An Introduction to Management Science: Quantitative Approach

Description

Gain a sound conceptual understanding of the role that management science plays in the decision-making process with the market leader that integrates the latest developments in Microsoft Office Excel 2016. The market-leading Anderson/Sweeney/Williams/Camm/Cochran/Fry/Ohlmann's AN INTRODUCTION TO MANAGEMENT SCIENCE: QUANTITATIVE APPROACHES TO DECISION MAKING, 15E uses a proven problem-scenario approach to introduce each quantitative technique within an applications setting. All data sets, applications, and screen visuals reflect the details of Excel 2016 to effectively prepare readers to work with the latest spreadsheet tools. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version. Cover Brief Contents Contents Preface About the Authors Chapter 1: Introduction 1.1 Problem Solving and Decision Making 1.2 Quantitative Analysis and Decision Making 1.3 Quantitative Analysis 1.4 Models of Cost, Revenue, and Profit 1.5 Management Science Techniques Summary Glossary Problems Case Problem Scheduling a Golf League Appendix 1.1 Using Excel for Breakeven Analysis Chapter 2: An Introduction to Linear Programming 2.1 A Simple Maximization Problem 2.2 Graphical Solution Procedure 2.3 Extreme Points and the Optimal Solution 2.4 Computer Solution of the Par, Inc., Problem 2.5 A Simple Minimization Problem 2.6 Special Cases 2.7 General Linear Programming Notation Summary Glossary Problems Case Problem 1 Workload Balancing Case Problem 2 Production Strategy Case Problem 3 Hart Venture Capital Appendix 2.1 Solving Linear Programs with Excel Solver Appendix 2.2 Solving Linear Programs with LINGO Chapter 3: Linear Programming: Sensitivity Analysis and Interpretation of Solution 3.1 Introduction to Sensitivity Analysis 3.2 Graphical Sensitivity Analysis 3.3 Sensitivity Analysis: Computer Solution 3.4 Limitations of Classical Sensitivity Analysis 3.5 The Electronic Communications Problem Summary Glossary Problems Case Problem 1 Product Mix Case Problem 2 Investment Strategy Case Problem 3 Truck Leasing Strategy Appendix 3.1 Sensitivity Analysis with Excel Solver Appendix 3.2 Sensitivity Analysis with LINGO Chapter 4: Linear Programming Applications in Marketing, Finance, and Operations Management 4.1 Marketing Applications 4.2 Financial Applications 4.3 Operations Management Applications Summary Problems Case Problem 1 Planning an Advertising Campaign Case Problem 2 Schneider's Sweet Shop Case Problem 3 Textile Mill Scheduling Case Problem 4 Workforce Scheduling Case Problem 5 Duke Energy Coal Allocation Appendix 4.1 Excel Solution of Hewlitt Corporation Financial Planning Problem Chapter 5: Advanced Linear Programming Applications 5.1 Data Envelopment Analysis 5.2 Revenue Management 5.3 Portfolio Models and Asset Allocation 5.4 Game Theory Summary Glossary Problems Chapter 6: Distribution and Network Models 6.1 Supply Chain Models 6.2 Assignment Problem 6.3 Shortest-Route Problem 6.4 Maximal Flow Problem 6.5 A Production and Inventory Application Summary Glossary Problems Case Problem 1 Solutions Plus Case Problem 2 Supply Chain Design Appendix 6.1 Excel Solution of Transportation, Transshipment, and Assignment Problems Chapter 7: Integer Linear Programming 7.1 Types of Integer Linear Programming Models 7.2 Graphical and Computer Solutions for an All-Integer Linear Program 7.3 Applications Involving 0-1 Variables 7.4 Modeling Flexibility Provided by 0-1 Integer Variables Summary Glossary Problems Case Problem 1 Textbook Publishing Case Problem 2 Yeager National Bank Case Problem 3 Production Scheduling with Changeover Costs Case Problem 4 Applecore Children's Clothing Appendix 7.1 Excel Solution of Integer Linear Programs Appendix 7.2 LINGO Solution of Integer Linear Programs Chapter 8: Nonlinear Optimization Models 8.1 A Production Application-Par, Inc., Revisited 8.2 Constructing an Index Fund 8.3 Markowitz Portfolio Model 8.4 Blending: The Pooling Problem 8.5 Forecasting Adoption of a New Product Summary Glossary Problems Case Problem 1 Portfolio Optimization with Transaction Costs Case Problem 2 Cafe Compliance in the Auto Industry Appendix 8.1 Solving Nonlinear Problems with Excel Solver Appendix 8.2 Solving Nonlinear Problems with LINGO Chapter 9: Project Scheduling: PERT/CPM 9.1 Project Scheduling Based on Expected Activity Times 9.2 Project Scheduling Considering Uncertain Activity Times 9.3 Considering Time-Cost Trade-Offs Summary Glossary Problems Case Problem 1 R. C. Coleman Appendix 9.1 Finding Cumulative Probabilities for Normally Distributed Random Variables Chapter 10: Inventory Models 10.1 Economic Order Quantity (EOQ) Model 10.2 Economic Production Lot Size Model 10.3 Inventory Model with Planned Shortages 10.4 Quantity Discounts for the EOQ Model 10.5 Single-Period Inventory Model with Probabilistic Demand 10.6 Order-Quantity, Reorder Point Model with Probabilistic Demand 10.7 Periodic Review Model with Probabilistic Demand Summary Glossary Problems Case Problem 1 Wagner Fabricating Company Case Problem 2 River City Fire Department Appendix 10.1 Development of the Optimal Order Quantity (Q) Formula for the EOQ Model Appendix 10.2 Development of the Optimal Lot Size (Q*) Formula for the Production Lot Size Model Chapter 11: Waiting Line Models 11.1 Structure of a Waiting Line System 11.2 Single-Server Waiting Line Model with Poisson Arrivals and Exponential Service Times 11.3 Multiple-Server Waiting Line Model with Poisson Arrivals and Exponential Service Times 11.4 Some General Relationships for Waiting Line Models 11.5 Economic Analysis of Waiting Lines 11.6 Other Waiting Line Models 11.7 Single-Server Waiting Line Model with Poisson Arrivals and Arbitrary Service Times 11.8 Multiple-Server Model with Poisson Arrivals, Arbitrary Service Times, and No Waiting Line 11.9 Waiting Line Models with Finite Calling Populations Summary Glossary Problems Case Problem 1 Regional Airlines Case Problem 2 Office Equipment, Inc. Chapter 12: Simulation 12.1 What-If Analysis 12.2 Simulation of Sanotronics Problem 12.3 Inventory Simulation 12.4 Waiting Line Simulation 12.5 Simulation Considerations Summary Glossary Problems Case Problem 1 Four Corners Case Problem 2 Harbor Dunes Golf Course Case Problem 3 County Beverage Drive-Thru Appendix 12.1 Probability Distributions for Random Variables Appendix 12.2 Simulation with Analytic Solver Chapter 13: Decision Analysis 13.1 Problem Formulation 13.2 Decision Making without Probabilities 13.3 Decision Making with Probabilities 13.4 Risk Analysis and Sensitivity Analysis 13.5 Decision Analysis with Sample Information 13.6 Computing Branch Probabilities with Bayes' Theorem 13.7 Utility Theory Summary Glossary Problems Case Problem 1 Property Purchase Strategy Case Problem 2 Lawsuit Defense Strategy Case Problem 3 Rob's Market Case Problem 4 College Softball Recruiting Appendix 13.1 Decision Trees with Analytic Solver Chapter 14: Multicriteria Decisions 14.1 Goal Programming: Formulation and Graphical Solution 14.2 Goal Programming: Solving More Complex Problems 14.3 Scoring Models 14.4 Analytic Hierarchy Process 14.5 Establishing Priorities Using AHP 14.6 Using AHP to Develop an Overall Priority Ranking Summary Glossary Problems Case Problem 1 EZ Trailers, Inc. Appendix 14.1 Scoring Models with Excel Chapter 15: Time Series Analysis and Forecasting 15.1 Time Series Patterns 15.2 Forecast Accuracy 15.3 Moving Averages and Exponential Smoothing 15.4 Linear Trend Projection 15.5 Seasonality Summary Glossary Problems Case Problem 1 Forecasting Food and Beverage Sales Case Problem 2 Forecasting Lost Sales Appendix 15.1 Forecasting with Excel Data Analysis Tools Appendix 15.2 Using the Excel Forecast Sheet Appendices Appendix A: Building Spreadsheet Models Appendix B: Areas for the Standard Normal Distribution Appendix C: Values of e-lambda Appendix D: References and Bibliography Appendix E: Self-Test Solutions and Answers to Even-Numbered Exercises (Online) Index