Break even analysis
A spreadsheet that shows how much you must sell to cover your costs. Enter the selling price, the variable cost of each unit and your fixed costs and it gives the contribution of each unit, the break even units and sales, your profit and margin of safety at the units you expect, and a table and chart of sales against total cost. Download it as Excel, OpenDocument, PDF or CSV.
Break even
Break even analysis
Fill in the yellow cells. The units and sales you need to cover your costs are worked out below.
Product or service Handmade candles
Selling price per unit 18.00
Variable cost per unit 6.50
Fixed costs per period 2,300.00
Expected units sold per period 260
| Result | Words shown | ||||
|---|---|---|---|---|---|
| Contribution per unit | 11.50 | Not reachable | |||
| Contribution margin | 63.9% | ||||
| Break even units | 200 | ||||
| Break even sales | 3,600.00 | ||||
| Profit at expected units | 690.00 | ||||
| Margin of safety | 23.1% | ||||
| Units sold | Sales | Total cost | Profit | ||
| 0 | 0.00 | 2,300.00 | -2,300.00 | ||
| 40 | 720.00 | 2,560.00 | -1,840.00 | ||
| 80 | 1,440.00 | 2,820.00 | -1,380.00 | ||
| 120 | 2,160.00 | 3,080.00 | -920.00 | ||
| 160 | 2,880.00 | 3,340.00 | -460.00 | ||
| 200 | 3,600.00 | 3,600.00 | 0.00 | ||
| 240 | 4,320.00 | 3,860.00 | 460.00 | ||
| 280 | 5,040.00 | 4,120.00 | 920.00 | ||
| 320 | 5,760.00 | 4,380.00 | 1,380.00 | ||
| 360 | 6,480.00 | 4,640.00 | 1,840.00 | ||
| 400 | 7,200.00 | 4,900.00 | 2,300.00 |
