We normally report sales as Total Goal & Total Digital Goal against Total Actual Sales & Total Actual Digital sales, weight both at 50% add them together then take that percentage and give a base percentage with an accelerator for any amount over. For example:
<tbody>
</tbody>
So for both line items you take the Goal/Actual = % to goal. Reduce that by 50% to get the weighted %.
Then add both of them together to get the weighted performance percent.
This number is then compared to a chart and a final payout % is calculated. This is the chart:
<tbody>
</tbody>
So, if the weighted performance % is 209.2% (as in the example) they would get a base of 100%, which leaves 109.2% to be calculated on the above chart. So for every percentage point above 100% they get an additional 2% so the total percentage to be paid out is 318.3%. In this example the commission paid out to the sales rep was $10,387.10, total.
The problem is that now corporate is wanting us to go back and break out what percentage of that payout amount is attributed to digital. I can't figure how in the world I will figure that out as we base the accelerator on the combined percentage. If you try to break them apart it doesn't work out.
Is there a way to figure the percentage of a percentage?
Goal | Actual | % to Goal | Measured Weight | Weighted % | Weighted Performance % | Payout% | Total Payout | |
Total Net Revenue | $32,787 | $51,730 | 157.8% | 50% | 78.9% | |||
Digital Net Revenue | $13,000 | $33,872 | 260.6% | 50% | 130.3% | 209.2% | 318.3% | $10,387.10 |
<tbody>
</tbody>
So for both line items you take the Goal/Actual = % to goal. Reduce that by 50% to get the weighted %.
Then add both of them together to get the weighted performance percent.
This number is then compared to a chart and a final payout % is calculated. This is the chart:
% to Plan | Incentive Payout % | Accelerator |
<70% | 0% | 0% |
70% | 40% | 1% |
80% | 50% | 1.5% |
90% | 65% | 3.5% |
100% | 100% | 0% |
110% | 120% | 2% |
120% | 140% | 2% |
>120% | 140% | 2% |
<tbody>
</tbody>
So, if the weighted performance % is 209.2% (as in the example) they would get a base of 100%, which leaves 109.2% to be calculated on the above chart. So for every percentage point above 100% they get an additional 2% so the total percentage to be paid out is 318.3%. In this example the commission paid out to the sales rep was $10,387.10, total.
The problem is that now corporate is wanting us to go back and break out what percentage of that payout amount is attributed to digital. I can't figure how in the world I will figure that out as we base the accelerator on the combined percentage. If you try to break them apart it doesn't work out.
Is there a way to figure the percentage of a percentage?