Agmt09 Kennedy/Jenks Consultants

Browse Search

EXHIBIT "A" SCOPE OF SERVICES The scope of services for DPS data analysis involves the following tasks: TASK 0: Effort Expended for Meeting of March 26, 2009 Task 0 is intended to cover the effort required to prepare for and attend a meeting held at the Redwood City Public Works Services office on 26 March 2009. Kennedy/Jenks staff performed some data analysis and developed demand-pressure curves in preparation for the meeting. The curves were used to illustrate the limitations of using the raw pump station data from summer 2008 and as the basis for discussion of how to move forward with further data analysis. The outcome of the meeting provides the basis for Tasks 1 through 5. Three K/J staff attended the meeting, which lasted approximately two hours. Meeting minutes were prepared and distributed subsequent to the meeting. TASK 1: Operational Data Request and Analysis Kennedy/Jenks will request one-minute interval pump flow and pressure data from EDCCO, the City's SCADA consultant, for the months of June, July and August, 2008, as well as identify other data gaps to include in the previous data received. Kennedy/Jenks will analyze the one-minute interval data from June through October 2008, and develop a means to smooth out the data. Two techniques will be tested for at least one week's worth of data to see which one provides a more appropriate demand approximation: 1) Use the "running average" method, whereby each data point will be averaged with data points before and after it (for example, two data points before and two data points after it as a "5-minute running average"). A 5-minute, 10-minute, and 15-minute, and 20-minute running average will be developed. 2) Use a "simple average" method, whereby data for minutes 1 through 5 will be averaged together to determine the pressure and flow for that 5- minute period. Data for minutes 6 through 10 will be averaged together to determine pressure and flow for that 5-minute period, and so on. Within 7 working days of receiving the data from EDCCO, Kennedy/Jenks will share the results of the test of the two techniques with the City and provide a preliminary recommendation via email transmittal which technique and duration should be used to analyze the full set of data. We assume the City will provide direction on which method to use within 3 working days of receipt of the email notification. Following receipt of the City's response, Kennedy/Jenks will implement the method specified by the City and apply that method Agreement over $1 OK 10 City Attorney Approved Version 111803