Loading...
December 2019 - Council Expenditure ReportAs of  1/17/2020 25.00 % Year Complete Executive Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 20,204.86                    65,383.04                    267,156.00                  24.47% 16,709.67                    54,249.64                    3,495.19                                11,133.40                   Benefits 2,495.47                      8,236.79                      35,188.00                    23.41% 2,010.59                      6,805.31                      484.88                                    1,431.48                     Operations 3,608.98                      26,049.88                    162,775.00                  16.00% 17,134.26                    33,043.14                    (13,525.28)                             (6,993.26)                   Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 26,309.31                    99,669.71                    465,119.00                  21.43% 35,854.52                    94,098.09                    (9,545.21)                               5,571.62                     Legislative Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 10,417.04                    31,251.12                    125,000.00                  25.00% 10,417.04                    31,251.12                    ‐                                          ‐                               Benefits 761.00                          2,269.80                      10,299.00                    22.04% 711.22                          2,211.70                      49.78                                      58.10                          Operations 225.00                          1,508.38                      13,300.00                    11.34% ‐                                689.77                          225.00                                    818.61                        Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 11,403.04                    35,029.30                    148,599.00                  23.57% 11,128.26                    34,152.59                    274.78                                    876.71                        Finance Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 24,898.64                    73,391.02                    360,253.00                  20.37% 22,156.57                    60,000.46                    2,742.07                                13,390.56                   Benefits 4,045.61                      11,646.43                    60,616.00                    19.21% 3,628.17                      10,469.35                    417.44                                    1,177.08                     Operations 11,777.24                    35,822.86                    240,360.00                  14.90% 6,162.85                      21,902.02                    5,614.39                                13,920.84                   Capital Outlay ‐                                ‐                                0.00% ‐                                          ‐                               Total 40,721.49                    120,860.31                  661,229.00                  18.28% 31,947.59                    92,371.83                    8,773.90                                28,488.48                   City Clerk Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 10,825.53                    32,205.87                    139,619.00                  23.07% 10,355.14                    27,311.80                    470.39                                    4,894.07                     Benefits 1,747.10                      5,288.15                      24,068.00                    21.97% 1,594.54                      4,648.15                      152.56                                    640.00                        Operations 3,004.80                      7,297.75                      108,240.00                  6.74% 1,202.03                      5,807.79                      1,802.77                                1,489.96                     Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               Total 15,577.43                    44,791.77                    271,927.00                  16.47% 13,151.71                    37,767.74                    2,425.72                                7,024.03                     HR Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 23,656.55                    70,870.36                    308,420.00                  22.98% 21,594.53                    59,304.29                    2,062.02                                11,566.07                   Benefits 4,156.29                      12,591.96                    56,426.00                    22.32% 3,790.13                      11,116.77                    366.16                                    1,475.19                     Operations 7,832.13                      16,198.72                    72,275.00                    22.41% 9,087.30                      20,433.78                    (1,255.17)                               (4,235.06)                   Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               Total 35,644.97                    99,661.04                    437,121.00                  22.80% 34,471.96                    90,854.84                    1,173.01                                8,806.20                     IT Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 14,963.08                    43,512.33                    195,466.00                  22.26% 13,701.36                    36,455.54                    1,261.72                                7,056.79                     Benefits 2,240.94                      6,527.95                      30,262.00                    21.57% 2,040.64                      5,693.98                      200.30                                    833.97                        Operations 189,535.35                  426,690.54                  1,371,831.00              31.10% 167,499.55                  367,441.45                  22,035.80                              59,249.09                   Capital Outlay 6,390.50                      6,390.50                      200,000.00                  3.20% ‐                                ‐                                6,390.50                                6,390.50                     Total 213,129.87                  483,121.32                  1,797,559.00              26.88% 183,241.55                  409,590.97                  29,888.32                              73,530.35                   Vehicle Maint. Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 17,946.40                    52,259.76                    228,594.00                  22.86% 18,689.82                    52,074.54                    (743.42)                                  185.22                        Benefits 2,954.57                      8,661.80                      43,245.00                    20.03% 3,119.42                      9,187.17                      (164.85)                                  (525.37)                       Operations 5,236.95                      28,636.14                    98,650.00                    29.03% 3,498.56                      11,484.49                    1,738.39                                17,151.65                   Capital Outlay ‐                                ‐                                37,000.00                    0.00% ‐                                ‐                                ‐                                          ‐                               Total 26,137.92                    89,557.70                    407,489.00                  21.98% 25,307.80                    72,746.20                    830.12                                    16,811.50                   City of Prattville December Unaudited Expenditures By Department Engineering Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 34,290.60                    109,004.33                 552,052.00                 19.75% 36,556.97                    100,962.14                 (2,266.37)                               8,042.19                     Benefits 6,022.74                      18,994.72                    113,511.00                 16.73% 6,562.78                      19,344.09                    (540.04)                                  (349.37)                       Operations 15,343.13                    104,165.57                 566,300.00                 18.39% 18,813.35                    68,880.03                    (3,470.22)                               35,285.54                  Capital Outlay ‐                                ‐                                333,718.00                 0.00% ‐                                ‐                                ‐                                          ‐                              Total 55,656.47                    232,164.62                 1,565,581.00              14.83% 61,933.10                    189,186.26                 (6,276.63)                               42,978.36                  Planning Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 25,974.88                    72,012.87                    335,243.00                 21.48% 16,884.36                    37,553.24                    9,090.52                                34,459.63                  Benefits 4,563.24                      12,818.75                    60,022.00                    21.36% 3,003.56                      6,953.50                      1,559.68                                5,865.25                     Operations 36,733.80                    134,706.71                 727,450.00                 18.52% 36,166.36                    84,628.84                    567.44                                   50,077.87                  Capital Outlay ‐                               ‐                              ‐                                0.00% ‐                                ‐                                ‐                                          ‐                              Total 67,271.92                    219,538.33                 1,122,715.00              19.55% 56,054.28                    129,135.58                 11,217.64                              90,402.75                  Urban Management Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 70,168.47                    198,407.36                 927,120.00                 21.40% 66,532.02                    157,510.11                 3,636.45                                40,897.25                  Benefits 11,218.70                    31,828.45                    167,371.00                 19.02% 9,359.88                      25,145.44                    1,858.82                                6,683.01                     Operations 29,278.70                    139,224.09                 493,000.00                 28.24% 33,260.57                    126,030.46                 (3,981.87)                               13,193.63                  Capital Outlay ‐                                ‐                                30,000.00                    0.00% ‐                                ‐                                ‐                                          ‐                              Total 110,665.87                 369,459.90                 1,617,491.00              22.84% 109,152.47                 308,686.01                 1,513.40                                60,773.89                  Facilities Maintenance Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 28,070.13                    82,872.15                    363,631.00                 22.79% 25,169.38                    68,401.19                    2,900.75                                14,470.96                  Benefits 4,310.19                      12,734.15                    59,507.00                    21.40% 3,810.37                      10,922.12                    499.82                                   1,812.03                     Operations 4,544.99                      35,194.38                    237,050.00                 14.85% 14,907.29                    42,382.65                    (10,362.30)                            (7,188.27)                   Capital Outlay ‐                                ‐                                48,626.00                    0.00% ‐                                ‐                                ‐                                          ‐                              Total 36,925.31                    130,800.68                 708,814.00                 18.45% 43,887.04                    121,705.96                 (6,961.73)                               9,094.72                     Public Works Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 24,555.73                    69,749.14                    312,653.00                 22.31% 19,873.89                    54,517.63                    4,681.84                                15,231.51                  Benefits 4,210.07                      12,048.18                    58,569.00                    20.57% 3,379.47                      9,822.37                      830.60                                   2,225.81                     Operations 18,622.79                    57,992.54                    224,718.00                 25.81% 22,881.34                    56,020.44                    (4,258.55)                               1,972.10                     Capital Outlay 6,210.00                      6,210.00                      225,000.00                 2.76% ‐                                ‐                                6,210.00                                6,210.00                     Total 53,598.59                    145,999.86                 820,940.00                 17.78% 46,134.70                    120,360.44                 7,463.89                                25,639.42                  Police Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 422,459.47                 1,230,040.68              5,557,043.00              22.13% 387,761.54                 1,020,064.27              34,697.93                              209,976.41                Benefits 70,628.71                    203,505.85                 1,044,030.00              19.49% 64,547.30                    181,856.90                 6,081.41                                21,648.95                  Operations 245,404.35                 526,225.06                 1,425,809.00              36.91% 54,611.75                    275,962.03                 190,792.60                           250,263.03                Capital Outlay 64,124.28                    64,124.28                    133,600.00                 48.00% ‐                                ‐                                64,124.28                              64,124.28                  Total 802,616.81                 2,023,895.87              8,160,482.00              24.80% 506,920.59                 1,477,883.20              295,696.22                           546,012.67                Fire Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 406,606.07                 1,196,883.37              5,047,501.00              23.71% 367,622.21                 966,249.97                 38,983.86                              230,633.40                Benefits 71,205.66                    207,224.20                 1,012,418.00              20.47% 64,592.56                    179,759.21                 6,613.10                                27,464.99                  Operations 35,584.80                    196,903.26                 1,044,321.00              18.85% 81,047.71                    233,767.01                 (45,462.91)                            (36,863.75)                 Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                              Total 513,396.53                 1,601,010.83              7,104,240.00              22.54% 513,262.48                 1,379,776.19              134.05                                   221,234.64                Building Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 18,804.81                    56,137.92                    244,473.00                 22.96% 22,623.70                    62,162.51                    (3,818.89)                               (6,024.59)                   Benefits 3,271.38                      9,843.27                      49,214.00                    20.00% 4,002.07                      11,655.62                    (730.69)                                  (1,812.35)                   Operations 912.44                         19,973.15                    55,450.00                    36.02% 1,905.35                      17,219.53                    (992.91)                                  2,753.62                     Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                              Total 22,988.63                    85,954.34                    349,137.00                 24.62% 28,531.12                    91,037.66                    (5,542.49)                               (5,083.32)                   Parks & Recreation Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 77,370.70                    227,617.13                 1,005,486.00              22.64% 57,448.40                    158,592.86                 19,922.30                              69,024.27                  Benefits 12,130.16                    35,407.43                    169,471.00                 20.89% 9,036.50                      25,966.21                    3,093.66                                9,441.22                     Operations 71,912.53                    286,102.41                 1,174,070.00              24.37% 55,150.77                    189,452.11                 16,761.76                              96,650.30                  Capital Outlay/ Capital Projects ‐                                ‐                                200,400.00                 0.00% ‐                                ‐                                ‐                                          ‐                              Total 161,413.39                 549,126.97                 2,549,427.00              21.54% 121,635.67                 374,011.18                 39,777.72                              175,115.79                Performing Arts Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 9,178.97                      26,160.64                    106,627.00                 24.53% 6,647.85                      17,975.24                    2,531.12                                8,185.40                     Benefits 1,308.88                      3,813.63                      15,770.00                    24.18% 1,017.05                      2,869.65                      291.83                                   943.98                        Operations 15,460.22                    39,371.40                    266,690.00                 14.76% 11,444.40                    35,534.80                    4,015.82                                3,836.60                     Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                              Total 25,948.07                    69,345.67                    389,087.00                 17.82% 19,109.30                    56,379.69                    6,838.77                                12,965.98                  Non‐Departmental Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference City ‐ County Svcs 17,083.34                    118,333.36                 425,000.00                 27.84% 23,333.34                    114,166.68                 (6,250.00)                               4,166.68                     Community Initiatives 110,952.86                 287,731.58                 979,274.00                 29.38% 71,934.31                    229,080.69                 39,018.55                              58,650.89                  Transfer to DSF ‐ One Cent ‐                                1,925,105.53              3,394,441.00              56.71% ‐                                1,880,628.47              ‐                                          44,477.06                  Transfer to DSF ‐ Other ‐                                225,490.92                 664,029.00                 33.96% ‐                                84,218.42                    ‐                                          141,272.50                Transfer to Group Health 249,583.33                 748,749.99                 2,995,000.00              25.00% 247,167.00                 741,501.00                 2,416.33                                7,248.99                     Transfer to Capital Project Fund ‐                                10,772.24                    75,000.00                    14.36% 12,026.21                    42,017.58                    (12,026.21)                            (31,245.34)                 Transfer to Gas Tax Fund ‐                                ‐                                22,000.00                    0.00% ‐                                ‐                                ‐                                          ‐                              Transfer to Judicial ‐                                121,794.00                 0.00% ‐                                ‐                                ‐                                          ‐                              Total 377,619.53                 3,316,183.62              8,676,538.00              38.22% 354,460.86                 3,091,612.84              23,158.67                              224,570.78                Debt Service Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Debt Service 188,411.76                 444,286.51                 1,728,000.00              25.71% 36,694.16                    275,952.00                 151,717.60                           168,334.51                Total 188,411.76                 444,286.51                 1,728,000.00              25.71% 36,694.16                    275,952.00                 151,717.60                           168,334.51                Total Dec‐19 YTD Budget % of Budget Dec‐18 YTD December Difference YTD Difference Salary 1,240,391.93              3,637,759.09              16,076,337.00            22.63% 1,120,744.45              2,964,636.55              119,647.48                           673,122.54                Benefits 456,854.04                 1,352,191.50              6,004,987.00              22.52% 433,373.25                 1,265,928.54              23,480.79                              86,262.96                  Operations 823,054.40                 2,498,900.02              9,905,357.00              25.23% 642,067.30                 1,975,945.29              180,987.10                           522,954.73                Capital Outlay 76,724.78                    76,724.78                    1,208,344.00              6.35% ‐                                ‐                                76,724.78                              76,724.78                  Debt Service 188,411.76                 2,594,882.96              5,786,470.00              44.84% 36,694.16                    2,240,798.89              151,717.60                           354,084.07                Total 2,785,436.91              10,160,458.35            38,981,495.00            26.06% 2,232,879.16              8,447,309.27              552,557.75                           1,713,149.08             Prepared by      Daniel Oakley