The number of cans of soft drinks 338 219 278 265 314 323 29

The number of cans of soft drinks 338, 219, 278, 265, 314, 323, 299, 259, 287, 302 represent the number sold in a machine each week over the last 10 weeks, with the first number being 10 weeks ago up to the most recent week. Using a three-period moving average, what would have been the forecast for the 5th period?

Solution

The number of cans of soft drinks 338, 219, 278, 265, 314, 323, 299, 259, 287, 302 represent the number sold in a machine each week over the last 10 weeks, with the first number being 10 weeks ago up to the most recent week. Using a three-period moving average, what would have been the forecast for the 5th period?

Moving Average

number of periods:

3

t

Data

3MA

1

338

2

219

3

278

(338+219+278)/3=

278.3

4

265

(219+278+265)/3=

254.0

5

314

(278+265+314)/3=

285.7

6

323

(265+314+323)/3=

300.7

7

299

(314+323+299)/3=

312.0

8

259

(323+299+259)/3=

293.7

9

287

(299+259+287)/3=

281.7

10

302

(259+287+302)/3=

282.7

the forecast for the 5th period =(219+278+265)/3= 254.0