1) Build the spreadsheet and get the sensitivity report. Attached 2) The management at Union Airways hired and assigned agents as determined by the LP optimization. They have now discovered that labor costs are rising and are concerned about the impact this will have on their schedule. If the cost per shift for the 6am-2pm shift increases by $50, will there be a change in the number of agents assigned to each shift? Are they able to determine how much total costs will change? If yes, then how much will they change? (Justify all answers using information from the sensitivity report). No there will not be a change in the number of agents assigned to each shift. Because the allowable increase for the cost per shit for 6am-2pm is infinity and therefore will not change the number of agents assigned. However, this will change the total cost to $33,010, an increase of $2400. 3) Write a sentence explaining the meaning of the range of optimality for the cost per shift of the noon-8pm shift. (Use numbers from the sensitivity report and explain the meaning of the range in the context of the problem). The range of optimality for the cost