Automated Hotel Booking and Cancellation Web-Based Application: A Prototype

Michael G. Albino; Cyrel B. Alvarez; Shermaine B. Murillo; Aubrey Jaye S. Tuzon; Kris Danica P. Paña

PDF Downloads: 206

Open Access - Download full article:

Automated Hotel Booking and Cancellation Web-Based Application: A Prototype

Michael G. Albino^*, Cyrel B. Alvarez, Shermaine B. Murillo, Aubrey Jaye S. Tuzon and Kris Danica P. Paña

President Ramon Magsaysay State University, Philippines.

Corresponding Author E-mail: malbino0203@gmail.com

DOI : http://dx.doi.org/10.13005/ojcst15.010203.05

Article Publishing History
Article Received on : 11 Oct 2022
Article Accepted on : 31 Oct 2022
Article Published : 04 Nov 2022
Plagiarism Check: Yes
Reviewed by: Dr. Nagsen Bansod

Second Review by: Dr. Anil V. Turukmane

Final Approval by: Dr. Froilan D. Mobo

Article Metrics

ABSTRACT:

The purpose of this study is to provide new insights into the factors that influence cancellation behaviour with respect to hotel bookings. Cancellations of bookings are one of the most common concerns in the hotel sector. Before the specified arrival date, the client would cancel their reservation. The cancellation has had a major impact on hotel operations as well. The researchers developed a prototype system called Automated Hotel Booking Cancellation that can assist a hotel in better anticipating consumer cancellations and booking transactions. The researchers utilized a survey questionnaire following the ISO 25010 Software Quality Standard to assess the system's usefulness, functionality, accuracy, security, reliability, and maintainability. The results show "strongly agree" in all the domains with an overall mean = 3.46. IT Experts and respondents evaluated the proposed prototype and gained a "Strongly Agree" rating in all the domains under the survey. The domain on the usefulness of the system gained the highest mean = 3.89 with an interpretation of "strongly agree," and the lowest was the domain of security with a mean = 3.15 or "strongly agree," which ranked 6 in summary.

The researchers concluded based on the findings that the developed prototype web-based system was useful and functional to the needs of the target users/beneficiaries. The user interface of the web-based system was user-friendly, representing an object-oriented user interface for the users. An improvement recommended on the cancellation to automatically predict cancellations that can be incorporated into the system using Machine Learning Algorithms to ease the process of cancellation were recommended for future researchers who want to pursue advanced studies about the topic.

KEYWORDS: Automated hotel booking cancellation; ISO 25010; web-based application;

Copy the following to cite this article:

Albino M. G, Alvarez C. B, Murillo S. B, Tuzon A. J. S, Paña K. D. P. Automated Hotel Booking and Cancellation Web-Based Application: A Prototype. Orient.J. Comp. Sci. and Technol; 15(1,2,3).

Copy the following to cite this URL:

Albino M. G, Alvarez C. B, Murillo S. B, Tuzon A. J. S, Paña K. D. P. Automated Hotel Booking and Cancellation Web-Based Application: A Prototype. Orient.J. Comp. Sci. and Technol; 15(1,2,3). Available from: https://bit.ly/3zIfz7l

Introduction

The coronavirus pandemic has affected so many people, including travel enthusiasts who booked their trips long before an enhanced community quarantine (ECQ) was imposed in the Philippines ¹. Apart from flight cancellations and suspended operations of travel-related services, hotel chains have also been shut down. Many guests postpone and cancel their bookings due to the outbreak. In the meantime, they are upholding their commitment to bring light to everyone by sending emails on self-care, sharing positive messages on Instagram with the help of their wellness practitioners, and providing wellness resources for guests through their website ².

Marriott Hotel Manila Customers who booked a room at Marriott Hotel Manila within the enhanced community quarantine are allowed to cancel or make changes to their reservation by June 30, 24 hours before their arrival date. While the management is updating their website regularly in line with their availability and exclusions, they have decided not to accept bookings, for now, to keep their guests and employees safe from coronavirus. [6] stated as it has always been, the safety and security of our guests and team members remain our highest priority,” Hilton Manila said in a statement, adding that they have strengthened their operating protocols by increasing the number of their cleaning agents and making sure their public areas are sanitized regularly ³.

Other than offering refunds to those affected by the current situation, they also allow free cancellations of reservations made before June 30, 24 hours before their slated arrival. This can also be applied to bookings labeled as “non-cancellable.” For further assistance, Hilton Manila can be contacted at their contact support page or global support numbers ⁴.

As the Corona Virus spreads over the globe. The hotel business has been one of the industries that will be impacted. Many hotels and restaurants have chosen to close their doors due to the epidemic, which is also required. They don’t want to be infected with the virus that has been spoken of. ¹ stated that various hotels have recently opened in Zambales to maintain their operations. Nevertheless, the main problem within Zambales is that they’re not experienced with online cancellation and rather depend on physical cancellation ⁵.

Booking cancellations already have a well-known body of knowledge in the scope of revenue management applied to service industries, particularly the hospitality industry. Nevertheless, in recent years, with the increasing influence of the internet on the way customers search and buy travel services ^{1; 6; 12} research revealed that the topic related to controls used to mitigate the effects of cancellations in revenue and inventory allocation, cancellation policies and overbooking ^10,13;17. Nevertheless, there are few kinds of literature on the subject of booking cancellation forecasts for the hospitality industry.

This work takes advantage of advanced data science methods to synthesize the current research findings on the development of forecast/prediction models for booking cancellation in the hotel and tourism-related industries and to identify the main topics covered by booking cancellation research
¹. To guide the researchers in developing the web-based application and to determine the efficiency of the proposed system, the researchers were conducted by the research paradigm as presented in Figure 1.

Figure 1: Conceptual Framework

Click here to View Figure

The researchers gathered necessary data from the internet through literature reviews and studies. Information gathered was used by the researchers to give them an idea about how to develop the hotel cancellation web-based system and its target beneficiaries. The respondents were identified based on their characteristics and relevance to the function of the proposed system. After all the data collection undertakings, the researchers developed a web-based system and deployed a cancellation procedure within the system. Testing of the system while the development is undergoing, beta and alpha testing was done. The identified features were also identified through the testing. As an output, the researchers successfully developed the prototype web-based system with cancellation on hotel booking and underwent a survey to determine its efficiency in the processes.

This research paper aims to discuss the proposed Automated Hotel Booking and Cancellation Web-based Application and determine its usefulness, functionality, accuracy, security, reliability, and maintainability from the survey instrument used by the researchers. This research paper discusses the software development methodology used and the design or interface of the proposed system.

Research Objectives

The general objective of this study was to monitor the client’s reservation of the hotel room booked. An automated system was proposed by the researchers to automatically secure and cancel clients’ bookings based on the hotel businesses’ existing policies. Also, the research paper was guided by the following specific research objectives:

To develop a prototype automated hotel booking and cancellation web-based system based on the requirement and specifications of the beneficiaries;

To design a user-friendly interface that users can automatically use the system without being computer literate; and

To evaluate the proposed web-based system based on ISO 25010 software quality standards in terms of:

Usefulness;

Functionality;

Accuracy;

Security;

Reliability; and

Maintainability.

Material and methods

To make the hotel management work systematic, standardization and automation achieve the aim of improving the efficiency of hotel guest room management. This paper used a mixed-method research design. An applied method was used in designing the hotel management system; the overall mission of system development was to make the office staff quickly and easily complete the hotel guest room management task. The researchers also used a survey questionnaire to identify the efficiency of the developed system based on ISO 25010 Software Quality Standards. The researchers also chose a software development methodology to guide the prototype system’s development and deployment.

To select the target beneficiaries of the prototype system, the researchers used the purposive sampling technique. The selected respondents are the executive and employees of a hotel company in Zambales and Olongapo City, Philippines. The respondents selected private hotels in specific based on the purpose of the developed web-based system. The respondents were twenty-five (25) hotel owners, managers, staff, and clients and five (5) IT experts, with a total of thirty (30) respondents participating in the survey.

The researchers also used the researcher instrument to determine the efficiency of the proposed web-based system. The instrument was adapted from the ISO 25010 Software Quality Standards with minor revisions. The domain of the instrument was usefulness, functionality, accuracy, security, reliability, and maintainability. The researchers checked the validity and reliability of the survey instrument through Cronbach Alpha testing, with yielded an overall alpha test result of .72, which is higher than the benchmark value of >.70 to be valid and acceptable.

The researchers also used statistical tools after gathering the data from the respondents after the survey. Weighted mean and Likert scale with a 4-point agreement scale was used by the researchers to analyze the result of the survey.

System Development and Methodology

Agile is the approach adopted by the researchers for this study. The goal of this software development methodology was to ensure that the development of the web-based system conforms with the standards and quality of a hotel booking system and to fasten the development without considering the proposed prototype’s efficiency. The agile prototyping methodology is presented in Figure 2.

Figure 2: Agile Prototyping

Click here to View Figure

Requirement Analysis

The researchers and target users worked closely together to develop device requirements and specifications. The researchers gathered necessary data from the beneficiaries about the process of booking and the policy on the cancellation of bookings.

Design

The researchers created a prototype system at this point. The prototype system was designed based on the specifications given by the target beneficiaries. The user interface was evaluated by IT experts to determine the correctness and user-friendliness of the UI.

Development

At this point, the developers now started to develop both the interface and the database of the prototype system. The database used an entity-relational model to determine the relationship of each entity in the design and to normalize the data input and output of the system.

Quality Assurance

During development, quality assurance personnel reviewed and tested the system to assure its quality and minimize any faults. During this step, the developers automatically corrected system faults. Based on the data gathered from the IT experts who tested the system, minimal errors and corrections were suggested and automatically corrected by the developers.

Deployment

In this stage, the developed prototype was ready to deploy and be tested by the target beneficiaries. The hotel owners, managers, staff, and clients tested the proposed prototype. During the deployment, the survey instructions were also administered to determine the efficiency of the system.

Results and Discussion

The main objective of this research paper was to develop and propose a prototype web-based hotel booking and cancellation system for hotel owners. The researchers conducted a survey to determine the efficiency of the proposed system based on the ISO 25010 software quality standards. The results of the survey were presented in the following discussions. The respondents in hotel business establishments (25) rated the survey, and (5) IT experts with a total of (30) respondents.

Table 1: Automated Hotel Booking and Cancellation Web-based Application: A Prototyping as Evaluated metrics as to Usefulness Towards System Quality

Question	Weighted Mean	Interpretation
The system is accessible.	3.87	Strongly Agree
The system easily processes reservation transaction.	3.94	Strongly Agree
The system enables a better deal for assured accommodation.	3.87	Strongly Agree
Overall Weighted Mean	3.89	Strongly Agree

Legend : 3.26 – 4.00 (Strongly Agree); 2.51 – 3.25 (Agree); 1.76 – 2.50 (Disagree); 1.00 -1.75 (Strongly Disagree

Table 1 presents the results of the evaluation of the usefulness of the web-based system. The respondents’ evaluation revealed that the system is accessible with a mean=3.87 or “strongly agree,” the process of reservation is easy with a mean = 3.94 or “strongly agree,”; and the accommodation of the system is better with a mean = 3.87 or “strongly agree”. The proposed system gained a total mean = 3.89 or “strongly agree,” indicating that the system is useful and processes conform to the needs of the users.

Table 2:Automated Hotel Booking and Cancellation Web-based Application: A Prototyping as Evaluated metrics as to Functionality Towards System Quality

Question	Weighted Mean	Interpretation
1. The system is user friendly	3.90	Strongly Agree
2. The system provides necessary operations needed by the user.	3.37	Strongly Agree
3. The system updates hotel rooms status information.	3.70	Strongly Agree
Overall Weighted Mean	3.66	Strongly Agree