+234 813 0686 500
+234 809 3423 853
info@grossarchive.com

DESIGN AND IMPLEMENTATION OF AUTOMATED WATER BILLING UTILITY SERVICE

  • Type:Project
  • Chapters:5
  • Pages:65
  • Format:Microsoft Word
(Computer Science Project Topics & Materials)

CHAPTER ONE

INTRODUCTION

  • Introduction

Effective billing and collection systems are a critical component for ensuring the viability of a service provider. Improving billing and collection activities has an immediate impact on the revenue streams of a service provider that can, in turn, help the service provider in improving services. However, while effective billing and collection practices depend on many internal factors (including customer databases, the extent of metered and unmetered service provision, tariff and billing structures, delivery of bills, and facilities for customer payments), the institutional arrangements under which service providers operate and provide services determine whether such practices will remain sustainable in the long term. Efficient billing and collection practices can set incentives for the provider to effectively charge and collect water bills while also fulfilling a commercial orientation to services Most  water utilities and service providers are under severe financial strain, with insufficient funds for routine maintenance, replacement, and expansion. Poor financial health is a result of a number of factors including inefficient operations, poor levels and/or absence of metering, poor billing and collection practices, poor structure and levels of water tariffs, increased and inefficient operational costs, and weak management. Billing and collection systems hence are critical for ensuring financial sustainability and for achieving cost recovery, especially if a service provider is looking to expand services and improve the equity of service provision [1].

1.1 Theoretical Background

The technologies used to implement the system are Visual Basic 6.0 programming language and Microsoft Access 2003 database. The programming language is used to create an interface that would be used to capture and compute water billing details and the information can be saved to the database for future retrieval. For instance, the source code below is used to query for bill records of customers using Adodc data control that is linked to the database by next due date for billing or by account number.

Private Sub Command1_Click()

Adodc3.Recordset.Filter = “NEXT_DUE_DATE_FOR_BILLING ='” & Text1.Text & “‘”

End Sub

Private Sub Command3_Click()

Adodc3.Recordset.Filter = “ACCOUNT_NO ='” & Text2.Text & “‘”

End Sub

Fig 1.1: Query form for existing records

1.2 Statement of the Problem

The following problems were identified to be faced by water billing companies like Akwa Ibom water company:

  1. The manual approach of billing customers is associated with numerous errors and mistakes.
  2. It is difficult to get accumulated bills from customers as tracking payments manually is difficult.
  3. It is difficult to accurately compute water bills.
  4. Delay in getting reports that pertain to water bills.
  • Aim and Objectives of the Study

The aim of the study is to design and implement automated water billing utility service system. The following are the objectives of the study to realize the aim:

  • To design a system that will be used to capture water billing details to database.
  • To develop a system that can be used to compute water bill
  • To design a system that can be used to present reports of water billing.
  • Significance of the Study

The significance of the study is that it will provide a more accurate and reliable approach to the computation of water bills as well as the storage and retrieval of bill records of consumers. The study will also serve as a useful reference material for other researchers seeking related information on water billing.

  • Scope of the Study

This study covers the design and implementation of automated water billing utility service, a case study of Akwa Ibom state water company.

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 research methodology used in the development of the system, it analyzes the present system to identify the problems and provides information on the advantages and disadvantages of the proposed system. The system design is also presented in this chapter.

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.

  • Definition of Terms

Bill – a written statement of how much money is owed for items purchased or services provided.

System – a collection of related parts working together to achieve a particular goal.

Revenue – money that comes into business from the sales of goods or services

Tariff – a list of fees, fares or other prices charged by a business.

DESIGN AND IMPLEMENTATION OF AUTOMATED WATER BILLING UTILITY SERVICE
Share This

Details

Type Project
Department Computer Science
Project ID CPU0483
Price ₦3,000 ($9)
Chapters 5 Chapters
No of Pages 65 Pages
Format Microsoft Word

500
Leave a comment...

    Details

    Type Project
    Department Computer Science
    Project ID CPU0483
    Price ₦3,000 ($9)
    Chapters 5 Chapters
    No of Pages 65 Pages
    Format Microsoft Word

    Related Works

    TABLE OF CONTENT Approval/Certification                                                                                    ii... Continue Reading
    CHAPTER ONE    1.0    INTRODUCTION              In some years back many operation were carried out manually. The method used to prepare bills was manual which possibly give room for fraud. Recently, computer came into an existence so as to solve many problem that may arise as a result or using manual and reduce the time... Continue Reading
    TABLE OF CONTENTS CHAPTER ONE: INTRODUCTION 1.1            Background of the Study 1.2            Statement of the Problem 1.3            Objectives of the Study 1.4            Methodology 1.5            Significance of the Study... Continue Reading
      ABSTRACT This project was centered on Hospital Billing information system. The current process of keeping records of patients is being operated manually and due to this procedure numerous problem are been encountered. A design was taken to computerized the manual process in order to check this problem. The problems were identified after series... Continue Reading
    (A Case Study Of Nigeria Telecommunication Limited Enugu) ABSTRACT It is obvious that the trend in techniques today has gone beyond the ordinary to extraordinary expect are working unrelenting to postulate new theory, disorder or manufacture new technology to satisfy the human... Continue Reading
    ABSTRACT It is obvious that the trend in techniques today has gone beyond the ordinary to extraordinary expect are working unrelenting to postulate new theory, disorder or manufacture new technology to satisfy the human desires or need and to solve global problems that is to say as... Continue Reading
    CHAPTER ONE 1.1     INTRODUCTION Hospital is health care institution or a place where people who are sick injured and wounded are given medical treatment, surgical care and cure, while billing is a process of showing an invoice on how much one owes or has to pay for service rendered. In summary hospital billing is amount of money to be paid or... Continue Reading
    CHAPTER ONE 1.1                                              INTRODUCTION The internet stands for international network; it is a huge web of network system connecting million of people all over the world. In fact, internet is a network of... Continue Reading
    ABSTRACT             The application of computer in various fields has eased a lot of problems encountered in the use of manual system in the various discipline if life. It is as measure towards addressing this issue that this project has primarily billing system that would get rid of the short falls. In this project, the researcher have... Continue Reading
    (A CASE STUDY OF NITEL ENUGU) ABSTRACT The application of computer in various fields has eased a lot of problems encountered in the use of manual system in the various discipline if life. It is as measure towards addressing this issue that this project has primarily billing system... Continue Reading