Proceedings of the International Conference on Sustainable Green Tourism Applied Science - Social Applied Science 2025 (ICOSTAS-SAS 2025)

Creation of Occupancy Rate Calculation Application to Support Hospitality Business Mathematics Learning

Authors
Layla Fickri Amalia1, *, Putu Gita Suari Miranti1
1Department of Tourism, Politeknik Negeri Bali, Bali, Indonesia
*Corresponding author. Email: fickriamalia@pnb.ac.id
Corresponding Author
Layla Fickri Amalia
Available Online 14 November 2025.
DOI
10.2991/978-94-6463-882-0_22How to use a DOI?
Keywords
Calculation Application; Occupancy Rate; T-Test
Abstract

Occupancy rate is a very important calculation in the hospitality industry. With the right occupancy rate calculation, hotel industry players can manage their business to maximize profits. In the hospitality study program, many students have school backgrounds with non-exact majors. Students with non-exact educational backgrounds tend to have difficulty learning to understand basic mathematical operations. Meanwhile, hospitality study program students must have the ability to calculate occupancy rates correctly. To minimize errors in occupancy rate calculations, this study developed a VBA-based macro application for this purpose. This calculation tool has been socialized in business mathematics as a learning medium. With this tool, it is hoped that there will be no errors in calculating the occupancy rate, so that it can manage hotel resources appropriately. This calculation was applied in a business mathematics class, followed by a paired t-test. The results of the paired t-test revealed a significant difference between students’ calculations using manual formulas and those made using applications, with the latter showing slight mistakes.

Copyright
© 2025 The Author(s)
Open Access
Open Access This chapter is licensed under the terms of the Creative Commons Attribution-NonCommercial 4.0 International License (http://creativecommons.org/licenses/by-nc/4.0/), which permits any noncommercial use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license and indicate if changes were made.

Download article (PDF)

Volume Title
Proceedings of the International Conference on Sustainable Green Tourism Applied Science - Social Applied Science 2025 (ICOSTAS-SAS 2025)
Series
Advances in Social Science, Education and Humanities Research
Publication Date
14 November 2025
ISBN
978-94-6463-882-0
ISSN
2352-5398
DOI
10.2991/978-94-6463-882-0_22How to use a DOI?
Copyright
© 2025 The Author(s)
Open Access
Open Access This chapter is licensed under the terms of the Creative Commons Attribution-NonCommercial 4.0 International License (http://creativecommons.org/licenses/by-nc/4.0/), which permits any noncommercial use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license and indicate if changes were made.

Cite this article

TY  - CONF
AU  - Layla Fickri Amalia
AU  - Putu Gita Suari Miranti
PY  - 2025
DA  - 2025/11/14
TI  - Creation of Occupancy Rate Calculation Application to Support Hospitality Business Mathematics Learning
BT  - Proceedings of the International Conference on Sustainable Green Tourism Applied Science - Social Applied Science 2025 (ICOSTAS-SAS 2025)
PB  - Atlantis Press
SP  - 187
EP  - 193
SN  - 2352-5398
UR  - https://doi.org/10.2991/978-94-6463-882-0_22
DO  - 10.2991/978-94-6463-882-0_22
ID  - Amalia2025
ER  -