Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Already have parts A-D answered. Please only answer E, F, and G. 5. The quarterly production of pine lumber, in millions of board feet, by
Already have parts A-D answered. Please only answer E, F, and G.
5. The quarterly production of pine lumber, in millions of board feet, by Northwest Lumber in the recent past is presented in the table below. Quarter Winter Summer Fall 7.8 14.7 9.3 Year 17 18 19 Spring 10.2 L 11.6 9.7 - I L L 6.9 8.9 17. 5 15.3 9.3 10.1 a. Determine the seasonal indices for each quarter. b. Deseasonalize the data by dividing each quarter by its seasonal index (you're removing seasonality by dividing). c. Fit a regression line using Excel and find the slope and intercept. Use X from 1 to 12 for X-ime. Can use functions or the data analysis product. d. Forecast the next year of production. Quarters 13-16 e. Add the seasonal component by applying your computed seasonal indices to your forecasted production in (d) f. Wood is primarily used for residential housing in the US. It's expected that demand for housing will decline by 3 percent in the next year. Adjust your forecasts in (e) to account for this forecasted cyclical move. g. State your final estimated production for the 4th year. 5. The quarterly production of pine lumber, in millions of board feet, by Northwest Lumber in the recent past is presented in the table below. Quarter Winter Summer Fall 7.8 14.7 9.3 Year 17 18 19 Spring 10.2 L 11.6 9.7 - I L L 6.9 8.9 17. 5 15.3 9.3 10.1 a. Determine the seasonal indices for each quarter. b. Deseasonalize the data by dividing each quarter by its seasonal index (you're removing seasonality by dividing). c. Fit a regression line using Excel and find the slope and intercept. Use X from 1 to 12 for X-ime. Can use functions or the data analysis product. d. Forecast the next year of production. Quarters 13-16 e. Add the seasonal component by applying your computed seasonal indices to your forecasted production in (d) f. Wood is primarily used for residential housing in the US. It's expected that demand for housing will decline by 3 percent in the next year. Adjust your forecasts in (e) to account for this forecasted cyclical move. g. State your final estimated production for the 4th yearStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started