IloveGronk
New Member
- Joined
- Jan 16, 2013
- Messages
- 1
Hi, I am looking for help building a sliding sales commission excel template.
I would like to be able to plug in sales and have it compute what the payout is.
Details:
Commission rate:
0-35% payout is 25%
36-75% payout rate is 30%
76+ payout s 40%
Quarterly quota is $194,000
At 25% of quarterly quota pays out (67,900*.25%)=$16,975
At 75% of quarterly quota payout is (145,500-67900*.30)=$23,280
Over 75% of quota payout is 40%
I would like to be able to plug in sales and have it compute what the payout is.
Details:
Commission rate:
0-35% payout is 25%
36-75% payout rate is 30%
76+ payout s 40%
Quarterly quota is $194,000
At 25% of quarterly quota pays out (67,900*.25%)=$16,975
At 75% of quarterly quota payout is (145,500-67900*.30)=$23,280
Over 75% of quota payout is 40%