Current Volume 9
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
Abstract
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.
Keywords
Manufacturing Company, Microsoft Excel, Ordering System, Visual Basic
Citations
IRE Journals:
Angelica T. Pangilinan, Michael John M. Villar "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" Iconic Research And Engineering Journals Volume 9 Issue 11 2026 Page 3548-3551 https://doi.org/10.64388/IREV9I11-1718057
IEEE:
Angelica T. Pangilinan, Michael John M. Villar
"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" Iconic Research And Engineering Journals, 9(11) https://doi.org/10.64388/IREV9I11-1718057
About IRE Journals
IRE Journals is an open access online journals established with an aim to publish high quality of research work in various diciplines. We have more than 6 years in publications. Over 2500+ papers already published.
Important Links
For Authors
Volume 8:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 7:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 6:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 5:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 4:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 3:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12