Please make the steps and answer clear and able to read Use

Please make the steps and answer clear and able to read!! :)

Use the following table to answer the questions. Develop an exponential trend forecasting equation with quarterly components. (1) What is the fitted value for the 3rd quarter of 2012 (1) What is the forecast value for the second quarter of 2015? (1)

Solution

Given,

The Seasonal Adjustment is calculated as

The seasonal adjustments are

The fitted value for the third quarter of 2012 is 0.53 x 90 = 47.7

The forecast value for second quarter of 2015 is 1.53 x (265+270+252+281+279)/5 = 412.18

	2010	2011	2012	2013	2014
Q1	196	204	198	210	212
Q2	265	270	252	281	279
Q3	84	91	90	100	106
Q4	130	143	127	140	153
	675	708	667	731	750
	168.75	177	166.75	182.75	187.5