Order from us for quality, customized work in due time of your choice.
Case Study #1 is intended to test your knowledge of how to run and interpret the
Case Study #1 is intended to test your knowledge of how to run and interpret the results of a moving average model, a Holt’s exponential smoothing model, and a Winter’s exponential smoothing 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.
Four-period moving average
Holt’s Exponential Smoothing
Winter’s Exponential Smoothing
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
Resources:
Below is the data file and the Instructions/Answer sheet for the case study.
HeathCo_Sales.xlsx Download HeathCo_Sales.xlsx
Week 2 Case Study Instructions and Answer Sheet – BBA 360.docx
Order from us for quality, customized work in due time of your choice.