KimberlyWelty
New Member
- Joined
- May 10, 2016
- Messages
- 20
So, I am trying to determine how best to calculate Tie rates for a commission structure when I know what the total payout should be at 100% achieved? Here is a sample of the tier structures,
<colgroup><col><col><col></colgroup><tbody>
</tbody>The problem I am having is that if a person's quota is $3,000,000 and there total compensation needs to be $80,000 if they achieve 100%, how can I have it calculate the proper % earned in each category. I am sure there has to be a formula to do this. Any assistance would be greatly appreciated.
0.00% | 75.000% | 2.00% |
75.00% | 90.000% | 3.00% |
90.00% | 100.000% | 4.00% |
100.00% | 110.000% | 5.00% |
110.00% | 6.00% |
<colgroup><col><col><col></colgroup><tbody>
</tbody>