Enhancing Efficiency of the Warehouse Transportation Department using the AppSheet Program: A Case Study of an Aluminum Industry Company

Abstract

This research aims 1) to record data on the warehouse transportation process using the App Sheet program, 2) to reduce customer complaints, and 3) to increase the efficiency of the warehouse transportation department. From collecting data from the warehouse transportation department, it was found that the warehouse transportation department's work system was inefficient. The researcher analyzed the causes of the problem using a fishbone diagram, the Why-Why principle, and a flow chart. The researcher solved the problem by creating an App Sheet program to support data recording. Research results 1) Before improvement, there were problems with lost and damaged documents from June to September 2024. There were 1,003 shipments, 66 lost and damaged documents, or 6.5 percent, and after improvement. By using the application sheet program to record data from Oct 2024 to Jan 2025, there were 1,003 shipments of goods. Lost and damaged documents - times 2) Customer complaints before improvement from Jun to Sep 2024, there were 1,003 shipments. (1) Complaints about damaged goods, including 18 written complaints, representing 1.79 percent, and 137 verbal complaints, representing 13.66 percent, and (2) The service of the delivery staff had inappropriate behavior, including 8 written complaints, representing 0.79 percent, and 129 verbal complaints, representing 12.86 percent. After improvement from Oct 2024 to Jan 2025, there were 1,003 shipments. (1) Complaints about damaged goods, including 12 written complaints, representing 1.20 percent, and (2) The service of the delivery staff had inappropriate behavior. (no complaints) and 3) increase the efficiency of the warehouse transportation department. The 8 steps of work before improvement took 682 minutes, distance 191 kilometers, and after improvement, the customer signed the document through the sheet application, took 537 minutes, distance 191 kilometers, which the time reduced was the step of waiting to receive documents for processing from the customer, reduced by 148 minutes, or 29.96 percent.