Page 4 of 5
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
We compare a linear programming model written using Julia/JuMP with the same model written using Python/Pyomo.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
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?
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.