I work in sales… There is a need for me to quickly calculate prices based on the commission I will be getting. Each sale pays commission based on 2 values: First, the commission on the base price is 8%. Anything over the base price of the item is paid at 40%. However, you will never earn more than 24% of the entire sale price.

For instance, if the base price is $5000, and the item is sold for 7000$, then you would receive 5000*.08 or $400 and then 2000$ * .4 or $800 for a total commission of $1200. I basically need to know what I should be charging based on a commission value; for instance, If I want to make $1000, and the base price is 3000$, then I would need to charge 1900 over the base price to receive a commission of (3000*.08) + (1900*.4) to get 240+760=1000

I am asking if someone could write an algebraic equation for this instance so that I could plug in the commission amount and get the price I need to charge.

My brain is not working today, hopefully you can give me some insight.

Thanks

I tried to work it out and could not come up with the variables in a single equation.