218k views
5 votes
Kidd Company produces two products. Budgeted annual income statements for the two products are provided as follows. Power Lite Total Budgeted Per Budgeted Budgeted Per Budgeted Budgeted Budgeted Number Unit Amount Number Unit Amount Number Amount Sales 160 @ $ 500 = $ 80,000 640 @ $ 450 = $ 288,000 800 $ 368,000 Variable cost 160 @ 320 = (51,200 ) 640 @ 330 = (211,200 ) 800 (262,400 ) Contribution margin 160 @ 180 = 28,800 640 @ 120 = 76,800 800 105,600 Fixed cost (12,000 ) (54,000 ) (66,000 ) Net income $ 16,800 $ 22,800 $ 39,600 Required Based on budgeted sales, determine the relative sales mix between the two products. Determine the weighted-average contribution margin per unit. Calculate the break-even point in total number of units. Determine the number of units of each product Kidd must sell to break even. Verify the break-even point by preparing an income statement for each product as well as an income statement for the combined products. Determine the margin of safety based on the combined sales of the two products.

User Rakke
by
4.6k points

2 Answers

4 votes

Final Answer:

The relative sales mix between the two products is 20% for Power Lite and 80% for Total. The weighted-average contribution margin per unit across both products is $132. The break-even point in total number of units is 627 units. Kidd must sell 127 units of Power Lite and 500 units of Total to break even. The margin of safety, based on combined sales, is $107,600.

Step-by-step explanation:

To determine the relative sales mix, divide the budgeted sales for each product by the total budgeted sales. For Power Lite, $80,000 / $368,000 = 0.217, or 21.7%. For Total, $288,000 / $368,000 = 0.783, or 78.3%. Thus, the sales mix is 21.7% for Power Lite and 78.3% for Total.

The weighted-average contribution margin per unit is found by considering the contribution margin per unit for each product and their respective sales mix. Multiply the contribution margin per unit of Power Lite ($180) by its sales mix (0.217), and do the same for Total ($120 * 0.783). Then sum these values: ($180 * 0.217) + ($120 * 0.783) = $39.06 + $93.96 = $132. This weighted-average contribution margin represents the average contribution per unit across both products.

The break-even point in total number of units is calculated by dividing the total fixed costs ($66,000) by the weighted-average contribution margin per unit ($132), resulting in 500 units. To determine how many units of each product Kidd must sell to break even, use the sales mix percentages. For Power Lite, 500 units * 0.217 = 127 units. For Total, 500 units * 0.783 = 393 units. Therefore, Kidd must sell 127 units of Power Lite and 393 units of Total to break even.

Finally, to find the margin of safety based on combined sales, subtract the break-even sales revenue ($368,000) from the actual budgeted sales revenue ($475,600). The margin of safety is $475,600 - $368,000 = $107,600. This indicates how much sales can decline before the company reaches the break-even point.

User Neal Stublen
by
5.6k points
4 votes

Answer:

  • Determine the relative sales mix between the two products

PRODUCT 1 20%

PRODUCT 2 80%

  • Determine the weighted-average contribution margin per unit

PRODUCT 1 $ 36

PRODUCT 2 $ 96

Total Contr. Margin $ 132

  • Calculate the break-even point in total number of units

Total UNITS 500 Quantity

$ 66.000 Contributing Margin

-$ 66.000 Anual Fixed Costs

$ 0 Segment Margin

  • Determine the number of units of each product Kidd must sell to break even

PRODUCT 1 67 Quantity

$ 12.000 Contributing Margin

-$ 12.000 Anual Fixed Costs

$0 Segment Margin

PRODUCT 2 450 Quantity

$ 54.000 Contributing Margin

-$ 54.000 Anual Fixed Costs

$0 Segment Margin

  • Verify the break-even point by preparing an income statement for each product as well as an income statement for the combined products.

PRODUCT 1 BREAK EVEN POINT

Quantity Unit TOTAL Income Statement

67 $ 500 $ 33.333 Total Net Sales

$ 320 -$ 21.333 Variable Cost

$ 180 $ 12.000 Contributing Margin

-$ 12.000 Anual Fixed Costs

$0 - Segment Margin

PRODUCT 2 BREAK EVEN POINT

Quantity Unit TOTAL Income Statement

450 $ 450 $ 202.500 Total Net Sales

$ 330 -$ 148.500 Variable Cost

$ 120 $ 54.000 Contributing Margin

-$ 54.000 Anual Fixed Costs

$0 - Segment Margin

  • Determine the margin of safety based on the combined sales of the two products.

Margin Safety Actual Sales 800 $ 368.000

Break Even Point 517 $ 235.833

RATIO 283 132.167 36%

Step-by-step explanation:

User Nicolas Voron
by
5.5k points