Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.
We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.
We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.