Problem -1 For the moving average problem below, determine (in the Excel file): A) Calculate the seasonal factors (10) B) (50 points) Using the seasonal factors above find out the 1. The Moving Average Forecasting values 2. MAD and MSE (hint to save time, you can copy and paste the entire table into Excel) TRUE Year Quarter Value Moving Average Value n= 3 1 1 1 1 1 2 3 4 2 1 2 2 3,805 3,622 4,500 4,100 4,310 6,100 5,290 3,610 4,600 5,850 5,320 5,950 Mean Absolute Deviation MAD = WWW WINNINN 3 4 1 2 2 3 3 3 3 Mean Square Error MSE = 2 3 4