Matching Consignees/Shippers Recommendation System in Courier Service Using Data Analytics

The purpose of this research was to create a Matching Consignees/Shippers Recommendation System (MCSRS). We used the association rule to identify product associations, the clustering technique to group shippers and consignees according to behaviors when receiving goods from similar shipper groups, and the decision tree to identify possible matches between shippers and consignees. Finally, Monte Carlo simulation was used to estimate potential revenue. The case study is a courier company in Thailand. The results showed that garment products and clothes were the products with the highest association. Shippers and consignees of these products were segmented according to recency, frequency, monetary factors, number of customers, number of product items, weight, and day. Three rules are proposed that enabled the assignment of 8 consignees to 56 shippers with an estimated increase in revenue by 36%. This approach helps decision-makers to develop an effective cost-saving new marketing, inclusive strategy quickly.

[1]  Saeid Eslami,et al.  An assessment of the risk factors for vitamin D deficiency using a decision tree model. , 2019, Diabetes & metabolic syndrome.

[2]  Valerij Dermol,et al.  Predicting students’ satisfaction using a decision tree , 2019, Tertiary Education and Management.

[3]  AgrawalRakesh,et al.  Mining association rules between sets of items in large databases , 1993 .

[4]  Ismail Hakki Toroslu,et al.  Data Mining Approach for Direct Marketing of Banking Products with Profit/Cost Analysis , 2017, Rev. Socionetwork Strateg..

[5]  Osama Abu Abbas,et al.  Comparisons Between Data Clustering Algorithms , 2008, Int. Arab J. Inf. Technol..

[6]  Ying LU,et al.  Decision tree methods: applications for classification and prediction , 2015, Shanghai archives of psychiatry.

[7]  Sunil Erevelles,et al.  Big Data consumer analytics and the transformation of marketing , 2016 .

[8]  I-En Liao,et al.  An improved frequent pattern growth method for mining association rules , 2011, Expert Syst. Appl..

[9]  Kiyana Zolfaghar,et al.  Estimating customer lifetime value based on RFM analysis of customer purchase behavior: Case study , 2011, WCIT.

[10]  Hsiao-Ping Tsai,et al.  Group RFM analysis as a novel framework to discover better customer consumption behavior , 2011, Expert Syst. Appl..

[11]  Nils Boysen,et al.  Matching supply and demand in a sharing economy: Classification, computational complexity, and application , 2019, Eur. J. Oper. Res..

[12]  Li-Yen Shue,et al.  Business intelligence approach to supporting strategy-making of ISP service management , 2008, Expert Syst. Appl..

[13]  Alexandre Villeminot,et al.  Combined use of association rules mining and clustering methods to find relevant links between binary rare attributes in a large data set , 2007, Comput. Stat. Data Anal..

[14]  Mao-Jiun J. Wang,et al.  Using decision tree-based data mining to establish a sizing system for the manufacture of garments , 2005 .

[15]  Jyh-Jian Sheu,et al.  The associate impact of individual internal experiences and reference groups on buying behavior: A case study of animations, comics, and games consumers , 2017, Telematics Informatics.

[16]  Josep Blat,et al.  Urban association rules: Uncovering linked trips for shopping behavior , 2016, ArXiv.

[17]  Qibei Lu,et al.  Personalized information recommendation model based on context contribution and item correlation , 2019, Measurement.

[18]  Proprietary Costs and the Disclosure of Information About Customers , 2012 .

[19]  You-Shyang Chen,et al.  Classifying the segmentation of customer value via RFM model and RS theory , 2009, Expert Syst. Appl..

[20]  Chao-Ton Su,et al.  An innovative service quality evaluation and improvement model , 2018 .

[21]  Hsin-Hung Wu,et al.  Analyzing Patients' Values by Applying Cluster Analysis and LRFM Model in a Pediatric Dental Clinic in Taiwan , 2014, TheScientificWorldJournal.

[22]  Duen-Ren Liu,et al.  A hybrid of sequential rules and collaborative filtering for product recommendation , 2009, Inf. Sci..

[23]  Ruimin Hu,et al.  Comprehensive Association Rules Mining of Health Examination Data with an Extended FP-Growth Method , 2017, Mob. Networks Appl..

[24]  Soung Hie Kim,et al.  Mining the change of customer behavior in an internet shopping mall , 2001, Expert Syst. Appl..

[25]  Mahdi Hasanipanah,et al.  Risk Assessment and Prediction of Flyrock Distance by Combined Multiple Regression Analysis and Monte Carlo Simulation of Quarry Blasting , 2016, Rock Mechanics and Rock Engineering.

[26]  Patrick Olivier,et al.  Recommender system based on pairwise association rules , 2019, Expert Syst. Appl..

[27]  Victor Platon,et al.  Monte Carlo Method in Risk Analysis for Investment Projects , 2014 .

[28]  Yen-Liang Chen,et al.  Discovering recency, frequency, and monetary (RFM) sequential patterns from customers' purchasing data , 2009, Electron. Commer. Res. Appl..

[29]  Kamran Rezaie,et al.  Using extended Monte Carlo simulation method for the improvement of risk management: Consideration of relationships between uncertainties , 2007, Appl. Math. Comput..

[30]  Kuanchin Chen,et al.  Predicting customer churn from valuable B2B customers in the logistics industry: a case study , 2015, Inf. Syst. E Bus. Manag..

[31]  J. R. Bult,et al.  Optimal Selection for Direct Mail , 1995 .

[32]  Mu-Chen Chen,et al.  Mining changes in customer behavior in retail marketing , 2005, Expert Syst. Appl..

[33]  David L. Olson,et al.  Comparison of customer response models , 2009 .

[34]  D. Dougherty.  A PRACTICE-CENTERED MODEL OF ORGANIZATIONAL RENEWAL THROUGH PRODUCT INNOVATION , 1992 .

[35]  Byung Rae Cho,et al.  Development of a Scaling Factor Identification Method Using Design of Experiments for Product-Family-Based Product and Process Design , 2002 .

[36]  Jian Pei,et al.  Mining frequent patterns without candidate generation , 2000, SIGMOD 2000.

[37]  Maryam Tayefi,et al.  The application of a decision tree to establish the parameters associated with hypertension , 2017, Comput. Methods Programs Biomed..

[38]  Wan-Ting Tseng,et al.  The Application of Data Mining Techniques to Oral Cancer Prognosis , 2015, Journal of Medical Systems.

[39]  John A. McCarty,et al.  SEGMENTATION APPROACHES IN DATA MINING: A COMPARISON OF RFM, CHAID, AND LOGISTIC REGRESSION , 2007 .

[40]  Thomas R. Rohleder,et al.  Combining Operations and Marketing to Manage Capacity and Demand in Services , 2001 .

[41]  A. Umamakeswari,et al.  RFM ranking - An effective approach to customer segmentation , 2018, J. King Saud Univ. Comput. Inf. Sci..

[42]  Seyed Mohammad Seyedhosseini,et al.  Cluster analysis using data mining approach to develop CRM methodology to assess the customer loyalty , 2010, Expert Syst. Appl..

[43]  Chia-Chen Chang,et al.  Mining customer knowledge for exploring online group buying behaviour , 2012, Expert Syst. Appl..

[44]  Kun Guo,et al.  Data mining for the online retail industry: A case study of RFM model-based customer segmentation using data mining , 2012 .

[45]  Chu-Chai Henry Chan,et al.  Intelligent value-based customer segmentation method for campaign management: A case study of automobile retailer , 2008, Expert Syst. Appl..

[46]  Krittipat Pitchayadejanant,et al.  Data mining approach for arranging and clustering the agro-tourism activities in orchard , 2018, Kasetsart Journal of Social Sciences.

[47]  Chun-Che Huang,et al.  Qualitative analysis of big data in the service sectors , 2018, The Service Industries Journal.

[48]  Anand Shanker Tewari,et al.  Sequencing of items in personalized recommendations using multiple recommendation techniques , 2018, Expert Syst. Appl..

[49]  Mohamed Fakir,et al.  Application of Data Mining in e-Commerce , 2014, J. Inf. Technol. Res..