DER SINGH ATWAL on pee (UE WILL 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 Sondity Reporti Variable Cels a What is the objective function and its optimal value? b. What are the slack/surplus values for different constraints? CHI 58521 SCS21 Name Number produced the Number produced Sharp Final Reduced Objective Allowable Allowane Value Cost Coefficient Increase Decrease 0 -10 10 10 1E-15 180 0 20 IE30 20 Soker Constraints c. What happens to the optimal solution if the coefficient of "Number produced Star" changes to 30? Cell Nase SB535 Sted Amon Used 58526 Titanium Mount Used 58527 Labor Amount Uved Final Shadow Constraint Value Price RH Side 1440 0 3800 180 0 350 360 20 360 Allowable Increase 1E430 1E30 40 Allowable Decrease 3500 200 360 d. What % of available "Labor amount used" can be decreased without it affecting the current (given) optimum solution? 20 minutes on slide 4 4 marks per question e. How much should the "Star" product unit profit of $10 be increased by so the manufacturer can produce them