Notes:
GitHub: Diet in PuLP.
Why does my model find different solutions? Some solutions are better than others – how can that be? How do I find the best solution?
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
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?
We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
Bin packing is a common problem. A new formulation helps us solve a simple, yet difficult to solve, bin packing model.
To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
This series explores optimization of a "picking warehouse" by improving the warehouse design and efficiency of the picking process.
We estimate the speed improvement for optimization solvers in the 35 years from 1989 to 2024. The results may be surprising.
We explore two aspects of refactoring an existing optimization model: Modularization and adding model variations.
We run optimization model cases 10 times faster, fully using the parallel capabilities of the CPU cores/threads in a modern computer.
Academic research papers can be tremendously valuable. But only if they are complete. So, academics, please publish your data and code.
