Hello,
Im having some trouble creating a formula. I sell on Amazon and for all our products the minimum profit on all products i want is € 1,-.
Calculating profit from selling price is easy, but the other way it is not.
Basically i need to enter my cost price and the formula needs to calculate minimum selling price for € 1,-
The hard part for me is the added VAT, Commission and fulfillment fee.
VAT % on all products (on selling price) = 19.6%
Commission % on all products (on selling price) = 10.44%
Fulfillment FBA fee is constant = € 1.75
Underneath is an example for selling an item at cost 4,246 for 10,-.
Selling Price = 10
Cost Price = 4,246
VAT 19.6% = 1,96 (19.6% over 10)
Amazon Fee 10.44% = 1,044 (10.44% over 10)
FBA cost = 1.75
NETTO MARGIN = 1
Ive checked this thread and added excel but am to confused what to do.
http://www.excelforum.com/excel-gene...ing-price.html
Any help would be appreciated. Many Thanks.
Kiran
Bookmarks