We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
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.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.