Elaboração de planilha eletrônica para planejamento de recursos de fabricação em indústria farmacêutica

Abstract

The increasing complexity and competitiveness in the labor market demands more efficient management of industrial processes, often achieved by interconnecting several organizational sectors in an enterprise resource planning system. However, due to the various specificities of each business it is necessary to customize the tool, becoming an arduous process that does not always fully meet the daily requirements. In order to complement Totvs' ERP Protheus in a pharmaceutical grade cosmetic sector, a spreadsheet was developed with the Microsoft Excel® editor along with macros programmed the Visual Basic for Application (VBA) language, with the purpose of simulating different MRP scenarios for the Production Planning and Control sector in a faster and more efficient way than the methods usually used. The new tool was validated through the simulation of three finished products with a future delivery time between three and four months, in the amount of 1.000, 5.000 and 8.000 units in each product and with varied delivery parameters, considering the product's registration and structure specified by the user, the updated data of initial and planned balance of materials compatible with the ERP electronic reports as well as parameters of industrial production capacity. After the tests, the spreadsheet proved to be valid to be applied in the daily production planning and contribute to gain operational time of projections, decrease of errors and manpower.