Glyen results after developing the excel LP and Solver: 18 minutes on slide Question 5: Sensitivity Analysis (20 marks Using the Excel Solver results in Table, address the following questions: What is the objective function and its optimal value? (4 marks) Selver Sensitivity Report: Variable Cell a Cel Name SBS21 Number produced Star $C$21 Number produced Sharp Final Reduced Objective Allowable Allowable Valoe Cost Coeficient Ince Decrease 0 -10 10 10 1E-15 180 0 20 1E430 20 b. Will the optimal solution remain the same if the objective coefficient of "Number produced Star" changes to 182 (4 marks) Solver Constraints Cel Name $B$25 Steel Amour Uked SES26 Ti Amount Used 58527 Labor Amont Used What happens to the optimal value of the objective function if the coefficient of "Number produced Sharp" changes to 10 and the other coefficient changes to 16? (6 marks) Final Shadow Cooraint Valee Price RIL Side 140 0 3300 180 0 350 360 300 Allowable Allowable Increase Decres 15-30 3.500 IE0 200 10 360 e. How much should the "Star" product unit profit of $10 be increased by so the manufacturer can produce them? (3 marks) d. What % of available "Titanium Amount Used" can be decreased without it affecting the current (given) optimum solution