DESIGN AND DEVELOPMENT OF A WEB BASED WAREHOUSE INVENTORY MANAGEMENT SYSTEM

ABSTRACT

In the early years, the use of humans and paper work in tracking distribution of goods was a norm but there was a gap in the chain process. The manual method or intervention is labour intensive, costly, and error prone and cannot ensure the inventory remains up-to-date due to oversight and internal shrinkage. Hence the need to replace human workers with technology in certain key areas to ensure productivity and profit. 

This project negates the manual method and highlights the processes involved in the design and implementation of an inventory management system for a warehouse. The core concept of this project is to manage the supply chain, distribution and sale of items from cash registers with additional features for data interpretation.

The project outlines the main concepts of the analysis and design methodology of the system, compares it to the existing and goes further to explain the design and implementation of the system using recent and modern web technologies.

TABLE OF CONTENT

       Pages     

Title Pagei

Certificationii

Dedicationiii

Acknowledgementiv

Abstractv

Table of contentvi

CHAPTER ONE: INTRODUCTION

1.1 Background of study……………………………………………………1

1.2 Statement of the Problem …………………………………….…………..3

1.3 Aim and Objectives………………………………………………………4

1.4 Definition of Keywords………………………………………………..     4

CHAPTER TWO: LITERATURE REVIEW

2.1 Concept of Warehousing…………………………………………………6

2.2 Need for Warehousing…………………………………………………...8

2.3 Type of Warehouses ………………………………………………….....9

2.4 Private and Public Warehousing ……………………………………… 11

2.5 Functions of a Warehouse ………………………………………        12

2.6 Issues of Warehousing …………………………………...........          13

CHAPTER THREE: SYSTEM DESIGN AND ANALYSIS

3.1 Methodology ……………………………………………………..      17

3.2 The Paper- based System …………………………………………     17

3.3 Limitation of the Existing System ………………………………..     18

3.4 System Design ……………………………………………………..   18

3.5 System Flowchart …………………………………………………..  22

CHAPTER FOUR: IMPLEMENTATION AND TESTING 

4.1 Development Tools  …………………………………………….        24

4.2 System Requirements  ………………………………………………  24

4.3 Implementation ………………………………………………………..26

4.4 Testing …………………………………………………………………27       

CHAPTER FIVE: CONCLUSIONS AND RECOMMENDATIONS

5.1 Summary …….……………………………..………………………..  32

5.2 Recommendations……………………………………………………  32

5.3 Conclusion ………………….……………………………………….. 33

APPENDIX …………………………………………………………….. 34  

REFERENCES ………………………………………………………    63

LIST OF FIGURES

Fig 3.4 Web Architecture …………………………………………………19

Fig 3.5 System Flow Chart .......................................................................23

Fig 4.3 Implementation of Program Design ...……………………………27