Optimization is one of the most powerful tools available in Excel, with a broad range of applications such as inventory control, scheduling, asset allocation, product mix and many others.
Models developed for optimization can be either linear or non-linear. This demonstration goes through a classic textbook example of a relatively simple two product mix linear problem to give an idea of how to work with models involving Excel’s Solver Add-in. The video tutorial includes dicussion of the three Solver reports. The spreadsheets used in these videos may be downloaded from: Our resources page