Bin packing is a common optimization problem. A new formulation helps us solve a simple, yet difficult to solve, bin packing model.
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.
Why does my model find different solutions? Some solutions are better than others – how can that be true? How do I find the overall best solution?
To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.
We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?
