Hiring guide
Sales mix and break-even: why the same revenue can produce a different result
By CFO Index · Published
A sales target can be met while the business misses its profit target. If customers switch towards products that leave less contribution, the same revenue covers less overhead. A useful fractional CFO brief tests the mix behind the target instead of applying last month's average margin to every future sale.
Choose one period and a consistent cost boundary
Start with net sales by product or service for one entity, currency and month. Identify costs that change with those sales: product cost, delivery, payment fees and other agreed variable costs. Keep the period's fixed costs separate. Document exclusions, returns and cost allocations. Do not subtract the same delivery payroll both per sale and in fixed overhead. Reconcile the starting model to management records before using it for a budget decision. This is a planning definition, not a prescription for statutory account presentation.
Use the single-product formula carefully
The US Small Business Administration explains unit break-even as fixed costs divided by selling price less variable cost per unit, describing a single-product or service foundation. For a mixed business, the editorial model below weights contribution ratios by each product's share of sales revenue. It assumes that mix and cost behaviour stay constant within each case. It is not the same as averaging two margin percentages without considering sales shares, and it does not establish what customers will buy.
Build the sales-weighted contribution ratio
Hypothetical monthly example: product A leaves 40% of net sales after the agreed variable costs; product B leaves 20%. Fixed costs are €30,000. Prices, cost ratios and fixed costs do not change within each case. There are no taxes, financing costs or other excluded expenses in this simplified result. All figures are invented, not sector benchmarks.
| Case | A share / B share of revenue | Weighted contribution ratio | Contribution | Result after fixed costs |
|---|---|---|---|---|
| Original mix | 75% / 25% | 35% | €35,000 | €5,000 |
| Changed mix | 25% / 75% | 25% | €25,000 | −€5,000 |
Recalculate the sales hurdle, not just the headline margin
Original weighted contribution is 75% × 40% + 25% × 20% = 35%. Its break-even sales are €30,000 / 0.35 = about €85,714.29. The changed mix gives 25%, so break-even sales rise to €120,000. At €100,000 revenue, changing mix reduces contribution by €10,000 and moves the simplified result from €5,000 to a €5,000 loss. To earn €5,000 under the changed mix would require (€30,000 + €5,000) / 0.25 = €140,000. These are conditional hurdles, not sales forecasts.
Check whether the required mix can be delivered
Translate each case back into product quantities and delivery hours. Confirm stock, demand and capacity with commercial and operational owners. A shift towards A cannot be assumed merely because it improves the spreadsheet. If the €140,000 case requires another shift or contractor, add that cost and recalculate; fixed costs need not stay fixed beyond the tested activity range. Keep any product with negative contribution visible instead of hiding it inside an average. Do not use a whole-business allocation to decide discontinuation without separately checking avoidable costs and lost demand.
Put collection timing beside break-even
Accounting-period contribution does not prove cash sufficiency. Build receipts and payments on their actual dates, including stock purchases, delayed customer collections and existing obligations. Keep depreciation and cash capital spending distinct if they occur in your full model. A higher-contribution product with a long production lead time can still require more upfront funding. Request both the modelled operating result and lowest cash balance, with exclusions stated. Do not call the sales hurdle a cash break-even measure unless it was actually built from cash movements.
Accept the model with three reproducible tests
Ask a colleague to reproduce the original 35% ratio, change the revenue mix to 25%/75%, and add one evidenced capacity-cost step. Each case should retain the same cost definitions and reconcile to its product detail. Keep the source extracts, assumptions, version date and approval owner with the file. Review actual mix, realised contribution and capacity after the period. The assignment is useful when management understands what sales composition must hold and which assumptions need confirming, not when a single break-even number looks reassuring.