next up previous contents
Next: Second Example: Market Allocations Up: Introductory Example Previous: Solving the Model

Using Solver

Rather than the somewhat tedious and error-prone graphical method (which is limited to linear programs with 2 variables), special computer programs can be used to find solutions to linear programming models. The most widespread program is undoubted Solver, included in all recent versions of the Excel spreadsheet program. Solver, while not a state of the art code (which can cost upwards of $15,000 per copy) is a reasonably robust, easy-to-use tool for linear programming. Solver uses standard spreadsheets together with an interface to define variables, objective, and constraints to define a linear program.

It is difficult to describe in words how to create a Solver spreadsheet, so we will do one or two in class. Here is a brief outline and some hints and shortcuts:


next up previous contents
Next: Second Example: Market Allocations Up: Introductory Example Previous: Solving the Model

Michael A. Trick
Mon Aug 24 14:40:57 EDT 1998