Question 45 What is the "seasonal factor" for Q1? O 0.31 0.18 O 0.25 0.27

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.6: Moving Averages Models
Problem 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...
icon
Related questions
Question
Question 45
What is the "seasonal factor" for Q1?
0.31
0.18
O 0.25
O 0.27
Transcribed Image Text:Question 45 What is the "seasonal factor" for Q1? 0.31 0.18 O 0.25 O 0.27
Given the following demand data
Quarter Demand
105
150
93
121
140
170
105
150
150
170
110
130
Year
130.2
1
2
136.67
145.1
200
3
1
2
3
4
1
2
3₂
st
What is the weighted 3-quarter moving average forecast for Year 4, Q1 with weights of 0.5 on the most recent
observed demand, 0.33 on 2nd most recent observed demand, and 0.17 on 3rd most recent observed demand?
4
1
2
3
4
Transcribed Image Text:Given the following demand data Quarter Demand 105 150 93 121 140 170 105 150 150 170 110 130 Year 130.2 1 2 136.67 145.1 200 3 1 2 3 4 1 2 3₂ st What is the weighted 3-quarter moving average forecast for Year 4, Q1 with weights of 0.5 on the most recent observed demand, 0.33 on 2nd most recent observed demand, and 0.17 on 3rd most recent observed demand? 4 1 2 3 4
Expert Solution
steps

Step by step

Solved in 2 steps with 4 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,
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing