We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
This series explores optimization of a "picking warehouse" by improving the warehouse design and efficiency of the picking process.
Allocating people to teams is a task common in both sport and business. We allocate 32 people to 4 teams that are as balanced as possible.
We estimate the speed improvement for optimization solvers in the 35 years from 1989 to 2024. The results may be surprising.
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 minimize the number of racks required to accommodate all pallets in a warehouse, freeing space for other activities and allowing company growth.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.