Problem 13 page 552 A BMW car dealer in Sicilia, Italy, has the following monthly new car sales data for January through December 2014. The dealer believes that new car sales follow a monthly seasonal pattern and computed the seasonal indices for each of the 12 months, which are also given in the following table. Month New Car Sales Seasonal Indices 1 720 0.85 2 742 0.85 3 695 0.65 4 798 0.9 5 740 0.85 6 830 1 7 785 0.96 8 900 1.2 9 990 1.3 10 920 1.3 11 890 1.35 12 840 1.35 a Plot the car sales data. Does there appear to be a trend? b. Deseasonalize the actual car sales to isolate the trend component. c Develop a linear trend equation using the desasonalized data. d Develop a trend forecast for January and February 2015 e. Develop a seasonalized forecast for January and February 2015.
Problem 13 page 552
A BMW car dealer in Sicilia, Italy, has the following
monthly new car sales data for January through
December 2014. The dealer believes that new car sales
follow a monthly seasonal pattern and computed the
seasonal indices for each of the 12 months, which are
also given in the following table.
Month New Car
Sales
Seasonal
Indices
1 720 0.85
2 742 0.85
3 695 0.65
4 798 0.9
5 740 0.85
6 830 1
7 785 0.96
8 900 1.2
9 990 1.3
10 920 1.3
11 890 1.35
12 840 1.35
a Plot the car sales data. Does there appear to be a trend?
b. Deseasonalize the actual car sales to isolate the trend
component.
c Develop a linear trend equation using the
desasonalized data.
d Develop a trend forecast for January and February
2015
e. Develop a seasonalized forecast for January and
February 2015.
Step by step
Solved in 3 steps with 3 images