Hey,
Looking for help with a formula to to work out a new commission plan in my work from looking at our actual total billed
The new structure is as follows. if I bill
$60,000 - $90,000 = 20%
$90,001 - $140,000 = 35%
$140,001 - $175,000 = 45%
$175,001 + = 50%
To clarify, 60k is threshold. If I bill between 60 -90k I get 20% of the value over 60k. I.e. if I bill 70k I get 20% of 10k = 2k.
Where it gets complex is working out the remaining teirs - If I bill say 145k I recieve 20% of $30k (difference between 60-90), 35% of 50k (differece between 90-140) and then 45% of 5k.
Is there a formula I could use to work out the above commission scheme to share with my team? Any help would be appreciated.
Thanks,
Michael
Bookmarks