Sensitive analysis

QUESTION 5: Sensitivity Analysis (25 Points) Use the following Management Scientist output to answer the questions. Given results after developing the excel LP and Solver: Excel program MIN 4X1+5X2+2X3 X1 X2 X3 S.T. Final Value 0 55 30 Total X1+X2+X3 280 Solver Sensitivity Report: Variable Cells 2X1+4X2+4X3>320 Final Reduced Objective Allowable Allowable Name Value Cost Coefficient Increase Decrease a. What is the optimal solution, and what is the value of the profit contribution? X1 0 0.5 1E+30 0.5 X2 55 0 5 1 b. Which constraints are binding? X3 30 0 2 0.5 1E+30 c. What are the dual prices for each resource? Interpret. Constraints Final Shadow Constraint Allowable Allowable d. Compute and interpret the ranges of optimality. Name Value Price R.H. Side Increase Decrease Constraint 1 85 -1 85 55 5 Constraint 2 280 1.5 280 60 110 Constraint 3 340 0 320 20 1E+30 20 minutes on slide 04:37 PM ADEENG O W 30 C Mostly cloudy 11-08-2021