Link to Dr.
Frederick's page
Link to
the MBA 510 page
To perform a linear programming problem in Lotus 1-2-3, follow these steps:
1. In a spreadsheet, set up
a matrix of coefficients for the constraints and for the objective function.
Note that the
whole inequality for the constraint is included in a cell--including the
inequality sign (<= or >=, as appropriate) and the value for the right-hand
side of the inequality. When Lotus evaluates this cell it will show
a 1 or a 0 depending on whether the inequality is true or false.
It is necessary
to specify the non-negativity constraints explicitly.
| A | B | C | D | E | F | |
| 1 | Constraints | X1 | X2 | X3 | Formulas | |
| 2 | Labor time | 64 | 33 | 14 | @sumproduct(b2..d2,b$9..d$9)<=400 | |
| 3 | Machine time | 50 | 60 | 9 | @sumproduct(b3..d3,b$9..d$9)<=400 | |
| 4 | Management time | 3 | 3 | 3 | @sumproduct(b4..d4,b$9..d$9)<=80 | |
| 5 | Non-negativity of X1 | 1 | 0 | 0 | +b9>=0 | |
| 6 | Non-negativity of X2 | 0 | 1 | 0 | +c9>=0 | |
| 7 | Non-negativity of X3 | 0 | 0 | 1 | +d9>=0 | |
| 8 | Objective Function | 3.5 | 0.45 | 2.2 | @sumproduct(b6..d6,b$9..d$9) | |
| 9 | Decision Variables | 1 | 1 | 1 | ||
| 10 |
2. Click on Range, then Analyze, then Solver.
3. Enter the instructions in the Solver Definition box.