Commissions

I am implementing a new commission plan for my reps that has 4 levels of commssion. The reps get paid there commision on a monthly basis by sending me a spreadsheet of there total loans closed. I would like to have the spreadsheet set up so that the commission is calculated off the sum at the bottom of the page.

The levels are
$1 - 500,000
501,000 - 750,000
751,000 - $1,000,000
1,000,001 - $1,250,000

The commission paid factor is
.0005
.001
.0025
.0035
As they get to each level the commision amount would change to the next higher level
Is there an "if" statement or will it take more than that?

Any help much appreciated

WOW!! You are good.

How a bout this. We charge a $250 admin fee. Anything charged above 250 half goes to the rep, but any thing charged less than 250 the reps commision is reduced on a 5 to 1 ratio.

Is something like that doable with an if statement or does it have to go to VBA?


Thanks for your help on this

Hi,

My suggestion with all these variables would be to have them handy for changes ... just in case ...
Attached is a sample you can adjust to your needs ...

HTH
Carim

Yes the admin fee is in a different cell. The 250 is a base fee that is charged and the rep can raise or lower it.

2 examples
275 fee charged differce of 25 the repwould get paid 12.50
225 fee charged difference of 25 reps commision would be reduced by $5

Does that help?

Isn't that what is already happening in the Commission worksheet ?

Carim

Yes, I didn't see your response until after I replied. I am now going to work it into my commission log

See attached draft