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 6 MONTHS 6 MONTHS 6 MONTHS FROM INCREASE 6 MONTHS 6 MONTHS Fund BUDGET PROJECTED $ % AS OF 12/31/2023 AS OF 12/31/2022 AS OF 12/31/2021 PRIO R YEAR (DECREASE) AS OF 12/31/2023 AS OF 12/31/2022 GENERAL FUND (FUNDS 001-003)
DEPARTMENTS:
COUNCIL/BOARD 450,910$ 450,910 $ - $ 0.0% 316,781 $ 356,648 $ 228,999 $ (39,867) $ (11.2%) 70.3% 68.9% CITY MANAGER (2) 1,564,025$ 1,564,025 $ - $ 0.0% 710,774 $ 1,245,086$ 869,085 $ (534,312) $ (42.9%) 45.4% 61.2% COMMUNICATIONS/CITY CLERK 1,257,736$ 1,257,736 $ - $ 0.0% 478,915 $ 514,803 $ 409,611 $ (35,888) $ (7.0%) 38.1% 51.3% CITY ATTORNEY 656,365$ 656,365 $ - $ 0.0% 110,069 $ 243,172 $ 218,804 $ (133,103) $ (54.7%) 16.8% 40.0% HUMAN RESOURCES (2) 1,942,043$ 1,942,043 $ - $ 0.0% 593,795 $ 290,606 $ 415,001 $ 303,189 $ 104.3% 30.6% 43.4% FINANCIAL SERVICES 1,842,002$ 1,842,002 $ - $ 0.0% 841,949 $ 644,947 $ 599,497 $ 197,002 $ 30.5% 45.7% 48.8% PARKS & RECREATION 8,123,729$ 8,123,729 $ - $ 0.0% 3,514,234 $ 4,668,718 $ 4,351,898 $ (1,154,484) $ (24.7%) 43.3% 55.6% POLICE 18,006,083$ 18,006,083 $ - $ 0.0% 8,479,535 $ 9,397,732 $ 8,718,273 $ (918,197) $ (9.8%) 47.1% 56.3% FIRE 11,686,922$ 11,686,922 $ - $ 0.0% 7,977,043 $ 7,663,478 $ 8,544,856 $ 313,565 $ 4.1% 68.3% 67.1% COMMUNITY DEVELOPMENT 4,871,051$ 4,871,051 $ - $ 0.0% 2,069,541 $ 1,797,761 $ 1,739,333 $ 271,780 $ 15.1% 42.5% 46.8% PUBLIC WORKS 4,779,845$ 4,779,845 $ - $ 0.0% 1,688,311 $ 1,459,982 $ 1,264,222 $ 228,329 $ 15.6% 35.3% 36.3% LIBRARY 538,360$ 538,360 $ - $ 0.0% 269,180 $ 251,872 $ 273,809 $ 17,308 $ 6.9% 50.0% 50.0% 001 SUBTOTAL (1) 55,719,071$ 55,719,071 $ - $ 0.0% 27,050,127 $ 28,534,805 $ 27,633,388 $ (1,484,678) $ (5.2%) 48.5% 55.9% 002 PROPERTY TAX ADMINISTRATION 369,609$ 369,609 $ - $ 0.0% 164,459 $ 152,731 $ 152,731 $ 11,728 $ 7.7% 44.5% 45.1% 003 SPECIAL RECREATION 3,257,272$ 3,257,272 $ - $ 0.0% 1,507,343 $ 996,398 $ 741,600 $ 510,945 $ 51.3% 46.3% 46.5% 59,345,952$ 59,345,952 $ - $ 0.0% 28,721,929$ 29,683,934 $ 28,527,719 $ (962,005) $ (3.2%) 48.4% 55.5% 005 GENERAL FUND - COMMUNITY BENEFITS PROGRAM 349,667$ 349,667 $ - $ 0.0% 54,168 $ 49,591 $ 184,844$ 4,577 $ 9.2% 15.5% 9.5% 006 GENERAL FUND - DARE 38,366$ 38,366 $ - $ 0.0% - $ - $ - $ - $ - - - 007 GENERAL FUND - SOLAR INCENTIVE GRANT PROGRAM 25,000$ 25,000 $ - $ 0.0% 13,000 $ 7,000 $ 8,000 $ 6,000 $ 85.7% 52.0% 28.0% 008 GENERAL FUND - RENTAL ASSISTANCE -$ - $ - $ - - $ - $ - $ - $ - - - 009 GENERAL FUND - ASSET SEIZURE 4,097$ 4,097 $ - $ 0.0% - $ - $ - $ - $ - - - 010 GENERAL FUND - PENSION STABILIZATION FUND -$ - $ - $ - - $ - $ - $ - $ - - - 011 GENERAL FUND - FACILITIES REPLACEMENT -$ - $ - $ - - $ - $ - $ - $ - - - 012 SUSTAINABLE FOSTER CITY 120,945$ 120,945 $ - $ 0.0% 4,122 $ 3,500 $ 87,536$ 622 $ 17.8% 3.4% 2.6% TOTAL ALL GENERAL FUND (FUNDS 001-011) 59,884,027$ 59,884,027 $ - $ 0.0% 28,793,219 $ 29,744,025 $ 28,808,099 $ (950,806) $ (3.2%) 48.1% 54.8%
SPECIAL REVENUE FUNDS
101 TRAFFIC SAFETY 60,000$ 60,000 $ - $ 0.0% 30,000 $ 30,000 $ 30,000 $ - $ 0.0% 50.0% 50.0% 102 MEASURE "A" 4,253,588$ 4,253,588 $ - $ 0.0% 648,666 $ 381,257 $ - $ 267,409$ 70.1% 15.2% 25.4% 103 GAS TAX 935,549$ 935,549 $ - $ 0.0% 612,775 $ 834,527 $ 277,250 $ (221,752) $ (26.6%) 65.5% 147.6% 104 PARK-IN-LIEU FUND 745,435$ 745,435 $ - $ 0.0% - $ - $ - $ - $ - - - 105 MEASURE "M" 100,000$ 100,000 $ - $ 0.0% 100,000 $ 119,300 $ - $ (19,300)$ (16.2%) 100.0% - 108 SLESF/COPS GRANT 100,000$ 100,000 $ - $ 0.0% 125,762 $ 104,058 $ 95,929 $ 21,704 $ 20.9% 125.8% 104.1% 114 CALOPPS 783,050$ 783,050 $ - $ 0.0% 147,964 $ 217,144 $ 232,893 $ (69,180) $ (31.9%) 18.9% 38.5% 116 FOSTER CITY FOUNDATION 136,250$ 136,250 $ - $ 0.0% 40,149 $ 12,113 $ 17,888 $ 28,036 $ 231.5% 29.5% 36.3% 119 SB 1 ROAD MAINTENANCE AND REHAB 455,057$ 455,057 $ - $ 0.0% - $ 1,285,709$ 62,362 $ (1,285,709)$ (100.0%) - - 122 HOUSING SUCCESSOR-LMIHF 146,620$ 146,620 $ - $ 0.0% 44,272 $ 34,988 $ 36,408 $ 9,284 $ 26.5% 30.2% 25.7% 124 FC AFFORDABLE HOUSING FUND 235,000$ 235,000 $ - $ 0.0% 43,717 $ 66,429 $ 159,538$ (22,712) $ (34.2%) 18.6% 6.4% 125 -$ - $ - $ - - $ - $ - $ - $ - - - 127 BAERS (PROGRAM CLOSED OUT IN FY 20/21) -$ - $ - $ - - $ - $ - $ - $ - - - 128 GENERAL PLAN MAINTENANCE 167,400$ 167,400 $ - $ 0.0% 53,683 $ 161,969$ 105,778 $ (108,286) $ (66.9%) 32.1% 19.2% 129 CONSTRUCTION AND DEMO RECYCLING 309,750$ 309,750 $ - $ 0.0% 18,238 $ 29,944 $ 31,170 $ (11,706) $ (39.1%) 5.9% 9.9% 130 TECHNOLOGY MAINTENANCE 105,485$ 105,485 $ - $ 0.0% 27,460 $ 60,371 $ 40,274 $ (32,911) $ (54.5%) 26.0% 57.2% 131 SB 1186 1,300$ 1,300 $ - $ 0.0% - $ - $ - $ - $ - - - 132 SMIP FEE 500$ 500 $ - $ 0.0% - $ - $ - $ - $ - - - 133 CRV GRANT FUND 21,919$ 21,919 $ - $ 0.0% 560 $ 82 $ 1,699$ 478 $ 582.9% 2.6% 0.6% 134 CURBSIDE RECLYCLING 25,000$ 25,000 $ - $ 0.0% - $ - $ - $ - $ - - - 135 GREEN BUILDING FEE 500$ 500 $ - $ 0.0% - $ - $ - $ - $ - - - 136 MEASURE W 815,215 $ 815,215 $ - $ 0.0% 240,215 $ - $ - $ 240,215$ - 29.5% - 137 COMMERCIAL LINKAGE GEE 10,000 $ 10,000 $ - $ 0.0% - $ - $ - $ - $ - - - 138 TENANT RELOCATION ASSISTANCE 51,640 $ 51,640 $ - $ 0.0% - $ - $ - $ - $ - - - 139 WORKFORCE HOUSING 386,187 $ 386,187 $ - $ 0.0% 98,738 $ 47,827 $ - $ 50,911$ 106.4% 25.6% 14.5% 140 EQUIPMENT REPLACEMENT-WORKFORCE HOUSING - $ - $ - $ - - $ - $ - $ - $ - - - 141 SB 1383 IMPLEMENTATION 29,915 $ 29,915 $ - $ 0.0% 5,261 $ 3,538 $ - $ 1,723$ 48.7% 17.6% 7.5% 142 PARK FACILITIES IMPACT FEE - $ - $ - $ - - $ - $ - $ - $ - - - 143 PUBLIC SAFETY IMPACT FEE - $ - $ - $ - - $ - $ - $ - $ - - - 144 TRANSPORTATION IMPACT FEE - $ - $ - $ - - $ - $ - $ - $ - - - TOTAL SPECIAL REVENUE FUNDS 9, 875,360$ 9,875,360 $ - $ 0.0% 2,237,460$ 3,389,256 $ 1,091,189 $ (1,151,796) $ (34.0%) 22.7% 54.7% FY 2023-24
COMPARISON OF BUDGET VS. PROJECTED ACTUAL EXPENDITURES
BUDGET VS ACTUAL & CURRENT VS PRIOR
FOR THE SIX MONTHS ENDED DECEMBER 31, 2023
SAVINGS (EXCESS) FROM
AMENDED BUDGET
TOTAL GENERAL FUND (FUNDS 001-003)
SUSTAINABLE FOSTER CITY (MOVED TO FUND 012)
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 6 MONTHS 6 MONTHS 6 MONTHS FROM INCREASE 6 MONTHS 6 MONTHS Fund BUDGET PROJECTED $ % AS OF 12/31/2023 AS OF 12/31/2022 AS OF 12/31/2021 PRIO R YEAR (DECREASE) AS OF 12/31/2023 AS OF 12/31/2022 FY 2023-24
COMPARISON OF BUDGET VS. PROJECTED ACTUAL EXPENDITURES
BUDGET VS ACTUAL & CURRENT VS PRIOR
FOR THE SIX MONTHS ENDED DECEMBER 31, 2023
SAVINGS (EXCESS) FROM
AMENDED BUDGET
230 LEVEE DEBT SERVICE FUND - 2020 GO BONDS 5,349,188 $ 5,349,188 $ - $ 0.0% 4,229,256 $ 5,198,056 $ 5,230,656 $ (968,800) $ (18.6%) 79.1% 81.5% 231 LEVEE DEBT SERVICE FUND - 2023 GO BONDS 109,513 $ 109,513 $ - $ 0.0% - $ - $ - $ - $ - - -
CAPITAL PROJECTS FUNDS
301 CIP PROJECTS-CITY 4,395,000$ 4,395,000 $ - $ 0.0% 3,382,061 $ 648,092 $ 29,944 $ 2,733,969 $ 421.8% 77.0% 14.2% 326
CAPITAL ASSET ACQUISITION AND REPLACEMENT
FUND (3) -$ - $ - $ - - $ 7,015,009$ - $ (7,015,009)$ (100.0%) - 99.5% 327 LEVEE PROJECT FUND 9,438,912$ 9,438,912 $ - $ 0.0% 5,370,412 $ 9,810,660 $ 15,562,473$ (4,440,248) $ (45.3%) 56.9% - TOTAL CAPITAL PROJECTS FUNDS 13, 833,912$ 13,833,912 $ - $ 0.0% 8,752,473$ 17,473,761$ 15,592,417 $ (8,721,288) $ (49.9%) 63.3% 150.5%
ENTERPRISE FUNDS
401 WATER REVENUE 17,922,284$ 16,219,700 $ - $ 0.0% 7,541,891 $ 6,933,928 $ 6,352,649 $ 607,963 $ 8.8% 42.1% 40.3% 405 CIP-WATER -$ - $ - $ - 159,894 $ 81,224 $ 515,396$ 78,670 $ 96.9% - 2.5% 408 WATER EQUIPMENT REPLACEMENT 249,000$ 249,000 $ - $ 0.0% 15,468 $ 193,484$ 16,306 $ (178,016) $ (92.0%) 6.2% 100.3% 409 WATER CONNECTION FEES -$ - $ - $ - - $ - $ - $ - $ - - - 451 WASTEWATER REVENUE 9,981,803$ 9,981,803 $ - $ 0.0% 3,399,034 $ 3,273,404 $ 3,007,700 $ 125,630 $ 3.8% 34.1% 37.6% 453 WASTEWATER RATE STABILIZATION - $ - $ - $ - - $ - $ - $ - - - 454 SM-FC PUBLIC FINANCING AUTHORITY LOAN 1,863,716 $ 1,863,716 $ - $ 0.0% 1,350,000 $ 1,334,250 $ 1,322,875 $ 15,750 $ 1.2% 72.4% 71.6% 455 CIP-WASTEWATER 11,729,789$ 11,729,789 $ - $ 0.0% 8,489,891 $ 13,208,409$ 3,975,165 $ (4,718,518) $ (35.7%) 72.4% 340.4% 456 WASTEWATER PLANT EXPANSION - $ - $ - $ - - $ - $ - $ - $ - - - 458 WASTEWATER EQUIPMENT REPLACEMENT 423,501$ 423,501 $ - $ 0.0% 184,764 $ 46,774 $ - $ 137,990$ 295.0% 43.6% 15.1% 459 WASTEWATER NOTES/WIFIA LOAN/SRF LOAN 3,144,950$ 3,144,950 $ - $ 0.0% 1,570,780 $ 1,570,920 $ 216,656 $ (140) $ (0.0%) 49.9% 15.4% 460 WASTEWATER CONNECTION FEES -$ - $ - $ - - $ - $ - $ - $ - - - 461 STATE REVOLVING LOAN FUND -$ - $ - $ - - $ - $ - $ - $ - - - TOTAL ENTERPRISE FUNDS 45, 315,043$ 43,612,459 $ - $ - 22,711,722 $ 26,642,393 $ 15,406,747 $ (3,930,671) $ (14.8%) 50.1% 35.3%
INTERNAL SERVICE FUNDS
501 VEHICLE RENTAL FUND 2,134,551$ 2,134,551 $ - $ 0.0% 608,903 $ 808,981 $ 862,347 $ (200,078) $ (24.7%) 28.5% 40.6% 502 EQUIPMENT REPLACEMENT FUND 529,500$ 529,500 $ - $ 0.0% 630 $ 75,693$ 13,765 $ (75,063) $ (99.2%) 0.1% 20.3% 503 SELF INSURANCE FUND (4) 1,532,807$ 1,532,807 $ - $ 0.0% 1,390,765 $ 1,097,466 $ 796,053 $ 293,299 $ 26.7% 90.7% 81.7% 504 INFORMATION TECHNOLOGY 2,892,584$ 2,892,584 $ - $ 0.0% 1,027,344 $ 1,087,453 $ 910,834 $ (60,109) $ (5.5%) 35.5% 45.3% 505 BUILDING MAINTENANCE 2,974,968$ 2,974,968 $ - $ 0.0% 1,207,702 $ 1,160,328 $ 1,108,616 $ 47,374 $ 4.1% 40.6% 25.6% 507 LONGEVITY RECOGNITION PLAN 238,420$ 238,420 $ - $ 0.0% 102,620 $ 93,098 $ 99,220 $ 9,522 $ 10.2% 43.0% 39.1% 508 PEMHCA FUND 245,843$ 245,843 $ - $ 0.0% 101,379 $ 93,853 $ 89,713 $ 7,526 $ 8.0% 41.2% 40.9% 509 COMPENSATED ABSENCES FUND 500,719$ 500,719 $ - $ 0.0% 92,583 $ 305,491$ 167,248 $ (212,908) $ (69.7%) 18.5% 54.5% TOTAL INTERNAL SERVICE FUNDS 11, 049,392$ 11,049,392 $ - $ 0.0% 4,531,926$ 4,722,363 $ 4,047,796 $ (190,437) $ (4.0%) 41.0% 40.5%
FIDUCIARY FUND
604 SUCESSOR ANGENCY 508,051 $ 508,051 $ - $ 0.0% 8,876 $ 10,610$ 11,091 $ (1,734) $ (16.3%) 1.7% 3.2% 607 TOURISM ASSESSMENT - $ - $ - $ - - $ - $ 26,058$ - $ - - - 608 SMC FIRE FEES 320,000 $ 320,000 $ - $ 0.0% 43,556 $ 26,204 $ 67,398 $ 17,352 $ 66.2% 13.6% 11.9% TOTAL CITY / EMID FUNDS 146,244,486$ 144,541,902 $ - $ 0.0% 71,308,488 $ 87,206,668 $ 70,281,451 $ (15,898,180) $ (18.2%) 48.8% 52.5% 1 2
3 The City acquired 22 units of workforce housing in August 2022 4 The City makes its annual insurance premium payments in the 1st quarter of each fiscal year.
Notes and Explanation of Variances:
FY 23/24 expenditures for various departments were comparatively lowe r than the prior two years as the City elected not to prep ay the entire year's unfunded liability obligations to CalPERS in July, but rather make monthly payments due to its high invest ment portfolio yields. These July payments totaled $7.51M and $6.79M for FY 22/23 and FY 21/22 respectively.
Expenditures for the City Managers office are lower as the self insurance program was transferred to the Administrative Service s Dept in FY 23/24 and the Principal Management Analyst positi on has been left unfilled. FY 21/22 expenditures were comparative ly higher and included severance pay to its former City Manager.