Accounting › Section Q · Cost-volume-profit analysis › Topic Q.3
Break-even sensitivity for one and many products
Prices, costs and customer tastes never stand still. Sensitivity analysis reruns the break-even model under "what if" changes, one at a time or several at once, and extends it to businesses that sell a mix of products.
Asking "what if?"
Sensitivity analysis asks how operating income and the break-even point respond when one input changes: the selling price, the variable cost per unit, total fixed costs or the volume sold. Managers run it before raising prices, signing a lease or buying equipment, and accountants usually build it in a spreadsheet so each scenario takes seconds. The tools are the ones from The break-even point. Throughout, the base case is Quillmoor Kayaks: price $800, variable cost $480, margin $320, fixed costs $96,000 a month and expected sales of 400 kayaks, giving operating income of $32,000 and a break-even of 300 kayaks.
Changing one input
Each single change has a predictable direction. A higher price or a lower variable cost raises the contribution margin per unit, so fewer units are needed and break-even falls. A lower price or a higher variable cost does the reverse. A change in fixed costs leaves the margin per unit untouched but changes how many margins are needed: higher fixed costs raise break-even, lower ones reduce it. For the effect on income at a given volume, multiply any change in margin per unit by the units sold, and subtract any rise in fixed costs directly.
Worked example: three single changes
Hold sales at 400 kayaks and change one input at a time. 1. Price rises $40 to $840: margin becomes $360, income rises by \(400 \times 40 = 16{,}000\) to $48,000, and break-even falls to \(96{,}000 \div 360 = 266.7\), so 267 kayaks. 2. Resin costs push variable cost up $20 to $500: margin $300, income falls by $8,000 to $24,000, and break-even rises to exactly 320. 3. A new lease adds $12,000 of fixed cost: margin stays $320, income falls to $20,000, and break-even rises to \(108{,}000 \div 320 = 337.5\), so 338. Each change assumes volume holds at 400, which a price rise may not allow.
Changing several inputs at once
Real decisions usually move more than one input. Automation typically raises fixed costs and lowers variable cost per unit; a price cut lowers the margin but may lift volume. Rebuild the whole model with all the new figures rather than adding up separate effects. A useful extra figure is the indifference point, the volume at which two cost structures give the same income. Set the two income equations equal:
where \(M\) is margin per unit and \(F\) fixed costs. Above that volume the option with the higher margin and higher fixed costs wins.
Worked example: a moulding machine
A moulding machine would add $16,000 a month of lease cost but cut variable cost by $40, to $440. 1. New margin \(800 - 440 = 360\); new fixed costs 112,000. 2. Break-even: \(112{,}000 \div 360 = 311.1\), so 312 kayaks, up from 300. 3. Income at 400: \(400 \times 360 - 112{,}000 = 32{,}000\), the same as now. 4. Indifference point: \(320Q - 96{,}000 = 360Q - 112{,}000\) gives \(Q = 400\). 5. The firm also estimates that cutting the price to $780 would lift sales to 460: margin $340, income \(460 \times 340 - 112{,}000 = 44{,}400\). The combined plan beats $32,000 only if the volume estimate holds.
Many products: the sales mix
Most businesses sell several products with different margins, so break-even depends on the sales mix, the proportion in which products sell. The standard method assumes the mix stays constant and treats it as a composite unit, an imaginary bundle holding each product in its mix proportion. Find the bundle's margin by adding each product's margin times its quantity in the bundle, then divide fixed costs by that margin to get break-even bundles, and multiply back out by the mix. Fixed costs here are shared by the whole company, so they are not split product by product.
Worked example: Brackenfield Candle Co.
Brackenfield sells pillar candles ($20 price, $12 variable cost, $8 margin) and gift sets ($50, $25, $25), in a unit mix of 4 pillars to 1 gift set. Fixed costs are $30,780 a month. 1. Bundle margin: \(4 \times 8 + 1 \times 25 = 57\). 2. Bundle revenue: \(4 \times 20 + 50 = 130\). 3. Break-even bundles: \(30{,}780 \div 57 = 540\). 4. Products: \(540 \times 4 = 2{,}160\) pillars and 540 gift sets. 5. Sales: \(540 \times 130 = 70{,}200\) dollars. 6. Check: \(2{,}160 \times 8 + 540 \times 25 = 30{,}780\), exactly the fixed costs.
Break-even in dollars for a mix
A business that tracks sales in dollars can use a weighted-average contribution margin ratio, the bundle's margin divided by the bundle's revenue:
Then break-even sales are fixed costs divided by that ratio, \(30{,}780 \div (57 \div 130) = 70{,}200\), the same answer. Using the unrounded fraction avoids rounding errors. For a store with hundreds of products, the ratio is often estimated from total contribution margin and total sales of a typical period, which builds in that period's mix.
When the mix shifts
Suppose customers move towards pillars, so the mix becomes 7 to 1. Nothing about either product changes, yet break-even moves. The bundle margin is \(7 \times 8 + 25 = 81\) and its revenue \(7 \times 20 + 50 = 190\). Break-even is \(30{,}780 \div 81 = 380\) bundles: 2,660 pillars and 380 gift sets, or 3,040 units and $72,200 of sales, up from 2,700 units and $70,200. A shift towards lower-margin products raises break-even; a shift towards higher-margin ones lowers it, even when total sales dollars stay the same. That is why managers watch the mix, not just the total.
Common mistakes to avoid
First, adding the separate effects of several changes instead of rebuilding the model: interactions are easy to miss. Second, assuming volume stays fixed after a price change without saying so. Third, averaging the products' margins equally instead of weighting them by the sales mix. Fourth, mixing a unit mix with a dollar mix: a 4-to-1 unit mix is not 80% of sales dollars. Fifth, forgetting to multiply break-even bundles back out by the mix to get each product's units. Sixth, rounding the weighted ratio early, which distorts the dollar answer.
Key takeaways
Sensitivity analysis reruns CVP under changed inputs. A higher price or lower variable cost raises the margin and lowers break-even; higher fixed costs raise break-even without changing the margin. When several inputs change, rebuild the model, and use the indifference point to compare cost structures. For several products, assume a constant sales mix, build a composite unit, divide fixed costs by its margin, and multiply back out by the mix; for dollars, divide by the weighted-average ratio. A shift in the mix moves break-even even when nothing else changes.
Flashcards
Flashcard
Rerunning CVP with changed inputs
Test your understanding
Question 1 of 5
A product sells for $60 with variable costs of $36; fixed costs are $48,000. If variable costs rise to $40 per unit, what is the new break-even point?
Question 2 of 5
A firm's fixed costs rise by $10,000 while price and variable cost stay the same. What happens to its contribution margin per unit and its break-even point?
Question 3 of 5
Option A has a $30 margin per unit and $60,000 of fixed costs; option B has a $40 margin and $90,000 of fixed costs. At what volume do they earn the same income?
Question 4 of 5
A shop sells 3 mugs ($4 margin each) for every 1 teapot ($12 margin). Fixed costs are $18,000. How many teapots are sold at break-even?
Question 5 of 5
With no change in prices or costs, customers start buying more of a company's lowest-margin product. What happens to the break-even point?
