buddyosher
New Member
- Joined
- Jan 15, 2012
- Messages
- 31
I am looking for a way to pay a commission rate based on a sliding scale, where the sales amount spans 2 payout %.
(will not allow me to post picture, so I included dropbox link)
and payouts
Quota is $480,000 and it is easy to add up the sales and determine the payout %. What I do not know is to calculate a payout that spans 2 payouts.
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>For instance if quota is 480k and sales equal 735,330, is there a formula that would pay the first 244,795 @ 3.65, then 244,800-479,995 @ 6.77% etc?
(will not allow me to post picture, so I included dropbox link)
and payouts
Quota is $480,000 and it is easy to add up the sales and determine the payout %. What I do not know is to calculate a payout that spans 2 payouts.
1 | $ 480,000 | From | From | Available @% | Total Sales |
3.65% | 0% | 51% | $ - | $ 244,795 | $ 735,330 |
6.77% | 51% | 100% | $ 244,800 | $ 479,995 | Rate % |
10% | 100% | 150% | $ 480,000 | $ 719,995 | 15.00% |
15% | 150% | 500% | $ 720,000 | $ 2,400,000 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>