AQILA : Acceleration, Quantum, Information Technology and Algorithm Journal
Vol. 2 No. 1 (2025): VOLUME 2, NO 1: JUNE 2025

A Prognostic System for Pharmaceutical Inventory Forecasting Using the Trend Least Squares Method at Rakha Medika

Yulianti, Evi (Unknown)
Putri, Indah Pratiwi (Unknown)
Marcelina, Dona (Unknown)



Article Info

Publish Date
24 Jun 2025

Abstract

This study proposes the development of a sophisticated predictive system for pharmaceutical inventory management at Rakha Medika, Palembang, aimed at addressing the prevalent challenges associated with inaccurate drug stock forecasting. Employing the Trend Least Squares method, the system leverages historical consumption data to generate precise predictions of future pharmaceutical needs, thereby facilitating optimal procurement strategies and mitigating the risks of both stockouts and surplus inventory. Developed with PHP and MySQL, the system offers a user-friendly web-based interface, providing role-specific access for administrators, warehouse personnel, and senior management, ensuring seamless integration within the existing operational framework. This research highlights the importance of data-driven decision-making in healthcare supply chain management, where the accuracy of stock forecasts directly correlates with the quality-of-service delivery. Through rigorous testing using real-world data, the system demonstrated a significant improvement in forecasting accuracy and operational efficiency, with tangible benefits including reduced administrative burdens and enhanced drug availability. The implementation of this predictive system not only optimizes inventory control but also contributes to the overall enhancement of healthcare services at the public health center.

Copyrights © 2025






Journal Info

Abbrev

aqila

Publisher

Subject

Computer Science & IT Control & Systems Engineering Economics, Econometrics & Finance

Description

Acceleration, Quantum, Information Technology and Algorithm Journal (AQILA)is open to researchers and experts in the fields of computer science, information engineering, quantum computing, and information systems. Serving as a platform for scholars and practitioners, this journal facilitates the ...