links or lookups?

[sammar12]

I have about 10 different suppliers each month who offer our 20 salesman incentives. Our salesmen our broken down into 6 different districts, but all are eligible for different goals for each suppliers incentive. I am looking for an idea of how to create
1. a master list with salesman results by supplier
2. a compilation list of information broken down by district
3. a list by supplier (and salesman information) for payroll purposes

The purpose is to have a worksheet for the supplier, one for the sales district, and one for payroll. But, I don't need the suppliers to see what the sales people are receiving from other suppliers and I don't need the salespeople seeing what people receive in other district.

[Richard Buttrey]

I have about 10 different suppliers each month who offer our 20 salesman incentives. Our salesmen our broken down into 6 different districts, but all are eligible for different goals for each suppliers incentive. I am looking for an idea of how to create
1. a master list with salesman results by supplier
2. a compilation list of information broken down by district
3. a list by supplier (and salesman information) for payroll purposes

The purpose is to have a worksheet for the supplier, one for the sales district, and one for payroll. But, I don't need the suppliers to see what the sales people are receiving from other suppliers and I don't need the salespeople seeing what people receive in other district.

Hi,

What's the nature of the incentive?

Do the suppliers set a minimum sales value target which is the same for each salesman?

What's the nature of the different goals for each suppliers incentive. i.e. how is this expressed - can you give some typical examples?

Is it a banded system where additional sums are given for sales above different taget levels, or is it a straightforward % of sales above target?

If you can provide some typical numbers and show examples of how bonuses are calculated with reference to those numbers, I'm sure we can come up with something.

Rgds