Question 5: Sensitivity Analysis (25. marks) Using the Excel Solver results in Table, address the following questions: Glyen results after developing the excel LP and Solver: 18 minutes on slide we 4 How much is reduced cost of "Number produced ASAN" and how should we interpret this value? (4 marks) Med Objective va Owl Oct 0 18 15 0 30 Allowwhile Allowable TTT Deere 15 115 IRO 2 de AKAN RAMA HU 115 Price b. Calculate the expected objective function's value if the coefficient of "Number produced ASAN" changes to 25. (4 marks) Thes Vah 8751 700 Rade 1000 Allow Allowable Decre 130 120 LEJO 250 40 900 15 KAU 20 Leather Am KEIT Law AU 0 20 Tool 700 360 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) c. How much should the management pay for an additional 35 units of "Labor Amount Used" considering it to be a sunk cost? (3 marks) f. What % of "Labor Amount Used" can be increased without changing the optimal solution? (4 marks) What % of available "Cotton Amount Used" can be decreased without the current (given) optimum solution changing? (4 marks)