We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
We present an example of project crashing using an optimization model to help the project manager decide what to do.
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've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.