We need to track our sales people's work, and below are the project requirements:
The application is to be developed in Microsoft Access. You are expected to use Access Tables to store data, Forms to present interface, and a few simple reports.
We have about 50 sales people, we need to keep track of each individual's sales record.
a. Let's say John Doe makes a $10,000 sale this month, his customer is expected to make payment of $6,000.
b. If the customer makes a payment less than $6,000, the sales person would be penalized; for example, if the customer only pays $4,000, the sales person would pay 10% of the difference, so it would be 20% * ($6,000 - $4,000) = $400. This penalty comes out of the sales person's monthly paycheck.
c. If the customer makes a payment greater than $6,000, the sales person would be rewarded; use above example, let's say customer pays $8,000, the sales person would be rewarded 20% * ($8,000 - $6,000) = $400. This reward would be included in the sales person's monthly paycheck.
d. Very importantly, above logic needs to be applied to each transaction. The reward and penalty is assessed every month, on each transaction. Whenever the customer makes a full payment for a transaction, that transaction is marked as Complete.
e. The interface should allow us to view and edit each sales person's transaction history, his rewards and penalties, the transaction history.
f. The report function should allow us to view transactions of different sales person for a specified date range.
g. The application should have the flexibility to change different variables, such as reward/penalty percentage, etc.
This is not a fancy or complex application, we are looking for a simple Microsoft Access application. Please bid accordingly.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
Microsoft Windows NT, 2000, Me, XP.