Case Study #6 is intended to test your knowledge of how to run and interpret the results of a combined model.
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.
Develop and interpret models using the methods below. Use the data from the years 2007 to 2015 to develop models. Evaluate the fit of your models to the data series used to create the model. Reserve 2016 data as a holdout to evaluate the accuracy of your models.
Combined Model
Submit both the Instructions/Answer sheet and your detailed forecasting model runs. You will submit a single Excel workbook with all relevant sheets. The first sheet in your workbook will be an answer sheet with clearly labeled answers to all questions and a guide to sheets where supporting Excel information can be found.
Submit the following two documents:
Completed Instructions/Answer sheet
Excel workbook showing forecasting models and formulas used for calculations
Case Study #6 is intended to test your knowledge of how to run and interpret the
Important - Read this before proceeding
These instructions reflect a task our writers previously completed for another student. Should you require assistance with the same assignment, please submit your homework details to our writers’ platform. This will ensure you receive an original paper, you can submit as your own. For further guidance, visit our ‘How It Works’ page.
