Question: Please use the Excel Module to answer the questions below. 1122. Highland Automotive wishes to forecast the number of new cars that will be sold

Please use the Excel Module to answer the questions below.

Please use the Excel Module to answer the

1122. 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: Week Number Sold Week Number Sold 1 7 2 8 3 9 22 26 23 27 21 25 28 26 29 29 27 31 10 4 5 6 11 12 (a) Provide a forecast by using a 3-week weighted moving average tech- nique 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!