Hi Folks, I badly need help to calculate quarterly incentives for my sales team in outdoor as well as in retail. I am really bad in excel scenario calculations, hence i am requesting for urgent help.
I have to allocate 2 criteria's for them to be able to qualify for incentives.
1st Criteria is Revenue & the 2nd Criteria is Gross Profit
Considering a sample case where a salesman needs to achieve a Revenue target of AED 10,500,000 & needs to make minimum 26% Gross Profit i.e AED 2,730,000. So if he does 100% of revenue target and get 26% GP...then he will be eligible for 0.02% incentive on GP value of 2,730,000 i.e AED 54,600
But now the conditions where i need help is if he does not fulfill one of the 2 criteria's what would be the incentive amount on the below conditions set for both the criteria's
<colgroup><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Please help. thanks in advance. need this urgent.
I have to allocate 2 criteria's for them to be able to qualify for incentives.
1st Criteria is Revenue & the 2nd Criteria is Gross Profit
Considering a sample case where a salesman needs to achieve a Revenue target of AED 10,500,000 & needs to make minimum 26% Gross Profit i.e AED 2,730,000. So if he does 100% of revenue target and get 26% GP...then he will be eligible for 0.02% incentive on GP value of 2,730,000 i.e AED 54,600
But now the conditions where i need help is if he does not fulfill one of the 2 criteria's what would be the incentive amount on the below conditions set for both the criteria's
Target Achievement | Payout | |
Revenue | 100% | 100% |
Revenue | 90%-99% | 60% |
Revenue | 80%-89% | 20% |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Target Achivement | Payout | |
Gross Profit | 100% | 100% |
Gross Profit | 90%-99% | 60% |
Gross Profit | 80%-89% | 20% |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Please help. thanks in advance. need this urgent.