Page 67 - Pantego FY23 Budget

TOWN OF PANTEGO
WATER AND SEWER OPERATING FUND
EXPENSES BY CATEGORY
FOR FY 2022-2023 BUDGET

2021‐2022 2020‐2021 2022‐2023 2021-2022/
2019‐2020 2020‐2021 ADOPTED Y-T-D 2021‐2022 PROPOSED 2022-2023
ACC. NUM. ACCOUNT DESCRIPTION ACTUAL ACTUAL BUDGET 6/30/2021 YE ESTIMATE BUDGET % CHANGE

CONTRACTUAL AGREEMENTS
232.00 Engineering & Maps $ - $ 512 $ 4,500 $ 550 $ 825 $ 3,500 -22.2%
247.00 Insurance Expense 4,070 4,662 4,880 7,188 8,470 5,900 20.9%

284.00 Arlington Sewer Charge 102,939 115,166 110,000 68,706 121,000 125,000 13.6%

284.10 Fort Worth Sewer Charge 226,390 157,350 255,000 89,572 170,000 180,000 -29.4%

367.00 TCEQ Annual System Fees 4,476 4,476 4,476 4,376 4,376 5,000 11.7%
710.00 Franchise Expense 24,996 24,996 24,996 16,664 25,000 33,000 32.0%

710.10 Ground Water Conservation Fees 22,635 21,502 24,000 14,032 26,516 25,000 4.2%

710.20 Collier Groundwater Contract 13,500 10,800 10,800 5,400 10,800 12,000 11.1%
SUBTOTAL CONTRACTUAL $ 399,006 $ 339,464 $ 438,652 $ 206,488 $ 366,987 $ 389,400 -11.2%
SUPPLIES / MAINTENANCE
234.00 Maintenance Agreements $ - $ - $ 1,000 $ - $ 500 $ 1,000 0.0%
238.00 Office Supplies 228 - 250 27 500 1,000 300.0%
239.00 Postage Service / Maintenance 7,001 8,122 7,500 5,453 8,850 9,500 26.7%

245.00 Water Meter Maintenance - 1,304 5,000 604 805 6,000 20.0%

245.10 Storage Tank Inspections 3,000 2,645 3,500 995 3,000 3,500 0.0%

282.00 Printing Expense - 1,072 3,000 3,942 5,255 6,000 100.0%

329.00 Uniform Expense 2,121 1,331 2,400 1,031 1,455 10,000 316.7%

350.00 Building Maintenance 1,803 296 2,000 - 500 5,000 150.0%
351.00 Water Quality Sampling 3,902 3,849 4,000 1,149 1,625 4,000 0.0%

354.00 General Water/Sewer System Repair 17,849 12,811 132,500 27,762 38,098 140,000 5.7%

355.00 Water Treatment Chemicals 10,454 12,018 12,000 7,178 11,000 16,500 37.5%

356.00 Vehicle / Equipment Expense 4,916 1,682 3,000 3,125 5,180 4,000 33.3%
360.00 Ground Maint / Landscaping 5,850 6,687 23,870 2,380 5,600 6,160 -74.2%

476.00 Valves and Hydrants 50,000 5,000 50,000

477.40 Well Maintenance Program 9,857 15,238 225,000 7,430 60,500 225,000 0.0%
528.00 Equipment & Supplies 12,122 11,410 14,500 2,631 6,225 11,350 -21.7%
528.10 Filtration Supplies - - 1,200 - 1,200 1,500 25.0%
528.20 Traffic Control Supplies - 162 500 - - 1,500 200.0%
770.10 Credit Card Processing Fees - - - - - -
SUBTOTAL SUPPLIES / MAINTENANCE $ 79,104 $ 78,626 $ 491,220 $ 63,707 $ 155,293 $ 502,010 2.2%
UTILITIES & GASOLINE
362.00 Gasoline / Oil Expense $ 4,126 $ 5,474 $ 3,500 $ 5,715 $ 8,125 $ 11,000 214.3%

411.00 Natural Gas and Electricity 99,936 96,316 115,000 70,531 107,000 115,000 0.0%

411.10 Telephone Expense 1,341 1,579 465 1,255 1,906 1,700 265.6%

411.20 Cell phone Expense 988 1,793 1,800 1,395 2,065 2,230 23.9%
SUBTOTAL UTILITIES & GASOLINE $ 106,390 $ 105,162 $ 120,765 $ 78,896 $ 119,096 $ 129,930 7.6%
TRAINING / DUES / MISC.
705.00 Membership Dues $ 780 $ - $ 750 $ 105 $ 300 $ 1,250 66.7%
724.00 Travel / Training 2,888 2,187 5,415 3,109 4,150 4,000 -26.1%

770.00 Miscellaneous 388 740 2,000 1,140 1,872 2,000 0.0%
SUBTOTAL TRAINING / DUES / MISC. $ 4,056 $ 2,927 $ 8,165 $ 4,354 $ 6,322 $ 7,250 -11.2%
CAPITAL

480.00 Asset Purchase - $ - $ - $ 13,302 $ 26,604 $ -
482.00 Minor Software $ - $ - $ 1,770 $ - $ - $ 2,500 41.2%
486.00 Minor Equipment - - - - - 1,500
486.10 Major Equipment - - 31,000 - - - #DIV/0!
488.00 Equipment - 3,579 - - - -

SUBTOTAL CAPITAL OUTLAY $ - $ 3,579 $ 32,770 $ 13,302 $ 26,604 $ 4,000
TOTAL EXPENSES
WATER & SEWER OPERATING FUND $ 588,555 $ 529,758 $ 1,091,572 $ 366,746 $ 674,302 $ 1,032,590 -5.4%
ADOPTED BUDGET FY2022-23 TOWNOFPANTEGO.COM/BUDGET PAGE 65