In this assignment you will apply two smoothing methods, Moving Average $($MA$)$ and Exponential Smoothing $($ES$),$ to forecast for the next period, Month $25.$ The actual time series data $\{$At$\}$ in column B are level and represent two years of monthly sales $($in $$1,000$s$)$ from a line of dresses made by a small clothing manufacturer. Click on the "Data" sheet $($tab below$)$ to see the data.

Calculation of the first forecast and first error for each forecasting method have already been done. Copy and paste the formulas down each column as needed, keeping $3$ decimal places in all calculations. Calculate the Mean Absolute Deviation $($MAD$)$ for each forecasting method $($in H$31$:K$31)$ using Excel$$s AVERAGE function. An example of how to do everything is contained in the file $$FC$-$Ex$1-$Level.xlsx$"$ on iLearn. Don$$t be afraid to experiment!