Page 69 - CityofGrandPrairieFY25Adopted Budget

City of Grand Prairie
Water/Wastewater Fund
Enterprise Fund
2024/2025

Modified Modified
2022-23 2023-24 2023-24 2024-25 vs. vs.
Actual Modified Projection Adopted Adopted Adopted
% $

Beginning Resources $ 38,775,207 $ 36,360,614 $ 36,360,614 $ 35,713,462 -2% $ (647,152)
Revenues
Water Sales $ 58,207,007 $ 60,530,573 $ 60,124,032 $ 63,454,188 5% $ 2,923,615
Wastewater Services 36,799,969 42,619,577 42,255,417 44,898,038 5% 2,278,461
Wastewater Surcharges 1,092,972 1,016,616 1,120,508 1,068,914 5% 52,298
Water and Wastewater Fees 2,796,125 2,906,431 2,865,294 2,868,539 -1% (37,892)
Fines and Forfeitures 5,000 - - - 0% -
License Fees and Permits 21,712 21,050 25,966 21,050 0% -
Intergovernmental Revenue 1,152,107 - 2,159,344 - 0% -
Rents and Royalties 262,278 247,052 247,052 247,052 0% -
Misc Revenue 7,208,121 12,000 12,000 12,000 0% -
Total Operating Revenues $ 107,545,291 $ 107,353,299 $ 108,809,613 $ 112,569,781 5% $ 5,216,482
Gain/Loss On Sales Of Capital $ 133,554 $ 26,308 $ 141,588 $ 20,000 -24% $ (6,308)
Investment Income 18,901 - 9,409 - 0% -
Proceeds from Debt Issuance (10,765,000) - - - 0% -
Total Operating & Non-Operating Revenues $ 96,932,746 $ 107,379,607 $ 108,960,610 $ 112,589,781 5% $ 5,210,174
Total Resources $ 135,707,953 $ 143,740,221 $ 145,321,224 $ 148,303,243 3% $ 4,563,022
Expenditures
Personnel $ 9,909,052 $ 12,046,366 $ 10,903,519 $ 12,416,091 3% $ 369,725
Operating Expenses
Wastewater Treatment 21,966,517 26,879,062 26,179,062 28,092,760 5% 1,213,698
Water Purchases 20,215,425 23,084,991 22,984,991 26,364,593 14% 3,279,602
Purchased Services 2,389,286 2,634,715 2,634,715 2,905,965 10% 271,250
Utilities 415,153 481,549 480,955 493,522 2% 11,973
Supplies and Materials 1,380,085 1,202,888 1,194,896 1,367,379 14% 164,491
Maintenance and Repair 982,281 1,682,967 1,682,967 2,687,807 60% 1,004,840
Interdepartmental 1,024,072 1,147,083 1,147,083 2,662,354 132% 1,515,271
Misc Operating Expenses 221,866 414,348 376,508 397,620 -4% (16,728)
Travel and Training 47,750 63,420 63,420 66,419 5% 2,999
Total Operating Expenditures $ 58,551,487 $ 69,637,389 $ 67,648,116 $ 77,454,510 11% $ 7,817,121
Capital Outlay $ 9,700,948 $ 2,314,146 $ 2,314,146 $ 1,438,625 -38% $ (875,521)
Debt Service (5,196,543) 24 24 7,385,621 30773321% 7,385,597
Franchise Fees 3,764,745 4,098,475 4,098,475 4,098,475 0% -
General and Administrative Costs 4,893,621 5,138,301 5,138,301 5,138,301 0% -
Insurance Claims and Service 3,000 3,000 3,000 3,000 0% -
Reimbursements 948,665 1,061,481 1,061,481 - -100% (1,061,481)
Transfer to Water CIP 10,000,000 20,600,000 20,600,000 13,500,000 -34% (7,100,000)
Transfer to Wastewater CIP - - - 1,500,000 0% 1,500,000
Transfer to Wastewater Debt Service 6,866,202 7,012,331 7,012,331 - -100% (7,012,331)
Transfer In-Lieu-Of-Property Tax 1,328,050 1,386,888 1,386,888 1,445,950 4% 59,062
Transfer to Water/Wastewater Rate Stability 195,000 195,000 195,000 195,000 0% -
Transfer to IT Acquisition 150,000 150,000 150,000 150,000 0% -
Non Budget (13,923,045) - - - 0% -
Total Operating & Non-Operating Expenditures $ 77,282,130 $ 111,597,035 $ 109,607,762 $ 112,309,482 1% $ 712,447
Ending Resources $ 36,360,614 $ 32,143,186 $ 35,713,462 $ 35,993,761
Rate Stabilization 5,118,408 5,313,408 5,313,408 5,508,408
Debt Service 2,534,049 2,534,049 2,534,049 2,534,049
Reserves $ 7,652,457 $ 7,847,457 $ 7,847,457 $ 8,042,457
Ending Resources Less Reserves $ 28,708,157 $ 24,295,729 $ 27,866,005 $ 27,951,304
Addition to (or draw on) Reserves 19,650,616 (4,217,428) (647,152) 280,299
Fund Balance Requirement (80) Days 16,938,549 24,459,624 24,023,619 24,615,777
Excess fund balance available 19,422,065 7,683,562 11,689,843 11,377,984
Current Total Positions:138 Full-Time and 12 Part-Time
Customer Service: 35 Full-Time and 6 Part-Time
Wastewater Maint: 29 Full-Time and 0 Part-Time
Water Distribution: 59 Full-Time and 0 Part-Time
Water Inspection: 15 Full-Time and 6 Part-Time
Frozen: 0 Full-Time and 0 Part-Time

69