An Introduction to Spreadsheet Optimization Using Excel

How can one use "optimizers" to solve linear, nonlinear, and integer programs within spreadsheets?
Mark Broadie  | Spring 2012
Operations
Print this page

The major PC-based spreadsheets used today, Lotus, Excel, and Quattro, all have built-in optimizers. These optimizers allow linear, nonlinear, and integer programs to be solved within the spreadsheet. This guide provides a step-by-step introduction to using the optimizer that is built into Microsoft Excel.

Case ID: 120201

Buy select cases through Ivey Publishing and Harvard Business Publishing.

 

Contact us by e-mail at Columbia CaseWorks or 212-854-1796.