Cities Index.
Attachment C - FY22-23 Proposed Biennial Operating Budget

San Pablo City Council
June 6, 2022

Document
Attachment C - FY22-23 Proposed Biennial Operating Budget
Meeting
June 6, 2022
Body
San Pablo City Council
Original file
788 KB
Text extracted from the city's file for reading and search. Open the original on sanpablo.legistar1.com. That file is the official record.

6/1/2022 10:09
General Funds Special Revenue
Fu
nds Total FY22 to FY23 Delta % Change
50,111,336 48,437,658 9,840,192 58,277,850 8,166,514 16% Transfers In 2,908,195 542,000 5,993,966 6,535,966 3,627,771 125% - - 901,535 901,535 901,535 0%
53,019,531 48,979,658 16,735,693 65,715,351 12,695,820 24% 32,992,024 29,410,422 4,482,664 33,893,086 901,062 3% Services and Supplies 16,119,314 15,466,303 11,126,189 26,592,492 10,473,178 65% Transfers Out
General Funds 145,139 542,000 542,000 396,861 0%
Other Fund Subsidies 2,763,056 3,748,789 3,748,789 985,733 0% Debt Service 2,245,177 2,245,177 2,245,177 0% 1,000,000 445,160 584,840 1,030,000 30,000 3% 53,019,531 51,315,851 16,735,693 68,051,544 15,032,011 28% - (2,336,193) - (2,336,193)
Budget Balancing Measures
Presented To Council 2,336,193 2,336,193
Surplus/(Shortfall) - - - -
General Funds
Special Revenue
Funds Total FY22 to FY23 Delta % Change
Casino Pilot 2,100,567 2,185,215 - 2,185,215 84,648 4% Casino Revenue 26,596,265 29,351,198 - 29,351,198 2,754,933 10% Fines and Fees 393,322 397,250 - 397,250 3,928 1%
Grants 1,154,171 1,069,232 4,449,004 5,518,236 4,364,065 378% Intergovernmental 1,724,492 250,000 1,627,043 1,877,043 152,551 9% Licenses and Permits 317,932 37,355 287,230 324,585 6,653 2% Miscellaneous Revenue 99,954 - 120,500 120,500 20,546 21% Other Taxes (incl. Franchise Fees) 1,637,756 1,780,000 - 1,780,000 142,244 9% Property Taxes (incl. RPTTF) 2,774,706 1,071,103 1,173,832 2,244,935 (529,771) -19% Sales Tax (incl. Meas Q/S/Bradley Burns) 4,673,158 4,670,696 1,156,000 5,826,696 1,153,538 25% Use of Property and Money 1,296,764 1,174,600 - 1,174,600 (122,164) -9% Utility Users Tax 2,636,725 2,645,000 - 2,645,000 8,275 0% Property Taxes in Lieu of VLF 3,026,173 3,254,890 - 3,254,890 228,717 8% C
harges for Services 1,542,398 551,119 1,026,583 1,577,702 35,304 2% Note Repayment 136,956 - - - (136,956) -100%
50,111,336 48,437,658 9,840,192 58,277,850 8,166,511 16% General Funds Special Revenue
Funds Total FY22 to FY23 Delta % Change
General Fund 2,763,056 5,993,966 5,993,966 3,230,910 117% Other Funds:

Fund 120 ARPA 300,000 300,000 300,000 0%
Fund 203 Public Safety 145,139 156,000 156,000 10,861 7% Fund 230 Measure J 86,000 86,000 86,000 0%
2,908,195 542,000 5,993,966 6,535,966 3,627,771 125% FY 2022-2023 PROPOSED BUDGET SUMMARY
FY 2021-22
Adopted
(Combined)
FY 2022-23 Proposed
Baseline Revenue

ALL FUNDS

BUDGET SUMMARY
FY 2021-22
Adopted
(Combined)
FY 2022-23 Proposed
Total
From Available Special Revenue Fund Balance
Total Revenue Sources
Personnel (including UAL)
CIP
Total Uses of Resources
Surplus/(Shortfall)

BASELINE REVENUE DETAILS

TRANSFERS IN
FY 2021-22
Adopted
(Combined)
FY 2022-23 Proposed
Special Revenue Funds:

Total
1 General Funds Special Revenue
Funds Total FY22 to FY23 Delta % Change
29,495,324 25,461,010 4,482,664 29,943,674 448,350 2% 3,496,700 3,949,412 3,949,412 452,712 13% 32,992,024 29,410,422 4,482,664 33,893,086 901,062 3% General Funds Special Revenue
Funds Total FY22 to FY23 Delta % Change
General Funds Special Funds Total
1110 City Council 3,548,336 2,236,300 1,693,440 3,929,740 381,404 11% 1210 City Attorney 99,100 112,876 - 112,876 13,776 14% 1310 City Manager 467,800 816,160 - 816,160 348,360 74% 1320 City Manager-ED 143,320 211,630 483,000 694,630 551,310 385% 1741 City Manager-Housing Admin. 50,000 - 51,500 51,500 1,500 3% 1510 City Manager-I.T. 361,779 372,063 - 372,063 10,284 3% 1420 Finance 363,203 389,570 - 389,570 26,367 7%
1430 Multi-Dept-Gen. Gov. 2,028,851 3,657,752 - 3,657,752 1,628,901 80% 1450 Multi-Dept-Debt Serv. 1,803,415 85,864 2,245,177 2,331,041 527,626 29% Multi-Dept-Cap Asset & Equipt - 1,035,669 3,450,000 4,485,669 4,485,669 0% Multi-Dept-EBRCS - 75,705 - 75,705 75,705 0%
1755 Development Services 394,830 - 516,030 516,030 121,200 31% 2110 Po lice 3,530,382 4,107,534 - 4,107,534 577,152 16% 3310 PW Engineering 157,824 300,568 - 300,568 142,744 90% 3410 PW-Building Maintenance 404,408 461,762 - 461,762 57,354 14% 3510 PW-Environmental Serv. 101,410 - 1,178,353 1,178,353 1,076,943 1062% 3610 PW-Street Lighting 726,482 - 821,212 821,212 94,730 13% 3710 PW
-Street Maintenance 462,741 - 535,388 535,388 72,647 16% 5110 CS-YSCP 845,026 1,203,636 99,000 1,302,636 457,610 54% 5210 CS-Recreation 559,590 399,214 - 399,214 (160,376) -29% 5310 CS-Senior Services - - - - - 0%
5410 CS-Paratransit 70,817 - 53,089 53,089 (17,728) -25% 16,119,314 15,466,303 11,126,189 26,592,492 10,473,178 65% General Funds Special Revenue
Funds Total FY22 to FY23 Delta % Change
General Fund 145,139 542,000 542,000 396,861 273%
Other Funds Subsidies:

Fund 200 Gas Tax 1,061,333 135,163 135,163 (926,170) 0% Fund 201 Measure K 693,440 693,440 693,440 0%
Fund 212 Development Services 836,720 1,174,748 1,174,748 338,028 0% Fund 237 Street Lighting 518,920 1,220,200 1,220,200 701,280 0% Fund 255 NPDES Environmental Svcs 240,012 525,238 525,238 285,226 0% Fund 263 Paratransit 106,071 - (106,071)
Total Other Funds Subsidies 2,763,056 3,748,789 3,748,789 Debt Service:

Fund 315 LRB-2015A 921,838 132,379 132,379 (789,459) -86% Fund 419 Series 2022 - 1,303,430 1,303,430 1,303,430 0% Fund 469 Series 2018 808,213 809,368 809,368 1,155 0%
Total Debt Service 1,730,051 2,245,177 2,245,177 Total Special Revenue Funds 4,493,107 5,993,966 5,993,966 CIP:
1,000,000 445,160 584,840 1,030,000 30,000 3% 5,638,246 6,439,126 1,126,840 7,023,966 1,927,720 34% FY 2022-23 Proposed

PERSONNEL EXPENSE DETAILS
FY 2021-22
Adopted
(Combined)
FY 2022-23 Proposed
CY Baseline Salary & Benefits wo/UAL

PERS UAL
Total

SERVICE AND SUPPLIES EXPENSE

DETAILS
FY 2022-23 Proposed
Division Departments FY 2021-22
Adopted
FY 2022-23 Proposed
FY22 to F23 Delta % Change
FY 2021-22
Adopted
(Combined)
FY 2021-22
Adopted
(Combined)
Special Revenue Funds:

Fund 320
Total
Total

TRANSFERS OUT
2 6/1/2022 10:09
General Fund Public Works
Construction
2015 Lease Revenue
Bonds
2018 JPFA Lease
Revenue Bonds 2022 Revenue Bonds Special Revenue
Funds
Total Governmental
Funds
Revenues
2,185,215 - - - - - 2,185,215
29,351,198 - - - - - 29,351,198
397,250 - - - - - 397,250
1,069,232 - - - - 4,449,004 5,518,236
250,000 - - - - 1,627,043 1,877,043
37,355 - - - - 287,230 324,585
- - - - - 120,500 120,500
1,780,000 - - - - - 1,780,000
1,071,103 - - - - 1,173,832 2,244,935
4,670,696 - - - - 1,156,000 5,826,696
1,174,600 - - - - - 1,174,600
2,645,000 - - - - - 2,645,000
3,254,890 - - - - - 3,254,890
551,119 - - - - 1,026,583 1,577,702
- - - - - - -
48,437,658 - - - - 9,840,192 58,277,850
542,000 1,030,000 132,379 809,368 1,303,430 3,748,789 7,565,966 - - - - - - -
Total Resources 48,979,658 1,030,000 132,379 809,368 1,303,430 13,588,981 65,843,816 Ex
penditures
25,461,010 - - - - 4,482,664 29,943,674
3,949,412 - - - - - 3,949,412
500,000 - - - - - 500,000
2,774,102 - - - - 1,693,440 4,467,542
474,832 - - - - 19,805 494,637
2,736,235 - - - - - 2,736,235
378,018 - -
- - 93,983 472,001
35,864 - - - - 824 36,688
918,407 - - - - 478,699 1,397,106
5,197,445 - 2,060 6,180 6,180 1,672,325 6,884,190
665,055 - - - - 5,000 670,055
367,419 - - - - 55,132 422,551
701,530 - - - - 320,604 1,022,134
44,159,329 - 2,060 6,180 6,180 8,822,476 52,996,225
6,439,126 - - - 1,126,840 7,565,966
85,864 - 130,319 803,188 1,297,250 - 2,316,621
631,531 - 4,541,200 5,172,731
Total Use of Resources 51,315,850 - 132,379 809,368 1,303,430 14,490,516 68,051,543 (2,336,192) 1,030,000 - - - (901,535) (2,207,727) Annual Surplus (Shortfall) Transfers Out
Debt Service
Capital Outlay
Salary and Benefits
PERS Smoothing-Annual Payment
CM Contingency Account
Community Grants & Spec Events
Dues & Subscriptions
Insurance
Maintenance & Repair
Misc. Expense
Office Expenses, Supplies & Materials
Total Expenditures
Professional Services
Special Department Expense
Travel & Training
Utilities & Communications
Note Repayment
Transfers In
Bond Proceeds
Total Revenues
Sales Tax
Use of Property and Money
Utility Users Tax
Property Taxes in Lieu of VLF
Charges for Services
Intergovernmental
Licenses and Permits
Miscellaneous Revenue
Other Taxes
Property Taxes

SUMMARY OF ACTIVITIES BY FUND
GOVERNMENTAL FUND FY 2022-23 PROPOSED
Casino Pilot
Casino Revenue
Fines and Fees
Grants
3 6/1/2022 10:09
ARPA (120) Gas Tax (200) Measure K (201) Public Safety (203) Development Services (212) RMRA (221) Measure J (230) Street Lighting (237) Total (Continue on Pg 2)
Revenues
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
3,706,733 - - - 3,618 - 463,000 - 4,173,351
- 909,474 - - - 707,569 - - 1,617,043
- - - - 287,230 - - - 287,230
- - - - - - - - -
- - - - - - - - -
- - - - - - - 843,832 843,832
- - 1,000,000 156,000 - - - - 1,156,000
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - 1,026,583 - - - 1,
026,583
- - - - - - - - -
3,706,733 909,474 1,000,000 156,000 1,317,431 707,569 463,000 843,832 9,104,039 - 135,163 693,440 - 1,174,748 - - 1,220,200 3,223,551 - - - - - - - - -
Total Resources 3,706,733 1,044,637 1,693,440 156,000 2,492,179 707,569 463,000 2,064,032 12,327,590 Expenditures
- 518,915 - - 1,976,148 - - 1,050,934 3,545,997
- - - - - - - - -
- - 1,693,440 - - - - - 1,693,440
- - - - 4,830 - - 1,103 5,933
- - - - - - - - -
- 16,842 - - - - - 53,051 69,893
- - - - - - - - -
99,000 82,652 - - 74,900 - - 144,272 400,824
483,000 395,635 - - 395,000 - - 246,190 1,519,825
- - - - 5,000
- - - 5,000
- 6,269 - - 33,800 - - 3,691 43,760
- 3,090 - - 2,500 - - 312,605 318,195
582,000 1,023,403 1,693,440 - 2,492,179 - - 1,811,845 7,602,867 300,000 - - 156,000 - 584,840 86,000 - 1,126,840
- - - - - - - - -
4,450,000 30,900 - - - - 60,300 4,541,200
Total Use of Resources 5,332,000 1,054,303 1,693,440 156,000 2,492,179 584,840 86,000 1,872,145 13,270,907 (1,625,267) (9,666) - - (0) 122, 729 377,000 191,887 (943,317) 3,706,733 9,666 - 40,392 - - 3,367,597 (191,887)
2,081,466 0 - 40,392 (0) 122,729 3,744,597 0
Use of Property and Money

SUMMARY OF ACTIVITIES BY FUND
SPECIAL REVENUE FUNDS FY 2022-23 PROPOSED
Casino Pilot
Casino Revenue
Fines and Fees
Grants
Intergovernmental
Licenses and Permits
Miscellaneous Revenue
Other Taxes
Property Taxes
Sales Tax
CM Contingency Account
Utility Users Tax
Property Taxes in Lieu of VLF
Charges for Services
Note Repayment
Total Revenues
Transfers In
Bond Proceeds
Salary and Benefits
Community Grants & Spec Events
Dues & Subscriptions
Insurance
Maintenance & Repair
Misc. Expense
Office Expenses, Supplies & Materials
Professional Services
Special Department Expense
Travel & Training
Utilities & Communications
Total Expenditures
Transfers Out
Capital Outlay
Annual Surplus (Shortfall)
Estimated Beginning Fund Balance
Estimated Ending Fund Balance
Debt Service
4 Total
(From Page 1) Dump Voucher (241) Low Mod Inc Housing
(250)
Environmental
Services (255)
Paratransit Measure C
(263) Senior Nutrition (730) Senior Bingo (733) Davis Park Bingo (738)
Total Special Revenue
Funds
Revenues
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
4,173,351 - - - 275,653 - - - 4,449,004
1,617,043 - - - 10,000 - - - 1,627,043
287,230 - - - - - - - 287,230
- - - - - 2,500 112,000 6,000 120,500
- - - - - - - - -
843,832 - - 330,000 - - - - 1,173,832
1,
156,000 - - - - - - - 1,156,000
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
1,026,583 - - - - - - - 1,026,583
- - - - - - - -
9,
104,039 - - 330,000 285,653 2,500 112,000 6,000 9,840,192 3,223,551 - - 525,238 - - - - 3,748,789
- - - - - - - - -
Total Resources 12,327,590 - - 855,238 285, 653 2,500 112,000 6,000 13,588,981 Expenditures
3,545,997 - - 678,429 258,238 - - - 4,482,664
- - - - - - - - -
1,693,440 - - - - - - - 1,693,440
5,933 - - 4,820 9,052 - - - 19,805
- - - - - - - - -
69,893 - - - 24,090 - - - 93,983
- - - - 824 - - - 824
400,824 1,545 - 64,065 12,265 - - - 478,699
1,519,825 - 51,500 101,000 - - - - 1,672,325
5,000 - - - - - - - 5,000
43,760 - - 6,614 4,758 - -
- 55,132
318,195 - - 309 2,100 - - - 320,604
7,602,867 1,545 51,500 855,238 311,327 - - - 8,822,476
1,126,840 - - - - - - - 1,126,840
- - - - - - - - -
4,541,200 - - - - - - - 4,541,200
Total Use of Resources 13,270,907 1,545 51,500 855,238 311,327 - - - 14,490,516 (943,317) (1,545) (51,500) 0 (25,674) 2,500 112,000 6,000 (901,535) 181,919 8,214, 227 - 462,727 - - -
180,374 8,162,727 0 437,053 2,500 112,000 6,000
Estimated Beginning Fund Balance
Estimated Ending Fund Balance
Licenses and Permits

SUMMARY OF ACTIVITIES BY FUND
SPECIAL REVENUE FUNDS FY 2022-23 PROPOSED (Continued)
Casino Pilot
Casino Revenue
Fines and Fees
Grants
Intergovernmental
Note Repayment
Total Revenues
CM Contingency Account
Community Grants & Spec Events
Sales Tax
Use of Property and Money
Utility Users Tax
Property Taxes in Lieu of VLF
Charges for Services
Dues & Subscriptions
Insurance
Maintenance & Repair
Debt Service
Professional Services
Bond Proceeds
Salary and Benefits
Misc. Expense
Office Expenses, Supplies & Materials
Transfers In
Miscellaneous Revenue
Other Taxes
Property Taxes
Capital Outlay
Annual Surplus (Shortfall)
Special Department Expense
Travel & Training
Utilities & Communications
Total Expenditures
Transfers Out
5 6/1/2022 10:09
(2,336,193)$
Reduce Services & Supplies (-7.4% to -10%) 1,149,440
500,000
138,581
Reduce Community Service Part-Time Hours (-20%) 181,310 366,862
-$
Defer Code Enforcement Move From PD to CD Dept.

Surplus/(Shortfall)
Reduce Police Department Overtime Hours (-10%)
FY 2022-2023 PROPOSED BUDGET BALANCING MEASURES
Budget Balancing Measures
Surplus/(Shortfall)
Eliminate Multi-Dept. Vehicle Replacement Funding
Reduction Amount
6

← All documents from this meeting