Design and implementation of a computerized inventory control system
Table Of Contents
<p> </p><p>Title page</p><p>Approval Page</p><p>Certification Page</p><p>Dedication</p><p>Acknowledgement</p><p>Abstract</p><p>Table of Contents</p><p>List of Figures</p><p>List of Tables</p><p>
Chapter ONE
i</p><p>10 Introduction 1</p><p>11 Background of the Study 2</p><p>12 Statement of the Problem 3</p><p>13 Purpose of the Study 4</p><p>14 Significance of the Study 4</p><p>15 Objectives of the Study 4</p><p>16 Scope of the Study 5</p><p>17 Limitations of the Study 6</p><p>18 Definition of Basic Concepts 6</p><p>Chapter TWO
</p><p>20 Literature Review 9</p><p>21 Comprehensive Overview 9</p><p>211 Purpose 10</p><p>22 Types of Inventory Control Systems – – – – 10</p><p>221 Four types of inventory control systems – – – – 11</p><p></p><p>2211 Manual Inventory Management System – – – 11</p><p>2212 Barcode Technology 12</p><p>2213 Radio Frequency Identification (RFID) – – – 13</p><p>2214 Warehouse Management System – – – – 14</p><p>23 How Inventory Control Systems Really Work – – 16</p><p>24 What Industries Use Inventory Control Systems – – 19</p><p>241 Application of Inventory Control Systems – – – 20</p><p>242 Importance of Inventory Control Systems – – – – 21</p><p>25 Warehouse Management Systems – – – – 22</p><p>251 Warehouse Management Rules Engine – – – 24</p><p>2511 Rules Workbench 25</p><p>2512 Warehouse Management System Strategy – – – 25</p><p>252 Importance of Warehouse Management Systems – – 25</p><p>253 Inventory Control Systems vs Warehouse Mgt Systems – 27</p><p>26 Automated Inventory Control System Software – – – 28</p> <br><p></p>Project Abstract
This research work is concise and generally summarizes the activities duly carried out in the design and implementation of a computerized inventory control system for a manufacturing organization. The system is designed to efficiently handle the movement and tracking of goods through the replacement of human workers by technology. 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. With the proposed new system, inventory can be updated in real time without product movement, scanning, or human involvement. The automated system allows inventory status to be determined and shipping and receiving documents to be generated automatically triggering automatic orders for products that are low in inventory. The study outlines the main concepts of the analysis and design methodology of the proposed system, compares it to the existing and goes further to explain the design and implementation of the system using Visual Basic 6.0 for the database. The fact finding techniques employed is interview, observation, online and library research.
Project Overview
INTRODUCTION
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 Inventory control may be used to automate sales order fulfilment 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 Warehouse management functions for inventory control cover internal warehouse movements and storage and its support helps in the recording and tracking of materials on basis of both quantity and value
This application takes care of all supply orders reducing cost for warehousing, transportation while improving customer service It significantly improves inventory turns, optimizes flow of goods It also improves cash flow, visibility and decision making providing efficient execution of tasks using this fast and reliable computerised method
11 BACKGROUND OF THE STUDY
The Nigerian Breweries PLC was established in the year 1946 It aims at providing satisfaction and nourishment to the Nigerian population through the distribution of drinks like beer, coca-cola, fanta, sprite etc It is second to none and for this reason, the demand is high and the company responds to the increasing demand by stabilizing supply to strike a balance
Justifiably, the company has the problem of keeping adequate record of goods transfer and since it is done manually, associated problems of insecurity, high cost of operation and delay in supply arise Data processing in Nigerian Breweries PLC is presently carried out using people, pens, and paper to control stock and inventory
The design and development of a computerized inventory control system for the Nigerian Breweries PLC will no doubt bring immeasurable relief from the problems associated with the manual system
12 STATEMENT OF THE PROBLEM
The Nigerian Breweries PLC is to an extent manually operated and reveals a number of problems
The recording of sales and cash received are done manually on a book that appears rough Thus, the books are exposed to physical damage, information can be lost and dust particles are accumulated
The long list of supply orders waiting to be attended to on daily basis
The control system is time consuming, less accurate and less efficient, and the environment is not user friendly
Inaccuracies often ensue from human error
The manual system is quite tedious and can be reduced or eliminated with the introduction of the proposed system
13 PURPOSE OF THE STUDY
The purpose of this study is to improve current operational process in the Nigerian Breweries PLC to its full capacity by developing efficient computer software that can handle inventory in a computerised fashion
14 SIGNIFICANCE OF THE STUDY
This study is primarily aimed at increasing efficiency in operations, reducing maintenance and running cost, monitoring the supply of goods and its distribution and increase profit in the Nigerian Breweries PLC by introducing a computerizedinventory control system
15 OBJECTIVES OF THE STUDY
The main objective of this study is to develop a computerised inventory control management system Others include;
i It provides total asset visibility
ii It allows reduced inventory stocking levels giving full inventory history
iii It reduces lead time, shelf space, and errors due to damage, fatigue of staff and overall cost of operations
iv It facilitates “just in time” deliveries
v It provides full process control for products
vi It provides higher level security as the system would be passworded to prevent unauthorised access
vii It shortens cross docking time and speeds up sort/pick up rate
viii It helps the management plan, monitor, optimize resources and ascertain their financial position at any time
16 SCOPE OF THE STUDY
The scope of this study covers the Nigerian Breweries PLC as a whole, and its customers which include retailers, distributors and the general public
17 LIMITATIONS OF THE STUDY
This project was constrained by the following factors:
(a) Financial Constraints
Bearing in mind the economic state of the nation, it was found difficult in making both ends meet, because of the exorbitant nature of things nowadays in travelling for the collection of data needed for the project
(b) Time Constraints
Looking at the interval between the resumption and vacation of the final semester for the project to be completed, the time given seemed to be short for the collection of required information for better work to be done
(c) Non-Availability of Material
During this project, it was noticed that the required materials needed for the project are not documented Those that were documented lacked storage facilities where they can be reached
18 DEFINITION OF BASIC CONCEPTS
Automation: This is the use of technology or computers to control and process data reducing the need for human intervention
Database: This refers to a large store of related data on a computer that a user can access and modify
Password: This is a secret code that must be entered into a computer to enable access to its applications It is made up of numbers, letters, special characters or a combination of any of the above categories
Inventory Control System: A list of orders to be filled, and prompts workers to pick the necessary items and provides them with packaging and shipping information
Computerization: This is the conversion of a manually operated system to a controlled, organized and automated system
Research: A careful study of a subject to discover facts, establish a theory or develop a plan of action based on the facts discovered
System: A set of computer components functioning together
Technology: The study of techniques of mobilizing resources such as information for accomplishing objectives that benefit man and his environment
Software: A computer program or set of instructions that direct a computer to perform processing functions
Information System: A collection of procedures, people, instructions and equipment to produce information in a useful form
Processing: This is dealing with something according to an established procedure
Blazingprojects Mobile App
📚 Over 50,000 Project Materials
📱 100% Offline: No internet needed
📝 Over 98 Departments
🔍 Software coding and Machine construction
🎓 Postgraduate/Undergraduate Research works
📥 Instant Whatsapp/Email Delivery
Related Research
Predicting Disease Outbreaks Using Machine Learning and Data Analysis...
The project topic, "Predicting Disease Outbreaks Using Machine Learning and Data Analysis," focuses on utilizing advanced computational techniques to ...
Implementation of a Real-Time Facial Recognition System using Deep Learning Techniqu...
The project on "Implementation of a Real-Time Facial Recognition System using Deep Learning Techniques" aims to develop a sophisticated system that ca...
Applying Machine Learning for Network Intrusion Detection...
The project topic "Applying Machine Learning for Network Intrusion Detection" focuses on utilizing machine learning algorithms to enhance the detectio...
Analyzing and Improving Machine Learning Model Performance Using Explainable AI Tech...
The project topic "Analyzing and Improving Machine Learning Model Performance Using Explainable AI Techniques" focuses on enhancing the effectiveness ...
Applying Machine Learning Algorithms for Predicting Stock Market Trends...
The project topic "Applying Machine Learning Algorithms for Predicting Stock Market Trends" revolves around the application of cutting-edge machine le...
Application of Machine Learning for Predictive Maintenance in Industrial IoT Systems...
The project topic, "Application of Machine Learning for Predictive Maintenance in Industrial IoT Systems," focuses on the integration of machine learn...
Anomaly Detection in Internet of Things (IoT) Networks using Machine Learning Algori...
Anomaly detection in Internet of Things (IoT) networks using machine learning algorithms is a critical research area that aims to enhance the security and effic...
Anomaly Detection in Network Traffic Using Machine Learning Algorithms...
Anomaly detection in network traffic using machine learning algorithms is a crucial aspect of cybersecurity that aims to identify unusual patterns or behaviors ...
Predictive maintenance using machine learning algorithms...
Predictive maintenance is a proactive maintenance strategy that aims to predict equipment failures before they occur, thereby reducing downtime and maintenance ...
