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.

Job sequencing is a common problem. Excel Solver can help you make optimal job sequencing decisions to minimize cost.

This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.

We estimate the speed improvement for optimization solvers in the 35 years from 1989 to 2024. The results may be surprising.

We compare a linear programming model written using Julia/JuMP with the same model written using Python/Pyomo.

We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.

We explore methods to decide the best order for positioning devices in a rack: enumerate, heuristic, constraint programming, and linear program.

Minimize the number of racks to store all pallets in a warehouse, freeing space for other activities and allowing company growth.

Bin packing is a common problem. A new formulation helps us solve a simple, yet difficult to solve, bin packing model.

How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.

To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.