Cities Index.
FY 23-24 Proposed Biennial Budget -ALL FUNDS_6.10.22

San Pablo City Council
June 21, 2022

Document
FY 23-24 Proposed Biennial Budget -ALL FUNDS_6.10.22
Meeting
June 21, 2022
Body
San Pablo City Council
Original file
854 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/10/2022 15:34
General Funds Special Revenue
Funds Total FY23 to FY24 Delta % Change
59,426,652 52,346,870 6,242,459 58,589,329 (837,323) -1% Transfers In 6,603,429 157,560 6,769,848 6,927,408 323,979 5% 905,546 - 986,448 986,448 80,902 0%
66,935,627 52,504,430 13,998,755 66,503,185 (432,442) -1% 34,329,590 31,962,836 4,984,372 36,947,208 2,617,618 8% Services and Supplies 26,685,184 15,908,586 8,254,438 24,163,024 (2,522,160) -9% Transfers Out
General Funds 542,000 157,560 157,560 (384,440) -71% Other Fund Subsidies 3,816,252 4,056,077 4,056,077 239,825 6% Debt Service 2,245,177 2,713,771 2,713,771 468,594 21% 1,030,000 458,515 602,385 1,060,900 30,900 3%
68,648,203 55,099,789 13,998,755 69,098,540 450,337 1% (1,712,576) (2,595,360) (0) (2,595,360)
Budget Balancing Measures Presented
To Council June 6, 2022:

1. Reduce Services & Supplies ( -7.4% to -10 %) 1,149,440 1,306,182 1,306,182

2. Eliminate Multi-Dept Vehicle Replcmt Fund 500,000 500,000 500,000

3. Reduce Police Dept OT Hours (-10%) 138,581 142,738 142,738

4. Reduce Community Svc PT Hours (-20%) 181,310 186,749 186,749

5. Defer Code Enforcement Move From
PD to CD Dept 366,862 486,556 486,556
2,336,193 2,622,225 2,622,225
Subsequent Budget Adj to Services & Supplies (623,617) (26,869) (26,869) Surplus/(Shortfall) - - - -
Total Revenue Sources
Personnel (including UAL)
CIP
Total Uses of Resources
Surplus/(Shortfall)
From Available Special Revenue Fund Balance
FY 2023-2024 PROPOSED BUDGET SUMMARY

ALL FUNDS

BUDGET SUMMARY
FY 2022-23
Proposed
(Combined)
FY 2023-24 Proposed
Baseline Revenue
1 General Funds Special Revenue
Funds Total FY23 to FY24 Delta % Change
Casino Pilot 2,185,215 2,228,920 - 2,228,920 43,705 2% Casino Revenue 30,500,000 31,500,000 - 31,500,000 1,000,000 3% Fines and Fees 397,250 402,018 - 402,018 4,768 1%
Grants 5,518,236 2,080,309 759,910 2,840,219 (2,678,017) -49% Intergovernmental 1,877,043 250,000 1,659,263 1,909,263 32,220 2% Licenses and Permits 324,585 38,476 295,847 334,323 9,738 3% Miscellaneous Revenue 120,500 - 121,500 121,500 1,000 1% Other Taxes (incl. Franchise Fees) 1,780,000 1,860,300 - 1,860,300 80,300 5% Property Taxes (incl. RPTTF) 2,244,935 1,082,537 1,165,000 2,247,537 2,602 0% Sales Tax (incl. Meas Q/S/Bradley Burns) 5,826,696 5,047,284 1,183,560 6,230,844 404,148 7% Use of Property and Money 1,174,600 1,180,720 - 1,180,720 6,120 1% Utility Users Tax 2,645,000 2,706,000 - 2,706,000 61,000 2% Property Taxes in Lieu of VLF 3,254,890 3,405,592 - 3,405,592 150,702 5% C
harges for Services 1,577,702 564,714 1,057,379 1,622,093 44,391 3% Note Repayment - - - - - 0%
59,426,652 52,346,870 6,242,459 58,589,329 (837,323) -1% General Funds Special Revenue
Funds Total FY23 to FY24 Delta % Change
General Fund 6,061,429 6,769,848 6,769,848 708,419 12% Other Funds:

Fund 120 ARPA 300,000 - - (300,000) -100%
Fund 203 Public Safety 156,000 157,560 157,560 1,560 1% Fund 230 Measure J 86,000 - - (86,000) -100%
Total Other Funds 6,603,429 157,560 157,560
6,603,429 157,560 6,769,848 6,927,408 323,979 5%
General Funds Special Revenue
Funds Total FY23 to FY24 Delta % Change
30,380,178 27,565,836 4,984,372 32,550,208 2,170,030 7% 3,949,412 4,397,000 4,397,000 447,588 11%
34,329,590 31,962,836 4,984,372 36,947,208 2,617,618 8%

PERS UAL
Total
CY Baseline Salary & Benefits wo/UAL
FY 2022-23
Proposed
(Combined)
FY 2023-24 Proposed
Total

TRANSFERS IN
FY 2022-23
Proposed
(Combined)
FY 2023-24 Proposed

BASELINE REVENUE DETAILS
Special Revenue Funds:

Total

PERSONNEL EXPENSE DETAILS
FY 2022-23
Proposed
(Combined)
FY 2023-24 Proposed
2 General Funds Special Revenue
Funds Total FY23 to FY24 Delta % Change
General Funds Special Funds Total
1110 City Council 3,929,740 2,418,710 1,778,112 4,196,822 267,082 7% 1210 City Attorney 112,876 116,264 - 116,264 3,388 3% 1310 City Manager 816,160 824,022 - 824,022 7,862 1% 1320 City Manager-ED 694,630 213,081 392,000 605,081 (89,549) -13% 1741 City Manager-Housing Admin. 51,500 - 53,045 53,045 1,545 3% 1510 City Manager-I.T. 372,063 414,483 - 414,483 42,420 11% 1420 Finance 389,570 358,333 - 358,333 (31,237) -8% 1430 Multi-Dept-Gen. Gov. 3,750,444 3,862,956 - 3,862,956 112,512 3% 1450 Multi-Dept-Debt Serv. 2,331,041 85,864 2,713,771 2,799,635 468,594 20% Multi-Dept-Cap Asset & Equipt 4,485,669 500,000 1,003,467 1,503,467 (2,982,202) -66% Multi-Dept-EBRCS 75,705 77,976 - 77,976 2,271 3% 1755 Development Services 516,030 - 500,130 500,130 (15,900) -3% 2110 Po lice 4,107,534 4,557,378 - 4,557,378 449,844 11% 3310 PW Engineering 300,568 306,895 - 306,895 6,327 2% 3410 PW-Building Maintenance 461,762 525,075 - 525,075 63,313 14% 3510 PW-Environmental Serv. 1,178,353 - 151,500 151,500 (1,026,853) -87% 3610 PW-Street Lighting 821,212 - 852,447 852,447 31,235 4% 3710 PW
-Street Maintenance 535,388 - 551,448 551,448 16,060 3% 5110 CS-YSCP 1,302,636 1,236,356 203,834 1,440,190 137,554 11% 5210 CS-Recreation 399,214 411,193 - 411,193 11,979 3% 5310 CS-Senior Services - - - - - 0%
5410 CS-Paratransit 53,089 - 54,684 54,684 1,595 3% 26,685,184 15,908,586 8,254,438 24,163,024 (2,522,160) -9% General Funds Special Revenue
Funds Total FY23 to FY24 Delta % Change
General Fund 542,000 157,560 157,560 (384,440) -71% Other Funds Subsidies:

Fund 200 Gas Tax 143,960 187,249 187,249 43,289 30% Fund 201 Measure K 693,440 752,112 752,112 58,672 8% Fund 212 Development Services 1,207,813 1,398,460 1,398,460 190,647 16% Fund 237 Street Lighting 1,236,002 1,158,114 1,158,114 (77,888) -6% Fund 255 NPDES Environmental Svcs 535,037 560,142 560,142 25,105 5% Fund 263 Paratransit - - - - 0%
Total Other Funds Subsidies 3,816,252 4,056,077 4,056,077 Debt Service:

Fund 315 LRB-2015A 132,379 132,441 132,441 62 0%
Fund 419 Series 2022 1,303,430 1,774,715 1,774,715 471,285 36% Fund 469 Series 2018 809,368 806,615 806,615 (2,753) 0% Total Debt Service 2,245,177 2,713,771 2,713,771
Total Special Revenue Funds 6,061,429 6,769,848 6,769,848 CIP:
1,030,000 458,515 602,385 1,060,900 30,900 3%
7,633,429 7,228,363 759,945 7,988,308 354,879 5%
Fund 320
Total
% Change
Total

TRANSFERS OUT
FY 2022-23
Proposed
(Combined)
FY 2023-24 Proposed
Special Revenue Funds:

Division Departments FY 2022-23
Proposed
FY 2023-24 Proposed
FY23 to FY24 Delta

SERVICE AND SUPPLIES EXPENSE

DETAILS
FY 2022-23
Proposed
(Combined)
FY 2023-24 Proposed
3 6/10/2022 15:34
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,228,920 - - - - - 2,228,920
31,500,000 - - - - - 31,500,000
402,018 - - - - - 402,018
2,080,309 - - - - 759,910 2,840,219
250,000 - - - - 1,659,263 1,909,263
38,476 - - - - 295,847 334,323
- - - - - 121,500 121,500
1,860,300 - - - - - 1,860,300
1,082,537 - - - - 1,165,000 2,247,537
5,047,284 - - - - 1,183,560 6,230,844
1,180,720 - - - - - 1,180,720
2,706,000 - - - - - 2,706,000
3,405,592 - - - - - 3,405,592
564,714 - - - - 1,057,379 1,622,093
- - - - - - -
52,346,870 - - - - 6,242,459 58,589,329
157,560 1,060,900 132,441 806,615 1,774,715 4,056,077 7,988,308 - - - - - - -
Total Resources 52,504,430 1,060,900 132,441 806,615 1,774,715 10,298,536 66,577,637 Ex
penditures
27,565,836 - - - - 4,984,372 32,550,208
4,397,000 - - - - - 4,397,000
500,000 - - - - - 500,000
2,990,053 - - - - 1,778,112 4,768,165
520,200 - - - - 20,655 540,855
2,818,321 - - - - - 2,818,321
484,831 - -
- - 96,803 581,634
36,941 - - - - 849 37,790
980,341 - - - - 563,895 1,544,236
4,872,112 - 2,122 6,365 6,365 1,605,991 6,492,955
904,007 - - - - 3,600 907,607
357,925 - - - - 43,212 401,137
722,518 - - - - 330,147 1,052,665
47,150,085 - 2,122 6,365 6,365 9,427,636 56,592,573
7,228,363 - - - - 759,945 7,988,308
85,864 130,319 800,250 1,768,350 - 2,784,783
635,477 1,097,403 1,732,880
Total Use of Resources 55,099,789 - 132,441 806,615 1,774,715 11,284,984 69,098,544 (2,595,360) 1,060,900 - - - (986,448) (2,520,908)
Transfers Out
Debt Service
Capital Outlay
Annual Surplus (Shortfall)
Total Expenditures
CM Contingency Account
Community Grants & Spec Events
Dues & Subscriptions
Insurance
Maintenance & Repair
Misc. Expense
Office Expenses, Supplies & Materials
Professional Services
Special Department Expense
Travel & Training
Utilities & Communications
PERS Smoothing-Annual Payment
Utility Users Tax
Property Taxes in Lieu of VLF
Charges for Services
Note Repayment
Total Revenues
Transfers In
Bond Proceeds
Salary and Benefits
Use of Property and Money

SUMMARY OF ACTIVITIES BY FUND
GOVERNMENTAL FUND FY 2023-24 PROPOSED
Casino Pilot
Casino Revenue
Fines and Fees
Grants
Intergovernmental
Licenses and Permits
Miscellaneous Revenue
Other Taxes
Property Taxes
Sales Tax
4 6/10/2022 15:34
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,727 - 472,260 - 475,987
- 927,543 - - - 721,720 - - 1,649,263
- - - - 295,847 - - - 295,847
- - - - - - - - -
- - - - - - - - -
- - - - - - - 845,000 845,000
- - 1,026,000 157,560 - - - - 1,183,560
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - 1,057,379 - - - 1,
057,379
- - - - - - - - -
- 927,543 1,026,000 157,560 1,356,953 721,720 472,260 845,000 5,507,036 - 187,249 752,112 - 1,398,460 - - 1,158,114 3,495,935 - - - - - - - - -
Total Resources - 1,114,792 1,778,112 157,560 2,755,413 721,720 472,260 2,003,114 9,002,971 Expenditures
- 563,343 - - 2,255,283 - - 1,150,668 3,969,294
- - - - - - - - -
- - 1,778,112 - - - - - 1,778,112
- - - - 4,830 - - 1,136 5,966
- - - - - - - - -
- 17,347 - - - - - 54,643 71,990
- - - - - - - - -
203,834 85,131 - - 70,900 - - 155,132 514,997
392,000 407,504 - - 395,000 - - 253,642 1,448,146
- - - - 3,600
- - - 3,600
- 6,456 - - 23,300 - - 3,802 33,558
- 3,183 - - 2,500 - - 321,983 327,666
595,834 1,082,964 1,778,112 - 2,755,413 - - 1,941,006 8,153,329 - - - 157,560 - 602,385 - - 759,945
- - - - - - - - -
1,003,467 31,827 - - - - - 62,109 1,097,403
Total Use of Resources 1,599,301 1,114,791 1,778,112 157,560 2,755,413 602,385 - 2,003,115 10,010,677 (1,599,301) 1 - - (0) 119, 335 472,260 (1) (1,007,706)
2,081,466 - - 40,392 - 122,729 3,744,597 -
482,165 1 - 40,392 (0) 242,064 4,216,857 (1)Estimated Ending Fund Balance Special Department Expense
Travel & Training
Utilities & Communications
Total Expenditures
Transfers Out
Capital Outlay
Annual Surplus (Shortfall)
Estimated Beginning Fund Balance
Charges for Services
Note Repayment
Total Revenues
Professional Services
Transfers In
Bond Proceeds
Salary and Benefits
CM Contingency Account
Community Grants & Spec Events
Dues & Subscriptions
Insurance
Maintenance & Repair
Misc. Expense
Office Expenses, Supplies & Materials
Intergovernmental
Debt Service

SUMMARY OF ACTIVITIES BY FUND
SPECIAL REVENUE FUNDS FY 2023-24 PROPOSED
Casino Pilot
Casino Revenue
Fines and Fees
Grants
Licenses and Permits
Miscellaneous Revenue
Other Taxes
Property Taxes
Sales Tax
Use of Property and Money
Utility Users Tax
Property Taxes in Lieu of VLF
5 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
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
475,987 - - - 283,923 - - - 759,910
1,649,263 - - - 10,000 - - - 1,659,263
295,847 - - - - - - - 295,847
- - - - - 2,500 113,000 6,000 121,500
- - - - - - - - -
845,000 - - 320,000 - - - - 1,165,000
1,
183,560 - - - - - - - 1,183,560
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
1,057,379 - - - - - - - 1,057,379
- - - - - - - - -

5,507,036 - - 320,000 293,923 2,500 113,000 6,000 6,242,459 3,495,935 - - 560,142 - - - - 4,056,077
- - - - - - - - -
Total Resources 9,002,971 - - 880,142 293, 923 2,500 113,000 6,000 10,298,536 Expenditures
3,969,294 - - 730,233 284,845 - - - 4,984,372
- - - - - - - - -
1,778,112 - - - - - - - 1,778,112
5,966 - - 5,364 9,325 - - - 20,655
- - - - - - - - -
71,990 - - - 24,813 - - - 96,803
- - - - 849 - - - 849
514,997 1,591 - 34,674 12,633 - - - 563,895
1,448,146 - 53,045 104,800 - - - - 1,605,991
3,
600 - - - - - - - 3,600
33,558 - - 4,753 4,901 -
- - 43,212
327,666 - - 318 2,163 - - - 330,147
8,153,329 1,591 53,045 880,142 339,529 - - - 9,427,636
759,945 - - - - - - - 759,945
- - - - - - - - -
1,097,403 - - - - - - - 1,097,403
Total Use of Resources 10,010,677 1,591 53,045 880,142 339,529 - - - 11,284,984 (1,007,706) (1,591) (53,045) 0 (45,606) 2,500 113,000 6,000 (986,448) 180,374 8,162,727 - 437,053 2,500 112,000 6,000
178,783 8,109,682 0 391,447 5, 000 225,000 12,000
Total Expenditures
Transfers Out
Debt Service
Capital Outlay
Annual Surplus (Shortfall)
Estimated Beginning Fund Balance
Estimated Ending Fund Balance
Utilities & Communications
Salary and Benefits
CM Contingency Account
Community Grants & Spec Events
Dues & Subscriptions
Insurance
Maintenance & Repair
Misc. Expense
Office Expenses, Supplies & Materials
Professional Services
Special Department Expense
Travel & Training
Sales Tax
Use of Property and Money
Utility Users Tax
Property Taxes in Lieu of VLF
Charges for Services
Note Repayment
Total Revenues
Transfers In
Bond Proceeds
Property Taxes

SUMMARY OF ACTIVITIES BY FUND
SPECIAL REVENUE FUNDS FY 2023-24 PROPOSED (Continued)
Casino Pilot
Casino Revenue
Fines and Fees
Grants
Intergovernmental
Licenses and Permits
Miscellaneous Revenue
Other Taxes
6

← All documents from this meeting