{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

lion problem

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

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

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

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

View Full Document
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
Microsoft Excel 11.0 Answer Report Worksheet: [lion problem.xls]Sheet2 Report Created: 2/6/2007 10:38:24 PM Target Cell (Max)

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

View Full Document
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<=\$J\$6 Binding \$H\$7 Trains 15000 \$H\$7>=\$J\$7 Binding \$H\$8 Lumber 180000 \$H\$8<=\$J\$8 Binding \$H\$9 Labor 177000 \$H\$9<=\$J\$9 Not Binding 18000 \$H\$10 Lioness 9000 \$H\$10>=\$J\$10 Not Binding 1000 S1 T1 S2 T2 Max 65 32-5-10 3352000 S.T. 1 1 0 Soldiers 50000 <= 50,000 1 1 Trains 15000 >= 15,000 3 5 0 Lumber 180000 <= 180,000 3 4.5 0 Labor 177000 <= 195,000 1 1 Lioness 9000 >= 8,000 50000 6000 9000...
View Full Document

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online