Calculate final sales price for a desired profit

Hello all and happy holidays,

I am trying to calculate the final sales price for Etsy sales over a desired profit price, but couldn't handle it. The problem is that commission rates are connected to each other and one changes, others change too. I could solve the problem when only one commission rate applied, but multiple commission rates are getting hard to get out of. Is there a magic way that when I enter purchase price from the supplier and shipping fee as costs (only those two), and the profit I want to have, populate all other fields and finally get the price that I should sell? I hope it is not complicated. Thank you.

Quote from alansidman

A sample worksheet would help to get a solution.

Added. Thank you very much. Normally, I can do this only for one commission rate: ( Costs Total * Commission Percentage ) / ( 1 - Commission Percentage ) gives me what I want to. However, in this case, same commission calculations are connected to each other.

Quote from r_hind

This is a case of getting the maths clear..

For example ...

Lets assume the selling price = 1.00 (or 100%) and the selling price = all costs and all commissions and the desired profit.

If thew desired profit = 25 cents in every dollar then the assumption is that costs and commissions are 75 cents and the markup % is 33%.

Are you able to calculate the total of costs and commissions THEN add your desired markup?

Of course ..if the commissions are based on the end selling price it is a little more complicated but the same rationalse applies and it may be necessary (but not good practice) to enable iterative calculations (Options / Formulas).

From a maths (algebra) perspective you should be able to apply the maths in either direction.

Let me know if I can help further.

Display More

Thank you. I will make a calculation.