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
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
CTC Calculator.xls