Page 49 - CityofTrophyClubFY25AdoptedBudget
P. 49

FY2024-25 Approved Budget


   Storm Drainage                  FY 2021    FY 2022   FY 2023   FY 2024    FY 2024   FY 2024 YEAR   FY 2025   FY 2026

   Utility                         ACTUAL     ACTUAL    ACTUAL   APPROVED   AMENDED    TO DATE   APPROVED  PROJECTED
   Beginning Working Capital      $    1,731,975  $    2,178,395  $  2,635,282  $     872,424   $     872,424  $    3,074,607  $  3,294,643   $  3,285,790


    Revenue
       Storm Drainage Fee          $     435,798   $     435,559   $     437,219   $     430,000   $     430,000   $       361,348   $     438,600   $     451,758
       Hazardous Waste Stipend              -         -        -         -           -          -        -         -
       Miscellaneous Revenue              -         -            -       -         -          -            -       -
       Interest Income                           325                8,264            62,757              5,000              5,000               60,459            40,000            41,200



   Total Revenue                  $      436,123  $      443,823  $     499,977   $     435,000   $       435,000  $       421,806  $     478,600   $     492,958

   Expenses
   Personnel
       Salaries                   $       -    $    -    $     -    $        50,213 $        50,213 $          38,703  $       52,793   $       54,377
       Overtime                           -           -        -           -       -            -        -         -

       Longevity                            -       -          -                     187                 187                   187                 226                   232


       Certification Pay                  -         -          -           -       -                       100                 120                 120




       Cell Phone Stipend                   -         -          -                 405                 405                     338                   405                   417

       Retirement                         -           -        -                  6,633                6,633                5,133                8,453              8,707

       Medical Insurance                  -           -        -                2,037                2,037                3,351              4,317                4,447



       Dental Insurance                     -         -          -                   267                 267                   490                   651                 671


       Vision Insurance                     -       -          -                       45                   45                   105                 135                 140







       Life Insurance & Other               -         -        -                   225                 225                   246                 302                   311

       Social Security Taxes                -       -            -              3,113              3,113                   2,353              3,320              3,419





       Medicare Taxes                       -       -            -                   728                 728                   550                   776                 800
       Unemployment Taxes                   -       -          -                     139                 139  5                     139                   143



       Workers' Compensation                -       -          -                1,416                1,416                   260                1,369               1,410

   Total Personnel                $       -    $    -    $              -    $         65,408  $       65,408   $         51,819  $         73,006  $       75,193
   Services & Supplies
       Professional Outside Services   $       19,175   $       19,175   $       27,722   $       30,000   $       30,000   $         35,904   $       30,600   $       31,518



       Engineering/Construction               14,597                9,018            14,088            30,000            30,000                   100         230,600         237,518

       Legal Notices                      -           -        -         -           -                   181                   185                   191



       Trash Removal/Recycling                5,900              2,950                1,700                5,202              5,202                5,545                5,306              5,465


       Street Sweeping                        6,121                7,100                6,660            15,606            15,606                8,350            20,000            20,600


       Independent Labor                    17,395            47,005            72,156         125,000         125,000               79,850         127,500           131,325




       Dues & Membership                         105  -          -                 250                 250  -                     255                   263

       Postage                              -       -            -       -           -         21        -           -
       Depreciation Expense                   51,084            51,083            51,083  -    -    -      -       -


   Total Services & Supplies      $      114,377  $      136,331  $     173,409  $     206,058   $     206,058  $       129,951  $       414,446  $     426,880

   Capital
      Capital Replacement         $       -    $    -    $        41,261 $  -    $  -    $    -    $     -     $                -
     Capital Expense                      -           -          -         -       -            -          -         -

      Capital Projects                    -         -          -           150,000           150,000    -  -         -
     Transfer to Drainage Capital Projects  -       -          -           -         -        -            -         -
   Total Capital                  $       -    $    -    $         41,261  $     150,000   $       150,000  $                -  $              -    $              -
   Debt Service
       Principal                  $     (160,000) $  -     $                -    $  -     $                -    $  -     $                -     $                -
       Interest                             11,789    -              (4,018)  -      -          -          -         -

   Total Debt Service             $      (148,211) $  -    $        (4,018) $               -  $                -  $                -  $                -  $                -

   Total Expenses                 $        (33,834) $      136,331  $     210,652  $     421,466  $       421,466  $       181,770   $       487,453  $     502,073



    Other Sources (Uses)
       Cumulative effect on change in account $  -    $  -     $                -    $  -     $                -    $  -     $                -     $                -

       Transfer In                          16,463         177,194         170,000    -    -    -        -           -


       Transfer to General Fund             (40,000)          (20,000)          (20,000)          (20,000)          (20,000)            (20,000)  -      -
       Transfer To Debt Service           -                (7,799)  -      -       -            -        -         -
   Total Other Sources            $       (23,537) $      149,395  $     150,000  $      (20,000)   $        (20,000) $         (20,000) $               -  $                -

   Net Increase (Decrease)        $      446,420  $      456,887  $      439,325  $         (6,466) $         (6,466) $        220,036  $         (8,853) $         (9,115)
   Ending Working Capital          $ 2,178,395   $ 2,635,282   $ 3,074,607   $     865,958   $     865,958   $   3,294,643   $ 3,285,790   $ 3,276,675
             FY 2024-2025                                 41                    Approved Annual Budget
   44   45   46   47   48   49   50   51   52   53   54