Markup vs margin: the pricing mistake that quietly costs shops money

Markup is measured on cost, margin on the selling price. Mixing them up underprices every product.

· 5 min read

You buy a product for €1.00 and want to “make 40%”. If you add 40% to the cost, you sell at €1.40. But €0.40 is only 28.6% of €1.40. You wanted to keep 40 cents of every euro, and you keep 28.6. That gap repeats on every product in the shop.

The two formulas

  • Markup = (price − cost) ÷ cost. It answers: how much do I add to my cost?
  • Margin = (price − cost) ÷ price. It answers: how much of each sale do I keep?
The same €0.40 profit: 40% of the cost, 28.6% of the price.

Conversion table

To reach a margin, convert it to a markup once: markup = margin ÷ (1 − margin). For a 40% margin, 0.40 ÷ 0.60 = 66.7%, so €1.00 becomes €1.67.

Margin you wantMarkup to apply€1.00 cost sells at
20%25%€1.25
25%33.3%€1.33
30%42.9%€1.43
40%66.7%€1.67
50%100%€2.00

Which one to use

Most shops and wholesalers price from cost, so they apply a markup — that is fine, as long as the markup is chosen for the margin you need. Make sure the cost is the unit cost, not the case price, and that it includes your share of transport.

How SAMZY helps

In a Smart Sheet the markup lives in its own column, like 41%, and the price is a formula: cost × (1 + markup). SAMZY calculates both ways: type a new selling price and the markup updates to match, change the markup and the price follows. Use one markup column per price list — see retail, wholesale and restaurant prices in one sheet.

Questions

Is a 50% markup a 50% margin?
No. A 50% markup gives a 33.3% margin. To get a 50% margin you need a 100% markup: the price is double the cost.
How do I convert margin to markup?
Markup = margin ÷ (1 − margin). A 30% margin needs a 42.9% markup.