Application of AppSheet for Improving the Material Withdrawal and Disbursement Process in a Metal Mold Department: A Case Study of an Automotive Parts Manufacturing Company, Krathum Baen District, Samut Sakhon Province
Keywords:
Material Disbursement, Automotive Part, OptimizationAbstract
This research aimed to: 1) apply AppSheet to develop a material requisition and dispensing system for a metal mold department; and 2) determine the efficiency of the material requisition and dispensing process in the metal mold department. Data analysis revealed an inefficient material requisition and dispensing system. The researchers analyzed the causes using process flow diagrams and the "why-why" principle, applying AppSheet to the material requisition and dispensing system. The results showed that: 1) the application of AppSheet effectively improved the efficiency of the material requisition and dispensing system; and 2) the efficiency of the material requisition and dispensing process in the metal mold department was reduced. Before improvement, the system consisted of 8 steps taking 1,295 seconds. After improvement using AppSheet, the process was reduced to 7 steps taking 605 seconds, a decrease of 1 step or 12.50%, resulting in a 690 second reduction in material requisition and dispensing time, or a 53.28% reduction.
References
AppSheet. (n.d.). Google AppSheet | Build apps with no code. https://www.appsheet.com/.
Dina, M., Widya, R., Bhumyamka, S. & Bambang, D. (2020). Warehouse management
system for smart digital order picking systems. International Journal of New Media Technology, 6(2), 74–80.
Fabria, M., Ramalhinho, H., Oliver, M. & Muñoz, J. C. (2020). Internal logistics flow
simulation: A case study in automotive industry. Journal of Simulation, 16(2), 204 216.
Hassan, M. K., Rusli, M. H. M. & Salleh, N. A. M. (2023). Development of an order
processing system using Google Sheets and Appsheet for a Malaysian automotive SME
factory warehouse. Journal of Mechanical Engineering (JMechE), 20(3), 63–81.
Kraus, S., Jones, P., Kailer, N., Weinmann, A., Chaparro-Banegas, N. & Roig-Tierno, N.
(2021). Digital transformation: An overview of the current state of the art of research. SAGE Open, 11(3), 1–21.
Rattanapanya, S. (2024). The Development of Disbursement Process for Medical
Support Equipment: Chaiyaphum Hospital. Chaiyaphum Medical Journal, 43(Supplement), 46-58. (in Thai)
Thavornwat, C. & Boonchujarud, S. (2020). Process Improvement of Raw Materials Storage with Industrial Engineering Techniques. Rajamangala University of Technology Thanyaburi Engineering Journal, 21(2), 104–111. (in Thai)
Treewichit, W., Poljaroen, T. & Srisawat, Y. (2025). Enhancing efficiency in powdered
pigment raw material warehouse management using the AppSheet program:
a case study of a plastic industry company. Journal of Engineering and Innovation, 18(2), 33-44. (in Thai)
Widianto, M. H., Sanjaya, B., Aurellia, V. & Chrysanthia, S. A. (2022). Implementation
mobile smart farming monitoring system with low-cost platform using Blynk. Journal
of Theoretical and Applied Information Technology, 100(9), 2723–2745.
Worachotepanyaratana, S. & Niemsakul, J. (2021). Demand Forecasting and Inventory
Management: A Case Study of Automotive Parts Manufacturing Company.
Sripatum Chonburi Academic Journal, 17(3), 155-166. (in Thai)
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Wittayasara: Integration Apply Engineering and Industrial Technology
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
