Question: Solve using excel. Knowing that, for a medium - sized dealership, the vehicle sales forecast for week 4 was 8 5 units: a ) Use

Solve using excel. Knowing that, for a medium-sized dealership, the vehicle sales forecast for week 4 was 85 units: a) Use the exponential smoothing with an alpha of 0.45 to forecast sales for periods 5 through 10. b) Estimate the tracking signal for your forecasts. Would you recommend this forecasting model? \begin{tabular}{|c|c|}\hline Week & Sales (units)\\\hline 1 & 100\\\hline 2 & 120\\\hline 3 & 112\\\hline 4 & 90\\\hline 5 & 115\\\hline 6 & 113\\\hline 7 & 108\\\hline 8 & 100\\\hline 9 & 110\\\hline 10 & 99\\\hline 11 & 125\\\hline \end{tabular}

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!