12 Problem 18-7A Break-even analysis with composite units LO P4 10 points Patriot Co. manufactures and sells three products: red, white, and blue. Their unit selling prices are red, $58: white, $88; and blue, $113. The per unit variable costs to manufacture and sell these products are red. $43; white. $63; and blue, $83. Their sales mix is reflected in a ratio of 5:42 (red:white:blue). Annual fixed costs shared by all three products are $153.000. One type of raw material has been used to manufacture all three products. The company has developed a new material of equal quality for less cost. The new material would reduce variable costs per unit as follows: red, by $13, white, by $23; and blue, by $13. However, the new material requires new equipment, which will increase annual fixed costs by $23,000. Required: 1. Assume if the company continues to use the old material, determine its break-even point in both sales units and sales dollars of each individual product. 2 Assume if the company uses the new material, determine its new break-even point in both sales units and sales dollars of each Individual product. Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Assume if the company uses the new material, determine its new break-even point in both sales units and sales dollars of each individual product. (Round composite units up to next whole number.) 2. Determine its break-even point in both sales units and sales dollars of each individual product. Determine the selling price per composite unit. Ratio Selling price per unit Total per composite unit Red 5 IS 58.00 $ 290.00 White 4 88.00 352.00 Blue 2 113.00 228.00 $ 888.00 Determine the variable costs per composite unit. Ratio Variable cost per unit Total per composite unit Red 5 S 13.00 $ 65.00 White 4 23.00 92.00 Blue 2 13.00 26.00 S 183.00 Determine the break-even point in composite units. Choose 1 Numerator: Choose Denominator: Break Even Units Total fixed costs 1 Contribution margin per unit Break even units $ 175.000 $ 685.00 - 257 composite units Determine its break-even point in units and sales dollars of each individual product. Number Units sales at Dollar sales at per Number of composite units composite to break even the break-even the break-even point unit point Red 5 257 117 XS 6.788 White 4 257 1,028 90.484 Blue 2 257 514 58,082 =