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 year