Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
This series of 13 articles compares Python libraries Pyomo, PuLP, OR-Tools, Gekko, CVXPY, and SciPy for building a linear programming model.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.
We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
Formulating logic conditions in linear programs can be difficult. This two-part article series explains how, using easy to follow steps.