Page 43 - Trophy Club FY22 Budget
P. 43
TOWN OF TROPHY CLUB, TEXAS
Annual Program of Services
Hotel Occupancy Tax FY 2019 FY 2020 FY 2020 AMENDED FY 2021 FY 2022 FY 2023 FY 2024
FY 2021
Fund ACTUAL APPROVED ACTUAL BUDGET ESTIMATE APPROVED PROJECTED PROJECTED
Beginning Fund Balance $ 790,686 $ 1,067,065 $ 1,313,981 $ 1,313,981 $ 1,530,643 $ 1,393,312 $ 1,450,312 $ 1,511,217
Revenue
Hotel Occupancy Tax $ 669,983 $ 550,000 $ 387,759 $ 210,000 $ 293,029 $ 400,000 $ 400,000 $ ‐
July 4th Revenue 11,133 7,500 ‐ 7,500 15,750 7,500 7,500 ‐
Interest Income 14,485 5,000 6,856 5,000 1,460 5,000 5,000 ‐
Total Revenue $ 695,601 $ 562,500 $ 394,615 $ 222,500 $ 310,239 $ 412,500 $ 412,500 $ ‐
Expenditures
Personnel
Salaries $ 17,732 $ ‐ $ 4,398 $ ‐ $ ‐ $ ‐ $ ‐ $ ‐
Overtime ‐ 20,000 ‐ 20,000 20,000 ‐ ‐ ‐
Longevity ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
Stipend ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
Retirement 2,191 ‐ 507 ‐ ‐ ‐ ‐ ‐
Medical insurance 1,689 ‐ 214 ‐ ‐ ‐ ‐ ‐
Dental Insurance 81 ‐ 25 ‐ ‐ ‐ ‐ ‐
Vision Insurance 10 ‐ 3 ‐ ‐ ‐ ‐ ‐
Life Insurance & Other 116 ‐ 25 ‐ ‐ ‐ ‐ ‐
Social Security Taxes 1,059 ‐ 252 ‐ ‐ ‐ ‐ ‐
Medicare Taxes 248 ‐ 59 ‐ ‐ ‐ ‐ ‐
Unemployment Taxes 4 ‐ 5 ‐ ‐ ‐ ‐ ‐
Workers' Compensation ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
Pre‐Employment Physicals/Testing ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
Total Personnel $ 23,129 $ 20,000 $ 5,489 $ 20,000 $ 20,000 $ ‐ $ ‐ $ ‐
Services & Supplies
Professional Outside Services $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐
Auditing 2,000 3,000 3,000 3,000 3,000 4,000 4,000 4,000
Software & Support ‐ 4,500 4,725 5,000 5,000 10,000 5,000 5,000
Advertising 33,501 17,725 16,994 25,000 25,000 17,500 18,595 18,595
Service Charges & Fees 51 ‐ ‐ ‐ ‐ ‐ ‐ ‐
Printing ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
Communications/Pagers/Mobiles 75 ‐ 1,236 ‐ 570 ‐ ‐ ‐
Event Rentals ‐ 1,500 ‐ 15,045 10,000 ‐ ‐ ‐
Dues & Membership ‐ 3,900 ‐ 4,000 2,000 4,000 4,000 4,000
Uniforms ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
Program Supplies ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
July 4 Celebration 82,505 111,300 32,941 114,883 112,000 125,000 125,000 125,000
Community Events ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
Total Services & Supplies $ 118,132 $ 141,925 $ 58,896 $ 166,928 $ 157,570 $ 160,500 $ 156,595 $ 156,595
Capital Outlay
Capital Outlay $ 31,045 $ 50,000 $ 113,568 $ 175,000 $ 175,000 $ 100,000 $ 100,000 $ 100,000
Total Capital $ 31,045 $ 50,000 $ 113,568 $ 175,000 $ 175,000 $ 100,000 $ 100,000 $ 100,000
Total Expenditures $ 172,306 $ 211,925 $ 177,953 $ 361,928 $ 352,570 $ 260,500 $ 256,595 $ 256,595
Other Sources (Uses)
Transfer To General Fund $ ‐ $ ‐ $ ‐ $ ‐ $ 95,000 $ 95,000 $ 95,000 $ 95,000
Transfer To Future Capital Project Rese ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
Total Other Sources (Uses) $ ‐ $ ‐ $ ‐ $ ‐ $ 95,000 $ 95,000 $ 95,000 $ 95,000
Net Increase (Decrease) $ 523,295 $ 350,575 $ 216,662 $ (139,428) $ (137,331) $ 57,000 $ 60,905 $ (351,595)
Ending Fund Balance $ 1,313,981 $ 1,417,640 $ 1,530,643 $ 1,174,553 $ 1,393,312 $ 1,450,312 $ 1,511,217 $ 1,159,622
41 FY22 Approved Budget