Given results after developing the end 4 Ster Question 4: Sensitivity Analysis (20 points) Using the Excel Solver results in Table, address the following questions: 5 8 2 What is the objective function and its optimal value? Lab Profit BIO b. What are the slack/surplus values for different constraints? Number produced Profit contribution 20 minutes on side What happens to the coefficient of "Number produced Star" changes to 30? Selver Seativky Kaart Variable Cels d. What % of available "Labor amount used can be decreased without it affecting the current (given) optimum solution? cdl SB521 SCS21 Name Number produced Stur Number produced Sharp Paal Reduced Owens Abowe Awe Valee Con Code Daa 0 -10 10 180 0 20 20 Solver Constraints e. How much should the "Star" product unit profit of $10 be increased by so the manufacturer can produce them? Cdi Name SBS25 Steel Amount Used SBS26 Titanium Amount Used SBS27 Labor Amount Used Fiaal Shadow Costrat Allowable Alowable Valse Price RH Side Increase Derras 1440 0 3500 1E-30 3500 180 0 350 1E-30 200 360 20 3601 40 3 to search V VOBOOK Given results after developing the end 4 Ster Question 4: Sensitivity Analysis (20 points) Using the Excel Solver results in Table, address the following questions: 5 8 2 What is the objective function and its optimal value? Lab Profit BIO b. What are the slack/surplus values for different constraints? Number produced Profit contribution 20 minutes on side What happens to the coefficient of "Number produced Star" changes to 30? Selver Seativky Kaart Variable Cels d. What % of available "Labor amount used can be decreased without it affecting the current (given) optimum solution? cdl SB521 SCS21 Name Number produced Stur Number produced Sharp Paal Reduced Owens Abowe Awe Valee Con Code Daa 0 -10 10 180 0 20 20 Solver Constraints e. How much should the "Star" product unit profit of $10 be increased by so the manufacturer can produce them? Cdi Name SBS25 Steel Amount Used SBS26 Titanium Amount Used SBS27 Labor Amount Used Fiaal Shadow Costrat Allowable Alowable Valse Price RH Side Increase Derras 1440 0 3500 1E-30 3500 180 0 350 1E-30 200 360 20 3601 40 3 to search V VOBOOK