Introduction to Operations Management- Week 8 Assignment

Rachel's Breakfast Caf

For the final project, read Rachel's Breakfast Caf from chapter 12 on page 450 and address the following questions. Excel document with the data for the case study is provided here.

1.Develop forecasts using regressions of sales on each of the series of rain forecasts, respectively. Calculate the MFE (bias), MAD, and MAPE for the two forecasting models. Which rain forecast seems to be better at predicting Rachel's daily sales, the five-day forecast or the two-day forecast?

2.How can Rachel make use of the rain forecasts to improve her forecasts of total sales each day? What other changes to her business would she need to make in order to capitalize on this information?

3.How are order lead time and forecasting accuracy related to each other in this case?

4.Plot and visually inspect the sales data. What other suggestions would you give Rachel for improving her sales forecasts? What type of time series model would be appropriate? Why?

In addition to providing the data analysis in Excel or Microsoft Word document, you MUST submit a 10-15 minutes PowerPoint recorded presentation in which you provide details of your work and recommendations based on the data analysis and findings.