Weighted Average Unit Contribution Margin

The unit contribution margin for a product is the difference between the selling price and the cost price. So for example, if a business sells only one product with a selling price of 20.00 and a cost of 7.00, then the unit contribution margin for the product and the business is 20.00 – 7.00 = 13.00.

The problem becomes more complicated when a business sells multiple products. Each product will have a different contribution margin, and therefore to establish the overall unit contribution margin for the business, the contribution from each product must be weighted in proportion to the number of units of that product sold (sometimes referred to as the unit sales mix). The resultant unit contribution is known as the weighted average unit contribution margin.

Suppose, for example, that a business sells five products with contribution margins and unit sales mix percentages as follows:

Multiple products margin and unit sales mix
Product Margin Mix %
A 2.46 20%
B 5.90 19%
C 12.00 26%
D 18.90 14%
E 22.00 21%

While the individual contribution margins of each product are known, the overall unit contribution margin of the business needs to be calculated using the weighted average contribution margin per unit formula.

Weighted Average Unit Contribution Margin Formula

The weighted average unit contribution margin formula takes each products unit contribution, and weights it in proportion to its unit sales mix percentage as follows:

Weighted average unit contribution margin = Contribution A x Sales mix % A + Contribution B x Sales mix % B + ... Contribution E x Sales mix % E
Weighted average unit contribution margin = 2.46 x 20% + 5.90 x 19% + 12.00 x 26% + 18.90 x 14% + 22.00 x 21%
Weighted average unit contribution margin = 12.00

Providing the unit sales mix percentages remain constant, for every product sold by this business, on average it will receive a unit contribution margin of 12.00.

Using the Weighted Average Unit Contribution Margin

The most important use for the weighted average unit contribution margin is in the calculation of the break even point for a multiple product business.

The break even formula is as follows:

Break even units = Operating expenses / Contribution margin per unit

For a multiple product business, the weighted average unit contribution margin is simply substituted into the formula. For our example above, if the fixed operating expenses were 96,000, then the break even units is given as follows:

Break even units = Operating expenses / Weighted average unit contribution margin
Break even units = 96,000 / 12.00
Break even units = 8,000

The business needs to sell 8,000 units to break even. For this calculation to work, the unit sales mix percentages must remain constant, and the units must be sold in the correct proportions as follows:

Allocation of break even units
Product Mix % Units
A 20% 1,600
B 19% 1,520
C 26% 2,080
D 14% 1,120
E 21% 1,680
Total 100% 8,000

The total contribution margin from these products is as follows:

Contribution = 2.46 x 1,600 + 5.90 x 1,520 + 12.00 x 2,080 + 18.90 x 1,120 + 22.00 x 1,680 Contribution = 95,992 rounded to 96,000

As the operating expenses were also 96,000 the business will break even at this level of unit sales for each of the five products.

Weighted Average Unit Contribution Margin November 6th, 2016Team

You May Also Like

Related pages

economic entity assumption definitionaccruals and prepayments double entryperpetual inventory using fifosupplier reconciliation templateaccruals entriesuncleared cheques in bank reconciliationadjustment journal entriesfinance lease vs operating lease accountingadjusting entries problemshow do you figure out markup percentagewhat are accrued revenuescurrent liabilities definition in accountinghow to calculate vertical analysis percentagesday sales outstanding calculationhow to record payroll journal entriespayment voucher word formatdirect material usage variance formulaproject completion method of accountinghow to calculate future value in excelcost of good sold on balance sheetannuity present value formulaaccounting templates excelaccured expenseredeemable convertible preferred stocksales and purchase ledgersroyalty expense on income statementprepaid rental incomenpv calculator excelreceivables turnover ratio calculationexcel basics quizwip in manufacturingdefine accrued incomegoodwill accounting treatment exampleclaim receivable on balance sheetjournal entry to record accounts receivableconverting preference sharesshare repurchase journal entrycredit noesimple expenses claim form templatemonthly balance sheet template exceleffective interest rate exceldisposal of fixed assets double entryfifo perpetualannuity and perpetuity formulassample voucher receipta subsidiary ledgerreducing balance depreciation methodsprepaid rent journal entry adjusting entrycarriage inward meaningaccounts receivable age analysisebit interest coverpresent value of infinite cash flowdouble declining method examplewhat does manufacturing overhead includeexamples of ledger entries for accountingdefine debtorwhat is materials requisitionpmt dividendcalculate total variable costpetty cash voucher templateaccount receivable days formuladefine deferred tax assetrequisition slip sampleytm definitionstatement of retained earnings formulaaccounting principles quizaccounting reversing entriesmeaning of accrued revenuejournal for accountingwarranty journal entrydepreciation reducing balance formula