5: Sensitivity Analysis (25 marks) Using the Excel Solver results in Table, address the following questions: a. How much is reduced cost of "Number produced ASAN" and how should we interpret this value? (4 marks) Given results after developing the excel LP and Solver: 18 minutes on slide Solvex Sansitivity Report: Variable Cals Final Reduced Objective Allowable Allowable Name Value Cust Cocident Increase Decrease SB$21 Number produced ASAN 0 -15 15 15 1E+15 Number produced HANA 175 0 30 TE+30 2 Cdi b. $C$21 Calculate the expected objective function's value if the coefficient of Number produced ASAN changes to 25. (4 marks) Solver Constraints Call Final Shadow Valne Price 875 0 Name SB$25 Cotton Amount Used $B$26 Leather Amount Used $B$27 Labor Amount Used C. Constraint Allowable Allowable R. Side Inorcase Dearcase 1000 L-130 120 900 1E130 250 700 40 360 700 0 700 What happens to the optimal value of the objective function if the coefficient of "Number produced HANA changes to 26 and the other coefficient changes to 20? (6 marks) 20 e. How much should the management pay for an additional 35 units of Labor Amount Used considering it to be a sunk cost? (3 marks) d. f. What % of available Cotton Amount Used can be decreased without the current (given) optimum solution changing? (4 Marks) What % of "Labor Amount Used can be increased without changing the optimal solution? (4 marks) Tint