Design and implementation of an automated inventory control system for nigerian breweries plc, enugu

• Certification Page ii Dedication iii Acknowledgement iv Abstract v Table of Contents vi List of figures x List of tables xi 7

Chapter ONE

INTRODUCTION

• 1.1Background of the Study……………………………………………………..1
• 1.2Statement of the Problem……………………………………………………..2
• 1.3Aims/objectives of the project……………………………………………..3
• 1.4Justification for the project…………………………………………………..3
• 1.5Objectives of the Study………………………………………………………..4
• 1.6Scope of the Study……………………………………………………………….4
• 1.7Definition of Basic Concepts…………………………………………………5
• 1.8Project report organisation……………………………………..6

Chapter TWO

LITERATURE REVIEW

• 2.1Comprehensive Overview………………………………………………………7
• 2.2Types of Inventory Control System…………………………………………7 2.
• 2.1Four types of Inventory Control Systems………………………………….8 2.2.
• 1.1Manual Inventory Management System………………………………….8 2.2.
• 1.2Barcode Technology…………………………………………………………….8 2.2.
• 1.3Radio Frequency Identification (RFID)……………………………………9 2.2.
• 1.4Warehouse Management System…………………………………………….9
• 2.3How Inventory Control Systems really work…………………………….11
• 2.4What Industries use Inventory Control Systems………………………..13 2.
• 4.1Application of ICS in the Manufacturing Industry……………………12 2.
• 4.2Importance of Inventory Control Systems……………………………….14 8
• 2.5Warehouse Management Systems (WMS)……………………………….15 2.
• 5.1Warehouse Management Rules Engine…………………………………….15 2.5.
• 1.1Rules Workbench………………………………………………………………..16 2.5.
• 1.2Warehouse Management System Strategy………………………………16 2.
• 5.2Importance of Warehouse Management Systems……………………..17 2.
• 5.3ICS vs. WMS……………………………………………………………………….18
• 2.6Automated Inventory Control System Software…………………………18

Chapter THREE

SYSTEM DESIGN AND IMPLEMENTATION

• 3.1Research Methodology………………………………………………………….20
• 3.2Data Collection…………………………………………………………………….21 3.
• 2.1Primary Source…………………………………………………………………….20 3.
• 2.2Secondary Source…………………………………………………………………20 3.
• 2.3Observational Method…………………………………………………………..20
• 3.3Analysis of the existing system…………………………………………….21
• 3.4Limitations of the Existing System…………………………………………22
• 3.5System Design………………………………………………………………………23 3.
• 5.1Input Specification…………………………………………………………………23 3.
• 5.2Output Specification………………………………………………………………23 3.
• 5.3Processing……………………………………………………………………………..23 3.
• 5.4Login form…………………………………………………………..24 3.
• 5.5New customer form…………………………………………..……..24 3.
• 5.6Edit customer………………………………………………………..25 3.
• 5.7Register product……………………………………………………..26 3.
• 5.8Edit product…………………………………………………………27
• 3.6Data Base Design……………………………………………………28
• 3.7System Flow Chart………………………………………………….29
• 3.8Top Down Diagram…………………………………………………30 9

Chapter FOUR

SYSTEM TESTING AND EVALUATION

• 4.1Choice of development tools…………………………………………………32
• 4.2System Requirements…………………………………………….32 4.
• 2.1Software Requirements………………………………………………………..32 4.
• 2.2Hardware Requirements……………………………………………………….33 4.
• 2.3Functional Requirements………………………………………………………33 4.
• 2.4Non-functional Requirements………………………………………………..34
• 4.3System Implementation…………………………………………………………34 4.
• 3.1Login form…………………………………………………………35 4.
• 3.2Main form…………………………………………………………..36
• 4.4System Testing……………………………………………………………………..37 4.
• 4.1Unit Testing…………………………………………………………………………38 4.
• 4.2System Testing……………………………………………………………………..41 4.
• 4.3Testing Process……………………………………………………………………..41
• 4.5integration………………………………………………………….42

Chapter FIVE

SUMMARY, CONCLUSION AND RECOMMENDATIONS

• 5.1Summary of findings……………………………………………………………43
• 5.2Limitations of the project…………………………………………………….43
• 5.3Recommendations……………………………………………………………….43
• 5.4BEME (Bill Of Engineering Measurement & Evaluation)……….44
• 5.5Conclusion………………………………………………………………………….44 REFERENCES…………………………………………………………………………….48 Appendix A: Program Source Code………………………………………………….40 10 Appendix B: Output System…………………………………………………………….51 Appendix C: User Guide………………………………………………………………….51 List of Figures Fig 1: login form………………………………………………………………24 Fig 2: new customer form……………………………………………………..24 Fig 3: edit customer form………………………………………………………25 Fig 4: register product form……………………………………………………26 Fig 5: edit product form……………………………………………………….27 Fig 6: system flow chart……………………………………………………….29 11 Fig 7: top down diagram………………………………………………………30 Fig 8: login form………………………………………………………………35 Fig 9: main form……………………………………………………………….36 Fig 10: new customer form……………………………………………………37 Fig 11: order slip form………………………………………………………..38 Fig 12: testing process………………………………………………………..43 List of Tables Table 1: The Test Data, Expected Data, and Actual Result table ……………40 Table 2: BEME (Bill of Engineering Measurement & Evaluation)……………46

Chapter ONE

INTRODUCTION

• 12