A major brokerage company has an office in Miami, Florida. The manager of the office is evaluated

Question:

A major brokerage company has an office in Miami, Florida. The manager of the office is evaluated based on the number of new clients generated each quarter. The following data reflect the number of new customers added during each quarter between 2006 and 2009.

a. Plot the time series and discuss the components that are present in the data.
b. Referring to part a, fit the linear trend model to the data for the years 2006 through 2008. Then use the resulting model to forecast the number of new brokerage customers for each quarter in the year 2009. Compute the MAD and MSE for these forecasts and discuss the results.
c. Using the data for the years 2006 through 2008, determine the seasonal indexes for each quarter.
d. Develop a seasonally unadjusted forecast for the four quarters of year 2009.
e. Using the seasonal indexes computed in part d, determine the seasonally adjusted forecast for each quarter for the year 2009. Compute the MAD and MSE for these forecasts.
f. Examine the values for the MAD and MSE in parts b and e. Which of the two forecasting techniques would you recommend the manager use to forecast the number of new clients generated each quarter? Support your choice by giving your rationale.