We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
Page 17 of 35
Why does my model find different solutions? Some solutions are better than others – how can that be? How do I find the best solution?
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
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?
Academic research papers can be tremendously valuable. But only if they are complete. So, academics, please publish your data and code.
We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.
This series explores optimization of a "picking warehouse" by improving the warehouse design and efficiency of the picking process.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.
We present an example of project crashing using an optimization model to help the project manager decide what to do.
We explore methods to decide the best order for positioning devices in a rack: enumerate, heuristic, constraint programming, and linear program.
This series of 13 articles compares Python libraries Pyomo, PuLP, OR-Tools, Gekko, CVXPY, and SciPy for building a linear programming model.
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
