answer and formulas needed

3 4 5 6 7 8 By uploading this assignment, I affirm that I have not given or received any unauthorized help and that all work submitted is my own. I have abided by Seneca's Academic Integrity Policy and I understand that any violation of academic integrity will be subject to the penalties outlined in the policy. Formulas must be used for each calculation in this assignment in order to obtain a grade. 9 10 11 12 13 14 15 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 Period Weighted 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. 16 WMA SMA 3 Period WMA .4,.3, 2,1 EXP Sm.25 1000 17 .6.4 Month Jan Feb Mar Apr May 18 19 20 21 22 23 24 25 26 27 28 Jun Jul Demand 1105 1068 1080 998 960 1125 960 1023 956 945 1035 1200 Aug Sep Oct Nov Dec