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. Our calculation criteria are as follows:
- 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,
A. Dhawal
From India, Bhopal
Acknowledge(0)
Amend(0)
2I 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. Our calculation criteria are as follows:
- 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,
A. Dhawal
From India, Bhopal
Acknowledge(0)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(0)Amend(0)
From India, Jaipur
Acknowledge(0)Amend(0)
Dear Nitesh Sir,
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?
Here is the proposed 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(0)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?
Here is the proposed 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(0)Amend(0)
Dear can you help me to have an Incentive Scheme for Travel Agency staff to reach their target
From Egypt, Cairo
Acknowledge(0)Amend(0)
From Egypt, Cairo
Acknowledge(0)Amend(0)
Hi Nitesh, I need help with the below as I am applying for a job and have received an assessment.
The requirement is as follows: Cleaners earn a base bonus amount according to their status. Additionally, they earn a certain amount for each 5-star rating they receive and lose a certain amount for each 1 or 2-star rating they receive. There are other constraints to consider, which you can find in the sheet named Incentive Plan.
I have attached the Excel file with the details, and I need to calculate incentives and bonuses based on the criteria mentioned above.
Email: shaikh.mohd.hussain@gmail.com
From United Arab Emirates, Sharjah
Acknowledge(0)Amend(0)
The requirement is as follows: Cleaners earn a base bonus amount according to their status. Additionally, they earn a certain amount for each 5-star rating they receive and lose a certain amount for each 1 or 2-star rating they receive. There are other constraints to consider, which you can find in the sheet named Incentive Plan.
I have attached the Excel file with the details, and I need to calculate incentives and bonuses based on the criteria mentioned above.
Email: shaikh.mohd.hussain@gmail.com
From United Arab Emirates, Sharjah
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.