CMA Study Group

How have the weights been assigned: 83.3% and 16.7%?

  • 1.  How have the weights been assigned: 83.3% and 16.7%?

    Posted 21 days ago

    Sheltie Company sells both lamps and clocks. Consider the following per unit data:

    Unit DataLampsClocks
    Selling price$75$45
    Variable costs830
    Contribution margin$27$15
    Sales mix31

    What is the total revenue in lamps Sheltie Company will need to break even if fixed costs are $149,952?

    Solution: The general breakeven point formula for revenues is Fixed Costs ÷ Contribution Margin Ratio. A multi-product firm needs to use the overall contribution margin ratio rather than the contribution margin ratio for an individual product. It is based on the individual contribution margin ratios and the sales mix. While the sales mix is 75% lamps and 25% clocks based on units sold, it is 83.3% lamps and 16.7% clocks based on revenue (3 lamps generate $225 of revenue and 1 clock generates $45 of revenue). The contribution margin ratio is 36% for lamps ($27 ÷ $75) and 33.3% for clocks ($15 ÷ $45). Sheltie's overall contribution margin ratio is 35.6% (36% × 83.3% + 33.3% × 16.7%). This results in needing to generate $421,740 in revenue to break even ($149,952 ÷ 35.6%). Once the total revenue needed is determined, the sales mix based on revenues is used to determine how much revenue each product needs to generate to break even. Based on Sheltie's sales mix, it needs to generate $351,450 in revenue from lamps to break even (83.3% × $421,740).



  • 2.  RE: How have the weights been assigned: 83.3% and 16.7%?

    Posted 21 days ago
    Hi @Nasira Hameduddin,

    The 83.3% lamps and 16.7% clocks are allocated as follows (just as it is explained in your solution explanation):

    • 3 lamps * $75 selling price per unit = $225 revenue for 3 lamps
    • 1 clock * $45 selling price per unit = $45 revenue for 1 clock
    • Total revenues = $225 + $45 = $270
    • 3 lamps = $225/$270 = .83 or 83.3%  AND 1 clock = $45/$270 = .167 or 16.7%

    I hope this helps!



    ------------------------------
    Daniel Jo, CPA
    Internal Auditor - Risk & Control
    Sunnyvale, CA
    United States
    ------------------------------