REVISED
City of San Ramon
FINANCE COMMITTEE
AGENDA
Mark Armstrong, Chair Scott Perkins, Vice Chair
City Hall – Large Conference Room
Second Floor * Please Note New Location
7000 Bollinger Canyon Road
Special Meeting
3:30 PM
February 23, 2023
AGENDA QUESTIONS: PLEASE CALL THE ADMINISTRATIVE SERVICES DIRECTOR AT (925) 973-2576 Documents received after publication of this Agenda and considered by the Finance Committee in its deliberation will be available for inspection in the Administrative Services Department located at 7000 Bollinger Canyon Road, San Ramon during normal business hours and in the red binder at the Finance Committee meeting.
1. CALL TO ORDER
2. NEW BUSINESS
2.1 FY 2022-23 Mid-Year Financial Review – Updated 2/23/23 Staff Report by Kelly Sessions, Administrative Service Director
3. ADJOURNMENT
I hereby certify that the attached Finance Committee Meeting Agenda was posted 72 hours before the noted meeting. To make a request for disability-related accommodation to participate in the meeting, please contact the City Clerk’s Office 48 hours in advance of the meeting at 925-973-2539 or [email protected].
Dated: February 17, 2023
Revised: February 23, 2023
2 Finance Committee Meeting – February 23, 2023
ATTENDEE CONDUCT
There will be zero tolerance for any person addressing the Committee making profane, offensive and disruptive remarks, or engaging in loud, boisterous, or other disorderly conduct, that disrupts the orderly conduct of the public meeting. Specifically, it is important for all speakers to adhere to the following guidelines for participation in this meeting:
a. No profanity or obscenity
b. Refrain from personal threats or attacks.
c. Refrain from hateful epithets and demeaning language based on any person’s race, religion, sexual orientation, ethnicity, gender, or disability. d. Respect all people that are present.
At the discretion of the Committee Chair, a speaker may forfeit speaking time for any of the following reasons:
a. Exceeding the allotted time to speak;
b. Yelling, screaming, or other behavior that renders this Committee unable to continue the meeting;
c. Excessive profanity or slander; Specific threats or “fighting words” that incite violence; or
d. Speech that is outside the subject matter jurisdiction of the Committee or the specific agenda item in which you are speaking.
FINANCE COMMITTEE STAFF REPORT
DATE: February 23, 2023
TO: Finance Committee/City Manager
FROM: Kelly Sessions, Administrative Services Director
By: Kelly Sessions, Administrative Services Director
SUBJECT: FY 2022-23 Mid-Year Financial Review
The Staff Report and Attachments have been updated as of 2/23/23
RECOMMENDED ACTION
Review the Mid-Year 2022-23 Financial Report and backup documentation, recommend changes if any, and forward the report to City Council for approval by resolution.
BACKGROUND/DISCUSSION
The City conducts an annual Mid-Year Financial Review to assess the financial condition of the City budget. The review includes a comparison of the budget to a projection of full-year financial outcomes, as well as the identification of requests for mid-year budget adjustments.
The 2022-23 Mid-Year Financial Report was presented to the Finance Committee on February 23, 2023. Any changes to the report or proposed budget adjustments requested by the Finance Committee have already been incorporated and are presented herein.
The Mid-Year Financial Report included the identification of several key items as follows:
Current Fiscal Year beginning reserves were $18.2 million. Year-end reserves are projected at $19.3 million, an increase of $1.1 million.
General Fund revenue collections for the six months ending December 31, 2022 were $24.4 million, which is $2.2 million more than the $22.2 million collected during the same period in the prior year. Additionally, General Fund revenue for FY 2022-23 is projected to end the year at $60.6 million, $2.7 million above budgeted levels.
General Fund expenditures for the six months ending December 31, 2022 were $23.4 million, which is $0.4 million more than the $23.0 million during the same period in the prior year.
Additionally, General Fund year-end expenditures are projected at $52.7 million, $0.1 million below the budgeted amount.
Year-end revenues for the combined General Fund and Dougherty Valley Fund are projected to be $0.7 million above budget, while year-end expenditures are estimated to end the year $0.1 million less than budget.
2.1 Packet Pg. 2
Despite that General Fund fund balance is projected to grow by $2.9 million in FY 2022- 23, these gains will be more than offset when the $5.4 million in pension and retiree medical expenses return to the General Fund in FY 2023-24. At 2022-23 fiscal year end, General Reserves are projected to be $19.3 million before supplemental appropriations. Funding all the General Fund requests would draw an additional $1.2 million and lower the year-end reserves to approximately 33%.
Proposed Mid-Year Adjustments
A number of proposed mid-year adjustments were identified in the report as follows:
General Fund Adjustments Totaling $1,220,884:
City Attorney’s Office - Planning Commission issues have taken significant amounts of staff time to address. Additional funding is needed to engage outside counsel to respond to all Planning Commission requests - $50,000.
City Manager’s Office - Request to conduct a community-wide survey to measure resident satisfaction with services and explore opportunities for areas of growth areas - $40,000. City Manager’s Office - Request to engage a revenue consultant to advise on potential new sources of City revenue - $30,000.
Community Development/Building - Several large construction projects have been submitted or will be submitted before the end of the fiscal year, including Belmont Village at BR1A, the five-story 383 unit apartment development at BR1A, and large tenant improvements for Chevron. Plan check fees have already been collected to cover the additional expense - $800,000.
Public Works/Public Services Division - For purchase of vehicle and equipment fuel (unleaded and diesel), primarily due to increased fuel costs and increased usage. Over the past four fiscal years, an average of 48% of the fuel budget is typically depleted by the end of December. Currently, $123,770 or 69% of the fuel budget has been depleted; however, if approved, the requested adjustment of $80,000 would change this percentage from 69% to 48%, likely providing sufficient funding for fuel through the end of this fiscal year - $80,000.
Public Works/Public Services Division - During labor negotiations, the City agreed to provide SEIU staff with a second pair of work boots each fiscal year. This agreement occurred after the FY 2022-23 budget was completed such that the additional cost was not included in the FY 2022-23 Adopted Budget - $13,000.
Public Works/Public Services Division - Upgrade one Maintenance Technician II position to Maintenance Specialist responsible for advanced-journey level maintenance activities within the Facilities Maintenance Program, including both skilled and semi-skilled work requiring special experience, training/education, licenses and/or certifications (e.g.
HVAC). The additional expense will be absorbed in the current fiscal year Public Services budget, so no additional funding is needed. The ongoing cost of this upgrade beginning in FY 2023-24 is approximately $11,000 annually.
2.1 Packet Pg. 3
Public Works/Public Services Division - Additional funding is requested to cover gas and electricity usage at the San Ramon Olympic Pool, City Hall, Alcosta Senior and Community Center, and Citywide Street Lighting. The requested adjustments are primarily due to increases in overall usage, varying rate increases, and increased usage during “peak” and “part-peak” tier level. With a total need of $233,886, only $207,884 would come from the General Fund with the remainder coming from the Citywide Street Lighting Fund (302).
Other Fund Adjustments Totaling $460,463:
Public Works/Public Services Division - Additional funding is requested to cover gas and electricity usage at the San Ramon Olympic Pool, City Hall, Alcosta Senior and Community Center, and Citywide Street Lighting. The requested adjustments are primarily due to increases in overall usage, varying rate increases, and increased usage during “peak” and “part-peak” tier level. With a total need of $233,886, only $26,002 would come from Citywide Street Lighting Fund (302) with the remainder coming from the General Fund. Fund 302 fund balance at fiscal year-end (FYE) is projected to be $880,392.
Public Works/Public Services Division (Various Funds) - Funds the various year-to-date auto accident damage repairs that have occurred throughout the City. Typical accident repairs include the replacement of street light poles, traffic signals, landscaping, irrigation, and fencing. The responsible party’s insurance company often reimburses the City for repairs. Fiscal impact is as follows:
o Citywide Landscaping (Fund 301) from fund balance - $41,439. Fund balance at FYE is projected to be $369,331.
o Citywide Street Lighting (Fund 302) from fund balance - $6,511. Fund balance at FYE is projected to be $880,392.
o Dougherty Valley Landscaping (Fund 343) from fund balance - $35,447 o Dougherty Valley Street Lighting (Fund 343) - from fund balance $1,404 Public Works/Public Services Division (Fund 304) - To address an emergency mainline repair to prevent water flow on Woodview Terrace Drive within Special Assessment Zone 4 - Vista San Ramon from fund balance - $2,765. Fund balance at FYE is projected to be $19,164.
Public Works/Public Services Division (Fund 314) - To address emergency tree pruning of the oak trees in Special Assessment Zone 14 - Four Oaks. The oak trees require pruning to prevent potential damage to adjacent homes and to improve tree structure. Appropriate from fund balance - $14,600. Fund balance at FYE is projected to be $34,544. Public Works/CIP 925425 - HVAC Duct Cleaning & Equipment Replacement (from Infrastructure Maintenance Fund 618) - Funding needed to cover any unforeseen HVAC repairs or unit replacements from fund balance - $50,000. Fund Balance $576,282 Public Works/CIP 300005 - Summerwood Loop Zone Improvements (from Citywide Landscape Fund 301) - $82,990
o To review and reconcile the Engineer’s Report for Summerwood Loop’s general
2.1 Packet Pg. 4
benefit charge - $2,243. Fund balance at FYE is projected to be $369,331. o To correct previous under-transfers to Summerwood Loop (Zone 5) - $80,747.
Fund balance at FYE is projected to be $369,331.
Public Works/CIP 200007 - Joint Public Safety Complex Landscape Renovation. Additional funding needed from Infrastructure Maintenance Fund 618 as site improvements are separate from building renovation. Cost will be split equally with the Fire District - $100,000. Fund Balance is projected at $576,282.
Public Works/CIP 200007 - Joint Public Safety Complex EV Charging Stations. Additional funding needed from Infrastructure Maintenance Fund 618 as site improvements are separate from building renovation. Cost will be split equally with the Fire District to cover installation of electric vehicle charging stations - $85,000. Fund Balance is projected at $576,282. Public Works/CIP 925515 - Joint Public Safety Complex Security Gate for San Ramon Police Department. Current gate is no longer reliable and needs to be replaced with funding from Infrastructure Maintenance Fund 618 - $14,305. Fund Balance is projected at $576,282.
A resolution has been prepared which authorizes funding for the proposed Mid-Year Budget adjustments, and other fund transfers.
FISCAL ANALYSIS
The proposed action would appropriate $1,220,884 of General Fund reserves to the respective budgets and $460,463 from fund balances of other non-General Fund sources to their respective budgets. There are sufficient reserves in all funding sources to fund the additional appropriations. However, year-end General Fund Reserves are currently projected at 35%, slightly under the City’s 36% General Reserve Policy. Making this appropriation in full would reduce General Fund Reserves to a level of approximately 33%.
STEPS FOLLOWING APPROVAL
1. Incorporate any changes from tonight’s meeting.
2. Amend the 2022-23 Adopted Budget.
ATTACHMENT
A. Mid-Year Finanical Report FY 22-23
B. Mid-Year Financial Summaries FY 22-23
C. Mid-Year Adjustments Summary FY 22-23
2.1 Packet Pg. 5
CITY OF SAN RAMON
MID-YEAR 2022-23
FINANCIAL REVIEW
FEBRUARY 2023
2.1.a
Packet Pg. 6
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review)
Mid-Year Financial Review 2022-23
Key Highlights:
Current Fiscal Year beginning reserves were $18.2 million. Year-end reserves are projected at $19.3 million, an increase of $1.1 million. General Fund revenue collections for the six months ending December 31, 2022 were $24.4 million, which was $2.2 million more than the $22.2 million collected during the same period in the prior year. General Fund revenue for FY 2022-23 is projected to end the year at $60.6 million, $2.7 million above budgeted levels.
Year-end revenues for the combined General Fund and Dougherty Valley Fund are estimated at $78.9 million against a budget of $78.2 million, or $0.7 million above budget.
General Fund expenditures for the six months ending December 31, 2022 were $23.4 million, which was $0.4 million more than the $23.0 million during the same period in the prior year.
General Fund year-end expenditures are projected at $52.7 million, $0.1 million below the budgeted amount.
Year-end expenditures for the combined General Fund and Dougherty Valley Fund are estimated at $74.9 million against a budget of $75.0 million, or $0.1 million less than budget.
General Fund transfers in is projected at $4.8 million and transfers out at $9.6 million, for a net transfer of -$4.8 million.
The projected net gain of $2.9 million in General Fund fund balance will be more than offset when the $5.4 million in pension and retiree medical expense returns to the General Fund.
There are appropriation actions that are recommended for consideration related to the upcoming budget year.
City of San Ramon
2.1.a
Packet Pg. 7
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) Overview
This mid-year report provides information pertaining to the financial performance of the City to date, along with estimates for the full 2022-23 fiscal year. Actual financial results through December 31, 2022 have been analyzed and updated revenue and expenditure projections for the current fiscal year are included in this report.
The 2022-23 Fiscal Year Budget was prepared based on the City’s best assumptions, projections, and estimates of financial impacts as the City continues to recover from the global pandemic, which affected, in one way or another, every government service and related budget provided by the City.
The City of San Ramon has mostly recovered from revenue losses resulting from the COVID-19 pandemic. At mid-year, last year’s $55.0 million General Fund revenue budget had received $22.2 million and ended the fiscal year with $55.9 million in actual receipts. This fiscal year’s $57.9 million General Fund revenue budget had received $24.4 million through the first half of the year with year-end receipts projected at $60.6 million. Property taxes are tracking well, while sales taxes are a pleasant surprise, projected to end the year $2.0 million over budget.
Licenses and permits are also projected to end the year over budget but by $0.9 million. These increases are helping offset other areas that are still lagging.
Charges for service, for instance, is projected to end the year $0.2 million under budget while Transient Occupancy Taxes (TOT), projected at $2.3 million, are still well below FY 2018-19 actuals of $3.3 million.
With year-end General Fund revenues projected above budget by $2.7 million and General Fund expenditures projected under budget by $0.1 million, normally this would be a cause for celebration. This report, however, is a cautionary tale, and a reminder that the FY 2022-23 General Fund budget was balanced by moving $3.2 million in ongoing pension expense and $2.2 million in retiree healthcare expense to their respective one-time rainy day reserve funds. Therefore, the projected net gain of $2.9 million in FY 2022-23 General Fund fund balance will be more than offset when this $5.4 million in ongoing and unavoidable expense returns to the General Fund. Moreover, the City’s General Fund Reserve Policy of 36% is getting more and more difficult to attain; the City is projected to end this fiscal year at 35% with no new Mid-Year General Fund budget adjustments.
After last year’s State budget high with a projected surplus of nearly $46 billion, the State budget is back on familiar territory: a $23 billion shortfall on a $297 billion budget. Funding consists of approximately $224 billion from the General Fund and $70 billion from special funds and $3 billion from bond funds. The Governor proposes no deep cuts to ongoing programs nor a redirecting of local revenues to the State to plug the gap, which is good news for cities. The budget also upholds commitments made in last year’s 2022 Budget Act to invest an additional $1 billion
2.1.a
Packet Pg. 8
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) to fund a fifth round of Homeless Housing, Assistance and Prevention grants, but does not go so far as to provide any new, ongoing funding for cities to address issues with housing supply and homelessness. Originally proposed in January, the Governor’s budget will be updated in May when the May Revise comes out.
2.1.a
Packet Pg. 9
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) Economic Outlook
The City continues its recovery from the severe revenue losses at the height of the COVID-19 global pandemic. National and State levels have seen recovery as well.
Below are some indicators of improvement:
The Bureau of Economic Analysis reported the US economy—as measured by changes in Gross Domestic Product (GDP)—increased 3.2% in the third quarter of 2022 and 2.9% in the fourth quarter. The 2022 annual rate of real GDP growth was 2.1% from 2021 levels. During this period, prices in the US rose sharply due to inflationary pressures, resulting in significant increases in Federal Reserve rate hikes. The rate hikes have slowed the economy, but economic forecasts are mixed regarding whether a recession will follow. The Bureau of Labor Statistics (BLS) reported employment—as measured by nonfarm payroll—was up by 467,000 jobs in January 2022 from the previous month, but down by 2.9 million jobs since February 2020. In the short-term employment growth continued in leisure and hospitality, but since February 2020, employment is down 10.3%. Employment in professional and business services saw increases of over 0.5 million jobs, primarily in the tech industry, temporary help jobs, and management and technical consulting. The BLS estimates the national unemployment rate has been hovering between 3.5% to 3.7% since March 2022. California as a whole fares slightly worse at 4.1%. Contra Costa County, however, maintains an unemployment rate of only 2.9%, compared to 4.1% in 2021. San Ramon boasts an even lower rate of 2.4%, down from 2.6% in December 2021.
U.S. housing starts decreased 22% in 2022 over 2021 as mortgage rates increased significantly due to increases in the Federal Reserve’s borrowing rate. The Case Shiller Home Price Index reports that annual growth in home prices slowed to 6.8% over the past year. In California, although housing prices are trending down, because inventories remain tight, economists predict that homes prices will not see precipitous declines.
Growth in the local economy continues to affect revenue that is closely tied to economic trends and development projects within the City. The most significantly impacted revenue sources have been development fees, transient occupancy tax, and recreation program revenue, which fall under the charges for services and miscellaneous revenue categories. Sales tax growth, due to rampant national inflation and large increases in the cost of gasoline and diesel fuel, have helped offset the losses. Staff will continue to monitor all revenue sources and adjust future revenue estimates accordingly.
2.1.a
Packet Pg. 10
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) Financial Results – General Fund
General Fund Revenue by Source (000’s)
December
2022-2023
To Date
December
2021-2022
To Date Difference
Annual
2022-2023
Estimate
Annual
2022-2023
Budget
Annual
2021-2022
Actuals
Property Tax $ 10,798 $ 10,164 $ 633 $ 24,377 $ 24,377 $ 23,480 Sales and Use Tax 4,475 3,847 628 13,291 11,298 12,124
Property Transfer Tax 420 578 (159) 1,055 1,055 1,213
Transient Occupancy Taxes (TOT) 847 701 147 2,317 2,317 1,745 Franchise Fees 1,278 1,680 (402) 5,737 5,737 5,443
Licenses and Permits 1,290 1,200 90 3,598 2,748 2,705
Intergovernmental 292 159 133 614 498 553
Charges for Services 3,182 2,656 526 6,022 6,251 5,807
Fines and Forfeitures 65 55 10 289 289 133
Investment Income 106 63 43 105 105 (355)
Miscellaneous Revenue 1,639 1,046 593 3,152 3,176 3,073 Total $ 24,390 $ 22,148 $ 2,242 $ 60,556 $ 57,852 $ 55,921 Revenue Results:
Based on six months’ worth of financial data, General Fund revenue exceeds last year’s amount by $2.2 million or 10.1%.
Revenue Estimates:
After analysis of year-to-date revenue and consideration of the projected economic environment, 2022-23 General Fund revenue estimates for the year have been increased to $60.6 million, or $2.7 million (4.7%) above the adopted budget amount.
This increase is due primarily to an increase in sales tax revenues and also reflects advances in licenses and permits and intergovernmental revenues offset by decreases in charges for services and miscellaneous revenue.
Property Tax – (at budget) – Revenue during the first half of the year is $10.8 million or $0.6 million (6.2%) above last year during the same period. The full-year estimate is $24.4 million, which is $0.9 million more than actuals from the previous fiscal year.
San Ramon’s assessed property values increased 6.0% during FY 2022-23, the second lowest increase in the County, which experienced increases in assessed value of 7.8%.
2.1.a
Packet Pg. 11
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) Property Tax Revenue Estimates (in 000’s)
Sales Tax – ($2.0 million above budget) – Revenue during the first half of the year is $4.5 million or $0.6 million (16.3%) above last year during the same period. The fullyear estimate of $13.3 million is $1.2 million (9.6%) higher than actuals from the previous fiscal year. This increase represents the City’s first full return of sales tax revenues to pre-pandemic levels adjusted for inflation.
Receipts and reporting of sales tax revenue lags by several months. As a result, the most recent actual sales tax results reported to the City by the CDTFA was for the period ending September 30, 2022. In this report, the City uses the sales tax projection produced by the City’s sales tax consultant who has much more sophisticated tools at hand. In mid-March, the City will receive actual results for the quarter ending December 31, 2022. When this information is available, staff will again review the full-year sales tax estimate to ensure the projection tracks with actuals.
2.1.a
Packet Pg. 12
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) Sales Tax Revenue Estimate (in 000's)
Property Transfer Tax – (at budget) – Revenue during the first half of the year is $.04 million or $0.2 million (-27.4%) below last year during the same period. The fullyear estimate of $1.1 million is $0.8 million (-6.8%) less than last year’s actual collections. Higher mortgage interest rates and fewer homes on the market are hampering home sales, leading to an overall decline in real estate transactions.
Transient Occupancy Taxes – (at budget) – Revenue during the first half of the year is $0.8 million (20.9%) above last year during the same period. The full-year revenue is projected at $2.3 million or $0.7 million (46%) above last year’s actual collections. The hotel industry in San Ramon is experiencing gradual but steady progress as it continues to recover from the devastating impacts of the COVID-19 pandemic.
Franchise Fees – (at budget) – During the first half of the year, the City received revenues $1.3 million (-23.9%) below last year’s levels during the same period due in part to City-approved changes to the solid waste franchise agreement. The full-year estimate is $5.7 million, which is $0.6 million (5.3%) above last year’s actual collections; thus, the revenue reductions experienced earlier in the fiscal year are expected to be made whole by year end. Growth of this revenue source is impacted by annexations, in-fill redevelopment, and rates.
Licenses and Permits – ($0.9 million above budget) – Revenue during the first half of the year is $1.3 million (7.5%) above last year’s receipts during the same period.
The full-year estimate is $3.6 million, which is $0.9 million (33.0%) above last year’s actual total. This revenue source is subject to the timing of development projects. The departments performing the services estimated the revenue in this category.
Intergovernmental – ($0.1 million above budget) – Revenue during the first half of the year is $0.1 million above last year during the same period. The full-year estimate
2.1.a
Packet Pg. 13
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) is $0.6 million, which is $0.1 million above last year’s actual total. This revenue source comes from grants provided through Federal, State, and local government agencies.
Charges for Services – ($0.2 million below budget) – Revenue during the first half of the year is $0.5 million above last year’s receipts during the same period. The fullyear estimate is $6.0 million, which is $0.2 million above last year’s actual total. This revenue source is subject to the timing of development projects and recreation offerings. Recreation programming and associated revenues are steadily increasing back to pre-pandemic levels. Some areas such as Sports, Aquatics, and Facility Rentals are fully back, while other areas are still lagging (e.g. Seniors, Theater, and Teens). With estimated FY 2022-23 revenues of $4.7 million, Recreation still has a ways to go to get back to their pre-pandemic revenue of $5.9 million in FY 2018-19.
The departments performing the services estimated the revenue in this category.
Fines and Forfeitures – (at budget) – Revenue during the first half of the year is slightly above last year during the same period. The full-year estimate is $0.3 million, which is $0.2 million above last year’s actual total.
Investment Income – (at budget) – Revenue during the first half of the year is $0.04 million above last year during the same period. The full-year estimate for this revenue source is $0.1 million. This revenue source is subject to market value fluctuations.
Miscellaneous Revenue – (slightly below budget) – Revenue during the first half of the year is $0.6 million above last year during the same period. The full year estimate is $3.2 million, which is roughly equivalent to actuals from last fiscal year. The departments receiving fees for facility rentals and cell site leases estimated the revenue in this category.
General Fund Expenditures
Expenditure Results:
Year-to-date General Fund expenditures are $0.4 million (1.8%) higher than the previous year during the same period. The increase in expenditures reflects higher costs for salaries, general benefits, and service contracts offset by savings due to vacant positions, and reductions to the General Fund in ongoing pension and retiree medical costs, which were expensed to their respective “rainy day” reserve funds as approved in the FY 2022-23 Adopted Budget.
Expenditure Estimate:
General Fund full-year expenditures are projected to be $52.7 million, which is $0.1 million below the budget.
2.1.a
Packet Pg. 14
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) General Fund Expenditures by Department (in 000’s)
December
2022-2023
To Date
December
2021-2022
To Date Difference
Annual
2022-2023
Estimate
Annual
2022-2023
Budget*
Annual
2021-2022
Actuals
General Government $ 1,400 $ 1,364 $ 37 $ 3,097 $ 3,255 $ 3,136 Administrative Services 2,752 2,524 228 5,582 5,582 5,080 Community Development 2,054 1,885 169 4,528 4,579 4,200 Police Services 6,506 6,800 (294) 14,923 14,923 16,459
Public Works 6,925 6,969 (44) 16,169 16,001 16,002
Parks & Community Services 3,727 3,412 315 8,286 8,461 7,774 Non-Departmental 5 0 5 50 50 -
Total Expenditures $ 23,369 $ 22,953 $ - $ 415 $ 52,636 $ 52,850 $ 52,651 * Includes carry-over encumbrances
General Fund expenditures for the year are projected to total $52.7 million, $0.1 million above the prior year’s total. The current year estimate includes actual expenditures over the first six months, which were higher than the same period last year by $0.4 million (1.8%). The expenditure estimate is projected to be $0.1 million under budget and reflects higher costs for salaries, general benefits, and service contracts offset by vacancy savings and reductions to the General Fund in ongoing pension and retiree medical costs, which were expensed to their respective “rainy day” reserve funds. Each department has estimated expenditures through the balance of the year.
General Government – ($0.2 million under budget) – The full-year expenditure estimate is $3.1 million. This category includes the City Council, City Manager, City Clerk and City Attorney budgets. Spending over the first half of the year was 43% of the budget and 45% of the projection. General Government expects significant savings due to the City Manager vacancy, which will be partially offset by the executive recruitment costs and reclassification of the Deputy City Manager to Assistant City Manager.
Administrative Services – (at budget) – The full-year expenditure estimate is $5.7 million. This category includes Finance, Information Technology, and Human Resources budgets. Spending over the first half of the year was 49% of budget and the projection. The Human Resources Division experienced unbudgeted expenditures for legal expenses related to outside counsel costs for personnel and labor relations matters.
Community Development – ($0.1 million under budget) – The full-year expenditure estimate is $4.5 million and encompasses division budgets for Planning and Building.
Spending over the first half of the year was 45% of budget and 45% of the current projection.
2.1.a
Packet Pg. 15
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) General Fund Expenditures Citywide (in 000’s)
Police Services – (at budget) – The full-year expenditure estimate is $15.0 million (General Fund only). Spending over the first half of the year was 44% of budget and 43% of the current projection. It should be noted that the remainder of the Police Department expenditures are part of the Dougherty Valley Fund.
Public Works – ($0.2 million over budget) – The full-year expenditure estimate is $16.2 million (General Fund only), and includes the Engineering, Transportation and Public Services divisional budgets. Spending over the first half of the year was 43% of the budget and the current projection. It should be noted that the remainder of the Public Works Department expenditures are part of the Dougherty Valley and other Special Revenue funds.
Parks and Community Services – ($0.2 million under budget) – The full-year expenditure estimate is $8.3 million. Spending over the first half of the year was 44% of budget and 45% of the current projection.
Non-Departmental – (at budget) – The full-year expenditure estimate is $0.05 million. The non-department area is used to cover expenditures for the City Manager’s contingency reserve.
2.1.a
Packet Pg. 16
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) Policy Reserves
Estimate (in 000’s)
Actual Policy Reserves - June 30, 2022
2022-23
Estimate
2022-23
Budget**
General Fund Unreserved $ 19,687 19,687$
Dougherty Valley Fund (1,442) (1,442)
Total $ 18,245 18,245$
General Fund & Dougherty Fund Financial Summary:
Revenues 78,922 78,187
Expenditures (74,815) (74,993)
Net Transfers out (3,033) (3,256)
Net Increase/(Decrease) in Fund Balance 1,074 (62)
General Fund Unreserved $ 19,319 18,182$
Estimated Policy Reserves - June 30, 2023 $ 19,319 18,182$
**Budget as adjusted during the year plus carry-over encumbrances Policy reserves are projected to finish the year at $19.3 million. This represents 35% of the prior fiscal year’s audited actual General Fund expenditures and the transfer to the Dougherty Valley Fund.
2.1.a
Packet Pg. 17
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) Other City Funds:
The Other City Funds include:
• Special Revenue funds that primarily fund CIP projects, GHAD, and Stormwater Management
• Assessment District funds that fund lighting and landscaping, and special zones maintenance
• Dougherty Valley Fund which pays for services covered by the CSA assessment • San Ramon Housing Fund, which is used to fund housing projects and programs • Debt Service funds which account for the accumulation of resources for payment of principal and interest on general long-term debt obligations • Internal Service funds which accumulate funds for equipment replacement, insurance costs, healthcare and building maintenance
The timing of revenue received by these funds varies depending on the funding source. Other City funds that are currently projected to have financial results that are significantly different from the budget are discussed below.
Development Mitigation Revenue: ($0.1 million below budget) – The full year estimate is $1.1 million, which is $0.6 million more than last year’s actual totals. This revenue source varies annually based on the timing of development projects.
Street Maintenance and Improvement: ($1.0 million below budget) – The full year estimate is $0.1 million, which is $0.3 million less than last year’s actual totals. This revenue source varies annually based on the timing of development projects, some of which were delayed this fiscal year.
Solid Waste Revenue: ($0.1 million below budget) – The full year estimate is $1.3 million, which is $0.1 million less than last year’s actual totals. The reduced revenue receipts experienced at the beginning of the fiscal year are due to timing of an amendment to the Franchise Agreement and are expected to be made whole by year end.
All City Expenditures by Category
As shown on the table below, the total of all City expenditures by category are $11.5 million above last year’s spending during the first six months of the year. The biggest increase is in CIP spending at $5.4 million, followed by Capital Outlay of $4.0 million, Debt Service of $1.7 million, and Other Costs of $1.0 million. Personnel costs
2.1.a
Packet Pg. 18
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) actually show a decrease of $0.4 million, but this is due to the one-time transfer of ongoing pension and retiree medical expenses to their respective reserve funds.
Contract Services costs have also decreased by $0.3 million over the same time frame since last year, but are estimated to end the fiscal year $0.06 million under budget at $24.4 million.
All City Expenditures by Category (in 000’s)
(All City Funds)
December
2022-2023
To Date
December
2021-2022
To Date Difference
Annual
2022-2023
Estimate
Annual
2022-2023
Budget* Difference
Personnel Services $ 27,361 $ 27,775 $ (414) $ 55,814 56,069 $ (255) Contract Services 8,732 9,077 (345) 24,426 24,366 60
Material & Supplies 974 813 161 2,652 2,548 104
Other Costs 7,823 6,856 967 13,657 13,663 (6)
Capital Outlay 4,492 455 4,037 5,875,513 2,100 5,873,413 Capital Improvement Program (CIP) 12,066 6,650 5,416 17,621 16,448 1,173 Debt Service 1,777 77 1,700 5,688 5,688 -
Total $ 63,227 $ 51,704 11,523$ $ 5,995,371 $ 120,882 $ 5,874,489 *Includes City Council approved budget adjustments and carry-over encumbrances
2.1.a
Packet Pg. 19
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review)
Mid-Year Budget Adjustments
There are a number of budgetary needs that have been identified since the budget was adopted last June. These proposed adjustments total $1,220,884 in the General Fund and $460,463 in Other Funds, and are recommended as follows:
Proposed changes impacting the General Fund:
• City Attorney’s Office – Planning Commission issues have taken significant amounts of staff time to address. Additional funding is needed to engage outside counsel to respond to all Planning Commission requests - $50,000. • City Manager’s Office – Request to conduct a community-wide survey to measure resident satisfaction with services and explore opportunities for areas of growth areas - $40,000.
• City Manager’s Office – Request to engage a revenue consultant to advise on potential new sources of City revenue - $30,000.
• Community Development/Building – Several large construction projects have been submitted or will be submitted before the end of the fiscal year, including Belmont Village at BR1A, the five-story 383 unit apartment development at BR1A, and large tenant improvements for Chevron. Plan check fees have already been collected to cover the additional expense - $800,000. • Public Works/Public Services Division – For purchase of vehicle and equipment fuel (unleaded and diesel), primarily due to increased fuel costs and increased usage. Over the past four fiscal years, an average of 48% of the fuel budget is typically depleted by the end of December. Currently, $123,770 or 69% of the fuel budget has been depleted; however, if approved, the requested adjustment of $80,000 would change this percentage from 69% to 48%, likely providing sufficient funding for fuel through the end of this fiscal year - $80,000.
• Public Works/Public Services Division – During labor negotiations, the City agreed to provide SEIU staff with a second pair of work boots each fiscal year.
This agreement occurred after the FY 2022-23 budget was completed such that the additional cost was not included in the FY 2022-23 Adopted Budget - $13,000.
• Public Works/Public Services Division – Upgrade one Maintenance Technician II position to Maintenance Specialist responsible for advancedjourney level maintenance activities within the Facilities Maintenance Program, including both skilled and semi-skilled work requiring special experience, training/education, licenses and/or certifications (e.g. HVAC).
The additional expense will be absorbed in the current fiscal year Public
2.1.a
Packet Pg. 20
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) Services budget, so no additional funding is needed. The ongoing cost of this upgrade beginning in FY 2023-24 is approximately $11,000 annually. • Public Works/Public Services Division – Additional funding is requested to cover gas and electricity usage at the San Ramon Olympic Pool, City Hall, Alcosta Senior and Community Center, and Citywide Street Lighting. The requested adjustments are primarily due to increases in overall usage, varying rate increases, and increased usage during “peak” and “part-peak” tier level.
General Fund total - $207,884 (project total $233,886).
Proposed changes impacting other operating funds include:
• Public Works/Public Services Division – Additional funding is requested to cover gas and electricity usage at the San Ramon Olympic Pool, City Hall, Alcosta Senior and Community Center, and Citywide Street Lighting. The requested adjustments are primarily due to increases in overall usage, varying rate increases, and increased usage during “peak” and “part-peak” tier level.
Citywide Street Lighting (Fund 302) - $26,002; (project total $233,886). Fund balance at fiscal year-end (FYE) is projected to be $880,392. • Public Works/Public Services Division (Various Funds) – Funds the various year-to-date auto accident damage repairs that have occurred throughout the City. Typical accident repairs include the replacement of street light poles, traffic signals, landscaping, irrigation, and fencing. The responsible party’s insurance company often reimburses the City for repairs. Fiscal impact is as follows:
o Citywide Landscaping (Fund 301) from fund balance - $41,439.
Fund balance at FYE is projected to be $369,331.
o Citywide Street Lighting (Fund 302) from fund balance - $6,511.
Fund balance at FYE is projected to be $880,392.
o Dougherty Valley Landscaping (Fund 343) from fund balance - $35,447
o Dougherty Valley Street Lighting (Fund 343) - from fund balance $1,404
• Public Works/Public Services Division (Fund 304) – To address an emergency mainline repair to prevent water flow on Woodview Terrace Drive within Special Assessment Zone 4 – Vista San Ramon from fund balance - $2,765. Fund balance at FYE is projected to be $19,164. • Public Works/Public Services Division (Fund 314) – To address emergency tree pruning of the oak trees in Special Assessment Zone 14 – Four Oaks.
The oak trees require pruning to prevent potential damage to adjacent homes
2.1.a
Packet Pg. 21
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) and to improve tree structure. Appropriate from fund balance - $14,600.
Fund balance at FYE is projected to be $34,544.
• Public Works/CIP 925425 - HVAC Duct Cleaning & Equipment Replacement (from Infrastructure Maintenance Fund 618) - Funding needed to cover any unforeseen HVAC repairs or unit replacements from fund balance - $50,000.
Fund Balance $576,282
• Public Works/CIP 300005 – Summerwood Loop Zone 5 Improvements (from Citywide Landscape Zone 2, Fund 301) - $82,990
o To review and reconcile the Engineer’s Report for Summerwood Loop’s general benefit charge - $2,243. Fund balance at FYE is projected to be $369,331.
o To correct previous under-transfers from Citywide Landscape, Zone 2 to Summerwood Loop (Zone 5) - $80,747. Fund balance at FYE is projected to be $369,331.
• Public Works/CIP 200007 – Joint Public Safety Complex Landscape Renovation. Additional funding needed from Infrastructure Maintenance Fund 618 as site improvements are separate from building renovation. Cost will be split equally with the Fire District - $100,000. Fund Balance $576,282. • Public Works/CIP 200007 – Joint Public Safety Complex EV Charging Stations. Additional funding needed from Infrastructure Maintenance Fund 618 as site improvements are separate from building renovation. Cost will be split equally with the Fire District to cover installation of electric vehicle charging stations - $85,000. Fund Balance $576,282.
• Public Works/CIP 925515 – Joint Public Safety Complex Security Gate for San Ramon Police Department. Current gate is no longer reliable and needs to be replaced with funding from Infrastructure Maintenance Fund 618 - $14,305. Fund Balance $576,282.
2.1.a
Packet Pg. 22
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) Looking Forward to FY 2023-24:
The budget development process for 2023-24 is underway. Laying the foundation for that budget will be how the City fares with the FY 2022-23 budget, which was balanced using one-time reserve funds of $3.2 million from the PARS Pension Stabilization Fund and $2.2 million ($5.4 million total) from the Healthcare Fund to pay for ongoing expenses. The previous two fiscal years (FY 2021-22 and FY 2020- 21) were each balanced with $4.1 million in funding from the American Rescue Plan Act. These funding bridges need to be replaced with new ongoing funding sources.
The return of sales tax to pre-pandemic levels is a good start, but other major sources, such as transient occupancy tax due to business travel, may never fully recover. The FY 2022-23 budget is projected to end the fiscal year at approximately 35% in General Fund reserves, and the FY 2023-24 budget will be equally strained to maintain the 36% reserve balance per City policy.
Other key issues in developing the budget include:
Strategic cost reduction
Identification of new sources of revenue
Rising costs of employee benefits and inflationary costs Maintaining service levels with resource constraints
2.1.a
Packet Pg. 23
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) Conclusion:
Projections indicate that the General Fund will end fiscal year 2022-23 with a net increase to fund balance of approximately $2.9 million. This positive result is due to better than anticipated sales tax revenues, careful monitoring of expenditures and salary savings from position vacancies. The projected net gain, however, will be more than offset when the annual pension and retiree medical expenses, budgeted at $5.4 million this year, return to the General Fund next year. These obligations leave another potential funding gap of approximately $2.5 million in annual expense.
General Fund revenue is estimated to be $2.7 million above budget, while the expenditures are projected to be $0.1 million below budget. The projected ending policy reserves before mid-year adjustments are $19.3 million or 35% of the prior fiscal year’s audited General Fund expenditures, plus the General Fund transfer to the Dougherty Valley Fund. If Council approves the $1.2 million of General Fund midyear requests, the projected ending reserves would be at $18.0 million or 33% of the prior fiscal year’s audited General Fund expenditures, plus the General Fund transfer to the Dougherty Valley Fund. The remaining $0.5 million of mid-year requests will be funded by other dedicated sources.
Staff will continue to monitor revenue receipts and will update the estimates as part of the upcoming budget process for 2023-24.
2.1.a
Packet Pg. 24
Attachment: A. Mid-Year Finanical Report FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) DESCRIPTION 12/31/2022 12/31/2021 DIFFERENCE ESTIMATE BUDGET DIFFERENCE FUND BALANCE, JULY 1 $ 19,686,545 $ 19,686,545 $ -
REVENUES
Property Tax $ 10,797,509 $ 10,164,343 $ 633,165 $ 24,376,859 $ 24,376,859 $ - Sales and Use Tax 4,474,978 3,847,447 627,531 13,290,794 11,298,342 1,992,452 Property Transfer Tax 419,537 578,186 (158,650) 1,054,696 1,054,696 - Transient Occupancy Taxes (TOT) 847,245 700,735 146,510 2,317,261 2,317,261 - Franchise Fees 1,277,877 1,679,835 (401,958) 5,737,096 5,737,096 - Licenses and Permits 1,289,935 1,199,923 90,012 3,598,250 2,748,250 850,000 Intergovernmental 291,903 158,919 132,984 614,012 498,484 115,528 Charges for Services 3,181,893 2,655,726 526,167 6,021,812 6,251,004 (229,192) Fines and Forfeitures 64,921 54,504 10,417 289,000 289,000 - Investment Income 105,981 62,624 43,357 105,000 105,000 - Miscellaneous Revenue 1,638,585 1,045,825 592,760 3,151,707 3,176,466 (24,759) Total Revenues 24,390,363 22,148,069 2,242,295 60,556,487 57,852,458 2,704,029
EXPENDITURES
General Government 1,400,157 1,363,561 36,597 3,097,351 3,255,183 (157,832) Administrative Services 2,751,593 2,523,567 228,027 5,581,724 5,581,724 - Community Development 2,053,930 1,885,275 168,655 4,528,102 4,578,615 (50,513) Police Services 6,505,907 6,799,573 (293,666) 14,922,602 14,922,602 - Public Works 6,925,373 6,969,320 (43,947) 16,169,296 16,001,438 167,858 Parks & Community Services 3,727,171 3,412,151 315,020 8,286,286 8,460,650 (174,364) Non-Departmental 4,773 - 4,773 50,000 50,000 -
Total Expenditures 23,368,905 22,953,446 415,459 52,635,361 52,850,212 (214,851)
OTHER FINANCING SOURCES (USES)
Operating Transfers In 4,781,633 4,781,633 -
Operating Transfers Out (9,623,337) (9,846,292) 222,955 Total Other Financing Sources (4,841,704) (5,064,659) 222,955 Net Increase (Decrease) in Fund Balance $ 3,079,422 $ (62,413) $ 3,141,835 FUND BALANCE:
Unreserved Fund Balance in General Fund $ 22,765,967 $ 19,624,132 TOTAL FUND BALANCE, JUNE 30 $ 22,765,967 $ 19,624,132
GENERAL FUND
REVENUE - EXPENDITURE - FUND BALANCE
6 MONTHS ENDING FULL YEAR 22/23
2.1.b
Packet Pg. 25
Attachment: B. Mid-Year Financial Summaries FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) DESCRIPTION 12/31/2022 12/31/2021 DIFFERENCE ESTIMATE BUDGET DIFFERENCE FUND BALANCE, JULY 1 $ 18,244,808 $ 18,244,808 $ -
REVENUES
Property Tax $ 10,797,509 $ 10,164,343 $ 633,165 $ 24,376,859 $ 24,376,859 $ - Sales and Use Tax 4,474,978 3,847,447 627,531 11,298,342 11,298,342 - Property Transfer Tax 419,537 578,186 (158,650) 1,054,696 1,054,696 - Transient Occupancy Taxes (TOT) 847,245 700,735 146,510 2,317,261 2,317,261 - Franchise Fees 1,277,877 1,679,835 (401,958) 5,737,096 5,737,096 - Licenses and Permits 1,289,935 1,199,923 90,012 3,598,250 2,748,250 850,000 Intergovernmental 291,903 158,919 132,984 20,947,642 20,832,114 115,528 Charges for Services 3,181,893 2,655,726 526,167 6,021,812 6,251,654 (229,842) Fines and Forfeitures 64,921 54,504 10,417 289,000 289,000 - Investment Income 105,981 62,624 43,357 105,000 105,000 - Miscellaneous Revenue 1,663,237 1,071,123 592,114 3,176,359 3,176,466 (107) Total Revenues 24,415,015 22,173,367 2,241,649 78,922,317 78,186,738 735,579
EXPENDITURES
General Government 1,400,157 1,363,561 36,597 3,097,351 3,255,183 (157,832) Administrative Services 2,751,593 2,523,567 228,027 5,581,724 5,581,724 - Community Development 2,053,930 1,885,275 168,655 4,528,102 4,578,615 (50,513) Police Services 10,188,651 10,641,043 (452,392) 23,692,930 23,692,930 - Public Works 12,538,836 12,627,654 (88,817) 29,518,459 29,374,253 144,206 Parks & Community Services 3,727,171 3,412,151 315,020 8,286,286 8,460,650 (174,364) Non-Departmental 4,773 - 4,773 50,000 50,000 -
Total Expenditures 32,665,112 32,453,250 211,863 74,754,852 74,993,355 (238,503)
OTHER FINANCING SOURCES (USES)
Operating Transfers In 7,077,481 7,077,481 -
Operating Transfers Out (10,110,322) (10,333,277) 222,955 Total Other Financing Sources (3,032,841) (3,255,796) 222,955 Net Increase (Decrease) in Fund Balance $ 1,134,624 $ (62,413) $ 1,197,037 TOTAL FUND BALANCE, JUNE 30 $ 19,379,432 $ 18,182,395
GENERAL FUND AND DOUGHERTY VALLEY FUND
REVENUE - EXPENDITURE - FUND BALANCE
6 MONTHS ENDING FULL YEAR 22/23
2.1.b
Packet Pg. 26
Attachment: B. Mid-Year Financial Summaries FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) FUND # FUND DESCRIPTION 12/31/2022 12/31/2021 DIFF ESTIMATE BUDGET DIFF 101 General Fund $ 24,390,363 $ 22,148,069 $ 2,242,295 $ 60,556,487 $ 57,852,458 $ 2,704,029 201 Planning Cost Recovery 358,158 119,393 238,765 312,157 312,157 - 202 Geographic Information Systems 53,219 46,842 6,378 95,000 95,000 - 203-207 Development Mitigation 322,839 274,437 48,402 1,130,919 1,235,735 (104,816) 208 Gas Tax 1,539,670 1,551,889 (12,219) 4,351,860 4,351,860 - 209-210 Park Development 175,489 1,604 173,885 2,296,662 2,296,662 - 211 Crow Canyon Project - 29 (29) - - -
212 SCCJEPA 1,099,676 312,556 787,121 2,718,509 2,718,509 - 213 Street Maintenance & Improvement 163,950 9,600 154,349 100,000 1,109,099 (1,009,099) 214 Traffic Improvement 290,609 93,640 196,969 878,135 878,135 - 215 Tri-Valley Transportation Fund (105,618) 345,501 (451,119) 355,837 355,837 - 216 Public Education & Governement 58,249 56,883 1,366 195,000 195,000 - 217 Vehicle Refuse Impact Fees 590,421 60,265 530,156 1,615,220 1,615,220 - 218 Open Space Development 47,318 19 47,299 404,179 404,179 - 251/252 CFD 2014-1 Acres/Faria 245,513 202,715 42,798 383,253 383,253 - 301 Citywide Landscaping 995,868 1,020,334 (24,465) 1,794,681 1,792,480 2,201 302 Citywide Lighting 313,781 437,355 (123,574) 813,508 799,175 14,333 303-319 Landscaping & Lighting Special Districts 632,789 631,017 1,772 1,130,320 1,130,320 - 330 The Preserve Faria 53,372 58,226 (4,853) 114,522 114,522 - 341 Canyon Park 1,271 1,495 (224) 10,990 10,990 -
342 Village Center Common Area 441 446 (5) 6,006 6,006 - 343 Dougherty Valley 24,652 25,298 (646) 20,358,282 20,334,280 24,002 344 Solid Waste 420,843 460,822 (39,979) 1,332,215 1,412,215 (80,000) 345 Non Point Drainage 20,418 43,357 (22,940) 1,222,015 1,222,015 - 346 Streets Smarts Program 81,171 94,562 (13,391) 207,750 207,750 - 347 TDM Programs 40,132 61,702 (21,569) 646,379 646,379 - 348 Local Law Enforcement Block Grant 33 38 (4) - - -
349 Police Services Donations 300 67 233 - - -
350 Narcotics Asset Forfeiture 1,501 8,344 (6,843) - - - 351 TRAFFIX Program 89,880 56,182 33,697 139,759 139,759 - 352 Abandoned Veh Abatement Fund 3,401 - 3,401 -
361 GHAD-Dougherty Valley 1,290,113 1,289,673 440 2,348,489 2,343,989 4,500 362 GHAD-NW San Ramon 285,313 217,217 68,096 459,506 459,506 - 371 San Ramon Housing 2,131 78,902 (76,771) 2,393,320 2,393,320 - 401 Capital Projects 3,402,239 632,862 2,769,377 4,639,313 4,639,313 - 501-521 Debt Service Funds 1,058,642 659,666 398,976 3,287,450 3,287,450 - 601-618 Internal Service Funds 3,187,359 4,153,257 (965,898) 12,568,420 12,568,420 - Total Revenues Excluding Transfers $ 41,135,506 $ 35,154,262 $ 5,981,244 $ 128,866,143 $ 127,310,993 $ 1,555,150 6 MONTHS ENDING FULL YEAR 22/23
All City Revenue by Fund
2.1.b
Packet Pg. 27
Attachment: B. Mid-Year Financial Summaries FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) FUND # FUND DESCRIPTION 12/31/2022 12/31/2021 DIFF ESTIMATE BUDGET * DIFF 101 General Fund $ 23,368,905 $ 22,953,446 $ 415,459 $ 52,635,361 $ 52,850,212 $ (214,851) 201 Planning Cost Recovery 74,908 116,796 (41,887) 164,422 164,422 - 202 Geographic Information Systems 74,701 67,470 7,231 102,533 102,533 - 216 Public Education & Government 36,969 11,175 25,793 335,000 335,000 - 301 Citywide Landscaping 482,614 529,535 (46,921) 1,200,681 1,205,404 (4,723) 302 Citywide Lighting 298,742 162,851 135,891 671,746 671,746 - 303-319 Landscaping & Lighting Special Districts 490,503 588,938 (98,435) 1,386,230 1,388,762 (2,532) 330 The Preserve Faria 18,816 721 18,095 63,101 63,101 - 341 Canyon Park 26,183 2,465 23,718 59,426 59,426 -
342 Village Center Common Area 766 1,472 (707) 6,294 6,294 - 343 Dougherty Valley 9,296,207 9,635,473 (339,266) 22,141,688 22,143,143 (1,455) 344 Solid Waste 368,644 1,134,223 (765,580) 1,406,472 1,406,472 - 345 Non Point Drainage 264,279 322,647 (58,368) 1,245,084 1,245,084 - 346 Street Smarts Program 80,439 58,840 21,599 123,923 123,923 - 347 TDM Programs 126,455 116,694 9,762 646,379 646,379 - 350 Narcotics Asset Forfeiture 122,474 - 122,474 100,000 100,000 - 351 TRAFFIX Program 69,777 42,625 27,152 139,759 139,759 - 361 GHAD - Dougherty Valley 208,351 299,814 (91,464) 1,020,655 1,020,655 - 371 San Ramon Housing 4,068,635 76,469 3,992,166 146,477 146,477 - 401 Capital Projects 12,066,321 6,911,477 5,154,844 17,620,628 16,447,949 1,172,679 501-521 Debt Service Funds 1,777,487 77,290 1,700,197 5,687,972 5,687,972 - 601-611 Internal Service Funds 9,904,530 8,593,641 1,310,889 14,777,465 14,927,465 (150,000) Total Expenditures Excluding Transfers $ 63,226,705 $ 51,704,060 $ 11,522,645 $ 121,681,296 $ 120,882,178 $ 799,118 * Includes Council approved budget adjustments and carry-over encumbrances All City Expenditures by Fund
6 MONTHS ENDING FULL YEAR 22/23
2.1.b
Packet Pg. 28
Attachment: B. Mid-Year Financial Summaries FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review) CATEGORY 12/31/2022 12/31/2021 DIFF ESTIMATE BUDGET * DIFF Personnel Services $ 27,361,364 $ 27,775,089 $ (413,725) $ 55,813,704 $ 56,068,596 (254,892) Contract Services 8,732,178 9,077,178 (345,000) 24,426,099 24,365,601 60,498 Material & Supplies 974,160 812,916 161,244 2,630,321 2,548,356 81,965 Other Costs 7,823,268 6,856,134 967,134 13,657,411 13,663,411 (6,000) Capital Outlay 4,491,927 455,018 4,036,909 1,953,355 2,100,293 (146,938) Capital Improvement Program (CIP) 12,066,321 6,650,435 5,415,886 17,620,628 16,447,949 1,172,679 Debt Service 1,777,487 77,290 1,700,197 5,687,972 5,687,972 - Total Expenditures Excluding Transfers $ 63,226,705 $ 51,704,060 $ 11,522,645 $ 121,789,490 $ 120,882,178 $ 907,312 * Includes Council approved budget adjustments and carry-over encumbrances All City Expenditures by Category
6 MONTHS ENDING FULL YEAR 22/23
2.1.b
Packet Pg. 29
Attachment: B. Mid-Year Financial Summaries FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review)
DEPARTMENT AUTHORIZED FUNDED
ACTUAL
12/31/22
VACANT
(Funded)
General Government 11.00 11.00 11.00 -
Administrative Services 19.00 19.00 18.00 1.00
Community Development 20.00 19.00 17.00 2.00
Police Services 89.00 89.00 83.00 6.00
Public Works 106.75 106.75 99.75 7.00
Parks and Community Services 34.00 29.00 26.00 3.00
Total FTE Personnel 279.75 273.75 254.75 19.00
Vacancy Rate: 7%
FULL-TIME EQUIVALENTS (FTE) BY DEPARTMENT
STAFFING LEVELS
2.1.b
Packet Pg. 30
Attachment: B. Mid-Year Financial Summaries FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review)
YTD ADJUSTED
DEPARTMENT BUDGET * Gen Fund Other Funds BUDGET
General Government $ 3,187,425 - - $ 3,187,425
City Attorney's Office - Outside Counsel - 50,000 - -
City Manager's Office - Community Survey - 40,000 - -
City Manager's Office - Revenue Consultant - 30,000 - 120,000 Administrative Services 5,270,698 - - 5,270,698
Community Development 4,760,785 - - -
Plan Check Services ** - 800,000 - 5,560,785
Police Services 26,936,571 - - 26,936,571
Parks & Community Services 8,640,785 - - 8,640,785
Public Works 37,697,591 - - 37,697,591
Vehicle and Equipment Fuel - 80,000 - -
Safety Boots - 13,000 - -
Gas and Electricty - San Ramon Olympic Pool - 166,234 - - Gas and Electricty - City Hall - 28,733 - -
Gas and Electricty - Alcosta Sr. & Community Ctr. - 12,917 - 300,884 Gas and Electricty - Citywide Street Lighting - - 26,002 - Upgrade Maint Tech I/II to Maint Specialist *** - - - - Auto Accident Repairs - Citywide Landscape - - 41,439 - Auto Accident Repairs - Citywide Lighting - - 6,511 -
Auto Accident Repairs - DV Landscaping - - 35,447 -
Auto Accident Repairs - DV Street Lighting - - 1,404 -
Mainline Repair - Vista San Ramon - - 2,765 -
Hazardous Tree Pruning - Four Oaks Arterial - - 14,600 128,168 Capital Improvement Projects - - - -
HVAC Duct Clean & Equipt Replcmt - CIP 925425 - - 50,000 - Zone 5 - Summerwood Loop - CIP 300005 - - 82,990 -
Public Safety Complex/Landscape - CIP 200007 - - 100,000 - Public Safety Complex/EV Charging - CIP 200007 - - 85,000 - Public Safety Complex/Gate Repair - CIP 925515 - - 14,305 332,295 TOTAL $86,493,855 $ 1,220,884 $ 460,463 $ 88,175,202
* Includes Council approved budget adjustments and carry-over encumbrances. Excludes Transfers, Capital Outlay, CIP, Debt Service and Internal Service
** Expense offset by new unbudgeted revenue collected for this purpose. *** Cost will be absorbed within the Public Works budget in FY23. Ongoing cost is approximately $11,000 annually.
FY 2022-23 Proposed Mid-Year
Adjustments by Department
ADJUSTMENT
2.1.c
Packet Pg. 31
Attachment: C. Mid-Year Adjustments Summary FY 22-23 (3894 : FY 2022-23 Mid-Year Financial Review)