GROUP II
Leader: Mr. John Jeric G. Binuya
Members:
Ms. Jessidin Manuzon

Ms. Marilyn Santiago
Ms. Rachel Sangoyo

Mr. Jay Frie Bactol

Mr. Melvin Ramos

Mr. Victor Delara

Mr. Sammy Sulit

CHAPTER I

INTRODUCTION

WATER DISTRICT is known to be the water supplier of the town. They supplies water in certain location in San Isidro. They have type of category that consumer will follow the residential, commercial and industrial. The residential cost is much lower in commercial. The commercial is lower than the industrial. The higher rate is the industrial.The staff of WASSER DISTRICT none other than Mrs. Isabelita J. Ramos the manager, Mrs. Andrea G. Fiesta the operation’s head, Ms. Arlene Dela Cruz the computer analysis and the rest of the member. WASSER is a German word “water”. The manager said that they have an agreement in municipal of San Isidro that they operate in 15 yrs.

EXISTING SYSTEM

The existing system is the system used by the WASSER DISTRICT in handling its billing system for the consumer. In traditional way they used pens and papers in manual procedure. By computing the bills of the consumers record and file. Unlike the in automated or computerized, only they do is type the information that the computer need. The rest computer will do.

The primary concern of the system is. Design it to become easier in preparing the monthly bills of the consumer of WASSER DISTRICT.The following question are some pattern to construct the system.

1. What are the advantages and disadvantages of the system?

2. What is the significance of the system?

3. Who are the beneficiates?

4. If this system helps our economy?

5. What the system do in making the billings of the consumer?

THE PROPOSED SYSTEM

The proposed system was design and developed using the application of Visual Basic version 6.0 for windows. It records the information about the consumers. Unlike in manual procedure that you need to chat down the information in the papers or bond papers. The system also use for backup files. By using storage medium such as floppy disk, compact disk, flash drive and other kind of storages.

OBJECTIVE OF THE PROPOSED SYSTEM

To know in how it made the bills. Filing and recording the consumer. And know the consumer, how the process of he bills.The objectives followed by the researchers were:1. To have records of the consumers of the company.2. To compute the cost of the consumers.3. To know if the consumers are paid in his/her monthly bill.HYPOTHESISIf the computerized water billing system of the WASSER DISTRICT could be implemented. Here are the speculation as a research will we expect and its advantages.The work of the company will be easy and fast.It will be more accurate and the records will not lost.Lessen the time of work of the staff.

THEORITICICAL/CONCEPTUAL FRAMEWORK

Of all the various use of the computer, that comes in our mind mostly is the bills. This is probably due the fact that our cost of bills in water. In the other side, managing the bills of the consumer is a necessary task since the consumers serve as them in a great way. The designing of the computerized water billing system is for the benefits of the WASSER DISTRICT as well as the consumers.

PARADIGM

Input Process OutputComputerized information of the consumersAccurate bills of the consumersComputation of the consumersAs well as the specify categoryConsumer’s informationConsumer’s costsThe present and previous of the consumers useConsumer’sConsumer’s cost.

SIGNIFICATION OF THE STUDY

The significant of the system is to know how its works. To gain more knowledge to the researchers and the consumers. Make the staff of the WASSER DISTRICT do their work accurate and easy.

SCOPE AND DELIMATION

The system focus on the records of the water billing system. The system do is, their work will speed up the process of computing the bills of the consumers. The study of the system is t helps to convert into automated or computerized to manual procedure.

We expect that the system will need 3 to 4 months to construct.The system is developed in such way that the company will be able to obtain the following.

1. Maintain complete files in computerized form

2. Prepare billing reports in an easiest way.

3. Compute the bills of the consumers.

DEFINITION

Computer - a programmable device that can perform any programming language. Is one of the most imposing forms of information technology.Computerized – is a process in automated or computerized method.

Data – is defined as any collection of facts, figures or numbers.

Storage – the data information and programs are stored in the computer in a form that can be accessed such as floppy disk, CD-ROMs, magnetic tape for future reference.

Flowchart – is a diagram representing the logical sequence in which combination of steps or operations is to be performed.

Database – set of several permanent files integrated into a single file which is available for many different uses.

Computation – set of variables that will compute the total.Security – to secure the subject and to make it safe.

Software – it refers to programs that direct the activities of the computer system.Users – also called knoware or peopleware represents the personnel involved in systems analysis programming, computer operation, system maintenance and many more.

Manual System – all operation from the data gathering to output preparation are perform by man without the aid of any single machine.

CHAPTER II

Ease of use of the software for water or electricity billing

A powerful new billing system

Setup menu

Consumer menu

Readings menu

Billing process menu

Payments

Billing cycle

History



Ease of use EasyBilling software is a software which belong to a new generations of softwares.EasyBilling has been produced with the idea not to produce another complex software for water and electricity billing.The main feature of this software is : Ease of use. This software is designed in order to be as easy to use as possible with very clear screens and a clear way to work.The design of this software for water or electricity billing has been made in order to help the user. Everything is clear and staightforward.Time of training is then reduced and the user can work fastly without the need to understand very complex concepts. In this way, utilities can be efficient in a few days and are able to bill all their consumers.

A powerful new billing systemEasyBilling is a very powerful software for water and electricity billing and it can generate thousands of invoices in a few minutes only. It operates perfectly into a network with several PCs.EasyBilling is also very reliable and it can store thousands of consumers data.From the creation of a new consumer until the issue of an invoice, the user is guided through a range of menus which follow each other in a logical way.EasyBilling gives power to the user.Bills production has never been so easy.EasyBilling software for water or electricity billing has been designed in order to store all data for a billing process.These data are stored through a few screens which are very clear and understandable for any user.All these screens can be run through these menus : Tools / Setup / Consumer / Readings / Billing process / Payments / Billing cycle / History.All these menus are detailed below : Setup menu






In Setup menu, the user can store all data about routes, water or electricity rates, standing charges, subsidies.He can also enter all data about the water district which use the billing software and store some discount and layout parameters.Consumer menuIn this menu, the user can store all data about consumers, billing addresses, meters…He can produce consumer reports ordered by name, by route and by city. He can also produce labels containing consumers addresses, billing addresses in order to paste bills adresses on envelopes. He can also enter opening balance for each account .

Readings menu







The user is able to print routes reports with all meters/readings inside. When meters are read, he can then input all readings for each consumer.

Billing process menu

It is possible to calculate bills before producing them. The user can select one particular consumer and produce his bill. He can produce all bills which are linked to one route or bill all the consumers. He can also issue credit notes.

Payments





The user can issue a report about payments and have the balance for all payments. He can also input payments.- top of page -Billing cycleWhen payments are entered, the user can then run another billing cycle.

History


All bills are stored in a history file. The user can reproduce each bill at anytime and he can have detailed view of each account.

CHAPTER IIIMETHOD, PROCEDURES AND SOURCES OF DATAMETHOD USEDAbstract An automated method and system for consolidating a plurality of individual company charges for a customer with different periodic company billing and payment due dates is provided. Under the system, companies and businesses such as utility companies report their periodic billing information to a central processing office or facility. The processing office holds the billing information data in time suspense until all of the billing information for the customer during a pre-selected time period is received. Then, the central processing facility generates a single customer statement which identifies all individual company charges as well as a statement due date. The statement is sent to the customer and payment for the identified charges is due by the statement due date. After receiving payment from the customer, the centralized billing center processes the payment and then remits payment to all of the consumers.This paper presents a system for billing users. This is achieved by postponing the establishment of connections while the user is contacted, verifying in a secure way that they are prepared to pay. By presenting the user with cost and price information or bills payment, the system can be used for cost recovery and to encourage efficient use of network resources. The system requires no changes to existing protocols or applications and can be used to recover costs between cooperating sites. Our study also indicates that the bills of the consumer schemes may be used to control.DESCRIPTION ONF MANUAL METHODWith water costs and demand increasing worldwide at an incredible pace and availability decreasing at an alarming rate, there has never been a greater need for practical hands-on coverage of water auditing and loss reduction techniques. In this manual, an international expert examines every aspect of water loss and provides simple, effective, tested solutions. This highly visual reference includes coverage of : the nature and scope of water loss occurring in water distribution systems, how to assess loss conditions in any system by using water audit and computer models to identify losses, how to implement interventions to control real losses, mapping tools and techniques, leak detection, repair, and response time, managing pressures and pressure-related problems, pipe rehabilitation and replacement, how to implement interventions to control apparent losses, meter testing, repair, and replacement, billing system analysis and rectification, reduction of unauthorized use, demand control and water conservation, how to perform cost-to-benefit calculation, computer set. This manual a particularly versatile guide, valuable in a wide variety of situations. Charts, graphs, and basic explanations present information in a quick-read, easy-to-digest format and make the book immediately usable to all readers no matter what their level of expertise.DESCRIPTION OF THE PROPOSED SYSTEMThe system made in automated or computerized. So that, the user will make his/her work easier and fast. It also lessen time will consumed more transaction he/she can make. Unlike in manual system, Much time will consumed. He/she take more time and need more computation will do.CHATER IVPRESENTATION, ANALYSIS, AND INTERPRETATIONTHE SYSTEM DEVELOPMENT STEPSThe systems development is a conceptual model used in ` that describes the stages involved in an information system development project, from an initial feasibility study through maintenance of the completed application. Various SDLC methodologies have been developed to guide the processes involved, including which was the original rapid application development (RAD); joint application development (JAD); the fountain model; the build and fix; Frequently, several models are combined into some sort of hybrid methodology. Documentation is crucial regardless of the type of model chosen or devised for any application, and is usually done in parallel with the development process. Some methods work better for specific types of projects, but in the final analysis, the most important factor for the success of a project may be how closely the particular plan was followed.In general, an System Development o methodology follows the following steps:1. The existing system is evaluated. Deficiencies are identified. This can be done by interviewing users of the system and consulting with support personnel.2. The new system requirements are defined. In particular, the deficiencies in the existing system must be addressed with specific proposals for improvement.3. The proposed system is designed. Plans are laid out concerning the physical construction, hardware, operating systems, programming, communications, and security issues.4. The new system is developed. The new components and programs must be obtained and installed. Users of the system must be trained in its use, and all aspects of performance must be tested. If necessary, adjustments must be made at this stage.5. The system is put into use. This can be done in various ways. The new system can phased in, according to application or location, and the old system gradually replaced. In some cases, it may be more cost-effective to shut down the old system and implement the new system all at once.6. Once the new system is up and running for a while, it should be exhaustively evaluated. Maintenance must be kept up rigorously at all times. Users of the system should be kept up-to-date concerning the latest modifications and procedures.STATISTICAL ANALYSISDevelopments in the field of statistical data analysis often parallel or follow advancements in other fields to which statistical methods are fruitfully applied. Because practitioners of the statistical analysis often address particular applied decision problems, methods developments is consequently motivated by the search to a better decision making under uncertainties.Decision making process under uncertainty is largely based on application of statistical data analysis for probabilistic risk assessment of your decision. Managers need to understand variation for two key reasons. First, so that they can lead others to apply statistical thinking in day to day activities and secondly, to apply the concept for the purpose of continuous improvement. This course will provide you with hands-on experience to promote the use of statistical thinking and techniques to apply them to make educated decisions whenever there is variation in business data. Therefore, it is a course in statistical thinking via a data-oriented approach.GRAPHICAL ANALYSIS AND PRESENTATIONAn automated method for generating Graphical User Interfaces (GUI's) is illustrated in the context of a system for processing financial applications. In one embodiment, the GUI generator converts domain data representing over one thousand application types into an equal number of corresponding user screens. The interface may also be bi-directional, operating on user inputs to validate data or check for double keyingTable show the guide question used by the researchers in developmenta new for WASSER District.QuestionsYesPercentNoPercentTotal1. Does the company report were complete and true?2. Does the consumer satisfy in the computation of there bills3. Does the consumer computation more accurate?4. Are you satisfied with the company existing system?5. Do you think that the WASSER District needed new system, so that it become more accurate than the old system?30343830%30%40%30%80%7767270%70%60%70%20%1010101010Total21210%29290%CHAPTER VSYSTEM DEVELOPMENTREQUIREMENT ANALYSIS AND DEFINITIONIn hardware and software system, requirements analysis encompasses those tasks that go into determining the needs or conditions to meet for a new or altered product, taking account of the possibly conflicting requirements of the various system. Requirements analysis is critical to the success of a development project.Requirements must be actionable, measurable, testable, related to identify the system needs or opportunities, and defined to a level of detail sufficient for system design. Requirements analysis involves frequent communication with system users to determine specific feature expectations, resolution of conflict or ambiguity in requirements as demanded by the various users or groups of users, avoidance of feature creep and documentation of all aspects of the project development process from start to finish. Energy should be directed towards ensuring that the final system conforms to consumer needs rather than attempting to mold user expectations to fit the requirementsDESIGN TOOLSWASSER District need an effective and accurate billing system to be able to assure their revenue. Billing systems process the usage of computer that is used during the service usage into a single record. The billing process involves receiving billing records from various system, determining the billing rates associated with the billing records, calculating the cost for each billing record, aggregating these records periodically to generate invoices, sending invoices to the customer, and collecting payments received from the customer.Billing system is very complex starting from computer elements that generate usage to the billing system to usage collection, mediation, rating, and invoicing. To simplify the process I will introduce a simple system usage scenario. The system user navigates through the company and views company services, and he decides to order one of the available services. If he has no account, he signs up for a new account, else he signs in. Then the user asks to conduct an order with the selected service. The service may be prepaid where he has to pay to have credits to use the service. Where he has to pay if the service has installation or setup fees, and later on he will pay for his usage of each billing cycle.VISUAL TABLE CONTENTSOur visual table of content is we divided into program level and module level. You can see in the flow of the system is very much like the other system.PROGRAM DESIGNThis is a short presentation of a method for program design. The word design must be understood in a wider sense than user interface design. The design process as defined by Websters Dictionary [3] covers a wide approach and seems appropriate:The approach that engineering (and some other) disciplines use to specify how to create or do something. A successful design must satisfies a (perhaps informal) functional specification (do what it was designed to do); conforms to the limitations of the target medium (it is possible to implement); meets implicit or explicit requirements on performance and resource usage (it is efficient enough). A design may also have to satisfy restrictions on the design process itself, such as its length or cost, or the tools available for doing the design.The method covers the process from idea to program. The focus is on "tools for thinking" in the process rather than rules for designing the user interface or the technical design of the program. The tools have a form that gives priority to simplicity and communication, rather than precision and formality. That means that participation, from different kinds of knowledge, experience and expertise, is given high priority.The method has been developed and used mainly as a tool for designing computer programs for educational purposes. The method has a wider applicability. The techniques are fairly general and easily adaptable to programs of other categories. Design of computer programs in general is in my experience to a large extent a pedagogical endeavour.SYSTEM REQUIREMENTComputer SetMedium StorageApplication of Visual BasicPROGRAM SPECIFICATIONThe following are the components of the proposed water billing system for WASSER District.1. Back-up Files – allows the user to save on any medium storage and the better protection of the files.2. Functions – the proposed system is design to include the main functions of the Water Billing System.ADD – allows the user to add information of the consumer and records tothe file.EDIT – allow the user to change or edit the existing records.VIEW – allow the user to view an existing record of the consumer.DELETE – allow the user to delete an existing record but it notrecommended to delete an existing record.EXIT - allow the user to exit or escape the systemSAVE – allow to store, to save the record of the consumer.3. Short-cut Key – the system have short-cut keys so that the user is more faster.Alt + A - Adding of recordsAlt + E – Editing of recordsAlt + V – Finding or viewing recordsAlt + D – Delete or executing recordsAlt + X – Escape or exiting systemAlt + S – Saving or storing records4. Security – a password will need to enter to use the system. This passwordwas the security of the non-user of the system.5. Icons – we use icons in the system to become more representative,delightful, and impressive. It also useful for easily knowing the command that the user will use.SYSTEM TESTINGSystem testing of software is testing conducted on a complete,integrated system to evaluate the system's compliance with itsspecified requirements. System testing falls within the scope ofblack box testing, and as such, should require no knowledge of theinner design of the code or logic. [1]As a rule, system testing takes,as its input, all of the "integrated" software components that havesuccessfully passed integration testing and also the softwaresystem itself integrated with any applicable hardware system(s).System testing are going to performed is to make sure that thesystem runs 100%. So that, there’s no error or problem will encounter.SYSTEM IMPLEMENTATIONAfter the system test, we proceed to implement the system. After all the study is just a proposal to give convenience to the system and to relieve problems of the system.SYSTEM DELIVERYThe system delivery is give instruction of the programmer to use the system in any function of the billing system.MAINTENANCETo maintain the system, we need to check the system capability and if the system runs 100%. To check error and correct it.FEASEBILITY STUDYThis section will determine the operational feasibility of the study.Operational Feasibility. The system can be implemented in company, given great offers a advantage ever the existing billing system from the basic of the system test.Technical Feasibility. The proposed water billing on a computer generates accurate, effective, efficient and friendly user.