a. Compute MAD for the fifth period, then update it period by period using exponential smoothing with a = .10. (Round your intermediate calculations and final answers to 3 decimal places.)

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Solve it both a 

Problem 3-28
The manager of a travel agency has been using a seasonally adjusted forecast to predict demand for packaged tours. The actual and
predicted values are as follows:
Period Demand Predicted
123
183
113
200
1
143
78
73
150
102
80
135
4
5
6.
118
113
142
7
128
124
9.
107
162
117
109
150
94
80
10
11
102
137
12
13
140
128
14
147
Transcribed Image Text:Problem 3-28 The manager of a travel agency has been using a seasonally adjusted forecast to predict demand for packaged tours. The actual and predicted values are as follows: Period Demand Predicted 123 183 113 200 1 143 78 73 150 102 80 135 4 5 6. 118 113 142 7 128 124 9. 107 162 117 109 150 94 80 10 11 102 137 12 13 140 128 14 147
a. Compute MAD for the fifth period, then update it period by period using exponential smoothing with a = .10. (Round your
intermediate calculations and final answers to 3 decimal places.)
t
A
Period
Demand
123
183
143
78
MADT
1
3
4
73
6.
118
7
113
8.
142
9.
107
10
162
11
117
12
102
13
137
14
147
Transcribed Image Text:a. Compute MAD for the fifth period, then update it period by period using exponential smoothing with a = .10. (Round your intermediate calculations and final answers to 3 decimal places.) t A Period Demand 123 183 143 78 MADT 1 3 4 73 6. 118 7 113 8. 142 9. 107 10 162 11 117 12 102 13 137 14 147
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Forecasting methods
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.