Modelo Tarifario en paneles interactivos para la toma de decisiones en una cadena de suministros

Abstract

CONDITION FOR PROJECT PUBLICATION. In the fast-food sector, logistics management must be efficient given the volatility of operating costs such as fuel. This work proposes a dynamic tariff model for secondary distribution, which also incorporates business intelligence to optimize budget allocation. The innovation stems from the obsolescence of current tariffs and the need for technical bases to conduct negotiations with suppliers that favor profitability. Methodologically, field data collection and interviews with key stakeholders were carried out, with data processing conducted using ETL techniques. Tools such as Python were used for data cleaning and Excel for structuring, enabling the creation of interactive dashboards in Power BI with allocation models by distance and by route. The analysis of the generated data yielded positive results regarding the cost structure, as well as identifying some irregularities. For example, on the Milagro route, it was found that the cost per km is excessive; considering our model, it is currently being charged 50-60% higher. Another important aspect is the creation of management tools that help identify scenarios and the level of financial sensitivity. Finally, it is concluded that tariff standardization according to this model not only aligns operating costs with reality but also endows management with immediate response capacity to market fluctuations, ensuring informed and sustainable decisions. Keywords: Tariff Model, Secondary Distribution, Business Intelligence, Logistics Costs, Power BI.