We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
We explore two aspects of refactoring an existing optimization model: Modularization and adding model variations.
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
Designing an optimization model is difficult. This article explains common mathematical notation used to define optimization model formulations.
How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.