Copy of C6p53

# Copy of C6p53 - MicrosoftExcel12.0AnswerReport...

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

Microsoft Excel 12.0 Answer Report Worksheet: [C6p53.xlsx]Sheet1 Report Created: 10/12/2010 10:04:08 PM Target Cell (Min) Cell Name Original Value Final Value \$G\$27 total dist. distance travelled 0 985 Adjustable Cells Cell Name Original Value Final Value \$G\$3 athens 0 0 \$H\$3 columbia 0 1 \$I\$3 nashville 0 0 \$G\$4 athens 0 1 \$H\$4 columbia 0 0 \$I\$4 nashville 0 0 \$G\$5 athens 0 0 \$H\$5 columbia 0 0 \$I\$5 nashville 0 1 \$G\$6 athens 0 0 \$H\$6 columbia 0 1 \$I\$6 nashville 0 0 \$G\$7 athens 0 0 \$H\$7 columbia 0 0 \$I\$7 nashville 0 1 \$G\$8 athens 0 1 \$H\$8 columbia 0 0 \$I\$8 nashville 0 0 \$G\$9 athens 0 0 \$H\$9 columbia 0 1 \$I\$9 nashville 0 0 \$G\$10 athens 0 1 \$H\$10 columbia 0 0 \$I\$10 nashville 0 0 \$G\$11 athens 0 0 \$H\$11 columbia 0 0 \$I\$11 nashville 0 1 Constraints Cell Name Cell Value Formula Status Slack \$J\$3 binary sum 1 \$J\$3<=\$L\$3 Binding 0 \$J\$4 binary sum 1 \$J\$4<=\$L\$4 Binding 0 \$J\$5 binary sum 1 \$J\$5<=\$L\$5 Binding 0 \$J\$6 binary sum 1 \$J\$6<=\$L\$6 Binding 0 \$J\$7 binary sum 1 \$J\$7<=\$L\$7 Binding 0 \$J\$8 binary sum 1 \$J\$8<=\$L\$8 Binding 0 \$J\$9 binary sum 1 \$J\$9<=\$L\$9 Binding 0 \$J\$10 binary sum 1 \$J\$10<=\$L\$10 Binding 0 \$J\$11 binary sum 1 \$J\$11<=\$L\$11 Binding 0 \$G\$12 total refs athens 3 \$G\$12=\$G\$14 Not Binding 0 \$H\$12 total refs columbia 3 \$H\$12=\$H\$14 Not Binding 0 \$I\$12 total refs nashville 3 \$I\$12=\$I\$14 Not Binding 0 \$G\$3 athens 0 \$G\$3=binary Binding 0 \$H\$3 columbia 1 \$H\$3=binary Binding 0 \$I\$3 nashville 0 \$I\$3=binary Binding 0 \$G\$4 athens 1 \$G\$4=binary Binding 0 \$H\$4 columbia 0 \$H\$4=binary Binding 0 \$I\$4 nashville 0 \$I\$4=binary Binding 0 \$G\$5 athens 0 \$G\$5=binary Binding 0 \$H\$5 columbia 0 \$H\$5=binary Binding 0 \$I\$5 nashville

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.