Cost Markup Calculator

The underlying calculation

Markup is profit as a percentage of cost: (price − cost) ÷ cost. To apply one, price = cost × (1 + markup). Converting to margin: markup ÷ (1 + markup).

Markup multiplies because its base is the cost you already know. Margin divides because its base is the price you are solving for. That is the entire distinction and it is worth stating every time, because it is the source of more lost margin than any other arithmetic error in retail.

Worked through

Cost $26.10 with a 122% markup: price = 26.10 × 2.22 = $57.94. The margin is $31.84 ÷ $57.94 = 55%.

So a 122% markup is a 55% margin. Someone told to work on 55% who applies it as a markup prices at $40.46 and achieves 35.5%, a $17.48 shortfall on every unit.

Across a 200-product catalogue averaging 3,000 units a year each, that error is not a rounding issue. It is the difference between a business that works and one that does not.

Where it goes wrong

Markup percentages sound larger than the margins they produce, which flatters them in supplier and distributor negotiations. A quoted 60% markup is a 37.5% margin, and the gap is not obvious to anyone who has not done the conversion.

It also has no ceiling, which makes large markup figures hard to interpret. A 400% markup is an 80% margin, and neither number is wrong, but only one of them is comparable against your advertising and fulfilment ratios.

Making it useful

Convert everything to margin and keep the business in margin. Margin is comparable against every other percentage you track; markup is comparable against nothing, which is why it should live only at the boundary where suppliers use it.

Then audit the existing catalogue once. Where prices were set by different people over several years, some were set with the wrong denominator, and those products will show as unexplained low-margin outliers among their neighbours.

The conversions worth committing to memory

A 50% markup is a 33% margin. A 100% markup is a 50% margin. A 150% markup is a 60% margin. A 200% markup is a 67% margin. A 300% markup is a 75% margin.

Running the other way: a 30% margin needs a 43% markup, 40% needs 67%, 50% needs 100%, 60% needs 150%, 70% needs 233%.

The pattern is that markup rises without limit as margin approaches 100%, which is why the two diverge so sharply at the top end and stay close at the bottom. At a 10% margin the markup is 11% and the confusion costs almost nothing. At a 60% margin the markup is 150% and the confusion costs more than a third of the price, which is exactly why the error is most damaging on the products a business can least afford to underprice.

One habit that prevents the error permanently: never store a markup percentage in the pricing sheet. Store cost and target margin, calculate the price by division, and let the markup be a derived column that exists only for conversations with suppliers.

Where markup appears as an input, someone eventually applies it as a margin or the reverse, and the resulting price looks plausible enough that nobody checks it for years.