Loading...
01-0206_ADVANCED UTILLITY SYSTEMS_C2_Agenda Report AGENDA ITEM February 6, 2001 TO: George Scarborough, General Manager FROM: Cynthia L. Russell, Administrative Services Director SUBJECT: Consideration of Award of Contractfor Utility Billing System(Advanced Utility Systems) RECOMMENDATION: By Motion: a. Award contract to Advanced Utility Systems for the purchase and installation of a new utility billing system, and; b. Authorize a budget adjustment of$38,400 from Water Enterprise Operation Fund reserves to Acct# 50-65401-4143. c. Authorize the General Manager to execute the contract upon final approval of the City Attorney. SITUATION: A. Summary and Recommendation Over the past few years, the customer service staff has been fighting to keep the District's old DOS-based utility billing system alive. The FY 2000/01 budget approvals included the replacement of this system with a new Windows-based system to provide for adequate dependability as well as bring our practices up-to-date. Staff has completed a Request for Proposal (RFP) process and Advanced Utility Systems has emerged as the successful bidder at a not-to-exceed amount of$110,400. The budget for this project is $72,000 and would require a budget adjustment of $38,400 from Water Enterprise Operating fund reserves to support the staff recommendation. Staff recommends the Board of Directors approve the contract with Advanced Utility Systems, authorize a budget adjustment for $38,400, and authorize the General Manager to execute the contract upon approval of the City Attorney. B. Background The customer service division of the City's Administrative Services department provides customer service and billing for all City residents and businesses for water and sewer on behalf of the Capistrano Valley Water District. The District's service area includes FOR CITY COUNCIL AGEN . � V w D C 2. AGENDA ITEM -2- February 6, 2001 approximately 1,000 residences in the City of Dana Point.The current computer system is 7 years old and has many limitations. It's software has been extensively modified over the years to accommodate numerous changes in services, rates, policies and procedures. The firm that the current software was purchased from has not supported this version of their software for over two years. Since that time staff and our computer consultant have kept this fragile, vulnerable system afloat. Since the system is outdated and unsupported by the software firm and the database software manufacturer, additions or modifications would not be sufficient. It has run it's useful life in providing the analytical and reporting tools that are needed to manage these services in a contemporary customer service environment. The utility billing system is at the heart of the CVWD business success and is a critical tool that drives City revenue, customer relations and resource management. In addition to billing and other business functions, the utility billing system provides all water service personnel with the service history and other information necessary to maintain the high level of customer service we now provide. A new, modern system is urgently needed. As a result, a Request for Proposal for a utility billing system was developed by Staff and distributed. A copy of the RFP is available attached (Exhibit 1) for review. The required system features included: Customer and account history (customer service), automated payment processing, billing, adjustments, service order processing, credit and collections, accounting components, meter reading and management information capabilities. Enhancements over the current billing software will include: A modern database with expected staying power in the market. Windows-based printing vs. DOS fixed location printing, more efficient billing processes, more automated"collections"management, billing for large accounts with compound meters, built in calendaring, improvements to the processing of payments, expansion of scope of service orders, improved customer information, improved history and third party billing. VENDOR SCREENING AND EVALUATION Staff developed a list of 15 potential firms by an Internet search and firms that have contacted the City. The target firms were those with billing systems with the features we need for our current applications and provide the required enhancements to our practices, such as bar coding bills and scanning the return stubs. We limited the list to those firms that complement the City hardware and operating system environment. The City's RFP clearly indicated a very strong preference for Windows NT and a programming language that will last for many years. Five firms responded to the RFP. AGENDA ITEM -3- February 6, 2001 A committee made up of Jim Widner, Admin. Serv. Manager, Stacie Ando, Customer Serv. Rep, and John Stewart, computer consultant evaluated the written proposals and rated the responses. The following is a recap of the proposed amounts for purchase, training & conversion and the 15` year of Maintenance/upgrades and their initial ranking taking into account a review of the proposals for features and costs (inc. first year maint): • DR Frey & Co. — Costs $55,488 — Rank 1 • I-Nhance Utility Info — Cost $114,450 — Rank 2 • Aquilium Software Corp. — Cost $162,400 — Rank 3 • Advanced Utility Systems — Costs $133,400 — Rank 4 • Mission Management— Cost $47,000 — Rank 5 ' - This proposal had the lowest cost, however it was considered non-conforming to basic requirements of bid in the database & operating system requirements. All proposals are available for review in the Administrative Services Department . A copy of the proposal from Advanced Utility Systems is included with this report (See Exhibit 2 ) VENDOR SELECTION: Staff viewed a demonstration of system operation of all four responsive proposers. The demos were either on-site or at an existing user's site, and were attended by customer services staff and the Director of Administrative Services. All firms were evaluated against a wide variety of specific criteria outlined in the City's RFP. After the demos a clear favorite emerged from all the evaluation team. The major areas of review were as follows: ability to meet the City's utility billing business needs; demonstrated ability in the past two years to successfully implement a utility billing system for water & sewer in a similar size agency; justification of all costs; training and conversion plans; and references. Here is a recap of the primary features both pro & con that weighed in the selection. • Advanced Utility Systems—Good, easy to use screens. Modern database used. Many features, only they had i.e past due follow up day intervals, could accommodate our rate structure without custom programming. They had a well thought out conversion plan that was communicated well in their proposal, to guard against disaster. • Aquilium Software Corp. — Awkward screens, much more expensive, custom programming required at additional cost. Turn-on process is too complicated. • I-Nhance Utility Info — Awkward screens, custom programming required at additional cost. Turn-on process is too complicated. • DR Frey&Co.—Proposal was unresponsive to list of references and a bid bond AGENDA ITEM -4- February 6, 2001 was refused. Features were generally good, except the turn-on/turn-off process was much too cumbersome and required too much operator involvement. Advanced was the only firm able to accommodate the District's water rates without special programming. This saves costs but, more importantly it keeps the District on the same version of the software as all other users. This is an important feature. To assure staff of the functionality of the Advance software the system was tested with actual District data using the specific rate calculations currently in use, including the tiers & allocations based on weather. These tests have been successful. Afterthe initial selection of Advanced as the leading vendor, discussions were held with them about their proposed time and resulting costs of training, conversion and implementation. That resulted in a reduction of their"upper" cost by several thousand dollars to $110,400. These are upper limit not to exceed costs and should various elements go faster than planned we would only be billed for the actual costs. The contract will provide their final pricing and the scope of their duties. Advanced is located in Toronto, Canada; has 35 current installations and about 35 employees. They have recently been selected in 4 other California agencies some of them larger than CVWD and some smaller. They have been in business since 1997. IMPLEMENTATION PLAN Since it is important that City utility customers and the City's revenue stream not be negatively impacted by the conversion to a new system, staff has worked with Advanced to develop a realistic implementation plan, which will assure a successful project. It is anticipated that the project will take 3-4 months to accomplish, complicated by the need to keep day-to-day operations running. The conversion may well involve additional cost-effective changes to make use of the superior method of data entry systems for remittance processing using optical character recognition (OCR) technology. COMMISSION/BOARD REVIEW AND RECOMMENDATIONS: The Water Advisory Commission (WAC) consideration the award of contract to Advanced Utility Systems and the budget adjustment at their meeting on January 24, 2001. The WAC recommended approval of the contract and budget adjustment. FINANCIAL CONSIDERATIONS: Advanced has revised their proposal after discussion with staff about the scope of the conversion and the assistance and sophistication they will be dealing with. The new upper limit to total cost for the software, training, conversion and setup is $110,400. AGENDA ITEM -5- February 6, 2001 After the first 3 months the annual support costs of $10,000 per year would also kick in. Staff anticipates these "upper limit" costs will come in under the proposal because, District staff is very knowledgeable in billing issues and computer conversion and implementation issues. The RFP called for a performance bond. Staff is recommending the elimination of this requirement because due to cost. Staff can build in protection for non-performance in the payment schedule of the contract with Advanced. The City Attorney's office is currently finalizing the contract provisions for this acquisition. The budget for this project is $72,000 including software acquisition, training and implementation. While we were optimistic in our estimate it was only an estimate heavily influenced by our past costs in 1994. Funds are available in the Water Enterprise Operating Fund reserves to support the upper limit increased cost of $38,400. Again, staff anticipates actual costs will come in even lower. NOTIFICATION: Advanced Utility Systems DR Frey & Co. I-Nhance Utility Info Aquilium Software Corp. MMI Software ALTERNATE ACTIONS: 1. By Motion: a. Award of contract to Advanced Utility Systems for the purchase and installation of a new utility billing system, and; b. Authorize a budget adjustment of$38,400 from Water Enterprise Operation Fund reserves to Acct# 50-65401-4143, and; c. Authorize the General Manager to execute the contract upon final approval of the City Attorney. 2. Do not recommend award of contract for replacement of the District's Utility Billing System 3. Request additional information from staff. AGENDA ITEM -6- February 6, 2001 RECOMMENDATION: By Motion: a. Award of contract to Advanced Utility Systems for the purchase and installation of a new utility billing system, and; b. Authorize a budget adjustment of$38,400 from Water Enterprise Operation Fund reserves to Acct# 50-65401-4143, and; c. Authorize the General Manager to execute the contract upon final approval of the City Attorney. Respectfully Submitted, �h&- � Cy6khia L. Russell Administrative Services Director Exhibit 1 - Request for Proposal Exhibit 2 - Advanced Utility Systems Proposal [JYwn EXHIBIT 1 GJ� , (A� lA1 32400 PASEO AOELANTO ,y� LJ i.j MEMBERS OF THE CITY COUNCIL SAN JUAN CAPISTRANO,CA 92675 ,yy lo[aa,Man6 DIANE L.BATHGATE Dtaulsa[a 1861 COLLENE CAMPBELL (949)493-1 171 176 _ JOHN GREINER (949)493-1053 (FAX) MATT HART 0 DAVID M.SWERDLIN CITY MANAGER GEORGE SCARBOROUGH August 21, 2000 The City of San Juan Capistrano, CA on behalf of the Capistrano Valley Water District Request for Proposals Utility Billing System INTRODUCTION The City desires to acquire a comprehensive Utility Billing system to replace an unstable, highly patched, unsupported DOS based system. Vendors are invited to submit proposal information and cost quotations to the City of San Juan Capistrano (City), California, for the provision of software, hardware, training, implementation, and software support services. The vendors were selected from a list of firms that have previously contacted the City, known vendors, responses to notices and an internet search. This RFP is being sent by e-mail, if available. The City reserves the right to reject all bids and issue another Request for Proposals. This RFP does not commit the City to reimburse vendors for proposal submission costs. Price is an important consideration in this process, but not the only consideration. Other factors will include track record of successes at other municipalities or utilities, meeting the City's requirements, and experience and qualifications of the firm and key personnel. The responses to the RFP will be evaluated by two City employees involved in the utility billing and an outside computer consultant. CITY BACKGROUND INFORMATION The City and the adjacent water service area has a population of approximately 32,000. The Capistrano Valley Water District (CVWD) is operated by the City under agreement. CVWD currently has 10,800 water service connections, with build out expected at 13,000 water services. CVWD bills monthly for water and sewer. The City is in Orange County, Ca, mid-way between Los Angeles and San Diego, CA Specific information about the City may be found on their Web Site at www.sanivancapistrano.org. 011U6 USE li San Juan Capistrano: Preserving the Past to Enhance the Future r PROPOSAL SUBMISSION Responses to this RFP should be mailed or e-mailed clearly marked: CAPISTRANO VALLEY WATER DISTRICT/ CITY OF SJC " UTILITY BILLING SYSTEM, RFP" They are due on or before 5:00 pm pacific (dst) on September 12, 2000 to: Mr. Jim Widner, Administrative Services Manager City of San Juan Capistrano 32450 Paseo Adelanto San Juan Capistrano, CA 92675 Or to: e-mail: iwidner(a)sanivancapistrano.org Proposal submission will not be accepted by facsimile. All specific questions regarding the RFP should be directed in writing to Jim Widner via mail, by e-mail to: Iwidner0sanivancapistrano.orq or fax at 949-493-3955 on or before 2:00 pm on September 6th. Written responses to the questions will be posted on the City's web site at http://www.sanivancar)istrano.orci by September 8th. A link will be placed on the homepage that directs the browser to a file containing the questions and City responses. A hard copy version of the questions and responses will be made available at City Hall offices. General questions maybe directed to Jim Widner at 949- 487-4303. EVALUATION PROCESS AND SCHEDULE The selection process will be in two steps. In order to streamline the RFP responses a standard list of questions must be answered. Step one requires each vendor to respond to the City's list of questions. Answers to these questions will be evaluated and weighted to determine which three vendors best meet our needs. The second step will entail a more through evaluation of the features of the vendor's software and will include demonstrations of the software and assurances that the software will accommodate all the City's needs, including our rate structure. Other items may be considered and weighed in the final selection after demonstrations are completed. It is the City's desire to conduct software demonstrations with the vendors at the City's offices or if impractical at the Vendors office between September 26, 2000 and October 13, 2000. Three finalists will be selected for demonstrations. The City is targeting completion of the evaluation by mid October, 2000. System installation and implementation should begin early in November 2000 with a target completion of December 1 , 2000. Proposal Instructions: Please answer all the questions listed below. Please feel free to include pre-printed product literature regarding your system(s). Please indicate where in your pre-printed information any expansion of your answer to one of these questions may be found. Please provide one price quote for your Utility Billing system and a separate quotes for the training and conversion and implementation costs. Please indicate the length of time over which your price quote applies. If enhancements are required to accommodate a specific task identified on Exhibit A, please identify the cost of such enhancement. Please identify when the application was first put into production, how many sites are using the application, and how many installations are in progress. This information will be held confidential within the scope of the Public Records laws of California. The following questions related to how your system meets our needs must be answered in the same order as presented. 1. Attached is a list of System Requirements (Exhibit A) that the City considers minimum requirements. —Does your software meet ALL these needs? If not, what items are not features of your standard software? 2. What database is used as the foundation of your system? 3. What networking protocol does your system operate on? Does system run on an Windows workstations or Novell? 4. Is your system a client/server application? 5. Is your system a Windows environment? 6. Remote Access - Does the system provide access by remote locations and/or by your support staff? 7. Schedule—Can you provide the resources required to install the system in a timely manner and according to the City's tentative schedule? 8. Ad Hoc Reporting— Does the system provide reporting tools for generating custom reports from system information? 9. Do you currently sponsor regular (i.e., quarterly) user group meetings? Where does the nearest (to the City) user group meet? 10.Do you provide system and user documentation manuals for each subsystem? 11.Training and Support— Do you provide detailed on-site training, documentation, and support? Is ongoing training and support available? Please state hours of live support availability. 12.Please specify how many staff-days of training you anticipate providing as part of your proposal. 13.If you are chosen as a finalist, are you willing to provide a live demo using the City's rate structure and budget based allocations as the sample? 14. Please provide a list of ALL municipalities or public utilities which use your system, along with names and phone numbers of responsible individuals who can be contacted. If there are some who can not be contacted tell us why. 15.As part of your proposal, please provide staff hourly rates for additional work or enhancements needed, should your firm be selected. 3 16.Can your firm meet the timelines outlined above, leading to the system being fully operational by December 1, 2000? 17.Please provide a profile of your firm, which indicates number of staff, years established, and key staff and how long they have been with your firm, how long the software has been in use and the location of your offices. 18.Security— Does your system have password access, file recovery, record locking, and automatic backup procedures? 19.What is the Price for your Utility Billing Software that fully meets our needs. Break down the price in Standard software costs and any supplemental programming required to meet the City's specific needs. 20.What is the estimated costs of conversion. Final costs may be updated (adjusted) by up to 50% after a demo, but, before a firm is selected. 21 . What are the estimated training costs? What are the actual training costs per day per pupil? Where would the training be conducted? 22.What are the annual maintenance, support costs? 23.What is your policy with regard to future enhancements and/or upgrades to your software? In other words, do we have to keep repurchasing your system? 24.Will you put the Source Code in Escrow? 25.A Performance Bond will be required of the successful bidder. What is the cost of this item? Attachments to this RFP: Exhibit A—Minimum requirements of Utility Billing System. (4 pages) Exhibit B—Sample Monthly Sales Report. (1 page) Exhibit C—Sample Water Bill. (1 page) Exhibit D— Rate Summary. (1 page) End- p:\admin\jim\billing\rfp2 Exhibit A — of RFP Capistrano Valley Water District/City of SJC Utility Billing Software Requirements August 14, 2000 Here are the minimum features that are required of a replacement Utility Billing System. System - Must be designed around these general operational conditions: 1. Designed to service 13,000 accounts for various utility billing services. 2. Windows operating system. 3. 10-12 total users with 5-6 simultaneous, constant users. 4. Record locking not table locking features. 5. Backup and Restore features built into software. 6. Offsite access to system for trouble shooting mandatory i.e. PCAnywhere 7. Designed or flexible enough to accommodate our rate structure. Features include water budgeting allocation system tied to each customers lot size, house size, the weather and the number of days in the billing period. 8. Database core so information can be utilized with the features of your system or Report Writers. Prefer a commonly used DB, with wide use, staying power and support. 9. Current billing system — DOS based, Paradox 4.5 Database, Programs in Object PAL, runs on Windows 98 peer/peer network, 8-10 users (5-6 usually active simultaneously), 10,800 accounts, Table structure available, conversion of current database info to ASCII or DBase files is a feature available. All files including programs, tables, back-up tables and use history information occupy 3 gigabits of space. Consultant/Vendor Services is expected to: 1 . Assist with Installation and testing 2. Provide conversion assistance 3. Provide training 4. What is the location of the nearest support 5. Have the capability of testing with a sample cycle on real CVWD data. 6. Provide On-line help and through, useful System and User documentation. Features required of the software: 1 . Backflow system administration and notices and follow-up. ( Database tied to Customer Database, Maintenance History, notices, follow-up, standard reports, and a report writer for ad-hoc reports) 2. Billing software database must be linkable to our GIS system, which uses ArchView and Automap2000. 3. Water, sewer, garbage and other services to be used and functional. 4. Past due follow-up including Past Due Notices with the assessment of late charges, Door hangers and Shut off notices. Late charges must be assessable on each type charge independently ie. Water, sewer, other charges. 5. Standard Reports built into system and Report Writer capability to query Database. 6. Work order system for turn-on, shut-offs, maintenance, high-bills, etc. tied to account numbers and/or billing addresses. Would like work order system to 1 function for general work orders also, those not tied to customer accounting information i.e. broken mains, pump maintenance, leak in streets, etc. 7. Desire to maintain our current Account Numbers. If not possible what is structure and how would old vs. new be indexed and accessed during conversion period. Current account number structure is 7 digits long made up as follows: BBAAASS, (book, account, sequence.) A separate field containing the Cycle where each account is assigned. 8. Password protected by functions and user. i.e. Some can look; others can only access certain features. 9. Processing of Closing Bills with flexible routine for how often send, lower limits and follow up process for collection. 10.Ability to bill by Cycles progressively during the Month. 11.Feature Rich Database management and Report Writer capability. Customer Information requirements: 1 . Look up by Name, address, account no, or meter no. 2. Notes specific to each account regarding arrangements or conversations. 3. Bill history maintained on-line for 3 years. 4. Meter use history maintained on-line for 3 years 5. Credit/ payment history for 12 months i.e. current, delinquent, shut-off. 6. Move in dates and other changes in status dates. 7. Notes regarding arrangements to pay with follow up dates to trigger. 8. Database must accommodate Phone numbers, lot size, house size, sub-division, parcel #, map xy locations and other static information about each account. 9. Rental property—Automatic turn-on in owners name when tenant turns-off. (if available as standard feature?) 10.Linking of turn-on and turn-off work orders by wanted date. 11.View Notes regarding an account online, when viewing standard AR info. 12.Last Bill Detail on line to include Tiered Bills as issued and Allocation History. (i.e. See what the customer is seeing.) Payment processing: 1. Automated payment entry. 2. Electronic payments (WEZY to us). —ACH processing capability. 3. Bar code reading capability to process payments 4. Batch file processing if a Lock Box is utilized. 5. Auto posting, real time, for Cash Register payments. 6. Multiple Users entering payments simultaneously. Security Deposits: 1 . Automated processing upon payment 2. Apply to closing bills 3. Apply interest to deposits on hand. 4. Capability to apply to open accounts, if standard feature. Accounting: 1. Generate Journal Entries for use in GL system. Entries to be passed to Accounting System for each module of billing system, i.e. payments, billing, late charges, deposits. Prefer some automation of entry, but print out is acceptable choice. 2. Process adjustments. 2 (0 3. Write-off process. 4. Collection follow-up routines. 5. Comprehensive month end report on use and sales by customer type, billed amounts and average rates charged. (See sample of current report— Exhibit B) Meter Maintenance and reading: 1. Meter repair history 2. Meter locations, # of dials, size, mfr. 3. Compound meter billing capabilities, not mandatory but, preferable. 4. Billing system handle "swaps" of meters and combines use of old and new meters. Meter Reading: 1. Interface with hand held reading devices, if needed. Not a current need. 2. Interface with outside company performing our meter reading, using batch files transmitted by modem or e-mail. CVWD contracts with another local utility to read most of our meters. 3. Built in reports and edit routines to process meter readings, tailored to our needs i.e. different high/low ranges for accounts by use patterns and alerts for problems. 4. Re-read listings produced by edit routines that show meter locations. 5. Ability to force an Estimated reading. Bills: 1 . Bill by cycle during the month. 2. Standard stuff on bill ( reads, days covered, current due, past due, follow up dates) plus bar code address for Post Office, Bar Code stub for cash remittance processing, warnings for past dues. See sample of Bill — Exhibit C 3. Ability to add a note ( 3-4 lines long) to all customer, some customers based on selection criteria, specific note to a customer. 4. Ability to create duplicate bills after initial bill has gone out. (updated for recent activity, such as adjustments or payments) 5. Ability to reprint bills if printer problems encountered. 6. Use history of last 13 months use and allocations. List acceptable but, prefer chart capability. See sample of bill. 7. Sort bills by multiples to one addressee together, then by zip, carrier route, etc. 8. Ability to send extra bill to different address or a 3rd party. 9. Bills to show account activity for the past month. (Payments, adjustments, late fees, etc.) 10.Process past due notices and related tags based on our past due rules. (Ability to pull out some tags if not to be delivered, if standard feature.) 11 .Ability to set user defined parameters for delinquent follow up and assessment of late fees. 12.Pro-rate charges for short-term bills. Must Accommodate CVWD rates: (Rate Schedule Summary Attached—Exhibit D) 1 . Tiered rates ( 3 tiers now) for commodity charges 2. Water Budget Allocation based on lot size, house size, & weather. 3. Service charges by service size. 4. Sewer charges—flat monthly rates by class of customer. 5. Sewer charges—tied to water use for commercial customers. 6. Handle various discounts. End- p:\admin\jim\billing\rfpbill 3 CAPISTRANO VALLEY WATER DISTRICT MONTHLY ANALYSIS OF SALES Jun-GO RUN: 15-Aug-00 a #OF SERV. #OF USE AVG COMMODITY SERVICE WATER AVG PER AVG S SEWER TOTAL CUSTOMER USE CLASS e BILLED UNITS ccf USE CHARGES CHARGES REVENUE ccf WATER CHARGES SALES PER UNIT: PER UNIT: RESID.-REGULAR LOTS A 2,951 2,951 49,559 16.8 $64,629 $18,260 $82,888 $1.304 $28.09 $34,612 $117,501 RESID.-LARGE LOTS B 3,572 3,578 134,274 37.5 173,330 23,828 197,158 $1.291 $55.10 44,527 241,685 MASTER METERED RESID C 17 1,408 9,594 6.8 11,996 1,096 13,092 $1.250 $9.30 13,646 26,738 RESID.-MULTI with IRRIG D 1,538 1,698 17,342 10.2 21,773 9,608 31,381 $1.255 $18.48 20,727 52,108 RESID.-MULTI w/o IRR-Reg E 1,213 1,230 7,407 6.0 9,695 7,408 17,103 $1.309 $13.91 14,883 31,986 RESID.-MULTI w/o IRR-High N 274 1215 18.365 15.1 24.899 2.553 27.452 $1.356 $22.59 14.954 42.406 Sub Total-RESIDENTIAL 9,565 12,080 236,541 1 19.6 $306,322 $62,753 $369,074 $1.295 $30.55 $143,349 $512,423 PER SERVICE: PER SERVICE: LANDSCAPING F 427 56,753 132.9 $72,395 $5,520 $77,915 $1.276 $182.47 $0 $77,915 AGRICULTURE G 21 8,290 394.8 8,846 308 9,154 $1.067 $435.89 62 9,215 COMMERCIAL H 423 37,885 89.6 46,977 4,816 51,793 $1.240 $122.44 28,760 80,553 CONSTRUCTION 1 43 2,087 48.5 3,277 1,287 4,564 $1.570 $106.15 - 4,564 NON POTABLE J 63 40,895 649.1 34,641 1,014 35,654 $0.847 $565.94 - 35,654 NO CHARGE K 2 0 - - 52 52 #DIV/0! $25.86 31 83 FIRE SERVICE L 116 0 - - 3,568 3,568 n/a $30.76 - 3,568 CITY FARM WELL M 2 2,695 1,347.5 1,477 - 1,477 $0.548 $738.56 - 1,477 ADJUSTMENTS0 1,547 2,003 19 1,984 160 1,824 Totals 10,662 12,080 386,693 1 1 $475,939 %79,297 $555,236 $1.231 $172,041 $727,277 BUDGET ESTIMATES 6 354,609 $448,272 $78,032 $526,304 S 168,416 ACTUAL TO BUDGET 109.0% 106.2% 101.6% 105.5% 102.2% Weighted Average of weather based Outdoor Allocations ------- USE BY TIER(ccf) ---------- ----- PERCENT OF USE ---------- Regular Lots-ccf 13.7 CUSTOMER USE CLASS TIER I TIER 11 TIER III TOTAL TIER I TIER 11 TIER BI jLarge Lots&Landscaping ccf/M sq ft 3.69 RESID.-REGULAR LOTS A 42,724 5,960 875 49,559 86.2% 12.0% 1.8%From ALLOC Table: %of billings #of billings RESID.-LARGE LOTS B 119,713 12,611 1,941 134,265 89.2% 9.4% 1.4%All use in Tier 1 80.1% 8,543 MASTER METERED RESID C 9,294 300 0 9,594 96.9% 3.1% 0.0%Some use in Tier 11 18.00% 1,923 RESID.-MULTI with IRRIG D 16,700 588 54 17,342 96.3% 3.4% 0.3%Some use in Tier 111 1.9% 206 RESID.-MULTI w/o IRR-Reg E 6,475 739 193 7,407 87.4% 10.0% 2.6% 10,672 RESID.-MULTI w/o IRR-High N 13,320 4,605 440 18,365 72.5% 25.1% 2.4%Some use in Penalty Tiers 19.9% t�!� LANDSCAPING F 52,679 3,517 624 56,820 92.7% 6.2% 1.1%Weighted Average#of billing days in Mo. 30.6 X\ AGRICULTURE G 6,553 1,737 0 8,290 79.0% 21.0% 0.0%Normalized Sales-ccf(30.4 day Mo.) 384,534 _ COMMERCIAL 11 37,885 0 0 37,885 100.0% 0.0% 0.0%Percentage of Est.sales - 108.4% CONSTRUCTION 1 2,087 0 0 2,087 100.0% 0.0% 0.00/a#of Delinquent Notices 397 3.8% NON POTABLE 1 36,760 3,183 952 40,895 89.9% 7.8% 2.3%#of Red Tags 194 1.8% NO CHARGE K 0 0 0 0 #DIV/01 #DIV/0! #DIV/O! #of Delinquent Shut-offs 46 0.4% �+V FIRE SERVICE L 0 0 0 0 - - - Late Charges&Ad.LC S 1,323 (3,227) CITY FARM WELL M 2,695 0 0 2,695 100.0% 0.0% 0.0% Month end Active customers 10,582 ADJUSTMENTS - 464 464 619 1,547 30.0% 30.0% 40.0% Month end Inactive customers 219 -TOTALS- 347,349 33,704 5,698 386,751 89.8% 8.7% 1.5%Total Customers(Serv.Connections) 10,801 Penalty Revenue S 10,718 S 7,397 (1 CIP Incremental Rev.Comm.Chgs: $ 3,447 S 620 $ 155 1 $ 4,222 ICIP Serv.Chgs: I S 1,156 1, ."` " • C7,01 ' v 1on City of San Juan Capistrano NNP THIS PORTION FOR wOR WORDS Water Services Department 33400 Pose* Adsianto STATEMENT San Juan Capistrano, CA 92675 ' 949/493-1515 Account No: 4509701 Allocation Info: SILLINGDATE: 8/14/00 SERVICE PERIOD 7/12/00 TO 8/10/00 This Month's Allocation(ccf): SERVICE.ADDRESS: g� METER INFORMATION # Current Reodi Previous ReadingUsage in CCF I car=748 Gallons #of Das Usage in Gollons Next MontF's EsL Allocation(cd): METER 783 736 47 29 35156 Lot Size(sq—k8 }$! hHouse Size sq groundoooar): 1,471 ast Billing 7/18/2000 216 . 10 ayment 8/10/2000 -128 . 53 Use History ate Charge 7/27/2000 4. 07 Billed Allocation Use-ccf Aug 00 36 47 Jul 00 40 50 Previous Charges: 91. 64 Jun 00 36 36 Pay by 8/22/2000 to avoid a late charge. May 00 34 30 PAY BY 9/05/2000 TO AVOID A SEDT OFF. Apr 00 29 27 Tier 1 Usage: 36 @ $1.25 45 .00 Mar 00 16 13 Tier 2 Usage: 11 @ $1.59 17 .49 Feb 00 16 22 4 Jan 00 19 35 Water Service Charg4pa, � 6 . 27 Dec 99 19 38 Sewer Charges: 15 .40 Nov 99 24 45 Oct 99 25 50 Sep 99 34 60 Current rg Due By: 9/11/00 84 .16 Aug 99 37 53 TOTAL DUE > $175. 80 (SEE REVERSE SIDE FOR IMPORTANT INFORMATION,MRP AND PHONE NUMBERS) Account Number : 4509701 PLEASE RETURN THIS PORTION WITH YOUR PAYMENT 8/14/2000 7 B Note: Area Service Address: 259tW CALLE ASPERO PLEASE ENTER AMOUNT PAID , Cit p of son, Jvap Capistrano - PREVIOUS BALANCE j 91.64 ' Oler Services Department CURRENT CHRRCaES > 84.16 / 32400 Paseo Rdelonto Ri► Son Juan Capistrano, CA 94675 949/493-1515 PLEASE PRY THIS AMOUNT> CHECKS MAY BE MADE PAYABLE TO"CITY OF SJC" 2590& CALLE ASPERO SAN JUAN CAPISTRANO, CA 92675 3908 fh zKn • �U CAPISTRANO VALLEY WATER DISTRICT -RATE CODES Rates &Allocations Effective as at 7/1/2000 7/12/00 COLE ' Cm7�IMER TYPE TIER I''° T1TR'IC ON TYPE '. A REGULAR LOT $1.25 $1.59 $2.65 A-Indoor @ 9+Standard Outdoor B LARGE LOT $1.25 $1.59 $2.65 B-Indoor @ 9+Outdoor by SQ FT C MASTER METERED RESIDENTAIL $1.25 $1.59 $2.65 C-Indoor @ 6+Outdoor by SQ FT D MULTI WITH OWN HRR $1.25 $1.59 $2.65 D-Indoor @ 9+Standard Outdoor(a#Units) E MULTI W/O IRR-Regular $1.25 $1.59 $2.65 E-Indoor only @ 9(z#Units) N IMULTI W/O IRR-High Density 51.25 $1.59 $2.65 N-Indoor only @ 12(z#Units) F ILANDSCAPE $1.25 $1.59 $2.65 F-Outdoor by SQ FT G JAG $1.01 $1.33 $2.39 G-Outdoor by SQ FT +Indoor. II 1COMMERCIAL $1.25 N/A N/A Tier I-Ag credit of$.24 per ccf ONTRUCTION $1.59 N/A N/A OTABLE $0.82 $1.03 $1.72 J-Outdoor by SQ FT ARGE $0.00 N/A N/A INES $1.59 N/A N/A ARM(Billed in 1,000 Gal $0.5481 N/A N/A ($.41 ccf) CE 537 CHARGE': 518" $6.27 1" $6.27 1.5" $9.43 211 $15.71 NG311 $31.47 4" $62.89 611 $125.83 811 $188.72 MISC.FLAT RATE USE $15.50 MOBILE HOMES $.627 er lot JUMPER $6.27 L FIRELINE $31.47 S 1CONSTRUCTION 1 $36.72 (i.e.$1.22 day) T NO CHARGE-MULTI MTR I $0.00 No charge i.e.Com owd meter DISC IDISCOUNT-CITY TREES ($6.2 =5 ccf SERV IDISCOUNT-SHARED SERVICE ($15.50) =Flat Rate Charge CHIDE ;CUSTOMER TYPE CHARGE A NO SJC SEWER $0.00 B Not used C RESIDENTIAL 515.40 PER UNIT(if multi units) D MULTI-RESIDENTIAL $12.30 PER UNIT(if mufti units E COMMERCIAL BY USE" *Monthly water use plus$15.40 P POOL-SMALL $10.00 0.30 ccf $0.80 G POOL-LARGE $20.00 31-100 ccf $0.95 H FLAT-AMBUEHL $226.00 101&>ccj I SL IO I FLAT-CAPD SCH $225.75 J FLAT-MARCO $299.50 K FLAT-SJ ELEM $143.80 L FLAT-CV CHURCH $278.50 M FLAT-ST MARG $164.15 N FLAT-NAZARENE $115.50 P Not Used Q MOBILE HOMES $10.00 PER UNIT p:\j=m RATES\700RATESMS EXHIBIT 2 e.3 A November 6, 2000 Mr. Jim Widner Administrative Services Manager City of San Juan Capistrano 32450 Paseo Adelanto San Juan Capistrano, CA 92675 Dear Jim: I was delighted to have the chance to meet with your team in the beautiful city of San Juan Capistrano, and present to you the complex functionality offered by CIS Infinity. From our meeting, I have gained an even better understanding of the needs of your organization, and I am confident that CIS Infinity will provide you with the support and functionality that you are looking for. I am very pleased by your interest in our product, and I hope that you were able to discover the true benefits of CIS Infinity through our product demonstration. As per our discussion, I have taken a closer look at our Price Proposal, and have considered the issues that you have mentioned. I have factored in the high level of expertise of your staff as well as the fact that we have completed similar conversions before, and consequently, I have reduced the Total Fees by a significant amount. I sincerely hope that this will better suit your budgetary situation, as I am truly excited about the opportunity to collaborate with you in your transition to a new Utility Billing System. As such, I ask that you take the time to review our newly revised Price Proposal, and contact me with your feedback. I look forward to meeting with your team again to further discuss long-term plans. Sincerely, Philip Playfair Vice President and Chief Marketing Officer 1.888-355-7772 info&ausc.com www.ausc.com k`l AD VAMC ED UT*LSTT SYNTE"A REVISED PRICE PROPOSAL Please find below a breakdown of pricing for the implementation of CIS Infinity, which includes Conversion, System Installation/ Set-up, Training, and Server/License Fees. (A) CONVERSION To provide an accurate and comprehensive assessment of the conversion process and the installation of the system, Advanced Utility Systems would usually propose to spend a day analyzing each utility system. At this time, Advanced Utility Systems is prepared to provide an estimate of conversion hours, including a schedule for both the conversion and installation processes. However, it should be recognized that changes might be required once the assessment takes place. Diagnose existing systems70 a) Determine what data is available b) Determine what data is not available a) Determine what data can be trusted Ma data fields from the existingsystems to news stem 15 Programming/testing of conversion code on the existing system 15 Identify and correct exceptions and problems in conversion 35 Perform ongoing conversions and ensure data mapping is correct 25 Formulate, develop and execute a"Go Live" strategy 10 TOTAL: 170 1 I] ADVANCED UTILITY AYMTWMi (B) SYSTEM INSTALLATION/SET-UP Install Server Software 10 Install Client Software 10 Configuration of the control files 55 Set up the interface with third party packages 35 Test billings/cash processing/adjustments with installed settings 25 Full testing of processes of CIS Infinity with existing systems. Advanced 55 Utility Systems staff on-site during parallel testing and live. Project Management 35 TOTAL: 225 (C) Training Training is vital to maximizing the benefits of CIS Infinity. Outlined below is the training hours recommended for training. Classroom training will augment the one-on-one training staff will receive during installation, parallel testing and going live. The training hours quoted are based on an average of 20-30 hours per user, which in our experience is the minimum required for each user who actively uses the billing and customer service aspects of the software. In some cases the requirement per user is less and in others, for example, administrator training, it will be more. Total training hours required, based on an estimated 10 users: 200 hours 2 AD VAMC Eca UTILJT'T iY;Ts"s (D) 'TOTAL FEES— INCLUDING LICENSE CHARGES Fee Structure Server License $ 25,000 User Licenses 6 @ $2,500 $ 15,000 Subtotal: $40,000 Conversion 170 hours @ $120 $ 20,400 Set-up and Install 225 hours @ $120 $ 27,000 Training 200 hours @ $120 $ 24,000 fid, Subtotal: _ 1 $71,400 TOTAL: Please note that the above fees are based on our current knowledge of your operation and may require revision following a more in-depth analysis of your organization. This quote is valid for 90 days from the date on the proposal. SUPPORT The team at Advanced Utility Systems has over 45 years combined experience in the utility sector. Our development team has extensive programming experience across many platforms, systems and programs including experience in Visual FoxPro, Oracle, SQL Server, Visual Basic, Visual C,Business Basic, RPG, Case,Pace, Cobol. Operating systems include Dos, NT,Unix, Windows 95/98, and AS400. The wide variety of experience within our team gives Advanced Utility Systems a unique ability to undertake complex conversions and interface with third party software. We offer 7 day a week 24 hour a day technical and user support. PC Anywhere 9.0 is used for remote support and we make site visits when necessary. The cost for annual support would be $10,000. E �✓bs . 3 Request for Proposal — Utility Billing System September 12,2000 City of San Juan Capistrano, CA ' ADVAN mpyq ti''i'�1.1?Y EYSTG MS Sir }iin IWYY�IIYI+�ir�l1 TABLE OF CONTENTS CITY OF SAN JUAN CAPISTRANO 1) EXECUTIVE SUMMARY 2) COMPANY OVERVIEW 3) FUNCTIONALITY QUESTIONS 4) SYSTEM REQUIREMENTS QUESTIONS (I) SYSTEM (II) IMPLEMENTATION (III) FEATURES 5) PRICE PROPOSAL _r # ADVANCED UTILITY SYSTEMS ExECUT1VE SUMMARY Advanced Utility Systems Corporation is proud to offer the Capistrano Valley Water District a proposal that defines and distinguishes the key factors that will provide the foundation for a successful conversion to a new Customer Information System. We appreciate the opportunity to highlight some of the strengths of CIS Infinity, our Customer Information and Billing software application. After review of our proposal, we hope that the City will see that Advanced represents a safe and practical choice for a complete CIS solution. After reviewing this Executive Summary,we are confident that the City will have a broad understanding of why so many public sector entities have chosen Advanced Utility Systems Corporation to provide the most functional, innovative, and progressive solutions available for CIS today. We have attempted to follow the RFP format, and have answered the Questions from Page 3 in the order presented, within Section 3. For the questions present under Exhibit A we have grouped responses under three main sub-headings within Section N—(i) System —which deals with "billing" issues; (ii) Implementation—which deals with installation, set-up, data conversion, support, and training issues, and; (iii) System Features-which deals with product functions. Company Strengths Advanced Utility Systems Corporation was formed in 1997 to provide Customer Information and Billing services exclusively for customers like the Capistrano Valley Water District. We have a deep understanding of the water industry and its needs: the majority of the company's management installation, sales and support personnel have worked for utilities themselves, and it is this experience and expertise upon which we draw to deliver powerful solutions. We believe one of the key reasons behind our success is our proven track record. In 1997 the company began with a single client. In three short years we now exceed 35 clients. In 1999 growth topped 100%. For the year 2000 Advanced Utility Systems has continued to experience very strong growth. Technology Structure/Future CIS Infinity is a Windows NT software solution utilizing data base independent technology'M. CIS Infinity supports multi-platform database engines including Oracle and Microsoft SQL Server. 1 7 ;I ADVANCED Y url4jyv s+Srent Implementation Methodology A thorough understanding of our streamlined implementation process is key to assessing the value of choosing CIS Infinity as your billing and customer information solution. Our previous work with more than 35 implementations for utilities has been instrumental in the development of our conversion, installation, set-up and training solutions. We know from experience that thorough preparation and effective scheduling increases the confidence of your staff while keeping overtime and costs to a minimum- and that's as important to us as it is to you. On-Going Support Structure During and after the implementation,the on-going support structure of Advanced Utility Systems Corporation will provide that added value to make the successful conversion to CIS Infinity. There are several elements to our service package that are provided with on-going support and maintenance. Some of these services include: Help Desk Support- AUSC offers a variety of support services based out of the company's Toronto office including the"Gold" 7-day a week 24 hour a day technical and user support, and the"Silver"`Business Hours" service. PC Anywhere 9.0 is used for remote support and site visits are made when necessary. Enhancements -No matter which support package is selected for the CIS Infinity system the Capistrano Valley Water District will be entitled to all ongoing enhancements to the system. These enhancements are included as part of the base support agreement and will be provided at no additional cost. Version Upgrades—New versions of CIS Infinity are included as part of the core support package. Historically new versions are issued annually. Continued Compatibility - Separating the back-end database from new versions of CIS Infinity means Capistrano can receive a new version and not be forced to or upgrade your database. Or if you elect to upgrade your database to a new release of SQL or Oracle, Advanced is constantly testing in-house all new database releases to ensure CIS Infinity is fully compatible with the latest database technology. This gives you the power to decide when it is time to upgrade database software, and not be dictated by the CIS application. Price Advanced Utility Systems prides itself on providing mission-critical software to Public Sector organizations for a reasonable price. CIS Infinity provides robust software, comprehensive support and cost effective solutions to the North American Utility marketplace. 2 vita ADVANCED UTILITY •TOTEM• Summa Benefits • Strong Company Stability and Mission • Innovative Product Functionality yl • Realistic and Progressive Technology Structure/Future • Proven `Best Practices"Implementation Methodology V • Consistent and Reliable On-Going Support Structure Wi • Competitive Price Future Versions Advanced Utility Systems is committed to keeping both our clients and our customers up-to-date with the latest technology and processes. Our policy of annual releases has allowed us to keep on top of the latest changes in both the utility industry and the software industry. Version 2.0 which will be shipping in January of 2001 provides our clients with the advantages of Database Independent TechnologyTM and our Rate InfinityTM rate management system. We have also completed interfaces to automatic payment firms, 12 different meter-reading devices, and, most recently, Bill Presentment technology that allows our customers to offer bills and bill payments over the web. In CIS Infinity, Version 2.0, we have a product that is robust yet flexible but we are committed to go farther. Our next version will take full advantage of not only the web but of mobile and palm computing. We are fully focused on taking advantage of com/dcom technology and are striving to provide tools to our clients that will allow them to take advantage of technological change. As we commit to strengthen our product, we commit to ensure that our customers can take advantage of the latest technology and techniques to provide state-of-the-art responsive customer care and billing services. 3 UTILITY SYSTEMS COMPANY OVERVIEW Advanced Utility Systems Corporation was formed in 1997 to provide Customer Information and Billing services for Municipal Electric Utilities like the Capistrano Valley Water District. Our services include providing the application software, software installation, product implementation, and complete acceptance testing. The implementation involves training, conversion, and complete documentation. It also involves working with your technical experts in specifying hardware and communications technology and ensuring the interfaces to the software application selected for financials and works management are operating seamlessly. CIS Infinity taps the potential of SQL development and object-oriented Windows technology in order to deliver a flexible and dynamic utility billing software system. Within three years of releasing CIS Infinity,billing and customer information software, Advanced Utility Systems Corporation has established itself as one of the leading suppliers of Windows NT solutions in the North American utility marketplace. The Advanced Utility Systems management team has proven experience in three key areas: innovative development of billing and customer service software for municipal water utilities, a thorough understanding of the role of information technology in the water business and a comprehensive understanding of the changing utility industry. That expertise has resulted in the creation of robust software, cost effective solutions and comprehensive client support. Over thirty-five utilities in North America, and many with similar operating characteristics to the Capistrano Water District, have already chosen CIS Infinity as their software solution. Their search for an experienced company,with comprehensive, affordable, and easy-to-use billing and customer information software has led them to Advanced Utility Systems Corporation. It is our hope your search will result in the selection of an Advanced Utility Systems' solution, as we demonstrate the fit between your needs and our solution. Advanced Utility Systems has approximately 35 staff that specialize in software development, implementation, support and administration for the utility sector. They are all based out of the company's Toronto office, with the exception of sales, based in Toronto and Atlanta. Advanced Utilities Systems Corporation is owned and led by three principals, along with several minority shareholders. The three are profiled below: 4 lok ADVANCED YTOLITY •Yl T4ala President and CFA Patricia Sorbara, the President and CEO of Advanced Utility Systems, is responsible for the overall strategic direction of the company. Patricia has fourteen years management experience, particularly in the energy and government sectors. For two years she was Chief of Staff to the Minister of Energy of the Province of Ontario where she participated in the Provinces deregulation process. Her expertise is in strategic planning and she has a proven ability to co-ordinate complex projects and produce results. Vice-president So hvare Development Steven Hammond is the Vice-President of Software Development. As the architect of the primary product, Steven oversees the ongoing development of the product, and its use by the customer. As well, Steven provides the direction necessary to ensure that the company meets its technical goals. For the last twelve years, Steven has provided system development and support to utilities, developing a unique understanding of the environment in which utilities operate. He has earned a solid reputation in the industry as an innovative programmer and architect of leading edge utility billing and customer service software. Vic President,Chief Marketing Offices Philip Playfair is the Vice-President, Chief Marketing Officer of Advanced Utility Systems. Philip directs the marketing and sales activity of the company and is responsible for the company's customer service strategies. His strengths include project coordination, innovative problem solving, and the successful implementation of complex information management projects. 5 "i ADVAN CE0 A' UTILITY FTF TFFIF FUNCTIONALITY QUESTIONS Advanced Utility Systems Corporation has a deep understanding of the water industry and its needs, enabling us to deliver powerful solutions. Based on the questions outlined on Page 3 of the RFP documentation the following summarizes the full responsiveness of CIS Infinity: Q1)Does your software meet the attached list of system requirements? Section IV addresses these questions, and highlights the key attributes of CIS Infinity that 1 enable Advanced to answer Yes to this question! Q2)What database is used as the foundation of your system? CIS Infinity utilizes data base independent technology to allow the use of Microsoft SQL, Microsoft Visual Foxpro or Oracle databases.The application runs on Microsoft NT Server Q3)What networking protocol does your system operate on? The system runs on Windows 95 —2000,and Windows NT. Q4)Is the system Client server?—CIS Infinity is an easy to use, fully flexible client/server application that will allow Capistrano to increase staff efficiencies and optimize staffing levels. Q5)Is system a Windows environment? —The software is built from the ground up as a windows application. Q6)Does system provide access to remote locations?—Both Capistrano staff and Advanced Utility Systems support staff can gain full access from remote locations. Q7)Can you provide the resources required to install the system in a timely manner?Advanced is committed to providing the expertise to effectively install the system and fully train the team at the Water District. Based on our experience the anticipated one/two month proposed time frame is too tight, and 4 months allows for a more effective implementation. Q8) Ad Hoc Reporting? The system allows full custom reporting as well as over s/ 80 standard reports. ` Q9) Sponsor regular user group meetings?The company holds an annual user It group meeting,with the next meeting scheduled for September 24—26.This year's meeting is near Toronto,the company's head office location. Q10 Provide User and System documentation? Both hard copy and electronic 6 t ADVANCED UTILITY srISTena versions of extensive documentation are provided. In addition full on-line help is built into the application. Q11)Will training meet the Water Districts needs?Training is held`on-she", accompanied by extensive documentation. Support is available when and how you need it. Q12)How many staff days of training are forecast?This can vary depending on staff specialized needs and level of experience and expertise,however a rule of thumb is an average of 4—6 days per user. Q13) Can we demonstrate CIS Infinity using the CV WD rates?Yes,we can install the cities rates and demonstrate the versatility of CIS Infinity through a demonstration. Q14) Can we provide a total list of customers?Yes,all our customers can be contacted.To respect workload of our clients we would like to propose a sub-list of clients in the water sector, of similar size and geograhic characteristics for reference follow-up if we are selected for a product demonstration. Q15) Please provide staff hourly rates for additional work or enhancements. All enhancements and new product releases are included as part of the support agreement. However future set-up and training would be done based on current hourly rates ranging from$120 to$150 depending on the level of expertise needed. Q16) Can firm meet the timelines outlined above—leading to full operation by December 1,2000? In customer research held in the spring of 2000 CIS Infinity was deemed "superior" in terms of user friendliness by over 83%of exisitng clients That said, it still requires extensive training to master the full functionality. As well data conversion and set-up are also time consuming. Therefore, depending on project start-date we recommend a four month installation schedule, and while we would have the software`operational" on Decmeber 1, it would be in test mode only. Q17) Provide a profile of your firm?In section II a company overview is provided Q18) Security—does your software meet proposed levels ? CIS Infinity has complete security including password access. It also uses the software application of it's database and application logic for full backup proceedures and full recovery. Q(19/20/21/22) What price is provided for the software, data conversion,training, and support? As is evident in the pricing Section V, CIS Infinity is functionaly rich, flexible- through the extensive use of control files, easy-to-use and operate, and innovative in design and development. All this at a competitive price, supported by an ongoing support and maintenance aggreemment. Q23)What is your policy with regard to future enhancements/upgrades? As is indicated in Section IV enhancements and product upgrades are included for free 7 - .MJADVANCED UTILITY OYSTONS as part of the support agreement. Q24)Will the source code be put in escrow?Yes! Q25)What is the cost of a performance bond? For past installations performance bonds have not presented a hurdle, and can be easily accomodated to meet your needs. 8 ' KDY' KNCED YT141iY {Y{T{Mi SYSTEM REQu mEMENTS (I) System CIS Infinity has been designed to handle the"general operational conditions"outlined in this section of the RFP. Operational and Proven with numerous clients the software is easily able to handle 13,000 accounts, for 10-12 total users, and meet all of the requirements outlined. By utilizing full SQL rollback, in the event of a major event such as a power outage, active files are `rolled back' prior to a commit and the integrity of the data is maintained. Highlights of the functionality built into the system include: CoNTRAcrs AND RATES A key strength of CIS Infinity is its ability to handle a myriad of rates and contracts. CIS Infinity can handle every residential, commercial and industrial rate currently in place. Using Rate Infinity Technology,we have developed a new rate engine that allows extremely complicated formulae and calculations that can be woven into individual rates, making secondary spreadsheets and manual work redundant. This total flexibility allows the software to also handle all unique contracts with your larger accounts. UTILITY BILL PREPARATION With CIS Infinity all billing processes including manual, estimated, budget, flat rate and rental are simplified. Real time transactions eliminate the need for day-end processes. The integration of the customer information and billing components of CIS Infinity makes processing adjustments, estimates and final bills quick and easy. You can define exception parameters and processes, make special discount and credit arrangements for individual customers and implement alternative tax rates and apply multiple taxes. CIS Infinity provides you with simplified billing processes, including cancel and rebill, bill re-print based on revised consumption history, single bill print from archives and re- print bill register. Bill registers are archived electronically. And,with the unlimited reading history provided by CIS Infinity you have greater precision for exception checking, usage quoting and estimating. CIS Infinity can be configured to offer different estimating procedures for each service. Bills, deposits and equalized billing can be estimated based on any formula you define, for example the amount of the last bill, the average of the last six months or year or two years, same as the bill six months ago, last year or two years ago. With CIS Infinity, history of the service address and previous customer's history for greater estimating precision can also be tracked. 9 5<, ADVANCED ". YTILITT [T[T[N[ CIS Infinity can currently save bills as an html format for e-mailing. As well, Advanced Utility Systems is working with a number of large financial institutions and have written interfaces to accept all forms of electronic payments including web payments. Efforts are currently underway to extend this functionality. NON-UTILITY BILL PREPARATION CIS Infinity has the capability to bill all types of different products and one-time charges. Using the billing interface users can create invoices for products and services. These invoices are tracked and aged like regular bills. Further, any type of flat rate or non- consumption charge can be associated with a customer and billed. CIS Infinity has the ability to bill and track any type of transaction, from cable to light bulbs. BILL PRINTING CIS Infinity has the flexibility to support printing locally or by printing by third party mailing houses. CASHIERING Whether it's a one-time cash payment from a non-utility customer or a pre-authorized payment plan through a bank draw for a regular customer, CIS Infinity gives you the flexibility you need to handle all payment types. You can define the parameters for each payment type through control files as well as the aging of accounts and the set up of multiple accounts receivable. Integrated with payment processing,the point of sale component of CIS Infinity offers you a wide range of options for product payments, including payment plans with interest, either as part of the customer's regular utility bill or billed separately. As with all other forms of payment processing, you can accept any payment type you choose. CIS Infinity supports the following payment processing types: • OCR Scanning • Electronic files from Lock Boxes • Real Time Posting of Payments • Bar Code Reading 10 _,mADVANCEa Yrikarr ararene (II) Implementation Services Successful implementation and operation of CIS Infinity requires certain key variables to be in place: ➢ An implementation team staffed with experts in data conversion, application set- up, configuration and testing. ➢ Experience in utility business processes. ➢ Formal Implementation processes, with the flexibility to adapt to unforeseen changes. Advanced Utility Systems will ensure these variables are accounted for during your implementation, and that the experience present in our team is applied to your implementation. Outlined on the next page is a graphical representation of a 4 month implementation schedule for CIS Infinity. This represents a"typical' installation, which we would refine once we determine your exact needs. We recognize that you are looking for a faster pace, suggesting a 1-2 month time frame. We believe the 4 month schedule can be accelerated as functions are done in parallel and others are done more quickly as we rely on your expertise. However installation faster than 3 - 4 months is not recommended. The following chart is intended to paint a"representative"picture of activities required. The chart is followed by a general explanation of each of the processes involved in the implementation process. 11 =1dw] ADVANC ED UTILITY SYSTEM/ On-Site Evaluation s Conversion Installation of CIS Infinity System Set-up Training Parallel Testing System Live Y w� k Month One • Advanced Utility Systems undertakes an on-site evaluation of your existing software, and completes the initial best practices assessment,including billing cycles, cash processes, daily processes, and undertake an assessment of the level of computer literacy of your staff • An analysis of your data is completed and Advanced Utility Systems begins the development of conversion utilities to import data from your existing billing system • These utilities are modified over a period of time until such time that the staff of both Advanced Utility Systems and the Capistrano Valley Water District are satisfied with the results • Any customizations are identified, and specifications set if it is deemed that they are necessary. • CIS Infinity software is installed with the first of the converted data • The data is used for general training on the software and to test the accuracy of the conversion routines • The initial set-up of control files in CIS Infinity is completed Month Two • The conversion routines are approved by both the City and staff from Advanced Utility Systems • More intensive training is conducted with emphasis on the Billing and Payment processing modules. The system is tested, with emphasis on the set-up of the control files Month Three • Emphasis is on preparation for running parallel • Training is focused on customer service inquiries, notices, penalties, and arrangements • Testing is done on the rate structures, penalty pick-up, and finalizing the integration with the Financial software. 12 " , ADVANCED UTILITY {Y\T[M• Month Four • Focus is on running CIS Infinity parallel with the existing billing software • Training will focus on billing and testing the new system • Testing is complete and a decision is made to go live Based on over 35 installations, many of which share the operating characteristics of the Capistrano Valley Water District,this implementation process has been honed. A successfully implementation is dependent upon the team at Advanced Utility Systems working hand-in-hand with the team from the City, and sharing their expertise and knowledge of the process Training Services Training is vital to optimizing the benefits of CIS Infinity. The more confidence users have when using CIS Infinity, the smoother the implementation process will be and the more effectively the software will perform for you when you go live. Advanced Utility Systems would assume responsibility to train the primary and secondary users indicated, and work with them to ensure casual users then receive elements of this training. All staff who will have any contact with CIS Infinity will receive Overview Training to allow them to inquire on the software,test data and make minor edits when necessary. Users who use the software on a full-time basis receive intensive one-on-one training with a focus on their particular area of responsibility. A significant portion of time is allotted to focus on Administrator Training, as the understanding and effective use of the control files and data structures of the system will ensure that CIS Infinity is used to its maximum potential. Classroom training held at your site will be arranged to augment the one-on-one training staff will receive during installation and parallel testing. In this case, we generally train your billing and cash staff, your customer service staff and your meter inventory staff in separate groups,to ensure the most effective use of their time. The skill level of your staff(particularly their experience with Windows), and the way staffing resources are allocated (whether staff are assigned individual aspects of the billing process or whether all staff know all aspects of billing), are the primary factors that are taken into consideration when a training plan is developed. In our pricing estimate we have projected 4-6 days of training per person as an average requirement By the completion of Administrator Training, users will be able to set up new rates and services, implement multiple rate classes and structures and customize bills by customer type. Users will be trained to utilize aspects of CIS Infinity that will be crucial to your future in the ever-changing water industry. User Training usually takes place in five distinct sessions over several weeks depending on your needs. Based on our experience with previous implementations, an integrated 13 7 A O V A N C E O UTILITY §V514"[ approach to training has been developed to not only reflects the set-up of CIS Infinity at your utility but also progresses logically for your staff. As each training component is completed, users will be ready to run parallel with those functions. Throughout the implementation phase and the first several weeks live on CIS Infinity your staff will have full access to the same team members who trained them. This ensures that we're totally familiar with the needs of your staff and that your staff has a high level of comfort. Our commitment to training and client support means that we do not leave until your staff has everything they need to do their jobs. A formal training plan will be developed if we are selected as the vendor of choice. PRODUCT DOCUMENTATION User and Technical documentation for the application software is extensive, and fully addresses all aspects of system operation. It is available in both hard copy and electronically, and we will provide one master and one copy of documentation as requested. We would be happy to provide samples at a product demonstration. PROPOSED IMPLEMENTATION TEAM STRUCTURE Advanced Utliity Systems Corp. Steering Committee . Change Ntanagement, Project>Manager ,, Advanced Utility Systerms- S n r Conversion Expert SnrAnalyst InterfaceExperts ShrTrainer Conversion Ts0rIician Installer. Trainer 14 yADVAMC ED UTILITY RTNITE"S (III) Features CREDIT AND COLLECTIONS Collections procedures including penalty pick up are automated, based on collection parameters you define. CIS Infinity will build credit ratings based on your specifications. CIS Infinity stores unlimited collection history for each account that is quickly accessible through the customer information screen. As well past due follow-up activities required are fully processed by CIS Infinity. The examples cited such as shut off notices and past due notices are generated by CIS Infinity. REPORTS CIS Infinity contains an ad-hoc query tool called Advanced Search. It allows a user to search on any field within the database. The user places "operators" on the field and types in a variable to start the search. All matching records can be exported to a spreadsheet for further manipulation, or can be filtered on screen. Ad-hoc reporting will be available in Version 2.0. Users have the ability to query any database field and create their own report formats. As well, any ODBC compliant reporting software can be used to query the tables from outside of CIS Infinity. CUSTOMER INFORMATION REQUIREMENTS The information requirements stated in the RFP can be demonstrated through sample screen prints from CIS Infinity. Shown below is the main customer inquiry form, from which your billing staff can access most of the information required to effectively serve your customers. 15 ADVANCED I UTILITY {TBTIEMt g, P{ 9 811-0l1 Nesdeettiet. 2000MA03 1 ...m m. "89M0- O.OMMIN O.M0009•'� 0.000090'„. 91000860 „ I OWN , 11 � *. 4Y M .Y'.,. J'x f .`�G A7FHI..N6 Y MG_ 4YW.iYbP.4bN3 .• ` A024796 Water -< Outsid.MotorQ 6 `1.000900 8.000090 Gallons M1 M0091805A',„ 1207698 Water Q Outside Meter m 6 11000808 0.900680 GWd0s Z.M00 I 3287648 M19h Flew_®Inside Meter 7 10.000000 8.980088 Gegdns © 2700 I/ ?; 3267540 Low Flow_d lwide Meter [ 6 11000090 0.000000 Gallotw E3 96090 I I 1123456 Water OUt9ida Mel<r Q 5 19.000800 0.800690 1019964 The software uses both a service account number(premise number) and a customer number. The district's current account numbers can in all likelihood be used to form the new systems account/premise number. Cycles can be billed throughout the month, adhering to your current schedule, or re-set to follow a different schedule. SECURITY DEPOSITS Collection parameters are specifically designed for deposits. CIS Infinity can be configured to provide automated interest pick up with interest applied to either the deposit or the account. INTERFACES As indicated in the RFP you wish to transfer information to the General Ledger system. As well links to the GIS System ArcView and AutoMap2000 are necessary. Where a new interface is required for a common third party software application in use by many utilities we will absorb most of the costs of development applicable to CIS Infinity. Where a new interface is required with a software application that is unique and custom built we will develop it at the clients cost. Currently we have interfaces to the following financial software packages: Great Plains, AccPac, J.D. Edwards,Platinum, Business Vision and a host of other proprietary packages. In addition links to several GIS Systems are in development. If Capistrano Water District uses any one of these applications the set-up would occur during the installation. 16 ADVANCEO UTILITY 5VOTSM9 SERVICE APPOINTMENTS Integrated with the contact management component of the software,the service order module can be configured to automatically generate service orders in response to other activity within the system as a whole. For example, CIS Infinity will automatically issue a service order for a final meter reading on an account when a move out is entered. Whether generated automatically or manually, the service order system will schedule the service order, assign it to a user or department and track it through the entire CIS system until completion. The software can store unlimited customer information including multiple names on accounts, all service address information including lot, plan concession and roll number, phone numbers for home,business, fax, cellular, pager, employer, lawyer and more, as well as e-mail and web addresses. You can use CIS Infinity to track customer demographic information. METER EQUIPMENT AND INVENTORY The meter inventory functionality of CIS Infinity supports multiple meter changes and tracks meters in the field, in stock and scrapped. It also tracks repair history, and meter information such as number of dials and manufacturer. Through the automated link to the contact management system, CIS Infinity generates service orders for reverif:cation or repairs and produces reports for service orders and replacements. Backflow system administration and notices and follow-up are supported by CIS Infinity. METER READINGS CIS Infinity interfaces with automatic meter reading devices and is fully compatible with data capture units including Itron (Premier, Premier Plus, MVRS/FS2), Radix, DAP, Sensus and many other electronic read transmitters. CIS Infinity is fully configurable to process radio reads collected using an ERT remote and all types of remote devices(ARB, Sensus Touch). Clients can maximize the use of automated reading features,for example, updating the meter reader's notes and codes, re-routing and route details. MOVE IN/MOVE OUT PROCESS With the automated contact management system in CIS Infinity,the move in/move out process is simplified. With the completion of a move in/move out entry on CIS Infinity, the meter reading is automatically scheduled,the necessary service orders are generated and all information for processing deposits and final bills are prepared HARDWARE SPECIFICATIONS The hardware platform needed to support CIS Infinity is outlined below. It represents modern, state-of-the-art technology, so that the Water District will be able to not only optimize CIS Infinity, but also operate other elements in a cost-effective, scalable manner. 17 ADVANCED UT161TT *YfrRMi While selection of a technology platform may appear to be an afterthought, it is very important. Selecting a CIS application that uses older, or poorly supported technology such as AS400 servers can create problems in the future. Because it is not an open system the AS400 platform is severely limited in areas such as scalability, networking, future support,the use of 3`d party tools, and requires expensive ongoing maintenance. They are also expensive to purchase for new users. Selecting an NT Operating System, along with Pentium technology, provides numerous benefits. Pentium chips are literally doubling in speed every 1-3 years, with costs almost unchanged. Annual maintenance costs of older AS400 platforms are comparable to the costs of new Pentium servers. NT systems are scalable, multi-platform, which can interface easily and com.pletely with the Microsoft suite of office products. As well they are open to the use of 3 party tools, such as Crystal Reports. MINIMUM HARDWARE SPECIFICATIONS(FOR EXISTING HARDWARE) Server: Pentium I1300 9 gig of disk space (SCSI) 256 megabyte of ram 10/100 megabit network Windows NT 4.0 operating system Workstations: Pentium II 200 64 megabyte of ram(128 is recommended for billing staff) 15" monitor(17" is recommended for customer service staff) 2 megabyte video cards, minimum resolution of 1024 x 768 pixels Printer: Laser(high capacity, high volume) Networking: 10/100 megabit Network cards and cabling PREFERRED HARDWARE SPECIFICATIONS(IF BUYING NEW) Server: Pentium 111600 18 gig of disk space (SCSI)-(RAID) 512 megabyte of ram Adequate tape backup 100 megabit network Windows NT 4.0 operating system Workstations: Pentium 111600 128 megabyte of ram(256 is recommended for billing staff) 15"monitor(17"is recommended for staff who deal directly with customers) Printer: Laser (high capacity, high volume) 18 ADVANCED k UTILITY tYsreMi Networking: 100 megabit Network cards and cabling CLIENT LISTING Attached is a listing of the company's current clients. We have also provided an indication of the products and services they bill. We ask that you only contact them if we are one of the short-listed vendors, as we wish to respect their heavy workload. If you would please let us know whom you wish to contact we can provide contact names and phone numbers. We would also like to work with you to provide names of similar utilities in terms of size, location and product mix. 1 N7fS Aurora Hydro Electric Commission Ontario Electric Town of Berlin Maryland Electric/Water Cambridge &North Dumfries Hydro Electric Ontario Electric/Water/ Commission Fibre Optics Cam bellford P.U.C. Ontario Electric/Water Cochrane P.U.C. Ontario Electric/Water Collingwood P.U.C. Ontario Electric/Water Dunnville Hydro Electric Commission Ontario Electric/Water E.L.K. Energy Ontario Electric Energy West Arizona, Montana, Electric/Gas/ Wyoming Pro ane df+ City of Galveston Texas Water rn` Goulbourn Hydro Electric Commission Ontario Electric Gravenhurst Hydro Electric Commission Ontario Electric Greater Napanee Water Supply &Pollution Ontario Water Control Board New Haldimand Hydro Ontario Electric/Water Hearst P.U.C. Ontario Electric/Water Kanata Hydro-Electric Commission Ontario Electric Lincoln Hydro Electric Commission Ontario Electric Midland P.U.C. Ontario Electric/Water Nanticoke Hydro Electric Commission Ontario Electric/Water Town of Newmarket Ontario Water Niagara-On-The-Lake Hydro Ontario Electric North Slope Borough Alaska Electric/Water Orangeville Hydro Ontario Electric/Water Orillia Water Light & Power Commission Ontario Electric/Fibre Optics Ottawa Transition Board Ontario Electric Park Water Company California Water Pembroke Hydro Electric Commission Ontario Electric Penetanguishene Hydro Electric Commission Ontario Electric City of Redlands California Water 19 u . A0vANCEO � ur�L,�rr tr�r<Ma Client�7 `LticaltiOn. SerMi�eS Reedsburg Utility Commission Wisconsin Electric/Water Renfrew H dro Electric Commission Ontario Electric Town of Richmond Hill Ontario Water Schlumberger Resource Management New Brunswick Water Services Miramichi Seacoast Utility Authority Florida Water Smiths Falls Hydro,Electric System Ontario Electric St. Thomas Public Utilities Commission Ontario Electric/Water Tay Hydro Ontario Electric Wasa a Electric Energy Commission Ontario Electric Waukesha Water Utility Wisconsin Water West Nipissing Hydro Electric Ontario Electric/Water Woodstock P.U.C. Ontario Electric/Water 20 z ADVANCED uriLitr ST&TV"A PRICE PROPOSAL Please find below a breakdown of pricing for the implementation of CIS Infinity, which includes Conversion, System Installation/ Set-up, Training, and Server/License Fees. (A) CONVERSION To provide an accurate and comprehensive assessment of the conversion process and the installation of the system, Advanced Utility Systems would usually propose to spend a day analyzing each utility system. At this time, Advanced Utility Systems is prepared to provide an estimate of conversion hours, including a schedule for both the conversion and installation processes. However, it should be recognized that changes might be required once the assessment takes place. .�.;� "YtM "7`.t EF e� d � .�a a �a 3. a. x Diagnose existing systems 80 a) Determine what data is available b) Determine what data is not available a) Determine what data can be trusted Ma data fields from the existingsystems to news stem 20 Programming/testing of conversion code on the existing system 20 Identify and correct exceptions and problems in conversion 40 Perform ongoing conversions and ensure data mapping is correct 30 Formulate, develop and execute a"Go Live" strategy 10 ToTAL: 200 21 elf; A 0 V A N C E 0 u TILiVY SYNTENS (B) SYSTEM INSTALLATION/SET-UP Install Server Software 10 Install Client Software 10 Configuration of the control files 60 Set up the interface with third party packages 40 Test billings/cash processing/adjustments with installed settings 25 Full testing of processes of CIS Infinity with existing systems. Advanced 60 Utility Systems staff on-site during parallel testing and live. Project Management 40 TOTAL 245 (C) Training Training is vital to maximizing the benefits of CIS Infinity. Outlined below is the training hours recommended for training. Classroom training will augment the one-on-one training staff will receive during installation, parallel testing and going live. The training hours quoted are based on an average of 20-30 hours per user,which in our experience is the minimum required for each user who actively uses the billing and customer service aspects of the software. In some cases the requirement per user is less and in others, for example, administrator training, it will be more. Total training hours required, based on an estimated 10 users: 250 hours 22 y\�:JADVANCED UTILITY SYNTIR"S (D) TOTAL FEES— INCLUDING LICENSE CHARGES MIT Server License $25,000 User Licenses 6 @ $2,500 $15,000 Subtotal: $40,000 Conversion 200 hours @ $120 $ 24,000 Set-up and Install 245 hours @ $120 $ 29,400 Training 250 hours @ $120 $ 30,000 Subtotal: $83,400 TOTAL: $123,400 Please note that the above fees are based on our current knowledge of your operation and may require revision following a more in-depth analysis of your organization. This quote is valid for 90 days from the date on the proposal. SUPPORT The team at Advanced Utility Systems has over 45 years combined experience in the utility sector. Our development team has extensive programming experience across many platforms, systems and programs including experience in Visual FoxPro, Oracle, SQL Server, Visual Basic, Visual C, Business Basic, RPG, Case, Pace, Cobol. Operating systems include Dos,NT, Unix, Windows 95/98, and AS400. The wide variety of experience within our team gives Advanced Utility Systems a unique ability to undertake complex conversions and interface with third party software. We offer 7 day a week 24 hour a day technical and user support. PC Anywhere 9.0 is used for remote support and we make site visits when necessary. The cost for annual support would be $10,000. 23 3 { ADVANCED UTILITY SYSTEMS 3. . MAIN MENU z. CIS Infinity is comprised of integrated components that together } . function as the central core of your EI information database for your entire qi utility. [A sample screen print displaying the Main Menu is shown on the reverse side of this page.] Over one hundred, user definable control files give you total command over your billing and customer information processes. Even the menus are dynamic, not hard coded. You can decide what you call files, which way the menus are organized and even which menus go on 4 which desktops. �'Ix N As part of the implementation process, we'll set up your control files to ;fit accurately reflect your current processes and meet any specified future needs. During our comprehensive Administrator Training, you'll learn how to k configure the control files in order to effectively meet the challenges of the quickly changing business environment. Through the control files you can define billing, collection and penalty procedures to respond proactively to the specific needs of your staff and your customers. You can also change your rates, add new services and bring new products to market quickly without the need for additional programming. ADVANCED THINKING : ADVANCED SOLUTIONS A'D-\%_ " n 4 I blit .t ym Cuiyuabrn CI 2000 vl G FF3 $ r rsi ,+ A k ries e§+t $ i i1.t� E'r `, �` •. d fX u''`�i•}M�'faimn*' 1y Or. ' Y' Fn AW� i `u•• ' V4G a :xii� f r}F ti m 3� ? i[ A , 7 4 e f �i ADVANCED UTILITY SYSTEMS SYSTEM . SY BILLING INFO■MATON \ \ . With CIS Infinity 9u can process : 4; unlimited meters per service, ' « \K unlimited ery2B per customer ( ( and mu p� accounts per customer \ � — all on one bill. ! per u billing structures « OS Infinity enable 9u to implement multiple rate Uss and . structures, offer eGb� contract options, Gsmi y& by customer type ad offer both / ) aggregated and consolidated i billing. . � / sample screen pant d222the Bili afmm, ¥ shown mthe \ , » reverse seothis 777 } : d ! � . p \ E � \ A ADVANCED THINKING ADVANCED SOLUTIONS & < I 4 M1�#�v�i;E 4� t � � �'M `{y{l�i• � k �> (p0 t � r i °"Ti' i._,,,a u.. fry -�'-s' m K".m... Ali- ........... 9J k� c ry ,. agry ^I mow- Y 4 W' fLl' I.Or6. !' I1n �°.w..M��Yw��d '.�:alu..A lw' •�` '�L :1�,:c�.L. '`�•�`' 6i C9 II I p E FF l ^5 � 3 9, �Y S I } ADVANCED I . i� UTILITY SYSTEMS iI CUSTOMER ACCOUNT INQUIRY SCREEN CIS Infinity enables you to respond quickly and effectively to t � customer inquiries. The user interface is designed to provide x access from the account inquiry screen to all customer information with the click of a mouse. In response to a customer's call you can quickly track all outgoing and internal account activity including previous inquiries, correspondence and service orders. yye Si F CIS Infinity retains all customer history including calling history, correspondence notes, comments, service orders, usage, credit and payment for an unlimited period of time. [A sample screen print displaying the Customer Account Inquiry Screen is shown on the reverse side of this page] -� i I: "-1 z �.Y ADVANCED THINKING ADVANCED SOLUTIONS A.M • • • t'� i�V ��y� d � '°Inr r�l� a�� �-�4 �V� �i":���` , �' , A'✓' f a � �� a ' y f V y rT - Q��13 e� �XwF ����"�r bt�7fn� " i v'�'�`ro"C� ����•.h'F rye}: eP KNI �r"�."' ° nr rP•� �. �avn ta.nrr�"4t ti'•.- td'e 1�4`s, fi� Frt '7�� wu� l tem� � a0. � � yJ"sl khy � V a a t �S+yu4 � a wrm k 1 G ' I i f ADVANCED UTILITY SYSTEMS pd r CONTACT MANAGEMENT The ability to track all customer contacts is crucial to providing j superior customer care. With CIS Infinity all customer contact is accessible from one screen. You can view notes, tasks, payment arrangements, letters, service orders, notice history, contact history and inquiry history individually. Or, you can choose the option of viewing the total history of all interactions with the customer at once. Ir, C With CIS Infinity you can directly assign tasks to a user or department that arise from customer inquiry calls. [A sample screen print displaying the Customer Management screen is shown on the reverse side of this page] ,3 i' x t. ADVANCED THINKING ADVANCED SOLUTIONS AD'V �tfiJ; (jt ol IM 6,•vn s ,v is .' . LtM., N4 "L i ' i• 5 4�z..r"sus ( i 3 „S411,11E ' 11155 =41=1 .. o-v ss t -sa- flT' y".;nnwn �,3uP arvazatx^ anm.z YV"`+ "'✓-�" t s �i � s 14r V r�td0. mt� Fmmzkv}_i�?g t r #x.. t` t i �r. rs i � ADVANCED UTILITY SYSTEMS nom. CUSTOMER/ACCOUNT INFORMATION t� The Customer/Account Information I + tab allows you to view a customer's account status and their associated details in a glance. With easy to use drop down menus, "S CIS Infinity allows you to point, click and make any necessary edits or changes. Through the Customer/Account Information Tab you can set up alternative tax options, tax exemptions and penalty exemptions. [A sample screen print displaying the Customer/Account Information Screen is shown on the reverse side of this page] a i. is 4 � i r.: ADVANCED THINKING ADVANCED SOLUTIONS AP L„ oafs'e���a,�,lisat�J�a��� ICa�� �.�kt�i!`', ,,ell�.swsaz.�,l�•�_... C.e.t,-! G. ,!. G,�_(B;p'I a r pAi �..;i 'xY"-.:F ww0.40. AyG, E�i� a s�{�r+ .fiXnna ° bJ�:✓ I [uk7 aPL�6ry .... zeu 5.d'7uwy�a °'�✓u ,w^'�^�`y�'<v...-, r � 3 vis; "lTM..dt��k a.�"` mhxsr •4 �)� r*vim J*Ka r5 x r �° a:r c".- � �Nv lt'•r�h� tiw ��, `�'a•ey rr 4 �'s� xv� �lv�b�xl;� Hpll P' f S YID '( i s ADVANCED : UTILITY SYSTEMS IL READING HISTORY GRAPH Unlimited history of consumption 1" by account and by service can be ;. viewed in a graph or exported to a spreadsheet. Using a bar graph for easy analysis, comparative account history can be made available to your customers. You can define the parameters of the reading history graph choosing the time frame and method for the comparison. You can also choose to include previous service address history and cancelled bills. [A sample screen print displaying a Reading History Graph (on water usage)is shown on the reverse side of this page] s it ADVANCED THINKING ADVANCED SOLUTIONS i i` � s lb .+o-�w .,ye�r,< w�1� _ iw r '* a �r�i x' t4. ri+-i { e '�fp1 , y, rA 'y• Man .. � ilki Ifi A �' h �ti.,9 r 7gfr�ntle grj *`r+J"t"4y' c k �t x 1�1 �' @r^,ua +} ✓ %''a� ly t s� Al E ( a k � lxt'f- "Rz 4 "+' '� * &h hr✓'t �S"r`' Gig � LPy Bir f'ti� r �m t.y��y rl ��P ra x`�1 Cal: ' ,�'...,lL �A2-9s9vui ear r vfifl•" w hx x ^ '' �A.." �..� t 8 � 8�t ' 4}j � u+` d ADVANCED UTILITY SYSTEMS kWkW F% r � 'o WATER METER INVENTORY The meter inventory system integrates with the contact management component and service order system of CIS Infinity to schedule meter readings, reverification and repairs and produce reports for service orders and replacements. Now you can track multiple meter changes and track meters in the field, in stock and scrapped. CIS Infinity can store unlimited meter history including field notes and installation information. [A sample screen print displaying the water meter inventory screen is shown on the reverse side of this page] a s� t. ADVANCED THINKING ADVANCED SOLUTIONS --:- A:DV.,,t "aw' • 'k{y..KAf3 � Vv'1 w '; iW r...ne 4 fi .� v �S^ 3 H' -77577 !w'"�"p "n s 2e3��,e �,,,t t�" Y. � ,� xt � v:•8 > ��klx^�r ',� ` .. ���#fro �.-• �t at� 9 kx F {*'�,"Y yz—",14*�YY'''01MM1rAd 9,(^n t t r; i-i t