Book1 - MicrosoftExcel12.0AnswerReport...

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

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

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

Book1 - MicrosoftExcel12.0AnswerReport...

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

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