Proposal of an inventory control system based on the flow of materials in a warehouse using Excel/VBA

Abstract

Inventory management systems are indispensable for most companies since the cost of implementing robust systems, such as the Warehouse Management System (WMS), leads companies to invest a high implementation value depending on the structure that best suits their internal flow. Thus, this article sought to present the implementation of a more viable software for material management in one of the warehouses of an assembler of the two-wheeler hub in Manaus, where no warehouse system controls the flow of materials and their addressing. The Excel program developed the system using the programming language linked to Microsoft Office: Visual Basic for Applications (VBA). This system presented itself as an alternative with a more viable implementation cost than a robust system such as the WMS. In addition, the system’s functioning flow was developed based on the process already done in the stock, facilitating its implementation and acceptance by the operators