The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
We explore two aspects of refactoring an existing optimization model: Modularization and adding model variations.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?
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.