1.A retail store records customer demand during each sales period. Use the following demand data to develop

a.3 period moving average forecast for period 13

b.4 period moving average forecasts for period 13

c.Weighted moving average for the period 4 through 12 with weights ( 0.5, 0.3, 0.2) respectively and forecast for the period 13

d.Single exponential smoothing forecast for the period 2 through 13 with = 0.45. (Assume F1= 86)

e.Forecast for the next 3 periods using linear regression.

f.Also compute the MAD, MAPE, MSE and tracking signal for all the method and interpret the result.15 marks

Period

1

2

3

4

5

6

7

8

9

10

11

12

Demand

86

93

88

89

92

94

91

93

96

97

93

95