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

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