Forecasting average room rate using k-nearest neighbor at Hotel S

Vaizal Asy'ari, Mohamad Yusak Anshori, Teguh Herlambang*, Imam Wahyudi Farid, Denis Fidita Karya, Mukhtar Adinugroho

*Corresponding author for this work

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

Abstract

In managing a hospitality business, it takes a lot of data and analysis to make the right decisions. One important indicator in assessing the performance of a hotel is the Average Room Rate (ARR) which shows the average price of rooms sold by the hotel in a certain period. From the ARR data obtained, it can make a picture of the future regarding expansion to increase the value of ARR in the future. In this study, ARR forecasting was carried out for Hotel S using the k-nearest neighbor (k-NN) method. The dataset used in this study is in the form of room sold out, room revenue, and average room rate at Hotel S from April 2018 to June 2023. The simulation was carried out by dividing the data into training data and testing data with a ratio of 70:30 and 80:20, and the selection of k-values are 3 to 7. The forecasting results that have been carried out using k-NN for split data 70%:30% produce an optimal RMSE of 6,335 at k-values is 3. The forecasting results that have been carried out using k-NN for 80%:20% data split produce an optimal RMSE of 7,452 at k-values is 5. From this comparison, the results of forecasting ARR using k-NN obtained the best RMSE of 6,335. The results of this study can be used by Hotel S in determining the price of various types of rooms that are appropriate and expected to provide benefits for management.

Original languageEnglish
Title of host publication2023 International Conference on Advanced Mechatronics, Intelligent Manufacture and Industrial Automation, ICAMIMIA 2023 - Proceedings
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages496-500
Number of pages5
ISBN (Electronic)9798350309225
DOIs
Publication statusPublished - 2023
Externally publishedYes
Event2023 International Conference on Advanced Mechatronics, Intelligent Manufacture and Industrial Automation, ICAMIMIA 2023 - Lombok, Indonesia
Duration: 14 Nov 202315 Nov 2023

Publication series

Name2023 International Conference on Advanced Mechatronics, Intelligent Manufacture and Industrial Automation, ICAMIMIA 2023 - Proceedings

Conference

Conference2023 International Conference on Advanced Mechatronics, Intelligent Manufacture and Industrial Automation, ICAMIMIA 2023
Country/TerritoryIndonesia
CityLombok
Period14/11/2315/11/23

Keywords

  • average room rate
  • forecasting
  • hotel
  • k-nearest neighbor

Fingerprint

Dive into the research topics of 'Forecasting average room rate using k-nearest neighbor at Hotel S'. Together they form a unique fingerprint.

Cite this