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.
We run optimization model cases 10 times faster, fully using the parallel capabilities of the CPU cores/threads in a modern computer.
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
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.