Markup

[AbrahamGluck]

Hi as an employee of an Amazon business, I want to make a listing on amazon.

How can I calculate a markup of 10% in excel? - the markup is “on the cost of the item plus the fee amazon takes after the item being sold” which is a percentage of the listing/sale price? Is it possible to have an exact furmola for that?

 

[jproffer]

Maybe:

1.1*(A1 * (1+amazon %))

Where A1 is your original price. Amazon % is a constant that you need to enter into the formula.

If you had some real numbers to apply, it would be easier to test a solution, but I think that would do what you want.

 

[AbrahamGluck]

Maybe:

1.1*(A1 * (1+amazon %))

Where A1 is your original price. Amazon % is a constant that you need to enter into the formula.

If you had some real numbers to apply, it would be easier to test a solution, but I think that would do what you want.

Thank you for your response,
Please take a look on my sheet with the furmola https://www.dropbox.com/s/ufdvlyirkcuiwwo/Amazon Markup.xlsx?dl=0

I tried to use the furmola but it doesn’t sound right or I didn’t express myself in the question in the first place,

To rephrase the question,
I want to stay with a 10% markup after selling it and taking off the amazon fees,
You can also look on the amazon fees like sales tax, let say I want to have a net 10% markup after taking off the sales tax.

 

[jproffer]

So if the original price is $10 amazon fees are $1....do you want to make (on mark up) $1 (based on the $10) or $1.10 (based on $11)?

 

[AbrahamGluck]

So if the original price is $10 amazon fees are $1....do you want to make (on mark up) $1 (based on the $10) or $1.10 (based on $11)?

Amazon fees isn’t based on the original price, it is based on the selling price.
but to make a selling price I have to know the amazon fees
one is based on one another, it could be it is impossible to have a furmola

 

[jproffer]

Nothing is impossible. I think I'm understanding now.

Give me a few with your workbook so I can see real numbers, and I'll get back here.

 

[jproffer]

Didn't take as long as I thought, or I would have just did it before the last post.

Try this in C2, and see if you get what you expect.


=(A2+(B2*A2))/0.9

 

[AbrahamGluck]

Nothing is impossible. I think I'm understanding now.

Give me a few with your workbook so I can see real numbers, and I'll get back here.

I guess it is an algebra equation,

amazon is x percent of the markup

the markup is x percent of the cost plus the Amazon fee

you need to know the sales price in order to know x percent of amazon and you need to know the percent of Amazon in order to know sales price.

 

[jproffer]

Something like that. Did you try that formula? Is that what giving you the results you expect?

 

[AbrahamGluck]

Something like that. Did you try that formula? Is that what giving you the results you expect?

YES!
I really appreciate that, thanks so much for your help.