Allocating people to teams is a task common in both sport and business. We allocate 32 people to 4 teams that are as balanced as possible.
How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.