Seasonally adjusted trend forecast estimates

Reference no: EM13990609

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: EM13990609

Questions Cloud

Sketch and label the hierarchy of tendons : Sketch and label the hierarchy of tendons, starting with the reticular membrane through tropocollagen.

Invest a fixed sum into a two-year fixed deposit : A couple decides to save to buy a car in two years' time. They will invest a fixed sum into a two-year fixed deposit savings account that pays interest at 12% p.a. How much would they need to invest today to have R150 000 at the end of the two-yea..

Which one of the following is a capital budgeting decision : intermediaries that raise funds from outside investors, play an active role in overseeing, advising, and monitoring the companies in which they invest, and generally do not want to own the investment forever.

What is the purpose of trabecular bone : What is the purpose of trabecular bone? What are trabeculae? What is their function?

Seasonally adjusted trend forecast estimates : (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..

How long does it take of the strontium to decay : Strontium -90 has a half-life of 28 days. Find a formula that gives the amount of strontium left after time t if you start one 200 grams. How long does it take for 80% of the Strontium to decay

Find the resonance width for the circuit : A series RLC circuit with L = 5 mH, C = 3.0 μF, and R = 6.8 ohm is driven by an Ideal ac voltage source that has a peak emf of 80 V and a variable angular frequency w. Find the Q factor. Find the resonance width for the circuit.

What is the linnean classification scheme : What is the linnean classification scheme? How do we currently use this method to organize or classify organisms?

A firm that has total fixed costs sells : If the firm's cost and revenue curves are linear, how much output must the firm produce to break even?

User Account

All Pages