196k views
3 votes
Waterways has a sales mix of sprinklers, valves, and controllers as follows. Annual expected sales:

Sale of sprinklers 512,712 units at $27.00
Sale of valves 1,580,862 units at $11.00
Sale of controllers 42,726 units at $43.00
Variable manufacturing cost per unit:
Sprinklers $14.00
Valves $8.00
Controllers $30.00
Fixed manufacturing overhead cost (total) $709,000

Variable selling and administrative expenses per unit:
Sprinklers $1.00
Valves $1.00
Controllers $3.00
Fixed selling and administrative expenses (total) $1,678,616

Required:
a. Determine the sales mix based on unit sales for each product.
b. Using the annual expected sales for these products, determine the weighted-average unit contribution margin for these three products.
c. Assuming the sales mix remains the same, what is the break-even point in units for these products?

User Ilyssis
by
5.8k points

2 Answers

3 votes

Final answer:

The sales mix based on unit sales for each product is 24.01% for sprinklers, 73.97% for valves, and 2.02% for controllers. The weighted-average unit contribution margin for these three products is $2.58. The break-even point in units for these products is 925,181.

Step-by-step explanation:

To determine the sales mix based on unit sales for each product, we need to calculate the percentage of total unit sales for each product. The total unit sales is the sum of the unit sales for each product, which is 512,712 (sprinklers) + 1,580,862 (valves) + 42,726 (controllers) = 2,136,300 units. The sales mix for sprinklers is 512,712 / 2,136,300 = 0.2401 or 24.01%, the sales mix for valves is 1,580,862 / 2,136,300 = 0.7397 or 73.97%, and the sales mix for controllers is 42,726 / 2,136,300 = 0.0202 or 2.02%.

The weighted-average unit contribution margin can be calculated by multiplying the unit contribution margin for each product by its sales mix, and then summing up the results. The unit contribution margin is the selling price per unit minus the variable manufacturing cost per unit minus the variable selling and administrative expenses per unit. For sprinklers, the unit contribution margin is $27.00 - $14.00 - $1.00 = $12.00. For valves, the unit contribution margin is $11.00 - $8.00 - $1.00 = $2.00. For controllers, the unit contribution margin is $43.00 - $30.00 - $3.00 = $10.00. The weighted-average unit contribution margin is (0.2401 * $12.00) + (0.7397 * $2.00) + (0.0202 * $10.00) = $2.58.

To calculate the break-even point in units, we need to divide the fixed manufacturing overhead cost plus the fixed selling and administrative expenses by the weighted-average unit contribution margin. The fixed manufacturing overhead cost is $709,000 and the fixed selling and administrative expenses are $1,678,616, so the total fixed costs is $709,000 + $1,678,616 = $2,387,616. The break-even point in units is $2,387,616 / $2.58 = 925,181 units.

User MysteryGuy
by
4.8k points
6 votes

Answer:

Waterways

Sprinklers Valves Controllers

a. Sales mix in units 12 37 1

or in percentage 24% 74% 2%

b. The weighted-average unit contribution margin

= $4.56

c. Break-even points in units

= 523,600 units

Step-by-step explanation:

a) Data and Calculations:

Sprinklers Valves Controllers Total

Annual expected sales 512,712 1,580,862 42,726 2,136,300

Sales price per unit $27.00 $11.00 $43.00

Variable costs per:

Manufacturing 14.00 8.00 30.00

Selling and Admin. expense 1.00 1.00 3.00

Total variable costs per unit $15.00 $9.00 $33.00

Contribution margin per unit $12.00 $2.00 $10.00

Fixed manufacturing cost = $709,000

Fixed selling and admin exp. = $1,678,616

Total fixed costs = $2,387,616

Sales mix based on unit sales 0.24 0.74 0.02

= 12 37 1

Weighted-average unit contribution margin

= $12 * 0.24 + $2.00 * 0.74 + $10 * 0.02

= $2.88 + $1.48 + $0.20

= $4.56

Break-even point in units = Fixed costs/Weighted-average Contribution margin per unit

= $2,387,616/$4.56

= 523,600 units

User Mengo
by
5.4k points