Page 52 - CityofTrophyClubFY26Budget
P. 52

Street Maintenance              FY 2022    FY 2023   FY 2024   FY 2025   FY 2025    FY 2025   FY 2026   FY 2027
                                                                                         YEAR TO
      Fund                            ACTUAL     ACTUAL    ACTUAL   APPROVED  AMENDED      DATE    PROPOSED  PROJECTED
      Beginning Fund Balance         $      302,900  $      436,698  $      426,985  $      508,668  $      508,668  $      508,668  $      634,771  $      533,360
      Revenue
          Sales Tax                   $     361,485  $     370,715  $     418,021  $     357,000  $     357,000  $     336,255  $     400,000  $     412,000
          Interest Income                    ‐                 2,038               1,036               1,530               1,530               1,044               1,576               1,623
      Total Revenue                  $      361,485  $      372,753  $      419,057  $      358,530  $      358,530  $      337,299  $      401,576  $      413,623
      Expenditures
      Personnel
          Salaries                    $       73,413  $       80,449  $     119,770  $     126,817  $     126,817  $       87,565  $     150,998  $     155,528
          Salaries ‐ Part‐Time               ‐           ‐          ‐       ‐         ‐                 1,594
          Salaries ‐ Overtime                        791               2,702               1,400               2,500               2,500               1,369               2,500              2,575
          Longevity                               1,523               1,649               1,828               1,975               1,975               1,975               2,122               2,185
          Certification Pay                  ‐           ‐                  116                  120                  120    79                  120                  124

          Cell Phone Stipend                        343                  332                  582                  585                  585                  456                  675                 695
          Retirement                            10,090            10,573            16,312            18,026            18,026            12,588            22,148            22,813
         457 Contributions                   ‐         ‐          ‐         ‐         ‐                         1,000              1,000
          Medical Insurance                       4,514               5,034            10,294            10,707            10,707               7,983            11,253            11,591
          Dental Insurance                           531                  591               1,663               1,755               1,755               1,172               2,114               2,178

          Vision Insurance                  87                  104                  357                  367                  367                  242                  369                  380
          Life Insurance & Other                     420                  426                  765                  688                  688                  536               1,163               1,198
          Social Security Taxes                   4,766               3,568               7,556               8,029               8,029               5,689               9,524               9,810
          Medicare Taxes                          1,115                  834               1,800               1,878               1,878               1,322               2,227               2,294
          Unemployment Taxes                          (39)  13  16                  441                  441                  190                  441                  454



          Workers' Compensation                  3,301               4,553               2,481               7,156               7,156               1,374               8,571               8,828
      Total Personnel                $      100,855  $      110,827  $      164,941  $      181,044  $      181,044  $      124,133  $      215,225  $      221,652
      Services & Supplies
          Professional Outside Services   $                ‐     $                ‐     $                ‐     $                ‐     $                ‐     $         6,472  $       10,000  $       10,300
          Water                              ‐           ‐          ‐               2,123               2,123  ‐      ‐  ‐
          Communications/Pagers/Mobiles      ‐           ‐        ‐           ‐       ‐           ‐        ‐         ‐
          Vehicle Maintenance                     2,615               3,151               2,060               7,500               7,500               2,718               7,500               7,725
          Equipment Maintenance                   1,420               1,322               2,767               3,060               3,060               1,957               3,121               3,215
          Street Maintenance                   77,207            88,526            82,518          127,500          127,500            71,955          100,000          103,000

          Signs & Markings                      17,073            20,603            27,665            47,000            47,000               6,739            52,000            53,560
          Fuel                                    5,653               6,347               6,335               7,000               7,000               3,541               7,140               7,354
          Small Tools                              2,322                  302               2,090               3,000               3,000                  155               3,000               3,090
          Miscellaneous Expense                      542                  359  ‐      ‐    ‐    ‐          ‐           ‐
      Total Service & Supplies       $      106,832  $      120,610  $      123,434  $      197,183  $      197,183  $        87,064  $      172,761  $      177,944
      Capital
          Vehicles                    $      ‐   $      ‐   $     ‐   $     ‐   $     ‐   $      ‐   $     ‐   $                ‐
          Capital Replacement                ‐               51,529  ‐      ‐         ‐         ‐          ‐           ‐
          Capital Outlay                     ‐               79,500            28,999  ‐                 2,123  ‐             115,000          118,450
      Total Capital                  $              ‐    $      131,029  $        28,999  $              ‐    $          2,123  $              ‐    $      115,000  $      118,450

      Other Sources (Uses)
          Transfer to General Fund    $       20,000  $       20,000  $       20,000  $  ‐   $  ‐   $  ‐   $  ‐   $                ‐
          Transfer To Debt Service           ‐         ‐          ‐           ‐         ‐       ‐          ‐         ‐
          Transfer Out                       ‐           ‐          ‐         ‐         ‐         ‐                  ‐
          Transfer To Storm Drainage         ‐           ‐          ‐         ‐         ‐         ‐        ‐           ‐
      Total Sources Other (Uses)     $        20,000  $        20,000  $        20,000  $                ‐  $              ‐    $                ‐  $              ‐    $              ‐
      Net Increase (Decreases)       $      133,798  $         (9,713) $        81,683  $       (19,697) $       (21,820) $      126,102  $     (101,410) $     (104,422)
      Ending Fund Balance             $     436,698  $     426,985  $     508,668  $     488,972  $     486,849  $     634,771  $     533,360  $     428,938

                            PERSONNEL SCHEDULE
      POSITION TITLE                  FY 2024    FY 2025   FY 2026
      STREETS CREW LEADER              1.00       1.00      1.00
      COMMUNITY DEVELOPMENT DIR.       0.25       0.25      0.25   50% Funded by General Fund ‐ 25% Funded by Drainage
      STREETS SUPERINTENDENT           0.40       0.40      0.40   40% Funded by General Fund ‐ 20% Funded by Drainage
      SENIOR ADMINISTRATIVE ASSISTANT  0.10       0.10      0.10   80% Funded by General Fund ‐ 10% Funded by Drainage
      TOTAL FTEs                        1.75      1.75      1.75
               FY26 Adopted Budget                           44                                        9/9/25
   47   48   49   50   51   52   53   54   55   56   57