We present an example of project crashing using an optimization model to help the project manager decide what to do.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
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.
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.
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 series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.