Financial Laboratory · Costs and break-even

Output for a target profit

How many units, or what price, would earn a chosen profit?

Back to 5.5 Break-even analysis

  • IB 5.5 Break-even analysis
  • SL and HL
  • Standard formula: not on the formula sheet
  • Simulated data Example: Emberly Roasters, fictional

The guide’s formula sheet (pp. 64 to 65) has no break-even formulas, so this is the standard form used in the platform’s notes on 5.5.

The calculator

Example figures: Emberly Roasters, a fictional business. Simulated data.

Your figures
Every cost that rises with each unit made and sold.
Costs that stay the same whatever the output.
The sales the target price is worked for.
The most that can be made in the period.
Currency, units and period

The labels, workings and results use these words. Emberly Roasters’s figures are in dollars, bags and months.

The figures

Selling price per bag
$24.00
Variable cost per bag
$14.40
Fixed costs per month
$29,000.00
Target profit per month
$8,000.00
Expected sales per month
3,600 bags
Capacity per month
4,500 bags

Changing these figures needs JavaScript. With it switched off, the page shows the full worked example for the figures above.

Result

These results are for the last complete figures. Correct the figure marked in the inputs to update them.

Output for the target profit

3,855 bags a month

for a profit of $8,000; within capacity

Within capacity?
Yes85.7% of 4,500 bags
Gap to expected sales
+255 bagsexpected sales 3,600 bags
Target price at 3,600 bags
$24.68+2.8% on $24.00
Profit at expected sales and today’s price
$5,560.00

Section 01: The formula and the working

Each formula in the guide’s words, then the working with the figures above, step by step.

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

Standard form; the guide gives no formula.

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

Standard form; the guide gives no formula.

Target profit output

Given
  • Fixed costs per month: $29,000
  • Target profit per month: $8,000
  • Selling price per bag: $24.00
  • Variable cost per bag: $14.40
Formula
Target profit output = (fixed costs + target profit) ÷ contribution per unit
Substitution
= ($29,000 + $8,000) ÷ ($24.00 − $14.40)
Working
Contribution per unit = 24.00 − 14.40 = 9.60
(29,000.00 + 8,000.00) ÷ 9.60 = 3,854.17
Answer
3,855 bags

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

Unit
bags per month
Interpretation
At $24.00 the business must sell 3,855 bags a month to make $8,000.
Business implication
That is within capacity (85.7% of it); the question is whether the market will buy it.

Target price at expected sales

Given
  • Fixed costs per month: $29,000
  • Target profit per month: $8,000
  • Variable cost per bag: $14.40
  • Expected sales per month: 3,600 bags
Formula
Target price = ((fixed costs + target profit) ÷ expected sales) + variable cost per unit
Substitution
= (($29,000 + $8,000) ÷ 3,600) + $14.40
Working
(29,000.00 + 8,000.00) ÷ 3,600 = 10.2778
10.2778 + 14.40 = 24.6778
Answer
$24.68

Rounded up to the next cent, so that the target profit is reached at the expected sales.

Unit
$ per bag
Interpretation
If sales stay at 3,600 bags, the business would need to charge $24.68 a bag.
Business implication
The answer assumes sales do not fall at the higher price. If they would, the price that meets the target is higher still, or the target is out of reach.

Section 02: The chart

Drawn from the figures above, with every value also in a table.

Break-even chartTotal revenue and total cost meet at 3,021 bags a month (the break-even point, rounded up). Forecast sales of 3,600 give a margin of safety of 579 and a profit of $5,560.00. Capacity is 4,500. At the target output of 3,855, the gap between total revenue and total cost is a profit of $8,008.00.025,00050,00075,000100,000125,00001,0002,0003,0004,0005,000bags a month$ a monthLossProfitTotal revenueTotal costFixed costsCapacity 4,500Forecast 3,600Margin of safety 579Target 3,855Break-even 3,021
Chart Total revenue (blue line), total cost (black line) and fixed costs (dashed line) against output. Left of the break-even point the gap between the lines is a loss; right of it, a profit. Drawn from the figures entered above.
The chart’s figures as a table
The break-even chart’s figures
PointOutputTotal revenueTotal costProfit or loss
Zero output0 bags$0.00$29,000.00−$29,000.00
Break-even3,021 bags$72,504.00$72,502.40$1.60
Expected sales3,600 bags$86,400.00$80,840.00$5,560.00
Target profit output3,855 bags$92,520.00$84,512.00$8,008.00
Capacity4,500 bags$108,000.00$93,800.00$14,200.00

Section 03: A table of targets

The output needed, whether it fits within capacity, and the target price at expected sales of 3,600 bags, for a range of target profits.

Output and price for each target profit
Target profitOutput neededWithin capacity?Target price
$0 (break-even)3,021 bagsYes (67.1%)$22.46
$4,0003,438 bagsYes (76.4%)$23.57
$8,000 (the figures as entered)3,855 bagsYes (85.7%)$24.68
$12,0004,271 bagsYes (94.9%)$25.79
$16,0004,688 bagsNo (104.2%)$26.90

Reading. At $24.00 the most the business can earn is $14,200.00 a month, at full capacity of 4,500 bags. Any target above that needs a higher price, lower costs or more capacity, however hard it sells.

Section 04: What it means

For the figures above: the reading, the comparisons that give it meaning, and what a manager might do.

What the number means

To earn $8,000 a month at $24.00 a bag, the business must sell 3,855 bags: 255 bags more than the 3,600 bags it expects. Or, if sales stay at 3,600 bags, it would need to charge $24.68.

What to compare it with

Compare the target output with capacity, with past sales and with what market research suggests customers will buy. Compare the target price with competitors’ prices and with what customers have paid before. A target is a plan only if both comparisons hold.

Why benchmarks vary

What counts as a realistic target depends on the market. A business in a growing market may win extra sales with modest marketing; one in a mature market usually has to take them from rivals, which costs more. Customers of a premium or specialist product may accept a higher price, while customers of a standard product often switch at the first rise. Targets also need revisiting as costs change: the same profit needs more output after a supplier raises its prices.

What a manager might do

Options for a manager, not IB requirements; each has a cost or a risk to weigh.

  • The target needs 255 bags more than expected sales: find out whether marketing, new customers or a new channel could realistically win them.
  • The price route needs $24.68, +2.8% on today’s price: test whether customers would still buy 3,600 bags at that price, since a higher price usually sells less.
  • Combine routes: a smaller price rise with a modest gain in sales, or a cost saving, may reach the same target with less risk than either route alone.

Section 05: Learn more