The company uses the additive model and seasonal variations as follows: SV Q1 -18 Q2 2 Q3 30 Q4 -14 Required: Project the sales for the last quarter of Year 7 and the first quarter of Year 8. State your assumptions.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.7: Exponential Smoothing Models
Problem 28P: The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present...
icon
Related questions
Question
CASE 4: PROJECTING SALES USING MOVING AVERAGE
The sales (in thousands) of a particular beverage of a popular milk tea shop for each quarter of the following
months and trend values were found using moving averages as follows:
Actual Sales (in
thousands)
Year
Quarter
Trend
4
3
4
24
1
2
30
30
3
60
31
4
20
35
1
20
40
50
45
3
80
50
4
40
54
7
1
40
57
62
3
92
4
1
LO
CO
Transcribed Image Text:CASE 4: PROJECTING SALES USING MOVING AVERAGE The sales (in thousands) of a particular beverage of a popular milk tea shop for each quarter of the following months and trend values were found using moving averages as follows: Actual Sales (in thousands) Year Quarter Trend 4 3 4 24 1 2 30 30 3 60 31 4 20 35 1 20 40 50 45 3 80 50 4 40 54 7 1 40 57 62 3 92 4 1 LO CO
The company uses the additive model and seasonal variations as follows:
sv
Q1
-18
Q2
2
Q3
30
Q4
-14
Required: Project the sales for the last quarter of Year 7 and the first quarter of Year 8. State your assumptions.
Transcribed Image Text:The company uses the additive model and seasonal variations as follows: sv Q1 -18 Q2 2 Q3 30 Q4 -14 Required: Project the sales for the last quarter of Year 7 and the first quarter of Year 8. State your assumptions.
Expert Solution
steps

Step by step

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