ClaireGoode
New Member
- Joined
- Jan 6, 2017
- Messages
- 13
Good morning all. I am new to this forum so hope that this makes sense to you!
I am trying to work out a commission/bonus model and want Excel to provide me with how much commission we should pay based on certain criteria - which includes a capped amount. We have 2 potential models to work with.
Example;
<tbody>
</tbody>
<tbody>
</tbody>
Any help here would be greatly appreciated. I suspect I have attempted to make this harder than it needs to be and maybe I cannot see the simple solution!
Many thanks,
Claire Goode.
I am trying to work out a commission/bonus model and want Excel to provide me with how much commission we should pay based on certain criteria - which includes a capped amount. We have 2 potential models to work with.
Example;
Sample No. of Units | 8,000,000 | |
Sample Commission | £1,500 | |
MODEL 1 | ||
Base Units | 2,000,000 | The min units under which no Bonus applies |
Step | 250,000 | The steps/graduations in the units that apply to the Bonus scheme |
Step Bonus | £250 | The bonus that applies for each step or graduation that is achieved |
Cap | 10,000,000 | The cap that applies to the units, beyond which no additional Bonus is payable |
ANSWER | Help here please! | |
MODEL 2 | ||
Base Units | 3,000,000 | The min units under which no Bonus applies |
<tbody>
</tbody>
Step | 250,000 | The steps or graduations in the units that apply to the Bonus scheme |
Step Bonus | 10.0% | The bonus that applies for each step or graduation that is achieved |
Cap | 20,000,000 | The cap that applies to the units, beyond which no additional Bonus is payable |
ANSWER | Help here please! |
<tbody>
</tbody>
Any help here would be greatly appreciated. I suspect I have attempted to make this harder than it needs to be and maybe I cannot see the simple solution!
Many thanks,
Claire Goode.