Drops by month
This presentation is the property of its rightful owner.
Sponsored Links
1 / 15

Drops By Month PowerPoint PPT Presentation


  • 56 Views
  • Uploaded on
  • Presentation posted in: General

Drops By Month. Drops By Week. Drops By Day Of Week. Weekends have low volumes. Errors in Daily Forecast by Day of Week. Weekends are hard to forecast. Bad Days. A Bad Day is… When drops exceed forecast by more than 20% (say) Two kinds of Bad Days

Download Presentation

Drops By Month

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Drops by month

Drops By Month


Drops by week

Drops By Week


Drops by day of week

Drops By Day Of Week

Weekends have low volumes


Errors in daily forecast by day of week

Errors in Daily Forecast by Day of Week

Weekends are hard to forecast


Bad days

Bad Days

  • A Bad Day is…

    • When drops exceed forecast by more than 20% (say)

  • Two kinds of Bad Days

    • High Days: When Drops exceed Forecast by more than 20%

    • Low Days: When Drops fall short of Forecast by more than 20%


Example

Example

  • Compare the fraction of forecasted drops seen each hour of a “good” day with the fraction seen on “bad” days

  • Question: Can we determine early when a bad day is coming?

  • Next Slide has four charts: (view in Presentation mode)

    • Good Fridays

    • High Fridays

    • Low Fridays

    • Good Fridays again


Fridays

Fridays


A test

A Test

  • If By 7 am

    • More than 5 times the volume we forecasted has dropped, anticipate a High Day

    • Less then 10% of the volume we forecasted has dropped, anticipate a Low Day

    • Otherwise, expect a Good Day


How it performs

We predict a Good Day, but it turns out to be a High Day

How it Performs


Waiting to decide

Waiting to Decide

  • If By 9 am

    • More than 10 times the volume we forecasted has dropped, anticipate a High Day

    • Less then 5% of the volume we forecasted has dropped, anticipate a Low Day

    • Otherwise, expect a Good Day


Better predictions

Better Predictions


Waiting to decide1

Waiting to Decide

  • If By 11 am

    • More than 50% higher volume than we forecasted has dropped, anticipate a High Day

    • Less then 50% of the volume we forecasted has dropped, anticipate a Low Day

    • Otherwise, expect a Good Day


By 11 am

By 11 am


Conclusions

Conclusions

  • Forecasts by Month and Week are quite good

  • Daily Forecasts are less reliable, especially on Mondays and Weekends

  • Focus labor flexibility around those days

  • As the day progresses, we can make increasingly good predictions about the rest of the day’s demand

  • There seems to be an opportunity to develop intelligent staffing strategies that use this information


Question

Question

  • As the day progresses, we…

    • Get better information

    • Incur more sunk costs

    • Lose flexibility

  • How much can be gained by quantifying and trading off these factors?


  • Login