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
