Benchmark Assignment - Data Analysis Case Study
Malik_Prof
linear_programming_template_0_1.xlsxLP_min
| Linear, Integer and Mixed Integer Programming | |||||||||||||||
| Signs | |||||||||||||||
| < | less than or equal to | ||||||||||||||
| = | equals (You need to enter an apostrophe first.) | ||||||||||||||
| > | greater than or equal to | ||||||||||||||
| Data | Results | Problem setup area | |||||||||||||
| x 1 | x 2 | x 3 | x 4 | x 5 | LHS | Slack/Surplus | |||||||||
| Minimize | 1 | 1 | 1 | 1 | 1 | sign | RHS | 0 | < constraints | > constraints | |||||
| 10 AM-1 PM | > | 3 | 0 | 3 | 0 | 0 | 0 | 3 | |||||||
| 1:00 PM - 4:00 PM | > | 4 | 0 | 4 | 0 | 0 | 0 | 4 | |||||||
| 4:00 PM- 7:00 PM | > | 6 | 0 | 6 | 0 | 0 | 0 | 6 | |||||||
| 7:00 PM- 10:00 PM | > | 7 | 0 | 7 | 0 | 0 | 0 | 7 | |||||||
| 10:00 PM- 1:00 AM | > | 4 | 0 | 4 | 0 | 0 | 0 | 4 | |||||||
| Results | |||||||||||||||
| Variables | 0 | 0 | |||||||||||||
| Objective | 0 |
Enter the values in the shaded area. Then go to the DATA Tab on the ribbon, click on Solver in the Data Analysis Group and then click SOLVE. If SOLVER is not on the Data Tab then please see the Help file (Solver) for instructions. To use Integer variables, define them in the Solver model as a constraint.
