Calculate rate based on total sales

Calculate rate based on total sales

Post by paperbo » Sun, 29 Jun 2003 08:56:25



Steve..

SALES MON TUE WED THU FRI SAT TOTAL
A 5 7 5 8 9 6 40 $57.00
B 4 8 4 4 8 3 31 $34.50
C 1 3 2 8 2 4 20 $17.00

"TOTALS
by DAY" 10 18 11 20 19 13 91

For the first 45 sales (any combination), the salesperson makes $1.00
for each A,$0.75 for each B and $0.50 for each C.

Any sale over 45 (any combination), the salesperson makes $2.00 for
each A, $1.50 for each B and $1.00 for each C.

By the chart above, this person hit 45 on Thursday. 6 out of the A's
would be $1.00 each and the other 2 would by $2.00. Then the 4 B's and
8 C's would be at the higher comission along with all sales on Friday
and Saturday


First 45 comm Over 45 comm TOTAL TOTAL
SALES COMM
A 23 *1.00 $23.00 17 *2.00 $34.00
B 16 *0.75 $12.00 15 *1.50 $22.50
C 6 *0.50 $3.00 14 *1.00 $14.00

45 $38.00 46 $70.50 91 $108.50


I tried the suggestion in the previous reply and, although a bit
cumberson, it does work.It just gets a little funny when the comission
for their Supervisor is figured out because it's counted the same way,
only they have 6 salespeople each. The Supervisor is paid a lower rate
on the first 270 sales (6 salespeople * 45 each)and a higher rate for
all sales over 270. The funny part is when one of their salepeople
doesn't hit 45.


Thanks for your help

Johnny
 
 
 

Calculate rate based on total sales

Post by Ron Rosenf » Sun, 29 Jun 2003 11:34:03

On Fri, 27 Jun 2003 14:43:38 +0100, "Stephen Dunn"



Good pickup


--ron

 
 
 

Calculate rate based on total sales

Post by Ron Rosenf » Tue, 08 Jul 2003 00:09:25


I'm glad the calculations are working. But I don't understand your question.

What is the "it" that you want to recalculate?
What is not recalculating?

The columns that you show as Totals should refresh automatically if you just
use the SUM function.

The commission should also recalculate automatically if you have auto calc on
and you change a cell in the range.

Best,

--ron