Page 4 - Dalworthington Gardens FY21 Budget
P. 4

09/17/2020
                                                                               FY 20/21 BUDGET - TOTAL EXPENSES BY DEPARTMENT


                                                  EXPENSE CATEGORY           OTHER USES   COMM DEV      COURT        ADMIN        POLICE        FF         PW        TOTAL

                                                  Personnel Salary & Wages                              111,735                  59,467               114,302            1,069,132               173,937              56,128          1,584,700
                                                  Personnel Taxes & Benefits                              42,933                  26,719                  49,029               482,168                  56,282              29,477             686,609
                                                  Training & Travel                                         2,291                    2,883                    3,175                  30,900                  24,090                1,300               64,638
                                                  Materials & Supplies                                  7,095.00                    2,615                  18,870                  66,935                  64,424                9,873             169,813

                                                  Utilities                                             1,080.00                        -                  37,531                    7,063                    1,543              26,904               74,121

                                                  Maintenance                                         3,500.00                        -                    7,080                  34,300                  30,000              26,340             101,220

                                                  Consultants                                           1,100.00                  94,685                  60,800                  10,500                       500                3,200             170,785
                                                  Contractual                                       31,483.80                  15,650                  86,064               122,027                  32,666                6,136             294,026

                                                  Other Expenses                                        1,406.25                       240                  13,746                  38,105                  70,571                   100             124,168
                                                  Capital Outlay                                                -                         -                         -                         -                  10,000                      -                10,000
                                                  Other Uses                                 10,000                                                                              10,000
                                                  Transfer to Gas Reserve                    60,000                                                                              60,000
                                                  Transfer to Fire Truck Fund                            -                                                                             -
                                                        TOTAL EXPENSES                       70,000                202,624               202,259               390,597            1,861,130               464,013           159,459          3,350,081
                                                                                2%           6%           6%          12%          56%         14%          5%        100%

                                                                                 FY 19/20 PROJECTED - TOTAL EXPENSES BY DEPARTMENT


                                                  EXPENSE CATEGORY           OTHER USES   COMM DEV      COURT        ADMIN        POLICE        FF         PW        TOTAL
                                                  Personnel Salary & Wages                              110,419                  56,319               123,612               927,139               139,792              36,223          1,393,505
                                                  Personnel Taxes & Benefits                              42,395                  24,483                  47,739               394,937                  46,685              18,029             574,268
                                                  Training & Travel                                         1,241                       242                       997                  26,731                  10,058                    -                39,269
                                                  Materials & Supplies                                      7,208                    1,060                  17,392                  54,918                  43,700                3,229             127,508
                                                  Utilities                                                 1,075                        -                  37,036                       6,254                    1,811              25,960               72,137

                                                  Maintenance                                               2,800                        -                    7,030                  35,212                  28,344              10,791               84,177
                                                  Consultants                                               1,715                  90,851                  62,197                    8,967                        -                2,931              166,662

                                                  Contractual                                             31,194                  14,077                  90,482               112,331                  36,349                7,609             292,043
                                                  Other Expenses                                            1,871                       268                    7,185                  36,215                    7,820                   172               53,531
                                                  Capital Outlay                                               299                    1,197                       299                    7,067               841,347                4,224             854,433
                                                  Other Uses                                 10,000                                                                              10,000
                                                  Transfer to Gas Reserve                  125,712                                                                              125,712
                                                  Transfer to Fire Truck Fund                            -                                                                             -
                                                        TOTAL EXPENSES                     135,712                200,216               188,499               393,968            1,609,773            1,155,907           109,170          3,793,244
                                                                                4%           5%           5%          10%          42%         30%          3%        100%

                                                                   FY 20/21 BUDGET vs FY 19/20 PROJECTED VARIANCE OF EXPENSES BY DEPARTMENT


                                                  EXPENSE CATEGORY                        COMM DEV      COURT        ADMIN        POLICE        FF         PW        TOTAL
                                                  Personnel Salary & Wages                          -                       1,316                    3,147                  (9,310)               141,993                  34,144              19,905             191,196
                                                  Personnel Taxes & Benefits                            -                        538                    2,236                    1,290                  87,232                    9,597              11,448             112,341
                                                  Training & Travel                                -                       1,050                    2,641                    2,178                    4,169                  14,032                1,300               25,370
                                                  Materials & Supplies                               -                       (113)                    1,555                    1,478                  12,017                  20,724                6,644               42,305

                                                  Utilities                                        -                              5                        -                        495                       809                      (268)                   944                 1,984
                                                  Maintenance                                        -                        700                        -                          50                      (912)                    1,656              15,549               17,043
                                                  Consultants                                        -                       (615)                    3,834                  (1,397)                    1,533                       500                   269                 4,123
                                                  Contractual                                        -                        290                    1,573                  (4,418)                    9,695                  (3,683)              (1,474)                 1,983
                                                  Other Expenses                                     -                       (464)                        (28)                    6,562                    1,889                  62,751                    (72)               70,637
                                                  Capital Outlay                                   -                         (299)                  (1,197)                      (299)                  (7,067)              (831,347)              (4,224)           (844,433)
                                                  Other Uses                                       -                           -                         -                         -                         -                         -                     -                      -
                                                  Transfer to Gas Reserve                   (65,712)                        -                         -                         -                         -                         -                     -                      -
                                                  Transfer to Fire Truck Fund                            -                         -                         -                         -                         -                         -                     -                      -
                                                        TOTAL EXPENSES                      (65,712)                    2,408                  13,760                  (3,372)               251,357              (691,894)              50,289           (377,452)
                                                                                17%          -1%          -4%         1%          -67%         183%        -13%       100%
                                                                                                                                                                                                                         Page 3 of 48
   1   2   3   4   5   6   7   8   9