Qgestion 3: Sensitivity Analysis (5 marks) Using the Excel Solver results in Table, address the following questions: Give results after developing the ccel LP and Solver: 18 minutes on slide besty Deport Vale Calle Pel Redent de Alle A Bowl CA Nese Vale Cat Inc Dec SI Naber produod ASAN 0 -15 13 15 LE+15 10531 Shaber produced HANA 175 0 30 IE+0 How much is reduced cost of "Number produced ASAN" and how should we interpret this value? (4 marks) Solver Coats b. Calculate the expected objective function's value if the coefficient of "Number produced ASAN" changes to 25. (4 marks) Call Nape 58523 Cotion Amount Used $B$26 Leher Arsed 58327 Labor Ancat Used Flan Shadow Cost Valo Price RII Side 875 0 1000 700 0 900 700 700 Allowable Allowable taceae Decrease LE30 120 10 250 40 360 c. 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 207 (6 marks) 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. What % of available "Cotton Amount Used" can be decreased without the current (given) optimum solution changing? (4 Sharks) f. What % of "Labor Amount Used" can be increased without changing the optimal solution? (4 marks) Qgestion 3: Sensitivity Analysis (5 marks) Using the Excel Solver results in Table, address the following questions: Give results after developing the ccel LP and Solver: 18 minutes on slide besty Deport Vale Calle Pel Redent de Alle A Bowl CA Nese Vale Cat Inc Dec SI Naber produod ASAN 0 -15 13 15 LE+15 10531 Shaber produced HANA 175 0 30 IE+0 How much is reduced cost of "Number produced ASAN" and how should we interpret this value? (4 marks) Solver Coats b. Calculate the expected objective function's value if the coefficient of "Number produced ASAN" changes to 25. (4 marks) Call Nape 58523 Cotion Amount Used $B$26 Leher Arsed 58327 Labor Ancat Used Flan Shadow Cost Valo Price RII Side 875 0 1000 700 0 900 700 700 Allowable Allowable taceae Decrease LE30 120 10 250 40 360 c. 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 207 (6 marks) 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. What % of available "Cotton Amount Used" can be decreased without the current (given) optimum solution changing? (4 Sharks) f. What % of "Labor Amount Used" can be increased without changing the optimal solution? (4 marks)