DESIGN AND IMPLEMENTATION OF A COMPUTERIZED WATER BILLING SYSTEM A CASE STUDY OF WATER COOPERATION

0
2505

ABSTRACT

With the advance in technology more in particular in the field of computer related organization, a lot of things are now automated. As a matter of fact, Information technology has a vital role in the design and implementation of electric billing system. Almost all the big organization are developing their billing system because of the extraordinary benefit resulting from information technology. Information technology has enabled electric billing system to work successfully.  To ease the operation of WATER COOPERATION co-operation, researcher took up this study by critically understanding the work, procedure involved, analysis of the various steps and at the same time detecting problem in the present system and designing a new system that has solution to the problem of the existing system. The new design is computerized and is subject to modification at any given time.  It also have this interaction feature and accurate in it’s output.

TABLE OF CONTENT

Title page                                                                                 i        

Certification                                                                              ii

Approval                                                                                   iii

Dedication                                                                                iv

Acknowledgement                                                                     v

Abstract                                                                                   vi

Organization of work                                                                 vii

Table of content                                                                        viii

CHAPTER ONE

1.0     Introduction                                                                              1

1.1     Statement of problem                                                                2

1.2     Aims and objectives                                                                  2

1.3     Purpose of study                                                                       3

1.4     Significant of study                                                                   3

1.5     Scope/Delimitations                                                                  4

1.6     Limitations/Constraints                                                              4

1.7     Assumption of study                                                                 5

1.8     Definition of terms                                                                     5                

CHAPTER TWO

2.0     Literature review                                                                       6

CHAPTER THREE

3.0     Description and analysis of the existing system                         9

3.1     Fact-finding method/ methodology                                             9

3.2     Organisational Structure/Organogram                              10

3.3     Objectives of the existing system                                              10

3.4     Input, Process, and Output Analysis                                          11

          3.4.1  Input Analysis                                                                 11

          3.4.2  Process Analysis                                                            11

          3,4.3  Output Analysis                                                               11

3.5     Information Flow diagram                                                12

3.6     Problems of the existing system                                                12

3.7     Justification of the new system                                                  13

CHAPTER FOUR

4.0     Design of the new system                                                         14

4.1     Design Standard                                                                       14

4.2     Output specification and design                                       14

4.3     Input specification and design                                                   14

4.3.1  File design                                                                      15

4.4     Procedure chart                                                                        16

4.5     Systems flowchart                                                                    17

4.6     System requirements                                                                18

          4.6.1  Hardware Requirements                                                  18

          4.6.2  Software Requirements                                                   18

          4.6.3  Operational Requirements                                               18

          4.6.4  Personnel Requirements                                                 18

CHAPTER FIVE

5.0     Implementation                                                                         19

5.1     Design Standard                                                                       19

5.2     Program design                                                                        20

5.2.1  Program Flowchart                                                          20

5.2.2  Pseudo code                                                                   24

5.3     Coding                                                                                     25

5.4     Test Data/Test Run                                                                  31

5.5     User Training – An overview                                                     31

5.6     Cutover Process                                                                       31

CHAPTER SIX

6.0     Documentation                                                                          32

6.1     The user documentation                                                            32

6.2     The programmer documentation                                                32

CHAPTER SEVEN

7.0     Recommendations, Summary and Conclusion                            33

7.1     Recommendation                                                                      33

7.2     Summary                                                                                  34

7.3     Conclusion                                                                               34

REFERENCES                                                                                   35

BIBLIOGRAPHY

APPENDIX                                                                                         36

SOURCE LISTING                                                                             36

LIST OF FIGURES                                                                             40

CHAPTER ONE

1.0           INTRODUCTION

Billing System is System that tracks customer usage of services, and calculates the impact on a customer’s account, based on the price of the services               

A computer-based billing system is necessary for handling and preparing of accurate bills for customers.  The new system will facilitate the prompt preparation of bills, easy retrieval of information, security to vital information and resource sharing among the billing department.

The previous billing system lacked the flexibility to quickly update services and provide customers with an acceptable level of detailed information. It is also programmer intensive to maintain,” said Miguel Echeverria, manager, information and technology.

In addition to the new billing system, customer bills have been redesigned to better serve customers. The new design is much more user friendly. Accounts with multiple water services will now have an account summary page followed by a detail sheet for each service.

All accounts will receive a new account number that will have a nine-digit customer number followed by a seven-digit premise number.

The new Water system allows customer service representatives to handle customer calls more efficiently,” said Customer Service Manager Marnie Hammer. “Customer service representatives will be able to view customer history on-line. As account history is built in the Advantage/Water system they will no longer have to look up past information on microfiche.”
Hammer added that in addition to implementing the new billing system, work processes that are involved in the processing of bills and responding to customer inquiries have been reviewed and will continue to be updated to provide better, more efficient customer service

The billing system is presently handling manually by the marketing department.  The marketing department took over the function of revenue billing from the traffic department in the 80’s.  Their main function is to raise customer’s bills of all statutory charges against users for the services rendered to them.

The role at which the bills are prepared with the increasing number of customer is insignificant.  There are procedural ways in which these bills are being prepared.  They are the provisional bills of vessels, the final bills of vessels and the miscellaneous bills.  A staff has to raise as many bills as the number of the customer increases: more importantly, delays bring extra cost on the importer, and this makes the importer feel disappointed when they come to collect their raised bills.

Hence, a thorough investigation and analysis of the manual billing method enables me to gain understanding on the true nature of their problems and design a computerized Water billing system that would bring solutions to the problem inherent.

1.1           STATEMENT OF PROBLEM

History has it that the billing system in WATER COOPERATION, has been plagues by several factors based on the current manual process by the use of different means, these factors includes:

Fills and records are not properly kept

Errors are easily made and hardly detected

A lot of time is wasted to prepare bills

Information is not well documented

Security of files or document is not granted.

DESIGN AND IMPLEMENTATION OF A COMPUTERIZED WATER BILLING SYSTEM A CASE STUDY OF WATER COOPERATION