REC Question 4: Sensitivity Analysis (20 Points) Given results after developing the excel LP and Solver: Using the Excel Solver results in Table, address the following questions: Solver Smritivirg Report! a. What is the objective function and its optimal value? Variable Cdh Final Reduced Objective Allowable Allowable Call Name Value Com Coefficient Increase Decrease b. What are the slack/surplus values for different $8521 Number produced Star -10 10 10 15-15 constraints? BC$21 Member produced Shap 1E+30 C. What happens to the optimal solution if the Final Shadow | Constraint Allowable Allowable coefficient of "Number produced Star" changes to Call Same Valor Price R.H. Side Increase 38425 Speed Amount Used 1440 IE-30 307 1:30 350 360 20 360 360 d. What % of available "Labor amount used" can be decreased without it affecting the current (given) 20 minutes on slide optimum solution? e. How much should the "Star" product unit profit of 4 marks per question $10 be increased by so the manufacturer can produce them