HomeMy WebLinkAboutContract 37548-A1STATE OF TEXAS S
COUNTY OF TARRANTS
AMENDMENT NUMBER 1
CITY SECRETARY CONTRACT NO. 31514 �L n I
WHEREAS, the City of Fort Worth (CITY) and Freese &Nichols, Inc., (ENGINEER) made and entered into
City Secretary Contract No. 37548, (the CONTRACT) which was authorized by the City Council by M&C C.
22997 on the 9th day of February, 2010;
WHEREAS, the Contract involves engineering services for the following project:
Update the Wastewater System Master Plan Citywide
(Project No. );
WHEREAS, it has become necessary to execute Amendment No. 1 to said Contract to include an
increased scope of work and revised maximum fee;
NOW THEREFORE, CITY and ENGINEER, acting herein by and through their duly authorized
representatives, enter into the following agreement, which amends the Contract:
1.
Article I of the Contract is amended to include the additional engineering services specified in the
attached Exhibits A1, B, B-2A, B=3A and 134A, copies of which are attached hereto and incorporated
herein. The cost to City for the additional design services to be performed by Engineer total $346,427.00
2.
Article II of the Contract is amended to provide for an increase in the maximum fee to be paid to
Engineer for all work and services performed under the Contract, as amended, so that the total fee paid
by the City for all work and services shall not exceed the sum of $3,333,620.00.
3.
All other provisions of the Contract, which are not expressly amended here
and effect.
Page -1-
OFFICIAL RECQRD
CITY SECRETARY
T.
WORTH, TX
EXECUTED on this theC day of MWZ162=0 in Fort Worth, Tarrant County, Texas.
ATTEST:
City Secretary
APPROVAL RECOMME"'^�^•
S. Frank Crumb, Director
Water Department
FREESE and NICHOLS, INC.
FNf;11UFFR
Thomas Haster, P.E., Principal
APPROVED AS TO FORM AND LEGALITY:
Amy Ramsey
Assistant City Attorney
APPROVED:
Fernando Costa
Assistant City Manager
Contrac 4 Authorz zatiox
C)�j
to
Page -2-
OFFICIAL RECORD'
CITY SECRETARY
FT. WORTH, TX
EXHIBIT 14-1
SUPPLEMENTAL SCOPE OF SERVICES
(SUPPLEMENT TO ATTACHMENT "A")
The followingclarification of the tasks that ENGINEER will perform under Amendment
1 to the existing contract for the Update of the Wastewater System Master Plan Citywide.
Work under this amendment includes engineering services for the following:
Additional Flow Monitoring Services and Data Integration Needs for a Sustainable Risk
Based Assessment Program (CapPlan) and Graphical Reporting of Wastewater System
Condition
1.0 DEVELOP AND IMPLEMENT THE BUSINESS PROCESS TO LINK EXISTING GIS TEMP
ID TO WASTEWATER PIPE CONDITION DATABASE AND MAXIMO WORK ORDERS
IN ORDER TO PROVIDE CONDITION SCORING TO POPULATE CAPPLAN
1.1 Review GIS/Wastewater Pipe Condition Scoring Interface, Recommend
Enhancements to the Existing Business Process and Facilitate the Implementation.
A. Meet with (71perations, Engineering and Water IT user groups (up to three
meetings) and review existing Business Process, Software limitations and
integratioi �� ievei required.
Assumptions•.
• Prior to the meetings, each user group will submit to FNI the available
information on the existing business process (such as existing data
sharing practices), known integration issues and available
documentation on wastewater pipe condition database software.
FWWD will specify the pipe condition database software being used,
and the software will not change during the implementation process.
• FWWD provides FNI the GIS data for wastewater features having
corrected (unique) TemplDs.
• FWWD provides FNI the pipe condition scoring database with corrected
TemplDs
Expectations:
User groups (Field Operations, Water IT and Engineering) to submit
information listed under "assumptions", attend meetings and review and
provide comments on minutes from each meeting. Management from each
group will assist FNI in determining Fort Worth Water Department (FWWD)
staff needed to attend meetings and workshop.
Deliverable: Meeting minutes will be prepared for each meeting. A summary
of the results of each meeting will be provided for the workshop in Task 2.1B.
EXHIBIT A-1
B. Conduct one workshop with Water IT, Engineering, and Field Operations to
discuss required analysis needs.
Expectations:
Managers and staff involved in the business process from Water IT,
Engineering and Field Operations will attend the workshop.
Deliverable: Summary presentation for the workshop and meeting
minutes/notes following the workshop.
C. Identify connectivity and field naming conflicts between GIS and Wastewater
Pipe Condition Scoring Database.
Assumptions:
• FNI will utilize the Temp ID in the existing GIS geodatabase provided by
the FWWD as linkage between GIS, wastewater model and field
operations condition database sources. The Fort Worth Water
Department will maintain a Temp ID as a unique asset identifier that
will not change for each asset as updates are made to the GIS. If Temp
ID changes are detected, the FWWD will correct the Temp IDs, update
the GIS files and submit the updated files to FNI.
• The Operations user group will provide a list of required fields with the
type of field (i.e. text, integer, double, etc.) within the inspection
software.
Expectations:
FWWD Water IT staff will correct any errors with the existing Temp IDs, if they
are found (as listed under assumptions), and provide updated files to FNI.
D. Review and develop alternatives of handling break nodes in the GIS to
Wastewater Pipe Condition Scoring interface to minimize redundancy and
maintain asset linkage between systems. Assess the impact analysis of each
alternative. Prepare a memorandum on the alternatives for handling break
nodes and their impact and provide a recommendation.
Assumptions:
A custom application will be developed to support break nodes throughout the
risk based scoring process. The custom application will be based on joins,
relates and tables.
Expectations:
FWWD Water IT staff will review proposed options and assist in identifying
fatal flaws.
EXHIBIT A-2
Deliverable: Memorandum on break node alternatives and recommended
option.
E. Develop draft business process technical memorandum on updated workflow
and linkage between GIS and Wastewater Pipe Condition Scoring, entering
existing records, importing/exporting information, etc.
Expectations:
All comments from the FWWD user groups on the draft business process
technical memorandum will be compiled into one document and provided to
FNI.
Deliverable: Draft Technical Memorandum on business process and
implementation plan linking Wastewater Pipe Condition Scoring data to the
GIS
F. Conduct one workshop to deploy updated business process on roles and
implementation responsibilities going forward to maintain linkage between
the Wastewater Pipe Condition database and GIS.
Assumptions•
User groups will review draft business process technical memorandum prior to
the workshop.
Expectations:
Managers and staff involved in the business process from Water IT,
Engineering and Field Operations will attend the workshop.
Deliverable: Meeting minutes from workshop &revised technical
memorandum on business process linking Wastewater Pipe Condition Scoring
data to the GIS
G. Implement recommended business process. Populate the historical
wastewater pipe condition score data field to the wastewater line feature class
in the geodatabase with the existing GIS Temp ID.
Assumptions:
FWWD Field Operations will provide FNI with the latest pipe condition
database. FWWD Water IT will provide FNI with the latest geodatabase.
EXHIBIT A-3
Expectations:
• FNI will import the GIS and pipe condition scoring database into their
own geodatabase.
• FNI will develop a custom application that relates pipe condition
scoring database (without breaks) with the GIS data (with breaks) so
that the pipe condition scores are keyed to every GIS feature.
• Water IT will install the custom application developed in Task 2.11) and
other applicable files on Fort Worth's server.
Deliverable: Updated pipe condition scoring table (electronic), other files or
programs/programming utilized in implementation (custom application)
H. Perform meetings with Field Operations, Engineering and Water IT (up to two
meetings) after two months of usage of updated business process to review
workflow issues and to identify possible changes needed to optimize business
processes.
Assumptions•
FWWD user groups (Water IT, Field Operations & Engineering) will actively use
the business process over a two month period and track issues encountered
over the review period and provide available data to FNI prior to the
workshop.
Expectations•
Applicable staff from FWWD user groups will attend the workshop.
Deliverable: Documentation of meeting minutes
Finalize Business Process Technical Memorandum on GIS to Wastewater Pipe
Condition Database Interface and Linkage.
Expectations:
FWWD staff will assist FNI in implementing any resulting changes to the
business process from Task 2.1H.
Deliverable: Revised business process memo on linking Wastewater Pipe
Condition Scoring data to the GIS
1.2 Review GIS/Work Order Data Interface, Recommend Enhancements to the Existing
Business Process and Facilitate Implementation of the New Business Process.
A. Review Existing Business Process, Software limitations and integration level
required with Field Operations, Engineering and Water IT.
EXHIBIT A-4
Assumptions:
• Each user group will submit to FNI available information on the existing
business process (such as existing data sharing practices), known
integration issues and available documentation on Maximo software.
FWWD Field Operations will provide FNI with the existing work order
process within Maximo.
• FWWD will provide FNI the sewer work order data with addresses from
the year 2005 to present.
Expectations:
User groups (Field Operations, Water IT and Engineering) to submit
information listed under "assumptions", attend meetings and review and
provide comments on minutes from each meeting. Management from each
group will assist FNI in determining FWWD staff needed to attend meetings
and workshop.
Deliverable: Meeting minutes will be prepared for each meeting. A summary
of the results of each meeting will be provided for the workshop in Task 2.213.
B. Conduct one workshop with Water IT, Engineering, and Field Operations to
discuss interim work order linkage and reporting needs before full Maximo
Integration
is Coiid'u�,ted.
Expectations:
Managers and staff involved in the business process from Water IT,
Engineering and Field Operations will attend the workshop.
Deliverable: Summary presentation for the workshop and meeting
minutes/notes following the workshop.
C. Submit technical memorandum on geocoding process, quality
Expectations•
• All comments from the FWWD user groups on the technical
control
memorandum will be compiled into one document and provided to
FNI.
• Comments will be provided on the proposed geocoding process within
one week from submittal of memorandum.
Deliverable: Technical Memorandum on geocoding process
EXHIBIT A-5
D. Geocode historical wastewater system work order data to assign each work
order to an existing wastewater asset using wastewater Temp IDs. Submit
updated work order data to City for review.
Assumptions•
• FNI will import the GIS and wastewater work order database into their
own geodatabase.
• FNI will geocode only historical wastewater work order data from the
year 2005 to present.
• FNI will geocode the Maximo wastewater work order data to an asset.
• FWWD will provide the most recent Maximo wastewater work order
data in a database or similar format.
Expectations:
• FWWD Field Operations will provide FNI with necessary wastewater
work order data.
• FNI will geocode the wastewater work order data provided so that
each work order has a TemplD.
Deliverable: Updated work order (wastewater) database with work orders
assigned to a wastewater asset using the Temp ID.
E. Develop draft business process technical memorandum on updated workflow
and linkage between Water IT and Field Operations to allow each completed
work order to be assigned to a Temp ID and regular reporting back to GIS.
Expectations:
All comments from the FWWD user groups on the draft business process
technical memorandum will be compiled into one document and provided to
FNI.
Deliverable: Draft Technical Memorandum on business process linking work
orders to GIS data
F. Conduct one workshop to deploy updated business process roles and
implementation responsibilities going forward to maintain linkage between
work orders and GIS.
Assumptions•
User groups will review draft business process technical memorandum prior to
the workshop.
Expectations:
Managers and staff involved in the business process from Water IT,
Engineering and Field Operations will attend the workshop.
EXHIBIT A-6
Deliverable: Meeting minutes from workshop & revised technical
memorandum on business process linking work order data to the GIS
G. Implement recommended business process on linking work order data to the
GIS.
Assumptions:
FWWD Field Operations will not close out wastewater system work orders
until work orders are assigned to an asset using the Temp ID.
Expectations:
• FWWD Water IT and Field Operations will update the Maximo database
with the Temp ID using the files provided by FNI. FWWD Field
Operations will input the Temp ID on new work orders generated by
the system.
Deliverable: Electronic GIS files linking work order data to wastewater assets
using the Temp ID.
H. Perform meetings .�,,ith Field Operations, Engineering and �,��ater IT ;up to tvvo
meetings) after two months of usage of updated business process to review
workflow issues and to identify possible changes needed to optimize business
process.
Assumptions:
FWWD user groups (Water IT, Field Operations & Engineering) will actively use
the business process over a two month period and track issues encountered
over the review period and provide available data to FNI prior to the
workshop.
Expectations:
Applicable staff from FWWD user groups will attend the workshop.
Deliverable: Documentation of meeting minutes
Finalize Business Process Technical Memorandums on GIS to Work Order
Interface and Linkage within GIS.
Expectations•
FWWD staff will assist FNI in implementing any resulting changes to the
business process from Task 2.2H.
EXHIBIT A-7
Deliverable: Revised business process memo on linking work order data to the
Is
2.0 INCORPORATE RISK MATRIX INTO CAPPLAN FOR SUSTAINABLE RISK BASED
ASSESSMENT PROGRAM
2.1 Risk -Based Project Implementation
A. The Consultant will upload CapPlan with the risk decision logic and the
available data. Consultant will conduct one workshop to review initial results
of the analysis. Consulting input will be utilized to further refine CapPlan
decision criteria. Consultant will utilize refined CapPlan decision criteria and
conduct a refined pre -design level analysis using MWH Soft CapPlan software
tool.
Deliverable: Meeting minutes from workshop
B. Submit Technical Memorandum on documenting Risk based decision logic.
Deliverable: Technical memorandum on risk based logic loaded into CapPlan
2.2 Risk -Based Assessment Proeram Tool
A, The ('nncaltant Will rinriiment the bi�cinecc rnrnra�� fnr �nntinried City use ^f
the CapPlan software tool to integrate with FWWD annual budgeting and CIP
development process. The business process will include a schedule and
estimated man-hour requirements.
Deliverable: Technical memorandum on business process for utilizing CapPlan
going forward
B. The Consultant will provide aone-day training session for FWWD staff upon
delivery of the decision support tool and a one -day refresher training session
for FWWD staff approximately 3 months after the decision support tool
delivery.
Deliverable: Two days of training and associated training materials
C. Consultant shall submit as a deliverable the Decision -support Tool MWH Soft
CapPlan software modified for selected FWWD model (one floating license).
The CapPlan software will include the criticality (consequence of failure) score
for those assets contained within the core GIS database. The CapPlan
software will also include condition scoring for those assets deemed to have
adequate field inspection data for a pre -design level analysis. Related business
process and training materials.
Expectations•
EXHIBIT A-8
FWWD will implement the CapPlan application, data, and processes on its own
servers and databases.
Deliverable: SewerXL CapPlan software, CapPlan electronic files/databases
D. Consultant will prepare and submit draft Risk -Based Assessment Program Tool
practice manual and submit to City for review. The manual will include input
data, detailed description of the GIS to Risk -Based Assessment Program Tool
translation procedures, Risk -Based Assessment Program Tool file layout, and
basic instructions of the Risk -Based Assessment Tool.
Deliverable: RBA Program Tool Practice Manual
Wastewater Master Plan Additional Services Performed for Flow Monitoring
3.0 SECOND METER REMOVAL &INSTALLATION
In December 2008, the 43 meters in the collection system were removed and
contract time was suspended. These meters were installed for a second time
starting April 15, 2009, to fulfill the remaining 30 days in the contract.
A. Second Meter Removal (43 meters).
B. Second Meter Reinstallation (43 meters).
C. Project Management and Data Review.
EXHIBIT A-9
ATTACHMENT B (Amended)
COMPENSATION AND SCHEDULE
WASTEWATER SYSTEM MASTER PLAN
I. COMPENSATION
A. The ENGINEER shall be compensated at a cost plus with a maximum
fee of $3,333,620 for Basic Services as summarized on Exhibits "B-I"
and "B-2" in the original contract and "B4A" and "'K-A" in this
Amendment. Payment of the fee shall be considered full
compensation for the services described in Exhibit "A -I" for all labor,
materials, supplies and equipment necessary to complete the
project.
/,�■re�il:r �1����t�il
m
F
B
C
C
�
o•
a
�
c
o
£''
'�
�
d
E
o
O�
�.a
'
o
w
`
E
s
c
E
w
.�
o`
d£
o
_5
R
6
E�
o
m
�yacm
b
�ofg
14
19.0.
o-
o
o,
-3
'tl
d
3,
Yr
w
Er
7 pf
:
-
mW
b�
�b
.a
o�m
a�
s
Rc
�aS
go
y
o
d
a
o
bycd
y�
94
ET
m
m
�
rt Ci7
a
a
m
^
�
�
e
�
n
y
O
'b
T
7
to
m
oa
un
xy
'g
7
7
yLM
4 ^
,� m
a
o
y
x
F
n
�.
y.0
5
m
q9
�'
tE0
o
��3�b
3
�f
°
c
E,�
o
,� _•'4°..�.i
no
ore
E5
o
gym;
�F
Ni
V
�
9
0
�
�
�
�
a
0
5
c
mwm
b�
Ln
;..
4
b
�
^C
m N
°
m
m
ee;n
ewm
9
^+ m
K
�
o aooT
w c
rA
Ay
m
�
O.
O
0
m
m
,§
hl m.
KJ m.
n:6
M&C Review
Page 1 of 2
Official site of the City of Fort Worth, Texas
CITY COUNCIL AGENDA
FoR H
COUNCIL ACTION: Approved on 2/9/2010 -Ord. No. 19034-02-2010
REFERENCE ** 60WASTEWATER MASTER
DATE: 2/9/2010 NO : C-24085 LOG NAME: PLAN
CODE: C TYPE: CONSENT PUBLIC NO
HEARING:
SUBJECT: Authorize Amendment No. 1 in the Amount of $346,427.00 to City Secretary Contract No.
37548, an Agreement with Freese and Nichols, Inc., to Update the Wastewater System
Master Plan Citywide and Adopt Appropriation Ordinance
RECOMMENDATION:
It is recommended that the City Council:
1. Authorize the City Manager to transfer $346,427.00 from Water and Sewer Fund to the Sewer
Capital Projects Fund;
2. Adopt the appropriation ordinance increasing estimated receipts and appropriations in the Sewer
Capital Projects Fund in the amount of $346,427.00 from available funds; and
3. Authorize the City Manager to execute Amendment No. 1 to an Agreement with Freese and
Nichols, Inc., City Secretary Contract No. 37548 to update the Wastewater System Master Plan
Citywide, increasing the total fee by $34E,427.00 from $2,987,193.00 to $3,333,520.00.
DISCUSSION:
On August 26, 2008, (M&C C-22997) the City Council authorized the execution of an Agreement with
Freese � Nichols, Inc., to update Wastewater Master Plan for a total fee not to exceed
$2,987,193.00. The original Agreement scope of services included defining the Fort Worth's ultimate
service area by establishing planning area boundaries (PAB), surveying organization within the PAB
to identify constraints and evaluate needs in future wastewater system development. The engineer
will analyze and update the existing wastewater collection system hydraulic model and develop
various scenarios to evaluate and recommend wastewater system improvements to serve
undeveloped and unincorporated areas within the City of Fort Worth. The engineer will base future
wastewater system improvements on future wastewater flows under various development scenarios
fora 20 year planning period. The Wastewater Master Plan will address wastewater system
deficiencies as well as future growth areas. The engineer will develop as part of the study a
wastewater system capital improvements plan with cost estimates and implementation schedule and
identify relevant issues associated with additional wastewater treatment capacity/plant requirements,
including permitting, schedule and cost.
The scope of services for Amendment No. 1 includes three task items. Task item No. 1 is to develop
a business process to link core GIS unique Asset IDs to wastewater pipe condition data and work
orders to enhance the water department's ability to track, report and manage the condition of
wastewater assets. Task item No. 2 is to incorporate condition and criticality risk matrices into the
CapPlan assessment software to provide a sustainable risk planning tool to prioritize replacement
and renewal of the wastewater collection system. Task No. 3 is the additional flow monitoring to
capture the impacts of larger rainfall events from Spring 2009, on the wastewater collection system.
Freese and Nichols, Inc., is in compliance with the City's M/WBE Ordinance by committing to 21
percent M/WBE participation. The City's goal on this project is 21 percent.
This project is CITYWIDE.
http://apps.cfwnet.org/council�acket/mc review.asp?ID=13029&councildate=2/9/2010 3/15/2010
M&C Review
Page 2 of 2
FISCAL INFORMATION/CERTIFICATION:
The Financial Management Services Director certifies that funds will be available in the current
operating budget, as appropriated, of the Water and Sewer Fund and in the capital budget, as
appropriated, in the Sewer Capital Projects Fund.
TO Fund/Account/Centers
1 & 2)
P258 476045 701300115530
2)P258 531200 701300115530
$346,427.00
$346,427.00
Submitted for City Manager's Office by:
Originating Department Head:
Additional Information Contact:
FROM Fund/Account/Centers
1)PE45 538040 0709020
3) P258 531200
701300115530
Fernando Costa (6122)
S. Frank Crumb (8207)
Nowzar Dinyarian (8256)
ATTACHMENTS
60WASTEWATER MASTER PLAN REVISED.doc
$346,427.00
$346,427.00
http://apps. cfwnet.org/council�acket/mc_review. asp?ID=13 029&councildate=2/9/2010
3/15/2010