MHB Percentage in Commission Calculation Issue

  • Thread starter Thread starter mitsu
  • Start date Start date
  • Tags Tags
    Calculation
AI Thread Summary
The discussion centers on the confusion surrounding the calculation of employee commissions based on net income. The owner believes that commissions should be calculated after deducting the manager's pay as an expense, leading to a formula that appears to miscalculate the true net income. The proposed method results in a discrepancy, leaving an amount that the employee should also be entitled to, suggesting that the true net income is not accurately represented. The poster seeks clarity on whether the formula would remain consistent regardless of the commission percentage applied. The conversation highlights the complexity of calculating commissions when they are based on a net income that includes deductions for employee pay.
mitsu
Messages
1
Reaction score
0
I'm trying to figure out a formula for a pay plan, I think we are calculating things incorrectly but I can't seem to work out the right formula..

The idea is that an employee is paid a percentage of the business's net income, the owner believes that percentage should be after their pay is calculated, the theory being the managers pay is an expense, so the true net income of the business is net of his pay and that's the number pay should be calculated from...

they are proposing to do it like this...

net income - 100,000

pay plan - 25 percent

so they go 100,000 x 75 percent = 75,000

then pay the 25 percent from that number which is 18750.

Doesn't seem right to me since 75,000+18,750 = 93750

leaving an amount of 6,250 that the employee should be entitled to a portion of...

This seems wrong to me as the true net income is not 75,000, it is 81,750 with that formula...

Would the formula be the same no matter what percentage was being used ? (ie whether the employee pay plan was being calculated at 10 or 15 or 20 % )

Hoping someone can help me figure out (what I feel like) should be a simple formula...
 
Last edited:
Mathematics news on Phys.org
Looks to me that something like this is going on:

Income before commissions : A

Commissions : B

Net income: A-B

The weird part: B is calculated using a certain percentage
of (A-B), not on A alone.

If you want a reasonable answer, post your problem
reasonably clearly...guessing is not the way...
 
Here's an example of what I mean:
Code:
Gross income            96,800

Tax#1: 15% of Gross    -14,520 : 96800 * .15

Tax#2: 10% of Net      - 7,480 : 74800 * .10
                       =======
Net income              74,800
Calculation of Tax#2 a bit tricky, since Net income not known.
This'll work:

g = 96800

x = g * (1 - .15) = 96800 * .85 = 82280

n = x / (1 + .10) = 82280 / 1.10 = 74800

Tax#2 = x - n = 82280 - 74800 = 7480
 
Seemingly by some mathematical coincidence, a hexagon of sides 2,2,7,7, 11, and 11 can be inscribed in a circle of radius 7. The other day I saw a math problem on line, which they said came from a Polish Olympiad, where you compute the length x of the 3rd side which is the same as the radius, so that the sides of length 2,x, and 11 are inscribed on the arc of a semi-circle. The law of cosines applied twice gives the answer for x of exactly 7, but the arithmetic is so complex that the...
Is it possible to arrange six pencils such that each one touches the other five? If so, how? This is an adaption of a Martin Gardner puzzle only I changed it from cigarettes to pencils and left out the clues because PF folks don’t need clues. From the book “My Best Mathematical and Logic Puzzles”. Dover, 1994.
Back
Top