Desenvolvimento de ferramenta informatizada para suporte ao planejamento das necessidades de materiais

Abstract

This work consists in developing and validating a computerized tool using Microsoft Excel software to support material requirements planning in a line of repackaging of imported pharmaceuticals. At first, it was performed a literature research on production management, production planning and control and MRP (Material Requirements Planning), presenting concepts useful for better understanding of work, as dependent and independent demand items, bill of materials and requirements calculation. Then it was identified the steps were identified for developing the tool: obtaining inputs information, developing the layout of spreadsheets and filling in the permanent information. Finally, the tool was tested in a practical situation with products of greater representation in revenues, defined through an ABC analysis. The tool provided greater clarity and organization of process information, besides rationalization of work, considering that initially, the requirements calculation was conducted in a slow and informal way, where the analyst checked the forecast arrival of products, bills of materials and stocks of components, then he performed the requirements calculation to finally release purchase requisitions.