Wheat SE Wheat N
Wheat
NW
Wheat W
Wheat
SW
Alfalfa
SE
Alfalfa
N
Alfalfa
NW
Alfalfa
W
Alfalfa
SW
Barley
SE
Barley N
Barley
NW
Barley
W
Barley
SW
Number of acres 2,000.00 200.00 – – – – – 165.52 – – – 880.00 91.43 28.57 –
Wheat acreage 1 1 1 1 1 2200.00 <= 2200
Alfalfa acreage 1 1 1 1 1 165.52 <= 1200
Barley acreage 1 1 1 1 1 1000.00 <= 1000
SE water 1.6 2.9 3.5 3200.00 <= 3200
N water 1.6 2.9 3.5 3400.00 <= 3400
NW water 1.6 2.9 3.5 800.00 <= 800
W water 1.6 2.9 3.5 100.00 <= 500
SW water 1.6 2.9 3.5 0.00 <= 600
Problem 3-27
SE acreage 1 1 1 2000.00 <= 2000
N acreage 1 1 1 1080.00 <= 2300
NW acreage 1 1 1 256.95 <= 600
W acreage 1 1 1 28.57 <= 1100
SW acreage 1 1 1 0.00 <= 500
Worksheet: [P4-17.xls]
Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$4 Number of acres Wheat SE 2000.000 0.000 100.000 0.000 0.000
$F$4 Number of acres Wheat SW 0.000 0.000 100.000 0.000 1E+30
$G$4 Number of acres Alfalfa SE 0.000 0.000 60.000 0.000 1E+30
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$Q$7 SE acreage 2000.000 0.000 2000.000 0.000 1045.000
$Q$8 N acreage 1080.000 0.000 2300.000 1E+30 1220.000
$Q$9 NW acreage 256.946 0.000 600.000 1E+30 343.054
Microsoft Excel 14.0 Sensitivity Report
Wheat SE Wheat N
Wheat
NW
Wheat
W
Wheat
SW
Alfalfa
SE
Alfalfa
N
Alfalfa
NW
Alfalfa
W
Alfalfa
SW
Barley
SE
Barley N
Barley
NW
Barley
W
Barley
SW
SW acreage 1 1 1 0.00 <= 500
Wheat acreage 1 1 1 1 1 2200.00 <= 2200
Problem 4-17 (Alternate)