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

TOWN OF TROPHY CLUB, TEXAS
Annual Program of Services
Street Maintenance FY 2021 FY 2022 FY 2022 FY 2023 FY 2023 FY 2024 FY 2025 FY 2026
Fund ACTUAL AMENDED ACTUAL AMENDED ESTIMATE PROPOSED PROJECTED PROJECTED
BUDGET
BUDGET
Beginning Fund Balance $ 184,556 $ 302,900 $ 302,900 $ 222,366 $ 302,901 $ 259,253 $ 245,435 $ 231,753

Revenue
Sales Tax $ 322,978 $ 300,000 $ 361,485 $ - $ 350,000 $ 350,000 $ 357,000 $ 364,140
Interest Income - - - - 1,983 1,500 1,530 1,561

Total Revenue $ 322,978 $ 300,000 $ 361,485 $ - $ 351,983 $ 351,500 $ 358,530 $ 365,701

Expenditures
Personnel
Salaries $ 63,461 $ 67,937 $ 73,413 $ 76,594 $ 85,930 $ 115,609 $ 117,921 $ 120,280

Merits - 1,359 - 3,930 - - - -
Salaries - Overtime - - 791 - 2,360 - - -

Longevity 1,344 1,523 1,523 1,649 1,649 1,815 1,851 1,888
Annual Stipend 1,050 - - - - - - -

Cell Phone Stipend - 360 343 360 377 585 585 585

Retirement 8,895 9,008 10,090 10,389 11,142 15,272 15,577 15,889

Medical Insurance 5,514 5,702 4,514 6,272 5,204 6,011 6,131 6,254

Dental Insurance 648 682 531 750 590 976 995 1,015

Vision Insurance 70 76 87 84 97 211 215 220

Life Insurance & Other 365 507 420 563 469 561 573 584

Social Security Taxes 4,044 4,413 4,766 4,873 3,568 7,168 7,311 7,457

Medicare Taxes 946 1,032 1,115 1,139 834 1,676 1,710 1,744

Unemployment Taxes 331 353 (39) 353 13 416 424 433

Workers' Compensation 2,564 2,904 3,301 3,472 3,472 6,760 6,895 7,033
Total Personnel $ 89,231 $ 95,856 $ 100,852 $ 110,428 $ 115,706 $ 157,060 $ 160,190 $ 163,382

Services & Supplies
Water $ - $ 2,040 $ - $ 2,081 $ 2,081 $ 2,081 $ 2,123 $ 2,165
Communications/Pagers/Mobiles 180 - - - - - - -

Vehicle Maintenance 5,950 3,570 2,615 3,641 3,641 7,210 7,354 7,501

Equipment Maintenance 1,916 500 1,420 500 500 3,000 3,060 3,121

Street Maintenance 52,861 102,000 77,207 125,000 125,000 125,000 127,500 130,050
Signs & Markings 47,835 24,400 17,073 40,000 40,000 40,000 40,800 41,616

Fuel 5,055 6,630 5,653 6,763 6,763 6,763 6,898 7,036

Small Tools 1,014 2,040 2,322 2,081 2,081 2,081 2,123 2,165

Miscellaneous Expense 591 - 542 - 359 - - -
Total Service & Supplies $ 115,402 $ 141,180 $ 106,832 $ 180,066 $ 180,425 $ 186,135 $ 189,858 $ 193,655

Capital
Vehicles $ - $ - $ - $ - $ - $ - $ - $ -
Capital Replacement - - - - - - - -

Capital Outlay - - - 2,081 79,500 2,123 2,165 2,208

Total Capital $ - $ - $ - $ 2,081 $ 79,500 $ 2,123 $ 2,165 $ 2,208

Total Expenditures $ 204,634 $ 237,036 $ 207,684 $ 292,575 $ 375,631 $ 345,318 $ 352,213 $ 359,245

Other Sources (Uses)
Transfer to General Fund $ - $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000
Transfer To Debt Service - - - - - - - -
Transfer Out - - - - - - -
Transfer To Storm Drainage - - - - - - - -
Total Sources Other (Uses) $ - $ (20,000) $ (20,000) $ (20,000) $ (20,000) $ (20,000) $ (20,000) $ (20,000)
Net Increase (Decreases) $ 118,344 $ 42,964 $ 133,801 $ (312,575) $ (43,648) $ (13,818) $ (13,683) $ (13,545)

Ending Fund Balance $ 302,900 $ 345,864 $ 436,701 $ (90,209) $ 259,253 $ 245,435 $ 231,753 $ 218,208
PERSONNEL SCHEDULE
POSITION TITLE FY 2023 FY 2024
STREETS CREW LEADER 1.00 1.00
COMMUNITY DEVELOPMENT DIR. 0.00 0.25 50% Funded by General Fund - 25% Funded by Drainage
STREETS SUPERINTENDENT 0.40 0.40 40% Funded by General Fund - 20% Funded by Drainage
SENIOR ADMINISTRATIVE ASSISTANT 0.00 0.10 80% Funded by General Fund - 10% Funded by Drainage
TOTAL FTEs 1.40 1.75
FY24 Adopted Budget 40