Question: 15. Construct a table similar to Table P-14 with the natural logarithms of monthly sales. For example, the value for January 2000 is . a.

15. Construct a table similar to Table P-14 with the natural logarithms of monthly sales. For example, the value for January 2000 is .

a. Perform an additive decomposition of ln(sales), assuming the model Y = T + S + I.

TABLE P-14 Month 2000 2001 2002 2003 2004 2005 2006 January 154 200 223 346 518 613 628 February 96 118 104 261 404 392 308 March 73 90 107 224 300 273 324 April 49 79 85 141 210 322 248 May 36 78 75 148 196 189 272 June 59 91 99 145 186 257 July 95 167 135 223 247 324 August 169 169 211 272 343 404 September 210 289 335 445 464 677 October 278 347 460 560 680 858 November 298 375 488 612 711 895 December 245 203 326 467 610 664

b. Would you use the trend component, the seasonal component, or both to forecast?

c. Provide forecasts of ln(sales) for the remaining months of 2006.

d. Take the antilogs of the forecasts calculated in part c to get forecasts of the actual sales for the remainder of 2006.

e. Compare the forecasts in part d with those in Problem 14, part

c. Which set of forecasts do you prefer? Why?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Forecasting Predictive Analytics Questions!