We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
We explore two aspects of refactoring an existing optimization model: Modularization and adding model variations.
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
We minimize the number of racks required to accommodate all pallets in a warehouse, freeing space for other activities and allowing company growth.
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
Bin packing is a common optimization problem. A new formulation helps us solve a simple, yet difficult to solve, bin packing model.
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
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?