ASSIGNMENT INFORMATION Points Possible Due Date Sunday, April 10, 2022 11:59 PM 10 There are six forecasting methods presented in the chapter slides. Use the same data set below to forecast from April through December for all six methods. Also calculate error terms for each forecast. Please use an excel spreadsheet to do all of your work, and please plot the actual data below using the graph function. Please watch the videos if you need to see how to make the forecasts. Important Note: Assume you know actual values of January, February, March, and April but that you don't know actual values (even though they are given) for April through December. You only forecast the next month after the previous month is revealed. Month X-Values of number of the month Y-values or Actual Demand Forecasted Demand Starting for the Month in April Jan 1 16 X Feb 2 22 X Mar 3 20 X Apr 4 16 X May 5 25 6 35 7 33 Jun Jul Aug Sept 8 32 9 39 Oct 10 47 Nov 43 11 12 Dec 44 E14 @fx =AVERAGE(ES:E13) E D F B Absolute Error 1 MONTH X VALUE OF NUMBER OF MONTH Y-VALUES OF ACTUAL DEMAND FOR THE FORECAST DEMAND STARTING IN MONTH MONTH APRIL 1 16 2 22 20 4 16 25 35 2 Jan 3 Feb 4 Mar 5 Apr 6 May 7 Jun 8 Jul 9 Aug 10 Sep 11 Oct 12 Nov 13 Dec RECOMAN 33 32 =AVERAGE(C2:04) =AVERAGE(C3:C5) =AVERAGE(C4:06) =AVERAGE(C5:07) AVERAGE(C6:08 =AVERAGE(C7:C9) =AVERAGE(C8:C10) =AVERAGE(C9:C11) =AVERAGE(C10:012) =ABS(C5-D5) =ABS(C6-06) =ABS(C7-07) =ABS(C8-D8) =ABS(C9-09) =ABS(C10-D10) =ABS(C11-011) =ABS(C12-D12) =ABS(C13-D13) =AVERAGE(ES:E13) 39 10 11 147 143 44 12 MAD 14 15 A B D E F X VALUE OF 1 MONTH NUMBER OF MONTH Y-VALUES OF ACTUAL DEMAND FOR THE MONTH FORECAST DEMAND Absolute STARTING IN MONTH Error APRIL 2 Jan 1 16 3 Feb 2 22 3 20 4 16 19.33 4 Mar 5 Apr 6 May 7 Jun 3.33 5.67 5 25 19.33 6 35 20.33 8 Jul 7 33 25.33 31.00 14.67 7.67 1.00 5.67 8 9 Aug 10 Sep 11 Oct 32 39 9 33.33 34.67 10 47 12.33 3.67 11 HTTA 43 12 Nov 13 Dec 39.33 12 44 43.00 1.00 6.11 14 MAD 15 ASSIGNMENT INFORMATION Due Date Points Possible 10 Sunday, April 17, 2022 11:59 PM For last week's spreadsheet assignment and using the error terms for each forecasting method, calculate the MAD, the MAPE, and the MSE for each method. Declare which forecast is the best. This homework, like last week will be due Sunday at midnight, and it might be helpful to watch the videos once they are posted. Dr. S