Hong Life CalculatorsUnderstanding the volume discount margin calculator — concept and principle
This calculator shows what a volume discount really does to the profit on an order: the profit after the discount, the profit you would have made at list price, the margin left on the discounted price, and how many extra units you would have to sell to earn the same profit as without the discount. Sales teams and small businesses use it before agreeing to bulk pricing. It works with any currency; the example uses US dollars.
How it is calculated
- Discounted price = list price × (1 − discount).
- Order profit = (discounted price − unit cost) × quantity.
- Profit without discount = (list price − unit cost) × quantity.
- Margin after discount (%) = (discounted price − unit cost) ÷ discounted price × 100.
- Extra units needed to match = profit without discount ÷ (discounted price − unit cost) − quantity.
The principle
A discount comes entirely out of your margin, not out of your cost. If a product earns $8 on a $20 price, a 10% discount removes $2 per unit, which is a quarter of the profit, not a tenth. That is why the volume needed to make up for a discount grows quickly: you must sell enough extra units at the thinner margin to replace the profit given away. The calculation assumes unit cost stays the same at higher volume; in reality, bulk purchasing or production may lower it.
Worked example
- Discounted price = $20 × 0.90 = $18; margin per unit = $18 − $12 = $6.
- Order profit = $6 × 500 = $3,000.00.
- Profit without discount = ($20 − $12) × 500 = $4,000.00.
- Margin after discount = $6 ÷ $18 = 33.33%.
- Extra units = $4,000 ÷ $6 − 500 = 166.7, shown as 167.
How to read the result
Here a 10% price cut requires about a third more volume (667 instead of 500 units) just to stand still. Grant the discount only if it truly brings that extra volume, or if it wins a customer whose future orders are worth it. If the extra-units figure is negative or the margin after discount is near zero, the discount is too deep for this cost.
Common mistakes
- Thinking a 10% discount costs 10% of profit.
- Confusing margin (profit ÷ price) with markup (profit ÷ cost).
- Ignoring extra costs of large orders such as freight or payment terms.
- Offering the discount to customers who would have bought the volume anyway.
Frequently asked questions
What discount can I afford?
Keep the discount below your margin percentage, and check that the extra volume you expect is at least the "extra units needed" figure.
Why does profit fall by more than the discount percentage?
The price falls 10%, but the whole $2 cut comes out of the $8 profit, so profit per unit falls 25%. The margin percentage drops from 40% to 33.33%.
Is a free unit better than a discount?
A "buy 10, get 1 free" deal costs you the unit cost of the free item, not its price, so it is often cheaper than an equal-value discount.
Sources: Thomas T. Nagle & Georg Müller, The Strategy and Tactics of Pricing (Routledge)