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%...
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.
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
101- above @$6
if someone sell 161 units he/she gets $666 (50X2)+(50X4)+(61X6)
if someone sell 71 units he/she gets $184 (50X2)+(21X4)
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:
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
Bonus = 1
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.