Without generating the sensitivity report

Assignment Help Management Theories

Reference no: EM131100620

Without generating the Sensitivity Report, adapt the sensitivity analysis procedure presented in Secs. 6.6 and 6.7 to conduct the sensitivity analysis specified in the four parts of Prob. 8.2-24.

Prob. 8.2-24

Consider the transportation problem formulation and solution of the Metro Water District problem presented in Sec. 8.1 and 8.2. 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 the Excel 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 8.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?

Reference no: EM131100620

Questions Cloud

Network representation of this assignment problem : (a) Draw the network representation of this assignment problem. (b) Formulate this problem as a transportation problem by constructing the appropriate parameter table.

Draw a gate diagram for the function using only not gates : Dale needs help implementing the function F(a, b, c) = a'b' + bc' Draw a gate diagram for the function using only NOT and SCHMAND gates, using the fewest possible gates

Companies in the same industry as apix printing : Explain the computation for each of the following, and compute each for Apix and two other companies in the same industry as Apix Printing:

The firm''s income tax liability and its after-tax income : The Talley Corporation had a taxable income of $365,000 from operations after all operating costs but before (1) interest charges of $50,000, (2) dividends received of $15,000, (3) dividends paid of $25,000, and (4) income taxes. What is the firm's i..

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

What tax rate would an investor be indifferent in 2 bonds : Corporate bonds issued by Johnson Corporation currently yield 8 percent. Municipal bonds of equal risk currently yield 6 percent. At what tax rate would an investor be indifferent between these two bonds?

Problem formulation and solution of the metro water : Consider the transportation problem formulation and solution of the Metro Water District problem presented in Sec. 8.1 and 8.2. The numbers given in the parameter table are only estimates that may be somewhat inaccurate, so management now wishes t..

Response to a divorce : What are some of the family tasks that must be accomplished in response to a divorce - You need to use the attached document to answer this question.

Derive a formula that predicts the maximum useful deflection : Derive a formula that predicts the maximum useful deflection angle,

User Account

All Pages