Title:
Optimization modeling with spreadsheets
Personal Author:
Series:
Duxbury applied series
Publication Information:
Belmont, CA : Thomson Brooks / Cole, 2006
Physical Description:
1 CD-ROM ; 12 cm.
ISBN:
9780534494742
General Note:
Accompanies text of the same title : HB143.7 B34 2006
Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
|---|---|---|---|---|---|
Searching... | 30000010108094 | CP 7701 | Computer File Accompanies Open Access Book | Compact Disc Accompanies Open Access Book | Searching... |
On Order
Summary
Summary
Presenting a spreadsheet-based introduction to mathematical programming concepts and applications, this book emphasizes on model building. It also includes a tutorial on the use of Excel's Solver and Frontline Systems Premium Solver and is intended for undergraduate and graduate students in management and engineering.
Table of Contents
| 1 Introduction to Spreadsheet Modeling for Optimization |
| Elements of a Model |
| Spreadsheet Models |
| A Hierarchy for Analysis |
| Optimization Software |
| Using Solver |
| Summary |
| Homework |
| 2 Linear Programming Formulations: Allocation, Covering, and Blending Models |
| Linear Models |
| Allocation Models |
| Blending Models |
| Modeling Errors in Linear Programming |
| Summary |
| Homework |
| 3 Linear Programming Formulations: Network Models |
| The Transportation Model |
| The Assignment Model |
| The Transshipment Model |
| Features of Special Network Models |
| Building Network Models with Balance Equations |
| General Network Models with Expanding Flows |
| General Network Models with Transformed Flows |
| Summary |
| Homework |
| 4 Sensitivity Analysis Linear Programs |
| Sensitivity Analysis Transportation Example |
| Sensitivity Analysis in the Allocation Example |
| The Sensitivity Report and the Transportation Example |
| The Sensitivity Report and the Allocation Example |
| Degeneracy and Alternative Optima |
| Patterns in Linear Programming Solutions |
| Summary |
| Homework |
| 5 Linear Programming Formulations: Data Envelopment Analysis |
| A Graphical Perspective on DEA |
| An Algebraic Perspective on DEA |
| A Spreadsheet Model for DEA |
| Indexing |
| Finding Reference Sets and HCUs |
| Assumptions and Limitations of DEA |
| Summary |
| Homework |
| 6 Integer Programming |
| Using Solver with Integer Requirements |
| Models with Binary Choice |
| Models with Qualitative Constraints |
| The Facility Location Model |
| The Algorithm for Solving Integer Programs |
| Summary |
| Homework |
| 7 Nonlinear Programming |
| One-Variable Models |
| Local Optima and Search for an Optimum |
| Two-Variable Models |
| Nonlinear Models with Constraints |
| Linearizations |
| Summary |
| Homework |
| 8 Heuristic Solutions with the Evolutionary Solver |
| Features of the Evolutionary Solver |
| An Illustrative Example: Nonlinear Regression |
| The Machine-Sequence Problem Revisited |
| The Traveling Salesperson Problem Revisited |
| Multi-Machine Scheduling |
| Two-Dimensional Location |
| Group Assignment |
| Summary |
| Homework |
| Appendix I Software |
| Appendix II Graphical Methods in Linear Programming |
| Appendix III The Simplex Method |
| Appendix IV Stochastic Programming. |
