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

TOWN OF TROPHY CLUB, TEXAS
Annual Program of Services
Hotel Occupancy Tax 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
Beginning Fund Balance $ 1,530,643 $ 1,473,389 $ 1,726,747 $ 1,393,312 $ 2,275,554 $ 2,638,723 $ 2,677,914 $ 2,789,082

Revenue
Hotel Occupancy Tax $ 392,660 $ 400,000 $ 781,831 $ - $ 700,000 $ 600,000 $ 600,000 $ 600,000

July 4th Revenue 19,934 7,500 21,442 600,000 6,000 7,500 7,500 7,500

Interest Income 919 5,000 12,140 7,500 88,639 5,000 5,000 5,000

Total Revenue $ 413,513 $ 412,500 $ 815,413 $ 607,500 $ 794,639 $ 612,500 $ 612,500 $ 612,500

Expenditures
Personnel
Salaries $ 20,046 $ - $ 12,264 $ - $ 90,479 $ 77,681 $ - $ -
Overtime - - - - - - - -

Longevity - - - - - 300 306 312

Salaries - Certification - - - - 835 930 949 968

Salaries - Cell Phone Stipend - - - 47,013 305 582 594 606
Retirement 2,501 - 1,032 653 10,168 9,765 9,960 10,159

Medical insurance 1,641 - 795 - - 721 736 750

Dental Insurance 125 - 48 392 421 778 793 809
Vision Insurance 14 - 7 6,107 56 163 166 169

Life Insurance & Other 102 - 38 385 326 339 346 353

Social Security Taxes 1,208 - 744 34 1,280 4,583 4,675 4,768

Medicare Taxes 283 - 174 328 299 1,072 1,093 1,115

Unemployment Taxes 55 - 5 2,915 9 159 162 165

Workers Compensation - - - 303 309 315

Total Personnel $ 25,975 $ - $ 15,108 $ 57,827 $ 104,178 $ 97,375 $ 19,779 $ 20,174
Services & Supplies

Professional Outside Services $ - $ - $ 5,484 $ 682 $ 97,500 $ 20,000 $ 20,400 20,808
Auditing 3,000 4,000 4,000 - 4,000 4,000 4,080 4,162
Software & Support 4,961 10,000 18,284 52,000 19,293 31,434 32,063 32,704
Advertising 4,031 17,500 19,292 4,000 61,500 61,500 62,730 63,985

Communications/Pagers/Mobiles 1,368 - 1,368 19,293 - - - -

Event Rentals 1,500 - 1,968 61,500 - - - -

Dues & Membership - 4,000 - - - 4,000 4,080 4,162

July 4 Celebration 81,992 140,000 95,602 - 140,000 160,000 163,200 166,464

Bad Debt Expense - - 10,500 - - - - -

Total Services & Supplies $ 96,852 $ 175,500 $ 156,498 $ 137,475 $ 322,293 $ 280,934 $ 286,553 $ 292,284

Capital Outlay
Capital Outlay $ - $ 100,000 $ - $ 4,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000

Total Capital $ - $ 100,000 $ - $ 4,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000

Total Expenditures $ 122,827 $ 275,500 $ 171,606 $ 199,301 $ 526,471 $ 478,309 $ 406,331 $ 412,458

Other Sources (Uses)
Transfer To General Fund $ (94,582.00) $ (95,000.00) $ (95,000.00) $ 140,000.00 $ 95,000 $ (95,000) $ (95,000) $ (95,000)

Total Other Sources (Uses) $ (94,582) $ (95,000) $ (95,000) $ 140,000 $ 95,000 $ (95,000) $ (95,000) $ (95,000)
Net Increase (Decrease) $ 196,104 $ 42,000 $ 548,807 $ 548,199 $ 363,168 $ 39,191 $ 111,169 $ 105,042

Ending Fund Balance $ 1,726,747 $ 1,515,389 $ 2,275,554 $ 1,941,511 $ 2,638,723 $ 2,677,914 $ 2,789,082 $ 2,894,124

PERSONNEL SCHEDULE
POSITION TITLE FY 2023 FY 2024
TOWN MANAGER 0.00 0.05 80% Funded by General Fund - 15% Funded by EDC4B
COMM & MARKETING DIRECTOR 0.58 0.58 42% Funded by General Fund
TOTAL FTEs 0.58 0.63
FY24 Adopted Budget 46