Img-Reboot

Designed And Implemented A Scalable Automated Solution To Accurately Predict Hotel Stay For A Fortune 500 Travel Technology Company

Summary

The client needed daily level forecasts of Hotel Stay Nights for its 7 brands and 50 countries for

  • Effective tracking of daily business performance
  • Accurate prediction of the total stay for the quarter for better financial planning

Approach

We solved this problem with a 2-step approach.

  •  A base forecast model called “Cumulative Booked-to-Stay” approach was designed. This model leverages previous year’s booked and total stay pattern to forecast stayed room nights. With this model as base, we smoothened out the daily booking volatility using a cumulative approach and re-distributed for individual days.
  • Further we treated the model for holidays and events based on the historical holiday booking pattern.

Key Benefits

  • 180 days forecast for every brand-country combination
  • The forecast results were made reporting-friendly to match client’s existing data input format and the output was integrated to their existing system for consumption
  • Real-time tracking of performance with every day forecast
  • Cancellation projection on the booked data to effectively predict no-show and delayed reporting.

Results

Icon Boost

We back-tested the model for two years and achieved an accuracy of 99% for the cumulative 120 days forecast. The accuracy of daily forecast for holidays was over 95%.

Icon Boost

The client now has additional leverage on discussions with brands on projections and expectations for the quarter.

Talk To Us