AgdaPkt 2002-07-15 - Laserfiche WebLink

Browse Search

IREPORT To the Honorable Mayor and .C..ity Council From the City Manager July 15, 2002 Subject Agreement for Professional Consulting Services related to the City's Water Allocation Program (WAP) Recommendation By Motion, authorize execution of an agreement with Kortech, Information Technology Consulting of Redwood City, California, for providing professional consulting services to assess the system architecture of the Water Allocation Program, in the amount not to exceed $18,000. Background On May, 2001, the City implemented a Water Allocation Program (WAP) for all residential water customers, to provide a "fair and equitable" way to distribute water during possible future water shortages, taking into consideration the individual customer needs and their conservation efforts. On May 10, 2001, 19,000 surveys were mailed to all residential water customers asking them to provide information regarding their household, in order to calculate their water allocation based on their individual needs. In April, 2001, the City council approved an agreement with Kortech for the development of a web-based survey data entry format to give residential customers the ability to complete their WAP surYey on-line. Of the 19,000 surveys mailed, fifty percent of the residential customers completed the survey with 15% completed on-line. The water allocations were printed on the utility bills beginning in the fall of 2001~ The WAP software program was originally created in 1997 as a FoxPro database and was updated to an Access format, prior to its implementation in 2001. The program has been performing well but has limitations regarding the information available for customer support and the ability to modify allocation criteria, perform analysis and prepare reports and graphs. Staff is now planning to enhance and improve the existing WAP software program to: 1 ) provide a higher level of administration of the program in preparation for a future water shortage, 2) provide customer information screens for administrative staff to facilitate interaction with customers, 3) expand the use of the web for'customer support and to prepare for expansion of the program for other customer classes beyond the residential classification. Before we can proceed with the WAP sofbNare improvements it is necessary to perform a WAP software architecture analysis and assessment; Kortech's scope of work for this project will provide the analysis and identify recommended improvements to the software. Staff plans to come back to the council with a plan and scope of work to implement the