Given results after developing the excel LP and Solver Question 4: Sensitivity Analysis (20 Points) Using the Excel Solver results in Table, address the following questions: (4 points per question) Standard Delo Aly Pine 0 Dal ar Labor a. What is the objective function and its optimal value? SU SW hudent Sensitivity report b. What are the slack/surplus values for different constraints? Variable Calle W ded c. Calculate the profit if the coefficient of "deluxe" changes to 250? SA Nalur SRETA d. Will the optimal solution remain the same if simultaneously the coefficient of "standard" changes to 180 and coefficient of "deluxe" changes to 290? How much will it cost to buy an additional 600 units of labor amount considering it to be a "sunk" cost? Standard Delure Availability 80 60 Pine 5000 0 18 Oak 200 alue? 10 16 Labor $130 $178 Profit/unit Sensitivity report: Variable Cells Reduced Objective Alowable Allowable Final Decrease hores Coefficient Case Value 50 Name 1.50 50 Cell 16:30 3220 0 45 $B$21 Standard $C$21 Deluxe Allowable Allowak D Final Shadow Constraint one RH Side CU Price JE Value S2 Name a JE 1.500 Cell 0 26.6666667 : 450 AU 20 400 $B$25 Pine Amount Used $B$26 Oak Amount Used $B$27 Labor Amount Used 15 m