Pickup Models Excel Template

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