Markup vs margin: the wholesale pricing math

The definitions, with one example

Take one product. It costs you $80.00 delivered to your warehouse, and you sell it for $100.00. The gross profit is $20.00. Now express that profit two ways:

• Markup = gross profit ÷ cost = $20.00 ÷ $80.00 = 25%.
• Margin = gross profit ÷ selling price = $20.00 ÷ $100.00 = 20%.

The profit is the same $20.00 in both cases. Only the base you divide by changes. Cost is always smaller than price when you make money, so markup is always a bigger percentage than margin for the same sale. A markup can be above 100% (a $10 part sold at $25 is a 150% markup). A margin can never reach 100%, because that would mean a cost of zero.

The formulas you need

The two conversions at the bottom are the ones to remember. A 25% markup gives 0.25 ÷ 1.25 = 20% margin. A 20% margin needs 0.20 ÷ 0.80 = 25% markup.

Markup to margin: what each markup really earns

This table starts from a $100.00 cost and shows what a given markup produces. Read across a row: the selling price, the gross profit and the margin you actually earn.

Margin to markup: what you must add to hit a target

If your target is a margin, go the other way. The table shows the price and the markup you need on a $100.00 cost to reach each target margin.

A 50% markup is not a 50% margin: it is a 33.33% margin. A 50% margin needs a 100% markup, which means selling at double the cost.

Worked examples

Example 1: pricing from a target margin. A part costs you $70.00 landed. Your target margin on this product class is 30%. Price = $70.00 ÷ (1 − 0.30) = $70.00 ÷ 0.70 = $100.00. Check: the profit is $30.00, and $30.00 ÷ $100.00 = 30%. The markup you applied was $30.00 ÷ $70.00 = 42.86%.

Example 2: the common mistake. The same $70.00 part, but the price clerk adds a “30% margin” as a 30% markup: $70.00 × 1.30 = $91.00. The profit is $21.00, and $21.00 ÷ $91.00 = 23.08% margin. The price is $9.00 short of the $100.00 you wanted, on every unit.

At the scale of a business the gap is large. Suppose your cost of goods sold is $280,000 a month. A true 30% margin sells that stock for $280,000 ÷ 0.70 = $400,000, a gross profit of $120,000. A 30% markup sells it for $280,000 × 1.30 = $364,000, a gross profit of $84,000. The difference is $36,000 a month, with no change in what you buy or sell. The figures are illustrative; the lesson is that the base matters.

Example 3: averaging margins across lines. A quote has two lines. Line A is $1,000.00 of sales at a 20% margin ($200.00 of profit). Line B is $3,000.00 at a 30% margin ($900.00 of profit). The margin of the quote is the total profit over the total sales: $1,100.00 ÷ $4,000.00 = 27.5%. Averaging the two percentages would give 25%, which is wrong, because the larger line carries more weight.

Why discounts cost more than they look

A discount comes off the price, not off the cost, so it comes straight out of your profit. Take the $100.00 product with an $80.00 cost, which earns a $20.00 profit at a 20% margin.

A 5% discount sounds small. On a 20% margin product it removes a quarter of the profit. This is why distributors keep tier discounts and quantity breaks inside a price rule that shows the margin each one leaves, rather than letting each salesperson decide line by line.

The same arithmetic applies when your costs rise. If the cost goes from $80.00 to $84.00, a 5% increase, and you keep the $100.00 price, the margin falls from 20% to 16%. To keep a 20% margin the price must go to $84.00 ÷ 0.80 = $105.00, a 5% rise. To keep the same $20.00 of profit per unit you would need only $104.00.

Which one should you use?

Neither is wrong. They answer different questions, so most distributors use both.

• Use markup to set prices from cost. Cost-plus rules, price matrices and supplier price files are naturally expressed as “cost plus X%” or as a multiplier on cost.
• Use margin to judge results. Financial statements, budgets, sales targets and commissions are normally expressed as gross margin on sales, because margin can be compared across products and added up to a business total.
• Always label the number. “30%” on its own could mean either. Write “30% markup” or “30% margin”, and make the heading of every price file say which it is.

In the UK, margin on sales is often called gross profit percentage, or GP%, and markup is written “mark-up”. The definitions are the same.

Using the formulas in a spreadsheet

If cost is in cell B2 and a markup is in C2, the price in D2 is =B2*(1+C2). If you work from a margin in C2 instead, it is =B2/(1-C2). To check a finished price, the margin is =(D2-B2)/D2 and the markup is =(D2-B2)/B2. Round prices to the cent with ROUND(…,2), and round the price rather than the percentage, so the number that reaches the customer is the one you tested.

The free price list template on this site calculates tier prices, markup and margin for you and flags lines that fall below a margin floor you set.

Common mistakes

• Applying a target margin as if it were a markup. This under-prices every product by the gap in the tables above.
• Calling a number “margin” when it is a markup in a price file, then comparing it with margin in the accounts.
• Averaging percentages across lines instead of dividing total profit by total sales.
• Using the supplier’s invoice price instead of landed cost, which hides freight, duty and handling.
• Giving a percentage discount without checking the margin it leaves.
• Not repricing when costs move, so a stable price slowly becomes a lower margin.
• Rounding the percentage instead of the price.

Checklist for setting a price

• Is the cost the landed cost, current as of today?
• Is the rule written as a markup or as a margin, and labeled that way?
• If a margin is required, has it been converted with cost ÷ (1 − margin)?
• Have the customer’s tier discount and the quantity break been applied in the right order?
• What margin does the lowest price leave, and is it above your floor?
• Has the price been rounded to the cent after the calculation?

Keeping the rules consistent when a quote has fifty lines

The arithmetic is not hard. The trouble is applying it correctly and the same way on fifty lines, under time pressure, for dozens of customers with different tiers. That is a job for rules held in one place rather than in people’s heads.

Qotora AI applies the price rules you define, such as customer tiers, margins and discounts, to the lines it finds in your own catalogue. Every price traces back to your own data. It can flag a line whose margin falls under a floor you set, and a person on your team reviews the quote before anything leaves.