Breaking The Limitations of Distribution: Creating an Integrated Solution with Saving Matrix and Net Present Value

Alifah Nur Astari; Muchammad Fauzi

doi:10.24014/jti.v10i1.29967

Breaking The Limitations of Distribution: Creating an Integrated Solution with Saving Matrix and Net Present Value

Alifah Nur Astari, Muchammad Fauzi

Abstract

PT BCD is one of the large pharmaceutical companies in Bandung, West Java which plays the role of main distributor. PT BCD is facing a problem related to its company logistics. The problem in question is in the form of customer complaints that reflect a bad image for the company, especially regarding on-time delivery. Many of these complaints came from outlets in the central rayon area consisting of RS A, RS B, RS C, Pharmacy D, Pharmacy E, Pharmacy F, PBF G, PBF H, and PBF I. In an effort to overcome this problem, the management plans to launch a program called same-day delivery service so it is necessary to carry out research that integrates the saving matrix method to determine the most optimal distribution route for pharmaceutical products so that the distance traveled in delivery is the shortest as well as carrying out mathematical considerations regarding fleet investment decisions based on which offers are available. Provides the greatest savings using the total cost of ownership (TCO) net present value method approach. From the results of the analysis of the two integrated methods, a picture of the decision in the form of the most optimal route based on the saving matrix analysis is obtained, namely PT BCD – RS A – RS B – PBF G – PBF H – PBF I – Apotek F – RS C – Apotek E – Apotek D – PT BCD with the decision to procure a fleet in the form of purchasing an L300 type box car.

Keywords: Logistic, Net Present Value, Same Day Delivery, Saving Matrix

Full Text:

PDF

References

Lukmandono, M. Basuki, M. J. Hidayat, and F. B. Aji, “Application of Saving Matrix Methods and Cross Entropy for Capacitated Vehicle Routing Problem (CVRP) Resolving,” IOP Conf. Ser. Mater. Sci. Eng., vol. 462, no. 1, 2019, doi: 10.1088/1757-899X/462/1/012025.

G. Kurnia, N. Putu, and D. Velicia, “Optimizing Warehouse Distribution Routes During Eid Season Using Saving Matrix and Nearest Insert Method,” J. Indonesian Logistics., flight. 5, no. 2, pp. 111–119, 2021.

A. Prayudha Hidayat, S. Husen Santosa, R. Siskandar, S. Vokasi Bogor Agricultural Institute Bogor Indonesia, and S. Vokasi Bogor Agricultural Institute, "Vehicle Route Determination Using Saving Matrix for Goods Delivery Services," Indonesians J. Sci., vol. 2, no. 3, pp. 113–117, 2021, [Online]. Available: http://journal.pusatsains.com/index.php/jsi.

T. R. Damayanti, A. L. Kusumaningrum, Y. D. Susanty, and S. S. Islam, “Route optimization using saving matrix method – a case study at a public logistics company in Indonesia,” Proc. Int. Conf. Ind. Eng. Oper. Manag., no. August, pp. 1583–1591, 2020.

O.: Riski, A. Mardika, and F. Achmadi, "Designing Transportation Routes Using the Saving Matrix Method to Minimize Delivery Distances," J. Econ. and Business, flight. 9, no. 2, pp. 440–446, 2022.

D. Meilani and A. Iswara, "3 Kg LPG Distribution Route Determination Application," J. Optimization Syst. Ind., flight. 17, no. 2, p. 208, 2018, doi: 10.25077/josi.v17.n2.p208-219.2018.

A. F. Ahsan and Lukmandono, “Application Of Saving Matrix Method In Determining 3 Kg Lpg Distribution Routes To Minimize Transportation Costs In. Pojur Real Madura,” Procedia Eng. Life Sci., flight. 1, no. 1, 2021, doi: 10.21070/pels.v1i1.842.

J. Alfian Pradana, A. Komari, and L. Dewi Indrasari, "Feasibility Study of Tell Kopi Business Using Financial Analysis," In. Innovation J. Tech. In., 2020, doi: 10.36040/industri.v10i2.2855.

R. P. Dewanti, E. Paryanto, J. A. Pradana, and C. Harsito, “Financial Feasibility of Modification Workshop Case Studies: Be-Modified,” Int. J. Sustain. Dev. Plan., vol. 17, no. 6, pp. 1865–1871, 2022, doi: 10.18280/ijsdp.170621.

HE. Gönül, A. C. Duman, B. Barutçu, and Ö. Güler, “Techno-economic analysis of PV systems with manually adjustable tilt mechanisms,” Eng. Sci. Technol. an Int. J., vol. 35, 2022, doi: 10.1016/j.jestch.2022.101116.

N. Gottschalk, A. Burkard, J. Quodbach, and M. Bogdahn, “Drop-on-powder 3D printing of amorphous high dose oral dosage forms: Process development, opportunities and printing limitations,” Int. J. Pharm. X, vol. 5, no. December 2022, p. 100151, 2023, doi: 10.1016/j.ijpx.2022.100151.

F. Armanda and R. F. Sari, “Optimization of Liquid Petroleum Gas ( LPG ) Cylinder Distribution Route with the Saving Matrix Method,” Numer. J. Matt. and Educator. Matt., flight. 7, no. 1, pp. 99–110, 2023.

P. H. Kasih and Y. Maulidina, "Determining Delivery Routes to Minimize Transportation Distance Using the Saving Matrix Method," J. INTECH Tech. Ind. Univ. Raya attack, vol. 9, no. 1, pp. 53–62, 2023, doi: 10.30656/intech.v9i1.5680.

J. Alfian Pradana, A. Komari, and L. Dewi Indrasari, "Feasibility Study of Tell Kopi Business Using Financial Analysis," In. Innovation J. Tech. In., vol. 10, no. 2, pp. 92–97, 2020, doi: 10.36040/industri.v10i2.2855.

V. Arfana Perdana, Z. Fatimah Hunusalela, and A. Teja Prasasty, "Application of the Saving Matrix Method and Nearest Neighbor Algorithm in Determining Distribution Routes to Minimize Transportation Costs at PT. XYZ," UNIQUE TEAK J. Ilm. Tech. and Manaj. Ind., vol. 4, no. 2, p. 91, 2021, doi: 10.30737/jatiunik.v4i2.1000.

D. E. Febriyanti, R. Primadasa, and S. Bhakti Sutono, “Determination of Distribution Routes Using the Saving Matrix Method to Minimize Shipping Costs at PT. SUKUN TRANSPORT LOGISTICS,” Spectrum Ind., vol. 20, no. 1, pp. 79–90, 2022, doi: 10.12928/si.v20i1.18.

N. A. F. P. Adam, I. P. Sari, A. Tasya, W. Sutopo, and Yuniaristanto, “Determination of Routes for Daily Newspaper Product Distribution with Saving Matrix Methods,” IOP Conf. Ser. Mater. Sci. Eng., vol. 943, no. 1, 2020, doi: 10.1088/1757-899X/943/1/012040.

Suparmi, H. Suyitno, and I. Rosyida, "OPTIMIZING PRODUCT DISTRIBUTION ROUTES USING SAVING MATRIX AND NEAREST INSERTION METHODS," UNNES J.Math., vol. 9, no. 2, p. 2020, 2020, [Online]. Available: http://journal.unnes.ac.id/sju/index.php/ujmUJM9.

N. Aprilia, "Application of the Savings Matrix Method to Minimize Shipping Costs for Packaged Products at PT XYZ," Tech. In., flight. 1, no. 1, pp. 5–9, 2019.

M. M. A. Azis, B. Trisno, and J. Kustija, “Feasibility analysis of DMSY cubicle in Dago Pakar substation, Indonesia, using FMEA, technical age, NPV and economic age,” IOP Conf. Ser. Mater. Sci. Eng., vol. 830, no. 3, 2020, doi: 10.1088/1757-899X/830/3/032033.

Toth, P., & Vigo, D., “The Vehicle Routing Problem . Philadelphia: Society for Industrial and Applied Mathematics”,2002.

Azhar, F. J., Astari, A. N., Rizky, C. A., & Fauzi, M. "Determining the Best Route for Distribution of Product , 2023.

Department of Public Works, "Vehicle Operating Cost Calculations", Construction and Building Guidelines, Pd T-15-2005-B, 2005.

Margana, R. R., & Astari, A. N, "Decision Making Analysis for Procurement of Photocopiers at PT BCD Using the Net Present Value Mathematical Model Approach", Lebesgue: Scientific Journal of Mathematics, Mathematics and Statistics Education, 1956-1964, 2023.

Marchioni, A., & Magni, C. A, “Investment decisions and sensitivity analysis: NPV-consistency of rates of return”, European Journal of Operational Research, 361-372, 2018.

DOI: http://dx.doi.org/10.24014/jti.v10i1.29967