Question 3: Sensitivity Analysis (25. marks) Using the Excel Solver results in Table, address the following questions: Give results after develophug the excel LP and Solver: 18 minutes on slide Bohrer Seity Report: Verse Odis Nederd Oblece Albite Allowable Odl Neate Valee Coreldrar TSC Decrease $B$21 Number produced ASAN 0 -15 15 15 JEPIS $C$21 Number produced HANA 175 0 30 LE+30 2 3. How much is reduced cost of "Number produced ASAN" and how should we interpret this value? (4 marks) Sohrer Construts b. Calculate the expected objective function's value if the coefficient of "Number produced ASAN" changes to 25. (4 marks) Flas Value 875 Shadow Price call NADE SB$25 Cotton Amount Used SB$26 Leather Amoxat Used SB527 Labor Amount Used 0 Constra RF Side 1000 900 700 Allowable Increase IE30 LE+30 40 Allowable Decrease 120 250 700 700 0 20 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 20? (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. f. What % of available Cotton Amount Used" can be decreased without the current (given) optimum solution changing? (4 Darks) What % of "Labor Amount Used" can be increased without changing the optimal solution? (4 marks)