Addendum.Item #14 - Mid-Year Budget Performance Report
PREPARED BY: Gitta Ungvari
Finance Director
Reviewed by: Town Manager and Town Attorney
110 E. Main Street Los Gatos, CA 95030 ● (408) 354-6832
www.losgatosca.gov
TOWN OF LOS GATOS
COUNCIL AGENDA REPORT
MEETING DATE: 02/21/2023 ITEM NO: 14 ADDENDUM
DATE: February 17, 2023
TO: Mayor and Town Council
FROM: Laurel Prevetti, Town Manager
SUBJECT: Mid-Year Budget Report - July 1 - December 31, 2022:
a. Receive FY 2022/23 Mid-Year Budget Report;
b. Authorize Budget Adjustments as Recommended in the Mid-Year Budget
Report; and
c. Provide Direction of the Order of Authorized Funding Source to Balance
the FY 2022/23 Operating Budget, if Necessary, at the Final Close of the
Fiscal Year.
REMARKS:
A Council Member had the following inquiries and staff’s response is below.
Please confirm if $4,998,746 of American Rescue Plan Act (ARPA) funds are currently
available to be reprogrammed by the Town Council, itemize what ARPA funds have actually
been spent, specify what funds have been programmed but not spent and what is the
estimated revenues over expenditures.
FY 2020/21 GRAND
BUDGET ADJ.
ACTUALS ESTIMATED ACTUALS BAL REMAINING ESTIMATED EST. MID-YEAR TOTAL
ARPA FUNDS REVENUE RECOGNIZED 200,911$ 3,413,961$ 3,614,872$ 7,229,744$
GOV SERVICES (WAIVERS,CUP&ADA,DIRECT GRANTS)200,911 200,911 REVENUE LOSS -GOV SERVICES (PUBLIC SAFETY)3,413,961 3,413,961 3,614,872 7,028,833
200,911$ 3,413,961$ 3,614,872$ 7,229,744$
GENERAL FUND ARPA REPLACEMENT REVENUES AVAILABLE 200,911$ 3,413,961$ 3,614,872$ 7,229,744$ LESS APPROVED USES TO BE BUDGETED: PARKLETS (DOWNTOWN IMPVTS PROJECT)-$ 680,000$ 466,428$ 213,572$ 250,000$ -$ 930,000$
RENT WAIVERS 121,255 341,452 341,452 - 283,756 746,463
CUP/ADA FEE WAIVERS 19,656 27,672 27,672 - 27,672 75,000
DESTINATION MARKETING 55,000 55,000 - 55,000 K-RAILS (DOWNTOWN IMPVTS PROJECT)68,000 88,654 (20,654) 68,000 PROMENADES 80,000 69,855 10,145 120,000 90,628 200,000
DIRECT GRANTS 60,000 50,000 50,000 - 110,000
ENHANCED SENIOR SERVICES 500,000 249,597 250,403 500,000
CAPITAL IMPROVEMENT PROGRAM SUPPORT TRANSFERS 2,900,000 580,000 2,900,000 REQUIRED FOR GF BALANCING OF OPERATING REV_EXP 1,645,281 1,645,281
TOTAL ALLOCATIONS OF GENERAL FUND ARPA REPLACEMENT REVENUES 200,911$ 1,802,124$ 1,348,659$ 453,465$ 5,226,709$ 670,628$ 7,229,744$
FY 2021/22 FY 2022/23
PAGE 2 OF 3 SUBJECT: Mid-Year Budget Performance Report – Six Months Ending December 31, 2022 DATE: February 17, 2023
REMARKS (continued):
The table above is also found on page 27 of the Mid-Year Budget Report. It depicts that all of
the blue highlighted items that were not fully spent as of December 31 2022 will be fully
expended per Council direction for parklets, enhanced senior services, rent waivers, and other
items as listed.
The Adopted Budget included $2.9 million of ARPA allocation for Capital Purposes (highlighted
in orange in the above table). At its August 16, 2022 meeting, the Council approved the partial
programming of the $2.9 million as demonstrated in the table below.
Project Name
Recommended Funding
Allocation
East Main Street Crosswalk
Improvements 300,000
Downtown Restroom
Feasibility Study/Design 25,000
Rehabilitate Automatic Gates
- 41 Miles Avenue 25,000
Termite Abatement at Water
Tower – 41 Miles Avenue 25,000
Civic Center Plumbing Repair
– 110 E. Main Street 40,000
HVAC Improvements – Police
Operations Building 25,000
Engineering Counter
Modifications – 41 Miles
Avenue 40,000
Unanticipated Repairs 100,000
Council Add: Pinehurst
Community Garden Project 100,000
Reserve for Future Capital
Projects or Matching Funds 2,220,000
TOTAL $2,900,000
As demonstrated in this table, $2,220,000 were set aside for Future Capital Projects or
Matching Funds, such as Shannon Road repair and the required $750,000 match for the
Wildfire Grant. The Capital Improvement Program and direction will be discussed separately at
the the Finance Commission and Town Council March meetings.
Based on staff mid-year estimates, there is approximately $1.4 million operating revenues over
operating expenditures. If all assumptions hold true, the $1.6 million (highlighted in green in
PAGE 3 OF 3 SUBJECT: Mid-Year Budget Performance Report – Six Months Ending December 31, 2022 DATE: February 17, 2023
REMARKS (continued):
the table on the first page) most probably will not needed to balance the FY 2022/23 budget
and would be available for Council reprogramming at the final close of the Fiscal Year with the
audit (December 2023).
The following table demonstrates of the actual spending as of 2/15/2023 as a snapshot. The
actual numbers do not include encumbrances, or future obligations under signed agreements.
*Conditional Use Permit and Americans with Disability Act fee waivers for FY2022/23 will be
determined at the close of the fiscal year.
Attachments previously received with the Staff Report:
1. Mid-Year Budget Report - July 1 - December 31, 2022 as Presented at the Finance
Commission February 13, 2023 Meeting.
2. Public Comments Receive before Posting the Staff Report
Attachments received with this Addendum:
3. Public Comments received after publishing the Staff Report and before 11:01 a.m. on Friday
February 17.
GRAND ACTUAL
SPENDING
TOTAL AS OF 2/15/2023
ARPA FUNDS REVENUE RECOGNIZED 7,229,744$
GOV SERVICES (WAIVERS,CUP&ADA,DIRECT GRANTS)200,911
REVENUE LOSS -GOV SERVICES (PUBLIC SAFETY)7,028,833
7,229,744$
GENERAL FUND ARPA REPLACEMENT REVENUES AVAILABLE 7,229,744$
LESS APPROVED USES TO BE BUDGETED:
PARKLETS (DOWNTOWN IMPVTS PROJECT)930,000$ 926,262$
RENT WAIVERS 746,463 746,463
CUP/ADA FEE WAIVERS*75,000 47,328
DESTINATION MARKETING 55,000 55,000
K-RAILS (DOWNTOWN IMPVTS PROJECT)68,000 88,654
PROMENADES 200,000 200,000
DIRECT GRANTS 110,000 110,000
ENHANCED SENIOR SERVICES 500,000 455,067
CAPITAL IMPROVEMENT PROGRAM SUPPORT TRANSFERS 2,900,000 65,900
REQUIRED FOR GF BALANCING OF OPERATING REV_EXP 1,645,281 -
TOTAL ALLOCATIONS OF GENERAL FUND ARPA REPLACEMENT REVENUES 7,229,744$ 2,694,674$
AMERICAN RESCUE PLAN ACT (ARPA) SUMMARY WORKSHEET
From:Phil Koen
To:Gitta Ungvari
Subject:Question
Date:Thursday, February 16, 2023 10:30:30 PM
Attachments:Pages from MEET-Packet-ea2faa2d56764d67af3ef698c40b1cd1.pdf
[EXTERNAL SENDER]
Gitta,
Could you check to see which net change number for FY 23 is correct? On page 196 you are
showing $(3,876,603) and on page 256 you are showing $(4,007,441).
Thanks.
Phil
ATTACHMENT 3
Fund Schedule
Fund
Number Fund Description
Current
Revenue
Current
Expenditure Transfer In
Transfer
Out
GENERAL FUND
Non-Spendable:- - - - -
Loans Receivable 159,000 159,000
Restricted Fund Balances:
Pension 690,000 690,000
Committed Fund Balances:
Budget Stablization 5,991,566 5,991,566
Catastrphic 5,991,566 5,991,566
Pension/OPEB 300,000 300,000
Assigned Fund Balances:
Open Space 410,000 - - - 410,000
Sustainability 140,553 140,553
Capital/Special Projects 11,071,231 11,071,231
Carryover Encumbrances 33,145 - - - - 33,145
Compensated Absences 1,519,147 - - - - 1,519,147
Measure G District Sales Tax 590,581 - - - - 590,581
Unassigned Fund Balances:
111 Other Unassigned Fund Balance Reserve (Pre YE distribution - (3,355,854) 6,211,284 (6,732,033) - (3,876,603)
General Fund Total 26,896,789 (3,355,854) 6,211,284 (6,732,033) - - 23,020,186
December 2022 Prior Year
Carryforward
7/1/2022
Increase/
(Decrease)
July-Nov
Estimated Fund
Balance
12/31/2022*
Page 7Page 196
28
GENERAL FUND FINANCIAL SUMMARIES AND ESTIMATES
The following table is the Schedule of General Fund Operating Revenues Versus Operating Expenditures
for the second quarter of FY 2022/23which includes comparison information from the prior year.
The FY 2022/23 Adjusted Budget column includes the adopted budget and items that Council approved
during the course of the first two quarters of the fiscal year, such as additional funding for legal services,
and miscellaneous carry over grants from prior fiscal year.
The FY 2022/23 Estimated column contains projections of final balances for the current fiscal year based
upon staff analysis, the early trends observed through the second quarter in sales tax and property tax
projections, and the proposed mid-year adjustments as listed in this report.
The FY 2022/23 Estimated figures also include analysis on potential salary and other expenditure
savings; however, budget adjustments are only recommended as identified in this Report.
Staff continues to fine tune the detailed analysis of the FY 2022/23 year-end estimated revenue and
expenditure numbers and an update will be provided with the presentation of the Proposed Fiscal Year
2023/24 Operating Budget.
The following table illustrates the summary of the General Fund balance status based on current
estimates and prior year result.
The table in the following page provides the details of the Revenues and Use of Reserve and Total
Expenditures and Reserve Allocations.
FY 2021/22 FY 2021/22
2Q % of
FY 2021/22
2Q % of
FY 2022/23 FY 2022/23 FY 2022/23 FY 2022/23
Actuals Q2 Actuals Adjusted
Budget
as of 12/31/2022
Q2 Adjusted
Budget
Year End Estimates
Including
Proposed
Mid-Year
Adjustments
Total Revenues & Transfers In 54,448,222$ 17,978,806$ 33%34%17,098,505$ 50,266,120$ 50,546,861$
Total Expenditures 51,466,052 21,155,306 41%40%21,105,947 52,886,926 51,777,130
Net Increase (Decrease)2,982,171$ (4,007,441)$ (2,620,805)$ (1,230,268)$
Beginning Fund Balance 23,914,618 26,896,789 26,896,789 26,896,789
Ending Fund Balance 26,896,789$ 22,889,348$ 24,275,983$ 25,666,521$
GENERAL FUND
SUMMARY OF REVENUES AND EXPENDITURES
Page 256
8
O O