+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    06-14-2015
    Location
    calufornia usa
    MS-Off Ver
    not sure 2000?
    Posts
    2

    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
    Adam

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,229

    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?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    06-14-2015
    Location
    calufornia usa
    MS-Off Ver
    not sure 2000?
    Posts
    2

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 11-20-2014, 11:10 PM
  2. Replies: 3
    Last Post: 01-03-2013, 12:32 AM
  3. [SOLVED] Compare 1 price against multiple prices and change the price according to a formula
    By CharlieAziz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-16-2012, 11:05 AM
  4. Replies: 4
    Last Post: 08-15-2012, 09:49 AM
  5. Automatic calculation of cheapest unit price with bulk discounts
    By whirlwind1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-18-2011, 08:20 PM

Bookmarks

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