Weighted Average Contribution Margin Calculator

Work out the blended contribution margin across your product mix and the units you must sell to break even.

How it is calculated

Each product's contribution margin is price − variable cost per unit. The mix numbers (any scale, such as percentages or unit counts) are first turned into shares that add up to 1. The blended margin is the share-weighted sum of the three unit margins, and the blended price is the share-weighted sum of the three prices. Then CM ratio = blended CM ÷ blended price × 100 and break-even units = fixed costs ÷ blended CM, rounded up to a whole unit. Break-even revenue is the unrounded break-even units times the blended price. These are units of the composite package at your mix, not per product. If the blended margin is zero or negative, the tool shows "Never" because fixed costs can never be covered at that mix. Prices, costs and mix cannot be negative, and the mix cannot be all zero.

Worked example

Product A sells for 50 with variable cost 30 (margin 20), B for 80 with cost 45 (margin 35), C for 120 with cost 70 (margin 50). The mix is 50, 30, 20, so the shares are 0.5, 0.3 and 0.2, and fixed costs are 40000. The blended margin is 20 × 0.5 + 35 × 0.3 + 50 × 0.2 = 30.50, shown as "$30.50". The blended price is 25 + 24 + 24 = $73.00, so the CM ratio is 30.5 ÷ 73 = 41.78%. Break-even is 40000 ÷ 30.5 = 1311.5, rounded up to 1,312 units, with revenue of $95,737.70. At that volume, 656 units are A, 394 are B and 262 are C.

Try this example →

Common mistakes

  • Entering the sales mix as revenue shares instead of unit shares: the weights must be shares of units sold, otherwise the blended margin per unit is wrong.
  • Putting total cost, not variable cost, in the cost fields; fixed costs belong only in the separate fixed-cost field.
  • Reading the break-even units as a figure for each product; it is the total across the three, split by your mix.
  • Leaving a product's mix at 0 but still entering prices for it: it simply drops out of the average, so the blended numbers describe only the other products.
  • Expecting the break-even revenue to equal the rounded units times blended price: revenue uses the unrounded units, so it can differ slightly.

About this calculator

When a company sells more than one product, a single overall contribution margin only makes sense as a weighted average — each product’s contribution margin (price minus variable cost) blended according to its share of the total sales mix, since a low-margin, high-volume item and a high-margin, low-volume item pull the blended number in opposite directions.

That weighted average CM is what turns multi-product break-even analysis from guesswork into arithmetic: total fixed costs divided by the weighted average contribution margin (in dollars per unit, or as a ratio against weighted average price) gives the combined unit volume — split across the product mix — the business needs to sell before it starts generating profit. This is a core piece of cost-volume-profit (CVP) analysis used by managerial accountants and CFOs to set sales targets and evaluate how a shift in product mix changes profitability.

Was this helpful?

You can pick up to 3 reactions.

Comments

  • Be the first to comment.

Popular calculators

All Calculators