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...

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
Image of page 1
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
Image of page 2
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
Image of page 3
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
Image of page 4
8 2 0 2 0 2 0 0
Image of page 5
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
Image of page 6
Image of page 7

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture