Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?
This series explores optimization of a "picking warehouse" by improving the warehouse design and efficiency of the picking process.
To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
Bin packing is a common optimization problem. A new formulation helps us solve a simple, yet difficult to solve, bin packing model.
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.