Optimization Modeling with Spreadsheets

Spreadsheet-based introduction to mathematical programming concepts and applications, intended for undergraduate and graduate students in management and engineering. Its emphasis on model building and its focus on formulation principles are key features that reinforce its practical approach. The text also includes a comprehensive tutorial on the use of Excel Premium Solver.Features * Each chapter includes classifications for problem types, which provide a practical guide and broad understanding of possible applications. * Network models are presented in a broader framework extending the student?s capability for recognizing and analyzing network problems. * This text provides a systematic introduction to Data Envelopment Analysis (DEA). * The text discusses in detail the identification of patterns providing an important framework for interpreting linear programming solutions. * Integer programming applications include a number of well-known combinatorial problems, such as facility location, machine sequencing, and the traveling salesperson problems. * Describes the use of Frontline Systems? Evolutionary Solver a special version of Premium Solver, which includes Evolutionary Solver, and is included with each new copy of the book. * End-of-chapter exercises include a number of interesting and challenging applied problems. * Includes cases to accompany each of the major topics. * Introduces advanced Excel skills where needed.