ANALYSIS OF THE INFLUENCE OF COMMERCIAL TIME WINDOW, DELIVERY TIME CONSTRAINTS, AND TRAFFIC CONGESTION ON FIRST-ATTEMPT DELIVERY SUCCESS RATE WITH FLEET ALLOCATION MANAGEMENT AS A MEDIATING VARIABL E (CASE STUDY: LION PARCEL BANDUNG)
Published:
2026-08-11Downloads
Abstract
This study aims to identify the factors contributing to the high rate of first-attempt delivery failures in Lion Parcel's last-mile delivery operations in the city of Bandung, which are caused by various operational obstacles faced by couriers in the field. The objective is to examine how Commercial Time Window, Delivery Time Constraints, and Traffic Congestion affect the first-attempt delivery success rate, while also testing whether Fleet Allocation Management acts as a mediating factor among these variables. This study employs a quantitative approach with an explanatory research design. Given the relatively small population size, the entire population was used as the sample (census/saturated sampling), consisting of 90 respondents made up of active motorcycle couriers and van drivers. Primary data were collected directly through a closed-ended Likert-scale questionnaire and subsequently processed using the Structural Equation Modeling–Partial Least Squares (SEM-PLS) method with the aid of SmartPLS 4 software. The structural model testing results show that Delivery Time Constraints and Traffic Congestion both have a positive and significant effect on Fleet Allocation Management, whereas Commercial Time Window shows no significant effect. Meanwhile, in testing the direct effects, all three obstacle variables, together with Fleet Allocation Management, were proven to have a significant effect on the first-attempt delivery success rate. In terms of mediation testing, Fleet Allocation Management was proven to successfully bridge the effects of Delivery Time Constraints and Traffic Congestion on delivery success, but was unable to mediate the effect of the Commercial Time Window constraint. This indicates that the issue of the commercial acceptance time limit (commercial time window) cannot be resolved solely through fleet management in the field; rather, improvements are needed in the dispatch work system at the warehouse that are more preventive in nature.
Keywords:
Last-Mile Delivery Commercial Time Window Traffic Congestion Fleet Allocation Management First-Attempt Delivery Success Rate SEM-PLSReferences
Ahani, P., Arantes, A., & Melo, S. (2023). An Optimization Model for Structuring a Car-Sharing Fleet Considering Traffic Congestion Intensity. Journal of Advanced Transportation, 2023. https://doi.org/10.1155/2023/9283130
AYDIN, A., BENLİ, D., ÇİMEN, M., & SOYSAL, M. (2022). Analyses on the Effect of Time Window Selections in Sustainable Vehicle Allocation Problems. Cankiri Karatekin University Faculty of Economics and Administrative Sciences Journal. https://doi.org/10.18074/ckuiibfd.970762
Balaska, V., Tsiakas, K., Giakoumis, D., Kostavelis, I., Folinas, D., Gasteratos, A., & Tzovaras, D. (2022). A Viewpoint on the Challenges and Solutions for Driverless Last-Mile Delivery. Machines, 10 (11). https://doi.org/10.3390/machines10111059
Chairunnisa, C., Maemunah, S., & Kadarisman, M. (n.d.). Analysis of Vendor Trucking Management Factors, Delivery Timeliness, and Fleet Availability on IKEA Export Goods Delivery at PT XYZ Logistics Jakarta. https://doi.org/10.38035/jemsi.v7i3
Chu, H., Zhang, W., Bai, P., & Chen, Y. (2023). Data-driven optimization for last-mile delivery. Complex and Intelligent Systems, 9(3), 2271–2284. https://doi.org/10.1007/s40747-021-00293-1
Cvetek, D., Muštra, M., Jelušić, N., & Tišljarić, L. (2021). A survey of methods and technologies for congestion estimation based on multisource data fusion. In Applied Sciences (Switzerland) (Vol. 11, Number 5, pp. 1–19). MDPI AG. https://doi.org/10.3390/app11052306
de Oliveira, L. K., de Oliveira, I. K., de Oliveira Leite Nascimento, C., de Oliveira Lobo Cordeiro, C. H., Meira, L. H., Rabay, L., & da Silva, F. G. F. (2021a). Identification of factors to improve the productivity and working conditions of motorcycle couriers in Belo Horizonte, Brazil. Case Studies on Transport Policy, 9(4), 1737–1745. https://doi.org/10.1016/j.cstp.2021.09.003
de Oliveira, L. K., de Oliveira, I. K., de Oliveira Leite Nascimento, C., de Oliveira Lobo Cordeiro, C. H., Meira, L. H., Rabay, L., & da Silva, F. G. F. (2021b). Identification of factors to improve the productivity and working conditions of motorcycle couriers in Belo Horizonte, Brazil. Case Studies on Transport Policy, 9(4), 1737–1745. https://doi.org/10.1016/j.cstp.2021.09.003
Escudero-Santana, A., Muñuzuri, J., Lorenzo-Espejo, A., & Muñoz-Díaz, M. L. (2022). Improving E-Commerce Distribution through Last-Mile Logistics with Multiple Possibilities of Deliveries Based on Time and Location. In Journal of Theoretical and Applied Electronic Commerce Research (Vol. 17, Number 2, pp. 507–521). MDPI. https://doi.org/10.3390/jtaer17020027
Grzelak, M., & Borucka, A. (2026). Modeling Food Distribution Time as a Tool for Developing the Competitive Advantage of Logistics Enterprises in the Context of Sustainable Development Implementation. Sustainability (Switzerland), 18(9). https://doi.org/10.3390/su18094225
Hosseini, D., Rostami, B., & Araghi, M. (2025). Service Time Window Design in Last-Mile Delivery. http://arxiv.org/abs/2508.01032
Jazemi, R., Alidadiani, E., Ahn, K., & Jang, J. (2023). A Review of Literature on Vehicle Routing Problems of Last-Mile Delivery in Urban Areas. In Applied Sciences (Switzerland) (Vol. 13, Number 24). Multidisciplinary Digital Publishing Institute (MDPI). https://doi.org/10.3390/app132413015
Kandula, S., Krishnamoorthy, S., & Roy, D. (n.d.). A Predictive and Prescriptive Analytics Framework for Efficient E-Commerce Order Delivery.
Lorenzo-Espejo, A., Muñuzuri, J., Onieva, L., & Muñoz-Díaz, M. L. (2025). Exploring the correlation between courier workload, service density and distance with the success of last-mile and first-mile reverse logistics. Central European Journal of Operations Research, 33(4), 1327–1341. https://doi.org/10.1007/s10100-024-00928-x
Moreno, R. P. R., Lopes, R. B., Ramos, A. L., Ferreira, J. V., Correia, D., & Melo, I. E. S. de. (2025). An Agent-Based Simulation and Optimization Approach for Sustainable Urban Logistics: A Case Study in Lisbon. Applied System Innovation, 8(3). https://doi.org/10.3390/asi8030066
Muhammad Tarmuji Riduwan, Suharto Suharto, & Rachmad Ilham. (2026). Optimization of Distribution Flow to Improve Delivery Time Efficiency at PT SINJ. Trending: Jurnal Manajemen Dan Ekonomi, 4(2), 159–166. https://doi.org/10.30640/trending.v4i2.6423
Oloko, O. (2025). Dynamic Route Optimization in Last-Mile Delivery Using Predictive Analytics: A Case Study of E-commerce in the U.S. European Journal of Logistics, Purchasing and Supply Chain Management, 12(3), 1–32. https://doi.org/10.37745/ejlpscm.2013/vol12n3132
Pradini, J. (2023). The Influence of Service Quality and Timeliness of Delivery on Customer Satisfaction at the Sicepat Express Delivery Service. In Logistica : Journal of Logistic and Transportation (Vol. 1, Number 1).
Rumondang Banjarnahor, A., Triharjono, A., & Setiawan, A. (2021). Effect of Fleet Availability and Controlling on Delivery Accuracy (Case Study at PT. Cardig Logistics Indonesia). Jurnal Manajemen Bisnis, 8(1), 112–122.
Seghezzi, A., & Mangiaracina, R. (2023). Smart home devices and B2C e-commerce: a way to reduce failed deliveries. Industrial Management and Data Systems, 123(5), 1624–1645. https://doi.org/10.1108/IMDS-10-2022-0651
Shehadeh, K. S., Wang, H., & Zhang, P. (2021). Fleet Sizing and Allocation for On-demand Last-Mile Transportation Systems. http://arxiv.org/abs/2107.12523
Sosedová, J., Otáhalová, Z., Dávid, A., & Galieriková, A. (2021). Delivery times and delay in delivery of consignment under the conditions of international carriage. In Communications - Scientific Letters of the University of Žilina (Vol. 23, Number 4, pp. A248–A255). University of Žilina. https://doi.org/10.26552/COM.C.2021.4.A248-A255
Suguna, M., Shah, B., Raj, S. K., & Suresh, M. (2022). A study on the influential factors of the last mile delivery projects during Covid-19 era. Operations Management Research, 15(1–2), 399–412. https://doi.org/10.1007/s12063-021-00214-y
Sumekar, A., Bukit, R. B., & Situmeang, C. (2022). Prosiding Fakultas Ekonomi dan Bisnis.
Ünal, Y. (2025). Real time routing with vehicle failure and traffic awareness in last-mile delivery. Engineering and Applied Science Letters, 8(4), 98–112. https://doi.org/10.30538/psrp-easl2025.0128
License
Copyright (c) 2026 Muhammad Taufiq, Maniah, Agus Purnomo
This work is licensed under a Creative Commons Attribution 4.0 International License.
