Please fill solve all SMA WMA etc

extBox 2 4 X V fx H K A B C D E F G student Name: By submitting this assignm any unauthorized help, and Student Number: The college's definition of In order to get graded for this work, you must use formulas aiding another to obtain, c for all of your calculations. Insert your answers in the performance, by dishonest shaded areas indicated. You agree to abide by Sene understand any violations Q1 A product has a consistent year round demand. You are the planner and have been tasked with experimenting with some time series analysis. Using this previous weekly demand, calculate the following forecasts for each period possible. A) Two - Period Simple moving average B) 3 Period Weighted moving average using weights of .5, .3,.2, C) Four-period weighted moving average with weights of .4,.3,.2,.1 and D) Exponential Smoothing forecast using an Alpha of .15 and a Week 1 forecast of 2100 units. Round all forecasts to whole numbers. 15 6 Week Demand SMA WMA WMA EXP Sm .15 17 1 2160 2 Period .5, .3, .2 4,.3,.2,.1 2100 18 2240 W N 19 2365 20 2210 21 2180 22 2155 23 2260 24 40 00 2240 25 2205 26 10 2380 27 11 2340 28 12 2310 29 30 Q2 For each of the forecasts and demand below, calculate the Mean Absolute Deviation, 31 Mean Squared Error and Mean Absolute Percent Error. 32 Use the ABS formula for Absolute Value. NOTE: Use formulas for each calculation. 33 Round each answer to one decimal place. 34