Microsoft Office Tutorials and References
In Depth Information
9.3.4 Using Solver
Now let us consider the application of Solver and examine the resulting solution.
Assuming we have entered all the necessary formulation data and correctly pre-
pared the worksheet for Solver, we are now ready to execute the tool. Exhibit 9.5
shows the dialogue box called Solver Options . This dialogue box is available via
a button in the Solver Parameters box. The top five numerical parameter settings
( Max Time , etc.) are defaults and the recommended values for most problems.
I suggest that you not change these settings, unless, you have a well-informed
justification to do so. These settings control the technical aspects of the solu-
tion algorithms associated with Solver, and they are important to its precision and
In Exhibit 9.5 we can also see that the Assume Linear Model and Assume Non -
Negative boxes are checked. Both these conditions apply to our LP model and result
in improved calculation performance. When Solver can assume LP characteristics, it
simplifies and streamlines the solution procedure and also affects the solution output
format. As with the numerical parameter settings, leave the Estimates , Derivatives ,
and Search settings as they appear. You can now return to the Solver Parameters
box by selecting the OK button, and you are ready to launch Solver by selecting the
Solve button.
Exhibit 9.5 Running the solver tool
Search JabSto ::

Custom Search