Loading...
HomeMy WebLinkAboutContract 48301-FP1 NN Coded 11.01.22 Vendor Name: Aqua Metric Invoice No. 2241011-IN CSC No.48301-FP1 Invoice Date: 10/14/2022 FORT WORTH PO# FW060-135366 Line 1 -$24,777.67 "mi+mil I � Release Retainage -$106,891.76 FID 56015-2060000-CO2715-CRETAN WATER DEPARTMENT ENGINEERING AND FISCAL SERVICES 57005-CO2715 NOTICE OF PROJECT COMPLETION CS 48301 Regarding contract 48301 for the Advanced Meter Infrastructure Project(MyH2O)as required by the Water Department and approved by City Council on May 17,2016 through M&C C-27726 the Director of the Water Department,upon the recommendation of the Deputy Director of Business Services, Water Department has accepted the project as complete. Original Contract Price: $11,783,697.00 Amount of Approved Amendments $61,697,265.00 Number 4(see comments) Revised Contract Amount: S73,480,962.00 Total Cost Work Completed: $72,887,781.20 Less Deductions: Liquidated Damages: NA Other Deductions(see comments): $0 OFFICIAL RECORD Total Deduction Amount: $0 CITY SECRETARY Total Cost of Work Completed: $72,887,781.20 FT. WORTH, TX Less Previous Payments: $72,756,111.77 Final Payment Due: $131,669.43 / 1&kommgwtWfQr Acceptance Date Dep Director, Water Department ChL2 o 2her Nardor Christopher Harder(Nov 1,202216:48 CDT) Accepted Date Director,Water Department Dana Burghdoff(Nov 4,20 1:29 CDT) City Manager Date Project Name: Advanced Meter Infrastructure Project(MyH2O) CPN CO2715 Comments: The contract for the Advanced Meter Infrastructure Project was set up as a professional services agreement. Changes to the contract were processed as amendments. Total Contract Days: 2,195 Total Days: 2,093 Invoice Page: 1 Aqua-Metric Sales,Co. 4050 Flat Rock Drive Riverside,CA 92505 Invoice Number: 2241011-IN (951)637-1400 Invoice Date: 10/14/2022 Order Number: 3021080 Order Date: 8/1/2022 Salesperson: 0010 Bill To: Customer Number: FORTWORTH City of Fort Worth Ship To: Attn:Suzanne Abbe City of Fort Worth 1130 Fournier Street Attn:Suzanne Abbe Fort Worth,TX 76102 1130 Fournier Street Confirm To: Fort Worth TX 76102 Customer P.O. Ship VIA F.O.B. 17-00096321 Terms CSC 48301-92 Quantity Item Number Description Require Shipped B.O. Unit Price Amount 45 1 44 /LABOR-TX AQUA METRIC PROJECT MANAGEMENT $ 35,416.67 $ 35,416.67 1 1 0 /LABOR-TX AMI NETWORK PROPOGATION STUDY- EULESS SITE REPAIR,CO#41 $ 18,265.00 $ 18,265.00 1 1 0 /LABOR-TX CREDIT-LOST INVENTORY $ (28,901.01) $ (28,901.01) RETAINAGE REIMBURSEMENT $ 106,888.77 $ 106,888.77 Net Invoice: $24,780.66 Freight: Sales Tax: LI a 4�_� Invoice Total: $131,669.43 Aqua-Metric Sales,Co. Date 10/26/2022 City of Fort Worth,TX Date Aqua-Metric Invoice Summary(SWIFT FUNDED) Contract Amount _ $73,480,96_2.00 Amount Invoiced to Date $72,863,000.54 Amount of This Invoice $24,780.66 _ Final Total Spend _ - $72,8_87,7_81.20_ Remaining Contract Balance $593,180.80 Contract Retainage Summary Retainage Applied(Previous Balance) _ _ _ _ _ $106,888.7_7_ Retainage Applied(This Invoice $0.00 ge Total Retaina Applied To Date _ -_ _ __ _ _ -$106 888.77 - - This is the final invoice for CSC 48301,a`Professional Service Agreement"(Information Technology)between the City of Fort Worth and Aqua-Metric Sales Company,a registered d/b/a of Thirkett/e Corporation,a California Corporation. MyH2O Budget Forecast v2.03102022 MyH2O Program Budget Summary Actual Spend to Category Total Budget Date AMllnfrastructure $3,288,397 $3,323,813 RNI SaaS, Hosting and Integration $245,058 $245,058 Harris Software&Implementation $903,588 $903,588 Mulesoft Integration Platform $1,610,716 $1,610,716 TENON Software $201,000 $201,000 SEW Software $1,518,465 $1,518,465 UtiliWorks $512,091 $512,091 Meters and SmartPoints $47,734,787 $47,768,409 Meter/SmartPoint Installation $14,933,797 $14,545,375 Miscellaneous Installation Materials/Services $1,442,754 $1,579,447 Leak Detection(TBD) $0 $0 Performance Bond $607,582 $498,905 Contingency $482,727 $180,913 Total $73,480,962 $72,887,781 1of7 MyH2O Budget Forecast v2.03102022 Network Infrastructure-Equipment,Installation and Annual Maintenance Agreement INF M400 Basestation4(Including Test`nyWenffmn ` $480,000.00 $480,000.00 $0.00 $0.00 $0.00 INF Basestation Antenna Installation(Labor)4 $385,623.12 $385,623.12 $0.00 $0.00 $0.00 Basestation Antenna Installation(Electrical INF Labor) $215,411.23 $215,411.23 $0.00 $0.00 $0.00 Basestation Installation(Materials Up To 200 INF ft.)4 $87,422.71 $87,422.71 $0.00 $0.00 $0.00 Basestation Installation(Materials 200 ft.-300 INF ft.)4 $87,470.28 $87,470.28 $0.00 $0.00 $0.00 INF 113ackhaul Communications(Cellular) $27,000.00 $27,000.00 $0.00 $0.00 $0.00 INF Tower Site Lease 12 $149,083.57 $149,083.57 $0.00 $0.00 $0.00 Load Study(As Required/Per Site)-American INF Tower $242,912.19 $242,912.19 $0.00 $0.00 $0.00 Load Study(As Required/Per Site)-Malouf INF lEngineering $25,300.00 $25,300.00 $0.00 $0.00 $0.00 Load Study(As Required/Per Site)-Centerline INF Engineering $139,957.26 $139,957.26 $0.00 $0.00 $0.00 Antenna Magnetic Mount Hardware(as INF required) $12,292.50 $12,292.50 $0.00 $0.00 $0.00 Lattice Tower(Estimated,variable on site INF requirements) $0.00 $0.00 $0.00 $0.00 $0.00 INF FL6501-GB Hand Held $48,125.00 $48,125.00 $0.00 $0.00 $0.00 INF Single Ethernet Dock $5,500.00 $5,500.00 $0.00 $0.00 $0.00 INF lCommand Link $4,375.00 $4,375.00 $0.00 $0.00 $0.00 INF AutoRead/Field Logic Software $125.00 $125.00 $0.00 $0.00 $0.00 INF UniPro Communication Tool $2,433.40 $2,433.40 $0.00 $0.00 $0.00 INF I Project Management(Annual) $895,450.43 $895,450.43 $0.00 $0.00 $0.00 INF Project Management(Annual)effective 4/01/21 $350,000.01 $350,000.04 -$0.03 $0.00 -$0.03 INF Project Management(Annual)effective 4/01/22 $106,250.00 $141,666.68 -$35,416.68 $0.00 -$35,416.68 INF 15ensus Customer Portal Open-House Demo $5,000.00 $5,000.00 $0.00 $0.00 $0.00 INF Tower Lighting $17,165.00 $17,165.00 $0.00 $0.00 $0.00 Annual Support(A-M Annual Maintenance INF Agreement)12 $0.00 $0.00 $0.00 $0.00 $0.00 INF lContract Administration $1,500.00 $1,500.00 $0.00 $0.00 $0.00 INF Network Infrastructure $3,288,396.70 $3,323,813.41 rp -$35,416.71 $0.00 -$35,416.71 Regional Ni MeterSense MDMS Managed Service Model MeterSense Customer Connect Portal Managed RNI Service Model $0.00 $0.00 $0.00 $0.00 $0.00 MeterSense MDMS Managed Service Model RNI (FY2018/2019)12 $66,666.67 $66,666.67 $0.00 $0.00 $0.00 RNI lRNI SaaS Setup Fee Phase II $63,925.90 $63,925.901 $0.001 $0.001 $0.00 2of7 MyH2O Budget Forecast v2.03102022 RNI Annual RNI SaaS Fee(FY2018/2019)12 $23,243.33 $23,243.33 $0.00 $0.00 $0.00 RNI RNI Core Education-Onsite5 $9,444.44 $9,444.44 $0.00 $0.00 $0.00 RNI iSolution Design&Business Process Workshops $40,000.00 $40,000.00 $0.00 $0.00 $0.00 RNI RNI to MeterSense MDMS Standard Integration $12,000.00 $12,000.00 $0.00 $0.00 $0.00 RNI Regional Network Interface $215,280.34 $215,280.34 $0.00 $0.00 $0.00 Additional Sensus Services(As Required/Requested) RNI CMEP Setup&Installation $1,777.78 $1,777.78 $0.00 $0.00 $0.00 RNI MultiSpeak Setup,Integration,and Testing $5,777.78 $5,777.78 $0.00 $0.00 $0.00 Application Engineering Manager(Fulltime Per RNI I Month)6 $22,222.22 $22,222.22 $0.00 $0.00 $0.00 RNI Application Engineering Manager(Per Hour) $0.00 $0.00 $0.00 $0.00 $0.00 Advanced Hands-On Education&Training(Per RNI Day)7 $0.00 $0.00 $0.00 $0.00 $0.00 RNI RNI-Integration Services 1 $29,777.78 $29,777.78 $0.00 $0.00 $0.00 Harris Software License-Project Management-Annual Software Support HAR MeterSense MOM and Compass $409,500.00 $409,500.00 $0.00 $0.00 $0.00 HAR Implementation Services 8 $494,088.35 $494,088.35 $0.00 $0.00 $0.00 HAR Harris Software Licenses and Services $903,588.35 $903,588.35 $0.00 $0.00 $0.00 Mulesoft Integration Platform MUL Aqua-Metric Contract Execution $50,000.00 $50,000.00 $0.00 $0.00 $0.00 MUL Mulesoft PaaS Year 1(Annual) $613,591.17 $613,591.17 $0.00 $0.00 $0.00 MUL I Mulesoft Training Credits $47,432.00 $47,432.00 $0.00 $0.00 $0.00 MUL Mulesoft Implementation Services $734,957.00 $734,957.00 $0.00 $0.00 $0.00 MUL Aqua-Metric Procurement $139,598.02 $139,598.02 $0.00 $0.00 $0.00 MUL Anypoint MQ Base Subscription Module $22,852.44 $22,852.44 $0.00 $0.00 $0.00 MUL Aqua-Metric Contract Administration $2,285.24 $2,285.24 $0.00 $0.00 $0.00 MUL I Mulesoft Integration Platform 1 $1,610,715.87 $1,610,715.87 $0.00 $0.00 $0.00 TENON Data Warehouse Software TENON Systems Software Annual Subscription- TEN Year 1 $150,000.00 $150,000.00 $0.00 $0.00 $0.00 TEN Training-Onsite 3 Days $10,000.00 $10,000.00 $0.00 $0.00 $0.00 TEN Aqua-Metric Contract Administration $16,000.00 $16,000.00 $0.00 $0.00 $0.00 TEN Aqua-Metric Contract Execution $25,000.00 $25,000.00 $0.00 $0.00 $0.00 TEN TENON Data Software $201,000.00 $201,000.00 $0.00 $0.00 $0.00 3of7 MyH2O Budget Forecast v2.03102022 SEW Software SEW Aqua-Metric Contract Execution $50,000.00 $50,000.00 $0.00 $0.00 $0.00 SEW SEW SaaS Fees-Year 1 $405,700.00 $405,700.00 $0.00 $0.00 $0.00 SEW SEW SaaS Fees-Year 2 $398,600.00 $398,600.00 $0.00 $0.00 $0.00 SEW 1 SEW SaaS Fees-Year 3 $391,501.00 $391,501.00 $0.00 $0.00 $0.00 SEW SEW Implementation Services $139,167.00 $139,167.00 $0.00 $0.00 $0.00 SEW Aqua-Metric Procurement $133,496.80 $133,496.80 $0.00 $0.00 $0.00 SEW SEW Software $1,518,464.80 $1,518,464.80 $0.00 $0.00 $0.00 Utiliworks-Assessment,Business Process Development,Public Awareness Campaign and Benefits Verification UWC AMI Assessment-Remaining Deliverables $102,448.72 $102,448.72 $0.00 $0.00 $0.00 UWC Business Processs Development $268,628.53 $268,628.53 $0.00 $0.00 $0.00 UWC Public Awareness Campaign 5115,329.50 $115,329.50 $0.001 $0.001 $0.00 UWC Benefits Verification $25,684.12 $25,684.12 $0.00 $0.00 $0.00 UWC UtiliWorks $512,090.87 $522,090.87 $0.00 $0.00 $0.00 Meters&SmartPoints MTR 5/8"x 3/4"SRII TR/PL C.F. $9,454,767.62 $9,454,767.62 $0.00 $0.00 $0.00 MTR 5/8"x 3/4"SRII TR/PL C.F.(adjusted 04/01/2021) $4,024,463.16 $4,007,960.03 $16,503.13 $0.00 $16,503.13 MTR 3/4"S SRII TR/PL C.F. $75,543.20 $92,519.20 -$16,976.00 $0.00 -$16,976.00 MTR 1"SRII TR/PL C.F. $3,898,229.87 $3,936,673.61 -$38,443.74 $0.00 -$38,443.74 MTR 1 1/2"OMNI R2 TR/PL C.F. $0.00 $0.00 $0.00 $0.00 $0.00 MTR 1 1/2"OMNI C2 TR/PL C.F. $1,876,798.63 $1,876,798.63 $0.00 $0.00 $0.00 MTR 1 1/2"OMNI T2 TR/PL C.F. $428,822.75 $428,822.75 $0.00 $0.00 $0.00 MTR 2"OMNI R2 TR/PL C.F. $0.00 $0.00 $0.00 $0.00 $0.00 MTR 1211 OMNI C2 TR/PL C.F. $2,791,270.30 $2,790,393.92 $876.38 $0.00 $876.38 MTR 2"OMNI T2 TR/PL C.F. $842,193.64 $841,577.10 $616.54 $0.00 $616.54 MTR 3"OMNI C2 TR/PL C.F. $105,724.26 $88,671.96 $17,052.30 $0.00 $17,052.30 MTR 3"OMNI T2 TR/PL C.F. $6,146.48 $6,146.48 $0.00 $0.00 $0.00 MTR 4"OMNI C2 TR/PL C.F. $302,093.91 $266,553.45 $35,540.46 $0.00 $35,540.46 MTR 4"OMNI T2 TR/PL C.F. $17,948.64 $20,940.08 -$2,991.44 $0.00 -$2,991.44 MTR 6"OMNI C2 TR/PL C.F. $849,201.00 $812,568.80 $36,632.20 $0.00 $36,632.20 MTR 6"OMNI T2 TR/PL C.F. $26,200.50 $34,060.65 -$7,860.15 $0.00 -$7,860.15 MTR 8"OMNI C2 TR/PL C.F. $496,792.33 $496,791.68 $0.65 $0.00 $0.65 4of7 MyH2O Budget Forecast v2.03102022 MTR 8"OMNI T2 TR/PL C.F. $70,030.65 $70,030.65 $0.00 $0.00 $0.00 MTR 8"OMNI F2 COMPACT TR/PL C.F. $9,480.00 $9,480.00 $0.00 $0.00 $0.00 MTR 10"OMNI C2 TR/PL C.F. $73,753.82 $73,753.72 $0.10 $0.00 $0.10 MTR 10"OMNI T2 TR/PL C.F. $85,641.64 $91,758.90 -$6,117.26 $0.00 -$6,117.26 MTR MXU 520M SmartPoint Single Port $13,783,660.44 $13,770,599.70 $13,060.74 $0.00 $13,060.74 MTR I MXU 520M SmartPoint Single Port(adjusted 04/ $5,939,862.84 $5,856,202.80 $83,660.04 $0.00 $83,660.04 MTR MXU 520M SmartPoint Dual Port $2,332,411.52 $2,530,087.68 -$197,676.16 $0.00 -$197,676.16 MTR IQor Meter Lid Plug $243,750.00 $211,250.00 $32,500.00 $0.00 $32,500.00 MTR Contingency for Meter Count Growth $0.00 $0.00 $0.00 $0.00 $0.00 MTR Meters and SmartPoints $47,734,787.20 $47,768,409.41 -$33,622.21 $0.00 -$33,622.21 Meter&SmartPoint Installation INS Meter Box Lids(seed-stock) $450,489.15 $365,644.38 $84,844.77 $0.00 $84,844.77 5/8"&3/4"Meter&SmartPoint Installation and INS Activation(Approximately 20 Minutes)9,10 $3,349,780.00 $3,349,780.00 $0.00 $0.00 $0.00 5/8"&3/4"Meter&SmartPoint Installation and INS JActivation(adjusted 04/01/2021) $3,061,275.00 $2,777,962.50 $283,312.50 $0.00 $283,312.50 5/8"&3/4"Meter&SmartPoint Installation and INS Activation(adjusted 04/01/2022) $0.00 $134,818.70 -$134,818.70 $0.00 -$134,818.70 1"Meter&SmartPoint Installation and INS Activation(Approximately 20 Minutes)9'10 $443,415.00 $443,415.00 $0.00 $0.00 $0.00 1"Meter&SmartPoint Installation and INS JActivation(adjusted 04/01/2021) $357,112.50 $318,412.50 $38,700.00 $0.00 $38,700.00 1"Meter&SmartPoint Installation and INS Activation(adjusted 04/01/2022) $0.00 $9,387.09 -$9,387.09 $0.00 -$9,387.09 Residential Meter Boxes Vac(Approximately 5 INS Minutes) $14,574.78 $14,574.78 $0.00 $0.00 $0.00 Residential Meter Boxes Vac(Adjusted INS 11/01/2019) $503,536.50 $503,536.50 $0.00 $0.00 $0.00 INS Residential Meter Boxes Vac(as of 04/01/2021) $456,999.90 $429,048.00 $27,951.90 $0.00 $27,951.90 INS Residential Meter Boxes Vac(as of 04/01/2022) $0.00 $0.00 $0.00 $0.00 $0.00 Drill Holes in Cast Iron Meter Box Lids INS I(Approximately 5 Minutes) $2,301,793.57 $2,215,613.76 $86,179.81 $0.00 $86,179.81 Drill Holes in Cast Iron Meter Box Lids(as of INS 04/01/2022.Approximately 5 Minutes) $0.00 $4,189.96 -$4,189.96 $0.00 -$4,189.96 1 1/2"Meter&SmartPoint Installation and INS Activation(Approximately 45 Minutes)9'10 $394,714.32 $394,714.32 $0.00 $0.00 $0.00 1 1/2"Meter&SmartPoint Installation and INS JActivation(adjusted 04/01/2021) $15,200.00 $15,200.00 $0.00 $0.00 $0.00 1 1/2"Meter&SmartPoint Installation and INS Activation(adjusted 04/01/2022) $0.00 $0.00 $0.00 $0.00 $0.00 2"Meter&SmartPoint Installation and INS Activation(Approximately 45 Minutes)9'10 $642,207.15 $642,207.15 $0.00 $0.00 $0.00 2"Meter&SmartPoint Installation and INS JActivation(adjusted 04/01/2021) $32,850.00 $32,850.00 $0.00 $0.00 $0.00 2"Meter&SmartPoint Installation and INS Activation(adjusted 04/01/2022) $0.00 $0.00 $0.00 $0.00 $0.00 3"Meter&SmartPoint Installation and INS Activation(Approximately 75 Minutes)9'10 $30,802.641 $30,802.641 $0.001 $0.001 $0.00 5of7 MyH2O Budget Forecast v2.03102022 3"Meter&SmartPoint Installation and INS Activation(adjusted 04/01/2021) $7,596.59 $5,362.32 $2,234.27 $0.00 $2,234.27 3"Meter&SmartPoint Installation and INS Activation(adjusted 04/01/2022) $0.00 $460.26 -$460.26 $0.00 -$460.26 4"Meter&SmartPoint Installation and INS jActivation(Approximately 75 Minutes)"" $62,803.56 $62,803.56 $0.00 $0.00 $0.00 4"Meter&SmartPoint Installation and INS Activation(adjusted 04/01/2021) $16,171.89 $9,480.05 $6,691.84 $0.00 $6,691.84 4"Meter&SmartPoint Installation and INS Activation(adjusted 04/01/2022) $0.00 $0.00 $0.00 $0.00 $0.00 6"Meter&SmartPoint Installation and INS jActivation(Approximately 75 Minutes)9'10 $171,785.82 $171,785.82 $0.00 $0.00 $0.00 6"Meter&SmartPoint Installation and INS Activation(adjusted 04/01/2021) $23,803.50 $8,727.95 $15,075.55 $0.00 $15,075.55 6"Meter&SmartPoint Installation and INS Activation(adjusted 04/01/2022) $0.00 $817.25 -$817.25 $0.00 -$817.25 8"Meter&SmartPoint Installation and INS jActivation(Approximately 75 Minutes)9"'0 $15,954.15 $15,954.15 $0.00 $0.00 $0.00 8"Meter&SmartPoint Installation and INS Activation(adjusted 04/01/2021) $96,405.74 $93,119.20 $3,286.54 $0.00 $3,286.54 8"Meter&SmartPoint Installation and INS Activation(adjusted 04/01/2022) $0.00 $0.00 $0.00 $0.00 $0.00 10"Meter&SmartPoint Installation and INS jActivation(Approximately 75 Minutes)9"'0 $1,579.55 $1,579.55 $0.00 $0.00 $0.00 10"Meter&SmartPoint Installation and INS Activation(adjusted 04/01/2021) $37,419.54 $26,031.04 $11,388.50 $0.00 $11,388.50 10"Meter&SmartPoint Installation and INS Activation(adjusted 04/01/2022) $0.00 $1,675.74 -$1,675.74 $0.00 -$1,675.74 INS jSmartPoint Installation&Activation Only $2,656,368.75 $2,378,293.75 $278,075.00 $0.00 $278,075.00 SmartPoint Installation&Activation Only INS (adjusted 04/01/2022) $0.00 $451,996.86 -$451,996.86 $0.00 -$451,996.86 INS Reimbursable Dump Fees $4,173.95 $1,263.90 $2,910.05 $0.00 $2,910.05 INS Scrap Meter Value"' -$935,482.80 -$1,088,560.16 $153,077.36 $0.00 $153,077.36 INS Product Staging(Monthly) $481,426.56 $481,426.56 $0.00 $0.00 $0.00 INS Product Staging(Monthly)effective 4/01/21 $180,000.00 $210,000.00 -$30,000.00 $0.00 -$30,000.00 INS Product Staging(Monthly)effective 4/01/22 $46,500.00 $31,000.00 $15,500.00 $0.00 $15,500.00 INS Trip Charge-Replace Lid $4,740.00 $0.00 $4,740.00 $0.00 $4,740.00 INS Trip Charge-Cycle 1 RTU Revisit to Replace Lid $7,800.00 $0.00 $7,800.00 $0.00 $7,800.00 INS Meter and SmartPoint Installation $24,933,797.31 $14,545,375.08 $388,422.23 $0.00 $388,422.23 AMI Components Not Otherwise Specified&Installation Material INS I Flange Kit Installs(1.5"or 2"),including materials $325,375.00 $325,375.00 $0.00 $0.00 $0.00 Flange Kit Installs(1.5"or 2"),including INS materials(adjusted 04/01/2022) $0.00 $0.00 $0.00 $0.00 $0.00 INS Meter Box Resets $119,250.00 $119,250.00 $0.00 $0.00 $0.00 INS Meter Box Resets(adjusted 04/01/2021) $92,584.30 $139,880.00 -$47,295.70 $0.00 -$47,295.70 INS Meter Box Resets(adjusted 04/01/2022) $0.00 $15,802.56 -$15,802.56 $0.00 -$15,802.56 INS Residential Direct Connect $340,556.25 $559,650.00 -$219,093.75 $0.00 -$219,093.75 6of7 MyH2O Budget Forecast v2.03102022 Residential Direct Connect(adjusted INS 04/01/2022) $0.00 $12,035.55 -$12,035.55 $0.00 -$12,035.55 INC Special Job Hours $131,889.26 $131,889.26 $0.00 $0.00 $0.00 INC ISpecial Job Hours(adjusted 04/01/2021) $127,553.90 $42,900.30 $84,653.60 $0.00 $84,653.60 INC Special Job Hours(adjusted 04/01/2022) $0.00 $3,638.48 -$3,638.48 $0.00 -$3,638.48 INS Large Commercial Flange Kits $0.00 $95,780.30 -$95,780.30 $0.00 -$95,780.30 INC lincidentals-Third Party Plumber $0.00 $69,847.78 -$69,847.78 $0.00 -$69,847.78 INC Misc Plumbing Parts $305,545.45 $63,397.65 $242,147.80 $0.00 $242,147.80 INC Installation-Miscellaneous Materials $1,442,754.16 $1,579,446.88 -$136,692.72 $0.00 -$136,692.72 Leak Detection LDS Leak Detection Equipment $0.00 $0.00 $0.00 $0.00 $0.00 LDS Pressure Monitoring System $0.00 $0.00 $0.00 $0.00 $0.00 LDS I Leak Detection $0.00 $0.00 $0.00 $0.00 $0.00 Performance&Payment Bond Performance&Payment Bond $607,581.91 $498,905.25 $108,676.66 $0.00 $498,905.25 Contingency CON Extend Novus Access(6 Months,CO#38) $15,000.00 $15,000.00 $0.00 $0.00 $0.00 AMI Network Propagation Study-Final Coverage CON &Growth(CO#39) $5,000.00 $5,000.00 $0.00 $0.00 $0.00 AMI Network Propagation Study-Add CON I Fleetwood Site &Remove Euless Site(CO#39) $5,000.00 $5,000.00 $0.00 $0.00 $0.00 CON Troubleshooting(CO#40) $90,000.00 $100,140.00 -$10,140.00 $0.00 -$10,140.00 CON Replacement SRII Registers(CO#40) $27,496.00 $27,496.00 $0.00 $0.00 $0.00 CON 1 Meter Splice Kits(CO#40) $7,140.00 $7,140.00 $0.00 $0.00 $0.00 CON Euless Site Repair(CO#41) $18,265.00 $18,265.00 $0.00 $0.00 $0.00 CON M400 Battery(CO#42) $2,872.16 $2,872.16 $0.00 $0.00 $0.00 CON Contingency $482,726.73 $180,913.16 $301,813.57 $0.00 $180,913.16 Total Total $73,480,962.02 $72,887,781.20 $593,180.82 $0.00 $862,509.00 7of7 AFFIDAVIT STATE OF TEXAS COUNTY OF GUADALUPE Before me,the undersigned authority, a Notary Public in the state and county aforesaid, on this day personally appeared Christopher Newville,Manager for Thirkettle Corporation dba Aqua- Metric Sales Company, known by me to be a credible person, who being by me duly sworn,upon his oath deposed and said; That all persons, firms, associations, corporations, or other organizations furnishing labor and/or materials have been paid in full; That there are no claims pending for personal injury and/or property damage; On Contract described as; Advanced Meter Infrastructure Project (MyH2O) CPN CO2715, CSC 48301 Christopher Newville—Manager Subscribed and sworn before me on this Day of_Q::t-,A2ZC 2022. ►"' M Sf Texas Notary ublic in Riverside ounty, CA3-2026-7 �Y AIA Document G707TM - 1994 Consent Of Surety to Final Payment Bond No.: 0773330 PROJECT:(�tanre and address) ARCHITECT'S PROJECT NUMBER: 48301 OWNER: Phases 1 -5 of the City of Fort Worth AMI Program CONTRACT FOR: Construction ARCHITECT: CONTRACTOR: SURETY: TO OWNER:(Name and oddness) CONTRACT DATED: October 14, 2016 OTHER; City of Fort Worth 1000 Throckmorton Fort Worth, Texas 76102 In accordance with the provisions of the Contract between the Owner and the Contractor as indicated above,the (Insert natne and address of Suret ) Harco National Insurance Company 4200 Six Forks Road, Suite 1400 Raleigh, NC 27609 SURETY, on bond of (Insert name and address ofContractot) Thirkettle Corporation dba Aqua-Metric Sales Company 4050 Flat Rock Drive Riverside, CA 92505 CONTRACTOR. hereby approves of the final payment to the Contractor,and agrees that final payment to the Contractor shall not relieve the Surety of any of its obligations to (Insert name and address of Owner) City of Fort Worth 1000 Throckmorton Fort Worth, Texas 76102 OWNER as set forth in said Surety's bond. IN WITNESS WIIGREOI:.the Surety has hereunto set its hand on this date: September 08, 2022 (Insert in writing the inotuh followed Gv the tnuneric date and year.) Harco National Insurance Company Lu (Sigsratzu•e of aztshorised epresetrt rive) xltst: e i - ,Emilie George, Attorne -in-Fact i - g Y (Printed name and title) AIA Document G707T"—1994.Copyright©1982 and 1994 by The American Institute of Architects.All rights reserved.WARNING:This Ate Document is protected by U.S.copyright Law and International Treattes.Unauthorized reproduction or distribution of this AIIA` Document,or any portion of It, 1 may result in severe civil and criminal penalties,and will he prosecuted to the maximum extent possible under the law. j A notary public or other officer c.or;:�i ing this,certificate.verifies only the iderifity of the individual who signed the document I to which this cedificate is atta hed,and not the truthfulness,acctjracvt or vLandi y c that document. State of California Orang 1.e County of- . J. Smith, Notary Public Cara _..$EP_w0.... ..._2.0 ...._.._............... before me ._.._....... ._._ _-. ___.. .. .,. .................._....,. _...........,....,.............. �, . Date ; 1: e Insert Name and Title of the Officer personally appeared W __..Emilie George _...._....._.........._............. ._._.._._.._...._.._.__.._.._.._............._._._....._.. ..._...._........._....._,............,.._.__...... ............_...._._....__._._........._.... .__.__...�...... who proved to me on the basis of satisfactory evidence to be the persons)whose name(s) isiare subscribed to the within instrurnent and acknowiedged to me that hekheithey eicecuted the same in hisihertheir authorized capacity(les),and that by Ns.her,their sign atureis)on the instrument the person(s),or the entity upon behalf of which the person(s)acted,executed the instrument. 1 certify under PENALTY OF PERJURY under the laws of the State of California that the foregoing 90my J.SMITHNotary Pobiic•California }3GisY�ayf<�pta IStrueand correct. orange County WITNESS m hand and official seal. Commission s 2358196 Y Comm.Expires May 19.2025 Signature _... . ._._ !�'....[.......-.1�� Place Pkirary-Seal arid,%or Stainp Above Sig c,tc;re of l�lofury Public. OPTIONAL p i C 0177pietificg this h7formation can deter alteration of the document or 1 froudule."al reattac.;ament of this forma to an unintended document, Description of Attached Document Title or Type of Document: Document Date:� ., _._.�....Number of Pages: Signer(s) Other Than N arracat3 Above: ­,_._.�__. [ � E j ap ity(les) Claimed by Signer(s) Signer's Nrarie: _. _._ _._ _ Signer's Name: t3 Corporate Offic er..,,. T itle(s): o Corporate orate Officer—Title(s) . ._..._...._... �..� 3 Cl Partner_ l Limited u Lei"aerrff 0 Partner - Lif7iiied C ,rr fal individual 0 Attorney in Fact 0 Individual Li Attorney in Fact Trustee rr Guardian or C,tanservator o Trustee ri Gwardian or Conservator 0other: .w._.­.._____ ___ __ n Otl•et: ......._� Signer is Representing: __._._............................... .................................. Signei is Representing: ...................._......_..._.__ w._�.......�._...._._..._.,.. _ 1 % C39�J National Notary Association Bond oa264�� POWER OF ATTORNEY HARCO NATIONAL INSURANCE COMPANY INTERNATIONAL FIDELITY INSURANCE COMPANY Member companies of IAT Insurance Group,Headquartered:4200 Six Forks Rd,Suite 1400, Raleigh, NC 27609 KNOW ALL MEN BY THESE PRESENTS:That HARCO NATIONAL INSURANCE COMPANY,a corporation organized and existing under the laws of the State of Illinois,and INTERNATIONAL FIDELITY INSURANCE COMPANY,a corporation organized and existing under the laws of the State of New Jersey,and having their principal offices located respectively in the cities of Rolling Meadows,Illinois and Newark,New Jersey,do hereby constitute and appoint P. AUSTIN NEFF, EMILIE GEORGE, CHRISTINE HOANG, IRENE LUONG, JAMES W. MOILANEN, YUNG T. MULLICK, DANIELLE HANSON Mission Viejo, CA their true and lawful attorney(s)-in-fact to execute, seal and deliver for and on its behalf as surety, any and all bonds and undertakings, contracts of indemnity and other writings obligatory in the nature thereof,which are or may be allowed,required or permitted by law,statute,rule,regulation,contract or otherwise, and the execution of such instrument(s) in pursuance of these presents, shall be as binding upon the said HARCO NATIONAL INSURANCE COMPANY and INTERNATIONAL FIDELITY INSURANCE COMPANY,as fully and amply,to all intents and purposes,as if the same had been duly executed and acknowledged by their regularly elected officers at their principal offices. This Power of Attorney is executed,and may be revoked,pursuant to and by authority of the By-Laws of HARCO NATIONAL INSURANCE COMPANY and INTERNATIONAL FIDELITY INSURANCE COMPANY and is granted under and by authority of the following resolution adopted by the Board of Directors of INTERNATIONAL FIDELITY INSURANCE COMPANY at a meeting duly held on the 13th day of December,2018 and by the Board of Directors of HARCO NATIONAL INSURANCE COMPANY at a meeting held on the 13th day of December,2018. "RESOLVED, that (1) the Chief Executive Officer, President, Executive Vice President, Senior Vice President, Vice President, or Secretary of the Corporation shall have the power to appoint.and to revoke the appointments of,Attorneys-in-Fact or agents with power and authority as defined or limited in their respective powers of attorney, and to execute on behalf of the Corporation and affix the Corporation's seal thereto, bonds. undertakings, recognizances,contracts of indemnity and other written obligations in the nature thereof or related thereto; and (2)any such Officers of the Corporation may appoint and revoke the appointments of joint-control custodians, agents for acceptance of process. and Attorneys-in-fact with authority to execute waivers and consents on behalf of the Corporation,and(3)the signature of any such Officer of the Corporation and the Corporation's seal may be affixed by facsimile to any power of attorney or certification given for the execution of any bond.undertaking,recognizance,contract of indemnity or other written obligation in the nature thereof or related thereto,such signature and seals when so used whether heretofore or hereafter, being hereby adopted by the Corporation as the original signature of such officer and the original seal of the Corporation,to be valid and binding upon the Corporation with the same force and effect as though manually affixed." IN WITNESS WHEREOF,HARCO NATIONAL INSURANCE COMPANY and INTERNATIONAL FIDELITY INSURANCE COMPANY have each executed and attested these presents on this 31st day of December 2021 �tLl�f1'l ,��11,dtg '•.. SG STATE OF NEW JERSEY STATE OF ILL!NOIS O: c3�Fd4� y Count of Essex ^'•a' u �, Y County of Cook : a o SEAL / _ _ SEAS Kenneth Chapman '<.�i 4 ,• Executive Vice President, Harco National Insurance Company and International Fidelitv Insurance Companv On this 31 st day of December,2021 before me came the individual who executed the preceding instrument,to me personally known,and, being by me duly sworn,said he is the therein described and authorized officer of HARCO NATIONAL INSURANCE COMPANY and INTERNATIONAL FIDELITY INSURANCE COMPANY;that the seals affixed to said instrument are the Corporate Seals of said Companies:that the said Corporate Seals and his signature were duly affixed by order of the Boards of Directors of said Companies. .�,"iM"''. IN TESTIMONY WHEREOF,I have hereunto set my hand affixed my Official Seal.at the City of Newark, 4•0Gj�: New Jersey the day and year first above written. SA0309 S 07910�• �` �, "-"�L� V'�. J6=0��`� Shirelle A.Outley a Notary Public of New Jersey �'`"""`�� CERTIFICATION My Commission Expires April 4,2023 1,the undersigned officer of HARCO NATIONAL INSURANCE COMPANY and INTERNATIONAL FIDELITY INSURANCE COMPANY do hereby certify that I have compared the foregoing copy of the Power of Attorney and affidavit,and the copy of the Sections of the By-Laws of said Companies as set forth in said Power of Attorney,with the originals on file in the home office of said companies,and that the same are correct transcripts thereof,and of the whole of the said originals,and that the said Power of Attorney has not been revoked and is now in full force and effect. IN TESTIMONY WHEREOF,I have hereunto set my hand on this day, September 08,2022 A00964 Mullick&Moilanen Bonding&I Irene Martins,Assistant Secretary Aqua Metric Alamo16914 Parkway,Bldg. 0 •. 00 967-6305 October 14, 2022 City of Fort Worth Water Department 1000 Throckmorton Street Fort Worth,TX 76102 RE: Supplier Warranties MyH2O Advanced Metering Infrastructure Project(MyH2O) CPN CO2715, CSC 48301 To Whom It May Concern: On September 12, 2022, Aqua-Metric Sales Company received the City of Fort Worth's Acceptance letter referencing the aforementioned project. Pursuant to the agreement between the parties, the following warranties, attached hereto,will remain in effect where applicable and through the duration as outlined in each. 1. Sensus AMI System Performance Warranty a. The Sensus AMI System Performance Warranty covers the performance and read interval success of the network communications.The term and conditions are limited to those set forth within the Sensus AMI System Performance Warranty included within Aqua-Metric Support Services Agreement CSC50011 executed on November 28, 2017. 2. Sensus Limited Warranty G-500 a. Product warranties began from the date of Sensus shipment and extend through the term(s) identified for each applicable product respectively. 3. Sensus Extended Warranty Program FlexNetT" Infrastructure a. The Sensus Extended Warranty Program FlexNetT" Infrastructure serves as an extended warranty to each network base stations under the program.This program,which became effective as part of the Aqua-Metric Support Services Agreement CSC50011 on November 28, 2017, shall extend on an annual basis pursuant to Agreement CSC50011 unless and until cancelled by Fort Worth or discontinued by Sensus. 4. City of Fort Worth Mass Warranty—SmartPointT"/SRII® a. The Mass Warranty under Aqua-Metric Support Services Agreement CSC50011, effective November 28, 2017, enacted a three-year term valid through November 28, 2020. The Aqua- Metric Support Services Agreement will survive in full past the expiration of the Mass Warranty and continue to renew on an annual basis in accordance with the terms of that Agreement. 5. Meter Services Warranty a. The Meter Services Warranty covered thirty (30) days from the date of the meter installation/exchange. The mass meter exchange took place between July 1, 2019 through April 26, 2022. The Meter Services Warranty expired on May 26, 2022, or 30 days following the final meter exchange. If you have any questions concerning this letter of Supplier Warranties, please feel free to contact our Texas office at(210) 967-6300. Sincerely, Christopher Newville Manager Aqua-Metric Sales Company FORT WORTH September 12, 2022 Aqua Metric Sales Company Attn: Paul Morrison, Program Manager 16914 Alamo Parkway Bldg 2 Selma, Texas 78154 RE: Acceptance Advanced Meter Infrastructure Project (MyH2O), CPN CO2715, CSC 48301 Dear Mr. Morrison: Acceptance testing for the project was completed June 24, 2022 and a final inspection was conducted on June 30, 2022. Punch list items identified during acceptance testing were completed July 21, 2022. The work meets contractual requirements and is therefore accepted by the City. If you have any questions concerning this letter of acceptance,please feel free to contact me at(817) 392-8209. Sincerely, Suzanne Abbe, PE MyH2O Program Manager CC: Chris Harder, P.E., Director Kara Shuror, Deputy Director Jerry Pressley, P.E., Assistant Director Homero Beltran, Meter Services Superintendent Marty Barker, Meter Services AMI Administrator Taylor Paris, Assistant City Attorney SL Serco, Consultant Aqua Metric, Vendor Project File