We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
This series explores optimization of a "picking warehouse" by improving the warehouse design and efficiency of the picking process.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.
Designing an optimization model is difficult. This article explains common mathematical notation used to define optimization model formulations.