as excel file

1.

Year Actual Demand

1 310

2 365

3 395

4 415

5 450

6 465

Find forecast for the 7th year using the following methods respectively:

a. Nave

b. 2-period Moving Average

c. 3-period Moving Average

d. Exponential Smoothing using =0.8

2. Calculate Mean Square error for each of the above mentioned methods and check the forecast accuracies. Which is the most accurate in this context?