3. Develop forecasts for June through October using these techniques: moving average of three period, simple exponential smoothing, and Holt's method (trend-corrected 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 Holt's method (trend-corrected exponential smoothing). For Holt's model the regression equation has an intercept of 38.0 (FJan=38.0) and a trend component of 4.0 (TJan=4.0). Beta = 0.3 and alpha = 0.2.

2. Evaluate the three forecasts using the accuracy measure MAD for only June-September. Identify the forecasting method which is the most accurate and comment on the use of these three methods to generate a forecast in this situation.

I need help with solving the problem as well and more importantly how to setup the table in excel and what formulas to use.