Book Description
Reflects the latest applied research and features stateoftheart 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 realworld optimization problems through the creation of mathematical models and the use of spreadsheets to represent and analyze those models. Developed and extensively classroomtested 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 spreadsheetbased 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 upperundergraduate 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.
Table of Contents
 Cover
 Title page
 Copyright page
 Preface
 Chapter 1: Introduction to Spreadsheet Models for Optimization
 Chapter 2: Linear Programming: Allocation, Covering, and Blending Models
 Chapter 3: Linear Programming: Network Models

Chapter 4: Sensitivity Analysis in Linear Programs
 4.1 Parameter Analysis in The Transportation Example
 4.2 Parameter Analysis in The Allocation Example
 4.3 The Sensitivity Report And The Transportation Example
 4.4 The Sensitivity Report and The Allocation Example
 4.5 Degeneracy and Alternative Optima
 4.6 Patterns in Linear Programming Solutions
 Summary
 Exercises
 Chapter 5: Linear Programming: Data Envelopment Analysis
 Chapter 6: Integer Programming: Binary Choice Models

Chapter 7: Integer Programming: Logical Constraints
 7.1 Simple Logical Constraints: Exclusivity and Contingency
 7.2 Linking Constraints: The Fixed Cost Problem
 7.3 Linking Constraints: The Threshold Level Problem
 7.4 Linking Constraints: The Facility Location Model
 7.5 Disjunctive Constraints: The Machine Sequencing Problem
 7.6 Tour and Subset Constraints: The Traveling Salesperson Problem
 Summary
 Exercises
 Chapter 8: Nonlinear Programming
 Chapter 9: Heuristic Solutions with the Evolutionary Solver
 Appendix 1: Optimization Software and Supplemental Files
 Appendix 2: Graphical Methods in Linear Programming
 Appendix 3: The Simplex Method
 Appendix 4: Stochastic Programming
 Index
Product Information
 Title: Optimization Modeling with Spreadsheets, Second Edition
 Author(s):
 Release date: May 2011
 Publisher(s): Wiley
 ISBN: 9780470928639