Page 1 of 2
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
Given available stock of wire and a list of pieces required, what is the best way to cut the stock to fulfil demand while minimizing waste?
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.