Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.

This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.

To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.

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?

We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.

We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.

Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.

We explore methods to decide the best order for positioning devices in a rack: enumeration, heuristics, constraint programming, and linear programming.