Enhancing Production and Operations Efficiency through the Integration of an Automated Parts Ordering System Using Visual Basic for Applications (VBA) in Microsoft Excel: A Case Study of the Engineering Department in a Manufacturing Company

This research focuses on integrating a Visual Basic for Applications (VBA) tool into Microsoft Excel to enhance the engineering department's productivity at an automotive wire harness manufacturing company. Traditionally, the department relied on manual, paper-based requests for ordering parts, a process that frequently led to unclear descriptions, missing information, and incorrect part specifications. To address these inefficiencies, a digital system was developed following an eight-stage methodology: problem identification, data collection, data analysis, system design, VBA encoding, testing, implementation, and conclusion.