HOSPITAL MANAGEMENT SYSTEM: LOGISTICS 2 MEDICINE DISPATCH AND VENDOR SELECTION FOR HOSPITAL SUPPLY CHAINS WITH REAL-TIME TRACKING, EMERGENCY EXPRESS DELIVERIES, MULTI-VENDOR COORDINATION USING MICROSERVICES

Abstract

This capstone project presents a hospital supply logistics management system designed to enhance drug dispensing, vendor management, and supply coordination. Its primary objective is to minimize delays and increase transparency in hospital supply chains through real-time tracking, express emergency delivery, and the use of microservices. Many hospitals still rely on traditional methods, which often result in stockouts, overstocking, and inefficient vendor coordination. To address these challenges, the system incorporates modules for vendor evaluation, emergency dispatch management, and stock tracking with expiry-date reminders. Developed through iterative sprint cycles, each module was designed and tested to ensure system functionality and reliability. The project adopted the Agile Scrum framework, dividing development into sprint cycles that addressed tasks such as database configuration, vendor selection, and order tracking. Key roles in the process included a system analyst, quality assurance staff, and a Scrum Master. The system was built using the MERN stack (MongoDB, Express.js, React.js, and Node.js) and employed microservices to support modular and scalable development. Cloud databases were used to manage vendor and inventory information, complemented by security features such as role-based access control and encryption. Simulations and real-time testing were carried out to evaluate the system’s performance in handling emergency deliveries. Following multiple development cycles and rigorous testing, stock discrepancies were reduced by more than half, with system reports showing over a 90% improvement in inventory management accuracy. Simulated emergency dispatch scenarios demonstrated a nearly 60% reduction in response times. Furthermore, stress testing confirmed that the microservices architecture could sustain very high levels of concurrent transactions, maintaining system stability with nearly 100% uptime in test environments. This project highlighted key challenges in hospital supply chains, particularly in medicine dispatch. To address these, we implemented real-time tracking to notify staff and prioritized emergency express delivery to reduce delays in patient treatment. The use of microservices facilitated system organization, making it easier to test and update, while the Agile Scrum approach enabled efficient workload management. Although issues such as microservices integration and internet reliability posed challenges, the system performed effectively during testing and demonstrates strong potential to streamline hospital logistics and medicine delivery, with further refinements still required.