Okay here's what i need...this may be difficult to explain
I'm figuring out a new commission structure. if you hit 103% of plan you get $1000...any percentage above that goes as this...110% would equal = $1100. Then take the 110% minus the 103% which gives you 7%. Take 7% x 2 = 14%. Take 14% of $1000 and add to the original $1100. So the example of 110% would be...$1100 + 140 = $1240.
I know it's confusing...I'm trying to put this in excel...so everyone can automatically track their payout...can anyone help...?
Thanks...
I'm figuring out a new commission structure. if you hit 103% of plan you get $1000...any percentage above that goes as this...110% would equal = $1100. Then take the 110% minus the 103% which gives you 7%. Take 7% x 2 = 14%. Take 14% of $1000 and add to the original $1100. So the example of 110% would be...$1100 + 140 = $1240.
I know it's confusing...I'm trying to put this in excel...so everyone can automatically track their payout...can anyone help...?
Thanks...