Solver Engine Engine Simplex LP Solution Time 98784644247 Seconds Iterations 2

# Solver engine engine simplex lp solution time

• 11

This preview shows page 7 - 11 out of 11 pages.

Solver Engine Engine: Simplex LP Solution Time: 98784644.247 Seconds. Iterations: 2 Subproblems: 2 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonN Objective Cell (Max) Cell Name Original Value Final Value \$C\$6 Max Y2 230000 230000 Variable Cells Cell Name Original Value Final Value Integer \$B\$3 Y1 1 1 Binary \$C\$3 Y2 0 0 Binary \$D\$3 X1 28000 28000 Contin \$E\$3 X2 0 0 Contin Constraints Cell Name Cell Value Formula Status Slack \$G\$6 Max M 28000 \$G\$6<=\$I\$6 Not Binding 99971999 \$G\$7 M 0 \$G\$7<=\$I\$7 Binding 0 \$G\$9 M 700 \$G\$9<=\$I\$9 Binding 0 \$B\$3:\$C\$3=Binary
Microsoft Excel 16.17 Answer Report Worksheet: [IE_HW4_12.4-6.xlsx]Sheet1 Report Created: 10/19/18 8:12:54 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 103079931.92 Seconds. Iterations: 18 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Solve Without Objective Cell (Min) Cell Name Original Value Final Value \$P\$19 Total Cost 0 12 Variable Cells Cell Name Original Value Final Value Integer \$C\$17 x1 0 0 Binary \$D\$17 x2 0 0 Binary \$E\$17 x3 0 0 Binary \$F\$17 x4 0 1 Binary \$G\$17 x5 0 1 Binary \$H\$17 x6 0 0 Binary \$I\$17 x7 0 0 Binary \$J\$17 x8 0 1 Binary \$K\$17 x9 0 0 Binary \$L\$17 x10 0 0 Binary Constraints Cell Name Cell Value Formula Status Slack \$M\$17 Total 3 \$M\$17=\$O\$17 Binding 0 \$M\$4 A Total 1 \$M\$4<=\$O\$4 Binding 0 \$M\$5 B Total 1 \$M\$5<=\$O\$5 Binding 0 \$M\$6 C Total 1 \$M\$6<=\$O\$6 Binding 0 \$M\$7 D Total 1 \$M\$7<=\$O\$7 Binding 0 \$M\$8 E Total 1 \$M\$8<=\$O\$8 Binding 0 \$M\$9 F Total 1 \$M\$9<=\$O\$9 Binding 0 \$M\$10 G Total 1 \$M\$10<=\$O\$10 Binding 0 \$M\$11 H Total 1 \$M\$11<=\$O\$11 Binding 0 \$M\$12 I Total 1 \$M\$12<=\$O\$12 Binding 0
\$C\$17:\$L\$17=Binary