Product Tracking System Development for Transportation Process from Automobile Parts Factory to The Warehouse
Keywords:
data management, transportation process, web application, system performanceAbstract
This research aimed to develop a web application with the objectives of (1) designing and developing a system for recording and tracking the status of product shipments to address data-related issues, enabling tracking and traceability within the process, and (2) evaluating the system’s performance and limitations. Data collection involved identifying issues from a purposively selected sample group based on relevance to the process and work experience. The system was developed following the Software Development Life Cycle (SDLC) as a Single Page Application (SPA) with a serverless architecture. Functional tests were conducted to verify system capabilities, while performance tests, including Load, Capacity, Stress, and Availability tests, were carried out to assess system performance across three metrics: Throughput (req/sec), Response Time (ms), and Resource Usage. Performance was analyzed under worst-case scenarios using the 90th and 95th percentiles. Results indicated that the system met the expectations in all 15 evaluation criteria across 7 functions, achieving 100% compliance, and demonstrated its effectiveness in resolving data management issues. The developed system reduced data-related costs by over 36,521.22 baht annually and minimized shipment waiting time by 190.41 minutes per shipment, equivalent to a 5.98% reduction. Furthermore, the system exhibited efficient performance under current loads, supporting scalability up to 800% before experiencing any performance degradation, thereby enhancing the overall efficiency of the shipment process.
References
Al-Ahmad, B., & Debei, K. A. (2020). Survey of testing methods for web applications. European International Journal of Science and Technology, 9(12), 1-22. Retrieved from https://www.researchgate.net/profile/Bilal_Al-Ahmad/publication/348000478_Survey_of_Testing_Methods_for_Web_Applications/links/5fec692a92851c13fed40a1c/Survey-of-Testing-Methods-for-Web-Applications.pdf
Ambore, S. (2021). Web application development: Full & detailed guide for 2022. Retrieved from https://www.linkedin.com/pulse/web-application-development-full-detailed-guide-2022-sham-ambore/
Andersson, M. (2023). The importance of web application architecture: Understanding factors influencing decision-making and identifying potential improvements for effective web development (Bachelor’s thesis). Karlstad University. Karlstad.
Athikulrat, K., & Jangruxsakul, S. (2023). Design and implementation of industrial logistics communication system with google workspace: A case study hitech Pattana Industry Co., Ltd. Journal of Professional Routine to Research, 10, 55-66. Retrieved from https://so03.tci-thaijo.org/index.php/jpr2r/article/view/263676/178517 (in Thai)
Babu, A. C., Teja, V. N. C. S., Reddy, A. D., Kumar, E. N., & Srinivas, V. (2023). Web based hospital management system. 2023 9th International Conference on Advanced Computing and Communication Systems (ICACCS) (pp. 1109-1113). Coimbatore, India: IEEE
Chandrasekhar, A. K., & Chandran, A. S. (2021). Comparative analysis of load testing tools. International Journal of Creative Research Thoughts (IJCRT), 9(6), 758-764. Retrieved from https://ijcrt.org/papers/IJCRT2106814.pdf
Ferràs-Hernández, X., Tarrats-Pons, E., & Arimany-Serrat, N. (2017). Disruption in the automotive industry: A Cambrian moment. Business Horizons, 60(6), 855-863. https://doi.org/10.1016/j.bushor.2017.07.011
Hossain, M. I. (2023). Software Development Life Cycle (SDLC) Methodologies for information systems project management. International Journal for Multidisciplinary Research, 5(5), 6223. https://doi.org/10.36948/ijfmr.2023.v05i05.6223
Jain, M. (2023). Understanding data: Definition, importance, and its four key aspects. Retrieved from https://www.linkedin.com/pulse/understanding-data-definition-importance-its-four-key-manas-jain/
Jugo, I., Kermek, D., & Mestrovic, A. (2014). Analysis and evaluation of web application. 14th International Conference, ICWE 2014, Toulouse, France, July 1-4, 2014, Proceedings (pp. 40-56). Toulouse, France: Université Paul Sabatier
Jutamaneeroj, D. (2021). Development of web application using decision based learning to enhance pre-clinic medical student’s evaluate reasoning (Master’s Thesis). Chulalongkorn University. Bangkok (in Thai)
Leelaprute, P., & Churchart, N. (2018). Development of system and database for capacity planning in integrated circuit manufacturing. UTK Research Journal, 12(2), 136–147. Retrieved from https://ph02.tci-thaijo.org/index.php/rmutk/article/view/143793/117471 (in Thai)
Katruksa, S., & Kullimratchai, P. (2024). Application of artificial neural networks and adaptive neuro-fuzzy inference systems in the electrical power system. EAU Heritage Journal Science and Technology, 18(1), 1–19. retrieved from https://he01.tci-thaijo.org/index.php/EAUHJSci/article/view/266469 (in Thai)
Pantupon, T., Chotibhawaris, T., & Buddeejeen, J. (2021). Improvement of nut and screw placement in warehouse with ABC analysis. EAU Heritage Journal Science and Technology, 15(3), 201–210. Retrieved from https://he01.tci-thaijo.org/index.php/EAUHJSci/article/view/249752 (in Thai)
Orsuwan, P., & Tati, S. (2023). Web application development for efficient and paperless disbursement of office supplies. Case study 9th armoured regiment, 4th infantry division. Journal of Logistics and Digital Supply Chain, 1(3), 52-67. Retrieved from https://ph03.tci-thaijo.org/index.php/JLDSC/article/view/1259/1091 (in Thai)
Patil, S, S., & Joshi, S, D. (2012). Identification of performance improving factors for web application by performance testing. International Journal of Emerging Technology and Advanced Engineering, 2(8), 433-436. Retrieved from https://www.ijetae.com/files/Volume2Issue8/IJETAE_0812_74.pdf
Pengsomboon, W., Thanawasien, S., & Sujarae, A. (2019). Transportation system design for transporting heavy and oversize goods. EAU Heritage Journal Science and Technology (Online), 13(3), 106–118. retrieved from https://he01.tci-thaijo.org/index.php/EAUHJSci/article/view/231616 (in Thai)
Phanthali, P. (2020). Social changes in the 21st century. Buddhism in Mekong Region Journal, 3(2), 44-55. Retrieved from https://so06.tci-thaijo.org/index.php/bmrj/article/view/251411 (in Thai)
Piromrit, S., & Tinapron, S. (2014). Data center design for organization functions and scale. EAU Heritage Journal Science and Technology, 6(2), 30–38. Retrieved from https://he01.tci-thaijo.org/index.php/EAUHJSci/article/view/25721 (in Thai)
Pranee, P. (2018). A design of customer surveying and data processing system of new car buyers (Master’s Thesis). Chulalongkorn University. Bangkok (in Thai)
Somsar, P. (2018). Supplier information management systems Case study auto parts manufacturing company (Master’s Thesis). Burapha University. Chon Buri (in Thai)
Tangsongjitakul, C., Jairueng, S., Hirunwat, A., & Ruekkasaem, L. (2024). Supplier selection using analytic hierarchy process for installation fire protection system in high-rise building. EAU Heritage Journal Science and Technology, 18(2), 152–170. Retrieved from https://he01.tci-thaijo.org/index.php/EAUHJSci/article/view/268196 (in Thai)
Wing, J. M. (2019). The data life cycle. Harvard data science review, 1(1), 198882622. https://doi.org/10.1162/99608f92.e26845b4
