Practical guide
Understanding business break-even planner — sensitivity table
Everyday editorial team · GEOINNOVATION CO., LTD · Published · Updated
What this calculation is for
Break-even analysis translates operating costs into the sales needed to cover them. A contribution margin is not the same as net profit: it first pays fixed overhead. Use costs measured over the same period so monthly expenses are not compared with annual sales.
How the method works
Selling price minus variable product cost and per-unit selling fees gives contribution per unit. Fixed monthly costs divided by that contribution gives operating break-even units. Adding a desired profit to the numerator gives a higher sales target.
A worked example
At a $50 selling price and $30 of variable cost and fees, each unit contributes $20. Fixed costs of $4,000 require 200 units before operating profit. A further $2,000 target requires 300 units.
Assumptions and real-world differences
A zero or negative unit contribution cannot cover positive fixed expenses through more sales. Taxes, returns, financing, inventory timing and owner pay must be included consistently where relevant. Capacity shown beside the result is a practical constraint, not a demand forecast.
Reading the monthly fixed operating costs sensitivity table
The tool evaluates the same model across a range of monthly fixed operating costs values while holding other assumptions constant. Choose a realistic low value, high value and number of points. Each row reports the same headline measure; the table is a set of conditional calculations, not a probability distribution or a forecast. Input-step rounding can make nearby rows equal.
Reproduce this tool’s example
These fixed example inputs are independent of edits you make above. Enter them in this tool to reproduce the result, then replace them with your own assumptions.
- Minimum monthly fixed operating costs
- 6,000 $
- Maximum monthly fixed operating costs
- 18,000 $
- Number of comparison points
- 5 points
- Selling price per unit
- 80 $
- Variable cost per unit
- 35 $
- Payment and selling fee per unit
- 3 $
- Desired monthly operating profit
- 5,000 $
- Monthly sales capacity
- 5,000 units
Sensitivity analysis: 5 comparison points
Monthly fixed operating costs ranges from $6,000 to $18,000.
- Monthly fixed operating costs: $6,000: 262 units
- Monthly fixed operating costs: $9,000: 334 units
- Monthly fixed operating costs: $12,000: 405 units
Frequently asked questions
- Are owner wages a fixed cost?
- They can be included if that reflects your planning definition. Do not omit them and then interpret the result as take-home profit.
- Can I use this for services?
- Yes, if a unit and its variable costs are defined consistently; utilization and billable hours may need a separate pricing tool.
- Does the most favorable row show the most likely outcome?
- No. The table assigns no likelihood to any row. It shows how the result responds to the chosen assumption, and you remain responsible for selecting a plausible range.