excel solver
optimization
simulation
feasible solution, optimal solution

   solver.com

Frontline Systems, Inc.  

quadratic programming, portfolio optimization, quadratic solver 
Developers of Your Spreadsheet's Solver  
robust optimization, stochastic programming, simulation optimization
   
excel solver, optimization software

Solver Tutorial - Interpreting Solutions


globally optimal, locally optimal

 
Home
Register
What's New
Solver Tutorial
Solver Technology
Select a Product
Excel Users
Developers
MATLAB Users
Macintosh Users
Government Users
Academic Users
Press/Analysts
Privacy Policy
 

 

 
A solution (set of values for the decision variables) for which all of the constraints in the Solver model are satisfied is called a feasible solution. Most solution algorithms first try to find a feasible solution, and then try to improve it by finding another feasible solution that increases the value of the objective function (when maximizing, or decreases it when minimizing).
  An optimal solution is a feasible solution where the objective function reaches a maximum (or minimum) value.

A globally optimal solution is one where there are no other feasible solutions with better objective function values. A locally optimal solution is one where there are no other feasible solutions "in the vicinity" with better objective function values -- you can picture this as a point at the top of a "peak" or at the bottom of a "valley" which may be formed by the objective function and/or the constraints. The Solver is designed to find optimal solutions -- ideally the global optimum -- but this is not always possible. In many cases, though, you may be happy to find a good solution -- one that is better than the solution you are using now.

Whether the Solver can find a globally optimal solution, a locally optimal solution, or a good solution depends on the nature of the mathematical relationship between the variables and the objective function and constraints (and the solution algorithm used). For more information, click on the link "What Makes a Model Hard to Solve?" 

Next: What Makes a Model Hard to Solve?

Back to Tutorial Start

To Learn More:
For instant access to example models, full-text User Guides, and to download free 15-day trial versions of our software products whenever you're ready, you can register now.
User Type
Email Address
Name First Last
Company University
Phone

Trial version passwords are sent to the above email address: See Privacy Policy.
Our Premium Solver Platform works with existing Excel Solver models, solves much larger problems up to hundreds of times faster, and solves new kinds of problems via Evolutionary Solver.  Solver Engines plug into the Premium Solver Platform.
   
Solver Platform SDK makes it easy to solve any type or size of optimization problem in your Visual Basic, VB.NET, C/C++, C#, Java, or MATLAB program. And it's easy to deploy your application with our flexible licensing for software vendors and corporate developers.
  global optimization   objective, maximize, minimize
spreadsheet solver
scarce resources