No Tags Found!


Arun Dhawal
2

Hello all
I want to calculate sales incentive for field force on monthly basis n I am already create targets, please create one incentive calculation format for me, our calculation criteria is:
if achieve 100% we give 3/- for 1 unit
if achieve 90% we give 2/- for 1 unit
if achieve 80% we give 1.5/- for 1 unit
Thanks in Advance
A.Dhawal

From India, Bhopal
nitesh_barman
82

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
Attached Files (Download Requires Membership)
File Type: xls Sales Incentive.xls (1.12 MB, 17877 views)

Arun Dhawal
2

Dear Nitesh Sir
Thanks for the Sheet Its helpful for me but can you insert slab wise incentive coz in the sheet calculate incentive only fix percentage like 80% 90%
but if any person achieve 85% or 81.5% then our sheet calculate 0/- incentive please do some about this
can you put formula for the same
like: if achieve under 79% calculate 0/-
If achieve 79.5 to 89.5% calculate 1/- per unit
If achieve 89.5 to 99.5% calculate 2/- per unit &
if achieve 99.5 to above then calculate 3/- per unit
please change some formula if possible..

From India, Bhopal
sathya-moorthy1
manufacturing employee incentive working excel pls
From India, Bengaluru
tarek-tarek
Dear can you help me to have an Incentive Scheme for Travel Agency staff to reach their target
From Egypt, Cairo
hussain-ak-shaikh
Hi Nitesh, I need help on the below as I am applying for a job and received an assessment.

Requirement is as below:
Cleaners earn a base bonus amount according to their status. Additionally, they earn a certain
amount for each 5-star rating they receive and they lose a certain amount for each 1 or 2 star
ratings they receive. And there are other constraints to be taken into consideration. You can see
them in the sheet named as Incentive Plan.

Attached is the excel with the details and I need to calculate incentives and bonus as per the above criteria.


From United Arab Emirates, Sharjah
Attached Files (Download Requires Membership)
File Type: xlsx Data Sheet - Quality Lead.xlsx (237.1 KB, 397 views)

virendra-rao
What is the incentive trend in manufacturing company these days ?
From India, Ahmedabad
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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.