BOTika: A Pharmaceutical Management System Using Seasonal Autoregressive Integrated Moving Average (SARIMA) and Clustering Algorithm

This study introduces “BOTika: A Pharmaceutical Management System,” which incorporates the Seasonal Autoregressive Integrated Moving Average (SARIMA) model and a Clustering Algorithm to tackle significant challenges faced by small and medium-sized pharmacies in Metro Manila. BOTika is designed to streamline and enhance pharmaceutical operations, focusing on areas such as inventory control, sales monitoring, profit evaluation, and medication management. Its primary goal is to improve efficiency in pharmacy operations, particularly through predictive analytics powered by the SARIMA model. The system also uses a Retrieval Report Algorithm for data retrieval and Statistical Analytics for data interpretation. Additionally, a Clustering Algorithm is employed to group medicines by key characteristics, enabling targeted discounts and promotions. The system's interface, developed as a Progressive Web App (PWA), allows administrators to manage operations seamlessly, while customers benefit from a pre-order feature. Results demonstrate that the SARIMA model provides accurate demand forecasts, leading to better decision-making in pharmacy management. Ultimately, the project aims to modernize pharmacy operations, enhance customer experience, and support the sector's growth, contributing to both sustainable practices and economic progress in the region.