This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
Why does my model find different solutions? Some solutions are better than others – how can that be true? How do I find the overall best solution?
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
Designing an optimization model is difficult. This article explains common mathematical notation used to define optimization model formulations.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
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.