We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
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.
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 many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.