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)
Can the material for “Development of a Web Based Airline Reservation System” be used as a guide for Computer Science Education Project?
Yes it can be used — An Airline Reservation Information System is a computerized system used to store and retrieve information and conduct transactions related to travel. The aim of the study is to Design and Implement a Web Based Airline Reservation System. In achieving this aim, the following specific objectives were laid out as follows to design and develop an application software that will minimize cost of maintenance instead of spending more money in purchasing of new equipment and increase output of passenger manifest with the interconnection more than one computer system over network. The motivation that led to the implementation of the proposed system is as a result of inefficiency will be notified and new system design implemented. With references to the rapid growth …
Can this topic “The Contribution of Micro Finance Banks in the Empowerment of Small-Scale Business” be used for Finance Project?
Yes it can be utilized for research — This study reviewed the crucial role of micro Finance Banks in promoting small scale enterprise. The purpose of this study is to provide means through which those problems facing small scale can be solved; the significant of this is to provide means in which government can assist micro finance banks will bring lasting solution to those problems facing small scale industries, in the analysis of data collected, the research used descriptive method. All the data gathered by the researcher were tabulated and analyzed accordingly. It is included that micro finance banks is an indispensable ingredient for efficient, effective and successful performance of an organization, it also showed that micro finance banks is the source of fund to small scale business. The study of …
Can the material for “Design and Implementation of an Online Forum Discussion System” be used as a guide for Computer Science (CS) Project?
Yes it can be used — Online Based forums also known as discussion boards enable users of a website to interact with each other by exchanging tips and discussing topics related to a certain theme. The aim of the study is to design and implement an Online Forum Discussion System for Computer Science and Engineering Students in FUTO. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will protect information from unauthorized users by implementing role based security and implement a secured web forum for students and lecturers of the Department Of Computer Science, University of Port Harcourt. The motivation that led to the implementation of the proposed system is that due to busy schedules of …
Can the material for “Impact of Effective Management of Finance on the Success of Business Organization” be used as a guide for Business Management Project?
Yes it can be used — Management of finance is one of the indispensable factors used in organization for the achievement of goal and objectives. Management tools that manages in an organization need in order to perform better. This research work focused on effective management as a tool for achieving business success using Union Bank of Nigeria Plc, Keffi Abuja road, New Nyanya branch as a case study. The researcher used questionnaires, primary and secondary source of data collection. Tables and percentages were used for data analysis. It was observed that managers used ratio analysis, portfolio analysis and break even analysis as management tools. It is recommended that organization should properly met irate their managers to avoid low profitability for the achievement of its goals and …
Can the material for “Information Technology and the Changing Role of Mass Media in Nigeria: A Discourse on the Impact of Information Technology and Media Development in Nigeria” be used as a guide for Mass Communication (MC) Project?
Yes it can be used — The study was carried out to examine the Information Technology and the Changing Role of Mass Media with reference to the Impact of Information Technology and Media Development in Nigeria. Investigation revealed that mass media in Nigeria is underdeveloped. The problems militating against the effective use of Information Technology resources in Nigeria media industry include; unreliable power supply, incompetent human resources, unreliable telecommunication network and lack of adequate capital. These challenges could be overcome through the provision of reliable power supply and telecommunication network, human resources development in the area of IT and the provision of adequate capital. The research design used in this report is descriptive design, utilizing questionnaire method to obtain information from the respondents for this project. A …
Can the material for “The Effects of Working Capital Management on the Profitability of Manufacturing Company” be used as a guide for Business Administration and Management (BAM) Project?
Yes it can be used — The study investigated the Effects of Working Capital Management on the profitability of manufacturing Company, A Case study of Cadbury Nigeria Plc. The specific objectives of the study are to identify the various components of working capital in Cadbury Nigeria PLC; identify the level of working capital management in Cadbury Nigeria PLC; and to evaluate the impact of working capital management on the profitability of Cadbury Nigeria PLC. Total of questionnaires was distributed to staff in Cadbury Nigeria Plc drawn from the study population was used for the analysis. Three hypotheses were formulated for the study, simple percentage and ratio analysis. Under the simple percentage and ratio analysis was analyzed by the use of tables which involved the use of …
Can the material for “Effect of Consolidation on Corporate Financial Performance” be used as a guide for Accountancy / Accounting Project?
Yes it can be used — In this research work titled effect of consolidation on corporate financial performance of Nigerian banking sector. The researcher examined the effect of total assets on earnings per share of Nigerian banks. The effect of total deposit on earnings per share of Nigerian banks. And the effect number of branches of Nigerian banks on earnings per share of the banks. Data for the study was sourced through the annual report of the selected banks (Access bank plc and Guarantee Trust bank plc) and journal articles related to the subjects matter. Eview was used in the data analysis. The result revealed that the observed distribution for Earning per share, value(EPS), Total Assets (TOASSETS), Total Deposit (TODEPOSIT) and Numbers of Branches (BRA) have …
Is the topic “Synergistic Effect of Bacteriocin-Like Inhibitory Substances Produced by Vaginal Lactobacillus Against Group B Streptococci” recommended for Microbiology Project?
Yes it is highly recommended — The vaginal normal flora of a healthy woman is dominated by species of Lactobacillus. The balance between the vaginal flora is maintained by the protective antagonizing compounds produced by Lactobacillus. Group B Streptococci (GBS) is an opportunistic organism usually carried asymptomatically by pregnant women but cause severe neonatal infections. Antibiotics chemotherapy poses a lot of threat especially to pregnant women. Thus, this study was aimed at evaluating the antimicrobial activity of bacteriocin-like inhibitory substance produced by vaginal Lactobacillus of pregnant women on GBS. Identification of isolates was by microscopy, cultural characteristics and biochemical tests. Lactobacillus isolates were tested for their ability to inhibit GBS using agar diffusion method. Partial purification was done using ammonium sulphate precipitation and dialysis. The result …
Can this topic “Effect of Globalization on Non-Oil Export trade” be used for Business Administration and Management (BAM) Project?
Yes it can be utilized for research — This project work is concerned with effects of globalization on non-oil export trade. Globalization as a concept can be attributed to two major reasons: The first is its scale and speed and the way technology (especially in communications and transportation) is changing the world. Second, it is the latest in economic fad that has become accepted as changing the international environment and turning the whole world into a global villages. Three hypotheses were tested through statistical package for the social sciences (SPSS) along with least square, regression analysis, F-statistic (ANOVA), t-statistic, co-efficient of correlation among others were used to analyse the result of the findings. The findings of the study revealed that globalization has enhanced the growth of non-oil export trade, that globalization …
Can the material for “Parent Awareness of the Health Implication of Child Abuse” be used as a guide for Health Education Project?
Yes it can be used — Child abuse is a type of physical or mental injury or maltreatment of a person who is regarded as a child. The study was carried out to investigate the Parent Awareness of the Health Implication of Child Abuse. In achieving this aim, the following specific objectives were laid out to ascertain the effect of child abuse on the academic performance of the child and roles of parents and government in curbing the menace. Investigation revealed that the issue of child abuse has been recognized as a major global social problem prevalent within and outside the homes and among all socio-economic groups of both the developed and the developing nations of whole world. Parents now push over the responsibility of caring …