This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.
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.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
We compare a linear programming model written using Julia/JuMP with the same model written using Python/Pyomo.
We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?
We present an example of project crashing using an optimization model to help the project manager decide what to do.
We explore two aspects of refactoring an existing optimization model: Modularization and adding model variations.