Transport.xlsx - Microsoft Excel 16.0 Answer Report Worksheet[Book1]Sheet1 Report Created 2:45:03 AM Result Solver found a solution All Constraints and

# Transport.xlsx - Microsoft Excel 16.0 Answer Report...

• 21

This preview shows page 1 - 7 out of 21 pages.

Microsoft Excel 16.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 9/26/2019 2:45:03 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.078 Seconds. Iterations: 9 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Min) Cell Name Original Value Final Value \$N\$12 Z 116 202 Variable Cells Cell Name Original Value Final Value Integer \$B\$12 X1A 1 10 Contin \$C\$12 X2A 1 0 Contin \$D\$12 X3A 1 0 Contin \$E\$12 X1B 1 0 Contin \$F\$12 X2B 1 8 Contin \$G\$12 X3B 1 0 Contin \$H\$12 X1C 1 3 Contin \$I\$12 X2C 1 8 Contin \$J\$12 X3C 1 1 Contin \$K\$12 X1D 1 0 Contin \$L\$12 X2D 1 0 Contin \$M\$12 X3D 1 16 Contin Constraints Cell Name Cell Value Formula Status Slack \$B\$16 Constraint 1 LHS 13 \$B\$16=\$C\$16 Binding 0 \$B\$17 Constraint2 LHS 16 \$B\$17=\$C\$17 Binding 0 \$B\$18 Constraint3 LHS 17 \$B\$18=\$C\$18 Binding 0 \$B\$19 Constraint4 LHS 10 \$B\$19=\$C\$19 Binding 0 \$B\$20 Constraint5 LHS 8 \$B\$20=\$C\$20 Binding 0 \$B\$21 Constraint6 LHS 12 \$B\$21=\$C\$21 Binding 0 \$B\$22 Constraint7 LHS 16 \$B\$22=\$C\$22 Binding 0
A B C D Subgrade available A B 1 3 9 8 16 13 2 8 2 15 1 7 17 16 14 0 3 12 19 4 5 17 11 18 Subgrade required 10 8 12 16 46 10 8 A B C D 2 -8 14 15 0 10 -6 0 6 7 -8 8 -8 -3 3 4 -11 2 8 14 15 10 8 3 4 5 6 7 Available A 0 1.7 3.2 6 0 30 B 2.3 0 1.5 4.3 0 300 C 6.8 4.5 2 0 0 10 D 8.3 6 3.5 1.5 0 100 Required 30 120 140 50 100 440 3 4 5 6 7 30 0 30 120 140 40 300 10 10 40 60 100 30 120 140 50 100
C D A B C D A 7 15 13 10 3 13 2 6 16 16 8 8 16 3 4 17 4 13 17 12 16 10 8 12 16 10 (+) 3(-) 13 10 3 13 8 16 8 8 16 4(-) 13(+) 17 1 16 17 12 16 10 8 12 16 Penalty 0 1.7 3.2 6 0 30 0 1.7 2.3 0 1.5 4.3 0 300 0 1.5 6.8 4.5 2 0 0 10 0 8.3 6 3.5 1.5 0 100 1.5 30 120 140 50 100 Penalty 2.3 1.7 0.5 1.5 0 4.5 2 2.8 3 4 5 6 7 6 0 0 1.5 1.5 0 0 1 16 0 0 1.5 1.5 0 0 2 16 -1.5 -1.5 0 0 -1.5 3 17 0 0 1.5 1.5 0 0 Required tons/day 80 0 0 1.5 1.5 0
B C D 15 13 0 6 16 3 4 17 8 12 16 2 1 7 -8 0 1 0 6 7 -1 -2 -3 3 4 -4 2 1 7 8 6 7 8 6 7 0 0 2 100 0 0 0 1 2 50 0 0 1 0 2 30 0 0 80 40 60 0 0 7 8 Available tons/day 6 7 8 16 18 100 80 20 100 17 18 50 50 50 16 18 30 20 10 30 40 60 180 80 40 60
8 2 0 2 0 2 0 0
Microsoft Excel 16.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 9/26/2019 3:06:47 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.109 Seconds. Iterations: 17 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Min) Cell Name Original Value Final Value \$N\$7 Z 202 202 Variable Cells Cell Name Original Value Final Value Integer \$B\$7 X1A 10 10 Contin \$C\$7 X2A 0 0 Contin \$D\$7 X3A 0 0 Contin \$E\$7 X1B 0 0 Contin \$F\$7 X2B 8 8 Contin \$G\$7 X3B 0 0 Contin \$H\$7 X1C 3 3 Contin \$I\$7 X2C