DESIGN AND IMPLEMENTATION OF A COMPUTERISED MATERIAL STOCK CONTROL SYSTEM FOR A MANUFACTURING ORGANISATION.

 
ABSTRACT
No production distribution company can do without accurate stock control. There is need to keep accurate record of goods produced by a company and tract of those ones that are supposed to be distributed or sold.  Stock is simply the amount of goods that are been stored.  But due to the trend toward automation in the world order and as the store of Nigerian Bottling Company Plc grows larger daily and its business transaction more complex, the manual system of stock control becomes more tedious, inefficient and not cost effective due to huge material and human resources required. There is need for an alternative to manual form of stock control which will ensure efficient, accurate stock of information and reduce sales control fraud.  This project work critically analyzed the processes and procedures of stock keeping of the case study “Nigeria Bottling Company Plc, Nineth Mile Corner, Enugu, carefully designed more efficient computerized procedure using programme language suitable for data base management.
 
CHAPTER ONE
1.0   INTRODUCTION
In large and established company such Nigeria Bottling Company, accurate stock management which ensures just-in-time delivery of goods is responsible for the maintenance of customers’ goodwill and consequently good turnover. Nigeria Bottling Company is a well established production company under coca-cola as an umbrella organization.  They produce soft drinks like coke, fanta, sprite, bitter lemon, club soda, eva water etc.  NBC have the production plant located at strategic cities in the country and each place have depot to which it serves.  Nigeria Bottling Company Plc, Nineth Mile, Enugu is a plant site and have depots under it which include Achi, Ogoja, Nsukka urban  etc.
This project is on computerized material stock control using “Nigeria Bottling Company Plc, Nineth Mile Enugu as a case study.  This software is incorporated with security techniques to track down frauds by employees, it will maintain re-order level of all product, restrict access to some vital management information, shorten the order process time, its data base will contain the expiring date of products that have not been sold.  It iwill also give a report on the existence of debtors and how much they owing the company.  This software is able to generate report on demand and statement needed by the management for its decision making while promoting the business.  This report ranges from list of the debtors to the some of each product sold within a specified period.
1.1      STATEMENT OF THE PROBLEM
Before now, Nigeria Bottling Company Plc 9th Mile Enugu has been using the manual method of material stock control which necessitated its computerization.  Among these problems are
INACCURATE CALCULATION
This is a situation where the quantity of goods material stock was not accurately added due to human error.
FRAUD
Manual material stock control system is prone to fraud by unreliable or workers o employees.  This might be through the distortion of data in the record book caused by unauthorized access to the book and its insecurity.
COST INEFFECTIVE
Manual material stock control system may not be effective in terms of cost to some small and medium scale industries.
INEFFICENCY
Due to unnecessary duplication of data into various files, manual procedure of material stock control become highly inefficient.
1.2      PURPOSE OF STUDY
This study has the purpose of designing and implementing computerized material stock control system.
The software system will attain some degree of flexibility, be able to produce the required report on demand, be reliably effective and accurate. The voluminous work and the difficult way of tackling stock control made us to research into this work. It is going to help in modifying the system of job operations in the business.  It will help to understand more about stock and the best way of carrying out the business to avoid complexities. As stock takes place in every aspect of life it is very important to understand it and the possible problems one may encounter in the course of carrying out the operation involved and the necessary solution that may be applied to solve the problem.
1.3  AIMS AND OBJECTIVES
This project is aimed at producing optimal solution to the problems inherent in the manual system of stock control in Nigeria bottling company Plc 9th Mile Corner.  The objectives include:
Reduce Order Processing Time: In the manual system it takes one or two days before an order could be fully processed, but with the new computerization of the system, it will take few minutes for an order to be processed.
Efficiency: This stock control package will reduce access time to store data as enquiries could be made an information gotten without stress.
Redundancy: Using this computerize stock control software, save NBC the burden of creating more than one file of a similar content.
Security: Various stages in the system are pass-worded to avoid unauthorized access to information.  This helps to check fraud.
1.4      DELIMITATION
This project covers the stock control section of Nigeria Bottling Company Plc 9th Mile, Enugu. The stock control aspect of this project considers only the stock finished products. The stock of raw materials used for production is not considered. The stock of only the finished product was put into consideration.  The project did not take care of stock of byproducts from production.  Sales of worn out tools etc.