DESIGN AND IMPLEMENTATION OF AN AUTOMATED INVENTORY MANAGEMENT SYSTEM FOR A MANUFACTURING COMPANY
ABSTRACT
An Automated Inventory Management System is a software-based business solution used to simultaneously track sales activity and inventory. Computerized Automated Inventory Management System for a Manufacturing Company save time for businesses by speeding up transactions while raising accuracy. The aim of the study is to design and implement a web based application that will manage the sales and inventory on goods and services. In achieving this aim, the following specific objectives were laid out to create a database that will help store sales records and develop an independent user application software. The motivation that led to the implementation of the proposed system is that the recording of sales and cash received are done manually on the book that appear rough, inaccuracies in record keeping due to human errors and difficulty involved in knowing when certain items need to be restocked.
The methodology adopted in this study is the structure system analysis and design methodology (SSADM) which is a technical approach for analyzing and designing an application or system by applying object oriented programming as well as visual modeling throughout the software development. 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 significance of this study is to Nigerian Breweries PLC that will provide easy-to-use and easy accessed system thus transactions will be more reliable and faster that they do not have to hire another employer to do the job. It gives more accurate and secure records of sales and list of products. Based on the findings of this study, recommendations made are that constant monitoring of the activities with the designated sales and inventory management software application, it is necessary to determine their level of compliance while adequate training should be provided for the recruitment of staff to enhance their efficiency and productivity. The expected result is an automated inventory management system that will capture the sales and inventory activities and automate sales and inventory task/activities.
CHAPTER ONE
1.1 Introduction
An Automated Inventory Management System is a software-based business solution used to simultaneously track sales activity and inventory. Manufacturers and trade resellers can both benefit from a thorough solution, where single transaction entry records necessary details on the customer, products purchased, price and date while also updating inventory levels. 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 fulfillment 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 computerized method.
As a prelude to other parts of this study, this chapter will discuss the background upon which this study was initiated, the statement of problems that led to this study, the Aim and Objectives of the study. Others are Significance of the study, Scope of work, Limitations of the Study and Definition of technical terms.
1.2 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. They also allow for consistent experiences in terms of customer service. People know there is always a uniform interaction at the register that requires tendering payment, taking a receipt and transition of ownership of products and services. This generates confidence in a business and ensures ongoing consumer relationships. Computerized systems are the most common method of inventory control and sales processing in retail markets.
1.3 Statement of the Problems
Investigation revealed 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.4 Aim and Objectives of the Study
The aim of the study is to design and implement a web based application that improve current operational process in the Nigerian Breweries PLC to its full capacity by developing efficient computer software that can handle inventory in a computerized fashion. In achieving this aim, the following specific objectives were laid out as follows:
- To develop an independent user application software;
- To automate sales and inventory task/activities;
- To capture the sales and inventory activities; and
- To create a database that will help store sales records.
1.5 Scope of the Study
The scope of this research is focused on the Design and Implementation of an Automated Inventory Management System for a Manufacturing Company using Nigerian Breweries PLC as a case study.
1.6 Significance of the Study
The significance of this study is to Nigerian Breweries PLC that will provide easy-to-use and easy accessed system thus transactions will be more reliable and faster that they do not have to hire another employer to do the job. It gives more accurate and secure records of sales and list of products.
Admin: manages the adding of stocks, updating the inventory, and determining the users of the system.
Customers: have the benefits of the printed receipts right after purchasing an item.
Future Researchers: would see the possibilities of upgrading the system.
Researcher: student, teacher, programmer and web-developer can benefit in this system through a detailed document
1.7 Limitations of the Study
During the course of this study, many things militated against its completion, some of which are:
- 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.
- Establishment Policies: Establishment policies posed a serious limitation as most staffs are not ready to release information needed for this project work. There were lots of information needed from the staffs of this establishment to enhance the study which took them time to release or they did not release at all for security purposes, hence the scope was reduced.
- 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).
- High Programming Technique: The programming aspect of this project posed a lot of problematic bugs that took us some days to solve. Problem such as database connections using PHP, MySql, posed a lot of challenging.
1.8 Definition of Terms
Customers: a person who buys goods or services from a shop or business.
Hardware: the physical tangible parts or component of a computer such as the cabinet, central processing unit, speakers and motherboard.
Inventory: is the goods and materials that a business holds for the ultimate goal of resale.
Inventory Management: a discipline primarily about specifying the shape and placement of stocked goods
Inventory Management system: the combination of technology (hardware and software) and processes and procedure that oversees the monitoring and maintenance of stocked products.
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 Inventory Management System for a Manufacturing Company 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.1 Introduction
- 1.2 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 Inventory Management System for 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.1 Introduction
- 1.2 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 Inventory Management System for 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 this topic “The Impact of Corruption on Good Governance and Development in Nigeria (1999-2013)” be used for Public Administration (PA) Project?
Yes it can be utilized for research — This study is an attempt to examine the extent corruption has retarded good governance and development in Nigeria from 1999 to 2011. If focuses on the determination of the cause(s) of corruption in Nigeria; the implications and recommendations of appropriate solutions to curb the menace. Discoveries were made such ; corruption as the cause of bad governance in Nigeria; breeds bad leadership; creates room for looting of public treasury by public office holders and enhances waste of government funds as a result of ghost workers. The key recommendations were also given such as; every public office holder should be made declare his or her assets before commencement of duties and prior to their leaving of offices and have to be …
Can the material for “Conflict Management Strategies of Principals as Perceived by Teachers in Secondary Schools” be used as a guide for Education Project?
Yes it can be used — This study is aimed at investigating the various strategies adopted by principals of secondary schools in Imo State in handling conflicts. Four research questions and three hypothesis guided the conduct of the study. Questionnaire was used to collect relevant data from three educational zones out of the six educational zones of the state. 720 teachers were randomly selected. T-test statistics was employed to test each hypothesis at 0.05 level of significance. The findings revealed that various levels of conflicts exist in secondary schools. They include, intra-personal, inter-personal, community related and inter-organizational conflicts. The most prevalent level of conflict are intra-personal, inter-personal and intra-unit/departmental. The study revealed that the conflict management strategies that are regularly used by principals are dialogue, communication and …
Can the material for “Minimizing Defective Product Through Effective Production Planning and Control in Defence Industries Corporation of Nigeria” be used as a guide for Business Administration and Management (BAM) Project?
Yes it can be used — This research work examine production planning and control as a tool for minimizing defective products through effective production planning and control in Defence Industries Corporation of Nigeria (DICON), Kakuri Kaduna. Hence the scope of the research cover every activity which has to do with production planning and control. The work covers statement of the general problems, research objectives, scope of the study, significance of the study and limitation of the study. Also diverse view of authors on production planning and control and other related areas in review. The research work employs the descriptive method for the purpose of an in-depth investigation. A sample size of 70 respondents was selected from the total population of 180 staff, questionnaire were administered to …
Can the material for “The Impact of Cash Flow Risk Management in the Insurance Industry” be used as a guide for Insurance Project?
Yes it can be used — The study was carried out to examine the Impact of Cash Flow Risk Management in the Insurance Industry. Investigation revealed that most insurance businesses encounter cash flow risk management problem at one time or another. Furthermore, cash flow problems can be serious and threaten your ability to stay in business if not well analyzed. Insurance companies are more at cash flow risk due to the nature of their business. The research design used in this report is descriptive design, utilizing questionnaire method to obtain information from the respondents for this project. A total of 133 (one hundred and thirty three) respondents were selected for this study to represent the entire population of the study. For null hypotheses were formulated and …
Can the material for “The Role of Financial Institution in Enhancing Business Activities” be used as a guide for Business Administration and Management (BAM) Project?
Yes it can be used — Financial institution has contributed immensely to the development of the economy of Nigeria by enhancing and playing a significant role in the activities of business in the economy and also contributing to the different sectors of the economy. In recognition of the important role of financial institutions in development of economy, this project work has been designed to enlighten all interested individuals who may not want to go into one business line or other on the availability of funds for them in any financial institution such as commercial banks like First Bank Nigeria Plc. The more individual’s ventures into business line, the more developed the nations economy becomes because the development of any given nation is measured by the numerous business activities …
Is the topic “Impact of Unemployment on the Economy of Nigeria” recommended for Economics Project?
Yes it is highly recommended — The term unemployment can be defined as a situation whereby those who are willing and able to work do not find job. This is mostly seen among greduates of various institutions of learning especially in underdeveloped nation like Nigeria. The study was designed to investigate the impact on unemployment on Nigeria economy (1980-2010). The research focuses on determining the causes and effects of unemployment and how the problem of unemployment in Nigeria will be reduced to a minimal level or even eradicated. It focuses on this objective: to determine the relationship between unemployment and economic growth in Nigeria (GDP).The method of analysis used in testing the hypothesis is the t-test, f-test e.t.c.Data for the study was obtained from the Central Bank …
Is the topic “Awareness of Mass Media Role in Generating News Against Drug Abuse” recommended for Mass Communication (MC) Project?
Yes it is highly recommended — The study was carried out to assess the Awareness of Mass Media Role in Generating News Against Drug Abuse. In achieving this aim, the following specific objectives were laid out to examine whether newspapers mass media educate and enlighten the general public on drug abuse, examine the problem facing the mass media in creating awareness on drug abuse and investigate the contribution of newspapers towards drug abuse through advertisement and alcohol promo. Mass media in organization provides news and opinions to a large number of people, retaining these people and building internal and external good will beyond reasonable assumption needed for an organization to remain and prosper in it. This led to the establishment of the media in Nigeria, vanguard …
Can the material for “Customary Succession Law in Modern Ibo Land; Judicial and Legislative Dimension in Focus” be used as a guide for Law Project?
Yes it can be used — Right from the beginning there has always been a transition from one generation to another generation and whatever assets or liabilities that were owned or used by one generation is usually passed or transferred to the succeeding generation. The law of succession is all about the transfer or devolution of property on the death of the owner[1]. It is the manner or form by which property devolves. Though there may not have been any law or statute enacted by a legislature for this purpose, yet each community have had their own beliefs and practices regulating same. Thus, it was held,[2] that it is the assent of the natives of a particular community to practices and customs in that community that makes …
Can the material for “The Impact of Organizational Structure in Effective Management of Nigerian Organization” be used as a guide for Microbiology Project?
Yes it can be used — The topic of this study is Impact of Organizational Structure in Effective Management of Nigerian Organization (A study of Nigerian Brewery Plc, Enugu State. The researcher adopted the descriptive survey design. The researcher used both the primary, and secondary sources of Data in the course of the study. The primary data was sourced through the instrument of questionnaire and oral interview while secondary data was sourced through texts books, magazines, journals and internet. The Population of the study is eight hundred and ninety while the sample size is one hundred and thirty-three. The findings revealed among others that organizational structure has a great impact in the effective management of organizations. The researcher recommended among others that organizations should endeavour to …
Can the material for “The Effect of Political Corruption on Nigerian Government and Politics” be used as a guide for Political Science Project?
Yes it can be used — The major purpose of this study was to examine the political corruption and its effect in the Nigerian government and politics. The study looked into political livies of Anambra state citizens being the case study of the work. For comprehensive understanding of the place and its impact of this study. The work has been divided into five chapters. In chapter one, comprises of statement of problems, significance of the study, purpose and research of the study and others. In chapter two comprises of the causes of corruption and poverty in Nigeria, Nigeria’s political godfathers, the evils of corruption, the effects of corruption in Nigeria which had put the federation into high jump from 1999 2010 in Nigeria especially Anambra state. …