C02 ยท Lesson 2 of 22 ยท 14 min ยท 5 hands-on tasks

Cost-Volume-Profit Analysis

How much must Trailhead sell to stop losing money, and does it matter which bikes? Work out the contribution margin ratio, break-even revenue and the sales needed for a profit target, then discover why selling more of the 'exciting' e-bike pushes break-even further away.

๐ŸŽฅ Watch it (3 min)

๐ŸŽฌ Situation

Theo has sorted Trailhead's costs: $32.3M variable, $21.7M fixed, on $50M of sales. That leaves $17.7M of contribution, $4M short of the fixed costs.

The board asks one question: how much do we need to sell to break even? The answer turns out to depend on which bikes.

Bike Price Variable cost Contribution CM ratio Revenue
City $600 $380 $220 36.7% $18M (30,000 bikes)
Trail $1,200 $700 $500 41.7% $18M (15,000)
E-Cargo $3,500 $2,600 $900 25.7% $14M (4,000)

๐ŸŽฎ Play

Profit vs sales, with a mix. Slide total revenue and the share each bike takes. The profit line crosses zero at break-even.

Trailhead's profit line
Trail share (the rest)36%
Break-even revenue$61.3M
Operating profitโˆ’$4M
CM ratio (mix-weighted)35.4%
โˆ’$20Mโˆ’$10M$0$10M020406080100Revenue ($ millions)Break-even: 61.3
Operating profit Zero

Hold revenue at $50M and drag E-Cargo's share up. The marker (break-even) runs away from you.

Today's mix (36% City, 36% Trail, 28% E-Cargo) gives a 35.4% CM ratio and break-even at $61.3M.

Build the CVP sheet. Theo's one-page answer for the board.

Trailhead CVP, $ millions
B5
AB
1
2
3
4
5
6
7
8
9
10
  • B5: CM ratio = contribution รท revenue, =B4/B2
  • B8: break-even = fixed costs รท CM ratio
  • B9: (fixed costs + 3) รท CM ratio
  • B10: margin of safety = (revenue โˆ’ break-even) รท revenue
A negative margin of safety: sales would have to rise 23% just to break even. Volume alone is a hard road; the course will look for better ones.

๐Ÿท๏ธ Name it

Term Formula Trailhead
Contribution margin Revenue โˆ’ variable costs $17.7M
CM ratio Contribution รท revenue 35.4%
Break-even revenue Fixed costs รท CM ratio $61.3M
Target-profit revenue (Fixed costs + target profit) รท CM ratio $69.8M for a $3M profit
Margin of safety (Revenue โˆ’ break-even) รท revenue โˆ’22.6%
Operating leverage Contribution รท operating profit Very high near break-even
Sales mix Each product's share of sales 36% / 36% / 28%

With one product you can break even in units: fixed costs รท contribution per unit. With several, use the mix-weighted CM ratio and break even in revenue, or use a weighted contribution per "bundle" of bikes.

๐Ÿ–๏ธ Like you're five: a lemonade stand that keeps 40 cents of every dollar needs $50 of sales to pay a $20 table rental. If it starts selling cookies that keep only 20 cents a dollar, it needs more sales to pay the same table.

Real life: CVP assumes prices, variable cost per unit, fixed costs and mix all stay put. Real life moves all four. Use CVP for fast, rough answers ("we need about $61M"), then test the assumptions with scenarios.

๐Ÿ”จ Do it: 5 tasks

0 / 5 done

Task 1 of 5 ยท The Trail bike's ratio

A Trail bike sells for $1,200 and has $700 of variable costs. What's its contribution margin ratio? Round to one decimal.

๐Ÿงฉ Case: "E-Cargo is our way out"

โญ VIP

Trailhead's CEO has a plan: "E-cargo is the fastest-growing part of the bike market. We'll put all our marketing behind it and sell $10M more E-Cargo bikes next year. That fixes the loss." Extra marketing: $1M.

Theo runs the numbers: $10M more revenue at E-Cargo's 25.7% CM ratio. What's the effect on profit?

What would you do? VIP members make the call, see what happens next across 2 decisions, and get the expert debrief.

๐Ÿ” Remember it

  1. A company has a 40% CM ratio and $2M of fixed costs. Break-even revenue is...

  2. Margin of safety measures...

  3. Contribution $10M, operating profit $1M: operating leverage is 10ร—. A 5% drop in sales cuts profit by...

Contribution margin ratio = contribution รท revenue. Break-even revenue = fixed costs รท CM ratio; revenue for a target profit = (fixed costs + target) รท CM ratio. With several products, the sales mix sets the CM ratio, so a mix shift toward low-margin products raises break-even. Operating leverage (contribution รท operating profit) shows how hard profit swings when sales move.

๐Ÿ“… Use it Monday

For your product or team, find three numbers: revenue, variable costs, fixed costs. Work out the CM ratio and break-even. Then ask: if our mix shifted to our cheapest product, how far would break-even move?

Create a free account to track your progress.