Solver Max - Excel

Packing problems

Assign items to containers, minimizing the number of containers or maximizing value
Optimal selection

Make an optimal choice given preferences and available resources
Logistics

Determine the optimal quantity and timing of orders, including shipping and storage
Networks

Find the shortest, fastest, or cheapest path through a network
Stock mix

Decide the best stock mix, given customer demand, to maximize profit
Puzzles

Solve puzzles like Sudoku, magic squares, and algebra word puzzles
Cutting stock

Find the best way to cut stock material, given your requirements
Product mix

Find the best mix of products or ingredients
Capital investment

Choose the best capital investment options, given your budget and requirements
Team selection

Allocate team members in the best combination, given their skills and preferences
Scheduling

Schedule your resources to minimize time or maximize benefit
Production planning

Select machines or production processes to maximize efficiency or minimize cost
Portfolio optimization

Allocate resources across a portfolio of choices, to maximize return and minimize risk
Sports

Improve your fantasy sports team's performance by building an optimal line-up
Create groups

Assign people to groups to equalize distribution, maximize satisfaction, or minimize conflicts
Facility location

Locate facilities to minimize costs while meeting customer needs

Allocate people to balanced teams
CMPL 2.0 optimization tool
Coursera: Operations Research (series)
Coursera: Optimization for decision making
Excel Solver
Facility location optimization in Excel
Fantasy sports: Pick the best team
Frontline Systems
Future of COIN-OR
Green manufacturing via cutting patterns
Job sequencing to minimize completion time
On the shoulders of giants
One-dimensional packing: Wire cutting
OpenSolver
Optimization in Excel vs Python
Production mix via graphical LP
Project crashing: Time-cost trade-off
Symmetry-less 1D bin packing
Taking a dip in the MIP solution pool
Vaccination plan for Hong Kong

Page 1 of 2