We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
This series explores optimization of a "picking warehouse" by improving the warehouse design and efficiency of the picking process.
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.