Homework
Scenario: You will help Karen, the owner and operator of Vantage Restaurant, develop a system that will enable her to forecast food and beverage sales by month for up to one year in advance.
Steps:
I. Perform an analysis of the sales data.
II. Prepare a report that summarizes your findings in five pages maximum, forecasts, and recommendations. Include the following:
i. A time series plot. Comment on the underlying pattern in the time series.
ii. 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.
iii. Deseasonalize the time series. Does there appear to be any trend in the deseasonalized time series?
iv. Using the time series decomposition method, forecast sales for January through December of the fourth year.
v. Using the dummy variable regression approach, forecast sales for January through December of the fourth year.
vi. Provide summary tables of your calculations and any graphs in the appendix of your report.
Format your homework according to the following formatting requirements:
i) The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
ii) The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
iii) Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.