Problem #18: Complete in Excel as much as possible Please. (Compute MAE: Mean Average Error for the forecast part)

8. New car sales for a dealer in Cook County, Illinois, for the past year are shown in the following table, along with monthly indexes (seasonal relatives), which are supplied to the dealer by the regional distributor. a. Plot the data. Does there seem to be a trend? b. Deseasonalize car sales. c. Plot the deseasonalized data on the same graph as the original data. Comment on the two graphs. d. Assuming no proactive approach on the part of management, discuss (no calculations necessary) how you would forecast sales for the first three months of the next year. e. What action might management consider based on your findings in part b