Maulana, Kaka Rizki
Unknown Affiliation

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

Predicting Tablet Drug Expenditures Using Python-Based Facebook Prophet in Pharmaceutical Installations Maulana, Kaka Rizki; Widiyono, Widiyono; Darmawan, Arief Soma
JURNAL TEKNOLOGI DAN OPEN SOURCE Vol. 8 No. 2 (2025): Jurnal Teknologi dan Open Source, December 2025
Publisher : Universitas Islam Kuantan Singingi

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.36378/jtos.v8i2.4907

Abstract

The increasing complexity of pharmaceutical logistics requires accurate forecasting to ensure drug availability and minimize the risk of stock shortages. This study aims to develop a forecasting model to predict monthly tablet drug expenditure in the Pharmacy Department. The research stages include problem identification, data collection from historical drug expenditure records, data pre-processing, and implementation of the forecasting model. The method used is Facebook Prophet, which was chosen for its ability to capture seasonal patterns, trends, and holidays in time series data. Model performance evaluation was conducted using Mean Absolute Percentage Error (MAPE) and Mean Absolute Error (MAE). The results showed that the model produced an MAE of 3,621.25 and a MAPE of 4.93%, indicating that the prediction accuracy level was in the good category. These findings prove that the Prophet method is capable of providing reliable results in drug expenditure forecasting. The results of this study are expected to support decision-making in drug requirement planning and improve the efficiency of pharmaceutical logistics management.