Routing for tourist and excursion bureaus based at parametric network models

This study is devoted to applying parametric network models for the process of defining a guided tour route within route networks on the example of Denmark. This is caused by difficulty in determining variations when organizing guided tours. Under the actual digitization conditions, tourist and excursion bureaus are being restructured from static organizations administering various excursions into dynamic ones. They are actually getting adjusted to the customers’ needs and demands, taking into account the actual possibilities for covering a certain topic by the tour party within a route. The main problem encountered by tourist and excursion bureaus is the following. Although the nomenclature of presented guided tours is established by the economic entity independently, those are not always carried out according to a clearly defined itinerary and on the same conditions for all participants. When providing such services, customers’ demands and service peculiarities are not known in advance. The purpose of the present study is to provide a substantive basis for routing in tourist and excursion bureaus, based on parametric network models and taking into account the peculiarities of dynamically adaptable tables containing the best routes. To achieve the research goal, network planning methods were used, such as analytical, tabular, cloud computing in the AnyLogic Cloud environment. As a result of the study, a substantive basis of routing of the tourist route was presented for tourist and excursion bureaus, through their parametric network models. The study was implemented at the sample of the Denmark Tour -Your Guide Office, a company founded within cooperation with Russian, Ukrainian, and Denmark partners and providing travel services within the Denmark tourist market. The Office includes about 20 affiliates in Denmark, where route networks have already been adapted to designing tours in practice and parameterization of such networks is well underway, in particular by shifting the focus from the route distance rate to minimization of transfers between attraction sites. However, to provide a substantive basis for the routing in a tourist office, parameters of the routing networks should be determined not only based on the list of actions (activities) to be carried out, but also on their minimum and maximum possible duration. A lack of due attention to the servicing time for the tour groups will lead to breaking tour schedules. Thus, in 2020, as a result of the inefficient parameterization at Denmark Tour - Your Guide, about 5-6 tours around Aalborg and its vicinity were cancelled monthly. Denmark Tour- Your Guide incurs monthly profit losses at 15% in 4-6 tours around Aarhus and its surroundings, Jursland peninsula, rated at a fixed cost, as the result of payment of a fixed cost for the selected excursions. A similar situation, with breaking tour schedules and monthly losses incurred, is common with tourist and excursion bureaus in various countries around the world, including Ukraine. According to the results of the study, it is marked that the routing of tourist itineraries designed by tourist agencies, based on parametric network models turns their static time reserves and operational metrics into dynamic values depending on the duration of the tour activities. This not only ensures following schedules properly in all tours but also minimizes monthly profit loss, at an estimated EUR 2,250 for the Aalborg and its surroundings routes. Meanwhile, there may be situations where it is not possible to change the total tour cost. For example, in the company Denmark Tour - Your Guide, when working with intermediate parties, this price is fixed. To prevent incurring monthly losses within 15% of the profits for 4-6 tours of Aarhus and its surroundings, Jursland peninsula, Aalborg and Surroundings, it is necessary to make some quite specific adjustments in some activities at the sites. These should take into account the time reserve values on the longest route. A special tour activity complex is to be completed, with a maximum difference in early and late schedule times, standard and urgent pricing for the site operations). A procedure is compiled for minimizing losses in routes (over 8K euro annually), providing for completion of the activity complex within the schedule with a minimum additional charge to the operating metric (the route price), since it is not reimbursed by the tourists. It is important that the results presented should identify the path adjustments of each route simultaneously, taking into account the actual time reserve (available based on the tour group location and the previouisly completed schedule items on the tour). Prospects for practical implementation of the presented substantiation basis for the itinerary routing to be used in tourist and excursion bureaus, based on parametric network models, are in establishing facilities for creating dynamic graphic images of the whole tour procedure, in the form of a directed graph of the route network.