Solver Engine Engine Simplex LP Solution Time 98784644247 Seconds Iterations 2

Solver engine engine simplex lp solution time

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
Image of page 7
Image of page 8
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
Image of page 9
$C$17:$L$17=Binary
Image of page 10
Image of page 11

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture