b. Compute all possible forecasts using a five-period moving average. (Round your answers to 1 decimal place.) Absolute Period Demand 5.neriod SMA

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
Respond to each of the items using the following time series data.
Period
Demand
144
2
172
3
157
4
160
144
181
7
160
8
176
9.
149
10
183
11
182
12
149
13
153
14
164
15
153
16
104
Click here for the Excel Data File
b. Compute all possible forecasts using a five-period moving average. (Round your answers to 1 decimal place.)
Absolute
Period
Demand
5-period SMA
Errors
1
144
172
3
157
4.
160
5
144
181
7
160
8
176
9
149
10
183
11
182
12
149
13
153
14
164
LO
Transcribed Image Text:Respond to each of the items using the following time series data. Period Demand 144 2 172 3 157 4 160 144 181 7 160 8 176 9. 149 10 183 11 182 12 149 13 153 14 164 15 153 16 104 Click here for the Excel Data File b. Compute all possible forecasts using a five-period moving average. (Round your answers to 1 decimal place.) Absolute Period Demand 5-period SMA Errors 1 144 172 3 157 4. 160 5 144 181 7 160 8 176 9 149 10 183 11 182 12 149 13 153 14 164 LO
c. Compute the MAD. (Round your answer to 1 decimal place.)
MAD
d. What is the forecast demand for period 17? (Round your answer to 1 decimal place.)
Forecast demand for period 17
units
e. What is the error associated with the period 17 forecast? (Round your answer to 1 decimal place.)
Error associated with the period 17 forecast
Transcribed Image Text:c. Compute the MAD. (Round your answer to 1 decimal place.) MAD d. What is the forecast demand for period 17? (Round your answer to 1 decimal place.) Forecast demand for period 17 units e. What is the error associated with the period 17 forecast? (Round your answer to 1 decimal place.) Error associated with the period 17 forecast
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
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.