sliding sales commission

Hi there, I haven't used this forum for a while but I'm desperately in need of some help! I've been asked to put together a bonus calculator for a new bonus scheme at work. The scheme works like this; Assuming John hits his target i.e. D6 is greater than 0 then; - He gets 10% (D11) of the...

I need a Sliding Scale Commission table so I can figure out how to pay out based on the price. I've set this up as 3 tiers, but there could be 4. This is the closest thread I could find on the topic, but I couldn't get this to work for my situation: Sliding Commission Scale (I know its been...

Hi All, Currently working on something and need some assistance. assume we have a client with $700,000 of investments and we charge a percentage of that. I need the following to be calculated; First $250,000 @1% Next $250,000 to $500,000 at 0.70% The residual value of above $500,000 at...

Excel 2007 Windows 8.1 Hello everyone, and thank you in advance!!! I am creating a commission worksheet for my real estate agents so they can easily track their earnings for every deal. I have essentially found the solution (thanks to the second-half of a YouTube post from MrExcel), but do...

I am trying to set up a sliding commission scale for a nail salon. I really need help with the formula. sales between $1-$300 = 40% commission sales between $301-$500= 45% commission sales between $501-$700= 50% commission sales between $701-$900= 55% commission sales from $900 & up= 60%...

Hi, I am looking for help building a sliding sales commission excel template. I would like to be able to plug in sales and have it compute what the payout is. Details: Commission rate: 0-35% payout is 25% 36-75% payout rate is 30% 76+ payout s 40% Quarterly quota is $194,000 At 25% of...