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?
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.