COMPARISON OF FORECASTING DRUG NEEDS USING TIME SERIES METHODS IN HEALTHCARE FACILITIES: A SYSTEMATIC REVIEW
DOI:
https://doi.org/10.31603/pharmacy.v10i2.11145Keywords:
Exponential smoothing, Forecasting, Healthcare facilities, Moving averageAbstract
Drug planning is essential to ensure the fulfillment of the right type, amount, and time criteria. Forecasting can be utilized during the planning stage to predict future drug needs. Perfect forecasting is impossible due to uncertainties in various factors, necessitating selecting the best method. This study aimed to identify the optimal forecasting method for healthcare facilities based on the smallest Mean Absolute Deviation (MAD), Mean Square Error (MSE), and Mean Absolute Percent Error (MAPE) values obtained from forecasting results using time series methods like Single Moving Average (SMA), Weight Moving Average (WMA), (Single Exponential Smoothing) SES, Double Exponential Smoothing (DES), and Triple Exponential Smoothing (TES). This research involved a descriptive observational study with retrospective data and adhered to PRISMA guidelines. PubMed, Google Scholar, and Garuda served as the data sources. Nine articles meeting the eligibility criteria were employed. The findings revealed that the SES, DES, and TES methods produced forecasts with MAPE values below 10%, indicating highly accurate forecasting. The MAPE values for the SMA and WMA methods were less than 50%, which is still acceptable. Therefore, the ES methods, particularly SES, are highly recommended for accurate drug planning. Forecasting accuracy factors include data stability, pattern consistency, and smoothing constants. The SES method emerged as the best forecasting method, generating the smallest MAD, MSE, and MAPE values compared to other methods, falling below 10%, reflecting highly accurate forecasting.
References
Ahmad, F. (2020). Penentuan Metode Peramalan Pada Produksi Part New Granada Bowl St Di PT.X. JISI: Jurnal Integrasi Sistem Industri, 7(1), 31. https://doi.org/10.24853/jisi.7.1.31-39
Aji, B. G., Sondawa, D. C. A., Anindika, F. A., & Januarita, D. (2022). Analisis Peramalan Obat Menggunakan Metode Simple Moving Average, Weighted Moving Average, Dan Exponential Smoothing. JURIKOM (Jurnal Riset Komputer), 9(4), 959. https://doi.org/10.30865/jurikom.v9i4.4454
Box, G. E. P., Jenkins, G. M., Reinsel, G. C., & Ljung, G. M. (2015). Time Series Analysis (Fifth Edition). Wiley.
Dewi, E. N. S., & Chamid, A. A. (2019). Implementation of Single Moving Average Methods For Sales Forecasting Of Bag In Convection Tas Loram Kulon. Jurnal Transformatika, 16(2), 113.
https://doi.org/10.26623/transformatika.v16i2.1047
Eris, P. N., Nohe, D. A., & Wahyuningsih, S. (2014). Peramalan Dengan Metode Smoothing dan Verifikasi Metode Peramalan Dengan Grafik Pengendali Moving Range (MR) (Studi Kasus: Produksi Air Bersih di PDAM Tirta Kencana Samarinda). Jurnal EKSPONENSIAL, 5(2), 203–210.
Fachrurrazi, S. (2015). Peramalan Penjualan Obat Menggunakan Metode Single Exponential Smoothing Pada Toko Obat Bintang Geurugok. Techsi, 6(1), 19–30.
Fajrul, M., Satra, R., & Ilmawan, L. B. (2022). Aplikasi Prediksi Permintaan Peralatan Sarang Walet Menggunakan Metode Double Exponential Smoothing Berbasis Android. Buletin Sistem Informasi dan Teknologi Islam, 3(3), 188–195. https://doi.org/10.33096/busiti.v3i3.1348
Falani, I. (2018). Penentuan Nilai Parameter Metode Exponential Smoothing Dengan Algoritma Genetik Dalam Meningkatkan Akurasi Forecasting. Computer Engineering, Science and System Journal, 3(1), 14. https://doi.org/10.24114/cess.v3i1.8268
Febriyanti, A. N., & Rifai, N. A. K. (2022). Metode Triple Exponential Smoothing Holt-Winters untuk Peramalan Jumlah Penumpang Kereta Api di Pulau Jawa. Bandung Conference Series: Statistics, 2(2), 152–158. https://doi.org/10.29313/bcss.v2i2.3560
Ginantra, N. L. W. S. R., & Anandita, I. B. G. (2019). Penerapan Metode Single Exponential Smoothing Dalam Peramalan Penjualan Barang. J Sains Komput Inform J-SAKTI, 3(2), 433–441.
Gustriansyah, R. (2017). Analisis Metode Single Exponential Smoothing Dengan Brown Exponential Smoothing Pada Studi Kasus Memprediksi Kuantiti Penjualan Produk Farmasidi Apotek. Seminar Nasional Teknologi Informasi dan Multimedia 2017. 7-12.
Heizer, J., & Render, B. (2016). Manajemen Operasi (Manajemen Keberlangsungan dan Rantai Pasokan) (Edisi 11). Salemba Empat.
Hendriani, T., Yamin, M., & Dewi, A. P. (2016). Sistem Peramalan Persediaan Obat Dengan Metode Weight Moving Average Dan Reorder Point (Studi Kasus: Puskesmas Soropia). SEMANTIK, 2(2), 207–214.
Hernadewita, Hadi, Y. K., Syaputra, M. J., & Setiawan, D. (2020). Peramalan Penjualan Obat Generik Melalui Time Series Forecasting Model Pada Perusahaan Farmasi di Tangerang: Studi Kasus. Journal Industrialengineering&Management Research( JIEMAR), 1(2), 35–49. https://doi.org/10.7777/jiemar.v1i2
Hudaningsih, N., Firda Utami, S., & Abdul Jabbar, W. A. (2020). Perbandingan Peramalan Penjualan Produk Aknil PT.Sunthi Sepuri Mengguanakan Metode Single Moving Average Dan Single Exponential Smooting. Jurnal Informatika, Teknologi dan Sains, 2(1), 15–22. https://doi.org/10.51401/jinteks.v2i1.554
Junita, T. P., & Primandari, A. H. (2023). Perbandingan Metode Double Exponential Smoothing dan Metode Triple Exponential Smoothing untuk Harga Telur pada Produsen Di Kabupaten Sukabumi: Perbandingan Metode Double Exponential Smoothing dan Metode Triple Exponential. Emerging Statistics and Data Science Journal, 1(2), 204–214. https://doi.org/10.20885/esds.vol1.iss.2.art21
Kemenkes, R. (2019). Pedoman Penyusunan Rancangan Kebutuhan Obat dan Pengendalian Persediaan Obat di Rumah Sakit. Kementrian Kesehatan Republik Indonesia.
Kristianto, R. P., Utami, E., & Lutfi, E. T. (2017). Penerapan Algoritma Forecasting Untuk Prediksi Penderita Demam Berdarah Dengue Di Kabupaten Sragen. Seminar Nasional Teknologi Informasi dan Multimedia 2017, 2(1), 55–60.
Laurensia, V., Achmad, G. N. V., Diniya, R., & Soeliono, I. (2020). Evaluasi Perencanaan Persediaan Antibiotik Secara Kuantitatif Di Instalasi Farmasi Rumah Sakit Tipe A. JURNAL MANAJEMEN DAN PELAYANAN FARMASI (Journal of Management and Pharmacy Practice), 10(3), 176. https://doi.org/10.22146/jmpf.49035
Lusiana, A., & Yuliarty, P. (2020). Penerapan Metode Peramalan (Forecasting) Pada Permintaan Atap Di Pt X. Industri Inovatif : Jurnal Teknik Industri, 10(1), 11–20. https://doi.org/10.36040/industri.v10i1.2530
Montgomery, D. C., Jennings, C. L., & Kulahci, M. (2015). Introduction to Time Series Analysis and Forecasting. Wiley Series in Probability and Statistics.
Nangi, J., Indrianti, S. H., & Pramono, B. (2018). Peramalan Persediaan Obat Menggunakan Metode Triple Exponential Smoothing (TES) (Studi Kasus: Instalasi Farmasi RSUD Kab. Muna). SEMANTIK, 4(1), 135–142.
Nu, M., Rizki, E. N., Karim, A. A., & Sari, R. K. (2024). Peramalan Jumlah Penumpang Domestik Pada Bandar Udara Sultan Syarif Kasim II Dengan Menggunakan Metode Winter’s Exponential Smoothing. Jurnal Teknologi dan Manajemen Industri Terapan, 3(1), 57–66. https://doi.org/10.55826/tmit.v3iI.302
Puspitasari, A., Satibi, S., Yuniarti, E., & Taufiqurohman, T. (2022). Forecasting Drug Demand Using The Single Moving Average 3 Periode At Ugm Academic Hospital. Jurnal Farmasi Sains Dan Praktis, 8(3), 233–242. https://doi.org/10.31603/pharmacy.v8i3.7130
Rizqi, M., Cahya, A., & Maida, N. E. (2021). Implementasi Metode Weighted Moving Average Untuk Sistem Peramalan Penjualan Markas Coffee. INFORMAL: Informatics Journal, 6(3), 154. https://doi.org/10.19184/isj.v6i3.28467
Romaita, D., Bachtiar, F. A., & Furqon, M. T. (2019). Perbandingan Metode Exponential Smoothing Untuk Peramalan Penjualan Produk Olahan Daging Ayam Kampung (Studi Kasus: Ayam Goreng Mama Arka). Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, 3(11), 10384–10392. http://j-ptiik.ub.ac.id
Sabarina, A. M., Rustamaji, H. C., & Himawan, H. (2021). Prediction Of Drug Sales Using Methods Forecasting Double Exponential Smoothing (Case Study: Hospital Pharmacy of Condong Catur). Telematika : Jurnal Informatika dan Teknologi Informasi, 18(1), 106. https://doi.org/10.31315/telematika.v18i1.4586
Saepulloh, I., & Handoko, Y. (2018). Forecasting Kebutuhan Obat Menggunakan Metode Pola Konsumsi, Pola Mordibitas dan Winter’s Exponential Smoothing di RS Paru Dr.H.A Rotinsulu Bandung. Jurnal Tata Kelola dan Kerangka Kerja Teknologi Informasi, 4(1), 9–14. https://doi.org/10.34010/jtk3ti.v4i1.1393
Safitri, T., Dwidayati, N., & Sugiman. (2017). Perbandingan Peramalan Menggunakan Metode Exponential Smoothing Holt-Winters dan ARIMA. UNNES Journal of Mathematics, 6(1), 48–58.
Santiari, N. P. L., & Rahayuda, I. G. S. (2021). Analisis Perbandingan Metode Single Exponential Smoothing dan Single Moving Average dalam Peramalan Pemesanan. 6(2).
Sari, P. P., Hidayat, A. T., & Wijaya, H. O. L. (2023). Prediksi Penjualan Obat Menggunakan Metode Forecasting Exponential Smooting Models (Kasus pada Apotek Simpang F). BRAHMANA : Jurnal Penerapan Kecerdasan Buatan, 4(2), 129–137.
Satibi. (2014). Manajemen Obat Di Rumah Sakit. Universitas Gadjah Mada.
Sesario, R., Duha, T., Alfiah, A., Pramono, S. A., & Cakranegara, P. A. (2022). Single Exponential Smoothing In Forecasting Tools And Medicine Stocks. JURNAL INFOKUM, 10(4), 27–32. http://infor.seaninstitute.org/index.php/infokum/index
Setyawan, H., Fitriasih, S. H., & Vulandari, R. T. (2021). Implementasi Metode Penghalusan Ekponensial Tunggal Dalam Prediksi Penjualan Buku. Jurnal Teknologi Informasi dan Komunikasi (TIKomSiN), 9(2), 1. https://doi.org/10.30646/tikomsin.v9i2.539
Sophia, E., Maknunah, J., & Oktavianda, M. D. (2021). Sistem Informasi Peramalan Obat Alphamol Menggunakan Metode Double Exponential Smoothing. SMATIKA JURNAL, 11(01), 53–59. https://doi.org/10.32664/smatika.v11i01.567
Sudarthio, A. T. S., Mulyawan, B., & Haris, D. A. (2020). Aplikasi E-Commerce Berbasis Web Menggunakan Metode Weighted Moving Average Dan K-Medoids. Jurnal Ilmu Komputer dan Sistem Informasi, 8(1), 31. https://doi.org/10.24912/jiksi.v8i1.11461
Vimala, J., & Nugroho, A. (2022). Forecasting Penjualan Obat Menggunakan Metode Single, Double, Dan Triple Exponential Smoothing ( Studi Kasus: Apotek Mandiri Medika). IT-Explore: Jurnal Penerapan Teknologi Informasi dan Komunikasi, 1(2), 90–99. https://doi.org/10.24246/itexplore.v1i2.2022.pp90-99
Yuniarti, R. (2021). Analisa Metode Single Exponential Smoothing Sebagai Peramalan Penjualan Terhadap Penyalur Makanan (Studi Kasus: Lokatara Dimsum). Aliansi : Jurnal Manajemen dan Bisnis, 15(2), 29–34. https://doi.org/10.46975/aliansi.v15i2.63
