Proposal of an inventory control system based on the flow of materials in a warehouse using Excel/VBA
DOI:
https://doi.org/10.18624/etech.v16i1.1246Keywords:
Excel; VBA; Inventory management; WMS; SystemAbstract
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
Downloads
Downloads
Published
How to Cite
Issue
Section
License
Esta licença permite que os reutilizadores distribuam, remixem, adaptem e desenvolvam o material em qualquer meio ou formato, desde que a atribuição seja dada à revista. A licença permite o uso comercial.