commission calculation

Hi, I would like a formula for a commission structure. Say C5 to C16 are months of the year with sales figures per month for which commission is paid. I would like the formula to work out the commission I would get each month. The end of the formula on months after January will then minus the...

Hello! I am trying to find a formula where, using a static book size (say $1550000) and dollars over goal (say 250000) it will return the % at which commission is applied & can then calculate the annual bonus. For the example this would be 4% as the book size is between $1.5m and $2m, and the...

Hi, I require a formula to work out a sales commission structure as a lot of online templates seem to be different structures. In a nutshell, when looking at the picture, I will require 5 of the same formulas which I can replicate which need to go into the cells in yellow in G2, G3, G4, G5 &...

Hi Guys, I was hoping you'd be able to help me with a formula to calculate monthly commissions for my team. My team are paid per sale with the amount of commission increasing at different tiers. 0-5 sales = $0 per sale 6-55 sales = $25 per sale 56+ sales = $50 per sale 55 would equal to 100%...

<tbody> Tier Rate Differential Rate 1 0 5% 5% 2 500,001 10% 5% 3 100,0001 15% 5% 4 1,500,001 20% 5% 5 6 Deal 1 Amount 1,000,000 7 Commission =sumproduct((A1:A4<B6)*(B5-A1:A4)*(C1:C4)) =75,000 </tbody> I have a tiered comm calculation using the above...

Hi, I know it's Monday and I keep hitting a wall to calculate my selling price. I am trying to come up with a selling price where I can factor in all my costs and still make a 10% profit. The problem is I pay a 15% hosting fee based on the selling price I list, I want to make sure I am...

Mr. Excel Forum, I have a sales team that gets paid based on units sold not dollars sold and then a percentage for bonus. I'm trying to figure out a formula that would allow them to track sales and see potential commissions. For basic math sake they need to sell 60 units a quarter. They only...

Hey everyone, I am trying to pull commission rates using a commission reference sheet which contains multiple criteria on the x axis and 1 criteria on the y axis. I have tried indexes, match functions, arrays, etc and cannot get it to pull a commission rate when both criteria from the x axis...

I would appreciate some help with automatically calculating commissions. How can I have it reflect a specific number when I have numbers within a field. ex 0 - 88 = 0% 89 - 97 = 50% 98 - 106 = 75% 107 - 115 = 100% 116 - 124 = 125% 125 - 133 = 150% 134 - greater = 200% This will only...

Hi I need help on formula to calculate commission in Excel Commission Scale 1-50 @$2 51-100 @$4 101- above @$6 For example if someone sell 161 units he/she gets $666 (50X2)+(50X4)+(61X6) if someone sell 71 units he/she gets $184 (50X2)+(21X4) Thank you Hattan

I am brand new to the forum and am no expert at excel. I have a MAC Excel 2011 program to work with. I have created a direct selling model that pays commissions based on percentages of sales. I also have partner companies I am working with plus the product distributor. The partner companies (2)...

I have a tiered commission structure that is laid out as follows: <tbody> Tier 1 $1 30% Tier 2 $5,000 35% Tier 3 $10,000 40% Tier 4 $15,000 45% Tier 5 $20,000 50% Tier 6 $25,000 55% Tier 7 $30,000 60% </tbody> The commission percent is retroactive to $1. For example: If you...

Status B & C: commission + 3% bonus ; Status A: commission only Status A is calculating correctly, but B & C is not. I'd appreciate any help with this. If StatusCode <> "A" Then Bonus = 0.03 Commission = CommissionRate * Bonus * SalesAmount Else Bonus = 1 Commission =...

I need a way to calculate commission for my sales reps. The commission is based off a calculated value in H39 of a sheet that I have developed. They get 7.5% of the value when between $1 - $100,000, example: sales of $50,000 = $3,750 in commission. If the value in H39 is > $100,000 but...

i will pay my sales person as following rates i need a formula to execute this from 1 to 1000000 6% from 1000000 to 1500000 7% from 1500001 to 2000000 8% from 2000001 to 2500000 9% from 2500001 to 3000000 10% from 3000001 to 3500000 11% from 3500001 to 4000000 12% from 4000001 to 4500000 13%...

I need a formula to calculate tiered commissions based on incremental sale numbers. For example, .5% for 0-25, .65% for 26-49, .75% for 50-99, .9% for 100-149, 1.0% for >150. Each sale commission is based on total value of each individual sale.