The details of the clock sales at a supermarket for the past 6 weeks are shown i
ID: 3241464 • Letter: T
Question
The details of the clock sales at a supermarket for the past 6 weeks are shown in the table below. The time series appears to be relatively stable, without trend, seasonal, or cyclical effects. The simple moving average value of k is set at 2.
Week
Units sold
1
88
2
44
3
54
4
65
5
72
6
85
For the given data, the simple moving average mean absolute deviation is ________.
A) 0.21
B) 20.12
C) 14.25
D) 207.13
If the smoothing constant is assumed to be 0.7, and setting F1 and F2 = A1, the exponential smoothing sales forecast for week 7 is approximately
A) 50 clocks
B) 80 clocks
C) 60 clocks
D) 70 clocks
Week
Units sold
1
88
2
44
3
54
4
65
5
72
6
85
Explanation / Answer
1)
1 88
2 44
3 54 66 12
4 65 49 16
5 72 59.5 12.5
6 85 68.5 16.5
78.5
14.25
MAD = (summation absolution deviation)/n =(12+16+12.5+16.5) /4 = 14.25
b)
1 88 88
2 44 88
3 54 57.2
4 65 54.96
5 72 61.988
6 85 68.9964
80.19892
B) 80 clock is correct
St=yt1+(1)St1