HomeMy WebLinkAboutContract 48301-A2 CSC No.48301-A2
SECOND AMENDMENT TO
FORT WORTH CITY SECRETARY CONTRACT NO. 48301
This Second Amendment is made between the City of Fort Worth("FORT WORTH"), a
municipal corporation, acting herein by and through Dana Burghdoff, its duly authorized
Assistant City Manager and("Aqua Metric Sales Company"), a registered d/b/a of Thirkettle
Corporation, a California Corporation("Consultant or Contractor") acting herein through
Tommy Thirkettle, its duly authorized President.
RECITALS:
WHEREAS, FORT WORTH and Contractor entered into an Agreement identified as Fort
Worth City Secretary Contract No. 48301 (the "Contract") for a period of five (5)years
beginning October 14, 2016 to expire no later than March 31, 2021; and
WHEREAS, it is the collective desire of both FORT WORTH and the Contractor to
execute this Second Agreement to amend the Scope of Work to modify the program as depicted
in Attachment A for continued program support based on the current demonstrated successful
performance of the Contractor; and
WHEREAS, the Parties agree that due to the collaborative nature of the AMI Program,
certain changes are necessary to complete the AMI Program and effectuate the Contract;
AND WHEREAS, the Parties have been authorized to now agree to memorialize in this
Amendment No. 2 to the Contract. The changes the City and Contractor intend to include are
attached hereto as Attachment A,Attachment B and Attachment C,which are hereby attached
hereto and incorporated herein.
AGREEMENTS:
NOW THEREFORE, KNOWN ALL BY THESE PRESENT:
This Second Amendment shall commence upon the date of complete execution("Effective
Date") and not expire no later than March 31, 2021.
1. Memorializing the Parties intent to amend the agreement for program changes in
accordance with Attachment A,this Second Amendment to Fort Worth City Secretary Contract
No. 48301, which amends Exhibit A, Statement of Work and Exhibit B accordingly; and
2. Amend the Exhibit A- Statement of Work in accordance with Attachment A.
3. Amend the Exhibit B - Budget, in accordance with the Attachment B.
4. Amend the Exhibit A—Program Schedule, in accordance with the Attachment C.
5. Amend the Exhibit C -Major Milestones, in accordance with the Attachment D.
Second Amendment to Fort Worth City Secretary Contract No.48301 OFFICIAL RECORD
CITW ARY
FT. WORTH,T
6. The Recitals above are incorporated herein for all purposes.
All other terms,provisions, conditions, covenants and recitals of said Agreement not expressly
amended herein shall remain in full force and effect.
[THE REMAINDER OF THIS PAGE INTENTIONALLY LEFT BLANK]
Second Amendment to Fort Worth City Secretary Contract No.48301
Page 2 of 17
APPROVED FOR APPROVED FOR
CITY OF FORT WORTH:
AQUA METRIC SALES COMPANY,A
REGISTERED D/B/A,THIRKETTLE
CORPORATION
By: By:
Dana Burghdoff Tommy Thirkettle
Assistant City Manager President
Date:May 8,2020 Date: 04/24/2020
Gh nhnr ffardnr
Chris Harder,P.E.
Department Director
Date: May 6,2020
APPROVED AS TO FORM
AND LEGALITY:
By: �-.,,-
J.B. Strong
Assistant City Attorney II
ATTEST:
Mary J. Kayser :
City Secretary `
A
Contract Authorization:
M&C:No M&C Required
®Le ,
CITY SECRETARY
Second Amendment to Fort Worth City Secretary Contract No.48301 FT. WOPT4—-'y
Page 3 of 17
CONTRACT COMPLIANCE MANAGER:
By signing, I acknowledge that I am the person responsible
for the monitoring and administration of this contract, including
ensuring all performance and reporting requirements.
Madelene Rafalko(May 5, 020)
Madelene Rafalko,P.E.
MyH2O Program Manager
F
ECORD:%,;
ETARY`'H, T
Second Amendment to Fort Worth City Secretary Contract No.48301
Page 4 of 17
"ATTACHMENT A—Amendment to Exhibit A- Statement of Work"
SECOND AMENDMENT TO
FORT WORTH CITY SECRETARY CONTRACT NO. 48301
Proposed Contract Modification Requests (PCMR) were administratively approved and shall be
incorporated formally into this Amendment No. 2 to City Secretary Contract Number 48301.
1. Modifications related to the AMI Network:The AMI Network consists of 30 sites
strategically located across the service area to capture individual water meter usage data
through wireless transmissions. The process of siting, licensing, permitting and installing the
necessary equipment in a rapidly changing market required flexibility and focus. The end
result is a stable communication network for the Fort Worth water utility that adequately
covers the service area to enable remote reads of nearly all water meters. The original
contract budget was overly conservative and did not include all of the services required to
develop documents to permit the equipment installation in the City of Fort Worth. The
following items are the changes needed to complete the AMI Network:
1.1. PCMR01 and PCMR04: Load Studies: Aqua Metric procured structural engineering
services on behalf of the city to produce load studies for nine (9) city-owned and (18)
leased network sites. The load studies provided necessary documentation required for
the City's permit of AMI Network installation and ensured the existing towers could
safely support the additional equipment.
1.2. PCMR02: Civil Drawings for Antenna Installations: Aqua Metric procured civil
engineering services on behalf of the city to produce site surveys. The site surveys
provided necessary documentation required for the City's permit of AMI Network
installation.
1.3. PCMR03: Electrical Drawings for Permits: Aqua Metric procured professional services
on behalf of the city to produce electrical design drawings. The electrical design
documents provided necessary documentation required for the City's permit of AMI
Network installation.
1.4. PCMR05: ATC Lease Sites:The City requested the Contractor alter the original project
phasing and proceed with full city-wide AMI network installation. The rapidly changing
market forces along with the need to have a comprehensive network solution
necessitated the change. To deploy the AMI Network,Aqua Metric executed licenses/
leases with American Tower Corporation for 19 sites, facilitating full deployment of the
AMI Network. This decision to secure all the AMI Network sites earlier than planned
was made to manage the risks associated with losing key locations.
Second Amendment to Fort Worth City Secretary Contract No.48301
Page 5 of 17
1.5. PCMR07, PCMR08, PCMR09 and PCMR10 Additional Tower Sites: Added
communication sites and equipment for appropriate coverage of the full city-wide AMI
network.
2. Software and Professional Services: The AMI Solution originally proposed by Aqua Metric
included budget for some software and professional services in excess of actual needs in
some areas and short in others. The following items summarize the budget balancing of
these services.
2.1. Regional Network Interface:The RNI SaaS fees were originally budgeted to be paid out
of the capital project. These costs were classified as operating in nature and as a result
the contract was assigned to the city and paid from the city's operating budget. This
amendment reallocates the remaining budget balance to offset other costs within the
project.
2.2. Harris Software Licenses:The City purchased the software licenses for the Harris
MDMS and is working towards the MDMS implementation. However, the proposed
portal did not meet the City's long-term customer engagement requirements (PCMR13)
and the city opted to pursue a different portal solution. This amendment reallocates
the unused budget for the Harris customer portal to offset other costs within the
project.
2.3. SEW Customer Portal: The City determined the SEW Customer portal meets the long-
term customer engagement requirements. Therefore,the City and Aqua Metric
approved PCMR25 which allows Aqua Metric to procure the SEW software and
implementation services on behalf of the City. Aqua Metric assigned the SEW contracts
over to the City.
2.4. Utiliworks Professional Services: A portion of the Utiliworks professional services was
deleted from the scope of work (PCMR11). This amendment reallocates the unused
budget to offset other costs within the project.
2.5. MuleSoft Integration:The City has identified MuleSoft software as an integration
platform to meet the City's MyH2O Program requirements. Therefore,the City and
Aqua Metric approved PCMR26 allowing Aqua Metric to procure the MuleSoft software
and implementation services on behalf of the City. Aqua Metric assigned the MuleSoft
contracts over to the City.
2.6. Tenon: The City has determined a need for some preliminary data management
professional services to assist staff with the increasing amount of water usage, billing
and other data. The City and Aqua Metric approved PCMR24 securing Tenon services
on behalf of the City. Aqua Metric assigned the Tenon contracts over to the City.
Second Amendment to Fort Worth City Secretary Contract No.48301
Page 6 of 17
3. Meters and Smartpoints:
3.1. Omni Meter 1-1/2"and 2" (PCMR15):The initial contract included procurement of
Omni R2 meters for locations with either 1 %" or 2" service. The Omni R2 meter is
designed for large residential applications and therefore has lower accuracy when
measuring high flow consumption. The City requested a change from Omni R2 to Omni
C2 and Omni T2 type meters. Fort Worth intends to deploy the Omni C2 for all "water
account" services and the Omni T2 for all "irrigation" services. The Omni C2 and T2
(designed for commercial applications) support a higher flow rate metering compared
to the Omni R2. In addition,the Omni C2 and T2 include additional features like data
logging, pulse output, etc. The unit cost of the Omni C2 and T2 is higher. The
quantities required have been offset due to ongoing large meter exchange work in a
separate contract and updated billing/account information. The net change of the
meter type, unit cost and quantity is listed in the table below:
Quantity Quantity Exhibit B Budget
Meter Unit Cost (Original) (Revised) (Amendment#2)
1 1/2"OMNI R2 TR/PL C.F. $340.95 4,085 0 -$1,428,239.55
1 1/2"OMNI C2 TR/PL C.F. $759.53 0 2,718 $2,064,402.54
1 1/2"OMNI T2 TR/PL C.F. $519.79 0 627 $325,908.33
2"OMNI R2 TR/PL C.F. $478.38 1 7,033 1 0 1 -$3,539,533.62
2"OMNI C2 TR/PL C.F. $876.38 0 4,040 $3,540,575.20
2"OMNI T2 TR/PL C.F. $616.54 0 1,844 $1,136,899.76
3.2. Omni Meters Greater Than 2 Inches (PCMR16): The initial contract included
procurement of Omni C2 meters for locations with meters larger than 2-inch. The City
requested a change to add Omni T2 meters in order to capture the high flow rate
patterns and to offer the additional features available on these meters to interested
customers. Fort Worth intends to deploy the Omni C2 for all "water account" services
and the Omni T2 for all "irrigation" services. The unit cost of the Omni T2 is lower. The
quantities required have been offset due to ongoing large meter exchange work in a
separate contract and updated billing/account information. The net change of the
meter type, unit cost and quantity is listed in the table below:
Quantity Quantity Exhibit B Budget
Meter Unit Cost (Original) (Revised) (Amendment#2)
3"OMNI C2 TR/PL C.F. $1,136.82 56 93 $105,724.26
3"OMNI T2 TR/PL C.F. $768.31 0 6 $4,609.86
4"OMNI C2 TR/PL C.F. $1,974.47 224 155 $306,042.85
4"OMNI T2 TR/PL C.F. $1,495.72 0 10 $14,957.20
6"OMNI C2 TR/PL C.F. $3,330.20 240 258 $859,191.60
Second Amendment to Fort Worth City Secretary Contract No.48301
Page 7 of 17
6"OMNI T2 TR/PL C.F. $2,620.05 0 10 $26,200.50
8"OMNI C2 TR/PL C.F. $5,645.36 77 102 $575,826.72
8"OMNI T2 TR/PL C.F. $4,668.71 0 2 $9,337.42
10"OMNI C2 TR/PL C.F. $7,375.39 25 23 $169,633.97
10"OMNI T2 TR/PL C.F. $6,117.26 1 0 1 0 1 $0.00
3.3.Adjust Meter Counts(PCMR29):To offset budget increases described herein and to
ensure the costs of the AMI Program are covered fully by the SWIFT loan amount, the
City and Aqua Metric agree to reduce the meter and endpoint budget as described
herein. The City intends to exchange 100% of the existing meters in the system with
Aqua Metric, using the Sensus meters for a complete and functional system. In the
event additional meters and endpoints are needed to complete the project, the City
will allocate the additional funding necessary. The City and Aqua Metric will work
together in good faith to execute a suitable contract format at that time to procure and
install the required meters, and any additional services related to the AMI system from
Aqua Metric.
Unit Reduction in Exhibit B Budget
Meter Cost Quantity (Amendment#2)
5/8"x 3/4"SRII TR/PL C.F. $75.29 -18,796 -$1,415,150.84
3/4"S SRII TR/PL C.F. $106.10 -41 -$4,350.10
1"SRII TR/PL C.F. $173.17 -2,415 -$418,205.55
1 1/2"OMNI C2 TR/PL C.F. $759.53 -413 -$313,685.89
1 1/2"OMNI T2 TR/PL C.F. $519.79 -76 -$39,504.04
2"OMNI C2 TR/PL C.F. $876.38 -457 -$400,505.66
2"OMNI T2 TR/PL C.F. $616.54 -230 -$141,804.20
MXU 520M SmartPoint Single Port $84.81 -21,727 -$1,842,666.87
MXU 520M SmartPoint Dual Port $104.48 -1,539 -$160,794.72
Total Exhibit B Adjustment I -$4,736,667.87
Second Amendment to Fort Worth City Secretary Contract No.48301
Page 8 of 17
4. Installation:
4.1. Product Warehousing(PCMR06):The Contractor requested an increase in the program
budget for leasing a warehouse in Fort Worth. The rapidly changing real estate market
resulted in an extremely competitive market. The City and Aqua Metric agreed to
increase the monthly budget for the warehouse and, both parties agreed the
warehouse would be necessary for a longer duration than the original forecast.
4.2. Plugs for Drilling Holes-Meter Box Lids(PCMR14 and 14A): The meter exchange
process consists of two site visits that may be eight weeks apart. The first step includes
the drilling of a hole in the meter box lid. This results in a two-inch hole that may allow
debris to fall in and the existence of the open hole may present a hazard to
pedestrians. The Contractor will provide a cap for the holes until the meter
smart/endpoint equipment can be installed.
4.3. Meter Box Prep for Full Program Implementation (PCMR19): The meter box
preparation services consist of removing dirt, pests and debris from the existing meter
box and drilling a hole into the meter lid to eventually receive the radio endpoint
during the meter exchange process. The price increase for this effort is to address
increases in the cost of labor since the original budget was developed in 2016.
4.4. Residential Direct Connect for Full Program Implementation (PCMR20): During the
Initial Deployment phase, Aqua Metric encountered locations where customer service
was directly connected to the City's meter (that is, without a fitting that would allow
the installer to disconnect the meter from the customer service piping). To facilitate
the meter exchange, Aqua Metric will handle this pre-existing issue by providing
additional services to work the location, exchange the meter and install a coupling in
accordance with Fort Worth standards. The cost for this work per location is $205.00
(materials and labor). Based on forecasts, this affects approximately 1000 locations.
4.5. Flange Kit Install for Full Program Implementation (PCMR21): During the Initial
Deployment phase, Aqua Metric encountered locations where services were connected
to meters over 1-1/2-inch in diameter with a threaded connection. The Omni meter
requires a flanged meter connection. To complete the meter exchange,Aqua Metric
will address this pre-existing issue by providing additional services to install flange kits.
The cost to install flange kits is$475.00 (materials and labor)for each location. Based
on forecasts, approximately 500 flange kit installations will be needed.
4.6. Meter Box Reset for Full Program Implementation (PCMR22): During the Initial
Deployment phase, Aqua Metric encountered locations where meter connections were
inaccessible through the normal meter box opening. To access the meter connections,
Aqua Metric's installers must temporarily remove the meter box. The cost to perform
the meter box reset is $30.00 per location. Based on forecasts, this affects
approximately 10,000 locations.
Second Amendment to Fort Worth City Secretary Contract No.48301
Page 9 of 17
4.7. Meter Lid/Box Replacement (PCMR26): During the Initial Deployment phase,Aqua
Metric encountered locations where meter box lids and/or boxes needed to be
installed or replaced. To complete the project,Aqua Metric will procure both meter
lids and meter boxes to be used at the locations where boxes and/or lids are missing or
require replacement. This amendment gives Aqua Metric the approval to purchase
meter boxes and lids that conform to the Fort Worth standard products.
5. Leak Detection (PCMR12):The solution proposed by the Contractor was rejected by the
City. The replacement of existing leak detection equipment shall be completed through the
operating division's budget under a separate contract. This amendment reallocates the
remaining budget balance to offset other costs within the project.
Second Amendment to Fort Worth City Secretary Contract No.48301
Page 10 of 17
"ATTACHMENT B-Amendment to Exhibit B- Budget"
SECOND AMENDMENT TO
FORT WORTH CITY SECRETARY CONTRACT NO. 48301
Approved Contract
Budget Amendment#2 Revised
(Contract+ Units Reallocation Exhibit
Category/Subcategory Unit Cost Amendment Ri) (revised) Amount Explanation Budget(Total)
INF Infrastructure $2,406,722.90 $726,539.99 See Attachment A section 1 $3,133,262.79
AMI Network $1,356,722.80 32 $576,539.99 $1,933,262.79
Aqua Metric Project Management $200,000.00 $1,050,000.00 6 $150,000.00 $1,200,000.00
RNI Regional Network Interface $329,282.97 -$78,058.17 See Attachment A section 2.1 $251,224.80
HAR Harris Software License $1,460,400.00 -$640,519.65 See Attachment A section 2.3 $919,880.35
UWS Utiliworks $1,084,288.21 -$572,197.34 See Attachment A section 2.4 $512,090.87
SEW SEW Customer Portal $0.00 $1,518,464.80 See Attachment A section 2.3 $1,518,464.80
MUL MuleSoft Integration PaaS $0.00 $1,625,578.19 See Attachment A section 2.5 $1,625,578.19
TEN TENON Data Warehouse Software $0.00 $215,000.00 See Attachment A section 2.6 $215,000.00
MTR Meters&SmartPoints $48,790,478.61 -$3,933,702.22 See Attachment A section 3 $44,856,776.39
MTR 5/8"x 3/4"SRII TR/PL C.F. $75.29 $15,869,325.04 170,083 -$3,063,775.97 $12,805,549.07
MTR 3/4"S SRII TR/PL C.F. $106.10 $65,994.20 758 $14,429.60 $80,423.80
MTR 1"SRII TR/PL C.F. $173.17 $4,387,954.63 20,363 -$861,693.92 $3,526,260.71
MTR 11/2"OMNI R2 TR/PL C.F. $340.95 $1,428,239.55 0 -$1,428,239.55 $0.00
MTR 11/2"OMNI C2 TR/PL C.F. $759.531 $0.00 2,718 $2,064,402.54 $2,064,402.54
MTR 11/2"OMNI T2 TR/PL C.F. $519.79 $0.00 627 $325,908.33 $325,908.33
MTR 2"OMNI R2 TR/PL C.F. $478.38 $3,539,533.62 0 -$3,539,533.62 $0.00
MTR 2"OMNI C2 TR/PL C.F. $876.38 $0.00 4,040 $3,540,575.20 $3,540,575.20
MTR 2"OMNI T2 TR/PL C.F. $616.54 $0.00 1,844 $1,136,899.76 $1,136,899.76
MTR 3"OMNI C2 TR/PL C.F. $1,136.82 $107,997.90 93 -$2,273.64 $105,724.26
MTR 3"OMNI T2 TR/PL C.F. $768.31 $0.00 6 $4,609.86 $4,609.86
MTR 4"OMNI C2 TR/PL C.F. $1,974.47 $513,362.20 155 -$207,319.35 $306,042.85
MTR 4"OMNI T2 TR/PL C.F. $1,495.72 $0.00 10 $14,957.20 $14,957.20
MTR 6"OMNI C2TR/PLC.F. $3,330.20 $965,036.80 258 -$105,845.20 $859,191.60
MTR 6"OMNI T2 TR/PL C.F. $2,620.05 $0.00 10 $26,200.50 $26,200.50
MTR 8"OMNI C2 TR/PL C.F. $5,645.36 $519,087.24 102 $56,739.48 $575,826.72
MTR 8"OMNI T2 TR/PL C.F. $4,668.71 $0.00 2 $9,337.42 $9,337.42
MTR 10"OMNI C2 TR/PL C.F. $7,375.39 $191,760.14 23 -$22,126.17 $169,633.97
MTR 10"OMNI T2 TR/PL C.F. $6,117.26 $0.00 0 $0.00 $0.00
MTR MXU 520M SmartPoint Single Port $84.81 $19,582,956.25 204,572 -$2,233,204.93 $17,349,751.32
MTR MXU 520M SmartPoint Dual Port $104.48 $1,619,231.04 17,161 $173,750.24 $1,792,981.28
MTR iQor Meter Lid Plugs $3.25 $0.00 50,000 $162,500.00 $162,500.00
INS Installation $13,976,470.64 $94,853.10 See Attachment A section 4 $14,071,323.74
INS Meter Box Lids(seed stock) $348,920.00 $0.00 $348,920.00
INS 5/8"x 3/4"SRII TR/PL C.F. $35.00 $7,440,860.00 170,841 -$1,461,425.00 $5,979,435.00
INS 1"Meter&SmartPoint Installation and Activation $35.001 $886,865.00 20,363 -$174,160.00 $712,705.00
INS Residential Clean Meter Box $3.06 $699,739.38 4,179 -$686,951.64 $12,787.74
INS Residential Clean Meter Box(adjusted 11/1/2019) $4.50 $0.00 200,433 $901,948.50 $901,948.50
INS Drill Lid $9.33 $2,219,653.65 238,961 $9,852.48 $2,229,506.13
INS 11/2"Meter&SmartPoint Installation and Activation $192.92 $764,963.43 3,345 -$119,646.03 $645,317.40
INS 2"Meter&SmartPoint Installation and Activation $216.45 $1,527,174.74 5,884 -$253,582.94 $1,273,591.80
INS 3"Meter&SmartPoint Installation and Activation $433.84 $39,978.32 99 $2,971.84 $42,950.16
INS 4"Meter&SmartPoint Installation and Activation $541.41 $131,490.76 165 -$42,158.11 $89,332.65
INS 6"Meter&SmartPoint Installation and Activation $770.34 $204,350.16 268 $2,100.96 $206,451.12
INS 8"Meter&SmartPoint Installation and Activation $1,063.61 $90,389.57 104 $20,225.87 $110,615.44
INS 10"Meter&SmartPOint Installation and Activation $1,579.55 $37,090.80 23 -$761.15 $36,329.65
INS SmartPoint Activation Only $43.75 $7,918.75 37,869 $1,648,850.00 $1,656,768.75
INS Scrap meter Value -$935,482.80 $0.00 -$935,482.80
INS Product Staging(Monthly) $12,669.12 $512,558.88 60 $247,588.32 $760,147.20
INS Installation Labor&Materials Incidentals $243,609.55 $992,490.00 See Attachment A section 4 $992,490.00
INS Flange Kits installs(labor&materials) $475.00 $0.00 500 $237,500.00 $237,500.00
INS Reset or Replace Meter Box $30.00 $0.00 10,000 $300,000.00 $300,000.00
INS Direct Connect(Residential)labor&materials $205.00 $0.00 1,000 $205,000.00 $205,000.00
INS Special Job Hours $83.33 $0.00 3,000 $249,990.00 $249,990.00
LDS Leak Detection Equipment $816,542.24 -$816,542.24 See Attachment A section 5 $0.00
Performance&Payment Bond $606,832.46 $749.45 $607,581.91
Contingency $126,803.031 $867,344.09 $994,147.12
Total $69,841,430.511 $0.001 $69,597,820.96
Second Amendment to Fort Worth City Secretary Contract No.48301
Page 11 of 17
"ATTACHMENT C—Amendment to Exhibit A-Project Schedule"
SECOND AMENDMENT TO
FORT WORTH CITY SECRETARY CONTRACT NO. 48301
Apr Jul Oct Jim Apr Jul Oct J n Apr Jul Oct Jan Apr Jul Oct J4 m Apr Jul Oct Jar Apr Jul
Ji kn 2017 2017 2017 2C18 2018 2018 2018 2C19 2019 2019 2019 2C20 2020 2020 2020 2021 2021 2021 2021 2 22 2022 2022 S
Contracts 2 17 2t
Sens us
Harris
Mulesott
SEW
Tenon
Design
UtifiWorks-Bus.Proc.
Fort Worth-Bus.Proc.
AM Network
Propagation Study
ATC Lease Agreements
Structurals,permits,etc.
RNI Install
Base Stations-Pilot
Base Stations-Full
MDMS Implementation
Setup and Kickoff
Daily Sync Integration
Configure 0
Billing Integration
Initial Deployment
Deployment Planning
Warehouse Setup
Endpoint Procurement
Meter Swap Integration _
NovusCenter Setup
Meter Box Prep
Meter Exchanges
Full Deployment
Apr Jul Oct Jan Apr Jul Oct Jan Apr Jul Oct Jan Apr Jul Oct Jan Apr Jul Oct Jan Apr Jul
Jan 2017 2017 2017 2018 2018 2018 2018 2019 2019 2019 2019 2020 2020 2020 2020 2021 2021 2021 2021 2022 2022 2022 S
2017 21
Second Amendment to Fort Worth City Secretary Contract No.48301
Page 12 of 17
"ATTACHMENT D—Amendment to Exhibit C - Major Milestones"
SECOND AMENDMENT TO
FORT WORTH CITY SECRETARY CONTRACT NO. 48301
Category Milestone Deliverable Status Date Notes
Sensus AMI Network Propagation Study document includes the following: Complete Oct-18
Assumptions
Identification AMI Network Sites
Covered Endpoints(forecasts)
Not Covered Endpoints(forecasts)
AMI -Network Resilency
Network AMI Network Design Read Rate(forecast)
Licenses 3rd party engineer structural analysis confirms site structure will not be Complete Varies
Structural Analysis compromised with installation of MyH2O AMI Network equipment by site Added with PCMR04
Aqua Metric entered into 20lease agreements with 3rd parties(19 American Complete Varies
Tower Corp.and 1 Benbrook Water Authority)on behalf of FWWD.The lease by site
3rd Party Tower Site agreements were assigned to the City of Fort Worth after completion of Added with PCMR05 and
Lease Agreements installation PCMR09
Base Station Upon installation of each AMI Network site,Sensus performs base station Complete Varies
Certification certification.This has been completed for 30 sites. by site
Upon installation of each AMI Network site,Sensus performs base station Not TBD
certification.2 sites remain outstanding-Stagecoach and Walsh Ranch. Pending Started
Base Station Fort Worth's initiative to construct communication towers at those sites.
Certification Added with PCMR10
Aqua Metric will conduct a series of workshops to collaborate with Fort Worth Complete Feb-18
Business stakeholders on current state business processes. Coming out of the workshops,
Process Current State Business Aqua Metric will document Fort Worth's current state business processes.
Design Processes
Aqua Metric will conduct a series of workshops to collaborate with Fort Worth Complete Jul-18
Future State Business stakeholders on future state business processes.Coming out of the workshops,
Processes(1st Pass) Aqua Metric will create the initial version of the expected future state business
processes for Fort Worth.
Aqua Metric will conduct a 2nd series of workshops to collaborate with Fort Removed N/A
Future State Business Worth stakeholders on future state business processes.Coming out of the from scope
Processes(2nd Pass) workshops,Aqua Metric will deliver the 2nd version of the expected future state Removed from scope with
business processes for Fort Worth. PCMR31
Aqua Metric will deliver Future State Business Processes(Final). Note:The 3rd Removed N/A
pass of Future State Business Processes will occur in Phase 2 Pilot. from scope
Future State Business
Contents include:
Processes(Final) Future State Business Process Flows(final)
Requirements Document Removed from scope with
-Use Cases PCMR31
After 3rd series of workshops the proposed AMI Options Selected will be Removed N/A
memorialized in a document for review by staff and to be presented to Assistant from scope
AMI Options Selection Water Director and Water Director and possibly Assistant City Manager for
Design Acceptance Milestone(This should kick other deliverables off;need to Removed from scope with
define what they are). PCMR31
Using the Business Process Design,synchronize the design of the AMI Solution Removed N/A
with Business Process Design whereby the proposed design supports and builds from scope
upon the future state process flows.The deliverable will delineate between
standard and non-standard technical features with plans to address non-
Synchronize Business standard technical features.
Process Design and AMI
Solution Design Contents include:
Proposed AMI Solution Design
Conceptual Integration Design supporting Business Process Design
Future State Business Process(from Business Process Design)
•Standard Feature supporting business process Removed from scope with
•Non-standard Feature supporting business process PCMR31
Second Amendment to Fort Worth City Secretary Contract No.48301
Page 13 of 17
Category Milestone Deliverable Status Date Notes
The Aqua Metric team will develop and deliver business process training. Removed N/A
from scope
Business Process Contents include:
Training •Business Process Training Plan
•Business Process Training Documentation Removed from scope with
•Training attendance records PCMR31
The Aqua Metric team will conduct business process audits to measure the Removed N/A
Business Process Audit effectiveness of the business process training and expected future state.The from scope Removed from scope with
deliverable is the audit findings. PCMR31
AMI Solution Design Finalize the overall AMI Solution design diagram. Identify all the system In Progress Aug-20
integrations to the AMI Solution.
•Public Awareness Campaign Plan Complete Apr-18
-Goals,objectives and strategy
Public Awareness -PAC Evaluation Process and Metrics
Campaign Plan PAC communication plan
PAC communication content Removed from scope with
Define PAC Status Reports PCMR31
Aqua Metric will collaborate with Fort Worth stakeholders to develop AMI Goals Removed N/A
and Benefits scorecard. from scope
Define AMI Goals and AMI Goals and Benefits
Benefits AMI Program Goals
AMI Business Case Removed from scope with
Benefits Verification Scorecard PCMR31
Benefits Verification This is a ongoing quarterly deliverable that begins in Pilot once both parties Removed N/A
Scorecard(quarterly agree that we have deployed enough meters to begin Benefits Verification. from scope Removed from scope with
update) PCMR31
Benefits Verification Benefits Verification Scorecard(Final) Removed N/A Removed from scope with
Measurement(Final) from scope PCMR31
AMI Meter Swap Integration Aqua Metric will collaborate with Fort Worth IT and their CIS software vendor to Complete Jun-19
Software Design create Meter Swap Interace document.
Imple.
MDMS Workshops Aqua Metric will conduct MDMS workshops to kick off the MDMS configuration Complete Oct-19
and integration efforts
MDMS Daily Sync Aqua Metric will deliver MDMS Daily Sync Interface document. Complete Jan-18
Integration
MDMS Billing Aqua Metric will deliver MDMS Billing Interface document.The assumption is In Progress Jun-20
Integration the MDMS Billing Interface will utilize MVRS flileformat.
MDMS Configuration Aqua Metric will deliver MDMS Configuration Requirements document In Progress Apr-20
Requirements
Document
For software solution that Aqua Metric will implement,Aqua Metric will work Partially Jul-20 Completed for the
with Fort Worth stakeholders to develop AMI Solution Acceptance Test criteria. Complete. following:
Meter Swap Integration
Define AMI Solution •AMI Solution Acceptance Test Sensus Field Logic
Acceptance Test Test Plan Sensus RNl
Test Cases
-Test Results Pending:
-Harris MDMS
MDMS Training Aqua Metric will conduct NovusCenter training sessions with Fort Worth Not Aug-20
stakeholders. Started
NovusCenter Training Aqua Metric will conduct NovusCenter training sessions with Fort Worth Complete Jul-19
stakeholders.
FlexNet RNI Training Aqua Metric will conduct NovusCenter training sessions with Fort Worth Complete Apr-19
stakeholders.
FieldLogic Training Aqua Metric will conduct NovusCenter training sessions with Fort Worth Complete Apr-19
stakeholders.
With collaboration from Fort Worth stakeholders,Aqua Metric will procure Complete Dec-19
Customer Portal software and implementation services from SEW.Aqua Metric will assign the
Procurement contracts to Fort Worth. Fort Worth IT will work directly with the SEW team to added to scope with
implement the SEW software. PCMR23
With collaboration from Fort Worth stakeholders,Aqua Metric will procure Complete Nov-19
Enterpise Service Bus software and implementation services from Mulesoft.Aqua Metric will assign
Procurement the contracts to Fort Worth. Fort Worth IT will work directly with the Mulesoft added to scope with
team to implement the Mulesoft software. PCMR24
Second Amendment to Fort Worth City Secretary Contract No.48301
Page 14 of 17
Category Milestone Deliverable Status Date
Data Management With collaboration from Fort Worth stakeholders,Aqua Metric will procure Complete Date of
Professional Services software and implementation services from Tenon.Aqua Metric will assign the this
Procurement contracts to Fort Worth. Fort Worth IT will work directly with the Tenon team to Amend- added to scope with
implement the Tenon software. ment#2 PCMR25
Prior to procurement,Aqua Metric will work with Fort Worth stakeholders to Complete Jan-18
Deployment Meter Profiles define meter profiles.The meter profiles will be used for the procurement of
meters/radios.The meter profiles will also be setup in Field Logic for purposes
of programming registers and smartpoints.
•Meter Installation Plan Complete Jun-19
Meter deployment plan
Meter purchasing and inventory control procedures
Meter install checklist(residential&commercial)
Meter Installation Plan Detailed procedures for meter installation and post installation
(Pilot) Detailed procedures for meter installation skips/exceptions
Definition of meter installation data requirements:
•Meter inventory file
•Meter swap request file(from FWWD)
•Meter swap response file
•Meter installation exception/skip report
•Meter Installation Plan In Progress May-20
Meter deployment plan
Meter purchasing and inventory control procedures
Meter install checklist(residential&commercial)
Meter Installation Plan Detailed procedures for meter installation and post installation
(Full Deployment) Detailed procedures for meter installation skips/exceptions
Definition of meter installation data requirements:
•Meter inventory file
•Meter swap request file(from FWWD)
•Meter swap response file
•Meter installation exception/skip report
•AMI Program Cleanup Checklist Not Dec-20
-Description of outstanding item Started
Description of plan to resolve item
AMI Program Cleanup Target resolution date
Checklist Owner
Status—Pending,In Progress,Complete
-Status Update
AMI Program Cleanup Completion of the AMI Program Cleanup Checklist Not Jul-21
Completion I Started
Second Amendment to Fort Worth City Secretary Contract No.48301
Page 15 of 17
Second Amendment to Fort Worth City Secretary Contract No.48301
Page 16 of 17
Second Amendment to Fort Worth City Secretary Contract No.48301
Page 17 of 17