Need help to Create Incentive Calculation.
Slab
if sales rep achv min 72 unit will get @10 Rs.720 and will achv addition 50 get @20, Rs. 1000 Total Rs.1720 but if he will achv only 49 unit will get @10, Rs. 490 total Rs.1210
72 unit - @10 , Rs 720
49 unit - @10, Rs. 490 total 720+490=1210
but cross additional 50 get @20, Rs. 1000 and 72 will remain @10
total 720+1000=1720
From India, New Delhi
Slab
if sales rep achv min 72 unit will get @10 Rs.720 and will achv addition 50 get @20, Rs. 1000 Total Rs.1720 but if he will achv only 49 unit will get @10, Rs. 490 total Rs.1210
72 unit - @10 , Rs 720
49 unit - @10, Rs. 490 total 720+490=1210
but cross additional 50 get @20, Rs. 1000 and 72 will remain @10
total 720+1000=1720
From India, New Delhi
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.
CTC Calculator.xls