Forecasting Drug Demand Using The Single Moving Average At Prof. dr. I.G.N.G. Ngoerah Hospital

https://doi.org/10.22146/farmaseutik.v19i3.86207

Endang Yuniarti(1*)

(1) RS PKU Muhammadiyah Yogyakarta Universitas Muhammadiyah Gombong
(*) Corresponding Author

Abstract


Problems that often occur in inventory planning are excess and shortages of drug supplies. The single moving average (SMA) forecasting smooths drug demand data fluctuations. This study aims to see the potential and magnitude of errors using the SMA method based on the MAPE values. This research is non-experimental descriptive research. The study sample was the seven highest order drug items based on category A of the ABC analysis results in 2020 and 2021. The sampling technique was purposive sampling using retrospective data. The results obtained were highly accurate forecasting (MAPE <10%) for four drug items, namely Human Albumin 20% Injection 100 mL (MAPE = 2%), Eksemestan 25 mg tablets (MAPE = 3%), Trastuzumab 440 mg/20 mL injection (MAPE = 4%), Deferasirok 500 mg tablets (MAPE = 3%); Good forecasting (MAPE = 10-20%) for one drug item, namely Nilotinib 200 mg capsules (MAPE = 16%), and Reasonable forecasting (20-50%) for two drug items, namely Ifosfamide injection 1 gram (MAPE = 35%), Fentanyl injection 100 mcg / 2 mL (MAPE = 23%) with an average MAPE value of 12%. This study concluded that Prof. Dr. I.G.N.G. Ngoerah Denpasar Hospital could use the SMA forecasting method.


Keywords


Pharmaceutical Forecasting, Single Moving Average, MAPE

Full Text:

PDF


References

Agustian, H., Pujiastuti, A., Sayoga, M.V., 2020. Comparison Of Simple Moving Average and Exponential Smoothing Methods To Predict Seaweed Prices. CCIT Journal 13, 175–184.

https://doi.org/10.33050/ccit.v13i2.1033

Astuti, Y., Novianti, B., Hidayat, T., Maulina, D., 2019. Penerapan Metode Single Moving Average untuk Peramalan Penjualan Mainan Anak, Sensitif 1, 253–261.

Azhari, Y., Azhar, Z., Nehe, N., 2022. Prediksi Persediaan Kedelai Di Ud Tahu Home Industry Dengan Menggunakan Metode Single Moving Average. JUTSI (Jurnal Teknologi Dan Sistem Informasi) 2, 121–128.

https://doi.org/10.33330/jutsi.v2i2.1696

Aziza, J.N.A., 2022. Perbandingan Metode Moving Average, Single Exponential Smoothing, dan Double Exponential Smoothing Pada Peramalan Permintaan Tabung Gas LPG PT Petrogas Prima Services. Jurnal Teknologi dan Manajemen Industri Terapan 1, 35–41. https://doi.org/10.55826/tmit.v1iI.8

Chatfield, 2000. Time-Series Forecasting, 2nd ed. Chapman & C Hall / CRC, USA.

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, 113–125. https://doi.org/10.26623/transformatika.v16i2.1047.

Fauziah, L., Fauziah, F., 2022. Penerapan Metode Single Exponential Smoothing dan Moving Average Pada Prediksi Stock Produk Retail Berbasis Web. STRING 7, 159-168. https://doi.org/10.30998/string.v7i2.13932

Ginantra, N.L.W.S.R., Anandita, I.B.G., 2019. Penerapan Metode Single Exponential Smoothing Dalam Peramalan Penjualan Barang. J-SAKTI (Jurnal Sains Komputer dan Informatika) 3, 433–441.

https://doi.org/10.30645/j-sakti.v3i2.162

Hady, S., Hamsinar, H., Hardiyanti, R.P., 2022. Penerapan Data Mining dengan Metode Single Moving Average untuk Menentukan Jumlah Penjualan Obat. Jurnal Informatika 11, 166-175. https://doi.org/10.55340/jiu.v11i2.1051

Hay’s, R. naufal, Anharudin, Adrean, R., 2017. Sistem Informasi Inventory Berdasarkan Prediksi Data Penjualan Barang Menggunakan Metode Single Moving Average Pada CV.Agung Youanda. ProTekInfo(Pengembangan Riset dan Observasi Teknik Informatika) 4, 29–33. https://doi.org/10.30656/protekinfo.v4i0.409

Hayuningtyas, R.Y., Sari, R., 2021. Aplikasi Peramalan Alat Kesehatan Menggunakan Single Moving Average. Infortech 3, 40–45.

https://doi.org/10.31294/infortech.v3i1.10397

Hudaningsih, N., Utami, S.F., Jabbar, W.A.A., 2020. Perbandingan Peramalan Penjualan Produk Aknil Pt.Sunthi Sepuri mengguanakan Metode Single Moving Average dan Single Exponential Smooting. Jurnal Informatika Teknologi dan Sains (Jinteks) 2, 15–22. https://doi.org/10.51401/jinteks.v2i1.554

Kemenkes RI. 2016. Permenkes Nomor 72 Tahun 2016. Kementrian Kesehatan Republik Indonesia, Jakarta

Kemenkes RI. 2019. Petunjuk Teknis Standar Pelayanan Kefarmasian di Rumah Sakit. Kementrian Kesehatan Republik Indonesia, Jakarta

Kurnia, N., 2022. Penerapan Peramalan Penjualan Sembako Menggunakan Metode Single Moving Average (Studi Kasus Toko Kelontong Dedeh Retail). Infinity: Jurnal Matematika dan Aplikasinya 2, 93–103. https://doi.org/10.5281/ZENODO.7076573

Makridakis, Wheelwright, Hyndman, 2018. Forecasting, Methods and Applications, 3rd ed. Wiley India Pvt. Limited, India.

Montaño Moreno, J.J., Palmer Pol, A., Sesé Abad, A., 2013. Using the R-MAPE Index as a Resistant Measure Of Forecast Accuracy. Psicothema 25, 500–506. https://doi.org/10.7334/psicothema2013.23

Montgomery, D.C., Jennings, C.L., Kulahci, M., 2015. Introduction to Time Series Analysis and Forecasting. John Wiley & Sons, USA.

Nathania, C.J., Iskandar, F.R., Wicaksonoputra, A.F., Nurcahyo, R., 2021. Production Planning Forecasting using Single Moving Average and Exponential Smoothing Method in PT. Semen Indonesia. IEOM Society International 1, 324–330.

Puspikaryani, G.A.P., Iin Kristanti, I.G.A.M., Wibawa, I.M.A.Y., 2022. Strategi Perencanaan dan Pengadaan Obat Dalam Penanganan Pandemi Covid-19 di Instalasi Farmasi RSUD Bali Mandara. Majalah Farmaseutik 18, 85-89. https://doi.org/10.22146/farmaseutik.v18i1.71902

Render, Stair, Hanna, 2015. Quantitative Analysis For Management, 13th ed. Pearson, United Kingdom

Rosmania, F., Supriyanto, S., 2015. Analisis Pengelolaan Obat Sebagai Dasar Pengendalian Safety Stock pada Stagnant dan Stockout Obat. Jurnal Administrasi Kesehatan Indonesia 3, 1-10. https://doi.org/10.20473/jaki.v3i1.2015.1-10.

Rusdiana, S., Yuni, S.M., Khairunnisa, D., 2020. Comparison of Rainfall Forecasting in Simple Moving Average (SMA) and Weighted Moving Average (WMA) Methods (Case Study at Village of Gampong Blang Bintang, Big Aceh District-Sumatera-Indonesia. Journal of Research in Mathematics Trends and Technology 2, 21–27. https://doi.org/10.32734/jormtt.v2i1.3753

Sam, M., Kurniawati, E., Fausia, S.R., 2022. Peramalan Permintaan Smartphone Oppo Android Menggunakan Metode Single Moving Average. Infinity: Jurnal Matematika dan Aplikasinya 2, 93–103.

https://doi.org/10.30605/27458326-93-103

Satibi, S., 2016. Manajemen Obat di Rumah Sakit.

Suryagama, D., Satibi, S., Sumarni, S., 2019. Analisis Perencanaan dan Ketersediaan Obat di Kabupaten dan Kota Provinsi Jawa Timur. Jurnal Manajemen Dan Pelayanan Farmasi (Journal of Management and Pharmacy Practice) 9, 243–251. https://doi.org/10.22146/jmpf.44444

Suryana Asrul Sani, 2018. Perbandingan Metode Peramalan Beban Listrik Jangka Pendek Menggunakan Metode Moving Average, Single Exponential Smoothing dan Autoregressive Moving Average di Yogyakarta.



DOI: https://doi.org/10.22146/farmaseutik.v19i3.86207

Article Metrics

Abstract views : 122 | views : 9

Refbacks

  • There are currently no refbacks.


Majalah Farmaseutik Indexed by:

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