Calculating Mark Ups with percentages

[john.warren414]

Hi, I have some trouble understanding something I will post an example below

The cost of something is 13.25 I need to calculate different tiers of cost mark up.

COG	50%​	31%​	20%​	23%​
13.25​	$ 26.50	$ 19.20	$ 16.56	$ 17.21

What is the formula to calculate these? I am trying to write a formula for excel to auto calc when I Pull to the COGS of something but do not know how they arrived at these numbers

 

[Deleted member 4993]

Hi, I have some trouble understanding something I will post an example below

The cost of something is 13.25 I need to calculate different tiers of cost mark up.

COG	50%​	31%​	20%​	23%​
13.25​	$ 26.50	$ 19.20	$ 16.56	$ 17.21

What is the formula to calculate these? I am trying to write a formula for excel to auto calc when I Pull to the COGS of something but do not know how they arrived at these numbers

13.25/(1-0.5) = 26.5

13.25/(1-0.31) = 19.20

13.25/(1-0.2) = 16.56

there .......

 

[JayJay]

Are you sure that mark up should be calculated as a percentage of selling price rather than cost price?

 

[Deleted member 4993]

Are you sure that mark up should be calculated as a percentage of selling price rather than cost price?

COG is generally cost of goods.

 

[JayJay]

COG is generally cost of goods.

Yes, I realise that. My point is that 50%, 31%, 20% and 23% are the percentages of the selling price. I wonder whether this reflects the definition of "mark up" that John Warren should be using. That's a!l I have to say.

 

[Dr.Peterson]

Yes, I realise that. My point is that 50%, 31%, 20% and 23% are the percentages of the selling price. I wonder whether this reflects the definition of "mark up" that John Warren should be using. That's a!l I have to say.

SK's answer fits the numbers provided; the question was, "What is the formula to calculate these?", presumably meaning the numbers shown.