Propuesta de mejora del proceso de planificación de la producción mediante el analisis de datos

Abstract

Abstract: This thesis focuses on improving production planning in companies that wish to implement an efficient and adaptable model. The research was conducted using real-world data from Ecolac, a company located in Loja, Ecuador, that produces 65 products made from raw milk. Manufacturing involves the interaction of various variables, such as production costs, processing times, capacities, efficiency, and productivity. These variables require rigorous planning, as their proper management directly impacts company performance. It is important to note that these variables are common to many organizations, so having a standard database will allow for accurate analyses for current planning and future projections. The main objective of this thesis is to propose an improvement in production planning through the analysis of data captured in Power BI. To achieve this, key process variables will be identified and addressed, and a standard database will be designed to facilitate the visualization of valuable information on production and sales. This tool will optimize processes and provide practical solutions for more efficient and strategic management.