Desenvolvimento de melhorias no controle de estoque em uma indústria de reciclagem metálica

Abstract

The inventory management is presented as a segment of high relevance in the management of production, once performed efficiently, it enables planning and control of production based in strategic management. The objective of this work was the development of a suppply control tool that enables managers to quantify the existence of raw material to be processed, as well as in all stages of the process and the inputs used in the metal recycling process. This tool also assists in the decision making regarding the purchase of inputs. A spreadsheet using Excel ® software was developed for daily control of the data, quantifying inputs (purchases), consumption, production and output, inserting the conditional formatting in the cells of the balance of inputs with reference to the point of application. This, in turn, was calculated based on the literature of Dias (2008) and Tubino (2009). The tool was presented as a communication between the data of purchase and production, which the managers already had control, promoting both simple and detailed overview of the consumption of inputs as production. The data archived in the developed tool also allows the definition of economic lots of purchasing, inventory costs, use of statistical methods for predicting consumer and also the implementation of a MRP system.