LOSS MANAGEMENT IN PHARMACEUTICAL LOGISTICS THROUGH BUSINESS INTELLIGENCE: EVIDENCE FROM A DISTRIBUTION CENTER
DOI:
https://doi.org/10.66104/asggh131Keywords:
Business Intelligence; Performance Indicators; Loss Management; Pharmaceutical Logistics; Distribution Center.Abstract
This study analyzes the contribution of Business Intelligence (BI) to loss management in a pharmaceutical Distribution Center located in Teresina-PI, through the implementation of performance indicators focused on inventory control and loss prevention. The research is characterized as applied, exploratory, documentary, and qualitative, developed through a case study using data extracted from the company’s ERP and WMS systems. The study involved the restructuring of fiscal operations, the segmentation of loss and credit causes, and the implementation of dashboards in Power BI for monitoring strategic indicators. The results demonstrated greater accuracy in inventory movement control, improved information traceability, and increased agility in managerial decision-making. A reduction in operational inconsistencies and improvements in the loss analysis process were observed, especially regarding internal damages and product incineration. It is concluded that the integration between Business Intelligence and performance indicators significantly contributes to operational efficiency and the sustainability of pharmaceutical logistics management, providing a model applicable to other distribution centers.
Downloads
References
ALMEIDA, I. D. Metodologia do trabalho científico. Editora UFPE. 2021. DOI: https://doi.org/10.51359/978-65-5962-058-6
ANVISA. Resolução RDC nº 430/2020 – Boas práticas de distribuição, armazenagem e transporte de medicamentos. 2020. Disponível em: https://anvisalegis.datalegis.net/action/ActionDatalegis.php. Acesso em 27 de maio de 2025.
BRAGA, P. D. B., AMARAL, T. G. do, MELO, R. S. S. de. (2021). Business intelligence e sistemas nebulosos na definição de Lean Score. In Anais do III Simpósio Brasileiro de Tecnologia da Informação e Comunicação na Construção. Porto Alegre: ANTAC, DOI: https://doi.org/10.46421/sbtic.v3i00.597. DOI: https://doi.org/10.46421/sbtic.v3i00.597
CARVALHO JUNIOR, S., & MACEDO, S. H. M. Logística farmacêutica geral: Da teoria à prática. Contento. 2012.
CHRISTOPHER, M. Logistics and supply chain management. 5. ed. London: Pearson, 2016.
DAVENPORT, T. H.; HARRIS, J. G. Competing on analytics. Boston: Harvard Business School Press, 2007.
DE OLIVEIRA, G. C., DIAS, F. H. A importância da análise de indicadores de desempenho dentro do processo produtivo. Revista Interface Tecnológica, 20(1), 645–656. 2023. DOI: https://doi.org/10.31510/infa.v20i1.1744 DOI: https://doi.org/10.31510/infa.v20i1.1646
DEHORATIUS, N.; RAMAN, A. Inventory record inaccuracy: An empirical analysis. Management Science, v. 54, n. 4, p. 627–641, 2008. DOI: https://doi.org/10.1287/mnsc.1070.0789 DOI: https://doi.org/10.1287/mnsc.1070.0789
Gil, A. C. (2008). Métodos e técnicas de pesquisa social (6. ed.). Atlas.
LEÃO, A. P. DA S., GOMES, B. R. A., CRUZ, J. C. S., SILVA, V. V. DA, SENA, C. DA C., & OLIVEIRA JÚNIOR, F. A. V. Power BI para tomada de decisões estratégicas: Análise de indicadores-chave de desempenho (KPIs). Revista Foco, 16(7). 2023. DOI: https://doi.org/10.28950/1981-223x_revistafocoadm/2023.v16i7.2141 DOI: https://doi.org/10.54751/revistafoco.v16n7-084
LIMA, N. C., & TEIXEIRA, W. Análise do uso de KPIs com o suporte de sistemas BI para incremento da eficácia do processo decisório em uma organização jurídica. Revista GESTO: Revista de Gestão Estratégica de Organizações, 9(1), 21–34. 2020. DOI: https://doi.org/10.33369/gesto.v9i1.11863 DOI: https://doi.org/10.31512/gesto.v9i1.200
OZAWA, A. Pentágono de perdas: Transformando perdas em lucros (1ª ed.). Ed.: Edição do Autor. 2017.
PEREIRA, D. A. DE M., DOS SANTOS, M., & COSTA, D. DE O. Análise da distribuição de vacinas contra o COVID-19 no Cariri Paraibano a partir do desenvolvimento de um dashboard em Power BI. Journal Archives of Health, 2(3), 430–441. 2021. DOI: https://doi.org/10.46919/archv2n3-019 DOI: https://doi.org/10.46919/archv2n3-019
PRODANOV, C. C., & FREITAS, E. C. Metodologia do trabalho científico: Métodos e técnicas da pesquisa e do trabalho acadêmico (2. ed.). Feevale.2013.
RODRIGUES, M. Ações para a qualidade: Gestão estratégica e integrada para a melhoria dos processos na busca da qualidade e competitividade. (5. ed.). Elsevier. 2016
SHARDA, R.; DELEN, D.; TURBAN, E. Business intelligence, analytics, and data science: A managerial perspective. 4. ed. Boston: Pearson, 2018.
SOUZA, R. S., & RODRIGUEZ, C. M. T. Logística de distribuição de produtos farmacêuticos no estado do Amazonas. Revista de Gestão e Secretariado – GeSec, 15(11), p. 1–21, 2024. DOI: https://doi.org/10.7769/gesec.v15i11.2215 DOI: https://doi.org/10.7769/gesec.v15i11.4396
TEIXEIRA, M. T., & SANTOS, M. S. F. dos. Implantação de Warehouse Management System (WMS) em um centro de distribuição farmacêutico. 2021.
WORLD HEALTH ORGANIZATION. Guidelines on good distribution practices for pharmaceutical products. Geneva, 2010. Disponível em: https://www.prepwatch.org/resources/good-distribution-practices-who-2010/. Acesso em 04 de abril de 2025.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Caio Denílson Cavalcante de Sousa, Geordy Souza Pereira, Francismilton Teles, Matheus Almeida Neves, Nayara Cardoso de Medeiros, Márcio Vinícius Brito Pessoa
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish in this journal agree to the following terms:
Authors retain copyright and grant the journal the right of first publication, with the work simultaneously licensed under the Creative Commons Attribution License, which permits the sharing of the work with proper acknowledgment of authorship and initial publication in this journal;
Authors are authorized to enter into separate, additional agreements for the non-exclusive distribution of the version of the work published in this journal (e.g., posting in an institutional repository or publishing it as a book chapter), provided that authorship and initial publication in this journal are properly acknowledged, and that the work is adapted to the template of the respective repository;
Authors are permitted and encouraged to post and distribute their work online (e.g., in institutional repositories or on their personal websites) at any point before or during the editorial process, as this may lead to productive exchanges and increase the impact and citation of the published work (see The Effect of Open Access);
Authors are responsible for correctly providing their personal information, including name, keywords, abstracts, and other relevant data, thereby defining how they wish to be cited. The journal’s editorial board is not responsible for any errors or inconsistencies in these records.
PRIVACY POLICY
The names and email addresses provided to this journal will be used exclusively for the purposes of this publication and will not be made available for any other purpose or to third parties.
Note: All content of the work is the sole responsibility of the author and the advisor.
