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.
The calculator could not start. The worked example below uses the example figures.
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.277810.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.
The chart’s figures as a table
| Point | Output | Total revenue | Total cost | Profit or loss |
|---|---|---|---|---|
| Zero output | 0 bags | $0.00 | $29,000.00 | −$29,000.00 |
| Break-even | 3,021 bags | $72,504.00 | $72,502.40 | $1.60 |
| Expected sales | 3,600 bags | $86,400.00 | $80,840.00 | $5,560.00 |
| Target profit output | 3,855 bags | $92,520.00 | $84,512.00 | $8,008.00 |
| Capacity | 4,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.
| Target profit | Output needed | Within capacity? | Target price |
|---|---|---|---|
| $0 (break-even) | 3,021 bags | Yes (67.1%) | $22.46 |
| $4,000 | 3,438 bags | Yes (76.4%) | $23.57 |
| $8,000 (the figures as entered) | 3,855 bags | Yes (85.7%) | $24.68 |
| $12,000 | 4,271 bags | Yes (94.9%) | $25.79 |
| $16,000 | 4,688 bags | No (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
- Notes 5.5 Break-even analysis The full notes for the subtopic.
- Formula sheet The formula sheet The formulae the examination provides, and the ones to learn, on one printable page.
- Practice Target profit output, a practice question Fresh fictional figures, checked as you answer, with the working and the usual slips. Paper 2 style, the platform’s own.
- On a case Break-even workspace (Atelier Barro) The same idea worked on a fictional case at the Finance Desk.
- Register Target profit output, worked on a case The calculation in eight parts, with the errors that cost marks.
Arjun Agrawal | The Business Brief, https://the-business-brief-dun.vercel.app/finance-desk/lab/target-profit/. Original teaching material, not an IB publication. The organizations in the teaching cases are fictional unless a case says otherwise.