Development of Transportation Notification and On line Report : a case study of Tharathong Metal Co ., Ltd

Abstract

The objective of this research is to design and develop an online transportation notification and reporting system. This will be achieved by studying and collecting current operational data to create a current workflow diagram, analyzing the root causes of problems to implement process improvements using the Why Why analysis, and creating swim lane diagrams before and after the improvement to illustrate the flow of transportation information. Google Workspace and Google Apps Script will be utilized to record and store transportation data, real-time transportation status notifications will be provided via the LINE application, and delivery in full on time report will be generated in the form of an online dashboard using Looker Studio. The results of the research made it possible to reduce the waiting time for employees to report the transportation status from the original 5 hours down to 2 seconds, representing a reduction of 17,998 seconds or a reduction of 99.99 percent. It is also possible to summarize and report the delivery of goods in Overall and individual. At the same time, the satisfaction of 2 groups of users of the system was evaluated: the data recording group, which is transportation employees, and the data data group, which is transportation department executives. Satisfaction evaluation results found that The data recorder group had the highest level of overall satisfaction (Mean±S.D. = 4.43±0.53) and the data user group had the highest level of overall satisfaction (Mean±S.D. = 4.25±0.52).