PRIME SPONSOR - FACTOHR - Customised Payroll, GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
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
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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.

Attached Files
Membership is required for download. Create An Account First
File Type: xls Sales Incentive.xls (1.12 MB, 15459 views)

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..
manufacturing employee incentive working excel pls
can you help me to have an Incentive Scheme for Travel Agency staff to reach their target
PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
Add Reply Start A New Discussion

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™