Hi all,
It's been a couple of years since I've had to solve a problem like this, so I just need a little help simplifying this equation.
f(x,y) = .02x + .1xy
The equation represents sales comissions. For a given level of gross sales (x), a person earns 2% of that plus 10% of the profit on the gross sales (y). I'd like to reverse the equation so that given an input of the commission desired (f(x,y)) and the estimated profit margin (y), I can figure out what the gross sales need to be. This would go into an excel formula.
Basically, I need to solve for x. This could be done with either algebra or calc, if memory serves. But I can't remember how to do it.
Thanks for your help!
Mike
It's been a couple of years since I've had to solve a problem like this, so I just need a little help simplifying this equation.
f(x,y) = .02x + .1xy
The equation represents sales comissions. For a given level of gross sales (x), a person earns 2% of that plus 10% of the profit on the gross sales (y). I'd like to reverse the equation so that given an input of the commission desired (f(x,y)) and the estimated profit margin (y), I can figure out what the gross sales need to be. This would go into an excel formula.
Basically, I need to solve for x. This could be done with either algebra or calc, if memory serves. But I can't remember how to do it.
Thanks for your help!
Mike