1) For each of the five problems, print a sensitivity analysis report by clicking "Sensitivity" in the "Reports" menu on the right-hand side of the "Solver Results" window immediately after you have clicked solve." Attach a print-out of the sensitivity report for each problem. Note that the first table in the sensitivity report shows how changing the objective fcn. coeffs. affects the optimal solution, and the second table shows how changing the right-hand sides affects the optimal solution and optimal objective value. 2) On a separate sheet of paper, answer the following questions: a. For problem 2 (the Steelco shipping problem), what do the values in the "allowable increase" and "allowable decrease" columns tell us? For what ranges of values for the six shipping costs ($2000, $1700, ...) will the current optimal solution still be optimal, assuming only a single shipping cost is changed at a time? Your answer should consist of six different intervals. b. For problem 3 (Mike's metal manufacturing problem), what do the values in the "shadow price" column tell us? i. Would Mike's profit change if he had more than 480 hours of machine time each week? If so, how much would his profit increase initially) per extra hour of machine time available? ii. Would Mike's profit change if he had more than 400 hours of polishing time each week? If so, how much would his profit increase initially) per extra hour of polishing time available? iii. Would Mike's profit change if he had more than 400 hours of assembly time each week? If so, how much would his profit increase initially) per extra hour of assembly time available? iv. Would Mike's profit change if the contract for product I required him to produce more than 50 units of product I each week? If so, how much would his profit decrease initially) per extra unit of product I that he is required to produce? v. Would Mike's profit change if he were allowed to sell more than 25 units of product IV each week? If so, how much would his profit increase (initially) per extra unit of product IV that he is allowed to produce? c. Consider problem 4 (the Bullco fertilizer blending problem). If Bullco were allowed to purchase either more nitrogen or more silicon, but not both, which element should Bullco purchase more of initially). How can you tell