Aplicação de uma ferramenta para auxílio no planejamento e controle da produção em uma cervejaria de grande porte

Abstract

The beer market is a sector that has been growing more and more in Brazil and in the world, as its demand has been growing, the dispute of the big brands is also competitive, the brewing industries aim to have as many of their products as possible in markets, bars, events and distributors. The area of Production Planning and Control (PCP) is essential for this to occur, aiming at the demand, the control of inputs, the capacity of the manufacturing units and the planning and control of the production lines, this makes the PCP branch a strategic sector of the company, needing to make decisions in accordance with the current scenario and with the planning previously carried out. Thus, the PCP of breweries seeks to boost production according to demand restrictions, availability of inputs and the capacity of production lines. Considering the search for the best delivery to the market, it is necessary to monitor indicators and manage them through tools developed in software, such as Excel and Power BI. These tools allow a better visualization and control of the variables that influence the planning, aiming to prevent or block possible problems. In view of this, the construction and all interpretation of the tools, usually based on graphics, are developed for analysis and decisionmaking. Through this work, information was collected about variables that influence the performance and decision making of the PCP and the Power BI tool was applied with a focus on integrating information from this sector that is interconnected with all others. The result of this was the presentation of a dashboard that allowed a better visibility of the indicators and production progress, making the PCP accuracy indicator evolve, that is, the production goals are met.