Análisis y mejora del control de inventarios y abastecimiento de productos farmacéuticos en el área de hospitalización pediátrica del Camino Adelita de Char, utilizando la herramienta Google Data studio para procesamiento y visualización de datos
Cargando...
Fecha
2022
Autores
Paredes Quiñones, José Enrique
Título de la revista
ISSN de la revista
Título del volumen
Editor
Ediciones Universidad Simón Bolívar
Facultad de Ingenierías
Facultad de Ingenierías
Resumen
El servicio de pediatría de la Clínica adelita de Char maneja una sala de servicio para atender a 60 pacientes aproximadamente, el objetivo principal de este trabajo es resolver la incertidumbre constante con la siguiente pregunta ¿Por qué se generan faltantes en los pedidos de los servicios solicitados por el área hospitalaria de la clínica enfocados en el servicio de pediatría? Para resolver esta pregunta se genera una herramienta de inteligencia de negocios basados en la herramienta Google Data Studio, para que de las diferentes áreas, hospitalaria, farmacia, compras, así como del área contable y financiera, puedan visualizar de manera actualizada los insumos o medicamentos que requieren atención, que cuando lleguen a stock de seguridad, genere la respectiva alerta y que se mantenga la trazabilidad en la adquisición por el área de compras para tener un correcto manejo en los costos, inclusive con esta previsión de la demanda se pueden establecer mejores relaciones con los proveedores para informar de manera oportuna la solicitud de pedido y así darles el tiempo respectivo para la adquisición de este, para evitar rupturas en la cadena de suministro que beneficiando directamente al paciente que se atiende, así como la correcta gestión de inventarios por parte del servicio farmacéutico, manteniendo un índice de rotación de sus productos adecuado a la demanda del servicio.
The pediatric service of the Adelite de Char Clinic manages a service room to serve approximately 60 patients, the main objective of this work is to solve the constant uncertainty with the following question: Why are missing orders generated for the requested services? by the hospital area of the clinic focused on the pediatric service? To solve this question, a business intelligence tool based on the Google Data Studio tool is generated, so that the different areas, hospital, pharmacy, purchases, as well as the accounting and financial area, can visualize the supplies or medicines in an updated manner. that require attention, that when they reach safety stock, generate the respective alert and that traceability is maintained in the acquisition by the purchasing area to have a correct cost management, even with this forecast of the demand better can be established relationships with suppliers to inform the order request in a timely manner and thus give them the respective time for the acquisition of this, to avoid breaks in the supply chain that directly benefit the patient being treated, as well as the correct management of inventories by part of the pharmaceutical service, maintaining a rotation index of its products adapted to the demand of the service.
The pediatric service of the Adelite de Char Clinic manages a service room to serve approximately 60 patients, the main objective of this work is to solve the constant uncertainty with the following question: Why are missing orders generated for the requested services? by the hospital area of the clinic focused on the pediatric service? To solve this question, a business intelligence tool based on the Google Data Studio tool is generated, so that the different areas, hospital, pharmacy, purchases, as well as the accounting and financial area, can visualize the supplies or medicines in an updated manner. that require attention, that when they reach safety stock, generate the respective alert and that traceability is maintained in the acquisition by the purchasing area to have a correct cost management, even with this forecast of the demand better can be established relationships with suppliers to inform the order request in a timely manner and thus give them the respective time for the acquisition of this, to avoid breaks in the supply chain that directly benefit the patient being treated, as well as the correct management of inventories by part of the pharmaceutical service, maintaining a rotation index of its products adapted to the demand of the service.
Descripción
Palabras clave
Inteligencia de negocios, Inventarios, Abastecimiento, Farmacia
