Excel program Question 4: Sensitivity Analysis (16 Points) FB Farnoosh Bagh Product X 4 Product Y 3 Availability 60 Ajang De 2 5 50 Excel's Solver tool has been used in the spreadsheet below to solve a linear programming problem with a minimization objective function and all > constraints. Anirudh CF Material 1 Material 2 Material 3 Cost/unit 9 8 144 G $4 Gran B $5 HK Harios 9.6 7.2 Number produced Cost Total $76.8 $48 $28.8 W Solver Sensitivity Report: WK Variable Cells 1) What are the Binding Constraints and the Optimum amount of Objective Function? 2) What are the slack/surplus values for Material 1, Material 2 and Material 3? 3) Looking at the Shadow prices, how much would the objective function change by if Material 2 is increases by 5 units? 4) What % of available Material 3 can be reduced without it affecting the current (given) optimum solution? 5) Why the amount of reduced costs are zero? Final Value Reduced Cost Objective Coefficient Allowable Decrease Allowable Increase Name 0.33 0.5 M 5 9.6 0 Product X 0.44 0.25 4 7.2 0 Product Y Constraints Final Value Allowable Decrease Shadow Price Constraint R.H. Side Allowable Increase 6 Name 0.9 60 Given results after developing the excel LP and Solver: 60 0.8 1+30 Material 1 5.2. 55.2 0 50 1.9 Material 2 16 144 0.2 144 Material 3 25 minutes on slide