Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?
Sometimes we need more power to solve a model. This article describes how to solve a model using the CPLEX solver via the NEOS Server.
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
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.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.