Loading...
September 2019 - Council Expenditure ReportAs of  10/11/2019 100.00 % Year Complete Executive Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 23,570.61                   278,648.78                 322,551.00                 86.39% 19,971.33                   253,509.02                 3,599.28                               25,139.76                   Benefits 3,031.27                     35,278.77                   45,781.00                   77.06% 2,897.70                     32,697.94                   133.57                                   2,580.83                     Operations 7,406.94                     97,197.66                   137,333.00                 70.78% 8,520.10                     75,625.78                   (1,113.16)                              21,571.88                   Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 34,008.82                   411,125.21                 505,665.00                 81.30% 31,389.13                   361,832.74                 2,619.69                               49,292.47                   Legislative Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 10,417.04                   125,004.48                 125,000.00                 100.00% 10,417.04                   125,004.48                  ‐                                          ‐                               Benefits 711.22                         9,193.53                     10,297.00                   89.28% 750.24                         9,324.54                     (39.02)                                    (131.01)                       Operations 1,022.00                     13,106.35                   13,600.00                   96.37% 342.65                         8,977.21                     679.35                                   4,129.14                     Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 12,150.26                   147,304.36                 148,897.00                 98.93% 11,509.93                   143,306.23                 640.33                                   3,998.13                     Finance Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 22,868.38                   289,342.88                 334,879.00                 86.40% 21,347.10                   289,850.78                 1,521.28                               (507.90)                       Benefits 3,760.03                     48,421.98                   56,680.00                   85.43% 3,304.92                     45,112.73                   455.11                                   3,309.25                     Operations 8,785.86                     211,619.49                 242,460.00                 87.28% 36,041.25                   254,339.25                 (27,255.39)                            (42,719.76)                 Capital Outlay ‐                                ‐                               0.00% 1,502.00                     1,502.00                     (1,502.00)                              (1,502.00)                   Total 35,414.27                   549,384.35                 634,019.00                 86.65% 62,195.27                   590,804.76                 (26,781.00)                            (41,420.41)                 City Clerk Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 10,327.95                   130,547.58                 136,748.00                 95.47% 9,867.75                     125,651.14                 460.20                                   4,896.44                     Benefits 1,646.61                     21,276.61                   22,759.00                   93.49% 1,450.74                     18,640.47                   195.87                                   2,636.14                     Operations 3,635.53                     34,572.25                   45,750.00                   75.57% 5,500.92                     67,064.12                   (1,865.39)                              (32,491.87)                 Capital Outlay ‐                                ‐                                ‐                               0.00%‐                               365.00                          ‐                                         (365.00)                       Total 15,610.09                   186,396.44                 205,257.00                 90.81% 16,819.41                   211,720.73                 (1,209.32)                              (25,324.29)                 HR Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 22,401.95                   282,491.96                 283,708.00                 99.57% 21,239.00                   255,598.25                 1,162.95                               26,893.71                   Benefits 3,928.62                     50,753.84                   52,021.00                   97.56% 3,445.66                     42,035.84                   482.96                                   8,718.00                     Operations 12,594.51                   73,264.11                   71,100.00                   103.04% 7,910.57                     122,711.99                 4,683.94                               (49,447.88)                 Capital Outlay ‐                               10,950.00                   10,950.00                   0.00%‐                                ‐                                ‐                                         10,950.00                   Total 38,925.08                   417,459.91                 417,779.00                 99.92% 32,595.23                   420,346.08                 6,329.85                               (2,886.17)                   IT Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 13,420.77                   167,843.37                 168,121.00                 99.83% 12,470.58                   161,807.83                 950.19                                   6,035.54                     Benefits 1,997.68                     25,577.09                   26,061.00                   98.14% 1,752.58                     23,121.20                   245.10                                   2,455.89                     Operations 77,778.13                   1,251,136.55             1,399,083.00             89.43% 107,921.98                 1,171,342.39             (30,143.85)                            79,794.16                   Capital Outlay 27,212.00                   130,886.00                 151,331.00                 86.49%‐                               50,234.92                   27,212.00                             80,651.08                   Total 120,408.58                 1,575,443.01             1,744,596.00             90.30% 122,145.14                 1,406,506.34             (1,736.56)                              168,936.67                Vehicle Maint. Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 17,096.89                   234,767.31                 253,371.00                 92.66% 18,690.87                   221,529.30                 (1,593.98)                              13,238.01                   Benefits 2,817.03                     44,378.81                   50,796.00                   87.37% 2,904.35                     43,945.58                   (87.32)                                    433.23                        Operations 9,618.47                     61,832.24                   103,450.00                 59.77% 3,906.27                     37,949.67                   5,712.20                               23,882.57                   Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 29,532.39                   340,978.36                 407,617.00                 83.65% 25,501.49                   303,424.55                 4,030.90                               37,553.81                   City of Prattville September Unaudited Expenditures By Department Engineering Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 35,634.93                   463,586.70                488,503.00                94.90% 36,270.72                   450,453.14                (635.79)                                 13,133.56                  Benefits 6,411.01                     96,631.42                   102,847.00                93.96% 6,012.17                     89,122.36                   398.84                                  7,509.06                     Operations 56,501.55                   351,376.52                546,500.00                64.30% 24,362.50                   376,686.45                32,139.05                             (25,309.93)                 Capital Projects ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 98,547.49                   911,594.64                1,137,850.00             80.12% 66,645.39                   916,261.95                31,902.10                             (4,667.31)                   Planning Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 21,333.01                   223,520.41                230,589.00                96.93% 39,502.89                   239,450.96                (18,169.88)                           (15,930.55)                 Benefits 3,821.85                     41,038.73                   40,685.00                   100.87% 3,978.53                     36,500.92                   (156.68)                                 4,537.81                     Operations 44,996.93                   410,601.29                490,831.00                83.65% 80,539.68                   505,871.95                (35,542.75)                           (95,270.66)                 Capital Projects ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Capital Outlay ‐                               26,863.00                   32,000.00                   83.95%‐                               6,011.00                      ‐                                         20,852.00                  Total 70,151.79                   702,023.43                794,105.00                88.40% 124,021.10                787,834.83                (53,869.31)                           (85,811.40)                 Urban Management Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 60,164.41                   724,354.45                843,847.00                85.84% 55,078.74                   691,950.81                5,085.67                               32,403.64                  Benefits 9,383.61                     130,012.63                154,697.00                84.04% 8,006.67                     121,463.28                1,376.94                               8,549.35                     Operations 54,785.93                   447,726.85                497,852.00                89.93% 37,746.07                   377,674.14                17,039.86                             70,052.71                  Capital Outlay 9,804.24                     64,059.24                   95,898.00                   66.80%‐                               34,382.39                   9,804.24                               29,676.85                  Total 134,138.19                1,366,153.17             1,592,294.00             85.80% 100,831.48                1,225,470.62             33,306.71                             140,682.55                Facilities Maintenance Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 25,523.50                   322,845.78                330,843.00                97.58% 24,598.63                   293,608.01                924.87                                  29,237.77                  Benefits 3,876.81                     53,254.26                   54,394.00                   97.90% 3,489.76                     51,612.10                   387.05                                  1,642.16                     Operations 6,915.82                     130,320.16                170,000.00                76.66% 4,518.11                     116,671.39                2,397.71                               13,648.77                  Capital Outlay 34,950.00                   107,545.68                163,000.00                65.98% 115,590.06                169,224.48                (80,640.06)                           (61,678.80)                 Total 71,266.13                   613,965.88                718,237.00                85.48% 148,196.56                631,115.98                (76,930.43)                           (17,150.10)                 Public Works Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 20,696.09                   257,169.75                268,409.00                95.81% 18,390.88                   340,892.85                2,305.21                               (83,723.10)                 Benefits 3,507.10                     47,708.84                   50,333.00                   94.79% 2,924.11                     88,218.24                   582.99                                  (40,509.40)                 Operations 4,291.75                     188,429.71                235,214.00                80.11% 10,182.72                   119,192.93                (5,890.97)                              69,236.78                  Capital Outlay 63,216.80                   229,194.30                408,399.00                56.12%‐                               6,550.00                     63,216.80                             222,644.30                Total 91,711.74                   722,502.60                962,355.00                75.08% 31,497.71                   554,854.02                60,214.03                             167,648.58                Police Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 381,070.62                4,758,192.01             5,205,663.00             91.40% 378,732.58                4,769,310.25             2,338.04                               (11,118.24)                 Benefits 63,366.93                   895,499.76                1,003,222.00             89.26% 59,318.06                   926,149.47                4,048.87                               (30,649.71)                 Operations 17,658.55                   1,134,664.34             1,197,488.00             94.75% 49,818.77                   1,114,608.52             (32,160.22)                           20,055.82                  Capital Outlay 176,504.05                298,818.43                287,457.00                103.95% 33,150.00                   249,232.46                143,354.05                          49,585.97                  Total 638,600.15                7,087,174.54             7,693,830.00             92.12% 521,019.41                7,059,300.70             117,580.74                          27,873.84                  Fire Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 360,138.31                4,472,014.12             4,604,544.00             97.12% 354,223.50                4,611,955.93             5,914.81                               (139,941.81)               Benefits 62,766.15                   903,293.71                972,204.00                92.91% 57,063.20                   916,448.12                5,702.95                               (13,154.41)                 Operations 63,885.81                   893,859.69                1,061,540.00             84.20% 63,165.30                   1,010,723.44             720.51                                  (116,863.75)               Capital Outlay ‐                               445,444.00                616,976.00                72.20%‐                               55,150.25                    ‐                                         390,293.75                Total 486,790.27                6,714,611.52             7,255,264.00             92.55% 474,452.00                6,594,277.74             12,338.27                             120,333.78                Building Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 18,068.07                   268,678.03                300,082.00                89.53% 22,549.67                   278,824.44                (4,481.60)                              (10,146.41)                 Benefits 3,153.65                     51,036.57                   59,832.00                   85.30% 3,664.90                     48,923.26                   (511.25)                                 2,113.31                     Operations 2,219.02                     39,589.27                   63,200.00                   62.64% 1,583.08                     41,462.59                   635.94                                  (1,873.32)                   Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 23,440.74                   359,303.87                423,114.00                84.92% 27,797.65                   369,210.29                (4,356.91)                              (9,906.42)                   Parks & Recreation Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 65,857.12                   863,458.75                940,078.00                91.85% 59,258.93                   726,450.51                6,598.19                               137,008.24                Benefits 10,079.20                   143,456.62                140,994.00                101.75% 8,551.52                     117,343.98                1,527.68                               26,112.64                  Operations 140,452.65                1,048,572.10             1,343,500.00             78.05% 119,407.13                890,889.72                21,045.52                             157,682.38                Capital Outlay/ Capital Projects 64,327.00                   559,087.83                754,820.00                74.07% 35,322.74                   227,294.93                29,004.26                             331,792.90                Total 280,715.97                2,614,575.30             3,179,392.00             82.24% 222,540.32                1,961,979.14             58,175.65                             652,596.16                Performing Arts Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 7,302.35                     93,147.77                   91,929.00                   101.33% 5,690.99                     75,434.15                   1,611.36                               17,713.62                  Benefits 1,048.47                     14,139.76                   13,441.00                   105.20% 824.60                        11,061.25                   223.87                                  3,078.51                     Operations 19,659.19                   202,329.33                258,595.00                78.24% 14,793.74                   157,261.38                4,865.45                               45,067.95                  Capital Outlay ‐                               10,514.00                   17,500.00                   60.08%‐                                ‐                                ‐                                         10,514.00                  Total 28,010.01                   320,130.86                381,465.00                83.92% 21,309.33                   243,756.78                6,700.68                               76,374.08                  Non‐Departmental Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference City ‐ County Svcs ‐                               410,000.00                410,000.00                100.00%‐                               400,000.00                 ‐                                         10,000.00                  Community Initiatives 153,445.14                898,398.24                978,094.00                91.85% 145,675.13                825,499.62                7,770.01                               72,898.62                  Transfer to DSF ‐ One Cent ‐                               7,335,956.05             7,343,844.00             99.89%‐                               8,505,423.04              ‐                                         (1,169,466.99)           Transfer to DSF ‐ Other ‐                               226,481.89                331,969.00                68.22%‐                               164,205.83                 ‐                                         62,276.06                  Transfer to Group Health ‐                               2,966,004.00             2,966,000.00             100.00% 249,375.00                2,992,500.00             (249,375.00)                         (26,496.00)                 Transfer to Capital Project Fund 511,611.32                906,561.47                451,255.00                200.90% 242,858.69                1,012,231.37             268,752.63                          (105,669.90)               Transfer to Gas Tax Fund ‐                               188,150.00                188,150.00                100.00%‐                                         188,150.00                Transfer to Judicial ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Total 665,056.46                12,931,551.65           12,669,312.00           102.07% 637,908.82                13,899,859.86           27,147.64                             (968,308.21)               Debt Service Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Debt Service 137,585.45                1,618,722.62             1,530,500.00             105.76% 161,998.75                1,451,972.41             (24,413.30)                           166,750.21                Total 137,585.45                1,618,722.62             1,530,500.00             105.76% 161,998.75                1,451,972.41             (24,413.30)                           166,750.21                Total Sep‐19 YTD Budget % of Budget Sep‐18 YTD September Difference YTD Difference Salary 1,115,892.00             13,955,614.13           14,928,865.00           93.48% 1,108,301.20             13,911,281.85           7,590.80                               44,332.28                  Benefits 185,307.24                5,576,956.93             5,823,044.00             95.77% 419,714.71                5,614,221.28             (234,407.47)                         (37,264.35)                 Operations 1,197,265.10             8,805,157.62             9,904,995.00             88.90% 964,794.66                8,686,783.91             232,470.44                          118,373.71                Capital Outlay 376,014.09                1,883,362.48             2,538,331.00             74.20% 185,564.80                799,947.43                190,449.29                          1,083,415.05             Debt Service 137,585.45                9,181,160.56             9,206,313.00             99.73% 161,998.75                10,121,601.28           (24,413.30)                           (940,440.72)               Total 3,012,063.88             39,402,251.72           42,401,548.00           92.93% 2,840,374.12             39,133,835.75           171,689.76                          268,415.97                Prepared by     Daniel Oakley