3. Develop forecasts for June through October using these techniques: moving average of three period, simple exponential smoothing (10 points)

Historical demand for Peeps is as displayed in the table.

Month	Demand
January	40
February	43
March	50
April	42
May	55
June	58
July	62
August	65
September	70

1. Develop forecasts for June through October using the 3-period moving average technique.

2. Develop forecasts for June through October using the simple exponential smoothing with an alpha of 0.2. For the simple exponential smoothing model assume that the forecast for May is the actual demand for May

Could someone show me how to do this in excel? As in setting up the tables and which formulas to use.