Given available stock of wire and a list of pieces required, what is the best way to cut the stock to fulfil demand while minimizing waste?
Why does my model find different solutions? Some solutions are better than others – how can that be true? How do I find the overall best solution?
How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.
We estimate the speed improvement for optimization solvers in the 35 years from 1989 to 2024. The results may be surprising.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
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.