DESIGN AND IMPLEMENTATION OF AN AUTOMATED SYSTEM FOR INVENTORY CONTROL IN A MANUFACTURING COMPANY
ABSTRACT
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 a manufacturing organization. The system is designed to efficiently handle the movement and tracking of goods through the replacement of human workers by technology. The manual method or intervention is labour intensive, costly, and error prone and cannot ensure 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 allows inventory status to be determined and shipping and receiving documents to be generated automatically triggering automatic orders for products that are low in inventory. 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 using web based programming languages and MySQL for the database.
The methodology adopted in this study is the object oriented analysis and design methodology (OOADM) which is a technical approach for analyzing and designing an application or system by applying object throughout the software development process. The programming language used is HTML, CSS, JAVASCRIPT, PHP, SQL and JQUERY. The reason why web programming languages was used is because, it is platform independent and it is a web based application. The fact finding techniques employed is interview, observation, online and library research.
CHAPTER ONE
1.0 Introduction
An inventory control system contains a list of orders to be filled and then prompts workers to pick the necessary items, and provides them with packaging and shipping information. Inventory control may be used to automate sales order fulfilment process and also manage in and outward material of hardware. Automation is the replacement of human workers by technology. For optimal sales and inventory management process, robust functionality is needed for managing logistics facilities. Warehouse management functions for inventory control cover internal warehouse movements and storage and its support helps in the recording and tracking of materials on basis of both quantity and value.
This application takes care of all supply orders reducing cost for warehousing, transportation while improving customer service. It significantly improves inventory turns, optimizes flow of goods. It also improves cash flow, visibility and decision making providing efficient execution of tasks using this fast and reliable computerised method.
1.1 Background of the Study
The Nigerian Breweries PLC was established in the year 1946. It aims at providing satisfaction and nourishment to the Nigerian population through the distribution of drinks like beer, coca-cola, fanta, sprite etc. It is second to none and for this reason, the demand is high and the company responds to the increasing demand by stabilizing supply to strike a balance. Justifiably, the company has the problem of keeping adequate record of goods transfer and since it is done manually, associated problems of insecurity, high cost of operation and delay in supply arise. Data processing in Nigerian Breweries PLC is presently carried out using people, pens, and paper to control stock and inventory. The design and development of an automated inventory control system for the Nigerian Breweries PLC will no doubt bring immeasurable relief from the problems associated with the manual system.
1.2 Statement of the Problem
The Nigerian Breweries PLC is to an extent manually operated and reveals a number of problems.
- The recording of sales and cash received are done manually on a book that appears rough. Thus, the books are exposed to physical damage, information can be lost and dust particles are accumulated.
- The long list of supply orders waiting to be attended to on daily basis.
- The control system is time consuming, less accurate and less efficient, and the environment is not user friendly.
- Inaccuracies often ensue from human error.
- The manual system is quite tedious and can be reduced or eliminated with the introduction of the proposed system.
1.3 Purpose of the Study
The purpose of this study is to improve current operational process in the Nigerian Breweries PLC to its full capacity by developing efficient computer software that can handle inventory in a computerised fashion.
1.4 Significance of the Study
This study is primarily aimed at increasing efficiency in operations, reducing maintenance and running cost, monitoring the supply of goods and its distribution and increase profit in the Nigerian Breweries PLC by introducing an automated inventory control system.
1.5 Objectives of the Study
The main objective of this study is to develop a computerised inventory control management system. Others include;
- It provides total asset visibility.
- It allows reduced inventory stocking levels giving full inventory history.
- It reduces lead time, shelf space, and errors due to damage, fatigue of staff and overall cost of operations.
- It facilitates “just in time” deliveries.
- It provides full process control for products.
- It provides higher level security as the system would be passworded to prevent unauthorised access.
- It shortens cross docking time and speeds up sort/pick up rate.
- It helps the management plan, monitor, optimize resources and ascertain their financial position at any time.
1.6 Scope of the Study
The scope of this study covers the Nigerian Breweries PLC as a whole, and its customers which include retailers, distributors and the general public.
1.7 Limitations of the Study
During the course of this study, there were some problems encountered which stood as limitations to the research work. Some of the limitations include:
- Time Constraint:
The time frame given to accomplish this project was very short due to school academic calendar and it was carried out under pressure which made the researcher not to implement some necessary features.
- Financial Constraint:
Insufficient fund tends to impede the efficiency of the researcher in sourcing for the relevant materials, literature or information and in the process of data collection (internet, questionnaire and interview).
- Initial Cooperation Delay from Respondents:
A particular limitation of this work came as a result of the respondent refusal to offer their cooperation at the initial time they were contacted. This contributed in making the success of this research study difficult.
1.8 Definition of Basic Concepts
Automation:
This is the use of technology or computers to control and process data reducing the need for human intervention.
Database:
This refers to a large store of related data on a computer that a user can access and modify.
Password:
This is a secret code that must be entered into a computer to enable access to its applications. It is made up of numbers, letters, special characters or a combination of any of the above categories.
Inventory Control System:
A list of orders to be filled, and prompts workers to pick the necessary items and provides them with packaging and shipping information.
Computerization:
This is the conversion of a manually operated system to a controlled, organized and automated system.
Research:
A careful study of a subject to discover facts, establish a theory or develop a plan of action based on the facts discovered.
System:
A set of computer components functioning together.
Technology:
The study of techniques of mobilizing resources such as information for accomplishing objectives that benefit man and his environment.
Software:
A computer program or set of instructions that direct a computer to perform processing functions. Information.
System:
A collection of procedures, people, instructions and equipment to produce information in a useful form.
Processing:
This is dealing with something according to an established procedure.
CHAPTER TWO
2.0 Literature Review
2.1 Introduction
The review of relevant literature is the main topic of this chapter. A literature review covers theoretical and methodological contributions to a certain issue in addition to the state of knowledge at the time of writing. It provides information about the state of the art in relation to the subject you are writing about. It examines the body of work on the chosen subject. The literature evaluation in this study comprises the …
Procedure for Downloading the PDF (Docx) Material
Design and Implementation of an Automated System for Inventory Control in a Manufacturing Company (A Case Study of Nigerian Breweries Plc, Enugu) can be downloaded by requesting the full set of materials at the project or seminar cost. The document will be sent via Microsoft Word (MS-Word) format via WhatsApp (e-mail) following payment confirmation.
| Seminar Material Cost ₦3,000 | Project Material Cost ₦5,000 |
Request Complete Material
 | Click here to request the Complete Material via WhatsApp including;
|
TABLE OF CONTENTSPRELIMINARY PAGES
- Title page
- Approval page
- Dedication
- Acknowledgement
- Table of Contents
- Abstract
INTRODUCTION
- 1.0 Introduction
- 1.1 Background …
- ⋮
LITERATURE REVIEW
- 2.1 Introduction
- ⋮
CHAPTER THREE
SYSTEM ANALYSIS AND DESIGN
- 3.1 Methodology Adopted
- 3.1.1 Problem Identification Using SSADM
- 3.2 Analysis of the Existing System
- 3.2.1 Dataflow of the Existing System
- 3.2.2 Disadvantages Of The Existing System
- 3.2.3 Weakness of the existing System
- 3.3 Feasibility Study
- 3.3.1 Economic Feasibility
- 3.3.2 Technical Feasibility
- 3.3.3 Operational Feasibility
- 3.4 Analysis of the Proposed System
- 3.4.1 Data Flow Diagram of the Proposed System
- 3.4.2 Advantages of the Proposed System
- 3.4.3 Justification of the Proposed System
- 3.5 Functional Requirements
- 3.5.1 Use Case Diagram Of The Admin / User Privileges
- 3.6 Data Requirements
- 3.7 High Level Model of the Proposed System
CHAPTER FOUR
SYSTEM DESIGN AND IMPLEMENTATION
- 4.1 Objectives of the Design
- 4.2 Cohesion and Decomposition High level Model
- 4.3 Control Center / Overall Dataflow Diagram
- 4.3.1 Proposed System Operation Flowchart
- 4.4 System Specification and Design
- 4.4.1 Input and Output Specification
- 4.4.2 Database Specification and Design
- 4.4.3 Data Dictionary
- 4.5 Choice and Justification of Programming Language
- 4.6 Program Documentation
- 4.7 Implementation Techniques
- 4.7.1 System Testing
- 4.8 Programming Module Specification
- 4.8.1 Installation
- 4.9 Computer Hardware Minimum Requirement
- 4.10 Software Requirement
- 4.11 Personnel / User Training
- 4.12 File Maintenance Module
CHAPTER FIVE
SUMMARY, CONCLUSION AND RECOMMENDATION
- 5.1 Introduction
- 5.2 Summary
- 5.3 Conclusion
- 5.4 Recommendation
REFERENCES
APPENDIX A - “SOURCE CODE”
APPENDIX B - “OBJECT PROGRAM”
Disclaimer for Complete Material Utilization
The displayed research work titled "Design and Implementation of an Automated System for Inventory Control in a Manufacturing Company" is stated as a research guideline towards accomplishing your assigned project / seminar research work. All the research materials on this website are ONLY for research purposes and should be used as a guideline in developing your research work. For no reason should you copy word for word as projectlist.com.ng will not be liable for any who copied the material. By ordering the complete research guideline, it signifies that you've accepted our terms of service.
PRELIMINARY PAGES
- Title page
- Approval page
- Dedication
- Acknowledgement
- Table of Contents
- Abstract
INTRODUCTION
- 1.0 Introduction
- 1.1 Background …
- ⋮
LITERATURE REVIEW
- 2.1 Introduction
- ⋮
CHAPTER THREE
SYSTEM ANALYSIS AND DESIGN
- 3.1 Methodology Adopted
- 3.1.1 Problem Identification Using SSADM
- 3.2 Analysis of the Existing System
- 3.2.1 Dataflow of the Existing System
- 3.2.2 Disadvantages Of The Existing System
- 3.2.3 Weakness of the existing System
- 3.3 Feasibility Study
- 3.3.1 Economic Feasibility
- 3.3.2 Technical Feasibility
- 3.3.3 Operational Feasibility
- 3.4 Analysis of the Proposed System
- 3.4.1 Data Flow Diagram of the Proposed System
- 3.4.2 Advantages of the Proposed System
- 3.4.3 Justification of the Proposed System
- 3.5 Functional Requirements
- 3.5.1 Use Case Diagram Of The Admin / User Privileges
- 3.6 Data Requirements
- 3.7 High Level Model of the Proposed System
CHAPTER FOUR
SYSTEM DESIGN AND IMPLEMENTATION
- 4.1 Objectives of the Design
- 4.2 Cohesion and Decomposition High level Model
- 4.3 Control Center / Overall Dataflow Diagram
- 4.3.1 Proposed System Operation Flowchart
- 4.4 System Specification and Design
- 4.4.1 Input and Output Specification
- 4.4.2 Database Specification and Design
- 4.4.3 Data Dictionary
- 4.5 Choice and Justification of Programming Language
- 4.6 Program Documentation
- 4.7 Implementation Techniques
- 4.7.1 System Testing
- 4.8 Programming Module Specification
- 4.8.1 Installation
- 4.9 Computer Hardware Minimum Requirement
- 4.10 Software Requirement
- 4.11 Personnel / User Training
- 4.12 File Maintenance Module
CHAPTER FIVE
SUMMARY, CONCLUSION AND RECOMMENDATION
- 5.1 Introduction
- 5.2 Summary
- 5.3 Conclusion
- 5.4 Recommendation
REFERENCES
APPENDIX A - “SOURCE CODE”
APPENDIX B - “OBJECT PROGRAM”
Disclaimer for Complete Material Utilization
The displayed research work titled "Design and Implementation of an Automated System for Inventory Control in a Manufacturing Company" is stated as a research guideline towards accomplishing your assigned project / seminar research work. All the research materials on this website are ONLY for research purposes and should be used as a guideline in developing your research work. For no reason should you copy word for word as projectlist.com.ng will not be liable for any who copied the material. By ordering the complete research guideline, it signifies that you've accepted our terms of service.
Frequently Asked Questions (FAQ)
Is the topic “Impact of Environment on Academic Achievement on Adult Learners in Selected Literacy Centres” recommended for Education Project?
Yes it is highly recommended — This study evaluated the effect of environment on teaching learning process of adults learners in Yetfund skill development centre Abeokuta. Fifty respondents were used, twenty-one, fifteen, nine and five from carpentry, block laying, welding and elect/elect respectively. Random sampling techniques was used for the study and the data collected was analysed using simple percentage, the findings of the study show that environment have great impact in teaching learning process of adult learners. Based on the findings an conclusion it is recommended among others that the government and other stakeholders in charge of literacy programme must provide acoustics for the learner bearing in mind that adult learners have different problems such as learning efficiency …
Can this topic “Laser Based Intruder Alarm System” be used for Physics Education Project?
Yes it can be utilized for research — Laser beam in light operated project works are mostly used as means of putting things ‘ON’ remotely or used as trap which when obstructed results in a switching into action another operation. The study was conducted to design and construct a laser based intruder alarm system. In achieving this aim, the following specific objectives were set out to develop a laser gun using a GA as diode to generate continuous laser beam for sensing by a detector, develop a receiving circuit based on LDR (light dependent resistor) to detect the laser beam, develop a switching circuit to switch into action a specified load, design a 555 timer based alarm system, and realize a suitable power supply system unit for the …
Is the topic “The Effective Management of Primary Schools in Ekiti State” recommended for Business Education Project?
Yes it is highly recommended — The study was carried out to examine the Effective Management of Primary Schools in Ekiti State. In achieving this aim, the following specific objectives were laid out to determine the difference in the management of human resources and the management of physical resources and examine the performance level of pupils in public examinations of primary schools in the area under study. Investigation revealed that irrespective of the importance of school records in the achievement of educational objectives, these records do not seem to be adequately managed by school principals. In Nigeria today getting accurate and reliable data has been a long letting problem. The research design used in this report is descriptive design, utilizing questionnaire method to obtain information from …
Can the material for “Effectiveness of Lagos State Traffic Management Authority (LASTMA) on Traffic Management” be used as a guide for Transport Management Technology Project?
Yes it can be used — Traffic management is the practice of managing the existing traffic environment to create avenue for free flow of traffic, to control and manage traffic proceedings. The study scrutinizes the Effectiveness of LASTMA on Traffic Management which is centered on the activities and achievements of LASTMA in Lagos since its creation and see whether it has been a success or a failure. In achieving this aim, the following specific objectives were laid out to determine if traffic congestion as reduce in Yaba routes - Ojota routes, determine if driving culture as be impacted on motorist, and find out if LASTMA has had a positive effect on driving culture. The research design used in this report is descriptive design, utilizing questionnaire method …
Is the topic “Design and Implementation of an Online Permanent Voters’ Card System” recommended for Computer Science (CS) Project?
Yes it is highly recommended — The Public opinion and democratic in universities setting are the most important determinant to establish a good administration. Voting is the process through which individuals convey their opinion and has the freedom to elect a leader of the choice to signify and address the student’s issues. In today’s technological and knowledge age, computerized related matters become widespread. E-voting is one of these substances and it is capable to deliver appropriate, less costly, fast and secure services. The aim of this paper is to present an online permanent voters’ system (E- Voting) to be applied to Muni University student’s electoral body. Several security measures were integrated into the E-Voting system in order to achieve an enhanced, speedy and accurate performance. A …
Can the material for “A Pragmatic Analysis of the Interplay Between Context and Illocutionary Acts on Meaning and Interpretation of Igala Proverbs” be used as a guide for English Language Project?
Yes it can be used — Proverbs play very important functional, communicative and pragmatic roles in Igala language. Their social and contextual importance has been attested to by ethnographers, philosophers, literary and other language experts, as instruments of communication, cultural education and channel of language aesthetics, as a house of wisdom, garnished and sustained among the Igala of Northern Nigeria. It is, perhaps, unimaginable thata speech event, involving a competent Igala speaker will be successfully conducted and concluded without the use of the appropriate and, contextually suitable proverbs, in order to achieve the purpose of the discourse. In spite of their rich linguistic and pragmatic importance, however, Igala proverbs have not been accorded critical linguistic and especially pragmatic focus in research, especially in relation to with …
Is the topic “Effective Solid Waste Management as a Booster to Nigeria Economy” recommended for Estate Management (EM) Project?
Yes it is highly recommended — It is always known that cleanliness is next to godliness and health is wealth Good health is achieved if there is good management of the environment. The need for a good management of the environment cannot be over emphasized since there is a continuing environmental decay as a result of increased urbanization. Pollution is a major problem of urbanization of which most of the causes have been identified as industrial combustion, solid waste generation, oil spillage disposal etc. since these causes are inevitable; there is need for a good control of them. In this project there will be a critical look at solid waste management situation with special focus on Cities Enugu. The project, which is required for the attainment of programme, will …
Can the material for “Causes of Ethnic Conflict Within Nigeria” be used as a guide for Public Administration (PA) Project?
Yes it can be used — Most developing countries are ethnically diverse. Ethnic diversity may lead to increased civil strife. This perception is tottered both by some graphic individual scenes of inter-ethnic violence, and by an aggregate correlation: Africa has not only the highest ethnic diversity, but also the highest incidence of civil war. Potentially, this might account for the detrimental economic effect of diversity. In countries of traditional stability, ethnic conflict is becoming an increasing factor. Ethnic conflicts have become the serious challenge of our times, which perhaps explains why ethnicity is seen as the reigning concept in African studies at present. In Nigeria, the colonial masters provided urban setting, which constitutes the cradle of contemporary ethnicity. The colonialist while pretending to carry out a …
Can the material for “Export Diversification Strategy for Economic Growth in Nigeria” be used as a guide for Banking and Finance (BF) Project?
Yes it can be used — This work is a research geared towards export diversification strategy for economic growth in Nigeria. The Nigeria economic growth has been hampered because of restricted export diversification arising from its export mono-product stance, a complete shift from hitherto exportable goods before the discovery of crude oil in late 1950’s despite the great potentials and abundance of human material and natural resources in the country. The economy has consistently remained in doldrums because of the aforementioned reason and steps are now being taken to find out solution to ensure maximum growth, the objective of this research is to achieve optimum diversification in export and positive economic growth to effectively do this certain relevant textbooks were viewed to have a good grasp …
Can this topic “Design and Implementation of a Computerized Bank Verification Number (BVN) System” be used for Computer Science (CS) Project?
Yes it can be utilized for research — Bank Verification Number (BVN) is the 11digit number you get from the bank after your picture, fingerprints, and signature have been captured electronically and successfully added to the database. The aim of the study is to design and implement a Computerized Bank Verification Number (BVN) System for Nigerians in the Diaspora and at home to use. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will examine the benefits of adopting an online BVN system and identify the necessary structures needed to run a successful online BVN system. The motivation that led to the implementation of the proposed system is that in the existing system, fraud and money laundering have …