To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
This series explores optimization of a "picking warehouse" by improving the warehouse design and efficiency of the picking process.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
Bin packing is a common optimization problem. A new formulation helps us solve a simple, yet difficult to solve, bin packing model.
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
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?