Sales Compensation Formula

[datastudent]

Hi,

Please help me figure out the formula to compute the sales compensation with the below principle.

If the sales performance is 0-50%, compensation is 0.
If sales performance is 51-100%, compensation is 50% will be paid 0.1, 51% up to 100% will be paid 0.2.
If sales performance is 101% or more, compensation is 50% will be paid 0.1, 51% up to 100% will be paid 0.2, above 100% will be paid 0.3.

For example:

sales performance %	111.00%
actual sales performance	100
sales compensation payment	16.5
published sales budget	90
qouta performance 0-50%	0.1
qouta performance 51-100%	0.2
qouta performance 101%+	0.3

In manual computation:
90 / 2 = 45 (this is the 50%)
45 * .1 = 4.5
45 * .2 = 9
100 - 90 = 10 (this is the above 100%)
10 * .3 = 3
then 4.5 + 9 +3 = 16.5

 

[Fluff]

Duplicate to: Compensation Formula

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.