Optimizing Project Selection: A Spreadsheet Tutorial

Spreadsheet optimization is a great way to improve your decision making on a practical basis without having to use difficult or expensive software. Here we use the example of selecting a capital project to show how an optimization model built in Excel can arrive at the best decision using the Solver tool. This tutorial spreadsheet includes an annotated working model, as well as a customizable template to get you started building your own. After reviewing this instructional spreadsheet, you’ll have a good sense of the Solver tool, and you’ll have all the information you need to start building a model with real-world complexity.

Like this content? Why not share it?