Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I need a formula to help calculate the commission for my team at work. We are collectors and take credit card payments to clear up delinquency. Here is how the tiers work:<o></o>
<o> </o>
$0 - $15,999 – 1% commission<o></o>
$16,000 – $19,999 – 3.75% commission<o></o>
$20,000 - $24,000 – 4.5% commission<o></o>
$25,000 – unlimited – 5.5% commission<o></o>
<o> </o>
The part I am having troubles with is, if you were to collect $35,000 – you would qualify for 5.5% on the whole balance. If you collect $22,000 – you would qualify for 4.5% on the whole balance. <o></o>
<o> </o>
Would anyone know how to calculate this for me? Any help would be appreciated. <o></o>
Thanks!! <o></o>
<o> </o>
I need a formula to help calculate the commission for my team at work. We are collectors and take credit card payments to clear up delinquency. Here is how the tiers work:<o></o>
<o> </o>
$0 - $15,999 – 1% commission<o></o>
$16,000 – $19,999 – 3.75% commission<o></o>
$20,000 - $24,000 – 4.5% commission<o></o>
$25,000 – unlimited – 5.5% commission<o></o>
<o> </o>
The part I am having troubles with is, if you were to collect $35,000 – you would qualify for 5.5% on the whole balance. If you collect $22,000 – you would qualify for 4.5% on the whole balance. <o></o>
<o> </o>
Would anyone know how to calculate this for me? Any help would be appreciated. <o></o>
Thanks!! <o></o>