| |
| |
| |
Introduction to Modeling | |
| |
| |
| |
Introduction | |
| |
| |
| |
A Waiting-Line Example | |
| |
| |
| |
Modeling versus Models | |
| |
| |
| |
The Seven-Step Modeling Process | |
| |
| |
| |
Successful Management Science Applications | |
| |
| |
| |
Why Study Management Science? | |
| |
| |
| |
Software Included in This Book | |
| |
| |
| |
Conclusion | |
| |
| |
| |
Introductory Spreadsheet Modeling | |
| |
| |
| |
Introduction | |
| |
| |
| |
Basic Spreadsheet Modeling Concepts | |
| |
| |
| |
Modeling Examples | |
| |
| |
| |
Conclusion | |
| |
| |
| |
Tips for Editing and Documenting Spreadsheets | |
| |
| |
| |
Introduction to Optimization Modeling | |
| |
| |
| |
Introduction | |
| |
| |
| |
A Brief History of Linear Programming | |
| |
| |
| |
Introduction to LP Modeling | |
| |
| |
| |
Sensitivity Analysis and the Solver Table Add-In | |
| |
| |
| |
The Linear Assumptions | |
| |
| |
| |
Graphical Solution Method | |
| |
| |
| |
Infeasibility and Unboundedness | |
| |
| |
| |
A Multiperiod Production Problem | |
| |
| |
| |
A Decision Support System | |
| |
| |
| |
Conclusion | |
| |
| |
| |
Information on Solvers | |
| |
| |
| |
Shelby Shelving | |
| |
| |
| |
Linear Programming Models | |
| |
| |
| |
Introduction | |
| |
| |
| |
Static Workforce Scheduling Models | |
| |
| |
| |
Aggregate Planning Models | |
| |
| |
| |
Dynamic Workforce Planning Models | |
| |
| |
| |
Blending Models | |
| |
| |
| |
Production Process Models | |
| |
| |
| |
Dynamic Financial Models | |
| |
| |
| |
Data Envelopment Analysis (DEA) | |
| |
| |
| |
Conclusion | |
| |
| |
| |
Lakefield Corporation's Oil Trading Desk | |
| |
| |
| |
Foreign Currency Trading | |
| |
| |
| |
Network Models | |
| |
| |
| |
Introduction | |
| |
| |
| |
Transportation Models | |
| |
| |
| |
More General Logistics Models | |
| |
| |
| |
Non-Logistics Network Models | |
| |
| |
| |
Project Scheduling Models | |
| |
| |
| |
Conclusion | |
| |
| |
| |
Optimized Motor Carrier Selection at Westvaco | |
| |
| |
| |
Linear Optimization Models with Integer Variables | |
| |
| |
| |
Introduction | |
| |
| |
| |
Approaches to Optimization with Integer Variables | |
| |
| |
| |
Capital Budgeting Models | |
| |
| |
| |
Fixed-Cost Models | |
| |
| |
| |
Lockbox Models | |
| |
| |
| |
Plant and Warehouse Location Models | |
| |
| |
| |
Set-Covering Models | |
| |
| |
| |
Models with Either-Or Constraints | |
| |
| |
| |
Cutting Stock Models | |
| |
| |
| |
Conclusion | |
| |
| |
| |
Giant Motor Company I | |
| |
| |
| |
Nonlinear Optimization Models | |
| |
| |
| |
Introduction | |
| |
| |
| |
Basic Ideas of Nonlinear Optimization | |
| |
| |
| |
Pricing Models | |
| |
| |
| |
Sales Force Allocation Models | |
| |
| |
| |
Facility Location Models | |
| |
| |
| |
Rating Sports Teams | |
| |
| |
| |
Estimating the Beta of a Stock | |
| |
| |
| |
Portfolio Optimization | |
| |
| |
| |
Conclusion | |
| |
| |
| |
GMS Stock Hedging | |
| |
| |
| |
Durham Asset Management | |
| |
| |
| |
Evolutionary Solver: An Alternative Optimization Procedure | |
| |
| |
| |
Introduction | |
| |
| |
| |
Introduction to Genetic Algorithms | |
| |
| |
| |
Introduction to the Evolutionary Solver | |
| |
| |
| |
Nonlinear Pricing Models | |
| |
| |
| |
Combinatorial Models | |
| |
| |
| |
Fitting an S-Shaped Curve | |
| |
| |
| |
Portfolio Optimization | |
| |
| |
| |
Cluster Analysis | |
| |
| |
| |
Discriminant Analysis | |
| |
| |
| |
Conclusion | |
| |
| |
| |
Assigning MBA Students to Teams | |
| |
| |
| |
Multi-Objective Decision Making | |
| |
| |
| |
Introduction | |
| |
| |
| |
Goal Programming | |
| |
| |
| |
Pareto Optimality and Trade-off Curves | |
| |
| |
| |
The Analytic Hierarchy Process | |
| |
| |
| |
Conclusion | |
| |
| |
| |
Play Time Toy Company | |
| |
| |
| |
Decision Making Under Uncertainty | |
| |
| |
| |
Introduction | |
| |
| |
| |
Elements of a Decision Analysis | |
| |
| |
| |
More Single-Stage Examples | |
| |
| |
| |
Multistage Decision Problems | |
| |
| |
| |
Bayes' Rule | |
| |
| |
| |
Incorporating Attitudes Toward Risk | |
| |
| |
| |
Conclusion | |
| |
| |
| |
GMC Motor Company II | |
| |
| |
| |
Jogger Shoe Company | |
| |
| |
| |
Westhouser Paper Company | |
| |
| |
| |
Introduction to Simulation Modeling | |
| |
| |
| |
Introduction | |
| |
| |
| |
Real Applications of Simulation | |
| |
| |
| |
Generating Uniformly Distributed Random Numbers | |
| |
| |
| |
Simulation with Built-In Excel Tools | |
| |
| |
| |
Generating Random Numbers from Other Probability Distributions | |
| |
| |
| |
Introduction to @ Risk | |
| |
| |
| |
Correlation in @ Risk | |
| |
| |
| |
Conclusion | |
| |
| |
| |
Ski Jacket Production | |
| |
| |
| |
Ebony Bath Soap | |
| |
| |
| |
Simulation Models | |
| |
| |
| |
Introduction | |
| |
| |
| |
Operations Models | |
| |
| |
| |
Financial Models | |
| |
| |
| |
Marketing Models | |
| |
| |
| |
Simulating Games of Chance | |
| |
| |
| |
Using TopRank with @ Risk for Powerful Modeling | |
| |
| |
| |
Conclusion | |
| |
| |
| |
A College Fund Investment Decision | |
| |
| |
| |
Bond Investment Strategy | |
| |
| |
| |
Financials at Carco | |
| |
| |
| |
Inventory Models | |
| |
| |
| |
Introduction | |
| |
| |
| |
Categories of Inventory Models | |
| |
| |
| |
Types of Costs in Inventory Models | |
| |
| |
| |
Economic Order Quantity (EOQ) Models | |
| |
| |
| |
Probabilistic Inventory Models | |
| |
| |
| |
Ordering Simulation Models | |
| |
| |
| |
Supply Chain Models | |
| |
| |
| |
Conclusion | |
| |
| |
| |
Subway Token Hoarding | |
| |
| |
| |
Retail Pricing Using Retailer | |
| |
| |
| |
Queueing Models | |
| |
| |
| |
Introduction | |
| |
| |
| |
Elements of Queueing Models | |
| |
| |
| |
The Exponential Distribution | |
| |
| |
| |
Important Queueing Relationships | |
| |
| |
| |
Analytical Models | |
| |
| |
| |
Queueing Simulation | |
| |
| |
| |
Conclusion | |
| |
| |
| |
The Catalog Company Problem | |
| |
| |
| |
Regression Analysis | |
| |
| |
| |
Introduction | |
| |
| |
| |
Scatterplots: Graphing Relationships | |
| |
| |
| |
Correlations: Indicators of Linear Relationships | |
| |
| |
| |
Simple Linear Regression | |
| |
| |
| |
Multiple Regression | |
| |
| |
| |
The Statistical Model | |
| |
| |
| |
Inferences About the Regression Coefficients | |
| |
| |
| |
Multicollinearity | |
| |
| |
| |
Modeling Possibilities | |
| |
| |
| |
Prediction | |
| |
| |
| |
Conclusion | |
| |
| |
| |
Quantity Discounts at the FirmChair Company | |
| |
| |
| |
Demand for French Bread at Howie's | |
| |
| |
| |
Investing for Retirement | |
| |
| |
| |
Heating Oil at Dupree Fuels Company | |
| |
| |
| |
Forecasting Overhead at Wagner Printers | |
| |
| |
| |
Time Series Analysis and Forecasting | |
| |
| |
| |
Introduction | |
| |
| |
| |
General Concepts | |
| |
| |
| |
Random Series | |
| |
| |
| |
The Random Walk Model | |
| |
| |
| |
Autoregression Models | |
| |
| |
| |
Regression-Based Trend Models | |
| |
| |
| |
Moving Averages | |
| |
| |
| |
Exponential Smoothing | |
| |
| |
| |
Deseasonalizing: The Ratio-to-Moving-Averages Method | |
| |
| |
| |
Estimating Seasonality with Regression | |
| |
| |
| |
Conclusion | |
| |
| |
| |
Arrivals at the Credit Union | |
| |
| |
| |
Forecasting Weekly Sales at Amanta | |
| |
| |
References | |
| |
| |
Index | |