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 stock of wire and a list of pieces required, what is the best way to cut the stock to fulfil demand while minimizing waste?
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
We explore methods to decide the best order for positioning devices in a rack: enumeration, heuristics, constraint programming, and linear programming.
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
We run optimization model cases 10 times faster, fully using the parallel capabilities of the CPU cores/threads in a modern computer.