Loading presentation...

Present Remotely

Send the link below via email or IM


Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.


Rachel's Breakfast Cafe

No description

Rachael Deutsch

on 17 February 2015

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Rachel's Breakfast Cafe

Rachael Deutsch & Steven Fingar
Rachel's Breakfast Cafe
Small cafe that specializes in breakfast foods

Opened just over a year ago

Open six days a week and is closed on Sundays

Works with one supplier for all raw materials

Sales are increasing
About Rachel's Breakfast Cafe
Rachel is having difficulty with demand forecasting

Some days she runs out of food, resulting in:
Lost sales
Overhead costs not utilized

Some days she throws away a lot of excess food, resulting in unnecessary costs:
Raw materials
Production costs
Holding costs
Labor costs

The Problem at
Rachel's Cafe
Beyond Fridays and Saturday, her busiest days, Rachel has noticed weather affects business:
On rainy days, fewer people go for breakfast

She wants to use weather forecasts to predict demand (demand forecasting)

Rachel has collected four weeks worth of data and noted the accompanying sales
Probability of rain (%) based on a five day and a two day forecast

Rachel's Proposed
Rachel's Data
5 Day Forecast Analysis
2 Day Forecast Analysis
5 Day Versus 2 Day Forecast
Additional Recommendations
Forecast Bias (MFE):
Average forecast error over a number of periods
A positive forecast = underestimating demand
A negative forecast = overestimating demand
Forecast bias of 0 is ideal

Mean Absolute Deviation (MAD):
Provides the average size of forecast errors, irrespective of their directions

Mean Absolute Percentage Error (MAPE)
Indicates how large errors are relative to the actual demand quantities

Both the 5 and 2 day forecasts have a forecast bias of 0. The MAD and MAPE of the 2 day forecast is lower. The 2 day forecast is therefore more accurate.

Open bakery on Sundays

Possibly extend hours open

Consider current season

Have wholesale prices increased?

Explore other suppliers/wholesalers who require fewer days notice

Demand Management possibilities
Pricing & promotional activities on weekdays, holidays, etc.

Time series model: Weighted moving average
Total Sales
Order Lead Time & Forecasting Accuracy
Current supplier requires at least five days notice (lead time)

Forecast accuracy is reduced with

Less accuracy = a waste or an excess of food
Works Cited


"Managing Operations Across the Supply Chain"

Effectively Using the Rain Forecasts
By using the rain forecasts, Rachel will be able to adjust production accordingly

Fridays & Saturdays should be independent of this adjustment

This adjustment will ideally lead to:
Fewer wasted resources
High customer satisfaction
Increased sales
Overall growth
Weekly Average Total Sales
Full transcript