Cities Index.
Agenda

Finance Committee
February 14, 2022

Document
Agenda
Meeting
February 14, 2022
Body
Finance Committee
Pages
603
Original file
17.7 MB
Text extracted from the city's file for reading and search. Open the original on www.cityofpasadena.net. That file is the official record.

CITY OF PASADENA, CALIFORNIA

AIR QUALITY IMPROVEMENT SPECIAL REVENUE FUND

BALANCE SHEET
JUNE 30, 2021
See accompan
ying Notes to Financial Statements.
(3)
Governmental
Funds
ASSETS
Cash and Investments 72,131$
Accounts Receivable 48,264
Total Assets 120,395$

LIABILITIES AND FUND BALANCE

LIABILITIES
Accounts Payable 3,310$
Total Liabilities 3,310

FUND BALANCE
Restricted for:

Air Quality Improvements 117,085
Total Fund Balance 117,085
Total Liabilities and Fund Balance 120,395$

Page 465 ends

CITY OF PASADENA, CALIFORNIA

AIR QUALITY IMPROVEMENT SPECIAL REVENUE FUND

STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE YEAR ENDED JUNE 30, 2021
See accompan
ying Notes to Financial Statements.
(4)
Governmental
Funds

REVENUES
Intergovernmental 189,132$
Investment Earnings 1,670
Total Revenues 190,802

EXPENDITURES
Transportation 196,978
Total Expenditures 196,978
NET CHANGE IN FUND BALANCE (6,176)
Fund Balance - Beginning of Year 123,261
FUND BALANCE - END OF YEAR 117,085$

Page 466 ends

CITY OF PASADENA, CALIFORNIA

AIR QUALITY IMPROVEMENT SPECIAL REVENUE FUND

STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE

BUDGET TO ACTUAL
YEAR ENDED JUNE 30, 2021
See accompa
nying Notes to Financial Statements.
(5)
Budget Actual Variance

REVENUES
Intergovernmental 170,000$ 189,132$ 19,132$ Investment Earnings 3,299 1,670 (1,629)
Total Revenues 173,299 190,802 17,503

EXPENDITURES
Transportation 172,388 196,978 (24,590)
Total Expenditures 172,388 196,978 (24,590)

EXCESS OF REVENUES OVER
(UNDER) EXPENDITURES 911 (6,176) (7,087) Fund Balance - Beginning of Year 123,261 123,261 - FUND BALANCE - END OF YEAR 124,172$ 117,085$ (7,087)$

Page 467 ends

CITY OF PASADENA, CALIFORNIA

AIR QUALITY IMPROVEMENT SPECIAL REVENUE FUND

NOTES TO FINANCIAL STATEMENTS
JUNE 30, 2021
(6)
NOTE 1 DESCRIPTION

OF THE REPORTING ENTITY
The City of Pasadena Air Quality Improvement Special Revenue Fund was formed to account for the allocations made by AB 2766 known as the Clean Air Act. The revenue provides a means and incentive for programs to reduce traffic and air pollution. The City performs all administrative and accounting functions. The accounting policies of the Air Quality Improvement Fund are in conformity with generally accepted accounting principles in the United States applicable to governmental units. The Governmental Accounting Standards Board (GASB) is the accepted standard-setting body for establishing accounting and financial reporting principles. These financial statements are exclusively for the Air Quality Improvement Special Revenue Fund and do not purport to, and do not, present fairly the financial position and changes in the financial position of the City of Pasadena.

Complete financial statements of the City can be obtained from the City’s Finance Department.

NOTE 2 SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
Fund Accounting
In order to ensure the proper identification of individual revenue sources and the expenditures made from those revenues, the Air Quality Improvement Special Revenue Fund is organized on the basis of an individual fund which is considered a separate accounting entity. The operations of the fund are accounted for with a separate set of self-balancing accounts. Monies under AB 2766 are accounted for in the Air Quality Improvement Special Revenue Fund.

Measurement Focus and Basis of Accounting
Basis of accounting refers to when revenues and expenditures are recognized in the accounts and reported in the financial statements, regardless of the measurement focus applied. All governmental funds are presented using modified accrual basis of accounting.

Revenues are recognized when they become measurable and available. Measurable means the amount of the transaction can be determined and available means the amount is collectible within the current period or soon enough thereafter (generally sixty days) to be used to pay liabilities in the current period. Amounts which could not be measured or were not available were not accrued as revenue in the current year. Expenditures are also recognized under the modified accrual basis of accounting which means that expenditures are generally recorded at the time liabilities are incurred.

Fund Balances
Governmental fund balance represents the net current assets of each fund. Net current assets generally represent a fund’s cash and receivables, less its liabilities. Portions of a fund’s balance may be restricted for future expenditure.

Page 468 ends

CITY OF PASADENA, CALIFORNIA

AIR QUALITY IMPROVEMENT SPECIAL REVENUE FUND

NOTES TO FINANCIAL STATEMENTS
JUNE 30, 2021
(7)
NOTE 3 CASH AND INVEST
MENTS
Equity in the Cash and Investment Pool of the City of Pasadena The AQMD has no separate bank accounts or investments other than its equity in the cash and investment pool managed by the City. The AQMD has not adopted an investment policy separate from that of the City.

The fair value of the AQMD’s investment in this pool is reported in the accompanying financial statements at amounts based upon the AQMD’s pro rata share of the fair value calculated by the City for the entire City portfolio. The balance available for withdrawal is based on the accounting records maintained by the City.

Disclosures Relating to the Investment Policy, Interest Rate Risk, Credit Risk and Custodial Credit Risk
Additional disclosures related to the investment policy, interest rate risk, credit risk and custodial credit risk are available in the City of Pasadena’s Comprehensive Annual Financial Report.

Page 469 ends

CliftonLarsonAllen LLP
CLAconnect.com

CLA is an independent member of Nexia International, a leading, global network of independent accounting and consulting firms. See nexia.com/member-firm-disclaimer for details. (8)

INDEPENDENT AUDIT
ORS’ REPORT ON COMPLIANCE WITH APPLICABLE

REQUIREMENTS AND ON INTERNAL CONTROL OVER COMPLIANCE
Honorable Mayor and Members of the City Council
of the City of Pasadena, California
Pasadena, California
Compliance
We have audited the City of Pasadena’s (the City) compliance with the applicable provisions of Assembly Bill 2766, Chapter 1705 (Health and Safety Code Sections 44220 through 44247) (AB2766) applicable to the City’s Air Quality Improvement Special Revenue Fund (AQMD Fund) for the year ended June 30, 2021.

Management’s Responsibility
Compliance with the requirements referred to above is the responsibility of City’s management.

Auditors’ Responsibility
Our responsibility is to express an opinion on City’s compliance based on our audit.

We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America; the standards applicable to financial audits contained in Government Auditing Standards issued by the Comptroller General of the United States; and AB2766. Those standards and AB2766 require that we plan and perform the audit to obtain reasonable assurance about whether noncompliance with the compliance requirements referred to above that could have a material effect on the City’s AQMD Fund occurred. An audit includes examining, on a test basis, evidence about City’s compliance with those requirements and performing such other procedures as we considered necessary in the circumstances. We believe that our audit provides a reasonable basis for our opinion.

Our audit does not provide a legal determination of City’s compliance with those requirements.

Opinion
In our opinion, City complied, in all material respects, with the compliance requirements referred to above that are applicable to the AQMD Fund for the year ended June 30, 2021.

Page 470 ends

Honorable Mayor and Members of the City Council
of the City of Pasadena, California
(9)
Internal Control Over Compliance
Management of the City is responsible for establishing and maintaining effective internal control over compliance with the compliance requirements referred to above. In planning and performing our audit, we considered City’s internal control over compliance to determine the auditing procedures for the purpose of expressing our opinion on compliance, but not for the purpose of expressing an opinion on the effectiveness of internal control over compliance. Accordingly, we do not express an opinion on the effectiveness of City’s internal control over compliance.

A deficiency in internal control over compliance exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance on a timely basis. A material weakness in internal control over compliance is a deficiency, or combination of deficiencies in internal control over compliance, such that there is a reasonable possibility that material noncompliance with a compliance requirement will not be prevented, or detected and corrected, on a timely basis.

Our consideration of internal control over compliance was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control that might be deficiencies, significant deficiencies, or material weaknesses in internal control over compliance. We did not identify any deficiencies in internal control over compliance that we consider to be material weaknesses, as defined above.

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

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

CliftonLarsonAllen LLP
Irvine, California
January 19, 2022

Page 471 ends

CliftonLarsonAllen LLP
CLAconnect.com

CLA is an independent member of Nexia International, a leading, global network of independent accounting and consulting firms. See nexia.com/member-firm-disclaimer for details. (10)

INDEPENDENT AUDIT
ORS’ REPORT ON INTERNAL CONTROL OVER

FINANCIAL REPORTING AND ON COMPLIANCE AND OTHER MATTERS

BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE

WITH GOVERNMENT AUDITING STANDARDS
Honorable Mayor and Members of the City Council
of the City of Pasadena, California

Pasadena, California
We have audited, in accordance with the auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards issued by the Comptroller General of the United States, the financial statements of the Air Quality Improvement Special Revenue Fund (AQMD) of the City of Pasadena, California (the City), as of and for the year ended June 30, 2021, and the related notes to financial statements, which collectively comprise the AQMD’s financial statements, and have issued our report thereon dated January 19, 2022.

Internal Control Over Financial Reporting
In planning and performing our audit of the AQMD financial statements, we considered the City’s internal control over financial reporting (internal control) as it relates to the AQMD as a basis for designing audit procedures that are appropriate in the circumstances for the purpose of expressing our opinion on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the City’s internal control related to the AQMD. Accordingly, we do not express an opinion on the effectiveness of the City’s internal control related to the AQMD.

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

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

Page 472 ends

Honorable Mayor and Members of the City Council
of the City of Pasadena, California
(11)
Compliance and Other Matters
As part of obtaining reasonable assurance about whether the Air Quality Improvement Special Revenue Fund of the City of Pasadena, California’s financial statements are free from material misstatements, we performed tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of our audit, and accordingly, we do not express such an opinion.

The results of our tests disclosed no instances of noncompliance or other matters that are required to be reported under Government Auditing Standards.

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

CliftonLarsonAllen LLP
Irvine, California
January 19, 2022

Page 473 ends
Page 474 ends

PASADENA HOUSING SUCCESSOR

CITY OF PASADENA, CALIFORNIA

FINANCIAL STATEMENTS AND

SUPPLEMENTARY INFORMATION
YEAR ENDED JUNE 30, 2021
Attachment H

Page 475 ends

PASADENA HOUSING SUCCESSOR

CITY OF PASADENA, CALIFORNIA

TABLE OF CONTENTS
YEAR ENDED JUNE 30, 2021
INDEPENDENT AUDITORS’ REPORT 1

FINANCIAL STATEMENTS
BALANCE SHEET 4

STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES 5
NOTES TO FINANCIAL STATEMENTS 6

REQUIRED SUPPLEMENTARY INFORMATION
BUDGETARY COMPARISON SCHEDULE 9
NOTES TO REQUIRED SUPPLEMENTARY INFORMATION 10

SUPPLEMENTARY INFORMATION
COMPUTATION OF HOUSING SUCCESSOR EXCESS/SURPLUS 11
INDEPENDENT AUDITORS’ REPORT ON INTERNAL CONTROL OVER

FINANCIAL REPORTING AND ON COMPLIANCE AND OTHER MATTERS

BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN
ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS 12

Page 476 ends

CLA is an independent member of Nexia International, a leading, global network of independent accounting and consulting firms. See nexia.com/member firm disclaimer for details.

CliftonLarsonAllen LLP
CLAconnect.com
(1)
INDEPENDENT AUDITORS’ REPORT
Honorable Mayor and Members of the City Council
of the City of Pasadena, California
Pasadena, California
Report on the Financial Statements
We have audited the accompanying financial statements of the Pasadena Housing Successor (the Housing Successor), a Special Revenue Fund of the City of Pasadena, California, as of and for the year ended June 30, 2021, and the related notes to the financial statements, which collectively comprise the Housing Successor’s financial statements as listed in the table of contents.

Management’s Responsibility for the Financial Statements Management is responsible for the preparation and fair presentation of these financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error.

Auditors’ Responsibility
Our responsibility is to express an opinion on these financial statements based on our audit. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards , issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free from material misstatement.

An audit involves performing procedures to obtain audit evidence about the amounts and disclosures in the financial statements. The procedures selected depend on the auditor’s judgment, including the assessment of the risks of material misstatement of the financial statements, whether due to fraud or error. In making those risk assessments, the auditor considers internal control relevant to the entity’s preparation and fair presentation of the financial statements in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the entity’s internal control. Accordingly, we express no such opinion. An audit also includes evaluating the appropriateness of accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluating the overall presentation of the financial statements.

We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our audit opinion.

Page 477 ends

Honorable Mayor and Members of the City Council
of the City of Pasadena, California
(2)
Opinion
In our opinion, the financial statements referred to above present fairly, in all material respects, the financial position of the special revenue fund of the Pasadena Housing Successor as of June 30, 2021, and the changes in financial position for the year then ended in accordance with accounting principles generally accepted in the United States of America.

Emphasis of Matter
As discussed in Note 1, the financial statements present only the Pasadena Housing Successor Special Revenue Fund and do not purport to, and do not, present fairly the financial position of the City of Pasadena, California, as of June 30, 2021 and the changes in its financial position for the year then ended in accordance with accounting principles generally accepted in the United States of America.

Our opinion is not modified with respect to this matter.

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

Management has omitted the management’s discussion and analysis that accounting principles generally accepted in the United States of America require to be presented to supplement the financial statements. Such missing information, although not a part of the financial statements, is required by the Governmental Accounting Standards Board, who considers it to be an essential part of financial reporting for placing the financial statements in an appropriate operational, economic, or historical context. Our opinion on the financial statements is not affected by this missing information.

Other Information
Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the Housing Successor’s financial statements. The computation of the Housing Successor excess/surplus is presented for purposes of additional analysis and is not a required part of the basic financial statements.

Page 478 ends

Honorable Mayor and Members of the City Council
of the City of Pasadena, California
(3)
The computation of the Housing Successor excess/surplus is the responsibility of management and was derived from and relates directly to the underlying accounting and other records used to prepare the basic financial statements. Such information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or to the basic financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the computation of the Housing Successor excess/surplus is fairly stated, in all material respects, in relation to the basic financial statements as a whole.

The computation of the Housing Successor excess/surplus has not been subjected to the auditing procedures applied in the audit of the basic financial statements, and accordingly, we do not express an opinion or provide any assurance on it.

Other Reporting Required by Government Auditing Standards In accordance with Government Auditing Standards , we have also issued our report dated December 30, 2021, on our consideration of the Housing Successor’s internal control over financial reporting and on our tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements and other matters. The purpose of that report is solely to describe the scope of our testing of internal control over financial reporting and compliance and the results of that testing, and not to provide an opinion on the effectiveness of the Housing Successor’s internal control over financial reporting or on compliance. That report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the Housing Successor’s internal control over financial reporting and compliance.

CliftonLarsonAllen LLP
Irvine, California
December 30, 2021

Page 479 ends

PASADENA HOUSING SUCCESSOR

CITY OF PASADENA, CALIFORNIA

BALANCE SHEET
JUNE 30, 2021
See accompanying Notes to Financial Statements.
(4)
Housing
Successor
Fund
ASSETS
Cash and Investments 6,918,142$
Receivables:

Accounts 4,249
Notes 21,340,218
Allowance for Uncollectible Notes (21,340,218)
Total Assets 6,922,391$

LIABILITIES AND FUND BALANCE

LIABILITIES
Accounts Payable and Accrued Liabilities 38,521$
Total Liabilities 38,521

FUND BALANCE
Restricted for Affordable Housing 6,883,870
Total Fund Balance 6,883,870
Total Liabilities and Fund Balance 6,922,391$

Page 480 ends

PASADENA HOUSING SUCCESSOR

CITY OF PASADENA, CALIFORNIA

STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES YEAR ENDED JUNE 30, 2021
See accompanying Notes to Financial Statements.
(5)
Housing
Successor
Fund

REVENUES
Investment Earning 5,223$
Rental Income 61,741
Charges for Service 90
Miscellaneous Revenue 298,958
Total Revenues 366,012

EXPENDITURES
Housing 515,323
Total Expenditures 515,323
NET CHANGE IN FUND BALANCE (149,311)
Fund Balance - Beginning of Year 7,033,181
FUND BALANCE - END OF YEAR 6,883,870$

Page 481 ends

PASADENA HOUSING SUCCESSOR

CITY OF PASADENA, CALIFORNIA

NOTES TO FINANCIAL STATEMENTS
JUNE 30, 2021
(6)
NOTE 1 SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
Financial Reporting Entity
The accompanying financial statements present only the Pasadena Housing Successor, a Special Revenue Fund of the City of Pasadena, California (the City) and do not include any other funds of the City. These financial statements are exclusively for the Pasadena Housing Successor and do not purport to, and do not, present fairly the financial position and changes in the financial position of the City. The City’s financial statements are available at City Hall.

On December 29, 2011, the California Supreme Court upheld Assembly Bill 1X 26 (the Bill) that provides for the dissolution of all redevelopment agencies in the state of California. The Bill impacted the reporting entity of the City of Pasadena that previously had reported a redevelopment agency within the report entity of the City as a blended component unit.

On February 11, 2013, and in accordance with California Health and Safety Code Section 34176, City Council of Pasadena elected that the City retain the housing assets and housing function of the former redevelopment agency. The City continues to report the housing assets and functions in the government special revenue fund designated City Housing Successor.

The Housing Successor accounts for transactions related to affordable housing activities.

Revenues include bond proceeds held by the Pasadena Successor Agency that were transferred for use into this fund for affordable housing activities, contributions from the City of Pasadena, investment earnings, rental income, loan repayments, and interest income.

Basis of Presentation
The Housing Successor’s fund financial statements are prepared in conformity with accounting principles generally accepted in the United States of America. The Government Accounting Standards Board is the acknowledged standard setting body for establishing accounting and financial reporting standards followed by governmental entities in the United States of America.

Measurement Focus, Basis of Accounting, and Financial Statement Presentation In the fund financial statements, governmental funds are presented using the modified accrual basis of accounting. Their revenues are recognized when they become measurable and available as net current assets. Measurable means that the amounts can be estimated, or otherwise determined. Available means that the amounts were collected during the reporting period or soon enough thereafter to be available to finance the expenditures accrued for the reporting period. The Housing Successor uses a sixty-day availability period.

The Housing Successor accrues the following revenue type: investment earnings.

Page 482 ends

PASADENA HOUSING SUCCESSOR

CITY OF PASADENA, CALIFORNIA

NOTES TO FINANCIAL STATEMENTS
JUNE 30, 2021
(7)
NOTE 1 SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (CONTINUED) Assets, Liabilities and Fund Balance
Cash and Investments
Investments are reported in the accompanying financial statements at fair value based on quoted market prices, except for certain certificates of deposit, money market investments that mature within one year of acquisition and investment contracts that are reported at cost because they are not transferable, they have terms that are not affected by changes in market interest rates, and provided that the fair value of those investments is not significantly affected by the impairment of the credit standing of the issuer or by other factors.

Both realized and unrealized changes in fair value that occur during a fiscal year are recognized and recorded as net changes in fair value of investments. Investment earnings include net changes in fair value of investments, interest earnings and all other investment income.

The City pools cash and investments of all funds, except for certain fund specific City-held portfolios, deferred compensation assets, and assets held by fiscal agents. The Successor Housing fund’s share in this pool is displayed in the accompanying financial statements as cash and investments. Investment income earned by the pooled investments is allocated to the various funds based on each fund’s average cash and investment balance.

Fund Balance
In the fund financial statements, The Housing Successor fund balance is made up of the following components:

Restricted fund balance is the portion of fund balance that is subject to externally enforceable limitations by law, enabling legislation or limitations imposed by creditors or grantors.

NOTE 2 CASH AND INVESTMENTS
As of June 30, 2021, the cash and investments reported in the accompanying financial statements are comprised as follows:

Equity in Pasadena Cash and Investment Pool 6,918,142$
Total Cash and Investments 6,918,142$

Page 483 ends

PASADENA HOUSING SUCCESSOR

CITY OF PASADENA, CALIFORNIA

NOTES TO FINANCIAL STATEMENTS
JUNE 30, 2021
(8)
NOTE 2 CASH AND INVESTMENTS (CONTINUED)
Equity in the Cash and Investment Pool of the City of Pasadena The Housing Successor has no separate bank accounts or investments other than its equity in the cash and investment pool managed by the City. This pool is governed by and under the regulatory oversight of the Investment Policy adopted by the City Council of the City.

The Housing Successor has not adopted an investment policy separate from that of the City.

The fair value of the Housing Successor’s investment in this pool is reported in the accompanying financial statements at amounts based upon the Housing Successor’s pro rata share of the fair value calculated by the City for the entire City portfolio. The balance available for withdrawal is based on the accounting records maintained by the City.

Disclosures Relating to the Investment Policy, Interest Rate Risk, Credit Risk, and Custodial Credit Risk
Additional disclosures related to the investment policy, interest rate risk, credit risk and custodial credit risk are available in the City of Pasadena’s Comprehensive Annual Financial Report.

NOTE 3 NOTES RECEIVABLE
The City of Pasadena Housing Successor made loans to assist in the development of affordable housing projects and the purchase of homes by homebuyers. These loans are secured by trust deeds and were funded with redevelopment low-moderate income housing set-aside funds. These notes have various terms, including maturities ranging from 5 to 45 years and interest ranging from 1.5% to 11%. At June 30, 2021, the long term receivable balance was $21,340,218. Due to the uncertainty of their collectability at June 30, 2021, the City has recorded an allowance for uncollectible note balances of $21,340,218.

Page 484 ends

PASADENA HOUSING SUCCESSOR

CITY OF PASADENA, CALIFORNIA

BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2021
See accompanying Notes to Required Supplementary Information. (9)
Variance with
Final Budget
Actual Positive
Original Final Amounts (Negative)
BUDGETARY FUND BALANCE - JULY 1, 2020 7,033,181$ 7,033,181$ 7,033,181$ -$ Resources (Inflows):

Investment Earnings - - 5,223 5,223
Rental Income 12,660 12,660 61,741 49,081
Charges for Service - - 90 90
Miscellaneous Revenue 169,494 169,494 298,958 129,464 Total Amounts Available for
Appropriations 182,154 182,154 366,012 183,858
Charges to Appropriations (Outflows):

Housing 3,771,309 3,824,862 515,323 3,309,539
Total Charges to Appropriations 3,771,309 3,824,862 515,323 3,309,539 BUDGETARY FUND BALANCE - JUNE 30, 2021 3,444,026$ 3,390,473$ 6,883,870$ 3,493,397$ Budget Amounts

Page 485 ends

PASADENA HOUSING SUCCESSOR

CITY OF PASADENA, CALIFORNIA

NOTE TO REQUIRED SUPPLEMENTARY INFORMATION
JUNE 30, 2021
(10)
NOTE 1 BUDGET
The City Council is required to adopt an annual budget resolution by June 30 of each fiscal year for the Pasadena Housing Successor. The budget is adopted on a basis that does not differ materially from accounting principles generally accepted in the United States of America.

The City maintains budgetary controls to ensure compliance with legal provisions embodied in the appropriated budget approved by the City Council. The level of budgetary control (the level at which expenditures cannot legally exceed the appropriated amount) is the department level and within a single fund. The City Manager may authorize transfers of appropriations within a department so long as it is within a single fund. Supplemental appropriations during the year must be approved by the City Council. All unencumbered appropriations lapse at fiscal year-end. In order to be an encumbered appropriation, there must be either an approved purchase order or contract in force as of June 30.

Page 486 ends

Honorable Mayor and Members of the City Council
of the City of Pasadena, California
(11)
Opening Fund Balance 6,883,870$
Less Unavailable Amounts: (4,218,165)$
Amount Committed to Heritage Square South Project (3,218,165) Amount committed to Salvation Army HOPE Center Apts (1,000,000) Available Housing Successor Funds 2,665,705$
Limitation (Greater of $1,000,000 or Four Years Deposits) Aggregate amount deposited for last four years: **
2019 - 2020 1,443,006$
2018 - 2019 848,443
2017 - 2018 1,294,310
2016 - 2017 1,400,435
Total 4,986,194$
Base Limitation 1,000,000$
Greater amount 4,986,194$
Computed Excess/Surplus -$ *
* This is the projected excess/surplus for Fiscal Year beginning July 1, 2021. Please note: If a housing successor has an excess surplus, the housing successor shall encumber the excess surplus for purposes described in paragraph (3) of subdivision (a) of Health and Safety Code 34176.1 or transfer the funds pursuant to paragraph (2) subdivision (c) of 34176.1 within three fiscal years. If the housing successor fails to comply with this subdivision, the housing successor, within 90 days of the end of the third fiscal year, shall transfer any excess surplus to the Department of Housing and Community Development for expenditure pursuant to the Multifamily Housing Program or the Joe Serna, Jr.

Farmworker Housing Grant Program.
** The City has decided to change the preceding four years to the last four fiscal years without the current fiscal year, as advised by legal counsel, starting from FY 2020.

July 1, 2021
Low and Moderate Housing Funds
All Project Area
(Projected)

Page 487 ends

CLA is an independent member of Nexia International, a leading, global network of independent accounting and consulting firms. See nexia.com/member firm disclaimer for details.

CliftonLarsonAllen LLP
CLAconnect.com
(12)
INDEPENDENT AUDITORS’ REPORT ON INTERNAL CONTROL OVER

FINANCIAL REPORTING AND ON COMPLIANCE AND OTHER MATTERS

BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH
Honorable Mayor and Members of the City Council
of the City of Pasadena, California
Pasadena, California
We have audited, in accordance with the auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States, the financial statements of the Pasadena Housing Successor Special Revenue Fund (Housing Successor) of the City of Pasadena, California (the City), as of and for the year ended June 30, 2021 and the related notes to the financial statements, which collectively comprise the Housing Successor’s financial statements, and have issued our report thereon dated December 30, 2021.

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

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

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

Page 488 ends

Honorable Mayor and Members of the City Council
of the City of Pasadena, California
(13)
Compliance and Other Matters
As part of obtaining reasonable assurance about whether the Housing Successor Special Revenue Fund of the City of Pasadena, California’s financial statements are free from material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts and grant agreements, noncompliance with which could have a direct and material effect on the Housing Successor’s financial statements. However, providing an opinion on compliance with those provisions was not an objective of our audit, and accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance or other matters that are required to be reported under Government Auditing Standards.

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

CliftonLarsonAllen LLP
Irvine, California
December 30, 2021

Page 489 ends

FOOTHILL WORKFORCE DEVELOPMENT BOAR
D

CITY OF PASADENA, CALIFORNIA

FINANCIAL STATEMENTS
YEAR ENDED JUNE 30, 2021
Attachment I

Page 490 ends

FOOTHILL WORKFORCE DEVELOPMENT BOARD

CITY OF PASADENA, CALIFORNIA

TABLE OF CONTENTS
YEAR ENDED JUNE 30, 2021
INDEPENDENT AUDITORS’ REPORT 1

FINANCIAL STATEMENT
S

GOVERNMENT-WIDE FINANCIAL STATEMENTS
STATEMENT OF NET POSITION 3
STATEMENT OF ACTIVITIES 4
FUND FINANCIAL STATEMENTS 5
BALANCE SHEET 5

RECONCILIATION OF THE GENERAL FUND BALANCE SHEET TO THE STATEMENT OF NET POSITION 6

STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN
FUND BALANCES 7

RECONCILIATION OF THE STATEMENT OF REVENUES,

EXPENDITURES, AND CHANGES IN FUND BALANCESTO THE
STATEMENT OF ACTIVITIES 8
NOTES TO FINANCIAL STATEMENTS 9

REQUIRED SUPPLEMENTARY INFORMATION
BUDGETARY COMPARISON SCHEDULE 13
NOTE TO REQUIRED SUPPLEMENTARY INFORMATION 14
INDEPENDENT AUDITORS’ REPORT ON INTERNAL CONTROL OVER

FINANCIAL REPORTING AND ON COMPLIANCE AND OTHER MATTERS

BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN
ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS 15

Page 491 ends

CliftonLarsonAllen LLP
CLAconnect.com

CLA is an independent member of Nexia International, a leading, global network of independent accounting and consulting firms. See nexia.com/member-firm-disclaimer for details. (1)

INDEPENDENT AUDITO
RS’ REPORT
Board of Directors
Foothill Workforce Development Boar
d
Pasadena, California
Report on the Financial Statements
We have audited the accompanying financial statements of the governmental activities and the general fund of the Foothill Workforce Development Board (the Board), as of and for the year ended June 30, 2021, and the related notes to the financial statements, which collectively comprise the Board’s basic financial statements, as listed in the table of contents.

Management’s Responsibility for the Financial Statements Management is responsible for the preparation and fair presentation of these financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error.

Auditors’ Responsibility
Our responsibility is to express opinions on these financial statements based on our audit. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free from material misstatement.

An audit involves performing procedures to obtain audit evidence about the amounts and disclosures in the financial statements. The procedures selected depend on the auditors’ judgment, including the assessment of the risks of material misstatement of the financial statements, whether due to fraud or error. In making those risk assessments, the auditor considers internal control relevant to the Board’s preparation and fair presentation of the financial statements in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the Board’s internal control. Accordingly, we express no such opinion. An audit also includes evaluating the appropriateness of accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluating the overall presentation of the financial statements.

We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our audit opinions.

Page 492 ends

Board of Directors,
Foothill Workforce Development Board
(2)
Opinions
In our opinion, the financial statements referred to above present fairly, in all material respects, the respective financial position of the governmental activities, and General Fund of the Foothill Workforce Development Board, as of June 30, 2021, and the respective changes in financial position for the year then ended in accordance with accounting principles generally accepted in the United States of America.

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

Management has omitted the management’s discussi on and analysis that accounting principles generally accepted in the United States of America require to be presented to supplement the financial statements. Such missing information, although not a part of the financial statements, is required by the Governmental Accounting Standards Board, who cons iders it to be an essential part of financial reporting for placing the financial statements in an appropriate operational, economic, or historical context. Our opinion on the financial statements is not affected by this missing information.

Other Reporting Required by Government Auditing Standards In accordance with Government Auditing Standards, we have also issued our report dated January 19, 2022, on our consideration of the Board’s internal control over financial reporting and on our tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements and other matters. The purpose of that report is solely to describe the scope of our testing of internal control over financial reporting and compliance and the results of that testing, and not to provide an opinion on the effectiveness of the Board’s internal control over financial reporting or on compliance. That report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the Board’s internal control over financial reporting and compliance.

CliftonLarsonAllen LLP
Irvine, California
January 19, 2022

Page 493 ends

FOOTHILL WORKFORCE DEVELOPMENT BOARD

CITY OF PASADENA, CALIFORNIA

STATEMENT OF NET POSITION
JUNE 30, 2021
See accompany
ing Notes to Financial Statements.
(3)
Governmental
Activities

CURRENT ASSETS
Accounts Receivable 469,215$
Other Assets 173
Total Current Assets 469,388

CURRENT LIABILITIES
Accounts Payable 61,169
Due to Other Governments 282,923
Total Current Liabilities 344,092

NET POSITION
Restricted 125,296$

Page 494 ends

FOOTHILL WORKFORCE DEVELOPMENT BOARD

CITY OF PASADENA, CALIFORNIA

STATEMENT OF ACTIVITIES
YEAR ENDED JUNE 30, 2021
See accompa
nying Notes to Financial Statements.
(4)
Net (Expenses)
Revenue and
Program Changes in
Revenues Net Position
Operating
Contributions Governmental
Expenses and Grants Activities

FUNCTIONS/PROGRAMS
Governmental Activities:

Workforce Development 3,675,439 $ 3,921,419 $ 245,980 $ CHANGE IN NET POSITION 245,980
Net Position (Deficit) - Beginning of Year (120,684)
NET POSITION - END OF YEAR 125,296$

Page 495 ends

FOOTHILL WORKFORCE DEVELOPMENT BOARD

CITY OF PASADENA, CALIFORNIA

BALANCE SHEET
JUNE 30, 2021
See accompany
ing Notes to Financial Statements.
(5)
ASSETS
Accounts Receivable 469,215$
Other Assets 173
Total Assets 469,388$

LIABILITIES, DEFERRED INFLOWS OF RESOURCES, AND FUND BALANCE

LIABILITIES
Accounts Payable 61,169$
Due to Other Governments 282,923
Total Liabilities 344,092

DEFERRED INFLOWS OF RESOURCES
Unavailable Revenues 1,991
Total Deferred Inflows of Resources 1,991

FUND BALANCE
Restricted for WIOA 123,305
Total Fund Balance 123,305
Total Liabilities, Deferred Inflows of Resources,
and Fund Balance 469,388$

Page 496 ends

FOOTHILL WORKFORCE DEVELOPMENT BOARD

CITY OF PASADENA, CALIFORNIA

RECONCILIATION OF THE GENERAL FUND BALANCE SHEET TO THE

STATEMENT OF NET POSITION
JUNE 30, 2021
See accompany
ing Notes to Financial Statements.
(6)
Fund Balance of Governmental Funds 123,305$
Amounts reported for governmental activities in the statement of net position are different because:

Revenues are reported as unavailable revenues in the governmental funds and recognized in the statement of activities. 1,991
Net Position of Governmental Activities 125,296$

Page 497 ends

FOOTHILL WORKFORCE DEVELOPMENT BOARD

CITY OF PASADENA, CALIFORNIA

STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES YEAR ENDED JUNE 30, 2021
See accompany
ing Notes to Financial Statements.
(7)

REVENUES
Intergovernmental 4,548,237$
Total Revenues 4,548,237

EXPENDITURES
Workforce Development 3,675,439
Total Expenditures 3,675,439
NET CHANGE IN FUND BALANCE 872,798
Fund Balance (Deficit) - Beginning of Year (749,493)
FUND BALANCE - END OF YEAR 123,305$

Page 498 ends

FOOTHILL WORKFORCE DEVELOPMENT BOARD

CITY OF PASADENA, CALIFORNIA

RECONCILIATION OF THE STATEMENT OF REVENUES, EXPENDITURES, AND

CHANGES IN FUND BALANCES TO THE STATEMENT OF ACTIVITIES YEAR ENDED JUNE 30, 2021
See accompan
ying Notes to Financial Statements.
(8)
Net Change in Fund Balance - Total Governmental Funds 872,798$ Amounts reported for governmental activities in the statement of activities are different because:

Revenues are reported as unavailable revenues in the governmental funds and recognized in the statement of activities. The change in unavailable revenue during the year is: (626,818)
Change in Net Position of Governmental Activities 245,980$

Page 499 ends

FOOTHILL WORKFORCE DEVELOPMENT BOARD

CITY OF PASADENA, CALIFORNIA

NOTES TO FINANCIAL STATEMENTS
JUNE 30, 2021
(9)
NOTE 1 ORGANIZA

TION AND SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
Developed 36 years ago, the Foothill Workforce Development Board (the Board) was approved by the City Council of the City of Pasadena as a Joint Powers Agreement (JPA) among the cities of Arcadia, Duarte, Monrovia, Sierra Madre, South Pasadena, and Pasadena. The JPA created the Foothill Employment and Training Consortium (FETC) which the City of Pasadena is the fiscal agent and has the authority to receive and administer workforce development funds. FETC formed the Foothill Workforce Development Board (Board) to take the lead in developing the implementation plan for workforce development services for job seekers and businesses. The mission is to support economic growth in the San Gabriel Valley by investing in skill development and job training to ensure that businesses have qualified workforce talent and job seekers have career opportunities.

The Board’s Americas Job Center of California is located at 1207 East Green Street in Pasadena and is funded through the Workforce Innovation and Opportunity Act (WIOA).

Basis of Presentation
The Board’s financial statements are prepared in conformity with accounting principles generally accepted in the United States of America. The Government Accounting Standards Board is the acknowledged standard setting body for establishing accounting and financial reporting standards followed by governmental entities in the United States of America.

These standards require that the financial statements described below be presented.

Government-Wide Financial Statements
Government-wide financial statements display information about the reporting government as a whole.

Government-wide financial statements are presented using the economic resources measurement focus and the accrual basis of accounting. Under the economic resources measurement focus, all economic resources and obligations of the reporting government (both current and long-term) are reported in the government-wide financial statements.

Basis of accounting refers to when revenues and expenditures are recognized in the accounts and reported in the financial statements. Under the accrual basis of accounting, revenues, expenses, gains, losses, assets, and liabilities are recognized when earned or when a liability is incurred.

When both restricted and unrestricted resources are combined in a fund, expenses are considered to be paid first from restricted resources, and then from unrestricted resources.

Page 500 ends

FOOTHILL WORKFORCE DEVELOPMENT BOARD

CITY OF PASADENA, CALIFORNIA

NOTES TO FINANCIAL STATEMENTS
JUNE 30, 2021
(10)
NOTE 1 ORGANIZA

TION AND SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
(CONTINUED)
Basis of Presentation
General Fund Financial Statements
The operations of the board are accounted for with a separate set of self-balancing accounts that comprise its assets, liabilities, fund equity, revenues and expenditures or expenses, as appropriate. Governmental resources are allocated to and accounted for in individual funds based upon the purposes for which they are to be spent and the means by which spending activities are controlled.

Fund financial statements are presented after the government-wide financial statements.

Governmental Funds
In the fund financial statements, governmental funds are presented using the modified-accrual basis of accounting. Their revenues are recognized when they become measurable and available as net current assets. Measurable means that the amounts can be estimated, or otherwise determined. Available means that the amounts were collected during the reporting period or soon enough thereafter to be available to finance the expenditures accrued for the reporting period. The Board uses a sixty-day availability period. The Board considers intergovernmental revenues to be susceptible to accrual.

In the fund financial statements, governmental funds are presented using the current financial resources measurement focus. This means that only current assets and current liabilities are generally included on their balance sheets. The reported fund balance (net current assets) is considered to be a measure of “available spendable resources.” Governmental fund operating statements present increases (revenues and other financing sources) and decreases (expenditures and other financing uses) in net current assets. Accordingly, they are said to present a summary of sources and uses of “available spendable resources” during a period.

Because of their spending measurement focus, expenditure recognition for governmental fund types excludes amounts represented by noncurrent liabilities. Since they do not affect net current assets, such long-term amounts are not recognized as governmental fund type expenditures or fund liabilities.

Accounts Receivable
In the government-wide statements, receivables consist of all revenues earned at year-end and not yet received. Receivables are recorded in the financial statements net of any allowance for doubtful accounts if applicable, and estimated refunds due. Federal and state grants are considered receivable and accrue as revenue when reimbursable costs are incurred.

Page 501 ends

FOOTHILL WORKFORCE DEVELOPMENT BOARD

CITY OF PASADENA, CALIFORNIA

NOTES TO FINANCIAL STATEMENTS
JUNE 30, 2021
(11)
NOTE 1 ORGANIZA

TION AND SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
(CONTINUED)
Equity Classifications
Government-Wide Statements
Net position is the excess of all the Board’s as sets over all its liabilities, regardless of fund. Net position is divided into three categories under GASB Statement No. 34. The category used in the government-wide financial statements is as follows:

Restricted Net Position – Amounts that are subjec t t o externally enforceable limitations by law, enabling legislation or limitations imposed by creditors or grantors.

General Fund Statements
The governmental fund financial statements present fund balances based on classifications that comprise a hierarchy that is based primarily on the extent to which the Board is bound to honor constraints on the specific purposes for which amounts in the respective governmental funds can be spent. The classifications used in the governmental fund financial statements are as follows:

Restricted – Amounts that are subject to exter nally enforceable limitations by law, enabling leg
islation or limitations imposed by creditors or grantors.

NOTE 2 CASH AND INVESTMENTS
Equity in the Cash and Investment Pool of the City of Pasadena The Board has no separate bank accounts or investments other than its equity in the cash and investment pool managed by the City. The Board has not adopted an investment policy separate from that of the City. The fair value of the Board’s investment in this pool is reported in the accompanying financial statem ents at amounts based upon the Board’s pro rata share of the fair value calculated by the City for the entire City portfolio. The balance available for withdrawal is based on the accounting records maintained by the City. As of June 30, 2021, the Board’s equity in the City’s cash and investment pool was a deficit of $282,923 which has been classified as a liability, due to other governments in the accompanying financial statements.

Disclosures Relating to the Investment Policy, Interest Rate Risk, Credit Risk and Custodial Credit Risk
Additional disclosures related to the investment policy, interest rate risk, credit risk and custodial credit risk are available in the City of Pasadena’s Comprehensive Annual Financial Report.

Page 502 ends

FOOTHILL WORKFORCE DEVELOPMENT BOARD

CITY OF PASADENA, CALIFORNIA

NOTES TO FINANCIAL STATEMENTS
JUNE 30, 2021
(12)
NOTE 3 FUND B
ALANCE
The accounting policies of the Board consider restricted fund balance to have been spent first when expenditures are incurred for purposes for which both the restricted and unrestricted fund balance is available. Similarly, when expenditures are incurred for purposes for which amounts in any of the unrestricted classifications of fund balance could be used, the Board considers committed amounts to be reduced first, followed by assigned and then unassigned amounts.

Page 503 ends

FOOTHILL WORKFORCE DEVELOPMENT BOARD

CITY OF PASADENA, CALIFORNIA

BUDGETARY COMPARISON SCHEDULE
YEAR ENDED JUNE 30, 2021
See accompany
ing Notes to Required Supplementary Information.
(13)
Variance with
Final Budget
Actual Positive
Original Final Amounts (Negative)
BUDGETARY FUND BALANCE - JULY 1, 2020 (749,493)$ (749,493) $ (749,493) $ - $ Resources (Inflows):

Intergovernmental 3,747,308 7,380,363 4,548,237 (2,832,126) Other Revenue 10,000 10,000 - (10,000)
Total Resources 3,757,308 7,390,363 4,548,237 (2,842,126) Charges to Appropriations (Outflows):

Workforce Development 4,254,203 7,887,258 3,675,439 4,211,819 Total Charges to Appropriations 4,254,203 7,887,258 3,675,439 4,211,819 BUDGETARY FUND BALANCE - JUNE 30, 2021 (1,246,388)$ (1,246,388)$ 123,305$ 1,369,693$ Budget Amounts

Page 504 ends

FOOTHILL WORKFORCE DEVELOPMENT BOARD

CITY OF PASADENA, CALIFORNIA

NOTE TO REQUIRED SUPPLEMENTARY INFORMATION
JUNE 30, 2021
(14)
NOTE 1 BUDGET

As required by the laws of the state of California, the Board prepares and legally adopts a final operating budget on or before July 1 of each fiscal year for the funds, which is prepared on the modified accrual basis of accounting. Expenditures may not legally exceed appropriations at the fund level, which is the legal level of control.

Supplemental appropriations may be made during the fiscal year. All budget amounts in the accompanying financial statements have been adjusted for legally authorized revisions of the annual budget during the year.

As of June 30, 2021, the Board did not incur expenditures exceeding appropriations.

Page 505 ends

CliftonLarsonAllen LLP
CLAconnect.com

CLA is an independent member of Nexia International, a leading, global network of independent accounting and consulting firms. See nexia.com/member-firm-disclaimer for details. (15)

INDEPENDENT AUDIT
ORS’ REPORT ON INTERNAL CONTROL OVER FINANCIAL

REPORTING AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT

OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE

WITH GOVERNMENT AUDITING STANDARDS
Board of Directors
Foothill Workforce Development Boa
rd
Pasadena, California
We have audited, in accordance with the auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards issued by the Comptroller General of the United States, the financial statements of the governmental activities and the general fund of the Foothill Workforce Development Board (the Board), as of and for the year ended June 30, 2021, and the related notes to the financial statements, which collectively comprise the Board’s basic financial statements, and have issued our report thereon dated January 19, 2022.

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

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

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

Page 506 ends

Board of Directors
Foothill Workforce Development Board
(16)
Compliance and Other Matters
As part of obtaining reasonable assurance about whether the Foothill Workforce Development Board’s financial statements are free from material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contract s, and grant agreements, noncompliance with which could have a direct and material effect on the financial statements. However, providing an opinion on compliance with those provisions was not an objective of our audit, and accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance or other matters that are required to be reported under Government Auditing Standards.

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

CliftonLarsonAllen LLP
Irvine, California
January 19, 2022

Page 507 ends
Page 508 ends

CITY OF PASADENA

AGREED-UPON PROCEDURES
APPROPRIATIONS LIMIT WORKSHEET NO. 6
YEAR ENDED JUNE 30, 2021
Attachment J

Page 509 ends

CLA is an independent member of Nexia International, a leading, global network of independent accounting and consulting firms. See nexia.com/member-firm-disclaimer for details.

CliftonLarsonAllen LLP
CLAconnect.com
INDEPENDENT ACCOUNTANTS’ REPORT

ON APPLYING AGREED-UPON PROCEDURES
The Honorable City Council
City of Pasadena
Pasadena, California
We have performed the procedures enumerated below on the accompanying Appropriations Limit Worksheet No. 6 of the City of Pasadena, California, (the “City”) for the year ended June 30, 2021. The City’s management is responsible for the Appropriations Limit Worksheet No. 6.

The City and the League of California Cities (as presented in the League publication entitled "Article XIII-B Appropriations Limit Uniform Guidelines") have agreed to and acknowledged that the procedures performed are appropriate to meet the intended purpose of meeting the requirements of Section 1.5 of Article XIII-B of the California Constitution. This report may not be suitable for any other purpose. The procedures performed may not address all the items of interest to a user of this report and may not meet the needs of all users of this report and, as such, users are responsible for determining whether the procedures performed are appropriate for their purposes.

The procedures performed and our findings were as follows:
a. We obtained the completed Appropriations Limit Worksheet No. 6 for the year ended June 30, 2021, and compared the limit and annual adjustment factors included in that worksheet to the limit and annual adjustment factors that were adopted by resolution of the City Council.

We also compared the population and inflation options included in the aforementioned worksheet to those that were selected by a recorded vote of the City Council.

No exceptions were noted as a result of our performing this procedure. b. For the Appropriations Limit Worksheet No. 6, we added last year’s limit to the total adjustments, and compared the resulting amount to this year’s limit. We also recalculated the adjustment factor and the adjustment for inflation and population, and compared the results to the amounts on Worksheet No. 6.

No exceptions were noted as a result of our performing this procedure. c. We compared the prior year appropriations limit presented in the accompanying Appropriations Limit Worksheet No. 6 to the prior year appropriations limit adopted by the City Council for the prior year.

No exceptions were noted as a result of our performing this procedure. (1)

Page 510 ends

(2)
The Honorable City Council
City of Pasadena
Pasadena, California
We were engaged by the City to perform this agreed-upon procedures engagement and conducted our engagement in accordance with attestation standards established by the American Institute of Certified Public Accountants. We were not engaged to and did not conduct an examination or review engagement, the objective of which would be the expression of an opinion or conclusion, respectively, on the accompanying Appropriations Limit Worksheet No. 6. Accordingly, we do not express such an opinion or conclusion. Had we performed additional procedures, other matters might have come to our attention that would have been reported to you.

We are required to be independent of the City and to meet our other ethical responsibilities, in accordance with the relevant ethical requirements related to our agreed-upon procedures engagement.

This report is intended solely for the information and use of the City Council and management of City and is not intended to be, and should not be, used by anyone other than these specified parties.

CliftonLarsonAllen LLP
Irvine, California
December 23, 2021

Page 511 ends

CITY OF PASADENA
APPROPRIATIONS LIMIT WORKSHEET NO. 6
YEAR ENDED JUNE 30, 2021
See accompanying Notes to Appropriations Limit Worksheet No. 6. (3)
Appropriations Limit for Fiscal Year Ended June 30, 2020 (see Note 2) 313,460,811$ Adjustments Factors for the Fiscal Year Ended June 30, 2021 (see Note 2):

Inflation Population
Factor Factor Combined
(Note 3) (Note 4) Factor

1.0373000 1.0011000 1.03844103 0.03844103
Adjustment for Inflation and Population 12,049,756
Other Adjustments (Note 5) -
Total Adjustments 12,049,756
Appropriations Limit for Fiscal Year Ended June 30, 2021 325,510,567$

Page 512 ends

CITY OF PASADENA
NOTES TO APPROPRIATIONS LIMIT WORKSHEET NO. 6
JUNE 30, 2021
(4)
NOTE 1 PURPOSE OF LIMITED PROCEDURES REVIEW
Under Article XIIIB of the California Constitution (the Gann Spending Limitation Initiative), California governmental agencies are restricted as to the amount of annual appropriations from proceeds of taxes. Effective for years beginning on or after July 1, 1990, under Section

1.5 of Article XIIIB, the annual calculation of the appropriations limit is subject to a limited procedures review in connection with the annual audit.

NOTE 2 METHOD OF CALCULATION
Under Section 10.5 of Article XIIIB, for fiscal years beginning on or after July 1, 1990, the appropriations limit is required to be calculated based on the limit for the fiscal year 1986-87, adjusted for the inflation and population factors discussed at Notes 3 and 4 below.

NOTE 3 INFLATION FACTORS
A California governmental agency may adjust its appropriations limit by either the percentage change in California per capita personal income from the preceding year (which is supplied by the State Department of Finance), or the percentage change in the local assessment roll from the preceding year due to the change of local nonresidential construction. The factor adopted by the City of Pasadena (the “City”) for fiscal year 2020- 2021 represents the percentage change in California per capita personal income from the preceding year.

NOTE 4 POPULATION FACTORS
A California governmental agency may adjust its appropriations limit by either the annual percentage change of the jurisdiction’s own population, or the annual percentage change in population in the County where the jurisdiction is located. The factor adopted by the City for fiscal year 2020-2021 represents the annual percentage change in the population of the City.

NOTE 5 OTHER ADJUSTMENTS
A California governmental agency may be required to adjust its appropriations limit when certain events occur, such as the transfer of responsibility for municipal services to, or from, another governmental agency or private entity. The City had no such adjustments for the year ended June 30, 2021.

Page 513 ends

CITY OF PASADENA

DEFERRED COMPENSATION PLAN
WITH INDEPENDENT ACCOUNTANTS’ REPORT
FOR THE YEAR ENDED JUNE 30, 2021
Attachment K

Page 514 ends

INDEPENDENT ACCOUNTANTS’ REPORT
Honorable Mayor and
Members of the City Council
of the City of Pasadena, California
Pasadena, California
We have performed the procedures enumerated below on the evaluation of the deferred compensation plan of the City of Pasadena as of June 30, 2021. The City is responsible for maintaining records in support of the City of Pasadena (the City) deferred compensation plan.

The City has agreed to and acknowledged that the procedures performed are appropriate to meet the intended purpose of an evaluation of the deferred compensation plan of the City of Pasadena as of June 30, 2021. This report may not be suitable for any other purpose. The procedures performed may not address all the items of interest to a user of this report and may not meet the needs of all users of this report and, as such, users are responsible for determining whether the procedures performed are appropriate for their purposes.

The procedures and associated findings are described below.

1. We obtained payroll registers for four periods for the fiscal year ended June 30, 2021. We traced the amounts withheld relating to the 457 deferred compensation plan to the liability recorded in the benefits fund liability amount payable to the deferred compensation provider (Great-West Financial Services).

Result: No exceptions were noted as a result of our procedures.

2. For each of the four pay periods selected, we agreed the amounts withheld to the payments issued to the provider.

Result: No exceptions were noted as a result of our procedures.

3. We observed the date of the selected payments to determine that withholdings were remitted to the provider for investment within fifteen days following the close of the month the payment related to, in accordance with Revenue Code Section 457.

Result: No exceptions were noted as a result of our procedures.

We were engaged by the City of Pasadena to perform this agreed-upon procedures engagement and conducted our engagement in accordance with attestation standards established by the AICPA. We were not engaged to and did not conduct an examination or review engagement, the objective of which would be the expression of an opinion or conclusion, respectively, on the deferred compensation plan of the City as of June 30, 2021. Accordingly, we do not express such an opinion or conclusion. Had we performed additional procedures, other matters might have come to our attention that would have been reported to you.

We are required to be independent of the City of Pasadena and to meet our other ethical responsibilities, in accordance with the relevant ethical requirements related to our agreed-upon procedures engagement.

CLA is an independ
ent member of Nexia International, a leading, global network of independent accounting and consulting firms. See nexia.com/member-firm-disclaimer for details.

CliftonLarsonAllen LLP
CLAconnect.com

Page 515 ends

This report is intended solely for the information and use of the City Council and management of the City of Pasadena, and is not intended to be, and should not be, used by anyone other than these specified parties.

CliftonLarsonAllen LLP
Irvine, California
December 23, 2021

Page 516 ends
Page 517 ends

CliftonLarsonAllen LLP
CLAconnect.com

CLA is an independent member of Nexia International, a leading, global network of independent accounting and consulting firms. See nexia.com/member-firm-disclaimer for details.

The Honorable City Council
of the City of Pasadena
Pasadena, California
We have audited the financial statements of the governmental activitie s, the business-type activities, the
aggregate discretely presented component units, each major fund, and the aggregate remaining fund information of City of Pasadena, California as of and for the year ended June 30, 2021, and have issued our report thereon dated January 19, 2022. We have previously communicated to you information about our responsibilities under auditing standards generally accepted in the United States of America and Government Auditing Standards, as well as certain information related to the planned scope and timing of our audit. Professional standards also require that we communicate to you the following information related to our audit.

Significant audit findings or issues
Qualitative aspects of accounting practices
Accounting policies
Management is responsible for the selection and use of appropriate accounting policies. The significant accounting policies used by City of Pasadena, California are described in Note 1 to the financial statements.

No new accounting policies were adopted and the application of existing policies was not changed during fiscal year ended 2021.

We noted no transactions entered into by the entity during the year for which there is a lack of authoritative guidance or consensus. All significant transactions have been recognized in the financial statements in the proper period.

Accounting estimates
Accounting estimates are an integral part of the financial statements prepared by management and are based on management’s knowledge and experience about past and current events and assumptions about future events. Certain accounting estimates are particularly sensitive because of their significance to the financial statements and because of the possibility that future events affecting them may differ significantly from those expected. The most sensitive estimates affecting the financial statements were:
 The annual required contributions, pension expense, net pension liability and corresponding deferred outflows of resources and deferred inflows of resources for the City’s public defined benefit plans with CalPERS are based on actuarial valuations provided by CalPERS.
 The annual required contributions, pension expense, net pension liability and corresponding deferred outflows of resources and deferred inflows of resources for the Fire and Police Retirement System Plan are based on actuarial valuations provided by a third-party consultant.

Attachment L

Page 518 ends

The Honorable City Council
City of Pasadena

Page 2 ends

 The Other Postemployment Benefit (OPEB) expense, net OPEB liability, and corresponding deferred outflows of resources and deferred inflows of resources for the City’s OPEB plans are based on certain actuarial assumptions and methods prepared by an outside consultant.
 Management’s estimate of the claims payable liabilities related to workers’ compensation claims are based on internal data and/or reports prepared by third-party claims administrators and general liability are based on City Attorney’s Office reports.

We evaluated the key factors and assumptions used to develop these estimates in determining that they were reasonable in relation to the financial statements taken as a whole.

Financial statement disclosures
Certain financial statement disclosures are particularly sensitive because of their significance to financial statement users. The most sensitive disclosures affecting the financial statements were:
 The disclosure of the retirement commitments reported in Note 18 to the financial statements  The disclosure of the claims payable reported in Note 16 to the financial statements  The disclosure of the OPEB commitments reported in Note 19 to the financial statements The financial statement disclosures are neutral, consistent, and clear.

Significant unusual transactions
We identified no significant unusual transactions.

Difficulties encountered in performing the audit
We encountered no significant difficulties in dealing with management in performing and completing our audit.

Uncorrected misstatements
Professional standards require us to accumulate all misstatements identified during the audit, other than those that are clearly trivial, and communicate them to the appropriate level of management. The attached schedule summarizes uncorrected misstatements of the financial statements. Management has determined that their effects are immaterial, both individually and in the aggregate, to the financial statements taken as a whole.

Corrected misstatements
Management did not identify and we did not notify them of any financial statement misstatements detected as a result of audit procedures.

Page 519 ends

The Honorable City Council
City of Pasadena

Page 3 ends

Disagreements with management
For purposes of this communication, a disagreement with management is a disagreement on a financial accounting, reporting, or auditing matter, whether or not resolved to our satisfaction, that could be significant to the financial statements or the auditors’ report. No such disagreements arose during our audit.

Management representations
We have requested certain representations from management that are included in the management representation letter dated January 19, 2022.

Management consultations with other independent accountants In some cases, management may decide to consult with other accountants about auditing and accounting matters, similar to obtaining a “second opinion” on certain situations. If a consultation involves application of an accounting principle to the entity’s financial statements or a determination of the type of auditors’ opinion that may be expressed on those statements, our professional standards require the consulting accountant to check with us to determine that the consultant has all the relevant facts. To our knowledge, there were no such consultations with other accountants.

Audits of group financial statements
We noted no matters related to the group audit that we consider to be significant to the responsibilities of those charged with governance of the group.

Quality of component auditor’s work
There were no instances in which our evaluation of the work of a component auditor gave rise to a concern about the quality of that auditor’s work.

Limitations on the group audit
There were no restrictions on our access to information of components or other limitations on the group audit.

Significant issues discussed with management prior to engagement We generally discuss a variety of matters, including the application of accounting principles and auditing standards, with management each year prior to engagement as the entity’s auditors. However, these discussions occurred in the normal course of our professional relationship and our responses were not a condition to our engagement.

Other information in documents containing audited financial statements With respect to the required supplementary information (RSI) accompanying the financial statements, we made certain inquiries of management about the methods of preparing the RSI, including whether the RSI has been measured and presented in accordance with prescribed guidelines, whether the methods of measurement and preparation have been changed from the prior period and the reasons for any such changes, and whether there were any significant assumptions or interpretations underlying the measurement or presentation of the RSI. We com pared the RSI for consistency with management’s responses to the foregoing inquiries, the basic financial statements, and other knowledge obtained during the audit of the basic financial statements. Because these limited procedures do not provide sufficient evidence, we did not express an opinion or provide any assurance on the RSI.

Page 520 ends

The Honorable City Council
City of Pasadena

Page 4 ends

With respect to the combining and individual nonmajor fund financial statements and schedules (collectively, the supplementary information) accompanying the financial statements, on which we were engaged to report in relation to the financial statements as a whole, we made certain inquiries of management and evaluated the form, content, and methods of preparing the information to determine that the information complies with accounting principles generally accepted in the United States of America, the method of preparing it has not changed from the prior period or the reasons for such changes, and the information is appropriate and complete in relation to our audit of the financial statements. We compared and reconciled the supplem entary information to the underlying accounting records used to prepare the financial statements or to the financial statements themselves. We have issued our report thereon dated January 19, 2022.

The introductory and statistical sections accom panying the financial statements, which are the responsibility of management, were prepared for purpos es of additional analysis and are not a required part of the financial statements. Such information was not subjected to the auditing procedures applied in the audit of the financial statements, and, accordingly, we did not express an opinion or provide any assurance on it.
* * *
This communication is intended solely for the information and use of the City Council and management of the City of Pasadena, California and is not intended to be, and should not be, used by anyone other than these specified parties.

CliftonLarsonAllen LLP
Irvine, California
January 19, 2022

Page 521 ends

UNCORRECTED ADJUSTMENTS
Description Assets Liabilities
Fund Balance /
Net Assets
Net
Expense/Revenue
and Change in
Net Assets /
Fund Balance
Revenue recognized in surrent year that pertained to
previous years for Construction and Demolition deposits that were not valid deposits. (1,688,078)$ 1,688,078$ Net current year misstatements (Iron Curtain Method) - - (1,688,078) 1,688,078 Net prior year misstatements - - 2,500,000 (2,500,000) Combined current and prior year misstatements (Rollover Method) -$ -$ 811,922$ (811,922)$
Financial statement totals 808,249,724$ 237,002,895$ 584,462,217$ 67,112,766$

SUMMARY OF UNCORRECTED MISSTATEMENTS - AUDIT
Year Ended June 30, 2021
Other Aggregate Remaining Funds
Effect of misstatements on:

City of Pasadena

Page 522 ends

FISCAL YEAR JUNE 30, 2021

ANNUAL FINANCIAL REPORTS
Finance-Audit Committee (Item 1)
City Council (Item 5)
February 14, 2022
Department of Finance

Page 523 ends

Fiscal Year Ended June 30, 2021
Attachment A
Annual Comprehensive Financial Report (ACFR)
2 Section Name Page
Transmittal Letter vii - xvii
Auditor Opinion Letter
• Unmodified (clean) opinion
1 - 3
Management’s Discussion & Analysis 5 - 19
Basic Financial Statements 20 - 39

Page 524 ends

Government-wide Financial Statements
Statement of Net Position
Governmental Activities
(in millions)
Department of Finance Attachment A pages 20 - 21
FY 2020 FY 2021
Total assets $ 883 $ 885
Deferred outflow of resources 108 110
Total liabilities (781) (815)
Deferred inflow of resources (20) (20)
Total net position $ 190 $ 160
3

Page 525 ends

Governmental Fund Financial Statements
Balance Sheet
General Fund
(in millions)
Department of Finance Attachment A page 24
FY 2020 FY 2021
Total assets $ 128 $ 142
Total liabilities (20) (42)
Deferred inflow of resources (0) (1)
Fund Balance $ 108 $ 99
4

Page 526 ends

Governmental Fund Financial Statements
Statement of Revenues, Expenditures and
Changes in Fund Balance
General Fund
(in millions)
Department of Finance Attachment A page 26
FY 2020 FY 2021
Revenue $ 266 $ 253
Expenditures (270) (258)
Other financing sources (uses) 13 - (5) -
Change in fund balance 9-- (9)--
Fund balance - beginning of year 99 - 108 -
Fund balance - end of year $ 108 - $ 99 -
5

Page 527 ends

Governmental Fund Financial Statements
Note 11 – Fund Balances, Governmental Funds
General Fund
(in millions)
FY 2020 FY 2021
• Nonspendable $ 15 $ 14
• Restricted 12 14
• Committed
 Emergency Contingency (15%) 43 40
 Operating Reserve (4.5%) 13 11
• Assigned 25 31
• Unassigned 0 (11)
• Fund balance - end of year $ 108 $ 99
Department of Finance Attachment A page 83
6

Page 528 ends

Fiscal Year Ended June 30, 2021
Attachment B
Independent Auditors’ Report on Financial Reporting
 No internal control deficiencies
 No instances on noncompliance identified
Department of Finance
7

Page 529 ends

Fiscal Year Ended June 30, 2021
• Seven remaining Fi nancial Statements
Attachments C, D, E, F, G, H, I
> All unmodified (clean) opinion
> No instances of noncompliance i dentified
• Two compliance related A greed-Upon Procedures
Attachments J, K
> No instances of noncompliance i dentified
Department of Finance
8

Page 530 ends

Attachment L
Auditor’s Communication with the
City’s Finance/Audit Committee
• Management is responsible for accounting policies.
• Accounting estimates are integral to the financial statements, w
ith key factors evaluated by auditors.
• Financial statement disclosures are neutral, consistent, and cl
ear.
• Encountered no difficulties in dealing with management • As a result of the audit, an uncorrected misstatement results i
n an immaterial net change combined with prior years’.

Fiscal Year Ended June 30, 2021
Department of Finance
9

Page 531 ends

INFORMATION ONLY

2. INTERNAL AUDIT STATUS UPDATE - REGARDING
THE JULY THROUGH DECEMBER 2021 WORK PLAN

Page 532 ends
Page 533 ends
Page 534 ends
Page 535 ends
Page 536 ends
Page 537 ends
Page 538 ends
Page 539 ends
Page 540 ends
Page 541 ends
Page 542 ends
Page 543 ends
Page 544 ends
Page 545 ends
Page 546 ends
Page 547 ends
Page 548 ends
Page 549 ends
Page 550 ends
Page 551 ends
Page 552 ends
Page 553 ends
Page 554 ends
Page 555 ends
Page 556 ends
Page 557 ends
Page 558 ends
Page 559 ends

CITY MANAGER’S OFFICE

INTERNAL AUDIT STATUS UPDATE
JULY THROUGH DECEMBER 2021
February 14, 2022
Finance/Audit Committee Meeting
Presented by: Ruthe Holden, Internal Audit Manager

Page 560 ends

CITY MANAGER’S OFFICE
Status of Progress on Audit Plan
• Completed Projects:
> Audit of City’s Ethics Policies & Processes
 Included in FY21/22 Audit Plan
 Scope includes survey of employee perspectives on the City’s ethic
al environment
 3 High risk & 1 medium risk issues were identified
 Recommended 8 changes to strengthen internal controls  Report was presented to the Finance/Audit Committee at the Oct
ober 25, 2021 meeting
2

Page 561 ends

CITY MANAGER’S OFFICE
Status of Progress on Audit Plan
• Requested Update:
> C&D Security Deposit Performance Audit
 Audit report was issued January 25, 2021
 4,188 cases have been reconciled and closed totaling $8.2M » In FY21, $1.8M in deposits were transferred to general fund » Net $6.4M additional deposits available to be forfeited/escheated  Policies and procedures are being documented
» PW staff has completed best practices research
» Will include segregation of duties and other internal controls  PW & DoIT staff in process to procure Green Halo software » Will be compatible with Energov
» Automate collection of tonnage data
» Automate process for customers & staff
3

Page 562 ends

CITY MANAGER’S OFFICE
Status of Progress on Audit Plan
• Additional projects completed this year
> Systems Implementation:
 System controls to PWP’s new customer information system,  Internal and access controls for Origami claims management system, and  Human Resource’s Outside Employment application
> Internal Controls Workshop
 November 2021 Conducted a 4 hour workshop with staff from PRCS dept  Purpose is to train City staff on how to build and assess internal controls into City proc
esses
 Interactive with 3 teams working on 3 different PRCS processes 4

Page 563 ends

CITY MANAGER’S OFFICE
Status of Recommendations
Status #
At Start of Year 45
Closed 7
Added 9
Current Open 47
5 Ranking #
High 30
Medium 15
Low 2
Total 47

Page 564 ends

CITY MANAGER’S OFFICE
Status of Progress on Audit Plan
• In Process Audits:
> High Risk Inventory Audit – planning f or this audit has started • Next in Queue:
> Succession Planning & Key Vacancies
> Building & Safety Inspections
> Accounts Payable Audit
6

Page 565 ends

CITY MANAGER’S OFFICE
Summary of Fraud Hotline Issues
• Complains received and closed
7 # of Complaints
Received
Department Assigned to Review
1 City Manager
7 Human Resources
8 Internal Audit (complaints unrelated to City business) 7 Water & Power
23 Total

Page 566 ends

CITY MANAGER’S OFFICE
8

Page 567 ends

CITY MANAGER’S OFFICE
Next Steps
• Internal Audit Next Status Update
> Progress of Audit Plan
> Summary of Fraud Hotline
> Status of Open Audit Recommendations
9

Page 568 ends

INFORMATION ONLY

3. FY 2022 CAPITAL IMPROVMENT PROGRAM 2nd

QUARTER MONITORING REPORT

Page 569 ends
Page 570 ends

Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
LEGEND
Project Completed
Project Delayed - External Factors
Project Delayed - Internal Factors
Project Over Budget

Page 571 ends

Municipal Buildings and Facilities
5,675,0005,675,000Fire Stations Renovations and
Improvements
719111 Fire Station 33 storage building
design review by the Planning &
Community Development
Department was completed in the
second quarter. Fire Station 38
anticipated to advertise for
construction in the third quarter.

Fire Station 33 renovations were
completed in the first quarter.

Renovations at Fire Station 38 will
begin in FY 2022.
1,500,000
28% 6/30/2023 Ongoing1,592,139
4,726,8826,096,855Building Maintenance FY 2021 -
2025
719032 Equipment was ordered for the
following projects in the second
quarter: HVAC replacement at the
Senior Center; Portable Emergency
Heavy Duty Generators; Stationary
Generators for the Police
Department Heliport, Fire Station 39,
and Schoolhouse Parking Structure;
Roll-up doors for Fleet Maintenance
Building; and Chiller and HVAC
equipment for the Police Department
Building and Shooting Range.

Installation of these systems will be
scheduled upon equipment delivery.

Window repair/replacement La
Pintoresca Library is under review by
the Historical Society and the
procurement process for roof
replacement at the Linda Vista
Library began in the second quarter.

Installation of insulation over drop
ceilings at the Jackie Robinson
Center is anticipated to be complete
in the third quarter.

Roof repairs were completed at the
Water & Power administration
building in the first quarter.

Work will be completed at the following
locations in FY 2022: City Yard, Fire
Station 39, Jackie Robinson Center,
La Pintoresca Library, Linda Vista
Library, Police Department Building,
Police Department Heliport and
Modular Office, Police Department
Shooting Range, Schoolhouse Parking
Lot, and the Senior Center. In addition,
emergency heavy duty portable
generators will be procured for
citywide use.
1,100,000
44% 6/30/2022 Planning2,090,685
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 2

Page 572 ends

1,049,5111,325,731Fire Station 31 Seismic Retrofit719143 Design plans incorporating additional tenant improvement work was
submitted to the Planning
Department for review in the second
quarter.

Design will be completed in FY 2023.980,680
8% 5/31/2023 Design80,051
140,013937,345Public Works Building - Seismic
Upgrade
719154 Consultant for design services was
selected in the second quarter and
contract is anticipated to be awarded
in the third quarter. Work to submit
an application to the granting agency
for additional funds began in the
second quarter.

Design will continue in FY 2022.140,000
10% 6/30/2023 Design13,715
1,400,0001,400,000Citywide Facility Improvements -
Jackie Robinson Center and La
Pintoresca Library
719125 This project was completed in the
second quarter.

Construction of HVAC system
replacement at La Pintoresca Library
will be completed in FY 2022.
350,000
89% 3/31/2022 Completed1,242,053
600,000600,000Roof Replacements - Hill Ave.

Library and Victory Park
Recreation Center
719166 Procurement process for roof
installation at the Victory Park
Recreation Center Administration
Building began in the second quarter.

New roof installation at the Victory
Park Recreation Center Administration
Building will begin in FY 2022. New
roof installation at the Hill Avenue
Library will subsequently follow.
600,000
0% 6/30/2023 Planning0
75,00075,000City Hall Building Systems
Assessment
719177 Request for Proposal responses
received in the second quarter and
contract is anticipated to be awarded
in the third quarter.

The building systems assessment will
be completed in FY 2022.
75,000
7% 6/30/2022 Planning5,612
2,200,0002,200,000Mobile Operations Center719199 Procurement of video downlink was completed in the second quarter.

Alternative solutions to securing a
new hangar will be reviewed in the
third quarter.

Design will be completed and phased
construction will begin in FY 2022.
2,200,000
0% 6/30/2022 Planning642
250,000250,000Public Health Building
Improvements
7192010 Design began in the second quarter.Design will begin in FY 2022.250,000 1% 6/30/2023 Design3,382
Streets and Streetscapes
3,750,00043,350,000Annual Citywide Street
Resurfacing and ADA
Improvement Program FY 2022
739331 The list of streets selected for
resurfacing was finalized in the
second quarter.

Resurfacing will begin in FY 2022.3,750,000
0% 9/30/2022 Design17,507
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 3

Page 573 ends

10,662,27119,662,271Annual ADA Sidewalk
Improvement Program
739132 Procurement of materials for
sidewalk replacements continued in
the second quarter.

Repair of sidewalks will continue in FY
2022.
650,000
76% 6/30/2022 Design8,137,044
5,650,0005,350,000Annual Citywide Street
Resurfacing and ADA
Improvement Program FY 2021
739323 All concrete improvement work was
completed in the second quarter.

Street resurfacing on Linda Vista Ave
was also completed. Additional street
resurfacing will begin in the third
quarter.

Resurfacing will begin in FY 2022.5,000,000
19% 6/30/2022 Construction1,070,701
1,275,0004,275,000Curb Ramp ADA Improvements
Program - FY 2022
739374 Contract for construction was
awarded on November 22, 2021 and
construction is anticipated to begin in
the third quarter.

Installation of curb ramps will continue
in FY 2022.
500,000
3% 6/30/2022 Construction32,179
954,429954,429Miscellaneous Sidewalk Repair
Program
739405 Contract was awarded for
construction on October 18, 2021
and construction is anticipated to
begin in the third quarter.

Sidewalk repairs will continue as funds
are received in FY 2022.
200,000
7% 11/30/2022 Construction68,666
3,050,0007,050,000Colorado Street Bridge Barrier
Enhancements
733246 Public Safety Committee review of
the barrier design mock-ups was
held and no recommendation on a
preferred design was made in the
first quarter. Alternative design efforts
with Pasadena Heritage to identify
other possible solutions underway in
the second quarter.

Environmental and design phases will
continue in FY 2022.
100,000
34% N/A Ongoing1,032,931
1,850,0009,878,000Holly Street Bridge - Seismic
Retrofit
733237 Design continued and the preliminary
concept of work is under review by
Caltrans in the second quarter.

Design will continue in FY 2022.925,000
50% 6/30/2023 Design921,647
258,000358,000Bridge Improvement Program FY
2019-2023
739298 LA County advertised the Bridge
Preventative Maintenance Program
in the second quarter for the
following bridges: Del Mar Blvd over
Eaton Wash, Columbia Street over
the MTA Gold Line, and New York
Drive over Eaton Wash.

Bridge inspections and improvements
will continue in FY 2022.
100,000
53% N/A Ongoing136,902
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 4

Page 574 ends

569,919654,919Guardrail Improvement Program739309 Design package submitted to Caltrans requesting approval and
authorization to begin construction.

This is a continuing program. Projects
will be scheduled by City staff as
repairs and/or replacements are
identified.
80,000
27% 6/30/2022 Design154,475
Street Lighting
3,965,0006,500,000High Voltage Series Street Light
Conversion - Phase I
744151 Construction on S-263 circuit was
completed and construction on S-
155 circuit continued in the second
quarter.

Construction will continue for S-155
circuit (Marianna Road and adjoining
streets) and S-263 circuit (Arroyo
Boulevard and adjoining streets)
conversions in FY 2022. Circuit S-048
(San Rafael Avenue and adjoining
streets) will be completed when funds
become available.
500,000
16% 6/30/2022 Construction652,857
450,0001,000,000Concrete Traffic Signal/Street
Lighting Pole Replacements
744162 Advertisement for construction
continued in the second quarter and
contract is anticipated to be awarded
in the third quarter.

Replacement of concrete poles at
Altadena Dr. and Foothill Blvd. will
begin construction in FY 2022.
200,000
46% 9/30/2022 Design207,569
185,0006,000,000High Voltage Series Street Light
Conversion - Phase III
744193 Design of S-013 and S-258 circuits
began in the second quarter.

The S-013 (South Marengo) circuit,
and the S-258 (South Lake) circuit will
begin construction in FY 2022.
150,000
6% 6/30/2023 Design10,834
95,0004,000,000High Voltage Series Street Light
Conversion - Phase IV
744204 Design of S-064 circuit continued in
the second quarter.

The S-064 (Rosemead) circuit will
begin construction in FY 2022.
95,000
10% 6/30/2023 Design9,031
1,033,2631,033,263Repair, Replacement, and
Installation of Street Lighting
744135 Procurement of streetlight equipment
including poles and LED luminaires
to complete various work orders
began in the second quarter.

This is a continuing program. Projects
will be scheduled by City staff as
requests are received for enhanced
lighting, in-fill lighting, and as street
light components in need of repair or
replacement are identified.
100,000
71% N/A Ongoing731,707
300,0008,000,000High Voltage Series Street Light
Conversion - Phase II
744176 Design for the pole and luminaire
replacement for the Linda Vista
circuit began in the second quarter.

Design of Phase II began in FY 2019
and will continue in FY 2022.
50,000
78% N/A Design235,207
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 5

Page 575 ends

140,0004,505,000Utility Undergrounding for Wildfire
Prevention
32161 No reportable activity in the second
quarter.

In FY 2022, design will begin to
underground high voltage overhead
circuitry to mitigate the fire risk in the
neighborhoods in the elevated or
extreme fire risk areas of the City.
134,000
0% 6/30/2025 No Activity This
Quarter
0 4,800,00010,000,000Mountain Street - Electrical
System Undergrounding, Lake
Avenue to Hill Avenue
32132 Actions are underway to hire and
procure resources to support the
Mountain Street district.

In FY 2022, design and coordination of
the Mountain Street Underground
Utility District will continue.
208,000
0% 6/30/2025 Planning1,651
950,00025,135,000Raymond Avenue - Electrical
System Undergrounding, Maple
Street to North City Limits
32143 Actions are underway to hire and
procure resources to support the
Raymond Avenue district.

In FY 2022, the coordinated design
package for the Raymond Avenue
Underground Utility District will begin.
615,000
0% 6/30/2025 Planning0
600,000360,000Electric System Undergrounding
Outside Established
Undergrounding Districts
32104 Processed one request for
reimbursement during the second
quarter.

This is an ongoing project involving
undergrounding projects that are not
part of an established undergrounding
district. In FY 2022, an estimated four
(4) service reimbursements will occur.
15,400
32% 6/30/2025 Ongoing194,552
Transportation
Active Transportation/Complete Streets
333,481613,481Pasadena Bicycle Program FY
2021-2025
751111 Four outreach events for the
Greenways Feasibility Study
occurred in the second quarter. Work
orders for a bike lane on Glenarm St
west of Fair Oaks Ave was also
completed.

Implementation of the Bicycle
Transportation Plan will continue in FY
2022, including installation of
additional painted bike-way amenities
such as green paint at conflict points
and installation of sharrows along
Roseways. In addition, prioritization of
Bike Boulevards (Greenways), existing
bike network gaps, and associated
outreach will continue in FY 2022.
80,000
53% 6/30/2024 Planning178,399
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 6
Street Lighting and Electric Undergrounding

Page 576 ends

374,915874,915Citywide Complete Streets
Program FY 2021-2025
751142 Analysis of existing conditions for the
Neighborhood Traffic Management
Program began in the second
quarter.

Ongoing work including speed hump
investigations, preferential parking
program and Neighborhood Traffic
Management Program (NTMP) will
continue in FY 2022. Specific NTMPs
for the neighborhoods of Mountain
Street/Summit Avenue Area (between
Fair Oaks Avenue and Los Robles
Avenue), N. Raymond Avenue Area
(between Washington Blvd and
Howard Street) and Mountain
St/Holliston Ave Area (between Mentor
Ave and Hill Ave) will be completed in
FY 2022.
200,000
47% 6/30/2024 Planning177,746
1,758,1601,758,660Pedestrian Safety Enhancements
at Signalized Intersections
750473 Construction for the intersection of
Lake Avenue at Mountain Street
completed in the second quarter.

Construction for the intersection of
Colorado Boulevard at Fair Oaks
Avenue will begin in the third quarter.

Construction will be completed in FY
2022 for the intersections of Colorado
Boulevard at Fair Oaks Avenue and
Lake Avenue at Mountain Street.
858,557
21% 6/30/2022 Construction362,533
160,000160,000Left Turn Signal Phasing at Fair
Oaks Ave. and Colorado Blvd.
750904 No reportable activity in the second
quarter.

Traffic signal modification under this
project is in coordination with civil
improvements under the Pedestrian
Safety Enhancements at Signalized
Intersections (75047) project.

Construction for CIP 75047 began in
the second quarter.

In FY 2022, construction will be
completed following the completion of
the "Pedestrian Safety Enhancements
at Signalized Intersections" project
(75047).
142,141
40% 9/30/2022 Construction63,251
1,977,4812,777,481Pedestrian Crossing
Enhancements Program FY 2021-
2025
751125 Project advertisement for
construction concluded in the second
quarter and a contract is anticipated
to be awarded in the third quarter.

Rectangular Rapid Flashing Beacons
at Raymond Ave and Bellevue Dr and
Marengo Ave and Bellevue Dr will be
under construction in FY 2022.
240,000
6% 9/30/2022 Ongoing121,893
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 7

Page 577 ends

185,500410,500Arterials Speed Management
Program FY 2021-2025
751136 Speed feedback sign installations
were completed on Villa St and
Washington Blvd in the second
quarter.

Design for Speed Feedback Signs on
Villa St between Wilson Ave and Hill
Ave, Washington Blvd between
Catalina Ave and Hill Ave, and Fair
Oaks Ave between Montana St and
Fair Oaks Dr will begin in FY 2022.

Painted islands with flexible bollards
will be installed on Los Robles Ave
north of Washington Blvd. Additional
potential raised median locations will
be identified and evaluated for
implementation.
100,000
16% 6/30/2022 Construction30,390
8,503,4409,003,440Complete Streets Project - Union
Street Cycle Track
750877 Project advertised for construction in
the second quarter.

Construction will begin in FY 2022.7,596,600
17% 12/30/2023 Design1,463,288
4,476,3424,476,342Complete Streets Project -
Cordova St. from Hill Ave. to
Arroyo Pkwy.
750528 Design completed and package for
Caltrans' authorization to advertise
for construction was submitted in the
second quarter.

Construction will begin in FY 2022.3,512,700
14% 6/30/2023 Design617,959
200,000200,000Lake Ave. Traffic and Pedestrian
Safety Enhancements from
Mountain St. to Maple Ave. –
Design Phase
751059 Preliminary design was completed in
the second quarter.

Final design will begin when funds are
identified.
0 99% 12/31/2021 Design197,930
1,871,0001,871,000Complete Streets Project -
Avenue 64 from Colorado Blvd. to
South City Limits
7507710 Design continued in the second
quarter.

Construction will begin in FY 2022.1,546,000
24% 12/31/2022 Design453,314
1,235,0001,599,980Complete Streets Project - N. Hill
Ave. from North City Limit to Villa
St.
7509311 Design continued in the second
quarter.

Design will be completed in FY 2022.600,000
19% 6/30/2024 Design230,159
2,973,0903,087,000South Lake Ave. Pedestrian
Access Improvements to Gold
Line Station
7510612 Design continued and community
outreach occurred in the second
quarter.

Design will be completed in FY 2022.570,000
14% 12/30/2023 Design403,682
200,000200,000Complete Streets Project -
Mountain St. at Sierra Bonita Ave.
and Sinaloa Ave. - Design Phase
7510713 Design continued in the second
quarter.

Design will be completed in FY 2022.197,300
18% 6/30/2022 Design36,756
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 8

Page 578 ends

500,0001,500,000Enhancements to Metro Gold Line
Allen Station - Design Phase
14 No reportable activity in the second
quarter.

A quick build pilot project will begin
implementation in FY 2021 and
continue in FY 2022. The design of the
permanent installation will begin when
funds are identified.
0 0% 6/30/2022 No Activity This
Quarter
05,100,000Citywide Continental Crosswalk
Implementation
16 Planning continued in the second
quarter and is anticipated to be
completed in the third quarter.

A Continental Crosswalk
implementation plan will be conducted
utilizing Department of Transportation
Operating Budget in FY 2022.
0 0% N/A Planning
Traffic Operations, Traffic Signals, and ITS
225,000625,000Transportation System Safety
Enhancements Project - FY 2021
- 2025
7511518 Locations were being identified for
potential safety enhancements in the
second quarter.

Staff will continue to address safety
concerns at high collision
intersections, with a focus on safety
enhancements in the Civic Center and
the central business district in FY
2022.
125,000
0% 6/30/2025 Ongoing0
1,447,1911,447,191Implement Bus Signal Priority
System on Pasadena Transit
Buses
7509419 Plans were completed in the second
quarter and project anticipated to
advertise for construction contract in
the third quarter.

Construction will begin in FY 2022.950,000
21% 6/30/2022 Design297,048
2,071,7662,071,766Adaptive Traffic Control Network -
Phase II
7509520 Contract for construction was
awarded on October 18, 2021 and is
anticipated to begin in the third
quarter.

Construction will begin in FY 2022.330,000
22% 9/30/2022 Construction461,110
925,000925,000Traffic Signal at Fair Oaks Ave.
and Bellevue Dr.
7509821 Construction continued in the second
quarter.

Construction will begin in FY 2022.900,000
38% 9/30/2022 Construction353,807
125,000125,000Traffic Signal Safety
Enhancements at the
Intersections of Lake Ave. at
Corson St. and Maple St.
7510822 No reportable activity in the second
quarter.

Construction will begin in FY 2022.100,000
0% 12/17/2021 6/30/2022 Construction56
140,279140,279Traffic Signal Improvements at
Colorado Blvd. and Bonnie Ave.
7510423 This project was completed in the
first quarter.

Construction will be completed in FY
2022.
0 100% 8/31/2021 Completed140,279
163,721163,721Left Turn Phasing at San Gabriel
Blvd. and California Blvd.
7510924 This project was completed in the
first quarter.

Construction will be completed in FY
2022.
0 87% 8/31/2021 Completed142,263
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 9

Page 579 ends

90,00090,000Left Turn Phasing at Fair Oaks
Ave. and Bellefontaine St.
7511025 This project was completed in the
first quarter.

Construction will be completed in FY
2022.
0 96% 8/31/2021 Completed86,652
99,512189,512Old Pasadena Traffic
Improvement - FY 2021-2025
7511626 No reportable activity in the second
quarter.

A study for the midblock crosswalk at
Holly St and Big Bang Theory Way is
anticipated to begin in the fourth
quarter.

On street parking will be evaluated
and dynamic curb management will be
studied in FY 2022. Additional
enhancements to signing, striping, and
signal operations will also continue as
requests are received.
30,000
6% 6/30/2025 No Activity This
Quarter
6,240
4,270,8005,711,908Gold Line Phase I - Project
Enhancements
7550627 Revised scope of work finalized with
Metro in the second quarter.

Implementation of the Light Rail Train
Tracking and Network System (75517)
will be completed in FY 2022.

Outreach and final design for the
Pedestrian Access Enhancements
(75523) will begin in FY 2022.
250,000
0% 6/30/2022 Ongoing0
5,417,5655,417,565Intelligent Transportation System
(ITS) Master Plan Implementation
Phase III
7591127 This project was completed in the
second quarter.

System will be activated in FY 2022.272,129
95% 3/31/2022 Completed5,167,448
3,959,3503,959,350Intelligent Transportation System
Phase I - Traffic Management
Center and Transit Vehicle Arrival
Information System
7570128 This project was completed in the
second quarter.

Construction will be completed in FY
2022.
577,880
97% 12/31/2021 Completed3,854,317
710,900710,900Intelligent Transportation System
Phase I - Video Detection System
and Fiber Optic Communication
7591329 This project was completed in the
second quarter.

Construction will be completed in FY
2022.
670,120
73% 12/31/2021 Completed515,976
698,711698,711Intelligent Transportation System
Phase I - Parking Guidance
7591230 Design continued in the second
quarter.

Construction will begin in FY 2022.683,100
4% 6/30/2023 Design30,289
250,802450,802Intelligent Transportation System
(ITS) Equipment
Upgrades/Replacement - FY
2021-2025
7511731 Fiber optic cable communication
systems were repaired and two
Closed Circuit Television cameras
were replaced in the second quarter.

This project will continue in FY 2022.50,000
9% 6/30/2024 Ongoing22,445
212,144462,144Mobility Corridor Improvements
FY 2021-2025
7511832 Continued signal timing work on I-
210 connected corridor in the second
quarter.

This project will continue in FY 2022.120,000
29% 4/28/2022 Construction61,470
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 10

Page 580 ends

661,9283,182,428Implementation of Citywide
Transportation Performance
Monitoring Network
7560233 No reportable activity in the second
quarter.

Construction will begin in FY 2022.200,000
58% 12/17/2021 6/30/2022 Construction383,839
4,100,0004,100,000Walnut Street Corridor Signal
Improvements
7512134 Procurement process for design
services continued in the second
quarter.

Design will continue in FY 2022.20,000
0% 7/25/2025 Planning0
2,600,0002,600,000St. John Capacity Enhancement7512035 No reportable activity in the second quarter.

Letter of Agreement received Metro
approval.

Design will continue in FY 2022.500,000
0% 6/30/2023 No Activity This
Quarter
4,872
220,000220,000Installation of Automated License
Plate Readers - Pilot Program
7511936 No reportable activity in the second
quarter.

This project will continue in FY 2022.220,000
0% 6/30/2022 No Activity This
Quarter
0 3,800,0003,800,000Intelligent Transportation System
Projects & Traffic Flow
Improvements within the SR 710
Affected Corridors
7591437 Coordination of funding agreement
with Metro continued in the second
quarter. This project is pending
approval of the funding agreement.

Design will begin in FY 2022.3,800,000
0% 1/29/2027 Planning0
683,0001,366,000Traffic Signal at Del Mar Blvd. and
Michigan Ave.
7521138 This project received $683,000 in
American Rescue Plan Act funds in
the first quarter for design. Design
continued in the second quarter.

Design will be completed in FY 2022.683,000
1% 6/30/2023 Design3,969
500,000500,000Traffic Signal at Orange Grove
Blvd. and Craig Ave.
7509739 This project received $440,000 in
ARPA funding in the first quarter for
construction. Design continued in the
second quarter and is anticipated to
be completed before the fourth
quarter.

Design will be completed in FY 2022.440,000
7% 6/30/2023 Design36,548
481,000481,000Traffic Signal at Orange Grove
Blvd. and Sunnyslope Ave.
7509940 This project received $416,000 in
ARPA funding in the first quarter for
construction. Design is anticipated to
be completed before the end of the
fourth quarter.

Design will be completed in FY 2022.416,000
4% 6/30/2023 Design21,590
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 11

Page 581 ends

9,012,49418,792,493Purchase of Replacement Transit
Vehicles and Expansion Fixed-
Route Transit Vehicles
7508541 Procurement process continued in
the second quarter.

Two replacement CNG cutaway buses
are anticipated to be delivered in FY
2022 and four additional replacement
CNG standard buses are anticipated
for delivery in FY 2023.
1,164,388
57% 6/30/2022 Planning5,137,615
1,274,3162,234,316Purchase of Dial-A-Ride Vehicles7508642 No reportable activity in the second quarter.

Three replacement vehicles and one
expansion vehicle will be purchased
and delivered in FY 2022.
221,000
74% 6/30/2022 No Activity This
Quarter
946,893
432,093732,093Bus Stop Improvement Program7590044 No reportable activity in the second quarter.

This is a continuing program. Projects
will be scheduled by City staff as
locations are identified.
55,354
70% N/A No Activity This
Quarter
304,608
Sewers and Storm Drains
1,000,0005,000,000Annual Sewer System
Improvements and Capacity
Upgrades - FY 2022-2026
769181 Design continued in the second
quarter.

Repair or rehabilitation of sewer will
begin in FY 2022 as identified by
annual inspection and evaluation.
1,000,000
3% 6/30/2023 Design25,204
826,2931,526,293Annual Storm Drain System
Repair & Improvements - FY
2020-2024
769132 Design continued in the second
quarter.

Repairs to storm drain infrastructure
will be implemented as needed in FY
2022.
350,000
3% 6/30/2022 12/30/2022 Design26,224
1,600,0001,600,000Annual Sewer System
Improvements and Capacity
Upgrades - FY 2021
769163 Construction was completed in the
second quarter. Televising of sewer
pipes is anticipated to be completed
in the third quarter.

Construction of the sewer lining and
repair work will be completed in FY
2022. This will consist of relining
20,000 linear feet of existing sewer
lines, various sewer repairs, and
rehabilitation work. Additionally, 50,000
linear feet of sewer pipe will be
televised.
868,203
64% 12/31/2021 1/28/2022 Construction1,027,579
900,000900,000NPDES - Storm Drain Master
Plan and Watershed Assessment
769144 Staff continued coordination with
project consultant and project
stakeholders.

The citywide storm drain assessment
will be completed in FY 2022.
700,000
56% 6/30/2022 Design500,013
4,870,0004,870,000San Rafael Treatment Wetlands
and Storm Water Capture
762915 Procurement for design consultant
contract continued in the second
quarter. Contract is anticipated to be
awarded in the third quarter.

Design will continue in FY 2022.3,500,000
5% 6/30/2024 Design248,416
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 12
Transit

Page 582 ends

1,500,0001,500,000Modernization of Busch Garden
and Rosemont Sewer Pump
Stations
769176 Design continued in the second
quarter.

Design will be completed in FY 2022.500,000
15% 6/30/2023 Design217,540
2,970,0004,470,000NPDES Rio Hondo Bacteria Load
Reduction - Design Phase
762927 Design continued in the second
quarter.

Design of this project will continue in
FY 2022 and is being managed by
San Gabriel Valley Council of
Governments.
1,000,000
7% 6/30/2024 Design219,292
Rose Bowl Improvements
2,151,0002,391,000Brookside Golf Course &
Clubhouse Preventative
Maintenance FY 2020 - 2024
1 Upgrades to fire, pump house
repairs, boiler replacement and
plumbing/electrical repairs continued
in the second quarter.

In FY 2022, the following preventative
work will continue: bunker repairs, tree
trimming, irrigation repairs, fencing
and netting repairs, golf course
equipment buyout, utility repairs, and
other miscellaneous repairs and
services.
1,871,119
0% N/A Ongoing
1,895,0003,195,000Rose Bowl Preventative
Maintenance FY 2020 - 2024
2 Elevator/escalator repairs, electrical
repairs, IT repairs, HVAC repairs,
signage/wayfinding repairs and
plumbing repairs continued in the
second quarter.

In FY 2022, the following preventative
maintenance work will continue: roof
repairs, stadium fiber and IT repairs,
security camera repairs, plumbing
repairs, videoboard maintenance,
concourse slurry and asphalt repairs,
and other miscellaneous repairs and
services.
1,554,305
0% N/A Ongoing
2,720,5003,050,500Rose Bowl Major Improvement
Projects FY 2020 - 2024
3 Sewer and water assessment,
concession stand upgrades, and
future studies/assessments
continued in the second quarter.

In FY 2022, the gas line will be
replaced.
1,471,918
0% N/A Ongoing
Parks and Landscaping - Park Projects
4,414,5584,414,558Villa Parke Community Center
Improvements
780611 Construction continued in the second
quarter.

Construction of facility improvements
will be completed in FY 2022.
3,000,000
52% 6/30/2022 Construction2,300,427
1,750,0001,750,000La Pintoresca Park Improvements780872 Construction continued in the second quarter.

Construction began in FY 2021 and
will be completed in FY 2022.
888,101
59% 1/31/2022 Construction1,027,095
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 13
N/A
N/A
N/A
N/A
N/A
N/A

Page 583 ends

5,000,0005,000,000Robinson Park - Pool and Pool
Building Renovations
780853 Construction drawings submitted to
Planning and Community
Development Department for final
review and approval in the second
quarter.

Construction will begin in FY 2022.1,000,000
14% 6/30/2023 Design686,623
300,000300,000Washington Park Community
House and Restroom - Design
Phase
780884 This project was completed in the
second quarter.

Plan review and permitting of the
project will be completed in FY 2022.
9,362
99% 12/31/2021 Completed296,556
2,800,0002,800,000Washington Park Community
House and Restroom -
Construction Phase
780895 Project for construction advertised in
the second quarter and is anticipated
to be awarded in the third quarter.

Construction will begin in FY 2022 and
be completed in FY 2023.
1,000,000
5% 6/30/2023 Construction147,973
5,275,0005,055,000Playhouse District Park and
Parking Lot
780836 Construction continued in the second
quarter.

Construction will be completed in FY
2022.
4,000,000
44% 6/30/2022 Construction2,341,259
996,000996,000Annandale Canyon Open Space
Trail Access, Improvements and
Park Expansion
782407 Construction began in the second
quarter and is anticipated to be
completed in the third quarter.

Construction will be completed in FY
2022.
250,000
89% 3/31/2022 Construction889,126
655,000655,000Lamanda Park Library Pocket
Park - Construction
780788 Contract execution completed in the
second quarter. Construction is
anticipated to begin in the third
quarter.

Construction will be completed in FY
2022.
300,000
35% 6/30/2022 Construction226,408
3,378,4663,378,466Citywide Sports Facilities
Improvements and Installations
780449 Planning and design for Brenner
Park continued in the second
quarter. Coordinating establishment
of Memorandum of Understanding
with Pasadena Unified School
District for McKinley improvements
began in the second quarter.

Design of Brenner Park, construction
of McKinley tennis and pickleball court
improvements, and Eaton Blanch Park
tennis court fencing will be completed
in FY 2022.
700,000
83% 6/30/2023 Design2,820,150
2,820,6005,920,600Central Park Improvements7846111 Design continued in the second quarter.

Design of the playground
improvements will be completed in FY
2022.
400,000
78% N/A Design2,201,793
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 14

Page 584 ends

1,025,3261,097,000Tree Replacement/Planting
Citywide - FY 2017 - 2021
789581 Procurement process for new
planting material upgrades continued
in the second quarter.
360 trees will be planted with 60
weeks of watering in FY 2021.
0 77% 6/30/2022 Ongoing791,670
Arroyo Projects
1,532,9001,532,900Hahamongna - Implement Master
Plan - Oak Grove Area
Improvements
775061 Construction began in the second
quarter.

Construction will be completed in FY
2022.
900,000
39% 3/31/2022 Construction597,762
848,803998,803Lower Arroyo Seco - Habitat
Restoration
774102 Contract awarded for habitat
maintenance, monitoring, and
reporting services on October 18,
2021.

A five-year environmental and habitat
monitoring effort will begin in FY
2022.
50,000
94% 6/30/2027 Ongoing801,435
2,418,4722,542,492Implement Master Plan -
Hahamongna Watershed Park -
Berkshire Creek Area
Improvements
775093 Contract awarded for habitat
maintenance, monitoring, and
reporting services on October 18,
2021.

The five-year environmental and
habitat sustainability plan began in FY
2021 and will continue through FY
2025.
50,000
97% 6/30/2026 Ongoing2,349,679
340,000340,000Jackie Robinson Baseball Field -
Foul Ball Netting Improvements
779024 Due to unforeseen underground
utility conditions encountered during
the construction of the foul ball
netting, the conduits and wiring for
the baseball infield lighting require
replacement. The replacement of
the electrical infrastructure began in
the second quarter and is anticipated
to be completed in third quarter.

This project will be completed in FY
2022.
199,458
42% 3/31/2022 Construction142,338
500,000550,000One Arroyo Project – Woodlands
Loop and Streamside Walk –
Environmental and Design Phase
773815 Contract for environmental
consultant services was awarded in
the second quarter and services
began on September 27, 2021.

Environmental documents scheduled
for completion in the fourth quarter.

Environmental and design will be
completed in FY 2022.
250,000
2% N/A Design7,617
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 15
Parks and Landscaping - Landscape Projects

Page 585 ends

4,450,0008,250,000Restoration, Upgrades, and
Repairs of the Civic Auditorium,
Convention Center and Ice Rink
1 Procurement of the Civic Auditorium
sound system continued and repairs
to the HVAC system were completed
in the second quarter.

In FY 2022, general and emergency
repairs will be completed as needed
including plumbing, electrical, and
building maintenance for the
Convention Center, Civic Auditorium,
and Ice Skating Center.
1,200,000
0% 12/31/2022 Planning
Water System
10,840,00032,240,000Distribution Mains - FY 2020 -
2024
10801 A total of 4,774 square feet of
asphalt roadway, and 1,885 square
feet of concrete roadway and
sidewalk were repaired in the second
quarter including Fillmore Street and
Glenarm Street. Construction for
Altadena Drive was completed in the
second quarter. Designs for future
water main construction continued.

In FY 2022, replacement of new water
mains will be prioritized based on
methods established in the Water
System and Resources Plan, the
completion of a water main
assessment, and the determination of
deficient fire flows. Planned projects in
FY 2022 include Altadena Drive, San
Gabriel Boulevard, Arroyo Parkway,
Grand Avenue, Bellefontaine and
Pasadena, gate valve replacements,
fire hydrant installations, and design of
mains.
6,380,000
57% 6/30/2024 Ongoing6,198,720
2,859,00020,293,214Sunset Reservoir Improvements10752 A historical resource report determined that the Sunset
Reservoir Project warrants an
Environmental Impact Report (EIR).

The EIR process began in the
second quarter. Alternative project
layouts for design consideration are
being reviewed. Public outreach
continued with a community meeting,
a tour for the W.D. Edson
Neighborhood Association, and a
project website launch.

In FY 2022, design, environmental
review, conditional use permit
package, and outreach will be
completed.
1,290,000
58% 6/30/2025 Design1,662,828
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 16
Pasadena Center Improvements
N/AN/A

Page 586 ends

6,811,75413,961,754Arroyo Seco Canyon Project10403 Efforts to obtain permits with the Department of Fish and Wildlife,
Army Corps of Engineers, and the
Regional Water Quality Control
Board continued in the second
quarter. A consultant was selected
for the preparation of an infiltration
study in the Arroyo Seco. Design for
Area 2 continued and design for Area
3 was completed.

In FY 2022, construction of the
replacement intake and diversion
structure (ASCP Area 2) will be
completed depending on dry weather
persisting into the winter. Equipment
testing and operational start-up will
also be completed. The spreading
basins, road, and parking (Area 3)
construction will begin. Area 1
construction is also included.
750,000
90% 6/30/2026 Design6,105,652
3,000,0008,169,286New Clean Water Well10884 Assessment of several sites for new well locations began in the second
quarter. A new well location was
identified on City-owned property
and discussions with the City's Real
Property Manager and the
Department of Drinking Water began.

In FY 2022, below grade construction
of a well may begin depending on
water quality results from the
monitoring well.
1,250,000
1% 6/30/2024 Planning38,346
67,613,31467,613,314Distribution Mains10015 Construction for Colorado Boulevard (from Altadena Drive to Craig
Avenue) continued in the second
quarter with tie-in connections,
services, and fire hydrants.

In FY 2022, the remaining project
located at Colorado Boulevard from
Meridith Avenue to Altadena Drive will
be completed. The new distribution
main projects are now being opened
under "Distribution Mains - FY 2020-
2024" (1080).
780,000
99% 6/30/2022 Construction67,067,980
525,0002,625,000Customer Information System
Managed Services - Water
10966 Procurement for managed services
for the Customer Information System
began in the second quarter.

In FY 2022, contract with vendors to
provide managed services for the
Oracle C2M Customer Information
System will begin. The managed
services will continue to enhance the
system.
525,000
0% 6/30/2024 Planning0
100,000125,000Laboratory Information
Management System
10947 Configuration of the Laboratory
Information Management System
began in the second quarter. The
system is anticipated to move to the
test phase in the third quarter and to
complete in the fourth quarter.

In FY 2022, a LIMS vendor will be
selected and a LIMS will be
implemented.
50,000
23% 6/30/2022 Construction23,199
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 17

Page 587 ends

8,961,2638,961,263Customer Information System10118 System integration testing continued in the second quarter.

This project is delayed due to the
identification of higher than expected
number of deficiencies during
testing. The deficiencies primarily
located in the data conversion,
system configuration and end-user
training are anticipated to be
corrected in the fourth quarter.

In FY 2022, the implementation of the
new Customer Information System will
be completed.
742,000
72% 12/31/2021 6/30/2023 Construction6,439,289
6,339,00011,789,000Well Improvements10749 The construction of the Garfield Replacement Well project began in
the second quarter.

In FY 2022, a below grade well
construction may begin depending on
water quality results from the
monitoring well. Other well equipment
will be replaced as required. Additional
wells will be assessed for
abandonment.
3,150,000
34% 6/30/2023 Construction2,171,769
4,940,0007,840,000Booster Improvements107310 Design of the Ross Booster Station upgrades was completed in the
second quarter. Preliminary
construction drawings for the new
transformer were finalized.

Coordinating project review with
Metropolitan Water District in
compliance with terms of the
accompanying easement.

In FY 2022, construction of Ross
Booster Station upgrades will be
completed and booster pumps will be
replaced as required.
1,650,000
71% 6/30/2023 Design3,516,153
361,491369,491Field Services and Meter Reading
Automation
101211 No reportable activity in the second
quarter.

In FY 2022, ongoing software and
hardware upgrades for meter reading
and drive-by routing, will continue as
needed.
8,000
34% 6/30/2022 No Activity This
Quarter
123,677
3,845,00013,895,000Meters and Services - FY 2020 -
2024
108112 In the second quarter, 410 small
meters and 5 large meters were
replaced and 5 domestic and fire
services were renewed. Staff is
reviewing the project expenditures
and will take appropriate action to
address the project imbalance.

In FY 2022, small and large meter
installations are planned. Domestic
and fire service renewals and
abandonments are also anticipated.

Vaults will be replaced and a pilot
program for testing smart water
metering systems will begin.
1,000,000
102% 6/30/2024 Ongoing3,920,203
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 18

Page 588 ends

440,0001,240,000Monk Hill Groundwater Treatment
Improvements
107613 The re-designed plans submitted by
NASA's consultant were reviewed in
the second quarter.

In FY 2022, environmental review will
be completed. Construction of the
Explorer Well will begin.
250,000
21% 6/30/2023 Design90,640
660,000710,000Computerized Maintenance
Management System
108914 The RFP was completed for
solicitation of a software solution and
implementation support in the
second quarter. Additional
professional consulting services will
be secured to augment staff
resources to evaluate RFP
responses and prepare
recommendations.

In FY 2022, the CMMS Assessment
and Implementation Plan will continue
the CMMS software procurement and
implementation plan.
10,000
26% 6/30/2024 Planning173,581
295,000785,000Geographic Information System
(GIS) Enhancements
108415 The tools/scripts were updated to
import data from C2M, and export to
C2M non-production environments
for systems integration testing in the
second quarter.

In FY 2022, projects will include
mobile or field unit hardware, GIS
software configuration, GIS tools and
web services development,
development of utility network and GIS
roadmap, and third party software
interface needs analysis.
175,000
24% 6/30/2024 Ongoing71,071
402,000647,000Management Information Systems
- FY 2020 - 2024
108316 No reportable activity in the second
quarter.

In FY 2022, projects include
implement vulnerability assessment
recommendation, IT data center
miscellaneous hardware and software,
and network equipment for switches
and firewalls.
87,500
46% 6/30/2024 No Activity This
Quarter
183,984
2,210,0004,910,000Local Non-Potable Water Project109517 Pending approval of an exemption from full environmental review,
preparations are underway for a
permanent tank installation and an
evaluation of existing pipelines.

In FY 2022, the irrigation system will
be connected to Brookside Golf
Course, Brookside Park and Area H.

Approximately 4,600 feet of 24”
pipeline will be installed from Devil’s
Gate Dam to PWP spreading basins
for the Pump Back Project.
1,500,000
28% 6/30/2025 Ongoing626,492
415,0001,415,000Water Operations/Meter Shop109018 No reportable activity in the second quarter.

In FY 2022, site selection and design
of an operations building will begin.
250,000
7% 6/30/2024 No Activity This
Quarter
27,878
45,000115,000Radio Equipment Replacement -
FY 2020 - 2024
108619 No reportable activity in the second
quarter.

In FY 2022, radios and/or equipment
will be purchased as needed.
25,000
0% 6/30/2024 No Activity This
Quarter
0 Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 19

Page 589 ends

2,728,0462,728,046Water and Power Warehouse
Modernization
105620 No reportable activity in the second
quarter.

In FY2022, projects include locker
room and shower facility
upgrades.  Additional upgrades and
improvements in the warehouse
building, premises, racks, and material
handling equipment will continue for
Electric and Water utility functions as
needed.
10,000
84% 6/30/2024 No Activity This
Quarter
2,304,106
4,133,00011,083,000Customer Driven - Mains, Meters,
and Service - FY 2020 - 2024
108221 There were 15 water service
applications and deposits received
from customers and developers in
the second quarter. Installation of 9
projects were completed including
the following 25 tasks: 9 domestic
services, 5 fire services with
backflow prevention devices, 2
meters, and 9 service
abandonments.

In FY 2022, crews will install new
meters, services, mains, fire hydrants,
gate valves, and services including
final paving of trenches. Planned
projects include Lake Avenue and
Union Street.
800,000
75% 6/30/2024 Ongoing3,087,976
2,220,00012,645,000Treatment Systems109122 A contract was awarded by City Council on December 13, 2021 for
the design and delivery of liquid
phase granular activated carbon and
vessels. Design for construction of
the Wadsworth Treatment Plant was
completed in the second quarter.

In FY 2022, two east side wells that
exceed maximum contaminant levels
1, 2, 3-trichloropropane (TCP) are
expected to begin construction. A well
that has not been operational since
2006, will also be included for
treatment once the well is
rehabilitated.
1,900,000
21% 6/30/2024 Design463,755
1,185,0002,525,000Emergency Generator - Water107923 A construction contract to connect generators to the booster stations
was awarded by City Council on
December 13, 2021.

In FY 2022, design for stationary
generators at booster stations and
wells will be completed along with
installation of stationary generator at
Wadsworth.
250,000
46% 6/30/2025 Construction547,337
8,252,67411,002,674Non-Potable Water Project101324 A feasibility study for the potable water interconnections with LADWP
continued in the second quarter.

In FY 2022, a feasibility study,
environmental documents, permits,
and regulatory agency approvals will
be completed. Construction of the
interconnections and the treatment
facility will begin.
750,000
94% 6/30/2024 Ongoing7,786,582
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 20

Page 590 ends

630,0004,055,000Reservoir Improvements109325 The Don Benito Reservoir assessment continued in the second
quarter.

In FY 2022, assessment of a reservoir
replacement will begin.  Reservoir
improvements will be performed as
needed.
180,000
81% 6/30/2025 Planning513,013
145,000410,000Water SCADA Improvements - FY
2020 - 2024
108726 SCADA communication circuits were
assessed for cellular upgrades in the
second quarter.

In FY 2022, upgrades to radio
transmission for the Water SCADA
system communications and remote
terminal units (RTU) upgrades will
continue and a full system upgrade will
be assessed.
100,000
24% 6/30/2024 Ongoing34,130
165,000256,000Water Facilities Improvement
Initiative
109227 Schematic designs for the Jones
Reservoir adjacent area (Sierra
Madre Blvd. median) were
completed in the second quarter.

Construction is anticipated to begin
in the third quarter.

In FY 2022, Hugels, a regenerative
landscape technique, will be
implemented at Jones Reservoir and
adjacent areas, and at the Sheldon
Community Demonstration Garden or
alternative site. Assess Linda Vista
Booster Station site for regenerative
landscape planting.
40,000
54% 6/30/2024 Design89,368
18,00018,000Interactive Voice Response
System (IVR) - FY 2020 - 2024
108528 No reportable activity in the second
quarter.

In FY 2022, enhancements and
modifications to improve customer
service experience will be completed
as needed.  Interactive Voice
Response (IVR) system menu will be
modified, and interface with payments
IVR will be designed and developed.
17,500
0% 6/30/2024 No Activity This
Quarter
0 Electric System
34,700,50335,350,503GT-1 and GT-2 Upgrades and
Replacements
31821 Due to air permit limitations, an
alternative solution to a gas
compressor was ordered that will
repair the units and return them to 22
mega-watts while retaining safety
and reliability features in the second
quarter.

In FY 2022, the GT-1 & GT-2 controls
system retrofit, the Generator Step Up
Transformer Containment, and GT1
Ammonia Continuous Emissions
Monitoring Systems Installation will be
completed.
3,378,453
94% 6/30/2022 Ongoing32,776,780
3,175,00012,775,000Conductor Replacement Program
- FY 2020 - 2024
32262 The design for cable replacement on
Lincoln Circuit continued in the
second quarter.

In FY 2022, cable replacement on
Lincoln Circuit will be completed.

Other projects will be completed as
needed.
2,074,000
15% 6/30/2024 Ongoing490,872
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 21

Page 591 ends

4,987,57113,987,5714kV to 17kV Distribution System
Conversions - FY 2020 - 2024
32273 Work for the 4kV to 17kV conversion
along Dunham Alley was completed
in the second quarter. In addition, the
design continued for the 4kV to 17kV
conversion of the F9 circuit and
began for the F11 circuit.

In FY 2022, conversions and
backbone enhancements will be
completed from circuit F9 to Lincoln
Avenue. Additional conversion projects
may occur based on operational
needs or to prepare for major
developments.
1,840,000
42% 6/30/2024 Ongoing2,104,199
19,411,43319,411,433Customer Information System30224 System integration testing continued in the second quarter.

This project is delayed due to the
identification of higher than expected
number of deficiencies during
testing. The deficiencies primarily
located in the data conversion,
system configuration and end-user
training are anticipated to be
corrected in the fourth quarter.

In FY 2022, the implementation of the
new CIS will be completed.
3,990,523
63% 12/31/2021 6/30/2023 Construction12,132,615
12,398,00023,298,000Installation of Low Voltage
Electrical Services
32215 Staff completed 182 residential and
commercial installation requests for
new service, modifications, and
upgrades from the public right of way
in the second quarter. In addition,
107 solar connections were
completed.

In FY 2022, modifications, upgrades,
solar installations, telecom, unmetered
service, or new low voltage electric
service will be installed as requested.

Installation of service conductors to
provide electrical service will be
installed, as needed.
2,617,000
88% 6/30/2024 Ongoing10,871,778
11,223,00021,523,000Installation of High Voltage
Electrical Services
32206 Installation of 5 private property
electric service in response to
customer requests for new service,
modifications, and upgrades were
completed in the second quarter.

In addition, 27 new applications were
processed and initiated.

In FY 2022, modifications, upgrades or
new high voltage electric service will
be completed as requested.

Installation of cables, conduits,
switches, transformers, and meters will
be installed as necessary.
2,442,000
84% 6/30/2024 Ongoing9,387,879
2,240,0007,105,000Chester to Santa Anita 34kV
Cable Replacement
32687 Design for the replacement of the
35kV subtransmission line between
Santa Anita Receiving Station and
Chester Substation was completed in
the second quarter.

In FY 2022, 34-20 subtransmission
line between Chester and Santa Anita
substations will be replaced through
existing Infrastructure. Feasibility study
for new Chester Substation 35 kV
switchgear will be completed.
2,240,000
1% 6/30/2024 Design17,815
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 22

Page 592 ends

6,815,3679,158,467GT-3 and GT-4 Upgrades and
Replacements
31868 Bids for the GT-3 and GT-4 Selective
Catalytic Reduction (SCR)
specification were received in the
second quarter.

In FY 2022, planned projects include
the recoating of the cooling tower
basin, GT 3/4 SCR & CO Catalyst
Retrofit, upgrade GT4 silencers, and
miscellaneous improvements on an as
needed basis.
3,991,050
37% 6/30/2023 Ongoing2,519,377
3,900,00011,900,000Electrical Vault Replacement and
Reinforcement - FY 2020 - 2024
32299 Designs for 10 underground vault
reinforcements were completed in
the second quarter. In addition, 5
vault and/or pullbox replacements
were completed.

In FY 2022, 33 vaults and/or pullboxes
will be reinforced or replaced.
1,900,000
49% 6/30/2024 Ongoing1,919,058
3,723,00011,723,000Distribution Switch Replacements
- FY 2020 - 2024
323110 13 switch replacements were
completed and 5 switch replacement
issued for construction in the second
quarter.

In FY 2022, 26 distribution switches
will be replaced based on oil test
results and field evaluation.
1,823,000
48% 6/30/2024 Ongoing1,791,624
2,064,3201,802,600Power Production Facility
Improvements - FY 2020 - 2025
323611 No reportable activity in the second
quarter.

Contract work is anticipated to begin
in the third quarter.

In FY 2022, planned projects include:
fountain rehabilitation, landscape
design overhaul, procurement of a
new trailer for instrumentation group,
installation of a new perimeter wall at
Azusa Hydro, physical security
improvements, and miscellaneous
facility improvements on an as-needed
basis.
1,194,600
31% 6/30/2025 No Activity This
Quarter
633,343
2,564,7587,364,758Receiving Station 35kV Upgrades326212 The 35-kV Potential Transformer Fuse upgrades were completed for
Glenarm Receiving Station D in the
second quarter.

In FY 2022, the upgrade of five 35 kV
potential transformer systems, 35 kV
Santa Anita capacitor 4 interrupter,
Santa Anita control house battery
charger, and 34-7 and 34-8 line
protection upgrades will be completed.
1,210,000
54% 6/30/2025 Ongoing1,382,073
8,638,00019,038,000Electric Vehicle Charging
Infrastructure
322513 Construction at Arroyo Parkway
Charging Depot (Phase 1) was
completed in the second quarter. In
addition, work related to projects at
Victory Park, Robinson Park, and Del
Mar garage continued.

In FY 2022, expansion/upgrades are
planned at Victory Park, Robinson
Park, Arroyo Parkway Charging Plaza,
and a fire station.
3,425,000
47% 6/30/2025 Ongoing4,040,986
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 23

Page 593 ends

2,200,0006,600,000Distribution Transformer
Replacements - FY 2020 - 2024
323714 Replacement of 8 transformers was
completed in the second quarter, and
the designs for 4 additional are in
progress.

In FY 2022, 15 transformers will be
replaced on field inspection or a
modeling indication of overloading.
1,050,000
63% 6/30/2024 Ongoing1,384,971
3,038,2783,838,278Work Order Management System
- Power Department
314016 The RFP was completed for
solicitation of a software solution and
implementation support in the
second quarter. Additional
professional consulting services will
be secured to augment staff
resources to evaluate RFP
responses and prepare
recommendations.

In FY 2022, staff will acquire the
services of a qualified vendor to
acquire system software or software
as a service license, complete detailed
system design, software installation,
and begin system integration and
configuration.
1,268,000
46% 6/30/2024 Planning1,408,861
80,000298,000Replacement of Power Plant
Instruments and Controls - FY
2020 - 2024
323217 No reportable activity in the second
quarter.

In FY 2022, instruments and controls
for the Glenarm Power Plant will be
procured as needed.
54,300
3% 6/30/2024 Ongoing2,280
6,050,0003,950,000New 34.5 kV Circuit from Oak
Knoll to Santa Anita
326418 Construction of the civil infrastructure
required for installation of the new
subtransmission line between the
Oak Knoll Substation and the Santa
Anita Receiving Station continued in
the second quarter.

In FY 2022, line protection relays for
the new sub transmission circuit
between Santa Anita and Oak Knoll
(34-38) will be installed.
500,000
64% 6/30/2024 Construction3,896,719
975,0004,875,000Customer Information System
Managed Services - Power
327119 A request for proposals was issued
to provide managed services for the
Customer Information System in the
second quarter.

In FY 2022, contract with vendors to
provide managed services for the
Oracle C2M Customer Information
System will begin and the managed
services will continue to enhance the
system.
975,000
0% 6/30/2024 Planning0
2,457,0006,457,000Deteriorated Pole Replacement
Program
323320 Replacements of 12 poles were
completed and design for 16
additional pole replacements
continued in the second quarter.

In FY 2022, 65 poles will be replaced
based on inspection and evaluation
criteria.
1,000,000
63% 6/30/2024 Ongoing1,559,407
2,800,0004,000,000Seismic Upgrade of Power
Facilities
319621 Contract awards for both Brookside
and Oak Knoll substations seismic
designs are in progress.

In FY 2022, the seismic upgrade of the
Brookside and Oak Knoll substations
will be completed.
523,000
56% 6/30/2024 Design1,579,101
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 24

Page 594 ends

980,000980,000Customer Load Research
Program - FY 2020 - 2024
324122 No reportable activity in the second
quarter.

In FY 2022, the ongoing replacement
of failing or analog electric customer
meters with load research/automated
metering equipment and connection to
the MV-90 system will continue.
300,000
66% 6/30/2024 No Activity This
Quarter
648,671
506,356506,356Advanced Metering Infrastructure
(AMI)
314223 No reportable activity in the second
quarter.

The AMI smart meter project is
dependent on the Customer
Information System (CIS) project.

With the 90 day extension of the CIS
implementation, the start of the AMI
needs assessment, business case
and roadmap will be delayed.

In FY 2022, a needs assessment,
business case, and roadmap will be
conducted.
200,000
60% 12/31/2025 No Activity This
Quarter
305,166
5,255,0016,255,001Distribution System Automation319224 Design for the City Yards Automatic Transfer Switch (ATS) was
completed in the second quarter with
construction to begin in the third
quarter. Design for the City Hall ATS
continued.

In FY 2022, two automated switches
will be installed to communicate with
the PWP Supervisory Control and
Data Acquisition (SCADA) system.

One Automated Transfer Switch (ATS)
system will be installed to provide
greater reliability at City Hall.
480,000
81% 6/30/2024 Ongoing4,271,462
1,550,0004,850,000Fire Threat Mitigation Tier 2 Areas325825 Procurement of a pole inspection contract to identify required pole
upgrades continued in the second
quarter.

In FY 2022, pole upgrades and new
equipment will be installed in tier 2
areas to mitigate the impact of
potential wildfires.
600,000
44% 6/30/2024 Planning684,593
650,000650,000Fire Threat Mitigation Tier 3 Areas325726 No reportable activity in the second quarter.

The work plan to underground high
voltage overhead circuitry to mitigate
the fire risk in neighborhoods in the
elevated or extreme fire risk areas of
the City will be captured under CIP
3216 in the Street Lighting and Electric
Undergrounding (Fund 206).
0 32% 6/30/2024 No Activity This
Quarter
207,013
4,132,0006,882,000Emergency Transmission and
Distribution System
Replacements
322227 Emergency infrastructure
replacements for 9 equipment
failures were completed in the
second quarter.

In FY 2022, emergency replacements
and repairs to transmission,
distribution, and substation systems
will be completed on an as needed
basis.
752,000
83% 6/30/2024 Ongoing3,442,974
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 25

Page 595 ends

330,0001,030,000Restraint Systems and Lid
Enhancement for Vault Manhole
Covers
323028 Installation of 5 vault lid restraint
systems was completed in the
second quarter. Design and
construction permits of 10 additional
vault lids continued.

In FY 2022, restraint system and lid
enhancement for 15 vault/manhole
covers will be completed.
174,000
49% 6/30/2024 Ongoing162,661
2,130,0002,239,000Emergency Generator - Power322329 Staff is evaluating various options, including battery storage at key
locations or the installation of an
emergency generator.

In FY 2022, an assessment will be
conducted for an emergency
generator.  The most feasible
generator will be procured based on
the conducted assessment.
1,156,590
0% 6/30/2022 6/30/2023 Planning0
1,480,0002,080,000Substation Modernization323530 Hastings Substation Unit 1 modernization and Eastern Unit 1
and Unit 2 transformer modernization
projects were completed in the
second quarter. In addition, the
emergency upgrade of Eastern Bank
1A load tap changer was completed.

In FY 2022, the design, procurement,
and construction of Hastings
Substation Unit 1 modernization will
be completed.
300,000
86% 6/30/2024 Ongoing1,272,472
600,0003,000,000Customer Facility Replacements326931 Meter and distribution equipment projects for 2 customer sites were
completed in the second quarter.

In FY 2022, 10 units will be replaced
based on field recommendation and
resource availability.
600,000
8% 6/30/2024 Ongoing50,351
520,0001,120,000Security, Access Control, and
Lighting at Power Facilities
324832 Design for security enhancements at
Santa Anita Receiving Station and at
Fair Oaks Substation continued in
the second quarter.

In FY 2022, design and construction of
security, access control, and lighting
for the Santa Anita Receiving Station
and Fair Oaks Substation will be
completed.
272,000
23% 6/30/2024 Ongoing119,167
460,000485,000Security Enhancements at
Glenarm Receiving Station and
Dispatch Center
324733 No reportable activity in the second
quarter. Construction is anticipated to
begin in the fourth quarter.

In FY 2022, design and construction of
security enhancements at Glenarm
Receiving Station and Dispatch Center
will be completed.
226,000
13% 6/30/2024 Design58,629
1,650,0008,686,000Santa Anita 35kV Receiving
Station Upgrades
326034 Design for the protection and control
upgrades of Santa Anita Receiving
Station circuit breakers in 35kV
Racks continued in the second
quarter. In addition, engineering
design and procurement for 34-18
and 34-38 protection and control
upgrades began.

In FY 2022, staff will develop
specifications for Engineering,
Procurement, and Construct contract
for the protection upgrades for all
remaining Santa Anita Receiving
Station 25kV circuit breakers.
500,000
45% 6/30/2024 Ongoing742,921
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 26

Page 596 ends

480,000880,000Distribution System GIS
Enhancements - FY 2020 - 2024
324635 Development of GIS applications or
tools as needed to support PWP
operations continued in the second
quarter.

In FY 2022, staff will create a tool to
produce Sectionalizing Maps directly
from GIS which will replace AutoCAD
generated maps.
225,000
3% 6/30/2024 Ongoing14,566
5,350,0006,350,000Distribution System Expansion -
FY 2020 - 2024
322836 The Shopper's Lane civil
construction design and permits
were completed in the second
quarter. In addition, design and
construction of system improvements
to support customers are being
completed on an as needed basis.

In FY 2022, underground infrastructure
for customer related projects will be
enhanced and expanded.
200,000
83% 6/30/2024 Ongoing4,436,345
840,00018,060,000Station Transformer Upgrades325937 No reportable activity in the second quarter.

In FY 2022, projects include a mobile
transformer contract to be issued, unit
substation transformer upgrade
proposal, and ongoing feasibility study
for phase shift transformer at Glenarm
Receiving Station will continue.
414,000
18% 6/30/2024 No Activity This
Quarter
153,654
200,000472,500Power Supply Integrated
Resource Planning and Design -
FY 2020 - 2025
324938 The 2021 IRP Update was
completed in the second quarter. City
subcommittees have been regularly
updated and City Council approval is
anticipated in the third quarter.

In FY 2022, continue work on the 2019
Integrated Resource Plan (IRP) will
continue. Development of new
assumptions, community outreach,
modeling, and analysis will occur.
120,000
61% 6/30/2025 Ongoing122,723
810,00021,090,000T.M. Goodrich Receiving Station
Upgrades
326339 No reportable activity in the second
quarter.

In FY 2022, the design, procurement,
and construction of TM Goodrich 220
kV metering upgrades will be
completed.
350,000
23% 6/30/2024 No Activity This
Quarter
184,224
1,140,0003,640,000Primary Dispatch Facility
Remodel
325340 Coordination of power rerouting to
transition the dispatch
facility from the east side switch gear
to a new dedicated switch gear
continued in the second quarter.

In FY 2022, proposals for the Primary
Dispatch Center remodel and service
upgrade project will be reviewed. The
engineering design phase of the
remodel and service upgrade portion
of the project will begin. In addition,
the project will complete design and
construction to transition the dispatch
facility off the East Side switch gear to
a new dedicated switch gear.
930,240
2% 6/30/2024 Planning19,613
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 27

Page 597 ends

4,062,3528,062,352Substation Oil Containment312841 Design for the Wilson Substation continued and design for the Oak
Knoll Substation began in the second
quarter.

In FY 2022, a new oil containment
system for the Villa Substation will be
constructed. The design and
construction of new oil containment
systems for the Oak Knoll and Wilson
Substations will begin.
995,000
74% 6/30/2024 Ongoing3,007,018
680,0001,630,000Power System Equipment325442 Procurement of test equipment for the distribution system continued in
the second quarter.

In FY 2022, major tools will be
purchased after a field evaluation.
300,467
36% 6/30/2024 Ongoing244,518
455,0001,055,000Fiber Optic Cable Expansions /
Overbuilds - FY 2020 - 2022
324443 Design to extend fiber optic cable to
a recloser on the Belmont circuit
began in the second quarter.

In FY 2022, PWP will work in
coordination with DoIT in completing
Hill Area Expansion, South Lake
Expansion, and Colorado Expansion
fiber optic projects.
75,000
32% 6/30/2024 Ongoing143,547
19,721,98219,721,982Water and Power Warehouse
Modernization
317544 No reportable activity in the second
quarter.

In FY 2022, projects include locker
room and shower facility upgrades.

Additional upgrades and
improvements in the warehouse
building, premises, racks, and material
handling equipment will continue for
Electric and Water utility functions as
needed.
750,000
91% 6/30/2024 No Activity This
Quarter
17,897,462
9,148,9999,287,000Power Transmission Program319045 LADWP is the operating agent for this project and has primary
responsibility for developing the
capital work schedule. Work
continued on the following main
projects: AC/DC Filter replacement,
Porcelain Insulator replacement, and
3-230 kV shunt Reactor Bushings in
the second quarter.

In FY 2022, work will continue on
the Porcelain Insulators Replacement
project, the Reactor Bushing
Replacement project, and any
unforeseen miscellaneous projects.

The DC Electrode Project (Land
Portion) and Submarine Segment of
Sylmar Electric Line Replacement
project will be completed.
111,858
93% 6/30/2024 Ongoing8,489,740
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 28

Page 598 ends

583,000823,606Power Transmission Program -
FY 2020 - 2024
325146 LADWP is the operating agent for
this project and has primary
responsibility for developing the
capital work schedule. Work
continued on the following main
projects: 480V Breaker replacement,
AC units for Converter 1 & 2 Valve
Halls replacement, fire protection
system replacement, and Old
Ground System removal in the
second quarter.

In FY 2022, replacement of the 480 V
breaker at Sylmar Converter Station,
main gate security cameras and card
reader installation, replacement of 3
IGS Towers, air conditioning unit
replacement for Converter 1 & 2 Valve
Halls, and Phase 2 of the Fire
Protection System Replacement will
continue.
443,848
2% 6/30/2024 Ongoing11,937
600,0006,000,000Supervisory Control and Data
Acquisition (SCADA) System
Expansion - FY 2020 - 2024
324547 No reportable activity in the second
quarter.

In FY 2022, installation of SCADA
Human Machine Interfaces at the TM
Goodrich and Santa Anita Receiving
Stations will continue.
170,000
27% 6/30/2024 Ongoing164,079
365,0008,675,000Fair Oaks Substation Upgrades326748 No reportable activity in the second quarter.

In FY 2022, staff will develop
specifications for Engineering,
Procurement, and Construct (EPC)
contract for the new Fair Oaks unit
substation.
165,000
2% 6/30/2024 No Activity This
Quarter
6,735
634,0001,121,500Management Information Systems
- Power - FY 2020 - 2024
323949 No reportable activity in the second
quarter.

In FY 2022, recommendations from a
cyber security vulnerabilities
assessment will be
implemented.  Additionally, information
technology hardware and software
along with network equipment projects
will take place.
113,750
59% 6/30/2024 No Activity This
Quarter
373,617
1,526,6033,137,603Santa Anita 17kV Substation
Upgrades
326150 Assessment of the Santa Anita 17 kV
open-air rack arc flash and incident
energy upgrade was completed in
the second quarter.

In FY 2022, the design and
procurement for Santa Anita 17 kV
open-air rack arc flash and incident
energy upgrades will be completed.
96,000
91% 6/30/2024 Ongoing1,388,274
321,0001,231,000Geographic Information System
(GIS) Enhancements
324051 The tools/scripts were updated to
import data from C2M and export to
C2M non-production environments
for systems integration testing in the
second quarter.

In FY 2022, purchases and work will
be done for the following projects:
mobile or field units hardware, GIS
software configuration, GIS tools and
web services development,
development of utility network and GIS
roadmap, and third party software
interface needs analysis.
308,750
26% 6/30/2024 Ongoing84,632
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 29

Page 599 ends

1,043,0002,243,000Distribution Volt/Var
Enhancements - FY 2020 - 2024
325252 Testing and procurement of the
batteries to be installed on the
distribution system pilot project was
completed in the second quarter. In
addition, design for a switched
capacitor bank was completed.

In FY 2022, a switched capacitor bank
solution will be installed to alleviate
low voltage problems in the system.

Voltage correction projects will be
completed as needed when identified
by recorded voltage abnormalities or
when customers request connection or
upgrade of a service connection.

Additionally, a pilot project to deploy
distribution battery storage systems
will be completed.
95,000
44% 6/30/2024 Ongoing460,270
250,000570,000Power Quality Meter Upgrades -
FY 2020 - 2024
325053 The engineering design and
procurement for the GT-3 and GT-4
power quality meter upgrades were
completed in the second quarter.

In FY 2022, two power quality meters
for GT-3 and GT-4 will be installed.
80,000
24% 6/30/2024 Ongoing60,434
200,0005,277,000Glenarm Receiving Station
Upgrades
326654 Design and procurement for
upgrades to the GT-3 and GT-4 line
current differential relay were
completed in the second quarter. In
addition, preliminary design for the
LA Line Load Shedding project
continued.

In FY 2022, on-going feasibility study
for new Glenarm Receiving Station
control house will continue.
20,000
48% 6/30/2024 Ongoing96,300
4,642,0004,642,000Transmission System
Enhancements
319555 No reportable activity in the second
quarter.

In FY 2022, payments for various
transmission equipment replacements
with Southern California Edison will be
completed.
200,000
71% 6/30/2024 No Activity This
Quarter
3,306,499
83,000148,000Interactive Voice Response
System - FY 2020 - 2024
324256 No reportable activity in the second
quarter.

In FY 2022, enhancements and
modifications to improve customer
experience will be completed as
needed. The IVR system menu will be
modified and interface with payments
IVR will be designed and developed.
32,500
0% 6/30/2024 No Activity This
Quarter
0 55,000115,000Radio Equipment Replacement -
Power - FY 2020 - 2024
324357 No reportable activity in the second
quarter.

In FY 2022, additional radios and/or
equipment will be purchased as
needed.
25,000
0% 6/30/2024 No Activity This
Quarter
0 208,600208,600Production Cost Model Software322459 No reportable activity in the second quarter.

In FY 2022, a Production Cost
Modeling software will be
implemented.
108,600
0% 6/30/2023 No Activity This
Quarter
0 Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 30

Page 600 ends

163,000381,000Power Facility Wastewater /
Storm Water Capture and
Treatment
327060 The wastewater permit was
approved that will allow
improvements to redirect catch
basins in the second quarter.

In FY 2022, staff will address issues
with wastewater treatment, storage,
recycling, and disposal facilities at the
power plants on an as-needed
basis.  It is anticipated that this project
will continue after FY 2022.
163,000
0% 6/30/2026 Ongoing0
4,200,0004,200,000Subtransmission System
Enhancements
320561 No reportable activity in the second
quarter.

In FY 2022, terminator replacement
will be conducted based on the
inspection program.  Vault vents and
blowers will be installed on ten vaults
along the cross-town system.
743,000
72% 6/30/2020 6/30/2022 No Activity This
Quarter
3,029,215
502,900720,900Power Supply Facility Security -
FY 2020 - 2024
323462 Contract negotiations are complete
and work is anticipated to begin in
the third quarter.

In FY 2022, the following work will
continue at the Broadway Plant:
migrate from Honeywell MaxPro Video
Management System to the new
unified opened Genetec Security
System; upgrade outdated analog
surveillance cameras to Axis 1080p or
4K IP cameras; install new thermal
and radar detector cameras for early
detection of bad actors; and migrate
Honeywell WinPak access control
(badge system) into unified integrated
Genetec Security System, pending the
access control migration plan.
162,900
21% 6/30/2024 Ongoing106,868
Technology Projects
5,073,2255,073,225Land Management System (LMS)
Replacement
711521 The Public Works Storage Container
(POD) online permit application was
launched in the second quarter.

Additional online permits including
the Public Works Sidewalk Vending,
Public Works Banners, and Public
Works Dining are being planned and
anticipated to launch by the fourth
quarter.

Phase 3 (Public Works permits and
other inspection functions) will go live
in FY 2022.
150,00092% 6/30/2022 Construction4,674,937
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 31

Page 601 ends

3,550,0003,550,000Police Computer-Aided Dispatch
and Records Management
System Replacement
711682 The remaining 20 configuration
workshops were completed in the
second quarter. To date, 35
configuration workshops are
complete. An officer and staff training
plan is under development.

Implementation will be completed in
FY 2022.
1,600,000
22% N/A Construction774,368
5,685,5018,235,501DoIT Equipment Lifecycle
Replacement FY 2020 - FY 2024
711653 Network and server infrastructure
equipment and software updates
continued as part of planned lifecycle
replacements in the second quarter.

Server and storage lifecycle
replacement migrations are in
progress and scheduled to be
completed by the fourth quarter.

Assessment workshops were also
completed for the replacement of the
City’s aging Private Branch
Exchange telephone system and for
the security enhancement of devices
attached to the City’s data network.

These projects are anticipated to
advertise in the third quarter.

Annual system life cycle replacement
of hardware and software will continue
in FY 2022.
1,500,000
43% 6/30/2024 Ongoing2,462,253
8,800,0008,800,000Radio Communication Equipment
Upgrade and Replacement
711664 This project was completed in the
second quarter.

Replacement of the custom helicopter
radios will be completed in FY 2022.
840,000
98% 12/31/2021 Completed8,613,046
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 32

Page 602 ends

2,328,2983,140,411Enterprise Building Security
Management
711635 Building security improvements at
the Villa Parke Community Center
Branch Library and La Pintoresca
Branch Library were completed in
the second quarter. Also, a contract
for construction was awarded for the
exterior park security improvements
at Villa Parke on October 25, 2021.

Work on this site is anticipated to
begin in the third quarter. In addition,
Community Development Block
Grant (CDBG) funding was approved
for exterior security improvements at
three additional sites: La Pintoresca
and Robinson parks, and the Jackie
Robinson Community Center.

Preliminary security enhancement
design for three libraries were also
completed in the second quarter.

Work will be completed on building
access control systems and other
security improvements at various
library locations in FY 2022.
550,000
63% 6/30/2022 Construction1,456,664
1,711,6533,211,653City Fiber Network Expansion FY
2020 - FY 2024
711676 Fiber installation at two City parking
garages (De Lacey and Plaza Las
Fuentes) and at the Arroyo EV
Charging Plaza in the second
quarter. Additional installations were
completed at the City Yards, other
Water & Power sites, and along Lida
Street for future expansion to the Art
Center Hillside campus.

Fiber connections to City-owned
parking facilities will be completed and
additional fiber expansion along
Colorado Blvd and South Lake Ave will
begin to augment existing fiber paths
and support future economic
development in FY 2022.
500,000
37% 6/30/2022 Ongoing637,116
653,513653,513Police Jail Access Control and
Monitoring System Replacement
7181112 This project is delayed due to
expanded scope of work to include
electrical and fire panel upgrades.

The electrical panel upgrade was
completed in the second quarter and
the fire panel is pending final fire
inspector approval. Final integration
of the Jail Access Control System
with the fire alarm will follow
completion of the fire panel upgrade.

Implementation will be completed in
FY 2022.
83,074
87% 12/31/2021 3/31/2022 Construction570,439
Capital Improvement Program
FY 2022 Quarter Monitoring Report
Activity Through December 31, 2021
Priority
Total
Estimated
CostProject Name
Appropriation
Thru FY 2022
FY 2022
Anticipated
Expenditures Status UpdateFY 2022 Workplan ScheduleProject# % of
Appropriations
Spent To Date
Revised
Completion
Date
Target
Completion
Date Phase
Expenditures
Life of
Project
February 7, 2022 Page 33

Page 603 ends
← All documents from this meeting