# Question

Consider the transportation problem formulation and solution of the Metro Water District problem presented in Secs. 9.1 and 9.2 (see Tables 9.12 and 9.23).

The numbers given in the parameter table are only estimates that may be somewhat inaccurate, so management now wishes to do some what-if analysis. Use Solver to generate the Sensitivity Report. Then use this report to address the following questions. (In each case, assume that the indicated change is the only change in the model.)

(a) Would the optimal solution in Table 9.23 remain optimal if the cost per acre foot of shipping Calorie River water to San Go were actually $200 rather than $230?

(b) Would this solution remain optimal if the cost per acre foot of shipping Sacron River water to Los Devils were actually $160 rather than $130?

(c) Must this solution remain optimal if the costs considered in parts (a) and (b) were simultaneously changed from their original values to $215 and $145, respectively?

(d) Suppose that the supply from the Sacron River and the demand at Hollyglass are decreased simultaneously by the same amount. Must the shadow prices for evaluating these changes remain valid if the decrease were 0.5 million acre feet?

The numbers given in the parameter table are only estimates that may be somewhat inaccurate, so management now wishes to do some what-if analysis. Use Solver to generate the Sensitivity Report. Then use this report to address the following questions. (In each case, assume that the indicated change is the only change in the model.)

(a) Would the optimal solution in Table 9.23 remain optimal if the cost per acre foot of shipping Calorie River water to San Go were actually $200 rather than $230?

(b) Would this solution remain optimal if the cost per acre foot of shipping Sacron River water to Los Devils were actually $160 rather than $130?

(c) Must this solution remain optimal if the costs considered in parts (a) and (b) were simultaneously changed from their original values to $215 and $145, respectively?

(d) Suppose that the supply from the Sacron River and the demand at Hollyglass are decreased simultaneously by the same amount. Must the shadow prices for evaluating these changes remain valid if the decrease were 0.5 million acre feet?

## Answer to relevant Questions

Without generating the Sensitivity Report, adapt the sensitivity analysis procedure presented in Secs. 7.1 and 7.2 to conduct the sensitivity analysis specified in the four parts of Prob. 9.2-22. Consider the prototype example for the transportation problem (the P & T Co. problem) presented at the beginning of Sec. 9.1. Verify that the solution given there actually is optimal by applying just the optimality test ...Four cargo ships will be used for shipping goods from one port to four other ports (labeled 1, 2, 3, 4). Any ship can be used for making any one of these four trips. However, because of differences in the ships and cargoes, ...Consider the linear programming model for the general assignment problem given in Sec. 9.3. Construct the table of constraint coefficients for this model. Compare this table with the one for the general transportation ...Reconsider the P & T Co. problem presented in Sec. 9.1. You now learn that one or more of the shipping costs per truckload given in Table 9.2 may change slightly before shipments begin. Use Solver to generate the Sensitivity ...Post your question

0