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.

    [SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
    Sir Arthur C. Clarke
    [/SIZE]

  • 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.

  • 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.

  • Thank you. I will make a calculation.

    [SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
    Sir Arthur C. Clarke
    [/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!