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
References
[1] Chukwulozie. (2014). Design and Development of Materials Requirements and Design of Goods Inventory Information System.
[2] Galloway, et al. (2021). [The shift from manual documentation to structured digital input].
[3] International Organization for Standardization. (2016). [Data traceability requirements].
[4] Itamaki. (2025). Improvement of Purchase Order Invoice Processing: Case study of Technical Materials Purchasing.
[5] Jones. (2023). [Practical, low-cost digital solutions applied in real workplace settings].
[6] Kalwar, & Khan. (2020). Optimization of Procurement & Purchase Order Process in Footwear Industry by Using VBA in Ms Excel.
[7] Kalwar, et al. (2021). Optimization of Vendor Rate Analysis Report by VBA: A Case Study of Footwear Industry.
[8] Kalwar, et al. (2024). Automation of Post Order Costing Analysis By Using Visual Basic For Applications in Microsoft Excel: A Case Study.
[9] Khan. (2021). Automation of Supplier Price Evaluation Report in MS Excel by Using Visual Basic for Applications: A Case of Footwear Industry.
[10] Logistics Management Journal. (2024). [Efficient project execution in the automotive sector].
[11] OpenAI. (2024). ChatGPT (Dec 27 version) [Large language model]. https://chatgpt.com
[12] Serrano, & Reid. (2022). [Excel-based automation as a low-code solution for manufacturing.]
[13] Smith, & Jones. (2022). [The role of engineering departments in automotive wire harness manufacturing].
[14] Smith, & Thompson. (2022). [Structured digital forms and request management].
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}
}