Walton 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 120 @ $ 680 = $ 81,600 1,080 @ $ 620 = $ 669,600 1,200 $ 751,200 Variable cost 120 @ 430 (51,600) 1,080 @ 370 = (399,600) 1,200 (451,200) Contribution margin 120 @ 250 = 30,000 1,080 @ 250 = 270,000 1,200 300,000 Fixed cost (18,000) (182,000) (200,000) Net income $ 12,000 $ 88,000 $ 100,000 Required: a. Based on budgeted sales, determine the relative sales mix between the two products. b. Determine the weighted-average contribution margin per unit. c. Calculate the break-even point in total number of units. d. Determine the number of units of each product Walton must sell to break even. e. Verify the break-even point by preparing an income statement for each product as well as an income statement products. f. Determine the margin of safety based on the combined sales of the two products. combined Complete this question by entering your answers in the tabs below. Required A Required B Required c Required D Required E Required F Based on budgeted sales, determine the relative sales mix between the two products. % Relative percentage for Power Relative percentage for Lite % Walton 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 120 @ $ 680 $ 81,600 1,080 @ $ 620 = $ 669,600 1,200 $ 751,200 Variable cost 120 @ 430 (51,600) 1,080 @ 370 (399,600) 1,200 (451,200) Contribution margin 120 @ 250 30,000 1,080 @ 250 = 270,000 1,200 300,000 Fixed cost (18,000) (182,000) (200,000) Net income $ 12,000 $ 88,000 $ 100,000 - Required: a. Based on budgeted sales, determine the relative sales mix between the two products. b. Determine the weighted-average contribution margin per unit. c. Calculate the break-even point in total number of units. d. Determine the number of units of each product Walton must sell to break even. e. Verify the break-even point by preparing an income statement for each product as well as an income statement for the combined products. f. Determine the margin of safety based on the combined sales of the two products. Complete this question by entering your answers in the tabs below. Required A Required B Required c Required D Required E Required F Determine the weighted-average contribution margin per unit. Weighted-average contribution margin per unit Walton 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 120 @ $ 680 = $ 81,600 1,080 @ $ 620 = $ 669,600 1,200 $ 751,200 Variable cost 120 @ 430 = (51,600) 1,080 @ 370 = (399,600) 1,200 (451, 200) Contribution margin 120 @ 250 = 30,000 1,080 @ 250 270,000 1,200 300,000 Fixed cost (18,000) (182,000) (200,000) Net income $ 12,000 $ 88,000 $ 100,000 Required: a. Based on budgeted sales, determine the relative sales mix between the two products. b. Determine the weighted-average contribution margin per unit. c. Calculate the break-even point in total number of units. d. Determine the number of units of each product Walton must sell to break even. e. Verify the break-even point by preparing an income statement for each product as well as an income statement for the combined products. f. Determine the margin of safety based on the combined sales of the two products. Complete this question by entering your answers in the tabs below. Required A Required B Required c Required D Required E Required F Calculate the break-even point in total number of units. Break-even point units Walton 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 120 @ $ 680 $ 81,600 1,080 @ $ 620 = $ 669,600 1,200 $ 751,200 Variable cost 120 @ 430 (51,600) 1,080 @ 370 (399,600) 1,200 (451,200) Contribution margin 120 @ 250 = 30,000 1,080 @ 250 270,000 1,200 300,000 Fixed cost (18,000) (182,000) (200,000) Net income $ 12,000 $ 88,000 $ 100,000 Required: a. Based on budgeted sales, determine the relative sales mix between the two products. b. Determine the weighted average contribution margin per unit. c. Calculate the break-even point in total number of units. d. Determine the number of units of each product Walton must sell to break even. e. Verify the break-even point by preparing an income statement for each product as well as an income statement for the combined products. f. Determine the margin of safety based on the combined sales of the two products. Complete this question by entering your answers in the tabs below. Required A Required B Required c Required D Required E Required F Determine the number of units of each product Walton must sell to break even. units Required sales for Power Required sales for Lite units Walton 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 120 @ $ 680 = $ 81,600 1,080 @ $ 620 = $ 669,600 1,200 $ 751,200 Variable cost 120 @ 430 = (51,600) 1,080 @ 370 = (399,600) 1,200 (451,200) Contribution margin 120 @ 250 = 30,000 1,080 @ 250 = 270,000 1,200 300,000 Fixed cost (18,000) (182,000) (200,000) Net income $ 12,000 $ 88,000 $ 100,000 Required: a. Based on budgeted sales, determine the relative sales mix between the two products. b. Determine the weighted average contribution margin per unit. c. Calculate the break-even point in total number of units. d. Determine the number of units of each product Walton must sell to break even. e. Verify the break-even point by preparing an income statement for each product as well as an income statement for the combined products. f. Determine the margin of safety based on the combined sales of the two products. Complete this question by entering your answers in the tabs below. Required A Required B Required c Required D Required E Required F Verify the break-even point by preparing an income statement for each product as well as an income statement for the combined products. Power Lite Total Sales Variable costs Contribution margin Fixed cost Net income (Loss) Unit Walton 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 Amount Number Unit Amount Number Amount Sales 120 @ $ 680 = $ 81,600 1,080 @ $ 620 = $ 669,600 1,200 $ 751,200 Variable cost 120 430 (51,600) 1,080 @ 370 = (399,600) 1,200 (451,200) Contribution margin 120 @ 250 30,000 1,080 @ 270,000 1,200 300,000 Fixed cost (18,000) (182,000) (200,000) Net income $ 12,000 $ 88,000 $ 100,000 250 = Required: a. Based on budgeted sales, determine the relative sales mix between the two products. b. Determine the weighted average contribution margin per unit. c. Calculate the break-even point in total number of units. d. Determine the number of units of each product Walton must sell to break even. e. Verify the break-even point by preparing an income statement for each product as well as an income statement for the combined products. f. Determine the margin of safety based on the combined sales of the two products. Complete this question by entering your answers in the tabs below. Required A Required B Required c Required D Required E Required F Determine the margin of safety based on the combined sales of the two products. (Round your answer to 1 decimal place. (i.e., 0.234 should be entered as 23.4)) Margin of safety %