Microsoft Excel 14.
2 Sensitivity Report
Worksheet: [Solution Plus.xlsx]Sheet1
Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$D$7 Cicinatti Santa Ana 0 9.44 11.2 1E+030 9.44
$E$7 Cicinatti EI Paso 6800 0 2.04 0.24 1E+030
$F$7 Cicinatti Pendleton 39636 0 2.03 0.11 0.24
$G$7 Cicinatti Houston 100447 0 1.65 9.89 1E+030
$H$7 Cicinatti Kansas city 24570 0 1.56 9.98 1E+030
$I$7 Cicinatti Los Angeles 0 9.44 11.2 1E+030 9.44
$J$7 Cicinatti Glendale 0 9.44 11.2 1E+030 9.44
$K$7 Cicinatti Jacksonville 68486 0 1.54 10 1E+030
$L$7 Cicinatti Little Rock 148586 0 1.54 10 1E+030
$M$7 Cicinatti Bridgeport 111475 0 1.54 10 1E+030
$N$7 Cicinatti Sacramento 0 9.51 11.2 1E+030 9.51
$D$8 Oakland Santa Ana 22418 0 1.87 9.44 1E+030
$E$8 Oakland EI Paso 0 0.24 2.39 1E+030 0.24
$F$8 Oakland Pendleton 40654 0 2.14 0.24 0.11
$G$8 Oakland Houston 0 9.89 11.65 1E+030 9.89
$H$8 Oakland Kansas city 0 9.98 11.65 1E+030 9.98
$I$8 Oakland Los Angeles 64761 0 1.87 9.44 1E+030
$J$8 Oakland Glendale 33689 0 1.87 9.44 1E+030
$K$8 Oakland Jacksonville 0 10 11.65 1E+030 10
$L$8 Oakland Little Rock 0 10 11.65 1E+030 10
$M$8 Oakland Bridgeport 0 10 11.65 1E+030 10
$N$8 Oakland Sacramento 112000 0 1.8 9.51 1E+030
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$E$17 Capacity constraints EI Paso 500000 -0.11 500000 40654 39636
$E$18 EI Paso 273522 0 500000 1E+030 226478
$E$19 Demand Constraints EI Paso 22418 1.87 22418 226478 22418
$E$20 EI Paso 6800 2.15 6800 39636 6800
$E$21 EI Paso 80290 2.14 80290 226478 40654
$E$22 EI Paso 100447 1.76 100447 39636 40654
$E$23 EI Paso 24570 1.67 24570 39636 24570
$E$24 EI Paso 64761 1.87 64761 226478 64761
$E$25 EI Paso 33689 1.87 33689 226478 33689
$E$26 EI Paso 68486 1.65 68486 39636 40654
$E$27 EI Paso 148586 1.65 148586 39636 40654
$E$28 EI Paso 111475 1.65 111475 39636 40654
$E$29 EI Paso 112000 1.8 112000 226478 112000
Decision Variables
Santa Ana EI Paso Pendleton Houston
Cicinatti 0 6800 39636 100447
Oakland 22418 0 40654 0
Objective Function
Santa Ana EI Paso Pendleton Houston
Cicinatti 11.2 2.04 2.03 1.65
Oakland 1.87 2.39 2.14 11.65
Demand 22418 6800 80290 100447
Constraints
Capacity constraints 500000 Less than 500000
273522 Less than 500000
Demand Constraints 22418 equal 22418
6800 equal 6800
80290 equal 80290
100447 equal 100447
24570 equal 24570
64761 equal 64761
33689 equal 33689
68486 equal 68486
148586 equal 148586
111475 equal 111475
112000 equal 112000
Kansas city Los Angeles Glendale Jacksonville Little Rock Bridgeport Sacramento
24570 0 0 68486 148586 111475 0
0 64761 33689 0 0 0 112000
Kansas city Los Angeles Glendale Jacksonville Little Rock Bridgeport Sacramento
1.56 11.2 11.2 1.54 1.54 1.54 11.2
11.65 1.87 1.87 11.65 11.65 11.65 1.8
24570 64761 33689 68486 148586 111475 112000
Cincinnati Oakland
Santa Ana 0 22418
El Paso 6800 0
Pendleton 39636 40654
Houston 100447 0
Kansas City 24570 0
Los Angeles 0 64761
Glendale 0 33689
Jacksonville 68486 0
Little Rock 148586 0
Bridgeport 111475 0
Sacramento 0 112000
Total 500000 273522
500000
273522
Supply Value
500000 1318984.93
500000
773522 1.705167959
