Page 49 - Trophy Club ORD 2023-15 Adoption FY23-24

TOWN OF TROPHY CLUB, TEXAS
Annual Program of Services
Storm Drainage FY 2021 FY 2022 FY 2022 FY 2023 FY 2023 FY 2024 FY 2025 FY 2026

Utility ACTUAL AMENDED ACTUAL AMENDED ESTIMATE PROPOSED PROJECTED PROJECTED
BUDGET
BUDGET
Beginning Working Capital $ 1,731,975 $ 743,720 $ 2,178,395 $ 953,482 $ 959,446 $ 872,424 $ 905,959 $ 1,112,766
Revenue
Storm Drainage Fee $ 435,798 $ 438,600 $ 435,559 $ - $ 430,000 $ 430,000 $ 438,600 $ 447,372
Hazardous Waste Stipend - - - - - - - -
Miscellaneous Revenue - - - - - - -

Interest Income 325 - 8,264 - 30,681 5,000 5,100 5,202

Total Revenue $ 436,123 $ 438,600 $ 443,823 $ - $ 460,681 $ 435,000 $ 443,700 $ 452,574
Expenses
Personnel
Salaries $ - $ - $ - $ - $ - $ 50,213 $ 51,217 52,241
Overtime - - - - - - - -
Longevity - - - - - 187 190 194
Cell Phone Stipend - - - - - 405 413 421

Retirement - - - - - 6,633 6,766 6,901

Medical Insurance - - - - - 2,037 2,077 2,119

Dental Insurance - - - - - 267 272 277

Vision Insurance - - - - - 45 46 47
Life Insurance & Other - - - - - 225 230 234
Social Security Taxes - - - - - 3,113 3,175 3,239

Medicare Taxes - - - - - 728 743 757

Unemployment Taxes - - - - - 139 141 144

Workers' Compensation - - - - - 1,416 1,444 1,473
Total Personnel $ - $ - $ - $ - $ - $ 65,407 $ 66,715 $ 68,050
Services & Supplies
Professional Outside Services $ 19,175 $ 30,000 $ 19,175 $ 30,000 $ 30,000 $ 30,000 $ 30,600 $ 31,212

Engineering/Construction 14,597 30,000 9,018 30,000 30,000 30,000 30,600 31,212

Trash Removal/Recycling 5,900 5,100 2,950 5,202 5,202 5,202 5,306 5,412
Street Sweeping 6,121 15,300 7,100 15,606 15,606 15,606 15,918 16,236

Independent Labor 17,395 122,400 47,005 125,000 125,000 125,000 127,500 130,050

Dues & Membership 105 250 - 250 250 250 255 260
Depreciation Expense 51,084 - 51,083 - - - - -

Total Services & Supplies $ 114,377 $ 203,050 $ 136,331 $ 206,058 $ 206,058 $ 206,058 $ 210,179 $ 214,383
Capital
Capital Replacement $ - $ - $ - $ - $ - $ - $ - $ -
Capital Expense - - - - - - - -
Capital Projects - - - - - 150,000 - -
Transfer to Drainage Capital Projects - - - - - - - -
Total Capital $ - $ - $ - $ - $ - $ 150,000 $ - $ -
Debt Service
Principal $ (160,000) $ - $ - $ - $ - $ - $ - $ -

Interest 11,789 - - - - - -
Total Debt Service $ (148,211) $ - $ - $ - $ - $ - $ - $ -
Total Expenses $ (33,834) $ 203,050 $ 136,331 $ 206,058 $ 206,058 $ 421,465 $ 276,894 $ 282,432
Other Sources (Uses)
Cumulative effect on change in account $ - $ - $ - $ - $ - $ - $ 1 $ -
Transfer In 16,463 - 177,194 - - - - -

Transfer to General Fund (40,000) (20,000) (20,000) 125,000 20,000 20,000 40,000 40,000
Transfer To Debt Service - - (7,799) - - - - -
Total Other Sources $ (23,537) $ (20,000) $ 149,395 $ 125,000 $ 20,000 $ 20,000 $ 40,001 $ 40,000
Net Increase (Decrease) $ 446,420 $ 215,550 $ 456,887 $ (81,058) $ 274,623 $ 33,535 $ 206,807 $ 210,142
Ending Working Capital $ 2,178,395 $ 959,270 $ 2,635,282 $ 872,424 $ 1,234,069 $ 905,959 $ 1,112,766 $ 1,322,907
FY24 Adopted Budget 41