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

Pickup Models Excel Template

A tool for forecasting the demand for the next periods.

additive pickupforecastforecastingmultiplicative pickuppickuprevenue managementyield management

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.

This business tool includes
1 Pickup Models Excel Template & 1 Methodology

Alberto Scappini offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Further information

To forecast the demand for the next periods.

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from Alberto Scappini

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Pickup Models Excel Template?

The user community and author are here to help. Go ahead!

please wait...