Development of Drug Plan and Control App Using ABC, VEN, and Combined Methods for Inventory Control

Muhamad Rinaldhi Tandah; Nurul Ambianti; Yenita Kartika Putri; Khusnul Diana

doi:10.56303/jhnresearch.v4i2.451

Authors

Muhamad Rinaldhi Tandah Department of Pharmacy, Tadulako University, Palu, Indonesia https://orcid.org/0000-0003-1090-6490
Nurul Ambianti Department of Pharmacy, Tadulako University, Palu, Indonesia
Yenita Kartika Putri Department of Pharmacy, Tadulako University, Palu, Indonesia
Khusnul Diana Department of Pharmacy, Tadulako University, Palu, Indonesia https://orcid.org/0000-0001-9683-1754

Keywords:

ABC Method, ABC-VEN Method, Drug PC, Inventory Control, VEN Method

Abstract

Drug Plan and Control (Drug PC) application is a web-based digital tool designed to support pharmaceutical management in healthcare facilities by assisting in the planning, monitoring, and control of drug inventories. This study aimed to enhance the Drug PC (Plan and Control) application by integrating a drug categorization feature to improve pharmaceutical inventory control. Efficient inventory management is critical in healthcare, as poor control can lead to shortages, overstocking, and financial inefficiencies. The application was developed using PHP as the programming language and MySQL as the database management system. Drug categorization was performed using the ABC method, the VEN method, and a combination of both (ABC-VEN matrix). To evaluate the application's performance, Blackbox testing was conducted to assess the functionality of the user interface. In addition, manual calculations using Microsoft Excel were performed to validate and compare the application results with drug inventory data from two hospitals. Ethical approval was obtained from the Health Research Ethics Committee of the Faculty of Medicine, Tadulako University. The results demonstrated successful integration and 100% functionality accuracy of the new features. Categorization outputs aligned fully with manual data. Hospital 1 followed a typical ABC distribution (70:20:10%), while Hospital 2 showed deviations. VEN classification revealed a significantly higher proportion of Vital (V) drugs in Hospital 1 compared to Hospital 2 (p < 0.05). Combined ABC-VEN results showed CE (C + Essential) as the most common group. High-cost drugs (Category I) represented the majority of investment in both hospitals. In conclusion, the study shows that integrating categorization methods into digital tools like Drug PC can enhance drug inventory control, improve procurement planning, and optimize healthcare resource allocation.

Downloads

Download data is not yet available.

References

Baybo MP, Lolo WA, Jayanti M. Analisis Pengendalian Persediaan Obat di Puskesmas Teling Atas. J Farm Medica/Pharmacy Med J [Internet]. 2022 Jun 30;5(1):7. Available from: https://ejournal.unsrat.ac.id/index.php/pmj/article/view/41434

Darmawan NW, Peranginangin JM, Herowati R. Analisis Pengendalian Persediaan Obat BPJS Kategori A(Always) dan E (Esensial) dengan Menggunakan Metode ABC, VEN dan EOQ di IFRS Bhayangkara Tingkat III Nganjuk. JPSCR J Pharm Sci Clin Res [Internet]. 2021 Mar 17;6(1):20. Available from: https://jurnal.uns.ac.id/jpscr/article/view/38960

Mauluddin Y, Setiawan R, Ainu Tazkia H. Rancangan Proses Bisnis Sistem Informasi Gudang Farmasi Rumah Sakit Medina. J Algoritm [Internet]. 2022 Nov 30;19(2):567–77. Available from: https://jurnal.itg.ac.id/index.php/algoritma/article/view/1150

Muliana H, Sutanto R, Wahab S. Analisis Pengendalian Persediaan Farmasi di Rumah Sakit Awal Bros Batam. J Manaj dan Adm Rumah Sakit Indones [Internet]. 2022 Oct 31;6(2):138–55. Available from: http://ejournal.urindo.ac.id/index.php/MARSI/article/view/1982

Khaerunnisa A, Adriansyah MR. Evaluasi Perencanaan dan Pengadaan Kebutuhan Obat Terhadap Ketersediaan Obat di Apotek Cicaheum Farma. Cerdika J Ilm Indones [Internet]. 2022 Mar 25;2(3):338–44. Available from: https://cerdika.publikasiindonesia.id/index.php/cerdika/article/view/333

Lopes H, Lopes AR, Farinha H, Martins AP. Defining clinical pharmacy and support activities indicators for hospital practice using a combined nominal and focus group technique. Int J Clin Pharm [Internet]. 2021 Dec 24;43(6):1660–82. Available from: https://pubmed.ncbi.nlm.nih.gov/34165664/

Soraya C, Surwanti A, Pribadi F. Drug Inventory Management Using ABC-VEN and EOQ Analysis for Improving Hospital Efficiency. J Aisyah J Ilmu Kesehat [Internet]. 2022 Mar 11;7(1):373–82. Available from: https://aisyah.journalpress.id/index.php/jika/article/view/7146

Rahmawatie E, Santosa S. Sistem Informasi Perencanaan Pengadaan Obat di Dinas Kesehatan Kabupaten Boyolali. J Pseudocode [Internet]. 2015;2(1). Available from: https://ejournal.unib.ac.id/index.php/pseudocode/article/view/425

Diana K, Adisaputra AD, Tandah MR. Drug Plan and Control (Drug PC): Web-Based System Information of Drug and Inventory Control. Indones J Pharm Sci Technol [Internet]. 2024 Sep 30;6(2):119–29. Available from: https://jurnal.unpad.ac.id/ijpst/article/view/52618

Romadhon S, Wardoyo R. Prioritizing Drug Procurement Using ABC, VEN, EOQ And ROP Combination. IJCCS (Indonesian J Comput Cybern Syst [Internet]. 2021 Apr 30;15(2):209. Available from: https://jurnal.ugm.ac.id/ijccs/article/view/63486

Rofiq A, Oetari O, Widodo GP. Analisis Pengendalian Persediaan Obat Dengan Metode ABC, VEN dan EOQ di Rumah Sakit Bhayangkara Kediri. JPSCR J Pharm Sci Clin Res [Internet]. 2020 Oct 27;5(2):97. Available from: https://jurnal.uns.ac.id/jpscr/article/view/38957

Taddele BW, Wondimagegn AA, Asfaw Asaro M, Sorato MM, Gedayi BG, Hailesilase AA. ABC-VEN Matrix Analysis of the Pharmacy Store in a Secondary Level Health Care Facility in Arbaminch Town, Southern Ethiopia. J Young Pharm [Internet]. 2019 May 1;11(2):182–5. Available from: http://www.jyoungpharm.org/article/1314

Damayanti D, Suprapti B, Andarsari MR, Machin A, Hakim LN. ABC-VEN analysis of drug use in outpatients at a neurology department in Indonesia. Pharm Educ [Internet]. 2024 May 1;24(3):63–8. Available from: https://pharmacyeducation.fip.org/pharmacyeducation/article/view/2636

Shaikh Teli E, Bhangale C, Momin K, Ramanand J, Mahajan H. Application of ABC-VED analysis for inventory control in drug store of a tertiary care hospital of North Maharashtra. Perspect Med Res [Internet]. 2022 Aug 30;10(2):61–71. Available from: https://pimr.org.in/2022-vol10-issue-2/originalarticle11_v2.php

Frayudha AD, Pande IR, Juwita MB. Implementation of Black Box Testing with the Application of Equivalence Partitioning Techniques in the M-Magazine Android Application at Semen Gresik High School. Elinvo (Electronics, Informatics, Vocat Educ [Internet]. 2024 Jun 5;9(1):134–43. Available from: http://journal.uny.ac.id/index.php/elinvo/article/view/70382

Putri SJ, Putri DGP, Putra WHN. Analisis Komparasi pada Teknik Black Box Testing (Studi Kasus: Website Lars). J Internet Softw Eng [Internet]. 2024 May 31;5(1):23–8. Available from: https://jurnal.ugm.ac.id/v3/JISE/article/view/9446

Kemenkes RI. Petunjuk Teknis Standar Pelayanan Kefarmasian di Apotek [Internet]. Jakarta: Kemenkes Ditjen Farmalkes; 2019. Available from: https://farmalkes.kemkes.go.id/2020/01/petunjuk-teknis-standar-pelayanan-kefarmasian-di-apotek/

Amer HY, Jawad MK. Inventory Analysis Using the ABC-Ved Matrix - Applied Research in Al-Zawraa State Company. Int J Prof Bus Rev [Internet]. 2023 May 5;8(5):e01508. Available from: https://openaccessojs.com/JBReview/article/view/1508

Satibi, Rokhman MR, Aditama H. Manajemen Apotek. Oktober, 2. Yogyakarta: Gadjah Mada University Press; 2016. 214 p.

Nurul Fatimah Agus A, Astari C, Hurria. Perencanaan Persediaan Obat dengan Metode Analisis ABC-VEN di Instalasi Farmasi RS “Y” Kota Palopo. Media Ilmu Kesehat [Internet]. 2023 Sep 1;12(2):116–28. Available from: https://ejournal.unjaya.ac.id/index.php/mik/article/view/837

Gizaw T, Jemal A. How is Information from ABC–VED–FNS Matrix Analysis Used to Improve Operational Efficiency of Pharmaceuticals Inventory Management? A Cross-Sectional Case Analysis. Integr Pharm Res Pract [Internet]. 2021 Jun;Volume 10:65–73. Available from: https://www.dovepress.com/how-is-information-from-abcvedfns-matrix-analysis-used-to-improve-oper-peer-reviewed-fulltext-article-IPRP