ADM 2302 Assignment 2 Problem 2 - Microsoft Excel 15.0 Answer Report Worksheet[ADM 2302 Assignment 2 Problem 2]Problem 2 Report Created 6:47:22 PM

ADM 2302 Assignment 2 Problem 2 - Microsoft Excel 15.0...

This preview shows page 1 - 2 out of 4 pages.

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 4 pages?

• Fall '05
• EL
• Addition, LHS, Centuries in the future