B G H O Q W A200 Units Fabrication Molding Machinery Assemble & Pack 0 500 1000 1500 2000 8100 Units 2500 2500 3000 -3000 3500 4000 -2000 0 Requirements 1-3 Requirement 4 Requirement 5 Requirement 7 Requirement 8 + Ready 100%Required information [The foiiowing information appiies to the questions dispiayed bellow} Conroy Company manufactures two products3100 and A200. The company provided the following information with respect to these products: 8189 A289 Estimated customer" demand (in units) 2,866 2,966 Selling price per' unit $1,266 $2,166 Variable expenses per unit $ 2'66 $1,266 The company has four manufacturing departmentsFabrication, 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 these departments is as follows: 8166 A266 Capacity (hours per' unit) (hours per' unit) (in hours) Fabrication 1 2 4,666 Holding 2 2 6,866 Machining 2 6 5,666 Assemble 81 Pack 6 3 4,566 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. Click here to download the Excel template which you will use to answer the questions that follow. Click here for a brief tutorial on SOLVER in Excel. Click here for a a brief tutorial on Charts in Excel. 6. Referto the graph that you prepared in requirement 5: 3. Where does the answer from requirement 3d plot on the graph? b. Where does the answer from requirement 4a plot on the graph? c. In essence. what is Solver doing when it calculates its optimal solution