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
54680 EMERGENCY MAINTENANCE 55090 PROFESSIONAL SERVICES 55102 UTILITY COLLECTION EXPENSE
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
307,743 $
287,963 $
100,000 160,687 12,000 14,250 105,000 2,900 45,500 18,000 688,544 129,142 10,000 962,290 2,000 500 5,000
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $
100,000 147,500 12,000 14,250 105,000 2,900 45,500 18,000 688,544 129,142 10,000 962,290 2,000 500 5,000
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $
300,000 191,000 12,000 14,000
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
300,000 61,000 12,000 14,000
104,790
$ $ $ $ $ $ $ $ $ $ $ $
58,229 15,417 5,216 89,941
$ $ $ $ $ $ $ $ $ $ $ $
8,845 7,994
55125 PRINTING & BINDING 55145 INSURANCE EXPENSE
86,500
-
-
55170 RENTALS-BLDG LAND & SPACE
- -
- -
2,000 3,500 1,950
2,000 3,500 1,950
55195 ANNUAL AWARDS
55230 MEMBERSHIPS & SUBSCRIPTIONS 55235 TRAINING AND TRAVEL EXPENSES
3,558 3,772
2,820 4,670
15,700 50,000 688,544
15,700 50,000 688,544
55275 RATE STUDY
18,000
18,000
55305 PILOT-TO GEN. FUND 55312 LEGAL-CITY ATTORNEY
688,544 $
688,544 $
8,783 95,226
-
5,000
5,000
55415 OTHER CONTRACTUAL SERVICES
70,971
129,142
129,142
55555 CLAIM SETTLEMENTS
-
500
-
-
55635 FRANCHISE FEE PAID TO G.F. 56355 WATER SERVICE(DALLAS WTR UTIL)
962,290 $ 5,544,405 $
962,290 $ 5,791,223 $
962,290 6,675,000
962,290 6,675,000
6,353,000 $
6,353,000 $
56450 TELEPHONE SERVICE
23,014
$
20,643
$
25,730
$
25,730
$
25,730
25,730
8,168,496 $
8,110,526 $
56640 SANITARY SEWER SERVE-TRA 57170 MISCELLANEOUS EXPENDITURES
7,622,051 $
8,110,526 $
8,516,000
8,516,000
-
$ $
7,170
$ $
5,000
$ $
5,000
$ $
5,000
5,000
57260 CASH OVER/SHORT
(20)
(30)
150
150
150
150
SERVICES AND PROFESSIONAL FEES
$ 17,370,370 $ 18,118,109 $ 18,884,836 $
18,864,595 $
19,671,844 $
19,541,844
58320 CAPITALIZED MACH. & EQUIP.
- - - -
$ $ $ $
- -
$ $ $ $
90,000 90,000
$ $ $ $ $ $ $ $ $ $ $
90,000 90,000
$ $ $ $ $ $ $ $ $ $ $
- -
- -
CAPITAL OUTLAY
50775 PAYING/ESCROW AGENT EXPENSES
750 750
1,500 1,500
1,500 1,500
1,500 1,500
1,500 1,500
DEBT SERVICE
59107 TRANSFER TO 107- LIABILITY INSURANCE 59230 TRANS TO 230-ENERGY MANAGEMENT 59412 TRANS TO 412 ELECTRONIC EQUIP 59420 TRANS TO 420-EQUIP REPLACEMENT 59503 TRANS TO 503 METER REPLACE 59504 TRANS TO 504 EQUIP REPLACEMENT 59505 TRANS TO 505-BUILD CONSTRUCTIO 59508 TRANS TO 508 CAPITAL PROJECTS
-
$
-
$
-
-
175,000 415,758 463,216
175,000 415,758 463,216
415,758 $
415,758 $ 463,216 $ 800,000 $ 174,000 $ - $ 1,980,574 $ 8,833,548 $ 5,000,000 $
415,758 463,216 800,000 145,000 -
415,758 463,216 800,000 145,000 -
58,216
$ $
-
-
-
300,000 $ 123,700 $ 1,000,000 $ 1,525,221 $ 3,422,895 $
1,000,000 388,435 500,000 2,539,103 5,481,512
1,000,000 388,435 500,000 2,532,186 5,474,595
-
-
1,977,433 $ 3,801,407 $
5,977,433 $ 7,801,407 $
TRANSFERS
TOTAL EXPENSES
$ 22,872,888 $ 29,216,696 $ 25,979,000 $
29,958,759 $
28,003,888 $
27,940,215
WORKING CAPITAL-ENDING BALANCE 14,766,057 $ $ 13,796,865 $ 13,496,636 $
9,168,365 $
7,332,097
$
6,169,158
4,574,578 6,861,866 8,005,511 10,191,479 7,904,191 6,760,546
5,843,339 8,765,009 10,225,844 7,953,526 5,031,856 3,571,021
5,195,800 7,793,700 9,092,650 8,300,836 5,702,936 4,403,986
5,991,752 8,987,628 10,485,566
5,600,778 8,401,166 9,801,361 1,731,319 (1,069,070) (2,469,264)
5,588,043 8,382,065 9,779,075
Minimum Reserve Requirement 20% Target Reserve Requirement 30% Maxium Reserve Requirement 35% Over/(Under) Minimum Reserve Requirement Over/(Under) Target Reserve Requirement Over/(Under) Maxium Reserve Requirement
3,176,613
581,115
180,737
(2,212,907) (3,609,918)
(1,317,201)
# days covered
387
283
312
184
157
132
9- 30
Made with FlippingBook - Online magazine maker