Automatización del sistema de información en los principales indicadores del negocio en PELPAK S.A.
No Thumbnail Available
Date
2022-05-27
Authors
Advisors
Editors
Journal Title
Journal ISSN
Volume Title
Publisher
Corporación Universitaria Minuto de Dios
Type
Thesis
Rights
Atribución-NoComercial-SinDerivadas 2.5 Colombia
Abstract
El proceso de sistematización de la práctica profesional se concentra en la empresa Pelpak S.A., la cual es una compañía que se dedica a lafabricación de envases plásticos y cuenta en su haber con un total de 40 máquinas sopladoras e inyectoras que utilizan los dispositivos (WIZE) los cuales permiten acceder a los diferentes sensores de las máquinas podemos obtener información la cual es procesacon protocolos ETL: Extraer información, Transformar y Limpiar los datos para posteriormente publicar dentro de los informes que la compañía ha determinado para realizar seguimiento y control. En ese sentido, se planteó como objetivo general automatizar la información de los principales indicadores del modelo del negocio (OEE, productividady merma), para consulta en tiempo real.Metodológicamente, se caracteriza por ser un trabajo con enfoque cualitativo en el cual se emplearon instrumentos como la entrevista a profundidad para poder establecer la situación actualy presentar alternativas que sirvieran de base para dar respuestasalproblema. Los resultados obtenidos durante el diagnóstico, permitió determinar que se llevaba un registro manual de los indicadores, en el cual todo el personal operativo registraba con un alto margen de error la información relacionada con las unidades fabricadas, tiempos perdidos, consumos de materia prima y perdidas asociadas, la cual era tabulada y posteriormente se realizaba los informes para poder tomar decisiones, tomando un tiempo de una semana y ocasionando retardo y lentitud en los procedimientos a seguir frente a cualquier eventualidad en la planta.
The systematization process of professional practice is concentrated in the company Pelpak SA, which is a company dedicated to the manufacture of plastic containers and has a total of 40 blow molding and injection machines that use the devices (WIZE ) which allow access to the different sensors of the machines, we can obtain information which is processed with ETL protocols: Extract information, Transform and Clean the data to later publish within the reports that the company has determined to carry out monitoring and control. In this sense, the general objective was to automate the information of the main indicators of the business model (OEE, time and waste), for consultation in real time. Methodologically, it is characterized by being a work with a qualitative approach in which instruments such as in-depth interviews were used to establish the current situation and present alternatives that would serve as a basis for responding to the problem. The results obtained during the diagnosis made it possible to determine that a manual record of the indicators was kept, in which all the operating personnel recorded, with a high margin of error, the information related to the units manufactured, lost times, consumption of raw materials and losses. associated, which was tabulated and later the reports were made to be able to make decisions, taking a time of one week and causing delay and slowness in the procedures to be followed in the face of any eventuality in the plant
The systematization process of professional practice is concentrated in the company Pelpak SA, which is a company dedicated to the manufacture of plastic containers and has a total of 40 blow molding and injection machines that use the devices (WIZE ) which allow access to the different sensors of the machines, we can obtain information which is processed with ETL protocols: Extract information, Transform and Clean the data to later publish within the reports that the company has determined to carry out monitoring and control. In this sense, the general objective was to automate the information of the main indicators of the business model (OEE, time and waste), for consultation in real time. Methodologically, it is characterized by being a work with a qualitative approach in which instruments such as in-depth interviews were used to establish the current situation and present alternatives that would serve as a basis for responding to the problem. The results obtained during the diagnosis made it possible to determine that a manual record of the indicators was kept, in which all the operating personnel recorded, with a high margin of error, the information related to the units manufactured, lost times, consumption of raw materials and losses. associated, which was tabulated and later the reports were made to be able to make decisions, taking a time of one week and causing delay and slowness in the procedures to be followed in the face of any eventuality in the plant
Description
Automatizar la información de los principales indicadores del modelo del negocio (OEE, tiempos y mermas), para consulta en tiempo real.
Keywords
máquinas sopladoras, internet de las cosa, protocolos ETL, blowing machines, internet of things, ETL protocols