Below are income and sales data for a company for the years 2003 through 2015. Year Net

Question:

Below are income and sales data for a company for the years 2003 through 2015.

Year Net Income/Loss Sales 2003 - 0.3 0.5 2004 - 5.7 15.7 2005 - 27.5 147.7 2006 - 124.5 609.8 2007 - 719.9 1,639.8 2008 - 1,411.2 2,761.9 2009 -567.3 3,122.9 2010 -149.1 3,933 2011 35.3 5,263.7 2012 588.5 6,921 2013 359 8,490 2014 190 10,711 2015 476 14,835

a. Produce a time-series plot for these data. Specify the exponential forecasting model that should be used to obtain the following years’ forecasts.

b. Assuming a double exponential smoothing model, fit the least squares trend to the historical data to determine the smoothed constant-process value and the smoothed trend value for period 0.

c. Produce the forecasts for periods 1 through 13 using a = 0.10 and b = 0.20. Indicate the sales the company should expect for 2016 based on the forecast model.

d. Calculate the MAD for this model.

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics

ISBN: 9781292220383

10th Global Edition

Authors: David Groebner, Patrick Shannon, Phillip Fry

Question Posted: