Conroy Company manufactures two products-B100 and A200. The company provided the following information with respect to these products: Estimated customer demand (in units) Selling price per unit Variable expenses per unit B100 2,800 $1,200 $ 700 Azee 2,000 $2,100 $1,2ee The company has four manufacturing departments-Fabrication, Molding, Machining, and Assemble & Pack. The capacity available in each department (in hours) and the demands that one unit of each of the company's products makes on thos departments is as follows: B180 A200 Capacity (hours per unit) Chours per unit) (in hours) Fabrication 4,000 Molding 6,000 Machining 5,000 Assemble & Pack 4,5ee 2 2 e The company is trying to decide what product mix will maximize profits. Given that its fixed costs will not change regardless of the chosen mix, the company plans to identify the product mix that maximizes its total contribution margin Conroy Company Volume Trade-Off Decisions with More Than One Constraint Contribution Margin Analysis 3100 A200 3100 Max Units A200 Units sold Selling price Variable expense per unit Contribution margin per unit Contribution margin per hour Departmental Datat Hours Demanded per unit and Capacity Available 3100 A200 Capacity (Hours per Unit) (Hours per Unit) (in Hours) Fabrication 1 2 4,000 Molding 2 2 6,000 Machining 2 0 5,000 Assemble & Pack 0 3 4,500 $ $ S 5 $ 7005 1700) (350) S 2.100 1,200 900 300 B100 A200 Total Sales Variable expenses Contribution margin 5 $ 5 $ $ $ S $ $ Departmental Data:Used vs. Unused Capacity (in Hours) 3100 A200 Used Fabrication Molding Machining Assemble & Pack Unused 4.000 6,000 5,000 4,500 8. In the Excel template, navigate to the "Requirement 8" tab. Using Solver: a. What is the maximum contribution margin the company can earn with its available resources if it increases the price of 8100 to $1,400? b. How many units of each product is the company producing to earn the contribution margin from requirement 8a? c. is your answer to requirement 8a greater than less than or equal to your answer from requirement 7d? Reg SALE Reg BB Req 8C What is the maximum contribution margin the company can earn with its available resources if it increases the price of 8100 to $1,4002 Madmum contribution margin $1,750,000 How many units of each product is the company producing to earn the contribution margin from requirement sa? Product A200 Product B100 500 2,500 units units Conroy Company manufactures two products-B100 and A200. The company provided the following information with respect to these products: Estimated customer demand (in units) Selling price per unit Variable expenses per unit B100 2,800 $1,200 $ 700 Azee 2,000 $2,100 $1,2ee The company has four manufacturing departments-Fabrication, Molding, Machining, and Assemble & Pack. The capacity available in each department (in hours) and the demands that one unit of each of the company's products makes on thos departments is as follows: B180 A200 Capacity (hours per unit) Chours per unit) (in hours) Fabrication 4,000 Molding 6,000 Machining 5,000 Assemble & Pack 4,5ee 2 2 e The company is trying to decide what product mix will maximize profits. Given that its fixed costs will not change regardless of the chosen mix, the company plans to identify the product mix that maximizes its total contribution margin Conroy Company Volume Trade-Off Decisions with More Than One Constraint Contribution Margin Analysis 3100 A200 3100 Max Units A200 Units sold Selling price Variable expense per unit Contribution margin per unit Contribution margin per hour Departmental Datat Hours Demanded per unit and Capacity Available 3100 A200 Capacity (Hours per Unit) (Hours per Unit) (in Hours) Fabrication 1 2 4,000 Molding 2 2 6,000 Machining 2 0 5,000 Assemble & Pack 0 3 4,500 $ $ S 5 $ 7005 1700) (350) S 2.100 1,200 900 300 B100 A200 Total Sales Variable expenses Contribution margin 5 $ 5 $ $ $ S $ $ Departmental Data:Used vs. Unused Capacity (in Hours) 3100 A200 Used Fabrication Molding Machining Assemble & Pack Unused 4.000 6,000 5,000 4,500 8. In the Excel template, navigate to the "Requirement 8" tab. Using Solver: a. What is the maximum contribution margin the company can earn with its available resources if it increases the price of 8100 to $1,400? b. How many units of each product is the company producing to earn the contribution margin from requirement 8a? c. is your answer to requirement 8a greater than less than or equal to your answer from requirement 7d? Reg SALE Reg BB Req 8C What is the maximum contribution margin the company can earn with its available resources if it increases the price of 8100 to $1,4002 Madmum contribution margin $1,750,000 How many units of each product is the company producing to earn the contribution margin from requirement sa? Product A200 Product B100 500 2,500 units units