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?
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
We minimize the number of racks required to accommodate all pallets in a warehouse, freeing space for other activities and allowing company growth.
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.