TRANSPETRO ROTA FÁCIL: DEVELOPMENT AND APPLICATION OF A WEB-BASED LOGISTICS DECISION SUPPORT SYSTEM FOR PIPELINE SPARE PARTS MANAGEMENT
Abstract
The maintenance of critical equipment in pipeline infrastructure requires spare parts to be stored at locations capable of meeting emergencies within predefined time windows. At Transpetro, Brazil's largest pipeline and terminal operator, the operational criterion for mechanical pump seals establishes a maximum road travel time of 2 hours and 30 minutes between the storage terminal and the requesting terminal. However, no formal system existed to verify whether designated storage terminals met this criterion. This paper presents Transpetro Rota Fácil, a web-based system developed in Python/Streamlit that integrates two routing API engines, OpenRouteService and Google Maps Distance Matrix, to calculate real road distances and travel times between operational units. Developed according to the Design Science Research Methodology (DSRM), the artifact was applied to real Transpetro data: it analyzed approximately 30 route pairs, identified 2 non-compliant terminals, and resulted in the formal redirection of storage to compliant terminals, with documented managerial validation. The solution established a precedent for systematic logistical compliance verification of other critical materials. The software is registered with Brazil's National Institute of Industrial Property (INPI) and available as open source.
Author Biographies
Economist, Production Engineer, and Ph.D. candidate in Production Engineering with a focus on Operations Research at the Fluminense Federal University (UFF). Holds a Master's degree in Economics and an MBA in Business Management. Works as a Production Engineer at Transpetro, leading continuous improvement projects, Big Data analytics initiatives, and the development of Artificial Intelligence agents for materials management.
Mechanical Engineer with postgraduate qualifications in Maintenance Management, Innovation, and Business. Holds a Master's degree in Transportation Engineering from the Military Institute of Engineering (IME). Has 11 years of experience in industrial maintenance and higher education teaching. Has been working at Transpetro since 2011 and currently serves as Materials Contracts Manager, leading initiatives in supply optimization, reliability, and inventory modeling.
Associate Professor at the Fluminense Federal University (UFF), where he serves as Coordinator of Post-Production. With a solid academic career, he has also taught at Ibmec and Veiga de Almeida University. His research and publications are primarily focused on Multi-Criteria Decision Making (MCDM), Strategic Planning, and Operational Efficiency Assessment.
Ph.D. in Operations Research from the Fluminense Federal University (UFF), with postdoctoral fellowships at the Aeronautics Institute of Technology (ITA) and UFF. Professor at the Brazilian Naval School and Decision-Making Consultant at Petrobras. A Reserve Officer of the Brazilian Navy, he is included in Stanford University's Top 2% Scientists ranking and leads research with more than 900 published works in Data Science, Multicriteria Methods, and Mathematical Modeling.
References
ACHAMRAH, Fatima Ezzahra; RIANE, Fouad; LIMBOURG, Sabine. Spare parts inventory routing problem with transshipment and substitutions under stochastic demands. Applied Mathematical Modelling, v. 101, p. 309-331, 2022. DOI: https://doi.org/10.1016/j.apm.2021.08.029 DOI: https://doi.org/10.1016/j.apm.2021.08.029
CALLEJAS-MOLINA, R. A. et al. Circuit Analysis Approach for Sustainable Routing Optimization with Multiple Delivery Points. Sustainability, v. 17, n. 7, p. 2866, 2025. DOI: https://doi.org/10.3390/su17072866 DOI: https://doi.org/10.3390/su17072866
CARDEAL, G.; LEITE, Marco; RIBEIRO, Inês. Decision-support model to select spare parts suitable for additive manufacturing. Computers in Industry, v. 144, p. 103798, 2023. DOI: https://doi.org/10.1016/j.compind.2022.103798 DOI: https://doi.org/10.1016/j.compind.2022.103798
COSTA, Juliana Martins; MEIRELLES, Betina Hörner Schlindwein; MAGALHÃES, Aline Lima Pestana. Software para apoio à decisão logística no processo de captação e transplante de órgãos. Revista Baiana de Enfermagem, p. e52699, 2023. Available at: https://pesquisa.bvsalud.org/portal/resource/pt/biblio-1529692 DOI: https://doi.org/10.18471/rbe.v37.52699
DE BARROS FRANCO, David Gabriel; STEINER, Maria Teresinha Arns; ASSEF, Fernanda Medeiros. Optimization in waste landfilling partitioning in Paraná State, Brazil. Journal of Cleaner Production, v. 283, p. 125353, 2021. DOI: https://doi.org/10.1016/j.jclepro.2020.125353 DOI: https://doi.org/10.1016/j.jclepro.2020.125353
DO REGO, José Roberto; DE MESQUITA, Marco Aurélio. Spare parts inventory control: a literature review. Produção, v. 21, n. 4, p. 645-655, 2011 DOI: https://doi.org/10.1590/S0103-65132011005000002 DOI: https://doi.org/10.1590/S0103-65132011005000002
GAO, Shijia; XU, Dongming. An intelligent agent-assisted logistics exception management decision support system: a design-science approach. In: Information Systems Foundations, p. 189, 2010. DOI: https://doi.org/10.22459/ISF.12.2010.09
GARCÍA-BENITO, Juan Carlos; MARTÍN-PEÑA, María-Luz. A redistribution model with minimum backorders of spare parts: a proposal for the defence sector. European Journal of Operational Research, v. 291, n. 1, p. 178-193, 2021 DOI: https://doi.org/10.1016/j.ejor.2020.09.014 DOI: https://doi.org/10.1016/j.ejor.2020.09.014
GÖKDAĞ, Zehra Hafızoğlu; TÜRKMEN, Ayşe Dilara; CEBECI, Salih. Optimization of the First-Mile Pickup Problem: a Real-Life Case Study. In: WCECSS Proceedings, 2025. DOI: 0.11159/cist25.125. DOI: https://doi.org/10.11159/cist25.125
GOOGLE. Google Maps Platform: Distance Matrix API Documentation. Mountain View: Google LLC, 2024. Disponível em: https://developers.google.com/maps/documentation/distance-matrix Acesso em: abr. 2026.
HEVNER, A. R.; MARCH, S. T.; PARK, J.; RAM, S. Design science in information systems research. MIS Quarterly, v. 28, n. 1, p. 75-106, 2004 DOI: https://doi.org/10.2307/25148625 DOI: https://doi.org/10.2307/25148625
KENNEDY, W. J.; PATTERSON, J. W.; FREDENDALL, L. D. An overview of recent literature on spare parts inventories. International Journal of Production Economics, v. 76, n. 2, p. 201-215, 2002 DOI: https://doi.org/10.1016/S0925-5273(01)00174-8 DOI: https://doi.org/10.1016/S0925-5273(01)00174-8
LEYERER, M. et al. Individually optimized commercial road transport: A decision support system for customizable routing problems. Sustainability, v. 11, n. 20, p. 5544, 2019. DOI: https://doi.org/10.3390/su11205544 DOI: https://doi.org/10.3390/su11205544
LI, Jinliang; REN, Weibo; WANG, Xibin. Joint location-allocation model for multi-level maintenance service network in agriculture. Applied Sciences, v. 13, n. 18, p. 10167, 2023 DOI: https://doi.org/10.3390/app131810167 DOI: https://doi.org/10.3390/app131810167
LI, Xinlong; JIANG, Shuai; CHEN, Baojia; CHEN, Fafa; AN, Youjun; RAN, Yan; ZHANG, Genbao. Joint optimization of imperfect preventive opportunistic maintenance and spare parts inventory for multi-unit systems considering spare parts reuse. Reliability Engineering & System Safety, v. 261, p. 111162, 2025 DOI: https://doi.org/10.1016/j.ress.2025.111162 DOI: https://doi.org/10.1016/j.ress.2025.111162
LJUBOTINA, Leonid; ŠEVROVIĆ, Marko; PIRDAVANI, Ali; JOVANOVIĆ, Bojan. Evaluating cargo bike delivery applications in urban logistics: the case of Zagreb. Transportation Research Procedia, v. 91, p. 235-242, 2025 DOI: https://doi.org/10.1016/j.trpro.2025.10.031 DOI: https://doi.org/10.1016/j.trpro.2025.10.031
MINNER, S. Multiple-supplier inventory models in supply chain management: a review. International Journal of Production Economics, v. 81-82, p. 265-279, 2003 DOI: https://doi.org/10.1016/S0925-5273(02)00288-8 DOI: https://doi.org/10.1016/S0925-5273(02)00288-8
MOUSCHOUTZI, Maria; PONIS, Stavros T. A comprehensive literature review on spare parts logistics management in the maritime industry. The Asian Journal of Shipping and Logistics, v. 38, n. 2, p. 71-83, 2022. DOI: https://doi.org/10.1016/j.ajsl.2021.12.003 DOI: https://doi.org/10.1016/j.ajsl.2021.12.003
NARANJO, Jose E. et al. A scoping review of pipeline maintenance methodologies based on Industry 4.0. Sustainability, v. 14, n. 24, p. 16723, 2022 DOI: https://doi.org/10.3390/su142416723 DOI: https://doi.org/10.3390/su142416723
NEIS, P.; ZIPF, A. Analyzing the contributor activity of a volunteered geographic information project—The case of OpenStreetMap. ISPRS International Journal of Geo-Information, v. 1, n. 2, p. 146-165, 2012. DOI: https://doi.org/10.3390/ijgi1020146 DOI: https://doi.org/10.3390/ijgi1020146
PEFFERS, K. et al. A design science research methodology for information systems research. Journal of Management Information Systems, v. 24, n. 3, p. 45-77, 2007 DOI: https://doi.org/10.2753/MIS0742-1222240302 DOI: https://doi.org/10.2753/MIS0742-1222240302
PEREIRA, M. Teresa et al. Enhancing third-party logistics efficiency: a digital approach to transport costing. In: Design, Simulation, Manufacturing: The Innovation Exchange. Cham: Springer Nature Switzerland, p. 159-170, 2025. DOI: https://doi.org/10.1007/978-3-032-07144-6_14 DOI: https://doi.org/10.1007/978-3-032-07144-6_14
PHAM, D. T.; KIESMULLER, G. P. Multiperiod integrated spare parts and tour planning for on-site maintenance activities with stochastic repair requests. Computers & Operations Research, v. 148, p. 105967, 2022 DOI: https://doi.org/10.1016/j.cor.2022.105967 DOI: https://doi.org/10.1016/j.cor.2022.105967
[removido para revisão por pares]. Transpetro Rota Fácil: simulador de distância e tempo rodoviário. Rio de Janeiro: INPI, 2026. Registro de Programa de Computador nº [removido para revisão por pares].
RIZKIA, Irma; YULIANTO, Hubertus Davy. Smart supply chain management with artificial intelligence: toward resilient and sustainable industrial automation in Industry 4.0. In: 2025 International Conference on ICT for Smart Society (ICISS). IEEE, 2025. p. 1-9. DOI: https://doi.org/10.1109/ICISS66954.2025.11389384 DOI: https://doi.org/10.1109/ICISS66954.2025.11389384
YIN, R. K. Estudo de caso: planejamento e métodos. 5. ed. Porto Alegre: Bookman, 2015.
License
Copyright (c) 2026 RECIMA21 - Revista Científica Multidisciplinar - ISSN 2675-6218
This work is licensed under a Creative Commons Attribution 4.0 International License.
Os direitos autorais dos artigos/resenhas/TCCs publicados pertecem à revista RECIMA21, e seguem o padrão Creative Commons (CC BY 4.0), permitindo a cópia ou reprodução, desde que cite a fonte e respeite os direitos dos autores e contenham menção aos mesmos nos créditos. Toda e qualquer obra publicada na revista, seu conteúdo é de responsabilidade dos autores, cabendo a RECIMA21 apenas ser o veículo de divulgação, seguindo os padrões nacionais e internacionais de publicação.