Strategic Optimization in Distribution Centers: Leveraging Relocation,  P-Median, and GIS-Based Routing for Enhanced Efficiency

Rahmad Inca Liperda; Nur Layli Rachmawati; Nanda Ruswandi; Ayu Apriani; Delinda Amarajaya; Nurdiana; Rifdah Tsabittaah

doi:10.36456/tibuana.7.01.8388.1-17

Authors

Rahmad Inca Liperda Logistics Engineering Department, Faculty of Industrial Technology, Universitas Pertamina, Daerah Khusus Ibukota Jakarta, 12220, Indonesia
Nur Layli Rachmawati Logistics Engineering Department, Faculty of Industrial Technology, Universitas Pertamina, Daerah Khusus Ibukota Jakarta, 12220, Indonesia
Nanda Ruswandi Logistics Engineering Department, Faculty of Industrial Technology, Universitas Pertamina, Daerah Khusus Ibukota Jakarta, 12220, Indonesia
Ayu Apriani Logistics Engineering Department, Faculty of Industrial Technology, Universitas Pertamina, Daerah Khusus Ibukota Jakarta, 12220, Indonesia
Delinda Amarajaya Logistics Engineering Department, Faculty of Industrial Technology, Universitas Pertamina, Daerah Khusus Ibukota Jakarta, 12220, Indonesia
Nurdiana Logistics Engineering Department, Faculty of Industrial Technology, Universitas Pertamina, Daerah Khusus Ibukota Jakarta, 12220, Indonesia
Rifdah Tsabittaah Logistics Engineering Department, Faculty of Industrial Technology, Universitas Pertamina, Daerah Khusus Ibukota Jakarta, 12220, Indonesia

DOI:

https://doi.org/10.36456/tibuana.7.01.8388.1-17

Keywords:

Business to Customer, Distribution Center, MTCVRP, P-Median

Abstract

In the realm of B2C (Business to Customer) company marketing, it is imperative to focus on sales and customer satisfaction. To uphold customer contentment, B2C enterprises must strategically position their delivery facilities to optimize efficiency and minimize both time and operational expenditures. PT ABC, a B2C entity specializing in the distribution of packaged goods, currently faces challenges in handling a substantial volume of requests, some of which are situated far from their distribution centers. This predicament leads to elevated fulfillment costs and an inefficient operational process. Consequently, the relocation of distribution center facilities becomes a necessity. The relocation process will be executed employing the P-Median method, facilitated by LINGO software. The P-Median analysis yielded three potential new locations: Cikupa, Jombang Wetan, and Bencongan Indah. Subsequently, further assessment through the resolution of the MTCVRP (Multitrip Capacitated Vehicle Routing Problem) with the aid of ArcGIS software was conducted. As a result, Jombang Wetan emerged as the optimal candidate, exhibiting a remarkable reduction of 165.7 kilometers or a 31.33% decrease in average mileage. This choice promises a more efficient and effective product distribution operation.

References

A. N. Sari. (2022, October). Kondisi Industri Pengolahan Makanan dan Minuman di Indonesia. Https://Www.Djkn.Kemenkeu.Go.Id/Kanwil-Suluttenggomalut/Baca-Artikel/15588/Kondisi-Industri-Pengolahan-Makanan-Dan-Minuman-Di-Indonesia.

A. Purnomo. (2017). ANALISIS RUTE DISTRIBUSI DENGAN METODE CAPACITY VEHICLE ROUTING PROBLEM (CVRP) PADA PRODUK COCA COLA DI PUSAT DISTRIBUSI BANDUNG. COMPETITIVE, 12(2).

Asmara, E., & Ichtiarto, B. P. (2021). Penerapan p-Median terhadap optimasi alokasi dan lokasi distribution center pada Sistem Logistik Pedesaan di Indonesia. Operations Excellence: Journal of Applied Industrial Engineering, 13(2), 215. https://doi.org/10.22441/oe.2021.v13.i2.020 DOI: https://doi.org/10.22441/oe.2021.v13.i2.020

BusinessWire. (2022, September). Indonesia B2C e-Commerce Markets Databook 2022: 100+ KPIs on e-Commerce Verticals, Market Share by Key Players, Sales Channel Analysis, Payment Instrument, Consumer Demographics 2017-2021 & 2022-2026. Https://Www.Businesswire.Com/News/Home/20220928005766/En/Indonesia-B2C-e-Commerce-Markets-Databook-2022-100-KPIs-on-e-Commerce-Verticals-Market-Share-by-Key-Players-Sales-Channel-Analysis-Payment-Instrument-Consumer-Demographics-2017-2021-2022-2026---Rese.

Cattaruzza, D., Absi, N., & Feillet, D. (2018). Vehicle routing problems with multiple trips. Annals of Operations Research, 271(1), 127–159. https://doi.org/10.1007/s10479-018-2988-7 DOI: https://doi.org/10.1007/s10479-018-2988-7

Fadhil (Universitas Pertamina), R. A., Prabowo (PT. Pertamina EP), E. G., & Redi (Universitas Pertamina), A. A. N. P. (2020). PENENTUAN LOKASI DISTRIBUTION CENTER DENGAN METODE P-MEDIAN DI PT PERTAMINA EP. Jurnal Manajemen Industri Dan Logistik, 4(1), 01–09. https://doi.org/10.30988/jmil.v4i1.282 DOI: https://doi.org/10.30988/jmil.v4i1.282

Kristina, S., Sianturi, R. D., & Husnadi, R. (2020). Penerapan Model Capacitated Vehicle Routing Problem (CVRP) Menggunakan Google OR-Tools untuk Penentuan Rute Pengantaran Obat pada Perusahaan Pedagang Besar Farmasi (PBF). Jurnal Telematika, 15(2).

Linfati, R., & Escobar, J. W. (2018). Reoptimization Heuristic for the Capacitated Vehicle Routing Problem. Journal of Advanced Transportation, 2018, 1–8. https://doi.org/10.1155/2018/3743710 DOI: https://doi.org/10.1155/2018/3743710

Lukmandono, Basuki, M., Hidayat, M. J., & Aji, F. B. (2019). Application of Saving Matrix Methods and Cross Entropy for Capacitated Vehicle Routing Problem (CVRP) Resolving. IOP Conference Series: Materials Science and Engineering, 462, 012025. https://doi.org/10.1088/1757-899X/462/1/012025 DOI: https://doi.org/10.1088/1757-899X/462/1/012025

Mingozzi, A., Roberti, R., & Toth, P. (2013). An Exact Algorithm for the Multitrip Vehicle Routing Problem. INFORMS Journal on Computing, 25(2), 193–207. https://doi.org/10.1287/ijoc.1110.0495 DOI: https://doi.org/10.1287/ijoc.1110.0495

Pribadi, O. S., & Permatasari, Y. (2021). Pemilihan Lokasi Terminal Barang di Kabupaten Semarang dengan Menggunakan Metode P-Median dalam Software Lindo 6.1. Jurnal Penelitian Transportasi Darat, 23(2), 158–169. https://doi.org/10.25104/jptd.v23i2.1813 DOI: https://doi.org/10.25104/jptd.v23i2.1813

Ramadhani, D. S., Masruroh, N. A., & Waluyo, J. (2021). MODEL OF VEHICLE ROUTING PROBLEM WITH SPLIT DELIVERY, MULTI TRIPS, MULTI PRODUCTS AND COMPARTMENTS FOR DETERMINING FUEL DISTRIBUTION ROUTES. ASEAN Journal of Systems Engineering, 5(2), 51. https://doi.org/10.22146/ajse.v5i2.72461 DOI: https://doi.org/10.22146/ajse.v5i2.72461

Rėklaitis, K., & Pilelienė, L. (2019). Principle Differences between B2B and B2C Marketing Communication Processes. Management of Organizations: Systematic Research, 81(1), 73–86. https://doi.org/10.1515/mosr-2019-0005 DOI: https://doi.org/10.1515/mosr-2019-0005

Widyastiti, M., & Awaludin, M. (2021). Implementasi Vehicle Routing Problem with Multiple Trips pada Masalah Pengangkutan Sampah. Limits: Journal of Mathematics and Its Applications, 18(1), 45. https://doi.org/10.12962/limits.v18i1.6038 DOI: https://doi.org/10.12962/limits.v18i1.6038

Zapata, Z., Cesar, A., Garnica, G., Arturo, E., Mota, C., Román, R., Álvarez, O., Fernando, F., Flores, M., Luis, J., Partida, S., & Diana, D. (2020). Warehouse Relocation of a Company in the Automotive Industry Using P-median. Advances in Science, Technology and Engineering Systems Journal, 5(3), 576–582. https://doi.org/10.25046/aj050372 DOI: https://doi.org/10.25046/aj050372