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
   38   39   40   41   42   43   44   45   46   47   48