Case study
ksmth0
LinearProgrammingTemplate-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 Elissa Torres: Linear, Integer and Mixed Integer Programming: Submodel = 0; Problem size @ 5 by 5 | 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.
