Question: Highland Automotive wishes to forecast the number of new cars that will be sold next week. The following table summarizes the number of new cars sold during each of the past 12 weeks:
(a) Provide a forecast by using a 3-week weighted moving average technique with weights 5, 3, and 1 15 = most recent2.
(b) Forecast sales by using an exponential smoothing model with a = 0.45.
(c) Highland would like to forecast sales by using linear trend analysis. What is the linear equation that best fits the data?
(d) Which of the methods analyzed here would you use? Explain your answer.