management science modeling - gbv管理科学建模g.PDF

A 4TH EDITION Management Science Modeling S. Christian Albright Kelley School of Business, Indiana University Wayne L. Winston Kelley School of Business, Indiana University With Cases by Mark Broadie Graduate School of Business, Columbia University Lawrence L. Lapin San Jose State University William D. Whisler California State University, Hayward SOUTH-WESTERN CENGAGE Learning- Australia ? Brazil ? Japan ? Korea ? Mexico ? Singapore ? Spain ? United Kingdom ? United States Contents Preface xi CHAPTER I Introduction to Modeling I 1.1 Introduction 3 1.2 A Waiting-Line Example 4 1.3 Modeling Versus Models 7 1.4 The Seven-Step Modeling Process 8 1.5 A Great Source for Management Science Applications: Interfaces 14 1.6 Why Study Management Science? 14 1.7 Software Included with This Book 16 1.8 Conclusion 18 CHAPTER 2 Introduction to Spreadsheet Modeling 21 2.1 Introduction 22 2.2 Basic Spreadsheet Modeling: Concepts and Best Practices 22 2.3 Cost Projections 27 2.4 Breakeven Analysis 31 2.5 Ordering with Quantity Discounts and Demand Uncertainty 40 2.6 Estimating the Relationship between Price and Demand 45 2.7 Decisions Involving the Time Value of Money 55 2.8 Conclusion 61 Appendix Tips for Editing and Documenting Spreadsheets 65 CHAPTER 3 Introduction to Optimization Modeling 67 3.1 Introduction 68 3.2 Introduction to Optimization 69 3.3 A Two-Variable Product Mix Model 70 3.4 Sensitivity Analysis 83 3.5 Properties of Linear Models 94 3.6 Infeasibility and Unboundedness 97 3.7 A Larger Product Mix Model 100 3.8 A Multiperiod Production Model 108 3.9 A Comparison of Algebraic and Spreadsheet Models 118 3.10 A Decision Support System 118 3.11 Conclusion 121 Appendix Information on Solvers 128 C A S E 3.1 Shelby Shelving 129 C A S E 3.2 Sonoma Valley Wines 131 CHAPTER 4 Linear Programming Models 133 4.1 Introduction 134 4.2 Advertising Models 135 4.3 Worker Scheduling Models 145 4.4 Aggregate Planning Models 152 4.5 Blending Models 163 4.6 Production Process Models 171