Break-even calculator sheet
Break-even calculator sheet
Estimate break-even units, break-even revenue, target-profit units, and expected profit for one product or service scenario.
PreviewPrintable break-even scenario
Break-even calculator sheet
April break-even calculator
Northwind Operations LLC - Implementation package - Base case
Break-even summary
| Total fixed costs | $7,600.00 |
|---|---|
| Variable cost / unit | $35.00 |
| Contribution margin / unit | $90.00 |
| Contribution margin % | 72.00% |
| Break-even units | 85 |
| Break-even revenue | $10,625.00 |
Core assumptions
| Selling price / unit | 125 |
|---|---|
| Expected units | 160 |
| Target profit | 4500 |
| Target-profit units | 135 |
| Expected profit / loss | $6,800.00 |
Fixed costs
| Category | Description | Owner | Monthly amount |
|---|---|---|---|
| Payroll | Management allocation | Maya | 5200 |
| Facilities | Office rent | Jordan | 1800 |
| Software | Planning tools | - | 600 |
Variable costs
| Category | Description | Amount / unit |
|---|---|---|
| Labor | Contractor support | 22 |
| Materials | Printed packet | 8 |
| Fees | Processing | 5 |
Fixed cost categories
| Payroll | $5,200.00 |
|---|---|
| Facilities | $1,800.00 |
| Software | $600.00 |
Variable cost categories
| Labor | $22.00 |
|---|---|
| Materials | $8.00 |
| Fees | $5.00 |
Scenario review checklist
- Confirm selling price and variable cost assumptions before using the break-even units.
- Review fixed cost rows for missing owners or outdated monthly amounts.
- Compare expected units against break-even and target-profit units.
Notes
Review contractor capacity before final pricing.