6 (25 points). Chapter 7: Integer Linear Programming 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 ABC Product 1 Product 2 Product 3 1.50 3.00 2.00 2.00 1.00 2.50 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. b. Formulate a linear programming model for maximizing total profit contribution. Solve the linear program formulated in part (a). using the MS Excel Solver. 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