Sistema de gerenciamento de estoque de matéria-prima em Excel VBA

Abstract

This paper aims to develop a raw material inventory management system using Excel VBA for the company Puracor Tintas, located in Londrina, Paraná, which identified the need to improve stock management following an administrative restructuring. The implementation of an efficient inventory control system is essential to avoid unexpected production stoppages and optimize purchasing, contributing to the continuous improvement of internal processes. The developed system seeks to meet this need by offering an inventory control tool that does not incur additional costs for the company, can be customized according to its needs, and is easy to understand and use. The study highlights the importance of inventory management, addressing concepts such as types of stock, economic effects, and management models like JIT and MRP, while also discussing in detail the system's implementation, from its adaptation to the company to the addition and removal of items in the inventory control.