Amazon jewelry fee help

[anand3000]

Hi,

Amazon jewelry fee schedule is as follows:

20% for the portion of the total sales price up to $250.00, and
5% for any portion of the total sales price greater than $250.00

I want to know how to formulate this in excel.

For example, if cost to acquire an item is $350 and I want to have a profit of $100 then I need to sell for $513.16 and the fee is 63.16.

I want to know how to calculate the "for sale price", salecalc.com does this but I cannot do 1 by 1 on the website. I am sure it can be done with a formula that be used on excel to popular sale prices based on cost to acquire and desired profit.

Any help would be greatly appreciated, thank you.

[6StringJazzer]

The calculations are attached. Note that the table in G:I is required for the calculations. This makes things easier if Amazon changes their fee structure.

[anand3000]

Thank you!!

[6StringJazzer]

You're welcome!

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.