We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?
Bin packing is a common optimization problem. A new formulation helps us solve a simple, yet difficult to solve, bin packing model.
Why does my model find different solutions? Some solutions are better than others – how can that be true? How do I find the overall best solution?
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
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?
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.