Design And Implementation Of Web-Based Drug Inventory Management System

Computer Science Project Material with Source Code Included

Computer Science Project Material with Source Code Included

Abstract

Inventory management is one of the necessities of every business institution. Every organization possesses its own method in managing and controlling the inventory system. For a hospital, it is paramount because lack of proper drug management can be detrimental to patients’ health and hospital flow. A study conducted at the Pharmacy Department of FMC, Bida showed that there is no proper automated inventory management system in place and the manual paper/pen method is used for drug inventory management. According to the nurses, this poses a great problem as files and paper may get destroyed or tampered with.

To solve the above problem, a web based drug inventory management system has been developed to automate drug stock and usage. This effective and efficient system therefore will resolve and replace the current system process thereby increasing the hospital efficiency. This system is able to remind the admin (pharmacist officer) about list of the drug, drug quantity and also support reminder for any expired drugs. This system is developed using PHP Hypertext Pre-processor (PHP) for data manipulation and MySQL as the system’s database.

Chapter One

1.0 Introduction

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.

1.1 Background of Study

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

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) The obvious outcome of this problem is a retrogressive effect on patient care due to delayed procedures and drug substitutions (Fox and Tyler 2003).

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. 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.

1.2 Statement of Problem

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:

  1. 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.
  2. Pharmacist consistent error on multiple or under ordering of drugs.
  3. No accurate mechanism to remind for critical quantity of each drug.

1.3 Objectives of the Study

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

The objectives of this project are:

  1. To explore issues associated with the current file based record of drug inventory and distribution process in FMC, Bida.
  2. To develop a Web-based Drug Inventory Management System prototype for FMC, Bida

1.4 Significant of the Study

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

1.5 Scope of the Study

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

  1. National insurance health services (NHIS) Unit
  2. Accident & Emergency (A&E) Unit
  3. Obstetrics & Gynaecology (O&G) Unit
  4. Paediatrics Unit
  5. General Out-patient Clinic (GOPC) Unit 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.

1.6 Limitation of the Study

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

1.7 Terminology Used in the Inventory

Stocks:

All items or materials stored within the organization.

Inventory:

List of items contained in the stock. Refer to the list of stocks and the stock itself.

Item:

One of the products kept in stock, is an input in inventory.

Unit:

Standard size or quantity of the items in the catalogue.

Control Inventory:

Activities or procedures used to ensure that the correct amount should be kept in stock.

Chapter Five

Summary and Conclusion

5.0 Introduction

This chapter will look into the summary of the project (Design and implementation of Web-based Centralized Inventory Management System).findings, recommendation and the conclusion of the new System developed

5.1 Summary

The investigation and analysis of the present system was conducted and the problems associated with the old method of Manual (file base Method) of Inventory Process were discovered. The new system was designed and implemented to take care of the problems identified during investigation. The developed system will allow for proper control on the drug distribution and reporting ability that monitors what has been distributed. The implementation stage was successful and it was implemented using PHP, DBMS and other scripting languages.

5.2 Findings and Discussion

In the course of this project, it was found that the urgent need for automated Centralized Inventory Management System will help in pharmaceutical units as a vital organ in the healthcare and has an important role in promoting public health. As part of my findings, Computer and automated systems brings better and more efficient ways of carrying out operations.

5.3 Suggestions for Further Work

In the course of this project work it was found that Most Pharmaceutical Unit of health industries are still carrying out Drug Inventory Manually (file base method) which encore a lot of financial waste and time consuming, and some who has embraced Electronic method of Inventory are either not Networked or no notification/alert system are incorporated in them for monitoring purposes. Web-based Drug Inventory Management System does not restrict you to office alone. You can operate from anywhere as long as you have access to internet connectivity to your Computer system. Because of this feature, administrating the flow of Drug and control of the Inventory will be made easy

5.4 Recommendation

Based on findings in the course of this project work, it is recommended that the system requirement for operation should be adhered to, when used on Local Area Network (LAN) or Internet, Proper external Back-up system must be maintained always and further improvement on this project should concentrate on adding Expired drug notification/alert system

5.5 Conclusion

The developed system was design to ensure flexibility with user-friendly and ability to generate accurate information while making sure that the data are safe and proper management and updates are carried out

Get Complete Project Material

5,000 5000

The Complete Material Will Be Sent to You in Just 2 Steps

Quick & Simple…

Step One Purchase

Make Payment (Through Transfer) of ₦5,000 to the Account Below

Access Bank PlcAcc No: 0811003731
Samphina Academy
Current Account

Or CLICK HERE To Pay With Debit Card

FOR STUDENTS OUTSIDE NIGERIA
CLICK HERE To Pay With Card ($15)
FOR GHANA STUDENTS (GHS 100)
Ghana MTN MoMoMTN MoMo
0553978005
Douglas Osabutey

Step Two Purchase

Send the Following Details on WhatsApp ( 07062590260 ) After Payment

  1. Payment Details
  2. TOPIC: Design And Implementation Of Web-Based Drug Inventory Management System

The Complete Material Will Be Sent To You On WhatsApp After Receiving Your Details
T & C Apply

  Contact Our Help Desk

Students Review

List of Related Works

Click on Any Topic to Preview the Content

Frequently Asked Questions

What is inventory management system?

Get complete project topic and material with source code on Design and Implementation of Inventory Management system An inventory control system contains a list of orders to be filled and then prompts workers to pick the necessary items, and provides them with packaging and shipping information.

What are the components of inventory control software?

The software is made up of components working together to create a cohesive inventory control system which include; Asset tracking: This involves tracking products via its barcodes and other tracking criteria such as serial number when they are in a warehouse or store. 

How does barcode technology improve inventory management?

All major retailers use barcode technology as part of an overall inventory control system because it increases the accuracy and efficiency of managing inventory. When a barcode is read at the point of sale, inventory sales data is immediately read and sent to a broader system that maintains usage statistics.

What is involved in in-inventory control?

Inventory control may be used to automate sales order fulfillment process and also manage in and outward material of hardware. Automation is the replacement of human workers by technology. For optimal sales and inventory management process, robust functionality is needed for managing logistics facilities. 

samphina.academy

Samphina Academy

Samphina Academy is an Online Educational Resource Center that is aimed at providing students with quality information and materials to aid them in succeeding in their academic pursuit.