Design And Implementation Of A Computer Based Warehousing Information System
(A Case Study Of Nigeria Ports Authority (NPA) Lagos)
A Computer-Based Warehousing Information System (CBWIS) is a sophisticated and dynamic technological infrastructure designed to streamline and optimize various facets of warehouse operations. This comprehensive system leverages cutting-edge software and hardware solutions to efficiently manage inventory, monitor stock levels, and facilitate seamless communication between different elements of the supply chain. Computer-Based Warehousing Information System incorporates robust data analytics tools, enabling real-time tracking and analysis of goods movement, thus enhancing decision-making processes. By integrating elements such as barcode scanning, RFID technology, and automated data entry, Computer-Based Warehousing Information System minimizes errors and improves overall accuracy in inventory management. This system plays a pivotal role in enhancing operational efficiency, reducing costs, and ensuring a responsive and adaptable approach to the evolving demands of modern warehousing. In essence, the Computer-Based Warehousing Information System acts as a technological linchpin, fostering a more agile and effective warehouse management ecosystem.
The purpose of this study is to computerize the warehousing information system (A case study of NPA – Lagos) and to develop a computer package, whereby the techniques observed from the manual method can be improved upon. It is a known fact that the manual method of warehousing information system has been associated with lots of inaccuracy in warehousing information system. This has led to some set back that has cost some obstruction on some parts, when in service.
The software, when developed will facilitate and enhance the more and methods of warehousing information system which enables accuracy and also saves time when services and rendered.
There is no intention here, to treat modules separately, hence the entire project is menu driven, to cover most of the facilities present.
Lastly, it is optimistic that at the end of going through the work, one should be able to;
1. Have a clear idea of the project
2. Improve it to suit other organization with regard to other sources and problems.
3. Know what it achieves.
COVER PAGE
TITLE PAGE
CERTIFICATION
DEDICATION
ACKNOWLEDGEMENT
ABSTRACT
TABLE OF CONTENT
CHAPTER ONE:
INTRODUCTION
1.1 BACKGROUND OF THE STUDY
1.2 STATEMENT OF PROBLEM
1.3 PURPOSE OF STUDY
1.4 SIGNIFICANCE OF THE STUDY
1.5 SCOPE AND PRELIMITATION
1.6 LIMITATIONS OR CONSTRAINTS
CHAPTER TWO
LITERATURE REVIEW
CHAPTER THREE
DESCRIPTION AND ANALYSIS OF EXISTING SYSTEM
3.1 FACT FINDINGS METHOD USED
3.2 ORGANISATIONAL STUDY
3.3 INPUT, PROCESS AND OUTPUT ANALYSIS
3.4 PROBLEMS OF THE EXISTING SYSTEM
3.5 JUSTIFICATION OF THE NEW SYSTEM
3.6 INFORMATION FLOW DIAGRAM
CHAPTER FOUR
DESIGN OF THE NEW SYSTEM
4.1 OUTPUT SPECIFICATION AND DESIGN
4.2 INPUT SPECIFICATION AND DESIGN
4.3 FILE DESIGN
4.4 SYSTEM FLOW CHART AND REQUIREMENT
4.5 PROCEDURE CHART
CHAPTER FIVE
5.1 IMPLEMENTATION
5.2 PROGRAM DESIGN
5.3 PROGRAM FLOW CHART
CHAPTER SIX
DOCUMENTATION
CHAPTER SEVEN
7.0 RECOMMENDATION AND CONCLUSION
7.1 BIBLIOGRAPHY
INTRODUCTION
1.1 BACKGROUND OF THE STUDY
Warehouse is where goods and commodities are kept for further clearance. Narrowing it to Nigeria Ports Authority, there are many warehouse where imported consignment and goods are stored. This is cleared by carrying the billing papers from post to post, waiting and wasting much time in seeing who is in charge. Goods that takes about two weeks to berth into the country takes another two weeks to get cleared. This makes the importers and the clearing agents to run from port to port, in search of where the goods were kept.
The introduction of computer in warehousing will enable importers know which and where their goods are kept, as it will always be stipulates on the bill of laden papers. Computer is hereby seen as a way of handling, by systematically organizing them, recording or making notations on them, following up with the appropriate action or the like.
1.2 STATEMENT OF THE PROBLE
The processing of billing papers for clearance of goods, with manual method has led to omission of many records that ought to be included. This is caused by inaccuracy of the manual billing process.
Due to the inefficiency in manual billing process, billing papers are carried from post to post, waiting for who is in charge, thereby delaying the goods that suppose to be delivered.
More so, goods are not delivered on time, due to the fact, that goods that takes about two weeks to get into the country, still takes another two weeks to be cleared.
1.3 PURPOSE OF STUDY
The purpose of this is study is to
1. Identify those problems caused by using manual billing clearance
2. Finding out the effect of this in Nigeria Ports Authority
3. Create computer awareness
4. Identify prospects for solution of problems.
1.4 SIGNIFICANCE OF THE STUDY
This research, base on the problem and prospect of using computer in Nigeria Ports Authority, will help to develop interest towards computer.
The findings of this research, will also help the management to increase the income generation of Nigeria Ports Authority and smooth running of the warehouse in general.
1.5 SCOPE OF THE STUDY
The researcher will identify all the problems, including the financial constraints of the problems, encounter with the use of manual billing clearance in warehousing.
1.6 LIMITATIONS OF THE STUDY
Due to the financial constraints of the researcher and lack of time, the researcher is concentrating the study in only Nigeria Ports Authority Lagos.
Computer Based Warehousing Information System:
A Computer-Based Warehousing Information System (WIS) is a comprehensive software solution designed to manage and optimize the operations of a warehouse or distribution center. This system utilizes computer technology, including hardware and software, to streamline the storage, retrieval, and tracking of inventory and related information within a warehouse setting. The primary goal of a WIS is to improve the efficiency, accuracy, and overall management of warehouse operations.
Here are some key components and functionalities of a Computer-Based Warehousing Information System:
- Inventory Management: WIS helps in tracking the movement of inventory items within the warehouse. It records information about stock levels, item locations, and inventory adjustments.
- Barcode Scanning: Barcode scanning technology is often integrated into WIS to improve the accuracy of data entry and inventory tracking. Warehouse personnel can scan barcodes on items, bins, and pallets to update the system in real-time.
- Order Management: WIS can manage customer orders, purchase orders, and internal transfer orders. It helps in order processing, picking, packing, and shipping.
- Location Management: Efficient storage allocation and management are crucial in a warehouse. WIS assists in determining the optimal storage locations for items based on factors like item characteristics, demand, and accessibility.
- Task Management: Warehouse staff can receive task assignments through the system, such as picking lists, replenishment tasks, and restocking instructions. This ensures that tasks are efficiently distributed and completed.
- Reporting and Analytics: WIS provides various reports and analytics to help warehouse managers make informed decisions. These reports may include inventory turnover, order fulfillment rates, and space utilization.
- Integration with Other Systems: A WIS often integrates with other systems, such as Enterprise Resource Planning (ERP) software and transportation management systems, to ensure seamless data flow and coordination between different parts of the supply chain.
- Real-time Updates: WIS offers real-time visibility into inventory levels and warehouse activities. This helps in minimizing errors, reducing stockouts, and optimizing inventory holding costs.
- Security and Access Control: Access to the WIS is typically controlled and restricted to authorized personnel to maintain data integrity and security.
- Mobile Accessibility: Many WIS systems provide mobile applications or handheld devices for warehouse workers, enabling them to perform tasks like scanning, picking, and updating inventory on the go.
- Automation: Advanced WIS solutions may incorporate automation technologies, such as conveyor systems, automated guided vehicles (AGVs), and robotic pickers, to further enhance warehouse efficiency.
- Scalability: WIS should be scalable to accommodate the changing needs of the warehouse, whether it’s handling more SKUs, expanding storage capacity, or adapting to new processes.
Implementing a Computer-Based Warehousing Information System can significantly improve the overall efficiency, accuracy, and responsiveness of warehouse operations. It helps businesses meet customer demands, reduce operational costs, and maintain better control over their inventory and logistics processes.