Calibri (Bo.. 11 Dictate B Aa ApS EEEE E ADA a21 Forecasting --Homework Styles Styles Pane Name: Due: In class November 6 1. Moving average. Input the predicted sales for the appropriate years using a 3-month and 4- month moving average. Calculate the forecast error and MAD for the moving averages. Year Sales 3-month Forecast error 4-month moving Forecast error moving average 3-month average 4-month 450 495 518 563 1 2 3 4 5 584 ? MAD 3-month MAD 4-month 2. Weighted average. Using the table to predict the yearly sales values. Weighted average (1) year 1, (3) year 2. (4) year 3. Calculate the forecast error and the MAD. Year Sales Forecast error Weighted average 1 2 3 4 5 6 450 495 518 563 584 ? 184 words English (United States) e Focus atv A ab x x ADA v 1 Styles Styles Pane 2. Weighted average. Using the table to predict the yearly sales values. Weighted average (1) year 1,(3) year 2, (4) year 3. Calculate the forecast error and the MAD. Year Sales Weighted Forecast error average 1 450 2 495 3 518 4 563 5 584 6 ? MAD I 3. Exponential Smoothing: Using the table below to predict the yearly sales. Use an a of 0.2 and 0.8. Calculate the forecast error and the MAD for both a. Year Sales Exponential Smoothing a=0.2 Forecast error q=0.2 Exponential Smoothing a=0.8 Forecast error q=0.8 O'Brien ISOM 201 Forecasting Fall 2020 450 450 1 2 3 4 5 6 450 495 518 563 584 7 MAD ords English (United States) Focus