1 / 15

# Drops By Month - PowerPoint PPT Presentation

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

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about 'Drops By Month' - lavi

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

Weekends have low volumes

Weekends are hard to forecast

• 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%

• 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

• 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

• 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

• 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

• 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

• 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?