Question 2 - Chapter 7: Integer Linear Programming Hint: For this question. you can nd similar example {Fixed Cost} in Chapter 7 slides between 19-25 {the excel le of this example in the lecture was RMCSetupxlsx}. This excel file belongs to the example. not to this question! Question 2 {40 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 l .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 (3. The prot 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 should be considered as well. 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 prot contribution. What is the linear programming model for this problem? Dene your decision variables and show your objective functions and constraints in your model. (10 points} Hint: Do not miss to create decision variables for set up costs as well. You need to come up with 6 decision variables. b. 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}. (15 points} Screenshot 1: Excel le that you build your model with Excel Solver parameters window open (See Appendix for example} Screenshot 2: Sensitivity Report {See Appendix for example} Screenshot 3: Answer Report {See Appendix for example) c. How much of each product should be produced? (5 points} d. What is the projected total profit contribution? (5 points} e. Which constraints are binding and what are the slack time in each department? (5 points} if you will miss to provide the screenshot for MS Excel Solver Solution, you will be graded for zero for the solution earl