WORLD TOURISM ORGANIZATION UNWTO Software for Measuring Accommodation

WORLD TOURISM ORGANIZATION (UNWTO) Software for Measuring Accommodation Services SESRIC-UNWTO Workshop on Tourism Statistics and the Elaboration of a Tourism Satellite Account ANKARA, TURKEY June 2008

Accommodation • Probably the most important sector within the tourism industries in any country • Measuring it, provides wealth of statistics • Relates to both Inbound and Domestic tourism 2

Objectives • Geographical distribution of tourists (travellers) (domestic and international) • Use of accommodation by type, category, location and size • Seasonal variation • Supply vs. demand • Duration of stay • Employment • Income 3

So what are the difficulties? • Available…but often hard to capture • Geographical spread • Variety of forms of accommodation that are often not well identified (not always a licensing procedure, or not covering all types) • Need statistics in a consistent format • Need consent and active participation of management 4

Key Issues Remember… • • • Legislation – providers must collect statistics Educate – trust / share the findings Universe need not be all establishments Ideally cover greatest possible number Sometimes confined to tourist areas Must cover the whole year 5

Key Issues Remember… Not all guests are tourists • • • And… Legislation – providers must collect statistics Some – tourists not the stayfindings in commercial Educate trust / will share accommodation Universe need not be all establishments Some tourists during their trips can also Ideally cover greatest possible number stay in more than one accommodation Sometimes confined to tourist areas establishment Must cover the whole year So… Not all inbound or domestic tourism is reflected in the statistics 6

TABLE 5 Production Accounts of the Tourism Industries 7

TABLE 10 Non-monetary indicators c. Number of establishments and capacity by forms of accommodation Collective tourism establishments Hotels and similar Others Private tourism accommodation Second homes Others Number of establishments Capacity (rooms) Capacity (beds) Capacity utilization (rooms) Capacity utilization (beds) 8

Software for Measuring Accommodation Services 9

How does it work? • • Compile a directory of accommodation establishments Select a sample Get the participation of the establishments in the sample They complete and return a monthly form These forms are processed centrally Missing information is estimated Informants receive feed-back Why not do it electronically? Technology widely used in the sector Facilitates data collection Facilitates data compilation 10

The Software • • • A programme that runs on Excel Easy to use Simplifies data collection Formats data ready for transmission Data ready to be processed by NTA 11

The format • 4 interrelated worksheets – Operations data – Analysis – Results – Data Stream 12

Operations data • • • Operation information Accommodation capacity Employment: all staff on payroll Wages and salaries Turnover total revenue for the month Statistics on rooms: occupied, vacant, and arrivals/departures 13

14

15

16

17

Results • Accommodation ratios – Room occupancy rate – Bed/room ratio • Average Length of Stay – Domestic/foreign Guests • Room and beds – Total room nights – Total bed nights (domestic/foreign) – Arrivals (domestic/foreign) • Economic indicators – Average room rate – Average total spend (room/night, guest/night) – Employee/room – Average wage/employee – Average revenue/employee 18

19

Basic summary data: • the data stream 20

Room Occupancy Rate 229/465 = 49. 2% 21

Bed Occupancy Rate (160+123)/930 = 30. 4% 22

Using the data stream 23

Persons per Room (160+123)/229 = 1. 2 24

Average Length of Stay (160+123)/(9+12) = 13. 5 25

Average Room Rate (30, 000)/229 = 131 26

Average Total Spend (per guest night) 39, 500/(160+123) = 140 27

Employees per Room (11+(5/2))/15 = 0. 9 28

Average Wage per Employee 20, 000/(11+(5/2)) = 1, 481 29

Average Revenue per Employee 39, 500/(11+(5/2)) = 2, 926 30

- You can save and print the results - You can print and export the outpu (data stream). 31

Compiling Statistics • Monthly, quarterly and annually • Regionally and nationally • Access, Excel or other software 32

In Summary… Define Scope of the Survey Compile Results and Report Directory of Establishments Encourage Sector Participation Daily Record Programme 33

Difficulties • Get the regular participation of the industry – Insist on the benefits for them – Provide feedback – Discuss the results with them • Update regularly the directory of establishments in particular when new developments are known… • If the coverage is too unstable – Device a system of estimation of missing values (guidelines are provided) – Systematic process of revision of estimates when late information arrives: pedagogical exercise (importance of each data…) 34