# commission calculation

1. ### Commission Per Sale + Tiers

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%...
2. ### Cumulative tiered commission & exclude big deals from cumulative calc

<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...
3. ### Calculating Commission fees to create my selling price

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...
4. ### Bonus payout calculator based on units sold not percentage of cash

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...
6. ### Commissions Calculator

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...
7. ### Calculating Commission

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
8. ### Hierarchy Chart for a 1 x 2 matrix direct sell company possible in Excel?

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)...
9. ### Work backwards from desired commission amount to find sales volume

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...
10. ### VBA code calculate commissions

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 =...
11. ### Variable Commission Rate Calculations

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...
12. ### sales comissison formula

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%...
13. ### Commission formula help

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.