Hi...
I need a formula for incentive caliculations for the consultants who sells cars, as below slab plz help me
con Tgt Ach incentive
srinu 7 8 114%
7 7 100%
7 6 85%
7 5 71%
among the 7 vehicles Target he may sell various vehicles like x vehicle, y vehicle, z vehicle and individually each & every vehicle is got its own incentive amount like for x-1000, y-500, z-350.
so please guide me how can i procceed towards this caliculations.
I need a formula for incentive caliculations for the consultants who sells cars, as below slab plz help me
con Tgt Ach incentive
srinu 7 8 114%
7 7 100%
7 6 85%
7 5 71%
among the 7 vehicles Target he may sell various vehicles like x vehicle, y vehicle, z vehicle and individually each & every vehicle is got its own incentive amount like for x-1000, y-500, z-350.
so please guide me how can i procceed towards this caliculations.