las must be used for den Q1 A product has a consistent year round demand. You are responsible for the forecast and have been tasked with experimenting with some time series analysis. Using this previous monthly demand, calculate the following forecasts for each period possible. A) 3 Period Simple moving average B) 4 Perlod Welghted moving average using weights of .4.3,2,1,C) two-period weighted moving average with weights of.6.4 and D) Exponential Smoothing forecast using an Alpha of 25. and a Week 1 forecast of 1000 units. Round all forecasts to whole numbers. Month Demand SMA WMA WMA EXP Sm.25 Jan 1105 3 Period .4, 3, 2,.1 .6, 4 1000 Feb 1068 Mar 1080 Apr 998 May 960 2 Jun 1125 23 Jul 960 24 Aug 1023 25 Sep 956 26 Oct 945 27 Nov 1035 28 Dec 1200 29 30 Q2 For each of the forecasts and demand below, calculate the Mean Absolute Deviation, 32 Mean Squared Error and Mean Absolute Percent Error. 32 Use the ABS formula for Absolute Value. NOTE: Use formulas for each calculation, 33 30 35 Week Absolute Demand Forecast MAD Error (e) 1 Error 556 500 3 2 598 550 39 3 625 650 36 MSE A2 MAPE Abs e/A Sho2 Ready esc B I U . ! # $ % 1 2 & 3 4 5 6 7 Q 2b W E R Y A wol J