# need help with a formula for amazon price calculation for bulk price updating

1. ## need help with a formula for amazon price calculation for bulk price updating

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

2. ## Re: need help with a formula for amazon price calculation for bulk price updating

Hi, welcome to the forum

Are you sure you have your numbers correct here?
my cost is 10 and the weight is 5lbs I would need to sell the item for 8.94 to get a 16% profit
If you sell for ANYTHING less than 10 you are making a loss?

3. ## Re: need help with a formula for amazon price calculation for bulk price updating

yes if you look at the calculator that is how it works because the customer pays for shipping and my shipping cost is free so the more they pay for shipping the lower my sales price has to be in order to make a profit

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1