1 / 15

Drops By Month

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

lavi
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Drops By Month

  2. Drops By Week

  3. Drops By Day Of Week Weekends have low volumes

  4. Errors in Daily Forecast by Day of Week Weekends are hard to forecast

  5. 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%

  6. 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

  7. Fridays

  8. 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

  9. We predict a Good Day, but it turns out to be a High Day How it Performs

  10. 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

  11. Better Predictions

  12. 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

  13. By 11 am

  14. 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

  15. 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?

More Related