| Microsoft Excel 16.0 Answer Report |
| Worksheet: [Final project2.xlsx]Model |
| Report Created: 3/18/2019 4:24:42 PM |
| Result: Solver found an integer solution within tolerance. All Constraints are satisfied. |
| Solver Engine |
| | Engine: Simplex LP |
| | Solution Time: 0.172 Seconds. |
| | Iterations: 2 Subproblems: 132 |
| Solver Options |
| | Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling |
| | Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative |
| Objective Cell (Min) |
| | Cell | Name | Original Value | Final Value |
| | $B$16 | total labor cost | $1,243 | $1,243 |
| Variable Cells |
| | Cell | Name | Original Value | Final Value | Integer |
| | $C$10 | Worker 1 Bakeries | 21 | 21 | Integer |
| | $D$10 | Worker 1 Coffee | 0 | 0 | Integer |
| | $E$10 | Worker 1 Other Drinks | 3 | 3 | Integer |
| | $C$11 | Worker 2 Bakeries | 1 | 1 | Integer |
| | $D$11 | Worker 2 Coffee | 33 | 33 | Integer |
| | $E$11 | Worker 2 Other Drinks | 1 | 1 | Integer |
| | $C$12 | Worker 3 Bakeries | 3 | 3 | Integer |
| | $D$12 | Worker 3 Coffee | 1 | 1 | Integer |
| | $E$12 | Worker 3 Other Drinks | 25 | 25 | Integer |
| Constraints |
| | Cell | Name | Cell Value | Formula | Status | Slack |
| | $B$20 | total hours of workers LHS | 24 | $B$20<=$D$20 | Not Binding | 13 |
| | $B$21 | LHS | 35 | $B$21<=$D$21 | Not Binding | 4 |
| | $B$22 | LHS | 29 | $B$22<=$D$22 | Not Binding | 9 |
| | $B$23 | total # of products demand LHS | 450 | $B$23=$D$23 | Binding | 0 |
| | $B$24 | LHS | 500 | $B$24=$D$24 | Binding | 0 |
| | $B$25 | LHS | 480 | $B$25=$D$25 | Binding | 0 |
| | $B$26 | worker constraints LHS | 21 | $B$26>=$D$26 | Not Binding | 1 |
| | $B$27 | LHS | 33 | $B$27>=$D$27 | Not Binding | 5.8 |
| | $B$28 | LHS | 25 | $B$28>=$D$28 | Not Binding | 1.8 |
| | $C$10:$E$12=Integer |