Page 49 - CityofTrophyClubFY26Budget
P. 49

FY 2025
       CCPD Fund                            FY 2022      FY 2023      FY 2024     FY 2025      FY 2025      YEAR TO      FY 2026     FY 2027
                                                         ACTUAL
                                            ACTUAL
                                                                                              AMENDED
                                                                                 APPROVED
                                                                      ACTUAL
                                                                                                             DATE      PROPOSED     PROJECTED
      Beginning Fund Balance               $      274,127  $     280,480  $     257,573  $       312,685  $     312,685  $     312,685  $       388,855  $     279,859





       Revenue
          Sales Tax                        $     365,464   $     373,794   $     424,044   $     360,500   $     360,500   $     334,052   $     425,000   $     437,750
          Grant Revenue                                    483            21,525            12,700              4,000              4,000  -                 4,120              4,244

          Interest Income                              -                 971                 570              1,030                1,030                   478                1,061              1,093



          Assets Sold                               -               10,000    -            -           -            -            -            -
      Total Revenue                        $       365,947  $       406,290  $     437,314  $     365,530  $       365,530  $     334,530  $     430,181  $     443,086





       Expenditures
      Personnel
         Salaries                            $                -     $                -     $                -     $                -     $                -     $                -   $        71,733 $        73,885


         Overtime                                   -            13,700            16,556            20,400            20,400  -            25,000            25,750
         Retirement                                    -              1,644                2,185              2,840                2,840    -            13,920            14,337


         Medical Insurance                          -                   685                   943  -    -             -            17,071     -



        Dental Insurance                            -           41          78             -             -            -              1,456      -


         Vision Insurance                             -            4        14             -             -          -                     258    -

         Life Insurance & Other                     -           33            71           -             -          -                   723   -



          Social Security Taxes                       -            -                1,074              1,265              1,265    -                5,997              6,177




         Medicare Taxes                               -            -                   241                   296                 296  -                1,403              1,445

          Unemployment Taxes                        -              -         2             -             -          -                     252                 260





          Workers' Compensation                     -                     585                   164              1,087                1,087                 209              3,364              3,465
      Total Personnel                       $        -   $       16,692   $       21,328   $       25,888   $       25,888   $             209   $     141,177   $     125,319
      Services & Supplies
          Professional Outside Services    $        47,913 $        40,468 $        41,402 $        45,000 $        45,000 $        39,611 $        35,000 $        36,050
          Schools & Training                          23,571            16,408            21,440            21,500            21,500            15,267            25,000            25,750

          Equipment Maintenance                      -           -                   530   -           -              -          -            -
          Qualifying Expenses                         16,813              7,294            19,716            21,500            21,500            18,877            25,000            25,750
          Meetings                                     -                   272                1,266                   800                 800    -                   825                   850

          Office Supplies                               1,932              3,135              5,160                 600                 600                 731              2,600              2,678
          Postage                                           245    -          48                 100                 100  -                  1,060                1,092


          Publications/Books/Subscription            51              3,952                 283                 500                 500  -                    515                 530
          Uniforms                                     4,920            19,372            11,430                8,000                8,000                   600              8,000              8,240



          Protective Clothing                       -            -                    855  -           -            -            -            -
          Small Equipment                            48,198            73,111            45,898            75,000            75,000            34,060           120,000         123,600


          Principle - Lease Payment                   33,273     -            -            -           -            -            -            -

          Interest - Lease Payment                        157    -            -            -           -            -            -            -
        Total Services & Supplies          $      177,073 $      164,013 $      148,029 $      173,000 $      173,000 $      109,147 $      218,000 $      224,540
      Capital
          Capital Outlay                   $     273,098   $     248,492   $     212,844   $     160,000   $     204,331   $     149,003   $     180,000   $     185,400
        Total Capital                      $      273,098  $     248,492  $       212,844  $       160,000  $       204,331  $     149,003  $       180,000  $     185,400



      Total Expenditures                   $      450,171  $     429,197  $     382,201  $     358,888  $       403,219  $     258,359  $     539,177  $       535,259





       Other Sources (Uses)
          Transfer Out                       $                -     $                -     $                -     $                -     $                -     $                -     $                -   $               -
          Lease Proceeds                              90,577     -            -            -           -            -            -            -
      Total Other Sources (Uses)           $        90,577 $                   - $                   - $                   - $                   - $                   - $                   -  $                -
      Net Increase (Decrease)              $          6,353  $      (22,907) $        55,113  $          6,642  $      (37,689) $        76,171  $    (108,997) $       (92,173)


      Ending Fund Balance                  $     280,480   $     257,573   $     312,685   $     319,327   $     274,996   $     388,855   $     279,859  $      187,686
                                PERSONNEL SCHEDULE
      POSITION TITLE                        FY 2024      FY 2025      FY 2026
      POLICE CADET                            0.00        0.00         1.00
      TOTAL FTEs                              0.00         0.00        1.00
               FY26 Adopted Budget                                        41                                                    9/9/25
   44   45   46   47   48   49   50   51   52   53   54