commission calculation

  1. T

    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. C

    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. Y

    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. S

    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...
  5. S

    Excel: Commission rates using multiple criteria in separate cells - PLEASE HELP

    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. J

    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. H

    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. M

    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. C

    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. D

    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. S

    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. R

    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. K

    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.

Some videos you may like

This Week's Hot Topics

Top