The five month moving averages for the following data
|
Month (rth) |
43 |
44 |
45 |
46 |
47 |
48 |
49 |
50 |
51 |
|
Actual Demand |
105 |
106 |
110 |
110 |
114 |
121 |
130 |
128 |
137 |
is:
Answer & explanation
Correct answer: option 1
The correct answer is Option (1) → 109, 112.2, 117, 120.6, 126
Five-Month Moving AveragesFormula: Five-month moving average = $\frac{\text{Sum of 5 consecutive months}}{5}$
Month 43-47: $\frac{105+106+110+110+114}{5} = \frac{545}{5} = 109$
Month 44-48: $\frac{106+110+110+114+121}{5} = \frac{561}{5} = 112.2$
Month 45-49: $\frac{110+110+114+121+130}{5} = \frac{585}{5} = 117$
Month 46-50: $\frac{110+114+121+130+128}{5} = \frac{603}{5} = 120.6$
Month 47-51: $\frac{114+121+130+128+137}{5} = \frac{630}{5} = 126$