Page 2 of 5
We explore two aspects of refactoring an existing optimization model: Modularization and adding model variations.
Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
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 present an example of project crashing using an optimization model to help the project manager decide what to do.
To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.