Code. Models. Analysis. Decisions.

Linear Programming & Optimization with Excel

For versions of Excel: Excel for Office 365, Excel for Office 365 for Mac, Excel 2016, Excel 2016 for Mac, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2008 for Mac, Excel 2007

Optimization and Linear Programming Using Solver

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.

You may also be interested in using Excel and Solver to create an optimal solution for a Network Transportation Problem.

The spreadsheet used in this video may be downloaded here.