Designing an optimization model is difficult. This article explains common mathematical notation used to define optimization model formulations.

We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?

Job sequencing is a common problem. Excel Solver can help you make optimal job sequencing decisions to minimize cost.

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

We explore methods to decide the best order for positioning devices in a rack: enumerate, heuristic, constraint programming, and linear program.

We run optimization model cases 10 times faster, fully using the parallel capabilities of the CPU cores/threads in a modern computer.

Academic research papers can be tremendously valuable. But only if they are complete. So, academics, please publish your data and code.

Minimize the number of racks to store all pallets in a warehouse, freeing space for other activities and allowing company growth.

This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.

The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.

To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.

Why does my model find different solutions? Some solutions are better than others – how can that be? How do I find the best solution?