# Altwrnate Essay

426 WordsOct 5, 20112 Pages
CASE 2 ANSWER REPORT Microsoft Excel 14.0 Answer Report | | | | | | | | | | Worksheet: [alternate2TRIAL2.xlsx]Sheet1 | | | | | | | | | | Report Created: 9/30/2011 1:10:33 PM | | | | | | | | | | Result: Solver found a solution. All Constraints and optimality conditions are satisfied. | | | | | | | Solver Engine | | | | | | | | | | | | Engine: Simplex LP | | | | | | | | | | | | Solution Time: 0.047 Seconds. | | | | | | | | | | | Iterations: 20 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 Constraints, Assume NonNegative | | | | | | | | | | | | | | | | | | | | | | | | | | | | Objective Cell (Min) | | | | | | | | | | | | Cell | Name | Original Value | Final Value | | | | | | | | | | \$AC\$27 | Obj fn | 121828.8925 | 121828.8925 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Variable Cells | | | | | | | | | | | | Cell | Name | Original Value | Final Value | Integer | | | | | | | | | \$B\$2 | xtb | 236.6433566 | 236.6433566 | Contin | | | | | | | | | \$C\$2 | xtl | 54.54545455 | 54.54545455 | Contin | | | | | | | | | \$D\$2 | xtma | 0 | 0 | Contin | | | | | | | | | \$E\$2 | xtmb | 0 | 0 | Contin | | | | | | | | | \$F\$2 | xtmc | 0 | 0 | Contin | | | | | | | | | \$G\$2 | xtcr | 0 | 0 | Contin | | | | | | | | | \$H\$2 | xtcf | 0 | 0 | Contin | | | | | | | | | \$I\$2 | xtg | 39.39393939 | 39.39393939 | Contin | | | | | | | | | \$J\$2 | xtl | 21.21212121 |