# Question: Reconsider the Union Airways problem and its spreadsheet model that

Reconsider the Union Airways problem and its spreadsheet model that was dealt with in Prob. 7.3-6. Management now is considering increasing the level of service provided to customers by increasing one or more of the numbers in the rightmost column of Table 3.19 for the minimum number of agents needed in the various time periods. To guide them in making this decision, they would like to know what impact this change would have on total cost. Use Solver to generate the sensitivity report in preparation for addressing the following questions.

(a) Which of the numbers in the rightmost column of Table 3.19 can be increased without increasing total cost? In each case, indicate how much it can be increased (if it is the only one being changed) without increasing total cost.

(b) For each of the other numbers, how much would the total cost increase per increase of 1 in the number? For each answer, indicate how much the number can be increased (if it is the only one being changed) before the answer is no longer valid.

(c) Do your answers in part (b) definitely remain valid if all the numbers considered in part (b) are simultaneously increased by one?

(d) Do your answers in part (b) definitely remain valid if all 10 numbers are simultaneously increased by one?

(e) How far can all 10 numbers be simultaneously increased by the same amount before your answers in part (b) may no longer be valid?

(a) Which of the numbers in the rightmost column of Table 3.19 can be increased without increasing total cost? In each case, indicate how much it can be increased (if it is the only one being changed) without increasing total cost.

(b) For each of the other numbers, how much would the total cost increase per increase of 1 in the number? For each answer, indicate how much the number can be increased (if it is the only one being changed) before the answer is no longer valid.

(c) Do your answers in part (b) definitely remain valid if all the numbers considered in part (b) are simultaneously increased by one?

(d) Do your answers in part (b) definitely remain valid if all 10 numbers are simultaneously increased by one?

(e) How far can all 10 numbers be simultaneously increased by the same amount before your answers in part (b) may no longer be valid?

**View Solution:**## Answer to relevant Questions

David, LaDeana, and Lydia are the sole partners and workers in a company which produces fine clocks. David and LaDeana each are available to work a maximum of 40 hours per week at the company, while Lydia is available to ...Consider the following problem. Minimize W = 5y1 + 4y2, Subject to and y1 ≥ 0, y2 ≥ 0. Because this primal problem has more functional constraints than variables, suppose that the simplex method has been applied directly ...The Royal Cola Company is considering developing a special new carbonated drink to add to its standard product line of drinks for a couple years or so (after which it probably would be replaced by another special drink). ...Consider the following problem. Maximize Z = 2x1 – x2 + x3, Subject to and x1 ≥ 0, x2 ≥ 0, x3 ≥ 0. If we let x4, x5, and x6 be the slack variables for the respective constraints, the simplex method yields the ...Consider the example for case 1 of sensitivity analysis given in Sec. 7.2, where the initial simplex tableau of Table 4.8 is modified by changing b2 from 12 to 24, thereby changing the respective entries in the right-side ...Post your question