1 Use the Historical demand data below to calculate TWO forecasts. 1) 3 Period Weighted moving average using weights of .5,.3,.2, with the heavier weights being used for the most recent periods, and 2) Exponential Smoothing forecast using an Alpha of .3 and a Week 3 forecast of 600 units. For each of the 3 forecasts calculate the Mean Absolute Deviation, Mean Squared Error and Mean Absolute Percent Error. Use the ABS formula for Absolute Value. In a few sentences, explain what insights can we learn from tracking the MAD/MSE/MAPE over a prolonged period of time? Insert answer here: In a few sentences, explain how having an understanding of one of the demand patterns we reviewed in class can assist Insert answer here: In a brief sentence, explain 1 advantage of using the weighted moving average over the simple moving average. Insert answer here: The candy company you work for recently hired a new demand planning manager and they have asked you to forecast the demand for October by using a 3-month moving average with July, August, and September's acutal demand. Is this a The Actual demand for Snow boards from a large GTA retail chain is shown below for 2022. Calculate the Seasonal Index (factor) for last year for each of the four seasons. Use the seasonal Index (factor) to calculate the demand for each of the seasons for 2023 ( Table \#2) based on a new ANNUAL demand of 10,000 snowboards