Calculating selling price from minum profit. VAT+ Commission on selling price.

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

I'm a bit confused as to what you are trying to do.

if you could post up a spreadsheet with desired results I can try and write a formula to accomplish the task.