Cities Index.
Attachment 4 - Comparison of Budget vs Actual and Prior Year's Expenditures (for the twelve months ended June 30, 2024)

Foster City City Council
November 4, 2024

Document
Attachment 4 - Comparison of Budget vs Actual and Prior Year's Expenditures (for the twelve months ended June 30, 2024)
Meeting
November 4, 2024
Body
Foster City City Council
Pages
2
Original file
92 KB
Text extracted from the city's file for reading and search. Open the original on fostercity.primegov.com. That file is the official record.

Attachment 4
ACTUAL ACTUAL ACTUAL INCREASE / % OF BUDGET % OF BUDGET FY 2023-24 FY 2022-23 FY 2021-22 DECREASE / % FY 2023-24 FY 2022-23 AMENDED 12 MONTHS 12 MONTHS 12 MONTHS FROM INCREASE 12 MONTHS 12 MONTHS Fund BUDGET ACTUAL $ % AS OF 6/30/2024 AS OF 6/30/2023 AS OF 6/30/2022 PRIO R YEAR (DECREASE) AS OF 6/30/2024 AS OF 6/30/2023 GENERAL FUND (FUNDS 001-003)
DEPARTMENTS:

COUNCIL/BOARD 450,910$ 417,351 $ 33,559 $ 7.4% 417,351 $ 478,280 $ 333,434 $ (60,929) $ (12.7%) 92.6% 91.5% CITY MANAGER (1) 2,220,213$ 1,877,476 $ 342,737 $ 15.4% 1,877,476 $ 1,927,954 $ 1,239,182 $ (50,478) $ (2.6%) 84.6% 92.9% COMMUNICATIONS/CITY CLERK (1) 1,257,736$ 1,045,916 $ 211,820 $ 16.8% 1,045,916 $ 857,121 $ 746,518 $ 188,795 $ 22.0% 83.2% 82.2% CITY ATTORNEY 656,365$ 399,024 $ 257,341 $ 39.2% 399,024 $ 768,964 $ 615,479 $ (369,940) $ (48.1%) 60.8% 90.7% HUMAN RESOURCES (1) 1,285,855$ 949,054 $ 336,801 $ 26.2% 949,054 $ 299,547 $ 708,315 $ 649,507 $ 216.8% 73.8% 40.3% FINANCIAL SERVICES 1,842,002$ 1,689,836 $ 152,166 $ 8.3% 1,689,836 $ 1,120,816 $ 883,055 $ 569,020 $ 50.8% 91.7% 84.4% PARKS & RECREATION (1) 8,123,729$ 7,179,598 $ 944,131 $ 11.6% 7,179,598 $ 7,639,499 $ 7,622,549 $ (459,901) $ (6.0%) 88.4% 89.9% POLICE (1) 18,006,083$ 16,198,774 $ 1,807,309 $ 10.0% 16,198,774 $ 15,134,593 $ 14,969,116 $ 1,064,181 $ 7.0% 90.0% 90.0% FIRE 11,818,947$ 11,798,445 $ 20,502 $ 0.2% 11,798,445 $ 11,352,653 $ 10,861,609 $ 445,792 $ 3.9% 99.8% 99.4% COMMUNITY DEVELOPMENT (1) 4,871,051$ 4,116,953 $ 754,098 $ 15.5% 4,116,953 $ 3,262,087 $ 2,947,704 $ 854,866 $ 26.2% 84.5% 82.2% PUBLIC WORKS (1) 4,779,845$ 3,535,576 $ 1,244,269 $ 26.0% 3,535,576 $ 2,835,722 $ 2,395,200 $ 699,854 $ 24.7% 74.0% 65.7% LIBRARY 538,360$ 538,360 $ - $ 0.0% 538,360 $ 503,744 $ 547,618 $ 34,616 $ 6.9% 100.0% 100.0% 001 SUBTOTAL (1) 55,851,096$ 49,746,363 $ 6,104,733 $ 10.9% 49,746,363 $ 46,180,980 $ 43,869,779 $ 3,565,383 $ 7.7% 89.1% 88.7% 002 PROPERTY TAX ADMINISTRATION 369,609$ 262,410 $ 107,199 $ 29.0% 262,410 $ 336,008 $ 305,462 $ (73,598) $ (21.9%) 71.0% 99.1% 003 SPECIAL RECREATION 3,257,772$ 2,942,453 $ 315,319 $ 9.7% 2,942,453 $ 1,903,492 $ 1,483,751 $ 1,038,961 $ 54.6% 90.3% 88.7% 59,478,477$ 52,951,226 $ 6,527,251 $ 11.0% 52,951,226$ 48,420,480 $ 45,658,992 $ 4,530,746 $ 9.4% 89.0% 88.7% 005 GENERAL FUND - COMMUNITY BENEFITS PROGRAM 382,567$ 155,668 $ 226,899 $ 59.3% 155,668 $ 115,287 $ 258,357 $ 40,381 $ 35.0% 40.7% 21.3% 006 GENERAL FUND - DARE 38,366$ - $ 38,366$ 100.0% - $ - $ - $ - $ - - - 007 GENERAL FUND - SOLAR INCENTIVE GRANT PROGRAM 25,000$ 19,000 $ 6,000 $ 24.0% 19,000 $ 9,000 $ 12,000$ 10,000 $ 111.1% 76.0% 36.0% 008 GENERAL FUND - RENTAL ASSISTANCE -$ - $ - $ - - $ - $ - $ - $ - - - 009 GENERAL FUND - ASSET SEIZURE 4,097$ - $ 4,097$ 100.0% - $ - $ - $ - $ - - - 010 GENERAL FUND - PENSION STABILIZATION FUND -$ - $ - $ - - $ - $ - $ - $ - - - 011 GENERAL FUND - FACILITIES REPLACEMENT -$ - $ - $ - - $ - $ - $ - $ - - - 012 SUSTAINABLE FOSTER CITY 120,945$ 5,932 $ 115,013 $ 95.1% 5,932 $ 16,566$ 94,293 $ (10,634) $ (64.2%) 4.9% 12.5% TOTAL ALL GENERAL FUND (FUNDS 001-011) 60,049,452$ 53,131,826 $ 6,917,626 $ 11.5% 53,131,826 $ 48,561,333 $ 46,023,642 $ 4,570,493 $ 9.4% 88.5% 87.8%

SPECIAL REVENUE FUNDS
101 TRAFFIC SAFETY 60,000$ 43,605 $ 16,395 $ 27.3% 43,605 $ 43,633 $ 77,042 $ (28) $ (0.1%) 72.7% 72.7% 102 MEASURE "A" 4,253,589$ 657,846 $ 3,595,743 $ 84.5% 657,846 $ 416,679 $ - $ 241,167$ 57.9% 15.5% 27.8% 103 GAS TAX 935,549$ 935,549 $ - $ 0.0% 935,549 $ 1,117,277$ 631,789 $ (181,728) $ (16.3%) 100.0% 79.4% 104 PARK-IN-LIEU FUND 745,435$ - $ 745,435$ 100.0% - $ - $ - $ - $ - - - 105 MEASURE "M" 100,000$ 100,000 $ - $ 0.0% 100,000 $ 119,300 $ - $ (19,300)$ (16.2%) 100.0% 54.4% 108 SLESF/COPS GRANT 100,000$ 186,159 $ (86,159) $ (86.2%) 186,159 $ 165,271 $ 161,285 $ 20,888 $ 12.6% 186.2% 100.0% 114 CALOPPS 783,050$ 336,379 $ 446,671 $ 57.0% 336,379 $ 456,664 $ 465,721 $ (120,285) $ (26.3%) 43.0% 93.1% 116 FOSTER CITY FOUNDATION 136,250$ 44,288 $ 91,962 $ 67.5% 44,288 $ 26,820 $ 23,326 $ 17,468 $ 65.1% 32.5% 24.1% 119 SB 1 ROAD MAINTENANCE AND REHAB 455,058$ - $ 455,058$ 100.0% - $ 1,293,791$ 244,002 $ (1,293,791)$ (100.0%) - 95.9% 122 HOUSING SUCCESSOR-LMIHF 278,080$ 133,801 $ 144,279 $ 51.9% 133,801 $ 70,922 $ 76,524 $ 62,879 $ 88.7% 48.1% 52.0% 124 FC AFFORDABLE HOUSING FUND 235,000$ 43,717 $ 191,283 $ 81.4% 43,717 $ 123,638$ 335,366 $ (79,921) $ (64.6%) 18.6% 22.7% 128 GENERAL PLAN MAINTENANCE 167,400$ 128,968 $ 38,432 $ 23.0% 128,968 $ 620,255 $ 233,672 $ (491,287) $ (79.2%) 77.0% 73.6% 129 CONSTRUCTION AND DEMO RECYCLING 309,750$ 105,716 $ 204,034 $ 65.9% 105,716 $ 63,630 $ 43,704 $ 42,086 $ 66.1% 34.1% 20.1% 130 TECHNOLOGY MAINTENANCE 105,485$ 91,081 $ 14,404 $ 13.7% 91,081 $ 81,180 $ 108,228$ 9,901 $ 12.2% 86.3% 77.0% 131 SB 1186 1,300$ 1,300 $ - $ 0.0% 1,300 $ - $ - $ 1,300$ - 100.0% - 132 SMIP FEE 500$ - $ 500 $ 100.0% - $ - $ - $ - $ - - - 133 CRV GRANT FUND 21,919$ 11,993 $ 9,926 $ 45.3% 11,993 $ 3,756 $ 11,781$ 8,237 $ 219.3% 54.7% 26.8% 134 CURBSIDE RECLYCLING 25,000$ - $ 25,000$ 100.0% - $ - $ - $ - $ - - - 135 GREEN BUILDING FEE 500$ - $ 500 $ 100.0% - $ - $ - $ - $ - - - 136 MEASURE W 815,215 $ 240,215 $ 575,000 $ 70.5% 240,215 $ 258,285 $ 1,500 $ (18,070) $ (7.0%) 29.5% 54.4% 137 COMMERCIAL LINKAGE GEE 10,000 $ 9,909 $ 91 $ 0.9% 9,909 $ - $ - $ 9,909$ - 99.1% - 138 TENANT RELOCATION ASSISTANCE 51,640 $ - $ 51,640$ 100.0% - $ - $ - $ - $ - - - 139 WORKFORCE HOUSING 386,187 $ 790,965 $ (404,778) $ (104.8%) 790,965 $ 165,081 $ 13,980 $ 625,884 $ 379.1% 204.8% 50.2% 140 EQUIPMENT REPLACEMENT-WORKFORCE HOUSING - $ - $ - $ - - $ - $ - $ - $ - - - 141 SB 1383 IMPLEMENTATION 122,694 $ 42,495 $ 80,199 $ 65.4% 42,495 $ 17,399 $ - $ 25,096$ 144.2% 34.6% 36.8% 142 PARK FACILITIES IMPACT FEE - $ - $ - $ - - $ - $ - $ - $ - - - 143 PUBLIC SAFETY IMPACT FEE - $ - $ - $ - - $ - $ - $ - $ - - - 144 TRANSPORTATION IMPACT FEE - $ - $ - $ - - $ - $ - $ - $ - - - TOTAL SPECIAL REVENUE FUNDS 10, 099,601$ 3,903,986 $ 6,195,615 $ 61.3% 3,903,986$ 5,043,581 $ 2,427,920 $ (1,139,595) $ (22.6%) 38.7% 52.0%

SAVINGS (EXCESS) FROM

AMENDED BUDGET
TOTAL GENERAL FUND (FUNDS 001-003)
FY 2023-24
COMPARISON OF BUDGET VS. PROJECTED ACTUAL EXPENDITURES

BUDGET VS ACTUAL & CURRENT VS PRIOR
FOR THE TWELVE MONTHS ENDED JUNE 30, 2024

Page 1 of 2 ends

Attachment 4
ACTUAL ACTUAL ACTUAL INCREASE / % OF BUDGET % OF BUDGET FY 2023-24 FY 2022-23 FY 2021-22 DECREASE / % FY 2023-24 FY 2022-23 AMENDED 12 MONTHS 12 MONTHS 12 MONTHS FROM INCREASE 12 MONTHS 12 MONTHS Fund BUDGET ACTUAL $ % AS OF 6/30/2024 AS OF 6/30/2023 AS OF 6/30/2022 PRIO R YEAR (DECREASE) AS OF 6/30/2024 AS OF 6/30/2023

SAVINGS (EXCESS) FROM

AMENDED BUDGET
FY 2023-24
COMPARISON OF BUDGET VS. PROJECTED ACTUAL EXPENDITURES

BUDGET VS ACTUAL & CURRENT VS PRIOR
FOR THE TWELVE MONTHS ENDED JUNE 30, 2024
230 LEVEE DEBT SERVICE FUND - 2020 GO BONDS 5,349,188 $ 5,348,588 $ 601 $ 0.0% 5,348,588 $ 6,378,388 $ 6,489,788 $ (1,029,801) $ (16.1%) 100.0% 100.0% 231 LEVEE DEBT SERVICE FUND - 2023 GO BONDS 109,513 $ 109,012 $ 501 $ 0.5% 109,012 $ - $ - $ 109,012$ - 99.5% -

CAPITAL PROJECTS FUNDS
301 CIP PROJECTS-CITY 4,816,575$ 3,727,290 $ 1,089,285 $ 22.6% 3,727,290 $ 2,980,720 $ 335,863 $ 746,570 $ 25.0% 77.4% 52.4% 326

CAPITAL ASSET ACQUISITION AND REPLACEMENT
FUND (2) -$ - $ - $ - - $ 7,015,009$ - $ (7,015,009)$ (100.0%) - 100.0% 327 LEVEE PROJECT FUND 9,438,912$ 7,320,333 $ 2,118,579 $ 22.4% 7,320,333 $ 22,972,497$ 27,541,707 $ (15,652,164) $ (68.1%) 77.6% 83.5% TOTAL CAPITAL PROJECTS FUNDS 14, 255,487$ 11,047,623 $ 3,207,864 $ 22.5% 11,047,623$ 32,968,226 $ 27,877,570 $ (21,920,603) $ (66.5%) 77.5% 82.0%

ENTERPRISE FUNDS
401 WATER REVENUE 18,030,506$ 17,478,788 $ - $ 0.0% 17,478,788 $ 13,223,080 $ 13,741,385 $ 4,255,708 $ 32.2% 96.9% 76.8% 405 CIP-WATER -$ 548,480$ (548,480) $ - 548,480 $ 844,506 $ 828,582 $ (296,026) $ (35.1%) - 26.2% 408 WATER EQUIPMENT REPLACEMENT 249,000$ 56,695 $ 192,305 $ 77.2% 56,695 $ 18,277 $ 18,987 $ 38,418 $ 210.2% 22.8% 5.3% 409 WATER CONNECTION FEES 1,100,000$ 1,100,000 $ - $ 0.0% 1,100,000 $ - $ - $ 1,100,000$ - 100.0% - 451 WASTEWATER REVENUE 9,981,803$ 24,341,797$ (14,359,994) $ (143.9%) 24,341,797 $ 6,382,524 $ 7,525,571 $ 17,959,273 $ 281.4% 243.9% 67.5% 453 WASTEWATER RATE STABILIZATION - $ - $ - $ - - $ - $ - $ - $ - - - 454 SM-FC PUBLIC FINANCING AUTHORITY LOAN 1,863,716 $ 1,248,866 $ 614,850 $ 33.0% 1,248,866 $ 1,278,741 $ 1,307,137 $ (29,875) $ (2.3%) 67.0% 68.6% 455 CIP-WASTEWATER 11,729,789$ 1,793,328 $ 9,936,461 $ 84.7% 1,793,328 $ 1,080,134 $ 1,155,260 $ 713,194 $ 66.0% 15.3% 27.8% 456 WASTEWATER PLANT EXPANSION - $ - $ - $ - - $ - $ - $ - $ - - - 458 WASTEWATER EQUIPMENT REPLACEMENT 423,501$ 184,367 $ 239,134 $ 56.5% 184,367 $ 152,317 $ 138,024 $ 32,050 $ 21.0% 43.5% 42.3% 459 WASTEWATER NOTES/WIFIA LOAN/SRF LOAN 3,144,950$ 2,127,502 $ 1,017,448 $ 32.4% 2,127,502 $ 216,894 $ 432,479 $ 1,910,608 $ 880.9% 67.6% 6.9% 460 WASTEWATER CONNECTION FEES -$ - $ - $ - - $ - $ - $ - $ - - - 461 STATE REVOLVING LOAN FUND -$ - $ - $ - - $ - $ - $ - $ - - - TOTAL ENTERPRISE FUNDS 46, 523,265$ 48,879,823 $ (2,908,276) $ (6.3%) 48,879,823 $ 23,196,473 $ 25,147,425 $ 25,683,350 $ 110.7% 105.1% 58.8%

INTERNAL SERVICE FUNDS
501 VEHICLE RENTAL FUND 2,134,551$ 1,548,694 $ 585,857 $ 27.4% 1,548,694 $ 1,141,399 $ 1,351,299 $ 407,295 $ 35.7% 72.6% 51.1% 502 EQUIPMENT REPLACEMENT FUND 529,500$ 298,504 $ 230,996 $ 43.6% 298,504 $ 309,159 $ 332,718 $ (10,655) $ (3.4%) 56.4% 82.9% 503 SELF INSURANCE FUND 1,532,807$ 1,471,459 $ 61,348 $ 4.0% 1,471,459 $ 1,235,517 $ 871,694 $ 235,942 $ 19.1% 96.0% 92.0% 504 INFORMATION TECHNOLOGY 2,892,584$ 2,160,517 $ 732,067 $ 25.3% 2,160,517 $ 1,899,294 $ 1,599,843 $ 261,223 $ 13.8% 74.7% 72.4% 505 BUILDING MAINTENANCE 2,974,968$ 2,605,014 $ 369,954 $ 12.4% 2,605,014 $ 2,249,880 $ 2,313,246 $ 355,134 $ 15.8% 87.6% 60.0% 507 LONGEVITY RECOGNITION PLAN 238,420$ 209,918 $ 28,503 $ 12.0% 209,918 $ 190,533 $ 188,448 $ 19,385 $ 10.2% 88.0% 79.9% 508 PEMHCA FUND 245,843$ 204,288 $ 41,555 $ 16.9% 204,288 $ 193,246 $ 182,660 $ 11,042 $ 5.7% 83.1% 84.1% 509 COMPENSATED ABSENCES FUND 500,719$ 132,397 $ 368,322 $ 73.6% 132,397 $ 477,994 $ 312,716 $ (345,597) $ (72.3%) 26.4% 85.2% TOTAL INTERNAL SERVICE FUNDS 11, 049,392$ 8,630,791 $ 2,418,601 $ 21.9% 8,630,791$ 7,697,022 $ 7,152,624 $ 933,769 $ 12.1% 78.1% 67.8%

FIDUCIARY FUND
604 SUCESSOR ANGENCY 508,051 $ 291,718 $ 216,333 $ 42.6% 291,718 $ 294,076 $ 294,482 $ (2,358) $ (0.8%) 57.4% 87.5% 607 TOURISM ASSESSMENT - $ - $ - $ - - $ - $ 31,430$ - $ - - - 608 SMC FIRE FEES 320,000 $ 117,640 $ 202,360 $ 63.2% 117,640 $ 131,684 $ 148,566 $ (14,044) $ (10.7%) 36.8% 59.6% TOTAL CITY / EMID FUNDS 148,263,949$ 131,461,006 $ 16,251,225 $ 11.0% 131,461,006 $ 124,270,783 $ 115,593,447 $ 7,190,223 $ 5.8% 88.7% 76.2% 1 2 The City acquired 22 units of workforce housing in August 2022 Notes and Explanation of Variances:

Due to the many unfilled positions, the General Fund reaped a signi ficant amount ($3.9 million) of personnel related savings. Similarly, service and supplies spending were also curtailed during the fiscal year.

Page 2 of 2 ends
← All documents from this meeting