Free

70.2K

Verified Solution

Link Copied!

The Table in my homework question below is completely wrong. Iam not sure where I went wrong in my calculations but coud yourework this question and answer the parts below??

Here are earnings per share for two companies by quarter fromthe first quarter of 2009 through the second quarter of 2012.Forecast earnings per share for the rest of 2012 and 2013. Useexponential smoothing to forecast the third period of 2012, and thetime series decomposition method to forecast the last two quartersof 2012 and all four quarters of 2013. (It is much easier to solvethis problem on a computer spreadsheet so you can see what ishappening.)

		EARNINGS PER SHARE
	QUARTER	COMPANY A	COMPANY B
2009	I	$ 1.68		$ 0.21       Â
	II	2.36		0.23       Â
	III	1.21		0.21       Â
	IV	1.30		0.35       Â
2010	I	1.66		0.20       Â
	II	2.08		0.36       Â
	III	1.31		0.37       Â
	IV	0.34		0.48       Â
2011	I	0.34		0.35       Â
	II	–0.19	(loss)	0.49       Â
	III	–0.87	(loss)	0.51       Â
	IV	0.24		0.52       Â
2012	I	–1.65	(loss)	0.31       Â
	II	0.37		0.52       Â

a.

For the exponential smoothing method, choose the first quarterof 2009 as the beginning forecast. Make two forecasts: one withα = 0.20 and one with α = 0.30. (Negativevalues should be indicated by a minus sign. Round your answers to 3decimal places.) For the exponential smoothing method, choose the first quarterof 2009 as the beginning forecast. Make two forecasts: one withα = 0.20 and one with α = 0.30. (Negativevalues should be indicated by a minus sign. Round your answers to 3decimal places.) Company A Company B           Quarter Forecast α = 0.20 Forecast α = 0.30 Forecast α = 0.20 Forecast α = 0.30 2009   I                            II                           III                            IV                 2010    I                             II                            III                             IV                 2011    I                             II                             III                             IV                 2012     I                              II                             III                 b-1. Calculate the MAD for each forecast using data starting withsecond quarter of 2009 through second quarter of 2012.(Round your answers to 3 decimal places.) MAD     Company A     Company B   α =0.20         α =0.30       b-2. Using the MAD method of testing the forecasting model'sperformance, plus actual data from 2009 through the second quarterof 2012, how well did the model perform?   Based upon MAD,(Click to select)0.30.2 performs better than an α of (Click toselect)0.20.3.