Planejamento de produção com a utilização do MS Excel Solver em uma indústria de farinhas e pré-misturas localizada no sudoeste do Paraná

Abstract

This work presents an approach on the planning of production of finished products and grinding of the company Dona Alda Indústria de Alimentos Ltda. In this work the restriction theory was applied through the software "MS Excel Solver" with the objective of analyzing a food industry using restriction theory to identify the main production bottlenecks and propose measures to improve its productive and economic performance. In order to carry out the data collection, three questionnaires were prepared based on the purpose of acquiring information relevant to the production process so that, in this way, the restrictions of the same are identified. The questions related to the identification of the types of wheats, which raw materials would generate, the existing technical data sheets, the storage capacity of the different types of raw materials and the specifications of the finished products. A total of 6 simulations were made, 3 of wheat grinding and 3 of finished product production, based on different scenarios. It was concluded at the end of this work that it is possible to define the optimized production through the milling of wheat or the market demand for finished products, up to 391.60% in the case of milling and 28.47% in the production of finished products and, if the owners opt for an enlargement, the first one that must be made is in the wheat milling line.