Water Billing System with Short Messaging Services Notification

Only available on StudyMode
  • Download(s) : 1512
  • Published : April 21, 2013
Open Document
Text Preview
WATER BILLING SYSTEM WITH SHORT MESSAGING SERVICES NOTIFICATION

---------------------------------------------------------

A Special Problem
Presented to the Faculty of
The College of Information and Communication Technology
LAGUNA COLLEGE OF BUSINESS AND ARTS
City of Calamba

---------------------------------------------------------

In Partial Fulfillment
of the Requirements for the Degree
BACHELOR OF SCIENCE IN COMPUTER SCIENCE

---------------------------------------

By
MARPURI, MARK ANTHONY S.
OCAMPO, JONATHAN M.

October 2012

Chapter 1
THE PROBLEM AND ITS BACKGROUND

Introduction

The Laguna Water Company, Incorporated (Laguna Water) is a subsidiary of Manila Water that provides potable water at affordable rates to urban poor communities. This company supplies water in Laguna, betting the acquisition will help it serve more customers in one of the Philippines highly-developed provinces.

The Laguna Water currently serves around 120,000 customers (out of around 600,000 populations which it expects to increase to around 1 million within fifteen years). Currently, all of their customer’s information including the water consumption was stored in the customers’ database using spreadsheet. Since the Laguna Water Corporation is using a manual process, they are wasting a lot of time to store, manage, update and retrieve all the information of thousands of its customers. Also, there are possibilities of pending transactions for other work activities such as saving the important customer data, registering the new customer and retrieving the important files regarding to their previous water bills.

The Laguna Water Company is one of the most helpful companies in Laguna province. In terms of billing process, the company’s meter consumption analyst (MCA) goes to the house of all customers to read the water consumption. After five (5) days, the MCA delivers the water bills to the customers by riding through motorcycle. Sometimes, the home owner is out for work or sometimes is out of town. In that case, the MCA puts the notice somewhere in the parts of the house such as the door, window or gate. By then, the home owners don’t have any idea if their water bill for the current month is already given or not. Thus, the payment for their water bill will be delayed until it comes to its due date because the bill is misplaced. In addition, the company has many manual paper works in order to manage the important data of their customers. Some customer wants to follow-up some documents regarding to the water billing, so the employee needs to retrieve those documents manually.

In line with this, the proponents came up with an idea to design and develop a Water Billing System with Short Messaging Service Notification, a more convenient and economical mobile communication technology which is the easiest and fastest way for the consumers to remind them and to inquire their water bills. Sending SMS text messages is very convenient. This is very suitable way for sending the notification to consumer reminders. It can also send the inquiry regarding to water billing consumption in a current month (Muhammad, 2007).

Conceptual Framework

According to Hunter et. al, (2009), the billing operations identify and calculate all the charges for a specific customer account, generate the actual bill and apply payments and credit against that bill. It is therefore needed to analyze and identify on what is the appropriate method to compute all of the customer’s charges the easiest way. The billing system gets whole information about the customer and the services. They get information about how and when the telecommunication provider delivers those services. Within the billing environment, billing systems process large quantities of time and location – specific usage data into customer – specific usage information. They figure out how much to charge for the usage, as well as for other non-usage based...
tracking img