Analysis of the seasonality of the data. Indicate seasonal indexes for each month and comment on the high and the low seasonal sales months. Do the seasonal indexes make intuitive sense? Explain.

Description

Review chapter 17 in Modern Business Statistics.

Read Case Problem 1, Forecasting Food and Beverage Sales, on page 868.

Perform an analysis of the sales data.

Prepare a report that summarizes your findings in five pages maximum, forecasts, and recommendations. Include the following:

A time series plot. Comment on the underlying pattern in the time series.

Analysis of the seasonality of the data. Indicate seasonal indexes for each month and comment on the high and the low seasonal sales months. Do the seasonal indexes make intuitive sense? Explain.

Deseasonalize the time series. Does there appear to be any trend in the deseasonalized time series?

Using the time series decomposition method, forecast sales for January through December of the fourth year.

Using the dummy variable regression approach, forecast sales for January through December of the fourth year.

Provide summary tables of your calculations and any graphs in the appendix of your report.

Submit your assignment for review and feedback.

Last Completed Projects