{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

412LP-FarmProbFixed

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

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
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
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
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
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}