Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
Sometimes we need more power to solve a model. This article describes how to solve a model using the CPLEX solver via the NEOS Server.
How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.
We minimize the number of racks required to accommodate all pallets in a warehouse, freeing space for other activities and allowing company growth.
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 replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
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?