Price determined by Profit Margin

Hi all

I have created a spreadsheet (attached) to determine my Store Price based on what profit I set.

For example there are currently Four Columns.

Column A = Product price from my supplier
Column B = Store Price, i.e. the Price I will sell to end user - Formula: =(E2+0.2+A2)/0.966
Column C = Paypal Fees (20p + 3.4%) - Formula: =0.2+0.034*B2
Column D = Profit Required after all fees

This allows me to set the profit I require after all fees in Column D and works brilliantly. However I now need to add a 10% Commission Fee to the final Selling Price in Column B, but still receive the same profit from Column D after all fees.

I have hopefully explained this correctly. Can anyone help?

paypal equation.xlsx

Originally Posted by MarvinP

Hi Johnty and welcome to the forum,

Good news. Read this and then click on their tutorial. I think this is the exact tool you need.

http://www.solver.com/welcome-mac-us...ded-excel-2011

Thanks Marvin. I should have mentioned in the previous post that my excel skills are worse than a beginner. The formulas I have in the current spreadsheet were provided by others.

Originally Posted by newdoverman

I take it that you want to have the commission to be based on the selling price. This adds 10% to the original selling price.

Formula:

Please Login or Register  to view this content.

Thanks, does this add the paypal fees into the selling price twice? Could you possibly break down your answer for me?

Originally Posted by newdoverman

I take it that you want to have the commission to be based on the selling price. This adds 10% to the original selling price.

Formula:

Please Login or Register  to view this content.

Column A = £30
Column B = £43.50 Formula =(D3+0.2+A3)/0.966+(D3+0.2+A3)/0.966*0.1)
Column C = £1.68 Formula =0.2+0.034*B2
Column D = £8

When I do the following math, for example:
43.50/100*10 = £4.35 (Commission of 10%)

43.50 (Selling Price)
-4.35 (Commission)
-30 (Suppliers Price)
-1.68 (Paypal Fees)
= £7.47 (Profit)

I would need this to be £8, or whatever price I was to set in Column D, if possible. I have hundreds of products and rather than set each price individually I would need to put what my desired profit is into Column D and it would set the selling price in Column B.

Thanks for taking the time to help me.