JASTH – Journal of Applied Sciences in Travel and Hospitality Vol. 1, No. 1, March 2018 24 CONTRIBUTION OF OFFLINE AND ONLINE TRAVEL AGENT TOWARD ROOM OCCUPANCY AT FOUR POINTS BY SHERATON BALI SEMINYAK HOTEL 1Putu Septiawan, 2Nyoman Mastiani Nadra, 3Ni Nyoman Sri Astuti Tourism Business Management, Politeknik Negeri Bali email: 1septiawanputu@gmail.com, 2mastianinadra@pnb.ac.id, 3nyomansriastuti@pnb.ac.id ABSTRACT The background of this research was based on of technology development that affect to room sales at Four Points by Sheraton Bali Seminyak. Room sales and promotion are made through offline and online travel agent. The purpose of this research to determine the level contribution of offline and online travel agent toward room occupancy of Four Points by Sheraton Bali Seminyak and to determine the highest contribution of offline and online travel agent. The data was collect by observation, interview and documentation. The data source were used are Primer and secondary data and the type of data were used quantitative data. The data will analyzed used descriptive statistic, the processing using Microsoft Excel to analyzed data by descriptive statistic function mean, median, modus, standard deviation. Based on calculation the contribution of offline and online travel agent was dominate by Expedia with total contribution by 61,78% and Coorendon with total contribution by 37,71% on 2015-2017. The suggestion could be given that the hotel should to strengthen in relationship with travel agent and make good contract rate and offer the best package for their market., so that the travel agent could provide the great contribution toward room occupancy of Four Points by Sheraton Bali Seminyak Hotel. Keywords: offline travel agent, online travel agent, room occupancy. INTRODUCTION Bali is popular and favorite tourist destination for every foreign and domestic. Uniqueness and attractiveness that is attract the tourist to visit Bali and it is resulting the development of tourism in Bali is growing rapidly. It evidenced by number of tourist visit to Bali in 2013 – 2017 which show the number of tourist visits increased. The number of tourist visit to Bali increased by 14,9% and by development of tourism facilities such as hotel accommodation, with the highest growth by 3-star hotel with an average growth by 62 hotels built each year. The globalization era was greatly effect to hospitality industry because everything is required to be easily accessible. Currently, offline travel agency is used as a leisure mailto:septiawanputu@gmail.com mailto:mastianinadra@pnb.ac.id mailto:nyomansriastuti@pnb.ac.id JASTH – Journal of Applied Sciences in Travel and Hospitality Vol. 1, No. 1, March 2018 25 and business trip organizer, it become a distribution channel to hotel. In simplifying effort of booking a room, online travel agent make a sale and promotion according to websites and social media that they provide for all customer with various features of booking to payment. With an easily offer by travel agency, Four Points by Sheraton Bali Seminyak hotel doing cooperate with travel agency. This way can attract tourist to stay and improve room occupancy. Online travel agent that become to Four Points by Sheraton Bali Seminyak’s partner such as Agoda.com, Booking.com, Expedia, and Hotelbed for offline travel agent such as Coorendon, Flight Center, GTA, and Thomas Cook. Table 1 Room occupancy of Four Points by Sheraton Bali Seminyak by 2015-2017. Tahun Distribution Channels Offline Travel Agent Online Travel Agent Website Direct Booking 2015 7.905 19.147 4.597 2.971 2016 11.664 15.158 3.408 1.421 2017 8.963 15.154 2.441 1.538 (Source: Sales and Marketing Department). As a distribution channel, contribution of travel agent toward room occupancy of Four Points by Sheraton Bali Seminyak fluctuated differently every year. Travel agent has a potential strength to become a distribution channel with the highest contribution if compared with other distribution channel. Table 1shows average contribution of offline travel agent on 2015 to 2017 by 9.853 and online travel agent by 16.630. Although the level of contribution is dominated by online travel agent, but the contribution of offline travel agent has a major effect toward room occupancy of Four Points by Sheraton Bali Seminyak. Accordingly, to know the level of contribution to hotel’s room occupancy and to know who has a highest level of contribution from each travel agent, therefor do this research about contribution of offline and online travel agent toward room occupancy of Four Points by Sheraton Bali Seminyak. JASTH – Journal of Applied Sciences in Travel and Hospitality Vol. 1, No. 1, March 2018 26 LITERATURE REVIEWS Hotel, according to SK Menparpostel number: KM 34/HK/103/MPPT-87 in Putri (2016; 1), is a type of accommodation that use a part or all of its buildings to provide accommodation services, food and drink, and other public services. Commercially managed and comply with the requirements set by government’s decisions. Travel agent is a travel agency that sells tourism service such as transportation, lodging, travel document arrangement and includes vacation activities for individuals and groups planning trips. Hanief and Pramana (2017 ; 55). Currently travel agents or travel agents can be grouped into two namely offline travel agent and online travel agent. The contribution made by offline and online travel agent as known as affiliate marketing. It is a Business system by paying someone’s service when sell the product of hotel or company used internet. According to sugiarto (2004; 55) room occupancy is the state which how far the number of rooms sold when compared with rooms that can be sold. Oka. A. Yoeti (2009; 55) said the rate or room rate, competition, and demand greatly affect to sale of room. According to Peter Franz Renner in Sugiarto (2011: 52) the reservation for the hotel is a reservation made some time before, obtained by various sources and by various reservation methods to ensure that guests get a room at check in. RESEARCH METHOD The research conduted at Four Points by Sheraton Bali seminyak. The research using statistic descriptive analysis. Data was collect by observation, interview, and dokumentation. Data on this research is room night production of Four Points by Sheraton Bali Seminyak Hotel’s distribution channel. This research using Microsoft Excel for analysis. RESULTS AND DISSCUSION Four Points by Sheraton Bali Seminyak is the one of international hotel’s brand under Marriott International Management. Four points by Sheraton Bali Seminyak is four star hotel located at Petitenget street Gg. Cendrawasih No. 99DS, Seminyak. It has 121 rooms with various categories such as Deluxe Room, Deluxe Pool View, Deluxe Pool JASTH – Journal of Applied Sciences in Travel and Hospitality Vol. 1, No. 1, March 2018 27 Access, Junior Suite and Vasanti Suite. PT. Dewi Tirta Sejahterah owns Four Points by Sheraton Bali Seminyak Hotel, owned by Danie Kurniawan Sigianto. Offline travel agent is business partners that belong to retail business and wholesaler. Each offline travel agent has a Different contract rate agreement and special offer agreement to do sell and promotion and also has a different market with different customer’s behavior. Online travel agent is business partner that grouped into B2B. B2B is Commercial business methods that do by entrepreneur using online communication with the same goals. Agoda.com, Expedia, Booking.com and HotelBed are business partner of Four Points by Sheraton Bali Seminyak that do direct sell and promotion to customer by online communication using the internet and website. They have their own market, benefit and features for customer. It made the contribution of both travel agent is different with each other depend of their market, features, benefit, rate and special offer that offer by hotel to agent. Table 2 Offline travel agent’s contribution on 2015. (Source: result of data analysis using Microsoft Excel, 2018). Table 2 shows the contribution of offline travel agent by 2015, based on above table the mean of contribution of each travel agent has a different result. The table shows coorendon has a mean of contribution by 361,33 it is meaning the average contribution of Coorendon toward room occupancy by 12,90%, from 75,9% occupancy. Flight Center has a mean by 71,75 it is meaning the average contribution of Flight center toward room occupancy by 2,56% from 75,9% occupancy. GTA has mean by 34,83 it is meaning the average contribution of GTA to room occupancy by 1,24% from 75,9% occupancy. Mean 361,3333333 Mean 71,75 Mean 34,83333333 Mean 34,83333333 Standard Error 18,75493201 Standard Error 8,902778763 Standard Error 8,748881602 Standard Error 8,504752088 Median 365 Median 70 Median 29 Median 26 Mode 337 Mode #N/A Mode 36 Mode 9 Standard Deviation 64,96899027 Standard Deviation 30,84013029 Standard Deviation 30,30701489 Standard Deviation 29,46132544 Sample Variance 4220,969697 Sample Variance 951,1136364 Sample Variance 918,5151515 Sample Variance 867,969697 Kurtosis -1,077612744 Kurtosis 1,971579516 Kurtosis 1,620529682 Kurtosis 2,461832529 Skewness -0,117954391 Skewness 1,011220259 Skewness 1,326696205 Skewness 1,702901348 Range 200 Range 116 Range 105 Range 97 Minimum 262 Minimum 29 Minimum 1 Minimum 9 Maximum 462 Maximum 145 Maximum 106 Maximum 106 Sum 4336 Sum 861 Sum 418 Sum 418 GTA Thomas CookCoorendon Flight Center JASTH – Journal of Applied Sciences in Travel and Hospitality Vol. 1, No. 1, March 2018 28 Thomas Cook has mean by 34,83 it is meaning the average contribution of Thomas Cook to room occupancy by 1,24% from 75,9% occupancy. Table 3 Offline travel agent’s contribution on 2016. (Source: Result of data analysis using Microsoft Excel, 2018). Table 3 shows the contribution of offline travel agent by 2016, based on above table the mean of contribution of each travel agent has a different result. The table shows coorendon has a mean of contribution by 389,08 it is meaning the average contribution of Coorendon toward room occupancy by 13,57%, from 77,7% occupancy. Flight Center has a mean by 88,5 it is meaning the average contribution of Flight center toward room occupancy by 3,08% from 77,7% occupancy. GTA has mean by 134,5 it is meaning the average contribution of GTA to room occupancy by 4,69% from 77,7% occupancy. Thomas Cook has mean by 15,83 it is meaning the average contribution of Thomas Cook to room occupancy by 0,55% from 77,7% occupancy. Table 4 Offline travel agent’s contribution on 2017 (Source: Result of data analysis using Microsoft Excel, 2018). Mean 389,0833333 Mean 88,5 Mean 134,5 Mean 15,83333333 Standard Error 26,2009884 Standard Error 10,07208865 Standard Error 12,42340167 Standard Error 3,682129928 Median 396,5 Median 94,5 Median 130 Median 11,5 Mode #N/A Mode #N/A Mode #N/A Mode 11 Standard Deviation 90,76288622 Standard Deviation 34,89073855 Standard Deviation 43,0359258 Standard Deviation 12,75527223 Sample Variance 8237,901515 Sample Variance 1217,363636 Sample Variance 1852,090909 Sample Variance 162,6969697 Kurtosis -0,111490258 Kurtosis -1,124912438 Kurtosis 2,727063114 Kurtosis 3,660031469 Skewness -0,087591184 Skewness -0,379061015 Skewness 1,289879921 Skewness 1,758963545 Range 319 Range 103 Range 164 Range 47 Minimum 217 Minimum 34 Minimum 77 Minimum 2 Maximum 536 Maximum 137 Maximum 241 Maximum 49 Sum 4669 Sum 1062 Sum 1614 Sum 190 Coorendon Flight Center GTA Thomas Cook Mean 278,25 Mean 124,6666667 Mean 83,5 Mean 30,33333333 Standard Error 46,63837752 Standard Error 18,95142648 Standard Error 7,335571284 Standard Error 5,014121473 Median 261 Median 106,5 Median 71,5 Median 24 Mode #N/A Mode #N/A Mode 71 Mode 22 Standard Deviation 161,5600789 Standard Deviation 65,64966708 Standard Deviation 25,41116433 Standard Deviation 17,36942629 Sample Variance 26101,65909 Sample Variance 4309,878788 Sample Variance 645,7272727 Sample Variance 301,6969697 Kurtosis -0,888473534 Kurtosis -0,925287961 Kurtosis -0,033221727 Kurtosis -1,166887572 Skewness 0,457805638 Skewness 0,527911827 Skewness 1,199099145 Skewness 0,546648907 Range 497 Range 194 Range 76 Range 49 Minimum 54 Minimum 40 Minimum 58 Minimum 9 Maximum 551 Maximum 234 Maximum 134 Maximum 58 Sum 3339 Sum 1496 Sum 1002 Sum 364 Coorendon Flight Center GTA Thomas Cook JASTH – Journal of Applied Sciences in Travel and Hospitality Vol. 1, No. 1, March 2018 29 Table 4 shows the contribution of offline travel agent by 2017, based on above table the mean of contribution of each travel agent has a different result. The table shows coorendon has a mean of contribution by 278,25 it is meaning the average contribution of Coorendon toward room occupancy by 11,24%, from 67,9% occupancy. Flight Center has a mean by 124,66 it is meaning the average contribution of Flight center toward room occupancy by 5,03% from 67,9% occupancy. GTA has mean by 83,5 it is meaning the average contribution of GTA to room occupancy by 3,37% from 67,9% occupancy. Thomas Cook has mean by 30,33 it is meaning the average contribution of Thomas Cook to room occupancy by 1,22% from 67,9% occupancy. Table 5 Online travel agent contribution by 2015 (Source: result of data analysis using Microsoft Excel, 2018). Table 5 shows the contribution of offline travel agent by 2015, based on above table the mean of contribution of each travel agent has a different result. The table shows Agoda.com has a mean of contribution by 303,66 it is meaning the average contribution of Agoda.com toward room occupancy by 10,84%, from 75,9% occupancy. Booking.com has a mean by 352,75 it is meaning the average contribution of Booking.com toward room occupancy by 12,60% from 75,9% occupancy. Expedia has mean by 651 it is meaning the average contribution of Expedia to room occupancy by 23.25% from 75,9% occupancy. HotelBed has mean by 87,75 it is meaning the average contribution of HotelBed to room occupancy by 3,13% from 75,9% occupancy. Mean 303,666666666667Mean 352,75 Mean 651 Mean 87,75 Standard Error 22,4766994953 Standard Error 17,0525591254589Standard Error 46,5090411542843Standard Error 7,7421759137072 Median 307 Median 359 Median 667 Median 82 Mode 380 Mode #N/A Mode #N/A Mode 75 Standard Deviation77,8615710246348Standard Deviation59,0717976087343Standard Deviation161,112044581064Standard Deviation26,8196840873537 Sample Variance6062,42424242425Sample Variance3489,47727272727Sample Variance25957,0909090909Sample Variance719,295454545455 Kurtosis 0,276619216014661Kurtosis -0,249133706041189Kurtosis 2,15566692691446Kurtosis -0,897365363291861 Skewness -0,521011757507134Skewness -0,0954382141762623Skewness -1,1644712698804Skewness 0,348985099946464 Range 279 Range 210 Range 588 Range 82 Minimum 146 Minimum 249 Minimum 265 Minimum 50 Maximum 425 Maximum 459 Maximum 853 Maximum 132 Sum 3644 Sum 4233 Sum 7812 Sum 1053 Agoda.Com Booking.com Expedia HotelBed JASTH – Journal of Applied Sciences in Travel and Hospitality Vol. 1, No. 1, March 2018 30 Table 6 Online travel agent contribution by 2016 (Source: result of data analysis using Microsoft Excel, 2018. Table 6 shows the contribution of offline travel agent by 2015, based on above table the mean of contribution of each travel agent has a different result. The table shows Agoda.com has a mean of contribution by 288,66 it is meaning the average contribution of Agoda.com toward room occupancy by 10,07%, from 77,7% occupancy. Booking.com has a mean by 448,5 it is meaning the average contribution of Booking.com toward room occupancy by 15,65% from 77,7% occupancy. Expedia has mean by 599,66 it is meaning the average contribution of Expedia to room occupancy by 19,52% from 77,7% occupancy. HotelBed has mean by 88 it is meaning the average contribution of HotelBed to room occupancy by 3,07% from 77,7% occupancy. Table 7 Online Travel Agent Contribution by 2017 (Source: result of data analysis using Microsoft Excel, 2018). Mean 288,666666666667Mean 448,5 Mean 599,666666666667Mean 88 Standard Error 23,8439793980651Standard Error 32,9330128189532Standard Error 25,704124575679Standard Error 4,43471156521669 Median 253,5 Median 473 Median 613,5 Median 90 Mode 248 Mode #N/A Mode #N/A Mode 63 Standard Deviation82,5979675441487Standard Deviation114,083302897488Standard Deviation89,0416994583115Standard Deviation15,3622914957372 Sample Variance6822,42424242424Sample Variance13015 Sample Variance7928,42424242427Sample Variance236 Kurtosis -1,55457178325428Kurtosis -1,45909243839993Kurtosis -1,12948064775142Kurtosis -0,220846500047879 Skewness 0,299262344301418Skewness -0,302143693627153Skewness 0,0323367796051572Skewness -0,331289655600663 Range 233 Range 325 Range 275 Range 51 Minimum 176 Minimum 262 Minimum 474 Minimum 63 Maximum 409 Maximum 587 Maximum 749 Maximum 114 Sum 3464 Sum 5382 Sum 7196 Sum 1056 Agoda.com Booking.com Expedia HotelBed Mean 143,75 Mean 417,75 Mean 470,583333333333Mean 67,3333333333333 Standard Error 10,7238935997796Standard Error 45,4504600436763Standard Error 48,134196615695Standard Error 13,627252848686 Median 137 Median 457 Median 520,5 Median 61,5 Mode 137 Mode 491 Mode #N/A Mode #N/A Standard Deviation37,148657139562Standard Deviation157,445012046053Standard Deviation166,741748239787Standard Deviation47,2061886030237 Sample Variance1380,02272727273Sample Variance24788,9318181818Sample Variance27802,8106060606Sample Variance2228,42424242424 Kurtosis 0,422252198747891Kurtosis -1,48894012092773Kurtosis -1,19778939963467Kurtosis -0,728153035437281 Skewness -0,295148616599248Skewness -0,0156677072564372Skewness -0,506090500194833Skewness 0,672756132530257 Range 138 Range 444 Range 475 Range 144 Minimum 68 Minimum 199 Minimum 218 Minimum 10 Maximum 206 Maximum 643 Maximum 693 Maximum 154 Sum 1725 Sum 5013 Sum 5647 Sum 808 HotelBedExpediaBooking.comAgoda.com JASTH – Journal of Applied Sciences in Travel and Hospitality Vol. 1, No. 1, March 2018 31 Table 7 shows the contribution of offline travel agent by 2015, based on above table the mean of contribution of each travel agent has a different result. The table shows Agoda.com has a mean of contribution by 143,75 it is meaning the average contribution of Agoda.com toward room occupancy by 5,80%, from 67,9% occupancy. Booking.com has a mean by 509,16 it is meaning the average contribution of Booking.com toward room occupancy by 16,87% from 67,9% occupancy. Expedia has mean by 544,58 it is meaning the average contribution of Expedia toward room occupancy by 19,01% from 67,9% occupancy. HotelBed has mean by 67,33 it is meaning the average contribution of HotelBed to room occupancy by 2,71% from 64,9% occupancy. Figure 1 (Source: result of data analysis using Microsoft Excel, 2018). Based on figure 1, the higest contribution toward room occupancy of Four Points by Sheraton Bali Seminyak on 2015 of offline travel agent is Coorendon with average contribution by 361,33 with percentage by 12,90% and for online travel agent is Expedia by average contribution by 651 with percentage 23,25%. 12,90% 2,56% 1,24% 1,24% 10,84% 12,60% 23,25% 3,13% 8,20% Coorendon Flight Center GTA Thomas Agoda.com Booking.com Expedia HotelBed Others Percentage of travel agent contribution toward room occupancy JASTH – Journal of Applied Sciences in Travel and Hospitality Vol. 1, No. 1, March 2018 32 Figure 2 (Source: result of data analysis using Microsoft Excel, 2018). Based on above picture, the higest contribution toward room occupancy of Four Points by Sheraton Bali Seminyak on 2016 of offline travel agent is Coorendon with average contribution by 389,08 with percentage by 13,57% and for online travel agent is Expedia by average contribution by 599,66 with percentage 19,52%. Figure 3 (Source: result of data analysis using Microsoft Excel, 2018). Based on above picture, the higest contribution toward room occupancy of Four Points by Sheraton Bali Seminyak on 2017 of offline travel agent is Coorendon with 0,00% 5,00% 10,00% 15,00% 20,00% Coorendon Flight Center GTA Thomas Agoda.com Booking.com Expedia HotelBed Others 11,24% 5,03% 3,37% 1,22% 5,80% 16,87% 19,01% 2,71% 2,70% Percentage of travel agent contribution toward room occupancy on 2016 Percentase 13,57% 3,08% 4,69% 0,55% 10,07% 15,65% 19,52% 3,07% 7,50% 0,00% 5,00% 10,00% 15,00% 20,00% 25,00% Series1 Percentage of travel agent contribution toward room occupancy on 2016 JASTH – Journal of Applied Sciences in Travel and Hospitality Vol. 1, No. 1, March 2018 33 average contribution by 278,28 with percentage by 11,24% and for online travel agent is Expedia by average contribution by 470,58 with percentage 19,01%. CONCLUSION Based on the discussion and the results of the research in the previous chapter, it can be concluded that the offline and online travel agent has been distribution channel with highest contribution to Four Points by Sheraton Bali Seminyak on 2015-2017. Contribution of travel agent such as coorendon by 37,71% flight center by 10,67% GTA by 9,3% Thomas Cook by 3,01% Agoda.com by 26,35 Booking.com by 45,18% Expedia by 61,78% and HotelBed by 8,21%. The highest contribution of travel agent by 2015- 2017 dominated by online travel agent, it is Expedia with total contribution by 61,78% and offline travel agent dominated by Coorendon with total contribution by 37,71. There are travel agents with low contribution such as HotelBed, Thomas Cook, and GTA. Hotel should keep the great relationship with their partner and make a new contract rate agreement to increase their contribution. And also offer the special package for their market. REFERENCES Adi Yanti Putri, Ni Made. 2014. Pengaruh Biro Perjalanan Wisata Sebagai Saluran Distribusi Terhadap Tingkat Hunian Kamar Pada Hotel All Season Legian Bali.Jurnal. Fakultas Pariwisata UNUD Hanief, Shofyan; Pramana, Dian. 2017. Pengembangan Bisnis pariwisata Dengan Sistem Informasi. Yogyakarata : Penerbit Andi. Putri, Emmita Devi Hari. 2016. Pengantar Akommodasi dan Restoran. Yogyakarta : Deepublish. Sugiarto, Endar. 2004. Hotel Front Office Administration. Jakarta: PT. Gramedia Pustaka Utama Sugiyono, 2014. Metode Penelitian Kuantitatif Kualitatif Dan R&D. Bandung: Alfabeta.