Book description
An accessible introduction to optimization analysis using spreadsheets
Updated and revised, Optimization Modeling with Spreadsheets, Third Edition emphasizes model building skills in optimization analysis. By emphasizing both spreadsheet modeling and optimization tools in the freely available Microsoft Office Excel Solver, the book illustrates how to find solutions to realworld optimization problems without needing additional specialized software.
The Third Edition includes many practical applications of optimization models as well as a systematic framework that illuminates the common structures found in many successful models. With focused coverage on linear programming, nonlinear programming, integer programming, and heuristic programming, Optimization Modeling with Spreadsheets, Third Edition features:
An emphasis on model building using Excel Solver as well as appendices with additional instructions on more advanced packages such as Analytic Solver Platform and OpenSolver
Additional space devoted to formulation principles and model building as opposed to algorithms
New endofchapter homework exercises specifically for novice model builders
Presentation of the Sensitivity Toolkit for sensitivity analysis with Excel Solver
Classification of problem types to help readers see the broader possibilities for application
Specific chapters devoted to network models and data envelopment analysis
A companion website with interactive spreadsheets and supplementary homework exercises for additional practice
Optimization Modeling with Spreadsheets, Third Edition is an excellent textbook for upperundergraduate and graduatelevel courses that include deterministic models, optimization, spreadsheet modeling, quantitative methods, engineering management, engineering modeling, operations research, and management science. The book is an ideal reference for readers wishing to advance their knowledge of Excel and modeling and is also a useful guide for MBA students and modeling practitioners in business and nonprofit sectors interested in spreadsheet optimization.
Table of contents
 COVER
 TITLE PAGE
 PREFACE
 1 INTRODUCTION TO SPREADSHEET MODELS FOR OPTIMIZATION
 2 LINEAR PROGRAMMING: ALLOCATION, COVERING, AND BLENDING MODELS
 3 LINEAR PROGRAMMING: NETWORK MODELS

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
 5 LINEAR PROGRAMMING: DATA ENVELOPMENT ANALYSIS
 6 INTEGER PROGRAMMING: BINARYCHOICE MODELS

7 INTEGER PROGRAMMING: LOGICAL CONSTRAINTS
 7.1 SIMPLE LOGICAL CONSTRAINTS: EXCLUSIVITY
 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 MACHINESEQUENCING PROBLEM
 7.6 TOUR CONSTRAINTS: THE TRAVELING SALESPERSON PROBLEM
 SUMMARY
 EXERCISES
 8 NONLINEAR PROGRAMMING
 9 HEURISTIC SOLUTIONS WITH THE EVOLUTIONARY SOLVER
 Appendix 1: SUPPLEMENTAL FILES AND SOFTWARE
 Appendix 2: GRAPHICAL METHODS FOR LINEAR PROGRAMMING
 Appendix 3: THE SIMPLEX METHOD
 INDEX
 END USER LICENSE AGREEMENT
Product information
 Title: Optimization Modeling with Spreadsheets, 3rd Edition
 Author(s):
 Release date: July 2015
 Publisher(s): Wiley
 ISBN: 9781118937693
You might also like
book
C++ Crash Course
Upgrade your Code with C++ C++ is one of the most widely used languages for realworld …
book
Automate the Boring Stuff with Python, 2nd Edition
If you’ve ever spent hours renaming files or updating hundreds of spreadsheet cells, you know how …
book
Effective Python: 90 Specific Ways to Write Better Python, 2nd Edition
Updated and Expanded for Python 3 It’s easy to start developing programs with Python, which is …
book
Practical SQL
"Practical SQL is an approachable and fastpaced guide to SQL (Structured Query Language), the standard programming …