Quarter Year 1 Year 2 Year 3 Year4 1 294 335 433 280 2 499 5

Quarter

Year 1

Year 2

Year 3

Year4

1

294

335

433

280

2

499

507

516

524

3

437

529

501

515

4

344

285

482

530

1. Using a 6 Moving Average model, what is the MAD value?

2. Using the Liniar Trend Anaylsyis model, what is the forecast for Q4 of year 5.

3.Using the seasonality model, what is the forecast value for the 1st Q of year 5?

4. Using the seasonality model, what is the forecast value for the 3rd Q of year 5?

5. Using the seasonality model, what is the forecast value for the 4th Q of year 5?

Solution