This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.
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 describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.