Optimization Modeling with Spreadsheets - Hardcover

Baker, Kenneth R.

Hardcover

ISBN 10: 0470928638 ISBN 13: 9780470928639

Verlag: John Wiley & Sons, 2011

Inhaltsangabe

This introductory book on optimization (mathematical programming) includes coverage on linear programming, nonlinear programming, integer programming and heuristic programming; as well as an emphasis 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 books 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 books devoted to optimization pay much attention to spreadsheet implementation of optimization principles, and most books that emphasize model building ignore spreadsheets entirely. Thus, someone looking for a spreadsheet-based treatment would otherwise need to use a book that was designed for some other purpose, like a survey of management science topics, rather than one devoted to optimization. The model building emphasis derives from an attempt to be realistic about what readers need most when learning about optimization. At an introductory level, the most practical and motivating theme is the wide applicability of optimization tools. To apply optimization effectively, readers needs more than a brief exposure to a series of numerical examples, which is the way that most mathematical programming books treat applications. With a systematic modeling emphasis, readers can begin to see the basic structures that appear in optimization models and as a result, develop an appreciation for potential applications well beyond the examples in the book. Formulating optimization models is both an art and a science, and this book pays attention to both. The art can be refined with practice, especially supervised practice, just the way a student would learn sculpture or painting. The science is reflected in the structure that organizes the topics in this book. For example, there are several distinct problem types that lend themselves to linear programming formulations, and it makes sense to study these types systematically. In that spirit, the book builds a library of templates against which new problems can be compared. Analogous structures are developed for the presentation of other topics as well.

Über diesen Titel

Über die Autorin bzw. den Autor

Kenneth R. Baker, PhD, is Nathaniel Leverone Professor of Management at the Tuck School of Business and Adjunct Professor of Engineering at Dartmouth College. A Fellow of the Institute for Operations Research and the Management Sciences (INFORMS), Dr. Baker has published extensively in his area of research interest, which include mathematical modeling, spreadsheet engineering, and scheduling. He is coauthor of Principles of Sequencing and Scheduling and Management Science: The Art of Modeling with Spreadsheets, Third Edition, both published by Wiley.

Von der hinteren Coverseite

Reflects the latest applied research and features state-of-the-art software for building and solving spreadsheet optimization models
 
Thoroughly updated to reflect the latest topical and technical advances in the field, Optimization Modeling with Spreadsheets, Second Edition continues to focus on solving real-world optimization problems through the creation of mathematical models and the use of spreadsheets to represent and analyze those models. Developed and extensively classroom-tested by the author, the book features a systematic approach that equips readers with the skills to apply optimization tools effectively without the need to rely on specialized algorithms.
 
This new edition uses the powerful software package Risk Solver Platform (RSP) for optimization, including its Evolutionary Solver, which employs many recently developed ideas for heuristic programming. The author provides expanded coverage of integer programming and discusses linear and nonlinear programming using a systematic approach that emphasizes the use of spreadsheet-based optimization tools. The Second Edition also features:
* Classifications for the various problem types, providing the reader with a broad framework for building and recognizing optimization models
* Network models that allow for a more general form of mass balance
* A systematic introduction to Data Envelopment Analysis (DEA)
* The identification of qualitative patterns in order to meaningfully interpret linear programming solutions
* An introduction to stochastic programming and the use of RSP to solve problems of this type
 
Additional examples, exercises, and cases have been included throughout, allowing readers to test their comprehension of the material. In addition, a related website features Microsoft Office(r) Excel files to accompany the figures and data sets in the book.
 
With its accessible and comprehensive presentation, Optimization Modeling with Spreadsheets, Second Edition is an excellent book for courses on deterministic models, optimization, and spreadsheet modeling at the upper-undergraduate and graduate levels. The book can also serve as a reference for researchers, practitioners, and consultants working in business, engineering, operations research, and management science.

Details zur Ausgabe

• Verlag: John Wiley & Sons
• Erscheinungsdatum: 2011
• Sprache: Englisch
• ISBN 10: 0470928638
• ISBN 13: 9780470928639
• Einband: Gebundene Ausgabe
• Auflage: 2
• Anzahl der Seiten: 432
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Nicht verfügbar