We compare a linear programming model written using Julia/JuMP with the same model written using Python/Pyomo.
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
We estimate the speed improvement for optimization solvers in the 35 years from 1989 to 2024. The results may be surprising.
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.