Agenda packet, first session — Modesto City Council, January 10, 2023 (part 3 of 5)

Fleet Additions and Replacements:

IFB Vehicle
#
Description Dept. Year of
Vehicle
Meter Repair
Cost
2223-07 Addition Compact
Sweeper
PW – Street
Maintenance

N/A N/A N/A
This new vehicle will be utilized to support the Slurry Seal program to prepare designated areas and to clean-up debris from the impacts from this program.

IFB Vehicle # Description Dept. Year of
Vehicle
Meter Repair
Cost
40501 One-Ton Truck
Turner Valve
UTL – Water
Quality
2005 106,250 $68,811
40502 One-Ton Truck
Turner Valve
UTL – Water
Quality
2005 97,336 $92,653
2223-16
40156 One-Ton Truck
Turner Valve
UTL –
Environmental
Services
2001 23,632 $23,632
These trucks are used by the Water division to exercise all the City of Modesto fresh water valves in the City. These trucks have equipment to exercise valves throughout the City to remain in compliance with water codes and regulations.

IFB Vehicle
#
Description Dept. Year of
Vehicle
Meter Repair
Cost
41339 Truck 60.0
Vacuum 3 Axle
UTL – Stormwater
Collections
2223-24 2013 47,032 $181,525
41340 Truck 60.0
Vacuum 3 Axle
UTL – Stormwater
Collections
2013 48,199 $160,191
These vacuum trucks are used for cleaning out sewer systems and drains, these are also used in hydro-excavating activities to repair sub-terrain facilities.

DISCUSSION:

Invitation for Bid (IFB) 2223-07 – One (1) Compact Sweeper On August 12, 2021, Sourcewell issued Request for Proposals (RFP) #093021 under Contract #093021-FAY for Street Sweepers and Specialty Sweepers, with Related Equipment, Accessories, and Supplies on the Sourcewell Procurement Portal and New York State Contract Reporter website, DJC Oregon, and Oklahoman. On September 30, 2021, proposals were conducted electronically through the Sourcewell Procurement Portals. Twenty-two (22) proposals were received and based on the Sourcewell Proposal Review Committee and criteria outlines in the RFP, six (6) contracts were awarded for this commodity which includes the Compact Sweeper. Based on the responsible and responsible proposer offering the best overall quality, selection of equipment and price, City staff recommends to award to Municipal Maintenance Equipment, Sacramento, CA to purchase one (1) Ravo 5-iSeries Compact Sweeper for an amount not to exceed $336,152.

Invitation for Bid (IFB) 2223-16 – Three (3) One-Ton Truck Turner Valve On August 12, 2021, Sourcewell issued Request for Proposals (RFP) #091521 under Contract #0191521-NAF for Automobiles, SUV, Vans, and Light Trucks with related equipment and #16..
- 413 -
City Council, January 10, 2023
Fleet Addition and Replacement Vehicles - one (1) Compact Sweeper, three (3) One-Ton Truck Turner Valve, and two (2) Vacuum 3 Axle Truck

Page 3 of 4 ends

accessories on the Sourcewell Procurement Portal and New York State Contract Reporter website, DJC Oregon, and Oklahoman. On September 15, 2021, proposals were conducted at the Sourcewell Procurement office in Staples, MN. Seventeen (17) proposals were received and based on the Sourcewell Proposal Review Committee and criteria outlines in the RFP, one contract was awarded for this commodity which includes the three (3) One-Ton Truck Turner Valve. Based on the responsible and responsible proposer offering the best overall quality, selection of equipment and price, City staff recommends to award to 72 Hour LLC doing business as (dba) National Auto Fleet Group, Watsonville, CA to purchase three (3) One-Ton Truck Turner Valve for an amount not to exceed $720,372.

Invitation for Bid (IFB) 2223-24 – Two (2) Vacuum 3 Axle Trucks On August 24, 2021, Sourcewell issued Request for Proposals (RFP) #101221 under Contract #101221-VAC for Sewer Cleaning, Hydro-Excavation, Municipal Pumping Equipment with related Accessories and Supplies on the Sourcewell Procurement Portal and New York State Contract Reporter website, DJC Oregon, State of Oklahoma, USA Today, and Public Purchase.

On October 12, 2021, proposals were conducted at the Sourcewell Procurement office in Staples, MN. Twenty-two (22) proposals were received and based on the Sourcewell Proposal Review Committee and criteria outlines in the RFP, nine contracts were awarded for this commodity which includes the Vacuum 3 Axle Trucks. Based on the responsible and responsible proposer offering the best overall quality, selection of equipment and price, City staff recommends to award to Municipal Maintenance Equipment, Sacramento, CA to purchase two (2) Vacuum 3 Axle Trucks for an amount not to exceed $1,296,449.

Sourcewell is a cooperative agreement to streamline the procurement process by developing RFBs or RFPs for national competitive solicitations that meet or exceed local requirements.

The competitive process is continually refined to best meet agency needs and allows Sourcewell to offer exceptional products from nationally acclaimed vendors.

City staff is recommending to apply a change order of up to 15% in case any market changes occur between the timeframe of when the order is placed with the vendor and when the production of the vehicle is completed. With current inflation and the volatile vehicle market, City staff will ensure any prices increases requested by the vendor align with the market change based on using the Commodities Research Unit indexes which focuses on indexes related to steel1.

Modesto Municipal Code Section 8-3.203 generally requires all purchases that meet or exceed $50,000 for material, equipment, or contractual services to be formally bid. However, exceptions to the formal bidding process are granted in MMC 8-3.204(d) “Where the Purchasing Manager, in her discretion, determines that a process other than the formal bid procedure set for in Section 8-3.203 will result in a procurement for the City at the lowest possible cost commensurate with the desired quality.” In addition, MMC 8-3.202(h) encourages the Purchasing Manager to join with the State of California or other units of government in cooperative purchasing plans when the best cost savings interest of the City would be served.

By utilizing the Sourcewell, the City is complying with the requirements defined under this code for these Fleet vehicle purchases.
1 https://www.crugroup.com/prices/steel/
#16..
- 414 -
City Council, January 10, 2023
Fleet Addition and Replacement Vehicles - one (1) Compact Sweeper, three (3) One-Ton Truck Turner Valve, and two (2) Vacuum 3 Axle Truck

Page 4 of 4 ends

FISCAL IMPACT:

Sufficient funds for the three (3) One-Ton Truck Turner Valve, and two (2) Vacuum 3 Axle Truck are budgeted in Fiscal Year 22-23 in the Fleet Replacement Fund. The addition of the one (1) Compact Sweeper is budgeted in Fiscal Year 22-23 in the Surface Transportation Fund utilizing Gas Tax funds.

COMMITTEE RECOMMENDATION:

This item was presented at the October 25, 2021 Finance Committee to capture all City vehicle additions and replacements through Fiscal Year (FY) 2021-22 which included the three (3) OneTon Truck Turner Valve and at the December 14, 2022 Finance Committee this item captured FY 2022-23 City vehicle additions and replacements which included the one (1) Compact Sweeper and two (2) Vacuum 3 Axle Trucks.

RECOMMENDED COUNCIL ACTION:

Staff Recommendations:

Resolution approving the Competitive Bidding Process from Sourcewell with Municipal Maintenance Equipment, Sacramento, CA for one (1) Ravo 5-iSeries Compact Sweeper for an amount not to exceed $336,152; and authorizing the Purchasing Manager, or her designee, to issue the Purchase Order; and authorizing the Purchasing Manager or her designee to execute any Change Orders not to exceed 15% of the total purchase price.

Resolution approving the Competitive Bidding Process from Sourcewell with 72 Hour LLC doing business as (dba) National Auto Fleet Group, Watsonville, CA to purchase three (3) One-Ton Truck Turner Valve for an amount not to exceed $720,372; and authorizing the Purchasing Manager, or her designee, to issue the Purchase Order; and authorizing the Purchasing Manager or her designee to execute any Change Orders not to exceed 15% of the total purchase price.

Resolution approving the Competitive Bidding Process from Sourcewell with Municipal Maintenance Equipment, Sacramento, CA to purchase two (2) Vacuum 3 Axle Trucks for an amount not to exceed $1,296,449; and authorizing the Purchasing Manager, or her designee, to issue the Purchase Order; and authorizing the Purchasing Manager or her designee to execute any Change Orders not to exceed 15% of the total purchase price.

Approved by:

DeAnna Christensen, Director of Finance
Joseph P. Lopez, City Manager
Attachments:

1. Resolution (3)

2. Quote – MME Compact Sweeper and Cost Abstract

3. Quote – National Auto Fleet Group and Cost Abstract

4. Quote – MME Two Vacuum Trucks and Cost Abstract
#16..
- 415 -
1 MODESTO CITY COUNCIL
RESOLUTION NO. 2023-

RESOLUTION APPROVING THE COMPETITIVE BIDDING PROCESS FROM

SOURCEWELL WITH MUNICIPAL MAINTENANCE EQUIPMENT,
SACRAMENTO, CA FOR ONE (1) RAVO 5-ISERIES COMPACT SWEEPER FOR AN AMOUNT NOT TO EXCEED $336,152; AND AUTHORIZING THE

PURCHASING MANAGER, OR HER DESIGNEE, TO ISSUE THE PURCHASE ORDER; AND AUTHORIZING THE PURCHASING MANAGER OR HER
DESIGNEE TO EXECUTE ANY CHANGE ORDER NOT TO EXCEEED 15% OF

THE TOTAL PURCHASE PRICE
WHEREAS, every year, City vehicles and equipment are individually evaluated based on their age, condition, mileage, and maintenance costs; and WHEREAS, throughout the fiscal year, new vehicles need to be added to the City’s Fleet inventory due to the operational needs of City departments; when these vehicles are added to the fleet, they are also added to the Fleet Replacement list to prepare for future replacement; and
WHEREAS, on August 12, 2021, Sourcewell issued Request for Proposals (RFP) #093021 under Contract #093021-FAY for Street Sweepers and Specialty Sweepers, with Related Equipment, Accessories, and Supplies on the Sourcewell Procurement Portal and New York State Contract Reporter website, DJC Oregon, and Oklahoman; and WHEREAS, on September 30, 2021, proposals were formally opened electronically; and
WHEREAS, twenty-two (22) proposals were received and based on the Sourcewell Proposal Review Committee and criteria outlines in the RFP, six contracts were awarded for Street Sweepers and Specialty Sweepers, with Related Equipment, Accessories, and Supplies which includes the Compact Sweeper; and #16..
- 416 -
2 WHEREAS, the use of state contracts are cooperative agreements to streamline the procurement process by developing RFBs or RFP’s for national competitive solicitations that meet or exceed local requirements; and WHEREAS, Modesto Municipal Code Section 8-3.203 generally requires all purchases that meet or exceed $50,000 for material, equipment or contractual services to be formally bid. However, exceptions to the formal bidding process are granted in MMC 8-3.204(d) “Where the Purchasing Manager, in her discretion, determines that a process other than the formal bid procedure set for in Section 8-3.203 will result in a procurement for the City at the lowest possible cost commensurate with the desired quality”; and WHEREAS, MMC 8-3.202(h) encourages the Purchasing Manager to join with the State of California or other units of government in cooperative purchasing plans when the best cost savings interest of the City would be served.

NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves the competitive bidding process from Sourcewell with Municipal Maintenance Equipment, Sacramento, CA for one (1) Ravo 5-iSeries Compact Sweeper for an amount not to exceed $336,152.

BE IT FURTHER RESOLVED that the Purchasing Manager, or her designee, is hereby authorized to execute the Purchase Order.

BE IT FURTHER RESOLVED that the Purchasing Manager or her designee to execute any change orders not to exceed 15% of the total purchase price. #16..
- 417 -
3 The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 10th day of January 2023, by Councilmember ________, who moved its adoption, which motion being duly seconded by Councilmember ______, was upon roll call carried and the resolution adopted by the following vote:

AYES: Councilmembers:

NOES: Councilmembers:

ABSENT: Councilmembers:

ATTEST: _____________________________
DIANE NAYARES-PEREZ, CMC, City Clerk
(SEAL)
APPROVED AS TO FORM:

BY: _____________________________
JOSE M. SANCHEZ, City Attorney
#16..
- 418 -
1 MODESTO CITY COUNCIL
RESOLUTION NO. 2023-

RESOLUTION APPROVING THE COMPETITIVE BIDDING PROCESS FROM SOURCEWELL WITH 72 HOUR LLC DOING BUSINESS AS (dba) NATIONAL AUTO FLEET GROUP, WATSONVILLE, CA TO PURCHASE THREE (3) ONETON TRUCK TURNER VALVE FOR AN AMOUNT NOT TO EXCEED $720,372;

AND AUTHORIZING THE PURCHASING MANAGER, OR HER DESIGNEE, TO ISSUE THE PURCHASE ORDER; AND AUTHORIZING THE

PURCHASING MANAGER OR HER DESIGNEE TO EXECUTE ANY CHANGE ORDER NOT TO EXCEEED 15% OF THE TOTAL PURCHASE PRICE
WHEREAS, every year, City vehicles and equipment are individually evaluated based on their age, condition, mileage, and maintenance costs; and WHEREAS, once a unit is replaced and placed into City service, funds for its replacement are charged out as monthly recurring charges until the end of the unit’s service life; and
WHEREAS, on August 12, 2021, Sourcewell issued Request for Proposals (RFP) #091521 under Contract #0191521-NAF for Automobiles, SUV, Vans, and Light Trucks with related equipment and accessories on the Sourcewell Procurement Portal and New York State Contract Reporter website, DJC Oregon, and Oklahoman; and WHEREAS, on September 15, 2021, proposals were formally opened; and WHEREAS, seventeen (17) proposals were received and based on the Sourcewell Proposal Review Committee and criteria outlines in the RFP, one contract was awarded for Automobiles, SUV, Vans, and Light Trucks with related equipment and accessories which includes the One-Ton Truck Turner Valve; and
WHEREAS, the use of state contracts are cooperative agreements to streamline the procurement process by developing RFBs or RFP’s for national competitive solicitations that meet or exceed local requirements; and #16..
- 419 -
2 WHEREAS, Modesto Municipal Code Section 8-3.203 generally requires all purchases that meet or exceed $50,000 for material, equipment or contractual services to be formally bid. However, exceptions to the formal bidding process are granted in MMC 8-3.204(d) “Where the Purchasing Manager, in her discretion, determines that a process other than the formal bid procedure set for in Section 8-3.203 will result in a procurement for the City at the lowest possible cost commensurate with the desired quality”; and WHEREAS, MMC 8-3.202(h) encourages the Purchasing Manager to join with the State of California or other units of government in cooperative purchasing plans when the best cost savings interest of the City would be served.

NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves the competitive bidding process from Sourcewell with 72 Hour LLC doing business as (dba) National Auto Fleet Group, Watsonville, CA to purchase three (3) One-Ton Truck Turner Valve for an amount not to exceed $720,372.

BE IT FURTHER RESOLVED that the Purchasing Manager, or her designee, is hereby authorized to execute the Purchase Order.

BE IT FURTHER RESOLVED that the Purchasing Manager or her designee to execute any change orders not to exceed 15% of the total purchase price. #16..
- 420 -
3 The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 10th day of January 2023, by Councilmember ________, who moved its adoption, which motion being duly seconded by Councilmember ______, was upon roll call carried and the resolution adopted by the following vote:

AYES: Councilmembers:

NOES: Councilmembers:

ABSENT: Councilmembers:

ATTEST: _____________________________
DIANE NAYARES-PEREZ, CMC, City Clerk
(SEAL)
APPROVED AS TO FORM:

BY: _____________________________
JOSE M. SANCHEZ, City Attorney
#16..
- 421 -
1 MODESTO CITY COUNCIL
RESOLUTION NO. 2023-

RESOLUTION APPROVING THE COMPETITIVE BIDDING PROCESS FROM

SOURCEWELL WITH MUNICIPAL MAINTENANCE EQUIPMENT,
SACRAMENTO, CA TO PURCHASE TWO (2) VACUUM 3 AXLE TRUCKS FOR AN AMOUNT NOT TO EXCEED $1,296,449; AND AUTHORIZING THE

PURCHASING MANAGER, OR HER DESIGNEE, TO ISSUE THE PURCHASE ORDER; AND AUTHORIZING THE PURCHASING MANAGER OR HER
DESIGNEE TO EXECUTE ANY CHANGE ORDER NOT TO EXCEEED 15% OF

THE TOTAL PURCHASE PRICE
WHEREAS, every year, City vehicles and equipment are individually evaluated based on their age, condition, mileage, and maintenance costs; and WHEREAS, throughout the fiscal year, new vehicles need to be added to the City’s Fleet inventory due to the operational needs of City departments; when these vehicles are added to the fleet, they are also added to the Fleet Replacement list to prepare for future replacement; and
WHEREAS, on August 24, 2021, Sourcewell issued Request for Proposals (RFP) #101221 under Contract #101221-VAC for Sewer Cleaning, Hydro-Excavation, Municipal Pumping Equipment with related Accessories and Supplies on the Sourcewell Procurement Portal and New York State Contract Reporter website, DJC Oregon, State of Oklahoma, USA Today, and Public Purchase; and
WHEREAS, on October 12, 2021, proposals were formally opened; and WHEREAS, twenty-two (22) proposals were received and based on the Sourcewell Proposal Review Committee and criteria outlines in the RFP, nine contracts were awarded for Sewer Cleaning, Hydro-Excavation, Municipal Pumping Equipment with related Accessories and Supplies which includes the Vacuum 3 Axle Trucks; and #16..
- 422 -
2 WHEREAS, the use of state contracts are cooperative agreements to streamline the procurement process by developing RFBs or RFP’s for national competitive solicitations that meet or exceed local requirements; and WHEREAS, Modesto Municipal Code Section 8-3.203 generally requires all purchases that meet or exceed $50,000 for material, equipment or contractual services to be formally bid. However, exceptions to the formal bidding process are granted in MMC 8-3.204(d) “Where the Purchasing Manager, in her discretion, determines that a process other than the formal bid procedure set for in Section 8-3.203 will result in a procurement for the City at the lowest possible cost commensurate with the desired quality”; and WHEREAS, MMC 8-3.202(h) encourages the Purchasing Manager to join with the State of California or other units of government in cooperative purchasing plans when the best cost savings interest of the City would be served.

NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves the competitive bidding process from Sourcewell with Municipal Maintenance Equipment, Sacramento, CA to purchase two (2) Vacuum 3 Axle Trucks for an amount not to exceed $1,296,449.

BE IT FURTHER RESOLVED that the Purchasing Manager, or her designee, is hereby authorized to execute the Purchase Order.

BE IT FURTHER RESOLVED that the Purchasing Manager or her designee to execute any change orders not to exceed 15% of the total purchase price. #16..
- 423 -
3 The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 10th day of January 2023, by Councilmember ________, who moved its adoption, which motion being duly seconded by Councilmember ______, was upon roll call carried and the resolution adopted by the following vote:

AYES: Councilmembers:

NOES: Councilmembers:

ABSENT: Councilmembers:

ATTEST: _____________________________
DIANE NAYARES-PEREZ, CMC, City Clerk
(SEAL)
APPROVED AS TO FORM:

BY: _____________________________
JOSE M. SANCHEZ, City Attorney
#16..
- 424 -
#16..
- 425 -
#16..
- 426 -
#16..
- 427 -
Aebi Schmidt North
America dba MͲB
Companies, Inc. Aries Industries, Inc. Bonnell Industries Inc Bucher Municipal North
America Curbtender, Inc. Cyclone Technology LLC
DuCo, LLC (Schwarze
Industries, Inc.)
Elgin Sweeper Co. (Division
of Federal Signal Corp.)
Possible Points
Conformance to RFP
Requirements 50 43 - 43 43 42 39 44 41
Pricing 400 333 - 323 330 336 279 331 330Financial Viability and Marketplace Success 75 63 - 62 64 60 62 66 61
Ability to Sell and Deliver
Service 100 76 - 78 81 82 71 87 82
Marketing Plan 50 42 - 43 38 43 36 43 39Value Added Attributes 75 67 - 62 65 59 53 66 61Warranty 50 41 - 40 44 45 41 42 42Depth and Breadth of Offered Equipment, Products, or
Services 200 156 - 139 161 157 146 175 167
Total Points 1,000 821 0 790 826 824 727 854 823
Rank Order 8 22 10.5 4 5 16.5 2 6.5
Exprolink Inc.

FAYAT Environmental
Solutions Americas (RAVO
Holding BV)
Global Environmental
Products, Inc Gradall Industries, Inc. Holms, Inc. Hughes Ventures, Inc. Nescon LLC Nilfisk, Inc.

Possible Points
Conformance to RFP
Requirements 50 45 43 39 41 35 35 39 39
Pricing 400 350 331 334 315 240 259 300 301Financial Viability and Marketplace Success 75 66 65 63 64 51 49 52 57
Ability to Sell and Deliver
Service 100 87 82 84 85 65 56 68 65
Marketing Plan 50 45 42 39 37 28 32 36 34Value Added Attributes 75 62 67 63 59 47 50 61 58Warranty 50 42 44 41 42 42 38 40 42Depth and Breadth of Offered Equipment, Products, or
Services 200 164 149 168 147 126 129 131 126
Total Points 1,000 861 823 831 790 634 648 727 722
Rank Order 1 6.5 3 10.5 21 20 16.5 18
ODRA, LLC (Challenger
Manufactureing, Ltd.)
ROOTS MULTICLEAN INC.

VICTORY SWEEPERS

DIVISION
Stepp Manufacturing
Company Inc Triverus LLC Trombia Technologies TYMCO, Inc.

Possible Points
Conformance to RFP
Requirements 50 43 39 35 41 40 38
Pricing 400 320 321 323 254 312 297Financial Viability and Marketplace Success 75 64 55 58 54 58 55
Ability to Sell and Deliver
Service 100 83 61 75 60 69 70
Marketing Plan 50 41 35 38 36 41 34Value Added Attributes 75 59 56 49 62 62 63Warranty 50 44 38 38 40 41 40Depth and Breadth of Offered Equipment, Products, or
Services 200 139 161 113 126 138 161
Total Points 1,000 793 766 729 673 761 758
Rank Order 91215191314
Kim Austin, MBA, CPPB, Procurement Lead Analyst Bill Davison, CPPO, NIGP-CPP, Procurement Analyst Brandon Town, CPSM, CPSD, Procurement Analyst Michael Muñoz, CPPB, Procurement Analyst Proposal Evaluation
Street Sweepers and Specialty Sweepers, with Related Equipment, Accessories, and Supplies RFP #093021

#16..
- 428 -
#16..
- 429 -
#16..
- 430 -
#16..
- 431 -
#16..
- 432 -
#16..
- 433 -
#16..
- 434 -
#16..
- 435 -
#16..
- 436 -
#16..
- 437 -
#16..
- 438 -
#16..
- 439 -
#16..
- 440 -
#16..
- 441 -
#16..
- 442 -
#16..
- 443 -
#16..
- 444 -
#16..
- 445 -
#16..
- 446 -
72 HOUR, LLC dba
National Auto Fleet
Group

CONTEMPORARY
MOTOR CARS, INC. Creative Bus Sales, Inc.

Davis Chevrolet, GMC,
Buick, Ltd. Donlen, LLC
GreenPower Motor
Company, Inc.

Lithia Toyota of Billings
II, LLC Lordstown Motors Corp.

Mike Albert Leasing,
Inc.

RO Truck & Equipment
LLC DBA RO Bus Sales Tesla, Inc. TROPICAL FORD, INC.

VALLEY FORD TRUCK,
INC.

Possible Points
Conformance to Terms/
Conditions to Include
Documentation 50 46 33 38 34 38 34 37 36 35 40 38 41 Pricing 400 355 244 298 240 268 268 264 259 255 260 301 314 Financial, Industry and
Marketplace Successes 75 66 56 63 47 49 50 46 55 58 60 55 64 Bidder's Ability to Sell/ Service
Contract Nationally 100 84 66 79 60 72 70 59 70 64 82 65 77 Bidder's Marketing Plan 50 47 31 40 26 31 29 36 36 34 34 36 40 Value Added Attributes 75 61 43 45 49 58 49 64 49 48 65 56 53 Warranty Coverages and
Information 50 43 37 40 38 39 41 41 38 38 44 41 39 Depth and Breadth of Offered
Equipment, Products, or
Services 200 176 134 146 155 154 149 133 156 156 143 160 166 Total Points 1,000 878 644 749 649 709 690 680 699 688 728 752 794 Rank Order 1 12 4116 8 1079532
_____________________________________________________ _____________________________________________ _______________________________ ___________________________________ James Voelker, CPCM, CFCM, Procurement Lead Analyst Stephanie Haataja, CPIM, Procurement Analyst Craig West, Procurement Analyst Tom Sharbonno, Procurement Analyst Proposal Evaluation
Automobiles, SUVs, Vans, and Light Trucks with Related Equipment and Accessories RFP #091521

#16..
- 447 -
#16..
- 448 -
#16..
- 449 -
#16..
- 450 -
#16..
- 451 -
#16..
- 452 -
Aries Industries, Inc. Badger Daylighting CUES, Inc. Deep Trekker DuCo, LLC (VacͲCon, Inc.) Elgin Sweeper Co. (Vactor
Manufacturing, a Division
of Federal Signal) GapVax, Inc. Garsite Progress, LLC Gradall Industries, Inc. Holland Pump Company Hurco Technologies, Inc.

Possible Points
Conformance to RFP
Requirements 50 44 42 43 39 42 41 39
Pricing 400 340 346 340 305 307 340 338
Financial Viability and
Marketplace Success 75 66 64 64 54 66 56 60
Ability to Sell and Deliver
Service 100 89 84 80 76 84 70 67
Marketing Plan 50 45 41 42 39 41 38 40
Value Added Attributes 75 67 63 67 54 59 61 56
Warranty 50 41 41 39 40 40 41 40
Depth and Breadth of
Offered Equipment,
Products, or Services 200 179 170 161 144 159 159 144
Total Points 1,000 871 851 836 751 798 806 784Rank Order 1 3 414 8 611 Kaiser Premier, LLC Park Pumps & Controls RingͲOͲMatic
Sewer Equipment Co. of
America Stetco Group, LLC Super Products, LLC
Texas Underground, Inc.
dba Pipehunter, Inc.

Thompson Pump and
Manufacturing Company,
Inc.

Visual Imaging Resources,
LLC dba VIR Proteus
Wachs Utility Products
(Illinois Tool Works)
WasteWater Solutions,
LLC
Possible Points
Conformance to RFP
Requirements 50 40 33 41 44 38 40 39 43 40
Pricing 400 311 238 333 341 328 311 279 310 314
Financial Viability and
Marketplace Success 75 58 49 60 68 56 63 60 64 64
Ability to Sell and Deliver
Service 100 75 58 82 86 68 78 71 84 77
Marketing Plan 50 41 24 40 44 40 40 39 42 36
Value Added Attributes 75 55 48 61 69 53 59 53 68 61Warranty 50 40 37 40 41 39 40 40 40 38 Depth and Breadth of
Offered Equipment,Products, or Services 200 150 145 178 173 135 160 165 148 158 Total Points 1,000 770 632 835 866 757 791 746 799 788
Rank Order 12 16 5 213 9157 10
Greg Grunig, Procurement Lead Analyst Carol Jackson, Procurement Analyst Craig West, Procurement Analyst Nick Scholer, Procurement Analyst Sewer Vacuum, HydroͲExcavation, and Municipal Pumping Equipment with Related Accessories and Supplies RFP #101221 Proposal Evaluation

#16..
- 453 -

CITY OF MODESTO

COUNCIL AGENDA REPORT
DATE OF MEETING:

January 10, 2023
Date: December 15, 2022
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
SUBJECT: Grant Management Software Subscription Agreement CONTACT: Cynthia Kline, Purchasing Manager, [email protected], 209-577-5412 DESCRIPTION:

Consider approving the Purchase of a Grant Management Software Subscription with Carahsoft Technology Corporation, Reston, VA (dba) eCivis in the amount of $295,685 over five years. (Funding Source: Information Technology Fund)
STRATEGIC PLAN ELEMENT:

This item advances the City of Modesto 2020-2025 Strategic Plan Area: Governance and Service Delivery: “build community trust in City government through responsive, transparent and efficient service delivery”; Goal J: “build a high-performance organization”.

BACKGROUND:

City departments actively pursue new grant applications to receive funding from federal, state, and local agencies. City staff utilizes resources through government newsletters they have subscribed to, such as Department of Housing, Department of Transportation, State Water Resources Control Board, Department of Justice and other professional government associations. City departments have staff assigned to monitor these grant application notices to determine if the City meets the required qualifications to apply for the available grants.

The City receives total grant awards ranging from $80 to $100 million annually from various state and federal grant agencies. This annual amount does not include the additional funding of $45.9 million in American Rescue Act funding received due to the fiscal impacts generated from COVID-19. City staff utilizes a variety of existing software tools to manage grant compliance requirements defined under these grants, but none of these tools are centralized under one software.

Under Administrative Directive 7.2 Grant Management policy, this policy defines the grant management process and steps to establish better controls on local match requirements, including potential future costs which could be required as part of a grant agreement. The Finance Department prepares and presents to Council a bi-monthly informational report on both grant applications and awards authorized by the Director of Finance, the City Manager and #17..
- 454 -
City Council, January 10, 2023
Grant Management Software Subscription Agreement

Page 2 of 4 ends

Council. The Finance Department has established internal grant application forms to manage the types of grants being applied for and are used to ensure local match requirements will be managed within our current budget. Preparing this report is a manual process that involves collecting, tracking and preparing a list of all grants application and awards to share with the public and City Council.

DISCUSSION:

The Finance Department coordinated with all City departments involved in the grant process to develop an evaluation team to determine what grant management software tools are available for local governments. This evaluation team conducted several demos to determine if there was a software tool that would address some of the inefficiencies in our current processes. Based on this review, there was one grant management software which was highly recommended by several local governments (City of Tracy, City of Los Angeles, City of Raleigh) of smaller, similar and larger size to Modesto called eCivis.

The eCivis solution has been serving local governments for over 20 years and serves over 400 local governments across the nation. They work closely with local governments and grant agencies to ensure their software addresses the needs of grant compliance and focuses on public sector government. Some key areas of benefits for the City of Modesto in utilizing this software include the following:
 Captures the full lifecycle of grants from the application to close-out of grant  Includes support to identify grants for City departments to apply for  Imports financial data from the City’s Enterprise Resource System (ERP) to manage the programmatic and fiscal grant data into one centralized system  Centralizes and automates key grant tasks for the full post grant award  Report capabilities to pull a list of grant applications and awards for all City departments
 Establishes a platform to share this centralized grant data through our public website
On November 19, 2019, Region 4 Education Service Center, Houston TX issued Request for Proposals (RFP) 19019 for an Educational Grant Management Solution on their public bidding website and various newspapers and daily business journals. On February 5, 2020, proposals were awarded for this state contract through OMNIA partners. Three hundred and one (301) companies downloaded the RFP. Nine (9) proposals were received and based on the Proposal Selection Committee and criteria outlines in the RFP, three (3) companies were awarded this contract and eCivis were ranked as one of top scorer for this contract Grant Management Solution. The recommendations provided by their Selection Committee was aligned with the same information gathered from the City evaluation team.

OMNIA Partners is the cooperative purchasing organization that with his extensive scope of competitively-solicited local government contracts from world-class suppliers streamlines the purchasing process and helps local government agencies achieve their procurement needs and still ensure the competitive bidding requirements are met. All local government purchasing cooperative contracts from OMNIA Partners have been competitively solicited by a lead public agency and meet the public cooperative standards.
#17..
- 455 -
City Council, January 10, 2023
Grant Management Software Subscription Agreement

Page 3 of 4 ends

Modesto Municipal Code Section 8-3.203 generally requires all purchases that meet or exceed $50,000 for material, equipment or contractual services to be formally bid. However, exceptions to the formal bidding process are granted in MMC 8-3.204(d) “Where the Purchasing Manager, in her discretion, determines that a process other than the formal bid procedure set for in Section 8-3.203 will result in a procurement for the City at the lowest possible cost commensurate with the desired quality.” In addition, MMC 8-3.202(h) encourages the Purchasing Manager to join with the State of California or other units of government in cooperative purchasing plans when the best cost savings interest of the City would be served.

By utilizing this government agencies bidding process, the City is complying with the requirements defined under this code.

FISCAL IMPACT:

The City will allocate first year funding based on allocating funds to all City departments through the Information Technology Internal Service fund model. This cost would be allocated to all City departments based on grant applications and awards established under each department.

Based on the Fiscal Year 2021-22 grant activity, the allocation of this cost is estimated below but this allocation is subject to change due to the grant activity every fiscal year. This agreement does include a 5% increase each year throughout the five-year agreement.

Funding Source Estimated Allocation
Airport 2%
Capital Improvement Fund 45%
General Fund 33%
Housing Urban Development 5%
Parking Fund 2%
Solid Waste 10%
Utility Funds 3%
Total 100%
COMMITTEE RECOMMENDATION:

This item was presented at the December 14, 2022 Finance Committee and approved to move forward to Council.

RECOMMENDED COUNCIL ACTION:

Staff Recommendations:

Resolution approving the Purchase of a Grant Management Software Subscription with Carahsoft Technology Corporation, Reston, VA (dba) eCivis in the amount of $295,685 over five years; and authorizing the Purchasing Manager or her designee to issue the Purchase Order. #17..
- 456 -
City Council, January 10, 2023
Grant Management Software Subscription Agreement

Page 4 of 4 ends

Approved by:

DeAnna Christensen, Director of Finance
Joseph P. Lopez, City Manager
Attachments:

1. Resolution

2. Quote
#17..
- 457 -
1 MODESTO CITY COUNCIL
RESOLUTION NO. 2023-

RESOLUTION APPROVING THE PURCHASE OF A GRANT MANAGEMENT

SOFTWARE SUBSCRIPTION WITH CARAHSOFT TECHNOLOGY
CORPORATION, RESTON, VA (DBA) ECIVIS IN THE AMOUNT OF $295,685 OVER FIVE YEARS; AND AUTHORIZING THE PURCHASING MANAGER

OR HER DESIGNEE TO ISSUE THE PURCHASE ORDER
WHEREAS, City departments actively pursue new grant applications to receive funding from federal, state, and local agencies; and
WHEREAS, the City receives total grant awards ranging from $80 to $100 million annually from various state and federal grant agencies; and WHEREAS, the City is the financial administrator for five (5) joint power agencies/program audits and twelve (12) Community Facilities Districts and will require the financial statement compilation and express an opinion on the financial statements and programs for these funds; and
WHEREAS, under Administrative Directive 7.2 Grant Management policy, this policy defines the grant management process and steps to establish better controls on local match requirements, including potential future costs which could be required as part of a grant agreement; and
WHEREAS, the Finance Department coordinated with all City departments involved in the grant process to develop an evaluation team to determine what grant management software tools are available for local governments; and WHEREAS, based on this review, there was one grant management software which was highly recommended by several local governments (City of Tracy, City of Los Angeles, City of Raleigh) of smaller, similar, and larger size to Modesto called eCivis; and
#17..
- 458 -
2 WHEREAS, the eCivis solution has been serving local governments for over 20 years and serves over 400 local governments across the nation and they work closely with local governments and grant agencies to ensure their software addresses the needs of grant compliance and focuses on public sector government; and WHEREAS, on November 19, 2019, Region 4 Education Service Center, Houston TX issued Request for Proposals (RFP) 19019 for an Educational Grant Management Solution on their public bidding website and various newspapers and daily business journals; and
WHEREAS, on February 5, 2020, proposals were awarded for this state contract through OMNIA partners; and
WHEREAS, nine (9) proposals were received and based on the Proposal Selection Committee and criteria outlines in the RFP, three (3) companies were awarded this contract and eCivis were ranked as one of top scorer for this contract Grant Management Solution; and
WHEREAS, Modesto Municipal Code Section 8-3.203 generally requires all purchases that meet or exceed $50,000 for material, equipment or contractual services to be formally bid; however, exceptions to the formal bidding process are granted in MMC 8-3.204(d) “Where the Purchasing Manager, in her discretion, determines that a process other than the formal bid procedure set for in Section 8-3.203 will result in a procurement for the City at the lowest possible cost commensurate with the desired quality.” In addition, MMC 8-3.202(h) encourages the Purchasing Manager to join with the State of California or other units of government in cooperative purchasing plans when the best cost savings interest of the City would be served;
#17..
- 459 -
3 WHEREAS, by utilizing this government agencies bidding process, the City is complying with the requirements defined under this code.

WHEREAS, OMNIA Partners is the cooperative purchasing organization that with his extensive scope of competitively-solicited local government contracts from world-class suppliers streamlines the purchasing process and helps local government agencies achieve their procurement needs and still ensure the competitive bidding requirements are met.

NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves the purchase of a Grant Management Software Subscription with Carahsoft Technology Corporation, Reston, VA doing business as (dba) eCivis in the amount of $295,685 over five years.

BE IT FURTHER RESOLVED, that the Purchasing Manager, or her designee, is hereby authorized to issue the Purchase Order, in a form approved by the City Attorney. #17..
- 460 -
4 The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 10th day of January 2023, by Councilmember ________, who moved its adoption, which motion being duly seconded by Councilmember ______, was upon roll call carried and the resolution adopted by the following vote:

AYES: Councilmembers:

NOES: Councilmembers:

ABSENT: Councilmembers:

ATTEST: _____________________________
DIANE NAYARES-PEREZ, CMC, City Clerk
(SEAL)
APPROVED AS TO FORM:

BY: _____________________________
JOSE M. SANCHEZ, City Attorney
#17..
- 461 -

GOVERNMENT - PRICE QUOTATION
QUOTE DATE:

QUOTE NO:
11/16/2022
18307633

CONFIDENTIAL
PAGE 1 of 2

MODESTO
PO Box 642
Modesto, CA 95353 USA
FROM: Garrett Smith
Carahsoft Technology Corp.
11493 Sunset Hills Road
Suite 100
Reston, Virginia 20190
EMAIL:

PHONE:
[email protected]
(209) 577-5387
EMAIL: [email protected]
PHONE: (571) 662-3062 FAX: (703) 871-8505
Shipping Point: FOB Destination
Credit Cards: VISA/MasterCard/AMEX
Remit To: Same as Above
Payment Terms: Net 30 (On Approved Credit)
Sales Tax May Apply
RFQ NO:

SHIPPING:

TOTAL PRICE:

ESD
$90,544.00
TOTAL QUOTE: $90,544.00
LINE NO. PART NO. DESCRIPTION - QUOTE PRICE QTY EXTENDED PRICE

NON-RECURRING ANNUAL FEE(S)
1 EC-PM-1756 eCivis - Implementation Services - Hourly $223.87 COOP 113 $25,297.31 Grants Network - Data Migration and Data Integration -
Services
eCivis, Inc. - EC-PM-1
2 EC-PM-1756 eCivis - Implementation Services - Hourly $223.87 COOP 15 $3,358.05 Grants Network Grantee Base Implementation - Services
eCivis, Inc. - EC-PM-1
3 EC-PM-1756 eCivis - Implementation Services - Hourly $223.87 COOP 72 $16,118.64 Grants Network Grantee Full Implementation - Services
eCivis, Inc. - EC-PM-1
NON-RECURRING ANNUAL FEE(S) SUBTOTAL: $44,774.00

RECURRING ANNUAL FEE(S)
4 POST-B100250M- Grants Network Grantee Post-Award - Between $100-250 $24,377.50 COOP 1 $24,377.50 1756 Million - Annual
eCivis, Inc. - POST-B100250M-1
5 PRE-B100250M-1756 Grants Network Grantee Pre-Award - Between $100-250 $14,925.00 COOP 1 $14,925.00 Million - Annual
eCivis, Inc. - PRE-B100250M-1
6 PRES-B100250M- Grants Network Grantee Pre-Award - State Research - $6,467.50 COOP 1 $6,467.50 1756 Between $100-250 Million - Annual
eCivis, Inc. - PRES-B100250M-1
RECURRING ANNUAL FEE(S) SUBTOTAL: $45,770.00
SUBTOTAL: $90,544.00
TERMS: OMNIA EDU contract: R191902 QUOTE NO: 18307633
Term: April 30, 2025 QUOTE DATE: 11/16/2022
FTIN:52-2189693 QUOTE EXPIRES: 01/31/2023
#17..
- 462 -

GOVERNMENT - PRICE QUOTATION
QUOTE DATE:

QUOTE NO:
11/16/2022
18307633

CONFIDENTIAL
PAGE 2 of 2
11493 SUNSET HILLS ROAD | SUITE 100 | RESTON, VIRGINIA 20190 CARAHSOFT TECHNOLOGY CORP PHONE (703) 871-8500 | FAX (703) 871-8505 | TOLL FREE (888) 66CARAH WWW.CARAHSOFT.COM | [email protected]
LINE NO. PART NO. DESCRIPTION - QUOTE PRICE QTY EXTENDED PRICE TOTAL PRICE: $90,544.00
TOTAL QUOTE: $90,544.00
Pricing is valid through 01/31/2023
eCivis Annual fees
eCivis annual subscription is based on a 5-year term
eCivis will apply a 5% inflationary increase beginning in year 2 eCivis Annual fees
Year 1 is $90,544.00
Year 2 is $48,058.50
Year 3 is $50,461.43
Year 4 is $52,984.50
Year 5 is $53,633.73
Total 5 Year contract is $295,684.16
Above pricing in US dollars
Applicable Taxes Extra
Pricing is not applicable in response to a formal RFP Process Terms of Payment:

Software:
100% upon Contract Effective Date (Net 30)
Professional Services:
100% upon Contract Effective Date (Net 30)
Additional Professional Services are available upon request at eCivis's then-current hourly rate, currently set at $225/hr.

Please include the following on your PO:
- PO made out to Carahsoft with our current address (11493 Sunset Hills Road, Suite 100. Reston, VA 20190) - Payment terms: Net30
- Ship to and bill to address listed
#17..
- 463 -

CITY OF MODESTO

COUNCIL AGENDA REPORT
DATE OF MEETING:

January 10, 2023
Date: December 12, 2022
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
SUBJECT: Monthly Investment Report – September 2022
CONTACT: Calogero Maniscalco, Senior Financial Analyst
[email protected], (209) 577-5219
DESCRIPTION:

Consider accepting the Monthly Investment Report for September 2022. (Funding Source:

Various Funds)
STRATEGIC PLAN ELEMENT:

This item supports the City of Modesto 2020-2025 Strategic Plan focus of Governance and Service Delivery under Goal H: Achieve Financial Sustainability.

BACKGROUND:

The City’s Finance Department submits a monthly investment report to Council and the City Manager. Attached are the September investment reports (see attachment list below) generated by Public Financial Management, the City’s investment advisor. Investments in the portfolio (attachment 4) are for the City of Modesto, Modesto Public Financing Authority, Community Facilities Districts, Tuolumne River Regional Park, Successor Agency to the Redevelopment Agency, and the Modesto-Ceres Fire Protection Agency Joint Powers Authority.

DISCUSSION:

It is the function of the Finance Department to deposit and invest funds in accordance with sound treasury management and to safeguard the principal and maintain the liquidity needs of the City. The purpose of the Monthly Investment Report is to keep the City Council and City Manager informed of the City’s investment portfolio. As shown in Attachment 2, on September 30, 2022 the City had a closing market value of $421,804,894 in its investment portfolio. #18..
- 464 -
City Council, January 10, 2023
Monthly Investment Report – September 2022

Page 2 of 2 ends

FISCAL IMPACT:

In September, the approximate yield of the City’s combined investments was 1.95% (see attachment 3) on a weighted average. For the portfolio of securities alone, the yield to maturity on cost was 1.71%. For comparative purposes, the yields (as of September 30, 2022) of other investments commonly used by public agencies are listed below:

Local Agency Investment Fund: 1.51%
1-Year U.S. Treasury Note: 4.30%
2-Year U.S. Treasury Note: 4.24%

The Portfolio maintains sufficient liquidity to meet the City's projected expenditure requirements for at least the next six months.

COMMITTEE RECOMMENDATION:

This item has not gone before a committee.

CEQA/NEPA REQUIREMENTS:

N/A
RECOMMENDED COUNCIL ACTION:

Staff Recommendations:

Motion accepting the Monthly Investment Report for September 2022.

Approved by:

DeAnna Christensen, Director of Finance
Joseph P. Lopez, City Manager
Attachments:

1. Monthly Investment Report

2. Account Statement

3. Combined Yields

4. Portfolio Holdings and Earnings Projections

5. Cash with Fiscal Agent
#18..
- 465 -

Page 1 ends

PORTFOLIO HOLDINGS
Attachment 1
Percentages may not total to 100% due to rounding.

Investment Type No. of Investments Amount Invested
CAMP 1 46,375,594
Federal Agency 31 67,783,967
Federal Home Loan Bank 2 4,155,935
Federal Home Loan Mortgage Co. 9 20,714,407
Federal Nat’l Mortgage Assc. 19 40,656,054
Federal Farm Credit Bank 1 2,257,571
Federal Agency CMO 2 903,980
U.S. Treasury 59 215,982,484
Commercial Paper 3 29,897,478
Negotiable CD 2 4,536,432
Corporate Note 18 38,059,882
Asset-Backed 12 5,687,758
Municipal 10 7,066,350
Supranational 2 5,510,969
Total Invested 140 421,804,894
Sector Allocation
September 30, 2022 versus August 31, 2022
Sector September 30, 2022 August 31, 2022 Change in Allocation Permitted by Policy
U.S. Treasury 51.2% 48.4% 2.78% 100%
Federal Agency 16.1% 16.7% -0.64% 100%
Federal Agency CMO 0.2% 0.2% 0.00% 100%
Commercial Paper 7.1% 9.3% -2.23% 25%
Negotiable CD 1.1% 1.1% 0.01% 30%
Corporate Note 9.0% 9.1% -0.03% 30%
Asset-Backed 1.3% 1.4% -0.08% 20%
Municipal 1.7% 1.7% 0.00% 100%
Supranational 1.3% 1.3% 0.00% 30%
CAMP 11.0% 10.8% 0.17% 100%
* Total invested includes only the bolded numbers
* * Amount invested are market values excluding accrued interest Additional, detailed information regarding security types and investment activity may be found in Attachment 2 accompanying this memo. Moreover, the addendum data will confirm continued compliance with the investment policy as well as with California Government Code.

RECENT ACTIVITY & CORPORATE EXPOSURE
Treasury yields throughout the month continue to rise across the curve. The Fed’s September Summary of Economic projections (SEP’s) point towards another 150 basis points (1.50%) in increases by the end of the year. Strong employment data and resilient inflation numbers reaffirm the Fed’s recent commentary to continue its path of rate increases. Credit sector spreads widened throughout September as elevated levels of volatility persist. In the Long-Term Portfolio, we purchased a longer duration Treasury with the proceeds from the sale of a short duration Agency. In the Short-Term Portfolio, we purchased two commercial paper securities and a Treasury note replacing three commercial paper securities that had matured.
#18..
- 466 -

Page 2 ends

PERFORMANCE
The City’s Portfolio has consistently outperformed its benchmark since the inception of performance reporting. Interest rates rose during the month, as the fixed income market digest another round of Fed rate increases, resulting in negative total return performance for the month. The higher interest rate environment we are now in has resulted in the continuation of a higher portfolio yield at cost over last month. This reflects the potential for higher realized earnings going forward.

1. Performance is calculated on trade-date basis, gross (i.e., before fees) in accordance the CFA Institute's Global Investment Performance Standards (GIPS).

2. Performance numbers for periods greater than 1 year are presented on an annualized basis unless otherwise noted.

3. The performance calculation excludes any funds not invested in the 1-5 year strategy.

4. Performance benchmark through December 31, 2018 was the ICE BofAML 1-3 Year U.S. Treasury Index, and is now the ICE BofAML 1-5 Year U.S. Treasury Index, sourced from Bloomberg.

5. Inception date is 3/31/04.

Percentages may not add due to rounding.

Long-Term Portfolio Total Return
September 30, 2022
1 Month Trailing
12 Months
Trailing 36
Months
Trailing 60
Months
Since
Inception5
City of Modesto Investment Portfolio1,2,3-1.48% -6.27% -0.60% 0.80% 1.82% Modesto Performance Benchmark4-1.70% -6.77% -0.97% 0.40% 1.56% Average Portfolio Yields
September 30, 2022
Past
Month
Past 3
Months
Past
Year
Past 3
Years
Past 5
Years
City of Modesto Investment Portfolio 1.71% 1.69% 1.47% 1.54% 1.96% City of Modesto Short-Term Portfolio 3.34% 2.38% - - -
$90.8
$44.6
$77.1 $81.9
$96.5
$30.9
$-
$30.0
$60.0
$90.0
$120.0
$150.0
$180.0
Under 6
Months
6-12
Months
1-2 Years 2-3 Years 3-4 Years 4-5 Years
Millions
Maturity Distribution
September 30, 2022
#18..
- 467 -

Page 3 ends

INVESTMENT POLICY
The City’s investment policy embraces the following standards: the prudent investor rule, requiring the safety of principal, through prudent and safe investments; sufficient liquidity to meet expected and unforeseen cash flows; generation of an above-market, risk-adjusted rate of return (meaning, returnsexpectations taking safety and liquidity into account). No investments longer than five years are permitted.

Some investments have maturity limits of 270 days or less. The table below details the City’s permitted investments.

Investment Type
Maximum
Maturity
Maximum Specified
% of Portfolio
Maximum
% per
Issuer
Minimum Quality
Requirements
Local Agency Bonds 5 Years None None None
Treasury Obligations 5 Years None None None
State Obligations 5 Years None None A rating
CA Local Agency Obligations 5 Years None None A rating
Federal Agencies 5 Years None None None
Supranationals 5 Years 30 percent 5 percent AA
Banker’s Acceptances 180 days 40 percent 5 percent Federal Reserve eligible Commercial Paper 270 days 25 percent 5 percent A1/P1 rating Negotiable Certificates of Deposit 5 Years 30 percent 5 percent A rating Certificates of Deposit 1 Year 20 percent 5 percent FDIC insured or collateralized Repurchase Agreements 90 days None 5 percent None
Reverse Repurchase Agreements 92 days 20 percent of
combined base value 5 percent None
Medium Term Notes 5 Years 30 percent 5 percent A rating Money Market Mutual Funds N/A 20 percent 10 percent Multiple Mortgage and Asset-backed Securities 5 Years 20 percent 5 percent AA Rating CAMP N/A None None N/A
LAIF N/A N/A None N/A
The City is not required to include a list of investments held by our bond trustees; however, staff believes the City Council should be kept informed of these investments. These investments are identified on Attachment A.

LONG TERM PORTFLIO INCOME RETURN
Monthly Income Return

0.10%
Fiscal Year-to-Date Income Return

0.31%
Prior 12 Months Income Return

1.26%
#18..
- 468 -

Page 4 ends

Source U.S. Bureau of Economic Analysis, Federal Reserve, FRED. Most recent data as of August 2022.

Economic Summary
Consumption Comes at a Cost to the Consumer
0%
5%
10%
15%
20%
25%
30%
35%
40%
2004 2006 2008 2010 2012 2014 2016 2018 2020 2022
Personal Savings as % of Disposable Income
$913 billion
$0
$100
$200
$300
$400
$500
$600
$700
$800
$900
$1,000
2004 2006 2008 2010 2012 2014 2016 2018 2020 2022
Consumer Loans: Credit Cards and Other Revolving
Plans (Billions)
#18..
- 469 -

Page 5 ends

Source: Federal Reserve, latest economic projections as of September 2022.

Economic Summary
Fed’s Projections Reflect Weaker Economic Growth and
Extended Timeline for Tighter Policy

0.2%

1.2%

1.7% 1.8%
0%
1%
2%
3%
2022 2023 2024 Longer
Run
Change in Real GDP
June Projections Sept Projections

3.8%

4.4% 4.4%

4.0%
0%
1%
2%
3%
4%
5%
2022 2023 2024 Longer
Run
Unemployment Rate
June Projections Sept Projections

4.5%

3.1%

2.3%
0%
2%
4%
6%
2022 2023 2024
Core PCE Inflation
June Projections Sept Projections

4.4% 4.6%

3.9%

2.5%
0%
1%
2%
3%
4%
5%
2022 2023 2024 Longer
Run
Federal Funds Rate
June Projections Sept Projections
#18..
- 470 -

Page 6 ends

Source: ICE BofAML 1-5 year Indices via Bloomberg, MarketAxess and PFM as of 9/30/2022. Spreads on ABS are option-adjusted spreads of 0-5 year indices based on weighted average life; spreads on agencies are relative to comparable maturity Treasuries.

Economic Summary
Corporate Spreads Widen while Agency and ABS Spreads
Remain Relatively Unchanged
-0.10%
-0.05%

0.00%

0.05%

0.10%

0.15%

0.20%

0.25%
Sep-21 Dec-21 Mar-22 Jun-22 Sep-22
Federal Agency Yield Spreads

0.30%

0.40%

0.50%

0.60%

0.70%

0.80%

0.90%

1.00%
Sep-21 Dec-21 Mar-22 Jun-22 Sep-22
Corporate Notes A-AAA Yield Spreads

0.20%

0.30%

0.40%

0.50%

0.60%

0.70%

0.80%

0.90%

1.00%

1.10%
Sep-21 Dec-21 Mar-22 Jun-22 Sep-22
Asset-Backed Securities AAA Yield Spreads
#18..
- 471 -

Page 7 ends

Treasury Yields Inversion Steepens
Source: Bloomberg as of 09/30/2022.

Economic Summary

3.90%

3.93%

4.29%

3.83%

3.78%

0.00%

0.25%

0.50%

0.75%

1.00%

1.25%

1.50%

1.75%

2.00%

2.25%

2.50%

2.75%

3.00%

3.25%

3.50%

3.75%

4.00%

4.25%

4.50%

4.75%
3M1Y 2Y 3Y 4Y 5Y 10Y 30Y
U.S. Treasury Yield Curve
September 30, 2022
August 31, 2022
June 30, 2022
#18..
- 472 -

Page 8 ends

This material is based on information obtained from sources generally believed to be reliable and available to the public, however, PFM Asset Management LLC cannot guarantee its accuracy, completeness or suitability. This material is for general information purposes only and is not intended to provide specific advice or a specific recommendation. All statements as to what will or may happen under certain circumstances are based on assumptions, some but not all of which are noted in the presentation. Assumptions may or may not be proven correct as actual events occur, and results may depend on events outside of your or our control. Changes in assumptions may have a material effect on results. Past performance does not necessarily reflect and is not a guaranty of future results. The information contained in this presentation is not an offer to purchase or sell any securities.

Investment advisory services are provided by PFM Asset Management LLC (“PFMAM”), an investment adviser registered with the U.S. Securities and Exchange Commission and a subsidiary of U.S. Bancorp Asset Management, Inc. (“USBAM”). USBAM is a subsidiary of U.S. Bank National Association (“U.S. Bank”). U.S. Bank is a separate entity and subsidiary of U.S. Bancorp. U.S. Bank is not responsible for and does not guarantee the products, services or performance of PFMAM. The information contained is not an offer to purchase or sell any securities. Additional applicable regulatory information is available upon request.

For more information regarding PFMAM’s services or entities, please visit www.pfmam.com.

Disclosures
#18..
- 473 -
For the Month Ending September 30, 2022
Account Statement
Consolidated Summary Statement
CITY OF MODESTO - Combined Portfolio
Investment Allocation
Investment Type Closing Market Value Percent
Asset-Backed Security 5,687,757.78 1.35
Federal Agency Bond / Note 67,783,966.85 16.07
Corporate Note 38,059,881.83 9.02
Certificate of Deposit 4,536,432.45 1.08
Federal Agency Commercial Mortgage-Backed Security 903,980.19 0.21 Commercial Paper 29,897,477.91 7.09
Municipal Bond / Note 7,066,350.40 1.68
Supra-National Agency Bond / Note 5,510,969.08 1.31
U.S. Treasury Bond / Note 215,982,483.70 51.20
CAMP Pool 46,375,593.86 10.99
Total $421,804,894.05 100.00%
Portfolio Summary
and Income
Closing
Portfolio Holdings Market Value
Cash Dividends
PFMAM Managed Account 484,298.39 375,429,300.19
CAMP Pool 0.00 46,375,593.86
Total $484,298.39 $421,804,894.05
Maturity Distribution (Fixed Income Holdings)
Portfolio Holdings Closing Market Value Percent
46,375,593.86
9,941,325.00
10,006,182.37
24,427,727.99
47,267,651.36
74,457,223.86
81,949,654.44
96,512,700.71
30,866,834.46

0.00 10.99

2.36 2.37

5.79 11.21

17.65 19.43

22.88 7.32

0.00 Under 30 days
31 to 60 days
61 to 90 days
91 to 180 days
181 days to 1 year
1 to 2 years
2 to 3 years
3 to 4 years
4 to 5 years
Over 5 years
Total $421,804,894.05
720
100.00%
Weighted Average Days to Maturity
Sector Allocation

1.35% ABS

16.07%
Fed Agy Bond /
Note

9.02%
Corporate Note

1.08%
Cert of Deposit

0.21%
Federal Agency
Commercial
Mortgage-Backed
Security

7.09%
Commercial Paper

1.68%
Muni Bond / Note

1.31%
Supra-National
Agency Bond / Note 51.20%
US TSY Bond / Note

10.99%
CAMP Pool
Summary Page 1
#18..
- 474 -
Managed Account Summary Statement For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Total Cash Basis Earnings
Plus Net Realized Gains/Losses
Less Purchased Interest Related to Interest/Coupons
Interest/Dividends/Coupons Received
Earnings Reconciliation (Cash Basis) - Managed Account
Less Beginning Accrued Interest
Less Beginning Amortized Value of Securities
Less Cost of New Purchases
Plus Coupons/Dividends Received
Plus Proceeds of Maturities/Calls/Principal Payments
Plus Proceeds from Sales
Ending Accrued Interest
Ending Amortized Value of Securities
Earnings Reconciliation (Accrual Basis)
$381,272,156.22
(30,396,418.92)
(2,848,159.05)
32,769,118.02

0.00 (5,367,396.08)
$375,429,300.19
441,544.52
(59,870.99)
102,624.86
$484,298.39
Total
396,109,516.69
985,175.67
2,850,264.33
30,396,418.92
439,439.24
(32,828,989.01)
(396,447,509.12)
(1,011,432.29)
Total Accrual Basis Earnings $492,884.43
Closing Market Value
Change in Current Value
Unsettled Trades
Principal Acquisitions
Principal Dispositions
Maturities/Calls
Opening Market Value
Transaction Summary - Managed Account
_________________
_________________
_______________________________________________ _______________________________________________ Reconciling Transactions Net Cash Contribution
Security Purchases
Principal Payments
Coupon/Interest/Dividend Income
Sale Proceeds
Maturities/Calls
Cash Transactions Summary - Managed Account
30,000,000.00
2,850,264.33
439,439.24
396,418.92
(32,828,989.01)
(0.29)

0.00 Cash Balance
Closing Cash Balance $931,607.40
CITY OF MODESTO - COMBINED PORTFOLIO Page 1
#18..
- 475 -
Portfolio Summary and Statistics For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Account Summary
Description Par Value Market Value Percent
U.S. Treasury Bond / Note 235,156,000.00 215,982,483.70 57.52 Supra-National Agency Bond / Note 5,885,000.00 5,510,969.08 1.47 Municipal Bond / Note 7,590,000.00 7,066,350.40 1.88
Federal Agency Commercial
Mortgage-Backed Security
914,857.58 903,980.19 0.24
Federal Agency Bond / Note 72,150,000.00 67,783,966.85 18.06 Corporate Note 40,100,000.00 38,059,881.83 10.14
Commercial Paper 30,200,000.00 29,897,477.91 7.96
Certificate of Deposit 4,600,000.00 4,536,432.45 1.21
Asset-Backed Security 5,904,922.44 5,687,757.78 1.52
Managed Account Sub-Total 402,500,780.02 375,429,300.19 100.00% Accrued Interest 985,175.67
Total Portfolio 402,500,780.02 376,414,475.86
Unsettled Trades 0.00 0.00
Sector Allocation

1.52% ABS

1.21%
Cert of Deposit

7.96%
Commercial Paper

10.14%
Corporate Note

18.06%
Fed Agy Bond /
Note

0.24%
Federal Agency
Commercial
Mortgage-Backed
Security

1.88%
Muni Bond / Note

1.47%
Supra-National
Agency Bond / Note 57.52%
US TSY Bond / Note
0 - 6 Months 6 - 12 Months 1 - 2 Years 2 - 3 Years 3 - 4 Years 4 - 5 Years Over 5 Years

11.82% 12.59%

19.83%

21.83%

25.71%

8.22%

0.00%
Maturity Distribution Characteristics
Yield to Maturity at Cost
Yield to Maturity at Market
Weighted Average Days to Maturity 809

1.89%

4.19%
CITY OF MODESTO - COMBINED PORTFOLIO Page 2
#18..
- 476 -
Managed Account Issuer Summary For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Credit Quality (S&P Ratings)

0.90%
A

3.66%
A+

1.96%
A9.17%
A-1

2.92%
AA

76.05%
AA+

1.44%
AA3.62%
AAA

0.28%
NR
Issuer Summary
Issuer of Holdings Percent
Market Value
AMAZON.COM INC 4,799,630.65 1.28
BANK OF AMERICA CO 3,909,976.80 1.04
BARCLAYS PLC 2,718,084.10 0.72
BRISTOL-MYERS SQUIBB CO 1,982,820.11 0.53
CALIFORNIA DEPARTMENT OF WATER RESOURCES 91,340.00 0.02 CALIFORNIA STATE UNIVERSITY 553,422.00 0.15
CARMAX AUTO OWNER TRUST 1,494,588.17 0.40
COLLAT COMM PAPER V CO 10,002,975.54 2.66
CREDIT SUISSE GROUP RK 1,818,348.35 0.48
DISCOVER FINANCIAL SERVICES 717,485.78 0.19
FANNIE MAE 41,553,067.60 11.07
FEDERAL FARM CREDIT BANKS 2,257,571.37 0.60
FEDERAL HOME LOAN BANKS 4,155,934.61 1.11
FLORIDA STATE BOARD OF ADMIN FIN CORP 1,633,932.00 0.44 FREDDIE MAC 20,721,373.46 5.52
HONDA AUTO RECEIVABLES 1,000,868.82 0.27
HYUNDAI AUTO RECEIVABLES 931,440.79 0.25
INTER-AMERICAN DEVELOPMENT BANK 3,801,572.78 1.01
INTL BANK OF RECONSTRUCTION AND DEV 1,709,396.30 0.46
JP MORGAN CHASE & CO 3,439,385.98 0.92
LMA AMERICAS LLC 9,888,320.00 2.63
LOS ANGELES COMMUNITY COLLEGE DISTRICT 829,318.00 0.22
MANHATTAN ASSET FUNDING CO LLC 10,006,182.37 2.67
MASTERCARD INC 1,656,688.00 0.44
MICROSOFT CORP 2,776,110.00 0.74
NEW JERSEY TURNPIKE AUTHORITY 450,439.80 0.12
NISSAN AUTO RECEIVABLES 59,740.99 0.02
NOVARTIS AG 2,147,861.99 0.57
PACCAR FINANCIAL CORP 1,700,690.48 0.45
PFIZER INC 3,380,013.52 0.90
STATE OF CALIFORNIA 2,267,103.30 0.60
STATE OF MARYLAND 579,700.00 0.15
CITY OF MODESTO - COMBINED PORTFOLIO Page 3
#18..
- 477 -
Managed Account Issuer Summary For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Issuer of Holdings Percent
Market Value
TARGET CORP 327,174.32 0.09
THE BANK OF NEW YORK MELLON CORPORATION 3,044,303.96 0.81 TOYOTA MOTOR CORP 3,687,283.55 0.98
UNITED STATES TREASURY 215,982,483.70 57.53
UNIVERSITY OF CALIFORNIA 661,095.30 0.18
US BANCORP 2,811,079.70 0.75
WAL-MART STORES INC 3,880,496.00 1.03
Total $375,429,300.19 100.00%
CITY OF MODESTO - COMBINED PORTFOLIO Page 4
#18..
- 478 -
Managed Account Detail of Securities Held For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
U.S. Treasury Bond / Note

US TREASURY NOTES
DTD 11/15/2012 1.625% 11/15/2022
912828TY6 9,960,000.00 AA+ Aaa 09/19/22 09/19/22 9,938,212.50 3.03 61,133.56 9,942,799.34 9,941,325.00

US TREASURY NOTES
DTD 08/01/2016 1.250% 07/31/2023
912828S92 3,155,000.00 AA+ Aaa 02/08/19 02/12/19 2,997,126.76 2.44 6,644.36 3,125,653.01 3,078,096.88

US TREASURY NOTES
DTD 08/01/2016 1.250% 07/31/2023
912828S92 5,625,000.00 AA+ Aaa 04/02/19 04/04/19 5,386,816.41 2.28 11,846.13 5,579,294.09 5,487,890.62

US TREASURY NOTES
DTD 08/31/2016 1.375% 08/31/2023
9128282D1 1,750,000.00 AA+ Aaa 07/01/19 07/03/19 1,723,886.72 1.75 2,060.60 1,744,261.95 1,703,789.15

US TREASURY NOTES
DTD 09/15/2020 0.125% 09/15/2023
91282CAK7 4,395,000.00 AA+ Aaa 04/06/22 04/07/22 4,264,523.44 2.24 242.82 4,308,429.05 4,225,380.25

US TREASURY NOTES
DTD 10/01/2018 2.875% 09/30/2023
9128285D8 2,700,000.00 AA+ Aaa 05/01/19 05/02/19 2,769,820.31 2.26 213.26 2,715,765.88 2,664,562.50

US TREASURY NOTES
DTD 11/15/2020 0.250% 11/15/2023
91282CAW1 3,910,000.00 AA+ Aaa 04/29/21 04/30/21 3,909,389.06 0.26 3,692.19 3,909,730.37 3,736,493.75

US TREASURY NOTES
DTD 11/15/2013 2.750% 11/15/2023
912828WE6 8,790,000.00 AA+ Aaa 03/06/19 03/08/19 8,878,930.08 2.52 91,303.74 8,811,285.07 8,634,802.00

US TREASURY NOTES
DTD 11/30/2016 2.125% 11/30/2023
912828U57 3,275,000.00 AA+ Aaa 01/07/19 01/09/19 3,216,408.21 2.52 23,388.06 3,261,057.38 3,195,171.88

US TREASURY NOTES
DTD 12/15/2020 0.125% 12/15/2023
91282CBA8 4,430,000.00 AA+ Aaa 04/06/22 04/07/22 4,263,528.91 2.41 1,634.02 4,311,284.80 4,213,345.53

US TREASURY NOTES
DTD 12/31/2018 2.625% 12/31/2023
9128285U0 270,000.00 AA+ Aaa 01/30/19 01/31/19 270,801.56 2.56 1,791.13 270,203.63 264,389.08

US TREASURY NOTES
DTD 02/28/2019 2.375% 02/29/2024
9128286G0 457,000.00 AA+ Aaa 08/11/21 08/12/21 480,671.17 0.33 929.46 470,119.57 444,718.13

US TREASURY NOTES
DTD 02/28/2019 2.375% 02/29/2024
9128286G0 1,564,000.00 AA+ Aaa 08/11/21 08/12/21 1,644,582.66 0.35 3,180.93 1,608,662.36 1,521,967.50

US TREASURY NOTES
DTD 03/15/2021 0.250% 03/15/2024
91282CBR1 4,450,000.00 AA+ Aaa 04/06/22 04/07/22 4,262,960.94 2.49 491.71 4,309,720.71 4,194,820.09 CITY OF MODESTO - COMBINED PORTFOLIO Page 5
#18..
- 479 -
Managed Account Detail of Securities Held For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
U.S. Treasury Bond / Note

US TREASURY N/B NOTES
DTD 04/15/2021 0.375% 04/15/2024
91282CBV2 4,890,000.00 AA+ Aaa 04/29/21 04/30/21 4,893,629.30 0.35 8,467.32 4,891,886.83 4,602,712.50

US TREASURY N/B NOTES
DTD 06/15/2021 0.250% 06/15/2024
91282CCG4 4,485,000.00 AA+ Aaa 04/06/22 04/07/22 4,262,852.34 2.59 3,308.61 4,312,002.51 4,187,868.75

US TREASURY NOTES
DTD 07/31/2017 2.125% 07/31/2024
9128282N9 2,450,000.00 AA+ Aaa 08/01/19 08/06/19 2,489,142.58 1.79 8,771.40 2,464,380.22 2,356,593.75

US TREASURY NOTES
DTD 08/31/2017 1.875% 08/31/2024
9128282U3 1,630,000.00 AA+ Aaa 09/04/19 09/05/19 1,672,214.45 1.34 2,617.23 1,646,218.50 1,558,178.13

US TREASURY N/B NOTES
DTD 09/15/2021 0.375% 09/15/2024
91282CCX7 4,505,000.00 AA+ Aaa 04/06/22 04/07/22 4,264,440.04 2.65 746.69 4,312,174.47 4,176,979.69

US TREASURY NOTES
DTD 10/02/2017 2.125% 09/30/2024
9128282Y5 1,850,000.00 AA+ Aaa 10/01/19 10/03/19 1,905,283.20 1.50 108.00 1,872,125.40 1,774,843.75

US TREASURY NOTES
DTD 10/31/2017 2.250% 10/31/2024
9128283D0 460,000.00 AA+ Aaa 11/01/19 11/05/19 475,039.84 1.57 4,331.25 466,281.73 441,600.00

US TREASURY NOTES
DTD 11/30/2017 2.125% 11/30/2024
9128283J7 1,215,000.00 AA+ Aaa 12/02/19 12/04/19 1,239,964.45 1.69 8,676.79 1,225,832.08 1,161,084.38

US TREASURY NOTES
DTD 11/30/2017 2.125% 11/30/2024
9128283J7 3,450,000.00 AA+ Aaa 01/03/20 01/07/20 3,529,916.02 1.63 24,637.81 3,485,334.58 3,296,906.25

US TREASURY NOTES
DTD 11/30/2017 2.125% 11/30/2024
9128283J7 4,585,000.00 AA+ Aaa 04/29/21 04/30/21 4,848,816.60 0.50 32,743.29 4,744,296.89 4,381,540.62

US TREASURY N/B NOTES
DTD 12/15/2021 1.000% 12/15/2024
91282CDN8 4,445,000.00 AA+ Aaa 04/06/22 04/07/22 4,251,920.31 2.68 13,116.39 4,286,686.44 4,140,795.31

US TREASURY N/B NOTES
DTD 02/15/2022 1.500% 02/15/2025
91282CDZ1 4,400,000.00 AA+ Aaa 04/06/22 04/07/22 4,255,109.38 2.70 8,429.35 4,279,650.66 4,123,625.00

US TREASURY NOTES
DTD 04/30/2020 0.375% 04/30/2025
912828ZL7 4,945,000.00 AA+ Aaa 04/29/21 04/30/21 4,894,777.34 0.63 7,760.16 4,912,618.24 4,478,315.63

US TREASURY NOTES
DTD 07/02/2018 2.750% 06/30/2025
912828XZ8 4,230,000.00 AA+ Aaa 04/06/22 04/07/22 4,232,148.05 2.73 29,397.35 4,231,825.84 4,064,765.63 CITY OF MODESTO - COMBINED PORTFOLIO Page 6
#18..
- 480 -
Managed Account Detail of Securities Held For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
U.S. Treasury Bond / Note

US TREASURY NOTES
DTD 08/31/2020 0.250% 08/31/2025
91282CAJ0 4,340,000.00 AA+ Aaa 08/02/21 08/06/21 4,291,514.06 0.53 929.14 4,305,250.66 3,865,312.50

US TREASURY NOTES
DTD 08/31/2020 0.250% 08/31/2025
91282CAJ0 4,635,000.00 AA+ Aaa 04/06/22 04/07/22 4,262,932.62 2.74 992.30 4,315,956.72 4,128,046.88

US TREASURY NOTES
DTD 09/30/2020 0.250% 09/30/2025
91282CAM3 1,100,000.00 AA+ Aaa 09/27/21 09/28/21 1,076,023.44 0.80 7.55 1,082,054.45 977,453.18

US TREASURY NOTES
DTD 09/30/2020 0.250% 09/30/2025
91282CAM3 4,550,000.00 AA+ Aaa 09/07/21 09/09/21 4,473,574.22 0.67 31.25 4,493,531.56 4,043,101.79

US TREASURY NOTES
DTD 10/31/2020 0.250% 10/31/2025
91282CAT8 5,010,000.00 AA+ Aaa 04/29/21 04/30/21 4,894,339.45 0.77 5,241.44 4,930,830.53 4,435,415.63

US TREASURY NOTES
DTD 10/31/2020 0.250% 10/31/2025
91282CAT8 6,930,000.00 AA+ Aaa 10/04/21 10/06/21 6,783,278.91 0.78 7,250.14 6,818,823.72 6,135,215.62

US TREASURY NOTES
DTD 11/30/2020 0.375% 11/30/2025
91282CAZ4 4,250,000.00 AA+ Aaa 11/01/21 11/02/21 4,133,291.02 1.07 5,356.04 4,159,391.82 3,767,226.35

US TREASURY NOTES
DTD 11/30/2020 0.375% 11/30/2025
91282CAZ4 4,635,000.00 AA+ Aaa 04/06/22 04/07/22 4,254,785.16 2.75 5,841.24 4,305,271.30 4,108,492.74

US TREASURY NOTES
DTD 12/31/2020 0.375% 12/31/2025
91282CBC4 500,000.00 AA+ Aaa 02/02/21 02/04/21 498,613.28 0.43 473.85 499,080.94 442,109.40

US TREASURY NOTES
DTD 12/31/2020 0.375% 12/31/2025
91282CBC4 1,040,000.00 AA+ Aaa 01/07/21 01/08/21 1,035,978.13 0.45 985.60 1,037,374.06 919,587.55

US TREASURY NOTES
DTD 12/31/2020 0.375% 12/31/2025
91282CBC4 3,735,000.00 AA+ Aaa 04/05/21 04/07/21 3,646,439.65 0.89 3,539.63 3,674,201.19 3,302,557.22

US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
91282CBH3 2,400,000.00 AA+ Aaa 07/02/21 07/07/21 2,353,875.00 0.80 1,516.30 2,366,338.98 2,114,250.00

US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
91282CBH3 5,000,000.00 AA+ Aaa 02/17/22 02/18/22 4,719,531.25 1.85 3,158.97 4,763,263.38 4,404,687.50

US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
91282CBH3 5,775,000.00 AA+ Aaa 01/04/22 01/06/22 5,570,167.97 1.27 3,648.61 5,607,109.41 5,087,414.06 CITY OF MODESTO - COMBINED PORTFOLIO Page 7
#18..
- 481 -
Managed Account Detail of Securities Held For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
U.S. Treasury Bond / Note

US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
91282CBH3 7,980,000.00 AA+ Aaa 05/03/22 05/04/22 7,256,812.50 2.95 5,041.71 7,336,109.38 7,029,881.25

US TREASURY NOTES
DTD 02/28/2019 2.500% 02/28/2026
9128286F2 3,210,000.00 AA+ Aaa 03/01/21 03/01/21 3,492,881.25 0.70 6,872.24 3,403,134.27 3,035,456.25

US TREASURY NOTES
DTD 02/28/2021 0.500% 02/28/2026
91282CBQ3 4,645,000.00 AA+ Aaa 04/06/22 04/07/22 4,259,973.05 2.76 1,988.88 4,307,864.67 4,098,486.95

US TREASURY NOTES
DTD 02/28/2021 0.500% 02/28/2026
91282CBQ3 6,000,000.00 AA+ Aaa 12/03/21 12/07/21 5,838,281.25 1.15 2,569.06 5,869,493.81 5,294,062.80

US TREASURY N/B NOTES
DTD 03/31/2021 0.750% 03/31/2026
91282CBT7 2,480,000.00 AA+ Aaa 09/07/21 09/09/21 2,479,031.25 0.76 51.10 2,479,256.55 2,201,775.00

US TREASURY N/B NOTES
DTD 03/31/2021 0.750% 03/31/2026
91282CBT7 4,925,000.00 AA+ Aaa 04/29/21 04/30/21 4,896,719.73 0.87 101.48 4,904,892.04 4,372,476.56

US TREASURY N/B NOTES
DTD 05/31/2021 0.750% 05/31/2026
91282CCF6 1,405,000.00 AA+ Aaa 06/23/21 06/25/21 1,396,987.11 0.87 3,541.29 1,399,047.06 1,241,010.09

US TREASURY N/B NOTES
DTD 05/31/2021 0.750% 05/31/2026
91282CCF6 4,615,000.00 AA+ Aaa 04/06/22 04/07/22 4,253,551.76 2.76 11,632.07 4,295,780.37 4,076,342.73

US TREASURY N/B NOTES
DTD 05/31/2021 0.750% 05/31/2026
91282CCF6 4,800,000.00 AA+ Aaa 06/06/22 06/08/22 4,399,125.00 2.99 12,098.36 4,430,852.89 4,239,749.76

US TREASURY N/B NOTES
DTD 08/31/2021 0.750% 08/31/2026
91282CCW9 4,640,000.00 AA+ Aaa 04/06/22 04/07/22 4,258,106.25 2.75 2,980.11 4,300,169.22 4,070,150.00

US TREASURY N/B NOTES
DTD 09/30/2021 0.875% 09/30/2026
91282CCZ2 4,310,000.00 AA+ Aaa 04/05/22 04/07/22 3,968,398.83 2.77 103.61 4,005,334.33 3,792,126.78

US TREASURY NOTES
DTD 11/15/2016 2.000% 11/15/2026
912828U24 4,545,000.00 AA+ Aaa 06/06/22 06/08/22 4,355,920.90 3.01 34,334.51 4,369,334.90 4,173,588.05

US TREASURY NOTES
DTD 02/15/2017 2.250% 02/15/2027
912828V98 9,220,000.00 AA+ Aaa 07/05/22 07/07/22 8,981,576.56 2.85 26,494.97 8,993,752.58 8,522,737.50

US TREASURY N/B NOTES
DTD 04/30/2020 0.500% 04/30/2027
912828ZN3 6,480,000.00 AA+ Aaa 08/03/22 08/05/22 5,791,500.00 2.92 13,558.70 5,814,197.80 5,512,050.00 CITY OF MODESTO - COMBINED PORTFOLIO Page 8
#18..
- 482 -
Managed Account Detail of Securities Held For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
U.S. Treasury Bond / Note

US TREASURY NOTES
DTD 06/30/2020 0.500% 06/30/2027
912828ZV5 5,545,000.00 AA+ Aaa 08/09/22 08/10/22 4,920,754.30 2.99 7,006.59 4,938,939.61 4,694,189.06

US TREASURY NOTES
DTD 08/15/2017 2.250% 08/15/2027
9128282R0 1,200,000.00 AA+ Aaa 08/29/22 08/31/22 1,142,625.00 3.30 3,448.37 1,143,607.67 1,102,500.00

US TREASURY NOTES
DTD 08/15/2017 2.250% 08/15/2027
9128282R0 2,985,000.00 AA+ Aaa 09/01/22 09/06/22 2,830,036.52 3.40 8,577.82 2,832,184.02 2,742,468.75 Security Type Sub-Total 235,156,000.00 227,739,538.05 2.00 541,036.54 228,682,011.49 215,982,483.70 Supra-National Agency Bond / Note

INTL BK RECON & DEVELOP NOTES
DTD 11/24/2020 0.250% 11/24/2023
459058JM6 1,790,000.00 AAA Aaa 11/17/20 11/24/20 1,786,151.50 0.32 1,578.68 1,788,527.38 1,709,396.30

INTER-AMERICAN DEVEL BK NOTES
DTD 09/23/2021 0.500% 09/23/2024
4581X0DZ8 4,095,000.00 AAA Aaa 09/15/21 09/23/21 4,091,969.70 0.52 455.00 4,093,001.00 3,801,572.78 Security Type Sub-Total 5,885,000.00 5,878,121.20 0.46 2,033.68 5,881,528.38 5,510,969.08 Municipal Bond / Note

CA ST TXBL GO BONDS
DTD 10/24/2019 2.400% 10/01/2023
13063DRJ9 2,310,000.00 AA- Aa2 10/16/19 10/24/19 2,356,223.10 1.87 27,720.00 2,321,732.57 2,267,103.30

MD ST TXBL GO BONDS
DTD 08/05/2020 0.510% 08/01/2024
574193TQ1 620,000.00 AAA Aaa 07/23/20 08/05/20 619,826.40 0.52 527.00 619,920.17 579,700.00

CA ST UNIV TXBL REV BONDS
DTD 09/17/2020 0.685% 11/01/2024
13077DMK5 600,000.00 AA- Aa2 08/27/20 09/17/20 600,000.00 0.69 1,712.50 600,000.00 553,422.00

CA ST DEPT WTR RES WTR SYS TXBL REV
BNDS
DTD 08/06/2020 0.560% 12/01/2024
13067WRB0 100,000.00 AAA Aa1 07/30/20 08/06/20 100,000.00 0.56 186.67 100,000.00 91,340.00

UNIV OF CAL TXBL REV BONDS
DTD 07/16/2020 0.883% 05/15/2025
91412HGE7 220,000.00 AA Aa2 07/14/20 07/16/20 220,796.40 0.81 733.87 220,425.76 199,234.20

UNIV OF CAL TXBL REV BONDS
DTD 07/16/2020 0.883% 05/15/2025
91412HGE7 510,000.00 AA Aa2 07/10/20 07/16/20 510,000.00 0.88 1,701.25 510,000.00 461,861.10 CITY OF MODESTO - COMBINED PORTFOLIO Page 9
#18..
- 483 -
Managed Account Detail of Securities Held For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Municipal Bond / Note

FL ST BOARD OF ADMIN TXBL REV BONDS
DTD 09/16/2020 1.258% 07/01/2025
341271AD6 505,000.00 AA Aa3 09/03/20 09/16/20 508,570.35 1.11 1,588.23 507,049.53 458,408.70

FL ST BOARD OF ADMIN TXBL REV BONDS
DTD 09/16/2020 1.258% 07/01/2025
341271AD6 1,295,000.00 AA Aa3 09/03/20 09/16/20 1,295,000.00 1.26 4,072.77 1,295,000.00 1,175,523.30

LOS ANGELES CCD, CA TXBL GO BONDS
DTD 11/10/2020 0.773% 08/01/2025
54438CYK2 925,000.00 AA+ Aaa 10/30/20 11/10/20 925,000.00 0.77 1,191.71 925,000.00 829,318.00

NJ TURNPIKE AUTHORITY TXBL REV BONDS
DTD 02/04/2021 1.047% 01/01/2026
646140DP5 505,000.00 AA- A1 01/22/21 02/04/21 505,000.00 1.05 1,321.84 505,000.00 450,439.80 Security Type Sub-Total 7,590,000.00 7,640,416.25 1.22 40,755.84 7,604,128.03 7,066,350.40 Federal Agency Commercial Mortgage-Backed Security

FANNIEMAE-ACES
DTD 04/01/2014 3.346% 03/01/2024
3136AJB54 907,890.94 AA+ Aaa 12/13/19 12/18/19 952,008.76 2.14 2,531.50 922,750.17 897,013.55 FHMS KJ27 A1
DTD 11/01/2019 2.092% 07/01/2024
3137FQ3V3 6,966.64 AA+ Aaa 11/20/19 11/26/19 6,966.47 2.09 12.15 6,966.58 6,966.64 Security Type Sub-Total 914,857.58 958,975.23 2.14 2,543.65 929,716.75 903,980.19 Federal Agency Bond / Note

FREDDIE MAC NOTES
DTD 06/11/2018 2.750% 06/19/2023
3137EAEN5 3,615,000.00 AA+ Aaa 01/07/19 01/09/19 3,640,377.30 2.58 28,166.88 3,619,083.52 3,580,502.06

FREDDIE MAC NOTES
DTD 06/11/2018 2.750% 06/19/2023
3137EAEN5 4,170,000.00 AA+ Aaa 11/01/18 11/05/18 4,114,455.60 3.06 32,491.25 4,161,406.59 4,130,205.69

FREDDIE MAC NOTES
DTD 06/26/2020 0.250% 06/26/2023
3137EAES4 3,315,000.00 AA+ Aaa 06/24/20 06/26/20 3,305,320.20 0.35 2,186.98 3,312,630.88 3,222,882.78

FANNIE MAE NOTES
DTD 07/10/2020 0.250% 07/10/2023
3135G05G4 3,395,000.00 AA+ Aaa 07/08/20 07/10/20 3,387,700.75 0.32 1,909.69 3,393,120.19 3,295,964.46

FREDDIE MAC NOTES
DTD 08/21/2020 0.250% 08/24/2023
3137EAEV7 2,200,000.00 AA+ Aaa 08/19/20 08/21/20 2,197,756.00 0.28 565.28 2,199,331.70 2,124,705.00 CITY OF MODESTO - COMBINED PORTFOLIO Page 10
#18..
- 484 -
Managed Account Detail of Securities Held For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Federal Agency Bond / Note

FANNIE MAE NOTES
DTD 09/14/2018 2.875% 09/12/2023
3135G0U43 3,745,000.00 AA+ Aaa 11/07/18 11/09/18 3,699,610.60 3.15 5,682.52 3,736,117.23 3,698,217.46

FANNIE MAE NOTES
DTD 09/14/2018 2.875% 09/12/2023
3135G0U43 5,665,000.00 AA+ Aaa 12/03/18 12/06/18 5,653,556.70 2.92 8,595.85 5,662,725.80 5,594,232.82

FEDERAL FARM CREDIT BANK (CALLABLE)
DTD 09/21/2020 0.250% 09/21/2023
3133EMAM4 2,345,000.00 AA+ Aaa 10/07/20 10/09/20 2,341,013.50 0.31 162.85 2,343,685.97 2,257,571.37

FANNIE MAE NOTES
DTD 11/25/2020 0.250% 11/27/2023
3135G06H1 900,000.00 AA+ Aaa 01/25/21 01/26/21 901,368.00 0.20 775.00 900,557.77 859,613.40

FREDDIE MAC NOTES
DTD 12/04/2020 0.250% 12/04/2023
3137EAFA2 2,015,000.00 AA+ Aaa 12/02/20 12/04/20 2,013,005.15 0.28 1,637.19 2,014,218.46 1,921,671.25

FEDERAL HOME LOAN BANKS NOTES
DTD 12/09/2013 3.375% 12/08/2023
3130A0F70 2,025,000.00 AA+ Aaa 01/30/19 01/31/19 2,084,684.63 2.72 21,452.34 2,039,584.34 2,002,317.98

FANNIE MAE NOTES
DTD 01/10/2020 1.625% 01/07/2025
3135G0X24 3,500,000.00 AA+ Aaa 03/04/20 03/05/20 3,628,135.00 0.85 13,270.83 3,560,047.44 3,296,695.50

FREDDIE MAC NOTES
DTD 02/14/2020 1.500% 02/12/2025
3137EAEP0 640,000.00 AA+ Aaa 02/27/20 02/28/20 649,676.80 1.18 1,306.67 644,621.99 599,534.72

FEDERAL HOME LOAN BANK NOTES
DTD 04/16/2020 0.500% 04/14/2025
3130AJHU6 2,370,000.00 AA+ Aaa 04/15/20 04/16/20 2,358,244.80 0.60 5,497.08 2,364,032.17 2,153,616.63

FANNIE MAE NOTES
DTD 04/24/2020 0.625% 04/22/2025
3135G03U5 475,000.00 AA+ Aaa 04/29/20 04/30/20 475,731.50 0.59 1,311.20 475,375.81 432,690.80

FANNIE MAE NOTES
DTD 04/24/2020 0.625% 04/22/2025
3135G03U5 1,910,000.00 AA+ Aaa 06/03/20 06/05/20 1,919,779.20 0.52 5,272.40 1,915,125.57 1,739,872.48

FANNIE MAE NOTES
DTD 04/24/2020 0.625% 04/22/2025
3135G03U5 3,195,000.00 AA+ Aaa 04/22/20 04/24/20 3,188,418.30 0.67 8,819.53 3,191,629.77 2,910,414.96

FANNIE MAE NOTES
DTD 04/24/2020 0.625% 04/22/2025
3135G03U5 3,345,000.00 AA+ Aaa 05/01/20 05/04/20 3,347,475.30 0.61 9,233.59 3,346,274.49 3,047,054.16

FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 200,000.00 AA+ Aaa 09/17/20 09/18/20 200,712.00 0.42 288.89 200,406.74 180,548.00 CITY OF MODESTO - COMBINED PORTFOLIO Page 11
#18..
- 485 -
Managed Account Detail of Securities Held For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Federal Agency Bond / Note

FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 1,075,000.00 AA+ Aaa 10/01/20 10/05/20 1,080,041.75 0.40 1,552.78 1,077,908.70 970,445.50

FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 1,190,000.00 AA+ Aaa 01/04/21 01/05/21 1,197,223.30 0.36 1,718.89 1,194,403.37 1,074,260.60

FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 3,675,000.00 AA+ Aaa 06/17/20 06/19/20 3,667,392.75 0.54 5,308.33 3,670,871.06 3,317,569.50

FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 3,820,000.00 AA+ Aaa 10/02/20 10/05/20 3,836,311.40 0.41 5,517.78 3,829,410.42 3,448,466.80

FREDDIE MAC NOTES
DTD 07/23/2020 0.375% 07/21/2025
3137EAEU9 2,220,000.00 AA+ Aaa 07/21/20 07/23/20 2,208,944.40 0.48 1,618.75 2,213,793.35 1,990,296.60

FANNIE MAE NOTES
DTD 08/27/2020 0.375% 08/25/2025
3135G05X7 450,000.00 AA+ Aaa 10/22/20 10/23/20 447,480.00 0.49 168.75 448,489.71 401,963.85

FANNIE MAE NOTES
DTD 08/27/2020 0.375% 08/25/2025
3135G05X7 550,000.00 AA+ Aaa 10/15/20 10/16/20 548,289.50 0.44 206.25 548,978.91 491,289.15

FANNIE MAE NOTES
DTD 08/27/2020 0.375% 08/25/2025
3135G05X7 2,360,000.00 AA+ Aaa 08/25/20 08/27/20 2,348,955.20 0.47 885.00 2,353,587.48 2,108,077.08

FREDDIE MAC NOTES
DTD 09/25/2020 0.375% 09/23/2025
3137EAEX3 130,000.00 AA+ Aaa 09/29/20 09/30/20 129,829.70 0.40 10.83 129,898.14 115,807.12

FREDDIE MAC NOTES
DTD 09/25/2020 0.375% 09/23/2025
3137EAEX3 3,400,000.00 AA+ Aaa 09/23/20 09/25/20 3,389,766.00 0.44 283.34 3,393,895.51 3,028,801.60

FANNIE MAE NOTES
DTD 11/12/2020 0.500% 11/07/2025
3135G06G3 2,040,000.00 AA+ Aaa 11/19/20 11/24/20 2,039,224.80 0.51 4,080.00 2,039,514.48 1,816,428.24

FANNIE MAE NOTES
DTD 11/12/2020 0.500% 11/07/2025
3135G06G3 2,215,000.00 AA+ Aaa 11/09/20 11/12/20 2,207,070.30 0.57 4,430.00 2,210,066.25 1,972,249.29 Security Type Sub-Total 72,150,000.00 72,207,550.43 1.17 174,406.72 72,190,793.81 67,783,966.85 Corporate Note
CITY OF MODESTO - COMBINED PORTFOLIO Page 12
#18..
- 486 -
Managed Account Detail of Securities Held For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Corporate Note

TOYOTA MOTOR CREDIT CORP CORP
NOTES
DTD 09/20/2018 3.450% 09/20/2023
89236TFN0 2,230,000.00 A+ A1 11/13/18 11/15/18 2,210,175.30 3.65 2,350.79 2,226,035.06 2,203,650.32

US BANK NA CINCINNATI CORP NOTES
(CALLAB
DTD 02/04/2019 3.375% 02/05/2024
91159HHV5 2,860,000.00 A+ A2 07/19/19 07/23/19 2,995,535.40 2.27 15,015.00 2,898,403.09 2,811,079.70

BANK OF AMERICA CORP NOTE (CALLABLE)
DTD 03/05/2018 3.550% 03/05/2024
06051GHF9 2,010,000.00 A- A2 09/28/20 09/30/20 2,142,318.30 1.57 5,153.42 2,033,148.24 1,994,221.50

PFIZER INC CORP NOTES
DTD 03/11/2019 2.950% 03/15/2024
717081ES8 3,445,000.00 A+ A2 04/02/19 04/04/19 3,486,374.45 2.69 4,516.78 3,456,681.65 3,380,013.52 AMAZON.COM INC CORPORATE NOTES
DTD 05/12/2021 0.450% 05/12/2024
023135BW5 1,590,000.00 AA A1 05/10/21 05/12/21 1,587,678.60 0.50 2,762.63 1,588,752.46 1,491,402.51

JP MORGAN CHASE BANK CORP NOTE
DTD 05/13/2014 3.625% 05/13/2024
46625HJX9 1,320,000.00 A- A1 09/22/20 09/24/20 1,461,028.80 0.65 18,342.50 1,382,703.08 1,298,289.96

WALMART INC CORPORATE NOTES
DTD 04/23/2019 2.850% 07/08/2024
931142EL3 4,000,000.00 AA Aa2 07/10/19 07/12/19 4,124,840.00 2.19 26,283.33 4,042,889.82 3,880,496.00

JPMORGAN CHASE & CO CORPORATE

NOTES (CAL
DTD 09/16/2020 0.653% 09/16/2024
46647PBS4 1,405,000.00 A- A1 09/09/20 09/16/20 1,405,000.00 0.65 382.28 1,405,000.00 1,340,497.86

PACCAR FINANCIAL CORP CORPORATE
NOTES
DTD 02/06/2020 1.800% 02/06/2025
69371RQ66 1,810,000.00 A+ A1 05/11/20 05/13/20 1,839,014.30 1.45 4,977.50 1,824,406.52 1,700,690.48

NOVARTIS CAPITAL CORP
DTD 02/14/2020 1.750% 02/14/2025
66989HAP3 2,290,000.00 AA- A1 05/07/20 05/11/20 2,378,050.50 0.92 5,232.01 2,333,072.10 2,147,861.99

MASTERCARD INC CORP NOTES (CALLABLE)
DTD 12/03/2019 2.000% 03/03/2025
57636QAN4 1,760,000.00 A+ A1 05/04/20 05/06/20 1,836,225.60 1.08 2,737.78 1,797,629.25 1,656,688.00 AMAZON.COM INC CORPORATE NOTES
DTD 04/13/2022 3.000% 04/13/2025
023135CE4 3,430,000.00 AA A1 04/11/22 04/13/22 3,424,546.30 3.06 48,020.00 3,425,397.20 3,308,228.14 CITY OF MODESTO - COMBINED PORTFOLIO Page 13
#18..
- 487 -
Managed Account Detail of Securities Held For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Corporate Note

JPMORGAN CHASE & CO (CALLABLE) CORP
NOTE
DTD 06/01/2021 0.824% 06/01/2025
46647PCH7 865,000.00 A- A1 05/24/21 06/01/21 865,000.00 0.82 2,375.87 865,000.00 800,598.16

BRISTOL-MYERS SQUIBB CO CORPORATE
NOTES
DTD 11/13/2020 0.750% 11/13/2025
110122DN5 2,230,000.00 A+ A2 06/23/21 06/25/21 2,210,888.90 0.95 6,411.25 2,216,412.27 1,982,820.11

BANK OF NY MELLON CORP (CALLABLE)
CORPOR
DTD 01/28/2021 0.750% 01/28/2026
06406RAQ0 3,465,000.00 A A1 02/02/21 02/04/21 3,465,831.60 0.75 4,547.81 3,465,550.68 3,044,303.96

BANK OF AMERICA CORP NOTES
(CALLABLE)
DTD 03/22/2022 3.384% 04/02/2026
06051GKM0 2,025,000.00 A- A2 03/17/22 03/22/22 2,025,000.00 3.38 35,976.15 2,025,000.00 1,915,755.30

MICROSOFT CORP (CALLABLE) NOTES
DTD 08/08/2016 2.400% 08/08/2026
594918BR4 3,000,000.00 AAA Aaa 02/23/22 02/25/22 3,033,150.00 2.14 10,600.00 3,028,435.91 2,776,110.00

TARGET CORP CORP NOTES (CALLABLE)
DTD 01/24/2022 1.950% 01/15/2027
87612EBM7 365,000.00 A A2 01/19/22 01/24/22 364,379.50 1.99 1,502.58 364,464.87 327,174.32 Security Type Sub-Total 40,100,000.00 40,855,037.55 1.89 197,187.68 40,378,982.20 38,059,881.83 Commercial Paper

MANHATTAN ASSET FDG CO COMM PAPER
DTD 09/22/2022 0.000% 12/19/2022
56274MMK5 10,090,000.00 A-1 P-1 09/23/22 09/23/22 10,000,997.79 3.68 0.00 10,009,181.90 10,006,182.37

COLLAT COMM PAPER V CO COMM PAPER
DTD 09/02/2022 0.000% 01/05/2023
19424JN51 10,110,000.00 A-1 P-1 09/12/22 09/12/22 9,999,871.21 3.45 0.00 10,018,066.40 10,002,975.54

LMA AMERICAS LLC COMM PAPER
DTD 07/12/2022 0.000% 01/11/2023
53944RNB0 10,000,000.00 A-1 P-1 08/01/22 08/01/22 9,857,375.00 3.20 0.00 9,910,750.00 9,888,320.00 Security Type Sub-Total 30,200,000.00 29,858,244.00 3.44 0.00 29,937,998.30 29,897,477.91 Certificate of Deposit
CITY OF MODESTO - COMBINED PORTFOLIO Page 14
#18..
- 488 -
Managed Account Detail of Securities Held For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Certificate of Deposit

BARCLAYS BANK PLC NY CERT DEPOS
DTD 02/03/2022 1.050% 02/01/2023
06742TG34 2,750,000.00 A-1 P-1 02/02/22 02/03/22 2,750,000.00 1.05 19,250.00 2,750,000.00 2,718,084.10

CREDIT SUISSE NEW YORK CERT DEPOS
DTD 03/23/2021 0.590% 03/17/2023
22552G3C2 1,850,000.00 A-1 P-1 03/19/21 03/23/21 1,850,000.00 0.59 6,003.25 1,850,000.00 1,818,348.35 Security Type Sub-Total 4,600,000.00 4,600,000.00 0.86 25,253.25 4,600,000.00 4,536,432.45 Asset-Backed Security
NAROT 2019-B A3
DTD 05/28/2019 2.500% 11/15/2023
65479HAC1 59,762.09 NR Aaa 05/21/19 05/28/19 59,748.58 2.51 66.40 59,758.70 59,740.99 CARMX 2019-2 A3
DTD 04/17/2019 2.680% 03/15/2024
14316LAC7 60,959.26 AAA NR 04/09/19 04/17/19 60,953.03 2.68 72.61 60,957.42 60,937.21 HAROT 2020-1 A3
DTD 02/26/2020 1.610% 04/22/2024
43813RAC1 454,645.29 NR Aaa 02/19/20 02/26/20 454,556.17 1.61 203.33 454,611.86 450,505.93 TAOT 2020-A A3
DTD 02/12/2020 1.660% 05/15/2024
89232HAC9 559,906.56 AAA Aaa 02/04/20 02/12/20 559,866.13 1.66 413.09 559,891.16 556,642.70 CARMX 2020-1 A3
DTD 01/22/2020 1.890% 12/16/2024
14315XAC2 362,993.88 AAA NR 01/14/20 01/22/20 362,922.66 1.89 304.91 362,961.77 359,568.02 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
43813GAC5 566,590.14 NR Aaa 02/17/21 02/24/21 566,579.77 0.27 42.49 566,583.76 550,362.89 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
44933LAC7 510,000.00 AAA NR 04/20/21 04/28/21 509,946.35 0.38 86.13 509,963.81 492,308.46 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
14316NAC3 340,065.22 AAA NR 01/20/21 01/27/21 339,998.02 0.34 51.39 340,021.09 328,565.40 TAOT 2021-C A3
DTD 09/27/2021 0.430% 01/15/2026
89239BAC5 980,000.00 AAA Aaa 09/21/21 09/27/21 979,921.89 0.43 187.29 979,940.24 926,990.53 CARMX 2021-2 A3
DTD 04/21/2021 0.520% 02/17/2026
14314QAC8 770,000.00 AAA NR 04/13/21 04/21/21 769,834.07 0.52 177.96 769,883.76 745,517.54 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
44935FAD6 465,000.00 AAA NR 11/09/21 11/17/21 464,896.21 0.75 152.93 464,916.34 439,132.33 CITY OF MODESTO - COMBINED PORTFOLIO Page 15
#18..
- 489 -
Managed Account Detail of Securities Held For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par
Asset-Backed Security
DCENT 2021-A1 A1
DTD 09/27/2021 0.580% 09/15/2026
254683CP8 775,000.00 AAA Aaa 09/20/21 09/27/21 774,834.07 0.58 199.78 774,867.82 717,485.78 Security Type Sub-Total 5,904,922.44 5,904,056.95 0.81 1,958.31 5,904,357.73 5,687,757.78 Managed Account Sub-Total 402,500,780.02 395,641,939.66 1.89 985,175.67 396,109,516.69 375,429,300.19 $402,500,780.02 $395,641,939.66 1.89% $985,175.67 $396,109,516.69 $375,429,300.19 $376,414,475.86
$985,175.67
Total Investments
Accrued Interest
Securities Sub-Total
CITY OF MODESTO - COMBINED PORTFOLIO Page 16
#18..
- 490 -
Managed Account Fair Market Value & Analytics For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
U.S. Treasury Bond / Note
US TREASURY NOTES 912828TY6 9,960,000.00 CITIGRP 99.81 9,941,325.00 3,112.50 (1,474.34) DTD 11/15/2012 1.625% 11/15/2022

0.13 3.11
US TREASURY NOTES 912828S92 3,155,000.00 RBC 97.56 3,078,096.88 80,970.12 (47,556.13) DTD 08/01/2016 1.250% 07/31/2023

0.83 4.25
US TREASURY NOTES 912828S92 5,625,000.00 NOMURA 97.56 5,487,890.62 101,074.21 (91,403.47) DTD 08/01/2016 1.250% 07/31/2023

0.83 4.25
US TREASURY NOTES 9128282D1 1,750,000.00 RBS 97.36 1,703,789.15 (20,097.57) (40,472.80) DTD 08/31/2016 1.375% 08/31/2023

0.91 4.34
US TREASURY NOTES 91282CAK7 4,395,000.00 NOMURA 96.14 4,225,380.25 (39,143.19) (83,048.80) DTD 09/15/2020 0.125% 09/15/2023

0.96 4.28
US TREASURY NOTES 9128285D8 2,700,000.00 TD 98.69 2,664,562.50 (105,257.81) (51,203.38) DTD 10/01/2018 2.875% 09/30/2023

0.99 4.23
US TREASURY NOTES 91282CAW1 3,910,000.00 MERRILL 95.56 3,736,493.75 (172,895.31) (173,236.62) DTD 11/15/2020 0.250% 11/15/2023

1.12 4.33
US TREASURY NOTES 912828WE6 8,790,000.00 TD 98.23 8,634,802.00 (244,128.08) (176,483.07) DTD 11/15/2013 2.750% 11/15/2023

1.10 4.37
US TREASURY NOTES 912828U57 3,275,000.00 BNP_PARI 97.56 3,195,171.88 (21,236.33) (65,885.50) DTD 11/30/2016 2.125% 11/30/2023

1.15 4.29
US TREASURY NOTES 91282CBA8 4,430,000.00 NOMURA 95.11 4,213,345.53 (50,183.38) (97,939.27) DTD 12/15/2020 0.125% 12/15/2023

1.21 4.32
US TREASURY NOTES 9128285U0 270,000.00 MERRILL 97.92 264,389.08 (6,412.48) (5,814.55) DTD 12/31/2018 2.625% 12/31/2023

1.23 4.35
US TREASURY NOTES 9128286G0 457,000.00 WELLS_F 97.31 444,718.13 (35,953.04) (25,401.44) DTD 02/28/2019 2.375% 02/29/2024

1.40 4.35
US TREASURY NOTES 9128286G0 1,564,000.00 WELLS_F 97.31 1,521,967.50 (122,615.16) (86,694.86) DTD 02/28/2019 2.375% 02/29/2024

1.40 4.35
US TREASURY NOTES 91282CBR1 4,450,000.00 RBS 94.27 4,194,820.09 (68,140.85) (114,900.62) DTD 03/15/2021 0.250% 03/15/2024

1.46 4.35
US TREASURY N/B NOTES 91282CBV2 4,890,000.00 BARCLAY 94.13 4,602,712.50 (290,916.80) (289,174.33) DTD 04/15/2021 0.375% 04/15/2024

1.53 4.36
US TREASURY N/B NOTES 91282CCG4 4,485,000.00 NOMURA 93.38 4,187,868.75 (74,983.59) (124,133.76) DTD 06/15/2021 0.250% 06/15/2024

1.70 4.32
US TREASURY NOTES 9128282N9 2,450,000.00 TD 96.19 2,356,593.75 (132,548.83) (107,786.47) DTD 07/31/2017 2.125% 07/31/2024

1.80 4.31
CITY OF MODESTO - COMBINED PORTFOLIO Page 17
#18..
- 491 -
Managed Account Fair Market Value & Analytics For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
U.S. Treasury Bond / Note
US TREASURY NOTES 9128282U3 1,630,000.00 MERRILL 95.59 1,558,178.13 (114,036.32) (88,040.37) DTD 08/31/2017 1.875% 08/31/2024

1.89 4.29
US TREASURY N/B NOTES 91282CCX7 4,505,000.00 BARCLAY 92.72 4,176,979.69 (87,460.35) (135,194.78) DTD 09/15/2021 0.375% 09/15/2024

1.95 4.29
US TREASURY NOTES 9128282Y5 1,850,000.00 HSBC 95.94 1,774,843.75 (130,439.45) (97,281.65) DTD 10/02/2017 2.125% 09/30/2024

1.97 4.27
US TREASURY NOTES 9128283D0 460,000.00 MORGAN_S 96.00 441,600.00 (33,439.84) (24,681.73) DTD 10/31/2017 2.250% 10/31/2024

2.03 4.28
US TREASURY NOTES 9128283J7 1,215,000.00 NOMURA 95.56 1,161,084.38 (78,880.07) (64,747.70) DTD 11/30/2017 2.125% 11/30/2024

2.11 4.29
US TREASURY NOTES 9128283J7 3,450,000.00 RBS 95.56 3,296,906.25 (233,009.77) (188,428.33) DTD 11/30/2017 2.125% 11/30/2024

2.11 4.29
US TREASURY NOTES 9128283J7 4,585,000.00 HSBC 95.56 4,381,540.62 (467,275.98) (362,756.27) DTD 11/30/2017 2.125% 11/30/2024

2.11 4.29
US TREASURY N/B NOTES 91282CDN8 4,445,000.00 BNP_PAR 93.16 4,140,795.31 (111,125.00) (145,891.13) DTD 12/15/2021 1.000% 12/15/2024

2.18 4.28
US TREASURY N/B NOTES 91282CDZ1 4,400,000.00 RBS 93.72 4,123,625.00 (131,484.38) (156,025.66) DTD 02/15/2022 1.500% 02/15/2025

2.34 4.31
US TREASURY NOTES 912828ZL7 4,945,000.00 JPM_CHA 90.56 4,478,315.63 (416,461.71) (434,302.61) DTD 04/30/2020 0.375% 04/30/2025

2.57 4.27
US TREASURY NOTES 912828XZ8 4,230,000.00 BARCLAY 96.09 4,064,765.63 (167,382.42) (167,060.21) DTD 07/02/2018 2.750% 06/30/2025

2.65 4.27
US TREASURY NOTES 91282CAJ0 4,340,000.00 WELLS_F 89.06 3,865,312.50 (426,201.56) (439,938.16) DTD 08/31/2020 0.250% 08/31/2025

2.91 4.28
US TREASURY NOTES 91282CAJ0 4,635,000.00 BNP_PAR 89.06 4,128,046.88 (134,885.74) (187,909.84) DTD 08/31/2020 0.250% 08/31/2025

2.91 4.28
US TREASURY NOTES 91282CAM3 1,100,000.00 BNP_PAR 88.86 977,453.18 (98,570.26) (104,601.27) DTD 09/30/2020 0.250% 09/30/2025

2.99 4.24
US TREASURY NOTES 91282CAM3 4,550,000.00 HSBC 88.86 4,043,101.79 (430,472.43) (450,429.77) DTD 09/30/2020 0.250% 09/30/2025

2.99 4.24
US TREASURY NOTES 91282CAT8 5,010,000.00 HSBC 88.53 4,435,415.63 (458,923.82) (495,414.90) DTD 10/31/2020 0.250% 10/31/2025

3.07 4.26
US TREASURY NOTES 91282CAT8 6,930,000.00 TD 88.53 6,135,215.62 (648,063.29) (683,608.10) DTD 10/31/2020 0.250% 10/31/2025

3.07 4.26
CITY OF MODESTO - COMBINED PORTFOLIO Page 18
#18..
- 492 -
Managed Account Fair Market Value & Analytics For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
U.S. Treasury Bond / Note
US TREASURY NOTES 91282CAZ4 4,250,000.00 WELLS_F 88.64 3,767,226.35 (366,064.67) (392,165.47) DTD 11/30/2020 0.375% 11/30/2025

3.15 4.25
US TREASURY NOTES 91282CAZ4 4,635,000.00 WELLS_F 88.64 4,108,492.74 (146,292.42) (196,778.56) DTD 11/30/2020 0.375% 11/30/2025

3.15 4.25
US TREASURY NOTES 91282CBC4 500,000.00 HSBC 88.42 442,109.40 (56,503.88) (56,971.54) DTD 12/31/2020 0.375% 12/31/2025

3.23 4.22
US TREASURY NOTES 91282CBC4 1,040,000.00 CITIGRP 88.42 919,587.55 (116,390.58) (117,786.51) DTD 12/31/2020 0.375% 12/31/2025

3.23 4.22
US TREASURY NOTES 91282CBC4 3,735,000.00 JPM_CHA 88.42 3,302,557.22 (343,882.43) (371,643.97) DTD 12/31/2020 0.375% 12/31/2025

3.23 4.22
US TREASURY NOTES 91282CBH3 2,400,000.00 BNP_PAR 88.09 2,114,250.00 (239,625.00) (252,088.98) DTD 01/31/2021 0.375% 01/31/2026

3.31 4.24
US TREASURY NOTES 91282CBH3 5,000,000.00 NOMURA 88.09 4,404,687.50 (314,843.75) (358,575.88) DTD 01/31/2021 0.375% 01/31/2026

3.31 4.24
US TREASURY NOTES 91282CBH3 5,775,000.00 MORGAN_ 88.09 5,087,414.06 (482,753.91) (519,695.35) DTD 01/31/2021 0.375% 01/31/2026

3.31 4.24
US TREASURY NOTES 91282CBH3 7,980,000.00 JPM_CHA 88.09 7,029,881.25 (226,931.25) (306,228.13) DTD 01/31/2021 0.375% 01/31/2026

3.31 4.24
US TREASURY NOTES 9128286F2 3,210,000.00 GOLDMAN 94.56 3,035,456.25 (457,425.00) (367,678.02) DTD 02/28/2019 2.500% 02/28/2026

3.29 4.23
US TREASURY NOTES 91282CBQ3 4,645,000.00 NOMURA 88.23 4,098,486.95 (161,486.10) (209,377.72) DTD 02/28/2021 0.500% 02/28/2026

3.39 4.23
US TREASURY NOTES 91282CBQ3 6,000,000.00 WELLS_F 88.23 5,294,062.80 (544,218.45) (575,431.01) DTD 02/28/2021 0.500% 02/28/2026

3.39 4.23
US TREASURY N/B NOTES 91282CBT7 2,480,000.00 WELLS_F 88.78 2,201,775.00 (277,256.25) (277,481.55) DTD 03/31/2021 0.750% 03/31/2026

3.46 4.23
US TREASURY N/B NOTES 91282CBT7 4,925,000.00 MORGAN_ 88.78 4,372,476.56 (524,243.17) (532,415.48) DTD 03/31/2021 0.750% 03/31/2026

3.46 4.23
US TREASURY N/B NOTES 91282CCF6 1,405,000.00 MERRILL 88.33 1,241,010.09 (155,977.02) (158,036.97) DTD 05/31/2021 0.750% 05/31/2026

3.61 4.22
US TREASURY N/B NOTES 91282CCF6 4,615,000.00 NOMURA 88.33 4,076,342.73 (177,209.03) (219,437.64) DTD 05/31/2021 0.750% 05/31/2026

3.61 4.22
US TREASURY N/B NOTES 91282CCF6 4,800,000.00 CITIGRP 88.33 4,239,749.76 (159,375.24) (191,103.13) DTD 05/31/2021 0.750% 05/31/2026

3.61 4.22
CITY OF MODESTO - COMBINED PORTFOLIO Page 19
#18..
- 493 -
Managed Account Fair Market Value & Analytics For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
U.S. Treasury Bond / Note
US TREASURY N/B NOTES 91282CCW9 4,640,000.00 RBC 87.72 4,070,150.00 (187,956.25) (230,019.22) DTD 08/31/2021 0.750% 08/31/2026

3.86 4.18
US TREASURY N/B NOTES 91282CCZ2 4,310,000.00 RBC 87.98 3,792,126.78 (176,272.05) (213,207.55) DTD 09/30/2021 0.875% 09/30/2026

3.93 4.17
US TREASURY NOTES 912828U24 4,545,000.00 RBC 91.83 4,173,588.05 (182,332.85) (195,746.85) DTD 11/15/2016 2.000% 11/15/2026

3.94 4.18
US TREASURY NOTES 912828V98 9,220,000.00 JPM_CHA 92.44 8,522,737.50 (458,839.06) (471,015.08) DTD 02/15/2017 2.250% 02/15/2027

4.17 4.16
US TREASURY N/B NOTES 912828ZN3 6,480,000.00 NOMURA 85.06 5,512,050.00 (279,450.00) (302,147.80) DTD 04/30/2020 0.500% 04/30/2027

4.52 4.11
US TREASURY NOTES 912828ZV5 5,545,000.00 WELLS_F 84.66 4,694,189.06 (226,565.24) (244,750.55) DTD 06/30/2020 0.500% 06/30/2027

4.69 4.09
US TREASURY NOTES 9128282R0 1,200,000.00 BNP_PAR 91.88 1,102,500.00 (40,125.00) (41,107.67) DTD 08/15/2017 2.250% 08/15/2027

4.62 4.11
US TREASURY NOTES 9128282R0 2,985,000.00 HSBC 91.88 2,742,468.75 (87,567.77) (89,715.27) DTD 08/15/2017 2.250% 08/15/2027

4.62 4.11
Security Type Sub-Total 235,156,000.00 215,982,483.70 (11,757,054.35) (12,699,527.79) 2.59 4.20 Supra-National Agency Bond / Note
INTL BK RECON & DEVELOP NOTES 459058JM6 1,790,000.00 TD 95.50 1,709,396.30 (76,755.20) (79,131.08) DTD 11/24/2020 0.250% 11/24/2023

1.15 4.31
INTER-AMERICAN DEVEL BK NOTES 4581X0DZ8 4,095,000.00 JPM_CHA 92.83 3,801,572.78 (290,396.92) (291,428.22) DTD 09/23/2021 0.500% 09/23/2024

1.97 4.31
Security Type Sub-Total 5,885,000.00 5,510,969.08 (367,152.12) (370,559.30) 1.72 4.31 Municipal Bond / Note
CA ST TXBL GO BONDS 13063DRJ9 2,310,000.00 MORGAN_S 98.14 2,267,103.30 (89,119.80) (54,629.27) DTD 10/24/2019 2.400% 10/01/2023

0.98 4.31
MD ST TXBL GO BONDS 574193TQ1 620,000.00 JPM_CHA 93.50 579,700.00 (40,126.40) (40,220.17) DTD 08/05/2020 0.510% 08/01/2024

1.83 4.23
CA ST UNIV TXBL REV BONDS 13077DMK5 600,000.00 GOLDMAN 92.24 553,422.00 (46,578.00) (46,578.00) DTD 09/17/2020 0.685% 11/01/2024

2.07 4.63
CITY OF MODESTO - COMBINED PORTFOLIO Page 20
#18..
- 494 -
Managed Account Fair Market Value & Analytics For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Municipal Bond / Note
CA ST DEPT WTR RES WTR SYS TXBL REV 13067WRB0 100,000.00 MORGAN_ 91.34 91,340.00 (8,660.00) (8,660.00) BNDS
DTD 08/06/2020 0.560% 12/01/2024

2.15 4.81
UNIV OF CAL TXBL REV BONDS 91412HGE7 220,000.00 JPM_CHA 04/15/25 90.56 199,234.20 (21,562.20) (21,191.56) DTD 07/16/2020 0.883% 05/15/2025

2.51 4.75
UNIV OF CAL TXBL REV BONDS 91412HGE7 510,000.00 JPM_CHA 04/15/25 90.56 461,861.10 (48,138.90) (48,138.90) DTD 07/16/2020 0.883% 05/15/2025

2.51 4.75
FL ST BOARD OF ADMIN TXBL REV BONDS 341271AD6 505,000.00 MERRILL 90.77 458,408.70 (50,161.65) (48,640.83) DTD 09/16/2020 1.258% 07/01/2025

2.70 4.88
FL ST BOARD OF ADMIN TXBL REV BONDS 341271AD6 1,295,000.00 MERRILL 90.77 1,175,523.30 (119,476.70) (119,476.70) DTD 09/16/2020 1.258% 07/01/2025

2.70 4.88
LOS ANGELES CCD, CA TXBL GO BONDS 54438CYK2 925,000.00 MERRILL 89.66 829,318.00 (95,682.00) (95,682.00) DTD 11/10/2020 0.773% 08/01/2025

2.81 4.71
NJ TURNPIKE AUTHORITY TXBL REV 646140DP5 505,000.00 CITIGRP 89.20 450,439.80 (54,560.20) (54,560.20) BONDS
DTD 02/04/2021 1.047% 01/01/2026

3.19 4.66
Security Type Sub-Total 7,590,000.00 7,066,350.40 (574,065.85) (537,777.63) 2.05 4.58 Federal Agency Commercial Mortgage-Backed Security
FANNIEMAE-ACES 3136AJB54 907,890.94 JPM_CHAS 98.80 897,013.55 (54,995.21) (25,736.62) DTD 04/01/2014 3.346% 03/01/2024

1.33 4.22
FHMS KJ27 A1 3137FQ3V3 6,966.64 JPM_CHAS 100.00 6,966.64 0.17 0.06 DTD 11/01/2019 2.092% 07/01/2024

0.28 2.09
Security Type Sub-Total 914,857.58 903,980.19 (54,995.04) (25,736.56) 1.32 4.20 Federal Agency Bond / Note
FREDDIE MAC NOTES 3137EAEN5 3,615,000.00 MORGAN_S 99.05 3,580,502.06 (59,875.24) (38,581.46) DTD 06/11/2018 2.750% 06/19/2023

0.71 4.10
FREDDIE MAC NOTES 3137EAEN5 4,170,000.00 CITIGRP 99.05 4,130,205.69 15,750.09 (31,200.90) DTD 06/11/2018 2.750% 06/19/2023

0.71 4.10
FREDDIE MAC NOTES 3137EAES4 3,315,000.00 TD 97.22 3,222,882.78 (82,437.42) (89,748.10) DTD 06/26/2020 0.250% 06/26/2023

0.74 4.11
CITY OF MODESTO - COMBINED PORTFOLIO Page 21
#18..
- 495 -
Managed Account Fair Market Value & Analytics For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Federal Agency Bond / Note
FANNIE MAE NOTES 3135G05G4 3,395,000.00 CITIGRP 97.08 3,295,964.46 (91,736.29) (97,155.73) DTD 07/10/2020 0.250% 07/10/2023

0.78 4.10
FREDDIE MAC NOTES 3137EAEV7 2,200,000.00 CITIGRP 96.58 2,124,705.00 (73,051.00) (74,626.70) DTD 08/21/2020 0.250% 08/24/2023

0.90 4.16
FANNIE MAE NOTES 3135G0U43 3,745,000.00 JPM_CHAS 98.75 3,698,217.46 (1,393.14) (37,899.77) DTD 09/14/2018 2.875% 09/12/2023

0.94 4.23
FANNIE MAE NOTES 3135G0U43 5,665,000.00 TD 98.75 5,594,232.82 (59,323.88) (68,492.98) DTD 09/14/2018 2.875% 09/12/2023

0.94 4.23
FEDERAL FARM CREDIT BANK (CALLABLE) 3133EMAM4 2,345,000.00 TD 96.27 2,257,571.37 (83,442.13) (86,114.60) DTD 09/21/2020 0.250% 09/21/2023

0.97 4.19
FANNIE MAE NOTES 3135G06H1 900,000.00 MORGAN_ 95.51 859,613.40 (41,754.60) (40,944.37) DTD 11/25/2020 0.250% 11/27/2023

1.16 4.26
FREDDIE MAC NOTES 3137EAFA2 2,015,000.00 CITIGRP 95.37 1,921,671.25 (91,333.90) (92,547.21) DTD 12/04/2020 0.250% 12/04/2023

1.18 4.33
FEDERAL HOME LOAN BANKS NOTES 3130A0F70 2,025,000.00 BARCLAYS 98.88 2,002,317.98 (82,366.65) (37,266.36) DTD 12/09/2013 3.375% 12/08/2023

1.16 4.35
FANNIE MAE NOTES 3135G0X24 3,500,000.00 CITIGRP 94.19 3,296,695.50 (331,439.50) (263,351.94) DTD 01/10/2020 1.625% 01/07/2025

2.23 4.34
FREDDIE MAC NOTES 3137EAEP0 640,000.00 WELLS_FA 93.68 599,534.72 (50,142.08) (45,087.27) DTD 02/14/2020 1.500% 02/12/2025

2.33 4.34
FEDERAL HOME LOAN BANK NOTES 3130AJHU6 2,370,000.00 CITIGRP 90.87 2,153,616.63 (204,628.17) (210,415.54) DTD 04/16/2020 0.500% 04/14/2025

2.52 4.34
FANNIE MAE NOTES 3135G03U5 475,000.00 WELLS_F 91.09 432,690.80 (43,040.70) (42,685.01) DTD 04/24/2020 0.625% 04/22/2025

2.54 4.34
FANNIE MAE NOTES 3135G03U5 1,910,000.00 HSBC 91.09 1,739,872.48 (179,906.72) (175,253.09) DTD 04/24/2020 0.625% 04/22/2025

2.54 4.34
FANNIE MAE NOTES 3135G03U5 3,195,000.00 CITIGRP 91.09 2,910,414.96 (278,003.34) (281,214.81) DTD 04/24/2020 0.625% 04/22/2025

2.54 4.34
FANNIE MAE NOTES 3135G03U5 3,345,000.00 WELLS_F 91.09 3,047,054.16 (300,421.14) (299,220.33) DTD 04/24/2020 0.625% 04/22/2025

2.54 4.34
FANNIE MAE NOTES 3135G04Z3 200,000.00 WELLS_F 90.27 180,548.00 (20,164.00) (19,858.74) DTD 06/19/2020 0.500% 06/17/2025

2.69 4.34
FANNIE MAE NOTES 3135G04Z3 1,075,000.00 NOMURA 90.27 970,445.50 (109,596.25) (107,463.20) DTD 06/19/2020 0.500% 06/17/2025

2.69 4.34
CITY OF MODESTO - COMBINED PORTFOLIO Page 22
#18..
- 496 -
Managed Account Fair Market Value & Analytics For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Federal Agency Bond / Note
FANNIE MAE NOTES 3135G04Z3 1,190,000.00 RBS 90.27 1,074,260.60 (122,962.70) (120,142.77) DTD 06/19/2020 0.500% 06/17/2025

2.69 4.34
FANNIE MAE NOTES 3135G04Z3 3,675,000.00 NOMURA 90.27 3,317,569.50 (349,823.25) (353,301.56) DTD 06/19/2020 0.500% 06/17/2025

2.69 4.34
FANNIE MAE NOTES 3135G04Z3 3,820,000.00 RBS 90.27 3,448,466.80 (387,844.60) (380,943.62) DTD 06/19/2020 0.500% 06/17/2025

2.69 4.34
FREDDIE MAC NOTES 3137EAEU9 2,220,000.00 WELLS_F 89.65 1,990,296.60 (218,647.80) (223,496.75) DTD 07/23/2020 0.375% 07/21/2025

2.79 4.33
FANNIE MAE NOTES 3135G05X7 450,000.00 NOMURA 89.33 401,963.85 (45,516.15) (46,525.86) DTD 08/27/2020 0.375% 08/25/2025

2.89 4.33
FANNIE MAE NOTES 3135G05X7 550,000.00 CITIGRP 89.33 491,289.15 (57,000.35) (57,689.76) DTD 08/27/2020 0.375% 08/25/2025

2.89 4.33
FANNIE MAE NOTES 3135G05X7 2,360,000.00 BARCLAY 89.33 2,108,077.08 (240,878.12) (245,510.40) DTD 08/27/2020 0.375% 08/25/2025

2.89 4.33
FREDDIE MAC NOTES 3137EAEX3 130,000.00 WELLS_F 89.08 115,807.12 (14,022.58) (14,091.02) DTD 09/25/2020 0.375% 09/23/2025

2.97 4.32
FREDDIE MAC NOTES 3137EAEX3 3,400,000.00 CITIGRP 89.08 3,028,801.60 (360,964.40) (365,093.91) DTD 09/25/2020 0.375% 09/23/2025

2.97 4.32
FANNIE MAE NOTES 3135G06G3 2,040,000.00 NOMURA 89.04 1,816,428.24 (222,796.56) (223,086.24) DTD 11/12/2020 0.500% 11/07/2025

3.07 4.31
FANNIE MAE NOTES 3135G06G3 2,215,000.00 BARCLAY 89.04 1,972,249.29 (234,821.01) (237,816.96) DTD 11/12/2020 0.500% 11/07/2025

3.07 4.31
Security Type Sub-Total 72,150,000.00 67,783,966.85 (4,423,583.58) (4,406,826.96) 1.82 4.26 Corporate Note
TOYOTA MOTOR CREDIT CORP CORP 89236TFN0 2,230,000.00 JPM_CHAS 98.82 2,203,650.32 (6,524.98) (22,384.74) NOTES
DTD 09/20/2018 3.450% 09/20/2023

0.96 4.71
US BANK NA CINCINNATI CORP NOTES 91159HHV5 2,860,000.00 GOLDMAN 01/05/24 98.29 2,811,079.70 (184,455.70) (87,323.39) (CALLAB
DTD 02/04/2019 3.375% 02/05/2024

1.24 4.70
BANK OF AMERICA CORP NOTE (CALLABLE) 06051GHF9 2,010,000.00 MERRILL 03/05/23 99.22 1,994,221.50 (148,096.80) (38,926.74) DTD 03/05/2018 3.550% 03/05/2024

0.43 4.12
CITY OF MODESTO - COMBINED PORTFOLIO Page 23
#18..
- 497 -
Managed Account Fair Market Value & Analytics For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Corporate Note
PFIZER INC CORP NOTES 717081ES8 3,445,000.00 BONY 02/15/24 98.11 3,380,013.52 (106,360.93) (76,668.13) DTD 03/11/2019 2.950% 03/15/2024

1.36 4.30
AMAZON.COM INC CORPORATE NOTES 023135BW5 1,590,000.00 JPM_CHA 93.80 1,491,402.51 (96,276.09) (97,349.95) DTD 05/12/2021 0.450% 05/12/2024

1.61 4.47
JP MORGAN CHASE BANK CORP NOTE 46625HJX9 1,320,000.00 JPM_CHA 98.36 1,298,289.96 (162,738.84) (84,413.12) DTD 05/13/2014 3.625% 05/13/2024

1.57 4.69
WALMART INC CORPORATE NOTES 931142EL3 4,000,000.00 CITIGRP 04/15/23 97.01 3,880,496.00 (244,344.00) (162,393.82) DTD 04/23/2019 2.850% 07/08/2024

1.65 4.62
JPMORGAN CHASE & CO CORPORATE 46647PBS4 1,405,000.00 JPM_CHA 09/16/23 95.41 1,340,497.86 (64,502.14) (64,502.14)

NOTES (CAL
DTD 09/16/2020 0.653% 09/16/2024

0.96 3.08
PACCAR FINANCIAL CORP CORPORATE 69371RQ66 1,810,000.00 MITSU 93.96 1,700,690.48 (138,323.82) (123,716.04) NOTES
DTD 02/06/2020 1.800% 02/06/2025

2.30 4.54
NOVARTIS CAPITAL CORP 66989HAP3 2,290,000.00 CITIGRP 01/14/25 93.79 2,147,861.99 (230,188.51) (185,210.11) DTD 02/14/2020 1.750% 02/14/2025

2.25 4.54
MASTERCARD INC CORP NOTES 57636QAN4 1,760,000.00 JSEB 02/03/25 94.13 1,656,688.00 (179,537.60) (140,941.25) (CALLABLE)
DTD 12/03/2019 2.000% 03/03/2025

2.29 4.58
AMAZON.COM INC CORPORATE NOTES 023135CE4 3,430,000.00 JPM_CHA 96.45 3,308,228.14 (116,318.16) (117,169.06) DTD 04/13/2022 3.000% 04/13/2025

2.42 4.50
JPMORGAN CHASE & CO (CALLABLE) CORP 46647PCH7 865,000.00 JPM_CHA 06/01/24 92.55 800,598.16 (64,401.84) (64,401.84) NOTE
DTD 06/01/2021 0.824% 06/01/2025

1.66 3.78
BRISTOL-MYERS SQUIBB CO CORPORATE 110122DN5 2,230,000.00 MERRILL 10/13/25 88.92 1,982,820.11 (228,068.79) (233,592.16) NOTES
DTD 11/13/2020 0.750% 11/13/2025

3.00 4.61
BANK OF NY MELLON CORP (CALLABLE) 06406RAQ0 3,465,000.00 US_BANC 12/28/25 87.86 3,044,303.96 (421,527.64) (421,246.72) CORPOR
DTD 01/28/2021 0.750% 01/28/2026

3.20 4.74
BANK OF AMERICA CORP NOTES 06051GKM0 2,025,000.00 MERRILL 04/02/25 94.61 1,915,755.30 (109,244.70) (109,244.70) (CALLABLE)
DTD 03/22/2022 3.384% 04/02/2026

2.38 5.08
CITY OF MODESTO - COMBINED PORTFOLIO Page 24
#18..
- 498 -
Managed Account Fair Market Value & Analytics For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Corporate Note
MICROSOFT CORP (CALLABLE) NOTES 594918BR4 3,000,000.00 TD 05/08/26 92.54 2,776,110.00 (257,040.00) (252,325.91) DTD 08/08/2016 2.400% 08/08/2026

3.46 4.53
TARGET CORP CORP NOTES (CALLABLE) 87612EBM7 365,000.00 CITIGRP 12/15/26 89.64 327,174.32 (37,205.18) (37,290.55) DTD 01/24/2022 1.950% 01/15/2027

4.03 4.64
Security Type Sub-Total 40,100,000.00 38,059,881.83 (2,795,155.72) (2,319,100.37) 2.00 4.51 Commercial Paper
MANHATTAN ASSET FDG CO COMM PAPER 56274MMK5 10,090,000.00 CSFB 99.17 10,006,182.37 5,184.58 (2,999.53) DTD 09/22/2022 0.000% 12/19/2022

0.23 3.77
COLLAT COMM PAPER V CO COMM PAPER 19424JN51 10,110,000.00 RBC 98.94 10,002,975.54 3,104.33 (15,090.86) DTD 09/02/2022 0.000% 01/05/2023

0.28 3.97
LMA AMERICAS LLC COMM PAPER 53944RNB0 10,000,000.00 GOLDMAN 98.88 9,888,320.00 30,945.00 (22,430.00) DTD 07/12/2022 0.000% 01/11/2023

0.29 3.95
Security Type Sub-Total 30,200,000.00 29,897,477.91 39,233.91 (40,520.39) 0.27 3.90 Certificate of Deposit
BARCLAYS BANK PLC NY CERT DEPOS 06742TG34 2,750,000.00 BARCLAY 98.84 2,718,084.10 (31,915.90) (31,915.90) DTD 02/03/2022 1.050% 02/01/2023

0.35 4.44
CREDIT SUISSE NEW YORK CERT DEPOS 22552G3C2 1,850,000.00 CSFB 98.29 1,818,348.35 (31,651.65) (31,651.65) DTD 03/23/2021 0.590% 03/17/2023

0.48 4.30
Security Type Sub-Total 4,600,000.00 4,536,432.45 (63,567.55) (63,567.55) 0.40 4.38 Asset-Backed Security
NAROT 2019-B A3 65479HAC1 59,762.09 WELLS_FA 99.96 59,740.99 (7.59) (17.71) DTD 05/28/2019 2.500% 11/15/2023

0.06 2.53
CARMX 2019-2 A3 14316LAC7 60,959.26 RBC 99.96 60,937.21 (15.82) (20.21) DTD 04/17/2019 2.680% 03/15/2024

0.09 2.70
HAROT 2020-1 A3 43813RAC1 454,645.29 JPM_CHAS 99.09 450,505.93 (4,050.24) (4,105.93) DTD 02/26/2020 1.610% 04/22/2024

0.38 2.20
TAOT 2020-A A3 89232HAC9 559,906.56 MITSU 99.42 556,642.70 (3,223.43) (3,248.46) DTD 02/12/2020 1.660% 05/15/2024

0.30 2.02
CITY OF MODESTO - COMBINED PORTFOLIO Page 25
#18..
- 499 -
Managed Account Fair Market Value & Analytics For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Dated Date/Coupon/Maturity CUSIP Par Broker Date Price Value On Cost Amort Cost at Mkt Security Type/Description Next Call Market Market Unreal G/L Unreal G/L Effective YTM Duration
Asset-Backed Security
CARMX 2020-1 A3 14315XAC2 362,993.88 MERRILL 99.06 359,568.02 (3,354.64) (3,393.75) DTD 01/22/2020 1.890% 12/16/2024

0.43 2.33
HAROT 2021-1 A3 43813GAC5 566,590.14 JPM_CHA 97.14 550,362.89 (16,216.88) (16,220.87) DTD 02/24/2021 0.270% 04/21/2025

0.65 1.41
HART 2021-A A3 44933LAC7 510,000.00 BARCLAY 96.53 492,308.46 (17,637.89) (17,655.35) DTD 04/28/2021 0.380% 09/15/2025

0.82 1.58
CARMX 2021-1 A3 14316NAC3 340,065.22 MITSU 96.62 328,565.40 (11,432.62) (11,455.69) DTD 01/27/2021 0.340% 12/15/2025

0.70 1.42
TAOT 2021-C A3 89239BAC5 980,000.00 BARCLAY 94.59 926,990.53 (52,931.36) (52,949.71) DTD 09/27/2021 0.430% 01/15/2026

1.22 2.13
CARMX 2021-2 A3 14314QAC8 770,000.00 MERRILL 96.82 745,517.54 (24,316.53) (24,366.22) DTD 04/21/2021 0.520% 02/17/2026

0.75 1.48
HART 2021-C A3 44935FAD6 465,000.00 SMBC 94.44 439,132.33 (25,763.88) (25,784.01) DTD 11/17/2021 0.740% 05/15/2026

1.42 2.34
DCENT 2021-A1 A1 254683CP8 775,000.00 CITIGRP 92.58 717,485.78 (57,348.29) (57,382.04) DTD 09/27/2021 0.580% 09/15/2026

1.91 2.55
Security Type Sub-Total 5,904,922.44 5,687,757.78 (216,299.17) (216,599.95) 0.91 1.97 Managed Account Sub-Total 402,500,780.02 375,429,300.19 (20,212,639.47) (20,680,216.50) 2.13 4.19 Total Investments $376,414,475.86
$985,175.67
$375,429,300.19
Accrued Interest
Securities Sub-Total $402,500,780.02 ($20,212,639.47) ($20,680,216.50) 2.13 4.19% CITY OF MODESTO - COMBINED PORTFOLIO Page 26
#18..
- 500 -
Managed Account Security Transactions & Interest For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
BUY
09/06/22 US TREASURY NOTES
DTD 08/15/2017 2.250% 08/15/2027
09/01/22 9128282R0 2,985,000.00 (2,830,036.52) (4,015.15) (2,834,051.67) 09/12/22 COLLAT COMM PAPER V CO COMM
PAPER
DTD 09/02/2022 0.000% 01/05/2023
09/12/22 19424JN51 10,110,000.00 (9,999,871.21) 0.00 (9,999,871.21) 09/19/22 US TREASURY NOTES
DTD 11/15/2012 1.625% 11/15/2022
09/19/22 912828TY6 9,960,000.00 (9,938,212.50) (55,855.84) (9,994,068.34) 09/23/22 MANHATTAN ASSET FDG CO COMM
PAPER
DTD 09/22/2022 0.000% 12/19/2022
09/23/22 56274MMK5 10,090,000.00 (10,000,997.79) 0.00 (10,000,997.79) Transaction Type Sub-Total 33,145,000.00 (32,769,118.02) (59,870.99) (32,828,989.01)

INTEREST
09/01/22 09/01/22 MONEY MARKET FUND MONEY0002 0.00 0.00 1,228.04 1,228.04 09/25/22 FANNIEMAE-ACES
DTD 04/01/2014 3.346% 03/01/2024
09/01/22 3136AJB54 909,719.13 0.00 2,536.60 2,536.60
09/25/22 FHMS KJ27 A1
DTD 11/01/2019 2.092% 07/01/2024
09/01/22 3137FQ3V3 7,450.06 0.00 12.99 12.99
09/03/22 MASTERCARD INC CORP NOTES
(CALLABLE)
DTD 12/03/2019 2.000% 03/03/2025
09/03/22 57636QAN4 1,760,000.00 0.00 17,600.00 17,600.00 09/05/22 BANK OF AMERICA CORP NOTE
(CALLABLE)
DTD 03/05/2018 3.550% 03/05/2024
09/05/22 06051GHF9 2,010,000.00 0.00 35,677.50 35,677.50 09/12/22 FANNIE MAE NOTES
DTD 09/14/2018 2.875% 09/12/2023
09/12/22 3135G0U43 9,410,000.00 0.00 135,268.75 135,268.75 09/15/22 CARMX 2019-2 A3
DTD 04/17/2019 2.680% 03/15/2024
09/15/22 14316LAC7 88,936.37 0.00 198.62 198.62
09/15/22 NAROT 2019-A A3
DTD 02/13/2019 2.900% 10/15/2023
09/15/22 65479KAD2 9,303.83 0.00 22.48 22.48
09/15/22 TAOT 2019-A A3
DTD 02/13/2019 2.910% 07/15/2023
09/15/22 89239AAD5 31,184.91 0.00 75.62 75.62
09/15/22 US TREASURY NOTES
DTD 03/15/2021 0.250% 03/15/2024
09/15/22 91282CBR1 4,450,000.00 0.00 5,562.50 5,562.50
CITY OF MODESTO - COMBINED PORTFOLIO Page 27
#18..
- 501 -
Managed Account Security Transactions & Interest For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method

INTEREST
09/15/22 PFIZER INC CORP NOTES
DTD 03/11/2019 2.950% 03/15/2024
09/15/22 717081ES8 3,445,000.00 0.00 50,813.75 50,813.75 09/15/22 DCENT 2021-A1 A1
DTD 09/27/2021 0.580% 09/15/2026
09/15/22 254683CP8 775,000.00 0.00 374.58 374.58
09/15/22 CARMX 2020-1 A3
DTD 01/22/2020 1.890% 12/16/2024
09/15/22 14315XAC2 399,668.85 0.00 629.48 629.48
09/15/22 NAROT 2019-B A3
DTD 05/28/2019 2.500% 11/15/2023
09/15/22 65479HAC1 103,276.22 0.00 215.16 215.16
09/15/22 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
09/15/22 44933LAC7 510,000.00 0.00 161.50 161.50
09/15/22 CARMX 2021-2 A3
DTD 04/21/2021 0.520% 02/17/2026
09/15/22 14314QAC8 770,000.00 0.00 333.67 333.67
09/15/22 COPAR 2019-1 A3
DTD 05/30/2019 2.510% 11/15/2023
09/15/22 14042WAC4 7,812.06 0.00 16.34 16.34
09/15/22 US TREASURY NOTES
DTD 09/15/2020 0.125% 09/15/2023
09/15/22 91282CAK7 4,395,000.00 0.00 2,746.88 2,746.88
09/15/22 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
09/15/22 14316NAC3 361,106.52 0.00 102.31 102.31
09/15/22 TAOT 2021-C A3
DTD 09/27/2021 0.430% 01/15/2026
09/15/22 89239BAC5 980,000.00 0.00 351.17 351.17
09/15/22 TAOT 2020-A A3
DTD 02/12/2020 1.660% 05/15/2024
09/15/22 89232HAC9 648,468.90 0.00 897.05 897.05
09/15/22 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
09/15/22 44935FAD6 465,000.00 0.00 286.75 286.75
09/15/22 US TREASURY N/B NOTES
DTD 09/15/2021 0.375% 09/15/2024
09/15/22 91282CCX7 4,505,000.00 0.00 8,446.88 8,446.88
09/16/22 JPMORGAN CHASE & CO CORPORATE

NOTES (CAL
DTD 09/16/2020 0.653% 09/16/2024
09/16/22 46647PBS4 1,405,000.00 0.00 4,587.33 4,587.33
09/20/22 TOYOTA MOTOR CREDIT CORP CORP
NOTES
DTD 09/20/2018 3.450% 09/20/2023
09/20/22 89236TFN0 2,230,000.00 0.00 38,467.50 38,467.50 09/21/22 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
09/21/22 43813GAC5 608,371.29 0.00 136.88 136.88
CITY OF MODESTO - COMBINED PORTFOLIO Page 28
#18..
- 502 -
Managed Account Security Transactions & Interest For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method

INTEREST
09/21/22 HAROT 2020-1 A3
DTD 02/26/2020 1.610% 04/22/2024
09/21/22 43813RAC1 515,249.72 0.00 691.29 691.29
09/21/22 HAROT 2019-2 A3
DTD 05/29/2019 2.520% 06/21/2023
09/21/22 43815MAC0 25,651.08 0.00 53.87 53.87
09/21/22 FEDERAL FARM CREDIT BANK
(CALLABLE)
DTD 09/21/2020 0.250% 09/21/2023
09/21/22 3133EMAM4 2,345,000.00 0.00 2,931.25 2,931.25
09/23/22 INTER-AMERICAN DEVEL BK NOTES
DTD 09/23/2021 0.500% 09/23/2024
09/23/22 4581X0DZ8 4,095,000.00 0.00 10,237.50 10,237.50 09/23/22 FREDDIE MAC NOTES
DTD 09/25/2020 0.375% 09/23/2025
09/23/22 3137EAEX3 3,530,000.00 0.00 6,618.75 6,618.75
09/30/22 US TREASURY NOTES
DTD 09/30/2020 0.250% 09/30/2025
09/30/22 91282CAM3 5,650,000.00 0.00 7,062.50 7,062.50
09/30/22 US TREASURY NOTES
DTD 10/02/2017 2.125% 09/30/2024
09/30/22 9128282Y5 1,850,000.00 0.00 19,656.25 19,656.25 09/30/22 US TREASURY N/B NOTES
DTD 09/30/2021 0.875% 09/30/2026
09/30/22 91282CCZ2 4,310,000.00 0.00 18,856.25 18,856.25 09/30/22 US TREASURY N/B NOTES
DTD 03/31/2021 0.750% 03/31/2026
09/30/22 91282CBT7 7,405,000.00 0.00 27,768.75 27,768.75 09/30/22 US TREASURY NOTES
DTD 10/01/2018 2.875% 09/30/2023
09/30/22 9128285D8 2,700,000.00 0.00 38,812.50 38,812.50 Transaction Type Sub-Total 72,711,198.94 0.00 439,439.24 439,439.24

MATURITY
09/12/22 COLLAT CP FLEX CO LLC COMM PAPER
DTD 05/13/2022 0.000% 09/12/2022
09/12/22 19423KJC9 10,000,000.00 10,000,000.00 0.00 10,000,000.00 50,258.33 0.00 09/19/22 STARBIRD FUNDING CORP COMM
PAPER
DTD 05/16/2022 0.000% 09/19/2022
09/19/22 85520MJK0 10,000,000.00 10,000,000.00 0.00 10,000,000.00 52,444.44 0.00 09/23/22 MUFG BANK LTD/NY COMM PAPER
DTD 12/28/2021 0.000% 09/23/2022
09/23/22 62479MJP9 10,000,000.00 10,000,000.00 0.00 10,000,000.00 58,025.00 0.00 Transaction Type Sub-Total 30,000,000.00 30,000,000.00 0.00 30,000,000.00 160,727.77 0.00 CITY OF MODESTO - COMBINED PORTFOLIO Page 29
#18..
- 503 -
Managed Account Security Transactions & Interest For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method

PAYDOWNS
09/25/22 FHMS KJ27 A1
DTD 11/01/2019 2.092% 07/01/2024
09/01/22 3137FQ3V3 483.42 483.42 0.00 483.42 0.01 0.00
09/25/22 FANNIEMAE-ACES
DTD 04/01/2014 3.346% 03/01/2024
09/01/22 3136AJB54 1,828.19 1,828.19 0.00 1,828.19 (88.84) 0.00 09/15/22 TAOT 2019-A A3
DTD 02/13/2019 2.910% 07/15/2023
09/15/22 89239AAD5 31,184.91 31,184.91 0.00 31,184.91 5.68 0.00 09/15/22 COPAR 2019-1 A3
DTD 05/30/2019 2.510% 11/15/2023
09/15/22 14042WAC4 7,812.06 7,812.06 0.00 7,812.06 1.58 0.00 09/15/22 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
09/15/22 14316NAC3 21,041.30 21,041.30 0.00 21,041.30 4.16 0.00 09/15/22 CARMX 2020-1 A3
DTD 01/22/2020 1.890% 12/16/2024
09/15/22 14315XAC2 36,674.97 36,674.97 0.00 36,674.97 7.20 0.00 09/15/22 CARMX 2019-2 A3
DTD 04/17/2019 2.680% 03/15/2024
09/15/22 14316LAC7 27,977.11 27,977.11 0.00 27,977.11 2.86 0.00 09/15/22 TAOT 2020-A A3
DTD 02/12/2020 1.660% 05/15/2024
09/15/22 89232HAC9 88,562.34 88,562.34 0.00 88,562.34 6.39 0.00 09/15/22 NAROT 2019-B A3
DTD 05/28/2019 2.500% 11/15/2023
09/15/22 65479HAC1 43,514.13 43,514.13 0.00 43,514.13 9.84 0.00 09/15/22 NAROT 2019-A A3
DTD 02/13/2019 2.900% 10/15/2023
09/15/22 65479KAD2 9,303.83 9,303.83 0.00 9,303.83 1.41 0.00 09/21/22 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
09/21/22 43813GAC5 41,781.15 41,781.15 0.00 41,781.15 0.76 0.00 09/21/22 HAROT 2019-2 A3
DTD 05/29/2019 2.520% 06/21/2023
09/21/22 43815MAC0 25,651.08 25,651.08 0.00 25,651.08 0.96 0.00 09/21/22 HAROT 2020-1 A3
DTD 02/26/2020 1.610% 04/22/2024
09/21/22 43813RAC1 60,604.43 60,604.43 0.00 60,604.43 11.88 0.00 Transaction Type Sub-Total 396,418.92 396,418.92 0.00 396,418.92 (36.11) 0.00 SELL
09/06/22 FANNIE MAE NOTES
DTD 05/22/2020 0.250% 05/22/2023
09/01/22 3135G04Q3 2,915,000.00 2,848,159.05 2,105.28 2,850,264.33 (58,066.80) (64,773.62) FIFO Transaction Type Sub-Total 2,915,000.00 2,848,159.05 2,105.28 2,850,264.33 (58,066.80) (64,773.62) CITY OF MODESTO - COMBINED PORTFOLIO Page 30
#18..
- 504 -
Managed Account Security Transactions & Interest For the Month Ending September 30, 2022 CITY OF MODESTO - Combined Portfolio
Transaction Type
Trade Settle Security Description CUSIP Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
Managed Account Sub-Total 475,459.95 381,673.53 857,133.48 102,624.86 (64,773.62) Total Security Transactions $475,459.95 $381,673.53 $857,133.48 $102,624.86 ($64,773.62) CITY OF MODESTO - COMBINED PORTFOLIO Page 31
#18..
- 505 -
Attachment 3
City of Modesto Combined Yields
Month
Ending
Combined
Yield
CAMP
Balance
CAMP Monthly
Distribution Yields
Long Term
Amortized Cost
Balance
Long Term
Portfolio Yield
Short Term
Amortized Cost
Balance
Short Term
Portfolio Yield
10/31/2020 1.46% 70,067,223.80 0.19% 238,332,735.73 1.83% 11/30/2020 1.41% 70,075,022.52 0.14% 237,871,749.29 1.79% 12/31/2020 1.33% 85,083,671.36 0.12% 237,485,609.39 1.77% 1/31/2021 1.31% 85,092,301.61 0.12% 238,149,298.87 1.74% 2/28/2021 1.14% 120,099,726.01 0.10% 232,079,913.81 1.68% 3/31/2021 1.08% 137,608,358.86 0.08% 234,986,337.21 1.67% 4/30/2021 1.09% 99,414,400.76 0.06% 273,342,506.45 1.47% 5/31/2021 1.00% 134,419,293.96 0.05% 273,479,692.78 1.46% 6/30/2021 0.97% 134,424,844.05 0.05% 273,831,695.68 1.42% 7/31/2021 1.02% 108,729,978.62 0.05% 273,119,224.63 1.40% 8/31/2021 1.01% 108,734,764.86 0.05% 272,424,046.82 1.39% 9/30/2021 0.97% 108,739,293.68 0.05% 275,543,849.60 1.33% 10/31/2021 0.91% 123,744,124.02 0.05% 274,089,339.67 1.30% 11/30/2021 0.90% 123,749,269.51 0.05% 275,079,950.15 1.28% 12/31/2021 0.91% 123,754,558.86 0.05% 274,968,424.92 1.29% 1/31/2022 0.92% 123,759,932.29 0.05% 276,103,753.02 1.31% 2/28/2022 0.92% 106,765,158.19 0.06% 276,530,404.21 1.31% 39,948,433.34 0.53% 3/31/2022 0.98% 106,788,084.24 0.25% 277,035,730.56 1.33% 39,948,380.00 0.53% 4/30/2022 1.39% 30,016,017.61 0.50% 353,203,903.46 1.56% 39,984,016.67 0.53% 5/31/2022 1.47% 50,044,305.28 0.82% 353,781,386.85 1.59% 39,880,961.12 1.26% 6/30/2022 1.56% 75,106,114.53 1.14% 354,423,884.74 1.64% 39,871,394.45 1.66% 7/31/2022 1.66% 46,186,072.35 1.64% 354,553,148.20 1.66% 39,928,141.66 1.66% 8/31/2022 1.79% 46,276,184.59 2.30% 356,564,454.56 1.69% 39,858,625.00 2.14% 9/30/2022 1.95% 46,375,593.86 2.61% 356,228,719.05 1.71% 39,880,797.64 3.34% Notes:

1. Long and Short Term Portfolio AC Balance is the amortized cost value of the separately managed portfolios.

2. Long and Short Term Portfolio Yields are the separately managed portfolios yield at costs. #18..
- 506 -
Attachment 4
City of Modesto - Portfolio Holdings and Earnings Projections Issuer Par Maturity Date Current Yield
Years to
Maturity
Expected Earnings
Rate to June 30, 2023
Expected Earnings to
June 30, 2023
Main Portfolio
Federal Agency
FHLMC 3,615,000 6/19/2023 4.100% 1 66,989 2.65% 71,583
FHLMC 4,170,000 6/19/2023 4.100% 1 91,616 3.11% 96,915
FHLMC 3,315,000 6/26/2023 4.110% 1 8,500 0.40% 10,032
FNMA 3,395,000 7/10/2023 4.100% 1 8,478 0.32% 8,178
FHLMC 2,200,000 8/24/2023 4.160% 1 5,616 0.28% 4,674
FNMA 3,745,000 9/12/2023 4.230% 1 112,019 3.15% 88,130
FNMA 5,665,000 9/12/2023 4.230% 1 157,268 2.92% 123,730 FFCB 2,345,000 9/21/2023 4.190% 1 7,043 0.31% 5,401
FNMA 900,000 11/27/2023 4.260% 1 2,047 0.20% 1,321
FHLMC 2,015,000 12/4/2023 4.330% 1 6,722 0.28% 4,268
FHLB 2,025,000 12/8/2023 4.350% 1 65,549 2.72% 41,232
FNMA 3,500,000 1/7/2025 4.340% 2 67,735 0.85% 22,279
FHLMC 640,000 2/12/2025 4.340% 2 17,992 1.18% 5,672
FHLB 2,370,000 4/14/2025 4.340% 3 36,173 0.60% 10,653
FNMA 3,195,000 4/22/2025 4.340% 3 54,591 0.67% 15,939
FNMA 475,000 4/22/2025 4.340% 3 7,222 0.59% 2,109
FNMA 3,345,000 4/22/2025 4.340% 3 52,256 0.61% 15,258
FNMA 1,910,000 4/22/2025 4.340% 3 25,374 0.52% 7,409
FNMA 3,675,000 6/17/2025 4.340% 3 54,087 0.54% 14,900
FNMA 200,000 6/17/2025 4.340% 3 2,303 0.42% 634
FNMA 1,075,000 6/17/2025 4.340% 3 11,650 0.40% 3,209
FNMA 3,820,000 6/17/2025 4.340% 3 42,334 0.41% 11,662
FNMA 1,190,000 6/17/2025 4.340% 3 11,708 0.36% 3,225
FHLMC 2,220,000 7/21/2025 4.330% 3 29,676 0.48% 7,904
FNMA 2,360,000 8/25/2025 4.330% 3 32,207 0.47% 8,295
FNMA 550,000 8/25/2025 4.330% 3 7,024 0.44% 1,809
FNMA 450,000 8/25/2025 4.330% 3 6,433 0.49% 1,657
FHLMC 3,400,000 9/23/2025 4.320% 3 44,227 0.44% 11,087
FHLMC 130,000 9/23/2025 4.320% 3 1,558 0.40% 390
FNMA 2,215,000 11/7/2025 4.310% 3 39,427 0.57% 9,492
FNMA 2,040,000 11/7/2025 4.310% 3 32,183 0.51% 7,748
Federal Agency CMO
FNMA 907,891 3/1/2024 4.220% 1 27,522 2.14% 14,505
FHLMC 6,967 7/1/2024 2.090% 2 256 2.09% 109
U.S. Treasury
U.S. Treasury 9,960,000 11/15/2022 3.110% 0 37,995 4.08% 303,636 U.S. Treasury 3,155,000 7/31/2023 4.250% 1 64,093 2.44% 57,558 U.S. Treasury 5,625,000 7/31/2023 4.250% 1 106,973 2.28% 96,065 U.S. Treasury 1,750,000 8/31/2023 4.340% 1 28,080 1.75% 22,883 U.S. Treasury 4,395,000 9/15/2023 4.280% 1 94,194 2.24% 73,471 U.S. Treasury 2,700,000 9/30/2023 4.230% 1 60,905 2.26% 45,554 U.S. Treasury 3,910,000 11/15/2023 4.330% 1 11,279 0.26% 7,492 U.S. Treasury 8,790,000 11/15/2023 4.370% 1 249,362 2.52% 165,635 U.S. Treasury 3,275,000 11/30/2023 4.290% 1 96,165 2.52% 61,627 U.S. Treasury 4,430,000 12/15/2023 4.320% 1 128,886 2.41% 79,786 U.S. Treasury 270,000 12/31/2023 4.350% 1 8,654 2.56% 5,170 U.S. Treasury 1,564,000 2/29/2024 4.350% 1 7,645 0.35% 4,037 U.S. Treasury 457,000 2/29/2024 4.350% 1 2,166 0.33% 1,144 U.S. Treasury 4,450,000 3/15/2024 4.350% 1 161,204 2.49% 82,723 U.S. Treasury 4,890,000 4/15/2024 4.360% 2 26,381 0.35% 12,792 U.S. Treasury 4,485,000 6/15/2024 4.320% 2 198,701 2.59% 86,932 U.S. Treasury 2,450,000 7/31/2024 4.310% 2 80,432 1.79% 32,773 U.S. Treasury 1,630,000 8/31/2024 4.290% 2 41,835 1.34% 16,292 U.S. Treasury 4,505,000 9/15/2024 4.290% 2 234,336 2.65% 89,349 U.S. Treasury 1,850,000 9/30/2024 4.270% 2 55,628 1.50% 20,775 U.S. Treasury 460,000 10/31/2024 4.280% 2 15,037 1.57% 5,387 U.S. Treasury 1,215,000 11/30/2024 4.290% 2 44,654 1.69% 15,392 U.S. Treasury 3,450,000 11/30/2024 4.290% 2 122,073 1.63% 42,078 U.S. Treasury 4,585,000 11/30/2024 4.290% 2 50,090 0.50% 17,266 U.S. Treasury 4,445,000 12/15/2024 4.280% 2 263,830 2.68% 89,251 U.S. Treasury 4,400,000 2/15/2025 4.310% 2 283,285 2.70% 88,995 U.S. Treasury 4,945,000 4/30/2025 4.270% 3 80,811 0.63% 23,395 U.S. Treasury 4,230,000 6/30/2025 4.270% 3 317,963 2.73% 86,458 U.S. Treasury 4,340,000 8/31/2025 4.280% 3 66,919 0.53% 17,138 U.S. Treasury 4,635,000 8/31/2025 4.280% 3 371,053 2.74% 95,026 U.S. Treasury 4,550,000 9/30/2025 4.240% 3 91,583 0.67% 22,812 U.S. Treasury 1,100,000 9/30/2025 4.240% 3 26,559 0.80% 6,615 U.S. Treasury 5,010,000 10/31/2025 4.260% 3 119,575 0.77% 28,965 U.S. Treasury 6,930,000 10/31/2025 4.260% 3 166,850 0.78% 40,417 U.S. Treasury 4,250,000 11/30/2025 4.250% 3 143,496 1.07% 33,859 U.S. Treasury 4,635,000 11/30/2025 4.250% 3 404,572 2.75% 95,461 U.S. Treasury 1,040,000 12/31/2025 4.220% 3 15,356 0.45% 3,529 U.S. Treasury 500,000 12/31/2025 4.220% 3 7,034 0.43% 1,616 U.S. Treasury 3,735,000 12/31/2025 4.220% 3 107,922 0.89% 24,800 U.S. Treasury 2,400,000 1/31/2026 4.240% 3 64,483 0.80% 14,441 U.S. Treasury 5,775,000 1/31/2026 4.240% 3 245,411 1.27% 54,961 U.S. Treasury 5,000,000 1/31/2026 4.240% 3 309,623 1.85% 69,341 U.S. Treasury 7,980,000 1/31/2026 4.240% 3 786,192 2.95% 176,071 U.S. Treasury 6,000,000 2/28/2026 4.230% 3 236,714 1.15% 51,823 U.S. Treasury 4,645,000 2/28/2026 4.230% 3 437,689 2.76% 95,821 U.S. Treasury 3,210,000 2/28/2026 4.230% 3 77,022 0.70% 16,862 U.S. Treasury 4,925,000 3/31/2026 4.230% 4 149,939 0.87% 32,029 U.S. Treasury 2,480,000 3/31/2026 4.230% 4 65,883 0.76% 14,074 U.S. Treasury 1,405,000 5/31/2026 4.220% 4 44,758 0.87% 9,125 U.S. Treasury 4,615,000 5/31/2026 4.220% 4 467,444 2.76% 95,304 U.S. Treasury 4,800,000 5/31/2026 4.220% 4 526,927 2.99% 107,432 U.S. Treasury 4,640,000 8/31/2026 4.180% 4 500,285 2.75% 95,442 U.S. Treasury 4,310,000 9/30/2026 4.170% 4 477,518 2.77% 89,228 U.S. Treasury 4,545,000 11/15/2026 4.180% 4 564,623 3.01% 102,284 U.S. Treasury 9,220,000 2/15/2027 4.160% 4 1,152,191 2.85% 196,715 U.S. Treasury 6,480,000 4/30/2027 4.110% 5 866,703 2.92% 141,429 U.S. Treasury 5,545,000 6/30/2027 4.090% 5 788,304 2.99% 124,110 U.S. Treasury 1,200,000 8/15/2027 4.110% 5 193,325 3.30% 29,650 U.S. Treasury 2,985,000 8/15/2027 4.110% 5 494,973 3.40% 75,914 September 30, 2022
Earnings to
Maturity
#18..
- 507 -
Attachment 4
City of Modesto - Portfolio Holdings and Earnings Projections Issuer Par Maturity Date Current Yield
Years to
Maturity
Expected Earnings
Rate to June 30, 2023
Expected Earnings to
June 30, 2023
September 30, 2022
Earnings to
Maturity
Commercial Paper
Sumitomo Mitsui Financial Group Inc 10,090,000 12/19/2022 3.770% 0 81,438 4.15% 313,301 Collat Commercial Paper V Co 10,110,000 1/5/2023 3.970% 0 92,628 4.03% 304,750 LMA Americas LLC 10,000,000 1/11/2023 3.950% 0 90,177 3.91% 292,501 Negotiable CD
Barclays PLC 2,750,000 2/1/2023 4.440% 0 9,810 2.83% 58,240 Credit Suisse Group 1,850,000 3/17/2023 4.300% 0 4,989 1.99% 27,557 Corporate Note
Toyota Motor Corp 2,230,000 9/20/2023 4.710% 1 79,187 3.65% 60,896 US Bancorp 2,860,000 2/5/2024 4.700% 1 87,647 2.27% 48,534 Bank Of America Co 2,010,000 3/5/2024 4.120% 1 45,163 1.57% 23,620 Pfizer Inc 3,445,000 3/15/2024 4.300% 1 135,011 2.69% 69,282 Amazon.Com Inc 1,590,000 5/12/2024 4.470% 2 12,827 0.50% 5,935 JPMorgan Chase & Co 1,320,000 5/13/2024 4.690% 2 13,830 0.65% 6,389 Wal-Mart Stores Inc 4,000,000 7/8/2024 4.620% 2 155,013 2.19% 65,407 JPMorgan Chase & Co 1,405,000 9/16/2024 3.080% 2 18,023 0.65% 6,862 Paccar Financial Corp 1,810,000 2/6/2025 4.540% 2 61,752 1.45% 19,603 Novartis Capital Corp 2,290,000 2/14/2025 4.540% 2 50,217 0.92% 15,794 Mastercard Inc 1,760,000 3/3/2025 4.580% 2 45,931 1.08% 14,169 Amazon.Com Inc 3,430,000 4/13/2025 4.500% 3 265,918 3.06% 78,397 JPMorgan Chase & Co 865,000 6/1/2025 3.780% 3 19,039 0.82% 5,331 Bristol-Myers Squibb Co 2,230,000 11/13/2025 4.610% 3 66,170 0.95% 15,846 The Bank Of New York Mellon Corporation 3,465,000 1/28/2026 4.740% 3 86,010 0.75% 19,310 Bank Of America Co 2,025,000 4/2/2026 5.080% 4 240,295 3.38% 51,250 Microsoft Corp 3,000,000 8/8/2026 4.530% 4 247,467 2.14% 47,982 Target Corp 365,000 1/15/2027 4.640% 4 31,142 1.99% 5,422 Asset-Backed Securities
Nissan Auto Receivables 59,762 11/15/2023 2.530% 1 1,686 2.51% 1,120 Carmax Auto Owner Trust 60,959 3/15/2024 2.700% 1 2,383 2.68% 1,223 Honda Auto Receivables 454,645 4/22/2024 2.200% 2 11,465 1.61% 5,491 Toyota Motor Corp 559,907 5/15/2024 2.020% 2 15,116 1.66% 6,959 Carmax Auto Owner Trust 362,994 12/16/2024 2.330% 2 15,220 1.89% 5,143 Honda Auto Receivables 566,590 4/21/2025 1.410% 3 3,921 0.27% 1,146 Hyundai Auto Receivables 510,000 9/15/2025 1.580% 3 5,776 0.38% 1,459 Carmax Auto Owner Trust 340,065 12/15/2025 1.420% 3 3,757 0.34% 875 Toyota Motor Corp 980,000 1/15/2026 2.130% 3 13,949 0.43% 3,166 Carmax Auto Owner Trust 770,000 2/17/2026 1.480% 3 13,675 0.52% 3,020 Hyundai Auto Receivables 465,000 5/15/2026 2.340% 4 12,558 0.75% 2,591 Discover Card Execution Note Trust 775,000 9/15/2026 2.550% 4 17,942 0.58% 3,387 Municipal Securities
California St 2,310,000 10/1/2023 4.310% 1 43,326 1.87% 32,317 Maryland St 620,000 8/1/2024 4.230% 2 5,894 0.52% 2,398 California State University 600,000 11/1/2024 4.630% 2 8,591 0.68% 3,074 State Of California 100,000 12/1/2024 4.810% 2 1,217 0.56% 419 University Of California 510,000 5/15/2025 4.750% 3 11,820 0.88% 3,368 University Of California 220,000 5/15/2025 4.750% 3 4,657 0.81% 1,327 Florida State Board of Administration Finance 1,295,000 7/1/2025 4.880% 3 44,860 1.26% 12,186 Florida State Board of Administration Finance 505,000 7/1/2025 4.880% 3 15,381 1.11% 4,178 Los Angeles Community College District 925,000 8/1/2025 4.710% 3 20,296 0.77% 5,348 New Jersey Turnpike Authority 505,000 1/1/2026 4.660% 3 17,224 1.05% 3,955 Supranational Securities
Intl Bank Of Reconstruction And Dev 1,790,000 11/24/2023 4.310% 1 6,634 0.32% 4,312 Inter-American Development Bank 4,095,000 9/23/2024 4.310% 2 42,635 0.52% 16,077 Overnight Investments 46,375,594 Varies Varies 3.79% 1,316,247 Totals (Main Portfolio) 448,876,374 16,259,033 2.15% 7,224,783 Notes:

1. Earnings projections are based on stated par value, future market expectations and current investment positions.

2. Earnings on overnight investments are based on the investment balances and the Fed Funds Futures rates.

3. Callable securities priced above par are considered to be called on their next call date. #18..
- 508 -
Attachment 5
Issue Name / Type Trustee Bank Investment Total Amount
1993 Community Center Refinancing U.S. Bank First American Treasury Obligation Fund $3,304,125.00 1993 Golf Course Refinancing U.S. Bank First American Treasury Obligation Fund $987,500.19 Instl Res Tre and Agny Cash Adv6541 $814,826.15
Financial Guaranty Insurance Pol $1.00
CAMP $1,941,854.86
Total $2,756,682.01
Instl Res Tre and Agny Cash Adv6541 $333,745.42
Cash $59,324.84
CAMP $4,803,939.06
Total $5,197,009.32
2018 Wastewater Refunding Bank of New York Fidelity Inv MM Trsy Only $15.64 Fairview Village Refunding US Bank First American Government $195,916.67 Blackrock Federal Fund Instl 30 $2,023.08
CAMP $2,750,380.72
Total $2,752,403.80
PCE Litigation Bank of America Business Interest Maximizer $491,968.93 Water ARRA Grants Bank of the West Business Money Market $36,289.42 Other Post Employment Benefits Section 115
Trust PARS HighMark Plus Moderate $1,321,762.82
Pension Section 115 Trust PARS HighMark Plus Moderately Conservative $2,384,098.36 Innovative Claim Solutions* (Previous Third
Party Administrator - Worker's Compensation) Wells Fargo Bank Business Money Market $187,398.93 Athens Administrators (New Third Party
Administrator - Worker's Compensation) Wells Fargo Bank $667,634.70 George Hills Company - General Liability Claims
Administration Services California Bank & Trust $82,842.88 Kemper Sports Management Inc. BMO Harris Bank Business Money Market $131,274.28 Stanislaus Community Foundation Modesto Commerce Bank Charles Schwab $654,148.05 California Bank of
Commerce $3,291,622.27
Columbia Bank $135,820.64
Banner Bank $19,282.55
Village One #2 Refunding Bank of New York
Third-Party Construction Contract Retention
* The amount showing for Innovative Claim Solutions is the actual bank account balance and not the reconciled amount after outstanding checks. The City is in the process of switching third party administrators and closing this account.

Cash with Fiscal Agent Investments
As of September 30, 2022
2008 Water Refunding COP Bank of New York
2008 Lease Revenue Bonds Bank of New York
#18..
- 509 -

CITY OF MODESTO

COUNCIL AGENDA REPORT
DATE OF MEETING:

January 10, 2023
Date: December 13, 2022
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: Alan Ernst, Fire Chief
SUBJECT: Amendment to ZOLL Data Systems, Inc. Agreement CONTACT: Alan Ernst, Fire Chief, [email protected] , 209-572-9590 DESCRIPTION:

Consider approving a First Amendment with ZOLL Data Systems, Inc. for Hosted Server Services for both ePCR and FireRMS Records Management and Reporting Software for Salida Fire Services and future fire contract services for a total revised amount not to exceed $272,296. (Funding Source: General Fund)
STRATEGIC PLAN ELEMENT:

This action supports the City of Modesto 2020-2025 Strategic Plan focus on quality of life under Goal A: Improve Community Safety.

BACKGROUND:

The Modesto Fire Department (MFD) has been utilizing ZOLL’s FireRMS as the department’s records management system for more than 15 years. Prior to 2019, the servers that stored and transmitted the data were owned and hosted by the City of Modesto Information Technology (IT) Department, and then transitioned to the Stanislaus County’s IT Department (SBT). This ownership and middle layer of coordination not only created time delays that hindered the department’s ability to comply with mandated reporting requirements, but it also created expenses by both the server owner and ZOLL for time and support, specifically when technical issues arose.

On May 3, 2022, by Resolution No. 2022-205, Council approved the renewal agreement with Zoll Data Systems, Inc. for hosted server services for both ePCR and FireRMS records management and reporting software, in an annual estimated amount of $77,124, with a one-time ePCR implementation fee of $7,500, for a total three-year agreement not to exceed $238,872.00.

DISCUSSION:

On September 13, 2022, by Resolution 2022-370, Council approved an agreement to provide fire protection services between the City of Modesto and the Salida Fire #19..
- 510 -
City Council, January 10, 2023
Amendment to ZOLL Data Systems, Inc. Agreement

Page 2 of 3 ends

Protection District. With this addition of service by the Modesto Fire Department, the city now faces increased expenditures for services by Zoll Data Systems which necessitates the amendment to the agreement.

The proposed amendment will allow services to be utilized by Station 12 (Salida) for a cost of $8,424. The current agreement expires on July 18, 2025 and the term remains unchanged with the addition of Salida’s services. Additionally, based on successful fire services agreements in the recent past, the department is seeking the additional $25,000.00 as a contingency in the event the department enters into a new fire services agreement which would then require additional Zoll hosted server services. This option will provide a greater ease of service transition.

FISCAL IMPACT:

The Modesto Fire Department currently expends approximately $44,271 annually on the user agreements for both Hosted RescueNet and FireRMS Programs. Funding for this agreement increase would come from the existing line items in the department’s operating budget across those cost centers that are specific to service contract with Oakdale, Ceres, and now Salida.

The additional funds needed would be pulled from the existing budget cost center for Salida.

Funds have been identified to cover the annual cost of $2,808, for the three-year contract. The new total cost of the three-year contract will be approximately $247,296. Should we take on an additional contract for service, the contingent $25,000 will be assigned to a new cost center to be created upon approval of a contract and bring the total to $272,296.

Fund/Cost Center Description Amount Account
General Fund/Salida $8,424 0100-18217-53030
General Fund (Cost Center
Contingent)
$25,000 0100-18XXX-53030
COMMITTEE RECOMMENDATION:

This project was presented to Safety and Communities Committee on December 12, 2022, and was recommended to forward to Council for approval.

RECOMMENDED COUNCIL ACTION:

Staff Recommendations:

Resolution approving a First Amendment with ZOLL Data Systems, Inc. for Hosted Server Services for both ePCR and FireRMS Records Management and Reporting Software for Salida Fire Services and future fire contract services by increasing the amount by $33,424 for a total revised amount not to exceed $272,296 and authorizing the City Manager, or his designee to execute the Amendment.

Approved by:

Alan Ernst, Fire Chief
#19..
- 511 -
City Council, January 10, 2023
Amendment to ZOLL Data Systems, Inc. Agreement

Page 3 of 3 ends

Joseph P. Lopez, City Manager
Attachments:

1. Resolution

2. Zoll Quote 41684 For Salida Annual Service

3. Q29282 SIGNED- Modesto and Oakdale

4. Q30206 SIGNED- Ceres
#19..
- 512 -
1 01/10/2023/Fire/AErnst/Item # 2023-xxx

MODESTO CITY COUNCIL
RESOLUTION NO. 2023-XX

RESOLUTION APPROVING A FIRST AMENDMENT WITH ZOLL DATA
SYSTEMS, INC. FOR HOSTED SERVER SERVICES FOR BOTH EPCR AND

FIRERMS RECORDS MANAGEMENT AND REPORTING SOFTWARE FOR

SALIDA FIRE SERVICES AND FUTURE FIRE CONTRACT SERVICES BY INCREASING THE AMOUNT BY $33,424 FOR A TOTAL REVISED AMOUNT NOT TO EXCEED $272,296 AND AUTHORIZING THE CITY MANAGER, OR

HIS DESIGNEE TO EXECUTE THE AMENDMENT
WHEREAS, the Modesto Fire Department (MFD) has been utilizing ZOLL’s FireRMS as the department’s records management system for more than 15 years; and WHEREAS, on May 3, 2022, by Resolution No. 2022-205, Council approved the renewal agreement with Zoll Data Systems, Inc. for hosted server services for both ePCR and FireRMS records management and reporting software, in an annual estimated amount of $77,124, with a one-time ePCR implementation fee of $7,500, for a total three-year agreement not to exceed $238,872.00; and
WHEREAS, on September 13, 2022, by Resolution 2022-370, Council approved an agreement to provide fire protection services between the City of Modesto and the Salida Fire Protection District. With this addition of service by the Modesto Fire Department, the city now faces increased expenditures for services by Zoll Data Systems which necessitates the amendment to the agreement; and
WHEREAS, the proposed amendment will allow services to be utilized by Station 12 (Salida) for a cost of $8,424; and
WHEREAS, based on successful fire services agreements in the recent past, the department is seeking the additional $25,000.00 as a contingency in the event the department enters into a new fire services agreement which would then require additional Zoll hosted server services. This option will provide a greater ease of service transition. #19..
- 513 -
2 01/10/2023/Fire/AErnst/Item # 2023-xxx
NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves a First Amendment with ZOLL Data Systems, Inc. for Hosted Server Services for both ePCR and FireRMS Records Management and Reporting Software for Salida Fire Services and future fire contract services for a total revised amount not to exceed $272,296.

BE IT FURTHER RESOLVED, that the City Manager, or his designee is hereby authorized to execute the Agreement, in a form approved by the City Attorney.

The foregoing resolution was introduced in a regular meeting of the Council of the City of Modesto held on the 10th day of January 2023, by Councilmember ________, who moved its adoption, which motion being duly seconded by Councilmember ______, was upon roll call carried and the resolution adopted by the following vote:

AYES: Councilmembers:

NOES: Councilmembers:

ABSENT: Councilmembers:

ATTEST: _____________________________
DIANE NAYARES-PEREZ, City Clerk
(SEAL)
APPROVED AS TO FORM:

BY: _______________________________________
JOSE M. SANCHEZ, City Attorney
#19..
- 514 -
ZOLL Data Systems, Inc.
11802 Ridge Parkway, Suite 400
Broomfield, Colorado 80021
(303) 801-0000 Main
(800) 474-4489
(303) 801-1063 Fax
Federal ID#: 65-0461124

Page 1 of 2 ends

Attn: Modesto Fire Department - Aurelia Harris
(209) 480-0150 / [email protected]
Bill To: Modesto Fire Department
PO Box 642
Modesto, CA 95353
Ship To: Modesto Fire Department
600 11th Street
Modesto, CA 95354
From: Jonathan Stewart
Data - Territory Sales Associate
[email protected]
QUOTATION:

Date:

Term:

FOB:

Expires:

Q-41684
September 27, 2022
36 Months
Shipping Point
November 26, 2022
ASP Services Term in Months: 36
Item
Lic.

Type Description Qty List Price Disc Adj. Price
Annual Fees or
One Time Charge Monthly Fees
HFPL HL Hosted RescueNet FireRMS Plus (Per Station)
Inc: NFIRS Incidents, Hydrants, EMS Reporting, Vehicles, Personnel, Equipment, Roster, Daybook, Training,
Messaging, Credentials, Reports, Occupancies, Sync Mgr, 3rd Party Monitor SDK, Security and Admin, 1 SMS
Interface.
1 $234.00 $234.00 $2,808.00 $234.00
#19..
- 515 -
ZOLL Data Systems, Inc.
11802 Ridge Parkway, Suite 400
Broomfield, Colorado 80021
(303) 801-0000 Main
(800) 474-4489
(303) 801-1063 Fax
Federal ID#: 65-0461124
TO: Modesto Fire Department - Quote No: Q-41684 Continued

Page 2 of 2 ends

SUMMARY OF FEES & COMMENTS
1MONTHLY FEES: $234.00
1ANNUAL FEES: $2,808.00
ANNUAL FEES FOR MULTI-YEAR TERM: $8,424.00

Comments:

BLANK

1. MONTHLY & ANNUAL FEES ARE SUBJECT TO ADJUSTMENT AS DEFINED IN THE ORDER.

2. APPLICABLE TAX, SHIPPING & HANDLING WILL BE ADDED AT TIME OF INVOICING.

3. ALL ORDERS ARE SUBJECT TO CREDIT APPROVAL BEFORE ACCEPTANCE BY ZOLL.

4. DELIVERY OF ADDITIONAL SOFTWARE LICENSES ARE TYPICALLY MADE WITHIN 48 HOURS FOLLOWING THE RECEIPT OF A SIGNED ORDER FORM.

DELIVERY OF ROAD SAFETY ADD ON COMPONENTS ARE TYPICALLY MADE THE FRIDAY FOLLOWING THE RECEIPT OF THE ORDER.

5. FURTHER TERMS & CONDITIONS APPLY AND CAN BE FOUND AT https://www.zolldata.com/legal.

TOTAL FEES FOR INITIAL TERM: $8,424.00
#19..
- 516 -
Order Order No.: Q-29282

Page 1 of 4 ends

THIS ORDER FORM (this ''Order'') is made as of the date on which both parties have signed below (the ''Effective Date'') by and between ZOLL Data Systems, Inc., a Delaware corporation with offices at 11802 Ridge Parkway, Suite 400, Broomfield, CO 80021, [email protected] (''ZOLL'') and Modesto Fire Department (the ''Customer'').

Bill To: Modesto Fire Department
PO Box 642
Modesto, CA 95353
Email for Notices: [email protected]
Ship To: Modesto Fire Department
600 11th Street
Modesto, CA 95354
Territory Manager: Jonathan Stewart Offer Expires: 05/30/2022 ASP Services
Item
Lic.

Type Description Qty Price
Annual Fees or
One Time Charge Monthly Fees
HFPL HL Hosted RescueNet FireRMS Plus (Per Station) 15 $216.32 $38,937.60 $3,244.80 HFRMPL HL Hosted RescueNet FireRMS-Mobile Plus (Per Device) 10 $54.08 $6,489.60 $540.80 ICC19CAH TPL Hosted ICC 2019 CA - Intl. Fire Code Lic. Per Concurrent User (Per Month)
10 $15.00 $1,800.00 $150.00
ICC19CAM
H
TPL Hosted ICC 2019 CA - Intl. Fire Code Lic. Mobile Per Device (Per Month)
10 $5.00 $600.00 $50.00
*MONTHLY FEES: $3,985.60
*ANNUAL FEES: $47,827.20
ANNUAL FEES FOR INITIAL TERM: $143,481.60
Comments: Renewal effective 07/19/2022 for subscriptions:

A-S00007003
A-S00007003
A-S00004159
A-S00004158
A-S00004158
BLANK
ASP Services Payment Terms: ZOLL will invoice Customer for the sum of any One-Time Fees and the Professional Services Fees listed above for the deployment of each of the ASP Services listed above upon completion of the Professional Services for which such Professional Services Fees are payable. ZOLL separately will invoice Customer for Expenses incurred by ZOLL in providing such Professional Services.

Additionally, ZOLL will invoice Customer upon the earlier of the Deployment Date or 60 days after on the Effective Date (the ''Monthly Fees Commencement Date'') and at the beginning of each calendar month during the Term for the amount of the Monthly Fees listed above for such ASP Services (i) prorated to account for any partial month, (ii) increased or decreased as set forth in the Adjustments to Fees section below and (iii) if such Monthly Fees are based on the quantity of Concurrent Users, increased by an amount equal to $10 per month for any Registered User in excess of 200% of the Concurrent Users Cap.

Monthly Fees are payable in advance for each month of ASP Services (''Monthly Service Period''), except for the first Monthly Service Period. Accordingly, the first invoice for Monthly Fees shall be for the amount of the Monthly Fee for the first Monthly Service Period and the Monthly Fee for the second Monthly Service Period. Each subsequent invoice shall be for the amount of the Monthly Fee.

Term. Unless earlier terminated as set forth in the Agreement, (i) the initial term of this Order shall begin on the Effective Date and continue for 36 months after the Monthly Fees Commencement Date (the ''Initial Term'') and (ii) after the Initial Term, this Order automatically shall continue on a month-to-month basis until so terminated.

Early Termination Fee. Notwithstanding the Agreement, if this Order is terminated prior to the expiration of the Initial Term by ZOLL for a material default or by Customer without cause, then Customer immediately shall pay ZOLL an early termination fee equal the amount of (i) the Annual Fees for the Initial Term minus (ii) the sum of Monthly Fees paid by Customer to ZOLL prior to the date of termination for the ASP Services or Software set forth in this Order. * Adjustments to Fees: Fees are subject to adjustment based on quantity as set forth in the attached Adjustment-to-Fees Addendum, including as a result of Registered Users being in excess of the Concurrent Users Cap for Fees based on Concurrent Users:

TOTAL FEES FOR INITIAL TERM: $143,481.60
DocuSign Envelope ID: 77F7B2B5-A88B-462F-9484-D46D45B9A5CD #19..
- 517 -
Order Order No.: Q-29282

Page 2 of 4 ends

THIS ORDER IS SUBJECT TO THE TERMS AND CONDITIONS, AND APPLICABLE ADDENDA, AVAILABLE AT https://www.zolldata.com/legal, WHICH ARE INCORPORATED BY REFERENCE. BY SIGNING BELOW, CUSTOMER ACKNOWLEDGES HAVING READ AND AGREES TO AND INTENDS TO BE BOUND BY THEM. HARD COPIES ARE AVAILABLE UPON REQUEST.

Each person signing below represents and warrants that she or he has the authority to bind the party for which he or she is signing to the terms of this Order. By signing below, the parties agree to the terms and conditions of this Order. Once signed, any reproduction of this Order made by reliable means (for example, photocopy or facsimile) is considered an original.

ZOLL Data Systems, Inc.

Authorized Signature: \ZCPQOPP_1_text\
\s2\
Name: \n2\
Title: \t2\
Date: \d2\

Modesto Fire Department
Authorized Signature: \ZCPQAcct_1\
\s1\
Name: \n1\
Title: \t1\
Date: \d1\
DocuSign Envelope ID: 77F7B2B5-A88B-462F-9484-D46D45B9A5CD 0064p00000XOlos
City Manager
5/25/2022 | 13:49 PDT
Joseph Lopez
001A000000AV6sg
Sandy King
5/25/2022 | 13:52 PDT
Director of Operational Accounting
#19..
- 518 -
Adjustments-to-Fees Addendum Order No.: Q-29282

Page 3 of 4 ends

* Adjustments to Fees: Fees in the Order Form to which this addendum is attached (the “Order”), and of which it is a part, are subject to adjustment based on quantity as specified below (“Qty”), including as a result of Registered Users being in excess of the Concurrent Users Cap for Fees based on Concurrent Users:

Product Basis for Adjustment
ZOLL AR Boost Qty of transactions (the “Transaction Volume”). Within thirty (30) days following the end of each month, ZOLL shall (i) conduct an audit of the Transaction Volume for each of the ASP Services listed above; (ii) multiply the Transaction Volume by the per-transaction price for each of the ASP Services listed above (the “Total Monthly Price”); and (iii) calculate the sum of the Total Monthly Prices for all of the ASP Services listed above (the “Total Monthly Price for All ASP Services”). If the Total Monthly Price for All ASP Services in any month is greater than the applicable Monthly Fees listed in the Order, then ZOLL shall invoice Customer for such excess per the overage charges listed in the Order. If the Total Monthly Price for All ASP Services for any month is equal to or less than the applicable Monthly Fee listed in the Order, then ZOLL shall not be obligated to refund Customer all or any part of the Monthly Fees for such month.

In no event shall Customer pay less than the applicable Monthly Fees for any month.

RescueNet® Billing Pro Qty of trips (the “Trip Volume”) listed in the line item in the Order. ZOLL may conduct an audit of Trip Volume following the 12th month after the Monthly Fees Commencement Date for Billing Pro and each anniversary of such date (a “Trip Audit”). Should actual Trip Volume, less any exclusions listed as a line item in the Order (“Exclusions”), which shall be increased or decreased prorata with actual Trip Volume (the “Actual Trip Volume”), for the preceding 12-month period (the “Trip Audit Period”) exceed 110% of the quantity of trips, less any Exclusions listed in the Order without a prorata increase or decrease, that was the basis for Monthly Fees in the Trip Audit Period multiplied by 12 (the “Estimated Trip Volume”), then ZOLL will invoice Customer for such excess multiplied by the per-trip price listed in the Order (the “Per-Trip Price”). Should the Actual Trip Volume be less than the Estimated Trip Volume by more than 10% during the Trip Audit Period, then ZOLL will issue a credit in the amount of 10% of the Estimated Trip Volume multiplied by the Per-Trip Price. Future billings of the Monthly Fee will be adjusted based on the Actual Trip Volume as determined by the Trip Audit; provided, that the Monthly Fee shall not decrease by more than 10%.

ZOLL emsCharts
ZOLL emsCharts –
Critical Care
Qty of PCRs (the "PCR Volume") listed in the line item in the Order. ZOLL may conduct an audit of PCR Volume following the 12th month after the Monthly Fees Commencement Date for ZOLL emsCharts and each anniversary of such date (a “PCR Audit”). Should actual PCR Volume (the “Actual PCR Volume”) for the preceding 12-month period (the “PCR Audit Period”) exceed 110% of the quantity of PCRs that was the basis for Monthly Fees in the PCR Audit Period multiplied by 12 (the “Estimated PCR Volume”), then ZOLL will invoice Customer for such excess multiplied by the per-PCR price listed in the Order (the “Per-PCR Price”). Should the Actual PCR Volume be less than the Estimated PCR Volume by more than 10% during the PCR Audit Period, then ZOLL will issue a credit in the amount of 10% of the Estimated PCR Volume multiplied by the Per-PCR Price. Future billings of the Monthly Fee will be adjusted based on the Actual PCR Volume as determined by the PCR Audit; provided, that the Monthly Fee shall not decrease by more than 10%.

ZOLL Fire Reports Qty of Fire Reports (the "Fire Report Volume") listed in the line item in the Order. ZOLL may conduct an audit of Fire Report Volume following the 12th month after the Monthly Fees Commencement Date for ZOLL Fire Reports and each anniversary of such date (a “Fire Report Audit”). Fire Report Volume (the “Actual Fire Report Volume”) for the preceding 12-month period (the “Fire Report Audit Period”) exceed 110% of the quantity of Fire Reports that was the basis for Monthly Fees in the Fire Report Audit Period multiplied by 12 (the “Estimated Fire Report Volume”), then ZOLL will invoice Customer for such excess multiplied by the per-Fire Report price listed in the Order (the “Per-Fire Report Price”). Should the Actual Fire Report Volume be less than the Estimated Fire Report Volume by more than 10% during the Fire Report Audit Period, then ZOLL will issue a credit in the amount of 10% of the Estimated Fire Report Volume multiplied by the Per-Fire Report Price. Future billings of the Monthly Fee will be adjusted based on the Actual Fire Report Volume as determined by the Fire Report Audit; provided, that the Monthly Fee shall not decrease by more than 10%.

EMS Mobile Health Qty of the tier based on number of visits. Following six months from the Monthly Fees Commencement Date and every six months thereafter, ZOLL will conduct an audit of the number of monthly visits (the “Visit Volume”). Should the monthly Visit Volume for any six month period exceed 110% of the maximum monthly visits for the current tier, then commencing the first month after the completion of the audit, ZOLL will invoice Customer based on the new Visit Volume as determined by the audit and based on the following tiers:
(i) $750.00 for 1-150 visits per month; (ii) $1,250.00 for 151-300 visits per month; (iii) $2,000.00 for 301-600 visits per month; and (iv) as quoted by ZOLL more than 600 visits per month.

Packaged Services Qty of trips (the ''Trip Volume'') listed in the line item in the Order. ZOLL may conduct an audit of Trip Volume following the 12th month after the Monthly Fees Commencement Date for Packaged Services and each anniversary of such date (a “Trip Audit”). Should actual Trip Volume (“Actual Trip Volume”) for the preceding 12-month period (the “Trip Audit Period”) exceed 110% of the quantity of trips that was the basis for Monthly Fees in the Trip Audit Period multiplied by 12 (the “Estimated Trip Volume”), then ZOLL will invoice Customer for such excess multiplied by the per-trip price listed in the Packaged Services– Overage line item in the Order. Should the Actual Trip Volume be less than the Estimated Trip Volume by more than 10% during the Trip Audit Period, then ZOLL will issue a credit in the amount of 10% of the Estimated Trip Volume multiplied by the per-trip price listed in the Packaged Services – Overage line item in the Order. Future billings of the Monthly Fee will be adjusted based on the Actual Trip Volume as determined by the Trip Audit; provided, that the Monthly Fee shall not decrease by more than 10%.

Packaged Services
Premium
Qty of trips (the ''Trip Volume'') listed in the line item in the Order. ZOLL may conduct an audit of Trip Volume following the 12th month after the Monthly Fees Commencement Date for Packaged Services Premium and each anniversary of such date (a “Trip Audit”).

Should actual Trip Volume (“Actual Trip Volume”) for the preceding 12-month period (the “Trip Audit Period”) exceed 110% of the quantity of trips that was the basis for Monthly Fees in the Trip Audit Period multiplied by 12 (the “Estimated Trip Volume”), then ZOLL will invoice Customer for such excess multiplied by the per-trip price listed in the Packaged Services Premium – Overage line item in the Order. Should the Actual Trip Volume be less than the Estimated Trip Volume by more than 10% during the Trip Audit Period, then ZOLL will issue a credit in the amount of 10% of the Estimated Trip Volume multiplied by the per-trip price listed in the Packaged Services Premium – Overage line item in the Order. Future billings of the Monthly Fee will be adjusted based on the Actual Trip Volume as determined by the Trip Audit; provided, that the Monthly Fee shall not decrease by more than 10%.

RescueNet® Billing Qty of Concurrent Users.

RescueNet Dispatch Qty of Concurrent Users.

RescueNet Eligibility Qty of trips.

RescueNet FireRMS Qty of stations.

RescueNet Navigator Qty of Customer vehicles.

RescueNet @Work Qty of Customer vehicles estimated in Order, or Qty of trips if specified in the line item in the Order.

RescueNet® ePCR Qty of PCRs (the "PCR Volume") listed in the line item in the Order. ZOLL may conduct an audit of PCR Volume following the 12th month after the Monthly Fees Commencement Date for RescueNet ePCR and each anniversary of such date (a “PCR Audit”). Should actual PCR Volume (the “Actual PCR Volume”) for the preceding 12-month period (the “PCR Audit Period”) exceed 110% of the quantity of PCRs that was the basis for Monthly Fees in the PCR Audit Period multiplied by 12 (the “Estimated PCR Volume”), then DocuSign Envelope ID: 77F7B2B5-A88B-462F-9484-D46D45B9A5CD #19..
- 519 -
Adjustments-to-Fees Addendum Order No.: Q-29282

Page 4 of 4 ends

Product Basis for Adjustment
ZOLL will invoice Customer for such excess multiplied by the per-PCR price listed in the Order (the “Per-PCR Price”). Should the Actual PCR Volume be less than the Estimated PCR Volume by more than 10% during the PCR Audit Period, then ZOLL will issue a credit in the amount of 10% of the Estimated PCR Volume multiplied by the Per-PCR Price. Future billings of the Monthly Fee will be adjusted based on the Actual PCR Volume as determined by the PCR Audit; provided, that the Monthly Fee shall not decrease by more than 10%.

Mobile Care Connect Qty of trips (the “Trip Volume”) listed in the line item above. ZOLL may conduct an audit of Trip Volume following the 12th month after the Monthly Fees Commencement Date and each anniversary of such date (a “Trip Audit”). Should actual Trip Volume (the “Actual Trip Volume”) for the preceding 12-month period (the “Trip Audit Period”) exceed 110% of the quantity of trips that was the basis for Monthly Fees in the Trip Audit Period multiplied by 12 (the “Estimated Trip Volume”), then ZOLL will invoice Customer for such excess multiplied by the per-trip price listed above, subject to increase in accordance with the Agreement (the “Per-Trip Price”); provided, that should Actual Trip Volume during any calendar month during the Trip Audit Period be (i) less than 300 trips, then the Monthly Fee attributable to such month will be the Per-Trip Price multiplied by 300 or (ii) more than 1,800 trips, then Monthly Fee attributable to such month will be the Per-Trip Price multiplied by 1,800 (the “Adjusted Trip Volume”). Future billings of the Monthly Fee will be adjusted based on the Adjusted Trip Volume.

ZOLL Billing Qty of claims (the ''Claim Volume'') listed in the line item in the Order. ZOLL may conduct an audit of Claim Volume following the 12th month after the Monthly Fees Commencement Date for ZOLL Billing and each anniversary of such date (a ''Claim Audit''). Should actual Claim Volume (the ''Actual Claim Volume'') for the preceding 12-month period (the ''Claim Audit Period'') exceed 110% of the quantity of claims that was the basis for Monthly Fees in the Claim Audit Period multiplied by 12 (the ''Estimated Claim Volume''), then ZOLL will invoice Customer for such excess multiplied by the applicable per-claim price, determined as if such excess were the final claims in Actual Claim Volume, less any discounts specified in the Order. Future billings of the Monthly Fee will be adjusted based on the Actual Claim Volume as determined by the Claim Audit; provided, that the Monthly Fee shall not decrease by more than 10%.

ZOLL Respond Qty of trips (the ''Trip Volume'') listed in the line item in the Order. ZOLL may conduct an audit of Trip Volume following the 12th month after the Monthly Fees Commencement Date for ZOLL Respond and each anniversary of such date (a ''Trip Audit''). Should actual Trip Volume (the ''Actual Trip Volume'') for the preceding 12-month period (the ''Trip Audit Period'') exceed 110% of the quantity of trips that was the basis for Monthly Fees in the Trip Audit Period multiplied by 12 (the ''Estimated Trip Volume''), then ZOLL will invoice Customer for such excess multiplied by the applicable per-trip price, determined as if such excess were the final trips in Actual Trip Volume, less any discounts specified in the Order. Future billings of the Monthly Fee will be adjusted based on the Actual Trip Volume as determined by the Trip Audit; provided, that the Monthly Fee shall not decrease by more than 10%. Actual Trip Volume includes only trips that have entered transporting status.

ZOLL Care Exchange Qty of transports (the "Transport Volume'') listed in the line above. ZOLL may conduct an audit of Transport Volume following the 12th month after the Monthly Fees Commencement Date for ZOLL Care Exchange and each anniversary of such date (a ''Transport Audit''). Should actual Transport Volume (the ''Actual Transport Volume'') for the preceding 12-month period (the ''Transport Audit Period'') exceed 110% of the quantity of transports that was the basis for Monthly Fees in the Transport Audit Period (the ''Estimated Transport Volume''), then ZOLL will invoice Customer for such excess in accordance with the tiers set forth below (the “Tiers”) based on the Actual Transport Volume, determined as if such excess were the final claims in Actual Transport Volume, less any discounts specified in the Order. Future billings of the Monthly Fee will be adjusted based on the Actual Transport Volume as determined by the Transport Audit; provided, that the Monthly Fee shall not decrease by more than 10%.

Tiers for ZOLL Care Exchange. The following Tiers apply to ZOLL Care Exchange based on the Qty of transports per year:

Qty Annual Fee Qty Annual Fee Qty Annual Fee Qty Annual Fee Qty Annual Fee Up to 9,999 $17,500.00 20,000-29,999 $31,500.00 40,000-49,999 $45,500.00 60,000-69,999 $59,500.00 80,000-89,999 $73,500.00 10,000-19,999 $24,500.00 30,000-39,999 $38,500.00 50,000-59,999 $52,500.00 70,000-79,999 $66,500.00 90,000-99,999 $80,500.00 DocuSign Envelope ID: 77F7B2B5-A88B-462F-9484-D46D45B9A5CD #19..
- 520 -
Order Order No.: Q-30206

Page 1 of 4 ends

Type Description Qty Price Extended Price
Annual
Maintenance
RNFD --- RescueNet FireRMS Implementation Day (Excludes T&E)

0 $1,500.00 $0.00 $0.00
ASP Services
Item
Lic.

Type Description Qty Price
Annual Fees or
One Time Charge Monthly Fees
HFRMPL HL Hosted RescueNet FireRMS-Mobile Plus (Per Device) 4 $54.08 $2,595.84 $216.32 HFPL HL Hosted RescueNet FireRMS Plus (Per Station) 4 $216.32 $10,383.36 $865.28 ICC1510H TPL Hosted ICC 2015 - Intl. Fire Code Lic. 10 Concurrent Users (Per Month)
1 $37.86 $454.32 $37.86
ICC19CAH TPL Hosted ICC 2019 CA - Intl. Fire Code Lic. Per Concurrent User (Per Month)
4 $15.00 $720.00 $60.00
ICC19CAM
H
TPL Hosted ICC 2019 CA - Intl. Fire Code Lic. Mobile Per Device (Per Month)
4 $5.00 $240.00 $20.00
*MONTHLY FEES: $1,199.46
*ANNUAL FEES: $14,393.52
ANNUAL FEES FOR INITIAL TERM: $43,180.56
Comments: Renewal to start 07/01/2022
PROFESSIONAL SERVICES FEES: $0.00
BLANK
Professional Services Expenses. Customer will reimburse ZOLL for Expenses incurred by ZOLL in providing the Professional Services. Any estimated Expenses above are based on the facts that ZOLL currently knows and represent ZOLL’s good faith assessment of the time and materials required.

ASP Services Payment Terms: ZOLL will invoice Customer on the Effective Date (the ''Monthly Fees Commencement Date'') and at the beginning of each calendar month during the Term for the amount of the Monthly Fees for each of the ASP Services listed above (i) prorated to account for any partial month, (ii) increased or decreased as set forth in the Adjustments to Fees section below and (iii) if such Monthly Fees are based on the quantity of Concurrent Users, increased by an amount equal to $10 per month for any Registered User in excess of 200% of the Concurrent Users Cap. Additionally, ZOLL will invoice Customer on the Monthly Fees Commencement Date for any One-Time Fees listed above.

TOTAL FEES FOR INITIAL TERM: $43,180.56
DocuSign Envelope ID: 89A50D53-1242-40F0-9623-2C15FECDEF3E #19..
- 521 -
Order Order No.: Q-30206

Page 2 of 4 ends

ZOLL Data Systems, Inc.

Authorized Signature: \ZCPQOPP_1_text\
\s2\
Name: \n2\
Title: \t2\
Date: \d2\

Modesto Fire Department
Authorized Signature: \ZCPQAcct_1\
\s1\
Name: \n1\
Title: \t1\
Date: \d1\
DocuSign Envelope ID: 89A50D53-1242-40F0-9623-2C15FECDEF3E Joseph Lopez
5/9/2022 | 10:46 PDT
City Manager
0064p00000XOyu4 001A000000AV6sg
Director of Operational Accounting
Sandy King
5/9/2022 | 15:37 PDT
#19..
- 522 -
Adjustments-to-Fees Addendum Order No.: Q-30206

Page 3 of 4 ends

In no event shall Customer pay less than the applicable Monthly Fees for any month.

RescueNet® Billing Qty of Concurrent Users.

RescueNet Dispatch Qty of Concurrent Users.

RescueNet Eligibility Qty of trips.

RescueNet FireRMS Qty of stations.

RescueNet Navigator Qty of Customer vehicles.

RescueNet @Work Qty of Customer vehicles estimated in Order, or Qty of trips if specified in the line item in the Order.

RescueNet® ePCR Qty of PCRs (the "PCR Volume") listed in the line item in the Order. ZOLL may conduct an audit of PCR Volume following the 12th month after the Monthly Fees Commencement Date for RescueNet ePCR and each anniversary of such date (a “PCR Audit”). Should actual PCR Volume (the “Actual PCR Volume”) for the preceding 12-month period (the “PCR Audit Period”) exceed 110% of the quantity of PCRs that was the basis for Monthly Fees in the PCR Audit Period multiplied by 12 (the “Estimated PCR Volume”), then DocuSign Envelope ID: 89A50D53-1242-40F0-9623-2C15FECDEF3E #19..
- 523 -
Adjustments-to-Fees Addendum Order No.: Q-30206

Page 4 of 4 ends

Tiers for ZOLL Care Exchange. The following Tiers apply to ZOLL Care Exchange based on the Qty of transports per year:

CITY OF MODESTO

COUNCIL AGENDA REPORT
DATE OF MEETING:

January 10, 2023
Date: December 16, 2022
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: Laurie A. Smith, Director of Parks, Recreation and Neighborhoods Department SUBJECT: Second Amendment for Portable Toilet Rental Services CONTACT: Laurie A. Smith, Director, [email protected], 209-577-5347 DESCRIPTION:

Consider approving a Second Amendment to the Agreement with United Site Services, Inc. of Modesto, CA for Portable Toilet Rental Services for a revised total amount not to exceed $583,250 over the term of the Agreement for United Site Services and Sun Valley Portable Restrooms, Inc., Turlock, CA. (Funding Source: Golf Fund) STRATEGIC PLAN ELEMENT:

This item supports the City of Modesto 2020-2025 Strategic Plan focus on Quality of Life, Goal D: provide safe, efficient, and reliable infrastructure through proactive community investment, maintenance and sustainability efforts.

BACKGROUND:

On April 28, 2020, by Resolution 2020-194, Council approved the award of bid for portable toilet rental services to United Site Services, Inc. of Modesto, CA as the primary supplier for daily, weekly and monthly rentals and the secondary supplier for yearly rentals and to Sun Valley Portable Restrooms, Inc., Turlock, CA, for a two-year agreement with three (3) one-year extension options for an estimated combined annual cost of $54,888 and a total combined cost not to exceed $274,440 over five years for both.

On August 4, 2020, the Dryden Golf Park Clubhouse was heavily damaged by a fire. The City contacted its insurance provider, Alliant, to establish a claim and to identify next steps. Alliant dispatched Belfor Property Restoration (Belfor) to secure the property.

Belfor brought a portable restroom unit onsite immediately after the fire to reopen the golf course for play. Once Belfor had completed securing the property, they transferred the restroom lease to the City to continue those services until the Clubhouse was rebuilt. The portable restroom lease was under United Site Services (United). Since the City already maintained a contract with United, staff needed to add additional funding to cover the cost of the lease.
#20..
- 525 -
City Council, January 10, 2023
Second Amendment for Portable Toilet Rental Services

Page 2 of 3 ends

On April 13, 2021, by Resolution 2021-135, Council approved a first amendment to the agreement with United Site Services, Inc. of Modesto, CA for a Portable Americans with Disability (ADA) Restroom Trailer to increase the agreement amount by $91,210 from $274,440 to a new total amount of $365,650 over the term of the agreement for United Site Services and Sun Valley Portable Restrooms, Inc., Turlock, CA.

DISCUSSION:

The Dryden Golf Clubhouse renovation is ongoing and still in its design phase. Staff is negotiating with the City insurance provider, Alliant, on the reconstruction cost of the Clubhouse.

At this time, it is estimated that construction will begin in Fall 2023. The portable restroom unit, that was brought onsite by Belfor in August of 2020, remains in use.

The First amendment increased the Portable Toilet Rental Services agreement by $91,210 for the portable ADA unit at Dryden Golf Course. The City continues to use these services and will continue to use them until the end of 2024 in anticipation that the Clubhouse will be rebuilt by that time.

As such, staff is requesting an increase to the current agreement for Portable Toilet Rental Services by an additional one-time amount of $217,600. This amount will cover the ADA unit at Dryden Clubhouse through December 2024. The current agreement for Portable Toilet Rental Services is $365,650. The addition of $217,600 will bring the agreement to a new total of $583,250.

FISCAL IMPACT:

This second amendment of the increase of $217,600 for this agreement will be funded 100% through the property insurance provider, Alliant. The chart below shows the annual breakdown of the additional funding:

Term Annual Cost ADA Unit Revised Annual Cost
1 April 2020 – April 2021 $ 54,888 $ 54,888
2 April 2021 – April 2022 $ 54,888 $ 91,210 $146,098 1
st Amendment
3 April 2022 – April 2023 $ 54,888 $ 81,600 $136,488 2
nd Amendment
4 April 2023 – April 2024 $ 54,888 $ 81,600 $136,488 2
nd Amendment
5 April 2024 – April 2025 $ 54,888 $ 54,400 $109,288 2
nd Amendment
$274,440 $308,810 $583,250
COMMITTEE RECOMMENDATION:

This item was approved by the Safety and Communities Committee on December 12, 2022, which recommended it be forwarded to Council for approval.

RECOMMENDED COUNCIL ACTION:

Staff Recommendations:

Resolution approving a Second Amendment to the Agreement with United Site Services, Inc. of Modesto, CA for Portable Toilet Rental Services for a revised total amount not to exceed $583,250 over the term of the Agreement for United Site Services and Sun Valley Portable Restrooms, Inc., Turlock, CA; and authorizing the City Manager, or his designee, to execute the Amendment.
#20..
- 526 -
City Council, January 10, 2023
Second Amendment for Portable Toilet Rental Services

Page 3 of 3 ends

Approved by:

Laurie A. Smith, Director
Parks, Recreation & Neighborhoods Department
Joseph P. Lopez, City Manager
Attachments:

1. Resolution

2. Agreement

3. First Amendment

4. Second Amendment
#20..
- 527 -
01/10/2023/PRND/SMITH 1 2023-?

MODESTO CITY COUNCIL
RESOLUTION NO. 2023-

RESOLUTION APPROVING A SECOND AMENDMENT TO THE
AGREEMENT WITH UNITED SITE SERVICES, INC. OF MODESTO, CA FOR

PORTABLE TOILET RENTAL SERVICES FOR A REVISED AMOUNT NOT TO EXCEED $583,250 OVER THE TERM OF THE AGREEMENT FOR UNITED SITE SERVICES AND SUN VALLEY PORTABLE RESTROOMS, INC.,
TURLOCK, CA; AND AUTHORIZING THE CITY MANAGER, OR HIS

DESIGNEE, TO EXECUTE THE AMENDMENT
WHEREAS, on April 28, 2020, by Resolution 2020-194, Council approved the award of bid for portable toilet rental services to United Site Services, Inc. of Modesto, CA as the primary supplier for daily, weekly and monthly rentals and the secondary supplier for yearly rentals and to Sun Valley Portable Restrooms, Inc., Turlock, CA, for a two-year agreement with three (3) one-year extension options for an estimated combined annual cost of $54,888 and a total combined cost not to exceed $274,440 over five years for both; and
WHEREAS, on April 13, 2021, by Resolution 2021-135, Council approved the First Amendment to the Agreement with United Site Services, Inc. of Modesto, CA for a portable Americans with Disability Act (ADA) restroom trailer to increase the amount by $91,210 from $274,440 to a new total amount of $365,650 over the term of the agreement; and
WHEREAS, the Dryden Golf Clubhouse renovation is ongoing and staff estimates that construction will not begin until Fall 2023; and WHEREAS, the City continues to rent the portable ADA restroom and will require these services until the end of 2024 in anticipation that the Clubhouse will be rebuilt by that time; and
#20..
- 528 -
01/10/2023/PRND/SMITH 2 2023-?
WHEREAS, staff is requesting a one-time increase of $217,600 to the Portable Toilet Rental Services agreement for these additional services; and WHEREAS, the current agreement for Portable Toilet Rental services is $365,650 and the additional $217,600 will bring the agreement to a revised total of $583,250.

NOW, THEREFORE, BE IT RESOLVED by the Council of the City of Modesto that it hereby approves a Second Amendment to the Purchasing Agreement with United Site Services, Inc. of Modesto, CA for Portable Toilet Rental Services for a revised total amount not to exceed $583,250 over the term of the agreement for United Site Services and Sun Valley Portable Restrooms, Inc., Turlock, CA.

BE IT FURTHER RESOLVED that the Director of Finance, or her designee, is hereby authorized to adjust financial amounts between both providers without exceeding an estimated annual cost of $136,488.

BE IT FURTHER RESOLVED that the City Manager, or her designee, is hereby authorized to execute the Amendment in a form approved by the City Attorney. #20..
- 529 -
01/10/2023/PRND/SMITH 3 2023-?
The foregoing resolution was introduced at a regular meeting of the Council of the City of Modesto held on the 10th day of January, 2023, by Councilmember ?, who moved its adoption, which motion being duly seconded by Councilmember ?, was upon roll call carried and the resolution adopted by the following vote:

AYES: Councilmembers:

NOES: Councilmembers:

ABSENT: Councilmembers:

ATTEST:

DIANE NAYARES-PEREZ, City Clerk
(SEAL)
APPROVED AS TO FORM:

BY: ___________________________
JOSE M. SANCHEZ, City Attorney
#20..
- 530 -
#20..
- 531 -
#20..
- 532 -
#20..
- 533 -
#20..
- 534 -
#20..
- 535 -
#20..
- 536 -
#20..
- 537 -
#20..
- 538 -
#20..
- 539 -
#20..
- 540 -
#20..
- 541 -
#20..
- 542 -
#20..
- 543 -
#20..
- 544 -
#20..
- 545 -

AGREEMENT TRANSMITTAL SHEET
Subject of Agreement:

Vendor Name: Division:

Contact Person: Extension:

Attorney Reviewer Name:

The attached agreement is the final agreement approved by Council on and pulled from Unity for routing via DocuSign.

PINS Approval Business License
Council Agenda Report 700 Form (for Consultants)
Signed or Unsigned Resolution W-9
Council Meeting Minutes (Only if unsigned
Resolution is provided)
DocuSign Envelope ID: 895C7C9E-022C-478D-B647-B081D61D8190 X
Valerie Fabela
04/13/2021
United Site Services, Inc. Finance
X
X
Frank S.

First Amendment for Portable Toilet Rental Services
X
75369
X
of California, Inc.

Updated to show as United Site Services of California, Inc.

DocuSign Envelope ID: 70DB75EF-DD7C-450E-B9D3-98C0C0CC035F #20..
- 546 -
1 AMENDMENT TO AGREEMENT
This Amendment (“Amendment”) is made with reference to the “Agreement” entered into between the CITY OF MODESTO, a municipal corporation of the State of California (hereinafter the “City”) and UNITED SITE SERVICES (hereinafter the “Contractor”) entered into by the parties on the 28th day of April, 2020 (hereinafter referred to as “Original Agreement”). The City and Contractor shall be collectively referred to as the “Parties.” This Amendment to the Original Agreement is made with regard to the following recitals:

WHEREAS, the Modesto City Council adopted Resolution No. 2020-194 authorizing the award of proposal and contract for the furnishing of portable toilet rental services as the primary supplier for daily, weekly, and monthly rentals; and WHEREAS, the Original Agreement, Section 1, ‘SCOPE OF WORK’ provides, in part, that Contractor agrees to the PORTABLE TOLIETS RENTAL SERVICES defined for the contracted rates, not to exceed $54,888 annually; and WHEREAS, the parties now desire to evidence the change to the terms of the Original Agreement with this Amendment by modifying Section 1, “SCOPE OF WORK”.

NOW, THEREFORE, in consideration of the mutual promises, covenants, and stipulations contained herein and the mutual promises, covenants, and stipulations contained in the Original Agreement, the parties agree as follows:

1. The parties agree that each of the recitals set out above are factually true and correct.

2. Section 1f, under “SCOPE OF WORK” shall be deleted in its entirety and the parties agree to and hereby do substitute the following in its place:

DocuSign Envelope ID: 895C7C9E-022C-478D-B647-B081D61D8190 of California, Inc.

DocuSign Envelope ID: 70DB75EF-DD7C-450E-B9D3-98C0C0CC035F #20..
- 547 -
2 “CONTRACTOR shall furnish the PORTABLE TOILET
RENTAL SERVICES defined for the following contracted rates, not to exceed $54,888 annually with a one-time addition of $91,210 for the Dryden Clubhouse temporary Americas with Disabilities Act (ADA) Restroom Trailer.

Equipment Description Daily Rental
Rate per
Unit
Weekly
Rental Rate
per Unit
Monthly
Rental Rate
per unit
Yearly
Rental
Rate per
Unit
Standard Portable Toilet $55.79 $60.79 $79.79 $957.48
Standard Portable Toilet with Urinal $55.79 $60.79 $79.79 $957.48 ADA Accessible Portable Toilet $65.79 $126.97 $176.97 $2,123.64 ADA Hand Wash Station $85.79 $153.94 $203.94 $2,447.28
Standard Portable Hand Wash Station $55.79 $60.79 $79.89 $958.68 Delivery & Set Up $53.94 $53.94 $53.94 $53.94
Environmental Fees $0 $0 $0 $0
Additional Services
Advanced Notice (24 hour placement) $53.94 $53.94 $53.94 $53.84 Short Notice (2-hour advance notice) $134.84 $134.84 $134.84 $134.84 Additional Pump Outs (in addition to standard
one (1) day per week)
$20.00 $20.00 $85.00 $1020.00
Standard Restroom w/Sink Inside $95.79 $122.37 $152.37 $1,828.35 Standard Portable Toilet Unit secured to trailer $95.79 $122.37 $152.37 $1,828.35 Weekends/Holiday Rates $215.75 $215.75 $215.75 $215.75
Emergency Service Pump Out $50.00 $50.00 $50.00 $50.00
Replacement Value of Standard Portable Toilet $700.00 $700.00 $700.00 $700.00 Replacement Value of Standard Portable Toilet
w/Urinal
$700.00 $700.00 $700.00 $700.00
Replacement Value of ADA Accessible Portable
Toilet
$995.00 $995.00 $995.00 995.00
12 ft ADA Restroom Trailer - - $6,200 -
Multiple Unit Order Discount $0% 0% 0% 0%
The parties to this contract further understand that except as modified herein, the provisions of the Original Agreement, and all exhibits attached thereto, are expressly reaffirmed and remain in full force and effect.
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// DocuSign Envelope ID: 895C7C9E-022C-478D-B647-B081D61D8190 DocuSign Envelope ID: 70DB75EF-DD7C-450E-B9D3-98C0C0CC035F #20..
- 548 -
3 IN WITNESS WHEREOF, the CITY OF MODESTO, a municipal corporation. has authorized the execution of this Amendment to Agreement for furnishing of portable toilet rental services, in duplicate, by its City Manager and attestation by its City Clerk, under authority of Resolution No. ______on the _____ day of _____________, 2021, and Contractor has caused this Amendment be executed in duplicate.

DocuSign Envelope ID: 895C7C9E-022C-478D-B647-B081D61D8190 2021-135 13 April
DocuSign Envelope ID: 70DB75EF-DD7C-450E-B9D3-98C0C0CC035F #20..
- 549 -

CITY OF MODESTO,
a municipal corporation
BY: ____________________________
JOSEPH P. LOPEZ, City Manager
ATTEST:
(Seal)
BY: ____________________________
STEPHANIE LOPEZ, City Clerk

CONSULTANT,
________________________________
BY: ____________________________
By _____________________________
Name Title
BY: ____________________________
By _____________________________
Name Title
APPROVED AS TO FORM:

BY: ____________________________
JOSE M. SANCHEZ, City Attorney
APPROVED AS TO FORM:

BY: ____________________________
JILES SMITH II, Risk Manager
Consultant’s Federal ID # ___________
* Corporations - signature of two (2) officers
required or one (1) officer plus corporate seal.

Partnership - signature of a partner required Sole
Proprietorship - signature of proprietor
required
DocuSign Envelope ID: 895C7C9E-022C-478D-B647-B081D61D8190 Jeff Dunlop, Vice President
United Site Services of California, Inc.
200968969
4/27/2021
DocuSign Envelope ID: 70DB75EF-DD7C-450E-B9D3-98C0C0CC035F Sean McDowell Director of Contracts
#20..
- 550 -
DocuSign Envelope ID: 895C7C9E-022C-478D-B647-B081D61D8190 DocuSign Envelope ID: 70DB75EF-DD7C-450E-B9D3-98C0C0CC035F #20..
- 551 -

CITY OF MODESTO

COUNCIL AGENDA REPORT
DATE OF MEETING:

April 13, 2021
Date: March 30, 2021
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: DeAnna Christensen, Director of Finance
Laurie Smith, Director of Parks, Recreation and Neighborhood SUBJECT: First Amendment for Portable Toilet Rental Services CONTACT: Cynthia Kline, Purchasing Manager, [email protected], (209) 577-5412 DESCRIPTION:

Consider approving a First Amendment to the Agreement with United Site Services, Inc. of Modesto, CA for a portable Americans with Disability Act (ADA) restroom trailer to increase the amount by $91,210 from $274,440 to a new total amount of $365,360 over the term of the agreement for United Site Services and Sun Valley Portable Restrooms, Inc., Turlock, CA. (Funding Source: Insurance Recovery)
STRATEGIC PLAN ELEMENT:

This action supports the 2020-2025 City of Modesto Strategic Plan: Goal H. Achieve Financial Sustainability.

BACKGROUND:

The City of Modesto requires the use of portable toilet rental services on a regular basis across multiple City departments. The uses range from temporary services for construction projects, special events such as Concerts in the Park and Earth Day, to regular monthly service at the Mary Grogan Soccer Complex. The needs for these services include, but are not limited to compliance with health and safety codes for personnel, providing ADA accessible units on sites where ADA accessibility does not exist, and increasing the count of available units to meet the demand of high use facilities and locations.

On April 28, 2020, by Resolution 2020-194, Council approved the award of bid for portable toilet rental services to United Site Services, Inc. of Modesto, CA as the primary supplier for daily, weekly and monthly rentals and the secondary supplier for yearly rentals and to Sun Valley Portable Restrooms, Inc., Turlock, CA, for a two-year agreement with three one-year extension options for an estimated combined annual cost of $54,888 and a total combined cost not to exceed $274,440 over five years for both.

DocuSign Envelope ID: 895C7C9E-022C-478D-B647-B081D61D8190 DocuSign Envelope ID: 70DB75EF-DD7C-450E-B9D3-98C0C0CC035F #20..
- 552 -
City Council, April 13, 2021
First Amendment for Portable Toilet Rental Services

Page 2 of 3 ends

DISCUSSION:

On August 4, 2020, the Dryden Golf Park Clubhouse was heavily damaged by a fire. The Modesto Fire Department responded to the fire, located at 920 Sunset Avenue, and was able to extinguish the blaze before the building was a complete loss.

The City contacted Alliant, the property insurance company that insured the structure on behalf of the City, to establish a claim and to identify the next steps. The insurance company dispatched Belfor Property Restoration of Modesto, CA (Belfor) to secure the property.

The property requires extensive reconstruction estimated at $1.2 million. A Capital Improvement Project was recently approved by City Council under Resolution #2020-401 on September 22, 2020 to reconstruct the building. The project is still in its early phases and requires the building design to be bid as well as the construction contract. The design RFP is almost complete, we’re negotiating with the architect now. At this time, it is estimated that construction will not begin until September 2021.

The portable restroom unit was brought onsite by Belfor immediately after the fire, in order to reopen the golf course for play. It has been in use since August of 2020, and contains a men’s, women’s and disabled restroom unit. In addition, United is the City’s primary contractor and service could continue uninterrupted.

FISCAL IMPACT:

This first amendment of the increase of $91,210 for this agreement will be funded 100% through the property insurance company, Alliant.

COMMITTEE RECOMMENDATION:

This item was considered by the Finance Committee on March 29, 2021 and recommended forwarding to Council for approval.

RECOMMENDED COUNCIL ACTION:

Staff Recommendation:

Resolution approving a First Amendment to the Agreement with United Site Services, Inc. of Modesto, CA for a portable Americans with Disability Act (ADA) restroom trailer to increase the amount by $91,210 from $274,440 to a new total amount of $365,360 over the term of the agreement for United Site Services and Sun Valley Portable Restrooms, Inc., Turlock, CA. and authorizing the City Manager, or his designee, to execute the amendment.

Approved by:

DeAnna Christensen, Director of Finance
DocuSign Envelope ID: 895C7C9E-022C-478D-B647-B081D61D8190 DocuSign Envelope ID: 70DB75EF-DD7C-450E-B9D3-98C0C0CC035F #20..
- 553 -
City Council, April 13, 2021
First Amendment for Portable Toilet Rental Services

Page 3 of 3 ends

Laurie Smith, Director of Parks, Recreation and
Neighborhood
Joseph P. Lopez, City Manager
Attachments:

1. Resolution

2. Amendment

3. Original Agreement
DocuSign Envelope ID: 895C7C9E-022C-478D-B647-B081D61D8190 DocuSign Envelope ID: 70DB75EF-DD7C-450E-B9D3-98C0C0CC035F #20..
- 554 -
DocuSign Envelope ID: 895C7C9E-022C-478D-B647-B081D61D8190 DocuSign Envelope ID: 70DB75EF-DD7C-450E-B9D3-98C0C0CC035F #20..
- 555 -
DocuSign Envelope ID: 895C7C9E-022C-478D-B647-B081D61D8190 DocuSign Envelope ID: 70DB75EF-DD7C-450E-B9D3-98C0C0CC035F #20..
- 556 -
DocuSign Envelope ID: 895C7C9E-022C-478D-B647-B081D61D8190 DocuSign Envelope ID: 70DB75EF-DD7C-450E-B9D3-98C0C0CC035F #20..
- 557 -
DocuSign Envelope ID: 895C7C9E-022C-478D-B647-B081D61D8190 DocuSign Envelope ID: 70DB75EF-DD7C-450E-B9D3-98C0C0CC035F #20..
- 558 -
DocuSign Envelope ID: 895C7C9E-022C-478D-B647-B081D61D8190 DocuSign Envelope ID: 70DB75EF-DD7C-450E-B9D3-98C0C0CC035F #20..
- 559 -
1 SECOND AMENDMENT TO AGREEMENT
THIS SECOND AMENDMENT to the AGREEMENT (“SECOND AMENDMENT”), made and entered into in the City of Modesto, County of Stanislaus, State of California, this ______ day of _____________, 2023, by and between the CITY OF MODESTO, a municipal corporation of the State of California (“CITY”) and UNITED SITE SERVICES OF CALIFORNIA, INC., Modesto, CA, hereinafter collectively referred to as “CONTRACTOR”.

This SECOND AMENDMENT to AGREEMENT is made with reference to the following recitals:

A. An Agreement (“AGREEMENT”) was entered into by and between CITY and CONTRACTOR on the 28th day of April 2020 for the furnishing of portable toilet rental services as the primary supplier for daily, weekly, and monthly rentals.

B. A First Amendment to Agreement was entered into by and between CITY and CONTRACTOR on the 13th day of April 2021 which increased compensation paid for the additional scope of services identified in the amendment.

C. The CITY wishes to increase the compensation paid for the agreement by $217,600 from $365,650 to a new total of $583,250 for the Dryden Clubhouse temporary Americans with Disabilities Act (ADA) Restroom Trailer.

D. CITY and CONTRACTOR desire to amend the provisions of AGREEMENT to increase compensation paid for services identified in the AGREEMENT.

E. All other provisions of the AGREEMENT shall remain in effect.

NOW, THEREFORE, the parties hereto mutually agree to the following:

1. Paragraph (f), Section 1 “SCOPE OF WORK” shall be deleted in its entirety and amended to read as follows:
#20..
- 560 -
2 “1. SCOPE OF WORK
f. CONTRACTOR shall furnish the PORTABLE TOILET RENTAL SERVICES defined for the following contracted rates, not to exceed $54,888 annually with a onetime addition of $217,600 for the Dryden Clubhouse temporary ADA Restroom Trailer.

Equipment Description Daily
Rental Rate
per Unit
Weekly
Rental Rate
per Unit
Monthly
Rental Rate
per Unit
Yearly
Rental Rate
per Unit
Standard Portable Toilet $55.79 $60.79 $79.79 $957.48
Standard Portable Toilet with Urinal $55.79 $60.79 $79.79 $957.48 ADA Accessible Portable Toilet $65.79 $126.97 $176.97 $2,123.64 ADA Hand Wash Station $85.79 $153.94 $203.94 $2,447.28
Standard Portable Hand Wash Station $55.79 $60.79 $79.89 $958.68 Delivery & Set Up $53.94 $53.94 $53.94 $53.94
Environmental Fees - - - -
Additional Services
Advanced Notice (24-hour placement) $53.94 $53.94 $53.94 $53.84 Short Notice (2-hour advance notice) $134.84 $134.84 $134.84 $134.84 Additional Pump Outs (in addition to standard
one (1) day per week)
$20.00 $20.00 $85.00 $1,020.00
Standard Restroom w/Sink Inside $95.79 $122.37 $152.37 $1,828.35 Standard Portable Toilet Unit secured to trailer $95.79 $122.37 $152.37 $1,828.35 Weekends/Holiday Rates $215.75 $215.75 $215.75 $215.75
Emergency Service Pump Out $50.00 $50.00 $50.00 $50.00
Replacement Value of Standard Portable Toilet $700.00 $700.00 $700.00 $700.00 Replacement Value of Standard Portable Toilet
w/Urinal
$700.00 $700.00 $700.00 $700.00
Replacement Value of ADA Accessible Portable
Toilet
$995.00 $995.00 $995.00 $995.00
12 ft ADA Restroom Trailer - - $6,200 -
Multiple Unit Order Discount - - - -

2. Except as modified and amended by this SECOND AMENDMENT to AGREEMENT, all other provisions of the AGREEMENT shall remain unchanged and in full force and effect.”
#20..
- 561 -
3 IN WITNESS WHEREOF, the CITY, a Municipal Corporation, has authorized the execution of this SECOND AMENDMENT to AGREEMENT in duplicate by its City Manager and attestation by its City Clerk (under authority of Resolution No. , adopted by the Council of the City of Modesto) on the _____ day of ___________, 2023, and CONTRACTOR, has caused this Second Amendment to Agreement to be duly executed. #20..
- 562 -

CITY OF MODESTO

COUNCIL AGENDA REPORT
DATE OF MEETING:

January 10, 2023
Date: December 13, 2022
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: Laurie A. Smith, Director of Parks, Recreation and Neighborhoods SUBJECT: American Legion Hall Fire Remediation Additional Emergency Work CONTACT: Nathan Houx, Parks Planning and Development Manager, [email protected], 209-571-5526
DESCRIPTION:

Consider authorizing additional payment not to exceed $151,225 to Belfor Property Restoration, Modesto, CA for Emergency Work related to the American Legion Hall Fire Remediation. (Funding Source: TRRP JPA Insurance Proceeds) STRATEGIC PLAN ELEMENT:

This item is consistent with the following 2020-2025 Strategic Plan Area of Focus: Quality of Life and Governance and Service Delivery.

BACKGROUND:

On July 21, 2022, the American Legion Hall was heavily damaged by a fire and the damage is significant. The City contacted Alliant, the property insurance company that insured the structure on behalf of the City, to establish a claim and to identify the next steps. The insurance company dispatched Belfor Property Restoration of Modesto, CA (Belfor) to complete emergency work at the site.

On July 22, 2022, Belfor began providing emergency services and mitigation to secure the property against additional damages, performed environmental testing, removed debris resulting from the fire and removed the deck and fenced the structure off to protect the public from unnecessary hazards. In addition, the City sent Allied Security to secure the property and ensure the safety of the public until Belfor was able to place fencing around the site and remove the deck. Finally, there were two large trees adjacent to the American Legion Hall that were significantly damaged and needed significant trimming or removal.

On September 27, 2022, by Resolution No. 2022-398, Council authorized payments not to exceed $160,000 to Belfor Property Restoration, Modesto, CA and other vendors for the abovementioned emergency related work. The above-mentioned work is complete and the total cost #21..
- 563 -
City Council, January 10, 2023
American Legion Hall Fire Remediation Additional Emergency Work

Page 2 of 3 ends

of that work is $147,631. At the time, the full cost of the damage to American Legion Hall had not been determined, nor had it been determined if the building could be rebuilt at this location.

DISCUSSION:

Over recent months, the insurance company has dispositioned the building as a total loss, and since it is in the floodway of the Tuolumne River, it cannot be reconstructed at this location.

Therefore, the building needs to be demolished. Belfor’s cost for demolition of the building is estimated at $131,500. This cost was reviewed and approved by the City’s insurance company as an eligible insurance-related expense.

Due to the fire damage, the building has been subject to weekly break-ins over the past few months and it is unsafe to be occupied in its current condition. Therefore, staff requested and received emergency approval from the City Manager to demolish and remove the building to protect the public from unnecessary hazards. Staff anticipates the building will be demolished by the time this is considered by Council.

Modesto Municipal Code Section 8-3.203 generally requires all purchases, which meet or exceed $50,000 for material, equipment or contractual services to be formally bid.

However, exceptions to the formal bidding process are granted in MMC 8-3.204(c) “Where the Purchasing Manager, in his or her discretion, determines that calling for bids on a competitive basis as set forth in Section 8-3.203 is undesirable due to exigent circumstances.” This project meets these requirements, as the contractor has been selected directly by the insurance company and it makes the best business sense to utilize their services, given the active insurance claim and the need for this work to be completed as soon as possible to minimize the risk to the public.

FISCAL IMPACT:

The City of Modesto’s property insurance policy establishes a maximum deductible (outof-pocket cost to the City) of $100,000. Additionally, the City’s insurance adjuster has confirmed that all of the above costs are covered expenses. The insurance company will provide payment to the City to cover the emergency expenses that exceed the $100,000 deductible. Negotiations are ongoing with the insurance company to determine the Actual Cash Value of the American Legion Hall. Based on the partial proof of loss from the insurance company, the initial partial payment is anticipated to be $1,692,931.

The maximum deductible of ($100,000) is being funded by a tranfer of funds from Fund 6700, the Joint Powers Authority (JPA) – Tuolumne River Regional Park (TRRP) operating budget to a Capital Improvement Project (CIP) 101425, in Fund 6710, that has been created to house this project’s funding and expenses. The project currently has $150,000 in revenue and a budget adjustment of $1,642,931, which was approved by the Finance Committee as part of the Budget division’s monthly budget adjustment on December 14, 2022.

In order to ensure sufficient coverage of all necessary emergency expenses, staff also requests an additional contingency of $19,725 (15%). The total estimated cost of the additional emergency work, including the additional 15%, is estimated at $151,225.

Therefore, the total estimated cost of the emergency work at American Legion Hall is expected not to exceed $298,856.
#21..
- 564 -
City Council, January 10, 2023
American Legion Hall Fire Remediation Additional Emergency Work

Page 3 of 3 ends

Anticipated Revenues for the Emergency Work in Project 101425:

TRRP JPA Funding $ 100,000
Insurance Proceeds (estimated) $1,692,931
Total Anticipated Revenue $1,792,931
Estimated Expenses for the Emergency Work in Project 101425:

Belfor Property Restoration (initial work, actual) $ 131,890 Allied Security (security, actual) $ 3,791
West Coast Arborists (tree work, actual) $ 11,950
Belfor Property Restoration (demolition estimate) $ 131,500 15% additional expense allowance (as needed) $ 19,725
Total Estimated Expenses $ 298,856
The costs to the City/TRRP JPA will not exceed $100,000. No General Fund money is being requested for this emergency work.

COMMITTEE RECOMMENDATION:

This item was reviewed by the Safety and Communities Committee on December 12, 2022, and they recommended the item be forwarded to Council for approval.

RECOMMENDED COUNCIL ACTION:

Staff Recommendations:

Resolution authorizing additional payment not to exceed $151,225 to Belfor Property Restoration, Modesto, CA for Emergency Work related to the American Legion Hall Fire Remediation and authorizing the Purchasing Manager, or her designee, to issue the payments.

Approved by:

Laurie A. Smith, Director of Parks, Recreation and
Neighborhoods Manager
Joseph P. Lopez, City Manager
Attachments:

1. Resolution
#21..
- 565 -
01/10/2023/PRN/NHoux/Item XX 1 2023-XXX

MODESTO CITY COUNCIL
RESOLUTION NO. 2023-

RESOLUTION AUTHORIZING ADDITIONAL PAYMENT NOT TO EXCEED $151,225 TO BELFOR PROPERTY RESTORATION, MODESTO, CA FOR

EMERGENCY WORK RELATED TO THE AMERICAN LEGION HALL FIRE

REMEDIATION AND AUTHORIZING THE PURCHASING MANAGER, OR

HER DESIGNEE, TO ISSUE THE PAYMENTS
WHEREAS, on July 21, 2022, the American Legion Hall was heavily damaged by a fire; and
WHEREAS, the City contacted Alliant, the property insurance company that insured the structure on behalf of the City, to establish a claim and to identify the next steps; and WHEREAS, the insurance company dispatched Belfor Property Restoration of Modesto, CA (Belfor) to complete emergency work at the site; and WHEREAS, on July 22, 2022, Belfor provided emergency services and mitigation to secure the property against additional damages, performed environmental testing, removed debris resulting from the fire, removed the deck and fenced the structure off to protect the public from unnecessary hazards; and
WHEREAS, the City sent Allied Security to secure the property and ensure the safety of the public until Belfor was able to place fencing around the site and remove the deck; and WHEREAS, there were two large trees adjacent to the American Legion Hall that were significantly damaged and needed heavy trimming or removal; and WHEREAS, on September 27, 2022, by Resolution No. 2022-398, Council authorized payments not to exceed $160,000 to Belfor Property Restoration, Modesto, CA and other vendors for the above-mentioned emergency related work; and WHEREAS, the above-mentioned work is complete and the total cost of that work is $147,631; and
#21..
- 566 -
01/10/2023/PRN/NHoux/Item XX 2 2023-XX
WHEREAS, at the time, the full cost of the damage to American Legion Hall had not been determined, nor had it been determined if the building could be rebuilt at this location; and WHEREAS, over recent months, the insurance company has dispositioned the building as a total loss, and since it is in the floodway of the Tuolumne River, it cannot feasibly be reconstructed at this location; and
WHEREAS, the building will need to be demolished; and
WHEREAS, Belfor’s cost for demolition of the building is estimated at $131,500; and WHEREAS, this cost has been reviewed and approved by the City’s insurance company as an eligible insurance-related expense; and
WHEREAS, due to the fire damage, the building has been subject to weekly break-ins over the past few months and it is unsafe to be occupied in its current condition; and WHEREAS, staff requested and received emergency approval from the City Manager to demolish and remove the building to protect the public from unnecessary hazards; and WHEREAS, Modesto Municipal Code Section 8-3.203 generally requires all purchases, which meet or exceed $50,000 for material, equipment or contractual services to be formally bid but exceptions to the formal bidding process are granted in MMC 8-3.204(c) “Where the Purchasing Manager, in his or her discretion, determines that calling for bids on a competitive basis as set forth in Section 8-3.203 is undesirable due to exigent circumstances”; and WHEREAS, this project meets these requirements, as the contractor has been selected directly by the insurance company and it makes the best business sense to utilize their services, given the active insurance claim and the need for this work to be completed as soon as possible to minimize the risk to the public.
#21..
- 567 -
01/10/2023/PRN/NHoux/Item XX 3 2023-XX
NOW, THEREFORE BE IT RESOLVED, by the Council of the City of Modesto that it hereby approves additional payment not to exceed $151,225 to Belfor Property Restoration, Modesto, CA for Emergency Work related to the American Legion Hall Fire Remediation.

BE IT FURTHER RESOLVED that the Purchasing Manager, or her designee, is authorized to issue the payments.

The foregoing resolution was introduced at a regular meeting of the Council of the City of Modesto held on the day of , 2023, by Councilmember , who moved its adoption, which motion being duly seconded by Councilmember , was upon roll call carried and the resolution adopted by the following vote:

AYES: Councilmembers:

NOES: Councilmembers:

ABSENT: Councilmembers:

ATTEST: _____________________________

DIANE NAYARES-PEREZ, CMC,
City Clerk
(SEAL)
APPROVED AS TO FORM:

BY: ________________________________
JOSE M. SANCHEZ, City Attorney
#21..
- 568 -

CITY OF MODESTO

COUNCIL AGENDA REPORT
DATE OF MEETING:

January 10, 2023
Date: December 13, 2022
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: Laurie A. Smith, Director of Parks, Recreation and Neighborhoods Department SUBJECT: Tuolumne River Regional Park Riverwalk Trail - Gateway to Neece Design Award CONTACT: Nathan Houx, Parks Planning and Development Manager, [email protected], 209-571-5526
DESCRIPTION:

Consider approving an Agreement with Mark Thomas & Company, Inc. to prepare construction documentation for the Tuolumne River Regional Park (TRRP) Riverwalk Trail - Gateway to Neece Project for a total amount not to exceed $289,583. (Funding Source: Parks Capital Facility Fee Fund, Recreational Trails and Greenways Grant Program – Proposition 68) STRATEGIC PLAN ELEMENT:

This item is consistent with the following 2020-2025 Strategic Plan Areas of Focus: Quality of Life and Governance and Service Delivery.

BACKGROUND:

The Tuolumne River Regional Park consists of 500-acres of riparian land within the City of Modesto and Stanislaus County. The park runs approximately 7-miles along the river’s edge stretching from the Mitchell Road bridge on the eastern boundary to just west of the Carpenter Road bridge on the western boundary.

In 1999, the Tuolumne River Regional Park Commission updated the original land use plan, which included preparation of a TRRP Master Plan and Master Environmental Impact Report.

The Master Plan and Master Environmental Impact Report (MEIR) were developed over a twoyear period and were certified by the TRRP Commission and adopted by Ceres City Council, Modesto City Council and County Board of Supervisors in 2001.

Construction of the Gateway Parcel development (the area on the north side of the river from the confluence of the Tuolumne River and Dry Creek to Highway 99) commenced in 2006.

Riparian habitat restoration activities have included construction of backwater channels, riparian terraces, wildlife areas, amphimeadow and river structure dam removal. Recreational #22..
- 569 -
City Council, January 10, 2023
Tuolumne River Regional Park Riverwalk Gateway to Neece Award

Page 2 of 3 ends

construction activities have included an outdoor classroom, river observation deck, multiple Class 1 trails and a pedestrian bridge installation.

Within the Tuolumne River Regional Park, the City is actively planning for the Neece Drive NonMotorized Boat Launch Facility (TRRP Golf Course Area), Bellenita Soccer Field Complex (TRRP Carpenter Road Area), Gateway River Overlook (TRRP Gateway Area), Legion Park River Pavilion (TRRP Legion Park Area) and Legion Park Learning Theater (TRRP Legion Park Area) projects. These projects will likely begin construction in 2023 and intermittently continue until 2025.

The TRRP Riverwalk Trail – Gateway to Neece Drive Project will provide a new paved trail connection between the existing trail just below Highway 99 at the Gateway Parcel to the corner of Neece Drive and Rouse Avenue. The project will extend the active recreational use of the river frontage to the future Neece Drive Boat Launch and is compatible for commuting uses between City employment centers and neighborhood destinations.

DISCUSSION:

In accordance with Administrative Directive 3.1, “Selection Procedures for Professional Consultants Who Provide Architectural & Engineering for Capital Projects”, staff initiated a Request for Qualifications and Proposals (RFQ/P) to perform Professional Design Consulting Services.

On October 6, 2021, the City’s Parks Planning and Development Division issued a Request for Proposals (RFP) # PRN-21-101164 for professional design consulting services for the Tuolumne River Regional Park (TRRP) Three Trails Connection Project. On November 10, 2021, staff received two (2) consultant proposals. A consultant selection committee was formed and met to review the proposals received. The committee decided that the project be split into three different sections (Section One – TRRP Riverwalk Trail - Gateway to Neece, Section Two – TRRP Riverwalk Trail - Gateway to Legion, and Section Three – Dry Creek Regional Park to TRRP) and determined that the prospective professional design consultant, Mark Thomas & Company, Inc., is well qualified to complete Section One – TRRP Riverwalk Trail - Gateway to Neece, of the project.

Based on the results of the RFP, staff recommends the Council approve an agreement with Mark Thomas & Company, Inc, in the amount of $263,257 to complete the TRRP Riverwalk Trail - Gateway to Neece Project.

In addition, staff recommends Council approve a 10% additional services budget in the amount of $26,326 to allow for additional services that may be required due to unforeseen conditions, delays or expenses for an agreement total not to exceed $298,583. This additional services budget does not commit the city to spend the additional funding, but allows the Department Director to approve change orders up to the additional services limit, without further council action.

In accordance with Modesto Municipal Code Sec. 8-3.204(a), Exceptions to Formal Bidding Requirements, the agreement is for professional services and, therefore, exempt from the bidding requirement. The approval of the agreement for construction documentation services for the Tuolumne River Regional Park Riverwalk Trail - Gateway #22..
- 570 -
City Council, January 10, 2023
Tuolumne River Regional Park Riverwalk Gateway to Neece Award

Page 3 of 3 ends

to Neece Project to Mark Thomas & Company, Inc. of Fresno, CA conforms to Modesto Municipal Code 8-3.204, subsection (a).

FISCAL IMPACT:

On June 9, 2020, per Council Resolution 2020-253, City Council accepted the grant award for the Recreational Trails and Greenways Grant Program in the amount of $2,968,885. The remaining amount of $150,000, will be funded by Parks Capital Facility Fee Fund. Funding is housed in Project 101164 – TRRP Riverwalk Gateway to Neece Drive.

Revenue:

Parks Capital Facility Fee Fund $ 150,000
Recreational Trails and Greenways Grant Program – Proposition 68 $2,968,885 Total Revenue $3,118,885
Anticipated Expenses:

Engineering/Design/Administration $ 400,000
Construction $2,265,741
Contingency $ 226,572
Construction Administration $ 226,572
Total Anticipated Expenses $3,118,885
COMMITTEE RECOMMENDATION:

This item was reviewed by the Safety and Communities Committee on December 12, 2022, and they recommended this item be forwarded to Council for approval.

RECOMMENDED COUNCIL ACTION:

Staff Recommendations:

Resolution approving an Agreement with Mark Thomas & Company, Inc. to prepare construction documentation for the Tuolumne River Regional Park (TRRP) Riverwalk Trail - Gateway to Neece Project for an amount of $263,257, plus $26,326 for additional services, if needed, for an Agreement total not to exceed $289,583 and authorizing the City Manager, or his designee, to execute the Agreement.

Approved by:

Laurie A. Smith, Director of Parks, Recreation and
Neighborhoods Department
Joseph P. Lopez, City Manager
Attachments:

1. Resolution

2. Agreement – Mark Thomas & Company, Inc.

3. Financial Interest Disclosure Form – Mark Thomas & Company, Inc. #22..
- 571 -
01/10/2023/PRN/NHoux/Item XX 1 2023-XXX

MODESTO CITY COUNCIL
RESOLUTION NO. 2023-

RESOLUTION APPROVING AN AGREEMENT WITH MARK THOMAS &
COMPANY, INC. TO PREPARE CONSTRUCTION DOCUMENTATION FOR THE

TUOLUMNE RIVER REGIONAL PARK (TRRP) RIVERWALK TRAIL - GATEWAY TO NEECE PROJECT FOR AN AMOUNT OF $263,257, PLUS $26,326 FOR

ADDITIONAL SERVICES, IF NEEDED, FOR AN AGREEMENT TOTAL NOT TO EXCEED $289,583 AND AUTHORIZING THE CITY MANAGER, OR HIS DESIGNEE,

TO EXECUTE THE AGREEMENT
WHEREAS, the Tuolumne River Regional Park consists of 500-acres of riparian land within the City of Modesto and Stanislaus County; and
WHEREAS, in 1999, the Tuolumne River Regional Park Commission updated the original land use plan, which included preparation of a TRRP Master Plan and Master Environmental Impact Report; and
WHEREAS, the Master Plan and Master Environmental Impact Report (MEIR) were developed over a two-year period and were certified by the TRRP Commission and adopted by Ceres City Council, Modesto City Council and County Board of Supervisors in 2001; and WHEREAS, construction of the Gateway Parcel development (the area on the north side of the river from the confluence of the Tuolumne River and Dry Creek to Highway 99) commenced in 2006; and
WHEREAS, riparian habitat restoration activities have included construction of backwater channels, riparian terraces, wildlife areas, amphimeadow and river structure dam removal; and
WHEREAS, within the Tuolumne River Regional Park the City is actively planning for the Neece Drive Non-Motorized Boat Launch Facility (TRRP Golf Course Area), Bellenita Soccer Field Complex (TRRP Carpenter Road Area), Gateway River Overlook (TRRP Gateway #22..
- 572 -
01/10/2023/PRN/NHoux/Item XX 2 2023-XX
Area), Legion Park River Pavilion (TRRP Legion Park Area) and Legion Park Learning Theater (TRRP Legion Park Area) projects; and
WHEREAS, the TRRP Riverwalk Trail – Gateway to Neece Drive Project will provide a new paved trail connection between the existing trail just below Highway 99 at the Gateway Parcel to the corner of Neece Drive and Rouse Avenue; and WHEREAS, the project will extend the active recreational use of the river frontage to the future Neece Drive Boat Launch and is compatible for commuting uses between City employment centers and neighborhood destinations; and
WHEREAS, in accordance with Administrative Directive 3.1, “Selection Procedures for Professional Consultants Who Provide Architectural & Engineering for Capital Projects”, staff initiated a Request for Qualifications and Proposals (RFQ/P) to perform Professional Design Consulting Services; and
WHEREAS, on October 6, 2021, the City’s Parks Planning and Development Division issued a Request for Proposals (RFP) # PRN-21-101164 for professional design consulting services for the Tuolumne River Regional Park (TRRP) Three Trails Connection Project; and WHEREAS, on November 10, 2021, staff received two (2) consultant proposals and a consultant selection committee was formed and met to review the proposals received; and WHEREAS, the committee decided that the project be split into three different sections (Section One – TRRP Riverwalk Trail - Gateway to Neece, Section Two – TRRP Riverwalk Trail - Gateway to Legion, and Section Three – Dry Creek Regional Park to TRRP) and determined that the prospective professional design consultant, Mark Thomas & Company, Inc., is well qualified to complete Section One – TRRP Riverwalk Trail - Gateway to Neece, of the project; and
#22..
- 573 -
01/10/2023/PRN/NHoux/Item XX 3 2023-XX
WHEREAS, in accordance with Modesto Municipal Code Sec. 8-3.204(a), Exceptions to Formal Bidding Requirements, the agreement is for professional services and, therefore, exempt from the bidding requirement; and
WHEREAS, the approval of the agreement for construction documentation services for the Tuolumne River Regional Park Riverwalk Trail - Gateway to Neece Project to Mark Thomas & Company, Inc. of Fresno, CA conforms to Modesto Municipal Code 8-3.204, subsection (a).

NOW, THEREFORE BE IT RESOLVED, by the Council of the City of Modesto that it hereby approves an Agreement with Mark Thomas & Company, Inc. to prepare construction documentation for the Tuolumne River Regional Park (TRRP) Riverwalk Trail - Gateway to Neece Project for an amount of $263,257, plus $26,326 for additional services, if needed, for an Agreement total not to exceed $289,583.

BE IT FURTHER RESOLVED that the City Manager, or his designee, is authorized to execute the agreement, in a form approved by the City Attorney.

AYES: Councilmembers:

NOES: Councilmembers:

ABSENT: Councilmembers:

ATTEST: _____________________________

DIANE NAYARES-PEREZ, CMC,
City Clerk
#22..
- 574 -
01/10/2023/PRN/NHoux/Item XX 4 2023-XX
(SEAL)
APPROVED AS TO FORM:

BY: ________________________________
JOSE M. SANCHEZ, City Attorney
#22..
- 575 -
-1-

MARK THOMAS AND COMPANY, INC AGREEMENT WITH THE CITY OF

MODESTO FOR THE TUOLUMNE RIVER REGIONAL PARK

RIVERWALK TRAIL - GATEWAY TO NEECE PROJECT
THIS AGREEMENT, made and entered into in the City of Modesto, State of California, this day of , 2023, (“Effective Date”) by and between the CITY OF MODESTO, a municipal corporation of the State of California, hereinafter referred to as "City", and MARK THOMAS & COMPANY, INC, a California corporation, hereinafter referred to as "Consultant".

This Agreement is made with regard to the following recitals:

A. The City has determined that construction documentation should be prepared; Profession Design Consulting Services are needed for the Tuolumne River Regional Park Riverwalk Trail - Gateway to Neece Project.

B. Consultant represents that it is qualified, willing and able to provide the services to prepare said document(s).

NOW, THEREFORE, in consideration of this agreement, and the mutual promises, covenants, and stipulations hereinafter contained, the parties agree as follows:

1. SCOPE OF SERVICES.

Consultant shall undertake and complete the preparation of the scope of work as set forth and described in the documents attached hereto and referred to as Exhibit "A" or "project". The Consultant shall perform the services as described in Exhibit "A" in a manner compatible with the standards of its profession, and shall produce a fully complete project that is acceptable to City.

2. TERM OF AGREEMENT.
#22..
- 576 -
-2-
This Agreement is effective as of the date first written above and will continue in effect until City's acceptance of and payment for all services authorized by City and performed by Consultant, unless terminated earlier in accordance with the provisions of the termination clause in this Agreement.

Consultant shall undertake and complete the preparation of the scope of work as set forth and described in the documents commonly referred to as “project” attached hereto as Exhibit "A" and made a part hereof. City hereby gives Consultant notice to proceed with the preparation of the project in the manner described in Exhibit "A", as of the Effective Date of this agreement. Consultant shall diligently proceed with the Professional Design Consulting Services of the Project until the completion of items shown in Exhibit “A”.

3. COMPENSATION.

Consultant agrees to accept a sum not to exceed TWO HUNDRED SIXTY THREE THOUSAND TWO HUNDRED FIFTY SEVEN AND 00/100 DOLLARS ($263,257 maximum compensation) as full remuneration for performing all services and furnishing all staffing and materials for Modesto in accordance with Exhibit "A" attached hereto and for performance by Consultant of all of its duties and obligations under this Agreement, except that additional services may be compensated as described below.

The Compensation shall be paid pursuant in the manner and at the times set forth below:

City shall pay Consultant on a time and materials basis for Consultant’s actual costs for all work called for in Exhibit “A” to this Agreement. All work to be performed under this Agreement shall be billed at the hourly rates set forth in Exhibit “B” attached hereto, Consultant shall submit monthly invoices to City which include detailed tasks, hours worked, #22..
- 577 -
-3-
and billable rates for all work completed, and detailed receipts for any out-of-pocket costs paid by Consultant in connection with work performed on this project.

No retainage will be withheld by City from progress payments due the Consultant. Retainage by the Consultant or subconsultants is prohibited, and no retainage will be held by the Consultant from progress due subconsultants. Any violation of this provision shall subject the violating Consultant or subconsultants to the penalties, sanctions, and other remedies specified in Section 7108.5 of the California Business and Professions Code. This requirement shall not be construed to limit or impair any contractual, administrative, or judicial remedies, otherwise available to the Consultant or subconsultant in the event of a dispute involving late payment or nonpayment by the Consultant or deficient subconsultant performance, or noncompliance by a subconsultant. This provision applies to both DBE and non-DBE Consultants and subconsultants.

Reimbursable Expenses including all printing and reproduction, travel, vehicle mileage, delivery and horticultural soils samples expenses will be billed at cost. The total cost for all reimbursable expenses for the Project shall not exceed $4,208, and is included in the not exceed figure of $263,257. It is the responsibility of the Consultant to manage reimbursable expenses to ensure that they do not exceed this budget. Reimbursable expenses shall be invoiced to the City by monthly invoices and shall itemize the reimbursable expenses incurred during the preceding month and indicate the amount due.

Additional services may be authorized by the Department Director in an amount up to, but not to exceed 10% of the agreed maximum compensation, or TWENTY-SIX THOUSAND THREE HUNDRED TWENTY-SIX AND 00/100 DOLLARS ($26,326). In the event that additional services are deemed necessary, the Consultant shall provide a written #22..
- 578 -
-4-
request to the Department Director, or designee, indicating the reason for additional work, scope and cost of such work. The Department Director, or designee, shall provide a written response to the request, either approving or denying the additional expenditure. If additional services are requested and approved, they will be billed at the hourly rates set forth in Exhibit “B” and may not exceed the amount requested and approved in writing by the Department Director. In that event, the new total compensation shall not exceed TWO HUNDRED EIGHTY NINE THOUSAND FIVE HUNDRED EIGHTY THREE AND 00/100 DOLLARS ($289,583). If additional services in excess of this amount are deemed necessary by City Staff, an amendment to this Agreement will be required and must be approved by the City Council prior to commencing the work, as provided in Paragraph 9 of this agreement.

4. OBLIGATIONS OF CONSULTANT.

Throughout the term of this Agreement, Consultant shall possess, or secure all licenses, permits, qualifications and approvals legally required to conduct business.

Consultant warrants that it has all of the necessary professional capabilities and experience, as well as all tools, instrumentalities, facilities and other resources necessary to provide the City with the services contemplated by this Agreement. Consultant further warrants that it will follow the current, generally accepted and professional practices to make findings, render opinions, prepare factual presentations, and provide professional advice and recommendations regarding this project.

5. PERFORMANCE BY KEY EMPLOYEE.

Consultant has represented to City that Ed Noriega, Project Manager, will be the person primarily responsible for the performance of the services referred to in this Agreement. City has entered into this Agreement in reliance on that representation by #22..
- 579 -
-5-
Consultant. Consultant therefore agrees that twenty percent (20%) or more of the time to be devoted to the project that is the subject of this Agreement will be that of the above-named person.

6. OWNERSHIP OF DOCUMENTS/TITLE TO DATA.

Ownership of Documents
All reports, drawings, designs, graphics, working papers and other incidental work or materials furnished hereunder shall become and remain the property of the City, and may be used by City as it may require without any additional cost to City. No reports shall be used by the Consultant for purposes other than this contract without the express prior written consent of City.

Title to Data
If, as a part of the agreement, Consultant is required to produce data such as, but not limited to, drawings, plans, specifications, calculations, models, flow diagrams, visual aids and other related materials, the originals of all such data generated under this agreement will be delivered to City upon the completion or termination of services under the contract.

All materials, documents, data or information obtained from the City data files or any City medium furnished to Consultant in the performance of this Agreement will at all times remain the property of the City. Such data or information may not be used or copied for direct or indirect use by Consultant after termination of this Agreement without written consent of the City.

7. NEWS AND INFORMATION RELEASE.

Consultant agrees that it will not issue any news releases in connection with either the award of this Agreement, or any subsequent amendment of or efforts under this #22..
- 580 -
-6-
Agreement, without first obtaining review and approval of said news releases from City through the City Manager.

8. INTEREST OF CONTRACTOR.

Consultant warrants that it presently has no interest and shall not acquire any interest, direct or indirect, which would conflict in any manner or degree with the performance of services required to be performed under this Agreement. Consultant warrants that, in performance of this Agreement, Consultant shall not employ any person having any such interest. Consultant agrees to file a Statement of Economic Interests with the City Clerk at the start and end of this contract if so required at the option of City.

Consultant warrants that he/she has not employed or retained any company or person, other than a bona fide employee working for the consultant; to solicit or secure this contract; and that he/she has not paid or agreed to pay any company or person other than a bona fide employee, any fee, commission, percentage, brokerage fee, gift, or any other consideration, contingent upon or resulting from the award, or formation of this contract. For breach or violation of this warranty, City shall have the right to annul this contract without liability, or at its discretion; to deduct from the contract price or consideration, or otherwise recover the full amount of such fee, commission, percentage, brokerage fee, gift or contingent fee.

9. AMENDMENTS.

Both parties to this Agreement understand that it may become desirable or necessary during the execution of this Agreement, for City or Consultant to modify the scope of services provided for under this Agreement. Any material extension or change in the scope of #22..
- 581 -
-7-
work shall be discussed with City and the change and cost shall be memorialized in a written amendment to the original contract prior to the performance of the additional work.

Until a change order is so executed, City will not be responsible to pay any charges Consultant may incur in performing such additional services, and Consultant shall not be required to perform any such additional services.

10. INDEPENDENT CONTRACTOR.

All acts of Consultant, its agents, officers, and employees and all others acting on behalf of Consultant relating to the performance of this Agreement, shall be performed as independent contractors and not as agents, officers, or employees of City. Consultant, by virtue of this Agreement, has no authority to bind or incur any obligation on behalf of City.

Consultant has no authority or responsibility to exercise any rights or power vested in the City.

No agent, officer, or employee of the City is to be considered an employee of Consultant. It is understood by both Consultant and City that this Agreement shall not under any circumstances be construed or considered to create an employer-employee relationship or a joint venture.

Consultant, its agents, officers and employees are and, at all times during the terms of this Agreement, shall represent and conduct themselves as independent contractors and not as employees of City.

Consultant shall determine the method, details and means of performing the work and services to be provided by Consultant under this Agreement. Consultant shall be responsible to City only for the requirements and results specified in this Agreement, and, except as expressly provided in this Agreement, shall not be subjected to City's control with respect to the physical action or activities of the Consultant in fulfillment of this Agreement. Consultant has control over the manner and means of performing the services under this Agreement. #22..
- 582 -
-8-
Consultant is permitted to provide services to others during the same period service is provided to City under this Agreement. If necessary, Consultant has the responsibility for employing other persons or firms to assist Consultant in fulfilling the terms and obligations under this Agreement.

If in the performance of this Agreement any third persons are employed by Consultant, such persons shall be entirely and exclusively under the direction, supervision, and control of Consultant. All terms of employment including hours, wages, working conditions, discipline, hiring, and discharging or any other term of employment or requirement of law shall be determined by the Consultant.

It is understood and agreed that as an independent contractor and not an employee of City neither the Consultant or Consultant's assigned personnel shall have any entitlement as a City employee, right to act on behalf of the City in any capacity whatsoever as an agent, or to bind the City to any obligation whatsoever.

It is further understood and agreed that Consultant must issue W-2 forms or other forms as required by law for income and employment tax purposes for all of Consultant's personnel.

As an independent contractor, Consultant hereby indemnifies and holds City harmless from any and all claims that may be made against City based upon any contention by any third party that an employer-employee relationship exists by reason of this Agreement.

11. ASSIGNMENT.

Neither this Agreement nor any portion thereof shall be subcontracted or assigned without the express prior written consent of the City in each and every instance. #22..
- 583 -
-9-

12. PATENT/COPYRIGHT MATERIALS.

Unless otherwise expressly provided in the contract, Consultant shall be solely responsible for obtaining the right to use any patented or copyrighted materials in the performance of this Agreement. Consultant shall furnish a warranty of such right to use to City at the request of City.

13. NOTICES.

Notice required by this Agreement shall be given in writing and shall be deemed given and effective upon receipt provided that such are delivered in accordance with the provisions of this Section. Notices shall be delivered either by: (a) personal delivery (including delivery by an overnight courier service which obtains confirmation of receipt); or (b) by facsimile, provided that such transmission is followed by delivery by an overnight courier service which obtains confirmation of receipt; or (c) postage prepaid, return receipt requested, certified mail; or (d) by electronic transmission subject to reasonable proof that the notice was both transmitted and received. Each such notice shall be sent to the parties at the address respectively set forth below or to such other address as a party may designate by written notice given in accordance with the provisions of this Section:
#22..
- 584 -
-10-
FOR CONSULTANT: Name: Mark Thomas & Company
Address: 7571 North Remington Ave, Suite 102
Fresno, CA 93711
Attention: Ed Noriega, Project Manager
Phone: Office: (559) 374-3111
Mobile: (530)484-1222
Facsimile: (559) 447-8586
Email: [email protected]
FOR CITY: Name: City of Modesto
Address: P.O. Box 642
Modesto, CA 95353
Attention: Laurie A. Smith
Phone: (209) 577-5344
Email: [email protected]

14. INSURANCE REQUIREMENTS.

The Consultant shall provide at its own expense and maintain at all times the following insurance with insurance companies licensed in the State of California and shall provide evidence of such insurance to the City as may be required by the Risk Manager of the City. The policies or certificates thereof shall provide that, thirty (30) days prior to cancellation or material change in the policy, notices of same shall be given to the Risk Manager of the City by certified mail, return receipt requested, for all of the following stated insurance policies.

In the event the certificates of insurance required hereunder do not provide for notice of cancellation to the certificate holder and/or additional insureds, the Consultant shall provide, and shall require its subcontractors to provide, as an express condition precedent to payment hereunder, an endorsement from their insurers providing that the additional insureds identified herein shall be provided 30 days notice of the cancellation on the policies of insurance required hereunder (10 days notice if the policies are cancelled for non-payment of premium). In addition, the named insured on all such policies shall provide to the additional insureds identified #22..
- 585 -
-11-
herein any notices of cancellation of said insurance policies within 5 business days of receipt of such notice. The Consultant shall, as a further express condition precedent to payment for work performed, affirm under penalty of perjury that the required insurance on the project remains in place and said insurance has not been cancelled.
(a) Worker's Compensation - in compliance with the statutes of the State of California, plus employer's liability with a minimum limit of liability of $1,000,000. (b) General Liability insurance with a minimum limit of liability per occurrence of $1,000,000 for bodily injury and property damage. If Commercial General Liability Insurance or other form with a general aggregate limit is used, either the general aggregate limit shall apply separately to this project/location or the general aggregate limit shall be twice the required occurrence limit. This insurance shall indicate on the certificate of insurance the following coverages and indicate the policy aggregate limit applying to: premises and operations; broad form contractual; independent consultants and subcontractors; products and completed operations as applicable.
(c) Automobile Liability insurance with a minimum limit of liability per occurrence of $1,000,000 for bodily injury and property damage. This insurance shall cover any automobile for bodily injury and property damage.
(d) Professional Liability insurance with a minimum limit of $1,000,000 per claim and $2,000,000 policy aggregate. If coverage is on a claims made basis it shall be maintained for at least three (3) years following completion of the work.

If at any time any of said policies shall be unsatisfactory to the City or State of California, as to form or substance, or if a company issuing such policy shall be unsatisfactory to the City or State of California, the Consultant shall promptly obtain a new #22..
- 586 -
-12-
policy, submit the same to the Risk Manager for approval and submit a certificate thereof as hereinabove provided. Upon failure of the Consultant to furnish, deliver or maintain such insurance and certificates as above provided, this Agreement, at the election of the City or State of California, may be forthwith declared suspended or terminated. Failure of the Consultant to obtain and/or maintain any required insurance shall not relieve the Consultant from any liability under this Agreement, nor shall the insurance requirements be construed to conflict with or otherwise limit the obligations of the Consultant concerning indemnification. The City and State of California, its agents, officers, employees, and volunteers shall be named as an additional insured on all insurance policies required herein, except Workers' Compensation and Professional Liability. The Workers' Compensation insurer shall agree to waive all rights of subrogation against the City and State of California, its agents, officers, employees, and volunteers for losses arising from work performed by Consultant for the City or State of California. The Consultant's insurance policy(ies) shall include a provision that the coverage is primary as respects the City or State of California; shall include no special limitations to coverage provided to additional insured; and, shall be placed with insurer(s) with acceptable Best's rating of A:VII or with approval of the Risk Manager. The Consultant must deliver certificates evidencing existence of the insurance listed above to the City prior to the time the contract is signed.

CONSULTANT shall provide CITY with separate endorsements evidencing proof of the CITY’s additional insured status as to both the general liability and automobile liability insurance policies. In addition, CONSULTANT shall provide CITY with a Workers Compensation subrogation waiver by way of a separate endorsement. All endorsements referenced above must include the applicable policy number. #22..
- 587 -
-13-
For any claims related to this project, the CONSULTANT’S insurance coverage shall be primary insurance as respects the Entity, its officers, officials, employees, and volunteers. Any insurance or self-insurance maintained by the Entity, its officers, officials, employees, or volunteers shall be excess of the CONSULTANT’S insurance and shall not contribute with it.

15. TERMINATION OF AGREEMENT.

Termination by City for Default of Consultant
Should Consultant default in the performance of this Agreement or materially breach any of its provisions, at its option, City may terminate this Agreement by giving written notification to Consultant. The termination date shall be the effective date of the notice. For the purposes of this section, material breach of this Agreement shall include, but not be limited to, any of the following: failure to perform required services or duties, willful destruction of City's property by Consultant, dishonesty or theft.

Termination by City for Convenience
TheCitymay also terminate theConsultant's performance underthe Agreement, eitherin whole orin part, at its own discretion, or when conditions encountered duringthe Work make it impossible orimpracticable to proceed, or when theCityis prevented fromproceeding with the Agreement by act of God, by law, or by official action of a public authority, or upon a determination by the City that such termination is in the best interest and convenience of the City, or whenever the City is prohibited from completing the Work for any reason. TheCityshall provide no lessthan ten (10) calendar days written notice of its intent to terminate the Agreement for convenience, and shall endeavor to provide the Consultant with consultation with the City prior to termination.
#22..
- 588 -
-14-
Post-Termination Procedure
Upon receipt of a written notice of termination pursuant to either of the foregoing paragraphs, the Consultant shall:
a. Cease its work as directed in the notice of termination as of the termination date and see to it that its employees, subconsultants and agents are notified of such termination and act as specified in the notice of termination;
b. Terminate all orders and Subcontractors except as necessary to complete any portion of the Work that is not terminated; c. If directed in writing by the City to do so, assign all right, title and interest in subcontracts and materials in progress to City, in which case the City will have the right at its discretion to settle, or pay any or all claims arising out of the termination of such subconsultants, but in no event shall recovery by any Consultant or subconsultant include lost profits for portions of the Work not completed or undertaken, including materials not delivered; d. Deliver or otherwise make available to the City all data, drawings, specifications, reports, estimates,summaries and such other information and material as mayhave been accumulated by the Consultant in performing the Work whether completed or in process; e. Settle outstanding liabilities and claims, subject to the approval of City;
f. Complete performance of such part of the Work as has not been #22..
- 589 -
-15-
terminated;
g. Take such other actions as may be necessary, or as may be directed by the City for the protection and preservation of the Work and/or property related to the Work;
h. If City so requests, and at City's cost, Consultant shall provide sufficient oral or written status reports to make City reasonably aware of the status of Consultant's work on the project. i. The Consultant understands and agrees that City may, in City's sole discretion, refuse to pay Consultant for that portion of Consultant's services which were performed by Consultant on the project prior to the termination date and which remain
unacceptable and/or not useful to City as of the termination date.

City will pay Consultant an amount based on the percentage of satisfactory work completed in accordance with the notice of termination. The final payment to the Consultant after termination for convenience shall be limited to amounts due and owing under the Agreement at time of termination, including the following:
a. The cost of settling and paying valid claims arising out of the termination of the Work such as subconsultant agreements or contracts for materials;
b. The Agreement price allocable to the portion of the Work properly performed or goods supplied to the work site by the Consultant as of the date of termination, as determined in accordance with the notice of termination, reduced by any sums #22..
- 590 -
-16-
previously paid to the Consultant.

Authorization to Terminate Agreement
Termination of the Agreement may be invoked by the City Manager, or his/her designee, subject to the right of the Consultant to appeal the City Manager, or his/her designee’s, decision to the City Council. The Consultant shall appeal by notifying the City Clerk in writing within ten (10) calendar days of receipt of written notification from City of termination of the Agreement. In the event that termination of this Agreement is upheld by the City Council, any cessation of payment of delay claims, extended claims, Eichleay claims, or any other claims for delay shall be retroactive to the date of termination selected by the City Manager, or his/her designee.

16. CERTIFIED PAYROLL REQUIREMENT.

For consultants performing field work on public works contracts on which prevailing wages are required: The Consultant shall comply with the provisions of Section 1776 of the California Labor Code, regarding payroll records, and shall require its subconsultants and subcontractors to comply with that section as may be required by law.

17. INDEMNITY.

The Consultant shall hold the City and State of California, it agents , officers, employees, and volunteers, harmless from and save, defend and indemnify them against any and all claims, losses, liabilities, judgments or damages from every cause, including but not limited to injury to person or property or wrongful death, including reasonable costs and expenses of defense, to the proportionate extent caused by any negligent or intentional wrongful act or omission of Consultant, or its agents, officers, employees, or volunteers relating to or #22..
- 591 -
-17-
during the performance of its obligations under this Agreement. Consultant’s cost of defense shall not exceed the Consultant’s proportionate percentage of fault.

Consultant's obligation to defend, indemnify, and hold the City and State of California, its agents, officers, and employees harmless under the provisions of this paragraph is not limited to or restricted by any requirement in this Agreement for Consultant to procure and maintain a policy of insurance.

18. DISPUTE RESOLUTION.

All claims, controversies, or disputes arising out of, or relating to the formation of this Agreement, or the breach, termination execution, enforcement, interpretation, or validity of this Agreement, including the determination of the scope or applicability of this contract provision shall be determined by binding arbitration in Modesto, California by one arbitrator, except as otherwise specified in this Agreement. The American Arbitration Association shall administer the arbitration under its Arbitration Rules then in effect, subject to the modifications of those rules contained in this paragraph. This agreement to arbitrate shall be specifically enforceable under the prevailing law of any court having jurisdiction, and the award rendered by the arbitrator may be entered in any court having jurisdiction. The appropriate venue for any arbitration or court proceeding relating to or arising out of this provision shall be in Stanislaus County, California.

This paragraph is not intended to and does not waive the claim filing requirements found in California Government Code section 900 et seq. In the event that a timely and legally sufficient, arbitrable claim is filed by Consultant with City, and the claim is rejected in whole or in part by City, this paragraph shall result in the conclusive, final, and binding resolution of all the issues presented in the claim by Consultant so long as any issues presented #22..
- 592 -
-18-
by the claim are arbitrable. Claims rejected by City or by operation of law, shall be submitted by Consultant to arbitration pursuant to the Arbitration Rules of the American Arbitration Association within ninety (90) days after mailing of the written rejection by City to Consultant.

Otherwise, the claim or claims shall be deemed waived in their entirety.

The “fast track’ rules of the American Arbitration Association shall apply to any claim or counterclaim less than ONE HUNDRED FIFTY THOUSAND AND 00/100 ($150,000.00) DOLLARS. In arbitration not proceeding under the “fast track” rules, the arbitrator shall have the power to order that depositions be taken and other discovery be made.

Both City and Consultant shall have the right, upon written notice, to take no more than three (3) depositions of the other as a matter of right in an arbitration proceeding under the “fast track” rules.

Whether or not City and Consultant may be engaged in interstate commerce, any controversy or dispute mentioned above shall be determined by, and the parties shall be bound by, the substantive law of the State of California, and not the Federal Arbitration Act at 9 USC Section 1 et seq.

The arbitrator may grant any remedy or relief deemed by the arbitrator just and equitable under the circumstances, whether or not such relief could be awarded in a court of law. The arbitrator shall be empowered to award monetary sanctions against a party for failure of cooperation in the arbitration. The arbitrator shall, in written award, allocate all the costs of the arbitration, including the fees of the arbitrator and the reasonable attorney fees of the prevailing party, against the party who did not prevail. The prevailing party shall be the party in whose favor the majority of the central issues in the case are resolved. #22..
- 593 -
-19-
Notwithstanding anything in this provision to the contrary, the arbitrator shall have no power to award punitive damages or other damages not measured by the party’s actual damages (excluding litigation costs and fees) against any party. This limitation of the arbitrator’s powers under this Agreement shall not operate as an exclusion of the issue of punitive damages from this Agreement to Arbitrate sufficient to vest jurisdiction in a court with respect to that issue.

Consultant shall include in all subcontracts a specification whereby the subcontractor consents to being joined in an arbitration between City and Consultant involving the work of the subcontractor to be joined. Consultant’s failure to do so shall be a breach of this Agreement.

The parties hereby waive any rights provided by Title 9.2 of the California Code of Civil Procedure, Section 1296. The arbitrator’s award shall be deemed final, conclusive and binding to the fullest extent allowed by California law.

19. ENTIRE AGREEMENT.

This Agreement and its exhibits contain the entire understanding between Consultant and City. Additional or new terms contained in this Agreement which vary from Consultant's proposal are controlling and are deemed accepted by Consultant by shipment of any article or other commencement of performance hereunder. All previous proposals, offers and communications relative to this Agreement, whether oral or written, are hereby superseded except to the extent that they have been incorporated into this Agreement. No future waiver of or exception to any of the terms, conditions, and provisions of this Agreement shall be considered valid unless specifically agreed to in writing by all the parties.

20. PARTIAL INVALIDITY.
#22..
- 594 -
-20-
If any provision in this Agreement is held by a court of competent jurisdiction to be invalid, void, or unenforceable, the remaining provisions shall nevertheless continue in full force without being impaired or invalidated in any way.

21. WAIVER.

The waiver by any party to this Agreement of a breach of any provision hereof shall be in writing and shall not operate or be construed as a waiver of any other or subsequent breach hereof unless specifically stated in writing.

22. AUDIT.

The City's duly authorized representative shall have access at all reasonable times to all reports, contract records, contract documents, contract files, and personnel necessary to audit and verify Consultant's charges to City under this Agreement.

Consultant agrees to retain reports, records, documents, and files related to charges under this Agreement for a period of four (4) years following the date of final payment for Consultant services. City's representative shall have the right to reproduce any of the aforesaid documents.

23. GOVERNING LAW.

This Agreement shall be governed according to the laws of the State of California.

24. HEADINGS NOT CONTROLLING.

Headings used in the Agreement are for reference purposes only and shall not be considered in construing this Agreement.

25. COMPLIANCE WITH LAWS.
#22..
- 595 -
-21-
Consultant shall insure compliance with all safety and hourly requirements for employees, in accordance with federal, state, and county safety and health regulations and laws. Consultant shall fully comply with all applicable federal, state, and local laws, ordinances, regulations and permits.

26. CITY BUSINESS LICENSE.

Consultant will have a City of Modesto business license.

IN WITNESS WHEREOF, the City of Modesto, a municipal corporation, has authorized the execution of this Agreement in duplicate by its City Manager and attestation by its City Clerk under authority of Resolution No. 2023- , adopted by the Council of the City of Modesto on the day of , 2023, and ____________ has caused this agreement to be duly executed in duplicate as of the Effective Date.
#22..
- 596 -
Parks, Recreation and
Neighborhoods Department
Parks Planning and
Development Division
P.O. Box 642
Modesto, California 95354
209.577.5344
EXHIBIT ‘A’

SCOPE OF WORK

PROJECT BACKGROUND
The Tuolumne River Regional Park (TRRP) Project was conceived during the 1960s to preserve and enhance approximately 7-miles of the river corridor that travels through the City of Modesto.

The park includes approximately 500 acres, is mostly on the north side of the river, and extends from Mitchell Road and the city airport on the east, to just beyond Carpenter Road on the west.

Approximately 180-acres of the park is developed to date.

In the late 1990’s, due to limitations on funding and changes in local demographics, a new Master Plan and Master Environmental Impact Report (MEIR) were developed over a two-year period for the Tuolumne River Regional Park and were approved and certified by the TRRP Joint Powers Authority, which consists of the City of Ceres, Modesto and the County of Stanislaus. Both City Councils and the County Board of Supervisors took a formal action to approve the Master Plan and MEIR in December 2001.

Subsequently, a Request for Proposal (RFP) to develop a Precise Plan for the approximate 90- acre Gateway Parcel was issued in 2003 and was completed in 2005. Included in the products developed for the Precise Plan was an Initial Study/Finding of Conformance to the TRRP MEIR and a Schematic Design Package.

Construction of the Gateway Parcel development (the area on the north side of the river from the confluence of the Tuolumne River and Dry Creek to the Seventh Street Bridge) commenced in 2006. Riparian habitat restoration activities have included construction of backwater channels, riparian terraces, wildlife areas, amphimeadow and river structure dam removal.

Recreational construction activities have included an outdoor classroom, river observation deck, multiple Class 1 trails and a pedestrian bridge installation.

Within the Tuolumne River Regional Park the City is actively planning for the Neece Drive NonMotorized Boat Launch Facility (TRRP Golf Course Area), Bellenita Soccer Field Complex (TRRP Carpenter Road Area), Gateway River Overlook (TRRP Gateway Area), Legion Park River Pavilion (TRRP Legion Park Area) and Legion Park Learning Theater (TRRP Legion Park Area) projects.

PROJECT DESCRIPTION
TRRP RIVERWALK TRAIL - GATEWAY TO NEECE DRIVE:

The project includes design construction documentation for a paved Class 1 trail along the river frontage extending from west Gateway Parcel to the intersection of Neece Drive and Rouse Avenue. Additionally, provide documentation for an approximately 30 striped parking stall paved parking lot, solar area lighting, bench seating areas, concrete paved picnic pads, paved ADA accessible trail connection(s) to new amenities, community pedestrian sidewalk and ADA ramp #22..
- 597 -
improvements. Encroachment permit from CalTrans will be required for the trail crossing under State Highway 99.
• In addition to the Trail Section Components listed above, construction plans and details shall include, at minimum, the following items:
o A 10’-12’ wide permeable concrete paved Class 1 trail. o Recreation trailhead, with small concrete paved plaza space, information kiosk, bench seating, waste receptacle and area lighting at Neece Drive and Rouse Avenue intersection.
o Small concrete paved plaza space, bench seating, waste receptacle and area lighting at Neece Drive Riverwalk Trail intersection.
o (3) Bench seating resting areas along trail section.
o Approximately (30) striped parking stall paved parking lot with solar powered area light poles. Parking lot to be placed adjacent to and in conjunction to the Neece Drive Non-Motorized Boat Launch Project work area. o (3) Concrete paved family picnic pads each with picnic table, waste receptacle and paved trail connection to the Riverwalk Trail, to be placed within the Neece Drive Non-Motorized Boat Launch Project work area.
o Community Access Improvements to the corners of Neece Drive & Rouse Avenue and Rouse Avenue & Sunset Avenue, in addition to sidewalk improvements on the west side of Sunset Avenue between Rouse Avenue and Jean St.

The work to be accomplished in this project consists of preparation of construction documentation and completion of permit application documentation as necessary to obtain permit acceptance. Emphasis on continuing and improving the existing conceptual and Master Plan designs, value engineering, simplicity and quality design will be essential to the success of this project.

The project will require an experienced full-service consultant (team) with the ability to evaluate the existing conditions and make recommendations in a wide range of design services including but not limited to: structural engineering, civil engineering, landscape architectural, and surveying. This project will also require the services of geotechnical specialists, archeological specialists, habitat restoration specialists and environmental consultants familiar with state and federal requirements and permit processes involving projects adjacent to or in navigable waters of the United States. Design services work shall be prepared by persons licensed by the State of California to undertake the type of design work required by the Project (engineer’s/architect’s license number to appear on construction contract design documents).

The consultant selected will need to be familiar with plans and specifications, and shall conform with the most recent version of all applicable local building codes (City of Modesto), Stanislaus County Health Department codes, the TRRP Master Plan (and any applicable Master Plan Updates), TRRP MEIR, TRRP Gateway Precise Plan, Initial Study/Finding of Conformance for the TRRP Gateway Precise Plan, City of Modesto Standards and Caltrans Specifications, Modesto Urban Area General Plan and MEIR.

The Construction Documentation will be comprehensive and will include some, if not all, the following items:
#22..
- 598 -
• Rough grading and storm water pollution prevention.
• Site preparation, finish grading and drainages.
• Sensitive habitat protection plans and removal of non-native species. • Riparian habitat landscape plantings, with installation of a rigid temporary irrigation system to establish riparian habitat plantings for a period of three years, where applicable.
• Parkway landscaping and permanent irrigation system at roadway intersections and plaza spaces.
• Site Furnishings: bench(s), picnic table(s), bike rack(s), bollard(s), kiosks and comprehensive wayfinding signage.
• Street curb, gutter replacement and repair, where applicable. • 25’ light pole fixtures along trail sections. Fixtures to include hardwired and solar options.

General Project Assumptions – The project scope:
• Does not include R/W Acquisition Documents
• Does not include R/W Appraisal and Acquisition
• Assumes rights-of-entry will be provided by City.

PROFESSIONAL DESIGN CONSULTING SERVICES TO INCLUDE
Based on the above, the following scope of services to be performed in chronological order.

Listed below are tasks and conditions that the consultant is expected to perform and meet on this project. It is not intended the tasks shown are the only tasks required on this project. The City will provide electronic copies of the necessary background documentation TASK #1 – PROJECT MANAGEMENT / PERMITTING

1.1 Kick-off meeting (Meeting #1) in Modesto with City Staff to:
a. Confirm project description/schedule
b. Obtain information and data regarding the project
c. Advise the City of Modesto on the approach to be taken in preparing the Phase I/Environmental Site Assessment and Biological Assessment for this project. d. Provide utility coordination services to determine existing utilities to generate preliminary utility plans.

1.2 Conduct a detailed site visit and collect and review all pertinent documentation including but not limited to the TRRP Master Plan (and any applicable Master Plan Updates), the Initial Study/Finding of Conformance for this project and the TRRP Master Plan MEIR.

1.3 Prepare a final project description through data collection, field work, and research which will be the basis for the preparation of the permits.

1.4 Conduct and prepare an Administrative Draft Phase I/Environmental Site Assessment as required by CEQA determinations and as directed by City of Modesto Staff.

1.5 Prepare Biological Assessment Report for use in permitting with State Agencies that includes site identification of plant species; tree species, location and DBH; and potentially impacted wildlife.
#22..
- 599 -

1.6 Complete Section 106 Report (Cultural Resources Inventory Report), Native American consultation, and Agency Coordination.

1.7 Provide the City with one (1) reproducible original and one (1) electronic copy of the above said documents for reproduction and distribution.

1.8 Based on comments from City staff, prepare a final Phase I/Environmental Site Assessment, Cultural Resources Inventory Report and Biological Assessment.

1.9 Coordinate and prepare all necessary permit applications and additional information if and as required by the CA Department of Fish and Wildlife, San Joaquin Valley Air Quality Control Board, Regional Water Quality Control Board, Department of Water Resources, Bureau of Reclamation and any other agency as identified in the Initial Study or as identified by the City of Modesto. Consultant shall assist City staff in ensuring the necessary permits are obtained prior to bidding the project.

1.10 Perform ongoing internal project coordination to share project information, identify critical issues, make decisions, assign project tasks, identify design criteria, and any other items critical to project delivery and perform ongoing general project coordination meetings with Caltrans.

1.11 At this time no USFWS/NFMS Consultation is anticipated but should it be necessary it would be an additional service to this contract.

1.12 Environmental Assumptions
• Surveys for elderberry shrubs will follow USFWS 2017 protocols and individual stem count measurements will not be required.
• Tree inventory will be performed for trees that are in the project features alignments and no more than 25 feet outside of the alignments.
• Anticipate no built environment or other historic-era resources will be affected in the project area and therefore no built environment field survey is included or required. • Anticipate that there are no archaeological or Tribal cultural resources in the project area. Field surveys will take one 10-hour day.
• Field surveys are based on the current project description (up 1.2 miles long). • GEI assumes that the City will make the necessary arrangements to provide access.

One GEI archaeological survey crew consisting of two archaeologists will conduct a cultural resources inventory of the APE to intensive standards. • Does not include Hydrology and Hydraulics Study. Assume SR 99 will not require H&H study.
• Does not include preconstruction surveys.
• Fee for permits shall be City’s responsibility.

TASK #2 – CONSTRUCTION DOCUMENTATION

2.1 Conduct an interdepartmental start up meeting in Modesto to begin the construction documentation process. (Meeting #2)
#22..
- 600 -

2.2 Topographic survey of Section 1 to locate the existing visible improvements and visible utilities. The survey shall include existing grades, any above ground utility structures, utility lines, trees identifying size (dbh), type and condition, and all above ground structures. If the Neece Drive Boat Launch construction is completed prior to design completion, additional topographic survey would be competed to document these new elements.

2.3 Project Scope does not include geotechnical services.

2.4 Prepare preliminary 30% construction documents including:
a. Preliminary Site Plan
b. Preliminary Utility Relocation Plans
c. Preliminary Trail Civil Plans, including preliminary plans and profiles d. Preliminary Light Fixture Layout with renderings of pole/fixture/solar panel combinations and photometric analysis.

Deliver one (1) PDF sets of plans and specifications to City. City staff will require a minimum of four (4) weeks for review of 30% construction documents.

2.5 Conduct an interdepartmental review session in Modesto to review City comments on 30% plans. (Meeting #3)

2.6 Based on comments received, prepare 75% construction documents including plans, specifications, and refined cost estimates. Submittal will include status of permits, comments from outside agencies and preliminary estimate of costs associated with permitting the project. Deliver one (1) PDF and four (4) hardcopy sets of plans and specifications to City. City staff will require a minimum of six (6) weeks for review of 75% construction documents.

2.7 Conduct an interdepartmental review session in Modesto to review City comments on 75% plans and prepare a response to comments including intended resolution. (Meeting #4)

2.8 Based on comments received, prepare 100% construction documents including plans, specifications and detailed estimate. In addition, provide a status of permits and final costs associated with permitting the project. Plans will be prepared to allow for deductive and additive alternates or phased construction as necessary. Deliver one (1) PDF and four (4) hardcopy sets of plans and specifications to City. City staff may require a minimum of four (4) weeks for review of 100% construction documents.

The construction documents for the park will include, (as applicable):
• title sheet
• general notes
• project control
• typical sections
• demolition plan
• grading & drainage plan, with utility information & existing conditions (using 1’ contours)
#22..
- 601 -
• erosion and sediment control plans and details
• sign and trail marking plans and details
• site construction plans and details
• planting plan and details
• irrigation plan and details
• electrical plans and details
• structural details and needed
• technical specifications (CSI format), city will provide boiler plate specifications • bid form
Provide one (1) set of final wet stamped Bond original plans and specifications for reproduction and a signed pdf of the plan set, one (1) AutoCAD (version 2019 compatible) drawings file. Use “D” size plan sheet and City of Modesto Title Block and Standards. All final plans & specifications shall be stamped & signed by a registered professional (Landscape Architect or Engineer), as appropriate.

Specifications should be CSI 6-digit provided in Microsoft Word and organized to match the format requested by the City during the design process. The Consultant must use the City of Modesto typical “front end” documents. Consultants may request additional sections be added to either division and/or recommend changes to the current “front ends”. Any changes must be requested in writing and are subject to review and approval by the City. Plans and Specifications shall meet all local, state and federal requirements as necessary. All construction shall be designed to be in accordance with current Americans with Disabilities Act and Title 24 requirements.

TASK #3 – BIDDING AND CONSTRUCTION SUPPORT

3.1 Assist City staff in bidding process as required, including answering questions from bidders.

3.2 Review and process all shop drawings and submittals required by technical specifications; with use of digital E-Builder Construction Management software. Free training will be provided by City for E-Builder Software.

3.3 Provide site visit reviews and prepare reports on construction progress and quality, with recommendations for correction of any deficiencies (approximately three-(3) Field Meetings).

3.4 Assist in determining and processing requests for information and change orders.

3.5 Make final site visit review and report on completed project #22..
- 602 -

PROJECT SCHEDULE
Proposed milestones for the project tasks are as follows:

MILESTONE DATE
Award Design Contract Tuesday, January 10, 2023
Design Start February 2023
Design Completion Approx. February 2024
PROPOSED COMPENSATION`
The following fees are based on the scope of work described previously in Exhibit ‘A’.

Payments will be made on a monthly basis when portions of the tasks are completed.

The monthly billing at the Hourly Rates included in Exhibit ‘B’, and verifiable documentation on any reimbursable expenses incurred.

Task #1 – Project Management / Permitting (not to exceed) $ 57,806 Task #2 – Construction Documentation (not to exceed) $ 186,243 Task #3 – Bidding and Construction Support (not to exceed) $ 15,000 Reimbursable Expenses (not to exceed) $ 4,208
Total Contract Amount $ 263,257
Additional Services (not to exceed 10%) $ 26,326
Grand Total $289,583
#22..
- 603 -
Parks, Recreation and
Neighborhoods Department
Parks Planning and
Development Division
P.O. Box 642
Modesto, California 95354
209.577.5344
EXHIBIT ‘B’

HOURLY RATES
The following hourly rates will be used for billable hours within this Agreement and for additional work requested and approved. In addition, monthly progress payment invoices shall include the minimum attachments: Detailed description or itemization of work completed for the time period, task billing summary, hourly rates from all consultants.

Mark Thomas
Engineering & Planning
Engineer Manager $305
Design Engineer II $135
Design Engineer I $110
Sr. Project Coordinator $138
O’Dell Engineering
Survey/Outreach/Landscape
Principal $280
Senior Civil Engineer $215
Senior Engineer 2 $200
Senior Engineer 1 $185
Engineer 2 $180
Engineer 1 $170
Assistant Engineer 2 $145
Assistant Engineer 1 $130
Senior Landscape Architect 2 $200
Senior Landscape Architect 1 $180
Landscape Architect 2 $170
Landscape Architect 1 $160
Landscape Designer 3 $155
Landscape Designer 2 $145
Landscape Designer 1 $135
Planner $175
Assistant Planner $140
#22..
- 604 -
Dry Utility Project Manager 2 $170
Dry Utility Project Manager 1 $150
Utility Engineer $135
CADD Operator 2 $115
CADD Operator 1 $95
Surveyor Manager $205
Senior Land Surveyor $195
Senior Surveyor 2 $190
Senior Surveyor 1 $170
Surveyor 2 $150
Surveyor 1 $140
Assistant Surveyor 2 $130
Assistant Surveyor 1 $115
Survey Crew 2-man/1-man $320/$180
Survey Crew 2-man/1-man (Prevailing
Wage) $396/$225
Administrative $96
GEI
Environmental/Permitting
Staff Professional – Grade 1 $ 89
Staff Professional – Grade 2 $ 105
Project Professional – Grade 3 $ 118
Project Professional – Grade 4 $ 143
Senior Professional – Grade 5 $ 164
Senior Professional – Grade 6 $ 188 - $ 205
Senior Professional – Grade 7 $ 243
Senior Consultant – Grade 8 $ 274
Senior Consultant – Grade 9 $ 279
Senior Principal – Grade 10 $ 279
Senior Drafter and Designer $145
Drafter / Designer and Senior
Technician $118
Field Professional $106
Technician, Word Processor,
Administrative Staff $84
#22..
- 605 -
Office Aide $83
Fehr & Peers
Electrical
Principal $240 - $375
Senior Associate $205 - $300
Associate $175 - $225
Senior Engineer/Planner $160 - $215
Engineer/Planner $130 - $175
Senior Engineering Technician $150 - $215
Senior Project Accountant $170 - $190
Senior Project Coordinator $130 - $180
Project Coordinator $120 - $170
Technician $150 - $170
Intern $95 - $140
Crawford
Geotechnical
Principal $200
Senior Project Manager $180
Project Manager $175
Senior Geologist $155
Senior Engineer $155
Project Engineer II $145
Project Engineer I $135
Staff Engineer $115
Drafter $95
Project Assistant $70
Technician (PW) $110
Technician (Non-PW) $95
#22..
- 606 -
#22..
- 607 -
#22..
- 608 -

CITY OF MODESTO

COUNCIL AGENDA REPORT
DATE OF MEETING:

January 10, 2023
Date: December 14, 2022
TO: Mayor and City Council
THROUGH: Joseph P. Lopez, City Manager
FROM: Bill Sandhu, Public Works Director
SUBJECT: Environmental Protection Agency Consumer Recycling Education and Outreach Grant Program
CONTACT: Rosene Salmo, Integrated Waste Program Manager, [email protected], 209-577-5453
DESCRIPTION:

Consider authorizing the submittal of application(s) to the Environmental Protection Agency Consumer Recycling Education and Outreach Grant Program, and authorizing the City Manager or his designee to sign Grant Applications and related forms. (Funding Source: Not Applicable) STRATEGIC PLAN ELEMENT:

The recommended action is consistent with the Council’s Strategic Plan Area (2020-2025) - Quality of Life: “Engage partners across the community to ensure the safety, resilience, and attractiveness of Modesto;” Goal D: “Provide safe, efficient, and reliable infrastructure through proactive community investment, maintenance, and sustainability efforts.” BACKGROUND:

The Environmental Protection Agency (EPA) Consumer Recycling Education and Outreach Grant Program is a nationwide competitive grant that offers a minimum of $250,000 to a maximum of $2,000,000 to successful applicants. There is no match requirement for this grant.

In 2020, the EPA announced the United States National Recycling Goal to increase the U.S. recycling rate to 50% by 2030.1 In 2021, the EPA released the accompanying National Recycling Strategy: Part One of a Series on Building a Circular Economy for All to guide action on the National Recycling Goal.2 Funding was provided for the above goal and strategy in the 2021 Bipartisan Infrastructure Law, which allows for the Consumer Recycling Education and Outreach Grant Program.
1 https://www.epa.gov/recyclingstrategy/us-national-recycling-goal 2 https://www.epa.gov/recyclingstrategy/national-recycling-strategy #23..
- 609 -
City Council, January 10, 2023
Environmental Protection Agency Consumer Recycling Education and Outreach Grant Program

Page 2 of 3 ends

Modesto City CouncilJanuary 10, 2023

Modesto City Council
January 10, 2023