Diseño y desarrollo de calculadora tarifaría digital para una empresa de transporte en Guayaquil

Abstract

CONDITION FOR PROJECT PUBLICATION. This study seeks to design and optimize a cost structure for the provision of heavy cargo services in a transportation company in Guayaquil. The study focuses on the transport of goods from a base to potential customers, where fixed and inefficient route pricing generates losses in profitability. To address the problem, a cost structure was modeled based on the classification of fixed and variable costs, then a factor by route type was implemented, using historical average data, allowing them to be categorized more efficiently. Additionally, a minimum loss threshold was set for routes that generate a significant margin with respect to total cost. The calculator was designed in Microsoft Excel, taking advantage of its ability to modify and analyze data in an automated manner. The results made it possible to identify profitable rates without losing competitive advantage, reduce losses on critical routes, and dynamically adjust items when quoting trips. These improvements optimized the cost structure and adaptability, which had a significant impact on customer satisfaction and enabled the company to adapt to the market. The digital fare calculator made it possible to standardize the transportation pricing structure using a reliable mathematical-financial model. The identification of critical variables and their integration into Excel facilitated fast, accurate, and justified quotes, contributing to improved profitability and operational decision-making. Keywords: Keywords: Profitability, Threshold, Automated, Dynamic.