Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
This series explores optimization of a "picking warehouse" by improving the warehouse design and efficiency of the picking process.
Formulating logic conditions in linear programs can be difficult. This two-part article series explains how, using easy to follow steps.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
We minimize the number of racks required to accommodate all pallets in a warehouse, freeing space for other activities and allowing company growth.
Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.