Seasonally adjusted trend forecast

Reference no: EM13990486

Hillstone SA manufactures and sells tyres to the passenger vehicle market in southern Africa. The quarterly sales (in 1 000s of units) are shown in the table below. The marketing department wishes to apply time series analysis to estimate future quarterly passenger vehicle tyre sales for 2012 and 2013.

Year	Quarter	Tyressold
2005	Jan-Mar	64 876
	Apr-Jun	58 987
	Jul-Sep	54 621
	Oct-Dec	62 345
2006	Jan-Mar	68 746
	Apr-Jun	66 573
	Jul-Sep	60 927
	Oct-Dec	71 234
2007	Jan-Mar	78 788
	Apr-Jun	71 237
	Jul-Sep	68 098
	Oct-Dec	74 444
2008	Jan-Mar	77 659
	Apr-Jun	76 452
	Jul-Sep	73 456
	Oct-Dec	78 908
2009	Jan-Mar	84 563
	Apr-Jun	81 243
	Jul-Sep	74 878
	Oct-Dec	86 756
2010	Jan-Mar	91 556
	Apr-Jun	85 058
	Jul-Sep	77 035
	Oct-Dec	80 145
2011	Jan-Mar	102 923
2011	Apr-Jun	96 456

(a) Use Excel to develop a time series model that Hillstone can use to prepare seasonally adjusted trend forecasts of passenger vehicle tyre sales on a quarterly basis.

(b) Prepare seasonally adjusted trend forecast estimates for 2012 and 2013 on a quarterly basis.

Reference no: EM13990486

Questions Cloud

Ethical issues that merit specific attention : Name and discuss briefly some of the most important human rights and ethical issues that merit specific attention when choices regarding investments in health are being made. Give examples

Construct a normal probability plot from the residuals : Construct a normal probability plot from the residuals - Calculate estimates of the main effects and does there appear to be interaction between the factors?

Difference between accommodation and assimilation : Explain in your own words the difference between accommodation and assimilation. Explain one life situation in which you found it easy to assimilate into a new situation. Explain one life situation in which you had to struggle to assimilate.

Planning for the expansion of the medical facilities : The Medical Officer of Health in charge of day clinics in the Butterworth district is planning for the expansion of the medical facilities at these clinics based on the growth in demand for the clinics' services.

Seasonally adjusted trend forecast : (a) Use Excel to develop a time series model that Hillstone can use to prepare seasonally adjusted trend forecasts of passenger vehicle tyre sales on a quarterly basis. (b) Prepare seasonally adjusted trend forecast estimates for 2012 and 2013 on a..

Moving average time series of company liquidations : (a) Use Excel to compute both a three-period and a five-period moving average time series of company liquidations. (b) Plot the original time series of company liquidations and the three-period and five-period moving average values on the same grap..

In which year would you say the team is doing better why : She wants to compare this year=s team scoring records to last year=s.Last year=s team had a standard deviation of 1.0 for goal scoring against, with a mean of 4.5. In which year would you say the team is doing better? Why

How much does she need to deposit now : Anne wants $15,000 in 5 years. If her savings account earns 6% a year, how much does she need to deposit now? a. $9,725.75 b. $11,208.87 c. $10,500 d. $12,317.51

An investment opportunity having a market price : An investment opportunity having a market price of $1,000,000 is available. You could obtain a $750,000, 25-year mortgage loan requiring equal monthly payments with interest at 7.0 percent.

User Account

All Pages