Microsoft Excel 15.0 Answer Report
Worksheet: [ADM 2302 Assignment 2 Problem 2.xls]Problem 2
Report Created: 13/10/2016 6:47:22 PM
Result: Solver found a solution.
All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.016 Seconds.
Iterations: 14 Subproblems: 0
Solver Options
Max Time 100 sec,
Iterations 100, Precision 0.000001
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 5%, Solve Without Integer Con
Objective Cell (Min)
Cell
Name
Original Value
Final Value
$P$5
Cost Totals
$0.00
$6,558,000.00
Variable Cells
Cell
Name
Original Value
Final Value
Integer
$C$3
Solution Regular
0
3000 Contin
$D$3
Solution Overtime
0
500 Contin
$E$3
Solution Regular
0
2000 Contin
$F$3
Solution Overtime
0
400 Contin
$G$3
Solution Regular
0
3000 Contin
$H$3
Solution Overtime
0
500 Contin
$I$3
Solution Regular
0
3200 Contin
$J$3
Solution Overtime
0
0 Contin
$K$3
Solution January
0
700 Contin
$L$3
Solution February
0
100 Contin
$M$3
Solution March
0
100 Contin
$N$3
Solution April
0
300 Contin
Constraints
Cell
Name
Cell Value
Formula
Status
Slack
$O$8

#### You've reached the end of your free preview.

Want to read all 8 pages?

- Fall '05
- EL
- Addition, Assignment 2, LHS, ADM 2302, Summer 2018