Given results after developing the excel LP and Solver Question 4: Sensitivity Analysis (15 Points) Using the Excel Solver results in Table, address the following questions: incel program a. What is the objective function and its optimal value? Steel Titania Labor Profit SEN 5 0 3 $10 Shop 8 1 2 520 Availability 3500 350 160 b. What are the slack/surplus values for different constraints? Number produced Profit contribution 0 50 180.0 S1600 Total (per wed) 500 c. What happens to the optimal solution if the coefficient of "Number produced Star" changes to 15 minutes on slide 30? Saver Susitiis Repti Variable dels d. How much will the objective function be improved if we increase 30 extra Labour Amount units? Cell Nase SBS Numba produced St SC521 Number produced Sharp Final Reduced Objective Alewable Allowable Valee Cou Collide Ince Der -10 10 10 15.15 180 . 20 130 30 Soler Coastalats e. How much should the "Star" product unit profit of $10 be increased by so the manufacturer can produce them? Call Nane 53526 Steel Amount Ured 58526 Amour Used S3527 Laber Amusel Fol Shadow Costro Value Price Side 1440 0 3900 0 350 360 20 360 Allowable Movable Increase Der 1E30 3900 15-30 200 300 State