Agenda packet — Rancho Cucamonga City Council, August 17, 2022 (part 1 of 3)

Mayor
L. Dennis Michael
Mayor Pro Tem
Lynne B. Kennedy
Members of the City
Council:

Ryan A. Hutchison
Kristine D. Scott
CITY OF RANCHO CUCAMONGA
REGULAR MEETING AGENDA
August 17, 2022
10500 Civic Center Drive
Rancho Cucamonga, CA 91730
FIRE PROTECTION DISTRICT BOARD – CITY COUNCIL
HOUSING SUCCESSOR AGENCY SUCCESSOR AGENCY – PUBLIC
FINANCE AUTHORITY
CLOSED SESSION TRICOMMUNITIES ROOM 4:30 P.M.

REGULAR MEETINGS COUNCIL CHAMBERS 7:00 P.M.

The City Council meets regularly on the first and third Wednesday of the month a t 7:00 p.m. in the Council Chambers located at 10500 Civic Center Drive. It Is the Intent to conclude the meeting by 10:00 p.m. unless extended by the concurrence of the City Council. Agendas, minutes, and recordings of meetings can be found at www.cityofrc.us or by contacting the City Clerk's Office at 9097742023. Live Broadcast available on Channel 3 (RCTV3).

CLOSED SESSION – 4:30 P.M.

TRICOMMUNITIES ROOM
ROLL CALL: Mayor Michael
Mayor Pro Tem Kennedy
Council Members Hutchison and Scott
A. ANNOUNCEMENT OF CLOSED SESSION ITEM(S)
B. PUBLIC COMMUNICATIONS ON CLOSED SESSION ITEM(S)
C. CITY MANAGER ANNOUNCEMENTS
D. CONDUCT OF CLOSED SESSION
D1. CONFERENCE WITH LEGAL COUNSEL — EXISTING LITIGATION PURSUANT TO PARAGRAPH (1) OF SUBDIVISION (D) OF SECTION 54956.9; NAME OF CASE: CITY OF RANCHO CUCAMONGA V. DR LANDMARK, INC.; POWER MEDIC TECHNOLOGIES, INC.; HOFER PROPERTIES, LLC; AND DOES 1 THROUGH 5 INCLUSIVE, SBSC CASE NO.: CIVDS 1904713. (CITY)
D2. CONFERENCE WITH LEGAL COUNSEL – PENDING LITIGATION PURSUANT TO PARAGRAPH (4) OF SUBDIVISION (D) OF SECTION 54956.9; NAME OF CASE: CITY OF RANCHO CUCAMONGA V.

SOUTHERN CALIFORNIA EDISON, SBSC CASE NO.: PENDING. (CITY) D3. CONFERENCE WITH LEGAL COUNSEL – PENDING LITIGATION PURSUANT TO PARAGRAPH (4) OF SUBDIVISION (D) OF SECTION 54956.9; NAME OF CASE: CITY OF RANCHO CUCAMONGA V.

SOUTHERN CALIFORNIA EDISON, SBSC CASE NO.: CIVSB2201969. (CITY) D4. CONFERENCE WITH LEGAL COUNSEL POSSIBLE LITIGATION PURSUANT TO PARAGRAPH (4) OF SUBDIVISION (D) OF SECTION 54956.9; DEFAULT OF DEVELOPER OBLIGATIONS UNDER IMPROVEMENT AGREEMENT RELATED TO CASE NO. SUBTT18966. (CITY) D5. CONFERENCE WITH REAL PROPERTY NEGOTIATORS PER GOVERNMENT CODE SECTION 54956.8 FOR PROPERTY LOCATED AT 12089 FOOTHILL BOULEVARD, FURTHER IDENTIFIED AS SAN BERNARDINO COUNTY TAX ASSESSOR'S PARCEL NUMBER 022902148; NEGOTIATING PARTIES, JOHN GILLISON, CITY MANAGER REPRESENTING THE CITY OF RANCHO CUCAMONGA, AND JOAN LOPEZ AGGAZZOTTIE, ETC., ET AL., OWNER; REGARDING INSTRUCTIONS TO NEGOTIATORS CONCERNING PRICE. NEGOTIATING PARTIES MAY NEGOTIATE WITH THE PROPERTY OWNERS SET FORTH ABOVE. (CITY) D6. CONFERENCE WITH LEGAL COUNSEL – PENDING LITIGATION PURSUANT TO PARAGRAPH (4) OF SUBDIVISION (D) OF SECTION 54956.9; NAME OF CASE: CITY OF RANCHO CUCAMONGA V.

BTC III RANCHO CUCAMONGA LOGISTICS CENNTER LP, A DELAWARE LIMITED LIABILITY COMPANY, SBSC CASE NO.: CIVSB2201955. (CITY)
D7. CONFERENCE WITH LEGAL COUNSEL—EXISTING LITIGATION PURSUANT TO PARAGRAPH (1) OF SUBDIVISION (D) OF SECTION 54956.9; NAME OF CASE: JULIO PINEDA VS. CITY OF RANCHO CUCAMONGA, WORKERS COMPENSATION CASE NO. ADJ13303390. (CITY) D8. CONFERENCE WITH LEGAL COUNSEL ANTICIPATED LITIGATION: INITIATION OF LITIGATION PURSUANT TO PARAGRAPH (4) OF SUBDIVSION (D) OF GOVERNMENT CODE SECTION 54956.9: 1 CASE (CITY)
D9. CONFERENCE WITH REAL PROPERTY NEGOTIATORS PER GOVERNMENT CODE SECTION 54956.8 FOR PROPERTY GENERALLY LOCATED AT THE RANCHO CUCAMONGA METROLINK STATION IDENTIFIED AS PARCEL NUMBERS 020927211, 020914321, AND 020927222 AND CERTAIN ADJACENT RIGHTOFWAY INCLUDED WITHIN THE STATION FOOTPRINT; CITY NEGOTIATOR: JOHN GILLISON, CITY MANAGER, REPRESENTING THE CITY OF RANCHO CUCAMONGA; NEGOTIATING PARTIES: SARAH WATERSON, PRESIDENT, REPRESENTING DESERTXPRESS ENTERPRISES, LLC, DBA AS BRIGHTLINE WEST; UNDER NEGOTIATION:

PRICE AND TERMS OF PAYMENT. (CITY)
E. RECESS – Closed Session to Recess to the Regular City Council Meeting at 7:00 P.M. in the Council Chambers at City Hall, 10500 Civic Center Drive, Rancho Cucamonga, California.

REGULAR MEETING – 7:00 P.M.

COUNCIL CHAMBERS
PLEDGE OF ALLEGIANCE
ROLL CALL: Mayor Michael
Mayor Pro Tem Kennedy
Council Members Hutchison and Scott
A. AMENDMENTS TO THE AGENDA
B. ANNOUNCEMENT / PRESENTATIONS
B1. Recognition of the Rancho Cucamonga Fire Protection District for Receiving the Lifeline EMS Gold Plus Award.

B2. Presentation Recognizing Jenifer Phillips, Deputy Director of Human Resources, for Being Featured as IPMAHR’s Member Spotlight for the Month of August.

C. PUBLIC COMMUNICATIONS
Members of the City Council also sit as the Fire Board, Housing Successor Agency, Successor Agency, and Public Finance Authority. This is the time and place for the general public to address the Fire Protection District, Housing Successor Agency, Successor Agency, Public Financing Authority Board, and City Council on any item listed or not listed on the agenda. State law prohibits the Fire Protection District, Housing Successor Agency, Successor Agency, Public Financing Authority Board, and City Council from addressing any issue not previously included on the Agenda. The Fire Protection District, Housing Successor Agency, Successor Agency, Public Financing Authority Board, and City Council may receive testimony and set the matter for a subsequent meeting.

Comments are to be limited to five minutes per individual or less, as deemed necessary by the Mayor, depending upon the number of individuals desiring to speak. All communications are to be addressed directly to the Fire Board, Agencies, Successor Agency, Authority Board, or City Council not to the members of the audience. This is a professional business meeting and courtesy and decorum are expected.

Please refrain from any debate between audience and speaker, making loud noises, or engaging in any activity which might be disruptive to the decorum of the meeting.

The public communications period will not exceed one hour prior to the commencement of the business portion of the agenda. During this one hour period, all those who wish to speak on a topic contained in the business portion of the agenda will be given priority, and no further speaker cards for these business items (with the exception of public hearing items) will be accepted once the business portion of the agenda commences. Any other public communications which have not concluded during this one hour period may resume after the regular business portion of the agenda has been completed.

CONSENT CALENDARS:

The following Consent Calendar items are expected to be routine and noncontroversial. They will be acted upon without discussion unless an item is removed by Council Member for discussion.

Members of the City Council also sit as the Fire Board, Housing Successor Agency, Successor Agency, and Public Finance Authority and may act on the consent calendar for those bodies as part of a single motion with the City Council consent calendar.

D. CONSENT CALENDAR
D1. Consideration to Approve City and Fire District BiWeekly Payroll in the Total Amount of $1,880,259.00 and City and Fire District Weekly Check Registers (Excluding Checks Issued to Southern California Gas Company) in the Total Amount of $3,932,613.70 Dated July 25, 2022, Through August 07, 2022 and City and Fire District Electronic Debit Registers for the Month of July in the Total Amount of $15,928,152.04. (CITY/FIRE) D2. Consideration to Approve City and Fire District Weekly Check Registers for Checks Issued to Southern California Gas Company in the Total Amount of $17,436.16 Dated July 25, 2022, Through August 07, 2022. (CITY/FIRE)
D3. Consideration to Receive and File Current Investment Schedules as of July 31, 2022 for the City of Rancho Cucamonga and the Rancho Cucamonga Fire Protection District. (CITY/FIRE) D4. Consideration to Authorize Signature of the California Intergovernmental Risk Authority Agreement for Apportionment of Retirement Obligations. (FIRE) D5. Consideration of an Award to Vigilant Solutions for the Purchase of and an Appropriation in the Amount of $26,750 for the Subscription Renewal of the Camera License Keys (CLK) Fees Used at Each Automated License Plate Reader (ALPR) Location. (CITY) D6. Consideration of an Appropriation in the Amount of $386,300 for the Purchase of Fixed Position Automated License Plate Reader Cameras to be Installed at Three Intersections and to Purchase Additional Surveillance Cameras to Replace or be Added to the Public Service Video Network (PSVN) at the Cultural Center and at City Hall. (CITY) D7. Consideration of a Professional Service Agreement with Gentry General Engineering, Inc. for Removal of the Existing Horseshoe and Shuffleboard Courts and Construction of Pickleball Courts at Red Hill Community Park in an Amount Not to Exceed $109,362.00. (CITY) D8. Consideration to Award a Contract to Ace Electric, Inc. for the "Heritage and Etiwanda Creek Parks LED Sports Lighting Upgrade Project". (CITY)
D9. Consideration of a Contract with Tinker Glass Contractors, Inc. for the Emergency Installation of Ballistic Glass on the Plaza Level of the Rancho Cucamonga Police Facility in the Amount of $165,025. (CITY)
D10. Consideration to Award a Contract to Gentry General Engineering for the "Heritage Community Park Pedestrian Trail Renovation Project. (CITY)
D11. Consideration of a Contract with Crosstown Electric & Data, Inc. in the Amount of $608,683, Plus a 10% Contingency for the 2022 HSIP Traffic Signal Modification at Various Locations Project and an Appropriation from the Gas Tax Fund (Fund 174) in the Amount of $453,000 and from the Transportation Fund (124) in the Amount of $264,400. (CITY) D12. Consideration to Authorize Signature of the California Intergovernmental Risk Authority Agreement for Apportionment of Retirement Obligations. (CITY) D13. Consideration of Amendment No. 1 to the Professional Services Agreement with NEOGOV for Applicant Tracking Software in the Amount of $66,800. (CITY) D14. Consideration to Approve Second Amendment to the Integrated Solid Waste Management Agreement between the City of Rancho Cucamonga and Burrtec Waste Industries, Inc., to Incorporate Senate Bill 1383 Requirements. (CITY)
D15. Consideration of a Professional Services Agreement with Renne Public Policy Group for State Legislative Advocacy Services in the Annual Amount of $114,000 and Direct Staff to Adjust an Appropriation at MidYear. (CITY)
D16. Consideration to Accept the Traffic Signal Battery Backup Systems Replacement FY 2021 Project as Complete, file a Notice of Completion, and Authorize Release of Retention and Bonds. (CITY)
D17. Consideration of Resolutions Approving the Special Tax Levy for Community Facilities Districts Nos. 851 and 881 for Fiscal Year 2022/23. (RESOLUTION NO'S. FD2022024 AND FD2022025) (FIRE)
D18. Consideration of a Resolution Adopting the Measure “I” FiveYear Capital Improvement Plan Covering Fiscal Years 2022/2027. (RESOLUTION NO. 2022120) (CITY) E. CONSENT CALENDAR ORDINANCE(S) SECOND READING/ADOPTION F. ADMINISTRATIVE HEARING ITEM(S)
G. ADVERTISED PUBLIC HEARINGS ITEM(S) CITY/FIRE DISTRICT G1. Public Hearing to Consider a Resolution to Set Residential and Commercial Solid Waste Collection Rates Within the City of Rancho Cucamonga. (RESOLUTION NO. 2022121) (CITY) G2. Public Hearing for Consideration of First Reading of Ordinance No. 1008, to be Read by Title Only and Waive Further Reading, Amending Development Code Chapters 17.38 and Chapter 17.140 Establishing an Agricultural Overlay. This Project is Exempt from Environmental Review Pursuant to Section 15060 of the CEQA Guidelines. (ORDINANCE NO. 1008) (CITY) G3. Public Hearing for Consideration of First Reading of Ordinance No. 1009, to be Read by Title Only and Waive Further Reading, Amending Title 17 of the Municipal Code Permitting Electric Vehicle Sales and Service as a ByRight Use in the Mixed Employment 2 (ME2), Corridor 1 (CO1), Corridor 2 (CO2) and Center 2 (CE2) Zones and Amending the Land Use Definitions for Electric Vehicle Sales.

This Project is Exempt from Environmental Review Pursuant to Section 15161(b)(3) of the CEQA Guidelines. (ORDINANCE NO. 1009) (CITY)
H. CITY MANAGER'S STAFF REPORT(S)
H1. Consideration of Various Actions Related to the Acquisition of a New Financial Enterprise Resource Platform (ERP) System. (CITY/FIRE)
I. COUNCIL BUSINESS
I1. COUNCIL ANNOUNCEMENTS
(Comments to be limited to three minutes per Council Member.) I2. INTERAGENCY UPDATES
(Update by the City Council to the community on the meetings that were attended. ) J. CITY ATTORNEY ITEMS
K. IDENTIFICATION OF ITEMS FOR NEXT MEETING
L. ADJOURNMENT

CERTIFICATION
I, Linda A. Troyan, MMC, City Clerk Services Director of the City of Rancho Cucamonga, or my designee, hereby certify under penalty of perjury that a true, accurate copy of the foregoing agenda was posted on at least SeventyTwo (72) hours prior to the meeting per Government Code 54954.2 at 10500 Civic Center Drive, Rancho Cucamonga, California and on the City's website
LINDA A. TROYAN, MMC
CITY CLERK SERVICES DIRECTOR
If you need special assistance or accommodations to participate in this meeting, please contact the City Clerk's office at (909) 4772700. Notification of 48 hours prior to the meeting will enable the City to make reasonable arrangements to ensure accessibility. Listening devices are available for the hearing impaired.

CITY COUNCIL VISION STATEMENT
“Our Vision is to build on our success as a world class community, to create an equitable, sustainable, and vibrant city, rich in opportunity for all to

Page 1 ends

Mayor
L. Dennis Michael
Mayor Pro Tem
Lynne B. Kennedy
Members of the City
Council:

REGULAR MEETINGS COUNCIL CHAMBERS 7:00 P.M.

CLOSED SESSION – 4:30 P.M.

REGULAR MEETING – 7:00 P.M.

B2. Presentation Recognizing Jenifer Phillips, Deputy Director of Human Resources, for Being Featured as IPMAHR’s Member Spotlight for the Month of August.

Please refrain from any debate between audience and speaker, making loud noises, or engaging in any activity which might be disruptive to the decorum of the meeting.

CONSENT CALENDARS:

The following Consent Calendar items are expected to be routine and noncontroversial. They will be acted upon without discussion unless an item is removed by Council Member for discussion.

CITY COUNCIL VISION STATEMENT
“Our Vision is to build on our success as a world class community, to create an equitable, sustainable, and vibrant city, rich in opportunity for all to

Page 2 ends

Mayor
L. Dennis Michael
Mayor Pro Tem
Lynne B. Kennedy
Members of the City
Council:

REGULAR MEETINGS COUNCIL CHAMBERS 7:00 P.M.

CLOSED SESSION – 4:30 P.M.

REGULAR MEETING – 7:00 P.M.

B2. Presentation Recognizing Jenifer Phillips, Deputy Director of Human Resources, for Being Featured as IPMAHR’s Member Spotlight for the Month of August.

Please refrain from any debate between audience and speaker, making loud noises, or engaging in any activity which might be disruptive to the decorum of the meeting.

CONSENT CALENDARS:

The following Consent Calendar items are expected to be routine and noncontroversial. They will be acted upon without discussion unless an item is removed by Council Member for discussion.

CITY COUNCIL VISION STATEMENT
“Our Vision is to build on our success as a world class community, to create an equitable, sustainable, and vibrant city, rich in opportunity for all to

Page 3 ends

Mayor
L. Dennis Michael
Mayor Pro Tem
Lynne B. Kennedy
Members of the City
Council:

REGULAR MEETINGS COUNCIL CHAMBERS 7:00 P.M.

CLOSED SESSION – 4:30 P.M.

REGULAR MEETING – 7:00 P.M.

B2. Presentation Recognizing Jenifer Phillips, Deputy Director of Human Resources, for Being Featured as IPMAHR’s Member Spotlight for the Month of August.

Please refrain from any debate between audience and speaker, making loud noises, or engaging in any activity which might be disruptive to the decorum of the meeting.

CONSENT CALENDARS:

The following Consent Calendar items are expected to be routine and noncontroversial. They will be acted upon without discussion unless an item is removed by Council Member for discussion.

CITY COUNCIL VISION STATEMENT
“Our Vision is to build on our success as a world class community, to create an equitable, sustainable, and vibrant city, rich in opportunity for all to

Page 4 ends

Mayor
L. Dennis Michael
Mayor Pro Tem
Lynne B. Kennedy
Members of the City
Council:

REGULAR MEETINGS COUNCIL CHAMBERS 7:00 P.M.

CLOSED SESSION – 4:30 P.M.

REGULAR MEETING – 7:00 P.M.

B2. Presentation Recognizing Jenifer Phillips, Deputy Director of Human Resources, for Being Featured as IPMAHR’s Member Spotlight for the Month of August.

Please refrain from any debate between audience and speaker, making loud noises, or engaging in any activity which might be disruptive to the decorum of the meeting.

CONSENT CALENDARS:

The following Consent Calendar items are expected to be routine and noncontroversial. They will be acted upon without discussion unless an item is removed by Council Member for discussion.

CITY COUNCIL VISION STATEMENT
“Our Vision is to build on our success as a world class community, to create an equitable, sustainable, and vibrant city, rich in opportunity for all to

Page 5 ends

Mayor
L. Dennis Michael
Mayor Pro Tem
Lynne B. Kennedy
Members of the City
Council:

REGULAR MEETINGS COUNCIL CHAMBERS 7:00 P.M.

CLOSED SESSION – 4:30 P.M.

REGULAR MEETING – 7:00 P.M.

B2. Presentation Recognizing Jenifer Phillips, Deputy Director of Human Resources, for Being Featured as IPMAHR’s Member Spotlight for the Month of August.

Please refrain from any debate between audience and speaker, making loud noises, or engaging in any activity which might be disruptive to the decorum of the meeting.

CONSENT CALENDARS:

The following Consent Calendar items are expected to be routine and noncontroversial. They will be acted upon without discussion unless an item is removed by Council Member for discussion.

CITY COUNCIL VISION STATEMENT
“Our Vision is to build on our success as a world class community, to create an equitable, sustainable, and vibrant city, rich in opportunity for all to

Page 6 ends

DATE:August 17, 2022
TO:Mayor and Members of the City Council
President and Members of the Boards of Directors
FROM:John R. Gillison, City Manager
INITIATED BY: Tamara L. Oatman, Finance Director
Veronica Lopez, Accounts Payable Supervisor
SUBJECT: Consideration to Approve City and Fire District Bi-Weekly Payroll in the Total Amount of $1,880,259.00 and City and Fire District Weekly Check Registers (Excluding Checks Issued to Southern California Gas Company) in the Total Amount of $3,932,613.70 Dated July 25, 2022, Through August 07, 2022 and City and Fire District Electronic Debit Registers for the Month of July in the Total Amount of $15,928,152.04. (CITY/FIRE)
RECOMMENDATION:

Staff recommends City Council/Board of Directors of the Fire Protection District approve payment of demands as presented. Bi-weekly payroll is $1,078,586.46 and $801,672.54 for the City and the Fire District, respectively. Weekly check register amounts are $2,538,679.10 and $1,393,934.60 for the City and the Fire District, respectively. Electronic Debit Register amounts are $12,142,525.44 and $3,785,626.60 for the City and the Fire District, respectively.

BACKGROUND:

N/A
ANALYSIS:

N/A

FISCAL IMPACT:

Adequate budgeted funds are available for the payment of demands per the attached listing.

COUNCIL MISSION / VISION / GOAL(S) ADDRESSED:

N/A

ATTACHMENTS:

Attachment 1 - Weekly Check Register
Attachment 2 - Electronic Debit Register

Page 7 ends

Agenda Check Register

RANCHO CUCAMONGA FIRE PROTECTION DISTRICT
Excluding So Calif Gas Company.

AND

CITY OF RANCHO CUCAMONGA
7/25/2022 through 8/7/2022
Check No.

Check Date
Vendor Name
City Fire Amount
AP
00014586
07/25/2022

AHUMADA, ALEXANDER R

0.00 614.88 614.88
AP
00014587
07/25/2022

ALMAND, LLOYD

0.00 232.94 232.94
AP
00014588
07/25/2022

BANTAU, VICTORIA

0.00 456.06 456.06
AP
00014589
07/25/2022

BAZAL, SUSAN

0.00 232.94 232.94
AP
00014590
07/25/2022

BELL, MICHAEL L

0.00 1,577.74 1,577.74
AP
00014591
07/25/2022

BERRY, DAVID

0.00 614.88 614.88
AP
00014592
07/25/2022

BROCK, ROBIN

0.00 1,096.31 1,096.31
AP
00014593
07/25/2022

CAMPBELL, GERALD

0.00 456.06 456.06
AP
00014594
07/25/2022

CAMPBELL, STEVEN

0.00 614.88 614.88
AP
00014595
07/25/2022

CARNES, KENNETH

0.00 456.06 456.06
AP
00014596
07/25/2022

CLABBY, RICHARD

0.00 1,290.56 1,290.56
AP
00014597
07/25/2022

CLOUGHESY, DONALD R

0.00 2,095.76 2,095.76
AP
00014598
07/25/2022

CORCORAN, ROBERT ANTHONY

0.00 714.37 714.37
AP
00014599
07/25/2022

COSTELLO, DENNIS M

0.00 2,055.05 2,055.05
AP
00014600
07/25/2022

COX, KARL

0.00 614.88 614.88
AP
00014601
07/25/2022

CRANE, RALPH

0.00 614.88 614.88
AP
00014602
07/25/2022

CROSSLAND, WILBUR

0.00 456.06 456.06
AP
00014603
07/25/2022

CURATALO, JAMES

0.00 1,096.31 1,096.31
AP
00014604
07/25/2022

DAGUE, JAMES

0.00 1,080.65 1,080.65
AP
00014605
07/25/2022

DAVENPORT, JAY

0.00 2,055.05 2,055.05
AP
00014606
07/25/2022

DE ANTONIO, SUSAN

0.00 714.37 714.37
AP
00014607
07/25/2022

DEANS, JACKIE

0.00 232.94 232.94
AP
00014608
07/25/2022

DOMINICK, SAMUEL A

0.00 614.88 614.88
AP
00014609
07/25/2022

EAGLESON, MICHAEL

0.00 1,577.74 1,577.74
AP
00014610
07/25/2022

EGGERS, BOB

0.00 1,080.65 1,080.65
AP
00014611
07/25/2022

FEJERAN, TIM

0.00 1,722.43 1,722.43
AP
00014612
07/25/2022

FRITCHEY, JOHN D

0.00 456.06 456.06
AP
00014613
07/25/2022

HEYDE, DONALD

0.00 614.88 614.88
AP
00014614
07/25/2022

HOLT, DANNY G

0.00 1,263.04 1,263.04
AP
00014615
07/25/2022

INTERLICCHIA, ROSALYN

0.00 232.94 232.94
AP
00014616
07/25/2022

JERKINS, PATRICK

0.00 1,722.43 1,722.43
AP
00014617
07/25/2022

KILMER, STEPHEN

0.00 1,290.56 1,290.56
AP
00014618
07/25/2022

KIRKPATRICK, WILLIAM M

0.00 730.03 730.03
AP
00014619
07/25/2022

LANE, WILLIAM

0.00 614.88 614.88
AP
00014620
07/25/2022

LARKIN, DAVID W

0.00 1,290.56 1,290.56
AP
00014621
07/25/2022

LEE, ALLAN J

0.00 232.94 232.94
AP
00014622
07/25/2022

LENZE, PAUL E

0.00 614.88 614.88
AP
00014623
07/25/2022

LONCAR, PHILIP

0.00 1,546.42 1,546.42
AP
00014624
07/25/2022

LONGO, JOE

0.00 153.53 153.53
AP
00014625
07/25/2022

LUTTRULL, DARRELL

0.00 456.06 456.06
AP
00014626
07/25/2022

MACKALL, BEVERLY

0.00 153.53 153.53
AP
00014627
07/25/2022

MAYFIELD, RON

0.00 614.88 614.88
AP
00014628
07/25/2022

MCKEE, JOHN

0.00 614.88 614.88
AP
00014629
07/25/2022

MCNEIL, KENNETH

0.00 614.88 614.88
AP
00014630
07/25/2022
MICHAEL, L. DENNIS

0.00 614.88 614.88
AP
00014631
07/25/2022

MORGAN, BYRON

0.00 1,968.84 1,968.84
AP
00014632
07/25/2022

MYSKOW, DENNIS

0.00 1,290.56 1,290.56
09:30:55
08/08/2022
Current Date:

VLOPEZ - Veronica Lopez
Page:
1 Time:

CK_AGENDA_REG_PORTRAIT_CONSOLIDATED - CK: Agenda Check Register Portrait Layout User:

Report:

Page 8 ends

Agenda Check Register

RANCHO CUCAMONGA FIRE PROTECTION DISTRICT
Excluding So Calif Gas Company.

AND

CITY OF RANCHO CUCAMONGA
7/25/2022 through 8/7/2022
Check No.

Check Date
Vendor Name
City Fire Amount
AP
00014633
07/25/2022

NAUMAN, MICHAEL

0.00 456.06 456.06
AP
00014634
07/25/2022

NELSON, MARY JANE

0.00 153.53 153.53
AP
00014635
07/25/2022

NOREEN, ERIC

0.00 2,095.76 2,095.76
AP
00014636
07/25/2022

O'BRIEN, TOM

0.00 1,577.74 1,577.74
AP
00014637
07/25/2022

PLOUNG, MICHAEL J

0.00 614.88 614.88
AP
00014638
07/25/2022

POST, MICHAEL R

0.00 1,546.42 1,546.42
AP
00014639
07/25/2022

PROULX, PATRICK

0.00 1,096.31 1,096.31
AP
00014640
07/25/2022

REDMOND, MICHAEL

0.00 614.88 614.88
AP
00014641
07/25/2022

ROBERTS, BRENT

0.00 714.37 714.37
AP
00014642
07/25/2022

ROBERTS, CHERYL L

0.00 2,095.76 2,095.76
AP
00014643
07/25/2022

ROEDER, JEFFREY

0.00 1,577.74 1,577.74
AP
00014644
07/25/2022
ROJER, IVAN M.

0.00 1,722.43 1,722.43
AP
00014645
07/25/2022

SALISBURY, THOMAS

0.00 614.88 614.88
AP
00014646
07/25/2022

SMITH, RONALD

0.00 456.06 456.06
AP
00014647
07/25/2022

SORENSEN, SCOTT D

0.00 1,080.65 1,080.65
AP
00014648
07/25/2022

SPAIN, WILLIAM

0.00 456.06 456.06
AP
00014649
07/25/2022

SULLIVAN, JAMES

0.00 456.06 456.06
AP
00014650
07/25/2022

TAYLOR, STEVEN

0.00 1,878.66 1,878.66
AP
00014651
07/25/2022

TOLL, RICHARD

0.00 2,095.76 2,095.76
AP
00014652
07/25/2022

TULEY, TERRY

0.00 1,577.74 1,577.74
AP
00014653
07/25/2022

VANDERKALLEN, FRANCIS

0.00 614.88 614.88
AP
00014654
07/25/2022

VARNEY, ANTHONY

0.00 614.88 614.88
AP
00014655
07/25/2022

WALTON, KEVIN

0.00 1,722.43 1,722.43
AP
00014656
07/25/2022

YOWELL, TIMOTHY A

0.00 614.88 614.88
AP
00014659
07/27/2022

CALIF GOVERNMENT VEBA / RANCHO CUCAMONGA
24,358.63 0.00 24,358.63
AP
00014660
07/27/2022

COMPUTERSHARE TRUST COMPANY NA
1,500.00 0.00 1,500.00
AP
00014661
07/27/2022

CONFIRE JPA

0.00 215,478.20 215,478.20
AP
00014662
07/27/2022
RCCEA
1,436.50 0.00 1,436.50
AP
00014663
07/27/2022
RCPFA
12,665.51 0.00 12,665.51
AP
00014664
07/27/2022

AMG & ASSOCIATES INC

0.00 730,754.02 730,754.02
AP
00014665
07/27/2022

BUREAU VERITAS NORTH AMERICA INC
9,228.69 0.00 9,228.69
AP
00014666
07/27/2022

CCS ORANGE COUNTY JANITORIAL INC
8,566.34 0.00 8,566.34
AP
00014667
07/27/2022

CRAFCO INC
662.67 0.00 662.67
AP
00014668
07/27/2022

ELECNOR BELCO ELECTRIC INC
15,870.99 0.00 15,870.99
AP
00014669
07/27/2022

GRAYBAR ELECTRIC COMPANY INC
7,805.46 0.00 7,805.46
***
AP
00014670
07/27/2022

INTERWEST CONSULTING GROUP INC
43,026.45 12,852.72 55,879.17
***
AP
00014671
07/27/2022

RICHARDS WATSON & GERSHON
132,066.49 2,073.20 134,139.69
AP
00014673
08/03/2022

COMPUTERSHARE TRUST COMPANY NA
2,000.00 0.00 2,000.00
AP
00014674
08/03/2022

DELTA DENTAL OF CALIFORNIA
41,542.77 0.00 41,542.77
***
AP
00014675
08/03/2022
ESRI
122,040.00 27,960.00 150,000.00
AP
00014676
08/03/2022

HAMPTON YOGA
684.00 0.00 684.00
AP
00014677
08/03/2022

PROMOTIONS TEES & MORE
2,763.96 0.00 2,763.96
AP
00014678
08/03/2022

RIVERSIDE, CITY OF
4,500.00 0.00 4,500.00
AP
00014679
08/03/2022

US DEPARTMENT OF ENERGY
9,704.68 0.00 9,704.68
AP
00014680
08/03/2022
360 DEEP CLEANING LLC

0.00 7,150.00 7,150.00
AP
00014681
08/03/2022

CHAFFEY JOINT UNION HIGH SCHOOL DISTRICT
484.20 0.00 484.20
***
AP
00014682
08/03/2022

CRAYON SOFTWARE EXPERTS LLC
43,023.24 12,361.08 55,384.32
09:30:55
08/08/2022
Current Date:

VLOPEZ - Veronica Lopez
Page:
2 Time:

CK_AGENDA_REG_PORTRAIT_CONSOLIDATED - CK: Agenda Check Register Portrait Layout User:

Report:

Page 9 ends

Agenda Check Register

RANCHO CUCAMONGA FIRE PROTECTION DISTRICT
Excluding So Calif Gas Company.

AND

CITY OF RANCHO CUCAMONGA
7/25/2022 through 8/7/2022
Check No.

Check Date
Vendor Name
City Fire Amount
***
AP
00014683
08/03/2022

EMCOR SERVICES
95,325.28 7,176.00 102,501.28
AP
00014684
08/03/2022

FEHR & PEERS
1,222.23 0.00 1,222.23
AP
00014685
08/03/2022

RICHARDS WATSON & GERSHON
10,869.60 0.00 10,869.60
AP
00014686
08/03/2022

YUNEX LLC
1,553.00 0.00 1,553.00
AP
00425985
07/25/2022

MAGNUSON, PETER

0.00 2,144.67 2,144.67
AP
00425986
07/25/2022

RODRIGUEZ, VICTOR

0.00 614.88 614.88
AP
00425987
07/25/2022

SPAGNOLO, VIOLA

0.00 4.53 4.53
AP
00425988
07/25/2022

TOWNSEND, JAMES

0.00 2,095.76 2,095.76
AP
00425989
07/25/2022

WALKER, KENNETH

0.00 232.94 232.94
AP
00425990
07/27/2022

AFLAC GROUP INSURANCE

24.58 0.00 24.58
AP
00425991
07/27/2022

ALTA VISTA MOBILE HOME PARK
292.58 0.00 292.58
AP
00425992
07/27/2022

AT&T CALIFORNIA
342.00 0.00 342.00
AP
00425993
07/27/2022

AVID IDENTIFICATION SYSTEMS
388.02 0.00 388.02
AP
00425994
07/27/2022

BARBARA'S ANSWERING SERVICE
552.00 0.00 552.00
AP
00425995
07/27/2022

BRIGHTLY SOFTWARE INC
16,890.00 0.00 16,890.00
***
AP
00426002
07/27/2022

C V W D
82,496.45 7.38 82,503.83
AP
00426003
07/27/2022

CA LLC - ALTA LAGUNA MHP
400.00 0.00 400.00
AP
00426004
07/27/2022

CALIF INTERGOVERNMENTAL RISK AUTHORITY

0.00 186,467.63 186,467.63
AP
00426005
07/27/2022

CALIFORNIA, STATE OF

50.00 0.00 50.00
AP
00426006
07/27/2022

CALIFORNIA, STATE OF

50.00 0.00 50.00
AP
00426007
07/27/2022

CALIFORNIA, STATE OF
872.77 0.00 872.77
AP
00426008
07/27/2022

CALIFORNIA, STATE OF
342.73 0.00 342.73
AP
00426009
07/27/2022

CALIFORNIA, STATE OF

32.26 0.00 32.26
AP
00426010
07/27/2022

CASA VOLANTE MOBILE HOME PARK
1,200.00 0.00 1,200.00
AP
00426011
07/27/2022

CELLEBRITE INC
5,258.20 0.00 5,258.20
AP
00426012
07/27/2022

CHAPARRAL HEIGHTS MOBILE HOME PARK
300.00 0.00 300.00
AP
00426013
07/27/2022

DE GUZMAN, CLARENCE
135.00 0.00 135.00
AP
00426014
07/27/2022

DIRECTV

43.24 0.00 43.24
AP
00426015
07/27/2022

DIRECTV
200.48 0.00 200.48
AP
00426016
07/27/2022

EPPLEY, JOAN
103.00 0.00 103.00
AP
00426017
07/27/2022

FACTORY MOTOR PARTS

0.00 1,177.38 1,177.38
AP
00426018
07/27/2022

FRANKLIN TRUCK PARTS INC

0.00 3,025.80 3,025.80
AP
00426019
07/27/2022

GODINEZ, CESAR

13.52 0.00 13.52
AP
00426020
07/27/2022

GONSALVES & SON, JOE A
3,000.00 0.00 3,000.00
AP
00426021
07/27/2022

GROVES ON FOOTHILL, THE
200.00 0.00 200.00
AP
00426022
07/27/2022

HAPPYORNOT AMERICAS INC
8,351.43 0.00 8,351.43
AP
00426023
07/27/2022

HILL'S PET NUTRITION SALES INC
2,353.86 0.00 2,353.86
AP
00426024
07/27/2022

HOMETOWN AMERICA RAMONA VILLA
300.00 0.00 300.00
AP
00426025
07/27/2022

HSUEH, YU

81.55 0.00 81.55
AP
00426026
07/27/2022

IDEXX DISTRIBUTION INC

26.80 0.00 26.80
AP
00426027
07/27/2022
IE INC
384.37 0.00 384.37
AP
00426028
07/27/2022

IMAGINE COURT REPORTING
449.73 0.00 449.73
AP
00426029
07/27/2022

INTERVET INC
484.88 0.00 484.88
AP
00426030
07/27/2022

ISHERWOOD, LINDA

50.00 0.00 50.00
AP
00426031
07/27/2022

JOHNSON, CHEARICE
140.00 0.00 140.00
AP
00426032
07/27/2022

KANA PIPELINE INC
179.77 0.00 179.77
AP
00426033
07/27/2022

KWALL LLC
37,500.00 0.00 37,500.00
09:30:55
08/08/2022
Current Date:

VLOPEZ - Veronica Lopez
Page:
3 Time:

CK_AGENDA_REG_PORTRAIT_CONSOLIDATED - CK: Agenda Check Register Portrait Layout User:

Report:

Page 10 ends

Agenda Check Register

RANCHO CUCAMONGA FIRE PROTECTION DISTRICT
Excluding So Calif Gas Company.

AND

CITY OF RANCHO CUCAMONGA
7/25/2022 through 8/7/2022
Check No.

Check Date
Vendor Name
City Fire Amount
AP
00426034
07/27/2022
LEVEL 3 COMMUNICATIONS LLC
5,691.50 0.00 5,691.50
AP
00426035
07/27/2022

LU, ALAN

97.09 0.00 97.09
AP
00426036
07/27/2022

MC AVOY & MARKHAM
5,437.74 0.00 5,437.74
AP
00426037
07/27/2022

MI, NAN

5.89 0.00 5.89
AP
00426038
07/27/2022

MUNOZ, CLAUDIA L
300.00 0.00 300.00
AP
00426039
07/27/2022

NEWSBANK INC
9,305.00 0.00 9,305.00
AP
00426040
07/27/2022

OCCUPATIONAL HEALTH CENTERS OF CA

0.00 195.50 195.50
AP
00426041
07/27/2022

PACIFIC MH CONSTRUCTION INC
236.81 0.00 236.81
AP
00426042
07/27/2022

PERSONAL EXPOSURE REPORTING

0.00 920.00 920.00
AP
00426043
07/27/2022

PRE-PAID LEGAL SERVICES INC

53.36 0.00 53.36
AP
00426044
07/27/2022

PSA PRINT GROUP

38.79 0.00 38.79
AP
00426045
07/27/2022

SAN BERNARDINO COUNTY DEPT OF PUBLIC HEALTH

0.00 155.00 155.00
AP
00426046
07/27/2022

SAN BERNARDINO CTY AUDITOR CONTROLLER
24,469.21 0.00 24,469.21
AP
00426047
07/27/2022

SB COUNTY FIRE PREVENTION OFFICERS

0.00 180.00 180.00
AP
00426048
07/27/2022
SBPEA
2,249.49 0.00 2,249.49
AP
00426049
07/27/2022

SCHEU MANAGEMENT CORP
708.50 0.00 708.50
AP
00426050
07/27/2022

SHRED PROS

0.00 198.00 198.00
AP
00426051
07/27/2022

SOK, CHRISTINA
307.03 0.00 307.03
***
AP
00426058
07/27/2022

SOUTHERN CALIFORNIA EDISON
31,981.12 2,757.00 34,738.12
AP
00426059
07/27/2022

SYCAMORE VILLA MOBILE HOME PARK
300.00 0.00 300.00
AP
00426060
07/27/2022

COUNSELING TEAM INTERNATIONAL, THE

0.00 1,200.00 1,200.00
AP
00426061
07/27/2022

TRANSWEST TRUCK CENTER LLC

0.00 134.84 134.84
AP
00426062
07/27/2022
TUTOR.COM INC
20,000.00 0.00 20,000.00
AP
00426063
07/27/2022

UNITED WAY

45.00 0.00 45.00
AP
00426064
07/27/2022

UNITY COURIER SERVICE INC
1,450.15 0.00 1,450.15
AP
00426065
07/27/2022

VALLEY POWER SYSTEMS INC

0.00 1,326.69 1,326.69
AP
00426066
07/27/2022

VERONICA TAM & ASSOCIATES
7,748.50 0.00 7,748.50
AP
00426067
07/27/2022

VICTOR MEDICAL COMPANY

32.34 0.00 32.34
AP
00426068
07/27/2022

VIRGIN PULSE INC
1,135.20 0.00 1,135.20
AP
00426069
07/27/2022

VIRTUAL PROJECT MANAGER LLC
500.00 0.00 500.00
AP
00426070
07/27/2022

VOLGISTICS INC
8,184.00 0.00 8,184.00
AP
00426071
07/27/2022

WOLFE, SARAH

29.08 0.00 29.08
AP
00426072
07/27/2022

ABC LOCKSMITHS INC
1,485.03 0.00 1,485.03
AP
00426073
07/27/2022

ALL WELDING
1,221.00 0.00 1,221.00
AP
00426074
07/27/2022

AMTECH ELEVATOR SERVICES
1,973.70 0.00 1,973.70
AP
00426075
07/27/2022

ARCHIBALD PET HOSPITAL
600.00 0.00 600.00
AP
00426076
07/27/2022

ATLAS ENGINEERING WEST INC
1,457.50 0.00 1,457.50
AP
00426077
07/27/2022

BOUND TREE MEDICAL LLC

0.00 52.39 52.39
AP
00426078
07/27/2022

BROWN, STEVE

0.00 470.00 470.00
AP
00426079
07/27/2022

C V W D
247.34 0.00 247.34
AP
00426080
07/27/2022

C V W D
172.04 0.00 172.04
AP
00426081
07/27/2022

C V W D

0.00 135.71 135.71
AP
00426082
07/27/2022

CART RETRIEVAL INC
5,715.00 0.00 5,715.00
AP
00426083
07/27/2022

CITIZENS BUSINESS BANK

0.00 38,460.74 38,460.74
AP
00426084
07/27/2022

CONSERVE LANDCARE LLC
2,952.14 0.00 2,952.14
AP
00426085
07/27/2022

DEPARTMENT OF JUSTICE

0.00 277.00 277.00
AP
00426086
07/27/2022

DIVISION OF THE STATE ARCHITECT
1,168.70 0.00 1,168.70
09:30:55
08/08/2022
Current Date:

VLOPEZ - Veronica Lopez
Page:
4 Time:

CK_AGENDA_REG_PORTRAIT_CONSOLIDATED - CK: Agenda Check Register Portrait Layout User:

Report:

Page 11 ends

Agenda Check Register

RANCHO CUCAMONGA FIRE PROTECTION DISTRICT
Excluding So Calif Gas Company.

AND

CITY OF RANCHO CUCAMONGA
7/25/2022 through 8/7/2022
Check No.

Check Date
Vendor Name
City Fire Amount
AP
00426087
07/27/2022

DUNN EDWARDS CORPORATION
681.26 0.00 681.26
AP
00426088
07/27/2022

EWING IRRIGATION PRODUCTS INC
269.92 0.00 269.92
AP
00426090
07/27/2022

FORTIN LAW GROUP
11,533.35 0.00 11,533.35
AP
00426091
07/27/2022

FRONTIER COMM
4,001.75 0.00 4,001.75
AP
00426092
07/27/2022

G/M BUSINESS INTERIORS
474.78 0.00 474.78
AP
00426093
07/27/2022

GENTRY BROTHERS INC
209,589.95 0.00 209,589.95
AP
00426094
07/27/2022
GOVERNMENTJOBS.COM INC
6,387.31 0.00 6,387.31
AP
00426095
07/27/2022

GRAPHICS FACTORY PRINTING INC
1,810.20 0.00 1,810.20
AP
00426096
07/27/2022

HCI ENVIRONMENTAL & ENGINEERING SVC
4,825.73 0.00 4,825.73
AP
00426097
07/27/2022

HD PRODUCTIONS INC
18,750.00 0.00 18,750.00
AP
00426098
07/27/2022

HOLT, RYAN

0.00 320.00 320.00
AP
00426099
07/27/2022

INLAND OVERHEAD DOOR COMPANY

0.00 556.50 556.50
AP
00426100
07/27/2022

INTERNATIONAL LINE BUILDERS INC
17,471.87 0.00 17,471.87
AP
00426101
07/27/2022

JOUDEH, MAHMOUD
276.86 0.00 276.86
AP
00426102
07/27/2022

LIFE-ASSIST INC

0.00 3,050.84 3,050.84
AP
00426103
07/27/2022

LINCUS INC
5,320.00 0.00 5,320.00
AP
00426104
07/27/2022

LN CURTIS & SONS

0.00 1,392.09 1,392.09
***
AP
00426106
07/27/2022

LOWES COMPANIES INC
5,695.81 1,416.97 7,112.78
AP
00426107
07/27/2022

LOZANO SMITH LLP
3,832.50 0.00 3,832.50
AP
00426108
07/27/2022

MAGELLAN ADVISORS LLC
6,000.00 0.00 6,000.00
AP
00426109
07/27/2022

MAIN STREET SIGNS
4,450.08 0.00 4,450.08
AP
00426110
07/27/2022

MAY, SKYLA K
821.00 0.00 821.00
AP
00426111
07/27/2022

MCMASTER-CARR SUPPLY COMPANY

60.68 0.00 60.68
AP
00426112
07/27/2022

MEDIWASTE DISPOSAL

40.00 0.00 40.00
AP
00426113
07/27/2022

MIDWEST TAPE
605.67 0.00 605.67
AP
00426114
07/27/2022

MOE, JOHN
588.00 0.00 588.00
AP
00426115
07/27/2022

MUSIC STAR
166.80 0.00 166.80
AP
00426116
07/27/2022

MUSICLAND
980.00 0.00 980.00
AP
00426117
07/27/2022

NAPA AUTO PARTS

0.00 7.40 7.40
AP
00426118
07/27/2022

NATIONAL UTILITY LOCATORS LLC
960.00 0.00 960.00
AP
00426119
07/27/2022

NETOP TECH INC
180.00 0.00 180.00
AP
00426120
07/27/2022

NEXTECH SYSTEMS INC
31,678.05 0.00 31,678.05
AP
00426121
07/27/2022

NINYO & MOORE
8,947.00 0.00 8,947.00
AP
00426122
07/27/2022

NORTH NET FIRE TRAINING CENTER

0.00 4,000.00 4,000.00
***
AP
00426123
07/27/2022

OCCUPATIONAL HEALTH CENTERS OF CA
190.00 301.83 491.83
AP
00426124
07/27/2022

ODP BUSINESS SOLUTIONS LLC
1,202.72 0.00 1,202.72
AP
00426125
07/27/2022

ONTARIO SPAY & NEUTER INC
2,400.00 0.00 2,400.00
AP
00426126
07/27/2022

ONTARIO WINNELSON CO
333.85 0.00 333.85
AP
00426127
07/27/2022

ONYX ARCHITECTS INC
6,027.50 0.00 6,027.50
AP
00426128
07/27/2022

PACIFIC TRUCK EQUIPMENT
4,980.06 0.00 4,980.06
AP
00426129
07/27/2022
PARS
3,500.00 0.00 3,500.00
AP
00426130
07/27/2022

PH&S PRODUCTS LLC

0.00 3,277.67 3,277.67
AP
00426131
07/27/2022

PINNACLE PETROLEUM INC

0.00 4,006.76 4,006.76
AP
00426132
07/27/2022

QUINN COMPANY
1,230.83 0.00 1,230.83
AP
00426133
07/27/2022

RALPH ANDERSEN & ASSOCIATES
23,850.00 0.00 23,850.00
AP
00426134
07/27/2022

RANCHO MALL LLC
880.58 0.00 880.58
***
AP
00426135
07/27/2022

SAN BERNARDINO COUNTY
15,443.92 25,232.32 40,676.24
09:30:55
08/08/2022
Current Date:

VLOPEZ - Veronica Lopez
Page:
5 Time:

CK_AGENDA_REG_PORTRAIT_CONSOLIDATED - CK: Agenda Check Register Portrait Layout User:

Report:

Page 12 ends

Agenda Check Register

RANCHO CUCAMONGA FIRE PROTECTION DISTRICT
Excluding So Calif Gas Company.

AND

CITY OF RANCHO CUCAMONGA
7/25/2022 through 8/7/2022
Check No.

Check Date
Vendor Name
City Fire Amount
AP
00426136
07/27/2022

SAN BERNARDINO CTY SHERIFF'S DEPT

0.00 502.00 502.00
AP
00426137
07/27/2022

SCOTT MCLEOD PLUMBING INC
21,815.74 0.00 21,815.74
AP
00426138
07/27/2022

SIEMENS INDUSTRY INC
44,988.00 0.00 44,988.00
AP
00426139
07/27/2022

SILVER & WRIGHT LLP
18,264.28 0.00 18,264.28
AP
00426140
07/27/2022

SITEONE LANDSCAPE SUPPLY LLC
2,186.86 0.00 2,186.86
***
AP
00426142
07/27/2022

SOUTHERN CALIFORNIA NEWS GROUP
16,551.32 599.53 17,150.85
AP
00426143
07/27/2022

TRANSTECH ENGINEERS INC
1,357.50 0.00 1,357.50
AP
00426144
07/27/2022

TROYAN, LINDA A

64.00 0.00 64.00
AP
00426145
07/27/2022
ULINE
1,013.57 0.00 1,013.57
AP
00426146
07/27/2022

UNDERGROUND SVC ALERT OF SO CAL
158.50 0.00 158.50
AP
00426147
07/27/2022

VALLEY POWER SYSTEMS INC

0.00 3.67 3.67
AP
00426148
07/27/2022

VERIZON

30.36 0.00 30.36
AP
00426149
07/27/2022

VERIZON BUSINESS

42.59 0.00 42.59
AP
00426150
07/27/2022

VERIZON WIRELESS - LA
5,745.88 0.00 5,745.88
AP
00426151
07/27/2022

VIRGIN PULSE INC

49.95 0.00 49.95
AP
00426152
07/27/2022

VIRTUAL PROJECT MANAGER LLC
1,000.00 0.00 1,000.00
AP
00426153
07/27/2022

VORTEX INDUSTRIES LLC
1,000.00 0.00 1,000.00
AP
00426154
07/27/2022

WALTERS WHOLESALE ELECTRIC CO
30,074.09 0.00 30,074.09
AP
00426155
07/27/2022

WAXIE SANITARY SUPPLY
5,085.84 0.00 5,085.84
AP
00426156
07/27/2022

WEST COAST ARBORISTS INC
79,951.40 0.00 79,951.40
AP
00426157
07/27/2022

WEST COAST ARBORISTS INC
6,000.00 0.00 6,000.00
AP
00426158
08/03/2022

LIU, GAILING
10,000.00 0.00 10,000.00
AP
00426159
08/03/2022

MHR INVESTMENTS INC
20,000.00 0.00 20,000.00
***
AP
00426160
08/03/2022

CALIF INTERGOVERNMENTAL RISK AUTHORITY
1,689.48 484.78 2,174.26
AP
00426161
08/03/2022
CalPERS LONG-TERM CARE PROGRAM
177.08 0.00 177.08
AP
00426162
08/03/2022

CARQUEST AUTO PARTS
946.38 0.00 946.38
AP
00426163
08/03/2022

CERTIFIED TOWING INC
150.00 0.00 150.00
AP
00426164
08/03/2022

CHAMPION AWARDS & SPECIALTIES

43.10 0.00 43.10
***
AP
00426165
08/03/2022

CHARTER COMMUNICATIONS
4,689.28 6,460.22 11,149.50
AP
00426166
08/03/2022
CINTAS CORPORATION #150
940.99 0.00 940.99
AP
00426167
08/03/2022

CITRUS MOTORS ONTARIO INC
694.23 0.00 694.23
AP
00426168
08/03/2022

CITY CLERKS ASSOCIATION OF CALIF

50.00 0.00 50.00
AP
00426169
08/03/2022

CITY TOOL WORKS INC
19,355.13 0.00 19,355.13
AP
00426170
08/03/2022

COUNSELING TEAM INTERNATIONAL, THE

0.00 300.00 300.00
AP
00426171
08/03/2022

CREATIVE BRAIN LEARNING LLC
357.60 0.00 357.60
AP
00426172
08/03/2022

DOG WASTE DEPOT
3,894.95 0.00 3,894.95
AP
00426173
08/03/2022

EWING IRRIGATION PRODUCTS INC
157.46 0.00 157.46
AP
00426174
08/03/2022

FEDERAL EXPRESS CORP
333.41 0.00 333.41
***
AP
00426175
08/03/2022

FRONTIER COMM
1,915.42 418.79 2,334.21
AP
00426176
08/03/2022

G/M BUSINESS INTERIORS
11,561.56 0.00 11,561.56
AP
00426177
08/03/2022

GILLISON, JOHN
853.37 0.00 853.37
***
AP
00426178
08/03/2022

GRAINGER
243.10 158.68 401.78
AP
00426179
08/03/2022

HAMILTON, MONIQUE
256.80 0.00 256.80
AP
00426180
08/03/2022

IMAGINE COURT REPORTING
149.25 0.00 149.25
AP
00426181
08/03/2022

INLAND DESERT SECURITY & COMMUNICATIONS INC
129.95 0.00 129.95
AP
00426182
08/03/2022

INLAND LIBRARY SYSTEM
1,926.00 0.00 1,926.00
AP
00426183
08/03/2022

K-K WOODWORKING

96.88 0.00 96.88
09:30:55
08/08/2022
Current Date:

VLOPEZ - Veronica Lopez
Page:
6 Time:

CK_AGENDA_REG_PORTRAIT_CONSOLIDATED - CK: Agenda Check Register Portrait Layout User:

Report:

Page 13 ends

Agenda Check Register

RANCHO CUCAMONGA FIRE PROTECTION DISTRICT
Excluding So Calif Gas Company.

AND

CITY OF RANCHO CUCAMONGA
7/25/2022 through 8/7/2022
Check No.

Check Date
Vendor Name
City Fire Amount
AP
00426184
08/03/2022

KAISER FOUNDATION HEALTH PLAN INC
247,930.61 0.00 247,930.61
AP
00426185
08/03/2022

KEITH, JORRY
1,231.80 0.00 1,231.80
AP
00426186
08/03/2022

KME FIRE APPARATUS

0.00 797.35 797.35
AP
00426187
08/03/2022

LANTAI, KRIS
200.00 0.00 200.00
AP
00426188
08/03/2022

LAWDIS, STEVE
158.75 0.00 158.75
AP
00426189
08/03/2022

MCFADDEN-DALE HARDWARE

51.50 0.00 51.50
AP
00426190
08/03/2022

MEDRANO, CELESTE

46.84 0.00 46.84
AP
00426191
08/03/2022

MOISA, DANIEL A
342.00 0.00 342.00
AP
00426192
08/03/2022

MYERS TIRE SUPPLY COMPANY
349.49 0.00 349.49
AP
00426193
08/03/2022

NAGHSHINEH, MORVARID

68.10 0.00 68.10
***
AP
00426194
08/03/2022

NAPA AUTO PARTS
209.27 1,233.21 1,442.48
AP
00426195
08/03/2022

NATIONAL LEAGUE OF CITIES
11,426.00 0.00 11,426.00
AP
00426196
08/03/2022

ODP BUSINESS SOLUTIONS LLC
1,612.84 0.00 1,612.84
AP
00426197
08/03/2022

OTT, SHARON
430.80 0.00 430.80
AP
00426198
08/03/2022
PARMA
150.00 0.00 150.00
***
AP
00426199
08/03/2022

PSA PRINT GROUP
1,646.17 38.79 1,684.96
AP
00426200
08/03/2022

QUADIENT INC
713.03 0.00 713.03
AP
00426201
08/03/2022

RANCHO SMOG CENTER

44.95 0.00 44.95
AP
00426202
08/03/2022

SAN BERNARDINO CO FIRE PROTECTION DIST
65,634.52 0.00 65,634.52
AP
00426203
08/03/2022

SAN BERNARDINO COUNTY DEPT OF PUBLIC HEALTH

0.00 775.00 775.00
AP
00426204
08/03/2022

SIRSI CORPORATION
54,735.24 0.00 54,735.24
AP
00426205
08/03/2022

SITEONE LANDSCAPE SUPPLY LLC
14,937.52 0.00 14,937.52
AP
00426207
08/03/2022

SOUTH COAST AQMD
620.61 0.00 620.61
***
AP
00426209
08/03/2022

SOUTHERN CALIFORNIA EDISON
3,078.25 186.79 3,265.04
AP
00426210
08/03/2022

SOUTHERN CALIFORNIA EDISON

53.74 0.00 53.74
AP
00426211
08/03/2022

STANDARD INSURANCE COMPANY
12,216.33 0.00 12,216.33
AP
00426212
08/03/2022

STANDARD INSURANCE COMPANY
2,196.70 0.00 2,196.70
AP
00426213
08/03/2022

STOTZ EQUIPMENT
444.81 0.00 444.81
AP
00426214
08/03/2022

SUNRISE FORD
375.52 0.00 375.52
AP
00426215
08/03/2022

SYCAMORE VILLA MOBILE HOME PARK
600.00 0.00 600.00
AP
00426216
08/03/2022

THOMPSON, SANDRA
500.00 0.00 500.00
AP
00426217
08/03/2022

TIREHUB LLC
1,952.28 0.00 1,952.28
AP
00426218
08/03/2022
U.S. BANK PARS ACCT #6746022500
18,811.91 0.00 18,811.91
AP
00426219
08/03/2022
U.S. BANK PARS ACCT #6746022500
1,253.31 0.00 1,253.31
AP
00426220
08/03/2022

UCR FORECASTING LLC
5,000.00 0.00 5,000.00
AP
00426221
08/03/2022
UPS

89.97 0.00 89.97
AP
00426222
08/03/2022

VENTEK INTERNATIONAL
2,070.00 0.00 2,070.00
AP
00426223
08/03/2022

VERIZON WIRELESS - LA
262.74 0.00 262.74
AP
00426224
08/03/2022

VERIZON WIRELESS - LA
6,230.55 0.00 6,230.55
AP
00426225
08/03/2022

VICTOR MEDICAL COMPANY
526.39 0.00 526.39
AP
00426226
08/03/2022

VULCAN MATERIALS COMPANY
990.32 0.00 990.32
AP
00426227
08/03/2022

WAXIE SANITARY SUPPLY
7,098.26 0.00 7,098.26
AP
00426228
08/03/2022

WILSON, RYAN
145.01 0.00 145.01
AP
00426229
08/03/2022

XEROX FINANCIAL SERVICES
298.38 0.00 298.38
AP
00426230
08/03/2022

YERO, ART
145.00 0.00 145.00
AP
00426231
08/03/2022

ABC LOCKSMITHS INC

0.00 1,450.29 1,450.29
AP
00426232
08/03/2022

ABLE BUILDING MAINTENANCE
2,209.15 0.00 2,209.15
09:30:55
08/08/2022
Current Date:

VLOPEZ - Veronica Lopez
Page:
7 Time:

CK_AGENDA_REG_PORTRAIT_CONSOLIDATED - CK: Agenda Check Register Portrait Layout User:

Report:

Page 14 ends

Agenda Check Register

RANCHO CUCAMONGA FIRE PROTECTION DISTRICT
Excluding So Calif Gas Company.

AND

CITY OF RANCHO CUCAMONGA
7/25/2022 through 8/7/2022
Check No.

Check Date
Vendor Name
City Fire Amount
AP
00426233
08/03/2022

ADVANCED CHEMICAL TRANSPORT INC
2,026.50 0.00 2,026.50
AP
00426234
08/03/2022

AIRGAS USA LLC
3,879.00 0.00 3,879.00
AP
00426235
08/03/2022

ALTA LOMA ENTERTAINMENT CORPS
500.00 0.00 500.00
AP
00426236
08/03/2022

BABCOCK LABORATORIES INC
717.12 0.00 717.12
AP
00426237
08/03/2022

BASTIAN, DAVID

0.00 320.00 320.00
AP
00426238
08/03/2022

BERN MARIE'S PROMOTIONAL PRODUCTS
1,159.70 0.00 1,159.70
AP
00426239
08/03/2022

BRAUN BLAISING SMITH WYNNE
275.81 0.00 275.81
AP
00426240
08/03/2022

BRIGHTVIEW LANDSCAPE SERVICES INC
8,116.68 0.00 8,116.68
AP
00426241
08/03/2022

C V W D

0.00 470.47 470.47
AP
00426242
08/03/2022

C V W D
15,185.82 0.00 15,185.82
AP
00426243
08/03/2022

C V W D
4,363.08 0.00 4,363.08
AP
00426244
08/03/2022

CODE RED HEADSETS
840.84 0.00 840.84
AP
00426245
08/03/2022

COUNTS UNLIMITED
320.00 0.00 320.00
AP
00426246
08/03/2022

DATA ARC LLC
5,642.44 0.00 5,642.44
AP
00426247
08/03/2022

DATA TICKET INC
6,701.59 0.00 6,701.59
AP
00426248
08/03/2022

DUNN EDWARDS CORPORATION
272.90 0.00 272.90
AP
00426249
08/03/2022

FIALLOS, WILSON
2,592.00 0.00 2,592.00
AP
00426250
08/03/2022

G/M BUSINESS INTERIORS
1,711.10 0.00 1,711.10
AP
00426251
08/03/2022

GLOBALSTAR USA
173.48 0.00 173.48
AP
00426252
08/03/2022

GRAYBAR ELECTRIC COMPANY INC
25,605.51 0.00 25,605.51
AP
00426253
08/03/2022

HAULAWAY STORAGE CONTAINERS INC
119.84 0.00 119.84
AP
00426254
08/03/2022

HODNICK, CHRISTOPHER

69.00 0.00 69.00
AP
00426255
08/03/2022

HOSE-MAN INC
1,035.97 0.00 1,035.97
AP
00426256
08/03/2022

HR GREEN PACIFIC INC
14,190.00 0.00 14,190.00
AP
00426257
08/03/2022

IML SECURITY SUPPLY
191.96 0.00 191.96
AP
00426258
08/03/2022

ITRON INC
8,455.84 0.00 8,455.84
AP
00426259
08/03/2022

KEYSER MARSTON ASSOCIATES INC
9,412.50 0.00 9,412.50
AP
00426260
08/03/2022

LANDSCAPE WEST MANAGEMENT SERVICES INC
111,453.29 0.00 111,453.29
***
AP
00426261
08/03/2022

LIEBERT CASSIDY WHITMORE
3,749.50 162.50 3,912.00
AP
00426262
08/03/2022

LINSCOTT LAW & GREENSPAN ENGINEERS
27,514.00 0.00 27,514.00
AP
00426263
08/03/2022

MANVILLE, JOSHUA
1,000.00 0.00 1,000.00
***
AP
00426264
08/03/2022

MARIPOSA LANDSCAPES INC
53,597.03 2,503.22 56,100.25
AP
00426265
08/03/2022

MCMASTER-CARR SUPPLY COMPANY
1,958.77 0.00 1,958.77
AP
00426266
08/03/2022

MIDWEST TAPE

87.19 0.00 87.19
AP
00426267
08/03/2022

MILES, JOSEPHINE
159.12 0.00 159.12
AP
00426268
08/03/2022

MINUTEMAN PRESS
563.16 0.00 563.16
AP
00426269
08/03/2022

NAPA AUTO PARTS
431.62 0.00 431.62
AP
00426270
08/03/2022

NAULLS, BRANDY
131.00 0.00 131.00
AP
00426271
08/03/2022

ODP BUSINESS SOLUTIONS LLC
2,812.24 0.00 2,812.24
AP
00426272
08/03/2022

ORTEGA, ILENE
426.10 0.00 426.10
AP
00426273
08/03/2022

PACIFIC TRUCK EQUIPMENT
10,251.90 0.00 10,251.90
AP
00426274
08/03/2022

PACIFIC UTILITY INSTALLATION INC
6,927.00 0.00 6,927.00
AP
00426275
08/03/2022

POPE, MICHAEL
257.24 0.00 257.24
AP
00426276
08/03/2022

RAPID DIESEL REPAIR LLC
1,286.15 0.00 1,286.15
AP
00426277
08/03/2022

RBM LOCK & KEY SERVICE
161.63 0.00 161.63
AP
00426278
08/03/2022

SAFELITE FULFILLMENT INC
173.99 0.00 173.99
AP
00426279
08/03/2022

SCOTT MCLEOD PLUMBING INC
4,958.08 0.00 4,958.08
09:30:55
08/08/2022
Current Date:

VLOPEZ - Veronica Lopez
Page:
8 Time:

CK_AGENDA_REG_PORTRAIT_CONSOLIDATED - CK: Agenda Check Register Portrait Layout User:

Report:

Page 15 ends

Agenda Check Register

RANCHO CUCAMONGA FIRE PROTECTION DISTRICT
Excluding So Calif Gas Company.

AND

CITY OF RANCHO CUCAMONGA
7/25/2022 through 8/7/2022
Check No.

Check Date
Vendor Name
City Fire Amount
AP
00426280
08/03/2022

SDI PRESENCE LLC
32,560.00 0.00 32,560.00
AP
00426281
08/03/2022

SHEAKLEY PENSION ADMINISTRATION
354.70 0.00 354.70
AP
00426282
08/03/2022

SHEAKLEY PENSION ADMINISTRATION

0.00 178.15 178.15
AP
00426284
08/03/2022

SOCIAL VOCATIONAL SERVICES
1,350.00 0.00 1,350.00
AP
00426285
08/03/2022

SUNRISE FORD
1,246.64 0.00 1,246.64
AP
00426286
08/03/2022

THOMSON REUTERS - WEST
365.00 0.00 365.00
AP
00426287
08/03/2022

VERIZON WIRELESS - LA

0.00 6,961.40 6,961.40
AP
00426288
08/03/2022

VETS CHOICE RADIOLOGY
109.00 0.00 109.00
AP
00426289
08/03/2022

WAXIE SANITARY SUPPLY
438.56 0.00 438.56
***
AP
00426293
08/04/2022

C V W D
75,591.36 418.51 76,009.87
$2,538,679.10
$3,932,613.70
$1,393,934.60
Note:

Grand Total:

Total Fire:

Total City:
*** Check Number includes both City and Fire District expenditures 09:30:55
08/08/2022
Current Date:

VLOPEZ - Veronica Lopez
Page:
9 Time:

CK_AGENDA_REG_PORTRAIT_CONSOLIDATED - CK: Agenda Check Register Portrait Layout User:

Report:

Page 16 ends

DATE DESCRIPTION CITY FIRE AMOUNT
7/5 Bank Fee 95.05 95.05
7/5 WIRE PAYMENT - RCMU CAISO 41,543.44 41,543.44 7/5 Workers Comp - City Account Transfer 21.07 21.07 7/5 Workers Comp - Fire Account Transfer 370.14 370.14 7/6 Workers Comp - Fire Account Transfer 623.70 623.70 7/6 U.S. BANK - Purchasing Card, Corporate Card and Costco Card Payment 135,144.87 49,234.02 184,378.89 7/7 Workers Comp - City Account Transfer 203.29 203.29 7/8 Workers Comp - City Account Transfer 991.67 991.67 7/11 WIRE PAYMENT - RCMU CAISO 32,302.75 32,302.75 7/11 Workers Comp - City Account Transfer 244.10 244.10 7/11 Workers Comp - Fire Account Transfer 5,072.80 5,072.80 7/12 Workers Comp - City Account Transfer 60.49 60.49 7/12 Workers Comp - Fire Account Transfer 2,771.18 2,771.18 7/13 Workers Comp - Fire Account Transfer 565.07 565.07 7/14 STATE DISBURSEMENT UNIT - Child Support Payments 3,534.45 3,534.45 7/14 STATE DISBURSEMENT UNIT - Child Support Payments 1,584.50 1,584.50 7/14 Workers Comp - Fire Account Transfer 6,794.24 6,794.24 7/15 CALPERS - City - Retirement Account Deposit 2,199.60 2,199.60 7/15 CALPERS - City - Retirement Account Deposit 8,591.60 8,591.60 7/15 CALPERS - City - Retirement Account Deposit 9,216.70 9,216.70 7/15 CALPERS - Fire - Retirement Account Deposit 197.40 197.40 7/15 CALPERS - Fire - Retirement Account Deposit 338.40 338.40 7/15 CALPERS - Fire - Retirement Account Deposit 394.80 394.80 7/15 CALPERS - Fire - Retirement Account Deposit 723.80 723.80 7/15 CALPERS - Fire - Retirement Account Deposit 2,006.90 2,006.90 7/15 CALPERS - Fire - Retirement Account Deposit 3,102.00 3,102.00 7/15 CALPERS - City - Retirement Account Deposit 65,635.61 65,635.61 7/15 CALPERS - City - Retirement Account Deposit 100,931.73 100,931.73 7/15 CALPERS - Fire - Retirement Account Deposit 2,760.11 2,760.11 7/15 CALPERS - Fire - Retirement Account Deposit 3,492.15 3,492.15 7/15 CALPERS - Fire - Retirement Account Deposit 5,151.89 5,151.89 7/15 CALPERS - Fire - Retirement Account Deposit 10,234.71 10,234.71 7/15 CALPERS - Fire - Retirement Account Deposit 36,121.61 36,121.61 7/15 CALPERS - Fire - Retirement Account Deposit 95,662.15 95,662.15 7/15 Workers Comp - Fire Account Transfer 301.62 301.62 7/18 WIRE PAYMENT - RCMU CAISO 41,634.53 41,634.53 7/18 Workers Comp - City Account Transfer 1,109.04 1,109.04 7/19 CALPERS - City - Retirement Account Deposit 4,866,642.00 4,866,642.00 7/19 CALPERS - Fire - Retirement Account Deposit 3,942.00 3,942.00 7/19 CALPERS - Fire - Retirement Account Deposit 6,053.00 6,053.00 7/19 CALPERS - Fire - Retirement Account Deposit 9,161.00 9,161.00 7/19 CALPERS - Fire - Retirement Account Deposit 20,548.00 20,548.00 7/19 CALPERS - Fire - Retirement Account Deposit 255,666.00 255,666.00 7/19 CALPERS - Fire - Retirement Account Deposit 2,895,177.00 2,895,177.00 7/19 Workers Comp - Fire Account Transfer 193.05 193.05 7/20 CALPERS - Fire - Retirement Account Deposit 182,681.87 182,681.87 7/20 CALPERS - Fire - Retirement Account Deposit 233.81 233.81 7/20 CALPERS - Fire - Retirement Account Deposit 1,340.19 1,340.19 7/20 CALPERS - Fire - Retirement Account Deposit 2,027.80 2,027.80 7/20 CALPERS - Fire - Retirement Account Deposit 10,702.54 10,702.54 7/20 Workers Comp - City Account Transfer 5,372.57 5,372.57 7/20 Workers Comp - Fire Account Transfer 1,256.23 1,256.23 7/21 Workers Comp - City Account Transfer 149.00 149.00 7/21 Workers Comp - Fire Account Transfer 2,344.08 2,344.08 7/22 Workers Comp - Fire Account Transfer 3,882.16 3,882.16 7/25 WIRE PAYMENT - RCMU CAISO 136,360.37 136,360.37 7/25 Workers Comp - Fire Account Transfer 917.25 917.25 7/26 WIRE PAYMENT - PROPERTY PURCHASE 6,503,370.52 6,503,370.52 7/26 Workers Comp - Fire Account Transfer 91.91 91.91 CITY OF RANCHO CUCAMONGA
AND
RANCHO CUCAMONGA FIRE PROTECTION DISTRICT
Electronic Debit Register
JULY 1, 2022 TO JULY 31, 2022
1

Page 17 ends

DATE DESCRIPTION CITY FIRE AMOUNT
CITY OF RANCHO CUCAMONGA
AND
RANCHO CUCAMONGA FIRE PROTECTION DISTRICT
Electronic Debit Register
JULY 1, 2022 TO JULY 31, 2022
7/27 CALPERS - City - Retirement Account Deposit 66,752.35 66,752.35 7/27 CALPERS - City - Retirement Account Deposit 101,381.03 101,381.03 7/27 Workers Comp - City Account Transfer 738.51 738.51 7/28 CALPERS - Fire - Retirement Account Deposit 2,788.67 2,788.67 7/28 CALPERS - Fire - Retirement Account Deposit 3,492.17 3,492.17 7/28 CALPERS - Fire - Retirement Account Deposit 5,105.25 5,105.25 7/28 CALPERS - Fire - Retirement Account Deposit 10,549.43 10,549.43 7/28 CALPERS - Fire - Retirement Account Deposit 37,196.71 37,196.71 7/28 CALPERS - Fire - Retirement Account Deposit 97,288.89 97,288.89 7/28 STATE DISBURSEMENT UNIT - Child Support Payments 3,534.45 3,534.45 7/28 STATE DISBURSEMENT UNIT - Child Support Payments 1,270.50 1,270.50 7/29 Workers Comp - City Account Transfer 18,978.55 18,978.55 TOTAL CITY 12,142,525.44
TOTAL FIRE 3,785,626.60
GRAND TOTAL 15,928,152.04
2

Page 18 ends

Staff recommends City Council/Board of Directors of the Fire Protection District approve payment of demands as presented. Weekly check register amounts are $16,497.42 and $938.74 for the City and the Fire District, respectively.

BACKGROUND:

N/A

ANALYSIS:

N/A

FISCAL IMPACT:

Adequate budgeted funds are available for the payment of demands per the attached listing.

COUNCIL MISSION / VISION / GOAL(S) ADDRESSED:

N/A

ATTACHMENTS:

Attachment 1 - Weekly Check Register

Page 19 ends

Agenda Check Register

RANCHO CUCAMONGA FIRE PROTECTION DISTRICT
So Calif Gas Company Only.

AND

CITY OF RANCHO CUCAMONGA
7/25/2022 through 8/7/2022
Check No.

Check Date
Vendor Name
City Fire Amount
AP
00426141
07/27/2022

SO CALIF GAS COMPANY
1,621.96 0.00 1,621.96
***
AP
00426206
08/03/2022

SO CALIF GAS COMPANY
14,860.67 486.12 15,346.79
***
AP
00426283
08/03/2022

SO CALIF GAS COMPANY

14.79 452.62 467.41
$16,497.42
$17,436.16
$938.74
Note:

Grand Total:

Total Fire:

Total City:
*** Check Number includes both City and Fire District expenditures 11:02:59
08/08/2022
Current Date:

VLOPEZ - Veronica Lopez
Page:
1 Time:

CK_AGENDA_REG_PORTRAIT_CONSOLIDATED - CK: Agenda Check Register Portrait Layout User:

Report:

Page 20 ends

DATE:August 17, 2022
TO:Mayor and Members of the City Council
President and Members of the Board of Directors
FROM:John R. Gillison, City Manager
INITIATED BY: Elisa Cox, Assistant City Manager
Tamara L. Oatman, Finance Director
Jason A. Shields, Management Analyst II

SUBJECT: Consideration to Receive and File Current Investment Schedules as of July 31, 2022 for the City of Rancho Cucamonga and the Rancho Cucamonga Fire Protection District. (CITY/FIRE)
RECOMMENDATION:

Staff recommends the City Council/Board of Directors of the Fire Protection District receive and file the attached current investment schedules for the City of Rancho Cucamonga (City) and the Rancho Cucamonga Fire Protection District (District) as of July 31, 2022.

BACKGROUND:

The attached investment schedules as of July 31, 2022, reflect cash and investments managed by the Finance Department/Revenue Management Division and are in conformity with the requirements of California Government Code Section 53601 and the City of Rancho Cucamonga’s and the Rancho Cucamonga Fire Protection District’s adopted Investment Policies as approved on June 16, 2022.

ANALYSIS:

The City’s and District’s Treasurers are each required to submit a quarterly investment report to the City Council and the Fire Board, respectively, in accordance with California Government Code Section 53646. The quarterly investment report is required to be submitted within 30 days following the end of the quarter covered by the report. However, the City and District Treasurers have each elected to provide this report on a monthly basis.

FISCAL IMPACT:

None.

COUNCIL MISSION / VISION / GOAL(S) ADDRESSED:

The monthly investment schedule supports the City Council’s core value of providing and nurturing a high quality of life for all by demonstrating the active, prudent fiscal management of the City’s investment portfolio to ensure that financial resources are available to support the various services the city provides to all Rancho Cucamonga stakeholders.

ATTACHMENTS:

Attachment 1 - Investment Schedule (City)
Attachment 2 - Investment Schedule (Fire)

Page 21 ends

Page 22 ends

For the Month Ending July 31, 2022
Account Statement
Consolidated Summary Statement

CITY OF RANCHO CUCAMONGA
Investment Allocation
Investment Type Closing Market Value Percent
11,040,053.80 2.92 Asset-Backed Security
36,647,682.60 9.71 Federal Agency Bond / Note
56,803,260.53 15.05 Corporate Note
2,975,766.88 0.79 Certificate of Deposit
1,171,120.84 0.31 Certificate of Deposit - FDIC Insured 989,985.00 0.26 Municipal Bond / Note
6,375,675.68 1.69 Supra-National Agency Bond / Note
197,564,136.68 52.32 U.S. Treasury Bond / Note
62,816,760.11 16.64 Local Agency Investment Fund
1,154,979.28 0.31 Passbook/Checking Accounts
$377,539,421.40 Total 100.00%
Portfolio Summary
and Income
Closing
Market ValuePortfolio Holdings
Cash Dividends
PFMAM Managed Account 77,101.29 313,567,682.01
Local Agency Investment Fund 0.00 62,816,760.11
Passbook/Checking Accounts 0.00 1,154,979.28
$77,101.29 $377,539,421.40 Total
Maturity Distribution (Fixed Income Holdings)
Portfolio Holdings Closing Market Value Percent
64,471,739.39

0.00 0.00

0.00 33,453,100.47
82,469,430.41
72,255,570.90
73,811,505.26
51,078,074.97

0.00 17.08

0.00 0.00

0.00 8.86

21.84 19.14

19.55 13.53

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 $377,539,421.40
783
100.00%
Weighted Average Days to Maturity
Sector Allocation

2.92%
ABS

9.71%
Fed Agy Bond /
Note

15.05%
Corporate Note

0.79%
Cert of Deposit

0.31%
Cert of Deposit -
FDIC

0.26%
Muni Bond / Note

1.69%
Supra-National
Agency Bond / Note

52.32%
US TSY Bond / Note

16.64%
Local Agency
Investment Fund

0.31%
Passbook/Checking
Accounts
Summary Page 1

Page 23 ends

For the Month Ending July 31, 2022Managed Account Summary Statement

CITY OF RANCHO CUCAMONGA -
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)
$308,311,921.22
(35,748.84)
(4,218,623.05)
7,302,890.63

0.00 2,207,242.05
$313,567,682.01
275,847.49
(45,850.68)
(152,895.52)
$77,101.29
Total
326,202,859.69
1,020,261.41
4,240,970.20
35,748.84
253,500.34
(7,348,741.31)
(323,256,521.85)
(910,771.58)
Total Accrual Basis Earnings $237,305.74
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

0.00 4,240,970.20
253,500.34
35,748.84
(7,348,741.31)

0.00 0.00
Cash Balance
$407,969.69 Closing Cash Balance
Account 73340000 Page 1

Page 24 ends

For the Month Ending July 31, 2022Portfolio Summary and Statistics

CITY OF RANCHO CUCAMONGA -
Account Summary
Percent Par Value Market ValueDescription
U.S. Treasury Bond / Note 205,555,000.00 197,564,136.68 63.00 Supra-National Agency Bond / Note 6,665,000.00 6,375,675.68 2.03 Municipal Bond / Note 1,000,000.00 989,985.00 0.32
Federal Agency Bond / Note 38,745,000.00 36,647,682.60 11.69 Corporate Note 58,860,000.00 56,803,260.53 18.12
Certificate of Deposit - FDIC Insured 1,225,000.00 1,171,120.84 0.37 Certificate of Deposit 3,000,000.00 2,975,766.88 0.95 Asset-Backed Security 11,457,305.47 11,040,053.80 3.52 Managed Account Sub-Total 326,507,305.47 313,567,682.01 100.00% Accrued Interest 1,020,261.41
Total Portfolio 326,507,305.47 314,587,943.42
Unsettled Trades 0.00 0.00
Sector Allocation

3.52%
ABS

0.95%
Cert of Deposit

0.37%
Cert of Deposit -
FDIC

18.12%
Corporate Note

11.69%
Fed Agy Bond /
Note

0.32%
Muni Bond / Note

2.03%
Supra-National
Agency Bond / Note

63.00%
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

0.16%

10.67%

26.30%

23.04% 23.54%

16.29%

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

1.14%

2.95%
Account 73340000 Page 2

Page 25 ends

For the Month Ending July 31, 2022Managed Account Issuer Summary

CITY OF RANCHO CUCAMONGA -
Credit Quality (S&P Ratings)

4.55%
A

1.57%
A+

5.44%
A-

0.95%
A-1+

1.38%
AA

75.97%
AA+

2.67%
AA-

4.72%
AAA

1.55%
BBB+

1.20%
NR
Issuer Summary
Percentof HoldingsIssuer
Market Value
1,389,325.67 0.44 AMAZON.COM INC
1,690,393.05 0.54 AMERICAN EXPRESS CO
1,838,084.00 0.59 AMERICAN HONDA FINANCE
2,999,334.00 0.96 APPLE INC
1,546,755.30 0.49 ASTRAZENECA PLC
1,954,786.00 0.62 BANK OF AMERICA CO
488,647.97 0.16 BMW FINANCIAL SERVICES NA LLC
1,774,144.47 0.57 CAPITAL ONE FINANCIAL CORP
2,375,439.59 0.76 CARMAX AUTO OWNER TRUST
1,838,986.00 0.59 CATERPILLAR INC
2,546,420.18 0.81 CHARLES SCHWAB
225,054.06 0.07 CHIPPEWA VALLEY BANK
1,413,024.00 0.45 CITIGROUP INC
1,878,502.00 0.60 DEERE & COMPANY
231,972.62 0.07 ENERBANK USA
25,417,953.30 8.11 FANNIE MAE
2,798,508.00 0.89 FEDERAL FARM CREDIT BANKS
8,431,221.30 2.69 FREDDIE MAC
1,610,083.20 0.51 GENERAL DYNAMICS CORP
895,626.28 0.29 GM FINANCIAL CONSUMER AUTOMOBILE TRUST 502,894.46 0.16 GM FINANCIAL LEASINGTRUST
1,749,111.50 0.56 GOLDMAN SACHS GROUP INC
1,982,904.00 0.63 HOME DEPOT INC
1,230,713.31 0.39 HONDA AUTO RECEIVABLES
1,457,822.40 0.46 HONEYWELL INTERNATIONAL
1,998,372.00 0.64 HSBC HOLDINGS PLC
273,636.61 0.09 HYUNDAI AUTO LEASE SECURITIZATION TRUST 1,983,945.09 0.63 HYUNDAI AUTO RECEIVABLES
1,662,710.53 0.53 IBM CORP
5,014,544.87 1.60 INTER-AMERICAN DEVELOPMENT BANK
1,361,130.81 0.43 INTL BANK OF RECONSTRUCTION AND DEV
2,652,032.04 0.85 JP MORGAN CHASE & CO
Account 73340000 Page 3

Page 26 ends

For the Month Ending July 31, 2022Managed Account Issuer Summary

CITY OF RANCHO CUCAMONGA -
Percentof HoldingsIssuer
Market Value
869,841.22 0.28 KUBOTA CREDIT OWNER TRUST
225,387.75 0.07 MEDALLION BANK UTAH
146,693.59 0.05 MERCEDES-BENZ AUTO LEASE TRUST
1,676,553.58 0.53 MORGAN STANLEY
3,019,524.00 0.96 NATIONAL AUSTRALIA BANK LTD
445,530.89 0.14 NATIONAL RURAL UTILITIES CO FINANCE CORP 1,641,747.86 0.52 NORTHERN TRUST
2,924,844.00 0.93 NOVARTIS AG
2,949,471.99 0.94 Roche Holding AG
989,985.00 0.32 SAN MATEO-FOSTER CITY SCHOOL DISTRICT
2,201,228.90 0.70 STATE STREET CORPORATION
337,306.80 0.11 TARGET CORP
1,539,254.24 0.49 THE BANK OF NEW YORK MELLON CORPORATION 2,975,766.88 0.95 TORONTO-DOMINION BANK
1,023,439.95 0.33 TOYOTA MOTOR CORP
1,916,617.50 0.61 TRUIST FIN CORP
417,915.96 0.13 UNILEVER PLC
197,564,136.68 63.01 UNITED STATES TREASURY
1,837,488.60 0.59 UNITEDHEALTH GROUP INC
2,419,365.00 0.77 US BANCORP
987,119.18 0.31 VOLKSWAGEN OF AMERICA
244,383.83 0.08 WELLS FARGO & COMPANY
$313,567,682.01 Total 100.00%
Account 73340000 Page 4

Page 27 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

US TREASURY NOTES
DTD 02/28/2018 2.625% 02/28/2023
1,806,606.25 1,835,425.76 19,882.95 1,910,257.03 11/18/2011/16/20AaaAA+ 1,810,000.00 9128284A5 0.19

US TREASURY NOTES
DTD 03/15/2020 0.500% 03/15/2023
3,397,171.88 3,457,189.28 6,515.63 3,477,357.42 11/05/2010/30/20AaaAA+ 3,450,000.00 912828ZD5 0.16

US TREASURY NOTES
DTD 04/30/2018 2.750% 04/30/2023
4,989,844.00 5,095,965.91 34,748.64 5,329,882.81 10/07/2010/06/20AaaAA+ 5,000,000.00 9128284L1 0.17

US TREASURY NOTES
DTD 05/31/2016 1.625% 05/31/2023
3,461,171.70 3,542,177.37 9,634.56 3,630,429.69 11/05/2010/30/20AaaAA+ 3,500,000.00 912828R69 0.17

US TREASURY NOTES
DTD 06/15/2020 0.250% 06/15/2023
6,347,656.25 6,505,872.16 2,086.75 6,518,281.25 09/28/2009/24/20AaaAA+ 6,500,000.00 912828ZU7 0.15

US TREASURY N/B NOTES
DTD 07/31/2021 0.125% 07/31/2023
5,831,250.00 5,995,030.34 20.38 5,990,156.25 08/09/2108/06/21AaaAA+ 6,000,000.00 91282CCN9 0.21

US TREASURY NOTES
DTD 08/15/2020 0.125% 08/15/2023
4,854,687.50 4,997,016.33 2,883.29 4,991,796.88 10/07/2010/06/20AaaAA+ 5,000,000.00 91282CAF8 0.18

US TREASURY NOTES
DTD 09/15/2020 0.125% 09/15/2023
4,842,969.00 4,995,390.62 2,360.73 4,988,476.56 11/24/2011/23/20AaaAA+ 5,000,000.00 91282CAK7 0.21

US TREASURY NOTES
DTD 09/30/2021 0.250% 09/30/2023
1,937,812.40 1,999,495.54 1,680.33 1,999,140.63 10/06/2110/04/21AaaAA+ 2,000,000.00 91282CDA6 0.27

US TREASURY N/B NOTES
DTD 10/31/2021 0.375% 10/31/2023
5,810,625.00 5,989,415.41 5,686.14 5,983,125.00 11/03/2111/01/21AaaAA+ 6,000,000.00 91282CDD0 0.52

US TREASURY NOTES
DTD 12/15/2020 0.125% 12/15/2023
961,875.00 966,864.71 160.52 963,359.38 06/09/2206/08/22AaaAA+ 1,000,000.00 91282CBA8 2.60

US TREASURY N/B NOTES
DTD 12/31/2021 0.750% 12/31/2023
3,392,265.80 3,498,537.58 2,282.61 3,497,949.22 01/05/2201/03/22AaaAA+ 3,500,000.00 91282CDR9 0.78

US TREASURY N/B NOTES
DTD 12/31/2021 0.750% 12/31/2023
4,846,094.00 4,990,921.89 3,260.87 4,987,304.69 01/07/2201/06/22AaaAA+ 5,000,000.00 91282CDR9 0.88

US TREASURY N/B NOTES
DTD 01/31/2022 0.875% 01/31/2024
4,846,875.00 4,869,550.51 118.89 4,845,507.81 04/22/2204/21/22AaaAA+ 5,000,000.00 91282CDV0 2.67 Account 73340000 Page 5

Page 28 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

US TREASURY NOTES
DTD 02/28/2019 2.375% 02/29/2024
7,928,750.40 8,277,326.11 79,510.87 8,600,312.50 09/28/2009/24/20AaaAA+ 8,000,000.00 9128286G0 0.18

US TREASURY NOTES
DTD 05/01/2017 2.000% 04/30/2024
3,556,820.91 3,726,340.83 18,271.47 3,836,983.59 11/05/2010/30/20AaaAA+ 3,615,000.00 912828X70 0.23

US TREASURY N/B NOTES
DTD 04/30/2022 2.500% 04/30/2024
4,961,719.00 4,979,442.16 31,589.67 4,977,734.38 06/09/2206/08/22AaaAA+ 5,000,000.00 91282CEK3 2.74

US TREASURY N/B NOTES
DTD 05/15/2021 0.250% 05/15/2024
1,811,531.25 1,885,103.88 1,006.79 1,878,921.88 11/03/2111/01/21AaaAA+ 1,900,000.00 91282CCC3 0.69

US TREASURY N/B NOTES
DTD 05/31/2022 2.500% 05/31/2024
1,419,051.63 1,426,185.69 6,056.01 1,425,866.41 06/06/2206/02/22AaaAA+ 1,430,000.00 91282CER8 2.65

US TREASURY NOTES
DTD 06/30/2019 1.750% 06/30/2024
5,040,562.50 5,054,458.00 7,836.96 5,042,976.56 05/09/2205/06/22AaaAA+ 5,150,000.00 9128286Z8 2.75

US TREASURY N/B NOTES
DTD 07/15/2021 0.375% 07/15/2024
4,761,719.00 5,004,402.42 866.17 5,006,640.63 08/03/2108/02/21AaaAA+ 5,000,000.00 91282CCL3 0.33

US TREASURY NOTES
DTD 07/31/2019 1.750% 07/31/2024
5,543,310.65 5,840,388.74 269.63 5,995,139.06 10/07/2010/06/20AaaAA+ 5,670,000.00 912828Y87 0.24

US TREASURY N/B NOTES
DTD 08/15/2021 0.375% 08/15/2024
3,800,000.00 3,997,405.99 6,919.89 3,996,250.00 09/03/2109/01/21AaaAA+ 4,000,000.00 91282CCT6 0.41

US TREASURY NOTES
DTD 08/31/2019 1.250% 08/31/2024
2,169,932.81 2,291,913.52 11,743.55 2,325,942.78 01/26/2101/25/21AaaAA+ 2,245,000.00 912828YE4 0.24

US TREASURY N/B NOTES
DTD 09/15/2021 0.375% 09/15/2024
1,327,375.00 1,396,328.66 1,983.02 1,394,914.06 10/06/2110/04/21AaaAA+ 1,400,000.00 91282CCX7 0.50

US TREASURY NOTES
DTD 10/02/2017 2.125% 09/30/2024
5,555,032.81 5,877,959.65 40,313.17 6,075,872.27 09/28/2009/24/20AaaAA+ 5,645,000.00 9128282Y5 0.21

US TREASURY NOTES
DTD 10/31/2019 1.500% 10/31/2024
2,425,000.00 2,566,532.94 9,476.90 2,616,796.88 11/18/2011/16/20AaaAA+ 2,500,000.00 912828YM6 0.31

US TREASURY NOTES
DTD 11/30/2019 1.500% 11/30/2024
4,844,531.00 5,139,295.76 12,704.92 5,239,843.75 11/24/2011/23/20AaaAA+ 5,000,000.00 912828YV6 0.30 Account 73340000 Page 6

Page 29 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

US TREASURY NOTES
DTD 12/31/2019 1.750% 12/31/2024
973,750.00 1,017,167.06 1,521.74 1,021,210.94 01/05/2201/03/22AaaAA+ 1,000,000.00 912828YY0 1.03

US TREASURY NOTES
DTD 02/28/2018 2.750% 02/28/2025
5,981,250.00 6,387,393.12 69,048.91 6,663,750.00 09/28/2009/24/20AaaAA+ 6,000,000.00 9128283Z1 0.23

US TREASURY NOTES
DTD 03/31/2020 0.500% 03/31/2025
2,583,710.80 2,761,817.76 4,620.90 2,769,335.94 11/20/2011/17/20AaaAA+ 2,750,000.00 912828ZF0 0.34

US TREASURY NOTES
DTD 04/30/2020 0.375% 04/30/2025
1,962,843.75 2,051,885.79 1,990.15 2,042,003.91 01/07/2201/06/22AaaAA+ 2,100,000.00 912828ZL7 1.23

US TREASURY N/B NOTES
DTD 05/15/2022 2.750% 05/15/2025
3,988,750.00 3,989,477.17 23,315.22 3,989,218.75 07/07/2207/05/22AaaAA+ 4,000,000.00 91282CEQ0 2.85

US TREASURY NOTES
DTD 07/31/2020 0.250% 07/31/2025
3,148,187.50 3,155,703.09 23.10 3,140,085.94 05/23/2205/20/22AaaAA+ 3,400,000.00 91282CAB7 2.77

US TREASURY NOTES
DTD 07/31/2020 0.250% 07/31/2025
4,166,718.75 4,485,859.06 30.57 4,478,730.47 01/26/2101/25/21AaaAA+ 4,500,000.00 91282CAB7 0.36

US TREASURY NOTES
DTD 07/31/2020 0.250% 07/31/2025
6,481,562.50 6,971,227.48 47.55 6,956,250.00 01/08/2101/06/21AaaAA+ 7,000,000.00 91282CAB7 0.39

US TREASURY NOTES
DTD 11/30/2020 0.375% 11/30/2025
2,769,375.00 2,852,945.37 1,905.74 2,833,007.81 02/17/2202/16/22AaaAA+ 3,000,000.00 91282CAZ4 1.91

US TREASURY NOTES
DTD 12/31/2020 0.375% 12/31/2025
3,591,656.25 3,853,783.62 1,271.74 3,837,082.03 05/07/2105/06/21AaaAA+ 3,900,000.00 91282CBC4 0.73

US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
684,934.38 735,611.14 7.59 732,748.24 07/07/2107/06/21AaaAA+ 745,000.00 91282CBH3 0.74

US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
5,516,250.00 5,931,654.91 61.14 5,912,578.13 08/09/2108/06/21AaaAA+ 6,000,000.00 91282CBH3 0.71

US TREASURY NOTES
DTD 02/28/2021 0.500% 02/28/2026
2,442,968.75 2,631,223.47 5,544.84 2,623,810.55 03/03/2103/02/21AaaAA+ 2,650,000.00 91282CBQ3 0.70

US TREASURY N/B NOTES
DTD 03/31/2021 0.750% 03/31/2026
2,787,187.50 2,980,615.77 7,561.48 2,973,632.81 04/06/2104/02/21AaaAA+ 3,000,000.00 91282CBT7 0.93 Account 73340000 Page 7

Page 30 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

US TREASURY NOTES
DTD 05/16/2016 1.625% 05/15/2026
3,379,043.15 3,506,703.53 12,141.13 3,504,758.79 03/07/2203/03/22AaaAA+ 3,525,000.00 912828R36 1.77

US TREASURY N/B NOTES
DTD 05/31/2021 0.750% 05/31/2026
2,779,218.60 2,870,017.78 3,811.48 2,854,687.50 02/17/2202/16/22AaaAA+ 3,000,000.00 91282CCF6 1.93

US TREASURY N/B NOTES
DTD 05/31/2021 0.750% 05/31/2026
5,651,077.82 6,089,754.17 7,750.00 6,086,656.25 06/04/2106/02/21AaaAA+ 6,100,000.00 91282CCF6 0.79

US TREASURY N/B NOTES
DTD 07/31/2021 0.625% 07/31/2026
1,838,437.60 1,988,763.25 33.97 1,986,015.63 08/09/2108/06/21AaaAA+ 2,000,000.00 91282CCP4 0.77

US TREASURY N/B NOTES
DTD 07/31/2021 0.625% 07/31/2026
2,757,656.40 2,993,618.01 50.95 2,992,031.25 08/03/2108/02/21AaaAA+ 3,000,000.00 91282CCP4 0.68

US TREASURY NOTES
DTD 08/15/2016 1.500% 08/15/2026
4,304,406.25 4,266,763.67 31,312.50 4,249,081.05 04/22/2204/21/22AaaAA+ 4,525,000.00 9128282A7 3.02

US TREASURY N/B NOTES
DTD 10/31/2021 1.125% 10/31/2026
374,000.00 397,921.05 1,137.23 397,578.13 11/18/2111/17/21AaaAA+ 400,000.00 91282CDG3 1.25

US TREASURY N/B NOTES
DTD 10/31/2021 1.125% 10/31/2026
2,805,000.00 2,798,726.50 8,529.21 2,789,648.44 05/23/2205/20/22AaaAA+ 3,000,000.00 91282CDG3 2.82

US TREASURY NOTES
DTD 11/15/2016 2.000% 11/15/2026
2,907,187.50 2,874,630.94 12,717.39 2,870,390.63 06/09/2206/08/22AaaAA+ 3,000,000.00 912828U24 3.05

US TREASURY N/B NOTES
DTD 11/30/2021 1.250% 11/30/2026
2,720,395.31 2,902,163.93 6,130.12 2,903,255.27 12/03/2112/01/21AaaAA+ 2,895,000.00 91282CDK4 1.19

US TREASURY N/B NOTES
DTD 12/31/2021 1.250% 12/31/2026
1,524,960.94 1,617,634.38 1,766.30 1,616,684.57 01/05/2201/03/22AaaAA+ 1,625,000.00 91282CDQ1 1.36

US TREASURY NOTES
DTD 02/15/2017 2.250% 02/15/2027
3,326,687.50 3,314,953.47 35,291.44 3,313,671.88 07/07/2207/05/22AaaAA+ 3,400,000.00 912828V98 2.84

US TREASURY NOTES
DTD 02/15/2017 2.250% 02/15/2027
3,644,679.69 3,615,491.41 38,664.88 3,611,794.92 06/06/2206/02/22AaaAA+ 3,725,000.00 912828V98 2.95 596,158.58 197,564,136.68 205,245,444.66 1.00 206,676,919.20 205,555,000.00 Security Type Sub-Total Account 73340000 Page 8

Page 31 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

INTL BK RECON & DEVELOP NOTES
DTD 11/24/2020 0.250% 11/24/2023
1,361,130.81 1,408,671.12 656.04 1,406,968.50 11/24/2011/17/20AaaAAA 1,410,000.00 459058JM6 0.32

INTER-AMERICAN DEVEL BK NOTES
DTD 09/23/2021 0.500% 09/23/2024
3,559,075.37 3,753,012.32 6,675.56 3,752,221.30 09/23/2109/15/21AaaAAA 3,755,000.00 4581X0DZ8 0.52

INTER-AMERICAN DEVELOPMENT BANK
NOTES
DTD 01/16/2020 1.750% 03/14/2025
1,455,469.50 1,549,705.54 9,989.58 1,576,950.00 02/23/2102/19/21AaaAAA 1,500,000.00 4581X0DK1 0.47 17,321.18 6,375,675.68 6,711,388.98 0.47 6,736,139.80 6,665,000.00 Security Type Sub-Total Municipal Bond / Note

SAN MATEO-FOSTER SCH DIST, CA TXBL GO
BO
DTD 05/19/2020 1.162% 08/01/2022
500,000.00 500,000.00 2,905.00 502,300.00 05/19/2005/19/20AaaAA+ 500,000.00 799055QR2 0.95

SAN MATEO-FOSTER SCH DIST, CA TXBL GO
BO
DTD 05/19/2020 1.266% 08/01/2023
489,985.00 501,056.91 3,165.00 503,385.00 05/19/2005/19/20AaaAA+ 500,000.00 799055QS0 1.05 6,070.00 989,985.00 1,001,056.91 1.00 1,005,685.00 1,000,000.00 Security Type Sub-Total Federal Agency Bond / Note

FANNIE MAE NOTES
DTD 07/10/2020 0.250% 07/10/2023
4,154,927.10 4,260,403.08 621.25 4,261,192.80 09/28/2009/24/20AaaAA+ 4,260,000.00 3135G05G4 0.24

FREDDIE MAC NOTES
DTD 09/04/2020 0.250% 09/08/2023
4,661,668.80 4,801,097.66 4,766.67 4,802,928.00 09/28/2009/24/20AaaAA+ 4,800,000.00 3137EAEW5 0.23

FREDDIE MAC NOTES
DTD 11/05/2020 0.250% 11/06/2023
1,643,979.90 1,699,355.05 1,003.47 1,698,470.00 11/05/2011/03/20AaaAA+ 1,700,000.00 3137EAEZ8 0.28

FANNIE MAE NOTES
DTD 11/25/2020 0.250% 11/27/2023
4,248,446.40 4,397,791.50 1,955.56 4,394,984.00 11/25/2011/23/20AaaAA+ 4,400,000.00 3135G06H1 0.29

FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
2,704,743.50 2,898,990.08 1,769.17 2,901,803.25 07/21/2007/21/20AaaAA+ 2,895,000.00 3135G04Z3 0.45 Account 73340000 Page 9

Page 32 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
4,671,405.00 5,010,857.69 3,055.55 5,017,800.00 09/28/2009/24/20AaaAA+ 5,000,000.00 3135G04Z3 0.42

FEDERAL FARM CREDIT BANK NOTES
DTD 07/02/2020 0.500% 07/02/2025
2,798,508.00 3,004,194.39 1,208.33 3,007,110.00 07/21/2007/21/20AaaAA+ 3,000,000.00 3133ELR71 0.45

FANNIE MAE NOTES (CALLABLE)
DTD 07/21/2020 0.625% 07/21/2025
2,333,437.50 2,499,405.81 434.03 2,499,000.00 07/21/2007/21/20AaaAA+ 2,500,000.00 3136G4ZJ5 0.63

FANNIE MAE NOTES
DTD 08/27/2020 0.375% 08/25/2025
1,851,914.00 1,992,656.78 3,250.00 1,988,500.00 11/05/2010/30/20AaaAA+ 2,000,000.00 3135G05X7 0.50

FREDDIE MAC NOTES
DTD 09/25/2020 0.375% 09/23/2025
2,125,572.60 2,295,638.97 3,066.67 2,293,077.00 09/25/2009/23/20AaaAA+ 2,300,000.00 3137EAEX3 0.44

FANNIE MAE NOTES
DTD 11/12/2020 0.500% 11/07/2025
1,286,889.80 1,388,504.48 1,621.67 1,387,720.40 11/13/2011/12/20AaaAA+ 1,390,000.00 3135G06G3 0.53

FANNIE MAE NOTES
DTD 11/12/2020 0.500% 11/07/2025
4,166,190.00 4,496,326.41 5,250.00 4,494,465.00 12/04/2012/02/20AaaAA+ 4,500,000.00 3135G06G3 0.53 28,002.37 36,647,682.60 38,745,221.90 0.39 38,747,050.45 38,745,000.00 Security Type Sub-Total Corporate Note

APPLE INC (CALLABLE) BONDS
DTD 02/09/2017 3.000% 02/09/2024
2,999,334.00 3,005,377.01 43,000.00 3,019,140.00 02/11/1902/11/19AaaAA+ 3,000,000.00 037833CG3 2.86

CHARLES SCHWAB CORP NOTES
(CALLABLE)
DTD 03/18/2021 0.750% 03/18/2024
634,770.18 659,820.85 1,828.75 659,670.00 03/18/2103/16/21A2A 660,000.00 808513BN4 0.77 AMAZON.COM INC CORPORATE NOTES
DTD 05/12/2021 0.450% 05/12/2024
1,389,325.67 1,453,740.15 1,436.81 1,452,875.70 05/12/2105/10/21A1AA 1,455,000.00 023135BW5 0.50

HSBC USA INC CORPORATE NOTES
DTD 05/24/2022 3.750% 05/24/2024
1,998,372.00 1,999,927.55 13,958.33 1,999,920.00 05/24/2205/17/22A1A- 2,000,000.00 40428HTA0 3.75

AMERICAN EXPRESS CO CORP NOTES
(CALLABLE
DTD 07/30/2019 2.500% 07/30/2024
1,690,393.05 1,770,438.68 119.79 1,786,755.00 11/23/2111/19/21A2BBB+ 1,725,000.00 025816CG2 1.14 Account 73340000 Page 10

Page 33 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

UNILEVER CAPITAL CORP (CALLABLE)

CORPORA
DTD 08/12/2021 0.626% 08/12/2024
417,915.96 440,000.00 1,293.04 440,000.00 08/12/2108/09/21A1A+ 440,000.00 904764BN6 0.63

BMW US CAPITAL LLC CORPORATE NOTES
DTD 08/12/2021 0.750% 08/12/2024
488,647.97 514,968.62 1,813.23 514,953.65 08/12/2108/09/21A2A 515,000.00 05565EBU8 0.75

US BANK NA CINCINNATI (CALLABLE)

CORPORA
DTD 01/21/2020 2.050% 01/21/2025
2,419,365.00 2,581,322.97 1,423.61 2,640,450.00 11/05/2010/30/20A1AA- 2,500,000.00 90331HPL1 0.69

NOVARTIS CAPITAL CORP
DTD 02/14/2020 1.750% 02/14/2025
2,924,844.00 3,082,753.82 24,354.17 3,144,750.00 09/28/2009/24/20A1AA- 3,000,000.00 66989HAP3 0.63

JPMORGAN CHASE & CO CORP NOTES
(CALLABLE
DTD 02/16/2021 0.563% 02/16/2025
576,861.14 610,000.00 1,574.05 610,000.00 02/16/2102/09/21A2A- 610,000.00 46647PBY1 0.56

ROCHE HOLDINGS INC (CALLABLE)

CORPORATE
DTD 03/10/2022 2.132% 03/10/2025
2,949,471.99 3,015,000.00 25,176.26 3,015,000.00 03/10/2203/03/22Aa3AA 3,015,000.00 771196BT8 2.13

GENERAL DYNAMICS CORP (CALLABLE)

CORP NO
DTD 05/11/2018 3.500% 05/15/2025
1,610,083.20 1,702,612.32 11,822.22 1,757,296.00 03/09/2103/05/21A3A- 1,600,000.00 369550BG2 1.09

NATIONAL RURAL UTIL COOP CORPORATE
NOTES
DTD 05/04/2022 3.450% 06/15/2025
445,530.89 444,889.25 3,710.19 444,879.85 05/04/2204/27/22A2A- 445,000.00 63743HFE7 3.46

CITIGROUP INC CORP NOTE (CALLABLE)
DTD 11/03/2021 1.281% 11/03/2025
1,413,024.00 1,501,162.98 4,697.00 1,501,545.00 11/03/2111/01/21A3BBB+ 1,500,000.00 172967ND9 1.25

BANK OF NY MELLON CORP (CALLABLE)
CORPOR
DTD 01/28/2021 0.750% 01/28/2026
1,539,254.24 1,684,303.77 105.31 1,684,005.85 02/01/2101/28/21A1A 1,685,000.00 06406RAQ0 0.76

STATE STREET CORP (CALLABLE)

CORPORATE N
DTD 02/07/2022 1.746% 02/06/2026
291,268.90 305,000.00 2,573.90 305,000.00 02/07/2202/02/22A1A 305,000.00 857477BR3 1.75 Account 73340000 Page 11

Page 34 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

STATE STREET CORP (CALLABLE)

CORPORATE N
DTD 02/07/2022 1.746% 02/06/2026
1,909,960.00 1,920,663.60 16,878.00 1,914,860.00 04/29/2204/27/22A1A 2,000,000.00 857477BR3 2.95

GOLDMAN SACHS GROUP INC CORPORATE
NOTES
DTD 02/12/2021 0.855% 02/12/2026
1,749,111.50 1,902,747.89 7,626.13 1,903,876.00 02/17/2102/12/21A2BBB+ 1,900,000.00 38141GXS8 0.81

BANK OF AMERICA CORP NOTES
(CALLABLE)
DTD 03/22/2022 3.384% 04/02/2026
1,954,786.00 1,961,108.92 24,252.00 1,958,700.00 05/10/2205/06/22A2A- 2,000,000.00 06051GKM0 3.96

JPMORGAN CHASE & CO (CALLABLE)

CORPORATE
DTD 04/26/2022 4.080% 04/26/2026
1,099,954.90 1,100,606.43 11,843.33 1,100,638.00 06/10/2206/08/22A2A- 1,100,000.00 46647PCZ7 4.06

IBM CORP
DTD 05/15/2019 3.300% 05/15/2026
1,662,710.53 1,811,978.89 11,669.17 1,844,861.75 09/03/2109/01/21A3A- 1,675,000.00 459200JZ5 1.08

ASTRAZENECA FINANCE LLC (CALLABLE)
CORP
DTD 05/28/2021 1.200% 05/28/2026
1,546,755.30 1,682,316.91 3,517.50 1,684,095.25 09/03/2109/01/21A3A- 1,675,000.00 04636NAA1 1.08

TOYOTA MOTOR CREDIT CORP CORPORATE
NOTES
DTD 06/18/2021 1.125% 06/18/2026
1,023,439.95 1,103,001.13 1,484.84 1,102,546.90 09/13/2109/08/21A1A+ 1,105,000.00 89236TJK2 1.17

MORGAN STANLEY CORP NOTES
DTD 07/25/2016 3.125% 07/27/2026
977,565.00 1,052,540.78 347.22 1,062,320.00 11/03/2111/01/21A1A- 1,000,000.00 61761J3R8 1.75

AMERICAN HONDA FINANCE CORPORATE
NOTES
DTD 09/09/2021 1.300% 09/09/2026
1,838,084.00 1,974,790.35 10,255.56 1,970,740.00 12/03/2112/01/21A3A- 2,000,000.00 02665WDZ1 1.62

CATERPILLAR FINL SERVICE CORPORATE
NOTES
DTD 09/14/2021 1.150% 09/14/2026
1,838,986.00 1,972,106.64 8,752.78 1,967,640.00 12/03/2112/01/21A2A 2,000,000.00 14913R2Q9 1.50

JPMORGAN CHASE & CO CORP NOTES
DTD 07/21/2016 2.950% 10/01/2026
975,216.00 1,048,372.84 9,833.33 1,057,540.00 11/03/2111/01/21A2A- 1,000,000.00 46625HRV4 1.72 Account 73340000 Page 12

Page 35 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

JOHN DEERE CAPITAL CORP CORPORATE
NOTES
DTD 01/10/2022 1.700% 01/11/2027
1,878,502.00 1,989,956.84 1,888.89 1,988,720.00 01/13/2201/11/22A2A 2,000,000.00 24422EWA3 1.82

TARGET CORP CORPORATE NOTES
DTD 01/24/2022 1.950% 01/15/2027
337,306.80 354,459.27 307.67 354,396.50 01/24/2201/19/22A2A 355,000.00 87612EBM7 1.99

HONEYWELL INTERNATIONAL (CALLABLE)
CORP
DTD 08/16/2021 1.100% 03/01/2027
1,457,822.40 1,519,019.45 7,333.33 1,511,904.00 03/07/2203/03/22A2A 1,600,000.00 438516CE4 2.27

TRUIST FINANCIAL CORP NOTES
(CALLABLE)
DTD 03/02/2021 1.267% 03/02/2027
1,916,617.50 1,960,321.44 11,012.34 1,949,808.00 03/28/2203/24/22A3A- 2,100,000.00 89788MAD4 2.83

CHARLES SCHWAB CORP NOTES
(CALLABLE)
DTD 03/03/2022 2.450% 03/03/2027
1,911,650.00 1,903,609.38 20,144.44 1,898,200.00 04/29/2204/27/22A2A 2,000,000.00 808513BY0 3.60

HOME DEPOT INC (CALLABLE) CORPORATE
NOTE
DTD 03/28/2022 2.875% 04/15/2027
1,982,904.00 1,939,044.86 19,645.84 1,936,100.00 05/10/2205/06/22A2A 2,000,000.00 437076CN0 3.59

MORGAN STANLEY CORP NOTES
(CALLABLE)
DTD 04/22/2021 1.593% 05/04/2027
454,666.00 454,196.21 1,924.88 452,825.00 06/10/2206/08/22A1A- 500,000.00 61772BAB9 3.72

NORTHERN TRUST CORP NOTE (CALLABLE)
DTD 05/10/2022 4.000% 05/10/2027
1,641,747.86 1,609,712.03 14,355.00 1,610,407.70 05/12/2205/10/22A2A+ 1,595,000.00 665859AW4 3.79

UNITEDHEALTH GROUP INC CORPORATE
NOTES
DTD 05/20/2022 3.700% 05/15/2027
408,330.80 399,792.66 2,918.89 399,784.00 05/20/2205/17/22A3A+ 400,000.00 91324PEG3 3.71

UNITEDHEALTH GROUP INC CORPORATE
NOTES
DTD 05/20/2022 3.700% 05/15/2027
1,429,157.80 1,412,100.35 10,216.11 1,412,488.00 06/06/2206/02/22A3A+ 1,400,000.00 91324PEG3 3.50 Account 73340000 Page 13

Page 36 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

NATIONAL AUSTRALIA BK/NY CORPORATE
NOTES
DTD 06/09/2022 3.905% 06/09/2027
3,019,524.00 2,974,689.50 16,921.67 2,973,990.00 06/13/2206/09/22Aa3AA- 3,000,000.00 63254ABE7 4.10 352,015.58 56,803,260.53 58,818,454.34 2.17 59,032,682.15 58,860,000.00 Security Type Sub-Total Certificate of Deposit - FDIC Insured

WELLS FARGO BANK NA
DTD 01/29/2020 1.900% 01/30/2023
244,383.83 245,000.00 38.26 245,000.00 01/29/2001/29/20NRNR 245,000.00 949763S64 1.90

MORGAN STANLEY PVT BANK
DTD 01/30/2020 1.850% 01/30/2023
244,322.58 245,000.00 24.84 245,000.00 01/30/2001/30/20NRNR 245,000.00 61760A6Q7 1.85

ENERBANK USA
DTD 07/24/2020 0.450% 07/24/2024
231,972.62 245,000.00 24.16 245,000.00 07/24/2007/24/20NRNR 245,000.00 29278TQD5 0.45

CHIPPEWA VALLEY BANK
DTD 07/29/2020 0.500% 07/29/2025
225,054.06 245,000.00 10.07 245,000.00 07/29/2007/29/20NRNR 245,000.00 169894AT9 0.50

MEDALLION BANK UTAH
DTD 07/30/2020 0.550% 07/30/2025
225,387.75 245,000.00 7.38 245,000.00 07/30/2007/30/20NRNR 245,000.00 58404DHQ7 0.55 104.71 1,171,120.84 1,225,000.00 1.07 1,225,000.00 1,225,000.00 Security Type Sub-Total Certificate of Deposit

TORONTO DOMINION BANK NY CERT
DEPOS
DTD 05/23/2022 2.800% 05/19/2023
2,975,766.88 3,000,000.00 16,333.33 3,000,000.00 05/23/2205/20/22P-1A-1+ 3,000,000.00 89114WXU4 2.80 16,333.33 2,975,766.88 3,000,000.00 2.80 3,000,000.00 3,000,000.00 Security Type Sub-Total Asset-Backed Security
MBALT 2021-A A3
DTD 01/27/2021 0.250% 01/16/2024
146,693.59 148,467.94 16.50 148,460.31 01/27/2101/20/21AaaAAA 148,475.32 58770GAC4 0.25 HALST 2021-A A4
DTD 01/20/2021 0.420% 12/16/2024
273,636.61 279,985.82 52.27 279,976.70 01/20/2101/12/21AaaAAA 280,000.00 44891TAD8 0.42 Account 73340000 Page 14

Page 37 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

CITY OF RANCHO CUCAMONGA -
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Original YTM Accrued Amortized MarketTrade Settle Par
Asset-Backed Security
GMALT 2021-1 A4
DTD 02/24/2021 0.330% 02/20/2025
502,894.46 514,950.15 51.93 514,922.24 02/24/2102/17/21AaaNR 515,000.00 36261RAD0 0.33 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
517,752.18 529,993.64 39.75 529,990.30 02/24/2102/17/21AaaNR 530,000.00 43813GAC5 0.27 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
523,803.24 539,959.51 91.20 539,943.19 04/28/2104/20/21NRAAA 540,000.00 44933LAC7 0.38 GMCAR 2021-1 A3
DTD 01/20/2021 0.350% 10/16/2025
345,763.98 354,437.41 51.69 354,419.21 01/20/2101/12/21AaaAAA 354,475.64 36261LAC5 0.35 KCOT 2021-2A A3
DTD 07/28/2021 0.560% 11/17/2025
869,841.22 924,973.31 230.22 924,965.13 07/28/2107/20/21AaaNR 925,000.00 50117XAE2 0.56 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
116,261.46 119,338.22 18.04 119,330.93 01/27/2101/20/21NRAAA 119,354.51 14316NAC3 0.34 HAROT 2021-4 A3
DTD 11/24/2021 0.880% 01/21/2026
712,961.13 744,868.80 182.11 744,842.95 11/24/2111/16/21AaaNR 745,000.00 43815GAC3 0.89 CARMX 2021-2 A3
DTD 04/21/2021 0.520% 02/17/2026
786,104.84 809,871.69 187.20 809,825.45 04/21/2104/13/21NRAAA 810,000.00 14314QAC8 0.52 CARMX 2021-3 A3
DTD 07/28/2021 0.550% 06/15/2026
1,473,073.29 1,529,800.41 374.00 1,529,748.32 07/28/2107/21/21AaaAAA 1,530,000.00 14317DAC4 0.55 VALET 2021-1 A3
DTD 12/13/2021 1.020% 06/22/2026
987,119.18 1,024,965.44 319.46 1,024,959.82 12/13/2112/07/21AaaAAA 1,025,000.00 92868KAC7 1.02 HART 2022-A A3
DTD 03/16/2022 2.220% 10/15/2026
1,460,141.85 1,499,947.01 1,480.00 1,499,942.25 03/16/2203/09/22NRAAA 1,500,000.00 448977AD0 2.22 COMET 2021-A3 A3
DTD 11/30/2021 1.040% 11/15/2026
1,774,144.47 1,864,777.63 862.04 1,864,743.00 11/30/2111/18/21NRAAA 1,865,000.00 14041NFY2 1.04 GMCAR 2022-1 A3
DTD 01/19/2022 1.260% 11/16/2026
549,862.30 569,955.92 299.25 569,950.47 01/19/2201/11/22NRAAA 570,000.00 380146AC4 1.26 4,255.66 11,040,053.80 11,456,292.90 0.90 11,456,020.27 11,457,305.47 Security Type Sub-Total Account 73340000 Page 15

Page 38 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

CITY OF RANCHO CUCAMONGA -
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Original YTM Accrued Amortized MarketTrade Settle Par
326,507,305.47 327,879,496.87 1.14 1,020,261.41 326,202,859.69 313,567,682.01 Managed Account Sub-Total $326,507,305.47 $327,879,496.87 $1,020,261.41 $326,202,859.69 $313,567,682.01 1.14% $314,587,943.42
$1,020,261.41
Total Investments
Accrued Interest
Securities Sub-Total
Account 73340000 Page 16

Page 39 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
U.S. Treasury Bond / Note
(28,819.51)(103,650.78) 1,806,606.25 99.81 CITIGRP 1,810,000.00 9128284A5US TREASURY NOTES DTD 02/28/2018 2.625% 02/28/2023

2.95 0.58
(60,017.40)(80,185.54) 3,397,171.88 98.47 WELLS_F 3,450,000.00 912828ZD5US TREASURY NOTES DTD 03/15/2020 0.500% 03/15/2023

2.99 0.63
(106,121.91)(340,038.81) 4,989,844.00 99.80 CITIGRP 5,000,000.00 9128284L1US TREASURY NOTES DTD 04/30/2018 2.750% 04/30/2023

3.02 0.75
(81,005.67)(169,257.99) 3,461,171.70 98.89 NOMURA 3,500,000.00 912828R69US TREASURY NOTES DTD 05/31/2016 1.625% 05/31/2023

2.98 0.84
(158,215.91)(170,625.00) 6,347,656.25 97.66 WELLS_F 6,500,000.00 912828ZU7US TREASURY NOTES DTD 06/15/2020 0.250% 06/15/2023

2.99 0.88
(163,780.34)(158,906.25) 5,831,250.00 97.19 MERRILL 6,000,000.00 91282CCN9US TREASURY N/B NOTES DTD 07/31/2021 0.125% 07/31/2023

3.00 1.00
(142,328.83)(137,109.38) 4,854,687.50 97.09 HSBC 5,000,000.00 91282CAF8US TREASURY NOTES DTD 08/15/2020 0.125% 08/15/2023

2.98 1.05
(152,421.62)(145,507.56) 4,842,969.00 96.86 NOMURA 5,000,000.00 91282CAK7US TREASURY NOTES DTD 09/15/2020 0.125% 09/15/2023

2.98 1.13
(61,683.14)(61,328.23) 1,937,812.40 96.89 NOMURA 2,000,000.00 91282CDA6US TREASURY NOTES DTD 09/30/2021 0.250% 09/30/2023

2.98 1.17
(178,790.41)(172,500.00) 5,810,625.00 96.84 CITIGRP 6,000,000.00 91282CDD0US TREASURY N/B NOTES DTD 10/31/2021 0.375% 10/31/2023

2.97 1.25
(4,989.71)(1,484.38) 961,875.00 96.19 BMO 1,000,000.00 91282CBA8US TREASURY NOTES DTD 12/15/2020 0.125% 12/15/2023

2.98 1.38
(106,271.78)(105,683.42) 3,392,265.80 96.92 JPM_CHA 3,500,000.00 91282CDR9US TREASURY N/B NOTES DTD 12/31/2021 0.750% 12/31/2023

2.99 1.42
(144,827.89)(141,210.69) 4,846,094.00 96.92 CITIGRP 5,000,000.00 91282CDR9US TREASURY N/B NOTES DTD 12/31/2021 0.750% 12/31/2023

2.99 1.42
(22,675.51) 1,367.19 4,846,875.00 96.94 RBS 5,000,000.00 91282CDV0US TREASURY N/B NOTES DTD 01/31/2022 0.875% 01/31/2024

2.98 1.49
(348,575.71)(671,562.10) 7,928,750.40 99.11 RBS 8,000,000.00 9128286G0US TREASURY NOTES DTD 02/28/2019 2.375% 02/29/2024

2.95 1.55
(169,519.92)(280,162.68) 3,556,820.91 98.39 MORGAN_ 3,615,000.00 912828X70US TREASURY NOTES DTD 05/01/2017 2.000% 04/30/2024

2.95 1.72
(17,723.16)(16,015.38) 4,961,719.00 99.23 BMO 5,000,000.00 91282CEK3US TREASURY N/B NOTES DTD 04/30/2022 2.500% 04/30/2024

2.95 1.72
Account 73340000 Page 17

Page 40 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
U.S. Treasury Bond / Note
(73,572.63)(67,390.63) 1,811,531.25 95.34 CITIGRP 1,900,000.00 91282CCC3US TREASURY N/B NOTES DTD 05/15/2021 0.250% 05/15/2024

2.94 1.79
(7,134.06)(6,814.78) 1,419,051.63 99.23 BMO 1,430,000.00 91282CER8US TREASURY N/B NOTES DTD 05/31/2022 2.500% 05/31/2024

2.93 1.80
(13,895.50)(2,414.06) 5,040,562.50 97.88 NOMURA 5,150,000.00 9128286Z8US TREASURY NOTES DTD 06/30/2019 1.750% 06/30/2024

2.90 1.90
(242,683.42)(244,921.63) 4,761,719.00 95.23 NOMURA 5,000,000.00 91282CCL3US TREASURY N/B NOTES DTD 07/15/2021 0.375% 07/15/2024

2.90 1.96
(297,078.09)(451,828.41) 5,543,310.65 97.77 WELLS_F 5,670,000.00 912828Y87US TREASURY NOTES DTD 07/31/2019 1.750% 07/31/2024

2.91 1.96
(197,405.99)(196,250.00) 3,800,000.00 95.00 NOMURA 4,000,000.00 91282CCT6US TREASURY N/B NOTES DTD 08/15/2021 0.375% 08/15/2024

2.92 2.04
(121,980.71)(156,009.97) 2,169,932.81 96.66 BNP_PAR 2,245,000.00 912828YE4US TREASURY NOTES DTD 08/31/2019 1.250% 08/31/2024

2.91 2.06
(68,953.66)(67,539.06) 1,327,375.00 94.81 MERRILL 1,400,000.00 91282CCX7US TREASURY N/B NOTES DTD 09/15/2021 0.375% 09/15/2024

2.91 2.12
(322,926.84)(520,839.46) 5,555,032.81 98.41 CITIGRP 5,645,000.00 9128282Y5US TREASURY NOTES DTD 10/02/2017 2.125% 09/30/2024

2.89 2.12
(141,532.94)(191,796.88) 2,425,000.00 97.00 CITIGRP 2,500,000.00 912828YM6US TREASURY NOTES DTD 10/31/2019 1.500% 10/31/2024

2.89 2.22
(294,764.76)(395,312.75) 4,844,531.00 96.89 NOMURA 5,000,000.00 912828YV6US TREASURY NOTES DTD 11/30/2019 1.500% 11/30/2024

2.89 2.30
(43,417.06)(47,460.94) 973,750.00 97.38 MORGAN_ 1,000,000.00 912828YY0US TREASURY NOTES DTD 12/31/2019 1.750% 12/31/2024

2.88 2.38
(406,143.12)(682,500.00) 5,981,250.00 99.69 MERRILL 6,000,000.00 9128283Z1US TREASURY NOTES DTD 02/28/2018 2.750% 02/28/2025

2.88 2.49
(178,106.96)(185,625.14) 2,583,710.80 93.95 MORGAN_ 2,750,000.00 912828ZF0US TREASURY NOTES DTD 03/31/2020 0.500% 03/31/2025

2.87 2.65
(89,042.04)(79,160.16) 1,962,843.75 93.47 NOMURA 2,100,000.00 912828ZL7US TREASURY NOTES DTD 04/30/2020 0.375% 04/30/2025

2.86 2.74
(727.17)(468.75) 3,988,750.00 99.72 MORGAN_ 4,000,000.00 91282CEQ0US TREASURY N/B NOTES DTD 05/15/2022 2.750% 05/15/2025

2.85 2.70
(7,515.59) 8,101.56 3,148,187.50 92.59 BMO 3,400,000.00 91282CAB7US TREASURY NOTES DTD 07/31/2020 0.250% 07/31/2025

2.84 2.99
Account 73340000 Page 18

Page 41 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
U.S. Treasury Bond / Note
(319,140.31)(312,011.72) 4,166,718.75 92.59 BNP_PAR 4,500,000.00 91282CAB7US TREASURY NOTES DTD 07/31/2020 0.250% 07/31/2025

2.84 2.99
(489,664.98)(474,687.50) 6,481,562.50 92.59 JPM_CHA 7,000,000.00 91282CAB7US TREASURY NOTES DTD 07/31/2020 0.250% 07/31/2025

2.84 2.99
(83,570.37)(63,632.81) 2,769,375.00 92.31 NOMURA 3,000,000.00 91282CAZ4US TREASURY NOTES DTD 11/30/2020 0.375% 11/30/2025

2.81 3.32
(262,127.37)(245,425.78) 3,591,656.25 92.09 HSBC 3,900,000.00 91282CBC4US TREASURY NOTES DTD 12/31/2020 0.375% 12/31/2025

2.82 3.40
(50,676.76)(47,813.86) 684,934.38 91.94 CITIGRP 745,000.00 91282CBH3US TREASURY NOTES DTD 01/31/2021 0.375% 01/31/2026

2.81 3.48
(415,404.91)(396,328.13) 5,516,250.00 91.94 RBS 6,000,000.00 91282CBH3US TREASURY NOTES DTD 01/31/2021 0.375% 01/31/2026

2.81 3.48
(188,254.72)(180,841.80) 2,442,968.75 92.19 CITIGRP 2,650,000.00 91282CBQ3US TREASURY NOTES DTD 02/28/2021 0.500% 02/28/2026

2.81 3.55
(193,428.27)(186,445.31) 2,787,187.50 92.91 NOMURA 3,000,000.00 91282CBT7US TREASURY N/B NOTES DTD 03/31/2021 0.750% 03/31/2026

2.80 3.62
(127,660.38)(125,715.64) 3,379,043.15 95.86 CITIGRP 3,525,000.00 912828R36US TREASURY NOTES DTD 05/16/2016 1.625% 05/15/2026

2.78 3.68
(90,799.18)(75,468.90) 2,779,218.60 92.64 JPM_CHA 3,000,000.00 91282CCF6US TREASURY N/B NOTES DTD 05/31/2021 0.750% 05/31/2026

2.79 3.78
(438,676.35)(435,578.43) 5,651,077.82 92.64 RBC 6,100,000.00 91282CCF6US TREASURY N/B NOTES DTD 05/31/2021 0.750% 05/31/2026

2.79 3.78
(150,325.65)(147,578.03) 1,838,437.60 91.92 CITIGRP 2,000,000.00 91282CCP4US TREASURY N/B NOTES DTD 07/31/2021 0.625% 07/31/2026

2.77 3.95
(235,961.61)(234,374.85) 2,757,656.40 91.92 CITIGRP 3,000,000.00 91282CCP4US TREASURY N/B NOTES DTD 07/31/2021 0.625% 07/31/2026

2.77 3.95
37,642.58 55,325.20 4,304,406.25 95.13 MERRILL 4,525,000.00 9128282A7US TREASURY NOTES DTD 08/15/2016 1.500% 08/15/2026

2.78 3.91
(23,921.05)(23,578.13) 374,000.00 93.50 CITIGRP 400,000.00 91282CDG3US TREASURY N/B NOTES DTD 10/31/2021 1.125% 10/31/2026

2.76 4.15
6,273.50 15,351.56 2,805,000.00 93.50 BMO 3,000,000.00 91282CDG3US TREASURY N/B NOTES DTD 10/31/2021 1.125% 10/31/2026

2.76 4.15
32,556.56 36,796.87 2,907,187.50 96.91 MERRILL 3,000,000.00 912828U24US TREASURY NOTES DTD 11/15/2016 2.000% 11/15/2026

2.77 4.12
Account 73340000 Page 19

Page 42 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
U.S. Treasury Bond / Note
(181,768.62)(182,859.96) 2,720,395.31 93.97 NOMURA 2,895,000.00 91282CDK4US TREASURY N/B NOTES DTD 11/30/2021 1.250% 11/30/2026

2.74 4.22
(92,673.44)(91,723.63) 1,524,960.94 93.84 JPM_CHA 1,625,000.00 91282CDQ1US TREASURY N/B NOTES DTD 12/31/2021 1.250% 12/31/2026

2.74 4.31
11,734.03 13,015.62 3,326,687.50 97.84 CITIGRP 3,400,000.00 912828V98US TREASURY NOTES DTD 02/15/2017 2.250% 02/15/2027

2.76 4.30
29,188.28 32,884.77 3,644,679.69 97.84 MERRILL 3,725,000.00 912828V98US TREASURY NOTES DTD 02/15/2017 2.250% 02/15/2027

2.76 4.30
(9,112,782.52) 2.89 (7,681,307.98) 197,564,136.68 205,555,000.00 Security Type Sub-Total 2.34 Supra-National Agency Bond / Note
(47,540.31)(45,837.69) 1,361,130.81 96.53 TD 1,410,000.00 459058JM6INTL BK RECON & DEVELOP NOTES DTD 11/24/2020 0.250% 11/24/2023

2.95 1.32
(193,936.95)(193,145.93) 3,559,075.37 94.78 JPM_CHA 3,755,000.00 4581X0DZ8INTER-AMERICAN DEVEL BK NOTES DTD 09/23/2021 0.500% 09/23/2024

3.03 2.14
(94,236.04)(121,480.50) 1,455,469.50 97.03 MORGAN_ 1,500,000.00 4581X0DK1INTER-AMERICAN DEVELOPMENT BANK NOTES
DTD 01/16/2020 1.750% 03/14/2025

2.93 2.56
(360,464.12) 2.99 (335,713.30) 6,375,675.68 6,665,000.00 Security Type Sub-Total 2.06 Municipal Bond / Note

0.00 (2,300.00) 500,000.00 100.00 NEW ACC 500,000.00 799055QR2SAN MATEO-FOSTER SCH DIST, CA TXBL GO BO
DTD 05/19/2020 1.162% 08/01/2022

1.16 0.01
(11,071.91)(13,400.00) 489,985.00 98.00 NEW ACC 500,000.00 799055QS0SAN MATEO-FOSTER SCH DIST, CA TXBL GO BO
DTD 05/19/2020 1.266% 08/01/2023

3.31 1.00
(15,700.00) 2.22 (11,071.91) 989,985.00 1,000,000.00 Security Type Sub-Total 0.50 Federal Agency Bond / Note
Account 73340000 Page 20

Page 43 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
Federal Agency Bond / Note
(105,475.98)(106,265.70) 4,154,927.10 97.53 MORGAN_ 4,260,000.00 3135G05G4FANNIE MAE NOTES DTD 07/10/2020 0.250% 07/10/2023

2.92 0.95
(139,428.86)(141,259.20) 4,661,668.80 97.12 KEYBANC 4,800,000.00 3137EAEW5FREDDIE MAC NOTES DTD 09/04/2020 0.250% 09/08/2023

2.92 1.11
(55,375.15)(54,490.10) 1,643,979.90 96.70 CITIGRP 1,700,000.00 3137EAEZ8FREDDIE MAC NOTES DTD 11/05/2020 0.250% 11/06/2023

2.92 1.27
(149,345.10)(146,537.60) 4,248,446.40 96.56 NOMURA 4,400,000.00 3135G06H1FANNIE MAE NOTES DTD 11/25/2020 0.250% 11/27/2023

2.92 1.33
(194,246.58)(197,059.75) 2,704,743.50 93.43 NEW ACC 2,895,000.00 3135G04Z3FANNIE MAE NOTES DTD 06/19/2020 0.500% 06/17/2025

2.89 2.86
(339,452.69)(346,395.00) 4,671,405.00 93.43 HSBC 5,000,000.00 3135G04Z3FANNIE MAE NOTES DTD 06/19/2020 0.500% 06/17/2025

2.89 2.86
(205,686.39)(208,602.00) 2,798,508.00 93.28 NEW ACC 3,000,000.00 3133ELR71FEDERAL FARM CREDIT BANK NOTES DTD 07/02/2020 0.500% 07/02/2025

2.91 2.91
(165,968.31)(165,562.50) 2,333,437.50 93.34 10/21/22NEW ACC 2,500,000.00 3136G4ZJ5FANNIE MAE NOTES (CALLABLE) DTD 07/21/2020 0.625% 07/21/2025

2.98 0.25
(140,742.78)(136,586.00) 1,851,914.00 92.60 NOMURA 2,000,000.00 3135G05X7FANNIE MAE NOTES DTD 08/27/2020 0.375% 08/25/2025

2.91 3.05
(170,066.37)(167,504.40) 2,125,572.60 92.42 CITIGRP 2,300,000.00 3137EAEX3FREDDIE MAC NOTES DTD 09/25/2020 0.375% 09/23/2025

2.91 3.13
(101,614.68)(100,830.60) 1,286,889.80 92.58 BMO 1,390,000.00 3135G06G3FANNIE MAE NOTES DTD 11/12/2020 0.500% 11/07/2025

2.89 3.24
(330,136.41)(328,275.00) 4,166,190.00 92.58 JEFFERI 4,500,000.00 3135G06G3FANNIE MAE NOTES DTD 11/12/2020 0.500% 11/07/2025

2.89 3.24
(2,099,367.85) 2.91 (2,097,539.30) 36,647,682.60 38,745,000.00 Security Type Sub-Total 2.09 Corporate Note
(6,043.01)(19,806.00) 2,999,334.00 99.98 12/09/23NEW ACC 3,000,000.00 037833CG3APPLE INC (CALLABLE) BONDS DTD 02/09/2017 3.000% 02/09/2024

3.01 1.32
(25,050.67)(24,899.82) 634,770.18 96.18 02/18/24CSFB 660,000.00 808513BN4CHARLES SCHWAB CORP NOTES (CALLABLE)
DTD 03/18/2021 0.750% 03/18/2024

3.17 1.54
Account 73340000 Page 21

Page 44 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
Corporate Note
(64,414.48)(63,550.03) 1,389,325.67 95.49 JPM_CHA 1,455,000.00 023135BW5AMAZON.COM INC CORPORATE NOTES DTD 05/12/2021 0.450% 05/12/2024

3.07 1.78
(1,555.55)(1,548.00) 1,998,372.00 99.92 HSBC 2,000,000.00 40428HTA0HSBC USA INC CORPORATE NOTES DTD 05/24/2022 3.750% 05/24/2024

3.79 1.76
(80,045.63)(96,361.95) 1,690,393.05 97.99 06/30/24MORGAN_ 1,725,000.00 025816CG2AMERICAN EXPRESS CO CORP NOTES (CALLABLE
DTD 07/30/2019 2.500% 07/30/2024

3.55 1.86
(22,084.04)(22,084.04) 417,915.96 94.98 08/12/22DEUTSCH 440,000.00 904764BN6UNILEVER CAPITAL CORP (CALLABLE)

CORPORA
DTD 08/12/2021 0.626% 08/12/2024

3.20 0.06
(26,320.65)(26,305.68) 488,647.97 94.88 GOLDMAN 515,000.00 05565EBU8BMW US CAPITAL LLC CORPORATE NOTES DTD 08/12/2021 0.750% 08/12/2024

3.37 2.02
(161,957.97)(221,085.00) 2,419,365.00 96.77 12/20/24US_BANC 2,500,000.00 90331HPL1US BANK NA CINCINNATI (CALLABLE)

CORPORA
DTD 01/21/2020 2.050% 01/21/2025

3.42 2.34
(157,909.82)(219,906.00) 2,924,844.00 97.49 01/14/25US_BANC 3,000,000.00 66989HAP3NOVARTIS CAPITAL CORP DTD 02/14/2020 1.750% 02/14/2025

2.78 2.40
(33,138.86)(33,138.86) 576,861.14 94.57 02/16/24JPM_CHA 610,000.00 46647PBY1JPMORGAN CHASE & CO CORP NOTES (CALLABLE
DTD 02/16/2021 0.563% 02/16/2025

2.79 1.54
(65,528.01)(65,528.01) 2,949,471.99 97.83 02/10/25DEUTSCH 3,015,000.00 771196BT8ROCHE HOLDINGS INC (CALLABLE)

CORPORATE
DTD 03/10/2022 2.132% 03/10/2025

3.00 2.46
(92,529.12)(147,212.80) 1,610,083.20 100.63 03/15/25SUSQ 1,600,000.00 369550BG2GENERAL DYNAMICS CORP (CALLABLE)

CORP NO
DTD 05/11/2018 3.500% 05/15/2025

3.26 2.52
641.64 651.04 445,530.89 100.12 RBC 445,000.00 63743HFE7NATIONAL RURAL UTIL COOP CORPORATE NOTES
DTD 05/04/2022 3.450% 06/15/2025

3.40 2.74
(88,138.98)(88,521.00) 1,413,024.00 94.20 11/03/24MORGAN_ 1,500,000.00 172967ND9CITIGROUP INC CORP NOTE (CALLABLE) DTD 11/03/2021 1.281% 11/03/2025

3.17 2.23
(145,049.53)(144,751.61) 1,539,254.24 91.35 12/28/25MITSU 1,685,000.00 06406RAQ0BANK OF NY MELLON CORP (CALLABLE) CORPOR
DTD 01/28/2021 0.750% 01/28/2026

3.40 3.37
Account 73340000 Page 22

Page 45 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
Corporate Note
(13,731.10)(13,731.10) 291,268.90 95.50 02/26/25GOLDMAN 305,000.00 857477BR3STATE STREET CORP (CALLABLE)

CORPORATE N
DTD 02/07/2022 1.746% 02/06/2026

3.11 2.93
(10,703.60)(4,900.00) 1,909,960.00 95.50 02/26/25GOLDMAN 2,000,000.00 857477BR3STATE STREET CORP (CALLABLE)

CORPORATE N
DTD 02/07/2022 1.746% 02/06/2026

3.11 2.93
(153,636.39)(154,764.50) 1,749,111.50 92.06 MERRILL 1,900,000.00 38141GXS8GOLDMAN SACHS GROUP INC CORPORATE NOTES
DTD 02/12/2021 0.855% 02/12/2026

3.25 3.47
(6,322.92)(3,914.00) 1,954,786.00 97.74 DEUTSCH 2,000,000.00 06051GKM0BANK OF AMERICA CORP NOTES (CALLABLE)
DTD 03/22/2022 3.384% 04/02/2026

4.05 3.44
(651.53)(683.10) 1,099,954.90 100.00 04/26/25CITIGRP 1,100,000.00 46647PCZ7JPMORGAN CHASE & CO (CALLABLE)

CORPORATE
DTD 04/26/2022 4.080% 04/26/2026

4.08 2.59
(149,268.36)(182,151.22) 1,662,710.53 99.27 MORGAN_ 1,675,000.00 459200JZ5IBM CORP DTD 05/15/2019 3.300% 05/15/2026

3.51 3.57
(135,561.61)(137,339.95) 1,546,755.30 92.34 04/28/26MORGAN_ 1,675,000.00 04636NAA1ASTRAZENECA FINANCE LLC (CALLABLE) CORP
DTD 05/28/2021 1.200% 05/28/2026

3.35 3.66
(79,561.18)(79,106.95) 1,023,439.95 92.62 JPM_CHA 1,105,000.00 89236TJK2TOYOTA MOTOR CREDIT CORP

CORPORATE NOTES
DTD 06/18/2021 1.125% 06/18/2026

3.16 3.81
(74,975.78)(84,755.00) 977,565.00 97.76 SUSQ 1,000,000.00 61761J3R8MORGAN STANLEY CORP NOTES DTD 07/25/2016 3.125% 07/27/2026

3.74 3.78
(136,706.35)(132,656.00) 1,838,084.00 91.90 RBC 2,000,000.00 02665WDZ1AMERICAN HONDA FINANCE CORPORATE NOTES
DTD 09/09/2021 1.300% 09/09/2026

3.43 3.99
(133,120.64)(128,654.00) 1,838,986.00 91.95 LOOP 2,000,000.00 14913R2Q9CATERPILLAR FINL SERVICE CORPORATE NOTES
DTD 09/14/2021 1.150% 09/14/2026

3.25 4.02
(73,156.84)(82,324.00) 975,216.00 97.52 07/01/26SUSQ 1,000,000.00 46625HRV4JPMORGAN CHASE & CO CORP NOTES DTD 07/21/2016 2.950% 10/01/2026

3.59 3.69
Account 73340000 Page 23

Page 46 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
Corporate Note
(111,454.84)(110,218.00) 1,878,502.00 93.93 JPM_CHA 2,000,000.00 24422EWA3JOHN DEERE CAPITAL CORP CORPORATE NOTES
DTD 01/10/2022 1.700% 01/11/2027

3.18 4.30
(17,152.47)(17,089.70) 337,306.80 95.02 CITIGRP 355,000.00 87612EBM7TARGET CORP CORPORATE NOTES DTD 01/24/2022 1.950% 01/15/2027

3.16 4.29
(61,197.05)(54,081.60) 1,457,822.40 91.11 02/01/27MORGAN_ 1,600,000.00 438516CE4HONEYWELL INTERNATIONAL (CALLABLE) CORP
DTD 08/16/2021 1.100% 03/01/2027

3.20 4.38
(43,703.94)(33,190.50) 1,916,617.50 91.27 03/02/26GOLDMAN 2,100,000.00 89788MAD4TRUIST FINANCIAL CORP NOTES (CALLABLE)
DTD 03/02/2021 1.267% 03/02/2027

3.33 3.50
8,040.62 13,450.00 1,911,650.00 95.58 02/03/27CSFB 2,000,000.00 808513BY0CHARLES SCHWAB CORP NOTES (CALLABLE)
DTD 03/03/2022 2.450% 03/03/2027

3.50 4.25
43,859.14 46,804.00 1,982,904.00 99.15 03/15/27SCOTIA 2,000,000.00 437076CN0HOME DEPOT INC (CALLABLE) CORPORATE NOTE
DTD 03/28/2022 2.875% 04/15/2027

3.07 4.40
469.79 1,841.00 454,666.00 90.93 05/04/26MERRILL 500,000.00 61772BAB9MORGAN STANLEY CORP NOTES (CALLABLE)
DTD 04/22/2021 1.593% 05/04/2027

3.69 3.65
32,035.83 31,340.16 1,641,747.86 102.93 04/10/27JPM_CHA 1,595,000.00 665859AW4NORTHERN TRUST CORP NOTE (CALLABLE) DTD 05/10/2022 4.000% 05/10/2027

3.33 4.30
8,538.14 8,546.80 408,330.80 102.08 MERRILL 400,000.00 91324PEG3UNITEDHEALTH GROUP INC CORPORATE NOTES
DTD 05/20/2022 3.700% 05/15/2027

3.23 4.41
17,057.45 16,669.80 1,429,157.80 102.08 JPM_CHA 1,400,000.00 91324PEG3UNITEDHEALTH GROUP INC CORPORATE NOTES
DTD 05/20/2022 3.700% 05/15/2027

3.23 4.41
44,834.50 45,534.00 3,019,524.00 100.65 JPM_CHA 3,000,000.00 63254ABE7NATIONAL AUSTRALIA BK/NY CORPORATE NOTES
DTD 06/09/2022 3.905% 06/09/2027

3.76 4.45
(2,229,421.62) 3.33 (2,015,193.81) 56,803,260.53 58,860,000.00 Security Type Sub-Total 3.15 Account 73340000 Page 24

Page 47 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
Certificate of Deposit - FDIC Insured
(616.17)(616.17) 244,383.83 99.75 NEW ACC 245,000.00 949763S64WELLS FARGO BANK NA DTD 01/29/2020 1.900% 01/30/2023

2.41 0.50
(677.42)(677.42) 244,322.58 99.72 NEW ACC 245,000.00 61760A6Q7MORGAN STANLEY PVT BANK DTD 01/30/2020 1.850% 01/30/2023

2.41 0.50
(13,027.38)(13,027.38) 231,972.62 94.68 NEW ACC 245,000.00 29278TQD5ENERBANK USA DTD 07/24/2020 0.450% 07/24/2024

3.22 1.98
(19,945.94)(19,945.94) 225,054.06 91.86 NEW ACC 245,000.00 169894AT9CHIPPEWA VALLEY BANK DTD 07/29/2020 0.500% 07/29/2025

3.36 2.98
(19,612.25)(19,612.25) 225,387.75 92.00 NEW ACC 245,000.00 58404DHQ7MEDALLION BANK UTAH DTD 07/30/2020 0.550% 07/30/2025

3.36 2.98
(53,879.16) 2.94 (53,879.16) 1,171,120.84 1,225,000.00 Security Type Sub-Total 1.75 Certificate of Deposit
(24,233.12)(24,233.12) 2,975,766.88 99.19 TD 3,000,000.00 89114WXU4TORONTO DOMINION BANK NY CERT DEPOS
DTD 05/23/2022 2.800% 05/19/2023

3.81 0.82
(24,233.12) 3.81 (24,233.12) 2,975,766.88 3,000,000.00 Security Type Sub-Total 0.82 Asset-Backed Security
(1,774.35)(1,766.72) 146,693.59 98.80 MITSU 148,475.32 58770GAC4MBALT 2021-A A3 DTD 01/27/2021 0.250% 01/16/2024

1.08 0.42
(6,349.21)(6,340.09) 273,636.61 97.73 SOCGEN 280,000.00 44891TAD8HALST 2021-A A4 DTD 01/20/2021 0.420% 12/16/2024

1.39 0.73
(12,055.69)(12,027.78) 502,894.46 97.65 RBC 515,000.00 36261RAD0GMALT 2021-1 A4 DTD 02/24/2021 0.330% 02/20/2025

1.27 0.82
(12,241.46)(12,238.12) 517,752.18 97.69 JPM_CHA 530,000.00 43813GAC5HAROT 2021-1 A3 DTD 02/24/2021 0.270% 04/21/2025

1.13 0.71
(16,156.27)(16,139.95) 523,803.24 97.00 BARCLAY 540,000.00 44933LAC7HART 2021-A A3 DTD 04/28/2021 0.380% 09/15/2025

1.36 0.99
(8,673.43)(8,655.23) 345,763.98 97.54 DEUTSCH 354,475.64 36261LAC5GMCAR 2021-1 A3 DTD 01/20/2021 0.350% 10/16/2025

1.13 0.72
Account 73340000 Page 25

Page 48 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
Asset-Backed Security
(55,132.09)(55,123.91) 869,841.22 94.04 MITSU 925,000.00 50117XAE2KCOT 2021-2A A3 DTD 07/28/2021 0.560% 11/17/2025

2.44 1.68
(3,076.76)(3,069.47) 116,261.46 97.41 MITSU 119,354.51 14316NAC3CARMX 2021-1 A3 DTD 01/27/2021 0.340% 12/15/2025

1.12 0.75
(31,907.67)(31,881.82) 712,961.13 95.70 MERRILL 745,000.00 43815GAC3HAROT 2021-4 A3 DTD 11/24/2021 0.880% 01/21/2026

2.17 1.59
(23,766.85)(23,720.61) 786,104.84 97.05 MERRILL 810,000.00 14314QAC8CARMX 2021-2 A3 DTD 04/21/2021 0.520% 02/17/2026

1.37 0.91
(56,727.12)(56,675.03) 1,473,073.29 96.28 RBC 1,530,000.00 14317DAC4CARMX 2021-3 A3 DTD 07/28/2021 0.550% 06/15/2026

1.54 1.23
(37,846.26)(37,840.64) 987,119.18 96.30 WELLS_F 1,025,000.00 92868KAC7VALET 2021-1 A3 DTD 12/13/2021 1.020% 06/22/2026

2.01 1.50
(39,805.16)(39,800.40) 1,460,141.85 97.34 MERRILL 1,500,000.00 448977AD0HART 2022-A A3 DTD 03/16/2022 2.220% 10/15/2026

2.89 1.92
(90,633.16)(90,598.53) 1,774,144.47 95.13 BARCLAY 1,865,000.00 14041NFY2COMET 2021-A3 A3 DTD 11/30/2021 1.040% 11/15/2026

2.23 2.23
(20,093.62)(20,088.17) 549,862.30 96.47 BNP_PAR 570,000.00 380146AC4GMCAR 2022-1 A3 DTD 01/19/2022 1.260% 11/16/2026

2.12 1.27
(415,966.47) 1.93 (416,239.10) 11,040,053.80 11,457,305.47 Security Type Sub-Total 1.45 326,507,305.47 313,567,682.01 (14,311,814.86) (12,635,177.68) 2.95 Managed Account Sub-Total 2.40 Total Investments $314,587,943.42
$1,020,261.41
$313,567,682.01
Accrued Interest
Securities Sub-Total $326,507,305.47 ($14,311,814.86) ($12,635,177.68) 2.95% 2.40 Account 73340000 Page 26

Page 49 ends

For the Month Ending July 31, 2022Managed Account Security Transactions & Interest

CITY OF RANCHO CUCAMONGA -
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
BUY
07/07/22 US TREASURY N/B NOTES
DTD 05/15/2022 2.750% 05/15/2025
91282CEQ0 (3,989,218.75) (15,842.39) (4,005,061.14) 4,000,000.00 07/05/22 07/07/22 US TREASURY NOTES
DTD 02/15/2017 2.250% 02/15/2027
912828V98 (3,313,671.88) (30,008.29) (3,343,680.17) 3,400,000.00 07/05/22 (45,850.68) (7,348,741.31)(7,302,890.63) 7,400,000.00 Transaction Type Sub-Total

INTEREST
07/01/22 MONEY MARKET FUND MONEY0002 0.00 308.75 308.75 0.00 07/01/22 07/02/22 FEDERAL FARM CREDIT BANK NOTES
DTD 07/02/2020 0.500% 07/02/2025
3133ELR71 0.00 7,500.00 7,500.00 3,000,000.00 07/02/22 07/10/22 FANNIE MAE NOTES
DTD 07/10/2020 0.250% 07/10/2023
3135G05G4 0.00 5,325.00 5,325.00 4,260,000.00 07/10/22 07/11/22 JOHN DEERE CAPITAL CORP

CORPORATE NOTES
DTD 01/10/2022 1.700% 01/11/2027
24422EWA3 0.00 17,094.44 17,094.44 2,000,000.00 07/11/22 07/15/22 COMET 2021-A3 A3
DTD 11/30/2021 1.040% 11/15/2026
14041NFY2 0.00 1,616.33 1,616.33 1,865,000.00 07/15/22 07/15/22 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
44933LAC7 0.00 171.00 171.00 540,000.00 07/15/22
07/15/22 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
14316NAC3 0.00 34.00 34.00 120,000.00 07/15/22
07/15/22 CARMX 2021-3 A3
DTD 07/28/2021 0.550% 06/15/2026
14317DAC4 0.00 701.25 701.25 1,530,000.00 07/15/22
07/15/22 KCOT 2021-2A A3
DTD 07/28/2021 0.560% 11/17/2025
50117XAE2 0.00 431.67 431.67 925,000.00 07/15/22
07/15/22 CARMX 2021-2 A3
DTD 04/21/2021 0.520% 02/17/2026
14314QAC8 0.00 351.00 351.00 810,000.00 07/15/22
07/15/22 HALST 2021-A A4
DTD 01/20/2021 0.420% 12/16/2024
44891TAD8 0.00 98.00 98.00 280,000.00 07/15/22
07/15/22 MBALT 2021-A A3
DTD 01/27/2021 0.250% 01/16/2024
58770GAC4 0.00 33.97 33.97 163,054.31 07/15/22
07/15/22 US TREASURY N/B NOTES
DTD 07/15/2021 0.375% 07/15/2024
91282CCL3 0.00 9,375.00 9,375.00 5,000,000.00 07/15/22 Account 73340000 Page 27

Page 50 ends

For the Month Ending July 31, 2022Managed Account Security Transactions & Interest

CITY OF RANCHO CUCAMONGA -
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method

INTEREST
07/15/22 TARGET CORP CORPORATE NOTES
DTD 01/24/2022 1.950% 01/15/2027
87612EBM7 0.00 3,288.19 3,288.19 355,000.00 07/15/22 07/15/22 HART 2022-A A3
DTD 03/16/2022 2.220% 10/15/2026
448977AD0 0.00 2,775.00 2,775.00 1,500,000.00 07/15/22 07/16/22 GMCAR 2022-1 A3
DTD 01/19/2022 1.260% 11/16/2026
380146AC4 0.00 598.50 598.50 570,000.00 07/16/22
07/16/22 GMCAR 2021-1 A3
DTD 01/20/2021 0.350% 10/16/2025
36261LAC5 0.00 109.38 109.38 375,000.00 07/16/22
07/20/22 GMALT 2021-1 A4
DTD 02/24/2021 0.330% 02/20/2025
36261RAD0 0.00 141.63 141.63 515,000.00 07/20/22
07/20/22 VALET 2021-1 A3
DTD 12/13/2021 1.020% 06/22/2026
92868KAC7 0.00 871.25 871.25 1,025,000.00 07/20/22
07/21/22 HAROT 2021-4 A3
DTD 11/24/2021 0.880% 01/21/2026
43815GAC3 0.00 546.33 546.33 745,000.00 07/21/22
07/21/22 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
43813GAC5 0.00 119.25 119.25 530,000.00 07/21/22
07/21/22 US BANK NA CINCINNATI (CALLABLE)

CORPORA
DTD 01/21/2020 2.050% 01/21/2025
90331HPL1 0.00 25,625.00 25,625.00 2,500,000.00 07/21/22 07/21/22 FANNIE MAE NOTES (CALLABLE)
DTD 07/21/2020 0.625% 07/21/2025
3136G4ZJ5 0.00 7,812.50 7,812.50 2,500,000.00 07/21/22 07/24/22 ENERBANK USA
DTD 07/24/2020 0.450% 07/24/2024
29278TQD5 0.00 90.62 90.62 245,000.00 07/24/22
07/27/22 MORGAN STANLEY CORP NOTES
DTD 07/25/2016 3.125% 07/27/2026
61761J3R8 0.00 15,625.00 15,625.00 1,000,000.00 07/27/22 07/28/22 BANK OF NY MELLON CORP (CALLABLE)
CORPOR
DTD 01/28/2021 0.750% 01/28/2026
06406RAQ0 0.00 6,318.75 6,318.75 1,685,000.00 07/28/22 07/29/22 WELLS FARGO BANK NA
DTD 01/29/2020 1.900% 01/30/2023
949763S64 0.00 382.60 382.60 245,000.00 07/29/22
07/29/22 CHIPPEWA VALLEY BANK
DTD 07/29/2020 0.500% 07/29/2025
169894AT9 0.00 100.68 100.68 245,000.00 07/29/22
07/30/22 MORGAN STANLEY PVT BANK
DTD 01/30/2020 1.850% 01/30/2023
61760A6Q7 0.00 2,247.62 2,247.62 245,000.00 07/30/22 Account 73340000 Page 28

Page 51 ends

For the Month Ending July 31, 2022Managed Account Security Transactions & Interest

CITY OF RANCHO CUCAMONGA -
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method

INTEREST
07/30/22 MEDALLION BANK UTAH
DTD 07/30/2020 0.550% 07/30/2025
58404DHQ7 0.00 110.75 110.75 245,000.00 07/30/22
07/30/22 AMERICAN EXPRESS CO CORP NOTES
(CALLABLE
DTD 07/30/2019 2.500% 07/30/2024
025816CG2 0.00 21,562.50 21,562.50 1,725,000.00 07/30/22 07/31/22 US TREASURY N/B NOTES
DTD 07/31/2021 0.625% 07/31/2026
91282CCP4 0.00 15,625.00 15,625.00 5,000,000.00 07/31/22 07/31/22 US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
91282CBH3 0.00 12,646.88 12,646.88 6,745,000.00 07/31/22 07/31/22 US TREASURY N/B NOTES
DTD 07/31/2021 0.125% 07/31/2023
91282CCN9 0.00 3,750.00 3,750.00 6,000,000.00 07/31/22 07/31/22 US TREASURY NOTES
DTD 07/31/2019 1.750% 07/31/2024
912828Y87 0.00 49,612.50 49,612.50 5,670,000.00 07/31/22 07/31/22 US TREASURY N/B NOTES
DTD 01/31/2022 0.875% 01/31/2024
91282CDV0 0.00 21,875.00 21,875.00 5,000,000.00 07/31/22 07/31/22 US TREASURY NOTES
DTD 07/31/2020 0.250% 07/31/2025
91282CAB7 0.00 18,625.00 18,625.00 14,900,000.00 07/31/22 253,500.34 253,500.34 0.00 80,058,054.31 Transaction Type Sub-Total

PAYDOWNS
07/15/22 MBALT 2021-A A3
DTD 01/27/2021 0.250% 01/16/2024
58770GAC4 14,578.99 0.00 14,578.99 1.47 0.00 14,578.99 07/15/22 07/15/22 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
14316NAC3 645.49 0.00 645.49 0.13 0.00 645.49 07/15/22 07/16/22 GMCAR 2021-1 A3
DTD 01/20/2021 0.350% 10/16/2025
36261LAC5 20,524.36 0.00 20,524.36 3.27 0.00 20,524.36 07/16/22

0.00 0.00 4.87 35,748.84 35,748.84 35,748.84 Transaction Type Sub-Total SELL
07/07/22 US TREASURY NOTES
DTD 02/29/2016 1.500% 02/28/2023
912828P79 4,218,623.05 22,347.15 4,240,970.20 (152,900.39) (68,964.80) FIFO 4,250,000.00 07/05/22 22,347.15 (68,964.80)(152,900.39) 4,240,970.20 4,218,623.05 4,250,000.00 Transaction Type Sub-Total Account 73340000 Page 29

Page 52 ends

For the Month Ending July 31, 2022Managed Account Security Transactions & Interest

CITY OF RANCHO CUCAMONGA -
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
(3,048,518.74) 229,996.81 (2,818,521.93) (152,895.52) (68,964.80)Managed Account Sub-Total Total Security Transactions ($152,895.52)($2,818,521.93)$229,996.81 ($3,048,518.74) ($68,964.80) Account 73340000 Page 30

Page 53 ends

Trustee and/or Purchase Maturity Cost
Bond Issue/Description Paying Agent Account Name Trust Account # Fund Investment Date Date* Yield Value CFD 2003-01 Improvement Area 1 (2013) Wells Fargo Reserve Fund 46571801 865 Money Market Fund 9/1/2013 N/A 0.01% 1,418,037.66 $ Agency Project 46571807 614 Money Market Fund 9/1/2013 N/A 0.01% 77,872.67 $ Cultural Center Fund 46571808 615 Money Market Fund 9/1/2013 N/A 0.01% 191,994.36 $ Bond Fund 46571800 864 Money Market Fund 9/1/2013 N/A 0.01% 71.91 $ Developer Project 46571806 614 Money Market Fund 9/1/2013 N/A 0.01% 98,169.36 $ Special Tax 46571805 864 Money Market Fund 9/1/2013 N/A 0.01% 0.55 $ 1,786,146.51$
CFD 2003-01 Improvement Area 2 (2013) Wells Fargo Bond Fund 46659800 866 Money Market Fund 12/1/2013 N/A 0.01% 6.77 $ Reserve Fund 46659801 867 Money Market Fund 12/1/2013 N/A 0.01% 132,570.71 $ Special Tax Fund 46659805 866 Money Market Fund 12/1/2013 N/A 0.01% 0.09 $ 132,577.57$
CFD No 2004-01 Rancho Etiwanda Series Wells Fargo Admin Expense Fund 48436802 Money Market Fund N/A 0.01% - $ Bond Fund 48436800 820 Money Market Fund N/A 0.01% 60.77 Reserve Fund 48436801 821 Money Market Fund N/A 0.01% 1,188,235.50 Special Tax Fund 48436807 820 Money Market Fund N/A 1.05 Project Fund 48436809 617 Money Market Fund N/A 45,016.15 1,233,313.47$
2014 Rancho Summit Wells Fargo Cost of Issuance Fund 48709906 Money Market Fund N/A - $ Bond Fund 48709900 858 Money Market Fund N/A 1,290.73
Reserve Fund 48709901 859 Money Market Fund N/A 259,667.01 Sepcial Tax Fund 48709907 858 Money Market Fund N/A 0.20 Rebate Fund 48709908 Money Market Fund N/A -
Redemption Fund 48709903 Money Market Fund N/A -
Prepayment Fund 48709904 Money Market Fund N/A -
260,957.94$
2019 Lease Revenue Bonds Wells Fargo Bond Fund 82631600 711 Money Market Fund 2/28/2019 N/A - $ Interest 82631601 711 Money Market Fund 2/28/2019 N/A - Principal 82631602 711 Money Market Fund 2/28/2019 N/A - Acquisition and Construciton - Series A 82631605 711 Money Market Fund 2/28/2019 N/A 3,220.55 Acquisition and Construciton - Series B 82631606 711 Money Market Fund 2/28/2019 N/A 1,040.43 Cost of Issuance 82631607 711 Money Market Fund 2/28/2019 N/A - 4,260.98$

CFD No. 2000-01 South Etiwanda Union Bank Rancho Cucamonga 2015 CFD2000-1 AGY 6712140200 7/30/2015 N/A - $ Special Tax Fund 6712140201 852 Money Market Fund 7/30/2015 N/A 0.11 Bond Fund 6712140202 852 Money Market Fund 7/30/2015 N/A (0.00) Prepayment Fund 6712140203 Money Market Fund 7/30/2015 N/A - Reserve Fund 6712140204 853 Money Market Fund 7/30/2015 N/A 0.00% 22,772.41 22,772.52$
City of Rancho Cucamonga
Summary of Cash and Investments with Fiscal Agents
For the Month Ended
7/31/2022
I:\FINANCE\SALINA\Fiscal Agent Stmts\_Fiscal Agent Statements Workbook Template.xlsx Summary Report Page 1
 
 

Page 54 ends

Trustee and/or Purchase Maturity Cost
Bond Issue/Description Paying Agent Account Name Trust Account # Fund Investment Date Date* Yield Value City of Rancho Cucamonga
Summary of Cash and Investments with Fiscal Agents
For the Month Ended
7/31/2022
CFD No. 2000-02 Rancho Cucamonga Corporate Park Union Bank Rancho Cucamonga 2015 CFD2000-2 AGY 6712140300 Money Market Fund 7/30/201 5 N/A - $ Special Tax Fund 6712140301 856 Money Market Fund 7/30/2015 N/A 0.97 $ Bond Fund 6712140302 856 Money Market Fund 7/30/2015 N/A (0.00) $ Prepayment Fund 6712140303 Money Market Fund 7/30/2015 N/A - $ Reserve Fund 6712140304 857 Money Market Fund 7/30/2015 N/A 0.00% 209,105.78 209,106.75$
CFD No. 2001-01 IA 1&2, Series A Union Bank Rancho Cucamonga 2015 CFD2001-1 AGY 6712140400 Money Market Fund 7/30/2015 N/A - $ Special Tax Fund 6712140401 860 Money Market Fund 7/30/2015 N/A 1.49 Bond Fund 6712140402 860 Money Market Fund 7/30/2015 N/A (0.00) Prepayment Fund 6712140403 Money Market Fund 7/30/2015 N/A - Reserve Fund 6712140404 861 Money Market Fund 7/30/2015 N/A 0.00% 303,837.27 303,838.76$
CFD No. 2001-01 IA3, Series B Union Bank Rancho Cucamonga 2015 CFD2001-1 AGY 6712140500 Money Market Fund 7/30/2015 N/A - $ Special Tax Fund 6712140501 862 Money Market Fund 7/30/2015 N/A 0.14 Bond Fund 6712140502 862 Money Market Fund 7/30/2015 N/A (0.00) Prepayment Fund 6712140503 Money Market Fund 7/30/2015 N/A - Reserve Fund 6712140504 863 Money Market Fund 7/30/2015 N/A 0.00% 29,499.29 29,499.43$
CFD No. 2006-01 Vintner's Grove Union Bank Rancho Cucamonga 2015 CFD2006-1 AGY 6712140600 Money Market Fund 7/30/2015 N/A - $ Special Tax Fund 6712140601 869 Money Market Fund 7/30/2015 N/A 6.26 Bond Fund 6712140602 869 Money Market Fund 7/30/2015 N/A 0.00 Prepayment Fund 6712140603 Money Market Fund 7/30/2015 N/A - Reserve Fund 6712140604 870 Money Market Fund 7/30/2015 N/A 0.00% 130,595.33 130,601.59$
CFD No. 2006-02 Amador on Rt. 66 Union Bank Rancho Cucamonga 2015 CFD2006-2 AGY 6712140700 Money Market Fund 7/30/2015 N/A - $ Special Tax Fund 6712140701 871 Money Market Fund 7/30/2015 N/A 3.78 Bond Fund 6712140702 871 Money Market Fund 7/30/2015 N/A 0.00 Prepayment Fund 6712140703 Money Market Fund 7/30/2015 N/A - Reserve Fund 6712140704 872 Money Market Fund 7/30/2015 N/A 0.00% 78,358.72 78,362.50$
4,191,438.02
TOTAL CASH AND INVESTMENTS WITH FISCAL AGENTS 4,191,438.02$ * Note: These investments are money market accounts which have no stated maturity date as they may be liquidated upon demand.

I:\FINANCE\SALINA\Fiscal Agent Stmts\_Fiscal Agent Statements Workbook Template.xlsx Summary Report Page 2
 
 

Page 55 ends

Page 56 ends

For the Month Ending July 31, 2022
Account Statement
Consolidated Summary Statement

RANCHO CUCAMONGA FIRE PROTECTION DISTRICT
Investment Allocation
Investment Type Closing Market Value Percent
548,101.83 0.70 Asset-Backed Security
7,924,268.60 10.15 Corporate Note
457,360.37 0.59 Certificate of Deposit - FDIC Insured
1,906,009.67 2.44 Supra-National Agency Bond / Note
48,502,712.11 62.14 U.S. Treasury Bond / Note
18,380,859.69 23.55 Local Agency Investment Fund
334,751.45 0.43 Passbook/Checking Accounts
$78,054,063.72 Total 100.00%
Portfolio Summary
and Income
Closing
Market ValuePortfolio Holdings
Cash Dividends
PFMAM Managed Account (43,294.87) 59,338,452.58
Local Agency Investment Fund 0.00 18,380,859.69
Passbook/Checking Accounts 0.00 334,751.45
($43,294.87) $78,054,063.72 Total
Maturity Distribution (Fixed Income Holdings)
Portfolio Holdings Closing Market Value Percent
18,715,611.14

0.00 0.00
832,912.50
4,835,307.82
18,587,353.71
13,754,813.17
12,691,335.52
8,636,729.86

0.00 23.98

0.00 0.00

1.07 6.19

23.81 17.62

16.26 11.07

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 $78,054,063.72
701
100.00%
Weighted Average Days to Maturity
Sector Allocation

0.70%
ABS

10.15%
Corporate Note

0.59%
Cert of Deposit -
FDIC

2.44%
Supra-National
Agency Bond / Note

62.14%
US TSY Bond / Note

23.55%
Local Agency
Investment Fund

0.43%
Passbook/Checking
Accounts
Summary Page 1

Page 57 ends

For the Month Ending July 31, 2022Managed Account Summary Statement

CITY OF RANCHO CUCAMONGA, FIRE PROT DIST -
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)
$58,731,780.93

0.00 (1,293,735.35)
1,495,957.03

0.00 404,449.97
$59,338,452.58
31,392.32
(5,940.90)
(68,746.29)
($43,294.87)
Total
60,942,635.90
186,268.62
1,297,335.52

0.00 27,792.15
(1,501,897.93)
(60,753,400.24)
(144,416.80)
Total Accrual Basis Earnings $54,317.22
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

0.00 1,297,335.52
27,792.15

0.00 (1,501,897.93)

0.00 0.00
Cash Balance
$35,255.78 Closing Cash Balance
Account 73340100 Page 1

Page 58 ends

For the Month Ending July 31, 2022Portfolio Summary and Statistics

CITY OF RANCHO CUCAMONGA, FIRE PROT DIST -
Account Summary
Percent Par Value Market ValueDescription
U.S. Treasury Bond / Note 50,435,000.00 48,502,712.11 81.75 Supra-National Agency Bond / Note 2,060,000.00 1,906,009.67 3.21 Corporate Note 8,150,000.00 7,924,268.60 13.35
Certificate of Deposit - FDIC Insured 490,000.00 457,360.37 0.77 Asset-Backed Security 570,000.00 548,101.83 0.92
Managed Account Sub-Total 61,705,000.00 59,338,452.58 100.00% Accrued Interest 186,268.62
Total Portfolio 61,705,000.00 59,524,721.20
Unsettled Trades 0.00 0.00
Sector Allocation

0.92%
ABS

0.77%
Cert of Deposit -
FDIC

13.35%
Corporate Note

3.21%
Supra-National
Agency Bond / Note

81.75%
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

1.40%

8.15%

31.32%

23.18%

21.39%

14.56%

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

1.69%

2.97%
Account 73340100 Page 2

Page 59 ends

For the Month Ending July 31, 2022Managed Account Issuer Summary

CITY OF RANCHO CUCAMONGA, FIRE PROT DIST -
Credit Quality (S&P Ratings)

3.54%
A

1.80%
A+

4.02%
A-

1.04%
AA

81.73%
AA+

0.68%
AA-

4.02%
AAA

2.29%
BBB+

0.88%
NR
Issuer Summary
Percentof HoldingsIssuer
Market Value
347,530.13 0.59 AMAZON.COM INC
478,009.13 0.81 AMERICAN EXPRESS CO
183,808.40 0.31 AMERICAN HONDA FINANCE
138,515.40 0.23 ASTRAZENECA PLC
413,948.58 0.70 BANK OF AMERICA CO
266,820.13 0.45 BERKSHIRE HATHAWAY INC
171,231.10 0.29 CAPITAL ONE FINANCIAL CORP
442,884.64 0.75 CATERPILLAR INC
286,747.50 0.48 CHARLES SCHWAB
538,072.20 0.91 CITIGROUP INC
187,850.20 0.32 DEERE & COMPANY
231,972.62 0.39 ENERBANK USA
57,880.24 0.10 GM FINANCIAL CONSUMER AUTOMOBILE TRUST
340,323.00 0.57 GOLDMAN SACHS GROUP INC
66,989.64 0.11 HONDA AUTO RECEIVABLES
255,118.92 0.43 HONEYWELL INTERNATIONAL
329,731.38 0.56 HSBC HOLDINGS PLC
150,881.32 0.25 HYUNDAI AUTO RECEIVABLES
266,596.83 0.45 IBM CORP
345,955.40 0.58 INTER-AMERICAN DEVELOPMENT BANK
1,560,054.27 2.62 INTL BANK OF RECONSTRUCTION AND DEV
337,152.50 0.57 JP MORGAN CHASE & CO
225,387.75 0.38 MEDALLION BANK UTAH
389,313.24 0.66 MORGAN STANLEY
402,603.20 0.68 NATIONAL AUSTRALIA BANK LTD
75,089.48 0.13 NATIONAL RURAL UTILITIES CO FINANCE CORP 411,723.60 0.69 NORTHERN TRUST
319,918.30 0.54 STATE STREET CORPORATION
175,779.60 0.30 TARGET CORP
430,757.70 0.73 THE BANK OF NEW YORK MELLON CORPORATION 333,428.40 0.56 TOYOTA MOTOR CORP
250,985.63 0.42 TRUIST FIN CORP
Account 73340100 Page 3

Page 60 ends

For the Month Ending July 31, 2022Managed Account Issuer Summary

CITY OF RANCHO CUCAMONGA, FIRE PROT DIST -
Percentof HoldingsIssuer
Market Value
48,502,712.11 81.73 UNITED STATES TREASURY
321,560.51 0.54 UNITEDHEALTH GROUP INC
101,119.53 0.17 VOLKSWAGEN OF AMERICA
$59,338,452.58 Total 100.00%
Account 73340100 Page 4

Page 61 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

US TREASURY NOTES
DTD 11/30/2020 0.125% 11/30/2022
832,912.50 840,035.90 177.87 840,164.06 05/26/2105/25/21AaaAA+ 840,000.00 91282CAX9 0.11

US TREASURY NOTES
DTD 04/30/2018 2.750% 04/30/2023
598,781.28 603,024.50 4,169.84 603,914.06 05/13/2205/12/22AaaAA+ 600,000.00 9128284L1 2.06

US TREASURY NOTES
DTD 05/31/2018 2.750% 05/31/2023
997,968.80 1,021,481.83 4,658.47 1,052,109.38 05/26/2105/25/21AaaAA+ 1,000,000.00 9128284S6 0.16

US TREASURY NOTES
DTD 05/31/2016 1.625% 05/31/2023
1,483,359.30 1,511,998.71 4,129.10 1,520,156.25 01/07/2201/06/22AaaAA+ 1,500,000.00 912828R69 0.66

US TREASURY NOTES
DTD 06/30/2016 1.375% 06/30/2023
783,323.44 799,168.24 950.54 801,521.48 01/25/2201/24/22AaaAA+ 795,000.00 912828S35 0.80

US TREASURY N/B NOTES
DTD 07/31/2021 0.125% 07/31/2023
971,875.00 999,171.73 3.40 998,359.38 08/09/2108/06/21AaaAA+ 1,000,000.00 91282CCN9 0.21

US TREASURY N/B NOTES
DTD 08/31/2021 0.125% 08/31/2023
770,901.56 794,291.34 415.86 793,695.70 09/03/2109/02/21AaaAA+ 795,000.00 91282CCU3 0.21

US TREASURY NOTES
DTD 09/30/2021 0.250% 09/30/2023
2,228,484.26 2,242,579.42 1,932.38 2,228,933.59 04/22/2204/21/22AaaAA+ 2,300,000.00 91282CDA6 2.45

US TREASURY N/B NOTES
DTD 10/31/2021 0.375% 10/31/2023
769,907.81 793,597.54 753.41 792,764.06 11/03/2111/01/21AaaAA+ 795,000.00 91282CDD0 0.52

US TREASURY N/B NOTES
DTD 10/31/2021 0.375% 10/31/2023
968,437.50 975,408.12 947.69 971,093.75 05/13/2205/12/22AaaAA+ 1,000,000.00 91282CDD0 2.40

US TREASURY NOTES
DTD 11/30/2018 2.875% 11/30/2023
2,256,821.99 2,339,593.34 11,006.69 2,410,342.97 05/26/2105/25/21AaaAA+ 2,260,000.00 9128285P1 0.22

US TREASURY N/B NOTES
DTD 12/31/2021 0.750% 12/31/2023
1,938,437.60 1,996,368.76 1,304.35 1,994,921.88 01/07/2201/06/22AaaAA+ 2,000,000.00 91282CDR9 0.88

US TREASURY NOTES
DTD 01/15/2021 0.125% 01/15/2024
959,687.50 992,905.89 57.74 989,492.19 11/18/2111/17/21AaaAA+ 1,000,000.00 91282CBE0 0.62

US TREASURY NOTES
DTD 03/15/2021 0.250% 03/15/2024
1,436,015.70 1,483,221.33 1,416.44 1,477,382.81 01/07/2201/06/22AaaAA+ 1,500,000.00 91282CBR1 0.95 Account 73340100 Page 5

Page 62 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

US TREASURY N/B NOTES
DTD 04/30/2022 2.500% 04/30/2024
1,855,682.91 1,868,395.28 11,814.54 1,868,246.88 06/03/2206/01/22AaaAA+ 1,870,000.00 91282CEK3 2.55

US TREASURY N/B NOTES
DTD 05/15/2021 0.250% 05/15/2024
1,883,039.06 1,972,724.87 1,046.54 1,971,219.73 05/26/2105/25/21AaaAA+ 1,975,000.00 91282CCC3 0.31

US TREASURY N/B NOTES
DTD 06/15/2021 0.250% 06/15/2024
323,531.25 339,344.34 109.15 338,990.63 07/28/2107/26/21AaaAA+ 340,000.00 91282CCG4 0.35

US TREASURY NOTES
DTD 06/30/2019 1.750% 06/30/2024
655,762.50 659,126.84 1,019.57 657,882.42 05/13/2205/12/22AaaAA+ 670,000.00 9128286Z8 2.63

US TREASURY N/B NOTES
DTD 07/15/2021 0.375% 07/15/2024
280,941.42 292,786.14 51.10 291,992.38 11/18/2111/17/21AaaAA+ 295,000.00 91282CCL3 0.76

US TREASURY N/B NOTES
DTD 07/15/2021 0.375% 07/15/2024
1,428,515.70 1,480,810.04 259.85 1,475,273.44 01/07/2201/06/22AaaAA+ 1,500,000.00 91282CCL3 1.04

US TREASURY NOTES
DTD 08/31/2019 1.250% 08/31/2024
1,609,326.56 1,612,060.17 8,709.58 1,605,033.99 04/22/2204/21/22AaaAA+ 1,665,000.00 912828YE4 2.84

US TREASURY NOTES
DTD 11/30/2019 1.500% 11/30/2024
1,937,812.40 2,048,988.76 5,081.97 2,073,828.13 05/26/2105/25/21AaaAA+ 2,000,000.00 912828YV6 0.44

US TREASURY NOTES
DTD 12/31/2019 1.750% 12/31/2024
486,875.00 508,583.53 760.87 510,605.47 01/05/2201/03/22AaaAA+ 500,000.00 912828YY0 1.03

US TREASURY NOTES
DTD 12/31/2019 1.750% 12/31/2024
1,071,125.00 1,075,672.39 1,673.91 1,074,046.88 06/03/2206/01/22AaaAA+ 1,100,000.00 912828YY0 2.70

US TREASURY N/B NOTES
DTD 01/15/2022 1.125% 01/15/2025
1,917,500.00 1,916,641.18 1,039.40 1,907,265.63 04/22/2204/21/22AaaAA+ 2,000,000.00 91282CDS7 2.90

US TREASURY N/B NOTES
DTD 02/15/2022 1.500% 02/15/2025
966,250.00 969,321.54 6,919.89 966,679.69 05/13/2205/12/22AaaAA+ 1,000,000.00 91282CDZ1 2.76

US TREASURY NOTES
DTD 04/30/2020 0.375% 04/30/2025
934,687.50 937,305.27 947.69 932,304.69 05/13/2205/12/22AaaAA+ 1,000,000.00 912828ZL7 2.77

US TREASURY N/B NOTES
DTD 05/15/2022 2.750% 05/15/2025
1,495,781.25 1,496,053.94 8,743.21 1,495,957.03 07/07/2207/05/22AaaAA+ 1,500,000.00 91282CEQ0 2.85 Account 73340100 Page 6

Page 63 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

US TREASURY NOTES
DTD 05/31/2020 0.250% 05/31/2025
1,324,804.69 1,412,240.17 603.48 1,406,909.18 05/26/2105/25/21AaaAA+ 1,425,000.00 912828ZT0 0.57

US TREASURY NOTES
DTD 08/31/2020 0.250% 08/31/2025
2,309,375.00 2,420,583.77 2,615.49 2,406,054.69 01/07/2201/06/22AaaAA+ 2,500,000.00 91282CAJ0 1.31

US TREASURY NOTES
DTD 10/31/2020 0.250% 10/31/2025
920,468.80 921,428.29 631.79 916,132.81 05/13/2205/12/22AaaAA+ 1,000,000.00 91282CAT8 2.81

US TREASURY NOTES
DTD 11/30/2020 0.375% 11/30/2025
1,384,687.50 1,384,319.13 952.87 1,378,710.94 06/03/2206/01/22AaaAA+ 1,500,000.00 91282CAZ4 2.82

US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
459,687.50 494,371.26 5.10 492,910.16 09/03/2109/01/21AaaAA+ 500,000.00 91282CBH3 0.70

US TREASURY NOTES
DTD 02/28/2019 2.500% 02/28/2026
494,843.75 494,662.63 5,230.98 494,335.94 05/13/2205/12/22AaaAA+ 500,000.00 9128286F2 2.82

US TREASURY N/B NOTES
DTD 04/30/2021 0.750% 04/30/2026
649,468.75 698,981.16 1,326.77 698,660.16 05/27/2105/25/21AaaAA+ 700,000.00 91282CBW0 0.79

US TREASURY NOTES
DTD 05/16/2016 1.625% 05/15/2026
575,156.28 596,885.71 2,066.58 596,554.69 03/07/2203/03/22AaaAA+ 600,000.00 912828R36 1.77

US TREASURY NOTES
DTD 05/31/2019 2.125% 05/31/2026
976,718.80 1,053,690.23 3,599.73 1,067,851.56 07/28/2107/26/21AaaAA+ 1,000,000.00 9128286X3 0.70

US TREASURY N/B NOTES
DTD 06/30/2021 0.875% 06/30/2026
557,812.50 587,299.60 456.52 585,468.75 01/07/2201/06/22AaaAA+ 600,000.00 91282CCJ8 1.44

US TREASURY NOTES
DTD 08/15/2016 1.500% 08/15/2026
1,902,500.00 1,885,862.40 13,839.78 1,878,046.88 04/22/2204/21/22AaaAA+ 2,000,000.00 9128282A7 3.02

US TREASURY N/B NOTES
DTD 09/30/2021 0.875% 09/30/2026
1,389,375.00 1,385,495.26 4,410.86 1,379,472.66 05/13/2205/12/22AaaAA+ 1,500,000.00 91282CCZ2 2.84

US TREASURY N/B NOTES
DTD 10/31/2021 1.125% 10/31/2026
289,850.00 308,804.13 881.35 308,595.31 11/03/2111/01/21AaaAA+ 310,000.00 91282CDG3 1.22

US TREASURY N/B NOTES
DTD 10/31/2021 1.125% 10/31/2026
935,000.00 994,802.61 2,843.07 993,945.31 11/18/2111/17/21AaaAA+ 1,000,000.00 91282CDG3 1.25 Account 73340100 Page 7

Page 64 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

US TREASURY NOTES
DTD 02/15/2017 2.250% 02/15/2027
489,218.75 487,422.90 5,189.92 486,816.41 05/13/2205/12/22AaaAA+ 500,000.00 912828V98 2.85 124,755.34 48,502,712.11 49,697,510.19 1.57 49,734,644.00 50,435,000.00 Security Type Sub-Total Supra-National Agency Bond / Note

INTER-AMERICAN DEVEL BK NOTES
DTD 09/23/2021 0.500% 09/23/2024
345,955.40 364,806.79 648.89 364,729.90 09/23/2109/15/21AaaAAA 365,000.00 4581X0DZ8 0.52

INTL BK RECON & DEVELOP NOTES
(CALLABLE)
DTD 02/10/2021 0.650% 02/10/2026
1,560,054.27 1,683,561.57 5,233.31 1,679,728.05 05/26/2105/25/21AaaAAA 1,695,000.00 459058JS3 0.85 5,882.20 1,906,009.67 2,048,368.36 0.79 2,044,457.95 2,060,000.00 Security Type Sub-Total Corporate Note

HSBC USA INC CORPORATE NOTES
DTD 05/24/2022 3.750% 05/24/2024
329,731.38 329,988.05 2,303.13 329,986.80 05/24/2205/17/22A1A- 330,000.00 40428HTA0 3.75

AMERICAN EXPRESS CO CORP NOTES
(CALLABLE
DTD 07/30/2019 2.500% 07/30/2024
269,482.95 282,243.85 19.10 284,845.00 11/23/2111/19/21A2BBB+ 275,000.00 025816CG2 1.14

MORGAN STANLEY CORP NOTES
(CALLABLE)
DTD 04/20/2022 3.620% 04/17/2025
223,137.45 224,455.13 2,285.13 224,412.75 05/16/2205/12/22A1A- 225,000.00 61747YEQ4 3.71

BANK OF NY MELLON CORP (CALLABLE)
CORP N
DTD 04/26/2022 3.350% 04/25/2025
249,185.50 250,358.92 2,210.07 250,387.50 05/16/2205/12/22A1A 250,000.00 06406RBC0 3.29

BANK OF AMERICA CORP NOTES
(CALLABLE)
DTD 04/27/2022 3.841% 04/25/2025
249,112.75 250,436.33 2,507.32 250,470.00 05/16/2205/12/22A2A- 250,000.00 06051GKS7 3.77

CATERPILLAR FINL SERVICE CORPORATE
NOTES
DTD 05/13/2022 3.400% 05/13/2025
191,245.64 189,776.31 1,399.67 189,758.70 05/13/2205/10/22A2A 190,000.00 14913R2V8 3.44 Account 73340100 Page 8

Page 65 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

CATERPILLAR FINL SERVICE CORPORATE
NOTES
DTD 05/13/2022 3.400% 05/13/2025
251,639.00 250,464.78 1,841.66 250,500.00 05/16/2205/12/22A2A 250,000.00 14913R2V8 3.33

CITIGROUP INC CORPORATE NOTES
DTD 05/24/2022 4.140% 05/24/2025
199,897.80 201,749.49 1,541.00 201,850.00 06/03/2206/01/22A3BBB+ 200,000.00 172967NQ0 3.81

NATIONAL RURAL UTIL COOP CORPORATE
NOTES
DTD 05/04/2022 3.450% 06/15/2025
75,089.48 74,981.33 625.32 74,979.75 05/04/2204/27/22A2A- 75,000.00 63743HFE7 3.46

MORGAN STANLEY CORPORATE NOTES
DTD 01/27/2016 3.875% 01/27/2026
166,175.79 179,972.88 71.04 185,034.30 05/27/2105/25/21A1A- 165,000.00 61746BDZ6 1.19

STATE STREET CORP (CALLABLE)

CORPORATE N
DTD 02/07/2022 1.746% 02/06/2026
33,424.30 35,000.00 295.37 35,000.00 02/07/2202/02/22A1A 35,000.00 857477BR3 1.75

STATE STREET CORP (CALLABLE)

CORPORATE N
DTD 02/07/2022 1.746% 02/06/2026
286,494.00 288,099.54 2,531.70 287,229.00 04/29/2204/27/22A1A 300,000.00 857477BR3 2.95

GOLDMAN SACHS GROUP INC CORP NOTES
(CALL
DTD 02/25/2016 3.750% 02/25/2026
165,156.75 178,699.18 2,681.25 183,570.75 05/27/2105/25/21A2BBB+ 165,000.00 38143U8H7 1.30

GOLDMAN SACHS GROUP INC CORP NOTES
(CALL
DTD 02/25/2016 3.750% 02/25/2026
175,166.25 174,902.06 2,843.75 174,895.00 04/29/2204/27/22A2BBB+ 175,000.00 38143U8H7 3.77

CITIGROUP INC CORP NOTES (CALLABLE)
DTD 03/17/2022 3.290% 03/17/2026
170,885.05 171,869.27 2,143.07 171,647.00 04/29/2204/27/22A3BBB+ 175,000.00 172967NL1 3.82

JP MORGAN CORP (CALLABLE) NOTES
DTD 03/23/2016 3.300% 04/01/2026
337,152.50 364,969.00 3,740.00 373,585.20 05/27/2105/25/21A2A- 340,000.00 46625HQW3 1.20

BANK OF AMERICA CORP NOTES
DTD 04/19/2016 3.500% 04/19/2026
164,835.83 178,587.08 1,636.25 182,902.50 05/27/2105/25/21A2A- 165,000.00 06051GFX2 1.21

CITIGROUP CORP NOTES
DTD 05/02/2016 3.400% 05/01/2026
167,289.35 183,016.07 1,445.00 187,113.90 05/27/2105/25/21A3BBB+ 170,000.00 172967KN0 1.29 Account 73340100 Page 9

Page 66 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

CITY OF RANCHO CUCAMONGA, FIRE PROT DIST -
Dated Date/Coupon/Maturity CUSIP Rating Rating Date Date Cost at Cost Interest Cost Value Security Type/Description S&P Moody's Original YTM Accrued Amortized MarketTrade Settle Par
Corporate Note
AMAZON.COM INC CORPORATE NOTES
DTD 05/12/2021 1.000% 05/12/2026
347,530.13 375,271.47 822.92 375,356.25 05/27/2105/25/21A1AA 375,000.00 023135BX3 0.98

IBM CORP
DTD 05/15/2019 3.300% 05/15/2026
148,899.45 162,266.77 1,045.00 165,211.50 09/03/2109/01/21A3A- 150,000.00 459200JZ5 1.08

ASTRAZENECA FINANCE LLC (CALLABLE)
CORP
DTD 05/28/2021 1.200% 05/28/2026
138,515.40 150,655.25 315.00 150,814.50 09/03/2109/01/21A3A- 150,000.00 04636NAA1 1.08

TOYOTA MOTOR CREDIT CORP CORPORATE
NOTES
DTD 06/18/2021 1.125% 06/18/2026
101,880.90 109,801.02 147.81 109,755.80 09/13/2109/08/21A1A+ 110,000.00 89236TJK2 1.17

TOYOTA MOTOR CREDIT CORP CORPORATE
NOTES
DTD 06/18/2021 1.125% 06/18/2026
231,547.50 229,423.15 335.94 228,305.00 05/16/2205/12/22A1A+ 250,000.00 89236TJK2 3.42

AMERICAN HONDA FINANCE CORPORATE
NOTES
DTD 09/09/2021 1.300% 09/09/2026
183,808.40 197,479.04 1,025.56 197,074.00 12/03/2112/01/21A3A- 200,000.00 02665WDZ1 1.62

BANK OF NY MELLON CORP CORPORATE
NOTES
DTD 07/27/2021 1.050% 10/15/2026
181,572.20 195,961.63 618.33 195,328.00 12/03/2112/01/21A1A 200,000.00 06406RAV9 1.55

AMERICAN EXPRESS CO (CALLABLE)

CORPORATE
DTD 11/04/2021 1.650% 11/04/2026
208,526.18 208,388.13 897.19 207,758.25 06/03/2206/01/22A2BBB+ 225,000.00 025816CM9 3.54

JOHN DEERE CAPITAL CORP CORPORATE
NOTES
DTD 01/10/2022 1.700% 01/11/2027
187,850.20 198,995.68 188.89 198,872.00 01/13/2201/11/22A2A 200,000.00 24422EWA3 1.82

TARGET CORP CORPORATE NOTES
DTD 01/24/2022 1.950% 01/15/2027
33,255.60 34,946.69 30.33 34,940.50 01/24/2201/19/22A2A 35,000.00 87612EBM7 1.99

TARGET CORP CORPORATE NOTES
DTD 01/24/2022 1.950% 01/15/2027
142,524.00 145,397.23 130.00 145,041.00 03/28/2203/24/22A2A 150,000.00 87612EBM7 2.69 Account 73340100 Page 10

Page 67 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

IBM CORP CORPORATE NOTES
DTD 02/09/2022 2.200% 02/09/2027
117,697.38 121,128.83 1,313.89 120,833.75 03/28/2203/24/22A3A- 125,000.00 459200KM2 2.94

HONEYWELL INTERNATIONAL (CALLABLE)
CORP
DTD 08/16/2021 1.100% 03/01/2027
255,118.92 265,828.40 1,283.33 264,583.20 03/07/2203/03/22A2A 280,000.00 438516CE4 2.27

TRUIST FINANCIAL CORP NOTES
(CALLABLE)
DTD 03/02/2021 1.267% 03/02/2027
250,985.63 256,708.76 1,442.09 255,332.00 03/28/2203/24/22A3A- 275,000.00 89788MAD4 2.83

CHARLES SCHWAB CORP NOTES
(CALLABLE)
DTD 03/03/2022 2.450% 03/03/2027
286,747.50 285,541.41 3,021.67 284,730.00 04/29/2204/27/22A2A 300,000.00 808513BY0 3.60

BERKSHIRE HATHAWAY CORP NOTES
(CALLABLE)
DTD 03/15/2022 2.300% 03/15/2027
266,820.13 269,608.44 2,389.44 269,205.75 03/28/2203/24/22Aa2AA 275,000.00 084664CZ2 2.76

NORTHERN TRUST CORP NOTE (CALLABLE)
DTD 05/10/2022 4.000% 05/10/2027
411,723.60 405,248.10 3,600.00 405,484.00 05/16/2205/12/22A2A+ 400,000.00 665859AW4 3.70

UNITEDHEALTH GROUP INC CORPORATE
NOTES
DTD 05/20/2022 3.700% 05/15/2027
66,353.76 64,966.31 474.32 64,964.90 05/20/2205/17/22A3A+ 65,000.00 91324PEG3 3.71

UNITEDHEALTH GROUP INC CORPORATE
NOTES
DTD 05/20/2022 3.700% 05/15/2027
255,206.75 252,993.95 1,824.31 253,095.00 06/03/2206/01/22A3A+ 250,000.00 91324PEG3 3.43

NATIONAL AUSTRALIA BK/NY CORPORATE
NOTES
DTD 06/09/2022 3.905% 06/09/2027
402,603.20 396,625.27 2,256.22 396,532.00 06/13/2206/09/22Aa3AA- 400,000.00 63254ABE7 4.10 55,282.07 7,924,268.60 8,136,804.80 2.71 8,161,385.55 8,150,000.00 Security Type Sub-Total Certificate of Deposit - FDIC Insured

ENERBANK USA
DTD 07/24/2020 0.450% 07/24/2024
231,972.62 245,000.00 24.16 245,000.00 07/24/2007/24/20NRNR 245,000.00 29278TQD5 0.45 Account 73340100 Page 11

Page 68 ends

For the Month Ending July 31, 2022Managed Account Detail of Securities Held

MEDALLION BANK UTAH
DTD 07/30/2020 0.550% 07/30/2025
225,387.75 245,000.00 7.38 245,000.00 07/30/2007/30/20NRNR 245,000.00 58404DHQ7 0.55

31.54 457,360.37 490,000.00 0.50 490,000.00 490,000.00 Security Type Sub-Total Asset-Backed Security
HAROT 2021-4 A3
DTD 11/24/2021 0.880% 01/21/2026
66,989.64 69,987.67 17.11 69,985.24 11/24/2111/16/21AaaNR 70,000.00 43815GAC3 0.89 VALET 2021-1 A3
DTD 12/13/2021 1.020% 06/22/2026
101,119.53 104,996.46 32.73 104,995.88 12/13/2112/07/21AaaAAA 105,000.00 92868KAC7 1.02 HART 2022-A A3
DTD 03/16/2022 2.220% 10/15/2026
150,881.32 154,994.52 152.93 154,994.03 03/16/2203/09/22NRAAA 155,000.00 448977AD0 2.22 COMET 2021-A3 A3
DTD 11/30/2021 1.040% 11/15/2026
171,231.10 179,978.54 83.20 179,975.20 11/30/2111/18/21NRAAA 180,000.00 14041NFY2 1.04 GMCAR 2022-1 A3
DTD 01/19/2022 1.260% 11/16/2026
57,880.24 59,995.36 31.50 59,994.79 01/19/2201/11/22NRAAA 60,000.00 380146AC4 1.26 317.47 548,101.83 569,952.55 1.37 569,945.14 570,000.00 Security Type Sub-Total 61,705,000.00 61,000,432.64 1.69 186,268.62 60,942,635.90 59,338,452.58 Managed Account Sub-Total $61,705,000.00 $61,000,432.64 $186,268.62 $60,942,635.90 $59,338,452.58 1.69% $59,524,721.20
$186,268.62
Total Investments
Accrued Interest
Securities Sub-Total
Account 73340100 Page 12

Page 69 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA, FIRE PROT DIST -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
U.S. Treasury Bond / Note
(7,123.40)(7,251.56) 832,912.50 99.16 HSBC 840,000.00 91282CAX9US TREASURY NOTES DTD 11/30/2020 0.125% 11/30/2022

2.68 0.34
(4,243.22)(5,132.78) 598,781.28 99.80 NOMURA 600,000.00 9128284L1US TREASURY NOTES DTD 04/30/2018 2.750% 04/30/2023

3.02 0.75
(23,513.03)(54,140.58) 997,968.80 99.80 HSBC 1,000,000.00 9128284S6US TREASURY NOTES DTD 05/31/2018 2.750% 05/31/2023

3.00 0.83
(28,639.41)(36,796.95) 1,483,359.30 98.89 CITIGRP 1,500,000.00 912828R69US TREASURY NOTES DTD 05/31/2016 1.625% 05/31/2023

2.98 0.84
(15,844.80)(18,198.04) 783,323.44 98.53 NOMURA 795,000.00 912828S35US TREASURY NOTES DTD 06/30/2016 1.375% 06/30/2023

3.01 0.92
(27,296.73)(26,484.38) 971,875.00 97.19 MERRILL 1,000,000.00 91282CCN9US TREASURY N/B NOTES DTD 07/31/2021 0.125% 07/31/2023

3.00 1.00
(23,389.78)(22,794.14) 770,901.56 96.97 CITIGRP 795,000.00 91282CCU3US TREASURY N/B NOTES DTD 08/31/2021 0.125% 08/31/2023

2.99 1.09
(14,095.16)(449.33) 2,228,484.26 96.89 RBS 2,300,000.00 91282CDA6US TREASURY NOTES DTD 09/30/2021 0.250% 09/30/2023

2.98 1.17
(23,689.73)(22,856.25) 769,907.81 96.84 CITIGRP 795,000.00 91282CDD0US TREASURY N/B NOTES DTD 10/31/2021 0.375% 10/31/2023

2.97 1.25
(6,970.62)(2,656.25) 968,437.50 96.84 BMO 1,000,000.00 91282CDD0US TREASURY N/B NOTES DTD 10/31/2021 0.375% 10/31/2023

2.97 1.25
(82,771.35)(153,520.98) 2,256,821.99 99.86 CITIGRP 2,260,000.00 9128285P1US TREASURY NOTES DTD 11/30/2018 2.875% 11/30/2023

2.98 1.32
(57,931.16)(56,484.28) 1,938,437.60 96.92 CITIGRP 2,000,000.00 91282CDR9US TREASURY N/B NOTES DTD 12/31/2021 0.750% 12/31/2023

2.99 1.42
(33,218.39)(29,804.69) 959,687.50 95.97 JPM_CHA 1,000,000.00 91282CBE0US TREASURY NOTES DTD 01/15/2021 0.125% 01/15/2024

2.97 1.46
(47,205.63)(41,367.11) 1,436,015.70 95.73 WELLS_F 1,500,000.00 91282CBR1US TREASURY NOTES DTD 03/15/2021 0.250% 03/15/2024

2.96 1.63
(12,712.37)(12,563.97) 1,855,682.91 99.23 BMO 1,870,000.00 91282CEK3US TREASURY N/B NOTES DTD 04/30/2022 2.500% 04/30/2024

2.95 1.72
(89,685.81)(88,180.67) 1,883,039.06 95.34 BARCLAY 1,975,000.00 91282CCC3US TREASURY N/B NOTES DTD 05/15/2021 0.250% 05/15/2024

2.94 1.79
(15,813.09)(15,459.38) 323,531.25 95.16 MERRILL 340,000.00 91282CCG4US TREASURY N/B NOTES DTD 06/15/2021 0.250% 06/15/2024

2.92 1.88
Account 73340100 Page 13

Page 70 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA, FIRE PROT DIST -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
U.S. Treasury Bond / Note
(3,364.34)(2,119.92) 655,762.50 97.88 CITIGRP 670,000.00 9128286Z8US TREASURY NOTES DTD 06/30/2019 1.750% 06/30/2024

2.90 1.90
(11,844.72)(11,050.96) 280,941.42 95.23 JPM_CHA 295,000.00 91282CCL3US TREASURY N/B NOTES DTD 07/15/2021 0.375% 07/15/2024

2.90 1.96
(52,294.34)(46,757.74) 1,428,515.70 95.23 WELLS_F 1,500,000.00 91282CCL3US TREASURY N/B NOTES DTD 07/15/2021 0.375% 07/15/2024

2.90 1.96
(2,733.61) 4,292.57 1,609,326.56 96.66 RBS 1,665,000.00 912828YE4US TREASURY NOTES DTD 08/31/2019 1.250% 08/31/2024

2.91 2.06
(111,176.36)(136,015.73) 1,937,812.40 96.89 GOLDMAN 2,000,000.00 912828YV6US TREASURY NOTES DTD 11/30/2019 1.500% 11/30/2024

2.89 2.30
(21,708.53)(23,730.47) 486,875.00 97.38 MORGAN_ 500,000.00 912828YY0US TREASURY NOTES DTD 12/31/2019 1.750% 12/31/2024

2.88 2.38
(4,547.39)(2,921.88) 1,071,125.00 97.38 WELLS_F 1,100,000.00 912828YY0US TREASURY NOTES DTD 12/31/2019 1.750% 12/31/2024

2.88 2.38
858.82 10,234.37 1,917,500.00 95.88 MORGAN_ 2,000,000.00 91282CDS7US TREASURY N/B NOTES DTD 01/15/2022 1.125% 01/15/2025

2.88 2.43
(3,071.54)(429.69) 966,250.00 96.63 TD 1,000,000.00 91282CDZ1US TREASURY N/B NOTES DTD 02/15/2022 1.500% 02/15/2025

2.89 2.49
(2,617.77) 2,382.81 934,687.50 93.47 MERRILL 1,000,000.00 912828ZL7US TREASURY NOTES DTD 04/30/2020 0.375% 04/30/2025

2.86 2.74
(272.69)(175.78) 1,495,781.25 99.72 MORGAN_ 1,500,000.00 91282CEQ0US TREASURY N/B NOTES DTD 05/15/2022 2.750% 05/15/2025

2.85 2.70
(87,435.48)(82,104.49) 1,324,804.69 92.97 WELLS_F 1,425,000.00 912828ZT0US TREASURY NOTES DTD 05/31/2020 0.250% 05/31/2025

2.85 2.83
(111,208.77)(96,679.69) 2,309,375.00 92.38 MORGAN_ 2,500,000.00 91282CAJ0US TREASURY NOTES DTD 08/31/2020 0.250% 08/31/2025

2.85 3.08
(959.49) 4,335.99 920,468.80 92.05 CITIGRP 1,000,000.00 91282CAT8US TREASURY NOTES DTD 10/31/2020 0.250% 10/31/2025

2.83 3.24
368.37 5,976.56 1,384,687.50 92.31 CITIGRP 1,500,000.00 91282CAZ4US TREASURY NOTES DTD 11/30/2020 0.375% 11/30/2025

2.81 3.32
(34,683.76)(33,222.66) 459,687.50 91.94 NOMURA 500,000.00 91282CBH3US TREASURY NOTES DTD 01/31/2021 0.375% 01/31/2026

2.81 3.48
181.12 507.81 494,843.75 98.97 CITIGRP 500,000.00 9128286F2US TREASURY NOTES DTD 02/28/2019 2.500% 02/28/2026

2.80 3.42
Account 73340100 Page 14

Page 71 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA, FIRE PROT DIST -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
U.S. Treasury Bond / Note
(49,512.41)(49,191.41) 649,468.75 92.78 BNP_PAR 700,000.00 91282CBW0US TREASURY N/B NOTES DTD 04/30/2021 0.750% 04/30/2026

2.79 3.70
(21,729.43)(21,398.41) 575,156.28 95.86 CITIGRP 600,000.00 912828R36US TREASURY NOTES DTD 05/16/2016 1.625% 05/15/2026

2.78 3.68
(76,971.43)(91,132.76) 976,718.80 97.67 CITIGRP 1,000,000.00 9128286X3US TREASURY NOTES DTD 05/31/2019 2.125% 05/31/2026

2.77 3.69
(29,487.10)(27,656.25) 557,812.50 92.97 WELLS_F 600,000.00 91282CCJ8US TREASURY N/B NOTES DTD 06/30/2021 0.875% 06/30/2026

2.78 3.86
16,637.60 24,453.12 1,902,500.00 95.13 MERRILL 2,000,000.00 9128282A7US TREASURY NOTES DTD 08/15/2016 1.500% 08/15/2026

2.78 3.91
3,879.74 9,902.34 1,389,375.00 92.63 NOMURA 1,500,000.00 91282CCZ2US TREASURY N/B NOTES DTD 09/30/2021 0.875% 09/30/2026

2.76 4.09
(18,954.13)(18,745.31) 289,850.00 93.50 MORGAN_ 310,000.00 91282CDG3US TREASURY N/B NOTES DTD 10/31/2021 1.125% 10/31/2026

2.76 4.15
(59,802.61)(58,945.31) 935,000.00 93.50 CITIGRP 1,000,000.00 91282CDG3US TREASURY N/B NOTES DTD 10/31/2021 1.125% 10/31/2026

2.76 4.15
1,795.85 2,402.34 489,218.75 97.84 MERRILL 500,000.00 912828V98US TREASURY NOTES DTD 02/15/2017 2.250% 02/15/2027

2.76 4.30
(1,231,931.89) 2.89 (1,194,798.08) 48,502,712.11 50,435,000.00 Security Type Sub-Total 2.24 Supra-National Agency Bond / Note
(18,851.39)(18,774.50) 345,955.40 94.78 JPM_CHA 365,000.00 4581X0DZ8INTER-AMERICAN DEVEL BK NOTES DTD 09/23/2021 0.500% 09/23/2024

3.03 2.14
(123,507.30)(119,673.78) 1,560,054.27 92.04 08/10/22KEYBANC 1,695,000.00 459058JS3INTL BK RECON & DEVELOP NOTES (CALLABLE)
DTD 02/10/2021 0.650% 02/10/2026

3.05 0.07
(138,448.28) 3.05 (142,358.69) 1,906,009.67 2,060,000.00 Security Type Sub-Total 0.44 Corporate Note
(256.67)(255.42) 329,731.38 99.92 HSBC 330,000.00 40428HTA0HSBC USA INC CORPORATE NOTES DTD 05/24/2022 3.750% 05/24/2024

3.79 1.76
Account 73340100 Page 15

Page 72 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA, FIRE PROT DIST -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
Corporate Note
(12,760.90)(15,362.05) 269,482.95 97.99 06/30/24MORGAN_ 275,000.00 025816CG2AMERICAN EXPRESS CO CORP NOTES (CALLABLE
DTD 07/30/2019 2.500% 07/30/2024

3.55 1.86
(1,317.68)(1,275.30) 223,137.45 99.17 04/17/24GOLDMAN 225,000.00 61747YEQ4MORGAN STANLEY CORP NOTES (CALLABLE)
DTD 04/20/2022 3.620% 04/17/2025

3.94 1.66
(1,173.42)(1,202.00) 249,185.50 99.67 03/25/25MERRILL 250,000.00 06406RBC0BANK OF NY MELLON CORP (CALLABLE) CORP N
DTD 04/26/2022 3.350% 04/25/2025

3.47 2.62
(1,323.58)(1,357.25) 249,112.75 99.65 SMBC 250,000.00 06051GKS7BANK OF AMERICA CORP NOTES (CALLABLE)
DTD 04/27/2022 3.841% 04/25/2025

3.98 2.60
1,469.33 1,486.94 191,245.64 100.66 MERRILL 190,000.00 14913R2V8CATERPILLAR FINL SERVICE CORPORATE NOTES
DTD 05/13/2022 3.400% 05/13/2025

3.15 2.67
1,174.22 1,139.00 251,639.00 100.66 MITSU 250,000.00 14913R2V8CATERPILLAR FINL SERVICE CORPORATE NOTES
DTD 05/13/2022 3.400% 05/13/2025

3.15 2.67
(1,851.69)(1,952.20) 199,897.80 99.95 JPM_CHA 200,000.00 172967NQ0CITIGROUP INC CORPORATE NOTES DTD 05/24/2022 4.140% 05/24/2025

4.16 2.67
108.15 109.73 75,089.48 100.12 RBC 75,000.00 63743HFE7NATIONAL RURAL UTIL COOP CORPORATE NOTES
DTD 05/04/2022 3.450% 06/15/2025

3.40 2.74
(13,797.09)(18,858.51) 166,175.79 100.71 BNP_PAR 165,000.00 61746BDZ6MORGAN STANLEY CORPORATE NOTES DTD 01/27/2016 3.875% 01/27/2026

3.66 3.30
(1,575.70)(1,575.70) 33,424.30 95.50 02/26/25GOLDMAN 35,000.00 857477BR3STATE STREET CORP (CALLABLE)

CORPORATE N
DTD 02/07/2022 1.746% 02/06/2026

3.11 2.93
(1,605.54)(735.00) 286,494.00 95.50 02/26/25GOLDMAN 300,000.00 857477BR3STATE STREET CORP (CALLABLE)

CORPORATE N
DTD 02/07/2022 1.746% 02/06/2026

3.11 2.93
(13,542.43)(18,414.00) 165,156.75 100.10 11/25/25JPM_CHA 165,000.00 38143U8H7GOLDMAN SACHS GROUP INC CORP NOTES (CALL
DTD 02/25/2016 3.750% 02/25/2026

3.72 3.10
Account 73340100 Page 16

Page 73 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA, FIRE PROT DIST -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
Corporate Note
264.19 271.25 175,166.25 100.10 11/25/25MKTX 175,000.00 38143U8H7GOLDMAN SACHS GROUP INC CORP NOTES (CALL
DTD 02/25/2016 3.750% 02/25/2026

3.72 3.10
(984.22)(761.95) 170,885.05 97.65 03/17/25GOLDMAN 175,000.00 172967NL1CITIGROUP INC CORP NOTES (CALLABLE) DTD 03/17/2022 3.290% 03/17/2026

3.99 2.51
(27,816.50)(36,432.70) 337,152.50 99.16 01/01/26JSEB 340,000.00 46625HQW3JP MORGAN CORP (CALLABLE) NOTES DTD 03/23/2016 3.300% 04/01/2026

3.54 3.23
(13,751.25)(18,066.67) 164,835.83 99.90 FIFTH_3 165,000.00 06051GFX2BANK OF AMERICA CORP NOTES DTD 04/19/2016 3.500% 04/19/2026

3.53 3.49
(15,726.72)(19,824.55) 167,289.35 98.41 JPM_CHA 170,000.00 172967KN0CITIGROUP CORP NOTES DTD 05/02/2016 3.400% 05/01/2026

3.86 3.53
(27,741.34)(27,826.12) 347,530.13 92.67 UBS 375,000.00 023135BX3AMAZON.COM INC CORPORATE NOTES DTD 05/12/2021 1.000% 05/12/2026

3.07 3.71
(13,367.32)(16,312.05) 148,899.45 99.27 MORGAN_ 150,000.00 459200JZ5IBM CORP DTD 05/15/2019 3.300% 05/15/2026

3.51 3.57
(12,139.85)(12,299.10) 138,515.40 92.34 04/28/26MORGAN_ 150,000.00 04636NAA1ASTRAZENECA FINANCE LLC (CALLABLE) CORP
DTD 05/28/2021 1.200% 05/28/2026

3.35 3.66
(7,920.12)(7,874.90) 101,880.90 92.62 JPM_CHA 110,000.00 89236TJK2TOYOTA MOTOR CREDIT CORP

CORPORATE NOTES
DTD 06/18/2021 1.125% 06/18/2026

3.16 3.81
2,124.35 3,242.50 231,547.50 92.62 JSEB 250,000.00 89236TJK2TOYOTA MOTOR CREDIT CORP

CORPORATE NOTES
DTD 06/18/2021 1.125% 06/18/2026

3.16 3.81
(13,670.64)(13,265.60) 183,808.40 91.90 RBC 200,000.00 02665WDZ1AMERICAN HONDA FINANCE CORPORATE NOTES
DTD 09/09/2021 1.300% 09/09/2026

3.43 3.99
(14,389.43)(13,755.80) 181,572.20 90.79 DEUTSCH 200,000.00 06406RAV9BANK OF NY MELLON CORP CORPORATE NOTES
DTD 07/27/2021 1.050% 10/15/2026

3.42 4.11
138.05 767.93 208,526.18 92.68 10/04/26JSEB 225,000.00 025816CM9AMERICAN EXPRESS CO (CALLABLE)

CORPORATE
DTD 11/04/2021 1.650% 11/04/2026

3.51 4.03
Account 73340100 Page 17

Page 74 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA, FIRE PROT DIST -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
Corporate Note
(11,145.48)(11,021.80) 187,850.20 93.93 JPM_CHA 200,000.00 24422EWA3JOHN DEERE CAPITAL CORP CORPORATE NOTES
DTD 01/10/2022 1.700% 01/11/2027

3.18 4.30
(1,691.09)(1,684.90) 33,255.60 95.02 CITIGRP 35,000.00 87612EBM7TARGET CORP CORPORATE NOTES DTD 01/24/2022 1.950% 01/15/2027

3.16 4.29
(2,873.23)(2,517.00) 142,524.00 95.02 STIFEL 150,000.00 87612EBM7TARGET CORP CORPORATE NOTES DTD 01/24/2022 1.950% 01/15/2027

3.16 4.29
(3,431.45)(3,136.37) 117,697.38 94.16 DEUTSCH 125,000.00 459200KM2IBM CORP CORPORATE NOTES DTD 02/09/2022 2.200% 02/09/2027

3.61 4.28
(10,709.48)(9,464.28) 255,118.92 91.11 02/01/27MORGAN_ 280,000.00 438516CE4HONEYWELL INTERNATIONAL (CALLABLE) CORP
DTD 08/16/2021 1.100% 03/01/2027

3.20 4.38
(5,723.13)(4,346.37) 250,985.63 91.27 03/02/26GOLDMAN 275,000.00 89788MAD4TRUIST FINANCIAL CORP NOTES (CALLABLE)
DTD 03/02/2021 1.267% 03/02/2027

3.33 3.50
1,206.09 2,017.50 286,747.50 95.58 02/03/27CSFB 300,000.00 808513BY0CHARLES SCHWAB CORP NOTES (CALLABLE)
DTD 03/03/2022 2.450% 03/03/2027

3.50 4.25
(2,788.31)(2,385.62) 266,820.13 97.03 02/15/27CITIGRP 275,000.00 084664CZ2BERKSHIRE HATHAWAY CORP NOTES (CALLABLE)
DTD 03/15/2022 2.300% 03/15/2027

2.99 4.30
6,475.50 6,239.60 411,723.60 102.93 04/10/27DEUTSCH 400,000.00 665859AW4NORTHERN TRUST CORP NOTE (CALLABLE) DTD 05/10/2022 4.000% 05/10/2027

3.33 4.30
1,387.45 1,388.86 66,353.76 102.08 MERRILL 65,000.00 91324PEG3UNITEDHEALTH GROUP INC CORPORATE NOTES
DTD 05/20/2022 3.700% 05/15/2027

3.23 4.41
2,212.80 2,111.75 255,206.75 102.08 MKTX 250,000.00 91324PEG3UNITEDHEALTH GROUP INC CORPORATE NOTES
DTD 05/20/2022 3.700% 05/15/2027

3.23 4.41
5,977.93 6,071.20 402,603.20 100.65 JPM_CHA 400,000.00 63254ABE7NATIONAL AUSTRALIA BK/NY CORPORATE NOTES
DTD 06/09/2022 3.905% 06/09/2027

3.76 4.45
(237,116.95) 3.46 (212,536.20) 7,924,268.60 8,150,000.00 Security Type Sub-Total 3.44 Account 73340100 Page 18

Page 75 ends

For the Month Ending July 31, 2022Managed Account Fair Market Value & Analytics

CITY OF RANCHO CUCAMONGA, FIRE PROT DIST -
Value On Cost Amort CostCUSIP Broker Date PriceDated Date/Coupon/Maturity Par at Mkt Market Unreal G/L Unreal G/LNext Call MarketSecurity Type/Description YTMEffective Duration
Certificate of Deposit - FDIC Insured
(13,027.38)(13,027.38) 231,972.62 94.68 NEW ACC 245,000.00 29278TQD5ENERBANK USA DTD 07/24/2020 0.450% 07/24/2024

3.22 1.98
(19,612.25)(19,612.25) 225,387.75 92.00 NEW ACC 245,000.00 58404DHQ7MEDALLION BANK UTAH DTD 07/30/2020 0.550% 07/30/2025

3.36 2.98
(32,639.63) 3.29 (32,639.63) 457,360.37 490,000.00 Security Type Sub-Total 2.47 Asset-Backed Security
(2,998.03)(2,995.60) 66,989.64 95.70 MERRILL 70,000.00 43815GAC3HAROT 2021-4 A3 DTD 11/24/2021 0.880% 01/21/2026

2.17 1.59
(3,876.93)(3,876.35) 101,119.53 96.30 WELLS_F 105,000.00 92868KAC7VALET 2021-1 A3 DTD 12/13/2021 1.020% 06/22/2026

2.01 1.50
(4,113.20)(4,112.71) 150,881.32 97.34 MERRILL 155,000.00 448977AD0HART 2022-A A3 DTD 03/16/2022 2.220% 10/15/2026

2.89 1.92
(8,747.44)(8,744.10) 171,231.10 95.13 BARCLAY 180,000.00 14041NFY2COMET 2021-A3 A3 DTD 11/30/2021 1.040% 11/15/2026

2.23 2.23
(2,115.12)(2,114.55) 57,880.24 96.47 BNP_PAR 60,000.00 380146AC4GMCAR 2022-1 A3 DTD 01/19/2022 1.260% 11/16/2026

2.12 1.27
(21,843.31) 2.35 (21,850.72) 548,101.83 570,000.00 Security Type Sub-Total 1.83 61,705,000.00 59,338,452.58 (1,661,980.06) (1,604,183.32) 2.97 Managed Account Sub-Total 2.34 Total Investments $59,524,721.20
$186,268.62
$59,338,452.58
Accrued Interest
Securities Sub-Total $61,705,000.00 ($1,661,980.06) ($1,604,183.32) 2.97% 2.34 Account 73340100 Page 19

Page 76 ends

For the Month Ending July 31, 2022Managed Account Security Transactions & Interest

CITY OF RANCHO CUCAMONGA, FIRE PROT DIST -
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
BUY
07/07/22 US TREASURY N/B NOTES
DTD 05/15/2022 2.750% 05/15/2025
91282CEQ0 (1,495,957.03) (5,940.90) (1,501,897.93) 1,500,000.00 07/05/22 (5,940.90) (1,501,897.93)(1,495,957.03) 1,500,000.00 Transaction Type Sub-Total

INTEREST
07/01/22 MONEY MARKET FUND MONEY0002 0.00 83.94 83.94 0.00 07/01/22 07/11/22 JOHN DEERE CAPITAL CORP

CORPORATE NOTES
DTD 01/10/2022 1.700% 01/11/2027
24422EWA3 0.00 1,709.44 1,709.44 200,000.00 07/11/22 07/15/22 TARGET CORP CORPORATE NOTES
DTD 01/24/2022 1.950% 01/15/2027
87612EBM7 0.00 1,713.56 1,713.56 185,000.00 07/15/22 07/15/22 US TREASURY N/B NOTES
DTD 01/15/2022 1.125% 01/15/2025
91282CDS7 0.00 11,250.00 11,250.00 2,000,000.00 07/15/22 07/15/22 COMET 2021-A3 A3
DTD 11/30/2021 1.040% 11/15/2026
14041NFY2 0.00 156.00 156.00 180,000.00 07/15/22
07/15/22 HART 2022-A A3
DTD 03/16/2022 2.220% 10/15/2026
448977AD0 0.00 286.75 286.75 155,000.00 07/15/22
07/15/22 US TREASURY N/B NOTES
DTD 07/15/2021 0.375% 07/15/2024
91282CCL3 0.00 3,365.63 3,365.63 1,795,000.00 07/15/22 07/15/22 US TREASURY NOTES
DTD 01/15/2021 0.125% 01/15/2024
91282CBE0 0.00 625.00 625.00 1,000,000.00 07/15/22
07/16/22 GMCAR 2022-1 A3
DTD 01/19/2022 1.260% 11/16/2026
380146AC4 0.00 63.00 63.00 60,000.00 07/16/22
07/20/22 VALET 2021-1 A3
DTD 12/13/2021 1.020% 06/22/2026
92868KAC7 0.00 89.25 89.25 105,000.00 07/20/22
07/21/22 HAROT 2021-4 A3
DTD 11/24/2021 0.880% 01/21/2026
43815GAC3 0.00 51.33 51.33 70,000.00 07/21/22
07/24/22 ENERBANK USA
DTD 07/24/2020 0.450% 07/24/2024
29278TQD5 0.00 90.62 90.62 245,000.00 07/24/22
07/27/22 MORGAN STANLEY CORPORATE NOTES
DTD 01/27/2016 3.875% 01/27/2026
61746BDZ6 0.00 3,196.88 3,196.88 165,000.00 07/27/22 07/30/22 AMERICAN EXPRESS CO CORP NOTES
(CALLABLE
DTD 07/30/2019 2.500% 07/30/2024
025816CG2 0.00 3,437.50 3,437.50 275,000.00 07/30/22 Account 73340100 Page 20

Page 77 ends

For the Month Ending July 31, 2022Managed Account Security Transactions & Interest

CITY OF RANCHO CUCAMONGA, FIRE PROT DIST -
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method

INTEREST
07/30/22 MEDALLION BANK UTAH
DTD 07/30/2020 0.550% 07/30/2025
58404DHQ7 0.00 110.75 110.75 245,000.00 07/30/22
07/31/22 US TREASURY NOTES
DTD 01/31/2021 0.375% 01/31/2026
91282CBH3 0.00 937.50 937.50 500,000.00 07/31/22
07/31/22 US TREASURY N/B NOTES
DTD 07/31/2021 0.125% 07/31/2023
91282CCN9 0.00 625.00 625.00 1,000,000.00 07/31/22
27,792.15 27,792.15 0.00 8,180,000.00 Transaction Type Sub-Total SELL
07/07/22 US TREASURY NOTES
DTD 05/31/2018 2.750% 05/31/2023
9128284S6 1,293,735.35 3,600.17 1,297,335.52 (68,746.29) (31,378.91) FIFO 1,295,000.00 07/05/22 3,600.17 (31,378.91)(68,746.29) 1,297,335.52 1,293,735.35 1,295,000.00 Transaction Type Sub-Total (202,221.68) 25,451.42 (176,770.26) (68,746.29) (31,378.91)Managed Account Sub-Total Total Security Transactions ($68,746.29)($176,770.26)$25,451.42 ($202,221.68) ($31,378.91) Account 73340100 Page 21

Page 78 ends

DATE:August 17, 2022
TO:President and Members of the Board of Directors
FROM:John R. Gillison, City Manager
INITIATED BY: Robert Neiuber, Human Resources Director
Lucy Alvarez-Nunez, Management Analyst
SUBJECT: Consideration to Authorize Signature of the California Intergovernmental Risk Authority Agreement for Apportionment of Retirement Obligations. (FIRE)
RECOMMENDATION:

Staff recommends that the Fire Board of the Rancho Cucamonga Fire Protection District authorize the Board President to sign the California Intergovernmental Risk Authority (CIRA) Agreement for Apportionment of Retirement Obligations on behalf of the Fire District.

BACKGROUND:

In September 2018, former Governor Jerry Brown signed into law AB 1912. This Bill, codified in Government Code 6508.2, established rules for Joint Powers Authorities (JPA) to meet pension obligations for employees and retirees should the JPA terminate its retirement plan with CalPERS or dissolve. The law requires that member agencies of a JPA, prior to filing a notice of termination of CalPERS participation, must mutually agree (within 60 days) with the public retirement system on how to apportion the retirement liability of the JPA so that the apportionment equals 100% of this liability.

The Public Agency Risk Sharing Authority of California (PARSAC), a statewide risk-sharing Joint Powers Authority provides general liability coverage. The Redwood Empire Municipal Insurance Fund (REMIF), a public entity pool provides worker’s compensation and liability coverage. Pools are empowered to exist through sections of the California Government Code known as joint powers authority (JPA) with a focus on managing and maintaining a financially stable risk sharing pool for members.

On July 1, 2021, PARSAC and REMIF merged to form the California Intergovernmental Risk Authority (CIRA). PARSAC became the successor agency and absorbed REMIF’s CalPERS pension liabilities into its contract. The contracting agency is now CIRA.

The Rancho Cucamonga Fire District is a member agency of CIRA.

This past May, CIRA’s Board of Directors approved an Agreement for Apportionment of Retirement Obligations. All member agencies must mutually agree on the method of apportioning the CalPERS retirement obligations.

Page 79 ends

Page 2 ends

1 4
2 9
ANALYSIS:

The Fire District agrees with the method of apportioning the CalPERS retirement obligations as recommended and approved by CIRA’s Board of Directors.

Staff recommends that the Fire Board authorize the Board President to sign CIRA’s Agreement for Apportionment of Retirement Obligations on behalf of the Fire District.

FISCAL IMPACT:

N/A
COUNCIL MISSION / VISION / GOAL(S) ADDRESSED:

This item addresses the Council’s core values, working together cooperatively and respectfully with each other, staff, and all stakeholders, and intentionally embracing and anticipating the future.

ATTACHMENTS:

Attachment 1 – Agreement for Apportionment of Retirement Obligations

Page 80 ends

Adopted May 20, 2022 1
CIRA
AGRE

EMENT FOR APPORTIONMENT OF

RETIREMENT OBLIGATIONS
Ca
lifornia Intergovernmental Risk Authority

CALIFORNIA INTERGOVERNMENTAL RISK AUTHORITY

AGREEMENT FOR APPORTIONMENT OF RETIREMENT OBLIGATIONS
ATTACHMENT 1

Page 81 ends

Adopted May 20 2022 2
T
HIS AGREEMENT is made in the State of California by and among those municipalities organized and existing under the laws of the State of California, hereinafter referred to as "Member Entity[ies]," which are parties’ signatory to the Joint Powers Authority Agreement hereafter “JPA Agreement. All such Member Entities are listed in Appendix "A", which is attached hereto and made a part hereof.

RECITALS
Wh ereas the California Intergovernmental Risk Authority (CIRA), formerly the Public Agency Risk Sharing Authority of California (PARSAC), is an entity formed under California Government Code Section 6500 which permits two or more public agencies by agreement to jointly exercise any power common to the contracting parties.

Whereas the Redwood Empire Municipal Insurance Fund (REMIF) is an entity formed under California Government Code Section 6500 which permits two or more public agencies by agreement to jointly exercise any power common to the contracting parties.

Whereas, the jurisdiction of PARSAC was expanded with the addition of member agencies of REMIF, and its name changed to the California Intergovernmental Risk Authority, effective July 1, 2021.

Whereas, to avoid the involuntary termination of the REMIF CalPERS pension contract as a result of the transfer of all employees to CIRA, the CalPERS pension contract of REMIF was merged into the CIRA CalPERS contract, effective July 1, 2021.

Whereas California Government Code § 6508.2 requires that the member agencies of a joint powers agency (“AGENCY”) that contracts with CalPERS, mutually agree to a 100% apportionment of the AGENCY’s retirement liability prior to the adoption of an notice of termination of the AGENCY’s participation in CalPERS.

Page 82 ends

Adopted May 20,2022 3
Now, therefore, in consideration of the above facts and the mutual benefits, promises and agreements set forth below, the Member Entities hereby agree as follow:

AGREEMENT

ARTICLE I

DEFINITIONS
The following terms shall have the following definitions:

A. “A greement” shall mean this California Intergovernmental Risk Authority Agreement for Apportionment of Retirement Obligations.

B. “B oard ” or “Board of Directors” shall mean the governing body of CIRA.

C. “CIRA” shall mean the California Intergovernmental Risk Authority created by that certain Joint Powers Agreement dated May 25, 2017, then known as PARSAC, most recently amended effective July 1, 2021 (JPA Agreement).

D. “D eposit Premium ” shall mean the estimated amount determined for each Member Entity necessary to fund each layer of coverage for each Policy Year of each Program of CIRA and REMIF.

E. “Mem ber Entity” shall mean any California public entity which is a party signatory to the JPA Agreement including any other agency for which the governing body of the Member Entity sits as the governing board of such other agency.

F. “P rogram Year ” shall mean a period of time, usually 12 months, for which each Program is to determine Deposit Premiums, Retrospective Premiums, and Retrospective Premium Adjustments.

G. “Program” shall mean arrangements to cover specific types of claims which may include, but not be limited to, property, workers' compensation, and comprehensive liability claims.

Page 83 ends

Adopted May 20, 2022 4
H. “Public Entity” shall mean a county, city, whether general law or chartered, city and county, town, district, political subdivision, joint powers authority, or any board, commission, or agency thereof providing a municipal service, excluding school districts.

I. “CalPERS” s hall mean California Public Employees’ Retirement System.

J. “Retirement Liability” shall mean the liability that CIRA possesses to all former or current employees of CIRA for retirement benefits owed to them pursuant to a contract between CIRA and CalPERS and arising by reason of those employees participation in CalPERS calculated on a terminated basis pursuant to sections 20570 -20593 of the Government Code.

K. “Retrospective Premium ” shall mean, the amount determined retrospectively as each Member Entity's share of losses, reserves, expenses and interest income as may be determined periodically for any Program.

L. “Retrospective Premium Adjustment” shall mean the amount necessary to periodically adjust the Deposit Premium, or prior Retrospective Premiums if any, to the newly calculated Retrospective Premium amount.

ARTICLE II
P

ARTIES TO THE AGREEMENT
Each Member Entity is a party to this Agreement . Each Member Entity also agrees that the expulsion or withdrawal of any Member Entity from the JPA Agreement shall not affect this Agreement nor the remaining parties as to the other Member Entities then remaining.

Page 84 ends

Adopted May 20, 2022 5
ART

ICLE III

PURPOSE
This Agreement is entered into by the Member Entities in order to:

A. Provide for an apportionment among current and former CIRA and REMIF Member Entities of 100% of CIRA’s Retirement Liability consistent with the requirements of Government Code sections 6508.1 and 6508.2 as enacted and amended effective January 1, 2019. The Member Entities of CIRA, as of the date of this Agreement, are set forth in Appendix A. The following are set forth in Appendix B:
• Former Member Entities of CIRA on or after July 1, 2021; • Members of CIRA prior to July 1, 2021; and
• Members of REMIF prior to July 1, 2021 .

B. The debts, liabilities or obligations incurred by either PARSAC or REMIF prior to July 1, 2021 shall not constitute the debts, liabilities or obligations of the other.

Notwithstanding the preceding, CIRA is the successor to the CalPERS pension obligations of REMIF pursuant to California Government Code section 20508. As such, the liability to CalPERS with respect to service credited under REMIF’s CalPERS contract, and the continuing liability to CalPERS of CIRA with respect to service credit accrued both prior to and after July 1, 2021 under CIRA’s CalPERS contract, shall be the contractual liability of CIRA. Periodically, but not more than every three years, CIRA will retain an actuary to determine the share of the estimated termination liability of CIRA which is allocable to CIRA and REMIF for service accrued prior to July 1, 2021. The allocation of liability, and

Page 85 ends

Adopted May 20, 2022 6
t
he payment of related contributions, with respect to service credit accrued prior to July 1, 2021 and thereafter is set forth below.

ARTICLE IV

METHOD OF APPORTIONMENT OF RETIREMENT LIABILITY
A. In the event of a decision by the governing Board of CIRA to adopt a notice of intent to terminate its contract with CalPERS, the Member Entities agree that 100% of CIRA’s Retirement Liability shall be funded by all current and former CIRA, and REMIF Member Entities based on a pro rata share of the former and current Member Entities’ historical Deposit Premium in the Workers’ Compensation and Liability self-funded Programs. The apportionment of the Retirement Liability shall be calculated as set forth above, and the unfunded Retirement Liability then existing shall be paid as follows: The unfunded Retirement Liability then existing shall be paid prior to any distribution of assets as provided in ARTICLE XIV and XV of the JPA Agreement and prior to the payment of any equity that may be determined as the result of the Retrospective Premium Adjustment process as set forth in ARTICLE XIV. (For example, should a Member Entity have remaining equity in either the Workers’ Compensation or Liability program, at the time of CIRA’s dissolution or CIRA’s termination of CIRA’s contract with a public retirement system, the Member Entity’s equity shall first be applied to reduce that Member Entity’s share of the apportionment of the Unfunded Retirement Liability.)
B. Any unfunded Retirement Liability allocated to CIRA for serviced accrued prior to July 1, 2021, shall first be reduced by applying the proceeds from the sale of real property identified as 1525 Response Road, Sacramento, CA, 95815 (the “CIRA Property”) as provided in

Page 86 ends

Adopted May 20, 2022 7
R
esolution No. 2019-03, attached hereto as Exhibit C, prior to the determination of the amounts owed by the members of CIRA prior to July 1, 2021 under the apportionment provided herein.

In the event that REMIF disposes of the real property identified as 414 West Napa Street, Sonoma, CA 95476 (REMIF Property), any unfunded Retirement Liability allocated to REMIF for service accrued prior to July 1, 2021 shall first be reduced by applying the proceeds from the sale of the REMIF Property as provided in Resolution 2019-03, attached hereto as Exhibit C , prior to the determination of the amounts owed by the members of REMIF prior to July 1, 2021 under the apportionment provided herein.

C. The apportionment of the Retirement Liability of CIRA among the former and current members of CIRA and REMIF, as identified in Appendix A and B, and the obligation to pay their share of the CIRA Retirement Liability as provided herein, shall be a separate and independent obligation from the obligation of the Member Entities arising upon termination, expulsion or withdrawal of a Member Entity or upon termination of the JPA Agreement including but not limited to ARTICLES XII, XIII, XIV, and XV of that Agreement.

ARTICLE V

TERM OF AGREEMENT
This Agreement shall become effective as of the date hereof and shall continue in full force and effect for the purpose of paying 100% of the Retirement Liability of CIRA pursuant to the apportionment among former and current members of CIRA and REMIF, as identified in Appendix A and B,, as provided for herein.

Page 87 ends

Adopted May 20, 2022 8
ART

ICLE VI

SEVERABILITY
Should any portion, term, condition or provision of this Agreement be decided by a court of competent jurisdiction to be illegal or in conflict with any law of the State of California, or be otherwise rendered unenforceable or ineffectual, the validity of the remaining portions, terms, conditions and provisions shall not be affected thereby.

ART

ICLE VII

AGREEMENT COMPLETE
The foregoing constitutes the full and complete agreement of the parties. There are no oral understandings or agreements not set forth in writing herein, except as noted with respect to the Bylaws and Memoranda of Coverage. If any provision of this Agreement conflicts with a provision of the Bylaws, Memoranda of Coverage or other document, such conflicting provisions shall be interpreted to avoid any such conflict, but this Agreement shall govern.

ARTICLE VIII

AMENDMENTS
This Agreement may be amended by a two -thirds vote of the Board present and voting at any duly convened regular or special meeting; provided that, any such amendment has been submitted to the directors and the Member Entities at least thirty [30] days in advance of such meeting. Member Entities may, by resolution or ordinance, grant their director and alternate on the Board explicit authorization to approve and execute amendments to this Agreement on behalf of the Member Entity without the necessity of a resolution or ordinance of the legislative body of the

Page 88 ends

Adopted May 20, 2022 9
M
ember Entity confirming or ratifying such amendment. Any such amendment shall become effective immediately, unless otherwise stated therein.

ART

ICLE IX

EXECUTION OF COUNTERPARTS
This Agreement may be executed in any number of counterparts, each of which when so executed shall be deemed to be an original, but altogether shall constitute one and the same Agreement.

California Intergovernmental Risk Authority [“CIRA’]
D
ate: By: ________________________________
CIRA General Manager
Attest: ______________________________
CIRA Deputy Secretary
M
ember Entity: _______________________
D
ate: By: ________________________________
Name/Title
A
ttest: ______________________________
City/Town Clerk

Page 89 ends

Adopted May 20, 2022 10
AP

PENDIX A
C

ALIFORNIA INTERGOVERNMENT RISK AUTHORITY
(
CIRA)
M

EMBER ENTITIES
C
ity of Amador City
City of Arcata
City of Avalon
City of Belvedere
City of Blue Lake
City of California City
City of Calimesa
City of Calistoga
City of Citrus Heights
City of Clearlake
City of Cloverdale
City of Coalinga
City of Cotati
City of Eureka
City of Ferndale
City of Fort Bragg
City of Fortuna
City of Grass Valley
City of Healdsburg
City of Highland
City of Lakeport
City of Menifee
City of Nevada City
City of Placentia
City of Placerville
City of Plymouth
City of Point Arena
City of Rancho Cucamonga
Rancho Cucamonga Fire Protection District
City of Rancho Santa Margarita
City of Rohnert Park
City of San Juan Bautista
City of Sebastopol
City of Sierra Madre
City of Sonoma
City of St. Helena
City of South Lake Tahoe
City of Tehama

Page 90 ends

Adopted May 20, 2022 11
C
ity of Trinidad
Town of Truckee
City of Twentynine Palms
City of Ukiah
City of Watsonville
City of Wheatland
City of Wildomar
City of Wilits
City of Windsor
Town of Yountville
City of Yucaipa
Town of Yucca Valley

Page 91 ends

Adopted May 20, 2022 12
AP
PENDIX “B”
P

UBLIC AGENCY RISK SHARING AUTHORITY OF CALIFORNIA
[PARSAC]

MEMBER ENTITIES
C
ity of Amador City
City of Avalon
City of Belvedere
City of Blue Lake
City of California City
City of Calimesa
City of Calistoga
City of Citrus Heights
City of Clearlake
City of Coalinga
City of Ferndale
City of Grass Valley
City of Highland
City of Menifee
City of Nevada City
City of Placentia
City of Placerville
City of Plymouth
City of Point Arena
City of Rancho Cucamonga
Rancho Cucamonga Fire Protection District
City of Rancho Santa Margarita
City of San Juan Bautista
City of South Lake Tahoe
City of Tehama
City of Trinidad
Town of Truckee
City of Twentynine Palms
City of Watsonville
City of Wheatland
City of Wildomar
Town of Yountville
City of Yucaipa
Town of Yucca Valley

Page 92 ends

Adopted May 20, 2022 13
RE

DWOOD EMPIRE MUNICIPAL INSURANCE FUND
(REMIF)
City
of Arcata
City of Cloverdale
City of Cotati
City of Eureka
City of Fort Bragg
City of Fortuna
City of Healdsburg
City of Lakeport
City of Rohnert Park
City of Sebastopol
City of Sonoma
City of St. Helena
City of Ukiah
City of Willits
City of Windsor
APP
ENDIX “B”
PUB

LIC AGENCY RISK SHARING AUTHORITY OF CALIFORNIA
[PARSAC]

FORMER MEMBER ENTITIES
City
of Alturas
City of Canyon Lake
City of Carlsbad
City of Elk Grove
City of Hesperia
City of Pacific Grove
City of Rialto
City of Ridgecrest
City of Rio Dell
City of West Hollywood
RE

DWOOD EMPIRE MUNICIPAL INSURANCE FUND
(RE
MIF)
City
of Crescent City

Page 93 ends

APPENDIX C

Page 94 ends

Page 95 ends

DATE:August 17, 2022
TO:Mayor and Members of the City Council
FROM:John R. Gillison, City Manager
INITIATED BY: Ernie Perez, Chief of Police
Jerry Davenport, Administrative Lieutenant
Karen Hunt, Sheriff’s Service Specialist
SUBJECT: Consideration of an Award to Vigilant Solutions for the Purchase of and an Appropriation in the Amount of $26,750 for the Subscription Renewal of the Camera License Keys (CLK) Fees Used at Each Automated License Plate Reader (ALPR) Location. (CITY)
RECOMMENDATION:

Staff recommends the City Council approve an award to Vigilant Solutions for the purchase of and an appropriation of funds for the ongoing annual subscription renewal of camera license key (CLK) fees as included in the FY2022/23 Adopted Budget.

BACKGROUND:

In the fall of 2014, the Police Department, with the approval of the City Council, embarked on the initial installation of both mobile and fixed ALPR cameras from Vigilant Solutions, as a Single Source vendor. Since then, the patrol fleet has been equipped with twelve 4-camera mobile ALPR platforms, two traffic trailers with 2-cameras each and cameras installed at a total of fifteen intersections throughout the city of Rancho Cucamonga. Data from these cameras is loaded into a shared database maintained by the vendor, Vigilant Solutions, and is used routinely to search for a variety of felony subjects associated with criminal activity occurring within the region. These cameras have proven to be very effective in the solving of felony crimes since their placement in the spring of 2015. CLK’s are a key component in sending the information from our ALPR cameras back to the database where it can be accessed.

ANALYSIS:

The camera license keys connect the database with the existing ALPR’s that are in place as envisioned for the city of Rancho Cucamonga. The data from these cameras will continue to be used to investigate and solve crimes occurring within the region.

FISCAL IMPACT:

The City of Rancho Cucamonga is billed annually for the camera license key fees. Currently new project funding includes five years of the CLK fees paid upfront. In the upcoming years the annual cost will grow to cover the CLK that have been in place beyond the five years of initial prepaid fees. Funding for this year’s CLK fees are included in the FY2022/23 Adopted Budget in the General Police Fund as follows:
1001701-5217-7217-6255 $26,750.00

Page 96 ends

Page 2 ends

1 4
1 7
COUNCIL MISSION / VISION / VALUE(S) ADDRESSED:

Automated License Plate Readers align with the following Council Core Values:
#2 Promoting and enhancing a safe and healthy community for all. #4 Intentionally embracing and anticipating the future.

ATTACHMENTS:

Attachment 1- Quote TXB-0006-01

Page 97 ends

City Of Rancho Cucamonga
Quote for:

Attn:

Karen Hunt

Reference:

CLK Fees

Quote By:

Tanya Brames

Date:
01-14-22

Page 98 ends

Page 1 of 2 ends

Vigilant Solutions is about protecting officers, families and communities. Vigilant is about saving lives – creating innovative and essential intelligence solutions for law enforcement that enhance policing efforts. Intelligence can solve crimes, prevent crimes before they occur, and improve safety for officers and the public that they serve and protect. Vigilant’s solutions are designed to collect, organize and share data to credentialed law enforcement personnel, making intelligence actionable and readily accessible.

WHAT WE DO:

OUR PRODUCTS:
● License Plate Recognition (LPR) Data and Analytics
● Fixed and Mobile LPR Cameras
● Body Worn Cameras
● Facial Recognition
● Campus Safety Solutions
● Parking Enforcement Solutions
● Corporate Security Solutions

Page 99 ends

Page 2 of 2 ends

(Including All Adds)
(Excluding sales tax)
$26,750.00 Total Price
Vigilant Solutions, LLC
1152 Stealth Street
Livermore, California 94551
(P) 925-398-2079 (F) 925-398-2113
Issued To: City Of Rancho Cucamonga - Attention: Karen Hunt Date: 01-14-22 Project Name: CLK Fees Quote ID: TXB-0006-01

PROJECT QUOTATION
We at Vigilant Solutions, LLC are pleased to quote the following systems for the above referenced project:

Additional Options
Qty Item # Description
(107) VS-CLKFEE CLK renewal is for Service Period Jul'22-Jun'23 Subtotal Price (Excluding sales tax) $26,750.00
Quote Notes:

1. All prices are quoted in USD and will remain firm and in effect for 60 days.

2. Returns or exchanges will incur a 15% restocking fee.

3. Orders requiring immediate shipment may be subject to a 15% QuickShip fee.

4. This Quote is provided per our conversation & details given by you - not in accordance to any written specification.

5. This Quote does not include anything outside the above stated bill of materials.

Quoted by: Tanya Brames – 832-588-0075 - [email protected]

Page 100 ends

DATE:August 17, 2022
TO:Mayor and Members of the City Council
FROM:John R. Gillison, City Manager
INITIATED BY: Ernie Perez, Chief of Police
Jerry Davenport, Administrative Lieutenant
Karen Hunt, Sheriff’s Service Specialist
SUBJECT: Consideration of an Appropriation in the Amount of $386,300 for the Purchase of Fixed Position Automated License Plate Reader Cameras to be Installed at Three Intersections and to Purchase Additional Surveillance Cameras to Replace or be Added to the Public Service Video Network (PSVN) at the Cultural Center and at City Hall. (CITY) RECOMMENDATION:

Staff recommends the City Council approve the purchase of fixed position automated license plate reader (ALPR) cameras to be installed at three intersections – Haven Ave./Foothill Blvd., Baseline Ave./Milliken Ave. and Baseline Ave./ Archibald Ave. from Vigilant Solutions as a sole source vendor in the amount of $358,300 from the Law Enforcement Reserve Fund. Additionally, staff requests approval to replace and add additional surveillance cameras to the PSVN system at two project locations, Cultural Center and City Hall, for a total amount of $28,000.

BACKGROUND:

In the fall of 2014, the Police Department, with the approval of the City Council, embarked on the initial installation of both mobile and fixed ALPR cameras from Vigilant Solutions, as a Single Source vendor. Since then, the patrol fleet has been equipped with twelve 4-camera mobile ALPR platforms, two traffic trailers with 2-cameras each and cameras installed at a total of fifteen intersections throughout the City of Rancho Cucamonga. Data from these cameras is loaded into a shared database maintained by the vendor, Vigilant Solutions, and is used routinely to search for a variety of felony subjects associated with criminal activity occurring within the region. These cameras have proven to be very effective in the solving of felony crimes since their placement in the spring of 2015.

In 2013, the City Council approved the initial phase of the PSVN which was installed around the Victoria Gardens Shopping Mall. In the years that followed, the PSVN has expanded to other locations including the Metrolink Parking Facility, City Hall, Rancho Cucamonga Public Libraries and all four high schools located within the City. Quotes on file with the City Clerk’s Office.

Page 101 ends

Page 2 ends

1 4
1 8
ANALYSIS:

The proposed installation is an expansion of the existing ALPR footprint envisioned for the City of Rancho Cucamonga. This ALPR project will provide fixed camera coverage for each lane of traffic in all directions at these three intersections. The data from these cameras will continue to be used to investigate and solve crimes occurring within the region.

There are currently PSVN cameras located at the Cultural Center. However, some are at end of life. We plan to replace these with higher quality cameras, as well as adding three new cameras to areas that are not covered by the existing cameras.

City Hall is also equipped with PSVN cameras that cover several interior and exterior locations to assist with deterring and solving criminal activity. This proposed project would add two cameras to the plaza area that is currently not covered well by the existing PSVN cameras.

FISCAL IMPACT:

The three ALPR project locations, at a total cost of $358,300, will roll out simultaneously and will be completed during Fiscal Year 2022/23. The cost includes tax, delivery, custom installation and an extended service warranty and Camera License Key costs for five years. During recent fixed ALPR installations, we’ve learned that some of the City conduit accessed during the projects are not adequate to run the project cabling through. Each of these three project locations has a $10,000 contingency amount added to ensure enough funds to troubleshoot any of these conduit issues. Funding for these projects is included in the FY2022/23 Adopted Budget in the Law Enforcement Reserve Fund as follows:
1017701-5603 $293,300.00
1017701-5300 $ 65,000.00
The two PSVN projects will also be completed in fiscal year 22/23. The need to update and supplement the cameras at these two project locations were not yet realized and therefor were not included in the FY2022/23 Adopted Budget for the Law Enforcement Reserve Fund. We are asking the City Council to approve appropriation of these funds:
1017701-5603 $11,000.00
1017701-5207 $17,000.00
COUNCIL MISSION / VISION / VALUE(S) ADDRESSED:

The upcoming projects will align with the following Council Core Values:
#2 Promoting and enhancing a safe and healthy community for all. #4 Intentionally embracing and anticipating the future.

ATTACHMENTS:

None.

Page 102 ends

DATE:August 17, 2022
TO:Mayor and Members of the City Council
FROM:John R. Gillison, City Manager
INITIATED BY: Jennifer Hunt Gracia, Community Services Director Jenny Hanlon, Community Services Supervisor
SUBJECT: Consideration of a Professional Service Agreement with Gentry General Engineering, Inc. for Removal of the Existing Horseshoe and Shuffleboard Courts and Construction of Pickleball Courts at Red Hill Community Park in an Amount Not to Exceed $109,362.00. (CITY)
RECOMMENDATION:

Staff recommends that the City Council:

1. Award and authorize the execution of a professional services agreement (PSA) for demolition and removal of the underutilized horseshoe and shuffleboard courts at Red Hill Community Park and construction of three (3) pickleball courts with Gentry General Engineering Inc of Rancho Cucamonga, California.

2. Authorize an expenditure in an amount not to exceed $109,370 (10% contingency included).

BACKGROUND:

In 2019 the City painted three pickleball courts on the outdoor basketball courts at the RC Sports Center. In 2020, due to the Covid-19 pandemic, the RC Sports Center canceled normal operations; however, with CDC approval for pickleball to be played in an outdoor environment, the pickleball courts remained available for the community to utilize.

According to the Sports and Fitness Industry Association, pickleball is the fastest-growing sport in the United States. Since 2020, pickleball courts have become increasingly popular with the sport's growth. To meet the increasing need within the city, and with funds donated by the Senior Pickle Ball Club, two additional courts were painted at the RC Sports Center in 2022, bringing current court inventory to five outdoor courts.

Red Hill Community Park has underutilized horseshoe and shuffleboard courts at the park’s north end. Upon evaluation, staff determined Red Hill Community Park would be the best location to construct pickleball courts based on costs, proximity to seating and shade, as well as an opportunity to reactivate an underutilized portion of the park by providing the community a new amenity for all ages and skill levels.

In March 2022, City staff hosted 3 community meetings at the RC Sports Center to discuss the needs of the pickleball community. Based on feedback, specifications for three pickleball courts, including permanent nets, were provided for an official Request for Bid on July 7, 2022, on file in the City Clerk’s office.

Page 103 ends

Page 2 ends

1 4
1 6
ANALYSIS:

Gentry General Engineering, Inc. provided a bid within the budgeted amount for the Red Hill Community Park pickleball court project. Only one other bid was received, far exceeding the budgeted amount. Therefore, staff recommends City Council authorize the execution of a professional service agreement for an amount not to exceed $109,370 for the construction of the pickleball courts at Red Hill Community Park.

FISCAL IMPACT:

The cost for the project is $99,420.00, and a 10% contingency has been added to the professional service agreement utilizing account 1001401-5607/5005401-00005607 Capital Outlay- Recreation Improvements. Additional funds of approximately $1,500, annually, will be needed for net replacement and maintenance of the courts which is budgeting by the Community Services Department in Sports Operations.

COUNCIL MISSION / VISION / VALUE(S) ADDRESSED:

This project supports the City Council’s core values of promoting and enhancing a safe and healthy community for all and embracing and anticipating the future by constructing pickleball courts in the City of Rancho Cucamonga, promoting physical activity and increasing the resources for a fast-growing sport.

Page 104 ends

DATE:August 17, 2022
TO:Mayor and Members of the City Council
FROM:John R. Gillison, City Manager
INITIATED BY: William Wittkopf, Public Works Services Director Neil Plummer, Facilities Superintendent
Kenneth Fung, Assistant Engineer
SUBJECT: Consideration to Award a Contract to Ace Electric, Inc. for the "Heritage and Etiwanda Creek Parks LED Sports Lighting Upgrade Project". (CITY) RECOMMENDATION:

Staff recommends that the City Council:

1. Approve the project plans and specifications.

2. Accept the bids received.

3. Award and authorize the execution of a contract in the amount of $248,000 (Base Bid) for the “Heritage and Etiwanda Creek Parks LED Sports Lighting Upgrade Project” to the lowest responsive bidder, Ace Electric, Inc. of San Diego.

4. Authorize the expenditure of a contingency in the amount of $44,000.

5. Appropriate $161,700 from PD 85 fund balance to account 1848303-5607.

6. Appropriate $130,300 from Capital Reserves fund balance to account 1025001- 5607.

BACKGROUND:

This project will replace the sports lighting fixtures for the senior sports field at Heritage Park and the south football/soccer field at Etiwanda Creek Park with more energy efficient and longer lasting light emitting diode (LED) lighting fixtures. This upgrade will greatly reduce maintenance, labor and materials costs, and include a new mounting system that will eliminate the risk of damaged fixtures falling to the ground during a wind event. The lights currently in place at Heritage Park are a mix of different fixtures from other locations that have been used over the years with replacement lamps no longer available for purchase.

ANALYSIS:

Four (4) bids for this project were opened at 2:00 pm on Tuesday, July 5, 2022, see attachment 1 - Bid Summary. Staff has completed the required background investigation and finds that the lowest responsive bidder, Ace Electric, Inc. of San Diego, has met the requirements and specifics of the bid documents and process. The project is scheduled to be completed within twenty-five (25) working days.

During the bidding process, it was discovered that the original project plans for Heritage Park and Etiwanda Creek Park did not specifically show that the sports lighting poles, for mounting the new LED sports lighting fixtures, at both parks were properly grounded. As a result, a pair of Additive

Page 105 ends

Page 2 ends

1 4
1 9
Bid items were included in the project bid documents seeking the costs of grounding the sports lighting poles. Ace Electric, Inc.’s cost to ground the 6 sports lighting poles at Heritage Park is $13,200 and their cost to ground the 4 sports lighting poles at Etiwanda Creek Park is $6,000. Combining these two additive bid costs with the 10% contingency amount of $24,800, taken from the base bid amount, results in staff requesting an authorization for the expenditure totaling $44,000. The grounding of the sports lighting poles at Heritage Park and at Etiwanda Creek Park are not part of the contract award amount. If it turns out that grounding of the sports lighting poles is necessary, then the cost of groundwork will be handled as a contract change order. A copy of the project contract can be found at the City Clerk’s Office.

FISCAL IMPACT:

Originally, funding ($100,000 for each park) was included in the Fiscal Year 2021/2022 adopted budget for this project in account numbers 1848303-5607 (PD 85) and 1025001-5607 (Capital Reserve). Unfortunately, the contracts for design consultants / architectural services for multiple firms were not approved until March 2022, which meant that the project plans and specifications could not be completed in time to bid and award this project before the end of Fiscal Year 2021/2022. To award this project, appropriations are requested from PD 85 fund balance in the amount of $161,700 and from Capital Reserve fund balance in the amount of $130,300.

COUNCIL MISSION / VISION / VALUE(S) ADDRESSED:

This item addresses City Council core values of promoting a safe and healthy community for all by ensuring City facilities are properly maintained.

ATTACHMENTS:

Attachment 1 - Bid Summary

Page 106 ends

JULY 5, 2022 BID OPENING SUMMARY

HERITAGE AND ETIWANDA CREEK PARKS LED SPORTS LIGHTING UPGRADE PROJECT BASE BID Ace Electric, Inc. Rex Moore
Alliance Electrical Systems,
Inc. Electro Construction Corp. Average of
Unit Pricesitem Description Qty Unit Unit Price Cost Unit Price Cost Unit Price Cost Unit Price Cost 1 Mobilization for work at Heritage
Park 1 LS $5,000.00 $5,000.00 $5,000.00 $5,000.00 $2,500.00 $2,500.00 $4,166.67 2 Video Recording of on-site
conditions before start of work and
after completion of work at Heritage
Park 1 LS $1,000.00 $1,000.00 $2,500.00 $2,500.00 $2,500.00 $2,500.00 $2,000.00 3 All work necessary to remove and
dispose of existing lighting along
with manufacture, installation,
testing, etc. of new LED lighting at
Heritage Park 1 LS $129,000.00 $129,000.00 $84,080.00 $84,080.00 $220,900.00 $220,900.00 $144,660.00 4 Mobilization for work at Etiwanda
Creek Park 1 LS $5,000.00 $5,000.00 $5,000.00 $5,000.00 $2,500.00 $2,500.00 $4,166.67 5 Video Recording of on-site
conditions before start of work and
after completion of work at
Etiwanda Creek Park 1 LS $1,000.00 $1,000.00 $2,500.00 $2,500.00 $2,500.00 $2,500.00 $2,000.00 6 All work necessary to remove and
dispose of existing lighting along
with manufacture, installation,
testing, etc. of new LED lighting at
Etiwanda Creek Park. 1 LS $107,000.00 $107,000.00 $64,581.00 $64,581.00 $177,800.00 $177,800.00 $116,460.33 BASE BID TOTAL = $248,000.00 $163,661.00 $360,000.00 $408,700.00 Included Signed Addendum No 1? Y/N Yes No No Yes
Included LED Lighting Submittals? Yes Yes Yes Yes
Is Bid Proposal Responsive? Why? Yes
NO! Did not used revised
Addendum No 1 sheets.

NO! Used own form did
not use City issued bid
proposal.

NO! Did not put company
name at bottom of each bid
proposal (P) sheet.

ADDITIVE BIDS Ace Electric, Inc. Rex Moore
Alliance Electrical Systems,
Inc. Electro Construction Corp. Average of
Unit Pricesitem Description Qty Unit Unit Price Cost Unit Price Cost Unit Price Cost Unit Price Cost 7 Controller System for new LED
Sports Lighting Installed at Heritage
Park 1 LS $20,000.00 $20,000.00 $5,000.00 $5,000.00 $31,970.00 $31,970.00 $18,990.00 8 Controller System for new LED
Sports Lighting Installed at Etiwanda
Creek Park 1 LS $23,000.00 $23,000.00 $4,500.00 $4,500.00 $31,970.00 $31,970.00 $19,823.33 9 Electrical Conduit Rework and
Grounding Below 10 Foot High
Electrical Connection Point of
Existing Sports Lighting Poles at
Heritage Park 6 EA $2,200.00 $13,200.00 $0.00 $0.00 $3,296.00 $19,776.00 $1,832.00 10 Electrical Conduit Rework and
Grounding Below 10 Foot High
Electrical Connection Point of
Existing Sports Lighting Poles at
Etiwanda Creek Park 4 EA $1,500.00 $6,000.00 $0.00 $0.00 $3,975.00 $15,900.00 $1,825.00 11 25 Year Extended Warranty,
Heritage Park (optional bid item) 1 LS $129,000.00 $129,000.00 These
Additive Bid
items were
added as
part of
Addendum
No 1.
not bid not bid $129,000.00
12 25 Year Extended Warranty,
Heritage Park (optional bid item) 25 Years $7,500.00 $187,500.00 not bid not bid $7,500.00 13 25 Year Extended Warranty,
Etiwanda Creek Park (optional bid
item) 1 LS $107,000.00 $107,000.00 not bid not bid $107,000.00 14 25 Year Extended Warranty,
Etiwanda Creek Park (optional bid
item) 25 Years $6,500.00 $162,500.00 not bid not bid $6,500.00 ADDITIVE BIDS 7 THRU 10, 11 and 13 TOTAL = $298,200.00 $9,500.00 $99,616.00 ADDITIVE BIDS 7 THRU 10, 12 and 14 TOTAL = $412,200.00 $9,500.00 $99,616.00 ATTACHMENT 1 - BID SUMMARY

Page 107 ends

DATE:August 17, 2022
TO:Mayor and Members of the City Council
FROM:John R. Gillison, City Manager
INITIATED BY: William Wittkopf, Public Works Services Director Ernie Perez, Police Chief
Neil Plummer, Facilities Superintendent
SUBJECT: Consideration of a Contract with Tinker Glass Contractors, Inc. for the Emergency Installation of Ballistic Glass on the Plaza Level of the Rancho Cucamonga Police Facility in the Amount of $165,025. (CITY) RECOMMENDATION:

Staff recommends the City Council:

1. Declare an emergency exists with the potential to cause harm to staff within the Rancho Cucamonga Police Department facility requiring the installation of ballistic glass and bypass the formal bidding process.

2. Award and authorize the execution of a contract with Tinker Glass Contractors, Inc. for the installation of ballistic glass on the plaza level of the Rancho Cucamonga Police Facility.

3. Authorize the expenditure of $165,025.

4. Appropriate $165,025 from the Law Enforcement Reserve fund balance to account 1017701-5602.

BACKGROUND:

When the Rancho Cucamonga Police Department (RCPD) facility was originally constructed the Plaza Level was not built using ballistic glass. Today, ballistic glass is an industry standard in any law enforcement facility. Over the last year, there have been three incidents that have resulted in broken glass and a partial facility breach. As a result, staff has been called upon to deal with an increasing level of damage to the RCPD facility that includes the use of rocks and other implements to break the glass doors and windows causing damage to the facility. The Plaza Level consists of three sides of the building in which members of the public have direct access to walk up to the doors and windows. Gaining access through one of these doors or windows would allow immediate access to the interior Plaza Level, and the ability of further access of the first and third levels of the building.

It is imperative that the facility is secured to keep someone from breaking the glass and making entry into the building which could potentially jeopardize the safety of employees, as well as members of the public. Law enforcement facilities contain information, documents, and equipment that are sensitive in nature and have a necessity to remain secured to prevent them from being accessed by unauthorized persons. Additionally, there is a need to provide an enhanced level of protection for the staff working within the RCPD Plaza Level offices. As the threat of violence directed at law enforcement has increased over the past several years, the current non-ballistic

Page 108 ends

Rancho Cucamonga City CouncilAugust 17, 2022

Rancho Cucamonga City Council
August 17, 2022