Multi-product break-even analysis: weighted contribution and sales mix
Calculate a break-even sales mix, distinguish unit shares from revenue shares, and test how a lower-margin product changes the required volume.
Choose a period and a unit-sales mix
A multi-product break-even calculation starts with the fixed costs for one planning period and each product’s selling price, variable cost and share of unit sales. The shares must describe the same population and total 100%. A 70% unit share means seven of every ten units sold are that product. It does not mean 70% of revenue. Keep monthly fixed expenses with monthly sales assumptions, or convert both to another consistent period. The resulting blended unit is a planning construct: customers still purchase the actual products, whose quantities need a separate feasibility check.
Build a two-product example you can reproduce
Enter Coffee with selling price 30, variable cost 12 and unit-sales share 70%. Enter Tea with price 20, variable cost 14 and share 30%. Use fixed costs 1,440 for the period. Coffee contributes 18 per unit and tea contributes 6. Weighted contribution is 0.70 × 18 + 0.30 × 6, or 14.40. The multi-product break-even calculator returns 100 blended units and revenue 2,700. At that mix, 70 coffee units produce 1,260 contribution and 30 tea units produce 180, exactly covering the fixed costs.
| Product | Units | Contribution per unit | Total contribution |
|---|---|---|---|
| Coffee | 70 | 18 | 1,260 |
| Tea | 30 | 6 | 180 |
| Combined | 100 | Weighted: 14.40 | 1,440 |
Unit shares are 70% and 30%. Total contribution covers the example’s fixed costs.
Change the mix while keeping prices unchanged
Now reverse the mix to 30% coffee and 70% tea. Weighted contribution falls to 9.60, so break-even volume rises to 150 blended units. The expected quantities become 45 coffee and 105 tea. Weighted price is 23, which gives break-even revenue 3,450. The business needs more units and more revenue even though neither product’s price or variable cost changed. This counterexample is why a single historical average contribution can become misleading after a campaign shifts demand toward a lower-contribution item. Recalculate using the proposed mix before interpreting a sales target.
Do not substitute revenue shares for unit shares
In the original 100-unit example, coffee generates 2,100 revenue and tea generates 600. Coffee therefore accounts for about 77.78% of revenue but only 70% of units. Entering 77.78 as its unit share would describe a different sales plan and change the weighted contribution. If your report provides revenue by product, divide each product’s revenue by its actual selling price to recover unit counts, allowing for discounts and product variants. Then calculate the unit shares. Keep the conversion worksheet with the scenario so a reviewer can follow how the mix was derived.
Round a sales plan and check it again
The tool reports continuous planning quantities, which can be fractional for many combinations. You cannot fulfill a fraction of an indivisible product. Rounding every line down may leave insufficient contribution, while rounding every line up can change the mix and required inventory. Sum the contribution of your proposed whole-unit quantities and compare it with fixed costs directly. If a product must be sold in packs, apply that constraint as well. Record the final sellable quantities separately from the theoretical blended volume, rather than presenting a decimal output as an executable stock plan.
Use costs that fit the sales channel
A product’s contribution can differ between channels because fees, packing and delivery vary. The contribution margin calculator helps you review percentage fees alongside other per-unit costs before building the multi-product table. Combine only costs with consistent scope. If a free-shipping promotion changes the average delivery expense or the products customers add, revisit both the variable cost and the unit mix. The free shipping threshold calculator can test representative basket economics, but its margin-rate assumption does not replace the product-by-product information needed for this break-even analysis.
Watch for capacity and cost steps
The model assumes fixed costs stay fixed and unit costs stay stable over the relevant range. If 150 units require additional storage, a second production shift or expedited replenishment, the cost structure has changed. Add the corresponding expense and rerun the scenario. Also compare product quantities with inventory and supplier lead times. A mathematical break-even point can be unreachable if the high-contribution item is unavailable. Keep a low-volume, expected-volume and capacity-limit scenario so the calculation shows where its assumptions stop fitting actual operations.
Make mix review part of the reporting routine
At the end of the period, compare actual product units, prices and variable costs with the planned table. Identify whether the gap came from lower volume, a different mix, discounts or cost changes. Those explanations lead to different decisions: a volume shortfall may call for demand investigation, while a mix shift may call for reviewing promotion placement or product economics. Save the original assumptions instead of overwriting them with actuals. Use the observed mix for the next plan, then test a plausible adverse mix so the target does not depend on an unexplained return to earlier customer behavior.