{"id":180090,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/assignment-auto-parts-sales-forecast"},"modified":"2018-10-24T09:33:29","modified_gmt":"2018-10-24T09:33:29","slug":"assignment-auto-parts-sales-forecast","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/assignment-auto-parts-sales-forecast\/","title":{"rendered":"Assignment: Auto Parts Sales Forecast"},"content":{"rendered":"<p>Here\u2019s the instruction:<br \/> Assignment: Auto Parts Sales Forecast<br \/> Estimate a regression model with trend &amp; season dummies to forecast the next year sales:<br \/> 1) Use estimated regression coefficients to compute in-sample forecasts for sales<br \/> 2) For the forecasted quarterly sales in years 2006 and 2007 calculate:<br \/> o Error<br \/> o Squared error<br \/> o Absolute % error<br \/> o The numerator of Thiel\u2019s U statistic<br \/> o The denominator of Thiel\u2019s U statistic<br \/> 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\u2019s U statistic<br \/> 4) Compute sales forecast in the year 2008<\/p>\n<p>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) \u2013 4) and calculate error metrics for years 2006-2007 and sales forecast in the year 2008.<\/p>\n<p>Compute sales forecasts using additive Holt-Winters model. Repeat steps 1) \u2013 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.<br \/> Compare the error metrics (ME, RMSE, MAPE, Thiel\u2019s U) of the four models.<br \/> Construct a line plot showing the actual quarterly sales and forecast by these models.<\/p>\n<p>Auto Parts Sales Forecast<\/p>\n<p>Ted Ralley, the director of marketing research of a large manufacturer of spare parts for<br \/> automobiles, is working on the sales forecast for the next year. He knows that forecast errors<br \/> are costly and wants to forecast the sales as accurately as possible. He collected the data on<br \/> quarterly sales for the previous four years and ran several forecasts using time series<br \/> forecasting methods, but he was still concerned. Ted believes that economic activity and oil<br \/> prices has a significant impact of auto parts sales and decided to check if the sales can be<br \/> predicted better using econometric variables.<i>\u2026<\/i><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here\u2019s the instruction: Assignment: Auto Parts Sales Forecast Estimate a regression model with trend &amp; 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 <a href=\"https:\/\/www.benedictsol.com\/blogs\/assignment-auto-parts-sales-forecast\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-180090","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/180090","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=180090"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/180090\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=180090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=180090"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=180090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}