Optimization Modeling with Spreadsheets (ePub)

Reflects the latest applied research and featuresstate-of-the-art software for building and solving spreadsheetoptimization models
Thoroughly updated to reflect the latest topical and technicaladvances in the field, Optimization Modeling with Spreadsheets,Second Edition continues to focus on solving real-worldoptimization problems through the creation of mathematical modelsand the use of spreadsheets to represent and analyze those models.Developed and extensively classroom-tested by the author, the bookfeatures a systematic approach that equips readers with the skillsto apply optimization tools effectively without the need to rely onspecialized algorithms.
This new edition uses the powerful software package Risk SolverPlatform (RSP) for optimization, including its Evolutionary Solver,which employs many recently developed ideas for heuristicprogramming. The author provides expanded coverage of integerprogramming and discusses linear and nonlinear programming using asystematic approach that emphasizes the use of spreadsheet-basedoptimization tools. The Second Edition also features:

* Classifications for the various problem types, providing thereader with a broad framework for building and recognizingoptimization models
* Network models that allow for a more general form of massbalance
* A systematic introduction to Data Envelopment Analysis (DEA)
* The identification of qualitative patterns in order tomeaningfully interpret linear programming solutions
* An introduction to stochastic programming and the use of RSP tosolve problems of this type
Additional examples, exercises, and cases have been includedthroughout, allowing readers to test their comprehension of thematerial. In addition, a related website features MicrosoftOffice® Excel files to accompany the figures and data sets inthe book.
With its accessible and comprehensive presentation,Optimization Modeling with Spreadsheets, Second Edition isan excellent book for courses on deterministic models,optimization, and spreadsheet modeling at the upper-undergraduateand graduate levels. The book can also serve as a reference forresearchers, practitioners, and consultants working in business,engineering, operations research, and management science.