Explore BrainMass
Share

Seasonal index of lumber production

The quarterly production of pine lumber, in millions of board feet, by Northwest Lumber sine 1996 is:

Year | Winter | Spring | Summer | Fall
1996 | 7.8 | 10.2 | 14.7 | 9.3
1997 | 6.9 | 11.6 | 17.5 | 9.3
1998 | 8.9 | 9.7 | 15.3 | 10.1
1999 | 10.7 | 12.4 | 16.8 | 10.7
2000 | 9.2 | 13.6 | 17.1 | 10.3

a. Determine the typical seasonal pattern for the production data using the ratio-to-moving-average method.

b. Interpret the pattern.

c. Deseasonalize the data and determine the linear trend equation.

d. Project the seasonally adjusted production for the four quarters of 2001.

© BrainMass Inc. brainmass.com June 24, 2018, 12:53 pm ad1c9bdddf

Attachments

Solution Summary

Using detailed explanation and calculation, this solution determines the seasonal pattern and linear trend, including a graph. It is attached in Excel format.

$2.19