To set up Solver for the DJJ problem, choose Tools/Solver from the menu. A dialog box similar to the one shown in Figure B-4 appears. Setting up an optimization problem with Solver consists of four steps:

- Specify the
**Target Cell**(corresponds to the objective function in the algebraic model). - Specify the
**Changing Cells**(corresponds to the decision variables in the algebraic model). - Specify the
**Constraints**. - Specify
**Solver Options**.

These steps are easy if you have previously completed the algebraic formulation and spreadsheet model. They are very difficult, and perhaps impossible, if you haven't. Most difficulties students have with Solver are not really with Solver, but arise because they either have not fully understood the problem or developed an algebraic formulation or have not developed a correct and flexible spreadsheet model.

**Constraints**

In Solver, the limitations and requirements that must be met.

**Solver Options**

Solver provides many options for the solution process. For LPs, the two most commonly used are Assume Linear Model and Assume Non-Negative.

The Target Cell is the cell that you want to maximize ...

Start Free Trial

No credit card required