=E*5.4.* Consider the Union Airways problem presented in Section 3.3, including the spreadsheet in Figure 3.5 showing its formulation and optimal solution.

Management is about to begin negotiations on a new contract with the union that represents the company’s customer service agents. This might result in some small changes in the daily costs per agent given in Table 3.5 for the various shifts. Several possible changes listed below are being considered separately. In each case, management would like to know whether the change might result in the solution in Figure 3.5 no longer being optimal. Answer this question in parts a to e by using the spreadsheet and Solver directly. If the optimal solution changes, record the new solution.

a. The daily cost per agent for shift 2 changes from

$160 to $165.

b. The daily cost per agent for shift 4 changes from

$180 to $170.

c. The changes in parts a and b both occur.

d. The daily cost per agent increases by $4 for shifts 2, 4, and 5, but decreases by $4 for shifts 1 and 3.

e. The daily cost per agent increases by 2 percent for each shift.