Agenda — Finance Committee, January 10, 2022

AGENDA

FINANCE COMMITTEE

SPECIAL MEETING NOTICE
JANUARY 10, 2022
PUBLIC MEETING 3:30 P.M.

M
embers
Victor M. Gordo, Mayor
Felicia Williams, District 2
John J. Kennedy, District 3
Andy Wilson, District 7
S
TAFF
Matthew Hawkesworth, Director of Finance
Theresa Fuentes, 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 Act of 1990, Assistive Listening Devices are available from the City Clerk’s Office with a 24-hour advance notice.

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

Language t
ranslation services are available for this meeting by calling (626)744-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.

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

I
tems 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/ Materials 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”

PURSUANT TO EXECUTIVE ORDER N-29-20 ISSUED BY GOVERNOR GAVIN NEWSOM ON MARCH 17, 2020, THE SPECIAL FINANCE COMMITTEE MEETING JANUARY 10, 2022 AT 3:30 P.M. WILL TAKE PLACE SOLELY BY VIDEOCONFERENCE/TELECONFERENCE.

TO
ACCESS THE MEETING:
htt
p://pasadena.granicus.com/MediaPlayer.php?publish_id=9
AND
WW
W.PASADENAMEDIA.ORG
In or
der to facilitate public participation at meetings held solely by electronic means, the City will accept public comment in the following manner:

1. During the meeting, members of the public may provide live 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
After submitting a public speaker card, join the virtual meeting at the published start time with a computer, other electronic device, or by telephone. The same name or telephone number on the Speaker Card must be used for the virtual meeting in order to locate and unmute the speaker.

Computer or electronic devices, join the meeting at:
https://us02web.zoom.us/j/161482446

Telephone only dial-in: 1-669-900-6833, Meeting ID: 161 482 446

2. 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 legislative body prior to the start of the meeting.

3. If assistance is needed by phone, please call the City Clerk's Office at:
(626) 744-4124.

IF Y

OU NEED A REASONABLE MODIFICATION OR ACCOMMODATION

PURSUANT TO THE AMERICANS WITH DISABILITIES ACT

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

OFFICE OF THE MAYOR

CITY OF PASADENA

NOTICE OF SPECIAL MEETING

OF THE FINANCE COMMITTEE
JANUARY 10, 2022
PUBLIC MEETING: 3:30 P.M.

PASADENA CITY HALL, COUNCIL CHAMBER
100 NORTH GARFIELD AVENUE, ROOM S249
Note to the Public: City Hall is closed to the public until further notice.

NOTICE IS HEREBY GIVEN that the regular meeting of the Finance Committee that would have been scheduled for Monday, January 10, 2022 at 4:00 p.m. is now taking place at 3:30 p.m. by videoconference/teleconference to discuss matters on the attached agenda.

This virtual meeting is held pursuant to Executive Order N-29-20 issued by Governor Gavin Newsom.

HEREBY CERTIFY that this notice, in its entirety, was posted on the Internet at www.cityofpasadena.neUcommissions/city-council-finance-committee and on the Council Chamber Bulletin Board, Room S249 and the Bulletin Board in the rotunda area, City Hall, 100 North Garfield Avenue, this 6th day of January, 2022, by 5:30 p.m., and that copies hereof were faxed, emailed or delivered to each member of the City Council and to each local newspaper of general circulation, radio or television station requesting notice in writing, all of which recipients are identified on the distribution list set forth herein below.

DISTRIBUTION:

City Council
City Manager
City Attorney
Public Information Officer
Los Angeles Times
Pasadena Independent
La Opinion
Pasadena Journal
Pasadena Now
Pasadena Star News
Pasadena Weekly
Conversation Live
In compliance with the Americans with Disabilities Act of 1990, listening assistive devices are available from the City Clerk's Office with a 24-hour advance notice.

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

Language translation services may be requested with 24-hour advance notice.

Habra servicio de interpretaci6n disponible para estas juntas 1/amando al (626) 744-4124 par lo menos con 24 horas de anticipaci6n.

SPECIAL MEETING
AGENDA

FINANCE COMMITTEE
JANUARY 10, 2022
Public Meeting: 3:30 P.M.

Council Chamber, Pasadena City Hall
100 North Garfield Avenue, Room S249
PUBLIC MEETING - 3:30 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
December 13, 20
21 Special Meeting
December 27, 2021 Cancellation Notice

NEW BUSINESS

1. AUTHORIZAT

ION TO ENTER INTO A CONTRACT WITH PFM FINANCIAL

ADVISORS LLC FOR INDEPENDENT REGISTERED MUNICIPAL ADVISOR

FOR THE WATER AND POWER DEPARTMENT FOR A PERIOD OF THREE

YEARS, WITH TWO OPTIONAL ONE YEAR EXTENSIONS FOR A TOTAL AMOUNT NOT TO EXCEED $250,000

2. RECOGNIZE AND APPROPRIATE $260,650 TO THE DEPARTMENT OF PUBLIC HEALTH’S FISCAL YEAR 2022 OPERATING BUDGET RELATED TO THREE NEW GRANTS; ADD 3.25 LIMITED-TERM GRANT FUNDED FTEs

3. APPROVAL T
O AMEND THE CITY’S 457(B) DEFERRED COMPENSATION

PLAN TO ALLOW FOR IN-PLAN ROTH CONVERSIONS

INFORMATION ONLY

4. FINANCIAL UPDATE JANUARY 2022

ADJOURN

Page 1 ends

APPROVAL OF MINUTES
• DECEMBER 13, 2021 SPECIAL MEETING
• DECEMBER 27, 2021 CANCELLATION NOTICE

Page 2 ends

December 13, 2021
Special Finance/Audit Committee

Page 1 of 4 ends

Special Meeting Minutes

FINANCE/AUDIT COMMITTEE
Monday, December 13, 2021 ▪ 3:00 p.m.

Videoconference/Teleconference Council Chambers Room S249, Pasadena City Hall

A. CALL TO ORDER: The special meeting of the Finance/Audit Committee was called to order at 3:02 p.m. with Mayor Gordo, Vice Mayor Wilson, and Councilmembers Kennedy and Williams

Attendees (Absent as indicated):

Councilmembers Staff
Mayor Gordo, Chair
Andy Wilson
John Kennedy
Felicia Williams
Matthew Hawkesworth
Theresa Fuentes
Timothy Park
Kris Markarian
Jim Wong
Ruthe Holden
Rebecca Takahashi
Jennifer Curtis

Byanca Banaga
Flora Karmiryan
Sarkis Garabedian
Tony Olmos
Phyllis Hallowell
Laura Rubio-Cornejo
Alex Hernandez
Randy Mabson
Anne Lansing

Recording Secretary: Gloria Acevedo

B. PUBLIC COMMENT- None

C. APPROVAL OF MINUTES

 November 22, 2021 Special Meeting

The minutes were approved as submitted.

D. NEW BUSINESS

1. RECOGNIZE AND APPROPRIATE $957,024 IN EMERGENCY HOUSING VOUCHER (EHV) FUNDING TO THE HOUSING DEPARTMENT’S FISCAL YEAR 2022 OPERATING BUDGET; ADD A LIMITED-TERM 1.0 FTE CITY SERVICE WORKER POSITION; AND APPROVE THE TEMPORARY POLICY SUPPLEMENT

Mayor Gordo introduced the item.

Vice Mayor Wilson asked for clarification that the limited term FTE position is different from the FTE mentioned in the next agenda item. Jim Wong, Senior Project Manager, responded that the Housing Department has two action items

Page 3 ends

December 13, 2021
Special Finance/Audit Committee

Page 2 of 4 ends

on the agenda and each is asking for an individual grant funded FTE City Service Worker.

The Finance/Audit Committee approved forwarding this report to the full City Council.

2. RECOGNIZE AND APPROPRIATE $150,000 OF HOME INVESTMENT

PARTNERSHIP ACT-AMERICAN RESCUE PLAN FUNDS TO THE HOUSING DEPARTMENT’S FISCAL YEAR 2022 OPERATING BUDGET; ADD A LIMITED-TERM

1.0 FTE PROGRAM COORDINATOR I POSITION

Mayor Gordo introduced the item.

The Finance/Audit Committee approved forwarding this report to the full City Council.

3. ANNUAL ADJUSTMENTS TO THE FISCAL YEAR 2022 SCHEDULE OF TAXES, FEES, AND CHARGES RELATED TO NEW YEAR’S DAY AND THE ROSE BOWL

Mayor Gordo introduced the item and reminded the Finance/Audit Committee that the changes do not apply to this year’s Rose Parade and Game rather they become effective next year.

Vice Mayor Wilson asked for confirmation that these fees are done outside the annual budget adoption. Matthew Hawkesworth, Director of Finance, added that the municipal code states that the fees are to be adopted in December and become effective on February 1, 2022.

The Finance/Audit Committee approved forwarding this report to the full City Council.

4. AMENDMENTS TO THE FISCAL YEAR 2022 GENERAL FEE SCHEDULE

Mayor Gordo introduced the item; the fees are related to the Capital Price Indexes.

Vice Mayor Wilson asked why the action was being taken off the scheduled annual fee adjustment time schedule. Matthew Hawkesworth, Director of Finance, responded that the action is the result of the State of California raising the fees on January 1, 2022.

The Finance/Audit Committee approved forwarding this report to the full City Council.

E. INFORMATION ONLY

5. AUDIT OF THE CITY’S ETHICS POLICIES AND PROCESSES

Page 4 ends

December 13, 2021
Special Finance/Audit Committee

Page 3 of 4 ends

Mayor Gordo introduced the item. Rebecca Takahashi, Senior Internal Auditor, presented a PowerPoint presentation outlining employee perception of the City’s ethics climate, the strength of internal controls related to ethics, and benchmarking policies and procedures against best practices.

Vice Mayor Wilson asked for clarification on who was in charge of notifying Statement of Economic Interest (Form 700) filers when the filing is due. Ms.

Takahashi responded that Mark Jomsky, City Clerk, is responsible for sending out the notices. Mayor Gordo added the function of the City Clerk is to make sure the filing is completed, not the review of the content and reminded the public that Form 700 reveals all financial interests for elected officials and certain appointed positons within the City. Vice Mayor Wilson also asked if there were any known conflicts as consequences to the lack of best practices. Jennifer Curtis, Director of Human Resources, indicated there are no known issues and clarified that Human Resources focuses on the outside employment forms. If an employee indicates, they have an outside employment, that employee’s form is routed to their Director for approval. There is a plan for better tracking, reporting, and follow-up in 2022.

Mayor Gordo asked staff for their recommendation on how to remedy the concerns identified in the audit. Ms. Takahashi responded that the audit findings recommend for the City Manager to form an ad-hoc review committee that includes the City Clerk, City Attorney, and the Human Resources Departments to discuss the violations and how to address them.

The Finance/Audit Committee acknowledged receiving the report.

6. MITIGATION FEE ACT ANNUAL REPORTS

Mayor Gordo introduced the item as a receive and file report.

Matthew Hawkesworth, Director of Finance, stated there were no anomalies; the report is created to comply with state requirements.

Vice Mayor Wilson asked for the balance of the unallocated current project balance related to the residential impact fees. Mr. Hawkesworth will provide the information.

The Finance/Audit Committee acknowledged receiving the report.

7. FINANCIAL UPDATE- COVID-19 EXPENDITURES

Matthew Hawkesworth, Director of Finance, provided a PowerPoint Presentation outlining the current COVID-19 expenditures.

Page 5 ends

December 13, 2021
Special Finance/Audit Committee

Page 4 of 4 ends

Vice Mayor Wilson asked for an explanation of the $4.9 million spent on COVID- 19 sick leave. Mr. Hawkesworth stated the expenditure was a result of a federal mandate under the CARES Act mandating cities to provide up to 80 hours of COVID-19 sick leave to eligible employees, they were for a specific period of time that expired in early 2021, and they were not eligible for reimbursement. The $4.9 million represents hours used and paid.

Mayor Gordo inquired when staff would be submitting reimbursement requests for all the projects. Mr. Hawkesworth responded that reimbursement requests have been submitted for projects that have closed and it will take up to 18- months for reimbursements. Since the state is still operating under a declared state of emergency the City continues to accrue expenses, the typical timeline for total reimbursement is two-years after the incident.

The Finance/Audit Committee acknowledged receiving the report.

F. ADJOURN

With no further business to come before the Finance/Audit Committee, the meeting adjourned at 3:34 p.m.

_________________________________
Victor M. Gordo Date
Chair, Finance/Audit Committee

_________________________________
ATTEST: Gloria Acevedo, Date
Recording Secretary

Page 6 ends

Page 7 ends

NEW BUSINESS

1. AUTHORIZATION TO ENTER INTO A CONTRACT WITH

PFM FINANCIAL ADVISORS LLC FOR INDEPENDENT

REGISTERED MUNICIPAL ADVISOR FOR THE WATER

AND POWER

DEPARTMENT FOR A PERIOD OF THREE

YEARS, WITH TWO OPTIONAL ONE YEAR EXTENSIONS

FOR A TOTAL AMOUNT NOT
TO EXCEED $250,000

Page 8 ends

Agenda Report
TO: Honorable Mayor and City Council
THROUGH: Finance Committee
FROM: Water and Power Department
January 10, 2022
SUBJECT: AUTHORIZATION TO ENTER INTO A CONTRACT WITH PFM

FINANCIAL ADVISORS LLC FOR INDEPENDENT REGISTERED

MUNICIPAL ADVISOR SERVICES FOR THE WATER AND POWER

DEPARTMENT FOR A PERIOD OF THREE YEARS, WITH TWO

OPTIONAL ONE YEAR EXTENSIONS FOR A TOTAL AMOUNT NOT
TO EXCEED $250,000
RECOMMENDATION:

It is recommended that the City Council:

1. Find that the proposed action is not a project subject to the California Environmental Quality Act (CEQA) pursuant to Section 21065 of CEQA and Sections 15060(c)(2), 15060(c)(3), and 15378 of the State CEQA Guidelines and, as such, no environmental document pursuant to CEQA is required for the project; and

2. Authorize the City Manager to enter into a contract, as the result of a competitive selection process, as specified by Section 4.08.047 of the Pasadena Municipal Code, with PFM Financial Advisors LLC for three years in an amount not to exceed $150,000 with two optional one-year extensions not to exceed $50,000 each, subject to the approval of the City Manager. Competitive bidding is not required pursuant to City Charter Section 1002(F) ( contracts for professional or unique services).

BACKGROUND:

The Water and Power Department ("PWP") is responsible for the operations and activities of the City of Pasadena's ("City") Electric System and Water System ("System" or collectively, "Systems"), which provide electric and water services to nearly all customers within the City limits and water service to some customers outside the City limits.

MEETING OF _____ _ AGENDA ITEM NO. ____ _

Page 9 ends

Award and Contract with PFM Financial Advisors LLC
January 10, 2022

Page 2 of 4 ends

PWP requires the services of an Independent Registered Municipal Advisor ("IRMA") to act as an objective financial advisor and economic market expert to provide advice and assistance on existing and new debt issuances, financing structures, and timing of debt issuance; including but not limited to pricing, call provision options, and rating agency strategy. The IRMA is also expected to provide support services to coordinate the administration and issuance of debt. The services include communication with rating agencies, coordination with bond and tax counsel in advance of securities offerings to ensure acceptance of the financing structure and to deliver an unqualified opinion and tax certificate, and assist in negotiations with bond insurers and/or letter of credit providers. These services require an IRMA to perform as a fiduciary with the required registrations and certifications of the Securities and Exchange Commission and the Municipal Securities Rulemaking Board.

Furthermore, the IRMA is expected to provide continuing updates and advice on the impact of current or proposed state or federal legislation and market conditions that could affect PWP's financial plans, identify options that balance varying priorities and risks, and perform other financial advisory services as needed including advising PWP on debt refunding opportunities.

REQUEST FOR PROPOSALS AND PROPOSAL EVALUATION
On August 4, 2021, PWP issued a Request for Proposals ("RFP") for Independent Registered Municipal Advisor services which was posted on PlanetBids. To support the participation of Pasadena businesses, staff sent email communications to over 100 Pasadena businesses whose PlanetBids registration profiles most closely matched the scope of work in the RFP. The direct communications ensured that local businesses were notified about the solicitation and provided them with the opportunity to contact the city with any detailed questions about the City's procurement procedures. • On July 27, 2021, staff sent emails to over 100 Pasadena businesses with general information of the scope of work from the RFP in advance of the formal issuance.
• On August 3, 2021, an additional email communication was sent to Pasadena businesses to announce the formal issuance of the solicitation. • On August 5, 2021, a third email communication was sent to Pasadena businesses to confirm that the RFP had been officially issued.

Fifteen prospective proposers downloaded the RFP, none of which were located in Pasadena. Despite the additional outreach, no Pasadena businesses responded to the RFP. The deadline for RFP submissions was August 26, 2021.

Three qualified professional firms responded and submitted proposals by the August 26, 2021 deadline:

1. Public Financial Management ("PFM") Financial Advisors LLC, Los Angeles, CA

2. Public Resources Advisory Group ("PRAG"), Los Angeles, CA

3. Fieldman, Rolapp & Associates, Inc. ("Fieldman"), Irvine, CA

Page 10 ends

Award and Contract with PFM Financial Advisors LLC
January 10, 2022

Page 3 of 4 ends

The proposals were evaluated by a panel of four staff members from PWP and the Department of Finance based on the specific criteria stated in the RFP. The scoring for all the responding firms is provided in the following table:

Max Point Averaae Score
Evaluation Criteria per Criteria PFM PRAG ,.Fieldman
Total 100 87.25 85.76 69.56
PWP conducted follow-up interviews with the two highest scoring firms and determined that PFM provided a broader range of relevant experience and access to more extensive services and staff. Based upon the scoring of the responses to the RFP and the results of the interview process, staff is recommending the award of an IRMA contract to PFM.

It is recommended that PFM be awarded a contract in an amount not to exceed $150,000 for an initial period of three years with two optional one-year extensions not to exceed $50,000 per year subject to the approval of the City Manager. The amount is based on an estimated 150 service hours per year, although the actual hours in a given year may vary based on specific needs for support. The service hours would cover advisory activities not related directly to bond transactions and would be used only as needed for specific services rendered. Fees related directly to bond issuances will be assessed separately and included in the cost of issuance for the transaction. PFM has no prior contracts with the City of Pasadena. The Finance and Administration division of PWP will be responsible for managing the contract and will review all invoices for services provided by PFM to ensure completion of work and accuracy of the invoices.

The proposed contact fully complies with the Competitive Bidding and Purchasing Ordinance P.M.C. 4.08 and the rules and regulations promulgated thereunder. The proposed contract will be managed by staff in the PWP Finance and Administration Division.

COUNCIL POLICY CONSIDERATION:

This action supports the City Council's strategic goal to maintain fiscal responsibility and stability.

ENVIRONMENTAL ANALYSIS:

The proposed contract for an independent financial advisor and economic market expert to provide advice and assistance on existing and new debt issuances to PWP is an administrative action that would not cause either a direct physical change in the environment or a reasonably foreseeable indirect physical change in the environment.

Therefore, the proposed action is not a "project" subject to CEQA, as defined in Section 21065 of CEQA and Section 15378 of the State CEQA Guidelines. Since the action is not a project subject to CEQA, no environmental document is required.

Page 11 ends

Award and Contract with PFM Financial Advisors LLC
January 10, 2022

Page 4 of 4 ends

FISCAL IMPACT:

The total cost of this action, including the two optional extensions, is $250,000 over a five-year term. This amount includes $150,000 for the initial three-year term, and $50,000 for each one year extension for a total maximum contract cost of $250,000.

Funding for this action will be addressed by the utilization of current and future year budgeted appropriations in Water Operating Fund (Account 42107980-811500) and Power Operating Fund (Account 42109230-811500).

Contract Amount -Initial Three Year Term $150,000
Water-Acct 42107980-811500 $ 52 ,500
Power - Acct 42109230-811 800 $ 97,500
Initial Term Total $150,000
Two optional one year extensions ($50,000 oer vear) $100,000 Water - Acct 42107980-811500
Power -Acct 42109230-8118 00
Two one-year extensions Total
Total Fiscal Impact for Five Years
Prepared by:
��
Shari M. Thomas
Assistant General Manager
Water and Power Department
Approved by:

Interim City Manager
Attachments: ( 1)
Attachment A: Criteria Scoring Summary
$ 35,000
' $ 65,000
$100,000
$250,000
Respectfully submitted,
GURCHARAN S. BAWA
General Manager
Water and Power Department
Concurred by:

Director of Finance
Department of Finance

Page 12 ends

Attachment A

Page 13 ends

Pasadena Water and Power

AUTHORIZE A CONTRACT WITH PFM

FINANCIAL ADVISORS LLC FOR

INDEPENDENT REGISTERED MUNICIPAL

ADVISOR SERVICES
Finance Committee Item 1
City Council Item xx
January 10, 2022

Page 14 ends

Pasadena Water and Power
Recommendation
• CEQA Exemption - State CEQA Guidelines 15060(c)(2)
and 15060(c)(3)
• Authorize the City Manager to enter into a contract with PFM Financial
Advisors LLC (“PFM”)
 $150,000 for initial three-year term
• Two opti
onal one-year extensi ons for $50,000 per
year
• Total maximum contract amount would be $250,000
 Result of competitive selection process per PMC

4.08.047
2

Page 15 ends

Pasadena Water and Power
3 Support to PWP
• Independent Advisory Services for PWP in multiple
areas:
Existing and new debt issuances
• Financing Structures
• Timing of issuances
• Refunding opportunities
Communication with Rating Agencies
Coordination with Bond and Tax counsel
Updates on current and proposed state or federal legislation and market conditions
Registered and in good standing with the SEC and MSRB

Page 16 ends

Pasadena Water and Power
4 Contractor Selection
• Request For Proposals
 RFP issued in August 2021
 Posted on the City's website through Planetbids
In accordance with the applicable provisions of the
Pasadena Municipal Code
 Email notifications directly to 100 Pasadena firms
Local firms did not choose to respond
 Three responsive proposals were received
 PWP interviewed the two highest scoring firms
 PFM obtained highest cumulative score

Page 17 ends

Pasadena Water and Power
RFP Evaluation Results
Vendor/Respondent Company Location
City and State
Evaluated Score
(Out of 100)
PFM Financial Advisors, LLC Los Angeles, CA 87.25
Public Resources Advisory
Group (PRAG) Los Angeles, CA 85.76
Fieldman, Rolapp & Associates,
Inc. Irvine, CA 69.56
5

Page 18 ends

4.08.047
6

Page 19 ends

NEW BUSINESS

2. RECOGNIZE AND APPROPRIATE $260,650 TO THE
DEPARTMENT OF PUBLIC HEALTH’S FISCAL YEAR
2022 OPERATING BUDGET RELATED TO THREE NEW
GRANTS; ADD 3.25 LIMITED-TERM GRANT FUNDED FTEs

Page 20 ends

PA^b^0
^^^ <<^
7 0
•(( *
<0 z
00 0CO 0
'-?>^ ^^ 0y 'f^EO
Agenda Report
January 10,2022
TO: Honorable Mayor and City Council
THROUGH: Finance Committee (January 10, 2022)
FROM:Public Health Department
SUBJECT: RECOGNIZE AND APPROPRIATE $260,650 TO THE DEPARTMENT OF PUBLIC HEALTH'S FISCAL YEAR 2022 OPERATING BUDGET
RELATED TO THREE NEW GRANTS; ADD 3.25 LIMITED-TERM
GRANT FUNDED FTEs
RECOMMENDATION:

It is recommended that the City Council:
j
;
I

2. Amend the Department of Public Health's Fiscal Year (FY) 2022 Operating Budget by recognizing and appropriating $260,650 for three new grants:

California Department of Public Health - Children and Youth with Special Health Care Needs (CYSHCN) Innovation Grant ($117,015), California Department of Public Health - California Equitable Recovery Initiative ($58,635), and L.A. Care Health Plan - COVID-19 Vaccine Incentive Grant ($85,000); and

3. Amend the Department of Public Health's Fiscal Year (FY) 2022 Operating Budget by adding 3.25 Full-Time Equivalents (FTE), limited-term, grant funded positions: 1.0 FTE Program Coordinator I, 1.25 FTE Community Service Representative II, and 1.0 FTE Community Service Representative III.

MEETING OF.AGENDA ITEM NO.

Page 21 ends

Amendments to Fiscal Year 2022 Adopted Operating Budget January 10, 2022

Page 2 of 4 ends

BACKGROUND:

Throughout the fiscal year, budget amendments are necessary to account for unanticipated changes to the adopted budget. These revenue and appropriation amendments are presented to the City Council for consideration. This Agenda Report includes proposed amendments to the FY 2022 Operating Budget as adopted by the City Council on June 21, 2021. The proposed budget amendments are a result of grants awarded to the Public Health Department after adoption of the budget.

Pasadena Public Health Department (PPHD) recommends recognizing revenue and appropriating $260,650 in the Public Health Fund (203) for three grants. This will support an additional 3.25 limited-term FTEs and program related expenses. The details are as follows:
a. California Department of Public Health - Children and Youth with Special Health Care Needs (CYSHCN) Innovation Grant
The Department recommends recognizing revenue and appropriating $117,015 to the Public Health Fund in FY 2022. Secondly, the PPHD recommends adding

2.0 FTE limited-term, grant-funded positions at a total cost of $69,871 through June 30, 2022, which will support a 1.0 FTE Program Coordinator I and a

1.0 FTE Community Service Representative II. The remaining $47,144 is requested to support the purchase of supplies, training, and consultant services.

The California Department of Public Health CYSHCN grant will: 1) Provide system navigation support and linkages to healthcare services, social services, and other peer-to-peer support and mentoring services for children and youth with special health care needs; 2) Support transition of youth into the adult health care system; and 3) Promote family health information networks that increase collaboration between agencies and parents. The total grant award is $969,620 and the remaining $852,605 will be presented to City Council through the annual budget development process in future fiscal years to support program activities through June 30, 2025.
b. California Department of Public Health - California Equitable Recover/ Initiative The Department recommends recognizing revenue and appropriating $58,635 to the Public Health Fund. Secondly, the PPHD recommends adding a 1.0 FTE limited-term, grant funded Community Services Representative III at a total cost of $41,534 through June 30, 2022. The remaining $17,101 is requested to support the purchase of program supplies and services. The funding is provided by the Centers of Disease Control and Prevention (CDC), as a pass-through grant from the California Department of Public Health (CDPH). The purpose of the California Equitable Recovery Initiative grant is to address COVID-19 and advance health equity for disproportionately impacted racial and ethnic groups, rural populations, those experiencing socioeconomic disparities, and other underserved within state and local health jurisdictions The total grant award is $200,000 and the remaining $141,365 will be presented to City Council through the annual budget development process for next fiscal year to support program activities through May 31, 2023.

Page 22 ends

Amendments to Fiscal Year 2022 Adopted Operating Budget January 10, 2022

Page 3 of 4 ends

c. L.A. Care Health Plan - COVID-19 Vaccine Incentive Grant The Department recommends recognizing revenue and appropriating $85,000 to the Public Health Fund. The funding is provided by the L.A. Care Health Plan.

The purpose of this grant is to increase COVID-19 vaccinations for L.A. Care members living in Pasadena, prioritizing communities that have disproportionately been affected by COVID-19 and have lower vaccinations, such as African Americans and Latinx communities. Funding will support portions of existing authorized staff as well as outreach strategies which include social media ads, user generated video contests, and promotora (i.e. community health worker) supported canvassing and pop-up vaccine clinics. The grant funding term is October 1, 2021 to February 28, 2022.
d. Los Angeles County Development Authority - Lead Free Homes Program The Department recommends modifying an existing limited-term position associated with this grant, which is already budgeted in the FY 2022 Operating Budget. The modification entails reclassifying an existing Work Experience Aide to a Community Services Representative II in order to better align with the grant's needs, as well as increasing the position from 0.75 FTE to 1.0 FTE. The requested change will result in a projected $33,000 in cost for salaries and benefits but no additional appropriations are requested at this time because there is sufficient grant revenue and appropriations in the FY 2022 Budget to support the requested modification. Funded by the Los Angeles County Development Authority (LACDA), the Lead Free Homes grant will fund outreach and enrollment of owners and tenants in a lead remediation program for residential structures built before 1951 that are home to children under age 6, pregnant women, or properties frequently visited by children under age 6. The grant will fund outreach and enrollment activities in Northwest Pasadena and segments ofAltadena, East Pasadena, and Monrovia.

COUNCIL POLICY CONSIDERATION:

The City Council's strategic planning goal of maintaining fiscal responsibility and stability will be advanced by monitoring the FY 2022 Adopted Operating Budget and by implementing necessary budget amendments.

ENVIRONMENTAL ANALYSIS:

The action proposed herein is not subject to the California Environmental Quality Act (CEQA) in accordance with Section 21065 of CEQA and State CEQA Guidelines Sections 15060 (c)(2), 15060 (c)(3), and 15378. The amendment of the Department of Public Health's budget is a government fiscal activity that does not involve any commitment to any specific project which may result in a potentially significant physical impact on the environment. Therefore, the proposed action is not a "project" subject to CEQA, as defined in Section 21065 of CEQA and Section 15378 of the State CEQA Guidelines. Since the action is not a project subject to CEQA, no environmental document is required.

Page 23 ends

Amendments to Fiscal Year 2022 Adopted Operating Budget January 10, 2022

Page 4 of 4 ends

FISCAL IMPACT:

Approval of the recommended action will amend the Department of Public Health's FY 2022 Operating Budget by recognizing revenue and appropriating $260,650 of grant funding to the Health Fund (203). This action will also add 3.25 limited-term grant- funded FTEs. Remaining grant funding will be included in the annual budget submission in future years. No net impact to the unappropriated fund balance is anticipated.

Respectfully submitted,
YING-YII^3/30H, MD, MSHS
Director ^Public Health & Health Officer
Department of Public Health
Prepared by:
^
Manuer'Safmona
Deputy Director
Department of Public Health
Approved by:

T^
3 KURTZ
Interim City Manager

Page 24 ends

Public Health Department
RECOGNIZE AND APPROPRIATE $260,650

TO THE DEPARTMENT OF PUBLIC
HEALTH’S FISCAL YEAR 2022 OPERATING

BUDGET RELATED TO THREE NEW
GRANTS; ADD 3.25 LIMITED-TERM GRANT
FUNDED FTEs
Finance Committee Item 2
Pasadena City Council Item No. 14
January 10, 2022

Page 25 ends

Public Health Department
• California Department of Public Health grant
award of $969,620
• Program component
s
• System navigation support
• Linkages to health, social, and other support services • Mentoring for chil
dren and youth with special health care
needs
• Support transition of youth
into the adult health care system
• Promote family health informati on networks that increase collaboration between agencies and parents
2 Children and Youth with Special Health Care
Needs (CYSHCN)

Page 26 ends

Public Health Department
Children and Youth with Special Health Care
Needs (CYSHCN)
• Requested appropriations of $117,015 in FY 2022
• Increase personnel allocation by 2.0 FT E
• 1.0 FTE Program Coordinator I
• 1.0 FTE Community Service Representative II
• Projected Expenses
• Personnel Costs $69,871
• Supplies, training, and consultant services $47,144
• Remaining $852,605 will be presented through
annual budget development process in f
uture
fiscal years through June 2025
3

Page 27 ends

Public Health Department
California Equitable Recovery Initiative
• California Equitable Recovery Initiative
• Centers of Disease Control and Prevention (CDC) through the California D
epartment of Public Health (CDPH)
• Total grant award of $200,000
• Program Goal
• Advance health equity for di sproportionately impacted racial and ethnic groups, rural populations, those
experiencing socioeconomic disparities, and other
underserved within state and local health jurisdictions. 4

Page 28 ends

Public Health Department
• Requested appropriations of $58,635 in FY 2022
• Increase PPHD personnel allocation by 1.0 FTE
• 1.0 FTE Community Service Representative III
• Projected Expenses
• Personnel Costs $41,534
• Program supplies and services $17,101
• Remaining $141,365 will be presented through
annual budget
development process for next
fiscal year to support program activities through
May 2023
5 California Equitable Recovery Initiative

Page 29 ends

Public Health Department
COVID-19 Vaccine Incentive Grant
• L.A. Care Health Plan grant award of $85,000
• P
rogram Components
• Increase COVID-19 vaccinati ons for L.A. Care
members living in Pasadena
• Focus on communities that have disproportionately
been affected by COVI
D-19 and have lower vaccination
rates
• Support outreach strategies such as social media, user generated video contests, and promotora (i.e.
community health worker) supported canvassing and
pop-up vaccine clinics
6

Page 30 ends

Public Health Department
COVID-19 Vaccine Incentive Grant
• Requested appropriations of $85,000 in FY 2022
• Projected Expenses
• Contracted Services $20,000
• Other Costs $65,000
• No new personnel requested
7

Page 31 ends

Public Health Department
Lead Free Homes Program
• Los Angeles County Development Authority (LACDA)
program launched t
his fiscal year
• Program Components
• Outreach and enrollment of owners and tenants in a
lead remediation program
for eligible residential
structures
 Built before 1951
 Home to children under age 6, pregnant women, or properties frequently visi
ted by children under age 6
 Located in LACDA eligible areas including Northwest
Pasadena and segments of
Altadena, East Pasadena, and
Monrovia
8

Page 32 ends

Public Health Department
Lead Free Homes Program
• Request reclassification of an existing position
• Reclassify from Work Experience Aide to Community
Services Represent
ative II
• Increase position from 0.75 FTE to 1.0 FTE
• Sufficient appropriations are available in the department operating budget to support t
he requested changes
9

Page 33 ends

Public Health Department
Staff Recommendations
It is recommended that the City Council:
1) Find that the proposed action is not a project subject to the California Environmental Qual
ity Act (CEQA) pursuant to Section 21065 of
CEQA and State CEQA Guidelines Sections 15060(c)(2),
15060(c)(3), and 15378, and, as such no environmental document pursuant to CEQA is required for the project; and
2) Amend the Department of Public Health’s Fiscal Year (FY) 2022 Operating Budget by
recognizing and appropriating $260,650 for
three new grants: California Department of Public Health – Children and Youth with Special Health Care Needs (CYSHCN) Innovation Grant ($117,015), California Department of Public Health – California Equitable Recovery Initiative ($58,635), and L.A. Care Health Plan – COVID-19 Vaccine Incentive Grant ($85,000); and
10

Page 34 ends

Public Health Department
Staff Recommendations
It is recommended that the City Council (continued):
3) Amend the Department of Public Health’s Fiscal Year (FY) 2022 Operating Budget by
adding 3.25 Full-Time Equivalents (FTE),
limited-term, grant funded positions: 1.0 FTE Program Coordinator I,

1.25 FTE Community Service Representative II, and 1.0 FTE Community Service Representative III.
11

Page 35 ends

NEW BUSINESS

3. APPROVAL TO AMEND THE CITY’S 457(B) DEFERRED

COMPENSATION PLAN TO ALLOW FOR IN-PLAN ROTH

CONVERSIONS

Page 36 ends

Page 37 ends

Page 38 ends

457(b) Deferred Compensation Plan
to allow for In-plan Roth Conversions
Matthew Hawkesworth
Director of Finance
January 10, 2022
Finance Committee Item 3 City Council Item XX

Page 39 ends

In-Plan Roth Conversions
• The City’s 457(b) Deferred Compensation plan
already accepts Roth (
post-tax) contributions.
• The proposed amendment would allow
participants to conver
t existing pre-tax funds to
Roth funds; therefore, assuming the tax liability
at the time of conversion rather than at the
time of withdrawal.
2

Page 40 ends

In-Plan Roth Conversions
• The proposed change came forward at the
request of some active pl
an participants.
• The proposed amendment was reviewed by
the Deferred Com
pensation Committee at their
August and November 2021 meetings and
unanimously supported the change.
• There is no financial risk to the City in
approving this plan
amendment.
3

Page 41 ends

Recommendation
• Find the proposed action is exempt from
CEQA.
• Authorize t
he Finance Director/Plan
Administrator
to sign the necessary form
documents with Empower Retirement to allow
In-Plan Roth Conversions.
4

Page 42 ends

INFORMATION ONLY

4. FINANCIAL UPDATE JANUARY 2022

Page 43 ends

TO:

FROM:

SUBJECT:

DEPARTMENT OF FINANCE
January 10, 2022
Cynthia J. Kurtz
Interim City Manager
-�Matthew E. Hawkeswort�
Director of Finance
Financial Update January 2022
This update provides details on key revenue and expenditure data through the first-half of the fiscal year.

Property Tax payments, which are primarily made up of first-half payments from November and the unsecured payments, are in line with the budgeted forecast.

Payments for secured property tax for the first-half of the year totaled $25.1 million, which is an increase of $1.0 million from the same period last year. This revenue is not reflected in the actuals in Attachment A as the bulk of it was received in December 2021. With the Consumer Price Index (CPI) continuing to be well above 2.0% year-over year, the forecast for Fiscal Year (FY) 2023 will include CPI growth at the maximum property tax rate at 2.0% plus additional growth from real estate transactions of an additional 2-3%.

Sales Tax revenue realized continued recovery_as compared to the prior year. While some tax revenue from online sales retailers dipped slightly, it was more than made up from year-over-year growth at local brick and mortar locations. Despite supply chain challenges, new auto sales continue to be robust and many of the City's larger retailers have recovered well. While the loss of some businesses such as Sears will hurt revenue in the short-term, many of the closures were anticipated and considered in the future forecasts. If sales tax revenue, both the regular Bradley Burns 1.0% and the local Measure I, remain resilient, actual revenue may come in $2-3 million higher than budgeted for FY 2022.

Transient Occupancy Tax (TOT) has improved since the prior year and monthly TOT is in line with the budgeted estimates. While total TOT revenue will still be well below pre pandemic levels, it will likely double compared to FY 2021. Monthly TOT is averaging more than $1 million per month, which is a positive sign, especially in light of the fact that the Constance Hotel remains closed thereby reducing the City's available inventory.

Additionally, December saw the return of large conferences at the Pasadena Center Operating Company, which provides an instant boost to both occupancy and average

Page 44 ends

Page 45 ends

Page 46 ends

City of Pasadena
Revenue
By Fund
November 2021
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 101 - General Fund $276,734,693 $81,278,961 $195,455,732 29.37% $271,955,551 $67,431,649 $204,523,902 24.80% $279,131,116 $70,293,125 $208,837,991 25.18% 71 - Taxes $188,661,000 $45,069,328 $143,591,672 23.89% $181,802,468 $36,965,402 $144,837,066 20.33% $193,331,680 $39,855,205 $153,476,475 20.61% 72 - Franchise Fees $2,754,000 $952,615 $1,801,385 34.59% $2,939,000 $929,199 $2,009,801 31.62% $2,804,000 $908,680 $1,895,320 32.41% 73 - Licenses And Permit $4,553,027 $1,986,267 $2,566,760 43.63% $4,568,380 $1,181,290 $3,387,090 25.86% $3,374,205 $1,531,791 $1,842,414 45.40% 74 - Intergov Revenue $22,524,230 $1,111,043 $21,413,187 4.93% $22,456,121 $313,117 $22,143,004 1.39% $23,801,215 $270,077 $23,531,138 1.13% 75 - Charge For Srvcs Ext $13,470,851 $6,584,592 $6,886,259 48.88% $13,716,433 $4,236,830 $9,479,603 30.89% $12,424,500 $4,432,026 $7,992,475 35.67% 76 - Charge For Svc Quasi $14,463,797 $5,988,832 $8,474,965 41.41% $14,815,390 $6,133,934 $8,681,455 41.40% $14,763,662 $6,120,274 $8,643,388 41.45% 77 - Operat Transfer In $19,757,388 $14,472,174 $5,285,214 73.25% $19,866,264 $14,906,560 $4,959,705 75.03% $20,140,438 $14,886,535 $5,253,904 73.91% 78 - Fine And Forfeiture $7,174,500 $3,246,636 $3,927,864 45.25% $7,373,000 $921,859 $6,451,141 12.50% $4,752,500 $1,394,714 $3,357,786 29.35% 79 - Investment Earnings $1,028,875 $775,614 $253,261 75.38% $1,272,101 $359,469 $912,632 28.26% $720,712 $28,707 $692,005 3.98% 80 - Rental Income $733,531 $195,550 $537,981 26.66% $491,900 $212,563 $279,337 43.21% $461,210 $228,204 $233,006 49.48% 81 - Misc. Revenue $1,588,494 $896,310 $692,184 56.43% $1,587,994 $900,897 $687,097 56.73% $1,490,494 $591,469 $899,025 39.68% 82 - Other Fincng Source 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income ($0) ($0) ($0) 0.00% $1,050,000 $370,528 $679,473 35.29% $1,050,000 $45,445 $1,004,555 4.33% 84 - Non-Op Revenue $25,000 ($0) $25,000 0.00% $16,500 ($0) $16,500 0.00% $16,500 ($0) $16,500 0.00% 102 - Parking Operations Fund $28,493 $11,506 $16,987 40.38% $27,620 $11,506 $16,114 41.66% $27,620 $11,506 $16,114 41.66% 73 - Licenses And Permit ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 75 - Charge For Srvcs Ext ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In $27,620 $11,506 $16,114 41.66% $27,620 $11,506 $16,114 41.66% $27,620 $11,506 $16,114 41.66% 79 - Investment Earnings $873 ($0) $873 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 104 - L. A. Impact Fund $78,319 $6,703 $71,616 8.56% $78,910 $9,460 $69,450 11.99% $74,999 $5,544 $69,455 7.39% 74 - Intergov Revenue $74,999 $6,352 $68,647 8.47% $74,999 $9,484 $65,515 12.65% $74,999 $5,544 $69,455 7.39% 79 - Investment Earnings $3,320 ($38) $3,358 -1.13% $3,911 ($24) $3,935 -0.62% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue ($0) $389 ($389) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 105 - General Fund Projects Fund $6,048,802 $5,268,682 $780,120 87.10% $6,515,000 $5,658,397 $856,603 86.85% $5,770,723 $3,567,120 $2,203,604 61.81% 73 - Licenses And Permit ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 74 - Intergov Revenue ($0) ($0) ($0) 0.00% ($0) $1,788,383 ($1,788,383) 0.00% ($0) $31,825 ($31,825) 0.00% 75 - Charge For Srvcs Ext $5,941,977 $5,268,682 $673,295 88.67% $5,928,350 $3,283,364 $2,644,986 55.38% $5,770,723 $3,535,295 $2,235,429 61.26% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% $586,650 $586,650 ($0) 100.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $106,825 ($0) $106,825 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 80 - Rental Income 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% Created on 12/23/2021 Page 1 of 10

Page 47 ends

City of Pasadena
Revenue
By Fund
November 2021
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 106 - New Years Day Genl Fund Events $1,603,603 $704,061 $899,542 43.90% $328,000 $271,356 $56,644 82.73% $1,623,000 $588,082 $1,034,918 36.23% 71 - Taxes $275,000 ($0) $275,000 0.00% $275,000 ($0) $275,000 0.00% $275,000 ($0) $275,000 0.00% 73 - Licenses And Permit $50,000 $55,208 ($5,208) 110.42% $50,000 ($475) $50,475 -0.95% $45,000 $45,089 ($89) 100.20% 75 - Charge For Srvcs Ext ($0) ($0) ($0) 0.00% $3,000 ($0) $3,000 0.00% $3,000 ($0) $3,000 0.00% 79 - Investment Earnings ($21,397) ($0) ($21,397) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue $1,300,000 $648,853 $651,147 49.91% ($0) $271,831 ($271,831) 0.00% $1,300,000 $542,993 $757,007 41.77% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 107 - Section 115 Trust Fund ($0) $329,819 ($329,819) 0.00% ($0) $915,701 ($915,701) 0.00% ($0) $7,341 ($7,341) 0.00% 77 - Operat Transfer In 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($0) $329,819 ($329,819) 0.00% ($0) $915,701 ($915,701) 0.00% ($0) $7,341 ($7,341) 0.00% 108 - Foothill Air Support Team Fund $397,073 $397,468 ($395) 100.10% $413,279 $409,568 $3,710 99.10% $411,098 $407,592 $3,506 99.15% 75 - Charge For Srvcs Ext $393,769 $393,769 ($0) 100.00% $407,597 $407,592 $5 100.00% $407,597 $407,592 $5 100.00% 79 - Investment Earnings $3,304 $3,699 ($395) 111.94% $5,682 $1,976 $3,705 34.78% $3,501 ($0) $3,501 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 201 - Supplemental Law Enforcement F $307,686 $140,790 $166,896 45.76% $369,613 $178,350 $191,263 48.25% $364,747 $182,497 $182,250 50.03% 74 - Intergov Revenue $300,000 $135,915 $164,085 45.31% $360,000 $175,932 $184,068 48.87% $360,000 $182,497 $177,503 50.69% 75 - Charge For Srvcs Ext 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $7,686 $4,875 $2,811 63.42% $9,613 $2,419 $7,194 25.16% $4,747 ($0) $4,747 0.00% 202 - Public Safety Augmentation Fun $1,668,207 $414,794 $1,253,413 24.86% $1,714,200 $411,244 $1,302,956 23.99% $1,700,000 $476,474 $1,223,526 28.03% 74 - Intergov Revenue $1,655,000 $414,794 $1,240,206 25.06% $1,700,000 $411,244 $1,288,756 24.19% $1,700,000 $476,474 $1,223,526 28.03% 79 - Investment Earnings $13,207 ($0) $13,207 0.00% $14,200 ($0) $14,200 0.00% ($0) ($0) ($0) 0.00% 203 - Health Fund $16,409,283 $3,489,848 $13,140,166 21.27% $17,574,496 $3,776,703 $13,797,793 21.49% $21,776,649 $4,801,065 $16,975,585 22.05% 71 - Taxes $970,111 $336,993 $633,118 34.74% $804,075 $377,690 $426,385 46.97% $804,075 $327,866 $476,209 40.78% 73 - Licenses And Permit $2,121,000 $602,153 $1,518,847 28.39% $2,131,137 $511,593 $1,619,544 24.01% $1,871,834 $534,724 $1,337,111 28.57% 74 - Intergov Revenue $12,263,699 $2,083,890 $10,179,809 16.99% $13,772,151 $2,534,062 $11,238,089 18.40% $17,305,979 $3,351,908 $13,954,071 19.37% 75 - Charge For Srvcs Ext $518,100 $173,630 $344,470 33.51% $547,040 $106,876 $440,164 19.54% $458,250 $164,269 $293,981 35.85% 76 - Charge For Svc Quasi $227,286 $85,757 $141,529 37.73% $60,000 $55,650 $4,350 92.75% $60,000 $25,000 $35,000 41.67% 77 - Operat Transfer In $125,000 $95,831 $29,169 76.66% $50,000 $20,831 $29,169 41.66% $830,541 $218,976 $611,565 26.37% 79 - Investment Earnings ($26,006) ($0) ($26,006) 0.00% ($0) $64 ($64) 0.00% ($0) $78 ($78) 0.00% 80 - Rental Income $210,093 $97,295 $333,529 46.31% $210,093 $109,411 $100,682 52.08% $217,578 $100,284 $117,294 46.09% 81 - Misc. Revenue ($0) $14,299 ($14,299) 0.00% ($0) $60,527 ($60,527) 0.00% $228,392 $77,959 $150,433 34.13% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% Created on 12/23/2021 Page 2 of 10

Page 48 ends

City of Pasadena
Revenue
By Fund
November 2021
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 204 - Building Services Fund $9,915,078 $3,961,908 $5,953,170 39.96% $9,958,799 $3,674,196 $6,284,603 36.89% $8,522,600 $3,253,704 $5,268,896 38.18% 73 - Licenses And Permit $7,088,651 $2,889,128 $4,199,523 40.76% $7,360,000 $2,929,672 $4,430,328 39.81% $6,624,000 $2,712,479 $3,911,521 40.95% 74 - Intergov Revenue $800,000 $11,585 $788,415 1.45% $345,000 $152,114 $192,886 44.09% ($0) $89,022 ($89,022) 0.00% 75 - Charge For Srvcs Ext $1,751,000 $828,898 $922,102 47.34% $1,900,000 $499,811 $1,400,189 26.31% $1,710,000 $430,914 $1,279,086 25.20% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 78 - Fine And Forfeiture ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $260,944 $172,547 $88,397 66.12% $293,799 $64,875 $228,924 22.08% $134,600 ($0) $134,600 0.00% 81 - Misc. Revenue $14,483 $59,751 ($45,268) 412.56% $60,000 $27,724 $32,276 46.21% $54,000 $21,288 $32,712 39.42% 205 - Sewer Construction and Maint. $6,748,210 $1,918,545 $4,829,665 28.43% $7,148,632 $1,899,364 $5,249,267 26.57% $7,170,975 $1,147,066 $6,023,909 16.00% 73 - Licenses And Permit ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 75 - Charge For Srvcs Ext $6,666,081 $1,868,223 $4,797,858 28.03% $7,048,573 $1,873,495 $5,175,077 26.58% $7,117,263 $1,147,066 $5,970,197 16.12% 79 - Investment Earnings $82,129 $50,322 $31,807 61.27% $100,059 $25,869 $74,190 25.85% $53,712 ($0) $53,712 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 206 - Underground Utilities Fund $6,454,064 $3,395,297 $3,058,767 52.61% $848,976 $1,217,135 ($368,159) 143.37% $6,053,885 $1,851,454 $4,202,431 30.58% 71 - Taxes $5,644,216 $2,888,790 $2,755,426 51.18% ($0) $1,055,468 ($1,055,468) 0.00% $5,700,000 $1,851,384 $3,848,616 32.48% 79 - Investment Earnings $809,848 $506,507 $303,341 62.54% $848,976 $161,667 $687,309 19.04% $353,885 ($0) $353,885 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) $70 ($70) 0.00% 207 - Asset Forfeiture Fund $408,510 $186,684 $221,826 45.70% $24,343 $34,192 ($9,848) 140.46% $15,323 $79,428 ($64,105) 518.36% 74 - Intergov Revenue $395,000 $170,759 $224,241 43.23% ($0) $26,832 ($26,832) 0.00% ($0) $79,428 ($79,428) 0.00% 79 - Investment Earnings $13,510 $15,925 ($2,415) 117.88% $24,343 $7,359 $16,984 30.23% $15,323 ($0) $15,323 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 208 - Transportation Sales Tax Fund $3,824,316 $1,372,079 $2,452,237 35.88% $3,943,325 $1,233,105 $2,710,219 31.27% $3,836,066 $1,506,877 $2,329,189 39.28% 73 - Licenses And Permit 0.00% 0.00% ($0) ($0) ($0) 0.00% 74 - Intergov Revenue $3,427,202 $1,278,594 $2,148,608 37.31% $3,533,981 $1,200,308 $2,333,673 33.96% $3,558,815 $1,499,028 $2,059,787 42.12% 75 - Charge For Srvcs Ext $13,500 $5,914 $7,586 43.81% $14,000 $3,384 $10,616 24.17% $14,000 $4,360 $9,640 31.14% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $94,349 $67,750 $26,599 71.81% $106,079 $28,231 $77,848 26.61% $55,251 ($0) $55,251 0.00% 81 - Misc. Revenue $289,265 $16,503 $272,762 5.71% $289,265 $1,183 $288,082 0.41% $208,000 $3,489 $204,511 1.68% 84 - Non-Op Revenue ($0) $3,317 ($3,317) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 209 - Proposition C Local Transit Fu $9,458,181 $3,349,916 $6,108,265 35.42% $9,669,303 $3,149,524 $6,519,779 32.57% $8,728,424 $3,280,460 $5,447,964 37.58% 74 - Intergov Revenue $3,847,344 $1,198,503 $2,648,841 31.15% $3,885,915 $1,058,047 $2,827,868 27.23% $3,559,894 $1,298,779 $2,261,116 36.48% 75 - Charge For Srvcs Ext ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In $4,330,135 $1,804,227 $2,525,908 41.67% $4,472,047 $1,863,350 $2,608,697 41.67% $4,260,944 $1,775,391 $2,485,553 41.67% 79 - Investment Earnings $120,702 $98,503 $22,199 81.61% $151,341 $47,236 $104,106 31.21% $92,586 ($0) $92,586 0.00% 81 - Misc. Revenue $1,160,000 $248,682 $911,318 21.44% $1,160,000 $180,892 $979,108 15.59% $815,000 $206,290 $608,710 25.31% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% Created on 12/23/2021 Page 3 of 10

Page 49 ends

City of Pasadena
Revenue
By Fund
November 2021
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 210 - Gas Tax Fund $4,792,829 $1,616,511 $3,176,317 33.73% $4,696,759 $1,319,340 $3,377,420 28.09% $4,663,560 $1,603,024 $3,060,537 34.37% 73 - Licenses And Permit ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 74 - Intergov Revenue $3,741,420 $1,175,034 $2,566,386 31.41% $3,628,768 $876,691 $2,752,077 24.16% $3,608,196 $1,174,657 $2,433,539 32.56% 76 - Charge For Svc Quasi $998,584 $416,072 $582,512 41.67% $1,028,050 $428,360 $599,690 41.67% $1,028,050 $428,367 $599,683 41.67% 79 - Investment Earnings $52,825 $25,406 $27,419 48.09% $39,942 $14,289 $25,652 35.78% $27,315 ($0) $27,315 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 212 - Library Services Fund $15,276,504 $6,425,191 $8,851,313 42.06% $15,077,584 $6,414,920 $8,662,664 42.55% $14,841,281 $6,178,119 $8,663,162 41.63% 74 - Intergov Revenue $324,500 $154,200 $170,300 47.52% ($0) ($0) ($0) 0.00% ($0) $19,790 ($19,790) 0.00% 75 - Charge For Srvcs Ext $9,500 $3,982 $5,518 41.92% $15,500 $182 $15,318 1.17% $7,500 $1,089 $6,412 14.51% 76 - Charge For Svc Quasi ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In $14,706,093 $6,127,537 $8,578,556 41.67% $14,500,967 $6,077,149 $8,423,818 41.91% $14,645,929 $6,102,464 $8,543,465 41.67% 78 - Fine And Forfeiture ($0) ($0) ($0) 0.00% $49,500 $155 $49,345 0.31% $27,500 $538 $26,962 1.96% 79 - Investment Earnings $107,911 $63,144 $44,767 58.51% $114,317 $29,935 $84,383 26.19% $61,552 ($0) $61,552 0.00% 80 - Rental Income $50,000 $33,111 $16,889 66.22% $50,000 $8,400 $41,600 16.80% $35,000 $37,975 ($2,975) 108.50% 81 - Misc. Revenue $78,500 $43,217 $35,283 55.05% $347,300 $299,099 $48,201 86.12% $63,800 $16,263 $47,537 25.49% 213 - Old Pasadena Parking Meter Fun $1,857,159 $917,000 $940,159 49.38% $2,067,151 $513,686 $1,553,465 24.85% $1,540,000 $631,677 $908,323 41.02% 79 - Investment Earnings $12,159 $13,055 ($896) 107.37% $22,151 $5,733 $16,418 25.88% ($0) ($0) ($0) 0.00% 80 - Rental Income $1,825,000 $895,756 $929,244 49.08% $2,025,000 $505,025 $1,519,975 24.94% $1,525,000 $620,049 $904,951 40.66% 81 - Misc. Revenue $20,000 $8,189 $11,811 40.95% $20,000 $2,928 $17,072 14.64% $15,000 $11,628 $3,372 77.52% 214 - Civic Center Parking Meter Fun $777,190 $455,983 $321,207 58.67% $814,161 $160,011 $654,150 19.65% $605,210 $220,205 $385,005 36.38% 73 - Licenses And Permit $38,000 $18,001 $19,999 47.37% $38,000 $14,408 $23,592 37.92% $28,500 $13,006 $15,494 45.64% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $19,190 $13,746 $5,444 71.63% $21,661 $5,279 $16,382 24.37% $10,835 ($0) $10,835 0.00% 80 - Rental Income $660,000 $296,696 $363,304 44.95% $694,500 $134,423 $560,077 19.36% $520,875 $175,958 $344,917 33.78% 81 - Misc. Revenue $60,000 $127,541 ($67,541) 212.57% $60,000 $5,901 $54,099 9.83% $45,000 $31,241 $13,759 69.43% 215 - Bikeways Fund $89,277 ($0) $89,277 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 74 - Intergov Revenue $90,000 ($0) $90,000 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($723) ($0) ($723) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 216 - Air Quality Improvement Fund $173,527 $1,738 $171,789 1.00% $173,299 $662 $172,637 0.38% $172,131 ($0) $172,131 0.00% 74 - Intergov Revenue $170,000 ($0) $170,000 0.00% $170,000 ($0) $170,000 0.00% $170,000 ($0) $170,000 0.00% 79 - Investment Earnings $3,527 $1,738 $1,789 49.28% $3,299 $662 $2,637 20.07% $2,131 ($0) $2,131 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% Created on 12/23/2021 Page 4 of 10

Page 50 ends

City of Pasadena
Revenue
By Fund
November 2021
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 217 - South Lake Parking Operating F $508,666 $169,669 $338,997 33.36% $496,134 $54,886 $441,248 11.06% $375,259 $119,840 $255,418 31.94% 71 - Taxes $14,000 $1,081 $12,920 7.72% $14,000 $1,545 $12,456 11.03% $14,000 $185 $13,816 1.32% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $4,666 $3,112 $1,554 66.70% $5,134 $736 $4,398 14.34% $1,759 ($0) $1,759 0.00% 80 - Rental Income $265,000 $58,752 $206,248 22.17% $250,000 $26,815 $223,185 10.73% $188,750 $56,712 $132,038 30.05% 81 - Misc. Revenue $5,000 $1,650 $3,350 33.00% $2,000 $1,752 $248 87.60% $2,000 ($0) $2,000 0.00% 84 - Non-Op Revenue $220,000 $105,075 $114,925 47.76% $225,000 $24,038 $200,962 10.68% $168,750 $62,944 $105,806 37.30% 218 - Library Special Tax Fund $2,802,130 $32,287 $2,769,843 1.15% $2,900,213 $35,273 $2,864,940 1.22% $2,816,080 $27,462 $2,788,618 0.98% 71 - Taxes $2,804,893 $32,287 $2,772,606 1.15% $2,900,213 $35,273 $2,864,940 1.22% $2,816,080 $27,462 $2,788,618 0.98% 79 - Investment Earnings ($2,763) ($0) ($2,763) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 219 - Community Develop Block Grant $2,203,620 $430,690 $1,772,930 19.54% $4,748,830 $113,324 $4,635,506 2.39% $3,177,131 $1,722,987 $1,454,144 54.23% 74 - Intergov Revenue $1,984,991 $421,301 $1,563,690 21.22% $4,548,830 $90,994 $4,457,836 2.00% $3,027,131 $1,715,757 $1,311,374 56.68% 75 - Charge For Srvcs Ext 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($6,371) $488 ($6,859) -7.66% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue $225,000 $8,900 $216,100 3.96% $200,000 $22,330 $177,670 11.16% $150,000 $7,230 $142,770 4.82% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 220 - Rental Assistance Programs Fnd $15,156,712 $6,370,044 $8,786,668 42.03% $15,833,307 $6,780,623 $9,052,684 42.83% $16,870,112 $7,090,168 $9,779,944 42.03% 74 - Intergov Revenue $15,075,112 $6,359,902 $8,715,210 42.19% $15,751,707 $6,772,978 $8,978,729 43.00% $16,850,112 $7,079,706 $9,770,406 42.02% 75 - Charge For Srvcs Ext ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($0) $1,790 ($1,790) 0.00% ($0) $1,990 ($1,990) 0.00% ($0) $2,644 ($2,644) 0.00% 80 - Rental Income $81,600 $8,352 $73,248 10.23% $81,600 $5,655 $75,945 6.93% $20,000 $7,818 $12,182 39.09% 221 - Home Investment Partnership Fd $895,082 $419,296 $475,786 46.84% $950,560 $221,590 $728,970 23.31% $950,560 $154,746 $795,814 16.28% 74 - Intergov Revenue $744,976 $325,376 $419,600 43.68% $834,537 $62,945 $771,592 7.54% $834,537 $68,588 $765,949 8.22% 75 - Charge For Srvcs Ext ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $34,083 ($0) $34,083 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 80 - Rental Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue $116,023 $93,920 $22,103 80.95% $116,023 $158,645 ($42,622) 136.74% $116,023 $86,158 $29,865 74.26% 222 - Housing Assistance Fund $3 ($0) $3 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 74 - Intergov Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $3 ($0) $3 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 223 - Supportive Housing Prog. (SHP) $3,558,259 $255,675 $3,302,584 7.19% $3,737,296 $283,015 $3,454,281 7.57% $3,737,296 $210,330 $3,526,966 5.63% 74 - Intergov Revenue $3,561,687 $255,675 $3,306,012 7.18% $3,737,296 $283,015 $3,454,281 7.57% $3,737,296 $210,330 $3,526,966 5.63% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($3,428) ($0) ($3,428) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% Created on 12/23/2021 Page 5 of 10

Page 51 ends

City of Pasadena
Revenue
By Fund
November 2021
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 224 - Emergency Shelter Grant -ESG $158,049 $124,984 $33,065 79.08% $4,157,460 $408,967 $3,748,493 9.84% $2,313,762 $1,247,517 $1,066,246 53.92% 74 - Intergov Revenue $158,823 $124,984 $33,839 78.69% $4,157,460 $408,967 $3,748,493 9.84% $2,313,762 $1,247,517 $1,066,246 53.92% 79 - Investment Earnings ($774) ($0) ($774) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 225 - West Gateway Parking Meter Fd $18,623 $46,597 ($27,974) 250.21% $27,666 $8,880 $18,786 32.10% $19,753 $3,641 $16,112 18.43% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $1,623 $1,162 $461 71.58% $2,666 $529 $2,136 19.86% $1,003 ($0) $1,003 0.00% 80 - Rental Income $17,000 $13,473 $3,527 79.25% $25,000 $8,351 $16,649 33.40% $18,750 $3,641 $15,109 19.42% 83 - Operating Income ($0) $31,962 ($31,962) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 226 - HOPWA Fund $188,524 $13,923 $174,601 7.39% $180,670 $65,849 $114,821 36.45% $180,670 ($0) $180,670 0.00% 74 - Intergov Revenue $188,526 $13,923 $174,603 7.39% $180,670 $65,849 $114,821 36.45% $180,670 ($0) $180,670 0.00% 79 - Investment Earnings ($2) ($0) ($2) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 80 - Rental Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 229 - Playhouse Parking Fund $18,398 $9,239 $9,159 50.22% $20,068 $2,242 $17,826 11.17% $13,313 $3,338 $9,975 25.07% 79 - Investment Earnings $3,698 $2,318 $1,380 62.69% $3,868 $255 $3,613 6.59% $1,813 ($0) $1,813 0.00% 80 - Rental Income $14,700 $6,921 $7,779 47.08% $16,200 $1,987 $14,213 12.27% $11,500 $3,338 $8,162 29.03% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 230 - Homeland Security Grant Fund $157,214 $28,299 $128,915 18.00% $142,937 ($0) $142,937 0.00% $628,304 ($0) $628,304 0.00% 74 - Intergov Revenue $163,534 $28,299 $135,235 17.30% $142,937 ($0) $142,937 0.00% $628,304 ($0) $628,304 0.00% 79 - Investment Earnings ($6,320) ($0) ($6,320) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 232 - So. Lake Parking Meter Zone Fd $270,988 $155,163 $115,825 57.26% $281,062 $62,189 $218,873 22.13% $185,540 $73,077 $112,463 39.39% 79 - Investment Earnings $9,988 $7,640 $2,348 76.49% $12,062 $3,179 $8,883 26.35% $6,290 ($0) $6,290 0.00% 80 - Rental Income $16,000 $6,392 $9,608 39.95% $14,000 $1,712 $12,288 12.23% $10,500 $480 $10,020 4.57% 81 - Misc. Revenue ($0) $24,716 ($24,716) 0.00% ($0) $3,146 ($3,146) 0.00% ($0) $18 ($18) 0.00% 84 - Non-Op Revenue $245,000 $116,416 $128,584 47.52% $255,000 $54,152 $200,848 21.24% $168,750 $72,579 $96,171 43.01% 233 - Sewer Facility Charge Fund $264,301 $384,070 ($119,769) 145.32% $487,518 $177,993 $309,525 36.51% $440,134 $181,214 $258,920 41.17% 75 - Charge For Srvcs Ext $200,000 $338,257 ($138,257) 169.13% $400,000 $158,169 $241,831 39.54% $400,000 $181,214 $218,786 45.30% 79 - Investment Earnings $64,301 $45,813 $18,488 71.25% $87,518 $19,824 $67,694 22.65% $40,134 ($0) $40,134 0.00% 236 - Measure R Transportation Fnd $1,867,509 $777,815 $1,089,694 41.65% $1,928,977 $750,660 $1,178,317 38.91% $1,822,697 $932,666 $890,031 51.17% 74 - Intergov Revenue $1,852,097 $772,281 $1,079,816 41.70% $1,918,724 $749,263 $1,169,461 39.05% $1,819,664 $932,666 $886,998 51.25% 79 - Investment Earnings $15,412 $5,534 $9,878 35.90% $10,253 $1,397 $8,856 13.63% $3,033 ($0) $3,033 0.00% 237 - Low and Mod Inc Housing Asset $245,015 $141,133 $103,882 57.60% $182,154 $52,960 $129,194 29.07% $182,154 $211,410 ($29,256) 116.06% 75 - Charge For Srvcs Ext $400 $88 $312 21.93% $400 ($0) $400 0.00% $400 $54,999 ($54,599) 13749.66% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $62,861 $19,961 $42,900 31.75% ($0) $2,238 ($2,238) 0.00% ($0) $785 ($785) 0.00% 80 - Rental Income $63,301 $25,725 $37,576 40.64% $63,301 $25,725 $37,576 40.64% $63,301 $25,725 $37,576 40.64% 81 - Misc. Revenue $118,453 $95,359 $23,094 80.50% $118,453 $24,997 $93,456 21.10% $118,453 $129,901 ($11,448) 109.66% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% Created on 12/23/2021 Page 6 of 10

Page 52 ends

City of Pasadena
Revenue
By Fund
November 2021
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 238 - Other Housing Funds $3,814,123 $558,309 $3,255,814 14.64% $4,711,977 $1,287,316 $3,424,661 27.32% $4,324,168 $1,834,007 $2,490,161 42.41% 74 - Intergov Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% $103,667 $842,635 ($738,968) 812.83% 75 - Charge For Srvcs Ext $400 $809 ($409) 202.37% $400 $3,777 ($3,377) 944.37% $400 $3,081 ($2,681) 770.24% 77 - Operat Transfer In $1,313,638 $547,341 $766,297 41.67% $1,549,638 $645,672 $903,966 41.67% $1,474,638 $614,429 $860,209 41.67% 79 - Investment Earnings $70,621 $98 $70,523 0.14% ($0) $39 ($39) 0.00% ($0) ($0) ($0) 0.00% 80 - Rental Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue $2,429,464 $10,061 $2,419,403 0.41% $3,161,939 $637,828 $2,524,111 20.17% $2,745,463 $373,862 $2,371,601 13.62% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 239 - Inclusionary Housing Trust Fun $226,968 $643,964 ($416,996) 283.72% $263,447 $151,223 $112,225 57.40% $200,091 $487,873 ($287,782) 243.83% 75 - Charge For Srvcs Ext $50,400 $357,133 ($306,733) 708.60% $50,400 $92,211 ($41,811) 182.96% $50,400 $93,446 ($43,046) 185.41% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $105,468 $84,304 $21,164 79.93% $141,947 $39,813 $102,135 28.05% $78,591 ($0) $78,591 0.00% 80 - Rental Income $71,100 ($0) $71,100 0.00% $71,100 ($0) $71,100 0.00% $71,100 ($0) $71,100 0.00% 81 - Misc. Revenue ($0) $202,528 ($202,528) 0.00% ($0) $19,199 ($19,199) 0.00% ($0) $394,427 ($394,427) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 241 - Rd Maint and Rehab Acct (RMRA) $2,389,858 $750,596 $1,639,262 31.41% $2,795,838 $711,564 $2,084,274 25.45% $2,877,815 $760,461 $2,117,355 26.42% 74 - Intergov Revenue $2,389,858 $729,217 $1,660,641 30.51% $2,763,372 $695,616 $2,067,756 25.17% $2,859,623 $760,461 $2,099,162 26.59% 79 - Investment Earnings ($0) $21,380 ($21,380) 0.00% $32,466 $15,948 $16,518 49.12% $18,192 ($0) $18,192 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 242 - Measure M Local Return Fund $2,099,044 $875,713 $1,223,331 41.72% $2,180,553 $846,096 $1,334,458 38.80% $2,063,364 $1,054,511 $1,008,853 51.11% 74 - Intergov Revenue $2,099,044 $869,646 $1,229,398 41.43% $2,174,329 $851,427 $1,322,902 39.16% $2,062,286 $1,054,511 $1,007,775 51.13% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($0) $6,067 ($6,067) 0.00% $6,224 ($5,332) $11,556 -85.66% $1,078 ($0) $1,078 0.00% 301 - Project Management Fund $53,150,357 $9,678,624 $43,471,733 18.21% $31,377,392 $8,357,327 $23,020,065 26.63% $48,232,639 $4,162,889 $44,069,750 8.63% 73 - Licenses And Permit 0.00% 0.00% ($0) ($0) ($0) 0.00% 74 - Intergov Revenue $9,236,084 $1,861,260 $7,374,824 20.15% $7,247,392 $1,280,147 $5,967,245 17.66% $10,809,721 $1,815,174 $8,994,547 16.79% 75 - Charge For Srvcs Ext $216,000 $6,959 $209,041 3.22% $130,000 $11,891 $118,109 9.15% ($0) $9,993 ($9,993) 0.00% 76 - Charge For Svc Quasi ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In $42,368,654 $7,460,522 $34,908,132 17.61% $23,800,000 $6,720,659 $17,079,341 28.24% $36,505,729 $1,995,120 $34,510,609 5.47% 79 - Investment Earnings ($23,015) ($0) ($23,015) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 80 - Rental Income $702,097 $93,665 $608,432 13.34% ($0) $9,994 ($9,994) 0.00% $530,000 $16,569 $513,431 3.13% 81 - Misc. Revenue $650,537 $256,219 $394,318 39.39% $200,000 $334,637 ($134,637) 167.32% $387,189 $326,033 $61,156 84.21% 82 - Other Fincng Source ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income 0.00% 0.00% ($0) ($0) ($0) 0.00%
84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% Created on 12/23/2021 Page 7 of 10

Page 53 ends

City of Pasadena
Revenue
By Fund
November 2021
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 310 - Capital Public Art Fund $15,245 $9,630 $5,615 63.17% $16,102 $5,565 $10,537 34.56% $7,763 ($0) $7,763 0.00% 74 - Intergov Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $15,245 $9,630 $5,615 63.17% $16,102 $3,924 $12,178 24.37% $7,763 ($0) $7,763 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) $1,641 ($1,641) 0.00% ($0) ($0) ($0) 0.00% 313 - Traffic Reduction Trans Improv $336,547 $267,978 $68,569 79.63% $694,619 $79,177 $615,442 11.40% $441,956 $24,201 $417,756 5.48% 75 - Charge For Srvcs Ext $300,000 $215,833 $84,167 71.94% $600,000 $59,275 $540,725 9.88% $400,000 $24,201 $375,799 6.05% 79 - Investment Earnings $36,547 $52,145 ($15,598) 142.68% $94,619 $19,902 $74,716 21.03% $41,956 ($0) $41,956 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 405 - Plaza Las Fuentes Parking Fund ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 80 - Rental Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 406 - Refuse Collection Fund $17,321,492 $6,550,670 $10,770,822 37.82% $17,977,903 $6,347,350 $11,630,553 35.31% $17,769,472 $7,800,797 $9,968,674 43.90% 72 - Franchise Fees $5,186,852 $1,298,560 $3,888,292 25.04% $5,486,000 $1,482,304 $4,003,696 27.02% $5,500,000 $1,590,045 $3,909,955 28.91% 73 - Licenses And Permit ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 74 - Intergov Revenue $110,000 $39,042 $70,958 35.49% $110,000 ($0) $110,000 0.00% $103,000 $19,593 $83,407 19.02% 75 - Charge For Srvcs Ext $267,000 $219,291 $47,709 82.13% $517,000 $145,372 $371,628 28.12% $517,000 $231,551 $285,449 44.79% 76 - Charge For Svc Quasi ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $347,159 $251,914 $95,245 72.56% $416,436 $104,112 $312,325 25.00% $206,005 ($0) $206,005 0.00% 81 - Misc. Revenue $131,090 $90,691 $40,399 69.18% $169,590 $35,168 $134,422 20.74% $169,590 $3,186,725 ($3,017,135) 1879.08% 83 - Operating Income $11,279,391 $4,621,307 $6,658,084 40.97% $11,278,877 $4,571,689 $6,707,188 40.53% $11,273,877 $2,764,338 $8,509,538 24.52% 84 - Non-Op Revenue ($0) $29,863 ($29,863) 0.00% ($0) $8,706 ($8,706) 0.00% ($0) $8,545 ($8,545) 0.00% 407 - Off-Street Parking Facilities $15,515,521 $4,616,577 $10,898,944 29.75% $15,336,161 $2,393,171 $12,942,989 15.60% $11,592,411 $2,845,658 $8,746,752 24.55% 75 - Charge For Srvcs Ext ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $201,806 $102,004 $99,802 50.55% $187,741 $32,356 $155,385 17.23% $137,971 $50 $137,920 0.04% 80 - Rental Income $13,664,315 $3,996,824 $9,667,491 29.25% $13,446,820 $1,948,548 $11,498,272 14.49% $10,144,965 $2,433,654 $7,711,311 23.99% 81 - Misc. Revenue ($0) $4,979 ($4,979) 0.00% ($0) $21,380 ($21,380) 0.00% ($0) $9,098 ($9,098) 0.00% 83 - Operating Income $599,400 $168,824 $430,576 28.17% $657,400 $195,576 $461,824 29.75% $522,125 $181,881 $340,244 34.83% 84 - Non-Op Revenue $1,050,000 $343,946 $706,054 32.76% $1,044,200 $195,312 $848,888 18.70% $787,350 $220,975 $566,375 28.07% 408 - Telecommunications Fund $596,944 $90,870 $506,074 15.22% $576,943 $421,104 $155,838 72.99% $436,958 $478,024 ($41,066) 109.40% 72 - Franchise Fees ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 73 - Licenses And Permit $551,208 $73,282 $477,926 13.29% $553,643 $305,029 $248,614 55.09% $420,290 $391,598 $28,692 93.17% 76 - Charge For Svc Quasi $36,000 $9,000 $27,000 25.00% $9,000 $18,000 ($9,000) 200.00% $9,000 $27,000 ($18,000) 300.00% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $9,736 $8,588 $1,148 88.21% $14,300 $4,180 $10,119 29.23% $7,668 ($0) $7,668 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) $93,895 ($93,895) 0.00% ($0) $59,426 ($59,426) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% Created on 12/23/2021 Page 8 of 10

Page 54 ends

City of Pasadena
Revenue
By Fund
November 2021
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 409 - Paseo Colo Parking Structures ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 80 - Rental Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 415 - DelMar GoldLine Parking Garage ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 501 - Computing and Communication Fd $17,888,686 $7,191,999 $10,696,687 40.20% $19,142,420 $7,655,544 $11,486,876 39.99% $19,276,372 $7,745,883 $11,530,489 40.18% 72 - Franchise Fees ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 73 - Licenses And Permit ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 74 - Intergov Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 75 - Charge For Srvcs Ext ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 76 - Charge For Svc Quasi $153,986 $64,162 $89,824 41.67% $164,251 $68,435 $95,816 41.66% $164,251 $68,435 $95,816 41.66% 77 - Operat Transfer In $345,000 $143,750 $201,250 41.67% $431,000 $179,581 $251,419 41.67% $606,400 $252,662 $353,738 41.67% 79 - Investment Earnings $58,875 $14,980 $43,895 25.44% $36,676 $4,352 $32,325 11.87% $9,333 ($0) $9,333 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) $196 ($196) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income $17,330,825 $6,969,107 $10,361,718 40.21% $18,510,493 $7,402,980 $11,107,513 39.99% $18,496,388 $7,424,786 $11,071,602 40.14% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 502 - Building Maintenance Fund $13,507,621 $5,463,959 $8,043,662 40.45% $14,176,576 $5,638,459 $8,538,117 39.77% $14,145,315 $5,584,697 $8,560,618 39.48% 76 - Charge For Svc Quasi $407,768 $169,901 $237,867 41.67% $582,535 $242,727 $339,808 41.67% $612,711 $255,298 $357,413 41.67% 77 - Operat Transfer In $94,088 $39,201 $54,887 41.66% $96,903 $40,378 $56,525 41.67% $96,903 $40,378 $56,525 41.67% 79 - Investment Earnings $140,088 $83,563 $56,525 59.65% $134,173 $37,092 $97,081 27.65% $72,736 ($0) $72,736 0.00% 80 - Rental Income $325,866 $117,242 $208,624 35.98% $337,800 $138,495 $199,305 41.00% $337,800 $138,495 $199,305 41.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income $12,539,811 $5,054,053 $7,485,758 40.30% $13,025,165 $5,179,767 $7,845,398 39.77% $13,025,165 $5,150,526 $7,874,639 39.54% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 503 - Fleet Replacement Fund $3,179,992 $1,461,776 $1,718,216 45.97% $3,307,634 $1,396,988 $1,910,647 42.24% $3,057,197 $1,014,565 $2,042,632 33.19% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $147,313 $118,327 $28,986 80.32% $177,575 $51,743 $125,833 29.14% $98,031 ($0) $98,031 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income $3,032,679 $1,297,744 $1,734,935 42.79% $3,130,059 $1,322,108 $1,807,951 42.24% $2,959,166 $1,000,969 $1,958,197 33.83% 84 - Non-Op Revenue ($0) $45,705 ($45,705) 0.00% ($0) $23,137 ($23,137) 0.00% ($0) $13,596 ($13,596) 0.00% 504 - Benefits and Insurance Fund $85,703 $14,000,968 ($13,915,265) 16336.61% ($11,684) $14,263,902 ($14,275,585) -122083.56% ($39,358) $13,975,206 ($14,014,563) -35508.37% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $85,703 ($16,470) $102,173 -19.22% ($11,684) ($81,513) $69,830 697.67% ($39,358) $12 ($39,369) -0.03% 81 - Misc. Revenue ($0) $2,718 ($2,718) 0.00% ($0) $2,200 ($2,200) 0.00% ($0) $2,140 ($2,140) 0.00% 83 - Operating Income ($0) $14,014,720 ($14,014,720) 0.00% ($0) $14,343,215 ($14,343,215) 0.00% ($0) $13,973,054 ($13,973,054) 0.00% 508 - Printing Services Fund $967,986 $315,919 $652,067 32.64% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($54,014) ($38,387) ($15,627) 71.07% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 83 - Operating Income $1,022,000 $354,306 $667,694 34.67% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% Created on 12/23/2021 Page 9 of 10

Page 55 ends

City of Pasadena
Revenue
By Fund
November 2021
Attachment A

UNAUDITED
Fiscal Year
2020 2021 2022
Fund Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD Revised Budget Actual Available Budget YTD 510 - Citizen Service Center Fund $795,329 $331,239 $464,090 41.65% $853,330 $354,965 $498,365 41.60% $851,737 $354,389 $497,348 41.61% 76 - Charge For Svc Quasi $791,329 $329,714 $461,615 41.67% $850,556 $354,389 $496,167 41.67% $850,556 $354,389 $496,167 41.67% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings $4,000 $1,525 $2,475 38.11% $2,774 $576 $2,198 20.76% $1,181 ($0) $1,181 0.00% 511 - Fleet Repair and Maintenance $8,844,280 $3,599,893 $5,244,386 40.70% $9,043,019 $3,965,917 $5,077,101 43.86% $9,030,296 $2,380,695 $6,649,600 26.36% 77 - Operat Transfer In ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($0) $7,269 ($7,269) 0.00% $22,053 $5,318 $16,735 24.11% $9,330 ($0) $9,330 0.00% 81 - Misc. Revenue $10,000 $1,423 $8,577 14.23% $10,000 $1,160 $8,840 11.60% $10,000 $983 $9,017 9.83% 83 - Operating Income $8,834,280 $3,591,202 $5,243,078 40.65% $9,010,966 $3,959,440 $5,051,526 43.94% $9,010,966 $2,379,712 $6,631,254 26.41% 84 - Non-Op Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 613 - Cultural Trust Fund $389,911 $155,595 $234,316 39.91% $529,445 $362,797 $166,649 68.52% $418,972 $204,653 $214,318 48.85% 79 - Investment Earnings $14,911 $17,573 ($2,662) 117.85% $29,445 $7,335 $22,111 24.91% $13,972 ($0) $13,972 0.00% 81 - Misc. Revenue $375,000 $138,022 $236,978 36.81% $500,000 $355,462 $144,538 71.09% $405,000 $204,653 $200,347 50.53% 614 - La Pintoresca Branch Childrens $288 $178 $110 61.73% $297 $72 $225 24.25% $143 ($0) $143 0.00% 79 - Investment Earnings $288 $178 $110 61.73% $297 $72 $225 24.25% $143 ($0) $143 0.00% 677 - Library Equip Repl-Pasadena $2,395 $1,188 $1,207 49.62% $2,229 $795 $1,434 35.68% $1,066 ($0) $1,066 0.00% 79 - Investment Earnings $2,395 $1,188 $1,207 49.62% $2,229 $795 $1,434 35.68% $1,066 ($0) $1,066 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 678 - Library Equip Repl-Glendale $1,868 $1,155 $713 61.82% $1,931 $468 $1,463 24.25% $931 ($0) $931 0.00% 79 - Investment Earnings $1,868 $1,155 $713 61.82% $1,931 $468 $1,463 24.25% $931 ($0) $931 0.00% 81 - Misc. Revenue ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 679 - Library Equip Repl-Shared $104,420 $568 $103,852 0.54% $1,105 $138 $968 12.44% $281 ($0) $281 0.00% 79 - Investment Earnings $4,420 $568 $3,852 12.85% $1,105 $138 $968 12.44% $281 ($0) $281 0.00% 81 - Misc. Revenue $100,000 ($0) $100,000 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 681 - Workforce Innov and Opport Act $4,989,067 $606,552 $4,382,515 12.16% $5,633,631 $874,087 $4,759,544 15.52% $5,493,888 $42,436 $5,451,452 0.77% 74 - Intergov Revenue $4,981,245 $606,552 $4,374,693 12.18% $5,623,631 $864,087 $4,759,544 15.37% $5,483,888 $42,436 $5,441,452 0.77% 75 - Charge For Srvcs Ext ($0) ($0) ($0) 0.00% ($0) $10,000 ($10,000) 0.00% ($0) ($0) ($0) 0.00% 79 - Investment Earnings ($2,178) ($0) ($2,178) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 81 - Misc. Revenue $10,000 ($0) $10,000 0.00% $10,000 ($0) $10,000 0.00% $10,000 ($0) $10,000 0.00% 820 - Successor Agency Admin $248,257 ($0) $248,257 0.00% ($0) ($0) ($0) 0.00% $36,297 ($0) $36,297 0.00% 71 - Taxes ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 75 - Charge For Srvcs Ext ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% 77 - Operat Transfer In $250,000 ($0) $250,000 0.00% ($0) ($0) ($0) 0.00% $36,297 ($0) $36,297 0.00% 79 - Investment Earnings ($1,743) ($0) ($1,743) 0.00% ($0) ($0) ($0) 0.00% ($0) ($0) ($0) 0.00% Created on 12/23/2021 Page 10 of 10

Page 56 ends

City of Pasadena
Expenditures
By Fund
November 2021
Attachment B

UNAUDITED
Fiscal Year
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 101 - General Fund $281,044,005 $110,260,710 $170,783,296 39.23% $292,040,991 $112,466,470 $179,574,521.49 38.51% 90 - Personnel $175,300,384 $71,642,581 $103,657,803 40.87% $178,878,804 $73,341,803 $105,537,001.62 41.00% 91 - Services & Supplies $48,781,358 $11,727,800 $37,053,558 24.04% $50,911,420 $14,343,788 $36,567,632.07 28.17% 92 - Capital Outlay $505,663 $356,603 $149,060 70.52% $234,853 $0 $234,852.60 0.00% 93 - Internal Srvc Chrg $23,753,168 $9,734,556 $14,018,613 40.98% $23,713,506 $8,822,837 $14,890,669.27 37.21% 94 - Debt Service $9,504 $0 $9,504 0.00% $9,504 $0 $9,504.00 0.00% 95 - Operat Transfer Out $21,193,928 $9,537,178 $11,656,750 45.00% $28,442,904 $9,921,003 $18,521,901.73 34.88% 96 - Operating Expense $11,500,000 $7,261,992 $4,238,008 63.15% $9,850,000 $6,037,040 $3,812,960.20 61.29% 97 - Non-Op Expense $0 $0 $0 0.00% $0 $0 $0.00 0.00%
102 - Parking Operations Fund $27,620 $5,552 $22,068 20.10% $26,000 $9,518 $16,481.92 36.61% 90 - Personnel $0 $0 $0 0.00% $0 $961 ($961.01) 0.00%
91 - Services & Supplies $27,620 $5,552 $22,068 20.10% $26,000 $8,557 $17,442.93 32.91% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 104 - L. A. Impact Fund $74,999 $19,070 $55,929 25.43% $74,999 $17,544 $57,455.22 23.39% 90 - Personnel $0 $5,338 -$5,338 0.00% $0 $2,397 ($2,397.33) 0.00% 91 - Services & Supplies $65,715 $9,866 $55,849 15.01% $65,715 $11,280 $54,434.55 17.17% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $9,284 $3,866 $5,418 41.64% $9,284 $3,866 $5,418.00 41.64% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 105 - General Fund Projects Fund $8,248,768 $3,677,368 $4,571,399 44.58% $5,871,057 $2,401,232 $3,469,824.68 40.90% 90 - Personnel $3,477,437 $1,326,229 $2,151,208 38.14% $3,614,810 $2,056,512 $1,558,297.69 56.89% 91 - Services & Supplies $4,692,912 $2,329,002 $2,363,909 49.63% $2,177,828 $328,041 $1,849,787.39 15.06% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $78,419 $22,137 $56,282 28.23% $78,419 $16,679 $61,739.60 21.27% 94 - Debt Service $0 $0 $0 0.00% $0 $0 $0.00 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 96 - Operating Expense 0.00% $0 $0 $0.00 0.00%
106 - New Years Day Genl Fund Events $2,111,053 $0 $2,111,053 0.00% $2,111,053 $46,604 $2,064,448.69 2.21% 90 - Personnel $712,010 $0 $712,010 0.00% $712,010 $38,806 $673,203.50 5.45% 91 - Services & Supplies $1,374,043 $0 $1,374,043 0.00% $1,374,043 $7,798 $1,366,245.19 0.57% 93 - Internal Srvc Chrg $25,000 $0 $25,000 0.00% $25,000 $0 $25,000.00 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 96 - Operating Expense $0 $0 $0 0.00% $0 $0 $0.00 0.00% 107 - Section 115 Trust Fund $0 $24,848 -$24,848 0.00% $0 $27,123 ($27,123.20) 0.00% 91 - Services & Supplies $0 $24,848 -$24,848 0.00% $0 $27,123 ($27,123.20) 0.00% Created on 12/23/2021 Page 1 of 10

Page 57 ends

City of Pasadena
Expenditures
By Fund
November 2021

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 108 - Foothill Air Support Team Fund $367,596 $88,322 $279,274 24.03% $389,093 $106,221 $282,872.06 27.30% 90 - Personnel $122,617 $47,505 $75,112 38.74% $120,008 $55,104 $64,904.88 45.92% 91 - Services & Supplies $231,462 $35,183 $196,280 15.20% $255,568 $45,483 $210,085.18 17.80% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $13,517 $5,635 $7,882 41.69% $13,517 $5,635 $7,882.00 41.69% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 201 - Supplemental Law Enforcement F $415,144 $94,357 $320,788 22.73% $583,451 $5,987 $577,463.92 1.03% 90 - Personnel $173,210 $88,434 $84,775 51.06% $176,097 $0 $176,097.12 0.00% 91 - Services & Supplies $173,871 $482 $173,389 0.28% $394,290 $547 $393,743.80 0.14% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $13,064 $5,441 $7,623 41.65% $13,064 $5,441 $7,623.00 41.65% 95 - Operat Transfer Out $55,000 $0 $55,000 0.00% $0 $0 $0.00 0.00% 202 - Public Safety Augmentation Fun $1,948,588 $947,640 $1,000,948 48.63% $2,001,373 $530,743 $1,470,629.60 26.52% 90 - Personnel $1,859,909 $910,466 $949,444 48.95% $1,908,499 $492,919 $1,415,580.55 25.83% 91 - Services & Supplies $11,009 $4,816 $6,193 43.74% $15,204 $5,465 $9,738.05 35.95% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $77,670 $32,359 $45,311 41.66% $77,670 $32,359 $45,311.00 41.66% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 203 - Health Fund $18,479,224 $6,544,748 $11,934,476 35.42% $20,666,844 $6,332,357 $14,334,487.01 30.64% 90 - Personnel $12,586,681 $5,068,484 $7,518,197 40.27% $15,146,582 $4,911,156 $10,235,426.68 32.42% 91 - Services & Supplies $3,468,689 $700,256 $2,768,432 20.19% $3,449,755 $608,783 $2,840,972.28 17.65% 92 - Capital Outlay $173,455 $0 $173,455 0.00% $675 $0 $675.00 0.00% 93 - Internal Srvc Chrg $2,250,400 $776,008 $1,474,392 34.48% $2,069,831 $812,418 $1,257,413.05 39.25% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 204 - Building Services Fund $12,972,514 $3,795,291 $9,177,223 29.26% $11,672,843 $3,550,911 $8,121,932.01 30.42% 90 - Personnel $6,890,337 $2,832,546 $4,057,791 41.11% $7,068,116 $2,446,075 $4,622,040.46 34.61% 91 - Services & Supplies $3,178,065 $348,310 $2,829,756 10.96% $3,150,616 $534,452 $2,616,164.44 16.96% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $1,404,111 $561,175 $842,936 39.97% $1,404,111 $554,774 $849,337.11 39.51% 95 - Operat Transfer Out $1,500,000 $53,260 $1,446,740 3.55% $50,000 $15,610 $34,390.00 31.22% 205 - Sewer Construction and Maint. $9,025,512 $1,988,312 $7,037,201 22.03% $7,036,595 $1,941,537 $5,095,058.13 27.59% 90 - Personnel $1,585,683 $562,510 $1,023,173 35.47% $1,600,425 $685,228 $915,197.62 42.82% 91 - Services & Supplies $2,692,122 $953,928 $1,738,194 35.43% $2,403,316 $963,088 $1,440,227.12 40.07% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $547,707 $258,433 $289,274 47.18% $567,239 $200,039 $367,200.39 35.27% 95 - Operat Transfer Out $4,200,000 $213,440 $3,986,560 5.08% $2,465,615 $93,182 $2,372,433.00 3.78% 206 - Underground Utilities Fund $6,427,255 $87,881 $6,339,374 1.37% $4,169,655 $95,051 $4,074,603.81 2.28% 91 - Services & Supplies $94,633 $39,431 $55,202 41.67% $94,633 $39,431 $55,202.00 41.67% 93 - Internal Srvc Chrg $29,562 $12,314 $17,248 41.65% $29,562 $12,314 $17,248.00 41.65% 95 - Operat Transfer Out $6,303,060 $36,136 $6,266,924 0.57% $4,045,460 $43,306 $4,002,153.81 1.07% Created on 12/23/2021 Page 2 of 10

Page 58 ends

City of Pasadena
Expenditures
By Fund
November 2021

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 207 - Asset Forfeiture Fund $326,644 $245,251 $81,393 75.08% $1,226,644 $233,931 $992,712.79 19.07% 90 - Personnel $15,375 $7,038 $8,337 45.78% $15,375 $13,870 $1,504.64 90.21% 91 - Services & Supplies $299,000 $61,974 $237,026 20.73% $299,000 $214,946 $84,054.15 71.89% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $12,269 $5,115 $7,154 41.69% $12,269 $5,115 $7,154.00 41.69% 95 - Operat Transfer Out $0 $171,124 -$171,124 0.00% $900,000 $0 $900,000.00 0.00% 208 - Transportation Sales Tax Fund $3,022,543 $879,642 $2,142,901 29.10% $3,041,784 $767,850 $2,273,934.08 25.24% 90 - Personnel $695,937 $284,896 $411,041 40.94% $704,316 $278,917 $425,399.18 39.60% 91 - Services & Supplies $2,013,215 $486,850 $1,526,365 24.18% $2,105,077 $422,023 $1,683,053.89 20.05% 93 - Internal Srvc Chrg $237,391 $75,827 $161,563 31.94% $232,391 $66,910 $165,481.01 28.79% 95 - Operat Transfer Out $76,000 $32,069 $43,931 42.20% $0 $0 $0.00 0.00% 209 - Proposition C Local Transit Fu $7,059,998 $1,965,432 $5,094,566 27.84% $7,837,432 $1,905,482 $5,931,949.77 24.31% 90 - Personnel $543,320 $224,311 $319,009 41.29% $541,652 $212,611 $329,040.96 39.25% 91 - Services & Supplies $5,827,321 $1,427,465 $4,399,856 24.50% $6,350,889 $1,490,864 $4,860,025.01 23.47% 93 - Internal Srvc Chrg $689,357 $269,709 $419,649 39.12% $683,957 $199,758 $484,199.80 29.21% 95 - Operat Transfer Out $0 $43,948 -$43,948 0.00% $260,934 $2,250 $258,684.00 0.86% 210 - Gas Tax Fund $5,395,560 $1,094,949 $4,300,611 20.29% $4,195,526 $1,242,916 $2,952,610.28 29.62% 90 - Personnel $1,598,020 $523,257 $1,074,762 32.74% $1,687,659 $636,828 $1,050,831.37 37.73% 91 - Services & Supplies $759,899 $247,443 $512,455 32.56% $715,225 $229,102 $486,122.59 32.03% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $437,642 $183,540 $254,101 41.94% $437,642 $123,549 $314,093.32 28.23% 95 - Operat Transfer Out $2,600,000 $140,708 $2,459,292 5.41% $1,355,000 $253,437 $1,101,563.00 18.70% 211 - Human Services Endowment Fund $0 $0 $0 0.00% $0 $0 $0.00 0.00% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0.00 0.00%
91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0.00 0.00% 212 - Library Services Fund $15,662,925 $5,403,586 $10,259,338 34.50% $15,605,626 $5,430,299 $10,175,326.64 34.80% 90 - Personnel $9,462,195 $3,482,263 $5,979,932 36.80% $9,752,020 $3,546,804 $6,205,216.41 36.37% 91 - Services & Supplies $3,162,756 $616,992 $2,545,765 19.51% $2,761,182 $679,009 $2,082,173.24 24.59% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $3,037,973 $1,259,917 $1,778,056 41.47% $3,007,423 $1,204,486 $1,802,936.99 40.05% 95 - Operat Transfer Out $0 $44,415 -$44,415 0.00% $85,000 $0 $85,000.00 0.00% 213 - Old Pasadena Parking Meter Fun $1,889,698 $605,167 $1,284,530 32.02% $1,573,618 $524,315 $1,049,303.06 33.32% 90 - Personnel $161,721 $52,132 $109,589 32.24% $162,292 $65,456 $96,835.95 40.33% 91 - Services & Supplies $1,613,869 $522,062 $1,091,807 32.35% $1,297,218 $427,929 $869,288.68 32.99% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $84,108 $30,973 $53,134 36.83% $84,108 $30,929 $53,178.43 36.77% 95 - Operat Transfer Out $30,000 $0 $30,000 0.00% $30,000 $0 $30,000.00 0.00% 96 - Operating Expense $0 $0 $0 0.00% $0 $0 $0.00 0.00% Created on 12/23/2021 Page 3 of 10

Page 59 ends

City of Pasadena
Expenditures
By Fund
November 2021

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 214 - Civic Center Parking Meter Fun $880,379 $246,736 $633,643 28.03% $754,604 $264,286 $490,317.76 35.02% 90 - Personnel $487,666 $176,534 $311,132 36.20% $498,637 $187,170 $311,467.05 37.54% 91 - Services & Supplies $219,260 $49,421 $169,839 22.54% $187,015 $56,923 $130,092.71 30.44% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $48,453 $20,781 $27,672 42.89% $43,253 $18,025 $25,228.00 41.67% 94 - Debt Service $0 $0 $0 0.00% $0 $0 $0.00 0.00%
95 - Operat Transfer Out $125,000 $0 $125,000 0.00% $25,699 $2,169 $23,530.00 8.44% 215 - Bikeways Fund $90,000 $34,190 $55,810 37.99% $80,000 $21,259 $58,741.00 26.57% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $90,000 $34,190 $55,810 37.99% $80,000 $21,259 $58,741.00 26.57% 216 - Air Quality Improvement Fund $172,388 $630 $171,758 0.37% $172,388 $8,150 $164,238.00 4.73% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0.00 0.00%
91 - Services & Supplies $172,388 $630 $171,758 0.37% $172,388 $8,150 $164,238.00 4.73% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 217 - South Lake Parking Operating F $570,530 $253,184 $317,346 44.38% $524,009 $111,902 $412,107.18 21.35% 90 - Personnel $136,476 $51,216 $85,260 37.53% $138,885 $65,366 $73,519.75 47.06% 91 - Services & Supplies $359,940 $181,782 $178,158 50.50% $335,157 $38,424 $296,733.43 11.46% 93 - Internal Srvc Chrg $49,967 $8,113 $41,854 16.24% $49,967 $8,113 $41,854.00 16.24% 95 - Operat Transfer Out $24,147 $12,073 $12,074 50.00% $0 $0 $0.00 0.00% 218 - Library Special Tax Fund $2,900,213 $1,208,425 $1,691,788 41.67% $2,843,371 $1,184,735 $1,658,636.00 41.67% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $2,900,213 $1,208,425 $1,691,788 41.67% $2,843,371 $1,184,735 $1,658,636.00 41.67% 219 - Community Develop Block Grant $4,796,269 $1,660,557 $3,135,712 34.62% $3,159,303 $585,964 $2,573,338.67 18.55% 90 - Personnel $561,259 $227,443 $333,816 40.52% $431,806 $163,324 $268,482.38 37.82% 91 - Services & Supplies $3,714,017 $1,027,302 $2,686,715 27.66% $2,206,504 $23,243 $2,183,261.79 1.05% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $80,992 $34,185 $46,807 42.21% $80,992 $31,596 $49,396.00 39.01% 94 - Debt Service $440,000 $371,627 $68,374 84.46% $440,000 $367,802 $72,198.50 83.59% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 220 - Rental Assistance Programs Fnd $16,344,815 $8,163,837 $8,180,979 49.95% $17,729,061 $8,625,491 $9,103,569.44 48.65% 90 - Personnel $1,300,926 $563,499 $737,427 43.32% $1,315,117 $552,256 $762,860.84 41.99% 91 - Services & Supplies $14,825,714 $7,513,159 $7,312,555 50.68% $16,155,769 $7,988,326 $8,167,443.34 49.45% 92 - Capital Outlay $0 $0 $0 0.00% $40,000 $0 $40,000.00 0.00% 93 - Internal Srvc Chrg $218,175 $87,178 $130,997 39.96% $218,175 $84,910 $133,265.26 38.92% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% Created on 12/23/2021 Page 4 of 10

Page 60 ends

City of Pasadena
Expenditures
By Fund
November 2021

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 221 - Home Investment Partnership Fd $917,946 $58,275 $859,671 6.35% $958,827 $43,434 $915,393.84 4.53% 90 - Personnel $62,167 $53,308 $8,858 85.75% $72,312 $42,917 $29,395.02 59.35% 91 - Services & Supplies $855,779 $4,967 $850,812 0.58% $886,515 $516 $885,998.82 0.06% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 222 - Housing Assistance Fund $0 $0 $0 0.00% $0 $0 $0.00 0.00% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0.00 0.00%
91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 223 - Supportive Housing Prog. (SHP) $3,856,288 $680,503 $3,175,785 17.65% $3,803,315 $897,744 $2,905,571.01 23.60% 90 - Personnel $321,973 $70,195 $251,778 21.80% $349,541 $213,358 $136,182.37 61.04% 91 - Services & Supplies $3,533,955 $610,308 $2,923,647 17.27% $3,453,414 $684,385 $2,769,028.64 19.82% 93 - Internal Srvc Chrg $360 $0 $360 0.00% $360 $0 $360.00 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 224 - Emergency Shelter Grant -ESG $4,157,461 $87,605 $4,069,856 2.11% $2,049,472 $85,607 $1,963,865.07 4.18% 90 - Personnel $117,320 $63,780 $53,540 54.36% $118,319 $48,478 $69,841.00 40.97% 91 - Services & Supplies $4,040,141 $23,824 $4,016,317 0.59% $1,711,153 $37,129 $1,674,024.07 2.17% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $220,000 $0 $220,000.00 0.00% 225 - West Gateway Parking Meter Fd $19,555 $5,297 $14,258 27.09% $19,881 $6,449 $13,432.48 32.44% 90 - Personnel $10,443 $3,784 $6,659 36.23% $10,724 $4,743 $5,981.34 44.23% 91 - Services & Supplies $9,112 $1,513 $7,599 16.61% $9,157 $1,706 $7,451.14 18.63% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0.00 0.00% 226 - HOPWA Fund $187,053 $72,949 $114,104 39.00% $186,281 $25,612 $160,669.81 13.75% 90 - Personnel $20,738 $6,615 $14,123 31.90% $21,088 $9,449 $11,638.18 44.81% 91 - Services & Supplies $166,315 $66,334 $99,981 39.88% $165,194 $16,162 $149,031.63 9.78% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 228 - Misc Public Safety Grants Fund $0 $0 $0 0.00% $0 $0 $0.00 0.00% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 229 - Playhouse Parking Fund $15,853 $4,560 $11,293 28.76% $15,390 $5,378 $10,011.38 34.95% 90 - Personnel $10,437 $3,851 $6,586 36.90% $10,724 $4,312 $6,412.48 40.21% 91 - Services & Supplies $5,415 $708 $4,707 13.08% $4,665 $1,066 $3,598.90 22.86% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% Created on 12/23/2021 Page 5 of 10

Page 61 ends

City of Pasadena
Expenditures
By Fund
November 2021

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 230 - Homeland Security Grant Fund $211,589 $6,407 $205,182 3.03% $696,956 $74,152 $622,804.43 10.64% 90 - Personnel $25,000 $5,597 $19,403 22.39% $24,400 $0 $24,400.00 0.00% 91 - Services & Supplies $106,152 $810 $105,342 0.76% $310,962 $5,500 $305,462.00 1.77% 92 - Capital Outlay $80,437 $0 $80,437 0.00% $361,594 $68,652 $292,942.43 18.99% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 232 - So. Lake Parking Meter Zone Fd $215,053 $41,933 $173,120 19.50% $763,519 $63,908 $699,611.83 8.37% 90 - Personnel $72,938 $22,572 $50,366 30.95% $74,404 $28,702 $45,702.22 38.58% 91 - Services & Supplies $123,507 $11,036 $112,471 8.94% $93,008 $20,174 $72,833.61 21.69% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $18,608 $7,751 $10,857 41.65% $18,608 $7,751 $10,857.00 41.65% 95 - Operat Transfer Out $0 $575 -$575 0.00% $577,500 $7,281 $570,219.00 1.26% 233 - Sewer Facility Charge Fund $1,500,000 $79,504 $1,420,496 5.30% $1,000,000 $3,315 $996,685.00 0.33% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $1,500,000 $79,504 $1,420,496 5.30% $1,000,000 $3,315 $996,685.00 0.33% 234 - Prop 1B-LocalStrs&Roads Imprvm $0 $0 $0 0.00% $0 $0 $0.00 0.00% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 236 - Measure R Transportation Fnd $1,918,724 $799,980 $1,118,744 41.69% $1,819,664 $758,191 $1,061,473.00 41.67% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0.00 0.00%
91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $1,918,724 $799,980 $1,118,744 41.69% $1,819,664 $758,191 $1,061,473.00 41.67% 237 - Low and Mod Inc Housing Asset $3,824,862 $114,322 $3,710,540 2.99% $4,341,619 $1,108,970 $3,232,649.57 25.54% 90 - Personnel $121,037 $69,054 $51,984 57.05% $122,199 $60,770 $61,428.73 49.73% 91 - Services & Supplies $3,703,824 $39,202 $3,664,622 1.06% $4,219,420 $1,048,199 $3,171,220.84 24.84% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $0 $6,066 -$6,066 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 97 - Non-Op Expense $0 $0 $0 0.00% $0 $0 $0.00 0.00%
238 - Other Housing Funds $5,215,820 $649,309 $4,566,511 12.45% $4,934,697 $628,929 $4,305,768.35 12.75% 90 - Personnel $965,514 $414,638 $550,875 42.94% $1,017,935 $398,569 $619,365.42 39.15% 91 - Services & Supplies $4,067,456 $135,031 $3,932,426 3.32% $3,524,413 $160,822 $3,363,590.57 4.56% 92 - Capital Outlay $3,000 $28,055 -$25,055 935.18% $213,000 $0 $213,000.00 0.00% 93 - Internal Srvc Chrg $179,850 $71,584 $108,266 39.80% $179,350 $69,537 $109,812.36 38.77% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 97 - Non-Op Expense $0 $0 $0 0.00% $0 $0 $0.00 0.00%
Created on 12/23/2021 Page 6 of 10

Page 62 ends

City of Pasadena
Expenditures
By Fund
November 2021

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 239 - Inclusionary Housing Trust Fun $1,886,632 $156,692 $1,729,940 8.31% $4,131,335 $3,133,480 $997,854.77 75.85% 90 - Personnel $261,931 $132,901 $129,030 50.74% $253,873 $84,266 $169,606.74 33.19% 91 - Services & Supplies $1,624,701 $23,791 $1,600,910 1.46% $3,877,461 $3,049,246 $828,215.03 78.64% 92 - Capital Outlay $0 $0 $0 0.00% $0 -$33 $33.00 0.00% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 97 - Non-Op Expense $0 $0 $0 0.00% $0 $0 $0.00 0.00%
241 - Rd Maint and Rehab Acct (RMRA) $2,800,000 $1,928,528 $871,472 68.88% $3,200,000 $120,181 $3,079,819.00 3.76% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0.00 0.00%
91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $2,800,000 $1,928,528 $871,472 68.88% $3,200,000 $120,181 $3,079,819.00 3.76% 242 - Measure M Local Return Fund $2,174,329 $922,796 $1,251,533 42.44% $2,062,286 $861,275 $1,201,011.00 41.76% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0.00 0.00%
91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $2,174,329 $922,796 $1,251,533 42.44% $2,062,286 $861,275 $1,201,011.00 41.76% 301 - Project Management Fund $9,349,413 $316,812 $9,032,601 3.39% $9,301,873 $311,395 $8,990,478.29 3.35% 90 - Personnel $8,664,006 $656,538 $8,007,468 7.58% $8,543,748 $524,344 $8,019,404.44 6.14% 91 - Services & Supplies $165,731 -$552,204 $717,935 -333.19% $238,449 -$419,396 $657,845.55 -175.88% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $519,676 $212,478 $307,198 40.89% $519,676 $206,447 $313,228.30 39.73% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 96 - Operating Expense $0 $0 $0 0.00% $0 $0 $0.00 0.00% 310 - Capital Public Art Fund $20,000 $0 $20,000 0.00% $20,000 $0 $20,000.00 0.00% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0.00 0.00%
91 - Services & Supplies $20,000 $0 $20,000 0.00% $20,000 $0 $20,000.00 0.00% 93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 313 - Traffic Reduction Trans Improv $874,000 $424,437 $449,563 48.56% $325,000 $194,472 $130,528.00 59.84% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0.00 0.00%
91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $874,000 $424,437 $449,563 48.56% $325,000 $194,472 $130,528.00 59.84% 405 - Plaza Las Fuentes Parking Fund $0 $0 $0 0.00% $0 $0 $0.00 0.00% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% Created on 12/23/2021 Page 7 of 10

Page 63 ends

City of Pasadena
Expenditures
By Fund
November 2021

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 406 - Refuse Collection Fund $22,244,305 $7,854,955 $14,389,350 35.31% $22,970,377 $7,111,353 $15,859,024.70 30.96% 90 - Personnel $7,717,207 $3,128,432 $4,588,775 40.54% $7,740,139 $2,991,259 $4,748,879.96 38.65% 91 - Services & Supplies $7,699,411 $2,449,305 $5,250,106 31.81% $7,688,003 $2,348,826 $5,339,177.04 30.55% 92 - Capital Outlay $3,059,038 $0 $3,059,038 0.00% $3,773,586 $500,434 $3,273,152.00 13.26% 93 - Internal Srvc Chrg $3,570,409 $1,867,468 $1,702,940 52.30% $3,570,409 $1,188,233 $2,382,175.70 33.28% 94 - Debt Service $0 $0 $0 0.00% $0 $0 $0.00 0.00%
95 - Operat Transfer Out $198,240 $82,600 $115,640 41.67% $198,240 $82,600 $115,640.00 41.67% 96 - Operating Expense $0 $327,150 -$327,150 0.00% $0 $0 $0.00 0.00% 407 - Off-Street Parking Facilities $17,610,110 $4,269,818 $13,340,292 24.25% $14,113,501 $3,169,443 $10,944,058.09 22.46% 90 - Personnel $1,147,732 $437,744 $709,988 38.14% $1,139,878 $465,851 $674,026.55 40.87% 91 - Services & Supplies $12,600,958 $2,549,719 $10,051,240 20.23% $10,241,002 $2,460,697 $7,780,305.20 24.03% 92 - Capital Outlay $866,141 $308,735 $557,406 35.64% $0 $0 $0.00 0.00% 93 - Internal Srvc Chrg $579,903 $207,819 $372,085 35.84% $457,903 $171,122 $286,781.30 37.37% 94 - Debt Service $643,781 $97,552 $546,229 15.15% $415,214 $37,178 $378,036.04 8.95% 95 - Operat Transfer Out $0 $0 $0 0.00% $83,000 $34,595 $48,405.00 41.68% 96 - Operating Expense $1,771,595 $668,250 $1,103,345 37.72% $1,776,504 $0 $1,776,504.00 0.00% 408 - Telecommunications Fund $676,230 $254,256 $421,974 37.60% $726,430 $157,266 $569,164.00 21.65% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0.00 0.00%
91 - Services & Supplies $69,000 $19,458 $49,542 28.20% $69,000 $0 $69,000.00 0.00% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $2,430 $1,016 $1,414 41.80% $2,430 $1,016 $1,414.00 41.80% 95 - Operat Transfer Out $445,000 $171,621 $273,379 38.57% $475,000 $156,250 $318,750.00 32.89% 96 - Operating Expense $159,800 $62,161 $97,639 38.90% $180,000 $0 $180,000.00 0.00% 409 - Paseo Colo Parking Structures $0 $0 $0 0.00% $0 $0 $0.00 0.00% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 501 - Computing and Communication Fd $20,681,857 $8,473,197 $12,208,660 40.97% $21,012,706 $6,820,796 $14,191,910.40 32.46% 90 - Personnel $11,645,749 $4,916,393 $6,729,356 42.22% $11,964,077 $4,668,809 $7,295,268.50 39.02% 91 - Services & Supplies $5,290,043 $2,398,372 $2,891,671 45.34% $5,322,762 $1,682,680 $3,640,082.23 31.61% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $1,150,866 $485,863 $665,003 42.22% $1,150,866 $462,678 $688,188.67 40.20% 94 - Debt Service $0 $0 $0 0.00% $0 $0 $0.00 0.00%
95 - Operat Transfer Out $1,275,000 $139,966 $1,135,034 10.98% $1,275,000 $6,629 $1,268,371.00 0.52% 96 - Operating Expense $1,320,200 $532,603 $787,597 40.34% $1,300,000 $0 $1,300,000.00 0.00% 502 - Building Maintenance Fund $14,081,735 $5,820,099 $8,261,636 41.33% $16,583,489 $4,911,637 $11,671,852.59 29.62% 90 - Personnel $5,528,320 $2,372,866 $3,155,454 42.92% $5,590,769 $2,199,928 $3,390,840.64 39.35% 91 - Services & Supplies $6,210,361 $2,296,344 $3,914,017 36.98% $6,439,666 $2,055,338 $4,384,328.64 31.92% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $1,257,054 $521,697 $735,358 41.50% $1,257,054 $509,649 $747,405.31 40.54% 95 - Operat Transfer Out $1,086,000 $628,730 $457,270 57.89% $3,296,000 $146,722 $3,149,278.00 4.45% 96 - Operating Expense $0 $462 -$462 0.00% $0 $0 $0.00 0.00% Created on 12/23/2021 Page 8 of 10

Page 64 ends

City of Pasadena
Expenditures
By Fund
November 2021

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 503 - Fleet Replacement Fund $3,631,899 $1,108,292 $2,523,607 30.52% $8,761,588 $1,084,810 $7,676,777.69 12.38% 90 - Personnel $228,522 $49,352 $179,170 21.60% $300,630 $88,853 $211,777.10 29.56% 91 - Services & Supplies $139,835 $69,665 $70,170 49.82% $443,467 $57,290 $386,177.46 12.92% 92 - Capital Outlay $3,009,066 $476,749 $2,532,316 15.84% $7,935,332 $926,731 $7,008,600.69 11.68% 93 - Internal Srvc Chrg $28,651 $11,935 $16,716 41.66% $82,157 $11,935 $70,222.44 14.53% 95 - Operat Transfer Out $225,826 $0 $225,826 0.00% $0 $0 $0.00 0.00% 96 - Operating Expense $0 $500,591 -$500,591 0.00% $0 $0 $0.00 0.00% 504 - Benefits and Insurance Fund $1,097,249 $459,847 $637,402 41.91% $1,115,726 $451,505 $664,221.04 40.47% 90 - Personnel $736,218 $360,658 $375,560 48.99% $752,388 $342,573 $409,815.19 45.53% 91 - Services & Supplies $220,695 $41,349 $179,345 18.74% $223,002 $51,093 $171,908.85 22.91% 93 - Internal Srvc Chrg $140,337 $57,840 $82,497 41.21% $140,337 $57,840 $82,497.00 41.21% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 506 - Worker's Compensation Fund $2,525,789 $750,838 $1,774,951 29.73% $2,547,526 $697,593 $1,849,932.45 27.38% 90 - Personnel $955,900 $367,420 $588,480 38.44% $974,700 $369,750 $604,950.16 37.93% 91 - Services & Supplies $1,358,599 $298,285 $1,060,314 21.96% $1,361,535 $242,725 $1,118,810.29 17.83% 93 - Internal Srvc Chrg $211,291 $85,133 $126,157 40.29% $211,291 $85,119 $126,172.00 40.29% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 507 - General Liability Fund $630,821 $163,542 $467,278 25.93% $504,063 $160,256 $343,806.96 31.79% 90 - Personnel $286,151 $132,956 $153,194 46.46% $290,996 $129,202 $161,794.34 44.40% 91 - Services & Supplies $274,954 $1,919 $273,034 0.70% $143,351 $2,388 $140,963.20 1.67% 93 - Internal Srvc Chrg $69,716 $28,667 $41,049 41.12% $69,716 $28,667 $41,049.42 41.12% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 508 - Printing Services Fund $0 $0 $0 0.00% $0 $0 $0.00 0.00% 90 - Personnel $0 $0 $0 0.00% $0 $0 $0.00 0.00%
91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $0 $0 $0 0.00% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 96 - Operating Expense $0 $0 $0 0.00% $0 $0 $0.00 0.00% 510 - Citizen Service Center Fund $836,692 $358,125 $478,567 42.80% $868,392 $328,757 $539,634.66 37.86% 90 - Personnel $664,121 $298,500 $365,621 44.95% $693,304 $263,171 $430,132.72 37.96% 91 - Services & Supplies $59,241 $15,315 $43,926 25.85% $61,758 $22,746 $39,011.94 36.83% 93 - Internal Srvc Chrg $113,330 $44,310 $69,020 39.10% $113,330 $42,840 $70,490.00 37.80% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% Created on 12/23/2021 Page 9 of 10

Page 65 ends

City of Pasadena
Expenditures
By Fund
November 2021

UNAUDITED
2021 2022
Fund Revised Budget Actual - YTD Remaining % Used Revised Budget Actual - YTD Remaining % Used 511 - Fleet Repair and Maintenance $8,942,923 $2,566,634 $6,376,289 28.70% $8,915,981 $3,416,719 $5,499,261.51 38.32% 90 - Personnel $2,744,038 $1,140,546 $1,603,492 41.56% $2,706,714 $1,070,432 $1,636,281.79 39.55% 91 - Services & Supplies $5,362,112 $1,069,327 $4,292,785 19.94% $5,369,423 $1,991,556 $3,377,866.44 37.09% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
93 - Internal Srvc Chrg $836,773 $354,989 $481,784 42.42% $839,845 $354,731 $485,113.28 42.24% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 96 - Operating Expense $0 $1,772 -$1,772 0.00% $0 $0 $0.00 0.00% 613 - Cultural Trust Fund $961,648 $52,204 $909,444 5.43% $362,108 $33,380 $328,728.54 9.22% 90 - Personnel $36,646 $14,791 $21,856 40.36% $37,106 $7,284 $29,821.73 19.63% 91 - Services & Supplies $896,784 $25,652 $871,132 2.86% $296,784 $14,334 $282,449.81 4.83% 93 - Internal Srvc Chrg $28,218 $11,761 $16,457 41.68% $28,218 $11,761 $16,457.00 41.68% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 677 - Library Equip Repl-Pasadena $0 $0 $0 0.00% $0 $0 $0.00 0.00% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 678 - Library Equip Repl-Glendale $0 $0 $0 0.00% $0 $0 $0.00 0.00% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 679 - Library Equip Repl-Shared $0 $0 $0 0.00% $0 $0 $0.00 0.00% 91 - Services & Supplies $0 $0 $0 0.00% $0 $0 $0.00 0.00% 92 - Capital Outlay $0 $0 $0 0.00% $0 $0 $0.00 0.00%
95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 681 - Workforce Innov and Opport Act $6,130,525 $1,410,086 $4,720,439 23.00% $4,950,554 $962,733 $3,987,821.49 19.45% 90 - Personnel $3,129,482 $871,598 $2,257,884 27.85% $2,386,412 $827,146 $1,559,265.35 34.66% 91 - Services & Supplies $2,992,819 $531,363 $2,461,456 17.75% $2,555,919 $135,280 $2,420,639.38 5.29% 93 - Internal Srvc Chrg $8,224 $7,125 $1,099 86.64% $8,224 $307 $7,916.76 3.73% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% 820 - Successor Agency Admin $20,872 $8,618 $12,254 41% $36,297 $0 $36,297.00 0.00% 90 - Personnel $1,319 $450 $869 34.11% $36,297 $0 $36,297.00 0.00% 91 - Services & Supplies $1,101 $482 $619 43.74% $0 $0 $0.00 0.00% 93 - Internal Srvc Chrg $18,452 $7,686 $10,766 41.65% $0 $0 $0.00 0.00% 95 - Operat Transfer Out $0 $0 $0 0.00% $0 $0 $0.00 0.00% Grand Total $539,471,471 $189,196,103 $350,275,367 35.07% $548,486,173 $186,066,615 $362,419,557.96 33.92% Created on 12/23/2021 Page 10 of 10

Page 66 ends

Financial Update – January 2022
Matthew Hawkesworth
Director of Finance
January 10, 2022
Finance Committee Item 4

Page 67 ends

General Fund – Property Tax
2

Page 68 ends

General Fund – Property Tax
3

Page 69 ends

General Fund – Transient Occupancy Tax
• Hotel Trends - N ovember
> Occupancy – 64. 2%
> Average Daily Rate - $178. 35
> Revenue per Available Room - $114. 41
4

Page 70 ends

General Fund – Utility Users’ Tax
• Year over year decreases have slowed and early
F
Y 2022 shows a little growth.
5 Utility Users Tax Fiscal Year
M
onths 2018 2019 2020 2021 2022
July $1,569,061.26 $1,576,814.36 $1,495,452.76 $1,519,346.41 $1,595,738.78 August $2,567,521.81 $2,516,922.24 $2,194,475.98 $2,117,762.99 $2,434,823.85 September $2,866,514.00 $2,798,193.00 $2,773,349.05 $2,633,748.31 $2,731,214.48

Page 71 ends

General Fund Five-Year Forecast
6 FY 2021 F Y 2022 FY 2023 FY 2024 FY 2025 FY 2026
Final Budget Forecast Forecast Forecast Forecast
Beginning Amount Available for Appropriations 462,393 0 0 (114,421) (1,594,121) (1,724,230) Revenues
Tax Revenues 206,586,160 216,790,289 229,617,375 237,289,710 245,021,400 252,745,802 Other Revenues 38,272,188 39,993,028 43,571,804 44,650,894 45,757,731 46,893,041 Contributions/Svs. From Other Funds 21,828,516 29,909,283 21,040,438 21,090,438 20,490,438 20,490,438 Total Revenues 266,686,864 286,692,600 294,229,617 303,031,042 311,269,569 320,129,281 Expens es
Personnel 169,557,325 177,870,499 185,501,184 191,931,439 194,182,102 200,621,591 Debt Service* 19,232,966 21,361,974 16,988,198 17,988,529 19,922,553 20,023,966 Contributions To Other Funds 18,888,138 14,330,434 15,117,043 15,419,384 15,727,771 16,042,327 Other Expenses 68,281,374 73,129,694 76,737,613 79,171,388 81,567,251 84,040,529 Total Expenses 275,959,803 286,692,601 294,344,038 304,510,740 311,399,678 320,728,413 Operating Income/(Loss) (9,272,939) (0) (114,421) (1,479,699) (130,109) (599,132) Ending Amount Available for Appropriations (8,810,546) 0 (114,421) (1,594,120) (1,724,229) (2,323,361) Reserve for Capital & EOC 2,706,441 - - - - - Reduction/(Contribution) to Policy Reserve 6,104,105
Net Income/(Loss) with Reserve Contribution (462,393) (0) (114,421) (1,479,699) (130,109) (599,132) General Fund Five-Year Forecast
* FY 2022 Forecast includes $10.0m contribution to RBOC to cover Debt Service and Amerifest. FY 2023 and beyond includes up to $7.7m in RBOC Debt Service.

Page 72 ends

General Fund Reserves
• Section 115 Trust
> Pension - $13. 4m
> OPEB - $2. 5m
7

Page 73 ends

Finance CommitteeJanuary 10, 2022

Finance Committee
January 10, 2022