(2) Isti Raafaldini Mirzanti
*corresponding author
AbstractPT Adhi Surya Amanah (ASA Trans), a domestic B2B freight forwarding company in Indonesia, faces persistent inefficiencies in its pricing process that hinder operational speed, accuracy, and competitiveness. The company relies heavily on manual quotation preparation using fragmented information spread across spreadsheets, emails, and handwritten records. This results in inconsistent pricing decisions, long quote response times, and a heavy reliance on staff interpretation, limiting the company's ability to respond efficiently to customer demand in an increasingly competitive logistics environment. These inefficiencies pose both scientific and managerial challenges, as accurate and timely pricing is a key factor in determining profitability and market performance in freight forwarding. Therefore, this study aims to develop, test, and implement a data-driven price forecasting infrastructure that can increase efficiency, reduce human error, and improve strategic decision-making at ASA Trans. The research begins by identifying the root causes of inefficiency through a detailed assessment of ASA Trans’s operational workflow. This evaluation identified four key challenges: unstructured and fragmented pricing information, manual verification, lack of access to real-time cost and market data, and over-reliance on subjective judgment. All of these issues lead to decreased operational reliability and limit the company's ability to grow. To address these challenges, this paper proposes a forecasting model to be developed based on the premise that ASA Trans' historical records of freight, cost, and pricing information are sufficient to provide the operational trends necessary for accurate forecasting. The study also assumes that market factors such as fuel and toll prices are subject to specific, predictable trends. The objectives of this study include determining the data requirements for price prediction, comparing forecasting techniques, creating a practical prototype of a price forecasting system, and integrating the system into ASA Trans' workflow. To achieve these objectives, the researchers employed a multi-stage methodology. Primary data was collected using internal freight data, operational cost records, and historical prices, while secondary data was collected in the form of freight benchmarks and competitor rate cards. Analysis Phase: The machine learning process involved is structured and includes data cleaning, standardization, exploratory data analysis, model development, and validation. Supervised learning technology was applied to three models: Multiple Linear Regression, Random Forest, and LightGBM to determine which approach provided the most accurate and operational predictions. Model evaluation is conducted using MAE, RMSE, and MAPE, supported by business-oriented validation criteria that measure quotation speed, usability, and alignment with financial objectives. The findings indicated that the best model was the Random Forest model, which had the lowest error and the most consistent results across various shipping situations. The fact that this model can capture nonlinear relationships makes it a favorable solution for the multifaceted and cost-based structure found in the Indonesian domestic freight market. The implementation of the Random Forest model was realized in a web-based Price Forecasting System created at ASA Trans. The implementation phase transformed the model into a working tool that can input estimated shipping costs, estimated operational costs, and estimated lead times with minimal user input. Test results showed that bid completion time was reduced from several hours to minutes, indicating significant improvements in operational efficiency. The fact that this system improves consistency, reduces administrative workload, and enhances the accuracy of pricing decisions was confirmed by user feedback during the training and socialization phases. This system is also capable of providing structured and continuous cost details, which increases transparency and enhances customer trust. This research contributes to scientific knowledge by demonstrating the practical application of machine learning in pricing optimization for domestic freight forwarding. It also establishes an empirical foundation for integrating predictive analytics into pricing workflows in small to mid-scale logistics companies in emerging markets. In the case of ASA Trans, the forecasting system is a strategic move towards digitalization, which will have long-term advantages with better pricing management, uniform decision-making, and preparedness to undertake an automation initiative in the future, like a more comprehensive Transportation Management System (TMS). KeywordsPricing Forecasting, Pricing System, Freight Forwarder
|
DOIhttps://doi.org/10.47679/jrssh.v5i4.497 |
Article metrics10.47679/jrssh.v5i4.497 Abstract views : 90 | PDF views : 22 |
Cite |
Full Text Download
|
References
ALI. (2023). Indonesia Logistics Market Outlook 2024. Indonesian Logistics Association.
Bappenas, & World Bank. (2023). Indonesia Logistics Cost Study.
BCG. (2018). The digital imperative in container shipping. https://www.bcg.com/publications/2018/digital-imperative-container-shipping
Cherepanov, V., & Popov, A. (2024). Design and design thinking in digital transformation. Journal of Business Research, 169, 113–126.
Christopher, M. (2016). Logistics & supply chain management (5th ed.). Pearson Education.
Gujarati, D. N., & Porter, D. C. (2009). Basic econometrics (5th ed.). McGraw-Hill/Irwin.
Harani, N. H., Setyawan, M. Y. H., & Ferdinan, D. (2025). Predicting basic shipping tariff using machine learning. Nuansa Informatika, 19(2), 58–66. https://doi.org/10.25134/ilkom.v19i2.388
IBM. (n.d.). Data-driven decision making. https://www.ibm.com/think/topics/data-driven-decision-making
Jang, H.-S., Chang, T.-W., & Kim, S.-H. (2023). Prediction of shipping cost on freight brokerage platform using machine learning. Sustainability, 15(2), 1122. ttps://doi.org/10.3390/su15021122
Ke, G., Meng, Q., Finley, T., Wang, T., Chen, W., Ma, W., Ye, Q., & Liu, T.-Y. (2017). LightGBM: A highly efficient gradient boosting decision tree. Advances in Neural Information Processing Systems, 30, 3146–3154.
Liang, Y., Chen, Z., & He, X. (2024). Intelligent pricing decision support system for the logistics industry based on big data platform. International Journal of Logistics Research and Applications, 27(4), 523–540.
Michel, S., & Siegfried, P. (2020). Digital freight forwarders in food logistics. Transportation Research Procedia, 46, 65–72.
Montgomery, D. C., Peck, E. A., & Vining, G. G. (2021). Introduction to linear regression analysis (6th ed.). Wiley.
Muha, R. (2019). Problematic issues in logistics cost management. Pomorstvo, 33(1), 102–109. https://doi.org/10.31217/p.33.1.11
Muthutantrige, D., Hasan, R., & Shah, B. (2023). Project management framework for digitalization of logistics processes. IEEE Access, 11, 45321–45335.
Oliveira, P., Zancul, E., & Salerno, M. (2024). Capability building for digital transformation through design thinking. Journal of Service Design, 15(1), 35–50.
Prasetyo, H., & Sutopo, W. (2018). The application of multiple linear regression for logistics cost estimation in freight forwarding. IOP Conference Series: Materials Science and Engineering, 337(1), 012046. https://doi.org/10.1088/1757-899X/337/1/012046
Shi, H., Guo, Y., & Wang, J. (2019). Application of LightGBM in demand forecasting for logistics. Procedia Computer Science, 162, 646–653. https://doi.org/10.1016/j.procs.2019.12.037
Wang, S., Meng, Q., & Sun, Z. (2018). Forecasting container transport demand with a multiple linear regression model. Maritime Policy & Management, 45(7), 985–1000. https://doi.org/10.1080/03088839.2018.1446105
Refbacks
- There are currently no refbacks.
Copyright (c) 2025 Shofi Rafiiola

This work is licensed under a Creative Commons Attribution 4.0 International License.
______________________________________________________________________________________________
Journal of Research in Social Science And Humanities
Published by Utan Kayu Publishing
Email: jurnal.jrssh@gmail.com











Download