Sales Commission

[Nur Muhammad]

Dear Friends:
I want to update my database and for that I interest to include a sales
commission report
There are the following criteria:
Comm for Comm for
Designation Primary Target Target
Fulfillment Non-fulfillment
Trainee Sales Executive 2000000 375 330
Sales Executive 2500000 390 375
Senior Seals Executive 3500000 450 390

Under the above criteria, if any sales officer achieve his/her target then
he avail target fulfillment commission rate per 100000.
For example, Mr. X is a Sales Executive and achieves 4,500,000 for the
December, 2009, so he avail Tk 390 per 100,000 and commission will be
4,500,000/100,000*390= Tk. 17,550.

Pls answer me as soon as possible and it will be better, if you give me a
Demo database to solve this problem. My e-mail address: (e-mail address removed)

Thanks

Nur Muhammad

 

[Piet Linden]

Dear Friends:
I want to update my database and for that I interest to include a sales
commission report
There are the following criteria:
                                                  Comm for       Comm for
Designation                        Primary Target      Target
Fulfillment     Non-fulfillment
Trainee Sales Executive 2000000     375         330
Sales Executive         2500000     390                         375
Senior Seals Executive  3500000     450         390

Under the above criteria, if any sales officer achieve his/her target then
he avail target fulfillment commission rate per 100000.
For example, Mr. X is a Sales Executive and achieves 4,500,000 for the
December, 2009, so he avail Tk 390 per 100,000 and commission will be
4,500,000/100,000*390= Tk. 17,550.

Pls answer me as soon as possible and it will be better, if you give me a
Demo database to solve this problem. My e-mail address: (e-mail address removed)

Thanks

Nur Muhammad                    

Oh please. If you want someone to do the work for you PAY FOR IT.
What's the matter, not smart enough to figure out a simple IIF
statement?

 

[Dale Fye]

Withought knowing the structure of your data tables, this is extremely
difficult, so why don't you post the names of the tables, the fields you
think are appropriate, and what you already have. I would suspect you would
have an Employees table, a Sales table, and this SalesCommissions table, as
a minimum. I would probably also have an EmployeeHistory table(or something
like that), which contains EmpID, their designation (Trainee, Sales Exec,
Senior Sales Exec, ...), and the date of that designation.

I would probably start out with an query (qryMonthlySales), which would give
me the total sales for each employee, by month. This query would include
the EmpID, SalesYear, SalesMonth, as TotSales.

I would then use that query, along with the EmployeeHistory table and the
SalesCommission table to determine the commission for each employee. By
including the EmployeeHistory table, you can the Sales query to the History
table to determine what their designation was in any given month, and then
use the appropriate commission rate from the SalesCommission table.

HTH
Dale