Asked by JeannieC
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.
„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.
Answers
There are no human answers yet.
There are no AI answers yet. The ability to request AI answers is coming soon!
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.