IDIALU CHARLES ABRAHAM

Effective inventory management is vital in ensuring the continuous availability of essential drugs in community pharmacies. However, many small and medium-sized pharmacies in Nigeria still rely on manual stock records, which are often prone to errors, delays, and inefficiencies. These limitations lead to frequent stock outs, overstocking, and poor decision-making. This project was therefore aimed at developing a low-cost, web-based pharmacy inventory management system that can automate key inventory operations and improve overall stock control efficiency. The system was designed to integrate real-time data entry, sales monitoring, and automatic computation of inventory parameters such as the Economic Order Quantity (EOQ) and the Reorder Point (ROP).
The methodology involved the design and implementation of a web application connected to a PostgreSQL database. The system was built using React.js for the frontend, Node.js with Express for the backend, and MongoDB and PostgreSQL for data management. Data used for analysis were derived from the pharmacy’s 2024 operational records, including sales transactions, purchase orders, and stock levels. Analytical models such as the EOQ and ROP formulas were embedded into the application to enable automated calculation of optimal order quantities and reorder levels. The system’s functionality was evaluated based on its performance in handling more than 15,000 sales records, accuracy in computation, and responsiveness in generating real-time alerts.
The results showed that the system effectively automated stock control processes, minimized manual errors, and significantly improved decision-making speed. The EOQ and ROP computations consistently produced accurate results using a uniform 20% safety stock across all products. Additionally, the system generated automatic reorder alerts