This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
We run optimization model cases 10 times faster, fully using the parallel capabilities of the CPU cores/threads in a modern computer.
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
Given available stock of wire and a list of pieces required, what is the best way to cut the stock to fulfil demand while minimizing waste?
Designing an optimization model is difficult. This article explains common mathematical notation used to define optimization model formulations.
Bin packing is a common optimization problem. A new formulation helps us solve a simple, yet difficult to solve, bin packing model.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.