Introduction to management science : a modeling and case studies approach with spreadsheets

Description

Cover Introduction to Management Science Dedication About the Authors About the Case Writers Preface Acknowledgments Brief Contents Contents Chapter One: Introduction 1.1 The Nature of Management Science 1.2 An Illustration of the Management Science Approach: Break-Even Analysis 1.3 The Relationship Between Analytics and Management Science 1.4 The Impact of Management Science 1.5 Some Special Features of this Book 1.6 Summary Glossary Learning Aids for This Chapter Solved Problem Problems Case 1-1 Keeping Time Chapter Two: Linear Programming: Basic Concepts 2.1 A Case Study: The Wyndor Glass Co. Product-Mix Problem 2.2 Formulating the Wyndor Problem on a Spreadsheet 2.3 The Mathematical Model in the Spreadsheet 2.4 The Graphical Method for Solving Two-Variable Problems 2.5 Using Excel’s Solver to Solve Linear Programming Problems 2.6 Analytic Solver 2.7 A Minimization Example—The Profit & Gambit Co. Advertising-Mix Problem 2.8 Linear Programming from a Broader Perspective 2.9 Summary Glossary Learning Aids for This Chapter Solved Problems Problems Case 2-1 Auto Assembly Case 2-2 Cutting Cafeteria Costs Case 2-3 Staffing a Call Center Chapter Three: Linear Programming: Formulation and Applications 3.1 A Case Study: The Super Grain Corp. Advertising-Mix Problem 3.2 Resource-Allocation Problems 3.3 Cost–Benefit–Trade-Off Problems 3.4 Mixed Problems 3.5 Transportation Problems 3.6 Assignment Problems 3.7 Model Formulation from a Broader Perspective 3.8 Summary Glossary Learning Aids for This Chapter Solved Problems Problems Case 3-1 Shipping Wood to Market Case 3-2 Capacity Concerns Case 3-3 Fabrics and Fall Fashions Case 3-4 New Frontiers Case 3-5 Assigning Students to Schools Case 3-6 Reclaiming Solid Wastes Case 3-7 Project Pickings Chapter Four: The Art of Modeling with Spreadsheets 4.1 A Case Study: The Everglade Golden Years Company Cash Flow Problem 4.2 Overview of the Process of Modeling with Spreadsheets 4.3 Some Guidelines for Building “Good” Spreadsheet Models 4.4 Debugging a Spreadsheet Model 4.5 Summary Glossary Learning Aids for This Chapter Solved Problems Problems Case 4-1 Prudent Provisions for Pensions Chapter Five: What-If Analysis for Linear Programming 5.1 The Importance of What-If Analysis to Managers 5.2 Continuing the Wyndor Case Study 5.3 The Effect of Changes in One Objective Function Coefficient 5.4 The Effect of Simultaneous Changes in Objective Function Coefficients 5.5 The Effect of Single Changes in a Constraint 5.6 The Effect of Simultaneous Changes in the Constraints 5.7 Robust Optimization 5.8 Chance Constraints with Analytic Solver 5.9 Summary Glossary Learning Aids for This Chapter Solved Problem Problems Case 5-1 Selling Soap Case 5-2 Controlling Air Pollution Case 5-3 Farm Management Case 5-4 Assigning Students to Schools (Revisited) Chapter Six: Network Optimization Problems 6.1 Minimum-Cost Flow Problems 6.2 A Case Study: The Bmz Co. Maximum Flow Problem 6.3 Maximum Flow Problems 6.4 Shortest Path Problems 6.5 Summary Glossary Learning Aids for This Chapter Solved Problems Problems Case 6-1 Aiding Allies Case 6-2 Money in Motion Case 6-3 Airline Scheduling Case 6-4 Broadcasting the Olympic Games Chapter Seven: Using Binary Integer Programming to Deal with Yes-or-No Decisions 7.1 A Case Study: The California Manufacturing Co. Problem 7.2 Using Bip for Project Selection: The Tazer Corp. Problem 7.3 Using Bip for The Selection of Sites for Emergency Services Facilities: The Caliente City Problem 7.4 Using Bip for Crew Scheduling: The Southwestern Airways Problem 7.5 Using Mixed Bip to Deal with Setup Costs for Initiating Production: The Revised Wyndor Problem 7.6 Summary Glossary Learning Aids for This Chapter Solved Problems Problems Case 7-1 Assigning Art Case 7-2 Stocking Sets Case 7-3 Assigning Students to Schools (Revisited) Case 7-4 Broadcasting the Olympic Games (Revisited) Chapter Eight: Nonlinear Programming 8.1 The Challenges of Nonlinear Programming 8.2 Nonlinear Programming with Decreasing Marginal Returns 8.3 Separable Programming 8.4 Difficult Nonlinear Programming Problems 8.5 Evolutionary Solver and Genetic Algorithms 8.6 Using Analytic Solver to Analyze a Model and Choose a Solving Method 8.7 Summary Glossary Learning Aids for This Chapter Solved Problem Problems Case 8-1 Continuation of the Super Grain Case Study Case 8-2 Savvy Stock Selection Case 8-3 International Investments Chapter Nine: Decision Analysis 9.1 A Case Study: The Goferbroke Company Problem 9.2 Decision Criteria 9.3 Decision Trees 9.4 Sensitivity Analysis with Decision Trees 9.5 Checking Whether to Obtain More Information 9.6 Using New Information to Update the Probabilities 9.7 Using a Decision Tree to Analyze the Problem with a Sequence of Decisions 9.8 Performing Sensitivity Analysis on the Problem with a Sequence of Decisions 9.9 Using Utilities to Better Reflect the Values of Payoffs 9.10 The Practical Application of Decision Analysis 9.11 Summary Glossary Learning Aids for This Chapter Solved Problems Problems Case 9-1 Who Wants to Be a Millionaire? Case 9-2 University Toys and the Business Professor Action Figures Case 9-3 Brainy Business Case 9-4 Smart Steering Support Chapter Ten: Forecasting 10.1 An Overview of Forecasting Techniques 10.2 A Case Study: The Computer Club Warehouse (CCW) Problem 10.3 Applying Time-Series Forecasting Methods to the Case Study 10.4 The Time-Series Forecasting Methods in Perspective 10.5 Causal Forecasting with Linear Regression 10.6 Judgmental Forecasting Methods 10.7 Summary Glossary Summary of Key Formulas Learning Aids for This Chapter Solved Problem Problems Case 10-1 Finagling the Forecasts Chapter Eleven: Queueing Models 11.1 Elements of a Queueing Model 11.2 Some Examples of Queueing Systems 11.3 Measures of Performance for Queueing Systems 11.4 A Case Study: The Dupit Corp. Problem 11.5 Some Single-Server Queueing Models 11.6 Some Multiple-Server Queueing Models 11.7 Priority Queueing Models 11.8 Some Insights about Designing Queueing Systems 11.9 Economic Analysis of the Number of Servers to Provide 11.10 Summary Glossary Key Symbols Learning Aids for This Chapter Solved Problem Problems Case 11-1 Queueing Quandary Case 11-2 Reducing In-Process Inventory Chapter Twelve: Computer Simulation: Basic Concepts 12.1 The Essence of Computer Simulation 12.2 A Case Study: Herr Cutter’s Barber Shop (Revisited) 12.3 Analysis of the Case Study 12.4 Outline of a Major Computer Simulation Study 12.5 Summary Glossary Learning Aids for This Chapter Solved Problem Problems Case 12-1 Planning Planers Case 12-2 Reducing In-Process Inventory (Revisited) Chapter Thirteen: Computer Simulation with Analytic Solver 13.1 A Case Study: Freddie the Newsboy’s Problem 13.2 Bidding for a Construction Project: A Prelude to the Reliable Construction Co. Case Study 13.3 Project Management: Revisiting the Reliable Construction Co. Case Study 13.4 Financial Risk Analysis: Revisiting the Think-Big Development Co. Problem 13.5 Revenue Management in the Travel Industry 13.6 Choosing the Right Distribution 13.7 Decision Making with Parameter Analysis Reports and Trend Charts 13.8 Optimizing with Computer Simulation Using the Solver in Analytic Solver 13.9 Summary Glossary Learning Aids for This Chapter Solved Problem Problems Case 13-1 Action Adventures Case 13-2 Pricing under Pressure Case 13-3 Financial Planning for Retirement Appendix A: Tips for Using Microsoft Excel for Modeling Appendix B: Partial Answers to Selected Problems Index