Fund B
alance Analysis
Vehicle
Replace-
ment
Fund 501
Equipment
Replace-
ment Fund
502
Self
Insurance
Fund 503
Information
Tech-
nology Fund
504
Building
Main-
tenance
Fund 505
Longevity
Recognition
Fund 507
PEMHCA
Fund 508
Compensated
Absences Fund
509 Total
Water
Enterprise
Equipment
Replacement
Fund 408
Wastewater
Enterprise
Equipment
Replacement
Fund 458
Estimated Ending Fund Balance at 6/30/24 1 6,292,580$ 6,689,496 $ 905,278 $ 5,880,299$ 9,025,173 $ 2,781,834 $ 6,591,995 $ 3,639,437 $ 41,806,092 $ 4,112,780 $ 2,424,428 $ Funds required per detail analysis of each Internal
Service Fund2 4,897,058$ 5,505,166 $ 1,000,000 $ 3,162,105 $ 5,330,067 $ 2,781,834 6,591,995 2,797,558 $ 32,065,783 4,289,251 2,277,929 Projected funds available (required) at 6/30/2024 before minimum reserves 1,395,522 1,184,330 (94,722) 2,718,194 3,695,106 - -
841,879 9,740,309 (176,471) 146,499 Equipment Replacement/Building Maintenance
Reserves (minimum $100,000 per fund) (100,000) (100,000) -
(100,000) (100,000) -
-
- (400,000) - -
Fund Surplus (Deficit) available after Vehicles,
Equipment Replacement, Building Maintenance
Reserves 1,295,522$ 1,084,330$ (94,722)$ 2,618,194$ 3,595,106$ -$ -$ 841,879$ 9,340,309$ (176,471)$ 146,499$ Fund Reallocation To (From) Internal Service Funds -
- - - - -
-
- -$ - -
Adjusted Unassigned Fund Balance above Reserves 1,295,522$ 1,084,330$ (94,722)$ 2,618,194$ 3,595,106$ -$ -$ 841,879$ 9,340,309$ (176,471)$ 146,499$ 1 Estimated Available General Ledger Fund Balance, 6/30/24 2 For Fund 509 (Compensated Absences), this represents the projected accrued liability for earned leave in the General Fund and Special Revenue Funds.
City of Foster Cit
y
Analysis of Internal Service Funds Balances
Projected as at June 30, 2024
For Funds 501 (Vehicle Replacement), 502 (Equipment Replacement), 504 (Information Technology), and Fund 505 (Building Maintenance), these amounts are estimated resources committed to fund asset replacements/building maintenance as of 6/30/24 For Fund 503 (Self-Insurance), the targeted reserve is $1 million.
For Fund 507 (Longevity Recognition) and Fund 508 (PEMHCA Benefit), this represents the projected balance accumulated as of 6/30/24.