Development of a Tour Package Pricing Calculation Method Using the ROUNDUP Function in Microsoft Excel

Abstract

Accurate and efficient tour package price calculation is one of the key factors in supporting the competitiveness of the travel and tourism industry. Manual calculation processes, which are still widely used by travel agencies, are often time-consuming, prone to errors, and difficult to modify when there are changes in cost components and the number of tourists. This study aims to develop a more effective method for calculating tour package prices through the utilization of the ROUNDUP function in Microsoft Excel. The method employed in this study is Research and Development (R&D) using the ADDIE model, which consists of the stages of Analysis, Design, Development, Implementation, and Evaluation. The results of the study indicate that the Excel template based on the ROUNDUP function is capable of simplifying formula structures by up to 60% compared to manual methods, making them easier to modify and reducing calculation processing time. Expert validation yielded a score of 95%, categorized as highly feasible. The implementation of this template has proven effective in improving work efficiency for travel agency administrators, accelerating the pricing preparation process, and minimizing the risk of pricing calculation errors. Therefore, this template can serve as a practical solution for enhancing work productivity in the tourism industry.