Extra problem: Please see problem $8\mathrm{.}16$ in the book. It is explained in more detail on pages $249-253$ of

the book and the spreadsheet formulation is given on page $251.)$

Biuld the spreadsheet and get the sensitivity report.

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 $6$ am$-2$pen 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? Jlastify all answers using information from the

sensitivity repert$].$

Write a sentence explaining the meaning of the range of eptimality for the cost per shift of the noon$-$

$8$ pm shift. $($Use numbers from the sensitivity report and explain the meaning of the range in the context

of the problem$).$

Write a sentence explaining the meaning of the range of feasibility for the minimum needed for the

$8$ pm$-10$pm shift. $($Use numbers from the sensitwity report and explain the meaning of the range in the

context of the problem$).$

If the cost per shift for all shifts increases by $$2$ will the will there be a change in the number of agents

assigned to each shift? $($Justify all answers using information from the sensitivity report$).$

It turns out that the minimum needed for the $6pm-8pm$ shift has increased to $90.$ is it possible to

determine without resolving how much the total cost of scheduling will change? if so$,$ how will total cost

change? Justify all answers using information from the sensitivity report$).$

If the minimum needed for all shifts ending by $4pm(6$am$-8$am$,8$ am$-10$am$,10$am$-12,12$pm$-2$pm$,2$pm$-$

$4pm)$ increases by $2,$ is it possible to determine without resolving how much the total cost of scheduling

will change? If so$,$ find the total cost with these changes. $($lustify all answers using information from the

sensinivity report$].$

If the minimum needed for all shifts ending by $4pm(6$am$-8$am$,8$am$-10$am$,10$am$-12,12$pm$-2$pm$,2$pm$-$

$4pm)$ increases by $3,$ is it possible to determine without resolving how much the total cost of scheduling

will change? If so$,$ find the total cost with these changes. $($lustify all answers using information from the

sensitivity report$].$