Amazon eBay Pricing Formula

[theguyIsHere]

Hi everyone, I sell furniture on Amazon and need to be able to calculate the end ‘Sell price’ taking into account various cost factors which can change (in some instances)

E.g A chair’s cost price from supplier is £10 (including vat)

I want the formula to calculate a minimum profit of 25% after all costs or £5 (whichever is greater).
Costs include:

Amazon Fee: 17.5% of sale price
VAT: 20% of sale price
Shipping: £10 (static)

How can I formulate that in excel folks? Many thanks in Advance

 

[d'Holbach]

Product Cost	10
Amazon Fee: 17.5%	17.50%	on sales price
VAT	20%	on sales price
Shipping	10
Amazon Fees	9.33333345	=C2*C13
VAT amount	10.6666668	=C3*C13
Fixed Costs	20	=C1+C4
Total Costs	40.00000025	=SUM(C7:C9)
Percentage Margin	13.3333335	=C13*0.25
Fixed Margin	5	5
Sales Price	53.333334	53.333334
Check	2.5E-07	=C13-C10-LARGE(C11:C12,1)

<tbody>
</tbody>

I've used Solver to solve this by asking it to make Check cell as close to 0 as possible by manipulating Sales Price cell.

 

[theguyIsHere]

what formula did you get sales price and how do you tie that back to the 25% profit (or min £5)? it doesn't add up for me

 

[d'Holbach]

Sales price is not derived from a formula, it's a amount derived by Solver (as explained in my previous post).

What do you mean it doesn't add up, the calculation is as follows:

0~53.34-(53.34*62.5%)-20

62.5%= Amazon Fee + VAT + Margin