How Do I Create a Monthly Sales Incentive Calculation Format for My Team?

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

As far as I understand your need, I have created a spreadsheet for it, organized month-wise as well as providing a total for all months. I hope this will meet your requirements. If not, feel free to ask for more.

Regards.

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.

Dear,

Can you help me to create an Incentive Scheme for Travel Agency staff to help them reach their targets?