DESIGN AND IMPLEMENTATION OF A COMPUTERIZED WATER DISTRIBUTION COMPANY SUPPLY MANAGEMENT SYSTEM

ABSTRACT

Supply chain management is the coordination of production, inventory, location, and transportation among the participants in a supply chain to achieve the best mix of responsiveness and efficiency for the market being served. Investigation reveals the following problems of the existing supply management system for water Distribution Company; most suppliers lack the technical expertise to dispense their duties; the manual system of managing supply records makes the business difficult to manage, inability to instantly determine customers to supply to that booked for the product for a particular date. Unclear specifications or careless supplier specification, lack of detailed information of the customers that need the product and their specific demand, and the purchasing and supply department of many business organizations lack clear rules and guidelines with regard to procurement and supply governance. It is in view of these problems that this research study is carried out. The aim of the Study is to implement Supply management system for water Distribution Company a case study of Terry Water Company. The following are the objectives of the study; to develop an automated system for supply management to manage supply functions, a system that will aid easy capture and retrieval of supply details, a system that will help in maximizing profit by determining priority of supply, and a system that will present reports of supplies when needed by management. 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. Based on the findings of this study, recommendations made are that will aid the management of Terry Water Company to properly manage the records of supplies to be made on a daily basis and the system will enable the water company to be able to determine who they have supplied to and those that are still pending.

Visit TextFancy.com to make your strings more stylish. Pick emojis and other characters, generate ascii art and more.

CHAPTER ONE

1.1 Introduction

Increasingly, supply chain management is being recognized as the management of key business processes across the network of organizations that comprise the supply chain. While many have recognized the benefits of a process approach to managing the business and the supply chain, most are vague about what processes are to be considered, what sub-processes and activities are contained in each process, and how the processes interact with each other and with the traditional functional silos. Streamlining cross-company processes is the next great frontier for reducing costs, enhancing quality, and speeding operations. It is where this decade’s productivity wars will be fought. The victors will be those companies that are able to take a new approach to business, working closely with partners to design and manage processes that extend across traditional corporate boundaries. They will be the ones that make the leap from efficiency to super efficiency.

The definition of supply chain management developed and used by The Global Supply Chain Forum: Supply Chain Management is the integration of key business processes from end user through original suppliers that provides products, services, and information that add value for customers and other stakeholders.

The Forum members identified eight key processes that need to be implemented within and across firms in the supply chain. Supply chains encompass the companies and the business activities needed to design, make, deliver, and use a product or service. Businesses depend on their supply chains to provide them with what they need to survive and thrive. Every business fits into one or more supply chains and has a role to play in each of them. The pace of change and the uncertainty about how markets will evolve has made it increasingly important for companies to be aware of the supply chains they participate in and to understand the roles that they play. Those companies that learn how to build and participate in strong supply chains will have a substantial competitive advantage in their markets.

1.2 Statement of Problem

Investigation reveals the following problems of the existing supply management system for water Distribution Company;

Most suppliers lack the technical expertise to dispense their duties; the manual system of managing supply records makes the business difficult to manage.
Inability to instantly determine customers to supply to that booked for the product for a particular date. Unclear specifications or careless supplier specification,
Lack of detailed information of the customers that need the product and their specific demand
The purchasing and supply department of many business organizations lack clear rules and guidelines with regard to procurement and supply governance. It is in view of these problems that this research study is carried out.

1.3 Aim and Objectives of the Study

The aim of the Study is to implement Supply management system for water Distribution Company a case study of Terry Water Company.

The following are the Objectives of the Study:

To develop an automated system for supply management to manage supply functions
To develop a system that will aid easy capture and retrieval of supply details.
To develop a system that will help in maximizing profit by determining priority of supply
To develop a system that will present reports of supplies when needed by management.

1.4 Scope of the Study

This study covers the development of a Supply management system for water Distribution Company a case study of Terry water company, Ikot Ekpene.

1.5 Significance of the Study

This study is significant in the following ways:

It will aid the management of Terry Water Company to properly manage the records of supplies to be made on a daily basis.
The system will enable the water company to be able to determine who they have supplied to and those that are still pending.
It will provide an easy way of updating and verifying supply records of customers.
The system will serve as a management information system to the management of terry Water Company.
The study will serve as a useful reference material to other researchers and academicians seeking related information on supply management.

1.6 Organization of the Research

This research work is organized into five chapters.

Chapter one is concerned with the introduction of the research study and it presents the preliminaries, theoretical background, statement of the problem, aim and Objectives of the Study, significance of the Study, scope of the Study, organization of the research and definition of terms.

Chapter two focuses on the literature review, the contributions of other scholars on the subject matter is discussed.

Chapter three is concerned with the system analysis and design. It presents the description of the existing system, analysis of the proposed system and system design..

Chapter four presents the system implementation and documentation, the choice of programming language, analysis of modules, choice of programming language and system requirements for implementation.

Chapter five focuses on the summary, constraints of the Study, conclusion and recommendations are provided in this chapter based on the study carried out.

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 institution 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.

1.8 Definition of Terms

Demand: The amount of a good or service that consumers are willing to buy at a particular price.

Database Application: A software program for storing, retrieving and manipulating a database.

Supply: To provide, give, sell, or make available something that is wanted or needed by somebody or something.

Management: Administration of business, the organizing and controlling of the affairs of a business or a sector of a business.

…

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 a Computerized Water Distribution Company Supply Management System 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;

Preliminary Pages,
Chapter 1-5,
References and Appendix.

TABLE OF CONTENTS
PRELIMINARY PAGES

Title page
Approval page
Dedication
Acknowledgement
Table of Contents
Abstract
CHAPTER ONE
INTRODUCTION
1.1 Introduction
1.2 Statement of Problem
1.3 Aim and Objectives of the Study
1.4 Scope of the Study
1.5 Significance of the Study
1.6 Organization of the Research
1.7 Limitations of the study
1.8 Definition of Terms
CHAPTER TWO
LITERATURE REVIEW
2.0 Introduction
2.1 Theoretical Review
2.2 Concept of Supply Management
2.2.1 Understand Supply Management
2.2.2 Supply Management Division
2.3 History of Supply Chain Management
2.3.1 Origin of the Term and Definitions
2.3.2 Functions of Supply Chain Management
2.3.3 Importance of Supply Chain Management
2.4 Inventory Management
2.4.1 Procurement process
2.4.2 Product Development and Commercialization
2.4.3 Manufacturing Flow Management Process
2.4.4 Physical Distribution
2.4.5 Outsourcing/Partnerships
2.4.6 Performance Measurement
2.4.7 Warehousing Management
2.4.8 Workflow Management
2.5 Concept of Water Distribution System
2.5.1 Definitions of Water Distribution System
2.5.2 Components of Water Distribution System
2.5.3 Topologies of Water Distribution System
2.5.4 Integrity of the Systems
2.6 Network Analysis and Optimization of Water Distribution
2.7 Hazards of Water Distribution
2.8 Maintenance of Water Distribution System
2.8.1 Internal corrosion control
2.8.2 Hydrant Flushing
2.1.8.3 Water main renewals
2.9 Water Distribution Systems
2.9.1 Infrastructure
2.9.2 Pipes
2.9.3 Pipe-Network Configurations
2.10 Storage Tanks and Reservoirs
2.10.1 Pumps
2.10.2 Valves
2.10.3 Hydrants
2.11 Infrastructure Design and Operation
2.12 Residential Drinking Water Provision
2.12.1 Fire Flow Provision
2.12.2 Decentralized Treatment
2.13 Water Supply Alternatives
2.13.1 Surface Water
2.13.2 Ground Water
2.13.3 Purchased Water
2.13.4 Water Conservation
2.14 Advantages of Water Supply
2.15 Limitation of Water Supply
2.16 Importance of Water Supply System
CHAPTER THREE
RESEARCH METHODOLOGY AN SYSTEM ANALYSIS
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.3.3 Weakness of the existing System
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
DESIGN AND IMPLEMENTATION OF THE NEW SYSTEM
4.1 Design Objectives
4.1 Design Standard
4.2 Output Specification and Design
4.3 Input Design and Specification
4.4 File Design
4.4.1 Water Supply Request table structure
4.4.2 Register table structure
4.4.3 Country table structure
4.5 System Requirements
4.5.1 Hardware Requirements
4.5.2 Software Requirements
CHAPTER FIVE
SUMMARY, CONCLUSION AND RECOMMENDATION
5.1 Summary
5.2 Conclusion
5.3 Recommendations
REFERENCES
APPENDIX A "SOURCE CODE"
APPENDIX B "OBJECT PROGRAM"

Disclaimer for Complete Material Utilization
The displayed research work titled "Design and Implementation of a Computerized Water Distribution Company Supply Management System" 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 “Knowledge of University Student on Laboratory Safety Education” be used as a guide for Science Education Project?

Yes it can be used — The study was carried out to examine the Knowledge of University Student on Laboratory Safety Education. In achieving this aim, the following specific objectives were laid out to determine the knowledge regarding laboratory safety precautions among University Students, analyze the understanding of high school students on laboratory work safety material and determine the current level of laboratory safety awareness among University Students in the area under study. Investigation revealed that students’ attitudes towards laboratory safety were lacking and needed more safety training and awareness activities or programs in the university. The unfortunate and regrettable state of equipment tools and laboratories have been attributed to inability of the operators to apply preventive and total maintenance culture as at when due, on …

Can the material for “Effects of Sales Force Training on Organizational Performance” be used as a guide for Human Resource Management (HRM) Project?

Yes it can be used — The study was carried out to investigate the Effects of Sales Force Training on Organizational Performance using Chicken Republic in Ado-Ekiti as a case study. In achieving this aim, the following specific objectives were laid out to ascertain the nature of relationship that exist between training of sales-force and organization profitability and examine the effect of motivation of sales-force on organization growth. Investigation revealed that the failure of sales force could have industrial, managerial and marketing implications which this study is set to explore, and which constitutes its research problem. Particularly in the context of how the sales force are motivated towards improving productivity using the incentives of salaries, sales calls allowances, sales bonuses, access to sales vans, product availability …

Is the topic “Automated Logbook System for Students Industrial Work Experience Scheme” recommended for Computer Science (CS) Project?

Yes it is highly recommended — The Students Industrial Work Experience Scheme (S.I.W.E.S) is an industrial training program for Nigerian university undergraduate students and other higher institutions. The aim of the study is to design and implement Automated Logbook System for Students Industrial Work Experience Scheme (SIWES). In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will Provide opportunities to apply their knowledge to actual practice thus making the college work easier and Enable students to practice theory at school, and to provide access to the non-school production equipment. The motivation that led to the implementation of the proposed system is that the existing system there is unnecessary delay in the payment of students and supervisor …

Can this topic “Impact of Insurance Companies on Economic Growth in Nigeria (1986-2016)” be used for Economics Project?

Yes it can be utilized for research — Insurance is a veritable sub-sector in the financial system that plays a critical role in growth and development process in an economy. Against this backdrop, the study examined the impact of insurance industry on economic growth in Nigeria between 1986 and 2016. The study precisely investigated the impact of life insurance and non-life insurance penetration on economic growth in Nigeria. The ordinary least square technique was employed in the analysis of data. The result revealed that life insurance penetration and non-life insurance penetration positively and significantly impacted on economic growth within the estimated period. Furthermore, a 1% increase in life-insurance penetration would produce about 17% increase in economic growth and 1% increase in non-life insurance penetration would generate approximately 40.8% increase …

Is the topic “Design and Implementation of an Online Learning Management System” recommended for Computer Science (CS) Project?

Yes it is highly recommended — Online Learning is a web-based environment that allows students to participate in live teaching and learning events without the need to travel. The aim of the study is to develop an Online Learning Management System using Computer Science Department in NOUN University as a case study. In achieving this aim, the following specific objectives were laid out as follows to design an application that will, provide alternative way of attaining education, facilitate the development of information technology, enhance examination and certification of students thereby improving the standard of education, reveal the use and technology of wireless network to the user, proffer solution to students whom because of nearness to institute and are unable to acquire knowledge that they need, and …

Can this topic “An Investigation Into the Impact of Community Policing as a Strategy for Crime Prevention and Control” be used for Criminology and Security Studies Project?

Yes it can be utilized for research — Community policing is in hand with systematic relationship between the police and the entire people in the community. The study investigates the Impact of Community policing as a Strategy for Crime Prevention. In achieving this aim, the following specific objectives were laid out to identify the prevalence of community policing on crime reduction, determine the factors that affect community policing, inquire the efforts taken by the government to ensure better community policing, and examine the effects of community policing by crime prevention and control in Nigeria. 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 …

Is the topic “Development of an Automated Result Computation System” recommended for Computer Science (CS) Project?

Yes it is highly recommended — Result computing are vital recurrent procedures and processes in every university system that is inevitable. The aim of the study is to design and implement an Automated Result Computation System. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will provide a reliable solution to result processing that is corruption free and maintain a reliable database for storage of students’ records and update as the need arises. The motivation that led to the implementation of the proposed system is that the effort expended in the process of registration of students and computation of their examination results is tedious. Also, it is quite worrisome that these processes are carried out every …

Can the material for “Effect of Mix Ratio and Curing Water on the Compressive Strength of Oil Palm Shell (OPS) Aggregate Concrete” be used as a guide for Civil Engineering Project?

Yes it can be used — In this study, the compressive strengths and Modulus of elasticity of lightweight Concrete with oil palm shells as partial replacement of coarse aggregate was presented. The different types of mixing water were used, namely, clean water from Ahmadu Bello University Water Works, Salt water, obtained from Lagos Shore and Pond water obtained from Nagoye, Zaria. Also three mix ratios were adopted which include 1:2:4, 1:1.5:3 and 1:1:2 mix ratios. Five mixes were investigated; control, which contain granite coarse aggregate only; then four other mixes with 20%, 40%, 60% and 80% granite coarse aggregate replacement by oil palm Shell (OPS) aggregate. Fifteen samples where produced for each mix ratio, given a total of 135 concrete cube specimen for compressive strength tests and …

Can the material for “Management of Stress Among Female Managers” be used as a guide for Business Administration and Management (BAM) Project?

Yes it can be used — The topic stress has come into being since the creation of man. However, the activity of man in organization seems to be the cause of his problem as want at times pressure or urgency by trying to engage in complex and difference task. The primary data would be the information gotten by researcher when she, the researcher conducted an oral interview and researched questionnaire contribution to officials or department heads of Power Holding Company of Nigeria based on research questionnaire namely: Section A” whether organizational defective has any influence on female managers stress and section B” whether female managers individuals problems contributed into stress and is work load a cause of stress in Power Holding Company of Nigeria (All those …

Can the material for “The State as a Community of Persons in Hegel; A Critique” be used as a guide for Philosophy Project?

Yes it can be used — This study was carried out to critique the state as a community of persons in Hegel. One of the objectives of the study was to evaluate how the Hegelian conception of the state fails to account for the specific state forms and process. The researcher adopted the doctrinal research method for the data analysis of the empirical literature. From the study it was concluded that Marx's community of freedom is a transformed social world in which people are treated not as rights-bearing citizen consumers as 'freely associated producers' but in contrast, Hegel's 'community of freedom is the rational state, a political and juridical order whose members encounter one another primarily as citizens and bearers of rights'. …