Pickup Models Excel Template
Originally published: 17/04/2018 12:10
Publication number: ELQ-82376-1
View all versions & Certificate

Pickup Models Excel Template

A tool for forecasting the demand for the next periods.

Pickup models are advanced models that are used in revenue management and can be applied in businesses that book advance services (i.e. airlines, hotels, theatres etc.). The forecast is calculated using the current bookings for a particular future period and estimating the incremental bookings (pickup) from now until this future period (i.e. departure date etc.).

Past data is used when calculating pickup, and it can be the average pickup with a specific anticipation (x days before) if we are summing it with the current bookings or it can be an average pickup ratio (total bookings / bookings x days before) if we are multiplying by the current bookings.

Please refer to the methodology to learn more about the formula and pickups.

This Best Practice includes
1 Pickup Models Excel Template & 1 Methodology

Alberto Scappini offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

To forecast the demand for the next periods.

4.6 / 5 (5 votes)

please wait...