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: Solver Sensitivity Report: Variable Cells What is the objective function and its optimal value? Cell What are the slack/surplus values for different constraints? Name Number produce Star Number produced Sharp $B$21 SCS21 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0 -10 10 10 1E-15 180 0 20 1E+30 20 Solver Constraints Allowable c. What happens to the optimal solution if the coefficient of Number produced Star changes to 30? Cell Name SBS25 Steel Amount Used $B$26 Titanium Amount Used $B$27 Labor Amount Used Final Shadow Constraint Value Price R.H. Side 1440 0 3500 180 0 350 360 20 360 Increase 1E+30 1E+30 Allowable Decrease 3500 200 360 40 d. What % of available Labor amount used can be decreased without it affecting the current (given) optimum solution? 20 minutes on slide 4 marks per question How much should the "Star" product unit profit of $10 be increased by so the manufacturer can produce them