Given results after de Hide thumbnail vided Excel program Question 4: Sensitivity Analysis (20 Points Using the Excel Solver results in Table, address the following questions: Star Sharp 8 5 0 Availability 3500 350 360 1 a. Steel Titanium Labor Profit/unit What is the objective function and its optimal value? 3 2 $10 $20 b. What are the slack/surplus values for different constraints 0 Number produced Profit contribution 180.0 $3600 Total (per week) $3600 c. What happens to the coefficient of "Number produced Star" changes to 30? SO 20 minutes on slide Solver Sensitivity Report: Variable Cels d. What % of available "Labor amount used" can be decreased without it affecting the current (given) optimum solution? e. How much should the "Star" product unit profit of $10 be increased by so the manufacturer can produce them? Cell Name SBS21 Number produced Star SCS21 Number produced Sharp Final Reduced Value Cost -10 180 0 Objective Coefficient 10 20 Allowable Allowable Increase Decrease 10 1E-15 1E+30 20 Solver Constraints Cell Name SBS25 Steel Amount Used SBS26 Titanium Amount Used SBS27 Labor Amount Used Final Shadow Value Price 1440 180 0 360 20 Constraint R.H. Side 3500 350 Allowable Allowable Increase Decrease 1E-30 3500 1E+30 200 40 360 3601 MacBook Air y A DI