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?
We explore two aspects of refactoring an existing optimization model: Modularization and adding model variations.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
Bin packing is a common optimization problem. A new formulation helps us solve a simple, yet difficult to solve, bin packing model.
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
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?
We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.
We estimate the speed improvement for optimization solvers in the 35 years from 1989 to 2024. The results may be surprising.