Question 6 (25 points). Hart Manufacturing makes three products. Each product requires manufacturing operations

Question: Question 6 (25 points). Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and C. The labor-hour requirements, by department, are as follows: Department Product 1 Product 2 Product 3 A 1.50 3.00 2.00 B 2.00 1.00 2.50 C 0.25 0.25 0.25 During the next production period, the labor-hours availableSee the answerSee the answerSee the answer done loadingShow transcribed image textAnswer : Let Pi = units of product i produced Max 25P1 28P2 30P3 s.t. 1.5P1 3P2 2P3 = 450 2P1 1P2 2.5P3 = 350 .25P1 .25P2 .25P3 = 50 P1, P2, P3 = 0 b. The optimal solution is P1 = 60 P2 = 80 Value = 5540 P3 = 60 This solution provides…View the full answerTranscribed image text: Question 6 (25 points). Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and C. The labor-hour requirements, by department, are as follows: Department Product 1 Product 2 Product 3 A 1.50 3.00 2.00 B 2.00 1.00 2.50 C 0.25 0.25 0.25 During the next production period, the labor-hours available are 450 in department A, 350 in department B, and 50 in department C. The profit contributions per unit are $25 for product 1, $28 for product 2, and $30 for product 3. The production supervisors noted that production setup costs had not been taken into account. She noted that setup costs are $400 for product 1, $550 for product 2, and $600 for product 3. Management also stated that we should not consider making more than 175 units of product 1, 150 units of product 2, or 140 units of product 3. a. Formulate a linear programming model for maximizing total profit contribution. Solve the linear program formulated in part (a). using the MS Excel Solver. b. Provide screenshots for each excel sheet: Your model sheet, excel solver screen (I want to see your inputs to solver), answer report, sensitivity analysis (see Appendix for examples). If you will miss to provide the screenshot for MS Excel Solver Solution, you will be graded for zero for the solution part. How much of each product should be produced, and what is the projected total profit contribution? What is the total profit contribution after taking into account the setup costs?