{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

Microsoft Excel 12.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 10/11/2010 10:14:14 PM Target Cell (Max) Cell Name Original Value Final Value \$B\$11 Profit Z= Profit  \$25,380.00   \$25,380.00  Adjustable Cells Cell Name Original Value Final Value \$C\$4 Midnight-8AM (x1) Number of drivers 0 0 \$C\$5 4AM-Noon (x2) Number of drivers 27 27 \$C\$6 8AM-4PM (x3) Number of drivers 1 1 \$C\$7 NOON-8PM (x4) Number of drivers 24 24 \$C\$8 4PM-Midnight (X5) Number of drivers 8 8 \$C\$9 8PM-4AM (X6) Number of drivers 10 10 Constraints Cell Name Cell Value Formula Status Slack \$F\$4 x1 CONSTRAINTS 10 \$F\$4>=\$H\$4 Binding 0 \$F\$5 x2 CONSTRAINTS 27 \$F\$5>=\$H\$5 Not Binding 15 \$F\$6 x3 CONSTRAINTS 28 \$F\$6>=\$H\$6 Not Binding 8 \$F\$7 x4 CONSTRAINTS 25 \$F\$7>=\$H\$7 Binding 0 \$F\$8 x5 CONSTRAINTS 32 \$F\$8>=\$H\$8 Binding 0 \$F\$9 x6 CONSTRAINTS 18 \$F\$9>=\$H\$9 Binding 0 \$F\$10 CONSTRAINTS 70 \$F\$10<=\$H\$10 Binding 0 \$C\$4 Midnight-8AM (x1) Number of drivers 0 \$C\$4>=0 Binding 0 \$C\$5 4AM-Noon (x2) Number of drivers 27 \$C\$5>=0 Not Binding 27 \$C\$6 8AM-4PM (x3) Number of drivers 1 \$C\$6>=0 Not Binding 1 \$C\$7 NOON-8PM (x4) Number of drivers 24 \$C\$7>=0 Not Binding 24 \$C\$8 4PM-Midnight (X5) Number of drivers 8 \$C\$8>=0 Not Binding 8 \$C\$9 8PM-4AM (X6) Number of drivers 10 \$C\$9>=0 Not Binding 10 \$C\$4 Midnight-8AM (x1) Number of drivers 0 \$C\$4=integer Binding 0 \$C\$5 4AM-Noon (x2) Number of drivers 27 \$C\$5=integer

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.

{[ snackBarMessage ]}