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 Deluxe Availability Pine 80 60 5000 Oak 0 18 750 a. What is the objective function and its optimal value? Labor 10 16 400 Profit/unit $130 $178 b. What are the slack/surplus values for different constraints? Sensitivity report: Variable Cells C. Calculate the profit if the coefficient of deluxe" changes to 250? Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$21 Standard 0 -50 150 50 1E+30 d. $C$21 Deluxe 45 0 320 1E+30 80 Final Shadow Constraint Allowable Allowable Will the optimal solution remain the same if simultaneously the coefficient of "standard changes to 180 and coefficient of deluxe changes to 290? Cell Name Value Price R.H. Side Increase Decrease $B$25 1500 0 5000 1E+30 3500 Pine Amount Used Oak Amount Used $B$26 450 0 750 1E+30 300 $B$27 Labor Amount Used 400 20 400 266.6666667 400 e. 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