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 |

    More about Altwrnate Essay

      Open Document