Working out Minimum Amazon Selling Price

jamobe

New Member
Joined
Dec 23, 2014
Messages
36
Office Version
  1. 365
Platform
  1. Windows
Hi Guys

I'm hoping someone can help.

I have a spread sheet with all my products which include the purchase price, shipping costs and fees etc.

I have a column for the minimum sale price, and this needs to be the break even price after VAT @ 20%, amazon fees, packaging costs etc

Here is an example

A1 Purchase Price = £2.00
A2 Packaging cost = £0.05
A3 Shipping cost = £1.40
A4 Amazon Fee = 15%
A5 VAT = 20%


Is there a calculation that can factor in these costs to accurately determine the minimum selling price as to not lose profit. The VAT and amazon fee is charged on the final selling price.

There are other costs I would like to include but will add these on at the end of the calculation myself, it is just the above that I would like to get right before I factor anything else in

I really hope someone can help.

Thanks in advance
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
AB
1£2.00Purchase Price
2£0.05Packaging Cost
3£1.40Shipping Cost
4=0.15*SUM(A1:A3)Amazon Fee (15%)
5=SUM(A1:A4)*0.2VAT (20%)
6=SUM(A1:A5)Minimum Sale Price

<tbody>
</tbody>

For your example, I would have thought this would work.
 
Last edited:
Upvote 0
You could have provided a complete example with expected results.


Excel 2010
ABCDEFGH
1PurchasePackagingShippingCostVATAmazonProfitSelling
22.000.051.403.450.200.150.005.31
32.000.051.403.451.060.800.005.31
1d
Cell Formulas
RangeFormula
H2=(Cost+Profit)/(1-(VAT+Amazon))
D2=SUM(A2:C2)
D3=SUM(A3:C3)
E3=H3*VAT
F3=H3*Amazon
G3=H3-SUM(D3:F3)
Named Ranges
NameRefers ToCells
Amazon='1d'!$F$2
Cost='1d'!$D$2
Profit='1d'!$G$2
VAT='1d'!$E$2
z=zList!$A$2
 
Upvote 0

Forum statistics

Threads
1,213,517
Messages
6,114,089
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top