1. Develop a 5 period simple moving average and 7 period simple moving average forecast.

2. Develop a series of exponential forecasts with alpha of 0.5, 0.8, and 0.95.

3. Develop a linear trend forecast.

4. Compute the MSE for each forecast. (Based on the maximum number of possible forecast periods.)

5. Plot the results on a common graph.

6. BONUS: Compute the MAD (MAE) for the Linear Trend forecast.

Please show the Excel formulas

Tue Oct 20 10:10 PM Q OO Q Home Excel File Edit View Insert Format Tools Data Window Help MO) 69% O AutoSave OFF UES : LAB HW Forecasting Workbook Blank Template(1) Draw Page Layout Formulas Data Review View Acrobat Tell me = = = Conditional Formatting Insert Calibri (Body) ~ APA 11 General Format as Table 3 Delete BI U A $ % ) 58 98 Cell Styles Format v Insert Share Comments 4 V Paste Editing Ideas Sensitivity Create and Share Adobe PDF N23 x fx A B C C F F H 1 K M N D 5- Period SMA Forecast 7-Period SMA Forecast Alpha-0.5 Exponential Forecast Alpha-0.8 Exponential Forecast Alpha-0.95 Exponential Forecast Linear Trend Forecast 1 2 2 Period 3 1 4 2 5 3 6 7 5 8 6 9 7 7 10 8 11 9 12 10 13 11 14 12 15 13 16 14 17 15 18 16 19 20 21 22 23 Sales (S00001 23.00 23.5a 22.50 24.30 24.00 27.80 23,50 23.00 24.50 24.00 23.50 23.90 25.70 25 30 26.00 MSE 24 Simple Moving Liet-k+1 Vi St+1 = k t +1 Exponential + = t + aet Trend t = bo + bit 25 26 27 28 29 30 21 Data and Table Template + F E 100% 20 OCT tv A W