JOURNAL OF APPLIED INFORMATICS AND COMPUTING
Vol. 9 No. 4 (2025): August 2025

Clustering and Forecasting Implementation for Medical Consumables Stock Reccomendation

Darma, Fahri Setia (Unknown)
Setiadi, Tedy (Unknown)



Article Info

Publish Date
07 Aug 2025

Abstract

Managing medical consumables (BMHP) in hospitals can be tricky because the demand often changes unpredictably. This study aims to help hospitals manage their BMHP stocks better by using two techniques: forecasting with Single Exponential Smoothing (SES) and grouping items using Agglomerative Hierarchical Clustering (AHC). SES is used to predict future needs based on previous usage, while AHC groups similar items based on how they're used, which helps make the predictions more accurate. Before applying clustering, the prediction error was quite high, with a MAPE of 61.77% and an MAE of 18,769.80. After clustering, these numbers dropped to 10.06% and 3,987.45, showing a significant improvement. The clustering itself was strong, with a Silhouette Coefficient of 0.727, meaning the item groups made sense. Each group of items got different stock suggestions. Items with high and unstable demand were advised to keep extra safety stock. Items with uncertain patterns needed a more flexible buffer stock. For items with stable use, average trends over the last few months were enough to guide stock planning. This approach helps hospitals avoid both overstock and stockouts by giving more accurate and tailored recommendations. Although this study only used data from one hospital, the results show that combining SES and AHC can make stock management smarter and more efficient.

Copyrights © 2025






Journal Info

Abbrev

JAIC

Publisher

Subject

Computer Science & IT

Description

Journal of Applied Informatics and Computing (JAIC) Volume 2, Nomor 1, Juli 2018. Berisi tulisan yang diangkat dari hasil penelitian di bidang Teknologi Informatika dan Komputer Terapan dengan e-ISSN: 2548-9828. Terdapat 3 artikel yang telah ditelaah secara substansial oleh tim editorial dan ...