Question: Chapter 4 , Question 1 7 ( Note: Solved Problem 4 . 1 mentioned in the question can be found on page 1 3 8

Chapter 4, Question 17(Note: Solved Problem 4.1 mentioned in the question can be found on page 138)
Refer to Solved Problem 4.1 on page 144. Using smoothing constants of .6 and .9, develop forecasts for the sales of VW Beetles. What effect did the smoothing constant have on the forecast? Use MAD to determine which of the three smoothing constants (.3,.6, or .9) gives the most accurate forecast.
SOLVED PROBLEM 4.1
Sales of Volkswagens popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). The sales manager had predicted before the new model was introduced that first year sales would be 410 VWs. Using exponential smoothing with a weight of a 5.30, develop forecasts for years 2 through 6.
YEAR SALES FORECAST
1450410
2495
3518
4563
5584
6?
SOLUTION
YEAR FORECAST
1410.0
2422.0=410+.3(450-410)
3443.9=422+.3(495-422)
4466.1=443.9+.3(518-443.9)
5495.2=466.1+.3(563-466.1)
6521.8=495.2+.3(584-495.2)
Group of answer choices

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!