Vehicle Scheduling for Tourism Routing Problem

The research aims to determine proper vehicle routes and travelling schedules, for tourism management, in order to minimize the total system cost composed of transportation cost, vehicle cost, and driver cost. A mathematical model based on two-phase problem solving is developed. The first phase is to determine the sequence of visiting places for each tour program in such a way that the travelling distance is minimized, and the operating time constraint of each visiting place is not violated. The second phase is to assign proper types and number of travelling vehicles for each tour program. The developed model is constructed on the spreadsheet and solved using the solver. The result obtained from the company of case study, a tourism company located in the North of Thailand, shows that the proposed method provides practical solutions in the real situation.