Agenda — Finance Committee, May 6, 2024

AGENDA

FINANCE/AUDIT COMMITTEE

SPECIAL MEETING NOTICE
MAY 6, 2024
PUBLIC MEETING 3:00 P.M.

Members
Victor M. Gordo, Mayor
Tyron Hampton, District 1
Felicia Willia ms, Dist rict 2
STAFF
Matthew Hawkesworth, Director of Finance
Lisa Hosey, Assistant City Attorney
Gloria Acevedo, Recording Secretary

MISSION STATEMENT
The City of Pasadena is dedicated to delivering exemplary municipal services, responsive to our entire community and consistent
with
our history, culture and unique character.

I
n compliance with the Americans with Disabilities Ac t of 1990, Assistive Listening Devices are available from the City Clerk’s Of fice with a 24-hour advance notice.

Please call (626) 744-4124 to request use of a listening device.

Language translation services are available for this meeting by calling (626)74
4-4124 at least 24 hours in advance.

Habrá servicio de interpretación disponible para éstas juntas llamando al (626)744-4124 por lo menos con 24 horas de anticipación.

Meetings
are broadcast live on cable Channel 3 and on the Internet at http://pasadena.granicus.com/mediaplayer.php?camera_i d=2&publish_id=9 and https://www.pasadenamedia.org/watch/ (Click on Video Streamlining on the right side of the screen).

Items
on the agenda may not be called in order listed. Agendas and supporting documents are available on the Internet at
https://www.cityofpasadena.net/commissions/city-council-finance-committee/ Materi
als related to an item on this Agenda submitted to the Finance/Audit Committee after distribution of the agenda packet will be posted online and listed as: “Supplemental Agenda Material Received after the Posting of the agenda”

PUBLIC COMMENT AT THE FINANCE/AUDIT COMMITTEE SPECIAL MEETING FOR MAY 6, 2024, AT 3:00 P.M. WILL BE ACCEPTED IN-PERSON AND BY VIDEOCONFERENCE/TELECONFERENCE.

Link
to City Meeting Policy:
cityofpasadena.net/CityCouncilMeetingPolicy
TO V
IEW A LIVE STREAM OF THE MEETING:
http:
//pasadena.granicus.com/MediaPlayer.php?publish_id=9
AND
WWW.P
ASADENAMEDIA.ORG
In order to facilitate public participation at meetings the City will accept public comment in the following manner:

1. Whether participating in-person or virtually at the meeting, members of the public may provide public comment by submitting a speaker card prior to the start of public comment on that item, at the following webpage:
www.cityofpasadena.net/commissions/public-comment/
If a public comment speaker wishes to speak on more than one agenda item, please indicate which items on the online form (multiple item speakers will be handled according to the process posted on the agenda and as specified in the City meeting policy). Public comments are limited to 3 minutes each, and the Chair and Committee may limit this time if reasonable under the circumstances.

2. In-person Meeting Participation: Complete an online speaker card at the following website: www.cityofpasadena.net/commissions/public-comment/ After submitting a public speaker card, members of the public may attend the meeting in-person by coming to the Pasadena City Council Chamber, Room S249 at City Hall at the date and start-time of the posted meeting.

Virtual Meeting Participation: For virtual participants, you may attend by connecting to the meeting using a computer, other electronic device, or by telephone. Please review the agenda to identify the published start time for the meeting and connect to the meeting just prior to, or at the start of the meeting.

To participate in public comment for an item and to be recognized to speak, it is required that the speaker login to the meeting using the same name or telephone number used on the Speaker Card form. This will allow City staff to locate and promote the speaker into the meeting when it is time for their public comment.

Participants’ phone calls to the Committee meeting will be recorded as part of the Committee meeting. By staying on the line and making public comment during the Committee meeting by phone, you are agreeing to have your phone call recorded. Following is the connectivity information for virtual participation:

Computer or electronic devices, join the meeting at: cityofpasadena.net/cczoom Telephone only dial-in: 1-669-900-6833, Meeting ID: 161 482 446

3. Speaker Card Help Line: If a public comment speaker needs assistance in completing a speaker card, please call the City Clerk’s Office at: (626) 744-4124.

Help line will open 30 minutes prior to the posted start time of the meeting.

4. Members of the public may submit correspondence of any length prior to the start of the meeting, at the following email address:
gacev
[email protected]
Cor
respondence will be forwarded to the Committee prior to the start of the meeting, posted online, and made part of the legislative record for the item.

LIVESTREAM WITH CAPTIONING IS AVAILABLE AT WWW.PASADENAMEDIA.ORG, AND ALSO AT WWW.CITYOFPASADENA.NET/COMMISSIONS/AGENDAS, IF

YOU NEED A REASONABLE MODIFICATION OR ACCOMMODATION PURSUANT

TO THE AMERICANS WITH DISABILITIES ACT

BECAUSE YOU ARE UNABLE TO PARTICIPATE ELECTRONICALLY AS SET FORTH ABOVE, CONTACT THE CITY CLERK’S OFFICE
AS SOON AS POSSIBLE AT (626) 744-4124 OR
[email protected].

SPECIAL MEETING
AGENDA

FINANCE/AUDIT COMMITTEE
MAY 6,
2024
Public Meeting: 3:00 P.M.

Council Chamber, Pasadena City Hall
100 North Garfield Avenue, Room S249
PUBLIC MEETING – 3:00 P.M.

ROLL CALL
PUBLIC COMMENT – LIMITED TO ITEMS ON THIS SPECIAL MEETING

AGENDA AND WILL BE HEARD AT THE TIME THE ITEM IS CONSIDERED

APPROVAL OF MINUTES

NEW BUSINESS

1. FIS
CAL YEAR JUNE 30, 2023, SINGLE AUDIT REPORT AND SAFE, CLEAN

WATER PROGRAM (SCW PROGRAM) AUDIT REPORT

2. DIRECT

THE CITY ATTORNEY TO PREPARE AN ORDINANCE TO AMEND
PASADENA MUNICIPAL CODE CHAPTER 4.100 TO CONFORM TO RECENT

CHARTER AMENDMENT ADDRESSING THE ANNUAL POWER FUND

TRANSFER TO THE GENERAL FUND

3. BUDGET WORKSHOP FY 2025 RECOMMENDED OPERATING BUDGET OPE
RATING BUDGET PRESENTATIONS:

A. HUMAN RESOURCES
B. CI
TY MANAGER’S OFFICE

INFORMATION ONLY

4. ROSE

BOWL OPERATING COMPANY FINANCIAL UPDATE

5. PASADE

NA CENTER OPERATING COMPANY FINANCIAL UPDATE

6. FY 2
024 CAPITAL IMPROVEMENT PROGRAM - THIRD QUARTER MONITORING REPORT

ADJOURN
PAGE 1

NEW BUSINESS
ITEM 1

1. FISCAL YEAR JUNE 30, 2023, SINGLE AUDIT REPORT

AND SAFE, CLEAN WATER PROGRAM (SCW

PROGRAM) AUDIT REPORT
PAGE 2
May 6, 20
24 TO: Honorabl
e Mayor and City Council/Successor to Pasadena
Community Development Commission
THROUGH: F
inance/Audit Committee
FROM: Depar
tment of Finance

SUBJECT
: FISCAL YEAR JUNE 30, 2023, SINGLE AUDIT REPORT AND

SAFE, CLEAN WATER PROGRAM (SCW PROGRAM) AUDIT
REPORT
RECOMMENDATION:

This age
nda report is provided for information only; no action is required at this time.

A. Single A
udit Report; and
B. Safe, Clean Water Program, (SCW Program) Financial Statements EXECUTIVE SUMMARY:

This ac
tion is to receive and file the City’s Single Audit Report and SCW Program Financial Statements, for the Fiscal Year (FY) ended June 30, 2023. All financial statements received an unmodified (or clean) opinion. The Single Audit Report reiterates that there were two financial statement findings and reports no grant related findings. The two financial statement findings were related to the timeliness of the bank reconciliation preparation and the number of post-closing journal entries made by City staff, after the start of the audit. The SCW Program audit noted three instances of non-compliance. The first non-compliance occurrence was related to the timeliness of the City’s submittal of the annual progress/expenditure reports, the second instance of non-compliance was related to the lack of interest allocation to the SCW Program funds, and the final non-compliance was related to the minimum threshold of expenditures to be utilized annually. The City did not attain the required threshold of SCW Program expenditures in FY 21-22 and FY 22-23.

PAGE 3
Fiscal Year June 30, 2023, Single Audit and SCW Program Financials May 6, 2024

Page 2 of 3 ends

BACKGROUND:

Singl
e Audit Reports on Federal Awards (Attachment A)
The Si
ngle Audit Act establishes uniform audit requirements for local governments expending federal awards greater than $750,000 a year. The audit is on an “entity- wide” basis and imposes additional requirements in relation to testing of and reporting on, internal control and compliance with laws and regulations. The Single Audit Report for FY ended 2023 contains two reports and three schedules. The Single Audit Report reiterated that there were two financial statement findings, however reported no grant related findings.

Safe,
Clean Water Program Financial Statements (Attachment B) Measur
e W Fund was set up to administer resources received from the Los Angeles County Flood Control District (District), pursuant to the SCW Program. The purpose of the SCW program is to fund projects and programs to increase stormwater and urban runoff capture and reduce stormwater and urban runoff pollution in the District.

Forty percent of the annual SCW program tax revenues are allocated to Municipalities within the District for the implementation, operation and maintenance, and the administration of projects and programs, in accordance with the criteria and procedures established in Chapters 16 and 18 of the District Code.

The SCW P
rogram is new funding for the City. The City has been implementing new processes and procedures to ensure all requirements are met; however, the SCW Program audit noted three instances of non-compliance:
• Annual pr
ogress/expenditure reports were submitted to the District, beyond the six-month timeline requirement. Management has implemented year-end procedures to ensure timely submission for all year end reports. • Program regulations require the City to hold the funds under a separate interest-bearing account, to ensure interest earned from the account is spent only for SCW Program eligible expenditures. The City does not hold multiple accounts; however, performs monthly interest allocations, for funds with this requirement. Management has taken the corrective action to ensure interest is properly allocated to the SCW Program funds within the City’s general ledger.
• The City did not meet the required annual expenditure threshold of at least 70% of SCW Program funds. The City expended 65% of the funds. With the implementation of new projects and programs, costs were not incurred as anticipated, resulting in the 5% shortfall. The City does not expect future shortfalls.

PAGE 4
PAGE 5

CITY OF PASADENA, CALIFORNIA
FOR THE YEAR ENDED JUNE 30, 2023 SINGLE AUDIT REPORT
Attachment A
PAGE 6

CITY OF PASADENA, CALIFORNIA

Single Audit Report

For the Year Ended June 30, 2023

PAGE 7

CITY OF PASADENA, CALIFORNIA

Single Audit Report

For the Year Ended June 30, 2023

Table of Contents

Page
Number

Independent Auditors’ Report on Internal Control Over Financial Reporting and on Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards ....................................................................................... 1

Independent Auditors’ Report on Compliance for Each Major Program and on Internal Control Over Compliance; and Report on Schedule of Expenditures of Federal Awards Required by the Uniform Guidance ..................................................................................................... 3

Schedule of Expenditures of Federal Awards for the
Fiscal Year Ended June 30, 2023 .................................................................................................................... 6

Notes to the Schedule of Expenditures of Federal Awards ................................................................................. 7

Schedule of Findings and Questioned Costs for the
Fiscal Year Ended June 30, 2023 .................................................................................................................... 8

Summary Schedule of Prior Year Findings and Questioned Costs for the Fiscal Year Ended June 30, 2022 .................................................................................................................. 10

PAGE 8

INDEPENDENT AUDITORS’ REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING AND ON

COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN

ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS

To the Honorable Mayor and Members of the City Council
City of Pasadena, California

We have audited, in accordance with the auditing standards gene rally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards issued by the Comptroller General of the United States, the financial statements of the governmental activities, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information of the City of Pasadena, California (the “City”), a s of and for the year ended June 30, 2023, and the related notes to the financial statements, which collectively comprise the City’s basic financial statements, and have issued our report thereon dated December 28, 2023.

Report on Internal Control over Financial Reporting

In planning and performing our audit of the financial statement s, we considered the City’s internal control over financial reporting (internal control) as a basis for designing audit procedures that are appropriate in the circumstances for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the City’s internal control. Accordingly, we do not express an opinion on the effectiveness of the City’s internal control.

A deficiency in internal control exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned fu nctions, to prevent, or detect and correct, misstatements, on a timely basis. A material weakness is a deficiency, or a combination of deficiencies, in internal control, such that there is a reasonable possibility that a mat erial misstatement of the entity’s financial statements will not be prevented, or detected and corrected, on a timely b asis. A significant deficiency is a deficiency, or a combination of deficiencies, in internal control that is less s evere than a material weakness, yet important enough to merit attention by those charged with governance.

Our consideration of internal control was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control that might be material weaknesses or significant deficiencies and therefore, material weaknesses or significant deficiencies may exist that were not identified. Given these limitations, during our audit we did not identify any def iciencies in internal control that we consider to be material weaknesses. We identified certain deficiencies in internal control, described in the accompanying schedule of findings and questioned costs
as items 2023-001 and 2023-002 that we consider to be significant deficiencies.

Report on Compliance and Other Matters

As part of obtaining reasonable assurance about whether the Cit y’s financial statements are free from material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a direct and ma terial effect on the financial statements.

However, providing an opinion on compliance with those provisio ns was not an objective of our audit, and accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance or other matters that are required to be reported under Government Auditing Standards.

PAGE 9

To the Honorable Mayor and Members of the City Council
City of Pasadena, California

City of Pasadena’s Response to Findings

Government Auditing Standards requires the auditor to perform limited procedures on the City ’s response to the findings identified in our audit a s described in the accompanyi ng schedule of findings and questioned costs. The City’s response was not subjected to the other auditing procedu res applied in the audit of the financial statements and, accordingly, we express no opinion on the response.

Purpose of This Report

The purpose of this report is solely to describe the scope of o ur testing of internal control and compliance and the results of that testing, and not to provide an opinion on the e ffectiveness of the City’s internal control or on compliance. This report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the City’s internal control and compliance. Acco rdingly, this communication is not suitable for any other purpose.

Brea, California
December 28, 2023
2 PAGE 10

CONTROL OVER COMPLIANCE AND REPORT ON SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS

REQUIRED BY THE UNIFORM GUIDANCE

To the Honorable Mayor and Members of the City Council
City of Pasadena, California

Report on Compliance for Each Major Federal Program

Opinion on Each Major Federal Program
We have audited the City of Pasadena, California (the “City”)’s compliance with the types of compliance requirements identified as subject to audit in the OMB Compliance Supplement that could have a direct and material effect on each of the City’s major federal programs for the yea r ended June 30, 2023. The City’s major federal programs are identified in the summary of auditor’s results section of the accompanying schedule of findings and questioned costs.

In our opinion, the City complied, in all material respects, wi th the types of compliance requirements referred to above that could have a direct and material effect on each of i ts major federal programs for the year ended June 30, 2023.

Basis for Opinion on Each Major Federal Program
We conducted our audit of compliance in accordance with auditin g standards generally accepted in the United States of America; the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States; and the audit requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Our responsibilities under those standards and the Uniform Guidance are further described in the Auditor’s Responsibilities for the Audit of Compliance section of our report.

We are required to be independent of the City and to meet our o ther ethical responsibilities, in accordance with relevant ethical requirements relating to our audit. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our opinion on complianc e for each major federal program. Our audit does not provide a legal determination of the City’s compliance with the compliance requirements referred to above.

Responsibilities of Management for Compliance
Management is responsible for compliance with the requirements referred to above and for the design, implementation, and maintenance of effective internal control o ver compliance with the requirements of laws, statutes, regulations, rules, and provisions of contracts or gr ant agreements applicable to the City’s federal programs.

PAGE 11

To the Honorable Mayor and Members of the City Council
City of Pasadena, California

Auditor’s Responsibilities for the Audit of Compliance
Our objectives are to obtain reasonable assurance about whether material noncompliance with the compliance requirements referred to above occurred, whether due to fraud o r error, and express an opinion on the City’s compliance based on our audit. Reasonable assurance is a high l evel of assurance but is not absolute assurance and therefore is not a guarantee that an audit conducted in accordance with generally accepted auditing standards, Government Auditing Standards , and the Uniform Guidance will always detect material noncompl iance when it exists. The risk of not detecting material noncompliance result ing from fraud is higher than for that resulting from error, as fraud may involve collusion, forgery, intentional omissions, misrepresentations, or the override of internal control. Noncompliance with the compliance requirements referre d to above is considered material if there is a substantial likelihood that, individually or in the aggregate, it would influence the judgment made by a reasonable user of the report on compliance about the City’s compliance with the requirements of each major federal program as a whole.

In performing an audit in accordance with generally accepted auditing standards, Government Auditing Standards, and the Uniform Guidance, we:

x Exercise professional judgment and maintain professional skepticism throughout the audit.

x Identify and assess the risks of material noncompliance, wheth er due to fraud or error, and design and perform audit procedures responsive to those risks. Such proced ures include examining, on a test basis, evidence regarding the City’s compliance with the compliance re quirements referred to above and performing such other procedures as we considered necessary in the circumstances.
x Obtain an understanding of the City’s internal control over compliance relevant to the audit in order to design audit procedures that are appropriate in the circumstances and to test and report on internal control over compliance in accordance with the Uniform Guidance, but not for the purpose of expressing an opinion on the effectiveness of the City’s internal control over compliance. Accordingly, no such opinion is expressed.
We are required to communicate with those charged with governance regarding, among other matters, the planned scope and timing of the audit and any significant deficiencies and material weaknesses in internal control over compliance that we identified during the audit.

Report on Internal Control over Compliance

A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis.

A material weakness in internal control over compliance is a deficiency, or a combination of deficiencies, in internal control over compliance, such that there is a reasonable possib ility that material noncompliance with a type of compliance requirement of a federal program will not be prevented, or detected and corrected, on a timely basis. A significant deficiency in internal control over compliance is a deficiency, or a combination of deficiencies, in internal control over compliance with a type of compliance requirement o f a federal program that is less severe than a material weakness in internal control over compliance, yet impo rtant enough to merit attention by those charged with governance.

Our consideration of internal control over compliance was for t he limited purpose described in the Auditor’s Responsibilities for the Audit of Compliance section above and was not designed to identify all deficiencies in internal control over compliance that might be material weaknesses or significant deficiencies in internal control over compliance. Given these limitations, during our audit we d id not identify any deficiencies in internal control over compliance that we consider to be material weaknesses, as defined above. However, material weaknesses or significant deficiencies in internal control over compliance may exist that were not identified. 4 PAGE 12

To the Honorable Mayor and Members of the City Council
City of Pasadena, California

Our audit was not designed for the purpose of expressing an opi nion on the effectiveness of internal control over compliance. Accordingly, no such opinion is expressed.

The purpose of this report on internal control over compliance is solely to describe the scope of our testing of internal control over compliance and the results of that testing based on the requirements of the Uniform Guidance.

Accordingly, this report is not suitable for any other purpose.

Report on Schedule of Expenditures of Federal Awards Required by the Uniform Guidance

We have audited the financial statements of the governmental activities, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information of the City, as of and for the year ended June 30, 2023, and the related notes to the financial statements, which collectively comprise the City’s basic financial statements. We issued our report thereon dated December 28, 2023, which contained unmodified opinions on those financial statements. Our audit was performed for the purpose of forming opinions on the financial statements that collectively comprise the basic financial statements. The accompanying schedule of expenditures of federal awards is presented for purposes of additional analysis as required by the Uniform Guidance and is not a required part of the basic financial statements. Such information is the responsibility of management and was derived from and relates directly to the underlying accounting and other records used to prepare the basic financial statements. The information has bee n subjected to the auditing procedures applied in the audit of the financial statements and certain additional pr ocedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or to the basic financial statements themselves, and other addi tional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the schedule of expenditures of federal awards is fairly stated in all material respects in relation to the basic financial statements as a whole.

Brea, California
March 27, 2024 (Except for the Report on Schedule of Expenditur es of Federal Awards Required by the Uniform Guidance which is dated December 28, 2023)
5 PAGE 13

CITY OF PASADENA
Schedule of Expenditures of Federal Awards
For the Fiscal Year Ended June 30, 2023
Federal
Assistance Listing Unique Entity Passed-Through Total Federal Number Identifying Number to Subrecipients Expenditures SNAP Cluster
Department of Agriculture:

Passed through State of California Department of Health Services:

State Administrative Matching Grants for the
Supplemental Nutrition Assistance Program 10.561 JE73CDQUAPA7 - $ 307,846$ Total Department of Agriculture Programs - 307,846
To
tal SNAP Cluster - 307,846
CDBG - Entitlement Grants Cluster
Department of Housing and Urban Development Direct Programs:

Community Development Block Grants/Entitlement Grants 14.218 N/A 175,118 3,663,208 COVID-19 Community Development Block Grants/Entitlement Grants 14.218 N/A 66,454 279,739 Begi
nning loan balances 14.218 N/A - 26,148,378
Subt
otal - AL 14.218 241,572 30,091,325
Total Department of Housing and Urban Development Programs 241,572 30,091,325 Total CDBG - Entitlement Grants Cluster 241,572 30,091,325 Housing Voucher Cluster
Department of Housing and Urban Development Direct Programs:

Section 8 Housing Choice Vouchers 14.871 N/A - 17,561,600 COV
ID-19 Section 8 Housing Choice Vouchers (CARES Act) 14.871 N/A - 1,543,738 Begi
nning loan balances 14.871 N/A - 50,000
Subt
otal - AL 14.871 - 19,155,338
To
tal Department of Housing and Urban Development Programs - 19,155,338 Total
Housing Voucher Cluster - 19,155,338
WIOA Cluster
Department of Labor
Passed through State of California Department:

WIOA Adult Program 17.258 JK7YAK6HPFM6 - 574,033
WI
OA Youth Activities 17.259 JK7YAK6HPFM6 - 382,458
WIO
A Dislocated Worker Formula Grants 17.277 JK7YAK6HPFM6 - 528,512 WI
OA Dislocated Worker Formula Grants - Regional Planning Implementation 4.0 17.278 JK7YAK6HPFM6 - 97,729 WI
OA National Dislocated Worker Formula Grants 17.278 JK7YAK6HPFM6 - 831,064 WI
OA Dislocated Worker Formula Grants - Rapid Response Layoff Aversion 17.278 JK7YAK6HPFM6 - 124,907 Subt
otal - AL 17.278 - 1,053,700
To
tal Department of Labor Programs - 2,538,703
Total
WIOA Cluster - 2,538,703
Transit Services Program Cluster
Pass-through State of California Department of Transportation:

Enhanced Mobility of Seniors and Individuals with Disabilities 20.513 EHEGWCLJEVJ4 - 487,587 To
tal Department of Transportation Programs - 487,587
To
tal Transit Services Programs Cluster - 487,587
Highway Safety Program Cluster
Pass-through State of California Department of Transportation:

State and Community Highway Safety 20.600 EHEGWCLJEVJ4 - 33,985 Mi
nimum Penalties for Repeat Offenders for Driving While Intoxicated - OTS Selective Traffic Enforcement Program (STEP) 20.608 EHEGWCLJEVJ4 - 27,903 To
tal California Department of Transportation Programs - 61,888 Total
Highway Safety Programs Cluster - 61,888
Medicaid Program Cluster
Department of Health and Human Services Direct Programs:

Medical Assistance Program 93.778 N/A - 186,572
Passed through County of Los Angeles:

CHOUER Program 93.778 JK7YAK6HPFM6 - 32,569
To
tal Department of Health and Human Services Programs - 219,141 Total Medicaid Program Cluster - 219,141
Grantor/Program or Cluster Title
Federal Grantor/Pass-Through
The notes to the schedule of expenditures of federal awards are an integral part of this schedule. 6 PAGE 14

CITY OF PASADENA
Schedule of Expenditures of Federal Awards
For the Fiscal Year Ended June 30, 2023
Other Programs
Department of Agriculture:

Passed through State of California Department of Agriculture:

WIC Special Supplemental Nutrition Program for Women,
Infants and Children 10.557 W7NKNDHMRD27 - 1,173,986
To
tal Department of Agriculture Programs - 1,173,986
Department of Housing and Urban Development:

Direct Programs:

Community Development Block Grants Section 108 Loan Guarantees 14.248 N/A - 424,073 Emergency
Solutions Grant Program 14.231 N/A 156,663 168,930
COVID-19
Emergency Solutions Grant Program 14.231 N/A 951,607 982,368 Subtotal
AL 14.231 1,108,270 1,151,298
HOME Investment Partnership Program* 14.239 N/A - 1,288,078 Begi
nning loan balances 14.239 N/A - 12,947,380
- 14,235,458
Conti
nuum of Care Program* 14.267 N/A 1,902,329 3,245,566 Passed through City of Los Angeles:

Home Opportunities for Persons with AIDS 14.241 JK7YAK6HPFM6 - 106,304 Total
Department of Housing and Urban Development Programs 3,010,599 19,162,699 Department of Interior:

Direct Programs:

Water Conservation Field Services HDP 15.530 N/A - 32,302 Total
Department of Interior Programs - 32,302
Department of Justice:

Direct Programs:

Equitable Sharing Program - Justice 16.922 N/A - 1,014,330 To
tal Department of Justice Programs - 1,014,330
Department of Transportation:

Passed through the California Department of Transportation Highway Planning and Construction - Holly Street Bridge Seismic Retrofit * 20.205 EHEGWCLJEVJ4 - 45,675 Highway Planning and Construction - Union Street Cycle Track * 20.205 EHEGWCLJEVJ4 - 4,775,976 Highway Planning and Construction - Repair of Existing Damaged Guardrails * 20.205 EHEGWCLJEVJ4 - 280,153 Highway Planning and Construction - Cordova Street Enhancement * 20.205 EHEGWCLJEVJ4 - 727,137 Highway Planning and Construction - Safety Enhance Fair Oaks/Colorado; Mountain/Lakes 20.205 EHEGWCLJEVJ4 - 190,391 Highway Planning and Construction - Rapid Flashing Beacons * 20.205 EHEGWCLJEVJ4 - 9,393 Highway Planning and Construction - Interval/Audible Signal at Intersections * 20.205 EHEGWCLJEVJ4 - 63,840 Federal Transit Capital Investment Grants - Intelligent Transportation System * 20.205 EHEGWCLJEVJ4 - 153,380 Subtotal
AL 20.205 - 6,245,945
To
tal Department of Transportation Programs - 6,245,945
Department of Treasury:

Direct Programs:

COVID-19 - Coronavirus State and Local Fiscal Recovery Funds* 21.027 N/A - 32,860,146 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - PORT* 21.027 N/A - 185,321 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Health Equity* 21.027 N/A - 288,511 Subtotal AL 21.027 - 33,333,978
To
tal Department of Treasury Programs - 33,333,978
Department of Health and Human Services Programs:

Direct Programs:

Substance Abuse and Mental Health Services Projects
of Regional and National Significance 93.243 N/A - 112,419 Passed-through the County of Los Angeles, Department of Public Health ELC Strike (Health Assoc. Infection) 93.323 DN3NGS58SMT9 - 24,197 CDC PH Infrastructure 93.967 DN3NGS58SMT9 - 41,043
COVID-19 Epidemiology Laboratory Capacity 93.323 DN3NGS58SMT9 - 2,587,974 Public Health Emergency Preparedness 93.354 DN3NGS58SMT9 - 227,838 CDC Disparities 93.354 DN3NGS58SMT9 - 193,230
Subtotal AL 93.354 - 421,068
HIV Prevention Activities Health Department Based 93.940 DN3NGS58SMT9 - 175,695 Total passed-through the County of Los Angeles, Department of Public Health - 3,249,977 Passed-through the State of California
Temporary Assistance for Needy Families (TANF) 93.558 JK7YAK6HPFM6 - 34,762 Passed through State of California Department of Health Services:

Project Grants and Cooperative Agreements for Tuberculosis Control Programs 93.116 JE73CDQUAPA7 - 32,202 Childhood Lead Poisoning Prevention Projects, State and Local Childhood Lead Poisoning Prevention and Surveillance of Blood Lead Levels in Children 93.197 JE73CDQUAPA7 - 67,107 Immunization Cooperative Agreements 93.268 JE73CDQUAPA7 - 25,332 COVID-19 Immunization Cooperative Agreements 93.268 JE73CDQUAPA7 - 666,127 Subtotal AL 93.268 - 691,459
CDC Work Force Development 93.391 JE73CDQUAPA7 - 222,980 State Health Disparity Grant - CERI 93.391 JE73CDQUAPA7 69,630 Subtotal AL 93.268 - 292,610
The notes to the schedule of expenditures of federal awards are an integral part of this schedule. 7 PAGE 15

CITY OF PASADENA
Schedule of Expenditures of Federal Awards
For the Fiscal Year Ended June 30, 2023
Maternal and Child Health Services Block Grant to the States 93.994 JE73CDQUAPA7 - 111,604 Maternal and Child Health Services Block Grant to the States 93.994 JE73CDQUAPA7 - 274,711 Subtotal AL 93.268 - 386,315
DIS Workforce Development 93.977 JE73CDQUAPA7 - 46,496
Total passed-through the State of California Department of Health Services - 1,516,189 Total Department of Health and Human Services Programs - 4,913,347 Department of Homeland Security Direct Programs:

Direct Programs:

Hazard Mitigation Grant 97.039 N/A - 614,372
Hazard Mitigation Grant 97.039 N/A - 140,710
Total direct programs - 755,082
Passed through County of Los Angeles
Homeland Security Grant Program - FY 2020 Urban Areas Security Initiative 97.067 DN3NGS58SMT9 432,346 432,346 Total Department of Homeland Security Programs 432,346 1,187,428 Total Other Programs 3,442,945 67,064,015
Total Expenditures of Federal Awards 3,684,517$ 119,925,843 * Major Program
1 There was no federal awards expended in the form of noncash assistance and insurance in effect during the year.

The notes to the schedule of expenditures of federal awards are an integral part of this schedule. 8 PAGE 16

CITY OF PASADENA
Notes to the Schedule of Expenditures of Federal Awards For the Year Ended June 30, 2023

NOTE 1: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES APPLICABLE T O THE SCHEDULE OF

EXPENDITURES OF FEDERAL AWARDS

A. Scope of Presentation

The accompanying schedule presents only the expenditures incurr ed by the City of Pasadena, California, that are reimbursable under federal programs of federal financial assistance. For the purposes of this schedule, federal awards include both federal financial assistance received directly from a federal agency, as well as federal funds received indirectly by the City from a non-federal agency or other organ ization. Only the portion of program expenditures reimbursable with such federal funds is reported in the accompanying schedule. Program expenditures in excess of the maximum federal reimbursement authorized or the portion of the program expenditures that were funded with state, local or other non-federal funds are excluded from the accompanying schedule.

B. Basis of Accounting

The expenditures included in the accompanying schedule were reported on the modified accrual basis of accounting.

Under the modified accrual basis of accounting, expenditures ar e incurred when the City becomes obligated for payment as a result of the receipt of the related goods and services. Expenditures reported included any property or equipment acquisitions incurred under the federal program. The City has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance.

NOTE 2: SECTION 108 LOAN GUARANTEE PROGRAM

On October 29, 2015, the City entered into a Contract for Loan Guarantee Assistance under Section 108 with the U.S. Department of Housing and Urban Development in the amount of $6,000,000 for the Robinson Park Project. On March 28, 2019 the loan was refinanced at $5,100,000 to lock in permanent fixed interest rates. Principal is payable in annual installments of $300,000 commencing on August 1, 2019 and ending August 1, 2035. Interest rate is fixed between 2.54%-3.635%. Interest payment is paid semi-annually from the effective date of March 28, 2019. The balance outstanding as of June 30, 2023, is $3,900,000.

NOTE 3: LOAN PROGRAMS WITH CONTI NUING COMPLIANCE REQUIREMENTS

The program costs listed below ar e administered directly by the City of Pasadena, and balances and transactions relating to these programs are included in the City’s basic fin ancial statements. Loans made during the year are included in the federal expenditures presented in the Schedule of Expenditures of Federal Awards. The balance of loans outstanding at June 30, 2023, consists of:

Assistance
Listing
Number Program Name
Outstanding
Balance at
June 30, 2023

14.218
Community Development Block Grants/Entitlement
Grants 27,159,649 $

14.239 Home Investment Partnerships Program 13,962,511

14.871 Section 8 Housing Choice Vouchers 50,000
41,172,160$

9 PAGE 17

CITY OF PASADENA
Schedule of Findings and Questioned Costs
For the Fiscal Year Ended June 30, 2023

SECTION I - SUMMARY OF AUDITORS' RESULTS

Financial Statements

Type of auditors' report issued: Unmodified Opinion

Internal control over financial reporting:

x Material weaknesses ident ified? yes X no

x Significant deficiencies identified? X yes none reported

Noncompliance material to financial
statements noted? yes X no

Federal Awards

Internal control over major programs:

x Material weaknesses ident ified? yes X no

x Significant deficiencies ident ified? yes X none reported

Type of auditors' report issued on compliance for major programs: Unmodified Opinion

Any audit findings disclosed that are required to be
reported in accordance with Title 2 U.S. Code of
Federal Regulations (CFR) Part 200, Uniform
Administrative Requirements, Cost Principles, and
Audit Requirements for Federal Awards (Uniform
Guidance)? yes X no

Identification of major programs:

Assistance Listing Number(s) Name of Federal Program or Cluster

21.027 COVID-19 - Coronavirus St ate and Local Fiscal Recovery Funds

14.267 Continuum of Care Program

14.239 Home Investment Partnerships Program

20.205 Highway Planning and Construction

Dollar threshold used to distinguish
between type A and type B program $3,597,775

Auditee qualified as low-risk auditee? yes X no 10 PAGE 18

CITY OF PASADENA
Schedule of Findings and Questioned Costs
For the Fiscal Year Ended June 30, 2023

SECTION II - FINANCIAL STATEMENT FINDINGS

Reference Number
2023-001 – Timeliness of Bank Reconciliation Preparation

Evaluation of Finding
Significant Deficiency

Condition
A cash reconciliation that reconciles from the bank balance to the general ledger balance should be prepared to determine that all cash transactions have been recorded properl y and to discover bank errors. Bank statements in some instances were accumulated for several months before they were reconciled to the appropriate general ledger controls. Not reconciling the accounts on a monthly and timely basis means that errors or other problems might not be recognized or resolved on a timely basis. We recommend that all bank accounts be reconciled each month prior to preparation of monthly financial statements.

Criteria
In order to make the financial reports generated by the accounting system as meaningful as possible, the City should reconcile to the general ledger accounts for cash on a monthly basis as timely as possible.

Cause of Condition
Due to the significant volume and detail of individual cash transactions, in addition to staffing and personnel issues experienced by the City, there were instances where the City did not possess the capacity to perform the monthly bank reconciliations on a timely basis.

Effect or Potential Effect of Condition
Not reconciling the accounts on a monthly and timely basis mean s that errors or other problems might not be recognized or resolved on a timely basis.

Recommendation
The Finance Department should look at ensuring that sufficient experienced personnel are available to help facilitate the monthly bank reconciliation processes.

Management Response
We agree with the finding. The City is currently implementing e fficiency improvements to the monthly bank reconciliation process in hopes to alleviate this occurrence during Fiscal Year 2024.

11 PAGE 19

CITY OF PASADENA
Schedule of Findings and Questioned Costs
For the Fiscal Year Ended June 30, 2023

SECTION II - FINANCIAL STATEMENT FINDINGS (CONTINUED)
Reference Number
2023-002 – Year-End Close and Financial Reporting

Evaluation of Finding
Significant Deficiency
Condition
During the audit, we found the following conditions that resulted in significant adjustments to the financial statements.

Accuracy in External Financial Reporting
The year-end closing process did not ensure that account balances were reconciled and accurate in advance of the audit requiring a significant number of correcting journal entr ies provided by the City to correct the final financial statements. It appears these errors were primarily caused by the trial balance being prepared from data that was not always complete, contained errors, and appropriate year end reconciliations had not been performed.

Criteria
Management is responsible for the preparation and fair presenta tion, as well as the accuracy of its financial statements, including disclosures in accordance with accounting principles generally accepted in the United States of America. This includes the design, implementation, and maintenance of internal controls relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to error or fraud.

Cause of Condition
Due to the significant volume and detail of general ledger transactions of the City, in addition to newly issued complex Government Accounting Standards Board (GASB) Pronouncements, so me processes were not fully executed and reflected in the City trial balance prior to being furnished to the auditors.

Effect or Potential Effect of Condition
Due to the items noted above, there is a potential for significant misstatements to be present in the initial trial balance that is provided to the auditors.

Recommendation
The City should put in place formalized year-end close procedures to ensure the close is complete and reduce the amount of journal entries needed and errors found after the clo sing process has been completed. We suggest management also establish effective review policies and procedu res, including but not lim ited to; apply analytical procedures on the trial balance numbers and perform reconciliations of all significant accounts.

Management Response
Management agrees with the finding. Due to the implementation o f the newly issued and complex GASB pronouncement, a number of journal entries and corrections were made by City staff. The City will implement and follow formal year-end closing processes and procedures to ensu re sufficient review and corrections to the trial balance are made, prior to year-end close.

SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS

No matters were reported.
12 PAGE 20

SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS FOR THE FISCAL YEAR ENDED JUNE 30, 2022

Finding: 2022-001

Condition:

Appropriate corrective actions were taken; this finding is considered resolved and is not repeated in the fiscal year ended June 30, 2023.

Finding: 2022-002

Condition:

Appropriate corrective actions were taken; this finding is considered resolved and is not repeated in the fiscal year ended June 30, 2023.

13 PAGE 21

CITY OF PASADENA, CALIFORNIA

SAFE, CLEAN WATER PROGRAM
FOR THE THREE YEAR PERIOD ENDING JUNE 30, 2023 FINANCIAL STATEMENTS Attachment B
PAGE 22

CITY OF PASADENA, CALIFORNIA

SAFE, CLEAN WATER PROGRAM

Financial Statements

For the Three Year Period Ending June 30, 2023

PAGE 23

CITY OF PASADENA, CALIFORNIA

SAFE, CLEAN WATER PROGRAM
Financial Statements
For the Three Year Period Ending June 30, 2023
Table of Contents
Page
Numb
er

FINANCIAL SECTION
INDEPENDENT AUDITORS’ REPORT .............................................................................................................. 1

BASIC FINANCIAL STATEMENTS
Balance Sheet .................................................................................................................................................. 4 Statement of Revenues, Expenditures, and Changes in Fund Balance .......................................................... 5 Notes to Basic Financial Statements ............................................................................................................... 6

REQUIRED SUPPLEMENTARY INFORMATION
Budgetary Comparison Schedule for the Year Ended June 30, 2023 ............................................................. 8 Budgetary Comparison Schedule for the Year Ended June 30, 2022 ............................................................. 9 Budgetary Comparison Schedule for the Year Ended June 30, 2021 ........................................................... 10

OTHER REPORTS
Independent Auditors’ Report on Compliance ................................................................................................... 11 Independent Auditors’ Report on Internal Control Over Financial Reporting and on Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards ..................................................................................... 13 PAGE 24

1611 E. Fourth Street, Suite 200
Santa Ana, CA 92701
(714) 569-1000
203 N. Brea Blvd, Suite 203
Brea, CA 92821
(714) 672-0022
21 Waterway Avenue, Suite 30089
The Woodlands, TX 77380
(936) 828-4587
2151 River Plaza Dr., Suite 150
Sacramento, CA 95833
(916) 503-9691
24422 Avenida de la Carlota, Suite 275
Laguna Hills, CA 92653
(949) 829-8299
www.lslcpas.com
INDEPENDENT AUDITOR’S REPORT
To the Honorable Mayor and Members of the City Council
City of Pasadena, California
Report on the Audit of the Financial Statements
Opinions
We have audited the accompanyi ng financial statements of the Me asure W Fund, a special revenue fund, which reports the Safe, Clean Water Program (“SCW Program”) of the City of Pasadena, California (the “City”), as of and for the three-year period ended June 30, 2023, and the related notes to the financial statements, which collectively comprise the SCW Program’s basic financial statements as listed in the table of contents.

In our opinion, the financial statements referred to above present fairly, in all material respects, the financial position of the SCW Program of the City, as of June 30, 2023, and the changes in financial position for the years then ended
in accordance with accounting principles generally accepted in the United States of America.

Basis for Opinions
We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards , issued by the Comptroller General of the United States. Our responsibilities under those standards are further described in the Auditor’s Responsibilities for the Audit of the Financial State ments section of our report. We are required to be independent of the City and to meet our other ethical responsib ilities, in accordance with the relevant ethical requirements relating to our audit. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our audit opinions.

Emphasis of Matter
As discussed in Note 1, the financial statements of the SCW Program are intended to present the financial position and the changes in financial position of only that portion of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of the City that is attributable to the transactions of the SCW Program. They do not purport to, and do not, present fa irly the financial position of the City, as of June 30, 2023, the changes in its financial position, or, where applicable, its cash flows for the year then ended in accordance with accounting prin ciples generally accepted in the United States of America. Our opinion is not modified with respect to this matter.

Responsibilities of Management for the Financial Statements Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation andfair presentation of financial statements that are free from material misstatement, whether due to fraud or error. In p reparing the financial statements, management is required to evaluate whether there are conditions or events, considered in the aggregate, that raise substantial doubt about the City’s ability to continue as a going concern for twelve months beyond the financial statement date, including any currently known information that may raise substantial doubt shortly thereafter.

PAGE 25
To the Hono
rable Mayor and Members of the City Council
City of Pasadena, California
Auditor’s Responsibilities for the Audit of the Financial Statements Our objectives are to obtain reasonable assurance about whether the financial statements as a whole are free from material misstatement, whether due to fraud or error, and to is sue an auditor’s report that includes our opinions.

Reasonable assurance is a high level of assurance but is not absolute assurance and therefore is not a guarantee that an audit conducted in accordance with generally accepted a uditing standards and Government Auditing Standards will always detect a material m isstatement when it exists. The risk of not detecting a material misstatement resulting from fraud is higher than for one resulting from error, as fraud may involve collusion, forgery, intentional omissions, misrepresentations, or the override of internal control. Misstatements are considered material if there is a substantial likelihood that, individually or in the aggregate, they would influence the judgment made by a reasonable user based on the financial statements.

In performing an audit in accordance with generally accepted au diting standards and Government Auditing Standards, we:
 Exercise professional judgment and maintain professional skepticism throughout the audit.  Identify and assess the risks of material misstatement of the financial statements, whether due to fraud or error, and design and perform audit procedures responsive to th ose risks. Such procedures include examining, on a test basis, evidence regarding the amounts and disclosures in the financial statements.  Obtain an understanding of inter nal control relevant to the audit in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the City’s internal control. Accordingly, no such opinion is expressed.  Evaluate the appropriateness of accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluate the overall presentation of the financial statements.  Conclude whether, in our judgment, there are conditions or events, considered in the aggregate, that raise substantial doubt about the City’s ability to continue as a going concern for a reasonable period of time.

We are required to communicate with those charged with governance regarding, among other matters, the planned scope and timing of the audit, significant audit findings, and certain internal control-related matters that we identified during the audit.

Required Supplementary Information
Accounting
principles generally accepted in the United States o f America require that the budgetary comparison information on as listed in the table of contents be presented to supplement the basic financial statements. Such information is the responsibility of management and, although not a part of the basic financial statements, is required by the Governmental Accounting Standards Board who considers it to be an essential part of financial reporting for placing the basic financial statements in an appropriate operat ional, economic, or historical context. We have applied certain limited procedures to the required supplementary information in accordance with auditing standards generally accepted in the United States of America, which consisted of inquiries of management about the methods of preparing the information and comparing the information for consistency with management’s responses to our inquiries, the basic financial statements, and other knowledge we obtained during our audit of the basic financial statements. We do not express an opinion or provide any assuran ce on the information because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance.

Management has omitted the management’s discussion and analysis that accounting principles generally accepted in the United States of America require to be presented to supplement the basic financial statements. Such missing information, although not a part of the basic financial stateme nts, is required by the Governmental Accounting Standards Board who considers it to be an essential part of fin ancial reporting for placing the basic financial statements in an appropriate operational, economic, or historic al context. Our opinion on the basic financial statements is not affected by this missing information. 2 PAGE 26
To the Hono
rable Mayor and Members of the City Council
City of Pasadena, California
Summarized Comparative Information
The financial statements of the City for the year ended June 30, 2022 and June 30, 2021, were audited by another auditor, who expressed an unmodified opinion on those financial statements in their reports dated March 17, 2023 and January 19, 2022, respectively. In our opinion, the summarized comparative information presented herein as of and for the year ended June 30, 2022 and June 30, 2021, is consistent, in all material respects, with the audited financial statements from which it has been derived.

Other Reporting Required by Government Auditing Standards In accordance with Government Auditing Standards, we have also issued our report dated December 28, 2023, on our consideration of the City’s internal control over financial reporting and on our tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements and other matters, including compliance with Los Angeles County Flood Control District Code Chapter Sections 16.05 and 18.05 through 18.07. The purpose of that report is solely to describe the scope of our testing of intern al control over financial reporting and compliance and the results of that testing, and not to provide an opinion on t he effectiveness of the City’s internal control over financial reporting or on compliance. That report is an integra l part of an audit performed in accordance with Government Auditing Standards in considering the City’s internal control over financial reporting and compliance.

Brea, California
December 28, 2023
3 PAGE 27

CITY OF PASADENA, CALIFORNIA

SAFE, CLEAN WATER PROGRAM
Balance Sheet
As of June 30,
2023 2022 2021
ASSETS
Cash and investments 2,105,660$ 537,442$ -$
Accounts Receivable - - 1,536,502
Total assets 2,105,660$ 537,442$ 1,536,502$

LIABILITIES AND FUND BALANCE

LIABILITIES
Accounts payable 28,223$ -$ -$
Total liabilities 28,223 - -

FUND BALANCE
Restricted:

Public works 2,126,469 537,442 1,536,502 Total fund balance 2,126,469 537,442 1,536,502 Total liabilities and fund balance 2,154,692$ 537,442$ 1,536,502$ See accompanying notes to financial statements.
4 PAGE 28

CITY OF PASADENA, CALIFORNIA

SAFE, CLEAN WATER PROGRAM
Statement of Revenues, Expenditures, and Changes in Fund Balance For the Year Ended June 30,
2023 2022 2021

REVENUES
Intergovernmental 3,099,753$ - $ 1,536,502$
Total revenues 3,099,753 - 1,536,502

EXPENDITURES
Current:

Public works 584,636 999,060 -
Total expenditures 584,636 999,060 - Excess (deficiency) of revenues over (under) expenditures 2,515,117 (999,060) 1,536,502

OTHER FINANCING SOURCES (USES)
Transfers out (926,090) - -
Total other financing sources (uses) (926,090) - - Net change in fund balance 1,589,027 (999,060) 1,536,502 Fund balance, beginning 537,442 1,536,502 - Fund balance - ending 2,126,469$ 537,442$ 1,536,502$ See accompanying notes to financial statements.
5 PAGE 29

CITY OF PASADENA, CALIFORNIA

SAFE, CLEAN WATER PROGRAM
Notes to the Basic Financial Statements
For the Three Year Period Ending June 30, 2023
NOTE 1
: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
The accounting policies of the Measure W special revenue fund (the “Fund”), which reports the Safe, Clean Water Program (“SCW Program”) of the City of Pasadena (the “City”) conform to accounting principles generally accepted in the United States of America as applicable to governments. T he Governmental Accounting Standards Board (GASB) is the standard-setting body for governmental accounting and financial reporting principles. These financial statements present only the financial position of the Fund and do not present nor purport to present the financial position of the City as a whole. The following is a summary of the significant policies.

A. Reporting Entity
The Fun
d was set up to administer resources received from the L os Angeles County Flood Control District (the District) pursuant to the SCW Program. The purpose of the SCW program is to fund projects and programs to increase stormwater and urban runoff capture and reduce stormwater and urban runoff pollution in the District. Forty percent (40%) of the annual SCW Program tax revenues is allocated to Municipalities within the District, in the same proportion as the amount of revenues collected within each Muni cipality, and is expended by these cities within their respective jurisdictions for the implementation, operation and maintenance, and administration of projects and programs, in accordance with the criteria and procedures establ ished in Chapters 16 and 18 of the Los Angeles County Flood Control District Code.

B. Measurement Focus, Basis of Presentation, And Financial Statement Presentation The Fund
Financial Statements include a Balance Sheet and a Statement of Revenues, Expenditures, and Changes in Fund Balance.

The Fund is accounted for on a spending or current financial resources measurement focus and the modified accrual basis of accounting. Accordingly, only current assets and current liabilities are included on the Balance Sheet. The Statement of Revenues, Expenditures, and Cha nges in Fund Balances present increases (revenues and other financing sources) and decreases (expenditures and other financing uses) in net current assets.

Under the modified accrual basis of accounting, revenues are re cognized in the accounting period in which they become both measurable and available to finance expenditures of the current period. Accordingly, revenues are recorded when received in cash, except that revenues subject to accrual are recognized when due. The primary sources susceptible to accrual are property tax, sales tax, tra nsient occupancy tax, investment income, and grant revenues. Generally, revenues are subject to accrual if anticip ated to be received within 180 days after year-end.

The exception to this general rule is that property taxes are s ubject to accrual if received within 60 days after year-end.

Expenditures are generally recognized under the modified accrual basis of accounting when the related fund liability is incurred.

C. Stewardship, Compliance, and Accountability
The legal
level of budgetary control is at the fund level. For the year ended June 30, 2023, there were no violations of expenditures over appropriations.

D. Investments and Interest Income on Investments
Cash
and investments of the City are managed on a pooled basis, and the Fund’s share in this pool is displayed in the accompanying financial statements as cash and investments. Investment income from the pool is allocated quarterly to the Fund based on its average cash balance in rela tion to the pool’s total balance. The primary components of investment earnings are interest earnings and distributions, unrealized gains or losses from changes in fair value, and realized gains or losses from the liquidation or sale of investments. All pooled investments are controlled by an investment policy that is adopted by the City Council and further controlled by State legislation. 6 PAGE 30

CITY OF PASADENA, CALIFORNIA

SAFE, CLEAN WATER PROGRAM
Notes to the Basic Financial Statements
For the Three Year Period Ending June 30, 2023
NOTE
1: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (CONTINUED) E. Fund Balance
In the gover
nmental fund financial statements, fund balance is made up of the following categories:
 Restricted fund balance includes amounts that can be spent only for speci fic purposes imposed by creditors, grantors, contributors, or laws or regulations of other governments or through enabling legislation.

When expenditures are incurred for purposes for which both rest ricted and unrestricted (committed, assigned, or unassigned) fund balances are available, the City’s policy is t o consider restricted fund balance to have been depleted before using any components of unrestricted fund balan ce. Further, when expenditures are incurred for purposes for which committed, assigned, or unassigned fund balances are available, the City’s policy is to first deplete committed fund balance, then assigned fund balance, and finally unassigned fund balance.

NOTE 2: CASH AND INVESTMENTS
The Fund participates in the City’s pooled cash and investments (the pool). Information relating to the City’s cash and investments can be found in the City’s financial statements.

NOTE 3: SUBSEQUENT EVENTS
The City evaluated subsequent events for recognition and disclo sure through March 31, 2024, the date on which these financial statements were available to be issued. Management concluded that no material subsequent events have occurred since June 30, 2023, that required recognition or disclosure in these financial statements. 7 PAGE 31

CITY OF PASADENA, CALIFORNIA

SAFE, CLEAN WATER PROGRAM
Budgetary Comparison Schedule
For the Year Ended June 30, 2023
Variance with
Original Final Actual Final Budget

REVENUES
Intergovernmental -$ -$ 3,099,753$ 3,099,753$
Total revenues - - 3,099,753 3,099,753

EXPENDITURES
Current:

Public works 1,650,000 630,000 584,636 45,364 Total expenditures 1,650,000 630,000 584,636 45,364 Excess (deficiency) of revenues over (under) expenditures (1,650,000)$ (630,000)$ 2,515,117 3,054,389$

OTHER FINANCING SOURCES (USES)
Transfers out - (700,000) (926,090) (226,090)
Total other financing sources (uses) - (700,000) (926,090) (226,090) Net change in fund balance (1,650,000)$ (1,330,000)$ 1,589,027 2,828,299$ Fund balance - beginning 537,442
Fund balance - ending 2,126,469$
Budgeted Amounts
8 PAGE 32

CITY OF PASADENA, CALIFORNIA

SAFE, CLEAN WATER PROGRAM
Budgetary Comparison Schedule
For the Year Ended June 30, 2022
Variance with
Original Final Actual Final Budget

REVENUES
Intergovernmental -$ -$ -$ -$
Total revenues - - - -

EXPENDITURES
Current:

Public works 3,120,000 355,000 999,060 (644,060) Total expenditures 3,120,000 355,000 999,060 (644,060) Excess (deficiency) of revenues over (under) expenditures (3,120,000)$ (355,000)$ (999,060) (644,060)$ Fund balance - beginning 1,536,502
Fund balance - ending 537,442$
Budgeted Amounts
9 PAGE 33

CITY OF PASADENA, CALIFORNIA

SAFE, CLEAN WATER PROGRAM
Budgetary Comparison Schedule
For the Year Ended June 30, 2021
Variance with
Original Final Actual Final Budget

REVENUES
Intergovernmental -$ -$ 1,536,502$ 1,536,502$
Total revenues - - 1,536,502 1,536,502

EXPENDITURES
Current:

Public works 3,120,000 3,120,000 - 3,120,000
Total expenditures 3,120,000 3,120,000 - 3,120,000 Excess (deficiency) of revenues over (under) expenditures (3,120,000)$ (3,120,000)$ 1,536,502 4,656,502$ Fund balance - beginning -
Fund balance - ending 1,536,502$
Budgeted Amounts
10 PAGE 34

To the Honorable Mayor and Members of the City Council
City of Pasadena, California
Opinion
We have audited City of Pasadena, California (the “City”)’s compliance with the compliance requirements identified as subject to audit in Los Angeles County Flood Control Distric t Code Chapter Sections 16.05 and 18.05 through

18.07 that could have a direct and material effect on the City’s Safe, Clean Water Program (“SCW Program”) for the three-year period ended June 30, 2023.

In our opinion, the City complied, in all material respects, with the compliance requirements referred to above that could have a direct and material effect on the SCW Program for the year ended June 30, 2023.

Basis for Opinion
We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financ ial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Our responsibilities under those standards are further descri
bed in the Auditor’s Responsibilities for the Audit of Compliance section of our report.

We are required to be independent of the City and to meet our o ther ethical responsibilities, in accordance with relevant ethical requirements relating to our audit. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our opinion on compliance for the SCW Program. Our audit does not provide a legal determination of the City’s compliance with the compliance requirements referred to above.

Responsibilities of Management for Compliance
Management is responsible for compliance with the requirements referred to above and for the design, implementation, and maintenance of effective internal control o ver compliance with the requirements of laws, statutes, regulations, rules, and provisions of contracts or grant agreements applicable to the City’s SCW Program.

Auditor’s Responsibilities for the Audit of Compliance
Our objectives are to obtain reasonable assurance about whether material noncompliance with the compliance requirements referred to above occurred, whether due to fraud o r error, and express an opinion on the City’s compliance based on our audit. Reasonable assurance is a high level of assurance but is not absolute assurance and therefore is not a guarantee that an audit conducted in accordance with generally accepted auditing standards and Government Auditing Standards will always detect material nonco mpliance when it exists. The risk of not detecting material noncompliance resulting from fraud is higher than for that resulting from error, as fraud may involve collusion, forgery, intentional omissions, misrepresent ations, or the override of internal control.

Noncompliance with the compliance requirements referred to above is considered material if there is a substantial likelihood that, individually or in the aggregate, it would influence the judgment made by a reasonable user of the report on compliance about City’s compliance with the requirements of the SCW Program as a whole.

PAGE 35
To the Hono
rable Mayor and Members of the City Council
City of Pasadena, California
In performing an audit in accordance with generally accepted au diting standards and Government Auditing Standards, we:
 Exercise professional judgment and maintain professional skepticism throughout the audit.  Identify and assess the risks of material noncompliance, wheth er due to fraud or error, and design and perform audit procedures responsive to those risks. Such proced ures include examining, on a test basis, evidence regarding the City’s compliance with the compliance re quirements referred to above and performing such other procedures as we considered necessary in the circumstances.  Obtain an understanding of the City’s internal control over compliance relevant to the audit in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of City’s internal control over compliance. Accordingly, no such opinion is expressed.

We are required to communicate with those charged with governance regarding, among other matters, the planned scope and timing of the audit and any significant deficiencies and material weaknesses in internal control over compliance that we identified during the audit.

Other Matters
The results of our auditing procedures disclosed instances of noncompliance which are required to be reported and which are described in the accompanying schedule of findings and questioned costs as items 2023-001, 2023-002 and 2023-003. Our opinion on the SCW Program is not modified with respect to these matters.

Government Auditing Standards requires the auditor to perform limited procedures on the City ’s response to the noncompliance findings identified in our compliance audit described in the accompanying schedule of findings and questioned costs. The City’s res ponse was not subjected to the other auditing procedures applied in the audit of compliance and, accordingly, we express no opinion on the response.

Brea, California
April 1, 2024
12 PAGE 36

RNAL CONTROL OVER FINANCIAL REPORTING AND ON

COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN

ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS
To the Honorable Mayo
r and Members of the City Council
City of Pasadena, Californi
a
We have audited, in accordance with the auditing standards gene rally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards issued by the Comptroller General of the United States, the financial stateme nts of the Safe, Clean Water Program (“SCW Program”) of the City of Pasadena, California (the “City”), as of and for the year ended June 30, 2023, and the related notes to the financial statements, which collective ly comprise the SCW Program’s basic financial statements, and have issued our report thereon dated April 1, 2024.

Report on Internal C
ontrol over Financial Reporting
In planning and performing our audit of the financial statement s, we considered the City’s internal control over SCW Program’s financial reporting (internal control) as a basis for designing audit procedures that are appropriate in the circumstances for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the City’s int ernal control. Accordingly, we do not express an opinion on the effectiveness of the City’s internal control.

A deficiency in internal control exists when the design or operation of a control does not allo w management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, misstatements, on a timely basis. A material weakness is a deficiency, or a combination of deficiencies, in internal control, such that there is a reasonable possibility that a material misstatement of the entity’s financial statements will not be prevented, or detected and corrected, on a timely b asis. A significant deficiency is a deficiency, or a combination of deficiencies, in internal control that is less s evere than a material weakness, yet important enough to merit attention by those charged with governance.

Our consideration of internal control was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control that might be material weaknesses or significant deficiencies and therefore, material weaknesses or significant deficiencies may exist that were not identified. Given these limitations, during our audit we did not identify any deficiencies in internal control that we consider to be material weaknesses or significant deficiencies.

Report on Compliance and Other Matters
As part of obtaining reasonable assurance about whether the SCW Program’s financial statements are free from material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a direct and material effect on the financial statements, including Los Angeles County Flood Control District Code Chapter Sections 16.05 and 18.05 through

18.07. The results of our tests d isclosed no instances of noncompliance or other matters that are required to be reported under Government Auditing Standards. The results of our tests disclosed instances of noncompliance or other matters that are required to be reported under Government Auditing Standards and which are described in the accompanying schedule of findings and questioned costs as items 2023-001, 2023-002, and 2023-003.

PAGE 37
To the Honorable Ma
yor and Members of the City Council
City of Pasadena, California
City of Pasadena’s Response to Findings
Government Auditing Standards requires the auditor to perform limited procedures on the City ’s response to the findings identified in our audit and described in the accompanying schedule of findings and questioned costs. The City’s response was not subjected to the other auditing procedu res applied in the audit of the financial statements and, accordingly, we express no opinion on the response.

Purpose of This Report
The purpose of this report is solely to describe the scope of our testing of internal control and compliance and the results of that testing, and not to provide an opinion on the effectiveness of the entity’s internal control. This report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the entity’s internal control and compliance. Accordingly, this communication is not suitable for any other purpose.

Brea, California
April 1, 2024
14 PAGE 38
To the Hono
rable Mayor and Members of the City Council
City of Pasadena, California

SCHEDULE OF FINDINGS AND QUESTIONED COSTS
Reference Number
2023-001
Evaluation of Finding
Non-Compliance - Reporting
Condition
The City submitted the annual progress/expenditure reports beyond the six-month requirement.

Criteria
Program regulations under B-26 require the City to submit annua l progress/expenditure reports within six months following the end of the fiscal year to the District.

Cause of Condition
The City submitted the FY21-22 and FY22-23 annual reports beyond the six-month requirement. The FY21-22 report was submitted August 7, 2023, and the FY22-23 report was submitted March 6, 2024.

Effect or Potential Effect of Condition
Measure W – Safe Clean Water Program is new funding for the Cit y. The City has been implementing new processes and procedures to ensure all requirements are met, ho wever the reconciliation and tracking of activity as well as requirements are new. Due to insufficient staff, information and invoices for services being provided in a timely manner, the City submitted the reports late.

Recommendation
We recommend the City implement procedures at year-end to ensur e timely submissions for all reporting requirements.

Management Response
Management agrees with the recommendation. Due to this being ne w funding and new procedures the City does not expect this to be an issue in future years. The City will be able to reconcile information through the tracking under fund 243 and through a new administrator position. This will result in timely submission of the annual reports. 15 PAGE 39

To the Honorable Mayor and Members of the City Council
City of Pasadena, California

SCHEDULE OF FINDINGS AND QUESTIONED COSTS (CONTINUED)

Reference Number
2023-002

Evaluation of Finding
Non-Compliance – Interest Allocation

Condition
The City did not have internal controls to properly set up the fund into the pooled cash for interest allocation and did not allocate interest from the City’s pooled cash and investments accounts to the Program.

Criteria
Program regulations under Section 16.13 require the City to hol d the Program funds under a separate interest-bearing account not be combined with other funds. Interest earned from each account shall be used by the account holder only for eligible expenditures consistent with the requirements of the Program.

Cause of Condition
The City calculated and recorded their interest allocation jour nal entries independently of the compliance requirements and through the financial closing process. Program regulations under Section 16.13 were not communicated to the City’s finance personnel prior to the calculations being recorded.

Effect or Potential Effect of Condition
Measure W – Safe Clean Water Program is new funding for the Cit y. The City has been implementing new processes and procedures to ensure all requirements are met, ho wever the reconciliation and tracking of activity as well as requirements are new. Due to insufficient information, the City finance department unknowingly omitted the interest allocation to the SCW Program Fund within the City’s general ledger.

Recommendation
We recommend the City implement procedures to ensure interest is properly allocated to all SCW Program Funds within the City’s general ledger.

Management Response
Management agrees with the recommendation. Due to this being ne w funding and new procedures the City does not expect this to be an issue in future years. The Public Work s department has communicated Program requirements to the City’s finance department to alleviate this issue in subsequent fiscal years. 16 PAGE 40

To the Honorable Mayor and Members of the City Council
City of Pasadena, California

SCHEDULE OF FINDINGS AND QUESTIONED COSTS (CONTINUED)

Reference Number
2023-003

Evaluation of Finding
Non-Compliance – Program Implementation

Condition
The City did not attain the required threshold of at least 70% of SCW Program expenditures to be expended on eligible Projects and Programs implemented on or after November 6, 2018 during FY21-22 and FY22-23. The City obtained 65% on both years and calculation was monitored and will be adjusted moving forward.

Criteria
Program regulations under Section 18.06 require that at least 70% of Program funds be spent annually on eligible expenses related to Projects or Programs implemented on or after November 6, 2018.

Cause of Condition
Due to new Program costs and activities, costs were not fully implemented as anticipated during FY21-22 and FY22-23.

Effect or Potential Effect of Condition
Measure W – Safe Clean Water Program is new funding for the Cit y. The City has been implementing new processes and procedures to ensure all requirements are met, ho wever the reconciliation and tracking of activity as well as requirements are new. Due to new implementation of new projects and programs, costs were not incurred as anticipated resulting in the failure to attain the aforementioned 70% expenditure threshold.

Recommendation
We recommend the City implement p rocedures to track Program exp enditures throughout the year and monitor against projected budgets to ensure funds are in line with developments and within required ratios of the Program.

Management Response
Management agrees with the recommendation. Due to this being ne w funding and new procedures the City does not expect this to be an issue in future years. The City had de lays in development and now has a new Stormwater Program Administrator position to monitor activity and ensure the ratios are being maintained in subsequent fiscal years.

17 PAGE 41
CORRE

CTIVE ACTION PLAN
Reference Number: 2023-001
Name of Contact Person: Dawn Petschauer (Stormwater Program Administrator) Corrective Action: The City has implemented new monitoring and tracking procedures as well as established a new Stormwater Program Administrator position to ensure all compliance requirements are met with timely submissions of annual reports.

Proposed Completion Date: June 30, 2024
Reference Number: 2023-002
Name of Contact Person: Dawn Petschauer (Stormwater Program Administrator) Corrective Action: The City has implemented new monitoring and tracking procedures as well as established a new Stormwater Program Administrator position to ensure all compliance requirements are met with proper interest allocation to all SCW Program activity within the City’s general ledger.

Proposed Completion Date: June 30, 2024
Reference Number: 2023-003
Name of Contact Person: Dawn Petschauer (Stormwater Program Administrator) Corrective Action: The City has implemented new monitoring and tracking procedures as well as established a new Stormwater Program Administrator position to ensure all com pliance requirements are met with proper adherence to the required threshold of annual expenditures requ ired to be expended on eligible Projects and Programs implemented on or after November 6, 2018.

Proposed Completion Date: June 30, 2024
18 PAGE 42

NEW BUSINESS
ITEM 2

2. DIRECT THE CITY ATTORNEY TO PREPARE AN ORDINANCE
TO AMEND PASADENA MUNICIPAL CODE CHAPTER 4.100 TO

CONFORM TO RECENT CHARTER AMENDMENT ADDRESSING THE

ANNUAL POWER FUND TRANSFER TO THE GENERAL FUND
PAGE 43
Direction to Prepare an Ordinance Amending PMC Chapter 4.100 May 6, 2024

Page 1 of 2 ends

May 6,
2024
TO: Honor
able Mayor and City Council
THROUGH: Finance Committee
FRO
M: Department of Finance
SUBJECT: DIRECT THE CITY ATTORNEY TO PREPARE AN ORDINANCE TO AMEND PASADENA MUNICIPAL CODE CHAPTER 4.100 TO

CONFORM TO RECENT CHARTER AMENDMENT

ADDRESSING THE ANNUAL POWER FUND TRANSFER TO

THE GENERAL FUND
RECOM
MENDATION:

1. Find t
hat the action proposed herein is exempt from the California Environmental Quality Act (CEQA) pursuant to State CEQA Guidelines per Section 15061(b)(3)(Common Sense Exemption); and

2. Direc
t the City Attorney to prepare and return with an ordinance within 60-days amending Chapter 4.100 of the Pasadena Municipal Code removing references to Net Income to conform to recent amendment to the Charter pertaining to the annual Power Fund transfer to the General Fund.

BACKGROUND:

Pasad
ena’s Charter, Article XIV, establishes regulations regarding water and power utility operations. In the March 2024 election, Pasadena voters approved a Charter amendment which, among other things, allowed the annual Power Fund transfer to the General Fund to conform to Generally Accepted Accounting Practices (GAAP). The Charter amendment removed the requirement to calculate what is known as “net income,” which is no longer used in GAAP calculations. Chapter 4.100 of the Pasadena Municipal Code establishes the calculation and methodology for the determination of the transfer on an annual basis. This chapter must be amended to conform with the Charter by removing the net income calculation in determining the amount available for transfer.

PAGE 44
PAGE 45

NEW BUSINESS
ITEM 3 (A)

3. BUDGET WORKSHOP FY 2025 RECOMMENDED OPERATING BUDGET OPERATING BUDGET PRESENTATIONS:

A. HUMAN RESOURCES
PAGE 46
Human Resources Department
FY 2025 Recommended
Operati
ng Budget
Finance Committee Item 3A
May 6, 2024
PAGE 47
Human Resources Department
FY 2024 Accomplishments
• Employment Services
> Processed over 20,000 job applications
> Filled/hired over 400 positi ons
• Supported local recruiting efforts
> KPI – local hiring into entry-level positions FY24 to date = 52% > Paramedic Intern (2nd Year)
> PUSD Job Shadow Day
> Local job fairs
• Rent Stabilization Department Support
> Onboarded Rental Housing Board Members
> Provided support for expedited staffing
 Actively recruiting for multiple positions including Director 2 PAGE 48
Human Resources Department
FY 2024 Accomplishments
3 PAGE 49
Human Resources Department
FY 2024 Accomplishments
• Risk Management Re-org
> Partnered with City Manager, City Attorney, Finance and IT to plan,
communicate and implement the Enterprise Risk section
• Labor Relations and Classification & Compensation
> Negotiated multi-year labor agreements with the following bargaining groups: PMA and PPSA (New Bargaining Unit)
> Completed over 70 salary surveys, resulting in market/equity adju
stments for over 50 classifications
> Established several new classifications and implemented over 20 re
cl
assifications
4 PAGE 50
Human Resources Department
FY 2025 Priorities/Work Plan
• Human Resources Department Strategic Planning
> Review and update KPI’s
> Review time-to-hir e life cycle
> Evaluate resource/staffing allocation
• City-wide Recruitment and Retention
> Continue classification and compensation studies
> Salary Resolutions for Non Represented Employees
> Social Media presence and branding as employer of choice 5 PAGE 51
Human Resources Department
FY 2025 Priorities/Work Plan
• Equity, Inclusion & Belonging
> Upgrade HR Analyst to Senior HR Analyst to coordinate and enhan
ce DEI efforts
> Launch transparent data dashboard for employee
demograp
hics
> Launch Employee Engagement Survey & Program
• Employee Wellness Initiative
> Promote employee well-being through access to organized health and wellness programs that improve employee
physical, mental, and financial health
6 PAGE 52
Human Resources Department
Appropriations by Category
7 *FY25 Recommended Budget for Capital Outlay is a one-time use of AQMD grant funding to purchase four EVs – three for the Fire Department and one for the Public Works Department.

Category
FY 2022
Actuals
FY 2023
Actuals
FY 2024
Adopted
FY 2025
Recommended % Change
Personnel 4,333,651 5,181,019 5,646,945 4,951,812 -12.3% Services & Supplies 2,847,171 2,850,156 3,137,463 1,474,405 -53.0% Capital Outlay* 0 153,762 0 208,000
Internal Srvc Chrg 759,397 826,419 1,038,469 861,165 -17.1% Operat Transfer Out 0 0 25,000 40,000 60.0%
Operating Expense 0 1,567 0 0
Grand Total 7,940,219 9,012,923 9,847,877 7,535,382 -23.5% FTE 35.00 30.00 -5.00
PAGE 53
Human Resources Department
Significant Changes from FY 2024
Budget
8 • Workers’ Compensation & Safety Re-Org:
> Reduction in HR Budget-Personnel, S&S, IS: $3,097,179 > Transferred to City Manager’s Office Budget beginning FY25
• Proposed Personnel:
> Salaries, Benefits and MOU Adjustments: $381,129
 Includes additional 1.0 FTE ($121,621) approved via FY24 Q2 Clean-up Report > PERS Increase: $116,406
> Workers’ Compensation Allocation: ($95,181)
• Proposed Services/Supplies:
> Other Contract Services (Gallup): $22,125
> Tuition Reimbursement: $80,000
PAGE 54
Human Resources Department
9 • Proposed Operating Transfers Out:
> Transfer to PWP: $15,000 (Total: $40,000)
> Air Quality Management District grant funding from the Prideshare program to subsidize the cost of the e-bike
rebate program in PWP (2nd Year)
Significant Changes from FY 2024
Budget
PAGE 55
Human Resources Department
10 • Proposed Capital Outlay:
> Automotive Equipment: $208,000
> Air Quality Management District grant funding from the Prideshare program to cover the cost of three Electric
Vehicles (EVs) in the Fire Department and one in the
Public Works Department.

Significant Changes from FY 2024
Budget
PAGE 56
Human Resources Department
FY 2025 Enhancement Requests
11 • Benefits Division:
> Add (1.0) FTE Sr. HR Analyst to the HR Department-
Benefits Division
 Estimated Cost: $142,671
> Reduce risk in this division by creating a succession plan, slowing turn-over, allocating resources to
leaves of absence management and launch new
employee wellness initiatives.

PAGE 57
PAGE 58

NEW BUSINESS
ITEM 3 (B)

3. BUDGET WORKSHOP FY 2025 RECOMMENDED OPERATING BUDGET OPERATING BUDGET PRESENTATIONS:

B. CITY MANAGER’s OFFICE
PAGE 59
City Manager Office
FY 2025 Recommended
Operating Budget
Finance Committee Item 3(B)
May 6, 2024
PAGE 60
City Manager Department
FY 2024 Accomplishments
• Secured successful approval of Charter Amendments
Meas
ures R, S & T with each passing with 86% or higher
voter approval
• Established Rent Stabilization Department
• Awarded Federal Earmark from Congressmember Chu
for
$1.5M for Dine Out Pasadena Program
• Awarded Historical & Master Plan contracts for the
Reconnec
ting Communities 710 project
• Established consolidated Risk Management function
• Acquired the 2.4-acr e former Kaiser property on Lake Ave & issued RFI seeking responses for design, planning, financing & development for mixed-use development
2 PAGE 61
City Manager Department
Appropriations by Category
3 Category
FY 2022
Actuals
FY 2023
Actuals
FY 2024
Adopted
FY 2025
Recommended
%
Change
Personnel 5,479,921 5,585,201 7,391,525 10,425,881 41.1% Services & Supplies 2,043,528 2,789,120 3,738,625 8,005,105 114.1% Capital Outlay 0 227,786 0 0
Internal Srvc Chrg 542,816 587,161 655,867 1,011,660 54.2% Grand Total 8,066,265 9,189,267 11,786,018 19,442,646 65.0% FTE 42.00 59.00 17.00
PAGE 62
City Manager Department
Significant Changes in Personnel
• Personnel – Incr ease 17.00 FTE
> 13 FTEs – Co nsolidation of Risk Management Functions from HR, PRCS, PWP and CAO to CM Office
> 2 FTEs – MAVII – E nterprise Risk Manager; Senior Office Assistant for Risk Management Division
> 1FTE – MAIII – R eal Property Manager (Econ Dev Division) > 1 FTE – Sustainability Coordinator (FY 2024)
4 PAGE 63
City Manager Department
Appropriations by Division
5 Category
FY 2022
Actuals
FY 2023
Actuals
FY 2024
Adopted
FY 2025
Recommended
%
Change
City Management-Admin. 2,561,825 3,098,665 3,329,624 6,114,394 83.6% Public Affairs 618,407 901,196 876,354 843,086 -3.8%
Economic Development
Division 4,401,293 4,581,447 6,707,431 6,652,161 -0.8%
Northwest Programs 5 50
Internal Audit 484,735 601,599 619,568 580,074 -6.4%
Risk Management 0 6,309 253,039 5,252,931 1975.9%
Grand Total 8,066,265 9,189,267 11,786,018 19,442,646 65.0% PAGE 64
City Manager Department
Significant Changes from FY 2024
Adopted Budget
• FY 2025 Recommended Budget of $19,442,646 is 65 %
Incr
ease over FY 2024 Adopted Budget
> Approximately $5.2 million creation of Risk Management Division
 Transfer of functions from HR, PRCS, PWP and CAO to CM Offic
e
> ~$1.6 million attributed to consultant services -
Rec
onnecting Communities 710 project
> $672,087 in Proposed Enhancements (next slide)
> Remaining cos t increases attributed to inflationary
adjustments for contractual & IS charges
6 PAGE 65
City Manager Department
Proposed Enhancements
• General Fund Enhancements - $288,225
> Personnel ($213,166)
 Senior Office Assistant – Ri sk Management
 Management Analyst III – Re al Property Program
> Services & Supplies (one-time $75K)
 Formation of BID – La manda Park Commercial District
• Non-General Fund Enhancements - $383, 862
> Personnel ($149,862)
 Management Analyst IV – Ent erprise Risk Management (Fund 507) > Services & Supplies ($234,000)
 Leased office space for Risk Management Division (Funds 506/507) 7 PAGE 66
City Manager Department
FY 2025 Priorities
• Public Affairs
> Video Content Development - Pro mote awareness of City programs, projects, initiatives & events
> Coordinate Citywide Outreach & Increase engagement
by stre
amlining & linking City Social Media Accounts to
Community Stakeholders, City Council newsletters &
existing Media Platforms
• Internal Audit
> Complete projects in approved Audit Plan
> Annual citywide risk assessment & update audit plan
> Monitor & report on Open Audit Recommendations
> Monitor & investigate fraud hotline complaints
8 PAGE 67
City Manager Department
FY 2025 Priorities (cont’d)
• Risk Management
> Promote culture of risk awareness, mitigation & strategic dec
ision-making related to risk across City departments
 Leverage the Risk Management Committee to mature
Ente
rprise Risk Management across the organization
 Continue to provide training to employee on the principles of effec
tive risk management
> Proactively identify potential safety issues & respond to empl
oyee safety concerns
 Implement Workplace Violence Prevention Program and
pro
vide training to all employees
> Identify & implement ways to enhance efficiency of the ins
urance review process as it relates to procurement
9 PAGE 68
City Manager Department
FY 2025 Priorities (cont’d)
• Continue planning efforts for Reconnecting Communities 710 pro
ject
• Continue to convene and forward the vision of the
Car
eer Technical Education Initiative working group
partnerships and pilot program
• Continue to assist with foundational work to prepare the Cit
y to host events in the 2028 Olympic Games
• Continue to mange City operations, ensure long-term
p
lanning for major capital reinvestment, and ensure
public services are provided efficiently, effectively, and with diligent oversight while furthering the City Council’s Strategic Plan and Goals
10 PAGE 69

INFORMATION ONLY
ITEM 4

4. ROSE BOWL OPERATING COMPANY FINANCIAL UPDATE
PAGE 70
PAGE 71
Agenda Report
March 27, 2024
TO: Rose Bowl Operating Company (through Finance Committee) FROM: Jens Weiden, General Manager
SUBJECT: Flash Reports
Recommendation:

This is an informational item only.

Background:

Following are Draft Flash Reports for:

Flea Market January-Feb 2024
Golf November-December 2023
“Flash Reports” are based on preliminary information for a particular month and in the case of Stadium events, are followed -up by complete “Event Settlements” which in turn, are used to produce tenant/promoter invoices and financial statements.

Further detail on these reports is available upon request.

Fiscal Impact:

The fiscal impact for each of the aforementioned events and revenue sources is shown in the attached reports.

Respectfully submitted by: Prepared by:

Jens Weiden, General Manager Mo Salama, CFO
DocuSign Envelope ID: A42F331A-7198-4E13-8BD0-CB2F4CB3CF17 PAGE 72

FLEA MARKET
2/11/2024 AS OF: 3/27/2024
Year to Year Weather: 2/11/2023 2/11/2024
59 61
65 Var %
of PY 12 Month YTD February 2023
Actual Budget Variance Actual Budget Variance YTD FY24 Budget Actuals Attendance 16,317 18,768 (2,451) 147,022 133,673 13,349 10% 209,616 135,431 Admissions (Buyers) 78,422 81,058$ (2,636) 705,029 577,322$ 127,707 22% 905,313$ 654,135 Rentals (Vendors) 54,428 47,500$ 6,928 420,749 338,310 $ 82,439 24% 530,514$ 384,809 License Fee (Rent) 132,851 128,558 4,293 1,125,778 915,632 210,146 23% 1,435,827 1,038,944 Expenses (Net) (10,382) (4,201) (6,180) (114,263) (32,311) (81,952) 254% (49,185) (68,956) Concessions (Net) 7140 LESS 7953 14,241 14,241 - 138,593 101,428 37,165 37% 159,053 126,851 Parking (Net) 6982 4,079 3,411 668 30,896 27,782 3,114 11% 41,400 17,450 Net Event Income 140,789$ 142,009$ (1,220)$ 1,181,005$ 1,012,531$ 168,473$ 17% 1,587,094$ 1,114,289$ 74% of Budget
* Budgeted expenses are used for certain outstanding expenses

CURRENT MONTH CURRENT YEAR YTD THRU
02/2024 02/2024

Page 1 of 2 ends

DocuSign Envelope ID: A42F331A-7198-4E13-8BD0-CB2F4CB3CF17 PAGE 73

FLEA MARKET
1/14/2024 AS OF: 2/29/2024
Year to Year Weather: 1/14/2023 1/14/2024
54 61
65 Var %
of PY 12 Month YTD January 2023
Actual Budget Variance Actual Budget Variance YTD FY24 Budget Actuals Attendance 23,317 16,691 6,626 130,705 114,905 15,800 14% 209,616 116,416 Admissions (Buyers) 109,029 72,089$ 36,940 626,607 496,264 $ 130,343 26% 905,313$ 562,289 Rentals (Vendors) 53,233 42,244$ 10,989 366,321 290,810 $ 75,510 26% 530,514$ 334,046 License Fee (Rent) 162,262 114,333 47,929 992,927 787,074 205,854 26% 1,435,827 896,335 Expenses (Net) (11,580) (4,038) (7,542) (103,881) (28,110) (75,771) 270% (49,185) (61,523) Concessions (Net) 7140 LESS 7953 12,665 12,665 - 124,353 87,188 37,165 43% 159,053 108,381 Parking (Net) 6982 3,850 3,473 377 26,817 24,372 2,446 10% 41,400 14,725 Net Event Income 167,198$ 126,434$ 40,764 $ 1,040,216$ 870,523$ 169,693$ 19% 1,587,094$ 957,918$ 66% of Budget
* Budgeted expenses are used for certain outstanding expenses

CURRENT MONTH CURRENT YEAR YTD THRU
01/2024 01/2024

Page 2 of 2 ends

DocuSign Envelope ID: A42F331A-7198-4E13-8BD0-CB2F4CB3CF17 PAGE 74

GOLF COURSE COMPLEX -FLASH REPORT
Report Date: 3/27/2024
Variance YTD
% of 12 MONTHS December '22
Actual Budget Variance Actual Budget Variance Budget Orig. Budget Actual Golf Operations Only (Net) 151,361 $ 260,941 $ (109,580) 1,196,551$ 1,117,199$ 79,352 7% 2,593,271 1,062,026$ Golf Displacement offset
(eg Net parking and golf closure)
- - - 596,000 498,000 98,000 20% 940,000 727,000 Events (Net) - 6,648 (6,648) (5,694) 39,887 (45,581) -114% 79,774 26,702 Subtotal: 151,361 267,589 (116,228) 1,786,857 1,655,086 131,771 8% 3,613,045 1,815,728 Food & Beverage (Net) 107,422 84,863 22,559 362,577 282,930 79,646 28% 566,860 # 51,355 Lessons (Net) 2,125 2,250 (125) 10,180 8,700 1,480 17% 17,550 # 7,550 Pro Shop (Net) 21,192 12,485 8,707 96,291 88,161 8,130 9% 167,673 # 78,040 Golf Complex Net Income 282,099 367,186 (85,087) 2,255,906 2,034,878 221,028 11% 4,365,129 # 1,952,673 Overhead Expenses (YTD Estimates) (691,515) (691,515) - (1,383,030) (479,563) - Cost Recovery/Interest - - - - - . .

Set Aside for Capital (204,249) (208,668) 4,419 -2% (585,390) (197,277) TOTAL RENT - GOLF COURSE COMPLEX 282,099 $ 367,186 $ (85,087)$ 1,360,142$ 1,134,695$ 225,447$ 2,396,709$ # 1,275,833$ Variance from Prior YTD: 84,309$ 7%
Statistical Summary:

Monthly Rounds 10,169 12,472 (2,303) 68,083 69,556 (1,473) -2% 143,630 65,759 Playable Days 26 29 (3) 153 153 0 310 146
Rounds/Day 391 430 (39) 445 455 (10) 463 450
Avg Green fee + Cart fee Per Round 50.21 $ 40.17 $ 10.04$ 46.73$ 43.72$ 3.01$ 43.17$ 43.14$ Average Range Fees Per Round 6.63 $ 5.37 $ 1.26$ 5.89$ 5.61$ 0.28$ 5.47$ 6.46$ Total Revenue Per Round 56.84 $ 45.54 $ 11.30$ 52.62$ 49.33$ 3.29$ 7% 48.64 $ 49.60$ Current Month YTD
12/31/2023 12/31/2023

Page 1 of 3 ends

DocuSign Envelope ID: A42F331A-7198-4E13-8BD0-CB2F4CB3CF17 PAGE 75

GOLF COURSE COMPLEX -FLASH REPORT
Report Date: 3/27/2024
Variance YTD
% of 12 MONTHS December '22
Actual Budget Variance Actual Budget Variance Budget Orig. Budget Actual Current Month YTD
12/31/2023 12/31/2023

DETAILS GOLF COURSE
Golf Revenues:

DF/Gst-Greens 358,831 350,000 8,831 1,905,283 1,870,000 35,283 DF/Gst-Greens No Show 4,107 - 4,107 50,160 - 50,160 Tournament-Greens 31,989 35,000 (3,011) 449,898 405,000 44,898 DF/Gst-Carts 110,505 110,000 505 681,125 660,000 21,125 DF/Gst-Carts Employee - - - - - -
Trn-Carts 5,148 6,000 (852) 95,347 106,000 (10,653) Driving Range-Range Fees 13,313 12,000 1,313 76,407 69,000 7,407 Driving Range-Key - - - - - -
Driving Range-Tournament - - - - - -
Driving Range-Player's Club 54,107 55,000 (893) 324,843 321,000 3,843 Other Golf-Club Rental - - - - - -
Other Golf-Reservation - - - - - -
Misc. Operating Income 2,532 - 2,532 (3,912) - (3,912) Total Golf Revenues 580,531 568,000 12,531 3,579,151 3,431,000 148,151 4% 6,970,476 3,252,953 Golf Expenses:

Payroll and Related Expenses (189,139) (172,134) (17,005) (961,897) (1,032,801) 70,904 General and Admin (30,447) (13,250) (17,197) (111,182) (79,500) (31,682) Property Taxes (759) (1,500) 741 (4,556) (9,000) 4,444 Routine Repairs & Maintenance (36,249) (10,200) (26,049) (98,036) (85,200) (12,836) Management Fee Expense (29,433) (29,775) 342 (176,598) (178,650) 2,052 Other Oper. Expenses (78,314) (51,400) (26,914) (381,083) (309,350) (71,733) Utilities-Water (56,152) (20,000) (36,152) (597,660) (565,000) (32,660) Utilities-Power/Nat Gas (7,427) (8,000) 573 (42,744) (48,000) 5,256 Utilities-Telephone (337) (100) (237) (3,256) (600) (2,656) Utilities-Security System (573) - (573) (2,950) (1,500) (1,450) Utilities-TV Cable - (100) 100 (268) (600) 332
Utilities-Waste Removal (338) (600) 262 (2,369) (3,600) 1,231 Total Golf Expense (429,170) (307,059) (122,111) (2,382,599) (2,313,801) (68,798) 3% (4,359,205) (2,187,032) Golf Operations Only (Net) 151,361 260,941 (109,580) 1,196,552 1,117,199 79,353 7% 2,611,271 1,065,921

Page 2 of 3 ends

DocuSign Envelope ID: A42F331A-7198-4E13-8BD0-CB2F4CB3CF17 PAGE 76

OTHER NON-GOLF REVENUES
Golf Displacement offset
(eg Net parking and golf closure) -$ -$ -$ 596,000$ 498,000$ 98,000$ 940,000 727,000 Displacement/Parking Net events YTD: FY23 had 10 events vs FY22 had 2 events.

Events (Net) -$ 6,648 $ (6,648)$ (5,694)$ 39,887$ (45,581)$ 79,774$ 26,702$ Food & Beverage (Net)
Food & Beverage Subtotal 107,422 84,863 22,559 362,577 282,930 79,646 28% 566,860 51,355 - -
Lessons (Net) 2,125 2,250 (125) 10,180 8,700 1,480 17,550 7,550 Pro Shop (Net) 21,192 12,485 8,707 96,291 88,161 8,130 167,673 78,040 (est to budget)
Golf Complex Net Income 282,100 367,186 (85,086) 2,255,906 2,034,878 221,029 11% 4,383,129 1,949,018 Overhead Expenses (YTD Estiamtes) (691,515) (691,515) - (1,383,030) (479,563) Cost Recovery/Interest - - - - -
Set Aside for Capital (204,249) (208,668) 4,419 (585,390) (197,277) GOLF COURSE COMPLEX -YTD TOTAL 282,100 367,186 (85,086) 1,360,142 1,134,695 225,448 2,414,709 1,272,178 - - - -

Page 3 of 3 ends

DocuSign Envelope ID: A42F331A-7198-4E13-8BD0-CB2F4CB3CF17 PAGE 77

GOLF COURSE COMPLEX -FLASH REPORT
Report Date: 3/27/2024
Variance YTD
% of 12 MONTHS November '22
Actual Budget Variance Actual Budget Variance Budget Orig. Budget Actual Golf Operations Only (Net) 249,680 $ 212,941 $ 36,739 1,045,191$ 856,258$ 188,933 22% 2,593,271 797,641$ Golf Displacement offset
(eg Net parking and golf closure)
66,000 60,000 6,000 596,000 498,000 98,000 20% 940,000 727,000 Events (Net) - 6,648 (6,648) (5,694) 33,239 (38,933) -117% 79,774 26,702 Subtotal: 315,680 279,589 36,091 1,635,497 1,387,497 247,999 18% 3,613,045 1,551,343 Food & Beverage (Net) 30,642 47,664 (17,022) 255,155 198,068 57,087 29% 566,860 # 92,263 Lessons (Net) 2,175 2,150 25 8,055 6,450 1,605 25% 17,550 # 5,300 Pro Shop (Net) 22,222 15,635 6,587 75,100 75,677 (577) -1% 167,673 # 67,466 Golf Complex Net Income 370,719 345,038 25,681 1,973,806 1,667,692 306,115 18% 4,365,129 # 1,716,372 Overhead Expenses (YTD Estimates) (576,263) (576,263) - (1,383,030) (399,636) - Cost Recovery/Interest - - - - - . .

Set Aside for Capital (173,742) (171,252) (2,490) 1% (585,390) (206,409) TOTAL RENT - GOLF COURSE COMPLEX 370,719 $ 345,038 $ 25,681$ 1,223,802$ 920,177$ 303,625$ 2,396,709$ # 1,110,327$ Variance from Prior YTD: 113,475$ 10%
*Prior year adjustment reducing Net by $1,244.

Statistical Summary:

Monthly Rounds 11,141 11,454 (313) 57,914 57,084 830 1% 143,630 68,803 Playable Days 28 26 2 127 124 3 310 140
Rounds/Day 398 441 (43) 456 460 (4) 463 494
Avg Green fee + Cart fee Per Round 46.55 $ 43.65 $ 2.90$ 46.12$ 44.50$ 1.62$ 43.17$ 38.26$ Average Range Fees Per Round 5.90 $ 6.11 $ (0.21)$ 5.76$ 5.66$ 0.10$ 5.47$ 4.17$ Total Revenue Per Round 52.45 $ 49.76 $ 2.69$ 51.88$ 50.16$ 1.72$ 3% 48.64 $ 42.43$ Current Month YTD
11/30/2023 11/30/2023

Page 1 of 3 ends

DocuSign Envelope ID: A42F331A-7198-4E13-8BD0-CB2F4CB3CF17 PAGE 78

GOLF COURSE COMPLEX -FLASH REPORT
Report Date: 3/27/2024
Variance YTD
% of 12 MONTHS November '22
Actual Budget Variance Actual Budget Variance Budget Orig. Budget Actual Current Month YTD
11/30/2023 11/30/2023

DETAILS GOLF COURSE
Golf Revenues:

DF/Gst-Greens 319,017 280,000 39,017 1,546,452 1,520,000 26,452 DF/Gst-Greens No Show 5,369 - 5,369 46,053 - 46,053 Tournament-Greens 68,557 95,000 (26,443) 417,909 370,000 47,909 DF/Gst-Carts 108,897 100,000 8,897 570,620 550,000 20,620 DF/Gst-Carts Employee - - - - - -
Trn-Carts 16,770 25,000 (8,230) 90,199 100,000 (9,801) Driving Range-Range Fees 12,197 12,000 197 63,094 57,000 6,094 Driving Range-Key - - - - - -
Driving Range-Tournament - - - - - -
Driving Range-Player's Club 53,512 58,000 (4,488) 270,736 266,000 4,736 Other Golf-Club Rental - - - - - -
Other Golf-Reservation - - - - - -
Misc. Operating Income (700) - (700) (6,444) - (6,444) Total Golf Revenues 583,618 570,000 13,618 2,998,620 2,863,000 135,620 5% 6,970,476 2,708,993 Golf Expenses:

Payroll and Related Expenses (148,540) (172,134) 23,594 (772,758) (860,667) 87,909 General and Admin (11,575) (13,250) 1,676 (80,735) (66,250) (14,485) Property Taxes (759) (1,500) 741 (3,797) (7,500) 3,703 Routine Repairs & Maintenance (11,587) (10,200) (1,387) (61,787) (75,000) 13,213 Management Fee Expense (29,433) (29,775) 342 (147,165) (148,875) 1,710 Other Oper. Expenses (68,415) (51,400) (17,015) (302,769) (257,950) (44,819) Utilities-Water (55,994) (70,000) 14,006 (541,508) (545,000) 3,492 Utilities-Power/Nat Gas (6,819) (8,000) 1,181 (35,316) (40,000) 4,684 Utilities-Telephone (477) (100) (377) (2,919) (500) (2,419) Utilities-Security System - - - (2,377) (1,500) (877) Utilities-TV Cable - (100) 100 (268) (500) 232
Utilities-Waste Removal (338) (600) 262 (2,030) (3,000) 970 Total Golf Expense (333,938) (357,059) 23,121 (1,953,429) (2,006,742) 53,313 -3% (4,359,205) (1,911,352) Golf Operations Only (Net) 249,680 212,941 36,739 1,045,191 856,258 188,933 22% 2,611,271 797,641

Page 2 of 3 ends

DocuSign Envelope ID: A42F331A-7198-4E13-8BD0-CB2F4CB3CF17 PAGE 79

OTHER NON-GOLF REVENUES
Golf Displacement offset
(eg Net parking and golf closure) 66,000$ 60,000$ 6,000$ 596,000$ 498,000$ 98,000$ 940,000 727,000 Events (Net) -$ 6,648 $ (6,648)$ (5,694)$ 33,239$ (38,933)$ 79,774$ 26,702$ Food & Beverage (Net)
Food & Beverage Subtotal 30,642 47,664 (17,022) 255,155 198,068 57,087 29% 566,860 92,263 - -
Lessons (Net) 2,175 2,150 25 8,055 6,450 1,605 17,550 5,300 Pro Shop (Net) 22,222 15,635 6,587 75,100 75,677 (577) 167,673 67,466 (est to budget)
Golf Complex Net Income 370,720 345,038 25,682 1,973,806 1,667,692 306,115 18% 4,383,129 1,711,072 Overhead Expenses (YTD Estiamtes) (576,263) (576,263) - (1,383,030) (399,636) Cost Recovery/Interest - - - - -
Set Aside for Capital (173,742) (171,252) (2,490) (585,390) (206,409) GOLF COURSE COMPLEX -YTD TOTAL 370,720 345,038 25,682 1,223,802 920,177 303,625 2,414,709 1,105,027 - - - -

Page 3 of 3 ends

DocuSign Envelope ID: A42F331A-7198-4E13-8BD0-CB2F4CB3CF17 PAGE 80

INFORMATION ONLY
ITEM 5

5. PASADENA CENTER OPERATING COMPANY

FINANCIAL UPDATE
PAGE 81
PAGE 82
/-------- Year - to - Date Through /
Actual Budget
Actual vs.

Budget Prior Year CY vs. PY
% Change
CY vs. PY
FY 2024
Adopted Budget
Fav / (unfav) Fav / (unfav)
Period Ended
February 2024
Operating Revenue
Convention Center 1,887,000$ 1,568,000$ 319,000$ 1,965,000$ (78,000)$ -4.0% 2,380,000$ Other rentals & Commissions 1,301,000 1,286,000 15,000 1,378,000 (77,000) -5.6% 2,085,000 Subtotal Center revenue 3,188,000 2,854,000 334,000 3,343,000 (155,000) -4.6% 4,465,000 Civic Auditorium & Facility Fees 1,078,000 817,000 261,000 1,149,000 (71,000) n/a 1,330,000 Food Service Commission 797,000 605,000 192,000 526,000 271,000 51.5% 900,000 Parking Garage 1,199,000 1,110,000 89,000 1,260,000 (61,000) -4.8% 1,800,000 Ice Skating Center 2,353,000 2,178,000 175,000 2,387,000 (34,000) -1.4% 3,000,000 Total Operating Revenues 8,615,000 7,564,000 1,051,000 8,665,000 (50,000) -0.6% 11,495,000 Investment Earnings 17,000 17,000 - 8,000 9,000 112.5% 25,000 Total Revenues: 8,632,000 7,581,000 1,051,000 8,673,000 (41,000) -0.5% 11,520,000 Center Operating Expenses
Convention Center 4,688,000 5,315,000 627,000 4,178,000 (510,000) -12.2% 7,989,000
Parking Garage Expense 216,000 262,000 46,000 180,281 (35,719) -19.8% 396,000 Ice Skating Center 1,271,000 1,298,000 27,000 1,097,000 (174,000) -15.9% 1,947,000 Total Center Operating Expense 6,175,000 6,875,000 700,000 5,455,281 (719,719) -13.2% 10,332,000 Operating Results: 2,457,000 706,000 1,751,000 3,217,719 (760,719) -23.6% 1,188,000 Debt Service - Loans - - - 108,000 108,000 100.0% 275,000 Net Gain/(Loss) 2,457,000$ 706,000$ 1,751,000$ 3,109,719$ (652,719)$ -21.0% 913,000$ TOT / Bonds Debt Services
Transient Occupancy Tax 8,249,000 8,154,000 95,000 8,125,000 124,000 1.5% 11,832,000 Debt Services & Allowance 7,062,000 8,105,000 1,043,000 7,199,000 137,000 1.9% 11,832,000 Net Gain / (Loss) 1,187,000$ 49,000$ 1,138,000$ 926,000$ 261,000$ 28.2% -$ Convention Visitors Bureau
TBID Assessment 2,738,000 2,666,000 72,000 2,666,000 72,000 2.7% 4,000,000 Convention Visitors Bureau Expenses 1,928,000 2,415,000 487,000 1,859,000 (69,000) -3.7% 3,750,000 Net Gain / (Loss) 810,000$ 251,000$ 559,000$ 807,000$ 3,000$ 0.4% 250,000$ Total PCOC
Total Revenue 19,619,000$ 18,401,000$ 1,218,000$ 19,464,000$ 155,000$ 0.8% 27,352,000$ Total Expenses 15,165,000 17,395,000 2,230,000 14,621,281 (543,719) -3.7% 26,189,000 Toal Net Gain / (Loss) 4,454,000$ 1,006,000$ 3,448,000$ 4,842,719$ (388,719)$ -8.0% 1,163,000$ sage Intell
Attachment A
PAGE 83
Fiscal Year 2024
2/29/2024
Projects Location Budget Amount Actual Amount Over / (Under) Status Exterior Waterproofing / Painting Civic exterior Civic 2,300,000.00 - (2,300,000.00) General Facility Maintenance Repair
including Civic, Ice Rink, Conference Ctr General 200,000.00 69,000.00 (131,000.00) 2,500,000.00 69,000.00 (2,431,000.00)
Notes: (1) Equipment purchased for $69k.

Capital Improvements Programs
PAGE 84

INFORMATION ONLY
ITEM 6

6. FY 2024 CAPITAL IMPROVEMENT PROGRAM -

THIRD QUARTER MONITORING REPORT
PAGE 85
TO:

FROM:

DATE:

DEPARTMENT OF PUBLIC WORKS

MEMORANDUM
Miguel Marquez, City Manager
Tony Olmos, P.E., Director of Public wof}_'p,
May 6, 2024
SUBJECT: FY 2024 Capital Improvement Program - Third Quarter Monitoring Report Attached for the Finance Committee's review is an update of the active Capital Improvement Program (CIP) projects through March 31, 2024. The Third Quarter Monitoring Report (QMR) includes 184 projects as summarized on the chart below:

Number of Projects Reviewed - 184
Planning
7%
Ongo;n
j
44%
Completed 4%
\
""'- No Activity
11%
Construction
15%
Design
23%
There are 31 active projects not included in the QMR. These projects are pending funding, do not have an FY 2024 workplan, and therefore, have no reportable activity.

If you have questions on any projects, please let me know prior to the May 6, 2024 Finance Committee meeting and I will have the appropriate staff available to respond.

Thank you.

PAGE 86
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
LEGEND
Project Completed
Project Delayed - External Factors
Project Delayed - Internal Factors
Project Over Budget
PAGE 87
Municipal Buildings and Facilities
9,000,0009,000,000Central Library Seismic Retrofit
and Renovations - Design Phase
719221 Design continued in the third quarter.

An update on the schematic design
and programming was presented to
the City Council on January 22,
2024. Community Meeting #4 was
held on March 13, 2024.

Environmental documentation and
design will continue in FY 2024.
4,000,000
39% 6/30/2025 Design3,511,166
1,709,0502,089,050Public Works Building - Seismic
Upgrade
719152 Project advertised for construction
bids for a third time in the second
quarter. One bid was received on
November 30 and exceeded the
project budget and fell beneath the
benefit cost ratio established by
FEMA for construction grant funding.

Requesting the final FEMA grant
reimbursement for the planning and
design phases. The CIP project will
have no further activity beyond the
third quarter.

Construction will begin when funds are
identified.
1,000,000
16% N/A Design265,505
7,675,0008,175,000Fire Stations Renovations and
Improvements
719113 Plan check for Fire Station 33 pre-
fab storage building was completed
in the third quarter and construction
is anticipated to begin in the fourth
quarter. Construction for Fire Station
38 continued in the third quarter, and
is anticipated to be completed in the
fourth quarter.

Seismic retrofit and renovations at Fire
Station 38, and storage building at Fire
Station 33, will be completed in FY
2024.
1,500,000
71% N/A Construction5,442,124
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 2
PAGE 88
9,344,5769,361,466Building Maintenance FY 2021 -
2025
719034 Specification development for
electrical panels for the BSFMD
Administration Building continued in
the third quarter. Materials for the
installation of LED canned lighting in
the City Hall Courtyard were
procured in the third quarter and
Installation is anticipated to begin in
the fourth quarter. The bidding
portion of the procurement process
for the installation of roll up doors at
the City Yards, Fleet Building/W&P
Meter shop/ W&P Warehouse, as
well as the procurement of the
automated rear access door at CHC
is anticipated to begin in the fourth
quarter.

Work will be completed at the following
locations in FY 2024: City Hall, Hale
Building, City Yards, Robinson Park
Center, Villa Parke Center, Victory
Park Center, Police Department, and
Pasadena Community Health Center.
1,000,000
50% 6/30/2025 Design4,659,701
3,400,0003,400,000Mobile Operations Center719195 The vendor who was awarded the hangar procurement contract on
September 18, 2023 refused to
honor pricing and execute contract.

As a result, contract for the purchase
of a prefabricated building was re-
advertised in the third quarter.

Contract is anticipated to be awarded
in the fourth quarter.

Construction of the new hanger will
begin in FY 2024.
500,000
54% 6/30/2025 Design1,838,964
222,0004,060,000Parking Lot Improvements at City
Facilities FY 2024-2028
719277 The FY 2024 workplan was
completed in the second quarter.

In FY 2024, construction of the
Lamanda Park Library parking lot
improvements will be completed, and
the City Facility Parking Lot
Assessment will be re-evaluated and
updated.
160,000
1% 6/30/2028 Ongoing1,565
3,907,9333,908,000Hale Building Interior Remodel -
Phase II
711708 Design was completed and
construction documents were
approved by Planning in the third
quarter. Project was advertised for
construction and contract will be
awarded in the fourth quarter.

Phase II construction will begin FY
2024.
500,000
11% 6/30/2025 Design419,521
600,000600,000Roof Replacements - Hill Ave
Library and Victory Park
Recreation Center
719169 Structural investigation proposals for
Hill Ave roof system were received in
the third quarter.

Design of the Hill Avenue Library roof
will begin in FY 2024.
300,000
24% N/A Design141,387
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 3
PAGE 89
300,000300,000City Hall Building Systems -
Design Phase
7192310 The City Hall Building Assessment
Report was completed in the fourth
quarter of FY 2023. Design will begin
in the fourth quarter upon evaluation
and prioritization of work identified by
the Assessment Report.

Design will begin in FY 2024.300,000
1% 6/30/2025 Ongoing2,470
175,000540,000Update to ADA Transition Plan for
City Facilities
7192411 Professional services contract to
update the ADA Transition Plan was
awarded by City Council on March
11, 2024.

This project will continue in FY 2024.150,000
11% 6/30/2025 Ongoing18,776
380,000380,000Alkebu-Lan Cultural Center
Improvements
7192112 Construction was completed in the
third quarter.

Construction will be completed in FY
2024.
345,589
57% 6/30/2024 Completed215,538
100,000100,000Public Health Building Restrooms
- ADA Improvements
7192513 Application for additional CDBG
funding was submitted in the third
quarter, however the project was not
awarded funds. Construction is
pending due to lack of funds.

Improvements will be completed in FY
2024.
69,565
49% 6/30/2024 Ongoing49,069
500,0005,000,000Improvements at City Yards
Facility
7192816 Design was completed in the third
quarter. Outreach is anticipated to
begin in the fourth quarter.

Design and construction of the phased
parking lot resurfacing will be
completed in FY 2024. Construction
for parking lot improvements will be
done in coordination with the Sunset
Reservoir project, located adjacent to
City Yards.
500,000
2% N/A Design8,883
Streets and Streetscapes
16,195,39156,195,391Annual Citywide Street
Resurfacing and ADA
Improvement Program FY
2023/2024
739381 This project will be constructed under
two construction contracts. The
contract for Phase 1 work began
construction in the first quarter and
continued in the third quarter, and is
anticipated for completion in the
fourth quarter. Design for Phase II
was completed in the third quarter.

Resurfacing will continue in FY 2024.5,000,000
48% 12/31/2024 Construction7,743,788
1,598,0502,798,050Curb Ramp ADA Improvements
Program FY 2022 - 2026
739372 Next project phase will be advertised
and is anticipated to be awarded in
the fourth quarter.

Installation of curb ramps will continue
in FY 2024.
300,000
83% 6/30/2026 Design1,329,720
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 4
PAGE 90
14,035,10822,035,108Annual ADA Sidewalk
Improvement Program
739133 Construction continued in the third
quarter.

Repair of sidewalks will continue in FY
2024.
1,400,000
93% 6/30/2024 Construction13,115,518
2,208,8242,408,824Miscellaneous Sidewalk Repair
Program FY 2021 - 2025
739404 Construction continued in third
quarter.

Sidewalk repairs will continue in FY
2024.
200,000
69% 6/30/2025 Construction1,524,533
3,050,0003,050,000Colorado Street Bridge Barrier
Enhancements - Design Phase
733245 Concept design development and
public outreach continued in the third
quarter. The project was presented
to Design Commission on January 9,
2024. The second public opinion
questionnaire (opened in the second
quarter on the project's webpage)
closed on February 29, 2024. The
project team is tentatively scheduled
to return to Public Safety Committee
in the fourth quarter.

Conceptual design and public
outreach will continue in FY 2024.
300,000
44% 6/30/2025 Design1,340,194
2,525,00010,575,000Holly Street Bridge - Seismic
Retrofit
733236 Design continued in the third quarter
along with completion CEQA
documentation.

Design will continue in FY 2024.500,000
42% 6/30/2025 Design1,050,590
200,000600,000Guardrail Program FY 2023 -
2027
739417 Ongoing discussion with contractor
for construction award in third
quarter.

This is a continuing program. Projects
will be scheduled by City staff as
repairs and/or replacements are
identified.
100,000
34% 6/30/2027 Ongoing67,838
100,000500,000Bridge Improvement Program FY
2024 - 2028
739438 LA County re-advertised BPMP
Group 16 project on March 6, 2024.

Bids are scheduled for submittal on
the fourth quarter.

Bridge inspections and improvements
will continue in FY 2024.
100,000
3% 6/30/2028 Ongoing3,062
Street Lighting
4,435,0004,935,000High Voltage Series Street Light
Conversion - Phase I
744151 Construction of underground
conduits for street lighting
substructure on S-104 (Linda Vista
Ave) circuit began in the third
quarter. Advertising for S-013
(Marengo Ave) circuit began in the
third quarter.

In FY 2024, design will continue for the
S-104 (Linda Vista Ave.) and S-057
(Orange Grove Blvd. from Wilson Ave.
to Oak Ave.) circuits. In addition,
construction on S-013 (Marengo Ave.)
circuit will be completed.
1,000,000
34% 12/31/2025 Construction1,521,865
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 5
PAGE 91
300,00015,620,000High Voltage Series Street Light
Conversion - Phase II
744172 No reportable activity in the third
quarter.

Design of the S-048 (San Rafael Ave.)
and S-092 (Orange Grove) circuits will
continue in FY 2024. Future circuit
conversions pending additional
funding.
60,000
79% N/A Design237,849
155,0005,060,000High Voltage Series Street Light
Conversion - Phase III
744203 Conduit installations and circuit
conversions for S-064 began in third
quarter.

Construction on the S-064
(Rosemead) circuit will be completed
in FY 2024. Future circuit conversions
will begin when funding becomes
available.
70,000
57% 6/30/2024 Construction88,162
500,0566,500,000Street Lighting Program FY 2024 -
2028
744224 Work performed to seal the
streetlight pull boxes to deter wire
theft continued in the third quarter.

Coordinating with Metro on Lake
Avenue Metro station canopy lighting
in third quarter. Repairs to Musco
field lighting at Robinson Field
completed in the third quarter.

This is a continuing program. Projects
will be scheduled by City staff as
requests are received for enhanced
lighting or in-fill lighting; and as street
light components in need of repair or
replacement are identified.
100,000
7% 6/30/2028 Ongoing32,866
300,0002,860,000LED Street and Safety Lighting
Upgrades FY 2023 - 2027
744215 Procurement of LED luminaires, and
installation continued in the third
quarter.

Procurement and installation of Phase
I will be completed in FY 2024.
150,000
29% 6/30/2027 Construction87,802
Street Lighting and Electric Undergrounding
4,800,00011,130,000Mountain Street - Electrical
System Undergrounding, Lake
Avenue to Hill Avenue
32131 Right of access letters for the district
were prepared, and street lighting
design continued in the third quarter.

In FY 2024, PWP will complete the
design and begin construction contract
procurement. Public Works will begin
design of the street lighting and civil
improvements.
50,000
4% 6/30/2027 Design182,919
1,110,00036,310,000Raymond Avenue - Electrical
System Undergrounding, Maple
Street to North City Limits
32142 Right of access letters for the district
were prepared and procurement for
the installation of the joint
substructure was initiated. In
addition, street lighting design
continued in the third quarter.

In FY 2024, PWP will complete the
design and begin construction contract
procurement. Public Works will begin
design of street lighting and civil
improvements.
90,000
35% 6/30/2027 Design383,581
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 6
PAGE 92
634,000385,000Electric System Undergrounding
Outside Established
Undergrounding Districts
32103 A reimbursement application was
received and processed in the third
quarter.

This is an ongoing project involving
undergrounding projects that are not
part of an established undergrounding
district. In FY 2024, an estimated four
service reimbursements will be
processed.
17,000
33% 6/30/2027 Ongoing206,852
76,0003,081,000Florecita Drive - Electrical System
Undergrounding
32174 No reportable activity in the third
quarter.

In FY 2024, Pasadena Water and
Power will formally establish the
underground utility district and begin
design work to underground high
voltage overhead circuitry in the Tier 3
Fire Threat areas containing Florecita
Dr. Project area contains addresses at
the north end of Crestford Dr.,
Florecita Crescent, and Florceita Dr.
60,000
0% 6/30/2027 No Activity This
Quarter
0 Transportation
Active Transportation/Complete Streets
513,481613,481Pasadena Bicycle Program FY
2021-2025
751111 Greenways outreach on schedule for
outreach. Bike rack maintenance and
installations continued through third
quarter.

Implementation of the Bicycle
Transportation Plan will continue in FY
2024, including installation of
additional painted bikeway amenities
such as green paint at conflict points
and installation of sharrows along
Roseways. In addition, prioritization of
bike boulevards (Greenways), existing
bike network gaps, and associated
outreach will continue in FY 2024.
90,000
87% 6/30/2025 Ongoing448,015
642,215874,915Citywide Complete Streets
Program FY 2021-2025
751142 NTMP pilot planning for Raymond
Avenue continued in the third
quarter.

Ongoing work, including speed hump
investigations, the preferential parking
program, and the Neighborhood Traffic
Management Program (NTMP), will
continue in FY 2024. A specific NTMP
for the neighborhood of Mountain
St./El Molino Ave. area (between Los
Robles Ave. and Lake Ave.) is
expected to begin in FY 2024.
75,000
72% 6/30/2025 Ongoing462,833
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 7
PAGE 93
1,258,2291,419,981Pedestrian Crossing
Enhancements Program FY 2021-
2025
751123 Construction contract was awarded
by City Council on December 11,
2023. Pre-construction work is
anticipated to begin in the fourth
quarter.

Construction of Rectangular Rapid
Flashing Beacons at Raymond Ave.
and Grandview St., Euclid Ave. and
Glenarm St., and El Molino Ave. and
Buckeye St. will begin in FY 2024.
250,000
43% 6/30/2025 Construction536,102
260,500410,500Arterials Speed Management
Program FY 2021-2025
751134 Design continued for current list of
priority locations in the third quarter.

Design for speed feedback signs on El
Molino Ave. between Del Mar Blvd.
and California Blvd.; El Molino Ave.
between California Blvd. and Alpine
St.; Los Robles Ave. between
California Blvd. and Fillmore St.; and
Orange Grove Blvd. between Wigmore
St. and Arlington Dr. will begin in FY
2024.
75,000
43% 6/30/2025 Design112,196
10,312,01710,312,017Complete Streets Project - Union
Street Cycle Track
750875 This project was completed in the
first quarter. A ribbon cutting for the
new Union Street protected bikeway
was held on September 9, 2023.

Construction will be completed in FY
2024.
2,500,000
98% 12/30/2023 Completed10,082,793
4,476,3425,500,000Complete Streets Project -
Cordova St from Hill Ave to Arroyo
Pkwy
750526 This project was completed in the
second quarter.

Construction will be completed in FY
2024.
600,000
76% 6/30/2024 Completed3,416,582
4,071,0004,071,000Complete Streets Project - Ave 64
from Colorado Blvd to South City
Limits
750778 Construction began in the third
quarter and is anticipated to be
completed by end of the fourth
quarter.

Construction is anticipated to begin in
FY 2024.
2,400,000
50% 12/20/2024 Construction2,022,926
1,599,9801,599,980Complete Streets Project - N Hill
Ave from North City Limit to Villa
St
750939 Roundabout at Topeka St. is
complete. Study to determine
efficacy before second roundabout
completed in the third quarter.

In FY 2024, construction will begin for
improvements at the intersection of Hill
Ave. and Topeka St.
1,200,000
58% 11/3/2023 Construction933,310
3,783,0903,783,090South Lake Ave Pedestrian
Access Improvements to L Line
Station
7510610 Street lighting and traffic signal
installations continued in the third
quarter, civil improvements began in
the third quarter.

Construction will begin in FY 2024.2,500,000
56% 12/30/2024 Construction2,131,757
2,106,6812,606,681Enhancements to Metro L Line
Allen Station
7551411 Design continued in the third quarter.In FY 2024, construction of the quick build is anticipated to begin, and the
design of the permanent installation
will continue.
100,000
2% 12/30/2026 Design41,601
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 8
PAGE 94
1,507,5001,507,500Installation of Leading Pedestrian
Interval and Audible Signals at
Signalized Intersections
7512512 Construction contract was awarded
on December 11, 2023 and
construction is anticipated to begin in
the fourth quarter.

Construction will begin in FY 2024.1,000,000
9% 12/30/2024 Construction135,586
12,600,00012,600,000Greenway (Bike Boulevard)
Implementation
7512613 Work to execute Metro funding
agreement for design and
construction of the four north-south
Greenways continued in the third
quarter. Design outreach and request
for proposals anticipated to begin the
fourth quarter.

Greenway outreach will continue on
Craig Ave. and El Molino Ave.
corridors in FY 2024. A final Greenway
work plan for all four corridors is being
developed, pending the execution of a
Metro funding agreement for Measure
R MIP funding.
400,000
0% 6/30/2029 Ongoing0
150,0002,200,000Pasadena Pedestrian Plan -
Outreach and Conceptual Design
7551114 Pedestrian Transportation Action
Plan revised and approved by
council in third quarter. Outreach and
concept design is anticipated to
begin in the fourth quarter.

Outreach and concept design is
anticipated to begin in FY 2024.
130,000
0% N/A Design0
75,100,00075,100,000Pasadena Ave and St John Ave
Street Improvements
7512716 Project is pending execution funding
agreement.

The work plan for the project is under
development, pending the execution of
a Metro funding agreement for
Measure R MIP funding in FY 2024.
250,000
0% 6/30/2029 Ongoing0
9,900,0009,900,000Columbia Street Multimodal
Improvements
7512817 No reportable activity in the third
quarter.

Project is pending execution of Metro
funding agreement.

The work plan for this project is under
development, pending the execution of
a Metro funding agreement for
Measure R MIP funding in FY 2024.
100,000
0% 6/30/2029 No Activity This
Quarter
0 160,000160,000Left Turn Signal Phasing at Fair
Oaks Ave. and Colorado Blvd.
7509051 Installation of longer mast arms and
signal timing completed in third
quarter.

Construction will be completed by City
crews in FY 2024.
0 98% 6/30/2024 Completed157,345
Traffic Operations, Traffic Signals, and ITS
1,447,1911,447,191Implement Bus Signal Priority
System on Pasadena Transit
Buses
7509424 Project is under redesign and is
anticipated to advertise in the fourth
quarter.

Construction will begin in FY 2024.1,000,000
23% 12/31/2024 Design338,759
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 9
PAGE 95
159,512189,512Old Pasadena Traffic
Improvement - FY 2021-2025
7511625 No reportable activity in the third
quarter. Midblock crossing on
Raymond assessment anticipated to
begin in the fourth quarter.

On-street dining and midblock
crosswalk study will continue in FY
2024. Additional enhancements to
signing, striping, on-street parking,
and signal operations will continue as
requested and received.
30,000
13% 6/30/2025 No Activity This
Quarter
20,329
698,711698,711Intelligent Transportation System
Phase I - Parking Guidance
7591226 This project was completed in the
second quarter. Final signage
planning continued in the third
quarter.

Construction will be completed in FY
2024.
400,000
94% 12/31/2023 Completed653,611
350,802500,802Intelligent Transportation System
(ITS) Equipment
Upgrades/Replacement - FY
2021-2025
7511727 Upgrades to DOT Intelligent
Transportation System equipment
continued in the third quarter.

This project will continue in FY 2024.50,000
32% 6/30/2025 Ongoing112,057
312,144462,144Mobility Corridor Improvements
FY 2021-2025
7511828 Signal timing work and the Caltrans
I-210 Connector Corridors Project
continued in the third quarter.

This project will continue in FY 2024.50,000
97% 6/30/2025 Ongoing302,865
4,208,0004,208,000Walnut St Corridor Signal
Improvements
7512130 Design continued in the third quarter.Design will be completed in FY 2024.1,200,000 12% 12/31/2025 Design520,222
2,605,0002,605,000St. John Capacity Enhancement7512031 Construction contract was advertised in the third quarter.

Design will be completed and
construction will begin in FY 2024.
2,000,000
10% 12/31/2024 Construction255,591
3,800,0003,800,000Intelligent Transportation System
Projects & Traffic Flow
Improvements within the SR 710
Affected Corridors
7591432 Design continued in the third quarter.Design of signalized intersections along segments of Orange Grove
Blvd., Colorado Blvd., Green St., and
Hill Ave. will be completed in FY 2024.
400,000
2% 6/30/2027 Design69,305
990,000990,000Traffic Signal at Orange Grove
Blvd and Craig Ave
7509734 Design continued in the third quarter.Design will be completed in FY 2024.75,000 15% 12/31/2025 Design144,273
531,000531,000Traffic Signal at Orange Grove
Blvd and Sunnyslope Ave
7509935 This project was completed in the
first quarter.

Construction will be completed in FY
2024.
200,000
91% 12/31/2023 Completed481,015
851,350851,350Installation of Automated License
Plate Readers - Pilot Program
7511936 Construction continued in the third
quarter.

In FY 2024, installation of new ALPRs
on traffic signals at up to 13 additional
intersections will be completed.
631,350
22% N/A Construction185,425
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 10
PAGE 96
917,210917,210Installation of Pedestrian Hybrid
Beacon at Washington Blvd and
Hudson Ave
7551237 Design continued in the third quarter.Design will be completed in FY 2024.50,000 1% 6/30/2026 Design8,168
4,270,8005,711,908L Line Phase I - Project
Enhancements
7550638 Railroad Remote Monitoring Device
was installed in the third quarter.

Implementation of the Light Rail Train
Tracking and Network System (75517)
and analysis of traffic conditions at
Holly St. and Arroyo Pkwy. for
Pedestrian Access Enhancements to
Metro L Line Memorial Park Station
(75523) is anticipated to be completed
in FY 2024.
25,000
1% 6/30/2024 Ongoing35,029
2,500,0002,500,000Pasadena Light Rail Train (LRT)
Tracking and Network Monitoring
System - Phase II
7552445 No reportable activity in the third
quarter.

Project is pending execution of Metro
funding agreement.

The work plan for the project is under
development, pending the execution of
a Metro funding agreement for
Measure R MIP funding in FY 2024.
100,000
0% 6/30/2026 No Activity This
Quarter
0 2,087,7492,087,749Adaptive Traffic Control Network -
Phase II
7509552 This project was completed in the
second quarter. Signal timing an
operations changes were completed
in the third quarter.

Software updates at the Traffic
Management Center will be completed
in FY 2024.
0 92% 6/30/2024 Completed1,910,497
Transit
25,232,52126,042,493Purchase of Replacement Transit
Vehicles and Expansion Fixed-
Route Transit Vehicles
7508546 Procurement of all 12 vehicles was
completed in the third quarter and all
vehicles are in the pre-manufacturing
phase.

Eleven replacement renewable natural
gas (RNG) transit buses and one zero
emission bus were purchased in FY
2023 with anticipated delivery in FY
2024.
8,607,852
20% 6/30/2024 Ongoing5,137,615
2,170,2715,234,316Purchase of Dial-A-Ride Vehicles7508647 Vehicles are in the manufacturing phase with anticipated delivery in the
fourth quarter.

Two replacement vehicles and one
expansion vehicle were purchased in
FY 2023 with an anticipated delivery in
FY 2024.
399,021
44% 6/30/2024 Ongoing946,893
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 11
PAGE 97
68,460,00068,460,000Construction of Transit Operations
Maintenance Facility
7570748 Negotiations with contracted design
consultant to amend contract and
continue design of the facility
continued in the second quarter. City
finalized negotiations with owner of
neighboring parcel to purchase and
expand footprint of project and
entered into escrow in the third
quarter. Design contract amendment
to go to Council in the fourth quarter.

Design will continue in FY 20243,500,000
3% 6/30/2027 Design2,218,996
1,898,0934,332,093Bus Stop Improvement Program7590049 No reportable activity in the third quarter.

This is a continuing program. Projects
will be scheduled by City staff as
locations are identified.
300,000
19% N/A No Activity This
Quarter
356,806
20,500,00020,500,000Hydrogen Fueling Station7513350 Contract negotiations continued in the third quarter, with anticipated
contract award in the fourth quarter.

Conceptual design and outreach will
begin in FY 2024.
250,000
0% 6/30/2027 Ongoing32,210
Parking
3,000,00012,100,000Off-Street Parking Facility
Maintenance and Repair Project
721601 No reportable activity in the third
quarter.

Modernization of all elevators in the
Paseo, Marengo, Los Robles,
Schoolhouse, DeLacey, and Marriott
garages will begin in FY 2024.
1,500,000
50% 6/30/2032 No Activity This
Quarter
1,503,265
Sewers and Storm Drains
3,807,24024,100,000Annual Sewer System
Improvements and Capacity
Upgrades - FY 2022-2026
769181 FY 2022-2023 Annual Sewer
Relining continues and will include
for additional relining locations in the
fourth quarter. FY 2024-2025 Annual
Sewer Relining work is anticipated to
advertise in the fourth quarter.

Repair or rehabilitation of sewer will
continue in FY 2024 as identified by
annual inspection and evaluation.
500,000
52% 6/30/2026 Construction1,969,817
2,826,2937,326,293Annual Storm Drain System
Repair & Improvements - FY 2020
- 2024
769132 The FY 2024 workplan was
completed in the third quarter.

Various improvements to the City's
storm drain system will be prioritized
and implemented in FY 2024.
500,000
35% 6/30/2024 Completed992,312
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 12
PAGE 98
9,641,5519,641,551San Rafael Treatment Wetlands
and Storm Water Capture
762913 Work on the adoption of CEQA Initial
Study/Mitigated Negative Declaration
continued in the third quarter.

Anticipated for council approval in
the fourth quarter.

Construction will begin in FY 2024.1,000,000
14% 6/30/2025 Design1,397,533
2,900,0003,300,000Modernization of Busch Garden
and Rosemont Sewer Pump
Stations
769174 No reportable activity in the third
quarter.

Design will be completed in FY 2024.2,500,000
10% 12/19/2025 No Activity This
Quarter
290,820
2,970,0002,970,000NPDES Rio Hondo Bacteria Load
Reduction - Design Phase
762925 Design continued in the third quarter.Design of this project will continue in FY 2024 and is being managed by
San Gabriel Valley Council of
Governments.
500,000
24% N/A Design715,437
200,0001,000,000Civil Defense - Septic System
Upgrades
769196 Design continued in the third quarter.Design will be completed in FY 2024.50,000 28% 6/30/2026 Design55,835
900,000900,000NPDES - Storm Drain Master
Plan and Watershed Assessment
7691410 Consultant work for the GIS
implementation of citywide storm
drain system continued in the third
quarter.

The GIS build-out will be completed in
FY 2024.
83% 6/30/2024 Planning744,123
Rose Bowl Improvements
1,907,9852,465,757Brookside Golf Course &
Clubhouse Preventative
Maintenance FY 2020 - 2024
1 Project planning, design, repair, and
implementation continued in third
quarter.

Preventative maintenance to the golf
course, including repairs to bunkers,
tree trimming and maintenance,
miscellaneous concrete repairs, and
golf course equipment buyout, will
continue in FY 2024. Preventative
maintenance and improvements to the
clubhouse, including repairs and
upgrades to IT and utilities, will also
continue.
1,871,119
0% N/A Ongoing
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 13
PAGE 99
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
4,560,0005,925,000Rose Bowl Preventative
Maintenance FY 2020 - 2024
2 Repair and preventative
maintenance work continued in the
third quarter.

In FY 2024, the following repair and
preventative maintenance work will
continue: miscellaneous electrical
power repairs; repairs to stadium fiber
and IT; repair and/or replacement of
security cameras, magnetometer and
AV control room equipment; HVAC
and escalator/elevator equipment
repairs; stadium roof, plumbing,
concourse restroom, and concrete
spall repairs; flooring repairs and
replacements; repairs to thin profile
seats and backs; maintenance of the
videoboard; safety netting cleaning;
repairs to stadium perimeter gate and
bollard; repairs to stadium wayfinding
and signage; parking lot maintenance,
including asphalt and slurry repairs
and crack sealant; landscaping work,
including tree thinning and irrigation;
maintenance work for Stormwater
Pollution Prevention Plan state
compliance; and various repair work
and equipment replacement in the
Pavilion.
1,365,000
0% N/A Ongoing
April 8, 2024 Page 14
PAGE 100
17,180,37628,370,000Rose Bowl Major Improvement
Projects FY 2020 - 2024
3 Project planning, design, and
implementation continued in third
quarter.

In FY 2024, the following projects will
take place: electrical and information
technology upgrades and
improvements for stadium cameras,
stadium and campus fiber, sound
cables, and the broadcast and
audio/visual control room; stadium
exterior and concourse improvements,
including improvements to perimeter
pedestrian flow safety, remodeling of
concourse restrooms, replacement of
gas line, and north gate stage
improvement; field growth blankets;
inside stadium bowl improvements,
including a new speaker system at the
stadium and gates, and chairs, tables
and carts for minor events; pavilion
improvements, including upgrades to
the audio/visual and sound system,
exterior TVs and furnishing, and new
man door in overhead coiling door for
the loading dock; stadium statues; and
marquee refurbishment. Future project
studies and assessments will also
occur.
8,780,000
0% N/A Ongoing
Parks and Landscaping - Park Projects
4,208,4664,208,466Citywide Sports Facilities
Improvements and Installations
780441 Brenner Park Improvements project
construction completed in third
quarter.

Construction of improvements at
Brenner Park, and ADA public access
improvements from El Molino Ave. to
McKinley School courts, will be
completed in FY 2024.
500,000
98% 6/30/2024 Construction4,142,248
2,950,6005,850,600Central Park Improvements784612 Construction began in the third quarter.

Construction of the playground
improvements will be completed in FY
2024.
620,000
86% N/A Construction2,549,511
100,000100,000Brenner Park Playground
Improvements - Design Phase
782003 Public outreach began in the third
quarter.

Design will be completed in FY 2024.90,000
47% 6/30/2024 Design47,178
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 15
PAGE 101
1,065,0005,200,000Vina Vieja Pickleball Courts780864 Phase I construction contract was awarded by City Council on
December 11, 2023. Phase I
construction documents were
amended to include a third pickleball
court. Construction will begin in the
fourth quarter.

Phase I construction of two pickleball
courts and parking modifications will
be completed in FY 2024.
500,000
45% N/A Construction474,428
350,000350,000Hamilton Park Field
Improvements - Design Phase
780715 Planning and scoping phase
continued in the third quarter.

Design will be completed in FY 2024.300,000
7% 6/30/2024 Design23,990
750,000750,000Villa Parke Community Center -
ADA Improvements - Locker
Room and Parking Lot
780726 Construction contract bids received
in the third quarter, with anticipated
award in the fourth quarter.

Design of the ADA improvements will
be completed in FY 2024.
750,000
9% 6/30/2025 Ongoing69,198
600,0001,800,000Citywide Parks Playground Shade
Structure Installations - Phase I
780847 Construction contract awarded by
City Council on March 11, 2024.

Construction scheduled to begin in
the fourth quarter.

Design of shade structures at
McDonald Park, Victory Park, Vina
Vieja, and Washington Park, and
installation at Washington Park will be
completed in FY 2024.
600,000
1% 12/31/2024 Ongoing3,083
215,000215,000Central Park - Lawn Bowling
Clubhouse Retrofit - Design
Phase
780918 Project design continued in third
quarter, with scheduled completion in
the fourth quarter.

Design will be completed in FY 2024.200,000
10% 6/30/2024 Design22,404
6,116,0006,116,000Robinson Park - Pool and Pool
Building Renovations
7808512 This project was completed in the
second quarter. A ribbon cutting
ceremony was held on October 14,
2023.

Construction will be completed in FY
2024.
632,181
94% 12/31/2023 Completed5,719,352
3,295,0003,295,000Washington Park Community
House and Restroom -
Construction Phase
7808913 This project was completed in the
second quarter. A Ribbon cutting
ceremony was held on January 13,
2024.

Construction will be completed in FY
2024.
617,379
98% 12/31/2023 Completed3,230,299
Parks and Landscaping - Landscape Projects
618,3161,218,316Tree Replacement/Planting
Citywide - FY 2023-2027
789591 A total of 125 trees were planted in
the third quarter.

In FY 2024, 400 trees will be
purchased and planted.
200,000
44% 6/30/2024 Ongoing269,395
Arroyo Projects
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 16
PAGE 102
1,300,0001,300,000Brookside Park - Upgrade of
Athletic Field Lighting and
Backstop Replacement
773631 Construction continued in the third
quarter.

Construction will be completed in FY
2024.
1,253,064
60% 6/30/2024 Construction774,905
500,000500,000One Arroyo Project – Upper
Arroyo Trail Loop and Lower
Arroyo Trail Loop – Environmental
and Design Phase
773812 Design and environmental
documentation (mitigated negative
declaration) for Mayberry-Parker
Bridge scope continued in the third
quarter.

Environmental and design will be
completed in FY 2024.
400,000
35% 6/30/2024 Design173,841
375,0002,500,000One Arroyo Project – Upper
Arroyo Trail Loop and Lower
Arroyo Trail Loop – Construction
Phase
773823 Project advertised for construction
bids in the third quarter. Contract
award for construction is anticipated
to be awarded in the fourth quarter.

This project will begin after design
phase is completed under project
number 77381 and when funds are
identified.
0 0% N/A Ongoing0
1,622,9001,722,900Hahamongna - Implement Master
Plan - Oak Grove Area
Improvements
775064 Habitat maintenance, monitoring,
and reporting services continued in
the third quarter.

The five-year environmental and
habitat monitoring effort was started in
FY 2022 and will continue through FY
2026.
40,000
85% 6/30/2026 Ongoing1,371,930
938,8031,038,803Lower Arroyo Seco - Habitat
Restoration
774105 Habitat maintenance, monitoring,
and reporting services continued in
the third quarter.

The five-year environmental and
habitat monitoring effort began in FY
2022 and will continue through FY
2026.
40,000
99% 6/30/2026 Ongoing927,687
2,508,4722,608,472Implement Master Plan -
Hahamongna Watershed Park -
Berkshire Creek Area
Improvements
775096 Habitat maintenance, monitoring,
and reporting services continued in
the third quarter.

The five-year environmental and
habitat sustainability plan was started
in FY 2022 and will continue through
FY 2026.
40,000
99% 6/30/2026 Ongoing2,483,547
82,55082,550Central Arroyo - Recreational
Stairs - Concept Study
773837 No reportable activity this quarter.The concept study will be completed in FY 2024.
73,520
11% 6/30/2024 No Activity This
Quarter
9,030
120,000120,000Hahamongna Watershed Park -
Disc Golf Improvements
775178 Project was completed in the second
quarter.

Project will be completed in FY 2024.84,414
93% 6/30/2024 Completed111,263
Pasadena Center Improvements
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 17
PAGE 103
5,400,00012,900,000Restoration, Upgrades, and
Repairs of the Civic Auditorium,
Convention Center and Ice Rink
1 Construction began in the third
quarter.

In FY 2024, design for the restoration
of the exterior façade, exterior stairs,
roof, lower level interior spaces below
the plaza, and the Civic Auditorium
Plaza will begin. Staff is securing cost
for interior painting of the Civic.

General and emergency maintenance
will continue as needed.
2,500,000
0% N/A Construction
Water System
20,480,00037,980,000Distribution Mains10801 A total of 8,671 square feet of asphalt roadway and 1,247 square
feet of concrete roadway and
sidewalk were replaced in the third
quarter. Construction contracts for
Bellefontaine Street and Glenarm
Street main replacements and for
utility and miscellaneous street
improvements were awarded. In
addition, construction of the Avenue
64 main was completed and design
for future water main construction
continued.

In FY 2024, Avenue 64 (from
Glenullen Dr. to La Loma Rd.) will be
completed and Fair Oaks Ave. (from
Montana St. to Washington Blvd.) will
begin. Gate valve replacements will be
prioritized to support the unidirectional
flushing program.
5,227,520
84% 6/30/2024 Ongoing17,159,903
5,469,00065,368,200Sunset Reservoir Improvements10752 Efforts to complete a seismic retrofit study continued in the third quarter.

In addition, development of a letter of
interest for a federally funded Water
Infrastructure Finance and
Infrastructure Act (WIFIA) loan was
initiated.

In FY 2024, the design, environmental
review, and permitting will be
completed. In addition, project
contracting and construction
preparation will occur.
1,594,189
68% 6/30/2025 Design3,741,975
10,149,00011,079,000Well Improvements10743 Construction activities for the above grade improvements of the Garfield
Replacement Well project continued
in the third quarter. In addition, the
Department of Water Resources
accepted the Jourdan Well
destruction documents.

Construction of above-grade
improvements for Garfield
Replacement Well will be completed.

Other well abandonments and well
equipment replacements will occur as
required in FY 2024.
5,048,845
71% 6/30/2027 Construction7,207,720
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 18
PAGE 104
10,058,44121,938,441Arroyo Seco Canyon Project10404 Efforts to complete the design of the intake and diversion structure in Area
2 and the designs and permitting for
the headworks in Area 1 continued in
the third quarter.

In FY 2024, efforts will be made to
seek grant funding for the Arroyo Seco
Canyon Project and to finalize permits
with the Fish and Wildlife, the
Regional Water Quality Control Board,
and the US Army Corps of Engineers.

The conceptual design and
environmental documentation will be
completed in collaboration with Los
Angeles County and the Raymond
Basin Management Board for
additional infiltration of the expanded
spreading basins (Devil's Gate
Reservoir Pump Back).
367,560
64% 6/30/2026 Design6,467,975
6,670,0008,655,000Booster Improvements10735 Improvements at the Annandale Booster Station were completed in
the third quarter. In addition,
construction for the Ross Booster
Station upgrades were initiated.

Construction of Ross Booster Station
upgrades will continue and booster
pumps will be replaced as required in
FY 2024. The design of Eagle Rock
Booster Station upgrades will begin.
2,661,880
64% 6/30/2027 Construction4,295,936
7,075,00010,575,000Meters and Services10816 City crews replaced 500 small and 6 large meters, and renewed 8
services in the third quarter.

For FY 2025, the following installations
are planned:
- Small Meter Installations - $700 per
meter -1,200 meters - $840,000
- Large Meter Installations - $9,000
per meter - 50 meters - $450,000
- Domestic and Fire Service
Renewals - $12,000 per service - 24
services - $288,000
- Service Abandonments - $2,000 per
service - 5 services - $10,000
- Repair and Replace Vaults - $3,000
per vault - 4 vaults - $12,000
1,235,700
98% 6/30/2024 Ongoing6,931,615
2,290,0006,902,600Monk Hill Groundwater Treatment
Improvements
10767 The 30-day public review period and
final documents for the Explorer Well
Initial Study/Mitigated Negative
Declaration (ISMND) were
completed in the third quarter. Staff
is reviewing the Explorer Well final
design plans and specifications that
were prepared by the consultant.

Explorer Well design and
environmental compliance will be
completed in FY 2024. In addition,
drilling and below-grade improvement
construction will begin.
2,080,288
22% 6/30/2027 Design502,708
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 19
PAGE 105
1,230,0004,005,000New Water Well10888 No reportable activity in the third quarter.

In FY 2024, land acquisition for a new
well (Daisy Well) will be completed,
and preliminary design, permits, and
preparation of environmental
documents will begin. The new well
site will be shared with an Electric
Vehicle fast charging depot.
1,098,596
5% 6/30/2024 Planning63,348
2,610,0009,374,500Advanced Metering Infrastructure
(AMI)
10789 An AMI needs assessment kick-off
meeting was conducted in the third
quarter.

In FY 2024, project procurement will
begin for the program management,
AMI network, systems integration, and
meters.
2,504,088
0% 6/30/2027 Planning0
1,175,0003,342,200Customer Information System
Managed Services - Water
109610 Enhancements of the Customer
Information System continued in the
third quarter.

Additional CIS system enhancements
and upgrades will continue to add
benefits to PWP customers and staff in
FY 2024.
625,363
73% 6/30/2027 Ongoing861,797
325,000425,000Water SCADA Improvements108711 The enhancements to SCADA was implemented in the third quarter.

Enhanced SCADA communication
through radio, cellular, and fiber
systems will be completed in FY 2024.

In addition, software and server
upgrades will be conducted.
120,478
90% 6/30/2024 Ongoing292,134
1,205,0002,005,000Computerized Maintenance
Management System
108912 The Computerized Maintenance
Management System (CMMS)
selection committee completed the
final phase of the selection process
during the third quarter. Contract
awards are expected to be presented
to the City Council after preliminary
contract negotiations.

Proposal evaluations, solution
demonstrations, and final selection for
the Computerized Maintenance
Management System and the solution
implementer will begin in FY 2024.
682,028
28% 6/30/2027 Ongoing334,124
361,491431,491Field Services and Meter Reading
Automation
101213 No reportable activity in the third
quarter.

Purchase of new meter reading
hardware, software, and professional
services for the upgrade to Cloud
capability will begin in FY 2024.
71,470
34% 6/30/2027 No Activity This
Quarter
123,677
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 20
PAGE 106
642,000904,500Management Information Systems108314 The replacement for Cohesity Backup Appliance (data protection
solution) was completed in the third
quarter. PWP and DoIT staff are
examining an implementation
strategic plan for the VXRail
upgrade/expansion (data center
expansion).

Project work in FY 2024 includes
implementation of vulnerability
assessment recommendations, new
vulnerability scanner, inventory system
Cloud upgrade, security upgrades,
information technology data center
miscellaneous hardware and software,
and network equipment for switches
and firewalls.
278,733
46% 6/30/2027 Ongoing293,723
1,005,0001,250,000Geographic Information System
(GIS) Enhancements
108415 Data preparation for the migration to
the utility network continued in the
third quarter.

The ArcGIS upgrade will be completed
and the GIS Utility Network Upgrade
preparation and training will be
conducted in FY 2024.
684,070
16% 6/30/2027 Ongoing165,813
1,635,0002,405,000Emergency Generators - Water107916 The surge protector component at the Atlanta Booster Station tap box
was replaced after it was damaged
following a station outage.

Assessment, evaluation, and design
for stationary generators at booster
stations and well sites will be
completed in FY 2024.
127,625
95% 6/30/2027 Construction1,559,897
555,0001,055,000Water Operations / Training and
Storage / Work Shop
109017 Initial site work including grading,
driveway installation, and equipment
pad installation was conducted by
the Power business unit in the third
quarter.

Design of the Water
Operations Materials Storage Facility
will be completed in FY 2024.
163,360
5% 6/30/2024 Construction27,881
1,330,0002,840,000Reservoir Improvements109318 The kick-off meeting and site-visit with the consultant was conducted
for the Don Benito Reservoir
replacement project .

Design of Don Benito Reservoir will
begin in FY 2024. Other reservoir
improvements will be performed as
needed.
122,520
43% 6/30/2027 Planning573,326
8,302,67410,302,674Non-Potable Water Project101319 No reportable activity in the third quarter.

An evaluation of indirect potable reuse
options, including additional treatment
of the tertiary treated and disinfected
recycled water from the Los Angeles-
Glendale Water Reclamation Plant for
groundwater recharge, will be
completed in FY 2024.
153,150
94% 6/30/2027 No Activity This
Quarter
7,835,254
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 21
PAGE 107
8,073,00016,073,000Customer Driven - Mains, Meters,
and Services
108220 A total of 13 water service
applications with deposits, and 58
fire flow testing applications were
received from customers and
developers in the third quarter. There
were 10 installed projects which
include the following tasks: 9
domestic services, 4 fire services, 6
meters, 3 fire hydrants, and 3 service
abandonments.

Installations of new meters, services,
mains, fire hydrants, gate valves, and
services, including final paving of
trenches, will be completed in FY
2024.
2,042,000
78% 6/30/2024 Ongoing6,307,313
2,968,0462,968,046Water and Power Facilities
Modernization
105621 A contract was awarded and
executed for the construction of the
Locker Room Remodel Project in the
third quarter.

The locker room upgrades will be
completed in FY 2024.
648,000
78% 6/30/2027 Design2,315,065
245,000545,000Facilities Improvement Initiative109223 Procurement for a consultant to assess the landscape conversions
was completed in the third quarter.

Water facility conservation
assessments and plans will be
completed in FY 2024. A contractor will
be secured to develop and implement
landscape retrofits at facilities. In
addition, installation of leak detection
equipment on water service lines will
begin.
76,575
59% 6/30/2027 Planning145,186
Electric System
4,875,00010,075,000Conductor Replacement Program32261 The Belmont Circuit and Raymond Circuit Cable upgrade projects began
construction in the third quarter.

The cable replacement on the
Raymond Circuit will be completed in
FY 2024. In addition, other projects
may be competed as needed to
mitigate the risk of failure.
1,363,000
56% 6/30/2024 Ongoing2,746,442
10,337,57123,287,5714kV to 17kV Distribution System
Conversion Program
32272 Design work for conversions for F8,
F5, and B6 circuits continued in the
third quarter. In addition, the design
work for conversions of F4 and W2
circuits were initiated in the third
quarter.

The 4kV to 17kV conversions from
circuits F11 to Lincoln and F9 to
Belmont and Lincoln will be completed
in FY 2024. Additional conversion
projects may occur based on
operational needs or to prepare for
major developments.
4,000,000
27% 6/30/2024 Ongoing2,842,832
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 22
PAGE 108
13,786,35642,570,356Advanced Metering Infrastructure
(AMI)
31423 An AMI needs assessment kick-off
meeting was conducted in the third
quarter.

In FY 2024, project procurement will
begin for the program management,
AMI network, systems integration, and
meters.
12,963,080
2% 6/30/2027 Planning311,666
1,130,8001,630,800GT-5 Capital Equipment
Replacements
32804 Vendor outreach for the nitrogen
oxide (NOx) pump upgrade
continued in the third quarter.

However, suspected bearing failure
on GT-5 required the engine to be
removed for further inspection.

Upgrades to the GT-5 turbine nitrogen
oxide control equipment will be
completed in FY 2024. In addition, the
work plan includes miscellaneous
improvements on an as needed
basis.
1,130,800
49% 6/30/2028 Ongoing555,653
1,941,0003,200,000Subtransmission Cable Upgrade
(34-20)
32765 No reportable activity in the third
quarter; experiencing material
shipment delays.

In FY 2024, the 34-20 subtransmission
line upgrade between Santa Anita and
Chester substations will begin.
1,941,000
1% 6/30/2025 Design24,142
3,610,0003,610,000Subtransmission Cable Upgrade
(34-4)
32726 The replacement of the 34-4
subtransmission line was completed
in the third quarter.

The replacement for the 34-4
subtransmission line between
Glenarm and Chester substations will
be completed through existing
infrastructure in FY 2024.
1,106,000
88% 6/30/2024 Completed3,181,355
35,240,50335,640,503GT-1 and GT-2 Capital Equipment
Replacements
31827 No reportable activity in the third
quarter.

Planned work in FY 2024 includes the
Generator Step Up (GSU) transformer
containment, replacement of the
Selective Catalytic Reduction (SCR)
Catalyst on GT-1, painting of both
units, and if needed, GT-1 Ammonia
Continuous Emissions Monitoring
Systems (CEMS) Installation.
1,744,516
95% 6/30/2027 No Activity This
Quarter
33,320,227
7,645,3679,245,367GT-3 and GT-4 Capital Equipment
Replacements
31868 No reportable activity in the third
quarter.

Upgrades to the GT-3/4 Turbines and
the Balance of Plant (BOP) Control
System will be completed in FY 2024.

In addition, the work plan includes
installation of GT-3 Silencers, GT-3/4
Ammonia CEMS (if required by
AQMD), re-coating of the Cooling
Tower Basin, and
miscellaneous improvements on an
as-needed basis.
2,066,280
63% 6/30/2027 No Activity This
Quarter
4,833,436
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 23
PAGE 109
7,120,00014,920,000Electrical Vault Replacement and
Reinforcement Program
32299 Approximately 14 vault or pullbox
projects were completed in the third
quarter.

A total of 50 vaults and/or pullboxes
will be reinforced, replaced, or have
their frame/cover replaced in FY
2024.
1,911,000
48% 6/30/2024 Ongoing3,446,403
6,320,50012,320,500Distribution Switch Replacement
Program
323110 Four switches were replaced and
additional replacements are under
design.

A total of 17 distribution switches will
be replaced based on oil test results
and field evaluation in FY 2024.
1,448,000
89% 6/30/2024 Ongoing5,612,713
2,590,0004,690,000Fire Threat Mitigation Tier 2 Areas325811 Material for the El Mirador Fire Threat Mitigation project was
received in the third quarter.

Construction is expected to begin in
the fourth quarter.

Pole replacements and new
equipment will be installed along
Rosemont Ave, between Washington
Blvd, and N. Arroyo Blvd, within the
Tier 2 areas to mitigate the impact of
potential wildfires in FY 2024.
403,000
67% 6/30/2027 Ongoing1,740,298
3,174,7584,631,758Receiving Station 35kV Upgrades326212 The 35kV potential transformers for the Glenarm RSC South Bus were
upgraded in the third quarter. In
addition, the general engineering
services contract task order for 35kV
Circuit Breakers was initiated in the
third quarter.

The upgrade of five 35 kV Potential
Transformers will be completed in FY
2024.
301,000
68% 6/30/2027 Ongoing2,169,683
776,5004,776,500Energy Storage System Phase II327513 Work on the Initial Study Mitigated Negative Declaration (ISMND)
continued and hazardous survey
results were summarized and
recorded for future investigation
work.

Planned work in FY 2024 includes
permitting, environmental study,
development of specifications for a
RFP for major construction,
installation, and Owner's Engineer.
771,000
23% 6/30/2027 Planning179,059
2,950,0004,933,000Distribution Transformer
Replacement Program
323714 Approximately two transformers were
replaced in the third quarter.

A total of 10 transformers will be
replaced based on field inspection,
evaluation criteria, or a modeling
indication of overloading in FY 2024.
463,000
99% 6/30/2024 Ongoing2,929,972
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 24
PAGE 110
11,088,00019,088,000Electric Vehicle Charging
Infrastructure
322515 Construction of Victory Park and
Robinson Park EV supply equipment
project continued in the third quarter.

In addition, the design process for
installation of additional EV chargers
at Arroyo Depot was initiated.

Electric Vehicle (EV) charging stations
with both fast and Level 2 chargers at
Robinson Park, Victory Park,
Shoppers Lane, and a fire station will
be installed in FY 2024. Installation of
12 additional fast chargers at the
Arroyo EV Charging Depot and 20
more Level 2 chargers at the
Playhouse Park will be completed. In
addition, installation of Department of
Transportation electric services for two
electric bus fast chargers will be
completed. Land acquisition and
design for a new EV charging depot
that will be shared with the Water
division’s new water well site will
begin.
2,445,000
47% 6/30/2027 Ongoing5,266,199
3,675,0006,160,800Customer Information System
Managed Services - Power
327116 Enhancements of the Customer
Information System continued in the
third quarter.

Additional CIS system enhancements
and upgrades will continue to add
benefits to PWP customers and staff in
FY 2024.
1,169,350
44% 6/30/2027 Ongoing1,635,249
1,090,1244,612,124T.M. Goodrich Receiving Station
Upgrades
326317 The 34-6 power meter, 34-9 power
meter, and 34-6 circuit breaker
transfer trip upgrades were
completed in the third quarter. In
addition, the TMG Alarm Upgrades
and XFMR Bank 2 Dissolved Gas
Analysis (DGA) engineering designs
were initiated in the third quarter.

The installation and commissioning of
TM Goodrich Bank 2 Dissolved Gas
Analysis (DGA) system will be
completed in FY 2024. In addition, the
design, installation, and
commissioning of the 34-6 and 34-9
power meter upgrades will be
completed in FY 2024.
263,000
77% 6/30/2027 No Activity This
Quarter
837,068
327,5001,836,000Power Substation Weatherizing
Enhancements
327918 Improvements on the Del Mar
Substation roof were completed
during the third quarter.

Two substations will be weatherized in
FY 2024. Enhancements will include
protective weatherproof high-
temperature paint coating for eight
transformers and protective
rubberized/weatherproof coating for
two control room structures and four
metal clad switchgear.
352,000
30% 6/30/2028 Ongoing97,480
132,0002,349,372Oak Knoll Substation Upgrades327719 The design and specification for the Oak Knoll 35kV switch upgrades
were initiated in the third quarter.

The design and specification for Oak
Knoll 35kV switch upgrades will be
initiated in FY 2024.
132,000
2% 6/30/2027 Design2,629
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 25
PAGE 111
132,0002,349,372Villa Substation Upgrades327820 The design and specification for the Villa 35kV switch upgrades were
initiated in the third quarter.

The design and specification for Villa
35kV switch upgrades will be
completed in FY 2024.
132,000
2% 6/30/2027 Design2,629
5,650,00012,642,000Substation Modernization
Program
323521 The Eastern Unit 2, Hastings Unit 1,
Hastings Unit 2, Villa Unit 1, and Villa
Unit 2 transformer upgrades were
completed in the third quarter. In
addition, the material procurement
for the Chester Unit 1 transformer
upgrade was initiated.

The Villa Unit 1 substation
modernization featuring new metering
and capacitor bank controllers will be
completed in FY 2024. In addition, five
transformer health upgrades featuring
new nitrogen cabinets, load tap
changer oil filters, and load tap
changer desiccant filters will be
completed.
1,758,000
77% 6/30/2027 Ongoing4,341,091
4,188,2784,988,278Computerized Maintenance
Management System
314022 The Computerized Maintenance
Management System (CMMS)
selection committee completed the
final phase of the selection process
during the third quarter. Contract
awards are expected to be presented
to the City Council after preliminary
contract negotiations.

Proposal evaluations, solution
demonstrations, and final selection for
the Computerized Maintenance
Management System and the solution
implementer will begin in FY 2024.
1,926,000
39% 6/30/2027 Ongoing1,621,423
7,592,00012,192,000Emergency Transmission and
Distribution System
Replacements
322223 Ten emergency replacement projects
were completed in the third quarter.

Emergency replacements to
transmission, distribution, and
substation systems will be completed
on an as needed basis in FY 2024.
1,408,000
98% 6/30/2027 Ongoing7,435,500
18,518,00031,318,000Installation of Low Voltage
Electrical Services
322124 Approximately 67 residential and
commercial installation requests for
new service, modifications, and
upgrades from the public right of way
equal to 400 amps or below were
completed during the third quarter. In
addition, approximately 106 solar
connections were completed.

Modifications, upgrades, solar
installations, telecom, unmetered
service, or new low voltage electric
service will be installed as requested
in FY 2024. Installation of service
conductors to provide electrical
service will be installed, as needed.
3,118,000
96% 6/30/2027 Ongoing17,741,873
16,343,00026,943,000Installation of High Voltage
Electrical Services
322025 Approximately three private property
electric service installations in
response to customer requests for
new service, modifications, and
upgrades higher than 400 amps of
service were completed during the
third quarter.

Modifications, upgrades or new high
voltage electric services will be
completed as requested in FY 2024.

Installation of cables, conduits,
switches, transformers, and meters will
be installed as necessary.
2,616,000
93% 6/30/2027 Ongoing15,177,035
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 26
PAGE 112
1,065,0006,287,500Supervisory Control and Data
Acquisition (SCADA) System
Expansion
324526 The design and specification for the
Connex 30 substation gateway and
Jungle-Mux fiber optic multiplexer
upgrades were initiated in the third
quarter.

The design and specifications for the
Connex 30 substation gateways and
Jungle Mux fiber optic multiplexer
upgrades will begin in FY 2024.
263,000
43% 6/30/2024 Design460,599
1,350,0004,850,000Primary Dispatch Facility
Remodel
325327 No reportable activity in the third
quarter.

A technical evaluation of the South
Wall power and controls equipment
will be completed in FY 2024. In
addition, a design package for
equipment removal and/or relocation
will be initiated.
328,000
8% 6/30/2027 Planning112,658
855,00014,862,500Fair Oaks Substation Upgrades326728 Task order work associated with a general engineering services
contract continued for the Fair Oaks /
Brookside Substation major
materials .

The design and specifications of a
new unit substation for Fair Oaks
Substation will continue in FY 2024.
285,000
12% 6/30/2027 Ongoing104,165
160,000560,000Replacement of Power Plant
Instruments and Controls
323229 No reportable activity in the third
quarter.

Procurement of instruments and
controls at the Glenarm Power Plant
will occur on an as-needed basis in FY
2024.
102,800
1% 6/30/2024 No Activity This
Quarter
2,280
6,070,55612,670,556Deteriorated Pole Replacement
Program
323330 Four poles were replaced in the third
quarter. In addition, seven joint poles
were replaced through Southern
California Joint Pole Committee
(SCJPC) coordination.

A total of 60 utility poles will be
replaced based on inspection and
evaluation criteria in FY 2024. In
addition, funds are required to cover
Southern California Joint Pole
Committee charges that account for
joint pole work performed by other
utilities.
1,559,000
88% 6/30/2027 Ongoing5,339,630
2,744,3203,144,320Power Production Facility
Improvements
323631 A specification for replacing 13
CAISO meters for the RIG
replacement project was prepared in
the third quarter. In addition, the
purchase of a new trailer was
approved by Council.

Work planned for FY 2024 includes:
installation of a perimeter wall at
Azusa; Remote Intelligent Gateway
(RIG) improvements to allow
communication between the units and
the California Independent System
Operator (CAISO); physical security
improvements; and miscellaneous
facility improvements on an as-needed
basis.
899,500
39% 6/30/2025 Ongoing1,069,627
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 27
PAGE 113
2,910,0004,310,000Seismic Upgrade of Power
Facilities
319632 The design for the Del Mar
Substation seismic upgrade was
finalized in the third quarter. In
addition, construction contracts were
awarded for the Brookside
Substation and Oak Knoll Substation
seismic upgrade projects.

Construction of the seismic upgrade of
the Del Mar substation will be
completed in FY 2024.
302,000
59% 6/30/2024 Ongoing1,718,991
700,0001,508,000Vault Cover Lid Replacement
Program
323033 Approximately 13 blast resistant
vault covers were installed in the
third quarter.

Installation of restraint system and lid
enhancement for 15 vault/manhole
covers will be completed in FY 2024.
202,000
55% 6/30/2027 Ongoing382,422
450,0002,450,000Fire Threat Mitigation Tier 3 Areas325734 Work on the overhead and the underground portions of the fire
threat mitigation design for Canyon
Close Rd. continued in the third
quarter.

Designs for the civil and electrical
systems for converting the high
voltage distribution line on Canyon
Close Rd and Fox Ridge Dr to
underground utilities will be completed
in FY 2024.
40,000
55% 6/30/2025 Design248,216
4,470,0006,154,000Santa Anita 35kV Receiving
Station Upgrades
326035 The construction drawings and relay
settings files were distributed to field
personnel for the North and South
circuit breakers in the third quarter.

The 34-20, 34-23, 34-27, 34-28, North
Tie, and South Tie protection and
control upgrades for the Santa Anita
35 kV circuit breakers will be
completed in FY 2024.
882,000
68% 6/30/2027 Ongoing3,035,230
5,915,0016,915,001Distribution System Automation319236 The final substructure design modifications were made for the
installation of the City Hall Automatic
Transfer Switch (ATS) in the third
quarter. In addition, coordination and
outreach for installation was initiated.

One Supervisory Control and Data
Acquisition (SCADA) connected
Resettable Fault Interrupter (RFI) on
the Waverly Circuit and one Automatic
Transfer Switch (ATS) for City Hall to
provide a backup power source will be
installed in FY 2024.
402,000
83% 6/30/2024 Construction4,901,016
1,170,0001,570,000Security, Access Control, and
Lighting Program at Power
Facilities
324837 Construction began for Santa Anita
Substation security upgrades in the
third quarter. In addition, design work
for security upgrades at the City
yards was finalized.

Construction of security, access
control, and lighting for the Fair Oaks
substation will be completed in FY
2024.
151,000
15% 6/30/2027 Construction174,112
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 28
PAGE 114
546,521946,521Distribution System GIS
Enhancements
324638 No reportable activity in the third
quarter.

A GIS mobile solution and related
forms/applications to facilitate field
inspections of assets and customer
facilities will be completed in FY 2024.

In addition, the GIS will continue to be
enhanced to meet operational needs.
100,000
6% 6/30/2024 No Activity This
Quarter
34,957
6,995,5288,195,528Distribution System Expansion
Program
322839 No reportable activity in the third
quarter as the workplan was
completed in the second quarter.

Staff is reviewing the project
expenditures and will take
appropriate action to address the
project imbalance.

Design and installation of the new
underground cable that will make up
the new Paloma Circuit out of
Hastings Substation will be completed
in FY 2024. In addition, field ties will
be constructed, with the neighboring
17kV circuits, to provide backup
support to Hastings Substation.

Underground infrastructure for
customer related projects will be
enhanced and expanded.
503,000
104% 6/30/2024 Ongoing7,268,175
1,810,0003,810,000Customer Facility Replacements326940 Design work to replace eight outdated protective devices at
various customer facilities was
initiated in the third quarter.

A total of 10 units will be replaced
based on field recommendation and
resource availability in FY 2024.
606,000
52% 6/30/2027 No Activity This
Quarter
948,351
545,0001,145,000Fiber Optic Cable Expansions /
Overbuilds
324441 No reportable activity in the third
quarter.

The installation of overhead and
underground fiber-optic cables along
El Mirador from Colorado Blvd. up to
El Mirador Tower on Glen Oaks Blvd.
will be completed in FY 2024. In
addition, work in coordination with
Department of Technology to complete
fiber projects to meet PWP operational
and system needs will continue.
151,000
28% 6/30/2024 No Activity This
Quarter
152,594
1,541,0001,996,000Geographic Information System
(GIS) Enhancements
324042 Data preparation for the migration to
the utility network continued in the
third quarter.

The ArcGIS upgrade will be completed
and the GIS Utility Network Upgrade
preparation and training will be
conducted in FY 2024.
1,213,040
9% 6/30/2027 Ongoing137,720
607,463737,463Field Services and Meter Reading
Automation
302543 No reportable activity in the third
quarter.

Purchase of new meter reading
hardware, software, and professional
services for the upgrade to Cloud
capability will begin in FY 2024.
133,640
51% 6/30/2027 No Activity This
Quarter
310,007
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 29
PAGE 115
1,380,0007,380,000Energy Storage System Phase I320644 Staff inspected two battery energy storage system project sites (New
Mexico and Palm Springs), finalized
internal technical review, and
completed the vendor selection
process. In addition, review of the
Initial Study Mitigated Negative
Declaration (ISMND) was initiated.

Planned work in FY 2024 includes
permitting, environmental study, and
development of specifications for
Requests for Proposal (RFP) for major
construction, installation, and owner's
engineer.
709,320
17% 6/30/2025 Planning237,475
870,0005,966,000Station Transformer Upgrades325945 One proposal received in response to the Mobile Transformer request for
bid was reviewed and evaluated
during the third quarter.

The vendor selection and procurement
contract for the Mobile Transformer
and Mobile Transformer Station
Upgrades will be issued in FY 2024. In
addition, the design and specification
for the Mobile Transformer Housing
Upgrades will be completed, the
vendor selected, and the procurement
contract will be issued.
353,000
39% 6/30/2027 Design340,203
1,755,8472,981,347Power System Equipment325446 Specifications for a 10,000 pound forklift were finalized and scheduled
for advertisement in the third quarter.

In addition, a Megger TTRU3 three
phase transformer turns ratiometer
was ordered and construction
machinery/equipment was received.

Major tools and test equipment will be
purchased upon field evaluation in FY
2024.
604,000
71% 6/30/2027 Ongoing1,251,107
1,946,6033,074,603Santa Anita 17kV Substation
Upgrades
326147 The engineering design for the Santa
Anita Bank 4 Transformer Controller
upgrade was initiated in the third
quarter.

The Santa Anita Bank 4 Transformer
Controller upgrade will be completed
in FY 2024. The upgraded controller
will monitor transformer temperature
and performance, control radiator
fans, and provide real-time updates to
the Power SCADA system.
290,000
74% 6/30/2027 Ongoing1,445,086
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 30
PAGE 116
1,593,0003,073,000Distribution Volt/Var
Enhancements Program
325248 Construction of a voltage correction
project on Marianna Rd. was
completed in the third quarter.

A switch capacitor bank solution will
be installed to alleviate low voltage
problems in the system in FY 2024.

Voltage correction projects will occur
when determined by recorded voltage
abnormalities or when customers
request connection or upgrade of a
service connection. In addition,
communication functionality to the
battery units installed on the C-1
Circuit will be completed.
402,000
93% 6/30/2024 Ongoing1,473,763
5,306,3527,579,352Substation Oil Containment312849 Construction contracts were awarded for the Oak Knoll Substation Oil
Containment and Wilson Substation
Oil Containment projects. In addition,
construction was completed to
address the oil containment system
at Chester Substation.

In FY 2024, a new oil containment
system for the Wilson, Oak Knoll, and
Villa substations will be constructed. In
addition, the design of a new oil
containment system for the Chester
substation will be completed and the
design of a new oil containment
system for Glenarm Units 1 and 2 will
be initiated.
925,000
69% 6/30/2027 Ongoing3,671,027
19,939,28219,939,282Water and Power Facilities
Modernization
317550 A contract was awarded and
executed for the construction of the
Locker Room Remodel Project in the
third quarter.

The locker room upgrades will be
completed in FY 2024.
1,177,000
91% 6/30/2027 Design18,059,933
1,920,0007,358,400Glenarm Receiving Station
Upgrades
326651 The completed LA Line Load
Shedding Motor Actuator and GT-1 /
GT-2 circuit breakers were received
in the third quarter.

The protection and control upgrades
for the GT-1 and GT-2 circuit breakers
will be completed in FY 2024. In
addition, the design and specifications
for Glenarm RSC and RSD 35kV
protection and control upgrades for
mini lines (34-31, 34-32, 34-4, 34-7,
34-8, and 34-3), major lines (34-15,
34-16, 34-24, and 34-25), and radial
lines (34-1, 34-2, 34-13, and 34-14)
will be initiated.
748,000
45% 6/30/2027 Ongoing868,237
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 31
PAGE 117
3,942,0004,342,000Transmission System
Enhancements
319552 Efforts continued on the Southern
California Edison draft letter
agreement to replace one of the
220kV disconnects and upgrade the
protection equipment for the TMG -
Gould 220kV Transmission Line at
TM Goodrich Receiving Station.

In FY 2024, an aging communication
device, RFL 6780 transmitter/receiver,
will be replaced. In addition, other
transmission equipment may be
replaced or upgraded per the
inspection results and
recommendations of Southern
California Edison.
101,000
84% 6/30/2027 Ongoing3,311,548
610,000615,000PWP Training Yard327453 Initial site work, including grading, driveway installation, and equipment
pad installation, was conducted in
the third quarter.

Environmental remediation will begin
in FY 2024.
251,000
21% 6/30/2027 Construction127,644
1,000,0002,000,000Power Supply Integrated
Resource Planning and Design
324954 No reportable activity in the third
quarter.

Staff is reviewing the project
expenditures and will take
appropriate action to address the
project imbalance.

Work on the 2023 IRP will continue
with stakeholder meetings in FY 2024.

The 2023 IRP will be completed and
approved by City Council by
December 31, 2023.
205,600
119% 6/30/2025 No Activity This
Quarter
1,194,308
1,159,0001,646,500Management Information Systems323955 The replacement for Cohesity Backup Appliance (data protection
solution), was completed in the third
quarter. PWP and DoIT staff are
examining an implementation
strategic plan for the VXRail
upgrade/expansion (data center
expansion).

Project work in FY 2024 includes
implementation of vulnerability
assessment recommendations, new
vulnerability scanner, inventory system
cloud upgrade, security upgrades,
information technology data center
miscellaneous hardware and software,
and network equipment for switches
and firewalls.
521,196
50% 6/30/2024 Ongoing575,719
1,073,0001,873,000Power Transmission Program325156 LADWP is the operating agent for this project. In the third quarter,
activity included continued work on
the following projects: 480V Breaker
Replacement, HVAC System
upgrade, Fire Protection System
Replacement, and Replacement of 3
IGS Towers.

The following work will take place in
FY 2024: continued work on the
replacement of the 480 V breaker at
Sylmar Converter Station (SCS);
removal of Old Ground System;
replacement of 3 IGS Towers; air
conditioning unit replacement for
Converter 1 & 2 Valve Halls; Phase 2
of the Fire Protection System
Replacement; and various smaller
capital projects.
443,799
21% 6/30/2024 6/30/2027 Ongoing221,258
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 32
PAGE 118
9,428,9999,478,999Power Transmission Program319057 LADWP is the operating agent for this project. In the third quarter,
activity included continued work on
the following projects: AC/DC Filter
Replacements and Porcelain
Insulator replacement.

Work will continue on the Sylmar
AC/DC Filter Replacement project and
SCS Fire Protection System
Replacement-Construction Phase 1
project in FY 2024. The Porcelain
Insulators Replacement project will
continue and is projected to be
complete in December 2024. The
Reactor Bushing Replacement project
is expected to be completed in FY
2024.
297,082
95% 6/30/2027 Ongoing8,969,069
463,0005,663,000Power Facility Wastewater /
Storm Water Capture and
Treatment
327058 Stormwater treatment/management
feasibility study procurement
continued in the third quarter. Staff
continued to monitor and follow best
practices under the Wastewater
permit.

Work planned for FY 2024 includes
the completion of a study to determine
the most cost-effective option for
managing chemical constituents in
stormwater; replacement of the oily
water separator, and addressing any
needs of storm and wastewater
treatment, storage, recycling, and
disposal facilities at the Power Plant.
305,600
0% 6/30/2027 Ongoing0
490,0004,816,000Chester Substation Upgrades327359 The design and specification for the Chester 35kV switch upgrades was
initiated in the third quarter.

The design and specifications for the
Chester 35kV switch upgrades will be
completed in FY 2024.
285,000
8% 6/30/2027 Design38,860
792,9001,192,900Power Supply Facility Security323460 No reportable activity in the third quarter.

In FY 2024, procurement and
installation of new and/or improved
security systems with a focus on
Glenarm Plant will continue, and work
on Broadway and Azusa Hydroelectric
Plants will be performed on an as-
needed basis.
308,400
53% 6/30/2024 No Activity This
Quarter
420,315
Technology Projects
3,550,0003,550,000Police Computer-Aided Dispatch
and Records Management
System Replacement
711681 Data migration was completed in the
third quarter.

Implementation of additional systems
and historical data migration will be
completed in FY 2024.
765,600
76% 6/30/2024 Ongoing2,707,112
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 33
PAGE 119
8,212,2318,212,231DoIT Equipment Lifecycle
Replacement FY 2020 - FY 2024
711652 Network and server infrastructure
equipment and software updates
continued as part of planned lifecycle
replacements. The PBX replacement
project continued with the
replacement of the Contact Center
(Call Center) technology completed
in the third quarter. Phone migrations
to Teams Phones also continued and
are expected to be completed in
2025.

Annual system life cycle replacement
of hardware and software will continue
in FY 2024.
1,100,000
39% 6/30/2024 Ongoing3,193,740
3,126,3673,126,367Enterprise Building Security
Management
711633 Security enhancements at the Jackie
Robinson Community Center and
additional door work in the lobby of
the Jefferson Elementary site were
completed in the third quarter.

Work will continue at various branch
library locations, and potentially
expand to other City facilities in FY
2024.
500,000
78% 6/30/2024 Construction2,432,673
2,596,6533,536,653City Fiber Network Expansion FY
2020 - FY 2024
711674 The first phase of the fiber
connection to the Mirador Radio
Tower project was completed,
development of the Strategic
Broadband Plan continued in the
third quarter.

Fiber expansion plans along South
Lake Ave. will continue in FY 2024.

Additionally, fiber expansion to the
Mirador Reservoir and Radio Tower
will begin and is expected to be
completed in FY 2024.
450,000
49% 9/30/2024 Ongoing1,268,339
1,500,0001,500,000City Park Public Wifi Expansion711695 Preliminary designs were finalized the third quarter, and review/approval
thereof is expected to be completed
by the end of the fourth quarter.

Implementation is scheduled to
commence in the second quarter of
FY 2025.

Implementation and construction will
begin in FY 2024 following design
finalization.
500,000
0% 6/30/2024 Design0
800,7912,000,000Enterprise Content Management
System
711516 After analysis of the original proof of
concept, it was determined that
further review of the security
surrounding the architectural design,
compliance and retention policies,
and search features of the proposed
solution is needed. This review is
expected to be completed in the
fourth quarter with implementation to
commence following acceptance of
the proposed solution.

Upgrade of the existing system will
take place in FY 2024 to support future
capabilities and expanded use to
support any department needs.
45,000
91% 6/30/2024 Ongoing725,365
Capital Improvement Program
FY 2024 Quarter Monitoring Report
Activity Through March 31, 2024
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2024
FY 2024
Anticipated
Expenditures Status UpdateFY 2024 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
April 8, 2024 Page 34
PAGE 120

Finance CommitteeMay 6, 2024

Finance Committee
May 6, 2024