Case study

ksmth0
LinearProgrammingTemplate-1.xlsx

LP_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.