Assig3.Problem 2a.b

# Assig3.Problem 2a.b - Binding \$F\$15 Solution x5 0...

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

Microsoft Excel 8.0 Answer Report Target Cell (Min) Cell Name Original Value Final Value \$Q\$4 Min Optimal Solution 0 4 Adjustable Cells Cell Name Original Value Final Value \$B\$15 Solution x1 0 1 \$C\$15 Solution x2 0 0 \$D\$15 Solution x3 0 0 \$E\$15 Solution x4 0 0 \$F\$15 Solution x5 0 0 \$G\$15 Solution x6 0 0 \$H\$15 Solution x7 0 1 \$I\$15 Solution x8 0 0 \$J\$15 Solution x9 0 0 \$K\$15 Solution x10 0 0 \$L\$15 Solution x11 0 1 \$M\$15 Solution x12 0 1 \$N\$15 Solution x13 0 0 Constraints Cell Name Cell Value Formula Status Slack \$O\$6 Room 1 LHS 1 \$O\$6>=\$P\$6 Binding 0 \$O\$7 Room 2 LHS 1 \$O\$7>=\$P\$7 Binding 0 \$O\$8 Room 3 LHS 1 \$O\$8>=\$P\$8 Binding 0 \$O\$9 Room 4 LHS 1 \$O\$9>=\$P\$9 Binding 0 \$O\$10 Room 5 LHS 1 \$O\$10>=\$P\$10 Binding 0 \$O\$11 Room 6 LHS 1 \$O\$11>=\$P\$11 Binding 0 \$O\$12 Room 7 LHS 1 \$O\$12>=\$P\$12 Binding 0 \$O\$13 Room 8 LHS 1 \$O\$13>=\$P\$13 Binding 0 \$B\$15 Solution x1 1 \$B\$15=binary Binding 0 \$C\$15 Solution x2 0 \$C\$15=binary Binding 0 \$D\$15 Solution x3 0 \$D\$15=binary Binding 0 \$E\$15 Solution x4 0 \$E\$15=binary

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: Binding \$F\$15 Solution x5 0 \$F\$15=binary Binding \$G\$15 Solution x6 0 \$G\$15=binary Binding \$H\$15 Solution x7 1 \$H\$15=binary Binding \$I\$15 Solution x8 0 \$I\$15=binary Binding \$J\$15 Solution x9 0 \$J\$15=binary Binding \$K\$15 Solution x10 0 \$K\$15=binary Binding \$L\$15 Solution x11 1 \$L\$15=binary Binding \$M\$15 Solution x12 1 \$M\$15=binary Binding \$N\$15 Solution x13 0 \$N\$15=binary Binding Problem 2 a b x1 x2 x3 x4 x5 x6 x7 x8 x9 x10 x11 x12 x13 LHS RHS Optimal Solution Min 1 1 1 1 1 1 1 1 1 1 1 1 1 4 Room 1 1 1 1 1 1 Room 2 1 1 1 1 1 Room 3 1 1 1 1 1 Room 4 1 1 1 1 1 1 Room 5 1 1 1 1 1 1 Room 6 1 1 1 1 1 Room 7 1 1 1 1 1 1 Room 8 1 1 1 1 Solution 1 1 1 1...
View Full Document

{[ snackBarMessage ]}

### Page1 / 2

Assig3.Problem 2a.b - Binding \$F\$15 Solution x5 0...

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

View Full Document
Ask a homework question - tutors are online