Pengembangan Sistem Informasi Manajemen Inventaris Obat yang Berbasis Metode Economic Order Quantity (EOQ) dan Diimplementasikan dengan PHP-MySQL

Authors

  • Rasyida Shabihah Zukro Aini Sepuluh Nopember Institute of Technology
  • Elsa Sari Hayunah Nurdiniyah Jenderal Soedirman University
  • Muhammad Adib Syamlan Sepuluh Nopember Institute of Technology
  • Mahesa Sangga Bhuwana Widya Kartika University

DOI:

https://doi.org/10.51903/juritek.v5i3.5762

Keywords:

Drug Stock Management, MySQL, PHP, Web

Abstract

Manual drug record-keeping in private pharmacies often results in inefficiency, errors, and data loss, disrupting stock and operational management. To overcome these issues, a web-based drug management system was developed using XAMPP, MySQL, and PHP. The system provides role-based access for managers, admins, and pharmacists, and integrates seven key functions: user registration, login/logout, drug data entry, stock monitoring, EOQ-based stock classification, drug distribution to branch pharmacies, and deletion of invalid stock data. The system enables real-time stock monitoring, reduces error risks, and improves efficiency in managing central and branch pharmacy operations. Its contribution lies in integrating EOQ-based stock classification with inter-branch coordination in a single web platform, strengthening the application of information technology in pharmaceutical management and offering a foundation for future development of pharmacy information systems.

References

[1] E. Lusiana, Imilda, and A. Salam, “Perancangan Sistem Informasi Inventory Obat Berbasis Web Pada Apotek Fadhilah Farma,” J. Sist. Komput. SISKOM, vol. 4, no. 1, pp. 32–44, 2024, doi: 10.35870/siskom.v4i1.810.

[2] E. Ernawaningtyas et al., PENGENALAN TENTANG FARMASI DAN KEFARMASIAN. Sada Kurnia Pustaka, 2023.

[3] A. Supryadi, “DUTIES AND LEGAL RESPONSIBILITIES OF PHARMACISTS IN PHARMACEUTICAL,” Media Keadilan J. Ilmu Huk., vol. 14, p. 110, Apr. 2023, doi: 10.31764/jmk.v14i1.14281.

[4] S. Dewi, N. Nurmalasari, L. Latifah, and N. Putri, “Perancangan Sistem Informasi Penjualan Obat Berbasis Web pada Apotek Amelia Sungai Raya,” J. Sist. Inf. Akunt., vol. 3, pp. 88–99, Sep. 2022, doi: 10.31294/justian.v3i2.1434.

[5] N. Novita, “Manajemen Proyek Sistem Informasi Pengolahan Data Apotek Berbasis Database,” vol. 2.

[6] S. T. Hanafi, W. U. Panjaitan, A. R. Ramadhan, and S. H. Purba, “Penerapan Sistem Informasi Kesehatan di Puskesmas di Indonesia,” Sagita Acad. J., vol. 3, no. 1, pp. 19–23, Jan. 2025, doi: 10.61579/sagita.v3i1.333.

[7] R. Andita, P. Nurul, P. Rachmatullah, S. Akbar, S. Permata, and S. Mulyaningsih, “Analisis dan Perancangan Sistem Informasi Pelayanan Obat di Apotek Generik,” J. Edukasi Dan Penelit. Inform. JEPIN, vol. 2, no. 1, Jun. 2016, doi: 10.26418/jp.v2i1.15463.

[8] D. Aluga, L. A. Nnyanzi, N. King, E. A. Okolie, and P. Raby, “Effect of Electronic Prescribing Compared to Paper-Based (Handwritten) Prescribing on Primary Medication Adherence in an Outpatient Setting: A Systematic Review,” Appl. Clin. Inform., vol. 12, no. 04, pp. 845–855, Aug. 2021, doi: 10.1055/s-0041-1735182.

[9] I. M. S. Ramayu, “RANCANGAN SISTEM INFORMASI PERSEDIAAN STOK OBAT DENGAN METODE SYSTEM DEVELOPMENT LIFE CYCLE DI APOTEK NUSA FARMA NUSA PENIDA,” J. Indones. Manaj. Inform. Dan Komun., vol. 4, no. 1, pp. 110–120, Jan. 2023, doi: 10.35870/jimik.v4i1.130.

[10] A. Sriyani, “Implementasi Aplikasi Penjualan dan Persediaan Obat Berbasis Desktop (Studi Kasus : Apotek Wisa Farma),” J. Inf. Technol., vol. 4, no. 2, pp. 184–192, Nov. 2024, doi: 10.46229/jifotech.v4i2.897.

[11] K. Ruliyanto, S. Andryana, and A. Gunaryati, “Sistem Informasi Manajemen Persediaan Obat Berbasis Web Menggunakan Metode Prototype Pada Apotek,” STRING Satuan Tulisan Ris. Dan Inov. Teknol., vol. 5, no. 3, p. 284, Apr. 2021, doi: 10.30998/string.v5i3.8113.

[12] R. Rasyid, L. Tridinatasya, I. Istiningsih, and R. Widyawati, “PERANCANGAN SISTEM INFORMASI PERSEDIAAN BARANG MENGGUNAKAN METODE ECONOMIC ORDER QUANTITY PADA APOTEK MANDIRI YOGYAKARTA,” J. Inf. Syst. Manag. JOISM, vol. 4, pp. 158–162, Jan. 2023, doi: 10.24076/joism.2023v4i2.934.

[13] F. Agustin, H. Kurniawan, Y. Yusfrizal, and K. Ummi, “Comparative Analysis of Application Quality Between Appserv and Xampp Webserver Using AHP Based On ISO/IEC 25010:2011,” in 2018 6th International Conference on Cyber and IT Service Management (CITSM), Parapat, Indonesia: IEEE, Aug. 2018, pp. 1–5. doi: 10.1109/citsm.2018.8674345.

[14] “MySQL with PHP, Apache and Perl,” in Springer Professional Computing, London: Springer-Verlag, pp. 183–198. doi: 10.1007/1-85233-859-8_15.

[15] S. Tongkaw and A. Tongkaw, “A comparison of database performance of MariaDB and MySQL with OLTP workload,” in 2016 IEEE Conference on Open Systems (ICOS), Langkawi: IEEE, Oct. 2016. doi: 10.1109/icos.2016.7881999.

[16] A. C. Padmasari, A. H. Hernawan, D. Rostika, and Y. Wahyuningsih, “Usability testing of digital map application using hand gesture recognition as a historical learning media for elementary school,” J. Phys. Conf. Ser., vol. 1987, no. 1, p. 012010, Jul. 2021, doi: 10.1088/1742-6596/1987/1/012010.

Downloads

Published

2025-11-30

How to Cite

Rasyida Shabihah Zukro Aini, Elsa Sari Hayunah Nurdiniyah, Muhammad Adib Syamlan, & Mahesa Sangga Bhuwana. (2025). Pengembangan Sistem Informasi Manajemen Inventaris Obat yang Berbasis Metode Economic Order Quantity (EOQ) dan Diimplementasikan dengan PHP-MySQL. Jurnal Ilmiah Teknik Mesin, Elektro Dan Komputer, 5(3), 322–332. https://doi.org/10.51903/juritek.v5i3.5762

Issue

Vol. 5 No. 3 (2025): November: Jurnal Ilmiah Teknik Mesin, Elektro dan Komputer

Section

Articles

License

Copyright (c) 2025 Jurnal Ilmiah Teknik Mesin, Elektro dan Komputer

Creative Commons License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.