Question 4: Sensitivity Analysis (20 Points Using the Excel Solver results in Table, address the following questions: (4 points per question) Glven results after developing the excel LP and Solver: Excel poem Sharp Availability Star Stad 5 & 3500 0 1 350 a. What is the objective function and its optimal value? 3 2 360 Labor Pro t $10 $20 b. What constraints are binding and which ones are non-binding? Please explain. 0 180.0 Number produced Pratit contribution Total (per week) SO $3600 $3600 Seher Report Variable Cdis c. What happens to the optimal solution if simultaneously the coefficient of "Number produced Sharp" changes to 10 and the coefficient of "Number of produced star" changes to 17? Cell Na SO521Naberaduced Star SCHUI Number produced Sharp Plaal Reduced Objective Allowable Allowable Valve Cos Collide Increase Decrease . -10 10 10 1E+13 . 20 1E30 20 150 Sobre Contrats d. What % of available "Steel amount used" can be decreased without it affecting the current (given) optimum solution? sal Shadow Cost Allowable Allowable Valor Price Rt Side . Cel Name 58525 Sted Act Us S5 ActUsed 38527 AUW e. Consider the Labor Amount Used to be Sunk cost. How much will it cost to buy an additional 35 hours of labor? 14 180 360 Increase 1E30 1E301 40 3500 350 360 . Der 3500 200 360 20 minutes on slide