Question 4. Sensitivity Analysis (20 Points) Using the Excel Solver results in Table, address the following questions: (4 points per question) Glven resultater leveloping the waxed Solver Tel SU st a What is the objective function and its optimal value NO We 10 C MO IM b. What constraints are binding and which ones are non-binding? Please explain STO be hot 0 VO 0 C. SO NA W SO What happens to the optimal solution it simultaneously the coefficient of "Number produced Sharp" changes to 10 and the coefficient of "Number of produced star" changes to 17 With R Vilablecak Witowe CHI None Nihil Sebebi lab Soma Vale CO COM VO W De d. What % of available "Steel amount used" can be decreased without it affecting the current (given) optimum solution? WA 20 Sol Coins Cell hu Vale Non Price TO Consider the labor Amount Used to be Sunk cost llow much will it cost to buy an additional 35 hours of labor 6 wr su bol Sie 30 Atable Tec GM 2 be Dee MOD 1 KO 24 MU Jou 20 notes on Question 4. Sensitivity Analysis (20 Points) Using the Excel Solver results in Table, address the following questions: (4 points per question) Glven resultater leveloping the waxed Solver Tel SU st a What is the objective function and its optimal value NO We 10 C MO IM b. What constraints are binding and which ones are non-binding? Please explain STO be hot 0 VO 0 C. SO NA W SO What happens to the optimal solution it simultaneously the coefficient of "Number produced Sharp" changes to 10 and the coefficient of "Number of produced star" changes to 17 With R Vilablecak Witowe CHI None Nihil Sebebi lab Soma Vale CO COM VO W De d. What % of available "Steel amount used" can be decreased without it affecting the current (given) optimum solution? WA 20 Sol Coins Cell hu Vale Non Price TO Consider the labor Amount Used to be Sunk cost llow much will it cost to buy an additional 35 hours of labor 6 wr su bol Sie 30 Atable Tec GM 2 be Dee MOD 1 KO 24 MU Jou 20 notes on