Optimization Modeling with Spreadsheets (with CD-ROM) (Duxbury Applied Series) - Hardcover

Baker, Kenneth

9780534494742: Optimization Modeling with Spreadsheets (with CD-ROM) (Duxbury Applied Series)

Hardcover

ISBN 10: 0534494749 ISBN 13: 9780534494742

Publisher: Cengage Learning, 2005

Ideal for students in managment and engineering, OPTIMIZATION MODELING WITH SPREADSHEETS (WITH CD-ROM) covers model building and include tutorials on the use of Excel's Solver, and, at a more advanced level, Frontline Systems' Premium Solver.

"synopsis" may belong to another edition of this title.

From the Back Cover:

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� 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.

About the Author:

Ken Baker is a faculty member at Dartmouth College. He is currently Nathaniel Leverone Professor of Management at the Tuck School of Business and also Adjunct Professor at the Thayer School of Engineering. He teaches courses relating to mathematical modeling and operations management. At present, he is a principal investigator on the Spreadsheet Engineering research project, and co-author (with Steve Powell) of The Art of Modeling with Spreadsheets. Over the years, much of Professor Baker's teaching and research has dealt with operations planning and control, and he is widely known for his textbook, Elements of Sequencing and Scheduling, in addition to a variety of technical articles. Professor Baker has served as Tuck School's Associate Dean and Associate Dean of Faculty, and he has directed the Tuck School's management development programs in the manufacturing area. Currently, he serves as a Co-director of Thayer School's Master's program in Engineering Management.

"About this title" may belong to another edition of this title.