MGT613

April 23 = (50+65+52)/3= 55.66April 30 = (65+52+56)/3= 57.66May 7 = (52+56+55)/3= 54.33 May 14 = (56+55+60)/3 = 57May 21 = (55+60+56)/3= 57Weighted Moving AverageApril 23 = 0.50(52)+0.30(65)+0.20(50)= 26 + 19.5 + 10= 55.5April 30 = 0.50(56)+0.30(52)+0.20(65)= 28 + 15.6 + 13= 56.6 May 7 = 0.50(55)+0.30(56)+0.20(52)= 27.5 + 16.8 + 10.4 = 54.7May 14 = 0.50(60)+0.30(55)+0.20(56)= 30 + 16.8 + 11.2= 58May 21 = 0.50(56)+0.30(60)+0.20(55)= 28 + 18 + 11= 57 Used smoothing constant (alpha)a = 0.1April 16 = 50 + 0.1(65 – 50)= 51.5April 23 = 51.5 + 0.1(52 – 51.5)= 51.55April 30 = 51.55 + 0.1(56 – 51.55)= 51.995May 07 = 51.995 + 0.1(55 – 51.995)= 52.2955May 14 = 52.2955 + 0.1(60 – 52.2955)= 53.0659May 21 = 53.0659 + 0.1(56 – 53.0659)= 53.3593