Aug 28 2022 09:12 PM
Hello, I would like some help or advice in creating a calculation/formula within excel to figure profit/loss.
Its for Amazon FBA Fees. I have the number figures that Amazon uses for products in the "Book" category.
Fees Breakdown:
- Book Category Fee = 15%
- Closing Fee = $1.80
Ideally I'd like the formula to take my cost * 15% + 1.80 = X
Then I can take that figure (X) and subtract it from the price the product sold for
TIA
Aug 28 2022 10:18 PM
Hi @RKD2313
I am not sure if I understand you right, anyhow this is what I understood:
the formula should be like this ( I assume x is the sale price) x=cost * 15% + 1.80
then, a second formula should be: profit =sale prices- cost
check the file attached