Oakland City Council
April 19, 2022

Finance and Management Committee
April 11, 2022

TO: Edward D. Reiskin
City Administrator
FROM: Erin Roseman
Director of Finance
SUBJECT: FY 2021-22 Q2 R&E Report DATE: March 31, 2022
City Administrator Approval Date: Mar 31, 2022

RECOMMENDATION

Staff Recommends That The City Council Receive An Informational Report On Fiscal Year (FY) 2021-22 Second Quarter Revenue and Expenditure (R&E) Results And Year-End Summaries For The General Purpose Fund (GPF, 1010) and Select Funds.

EXECUTIVE SUMMARY

This report details the City of Oakland’s (the City) unaudited Second Quarter (Q2) financial results for FY 2021-22 in the General Purpose Fund (GPF) and other funds. The purpose of the quarterly revenue and expenditure (R&E) report is to monitor collection and spending trends in relation to the plan and to guide the City in managing its ongoing budget as more financial data becomes available. The report also contains preliminary FY 2021-22 projected year-end revenues and expenditures based on Second Quarter (Q2) trends. With the timing of this report, inevitably there are current economic trends that may not be reflected.

The second quarter represents revenue collections and expenditure trends from July 2021 to December 2021. It is important to note, the collection of revenue is seasonal and thus only 34% of revenues are collected at the half-way mark in the fiscal year. Likewise, expenditures are at 35% spent at the half-way mark of the fiscal year.

Many of the economically sensitive revenue categories in the GPF have experienced growth in the first half of the fiscal year and revenues projections indicate that they are on pace to exceed budgeted levels. However, one-time Federal relief funding from American Rescue Plan Act (ARPA) is used to buffet the historical revenue decline. ARPA funds are budgeted at a value of $87 million or approximately 11% of budgeted revenues to continue to support qualified GPF expenditures. Overall GPF expenditures are trending below the Adjusted Budget and are projected to be at or just below budgeted levels.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report
Finance and Management Committee
April 11, 2022

Date: March 31, 2022 Page 2

Analysis of revenues and expenditures through the Second Quarter indicates that GPF revenues are projected to exceed GPF expenditures by $40.28 million by year-end for FY 2021- 22 in comparison to the adopted budget. This creates a projected Fund Balance at the end of FY 2021-22, including fund obligations, estimated at $36.30 million (Table 4).

This report also highlights non-GPF funds beginning with Table 15 through Table 60 that are of interest to the City due to their special revenue source (local measure, local tax) or because of particular expenditure restrictions. A fund summary for all other non-GPF funds, grouped by fund type, is captured at the end of Attachment A: Report Details beginning with Table 61 through Table 67.

BACKGROUND / LEGISLATIVE HISTORY

Below is a summary of Council's actions that have occurred from the beginning of the fiscal year through Q2 that have modified the FY 2021-22 Budget:

1) Action to allocate funding for Oakland's Mobile Assistance and Community Responders (MACRO) and capital and transportation projects Resolution 88784 C.M.S.

2) Action to fund Head Start Programming Resolution 88801 C.M.S.

3) Action to Add Two Police Academies Resolution 88942 C.M.S.

ANALYSIS AND POLICY ALTERNATIVES

General Purpose Fund (GPF)

Revenues

The 2021-22 GPF Adopted Budget was developed assuming that many of the revenue categories would continue to recover with the rollout of highly effective Covid-19 vaccines and corresponding loosening of public health restrictions. Based on the available data through the first six months, $279.26 million, or 34.4%, of adopted GPF revenues have been collected at the end of Q2. GPF revenues are projected to exceed the adopted budget by 4%. Some revenue categories are collecting and trending higher than anticipated and projected to exceed the adopted budget.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report
Date: March 31, 2022 Page 3
Finance and Management Committee
April 11, 2022

These include:
* Property Tax, projected 1.1% higher than budgeted,
* Sales Tax, projected 2.7% higher than budgeted,
* Business Tax, projected 2.1% higher than budgeted,
* Real Estate Transfer Tax, projected 19.9% higher than budgeted.

Details of adjustments for these categories are further discussed in Table 6 of the attached detailed report. Table 1 below summarizes all the GPF year-to-date and projected year-end revenues combined.

Table 1: FY 2021-22 Q2 GPF Revenues Budget to Actuals ($ in millions)

FY2021-22
Adopted Budget

FY2021-22
Adjusted Budget

FY2021-22
Q2 Actual
Revenue

FY 2021-22
Q2 Year End
Estimate

Year-End $
Over/(Under)
Adjusted Budget
Projected
Percentage Over /
(Under) Adjusted
Budget
784.39 812.81 279.26 846.17 33.36 4%

Expenditures

The GPF year-end expenditure projection is $805.89 million, which is $6.92 million or 1% under the $812.81 million adjusted budget before accounting for $87.02 million in eligible Public Safety expenditure transfers from GPF to the ARPA Fund (2072). Factoring for the one-time aid from ARPA funds, GPF expenditures are projected to end the fiscal year at $716.12 million.

In accordance with Consolidated Fiscal Policy (CFP) Part I, there are two departments that are projected to overspend by more than 1%. City Administration will provide a plan to bring them back into compliance within the next 60 days.

Table 2 on the following page summarizes GPF's FY 2021-22 expenditures budget to actuals at Q2 and projects year-end, adjusted to reflect the impact of the expenditures transferred out to the ARPA Fund:

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report
Date: March 31, 2022 Page 4
Finance and Management Committee
April 11, 2022

Table 2: FY 2021-22 Q2 GPF Expenditures Budget to Actuals ($ in millions)

A B C D E D + E = F B - F = G
FY 2021-22 Year-End Percentage
FY 2021-22 FY 2021-22 FY 2021-22 FY 2021-22 Q2 Adjust. (Over) / (Over) / Adopted Adjusted Q2 Q2 Year-End ARPA Year-End Under Under Budget Budget* Actuals Estimate Adjust. Estimate Budget Budget

784.39

812.81

287.51

716.12

87.02 805.89

6.92 1%
*The adjusted budget includes Council Budget Amendment per Resolutions 88784 C.M.S adopted on July 26,2021, 88942 C.M.S (Police Academies), 88940 C.M.S. (Head Start) and $28.07 million in Carryforwards

State and federal aid were the essential factors in the City’s own economic and financial recovery. Under regulations administered through the United States Treasury Department, ARPA provided the City with an allocation of $188 million, split between FY 2020-21 and FY 2021-22. Oakland's City Council directed these funds to replace revenue losses experienced during the pandemic and address budget imbalances in FY 2020-21, FY 2021-22, and FY 2022-

23. Through this aid, the City is able to maintain most of its services intact while also preserving its emergency reserve.

In addition to federal aid, the City's number of vacancies is a contributing factor to projected expenditure savings in the GPF. At Q2, the GPF's vacancy rate (net positions that are frozen as part of the FY 2021-23 Adopted Budget), is 16.08% as shown in Table 3 below. The vacancy rate assumed in the FY 2021-23 Adopted Budget is 8% across most City Departments, which is half of the actual vacancy rate reported at Q2.

Table 3: FY 2021-22 Q2 GPF Filled and Vacant Positions (Percent %) Status as of Q2 FY 2021-2022 Percent (%)
Filled or Encumbered (linked) 83.92%
Vacant 16.08%
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report
Finance and Management Committee
April 11, 2022

Date: March 31, 2022 Page 5

Fund Balance

As shown in Table 4 below, after meeting mandated reserves required by City Ordinances and the City Charter (mandated emergency reserves) & Oakland Municipal Employees’ Retirement System (OMERS) totaling $99.44 million, the preliminary estimated FY 2021-22 available Fund Balance is $36.30 million (Unaudited Ending Fund Balance - Obligations). The estimated FY 2021-22 available Fund Balance is the amount of unobligated funding available to the City in the GPF.

Table 4: Summary of FY 2021-22 Fiscal Situation with GPF Fund Balance ($ in millions) GENERAL PURPOSE FUND (1010) FY 2021-22 Q2
Projected FYE

Estimated FY 2021-22 Beginning Audited Fund Balance 95.46

FY2021-22 Performance
Revenue 846.17
Expenditures 805.89
FY 2020-21 Operating Surplus / Deficit 40.28

Unaudited Ending Fund Balance 135.74

Obligations Against Ending Fund Balance (93.28)
OMERS Reserves (Reso. No. 85098 C.M.S) (2.36)
Budgeted use of Fund Balance during Biennial FY21-23 (28.07) Prior Year Transfer of Fund Balance to the Emergency Reserve (Fund 1011)

(48.31)
New Revenue Subject to Excess RETT CFP Policy Including 50% for One Time Use, 25% for VSSF, 25% for Long Term Obligations

(14.54)

Other Commitments Against Fund Balance (6.16)
Fund Balance Reserved for Lake Merritt Lodge Through June 30, 2023 consistent with intent of Reso 89099

(5.13)
Contractually Obligated Transfers to Scotlan Convention Center (Report to Council Under Development)

(1.03)

Estimated FY 2021-22 Ending Available Fund Balance 36.30 Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report
Finance and Management Committee
April 11, 2022

Date: March 31, 2022 Page 6

In accordance with the Consolidated Fiscal Policy (CFP), Section 2 Reserve Fund Policies, Emergency Reserves, it shall be the policy of the City of Oakland to provide in each fiscal year a reserve of undesignated, uncommitted fund balance equal to seven and one-half (7.5%) of the General Purpose Fund (Fund 1010) appropriations for such fiscal year. That amount is $54.61 million of which $48.31 million will come from prior year GPF Fund balance and 6.3million will come from current year GPF revenues; these amounts are reserved in Fund 1011.

The FY2021-22 Adopted Budget includes, $2.58 million budgeted to the Vital Services Stabilization Fund Reserve. Using the FY21-22 Q2, revenue projections, the policy would require an additional allocation of $3.63 million based on the Excess RETT formula for a total of $6.21 million.

The CFP also provides guidance for use of One-Time Funds, CFP Section 1, Part D.

Appropriate uses and requirements are One-time uses, debt retirement and long-term obligations such as negative fund balances, Police and Fire Retirement System (PFRS) unfunded liabilities, CalPERS pension unfunded liabilities, paid leave unfunded liabilities, and Other Post- Employment Benefits (OPEB) unfunded liabilities or remain as fund balance.

Negative balances of prime concern include the Self-Insurance Liability Fund (1100), Internal Service Funds (ISFs), and the Capital Reserves Fund (5510). In alignment with the goals of the CFP, these funds, among others, are on formal repayment plans to reduce negative fund balances. In FY21-22, a total $4.89 million is budgeted in the GPF for this purpose. The FY21- 22 Q2 revenue projections, indicate that $10.91 million ($14.95 million of Excess Rett less $3.64 million for the VSSF) could be appropriated to address negative fund balances; and such appropriation would be consistent with the required use of such funds under the CFP.

Summary

In summary, FY 2021-22 Q2 revenue analysis suggests that GPF revenues may exceed budgeted expenditures by approximately $40.28 million. On the expenditure side, projected savings is attributable to one-time federal ARPA aid and citywide vacancies. However, caution is warranted for two reasons: 1) less revenue data is collected in the first 6 months of the fiscal year, and 2) the economy remains volatile and unpredictable due to the ongoing COVID-19 pandemic. The effects of the rapidly growing inflation are not reflected in the Q1 and Q2 expenditure trends however are expected to change spending trends in Q4. Note also that if not for the one-time ARPA funds, which are only available in this fiscal year and next, the City would be projecting a $47 million GPF shortfall this fiscal year.

While the Q2 revenue collections are trending ahead of expectations, FY 2021-22 City revenues remain uncertain due to the pandemic, supply chain disruptions, economic impacts of war, inflation, and federal monetary policy.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report
Date: March 31, 2022 Page 7
Finance and Management Committee
April 11, 2022

Staff recommends City Council receive this report but take no action based upon unaudited figures from the Second Quarter. Staff strongly recommends that City Council delay consideration of any action until the FY 2021-22 Third Quarter report to ascertain whether any action is necessary and recommends City Council then take any such actions as a part of the FY 2022-23 Midcycle Budget process. During the Midcycle budget process, staff will be able to provide more firm assessments of available resources and context of the City’s near-term financial outlook.

Non-GPF Funds

The selected non-GPF Funds that are analyzed in this report reflect an overall reduction in available fund balance and appropriations in the FY 2021-23 Biennial Budget as shown on Table 5 below. Please note the City’s Consolidated Fiscal Policy (CFP) requires the adoption of a balanced budget that limits appropriations to the total of estimated revenues and unallocated fund balances projected to be available at the close of the current fiscal year. The City Administrator shall be responsible for ensuring that the budget proposed to the City Council by the Mayor, adheres to the balanced budget policy.

Table 5: FY2021-22 Q2 Beginning and Year End Estimated Fund Balance ($ in millions)

FUND

FY 2021-22
Audited
Beginning
Balance

FY 2021-22
Revenue
Projected
Year-End
Estimate

FY 2021-22
Expenditure
Projected
Year-End
Estimate

FY 2021-22
Net (Use of) /
Contribution
to Fund
Balance

FY 2021-22
Estimated
Ending
Balance
Measure HH - Sugar Sweetened
Beverage Distribution Tax
(SSBT) Fund (1030)

7.82 14.05 14.62 (7.02) 0.23
Self-Insurance Liability Fund
(1100) ^
(19.07) 56.77 55.83 0.79 (17.34)
Comprehensive Clean-Up Fund
(1720)

4.31 26.18 23.78 (2.75) 3.96
Multipurpose Reserve Fund
(1750)
(0.66) 12.15 11.52 (0.57) (0.60)
OPRCA Self Sustaining
Revolving Fund (1820)

3.54 3.93 5.53 (0.07) 1.87
Affordable Housing Trust Fund
(1870)

38.49 51.62 49.29 (35.02) 5.80
Measure B/BB and Measure F
Funds (2211, 2212, 2213, 2215,
2216, 2217, 2218, 2219, 2220)

31.21 51.30 47.14 (17.95) 17.42
State Transportation (Gas Tax)
Funds (2230, 2232)

4.59 26.60 17.96 (4.22) 9.01
Measure Q - OPR Preservation,
Litter Reduction, Homelessness
Support Act Fund (2244)

11.99 39.68 40.15 (12.72) (1.20)
Measure Z -Violence Prevention
and Public Safety Act of 2014
Fund (2252)

1.73 30.17 29.17 (2.47) 0.26
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report
Finance and Management Committee
April 11, 2022

Date: March 31, 2022 Page 8

FUND

FY 2021-22
Audited
Beginning
Balance

FY 2021-22
Revenue
Projected
Year-End
Estimate

FY 2021-22
Expenditure
Projected
Year-End
Estimate

FY 2021-22
Net (Use of) /
Contribution
to Fund
Balance

FY 2021-22
Estimated
Ending
Balance
Vacant Property Tax Fund
(2270)

0.94 10.95 10.72 (5.35) (4.18)
Landscaping & Lighting Assess.

District Fund (LLAD) (2310)

0.05 20.06 19.62 (0.24) 0.24
Development Service Fund
(2415)
146.66 131.02 114.15 (77.10) 86.43
Measure C - Transient
Occupancy Tax (TOT)
Surcharge Fund (2419)

0.22 4.64 4.64 (0.07) 0.15
Reproduction Fund (4300)*^ (1.31) 1.70 1.70 0.26 (1.05) City Facilities Fund (4400)* 2.83 43.62 41.27 (3.95) 1.23 Central Stores Fund (4500)*^ (3.58) 1.29 1.34 0.78 (2.85) Purchasing Fund (4550)*^ (0.21) 1.78 1.88 0.00 (0.31)
Measure KK Funds (5330, 5331,
5332, 5333, 5335)
112.79 201.90 201.90 (109.98) 2.81
* FY 2021-22 Beginning Cash Balance is used for Internal Service Funds. ^ Funds that are on existing repayment plans for prior year negative balances

Conclusion

The City faced tremendous economic challenges during FY 2020-21, but its outlook was much improved by year-end and continued through the first half of FY 2021-22. One-time Federal relief funding from American Rescue Plan Act (ARPA) of $188 million and the utilization of excess of prevented the City's fiscal crisis at a time when residents have been especially reliant on City services. Despite the fortune of receiving these one-time funds, the City still faces a structural imbalance in the GPF and other funds, including funds reliant upon hotel taxes and parking revenues. The FY 2021-22 Q2 forecast indicates the economy is slowly recovering, however, the full impact of the COVID-19 pandemic on the City, its businesses, and its residents is still unfolding. The City's short-term recovery and long-term fiscal outlook will depend on how City Council continues to manage the City's fiscal health over the coming year.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report
Finance and Management Committee
April 11, 2022

Date: March 31, 2022 Page 9

The Graph below indicates the Forecast GPF Revenue and Federal ARPA Aid. Between FY 2022-23 and FY 2023-24 The City will likely lose $24 million in revenue support to the GPF despite growing GPF Revenues. This $24 million only reflects lost revenues and does not account for the impacts of rising inflation, increasing medical and pension costs or the settlement on of future labor MOUs on the GPF.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report
Date: March 31, 2022 Page 10
Finance and Management Committee
April 11, 2022

PUBLIC OUTREACH / INTEREST

No outreach was deemed necessary for this informational report beyond the standard City Council agenda noticing procedures.

COORDINATION

This report was prepared in coordination between the Finance Department, the City Administrator’s Office, and various departments.

SUSTAINABLE OPPORTUNITIES

Economic: No direct economic opportunities have been identified.

Environmental: No direct environmental impacts have been identified.

Race & Equity: No direct Race & Equity opportunities have been identified in this informational report.

ACTION REQUESTED OF THE CITY COUNCIL

Staff recommends that City Council receive an informational report on the unaudited Fiscal Year (FY) 2021-22 Second Quarter Revenue and Expenditure (R&E) results and year-end summaries for the General Purpose Fund (GPF, 1010) and select funds.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report
Date: March 31, 2022 Page 11
Finance and Management Committee
April 11, 2022

For questions regarding this report, please contact Bradley Johnson, Budget Administrator, at (510) 238-6119.

Respectfully submitted,

Erin Roseman
Director of Finance
Finance Department

Reviewed by:

Bradley Johnson
Budget Administrator

Margaret O'Brien
Revenue & Tax Administrator

Prepared by Revenue Management Bureau &
Budget Bureau staff:

Attachments (1):

A: FY 2021-22 Q2 Detailed Report
Appendix A: Consolidated Fiscal Policy
Appendix B: Midcycle Update on Five
Year Forecast
Rogers Agaba
Huey Dang
Chuck Maurer
Jose Segura
Walter Silva
Michelle Soares
Rina Stabler

Attachment A

FY 2021-22
2nd Quarter Detailed Report
Budget to Actual
Revenue and Expenditure
(R&E)

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 1
Finance and Management Committee
April 11, 2022

Attachment A: FY 2021-22 Q2 Detailed Report

TABLE OF CONTENTS

The report has the following major sections:

1. General Purpose Fund Q2 Revenues

2. General Purpose Fund Q2 Expenditures

3. General Purpose Fund Q2 Fund Balance

4. Reserves

5. Select Non-GPF Q2 Analysis

6. All Other Funds - Fund Balance Summary
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 2
Finance and Management Committee
April 11, 2022

1. GENERAL PURPOSE FUND Q2 REVENUES

The City's FY 2021-22 Q2 Forecast Assumes a Continued Slow & Steady Recovery

The exact economic impacts from the Covid-19 pandemic over the next few years remains unknown. The good news is that the GPF revenues through the first six months continue the upward trend started in the latter half of Fiscal Year 2020-21.

Through the first half of the current fiscal year, several revenue categories in the General Purpose Fund are projected to exceed adopted budget thereby increasing the projected GPF revenues by approximately $33.71 million, or 4.1%, over the Adjusted Budget. Those are Property Tax, Sales Tax, Business Tax, and Real Estate Transfer Tax. It is worth noting that inflationary pressures and possible increase in the interest rates may slow the rate of growth.

As with any projections, there is a level of uncertainty reflecting historical patterns, seasonality, and other unknown factors that may affect certain revenue streams. Furthermore, there is a lag in timing when revenue is received and recorded. Revenues reported in Q2 do not necessarily equate to one-half of the Adopted Budget as presented in Table 6.

Attached to this report is a preliminary updated forecast for the City’s major revenue categories in comparison to the Five-Year Financial Forecast produced in 2021 (See Appendix B). As noted in that report ongoing global economic dislocations, including Russia’s invasion of Ukraine and COVID-19 disruptions of office work and supply chains, these revenue projections remain uncertain. The projections are sensitive to changes in personal income, inflation, and the extent to which workers return to offices. Nevertheless, the projections reflect the most up to date economic and financial data available at the time of writing.

Rising personal incomes and sustained inflation have generated higher-than-expected tax revenues despite modest employment growth. Due in part to the COVID-19 pandemic’s Delta and Omicron waves, Oakland’s employment rebound during calendar years 2021 and 2022 to date has been slower than predicted. Fiscal policies enacted at the state and federal levels, however, have led to nominal personal income growth that has exceeded expectations, generating higher revenues across a broad range of categories. The American Rescue Plan, a new federal child tax credit, student loan relief, and California’s Golden State Stimulus helped to boost statewide per capita incomes, expected to increase by more than 6% in FY 21-22. Growth in real incomes was more modest, as the state’s CPI increased 4.2% during FY 20-21 and is expected to increase 6.6% in FY 2021-22.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Finance and Management Committee
April 11, 2022

Date: March 31, 2022 Page 3

The Graph below indicates the Forecast GPF Revenue and Federal ARPA Aid. Between FY 2022-23 and FY 2023-24 The City will likely lose $24 million in revenue support to the GPF despite growing GPF Revenues. This $24 million only reflects lost revenues and does not account for the impacts of rising inflation, increasing medical and pension costs or the settlement on of future labor MOUs on the GPF.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 4
Finance and Management Committee
April 11, 2022

Table 6: FY2021-22 Q2 Adopted Budget to Actuals and Year End Estimate ($ in millions)

Revenue Category
FY2021-22
Adjusted
Budget

FY2021-22 Q2
Actual Revenue
FY 2021-22 Q2
Year End
Estimate
Year-End $
Over/(Under)
Adjusted
Budget
Year-End %
Over/(Under)
Adjusted
Budget
Property Tax 247.15 106.75 249.84 2.69 1.1%
Business License Tax 97.75 15.02 99.85 2.10 2.1%
Real Estate Transfer
Tax

96.43 72.32 115.62 19.19 19.9%
Sales Tax 58.97 20.76 60.56 1.59 2.7%
Service Charges 50.27 18.92 50.27 0.00 0%
Utility Consumption Tax 49.14 23.89 53.26 4.12 8.4%
Vehicle License Fee 0.00 0.00 0.00 0.00 0%
Transient Occupancy
Tax

16.73 6.78 16.73 0.00 0%
Parking Tax 7.84 4.09 9.18 1.34 17.1%
Local Tax 0.00 0.00 0.00 0.00 0%
Licenses & Permits 4.05 0.80 4.05 0.00 0%
Fines & Penalties 15.74 8.65 17.93 2.20 14.0%
Interest Income 0.48 0.06 0.48 0.00 0%
Internal Service Funds 0.00 0.00 0.00 0.00 0%
Grants & Subsidies 0.00 0.14 0.14 0.14 0%
Miscellaneous 1.60 1.07 1.60 0.00 0%
Inter-Fund Transfers 89.93 0.00 89.93 0.00 0%
Sub-Total Revenue 736.08 279.26 769.44 33.36 4.5%
Transfers From Fund
Balance (including
Carry Forward)

76.73 0.00 76.73 0.00 0%
Total Revenue 812.81 279.26 846.17 33.71 4.1%
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 5
Finance and Management Committee
April 11, 2022

GENERAL PURPOSE FUND ADJUSTMENTS Q2 FY 2021-22

Property Tax: Projected year-end increase of $2.68 million in property tax revenue compared to budget due to higher than expected Residual Property Tax Trust Fund revenues from the wind down of the Redevelopment Agency.

Sales Tax: Projected year-end increase of $1.59 million in sales tax revenue compared to budget due to higher than expected new & used car sales, continuing growth in online shopping, and a return to indoor dining which began in Q4 of FY2020-21. Table 7 provides a year over year comparison of the major sales tax categories.

Table 7: Q2 Sales Tax Comparison by Category FY2020-21 and FY 2021-22 ($ in millions) Category Thru Q2 2021 Thru Q2 2022 Inc/Dec
Autos & Transportation 3.86 4.49 16.39 %
Building & Construction 2.95 2.60 (12.10) %
Business & Industry 2.81 3.05 8.65 %
Food & Drugs 3.32 3.09 (7.05) %
Fuel & Service Stations 1.84 3.61 96.13 %
General Consumer Goods 1.59 2.98 87.37 %
Restaurants & Hotels 3.21 4.97 54.97 %
State/County Pools & Transfers 6.38 6.03 (5.44) %
Total 25.95 30.81 13.30%

Business Tax: Projected year-end increase of $2.10 million in business tax revenue compared to budget due to growth in gross receipts reported by businesses of approximately 2.2% over the previous year and continuing efforts by staff in identifying noncompliant businesses.

Utility Users Tax: Projected year-end increase of $4.12 million in utility users tax revenue compared to budget due to increases in both electricity and gas rates expected in the second half of the fiscal year.

Real Estate Transfer Tax (RETT): Projected year-end increase of $19.19 million in RETT revenue compared to budget due to the growth in number of sales of properties valued in the $2-$5 million range over the previous fiscal year.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 6
Finance and Management Committee
April 11, 2022

Table 8: RETT Growth Rate ($ in millions)
FY 2020-21 FY 2021-22 Year-Over-Year Variance
Thru Q2
Sale Price Gross Sales Volume Gross Sales Volume Gross Sales Volume $300,000 or below 32.58 197 32.70 195 0.36 % (1.02) %
$300,001 to $2 Million 2,284.85 2,557 2,211.80 2,375 (3.20) % (7.12) % $2 million to $5 Million 254.14 97 486.95 179 91.61 % 84.54 % $5 -10 Million 161.51 22 101.97 15 (36.87) % (31.82) %
$10 - 50 Million 235.07 11 263.13 12 11.94 % 9.09 %
$50.01-100 Million 0.00 0 65.00 1 — % — %
Over $100 Million 449.77 1 327.50 1 (27.18) % — %
Total 3,417.91 2,885 3,489.04 2,778 2.08 % (3.71) %

Parking Tax: Projected year-end increase of $1.34 million compared to budget due to expected improved parking activities at the airport from the lows experienced in FY2020-21.

Fines and Penalties: Projected year-end increase of $2.20 million compared to budget due to the expected increase in the issuance of parking citations, which makes up a significant portion of this revenue category, as parking activity increases from the lows experienced in FY 2020-21.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 7
Finance and Management Committee
April 11, 2022

2. GENERAL PURPOSE FUND Q2 EXPENDITURES

GENERAL PURPOSE FUND EXPENDITURE HIGHLIGHTS
GPF year to date expenditures for Q2 are 35% of the Adjusted budget. All departmental spending is projected to be at or under budget. The overall projection of GPF expenditures is 1% under the adjusted budget. The larger concern with the GPF expenditures is the large savings projected in personnel savings. However, expenditure projections are based on the first six months of the year and are not picking up the inflationary trend expected in the 4th quarter. A Citywide vacancy rate in excess of 16% also affects the City’s ability to provide services to residents

ARPA Adjustments
The City Council directed the use of $87.02 million of the $188 million of ARPA funds allocated to the City to address projected FY 2021-22 budget imbalances.

Table 9 below reflects the GPF expenditure budget and year-end estimates to include transfers of eligible expenditures to the ARPA Fund. Factoring in the budgeted FY 2021-22 ARPA funding relieves the GPF of projected year-end expenditures by $87.02 million. GPF expenditures are forecasted to come in $6.92 million under the adjusted budget of $812.81 million.

Table 9: Summary of FY 2021-22 Q2 GPF Expenditures Budget to Actuals ($ in millions)

A B C D E D + E = F B - F = G

Department

FY 2021-22
Adopted
Budget

FY 2021-22
Adjusted
Budget

FY 2021-22
Q2
Actuals

FY 2021-22
Q2 Year-End
Estimate

ARPA
Adjust.

FY 2021-22
Q2 Adjust.

Year-End
Estimate
Year-End
(Over) /
Under
Budget
Percentage
(Over) /
Under
Budget
FY 2021-22
Expenditures

784.39

812.81*

287.51

716.12

87.02 805.89

6.92 1 %
*The adjusted budget includes Council Budget Amendment per Resolutions 88784 C.M.S adopted on July 26,2021, 88942 C.M.S (Police Academies), 88940 C.M.S. (Head Start) and $28.07 million in Carryforwards Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Finance and Management Committee
April 11, 2022

Date: March 31, 2022 Page 8

Department Level Spending Trends

Table 10 reflects department level spending and the impact on projected year-end GPF expenditures with ARPA funds support.

Table 10: Summary of FY 2021-22 GPF Projected Expenditure Variance ($ in millions)

Department

FY 2021-
22 Adopted
Budget

FY 2021-
22 Adjusted
Budget

FY 2021-
22 Q2
Actuals
FY 2021-
22 Q2
Year-End
Estimate

ARPA
Adjust.

FY 2021-
22 Q2
Adjust.

Year-End
Estimate
Year-End
(Over) /
Under
Budget
Percentage
(Over) /
Under
Budget
FY 2021-22 Expenditures 784.39 812.81 287.51 716.12 87.02 805.89 6.92 1 % Mayor 4.26 4.27 1.79 4.06 — 4.06 0.21 5 %
City Council 6.28 6.45 3.22 6.59 — 6.59 (0.14) (2) %
City Administrator 8.01 7.84 3.10 7.84 — 7.84 0.00 — %
City Attorney 15.00 15.06 6.12 15.06 — 15.06 0.00 — %
City Auditor 2.41 2.54 1.23 2.53 — 2.53 0.00 — %
City Clerk 3.56 3.81 1.11 6.31 — 6.31 (2.50) (66) %
Police Commission 4.49 5.03 1.42 4.22 — 4.22 0.81 16 %
Public Ethics Commission 1.49 1.56 0.66 1.46 — 1.46 0.11 7 % Finance 21.57 21.49 9.74 21.68 — 21.68 (0.19) (1) %
Information Technology 13.31 15.61 5.52 15.49 — 15.49 0.11 1 % Race & Equity 0.92 0.99 0.40 0.92 — 0.92 0.08 8 %
Human Resources 6.48 6.67 3.07 6.44 — 6.44 0.23 3 %
Violence Prevention 11.36 12.97 2.16 12.97 — 12.97 0.00 — % Police 313.92 320.17 109.99 226.84 87.02 313.87 6.30 2 % Fire 171.96 176.30 82.41 175.33 175.33 0.97 1 %
Library 14.11 14.12 8.02 12.72 — 12.72 1.40 10 %
Parks, Recreation, & Youth
Development 16.68 16.85 8.77 16.22 — 16.22 0.63 4 %
Human Services 15.26 19.65 5.58 19.65 — 19.65 0.00 — %
Economic Workforce &
Development 10.96 13.91 5.13 13.32 — 13.32 0.60 4 %
Housing & Community
Development 0.10 0.10 0.02 0.10 — 0.10 0.00 — %
Public Works 1.86 4.24 0.63 4.17 — 4.17 0.07 2 %
Transportation 15.95 17.61 7.74 17.67 — 17.67 (0.06) — % Workplace & Employment
Standards 4.36 4.36 1.70 3.66 — 3.66 0.70 16 %
Non-Departmental 114.14 114.05 15.52 113.95 — 113.95 0.11 — % Capital Improvement 0.55 1.62 0.09 1.62 — 1.62 0.00 — % Animal Services 5.41 5.52 2.68 5.09 — 5.29 0.23 4 %
Use of Salary Savings Per
Council Resolutions

—

—

—

—
—

2.7 (2.75)

— %
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Finance and Management Committee
April 11, 2022

Date: March 31, 2022 Page 9

The following section details projected GPF savings or overspending by Department, as compared to the Q2 FY 2021-22 Adjusted Budget.

Mayor’s Office

The Mayor’s Office is projected to underspend by $213,749, or 5% of their budget, due primarily to vacancies.

City Council

The City Council is projected to overspend their budget by$136,052, approximately (2)% of their budget due to personnel.

City Administrator (CAO)

The City Administrator’s Office is projected to end the fiscal year at budget.

City Attorney

The City Attorney is projected to end the fiscal year at budget.

City Auditor

The City Auditor is projected to end the year at budget.

City Clerk

The Office of the City Clerk is projected to overspend their budget by $2.50 million which is 66% of their budget due to unbudgeted June election costs.

Police Commission

The Police Commission is projected to have savings of $807,828, which is 16% of their budget, due to vacancies.

Public Ethics Commission (PEC)

The Public Ethics Commission is projected to have savings of $105,381, which is 7% of their budget, due to vacancies.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 10
Finance and Management Committee
April 11, 2022

Finance Department

The Finance Department is projected to overspend by $187,073, or 1% of their budget, due to overspending in personnel.

Information Technology (ITD)

The Information Technology Department is projected to have savings of $113,488, which is 1% of their budget due to vacancies.

Race & Equity

The Department of Race & Equity is projected to have savings of $78,854, which is 8% of their budget, due to vacancies.

Human Resources Management (HRM)

Human Resources Management is projected to have savings of $231,281, which is 3% of their budget, due to vacancies.

Violence Prevention (DVP)

The Department of Violence Prevention is projected to end the fiscal year at budget.

Oakland Police Department (OPD)

The Police Department is projected to have savings of $6.30 million, which is 2% of their budget, due to vacancies.

Oakland Fire Department (OFD)

The Oakland Fire Department is projected to have savings of $970,529, which is 1% of their budget, due to vacancies.

Oakland Public Library (OPL)

Oakland Public Library is projected to have savings of $1.40 million, which is 10% of their budget, due vacancies.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 11
Finance and Management Committee
April 11, 2022

Oakland Parks, Recreation and Youth Development (OPRYD)

Oakland Parks, Recreation and Youth Development is projected to have savings of $630,450, which is 4% of their budget, due to vacancies.

Human Services Department (HSD)

Human Services Department is projected to end the fiscal year at budget.

Economic & Workforce Development (EWD)

Economic & Workforce Development is projected to have savings of $598,604, which is 4% of their budget, due to vacancies.

Housing & Community Development (HCD)

Housing & Community Development is projected to end the fiscal year at budget. Their budget in the GPF is a very negligible portion of their overall department budget across all funds Citywide.

Oakland Public Works (OPW)

Oakland Public Works is projected to have savings of $67,009, which is 2% of their budget, due to vacancies.

Department of Transportation (DOT)

The Department of Transportation is projected to overspend by $58,391, which is 0.33% of their budget due to overspending in O&M.

Department of Workplace & Employment Standards (DWES)

The Department of Workplace & Employment Standards is projected to have savings of $697,621, which is 16% of their budget, due to vacancies.

Non-Departmental

Non-Departmental is projected to have savings of $105,752 which is 0.09% of their budget.

Capital Improvement Program (CIP)

The Capital Improvement Program is projected to end the fiscal year at budget.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 12
Finance and Management Committee
April 11, 2022

Department of Animal Services

The Department of Animal Services is projected to have savings of $225,627, which is 4% of their budget, due to vacancies.

Public Safety Costs & Analysis

Table 11 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 budget to be under spent by $8.18 million and Oakland Fire Department currently shows a projected year-end budget to be under spent by $770,057.

Details are provided on Table 11 below.

Table 11: FY 2021-22 Public Safety GPF Personnel Expenditures ($ in millions)

Department
FY 2021-22
Adjusted
Budget
FY 2021-22
Q2 YTD
Actuals
FY 2021-22
Year-End
Estimate
Year-End
(Over) /
Under
Budget
Percentage
(Over) /
Under
Budget
Police Department
Overtime (OT) 31.29 19.31 38.87 (7.58) (24.23)%
Reimbursable OT (Special Events, etc.) (2.36) (2.36) 2.36 NA All Other Personnel (non-OT) 242.80 117.85 229.39 13.40 5.52 % OPD Total Personnel 274.09 134.81 265.91 8.18 3 %
Fire Department
Overtime (OT) 18.52 17.32 31.05 (12.53) (67.65) %
All Other Personnel (non-OT) 131.86 66.45 118.56 13.30 10.09 % OFD Total Personnel 150.38 83.77 149.61 0.77 1 %
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 13
Finance and Management Committee
April 11, 2022

Table 12: Year-Over-Year Comparison of Public Safety GPF Personnel Expenditures ($ in millions)
Police Department
Overtime (OT) FY 2018-19 FY 2019-20 FY 2020-21 FY2021-22 Adjusted Budget 14.05 16.56 15.39 31.29
Actuals (FY22 Proj) 36.36 35.07 29.18 38.87
(Over)/Under (22.31) (18.51) (13.79) (7.58)
All Other Personnel (non-OT) FY 2018-19 FY 2019-20 FY 2020-21 FY2021-22 Adjusted Budget 211.35 232.95 239.29 242.80
Actuals (FY22 Proj) 212.68 242.01 244.23 229.39
(Over)/Under (1.33) (9.06) (4.94) 13.40
Total Personnel FY 2018-19 FY 2019-20 FY 2020-21 FY2021-22 Adjusted Budget 225.40 249.51 254.68 274.09
Actuals (FY22 Proj) 249.04 277.08 273.41 268.26
(Over)/Under (23.64) (27.57) (18.73) 5.83
Fire Department
Overtime (OT) FY 2018-19 FY 2019-20 FY 2020-21 FY2021-22 Adjusted Budget 3.34 2.37 4.22 18.52
Actuals (FY22 Proj) 19.65 20.63 24.22 31.05
(Over)/Under (16.31) (18.26) (20.00) (12.53)
All Other Personnel (non-OT) FY 2018-19 FY 2019-20 FY 2020-21 FY2021-22 Adjusted Budget 128.90 142.70 144.73 131.86
Actuals (FY22 Proj) 117.84 123.59 126.99 118.56
(Over)/Under 11.06 19.11 17.74 13.30
Total Personnel FY 2018-19 FY 2019-20 FY 2020-21 FY2021-22 Adjusted Budget 132.24 145.07 148.95 150.38
Actuals (FY22 Proj) 137.49 144.22 151.21 149.61
(Over)/Under (5.25) 0.85 (2.26) 0.77
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 14
Finance and Management Committee
April 11, 2022

Fire

The Oakland Fire Department currently is on target to achieve projected savings of $0.77 million due to salary savings in the amount of $13.30 million. These savings are currently being offset by overspending in overtime which is projected to be overspent by $12.53 million. Fire’s overtime budget has been affected by staff out due to injury, staff out due to COVID-19, and extreme weather events which has made it difficult for Fire to maintain its minimum staffing levels. A historical analysis of Fire’s budget is shown in Table 12.

Overspending in overtime continues to be an issue for Fire. As Table 12 above shows, Fire's overtime went over its budgeted amount by $16.31 million in FY 2018-19, $18.26 million in FY 2019-20 and $20.00 million in FY 2020-21 and is projected to be over by $12.53 million in FY 2021-22. However, this overtime overspending was offset with savings in all other personnel (non-OT) pay. Consequently, Fire's total personnel budget has oscillated between ending close to budget or having a slight operating deficit.

Fire's overtime use is due to three main causes: their staff vacancy level with unfilled positions, their compliance with the Local 55 MOU for minimum staffing provisions, and a reduced number of Fire Academies in recent years.

However, Fire has been able to balance their overtime use with salary savings across their total personnel budget from the number of vacancies they currently have. At this point, due to Local 55 MOU, Fire has been averaging about 70% of its overtime to backfill required Fire Suppression minimum service levels. In FY 2020-21, with the increase in services due to the COVID-19 pandemic, this resulted in the highest level of overtime Fire has had in recent years.

What also contributed to Fire's higher use of overtime is that a higher level of sworn staff is on paid disability leave, which has forced the department to utilize overtime to backfill for what would otherwise be 35 present Firefighters. In addition, due to the pandemic, Fire was unable to conduct its FY 2020-21 academy to recruit more staff, which has also led to a higher usage of overtime to meet current service demands. Until Fire has more staff, this is anticipated to be a reoccurring problem. However, Fire has been managing it in part through its overall vacancy savings.

Police

The Police Department is pursuing different ways to control personnel spending. In the FY 2021-23 Biennial Budget, the administration reviewed the Oakland Police Department's service levels and overtime budget. In an effort to realign OPD service levels, there was a careful assignment of available personnel to units and sub-unit for each sworn and professional staffing positions. A new staffing plan was created which primarily focused on sworn police officers’ assignments based on current service level demands in the City of Oakland. The new staffing plan is now consistent with the availability of actual police officers based upon budget and service levels needed.

This year fewer police academy graduates anticipated, and higher attrition rates have led to current salary savings due to vacancies and has also contributed the need for additional overtime.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 15
Finance and Management Committee
April 11, 2022

As of the 12/13/2021 Position Control reports there were 62 sworn position vacancies (Captain of Police 2, Deputy Chief of Police 1, Lieutenant of Police 2, Police Officer 48, & Sergeant of Police 9).

With the realignment of OPD’s service levels, OPD is currently projected to underspend in its annual personnel budget primarily due to salary savings.

For further details, please see the OPD Second Quarter Overtime Report which has an in-depth analysis on this matter.

Historical Police Overtime

As Table 12 above shows, Police has overspent its personnel budget for the past 3 years.

However, the Police's total personnel spending is projected to end with savings this fiscal year, interrupting what has been a negative trend: in FY 2018-19 the Police's total personnel overspending amounted to being $23.64 million over their budget (10% of total budget), in FY 2019-20 it was $27.57 million over budget (11% of total budget), but in FY 2020-21 police personnel overspending was $18.85 million over budget (7% of total budget) despite rising salary and benefit costs from the City's contract-mandated COLA increase to Sworn employees.

Currently FY 2021-22 is projected to end the year with $5.83 million in savings, due to non- overtime salary savings.

In FY 2019-20, the Police spent $15.62 million in Special Enforcement overtime which accounted 37.98% of the total overtime for that year. Of this $15.62 million, police coverage of demonstrations and protests accounted for $2.63 million, sideshows enforcement accounted for $1.54 million, patrol covered $1.35 million, and Uptown walking patrol accounted for $1.11 million. To meet the FY 2020-21 midyear reductions, the Police Department began to curtail its Special Enforcement overtime in January of 2021, which dropped to $11.9 million for FY 2020-

21. In comparison to FY 2019-20, police coverage of demonstrations and protests dropped to $0.95 million, sideshows enforcement decreased to $1.11 million, patrol was reduced to $0.70 million, and the Uptown walking patrol became $0.34 million.

A significant portion of Police's personnel policies are mandated from the Negotiated Settlement Agreement (NSA), which therefore also impacts the Police Department's overtime use. Of pertinence, two of NSA mandates on Police have particular impact on patrol overtime. The first is that a patrol sergeant may not supervise more than eight officers. The second is that Police cannot use acting sergeants in patrol. Taken together, a significant amount of overtime is generated because Police must have five regular permanent (not temporary acting) sergeants in patrol for every shift to supervise the minimum of 35 officers. The NSA requires the City to therefore expend a portion of its overtime for "backfill" and "extension of shift" overtime to meet this mandate.

The work of the Reimagining Public Safety Task Force and continued public dialogue around police spending initiated the Police Department in undergoing an overhaul of its budgeting for personnel costs, including and especially overtime use, during the FY 2021-23 Biennial Budget.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 16
Finance and Management Committee
April 11, 2022

As a part of the FY 2021-23 Biennial Budget process, the Police Department provided for the first time a detailed breakdown of its overtime allocations and limited or eliminated several categories for FY 2021-22. For the upcoming year, the Police Department will not be doing coverage of demonstrations or large events and it has completely eliminated its foot patrol units.

For a more detailed explanation, please refer to the Police Department's Q4 Overtime Report.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 17
Finance and Management Committee
April 11, 2022

3. GENERAL PURPOSE FUND Q2 FUND BALANCE

The City's GPF available Fund Balance, net of obligations & other committments, is projected at $36.30 million in FY 2021-22. Obligations are reserves required by City Ordinances and the City Charter (mandated emergency & OMERS reserves). Note that $54.61 million of the mandated FY 2021-22 emergency reserves is included in the projected year-end expenditures in Table 13 below (as a committed transfer to the designated reserve GPF Emergency Reserve Fund (Fund 1011)).

Table 13 provides detail of obligations against Fund Balance, which reduces the estimated year-end FY 2021-22 Fund Balance from $135.74 million to the available balance of $36.30 million.

Table 13: FY 2021-22 Year-End Available GPF Fund Balance GENERAL PURPOSE FUND (1010) FY 2021-22 Q2
Projected FYE

Estimated FY 2021-22 Beginning Audited Fund Balance 95.46

FY2021-22 Performance
Revenue 846.17
Expenditures 805.89
FY 2020-21 Operating Surplus / Deficit 40.28

Unaudited Ending Fund Balance 135.74

Obligations Against Ending Fund Balance (93.28)
OMERS Reserves (Reso. No. 85098 C.M.S) (2.36)
Budgeted use of Fund Balance during Biennial FY21-23 (28.07) Prior Year Transfer of Fund Balance to the Emergency Reserve (Fund 1011)

(48.31)
New Revenue Subject to Excess RETT CFP Policy Including 50% for One Time Use, 25% for VSSF, 25% for Long Term Obligations

(14.54)

Other Commitments Against Fund Balance (6.16)
Fund Balance Reserved for Lake Merritt Lodge Through June 30, 2023 consistent with intent of Reso 89099

(5.13)
Contractually Obligated Transfers to Scotlan Convention Center (Report to Council Under Development)

(1.03)

Estimated FY 2021-22 Ending Available Fund Balance 36.30 Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 18
Finance and Management Committee
April 11, 2022

4. 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 City of Oakland Consolidated Fiscal Policy, Section I, Part C: Use of Excess Real Estate Transfer Tax1). 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 7.5% GPF Emergency Reserve1 is funded at $54.61 million based on the FY 2021-22 Adopted Budget (Table 14). The reserve is equivalent to almost one month of FY 2021-22 Adopted Budget of $784.39 million in GPF (8.19%). This reserve is now held in Fund 1011 as directed by Council in Resolution 88717 C.M.S. The reserve requirement, pursuant to the CFP has been met.

However, the emergency reserve policy level of 7.5% is 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 Government Finance Officer's Association's (GFOA). Additionally, this recommended level can be witnessed in the levels of funding needed in the balancing of the FY2019-20 and FY2020-21 budget by programming CARES dollars ($36.99 million), ARPA dollars ($56.13 million) and use of VSSF ($14.65 million) for a total of $107.77 million which was

15.6% of FY20 GPF expenditures. Finally, the City Auditor’s Financial Condition for Fiscal Years 212-13 through 2019-20 Report cites the need for additional reserves to bolster the city’s financial standing

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 current balance is $2.58M, the target funding level is $120.3M, or 15% of the GPF revenues.

1 The 7.5% GPF reserve is not a cumulative balance.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 19
Finance and Management Committee
April 11, 2022

Table 14: FY 2021-22 Q2 Reserve Balances ($ in millions) As Budgeted Description FYE 2021-2022
Balances
Mandated Emergency Reserves FY 2021-221 54.61
OMERS Reserves (Reso. No. 85098 C.M.S) 2.36
Vital Services Stabilization Fund 2.58
Total Reserves 59.55
1 The 7.5% GPF reserve is not a cumulative balance.

Table 15: Capital Improvements Reserves Fund

Fund
Description
FY21-22 Beg
Audited Fund
Balance
FY21-22 Year
End Rev
Projections
FY21-22 Year
End Exp
Projections
FY21-22 Bud
Contribution
To/ (Use Of)
Fund Balance
FY21-22 Year
End Avail Fund
Balance
(Unaudited)
5510 - Capital
Reserves
(1.10) 0.22 0.22 0.22 (0.88)
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 20
Finance and Management Committee
April 11, 2022

5. SELECT NON-GPF Q2 ANALYSIS

This section of the Q2 report contains additional analysis on selected non-GPF funds. For additional Fund descriptions, please visit
https://stories.opengov.com/oaklandca/published/L7kWa4FcY

This Q2 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 the adopted budget, the revenue received for the fund through Q2 and the projected budget. The expenditure tables in this section compares the FY 2021-22 Adjusted Budget to FY 2021-22 year-end estimates based on Q2 expenditure actuals for these funds.

The fund balance tables compare the FY 2021-22 audited beginning fund balance to the FY 2021-22 projected ending fund balance for these funds. Please note that some of the fund tables below show a budgeted transfer from fund balance. These amounts represent either approved obligated carryforward from the prior year or dollars designated to balance the Adopted Budget.

All other funds are summarized in Table 62 through Table 68.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 21
Finance and Management Committee
April 11, 2022

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 ounce on the sugar sweetened beverage products. The tax was imposed in 2017 on those who distribute sugar- sweetened beverage products in the City. While this revenue is not restricted by State statue, City Council has elected to restrict it by policy and separate it into its own fund.

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 - Revenues continue to decline each year in this fund at an average rate of about 10% each year since the inception of the tax beginning in FY 2017-2018. Reasons for the decline include distributors passing the tax onto the consumer through higher shelf prices that results in less demand for sugar sweetened beverages.

Based on historical and the average collection through the first six months, a decrease of $1.26 million from the FY 2021-22 adopted budget.

Table 16: FY 2021-22 Measure HH (SSBT) Fund Revenues ($ in millions) Revenue Category FY 2021-22
Adjusted Budget Q2 YTD Revenue Q2 Budget Forecast
Local Tax 8.19 2.91 6.92
Interfund Transfers 0.11 — 0.11
Project Offsets & Carryforwards 7.02 — 7.02
Total 15.32 2.92 14.05
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 22
Finance and Management Committee
April 11, 2022

Expenditures - The FY 2021-22 year-end expenditures are projected to come in at $14.62 million, which is a savings of $0.70 million when compared to the Adjusted Budget of $15.32 million.

Table 17: FY 2021-22 Measure HH (SSBT) Fund Expenditures ($ in millions)

Department
FY 2021-22
Adjusted
Budget
FY 2021-22 Q2
YTD Actuals
FY 2021-22 Q2
Year-End
Estimate
Year-End $
(Over) / Under
Adjusted
City Administrator 0.20 0.01 0.02 0.19
Finance 0.36 0.10 0.36 —
Library 0.12 — 0.12 —
Parks, Recreation, & Youth
Development

4.24 2.39 3.94 0.31
Human Services 7.24 0.80 6.46 0.78
Economic & Workforce Development 0.45 0.40 0.45 —
Public Works — 0.07 0.57 (0.57)
Transportation — — — —
Non-Departmental — — — —
Capital Improvement Projects 2.71 0.14 2.72 —
Total Expenditures 15.32 3.91 14.62 0.70
*The adjusted budget includes Council Budget Amendments and Carryforwards Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 23
Finance and Management Committee
April 11, 2022

Fund Balance - FY 2021-22 revenue is projected to end the year at $14.05 million. Expenditures are projected to end the year at $14.62 million. The adjusted budget assumes fund balance to balance expenditures and support Carryforwards, in the amount of $-7.02 million. As a result, the fund balance in the Measure HH (SSBT) is projected to decrease from $7.82 million in FY 2020-21 to $0.23 million in FY 2021-22.

Table 18: Measure HH (SSBT) Fund Year-End Available Fund Balance ($ in millions) MEASURE HH SSBT (1030) FY 2021-22 Q2 Year-
End Estimate

Beginning Fund Balance – Audited 7.82
Revenue (including CarryForward) 14.05
Expenditures 14.62
Estimated Current Year Surplus/(Shortfall) (0.57)
Subtotal Fund Balance 7.26

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance (7.02)
Budgeted Fund Balance Repayment —
Estimated Ending Fund Balance 0.23
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 24
Finance and Management Committee
April 11, 2022

Self-Insurance Liability Fund (1100)

The Self-Insurance Liability Fund (1100) receives contributions from the General Purpose Fund and select funds to cover costs associated with liability claims and settlements, insurance premiums, outside legal services, and court costs. Projecting these costs, particularly the settlements, are difficult as they are driven by unpredictable lawsuits which have varying settlement values. Additionally, Insurance costs continue to increase over time due to market factors within the national insurance environment. Fixes will be in arrears as the negative balances must be trued up.

Revenues: - FY 2021-22 year-end revenues are projected to come in at $56.77 million, which are higher by $0.33 million when compared to the Adjusted Budget of $56.44 million.

Expenditures - FY 2021-22 year-end expenditures are projected to come in at $55.83 million, which is a savings of $0.61 million, compared to the Adjusted Budget of $56.44 million.

Table 19: FY 2021-22 Self-Insurance Liability Fund Expenditures ($ in millions)

Department FY 2021-22
Adjusted Budget
FY 2021-22 Q2
YTD Actuals
FY 2021-22 Q2
Year-End
Estimate
Year-End $
(Over) / Under
Adjusted Budget
City Attorney 3.92 0.20 3.31 0.61
Police 4.97 0.90 4.97 —
Fire 1.93 0.15 1.93 —
Parks, Recreation, & Youth
Development

0.59 — 0.59 —
Public Works 4.64 1.32 4.64 —
Non-Departmental 40.39 19.49 40.39 —
Total Expenditures 56.44 22.06 55.83 0.61
*The adjusted budget includes Council Budget Amendments and Carryforwards

Fund Balance - FY 2021-22 revenue is projected to end the year at $56.77 million. Expenditures are projected to end the year at $55.83 million. The adjusted budget assumes fund balance, to balance expenditures and support Carryforwards, in the amount of $-1.01 million. Inversely, there is a budgeted contribution to fund balance in the amount of $1.80 million. As a result, the fund balance in the Self-Insurance Liability Fund (1100) is projected to decrease from negative $19.07 million in FY 2020-21 to negative $17.34 million in FY 2021-22.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 25
Finance and Management Committee
April 11, 2022

Table 20: FY 2021-22 Self-Insurance Liability Fund Year-End Available Fund Balance ($ in millions)
SELF-INSURANCE LIABILITY FUND (1100) FY 2021-22 Year-End Estimate

Beginning Fund Balance – Audited (19.07)
Revenue 56.77
Expenditures 55.83
Estimated Current Year Surplus/(Shortfall) 0.94
Subtotal Fund Balance (18.13)

FY2021-22 Budgeted Contribution to Fund Balance
Budgeted Transfer from Fund Balance (1.01)
FY2021-22 Budgeted Contribution to Fund Balance 1.80
Estimated Ending Fund Balance (17.34)
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 26
Finance and Management Committee
April 11, 2022

Comprehensive Clean-Up Fund (1720)

The Comprehensive Clean-Up Fund (1720) collects revenues from a special surcharge on refuse collection bills to cover costs associated to illegal dumping enforcement, street sweeping, custodial services, and other clean-up activities.

Revenues: - FY 2021-22 year-end revenues are projected to come in at $26.18 million, which are higher by $0.02 million when compared to the Adjusted Budget of $26.16 million.

Expenditures - FY 2021-22 year-end expenditures are projected to come in at $23.78 million, which is a savings of $2.38 million when compared to the Adjusted Budget of $26.16 million.

Table 21: FY 2021-22 Comprehensive Clean-Up Fund Expenditures ($ in millions)

Department
FY 2021-22
Adjusted
Budget

FY 2021-22 Q2
YTD Actuals
FY 2021-22 Q2
Year-End
Estimate
Year-End $
(Over) / Under
Adjusted
Budget
City Administrator 0.18 0.09 0.18 (0.01)
City Attorney 0.31 0.19 0.37 (0.06)
Fire 0.22 — 0.21 0.01
Human Services — — — —
Economic & Workforce Development — — — —
Public Works 25.46 10.83 23.01 2.44
Total Expenditures 26.16 11.11 23.78 2.38
*The adjusted budget includes Council Budget Amendments and Carryforwards Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 27
Finance and Management Committee
April 11, 2022

Fund Balance - FY 2021-22 revenue is projected to end the year at $26.18 million. Expenditures are projected to end the year at $23.78 million. The adjusted budget assumes fund balance, to balance expenditures and support Carryforwards, in the amount of $-2.75 million. As a result, the fund balance in the Comprehensive Clean-Up Fund (1720) is projected to decrease from $4.31 million in FY 2020-21 to $3.96 million in FY 2021-22.

Table 22: FY 2021-22 Comprehensive Clean-Up Fund Year-End Fund Balance ($ in millions)

COMPREHENSIVE CLEAN-UP FUND (1720) FY 2021-22 Year-End
Estimate

Beginning Fund Balance – Audited 4.31
Revenue 26.18
Expenditures 23.78
Estimated Current Year Surplus/(Shortfall) 2.40
Subtotal Fund Balance 6.71

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance (2.75)
Budgeted Fund Balance Repayment —
Estimated Ending Fund Balance 3.96
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 28
Finance and Management Committee
April 11, 2022

Multipurpose Reserve Fund (1750)

The Multi-Purpose Reserve Fund (1750) collects fees from City-owned off-street parking facilities, and other revenues at Council discretion. The off-street parking facilities revenue is not derived from a special, restricted revenue source, it is restricted by Council policy to use for parking facility construction and operation. All other revenue may be spent at Council discretion.

Revenues: - FY 2021-22 year-end revenues are projected to come in at $12.15 million, which is at budget.

Expenditures - FY 2021-22 year-end expenditures are projected to come in at $11.52 million, which is a savings of $0.63 million when compared to the Adjusted Budget of $12.15 million.

Table 23: FY 2021-22 Multipurpose Reserve Fund Expenditures ($ in millions)

Department FY 2021-22
Adjusted Budget
FY 2021-22 Q2
YTD Actuals
FY 2021-22 Q2
Year-End
Estimate
Year-End $
(Over) / Under
Adjusted Budget
City Administrator 0.07 0.04 0.08 (0.01)
Finance 0.59 0.10 0.54 0.05
Economic & Workplace Development 0.05 — 0.05 —
Transportation 8.50 1.61 7.17 1.32
Non-Departmental 2.90 — 3.64 (0.73)
Capital Improvement Projects 0.04 — 0.04 —
Total Expenditures 12.15 1.75 11.52 0.63
*The adjusted budget includes Council Budget Amendments and Carryforwards Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 29
Finance and Management Committee
April 11, 2022

Fund Balance - FY 2021-22 revenue is projected to end the year at $12.15 million. Expenditures are projected to end the year at $11.52 million. The adjusted budget assumes fund balance, to balance expenditures and support Carryforwards, in the amount of $-1.30 million. Inversely, there is a budgeted contribution to fund balance in the amount of $0.73 million. As a result, the fund balance in the Multipurpose Reserve Fund (1750) is projected to increase from negative $0.66 million in FY 2020-21 to negative $0.60 million in FY 2021-22.

Table 24: FY 2021-22 Multipurpose Reserve Fund Year-End Available Fund Balance ($ in millions)

MULTIPURPOSE RESERVE FUND (1750) FY 2021-22 Year-End
Estimate

Beginning Fund Balance – Audited (0.66)
Revenue 12.15
Expenditures 11.52
Estimated Current Year Surplus/(Shortfall) 0.63
Subtotal Fund Balance (0.03)

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance (1.30)
FY2021-22 Budgeted Contribution to Fund Balance 0.73
Estimated Ending Fund Balance (0.60)
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 30
Finance and Management Committee
April 11, 2022

OPRCA Self Sustaining Revolving Fund (1820)

The OPRCA Self Sustaining Revolving Fund (1820) is a fee-based fund that supports Oakland Parks, Recreation and Youth Development's (OPRYD) recreation, cultural arts, science, sports, and aquatics programs for families in Oakland. Revenues in this fund have been significantly impacted by COVID-19 and the mandated stay-in-place orders that closed OPRYD facilities and decreased the availability of provided services.

Revenues: - FY 2021-22 year-end revenues are projected to come in at $3.93 million, which are lower by $3.94 million when compared to the adjusted budget of $7.87 million.

Expenditures - Projected expenditures are $5.53 million, which is a savings of $2.33 million compared to the Adjusted Budget of $7.87 million.

Table 25: FY 2021-22 OPRCA Self Sustaining Revolving Fund Expenditures ($ in millions)

Department FY 2021-22
Adjusted Budget
FY 2021-22 Q2
YTD Actuals
FY 2021-22 Q2
Year-End
Estimate
Year-End $
(Over) / Under
Adjusted Budget
Parks, Recreation, & Youth
Development

7.87 2.44 5.53 2.33
Total Expenditures 7.87 2.44 5.53 2.33
*The adjusted budget includes Council Budget Amendments and Carryforwards

Fund Balance - FY 2021-22 revenue is projected to end the year at $3.93 million. Expenditures are projected to end the year at $5.53 million. The adjusted budget assumes fund balance, to balance expenditures and support Carryforwards, in the amount of $-0.07 million. As a result, the fund balance in the OPRCA Self Sustaining Revolving Fund (1820) is projected to decrease from $3.54 million in FY 2020-21 to $1.87 million in FY 2021-22.

Table 26: FY 2021-22 OPRCA Self Sustaining Revolving Fund Year-End Available Fund Balance ($ in millions)

OPRCA SELF SUSTAINING REVOLVING FUND (1820) FY 2021-22 Year-End Estimate

Beginning Fund Balance – Audited 3.54
Revenue 3.93
Expenditures 5.53
Estimated Current Year Surplus/(Shortfall) (1.60)
Subtotal Fund Balance 1.94

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance (0.07)
Budgeted Contribution to Fund Balance —
Estimated Ending Fund Balance 1.87
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 31
Finance and Management Committee
April 11, 2022

Affordable Housing Fund (1870)

The Affordable Housing Trust Fund (1870) receives revenue from jobs/housing impact fees, affordable housing impact fees, fines and penalties, and redevelopment dissolution funds from the County's Real Property Tax Trust Fund (RPTTF). RPTTF is a unrestricted property tax revenue source collected by the County, however, City Council has chosen to restrict 25% of its value for uses related to affordable housing. Fund 1870 revenues are then provided as loans and grants for the development of rental and owner-occupied affordable housing within the City.

Revenues: - FY 2021-22 year-end revenues are projected to come in at $51.62 million, which are higher by $1.02 million when compared to the Adjusted Budget of $50.60 million.

Expenditures - FY 2021-22 year-end expenditures are projected to come in at $49.29 million, which is a savings of $1.31 million compared to the Adjusted Budget of $50.60 million.

Table 27: FY 2021-22 Affordable Housing Fund (1870) Expenditures ($ in millions)

Department FY 2021-22
Adjusted Budget
FY 2021-22 Q2
YTD Actuals
FY 2021-22 Q2
Year-End
Estimate
Year-End $ (Over)
/ Under Adjusted
Budget
City Administrator 0.22 0.12 0.24 (0.01)
City Attorney 0.17 0.09 0.17 (0.01)
Finance 0.24 0.13 0.24 0.01
Human Resources 0.12 0.07 0.14 (0.02)
Housing & Community
Development

0.38 3.93

0.38 —
Planning & Building 49.47 — 48.12 1.35
Total Expenditures 50.60 4.35 49.29 1.31
*The adjusted budget includes Council Budget Amendments and Carryforwards Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 32
Finance and Management Committee
April 11, 2022

Fund Balance - FY 2021-22 revenue is projected to end the year at $51.62 million. Expenditures are projected to end the year at $49.29 million. The adjusted budget assumes fund balance to balance expenditures and support Carryforwards in the amount of $-35.02 million. As a result, the fund balance in the Affordable Housing Trust Fund (1870) is projected to decrease from $38.49 million in FY 2020-21 to $5.80 million in FY 2021-22.

Table 28: FY 2021-22 Affordable Housing Trust Fund Balance ($ in millions)

AFFORDABLE HOUSING TRUST FUND (1870) FY 2021-22 Year-End Estimate

Beginning Fund Balance – Audited 38.49
Revenue 51.62
Expenditures 49.29
Estimated Current Year Surplus/(Shortfall) 2.34
Subtotal Fund Balance 40.83

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance (35.02)
Budgeted Contribution to Fund Balance —
Estimated Ending Fund Balance 5.80
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 33
Finance and Management Committee
April 11, 2022

Measure B/BB & Measure F Funds (2211, 2212, 2213, 2215, 2216, 2217, 2218, 2219, 2220)

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

3. Measure B, passed by voters in 2000, authorized a special half-cent sales tax and will be in effect for 20 years. Sales tax collection began on April 1, 2002 and will extend through March 31, 2022. Uses of funds support traffic and transportation projects, including street and signal construction, bicycle and pedestrian, paratransit, roads maintenance and repair.

4. 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 will extend through March 31, 2022. The full one-cent sales tax authorized by Measure BB will begin 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.

5. 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.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 34
Finance and Management Committee
April 11, 2022

Revenues - Based on the current collection trends and updates provided by the Alameda County Transportation Commission, revenues from these Measures are expected to meet the adopted budget.

Table 29: FY 2021-22 Measure B, BB & F Fund Revenues ($ in millions) Revenue Category FY 2021-22
Adjusted Budget Q2 YTD Revenue Q2 Budget Forecast
Sales Tax 28.38 11.04 28.56
Interest Income — 0.02 0.02
Service Charges 0.12 0.05 0.12
Grants & Subsidies 1.81 — 1.81
Miscellaneous Revenue — 0.42 0.42
Interfund Transfers 2.42 — 2.42
Transfers from Fund Balance 3.92 — 3.92
Project Offsets & Carryforwards 14.03 — 14.03
Total 50.68 11.53 51.30

Expenditures - FY 2021-22 year-end expenditures are projected to come in at $47.14, which is a savings of $3.24 million compared to the Adjusted Budget of $50.38 million.

Table 30: FY 2021-22 Measure B/BB/F Funds Expenditures ($ in millions)

Department FY 2021-22
Adjusted Budget
FY 2021-22 Q2
YTD Actuals
FY 2021-22 Q2
Year-End
Estimate
Year-End $
(Over) / Under
Adjusted Budget
Mayor 0.21 0.08 0.16 0.05
City Attorney 0.04 0.02 0.05 (0.01)
Finance 0.09 0.04 0.08 0.02
Human Services 1.00 0.74 3.96 (2.96)
Public Works 4.55 0.06 1.26 3.28
Transportation 0.03 7.60 24.29 (24.27)
Non-Departmental 27.15 — 0.03 27.13
Capital Improvement Projects 17.31 0.47 17.31 —
Total Expenditures 50.38 9.01 47.14 3.24
*The adjusted budget includes Council Budget Amendments and Carryforwards Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 35
Finance and Management Committee
April 11, 2022

Fund Balance - FY 2021-22 revenue is projected to end the year at $51.30 million. Expenditures are projected to end the year at $47.14 million. The adjusted budget assumes fund balance, to balance expenditures and support Carryforwards, in the amount of $-17.95 million. As a result, the fund balance in the Measure B/BB and Measure F Funds (2211, 2212, 2213, 2215, 2217, 2218, 2219, 2220) is projected to decrease from $31.21 million in FY 2020-21 to $17.42 million in FY 2021-22.

Table 31: FY 2021-22 Measure B/BB/F Funds Year-End Available Fund Balance ($ in millions)
Measure B/BB/F Funds
(2211, 2212, 2213, 2215, 2216, 2217, 2218, 2219, 2220)
FY 2021-22 Year-End
Estimate

Beginning Fund Balance – Audited 31.21
Revenue 51.30
Expenditures 47.14
Estimated Current Year Surplus/(Shortfall) 4.16
Subtotal Fund Balance 35.37

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance -17.95
Budgeted Contribution to Fund Balance 0.00
Estimated Ending Fund Balance 17.42
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 36
Finance and Management Committee
April 11, 2022

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 - Based on the current collection trends and updates provided by the state, revenues from these sources are expected to exceed the budget by approximately $3.58 million.

Table 32: FY 2021-22 State Transportation Gas Tax Fund Revenues ($ in millions) Revenue Category FY 2021-22
Adjusted Budget Q2 YTD Revenue Q2 Budget Forecast
Gas Tax 18.65 7.01 20.24
Service Charges 0.01 — 0.01
Grants & Subsidies 0.14 — 0.14
Miscellaneous Revenue — 1.99 1.99
Transfers from Fund Balance 0.85 — 0.85
Project Offsets & Carryforwards 3.37 — 3.37
Total 23.02 9.01 26.60

Expenditures - FY 2021-22 year-end expenditures are projected to come in at $17.96 million, which is a savings of $3.15 million when compared to the Adjusted Budget of $21.11 million.

Table 33: FY 2021-22 State Transportation Funds Gas Tax Expenditures ($ in millions)

Department
FY 2021-22
Adjusted
Budget*

FY 2021-22 Q2
YTD Actuals
FY 2021-22 Q2
Year-End
Estimate
Year-End $
(Over) / Under
Adjusted
Budget
City Administrator 0.15 0.05 0.11 —
Economic & Workforce Development 0.07 0.06 0.07 0.08
Public Works 0.08 — 0.01 —
Transportation 20.81 6.76 15.86 —
Capital Improvement Projects — 0.01 1.91 —
Total Expenditures 21.11 6.89 17.96 $ 3.15
*The adjusted budget includes Council Budget Amendments and Carryforwards Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 37
Finance and Management Committee
April 11, 2022

Fund Balance - FY 2021-22 revenue is projected to end the year at $26.60 million. Expenditures are projected to end the year at $$17.96 million. The adjusted budget assumes fund balance, to balance expenditures and support Carryforwards, in the amount of $4.22 million. As a result, the fund balance in the State Transportation Gas Tax Funds (2230, 2232) is projected to increase from $4.59 million in FY 2020-21 to $9.01 million in FY 2021-22.

Table 34: FY 2021-22 State Transportation Funds Year-End Available Fund Balance ($ in millions)

State Transportation Funds - Gas Tax (2230, 2232)
FY 2021-22 Year-End
Estimate

Beginning Fund Balance - Audited 4.59
Revenue 26.60
Expenditures 17.96
Estimated Current Year Surplus/(Shortfall) 8.64
Subtotal Fund Balance 13.23

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance (4.22)
Budgeted Fund Balance Repayment —
Estimated Ending Fund Balance 9.01
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 38
Finance and Management Committee
April 11, 2022

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 - Based on the collection through the first half of the year, a decrease of approximately $0.54 million is forecast for the FY 2021-22 adopted budget.

Table 35: FY 2021-22 Preservation, Litter Reduction, Homelessness Support Act Fund Revenues ($ in millions)

Revenue Category FY 2021-22
Adjusted Budget

Q2 YTD Revenue

Q2 Budget Forecast
Local Tax 27.50 13.78 26.77
Interest Income 0.00 0.01 0.01
Miscellaneous Revenue 0.00 0.19 0.19
Transfer from Fund Balance 1.58 0.00 1.58
Project Offsets & Carryforwards 11.14 0.00 11.14
Total 40.22 13.98 39.68
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 39
Finance and Management Committee
April 11, 2022

Expenditures - FY 2021-22 year-end expenditures are projected to come in at $40.15 million, which is a savings of $0.07 million when compared to the Adjusted Budget of $40.22 million.

Table 36: FY 2021-22 Measure Q - OPR Preservation, Litter Reduction, Homelessness Support Act Expenditures ($ in millions)

Department
FY 2021-22
Adjusted
Budget

FY 2021-22 Q2
YTD Actuals
FY 2021-22 Q2
Year-End
Estimate
Year-End $
(Over) / Under
Adjusted
Budget
City Administrator 2.40 0.06 2.33 0.07
Finance 0.11 0.11
Parks, Recreation & Youth
Development

0.25 — 0.25 —
Human Services 10.24 1.1 10.24
Public Works 25.39 7.3 25.39
Transportation — — — —
Non-Departmental 0.92 0.92
Capital Improvement Projects 0.93 — 0.93 —
Total Expenditures 40.22 8.5 40.15 0.0
*The adjusted budget includes Council Budget Amendments and Carryforwards

Fund Balance - FY 2021-22 revenue is projected to end the year at $39.68 million. Expenditures are projected to end the year at $40.15 million. The adjusted budget assumes the use of fund balance to support $12.72 million of carryforward funds. As a result, the fund balance in the Measure Q Fund (2252) is projected to decrease from $11.99 million in FY 2020-21 to negative $1.20 million in FY 2021-22.

Table 37: FY 2021-22 Measure Q Year-End Fund Balance ($ in millions)

MEASURE Q (2244) FY 2021-22 Year-End
Estimate

Beginning Fund Balance - Audited 11.99
Revenue 39.68
Expenditures 40.15
Estimated Current Year Surplus/(Shortfall) (0.47)
Subtotal Fund Balance 11.52

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance (12.72)
Budgeted Fund Balance Repayment —
Estimated Ending Fund Balance (1.20)
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 40
Finance and Management Committee
April 11, 2022

Measure Z - Public Safety and Services Violence Prevention Act of 2014 Fund (2252)

Measure Z, the Public Safety and Services Violence Prevention Act of 2014 Fund (2252), is a City of Oakland ballot initiative approved in November 2014 that provides annual funding for 10 years for violence prevention programs, police officers, fire services, and evaluation services.

The measure requires a citizen's oversight commission to oversee the proper administration of the revenue collection, spending, and implementation of the strategies funded through the measure. The Measure has two revenue sources: a parcel tax which is stable and grows with inflation, and an 8.5% parking tax which is subject to economic pressures.

Revenues - Based on the collection through the first half of the year, an increase of approximately $1.26 million is projected to the FY 2021-22 adopted budget due to expected improved parking activities at the airport from the lows experienced in FY2020-21.

Table 38: FY 2021-22 Public Safety and Services Violence Prevention Act of 2014 Fund Revenues ($ in millions)
Revenue Category FY 2021-22
Adjusted Budget Q2 YTD Revenue Q2 Budget Forecast
Parking Tax 7.43 3.62 8.70
Local Tax 19.00 9.62 19.00
Project Offsets & Carryforwards 2.47 0.00 2.47
Total 28.90 13.24 30.17

Expenditures - FY 2021-22 year-end expenditures are projected to come in at $29.17, which is a savings of $(0.27) million when compared to the Amended Budget of $28.90 million

Table 39: FY 2021-22 Measure Z Fund Expenditures ($ in millions)

Department
FY 2021-22
Adjusted
Budget

FY 2021-22 Q2
YTD Actuals
FY 2021-22 Q2
Year-End
Estimate
Year-End $
(Over) / Under
Adjusted
Budget
City Administrator 0.88 0.04 0.96 (0.07)
Finance 0.36 0.18 0.36 —
Violence Prevention 13.21 2.83 12.31 0.90
Police 11.96 5.79 14.23 (2.27)
Fire 2.00 0.50 0.90 1.10
Human Services 0.48 — 0.42 0.06
Non-Departmental — — — —
Total Expenditures 28.90 9.33 29.17 (0.27)
*The adjusted budget includes Council Budget Amendments and Carryforwards Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 41
Finance and Management Committee
April 11, 2022

Fund Balance - FY 2021-22 revenue is projected to end the year at $$30.17 million.

Expenditures are projected to end the year at $29.17 million. The adjusted budget assumes the use of fund balance to support $2.47 million of carryforward funds. As a result, the fund balance in the Measure Q Fund (2252) is projected to decrease from $1.73 million in FY 2020-21 to $0.26 million in FY 2021-22 .

Table 40: FY 2021-22 Measure Q Year-End Fund Balance ($ in millions)

MEASURE Z (2252)

FY 2021-22 Year-End
Estimate

Beginning Fund Balance - Audited 1.73
Revenue 30.17
Expenditures 29.17
Estimated Current Year Surplus/(Shortfall) 1.00
Subtotal Fund Balance 2.73

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance (2.47)
Budgeted Fund Balance Repayment —
Estimated Ending Fund Balance 0.26
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 42
Finance and Management Committee
April 11, 2022

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 - Based on the collections in the first year, a decrease of $1.40 million is projected due to higher than anticipated delinquencies combined with the newly revised valuation threshold by the County of Alameda to exempt properties with valuations of $10,000 or less.

Table 41: FY 2021-22 Vacant Property Tax Fund Revenues ($ in millions) Revenue Category FY 2021-22
Adjusted Budget Q2 YTD Revenue Q2 Budget Forecast
Local Tax 7.00 4.40 5.60
Transfers from Fund Balance 2.48 — 2.48
Project Offsets & Carryforwards 2.87 — 2.87
Total 12.35 4.40 10.95

Expenditures - FY 2021-22 year-end expenditures are projected to come in at $10.72 million, which is a savings of $1.63 million when compared to the Adjusted Budget of $12.35 million.

Table 42: FY 2021-22 Vacant Property Tax Fund Expenditures ($ in millions)

Department
FY 2021-22
Adjusted
Budget*

FY 2021-22 Q2
YTD Actuals
FY 2021-22 Q2
Year-End
Estimate
Year-End $
(Over) / Under
Adjusted
Budget
City Administrator 0.56 0.14 0.41 0.15
Finance 0.82 0.37 0.73 0.09
Human Services 2.27 — 2.11 0.17
Housing & Community Development 0.50 — 0.50 —
Public Works 8.20 2.78 6.98 1.23
Total Expenditures 12.35 3.29 10.72 1.63
*The adjusted budget includes Council Budget Amendments and Carryforwards Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 43
Finance and Management Committee
April 11, 2022

Fund Balance - FY 2021-22 revenue is projected to end the year at $10.95 million. Expenditures are projected to end the year at $10.72 million. The adjusted budget assumes the use of fund balance to support $5.35 million of prior year carryforward funds. As a result, the fund balance in the Development Service Fund (2415) is projected to decrease from $0.94 million in FY 2020-21 to negative $4.18 million in FY 2021-22.

Table 43: FY 2021-22 Vacant Property Tax Fund Year-End Available Fund Balance ($ in millions)

VACANT PROPERTY TAX ACT FUND (2270) FY 2021-22 Year-End Estimate

Beginning Fund Balance - Audited 0.94
Revenue 10.95
Expenditures 10.72
Estimated Current Year Surplus/(Shortfall) 0.23
Subtotal Fund Balance 1.17

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance (5.35)
Budgeted Fund Balance Repayment —
Estimated Ending Fund Balance (4.18)
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 44
Finance and Management Committee
April 11, 2022

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: - FY 2021-22 year-end revenues are projected to come in at $20.08 million, which are higher by $0.06 million when compared to the Adjusted Budget of $20.02 million.

Expenditures - FY 2021-22 year-end expenditures are projected to come in at $19.62 million, which is a savings of $0.40 million when compared to the Adjusted Budget of $20.02 million.

Table 44: FY 2021-22 Landscaping and Lighting Assessment District (LLAD) Fund Expenditures ($ in millions)

Department
FY 2021-22
Adjusted
Budget

FY 2021-22 Q2
YTD Actuals
FY 2021-22 Q2
Year-End
Estimate
Year-End $
(Over) / Under
Adjusted
Budget
Finance 0.02 0.00 0.02 0.00
Parks, Recreation & Youth
Development

3.79 3.67 3.67 0.11
Public Works 8.41 4.13 8.12 0.29
Transportation 2.69 1.78 2.69 0.00
Non Departmental and Port 5.11 5.11 0.00
Capital Improvement Projects 0.00 0.00 0.00 0.00
Total Expenditures 20.02 9.58 19.62 0.40
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 45
Finance and Management Committee
April 11, 2022

Fund Balance - FY 2021-22 revenue is projected to end the year at $20.06 million. Expenditures are projected to end the year at $19.62 million. The adjusted budget assumes the use of fund balance to support prior year Carryforwards in the amount of $0.61 million. As a result, the fund balance in the Development Service Fund (2415) is projected to decrease from $0.05 million in FY 2020-21 to $0.24 million in FY 2021-22.

Table 45: FY 2021-22 Landscaping and Lighting Assessment District (LLAD) Fund Balance ($ in millions)

LANDSCAPING & LIGHTING ASSESSMENT DISTRICT FUND (2310) FY 2021-22 Year-End Estimate

Beginning Fund Balance - Audited 0.05
Revenue 20.06
Expenditures 19.62
Estimated Current Year Surplus/(Shortfall) 0.43
Subtotal Fund Balance 0.48

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance (0.61)
Budgeted Fund Balance Repayment 0.36
Estimated Ending Fund Balance 0.24
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 46
Finance and Management Committee
April 11, 2022

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. Furthermore, this fund is required to keep a minimum 7.5% reserve of annual budgeted revenues for its balance, which would be $8.10 million.

Table 46: Historical Revenue for Fund 2415
Fiscal Year Budgeted Revenue Actual Revenue
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

Expenditures - FY 2021-22 year-end expenditures are projected to come in at $114.15 million, which is a savings of $16.76 million when compared to the Adjusted Budget of $130.91 million.

Table 47: FY 2021-22 Development Service Fund Expenditures ($ in millions)

Agency / Department
FY 2021-22
Adjusted
Budget*

FY 2021-22 Q2
YTD Actuals
FY 2021-22 Q2
Year-End
Estimate
Year-End $ (Over)
/ Under Adjusted
Budget
Mayor 0.32 0.19 0.38 (0.05)
City Administrator 2.37 0.93 2.12 0.25
City Attorney 3.06 1.61 3.15 (0.09)
Finance 1.02 0.50 1.01 0.01
Information Technology 1.67 0.68 1.37 0.30
Human Resources 0.94 0.45 0.86 0.08
Fire 9.43 2.78 6.56 2.88
Economic & Workforce Development 0.75 0.37 0.77 (0.02)
Planning & Building 80.46 20.05 69.82 10.64
Public Works 4.50 0.51 3.93 0.57
Transportation 17.77 3.76 15.58 2.19
Non-Departmental 8.60 0.00 8.60 —
Total Expenditures 130.91 31.84 114.15 16.76
*The adjusted budget includes Council Budget Amendments and Carryforwards Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 47
Finance and Management Committee
April 11, 2022

Fund Balance - The large fund balance, $146.66 million at the end of FY 2020-21, 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. Furthermore, this fund is required to keep a minimum 7.5% reserve of annual budgeted revenues for its balance, which would be $8.10 million.

FY 2021-22 revenue is projected to end the year at $131.02 million. Expenditures are projected to end the year at $114.15 million. The adjusted budget assumes the use of fund balance to support prior year carryforwards in the amount of $77.10 million. As a result, the fund balance in the Development Service Fund (2415) is projected to decrease from $146.66 million in FY 2020-21 to $86.43 million in FY 2021-22 .

Table 48: FY 2021-22 Development Service Fund Year-End Available Fund Balance ($ in millions)

DEVELOPMENT SERVICE FUND (2415)

FY 2021-22 Year-End
Estimate

Beginning Fund Balance - Audited 146.66
Revenue 131.02
Expenditures 114.15
Estimated Current Year Surplus/(Shortfall) 16.87
Subtotal Fund Balance 163.53

Use of Fund Balance in FY 2021-22
FY2021-22 Budgeted Transfer from Fund Balance (77.10)
Budgeted Fund Balance Repayment —
Estimated Ending Fund Balance 86.43
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 48
Finance and Management Committee
April 11, 2022

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 - Based on current collection trends and updates, revenues from this fund are expected to meet the adopted budget.

Table 49: FY 2021-22 Transient Occupancy Tax (Measure C) Fund Revenues ($ in millions) Revenue Category FY 2021-22
Adjusted Budget Q2 YTD Revenue Q2 Budget Forecast
Transient Occupancy Tax 4.56 1.85 4.56
Project Offsets & Carryforwards 0.07 — 0.07
Total 4.64 1.85 4.64

Expenditures - FY 2021-22 year-end expenditures are projected to come in at $4.64 million, which is equal to the adjusted budget of $4.64 million.

Table 50: FY 2021-22 Measure C Projected Year-End Totals ($ in millions)

Department
FY 2021-22
Adjusted
Budget

FY 2021-22 Q2
YTD Actuals
FY 2021-22 Q2
Year-End
Estimate
Year-End $
(Over) / Under
Adjusted
Budget
Economic & Workforce Development 0.65 0.19 0.65 —
Non-Departmental 3.99 1.08 3.99 —
Total Expenditures 4.64 1.27 4.64 —
*The adjusted budget includes Council Budget Amendments and Carryforwards Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 49
Finance and Management Committee
April 11, 2022

Fund Balance - FY 2021-22 revenues and expenditures are both projected to end the year at $4.64 million. The adjusted revenue assumes the use of fund balance to support prior year carryforwards in the amount of $0.07 million. As a result, the fund balance in the Measure C Fund (2419) is projected to decrease from $0.22 million in FY 2020-21 to $0.15 million in FY 2021-22.

Table 51: FY 2021-22 Measure C Fund Year-End Available Fund Balance ($ in millions)

MEASURE C - TRANSIENT OCCUPANCY TAX FUND (2419) FY 2021-22 Year-End Estimate

Beginning Fund Balance - Audited 0.22
Revenue 4.64
Expenditures 4.64
Estimated Current Year Surplus/(Shortfall) 0.00
Subtotal Fund Balance 0.22

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance (0.07)
Budgeted Fund Balance Repayment —
Estimated Ending Fund Balance 0.15
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 50
Finance and Management Committee
April 11, 2022

Reproduction Fund (4300)

The Reproduction Fund (4300) is reported on a modified full accrual basis to reflect current assets and liabilities. Revenues are generated from equipment rental and services charges to operating departments for personnel, maintenance, and replacement of equipment in the City's print shop.

Revenues: - FY 2021-22 year-end revenues are projected to come in at $1.70 million, which is equal to the adjusted budget of $1.70 million.

Expenditures - FY 2021-22 expenditures are projected to end the year at $1.70 million, which is equal to the adjusted budget of $1.70 million.

Table 52: FY 2021-22 Reproduction Fund Projected Year-End Totals ($ in millions)

Department
FY 2021-22
Adjusted
Budget*

FY 2021-22 Q2
YTD Actuals
FY 2021-22 Q2
Year-End
Estimate
Year-End $
(Over) / Under
Adjusted
Budget
Information Technology Department 1.39 0.44 1.39 —
Non-Departmental 0.30 — 0.30 —
Total Expenditures 1.70 0.44 1.70 —
*The adjusted budget includes Council Budget Amendments and Carryforwards Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 51
Finance and Management Committee
April 11, 2022

Fund Balance - FY 2021-22 revenue is projected to end the year at $1.70 million. Expenditures are projected to end the year at $1.70 million. The adjusted budget assumes the use of fund balance to support prior year carryforwards in the amount of $0.05 million and includes a budgeted transfer to fund balance in the amount of $0.30 million. As a result, the fund balance in the Reproduction Fund (4300) is projected to Increase from a negative $1.31 million in FY 2020-21 to a negative $1.05 million in FY 2021-22.

Table 53: FY 2021-22 Reproduction Fund Year-End Available Fund Balance ($ in millions)

REPRODUCTION FUND (4300) FY 2021-22 Year-End
Estimate

Beginning Fund Balance - Audited (1.31)
Revenue 1.70
Expenditures 1.70
Estimated Current Year Surplus/(Shortfall) 0.00
Subtotal Fund Balance (1.31)

Use of Fund Balance in FY 2020-21
Budgeted Transfer from Fund Balance (0.05)
Budgeted Fund Balance Repayment 0.30
Estimated Ending Fund Balance (1.05)
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 52
Finance and Management Committee
April 11, 2022

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: - FY 2021-22 year-end revenues are projected to come in at $43.62 million, which is higher by $0.01 million when compared to the adjusted budget of $43.61 million.

Expenditures - FY 2021-22 expenditures are projected to end the year at $41.27 million, which is a savings $2.34 million when compared to the adjusted budget of $43.61 million.

Table 54: FY 2021-22 City Facilities Projected Year-End Totals ($ in millions)

Department
FY 2021-22
Adjusted
Budget*

FY 2021-22
Q2 YTD Actuals
FY 2021-22
Q2 Year-End
Estimate
Year-End $
(Over) / Under
Adjusted
Budget
Human Resources 0.02 — 0.02 —
Human Services 0.77 0.36 0.74 0.03
Public Works 42.47 17.61 40.17 2.31
Transportation 0.05 0.02 0.05 0.01
Non-Departmental 0.28 — 0.28 —
Capital Improvement Project 0.02 — 0.02 —
Total Expenditures 43.61 17.99 41.27 2.34
*The adjusted budget includes Council Budget Amendments and Carryforwards Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 53
Finance and Management Committee
April 11, 2022

Fund Balance - FY 2021-22 revenue is projected to end the year at $43.62 million. Expenditures are projected to end the year at $41.27 million. The adjusted budget assumes the use of fund balance to support prior year carryforwards in the amount of $3.95 million. As a result, the fund balance in the Reproduction Fund (4400) is projected to decrease from $2.83 million in FY 2020-21 to $1.23 million in FY 2021-22.

Table 55: FY 2021-22 Facilities Fund Year-End Available Fund Balance ($ in millions)

FACILITIES FUND (4400) FY 2021-22 Year-End
Estimate

Beginning Fund Balance - Audited 2.83
Revenue 43.62
Expenditures 41.27
Estimated Current Year Surplus/(Shortfall) 2.34
Subtotal Fund Balance 5.18

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance (3.95)
Budgeted Fund Balance Repayment —
Estimated Ending Fund Balance 1.23
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 54
Finance and Management Committee
April 11, 2022

Central Stores Fund (4500)

The Central Stores Fund (4500) is reported on a modified full accrual basis to reflect current assets and liabilities. The Central Stores operation and facility was closed during a restructuring of the inventory model in Public Works. This fund now supports the Citywide mail room function and revenues are generated by charges to internal user departments.

Revenues - FY 2021-22 year-end revenues are projected to come in at $1.29 million, which is equal to the adjusted budget of $1.29 million.

Expenditures - FY 2021-22 expenditures are projected to end the year at $1.34 million, which is $0.05 million higher than the adjusted budget of $1.29 million.

Table 56: FY 2021-22 Central Stores Expenditures ($ in millions)

Department
FY 2021-22
Adjusted
Budget*

FY 2021-22
Q2 YTD Actuals
FY 2021-22
Q2 Year-End
Estimate
Year-End $
(Over) / Under
Adjusted
Budget
Finance 0.43 0.29 0.56 (0.13)
Non Departmental 0.86 — 0.78 0.08
Total Expenditures 1.29 0.29 1.34 (0.05)
*The adjusted budget includes Council Budget Amendments and Carryforwards Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 55
Finance and Management Committee
April 11, 2022

Fund Balance - FY 2021-22 revenue is projected to end the year at $1.29 million. Expenditures are projected to end the year at $1.34 million. The adjusted budget includes a budgeted transfer to fund balance in the amount of $0.78 million. As a result, the fund balance in the Central Stores Fund (4500) is projected to increase from negative $3.58 million in FY 2020-21 to negative $2.85 million in FY 2021-22 .

Table 57: FY 2021-22 Central Stores Fund Year-End Available Fund Balance ($ in millions)

CENTRAL STORES FUND (4500) FY 2021-22 Year-End
Estimate

Beginning Fund Balance – Audited (3.58)
Revenue 1.29
Expenditures 1.34
Estimated Current Year Surplus/(Shortfall) (0.05)
Subtotal Fund Balance (3.63)

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance —
Budgeted Fund Balance Repayment 0.78
Estimated Ending Fund Balance (2.85)
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 56
Finance and Management Committee
April 11, 2022

Purchasing Fund (4550)

The Purchasing Fund (4550) is reported on a modified full accrual basis to reflect current assets and liabilities. The Purchasing Fund supports the Citywide purchasing function for good and services. Revenues are generated by charges to internal user departments.

Revenues: - FY 2021-22 year-end revenues are projected to come in at $1.78 million, which is higher by $0.01 million when compared to the adjusted budget of $1.77 million.

Expenditures - FY 2021-22 expenditures are projected to end the year at $1.88 million, which is $0.11 million higher than the adjusted budget of $1.77 million.

Table 58: FY 2021-22 Purchasing Fund Expenditures ($ in millions)

Department
FY 2021-22
Adjusted
Budget*

FY 2021-22
Q2 YTD Actuals
FY 2021-22
Q2 Year-End
Estimate
Year-End $
(Over) / Under
Adjusted
Budget
Finance $ 1.74 $ 0.92 $ 1.85 $ -0.11
Non-Departmental 0.02 — 0.02 —
Total Expenditures 1.77 0.92 1.88 (0.11)
*The adjusted budget includes Council Budget Amendments and Carryforwards

Fund Balance - FY 2021-22 revenue is projected to end the year at $1.78 million. Expenditures are projected to end the year at $1.88 million. The adjusted budget assumes the use of fund balance to support prior year carryforwards in the amount of $0.02 million. Inversely, there is a budgeted contribution to fund balance in the amount of $0.02 million. As a result, the negative fund balance in the Purchasing Fund (4550) is projected to increase from negative $0.21 million in FY 2020-21 to negative $0.31 million in FY 2021-22.

Table 59: FY 2021-22 Purchasing Fund Year-End Available Fund Balance ($ in millions)

PURCHASING FUND (4550) FY 2021-22 Year-End
Estimate

Beginning Fund Balance – Audited (0.21)
Revenue 1.78
Expenditures 1.88
Estimated Current Year Surplus/(Shortfall) (0.10)
Subtotal Fund Balance (0.31)

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance (0.02)
Budgeted Fund Balance Repayment 0.02
Estimated Ending Fund Balance (0.31)
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 57
Finance and Management Committee
April 11, 2022

Measure KK Funds (5330, 5331, 5332, 5333, 5335)

In 2016, Oakland voters passed, with a two-thirds majority, the Measure KK bond measure which allowed the issuance of $600 million in general obligations bonds to finance City infrastructure projects and affordable housing. Per the ballot, Measure KK funds could be spent on affordable housing development, facilities improvements, and street maintenance.

Revenues - FY 2021-22 revenues are projected to end the year at the adjusted budget of $201.90 million.

Expenditures - FY 2021-22 expenditures are projected to end the year at the adjusted budget of $201.90 million.

Table 60: FY 2021-22 Measure KK Expenditures ($ in millions)

Department
FY 2021-22
Adjusted
Budget*

FY 2021-22
Q2 YTD Actuals
FY 2021-22
Q2 Year-End
Estimate
Year-End $
(Over) / Under
Adjusted
Budget
Police (0.14) 0.19 0.38 (0.52)
Public Works 0.44 1.68 5.74 (5.30)
Transportation 0.68 3.42 2.54 (1.86)
Housing & Community Development 31.82 4.85 31.39 0.43
Capital Improvement Projects 169.10 20.93 161.85 7.25
Total Expenditures 201.90 31.06 201.90 —
*The adjusted budget includes Council Budget Amendments and Carryforwards Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 31, 2022 Page 58
Finance and Management Committee
April 11, 2022

Fund Balance - FY 2021-22 revenue is projected to end the year at $201.90 million.

Expenditures are projected to end the year at $201.90 million. The adjusted budget assumes use of fund balance to support prior year carryforwards in the amount of $109.98 million. As a result, the fund balance in the Measure KK Funds (5330, 5331, 5332, 5333, 5335) is projected to decrease from $112.79 million in FY 2020-21 to $2.81 million in FY 2021-22 .

Table 61: FY 2021-22 Measure KK Funds Year-End Available Fund Balance ($ in millions)

MEASURE KK FUNDS (5331, 5332, 5333, 5335) FY 2021-22 Year-End Estimate

Beginning Fund Balance - Audited 112.79
Revenue 201.90
Expenditures 201.90
Estimated Current Year Surplus/(Shortfall) —
Subtotal Fund Balance 112.79

Use of Fund Balance in FY 2021-22
Budgeted Transfer from Fund Balance (109.98)
Budgeted Fund Balance Repayment —
Estimated Ending Fund Balance 2.81
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 11, 2022 Page 59

6. ALL OTHER FUNDS – FUND BALANCE SUMMARY

Table 62: FY 2021-22 All Other General Funds Year-End Available Fund Balances ($ in millions)

Fund Description

FY21-22 Beg
Audited Fund
Balance

FY21-22 Year
End Rev
Projections

FY21-22 Year
End Exp
Projections
FY21-22 Bud
Contribution
To/ (Use Of)
Fund Balance
FY21-22 Year
End Avail Fund
Balance
(Unaudited)
1011 - General Purpose
Emergency Reserve
— 54.61 54.61 54.61 54.61
1020 - Vital Services
Stabilization F

0.25 2.58 2.58 2.58 2.83
1030 - Measure HH
(SSBDT)

7.82 14.05 14.62 (7.02) 0.23
1100 - Self Insurance
Liability
(19.07) 56.77 55.83 0.79 (17.34)
1150 - Worker's
Compensation Insurance

0.17 0.03 8.66 (0.02) (8.48)
1200 - Pension Override
Tax Revenue
217.65 118.08 118.08 9.30 226.95
1600 - Underground
District Revolving
(0.92) 0.19 0.19 0.19 (0.74)
1610 - Successor
Redevelopment Agency
(0.14) 2.35 2.41 (0.03) (0.23)
1700 - Mandatory Refuse
Program

1.69 2.51 2.49 (0.15) 1.56
1710 - Recycling
Program

3.27 6.34 5.92 (1.06) 2.63
1720 - Comprehensive
Clean-up

4.31 26.18 23.78 (2.75) 3.96
1750 - Multipurpose
Reserve
(0.66) 12.15 11.52 (0.57) (0.60)
1760 -
Telecommunications
Reserve
(0.48) 1.68 1.68 (0.01) (0.49)
1770 -
Telecommunications
Land Use

0.57 0.82 0.84 (0.04) 0.51
1780 - Kid's First
Oakland Children's

8.71 25.29 24.74 (7.45) 1.81
1791 - Contract
Administration Fee
— — — — —
1820 - OPRCA Self
Sustaining Revolving

3.54 3.93 5.53 (0.07) 1.87
1830 - Central District
Project Area

1.92 1.42 1.42 (7.60) (5.68)
1870 - Affordable
Housing Trust Fund

38.49 51.62 49.29 (35.02) 5.80
1880 - Low Mod
Operations

1.10 0.13 0.13 (0.13) 0.97
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 11, 2022 Page 60

Fund Description

FY21-22 Beg
Audited Fund
Balance

FY21-22 Year
End Rev
Projections

FY21-22 Year
End Exp
Projections
FY21-22 Bud
Contribution
To/ (Use Of)
Fund Balance
FY21-22 Year
End Avail Fund
Balance
(Unaudited)
1882 - Multi Service
Center/Rent
(0.02) 0.18 0.18 (0.18) (0.20)
1884 - 2006 Housing Bond
Proceeds

8.61 1.18 1.18 (1.18) 7.43
1885 - 2011A-T
Subordinated Housing

38.13 11.31 10.75 (8.42) 30.26

Table 63: All Other Special Revenue Funds ($ in millions)

Fund Description
FY21-22 Beg
Audited Fund
Balance
FY21-22 Year
End Rev
Projections
FY21-22 Year
End Exp
Projections
FY21-22 Bud
Contribution
To/ (Use Of)
Fund Balance
FY21-22 Year
End Avail Fund
Balance
(Unaudited)
2063 - FEMA Declarations (1.08) 1.38 1.96 0.12 (1.53)
2071 - CARES Act Relief
Fund

0.96 30.24 29.41 (29.90) (28.10)
2072 - American Rescue
Act Plan
— 99.10 98.68 — 0.42
2102 - Department of
Agriculture
(0.07) 1.47 1.30 — 0.10
2103 - HUD-

ESG/SHP/HOPWA
(5.22) 83.78 64.14 — 14.42
2108 - HUD-CDBG (6.69) 16.93 16.55 — (6.31)
2109 - HUD-Home 4.12 26.04 24.08 — 6.09
2112 - Department of
Justice
(0.81) 2.48 0.11 — 1.56
2113 - Department of
Justice - COPS H
(1.52) (0.77) 0.27 0.27 (2.29)
2114 - Department of Labor 0.02 (0.03) (0.03) — 0.02
2116 - Department of
Transportation
(1.99) 20.86 21.31 — (2.45)
2120 - Federal Action
Agency
(0.04) 0.50 0.38 — 0.08
2123 - US Dept of
Homeland Security
(0.04) 7.09 4.76 — 2.30
2124 - Federal Emergency
Management A
(2.84) 7.34 5.95 0.28 (1.16)
2125 - Environmental
Protection Agency

2.46 1.50 1.50 — 2.46
2128 - Department of
Health and Human
(6.87) 30.93 28.10 — (4.04)
2129 - Trade Corridor
Improvement Fun

1.43 1.23 2.20 — 0.46
2134 - California Parks and
Recreation
(0.07) 4.88 4.88 — (0.07)
2138 - California
Department of Education

1.05 2.38 1.33 — 2.10
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 11, 2022 Page 61

Fund Description
FY21-22 Beg
Audited Fund
Balance
FY21-22 Year
End Rev
Projections
FY21-22 Year
End Exp
Projections
FY21-22 Bud
Contribution
To/ (Use Of)
Fund Balance
FY21-22 Year
End Avail Fund
Balance
(Unaudited)
2139 - California
Department of Conse

0.22 26.34 25.27 — 1.29
2140 - California
Department of Trans
(0.46) 11.96 12.37 — (0.88)
2144 - California Housing
and Community
(0.70) 3.32 2.72 — (0.10)
2146 - California State
Emergency Ser

1.68 0.09 0.09 — 1.68
2148 - California Library
Services

0.27 0.16 0.18 — 0.24
2150 - California
Department of Fish

0.14 0.21 0.19 — 0.17
2152 - California Board of
Correction
(3.68) 5.97 5.76 0.45 (3.02)
2154 - California Integrated
Waste Ma
(0.14) 0.06 0.06 — (0.14)
2158 - 5th Year State
COPS Grant, AB

3.09 0.43 0.25 — 3.27
2159 - State of California
Other

26.58 63.64 60.71 — 29.51
2160 - County of Alameda:

Grants

2.17 5.49 5.58 — 2.08
2162 - Metro Transportation
Com: TDA
(0.24) 1.51 1.50 — (0.23)
2163 - Metro Transportation
Com: Prog
(0.29) (0.05) 0.05 — (0.39)
2166 - Bay Area Air Quality
Management
(0.41) 0.59 0.59 — (0.41)
2172 - Alameda County:

Vehicle Abatement

0.07 0.59 0.83 — (0.17)
2175 - Alameda County:

Source Reduction

0.60 0.40 0.40 — 0.60
2190 - Private Grants 0.02 0.52 0.46 — 0.07
2195 - Workforce
Investment Act

0.92 6.55 5.68 — 1.80
2211 - Measure B: Local
Streets & Roads

13.02 20.18 20.75 (10.92) 1.53
2212 - Measure B:

Bicycle/Pedestrian

2.39 2.72 2.23 (1.48) 1.40
2213 - Measure B:

Paratransit - ACTC

1.00 1.96 1.65 (0.90) 0.40
2214 - ACTC Reimbursable
Grants
(1.50) 15.54 15.55 (13.91) (15.41)
2215 - Measure F - Vehicle
Registration

2.35 3.30 2.53 (1.08) 2.05
2216 - Measure BB -
Alameda County

0.01 0.01 — (0.01) 0.01
2217 - Measure BB - OAB
Roadway Infra
(0.09) (1.39) (1.31) 1.39 1.22
2218 - Measure BB - Local
Streets and

8.68 18.81 16.36 (2.55) 8.58
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 11, 2022 Page 62

Fund Description
FY21-22 Beg
Audited Fund
Balance
FY21-22 Year
End Rev
Projections
FY21-22 Year
End Exp
Projections
FY21-22 Bud
Contribution
To/ (Use Of)
Fund Balance
FY21-22 Year
End Avail Fund
Balance
(Unaudited)
2219 - Measure BB - Bike
and Pedestrian

1.97 2.81 2.63 (1.06) 1.09
2220 - Measure BB -
Paratransit

1.89 2.91 2.30 (1.34) 1.16
2230 - State Gas Tax 2.24 15.45 9.98 (2.09) 5.62
2232 - Gas Tax RMRA 2.35 11.15 7.98 (2.13) 3.39
2241 - Measure Q-Library
Services Ret

7.21 18.50 17.54 (0.53) 7.65
2243 - Measure D - Parcel
Tax to Main

6.34 13.91 13.15 (0.47) 6.63
2244 - Measure Q - Parks
& Recreation

11.99 39.68 40.15 (12.72) (1.20)
2250 - Measure N: Fund 0.91 2.23 2.20 (0.35) 0.58
2251 - Measure Y: Public
Safety Act 2
(0.11) — — — (0.11)
2252 - Measure Z -
Violence Prevention

1.73 30.17 29.17 (2.47) 0.26
2260 - Measure WW: East
Bay Regional
(0.57) 0.62 0.62 (0.62) (1.19)
2270 - Vacant Property Tax
Act Fund

0.94 10.95 10.72 (5.35) (4.18)
2310 - Lighting and
Landscape Assessment

0.05 20.06 19.62 (0.61) 0.24
2320 - Fire Suppression
Assessment Di

0.03 0.03 0.03 (0.03) —
2330 - Werner Court
Vegetation Mgmt D

0.05 0.05 0.05 (0.05) —
2331 - Wood Street
Community Facility

0.58 0.17 0.14 (0.10) 0.52
2332 - Gateway Industrial
Park

0.72 1.11 1.00 (0.27) 0.56
2333 - Brooklyn Basin
Public Services
— 0.05 0.05 (0.03) (0.03)
2411 - False Alarm
Reduction Program
(2.94) 3.00 3.02 (0.26) (3.22)
2412 - Measure M -
Alameda County: Em

0.91 2.80 2.68 (0.47) 0.55
2413 - Rent Adjustment
Program Fund

4.75 9.47 11.15 (2.83) 0.25
2415 - Development
Service Fund
146.66 131.02 114.15 (77.10) 86.43
2416 - Traffic Safety Fund 0.06 0.94 0.94 0.03 0.09
2417 - Excess Litter Fee
Fund

1.61 1.19 1.19 (0.74) 0.87
2419 - Measure C:

Transient Occupancy

0.22 4.64 4.64 (0.07) 0.15
2420 - Transportation
Impact Fee

7.16 6.89 6.72 (5.84) 1.49
2421 - Capital
Improvements Impact Fe

3.81 4.47 4.47 (3.55) 0.26
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 11, 2022 Page 63

Fund Description
FY21-22 Beg
Audited Fund
Balance
FY21-22 Year
End Rev
Projections
FY21-22 Year
End Exp
Projections
FY21-22 Bud
Contribution
To/ (Use Of)
Fund Balance
FY21-22 Year
End Avail Fund
Balance
(Unaudited)
2611 - HUD-CDBG (ARRA) 0.82 0.03 0.03 (0.03) 0.79
2826 - Mortgage Revenue 2.10 0.21 0.21 (0.12) 1.98
2830 - Low- and Moderate-
Income Housing

21.15 3.87 3.87 (3.87) 17.28
2990 - Public Works Grants (1.36) 0.53 0.41 0.26 (0.98) 2992 - Parks and
Recreation Grants
(2.03) 0.46 0.46 0.46 (1.56)
2994 - Social Services
Grants

0.33 0.18 0.18 — 0.33
2995 - Police Grants 0.30 0.02 0.02 — 0.30
2996 - Parks and
Recreation Grants 20
(0.06) 0.11 0.11 — (0.06)
2999 - Miscellaneous
Grants

12.39 10.97 11.39 (0.26) 11.70

Table 64: All Other Enterprise Funds ($ in millions)

Fund Description
FY21-22 Beg
Audited Fund
Balance
FY21-22 Year
End Rev
Projections
FY21-22 Year
End Exp
Projections
FY21-22 Bud
Contribution
To/ (Use Of)
Fund Balance
FY21-22 Year
End Avail Fund
Balance
(Unaudited)
3100 - Sewer Service Fund 85.06 139.08 141.40 (70.10) 12.64 3200 - Golf Course (0.40) 0.96 0.49 (0.09) (0.02)

Table 65: All Other Internal Service Funds ($ in millions)

Fund Description

FY21-22 Beg
Audited Fund
Balance

FY21-22 Year
End Rev
Projections

FY21-22 Year
End Exp
Projections
FY21-22 Bud
Contribution
To/ (Use Of)
Fund Balance
FY21-22 Year
End Avail Fund
Balance
(Unaudited)
4100 - Equipment 28.16 50.20 49.36 (12.37) 16.63
4200 - Radio /
Telecommunications

6.51 10.81 10.54 (3.98) 2.81
4210 - Telephone
Equipment and Software

0.82 0.91 0.91 (0.13) 0.69
4300 - Reproduction (1.31) 1.70 1.70 0.26 (1.05)
4400 - City Facilities 2.83 43.61 41.27 (3.95) 1.23
* FY 2021-22 Beginning Cash Balance is used for Internal Service Funds.

Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 11, 2022 Page 64

Fund Description
FY21-22 Beg
Audited Fund
Balance
FY21-22 Year
End Rev
Projections
FY21-22 Year
End Exp
Projections
FY21-22 Bud
Contribution
To/ (Use Of)
Fund Balance
FY21-22 Year
End Avail Fund
Balance
(Unaudited)
4450 - City Facilities
Energy Conservation

0.55 1.16 1.36 (1.16) (0.81)
4500 - Central Stores (3.58) 1.29 1.34 0.78 (2.85)
4550 - Purchasing (0.21) 1.78 1.88 (0.06) (0.31)
4600 - Information
Technology

9.97 31.21 30.49 (14.19) (3.50)
* FY 2021-22 Beginning Cash Balance is used for Internal Service Funds.

Table 66: All Other Capital Project Funds ($ in millions)

Fund Description

FY21-22 Beg
Audited Fund
Balance

FY21-22 Year
End Rev
Projections

FY21-22 Year
End Exp
Projections
FY21-22 Bud
Contribution
To/ (Use Of)
Fund Balance
FY21-22 Year
End Avail Fund
Balance
(Unaudited)
5012 - JPFA Admin
Building: Series 19
(1.35) 0.31 0.31 0.31 (1.04)
5055 - Piedmont Pines
Underground Ass

0.03 — — — 0.02
5130 - Rockridge: Library
Assessment

1.13 0.01 0.01 (0.01) 1.12
5200 - JPFA Capital
Projects: Series
(0.10) 0.04 0.04 (0.04) (0.14)
5320 - Measure DD: 2003A
Clean Water,
— 0.01 0.01 (0.01) (0.01)
5321 - Measure DD: 2009B
Clean Water,

0.46 0.86 1.73 (0.86) (1.27)
5322 - Measure DD: 2017C
Clean Water,

15.08 14.46 18.22 (14.46) (3.14)
5330 - Measure KK:

Infrastructure and

11.43 9.57 9.57 (9.57) 1.87
5331 - Measure KK:

Affordable Housing

13.33 11.13 11.13 (11.13) 2.20
5332 - Measure KK:

Infrastructure Series
2020B-1 (Tax Exempt)

67.34 68.59 68.59 (68.59) (1.25)
5333 - Measure KK:

Affordable Housing 2020

20.69 20.70 20.70 (20.70) (0.01)
5335 - 5335 - Measure KK:

Infrastructure 2022
— 91.93 91.93 — —
5500 - Municipal Capital
Improvement
(5.14) 1.03 1.03 1.03 (4.11)
5505 - Municipal Capital
Improvement:

2.11 1.39 1.39 (0.91) 1.20
5510 - Capital Reserves (1.10) 0.22 0.22 0.22 (0.88)
5610 - Central District
Projects

24.84 15.71 15.34 (12.21) 13.01
5611 - Central District: TA
Bonds Se

13.22 2.79 2.79 (2.79) 10.43
5612 - Central District: TA
Bonds Se

8.41 5.00 5.04 (5.00) 3.37
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 11, 2022 Page 65

Fund Description

FY21-22 Beg
Audited Fund
Balance

FY21-22 Year
End Rev
Projections

FY21-22 Year
End Exp
Projections
FY21-22 Bud
Contribution
To/ (Use Of)
Fund Balance
FY21-22 Year
End Avail Fund
Balance
(Unaudited)
5613 - Central District: TA
Bonds Se

2.94 4.29 4.25 (4.29) (1.31)
5614 - Central District: TA
Bonds Se

7.57 8.05 7.78 (8.05) (0.21)
5630 -
Broadway/MacArthur/San

0.19 0.18 0.18 (0.18) 0.01
5637 - BMSP: TA Bond
Series 2006C-TE
— — — — —
5638 - BMSP: TA Bond
Series 2006C-T

0.59 0.28 0.26 (0.28) 0.33
5640 - Central City East
Projects

0.17 0.02 0.07 (0.02) 0.10
5643 - Central City East TA
Bonds Ser

19.84 7.02 7.03 (7.02) 12.81
5650 - Coliseum Projects 6.05 4.57 4.69 (4.47) 1.46
5653 - Coliseum: TA Bonds
Series 2003
(0.11) 0.02 0.02 (0.02) (0.12)
5656 - Coliseum: TA Bonds
Series 2006

47.96 8.76 8.71 (8.76) 39.25
5660 - West Oakland
Projects
(1.48) — — — (1.48)
5670 - Oakland Base
Reuse Authority
(0.27) 0.07 0.07 (0.07) (0.34)
5671 - OBRA: Leasing &
Utility

52.12 4.82 4.30 (3.43) 49.20
5672 - Joint Army Base
Infrastructure

1.31 (0.23) (0.23) 0.23 1.55
5674 - Oakland Army Base
Joint Remediation

0.17 — — — 0.17
5999 - Miscellaneous
Capital Projects
(1.59) 3.05 2.64 0.44 (0.74)
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 11, 2022 Page 66

Table 67: All Other Debt Service Funds ($ in millions)

Fund Description

FY21-22 Beg
Audited Fund
Balance

FY21-22 Year
End Rev
Projections

FY21-22 Year
End Exp
Projections
FY21-22 Bud
Contribution
To/ (Use Of)
Fund Balance
FY21-22 Year
End Avail Fund
Balance
(Unaudited)
6013 - 2013 LED Streetlight
Acquisition

0.39 1.53 1.53 — 0.39
6029 - Taxable Pension
Obligation Bon

0.23 18.15 18.15 — 0.23
6032 - Taxable Pension
Obligation: Se

0.31 51.63 51.63 — 0.31
6036 - JPFA Refunding
Revenue Bonds:

6.96 0.18 0.18 (0.18) 6.78
6064 - GO Refunding
Bonds, Series 201

4.88 13.68 13.68 — 4.88
6322 - Measure DD: 2017C
Clean Water,

0.81 1.46 1.46 — 0.81
6330 - Measure KK:
2017A-1 (TE) Infra

1.65 2.25 2.25 — 1.65
6331 - Measure KK:
2017A-2 (Taxable)

1.61 4.14 4.14 — 1.61
6540 - Skyline Sewer
District – Redem.

0.03 0.02 0.02 (0.02) 0.01
6557 - Piedmont Pines P1
2018 Reassess

0.20 0.11 0.11 — 0.20
6587 - 2012 Refunding
Reassessment Bo

1.02 0.42 0.42 — 1.02
6613 - JPFA Lease
Revenue Refunding B
— 8.34 8.34 — —
Edward D. Reiskin, City Administrator
Subject: FY 2021-22 Q2 R&E Report Attachment A
Date: March 11, 2022 Page 67

Table 68: All Other Fiduciary Funds/Trust & Agency Funds ($ in millions)

Fund Description
FY21-22 Beg
Audited Fund
Balance
FY21-22 Year
End Rev
Projections
FY21-22 Year
End Exp
Projections
FY21-22 Bud
Contribution
To/(Use Of)
Fund Balance
FY21-22 Year
End Avail
Fund Balance
(Unaudited)
7100 - Police and Fire
Retirement Sys
458.53 3.56 3.34 (3.56) 455.20
7130 - Employee
Deferred Compensation
— 0.24 0.24 0.19 0.19
7320 - Police and Fire
Retirement Sys

50.97 4.89 4.89 — 50.97
7420 - State Asset Trust 0.49 0.09 0.09 (0.09) 0.40
7440 - Unclaimed Cash 0.63 (0.06) 0.04 0.06 0.59
7540 - Oakland Public
Library Trust

1.01 0.81 0.81 (0.60) 0.40
7640 - Oakland Public
Museum Trust

0.76 0.72 0.72 (0.71) 0.05
7690 - Kerrison Trust for
Police Enha

0.08 — — — 0.08
7760 - Grant Clearing (2.95) 2.53 6.28 (0.26) (6.97)
7780 - Oakland
Redevelopment Agency
P

0.15 0.15 0.15 (0.15) —
7902 - Oakland Senior
Center: North

0.02 0.01 0.01 (0.01) 0.01
7903 - Oakland Senior
Center: West

0.01 0.01 0.01 (0.01) 0.01
7904 - Oakland Senior
Center: East

0.01 0.01 0.01 (0.01) —
7999 - Miscellaneous
Trusts

2.13 1.50 1.51 — 2.12

FILE©
%'fTICE Of TH[ CIT. en.in
OAKLf.HD
2018 APR 13 AH g: 21
Appendix A

APPROVED AS TO FO

City Attorney

OAKLAND CITY COUNCIL
ORDINANCE IIE'l 3 4 8, 7 "c.M.S.

ORDINANCE AMENDING THE CITY OF OAKLAND

CONSOLIDATED FISCAL POLICY

WHEREAS, the City Council adopted Ordinance No. 13279, known as the Consolidated Fiscal Policy, on December 9, 2014; and,

WHEREAS, the Government Finance Officers Association (GFOA) recommends that local governments adopt formal policies in the areas of financial management, planning, revenues, and expenditures; and

WHEREAS, the Consolidated Fiscal Policy sets forth guidelines for budget balancing, use of volatile revenues, use of one-time revenues, process for carryforward appropriations, long-term financial planning, and transparency & public participation; and

WHEREAS, the Consolidated Fiscal Policy establishes reserve funds for emergencies, insurmountable and unanticipated hardship, and for capital improvement; and

WHEREAS, the Consolidated Fiscal Policy establishes a reserve fund to stabilize the provision of vital services, and protect against service reductions, layoffs, furloughs, and similar measures in times of economic hardship; and

WHEREAS, the Consolidated Fiscal Policy provides for accelerated debt repayment and pay - d
own of unfunded long -term obligations; and

WHEREAS, City staff recommends the definition of excess Real Estate Transfer Tax should be modified based on historical experience; and

WHEREAS, the Consolidated Fiscal Policy will include the policies on budgeting practices, reserve funds, and budget process, fiscal planning, transparency, and public participation; now, therefore

THE COUNCIL OF THE CITY OF OAKLAND DOES ORDAIN AS FOLLOWS:

Section 1. The Council does find, determine and declare the foregoing recitals to be true and correct and hereby adopts and incorporates them into this Ordinance.

Section 2. The City of Oakland Consolidated Fiscal Policy is hereby, amended, approved, and adopted in the form attached hereto as Exhibit 1.

Appendix A

Section 3. In conformance with best practice and sound financial management, the City shall continue to separately maintain and submit on an as needed basis to the City Council, statements of the City's Debt Policy and Investment Policy.

IN COUNCIL, OAKLAND, CALIFORNIA, .M...... A......Y.. '--1=-,-=5'-'2'-'-0_18 _

PASSED BY THE FOLLOWING VOTE:

AYES- BROO J.uCAMPBELL WASHINGTON, GALLO, GIBSON MCELHANEY, GUILLEN, KALB, KAPLAN, ,._ 7 fll)WYf.lYtrl#

NOES-
ABSENT-.¢
ABSTENTION-/;:!
l x cw:;e ._e.() a,t,&

Introduction Date
MAYO 12018
City Clerk and Clerk of the Council
of the City of Oakland, California
mans
Exhibit 1
Appendix A
1 .

CITY OF OAKLAND

CONSOLIDATED

FISCAL POLICY

Exhibit 1
Appendix A
2 Section 1. Budgeting Practices
Part A. General Provisions

The City's Fiscal Year shall begin on July pt of each year and end on June 30th of the subsequent year. The City shall adopt a two -year biennial policy budget by June 30th of odd-numbered calendar years. The City shall amend its biennial policy budget (midcycle) by June 30th of even- numbered years. The budget and midcycle amendments shall be adopted by resolution of the City Council as required by the City Charter.

Part B. Policy on Balanced Budgets

The City shall adopt a balanced budget that limits appropriations to the total of estimated revenues and unallocated fund balances projected to be available at the close of the current fiscal year. The City Administrator shall be responsible for ensuring that the budget proposed to the City Council by the Mayor, adheres to the balanced budget policy.

This policy entails the following additional definitions and qualifications:

1. The budget must be balanced at an individual fund level.

2. City policies on reserve requirements for individual funds must be taken into account.

The appropriated expenditures included in the balanced budget equation must include the appropriations necessary to achieve or maintain reserve targets.

3. Appropriated revenues can include transfers from unallocated fund balance where such fund balance is reasonably expected to exist by the end of the fiscal year preceding the year of the adopted budget. Transfers from fund balance are not to be counted as revenue if the fund balance is not reasonably expected to exist by the end of the fiscal year preceding the year of the adopted budget. (Note: The precise definition of 'fund balance' will vary from fund to fund, depending on the fund's characteristics and accounting treatment.)

4. Appropriated expenditures can include transfers to fund balance or to reserves.

From time to time the City Council may present changes in policy and consider additional appropriations that were not anticipated in the most recently adopted budget. Amendments by the City Council shall maintain a balanced budget.

Each fiscal year the City Administrator shall report to the City Council on actual revenues and expenditures in the General Purpose Fund and other funds as deemed necessary.

Part C. Use of Excess Real Estate Transfer Tax (RETT) Revenues

To ensure adequate levels of the General Purpose Fund reserves and to provide necessary funding for municipal capital improvement projects and one-time expenses, the City shall require that excess Real Estate Transfer Tax revenues be defined and used as follows:

Exhibit 1
Appendix A
3 1. The excess Real Estate Transfer Tax (RETT) revenue is hereby defined as any amount of projected RETT revenues that exceed 15% of General Purpose Fund Tax Revenues (inclusive ofRETT).

2. The excess Real Estate Transfer Tax, as described in this section, shall be used in the following manner and appropriated through the budget process:

a. At least 25% shall be allocated to the Vital Services Stabilization Fund, until the value in such fund is projected to equal to 15% of total General Purpose Fund revenues over the coming fiscal year; and

b. At least 25% shall be used to fund debt retirement and unfunded long-term obligations such as negative fund balances, Police and Fire Retirement System (PFRS) unfunded liabilities, CalPERS pension unfunded liabilities, paid leave unfunded liabilities, and Other Post-Employment Benefits (OPEB) unfunded liabilities; and

c. The remainder shall be used to fund one-time expenses or to augment reserves.

3. Use of the excess RETT revenues for purposes other than those established in this section must be authorized by City Council resolution. The resolution shall explain the need for using excess RETT revenues for purposes other than those established in this section. The resolution shall also include steps the City will take to return to using excess RETT revenues pursuant to this section.

4. Following the completion of the annual audit, excess RETT revenues will be analyzed to determine whether the transfers to the Vital Services Stabilization Fund or expenditures to fund debt retirement and unfunded long-term obligations were sufficient. If insufficient funds were transferred, a true-up payment shall be made in the next fiscal year. If the transfers exceed the actual requirement, the amounts in excess may be credited against allocations in the next fiscal year.

Part D. Use of One-Time Revenues

1. One-time revenues are defined as resources that the City cannot reasonably expect to receive on an ongoing basis, such as proceeds from asset sales and debt refinancing. This part shall not apply to the use of excess RETT revenues pursuant to Section 1. Part C.

2. Fiscal prudence requires that any unrestricted one-time revenues be used for one-time expenses. Therefore, one-time revenues shall be used in the following manner, unless they are legally restricted to other purposes: to fund one-time expenditures, to fund debt retirement and unfunded long-term obligations such as negative fund balances, Police and Fire Retirement System (PFRS) unfunded liabilities, CalPERS pension unfunded liabilities, paid leave unfunded liabilities, and Other Post-Employment Benefits (OPEB) unfunded liabilities; or shall remain as fund balance.

Exhibit 1
Appendix A
4 3. Use of one-time revenues for purposes other than those established in in this section must be authorized by City Council resolution. The resolution shall explain the need for using one-time revenues for purposes other than those established in this section. The resolution shall also include steps the City will take to return to using one -time revenues pursuant to this section.

Part E. Use of Unassigned General Purpose Fund Balance

Any unassigned General Purpose Fund balance, as projected in the 3rd Quarter Revenue and Expenditure Report, and not budgeted for other purposes, shall be used in accordance with Section 1, Part D.

Part F. Analysis of Funding for Debt or Unfunded Long-Term Obligations From Certain Revenues

When excess RETT or other one-time revenues are used to fund accelerated debt retirement or unfunded long-term obligations, the City Administrator shall present his or her analysis and recommendations to the Council based on the best long -term financial interest of the City.

Part G. Criteria for Project Carryforwards and Encumbrances

Previously approved but unspent project appropriations ("carryforwards") and contingent liability reserves for current purchases or contracts that are paid in the following fiscal year ("encumbrances") are financial obligations against reserves. Fiscal prudence requires that such obligations be limited.

Each fiscal year, the Finance Department will submit a list of eligible carryforwards and encumbrances to all departments for evaluation for all funds, including the General Purpose Fund. Departments may request to retain some or all carryforwards and encumbrances when such balances are:

1. Deemed essential to the delivery of active city projects, programs and services; or

2. If the liquidation of such balances would be in violation of legislative or legal requirements.

A departmental request to retain project carryforwards and/or encumbrances must be submitted to the Finance Department. Departments shall provide specific reasons for requested project carryforwards and encumbrance carryforwards, including, but not limited to, those reasons outlined above. Carryforward of project appropriations in funds with negative balances will only be allowed on an exception basis.

The Finance Department will recommend to the City Administrator an action on the departmental requests. The City Administrator shall make a final determination on project carryforward and encumbrances, and will direct the Finance Department to make carryforwards Exhibit 1
Appendix A
5 available to the appropriate department.

Part H. Grant Retention Clauses

Prior to the appropriation of revenues from any grant outside of the budget process, the City Council shall be informed of any retention clauses that require the City to retain grant-funded staff, services, programs, or operations beyond the term of the grant. The fiscal impacts of such retention clauses shall be disclosed. During the biennial budget process staff shall report to the Council the ongoing projected fiscal impacts of such retention clauses.

Part I. Alterations to the Budget

Substantial or material alterations to the adopted budget including shifting the allocation of funds between departments and substantial or material changes to funded service levels, shall be made by resolution of the City Council.

The Finance Department will include departmental expenditure projections for the General Purpose Fund in the Second Quarter Revenue & Expenditure Report. In the event that a department is projected to overspend in the General Purpose Fund by more than one percent (1%), the City Administrator 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.

Part J. Transfers of Funds between accounts.

The City Administrator shall have the authority to transfer funds between personnel accounts, and between non-personnel accounts within a department. The City Administrator shall have the authority to transfer funds allocated to personnel accounts to non-personnel accounts within a department provided that cumulative transfers within one fiscal year do not exceed 5% of the original personnel account allocation of that department. The City Administrator shall have the authority to transfer funds from non-personnel accounts to personnel accounts within a department. The City Administrator shall have the authority to transfer funds allocated to personnel accounts to non-personnel accounts if the transfer is required to meet the conditions of or maximize the funding derived from a grant that has been approved by the City Council. For the purposes of this section accounts for the provision of temporary personnel services shall be considered personnel accounts.

Part K. Pay-Go Account Expenditures, Priority Project Fund Expenditures, and Grants

The City Council hereby finds and determines that it is in the public interest to spend Pay-go account fund to facilitate and support programs & services of the City of Oakland, capital improvement projects of the City of Oakland, and programs & capital improvement projects of the public schools and other public entities within the City of Oakland. The Council authorizes Pay-Go account funds to be used for the following purposes:

Exhibit 1
Appendix A
6 Capital Improvements:

1. To pay for or augment funding for a City of Oakland capital improvement project including planning and pre -construction services for projects such as, but not limited to, feasibility studies and design, landscaping, architectural and engineering services and all services and materials needed to construct a capital improvements such as, but not limited to, contractor services, lumber, concrete, gravel, plants and other landscape materials, fountains, benches, banners, signs, affixed artwork and any other design and decorative elements of the project; and

2. To provide a grant to a public school, including a school chartered by the State of California or Oakland Unified School District, or other public entity for use on capital improvement project within the City of Oakland, including planning and pre-construction services for projects such as; but not limited to, feasibility studies and design, landscaping, architectural and engineering services and all services and materials needed to construct a capital improvements such as, but not limited to, c ontractor services, lumber, concrete, gravel, plants and other landscape materials, fountains, benches, banners, signs, affixed artwork and any other design and decorative elements of the project; and

Furniture & Equipment:

3. To pay for or augment funding for purchase of furniture and equipment, including computer equipment and software, to be used by participants in a program operated by the City of Oakland; and

4. To provide a grant to a public school, including a school charte red by the State of California or Oakland Unified School District, or another public entity to be used for furniture and equipment, including computer equipment and software, to be used by participants in a program operated by the public school or public e ntity.

Pay-go purposes stated above shall operate as restrictions on Pay-go expenditures or Pay-go grants, regardless of the Pay -go account funding source.

Pay-go purposes stated above shall apply to any and all Pay-go expenditures or grants made by the Mayor and each City Councilmember. All Pay-go expenditures and grants shall be administered by the City Administrator on behalf of the city, and grant agreements shall be required for all such grants.

In accord with the City Council's motion approving the initial allocation of Councilmember Priority Project funds on.June 8, 2006, the City Councilmembers must obtain City Council approval for all Priority Project expenditures.

All Priority Project fund grants approved by the City Council and shall be administered and executed by the City Administrator on behalf of the city, and grant agreements shall be required for all such grants.

Exhibit 1
Appendix A
7 Section 2. Reserve Funds
Part A. General Purpose Fund Emergency Reserve Policy

1. Council hereby declares that it shall be the policy of the shall City of Oakland maintain in each fiscal year a reserve equal to seven and one- half (7.5%) of the General Purpose Fund (Fund 1010) appropriations as adopted in the biennial or midcycle budget, and not including prior year carryforwards, encumbrances, or appropriations to Fund Balance for, such fiscal year (the "General Purpose Fund Emergency Reserve Policy"),

2. Each year, upon completion of the City's financial audited statements , the City Administrator shall report the status of the General Purpose Funds Emergency Reserve to the City Council and on the adequacy of the of the 7.5% reserve level. If in any fiscal year the General Purpose Fund Reserve Policy is not met, the City Administrator shall present to Council a strategy to meet the General Purpose Funds Emergency Reserve Policy. Each year, the City Administrator shall determine whether the 7.5% reserve level requires adjustment and recommend any changes to the City Co uncil.

3. The amounts identified as the General Purpose Funds Emergency Reserve may be appropriated by Council only to fund unusual, unanticipated and seemingly insurmountable events of hardship of the City, and only upon declaration of fiscal emergency. For the purposes of this Ordinance, "fiscal emergency" may be declared (1) by the Mayor and approved by the majority of the City Council, or (2) by a majority vote of the City Council.

4. Prior to appropriating monies from the General Purpose Funds Emergency Reserve, the City Administrator shall prepare and present such analysis to the City Council. Upon review and approval of the proposed expenditure by the City Council, and appropriate fiscal emergency declaration necessary for the use of GPF reserve, the City Administrator will have the authority to allocate from the reserves.

Part B. Vital Services Stabilization Fund Reserve Policy

1. Council hereby declares that it shall be the policy of the City of Oakland to maintain a Vital Services Stabilization Fund (VSSF) with a target funding level of 15% of General Purpose Fund Revenues. The funding of the Vital Services Stabilization Fund shall be made pursuant to Section 1, Part C concerning excess Real Estate Transfer Tax.

2. In years when the City forecasts that total General Purpose Fund revenues will be less than the current year's revenues, or anytime significant service reductions, such as layoffs or furloughs, are contemplated due to adverse financial conditions, use of this fund must be considered to maintain existing services.

3. Use of the VSSF must be authorized by City Council resolution. The resolution shall explain the need for using the VSSF. The resolution shall also include steps the City will take in order to replenish the VSSF in future years.

Exhibit 1
Appendix A
8 Part C. Capital Improvements Reserve Fund

1. Council hereby declares that it shall be the policy of the City of Oakland to maintain a Capital Improvements Reserve Fund.

2. Revenue received from one time activities, including the sale of Real Property, shall be deposited into the Capital Improvements Reserve Fund, unless otherwise directed by a majority vote of the City Council. Interest earnings on monies on deposit in the Capital Improvements Reserve Fund shall accrue to said fund and be maintained therein.

3. Monies on deposit in the Capital Improvements Reserve Fund may be appropriated by Council to fund unexpected emergencies, major capital maintenance, repair costs to City- owned facilities and to fund capital improvement projects through the Five-Year Capital Improvement Program.

Exhibit 1
Appendix A
9 Section 3. Budget Process Fiscal Planning,
Transparency, and Public Participation

Unless otherwise noted all timelines apply only to budget development years, normally odd numbered years and not to mid -cycle revisions to an adopted two-year budget.

1. Assessment of Stakeholder Needs, Concerns and Priorities

Timeline: Budget Advisory Committee review prior to survey release. Survey completion by December 5th of even-numbered years. Results publicly available within three weeks of survey's close.

Requirements: The City Administrator should develop or secure a statistically valid survey for assessing the public's concerns, needs and priorities prior to the development of the biennial budget. Whenever feasible, the City should conduct a professional poll administered to a statistically relevant and valid sample of residents that is representative of Oakland's population in terms of race, income, neighborhood, age, profession, family size, homeownership/renter -ship, etc. If that's not possible, then demographic information should be collected and reported out with the survey results.

Prior to release, the survey questions shall be submitted to the Budget Advisory Committee by September 1st of even numbered years for review of bias, relevance, consistency in administration, inclusion of benchmark questions, and ability to assess concerns, needs and priorities. The survey instrument, method of dissemination, and any instructions for administration shall be publicly available. The survey should be conducted following the November election and before December 5 th.

If the City cannot afford a professional survey, an informal survey shall be made available for broad dissemination by the Mayor and Councilmembers through community list serves and other communication channels. Furthermore, the City Administrator shall take steps to promote participation, such as issuing a Flyer promoting participation in the survey and methods of participation (survey internet link, email, phone number) and posting such Fliers near publicly available computers in all City libraries, Recreation Centers, and Senior Centers. A list of those dissemination channels should be publicly available along with survey results.

Survey results should be publicly available within three weeks of the completion and analysis of the survey. Survey results should be made widely available, shared o n social media, and published on the City's Budget website. In the event that City's statistically valid survey has been completed, the Mayor and City Administrator shall include in their proposed budget a summary of the survey data and a statement regarding how the data was or was not incorporated into the final proposed budget. Informal surveys and their results shall be made public but not included in their proposed budget document.

The City Administrator shall development a standardized and diverse means of collecting resident input via other means prior to budget development.

2. Council Initial Budget Briefing and Priorities Discussion Exhibit 1
Appendix A
10 Timeline: February

Requirements: The Mayor and City Council will hold a bi -annual budget workshop soon after the commencement of the Council term. The workshop will include briefings on estimated baseline expenditures, revenue projections and an overview of the City's budgeting process. The workshop will provide the Mayor and Council with the opportunity to begin discussing priorities for the next budget year based on the Assessment of Stakeholder Needs, Concerns and Priorities.

3. Five-Year Forecast

Timeline: Produced and heard by the Council's Finance & Management Committee or the full City Council in February or March. Forecast Fact Sheets should be distributed to City community centers and Forecast data should be available on Open Data Portal within two weeks of the Council heari ng.

Requirements: Each Budget Cycle, the City Administrator must prepare a Five-Year Forecast.

The Five-Year Financial Forecast ("Forecast") is a planning tool that estimates the City's likely revenues and expenditures over five-years, based on appropriate financial, economic, and demographic data. The purpose of the Forecast is to surface all major financial issues and estimate future financial conditions to support informed long -term decision making. Such planning provides for greater financial stability, signals a prudent approach to financial management, and is consistent with best practices.

The Forecast shall contain the two -year baseline budget for the forthcoming budget period, clearly reflecting projected expenditures to maintain existing service levels and obligations, plus an additional three-year forecast of revenues and expenditures. The Baseline Budget shall consist of projected expenditures n ecessary to maintain existing staffing and service levels, plus an estimate of anticipated revenues for the two -year period.

The Forecast shall also contain information on the variance between prior forecasts and actual amounts, including the factors that influenced these variances. Revenue estimates shall be based on the most current data available; minimally revenue projections shall take into account projected revenue for the current fiscal year, as reflected in the 2nd quarter Revenue and Expenditure Report, with appropriate trending into future years and an explanation as to how such revenue projections were derived.

The report shall include a Five -Year Forecast "Fact Sheet" document, which summarizes the Forecast's key findings with simplified text a nd graphics to make this important budgetary information more accessible to the general public. Within two weeks after the Forecast is heard by the City Council, the City Administrator shall print and distribute the Forecast Fact Sheet to all City libraries, recreation centers and senior centers, including in languages required by Oakland's Equal Access Ordinance. The full Forecast shall also be posted on the City of Oakland's website. Forecast data shall be available in open data format on Oakland's data portal.

Exhibit 1
Appendix A
11 4. Statement of Councilmember Priorities
Timeline: Written submission due by March 15th.

Requirements: City Council Members will have the opportunity to advise the Mayor and City Administrator publicly of their priorities. Each Councilmember shall be invited to submit up to seven expenditure priorities in ranked and/or weighted order for changes to the baseline budget as presented in the Five-Year Forecast. Councilmember prior ity statements must be submitted as part of a report to be heard by the City Council and/or in a publicly available writing to the Mayor and City Administrator by March 15. In addition to the priorities, Councilmembers may also submit other suggestions, including revenue suggestions.

5. Administrator's Budget Outlook Message & Calendar Report Timeline: Heard by City Council before April 15th.

Requirements: The City Administrator shall bring as a report to the City Council a Budget Outlook Message & Calendar no later than April 15th that provides an overview of the budget development process and lists all key dates and estimated dates of key budget events, including, but not limited to the release of the Mayor and Administrator's Proposed Budget, Community Budget Forums, Council meetings, and formal budget passage dates. This publication shall be posted on the City's website and by other means determined by the City Administra tor.

6. Release of Mayor & Administrator's Proposed Budget & Fact Sheet

Timeline: Published and publicly available by May 1st. Heard by City Council and Fact Sheet distributed by May 15th.

Requirements: The Proposed Budget must be released by May 1st and shall clearly indicate any substantive changes from the current baseline budget, including all changes to service levels from the current budget. The Proposed Budget shall indicate staffing by listing the number of positions in each classification for each Department, including a listing of each position proposed for addition or deletion. The Council shall hold a public meeting to present the Proposed Budget no later than May 15th in budget adoption years. The full proposed budget document shall be made available oilline from the City's website, and printed copies shall be available in all City libraries. Additionally, the proposed budget data shall be available in open data format on the City's open data portal by May 1st. Every effort should be made to thoroughly respond to any public request for departmental budget details, such as line item budgets. The requested information shall also be made available on the City's website and open data portal within a reasonable time following the request. ·

The Proposed Budget must include a Budget Fact Sheet with easy-to-understand graphics and text explaining the City's overall finances, the Proposed Budget and that year's Budget Calendar.

The Fact Sheet shall be published in languages required by Oakland's Equal Access Ordinance.

The Fact Sheet shall be printed and made available in all City Recreation Centers and Senior Centers as well as all City libraries by May 15th or the presentation to the Council, whichever is Exhibit 1
Appendix A
12 sooner.

7. Community Budget Forums

Timeline: During the months of May and June of odd-numbered years

Requirements: The Administration and Council shall hold at least one (1) Community Budget Forum in each council district. These forums, organized by the City Administrator's Office in partnership with Councilmembers shall be scheduled to maximize residents' access. The forums should include sufficient time for a question and answer period in a format that maximizes community participation, as well as a presentation of budget f acts by City staff. One or more of the forums must be scheduled in the evening. Another must be scheduled on the weekend. These meetings shall also be scheduled so that Councilmembers have sufficient opportunity to attend a meeting close to their council district. Every member of the City Council shall make their best effort to attend the Community Budget Forum in their council district. Sufficient Fact Sheets in all available languages shall be available at all Forums.

These forums shoul d be publicized in social media and via other means in a manner that is linguistically and culturally appropriate. City Council staff shall work with community-based, faith-based, identity based, and district specific organizations to ensure that a representative and broad group of residents is aware and encouraged to attend each forum.

8. Ongoing Public Education

Timeline: During the months of May and June of even-numbered years

Requirements: Beginning with the first even-numbered year following adoption of this ordinance, the Administration and City Council shall hold at least three (3) Community Budget Education Presentations in different neighborhoods throughout the City and outside of City Hall.

These presentations shall seek to increase Oakland residents understanding and awareness of the City Budget and Budget process.

9. Budget Advisory Commission's Report
Timeline: June 1st
Requirements: The Budget Advisory Committee (BAC) shall be requested to submit published, written report to the full City Council regarding the proposed budget with any suggested amendments no later than June 1 in budget adoption years. If submitted, the statement shall be published as part of the next budget report to the City Council. The BAC is encouraged to provide similar statements during the mid-cycle budget revise and any other significant budget actions.

10. Council President's Proposed Budget
Timeline: June 17th
Exhibit 1
Appendix A
13 Requirements: The City Council President, on behalf of the City Council, shall prepare a proposed budget for Council consideration to be heard at a Special City Council Budget Hearing occurring on or before June 17th. The Council President may delegate the duty to prepare a budget proposal to another member of the Council. The Finance Department will provide a costing analysis for proposed amendments. The City Council may schedule additional Special City Council Budget Hearings or Workshops as needed.

11. Council Budget Amendments

Timeline: No later than up to three (3) days prior to final budget adoption for public noticing

Requirements: In addition to the Council President's proposed budget, any Councilmember or group of Councilmembers may submit proposed budget amendments at any time during the budget process. However, the adopted budget shall not contain substantive amendments made on the floor by Councilmembers at the final meeting when the budget is adopted. All substantive amendments must have been published in the City Council agenda packet for at least three days prior to the budget's final adoption and posted on the City's budget website. This shall not preclude Council members from combining elements from various proposals, provided each element considered has been published in the City Council agenda packet as a component of one proposal. This three-day noticing requirement may be waived by a vote of Council upon a finding that (1) new information impacting the budget by at least $1 million dollars came to the attention of the body after the publication deadline making it not reasonably possible to meet the additional notice requirement and (2) the need to take immediate action on the item is required to avoid a substantial adverse impact that would occur if the action were deferred to a subsequent special or regular meeting, such as employee layoffs.

Councilmembers will present their proposed amendments in an easy to understand, standardized format provided by the City Administrator. The format should allow the proposals to be easily compared to the Mayor's Proposed Budget and to one another. Additions and reductions shall be clearly noted in separate sections.

In order to provide sufficient time to evaluate the cost of proposals, Councilmembers should request costing analyses for proposed budget amendments or line-items within a budget amendment to the City Administrator at least six (6) working days prior to the City Council meeting where that amendment will be considered.

12. Process Feedback & Continual Improvement
Timeline: September 30th following budget adoption
Requirements: The Budget Advisory Commission (BAC) shall be requested to submit an Informational Report to the Council's Finance and Management Committee and City Council containing their analysis of the budget adop tion process including, but riot limited to: 1) the informational quality of the Proposed Budget; 2) the City Administration's and City Council's attention to engaging the public and its impacts on the budget process and product; 3) the level of Exhibit 1
Appendix A
14 transparency and open dialogue in all public meetings dedicated to the budget; and 4) opportunities for improving the process in future years. In assessing opportunities for continually improving public participation in the budget process, the Administration, City Council and BAC shall be requested to consider the following guiding principles:
• Inclusive Design: The design of a public participation process includes input from appropriate local officials as well as from members of intended participant communities. Public participation is an early and integral part of issue and opportunity identification, concept development, design, and implementation of city policies, programs, and projects. • Authentic Intent: A primary purpose of the public participation process is to generate public views and ideas to help shape local government action or policy. • Transparency: Public participation processes are open, honest, and understandable. There is clarity and transparency about public participat ion process sponsorship, purpose, design, and how decision makers will use the process results.
• Inclusiveness and Equity: Public participation processes identify, reach out to, and encourage participation of the community in its full diversity. Processes respect a range of values and interests and the knowledge of those involved. Historically excluded individuals and groups are included authentically in processes, activities, and decision and policymaking. Impacts, including costs and benefits, are identif ied and distributed fairly. • Informed Participation: Participants in the process have information and/or access to expertise consistent with the work that sponsors and conveners ask them to do. Members of the public receive the information they need, and with enough lead time, to participate effectively. • Accessible Participation: Public participation processes are broadly accessible in terms of location, time, and language, and support the engagement of community members with disabilities.
• Appropriate Process: The public participation process uses one or more engagement formats that are responsive to the needs of identified participant groups; and encourage full, authentic, effective and equitable participation consistent with process purposes. Particip ation processes and techniques are well- designed to appropriately fit the scope, character, and impact of a policy or project. Processes adapt to changing needs and issues as they move forward. • Use oflnformation: The ideas, preferences, and/or recommendations contributed by community members are documented and given consideration by decision-makers. Local officials communicate decisions back to process participants and the broader public, with a description of how the public input was considered and used. • Building Relationships and Community Capacity: Public participation processes invest in and develop long -term, collaborative working relationships and learning opportunities with community partners and stakeholders. This may include relationships with other temporary or ongoing community participation venues.
• Evaluation: Sponsors and participants evaluate each public participation process with the collected feedback and learning shared broadly and applied to future public participation efforts.

Appendix A

AN ORDINANCE AMENDING ORDINANCE NO. 13279 C.M.S. (THE

CITY OF OAKLAND CONSOLIDATED FISCAL POLICY, OR
"CFP") TO ESTABLISH AND MODIFY THE FINANCIAL POLICIES
OF THE CITY OF OAKLAND.

NOTICE AND DIGEST

This Ordinance authorizes an amendment to Ordinance Number 13279 C.M.S. (The Consolidated Fiscal Policy, "CFP"), to establish and modify the financial policies and budgeting practices of the City of Oakland. The first public reading of this ordinance is scheduled at a public hearing on 5/1/18 and second on 5/15/18. The location is at City Council Chambers located on the Third Floor of City Hall, One Frank H. Ogawa Plaza, Oakland, California, at 5:30pm. The CFP will be effective upon final adoption of the Ordinance and w ill remain in effect until further notice.

Appendix B

MEMORANDUM
To: Finance Department, City of Oakland
From: Blue Sky Consulting Group
Date: March 24, 2022
Re: Mid-Cycle Revenue Update
This memorandum provides updated forecasts for the City’s major revenue categories relative to our Five-Year Financial Forecast produced in 2021.1 Given ongoing global economic dislocations, including Russia’s invasion of Ukraine and COVID-19 disruptions of office work and supply chains, these revenue projections remain uncertain. In particular, the projections are sensitive to changes in personal income, inflation, and the extent to which workers return to offices. Nevertheless, the projections presented in this memorandum reflect the most up to date economic and financial data available at the time of writing.

Rising personal incomes and sustained inflation have generated higher-than-expected tax revenues despite modest employment growth. Due in part to the COVID-19 pandemic’s Delta and Omicron waves, Oakland’s employment rebound during calendar years 2021 and 2022 to date has been slower than predicted when the City’s Five-Year Forecast was published in 2021. Fiscal policies enacted at the state and federal levels, however, have led to nominal personal income growth that has exceeded expectations, generating higher revenues across a broad range of categories. The American Rescue Plan, a new federal child tax credit, student loan relief, and California’s Golden State Stimulus helped to boost statewide per capita incomes, expected to increase by more than 6% in FY 21-22. Growth in real incomes was more modest, as the state’s CPI increased

4.2% during FY 20-21 and is expected to increase 6.6% in FY 2021-22 2 (See Table 1).

Table 1 – Economic Trends, FY20-21 to FY25-26.

Forecast Metric FY20-21 FY21-22 FY22-23 FY23-24 FY24-25 FY25-26 5-YR Employment (Thous ) 17,333 18,247 18,887 19,343 19,619 19,736 5-YR Per Cap. Income ($) 69,574 72,684 75,079 76,693 80,240 83,958 5-YR CPI 1.95% 2.78% 2.59% 2.45% 2.50% 2.50%
Mid-Cycle Employment (Thous ) 16,996 17,938 18,749 19,222 19,483 19,628 Mid-Cycle Per Cap. Income ($) 72,733 75,405 78,586 81,741 84,128 85,488 Mid-Cycle CPI 4.2% 6.6% 3.9% 2.1% 2.4% 2.4%
Difference (%) Employment (Thous ) -1.9% -1.7% -0.7% -0.6% -0.7% -0.5% Difference (%) Per Cap. Income ($) 4.5% 3.7% 4.7% 6.6% 4.8% 1.8% Difference (PP) CPI 2.3% 3.8% 1.3% -0.3% -0.1% -0.1%
Increasing revenues. This updated forecast shows increased revenue projections across nearly all revenue sources for both the budget year and forecast years. All Funds revenues for the revenue categories estimated are now projected to be $66 million higher in FY21-22 and $84 million higher in FY22-23 than projected in January 2021 (See Table 2). Similarly, for General Fund revenues, the totals for FY21-22 and FY22-23 are up by approximately $49 and $63 million respectively (See Table 3). Some of these increases are due to initial projections developed in January 2021 that were based on conservative FY20-21 revenue baseline

1 Note that estimates for interest income, service charges, internal service funds, grants & subsidies, miscellaneous revenue, interfund transfers, and transfers from fund balance have not been updated from the earlier five-year forecast produced in 2021.
2 While higher-than-forecast inflation has resulted in higher revenues, high inflation will also cause the City’s expenditures to grow more rapidly as well. For example, contracts with police, fire, and other unions are typically indexed to inflation.

Appendix B

assumptions. That is, forecasts for FY 21-22 and subsequent years were based on anticipated economic changes and the resulting fiscal impacts relative to the City’s FY20-21 budgeted amounts. Because actual FY20- 21 revenues were higher than had been expected in January 2021 when the forecast was prepared, revenue projections for the budget and forecast years have also been adjusted higher.

The key factors influencing the forecast include the following:
• Property and Real Estate Transfer Tax: The local residential housing market exceeded growth expectations, with single-family home prices in Oakland up 15% during the 12 months ending February 2022 and transaction volumes remaining high.3 Similarly, in the multi-family market, rents have begun rebounding from their lows during the height of the pandemic in winter 2020. And while offices continue to lose tenants, this trend has not yet resulted in significant losses in commercial real estate values on the assessor’s roll. As a result, FY 20-21 actual property tax revenues exceeded the budget amount by more than $15 million and the current (FY 21-22) amount is expected to exceed the forecasted amount by almost $5 million. Forecasts for subsequent years have also increased by more than $8 million annually.
• Business License Tax: Due in large part to higher-than-anticipated growth in retail sales, residential and commercial rents, and the City’s cannabis industry, BLT revenues in FY20-21 came in over $16 million higher than the City’s budget projection; expected revenue in the current year (FY 21-22) are expected to be more than $17 million higher than projected in the forecast prepared in 2021, with subsequent years also expected to be higher than forecasted in 2021.
• Construction Permits: Residential and office construction remained more active over FY20-21 than had been expected, despite the increase in commercial vacancies and the drop in rents, with actual permit revenue for FY 20-21 more than $8 million higher than budgeted. As a result, the current projection for FY 2021-22 and the subsequent forecast years is up by more than $10 million for the Licenses and Permits category.
• Hotels and Parking: Several revenue sources broadly related to the return of in-person business and tourism activity have recovered more quickly than expected, despite many offices remaining empty and business travel still well below pre-pandemic levels. FY21-22 Parking Tax and parking-related fines are expected to exceed the Five-Year Forecast estimate by nearly $5 million combined, and a more optimistic travel outlook
4 predicts that nominal spending on travel will reach pre-pandemic levels by 2023. • Utility Consumption Tax: While per capita declines in the City’s UCT revenue had been steady over the years prior to the pandemic, UCT revenues reversed this trend in FY20-21, partially due to high inflation and partially due to offices continuing to pay utility bills while workers stayed home and residential bills increased.

3 See Zillow: https://www.zillow.com/oakland -ca/home-values/ 4 See Visit California: https://industry.visitcalifornia.com/research/travel -forecast Appendix B

Table 2 – Estimated Revenues (All Funds), Five-Year Forecast (Feb. 2021) vs. Mid-Cycle (Mar. 2022)

ALL FUNDS Forecast Year 1 2 3 4 5

Forecast

Revenue Category
FY20-21
(Est. Jan 2021)

FY21-22

FY22-23

FY23-24

FY24-25

FY25-26
5-YR 01 - Property Tax 233.15 254.05 271.69 288.58 303.66 318.82 5-YR 02 - Sales Tax 87.47 87.73 98.47 101.23 104.95 108.28 5-YR 03 - Vehicle License Fee 0.00 0.00 0.00 0.00 0.00 0.00 5-YR 04 - Gas Tax 17.64 19.14 19.24 19.31 19.36 19.50
5-YR 05 - Business License Tax 88.00 92.66 94.31 98.59 103.87 109.05 5-YR 06 - Utility Consumpt Tax 52.00 49.14 48.80 48.45 48.12 47.73 5-YR 07 - Real Est Transfer Tax 93.33 94.64 98.29 104.27 111.28 117.79 5-YR 08 - Transient Occ. Tax 10.50 20.66 25.45 30.23 32.24 32.52 5-YR 09 - Parking Tax 8.24 15.27 19.30 21.13 21.84 22.45 5-YR 10 - Local Tax 266.29 266.90 268.13 269.33 270.61 271.94 5-YR 11 - Licenses & Permits 21.60 16.87 17.36 18.01 18.65 19.35 5-YR 12 - Fines & Penalties 15.35 16.15 19.75 21.43 22.12 22.73 5-YR TOTAL 893.57 933.21 980.79 1,020.56 1,056.70 1,090.16

Forecast

Revenue Category
FY20-21
(Actuals)

FY21-22

FY22-23

FY23-24

FY24-25

FY25-26
Mid-Cycle 01 - Property Tax 248.71 258.94 279.82 298.82 315.60 331.98 Mid-Cycle 02 - Sales Tax 88.89 92.13 100.32 104.56 107.14 109.14 Mid-Cycle 03 - Vehicle License Fee 0.32 0.00 0.00 0.00 0.00 0.00 Mid-Cycle 04 - Gas Tax 17.30 18.47 19.19 19.58 19.88 20.22 Mid-Cycle 05 - Business License Tax 104.23 109.71 111.88 117.64 121.15 125.53 Mid-Cycle 06 - Utility Consumpt Tax 51.80 54.51 54.40 54.29 54.19 54.08 Mid-Cycle 07 - Real Est Transfer Tax 113.36 108.31 113.60 119.77 125.82 130.75 Mid-Cycle 08 - Transient Occ. Tax 13.50 19.63 30.53 33.00 34.01 34.32 Mid-Cycle 09 - Parking Tax 11.59 17.23 24.14 25.95 27.00 27.72 Mid-Cycle 10 - Local Tax 275.52 272.58 274.78 275.95 277.03 278.15 Mid-Cycle 11 - Licenses & Permits 29.99 27.13 28.10 29.43 29.84 30.60 Mid-Cycle 12 - Fines & Penalties 20.16 20.80 27.93 29.85 30.98 31.78 Mid-Cycle TOTAL 975.36 999.45 1,064.70 1,108.84 1,142.64 1,174.28

Difference - Five-Year vs Mid-Cycle

FY20-21

FY21-22

FY22-23

FY23-24

FY24-25

FY25-26
Difference 01 - Property Tax 15.57 4.89 8.13 10.24 11.94 13.16 Difference 02 - Sales Tax 1.42 4.40 1.85 3.33 2.19 0.86 Difference 03 - Vehicle License Fee 0.32 0.00 0.00 0.00 0.00 0.00 Difference 04 - Gas Tax (0.34) (0.67) (0.05) 0.27 0.52 0.72 Difference 05 - Business License Tax 16.23 17.05 17.57 19.05 17.28 16.48 Difference 06 - Utility Consumpt Tax (0.20) 5.37 5.60 5.84 6.07 6.35 Difference 07 - Real Est Transfer Tax 20.03 13.67 15.31 15.50 14.54 12.96 Difference 08 - Transient Occ. Tax 3.00 (1.03) 5.08 2.77 1.77 1.80 Difference 09 - Parking Tax 3.35 1.96 4.84 4.82 5.16 5.27 Difference 10 - Local Tax 9.23 5.68 6.65 6.62 6.42 6.21 Difference 11 - Licenses & Permits 8.39 10.26 10.74 11.42 11.19 11.25 Difference 12 - Fines & Penalties 4.80 4.65 8.18 8.42 8.86 9.05 Difference TOTAL 81.80 66.24 83.91 88.28 85.94 84.12
Appendix B

Table 3-- Est Revenues (General Fund), Five-Year Forecast (Feb. 2021) vs. Mid-Cycle (Mar. 2022)

GEN FUND Forecast Year 1 2 3 4 5

Forecast

Revenue Category
FY20-21
(Est. Jan 2021)

FY21-22

FY22-23

FY23-24

FY24-25

FY25-26
5-YR 01 - Property Tax 233.15 242.44 257.98 273.11 287.09 301.30 5-YR 02 - Sales Tax 52.55 58.97 66.19 68.04 70.54 72.78 5-YR 03 - Vehicle License Fee 0.00 0.00 0.00 0.00 0.00 0.00 5-YR 05 - Business License Tax 88.00 92.66 94.31 98.59 103.87 109.05 5-YR 06 - Utility Consumpt Tax 52.00 49.14 48.80 48.45 48.12 47.73 5-YR 07 - Real Est Transfer Tax 93.33 94.64 98.29 104.27 111.28 117.79 5-YR 08 - Transient Occ. Tax 8.24 16.23 19.99 23.75 25.33 25.55 5-YR 09 - Parking Tax 4.50 7.84 9.91 10.85 11.21 11.53
5-YR 11 - Licenses & Permits 1.68 2.45 2.51 2.57 2.63 2.70 5-YR 12 - Fines & Penalties 14.04 14.69 18.11 19.69 20.33 20.90 5-YR TOTAL 547.49 579.06 616.09 649.32 680.40 709.33

Forecast
FY20-21
(Actuals)

FY21-22

FY22-23

FY23-24

FY24-25

FY25-26
Mid-Cycle 01 - Property Tax 238.93 247.15 265.49 282.45 297.89 313.13 Mid-Cycle 02 - Sales Tax 57.82 59.93 65.26 68.02 69.70 71.00 Mid-Cycle 03 - Vehicle License Fee 0.32 0.00 0.00 0.00 0.00 0.00 Mid-Cycle 05 - Business License Tax 104.23 109.71 111.88 117.64 121.15 125.53 Mid-Cycle 06 - Utility Consumpt Tax 51.80 54.51 54.40 54.29 54.19 54.08 Mid-Cycle 07 - Real Est Transfer Tax 113.36 108.31 113.60 119.77 125.82 130.75 Mid-Cycle 08 - Transient Occ. Tax 10.61 15.43 23.99 25.93 26.72 26.96 Mid-Cycle 09 - Parking Tax 6.26 8.84 12.39 13.32 13.86 14.23 Mid-Cycle 11 - Licenses & Permits 1.24 5.90 6.13 6.27 6.40 6.52 Mid-Cycle 12 - Fines & Penalties 17.79 18.44 25.54 27.33 28.39 29.13 Mid-Cycle TOTAL 602.37 628.23 678.69 715.02 744.11 771.34

Difference - Five-Year vs Mid-Cycle

FY20-21

FY21-22

FY22-23

FY23-24

FY24-25

FY25-26
Difference 01 - Property Tax 5.78 4.71 7.51 9.34 10.80 11.83 Difference 02 - Sales Tax 5.27 0.96 (0.93) (0.02) (0.84) (1.78) Difference 03 - Vehicle License Fee 0.32 0.00 0.00 0.00 0.00 0.00 Difference 05 - Business License Tax 16.23 17.05 17.57 19.05 17.28 16.48 Difference 06 - Utility Consumpt Tax (0.20) 5.37 5.60 5.84 6.07 6.35 Difference 07 - Real Est Transfer Tax 20.03 13.67 15.31 15.50 14.54 12.96 Difference 08 - Transient Occ. Tax 2.37 (0.80) 4.00 2.18 1.39 1.41 Difference 09 - Parking Tax 1.77 1.00 2.48 2.47 2.65 2.70 Difference 11 - Licenses & Permits (0.44) 3.45 3.62 3.70 3.77 3.82 Difference 12 - Fines & Penalties 3.76 3.75 7.43 7.64 8.06 8.23 Difference TOTAL 54.89 49.17 62.60 65.70 63.71 62.01