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.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
We present an example of project crashing using an optimization model to help the project manager decide what to do.