Finance Desk

Break-even

Change the price, the costs or the forecast and watch the break-even point, the margin of safety and profit move together. Then check the method against the worked calculations, and find the error in five flawed solutions.

Section 01: The workspace

Interaction

Atelier Barro's break-even, from November

Source: Simulated data

The inputs start from the case: €22 a mug, €6.30 of variable cost plus a 4% card fee, and €8,140 of monthly fixed costs. Try each scenario, then set your own.

Inputs
Excluding costs that are a share of the price.
Card fees, commissions, royalties.
Try a scenario

Each scenario changes only the inputs it names, starting from the case's figures.

Results

Variable cost per mug
€7.18includes 4% of the price
Contribution per mug
€14.82
Break-even quantity
550 mugsexactly 549.26, rounded up
Break-even revenue
€12,083.67
Margin of safety
90 mugs14.1% of forecast sales
Profit at forecast sales
€1,344.80
Output for the target profit
685 mugswithin capacity

Reading. The business must sell 550 mugs a month to cover its costs. At forecast sales of 640 it makes a profit of €1,344.80, and sales could fall by 90 mugs (14.1%) before it makes a loss.

Implication. The business could absorb a moderate fall in sales, but each mug lost costs €14.82 of profit.

Break-even chartTotal revenue and total cost meet at 550 mugs a month (the break-even point, rounded up). Forecast sales of 640 give a margin of safety of 90 and a profit of €1,344.80. Capacity is 1,200.010,00020,00030,00040,00005001,0001,500mugs a month€ a monthLossProfitTotal revenueTotal costFixed costsCapacity 1,200Forecast 640Margin of safety 90Break-even 550
Chart Total revenue (blue), total cost (black) and fixed costs (dashed). Simulated teaching data from the case file; the chart is redrawn from the inputs above.
The chart's figures as a table
PointOutputTotal revenueTotal costProfit or loss
Zero output0 mugs€0.00€8,140.00−€8,140.00
Break-even550 mugs€12,100.00€12,089.00€11.00
Forecast640 mugs€14,080.00€12,735.20€1,344.80
Capacity1,200 mugs€26,400.00€16,756.00€9,644.00

The working: break-even quantity

Given
  • Fixed costs per month: €8,140
  • Selling price per mug: €22.00
  • Variable cost per mug: €7.18
Formula
Break-even quantity = fixed costs ÷ contribution per unit
Substitution
= €8,140 ÷ (€22.00 − €7.18)
Working
Contribution per unit = 22.00 − 7.18 = 14.82
8,140.00 ÷ 14.82 = 549.26
Answer
550 mugs

Rounded up, not to the nearest whole number: at 549 mugs the result would be a loss of €3.82.

Unit
mugs per month
Interpretation
The business must sell 550 mugs a month to cover its costs. At forecast sales of 640 it makes a profit of €1,344.80, and sales could fall by 90 mugs (14.1%) before it makes a loss.
Business implication
The business could absorb a moderate fall in sales, but each mug lost costs €14.82 of profit.

Section 02: The calculations

Each with a worked example from the case.

Break-even

Contribution per unit

SL and HL Verification: Verified IB 5.5

Formula

Contribution per unit = selling price per unit − variable cost per unit

P
Selling price per unit (currency)
AVC
Variable cost per unit (currency)

Unit. currency per unit

What each unit sold adds towards paying the fixed costs and, once they are covered, towards profit.

Worked example: from the case Atelier Barro

Atelier Barro: contribution per mug at €22, from November

Given
  • Selling price per mug: €22.00
  • Variable cost per mug: €7.18
Formula
Contribution per unit = selling price per unit − variable cost per unit
Substitution
= €22.00 − €7.18
Working
22.00 − 7.18 = 14.82
Answer
€14.82
Unit
€ per mug
Interpretation

Each mug sold adds €14.82 towards the studio's €8,140 of monthly fixed costs, and then to profit.

Business implication

This is the figure that answers the question "what does one more mug do for the business?"

Errors that cost marks
  • Calling contribution per unit "profit per unit". It is not profit until the fixed costs are covered.
  • Forgetting a variable cost that is a share of the price, such as a card fee, which changes when the price changes.

Break-even

Total contribution

SL and HL Verification: Verified IB 5.5

Formula

Total contribution = contribution per unit × quantity sold

C
Contribution per unit (currency)
Q
Quantity sold (units per period)

Unit. currency per period

Profit equals total contribution minus fixed costs.

Worked example: from the case Atelier Barro

Atelier Barro: total contribution from 640 mugs, from November

Given
  • Selling price per mug: €22.00
  • Variable cost per mug: €7.18
  • Output per month: 640 mugs
Formula
Total contribution = contribution per unit × number of units sold
Substitution
= (€22.00 − €7.18) × 640
Working
Contribution per unit = 22.00 − 7.18 = 14.82
14.82 × 640 = 9,484.80
Answer
€9,484.80
Unit
€ per month
Interpretation

The month's mugs contribute €9,484.80, which covers the €8,140 of fixed costs and leaves €1,344.80 of profit.

Business implication

Profit is total contribution minus fixed costs, so any decision can be judged by what it does to contribution.

Errors that cost marks
  • Treating total contribution as profit.

Break-even

Break-even quantity

SL and HL Verification: Verified IB 5.5

Formula

Break-even quantity = total fixed costs ÷ contribution per unit

TFC
Total fixed costs (currency per period)
C
Contribution per unit (currency)

Unit. units per period

The output at which total revenue equals total cost. In whole units it is rounded up, because one unit fewer leaves a loss.

Worked example: from the case Atelier Barro

Atelier Barro: break-even quantity at €22, from November

Given
  • Fixed costs per month: €8,140
  • Selling price per mug: €22.00
  • Variable cost per mug: €7.18
Formula
Break-even quantity = fixed costs ÷ contribution per unit
Substitution
= €8,140 ÷ (€22.00 − €7.18)
Working
Contribution per unit = 22.00 − 7.18 = 14.82
8,140.00 ÷ 14.82 = 549.26
Answer
550 mugs

Rounded up, not to the nearest whole number: at 549 mugs the result would be a loss of €3.82.

Unit
mugs per month
Interpretation

The studio must sell 550 mugs a month to cover all its costs.

Business implication

In an average month it sells 640, so it is above break-even, but not by much.

Errors that cost marks
  • Rounding down to the nearest whole unit.
  • Dividing fixed costs by the selling price instead of by contribution per unit.

Break-even

Break-even revenue

SL and HL Verification: Teaching choice IB 5.5

Formula

Break-even revenue = break-even quantity × selling price per unit

BEQ
Break-even quantity (units per period)
P
Selling price per unit (currency)

Unit. currency per period

The value of sales at which the business makes neither a profit nor a loss.

Worked example: from the case Atelier Barro

Atelier Barro: break-even revenue at €22, from November

Given
  • Fixed costs per month: €8,140
  • Selling price per mug: €22.00
  • Variable cost per mug: €7.18
Formula
Break-even revenue = break-even quantity × selling price per unit
Substitution
= (€8,140 ÷ (€22.00 − €7.18)) × €22.00
Working
Break-even quantity = 8,140.00 ÷ 14.82 = 549.2578
549.2578 × 22.00 = 12,083.67
Answer
€12,083.67

The exact break-even quantity is used here, so the revenue is the point where total revenue equals total cost.

Unit
€ per month
Interpretation

The studio needs about €12,083.67 of sales a month to break even, the exact break-even quantity multiplied by the price.

Business implication

A target in money is easier to track week by week in the shop's till than a target in mugs.

Errors that cost marks
  • Giving the answer in units when revenue was asked for.

5.5: Not named in the guide, which lists break-even quantity; break-even revenue follows from it

Break-even

Margin of safety

SL and HL Verification: Verified IB 5.5

Formula

Margin of safety = actual or forecast output − break-even output

Q
Actual or forecast output (units per period)
BEQ
Break-even output (units per period)

Unit. units per period

How far sales can fall before the business makes a loss. A negative margin means the business is below break-even.

Worked example: from the case Atelier Barro

Atelier Barro: margin of safety at 640 mugs, from November

Given
  • Forecast sales per month: 640 mugs
  • Fixed costs per month: €8,140
  • Selling price per mug: €22.00
  • Variable cost per mug: €7.18
Formula
Margin of safety = forecast (or actual) output − break-even output
Substitution
= 640 − (€8,140 ÷ (€22.00 − €7.18))
Working
Break-even output = 8,140.00 ÷ 14.82 = 549.26, rounded up to 550
640 − 550 = 90
As a share of forecast sales: 90 ÷ 640 × 100 = 14.1%
Answer
90 mugs

Sales could fall by 90 mugs (14.1%) before the business makes a loss.

Unit
mugs per month
Interpretation

Sales could fall by 90 mugs a month, about 14%, before the studio makes a loss.

Business implication

A slow month, or one lost wholesale customer, could take away the profit. That is why the owner is worried.

Errors that cost marks
  • Confusing the margin of safety with profit.
  • Using the exact break-even figure for one purpose and the rounded figure for another in the same answer.

Break-even

Target profit output

SL and HL Verification: Verified IB 5.5

Formula

Target profit output = (total fixed costs + target profit) ÷ contribution per unit

TFC
Total fixed costs (currency per period)
TP
Target profit (currency per period)
C
Contribution per unit (currency)

Unit. units per period

The output needed to reach a chosen profit. Compare it with capacity and with realistic demand before treating it as a plan.

Worked example: from the case Atelier Barro

Atelier Barro: mugs needed for €2,000 of profit a month, from November

Given
  • Fixed costs per month: €8,140
  • Target profit per month: €2,000
  • Selling price per mug: €22.00
  • Variable cost per mug: €7.18
Formula
Target profit output = (fixed costs + target profit) ÷ contribution per unit
Substitution
= (€8,140 + €2,000) ÷ (€22.00 − €7.18)
Working
Contribution per unit = 22.00 − 7.18 = 14.82
(8,140.00 + 2,000.00) ÷ 14.82 = 684.21
Answer
685 mugs

Rounded up, so that the target is reached rather than just missed.

Unit
mugs per month
Interpretation

At €22 the studio would need to sell 685 mugs a month to make €2,000, 45 more than it sells now.

Business implication

That is 7% more sales at the same price. The survey in Exhibit 3 gives no reason to expect it, so the owner looks at price instead.

Errors that cost marks
  • Subtracting the target profit from fixed costs instead of adding it.

Break-even

Target price

SL and HL Verification: Verified IB 5.5

Formula

Target price = ((total fixed costs + target profit) ÷ expected sales) + variable cost per unit

TFC
Total fixed costs (currency per period)
TP
Target profit (currency per period)
Q
Expected sales (units per period)
AVC
Variable cost per unit (currency)

Unit. currency per unit

The price needed to reach a target profit if expected sales are achieved. A higher price usually lowers sales, so the expected sales figure is itself a judgement.

Worked example: from the case Atelier Barro

Atelier Barro: the price for €2,000 of profit at 640 mugs, from November

Given
  • Fixed costs per month: €8,140
  • Target profit per month: €2,000
  • Variable cost per mug, excluding costs that are a share of the price: €6.30
  • Expected sales per month: 640 mugs
  • Costs that are a share of the price: 4%
Formula
Target price = ((fixed costs + target profit) ÷ expected sales + variable cost per unit) ÷ (1 − share of the price)
Substitution
= ((€8,140 + €2,000) ÷ 640 + €6.30) ÷ (1 − 0.04)
Working
(8,140.00 + 2,000.00) ÷ 640 = 15.8438
15.8438 + 6.30 = 22.1438
22.1438 ÷ 0.96 = 23.0664
Answer
€23.07

Rounded up to the next cent. Dividing by 0.96 allows for the costs that rise with the price: at €23.07 they are €0.92 a mug.

Unit
€ per mug
Interpretation

The studio would need to charge €23.07 a mug to make €2,000 a month, if it still sold 640 mugs.

Business implication

The answer assumes sales stay at 640 at the higher price. Exhibit 3 suggests they would fall, so the price that meets the target is higher still, or the target is out of reach.

Errors that cost marks
  • Assuming sales stay the same when the price rises.

Section 03: Find the error

Five solutions, one wrong line in each.

Interaction

Find the error

Source: Subject knowledge

Each solution has exactly one wrong line. Choose it, then check.

  1. Solution 1 of 5

    Calculate Atelier Barro's break-even quantity from November, at a price of €22.

    Which line contains the error?
  2. Solution 2 of 5

    Calculate the break-even quantity before November, at a price of €22.

    Which line contains the error?
  3. Solution 3 of 5

    Calculate contribution per mug at a price of €24, from November.

    Which line contains the error?
  4. Solution 4 of 5

    Calculate the margin of safety at 640 mugs a month and a price of €22, from November.

    Which line contains the error?
  5. Solution 5 of 5

    How many mugs must the studio sell at €22 to make a profit of €2,000 a month, from November?

    Which line contains the error?

Choose an answer for each item, then open its answer to compare. 5 to do. Choose your answers, then check each one or check them all.

Back: costs and revenue Next: contribution decisions (HL)