A) Calcualte moving average for 3, 6, and 9 month time periods for January B) Calculate weighted moving for January using weights of .7, .2, .1 C) Calculate exponential smoothing for January using alpha @.23 and an Ft-1 of 48

n = Month Y- Demand XY 1 January At-12 1 15 15 2 February At-11 2 22 44 3 March At-10 3 27 81 4 April At-9 4 23 92 5 May At-8 5 32 160 6 June At-7 6 35 210 7 July At-6 7 40 280 8 August At-5 8 39 312 9 September At-4 9 43 387 10 October At-3 10 47 470 11 November At-2 11 52 572 12 December At-1 12 55 660 Ft ? January Totals 78 430 3283 Averages 6.5 35.83 (A) Calcualte moving average for 3, 6, and 9 month time periods for January B) Calculate weighted moving for January using weights of .7, -2, .1 C) Calculate exponential smoothing for January using alpha @.23 and an Ft-1 of 48 You must show all calculations to get credit. X^2 1 4 9 16 25 36 49 64 81 100 121 144 650 Y^2 Text Here - Time Series Analysis 225 Ft = At-1 + At-2 .... + At-n 484 729 Ft =W1 At-1+W2 At-2 .....+ Wn At-n 529 Ft = Ft-1+(At-1 - Ft-1) 1024 1225 Linear Regression if you have something that 1600 look like a linear trend. 1521 .............. Y = bi X + bo 1849 2209 2704 3025 17124 ...... a y = 3.4126x + 13.6515 R = 0.9707 2 60 50 40 Axis Title 30 20 10 0 0 2. 4 6 8 10 12 14 Axis Title