| Introduction to spreadsheet modeling | |
| Introduction to Modeling | |
| Introduction | |
| A Waiting Line Example | |
| Modeling Versus Models | |
| The Seven-Step Modeling Process | |
| A Successful Management Science Application | |
| Why Study Management Science? Software Included in This Book | |
| Conclusion | |
| Introductory Spreadsheet Modeling | |
| Introduction | |
| Basic Spreadsheet Modeling: Concepts and Best Practices | |
| Cost Projections | |
| Breakeven Analysis | |
| Ordering with Quantity Discounts and Demand Uncertainty | |
| Decisions Involving the Time Value of Money | |
| Conclusion | |
| Appendix: Tips for Editing and Documenting Spreadsheets | |
| Decision making under certainty | |
| Introduction to Optimization Modeling | |
| Introduction | |
| Introduction to Optimization | |
| A Two-Variable Model | |
| Sensitivity Analysis | |
| Properties of Linear Models | |
| Infeasibility and Unboundedness | |
| A Product Mix Model | |
| A Multiperiod Production Model | |
| A Comparison of Algebraic and Spreadsheet Models | |
| A Decision Support System | |
| Conclusion | |
| Appendix: Information on Solvers | |
| Linear Programming Models | |
| Introduction | |
| Advertising Models | |
| Static Workforce Scheduling Models | |
| Aggregate Planning Models | |
| Blending Models | |
| Production Process Models | |
| Financial Models | |
| Conclusion | |
| Network Models | |
| Introduction | |
| Transportation Models | |
| Assignment Models | |
| Minimum Cost Network Flow Models | |
| Shortest Path Models | |
| Project Scheduling Models | |
| Conclusion | |
| Linear Optimization Models with Integer Variables | |
| Introduction | |
| Overview of Optimization with Integer Variables | |
| Capital Budgeting Models | |
| Fixed-Cost Models | |
| Set Covering Models and Location/Assignment Models | |
| Conclusion | |
| Nonlinear Optimization Models | |
| Introduction | |
| Basic Ideas of Nonlinear Optimization | |
| Pricing Models | |
| Advertising Response and Selection Models | |
| Facility Location Models | |
| Models for Rating Sports Teams | |
| Portfolio Optimization Models | |
| Conclusion | |
| Decision making under uncertainty | |
| Decision Making Under Uncertainty | |
| Introduction | |
| Elements of a Decision Analysis | |
| The PrecisionTree Add-In | |
| Bayes? Rule | |
| Multistage Decision Problems | |
| Incorporating Attitudes Toward Risk | |
| Conclusion | |
| Introduction to Simulation Modeling | |
| Introduction | |
| Real Applications of Simulation | |
| Probability Distributions for Input Variables | |
| Simulation with Built-In Excel Tools | |
| Introduction to @RISK | |
| The Effect of Input Distributions on Results | |
| Conclusion | |
| Simulation Models | |
| Introduction | |
| Operations Models | |
| Financial Models | |
| Marketing Models | |
| Simulating Games of Chance | |
| Conclusion | |
| Queuing Models | |
| Introduction | |
| Elements of Queuing Models | |
| The Exponential Distribution | |
| Important Queueing | |
| Relationships | |
| Analytical Queuing Models | |
| Queuing Simulation Models | |
| Conclusion | |
| Regression and Forecasting Models | |
| Introduction | |
| Overview of Regression Models | |
| Simple Regression Models | |
| Multiple Regression Models | |
| Overview of Time Series Models | |
| Moving Averages Models | |
| Exponential Smoothing Models | |
| Conclusion | |
| Table of Contents provided by Publisher. All Rights Reserved. |