We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
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?
This series explores optimization of a "picking warehouse" by improving the warehouse design and efficiency of the picking process.
Designing an optimization model is difficult. This article explains common mathematical notation used to define optimization model formulations.
We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.
We explore two aspects of refactoring an existing optimization model: Modularization and adding model variations.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.