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.
Pangilinan et al. (2026) studied this question.