lion problem

lion problem - Cell Name Original Value Final Value $H$4...

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

View Full Document Right Arrow Icon
Microsoft Excel 11.0 Answer Report Worksheet: [lion problem.xls]Sheet1 Report Created: 2/6/2007 10:27:02 PM Target Cell (Max) Cell Name Original Value Final Value $G$3 Max 3520000 3352000 Adjustable Cells Cell Name Original Value Final Value $B$11 S1 50000 50000 $C$11 T1 10000 6000 $D$11 S2 0 0 $E$11 T2 5000 9000 Constraints Cell Name Cell Value Formula Status Slack $G$5 Soldiers 50000 $G$5<=$I$5 Binding 0 $G$6 Trains 15000 $G$6>=$I$6 Binding 0 $G$7 Lumber 180000 $G$7<=$I$7 Binding 0 $G$8 Labor 177000 $G$8<=$I$8 Not Binding 18000 $G$9 Lioness 9000 $G$9>=$I$9 Not Binding 4000
Background image of page 1

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

View Full DocumentRight Arrow Icon
S1 T1 S2 T2 Max 65 32 -5 -10 3352000 S.T. 1 0 1 0 Soldiers 50000 <= 50,000 0 1 0 1 Trains 15000 >= 15,000 3 5 0 0 Lumber 180000 <= 180,000 3 4.5 0 0 Labor 177000 <= 195,000 0 0 1 1 Lioness 9000 >= 5,000 50000 6000 0 9000
Background image of page 2
Microsoft Excel 11.0 Answer Report Worksheet: [lion problem.xls]Sheet2 Report Created: 2/6/2007 10:38:24 PM Target Cell (Max)
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Cell Name Original Value Final Value $H$4 Max 3352000 3352000 Adjustable Cells Cell Name Original Value Final Value $C$12 S1 50000 50000 $D$12 T1 6000 6000 $E$12 S2 $F$12 T2 9000 9000 Constraints Cell Name Cell Value Formula Status Slack $H$6 Soldiers 50000 $H$6&lt;=$J$6 Binding $H$7 Trains 15000 $H$7&gt;=$J$7 Binding $H$8 Lumber 180000 $H$8&lt;=$J$8 Binding $H$9 Labor 177000 $H$9&lt;=$J$9 Not Binding 18000 $H$10 Lioness 9000 $H$10&gt;=$J$10 Not Binding 1000 S1 T1 S2 T2 Max 65 32-5-10 3352000 S.T. 1 1 0 Soldiers 50000 &lt;= 50,000 1 1 Trains 15000 &gt;= 15,000 3 5 0 Lumber 180000 &lt;= 180,000 3 4.5 0 Labor 177000 &lt;= 195,000 1 1 Lioness 9000 &gt;= 8,000 50000 6000 9000...
View Full Document

Page1 / 4

lion problem - Cell Name Original Value Final Value $H$4...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online