DESIGN AND IMPLEMENTATION OF AN AUTOMATED INVENTORY CONTROL SYSTEM

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.

 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. The tools used were; Visual Basic 10 and Microsoft access 2007. The fact finding techniques employed is interview, observation, online and library research.

This material content is developed to serve as a GUIDE for students to conduct academic research