madmansgates
New Member
- Joined
- Jul 2, 2010
- Messages
- 8
Hi,
Is there a way of getting excel to work out monthly commission on the following basis:
Commission rates:
0 - 20,000 - 10%
20,001 - 40,000 - 15%
40,001 - 60,000 - 20%
60,001 - 25%
In any 3 months commission is paid monthly depending on sales per month over 3 months commision hurdle.
eg: Month 1 Sales of 15k is 15k@10%=1500 commission
Month 2 sales of 20k will have commision of 5k@10%(to reach 20k hurdle) and 15k@15% =total of 2750,
Month 3 sales of 10k will have commission of 5k @15% (40k hurdle) & 5k at 20% total of 1750
Any help would be appreciated
Thanks
Is there a way of getting excel to work out monthly commission on the following basis:
Commission rates:
0 - 20,000 - 10%
20,001 - 40,000 - 15%
40,001 - 60,000 - 20%
60,001 - 25%
In any 3 months commission is paid monthly depending on sales per month over 3 months commision hurdle.
eg: Month 1 Sales of 15k is 15k@10%=1500 commission
Month 2 sales of 20k will have commision of 5k@10%(to reach 20k hurdle) and 15k@15% =total of 2750,
Month 3 sales of 10k will have commission of 5k @15% (40k hurdle) & 5k at 20% total of 1750
Any help would be appreciated
Thanks