This is an introductory textbook on optimization--that is, on mathematical programming--intended for undergraduates and graduate students in management or in engineering. The principal coverage includes linear programming, nonlinear programming, integer programming, and heuristic programming, and the emphasis is on model building using Excel and Solver.
The emphasis on model building (rather than algorithms) is one of the features that makes this book distinctive. Most textbooks devote more space to algorithmic details than to formulation principles. These days, however, it is not necessary to know a great deal about algorithms in order to apply optimization tools, especially when relying on the spreadsheet as a solution platform.
The emphasis on spreadsheets is another feature that makes this book distinctive. Few textbooks devoted to optimization pay much attention to spreadsheet implementation of optimization principles, and most book that emphasize model building ignore spreadsheets entirely. Thus, someone looking for a spreadsheetbased treatment would otherwise have to use a textbook that was designed for some other purpose, like a survey of management science topics, rather than one devoted to optimization.
Chapter 1 Introduction to Spreadsheet Models for Optimization
Chapter 2 Linear Programming Formulations: Allocation, Covering, and Blending Models
Chapter 3 Linear Programming Formulations Network Models
Chapter 4 Sensitivity Analysis in Linear Programs
Chapter 5 Liners Programming Formulations: Data Envelopment Analysis
Chapter 6 Integer Programming
Chapter 7 Nonliner Programming
Chapter 8 Heuristic Solutions With the Evolutionary Solver