# Spreadsheet Modeling and Decision Analysis 9th edition

Cliff T. Ragsdale
Publisher: Cengage Learning

## Course Packs

Save time with ready-to-use assignments built by subject matter experts specifically for this textbook. You can customize and schedule any of the assignments you want to use.

## Textbook Resources

Additional instructional and learning resources are available with the textbook, and might include testbanks, slide presentations, online simulations, videos, and documents.

• Ragsdale Spreadsheet Modeling and Decision Analysis 9e - Homework and Quizzes from 8e MindTap

Access is contingent on use of this textbook in the instructor's classroom.

• Chapter 1: Introduction to Modeling and Decision Analysis
• 1.0: Introduction
• 1.1: The Modeling Approach to Decision Making
• 1.2: Characteristics and Benefits of Modeling
• 1.3: Mathematical Models
• 1.4: Categories of Mathematical Models
• 1.5: Business Analytics and the Problem-Solving Process
• 1.6: Anchoring and Framing Effects
• 1.7: Good Decisions vs. Good Outcomes
• 1.8: Summary
• 1.9: References
• 1: Questions and Problems (13)
• 1: Test Bank

• Chapter 2: Introduction to Optimization and Linear Programming
• 2.0: Introduction
• 2.1: Applications of Mathematical Optimization
• 2.2: Characteristics of Optimization Problems
• 2.3: Expressing Optimization Problems Mathematically
• 2.4: Mathematical Programming Techniques
• 2.5: An Example LP Problem
• 2.6: Formulating LP Models
• 2.7: Summary of the LP Model for the Example Problem
• 2.8: The General Form of an LP Model
• 2.9: Solving LP Problems: An Intuitive Approach
• 2.10: Solving LP Problems: A Graphical Approach
• 2.11: Special Conditions in LP Models
• 2.12: Summary
• 2.13: References
• 2: Questions and Problems (13)
• 2: Test Bank

• Chapter 3: Modeling and Solving LP Problems in a Spreadsheet
• 3.0: Introduction
• 3.2: Solving LP Problems in a Spreadsheet
• 3.3: The Steps in Implementing an LP Model in a Spreadsheet
• 3.4: A Spreadsheet Model for the Blue Ridge Hot Tubs Problem
• 3.5: How Solver Views the Model
• 3.6: Using Analytic Solver
• 3.7: Using Excel's Built-in Solver
• 3.8: Goals and Guidelines for Spreadsheet Design
• 3.9: Make vs. Buy Decisions
• 3.10: An Investment Problem
• 3.11: A Transportation Problem
• 3.12: A Blending Problem
• 3.13: A Production and Inventory Planning Problem
• 3.14: A Multiperiod Cash Flow Problem
• 3.15: Data Envelopment Analysis
• 3.16: Summary
• 3.17: References
• 3: Questions and Problems (25)
• 3: Test Bank

• Chapter 4: Sensitivity Analysis and the Simplex Method
• 4.0: Introduction
• 4.1: The Purpose of Sensitivity Analysis
• 4.2: Approaches to Sensitivity Analysis
• 4.3: An Example Problem
• 4.5: The Sensitivity Report
• 4.6: Ad Hoc Sensitivity analysis
• 4.7: Robust Optimization
• 4.8: The Simplex Method
• 4.9: Summary
• 4.10: References
• 4: Questions and Problems (16)
• 4: Test Bank

• Chapter 5: Network Modeling
• 5.0: Introduction
• 5.1: The Transshipment Problem
• 5.2: The Shortest Path Problem
• 5.3: The Equipment Replacement Problem
• 5.4: Transportation/Assignment Problems
• 5.5: Generalized Network Flow Problems
• 5.6: Maximal Flow Problems
• 5.7: Special Modeling Considerations
• 5.8: Minimal Spanning Tree Problems
• 5.9: Summary
• 5.10: References
• 5: Questions and Problems (17)
• 5: Test Bank

• Chapter 6: Integer Linear Programming
• 6.0: Introduction
• 6.1: Integrality Conditions
• 6.2: Relaxation
• 6.3: Solving the Relaxed Problem
• 6.4: Bounds
• 6.5 Rounding
• 6.6: Stopping Rules
• 6.7: Solving ILP Problems Using Solver
• 6.8: Other ILP Problems
• 6.9: An Employee Scheduling Problem
• 6.10: Binary Variables
• 6.11: A Capital Budgeting Problem
• 6.12: Binary Variables and Logical Conditions
• 6.13: The Line Balancing Problem
• 6.14: The Fixed-Charge Problem
• 6.15: Minimum Order/Purchase Size
• 6.16: Quantity Discounts
• 6.17: A Contract Award Problem
• 6.18: The Branch-and-Bound Algorithm (Optional)
• 6.19: Summary
• 6.20: References
• 6: Questions and Problems (22)
• 6: Test Bank

• Chapter 7: Goal Programming and Multiple Objective Optimization
• 7.0: Introduction
• 7.1: Goal Programming
• 7.2: A Goal Programming Example
• 7.4: Multiple Objective Optimization
• 7.5: An MOLP Example
• 7.7: Summary
• 7.8: References
• 7: Questions and Problems (15)
• 7: Test Bank

• Chapter 8: Nonlinear Programming and Evolutionary Optimization
• 8.0: Introduction
• 8.1: The Nature of NLP Problems
• 8.2: Solution Strategies for NLP Problems
• 8.3: Local vs. Global Optimal Solutions
• 8.4: Economic Order Quantity Models
• 8.5: Location Problems
• 8.6: Nonlinear Network Flow Problem
• 8.7: Project Selection Problems
• 8.8: Optimizing Existing Financial Spreadsheet Models
• 8.9: The Portfolio Selection Problems
• 8.10: Sensitivity Analysis
• 8.11: Solver Options for Solving NLP's
• 8.12: Evolutionary Algorithms
• 8.13: Forming Fair Teams
• 8.14: The Traveling Salesperson Problem
• 8.15: Summary
• 8.16: References
• 8: Questions and Problems (21)
• 8: Test Bank

• Chapter 9: Regression Analysis
• 9.0: Introduction
• 9.1: An Example
• 9.2: Regression Models
• 9.3: Simple Linear Regression Analysis
• 9.4: Defining ""Best Fit""
• 9.5: Solving the Problem Using Solver
• 9.6: Solving the Problem Using the Regression Tool
• 9.7: Evaluating the Fit
• 9.8: The R2 Statistic
• 9.9: Making Predictions
• 9.10: Statistical Tests for Population Parameters
• 9.11: Introduction to Multiple Regression
• 9.12: A Multiple Regression Example
• 9.13: Selecting the Model
• 9.14: Making Predictions
• 9.15: Other Model Selection Issues
• 9.16: Binary Independent Variables
• 9.17: Statistical Tests for the Population Parameters
• 9.18: Polynomial Regression
• 9.19: Summary
• 9.20: References
• 9: Questions and Problems (13)
• 9: Test Bank

• Chapter 10: Data Mining
• 10.0: Introduction
• 10.1: Data Mining Overview
• 10.2: Classification
• 10.3: Classification Data Partitioning
• 10.4: Discriminant Analysis
• 10.5: Logistic Regression
• 10.6: k-Nearest Neighbor
• 10.7: Classification Trees
• 10.8: Neural Networks
• 10.9: Naïve Bayes
• 10.11: Prediction
• 10.12: Association Rules (Affinity Analysis)
• 10.13: Cluster Analysis
• 10.14: Time Series
• 10.15: Summary
• 10.16: References
• 10: Questions and Problems (5)
• 10: Test Bank

• Chapter 11: Time Series Forecasting
• 11.0: Introduction
• 11.1: Time Series Methods
• 11.2: Measuring Accuracy
• 11.3: Stationary Models
• 11.4: Moving Averages
• 11.5: Weighted Moving Averages
• 11.6: Exponential Smoothing
• 11.7: Seasonality
• 11.8: Stationary Data with Additive Seasonal Effects
• 11.9: Stationary Data with Multiplicative Seasonal Effects
• 11.10: Trend Models
• 11.11: Double Moving Average
• 11.12: Double Exponential Smoothing (Holt's Method)
• 11.13: Holt-Winter's Method for Additive Seasonal Effects
• 11.14: Holt-Winter's Method for Multiplicative Seasonal Effects
• 11.15: Modeling Time Series Trends Using Regression
• 11.16: Linear Trend Model
• 11.18: Modeling Seasonality with Regression Models
• 11.19: Adjusting Trend Predictions with Seasonal Indices
• 11.20: Seasonal Regression Models
• 11.21: Combining Forecasts
• 11.22: Summary
• 11.23: References
• 11: Questions and Problems (32)
• 11: Test Bank

• Chapter 12: Introduction to Simulation Using Analytic Solver
• 12.0: Introduction
• 12.1: Introduction
• 12.2: Why Analyze Risk?
• 12.3: Methods of Risk Analysis
• 12.4: A Corporate health Insurance Example
• 12.5: Spreadsheet Simulation Using Analytic Solver
• 12.6: Random Number Generators
• 12.7: Preparing the Model for Simulation
• 12.8: Running the Simulation
• 12.9: Data Analysis
• 12.10: The Uncertainty of Sampling
• 12.11: Interactive Simulation
• 12.12: the Benefits of Simulation
• 12.13: Additional Uses of Simulation
• 12.14: A Reservation Management Example
• 12.15: An Inventory Control Example
• 12.16: A Project Selection Example
• 12.17: A Portfolio Optimization Example
• 12.18: Summary
• 12.19: References
• 12: Questions and Problems (19)
• 12: Test Bank

• Chapter 13: Queuing Theory
• 13.0: Introduction
• 13.1: The Purpose of Queuing Models
• 13.2: Queuing System Configurations
• 13.3: Characteristics of Queuing Systems
• 13.4: Kendall Notation
• 13.5: Queuing Models
• 13.6: The M/M/s Model
• 13.7: The M/M/s Model with Finite Queue Length
• 13.8: The M/M/s Model with Finite Population
• 13.9: The M/G/1 Model
• 13.10: The M/D/1 Model
• 13.11: Simulating Queues and the Steady-State Assumption
• 13.12: Summary
• 13.13: References
• 13: Questions and Problems (13)
• 13: Test Bank

• Chapter 14: Decision Analysis
• 14.0: Introduction
• 14.1: Good Decisions vs. Good Outcomes
• 14.2: Characteristics of Decision Problems
• 14.3: An Example
• 14.4: The Payoff Matrix
• 14.5: Decision Rules
• 14.6: Nonprobabilistic Methods
• 14.7: Probabilistic Methods
• 14.8: The Expected Value of Perfect Information
• 14.9: Decision Trees
• 14.10: Creating Decision Trees with Analytic Solver
• 14.11: Multistage Decision Problems
• 14.12: Sensitivity Analysis
• 14.13: Using Sample Information in Decision Making
• 14.14: Computing Conditional Probabilities
• 14.15: Utility Theory
• 14.16: Multicriteria Decision Making
• 14.17: The Multicriteria Scoring Model
• 14.18: The Analytic Hierarchy Process
• 14.19: Summary
• 14.20: References
• 14: Questions and Problems (16)
• 14: Test Bank

• Chapter 15: Project Management
• 15.0: Introduction
• 15.1: An Example
• 15.2: Creating the Project Network
• 15.3: CPM: An Overview
• 15.4: The Forward Pass
• 15.5: The Backward Pass
• 15.6: Determining the Critical Path
• 15.7: Project Management Using Spreadsheets
• 15.8: Gantt Charts
• 15.9: Project Crashing
• 15.10: Pert: An Overview
• 15.11: Simulating Project Networks
• 15.12: Microsoft Project
• 15.13: Summary
• 15.14: References
• 15: Questions and Problems (13)
• 15: Test Bank

• Chapter A: Appendix
• A: Appendix A: Basics of Excel (11)

### Instructor Product Features

• A Course Pack with ready-to-use assignments was built by subject matter experts specifically for this textbook. It is designed to save you time and can be easily customized to meet your teaching goals.
• Instructor Resources include Lecture PowerPoint slides and a full Instructor Solutions Manual.
• Test Bank questions (TB) - Coming Summer 2022! can either be used for additional practice or as a way to conduct formative or summative assessments of student performance.

### Student Learning Tools

• Read It links under each question quickly jump to the corresponding section of a complete, interactive eBook that lets students highlight and take notes as they read.
• Watch It - Coming January 2022! links provide step-by-step instruction with short, engaging videos that are ideal for visual learners.
• Excel Tutorial questions are available to help students practice Excel skills.

## Questions Available within WebAssign

Most questions from this textbook are available in WebAssign. The online questions are identical to the textbook questions except for minor wording changes necessary for Web use. Whenever possible, variables, numbers, or words have been randomized so that each student receives a unique version of the question. This list is updated nightly.

##### Question Availability Color Key
BLACK questions are available now
GRAY questions are under development

Group Quantity Questions
Chapter A: Appendix
A.ET 11 001 002 003 004 005 006 007 008 009 010 011
Chapter 1: Introduction to Modeling and Decision Analysis
1.E 13 003 006 009 010 011 012 014 015 017 019 020 021 023
1.TB 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081
Chapter 2: Introduction to Optimization and Linear Programming
2.E 13 001 004 006 007 009 011 013 018 019 020 022 024 026
2.TB 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082 083
Chapter 3: Modeling and Solving LP Problems in a Spreadsheet
3.E 25 004 005 006 008 010 013 014 016 018 020 022 024 025 026 028 029 031 034 037 038 039 041 044 046 048
3.TB 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082 083 084 085 086 087 088 089 090 091 092 093
Chapter 4: Sensitivity Analysis and the Simplex Method
4.E 16 002 003 006 010 012 013 015 016 017 020 021 023 024 026 029 031
4.TB 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082 083 084 085 086 087 088 089 090
Chapter 5: Network Modeling
5.E 17 003 005 006 007 009 010 016 017 018 019 020 023 024 027 029 032 033
5.TB 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082 083 084 085 086 087 088 089 090 091 092
Chapter 6: Integer Linear Programming
6.E 22 003 004 006 009 011 013 015 016 018 020 021 022 024 025 028 030 031 033 034 036 038 039
6.TB 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082 083 084 085 086 087 088 089 090 091 092 093 094 095 096 097 098 099 100 101
Chapter 7: Goal Programming and Multiple Objective Optimization
7.E 15 006 008 010 013 014 017 018 020 022 023 025 026 027 029 031
7.TB 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080
Chapter 8: Nonlinear Programming and Evolutionary Optimization
8.E 21 003 005 007 009 012 014 016 017 019 020 023 024 025 027 028 029 033 035 036 038 040
8.TB 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082 083 084 085 086 087
Chapter 9: Regression Analysis
9.E 13 001 007 008 009 012 013 014 016 017 020 021 023 024
9.TB 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082 083 084 085 086 087 088 089 090 091 092
Chapter 10: Data Mining
10.E 5 007 008 009 010 011
10.TB 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082 083 084 085 086 087 088 089 090 091 092 093 094 095 096 097 098 099 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126
Chapter 11: Time Series Forecasting
11.E 32 003 007 008 009 010 012 013 018 020 026 027 028 029 032 033 034 035 036 038 039 041 042 046 047 048 049 052 054 057 058 059 060
11.TB 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082 083 084 085 086 087 088 089 090 091 092 093 094 095 096 097 098 099 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121
Chapter 12: Introduction to Simulation Using Analytic Solver
12.E 19 002 004 007 008 010 013 014 017 018 020 022 024 026 028 030 032 034 035 037
12.TB 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082 083 084
Chapter 13: Queuing Theory
13.E 13 006 007 008 009 012 014 017 019 020 023 024 026 028
13.TB 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082 083 084 085 086 087 088 089 090 091 092 093 094 095 096
Chapter 14: Decision Analysis
14.E 16 005 006 008 010 012 013 015 017 018 019 021 023 024 025 029 031
14.TB 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082 083 084 085 086 087 088 089 090 091 092 093 094 095 096 097 098 099 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122
Chapter 15: Project Management
15.E 13 005 007 009 012 014 015 016 017 018 020 021 024 026
15.TB 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082
Total 264 (1430)