We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.

Allocating people to teams is a task common in both sport and business. We allocate 32 people to 4 teams that are as balanced as possible.

We present an example of project crashing using an optimization model to help the project manager decide what to do.

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?

Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.

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.

Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.