excel solver
optimization
simulation
optimization, tutorial, allocate scarce resources

   solver.com

Frontline Systems, Inc.  

quadratic programming, portfolio optimization, quadratic solver 
Developers of Your Spreadsheet's Solver  
robust optimization, stochastic programming, simulation optimization
   
finance, working capital management, capital budgeting

Optimization Tutorial for Solver Users


excel solver, portfolio optimization, Markowitz, investment
optimization, manufacturing, job shop scheduling

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

 

 
Welcome to our tutorial about Solvers for Excel and Visual Basic -- the easiest way to solve optimization problems -- from Frontline Systems, developers of the Solvers in Microsoft Excel, Lotus 1-2-3, and Quattro Pro.
 
bulletWhat are Solvers Good For?
bulletWhat Must I Do to Use a Solver?
bulletHow Do I Define a Model?
bulletWhat Kind of Solution Can I Expect?
bulletWhat Makes a Model Hard to Solve?
bulletCan You Show Me Step by Step?

After completing this tutorial, you can learn even more about topics such as linearity versus nonlinearity and sparsity in optimization models by taking our Advanced Tutorial.

What are Solvers Good For?

Solvers, or optimizers, are software tools that help users find the best way to allocate scarce resources. The resources may be raw materials, machine time or people time, money, or anything else in limited supply. The "best" or optimal solution may mean maximizing profits, minimizing costs, or achieving the best possible quality.  An almost infinite variety of problems can be tackled this way, but here are some typical examples:

Finance and Investment

Working capital management involves allocating cash to different purposes (accounts receivable, inventory, etc.) across multiple time periods, to maximize interest earnings.

Capital budgeting involves allocating funds to projects that initially consume cash but later generate cash, to maximize a firm's return on capital.

Portfolio optimization -- creating "efficient portfolios" -- involves allocating funds to stocks or bonds to maximize return for a given level of risk, or to minimize risk for a target rate of return.

Manufacturing

Job shop scheduling involves allocating time for work orders on different types of production equipment, to minimize delivery time or maximize equipment utilization.

Blending (of petroleum products, ores, animal feed, etc.) involves allocating and combining raw materials of different types and grades, to meet demand while minimizing costs.

Cutting stock (for lumber, paper, etc.) involves allocating space on large sheets or timbers to be cut into smaller pieces, to meet demand while minimizing waste.

Distribution and Networks

Routing (of goods, natural gas, electricity, digital data, etc.) involves allocating something to different paths through which it can move to various destinations, to minimize costs or maximize throughput.

Loading (of trucks, rail cars, etc.) involves allocating space in vehicles to items of different sizes so as to minimize wasted or unused space.

Scheduling of everything from workers to vehicles and meeting rooms involves allocating capacity to various tasks in order to meet demand while minimizing overall costs.

Next: What Must I Do to Use a Solver?

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.
  blending, CAPM, Sharpe, cutting stock   model, routing, loading, scheduling
spreadsheet solver
scarce resources