Page 1 of 2
We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?
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.
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
This series of 13 articles compares Python libraries Pyomo, PuLP, OR-Tools, Gekko, CVXPY, and SciPy for building a linear programming model.
We minimize the number of racks required to accommodate all pallets in a warehouse, freeing space for other activities and allowing company growth.