s 25 marks Using the Excel Solver results in Table, address the following questions: & How much is reduced cost of "Number produced ASAN" and how should we interpret this value? (4 marks) Given results alter developing the excel LP and Solver: 18 minutes on slide Hover Set Beport ve Record Objective Abte Allowable CHI Valne Om Coddat Encrease Decrease SBS21 Number produced /.SAN 0 -15 15 15 IF+15 $C$21 Number produced HANA 175 0 30 Na 1E430 b. Solver Constraints Calculate the expected objective function's value if the coefficient of "Number produced ASAN" changes to 25. (4 marks) Cd Name ISB$25 Cotton Amount Used $B$26 Leather Amount Used SB$27 Labor Amount Used Final Shadow Value Priez 875 0 700 0 700 20 Constant Allowable Allowable RH side Lacrta Decrease 1000 1E430 120 900 1E+30 250 700 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 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) f. What % of available Cotton Amount Used" can be decreased without the current given) optimum solution changing? (4 parks) What % of Labor Amount Used can be increased without changing the optimal solution? (4 marks)