Margin Based Price Calculator

Written out

Price from a target margin is cost ÷ (1 − margin). It is the same relationship as the desired-margin calculation and it is worth repeating because it is the single most commonly botched formula in retail pricing.

The reason it is division: the margin is a percentage of the price you are solving for, not of the cost you already have. Anything expressed as a share of the unknown belongs in the denominator.

In practice

Cost $26.10, target margin 55%: price = 26.10 ÷ 0.45 = $58. Contribution is $31.90, which is 55% of $58.

The addition version gives 26.10 × 1.55 = $40.46, on which the margin is $14.36 ÷ $40.46 = 35.5%. Nearly twenty points of intended margin gone.

The gap scales with the target. At 65% the correct price is $74.57 and the addition version gives $43.07, which carries a 39% margin. Higher targets suffer worse, which means the products a business most wants to protect are the ones the error damages most.

The limitations

The target margin has to be one the business can actually live on. A 55% target that leaves nothing after advertising, fulfilment and overheads produces a price that hits its number and a business that does not.

The cost also has to be the full one. Invoice price rather than landed and fulfilled cost produces a price that achieves the target on paper and misses it in reality by whatever was excluded.

Putting it to use

Derive the target margin from the cost structure rather than choosing it. Add up advertising, fulfilment and overheads as shares of revenue, add the net margin you want, and the total is the gross margin the price has to deliver.

Build the formula into the pricing sheet with landed cost as an input, so a supplier price change automatically produces a new floor. Most catalogues drift out of margin because costs moved and prices did not.

A margin ladder for a mixed catalogue

A single target margin across a catalogue ignores that different products carry different downstream costs. A bulky item with heavy shipping and a high return rate needs a higher gross margin than a small light one to arrive at the same net.

The practical structure is two or three margin bands: a standard target, a higher one for products with above-average fulfilment or return costs, and sometimes a lower one for entry products that acquire customers.

Assigning products to bands takes an afternoon and prevents the most common structural pricing fault, which is a catalogue where the bulky low-margin items are quietly subsidised by the small high-margin ones, and where growth in the wrong half makes the business less profitable as it gets bigger.

The audit is easier than it sounds. Add a calculated margin column to the product export, sort ascending, and look at the bottom fifty. Products carrying 35% where their neighbours carry 55% are almost always the ones priced with the wrong denominator rather than the ones with genuinely worse economics.

Fixing them is usually a price rise of 20% to 40%, which sounds alarming until you notice these are products that have been selling at an unintended discount for years and whose volume reflects that. The volume tolerance arithmetic on a rise that large is generous.