Note: do not key into the shaded area, those are done for you. Some areas will...

Note: do not key into the shaded area, those are done for you. Some areas will update automatically as you fill out the problem Determine the sales mix based on unit sales for each product. Using the annual expected sales for these products determine the weighted average unit contribution margin for these three products ( round to two decimal places).
Part 1

(a)	Total Units
	Item	Units
	Sprinklers	460,000
	Valves	1,480,000
	Controllers	60,000
	Total Units	2,000000

	Sales Mix %
	Item	Percentage

	Sprinklers

	Valves

	Controllers



(b)	Per Unit
		Sprinklers	Valves	Controllers
	Sales price
	Variable costs:
	Manufacturing
	Selling & admin.
	Total variable costs
	Contribution margin


	Weighted-Average Unit Contribution Margin
				Weighted-Avg
		Unit CM X	Sales Mix % =	Unit CM
	Sprinklers	-	0%
	Valves	-	0%
	Controllers	-	0%
	Total

Question: Waterways has a sales mix of sprinklers, valves, and controllers as follows. Annual expected s...

Waterways has a sales mix of sprinklers, valves, and controllers as follows.

Annual expected sales:
Sale of sprinklers		460,000 units at $26.50
Sale of valves		1,480,000 units at $11.20
Sale of controllers		60,000 units at $42.50

Variable manufacturing cost per unit
Sprinklers	$13.96
Valves	$7.95
Controllers	$29.75
Fixed manufacturing overhead cost (total)		$760,000

Variable selling and administrative expenses per unit:
Sprinklers	$1.30
Valves	$0.50
Controllers	$3.41
Fixed selling and administrative expenses (total)		$1,600,000

Determine the sales mix based on unit sales for each product. (Round answers to 0 decimal places, e.g. 25%.)

Sprinklers %

Valves %

Controllers %

Expert Solution




(a)	Total Units
	Item	Units
	Sprinklers	4,60,000
	Valves	14,80,000
	Controllers	60,000
	Total Units	20,00,000

	Sales Mix %
	Item	Percentage

	Sprinklers	23.00%
	(460000/2000000)
	Valves	74.00%
	(1480000/2000000)
	Controllers	3.00%
	(60000/2000000)


(b)	Per Unit
		Sprinklers	Valves	Controllers
	Sales price	26.50	11.20	42.50
	Variable costs:
	Manufacturing	13.96	7.95	29.75
	Selling & admin.	1.30	0.50	3.41
	Total variable costs	15.26	8.45	33.16

	Contribution margin	11.24	2.75	9.34


	Weighted-Average Unit Contribution Margin
				Weighted-Avg
		Unit CM X	Sales Mix % =	Unit CM
	Sprinklers	11.24	23.00%	2.59
	Valves	2.75	74.00%	2.04
	Controllers	9.34	3.00%	0.28
	Total			4.90

ekkarill92 answered 1 year ago

What do you consider to be the key areas for developing quality metrics in home and...

What do you consider to be the key areas for developing quality metrics in home and community based care? Which ones are easier to measure than others?

In 2019, Lila Done Ltd explored two different areas of interest and spent $340,000 for Area...

In 2019, Lila Done Ltd explored two different areas of interest and spent $340,000 for Area X and $260,000 for Area Y. The results of exploration and evaluation (E&E) activities suggested that Areas X and Y may contain mineral reserves, so the company acquired leases over these two areas. The leases cost $300,000 for each area. In 2020, Lila Done Ltd commenced a drilling program to evaluate Areas X and Y. Two exploratory wells were drilled in Area X and...

In your opinion, should more be done to battle diabetes in your area, or do you...

In your opinion, should more be done to battle diabetes in your area, or do you feel that the services provided are Studies have found common features among high-performing health departments that manage diabetes. These departments may include receiving external funding for programming, having a self-management education program that is recognized by the American Diabetes Association, and having partnership opportunities. Using your local health department as the basis of study, discuss the diabetes programming and services it utilizes. In your...

What are the key categories of nontraditional marketing? Do you expect these areas to grow over...

What are the key categories of nontraditional marketing? Do you expect these areas to grow over the next decade? Why or why not?

NOTE: This is done using Visual Basic. Create an application named You Do It 2. Add...

NOTE: This is done using Visual Basic. Create an application named You Do It 2. Add a text box, a label, and a button to the form. Enter the following three Option statements above the Public Class clause in the Code Editor window: Option Explicit On, Option Strict Off, and Option Infer Off. In the button’s Click event procedure, declare a Double variable named dblNum. Use an assignment statement to assign the contents of the text box to the Double...

NOTE: This is done using Visual Basic. Create an application named You Do It 1. Add...

NOTE: This is done using Visual Basic. Create an application named You Do It 1. Add a text box, a label, and a button to the form. The button’s Click event procedure should store the contents of the text box in a Double variable named dblCost. It then should display the variable’s contents in the label. Enter the three Option statements above the Public Class clause in the Code Editor window, and then code the procedure. Save the solution and...

what are some of the key areas to which internal auditors can apply the use of...

what are some of the key areas to which internal auditors can apply the use of data analytics?

Find the area of the shaded region. The graph to the right depicts IQ scores of adults, and those scores are normally distributed with a mean of 100 and a standard deviation of 15.

Find the area of the shaded region. The graph to the right depicts IQ scores of adults, and those scores are normally distributed with a mean of 100 and a standard deviation of 15. The area of the shaded region is _______ (Round to four decimal places as needed.)Find the indicated IQ score. The graph to the right depicts IQ scores of adults, and those scores are normally distributed with a mean of 100 and a standard deviation of 15. The indicated...

4. What are the key activity areas for securities firms? How does each activity area assist...

4. What are the key activity areas for securities firms? How does each activity area assist in the generation of profits and what are the major risks for each area?

Find the area of a regular octagon of side 10 cm. (NOTE: Do not use the...

Find the area of a regular octagon of side 10 cm. (NOTE: Do not use the directed formula of the area of the polygon)

Question