Question 4 (20 points). Consider the following linear program: Min 8X 12Y s.t.

Question: Question 4 (20 points). Consider the following linear program: Min 8X 12Y s.t. 1X 3Y 29 2X 2Y 210 6X 2Y 218 X,Y 20 a. Use the MS Excel Solver to find the optimal solution with sensitivity analysis and provide the reports by taking screenshot from excel. Provide screenshots for each excel sheet Your model sheet, excel solver screen (I want to see yourShow transcribed image text1. solution Decision variables X Y 3 2 Objective MINIMIZE 48 2. Name Final Value Reduced Costs Objective Value Allowable Increase Allowable Decrease X 3 0 8 4.0 4.0 Sensitivity analysis Sensitivity analysis (or post-optimality analysis) is used to de…View the full answerTranscribed image text: Question 4 (20 points). Consider the following linear program: Min 8X 12Y s.t. 1X 3Y 29 2X 2Y 210 6X 2Y 218 X,Y 20 a. Use the MS Excel Solver to find the optimal solution with sensitivity analysis and provide the reports by taking screenshot from excel. 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 this question. After providing report calculate the optimal solution. b. Based on the computer solution (sensitivity analysis report) for the linear program in part (a): Assume that the objective function coefficient for X changes from 8 to 6. Does the optimal solution change? C. Based on the computer solution (sensitivity analysis report) for the linear program in part (a): Assume that the objective function coefficient for X remains 8, but the objective function coefficient for Y changes from 12 to 6. Does the optimal solution change? d. Based on the computer solution (sensitivity analysis report) for the linear program in part (a): Determine the dual value for constraint 1. e. Based on the computer solution (sensitivity analysis report) for the linear program in part (a): Suppose that the right-hand side for constraint 1 is increased from 9 to 10. Find the new optimal solution. What does the right-hand-side range information for constraint 1 tell you about the dual value for constraint 12 f. The dual value for constraint 2 is 3. Using this dual value and the right-hand-side range information in part (a), what conclusion can be drawn about the effect of changes to the right- hand side of constraint 2?