A) Calcualte moving average for 3, 6, and 9 month time periods for January B) Calculate weighted avg. for January using weights of .7,.2,.1also a new problem use weigths .6,.2. & .2 C) Calculate exponential smoothing for January using alpha @.18 and an Ft-1 of 80 D) Using Excel use regression analysis - straight line analysis to calculate demand for January Please review the demand data will the slope of the line be positive or negative? Will the slop be a large or small number?

.............. IM Time Series Analysis Ft = At-1 + At-2 .... + At-n Ft = W1 At-1+W2 At-2.... + Wn At-n Ft = Ft-1+(At-1 - Ft-1) n 1 2 3 4 5 6 7 8 9 10 11 12 Ft ? ...!!!!!!!!!!!! Month January February March April May June July August September October November December January At-12 At-11 At-10 At-9 At-8 At-7 At-6 At-5 At-4 At-3 At-2 At-1 X Y - Demand 1 109 2 110 3 95 4 93 5 92 6 6 87 7 88 8 84 9 80 10 81 11 78 12 75 X^2 1 4 9 16 25 36 49 64 XY 109 220 285 372 460 522 616 672 720 810 858 900 Y^2 11881 12100 9025 8649 8464 7569 7744 7056 6400 6561 6084 5625 HIIHII Linear Regression if you have something that look like a linear trend. Y = bi X + bo 81 HI!!! ...::::::... 100 121 144 ........................................................................... ................................................. A) Calcualte moving average for 3, 6, and 9 month time periods for January B) Calculate weighted avg. for January using weights of .7,.2,. 1also a new problem use weigths .6, 2. & .2 C) Calculate exponential smoothing for January using alpha @.18 and an Ft-1 of 80 D) Using Excel use regression analysis - straight line analysis to calculate demand for January Please review the demand data will the slope of the line be positive or negative? Will the slop be a large or small number? ........................................................................................................................................ ............................................................................ y = -2.965x + 108.6061 2 R = 0.9027 120 100 80 Axis Title 60 40 20 0 0 0 2 4 4 6 8 10 12 14 Axis Title