This research paper is succinct and provides a general overview of the processes involved in the design and implementation of an automated inventory control system for a manufacturing company. The system is intended to handle the movement and tracking of items more effectively by replacing human labor with technology. Due to oversight and internal shrinkage, the manual approach or intervention is labor demanding, costly, and mistake prone, and it cannot ensure inventory remains up-to-date. Inventory may be updated in real time without product movement, scanning, or human intervention with the suggested new system. The automated system determines inventory status and generates shipping and receiving papers automatically, resulting in automatic orders for low-stocked products. The study describes the fundamental principles of the proposed system’s analysis and design approach, compares it to existing systems, then goes on to detail the system’s design and implementation using Visual Basic 6.0 for the database. Interview, observation, online, and library research are some of the fact-gathering strategies used.



An inventory control system keeps track of orders that need to be filled, directs workers to pick the items they need, and gives packaging and shipping information. Inventory control can be used to automate the fulfillment of sales orders as well as manage inbound and outbound hardware material. The term “automation” refers to the use of technology to replace human employees. Robust functionality is required for managing logistics facilities in order to achieve efficient sales and inventory management. Internal warehouse movements and storage are covered by warehouse management functions for inventory control, and their support aids in the recording and tracking of items based on both amount and value. This application manages all supply orders, lowering warehousing and transportation costs while also increasing customer service. It boosts inventory rotations and streamlines the flow of commodities. It also increases cash flow, visibility, and decision-making by ensuring that jobs are completed quickly and accurately utilizing this computerized manner.


The Nigerian Breweries PLC (NBPL) was founded in 1946. Its goal is to provide satisfaction and nourishment to the Nigerian people through distributing beverages such as beer, Coca-Cola, Fanta, and Sprite. It is unparalleled, and as a result, demand is strong. The corporation responds to the rising demand by stabilizing supply in order to establish a balance. The corporation, understandably, has a problem keeping proper records of products transfers, and because this is done manually, there are issues of insecurity, high operating costs, and supply delays. To handle stock and inventory, Nigerian Breweries PLC currently uses humans, pens, and paper to process data. The design and construction of an automated inventory control system for Nigerian Breweries PLC will undoubtedly provide significant relief from the manual system’s issues.


The Nigerian Breweries PLC is largely manual in operation and exhibits a variety of flaws.
The manual recording of sales and monies collected is done on a shabby-looking book. As a result, the books may be damaged physically, information may be lost, and dust particles may gather.
The never-ending list of supply orders that need to be fulfilled on a daily basis.
The control system is inefficient, inefficient, and time-consuming, and the atmosphere is not user-friendly.
Human mistake is frequently the cause of inaccuracies.
The manual system is inconvenient, and it can be decreased or eliminated by using the proposed solution.


The goal of this research is to improve the Nigerian Breweries PLC’s current operational processes to their maximum potential by developing efficient computer software that can handle inventory in a computerized manner.


By implementing an automated inventory control system, the Nigerian Breweries PLC would be able to boost operational efficiency, reduce maintenance and operating costs, monitor the supply of items and their distribution, and increase profit.


The primary goal of this research is to create a computerized inventory control and management system. Others are as follows:
i. It gives you complete asset visibility.
ii. It enables for lower inventory stocking levels while still providing complete inventory history.
iii. It minimizes lead time, shelf space, and errors due to damage, as well as employee weariness and overall operating costs.
iv. It makes “just in time” deliveries possible.
v. It allows for complete product process control.
vi. It has a better level of security because the system is password-protected to prevent unauthorized access.
vii. It reduces cross docking time and increases the rate of sorting and picking up items.
viii. It aids management in planning, monitoring, and optimizing resources, as well as determining their financial situation at any moment.


This research looks at the Nigerian Breweries PLC as a whole, as well as its clients, who include retailers, distributors, and the general public.


The following factors limited the scope of this project: Financial Constraints (a) Because of the expensive nature of things nowadays in traveling for the collection of data needed for the project, it was difficult to make both ends meet, especially given the country’s economic status. Time Constraints (b) Looking at the time between the last semester’s resumption and vacation for the project to be completed, it appeared that the time allotted was insufficient for gathering the necessary knowledge for better work. d) Material non-availability During this project, it was discovered that the project’s required materials were not documented. Those that were documented did not have access to storage facilities.


Automation is the use of technology or computers to control and process data without requiring human participation.
A database is a big collection of connected data on a computer that can be accessed and modified by a user. A secret code that must be input into a computer to have access to its programs is known as a password. It can be made up of numbers, letters, special characters, or a combination of the three. Inventory Control System: Provides workers with a list of orders to fulfil and prompts them to pick the necessary supplies as well as packaging and shipping information. Computerization is the process of transforming a manually operated system into one that is controlled, structured, and automated.

Research: An in-depth examination of a topic in order to uncover facts, formulate a theory, or devise a strategy based on the findings. A system is a collection of computer components that work together.
Technology is the study of methods for mobilizing resources such as information to achieve goals that benefit people and the environment.
Software is a set of instructions or a computer program that directs a computer to perform processing operations. A collection of procedures, people, instructions, and technology that produces information in a meaningful form is referred to as an information system. Processing is the act of dealing with something in accordance with a set of rules.

Leave a Comment