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 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 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 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.
Department | Computer Science |
Project ID Code | CMS0124 |
Chapters | 7 Chapters |
No of Pages | 34 pages |
Methodology | Null |
Reference | YES |
Format | Microsoft Word |
Price | ₦4000, $15 |
|
|
Contact Us On | +2348039638328 |
Contact Us On | +2347026816414 |
|