Agenda packet — Livermore City Council, May 16, 2022

CITY COUNCIL
AGENDA
MONDAY, MAY 16, 2022
WORKSHOP MEETING –
5:00 PM

MEETING PARTICIPATION INFORMATION CAN BE FOUND AT THE END OF THE AGENDA
IN PERSON INFORMATION:

CIVIC CENTER MEETING HALL

CITY COUNCIL CHAMBERS
1016 S. LIVERMORE AVENUE
TELECONFERENCE INFORMATION:

CITY OF LIVERMORE YOUTUBE CHANNEL:
https://www.youtube.com/c/CityofLivermoreCalifornia
ZOOM WEBINAR:
https://us02web.zoom.us/j/86073271313
Zoom dial in phone number:
1 669 900 6833
Meeting ID: 860 7327 1313
NOTICE IS HEREBY GIVEN that the City Council of the City of Livermore will convene a City Council special meeting on May 16, 2022 beginning at 5:00 pm, held in the locations listed above. This special meeting is being called by Mayor Bob Woerner. /s/ Bob Woerner Bob Woerner, Mayor
Regina Bonanno, Vice Mayor
Robert W Carling, Council Member
Brittni Kiick, Council Member
Trish Munro, Council Member
Livermore City Council Agenda
May 16, 2022

1 1.

CALL TO ORDER - 5:00 PM

2. ROLL CALL

Council Member Robert W. Carling
Council Member Brittni Kiick
Council Member Trish Munro
Vice Mayor Regina Bonanno
Mayor Bob Woerner

3. SPECIAL MEETING WORKSHOP ITEM

AN OPPORTUNITY FOR THE PUBLIC TO ADDRESS THE CITY COUNCIL REGARDING THE SPECIAL MEETING ITEM WILL BE PROVIDED BY THE MAYOR.

3.1 Proposed Fiscal Year 2021-23 Financial Plan Update

Recommendation:

Staff recommends the City Council provide direction regarding the Proposed Fiscal Year 2021-23 Financial Plan Update.

Staff Report

Attachments:

1. FY 2021-23 Budget Book Update

2. General Fund Revenue & Expense Table

3. FY 21-23 CIP Update Pie Chart

4. Project by Program Schedule

4. ADJOURNMENT

To a Regular City Council meeting on Monday, May 23, 2022 at 7:00 pm, Civic Center Meeting Hall, City Council Chambers, 1016 S. Livermore Avenue and virtually using Zoom.

5. SUPPLEMENTAL MATERIALS

5.1 Supplemental materials received prior to the meeting.

Staff Report

Attachments:

1. Supplemental Materials

HOW TO PARTICIPATE IN YOUR CITY COUNCIL MEETING

You can participate in the meeting in a number of ways:

Special Meetings, Workshops
- The public will have the opportunity to address the City Council regarding the item that is the subject of the special meeting or workshop. Public comments are limited to a maximum of 3 minutes per person.

Platforms to Participate in Meetings:

Submission of Comments Prior to the Meeting:

Livermore City Council Agenda
May 16, 2022

2 Email Comments
may be submitted by the public to the City Clerk’s Office (
[email protected]
). Items received no later than 12:00 pm on the day of the meeting will be provided to the City Council and available on the City website prior to the meeting. These items will NOT be read into the record.

eComments
may be submitted by the public using the eComment link
here
. Comments may be up to
1000 characters in length and will be accepted up until 4:00 pm the day of the meeting. These items will NOT be read into the record and are viewable by the City Council and the public upon submittal.

Submission of Comments During the Meeting:

Speakers are limited to a maximum of 3 minutes per person. To submit a comment in person, you must complete a speaker card for each item. Speaker cards are available in the Civic Center Meeting Hall lobby. Indicate on the card the item number you wish to comment on and submit the card directly to the City Clerk prior to the start of the item. To submit a comment using Zoom, you may use the 'raise hand' feature. Please note that the City Council is prohibited by State law from taking action on any items that are not listed on the agenda. However, if your item requires action, the City Council may place it on a future agenda or direct staff to work with you and/or report to the City Council on the issue.

Zoom Webinar:
https://us02web.zoom.us/j/86073271313

Zoom dial in phone number: 1 669 900 6833
Meeting ID: 860 7327 1313

If you would like to deliver written materials to the City Council as part of your public comments, and are commenting in person, please provide 10 copies to the City Clerk with your speaker card. If you are commenting using Zoom, the speaker must identify that intent in his or her comment and immediately email the materials to the City Clerk at
[email protected]
.

The
City Council Agenda and Agenda Reports
are prepared by City staff and are available for public review on Tuesday evening, six days prior to the City Council meeting in the Civic Center Library, 1188 South Livermore Avenue, Livermore, and at the City Clerk’s Office, 1052 South Livermore Avenue, Livermore. The Agenda is also available on the City’s website, http://cityoflivermore.net/agenda
.

Under Government Code §54957.5, any supplemental material distributed to the members of the City Council after the posting of this agenda will be available for public review in the City Clerk’s Office, 1052 South Livermore Avenue, Livermore, and included in the agenda packet available on the City’s web site at
http://cityoflivermore.net/agenda
.

PURSUANT TO TITLE II OF THE AMERICANS WITH DISABILITIES ACT (CODIFIED AT 42 UNITED STATES CODE SECTION 12101 AND 28 CODE OF FEDERAL REGULATIONS PART 35), AND SECTION 504 OF THE REHABILITATION ACT OF 1973, THE CITY OF LIVERMORE DOES NOT

DISCRIMINATE ON THE BASIS OF RACE, COLOR, RELIGION, NATIONAL ORIGIN, ANCESTRY,

SEX, DISABILITY, AGE OR SEXUAL ORIENTATION IN THE PROVISION OF ANY SERVICES, PROGRAMS, OR ACTIVITIES. TO ARRANGE AN ACCOMMODATION IN ORDER TO PARTICIPATE

IN THIS PUBLIC MEETING, PLEASE CONTACT THE ADA COORDINATOR AT [email protected]
OR CALL (925) 960-4170 (VOICE) OR (925) 960- 4104
(TDD) AT LEAST THREE (3) BUSINESS DAYS IN ADVANCE OF THE MEETING.

Livermore City Council Agenda
May 16, 2022

3 CITY COUNCIL STAFF REPORT
ITEM NO. 3.1

DATE:

May 16, 2022
TO:

Honorable Mayor and City Council
FROM:

Tina Olson, Administrative Services Director
SUBJECT:

Proposed Fiscal Year 2021-23 Financial Plan Update

RECOMMENDED ACTION

Staff recommends the City Council provide direction regarding the Proposed Fiscal Year 2021-23 Financial Plan Update.

SUMMARY
Staff is providing the Proposed Fiscal Year 2021-23 Financial Plan Update document and is seeking direction regarding refinement of the Proposed Financial Plan Update in anticipation of adoption at the June 13, 2022, City Council meeting.

DISCUSSION
Proposed

Fiscal Year 2021-23 Financial Plan Update
The Proposed Fiscal Year 2021-23 Financial Plan Update includes revised Financial Plans for fiscal year 2021-22 (FY 2021-22) and fiscal year 2022-23 (FY 2022-23). The Proposed Plan Update contains operational costs, maintains services levels, and provides continued funding of long-term obligations to improve Livermore’s long-term financial stability.

The Proposed FY 2021-23 Financial Plan Update includes General Fund budget projections which are summarized in attachment 1.

The FY 2021-23 Plan Update anticipates General Fund revenues to increase by $10.2 million in FY 2021-22 and $8 million in FY 2022-23 over the original estimates. In both years sales tax revenue is projected to increase over original estimates. FY 2021-22 increases from $34.1 million to $37.6 million and FY 2022-23 from $36.5 million to $39.1 million. These increases relate to the Outlet Mall, the City’s auto dealerships, the addition of non-retail-oriented sales tax producers, continued recovery from the pandemic, and inflation. Property tax revenue estimates in FY 2021-22 were reduced by $900,000 from $41.4 million to $40.5 million to better align with current year projections. The FY 2022-23 estimates remained the same at $43 million. The updated projections still anticipate a projected increase by $2.5 4 million, from $40.5 million in FY 2021-22 to $43.0 million in FY 2022-23 primarily on the strength of the current housing market and continued residential and commercial development activity.

Business licenses and Real Property Transfer tax together are projected to increase by $3.1 million ($1.5 and $1.6 million, respectively) in FY 2021-22 and $2.9 million ($1.6 and $1.3 million, respectively) in FY 2022-23. Other highlighted revenues include fire permits and hazmat permits projecting increases of $630,000 in FY 2021-22 and $510,000 in FY 2022-23. Development Fees are projected to increase by $631,000 in FY 2021-22 and $309,000 in FY 2022-23. Franchise taxes are estimated to increase by $642,000 in FY 2021-22 and $820,600 in FY 2022-23. Lastly, one time revenue of $1.5 million from Alameda County for use in the Vineyard 2.0 project will be recognized in FY 2021-22.

In the FY 2021-23 Plan Update, General Fund expenditures are proposed to increase by approximately $8.3

million over the two years. Operating expenditures in FY 2021-22 are expected to reduce by $204,000 from $121.3 million to $121.1 million. The budget is expected to increase by $8.5
million in FY
2022-23 from $118.5 million to $127 million. The driving factors related to this increase is large investments in IT modernizations, including a new Enterprise Resource Planning (ERP) system ($4.2 million, $2 million covered by ERP Reserve), General Plan Update ($2.8 million), housing and other grants ($1.3 million), increase in General Liability reserves ($1 million), replacement of self-contained breathing apparatus (SCBA) equipment for LPFD ($476,000), police equipment ($286,000), and consultants and contract staff to assist the Planning Division ($274,000).

General Fund resources for capital improvements over the two-year plan update remain at approximately $15.5 million. However, there is a decrease of $630,000 in FY 2021-22 from $14.2 million to $13.6 million, and an increase in FY 2022-23 of $807,000 from $1.1 million to $1.9 million. The $15.5 million of resources is primarily for construction of the I-Street Garage parking structure. The City set aside funds for the past several years specifically to help fund the I-Street Garage and other downtown improvements.

FY 2021-23 Capital Improvement Program Update
The Capital Improvement Plan lists all anticipated capital projects necessary to support the existing General Plan, Downtown Specific Plan, El Charro Specific Plan and Neighborhood Plan areas. It also includes key projects identified in the City’s utility master plans and asset management plans. This document updated appropriations for Fiscal Years 2021-22 and 2022-23.

The proposed FY 2021-23 Capital Improvement Program Update includes $129,493,285 in appropriations to cover 90 projects over the two-year period. The Capital Improvement Plan update shows a decrease of $17.9 million in in FY 2021-22 from $55 million to $37.1 million and a decrease of $6.5 million in FY 2022-23 from $98.9 million to $92.4 million. The proposed updated appropriations reflect budget reductions for some projects due to the impact of COVID-19 on the availability of materials, as well as current Engineering Division staff resources. In these cases, some construction activities need to be pushed out beyond the budget fiscal year. Proposed appropriations also reflect increased budgets on some projects due primarily to increased cost of materials, longer construction schedules due to lack of availability of materials, and unanticipated field conditions. As an example, additional funds are needed to complete Livermorium Plaza, CIP201436, due to unanticipated project requirements mandated by Alameda County Department of Public Health, in addition to unforeseen site and soil conditions.

The largest areas of expenditures for the FY 2021-23 CIP update are: Downtown Revitalization, 5 Wastewater, and Street Maintenance. Together these areas account for approximately 69% of the two- year budget total (see attachments 2 and 3).

Livermore Pleasanton Fire Department
The total proposed operating budget for LPFD is $46,012,024 for FY 2021-22 and $48,242,086 for FY 2022-23.

The proposed budget update for FY 2021-22 and FY 2022-23 proposes a 2.0% and 6.0% increase, respectively over the previously approved budget. The increase in expenditures is primarily due to an increase in overtime, the addition of a new Battalion Chief, and replacement of LPFD's self-contained breathing apparatus (SCBA) equipment.

Revenues are projected to be $2,397,998 and $2,144,016 for FY 2021-22 and FY 2022-23, respectively.

Livermore’s share of the total cost of LPFD’s budget net of revenues and use of equipment reserve funds, is roughly 50% or $21,632,013 and $22,861,535 for FY 2020-21 and FY 2022-23 respectively.

Livermore’s share of LPFD’s proposed budget allocations for both fiscal years has been incorporated into the Plan Update.

FISCAL AND ADMINISTRATIVE IMPACTS

This is an informational report only. There are no fiscal or administrative impacts at this time.

ATTACHMENTS

1. FY 2021-23 Budget Book Update

2. General Fund Revenue & Expense Table

3. FY 21-23 CIP Update Pie Chart

4. Project by Program Schedule

Prepared by: Erik Peterson
Accounting Supervisor

Approved by:
____________________________________
Marc Roberts
City Manager
Fiscal Review by:
____________________________________
Tina Olson
Administrative Services Director
6 Table of Contents
1 FINANCIAL PLAN UPDATE FY 2021-23
ATTACHMENT 1
7 2
FINANCIAL PLAN UPDATE FY 2021-23

THIS PAGE INTENTIONALLY LEFT BLANK
8 TABLE OF CONTENTS
Table of Contents
3 FINANCIAL PLAN UPDATE FY 2021-23
Introduction
Letter from the City Manager .................................................................................................... 5 Resolution .............................................................................................................................. 18

Budget Update Tables

General Fund
General Fund Revenues ....................................................................................... 20 General Fund Expenditures .................................................................................. 21 General Fund Transfers Schedule ........................................................................ 22

Citywide
Citywide Total Revenues and Expenditures .......................................................... 23 Citywide Operating Revenues and Expenditures .................................................. 23 Citywide Total Revenues by Fund ......................................................................... 24 Citywide Total Expenditures by Fund .................................................................... 27 Citywide Revenues and Expenditures by Category .............................................. 30 Citywide Expenditures by Division FY 2021-22 ..................................................... 31 Citywide Expenditures by Division FY 2022-23 ..................................................... 33 Citywide Transfers Schedule ................................................................................. 35

Fund Balances
Projected Fund Balances FY 2021-22 ................................................................. 36 Projected Fund Balances FY 2022-23 .................................................................. 39

Capital Improvement Program
Project by Fund ....................................................................................................................... 44 Project by Program .................................................................................................................. 54

Staff Allocation
Staff Allocation by Department ................................................................................................ 64

Appropriations Limits
Appropriations Limit (to be provided at Final) ......................................................................... 71

9 4
FINANCIAL PLAN UPDATE FY 2021-23

TABLE OF CONTENTS

THIS PAGE INTENTIONALLY LEFT BLANK
10 INTRODUCTION

LETTER FROM THE CITY MANAGER
5 FINANCIAL PLAN UPDATE FY 2021-23

Honorable Mayor and City Council,

I am pleased to submit the FY 2021-23 Financial Plan Update (Plan Update) for your review and consideration. The Plan Update document contemplates Livermore’s current short-term economic outlook and provides an overview of City-wide revenue and expenditure projections, with a focus on the General Fund and General Fund Reserves. It also includes longer term projections and options to address unfunded long-term obligations. Overall, the City’s is in solid financial shape and poised to substantially increase infrastructure repair and replacement funding over time, which is the last financial hurdle after focusing on addressing Other Post Employment Benefit (OPEB) and pension liabilities. In short, the past decade of hard work to bring on-going expenses in line with revenues has been successful.

Introduction
As the City comes out of the pandemic, revenues are recovering to more normal levels of growth. As a result, the Plan Update proposes increased staffing and recognizes several one- time revenues and expenditures, some of which will be realized in the coming months. The increased staffing and one-time expenditures and revenues are discussed in more detail below.

During the last ten years, the City’s pension expenses have increased substantially – CalPERS now estimates that FY 2022-23 will be the peak of the City’s 20-year unfunded pension liabilities amortization period. This cost is included in the Plan Update and is expected to decrease over the next twenty years. The Plan Update also fully funds the City’s OPEB obligations that has also peaked and is estimated to decrease over time until fully paid off in FY 2037-38. Together the decrease in these two large, long-term costs creates an opportunity to significantly increase infrastructure funding over time.

The Great Recession exposed that the City’s overall expenditures, including addressing long- term liabilities, were greater than revenues. Since then the City has constrained the growth of operating expenditures to pay down OPEB and pension liabilities and to give time for revenues to grow. That process is now complete and this Plan Update illustrates that long-term on-going expenditures and revenues are better aligned. Revenues are expected to exceed expenditures through the 5-year planning period. As a result, the City will be able to fund current operations, modest annual increases in staffing, increase allocations to infrastructure reserves, and other special projects or one-time expenses. Since constraining growth in staff positions has been the primary approach to balancing the City’s budget over the last ten years, there are several areas in the organization where service demands exceed staff resources. This Plan Update includes positions to address those service demands.

City Council Goals
The FY 2021-23 Plan Update presents a spending plan that (1) improves services, (2) invests in much needed IT infrastructure, equipment and software, (3) provides funding to non-profits to provide homeless services, (4) fully funds the I-Street Garage Expansion project, and (5) fully funds the General Plan Update all of which address Council priorities. In March 2021 Council identified the following five priorities for FY 2021-23:
11 INTRODUCTION

LETTER FROM THE CITY MANAGER
6 FINANCIAL PLAN UPDATE FY 2021-23

1. Asset Management and Stormwater. Establish a comprehensive Asset Management Program with a focus on stormwater, ensuring the community continues to receive vital services through a sustainable infrastructure strategy.

2. Downtown. Enhance the City's vibrancy by completing critical projects downtown, ensuring the right balance of local amenities to support quality of life.

3. General Plan Update. Engage in a comprehensive General Plan Update, including the Housing Element and Programmatic EIR, to address changes in regional and state policy, market trends, and community preferences, to plan for growth and conservation for the next 25 years, and support and enhance Livermore quality of life.

4. Homelessness and Affordable Housing. Establish a homelessness strategy, engaging local partners to develop a coordinated response, and expand diversity of affordable housing projects.

5. Modernization, Training, and Workplace Enhancements. Develop a systematic approach to modernizing the City's aging business systems, reviewing processes for alignment with industry best practices, and providing our workforce with the tools and training necessary to effectively deliver services to the community.

General Fund Budget Summary
The proposed FY 2021-23 General Fund budget is summarized below:

As discussed in more detail below, in the FY 2021-23 Plan Update General Fund revenues are expected to increase by $18.2 million, transfers in decrease by $4.8 million, General Fund Actual
2020-21
Existing
FY 2021-22
Proposed
FY 2021-22 Difference
Original
FY 2022-23
Proposed
FY 2022-23 Difference
One time
Rev & Exp
FY 2021-22
One time
Rev & Exp
FY 2022-23
Operating Revenue $128,102,944 $122,442,069 $132,648,846 $10,206,777 $123,579,681 $131,605,073 $8,025,392 $7,377,088 $568,658 Use of Unassigned Reserves 17,109,265 12,219,781 (4,889,484) 4,087,452 4,837,805 750,353 Use of ERP Reserves 2,000,000 2,000,000
Transfers In 537,023 4,278,135 705,275 (3,572,860) 2,132,599 852,919 (1,279,680) - - Total Sources $128,639,967 $143,829,469 $145,573,902 $1,744,433 $129,799,732 $139,295,797 $9,496,065 $7,377,088 $568,658 Total Operating Expenditures 109,359,867 121,263,434 121,058,888 (204,546) 118,484,301 127,000,395 8,516,094 7,341,394 8,663,449 Transfers-out 4,189,577 6,759,479 6,294,486 (464,993) 9,182,168 8,218,044 (964,124) - - Capital Improvement Plan 4,367,190 14,207,000 13,577,000 (630,000) 1,090,000 1,897,000 807,000 13,577,000 1,897,000 Contributions to Reserves 5,697,188 1,599,556 4,643,528 3,043,972 1,043,263 2,180,358 1,137,095 - - Total Uses 123,613,822 $143,829,469 $145,573,902 $1,744,433 $129,799,732 $139,295,797 $9,496,065 $20,918,394 $10,560,449 Surplus/(Shortfall) $5,026,145 $0 $0 $0 $0 $0 $0 ($13,541,306) ($9,991,791) General Fund Budget
12 INTRODUCTION

LETTER FROM THE CITY MANAGER
7 FINANCIAL PLAN UPDATE FY 2021-23
expenditures increase by approximately $8.3 million, transfers-out decrease by $1.4 million, contribution to reserves increase by $4.2 million, and Capital Improvement Program increased by $177,000. The overall effect is a combined budget shortfall of approximately $19 million that is covered through use of unassigned reserves and ERP reserves. That shortfall is related to some significant one-time expenditures that total $31.5 million (net $23.5 million when factoring in one-time revenues) over the two-year period. Excluding that $23.5 million, the General Fund had a $4.5 million combined surplus and there is an estimated $7.2 million unassigned General Fund balance at the end of FY 2022-23.

The FY 2021-23 Plan Update allocates approximately $15.5 million of General Fund resources for capital improvements, representing a significant investment in the Downtown as informed by the Council’s Downtown Goal. Consistent with this goal, the City set aside funds in the unassigned reserve for the past several years specifically to help fund the I Street Garage 1 and
other downtown improvements. Other one-time expenditures in the proposed FY 2021-23 budget total $16 million including:
• $4.2 million for the ERP and other IT modernization initiatives, $2 million of which is covered through the ERP reserve
• $4.2 million increased allocation to required reserves • $2.8 million for the General Plan update
• $1.5 million pass-through property taxes to the County with off-setting revenue • $1.3 for housing and other grants
• $1 million increase to General Liability reserves
• $476,000 for LPFD replacement SCBA equipment
• $286,000 for Police Department equipment
• $274,000 consultants and contract staff to assist Planning Division

General Fund Revenues and General State of the Local Economy General Fund revenues are expected to increase by $10.2 million in FY 2021-22 and $8 million in FY 2022-23 beyond original estimates. This is primarily related to growth in sales tax and business license tax revenues though all of the City’s revenue sources are expected to increase beyond original estimates.

The City’s three major revenue sources (property tax, sales tax, and development related items) weathered the pandemic induced recession and are expected to increase in FY 2022-23.

Property tax revenue is projected to increase by $2.5 million, from $40.5 million in FY 2021-22 to an estimated $43 million in FY 2022-23 primarily on the strength of the current housing market and continued residential and commercial development activity. Sales tax revenue has dropped to the City’s second largest revenue source. That said, sales tax revenues continue to be strong due to the Outlet Mall, the City’s auto dealerships, and the addition of non-retail sales tax producers. Sales tax revenue is projected to increase by $1.5 million from $37.6 million in FY 2021-22 to $39.1 million in FY 2022-23 due to anticipated continued recovery from the pandemic, and inflation.

1 There is also $3 million debt service payment for the L Street Garage included in the 5- year General Fund forecast for a bond staff is preparing to issue for that project in the fall 2022. 13 INTRODUCTION

LETTER FROM THE CITY MANAGER
8 FINANCIAL PLAN UPDATE FY 2021-23

Finally, the City’s Business License consultant, HdL, discovered that Sandia National Laboratories (SNL) and Lawrence Livermore National Laboratory (LLNL) (collectively “the Labs”) should have been paying the City’s Business License tax but have not done so to date.

The City can collect up to three years for past due amounts. City staff has been working with the Labs to determine the correct amount owed to the City for the previous three years and the amount due in FY 2022-23. City staff has reached agreement with SNL but has not yet done so for LLNL. As such the increased Business License revenue associated with SNL is included in the FY 2022-23 Plan Update but staff has not included anything for LLNL. In addition, the FY 2022-23 budget does not include the three years back payment for either lab. As described in more detail below, staff recommends allocating the back payments received from the Labs to prepay OPEB liabilities, from which the future annual OPEB contribution savings will be allocated to the Infrastructure Repair and Replacement Reserve.

Staffing Summary
The previous Financial Plan acknowledged a relatively strong economy and the pressure that increased economic activity level places on service demands for the community. For the past six budget cycles, still cognizant of the reduction in staffing of 100 Full Time Equivalents (FTE) during the Great Recession, one of the City’s cost containment strategies has been to carefully consider increasing City staffing levels such that General Fund revenues have time to grow and align with structural expenditures, specifically to more fully fund OPEB, pension obligations, and infrastructure maintenance. Current revenues are now in balance with structural expenditures and the City is in a position to increase staffing levels to continue providing a high level of service to Livermore’s residents and businesses, as well as achieve Council goals and priorities.

As such, staff is proposing to increase staffing levels by eight positions (6.5 FTE) in the FY 2022-23 Plan Update as summarized below:

Storm Water Manager (1.0 FTE) - This position will manage the City’s Storm Water Program including regulatory compliance, interaction with multiple departments and outside agencies, as well as work with City staff to identify means of repairing, replacing, or maintaining the City’s storm water infrastructure and systems.

Battalion Chief (0.5 FTE) - This position will add a third on-duty Battalion Chief so that each city will always have Battalion Chief coverage and to reduce the span of control from one manager to 34 employees to one manager to 17 employees. The overall intent was to improve job performance, oversight, and career development/succession planning while adding some depth to LPFD’s ability to respond to and manage emergency incidents. While this coverage level required three new FTEs, LPFD’s original FY 2021- 22 budget included two FTEs with the intent to add the third FTE in FY 2022-23 if both cities were able to cover the increased cost. The cost of the additional Battalion Chief is shared equally with Pleasanton.

Librarian I (0.5 FTE) - This position will be responsible for performing equitable community outreach to educate Livermore citizens on the services offered by the Livermore Public Library. It is also responsible for assessing community need for new 14 INTRODUCTION

LETTER FROM THE CITY MANAGER
9 FINANCIAL PLAN UPDATE FY 2021-23
Library programs and services. Outreach librarians focus on reaching the traditionally underserved including financially disadvantaged and unhoused people, ethnically diverse people, senior citizens, adult new and non-readers, incarcerated people and ex- offenders, people with disabilities, LGBTQ populations, and rural and geographically isolated communities.

Senior Civil Engineer (1.0 FTE) - The Senior Civil Engineer position leads a team of engineers and technicians as well as manages multiple consultant contracts for various Capital Improvement Plan (CIP) projects, land development, transportation, downtown implementation, and other assignments. The number of CIP projects currently exceeds the Engineering Division’s resources. This position will better balance Engineering Division resources with demand for services and provide additional capacity to implement CIP projects. This position will also improve the span of control within the Engineering Division’s management structure.

IT Engineer/Water SCADA (1.0 FTE) - This position will be an IT systems administrator responsible for implementing and managing the technology infrastructure that hosts the Supervisory Control and Data Acquisition (SCADA) system. This includes the server hardware and operating systems, the network connectivity for the SCADA terminals, and management of the vendor support contract that supports the SCADA specific technology. Additionally, this position acts as the liaison between DPW and IT management.

Crime Analyst (0.5 FTE) - Crime Analysts are responsible for collecting and disseminating pertinent information that assists the Police Department to plan, prevent, and suppress criminal activities. This position will be assigned to the Real Time Awareness Center (RTAC), to monitor “real-time” cameras, alerts, and other systems to provide immediate information and descriptions of crimes in progress to on-duty Patrol Officers and Detectives.

Crisis Intervention Specialist (1.0 FTE) - Working with Patrol Officers in a co-responder model, the Crisis Intervention Specialist will provide emergency crisis assessment and intervention services in the field as well as assist with linkage to outpatient mental health services and family support services. In addition, this position will conduct community outreach, provide ongoing intervention assessment, treatment, and follow-up services designed to help stabilize individuals and connect them to additional mental health resources.

Climate Action Manager (1.0 FTE) - This position will manage and coordinate citywide climate, sustainability, and healthy community efforts related to renewable energy, energy resilience, green buildings, decarbonization, waste reduction, water conservation, sequestration, habitat conservation, and climate adaptation.

Over the long-term, staff anticipates adding positions to address increased service demands as well as exploring options to make service delivery more efficient. Additionally, staff expects to 15 INTRODUCTION

LETTER FROM THE CITY MANAGER
10 FINANCIAL PLAN UPDATE FY 2021-23
continue utilizing “limited duration” or “special funded” positions that will allow the City to address elevated service level demands, but retain staffing flexibility in anticipation of the inevitable economic downturn. The long-term financial plan assumes adding three permanent FTEs annually over the five-year projection period.

Services and Supplies Budget Changes
The FY 2022-23 General Fund Services and Supplies budget is increasing from the original budget by approximately $6.2 million, of which approximately $4.8 million will be used to help to fulfill three of the Council priorities:

General Plan Update- $653,000 for additional consultant services to help prepare the General Plan update and provide back-up support to CDD staff

Modernization, Training, and Workplace Enhancements- $3.1 million for:
• Cybersecurity enhancements
• Enterprise Resource Program (ERP) system
• Upgrades to the City and library IT systems
• Replacing 50% of the City’s desktop computers with laptops that will facilitate telecommuting
• Expansion of IT support contracts
• Police training simulator

Homelessness and Affordable Housing – $1.0 million for grants to various non-profits to provide homeless services
2 as well as rental assistance

The remaining approximately $1.5 million increase in the FY 2022-23 Services and Supplies budget is for the following:
• Livermore Pleasanton Fire Department (LPFD) - $1.22 primarily related to increased overtime, adding 0.5 FTE Battalion Chief position, increased General Liability insurance premium, and purchasing replacement Self Contained Breathing Apparatus (SCBA). • Claims and Liability Reserve - $240,000

General Fund Reserves
Operating Reserves - During the Great Recession, the City spent approximately $12 million in General Fund operating reserves to maintain essential services. When the economy began to show signs of recovery, the City Council adopted a Governmental Accounting Standards Board (GASB) 54 Compliant Fund Balance policy, establishing General Fund reserve goals. The policy, adopted in June 2012 and amended in June 2016, targets an overall reserve level of 30% of the current year’s budgeted operating expenditures and outgoing transfers for debt service. Key components of the General Fund Balance policy goals include:

2 Includes funding to Asbury Church for shower and laundry services, Bay Area Community Health mobile substance abuse counseling services, bio-hazard and clean-up services of homeless encampments, Goodness Village tiny homes operating costs support, and CityServe operating cost support. 16 INTRODUCTION

LETTER FROM THE CITY MANAGER
11 FINANCIAL PLAN UPDATE FY 2021-23
15% of the General Fund’s current operating expenditures plus debt service transfers, to be used in a catastrophic event or in a major emergency or in periods of severe fiscal crisis (Catastrophic Reserve); and

13.5% of the General Fund’s current operating expenditures plus debt service transfers, to be used during times of severe economic distress such as protracted recessionary periods, State raids on local resources, or other unforeseen events (Economic Reserve); and

1.5% of the General Fund’s current operating expenditures plus debt service transfers to protect against cash shortfalls related to timing of projected revenue receipts and to maintain budgeted level of reserves (Cashflow Reserve).

The General Fund operating reserves in the FY 2021-23 Plan Update meet these policy targets.

Infrastructure Repair and Replacement Reserves - In addition to operating reserves, in June of 2016, Council directed staff to establish an Infrastructure Repair and Replacement Reserve to begin accumulating the resources necessary to address the City’s aging infrastructure as part of Council’s Asset Management goal. One of the City’s strategies to contain costs and leverage buying power is to save while the economy is doing well to have resources available during the next economic downturn when there is usually better construction pricing.

The City owns approximately $2.5 billion dollars of general government infrastructure in addition to another $1 billion dollars of enterprise fund infrastructure. Staff currently estimates that the City (like most local governmental agencies) is underfunding infrastructure maintenance by $12 million per year. For this reason, the City Council identified Asset Management as one of its goals, which includes developing funding and maintenance policies to address this significant challenge. As the City develops this program, Council directed staff to allocate at least $2 million annually to the Infrastructure Repair and Replacement Reserve. The FY 2021-23 budget allocates $2 million annually to this reserve. Further, staff is preparing a Long-term Obligations Funding Policy and Infrastructure Repair and Replacement Policy for Council’s review and consideration that will identify additional funding options to help the City have funding available to address infrastructure maintenance as well as define eligible uses of the Infrastructure Repair and Replacement Reserve. Those options are discussed in more detail under Funding Long Term Obligations section below.

17 INTRODUCTION

LETTER FROM THE CITY MANAGER
12 FINANCIAL PLAN UPDATE FY 2021-23
Below is a summary of anticipated General Fund balance categories during the period covered by the Plan Update:

Internal Services Fund Reserves
Workers’ Compensation Reserves - The City is self-insured for its Workers’ Compensation program up to $500,000 per claim. A significant element of self-insurance involves reserving funds to cover the anticipated cost for the life of the claims. The Plan Update includes resources sufficient to fund the resulting claims liability at a 90% confidence level.

Fleet, Information Technology Replacement, and Facility Rehabilitation Programs - The Plan provides approximately $3.9 million annually for fleet replacement. This funding is used to replace police cars, fire engines, and certain public works vehicles. The Information Technology Replacement program provides for the replacement of major information technology systems, such as the permit and financial software, phone systems, voicemail systems, and all city servers. The Plan Update adequately funds the Information Technology Replacement Program with $5 million annually. The Facility Rehabilitation Program provides approximately $2 million annually to fund basic facility maintenance. The Fleet, Information Technology, and Facility Rehabilitation replacement program balances are at prudent levels.

2020-21
Actual
2021-22
Budgeted
2022-23
Budgeted
Ending Total Fund Balance: $80,721,847 $73,145,595 $68,488,147 Nonspendable: 5,609,833 5,609,833 5,609,833
Committed (Catastrophic
Reserve 15%) 17,419,222 18,740,986 19,831,165
Assigned (Economic Reserve

13.5%) 15,677,300 16,866,888 17,848,049
Unassigned (Cashflow Reserve

1.5%) 1,741,922 1,874,099 1,983,116
Infrastructure Repair &
Replacement Reserve 12,000,000 14,000,000 16,000,000
ERP (Included in FY 2022-23
budget) 2,000,000 2,000,000 -
Total Reserves $48,838,444 $53,481,973 $55,662,330
Remaining Unassigned Fund
Balance $26,273,570 $14,053,789 $7,215,984
General Fund Reserves
18 INTRODUCTION

LETTER FROM THE CITY MANAGER
13 FINANCIAL PLAN UPDATE FY 2021-23
Funding Long-Term Obligations
The City has been allocating significant funding over the past ten years towards funding pension and OPEB obligations including paying down the City’s unfunded liabilities. In FY 2022-23, the City allocated $30.6 million towards pension and OPEB expenses. In addition, as previously noted, the City recently began allocating a minimum of $2 million towards Infrastructure Repair and Replacement Reserves that will be available to fund deferred maintenance projects, the City’s remaining largely unfunded long-term obligation. Thus, the City is allocating a total of $32.6 million in FY 2022-23 towards long-term obligations. Staff is proposing that the City maintain that level of funding
3 towards long-term obligations such that as pension and OPEB contributions decline there will be a corresponding increase to the Infrastructure Repair and Replacement Reserves. That proposal, the Long-term Obligations Funding Policy and the Infrastructure Repair and Replacement Policy4, will be presented to Council for consideration in June 2022. The sections below broadly discuss this funding strategy and approach to continue to effectively manage each of these long-term obligations.

OPEB - OPEB is a non-pension retirement benefit that certain employees receive upon their retirement, such as retiree health care. When these benefits were first offered by the City, the cost was quite modest and benefits were funded on a pay-as-you-go basis. Sharp increases to the cost of health care in the 1990’s and early 2000’s made this approach imprudent. Beginning in 2006, the City’s funding policy was to set funding aside in an irrevocable trust and to ramp up funding to the full Actuarial Determined Contribution (ADC) over ten years. However, the economic downturn in FY 2008-09 hampered the City’s ability to make its full ADC payment.

The City’s actuarial report indicated that this underfunding of the ADC and continued steep increases in health care costs caused its unfunded liability to grow to over $101 million. In June 2013, the Council directed staff to develop a comprehensive solution to this problem. The solution required a dramatic increase in funding and cooperation of employee bargaining groups to modify health care benefits. The City was successful in stabilizing its benefit costs and subsequently implemented a strategy to fully fund its ADC. As a result, the City’s unfunded liability has subsequently dropped to roughly $35 million with an ADC of $4.6 million annually. In July of 2015, the City Council adopted a policy requiring full funding of the City’s ADC every year. Funding for the full OPEB ADC payment is included in the FY 2021-23 Plan Update and the City’s OPEB liability is currently approximately 56% funded.

The FY 2021-23 Plan Update resolution will include authorization for staff to allocate the one- time Business License back payments when received from the Labs to pre-pay OPEB, which will reduce the City’s annual contribution to OPEB. While the total amount of those back payments is still under discussion, staff modeled various scenarios of the impact of prepaying OPEB on the City’s annual OPEB contributions. For example, $5 million will reduce annual contributions by between $529,000 and $753,000 annually, $10 million will reduce it between $1 million and $1.5 million, and $12.5 million will reduce it between $1.3 million to $1.9 million. All of those scenarios run through FY 2036-37 after which the City’s OPEB unfunded liability will be

3 In current dollars. Infrastructure Repair and Replacement funding requirements will increase by CPI. 4 The Long Term Obligations Funding Policy would set minimum funding levels to collectively address OPEB, pension, and infrastructure repair and replacement obligations. The Infrastructure Repair and Replacement Policy will identify the types of projects that could be funded by the Infrastructure Repair and Replacement reserves. 19 INTRODUCTION

LETTER FROM THE CITY MANAGER
14 FINANCIAL PLAN UPDATE FY 2021-23
fully funded. At that time, there will be a total annual savings of approximately $5.8 million available to allocate to the Infrastructure Repair and Replacement Reserve.

CalPERS Pension Costs – Since the Great Recession CalPERS made changes to several actuarial assumptions, such as mortality rates and adopted a policy to “de-risk” their portfolio, which resulted in reducing the discount rate that CalPERS uses to amortize the City’s pension liability beginning in FY 2018-19. The current discount rate is 6.8%, down from 7.75% in 2011.

CalPERS implemented a 20-year rate amortization and a five-year phase-in for these significant changes. The phase-in began in FY 2016-17 which increased the City’s annual pension contribution to $25.9 million in FY 2022-23, which, based on CalPERS latest estimates will be the peak of the 20-year amortization period. The City’s pension liability is currently approximately 78% funded.

As described in the chart below, based on CalPERS recent projections 5 the City’s pension
contributions will begin declining in FY 2023-24 until the unfunded liability is fully funded in FY 2040-41 resulting in an annual pension contribution of $8.9 million. Like the proposed approach to OPEB savings, the Long-term Obligations Funding will recommend that annual savings below $25.9 million be allocated to the Infrastructure Repair and Replacement Reserve. Those savings are currently expected to be $1.3 million in FY 2023-24 and grow to $17 million in FY 2040-41.

Section 115 Pension Trust Fund
In addition, staff is developing a proposal to create a Section 115 Pension Trust Fund (Section 115 Fund) with PARS
6 that would be used to help off-set pension contributions through increased investment earnings. The PARS Section 115 Trust Fund moderately conservative

5 CalPERS assumptions include: 6.8% discount rate, increased mortality rates, and FY 2020- 21 investment returns of 21.3%
6 Similar to the City’s Section 115 OPEB Trust Fund with PARS though Staff is proposing to have a more conservative investment portfolio for the Section 115 Pension Trust Fund to reflect the expected short -term use of funds.
$25.9
$22.0
$8.9
$0.0
$5.0
$10.0
$15.0
$20.0
$25.0
$30.0
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 Total Pension Contributions- In Millions
20 INTRODUCTION

LETTER FROM THE CITY MANAGER
15 FINANCIAL PLAN UPDATE FY 2021-23
investment portfolio’s returns are approximately 400 basis points greater than the City has recently been earning on investments (approximately 5% versus approximately 1%). The City can withdraw from a Section 115 Trust Fund to fund equal to three years of pension contributions in one withdrawal. Staff is exploring creating a Section 115 Trust Fund. Doing so would result in additional investment earnings that could be used to help make annual pension contributions, funds that can be used to allocate to the Infrastructure Repair and Replacement Reserve.

Infrastructure Repair and Replacement Funding – As noted above, the City has substantially addressed its long-term pension related obligations, and their true costs are integrated into the structural expense framework. That said, the largest and most complex underfunded liability is infrastructure repair and replacement and is primarily achieved via programming the CIP. As witnessed with the storm damage experienced in Livermore during February of 2017, deferring maintenance of infrastructure may help meet immediate operational needs in the short run, but is not a prudent financial strategy and can have serious and costly ramifications. It is for this reason that Asset Management has been, and will continue to be, an important focus for the City.

General Fund contributions to the Capital Improvement Program (CIP) program have been approximately $2 million per year. General Fund contributions to the CIP finance major infrastructure and maintenance projects that have no other funding sources. Traditionally, these projects have included American with Disabilities Act improvements, arroyo maintenance and stabilization, bridges, buildings, sound walls, Citywide landscaping improvements, culvert improvements, sidewalk repair, decorative wall repairs, and street improvement projects.

The FY 2021-23 Plan Update allocates $15.5 million to the CIP however, as previously noted, the bulk of that funding is for the I street Garage Expansion Project. While the proposed funding level allows for some progress, millions of dollars in unfunded CIP project requests remain unaddressed. Most of these projects are deferred maintenance projects for which the General Fund is the only source of funding. The City Council previously directed staff to develop a comprehensive Asset Management Plan so that adequate resources are available when needed. Staff continues to make progress on that plan and have provided periodic updates to the City Council. However, approximately $12 million General Fund additional annual allocation to the CIP will be necessary over the long run to maintain high risk infrastructure at acceptable levels of service, or $10 million more than the City has historically allocated to the CIP.

Long Term Obligations Funding Plan
The proposed plan to maintain total funding of long-term obligations at $32.6 million will result in the following estimated annual allocations between OPEB (assuming $10 million prepayment), pension (assuming CalPERS latest projections hold), and Infrastructure Repair and Replacement allocations (excluding inflationary increases):

21 INTRODUCTION

LETTER FROM THE CITY MANAGER
16 FINANCIAL PLAN UPDATE FY 2021-23

As illustrated in the chart above, as the City pays down OPEB and pension liabilities, the amount allocated to the Infrastructure Repair and Replacements Reserve increases over the next 18 years. By 2041, the City will be contributing nothing to OPEB, $8.9 million to pensions, and $23.7 million to the Infrastructure Repair and Replacements Reserve. In addition, staff will also recommend increasing allocations to the Infrastructure Repair and Replacements Reserve with all or a portion of year-end budget surpluses, which is not included in the graph above.

Actual FY 2016-17 through 2020-21 General Fund budget surpluses were between $2.1 million and $8.3 million and an average of $6 million.

5-year General Fund Forecast
Staff updated the General Fund 5-year forecast that includes the proposed FY 2021-23 Plan Update. As described in the table below, in FY 2023-24, total revenues will exceed total expenditures by approximately $429,000 and continue to exceed operating expenses through FY 2027-28 when revenues will exceed expenses by $7.9 million. The budgetary surplus can be used to increase allocations to the Repair and Replacements Reserve, prefund OPEB, fund other one-time costs, and/or increase service levels beyond the annual increase of 3.0 FTE included in the model.

The following assumptions are included in the 5-year Forecast:

• Revenues increasing overall by 4% in FY 2023-24 and increasing by 3% annually thereafter.
• Personnel Services increasing by 3% annually
• CalPERS contributions consistent with CalPERS estimates • Adding 3.0 FTE new positions annually
• Services and Supplies increasing by between 2% and 3% annually

22 INTRODUCTION

LETTER FROM THE CITY MANAGER
17 FINANCIAL PLAN UPDATE FY 2021-23

Next Steps
In summary, staff will present for Council’s consideration at a later date (1) creating a Long-term Obligations Funding Policy and Infrastructure Repair and Replacements Reserve Funding Policy and (2) establishing a Section 115 Pension Trust Fund with PARS.

Conclusion
The City is on a steady financial course, but still strives to achieve long-term financial sustainability. The FY 2021-23 Financial Plan incorporates funding for long-term obligations in the areas of fleet, information technology, facilities, and Citywide CIP projects. While General Fund reserves are currently fully funded, future liabilities, increasing employee costs, and deferred infrastructure maintenance temper the City’s progress. The City must remain vigilant about implementing new services or enhancing existing programs to achieve the longer-term prize – a sustainable financial future.

I appreciate the time and talents of the Executive Team, as well as managers and staff throughout the organization, who have also contributed to making this Financial Plan Update possible.

I wish to specifically acknowledge the Finance Division for their perseverance and dedication in preparing this document. I also wish to thank the City Council for their support of our workforce.

Respectfully submitted,

Marc Roberts
City Manager
Actual Proposed Proposed Projected Projected Projected Projected Projected FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 FY 2025-26 FY 2026-27 FY 2027-28 Operating Revenue $128,102,944 $132,648,846 $131,605,073 $138,265,732 $144,241,195 $148,467,490 $153,240,149 $157,974,372 Transfers In 537,023 705,275 852,919 688,792 708,209 728,186 748,740 769,888 Total Sources $128,639,967 $133,354,121 $132,457,992 $138,954,524 $144,949,404 $149,195,676 $153,988,889 $158,744,260 Total Operating Expenditures $109,359,867 $121,058,888 $127,000,395 $124,794,833 $128,027,862 $130,254,155 $133,647,919 $136,110,031 Transfers Out 4,189,577 6,294,486 8,218,044 9,895,229 9,914,414 9,948,569 9,961,865 9,985,862 Capital Improvement Program 4,367,190 13,577,000 1,897,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 Contribution to Reserves 5,697,188 4,643,528 2,180,358 1,835,091 2,969,076 2,671,349 3,015,129 2,738,634 Total Uses $123,613,822 $145,573,902 $139,295,797 $138,525,153 $142,911,352 $144,874,073 $148,624,913 $150,834,527 Surplus (Shortfall) $5,026,145 ($12,219,781) ($6,837,805) $429,371 $2,038,052 $4,321,603 $5,363,976 $7,909,733 23 INTRODUCTION

18 FINANCIAL PLAN UPDATE FY 2021-23

RESOLUTION

24 19
FINANCIAL PLAN UPDATE FY 2021-23

BUDGET UPDATE TABLES

Budget Update Tables
FY 2021-22 & FY 2022-23 Budget Update
25 20
FINANCIAL PLAN UPDATE FY 2021-23

GENERAL FUND

General Fund Revenues – by Category

General Fund FY 2020-21
Actual
FY 2021-22
Existing
Budget
FY 2021-22
Proposed
Budget
FY 2021-22
Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget
FY 2022-23
Change
Property Taxes 38,874,958$ 41,401,520$ 40,464,176$ (937,344)$ 42,953,530$ 43,011,015$ 57,485$ Sales & Use Taxes 35,441,550 34,094,000 37,550,000 3,456,000 36,500,000 39,047,000 2,547,000 Franchise Taxes 5,686,312 5,185,281 5,827,371 642,090 5,222,356 6,043,000 820,644 Business License Taxes 6,804,846 5,906,285 7,370,000 1,463,715 6,101,374 7,672,000 1,570,626 Other Taxes 3,651,054 4,250,000 5,862,930 1,612,930 5,550,000 6,850,800 1,300,800 Licenses & Permits 2,587,449 2,596,220 3,315,100 718,880 2,566,487 3,220,242 653,755 Fines &Forfeitures 395,011 370,000 345,000 (25,000) 380,000 355,000 (25,000) Use Of Money & Property 7,952,228 3,830,381 4,075,607 245,226 3,921,943 3,939,280 17,337 Intergovernmental Revenue 15,307,657 16,267,460 17,030,373 762,913 11,602,258 12,364,166 761,908 Other Taxes In Lieu 7,990 7,980 7,980 - 7,980 7,980 - Charges For Current Svc 7,954,985 8,063,192 8,694,048 630,856 8,299,003 8,608,340 309,337 Other Revenue 3,438,904 469,750 2,106,261 1,636,511 474,750 486,250 11,500 Total Operating Revenues 128,102,944$ 122,442,069$ 132,648,846$ 10,206,777$ 123,579,681$ 131,605,073$ 8,025,392$ Transfers In 537,023$ 4,278,135$ 705,275$ (3,572,860)$ 2,132,599$ 852,919$ (1,279,680)$ Total Revenues 128,639,967$ 126,720,204$ 133,354,121$ 6,633,917$ 125,712,280$ 132,457,992$ 6,745,712$

General Fund
The updated budget for General Fund operating revenue and transfers in represents increases of $6.6 million for FY 21-22 and $6.7 million for FY 22-23. The largest increase in both fiscal years was sales & use taxes of $3.5 million and $2.5 million, respectively. The two major factors influencing these increases are continued recovery from the pandemic and inflation. The increase of $1.5 million in FY 21-22 and $1.6 million in FY 22-23 in business license tax can be attributed to Sandia National Laboratory annual revenues of $1.0 million and the remainder due to recovery from the pandemic and inflation.

26 21
FINANCIAL PLAN UPDATE FY 2021-23

GENERAL FUND

General Fund Expenditures – by Department

Department
FY 2020-21
Actual
FY 2021-22
Existing
Budget
FY 2021-22
Proposed
Budget
FY 2021-22
Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget
FY 2022-23
Change
City Council 292,587$ 190,327$ 261,587$ 71,260$ 201,364$ 226,566$ 25,202$ City Manager 2,115,420 2,175,705 2,348,260 172,555 2,181,054 2,896,537 715,483 City Attorney 1,874,129 2,213,568 2,186,599 (26,969) 2,179,904 2,178,329 (1,575) Administrative Services 6,459,231 7,276,064 7,636,219 360,155 7,534,044 8,684,680 1,150,636 Community Development 16,807,040 21,936,110 21,267,737 (668,373) 17,270,648 20,524,616 3,253,968 Fire 22,758,011 23,822,187 24,041,576 219,389 24,199,167 25,437,560 1,238,393 General Services 3,040,213 3,569,999 4,411,457 841,458 3,601,224 3,596,673 (4,551) Innovation & Economic
Development 4,401,048 3,106,986 2,893,620 (213,366) 3,117,460 2,786,435 (331,025) Library 5,517,721 6,258,888 6,457,670 198,782 6,331,728 6,870,311 538,583 Police 38,168,354 41,631,320 40,664,368 (966,952) 43,019,382 44,455,554 1,436,172 Public Works 7,926,113 9,082,280 8,889,795 (192,485) 8,848,326 9,343,134 494,808 Total Operating Expenditures $109,359,867 $ 121,263,434 $121,058,888 $ (204,546) $118,484,301 $ 127,000,395 $ 8,516,094 Transfers Out 4,189,577$ 6,759,479$ 6,294,486$ (464,993)$ 9,182,168$ 8,218,044$ (964,124)$ Capital Improvements 4,367,190 14,207,000 13,577,000 (630,000) 1,090,000 1,897,000 807,000 Addition to Reserves 5,697,188 1,599,556 4,643,528 3,043,972 1,043,263 2,180,358 1,137,095 Total Expenditures 123,613,822$ 143,829,469$ 145,573,902$ 1,744,433$ 129,799,732$ 139,295,797$ 9,496,065$

General Fund Expenditures – by Category

Expense Category FY 2020-21
Actual
FY 2021-22
Existing
Budget
FY 2021-22
Proposed
Budget
FY 2021-22
Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget
FY 2022-23
Change
Personnel Services 33,724,109$ 37,319,745$ 36,424,489$ (895,256)$ 37,828,248$ 40,360,639$ 2,532,391$ Supplmntl Personnel Svcs 26,407,327 29,286,282 27,985,199 (1,301,083) 30,158,021 29,622,797 (535,224) Services & Supplies 49,130,697 54,657,407 56,649,200 1,991,793 50,448,932 56,620,959 6,172,027 Capital Outlay 97,734 - - - 49,100 396,000 346,900 Total Operating Expenditures $ 109,359,867 $ 121,263,434 $ 121,058,888 $ (204,546) $ 118,484,301 $ 127,000,395 $ 8,516,094 Transfers Out 4,189,577$ 6,759,479$ 6,294,486$ (464,993)$ 9,182,168$ 8,218,044$ (964,124)$ Capital Improvement 4,367,190 14,207,000 13,577,000 (630,000) 1,090,000 1,897,000 807,000 Addition to Reserves 5,697,188 1,599,556 4,643,528 3,043,972 1,043,263 2,180,358 1,137,095 Total Expenditures 123,613,822$ 143,829,469$ 145,573,902$ 1,744,433$ 129,799,732$ 139,295,797$ 9,496,065$

27 22
FINANCIAL PLAN UPDATE FY 2021-23

GENERAL FUND

General Fund Transfers Schedule
Transfer From Transfer To
FY 2020-21
Actual
FY 2021-22
Proposed
FY 2022-23
Proposed
306 Traffic Impact Fee 001 General Fund -$ 62,435$ 63,995$ (1) 331 Dwntwn Rev itlztn Fee 001 General Fund - - 150,000 (2) 611 Low Income Housing Fund 001 General Fund 273,167 249,340 252,424 (3) 614 Maintenance District L&LD 001 General Fund 246,707 234,000 240,000 (1) 615 Federal Grant 001 General Fund 1,009 - - (4) 621 BJA - Bullet Proof Vest Reimb 001 General Fund 1,080 - - (5) 645 CASP Cert & Training Fund 001 General Fund 6,494 4,500 4,500 (6) 650 Gas Taxes 001 General Fund - 107,000 109,000 (1) 671 HHS - Federal Home Program 001 General Fund 8,566 8,000 8,000 (7) 673 Library Foundation Grant 001 General Fund - 40,000 25,000 (7) Total Transfers to the General Fund 537,023$ 705,275$ 852,919$ 001 General Fund 220 Stormwater 1,767,363$ 1,767,363$ 2,300,000$ (8) 001 General Fund 417 2020 COPs Series B 1,076,684 3,881,018 3,882,372 (9) 001 General Fund 422 2022 COPs Debt Service Fund - - 1,325,000 (10) 001 General Fund 610 Horizons 638,749 450,558 509,258 (6) 001 General Fund 614 Maintenance District L&LD 118,985 195,547 201,414 (11) 001 General Fund 615 Federal Grant 587,797 - - (12) Total Transfers From the General Fund 4,189,577$ 6,294,486$ 8,218,044$ Description of Transfer
(1) Administrativ e and Ov erhead Cost
(2) Principal Payment
(3) Affordable Housing Activities
(4) Refund portion of original transfer
(5) Reimburse for Federal Grants
(6) Reimburse for Expenditures
(7) Reimburse Staff Time
(8) Operating Subsidy
(9) Debt Service for 2020 COP
(10) Debt Service Expense for a new 2022 COP
(11) Downtown LMD General Benefit Transfer
(12) Transfer for COVID related expenses
28 23
FINANCIAL PLAN UPDATE FY 2021-23

CITYWIDE
Citywide Total Revenues and Expenditures

Fund Type FY 2020-21
Actual
FY 2021-22
Existing
Budget
FY 2021-22
Proposed
Budget
FY 2021-22
Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget
FY 2022-23
Change
Revenues
General Fund 128,639,967$ 126,720,204$ 133,354,121$ 6,633,917$ 125,712,280$ 132,457,992$ 6,745,712$ Enterprise 67,081,449 70,655,399 67,710,840 (2,944,559) 81,564,953 79,996,694 (1,568,259) Capital Projects 3,937,486 56,216,646 7,276,654 (48,939,992) 9,560,700 64,036,852 54,476,152 Debt Service 1,304,856 5,438,818 4,361,018 (1,077,800) 6,943,491 6,244,672 (698,819) Permanent 186,198 66,244 66,244 - 66,244 66,244 - Special Revenue 22,953,666 24,847,422 18,619,957 (6,227,465) 18,480,698 26,373,491 7,892,793 Internal Service 14,455,302 14,835,703 18,573,109 3,737,406 15,156,520 20,240,895 5,084,375 Total Revenues $ 238,558,924 $ 298,780,436 $ 249,961,943 $ (48,818,493) $ 257,484,886 $ 329,416,840 $ 71,931,954 Expenditures
General Fund 123,613,822$ 143,829,469$ 145,573,902$ 1,744,433$ 129,799,732$ 139,295,797$ 9,496,065$ Enterprise 64,376,162 71,106,825 63,374,456 (7,732,369) 98,994,965 99,619,390 624,425 Capital Projects 4,099,998 17,578,136 12,136,744 (5,441,392) 50,941,943 31,109,191 (19,832,752) Debt Service 1,323,860 5,437,712 4,361,018 (1,076,694) 6,942,385 6,244,672 (697,713) Permanent 26,321 26,000 28,000 2,000 26,000 28,000 2,000 Special Revenue 16,837,673 35,356,742 24,189,954 (11,166,788) 18,719,315 39,659,397 20,940,083 Internal Service 15,330,951 24,169,158 22,601,908 (1,567,250) 23,852,125 27,704,934 3,852,809 Total Expenditures 225,608,787$ 297,504,042$ 272,265,982$ (25,238,060)$ 329,276,465$ 343,661,381$ 14,384,916$

Citywide Operating Revenues and Expenditures

Fund Type FY 2020-21
Actual
FY 2021-22
Existing
Budget
FY 2021-22
Proposed
Budget
FY 2021-22
Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget
FY 2022-23
Change
Operating Revenues
General Fund 128,102,944$ 122,442,069$ 132,648,846$ 10,206,777$ 123,579,681$ 131,605,073$ 8,025,392$ Enterprise 51,477,880 54,237,701 51,723,912 (2,513,789) 64,136,155 62,666,206 (1,469,949) Capital Projects 3,504,009 16,313,306 7,276,654 (9,036,652) 9,560,700 14,036,852 4,476,152 Debt Service - - - - - - - Permanent 161,472 66,244 66,244 - 66,244 66,244 - Special Revenue 21,545,906 24,306,864 17,457,817 (6,849,047) 18,051,171 25,662,819 7,611,648 Internal Service 14,455,302 14,835,703 18,573,109 3,737,406 15,156,520 20,240,895 5,084,375 Total Operating Revenues $ 219,247,514 $ 232,201,887 $ 227,746,582 $ (4,455,305) $ 230,550,471 $ 254,278,088 $ 23,727,617 Operating Expenditures
General Fund 109,359,867$ 121,263,434$ 121,058,888$ (204,546)$ 118,484,301$ 127,000,395$ 8,516,094$ Enterprise 40,957,800 47,181,469 44,863,891 (2,317,578) 47,029,817 48,199,917 1,170,100 Capital Projects 15,751 1,970,135 - (1,970,135) - 2,139,835 2,139,835 Debt Service 1,323,860 5,437,712 4,361,018 (1,076,694) 6,942,385 6,244,672 (697,713) Permanent 26,321 26,000 28,000 2,000 26,000 28,000 2,000 Special Revenue 10,109,079 18,891,689 16,227,142 (2,664,547) 9,401,059 16,199,784 6,798,726 Internal Service 14,847,949 20,526,134 21,789,604 1,263,470 20,842,125 24,654,934 3,812,809 Total Operating Expenditures 176,640,627$ 215,296,573$ 208,328,543$ (6,968,030)$ 202,725,687$ 224,467,537$ 21,741,850$

29 24
FINANCIAL PLAN UPDATE FY 2021-23

CITYWIDE
Citywide Total Revenues by Fund
Fund Type
F Y 2020-21
Actual
F Y 2021-22
Existing
Budget
F Y 2021-22
Proposed
Budget
F Y 2021-22
Change
F Y 2022-23
Existing
Budget
F Y 2022-23
Proposed
Budget
F Y 2022-23
Change
General Fund
General Fund 128,639,967$ 126,720,204$ 133,354,121$ 6,633,917$ 125,712,280$ 132,457,992$ 6,745,712$ Total General Fund 128,639,967$ 126,720,204$ 133,354,121$ 6,633,917$ 125,712,280$ 132,457,992$ 6,745,712$ Enterprise Funds
Airport 3,807,332$ 3,884,716$ 4,036,710$ 151,994$ 3,923,290$ 4,154,716$ 231,426$ Airport Grant 296,157 430,000 430,000 - 8,145,000 8,145,000 - Storm Water 2,907,114 3,946,175 3,510,538 (435,637) 3,951,878 3,851,878 (100,000) Storm Drain 177,161 341,680 224,680 (117,000) 346,680 164,680 (182,000) FEMA Storm Reimbursement 45,288 797,635 119,852 (677,783) 970,000 235,625 (734,375) Sewer 25,657,689 27,543,847 27,545,347 1,500 28,936,805 28,936,805 - Sewer Replacement 8,089,827 8,107,623 8,107,623 - 9,107,623 9,107,623 - Sewer Connection Fees 2,019,585 2,144,589 682,589 (1,462,000) 2,078,589 1,462,589 (616,000) LAVWMA 4,136,092 3,337,423 3,337,423 - 3,337,423 3,337,423 - Water 17,747,755 17,577,448 17,549,815 (27,633) 18,262,402 18,214,092 (48,310) Water Connection Fees 127,257 463,326 85,326 (378,000) 424,326 305,326 (119,000) Water Replacement 2,070,192 2,080,937 2,080,937 - 2,080,937 2,080,937 - Total Enterprise Funds 67,081,449 70,655,399 67,710,840 (2,944,559) 81,564,953 79,996,694 (1,568,259) Capital Project Funds
Developers Deposit 200,000$ 6,176$ 6,176$ -$ 6,176$ 6,176$ -$ Vasco Ace - Connector Rd 184 200 200 - 200 200 - Traffic Impact Fee (TIF) 606,936 4,688,249 1,795,249 (2,893,000) 2,649,249 3,095,249 446,000 2022 COP Construction Fund - 39,903,340 - (39,903,340) - 50,000,000 50,000,000 TVTC 20% Fee 162,971 1,930,162 265,162 (1,665,000) 1,426,162 1,215,162 (211,000) Downtown Revitlization Fee 5,850 552,000 - (552,000) 303,000 150,000 (153,000) HHS - Human Services Facilities Fee 108,287 120,000 50,000 (70,000) 120,000 120,000 - Parking In Lieu Fee 39,512 - 3,000,000 3,000,000 - - - Park Fee - AB 1600 1,074,143 4,889,571 832,571 (4,057,000) 3,676,571 3,632,571 (44,000) Transferable Development Credits - 2,780,876 - (2,780,876) - 4,447,828 4,447,828 El Charro Infrastructure 453,579 21,468 21,468 - 15,000 15,000 - Solid Waste & Recycling Impact Fee 1,286,024 1,324,604 1,305,828 (18,776) 1,364,342 1,354,666 (9,676) Other Capital Projects - - - - - - - Total Capital Project Funds 3,937,486$ 56,216,646$ 7,276,654$ (48,939,992)$ 9,560,700$ 64,036,852$ 54,476,152$ Debt Service Funds
2020 COPs Series A 228,171$ 475,600$ 480,000$ 4,400$ 490,850$ 497,300$ 6,450$ 2020 COPs Series B 1,076,684 3,850,946 3,881,018 30,072 3,882,015 3,882,372 357 2022 COPs Debt Service - 1,112,272 - (1,112,272) 2,570,626 1,865,000 (705,626) Total Debt Service Funds 1,304,855$ 5,438,818$ 4,361,018$ (1,077,800)$ 6,943,491$ 6,244,672$ (698,819)$ Permanent Funds
Doolan Canyon Preserv Endowment 186,198$ 66,244$ 66,244$ -$ 66,244$ 66,244$ -$ Total Permanent Funds 186,198$ 66,244$ 66,244$ -$ 66,244$ 66,244$ -$ 30 25
FINANCIAL PLAN UPDATE FY 2021-23

CITYWIDE
Citywide Total Revenues by Fund (Continued)
Fund Type
F Y 2020-21
Actual
F Y 2021-22
Existing
Budget
F Y 2021-22
Proposed
Budget
F Y 2021-22
Change
F Y 2022-23
Existing
Budget
F Y 2022-23
Proposed
Budget
F Y 2022-23
Change
Special Revenue Funds
Host Community Impact Fee 513,474$ 518,000$ 525,000$ 7,000$ 530,000$ 535,000$ 5,000$ City Street Sweeping 662,303 681,454 671,801 (9,653) 701,882 696,908 (4,974) LPD - COPS Ahead AB 3229 220,467 252,725 222,725 (30,000) 282,725 252,725 (30,000) State Grant - HHS - - 100,000 100,000 - 432,677 432,677 State Grant 643,291 693,895 367,500 (326,395) 192,395 1,062,075 869,680 Public Art Fee 87,032 170,000 170,000 - 190,000 190,000 - Housing Successor Agency 396,800 149,629 149,629 - 149,629 149,629 - LPD - Horizons 1,209,038 1,083,058 1,075,058 (8,000) 972,027 1,135,258 163,231 Low Income Housing Fund 1,201,088 1,207,038 1,264,443 57,405 1,207,038 1,264,443 57,405 Alameda County - Measure D 274,502 285,999 280,999 (5,000) 290,999 285,999 (5,000) CDBG 772,595 501,353 1,604,384 1,103,031 692,304 497,459 (194,845) Landscape Maintenance District 3,250,568 3,580,751 3,932,945 352,194 3,580,751 4,088,612 507,861 Federal Grant 1,722,017 - - - - - - Used Oil Recycling Grant 7,653 24,200 24,200 - 24,200 24,200 - Asset Seizure 351,771 57,367 27,367 (30,000) 57,367 27,367 (30,000) Social Opportunity Endowment 632 885 885 - 885 885 - BJA - Bulletproof Vest Reimb 3,778 15,000 15,000 - 15,000 15,000 - Calhome Reuse 252,917 43,200 55,000 11,800 43,200 50,000 6,800 Local & Other Grants 54,472 - - - 120,000 120,000 - CHFA Homebuyer Assistance 2,731 1,100 1,100 - 1,100 1,100 - Mortgage Assistance 161,683 15,000 45,000 30,000 15,000 45,000 30,000 CA Beverage Container Grant 28,296 22,000 28,000 6,000 22,000 22,000 - HUD Edi Special Grant Fed 20,906 700 700 - 700 700 - LPD - Federal Grants 46,508 50,634 160,000 109,366 72,000 153,629 81,629 Calif Begin Program - 45,000 - (45,000) 45,000 35,000 (10,000) Vehicle Impound Prog 28,305 35,000 30,000 (5,000) 35,000 30,000 (5,000) Open Space Acquis & Mgmt 9,963 6,160,350 643,830 (5,516,520) 10,350 5,560,350 5,550,000 CASP Cert & Training Fund 10,044 15,500 15,500 - 15,500 15,500 - Gas Taxes 2,163,034 2,039,489 1,824,989 (214,500) 2,039,489 2,039,489 - Gas Tax - SB1 1,784,079 1,660,000 1,300,000 (360,000) 1,660,000 1,660,000 - Federal Street Grants 1,277,260 - 104,740 104,740 - - - PEG Capital Fees 247,107 220,000 220,000 - 218,000 250,000 32,000 Solid Waste & Recycling 236,486 244,290 240,128 (4,162) 252,352 249,109 (3,243) Federal Home Program 155,158 139,428 139,419 (9) 139,428 139,500 72 Library Donations Fund 145,611 80,000 80,000 - 80,000 80,000 - Library Foundation Grant 49,922 50,000 78,000 28,000 50,000 78,000 28,000 MTC - TDA - 180,000 - (180,000) 50,000 580,000 530,000 Livermore's School Grant - 160,000 28,238 (131,762) 160,000 - (160,000) Measure B-Bike/Pedestrian 329,605 303,007 253,007 (50,000) 303,007 253,007 (50,000) Measure B-Local St & Rd 1,226,019 1,127,948 907,948 (220,000) 1,127,948 907,948 (220,000) Measure B Isabel Interchange 32,865 - - - - - - State Street Grants 897,288 640,000 - (640,000) 740,000 1,380,000 640,000 Local Vehicle Reg Fee 420,962 401,927 271,927 (130,000) 401,927 301,927 (100,000) Police Donations Fund 2,156 6,000 5,000 (1,000) 6,000 7,500 1,500 Measure BB-Bike/Ped 269,899 252,608 222,608 (30,000) 252,608 222,608 (30,000) Measure BB-Local St & Rd 1,103,145 1,007,708 807,708 (200,000) 1,007,708 807,708 (200,000) El Charro Maint CFD 2012-1 347,631 438,189 438,189 - 438,189 438,189 - Other Maint CFD's 323,562 277,946 277,946 - 277,946 277,946 - Surplus - AD Closeout 9,044 9,044 9,044 - 9,044 9,044 - Total Special Revenue Funds 22,953,667$ 24,847,422$ 18,619,957$ (6,227,465)$ 18,480,698$ 26,373,491$ 7,892,793$ 31 26
FINANCIAL PLAN UPDATE FY 2021-23

Special Revenue Funds
Special revenue funds are used to account for City revenues from sources that, by law or administrative action, are designated to finance particular functions or activities of government.

The City has 42 Special Revenue funds that in total represent revenue budget adjustments of a decrease of $6.2 million in FY 21-22 and an increase of $7.9 million in FY 22-23. The largest contributing factor to these adjustments is a timing shift in revenue from FY 21-22 to FY 22-23 of $5.5 million in the Open Space Acquisition & Management fund for Springtown and Doolan Canyon conservation easements and $0.6 million in the State Street Grants fund for the Vasco Road/I-580 Interchange project. In FY 22-23, the State Grant fund increased by $0.9 million primarily due to a Priority Conservation Area grant for the Arroyo Road Trail project.

Enterprise Funds
Enterprise funds account for city operations which are financed and operated in a manner similar to private enterprise. User charges and impact fees recover costs of providing service to the public. The operation categories are airport, water, sewer and storm water.

In FY 21-22, the updated revenue budget dropped by $2.9 million. The largest decrease, $1.8 million, was in water and sewer connection fee revenue. Annual growth rates for both water and sewer connection fees are subject to the cyclical nature of development and the economy. An additional decrease of $0.7 million represents an adjustment to the expected FEMA grant reimbursement for storm damage repairs.

In FY22-23, the updated revenue budget decreased by $1.6 million. As in FY 21-22, the decrease was due primarily to water/sewer connection fees and anticipated FEMA grant reimbursement that each dropped by $0.7 million.

32 27
FINANCIAL PLAN UPDATE FY 2021-23

CITYWIDE
Citywide Total Expenditures by Fund
Fund F Y 2020-21
Actual
F Y 2021-22
Existing
Budget
F Y 2021-22
Proposed
Budget
F Y 2021-22
Change
F Y 2022-23
Existing
Budget
F Y 2022-23
Proposed
Budget
F Y 2022-23
Change
General Fund
General Fund 123,613,822$ 143,829,469$ 145,573,902$ 1,744,433$ 129,799,732$ 139,295,797$ 9,496,065$ General Fund Total 123,613,822$ 143,829,469$ 145,573,902$ 1,744,433$ 129,799,732$ 139,295,797$ 9,496,065$ Enterprise
Airport 3,460,302$ 4,377,309$ 3,931,800$ (445,509)$ 4,794,834$ 4,981,455$ 186,621$ Airport Grant 296,157 430,000 - (430,000) 8,145,000 8,575,000 430,000 Storm Water 2,839,263 4,020,141 3,538,595 (481,546) 3,753,746 3,783,549 29,803 Storm Drain 282,939 54,681 125,024 70,343 12,206 11,206 (1,000) FEMA Storm Reimbursement 576,441 2,725,021 230,000 (2,495,021) 970,000 462,635 (507,365) Sewer 25,801,675 28,399,782 27,098,950 (1,300,832) 28,691,216 29,582,850 891,634 Sewer Replacement 5,756,961 4,526,249 3,113,546 (1,412,703) 19,720,241 19,638,241 (82,000) Sewer Connection Fees 3,239,460 2,273,475 1,946,961 (326,514) 6,503,475 7,644,556 1,141,081 LAVWMA 3,324,490 3,660,481 3,660,481 - 3,763,440 3,763,440 - Water 17,738,866 19,112,075 18,625,988 (486,087) 19,091,370 19,222,198 130,828 Water Connection Fees 199,907 647,358 299,858 (347,500) 837,984 1,121,807 283,823 Water Replacement 859,701 880,253 803,253 (77,000) 2,711,453 832,453 (1,879,000) Enterprise Total 64,376,162$ 71,106,825$ 63,374,456$ (7,732,369)$ 98,994,965$ 99,619,390$ 624,425$ Capital Projects
Developers Deposit 200,000$ -$ -$ -$ -$ -$ -$ Traffic Impact Fee (TIF) 805,227 2,592,744 1,308,744 (1,284,000) 3,587,495 2,980,106 (607,389) 2022 COP Construction Fnd - 1,685,000 1,675,000 (10,000) 34,890,000 16,580,000 (18,310,000) TVTC 20% Fee 14,534 2,261,000 1,626,000 (635,000) 1,521,250 2,536,250 1,015,000 Downtown Revitlization Fee - - - - - 150,000 150,000 HHS - Human Services Facilities Fee 200,315 2,039,726 420,000 (1,619,726) - 1,739,835 1,739,835 Parking In Lieu Fee - 110,000 72,000 (38,000) 50,000 50,000 - Park Fee - AB 1600 1,346,924 7,905,000 6,485,000 (1,420,000) 7,490,000 1,998,000 (5,492,000) El Charro Infrastructure 453,579 21,468 - (21,468) 15,000 - (15,000) El Charro Specific Plan 433,477 - - - - - - Solid Waste & Recycling Impact Fee 642,044 963,198 550,000 (413,198) 3,388,198 5,075,000 1,686,802 Other Capital Projects 3,898 - - - - - - Capital Projects Total 4,099,998$ 17,578,136$ 12,136,744$ (5,441,392)$ 50,941,943$ 31,109,191$ (19,832,752)$ Debt Service
2020 COPs Series A 229,161$ 475,000$ 480,000$ 5,000$ 490,250$ 497,300$ 7,050$ 2020 COPs Series B 1,094,699 3,850,440 3,881,018 30,578 3,881,509 3,882,372 863 2022 COPs Debt Service - 1,112,272 - (1,112,272) 2,570,626 1,865,000 (705,626) Debt Service Total 1,323,860$ 5,437,712$ 4,361,018$ (1,076,694)$ 6,942,385$ 6,244,672$ (697,713)$ Permanent
Dooln Cnyn Presrv Endwmnt 26,321$ 26,000$ 28,000$ 2,000$ 26,000$ 28,000$ 2,000$ Permanent Total 26,321$ 26,000$ 28,000$ 2,000$ 26,000$ 28,000$ 2,000$ 33 28
FINANCIAL PLAN UPDATE FY 2021-23

CITYWIDE
Citywide Total Expenditures by Fund (Continued)
Fund F Y 2020-21
Actual
F Y 2021-22
Existing
Budget
F Y 2021-22
Proposed
Budget
F Y 2021-2022
Change
F Y 2022-23
Existing
Budget
F Y 2022-23
Proposed
Budget
F Y 2022-2023
Change
Special Revenue
Host Community Impact Fee 268,775$ 506,104$ 500,504$ (5,600)$ 521,364$ 527,814$ 6,450$ City Street Sweeping 691,759 711,249 717,826 6,577 715,766 671,052 (44,714) LPD - COPS Ahead AB 3229 204,027 659,119 532,666 (126,453) 230,058 514,788 284,730 So Livermore Valley Specific Plan - - 100,000 100,000 - 240,389 240,389 State Grant - HHS - - 100,000 100,000 - 432,677 432,677 State Grant 648,103 693,885 366,398 (327,487) 192,385 1,058,613 866,228 Public Art Fee 81,218 421,840 421,840 - 330,393 330,393 - Housing Successor Agency 1,011 2,458,386 1,000,636 (1,457,750) 610 1,458,360 1,457,750 LPD - Horizons 1,120,830 1,083,058 1,085,590 2,532 972,027 1,183,521 211,494 Low Income Housing Fund 1,589,801 7,274,256 7,128,940 (145,316) 2,006,107 5,308,621 3,302,514 Alameda County - Measure D 257,938 445,557 331,189 (114,368) 337,548 413,117 75,569 CDBG 830,660 794,105 977,670 183,565 691,494 566,917 (124,577) Landscape Maintenance District 3,335,782 3,061,808 3,130,217 68,409 3,090,350 3,534,310 443,960 Federal Grant 1,009 - - - - - - Used Oil Recycling Grant 7,653 24,200 24,200 - 24,200 24,200 - Asset Seizure 151,458 821,680 576,680 (245,000) 101,715 301,715 200,000 Social Opportunity Endowment 61,000 81,344 87,078 5,734 71,071 81,266 10,195 BJA - Bulletproof Vest Reimb 3,778 15,000 15,000 - 15,000 15,000 - Calhome Reuse 59,253 142,952 63,352 (79,600) 81,148 122,474 41,326 Local & Other Grants 54,472 - - - - - - CHFA Homebuyer Assistance 111 305 305 - 305 305 - Mortgage Assistance 3,255 125,575 65,575 (60,000) 125,618 65,618 (60,000) CA Beverage Container Grt 28,296 22,000 28,000 6,000 22,000 16,000 (6,000) HUD EDI Special Grant Fed 162 58,594 100 (58,494) 700 58,100 57,400 LPD - Federal Grants 113,760 53,815 116,104 62,289 60,740 153,150 92,410 Calif Begin Program 69 30,100 30,100 - 10,100 30,100 20,000 Vehicle Impound Prog 38,985 15,218 20,290 5,072 15,218 20,290 5,072 Open Space Acquis & Mgmt 46,782 23,000 23,000 - 23,000 23,000 - CASP Cert & Training Fund 10,044 15,500 15,500 - 15,500 15,500 - Gas Taxes 354,796 2,070,276 656,600 (1,413,676) 2,627,482 6,726,000 4,098,518 Gas Tax - SB1 562,230 2,562,000 1,669,425 (892,575) 960,000 4,210,000 3,250,000 Federal Street Grants 1,382,000 - - - - - - PEG Capital Fees 44,739 102,093 102,093 - 45,772 45,772 - Import Mitigation 9,000 49,413 26,843 (22,570) - 21,580 21,580 Solid Waste & Recycling 265,279 273,920 290,127 16,207 277,310 295,712 18,402 Federal Home Prgram 146,461 144,813 156,002 11,189 144,862 144,782 (80) Library Donations Fund 66,090 151,727 151,727 - 141,607 141,607 - Library Foundation Grant 42,369 81,521 82,247 726 54,252 82,252 28,000 MTC - TDA - 180,000 - (180,000) 50,000 230,000 180,000 Livermore's School Grant - 160,000 28,238 (131,762) 160,000 - (160,000) Measure B-Bike/Pedestrian 896,145 476,565 282,433 (194,132) 420,650 427,500 6,850 Measure B-Local St & Rd 621,848 2,664,625 1,625,575 (1,039,050) 1,265,625 1,798,425 532,800 State Street Grants 860,739 640,000 - (640,000) 740,000 1,380,000 640,000 Local Vehicle Reg Fee 1,656 1,011,700 120,000 (891,700) 151,700 1,220,000 1,068,300 Police Donations Fund 1,134 21,353 21,353 - 21,361 21,361 - Measure BB-Bike/Ped 604,994 560,300 - (560,300) 280,300 800,000 519,700 Measure BB-Local St & Rd 557,541 2,793,375 570,000 (2,223,375) 50,725 2,985,000 2,934,275 El Charro Maint CFD 2012-1 226,951 395,574 395,854 280 374,348 361,966 (12,382) Other Maint CFD's 162,432 198,837 199,677 840 198,904 192,151 (6,753) Surplus - AD Closeout 421,279 1,280,000 353,000 (927,000) 1,100,000 1,408,000 308,000 Special Revenue Total 16,837,673$ 35,356,742$ 24,189,954$ (11,166,788)$ 18,719,315$ 39,659,397$ 20,940,083$ 34 29
FINANCIAL PLAN UPDATE FY 2021-23

CITYWIDE
Citywide Total Expenditures by Fund (Continued)
Fund F Y 2020-21
Actual
F Y 2021-22
Existing
Budget
F Y 2021-22
Proposed
Budget
F Y 2021-2022
Change
F Y 2022-23
Existing
Budget
F Y 2022-23
Proposed
Budget
F Y 2022-2023
Change
Internal Service
Liab Insurance Reserve 2,450,601$ 4,130,763$ 4,405,538$ 274,775$ 5,035,350$ 5,107,611$ 72,261$ Risk Management-W/C Insur 3,018,689 2,552,485 2,059,171 (493,314) 2,773,819 2,357,494 (416,325) Information Technology 3,633,861 4,266,551 5,261,265 994,714 4,310,575 7,727,652 3,417,077 Cyber Security 194,973 638,095 1,054,781 416,686 641,800 937,340 295,540 Fleet & Eqt Services 3,756,412 6,098,415 6,193,800 95,385 5,294,209 5,576,198 281,989 Facilities Rehab Pgm 2,276,414 6,482,849 3,627,353 (2,855,496) 5,796,372 5,998,640 202,268 Internal Service Total 15,330,951$ 24,169,158$ 22,601,908$ (1,567,250)$ 23,852,125$ 27,704,934$ 3,852,809$ Total Expenditures 225,608,786$ 297,504,042$ 272,265,982$ (25,238,060)$ 329,276,465$ 343,661,381$ 14,384,916$ 35 30
FINANCIAL PLAN UPDATE FY 2021-23

CITYWIDE
Citywide Total Revenues by Category

Revenue Category FY 2020-21
Actual
FY 2021-22
Existing Budget
FY 2021-22
Proposed
Budget
FY 2021-22
Change
FY 2022-23
Existing Budget
FY 2022-23
Proposed
Budget
FY 2022-23
Change
Property Taxes 42,677,735$ 45,545,107$ 44,884,410$ (660,697)$ 47,097,117$ 47,581,049$ 483,932$ Sales & Use Taxes 35,441,550 34,094,000 37,550,000 3,456,000 36,500,000 39,047,000 2,547,000 Franchise Taxes 5,686,312 5,185,281 5,827,371 642,090 5,222,356 6,043,000 820,644 Business License Taxes 6,814,890 5,921,785 7,385,500 1,463,715 6,116,874 7,687,500 1,570,626 Other Taxes 3,651,054 4,250,000 5,862,930 1,612,930 5,550,000 6,850,800 1,300,800 Licenses & Permits 2,587,449 2,596,220 3,315,100 718,880 2,566,487 3,220,242 653,755 Fines & Forfeitures 395,011 370,000 345,000 (25,000) 380,000 355,000 (25,000) Use of Money & Property 9,832,200 5,018,404 5,452,654 434,250 5,111,524 5,260,385 148,861 Intergovernmental Revenue 28,144,610 27,780,237 25,598,878 (2,181,359) 30,827,379 31,807,747 980,368 Other Taxes in Lieu 94,921 177,980 177,980 - 197,980 197,980 - Charges for Current Svc 55,427,931 71,281,818 65,663,813 (5,618,005) 66,446,991 76,246,338 9,799,347 Other Revenue 6,837,844 8,190,666 4,256,087 (3,934,579) 2,060,666 7,571,544 5,510,878 Water Revenue 17,708,624 17,701,739 17,298,239 (403,500) 18,347,366 18,128,366 (219,000) Airport Revenue 3,947,382 4,088,650 4,128,620 39,970 4,125,731 4,281,138 155,407 Operating Revenue Subtotal $ 219,247,514 $ 232,201,887 $ 227,746,582 $ (4,455,305) $ 230,550,471 $ 254,278,088 $ 23,727,617 Transfers In 19,311,409$ 26,163,549$ 22,215,361$ (3,948,188)$ 26,934,415$ 24,598,751$ (2,335,664)$ Other Financing Sources - 40,415,000 - (40,415,000) - 50,540,000 50,540,000 Total Revenues 238,558,923$ 298,780,436$ 249,961,943$ (48,818,493)$ 257,484,886$ 329,416,839$ 71,931,953$

Citywide Total Expenditures by Category

Expense Category FY 2020-21
Actual
FY 2021-22
Existing
Budget
FY 2021-22
Proposed
Budget
FY 2021-22
Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget
FY 2022-23
Change
Personnel Services 45,312,222$ 49,833,666$ 48,089,120$ (1,744,546)$ 50,506,004$ 53,953,641$ 3,447,637$ Supplmntl Personnel Sv cs 34,747,991 38,700,330 36,821,167 (1,879,163) 39,868,749 39,263,051 (605,698) Services & Supplies 95,035,897 121,848,486 118,642,165 (3,206,321) 108,436,450 126,170,461 17,734,011 Capital Outlay 1,544,518 4,914,091 4,776,091 (138,000) 3,914,484 5,080,384 1,165,900 Total Operating Expenditures 176,640,627$ 215,296,573$ 208,328,543$ (6,968,030)$ 202,725,687$ 224,467,537$ 21,741,850$ Transfers Out 19,311,410$ 26,178,549$ 22,215,361$ (3,963,188)$ 26,934,415$ 24,598,751$ (2,335,664)$ Capital Improv ement 23,959,561 54,981,364 37,078,550 (17,902,814) 98,876,100 92,414,735 (6,461,365) Addition to Reserves 5,697,188 1,047,556 4,643,528 3,595,972 740,263 2,180,358 1,440,095 Total Expenditures 225,608,786$ 297,504,042$ 272,265,982$ (25,238,060)$ 329,276,465$ 343,661,381$ 14,384,916$

36 31
FINANCIAL PLAN UPDATE FY 2021-23

CITYWIDE
Citywide Expenditures by Division – FY2021-22 Proposed Budget Department/Division General Fund Enterprise
Funds
Capital Projects
Funds
Debt Service
Funds
Permanent
Funds
Special
Revenue
Funds
Internal Service
Funds
Total
Expenditures
City Council
City Council 261,587$ -$ -$ -$ -$ -$ -$ 261,587$ City Council Total 261,587$ -$ -$ -$ -$ -$ -$ 261,587$ City Manager
City Manager 2,348,260$ -$ -$ -$ -$ 73,994$ -$ 2,422,254$ City Manager Total 2,348,260$ -$ -$ -$ -$ 73,994$ -$ 2,422,254$ City Attorney
City Attorney 2,186,599$ -$ -$ -$ -$ -$ -$ 2,186,599$ Risk Management - - - - - - 6,464,709 6,464,709 City Attorney Total 2,186,599$ -$ -$ -$ -$ -$ 6,464,709$ 8,651,308$ Administrative Services
Administrative Svcs Admin 625,030$ -$ -$ -$ -$ -$ -$ 625,030$ City Clerk 1,785,983 - - - - - - 1,785,983 Cyber Security - - - - - - 1,054,781 1,054,781 Finance 3,453,692 - - - - 11,000 - 3,464,692 Human Resources 1,771,515 - - - - - - 1,771,515 Information Technology - - - - - - 5,261,265 5,261,265 Administrative Services Total 7,636,219$ -$ -$ -$ -$ 11,000$ 6,316,046$ 13,963,265$ Community Development
Building & Permits 3,768,335$ -$ -$ -$ -$ -$ -$ 3,768,335$ Community Development 3,043,874 - - - - - - 3,043,874 Engineering 5,207,331 - - - - 105,000 - 5,312,331 Housing & Human Services 4,218,106 - - - - 8,366,383 - 12,584,489 Planning 5,030,090 - - - 28,000 89,000 - 5,147,090 Community Development Total 21,267,737$ -$ -$ -$ 28,000$ 8,560,383$ -$ 29,856,120$ Fir e
Fire Emergency 19,219,850$ -$ -$ -$ -$ -$ -$ 19,219,850$ Fire Admin & Prevention 4,821,726 - - - - 24,200 - 4,845,926 Fire Total 24,041,576$ -$ -$ -$ -$ 24,200$ -$ 24,065,776$ Innovation & Econ Dev
Innovation & Econ Dev 2,893,620$ -$ -$ -$ -$ 296,840$ -$ 3,190,460$ Innovation & Econ Dev Total 2,893,620$ -$ -$ -$ -$ 296,840$ -$ 3,190,460$ 37 32
FINANCIAL PLAN UPDATE FY 2021-23

CITYWIDE
Citywide Expenditures by Division – FY2021-22 Proposed Budget (Continued) Department/Division General Fund Enterprise
Funds
Capital Projects
Funds
Debt Service
Funds
Permanent
Funds
Special
Revenue
Funds
Internal Service
Funds
Total
Expenditures
Library
Library 6,457,670$ -$ -$ -$ -$ 193,974$ -$ 6,651,644$ Library Total 6,457,670$ -$ -$ -$ -$ 193,974$ -$ 6,651,644$ G eneral Services
General Services 4,411,457$ -$ -$ 4,361,018$ -$ -$ -$ 8,772,475$ G eneral Services Total 4,411,457$ -$ -$ 4,361,018$ -$ -$ -$ 8,772,475$ Police
Horizons -$ -$ -$ -$ -$ 1,085,590$ -$ 1,085,590$ Police 40,664,368 - - - - 762,491 - 41,426,859 Police Total 40,664,368$ -$ -$ -$ -$ 1,848,081$ -$ 42,512,449$ Public Works
Airport -$ 3,366,800$ -$ -$ -$ -$ -$ 3,366,800$ Maintenance 7,468,385 - - - - 3,824,685 9,008,849 20,301,919 Public Works 1,421,409 - - - - 1,393,985 - 2,815,394 Sewer - 20,728,483 - - - - - 20,728,483 Stormwater User - 3,543,767 - - - - - 3,543,767 Water - 17,224,841 - - - - - 17,224,841 Public Works Total 8,889,795$ 44,863,891$ -$ -$ -$ 5,218,670$ 9,008,849$ 67,981,204$ Total Operating Expenditures 121,058,888$ 44,863,891$ -$ 4,361,018$ 28,000$ 16,227,142$ 21,789,604$ 208,328,543$ Transfers Out 6,294,486$ 14,219,565$ 62,435$ -$ -$ 1,638,875$ -$ 22,215,361$ Capital Improvements 13,577,000 4,291,000 12,074,309 - - 6,323,937 812,304 37,078,550 Addition to Reserves 4,643,528 - - - - - - 4,643,528 Total Expenditures 145,573,902$ 63,374,456$ 12,136,744$ 4,361,018$ 28,000$ 24,189,954$ 22,601,908$ 272,265,982$

38 33
FINANCIAL PLAN UPDATE FY 2021-23

CITYWIDE
Citywide Expenditures by Division – FY2022-23 Proposed Budget Department/Division General Fund Enterprise
Funds
Capital Projects
Funds
Debt Service
Funds
Permanent
Funds
Special
Revenue
Funds
Internal Service
Funds
Total
Expenditures
City Council
City Council 226,566$ -$ -$ -$ -$ -$ -$ 226,566$ City Council Total 226,566$ -$ -$ -$ -$ -$ -$ 226,566$ City Manager
City Manager 2,896,537$ -$ -$ -$ -$ 45,772$ -$ 2,942,309$ City Manager Total 2,896,537$ -$ -$ -$ -$ 45,772$ -$ 2,942,309$ City Attorney
City Attorney 2,178,329$ -$ -$ -$ -$ -$ -$ 2,178,329$ Risk Management - - - - - - 7,465,105 7,465,105 City Attorney Total 2,178,329$ -$ -$ -$ -$ -$ 7,465,105$ 9,643,435$ Administrative Services
Administrative Svcs Admin 652,905$ -$ -$ -$ -$ -$ -$ 652,905$ City Clerk 2,054,102 - - - - - - 2,054,102 Cyber Security - - - - - - 937,340 937,340 Finance 4,164,245 - - - - 11,000 - 4,175,245 Human Resources 1,813,427 - - - - - - 1,813,427 Information Technology - - - - - - 7,727,652 7,727,652 Administrative Services Total 8,684,680$ -$ -$ -$ -$ 11,000$ 8,664,991$ 17,360,671$ Community Development
Building & Permits 4,347,783$ -$ -$ -$ -$ -$ -$ 4,347,783$ Community Development 1,212,608 - - - - - - 1,212,608 Engineering 5,718,762 - 400,000 - - 162,000 - 6,280,762 Housing & Human Services 3,294,461 - 1,739,835 - - 7,653,796 - 12,688,092 Planning 5,951,001 - - - 28,000 155,000 - 6,134,001 Community Development Total 20,524,616$ -$ 2,139,835$ -$ 28,000$ 7,970,796$ -$ 30,663,247$ Fir e
Fire Emergency 20,375,190$ -$ -$ -$ -$ -$ -$ 20,375,190$ Fire Admin & Prevention 5,062,370 - - - - 24,200 - 5,086,570 Fire Total 25,437,560$ -$ -$ -$ -$ 24,200$ -$ 25,461,760$ Innovation & Econ Dev
Innovation & Econ Dev 2,786,435$ -$ -$ -$ -$ 205,393$ -$ 2,991,828$ Innovation & Econ Dev Total 2,786,435$ -$ -$ -$ -$ 205,393$ -$ 2,991,828$ 39 34
FINANCIAL PLAN UPDATE FY 2021-23

CITYWIDE
Citywide Expenditures by Division – FY2022-23 Proposed Budget (Continued) Department/Division General Fund Enterprise
Funds
Capital Projects
Funds
Debt Service
Funds
Permanent
Funds
Special
Revenue
Funds
Internal Service
Funds
Total
Expenditures
Library
Library 6,870,311$ -$ -$ -$ -$ 198,859$ -$ 7,069,170$ Library Total 6,870,311$ -$ -$ -$ -$ 198,859$ -$ 7,069,170$ G eneral Services
General Services 3,596,673$ -$ -$ 6,244,672$ -$ -$ -$ 9,841,345$ G eneral Services Total 3,596,673$ -$ -$ 6,244,672$ -$ -$ -$ 9,841,345$ Police
Horizons -$ -$ -$ -$ -$ 1,183,521$ -$ 1,183,521$ Police 44,455,554 - - - - 847,341 - 45,302,895 Police Total 44,455,554$ -$ -$ -$ -$ 2,030,862$ -$ 46,486,416$ Public Works
Airport -$ 3,562,105$ -$ -$ -$ -$ -$ 3,562,105$ Maintenance 7,679,703 - - - - 4,295,441 8,524,838 20,499,981 Public Works 1,663,431 - - - - 1,417,461 - 3,080,892 Sewer - 22,985,632 - - - - - 22,985,632 Stormwater User - 3,659,130 - - - - - 3,659,130 Water - 17,993,050 - - - - - 17,993,050 Public Works Total 9,343,134$ 48,199,917$ -$ -$ -$ 5,712,902$ 8,524,838$ 71,780,791$ Total Operating Expenditures 127,000,395$ 48,199,917$ 2,139,835$ 6,244,672$ 28,000$ 16,199,784$ 24,654,934$ 224,467,537$ Transfers Out 8,218,044$ 15,030,488$ 213,995$ -$ -$ 1,136,224$ -$ 24,598,751$ Capital Improvements 1,897,000 36,388,985 28,755,361 - - 22,323,389 3,050,000 92,414,735 Addition to Reserves 2,180,358 - - - - - - 2,180,358 Total Expenditures 139,295,797$ 99,619,390$ 31,109,191$ 6,244,672$ 28,000$ 39,659,397$ 27,704,934$ 343,661,381$

40 35
FINANCIAL PLAN UPDATE FY 2021-23

CITYWIDE
Citywide Transfers Schedule
FY 2020-21
Actual
FY 2021-22
Proposed
FY 2022-23
Proposed
General Fund
001 General Fund 220 Stormwater 1,767,363$ 1,767,363$ 2,300,000$ (1) 001 General Fund 417 2020 COPs Series B 1,076,684 3,881,018 3,882,372 (2) 001 General Fund 422 2022 COPs Debt Service Fund - - 1,325,000 (3) 001 General Fund 610 Horizons 638,749 450,558 509,258 (1) 001 General Fund 614 Maintenance District L&LD 118,985 195,547 201,414 (4) 001 General Fund 615 Federal Grant 587,797 - - (5) Total Transfers From General Fund 4,189,577$ 6,294,486$ 8,218,044$ Enterprise Funds
210 Airport 212 Airport Grant 15,822$ -$ -$ (6) 220 Stormwater 222 FEMA Storm Reimbursement 5,590 49,852 60,625 (7) 230 Sewer 220 Stormwater - 600,000 400,000 (8) 230 Sewer 239 Water Resources Replcmt 8,000,000 8,000,000 9,000,000 (9) 230 Sewer 242 LAVWMA 2,500,000 2,000,000 2,000,000 (10) 241 Sewer Connection Fees 242 LAVWMA 1,253,788 1,328,455 1,328,455 (10) 250 Water 259 Water Replacement 2,000,000 2,000,000 2,000,000 (9) 251 Water Connection Fees 250 Water 61,006 241,258 241,408 (2) Total Transfers From Enterprise Funds 13,836,206$ 14,219,565$ 15,030,488$ Capital Improvement Funds
306 Traffic Impact Fee 001 General Fund -$ 62,435$ 63,995$ (11) 331 Dwntwn Revitlztn Fee 001 General Fund - - 150,000 (12) 341 El Charro Developer Fees 340 El Charro Infrastructure 433,477 - - (13) Total Transfers from Capital Improvement Funds 433,477$ 62,435$ 213,995$ Special Revenue Funds
600 Host Community Impact Fee 416 2020 COPs Series A 228,171$ 480,000$ 497,300$ (2) 611 Low Income Housing Fund 001 General Fund 273,167 249,340 252,424 (14) 611 Low Income Housing Fund 613 HHS-HCD CDBG - 516,035 - (15) 614 Maintenance District L&LD 001 General Fund 246,707 234,000 240,000 (11) 615 Federal Grant 001 General Fund 1,009 - - (16) 621 BJA - Bullet Proof Vest Reimb 001 General Fund 1,080 - - (17) 642 Open Space Acquis & Mgmt 500 Doolan Canyon Presrve Endwmnt 24,725 - - (18) 645 CASP Cert & Training Fund 001 General Fund 6,494 4,500 4,500 (13) 650 Gas Taxes 001 General Fund - 107,000 109,000 (11) 651 Gas Tax - SB1 650 Gas Taxes 62,230 (19) 671 HHS - Federal Home Program 001 General Fund 8,566 8,000 8,000 (20) 673 Library Foundation Grant 001 General Fund - 40,000 25,000 (20) Total Transfers from Special Revenue Funds 852,149$ 1,638,875$ 1,136,224$ Total Transfers Out 19,311,409$ 22,215,361$ 24,598,751$ Description of Transfer Description of Transfer
(1) Operating Subsidy (11) Administrative and Overhead Cost (2) Debt Service for 2020 COP (12) Principal Payment (3) Debt Service Expense for a new 2022 COP (13) Reimburse for Expenditures (4) Downtown LMD General Benefit Transfer (14) Affordable Housing Activities (5) Transfer for COVID related expenses (15) Loan Payoff to HUD (6) 10% Match for Federal Grants (16) Refund portion of original transfer (7) 25% Match for FEMA Grant (17) Reimburse for Federal Grants (8) To eliminate Stormwater fund balance deficit (18) Annual Reporting Requirements (9) Annual Replacement Contribution (19) Transfer to correct fund receipts (10) Debt Service LAVWMA Bonds (20) Reimburse Staff Time Transfer From Transfer To
41 36
FINANCIAL PLAN UPDATE FY 2021-23

FUND BALANCES
Projected Fund Balances FY 2021-22
Fund Name
Beginning Fund
Balance
FY 2021-22
Operating
Revenue Transfers In
Other
Financing
Sources Total Sources
Operating
Expenditure
Capital
Expenditure Transfers Out Reserves Total Uses
Estimated
Ending Fund
Balance
FY 2021-22
General Fund
General Fund 26,273,570$ 132,648,846$ 705,275$ -$ 159,627,691$ 121,058,888$ 13,577,000$ 6,294,486$ 4,643,528$ 145,573,902$ 14,053,789$ General Fund Total 26,273,570$ 132,648,846$ 705,275$ -$ 159,627,691$ 121,058,888$ 13,577,000$ 6,294,486$ 4,643,528$ 145,573,902$ 14,053,789$ Enterprise Funds
Airport 5,457,827$ 4,036,710$ -$ -$ 9,494,537$ 3,366,800$ 565,000$ -$ -$ 3,931,800$ 5,562,737$ Airport Grant - 430,000 - - 430,000 - - - - - 430,000 Storm Water 162,308 1,143,175 2,367,363 - 3,672,846 3,418,743 70,000 49,852 - 3,538,595 134,251 Storm Drain 7,018,889 224,680 - - 7,243,569 125,024 - - - 125,024 7,118,545 FEMA Storm Reimbursement 2,617,834 70,000 49,852 - 2,737,686 - 230,000 - - 230,000 2,507,686 Sewer 19,593,144 27,545,347 - - 47,138,491 16,498,950 - 10,600,000 - 27,098,950 20,039,541 Sewer Replacement 30,395,733 107,623 8,000,000 - 38,503,356 516,546 2,597,000 - - 3,113,546 35,389,810 Sewer Connection Fees 14,059,911 682,589 - - 14,742,500 52,506 566,000 1,328,455 - 1,946,961 12,795,539 LAVWMA 5,279,130 8,968 3,328,455 - 8,616,553 3,660,481 - - - 3,660,481 4,956,072 W ater 10,649,060 17,308,557 241,258 - 28,198,875 16,625,988 - 2,000,000 - 18,625,988 9,572,887 Water Connection Fees 1,263,410 85,326 - - 1,348,736 8,600 50,000 241,258 - 299,858 1,048,878 Water Replacement 21,809,995 80,937 2,000,000 - 23,890,932 590,253 213,000 - - 803,253 23,087,679 Enterprise Funds Total 118,307,241$ 51,723,912$ 15,986,928$ -$ 186,018,081$ 44,863,891$ 4,291,000$ 14,219,565$ -$ 63,374,456$ 122,643,625$ Capital Projects
Developers Deposit -$ 6,176$ -$ -$ 6,176$ -$ -$ -$ -$ -$ 6,176$ Vasco Ace - Connector Rd 69,145 200 - - 69,345 - - - - - 69,345 Traffic Impact Fee (TIF) 23,419,899 1,795,249 - - 25,215,148 - 1,246,309 62,435 - 1,308,744 23,906,404 2022 COP Construction Fund - - - - - - 1,675,000 - - 1,675,000 (1,675,000) TVTC 20% Fee 3,878,759 265,162 - - 4,143,921 - 1,626,000 - - 1,626,000 2,517,921 Isabel / I-580 Interchange - - - - - - - - - - - Downtown Revitlization Fee (3,874,396) - - - (3,874,396) - - - - - (3,874,396) HHS - Human Services Fac. Fee 2,584,411 50,000 - - 2,634,411 - 420,000 - - 420,000 2,214,411 Parking In Lieu Fee 162,065 3,000,000 - - 3,162,065 - 72,000 - - 72,000 3,090,065 Former Rte 84-Repair Funds - - - - - - - - - - - Park Fee - AB1600 7,712,466 832,571 - - 8,545,037 - 6,485,000 - - 6,485,000 2,060,037 Transferable Dev. Credits 14,557,752 - - - 14,557,752 - - - - - 14,557,752 El Charro Infrastructure - 21,468 - - 21,468 - - - - - 21,468 El Charro Specific Plan 33,849 - - - 33,849 - - - - - 33,849 SW & Rec Impact Fee 3,491,739 1,305,828 - - 4,797,567 - 550,000 - - 550,000 4,247,567 Capital Projects Total 52,035,689$ 7,276,654$ -$ -$ 59,312,343$ -$ 12,074,309$ 62,435$ -$ 12,136,744$ 47,175,599$ Debt Service
2020 COPs Series A -$ -$ 480,000$ -$ 480,000$ 480,000$ -$ -$ -$ 480,000$ -$ 2020 COPs Series B - - 3,881,018 - 3,881,018 3,881,018 - - - 3,881,018 - 2022 COPs Debt Service - - - - - - - - - - - Debt Service Total -$ -$ 4,361,018$ -$ 4,361,018$ 4,361,018$ -$ -$ -$ 4,361,018$ -$ Permanent Funds
Doolan Canyon Pres. Endow. 692,717$ 66,244$ -$ -$ 758,961$ 28,000$ -$ -$ -$ 28,000$ 730,961$

42 37
FINANCIAL PLAN UPDATE FY 2021-23

FUND BALANCES
Projected Fund Balances FY 2021-22 (Continued)
Fund Name
Beginning Fund
Balance
FY 2021-22
Operating
Revenue Transfers In
Other
Financing
Sources Total Sources
Operating
Expenditure
Capital
Expenditure Transfers Out Reserves Total Uses
Estimated
Ending Fund
Balance
FY 2021-22
Special Revenue Funds
Host Community Impact Fee 1,345,373$ 525,000$ -$ -$ 1,870,373$ 20,504$ -$ 480,000$ -$ 500,504$ 1,369,869$ City Street Sweeping 101,833 671,801 - - 773,634 717,826 - - - 717,826 55,808 LPD - COPS Ahead AB 3229 622,751 222,725 - - 845,476 187,666 345,000 - - 532,666 312,810 So Livermore Valley Specific Plan 340,389 - - - 340,389 - 100,000 - - 100,000 240,389 State Grant - HHS - 100,000 - - 100,000 100,000 - - - 100,000 - State Grant 270 367,500 - - 367,770 266,398 100,000 - - 366,398 1,372 Public Art Fee 840,635 170,000 - - 1,010,635 296,840 125,000 - - 421,840 588,795 Housing Successor Agency 3,360,352 149,629 - - 3,509,981 1,000,636 - - - 1,000,636 2,509,345 LPD - Horizons 91,564 624,500 450,558 - 1,166,622 1,085,590 - - - 1,085,590 81,032 Low Income Housing Fund 19,362,918 1,264,443 - - 20,627,361 5,893,565 470,000 765,375 - 7,128,940 13,498,421 Alameda County - Measure D 305,311 280,999 - - 586,310 331,189 - - - 331,189 255,121 CDBG 474,379 1,088,349 516,035 - 2,078,763 977,670 - - - 977,670 1,101,093 Landscape Maintenance District 8,614,182 3,737,398 195,547 - 12,547,127 2,896,217 - 234,000 - 3,130,217 9,416,910 Federal Grant - - - - - - - - - - - Used Oil Recycling Grant - 24,200 - - 24,200 24,200 - - - 24,200 - Asset Seizure 1,399,709 27,367 - - 1,427,076 201,680 375,000 - - 576,680 850,396 Social Opportunity Endowment 170,789 885 - - 171,674 87,078 - - - 87,078 84,596 BJA - Bulletproof Vest Reimb - 15,000 - - 15,000 15,000 - - - 15,000 - Calhome Reuse 431,211 55,000 - - 486,211 63,352 - - - 63,352 422,859 Local & Other Grants - - - - - - - - - - - CHFA Homebuyer Assistance 57,700 1,100 - - 58,800 305 - - - 305 58,495 Mortgage Assitance 1,223,796 45,000 - - 1,268,796 65,575 - - - 65,575 1,203,221 Ca Beverage Container Grant - 28,000 - - 28,000 28,000 - - - 28,000 - HUD EDI Special Grant Fed 98,037 700 - - 98,737 100 - - - 100 98,637 LPD - Federal Grants (24,442) 160,000 - - 135,558 116,104 - - - 116,104 19,454 Calif Begin Program 60,653 - - - 60,653 30,100 - - - 30,100 30,553 Vehicle Impound Program 143,161 30,000 - - 173,161 20,290 - - - 20,290 152,871 Open Space Acquis & Mgmt 2,561,124 643,830 - - 3,204,954 23,000 - - - 23,000 3,181,954 CASP Cert & Training Fund - 15,500 - - 15,500 11,000 - 4,500 - 15,500 - Gas Taxes 6,225,858 1,824,989 - - 8,050,847 55,000 494,600 107,000 - 656,600 7,394,247 Gas Tax - SB1 3,281,078 1,300,000 - - 4,581,078 - 1,669,425 - - 1,669,425 2,911,653 Federal Street Grants (104,740) 104,740 - - - - - - - - - PEG Capital Fees 1,065,783 220,000 - - 1,285,783 45,756 56,337 - - 102,093 1,183,690 Import Mitigation 49,570 - - - 49,570 26,843 - - - 26,843 22,727 Solid Waste & Recycling 116,189 240,128 - - 356,317 290,127 - - - 290,127 66,190 Federal Home Prgram 58,739 139,419 - - 198,158 148,002 - 8,000 - 156,002 42,156 Library Donations Fund 298,580 80,000 - - 378,580 151,727 - - - 151,727 226,853 Library Foundation Grant 77,579 78,000 - - 155,579 42,247 - 40,000 - 82,247 73,332

MTC - TDA - - - - - - - - - - - Livermore's School Grant - 28,238 - - 28,238 28,238 - - - 28,238 - Measure B-Bike/Pedestrian 374,306 253,007 - - 627,313 217,433 65,000 - - 282,433 344,880 Measure B-Local St & Rd 2,484,636 907,948 - - 3,392,584 95,000 1,530,575 - - 1,625,575 1,767,009 Measure B Isabel Interchange 32,865 - - - 32,865 - - - - - 32,865 State Street Grants - - - - - - - - - - - Local Vehicle Reg Fee 834,809 271,927 - - 1,106,736 - 120,000 - - 120,000 986,736 Police Donations Fund 47,845 5,000 - - 52,845 21,353 - - - 21,353 31,492 Measure BB-Bike/Ped 474,453 222,608 - - 697,061 - - - - - 697,061 Measure BB-Local St & Rd 2,386,744 807,708 - - 3,194,452 50,000 520,000 - - 570,000 2,624,452 El Charro Maint CFD 2012-1 2,017,218 438,189 - - 2,455,407 395,854 - - - 395,854 2,059,553 Other Maint CFD's 1,497,361 277,946 - - 1,775,307 199,677 - - - 199,677 1,575,630 Surplus - AD Closeout 2,349,218 9,044 - - 2,358,262 - 353,000 - - 353,000 2,005,262 Special Revenue Funds Total 65,149,786$ 17,457,817$ 1,162,140$ -$ 83,769,743$ 16,227,142$ 6,323,937$ 1,638,875$ -$ 24,189,954$ 59,579,789$ 43 38
FINANCIAL PLAN UPDATE FY 2021-23

44 39
FINANCIAL PLAN UPDATE FY 2021-23

FUND BALANCES
Projected Fund Balances FY 2022-23
Fund Name
Beginning Fund
Balance
FY 2022-23
Operating
Revenue Transfers In
Other
Financing
Sources Total Sources
Operating
Expenditure
Capital
Expenditure Transfers Out Reserves Total Uses
Estimated
Ending Fund
Balance
FY 2022-23
General Fund
General Fund 14,053,789$ 131,605,073$ 852,919$ -$ 146,511,781$ 127,000,395$ 1,897,000$ 8,218,044$ 2,180,358$ 139,295,797$ 7,215,984$ General Fund Total 14,053,789$ 131,605,073$ 852,919$ -$ 146,511,781$ 127,000,395$ 1,897,000$ 8,218,044$ 2,180,358$ 139,295,797$ 7,215,984$ Enterprise Funds
Airport 5,562,737$ 4,154,716$ -$ -$ 9,717,453$ 3,562,105$ 1,419,350$ -$ -$ 4,981,455$ 4,735,998$ Airport Grant 430,000 8,145,000 - - 8,575,000 - 8,575,000 - - 8,575,000 - Storm Water 134,251 1,151,878 2,700,000 - 3,986,129 3,647,924 75,000 60,625 - 3,783,549 202,579 Storm Drain 7,118,545 164,680 - - 7,283,225 11,206 - - - 11,206 7,272,019 FEMA Storm Reimbursement 2,507,686 175,000 60,625 - 2,743,311 - 462,635 - - 462,635 2,280,676 Sewer 20,039,541 28,936,805 - - 48,976,346 18,182,850 - 11,400,000 - 29,582,850 19,393,496 Sewer Replacement 35,389,810 107,623 9,000,000 - 44,497,433 978,241 18,660,000 - - 19,638,241 24,859,192 Sewer Connection Fees 12,795,539 1,462,589 - - 14,258,128 61,101 6,255,000 1,328,455 - 7,644,556 6,613,572 LAVWMA 4,956,072 8,968 3,328,455 - 8,293,495 3,763,440 - - - 3,763,440 4,530,055 W ater 9,572,887 17,972,684 241,408 - 27,786,979 17,222,198 - 2,000,000 - 19,222,198 8,564,782 Water Connection Fees 1,048,878 305,326 - - 1,354,204 180,399 700,000 241,408 - 1,121,807 232,397 Water Replacement 23,087,679 80,937 2,000,000 - 25,168,616 590,453 242,000 - - 832,453 24,336,163 Enterprise Funds Total 122,643,625$ 62,666,206$ 17,330,488$ -$ 202,640,319$ 48,199,917$ 36,388,985$ 15,030,488$ -$ 99,619,390$ 103,020,929$ Capital Projects
Developers Deposit 6,176$ 6,176$ -$ -$ 12,352$ -$ -$ -$ -$ -$ 12,352$ Vasco Ace - Connector Rd 69,345 200 - - 69,545 - - - - - 69,545 Traffic Impact Fee (TIF) 23,906,404 3,095,249 - - 27,001,653 - 2,916,111 63,995 - 2,980,106 24,021,547 2022 COP Construction Fund (1,675,000) - - 50,000,000 48,325,000 400,000 16,180,000 - - 16,580,000 31,745,000 TVTC 20% Fee 2,517,921 1,215,162 - - 3,733,083 - 2,536,250 - - 2,536,250 1,196,833 Isabel / I-580 Interchange - - - - - - - - - - - Downtown Revitlization Fee (3,874,396) 150,000 - - (3,724,396) - - 150,000 - 150,000 (3,874,396) HHS - Human Services Fac. Fee 2,214,411 120,000 - - 2,334,411 1,739,835 - - - 1,739,835 594,576 Parking In Lieu Fee 3,090,065 - - - 3,090,065 - 50,000 - - 50,000 3,040,065 Former Rte 84-Repair Funds - - - - - - - - - - - Park Fee - AB1600 2,060,037 3,632,571 - - 5,692,608 - 1,998,000 - - 1,998,000 3,694,608 Transferable Dev. Credits 14,557,752 4,447,828 - - 19,005,580 - - - - - 19,005,580 El Charro Infrastructure 21,468 15,000 - - 36,468 - - - - - 36,468 El Charro Specific Plan 33,849 - - - 33,849 - - - - - 33,849 SW & Rec Impact Fee 4,247,567 1,354,666 - - 5,602,233 - 5,075,000 - - 5,075,000 527,233 Capital Projects Total 47,175,599$ 14,036,852$ -$ 50,000,000$ 111,212,451$ 2,139,835$ 28,755,361$ 213,995$ -$ 31,109,191$ 80,103,260$ Debt Service
2020 COPs Series A -$ -$ 497,300$ -$ 497,300$ 497,300$ -$ -$ -$ 497,300$ -$ 2020 COPs Series B - - 3,882,372 - 3,882,372 3,882,372 - - - 3,882,372 - 2022 COPs Debt Service - - 1,325,000 540,000 1,865,000 1,865,000 - - - 1,865,000 - Debt Service Total -$ -$ 5,704,672$ 540,000$ 6,244,672$ 6,244,672$ -$ -$ -$ 6,244,672$ -$ Permanent Funds
Doolan Canyon Pres. Endow. 730,961$ 66,244$ -$ -$ 797,205$ 28,000$ -$ -$ -$ 28,000$ 769,205$ Permanent Funds Total 730,961$ 66,244$ -$ -$ 797,205$ 28,000$ -$ -$ -$ 28,000$ 769,205$ 45 40
FINANCIAL PLAN UPDATE FY 2021-23

FUND BALANCES
Projected Fund Balances FY 2022-23 (Continued)
Fund Name
Beginning Fund
Balance
FY 2022-23
Operating
Revenue Transfers In
Other
Financing
Sources Total Sources
Operating
Expenditure
Capital
Expenditure Transfers Out Reserves Total Uses
Estimated
Ending Fund
Balance
FY 2022-23
Special Revenue Funds
Host Community Impact Fee 1,369,869$ 535,000$ -$ -$ 1,904,869$ 30,514$ -$ 497,300$ -$ 527,814$ 1,377,055$ City Street Sweeping 55,808 696,908 - - 752,716 671,052 - - - 671,052 81,664 LPD - COPS Ahead AB 3229 312,810 252,725 - - 565,535 224,788 290,000 - - 514,788 50,748 So Livermore Valley Specific Plan 240,389 - - - 240,389 - 240,389 - - 240,389 - State Grant - HHS - 432,677 - - 432,677 432,677 - - - 432,677 - State Grant 1,372 1,062,075 - - 1,063,447 343,038 715,575 - - 1,058,613 4,834 Public Art Fee 588,795 190,000 - - 778,795 205,393 125,000 - - 330,393 448,402 Housing Successor Agency 2,509,345 149,629 - - 2,658,974 1,458,360 - - - 1,458,360 1,200,614 LPD - Horizons 81,032 626,000 509,258 - 1,216,290 1,183,521 - - - 1,183,521 32,769 Low Income Housing Fund 13,498,421 1,264,443 - - 14,762,864 4,701,197 355,000 252,424 - 5,308,621 9,454,243 Alameda County - Measure D 255,121 285,999 - - 541,120 413,117 - - - 413,117 128,003 CDBG 1,101,093 497,459 - - 1,598,552 566,917 - - - 566,917 1,031,635 Landscape Maintenance District 9,416,910 3,887,198 201,414 - 13,505,521 3,294,310 - 240,000 - 3,534,310 9,971,211 Federal Grant - - - - - - - - - - - Used Oil Recycling Grant - 24,200 - - 24,200 24,200 - - - 24,200 - Asset Seizure 850,396 27,367 - - 877,763 201,715 100,000 - - 301,715 576,048 Social Opportunity Endowment 84,596 885 - - 85,481 81,266 - - - 81,266 4,215 BJA - Bulletproof Vest Reimb - 15,000 - - 15,000 15,000 - - - 15,000 - Calhome Reuse 422,859 50,000 - - 472,859 122,474 - - - 122,474 350,385 Local & Other Grants - 120,000 - - 120,000 - - - - - 120,000 CHFA Homebuyer Assistance 58,495 1,100 - - 59,595 305 - - - 305 59,290 Mortgage Assitance 1,203,221 45,000 - - 1,248,221 65,618 - - - 65,618 1,182,603 Ca Beverage Container Grant - 22,000 - - 22,000 16,000 - - - 16,000 6,000 HUD EDI Special Grant Fed 98,637 700 - - 99,337 58,100 - - - 58,100 41,237 LPD - Federal Grants 19,454 153,629 - - 173,083 153,150 - - - 153,150 19,933 Calif Begin Program 30,553 35,000 - - 65,553 30,100 - - - 30,100 35,453 Vehicle Impound Program 152,871 30,000 - - 182,871 20,290 - - - 20,290 162,581 Open Space Acquis & Mgmt 3,181,954 5,560,350 - - 8,742,304 23,000 - - - 23,000 8,719,304 CASP Cert & Training Fund - 15,500 - - 15,500 11,000 - 4,500 - 15,500 - Gas Taxes 7,394,247 2,039,489 - - 9,433,736 112,000 6,505,000 109,000 - 6,726,000 2,707,736 Gas Tax - SB1 2,911,653 1,660,000 - - 4,571,653 - 4,210,000 - - 4,210,000 361,653 Federal Street Grants - - - - - - - - - - - PEG Capital Fees 1,183,690 250,000 - - 1,433,690 45,772 - - - 45,772 1,387,918 Import Mitigation 22,727 - - - 22,727 21,580 - - - 21,580 1,147 Solid Waste & Recycling 66,190 249,109 - - 315,299 295,712 - - - 295,712 19,587 Federal Home Prgram 42,156 139,500 - - 181,656 136,782 - 8,000 - 144,782 36,874 Library Donations Fund 226,853 80,000 - - 306,853 141,607 - - - 141,607 165,246 Library Foundation Grant 73,332 78,000 - - 151,332 57,252 - 25,000 - 82,252 69,080 MTC - TDA - 580,000 - - 580,000 - 230,000 - - 230,000 350,000 Livermore's School Grant - - - - - - - - - - - Measure B-Bike/Pedestrian 344,880 253,007 - - 597,887 267,500 160,000 - - 427,500 170,387 Measure B-Local St & Rd 1,767,009 907,948 - - 2,674,957 149,000 1,649,425 - - 1,798,425 876,532 Measure B Isabel Interchange 32,865 - - - 32,865 - - - - - 32,865 State Street Grants - 1,380,000 - - 1,380,000 - 1,380,000 - - 1,380,000 - Local Vehicle Reg Fee 986,736 301,927 - - 1,288,663 - 1,220,000 - - 1,220,000 68,663 Police Donations Fund 31,492 7,500 - - 38,992 21,361 - - - 21,361 17,631 Measure BB-Bike/Ped 697,061 222,608 - - 919,669 - 800,000 - - 800,000 119,669 Measure BB-Local St & Rd 2,624,452 807,708 - - 3,432,160 50,000 2,935,000 - - 2,985,000 447,160 El Charro Maint CFD 2012-1 2,059,553 438,189 - - 2,497,742 361,966 - - - 361,966 2,135,776 Other Maint CFD's 1,575,630 277,946 - - 1,853,576 192,151 - - - 192,151 1,661,425 Surplus - AD Closeout 2,005,262 9,044 - - 2,014,306 - 1,408,000 - - 1,408,000 606,306 Special Revenue Funds Total 59,579,789$ 25,662,819$ 710,672$ -$ 85,953,279$ 16,199,784$ 22,323,389$ 1,136,224$ -$ 39,659,397$ 46,293,882$ 46 41
FINANCIAL PLAN UPDATE FY 2021-23

47 42
FINANCIAL PLAN UPDATE FY 2021-23

CAPITAL IMPROVEMENT TABLES

48 43
FINANCIAL PLAN UPDATE FY 2021-23

CAPITAL IMPROVEMENT TABLES

Capital Improvement Tables
FY 2021-22 & FY 2022-23 Budget Update
49 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY FUND
44 FINANCIAL PLAN UPDATE FY 2021-23
Project Project Name Fund Fund Name
200439 New Civic Center Meeting Hall 001 General Fund
200654 Decorative Wall Replacement- Citywide 001 General Fund 200720 El Charro Specific Plan Infrastructure 001 General Fund 201715 I Street Garage And Land Acquisition 001 General Fund 201958 Real Time Awarness Center 001 General Fund
202120 Downtown Surface Parking 001 General Fund
586003 Livermore Village L Street Garage 001 General Fund 001 Total
201314 Slurry Seal Northside Aprons And Taxi Lanes 210 Airport 201425 Airport Pav ement Maintenance 210 Airport
201615 Airport W ater Quality And HMP Basins 210 Airport 201718 Airport Airfield Markings Maintenance 210 Airport 201849 FBO Building Flood Proofing 210 Airport
202017 Airport Geometry Study Improvements (AIP 27) 210 Airport 202019 Airport Rescue And Firefighting Facility 210 Airport 210 Total
202017 Airport Geometry Study Improvements (AIP 27) 212 Airport Grant 212 Total
201726 Permanent Storm Damage Repairs 2018-19 220 Stormwater 202132 Golf Course Damage Repairs 220 Stormwater
220 Total
201726 Permanent Storm Damage Repairs 2018-19 222 FEMA Storm Reimb 201727 Collier Canyon Creek Silt Basin 222 FEMA Storm Reimb 202015 Arroyo Las Positas Desilting Through LPGC 222 FEMA Storm Reimb 202132 Golf Course Damage Repairs 222 FEMA Storm Reimb
222 Total
201414 Springtown Trunkline Replacement 239 WR Replacement 201519 W RP HVAC And Roofing Repairs 239 WR Replacement 201522 WRP Emergency Generator 239 WR Replacement
201715 I Street Garage And Land Acquisition 239 WR Replacement 201931 WRP Primary & Secondary Treatment Improvements 239 WR Replacement 202003 Annual Sewer Replacement 2020 239 WR Replacement 202116 Railroad Ave Street Improvements 239 WR Replacement 202128 WRP UV Treatment System Replacement 239 WR Replacement 202129 WRP Scada Server & Network Upgrade 239 WR Replacement 202218 W RP Scada PLC Controls Upgrade 239 WR Replacement 239 Total
201519 W RP Hv ac And Roofing Repairs 241 Sewer Connection Fees 201522 WRP Emergency Generator 241 Sewer Connection Fees 201931 WRP Primary & Secondary Treatment Improvements 241 Sewer Connection Fees 201960 Trevarno Infrastructure 241 Sewer Connection Fees 202003 Annual Sewer Replacement 2020 241 Sewer Connection Fees 202128 WRP UV Treatment System Replacement 241 Sewer Connection Fees 202129 WRP Scada Server & Network Upgrade 241 Sewer Connection Fees 202218 W RP Scada Plc Controls Upgrade 241 Sewer Connection Fees 241 Total
50 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY FUND
45 FINANCIAL PLAN UPDATE FY 2021-23
FY 2021-22
Existing
Budget
FY 2021-22
Proposed
Budget
FY 2021-22
Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget
FY 2022-23
Change
887,000$ 887,000$ -$ -$ -$ -$ 250,000 40,000 (210,000) 1,020,000 1,100,000 80,000 - 75,000 75,000 - 102,000 102,000 11,940,000 12,575,000 635,000 - 25,000 25,000 - - - - 300,000 300,000 310,000 - (310,000) 70,000 370,000 300,000 820,000 - (820,000) - - - 14,207,000$ 13,577,000$ (630,000)$ 1,090,000$ 1,897,000$ 807,000$ -$ -$ -$ 19,000$ 19,000$ -$ 30,000 30,000 - 30,000 30,000 - 20,000 30,000 10,000 100,000 20,000 (80,000) 30,000 30,000 - 30,000 30,000 - 445,000 375,000 (70,000) - - - 330,000 100,000 (230,000) 935,350 1,165,350 230,000 - - - 155,000 155,000 - 855,000$ 565,000$ (290,000)$ 1,269,350$ 1,419,350$ 150,000$ 430,000$ -$ (430,000)$ 8,145,000$ 8,575,000$ 430,000$ 430,000$ -$ (430,000)$ 8,145,000$ 8,575,000$ 430,000$ 30,000$ 35,000$ 5,000$ 30,000$ 30,000$ -$ 50,000 35,000 (15,000) - 45,000 45,000 80,000$ 70,000$ (10,000)$ 30,000$ 75,000$ 45,000$ 460,000$ 45,000$ (415,000)$ 410,000$ 115,000$ (295,000)$ 140,000 - (140,000) 60,000 200,000 140,000 157,635 145,000 (12,635) 400,000 87,635 (312,365) 40,000 40,000 - 100,000 60,000 (40,000) 797,635$ 230,000$ (567,635)$ 970,000$ 462,635$ (507,365)$ 100,000$ 12,000$ (88,000)$ 2,000,000$ 12,000$ (1,988,000)$ 1,461,000 767,000 (694,000) 3,079,000 1,969,000 (1,110,000) 34,000 151,000 117,000 - 274,000 274,000 450,000 450,000 - - - - 900,000 825,000 (75,000) 7,910,000 12,915,000 5,005,000 521,000 265,000 (256,000) 2,789,000 2,605,000 (184,000) - - - - 115,000 115,000 175,000 2,000 (173,000) 1,287,000 363,000 (924,000) 153,000 125,000 (28,000) 1,386,000 407,000 (979,000) - - - 196,000 - (196,000) 3,794,000$ 2,597,000$ (1,197,000)$ 18,647,000$ 18,660,000$ 13,000$ 102,000$ 54,000$ (48,000)$ -$ -$ -$ 12,000 52,000 40,000 - 94,000 94,000 300,000 275,000 (25,000) 2,640,000 4,305,000 1,665,000 215,000 50,000 (165,000) 540,000 700,000 160,000 179,000 91,000 (88,000) 956,000 893,000 (63,000) 60,000 1,000 (59,000) 441,000 124,000 (317,000) 53,000 43,000 (10,000) 475,000 139,000 (336,000) - - - 67,000 - (67,000) 921,000$ 566,000$ (355,000)$ 5,119,000$ 6,255,000$ 1,136,000$ 51 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY FUND
46 FINANCIAL PLAN UPDATE FY 2021-23
Project Project Name Fund Fund Name
201960 Trevarno Infrastructure 251 Water Connection Fees 251 Total
202130 Airway Lift Station Improvements 259 Water Replacement 259 Total
199838 Las Positas Rd Widening - Hilliker To First 306 Traffic Impact Fee (TIF) 200259 North Canyons Pkwy/Dublin Blv d Connection 306 Traffic Impact Fee (TIF) 200720 El Charro Specific Plan Infrastructure 306 Traffic Impact Fee (TIF) 201028 Foley Road Realignment 306 Traffic Impact Fee (TIF) 201431 Traffic Signal Installation Program 306 Traffic Impact Fee (TIF) 201837 Vasco Road W idening 306 Traffic Impact Fee (TIF) 201937 Intersection Improv ements @ Jack London / Isabel 306 Traffic Impact Fee (TIF) 306 Total
202118 Livermore Village Remediation 320 2022 COP Construction Fund 202119 Livermore Village Joint Trench 320 2022 COP Construction Fund 586003 Livermore Village L Street Garage 320 2022 COP Construction Fund 320 Total
199238 Isabel Ave/I-580 Interchange 321 TVTC 20% Fee
199352 Vasco Road/I-580 Interchange 321 TVTC 20% Fee
321 Total
202032 Multi -Service Center Improvements 333 HHS - HS Facilities Fee 333 Total
201715 I Street Garage And Land Acquisition 335 Parking In Lieu Fee 202120 Downtown Surface Parking 335 Parking In Lieu Fee 335 Total
200429 Doolan Park Landscape Rehabilitation Project 337 Park Fee - AB 1600 200646 Park Facilities Fee Reimbursements 337 Park Fee - AB 1600 201436 Livermorium Park-Plaza At Mills Square 337 Park Fee - AB 1600 201945 Las Colinas Trail (T-6, Segment E1) 337 Park Fee - AB 1600 201955 Arroyo Rd Trail (T-13, Segment B) 337 Park Fee - AB 1600 202118 Livermore Village Remediation 337 Park Fee - AB 1600 202119 Livermore Village Joint Trench 337 Park Fee - AB 1600 202121 Veteran's Park 337 Park Fee - AB 1600
337 Total
200720 El Charro Specific Plan Infrastructure 340 El Charro Infrastructure 340 Total
202101 Street Resurfacing 2021 344 SW &R Impact Fee
202104 Slurry Seal 2021 344 SW &R Impact Fee
202204 Slurry Seal 2022 344 SW &R Impact Fee
202301 Street Resurfacing 2023 344 SW &R Impact Fee
202304 Slurry Seal 2023 344 SW &R Impact Fee
344 Total
200028 Police Facility Expansion 603 LPD - Cops Ahead AB 3229 201958 Real Time Awarness Center 603 LPD - Cops Ahead AB 3229 603 Total
201028 Foley Road Realignment 604 So Liv Val Spec Plan Fee 604 Total
52 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY FUND
47 FINANCIAL PLAN UPDATE FY 2021-23
FY 2021-22
Existing
Budget
FY 2021-22
Proposed
Budget
FY 2021-22
Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget
FY 2022-23
Change
180,000$ 50,000$ (130,000)$ 535,000$ 700,000$ 165,000$ 180,000$ 50,000$ (130,000)$ 535,000$ 700,000$ 165,000$ 290,000$ 213,000$ (77,000)$ 2,121,000$ 242,000$ (1,879,000)$ 290,000$ 213,000$ (77,000)$ 2,121,000$ 242,000$ (1,879,000)$ 169,000$ -$ (169,000)$ 441,000$ 169,000$ (272,000)$ 150,000 50,000 (100,000) 125,000 225,000 100,000 561,309 561,309 - - - - 250,000 - (250,000) 270,000 179,611 (90,389) 50,000 10,000 (40,000) - - - 1,100,000 620,000 (480,000) 1,637,500 2,117,500 480,000 250,000 5,000 (245,000) 1,050,000 225,000 (825,000) 2,530,309$ 1,246,309$ (1,284,000)$ 3,523,500$ 2,916,111$ (607,389)$ 265,000$ 115,000$ (150,000)$ 390,000$ 520,000$ 130,000$ 250,000 - (250,000) - 260,000 260,000 820,000 1,560,000 740,000 34,500,000 15,400,000 (19,100,000) 1,335,000$ 1,675,000$ 340,000$ 34,890,000$ 16,180,000$ (18,710,000)$ 676,000$ 876,000$ 200,000$ 20,000$ 200,000$ 180,000$ 1,585,000 750,000 (835,000) 1,501,250 2,336,250 835,000 2,261,000$ 1,626,000$ (635,000)$ 1,521,250$ 2,536,250$ 1,015,000$ 399,591$ 420,000$ 20,409$ -$ -$ -$ 399,591$ 420,000$ 20,409$ -$ -$ -$ 60,000$ 60,000$ -$ -$ -$ -$ 50,000 12,000 (38,000) 50,000 50,000 - 110,000$ 72,000$ (38,000)$ 50,000$ 50,000$ -$ -$ -$ -$ 240,000$ 240,000$ -$ 2,600,000 2,200,000 (400,000) 1,400,000 500,000 (900,000) 4,195,000 4,000,000 (195,000) - 920,000 920,000 220,000 5,000 (215,000) 1,880,000 8,000 (1,872,000) 20,000 10,000 (10,000) - - - 120,000 135,000 15,000 170,000 150,000 (20,000) 300,000 35,000 (265,000) - 100,000 100,000 450,000 100,000 (350,000) 3,800,000 80,000 (3,720,000) 7,905,000$ 6,485,000$ (1,420,000)$ 7,490,000$ 1,998,000$ (5,492,000)$ 21,468$ -$ (21,468)$ 15,000$ -$ (15,000)$ 21,468$ -$ (21,468)$ 15,000$ -$ (15,000)$ 500,000$ 350,000$ (150,000)$ 3,000,000$ 4,925,000$ 1,925,000$ 200,000 200,000 - - 100,000 100,000 50,000 - (50,000) 100,000 50,000 (50,000) - - - 50,000 - (50,000) - - - 25,000 - (25,000) 750,000$ 550,000$ (200,000)$ 3,175,000$ 5,075,000$ 1,900,000$ -$ -$ -$ -$ 290,000$ 290,000$ 345,000 345,000 - - - - 345,000$ 345,000$ -$ -$ 290,000$ 290,000$ -$ 100,000$ 100,000$ -$ 240,389$ 240,389$ -$ 100,000$ 100,000$ -$ 240,389$ 240,389$ 53 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY FUND
48 FINANCIAL PLAN UPDATE FY 2021-23
Project Project Name Fund Fund Name
201955 Arroyo Rd Trail (T-13, Segment B) 607 State Grant 607 Total
202122 Citywide Sculptures 608 Public Art Fee
608 Total
202118 Livermore Village Remediation 611 Low Income Housing Fund 583018 Livermore Village Infrastructure 611 Low Income Housing Fund 611 Total
200028 Police Facility Expansion 619 Asset Seizure
201722 Automated License Plate Readers 619 Asset Seizure 201958 Real Time Awarness Center 619 Asset Seizure
619 Total
201715 I Street Garage And Land Acquisition 650 Gas Taxes 201721 Bluebell Drive Bridge Repair At Altamont Creek 650 Gas Taxes 201841 Downtown Street Lighting Enhancement 650 Gas Taxes 201846 2018 Arterial Street Rehab Project 650 Gas Taxes 201856 Downtown East Side Public Improv ements 650 Gas Taxes 201933 Traffic Signal Modifications 2019-20 650 Gas Taxes 202001 Street Resurfacing 2020 650 Gas Taxes
202102 Sidewalk Repair 2021 650 Gas Taxes
202104 Slurry Seal 2021 650 Gas Taxes
202107 ADA Access Ramps 2020-21 650 Gas Taxes
202119 Livermore Village Joint Trench 650 Gas Taxes
202131 Miscellaneous Traffic Signing/Striping 2021-2023 650 Gas Taxes 202202 Sidewalk Repair 2022 650 Gas Taxes
202204 Slurry Seal 2022 650 Gas Taxes
202304 Slurry Seal 2023 650 Gas Taxes
583018 Livermore Village Infrastructure 650 Gas Taxes
650 Total
200827 Downtown Streetscape Phase Ii 651 Gas Tax SB-1
201727 Collier Canyon Creek Silt Basin 651 Gas Tax SB-1 201944 Montage Trail Connection To Collier Canyon Rd 651 Gas Tax SB-1 202001 Street Resurfacing 2020 651 Gas Tax SB-1
202028 2020 ATP Bike Lane Improvements 651 Gas Tax SB-1 202104 Slurry Seal 2021 651 Gas Tax SB-1
202116 Railroad Ave Street Improvements 651 Gas Tax SB-1 202133 Stanley Blv d At Isabel Connector Ramp Crossing Improv 651 Gas Tax SB-1 202201 Street Resurfacing 2022 651 Gas Tax SB-1
202204 Slurry Seal 2022 651 Gas Tax SB-1
202222 East Ave Corridor ATP Implementation 651 Gas Tax SB-1 651 Total
200439 New Civic Center Meeting Hall 665 Peg Capital Fees 665 Total
201820 Multi-Use Trails Repairs - 2020 674 MTC - TDA
674 Total
54 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY FUND
49 FINANCIAL PLAN UPDATE FY 2021-23
FY 2021-22
Existing
Budget
FY 2021-22
Proposed
Budget
FY 2021-22
Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget
FY 2022-23
Change
400,000$ 100,000$ (300,000)$ -$ 715,575$ 715,575$ 400,000$ 100,000$ (300,000)$ -$ 715,575$ 715,575$ 125,000$ 125,000$ -$ 125,000$ 125,000$ -$ 125,000$ 125,000$ -$ 125,000$ 125,000$ -$ 205,000$ 470,000$ 265,000$ 300,000$ 355,000$ 55,000$ 65,000 - (65,000) 460,000 - (460,000) 270,000$ 470,000$ 200,000$ 760,000$ 355,000$ (405,000)$ 140,000$ 20,000$ (120,000)$ -$ -$ -$ 55,000 55,000 - - - - 425,000 300,000 (125,000) - 100,000 100,000 620,000$ 375,000$ (245,000)$ -$ 100,000$ 100,000$ 200,000$ 200,000$ -$ -$ -$ -$ 60,000 100,000 40,000 230,000 400,000 170,000 - 8,000 8,000 - - - - 3,000 3,000 - - - 20,000 20,000 - 50,000 10,000 (40,000) - 10,000 10,000 - 670,000 670,000 - - - - 200,000 200,000 - 5,000 5,000 - 2,500,000 2,500,000 100,000 - (100,000) 600,000 1,900,000 1,300,000 - 50,000 50,000 - 300,000 300,000 250,000 35,000 (215,000) - 170,000 170,000 100,000 60,000 (40,000) - 100,000 100,000 - - - - 200,000 200,000 - - - 100,000 50,000 (50,000) - - - 25,000 - (25,000) 70,000 3,600 (66,400) 460,000 5,000 (455,000) 800,000$ 494,600$ (305,400)$ 1,465,000$ 6,505,000$ 5,040,000$ -$ 1,089,425$ 1,089,425$ -$ -$ -$ 150,000 - (150,000) 150,000 150,000 - - 20,000 20,000 - 460,000 460,000 2,312,000 150,000 (2,162,000) - 2,450,000 2,450,000 - 10,000 10,000 - - - 50,000 - (50,000) 210,000 300,000 90,000 - 240,000 240,000 - 350,000 350,000 - 150,000 150,000 - 250,000 250,000 50,000 - (50,000) 500,000 200,000 (300,000) - - - 100,000 50,000 (50,000) - 10,000 10,000 - - - 2,562,000$ 1,669,425$ (892,575)$ 960,000$ 4,210,000$ 3,250,000$ 56,337$ 56,337$ -$ -$ -$ -$ 56,337$ 56,337$ -$ -$ -$ -$ 180,000$ -$ (180,000)$ 50,000$ 230,000$ 180,000$ 180,000$ -$ (180,000)$ 50,000$ 230,000$ 180,000$ 55 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY FUND
50 FINANCIAL PLAN UPDATE FY 2021-23
Project Project Name Fund Fund Name
201723 Arroyo Road Path 677 Measure B-Bike/Pedestrian
201724 Iron Horse Trail Gap Closure Isabel to Murrieta 677 Measure B-Bike/Pedestrian 201820 Multi-Use Trails Repairs - 2020 677 Measure B-Bike/Pedestrian 201955 Arroyo Rd Trail (T-13, Segment B) 677 Measure B-Bike/Pedestrian 202117 Downtown Bike Parking 677 Measure B-Bike/Pedestrian 202222 East Ave Corridor ATP Implementation 677 Measure B-Bike/Pedestrian 677 Total
200827 Downtown Streetscape Phase Ii 678 Measure B-Local St & Rd 201715 I Street Garage And Land Acquisition 678 Measure B-Local St & Rd 201724 Iron Horse Trail Gap Closure Isabel To Murrieta 678 Measure B-Local St & Rd 201727 Collier Canyon Creek Silt Basin 678 Measure B-Local St & Rd 201955 Arroyo Rd Trail (T-13, Segment B) 678 Measure B-Local St & Rd 201959 Downtown Sidewalk And Misc ADA Improv 2019-21 678 Measure B-Local St & Rd 202222 East Ave Corridor ATP Implementation 678 Measure B-Local St & Rd 678 Total
199352 Vasco Road/I-580 Interchange 680 State Street Grants 680 Total
201959 Downtown Sidewalk And Misc ADA Improv 2019-21 681 Local Vehicle Reg Fee 202206 Crosswalk Safety Improvements 2022 681 Local Vehicle Reg Fee 681 Total
201820 Multi-Use Trails Repairs - 2020 687 Measure BB-Bike/Ped 201944 Montage Trail Connection to Collier Canyon Rd 687 Measure BB-Bike/Ped 202001 Street Resurfacing 2020 687 Measure BB-Bike/Ped
202028 2020 ATP Bike Lane Improvements 687 Measure BB-Bike/Ped 687 Total
200827 Downtown Streetscape Phase Ii 688 Measure BB-Local St & Rd 201434 Acquisition of Downtown Paseo 688 Measure BB-Local St & Rd 201820 Multi-Use Trails Repairs - 2020 688 Measure BB-Local St & Rd 202001 Street Resurfacing 2020 688 Measure BB-Local St & Rd 202107 ADA Access Ramps 2020-21 688 Measure BB-Local St & Rd 202116 Railroad Ave Street Improvements 688 Measure BB-Local St & Rd 202133 Stanley Blv d At Isabel Connector Ramp Crossing Improv 688 Measure BB-Local St & Rd 202225 Flag Pole Plaza And Downtown Streetscape Improvemen 688 Measure BB-Local St & Rd 688 Total
201941 Altamont Creek Mitigation 698 Surplus - AD Closeout 202015 Arroyo Las Positas Desilting Through LPGC 698 Surplus - AD Closeout 202035 Granada Channel Pipe Replacement at UPRR 698 Surplus - AD Closeout 202123 2021 Stream Maintenance by Contractors 698 Surplus - AD Closeout 202223 2022 Stream Maintenance by Contractors 698 Surplus - AD Closeout 698 Total
56 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY FUND
51 FINANCIAL PLAN UPDATE FY 2021-23
FY 2021-22
Existing
Budget
FY 2021-22
Proposed
Budget
FY 2021-22
Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget
FY 2022-23
Change
25,000$ 60,000$ 35,000$ -$ 10,000$ 10,000$ 50,000 - (50,000) - - - 200,000 - (200,000) - 150,000 150,000 - - - 400,000 - (400,000) - 5,000 5,000 - - - 50,000 - (50,000) - - - 325,000$ 65,000$ (260,000)$ 400,000$ 160,000$ (240,000)$ 1,700,000$ 810,575$ (889,425)$ -$ -$ -$ 50,000 50,000 - - - - 380,000 430,000 50,000 - - - - 150,000 150,000 - - - - 90,000 90,000 745,000 649,425 (95,575) 464,000 - (464,000) - 500,000 500,000 - - - 500,000 500,000 - 2,594,000$ 1,530,575$ (1,063,425)$ 1,245,000$ 1,649,425$ 404,425$ 640,000$ -$ (640,000)$ 740,000$ 1,380,000$ 640,000$ 640,000$ -$ (640,000)$ 740,000$ 1,380,000$ 640,000$ 1,010,000$ 120,000$ (890,000)$ -$ 1,000,000$ 1,000,000$ - - - 150,000 220,000 70,000 1,010,000$ 120,000$ (890,000)$ 150,000$ 1,220,000$ 1,070,000$ 20,000$ -$ (20,000)$ -$ -$ -$ 200,000 - (200,000) 280,000 - (280,000) 290,000 - ( 290,000) - 800,000 800,000 50,000 - (50,000) - - - 560,000$ -$ (560,000)$ 280,000$ 800,000$ 520,000$ -$ 450,000$ 450,000$ -$ -$ -$ 400,000 - (400,000) - 400,000 400,000 200,000 70,000 (130,000) - 450,000 450,000 797,000 - (797,000) - 1,000,000 1,000,000 342,000 - (342,000) - - - 875,000 - (875,000) - 885,000 885,000 70,000 - (70,000) - - - - - - - 200,000 200,000 2,684,000$ 520,000$ (2,164,000)$ -$ 2,935,000$ 2,935,000$ 50,000$ 3,000$ (47,000)$ 250,000$ 150,000$ (100,000)$ 330,000 45,000 (285,000) 490,000 198,000 (292,000) 580,000 115,000 (465,000) - 340,000 340,000 320,000 190,000 (130,000) - - - - - - 360,000 720,000 360,000 1,280,000$ 353,000$ (927,000)$ 1,100,000$ 1,408,000$ 308,000$ 57 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY FUND
52 FINANCIAL PLAN UPDATE FY 2021-23
Project Project Name F und Fund Name
200911 Fleet Shop Floor Renovation 740 Facilities Rehab Program 201518 Carpet Replacement for City Buildings 740 Facilities Rehab Program 201830 City Hall HVAC & Central Plant Chiller Replacement 740 Facilities Rehab Program 201833 Generator Replacement at Fire Station No. 6 740 Facilities Rehab Program 201930 Fleet Services Fuel Dispenser 740 Facilities Rehab Program 202032 Mult-Service Center Improvements 740 Facilities Rehab Program 202036 COVID Hardening of City Buildings 740 Facilities Rehab Program 202136 City Hall Roof Repairs 740 Facilities Rehab Program 740 Total
Grand Total

58 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY FUND
53 FINANCIAL PLAN UPDATE FY 2021-23
FY 2021-22
Existing
Budget
FY 2021-22
Proposed
Budget
FY 2021-22
Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget
FY 2022-23
Change
135,000$ 80,000$ (55,000)$ -$ -$ -$ 300,000 300,000 - 210,000 210,000 - 2,800,000 290,000 (2,510,000) 2,800,000 2,500,000 (300,000) 110,000 3,385 (106,615) - 120,000 120,000 75,000 12,000 (63,000) - 140,000 140,000 83,024 16,919 (66,105) - - - 60,000 110,000 50,000 - - - 80,000 - (80,000) - 80,000 80,000 3,643,024$ 812,304$ (2,830,720)$ 3,010,000$ 3,050,000$ 40,000$ 54,961,364$ 37,078,550$ (17,882,814)$ 98,876,100$ 92,414,735$ (6,461,365)$ 59 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY PROGRAM
54 FINANCIAL PLAN UPDATE FY 2021-23
Project Project Name Fund Fund Name
Airport Program
201314 Slurry Seal Northside Aprons And Taxi Lanes 210 Airport 201425 Airport Pav ement Maintenance 210 Airport
201615 Airport Water Quality And HMP Basins 210 Airport 201718 Airport Airfield Markings Maintenance 210 Airport 201849 FBO Building Flood Proofing 210 Airport
202017 Airport Geometry Study Improv ements (AIP27) 210 Airport 202017 Airport Geometry Study Improv ements (AIP27) 212 Airport Grant 202019 Airport Rescue And Firefighting Facility 210 Airport Total Airport Program
Downtown Revitalization Program
200827 Downtown Streetscape Phase II 651 Gas Tax - SB1
200827 Downtown Streetscape Phase II 678 Measure B-Local St & Rd 200827 Downtown Streetscape Phase II 688 Measure Bb-Local St & Rd 201434 Acquisition Of Downtown Paseo 688 Measure Bb-Local St & Rd 201436 Liv ermorium Park-Plaza At Mills Square 337 Park Fee - AB 1600 201715 I Street Garage And Land Acquisition 001 General Fund 201715 I Street Garage And Land Acquisition 239 Water Resources Replacement 201715 I Street Garage And Land Acquisition 335 Parking In Lieu Fee 201715 I Street Garage And Land Acquisition 650 Gas Taxes 201715 I Street Garage And Land Acquisition 678 Measure B-Local St & Rd 201841 Downtown Street Lighting Enhancement 650 Gas Taxes 201856 Downtown East Side Public Improv ements 650 Gas Taxes 201959 Downtown Sidewalk And Misc ADA Improv 2019-21 678 Measure B-Local St & Rd 201959 Downtown Sidewalk And Misc ADA Improv 2019-21 681 Local Vehicle Reg Fee 202116 Railroad Av e Street Improv ements 239 Water Resources Replacement 202116 Railroad Av e Street Improv ements 651 Gas Tax - SB1 202116 Railroad Av e Street Improv ements 688 Measure BB-Local St & Rd 202117 Downtown Bike Parking 677 Measure B-Bike/Pedestrian 202118 Liv ermore Village Remediation 320 2022 COP Construction Fund 202118 Liv ermore Village Remediation 337 Park Fee - AB 1600 202118 Liv ermore Village Remediation 611 Low Income Housing Fund 202119 Liv ermore Village Joint Trench 320 2022 COP Construction Fund 202119 Liv ermore Village Joint Trench 337 Park Fee - AB 1600 202119 Liv ermore Village Joint Trench 650 Gas Taxes
202120 Downtown Surface Parking 001 General Fund
202120 Downtown Surface Parking 335 Parking In Lieu Fee 202121 Veteran's Park 337 Park Fee - AB 1600
202225 Flag Pole Plaza & Downtown Streetscape Improv ements 688 Measure BB-Local St & Rd 583018 Liv ermore Village Infrastructure 611 Low Income Housing Fund 583018 Liv ermore Village Infrastructure 650 Gas Taxes
586003 Liv ermore Village L Street Garage 001 General Fund 586003 Liv ermore Village L Street Garage 320 2022 COP Construction Fund Total Downtown Revitalization Program
60 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY PROGRAM
55 FINANCIAL PLAN UPDATE FY 2021-23
FY 2021-22
Existing
Budget
FY 2021-22
Proposed
Budget Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget Change
-$ -$ -$ 19,000$ 19,000$ -$ 30,000 30,000 - 30,000 30,000 - 20,000 30,000 10,000 100,000 20,000 (80,000) 30,000 30,000 - 30,000 30,000 - 445,000 375,000 (70,000) - - - 330,000 100,000 (230,000) 935,350 1,165,350 230,000 430,000 - (430,000) 8,145,000 8,575,000 430,000 - - - 155,000 155,000 - 1,285,000$ 565,000$ (720,000)$ 9,414,350$ 9,994,350$ 580,000$ -$ 1,089,425$ 1,089,425$ -$ -$ -$ 1,700,000 810,575 (889,425) - - - - 450,000 450,000 - - - 400,000 - (400,000) - 400,000 400,000 4,195,000 4,000,000 (195,000) - 920,000 920,000 11,940,000 12,575,000 635,000 - 25,000 25,000 450,000 450,000 - - - - 60,000 60,000 - - - - 200,000 200,000 - - - - 50,000 50,000 - - - - - 8,000 8,000 - - - 20,000 20,000 - 50,000 10,000 (40,000) 464,000 - (464,000) - 500,000 500,000 1,010,000 120,000 (890,000) - 1,000,000 1,000,000 - - - - 115,000 115,000 - 240,000 240,000 - 350,000 350,000 875,000 - (875,000) - 885,000 885,000 - 5,000 5,000 - - - 265,000 115,000 (150,000) 390,000 520,000 130,000 120,000 135,000 15,000 170,000 150,000 (20,000) 205,000 470,000 265,000 300,000 355,000 55,000 250,000 - (250,000) - 260,000 260,000 300,000 35,000 (265,000) - 100,000 100,000 250,000 35,000 (215,000) - 170,000 170,000 310,000 - (310,000) 70,000 370,000 300,000 50,000 12,000 (38,000) 50,000 50,000 - 450,000 100,000 (350,000) 3,800,000 80,000 (3,720,000) - - - - 200,000 200,000 65,000 - (65,000) 460,000 - (460,000) 70,000 3,600 (66,400) 460,000 5,000 (455,000) 820,000 - (820,000) - - - 820,000 1,560,000 740,000 34,500,000 15,400,000 (19,100,000) 25,339,000$ 22,543,600$ (2,795,400)$ 40,250,000$ 21,865,000$ (18,385,000)$ 61 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY PROGRAM
56 FINANCIAL PLAN UPDATE FY 2021-23
Project Project Name Fund Fund Name
Parks and Beautification Program
200429 Doolan Park Landscape Rehabilitation Project 337 Park Fee - AB 1600 200646 Park Facilities Fee Reimbursements 337 Park Fee - AB 1600 200654 Decorativ e Wall Replacement- Citywide 001 General Fund 202122 Citywide Sculptures 608 Public Art Fee
Total Parks and Beautification Program
Public Building Program
200439 New Civ ic Center Meeting Hall 001 General Fund
200439 New Civ ic Center Meeting Hall 665 Peg Capital Fees 200911 Fleet Shop Floor Renov ation 740 Facilities Rehab Program 201518 Carpet Replacement For City Buildings 740 Facilities Rehab Program 201830 City Hall HVAC & Central Plant Chiller Replacement 740 Facilities Rehab Program 201930 Fleet Serv ices Fuel Dispenser 740 Facilities Rehab Program 202032 Mult-Serv ice Center Improv ements 333 HHS - HS Facilities Fee 202032 Mult-Serv ice Center Improv ements 740 Facilities Rehab Program 202036 COVID Hardening Of City Buildings 740 Facilities Rehab Program 202136 City Hall Roof Repairs 740 Facilities Rehab Program Total Public Building Program
Public Safety
200028 Police Facility Expansion 603 LPD - Cops Ahead AB 3229 200028 Police Facility Expansion 619 Asset Seizure
201722 Automated License Plate Readers 619 Asset Seizure 201833 Generator Replacement At Fire Station No. 6 740 Facilities Rehab Program 201958 Real Time Awarness Center 001 General Fund
201958 Real Time Awarness Center 603 LPD - Cops Ahead AB 3229 201958 Real Time Awarness Center 619 Asset Seizure
Total Public Safety
Storm Drain
201726 Permanent Storm Damage Repairs 2018-19 220 Stormwater 201726 Permanent Storm Damage Repairs 2018-19 222 FEMA Storm Reimb 201727 Collier Canyon Creek Silt Basin 222 FEMA Storm Reimb 201727 Collier Canyon Creek Silt Basin 651 Gas Tax - SB1 201727 Collier Canyon Creek Silt Basin 678 Measure B-Local St & Rd 201941 Altamont Creek Mitigation 698 Surplus - AD Closeout 202015 Arroyo Las Positas Desilting Through Lpgc 222 FEMA Storm Reimb 202015 Arroyo Las Positas Desilting Through Lpgc 698 Surplus - AD Closeout 202035 Granada Channel Pipe Replacement At UPRR 698 Surplus - AD Closeout 202123 2021 Stream Maintenance By Contractors 698 Surplus - AD Closeout 202132 Golf Course Damage Repairs 220 Stormwater
202132 Golf Course Damage Repairs 222 FEMA Storm Reimb
202223 2022 Stream Maintenance By Contractors 698 Surplus - AD Closeout Total Storm Drain Program
62 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY PROGRAM
57 FINANCIAL PLAN UPDATE FY 2021-23
FY 2021-22
Existing
B
udget
FY 2021-22
Proposed
B
udget Change
FY 2022-23
Existing
B
udget
FY 2022-23
Proposed
B
udget Change
-$ -$ -$ 240,000$ 240,000$ -$ 2,600,000 2,200,000 (400,000) 1,400,000 500,000 (900,000) 250,000 40,000 (210,000) 1,020,000 1,100,000 80,000 125,000 125,000 - 125,000 125,000 - 2,975,000$ 2,365,000$ (610,000)$ 2,785,000$ 1,965,000$ (820,000)$ 887,000$ 887,000$ -$ -$ -$ -$ 56,337 56,337 - - - - 135,000 80,000 (55,000) - - - 300,000 300,000 - 210,000 210,000 - 2,800,000 290,000 (2,510,000) 2,800,000 2,500,000 (300,000) 75,000 12,000 (63,000) - 140,000 140,000 399,591 420,000 20,409 - - - 83,024 16,919 (66,105) - - - 60,000 110,000 50,000 - - - 80,000 - (80,000) - 80,000 80,000 4,875,952$ 2,172,256$ (2,703,696)$ 3,010,000$ 2,930,000$ (80,000)$ -$ -$ -$ -$ 290,000$ 290,000$ 140,000 20,000 (120,000) - - - 55,000 55,000 - - - - 110,000 3,385 (106,615) - 120,000 120,000 - - - - 300,000 300,000 345,000 345,000 - - - - 425,000 300,000 ( 125,000) - 100,000 100,000 1,075,000$ 723,385$ (351,615)$ -$ 810,000$ 810,000$ 30,000$ 35,000$ 5,000$ 30,000$ 30,000$ -$ 460,000 45,000 (415,000) 410,000 115,000 (295,000) 140,000 - (140,000) 60,000 200,000 140,000 150,000 - (150,000) 150,000 150,000 - - 150,000 150,000 - - - 50,000 3,000 (47,000) 250,000 150,000 (100,000) 157,635 145,000 (12,635) 400,000 87,635 (312,365) 330,000 45,000 (285,000) 490,000 198,000 (292,000) 580,000 115,000 (465,000) - 340,000 340,000 320,000 190,000 (130,000) - - - 50,000 35,000 (15,000) - 45,000 45,000 40,000 40,000 - 100,000 60,000 (40,000) - - - 360,000 720,000 360,000 2,307,635$ 803,000$ (1,504,635)$ 2,250,000$ 2,095,635$ (154,365)$ 63 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY PROGRAM
58 FINANCIAL PLAN UPDATE FY 2021-23
Project Project Name F und Fund Name
Street Maintenance
201721 Bluebell Driv e Bridge Repair At Altamont Creek 650 Gas Taxes 201846 2018 Arterial Street Rehab Project 650 Gas Taxes 202001 Street Resurfacing 2020 650 Gas Taxes
202001 Street Resurfacing 2020 651 Gas Tax - SB1
202001 Street Resurfacing 2020 687 Measure BB-Bike/Ped
202001 Street Resurfacing 2020 688 Measure BB-Local St & Rd 202101 Street Resurfacing 2021 344 SW&R Impact Fee
202102 Sidewalk Repair 2021 650 Gas Taxes
202104 Slurry Seal 2021 344 SW&R Impact Fee
202104 Slurry Seal 2021 650 Gas Taxes
202104 Slurry Seal 2021 651 Gas Tax - SB1
202107 ADA Access Ramps 2020-21 650 Gas Taxes
202107 ADA Access Ramps 2020-21 688 Measure BB-Local St & Rd 202201 Street Resurfacing 2022 651 Gas Tax - SB1
202202 Sidewalk Repair 2022 650 Gas Taxes
202204 Slurry Seal 2022 344 SW&R Impact Fee
202204 Slurry Seal 2022 650 Gas Taxes
202204 Slurry Seal 2022 651 Gas Tax - SB1
202301 Street Resurfacing 2023 344 SW&R Impact Fee
202304 Slurry Seal 2023 344 SW&R Impact Fee
202304 Slurry Seal 2023 650 Gas Taxes
Total Street Maintenance Program
Traffic Control
201431 Traffic Signal Installation Program 306 Traffic Impact Fee (TIF) 201933 Traffic Signal Modifications 2019-20 650 Gas Taxes 202131 Miscellaneous Traffic Signing/Striping 2021-2023 650 Gas Taxes 202133 Stanley Blv d At Isabel Connector Ramp Crossing Improv 651 Gas Tax - SB1 202133 Stanley Blv d At Isabel Connector Ramp Crossing Improv 688 Measure BB-Local St & Rd 202206 Crosswalk Safety Improv ements 2022 681 Local Vehicle Reg Fee Total Traffic Control Program
Trail, Bike, & Misc. Street
201723 Arroyo Road Path 677 Measure B-Bike/Pedestrian
201724 Iron Horse Trail Gap Closure Isabel To Murrieta 677 Measure B-Bike/Pedestrian 201724 Iron Horse Trail Gap Closure Isabel To Murrieta 678 Measure B-Local St & Rd 201820 Multi-Use Trails Repairs - 2020 674 MTC - TDA
201820 Multi-Use Trails Repairs - 2020 677 Measure B-Bike/Pedestrian 201820 Multi-Use Trails Repairs - 2020 687 Measure BB-Bike/Ped 201820 Multi-Use Trails Repairs - 2020 688 Measure BB-Local St & Rd 201944 Montage Trail Connection To Collier Canyon Rd 651 Gas Tax SB1 201944 Montage Trail Connection To Collier Canyon Rd 687 Measure BB-Bike/Ped 201945 Las Colinas Trail (T-6, Segment E1) 337 Park Fee - AB 1600 201955 Arroyo Rd Trail (T-13, Segment B) 337 Park Fee - AB 1600 201955 Arroyo Rd Trail (T-13, Segment B) 607 State Grant 201955 Arroyo Rd Trail (T-13, Segment B) 677 Measure B-Bike/Pedestrian 201955 Arroyo Rd Trail (T-13, Segment B) 678 Measure B-Local St & Rd 64 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY PROGRAM
59 FINANCIAL PLAN UPDATE FY 2021-23
FY 2021-22
Existing
Budget
FY 2021-22
Proposed
Budget Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget Change
60,000$ 100,000$ 40,000$ 230,000$ 400,000$ 170,000$ - 3,000 3,000 - - - - - - - 200,000 200,000 2,312,000 150,000 (2,162,000) - 2,450,000 2,450,000 290,000 - (290,000) - 800,000 800,000 797,000 - (797,000) - 1,000,000 1,000,000 500,000 350,000 (150,000) 3,000,000 4,925,000 1,925,000 - 5,000 5,000 - 2,500,000 2,500,000 200,000 200,000 - - 100,000 100,000 100,000 - (100,000) 600,000 1,900,000 1,300,000 50,000 - (50,000) 210,000 300,000 90,000 - 50,000 50,000 - 300,000 300,000 342,000 - (342,000) - - - 50,000 - (50,000) 500,000 200,000 (300,000) - - - - 200,000 200,000 50,000 - (50,000) 100,000 50,000 (50,000) - - - 100,000 50,000 (50,000) - - - 100,000 50,000 (50,000) - - - 50,000 - (50,000) - - - 25,000 - (25,000) - - - 25,000 - (25,000) 4,751,000$ 858,000$ (3,893,000)$ 4,940,000$ 15,425,000$ 10,485,000$ 50,000$ 10,000$ ( 40,000)$ -$ -$ -$ - 10,000 10,000 - 670,000 670,000 100,000 60,000 (40,000) - 100,000 100,000 - 150,000 150,000 - 250,000 250,000 70,000 - (70,000) - - - - - - 150,000 220,000 70,000 220,000$ 230,000$ 10,000$ 150,000$ 1,240,000$ 1,090,000$ 25,000$ 60,000$ 35,000$ -$ 10,000$ 10,000$ 50,000 - (50,000) - - - 380,000 430,000 50,000 - - - 180,000 - (180,000) 50,000 230,000 180,000 200,000 - (200,000) - 150,000 150,000 20,000 - (20,000) - - - 200,000 70,000 (130,000) - 450,000 450,000 - 20,000 20,000 - 460,000 460,000 200,000 - (200,000) 280,000 - (280,000) 220,000 5,000 (215,000) 1,880,000 8,000 (1,872,000) 20,000 10,000 (10,000) - - - 400,000 100,000 (300,000) - 715,575 715,575 - - - 400,000 - (400,000) - 90,000 90,000 745,000 649,425 (95,575) 65 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY PROGRAM
60 FINANCIAL PLAN UPDATE FY 2021-23
Project Project Name Fund Fund Name
Trail, Bike, & Misc. Street cont.
202028 2020 Atp Bike Lane Improv ements 651 Gas Tax SB1 202028 2020 Atp Bike Lane Improv ements 687 Measure BB-Bike/Ped 202222 East Av e Corridor Atp Implementation 651 Gas Tax SB1 202222 East Av e Corridor Atp Implementation 677 Measure B-Bike/Pedestrian 202222 East Av e Corridor Atp Implementation 678 Measure B-Local St & Rd Total Trail, Bike, & Misc Street Program
Transportation I nfrastructure
199238 Isabel Av e/I-580 Interchange 321 TVTC 20% Fee
199352 Vasco Road/I-580 Interchange 321 TVTC 20% Fee
199352 Vasco Road/I-580 Interchange 680 State Street Grants 199838 Las Positas Rd Widening - Hilliker To First 306 Traffic Impact Fee (TIF) 200259 North Canyons Pkwy/Dublin Blv d Connection 306 Traffic Impact Fee (TIF) 200720 El Charro Specific Plan Infrastructure 001 General Fund 200720 El Charro Specific Plan Infrastructure 306 Traffic Impact Fee (TIF) 200720 El Charro Specific Plan Infrastructure 340 El Charro Infrastructure 201028 Foley Road Realignment 306 Traffic Impact Fee (TIF) 201028 Foley Road Realignment 604 So Liv Val Spec Plan Fee 201837 Vasco Road Widening 306 Traffic Impact Fee (TIF) 201937 Intersection Improv ements @ Jack London / Isabel 306 Traffic Impact Fee (TIF) Total Transportation Infrastructure Program
Wastewater
201414 Springtown Trunkline Replacement 239 Water Resources Replacement 201519 WRP HVAC And Roofing Repairs 239 Water Resources Replacement 201519 WRP HVAC And Roofing Repairs 241 Sewer Connection Fees 201522 WRP Emergency Generator 239 Water Resources Replacement 201522 WRP Emergency Generator 241 Sewer Connection Fees 201931 WRP Primary & Secondary Treatment Improv ements 239 Water Resources Replacement 201931 WRP Primary & Secondary Treatment Improv ements 241 Sewer Connection Fees 201960 Trev arno Infrastructure 241 Sewer Connection Fees 201960 Trev arno Infrastructure 251 Water Connection Fees 202003 Annual Sewer Replacement 2020 239 Water Resources Replacement 202003 Annual Sewer Replacement 2020 241 Sewer Connection Fees 202128 WRP UV Treatment System Replacement 239 Water Resources Replacement 202128 WRP UV Treatment System Replacement 241 Sewer Connection Fees 202129 WRP Scada Serv er & Network Upgrade 239 Water Resources Replacement 202129 WRP Scada Serv er & Network Upgrade 241 Sewer Connection Fees 202218 WRP Scada PLC Controls Upgrade 239 Water Resources Replacement 202218 WRP Scada PLC Controls Upgrade 241 Sewer Connection Fees Total Wastewater Program
Water
202130 Airway Lift Station Improv ements 259 Water Replacement Total Water Program
Grand Total
66 [Type here] [Type here] [Type here]

CAPITAL IMPROVEMENT PROGRAM

PROJECT LISTING BY PROGRAM
61 FINANCIAL PLAN UPDATE FY 2021-23
FY 2021-22
Existing
B
udget
FY 2021-22
Proposed
B
udget Change
FY 2022-23
Existing
B
udget
FY 2022-23
Proposed
B
udget Change
- 10, 000 10,000 - - - 50,000 - (50,000) - - - - 10,000 10,000 - - - 50,000 - (50,000) - - - - - - 500,000 500,000 - 1,995,000$ 805,000$ (1,190,000)$ 3,855,000$ 3,173,000$ (682,000)$ 676,000$ 876,000$ 200,000$ 20,000$ 200,000$ 180,000$ 1,585,000 750,000 (835,000) 1,501,250 2,336,250 835,000 640,000 - (640,000) 740,000 1,380,000 640,000 169,000 - (169,000) 441,000 169,000 (272,000) 150,000 50,000 (100,000) 125,000 225,000 100,000 - 75,000 75,000 - 102,000 102,000 561,309 561,309 - - - - 21,468 - (21,468) 15,000 - (15,000) 250,000 - (250,000) 270,000 179,611 (90,389) - 100,000 100,000 - 240,389 240,389 1,100,000 620,000 (480,000) 1,637,500 2,117,500 480,000 250,000 5,000 (245,000) 1,050,000 225,000 (825,000) 5,402,777$ 3,037,309$ (2,365,468)$ 5,799,750$ 7,174,750$ 1,375,000$ 100,000$ 12,000$ (88,000)$ 2,000,000$ 12,000$ (1,988,000)$ 1,461,000 767,000 (694,000) 3,079,000 1,969,000 (1,110,000) 102,000 54,000 (48,000) - - - 34,000 151,000 117, 000 - 274,000 274,000 12,000 52,000 40,000 - 94,000 94,000 900,000 825,000 (75,000) 7,910,000 12,915,000 5,005,000 300,000 275,000 (25,000) 2,640,000 4,305,000 1,665,000 215,000 50,000 (165,000) 540,000 700,000 160,000 180,000 50,000 (130,000) 535,000 700,000 165,000 521,000 265,000 (256,000) 2,789,000 2,605,000 (184,000) 179,000 91,000 (88,000) 956,000 893,000 (63,000) 175,000 2,000 (173,000) 1,287,000 363,000 (924,000) 60,000 1,000 (59,000) 441,000 124,000 (317,000) 153,000 125,000 (28,000) 1,386,000 407,000 (979,000) 53,000 43,000 (10,000) 475,000 139,000 (336,000) - - - 196,000 - (196,000) - - - 67,000 - (67,000) 4,445,000$ 2,763,000$ (1,682,000)$ 24,301,000$ 25,500,000$ 1,199,000$ 290,000$ 213,000$ (77,000)$ 2,121,000$ 242,000$ (1,879,000)$ 290,000$ 213,000$ (77,000)$ 2,121,000$ 242,000$ (1,879,000)$ 54,961,364$ 37,078,550$ (17,882,814)$ 98,876,100$ 92,414,735$ (6,461,365)$ 67 62
FINANCIAL PLAN UPDATE FY 2021-23

TABLE OF CONTENTS

THIS PAGE INTENTIONALLY LEFT BLANK
68 \[Type here] [Type here] [Type here]

63 FINANCIAL PLAN UPDATE FY 2021-23

STAFF ALLOCATIONS

Staff Allocations
FY 2021-22 & FY 2022-23 Budget Update
69 \[Type here] [Type here] [Type here]

64 FINANCIAL PLAN UPDATE FY 2021-23

STAFF ALLOCATIONS
Actual Actual Projected Projected
Department And Title Positions Positions Positions Positions FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23
Administrative Services
Administrative Services Admin
Administrative Services Director 1.000 1.000 1.000 1.000 Assistant Administrative Services Director
Cyber Security Manager 1.000 1.000 1.000
Administrative Specialist I/II (Flexible Staffing) 1.000 1.000 1.000 1.000 Subtotal 2.000 3.000 3.000 3.000
City Clerk
City Clerk 1.000 1.000 1.000 1.000
Assistant City Clerk 1.000 1.000 1.000 1.000
Deputy City Clerk 1.000 1.000 1.000 1.000
Administrative Technician 1.000 1.000 1.000
Division Clerk 1.000 1.000 1.000
Senior Clerk 1.000
Subtotal 4.000 5.000 5.000 5.000
Finance
Finance Manager 1.000 1.000 1.000 1.000
Assistant Finance Manager 1.000 1.000
Accounting Supervisor 3.000 3.000 3.000 3.000
Management Analyst II 1.000 1.000 1.000 1.000
Administrative Accounting Technician 2.000 2.000 1.000 1.000 Purchasing Specialist 1.000 1.000 1.000 1.000
Accounting Technician 4.000 3.000 3.000 3.000
Senior Account Clerk 2.000 1.000 1.000 1.000
Junior Account Clerk/Account Clerk (Flex Staff) 3.500 3.500 3.500 Account Clerk 2.000
Junior Account Clerk 1.500
Division Clerk 1.000 1.000 1.000
Subtotal 17.500 16.500 16.500 16.500
Human Resources
Human Resources Manager (Conf) 1.000 1.000 1.000 1.000
Human Resources Analyst, Senior (Conf) 1.000 1.000 1.000 1.000 Human Resources Analyst I/II (Conf) (Flex Staff) 2.000 1.000 1.000 1.000 Human Resources Technician 0.750 1.750 1.750 1.750
Human Resources Clerk I/II (Flexible Staffing) 1.000 1.000 1.000 1.000 Subtotal 5.750 5.750 5.750 5.750
Information Technology
Information Technology Manager 1.000 1.000 1.000 1.000
Systems Administrator 1.000 1.000 1.000 1.000
Senior Management Analyst 1.000 1.000
New Class (IT Engineer/Water SCADA) 1.000
GIS Specialist 1.000 1.000 1.000 1.000
Senior Information Technology Technician 2.000 2.000 2.000 2.000 Information Technology Technician 4.000 4.000 2.000 2.000 Administrative Technician 1.000 1.000
Subtotal 9.000 9.000 9.000 10.000
Administrative Services Total 38.250 39.250 39.250 40.250 70 \[Type here] [Type here] [Type here]

65 FINANCIAL PLAN UPDATE FY 2021-23

STAFF ALLOCATIONS
Actual Actual Projected Projected
Department And Title Positions Positions Positions Positions FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23
City Attorney
City Attorney
City Attorney 1.000 1.000 1.000 1.000
Senior Assistant City Attorney 1.000 1.000 1.000 1.000
Assistant City Attorney 2.000 2.000 2.000 2.000
Law Office Supervisor 1.000 1.000 1.000 1.000
Legal Assistant 0.500 0.500 0.500 0.500
Subtotal 5.500 5.500 5.500 5.500
Risk Management
Risk Manager 0.500 0.500 0.500 0.500
Management Analyst II (Conf) 0.500 0.500 0.500 0.500
Administrative Specialist I/II (Flexible Staffing) 0.650 0.650 0.650 0.650 Subtotal 1.650 1.650 1.650 1.650
Workers Compensation
Risk Manager 0.500 0.500 0.500 0.500
Management Analyst II (Conf) 0.500 0.500 0.500 0.500
Administrative Specialist I/II (Flexible Staffing) 0.350 0.350 0.350 0.350 Legal Assistant 0.500 0.500 0.500 0.500
Subtotal 1.850 1.850 1.850 1.850
City Attorney Total 9.000 9.000 9.000 9.000
City Manager
City Manager
City Manager 1.000 1.000 1.000 1.000
Assistant City Manager 1.000 1.000
Deputy City Manager 1.000 1.000
Management Analyst II 2.000 2.000 2.000 2.000
Executive Assistant 1.000 1.000 1.000 1.000
Administrative Specialist I/II (Flexible Staffing) 2.000 2.000 2.000 2.000 City Manager Total 7.000 7.000 7.000 7.000
Community Development Department
Community Development Admin
Community Development Director 1.000 1.000 1.000 1.000
Assistant Community Development Director 0.500 0.800 0.800 0.800 Administrative Assistant 1.000 1.000 1.000 1.000
Typist Clerk 1.000 1.000 1.000 1.000
Subtotal 3.500 3.800 3.800 3.800
Housing & Human Services
Assistant Community Development Director 0.500 0.200 0.200 0.200 Human Services Programs Manager 1.000 1.000 1.000 1.000 Housing Programs Manager 1.000 1.000 1.000 1.000
Management Analyst II 1.000 1.000 1.000 1.000
Management Analyst I 2.000 2.000 2.000 2.000
Administrative Technician 1.000 1.000 1.000 1.000
Division Clerk 1.000 1.000 1.000 1.000
Typist Clerk 1.000 1.000 1.000 1.000
Subtotal 8.500 8.200 8.200 8.200
71 \[Type here] [Type here] [Type here]

66 FINANCIAL PLAN UPDATE FY 2021-23

STAFF ALLOCATIONS
Actual Actual Projected Projected
Department And Title Positions Positions Positions Positions FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23
Engineering Division
City Engineer 1.000 1.000 1.000 1.000
Assistant City Engineer 2.000 2.000 2.000 2.000
Senior Civil Engineer 2.000 2.000 3.000 3.000
Senior Transportation Engineer 1.000 1.000 1.000 1.000
Construction Inspection Manager 1.000 1.000 1.000 1.000 Associate Civil Engineer 6.000 6.000 6.000 6.000
Associate Civil Engineer (Limited Duration) 1.000 1.000 Junior/Junior Civil Engineer/Assistant/
Assistant Civil Engineer (Flexible Staffing) 3.000 3.000 3.000 3.000 Junior/Junior Civil Engineer/Assistant/
Assistant Civil Engineer (Flex Staff) (Limited Dur) 1.000 1.000 Senior/Associate/Assistant Engineering
Technician (Flexible Staffing) 7.000 7.000 7.000 7.000
Engineering Specialist 2.000 2.000 2.000 2.000
Administrative Technician 1.000 1.000 1.000 1.000
Typist Clerk 1.500 1.500 1.500 1.500
Subtotal 29.500 29.500 28.500 28.500
Planning Division
Planning Manager 1.000 1.000 1.000 1.000
Principal Planner 2.000 2.000 2.000 2.000
Senior Planner 1.000 1.000 2.000 2.000
Associate/Assistant Planner (Flexible Staffing) 5.000 5.000 4.000 4.000 Associate/Assistant Planner (Flex) Limited Duration 1.000 1.000 1.000 1.000 Administrative Assistant 1.000 1.000
Administrative Technician 1.000 1.000
Division Clerk 1.000 1.000 1.000 1.000
Subtotal 12.000 12.000 12.000 12.000
Building Division
Building Official 1.000 1.000 1.000 1.000
Permit Center Manager 1.000 1.000 1.000 1.000
Inspection & Neighborhood Preservation Manager 1.000 1.000 1.000 1.000 Plan Check Engineer 1.000 1.000 1.000 1.000
Senior Building Inspector 1.000 1.000 1.000 1.000
Building Inspector I/II/III (Flexible Staffing) 2.000 2.000 2.000 2.000 Building Inspector I/II/III (Flex) Limited Duration 1.000 1.000 1.000 1.000 Neighborhood Preservation Officer 2.000 2.000 2.000 2.000 Permit Technician I/II (Flexible Staffing) 3.000 3.000 3.000 3.000 Division Clerk 1.000 1.000 1.000 1.000
Typist Clerk 1.000 1.000 1.000 1.000
Subtotal 15.000 15.000 15.000 15.000
Community Development Total 68.500 68.500 67.500 67.500 72 \[Type here] [Type here] [Type here]

67 FINANCIAL PLAN UPDATE FY 2021-23

STAFF ALLOCATIONS
Actual Actual Projected Projected
Department And Title Positions Positions Positions Positions FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23
Innovation & Economic Development Department
Innovation & Economic Development Director 1.000 1.000 1.000 1.000 Senior Management Analyst 1.000 1.000 1.000 1.000
Management Analyst II 1.000 1.000 1.000 1.000
Senior Clerk 1.000 1.000 1.000 1.000
Economic Development Total 4.000 4.000 4.000 4.000
Fire
Livermore/Pleasanton Fire Dept
Fire Chief 0.500 0.500 0.500 0.500
Deputy Chief 1.500 1.500 1.500 1.500
Battalion Chief 2.000 2.000 3.000 3.500
Assistant Fire Marshall 0.500 0.500 0.500 0.500
Emergency Preparedness Manager 0.500 0.500 0.500 0.500
Emergency Medical Services (EMS) Manager 0.500 0.500 0.500 0.500 Administrative Manager 0.500 0.500 0.500 0.500
Management Analyst 0.500 0.500 0.500 0.500
Fire Captain 15.000 15.000 15.000 15.000
Fire Engineer 15.000 15.000 15.000 15.000
Firefighter/Paramedic 15.000 15.000 15.000 15.000
Firefighter 6.000 6.000 6.000 6.000
Fire Inspector 1.500 1.500 1.500 1.500
Hazardous Materials Inspector 1.500 1.500 1.500 1.500
Office Manager 0.500 0.500 0.500 0.500
Administrative Assistant 1.000 1.000 1.000 1.000
Office Assistant 0.500 0.500 0.500 0.500
Fire-Livermore/Pleasanton Fire Dept Total 62.500 62.500 63.500 64.000 Library
Library
Library Services Director 1.000 1.000 1.000 1.000
Assistant Library Services Director 1.000 1.000
Supervising Librarian 3.000 3.000 2.000 2.000
Supervising Library Assistant 1.000 1.000 1.000 1.000
Librarian I/Librarian II (Flexible Staffing) 8.500 8.500 9.500 10.000 Library Assistant 7.850 8.350 7.850 7.850
Library Clerk 3.000 2.500 2.000 2.000
Administrative Technician 1.000 1.000 1.000 1.000
Administrative Assistant 1.000 1.000 1.000 1.000
Senior Clerk 1.000 1.000 1.000 1.000
Library Total 27.350 27.350 27.350 27.850
73 \[Type here] [Type here] [Type here]

68 FINANCIAL PLAN UPDATE FY 2021-23

STAFF ALLOCATIONS
Actual Actual Projected Projected
Department And Title Positions Positions Positions Positions FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23
Police
Police
Police Chief 1.000 1.000 1.000 1.000
Police Captain 2.000 2.000 3.000 3.000
Police Lieutenant 5.000 5.000 5.000 5.000
Police Sergeant 14.000 14.000 14.000 14.000
Police Officer 71.000 71.000 71.000 71.000
Police Officer (Special Funded) 2.000 2.000 2.000 2.000 Police Support Services Manager 1.000 1.000 1.000 1.000 Information Technology Coordinator 1.000 1.000 1.000 1.000 Police Media & Community Relations Analyst 1.000 1.000 1.000 Police Facility & Equipment Manager 1.000 1.000 1.000 1.000 Police Business Services Manager 1.000 1.000 1.000 1.000 Crime Analyst 2.000 2.000 2.000 3.000
Crime Prevention Specialist 1.000 1.000 1.000 1.000
Property & Evidence Specialist, Supervising 1.000 1.000 1.000 Police Identification Technician 1.000
Property & Evidence Specialist 2.000 2.000 2.000 2.000
Community Service Specialists 2.500 2.500 2.500 2.000
Community Service Spec. (Limited Duration) 1.000 1.000 1.000 1.000 Animal Control Officer 2.000 2.000 2.000 2.000
Supervising Public Safety Dispatcher 2.000 2.000 2.000 2.000 Senior Public Safety Dispatcher 3.000 3.000 3.000 3.000 Public Safety Dispatcher 14.000 14.000 14.000 14.000
Supervising Police Clerk 1.000 1.000 1.000 1.000
Senior Police Clerk 1.000 1.000 1.000 1.000
Police Clerk 5.000 5.000 5.000 5.000
Administrative Assistant 1.000 1.000 1.000 1.000
Division Clerk 2.000 2.000 2.000 2.000
Subtotal 139.500 140.500 141.500 142.000
Horizons
Youth & Family Services Manager - Clincal (SF) 1.000 1.000 1.000 1.000 Youth & Family Services Manager - Programs (SF) 1.000 1.000 Family Therapist (Special Funded) 1.750 1.750 2.250 2.250 New Class (Crisis Intervention Specialist) 1.000
Youth Services Case Coord (Special Funded) 0.500 0.500
Division Clerk (Special Funded) 1.000
Senior Clerk (Special Funded) 0.750 0.750 0.750 0.750
Subtotal 6.000 5.000 4.000 5.000
Police Total 145.500 145.500 145.500 147.000
Public Works
Public Works Administration
Director of Public Works 1.000 1.000 1.000 1.000
Public Works Manager 1.000 1.000 1.000 1.000
Management Analyst II 1.000 1.000 1.000 1.000
Asset Management Analyst 1.000 1.000 1.000 1.000
Administrative Assistant 1.000 1.000 1.000 1.000
Recycling Specialist 1.000 1.000 1.000 1.000
Subtotal 6.000 6.000 6.000 6.000
74 \[Type here] [Type here] [Type here]

69 FINANCIAL PLAN UPDATE FY 2021-23

STAFF ALLOCATIONS
Actual Actual Projected Projected
Department And Title Positions Positions Positions Positions FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23
Airport
Airport Manager 1.000 1.000 1.000 1.000
Public Works Supervisor 1.000 1.000 1.000 1.000
Senior Airport Service Attendant 1.000 1.000 1.000 1.000 Airport Service Attendant 3.500 3.500 3.500 3.500
Administrative Technician 1.000 1.000 1.000 1.000
Senior Account Clerk 1.000 1.000 1.000 1.000
Subtotal 8.500 8.500 8.500 8.500
Maintenance Services/Streets
Maintenance & Golf Operations Manager 1.000 1.000 1.000 1.000 Public Works Supervisor 1.000 1.000 1.000 1.000
Management Analyst II 1.000 1.000 1.000 1.000
Maintenance Worker III 2.000 1.000 1.000 1.000
Maintenance Worker II 2.000 3.000 3.000 3.000
Maintenance Worker I 4.000 4.000 4.000 4.000
Senior Facilities Maintenance Worker 1.000 1.000 1.000 1.000 Senior Traffic Signal Technician 1.000 1.000 1.000 1.000 Traffic Signal Technician/Trainee (Flex Staffing) 2.000 2.000 2.000 2.000 Senior Clerk 1.000 1.000 1.000 1.000
Typist Clerk 0.500 0.500 0.500 0.500
Subtotal 16.500 16.500 16.500 16.500
Facility Services
Supervising Facilities Maintenance Worker 1.000 1.000 1.000 Senior Facilities Maintenance Worker 1.000
Facilities Maintenance Wrkr I/Trainee (Flex Staff) 2.000 2.000 2.000 2.000 Subtotal 3.000 3.000 3.000 3.000
Landscape Maintenance
Public Works Supervisor 1.000 1.000 1.000 1.000
Landscape Maintenance Specialist 4.000 4.000 4.000 4.000 Supervising Groundskeeper 1.000 1.000 1.000 1.000
Groundskeeper III
Groundskeeper II 5.000 4.000 4.000 4.000
Groundskeeper I 1.000 2.000 2.000 2.000
Subtotal 12.000 12.000 12.000 12.000
Fleet & Equipment Services
Public Works Supervisor 1.000 1.000 1.000 1.000
Parts and Invetory Control Worker 1.000 1.000 1.000 1.000 Senior Mechanic 1.000 1.000 1.000 1.000
Mechanic 4.000 4.000 4.000 4.000
Division Clerk 1.000 1.000 1.000 1.000
Subtotal 8.000 8.000 8.000 8.000
75 \[Type here] [Type here] [Type here]

70 FINANCIAL PLAN UPDATE FY 2021-23

STAFF ALLOCATIONS
Actual Actual Projected Projected
Department And Title Positions Positions Positions Positions FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23
Water Resources
Water Resources Division Manager 1.000 1.000 1.000 1.000 WR Operations Manager 1.000 1.000 1.000 1.000
New Class (Watershed Programs Manager) 1.000
Public Works Supervisor 4.000 4.000 4.000 4.000
Management Analyst II 1.000 1.000 1.000 1.000
WR Communications Representative 1.000 1.000 1.000 1.000 WR Coordinator 3.000 3.000 4.000 4.000
WR Technical Programs Manager 1.000 1.000 1.000 1.000
Electrician 1.000 1.000 1.000 1.000
WR Lab Technician 2.000 2.000 2.500 2.500
WR Instrument Control Technician 3.000 3.000 3.000 3.000 Asset Management Specialist 1.000 1.000 1.000 1.000
WW Collection Systems Worker II/I/Trainee (Flex) 7.000 7.000 7.000 7.000 WR Mechanic I 3.000 3.000 2.000 2.000
WR Mechanic II 2.000 2.000 2.000 2.000
Parts & Inventory Control Worker 1.000 1.000 1.000
WR Operator Trainee/Grade I/Grade II/Grade III 10.000 10.000 10.000 10.000 WR Supervising Operator 2.000 2.000 2.000 2.000
WR Source Control Inspector 3.000 3.000 3.000 3.000
Administrative Technician 1.000 1.000 1.000 1.000
Senior Clerk 1.500 1.500 1.000 1.000
Division Clerk 1.000 1.000 1.000 1.000
Subtotal 49.500 50.500 50.500 51.500
Water
Water Distribution Operations Manager 1.000 1.000 1.000 1.000 Water Distribution Supervising Operator 1.000 1.000 1.000 1.000 Water Distribution Senior Operator 2.000 2.000 1.000 1.000 Water Distribution Operator III 2.000 2.000 1.000 1.000 WD Operator II/I/Trainee (Flex Staffing) 3.000 3.000 5.000 5.000 Administrative Technician 1.000 1.000 1.000 1.000
Senior Clerk 1.000
Subtotal 11.000 10.000 10.000 10.000
Public Works Total 114.500 114.500 114.500 115.500
Total Regular Full And Part-Time
Authorized Positions 476.600 477.600 477.600 482.100
Footnotes:
#1 - Assistant Community Development Director can be filled by any CDD Division Manager - current appointment is by the Housing & Human Services Manager.
76 \[Type here] [Type here] [Type here]

71 FINANCIAL PLAN UPDATE FY 2021-23

APPROPRIATIONS LIMIT

THIS PAGE INTENTIONALLY LEFT BLANK
77 Actual
2020-21
Existing
FY 2021-22
Proposed
FY 2021-22 Difference
Original
FY 2022-23
Proposed
FY 2022-23 Difference
One time
Rev & Exp
FY 2021-22
One time
Rev & Exp
FY 2022-23
Operating Revenue $128,102,944 $122,442,069 $132,648,846 $10,206,777 $123,579,681 $131,605,073 $8,025,392 $7,377,088 $568,658 Use of Unassigned Reserves 17,109,265 12,219,781 (4,889,484) 4,087,452 4,837,805 750,353 Use of ERP Reserves 2,000,000 2,000,000
Transfers In 537,023 4,278,135 705,275 (3,572,860) 2,132,599 852,919 (1,279,680) - - Total Sources $128,639,967 $143,829,469 $145,573,902 $1,744,433 $129,799,732 $139,295,797 $9,496,065 $7,377,088 $568,658 Total Operating Expenditures 109,359,867 121,263,434 121,058,888 (204,546) 118,484,301 127,000,395 8,516,094 7,341,394 8,663,449 Transfers-out 4,189,577 6,759,479 6,294,486 (464,993) 9,182,168 8,218,044 (964,124) - - Capital Improvement Plan 4,367,190 14,207,000 13,577,000 (630,000) 1,090,000 1,897,000 807,000 13,577,000 1,897,000 Contributions to Reserves 5,697,188 1,599,556 4,643,528 3,043,972 1,043,263 2,180,358 1,137,095 - - Total Uses 123,613,822 $143,829,469 $145,573,902 $1,744,433 $129,799,732 $139,295,797 $9,496,065 $20,918,394 $10,560,449 Surplus/(Shortfall) $5,026,145 $0 $0 $0 $0 $0 $0 ($13,541,306) ($9,991,791) General Fund Budget
ATTACHMENT 2
78 Downtown
Revitalization
$44,408,600
34%
Parks &
Beautification
$4,330,000
3%
Public Buildings
$5,102,256
4%
Public Safety
$1,533,385
1%Storm Drain
$2,898,635
2%
Street Maintenance
$16,283,000
13%
Traffic Control
$1,470,000
1%
Trail, Bike & Misc.

Street
$3,978,000
3%
Transportation
Infrastructure
$10,212,059
8%
Airport
$10,559,350
8%
Wastewater
$28,263,000
22%
Water
$455,000
< 1%
Capital Spending By Program Type
ATTACHMENT 3
79 Program name Project Project Name Fund
FY 2021-22
Existing Budget
FY 2021-22
Proposed
Budget Update
Proposed
Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget Update
Proposed
Change
AIRPORT 201314 SLURRY SEAL NORTHSIDE APRONS AND TAXI LANES 210 - - - 19,000 19,000 - AIRPORT 201425 AIRPORT PAVEMENT MAINTENANCE 210 30,000 30,000 - 30,000 30,000 - AIRPORT 201615 AIRPORT WATER QUALITY AND HMP BASINS 210 20,000 30,000 10,000 100,000 20,000 (80,000) AIRPORT 201718 AIRPORT AIRFIELD MARKINGS MAINTENANCE 210 30,000 30,000 - 30,000 30,000 - AIRPORT 201849 FBO BUILDING FLOOD PROOFING 210 445,000 375,000 (70,000) - - - AIRPORT 202017 AIRPORT GEOMETRY STUDY IMPROVEMENTS (AIP27) 210 330,000 100,000 (230,000) 935,350 1,165,350 230,000 AIRPORT 202017 AIRPORT GEOMETRY STUDY IMPROVEMENTS (AIP27) 212 430,000 - (430,000) 8,145,000 8,575,000 430,000 AIRPORT 202019 AIRPORT RESCUE A ND FIREFIGHTING FACILITY 210 - - - 155,000 155,000 - AIRPORT Total 1,285,000 565,000 (720,000) 9,414,350 9,994,350 580,000 DOWNTOWN REVITALIZATION 200827 DOWNTOWN STREETSCAPE PHASE II 651 - 1,089,425 1,089,425 - - - DOWNTOWN REVITALIZATION 200827 DOWNTOWN STREETSCAPE PHASE II 678 1,700,000 810,575 (889,425) - - - DOWNTOWN REVITALIZATION 200827 DOWNTOWN STREETSCAPE PHASE II 688 - 450,000 450,000 - - - DOWN
TOWN REVITALIZATION 201434 ACQUISITION OF DOWNTOWN PASEO 688 400,000 - (400,000) - 400,000 400,000 DOWNTOWN REVITALIZATION 201436 LIVERMORIUM PARK-PLAZA AT MILLS SQUARE 337 4,195,000 4,000,000 (195,000) - 920,000 920,000 DOWNTOWN REVITALIZATION 201715 I STREET GARAGE AND LAND ACQUISITION 001 11,940,000 12,575,000 635,000 - 25,000 25,000 DOWNTOWN REVITALIZATION 201715 I STREET GARAGE AND LAND ACQUISITION 239 450,000 450,000 - - - - DOWNTOWN REVITALIZATION 201715 I STREET GARAGE AND LAND ACQUISITION 335 60,000 60,000 - - - - DOWNTOWN REVITALIZATION 201715 I STREET GARAGE AND LAND ACQUISITION 650 200,000 200,000 - - - - DOWNTOWN REVITALIZATION 201715 I STREET GARAGE AND LAND ACQUISITION 678 50,000 50,000 - - - - DOWNTOWN REVITALIZATION 201841 DOWNTOWN STREET LIGHTING ENHANCEMENT 650 - 8,000 8,000 - - - DOWNTOWN REVITALIZATION 201856 DOWNTOWN EAST SIDE PUBLIC IMPROVEMENTS 650 20,000 20,000 - 50,000 10,000 (40,000) DOWNTOWN REVITALIZATION 201959 DOWNTOWN SIDEWALK AND MISC ADA IMPROV 2019-21 678 464,000 - (464,000) - 500,000 500,000 DOWNTOWN REVITALIZATION 201959 DOWNTOWN SIDEWALK AND MISC ADA IMPROV 2019-21 681 1,010,000 120,000 (890,000) - 1,000,000 1,000,000 DOWNTOWN REVITALIZATION 202116 RAILROAD AVE STREET IMPROVEMENTS 239 - - - - 115,000 115,000 DOWNTOWN REVITALIZATION 202116 RAILROAD AVE STREET IMPROVEMENTS 651 - 240,000 240,000 - 350,000 350,000 DOWNTOWN REVITALIZATION 202116 RAILROAD AVE STREET IMPROVEMENTS 688 875,000 - (875,000) - 885,000 885,000 DOWNTOWN REVITALIZATION 202117 DOWNTOWN BIKE PARKING 677 - 5,000 5,000 - - - DOWN
TOWN REVITALIZATION 202118 LIVERMORE VILLAGE REMEDIATION 320 265,000 115,000 (150,000) 390,000 520,000 130,000 DOWNTOWN REVITALIZATION 202118 LIVERMORE VILLAGE REMEDIATION 337 120,000 135,000 15,000 170,000 150,000 (20,000) DOWNTOWN REVITALIZATION 202118 LIVERMORE VILLAGE REMEDIATION 611 205,000 470,000 265,000 300,000 355,000 55,000 DOWNTOWN REVITALIZATION 202119 LIVERMORE VILLAGE JOINT TRENCH 320 250,000 - (250,000) - 260,000 260,000 DOWNTOWN REVITALIZATION 202119 LIVERMORE VILLAGE JOINT TRENCH 337 300,000 35,000 (265,000) - 100,000 100,000 DOWNTOWN REVITALIZATION 202119 LIVERMORE VILLAGE JOINT TRENCH 650 250,000 35,000 (215,000) - 170,000 170,000 DOWNTOWN REVITALIZATION 202120 DOWNTOWN SURFACE PARKING 001 310,000 - (310,000) 70,000 370,000 300,000 DOWNTOWN REVITALIZATION 202120 DOWNTOWN SURFACE PARKING 335 50,000 12,000 (38,000) 50,000 50,000 - DOWNTOWN REVITALIZATION 202121 VETERAN'S PARK 337 450,000 100,000 (350,000) 3,800,000 80,000 (3,720,000) DOWNTOWN REVITALIZATION 202225 FLAG POLE PLAZA AND DOWNTOWN STREETSCAPE IMPROV 688 - - - - 200,000 200,000 DOWNTOWN REVITALIZATION 583018 LIVERMORE VILLAGE INFRASTRUCTURE 611 65,000 - (65,000) 460,000 - (460,000) DOWNTOWN REVITALIZATION 583018 LIVERMORE VILLAGE INFRASTRUCTURE 650 70,000 3,600 (66,400) 460,000 5,000 (455,000) DOWNTOWN REVITALIZATION 586003 LIVERMORE VILLAGE L STREET GARAGE 001 820,000 - (820,000) - - - DOWNTOWN REVITALIZATION 586003 LIVERMORE VILLAGE L STREET GARAGE 320 820,000 1,560,000 740,000 34,500,000 15,400,000 (19,100,000) D
OWNTOWN REVITALIZATION Total 25,339,000 22,543,600 (2,795,400) 40,250,000 21,865,000 (18,385,000) PARKS AND BEAUTIFICATION 200429 DOOLAN PARK LA NDSCAPE REHABILITATION PROJECT 337 - - - 240,000 240,000 - PARKS AND BEAUTIFICATION 200646 PARK FACILITIES FEE REIMBURSEMENTS 337 2,600,000 2,200,000 (400,000) 1,400,000 500,000 (900,000) PARKS AND BEAUTIFICATION 200654 DECORATIVE WALL REPLACEMENT- CITYWIDE 001 250,000 40,000 (210,000) 1,020,000 1,100,000 80,000 PARKS AND BEAUTIFICATION 202122 CITYWIDE SCULPTURES 608 125,000 125,000 - 125,000 125,000 - PARKS AND BEAUTIFICATION Total 2,975,000 2,365,000 (610,000) 2,785,000 1,965,000 (820,000) PUBLIC BUILDING 200439 NEW CIVIC CENTER MEETING HALL 001 887,000 887,000 - - - - PUBLIC BUILDING 200439 NEW CIVIC CENTER MEETING HALL 665 56,337 56,337 - - - - PUBLIC BUILDING 200911 FLEET SHOP FLOOR RENOVATION 740 135,000 80,000 (55,000) - - - PUBLIC BUILDING 201518 CARPET REPLACEMENT FOR CITY BUILDINGS 740 300,000 300,000 - 210,000 210,000 - PUBLIC BUILDING 201830 CITY HALL HVAC & CE NTRAL PLANT CHILLER REPLACEMENT 740 2,800,000 290,000 (2,510,000) 2,800,000 2,500,000 (300,000) PUBLIC BUILDING 201930 FLEET SERVICES FUEL DISPENSER 740 75,000 12,000 (63,000) - 140,000 140,000 PUBLIC BUILDING 202032 MULT-SERVICE CENTER IMPROVEMENTS 333 399,591 420,000 20,409 - - - PUBLIC BUILDING 202032 M ULT-SERVICE CENTER IMPROVEMENTS 740 83,024 16,919 (66,105) - - - PUBLIC BUILDING 202036 COVID HARDENING OF CITY BUILDINGS 740 60,000 110,000 50,000 - - - PUBLIC BUILDING 202136 CITY HALL ROOF REPAIRS 740 80,000 - (80,000) - 80,000 80,000 PUBLIC BUILDING Total 4,875,952 2,172,256 (2,703,696) 3,010,000 2,930,000 (80,000) Capital Improvement Plan
Project by Program
FY 2021-23 Budget Update
ATTACHMENT 4
80 Program name Project Project Name Fund
FY 2021-22
Existing Budget
FY 2021-22
Proposed
Budget Update
Proposed
Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget Update
Proposed
Change
Capital Improvement Plan
Project by Program
FY 2021-23 Budget Update
PUBLIC SAFETY 200028 POLICE FACILITY EXPANSION 603 - - - - 290,000 290,000 PUBLIC SAFETY 200028 POLICE FACILITY EXPANSION 619 140,000 20,000 (120,000) - - - PUBLIC SAFETY 201722 AUTOMATED LI CENSE PLATE READERS 619 55,000 55,000 - - - - PUBLIC SAFETY 201833 GENERATOR REPLACEM ENT AT FIRE STATION NO. 6 740 110,000 3,385 (106,615) - 120,000 120,000 PUBLIC SAFETY 201958 REAL TIME AWARNESS CENTER 001 - - - - 300,000 300,000 PUBLIC SAFETY 201958 REAL TIME AWARNESS CENTER 603 345,000 345,000 - - - - PUBLIC SAFETY 201958 REAL TIME AWARNESS CENTER 619 425,000 300,000 (125,000) - 100,000 100,000 PUBLIC SAFETY Total 1,075,000 723,385 (351,615) - 810,000 810,000 STORM DRAIN 201726 PERMANENT STORM DAMAGE REPAIRS 2018-19 220 30,000 35,000 5,000 30,000 30,000 - STORM DRAIN 201726 PERMANENT STORM DAMAGE REPAIRS 2018-19 222 460,000 45,000 (415,000) 410,000 115,000 (295,000) STORM DRAIN 201727 COLLIER CANYON CREEK SILT BASIN 222 140,000 - (140,000) 60,000 200,000 140,000 STORM DRAIN 201727 COLLIER CANYON CREEK SILT BASIN 651 150,000 - (150,000) 150,000 150,000 - STORM DRAIN 201727 COLLIER CANYON CREEK SILT BASIN 678 - 150,000 150,000 - - - STORM DRAIN 201941 ALTAMONT CREEK MITIGATION 698 50,000 3,000 (47,000) 250,000 150,000 (100,000) STORM DRAIN 202015 ARROYO LAS POSITAS DESILTING THROUGH LPGC 222 157,635 145,000 (12,635) 400,000 87,635 (312,365) STORM DRAIN 202015 ARROYO LAS POSITAS DESILTING THROUGH LPGC 698 330,000 45,000 (285,000) 490,000 198,000 (292,000) STORM DRAIN 202035 GRANADA CHANNEL PI PE REPLACEMENT AT UPRR 698 580,000 115,000 (465,000) - 340,000 340,000 STORM DRAIN 202123 2021 STREAM MAINTENANCE BY CONTRACTORS 698 320,000 190,000 (130,000) - - - STORM DRAIN 202132 GOLF COURSE DAMAGE REPAIRS 220 50,000 35,000 (15,000) - 45,000 45,000 STORM DRAIN 202132 GOLF COURSE DAMAGE REPAIRS 222 40,000 40,000 - 100,000 60,000 (40,000) STORM DRAIN 202223 2022 STREAM MAINTENANCE BY CONTRACTORS 698 - - - 360,000 720,000 360,000 STORM DRAIN Total 2,307,635 803,000 (1,504,635) 2,250,000 2,095,635 (154,365) STREET MAINTENANCE 201721 BLUEBELL DRIVE BRIDGE REPAIR AT ALTAMONT CREEK 650 60,000 100,000 40,000 230,000 400,000 170,000 STREET MAINTENANCE 201846 2018 ARTERIAL STREET REHAB PROJECT 650 - 3,000 3,000 - - - STREET MAINTENANCE 202001 STR EET RESURFACING 2020 650 - - - - 200,000 200,000 STREET MAINTENANCE 202001 STREET RESURFACING 2020 651 2,312,000 150,000 (2,162,000) - 2,450,000 2,450,000 STREET MAINTENANCE 202001 STR EET RESURFACING 2020 687 290,000 - (290,000) - 800,000 800,000 STREET MAINTENANCE 202001 STR EET RESURFACING 2020 688 797,000 - (797,000) - 1,000,000 1,000,000 STREET MAINTENANCE 202101 STR EET RESURFACING 2021 344 500,000 350,000 (150,000) 3,000,000 4,925,000 1,925,000 STREET MAINTENANCE 202102 SIDEWALK REPAIR 2021 650 - 5,000 5,000 - 2,500,000 2,500,000 STREET MAINTENANCE 202104 SLURRY SEAL 2021 344 200,000 200,000 - - 100,000 100,000 STREET MAINTENANCE 202104 SLURRY SEAL 2021 650 100,000 - (100,000) 600,000 1,900,000 1,300,000 STREET MAINTENANCE 202104 SLURRY SEAL 2021 651 50,000 - (50,000) 210,000 300,000 90,000 STREET MAINTENANCE 202107 ADA ACCESS RAMPS 2020-21 650 - 50,000 50,000 - 300,000 300,000 STREET MAINTENANCE 202107 ADA ACCESS RAMPS 2020-21 688 342,000 - (342,000) - - - STREET MAINTENANCE 202201 STR EET RESURFACING 2022 651 50,000 - (50,000) 500,000 200,000 (300,000) STREET MAINTENANCE 202202 SIDEWALK REPAIR 2022 650 - - - - 200,000 200,000 STREET MAINTENANCE 202204 SLURRY SEAL 2022 344 50,000 - (50,000) 100,000 50,000 (50,000) STREET MAINTENANCE 202204 SLURRY SEAL 2022 650 - - - 100,000 50,000 (50,000) STREET MAINTENANCE 202204 SLURRY SEAL 2022 651 - - - 100,000 50,000 (50,000) STREET MAINTENANCE 202301 STR EET RESURFACING 2023 344 - - - 50,000 - (50,000) STREET MAINTENANCE 202304 SLURRY SEAL 2023 344 - - - 25,000 - (25,000) STREET MAINTENANCE 202304 SLURRY SEAL 2023 650 - - - 25,000 - (25,000) STREET MAINTENANCE Total 4,751,000 858,000 (3,893,000) 4,940,000 15,425,000 10,485,000 TRAFFIC CONTROL 201431 TRAFFIC SIGNAL INSTALLATION PROGRAM 306 50,000 10,000 (40,000) - - - TRAFFIC CONTROL 201933 TRAFFIC SIGNAL MODIFICATIONS 2019-20 650 - 10,000 10,000 - 670,000 670,000 TRAFFIC CONTROL 202131 MISCELLANEOUS TRAFFIC SIGNING/STRIPING 2021-2023 650 100,000 60,000 (40,000) - 100,000 100,000 TRAFFIC CONTROL 202133 STANLEY BLVD AT ISABEL CONNECTOR RAMP CROSSING IMPROV 651 - 150,000 150,000 - 250,000 250,000 TRAFFIC CONTROL 202133 STANLEY BLVD AT ISABEL CONNECTOR RAMP CROSSING IMPROV 688 70,000 - (70,000) - - - TRAFFIC CONTROL 202206 CROSSWALK SAFETY IMPROVEMENTS 2022 681 - - - 150,000 220,000 70,000 TRAFFIC CONTROL Total 220,000 230,000 10,000 150,000 1,240,000 1,090,000 TRAIL BIKE & MISCELLANEOUS STREET 201723 ARROYO ROAD PATH 677 25,000 60,000 35,000 - 10,000 10,000 TRAIL BIKE & MISCELLANEOUS STREET 201724 IRON HOR SE TRAIL GAP CLOSURE ISABEL TO MURRIETA 677 50,000 - (50,000) - - - TRAIL BIKE & MISCELLANEOUS STREET 201724 IRON HOR SE TRAIL GAP CLOSURE ISABEL TO MURRIETA 678 380,000 430,000 50,000 - - - TRAIL BIKE & MISCELLANEOUS STREET 201820 MULTI-USE TRAILS REPAIRS - 2020 674 180,000 - (180,000) 50,000 230,000 180,000 T
RAIL BIKE & MISCELLANEOUS STREET 201820 MULTI-USE TRAILS REPAIRS - 2020 677 200,000 - (200,000) - 150,000 150,000 TRAIL BIKE & MISCELLANEOUS STREET 201820 MULTI-USE TRAILS REPAIRS - 2020 687 20,000 - (20,000) - - - TRAIL BIKE & MISCELLANEOUS STREET 201820 MULTI-USE TRAILS REPAIRS - 2020 688 200,000 70,000 (130,000) - 450,000 450,000 ATTACHMENT 4
81 Program name Project Project Name Fund
FY 2021-22
Existing Budget
FY 2021-22
Proposed
Budget Update
Proposed
Change
FY 2022-23
Existing
Budget
FY 2022-23
Proposed
Budget Update
Proposed
Change
Capital Improvement Plan
Project by Program
FY 2021-23 Budget Update
TRAIL BIKE & MISCELLANEOUS STREET 201944 MONTAGE TRAIL CONNECTION TO COLLIER CANYON RD 651 - 20,000 20,000 - 460,000 460,000 TRAIL BIKE & MISCELLANEOUS STREET 201944 MONTAGE TR AIL CONNECTION TO COLLIER CANYON RD 687 200,000 - (200,000) 280,000 - (280,000) TRAIL BIKE & MISCELLANEOUS STREET 201945 LAS COLINAS TRAIL (T-6, SEGMENT E1) 337 220,000 5,000 (215,000) 1,880,000 8,000 (1,872,000) TRAIL BIKE & MISCELLANEOUS STREET 201955 ARRO YO RD TRAIL (T-13, SEGMENT B) 337 20,000 10,000 (10,000) - - - TRAIL BIKE & MISCELLANEOUS STREET 201955 ARRO YO RD TRAIL (T-13, SEGMENT B) 607 400,000 100,000 (300,000) - 715,575 715,575 TRAIL BIKE & MISCELLANEOUS STREET 201955 A RROYO RD TRAIL (T-13, SEGMENT B) 677 - - - 400,000 - (400,000) TRAIL BIKE & MISCELLANEOUS STREET 201955 A RROYO RD TRAIL (T-13, SEGMENT B) 678 - 90,000 90,000 745,000 649,425 (95,575) TRAIL BIKE & MISCELLANEOUS STREET 202028 2020 ATP BIKE LANE IMPROVEMENTS 651 - 10,000 10,000 - - - TRAIL BIKE & MISCELLANEOUS STREET 202028 2020 ATP BIKE LANE IMPROVEMENTS 687 50,000 - (50,000) - - - TRAIL BIKE & MISCELLANEOUS STREET 202222 EAST AVE CORRIDOR ATP IMPLEMENTATION 651 - 10,000 10,000 - - - TRAIL BIKE & MISCELLANEOUS STREET 202222 EAST AVE CORRIDOR ATP IMPLEMENTATION 677 50,000 - (50,000) - - - TRAIL BIKE & MISCELLANEOUS STREET 202222 EAST AVE CORRIDOR ATP IMPLEMENTATION 678 - - - 500,000 500,000 - TRAIL BIKE & MISCELLANEOUS STREET Total 1,995,000 805,000 (1,190,000) 3,855,000 3,173,000 (682,000) TRANSPORTATION INFRASTRUCTURE 199238 I SABEL AVE/I- 580 INTERCHANGE 321 676,000 876,000 200,000 20,000 200,000 180,000 TRANSPORTATION INFRASTRUCTURE 199352 VASC O ROAD/I-580 INTERCHANGE 321 1,585,000 750,000 (835,000) 1,501,250 2,336,250 835,000 TRANSPORTATION INFRASTRUCTURE 199352 VASC O ROAD/I-580 INTERCHANGE 680 640,000 - (640,000) 740,000 1,380,000 640,000 TRANSPORTATION INFRASTRUCTURE 199838 LAS POSITAS RD WIDENING - HILLIKER TO FIRST 306 169,000 - (169,000) 441,000 169,000 (272,000) TRANSPORTATION INFRASTRUCTURE 200259 NORTH CANYONS PKWY/DUBLI N BLVD CONNECTION 306 150,000 50,000 (100,000) 125,000 225,000 100,000 TRANSPORTATION INFRASTRUCTURE 200720 EL CHARRO SPECIFIC PLAN INFRASTRUCTURE 001 - 75,000 75,000 - 102,000 102,000 TRANSPORTATION INFRASTRUCTURE 200720 EL CHARRO SPECIFIC PLAN INFRASTRUCTURE 306 561,309 561,309 - - - - TRANSPORTATION INFRASTRUCTURE 200720 EL CHARRO SPECIFIC PLAN INFRASTRUCTURE 340 21,468 - (21,468) 15,000 - (15,000) TRANSPORTATION INFRASTRUCTURE 201028 FOLEY ROAD REALIGNMENT 306 250,000 - (250,000) 270,000 179,611 (90,389) TRANSPORTATION INFRASTRUCTURE 201028 FOLEY ROAD REALIGNMENT 604 - 100,000 100,000 - 240,389 240,389 TRANSPORTATION INFRASTRUCTURE 201837 VASCO ROAD WIDENING 306 1,100,000 620,000 (480,000) 1,637,500 2,117,500 480,000 TRANSPORTATION INFRASTRUCTURE 201937 INTERSECTION IMPROVEMENTS @ JACK LONDON / ISABEL 306 250,000 5,000 (245,000) 1,050,000 225,000 (825,000) TRANSPORTATION INFRASTRUCTURE Total 5,402,777 3,037,309 (2,365,468) 5,799,750 7,174,750 1,375,000 WASTEWATER 201414 SPRINGTOWN TRUNK LINE REPLACEMENT 239 100,000 12,000 (88,000) 2,000,000 12,000 (1,988,000) WASTEWATER 201519 WRP HVAC AND ROOFING REPAIRS 239 1,461,000 767,000 (694,000) 3,079,000 1,969,000 (1,110,000) WASTEWATER 201519 WRP HVAC AND ROOFING REPAIRS 241 102,000 54,000 (48,000) - - - WASTEWATER 201522 WRP EMERGENCY GENERATOR 239 34,000 151,000 117,000 - 274,000 274,000 WASTEWATER 201522 WRP EMERGENCY GENERATOR 241 12,000 52,000 40,000 - 94,000 94,000 WASTEWATER 201931 WRP PRIMARY & SECONDA RY TREATMENT IMPROVEMENTS 239 900,000 825,000 (75,000) 7,910,000 12,915,000 5,005,000 WASTEWATER 201931 WRP PRIMARY & SECONDA RY TREATMENT IMPROVEMENTS 241 300,000 275,000 (25,000) 2,640,000 4,305,000 1,665,000 WASTEWATER 201960 TREVARNO INFRASTRUCTURE 241 215,000 50,000 (165,000) 540,000 700,000 160,000 WASTEWATER 201960 TREVARNO INFRASTRUCTURE 251 180,000 50,000 (130,000) 535,000 700,000 165,000 WASTEWATER 202003 ANNUAL SEWER REPLACEMENT 2020 239 521,000 265,000 (256,000) 2,789,000 2,605,000 (184,000) WASTEWATER 202003 ANNUAL SEWER REPLACEMENT 2020 241 179,000 91,000 (88,000) 956,000 893,000 (63,000) WASTEWATER 202128 WRP UV TREATMENT SYSTEM REPLACEMENT 239 175,000 2,000 (173,000) 1,287,000 363,000 (924,000) WASTEWATER 202128 WRP UV TREATMENT SYSTEM REPLACEMENT 241 60,000 1,000 (59,000) 441,000 124,000 (317,000) WASTEWATER 202129 WRP SCADA SERVER & NETWORK UPGRADE 239 153,000 125,000 (28,000) 1,386,000 407,000 (979,000) WASTEWATER 202129 WRP SCADA SERVER & NETWORK UPGRADE 241 53,000 43,000 (10,000) 475,000 139,000 (336,000) WASTEWATER 202218 WRP SCADA PLC CONTROLS UPGRADE 239 - - - 196,000 - (196,000) WASTEWATER 202218 WRP SCADA PLC CONTROLS UPGRADE 241 - - - 67,000 - (67,000) WASTEWATER Total 4,445,000 2,763,000 (1,682,000) 24,301,000 25,500,000 1,199,000 WATER 202130 AIRWAY LIFT STATION IMPROVEMENTS 259 290,000 213,000 (77,000) 2,121,000 242,000 (1,879,000) WATER Total 290,000 213,000 (77,000) 2,121,000 242,000 (1,879,000) Grand Total 54,961,364 37,078,550 (17,882,814) 98,876,100 92,414,735 (6,461,365) ATTACHMENT 4
82 CITY COUNCIL STAFF REPORT
ITEM NO. 5.1

DATE:

May 16, 2022
TO:

Honorable Mayor and City Council
FROM:

Tina Olson, Administrative Services Director
SUBJECT:

Supplemental materials received prior to the meeting.

RECOMMENDED ACTION

SUMMARY
These materials were posted online and made available to the public at the same time that they were distributed to the City Council.

3.1 Proposed Fiscal Year 2021-23 Financial Plan Update

Material: PowerPoint Presentation

DISCUSSION

ATTACHMENTS

1. Supplemental Materials

Prepared by: Debbie Elam
Deputy City Clerk

Approved by:
____________________________________
Marc Roberts
City Manager
Fiscal Review by:
____________________________________
Tina Olson
Administrative Services Director
83 1

PROPOSED

FINANCIAL
PLAN
FY 2021-22 and FY 2022-23
City Council Budget Workshop
May 16, 2022
1 FY 2021-23 General Fund Budget Overview
General Fund Budget
Existing
FY 2021-22
Proposed
FY 2021-22 Difference
Original
FY 2022-23
Proposed
FY 2022-23 Difference
One time
Rev & Exp
FY 2021-22
One time
Rev & Exp
FY 2022-23
Operating Revenue $122,442,069 $132,648,846 $10,206,777 $123,579,681 $131,605,073 $8,025,392 $7,377,088 $568,658 Use of Unassigned Reserves 17,023,105 12,219,781 (4,803,324) 4,088,052 4,837,805 749,753 Use of ERP Reserves 2,000,000 2,000,000
Transfers In 4,278,135 705,275 (3,572,860) 2,132,599 852,919 (1,279,680) - - Total Sources $143,743,309 $145,573,902 $1,830,593 $129,800,332 $139,295,797 $9,495,465 $7,377,088 $568,658 Total Operating Expenditures 121,177,274 121,058,888 (118,386) 118,484,901 127,000,395 8,515,494 7,341,394 8,663,449 Transfers-out 6,759,479 6,294,486 (464,993) 9,182,168 8,218,044 (964,124) -- Capital Improvement Plan 14,207,000 13,577,000 (630,000) 1,090,000 1,897,000 807,000 13,577,000 1,897,000 Contributions to Reserves 1,599,556 4,643,528 3,043,972 1,043,263 2,180,358 1,137,095 - - Total Uses $143,743,309 $145,573,902 $1,830,593 $129,800,332 $139,295,797 $9,495,465 $20,918,394 $10,560,449 Surplus/(Shortfall) $0 $0 $0 $0 $0 $0 ($13,541,306) ($9,991,791) 2 1
2 Item 3.1
PowerPoint Presentation
84 2
FY 2021-23 General Fund Budget Overview – Revenues
General Fund FY 2020-21
Actual
FY 2021-22
Existing
FY 2021-22
Proposed
FY 2021-22
Change
FY 2022-23
Existing
FY 2022-23
Proposed
FY 2022-23
Change
Property Taxes $38,874,958 $41,401,520 $40,464,176 $(937,344) $42,953,530 $43,011,015 $57,485 Sales & Use Taxes 35,441,550 34,094,000 37,550,000 3,456,000 36,500,000 39,047,000 2,547,000 Franchise Taxes 5,686,312 5,185,281 5,827,371 642,090 5,222,356 6,043,000 820,644 Business License Taxes 6,804,846 5,906,285 7,370,000 1,463,715 6,101,374 7,672,000 1,570,626 Other Taxes 3,651,054 4,250,000 5,862,930 1,612,930 5,550,000 6,850,800 1,300,800 Licenses & Permits 2,587,449 2,596,220 3,315,100 718,880 2,566,487 3,220,242 653,755 Fines &Forfeitures 395,011 370,000 345,000 (25,000) 380,000 355,000 (25,000) Use Of Money & Property 7,952,228 3,830,381 4,075,607 245,226 3,921,943 3,939,280 17,337 Intergovernmental Revenue 15,307,657 16,267,460 17,030,373 762,913 11,602,258 12,364,166 761,908 Other Taxes In Lieu 7,990 7,980 7,980 - 7,980 7,980 -
Charges For Current Svc 7,954,985 8,063,192 8,694,048 630,856 8,299,003 8,608,340 309,337 Other Revenue 3,438,904 469,750 2,106,261 1,636,511 474,750 486,250 11,500 Total Operating Revenues $128 ,102,944 $122,442,069 $132,648,846 $10,206,777 $123,579,681 $131,605,073 $8,025,392 Transfers In 537,023 4,278,135 705,275 (3,572,860) 2,132,599 852,919 (1,279,680) Total Revenues $128, 639,967 $126,720,204 $133,354,121 $6,633,917 $125,712,280 $132,457,992 $6,745,712 3 FY 2022-23 General Fund Budget – $8.5M Expenditure Increases

8.0 New Positions (6.5 FTE)
$653,000 General Plan Update & other consultant and
contract services
$3.1M Modernization - Cybersecurity, ERP , IT system
upgrades, replacement computers, Police Training simulator $1M Homelessness & Affordable Housing – grants to non-
profits
$1.2M LPFD overtime, 0.5 FFTE Battalion Chief, insurance, SCBA equipment
$240,000 Claims and Liability Reserves
4 3
4 Item 3.1
PowerPoint Presentation
85 3
FY 2022-23 General Fund Budget – 8.0 New Positions (6.5 FTE) Stormwater
Manager (1.0 FTE)
• Manage City’s
Stormwater
Program
• Coordinate with
other
departments/age
ncies
Battalion Chief
(0.5 FTE)
•3 rd On Duty
Battalion Chief
• Provides full
coverage
• Reduce span of
control from 34 to
17 Librarian 1
(0.5 FTE)
•E q u i t a b l e
community
outreach
• Target under-
served
communities
Senior Civil
Engineer
(1.0 FTE)
• Lead CIP team
• Improve capacity
to deliver CIP
projects
5 FY 2022-23 General Fund Budget – 8.0 New Positions (6.5 FTE) IT Engineer/Water
SCADA (1.0 FTE)
• Manage SCADA
technology
• Liaison DPW & IT
Crime Analyst
(0.5 FTE)
• Provide real time
analytical support
to Patrol Officers
& Detectives
• Immediate
information
relevant to crimes
in progress
Crisis Intervention
Specialist
(1.0 FTE)
•P r o v i d e
emergency crisis
assessment &
intervention
services in the
field
•C o n d u c t
community
outreach and
follow-up services
Climate Action
Manager
(1.0 FTE)
• Manage &
coordinate
Citywide climate
& sustainability
efforts
6 5
6 Item 3.1
PowerPoint Presentation
86 4
FY 2021-23 General Fund Budget – Total One Time Expenditures One-time Expense
Amount (in
millions)
CIP $15.5
ERP and IT Modernization 4.2
Reserves 5.2
Housing & Other Grants 1.3
Police & LPFD Equipment 0.8
Planning Consultants - General
Plan & Contract Staff 3.07
Pass-through Property Taxes 1.5
Total $31.6
Excluding one-
time expenses,
FY 2021-23
budget has a
$4.5M surplus
7 Revenue Trends and 5-year Forecast
8 7
8 Item 3.1
PowerPoint Presentation
87 5
General Fund Revenue Trends – Property Taxes
77% increase since 2007-08 & 4% average annual increase 9 General Fund Revenue Trends – Sales Taxes
102% increase since 2007-08 & 5.4% average annual increase 10 9
10 Item 3.1
PowerPoint Presentation
88 6
General Fund Revenue Trends – Transient Occupancy Taxes 111% increase since 2014-15 and 7.3% average annual increase 11 General Fund 5-year Forecast
$0.5M surplus in FY 2023-24 growing to $7.9M surplus in FY 2027-28 12 • Revenues
increasing by 4% in
23-24 and 3%
annually
thereafter
• Personnel Services
increase by 3%
annually
• 3.0 new FTE
annually
• Services &
Supplies increase
by 2% to 3%
annually
Assumptions
11 12
Item 3.1
PowerPoint Presentation
89 7
Funding Long-term Obligations:

Infrastructure, OPEB, and Pension
13 Funding Long-term Obligations – Infrastructure
City is responsible for maintaining and repairing infrastructure Current annual funding $13M (Includes $2M to reserves) Short-term (10-year) funding goal $25M ($12M increase) Long-term (20-year) funding goal $45M ($32M increase) 14 13
14 Item 3.1
PowerPoint Presentation
90 8
Funding Long-term Obligations – OPEB
Prepay
OPEB with
$10M from
one-time
revenues
Reduce
annual OPEB
contribution
by $1M to
$1.5M
annually
Prepayment
Lowers annual contribution
OPEB fully funded in FY 2036-37 – save $5.8M
annually thereafter
Total OPEB
Unfunded
Liability =
$35M – 56%
funded
Prefund $10M
= $25M
Unfunded
Liability –
68% funded
15 Funding Long-term Obligations – Pension
Annual pension contributions peak in FY 2022-23 at $25.9M and decline from there to $8.9M in 2040-41
CalPERS
Assumptions:
• 6.8% Discount
Rate
• Increased
mortality rates
• Reflects FY 20-
21 investment
returns of

21.3%
• 78% funded
16 15
16 Item 3.1
PowerPoint Presentation
91 9
Long-term Obligations Funding Plan
Maintain total funding for long-term obligations at $32.6M (2022-23 dollars). Allocate reduced OPEB and pension contributions to Infrastructure Repair and Replacement Reserve. Increase baseline $2M Infrastructure Reserve by 3% annually.

By 2041 – No
contribution to
OPEB, $8.9M to
pensions &
$27.2M to
Infrastructure
reserve
17 Long-term Obligations Funding Plan – Infrastructure Funding Estimated funding by year from allocating $2M baseline (escalated by 3% annually) plus reduced OPEB and pension contributions to the Infrastructure Reserve $2,000,000
$9,974,412
$12,373,595
$22,417,039
$27,182,866
$0
$5,000,000
$10,000,000
$15,000,000
$20,000,000
$25,000,000
$30,000,000
2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 TotalInfrastructureReserveFunding
18 17
18 Item 3.1
PowerPoint Presentation
92 10
Establish Section 115 Pension Trust with General Fund Reserves Invest in Moderately Conservative portfolio – 5% average annual return – compares to City’s approximate 1% returns
Allocate increase in investment returns to pension contributions. Freed up General Fund Contribution Infrastructure Repair and Replacement Reserve Establish Section 115 Pension Trust Fund
19 Allocate Year-end Surplus to Infrastructure Repair and Replacement Reserve
Fiscal Year 2016-17 2017-18 2018-19 2019-20 2020-21 Total Revenues $103,007,269 $109,641,632 $117,420,762 $118,435,835 $124,558,590 Transfers in 2,287,970 3,845,182 900,260 691,026 537,023 Total Sources $105,295,239 $113,486,814 $118,321,022 $119,126,861 $125,095,613 Total Expenses 92,174,338 97,878,200 110,236,356 109,124,003 113,727,055 Transfers out 5,792,127 7,348,147 5,962,071 5,045,980 4,189,578 Total Uses $97,966,465 $105,226,347 $116,198,427 $114,169,983 $117,916,633 Surplus/(Deficit) $7,328,774 $8,260,467 $2,122,595 $4,956,878 $7,178,980 Average 5-year GF Budget Surplus = $6M
Assume allocating 50% or $3M to Infrastructure Repair and Replacement Reserve
20 19
20 Item 3.1
PowerPoint Presentation
93 11
Long-term Obligations Funding Plan
$25.8M
annual
allocation to
Infrastructure
$15.7M annual
GF allocation to
R&R funds and
Infrastructure
Reserves
$1M annual
OPEB savings
$5.1M reduced
annual CalPERS
Contribution
$1M Section 115
Pension Trust
Fund earnings
$3M from Year-
end Budget
Surplus
Possible Infrastructure Repair and
Replacement Funding Scenario in 2032
21 Questions?
22 21
22 Item 3.1
PowerPoint Presentation
94 12
FiscalYear2021Ͳ2023
CapitalImprovementPlan
Update
May2022
FY 2021-2023 CIP Accomplishments
Projects Completed
• Downtown Street Light Enhancements
• 2020 ATP Bike Lane Improvements
• Downtown Bike Racks
23 24
Item 3.1
PowerPoint Presentation
95 13
FY 2021-2023 CIP Accomplishments
Projects Completed (cont.)
• Real Time Awareness Center
• Iron Horse Trail, Isabel to Murrieta
• Multiservice Center Improvements
FY 2021-2023 CIP Accomplishments
Projects Completed (cont.)
• I Street Garage Expansion
• Livermorium Plaza
25 26
Item 3.1
PowerPoint Presentation
96 14
FY 2021-2023 CIP Accomplishments
Projects Completed (cont.)
• WRP Occupied Building Repairs
• WRP Emergency Generator
FY 2021-2023 CIP Accomplishments
Projects Under Construction (or soon to be)
• El Charro Infrastructure (Republic Square)
• Downtown Surface Parking
• Downtown Streetscape (Legacy)
• Granada Channel Pipe Repair
• L Street Garage Phase 1
• Railroad Avenue Improvements
• WRP Primary and Secondary Treatment Improvements
• 2021 Slurry Seal
• 2021 Street Resurfacing
27 28
Item 3.1
PowerPoint Presentation
97 15
Issues Impacting the CIP
• COVID-19
• Availability of construction material
•O utside agencies
• Engineering Division vacancies
Changes Between Proposed 2021-23 CIP
Update and Original FY 2021-2023 Budget
Program Original (M) Updated (M)
Airport $ 10.70 $ 10.56
Downtown $ 65.59 $ 44.41
Parks $ 5.76 $ 4.33
Buildings $ 7.89 $ 5.10
Public Safety $ 1.08 $ 1.53
Storm Drain $ 4.56 $ 2.90
Street Maintenance $ 9.69 $ 16.28
29 30
Item 3.1
PowerPoint Presentation
98 16
Changes Between Proposed 2021-23 CIP Update
and Original FY 2021-2023 Budget (cont.)
Program Original (M) Updated (M)
Traffic Control $ 0.37 $ 1.47
Trail/Bike $ 5.85 $ 3.98
Transportation $ 11.20 $ 10.21
Wastewater $ 28.75 $ 28.26
Water $2 . 4 1 $0 . 4 6
Total $ 153.83 $ 129.49
Next Steps

1. Tonight Ͳ Councilprovidesdirectiontostaffontheoperating budgetandCIP

2. May 17thruJune6Ͳ StafffinalizesoperatingbudgetandCIP

3. June 13–S t a f fbringOperatingBudgetandCIPbackfor Councilconsiderationandapproval
31 32
Item 3.1
PowerPoint Presentation
99

Livermore City CouncilMay 16, 2022

Livermore City Council
May 16, 2022