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?
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
We present an example of project crashing using an optimization model to help the project manager decide what to do.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.