Mahidol University Logo
Faculty of ICT, Mahidol University
 

Admissions

Printable Version

 

AN ANALYTICAL CRM SYSTEM FOR VAT REFUND FOR TOURISTS

 

TITLE AN ANALYTICAL CRM SYSTEM FOR VAT REFUND FOR TOURISTS
AUTHOR SOMJAI SAMOEMUAN
DEGREE MASTER OF SCIENCE PROGRAMME IN COMPUTER SCIENCE
FACULTY FACULTY OF SCIENCE
ADVISOR SONGSRI TANGSRIPAIROJ
CO-ADVISOR CHARNYOTE PLUEMPITIWIRIYAWEJ
 
ABSTRACT
VAT refund for Tourists (VRT), supervised by the Revenue Department, is a tax collection policy that supports Thai government policy to promote tourism. There are three main problems of the existing VRT system. First, making a manual report takes a long time. Second, these is only a small number of entrepreneurs and shops in the VRT system. Third, the officers in the VAT refund for tourists team (KOR-TOR) are lacking an efficient tool for analyzing goods purchase behavior in order to find new groups of VAT taxpayers that should join the VRT system. In this research project an Analytical Customer Relationship Management System for VAT Refund for Tourists (ACRM-VRT) has been designed and developed by applying the notion of customer relationship management (CRM), data warehousing, OLAP, and data mining. The data mart is built for collecting the data for VAT refund for Tourists. The OLAP tool is developed to support the KOR-TOR work, especially for reporting and generating executive summaries. The Data mining tool, particularly an association rule mining tool, is created for studying tourist’s goods purchase behavior to search for new groups of VAT taxpayers who sell the products that meet tourists’ requirements. The ACRM-VRT system is evaluated in the aspect of user satisfaction by the KOR-TOR officers. The overall results show that the user satisfactory level is good. The function that has the highest satisfactory level is the data mining tool. This is because the obtained knowledge can be used for specifying the strategies to search new groups of VRT taxpayers and facilitate the VRT system to recruit them into the system. Moreover, the obtained knowledge can be used for advertising to the VRT taxpayers in order to make tourist marketing plans. The VAT taxpayers who did not yet apply to the VRT system might be interested and volunteer to join the VRT system.
KEYWORD CUSTOMER RELATIONSHIP MANAGEMENT/ DATA MART/ ONLINE ANALYTICAL PROCESSING/ ASSOCIATION RULE MINING/ VAT REFUND FOR TOURISTS

 

 

Go to Top

 

ICT Building, Mahidol University, 999 Phuttamonthon 4 Road, Salaya, Nakhonpathom 73170 Tel. +66 02 441-0909 Fax. +66 02 849-6099
Mahidol University Computing Center, The Faculty of ICT, Mahidol University , Rama 6 Road, Rajathevi, Bangkok 10400 Tel. +66 02 354-4333 Fax. +66 02 354-7333