Calculation of Monthly Sales Commission

N

Nur Muhammad

Dear Friend:
I want to pay sales commission using the following system:
Designation Consolidated Salary Primary Target Rate per BDT 100,000
Target Fulfillment Non-Fulfillment
Trainee Sales 10,000 2,000,000 BDT 375 BDT 330
Sales Executive12,000 2,500,000 BDT 390
BDT 375
Senior Sales Executive15,000 3,500,000 BDT 420
BDT 390

So, if any sales person like Sales Executive sales Tk, 4,000,000 then his
commission will be 4,000,000/100000*390=Tk. 15600.
And Another sales person like, Senior Sales Executive sales Tk. 3,000,0000
then his commission will be 3,000,000/1000000*390= Tk. 11700
Pls help me who I can use this system using access
If you give a complete access demo file I will please

Thanks
Nur Muhammad
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top