I have forecasting question, and I attached the data in SBUX. (Plese note that I also attached the class lecture, just in case).

Please save your file with your last name as the first word. ABCDE.xlsx

Instructions:

1) Your submission for this part of the final exam is an Excel file with two labeled tabs. For example, the labels on the tabs should be: “Annual-SBUX” and “Quarter-SBUX” if you used Starbucks data. (I already collected the data and did that)

A. Annual Data – Please remember to label your tab with the company name and use it in the graph title.

1. Please provide a labeled scatter plot of your data over time.

2. Please provide the analysis (model) you used for your forecast.

3. What is your forecast for the next (most recent) period? Please show this clearly on your spreadsheet. If I cannot find it or how you arrived at the answer, you will not receive credit for having completed this portion of the exam.

4. Why have you chosen this model? Why is it better than other models? Please address in a paragraph on this tab.

5. What reservations, if any, do you have with your forecast? Please address in a paragraph on this tab.

B. Quarterly Data – Again, please label your tab and scatter plot with the company name.

1. Please provide a labeled scatter plot of your data over time.

2. Please provide the method (model) you used for your forecast.

3. What is your forecast for the next (most recent) period? Please show this clearly on your spreadsheet. If I cannot find it or how you computed it, you will not receive credit for having completed this portion of the exam.

4. Why have you chosen this model? Why does it have going for it? Please address in a paragraph on this tab.

5. Comment on the usefulness of quarterly forecasting for this company. That is, does the company benefit from quarterly forecasting? Why or why not? Please address in a paragraph on this tab.