Build a monthly fixed and variable cost worksheet
Classify mixed costs, normalize annual bills, and reconcile a practical cost worksheet before calculating break-even.
By DiligenceSignal editorial · AI-assisted preparation and numerical checks by Codex · Published . No independent accountant review is claimed.
Start with evidence, not a round number
Collect recent invoices, supplier quotes, payroll assumptions and subscription renewals. Write the source and date beside each estimate. Use a separate column for uncertain amounts instead of disguising them as zero. The purpose of the worksheet is to make assumptions inspectable: another person should be able to reproduce the totals from your notes.
Choose one month and one unit
Choose a representative operating month and define the unit being sold: one appointment, one delivered product or one subscription-month. Do not combine hourly prices with per-order costs. Divide an annual recurring bill by 12 for a monthly planning estimate; divide a quarterly recurring bill by 3. Keep one-time setup purchases separate from recurring operating costs. A cash payment schedule can still be uneven even when the monthly estimate is smooth.
An original worked worksheet
Consider a hypothetical solo service business. Its monthly workspace is $600, software is $90, insurance is $240 per year ($20 per month), and a chosen owner-pay allowance is $1,290. Total modeled fixed costs are $2,000. An appointment sells for $80 and uses $14 in materials and $6 in outsourced labor, for $20 of variable cost. With no payment fee in this first scenario, contribution is $60 and whole-appointment break-even is 34 appointments. At 33 appointments contribution is $1,980, leaving a $20 gap; at 34 it is $2,040, leaving $40 after fixed costs. These invented amounts illustrate the method, not industry benchmarks.
Split mixed costs and avoid double counting
A service bill may contain a base subscription and usage charges. Put the base in fixed costs and only the incremental usage in per-unit costs. If a supplier quote already includes packaging, do not add the same packaging again. If owner pay is included in fixed costs, do not include that same pay again as target profit. Keep loan repayments, taxes and depreciation treatment in a separate cash/accounting reconciliation rather than assuming the calculator resolves them.
Copy this worksheet structure
For every line, record: item; source and date; payment frequency; amount; fixed or variable classification; monthly fixed equivalent or per-unit amount; confidence; and next check. Reconcile fixed costs to the monthly total and variable costs to one clearly defined unit. For uncertain inputs, retain a low/base/high range and run the calculator separately for each scenario. Never mix the low cost assumption from one operating model with the high price from an incompatible offer.
Check the worksheet before deciding
Ask whether capacity limits or minimum purchase commitments change costs at higher volume. A second employee, a larger workspace or an equipment lease can create a step increase in fixed costs. Compare your calculated volume with actual bookable hours and realistic customer demand; the equation cannot prove either. Save the date and assumptions with a printed result so a later update can explain which input changed. Revisit the worksheet when a supplier quote expires or a new actual invoice arrives.
Reproduce the example
Use the free business break-even calculator. Inputs stay on your device. Start with one unit per transaction unless the example states otherwise.
Source and scope
The basic fixed-cost/contribution relationship is explained in the U.S. Small Business Administration’s break-even guidance, checked October 17, 2026. Worksheets, scenarios and calculations here are original hypothetical examples. See our methodology and correction process.