Forecasting Drug Needs Using the Single Exponential Smoothing Method at Ibnu Sina Regional Hospital, Gresik Regency

Authors

  • Bintang Azmi Nabilah Muhammadiyah University of Gresik, Gresik, Indonesia
  • Abi Hanif Dzulquarnain Muhammadiyah University of Gresik, Gresik, Indonesia

DOI:

https://doi.org/10.38035/dijms.v6i6.5211

Keywords:

Forecasting, Single Exponential Smoothing, Inventory Management

Abstract

This study was conducted at Ibnu Sina Regional Hospital in Gresik Regency with the aim of improving the accuracy of drug demand forecasting. The main issue in the hospital's drug inventory management is the inaccuracy in estimating demand, which leads to the risk of stock shortages or surpluses and disrupts healthcare services. The study seeks to compare the effectiveness of the currently used consumption-based method with the Single Exponential Smoothing method as a more adaptive alternative to changes in demand. A descriptive approach was used, utilizing historical order and usage data of ten selected generic drugs from July to December 2023. Forecasting accuracy was evaluated using the Mean Absolute Percentage Error (MAPE) indicator. The results indicate that the Single Exponential Smoothing method provides higher accuracy compared to the consumption method, with MAPE values below 10% for most of the drug data. Therefore, this method is more effective in minimizing forecasting errors and supports more efficient and timely drug procurement decisions. The study concludes that implementing the Single Exponential Smoothing method can enhance drug inventory management and is worth considering as the basis for a hospital drug demand forecasting system.

References

Ardiansyah, R., Handayani, L., & Nugroho, W. S. (2019). Perbandingan Metode Konsumsi dan Metode Exponential Smoothing dalam Perencanaan Kebutuhan Obat di Instalasi Farmasi Rumah Sakit. Jurnal Farmasi Indonesia, 6(2), 134–141.

Bagus, P., Putra Budiartha, P., Wiedyaningsih, C., Yuniarti, E., Agung, A., & Prithadewi, A. (n.d.). Forecasting Drug Demand Using The Single Moving Average At Prof. dr. I.G.N.G. Ngoerah Hospital. Majalah Farmaseutik, 19(3), 2023. https://doi.org/10.22146/farmaseutik.v19i3.86207

Hanif Dzulquarnain, A., & Kirono, I. (n.d.). Penerapan Konsep Supply Chain Sediaan Farmasi pada Layanan Kesehatan di Kota Surabaya Studi Kasus pada Puskesmas Sentral di Kota Surabaya. https://journal.unimma.ac.id

Heizer, J., Render, B., & Munson, C. (2020). Operations Management: Sustainability and Supply Chain Management (13th ed.). Pearson Education.

Hernowo, B. S., Puspitasari, H., & Dewi, F. S. (2020). Analisis Perencanaan Kebutuhan Obat Menggunakan Metode Konsumsi di Masa Krisis Kesehatan. Jurnal Manajemen Dan Pelayanan Farmasi, 10(3), 210–217.

Hyndman, R. J., & Athanasopoulos, G. (2021). Forecasting: Principles and Practice (3rd ed.). OTexts.

Indras Wari, N., Ahid Mudayana, A., Kesehatan Masyarakat, F., Ahmad Dahlan, U., & Author, C. (2022). Analisis Pengadaan Obat Menggunakan Metode Konsumsi di Bagian Logistik Farmasi Rumah Sakit Nur Hidayah Bantul. International Journal of Healthcare Research, 5, 23–36. https://doi.org/10.12928/ijhr.v3i1.xxx

Lewis, C. D. (1982). Industrial and Business Forecasting Methods: A Practical Guide to Exponential Smoothing and Curve Fitting. Butterworths.

Makridakis, S., Spiliotis, E., & Assimakopoulos, V. (2008). The accuracy of forecasting: An empirical comparison of the accuracy of different forecasting methods. International Journal of Forecasting, 24(1), 1–18.

Makridakis, S., Wheelwright, S. C., & Hyndman, R. J. (1998). Forecasting: Methods and Applications (3rd ed.). Wiley.

Nahmias, S., & Olsen, T. L. (2021). Production and Operations Analysis (8th ed.). Waveland Press.

Rahmawati, N. D., Wibowo, A., & Yulianty, N. D. (2021). Peramalan penjualan produk menggunakan metode Weighted Moving Average. Jurnal Teknologi Dan Manajemen Informatika, 7(1), 37–43.

Rahmawati, N., Putri, A. F., & Nugrohoi, H. (2020). Evaluasi Peramalan Permintaan Obat Menggunakan Metode Time Series. Jurnal Ilmu Dan Teknologi Kesehatan, 8(1), 45–53.

Sugiyono. (2017). Metode Penelitian Kualitatif, Kuantitatif, dan R&D. Alfabeta.

Yulianti, D., & Andriani, R. (2021). Analisis Perbandingan Metode Peramalan dalam Manajemen Persediaan Obat di Rumah Sakit. Jurnal Farmasi Klinik & Komunitas, 10(2), 112–119.

Published

2025-08-09

How to Cite

Nabilah, B. A., & Dzulquarnain, A. H. (2025). Forecasting Drug Needs Using the Single Exponential Smoothing Method at Ibnu Sina Regional Hospital, Gresik Regency. Dinasti International Journal of Management Science, 6(6), 1414–1425. https://doi.org/10.38035/dijms.v6i6.5211