Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets

Title
Contents
1 Introduction
	1.1 The Nature of Management Science
	1.2 An Illustration of the Management Science Approach: Break-Even Analysis
	1.3 The Impact of Management Science
	1.4 Some Special Features of This Book
	1.5 Summary
	Glossary
	Learning Aids for This Chapter in Your MS Courseware
	Solved Problem
	Problems
2 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 to Solve Linear Programming Problems
	2.6 A Minimization Example—The Profit & Gambit Co. Advertising-Mix Problem
	2.7 Linear Programming from a Broader Perspective
	2.8 Summary
	Glossary
	Learning Aids for This Chapter in Your MS Courseware
	Solved Problems
	Problems
	Case 2-1 Auto Assembly
	Case 2-2 Cutting Cafeteria Costs
	Case 2-3 Staffing a Call Center
3 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 in Your MS Courseware
	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
4 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 in Your MS Courseware
	Solved Problems
	Problems
	Case 4-1 Prudent Provisions for Pensions
5 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 Summary
	Glossary
	Learning Aids for This Chapter in Your MS Courseware
	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)
6 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 in Your MS Courseware
	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
7 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 in Your MS Courseware
	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)
8 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 Summary
	Glossary
	Learning Aids for This Chapter in Your MS Courseware
	Solved Problem
	Problems
	Case 8-1 Continuation of the Super Grain Case Study
	Case 8-2 Savvy Stock Selection
	Case 8-3 International Investments
9 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 in Your MS Courseware
	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
10 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 in Your MS Courseware
	Solved Problem
	Problems
	Case 10-1 Finagling the Forecasts
11 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 in Your MS Courseware
	Solved Problem
	Problems
	Case 11-1 Queueing Quandary
	Case 11-2 Reducing In-Process Inventory
12 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 in Your MS Courseware
	Solved Problem
	Problems
	Case 12-1 Planning Planers
	Case 12-2 Reducing In-Process Inventory (Revisited)
13 Computer Simulation with Crystal Ball
	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 Cash Flow Management: Revisiting the Everglade Golden Years Company Case Study
	13.5 Financial Risk Analysis: Revisiting the Think-Big Development Co. Problem
	13.6 Revenue Management in the Travel Industry
	13.7 Choosing the Right Distribution
	13.8 Decision Making with Decision Tables
	13.9 Optimizing with OptQuest
	13.10 Summary
	Glossary
	Learning Aids for This Chapter in Your MS Courseware
	Solved Problem
	Problems
	Case 13-1 Action Adventures
	Case 13-2 Pricing under Pressure
Appendix A Using the Solver Table
Appendix B Tips for Using Microsoft Excel for Modeling
Appendix C Partial Answers to Selected Problems
Index