calculating percentage of sales

[Evie]

I get paid 2.0% of sales over 120%. or 225% of target.

My quota was $234,762; I achieved $353,419 (150.5%)

Payout at 120% equals 11,250

My question is how do I calculate 2% over the 120%?

Thank you in advance for your help!

E.

 

[tkhunny]

I get paid 2.0% of sales over 120%. or 225% of target.

My quota was $234,762;

100% ==> 234,762
120% ==> 234,792*1.2 = 281,751
225% ==> 234,792*2.25 = 528,282

Potential Subject to 0% Commission: 281,751
Potential Subject to 2% Commission: 528,282 - 281,751 = 246,531
Potential Subject to 4% Commission: SALES - 528,282

Is this close? Your description is a bit wandering about.

 

[Evie]

This is completely incoherent.
120% of what?
What is 225% of target? How does that differ from 125% of unknown?
What is the relationship between target and quota?
Payout? Is 11,250 what is in excess of 120%?

Try again. Remember that we are not looking at your book or your contract. You may have context. We have only what you give us.

Thank you and I apologize, Its very confusing for me too.

OK, let me try again..if I make my sales quota (234,762) that equals 100% of target and I would get paid $5,000.00.

The information below was supposed to be a table but didn't come out properly when I sent. First bolded text is first column, second column is slanted and third column is bold again.

Jan-Dec 2011 Sales as a %
of an-Dec 2011 Sales Quota Payout % of Target

100% 5,000 100
101 5,500 110
102 6,000 120
103 etc. to 6,450 129
120 11,250 225

My total sales at the end of the year was $353,419 which is 150.5% of quota. According to my payout schedule, if I make 120% of sales quota (and I did) I get paid $11,250.00. I got paid $12,505.00 so I'm trying to figure out how my manager arrived at that figure hence wanting to know the formula.

According to my information, I'm supposed to get paid 2.0% of sales over 120%

Does this make more sense?

Thanks again for your patients and help!

Eve

 

[Evie]

I get paid 2.0% of sales over 120%. or 225% of target.

My quota was $234,762;

100% ==> 234,762
120% ==> 234,792*1.2 = 281,751
225% ==> 234,792*2.25 = 528,282

Potential Subject to 0% Commission: 281,751
Potential Subject to 2% Commission: 528,282 - 281,751 = 246,531
Potential Subject to 4% Commission: SALES - 528,282

Is this close? Your description is a bit wandering about.

Actually, after looking at this I figured out how to get my answer. Thanks you SO much for getting me going.

 

[Evie]

This is completely incoherent.
120% of what?
What is 225% of target? How does that differ from 125% of unknown?
What is the relationship between target and quota?
Payout? Is 11,250 what is in excess of 120%?

Try again. Remember that we are not looking at your book or your contract. You may have context. We have only what you give us.

Thanks JeffM, I appreciate your response but I'm good now...