HomeMy WebLinkAboutC2025-043 - 4/8/2025 - Approved •bus ct,�
G�
0 ��' Amendment#5
Finance & Procurement
NOflPOPPE�
1852
Date: February 21, 2025
Agreement#: 4090 - Rate Model 2022
Contractor/Consultant: NewGen Strategies and Solutions, LLC
Current Amount: $45,000.00
I. Section 3, Compensation and Payment, of the Agreement, is amended by increasing the amount
$316,080.00, of which $22,000.00 is included for estimated travel expenses, in order to expand
the scope of services necessary to complete a comprehensive rate study determination for the
anticipated FY 2026 rates and obtain consulting services for the City's water and wastewater
systems; therefore, the revised total amount of the Agreement is $406,080.00.
II. Attachment A of the Agreement is supplemented with the addition of Attachment A-5, which is
attached to this Amendment #5 and its content is incorporated by reference into the Agreement
as if fully set out here in its entirety. Attachment A-5 includes the current billing rates and estimated
additional hours that may be needed. Additionally, for clarity, Attachments A-1 and A-4 are
superseded by Attachment A-5; Attachment A-2 is contined in force solely to give effect to the
description of the annual optional extensions and the associated dollar amounts; annual amounts
for the optional extensions; and Attachment A-3 is continued in effect for the purpose of defining
the task order descriptions and deliverables as applied to the rate models for FY 2026.
III. This Amendment #5 is effective upon the date of final execution by the party signing last in time,
unless an earlier date is expressly stated within this document.
To the extent that the provisions of this Amendment #5 conflict with any provisions of the Agreement
and prior amendments, if any, the provisions of this Amendment #5 prevail and govern for all intents
and purposes.
'o l/' ana k�Ard �e�G
04/13/2025 Richard Campbell(Feb 25,2 510:49 CST) 02/25/2025
�Qt.,vt fin...i z nt m•z rnr�
Sergio Villasana Date Contractor Date
Director, Finance & Procurement
Approved as to legal form: M2025-035 ALIthorized By
ElizUbof-h OLUndley 94/09/2025 Council 4/8/2025
Elizabeth Hundley(Apr 9,2025 21:48(fDT)
Assistant City Attorney Date Asa
ATTEST:
Stegha ie Box for IAor 14,2025 0:20 CDT)
Rebecca Huerta
City Secretary
Attachment A-5
Corpus Christi Water
Rate Study for Determination of FY 2026 Rates
i
f Hourly
Billing
Employee Hours Rate Total
Richard Campbell 140 $ 365 51,100
Andy McCartney 448 $ 300 134,400
Tia Carnes 324 $ 200 64,800
Andrea Campbell 196 $ 170 33,320
Steve Doogue 28 $ 225 6,300
Administrative Staff 32 $ 130 4,160
1,168 $ 294,080
Other: Travel Expenses 2 Trips for 3 people @$3,000/Trip $ 6,000
Other: Travel Expenses 8 Trips for 2 people @$2,000/Trip $ 16,000
$ 316,080
Tasks
1 -Project Initiation and Project Management
2-Update Consumption and Revenue Analysis
3-Update Multi-Year Financial Plan
4-Water&Wastewater Cost of Service
5-Rate Design and Benchmarking
6-Public Involvement and City Council Meetings(with Presentations)
7-Report
Tasks by Hours
Employee Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 Task 7 Hours
Richard Campbell 4 - - 2 2 124 8 140
Andy McCartney 80 4 16 20 16 264 48 448
Tia Carnes 24 28 56 56 56 56 48 324
Andrea Campbell 16 24 44 40 40 16 16 196
Steve Doogue - 28 - - - - - 28
Administrative Staff - - - - - 16 16 32
124 84 116 118 114 476 136 1,168
Tasks by Dollars
Employee Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 Task 7 Total
Richard Campbell 1,460 - - 730 730 45,260 2,920 $ 51,100
Andy McCartney 24,000 1,200 4,800 6,000 4,800 79,200 14,400 $ 134,400
Tia Carnes 4,800 5,600 11,200 11,200 11,200 11,200 9,600 $ 64,800
Andrea Campbell 2,720 4,080 7,480 6,800 6,800 2,720 2,720 $ 33,320
Steve Doogue - 6,300 - - - - - $ 6,300
Administrative Staff - - - - - 2,080 2,080 $ 4,160
$ 32,980 $ 17,180 $ 23,480 $ 24,730 $ 23,530 $140,460 $ 31,720 $ 294,080
Effective Hourly Rate $ 265.97 $ 204.52 $ 202.41 $ 209.58 $ 206.40 $ 295.08 $ 233.24 $ 251.78
Page 1 of 1