Agmt06 KorTech Consulting - Laserfiche WebLink

Browse Search

EXHIBIT "A" SCOPE OF SERVICES Scope of Work for Stage 9 Stage 9 represents a major enhancement to WAP. It consists generally of some relatively minor maintenance improvements, plus support for multi-family residential (MFR) customers, commercial (Comm) customers, and an analysis tool for drought scenarios. Currently WAP supports only residential customers with bimonthly billing. Providing support for MFR and Comm customers, and monthly billed residential customers, is fairly involved because the data model must be changed to reflect the complex relationships among customers, sites, accounts, and meters and calculations for water allocations must be extended to support monthly as well as bimonthly billing. The new drought scenario tool represents significant new functionality. The work for Stage 9 is divided into categories of maintenance, general data model and processing changes, data loading, drought scenarios, system test, documentation, and miscellaneous. MAINTENANCE Task Description. Perform maintenance as described below. . Record the identity of any user who enters or updates data in WAP. . Make the query and reporting facilities and allocation calculator available in wapadmin2. . Automate processing of account updates and exporting of the allocation master. (See . GENERAL DATA MODEL AND PROCESSING CHANGES for a discussion on why the account master no longer needs to be imported.) . Provide notification to WAP system administrator of new accounts. This will be done by Redwood City IT. . Support other ad hoc minor maintenance requests that may arise during the project. Deliverables. Design, implementation, unit test. Work Estimate. Not to exceed 90 hours. GENERAL DATA MODEL AND PROCESSING CHANGES Task Description. In order to implement support for MFR and Comm customers, the current system must undergo significant changes to the data model and underlying software. Under the current implementation for residential customers only, no distinction is made between customer and account, or between account and meter. However, with MFR and Comm customers, we have a much richer and more complex data model. We need to support the notion of a Customer who is responsible for one or more sites, each of which may have one or more billing accounts, each associated with exactly one meter. Water allocation targets apply to the collection of all meters at a site. Water-saving programs such as toilet rebates will be applied at the level of a customer's site. The formula for calculating water allocation will be a function of the customer's class (residential, MFR, or Comm). Note that the notion of site is not rigorously defined. Intuitively, a site groups meters for a customer at a more-or-Iess contiguous set of locations. For Residential customers, a site is the Agreement over $1 OK City Attorney Approved Version 111803 10