solution

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) 4 Period Simple moving average B) Two Period Weighted moving average using weights of .7,.3, C) three-period weighted moving average with weights of.5, .3,.2 and D) Exponential Smoothing forecast using an Alpha of .40 and a Week 1 forecast of 800 units. Round all forecasts to whole numbers. 13 14 15 16 SMA WMA WMA Demand 725 EXP Sm .40 800 4 Period .7,.3 .5,3,.2 680 720 800 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 17 18 19 20 21 22 23 24 25 26 27 28 902 876 825 950 956 1021 995 1050