Retail Price Calculator

The maths behind it

Retail price from a cost and a target margin is cost ÷ (1 − margin). Retail price from a cost and a markup is cost × (1 + markup). Which you use depends on which figure your business works in, and mixing them is the most common pricing error in retail.

Where the price has to include tax, there is a further step: the calculated figure is the tax-exclusive price, and the shelf price is that times one plus the tax rate. Setting the shelf price from the margin calculation directly gives away the tax.

In practice

Cost $22, target margin 55%. Tax-exclusive retail is $22 ÷ 0.45 = $48.89. With 20% VAT the shelf price is $58.67, and rounding to a charm point gives $58.99.

Check the rounding: at $58.99 the VAT-exclusive price is $49.16, cost is $22, and the margin is 55.2%. The rounding added a fifth of a point rather than costing anything, because it rounded up.

Rounding down to $57.99 instead would give a VAT-exclusive $48.33 and a 54.5% margin. Half a point lost on every unit for a dollar off a price nobody was comparing.

The limitations

It gives a price that satisfies your margin requirement and says nothing about whether anyone will pay it. Where the calculated retail price sits well above the market, the calculation is telling you the cost base is wrong.

It also assumes the cost is complete. A retail price built from an invoice price rather than a landed and fulfilled cost hits its margin on paper and misses it by whatever was excluded, which on imported goods is commonly a third.

Putting it to use

Round up rather than down when moving to a charm price. The difference is a few cents to the customer and a permanent margin gain to you, and nobody is comparing your price against the unrounded figure they never saw.

Then check the price against the range. A catalogue where retail prices were each calculated independently often has an incoherent ladder, three products at $58.99 and a fourth at $61.47 for no reason a customer can see. Prices should look deliberate as a set, not just correct individually.

Building a price architecture rather than prices

Customers judge a price against the other prices around it far more than against any absolute standard. A range priced at $29, $59 and $99 reads as a deliberate ladder; the same products at $31, $57 and $104 read as arbitrary, and the arbitrariness itself undermines confidence in all three.

The practical method is to set a small number of price points for the range, perhaps four or five, and fit products to them, rather than calculating each product's price independently and accepting whatever comes out. Products that do not fit any point are either repositioned, respecified, or priced at the nearest point with the margin difference accepted.

This also makes the good-better-best structure work. A range with a clear entry, middle and premium tier sells more of the middle than a flat range sells of anything, because the tiers give the customer a way to decide. Independent per-product pricing rarely produces that structure by accident.