Rules & Legislation Committee
November 21, 2024

Attachment A: FY 2024-25 Q1 Detailed Report

TABLE OF CONTENTS

The report has the following major sections:

1. General Purpose Fund Q1 Revenues

2. General Purpose Fund Q1 Expenditures

3. General Purpose Fund Q1 Fund Balance

4. Reserves

Appendixes:

Consolidated Fiscal Policy

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

Summary of FY 2024-25 Q1 GPF Revenues & Expenditures

FY 2024-25 GPF Revenue is projected to come in at $0.30 million, or 0.0 % higher, compared to the Adjusted Budget of $758.22 million. GPF Expenditures are estimated to come in at $93.38 million or 12.3% over the Adjusted Budget of $758.22 million. Table 1 below shows the FY 2024-25 General Purpose Fund revenue and expenditures Adjusted Budget and year-end estimates which currently project a year end operating shortfall of $93.08 million.

Table 1: Summary of FY 2024-25 Q1 GPF Revenues & Expenditures Budget to Estimated Year-End Actuals ($ in millions)

FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25 Q1
Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
FY2023-24
Revenues 758.22 88.68 758.52 0.30 — %
FY 2023-24
Expenditures 758.22 168.73 8 51.60 (93.38) (12.3) % Operating
(Shortfall) / Surplus
— (80.05) (93.08) (93.08) (12.3) %

I. GENERAL PURPOSE FUND FY 2024-25 Q1 REVENUES

This section of the report provides an assessment of the City's revenue condition in the current fiscal year as compared to the FY 2024-25 Adjusted Budget based on actual performance during the first three months of FY 2024-25, quarterly trends established in prior fiscal years, and external data sources. The GPF tax revenue is projected to end the year with a net surplus of $0.30 million. The Adjusted Budget also assumes $13.37 million in use of fund balance to cover prior year encumbrance carryforwards. Without accounting for the before mentioned one- time use of available funds, the GPF revenues forecast to come in at $758.52 million, which is $14.05 million over compared to the revenues assumed in the Adjusted Budget of $744.47 million.

Amongst the 5 largest revenue contributors in the GPF, Property Tax is projected to increase slightly driven by an estimated 3.86% rise in assessed taxable values. Collections for Business Tax (BT) are concentrated in Q3 due to renewal deadlines. The current projection assumes BT will perform at the same level of the prior fiscal year. Real Estate Transfer Tax (RETT) Collections are expected to end the year at $66.03 million, which is $7.69 million or 10.4% under the Adjusted Budget. However, RETT is showing a recovery from the downturn in FY 2023-24. Sales Tax is projected to end slightly under budget by $63.65 million or 0.1%, following a decrease experienced in FY 2023-24. While the Utility Consumption Tax is expected to Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

continue to grow in FY 2024-25 driven by a 12.7% rate increase by the California Public Utilities Commission phased in gradually during 2024.

Q1 HIGHLIGHTS OF THE TOP 5 GPF REVENUE CONTRIBUTORS

Property Tax: FY 2024-25 collections of the City's largest revenue source through Q1 are at $10.94 million or 3.6% of the Adjusted Budget of $306.57 million, and are now projected to end the year at $310.69 million, which is $4.12 million or 1.3% over the Adjusted Budget. For comparison FY 2023-24 ended the year at $299.15 million, which represented a $17.87 million, or 6.35%, dollar increase compared to FY 2022-23. The projected year-over-year increase in FY 2024-25 is driven by the estimated overall increase in assessed taxable values for the City of approximately 3.86%, which result in a proportional increase in the amount of property tax assessments.

The assessed values for the fiscal year 2024-25 are based on the calendar year 2023 valuations. All real properties, including land and improvements, not subject to Proposition 8 reductions by County assessors, are assumed a 2.00% CPI adjustment. Properties sold between January and December 2023 were analyzed. The difference between the assessed value on the 2023-24 tax roll and the actual sale price was calculated to determine the market value adjustment. A decrease in the number of homes listed for sale in 2023 results in a less significant year-over-year price increase compared to previous years. Sales of single-family residential properties from the latter half of 2023 were compared to similar transactions from the second half of 2022 and the median price change was determined and applied to properties that had previously been reduced under Proposition 8. The adjustment ensures that the recapture does not exceed the potential value increase plus the next year's CPI adjustment, adhering to legal limitations. Both personal property on the secured tax rolls and unsecured property values are projected to remain constant from the 2023-24 levels. This stability is anticipated due to an equilibrium between depreciation of existing assets and the addition of new assets from commercial and industrial expansions. New construction additions to the tax roll are estimated at 25% of the average new construction value in the City over the last eight years. This conservative estimate accounts for potential slowdowns or in building activity. No new annexations or potential reductions due to property tax appeals are assumed.

Business License Tax (BT): FY 2024-25 collections of the second largest revenue source for the City through Q1 are at $5.53 million or 4.6% of the Adjusted Budget of $120.06 million, and are now projected to end the year at $123.48 million, which is $3.42 million or 2.9% over the Adjusted Budget. This estimate assumes that BT will perform at the same level as FY 2023-24.

The Bulk of BT is collected in the third quarter of the fiscal year since Business Tax renewals are due during that period. The Construction, Utilities, and Rental sectors showed decreased activity in FY2023-24 and did not meet tax contributions as anticipated in the budget. Despite these shortfalls there was a general increase in gross receipts of 1.3% reported by businesses renewing their tax filings in FY 2023-24 compared to the gross receipts reported in the prior fiscal year by the same accounts across all BT sectors. This growth rate was slightly below the

2.7% average annual percentage increase in gross receipts reported for account renewals over Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

the previous four fiscal years. In total, BT collection increased by $8.10 million or 7.0% in FY 2023-24 from the $115.38 million collected in FY 2022-23. The sectors with the highest year- over-year increase in BT remitted were led by Professional / Semi-Professional Services, Admin Headquarters, and Wholesale Sales. The November 17, 2023, report to the City Council on Measure T's implementation showed that these three categories accounted for approximately

47.5% of the overall net revenue increase from the amended business tax structure resulting from Measure T, totaling about $8.3 million in growth annually.

Real Estate Transfer Tax (RETT): FY 2024-25 collections of the third largest revenue source for the City is through Q1 are at $16.51 million or 22.4% of the Adjusted Budget of $73.72 million, and are projected to end the year at $66.03 million, which is $7.69 million or 10.4% under the Adjusted Budget. However, RETT collections are forecasted to increase by 16.5% by the end of this fiscal year compared to last year. This growth aligns with the increase observed in the first quarter (Q1) of this year over the same period last year. Through Q1, the number of properties sold through the first three months increased by 7.4%, or 65 properties, compared to the number of properties sold during the same time period in the prior year. Gross sales increased by 3.5% when accounting for the sales prices. High value properties sold during the Q1 also showed improvement over the same period in the prior year, with sales of properties valued over $5.00 million totaling 11 in FY 2024-25's Q1 compared to 8 during Q1 of FY 2023- 24, representing a year over year increase of 37.5 % for this sales price range.

The Federal Open Market Committee (FOMC) during Q1 made its first reduction in interest rates since they began to rise in March 2022. This cut is anticipated to stimulate buyer interest.

With this initial decrease in interest rates, there's potential for market stabilization. As buyers adjust to this new rate environment, we might see a gradual increase in sales volume. This adjustment period could lead to more consistent market growth if interest rates remain stable or decrease further.

Table 2 below shows the RETT growth rate by sales price comparing Q1 in FY 2024-25 to Q1 in FY2023-24.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

Table 2: RETT Growth Rate ($ in millions)
FY 2023-24 Q1 FY 2024-25 Q1 Year-Over-Year
Variance Thru Q1
Sale Price Gross Sales Volume Gross Sales Volume Gross Sales Volume $300,000 or below $ 9.69 54 $ 10.62 63 9.58 % 16.7 % $300,001 to $2 Million $ 693.87 768 $ 728.92 821 5.05 % 6.9 % $2 million to $5 Million $ 117.21 43 $ 108.65 43 (7.30) % — % $5 -10 Million $ 33.85 5 $ 54.29 7 60.39 % 40.0 %
$10 - 50 Million $ 71.85 3 $ 56.00 4 (22.06) % 33.3 % $50.01-100 Million $ — 0 $ — — — % — %
Over $100 Million $ — 0 $ — $ — — % — %
Total $ 926.46 873 $ 958.48 938 3.5 % 7.4 %

Sales Tax: FY 2024-25 collections of the fourth largest revenue source of the City through Q1 are at $5.34 million or 8.4% of the Adjusted Budget of $63.73 million, and are now projected to end the year at $63.65 million, which is $0.08 million or 0.1% slightly under the Adjusted Budget.

The $5.34 million in actual revenues reported for the first quarter do not accurately represent the Sales Tax receipts for that period. This is because the collections are managed externally by the State and then remitted in bulk to the City. Over the last five years, the average Sales Tax captured through the first quarter in Oracle has been approximately $5.37 million. Data available for FY2023-24 (Sales Tax is collected by the State and the corresponding detailed data becomes available to the City in the subsequent quarter) shows that Sales tax categories ended FY 2023-24 6.2% lower on average compared to the previous fiscal year.

Categories with year over year decreases in sales tax in FY 2023-24 overall were led percentage wise by fuel service stations. High gas prices were the primary driver of a 17.4% decline by fuel-service stations as airlines refueled more often at locations outside of the Bay Area. Cannabis has another downward outcome, more so than regional and statewide trends.

This sectors’ decrease was the primary cause of the food-drugs group lower returns of 12.3% compared to the prior year. Autos and transportation saw a downturn similar to state-wide trends, with a particular decline in sales of luxury vehicle brands which led to ending the fiscal year 12.1% lower compared to the prior year. This shift was largely due to higher interest rates and pricing concerns, which deterred potential buyers from making large purchases. The closure of several establishments over the past year and a shift in consumer behavior towards seeking value amid rising menu prices resulted in restaurants and hotels overall to decline by

4.2% compared to FY 2022-23. On average the Sales Tax categories dropped by 6.2% year over year. Moving on to FY 2024-25, a minor anticipated increase from the previous fiscal year indicates a slow recovery or stabilization rather than robust growth. The gradual increase suggests growth could bring a slow rise in Sales Tax revenues over the next couple of years.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

Table 3 below compares the Sales Tax totals received by category in FY 2022-23 to those received in FY 2023-24.

Table 3: Sales Tax Comparison by Category FY 2022-23 and FY 2023-24 ($ in millions) Category FY 2022-23 FY 2023-24 Inc/Dec
Autos & Transportation $ 10.27 $ 9.16 (12.1) %
Building & Construction $ 6.19 $ 5.94 (4.2 ) %
Business & Industry $ 6.17 $ 5.45 (13.2) %
Food & Drugs $ 5.34 $ 4.76 (12.3) %
Fuel & Service Stations $ 7.99 $ 6.80 (17.4) %
General Consumer Goods $ 5.49 $ 4.91 (11.9) %
Restaurants & Hotels $ 11.00 $ 10.55 (4.2) %
State/County Pools & Transfers $ 11.53 $ 12.66 8.9 %
Average $ 8.00 $ 7.53 (6.2)%

Utility Consumption Tax (UCT): FY 2024-25 collections of the fifth largest revenue category for the City through Q1 are at $16.99 million or 24.8% of the Adjusted Budget of $68.44 million, and are now projected to end the year at $72.77 million which is $4.34 million or 6.3% over the Adjusted Budget. The California Public Utilities Commission (CPUC) approved a 12.7% increase in consumer utility rates for 2024. PG&E, which is the largest contributor to the City’s UCT implemented rate hikes in phases in 2024 with a 6% increase that took effect in March, an additional 4% in June and implemented a further 2.7% adjustment in September. The full effect of the 12.7% rate increase will be in effect for the remainder of FY 2024-25, however, part of this increase was already accounted for last year. The UCT revenue forecast is driven by the compounded effects of the 2024 rate increases and assumes no drastic shifts in consumer behavior or regulatory frameworks.

Other Notable Revenue Highlights:

Fines & Penalties: Q1 FY 2024-25 collections came in at $5.84 million or 30.2% of the Adjusted Budget of $19.34 million, and now is projected to end the year at $20.97 million, an

8.4% increase over the Adjusted Budget of $19.34 million. Parking citations are the major revenue source. Though FY 2023-24 saw a slight decrease in Parking Citation revenue due to reduced enforcement tied to under-staffing and issues with scofflaw management, Q1 in FY 2024-25 shows an increase in citations issued, suggesting a potential revenue increase aligning with fine rates that have been raised by 10% over the last two years.

Miscellaneous Revenue: Q1 FY 2024-25 collections came in at $12.74 million, significantly over the $1.23 million Adjusted Budget. A $5 million payment from the Coliseum site sale, not initially accounted for due to delays, contributed to this surplus. Legal settlements also boosted the revenue in Q1. The revenue resulting from these legal settlements is restricted to specific reimbursements bound by settlement agreements.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

Service Charges: Q1 FY 2024-25 collections came in at $7.21 million or 13.9% of the Adjusted Budget, and are expected to meet the $51.84 million Adjusted Budget. Parking meter revenue was significantly under budget in FY 2023-24, but a 50% increase in parking fees for FY 2024- 25 is expected to recover this shortfall, with early data showing a 30% increase in collections.

Transient Occupancy Tax (TOT): Q1 FY 2024-25 collections came in at $3.13 million or 15.9% of the Adjusted Budget of $19.74 million, and is projected to end the year $2.23 million under budget at $17.50 million. A decrease in hotel operations and lower room rates have impacted collections, resulting in an 8% drop in Q1 from last year's first quarter.

Parking Tax (PT): Q1 FY 2024-25 collections came in at $2.32 million or 17.8% of the Adjusted Budget of $13.07 million, and now are projected to end the year $1.20 million under budget at $11.87 million. Post-COVID stabilization is evident, but the market seems to have reached its peak, and the projections are based on FY 2023-24's performance.

Interfund transfers & Transfers From Fund Balance: The adjusted budget assumes $13.75 million in use of fund balance to support carryforward expenditures.

Table 4 below summarizes all of the FY 2024-25 GPF revenues by category.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

Table 4: FY 2024-25 Q1 Adopted Budget to Actuals and Year End Estimate ($ in millions) Revenue
Category
FY 2024-25
Adopted
Budget
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-End
Estimate
Year-End $
Over / Under
Adjusted

Year-End %
Over / Under
Adjusted
Property Tax 306.57 306.57 10.94 310.69 4.12 1.3 % Sales Tax 63.73 63.73 5.34 63.65 (0.08) (0.1) %
Business
License Tax 120.06 120.06 5.53 123.48 3.42 2.9 %
Utility
Consumption
T

68.44 68.44 16.99 72.77 4.34 6.3 %
Real Estate
Transfer Tax 73.72 73.72 16.51 66.03 (7.69) (10.4) % Transient
Occupancy
T

19.74 19.74 4.59 17.50 (2.23) (11.3) %
Parking Tax 13.07 13.07 2.32 11.87 (1.20) (9.2) %
Licenses &
Permits 1.16 1.16 0.27 1.16 — — %
Fines &
Penalties

19.34 19.34 5.84 20.97 1.63 8.4 %
Interest
Income

2.50 2.50 0.18 2.50 — — %
Service
Charges 51.84 51.84 7.21 51.84 — — %
Internal
Service Funds — — — — — — %
Grants &
Subsidies — — 0.21 0.21 0.21 — %
Miscellaneous
Revenue

64.32 1.23 12.74 12.74 11.51 939.2 %
Interfund
Transfers

2.70 3.08 — 3.08 — — %
Subtotal 807.19 744.47 88.68 758.52 14.05 1.9 %
Transfers from
Fund Balance
— — — — — — %
Project Offsets
&
Carryforwards — 13.75 — — (13.75) (100.0) %
Total Revenue 807.19 758.22 88.68 758.52 0.30 0.1 %

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

II. GENERAL PURPOSE FUND Q1 EXPENDITURES

GENERAL PURPOSE FUND EXPENDITURE HIGHLIGHTS

The GPF expenditures are forecasted to come in at $851.60 million, which is an overspend of $93.38 million or 12.3% over, when compared to the Adjusted Budget of $758.22 million.

Originally, the Midcycle Adopted Budget assumed the use of the sale of the Coliseum in the amount of $63.5 million to balance the expenditures as budgeted. This follows a trend in recent years, during which one-time funding was needed in the balancing of the FY2019-20, FY2020- 21, FY2021-22, and FY2022-23 expenditures in the budget by programming CARES dollars ($36.99 million), ARPA dollars ($188 million), and use of VSSF ($14.65 million) for a total of $239.64 million, which would equal 32% of FY 2024-25 GPF budgeted expenditures.

However, the scheduled distribution of Coliseum sale revenues has not been met, leading to the reduction of City services to match the missing revenue. The budgeted personnel expenditure also assumes a vacancy factor of 10.00%, it is expected that the actual vacancy factor will be higher with the hiring freeze in effect.

On March 27, 2024, the City Administrator released a memo outlining several policies to be implemented immediately that would help reduce City expenditures, primarily in the GPF. The following reduction measures implemented remain in effect, such as a hiring freeze for all non- sworn positions. The citywide moratorium on professional training and conferences funded through the GPF also continues into the current year. All other discretionary spending in the GPF has been limited as the City attempts to bridge the widening gap between GPF revenues and expenditures.

In October 2024, administrative action was taken to initiate the implementation of the contingency budget after criteria was met related to the timing of receiving revenues from the Coliseum sale. This action consisted of a $63 million reduction to the Adjusted Budget, which included the freezing of 33.50 FTE positions across the City.

Table 5 below reflects the GPF expenditures forecasted to come in at $851.60 million, which is $93.38 million or 12.3% over the adjusted budget of $758.22 million.

Table 5: Summary of FY 2024-25 Q1 GPF Expenditures Budget to Actuals ($ in millions)

FY 2024-25
Adopted
Budget
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
FY 2023-24
Expenditure

807.19 758.22 168.73 8 51.60 (93.38) (12.3) %

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

Department Level Spending Trends

Table 6 below reflects department level spending and projected year-end GPF expenditures. As a result, City-wide GPF departmental expenditure projections are projected to come in above the Adjusted Budget by $93.38 million. Per the City’s Consolidated Fiscal Policy, Departments projected to overspend in the General Purpose Fund by more than one percent (1%), shall bring an informational report to the City Council within 60 days following acceptance of the Revenue & Expenditure report by the City Council. The report shall list the actions the Administration is taking to bring the expenditures into alignment with the budget.

Table 6: Summary of FY 2024-25 GPF Projected Expenditure Variance ($ in millions) Department
FY 2024-25
Adopted
Budget
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-
End
Estimate
Year-End $
Over /
Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Capital
Improvement
Projects 0.56 0.94 0.01 0.94 — — %
City
Administrator 5.99 4.87 1.19 5.58 (0.72) (14.7) % City Attorney 21.71 21.95 4.43 21.23 0.72 3.3 % City Auditor 3.73 3.90 0.49 2.65 1.25 32.0 %
City Clerk 8.00 7.94 0.73 8.00 (0.06) (0.8) %
City Council 7.87 7.91 1.54 7.35 0.56 7.1 %
Department of
Transportation 21.72 21.59 4.28 23.41 (1.82) (8.4) % Department of
Violence
Prevention 7.49 8.10 1.25 6.50 1.60 19.8 %
Department of
Workplace and
Employment
Standard 2.39 2.15 0.40 2.30 (0.15) (7.2) %
Economic and
Workforce
Development
Department 15.24 13.54 6.52 13.79 (0.25) (1.9) % Finance
Department 29.13 27.34 4.79 28.04 (0.70) (2.6) % Fire Department 180.45 163.26 44.62 197.70 (34.44) (21.1) % Human
Resources
Management
Department 0.33 0.53 0.26 0.19 0.33 63.3 %
Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

Department
FY 2024-25
Adopted
Budget
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-
End
Estimate
Year-End $
Over /
Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Human Services
Department 43.08 43.36 2.42 43.99 (0.62) (1.4) % Information
Technology
Department 6.55 6.95 1.79 8.35 (1.39) (20.0) %
Mayor 5.59 5.60 0.97 4.64 0.96 17.1 %
Non
Departmental
and Port 53.80 51.41 (3.06) 60.41 (9.00) (17.5) % Oakland Animal
Services 6.84 6.57 1.20 6.12 0.46 6.9 %
Oakland Parks
and Recreation
Department 11.80 12.01 2.88 12.01 — — %
Oakland Public
Library
Department

12.40 11.40 1.20 12.92 (1.53) (13.4) %
Oakland Public
Works
Department 2.73 4.48 0.54 3.85 0.63 14.2 %
Police
Commission

8.78 9.48 1.37 7.19 2.29 24.2 %
Police
Department 347.21 318.88 88.13 370.77 (51.89) (16.3) % Public Ethics
Commission

2.52 2.71 0.51 2.37 0.34 12.4 %
Race and Equity
Department 1.27 1.35 0.28 1.29 0.05 4.0 %
Total 807.19 758.22 168.73 8 51.60 ( 93.38) (12.3) %

The following section details Q1 projected GPF savings or overspending by Department, as compared to the FY 2024-25 Adjusted Budget.

Capital Improvement Program (CIP)

The Capital Improvement Program is projected to end the fiscal year at its adjusted budget of $0.94 million.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

City Administrator (CAO)

The City Administrator’s Office is projected to overspend by $0.72 million, or 14.7% of their budget. The overage is primarily due to an increase in personnel spending. In the General Purpose Fund, CAO has a vacancy rate of 6%, with one vacant position.

City Attorney (OCA)

The City Attorney is projected to underspend by $0.72 million, or 3.3% of their budget. In the General Purpose Fund, OCA has no vacant positions.

City Auditor

The City Auditor is projected to underspend by $1.25 million, or 32.0% of their budget, due to vacancies. In the General Purpose Fund, City Auditor has a vacancy rate of 33%, with four vacant positions.

City Clerk

The Office of the City Clerk is projected to overspend their budget by $0.06 million, or 0.8% of their budget. In the General Purpose Fund, City Clerk has no vacant positions.

City Council

The City Council is projected to underspend their budget by $0.56 million, or 7.1% of their budget. In the General Purpose Fund, City Council has a vacancy rate of 3%, with one vacant position.

Department of Transportation (DOT)

The Department of Transportation is projected to overspend by $1.82 million, or 8.4% of their budget. This is primarily due to overtime costs centered around parking enforcement activities and overnight street sweeping due to staffing shortages. In the General Purpose Fund, DOT has a vacancy rate of 16%, with 13 vacant positions.

Department of Violence Prevention (DVP)

The Department of Violence Prevention is projected to underspend by $1.60 million or 19.8% of their budget, due to vacancies. In the General Purpose Fund, DVP has a vacancy rate of 29%, with ten vacant positions.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

Department of Workplace & Employment Standards (DWES)

The Department of Workplace & Employment Standards is projected to overspend by $0.15 million, or 7.2% of their budget. The overage is primarily due to an increase in personnel spending. In the General Purpose Fund, DWES has a vacancy rate of 29%, with two vacant positions.

Economic & Workforce Development (EWD)

Economic & Workforce Development is projected to overspend by $0.25 million, or 1.9% of their budget. This overage is primarily due to an increase in personnel spending. In the General Purpose Fund, DWES has a vacancy rate of 19%, with three vacant positions.

Finance Department

The Finance Department is projected to overspend by $0.70 million, or 2.6% of their budget.

This overage is primarily due to an increase in personnel costs. In the General Purpose Fund, Finance has a vacancy rate of 10%, with 10 vacant positions.

Fire Department

The Oakland Fire Department is projected to overspend by $34.44 million, or 21.1% of their budget, due to overtime overspending. A detailed explanation of this overage can be found in a supplemental report that will be provided at a later date.

Human Resources Management (HRM)

Human Resources Management is projected to underspend by $0.33 million, or 63.3% of their budget. In the General Purpose Fund, HRM has no vacant positions.

Human Services Department (HSD)

Human Services Department is projected to overspend by $0.62 million, or 1.4% of their budget.

In the General Purpose Fund, HSD has a vacancy rate of 9%, with three vacant positions. The overage is primarily due to additional O&M costs related to HeadStart.

Information Technology (ITD)

The Information Technology Department is projected to overspend by $1.39 million, or 20.0% of their budget. This overage is primarily due to an increase in personnel spending. In the General Purpose Fund, ITD has no vacant positions.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

Mayor’s Office

The Mayor’s Office is projected to underspend by $0.96 million, or 17.1% of their budget, due to vacancies. In the General Purpose Fund, Mayor's Office has a vacancy rate of 31%, with four vacant positions.

Non-Departmental

Non-Departmental is projected to overspend by $9.00 million, or 17.5% of the budget. The overage is primarily due to costs associated with the closeout of the Coliseum.

Oakland Animal Services

The Department of Animal Services is projected to underspend by $0.46 million, or 6.9% of their budget, due to vacancies. In the General Purpose Fund, Animal Services has a vacancy rate of 22%, with four vacant positions.

Oakland Parks, Recreation and Youth Development (OPRYD)

Oakland Parks, Recreation and Youth Development is projected to end the fiscal year at its adjusted budget of $12.01 million. In the General Purpose Fund, OPRYD has a vacancy rate of 5%, with five vacant positions.

Oakland Public Library (OPL)

Oakland Public Library is projected to overspend by $1.53 million, or 13.4% of their budget. The overage is primarily due to an increase in personnel spending. In the General Purpose Fund, OPL has a vacancy rate of 11%, with four vacant positions.

Oakland Public Works (OPW)

Oakland Public Works is projected to underspend by $0.63 million, or 14.2% of their budget, due to vacancies. In the General Purpose Fund, OPW has a vacancy rate of 10%, with one vacant position.

Police Commission

The Police Commission is projected to underspend by $2.29 million, or 24.2% of their budget, due to vacancies. In the General Purpose Fund, Police Commission has a vacancy rate of 25%, with seven vacant positions.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

Police Department

The Police Department is projected to overspend by $51.89 million, or 16.3% of their budget, due to overtime overspending. A detailed explanation of this overage can be found in a supplemental report that will be provided at a later date.

Public Ethics Commission (PEC)

The Public Ethics Commission is projected to underspend by $0.34 million, or 12.4% of their budget, due to vacancies. In the General Purpose Fund, PEC has a vacancy rate of 20%, with two vacant positions.

Race & Equity

The Department of Race & Equity is projected to underspend by $0.05 million, or 4.0% of their budget. In the General Purpose Fund, Race & Equity has no vacant positions.

Public Safety Costs & Analysis

Due to the timing of when data was made available, the Police and Fire Department were unable to provide an analysis of their projected overspending in overtime by the publication of this report. A detailed analysis will be presented to City Council in a supplemental report at a later date.

Table 7 below shows the personnel expenditures, including overtime, for Public Safety in the GPF. Once all other personnel costs are accounted for, Oakland Police Department currently shows a projected year-end personnel budget to be overspent by $48.92 million in the General Purpose Fund. Details are provided on Table 7 below.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

Table 7: FY 2024-25 Public Safety GPF Personnel Expenditures ($ in millions) Department
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-
End
Estimate
Year-End $
Over /
Under
Adjusted
Budget
Year-End
% Over /
Under
Adjusted
Budget
Police Department**
Overtime (OT) 42.85 14.55 55.24 (12.38) (28.9) %
Reimbursable OT (Special Events, etc.) (5.07) (5.07) 5.07 All Other Personnel (non-OT) 226.07 69.46 267.68 (41.61) (18.4) % OPD Total Personnel 268.93 78.93 317.85 (48.92) (18.2) % Fire Department
Overtime (OT) 10.59 8.74 34.95 (24.36) (229.9) %
All Other Personnel (non-OT) 126.65 34.34 134.57 (7.92) (6.3) % OFD Total Personnel 137.25 43.07 169.52 (32.27) (23.5) %

As shown on Table 7 above, OPD was budgeted $42.85 million for overtime and is projected to exceed this budgeted amount by $12.38 million for a projected year-end total of $55.24 million.

In the table below, are the top five organizations in OPD where overspending has occurred most outlined in Table 8:

Table 8: FY 2024-25 OPD Top 5 Organizations in Overtime Expenditures ($ in millions) Top 5 Organizations in
OPD for Overtime
FY 2024-25
Adjusted Budget
FY 2024-25 Q1
Year-End Estimate
Year-End $ Over /
Under Adjusted
Budget
Special Operations Division (SOD) 2.59 10.35 (7.76)
Area 1 2.13 5.99 (3.85)
Area 5 2.15 3.82 (1.67)
Area 3 2.08 3.73 (1.65)
Homicide 0.74 3.67 (2.93)

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024

Special City Council Meeting
November 19, 2024

Table 9: Year-Over-Year Comparison of Public Safety GPF Personnel Expenditures ($ in millions)
Police Department
Overtime (OT) FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 Adjusted Budget 15.39 33.36 30.90 24.19 42.85
Actuals (FY25 Proj) 29.18 34.35 51.16 55.24 55.24
(Over)/Under (13.79) (0.99) (20.26) (31.05) (12.38)
All Other Personnel (non-OT) FY 2020-21 FY 2021-22 FY2022-23 FY2023-24 FY2024-25 Adjusted Budget 239.29 245.01 252.38 262.50 226.07
Actuals (FY25 Proj) 244.23 234.29 182.02 253.22 262.61 (Over)/Under (4.94) 10.71 70.36 9.29 (36.54)
Total Personnel FY 2020-21 FY 2021-22 FY2022-23 FY2023-24 FY2024-25 Adjusted Budget 254.68 278.37 283.28 286.69 268.93
Actuals (FY25 Proj) 273.41 264.27 233.18 308.45 317.85 (Over)/Under (18.73) 14.09 51.57 (21.76) (48.92)
Fire Department
Overtime (OT) FY 2020-21 FY2021-22 FY2022-23 FY2023-24 FY2024-25 Adjusted Budget 4.22 19.83 11.19 13.80 10.59
Actuals (FY25 Proj) 24.22 29.83 29.96 29.24 34.95
(Over)/Under (20.00) (10.00) (18.77) (15.43) (24.36)
All Other Personnel (non-OT) FY 2020-21 FY 2021-22 FY2022-23 FY2023-24 FY2024-25 Adjusted Budget 144.73 132.44 143.28 163.79 126.65
Actuals (FY25 Proj) 126.99 119.50 129.85 137.19 134.57 (Over)/Under 17.74 12.94 13.44 26.59 (7.92)
Total Personnel FY 2020-21 FY 2021-22 FY2022-23 FY2023-24 FY2024-25 Adjusted Budget 148.95 152.27 154.47 177.59 137.25
Actuals (FY25 Proj) 151.21 149.33 159.80 166.43 169.52 (Over)/Under (2.26) 2.94 (5.33) 11.16 (32.27)

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 18

Special City Council Meeting
November 19, 2024

III. GENERAL PURPOSE FUND - FUND BALANCE

The City's GPF Fund Balance, net obligations, is projected to end FY 2024-25 at negative $99.91 million. Obligations are reserves required by City Ordinances and the City Charter (mandated emergency reserves). Table 10 below shows additional adjustments totaling negative $15 million, decreasing the estimated FY 2024-25 year-end available fund balance from negative $99.91 million to negative $114.90 million. The estimated FY 2024-25 available Fund Balance is the amount of unobligated funding available to the City in the GPF.

Table 10: FY 2024-25 Year-End Available GPF Fund Balance GENERAL PURPOSE FUND (1010) FY 2024-25 Q1 Year-
End Estimate

Beginning Unassigned Fund Balance - Unaudited (6.83)
Revenue 758.52
Expenditures 851.60
Estimated Current Year Surplus/(Shortfall) (93.08)
Estimated Ending Fund Balance (99.91)
Use of Fund Balance in FY 2024-25
Return of Excess Fund Balance in Equipment Fund 8.32
Legal Settlements (10.58)
Required Carryforwards from FY 2023-24 (12.74)
Estimated Ending Fund Balance (114.90)

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 19

Special City Council Meeting
November 19, 2024

IV. RESERVES

On December 9, 2014 Council Ordinance No. 13279 amended the City’s Consolidated Fiscal Policies to include designated reserves for both the Vital Services Stabilization Fund and for the acceleration of long-term obligations, in addition to the mandated 7.5% GPF Emergency Reserve (refer to the City of Oakland Consolidated Fiscal Policy, Section I, Part C: Use of Excess Real Estate Transfer Tax). It is important to note that while these balances are designated each fiscal year, reserve appropriations adopted in subsequent fiscal years may include any prior year true-ups.

Emergency Reserve

The City’s GPF Emergency Reserve was budgeted at 7.5% of the FY 2022-23 GPF Adopted Budget of $872.07 million. As of June 30, 2024, the balance in this reserve was $70.16 million, or approximately 8.1% of the FY 2023-24 GPF Adopted Budget of $863.68 million. However, unassigned fund balance in the GPF was negative $32.93 million at year end. In combination these two source of reserves totaled $37.23 million, or 57% of the reserve requirement of $64.78 million.

Even if fully met, the emergency reserve policy level of 7.5% would be inadequate to sustain city services in an economic downturn as evidenced by the events of the last 2 years. The recommended policy level is 16.7% or two months of operating expenditures. This recommended level is supported by best practices outlined by the Government Finance Officer's Association's (GFOA).

Vital Services Stabilization Fund

The Vital Services Stabilization Fund (VSSF) was established in 2014 by City Council after the Great Recession to serve as the City's "Rainy Day" fund. Per the Consolidated Fiscal Policy, 25% of excess RETT revenue is intended to go into the VSSF. The FY 2022-23 ending available balance of $10.27 million was assumed in its entirety in the FY 2023-24 Adopted Budget to balance expenditures as City Council declared that the City is experiencing a severe financial event and state of extreme fiscal necessity. The target funding level per the City's Consolidated Fiscal Policy is $125.22 million, or 15% of the GPF revenues.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 20

Special City Council Meeting
November 19, 2024

Table 11 below shows the estimated FY 2024-25 year end reserve balances.

Table 11: FY 2024-25 Q1 Reserve Balances ($ in millions) Description
FY 2023-24
Beginning
Balances
FYE Estimated
2023-2024
Balances
(1) General Fund Reserves: 85.30 37.23
Mandated Emergency Reserves FY 2022-23* 66.63 70.16
Unassigned GPF Fund Balance 18.67 (32.93)
(2) Vital Services Stabilization Fund 10.27 0.50
(3) OMERS Reserves (Reso. No. 85098 C.M.S) 2.36 2.36
Total Reserves 97.93 40.09
*The 7.5% GPF reserve is not a cumulative balance
Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 21

Special City Council Meeting
November 19, 2024
V. SELECTED Q1 NON-GPF

This section of the FY 2024-25 Q1 report contains additional analysis on selected non-GPF funds. For additional fund descriptions, please visit
https://stories.opengov.com/oaklandca/published/_dhbklVRjPB.Thi s Q1 report discusses selected funds that are of special interest to the City because the revenue comes from a special tax or local measure, or because of the particular revenue or expenditure restrictions. For these funds, the revenue tables below will show year-end estimates compared to the adopted budget.

The expenditure tables in this section compares the FY 2024-25 Adjusted Budget to FY 2024-25 year-end estimates.

The fund balance tables compare the FY 2024-25 unaudited beginning fund balance to the FY 2024-25 projected ending fund balance for these funds. Please note that some of the fund tables below show a budgeted transfer from fund balance for FY 2024-25. These amounts represent dollars designated to balance the Adjusted Budget.

All other funds are summarized in Table 47.

Measure HH - Sugar Sweetened Beverage Distribution Tax (SSBT) Fund (1030)

Measure HH - SSBT Fund (1030) is a City of Oakland ballot initiative approved by voters on November 8, 2016, that established a general tax of one cent per fluid ounce on the sugar sweetened beverage products. The tax is imposed upon the first non-exempt distribution of sugar-sweetened beverage products in the City. While this revenue is not restricted by State statute, City Council has elected to restrict it by policy and separate it into its own fund because the primary purpose of the tax is to raise revenue to support programs designed to discourage sugar consumption and to reduce the growing burden of obesity and non-communicable diseases.

The measure formed a nine-member Community Advisory Board, appointed by the Mayor, and approved by City Council. The Board is responsible for:

1. Making recommendations to City Council on use of funding/programs that will reduce the health consequences from consuming sugar-sweetened beverages (final allocations are still determined by City Council).

2. Publishing an annual report regarding the implementation of the Board's recommendations and the impact on the use of these funds.

Revenues - In the first quarter (Q1) of FY 2024-25, collections from Measure HH came in at $1.35 million, which is 12.6% of the adjusted budget of $10.69 million. The adjusted budget includes $3.79 million in use of fund balance to cover carryforwards from FY 2023-24. Excluding Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 22

Special City Council Meeting
November 19, 2024
the use of the fund balance, the projected revenue from Measure HH for the year is expected to be $6.90 million which is at budget. The Measure HH Local Tax Adjusted Budget for FY 2024-25 closely mirrors the actual revenue collected in FY 2023-24, which was $6.88 million. This figure reflects an ongoing annual decline rate of approximately 8% since the measure's introduction in FY 2017-18.

Table 12: FY 2024-25 Measure HH (SSBT) Fund Revenues ($ in millions)

Revenue
Category
FY 2024-25
Adjusted
Budget
FY 2024-25 Q1
YTD Actuals
FY 2024-25 Q1
Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Local Tax 6.90 1.36 6.90 — — %
Interest Income — — — — — %
Miscellaneous
Revenue — (0.01) (0.01) (0.01) — %
Transfers from
Fund Balance 1.41 — — (1.41) (100.0) %
Project Offsets
& Carryforwards

2.38 — — (2.38) (100.0) %
Total Revenue 10.69 1.35 6.88 (3.81) (35.6) %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Expenditures - FY 2024-25 year-end expenditures are projected to come in at $8.41 million, which is a savings of $2.28 million, compared to the Adjusted Budget of $10.69 million. The savings are primarily due to underspending in personnel costs.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 23

Special City Council Meeting
November 19, 2024
Table 13: FY 2024-25 Measure HH (SSBT) Fund Expenditures ($ in millions) Agency / Department
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Capital Improvement
Projects 0.03 — 0.03 — — %
City Administrator 2.24 0.13 2.63 (0.39) (17.6) %
Economic and Workforce
Development Department 0.59 — 0.41 0.18 30.3 %
Finance Department 0.37 0.02 0.36 0.01 2.0 %
Human Services
Department

1.80 — 0.98 0.82 45.4 %
Non Departmental and
Port — — — — — %
Oakland Parks and
Recreation Department 5.63 0.69 3.95 1.67 29.7 %
Oakland Public Library
Department 0.04 — 0.04 — — %
Oakland Public Works
Department
— — — — — %
Total 10.69 0.84 8.41 2.28 21.3 %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Fund Balance - FY 2024-25 revenue is projected to end the year at $6.89 million. Expenditures are projected to end the year at $8.41 million. This results in an estimated current year shortfall of $1.52 million. As a result, the maximum estimated available fund balance in Measure HH (SSBT) Fund (1030) is projected to decrease from $11.65 million to $10.13 million in FY 2024-

25. There are $7.58 million of possible carry forwards from FY 2023-24 in this fund. If these are carried forward on to FY 2024-25 the fund balance would be reduced to the estimated minimum available fund balance of $2.55 million.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 24

Special City Council Meeting
November 19, 2024
Table 14: FY 2024-25 Measure HH (SSBT) Fund Year-End Available Fund Balance ($ in millions)

MEASURE HH SSBT (1030) FY 2024-25 Q1 Year-
End Estimate
Beginning Unassigned Fund Balance - Unaudited $ 11.65
Revenue 6.87
Expenditures 8.41
Estimated Current Year Surplus/(Shortfall) (1.52)
Estimated Maximum Ending Fund Balance 10.13

Possible Additional Use of Fund Balance in FY 2024-25
Possible FY 2023-24 Carry Forwards (7.58)
Estimated Minimum Ending Fund Balance 2.55

Measures BB & F Funds (2215, 2217, 2218, 2219, 2220)

Measure BB and F Funds are administered by the Alameda County Transportation Commission (Alameda CTC) which manages the following local fund sources:

1. Measure BB, passed by voters in November 2014, authorized collection of the initial half-cent transportation sales tax by the Board of Equalization. Collection began on April 1, 2015 and extended through March 31, 2022 as a compliment to Measure B which sunset in March 2022. The full one-cent sales tax authorized by Measure BB took effect April 1, 2022 and will extend through March 31, 2045. Starting in July 2015, Alameda CTC began making monthly direct local distribution payments to local jurisdictions and transit agencies, per the 2014 Transportation Expenditure Plan, for the following programs: local streets and roads (including county bridges), bicycle and pedestrian, transit, and paratransit.

2. Measure F, approved by voters in November 2010, authorizes the collection of $10 per year per vehicle registration fee to fund the Local Road Improvement & Repair Program and other congestion relief, transportation technology, and pedestrian/bicyclist safety programs in Alameda County.

Revenues - In the first quarter (Q1) of FY 2024-25, collections from Measure BB came in at $3.17 million, which is 6.0% of the Adjusted Budget of $53.21 million. Projected year-end revenues are $39.93 million, which is $13.28 million or 25.0% under the Adjusted Budget. The Adjusted Budget for FY 2024-25 includes $12.66 million in use of fund balance to balance expenditures adopted in the budget and an extra $2.86 million from the fund balance to cover carry forwards from FY 2023-24. Net of use of fund balance, Sales Tax from Measure BB and Measure F are projected to end the year at $37.57 million, which is $1.69 million or 4.7% over Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 25

Special City Council Meeting
November 19, 2024
the Adjusted Budget, according to the most recent estimates from the Alameda County Transportation Commission (ACTC).

Table 15: FY 2024-25 Measure BB & F Fund Revenues ($ in millions) Revenue Category
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Sales Tax 35.88 2.62 37.57 1.69 4.7 %
Interest Income — — — — — %
Service Charges — 0.03 0.03 0.03 — %
Grants & Subsidies 1.81 — 1.81 — — %
Miscellaneous Revenue — 0.51 0.51 0.51 — %
Transfers from Fund

12.66 — — (12.66) (100.0) %
Project Offsets &
Carryforwards 2.86 — — (2.86) (100.0) %
Total Revenue 53.21 3.17 39.93 (13.28) (25.0) %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Expenditures - FY 2024-25 year-end expenditures are projected to come in at $43.13 million, which is a savings of $10.09 million, compared to the Adjusted Budget of $53.21 million. The savings is primarily due to underspending in personnel costs.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 26

Special City Council Meeting
November 19, 2024
Table 16: FY 2024-25 Measure BB/F Funds Expenditures ($ in millions) Agency / Department
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Capital Improvement
Projects 8.23 0.03 8.32 (0.09) (1.1) %
City Administrator 0.41 0.05 0.24 0.17 41.1 %
City Attorney 0.05 — — 0.05 90.4 %
Department of
Transportation 37.47 4.95 27.89 9.57 25.5 %
Finance Department 0.01 — 0.01 — — %
Human Resources
Management
Department — — — — — %
Human Services
Department 4.38 0.27 4.21 0.18 4.1 %
Information Technology
Department — — — — — %
Mayor — — — — — %
Non Departmental and
Port — — — — — %
Oakland Public Works
Department 2.66 0.47 2.45 0.21 7.9 %
Police Department — — — — — %
Total Expenditures 53.21 5.77 43.13 10.09 19.0 %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Fund Balance - Fund Balance - FY 2024-25 revenue is projected to end the year at $39.93 million. Expenditures are projected to end the year at $43.13 million. This results in an estimated current year shortfall of $3.19 million. As a result, the maximum estimated available fund balance in the Measure BB/F Funds is projected to decrease from $57.73 million to $54.53 million in FY 2024-25. There are $34.70 million of possible carry forwards from FY 2023-24 in this fund. If these are carried forward on to FY 2024-25 the fund balance would be reduced to the estimated minimum available fund balance of $19.83 million.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 27

Special City Council Meeting
November 19, 2024
Table 17: FY 2024-25 Measure BB/F Funds Year-End Available Fund Balance ($ in millions)
Measure B/BB and Measure F Funds (2211, 2212, 2213, 2215, 2216, 2217, 2218, 2219, 2220)
FY 2024-25 Q1 Year-
End Estimate
Beginning Unassigned Fund Balance - Unaudited $ 57.73
Revenue 39.93
Expenditures 43.13
Estimated Current Year Surplus/(Shortfall) (3.19)
Estimated Maximum Ending Fund Balance 54.53
Possible Additional Use of Fund Balance in FY 2024-25
Possible FY 2023-24 Carry Forwards (34.70)
Estimated Minimum Ending Fund Balance 19.83

State Transportation Gas Tax Funds (2230, 2232)

The State of California imposes a per-gallon excise tax on gasoline and diesel fuel, sales taxes on gasoline and diesel fuel, and registration taxes on motor vehicles with allocations dedicated to transportation purposes. The local (city and county) portions of these allocations flow through the Highway Users Tax Account (HUTA) into the Gasoline Tax Fund (2230) and the Road Maintenance and Rehabilitation Account (RMRA) (Fund 2232), which allocates much of the revenue from the Road Repair and Accountability Act of 2017.

Revenues - In the first quarter (Q1) of FY 2024-25, revenue collections in the Gas Tax funds came in at $4.21 million, which is 16.3% of the FY 2024-25 Adjusted Budget of $25.78 million.

Year-end revenues project to come in at $24.32 million, which is $1.46 million or 5.7% under the Adjusted Budget. The Adjusted Budget assumes $1.87 million in use of fund balance to balance the expenditures as adopted in the budget and $0.97 million in use of fund balance to support FY 2023-24 carryforwards. Net of use of fund balance, the actual Gas Tax revenue projects to come in at $23.29 million which is $0.50 million or 2.2% above the Adjusted Budget estimate.

The new projection is taken from the estimates for FY 2024-25 provided by the State of California, for the State revenue allocations to Cities and Counties for the Local Streets and Roads including Highway Users Tax Account (HUTA), and for the Road Maintenance and Rehabilitation Account (RMRA). Estimates are as of May 2024.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 28

Special City Council Meeting
November 19, 2024
Table 18: FY 2024-25 State Transportation Gas Tax Fund Revenues ($ in millions) Revenue
Category
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Gas Tax 22.79 3.32 23.29 0.50 2.2 %
Interest Income

— — %
Service Charges 0.01

0.01 — — %
Grants &
Subsidies 0.14

— 0.14 — — %
Miscellaneous
Revenue

— 0.89 0.89 0.89 54182.7 %
Transfers from
Fund Balance 1.87

—

— (1.87) (100.0) %
Project Offsets &
Carryforwards 0.97

—

— (0.97) (100.0) %
Total Revenue 25.78 4.21 24.32 (1.46) (5.7) %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Expenditures - FY 2024-25 year-end expenditures are projected to come in at $19.71 million, which is a savings of $6.07 million, when compared to the Adjusted Budget of $25.78 million.

The savings is primarily due to underspending in personnel costs.

Table 19: FY 2024-25 State Transportation Funds Gas Tax Expenditures ($ in millions) Agency / Department
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Capital Improvement
Projects 0.01 — 0.01 — — %
City Administrator 0.19 0.03 0.17 0.02 11.2 %
Department of
Transportation 25.48 3.67 19.51 5.97 23.4 %
Economic and
Workforce
Development
Department — — — — — %
Finance Department 0.10 — 0.01 0.09 86.9 %
Human Resources
Management
Department — — — — — %
Oakland Public Works
Department
— — — — — %
Total Expenditures 25.78 3.70 19.71 6.07 23.6 %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 29

Special City Council Meeting
November 19, 2024
Fund Balance - FY 2024-25 revenue is projected to end the year at $24.32 million. Expenditures are projected to end the year at $19.71 million. This results in an estimated current year surplus of $4.61 million. The maximum estimated available fund balance in the State Transportation Gas Tax Funds is projected to increase from $11.84 million to $17.66 million in FY 2024-25 after accounting for $1.21 million returned from excess fund balance from the Equipment Fund.

There are $3.64 million of possible carry forwards from FY 2023-24 in this fund. If these are carried forward on to FY 2024-25 the fund balance would be reduced to the estimated minimum available fund balance of $14.02 million.

Table 20: FY 2024-25 State Transportation Funds Year-End Available Fund Balance ($ in millions)
State Transportation (Gas Tax) Funds (2230, 2232) FY 2024-25 Q1 Year- End Estimate
Beginning Unassigned Fund Balance - Unaudited $ 11.84
Revenue 24.32
Expenditures 19.71
Estimated Current Year Surplus/(Shortfall) 4.61
Estimated Subtotal Ending Fund Balance 16.45
Fund Balance Transfer In
Return of Excess Fund Balance in Equipment Fund 1.21
Estimated Maximum Ending Fund Balance 17.66

Possible Additional Use of Fund Balance in FY 2024-25
Possible FY 2023-24 Carry Forwards (3.64)
Estimated Minimum Ending Fund Balance 14.02

Measure Q - OPR Preservation, Litter Reduction, Homelessness Support Act Fund (2244)

Measure Q, the 2020 Oakland Parks and Recreation, Preservation, Litter Reduction, and Homelessness Support Act Fund (2244), is a City of Oakland ballot initiative approved by voters on March 3, 2020 that established an annual special parcel tax for 20 years. This measure, which passed by more than a two-thirds majority, imposes a special parcel tax for the purpose of raising revenue to provide services for parks, landscape maintenance, and recreational services; to address homelessness and enable unsheltered and unhoused residents to access temporary shelters, transitional, supportive, and permanent housing; and to address water quality and litter reduction, including the maintenance and cleaning of stormwater trash collection systems.

Revenues - In the first quarter (Q1) of FY 2024-25, revenue collections in the Measure Q fund have not come in yet, as they are remitted in bulk from the County typically at mid-year and towards the end of each fiscal year. Year-end revenues project to come in at $32.99 million, which is $21.32 million or 39.3% under the Adjusted Budget of $54.31 million. The Adjusted Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 30

Special City Council Meeting
November 19, 2024
Budget assumes $13.78 million in use of fund balance to balance expenditures as adopted in the budget and $7.52 million to support carryforward expenditures. The actual Measure Q Tax, net of use of fund balance, projects to come in at $33.01 million which is at budget.

Table 21: FY 2024-25 Preservation, Litter Reduction, Homelessness Support Act Fund Revenues ($ in millions)
Revenue
Category
FY 2024-25
Adjusted
Budget
FY 2024-25 Q1
YTD Actuals
FY 2024-25 Q1
Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Local Tax 33.01 (0.01) 33.01 — — %
Interest Income — — — — — %
Miscellaneous
Revenue — (0.02) (0.02) (0.02) — %
Transfers from

13.78 — — (13.78) (100.0) %
Project Offsets &
Carryforwards 7.52 — — (7.52) (100.0) %
Total Revenue 54.31 (0.03) 32.99 (21.32) (39.3) %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Expenditures - FY 2024-25 year-end expenditures are projected to come in at $52.05 million, which is a savings of $2.25 million, when compared to the Adjusted Budget of $54.31 million.

The savings are primarily due to underspending in personnel costs.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 31

Special City Council Meeting
November 19, 2024
Table 22: FY 2024-25 Measure Q - OPR Preservation, Litter Reduction, Homelessness Support Act Fund Expenditures ($ in millions)
Agency / Department
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Capital Improvement
Projects 4.33 0.03 4.33 — — %
City Administrator 4.67 0.33 4.60 0.07 1.5 %
City Auditor 0.04 — — 0.04 95.2 %
Economic and
Workforce
Development
Department 0.11 — 0.01 0.11 95.5 %
Finance Department 0.08 — 0.08 — — %
Human Services
Department 12.05 0.39 11.87 0.18 1.5 %
Non Departmental and
Port 0.86 — 0.86 — — %
Oakland Parks and
Recreation Department — — — — — %
Oakland Public Works
Department 32.16 5.08 30.26 1.90 5.9 %
Total Expenditures 54.31 5.84 52.05 2.25 4.1 %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Fund Balance - FY 2024-25 revenue is projected to end the year at $32.99 million. Expenditures are projected to end the year at $52.05 million. This results in an estimated current year shortfall of $19.07 million. The maximum estimated available fund balance in Measure Q Fund (2244) is projected to decrease from $26.55 million into $7.91 million in FY 2024-25 after accounting for $0.42 million returned from excess fund balance in the Equipment Fund. There are $10.32 million of possible carry forwards from FY 2023-24 in this fund. If these are carried forward on to FY 2024-25 the fund balance would be reduced to the estimated minimum available fund balance of negative $2.41 million.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 32

Special City Council Meeting
November 19, 2024
Table 23: FY 2024-25 Measure Q Year-End Fund Balance ($ in millions) MEASURE Q (2244) FY 2024-25 Q1 Year-
End Estimate
Beginning Unassigned Fund Balance - Unaudited 26.55
Revenue 32.99
Expenditures 52.05
Estimated Current Year Surplus/(Shortfall) (19.07)
Estimated Subtotal Ending Fund Balance 7.49
Fund Balance Transfer In
Return of Excess Fund Balance in Equipment Fund 0.42
Estimated Maximum Ending Fund Balance 7.91

Possible Additional Use of Fund Balance in FY 2024-25
Possible FY 2023-24 Carry Forwards (10.32)
Estimated Minimum Ending Fund Balance (2.41)

Vacant Property Tax Fund (2270)

Measure W - Vacant Property Tax Fund (2270) is a City of Oakland ballot initiative approved by voters on November 6, 2018 that established an annual special tax on vacant property for 20 years to raise revenue necessary to support and fund homelessness programs and services, affordable housing, code enforcement, and clean-up of blighted properties and illegal dumping.

A property is considered vacant if it is not in-use for at least 50 days in a calendar year. "Use" is defined as the performance of a function or operation. The per-parcel tax rates are $6,000 for vacant properties or lots and $3,000 for vacant condominium, duplex, townhouse and commercial ground floor commercial spaces. The tax is included in the secured property tax bill administered by the Alameda County.

Revenues - In the first quarter (Q1) of FY 2024-25, revenue collections in the Vacant Property Tax fund have not come in yet, as they are remitted in bulk from the County typically at mid-year and towards the end of each fiscal year. Year-end revenues project to come in at $5.36 million, which is $0.94 million or 14.9% under the FY 2024-25 Adjusted Budget of $6.30 million, The Adjusted Budget assumes $0.24 million in use of fund balance to balance expenditures as adopted in the budget, and $0.70 million to support carryforward expenditures. Net of use of fund balance, the actual Vacant Property Tax projects to come at $5.36 million which is at budget.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 33

Special City Council Meeting
November 19, 2024
Table 24: FY 2024-25 Vacant Property Tax Fund Revenues ($ in millions) Revenue Category
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Local Tax 5.36 (0.02) 5.36 — — %
Miscellaneous
Revenue — — — — — %
Transfers from Fund
Balance 0.24 — — (0.24) (100.0) %
Project Offsets &
Carryforwards

0.70 — — (0.70) (100.0) %
Total Revenue 6.30 (0.02) 5.36 (0.94) (14.9) %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Expenditures - FY 2024-25 year-end expenditures are projected to come in at $6.26 million, which is savings of $0.04 million, when compared to the Adjusted Budget of $6.30 million.

Table 25: FY 2024-25 Vacant Property Tax Fund Expenditures ($ in millions) Agency / Department
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
City Administrator — — — — — %
Finance Department 0.85 0.10 0.75 0.10 12.2 %
Human Services
Department 0.24 — 0.29 (0.05) (19.1) %
Oakland Public Works
Department 5.03 1.04 5.05 (0.02) (0.3) %
Total Expenditures 6.30 1.15 6.26 0.04 0.6 %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Fund Balance - FY 2023-24 revenue is projected to end the year at $5.36 million. Expenditures are projected to end the year at $6.26 million. This results in an estimated current year shortfall of $0.90 million. The maximum estimated available fund balance in the Vacant Property Tax Fund (2270) is projected to decrease from $2.51 million to $1.65 million in FY 2024-25 after accounting for $0.04 million returned from excess fund balance in the Equipment Fund. There are $0.05 million of possible carry forwards from FY 2023-24 in this fund. If these are carried forward on to FY 2024-25 the fund balance would be reduced to the estimated minimum available fund balance of $1.60 million.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 34

Special City Council Meeting
November 19, 2024
Table 26: FY 2024-25 Vacant Property Tax Fund Year-End Available Fund Balance ($ in millions)
Vacant Property Tax Fund (2270) FY 2024-25 Q1 Year-
End Estimate
Beginning Unassigned Fund Balance - Unaudited 2.51
Revenue 5.36
Expenditures 6.26
Estimated Current Year Surplus/(Shortfall) (0.90)
Estimated Subtotal Ending Fund Balance 1.61
Fund Balance Transfer In
Return of Excess Fund Balance in Equipment Fund 0.04
Estimated Maximum Ending Fund Balance 1.65

Possible Additional Use of Fund Balance in FY 2024-25
Possible FY 2023-24 Carry Forwards (0.05)
Estimated Minimum Ending Fund Balance 1.60

Landscaping and Lighting Assessment District (LLAD) Fund (2310)

The Landscaping and Lighting Assessment District (LLAD) Fund (2310) revenue is generated through a direct benefit assessment, or special assessment and is restricted by statue to be used for street lighting, landscaping, and public parks and recreation facility maintenance, and multi-use fields.

Revenues – In the first quarter (Q1) of FY 2024-25, revenue collections in the LLAD fund have not come in yet, as they are remitted in bulk from the County typically at mid-year and towards the end of each fiscal year. The FY 2024-25 year-end revenues project to come in at $19.75 million, which is $0.22 million below the FY 2024-25 Adjusted Budget of $19.98 million. The Adjusted Budget assumes $0.22 million in use of fund balance to support carryforward expenditures. Net of use of fund balance, the actual LLAD Tax projects to come at $19.47 million which is at budget.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 35

Special City Council Meeting
November 19, 2024
Table 27: FY 2024-25 Landscaping and Lighting Assessment District (LLAD) Fund Revenue ($ in millions)
Revenue
Category
FY 2024-25
Adjusted
Budget
FY 2024-25 Q1
YTD Actuals
FY 2024-25 Q1
Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Local Tax 19.47 — 19.47 — — %
Licenses &
Permits 0.08 0.03 0.08 — — %
Interest Income — — — — — %
Service Charges 0.21 — 0.21 — — %
Grants &
Subsidies — — — — — %
Miscellaneous
Revenue
— — — — — %
Project Offsets &
Carryforwards 0.22 — — (0.22) (100.0) %
Total Revenue 19.98 0.03 19.75 (0.22) (1.1) %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Expenditures - FY 2024-25 year-end expenditures are projected to come in at $21.25 million, which is an overage of $1.28 million, when compared to the Adjusted Budget of $19.98 million.

Table 28: FY 2024-25 Landscaping and Lighting Assessment District (LLAD) Fund Expenditures ($ in millions)
Agency / Department
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Department of
Transportation 2.56 0.85 3.60 (1.04) (40.5) %
Finance Department 0.04 0.01 0.04 — — %
Non Departmental and
Port 3.27 — 3.27 — — %
Oakland Parks and
Recreation Department 9.87 — 9.87 — — %
Oakland Public Works
Department 4.24 1.13 4.48 (0.24) (5.7) %
Total Expenditures 19.98 1.99 21.25 (1.28) (6.4) %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Fund Balance - FY 2024-25 revenue is projected to end the year at $19.75 million. Expenditures projected to end the year at $21.25 million. This results in an estimated current year shortfall of $1.50 million. The maximum estimated available fund balance in the LLAD Fund is projected to improve slightly from negative $0.59 million to negative $0.39 million in FY 2024-25 after accounting for $1.70 million returned from excess fund balance in the Equipment Fund. There Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 36

Special City Council Meeting
November 19, 2024
are $0.09 million of possible carry forwards from FY 2023-24 in this fund. If these are carried forward on to FY 2024-25 the fund balance would be reduced to the estimated minimum available fund balance of negative $0.48 million.

Table 29: FY 2024-25 Landscaping and Lighting Assessment District (LLAD) Fund Balance ($ in millions)
Landscaping & Lighting Assess. District Fund (LLAD) (2310) FY 2024-25 Q1 Year- End Estimate
Beginning Unassigned Fund Balance - Unaudited (0.59)
Revenue 19.75
Expenditures 21.25
Estimated Current Year Surplus/(Shortfall) (1.50)
Estimated Subtotal Ending Fund Balance (2.09)

Fund Balance Transfer In
Return of Excess Fund Balance in Equipment Fund 1.70
Estimated Maximum Ending Fund Balance (0.39)

Possible Additional Use of Fund Balance in FY 2024-25
Possible FY 2023-24 Carry Forwards (0.09)
Estimated Minimum Ending Fund Balance (0.48)

False Alarm Reduction Program Fund (2411)

The False Alarm Reduction Program was implemented by OPD in November 2003 by Ordinance No. 13015 C.M.S., and amended in 2010, to address the large number of false alarms that OPD was responding to each year. The revenue generated by these fees is to offset a portion of the expense that OPD incurs as a result of false alarm response. Fees also assist in encouraging residents and businesses to properly use and maintain their alarm systems, thus reducing false alarms.

Revenues - In the first quarter (Q1) of FY 2024-25, revenue collections in the False Alarm Reduction Fund came in at $0.18 million, which is 12.2% of the FY 2024-25 Adjusted Budget of $1.47 million. The FY 2024-25 year-end revenues project to come in at $0.95 million, which is $0.52 million or 35.3% lower compared to the FY 2024-25 Adjusted Budget of $1.47 million. The Adjusted Budget assumes 0.70 million in use of fund balance to support carryforward expenditures. Net of use of fund balance, the actual Service Charges for the program project to come at $0.83 million which is $0.44 million or 34.7% under budget. The projection assumes the same level of collection from FY 2023-24 which was the lowest level of service charges collected over the past five fiscal years. However, this is cautiously optimistic since revenues from service charges in this fund have been dropping year over year by an average of 12.4% over the past 5 fiscal years.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 37

Special City Council Meeting
November 19, 2024

Table 30: FY 2024-25 False Alarm Reduction Program Fund Revenue ($ in millions) Revenue
Category
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25 Q1
Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Fines & Penalties 0.12 — 0.12 — — %
Interest Income — — — — — %
Service Charges 1.27 0.18 0.83 (0.44) (34.7) %
Miscellaneous
Revenue — — — — — %
Project Offsets &
Carryforwards 0.08 — — (0.08) (100.0) %
Total Revenue 1.47 0.18 0.95 (0.52) (35.3) %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Expenditures - FY 2024-25 year-end expenditures are projected to come in at $0.79 million, which is a savings of $0.68 million, compared to the Adjusted Budget of $1.47 million. The savings are primarily due to underspending in personnel costs.

Table 31: FY 2024-25 False Alarm Reduction Program Fund Expenditures ($ in millions) Agency / Department
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Information Technology
Department — 0.01 0.04 (0.04) — %
Police Department 1.47 0.09 0.75 0.72 48.9 %
Total Expenditures 1.47 0.10 0.79 0.68 46.1 %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Fund Balance - FY 2024-25 revenue is projected to end the year at $0.95 million. Expenditures projected to end the year at $0.79 million. This results in an estimated current year surplus of $0.16 million. As a result, the maximum estimated negative fund balance in False Alarm Reduction Program Fund (2411) is projected to slightly improve from negative $3.99 million to negative $3.83 million in FY 2024-25. There are $0.36 million of possible carry forwards from FY 2023-24 in this fund. If these are carried forward on to FY 2024-25 the fund balance would be reduced to the estimated minimum available fund balance of negative $4.19 million.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 38

Special City Council Meeting
November 19, 2024
Table 32: FY 2024-25 False Alarm Reduction Program Fund Balance ($ in millions) False Alarm Reduction Fund (2411) FY 2024-25 Q1 Year-
End Estimate
Beginning Unassigned Fund Balance - Unaudited (3.99)
Revenue 0.95
Expenditures 0.79
Estimated Current Year Surplus/(Shortfall) 0.16
Estimated Maximum Ending Fund Balance (3.83)

Possible Additional Use of Fund Balance in FY 2024-25
Possible FY 2023-24 Carry Forwards (0.36)
Estimated Minimum Ending Fund Balance (4.19)

Development Service Fund (2415)

The Development Service Fund (2415) was created on June 20, 2006 by Ordinance No. 12741 C.M.S. This fund collects revenues from licenses, fees, and permits from housing and commercial planning and construction-related activities to support planning and zoning services, construction inspections and permit approvals, building code enforcement, plan checks and engineering services. This fund is required to keep a minimum 7.5% reserve of annual budgeted revenues for its balance, which would be $5.95 million in FY2024-25.

Table 33: Historical Revenue for Fund 2415
Fiscal Year Budgeted Revenue Projected Year End Revenue FY 2024-25 79.38 64.66
FY 2023-24 73.02 52.98
FY 2021-22 63.98 73.94
FY 2020-21 47.33 50.25
FY 2019-20 61.58 60.71
FY 2018-19 49.92 63.20
FY 2017-18 45.14 90.13
FY 2016-17 38.03 77.15

Revenues - In the first quarter (Q1) of FY 2024-25, revenue collections in the Development Services Fund came in at $14.32 million, which is 12.0% of the FY 2024-25 Adjusted Budget of $119.34 million. Year-end revenues project to come in at $64.66 million, which is $54.68 million or 45.8% under the Adjusted Budget. The Adjusted Budget assumes $25.53 million in use of fund balance to balance expenditures as adopted in the budget and $14.44 million in use of fund balance to support FY 2023-24 carryforward expenditures. The year-end projection assumes the same level of collection from FY 2023-24 for Service Charges, Licenses and Permits, Fines and Penalties, and Interest Income. These categories combined are projected to end FY 2024-25 at 81.2% of the Adjusted Budget.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 39

Special City Council Meeting
November 19, 2024

Table 34: FY 2024-25 Development Service Fund Revenues ($ in millions) Revenue Category
FY 2024-25
Adjusted
Budget
FY 2024-25 Q1
YTD Actuals
FY 2024-25 Q1
Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Licenses & Permits 41.77 7.42 25.45 (16.32) (39.1) % Fines & Penalties 0.65 0.76 2.53 1.88 288.9 %
Interest Income — — 5.48 5.48 — %
Service Charges 35.99 6.19 30.23 (5.76) (16.0) %
Grants & Subsidies — — — — — %
Miscellaneous
Revenue 0.27 (0.04) 0.27 — — %
Transfers from Fund

25.53 — — (25.53) (100.0) %
Project Offsets &
Carryforwards 14.44 — — (14.44) (100.0) %
Total Revenue 119.34 14.32 64.66 (54.68) (45.8) %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Expenditures - FY 2024-25 year-end expenditures project to come in at $103.27 million, which is a savings of $16.07 million, compared to the adjusted budget of $119.34 million. The projected savings are mainly attributed to vacancies.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 40

Special City Council Meeting
November 19, 2024
Table 35: FY 2024-25 Development Service Fund Expenditures ($ in millions) Agency /
Department
FY 2024-25
Adjusted
Budget
FY 2024-25 Q1
YTD Actuals
FY 2024-25 Q1
Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
City Administrator 3.61 0.77 3.56 0.05 1.4 %
City Attorney 3.83 0.91 3.99 (0.15) (4.0) %
City Auditor 0.05 — 0.03 0.03 52.2 %
Department of
Transportation 15.89 1.97 11.11 4.78 30.1 %
Economic and
Workforce
Development
Department

2.92 0.65 2.79 0.14 4.6 %
Finance Department 1.31 0.25 1.34 (0.03) (2.1) %
Fire Department 8.02 1.54 7.91 0.11 1.4 %
Human Resources
Management
Department — — — — — %
Information
Technology
Department 3.84 0.63 3.22 0.62 16.2 %
Mayor — 0.04 0.16 (0.16) — %
Non Departmental
and Port

1.84 0.06 1.84 — — %
Oakland Public
Works Department 3.09 0.37 2.83 0.25 8.2 %
Planning and
Building Department 74.84 10.05 64.41 10.43 13.9 % Total Expenditures 119.34 17.23 103.27 16.07 13.5 % *The adjusted budget includes Council Budget Amendments and Carryforwards

Fund Balance - The large fund balance, $122.38 million at the end of FY 2023-24, has accumulated over the life of the fund due to revenues exceeding the budget as well as longstanding underspending or delays in expenditures attributed to a high number of vacancies within the Planning and Building Department. This fund is required to keep a minimum 7.5% reserve of annual budgeted revenues for its balance, which would be $5.95 million in FY 2024-

25. FY 2024-25 revenue projects to end the year at $64.66 million. Expenditures project to end the year at $103.27 million. This results in an estimated current year shortfall of $38.61 million. This results in an estimated current year shortfall of $38.61 million. The maximum estimated available fund balance in the Development Service Fund (2415) projects to decrease from $104.90 million to $66.49 million in FY 2024-25 after accounting for $0.21 million returned from excess fund balance in the Equipment Fund. There are $25.38 million of possible carry forwards Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 41

Special City Council Meeting
November 19, 2024
from FY 2023-24 in this fund. If these are carried forward on to FY 2024-25 the fund balance would be reduced to the estimated minimum available fund balance of $43.11 million.

Table 36: FY 2024-25 Development Service Fund Year-End Available Fund Balance ($ in millions)

Development Service Fund Fund (2415) FY 2024-25 Q1 Year-End Estimate
Beginning Unassigned Fund Balance - Unaudited $ 104.90
Revenue 64.66
Expenditures 103.27
Estimated Current Year Surplus/(Shortfall) (38.61)
Estimated Subtotal Ending Fund Balance 66.28

Fund Balance Transfer In
Return of Excess Fund Balance in Equipment Fund 0.21
Estimated Maximum Ending Fund Balance 68.49

Possible Additional Use of Fund Balance in FY 2024-25
Possible FY 2023-24 Carry Forwards (25.38)
Estimated Minimum Ending Fund Balance 43.11

Transient Occupancy Tax (Measure C) Fund (2419)

The Transient Occupancy Tax (Hotel Tax) Fund (2419) is a City of Oakland initiative approved by voters in July 2009 that imposed a 3% special transient occupancy tax on the privilege of renting a hotel room in the City. The revenue generated by this special tax is allocated as follows: 50% to the Oakland Convention and Visitor’s Bureau for its expenses and promotion of tourism activities, and 12.5% each to the Oakland Zoo, the Oakland Museum of California, the Chabot Space and Science Center and the City’s Cultural Arts Programs and Festivals.

Revenues - In the first quarter (Q1) of FY 2024-25, revenue collections in the Measure C have come in at $0.85 million or 15.8% of the Adjusted Budget of $5.38 million. The FY 2024-25 year-end revenues project to come in at $4.77 million, which is $0.61 million or 11.3% under the Adjusted Budget resembling the estimated shortfall for TOT in the GPF.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 42

Special City Council Meeting
November 19, 2024
Table 37: FY 2024-25 Transient Occupancy Tax (Measure C) Fund Revenues ($ in millions) Revenue
Category
FY 2024-25
Adjusted
Budget
FY 2024-25 Q1
YTD Actuals
FY 2024-25 Q1
Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Transient
Occupancy Tax 5.38 0.85 4.77 (0.61) (11.3) %
Interest Income — — — — — %
Miscellaneous
Revenue
— — — — — %
Project Offsets
& Carryforwards
— — — — — %
Total Revenue 5.38 0.85 4.77 (0.61) (11.3) %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Expenditures - FY 2024-25 year-end expenditures are projected to come in at $5.26 million, which is a savings of $0.12 million, compared to the Adjusted Budget of $5.38 million. The savings are primarily due to underspending in personnel costs.

Table 38: FY 2024-25 Transient Occupancy Tax (Measure C) Fund Expenditures ($ in millions)
Agency / Department
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Economic and
Workforce
Development
Department 0.67 0.02 0.55 0.12 17.7 %
Non Departmental and
Port 4.71 — 4.71 — — %
Total Expenditures 5.38 0.02 5.26 0.12 2.2 %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Fund Balance - FY 2024-25 revenues are projected to end the year at $4.77 million.

Expenditures are projected to end the year at $5.26 million. This results in an estimated current year shortfall of $0.49 million. As a result, the maximum estimated available fund balance in the Measure C Fund (2419) is projected to decrease from $1.89 million to $1.40 million in FY 2024-

25. There are $0.67 million of possible carry forwards from FY 2023-24 in this fund. If these are carried forward on to FY 2024-25 the fund balance would be reduced to the estimated minimum available fund balance of $0.73 million.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 43

Special City Council Meeting
November 19, 2024
Table 39: FY 2024-25 Transient Occupancy Tax (Measure C) Fund Year-End Available Fund Balance ($ in millions)
Measure C - Transient Occupancy Tax (TOT) Surcharge Fund (2419) FY 2024-25 Q1 Year- End Estimate
Beginning Unassigned Fund Balance - Unaudited $ 1.89
Revenue 5.38
Expenditures 5.26
Estimated Current Year Surplus/(Shortfall) (0.49)
Estimated Maximum Ending Fund Balance 1.40

Possible Additional Use of Fund Balance in FY 2024-25
Possible FY 2023-24 Carry Forwards (0.67)
Estimated Minimum Ending Fund Balance 0.73

Equipment Fund (4100)

The Equipment Fund (4100) is reported on a modified full accrual basis to reflect current assets and liabilities. The Fund supports the Citywide function for procurement and maintenance of City-owned equipment. Revenues are generated by charges to internal user departments.

Revenues - In the first quarter (Q1) of FY 2024-25, revenue collections in the Equipment Fund have come in at $7.74 million or 20.5% of the Adjusted Budget of $37.83 million. The FY 2024- 25 year-end revenues project to come in at $29.23 million, which is $8.61 million under the FY 2024-25 Adjusted Budget. The Adjusted Budget assumes $2.87 million in use of fund balance to balance expenditures as adopted in the budget and $5.66 million in use of fund balance to support FY 2023-24 carryforward expenditures. Net of use of fund balance, the actual internal service fund revenues are expected to come in at $29.23 million, which is at budget since the cost recovery of the ISF funds is built into the budget.

Table 40: FY 2024-25 Equipment Fund Revenues ($ in millions) Revenue Category
FY 2024-25
Adjusted
Budget
FY 2024-25 Q1
YTD Actuals
FY 2024-25 Q1
Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget Licenses & Permits 0.07 — — (0.07) (100.0) % Internal Service

29.23 7.75 29.23 — — %
Miscellaneous
Revenue — (0.01) (0.01) — — %
Transfers from Fund

2.87 — — (2.87) (100.0) %
Project Offsets &
Carryforwards 5.66 — — (5.66) (100.0) %
Total Revenue 37.83 7.74 29.23 (8.61) (22.8) %

Expenditures - FY 2024-25 expenditures are projected to end the year at $35.74 million, which Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 44

Special City Council Meeting
November 19, 2024
is a savings of $2.09 million, compared to the Adjusted Budget of $37.83 million. The savings are primarily due to underspending in personnel costs.

Table 41: FY 2024-25 Equipment Fund Expenditures ($ in millions) Agency /
Department
FY 2024-25
Adjusted
Budget
FY 2024-25 Q1
YTD Actuals
FY 2024-25 Q1
Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Fire Department 0.05 — 0.05 — — %
Non Departmental
and Port 2.37 — 2.37 — — %
Oakland Public
Works Department 35.41 6.49 33.32 2.09 5.9 %
Total 37.83 6.49 35.74 2.09 5.5 %

Fund Balance - FY 2024-25 revenue is projected to end the year at $29.23 million. Expenditures ended the year at $35.74 million. This results in an estimated current year shortfall of $6.51 million. As a result, the maximum estimated available fund balance in the Equipment Fund (4100) is estimated to decrease from $46.24 million to $39.72 million in FY 2024-25.

Table 42: FY 2024-25 Equipment Fund Year-End Available Fund Balance ($ in millions) Equipment Fund (4100) FY 2024-25 Q1 Year-End
Estimate

Beginning Unassigned Fund Balance - Unaudited $ 46.02 Revenue 29.23
Expenditures 35.74
Estimated Current Year Surplus/(Shortfall) (6.51)
Estimated Maximum Ending Fund Balance 39.51

Fund Balance Transfer Out
Return of Excess Fund Balance out of the Equipment Fund (17.73)

Possible Additional Use of Fund Balance in FY 2024-25
Possible FY 2023-24 Carry Forwards (7.43)
Estimated Minimum Ending Fund Balance 14.35

The large fund balance, $46.02 million at the end of FY 2023-24, has accumulated over the life of the fund due to revenues exceeding the budget as well as longstanding underspending or delays in expenditures. The fund balance accumulated over the past three fiscal years is being returned back to the fund that was originally charged. The breakdown can be seen in Table 41 below. As a result, the estimated ending fund balance in the Equipment Fund in FY2024-25 is estimated to be reduced to $21.78 million. There are $7.43 million of possible carry forwards Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 45

Special City Council Meeting
November 19, 2024
from FY 2023-24 in this fund. If these are carried forward on to FY 2024-25 the fund balance would be further reduced to the estimated minimum available fund balance of $14.35 million.

Table 43: Fund Balance Return from Equipment Fund
FY 2021-22 FY 2022-23 FY 2023-24
Beginning Fund Balance 9,361,320 25,229,953 27,345,262 Ending Fund Balance 25,229,953 27,345,262 40,361,180 Overage to Redistribute 15,868,633 2,115,309 13,015,918 Less: Restricted Funds (4,424,014) (4,424,014 (4,424,014) Net Overage to Redistribute 11,444,619 (2,308,705 8,591,904 Fund Balance Redistribution by Fund
1010 - General Fund: General Purpose 5,718,469 (1,128,927 3,872,173 1710 - Recycling Program 5,317 (1,041 4,119
1720 - Comprehensive Clean-up 2,555,347 (511,949 1,683,667 1760 - Telecommunications Reserve 3,278 (647 2,388
1870 - Affordable Housing Trust Fund 13,806 (2,727 — 2108 - HUD-CDBG — — —
2128 - Department of Health and Human
Services 66,589 (13,227) 3,666
2211 - Measure B: Local Streets & Roads 2,927 — —
2218 - Measure BB - Local Streets and Roads 9,467 (2,631 8,964 2230 - State Gas Tax 178,585 (35,258) 119,691
2232 - Gas Tax RMRA 517,589 (155,199 582,830
2244 - Measure Q - Parks & Recreation
Preservation, Litter Reduction, and
Homelessness Support Act 196,977 (38,134) 261,604
2270 - Vacant Property Tax Act Fund 39,928 — —
2310 - Lighting and Landscape Assessment
District 797,524 (157,229 1,059,274
2332 - Gateway Industrial Park 87 (87) 830
2411 - False Alarm Reduction Program 2,587 (510 —
2415 - Development Service Fund 143,388 (28,834) 98,515 2416 - Traffic Safety Fund 10,583 (2,089 —
3100 - Sewer Service Fund 774,289 (152,892 571,286
3200 - Golf Course 2,915 (576 2,127
4100 - Equipment 126,224 (24,922) 111,387
4200 - Radio / Telecommunications 12,183 (2,405 12,340 4400 - City Facilities 186,125 (32,986) 140,371
4500 - Central Stores 2,302 (454 1,677
7760 - Grant Clearing 78,132 (15,978) 54,996
Total 11,444,619 (2,308,705 8,591,904

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 46

Special City Council Meeting
November 19, 2024
City Facilities Fund (4400)

The Facilities Fund (4400) is reported on a modified full accrual basis to reflect current assets and liabilities. The Fund supports the Citywide function for building maintenance and janitorial services of City-owned facilities. Revenues are generated by charges to internal user departments.

Revenues - In the first quarter (Q1) of FY 2024-25, revenue collections in the City Facilities Fund have come in at $0.21 million or 0.3% of the Adjusted Budget of $56.82 million. The FY 2024-25 year-end revenues project to come in at $50.69 million, which is $0.21 million lower than the FY 2024-25 Adjusted Budget. The Adjusted Budget assumes $6.13 million in use of fund balance to balance carryforward expenditures. The actual internal service fund revenues are expected to come in at $50.14 million which is at budget since the cost recovery of the ISF funds is built into the budget.

Table 44: FY 2024-25 City Facilities Fund Revenues ($ in millions) Revenue
Category
FY 2024-25
Adjusted
Budget
FY 2024-25 Q1
YTD Actuals
FY 2024-25 Q1
Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Interest Income — — — — — %
Service
Charges 0.55 0.21 0.55 — — %
Internal Service
Funds 50.14 — 50.14 — — %
Miscellaneous

— — — — — %
Project Offsets
& Carryforwards 6.13 — — (6.13) (100.0) %
Total Revenue 56.82 0.21 50.69 (6.14) (10.8) %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Expenditures - FY 2024-25 expenditures are projected to end the year at $50.93 million, which is a savings of $5.89 million, compared to the Adjusted Budget of $56.82 million. The savings are primarily due to underspending in personnel costs.

Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 47

Special City Council Meeting
November 19, 2024
Table 45: FY 2024-25 City Facilities Fund Expenditures ($ in millions) Agency / Department
FY 2024-25
Adjusted
Budget
FY 2024-25
Q1 YTD
Actuals
FY 2024-25
Q1 Year-End
Estimate
Year-End $
Over / Under
Adjusted
Budget
Year-End %
Over / Under
Adjusted
Budget
Capital Improvement
Projects 0.92 0.01 0.92

— — %
City Administrator 0.43 0.06 0.30 0.13 29.7 %
Human Resources
Management
Department — — — — — %
Human Services
Department 0.68 0.13 0.64 0.04 5.5 %
Non Departmental and
Port 1.72 — 0.06 1.67 96.7 %
Oakland Parks and
Recreation Department
— — — — — %
Oakland Public Works
Department 53.06 8.51 48.99 4.07 7.7 %
Police Department 0.01 — 0.03 (0.01) (125.0) %
Total 56.82 8.71 50.93 5.89 10.4 %
*The adjusted budget includes Council Budget Amendments and Carryforwards

Fund Balance - FY 2024-25 revenue is projected to end the year at $50.69 million. Expenditures ended the year at $50.93 million. This results in an estimated current year shortfall of $0.25 million. The maximum estimated available fund balance in the Reproduction Fund (4400) is estimated to increase from $5.18 million to $5.22 million in FY 2024-25 after accounting for $0.29 million returned from excess fund balance in the Equipment Fund. There are $1.70 million in possible carry forwards from FY 2023-24 in this fund. If these are carried forward on to FY 2024-25 the fund balance would be reduced to the estimated minimum available fund balance of $3.52 million.

Table 46: FY 2024-25 Facilities Fund Year-End Available Fund Balance ($ in millions) City Facilities Fund (4400) FY 2024-25 Q1 Year-
End Estimate
Beginning Unassigned Fund Balance - Unaudited $ 5.18
Revenue 50.69
Expenditures 50.93
Estimated Current Year Surplus/(Shortfall) (0.25)
Estimated Subtotal Ending Fund Balance 4.93

Fund Balance Transfer In
Return of Excess Fund Balance in Equipment Fund 0.29
Estimated Maximum Ending Fund Balance 5.22
Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 48

Special City Council Meeting
November 19, 2024

Possible Additional Use of Fund Balance in FY 2024-25
Possible FY 2023-24 Carry Forwards (1.70)
Estimated Minimum Ending Fund Balance 3.52

All Other Funds – Fund Balance Summary

Table 47: FY 2024-25 All Other Funds Year-End Available Fund Balances ($ in millions)

Fund Description
FY24-25 Beg
Unaudited
Fund
Balance
FY24-25
Year End
Rev
Projections
FY24-25
Year End
Exp
Projections
FY24-25 Year
End Estimated
Fund Balance
Eligible
Possible
Carryforward
1020 - Vital Services
Stabilization Fund

503,081

-

-

503,081 -
1100 - Self Insurance
Liability

23,097,126

61,500,607

61,500,607

23,097,126 (3,095,436)
1150 - Worker's
Compensation
Insurance Claims

(58)

60 9,811,061

(9,811,059) -
1200 - Pension
Override Tax
Revenue

381,185,390

94,263,973

94,263,973

381,185,390 -
1610 - Successor
Redevelopment
Agency
Reimbursement
Fund

(128,197)

1,464,323

1,094,152

241,974 -
1700 - Mandatory
Refuse Program

(1,086,174)

2,379,008

2,373,931

(1,081,097) -
1710 - Recycling
Program

5,140,168

6,927,114

6,407,132

5,660,150 836,332
1720 -
Comprehensive
Clean-up

(1,964,763)

28,175,650

25,353,421 857,466 50,712
1750 - Multipurpose
Reserve

(8,866,610)

8,861,043

9,150,927

(9,156,494) 119,415
1760 -
Telecommunications
Reserve

(1,242,485)

1,312,186

1,234,539

(1,164,839) 62,896
1770 -
Telecommunications
Land Use

1,928,286

873,313

882,417

1,919,182 -
1780 - Kid's First
Oakland Children's
Fund

18,744,492

23,565,016

27,577,776

14,731,732 12,248,501
1820 - OPRCA Self
Sustaining
Revolving Fund

2,801,001

11,278,356

11,841,421

2,237,936 23,600
1870 - Affordable
Housing Trust Fund

37,489,372

16,668,545

16,520,513

37,637,403 31,858,975
1871 - Jobs Housing
Impact Fee Fund

7,145,073

65,000

65,000

7,145,073 9,863,040
Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 49

Special City Council Meeting
November 19, 2024
1872 - Affordable
Housing Impact Fee
Fund

9,504,140

3,150,000

3,150,000

9,504,140 12,426,325
1882 - Multi Service
Center/Rent

108,318

107,050

122,437

92,931 162,242
1885 - 2011A-T
Subordinated
Housing

23,870,041

748,351

1,003,432

23,614,960 1,482,126
2102 - Department of
Agriculture

(483,872)

8,426,870

7,510,366

432,632 383,046
2103 - HUD-

ESG/SHP/HOPWA

(12,822,141)

14,606,226

27,085,969

(25,301,884) 6,924,298
2108 - HUD-CDBG
(4,826,375)

8,334,410

9,011,380

(5,503,345) 1,984,503
2109 - HUD-Home
1,532,536

2,921,719

2,955,081

1,499,174 24,058,773
2112 - Department of
Justice

(2,138,556)

998,344

2,159,254

(3,299,466) 2,814,243
2120 - Federal
Action Agency

(155,157)

591,147

764,910

(328,920) 431,825
2123 - US Dept of
Homeland Security

(617,096)

52,000

1,225,610

(1,790,706) 661,834
2124 - Federal
Emergency
Management
Agency (FEMA)

(606,220)

8,861,942

5,229,447

3,026,275 20,150,147
2128 - Department of
Health and Human
Services

(2,179,487)

18,803,247

21,890,299

(5,266,540) 21,248,443
2138 - California
Department of
Education

6,985,660

6,765,588

4,636,743

9,114,505 (1,396,819)
2139 - California
Department of
Conservation

(4,710,171)

4,242,621

472,749

(940,299) 7,578,584
2144 - California
Housing and
Community
Development

1,779,598

18,645,231

18,518,051

1,906,778 131,073,525
2152 - California
Board of
Corrections

279,792

5,477,125

6,896,600

(1,139,683) 10,143,467
2159 - State of
California Other

(14,707,407)

26,262,327

58,772,018

(47,217,098) 98,289,674
2160 - County of
Alameda: Grants

700,275

1,650,665

1,673,529

677,411 869,366
2172 - Alameda
County: Vehicle
Abatement Authority

(210,332)

163

123,681

(333,850) (103,904)
2190 - Private Grants
111,863

450,568

92,733

469,698 133,414
2195 - Workforce
Investment Act

1,157,817

3,692,339

4,000,801

849,355 3,590,218
2241 - Measure Q-
Library Services
Retention &
Enhancement

8,779,999

22,393,894

21,346,415

9,827,478 632,036
Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 50

Special City Council Meeting
November 19, 2024
2243 - Measure D -
Parcel Tax to
Maintain, Protect &
Improve Library
Services

10,341,990

18,431,886

15,963,253

12,810,623 116,000
2250 - Measure N:

Fund

892,582

2,403,096

1,991,017

1,304,661 10,993
2252 - Measure Z -
Violence Prevention
and Public Safety
Act of 2014

9,104,995

33,828,268

33,918,410

9,014,853 4,826,904
2253 - Oakland Zoo
Fund

227,030

15,009,876

15,009,876

227,030 -
2261 - Measure AA -
Oversight

6,398,433

3,202,657

3,243,675

6,357,415 -
2262 - Measure AA -
Early Education

19,460,736

28,366,383

28,366,383

19,460,736 -
2263 - Measure AA -
Oakland Promise

8,468,689

14,183,189

14,183,189

8,468,689 -
2264 - Measure AA -
First 5

(260,325)

6,580,608

3,008,948

3,311,335 4,003,899
2330 - Werner Court
Vegetation Mgmt
District

71,018

3,200

3,200

71,018 -
2331 - Wood Street
Community
Facilities District

575,328

95,812

111,318

559,822 88,442
2332 - Gateway
Industrial Park

1,365,172

1,502,008

1,690,223

1,176,956 1,352,108
2333 - Brooklyn
Basin Public
Services

602,577

502,382

517,103

587,856 915,730
2412 - Measure M -
Alameda County:

Emergency Dispatch
Service
Supplemental
Assessment

1,258,116

3,559,859

3,005,362

1,812,613 24,389
2413 - Rent
Adjustment Program
Fund

(1,047,248)

11,047,035

9,087,510

912,277 1,570,681
2416 - Traffic Safety
Fund

(39,646)

998,989

880,923

78,389 -
2417 - Excess Litter
Fee Fund

1,931,316

633,952

982,704

1,582,564 10,000
2420 -
Transportation
Impact Fee

10,561,596

3,482,896

3,526,446

10,518,046 6,049,217
2421 - Capital
Improvements
Impact Fee Fund

5,501,667

3,256,000

4,162,468

4,595,199 2,383,425
2430 - Lead
Settlement 2022

5,146,451

-

-

5,146,451 4,797,185
2826 - Mortgage
Revenue

3,131,834

89,492

91,399

3,129,927 2,425,076
2830 - Low and
Moderate Income
Housing Asset Fund

27,307,148

5,990,000

6,016,503

27,280,645 29,458,123
Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 51

Special City Council Meeting
November 19, 2024
2990 - Public Works
Grants

(957,692)

328,408

398,261

(1,027,545) 7,765
2994 - Social
Services Grants

527,559

600,000

478,774

648,785 621,550
2996 - Parks and
Recreation Grants
2001

180,950

16,847

16,847

180,950 59,225
2999 - Miscellaneous
Grants

9,182,877

1,351,419

6,736,316

3,797,980 5,080,406
3100 - Sewer Service
Fund

111,713,607

93,786,795

118,639,365

86,861,037 39,082,047
3200 - Golf Course
(718,981)

769,365

611,814

(561,430) 2,593,621
4200 - Radio /
Telecommunications

7,847,416

5,400,868

6,384,591

6,863,693 610,033
4210 - Telephone
Equipment and
Software

(1,196,502)

2,244,660

1,863,112

(814,954) -
4300 - Reproduction
956,441

1,953,410

1,984,165

925,686 -
4450 - City Facilities
Energy
Conservation
Projects

(214,882)

167

3,799

(218,514) -
4500 - Central Stores
(78,588)

654,796

624,635

(48,427) -
4510 - Personnel
Management

-

20,031,625

15,860,932

4,170,693 -
4550 - Purchasing
305,739

8,643,523

6,772,923

2,176,339 -
4600 - Information
Technology

16,365,750

27,111,787

28,341,261

15,136,276 10,139,846
5322 - Measure DD:
2017C Clean Water,
Safe Parks & Open
Space Trust for
Oakland

10,523,582

-

777,557

9,746,025 8,111,216
5331 - Measure KK:

Affordable Housing
(GOB 2017A-2
Taxable)

10,030,693

-

350

10,030,343 6,891,490
5332 - Measure KK:

Infrastructure Series
2020B-1 (Tax
Exempt)

14,122,083

570

9,310,024

4,812,629 9,219,628
5333 - Measure KK:

Affordable Housing
Series 2020B-2
(Taxable)

16,404,439

-

276,588

16,127,851 15,102,271
5335 - Measure KK:

Infrastructure Series
2022C-1 (Tax
Exempt)

95,629,813

26,613

39,735,771

55,920,655 67,326,936
5337 - Measure KK:

Series 2023 GOB

37,051,745

509

17,945,277

19,106,977 25,206,542
5338 - Measure KK
Infrastructure Series
2024E GOB (Tax
Exempt)

-

-

-

- -
Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 52

Special City Council Meeting
November 19, 2024
5340 - Measure U:

Affordable Housing
and Infrastructure
GOB

30,940,455

2 9,916,736

21,023,721 19,974,178
5341 - Measure U:

Affordable Housing
GOB Series 2023A-2
(Taxable)

64,745,124

1,969

1,220,813

63,526,280 62,502,424
5500 - Municipal
Capital Improvement

(3,334,023)

10,000,000

10,000,000

(3,334,023) -
5505 - Municipal
Capital
Improvement: Public
Arts

3,642,997

294,116

303,256

3,633,857 1,691,481
5510 - Capital
Reserves

1,223,630

-

18,666

1,204,964 994,870
5610 - Central
District Projects

20,420,106

911,621

1,178,957

20,152,770 6,076,142
5614 - Central
District: TA Bonds
Series 2006T

12,959,358

2,234,170

2,511,334

12,682,194 5,689,032
5638 - BMSP: TA
Bond Series 2006C-
T

443,794

380

-

444,174 174,776
5643 - Central City
East TA Bonds
Series 2006A-T
(Taxable)

16,942,143

7,457

259,544

16,690,056 6,467,945
5650 - Coliseum
Projects

4,972,196

100,000

306,506

4,765,690 2,773,325
5656 - Coliseum: TA
Bonds Series 2006B-
T (Taxable)

26,212,291

2,373,107

2,573,409

26,011,989 4,907,055
5671 - OBRA:

Leasing & Utility

56,154,280

1,607,000

1,997,451

55,763,829 4,081,373
5999 - Miscellaneous
Capital Projects

4,612,453

2,371,793

2,029,262

4,954,984 12,429,044
6013 - 2013 LED
Streetlight
Acquisition Lease
Financing

13,908

1,435,338

1,435,338

13,908 3,502
6029 - Taxable
Pension Obligation
Bonds: 2012 Series-
PFRS

9,335,273

54,086,806

54,086,806

9,335,273 5,250
6064 - GO Refunding
Bonds, Series 2015A

1,586,631

5,517,175

5,517,175

1,586,631 6,650
6322 - Measure DD:
2017C Clean Water,
Safe Parks & Open
Space Trust for
Oakland

592,625

1,456,433

1,456,433

592,625 7,001
6330 - Measure KK:
2017A-1 (TE)
Infrastructure and
Affordable Housing

1,498,534

2,247,558

2,247,558

1,498,534 6,136
6331 - Measure KK:
2017A-2 (Taxable)
Infrastructure and
Affordable Housing

1,131,326

4,137,780

4,137,780

1,131,326 7,500
Jestin D. Johnson, City Administrator
Subject: Attachment A - FY 2024-25 Q1 R&E Detail Report Date: November 19, 2024 Page 53

Special City Council Meeting
November 19, 2024

6332 - Measure KK:
2020B-1 GOB

2,608,526

3,944,700

3,944,700

2,608,526 8,500
6333 - Measure KK:
2020B-2 GOB

1,307,608

4,964,944

4,964,944

1,307,608 8,500
6334 - 2020 GOB
Refunding

(696,046)

5,806,950

5,806,950

(696,046) 8,000
6335 - Measure KK:

Infrastructure Series
2022C-1 GOB (Tax
Exempt)

23,557,661

10,446,400

10,446,400

23,557,661 7,900
6337 - Measure KK:

Infrastructure Series
2023D GOB (Tax-
Exempt)

4,874,390

2,820,350

2,820,350

4,874,390

(21,500)
6340 - Measure U:

Infrastructure Series
2023 A-1 GOB (Tax-
Exempt)

3,493,286

1,763,963

1,763,963

3,493,286 8,500
6341 - Measure U:

Affordable Housing
GOB Series 2023A-2
(Taxable)

13,754,634

12,934,855

12,934,855

13,754,634 8,500
6540 - Skyline Sewer
District -
Redemption

37,294

-

-

37,294 20,000
6557 - Piedmont
Pines P1 2018
Reassessment
Refunding Bond

233,973

107,122

107,122

233,973 25,953
6587 - 2012
Refunding
Reassessment
Bonds-Debt Service

579,527

416,844

416,844

579,527 45,960
6613 - JPFA Lease
Revenue Refunding
Bonds, Series 2018

(14,231)

8,328,125

8,328,125

(14,231) 6,450
6999 - Miscellaneous
Debt Service

-

25,000,000

25,000,000

- -
7100 - Police and
Fire Retirement
System

450,007,769

6,895,633

3,774,392

453,129,010 -
7130 - Employee
Deferred
Compensation

(3,856)

42,505

51,861

(13,212) -
7320 - Police and
Fire Retirement
System Refinancing
Annuity Trust

30,192,325

3,722,833

3,722,833

30,192,325 -
7540 - Oakland
Public Library Trust

1,430,524

103,399

165,393

1,368,530 978,051
7640 - Oakland
Public Museum
Trust

449,624

9,500

9,500

449,624 368,815
7760 - Grant
Clearing

(11,309,961)

125,850

9,239,171

(20,423,281) -
7999 - Miscellaneous
Trusts

2,968,572

264,270

278,645

2,954,197 1,772,982