Home / Current Issue / Paper 1718057
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
Subject area: Science,Engineering and Technology · Area of research: Engineering
DOI: https://doi.org/10.64388/IREV9I11-1718057
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
How to cite this paper
@article{1718057,
author = {Angelica T. Pangilinan, Michael John M. Villar},
title = {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},
journal = {Iconic Research And Engineering Journals},
year = {2026},
volume = {9},
number = {11},
pages = {3548-3551},
issn = {2456-8880},
url = {https://www.irejournals.com/formatedpaper/1718057.pdf},
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},
month = {May},
doi = {https://doi.org/10.64388/IREV9I11-1718057}
}