Please solve it
AutoSav Review View Draw Page Layout Formulas Data Home Insert ab General V 12 " A" A E x Delete v Calibri (Body) Conditional Format Cell $ ~ % 9 68 98 Formatting as Table Styles Format v Paste BIU V LAV TextBox 2 x v fx K M N C D E F G H 1 J 2 student Name: By submitting this assignment you acknowledge you will not give or receive any unauthorized help, and that all work will be your own. 3 student Number: The college's definition of cheating is: obtaining or attempting to obtain, or aiding another to obtain, credit for work or improvement in evaluation of 4 In order to get graded for this work, you must use formulas performance, by dishonest or deceptive means. 5 for all of your calculations. Insert your answers in the You agree to abide by Seneca's Academic Integrity Policy and you shaded areas indicated. understand any violations of academic integrity will be subject to the 6 C 8 9 Q1 A product has a consistent year round demand. You are the planner and have been tasked with 10 experimenting with some time series analysis. Using this previous weekly demand, calculate the following 11 forecasts for each period possible. A) Two - Period Simple moving average B) 3 Period Weighted moving 12 average using weights of .5, .3,.2, C) Four-period weighted moving average with weights of .4,.3,.2,.1 and 13 D) Exponential Smoothing forecast using an Alpha of .15 and a Week 1 forecast of 2100 units. Round all 14 forecasts to whole numbers. | 15 16 Week Demand SMA WMA WMA EXP Sm .15 17 2160 2 Period .5, .3, .2 4,.3,.2,.1 2100 18 2 2240 19 2365 20 2210 21 5 2180 22 6 2155 23 2260 24 8 2240 25 9 2205 26 10 2380 27 11 2340 28 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 33 Use the ABS formula for Absolute Value. NOTE: Use formulas for each calculation. Round each answer to one decimal place. 34 35 MAD MSE MAPE 4 Assignment 1 + Ready JUN 11 city