3- Auto sales at Carmen’s Chevrolet are shown below: Week Auto Sales 1 8 2 10 3
ID: 3023820 • Letter: 3
Question
3- Auto sales at Carmen’s Chevrolet are shown below: Week Auto Sales 1 8 2 10 3 9 4 11 5 10 6 14 7 - a- Develop a 3-week moving average. b- Carmen’s decides to forecast auto sales by weighting the three weeks as follows: Weights Applied Period 3 Last week 2 Two weeks ago 1 Three weeks ago 6 Total c- Carmen’s uses simple exponential smoothing with to forecast demand. The forecast for the week of January 1 was 15 units whereas the actual demand turned out to be 13 units. Calculate the demand forecast for the week of January 8.
Explanation / Answer
week sales moving avg 1 1 2 8 3 2 4 10 6.6667 5 3 5 6 9 7.3333 7 4 5.3333 8 11 8 9 5 6.6667 10 10 8.6667 11 6 7 12 14 10 13 7 9
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.