Availability Deluxe Given results after developing the excel LP and Solver: Standard sono 60 10 750 18 400 16 Question : Sensitivity Analysis (20 points) Using the Excel Solver results in Table, address the following questions: (4 points per question) bul 10 La $178 $130 ultur 2 What is the objective function and its optimal value? What are the slack surplus values for different Sensitivity report: constraints? Allowable Allowable Wwe Call ind Reduced Objective Cost Coefficient Increase Decrease Valur Cel Name 50 16:30 150 c Calculate the profit if the coefficient of "deluxe" changes to 2507 -50 0 1E30 80 320 $21 3521 Sandard Duke 45 O Allowable Allowable Final Shadow Constraint Increase Decrease Price RH. Side Whe Nune Will the optimal solution remain the same if simultaneously the coefficient of standard" changes to 180 and coefficient of "deluxe" changes to 2907 1500 3500 0 5000 1.30 Cell 533 Amounted $Dok Amounted $27 Lahor Amounted 450 750 16:30 300 400 20 400 2666666667 400 How much will it cost to buy an additional 600 units of labor amount considering it to be a "sunk" cost? 15 minutes on slide Availability Deluxe Given results after developing the excel LP and Solver: Standard sono 60 10 750 18 400 16 Question : Sensitivity Analysis (20 points) Using the Excel Solver results in Table, address the following questions: (4 points per question) bul 10 La $178 $130 ultur 2 What is the objective function and its optimal value? What are the slack surplus values for different Sensitivity report: constraints? Allowable Allowable Wwe Call ind Reduced Objective Cost Coefficient Increase Decrease Valur Cel Name 50 16:30 150 c Calculate the profit if the coefficient of "deluxe" changes to 2507 -50 0 1E30 80 320 $21 3521 Sandard Duke 45 O Allowable Allowable Final Shadow Constraint Increase Decrease Price RH. Side Whe Nune Will the optimal solution remain the same if simultaneously the coefficient of standard" changes to 180 and coefficient of "deluxe" changes to 2907 1500 3500 0 5000 1.30 Cell 533 Amounted $Dok Amounted $27 Lahor Amounted 450 750 16:30 300 400 20 400 2666666667 400 How much will it cost to buy an additional 600 units of labor amount considering it to be a "sunk" cost? 15 minutes on slide