Learn more about Optimization
- Home
- Solutions
- Analytic Method
- Learn more about Optimization
Use Analytic Solver Optimization to allocate resources such as money, people and time, with the full range of solving methods
Optimization helps you find the best way to allocate resources: money, staff time, raw materials or inventory, energy, warehouse space, and more. In each case, multiple decisions must be made in the best possible way while simultaneously satisfying a number of constraints. The "best" or optimal solution might mean maximizing profits, minimizing costs, or achieving the best possible quality. Below are some examples.
Classic Solver Tutorial using a Product Mix problem (multiple pages, step by step)
Modern Optimization Tutorial using a Call Center Scheduling problem (one page)
Finance and Investment
- Working capital management decides how much cash to allocate to accounts receivable or inventory across multiple time periods.
- Capital budgeting decides how much money to invest in projects that initially consume cash but later generate cash.
- Portfolio optimization -- creating "efficient portfolios" -- decides how much money to invest in stocks or bonds.
Manufacturing
- Job shop scheduling decides how to best assign work to different types of production equipment.
- Blending (of petroleum products, ores, animal feed, etc.) decides how to combine raw materials of different types and grades.
- Cutting stock (for lumber, paper, etc.) decides how to cut large sheets or timbers into smaller pieces, to minimize waste.
Distribution and Networks
- Routing (of goods, natural gas, electricity, etc.) decides which paths items should move through to arrive at desired destinations.
- Loading (of trucks, rail cars, etc.) decides how packages of different sizes can best use vehicle space.
- Scheduling of workers, vehicles or meeting rooms decides how these resources should be allocated to various tasks.
Review or download a full set of example Solver models.
We're Here to Help
- Question or Comment
- Support Live Chat
- Consulting Help
- Support KnowledgeBase
-
Call Us
Inside USA: 888-831-0333
Outside: 01+775-831-0300
