Microsoft Excel 11.6 Answer Report
Worksheet: [412LP-FarmProbFixed).xls]Farm
Report Created: 9/16/2010 12:14:46 PM
Target Cell (Max)
Cell
Name
Original Value
Final Value
$I$8
$NetIncome Total
0
92200
Adjustable Cells
Cell
Name
Original Value
Final Value
$B$4
#Units Cows
0
0
$C$4
#Units Hens
0
0
$D$4
#Units AcreSoybeans
0
0
$E$4
#Units AcreCorn
0
0
$F$4
#Units AcreOats
0
50
$G$4
#Units HrWinWorkNeighbor
0
3100
$H$4
#Units HrSumWorkNeighbor
0
3100
Constraints
Cell
Name
Cell Value
Formula
Status
Slack
$I$11 $Investment Actual
2500 $I$11<=$K$11 Not Binding
4500
$I$12 WinWorkHr Actual
3600 $I$12<=$K$12 Binding
0
$I$13 SumWorkHr Actual
4100 $I$13<=$K$13 Binding
0
$I$14 Acreage Actual
50 $I$14<=$K$14 Binding
0
$I$15 ChickenHouse Actual
0 $I$15<=$K$15 Not Binding
120
$I$16 BarnSize Actual
0 $I$16<=$K$16 Not Binding
20
This
preview
has intentionally blurred sections.
Sign up to view the full version.
Microsoft Excel 11.6 Sensitivity Report
Worksheet: [412LP-FarmProb.xls]Farm
Report Created: 9/16/2010 12:14:46 PM
Adjustable Cells
Final Reduced Objective Allowable
Allowable
Cell
Name
Value
Cost
Coefficient Increase
Decrease
$B$4
#Units Cows
0
-825
1000
825 1.0000E+030
$C$4
#Units Hens
0
-2.1
3
2.1 1.0000E+030
$D$4
#Units AcreSoybeans
0
-260
900
260 1.0000E+030
$E$4
#Units AcreCorn
This is the end of the preview.
Sign up
to
access the rest of the document.
- Spring '07
- Eng
- Centuries in the future, adjustable cells
-
Click to edit the document details