2406 hw 5 number 26 Complete

2406 hw 5 number 26 Complete - Microsoft Excel 12.0 Answer...

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: [2406 hw 5 number 26 Complete.xlsx]Transportation Report Created: 10/12/2010 6:47:33 PM Target Cell (Max) Cell Name Original Value Final Value $C$10 Profit St. Louis 159000 159000 Adjustable Cells Cell Name Original Value Final Value $C$5 Charlotte St. Louis 0 0 $D$5 Charlotte Atlanta 30 30 $E$5 Charlotte New York 0 0 $C$6 Memphis St. Louis 30 30 $D$6 Memphis Atlanta 0 0 $E$6 Memphis New York 0 0 $C$7 Louisville St. Louis 0 0 $D$7 Louisville Atlanta 0 0 $E$7 Louisville New York 30 30 Constraints Cell Name Cell Value Formula Status Slack $C$9 Truckloads Sent St. Louis 30 $C$9<=$C$8 Not Binding 10 $D$9 Truckloads Sent Atlanta 30 $D$9<=$D$8 Not Binding 30 $E$9 Truckloads Sent New York 30 $E$9<=$E$8 Not Binding 20 $F$5 Charlotte Supply 30 $F$5=$G$5 Not Binding 0 $F$6 Memphis Supply 30 $F$6=$G$6 Not Binding 0 $F$7 Louisville Supply 30 $F$7=$G$7 Not Binding 0 $C$5 Charlotte St. Louis 0 $C$5>=0 Binding 0 $D$5 Charlotte Atlanta 30 $D$5>=0 Not Binding 30 $E$5 Charlotte New York 0 $E$5>=0 Binding 0 $C$6 Memphis St. Louis 30 $C$6>=0 Not Binding 30 $D$6 Memphis Atlanta 0 $D$6>=0 Binding 0 $E$6 Memphis New York 0 $E$6>=0 Binding 0 $C$7 Louisville St. Louis 0 $C$7>=0
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 / 7

2406 hw 5 number 26 Complete - Microsoft Excel 12.0 Answer...

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