412LP-FarmProbFixed - MicrosoftExcel11.6AnswerReport...

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

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