HeathCo is a manufacturing company that produces a line of skiwear that is sold under various brand
Question:
HeathCo is a manufacturing company that produces a line of skiwear that is sold under various brand names. The Product Manager of HeathCo has contracted with you to develop a model to forecast company sales. You will be supplied with quarterly sales data from 2007 through 2016. They want a model that will allow them to forecast sales one year (four quarters) out. You will use the HeathCo Data with Causal Vars worksheet in the HeathCo_Sales.xlsx workbook for this case study. In this case study, you will run a causal regression model and compare the results to the best fitting model from the previous case study(s).1.Causal Regression Modela.Use the data from the years 2007 to 2015 to create a causal regression model using ForecastX. Reserve 2016 data as a holdout to evaluate the accuracy of your models.i.On the Data Capture tab, make sure the Data to be Forecast only includes data through 2015 (Row 37) and set the Forecast Periods to 4. ii.On the Forecast Method tab, set the Forecast Technique to Multiple Regression. Make sure the Dependent Series is set to Sales.iii.On the Statistics tab, check the MAPE option on the tab and the Root Mean Sq Error on the Accuracy tab of the More Statistics pop-up option.iv.On the Reports tab, uncheck the Standard option, check the Audit option, and check the Fitted Values Table option.v.Press Finish and View Output. Save your results. Copy the results worksheet to a workbook with the data file.b.Based on a review of the model fit graph in ForecastX, do the model results show a similar trend to the trend of data series? Explain your answer. c.Based on a review of the model fit graph in ForecastX, do the model results show a similar seasonal pattern to the seasonal pattern of data series? Explain your answer. d.Write a brief description of the model fit using the ForecastX MAPE and RMSE output. Include the values of the MAPE and RMSE measures in your descriptione.Calculate the MAPE and RMSE model accuracy using the four quarters of holdout data and the forecasts for the same four quarters in the ForecastX output. f.Write a brief description of the model accuracy. Include the values of the MAPE and RMSE measures in your description. 2.In a separate Word document, write a concise summary report in APA format for the general manager. Your report should include an introduction, methodology, results, conclusions/recommendations, and references. The introduction must include a brief literature review (see template for instructions and details). The recommendation to the general manager should include whether the causal regression model is likely to be more useful for making predictions for his intended business purpose than the best previous model. Period SalesMar-07 72962Jun-07 81921Sep-07 97729Dec-07 142161Mar-08 145592Jun-08 117129Sep-08 114159Dec-08 151402Mar-09 153907Jun-09 100144Sep-09 123242Dec-09 128497Mar-10 176076Jun-10 180440Sep-10 162665Dec-10 220818Mar-11 202415Jun-11 211780Sep-11 163710Dec-11 200135Mar-12 174200Jun-12 182556Sep-12 198990Dec-12 243700Mar-13 253142Jun-13 218755Sep-13 225422Dec-13 253653Mar-14 257156Jun-14 202568Sep-14 224482Dec-14 229879Mar-15 289321Jun-15 266095Sep-15 262938Dec-15 322052Mar-16 313769Jun-16 315011Sep-16 264939Dec-16 301479
Business Forecasting with Forecast X
ISBN: 978-0073373645
6th edition
Authors: Holton wilson, barry keating, john solutions inc