Rachel’s Breakfast Café
Rachel’s Breakfast Café
Rachel Kirkpatrick thought to herself, “What a waste,” as she threw away three bags full of unsold items and spoiled ingredients. “I have to get better at estimating how much food to order and prepare.”
Rachel owned and operated a small café that specialized in fresh-baked quiches, breakfast casseroles, and breads, as well as ready-made country style breakfasts. The café was open six days a week and closed on Sundays. Rachel had run her shop for over a year now, and business seemed to be taking off. While she had made a number of operating improvements related to the consistency and quality of her products, she still struggled between two extremes of the same problem. On some days Rachel did not have enough ingredients on hand to satisfy the day’s customers. In this case, some of the people who expected to get one of her famous quiches were disappointed. Other days Rachel had far too much food on hand. On days like today, Rachel found herself throwing away food because she had vastly overestimated the number of customers she would have.
While it was difficult for Rachel to know exactly how many customers she served each day, she was able to accurately track the total dollar value of sales. It seemed to her that her business was growing, but she had not taken the time to see whether the increasing demand was a true trend or just her perception. Based on her assumption that business was growing, Rachel had been placing larger orders with her suppliers of milk, eggs, cheese, and other ingredients each week. Each day Rachel placed orders for supplies online at a nearby grocer’s Web site, and he delivered each order five days later.
As Rachel considered how to improve her forecasts for needed items, she thought about possible factors that caused demand to be greater or smaller each day at her café. Fridays and Saturdays were usually busier than other days. Beyond the weekend effect, she noted that the weather had an impact. On rainy days people were less likely to go out for breakfast. Rachel wondered how she could use this information to improve her business.
Over the next four weeks Rachel collected the data shown in the following table. The “5-day forecast” column shows the probability of rain (percentage) for the area around Rachel’s café, as predicted by the local weather service five days into the future. For example, the table shows a forecasted 10 percent probability of rain on the first Monday in the table; this was the forecast released by the weather service on the Wednesday five days earlier. Since it currently took Rachel five days to receive orders for her supplies, she knew that she would need to have the weather forecast at least this far in advance in order for it to be of use to her. At the same time, she also knew that shorter term forecasts are usually more accurate. So, she also decided to track the “2-day forecast,” that is, forecasts made two days in advance.
Day |
Probability of Rain (%) 5-day forecast |
Probability of Rain (%) 2-day forecast |
Total Sales |
Monday |
10 |
40 |
5520 |
Tuesday |
20 |
30 |
4320 |
Wednesday |
30 |
10 |
4212 |
Thursday |
50 |
40 |
4987 |
Friday |
80 |
80 |
5545 |
Saturday |
90 |
90 |
6023 |
Monday |
60 |
30 |
4590 |
Tuesday |
70 |
30 |
4733 |
Wednesday |
90 |
30 |
4923 |
Thursday |
100 |
50 |
4687 |
Friday |
100 |
100 |
5988 |
Saturday |
20 |
70 |
6132 |
Monday |
10 |
10 |
5324 |
Tuesday |
10 |
10 |
4526 |
Wednesday |
10 |
10 |
5232 |
Thursday |
50 |
50 |
5684 |
Friday |
20 |
70 |
5911 |
Saturday |
60 |
60 |
6328 |
Monday |
20 |
20 |
4932 |
Tuesday |
15 |
15 |
5235 |
Wednesday |
20 |
50 |
5862 |
Thursday |
20 |
20 |
4862 |
Friday |
10 |
80 |
6100 |
Saturday |
60 |
70 |
6255 |
page 450
Questions
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?
CASE
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.