Computer sales over the past 4 months have been 35, 34, 38, and 44 units.
„L Using a 3-month moving average, forecast sales for the next month.
(35+34+38)/3 = 35.67
(34+ 38+44)3 = 38.67
„L Using a 3-month weighted moving average with the weights 3, 2, and 1, and with the most weight on the most recent data, forecast the next period¡¦s sales.
[(1x44) + (3x38) + (3x34)]/6=
1x44= 44
3x38=114
3x34=102
44+114+102=260/6 = 43.3
„L Calculate the forecast using exponential smoothing with an alpha of 1 and a first period¡¦s forecast of 35.
New forecast (NF) = 44
Last period¡¦s forecast (LPF) =38
Last period¡¦s actual demand = 38.67
(NF=LPF + a (LPAD ¡VLPF)
35 + 1 (44-35)
35 +1 (9)
35 + 9
44
I am kinder lost on this, not sure if I did it correctly.
0 answers