DESIGN AND IMPLEMENTATION OF A COMPUTERIZED 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.

TABLE OF CONTENTS

TITLE PAGE

ABSTRACT

TABLE OF CONTENTS

CHAPTER ONE

INTRODUCTION

1.1      STATEMENT OF THE PROBLEM

1.2      PURPOSE OF STUDY

1.3      AIMS AND OBJECTIVES

1.4      DELIMITATION

1.5      LIMITATION

1.6      ASSUMPTION

1.7      DEFINITION OF TERMS

CHAPTER TWO

LITERATURE REVIEW

CHAPTER THREE

DESCRIPTION AND ANALYSIS OF THE EXISTING SYSTEM

3.1      FACT FINDING METHOD USED

3.2      ORGANISATIONAL STRUCTURE

3.3      OBJECTIVES OF THE EXISTING SYSTEM

3.4      INPUT, OUTPUT AND PROCESS ANALSYSIS

3.5      INFORMATION FLOW DIAGRAM

3.6      PROBLEMS OF THE EXISTING SYSTEM

3.7      JUSTIFICATION FOR THE NEW SYSTEM

CHAPTER FOUR

DESIGN OF THE NEW SYSTEM

4.1      OUTPUT SPECIFICATIONS AND DESIGN

4.2      INPUT SPECIFICATIONS AND DEISGN

4.3      FILE DESIGN

4.4      PROCEDURE CHART

4.5      SYSTEM FLOWCHART

4.6      SYSTEM REQUIREMENTS

CHAPTER FIVE

IMPLEMENTATION

5.1      PROGRAM DESIGN

5.2      POGRAM FLOW CHART

5.3      PSEUDOCODE

5.4      SOURCE PROGRAM

5.5      TEXT DATA

5.6      SAMPLE REPORTS

CHAPTER SIX

DOCUMENTATION

6.1      SYSTEM DOCUMENTATION

6.2      PROGRAM DOCUMENTATION

6.3      USER DOCUMENTATION

CHAPTER SEVEN

CONCLUSION AND RECOMMENDATION

7.1      CONCLUSION

7.2      RECOMMENDATION

BIBLIOGRAPHY

CHAPTER ONE

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 9^th 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 9^th Mile Corner.  The objective includes:

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 9^th 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.