Formula for Markup from COGs

[infotokevin]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="width: 101"]Units[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 103"]
<tbody>[TR]
[TD="width: 103"]COGs (each)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="width: 101"]Total COGs[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 125"]
<tbody>[TR]
[TD="width: 125"]Desired Margin[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 235"]
<tbody>[TR]
[TD="width: 235"]Revenue (sell price) = COG/(1-m)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 152"]
<tbody>[TR]
[TD="width: 152"]Markup in percentage (?)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 101, align: right"]1,000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 103"]
<tbody>[TR]
[TD="class: xl66, width: 103, align: right"]5.00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl66, width: 101, align: right"]5,000.00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 125"]
<tbody>[TR]
[TD="class: xl66, width: 125, align: right"]40%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 235"]
<tbody>[TR]
[TD="class: xl65, width: 235, align: right"]8,333[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]what is the formula to determine what the markup would be to get a 40% margin?[/TD]
[/TR]
</tbody>[/TABLE]

The reverse would be; I would enter this markup to give me the 40% margin...

This may be obvious - I have been looking at this so long now I don't even know what month it is any more.... arrrrrgggghhh

Thanks up front for the assistance -

 

[shg]

The formula is described in your post -- sell price =COGS/(1-Margin)

=5000/(1-40%) returns 8333.33

 

[jsotola]

COG purchase price * 140% = COG selling price

 

[shg]

Sorry, I answered the wrong question. The markup of COGS to achieve a margin of 40% is

=1/(1-40%) - 1 ~ 0.667

 

[infotokevin]

Ah yes - this looks correct. I really appreciate the formula. In this example it works and makes sense - markup of .6666 works out to 40% margin.

I thank you and my battered and bruised brain thanks you as well...

Sorry, I answered the wrong question. The markup of COGS to achieve a margin of 40% is

=1/(1-40%) - 1 ~ 0.667

 

[infotokevin]

Ah yes - this looks correct. I really appreciate the formula. In this example it works and makes sense - markup of .6666 works out to 40% margin.

I thank you and my battered and bruised brain thanks you as well...

Oh no - something does not seem correct.

If I have COGs @ 5000 and with 40% margin have 8333 as sell price (revenue), then in your formula, which numbers represent the "1"?

=1 (?)/1(?)-40%) - 1 (?)

Thank you again...

 

[shg]

The 1 doesn't represent anything -- it just falls out of the algebra:

cogs + margin * sell = sell

therefore cogs = sell - margin * sell = sell * (1-margin)

So sell = cogs / (1 - margin)

Also,

sell = cogs * (1 + markup)

And from above,

sell = cogs / (1 - margin)

so cogs * (1 + markup) = cogs / (1 - margin)

therefore 1 + markup = 1 / (1 - margin)

So markup = 1 / (1 - margin) - 1

COGS and Sell are dollar amounts, margin and markup are percentages.