Article Open Access

Application of Data Mining with the Least Square Meth-od to Predict Web-Based Drug Inventory

Abdul Halim, Safwandi Safwandi, Fajriana Fajriana

Abstract


Drug supplies are an important aspect because of their large value and large quantity and are an important factor in supporting health services in community health centers. Ineffective drug management, especially in terms of needs planning, can lead to excess or shortage of stock. Both conditions have negative impacts, such as budget waste, drug expiration, or even disruption of patient services due to unavailability of drugs. At the Pante Bidari Health Center UPTD, the drug needs planning process is still carried out manually or based on rough estimates without using sophisticated technology. This study aims to design and build a web-based drug inventory prediction system using the Least Square method. The Least Square method was chosen because it is able to carry out the forecasting process quickly and with good results. In this study, the type of data obtained is drug usage data, data is grouped based on each supplier, from the health center information system during a certain period. After going through the pre-processing and calculation stages, the predicted values are calculated and displayed through a web-based system designed to be easy to use by health center officers. The web system developed in this study uses PHP as the programming language and MySQL as the database, implementing the Least Square method effectively. The results of this study are a drug usage prediction application for the future, applying the Least Square method, which displays drug usage data over a certain period. The system will present the data in the form of a table. Based on testing the drug usage data for Acyclovir Cream 5 mg from January 2023 to August 2024, the prediction result for the following month, September 2024, is estimated to be 38.415, which is rounded to 38 units of the drug.


Keywords


Data Mining, Least Square, Health Center, Drug Supplies, Web-Based

References


Kementerian Kesehatan Republik Indonesia. (2019). Tentang Pusat Kesehatan Masyarakat. Jakarta: Kemenkes RI.

M. Hatta and A. F. Fitri, “Sistem Prediksi Persediaan Stok Darah Dengan Metode Least Square Pada Unit Transfusi Darah Studi Kasus PMI Kota Cirebon,” Jurnal Ilmiah Ilmu Komputer, vol. 6, no. 1, pp. 19–23, 2020, doi: 10.35329/jiik.v6i1.130.

R. M. Fauzi and D. I. Mulyana, “Implementasi Data Mining Menggunakan Metode Least Square untuk Memprediksi Penjualan Lampu LED pada PT. Sumber Dinamika Solusitama,” Jurnal Sosial dan Teknologi, vol. 1, no. 8, pp. 907–919, 2021, doi: 10.59188/jurnalsostech.v1i8.182.

T. Yasmi, A. Erianda, and R. Afyenni, “Implementasi Metode Least Square untuk Peramalan Persediaan Barang pada Sistem In-ventori CV. Tree Jaya Perkasa,” Jurnal Ilmiah Teknologi Sistem Informasi, vol. 3, no. 4, pp. 137–142, 2022, doi: 10.62527/jitsi.3.4.100.

D. N. Fazira, N. Mulyani, and E. Rahayu, “Prediksi Kebutuhan Bahan Baku Kedelai Di Pabrik Tahu Buk Iyem Menggunakan Metode Least Square,” Jurnal Pendidikan Teknologi Informasi, vol. 3, no. 2, pp. 341–451, 2023, doi: 10.51454/decode.v3i2.203.

Werdiningsih, I., Nuqoba, B., & Muhammadun, S. (2020). Data Mining Menggunakan Android, Weka, dan SPSS. Airlangga Uni-versity Press.

Arhami, M. & Nasir, M. (2020). Data Mining: Algoritma dan Implementasi. Penerbit Andi: Banda Aceh.

Suntoro, J. (2019). DATA MINING: Algoritma dan Implementasi dengan Pemrograman php (Edisi 1). Jakarta: PT. Elex Media Komputindo.

Muflikhah, L., Ratnawato, D. E., & Putri, R. R. M. (2021). Buku Ajar: Data Mining. UB Press: Malang.

Agrawal, C. P., & Agrawal, M. (2017). Introduction to Data Mining. Educreation Publishing: New Delhi.

S. Mulyani, “Manajemen Persediaan Obat di Fasilitas Kesehatan,” Jurnal Manajemen Kesehatan, vol. 12, no. 1, pp. 45–52, 2020.

R. A. Walangadi and I. S. Kumala, “Prediksi Penjualan Motor Dengan Menggunakan Metode Least Square,” Jurnal COSPHI, vol. 3, no. 2, 2019.

M. Sadli and Safwandi, “Implementasi Sistem Cerdas Least Square Dalam Meramalkan Pemenuhan Kebutuhan Stok Listrik Di Kota Lhokseumawe,” Jurnal Ecotipe, vol. 4, no. 2, pp. 21–29, 2017, doi: 10.33019/ecotipe.v4i2.8.

C. A. Putra and A. R. Ardhana, “Implementasi Algoritma Least Square Untuk Pembuatan Sistem Prediksi Prof-it Bulanan,” SCAN, vol. 18, pp. 13–17, 2023, doi: 10.33005/scan.v18i1.3829.

D. Suwardiyanto, M. N. Shodiq, D. H. Kusuma, and T. O. Sari, “Sistem Prediksi Kebutuhan Obat di Puskesmas Menggunakan Metode Least Square,” Jurnal Pengembangan IT (JPIT), vol. 4, no. 1, pp. 75–80, 2019, doi: 10.30591/jpit.v4i1.1085.

Madcoms. (2016). Kupas Tuntas Adobe Dreamweaver CS6 dengan Pemograman PHP dan MySQL. Yogyakarta: Andi Publisher.

B. Abimanyu, R. Safe’I, and W. Hidayat, “Analisis Kerusakan Pohon Di Hutan Kota Stadion Kota Metro Provinsi Lampung,” Jurnal Hutan Pulau Kecil, vol. 3, no. 1, 2019. [Online]. Available: https://ojs3.unpatti.ac.id/index.php/jhppk/article/view/1317

Abdulloh, R. (2018). 7 in 1 Pemograman Web Untuk Pemula. Jakarta: PT. Elex Media Komputindo.

Enterprise, J. (2017). Otodidak Pemograman Database dengan Visual Basic. Jakarta: PT. Elex Media Komputindo.

Sukmawati, R. (2022). Pengantar Basis Data: Konsep dan Implementasi MySQL. Yogyakarta: Penerbit Andi.




DOI: https://doi.org/10.52088/ijesty.v5i3.897

Refbacks

  • There are currently no refbacks.


Copyright (c) 2025 Abdul Halim, Safwandi, Fajriana

International Journal of Engineering, Science, and Information Technology (IJESTY) eISSN 2775-2674