Allocating people to teams is a task common in both sport and business. We allocate 32 people to 4 teams that are as balanced as possible.
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
We explore two aspects of refactoring an existing optimization model: Modularization and adding model variations.
This series explores optimization of a "picking warehouse" by improving the warehouse design and efficiency of the picking process.
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
Designing an optimization model is difficult. This article explains common mathematical notation used to define optimization model formulations.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.