CC 11-16-2021 Item No. 15 First Quarter Financial Report_Staff PresentationFISCAL YEAR 2021-22
FIRST QUARTER FINANCIAL REPORT
CC 11-16-2021 Item No. 15
Agenda
Budget Reporting Cycle
How We Ended FY 2020-21
Amended Budget as of September 30, 2021
General Fund Update
Recommended Adjustments
Staffing
City Manager Discretionary Fund
American Rescue Plan Act of 2021
Recommendations and Next Steps
Transparency and Engagement
Budget Reporting Cycle
Proposed Budget
May
Final Budget
June/July
First Quarter
November
Mid-Year
February/March
Third Quarter
May
$172.7
$196.4
$149.8
$169.0
-$22.9 -$27.4
Expenditure Revenue
In
M
i
l
l
i
o
n
s
Budget Year-End Variance
FY21 Year End Actuals vs. Budget All Funds
FY21 Year-End Fund Balance Impact: +$19.2M
General Special Debt
Capital
Project Enterprise Internal
Service
Revenue $106.2 $12.4 $29.1 $8.3 $7.7 $5.3
Expenditure $83.9 $10.8 $30.7 $11.8 $5.6 $7.0
Fund Balance $22.4 $1.5 -$1.6 -$3.5 $2.1 -$1.7
-$20.0
$0.0
$20.0
$40.0
$60.0
$80.0
$100.0
$120.0
In
M
i
l
l
i
o
n
s
FY22 Amended Budget as of September 30,
2021- $225M
$121.00 $148.80 $76.8
IN
M
I
L
L
I
O
N
S
Proposed Final Budget Adjustments
FY22 Appropriation Changes since Adopted Budget
Fund
FY 21‐22
Adopted Carryovers Encumbrances
Adjustments
Approved in 1st
Quarter
FY 21‐22 Amended
Budget as of
September 30, 2021
General 89,767,034$ 22,657,533$ $ 4,906,141 5,959,987$ 123,290,695$
Special Revenue 18,597,024 11,749,252 2,414,116 ‐ 32,760,392
Debt Service 2,676,000 ‐ ‐ ‐ 2,676,000
Capital Projects 19,540,048 18,540,682 9,149,571 ‐ 47,230,301
Enterprise 9,417,117 855,369 189,833 26,400 10,488,719
Internal Service 8,848,012 60,790 208,700 ‐ 9,117,502
Total All Funds 148,845,235$ 53,863,626$ 16,868,361$ 5,986,387$ 225,563,609$
General Fund Revenues & Expenditures -
First Quarter Trends (3-year)
15%
34%
12%
29%
17%
27%
0%
5%
10%
15%
20%
25%
30%
35%
40%
Revenue Expenditures
High Low FY 21‐22
Revenue Category First Quarter 2021 First Quarter 2022 Variance % Change
05 ‐ Sales tax 9,533,877 8,018,866 (1,515,011)‐16%
10 ‐ Property tax 65,504 265,394 199,890 305%
15 ‐ Transient occupancy 237,729 287,021 49,292 21%
20 ‐ Utility tax 486,890 478,155 (8,735)‐2%
25 ‐ Franchise fees 137,188 170,876 33,687 25%
30 ‐ Other taxes 701,149 386,972 (314,177)‐45%
35 ‐ Licenses and permits 900,111 1,137,359 237,247 26%
40 ‐ Use of money and property 455,014 457,314 2,300 1%
45 ‐ Intergovernmental revenue 468,275 2,786,645 2,318,370 495%
50 ‐ Charges for services 2,589,194 3,035,050 445,856 17%
55 ‐ Fines and forfeitures 16,453 36,578 20,126 122%
60 ‐ Miscellaneous 126,875 236,900 110,025 87%
65 ‐ Transfers in 15,000 4,862,387 4,847,387 32316%
70 ‐ Other financing sources 78,952 0 (78,952)‐100%
Grand Total 15,812,213 22,159,516 6,347,303 40%
General Fund Revenues ‐ First Quarter FY21 vs. FY22
Expenditure Category First Quarter 2021 First Quarter 2022 Variance % Change
05 ‐ Employee compensation 4,485,425 4,534,220 48,795 1%
10 ‐ Employee benefits 2,297,198 2,374,179 76,981 3%
15 ‐ Materials 832,909 951,929 119,020 14%
20 ‐ Contract services 5,458,401 5,826,209 367,808 7%
25 ‐ Cost allocation 2,618,385 2,987,016 368,631 14%
30 ‐ Capital outlays 0 750 750 N/A
31 ‐ Special projects 298,945 287,063 (11,883)‐4%
35 ‐ Contingencies 0 0 0 N/A
45 ‐ Transfer out 9,948,689 16,099,371 6,150,682 62%
50 ‐ Other financing uses 72,778 139,096 66,318 91%
Grand Total $26,012,730 $33,199,832 $7,187,102 28%
General Fund Expenditures ‐ First Quarter FY 21 vs. FY22
Actuals
2019-20
Year-End Projection
2020-21
Adopted Budget
2021-22
1st Qtr Projection
2021-22
Non Spendable 3.45 3.44 3.44 3.44
Restricted 14.32 19.92 21.87 21.92
Committed 19.13 19.13 19.13 19.13
Assigned 3.18 4.91 3 4.91
Unassigned 34.43 49.45 35.7 64.47
Total Fund Balance 74.51 96.85 83.14 113.87
0
20
40
60
80
100
120
In
M
i
l
l
i
o
n
s
General Fund – Fund Balance
Fund Department Expenditure Revenue Fund Balance
(Use of)
Description
100 Administration 332,074 ‐ (332,074) Economic Development Functional Transfer
100 Administration 30,000 ‐ (30,000) Economic Development Strategic Plan Research
100 Administrative Services 200,000 ‐ (200,000) PLAN JPA ‐ Premium and Settlement Costs
100 Community Development (332,074) ‐ 332,074 Economic Development Functional Transfer
100 Community Development 20,228 23,262 3,034 Westport legal services
100 Community Development 80,000 123,077 43,077 Construction Plan Check
100 Public Works 3,149 ‐ (3,149) Community Garden Lock Replacement
100 Public Works 54,966 (54,966) McClellan Ranch Park Path Repairs
100 Public Works 14,400 (14,400) QCC Tree Removal and Replacement
100 Public Works 31,950 (31,950) Memorial Park Softball Fencing
100 Public Works 16,800 (16,800) Blackberry Farm Main Line Break Repair
100 Public Works 20,000 (20,000) Lawrence Mitty Site Fence Repairs
100 Public Works 25,000 (25,000) Unhoused Encampment Cleanup
100 Public Works 5,042 (5,042) Portable Restroom & Hand Washing Station
100 Public Works 120,000 (120,000) City Hall HVAC Ventilation
100 Public Works 588 588 ‐ Library Bikeep Monthly Maintenance Fees
100 Public Works 19,000 19,000 ‐ Library Boiler Piping Improvements
100 Public Works 35,000 35,000 ‐ Library Cooling Repairs
100 Public Works 22,362 22,362 ‐ Library Security System Enhancements
100 Public Works 199,514 (199,514) Service Center Automatic Gate Install
100 Public Works 9,120 (9,120) Linda Vista Trail Lockdown
100 Public Works 80,000 72,000 (8,000) Local Roadway Safety Plan
100 Public Works 160,000 ‐ (160,000) Adaptive Traffic Signaling (CWP)
100 Non‐Departmental ‐ 200,000 200,000 Transfer in from BMR Housing Special Revenue Fund
(Homeless Encampment)
1,147,119 495,289 (651,830)
Recommended Adjustments
GENERAL FUND
TOTAL GENERAL FUND
Fund Department Expenditure Revenue Fund Balance
(Use of)
Description
230 Public Works 8,706 ‐ (8,706) CUSD Cost Share for School Field Areas
230 Public Works 3,975 ‐ (3,975) Portable Water Meter and Service
265 Non‐Departmental 200,000 ‐ (200,000) Transfer out to General Fund (Homeless
Encampment)
212,681 ‐ (212,681)
560 Parks & Recreation 64,900 ‐ (64,900) Golf Course Netting Replacement
570 Public Works 10,000 ‐ (10,000) Power Surge Breaker Replacement
570 Public Works 6,500 ‐ (6,500) HVAC #4 Controls Repair
81,400 ‐ (81,400)
610 Innovation & Technology 150,000 ‐ (150,000) CIP Management System
630 Public Works 40,045 ‐ (40,045) Security Surveillance System for Lawrence Mitty Site
190,045 ‐ (190,045)
TOTAL ALL FUNDS 1,631,245 495,289 (1,135,956)
Recommended Adjustments
INTERNAL SERVICE FUND
TOTAL INTERNAL SERVICE FUND
SPECIAL REVENUE FUND
TOTAL SPECIAL REVENUE FUND
ENTERPISE FUND
TOTAL ENTERPRISE FUND
•Administration- $362,074
Adjustments by Department
Description Revenue Expenditure Fund
Balance
Economic Development Functional
Transfer*
- $332,074 ($332,074)
Economic Development Strategic Plan
Research
- $30,000 ($30,000)
*On-going cost. Will be added to base budget for FY 22-23.
•Administrative Services- $200,000
Adjustments by Department
Description Revenue Expenditure Fund
Balance
PLAN JPA Liability Insurance Premiums*- $200,000 ($200,000)
*On-going cost. Base budget will be adjusted for FY 22-23.
•Innovation & Technology- $150,000
Adjustments by Department
Description Revenue Expenditure Fund
Balance
CIP Management System*- $150,000 ($150,000)
*$75,000 on-going cost. Wil be added to base budget for FY
22-23.
•Community Development- ($231,846)
Adjustments by Department
Description Revenue Expenditure Fund
Balance
Economic Development Functional
Transfer*
- ($332,074) $332,074
Westport Legal Services $23,262 $20,228 $3,034
Construction Plan Check $123,077 $80,000 $43,077
TOTAL $146,339 ($231,846) $378,185
*On-going cost. Will be reflected in FY 22-23 Proposed Budget.
•Parks & Recreation- $64,900
Adjustments by Department
Description Revenue Expenditure Fund
Balance
Golf Course Netting Replacement - $64,900 ($64,900)
•Public Works- $886,117
Adjustments by Department
Description Revenue Expenditure Fund
Balance
Community Garden Lock Replacement - $3,149 ($3,149)
McClellan Ranch Park Path Repairs - $54,966 ($54,966)
QCC Tree Removal and Replacement - $14,400 ($14,400)
Memorial Park Softball Fencing - $31,950 (31,950)
Blackberry Farm Main Line Break Repair - $16,800 ($16,800)
Lawrence Mitty Site Fence Repairs* - $20,000 ($20,000)
*On-going cost. Will be added to base budget for FY 22-23.
•Public Works- continued
Adjustments by Department
Description Revenue Expenditure Fund
Balance
Unhoused Encampment Cleanup - $25,000 ($25,000)
Portable Restroom & Hand Washing* - $5,042 ($5,042)
City Hall HVAC Ventilation - $120,000 ($120,000)
Library Bikeep Monthly Maintenance Fee* $588 $588 -
Library Boiler Piping Improvements $19,000 $19,000 -
Library Cooling Repairs $35,000 $35,000 -
*On-going cost. Will be added to base budget for FY 22-23.
•Public Works- continued
Adjustments by Department
Description Revenue Expenditure Fund
Balance
Library Security System Enhancements $22,362 $22,362 -
Service Center Automatic Gate Install - $199,514 ($199,514)
Linda Vista Trail Lockdown* - $9,120 ($9,120)
Local Roadway Safety Plan $72,000 $80,000 ($8,000)
Adaptive Traffic Signaling (CWP)- $160,000 ($160,000)
CUSD Cost Share for School Field Areas* - $8,706 ($8,706)
*On-going cost. Will be added to base budget for FY 22-23.
•Public Works- continued
Adjustments by Department
Description Revenue Expenditure Fund
Balance
Portable Water Meter and Service - $3,975 ($3,975)
Power Surge Breaker Replacement - $10,000 ($10,000)
HVAC #4 Controls Repairs - $6,500 ($6,500)
Security Surveillance for Lawrence Mitty - $40,045 ($40,045)
TOTAL $148,950 $886,117 ($737,167)
•Non-Departmental- $200,000
Adjustments by Department
Description Revenue Expenditure Fund
Balance
Wolfe Road Encampment Transfer $200,000 $200,000 -
Staffing
•No recommended changes to staffing.
City Manager Discretionary Fund
•$75,000 Adopted Budget remains intact
•Staff anticipate using a portion of these funds to provide
free feminine products in various restrooms throughout
the City
•Staff will continue to report out on the use of this fund
American Rescue Plan Act of 2021
Of the $4.8M in funding, $2.8M in revenues recognized
•Transportation Transfer - $1,333,773
•Law Enforcement Services - $972,987
•General Liability Insurance - $182,112
•Administration Overhead - $95,787
•CDD Customer Service Solution - $42,180
•Climate Action Plan - $40,466
•Municipal Water System - $10,000
•General Plan and Muni Code Update - $8,265
•Accept the City Manager’s First Quarter Financial Report
for Fiscal Year 2021-22
•Consider Adopting Resolution No. 21-XXX approving
Budget Modification #2122-167 increasing
appropriations and revenues by $1,631,245 and
$495,289, respectively.
Recommendations
Next Steps
●FY 2021-22
●Mid Year Report to Council March 2022
●Third Quarter Report to Council May 2022
Transparency and Engagement
●OpenGov Interactive First Quarter Financial Report
Questions