Loading...
HomeMy WebLinkAboutContract 48301-A3 CSC No. 48301-A3 THIRD AMENDMENT TO FORT WORTH CITY SECRETARY CONTRACT NO. 48301 This Third 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. WHEREAS,FORT WORTH and Contractor entered into an Agreement identified as Fort Worth City Secretary Contract No.48301,executed on October 14,2016("the Agreement"); 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,it is the collective desire of both FORT WORTH and the Contractor to amend the Agreement to make certain changes in the contract to complete the AMI Program and effectuate the Contract,including increasing compensation in the Agreement by an amount not to exceed $3,639,531.00. NOW THEREFORE,known by all these present,Fort Worth and Vendor,acting herein by the through their duly authorized representatives,agree to the following terms,which amend the Agreement as follows: I. Amend Section 2, Term, of the Agreement as necessary to extend the Expiration Date to July 31, 2022. 2. Section 3,Compensation,of the Agreement is hereby deleted and replaced in its entirety with the following: City shall pay Contractor a total combined amount not to exceed$73,480,962.00 for the Services included under the Agreement. Contractor shall not perform any additional services for City not specified by this Amendment unless City requests and approves in writing the additional costs for such services. City shall not be liable for any additional expenses of Contractor not specified by this Amendment unless City first approves such expenses in writing. City agrees to pay all invoices of Contractor within thirty(30)days of receipt of such invoice. 3. Amend Exhibit A, Statement of Work,in accordance with: a. Attachment A-1 Proposed Contract Modifications b. Attachment A-2 Program Schedule c. Attachment A-3 Close Out Task List 4. Amend the Exhibit B,Budget,in accordance with Attachment B-1. 5. Amend Exhibit C,Major Milestones,in accordance with Attachment C-1. 6. All other terms,provisions,conditions,covenants and recitals of the Agreement not expressly amended herein shall remain in full force and effect. [Signature Page Follows] OFFICIAL RECORD CITY SECRETARY FT. WORTH, TX Third Amendment to Fort Worth City Secretary Contract No.48301 Page 1 of 13 Executed effective as of the date signed by the Assistant City Manager below. City: Vendor: Dana L4(( doff By: Dana Burghdoff(Jep 20,2021 09:22 CDT) By: Tommy Thick e(Sep 16,202111:37 PDT) Name: Dana Burghoff Name: Tommy Thirkettle Title: Assistant City Manager Title: President Date: Sep 20,2021 Date: Sep 16, 2021 CITY OF FORT WORTH INTERNAL ROUTING PROCESS: Approval Recommended: Contract Compliance Manager: By signing I acknowledge that I am the person (5ep 1620211512 CDT) responsible for the monitoring and a� administration of this contract, including By: h nophe de[Sep 16,20211519CDT) ensuring all performance and reporting Name: Chris Harder requirements. Title: Director, Water Department sgmeee abbe Approved as to Form and Legality: By: Suzanne Abbe(Sep 16,202114:00 CDT) Name: Suzanne Abbe Title: Program Manager B Taylor PAD,(Sep 16,202115:26 CDT) 'C O� 100000 O� 4 y �� °OO OO°O Name: Taylor Paris City Secretary: pro° °off d Title: Assistant City Attorney vg o Z 0 0 *%o 000��d 000000 Contract Authorization: By: ``� `` ���*XASaAp M&C: 21-0466 Name: Ronald P. Gonzales HR 1295- Cert.NO. 2021-747596 Title: Acting City Secretary Dated 05/04/2021 OFFICIAL RECORD CITY SECRETARY FT. WORTH, TX Third Amendment to Fort Worth City Secretary Contract No.48301 Page 2 of 13 ATTACHMENT A-1, Amendment to Exhibit A- Statement of Work THIRD 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. 3 to City Secretary Contract Number 48301. 1. Adjust Meter Lid Plug Counts (PCMR14B): This change order increases the total required number of plugs to 75,000 plugs. Amendment 2 Revised Exhibit B Description Quantity Quantity Unit Cost Budget iQor Meter Lid Plug 50,000 75,000 $3.25 $243,750.00 Total Costs $243,750.00 2. Install Hazard Lighting on Communication Tower(PCMR 27): The U.S. Navy requested that the FWWD install a hazard light on the communication tower located at the Stagecoach Ground Storage Tank Facility. The City requested Aqua Metric engage BC Walker, Inc. to install the hazard light on the tower. Description BC Walker Aqua Metric Total Tower Light and Controller $8.558.00 $1,711.60 $10,297.60 Installer on Tower $1,660.00 $332.00 $1,992.00 Installation of H-Frame Not Included $1,500.00 $1,500.00 Installation of Light Controller on H-Frame $480.00 $96.00 $576.00 BC Walker Mobilization $1,500.00 $300.00 $1,800.00 Aqua Metric Mobilization Not Included $1,000.00 $1,000.00 Total Costs $12,498.00 $4,939.60 $17,165.00 3. Warehouse Expansion (PCMR 28): As part of the MyH2O deployment, Aqua Metric procured warehouse space to store Fort Worth meters and smart-points and facilitate the MyH2O installation work. This change order approves the following: • Extension of the lease into 2022 with rights to extend on a month-to-month basis beginning January 2022. • Leasing an additional 2,000 square feet of adjacent warehouse space under the same lease terms at an additional cost of$850/month • One-time improvements for the warehouse to prepare new space estimated at $15,000. • Increase to operation costs to offset inflation price adjustments for warehouse labor, utilities, internet, security monitoring, etc. With the additional costs, the monthly warehouse costs will increase (effective 4/1/2021) from $12,669.12/month to $15,000/month. In addition, the warehouse costs will increase to $15,500/month effective on 4/1/2022. Expansion of the warehouse creates the staging space needed to expedite the program schedule. The expedited schedule will result in a net reduction in overall warehouse costs to the program. Third Amendment to Fort Worth City Secretary Contract No.48301 Page 3 of 13 4. Sensus Price Increase (PCMR 29): This change order approves a price increase for Sensus 5/8" x 3/4" inch meters and smart-points, effective April 1, 2021. Pricing expires on March 31 st 2022. Sensus Product Original Price Revised Price 5/8" x 3/4" Meters $75.29 $76.47 Single Port SmartPoints $84.81 $86.07 5. Labor Costs Increases (PCMR 30): This change order increases labor costs, effective April 1, 2021 to allow Aqua Metric to continue to employ field staff needed at competitive labor rates to complete the remaining portion of the MyH2O deployment. The labor costs are subject to a second increase effective April 1, 2022. Revised Revised Unit Cost (Effective Unit Cost Installation Labor Unit Cost 4/1/2021) (Effective 4/1/2022) Residential Clean Meter Box $4.50 $6.00 $6.18 Drill Lid $9.33 $9.33 $9.61 5/8" Meter Installation and Activation $35.00 $37.50 $38.63 1" Meter Installation and Activation $35.00 $37.50 $38.63 1 1/2" Meter Installation and Activ. $192.92 $200.00 $206.00 2" Meter Installation and Activation $216.45 $225.00 $231.75 3" Meter Installation and Activation $433.84 $446.86 $460.26 4" Meter Installation and Activation $541.41 $557.65 $574.38 6" Meter Installation and Activation $770.34 $793.45 $817.25 8" Meter Installation and Activation $1,063.61 $1,095.52 $1,128.38 10" Meter Installation and Activation $1,579.55 $1,626.94 $1,675.74 SmartPoint Activation $43.75 $43.75 $45.06 Meter Box Resets $30.00 $32.50 $33.48 Direct Connects $205.00 $205.00 $211.15 Flange Kit Installs $475.00 $475.00 $489.25 Special Job Hours $83.33 $90.00 $92.70 6. Increase in Program Management Budget (PCMR 31): The initial Program Management budget was based on a single program manager. This change order approves an increase in the annual Program Management fee, effective April 1, 2021, to fund four full-time employees: a program manager, a field manager, and two quality assurance techs. Program management costs are subject to a second increase effective April 1, 2022. Aqua Metric will continue to invoice the Program Management monthly basis as services are rendered. Revised Revised Current Annual Cost Annual Cost Program Management Annual Cost (Effective 4/1/2021) (Effective 4/1/2022) Aqua Metric Program Management $200,000 $350,000 $425,000 7. Omni Meter De-Scope (PCMR 32): Effective April 27, 2021, Fort Worth Water Meter Services assumed the responsibility for completing 1 '/2" and 2" meter exchanges to mitigate budget increases and to facilitate the use of custom gaskets in the installation. This change order approves the following: • Removal of labor associated with installation of 1 '/2" and 2" Omni meters from the Aqua Metric Statement of Work. • Sale and transfer of installation materials related to 1 '/2" and 2" meter exchanges (brass nipples, flanges, etc.) from Aqua Metric to Fort Worth Meter Services. The total cost of the materials is $40,980.60. Third Amendment to Fort Worth City Secretary Contract No.48301 Page 4of13 • Transfer of existing inventory related to 1 '/2" and 2" meter exchanges at the Vacek Street Warehouse to the Fort Worth Meter Services warehouse. Asset Purchased Installed Lost RMA Transfer to FW Omni 1.5 Inch C2 2474 1739 3 0 732 Omni 1.5 Inch T2 825 388 0 0 437 Omni 2 Inch C2 3186 2193 2 0 991 Omni 2 Inch T2 1366 901 0 1 464 SmartPoints 1944 0 0 0 1944 8. Expedited Program Schedule (PCMR 33): Fort Worth requested Aqua Metric to expedite the remaining MyH2O deployment to mitigate deployment work that extended past March 31st, 2022. In March 2021, Aqua Metric published the revised MyH2O deployment schedule and started to create a second installation group. The purpose of the 2nd installation group is to complete installation of the bill cycles (19, 6, 13 and 20) that were originally scheduled for 2022. This change order approves the second installation group as an approved subcontractor for the MyH2O deployment and memorializes the intent that both parties have agreed to execute against the expedited MyH2O Deployment Schedule. Year BiIPnmary Meter Alt.C Cycle Count (blackout) Begin Work Meter Exchange Cleanup/ Phase I 2019 21 11,926 7 Apr-19 Jul -Dec Jan-20 Year BiIPnmC Primary Count (blacko Meter Alt. ut) Begin eWorkrep Meter Exchange Cleanup/ 9 Y ( ) 7 12,965 14 Nov-19 Jan, Feb Jun-20 14 13,949 8, 15 Jan-20 Mar-Jul Sep-20 8 14,946 15 Feb-20 Apr-Jul Aug-20 2020 15 14,527 2 Mar-20 Jun,Jul Nov-20 2 11,223 9 Apr-20 Jul -Sept Nov-20 9 13,205 16 May-20 Oct, Nov Jan-21 16 15,980 3 Jul-20 Dec,Jan Feb-21 3 12,475 10 Sep-20 Jan, Feb Mar-21 10 14,269 17 Nov-20 Feb, Mar Apr-21 Full 17 17,830 4 Jan-21 Mar-May Jun-21 Deployment 4 12,814 11 Apr-21 Apr-Jun Jul-21 11 11,254 18 May-21 Jun -Jul Aug-21 18 11,874 5 May-21 Jul,Aug Sep-21 5 13,921 12 Jul-21 Sept, Oct Nov-21 2021 12 12,820 19 Aug-21 Oct, Nov Dec-21 19 1 11,143 6 1 Aug-21 Nov-Jan Feb-22 6 13,078 19 Sep-21 Nov-Jan Feb-22 Expedited Schedule(2nd Install Group) Primary oult Work Begin eWrep Meter Exchange Cleanup/ Billing 20 13,177 13 Jun-21 Jul -Oct Nov-21 13 10,911 20 Jul-21 Jun-Set Oct-21 1 7,676 6 Aug-20 Feb'21 -Jan '22 Feb-22 Total All 271,963 All Third Amendment to Fort Worth City Secretary Contract No.48301 Page 5of13 9. Meter Lids Replacement (PCMR 34): City of Fort Worth requested Aqua Metric to assist with lid replacements where the City's meter box is located in a pedestrian walkway. Because of the advanced phase of the deployment, incorporating new lids in pedestrian walkways will be limited to bill cycles 1, 5, 6, 12, and 19 as follows: • Bill Cycle: 1 o Order replacement lids for locations all locations in Cycle 1 where Fort Worth identified meter in a pedestrian walkway. o Further work on bill cycle 1 will be delayed until DFW Plastics delivers replacement lids. When lids are received, meter installations in pedestrian walkways will receive new lids. o Revisit RTU's related to pedestrian walkways—cost will be $52/ea. In Bill Cycle 1, there are 150 locations that were previously RTU'ed by Aqua Metric. o Replace lids for completed meter exchanges in pedestrian walkways —cost will be $20 ea. There are 237 locations where Aqua Metric will return to replace the lid. • Bill Cycles: 5, 6, 12, 19 -Aqua Metric has not prepped these bill cycles. Aqua Metric ordered lids from DFW Plastics. When lids are available, proceed with lids. o If replacement lid is not available, move forward with normal installation. Do not RTU the location because the meter box is located in a pedestrian walkway. o Notate location so that City of Fort Worth can replace the lid at a later date. • Bill Cycles: 4, 11, 13, 18, 20 - Aqua Metric has already prepped these bill cycles. The existing lid was most likely drilled. o Proceed with the install; do not RTU the location because the meter box is located in a pedestrian walkway. o Notate locations so that City of Fort Worth can replace the lid at a later date. Below is a breakdown of the replacement lids and material costs. Cycle Schedule DFWB12S DFW39C DFW1423C DFW37C Total 1 Feb-Jul 263 61 253 121 698 5 Sept-Oct 141 18 166 74 399 6 Nov-Jan 71 29 34 31 165 12 Nov-Jan 686 16 29 58 789 19 Nov-Jan 89 2 0 14 105 Total Count 1250 126 482 298 2156 Lid Count Contingency(20%) 250 25 96 60 431 Total Count(with Contingency) 1500 151 578 358 2587 DFW Lid Pallet Size 100 100 100 100 --- DFW Lids(Pallets) 15 2 6 4 27 DFW Lid Count Ordered 1500 200 600 400 2700 DFW Lids Unit Cost $27.95 $33.20 $31.72 $51.81 $88,321.00 AQM Markup(15%of DFW Lids unit cost) $4.19 $4.98 $4.76 $7.77 $13,248.15 Total Cost $32.14 $38.18 $36.48 $59.58 Total$'s $48,213.75 $7,636.00 $21,886.80 $23,832.60 $101,569.15 Third Amendment to Fort Worth City Secretary Contract No.48301 Page 6of13 ATTACHMENT A-2, Amendment to Exhibit A - Program Schedule THIRD AMENDMENT TO FORT WORTH CITY SECRETARY CONTRACT NO. 48301 MyH2O Program Schedule - Revised August 23,2021 Apr Jul Ocl Jan Ayr Jul Ocl Jan Apr Jul Oct Jan Ayr Jul Oct Jan Apr Jul Oct Jan Apr 2017 2017 2017 2018 2018 2018 M18 2019 2019 2019 2019 20M 2020 2020 202C 2021 2021 M21 2021 M 22 2022 J1 n contracts 2C 17 AMI Software Purchase FW-Other Software [SEW,Mulasoh,Tenon] Business Process UhINJb*s-PAC Strategy VGIiW -8 Prat. Fqt worth-8us14,prOc- AMI Network Propagation Study ATC Lease Agreements S1mChlr119,Permits,etc- Base Stations-Pilo[ ease Stations•Full AMI Integration RNI Setup&Integration MDMS Install MOMS Setup&Configure MDMS Daily Sync Imeg. MDMS Ming Inlegrativn UAT Deployment Deployment Planning Warehouse setup B Meter Swap Integration Navuscen er setup Pilot Deployment Full Deployment Close out Apr Jul Oct Jan Apr Jul Oct Jan Apr Jul Oct Jan Apr Jul Oct Jan Apr Jul Oct ]an Apr Jan 2017 2017 2017 2018 2018 2018 2018 2019 2019 2019 2019 2020 2020 MW 2020 2021 2021 2021 2021 2022 2022 Jun 2017 2M Third Amendment to Fort Worth City Secretary Contract No.48301 Page 7of13 ATTACHMENT A-2, Amendment to Exhibit A- Program Close Out THIRD AMENDMENT TO FORT WORTH CITY SECRETARY CONTRACT NO. 48301 MyH2O Deployment -Close Out Activities Check List status Estimated (Pending, In Responsible Completion Progress, # Activity Party Date Complete) Initials Notes Deployment Publish final weekly deployment 1 status report Aqua Metric Jan-22 2 Publish final install QC list FWWD Jan-22 3 Resolve final Install QC list Aqua Metric Feb-22 Publish final install not accepted 4 report sl-Serco Jan-22 Resolve final install not accepted 5 report Aqua Metric Feb-22 Cutover remaining bill cycles from 6 manual read to AMI read FWWD Feb-22 Expire 30-day workmanship warranty Feb 2022- 30 days from completion 7 for installation work Aqua Metric Mar 2022 of tasks#1-#5 Feb 2022- 30 days from completion 8 Release field staff Aqua Metric Mar 2022 of tasks#1-#5 Aqua Metric Feb 2022- 30 days from completion 9 Decommission CRM response process FWWD Mar 2022 of tasks#1-#5 Reconcile CIS data against 10 1 NovusCenter data Aqua Metric Mar-22 11 Publish final deployment reports Aqua Metric Mar-22 12 NovusCenter data transfer Aqua Metric Apr-22 13 NovusCenter decommissioning Aqua Metric May-22 Inventory/Warehouse Notice for warehouse lease 14 termination Aqua Metric Dec-22 Requires 6 month notice Publish inventory reports-installed 15 assets,warehouse,lost/damaged Aqua Metric Mar-22 Transfer of inventory from contractor Aqua Metric 16 to City FWWD Apr-22 17 Transfer open RMA tickets Aqua Metric Apr-22 18 Transfer product warranties Aqua Metric Apr-22 19 Decommission warehouse Aqua Metric May-22 Third Amendment to Fort Worth City Secretary Contract No.48301 Page 8 of 13 ATTACHMENT A-2, Amendment to Exhibit A- Program Close Out THIRD AMENDMENT TO FORT WORTH CITY SECRETARY CONTRACT NO. 48301 MyH2O Deployment -Close Out Activities Check List status Estimated (Pending, In Responsible Completion Progress, # Activity Party Date Complete) Initials Notes AMI Network and Software Apply latest software patches- 4th quarter 20 FlexNet RNI Aqua Metric 2021 Apply latest software patches- 4th quarter 21 FieldLogic Aqua Metric 2021 Apply latest software patches-Harris 4th quarter 22 MDMS Aqua Metric 2021 Switch endpoint communication from LAT(Listen after talk)to MOM(middle 23 of minute) Aqua Metric Feb-22 Conduct worksession with FW stakeholders to turnover to Aqua 24 Metric production support Aqua Metric Mar 2022 Conduct worksession with FW stakeholders to discuss FW territory 25 growth and AMI network coverage Aqua Metric Mar 2022 Deliver endpoint encryption 26 1 options/recommendation I Aqua Metric 1 Apr 2022 TWDB Close Out Activities On-going until 2022- 90% Listing of files,warranties and complete by technical data, location stored and January 27 point of contact A-M/FWWD 2022 Identify warranties and appoint November 28 responsible City employee/employees FWWD 2021 Convene Meeting and review close out checklist with progra.m participants and appropriate team members. Assign lead participants relevant activities to ensure completion of Aqua Metric November 29 activities FWWD 2021 Compile and publish close-out report indicating final status of deliverables, Aqua Metric February 30 issues,changes and costs FWWD 2022 Conduct formal contact close-out(see Aqua Metric 31 A-M Contract Close-Out) FWWD April 2022 32 Obtain and approval of final invoice(s) FWWD April 2022 Initiate SWIFT close-out with the Can attempt early close- 33 TWDB FWWD 1 Apri12022 out. 34 Conduct Program close-out meeting FWWD April 2022 Formal storage of program records- 35 retainage requirements FWWD May 2022 Complete SWIFT close-out with the 36 TWDB FWWD June 2022 Initiate contract retainage payment to 37 contractor FWWD June 2022 Third Amendment to Fort Worth City Secretary Contract No.48301 Page 9 of 13 ATTACHMENT B-1, Amendment to Exhibit B- Budget THIRD AMENDMENT TO FORT WORTH CITY SECRETARY CONTRACT NO. 48301 Contract Amendment 2 Contract Amend ment3 (Full Budget) (Full Budget) Units Actual Spend to Revised Category/Subcategory Unit Cost (Actual) Date Units Total Budget Change INF Infrastructure $3,133,262.79 $3,288,396.70 $155,133.91 INF AMI Network 32 $1,933,262.79 $1,936,696.26 $3,433.47 INF Aqua Metric Project Management $200,000.00 6 $1,200,000.00 4.5 $895,450.43 INF Aqua Metric Project Management(adjusted 4/1/2021) $350,000.00 1.0 $350,000.01 INF Aqua Metric Project Management(adjusted 4/1/2022) $425,000.00 0.3 $106,250.00 $151,700.44 RNI Regional Network Interface $251,224.80 $245,058.12 -$6,166.68 HAR Harris Software License $819,880.35 $903,588.35 $93,708.00 UWS Utiliworks 1 $512,090.87 $512,090.87 $0.00 SEW SEW Customer Portal $1,518,464.80 $1,518,464.80 $0.00 MUL MuleSoft Integration PaaS $1,625,578.19 $1,610,715.87 -$14,862.32 TEN TENON Data Warehouse Software $215,000.00 $201,000.00 -$14,000.00 MTR Meters&SmartPoints $44,856,776.39 $47,734,787.10 $2,878,010.71 MTR 5/8"x 3/4"SRII TR/PL C.F. $75.29 170,083 $12,805,549.07 125,578 $9,454,767.62 MTR 5/8"x 3/4"SRII TR/PL C.F.(adjusted 4/1/2021) $76A7 52,628 $4,024,463.16 $673,681.71 MTR 3/4"S SRII TR/PL C.F. $106.10 758 $80,423.80 712 $75,543.20 -$4,880.60 MTR 1"SRII TR/PL C.F. $173.17 20,363 $3,526,260.71 22,511 $3,898,229.87 $371,969.16 MTR 11/2"OMNI R2 TR/PL C.F. $340.95 0 $0.00 $0.00 $0.00 MTR 11/2"OMNI C2 TR/PL C.F. $759.53 2,718 $2,064,402.54 2,471 $1,876798.63 -$187,603.91 MTR 11/2"OMNI T2 TR/PL C.F. $519.79 627 $325,908.33 825 $428:822.75 $102,914.42 MTR 2"OMNI R2 TR/PL C.F. $478.38 0 $0.00 $0.00 $0.00 MTR 2"OMNI C2 TR/PL C.F. $876.38 4,040 $3,540,575.20 3,185 $2,791,270.30 -$749,304.90 MTR 2"OMNI T2 TR/PL C.F. $616.54 1,844 $1,136,899.76 1,366 $942,193.64 -$294,706.12 MTR 3"OMNI C2 TR/PL C.F. $1,136.82 93 $105,724.26 93 $105,724.26 $0.00 MTR 3"OMNI T2 TR/PL C.F. $768.31 6 $4,609.86 8 $6,146.48 $1,536.62 MTR 4"OMNI C2 TR/PL C.F. $1,974.47 155 $306,042.85 153 $302,093.91 -$3,948.94 MTR 4"OMNI T2 TR/PL C.F. $1,495.72 10 $14,957.20 12 $17,948.64 $2,991.44 MTR 6"OMNI C2 TR/PL C.F. $3,330.20 258 $859,191.60 255 $949,201.00 -$9,990.60 MTR 6"OMNI T2 TR/PL C.F. $2,620.05 10 $26,200.50 10 $26,200.50 $0.00 MTR 8"OMNI C2 TR/PL C.F. $5,645.36 102 $575,826.72 88 $496,792.33 -$79,034.39 MTR 8"OMNI T2 TR/PL C.F. $4,668.71 2 $9,337.42 15 $70,030.65 $60,693.23 MTR 8"OMNI F2 TR/PL C.F. $9,480.00 1 $9,480.00 $9,480.00 MTR 10"OMNI C2 TR/PL C.F. $7,375.39 23 $169,633.97 10 $73,753.72 -$95,880.25 MTR 10"OMNI T2 TR/PL C.F. $6,117.26 0 $0.00 14 $85,641.64 $85,641.64 MTR MXU 520M SmartPoint Single Port $84.81 204,572 $17,349,751.32 162,524 $13,783,660.44 MTR MXU 520M SmartPoint Single Port(adjusted 4/1/2021) $86.07 69,012 $5,939,862.94 $2,373,771.96 MTR MXU 520M SmartPoint Dual Port $104.48 17,161 $1,792,981.28 22,324 $2,332,411.52 $539,430.24 MTR iQor Meter Lid Plugs $3.25 50,000 $162,500.00 75,000 $243,750.00 $81,250.00 INS Installation $14,071,323.74 $14,933,797.32 $862,473.58 INS Meter Box Lids(seed stock) $348,920.00 $450,489.15 $101,569.15 INS Residential Clean Meter Box $3.06 4,179 $12,787.74 4,763 $14,574.78 INS Residential Clean Meter Box(adjusted 11/1/2019) $4.50 200,433 $901,948.50 111,897 $503,536.50 INS Residential Clean Meter Box(adjusted 4/1/2021) $6.00J225 76,167 $456,999.90 $60,374.94 INS Reimbursable Dump Fees $4,173.95 $4,173.95 INS Drill Lid $9.33 238,9613 246,709 $2,301,793.57 $72,287.44 INS 5/8"x 3/4"SRII TR/PL C.F. $35.00 170,8410 95,708 $3,349,780.00 INS 5/8"x 3/4"SRII TR/PL C.F.(adjusted 4/1/2021) $37.5081,634 $3,061,275.00 $431,620.00 INS 1"Meter&SmartPoint Installation and Activation $35.00 20,3630 12,669 $443,415.00 INS 1"Meter&SmartPoint Installation and Activation(adj.4/1/2021) $37.509,523 $357,112.50 $87,822.50 INS 11/2"Meter&SmartPoint Installation and Activation $192.92 3,3450 2,046 $394,714.32 INS 11/2"Meter&SmartPoint Installation and Activation(adj.4/1/21) $200.00 76 $15,200.00 -$235,403.08INS 2"Meter&SmartPoint Installation and Activation $216.45 5,8840 2,967 $642,207.15 INS 2"Meter&SmartPoint Installation and Activation(adj.4/1/2021) $225.00 146 $32,850.00 -$598,534.65 INS 3"Meter&SmartPoint Installation and Activation $433.84 99d$245 0.16 71 $30,802.64 INS 3"Meter&SmartPoint Installation and Activation(adj.4/1/2021) $446.86 17 $7,596.59 -$4,550.93 INS 4"Meter&SmartPoint Installation and Activation $541.41 1652.65 116 $62,803.56 INS 4"Meter&SmartPoint Installation and Activation(adj.4/1/2021) $557.65 29 $16,171.89 -$30,357.20 INS 6"Meter&SmartPoint Installation and Activation $770.34 2681.12 223 $171,785.82 INS 6"Meter&SmartPoint Installation and Activation(adj.4/1/2021) $793.45 30 $23,803.50 -$30,861.80 INS 8"Meter&SmartPoint Installation and Activation $1,063.61 1045.44 15 $15,954.15 INS 8"Meter&SmartPoint Installation and Activation(adj.4/1/2021) $1,095.52 88 $96,405.74 $1,744.45 INS 10"Meter&SmartPoi nt l nsta l lation a nd Activation $1,579.55 239.65 1 $1,579.55 INS 10"Meter&SmartPoi nt l nstal lation a nd Activation(adj.4/1/2021) $1,626.94 23 $37,419.54 $2,669.44 INS SmartPoi nt Activation Only $43.75 37,8698.75 60,717 $2,656,368.75 $999,600.00 INS Scrap meter Value .80 -$935,482.80 $0.00 INS Product Staging(Monthly)-Amendment $12,669.12 607.20 38 $481,426.56 INS Product Staging(Monthly)(adjusted 4/1/2021) $15,000.00 12 $180,000.00 INS Product Staging(Monthly)(adjusted 4/1/2022) $15,500.00 3 $46,500.00 -$52,220.64 INS ITrip Charge-Replace Lid $20.00 237 $4,740.00 $4,740.00 INS Trip Charge-Cycle 1 RTU Revisit to Replace Lid $52.00 150 $7,800.00 $7,800.00 INS Installation Labor&Materials Incidentals $992,490.00 $1,442,754.24 $450,264.24 INS Flange Kits installs(labor&materials) $475.00 500 $237,500.00 685 $325,375.00 $87,875.00 INS Reset or Replace Meter Box $30.00 10,000 $300,000.00 3,975 $119,250.00 INS Reset or Replace Meter Box(adjusted 4/1/2021) $32.50 2,849 $92,594.38 -$88,165.63 INS Direct Connect(Residential)labor&materials $205.00 1,000 $205,000.00 1,661 $340,556.25 $135,556.25 INS Special Job Hours $83.33 3,000 $249,990.00 1,583 $131,889.26 INS Special Job Hours(adjusted 4/1/2021) $90.00 1,417 $127,553.90 $9,453.16 INS Incidental Materials Cost+10% $305,545.45 $305,545.45 LDS Leak Detection Equipment $0.00 $0.00 $0.00 Performance&Payment Bond $607,581.91 $607,581.91 $0.00 Contingency $994,147.12 $482,726.73 -$511,420.39 Unallocated Funds $243,610.04 $0.00 -$243,610.04 Total $69,841,431.00 $73,480,962.00 $3,639,531.00 Third Amendment to Fort Worth City Secretary Contract No.48301 Page 10 of 13 ATTACHMENT C-1, Major Milestones THIRD AMENDMENT TO FORT WORTH CITY SECRETARY CONTRACT NO. 48301 MyH2O-Major Milestone Category Milestone Deliverable Status Date Notes AMI AMI Network Sensus AMI Network Propagation Study document Complete Oct-18 Network Design includes the following: Assumptions Identification AMI Network Sites -Covered Endpoints(forecasts) Not Covered Endpoints(forecasts) Network Resilency Read Rate(forecast) Structural Licenses 3rd party engineer structural analysis confirms Complete Varies Added with PCMR04 Analysis site structure will not be compromised with installation by site of MyH2O AMI Network equipment 3rd Party Aqua Metric entered into 20lease agreements with 3rd Complete Varies Added with PCMR05 Tower Site parties(19 American Tower Corp.and 1 Benbrook Water by site and PCMR09 Lease Authority)on behalf of FWWD. The lease agreements Agreements were assigned to the City of Fort Worth after completion of installation Base Station Upon installation of each AMI Network site,Sensus Complete Varies Certification performs base station certification. This has been by site completed for 30 sites. Base Station Upon installation of each AMI Network site,Sensus Complete Varies Added with PCMR10 Certification performs base station certification. 2 sites remain by site outstanding-Stagecoach and Walsh Ranch. Pending Fort Worth's initiative to construct communication towers at those sites. Business Current State Aqua Metric will conduct a series of workshops to Complete Feb-18 Process Business collaborate with Fort Worth stakeholders on current Design Processes state business processes. Coming out of the workshops, Aqua Metric will document Fort Worth's current state business processes. Future State Aqua Metric will conduct a series of workshops to Complete Jul-18 Business collaborate with Fort Worth stakeholders on future state Processes(1st business processes. Coming out of the workshops,Aqua Pass) Metric will create the initial version of the expected future state business processes for Fort Worth. Future State Aqua Metric will conduct a 2nd series of workshops to Removed N/A Removed from scope Business collaborate with Fort Worth stakeholders on future state from scope with PCMRll Processes business processes. Coming out of the workshops,Aqua (2nd Pass) Metric will deliver the 2nd version of the expected future state business processes for Fort Worth. Future State Aqua Metric will deliver Future State Business Processes Removed N/A Removed from scope Business (Final). Note:The 3rd pass of Future State Business from scope with PCMRll Processes Processes will occur in Phase 2 Pilot. (Final) Contents include: Future State Business Process Flows(final) Requirements Document Use Cases AMI Options After 3rd series of workshops the proposed AMI Options Removed N/A Removed from scope Selection Selected will be memorialized in a document for review from scope with PCMRll by staff and to be presented to Assistant Water Director and Water Director and possibly Assistant City Manager for Design Acceptance Milestone(This should kick other deliverables off,need to define what they are). Synchronize Using the Business Process Design,synchronize the Removed N/A Removed from scope Business design of the AMI Solution with Business Process Design from scope with PCMRll Process whereby the proposed design supports and builds upon Design and the future state process flows.The deliverable will AMI Solution delineate between standard and non-standard technical Design features with plans to address non-standard technical features.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 *Non-standard Feature supporting business process Third Amendment to Fort Worth City Secretary Contract No.48301 Page 11 of 13 ATTACHMENT C-1, Major Milestones THIRD AMENDMENT TO FORT WORTH CITY SECRETARY CONTRACT NO. 48301 MyH2O-Major Milestone Category Milestone Deliverable Status Date Notes Business The Aqua Metric team will develop and deliver business Removed N/A Removed from scope Process process training. from scope with PCMRll Training Contents include: •Business Process Training Plan •Business Process Training Documentation •Training attendance records Business The Aqua Metric team will conduct business process Removed N/A Removed from scope Process Audit audits to measure the effectiveness of the business from scope with PCMRll process training and expected future state. The deliverable is the audit findings. AMI Solution Finalize the overall AMI Solution design diagram. Identify Complete Aug-20 Design all the system integrations to the AMI Solution. Public •Public Awareness Campaign Plan Complete Apr-18 Removed from scope Awareness Goals,objectives and strategy with PCMRll Campaign PAC Evaluation Process and Metrics Plan PAC communication plan PAC communication content Define PAC Status Reports Define AMI Aqua Metric will collaborate with Fort Worth Removed N/A Removed from scope Goals and stakeholders to develop AMI Goals and Benefits from scope with PCMR12 Benefits scorecard. AMI Goals and Benefits AMI Program Goals AMI Business Case Benefits Verification Scorecard Benefits This is an ongoing quarterly deliverable that begins in Removed N/A Removed from scope Verification Pilot once both parties agree that we have deployed from scope with PCMR13 Scorecard enough meters to begin Benefits Verification. (quarterly update) Benefits Benefits Verification Scorecard(Final) Removed N/A Removed from scope Verification from scope with PCMR14 Measurement (Final) AMI Meter Swap Aqua Metric will collaborate with Fort Worth IT and their Complete Jun-19 Software Integration CIS software vendor to create Meter Swap Interace Imple. Design document. MDMS Aqua Metric will conduct MDMS workshops to kick off Complete Oct-19 Workshops the MDMS configuration and integration efforts MDMS Daily Aqua Metric will deliver MDMS Daily Sync Interface Complete Sep-20 Sync document. Integration MDMS Billing Aqua Metric will deliver MDMS Billing Interface Complete Sep-20 Integration document.The assumption is the MDMS Billing Interface will utilize MVRS file format. MDMS Aqua Metric will deliver MDMS Configuration Complete Sep-20 Configuration Requirements document Requirements Document Define AMI For software solution that Aqua Metric will implement, Complete Sep-20 Completed for the Solution Aqua Metric will work with Fort Worth stakeholders to following: Acceptance develop AMI Solution Acceptance Test criteria. -Meter Swap Test •AMI Solution Acceptance Test Integration -Test Plan Sensus Field Logic -Test Cases Sensus RNI -Test Results Harris MDMS MDMS Aqua Metric will conduct NovusCenter training sessions Complete Jul-20 Training with Fort Worth stakeholders. NovusCenter Aqua Metric will conduct NovusCenter training sessions Complete Jul-19 Training with Fort Worth stakeholders. FlexNet RNI Aqua Metric will conduct NovusCenter training sessions Complete Apr-19 Training with Fort Worth stakeholders. FieldLogic Aqua Metric will conduct NovusCenter training sessions Complete Apr-19 Training with Fort Worth stakeholders. Customer With collaboration from Fort Worth stakeholders,Aqua Complete Dec-19 Descoped Portal Metric will procure software and implementation Procurement services from SEW. Aqua Metric will assign the contracts to Fort Worth. Fort Worth IT will work directly with the SEW team to implement the SEW software. Third Amendment to Fort Worth City Secretary Contract No.48301 Page 12 of 13 ATTACHMENT C-1, Major Milestones THIRD AMENDMENT TO FORT WORTH CITY SECRETARY CONTRACT NO. 48301 MyH2O-Major Milestone Category Milestone Deliverable Status Date Notes Enterpise With collaboration from Fort Worth stakeholders,Aqua Complete Nov-19 added to scope with Service Bus Metric will procure software and implementation PCMR24 Procurement services from Mulesoft. Aqua Metric will assign the contracts to Fort Worth. Fort Worth IT will work directly with the Mulesoft team to implement the Mulesoft software. Data With collaboration from Fort Worth stakeholders,Aqua Complete Apr-20 added to scope with Management Metric will procure software and implementation PCMR25 Professional services from Tenon. Aqua Metric will assign the Services contracts to Fort Worth. Fort Worth IT will work directly Procurement with the Tenon team to implement the Tenon software. Deployment Meter Profiles Prior to procurement,Aqua Metric will work with Fort Complete Jan-18 Worth stakeholders to 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 •Meter Installation Plan Complete Jun-19 Installation Meter deployment plan Plan(Pilot) Meter purchasing and inventory control procedures Meter install checklist(residential&commercial) Detailed procedures for meter installation and post installation -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 •Meter Installation Plan Complete Jan-20 Installation Meter deployment plan Plan(Full Meter purchasing and inventory control procedures Deployment) Meter install checklist(residential&commercial) -Detailed procedures for meter installation and post installation -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 Define AMI •AMI Program Cleanup Checklist Complete Date of Program Description of outstanding item Amend Cleanup Description of plan to resolve item ment#3 Checklist -Target resolution date Owner Status(Pending,In Progress,Complete) Status Update AMI Program Completion of the AMI Program Cleanup Checklist Not Started Jun-22 Cleanup Completion Third Amendment to Fort Worth City Secretary Contract No.48301 Page 13 of 13 City of Fort Worth, Texas Mayor and Council Communication DATE: Tuesday, June 22, 2021 REFERENCE NO.: **M&C 21-0466 LOG NAME: 60MYH2OCOMPLETION SUBJECT: (ALL) Authorize Amendment No. 3 to the Agreement with Aqua Metric Sales Company in an Amount of $3,639,531.00, and Amendment No. 5 to the Agreement with SL-serco, Inc. in an Amount of$339,000.00, and Adopt Appropriation Ordinances for the Completion of the City-Wide Deployment of the MyH2O Program RECOMMENDATION: It is recommended that the City Council: 1. Authorize Amendment No. 3 to City Secretary Contract No. 48301 with Aqua Metric Sales Company, a registered d/b/a of Thirkettle Corporation, in the amount of$3,639,531.00, for the completion of the full city-wide deployment of advanced metering infrastructure through the MyH2O Program for a revised contract amount of$73,480,962.00; 2. Authorize Amendment No. 5 to City Secretary Contract No. 48192 with SL-serco, Inc. in the amount of$339,000.00 to provide continued support and technical assistance to complete the MyH2O Program for a revised contract amount of$2,008,000.00; 3. Adopt the attached appropriation ordinance increasing appropriations in the Texas Water Development Board - State Water Implementation Revenue Fund for Texas Fund in the amount of $129,999.92 for the purpose of funding the Advanced Metering Infrastructure project; and 4. Adopt attached appropriation ordinance increasing receipts and appropriations in the Water and Sewer Capital Projects Fund in the amount of$3,510,235.00, transferred from available funds within the Water and Sewer Fund, for the purpose of funding the Advanced Metering Infrastructure project (City Project No. CO2715). DISCUSSION: On September 1, 2015, the City Council authorized the first of two funding installments for an Advanced Metering Infrastructure Project, known as the MyH2O Program Mayor and Council Communication (M&C) G-18549). This program will give customers new tools and information to better understand and manage their water use, promote efficiencies from treatment to tap, and improve processes and operations across the utility. The City of Fort Worth requested $76 million in funding through the State Water Implementation Revenue Fund for Texas (SWIRFT formerly SWIFT) from the Texas Water Development Board (TWDB). The TWDB approved the application on July 23, 2015. On May 17, 2016, the City Council authorized a contract with Aqua Metric Sales Company, a registered d/b/a of Thirkettle Corporation (Aqua Metric), in the amount of$11,783,697.00 to implement planning and initial implementation of the MyH2O Program (M&C C-27726). On May 15, 2018 (M&C C-28695), the City Council authorized an amendment to City Secretary Contact No. 48301 with Aqua Metric for the full City- wide deployment of advanced metering infrastructure, bringing the total contract amount to $69,841,431.00. This M&C requests authorization to execute Amendment No. 3 to City Secretary Contract No. 48301 in the amount of$3,639,531.00 for a total contract amount of$73,480,962.00. Amendment No. 3 will allow the City to address the increasing cost of supplies and labor and provides additional funds to address growth in the service area to ensure full coverage. This includes the purchase of additional radios, meters, and meter box lids. On September 20, 2016 (M&C C-27936) the City Council authorized a contract with SL-serco, Inc. in the amount of$175,000.00 for program management support and technical assistance for MyH2O. The contract was renewable annually and revised by Amendment No. 1 on April 27, 2017 to increase the http://apps.cfwnet.org/ecouncil/printmc.asp?id=29015&print=true&DocType=Print 9/10/2021 annual renewal amount by$94,000.00 under the authorization of M&C C-27936. The contract was renewed on September 22, 2017 and April 18, 2018 in the amount of$269,000.00 per renewal under the authorization of M&C C-27936. Amendment No. 2 changed the contract term and was authorized administratively on April 12, 2018. Amendment No. 3 was authorized March 19, 2019 (M&C C-29065), ending annual renewals and authorizing the use of$807,000.00 for continued program support. Amendment No. 4, authorized administratively on February 10, 2021, allowed SL-serco to provide support services for the meter audit requested by the City Council's Audit Committee. This M&C requests authorization of Amendment No. 5 to City Secretary Contract No. 48192 in an amount not to exceed $339,000.00 for a total contract amount not to exceed $2,008,000.00. This amendment allows SL-serco to better align with the current program schedule and to complete the intensive technical and operational support requirements of MyH2O through final close-out and program acceptance. In addition to contract costs, $100,000.00 is required for contingency and the remaining amounts to cover all other City related charges. Appropriations for the Advanced Metering Infrastructure project, are as depicted below. Fund Existing Additional Project Appropriations Appropriations Total Water& Sewer Capital Projects $182,569.00 $3,510,235.00 $3,692,804.00 Fund 56002 WSS 2017B Capital Projects $60,471,450.26 $0.00 $60,471,450.26 Fund 56015 TWDB SWIFT $12,301,421.00 $129,999.92 $12,431,420.92 Fund 57005 Water Capital $592,234.00 $0.00 $592,234.00 Fund 59601 Project Total $73,547,674.26 $3,640,234.92 $77,187,909.18 Contract No. 48192 Amendment No. 5: Business Equity-A waiver of the goal for Business Equity subcontracting requirements was requested, and approved by the Department of Diversity and Inclusion (DVIN), in accordance with the applicable Ordinance, because the purchase of goods or services is from sources where subcontracting or supplier opportunities are negligible. Contract No. 48301 Amendment No. 3: Aqua-Metric Sales Company is in compliance with the City's Business Equity Ordinance by committing to six percent Business Equity participation on this project. The City's Business Equity goal on this project is six percent. This project serves ALL COUNCIL DISTRICTS. FISCAL INFORMATION /CERTIFICATION: The Director of Finance certifies that funds are currently available in the Water&Sewer Fund and the AMI -Advanced Metering Infras project within the TWDB SWIRFT Fund, and upon approval of the above recommendations and adoption of the attached appropriation ordinances, funds will be available in the W&S Capital Projects Fund and the TWDB SWIRT Fund for the AMI -Advanced Metering Infras project to support the approval of the above recommendations and execution of the contract amendments. Prior to any expenditure being incurred, the Water Department has the responsibility of verifying the availability of funds. FUND IDENTIFIERS (FIDs): TO Fund Department Accountl Project JProgram ctiiviitylBudget I Reference # mount http://apps.cfwnet.org/ecouncil/printmc.asp?id=29015&print=true&DocType=Print 9/10/2021 ID ID Year (Chartfield 2) FROM Fund Department ccount Project Program ctivity Budget Reference # mount ID ID Year Chartfield 2 CERTIFICATIONS: Submitted for City Manager's Office by: Dana Burghdoff (8018) Originating Department Head: Chris Harder (5020) Additional Information Contact: Suzzane Abbe (8209) ATTACHMENTS 1. 60MYH2O COMPLETION FID Table (NN 05.11.21) updated.xlsx (CFW Internal) 2. 60MYH2OCOMPLETION Aqua Metric 1295 form.0 (CFW Internal) 3. 60MYH2OCOMPLETION Aqua Metric MWBE.pdf (CFW Internal) 4. 60MYH2OCOMPLETION funds avail.docx (CFW Internal) 5. 60MYH2OCOMPLETION SAM Aqua Metric.pdf (CFW Internal) 6. 60MYH2OCOMPLETION SAM serco.pdf (CFW Internal) 7. 60MYH2OCOMPLETION SL-serco 1295 form.pdf (CFW Internal) 8. 60MYH2OCOMPLETION SL-serco.pdf (CFW Internal) 9. 60MYH2OCOMPLETION 56002 A021(r4).docx (Public) 10. 60MYH2OCOMPLETION 57005 A021(r3).docx (Public) http://apps.cfwnet.org/ecouncil/printmc.asp?id=29015&print=true&DocType=Print 9/10/2021 0. 8 LU LLccl B LU ' I�� ca II4 $ 'I I�IILU LU . S ' I�I1II� e ��1I11I1I z I11�1 z ��I1II 0" 1�1I11I1I I I I City of Fort Worth, Texas Mayor and Council Communication DATE: 06/22/21 M&C FILE NUMBER: M&C 21-0466 LOG NAME: 60MYH2OCOMPLETION SUBJECT (ALL)Authorize Amendment No. 3 to the Agreement with Aqua Metric Sales Company in an Amount of$3,639,531.00, and Amendment No. 5 to the Agreement with SL-serco, Inc. in an Amount of$339,000.00, and Adopt Appropriation Ordinances for the Completion of the City-Wide Deployment of the MyH2O Program RECOMMENDATION: It is recommended that the City Council: 1. Authorize Amendment No. 3 to City Secretary Contract No. 48301 with Aqua Metric Sales Company, a registered d/b/a of Thirkettle Corporation, in the amount of$3,639,531.00, for the completion of the full city-wide deployment of advanced metering infrastructure through the MyH2O Program for a revised contract amount of$73,480,962.00-1 2. Authorize Amendment No. 5 to City Secretary Contract No. 48192 with SL-serco, Inc. in the amount of$339,000.00 to provide continued support and technical assistance to complete the MyH2O Program for a revised contract amount of$2,008,000.00-1 3. Adopt the attached appropriation ordinance increasing appropriations in the Texas Water Development Board-State Water Implementation Revenue Fund for Texas Fund in the amount of$129,999.92 for the purpose of funding the Advanced Metering Infrastructure project; and 4. Adopt attached appropriation ordinance increasing receipts and appropriations in the Water and Sewer Capital Projects Fund in the amount of$3,510,235.00,transferred from available funds within the Water and Sewer Fund, for the purpose of funding the Advanced Metering Infrastructure project(City Project No. CO2715). DISCUSSION: On September 1, 2015,the City Council authorized the first of two funding installments for an Advanced Metering Infrastructure Project, known as the MyH2O Program Mayor and Council Communication(M&C)G-18549). This program will give customers new tools and information to better understand and manage their water use, promote efficiencies from treatment to tap, and improve processes and operations across the utility. The City of Fort Worth requested$76 million in funding through the State Water Implementation Revenue Fund for Texas(SWIRFT formerly SWIFT) from the Texas Water Development Board(TWDB). The TWDB approved the application on July 23, 2015. On May 17, 2016, the City Council authorized a contract with Aqua Metric Sales Company, a registered d/b/a of Thirkettle Corporation(Aqua Metric), in the amount of$11,783,697.00 to implement planning and initial implementation of the MyH2O Program(M&C C-27726). On May 15, 2018(M&C C-28695),the City Council authorized an amendment to City Secretary Contact No. 48301 with Aqua Metric for the full City-wide deployment of advanced metering infrastructure, bringing the total contract amount to$69,841,431.00. This M&C requests authorization to execute Amendment No. 3 to City Secretary Contract No. 48301 in the amount of$3,639,531.00 for a total contract amount of$73,480,962.00. Amendment No. 3 will allow the City to address the increasing cost of supplies and labor and provides additional funds to address growth in the service area to ensure full coverage. This includes the purchase of additional radios, meters, and meter box lids. On September 20, 2016(M&C C-27936)the City Council authorized a contract with SL-serco, Inc. in the amount of$175,000.00 for program management support and technical assistance for MyH2O. The contract was renewable annually and revised by Amendment No. 1 on April 27, 2017 to increase the annual renewal amount by$94,000.00 under the authorization of M&C C-27936. The contract was renewed on September 22, 2017 and April 18, 2018 in the amount of$269,000.00 per renewal under the authorization of M&C C-27936. Amendment No. 2 changed the contract term and was authorized administratively on April 12, 2018. Amendment No. 3 was authorized March 19, 2019(M&C C-29065), ending annual renewals and authorizing the use of$807,000.00 for continued program support. Amendment No. 4, authorized administratively on February 10, 2021, allowed SL-serco to provide support services for the meter audit requested by the City Council's Audit Committee. This M&C requests authorization of Amendment No. 5 to City Secretary Contract No. 48192 in an amount not to exceed$339,000.00 for a total contract amount not to exceed$2,008,000.00. This amendment allows SL-serco to better align with the current program schedule and to complete the intensive technical and operational support requirements of MyH2O through final close-out and program acceptance. In addition to contract costs, $100,000.00 is required for contingency and the remaining amounts to cover all other City related charges. Appropriations for the Advanced Metering Infrastructure project, are as depicted below. Fund Existing Additional Project Appropriations Appropriations Total Water&Sewer Capital Projects $182,569.00 $3,510,235.00 $3,692,804.00 Fund 56002 1 �1 1 WSS 2017B Capital Projects $60,471,450.26 $0.00$60,471,450.26 Fund 56015 TWDB SWIFT Fund $12,301,421.00 $129,999.92$12,431,420.92 57005 Water Capital Fund $592,234.00 $0.00 $592,234.00 59601 Project Total $73,547,674.26 $3,640,234.92$77,187,909.18 Contract No. 48192 Amendment No. 5: Business Equity-A waiver of the goal for Business Equity subcontracting requirements was requested, and approved by the Department of Diversity and Inclusion(DVIN), in accordance with the applicable Ordinance, because the purchase of goods or services is from sources where subcontracting or supplier opportunities are negligible. Contract No. 48301 Amendment No. 3: Aqua-Metric Sales Company is in compliance with the City's Business Equity Ordinance by committing to six percent Business Equity participation on this project. The City's Business Equity goal on this project is six percent. This project serves ALL COUNCIL DISTRICTS. FISCAL INFORMATION/CERTIFICATION: The Director of Finance certifies that funds are currently available in the Water&Sewer Fund and the AMI-Advanced Metering Infras project within the TWDB SWIRFT Fund, and upon approval of the above recommendations and adoption of the attached appropriation ordinances, funds will be available in the W&S Capital Projects Fund and the TWDB SWIRT Fund for the AMI-Advanced Metering Infras project to support the approval of the above recommendations and execution of the contract amendments. Prior to any expenditure being incurred,the Water Department has the responsibility of verifying the availability of funds. Submitted for City Manager's Office by: Dana Burghdoff 8018 Originating Business Unit Head: Chris Harder 5020 Additional Information Contact: Suzzane Abbe 8209 Insured:Thirkettle Corporation Policy Number:AW3-A665023-06 Policy Period:07/01/2021 -07/01/2022 THIS ENDORSEMENT CHANGES THE POLICY. PLEASE READ IT CAREFULLY. BLANKET ADDITIONAL INSURED - PRIMARY AND NON-CONTRIBUTORY This endorsement modifies insurance provided under the following: BUSINESS AUTO COVERAGE FORM A. The following is added to SECTION II — LIABILITY COVERAGE, Paragraph A.1. Who Is If you agree in a written contract, written An Insured: agreement or written permit that the insurance Additional Insured if Required by Contract provided to a person or organization who qualifies If you agree in a written contract, written as an additional "insured" under SECTION II — agreement or written permit that a person or LIABILITY COVERAGE, Paragraph A.1. Who Is organization be added as an additional "insured" An Insured, subparagraph Additional Insured if under this Coverage Part, such person or Required by Contract is primary and non- organization is an "insured"; but only to the extent contributory, the following applies: that such person or organization qualifies as an The liability coverage provided by this Coverage "insured" under paragraph A.1.c. of this Section. Part is primary to any other insurance available to If you agree in a written contract, written the additional "insured" as a Named Insured. We agreement or written permit that a person or will not seek contribution from any other insurance organization be added as an additional "insured" available to the additional "insured" except: under this Coverage Part, the most we will pay on (1) For the sole negligence of the additional behalf of such additional "insured" is the lesser of: "insured"; or (1) The Limits of Insurance for liability coverage (2) For negligence arising out of the ownership, specified in the written contract, written maintenance or use of any "auto" not owned agreement or written permit; or by the additional "insured" or by you, unless (2) The Limits of Insurance for Liability Coverage that "auto" is a "trailer" connected to an "auto" shown in the Declarations applicable to this owned by the additional "insured" or by you; or Coverage Part. (3) When the additional "insured" is also an Such amount shall be part of and not in addition to additional "insured" under another liability the Limits of Insurance shown in the Declarations policy. applicable to this Coverage Part. Regardless of C. This endorsement will apply only if the "accident" the number of covered "autos", "insureds", occurs: premiums paid, claims made or vehicles involved 1. During the policy period; in the "accident", the most we will pay for the total of all damages and "covered pollution cost or 2. Subsequent to the execution of the written expense" combined resulting from any one contract or written agreement or the issuance "accident" is the Limit of Insurance for Liability of the written permit; and Coverage shown in the Declarations. 3. Prior to the expiration of the period of time that B. The following is added to SECTION IV — the written contract, written agreement or BUSINESS AUTO CONDITIONS, Paragraph B. written permit requires such insurance to be General Conditions, subparagraph 5. Other provided to the additional "insured". Insurance: D. Coverage provided to an additional "insured" will Primary and Non-Contributory not be broader than coverage provided to any other"insured" under this Coverage Part. ALL OTHER TERMS, CONDITIONS, AND EXCLUSIONS REMAIN UNCHANGED. Page 1 of 1 461-0478 12 12 Includes copyrighted material of ISO Insurance Services Office, Inc.,with its permission Insured:Thirkettle Corporation Policy Number:ZZ3-A664940-06 Policy Perio:07/01/2021 -07/01/2022 THIS ENDORSEMENT CHANGES THE POLICY. PLEASE READ IT CAREFULLY. COMMERCIAL GENERAL LIABILITY BROADENING ENDORSEMENT This endorsement modifies insurance provided under the following: COMMERCIAL GENERAL LIABILITY COVERAGE PART SUMMARY OF COVERAGES 1. Additional Insured by Contract, Agreement or Permit Included 2. Additional Insured — Primary and Non-Contributory Included 3. Blanket Waiver of Subrogation Included 4. lBodily Injury Redefined Included 5. Broad Form Property Damage— Borrowed Equipment, Customers Goods & Use of Elevators Included 6. Knowledge of Occurrence Included 7. Liberalization Clause Included 8. IMedical Payments— Extended Reporting Period Included 9. Newly Acquired or Formed Organizations - Covered until end of policy period Included 10. Non-owned Watercraft 51 ft. 11. Supplementary Payments Increased Limits - Bail Bonds $2,500 - Loss of Earnings $1000 12. Unintentional Failure to Disclose Hazards Included 13. Unintentional Failure to Notify Included This endorsement amends coverages provided under the Commercial General Liability Coverage Part through new coverages, higher limits and broader coverage grants. 1. Additional Insured by Contract, Agreement or (1) "Your work" for the additional insured(s) Permit designated in the contract, agreement or The following is added to SECTION II — WHO IS permit; AN INSURED: (2) Premises you own, rent, lease or occupy; Additional Insured by Contract, Agreement or or Permit (3) Your maintenance, operation or use of a. Any person or organization with whom you equipment leased to you. agreed in a written contract, written agreement b. The insurance afforded to such additional or permit that such person or organization to insured described above: add an additional insured on your policy is an (1) Only applies to the extent permitted by additional insured only with respect to liability law; and for "bodily injury", "property damage", or "personal and advertising injury" caused, in (2) Will not be broader than the insurance whole or in part, by your acts or omissions, or which you are required by the contract, the acts or omissions of those acting on your agreement or permit to provide for such behalf, but only with respect to: additional insured. 421-2915 06 15 Includes copyrighted material of Insurance Services Office, Inc.,with its permission. Page 1 of 4 (3) Applies on a primary basis if that is advertising injury" involved the rendering required by the written contract, written of or failure to render any professional agreement or permit. services by or for you. (4) Will not be broader than coverage d. With respect to the insurance afforded to provided to any other insured. these additional insureds, the following is (5) Does not apply if the "bodily injury", added to SECTION III — LIMITS OF "property damage" or "personal and INSURANCE: advertising injury" is otherwise excluded The most we will pay on behalf of the from coverage under this Coverage Part, additional insured for a covered claim is the including any endorsements thereto. lesser of the amount of insurance: c. This provision does not apply: 1. Required by the contract, agreement or (1) Unless the written contract or written permit described in Paragraph a.; or agreement was executed or permit was 2. Available under the applicable Limits of issued prior to the "bodily injury", "property Insurance shown in the Declarations. damage", or "personal injury and This endorsement shall not increase the advertising injury". applicable Limits of Insurance shown in the (2) To any person or organization included as Declarations. an insured by another endorsement 2. Additional Insured — Primary and Non- issued by us and made part of this Contributory Coverage Part. The following is added to SECTION IV — (3) To any lessor of equipment: COMMERCIAL GENERAL LIABILITY (a) After the equipment lease expires; or CONDITIONS, Paragraph 4. Other insurance: (b) If the "bodily injury", "property Additional Insured — Primary and Non- damage", "personal and advertising Contributory injury" arises out of sole negligence of If you agree in a written contract, written the lessor agreement or permit that the insurance provided to (4) To any: any person or organization included as an (a) Owners or other interests from. whom Additional Insured under SECTION II — WHO IS land has been leased which takes AN INSURED, is primary and non-contributory, place after the lease for the land ex- the following applies: pires; or If other valid and collectible insurance is available (b) Managers or lessors of premises if: to the Additional Insured for a loss covered under Coverages A or B of this Coverage Part, our (i) The occurrence takes place after obligations are limited as follows: you cease to be a tenant in that premises; or a. Primary Insurance (ii) The "bodily injury", "property This insurance is primary to other insurance damage", "personal injury" or that is available to the Additional Insured "advertising injury" arises out of which covers the structural alterations, new con- Additional Insured as a Named Insured. We struction or demolition operations will not seek contribution from any other performed by or on behalf of the insurance available to the Additional Insured manager or lessor. except: (5) To "bodily injury", "property damage" or (1) For the sole negligence of the Additional "personal and advertising injury" arising Insured; out of the rendering of or the failure to (2) When the Additional Insured is an render any professional services. Additional Insured under another primary This exclusion applies even if the claims liability policy; or against any insured allege negligence or (3) when b. below applies. other wrongdoing in the supervision, hiring, employment, training or monitoring If this insurance is primary, our obligations are of others by that insured, if the not affected unless any of the other insurance "occurrence" which caused the "bodily is also primary. Then, we will share with all injury" or"property damage" or the offense that other insurance by the method described which caused the "personal and in c. below. 421-2915 06 15 Includes copyrighted material of Insurance Services Office, Inc.,with its permission. Page 2 of 4 b. Excess Insurance insurer contributes equal amounts until it has (1) This insurance is excess over any of the paid its applicable limit of insurance or none of other insurance, whether primary, excess, the loss remains, whichever comes first. If any contingent or on any other basis: of the other insurance does not permit contribution by equal shares, we will contribute (a) That is Fire, Extended Coverage, by limits. Under this method, each insurer's Builder's Risk, Installation Risk or share is based on the ratio of its applicable similar coverage for"your work"; limit of insurance to the total applicable limits (b) That is Fire insurance for premises of insurance of all insurers rented to the Additional Insured or 3. Blanket Waiver of Subrogation temporarily occupied by the Additional I The following is added to SECTION IV — Insured with permission of the owner; COMMERCIAL GENERAL LIABILITY (c) That is insurance purchased by the CONDITIONS, Paragraph 8. Transfer Of Rights Additional Insured to cover the Of Recovery Against Others To Us: Additional Insured's liability as a tenant for "property damage" to We waive any right of recovery we may have premises rented to the Additional against any person or organization with whom you Insured or temporarily occupied by the have a written contract that requires such waiver Additional with permission of the because of payments we make for damage under owner; or this coverage form. The damage must arise out of your activities under a written contract with that (d) If the loss arises out of the person or organization. This waiver applies only to maintenance or use of aircraft, "autos" the extent that subrogation is waived under a or watercraft to the extent not subject written contract executed prior to the "occurrence" to Exclusion g. of SECTION I — or offense giving rise to such payments. COVERAGE A — BODILY INURY AND PROPERTY DAMAGE 4. Bodily Injury Redefined LIABILITY. SECTION V — DEFINITIONS, Definition 3. "bodily (2) When this insurance is excess, we will injury" is replaced by the following: have no duty under Coverages A or B to 3. "Bodily injury" means bodily injury, sickness or defend the insured against any"suit" if any disease sustained by a person including death other insurer has a duty to defend the resulting from any of these at any time. "Bodily insured against that "suit". If no other injury" includes mental anguish or other insurer defends, we will undertake to do mental injury resulting from "bodily injury". so, but we will be entitled to the insured's 5. Broad Form Property Damage — Borrowed rights against all those other insurers. Equipment, Customers Goods, Use of (3) When this insurance is excess over other Elevators Insurance, we will pay only our share of a. SECTION I —COVERAGES, COVERAGE A— the amount of the loss, if any, that BODILIY INJURY AND PROPERTY exceeds the sum of: DAMAGE LIABILITY, Paragraph 2. (a) The total amount that all such other Exclusions subparagraph j. is amended as insurance would pay for the loss in the follows: absence of this insurance; and Paragraph (4) does not apply to "property (b) The total of all deductible and self damage" to borrowed equipment while at a insured amounts under all that other jobsite and not being used to perform insurance. operations. We will share the remaining loss, if any, Paragraphs (3), (4) and (6) do not apply to with any other insurance that is not "property damage" to "customers goods" while described in this Excess Insurance on your premises nor do they apply to the use provision and was not bought specifically of elevators at premises you own, rent, lease to apply in excess of the Limits of or occupy. Insurance shown in the Declarations of b. The following is added to SECTION V — this Coverage Part. DEFINTIONS: c. Method Of Sharing 24. "Customers goods" means property of If all of the other insurance permits your customer on your premises for the contribution by equal shares, we will follow this purpose of being: method also. Under this approach each 421-2915 06 15 Includes copyrighted material of Insurance Services Office, Inc.,with its permission. Page 3 of 4 a. worked on; or 10. Non-Owned Watercraft b. used in your manufacturing process. SECTION I — COVERAGES, COVERAGE A c. The insurance afforded under this provision is BODILY INJURY AND PROPERTY DAMAGE excess over any other valid and collectible LIABILITY, Paragraph 2. Exclusions, property insurance (including deductible) subparagraph g.(2) is replaced by the following: available to the insured whether primary, g. Aircraft, Auto Or Watercraft excess, contingent (2) A watercraft you do not own that is: 6. Knowledge of Occurrence (a) Less than 51 feet long; and The following is added to SECTION IV — (b) Not being used to carry persons or COMMERCIAL GENERAL LIABILITY property for a charge; CONDITIONS, Paragraph 2. Duties in the Event of Occurrence, Offense, Claim or Suit: This provision applies to any person who, with your consent, either uses or is e. Notice of an "occurrence", offense, claim or responsible for the use of a watercraft. "suit" will be considered knowledge of the insured if reported to an individual named 11. Supplementary Payments Increased Limits insured, partner, executive officer or an SECTION I — SUPPLEMENTARY PAYMENTS "employee" designated by you to give us such COVERAGES A AND B, Paragraphs 1.b. and a notice. 1.d. are replaced by the following: 7. Liberalization Clause 1.b.Up to $2,500 for cost of bail bonds required The following is added to SECTION IV — because of accidents or traffic law violations COMMERCIAL GENERAL LIABILITY arising out of the use of any vehicle to which CONDITIONS: the Bodily Injury Liability Coverage applies. We do not have to furnish these bonds. Liberalization Clause 1.d.All reasonable expenses incurred by the If we adopt any revision that would broaden the insured at our request to assist us in the coverage under this Coverage Form without investigation or defense of the claim or "suit", additional premium, within 45 days prior to or including actual loss of earnings up to $1000 a during the policy period, the broadened coverage day because of time off from work. will immediately apply to this Coverage Part. 12. Unintentional Failure to Disclose Hazards 8. Medical Payments — Extended Reporting Period The following is added to SECTION IV — a. SECTION I —COVERAGES, COVERAGE C— COMMERCIAL GENERAL LIABILITY MEDICAL PAYMENTS, Paragraph 1. CONDITIONS, Paragraph 6. Representations: Insuring Agreement, subparagraph a.(3)(b) We will not disclaim coverage under this Coverage is replaced by the following: Part if you fail to disclose all hazards existing as of the inception date of the policy provided such (b) The expenses are incurred and reported failure is not intentional. to us within three years of the date of the accident; and 13. Unintentional Failure to Notify b. This coverage does not apply if COVERAGE The following is added to SECTION IV — C — MEDICAL PAYMENTS is excluded either COMMERCIAL GENERAL LIABILITY by the provisions of the Coverage Part or by CONDITIONS, Paragraph 2. Duties in the Event endorsement. of Occurrence, Offense, Claim or Suit: 9. Newly Acquired Or Formed Organizations Your rights afforded under this policy shall not be prejudiced if you fail to give us notice of an SECTION II — WHO IS AN INSURED, Paragraph "occurrence", offense, claim or "suit", solely due to 3.a. is replaced by the following: your reasonable and documented belief that the a. Coverage under this provision is afforded until "bodily injury" or "property damage" is not covered the end of the policy period. under this policy. ALL OTHER TERMS, CONDITIONS, AND EXCLUSIONS REMAIN UNCHANGED. 421-2915 06 15 Includes copyrighted material of Insurance Services Office, Inc.,with its permission. Page 4 of 4 TEXAS WAIVER OF OUR RIGHT TO RECOVER FROM OTHERS ENDORSEMENT This endorsement applies only to the insurance provided by the policy because Texas is shown in Item 3.A. of the Information Page. We have the right to recover our payments from anyone liable for an injury covered by this policy. We will not enforce our right against the person or organization named in the Schedule, but this waiver applies only with respect to bodily injury arising out of the operations described in the Schedule where you are required by a written contract to obtain this waiver from us. This endorsement shall not operate directly or indirectly to benefit anyone not named in the Schedule. The premium for this endorsement is shown in the Schedule. Schedule 1, ❑ Specific Waiver ® Blanket Waiver Any person or organization for whom the Named Insured has agreed by written contract to furnish this waiver. 2. Operations: 'TEXAS (TX) 3. Premium: The premium charge for this endorsement shall be.percent of the premium developed on payroll in connection with work performed for the above person(s) or organization(s) arising out of the operations described. 4. Advance,Premium: This endorsement changes the policy to which it is attached and is effective on the date issued unless otherwise stated. (The information below is required only when this endorsement is issued subsequent to preparation of the policy.) Endorsement Effective 07/01/2021 Policy No .WD3A652982 Endorsement No, Insured Thirkettle Corporation Premium Insurance Company Hanover American Countersigned by Page 1 of 1 WC 42 03 04 B (Ed.6-14)©Copyright 2014 National Council on Compensation Insurance,Inc.Ali Rights Reserved. 1 CERTIFICATE OF INTERESTED PARTIES FORM 1295 1 Of 1 Complete Nos.1-4 and 6 if there are interested parties. OFFICE USE ONLY Complete Nos.1,2,3,5,and 6 if there are no interested parties. CERTIFICATION OF FILING 1 Name of business entity filing form,and the city,state and country of the business entity's place Certificate Number: of business. Aqua Metric Sales Company 2021-747596 Selma, TX United States Date Filed: 2 Name of governmental entity or state agency that is a party to the contract for which the form is 05/04/2021 being filed. City of Fort Worth, Texas Date Acknowledged: 3 Provide the identification number used by the governmental entity or state agency to track or identify the contract,and provide a description of the services,goods,or other property to be provided under the contract. SWIFT Project#51014 Aqua Metric Annual Support Agreement City of Fort Worth AMI Project 4 Nature of interest Name of Interested Party City,State,Country{place of business) (check applicable) Controlling Intermediary Arnold, Clint Selma, TX United States X Morrison, Paul Selma,TX United States X Aqua-Metric Sales Company Selma, TX United States X Cartwright, Michael Selma, TX United States X Wood, Michael Selma, TX United States X 5 Check only if there is NO Interested Party. 6 UNSWORN DECLARATION My name is and my date of birth is My address is (street) (city) { y) (state) (zip code) (country) I declare under penalty of perjury that the foregoing is true and correct. T Executed in r(L County, State of on the '1 today of 20 — s'�,Y pypn AMPAAO CAROLINA RNAS (mont ) (year) Notary ID#130778951 N„ My Comm€scion Expires ''for September 10, 2024 Signature of authorized agent of contracting bu ess entity (Declarant) Forms providlad by Texas EthiA Commission www.ethics.state.tx,us Version V1.1.ceffd98a