An optimization problem is one where you have to make the best decision (choose the best investments, minimize your company’s costs, find the class schedule with the fewest morning classes, or so on).
An Excel workbook called ProfitMax.xls provides a simple example of how to use Solver and the Comparative Statics Wizard. The Comparative Statics Wizard is an Excel add-in that walks the user through ...