Key takeaways
- Four margins become one weighted average using planned units as weights.
- The split must add up to the break-even total and to the fixed costs it covers.
- Losing the highest-margin product can raise break-even by 20% even if total units stay flat.
- Capacity can make a correct break-even infeasible, so check the split against the constraint.
- Target profit goes in the numerator: divide fixed costs plus target profit by the weighted margin.
Four products and the limits of one blended margin
With four products, the weighted contribution margin is still the right tool, but it compresses more information and therefore hides more. Each product can have a different price, variable cost, demand pattern, and claim on capacity. The single blended figure is useful for a go or no-go check on the plan; it is not a substitute for looking at each product.
The calculation also assumes the mix is achievable and stable. At four products, both assumptions deserve explicit testing, because a change in one product’s demand can move the weighted margin more than a change in any price. A plan that breaks even at the blended margin can fail at the mix that actually arrives.
The formula
Contribution margin per unit = price − variable cost
Weighted margin = Σ(CM_i × units_i) ÷ Σunits_i
Break-even units = fixed costs ÷ weighted margin
Units of product i = break-even units × units_i ÷ Σunits_i
The formula is the same as for two or three products; only the number of terms changes. The weighted margin is a dollars-per-unit average, so break-even is a unit count. For a revenue answer, divide fixed costs by the total contribution margin ratio instead, and state which measure you are reporting.
A worked four-product example
A distributor sells four lines with $30,000 of monthly fixed costs and plans 600, 400, 200, and 100 units respectively.
| Product | Price | Variable cost | Contribution margin | Planned units | Total contribution |
|---|---|---|---|---|---|
| A | $20 | $8 | $12 | 600 | $7,200 |
| B | $50 | $30 | $20 | 400 | $8,000 |
| C | $100 | $60 | $40 | 200 | $8,000 |
| D | $150 | $90 | $60 | 100 | $6,000 |
| Total | 1,300 | $29,200 |
The weighted margin is $29,200 ÷ 1,300 = $22.46. Break-even is $30,000 ÷ $22.46 = 1,335.6, which rounds up to 1,336 units. Product D has the highest margin but only 7.7% of units, so it adds $6,000 of contribution without moving the average much. Product A, with 46% of units, has the strongest pull on the weighted margin.
Splitting and rounding
Apply the unit shares: A 1,336 × 0.4615 = 616, B 1,336 × 0.3077 = 411, C 1,336 × 0.1538 = 205, and D 1,336 × 0.0769 = 103. Those figures add to 1,335, one unit short, so add one unit to the highest-margin product, D. The contribution check is 616 × $12 = $7,392, 411 × $20 = $8,220, 205 × $40 = $8,200, and 104 × $60 = $6,240, for $30,052, just above fixed costs.
That residue is normal. The important discipline is to verify the rounded split against fixed costs, not just against the total unit count. A split that sums to 1,336 but leaves $200 of fixed costs uncovered is not at break-even.
What a mix shift does
Suppose demand for D collapses, and the 100 units move to A instead: A 700, B 400, C 200, D 0. Total contribution becomes $8,400 + $8,000 + $8,000 = $24,400 over 1,300 units, a weighted margin of $18.77. Break-even rises to 1,598 units, 262 more than before, an increase of nearly 20% with no change in price, cost, or total volume.
This is why product-level demand deserves attention even when the total looks stable. A plan that assumes the highest-margin product holds its share is fragile: the products with the largest margins are often the ones with the smallest volumes and the least demand visibility. Test a scenario in which the top-margin product loses half its units and see whether the plan still clears fixed costs.
Capacity and the limiting factor
If product C’s line can produce only 180 units a month, the 205-unit break-even split is infeasible. The plan must be recalculated at a mix that respects the cap. Replacing 25 units of C with 25 units of A reduces total contribution by 25 × ($40 − $12) = $700, so the weighted margin falls to $28,500 ÷ 1,300 = $21.92 and break-even rises to 1,369 units. The correct response is either more capacity, a higher price for C, or a different mix, not a break-even that assumes unavailable units.
When one resource limits output, rank products by contribution per unit of that resource. If the constraint is machine hours, labor hours, shelf space, or a supplier allocation, the ranking can differ sharply from the ranking by contribution per unit, and the feasible mix is the one that maximizes contribution per constrained unit.
Loss leaders, bundles, and pruning
A product with a negative contribution margin cannot be part of a break-even mix on its own. If D is sold at $150 with $160 of variable cost, every unit loses $10. It can still make sense as a loss leader that drives sales of A, but the $10 belongs in a marketing budget, and the bundle’s combined margin is what must be tested. Measure the attach rate and the total basket margin; do not average the negative product into the weighted margin as if it contributed.
Pruning follows the same logic. Dropping a product removes its contribution but usually leaves its share of fixed costs behind. Drop a line only when its contribution is negative, when the fixed costs are genuinely avoidable, or when the freed capacity can earn more contribution than the line produced. Revenue share is not the test; contribution and capacity are.
A target profit, not just zero
Break-even is the zero-profit point. For a target profit, add it to fixed costs before dividing: ($30,000 + $12,000) ÷ $22.46 = 1,870 units at the same mix. In unit terms, the extra $12,000 requires 534 additional units at the weighted margin, and those units split by the same shares.
Common mistakes
- Using revenue instead of contribution. Revenue covers variable costs before it covers fixed costs.
- Putting per-unit costs into the fixed pool. The numerator and the weighted margin are both distorted.
- Rounding the total down. Break-even is a floor, so a fractional unit rounds up.
- Assuming the mix stays fixed. A single product’s decline can move break-even by 20%.
- Ignoring capacity. A split that needs units the plant cannot make is not a plan.
- Blending a negative-margin loss leader into the average. Its loss needs a budget and a bundle test.
Practical caveats
Four products multiply the assumptions: four prices, four variable costs, four demand forecasts, and a fixed cost pool that may step up as volume grows. Build the mix from recent actual sales, not from a target, and test at least one adverse mix. If the plan is close to break-even, the risk is concentrated in the product whose demand is least certain, which is often the highest-margin one.
Contribution margin ignores cash timing, financing costs, and taxes. A distributor can be above break-even and still short of cash if inventory and receivables absorb the contribution. Fixed costs also change with the relevant range: added storage, a second shift, or extra support staff are step costs that belong in the calculation before the plan is approved.
Finally, keep the product-level view. A blended break-even is a summary, and summaries hide the line that is losing money or the line that is carrying the plan. Review contribution by product each period, and update the weighted margin when the mix moves rather than at the end of the year.
Frequently asked questions
How is the weighted margin different from the average margin?
The weighted margin uses planned units as weights, so high-volume products count more. The simple average treats every product equally and is correct only at equal volume.
Why does break-even rise when a high-margin product loses volume?
Because the weighted margin falls. If those units are replaced by a lower-margin product, each unit now contributes less toward fixed costs, so more units are needed to cover the same pool.
Should I include fixed costs that exist only for one product?
Yes, either in the fixed pool or as a separate product-level test. A dedicated machine or campaign is a real cost of carrying that product.
What if two products share a capacity constraint?
Rank them by contribution per unit of the constrained resource, not by margin per unit, and build the mix from the top of that ranking until the constraint binds.
Can break-even be calculated for a target profit?
Yes. Add the target profit to fixed costs and divide by the weighted margin. The result is the unit volume needed to earn that profit at the assumed mix.
Further reading