Here’s the instruction:
Assignment: Auto Parts Sales Forecast
Estimate a regression model with trend & season dummies to forecast the next year sales:
1) Use estimated regression coefficients to compute in-sample forecasts for sales
2) For the forecasted quarterly sales in years 2006 and 2007 calculate:
o Error
o Squared error
o Absolute % error
o The numerator of Thiel’s U statistic
o The denominator of Thiel’s U statistic
3) Calculate the following error metrics: mean error (ME), mean squared error (MSE), root mean squared error (RMSE), mean absolute percent error (MAPE), and Thiel’s U statistic
4) Compute sales forecast in the year 2008
Estimate another regression model, but this time use M2 Index, non-farm activity index, and oil prices as predictors to forecast the next year sales. Repeat steps 1) – 4) and calculate error metrics for years 2006-2007 and sales forecast in the year 2008.
Compute sales forecasts using additive Holt-Winters model. Repeat steps 1) – 3) and calculate error metrics for years 2006-2007. Calculate the optimal alpha, beta, and gamma parameters of the model using MS Excel Solver so as to minimize RMSE. Compute sales forecast in the year 2008.
Compare the error metrics (ME, RMSE, MAPE, Thiel’s U) of the four models.
Construct a line plot showing the actual quarterly sales and forecast by these models.
Auto Parts Sales Forecast
Ted Ralley, the director of marketing research of a large manufacturer of spare parts for
automobiles, is working on the sales forecast for the next year. He knows that forecast errors
are costly and wants to forecast the sales as accurately as possible. He collected the data on
quarterly sales for the previous four years and ran several forecasts using time series
forecasting methods, but he was still concerned. Ted believes that economic activity and oil
prices has a significant impact of auto parts sales and decided to check if the sales can be
predicted better using econometric variables.…
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer Assignment: Auto Parts Sales Forecast
Here’s the instruction:
Assignment: Auto Parts Sales Forecast
Estimate a regression model with trend & season dummies to forecast the next year sales:
1) Use estimated regression coefficients to compute in-sample forecasts for sales
2) For the forecasted quarterly sales in years 2006 and 2007 calculate:
o Error
o Squared error
o Absolute % error
o The numerator of Thiel’s U statistic
o The denominator of Thiel’s U statistic
3) Calculate the following error metrics: mean error (ME), mean squared error (MSE), root mean squared error (RMSE), mean absolute percent error (MAPE), and Thiel’s U statistic
4) Compute sales forecast in the year 2008
Estimate another regression model, but this time use M2 Index, non-farm activity index, and oil prices as predictors to forecast the next year sales. Repeat steps 1) – 4) and calculate error metrics for years 2006-2007 and sales forecast in the year 2008.
Compute sales forecasts using additive Holt-Winters model. Repeat steps 1) – 3) and calculate error metrics for years 2006-2007. Calculate the optimal alpha, beta, and gamma parameters of the model using MS Excel Solver so as to minimize RMSE. Compute sales forecast in the year 2008.
Compare the error metrics (ME, RMSE, MAPE, Thiel’s U) of the four models.
Construct a line plot showing the actual quarterly sales and forecast by these models.
Auto Parts Sales Forecast
Ted Ralley, the director of marketing research of a large manufacturer of spare parts for
automobiles, is working on the sales forecast for the next year. He knows that forecast errors
are costly and wants to forecast the sales as accurately as possible. He collected the data on
quarterly sales for the previous four years and ran several forecasts using time series
forecasting methods, but he was still concerned. Ted believes that economic activity and oil
prices has a significant impact of auto parts sales and decided to check if the sales can be
predicted better using econometric variables.…
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer