Operations Research Models and Methods / Computation / Mathematical Programming /
Linear/Integer Programming

Solving the Problem

The problem is Solved by clicking on the Solve button. When using the Excel Solver, the model is created, loaded into the Solver program and the algorithmic portion of Solver is called to obtain a solution. The solution for the example is shown below. The optimum decision variable values are in the range H8:L8. The objective function value is in F4. The constraint values give the evaluation of the constraint expressions for the optimum solution.

The change button is used to change the structure of the problem by changing the numbers of variables and/or constraints or by changing the integer nature of the variables. The solver option, the Goal (max or min) and the Sensitivity choice can also be changed. All changes are automatically incorporated into the Solver model.

Sensitivity Analysis

Updated 1/16/01
Operations Research Models and Methods

by Paul A. Jensen and Jon Bard, University of Texas, Copyright by the Authors