Hello all, I want to calculate sales incentives for the field force on a monthly basis. I have already created targets. Please create an incentive calculation format for me.
Incentive Calculation Criteria
- If achieving 100%, we give ₹3/- for 1 unit.
- If achieving 90%, we give ₹2/- for 1 unit.
- If achieving 80%, we give ₹1.5/- for 1 unit.
Thanks in advance,
Regards,
A. Dhawal
From India, Bhopal
Acknowledge(1)
Amend(0)
2Incentive Calculation Criteria
- If achieving 100%, we give ₹3/- for 1 unit.
- If achieving 90%, we give ₹2/- for 1 unit.
- If achieving 80%, we give ₹1.5/- for 1 unit.
Thanks in advance,
Regards,
A. Dhawal
From India, Bhopal
Acknowledge(1)Amend(0)
As far i understand your need, i have made a sheet of it, month wise as well as total of all months sheet. Hope, it will fulfill your need, if not can ask for more.
From India, Jaipur
Acknowledge(4)
Amend(0)
From India, Jaipur
Acknowledge(4)Amend(0)
Thank you for the sheet. It's helpful for me, but could you please insert slab-wise incentives? The current sheet calculates incentives based on fixed percentages like 80% or 90%. However, if a person achieves, for example, 85% or 81.5%, the sheet calculates 0 incentive. Could you please address this issue by adding a formula for the same?
Proposed Incentive Formula
- If achievement is under 79%, calculate 0 incentive
- If achievement is between 79.5% and 89.5%, calculate 1 unit
- If achievement is between 89.5% and 99.5%, calculate 2 units
- If achievement is 99.5% or above, calculate 3 units
Please consider modifying the formula if possible.
Thank you.
From India, Bhopal
Acknowledge(1)Amend(0)
Proposed Incentive Formula
- If achievement is under 79%, calculate 0 incentive
- If achievement is between 79.5% and 89.5%, calculate 1 unit
- If achievement is between 89.5% and 99.5%, calculate 2 units
- If achievement is 99.5% or above, calculate 3 units
Please consider modifying the formula if possible.
Thank you.
From India, Bhopal
Acknowledge(1)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
PF Calculation format.xls
Kra format.doc