Weighted average contribution margin: unit mix and break-even

Weighted average contribution margin is contribution per unit weighted by each product's share of units sold. It tells a company how much an average unit, at a specified sales mix, contributes toward fixed costs and operating profit. In the example below, the average is $15 per unit, giving break-even of 6,000 units against $90,000 of fixed costs.

The formula: weight dollars per unit by units

Contribution per unit = Net selling price per unit - Variable cost per unit

Unit sales weight = Product units / Total units

Weighted average contribution margin = Sum of (Product contribution per unit x Unit sales weight)

An equivalent calculation divides total contribution by total units. The result is dollars per average unit. It is not a physical product that can be ordered; it describes the assumed blend of products.

The revenue-weighted percentage belongs to contribution margin ratio. Keep that calculation separate: it answers how much each sales dollar contributes, while this page answers how much each unit in the planned mix contributes.

OpenStax explains that multiproduct break-even uses a composite unit and must be revised when sales mix changes. The mix assumption is therefore a necessary part of the result.

Assemble the product rows

Start with an invoice-line export for the planning period, including SKU, units, net sales after credits, and product identifiers. Add the variable costs associated with those sales: purchased components, variable production labor, packaging, commissions, and variable delivery charges where applicable.

Use a consistent definition of a sellable unit. If one SKU is recorded by case and another by individual item, convert quantities before calculating their weights. If products consume very different production resources, this unit average can still describe sales mix, but it does not rank the best use of a constrained machine or labor hour.

Aggregate by SKU before calculating realized selling price and variable cost per unit. Match returns with their sales and cost reversals. For a forward plan, use the expected net price and variable cost rather than assuming historical averages will hold.

Keep fixed costs outside product contribution. Factory rent and salaried administrative costs enter the break-even calculation once, as a period total. The contribution margin glossary gives the underlying cost distinction.

Worked example: three kits sold by a US supplier

An illustrative US packaging supplier plans to sell 10,000 kits in one month. Each kit counts as one sellable unit. Prices and variable costs below are assumptions for that month; all dollar calculations are exact, and displayed percentages have no rounding difference.

Standard contributes 30 - 18 = $12 per unit. Its unit weight is 6,000 / 10,000 = 60%, so its contribution to the average is 12 x 60% = $7.20. Add all three weighted amounts: 7.20 + 7.20 + 0.60 = $15.00.

The simple average, (12 + 24 + 6) / 3 = $14, is wrong for this sales plan. It gives each product equal weight even though Standard accounts for most units.

Calculate the same result in Excel

Place the table's product rows in rows 2 through 4, with units in B, price in C, variable cost in D, contribution in E, weight in F, and weighted contribution in G. Enter these formulas in E2, F2, and G2, respectively:

=C2-D2
=B2/SUM($B$2:$B$4)
=E2*F2

Fill those formulas down. Calculate the average directly with:

=SUMPRODUCT(B2:B4,E2:E4)/SUM(B2:B4)

Microsoft documents SUMPRODUCT as multiplying corresponding entries and summing the results. Its ranges must have the same dimensions. Check for blank costs before calculation: the function treats nonnumeric entries as zero, which can overstate contribution.

Covirage is not affiliated with Microsoft. For more spreadsheet weighting examples, see weighted average in Excel.

The proof: rebuild total contribution

Multiply units by price, variable cost, and contribution for each product:

The identity is 15 x 10,000 = $150,000, which also equals 380,000 - 230,000. Both routes must agree before the average is used for planning. Tie revenue to the sales ledger and reconcile variable costs to the accounts classified as variable.

With fixed costs of $90,000, operating profit at planned volume is 150,000 - 90,000 = $60,000. Contribution is not profit until those fixed costs have been covered.

Convert the mix into break-even units

Break-even total units at a constant mix = Fixed costs / Weighted average contribution per unit

Here, 90,000 / 15 = 6,000 units. Allocate them using the same weights:

Revenue less variable costs is $90,000, exactly covering fixed costs. Profit is zero. The broader break-even analysis guide covers the single-product and revenue forms.

The same plan can be expressed as a composite basket of six Standard, three Premium, and one Compact kit. Its ten kits contribute 6 x 12 + 3 x 24 + 1 x 6 = $150. Break-even is 90,000 / 150 = 600 baskets, or the same 6,000 total kits.

Change one assumption: the unit mix

Suppose Premium gains 1,000 units from Standard while total volume, prices, and unit costs stay unchanged.

Weighted contribution rises to 162,000 / 10,000 = $16.20. Operating profit becomes 162,000 - 90,000 = $72,000, an improvement of $12,000 created entirely by mix.

The revised basket has five Standard, four Premium, and one Compact kit, contributing $162. Exact break-even is 90,000 / 162 = 555.555... baskets. Round up to 556 complete baskets, or 5,560 kits, to preserve the assumed mix. Those baskets contribute $90,072, leaving $72 after fixed costs; 555 baskets would leave a $90 loss.

Finance owns the cost definitions and reconciliation. Sales owns the feasible mix forecast, and operations confirms the capacity to supply it. A higher-contribution mix is useful only when customers will buy it and the business can deliver it.

Where it goes wrong

• Revenue weights used on unit contribution. That combines different measures. Use unit weights for dollars per unit and revenue weights for ratios.
• Fixed costs deducted twice. Keep fixed allocations out of variable unit costs when those same fixed costs form the break-even numerator.
• The old mix kept after a sales shift. Recalculate the weighted amount and the basket whenever the planned proportions change.
• Average units rounded without preserving mix. Round complete planning baskets when exact product proportions matter, then prove the resulting contribution.
• Incompatible units combined. Document case conversions and pack sizes so quantity changes represent actual changes in what is sold.

Check your product mix in Covirage

Bring product sales and variable-cost files with consistent SKU identifiers and unit definitions. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See customer profitability for the supporting product and customer analysis use case.