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 (5 = most recent).
(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.

Transcribed Image Text:

WEEK NUMBER SOLD WEEK NUMBER SOLD 26 23 27 21 25 28 26 29 29 27 31 10 12