Break-Even Planner
Calculate your break-even point in units and revenue. Enter fixed costs, variable cost per unit, and selling price. The sheet shows break-even quantity, required revenue, and a contribution margin summary. Includes scenario slider.
Excel • FinanceBreak-even has two jobs. It tells you the sales volume that keeps the doors open, and it tells you whether the price you charge makes that volume physically possible. Most people do the first and skip the second. That is how a business ends up with a target it could not hit even if every customer said yes.
Work it in this order. Fixed costs set the target. Contribution margin sets how fast you close it. Volume is division. Price comes last, and it is the only lever that moves the answer without adding hours or staff. The example below is a workshop selling one product wholesale, and its numbers carry through every step.
Step 1: Add up one month of fixed costs
Fixed costs are the bills that arrive whether you sell four units or four hundred. Convert everything to a monthly figure: annual insurance divided by 12, weekly wages multiplied by 4.33, quarterly bills divided by 3. Treat a quarterly charge as two quiet months then a big one and the break-even number under-reads all year.
| Fixed cost | Per month |
|---|---|
| Workshop unit rent | $1,450 |
| Liability and contents insurance | $180 |
| Owner's pay (what you must draw to live) | $3,200 |
| Part-time helper, 20 hrs/week at $18 | $1,560 |
| Equipment loan payment | $452 |
| Software and subscriptions | $165 |
| Utilities, 12-month average | $498 |
| Phone and internet | $95 |
| Total fixed cost | $7,600 |
Two lines need calculating. The equipment loan was $18,000 over 48 months at 9.5%, which the Loan EMI Calculator turns into the $452 payment (set the term unit to months). The helper's hours go through the Time Card Calculator. Use scheduled hours, not last week's. A quiet week flatters the model.
Step 2: Work out contribution margin per unit
Contribution margin drives the rest of the calculation. It is what one sale leaves behind after the costs that exist only because that sale happened: price minus variable cost, per unit.
The wholesale price is $48. Variable costs run to materials $16.40, packaging $2.10, a flat $3.36 payment and order-handling charge, allocated freight $1.90, per-piece outsourced finishing $4.20, and $1.04 for breakage and seconds. That totals $29.00.
Contribution margin = $48.00 − $29.00 = $19.00 per unit CM ratio = $19.00 ÷ $48.00 = 39.6% of every dollar of revenueEach sale hands you $19 towards the $7,600 of fixed cost. Nothing but price or unit cost changes that rate. Selling harder only gets you there sooner.
What counts as variable
The test is whether the cost disappears when the sale does. Card fees and commission scale with revenue, so they are variable. An accounting subscription is fixed even though it feels transaction-related. Filing card fees as fixed is the common slip, and it always errs the flattering way: contribution margin goes up, break-even volume comes down, and an unreachable plan starts to look reachable.
Step 3: Run the break-even point calculator
Put the numbers into the Break-Even Point Calculator: fixed costs 7600, price 48, variable cost 29, target profit 0.
Break-even only keeps the lights on, so run it again with a target profit. At $2,000 the maths is (7,600 + 2,000) ÷ 19 = 505.3, which rounds up to break-even point of 506 units and $24,288 of revenue. Those 106 extra units are more than a quarter on top of break-even. A thin margin makes profit expensive in volume terms.
Step 4: Test the volume against real capacity
This is the step that gets skipped.
Count what you can actually make and sell in a month. The workshop turns out about 15 units a day across 22 working days, and roughly 330 of those survive as sellable stock. The plan needs 400 to break even. It needs 506 to earn the $2,000.
That gap is not a motivation problem. At $48 the business cannot break even at full output, so every month ends short no matter how hard anyone works. Four levers close it: cut fixed costs, cut variable costs, add capacity, raise price. Cutting fixed costs usually means losing the helper, which cuts capacity too. Adding capacity means another wage, which puts fixed costs back up. Price moves the answer without moving anything else. Start there.
Step 5: Reprice with the wholesale price calculator
Pricing from a margin target is a division, not a multiplication. Open the Wholesale Price Calculator with unit cost 29 and target margin 51%.
Price = unit cost ÷ (1 − target margin) = 29 ÷ 0.49 = $59.18 → round to $59At $59 the contribution margin is $30, which gives 254 units to break even and 320 for the $2,000 profit. Both sit inside the 330 capacity, with room for a bad week.
Percentage-based costs move with the price. The $3.36 handling charge here is flat, so variable cost stays at $29. If yours is a percentage of the sale, re-enter it at the new price before trusting the result.
| Price | Contribution margin | Units to break even | Units for $2,000 profit |
|---|---|---|---|
| $43.50 | $14.50 | 525 | 663 |
| $48.00 | $19.00 | 400 | 506 |
| $53.00 | $24.00 | 317 | 400 |
| $58.00 | $29.00 | 263 | 332 |
| $59.00 | $30.00 | 254 | 320 |
Read the last two columns as the return on a price rise. The single dollar between $58 and $59 takes 12 units a month off the profit target. Nothing on the cost side of a $29 unit moves the number that fast.
The MSRP multiplier handles the other half of a wholesale deal. Set it to 2 and $59 wholesale implies $118 retail, the doubling most shops apply by default. If that shelf price is wrong for your product, so is the wholesale price.
Step 6: Start from an industry version if one fits
The generic calculator wants a price per unit. That gets awkward when your unit is a table of four, or a lawn. These versions arrive pre-shaped with the cost lines each trade already uses: restaurants (covers, food cost percentage), coffee shops (cups per day, milk and cup cost), food trucks (service days, pitch fees, fuel), and landscaping (jobs per week, crew time).
When the unit is a job, the Service Business Break-Even Calculator takes the same four inputs with average job value in place of price: 7,600 fixed, $450 a job, $180 variable, giving 36 jobs a month. Build that $180 in the Job Costing Calculator, using $90 of materials plus five crew hours at $18. Set overhead to 0. Fixed costs are already in step 1, and counting them again double-charges every job. And if you bill hourly, the Billable Hours Calculator runs the chain backwards, from target income and billable capacity to the rate that reaches it.
Step 7: Re-run it whenever an input moves
Every change in fixed cost converts straight into units at the contribution margin. A second $1,560 helper adds 1,560 ÷ 30 = 52 units a month before you are back where you started, so the hire only pays if it produces more than 52 extra sellable units. Ask that before the interview. A $200 rent review is 7 units. Variable costs bite harder: a supplier adding 8% to the $16.40 material line costs $1.31 of margin and pushes the target from 320 to 335.
Re-run the chain each quarter. Re-run it again straight after any renewal, wage change, supplier price list, or loan starting or ending. Nothing in the calculator flags a stale input, so the check has to sit on your calendar.
Related: discount percentage calculator · bulk discount calculator · 40 percent markup calculator · monthly overhead planner · all finance calculators
Selling more than one product changes the math
The whole walkthrough above prices and breaks even on one product. Most businesses sell more than one, at different margins, and a single blended break-even number can hide which items are actually carrying the business.
The fix is a weighted average contribution margin, weighted by sales mix rather than treating every product as equally common. Say the workshop above adds a second item selling at $65 with $22 contribution, and expects 60% of unit sales from the original $19-contribution item and 40% from the new one. Weighted contribution margin = (0.60 × 19) + (0.40 × 22) = $20.20 per unit. Run that blended figure through the break-even calculator instead of either product's number alone, and the result reflects the actual mix rather than assuming everything sold is the cheaper or the pricier item.
Watch what happens if the mix shifts. Sell more of the lower-margin item than planned, on the same total unit volume, and the blended contribution margin drops, quietly raising the real break-even point even though nothing about either product's price changed. Recheck the mix assumption whenever one product starts outselling its planned share.
