Design and implementation of a web based drug inventory management system

Project Abstract

The design and implementation of a web-based drug inventory management system is crucial in modern healthcare facilities to ensure efficient management of medication supplies, reduce errors, and streamline inventory tracking processes. This research project focuses on developing a user-friendly system that will enable healthcare providers to monitor drug inventory levels, track expiration dates, generate reports, and streamline the ordering process. The system will be designed to provide real-time updates on drug stock levels, alert users when supplies are running low, and facilitate easy reordering through automated notifications. By implementing this web-based system, healthcare facilities can reduce the risk of stockouts, prevent medication errors, and optimize their inventory management practices. The proposed system will feature a secure login system to restrict access to authorized personnel only, ensuring patient confidentiality and data security. It will also include a comprehensive database to store information about each medication, including dosage, expiration date, supplier details, and usage instructions. This database will be easily searchable, allowing users to quickly locate specific medications and monitor their availability. Moreover, the system will incorporate reporting functionalities to generate detailed reports on medication usage, stock levels, and expiration dates. These reports can be used by healthcare administrators to identify trends, make informed purchasing decisions, and optimize inventory levels to meet patient needs effectively. The web-based drug inventory management system will be developed using modern web technologies to ensure compatibility with various devices and browsers. It will be designed with a responsive user interface to provide a seamless experience across desktop computers, tablets, and smartphones. The system will also be scalable to accommodate the needs of healthcare facilities of different sizes, from small clinics to large hospitals. Overall, the design and implementation of a web-based drug inventory management system will revolutionize the way healthcare facilities manage their medication supplies. By leveraging technology to automate inventory tracking, streamline ordering processes, and enhance reporting capabilities, this system will help healthcare providers improve patient safety, reduce costs, and optimize their medication management practices.

Project Overview

<p> </p><div><ol><li><strong></strong></li></ol></div> <div><p><strong>1.0 &nbsp; &nbsp; &nbsp; INTRODUCTION</strong></p><p>This chapter discusses the background to the study, statement of the problem, objectives of study, significance of study, scope of study, limitations of study and operational definition of terms.</p><p><strong>1.1 &nbsp; &nbsp; &nbsp; BACKGROUND OF STUDY</strong></p><p>The control and maintenance of inventory is a vital problem experienced almost by all sectors of the economy. This topic is very important, as all organizations deal with inventories on a daily basis. Neglecting the importance of inventory in any organization can lead to the closing down of the company, especially if the factors of production are not well managed in order to meet customers’ needs or desires, the company will grind to a halt. The inventory problem consists of having sufficient items available when desired by the customers. The stock of items must be reasonable, meaning that it should not be too much or too little. The company should be in a position to meet customers’ demand in terms of quantity and quality</p><p>Drug inventory management is a key management function in hospital administration particularly in Federal Medical Centers Bida. The purchasing, storing, distributing and controlling of drugs are activities in drug management process which have the ultimate aim of improving patient care in the various medical centers. Hospital pharmacies throughout Nigeria may be experiencing inventory problems that have resulted in wastage and shortage of drugs due to the use of inefficient (existing manual process) &nbsp; The obvious outcome of this problem is a retrogressive effect &nbsp; on patient care due to delayed procedures and drug substitutions (Fox and Tyler 2003).</p><p></p><p>While some drug shortages are uncontrollable (e.g. due to a natural disaster), others can be controlled. Inventory, which is a result of the purchasing process, must be well controlled. However, based on daily activities performed in the hospital pharmacy, the main concerns regarding managing inventory occur during purchasing process. It is problematic and time consuming to decide when and how much to order. &nbsp; Improper inventory management can also result from the procurement expertise of those managing the inventory (Alverson, 2003). Although pharmacists in hospitals have expertise in the efficacy and treatment protocols of drugs that are administered to patients, they are also tasked with managing, ordering, and producing the drugs that are ultimately dispensed to patients</p><p></p></div><div><p><strong>1.2 &nbsp; &nbsp; &nbsp; STATEMENT OF PROBLEM</strong></p><p>Due to problem been faced with the existing file method of inventory management. There are two foremost statements of the problem which is to be solved by the proposed Centralized Inventory system:</p><p>a. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No automated process to manipulate data; currently Pharmacy Department of FMC, Bida does not have an automated inventory system. All process of drug management is done at file-base record level thus to manipulate drug such as add, delete. or edit is not available.</p><p>b. &nbsp; &nbsp; &nbsp; &nbsp; Pharmacist consistent error on multiple or under ordering of drugs.</p><p>c. &nbsp; &nbsp; &nbsp; No accurate mechanism to remind for critical quantity of each drug.</p><p><strong>1.3 &nbsp; &nbsp; OBJECTIVES OF THE STUDY</strong></p><p>Aim: This project is aimed to develop Web-based Drug Inventory Management System to automate and support the current process of drug inventory and distribution between FMC, Bida and its Units</p><p>The objectives of this project are:</p><p>a. &nbsp; &nbsp; &nbsp; To explore issues associated with the current file based record of drug inventory and distribution process in FMC, Bida.</p><p>b. &nbsp; &nbsp; To develop a Web-based Drug Inventory Management System prototype for FMC, Bida</p><p><strong>1.4 &nbsp; &nbsp; &nbsp; SIGNIFICANT OF THE STUDY</strong></p><p>The designing and implementing of Web-based Drug Inventory Management System is in view to enhance and eliminate all obvious lapses in the pharmacy department, such as; missing drugs, files, unaccounted monies etc. Because an automated process of drug inventory will record and store /backup information in its main and back-up memories, which can be retrieved at a press of button</p><p><strong>1.5 &nbsp; &nbsp; SCOPE OF THE STUDY</strong></p><p>There are five units in the pharmacy department at the Federal Medical Center, Bida and two out-units. One situated at Gawu-Babangida and the other at Zungeru all in Niger state. These out units are autonomous, while the Pharmacy units in Bida center are</p><p>· &nbsp; &nbsp; &nbsp; &nbsp; National insurance health services (NHIS) Unit</p><p>· &nbsp; &nbsp; &nbsp; &nbsp; Accident &amp; Emergency (A&amp;E) Unit</p><p>· &nbsp; &nbsp; &nbsp; &nbsp; Obstetrics &amp; Gynaecology (O&amp;G) Unit</p><p>· &nbsp; &nbsp; &nbsp; &nbsp; Paediatrics Unit</p><p>· &nbsp; &nbsp; &nbsp; &nbsp; General Out-patient Clinic (GOPC) Unit</p><p>and a central store, where all drugs is stored to serve these five units. This project therefore seeks to unravel a Web-base Drug Inventory System at Federal Medical Center, Bida to improve patient care.</p><p><strong>1.6 &nbsp; &nbsp; &nbsp; LIMITATION OF THE STUDY</strong></p><p>This study is limited to the Federal Medical Center Pharmacy Department Bida and its five (5) pharmaceutical units within Bida; those outside Bida i.e. Zungeru and Gawu-babangida are not considered for this study .I was restricted to all sensitive information at FMC, Bida at the time of this research work</p><p><strong>1.7 &nbsp; &nbsp; &nbsp; TERMINOLOGY USED IN THE INVENTORY</strong></p><p>STOCKS: All items or materials stored within the organization.</p><p>INVENTORY: List of items contained in the stock. Refer to the list of stocks and the stock itself.</p><p>ITEM: One of the products kept in stock, is an input in inventory.</p><p>UNIT: Standard size or quantity of the items in the catalogue.</p><p>CONTROL INVENTORY: Activities or procedures used to ensure that the correct amount should be kept in stock</p><p></p></div><h3></h3><br> <br><p></p>