Hello, I have been racking my brain for a few days trying to figure this out so I figured I'd come here for expert help.
I will be selling on amazon and need to figure out a formula for excel so i can upload my pricing easily and accurately
I know the values for the items below and for the sake of simplicity I put cell locations in ()
item cost (a1)
item weight(b1)
if you go to this page https://salecalc.com/amazon it is an actual calculator for single items.
I want to operate on 16% profit margins so according to the calculator if i have an item that my cost is 10 and the weight is 5lbs I would need to sell the item for 8.94 to get a 16% profit because of the shipping credit. I am stuck trying to incorporate that shipping credit into the formula which is where i need help.
the shipping credit is a flat 4.95 then .50 for each pound so the heavier the item the lower the sales price would be to earn 16% for example if the item above weighed 10lbs i would have to sell it for 6.44 to earn 16%
also the amazon flat fee is 15% which also includes the shipping credit value
hopefully that makes sense
so far the best i could come up with is the following formula =(a1*0.31)+(a1+(b1*.5))*0.15+(a1+(b1*.5)-4.49) which is close when the item is 1lb however as the weight goes up the value also goes up when it should be going down.
thank you
Adam
Bookmarks