The manager of the electrical department at Arnold’s store asked a statistician to perform a time series analysis on the quarterly sales figures of the numbers of TVs sold over the past 3 years. The statistician was called away on urgent business and you have been asked to finish the analysis. A copy of the data is shown on ARNOLD worksheet. You have been told that the aim is to forecast the next 4 quarters’ sales.

Complete the calculations that are required to estimate the sale forecast for Quarter 1, 2, 3 and 4 of Year 4 including the values of sales forecast for the quarter 1, 2, 3 and 4 of year 4. The table should include, Moving Average, Trend Centered Moving Average, Seasonal variation, adjusted seasonal values, extended trend and sale forecast. (22 marks)

Conclude the results that you achieved from the questions above. Your answers should include: (100 words) (8 marks)

(i) The purpose of the forecasting.

(ii) Conclusion – a summary of what you have achieved.