Design and Implementation of an Automated Inventory Control System

 – Design and Implementation of an Automated Inventory Control System –

Download Design and Implementation of an Automated Inventory Control System project materials: This project material is ready for students who are in need of it to aid their research.

ABSTRACT

This research work is concise and generally summarizes the activities duly carried out in the design and implementation of an automated inventory control system for NIGERIAN BREWERIES PLC, ENUGU. The system is designed to efficiently handle the movement and tracking of goods.

The manual method is labour intensive, costly, and error-prone and cannot ensure that the inventory remains up-to-date due to oversight and internal shrinkage. With the proposed new system, inventory can be updated in real-time without product movement, scanning, or human involvement.

The automated system helps in; (i) the determination of inventory status, (ii) registration of new stock, (iii)registration of new customers, (iv) supply of goods to registered customers, (v) printing of transaction invoices for customers for transactions that have taken place as well as viewing the available transactions that were carried out at a particular time.

TABLE OF CONTENTS

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

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

CHAPTER TWO
LITERATURE REVIEW
2.1 Comprehensive Overview………………………………………………………7
2.2 Types of Inventory Control System…………………………………………7
2.2.1 Four types of Inventory Control Systems………………………………….8
2.2.1.1 Manual Inventory Management System………………………………….8
2.2.1.2 Barcode Technology…………………………………………………………….8
2.2.1.3 Radio Frequency Identification (RFID)……………………………………9
2.2.1.4 Warehouse Management System…………………………………………….9
2.3 How Inventory Control Systems really work…………………………….11
2.4 What Industries use Inventory Control Systems………………………..13
2.4.1 Application of ICS in the Manufacturing Industry……………………12
2.4.2 Importance of Inventory Control Systems……………………………….14
2.5 Warehouse Management Systems (WMS)……………………………….15
2.5.1 Warehouse Management Rules Engine…………………………………….15
2.5.1.1 Rules Workbench………………………………………………………………..16
2.5.1.2 Warehouse Management System Strategy………………………………16
2.5.2 Importance of Warehouse Management Systems……………………..17
2.5.3 ICS vs. WMS……………………………………………………………………….18
2.6 Automated Inventory Control System Software…………………………18

CHAPTER THREE
3.1 Research Methodology………………………………………………………….20
3.2 Data Collection…………………………………………………………………….21
3.2.1 Primary Source…………………………………………………………………….20
3.2.2 Secondary Source…………………………………………………………………20
3.2.3 Observational Method…………………………………………………………..20
3.3 Analysis of the existing system…………………………………………….21
3.4 Limitations of the Existing System…………………………………………22
3.5 System Design………………………………………………………………………23
3.5.1 Input Specification…………………………………………………………………23
3.5.2 Output Specification………………………………………………………………23
3.5.3 Processing……………………………………………………………………………..23
3.5.4 Login form…………………………………………………………..24
3.5.5 New customer form…………………………………………..……..24
3.5.6 Edit customer………………………………………………………..25
3.5.7 Register product……………………………………………………..26
3.5.8 Edit product…………………………………………………………27
3.6 Data Base Design……………………………………………………28
3.7 System Flow Chart………………………………………………….29
3.8 Top Down Diagram…………………………………………………30

CHAPTER FOUR
4.1 Choice of development tools…………………………………………………32
4.2 System Requirements…………………………………………….32
4.2.1 Software Requirements………………………………………………………..32
4.2.2 Hardware Requirements……………………………………………………….33
4.2.3 Functional Requirements………………………………………………………33
4.2.4 Non-functional Requirements………………………………………………..34
4.3 System Implementation…………………………………………………………34
4.3.1 Login form…………………………………………………………35
4.3.2 Main form…………………………………………………………..36
4.4 System Testing……………………………………………………………………..37
4.4.1 Unit Testing…………………………………………………………………………38
4.4.2 System Testing……………………………………………………………………..41
4.4.3 Testing Process……………………………………………………………………..41
4.5 integration………………………………………………………….42

CHAPTER FIVE
5.1 Summary of findings……………………………………………………………43
5.2 Limitations of the project…………………………………………………….43
5.3 Recommendations……………………………………………………………….43
5.4 BEME (Bill Of Engineering Measurement & Evaluation)……….44
5.5 Conclusion………………………………………………………………………….44
REFERENCES…………………………………………………………………………….48
Appendix A: Program Source Code………………………………………………….40
Appendix B: Output System…………………………………………………………….51
Appendix C: User Guide………………………………………………………………….51

INTRODUCTION

Nigerian Breweries Plc., incorporated in 1946, is the pioneer and largest brewing company in Nigeria. Its first bottle of beer, STAR Lager, rolled off the bottling lines of its Lagos Brewery in June 1949.

Other breweries were subsequently commissioned by the company, including Aba Brewery in 1957, Kaduna Brewery in 1963, and Ibadan Brewery in 1982. In September 1993, the company acquired its fifth brewery in Enugu state, and in October 2003, its sixth brewery, sited at Ama in Enugu.

Ama Brewery is the largest brewery in Nigeria and one of the most modern worldwide. Operations at Enugu brewery were discontinued in 2004 leaving the company with five operational breweries.

REFERENCES

Kotler, I.C. (2003). Inventory Control Management in the 21st Century.Charlotte (USA): Mac-Williams and Capital Publishers Inc.

Harry, E.G. (2005). Tracking Inventory. London: Underwood Pitman.

Monzerka, J.G. (2002). Sales Management: Theory and Practice. London: Paul Chapman Publication.

Rubin, K. (2007). Computer Applications for Inventory Control Systems.Boston: McGraw Hill.

Lysons, M.C. (2001). Systematic Planning for Change. Palo Alto, California:Mayfield Publishing Company.

Kenneth. D.C. (2002). Contemporary Inventory Management Systems. New York: McGraw Go Spot.

Comments are closed.

Hey Hi

Don't miss this opportunity

Enter Your Details