Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating sales commission that changes based on a sales volume
I have a 7 tiered sales volume grid and the commission paid per thousand
changes at each tier. EG: 0 - 1.5M $3.00 per K 1.6 - 2.5 M $4.00 per K 2.6 - 4.0 M $5.00 per K and so on - for 7 tiers worth of numbers - the last one being at $10 per K. What formula and/or function can I use to calculate the correct amount of commission, at the correct tier level knowing that a payment could include commissions from 2 consecutive levels. Each year a sales agent remains under contract, the next year's grid changes slightly for that person in that the rate per $K skips a level giving that agent more money. (Eg at year 2, pay $4 for both tier 1 & 2, then year 3 - pay $5 for tiers 1, 2 & 3). I also have several sales reps to keep track of using the same graduated volume grid. Thank you for any help you can provide. -- Elbowes |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating sales commission that changes based on a sales volume
Follow this link:
http://www.mcgimpsey.com/excel/variablerate.html for some worked examples. Hope this helps. Pete On Jun 7, 1:08 am, Elbowes wrote: I have a 7 tiered sales volume grid and the commission paid per thousand changes at each tier. EG: 0 - 1.5M $3.00 per K 1.6 - 2.5 M $4.00 per K 2.6 - 4.0 M $5.00 per K and so on - for 7 tiers worth of numbers - the last one being at $10 per K. What formula and/or function can I use to calculate the correct amount of commission, at the correct tier level knowing that a payment could include commissions from 2 consecutive levels. Each year a sales agent remains under contract, the next year's grid changes slightly for that person in that the rate per $K skips a level giving that agent more money. (Eg at year 2, pay $4 for both tier 1 & 2, then year 3 - pay $5 for tiers 1, 2 & 3). I also have several sales reps to keep track of using the same graduated volume grid. Thank you for any help you can provide. -- Elbowes |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating sales commission that changes based on a sales vol
At first glance - it looks like it meets most of my requirements. I'll have
a go at it and hopefully I won't need to disturb you again. Thank you very much and regards, -- Elbowes from Montreal "Pete_UK" wrote: Follow this link: http://www.mcgimpsey.com/excel/variablerate.html for some worked examples. Hope this helps. Pete On Jun 7, 1:08 am, Elbowes wrote: I have a 7 tiered sales volume grid and the commission paid per thousand changes at each tier. EG: 0 - 1.5M $3.00 per K 1.6 - 2.5 M $4.00 per K 2.6 - 4.0 M $5.00 per K and so on - for 7 tiers worth of numbers - the last one being at $10 per K. What formula and/or function can I use to calculate the correct amount of commission, at the correct tier level knowing that a payment could include commissions from 2 consecutive levels. Each year a sales agent remains under contract, the next year's grid changes slightly for that person in that the rate per $K skips a level giving that agent more money. (Eg at year 2, pay $4 for both tier 1 & 2, then year 3 - pay $5 for tiers 1, 2 & 3). I also have several sales reps to keep track of using the same graduated volume grid. Thank you for any help you can provide. -- Elbowes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for determining sales commission | Excel Worksheet Functions | |||
Sales V Commission updated calculation | Excel Discussion (Misc queries) | |||
Sales V commission | Excel Worksheet Functions | |||
Sales Commission calculations | Excel Worksheet Functions | |||
sales commission template | Excel Discussion (Misc queries) |