Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
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?
We present an example of project crashing using an optimization model to help the project manager decide what to do.
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.
Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.