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

Marketing
20th Edition
ISBN:9780357033791
Author:Pride, William M
Publisher:Pride, William M
Chapter6: Target Markets: Segmentation And Evaluation
Section: Chapter Questions
Problem 17DRQ: Under what conditions might a firm use multiple forecasting methods?
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
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning