Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
We compare a linear programming model written using Julia/JuMP with the same model written using Python/Pyomo.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.