502 PUBLIC UTILITY FUND CITY OF DESOTO DETAILS
Actuals FY
Actuals FY
Budget FY
Projected FY
Proposed FY
Planning FY
LINE ITEMS
2021
2022
2023
2023
2024
2025
$12,949,246
$14,628,206 $13,934,716
$13,934,716
$
9,168,365 9,168,365 9,168,365
$
7,332,097 7,941,753 7,332,097
FUND BALANCE-BEGINNING BAL.
WORKING CAPITAL -BEG. BAL. $ 13,039,983 $ 14,718,943 $ 13,442,224 $ WC BEGINNING FUND BAL. $ 13,039,983 $ 14,766,057 $ 13,796,865 $
13,442,224 $ 13,796,865 $
$
$
REVENUES 45405 WATER SALES-METERED 45410 WATER SERVICE REVENUE 45415 WATER CONNECTION REVENUE 45416 SEWER SERVICE REVENUE 45418 SEWER CONNECTION REVENUE 45419 SENIOR DISCOUNT - WATER 45422 SENIOR DISCOUNT - SEWER
$ 10,710,161 $ 12,996,726 $ 11,567,200 $
11,567,200 $
11,798,600 $
11,798,600
$ $ $ $ $ $ $ $ $ $
32,825 16,853
$ $ $ $ $ $ $ $
43,245 33,793
$ $ $ $ $ $ $ $ $
30,000 50,000
$ $ $ $ $ $ $ $ $ $
32,000 25,000
$ $ $ $ $ $ $ $ $ $
30,000 50,000
$ $ $ $ $ $ $ $ $ $
30,000 50,000
$ 12,954,804 $ 14,231,152 $ 13,765,500 $
13,765,500 $
14,040,800 $
14,040,800
3,850
6,380
11,220
5,000
11,220
11,220
(131,805) (127,986)
(132,690) (129,117) 56,124 3,745 50,690 965,217
(120,000) (120,000) 300,000
(120,000) (120,000) 300,000 200,000
(120,000) (120,000) 300,000 150,000
(120,000) (120,000) 300,000 150,000
45426 PENALTY FEES
114,275 $
260,090 $
46060 INTEREST REVENUE
60,961 3,975 28,876
30,000 1,000 26,000
49110 MISCELLANEOUS REVENUE 49121 MISC. RECOVERY REVENUE 49851 REFUND OF EXCESS FUNDS - TRA
4,200 26,000
1,000 26,000
1,000 26,000
1,022,909 $
-
-
-
-
TOTAL REVENUES
$ 24,689,700 $ 28,385,354 $ 25,540,920 $
25,684,900 $ 39,127,124 $
26,167,620 $ 35,335,985 $
26,167,620 34,109,373
TOTAL AVAILABLE RESOURCES 37,638,945 $ $ 43,013,561 $ 39,475,636 $
USES OF FUNDS 51020 GROUP INSURANCE-EMPLOYER
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
212,651 $ 113,021 $
267,167 $ 127,019 $
384,141 152,592 24,050 225,019 126,000 14,000 81,585 17,371 3,300 11,530 9,600 5,000 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
384,141 152,592 24,050 225,019 126,000 14,000 81,585 17,371 3,300 11,530 9,600 5,000 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
387,002 138,420 13,076 190,818
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
468,530 142,294 12,887 180,843
51050 FICA EXP.-EMPLOYER
51080 WORKER'S COMPENSATION
10,889 30,580
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
18,037 42,371
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
51110 TMRS-EMPLOYER
51140 SALARY & BENEFIT ADJUSTMENTS
-
-
-
-
51290 PIP INCENTIVE PROGRAM
11,351
11,303
14,000
14,000
51470 SALARIES
1,397,631 $ 121,371 $
1,494,273 $
1,877,519 $
1,877,519 $
1,682,512
1,680,318
51530 SALARIES OVERTIME 51560 SALARIES-PART TIME 51590 CERTIFICATION PAY 51650 LONGEVITY PAY 51770 AUTO ALLOWANCE 51570 FINAL BENEFIT PAY EXPENSE 51800 DEFERRED COMPENSATION
100,132 29,275
81,585 28,033
81,585 28,033
12,935
-
-
-
-
1,913 9,292
3,075 9,920 5,600
3,000 8,436 9,600 6,000
2,400 6,236 9,600 6,000
11,600
-
-
PERSONNEL
1,933,235 $
2,108,171 $
2,931,707 $
2,931,707 $
2,562,482
2,632,726
53040 OTHER EQUIPMENT
9,148 10,878 83,717 1,178 12,298 28,441
15,139 21,678 61,532 1,257 17,460 35,000 3,912 140
18,500 11,000 145,000
18,500 11,000 145,000
18,500 11,000 145,000 5,000 27,800 20,100 56,400
18,500 11,000 145,000 5,000 27,800 20,100 56,400
53340 OFFICE SUPPLIES/EQUIPMENT 53360 CHEMICALS, MEDICINE & LAB SUP 53380 MISCELLANEOUS SUPPLIES
(0)
5,000 7,800
5,000 7,800
53520 FURNITURE & FIXTURES
53640 CLOTHING 53680 VEHICLE FUEL
20,100 56,400 5,750 269,550 155,000 97,800 56,000 7,500 150,000 157,254 30,000 125,000
20,100 56,400 5,750 269,550 155,000 97,800 56,000 7,500 150,000 150,200 30,000 125,000
53800 PROGRAM FOOD & REFRESHMENTS
728
5,750
5,750
SUPPLIES
146,389 $
156,118 $
289,550
289,550
52106 BANK & CREDIT CARD EXP.
159,779 $
152,338 $
155,000 97,800 60,000 7,500 124,475 119,000 1,356,063
155,000 97,800 60,000 7,500 124,475 119,000 1,356,063
52230 POSTAGE
66,741
$
83,971
$
52310 ADMIN COST REIMB TO 101 GEN FD
1,356,063 $
1,356,063 $
1,356,063 $
1,356,063 $
52430 TCEQ
55,769 5,885 92,862 49,802
$ $ $ $ $ $
55,774 3,087
$ $ $ $ $
52570 MILEAGE REIMB
54050 REPAIR & MAINTENANCE 54320 COMPUTER SOFTWARE MAINT.
105,282 $
70,349
54515 CONCRETE REPAIR
-
-
30,000 125,000
30,000 125,000
54650 W&S MAINTENANCE(MAINS MTRS.ETC
97,973
99,182
9- 29
Made with FlippingBook - Online magazine maker