Occupancy%= # of rooms / Rooms/day
ADR= turnover / room/night
Average Length of Stay = rooms/night / bookings
Average Transaction Size = Total Sales / #of consumed bookings
Total Sales = Turnover
Cancellation Ration= # of canceled bookings / total bookings (%)
Stay=Check in – Check Out
ADR=GP/STAY
Round (G3-F3) O
Classic Display Option
Average Value Field Settings
Why do you get – lead-time?
Check-Reservation Date
Occupancy % x ADR % =REV PAR
HT NET + (TAX + MARGIN) = BRG
Current Bookings/Search x 100 = Conversion
ROI Calculation: Gross/#of booked hotels = Gross per hotel
Gross per hotel x # of mapped = 201 hotels
Bookings x Average Stay x ADR = Growth x number
XXVIV. ABBREVIATIONS
PAX=Passengers
CSS-City Sightseeing
FD-Full Day
O/N-Overnight
AC-Air Canada
TRN-Transfer
EPCOT-Experiential Prototype communication
R/T-Round drip
HD-Half Day (4 hrs.)
BB-Bed and Breakfast
FOC-Free of Charge
DOP (Day of Payable)
DOS (Day of Received)
EBITDA-Net Profit After Expenses before Taxes
LOC-Line of Credit
BRG-Best Rate Guarantee
REIT-Real Estate Track Investment
S.T. (a) R.-Smith Travel Research
DW-Data Warehouse
GUID-Global Unique Id
IIS-Internet Information Server
AS-autonomous systems;
Prove searches done by them and we aren’t blocking them; check their IP address
Implementation – coding of the client (language)
Integration – Connection between 2 systems
Certification – Process we are working through
Permissions/credentials – Username and password
Hotwire -> They sell opaque (manual)
No CheckAvailabilityandPrices -> Booking Failures
NDA-Non Disclosure Agreement (not going to share info with anyone else)
Some process for the switch
SOW- How we can work/with the client on connectivity (XML)
based on pre-development questionnaires
NHS (New Horizon Systems and Revenue Management)
NHS
Gets data from back office;
Clickview-2/3 modules (Graphs and tables) Distribution/Destination
SEARCH –DW WEEKLY
- Source Country
- Reservation time 2015
- Agency Compare 1
- Conversion for Export
OVERSUPPLY: FEAR, MARKET DATA
=IF(Iserror(Vlookup($A2, Mix!$1:65536,6,0))O, VLOOKUP
COW/CURRENT Conversion/Hotels/PRB/FIT/DC
AEROMEXICO: OPAQUE
SALES
- Source Country
- Reservation Time 2015
- Agency – Compare 2
- Provider
- #Hotels
- Then Gross (Revenue)
- Total (Autosum)
- DC (Total-LocalTGS-Hoboo)
- DC-#Hotels
- DC-$Gross
- Agency + PRB (Gross Export)
- Agency + PRB (Export # of Hotels)
- FIT = NonPRB + EPRB (Twice)
- Vlookup (agency, $Agency2; 8N, 4)
- BCDEFG
- Paste special for #’s
- $A2: B2/(SUM PRB +/FIT) DC Hotels
- Excel Spreadsheet: Agency, DC-H, PRB-H, FIT-H, DC-H, PRB-H, FIT-H, DC-$, PRB-$, FIT-$