The excel file has a sheet that contains data for the past 30 weeks of sales for product X. Based on the data, answer the following questions

1. Plot the data. Just by looking at the plot (that is, without doing any calculation), do you think a 3-week simple moving average would be a better forecast, or a 6-week simple moving average? Just by looking at the plot, do you think an exponential smoothing with value of =0.2 would be better forecast or would =0.6 be better? Explain your reasoning. (Note: do the two comparisons separately; dont compare moving average with exponential smoothing)

2. Apply the four forecasts (3-week and 6-week simple moving average and exponential smoothing with value of =0.2 and =0.6), and plot the forecasted sales along with the actual sales you plotted in (a). For exponential smoothing, assume the forecast for the first week is 600.

Week	Demand
1	574
2	1,004
3	717
4	1,076
5	1,076
6	932
7	1,291
8	1,219
9	932
10	1,219
11	1,219
12	1,076
13	1,650
14	1,650
15	1,434
16	1,219
17	1,291
18	1,578
19	1,793
20	1,721
21	1,578
22	1,865
23	1,434
24	1,793
25	1,865
26	1,506
27	1,650
28	1,506
29	1,721
30	1,506