Loading...
November 2019 - Council Expenditure ReportAs of  1/13/2020 16.67 % Year Complete Executive Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 21,300.16                    45,178.18                    267,156.00                  16.91% 22,490.47                    37,539.97                    (1,190.31)                               7,638.21                     Benefits 2,700.00                      5,741.32                      35,188.00                    16.32% 2,484.86                      4,794.72                      215.14                                    946.60                        Operations 3,221.90                      22,440.90                    162,775.00                  13.79% 4,259.28                      15,908.88                    (1,037.38)                               6,532.02                     Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 27,222.06                    73,360.40                    465,119.00                  15.77% 29,234.61                    58,243.57                    (2,012.55)                               15,116.83                   Legislative Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 10,417.04                    20,834.08                    125,000.00                  16.67% 10,417.04                    20,834.08                    ‐                                          ‐                               Benefits 797.58                          1,508.80                      10,299.00                    14.65% 750.24                          1,500.48                      47.34                                      8.32                             Operations 913.44                          1,283.38                      13,300.00                    9.65% ‐                                689.77                          913.44                                    593.61                        Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 12,128.06                    23,626.26                    148,599.00                  15.90% 11,167.28                    23,024.33                    960.78                                    601.93                        Finance Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 24,789.56                    48,492.38                    360,253.00                  13.46% 21,761.58                    37,843.89                    3,027.98                                10,648.49                   Benefits 4,029.56                      7,600.82                      60,616.00                    12.54% 3,648.97                      6,841.18                      380.59                                    759.64                        Operations 10,952.28                    24,045.62                    240,360.00                  10.00% 7,153.55                      15,739.17                    3,798.73                                8,306.45                     Capital Outlay ‐                                ‐                                0.00% ‐                                          ‐                               Total 39,771.40                    80,138.82                    661,229.00                  12.12% 32,564.10                    60,424.24                    7,207.30                                19,714.58                   City Clerk Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 10,810.91                    21,380.34                    139,619.00                  15.31% 10,035.02                    16,956.66                    775.89                                    4,423.68                     Benefits 1,852.03                      3,541.05                      24,068.00                    14.71% 1,673.05                      3,053.61                      178.98                                    487.44                        Operations 590.41                          4,292.95                      108,240.00                  3.97% 2,712.85                      4,605.76                      (2,122.44)                               (312.81)                       Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               Total 13,253.35                    29,214.34                    271,927.00                  10.74% 14,420.92                    24,616.03                    (1,167.57)                               4,598.31                     HR Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 24,151.97                    47,213.81                    308,420.00                  15.31% 21,561.38                    37,709.76                    2,590.59                                9,504.05                     Benefits 4,396.07                      8,435.67                      56,426.00                    14.95% 3,921.07                      7,326.64                      475.00                                    1,109.03                     Operations 5,350.16                      8,366.59                      72,275.00                    11.58% 6,710.29                      11,346.48                    (1,360.13)                               (2,979.89)                   Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               Total 33,898.20                    64,016.07                    437,121.00                  14.64% 32,192.74                    56,382.88                    1,705.46                                7,633.19                     IT Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 14,649.96                    28,549.25                    195,466.00                  14.61% 12,498.62                    22,754.18                    2,151.34                                5,795.07                     Benefits 2,216.03                      4,287.01                      30,262.00                    14.17% 1,875.80                      3,653.34                      340.23                                    633.67                        Operations 167,010.26                  237,155.19                  1,371,831.00              17.29% 83,484.60                    199,941.90                  83,525.66                              37,213.29                   Capital Outlay ‐                                ‐                                200,000.00                  0.00% ‐                                ‐                                ‐                                          ‐                               Total 183,876.25                  269,991.45                  1,797,559.00              15.02% 97,859.02                    226,349.42                  86,017.23                              43,642.03                   Vehicle Maint. Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 17,360.73                    34,313.36                    228,594.00                  15.01% 18,831.57                    33,384.72                    (1,470.84)                               928.64                        Benefits 2,919.15                      5,707.23                      43,245.00                    13.20% 3,220.59                      6,067.75                      (301.44)                                  (360.52)                       Operations 7,435.31                      23,399.19                    98,650.00                    23.72% 4,855.39                      7,985.93                      2,579.92                                15,413.26                   Capital Outlay ‐                                ‐                                37,000.00                    0.00% ‐                                ‐                                ‐                                          ‐                               Total 27,715.19                    63,419.78                    407,489.00                  15.56% 26,907.55                    47,438.40                    807.64                                    15,981.38                   City of Prattville November Unaudited Expenditures By Department Engineering Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 38,301.56                    74,713.73                    552,052.00                 13.53% 36,914.66                    64,405.17                    1,386.90                                10,308.56                  Benefits 6,566.36                      12,971.98                    113,511.00                 11.43% 6,811.71                      12,781.31                    (245.35)                                  190.67                        Operations 20,494.44                    88,822.44                    566,300.00                 15.68% 14,771.78                    50,066.68                    5,722.66                                38,755.76                  Capital Outlay ‐                                ‐                                333,718.00                 0.00% ‐                                ‐                                ‐                                          ‐                              Total 65,362.36                    176,508.15                 1,565,581.00              11.27% 58,498.15                    127,253.16                 6,864.21                                49,254.99                  Planning Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 24,150.74                    46,037.99                    335,243.00                 13.73% 13,319.85                    20,668.88                    10,830.89                              25,369.11                  Benefits 4,337.95                      8,255.51                      60,022.00                    13.75% 2,443.12                      3,949.94                      1,894.83                                4,305.57                     Operations 41,145.40                    97,972.91                    727,450.00                 13.47% 38,419.94                    48,462.48                    2,725.46                                49,510.43                  Capital Outlay ‐                               ‐                              ‐                                0.00% ‐                                ‐                                ‐                                          ‐                              Total 69,634.09                    152,266.41                 1,122,715.00              13.56% 54,182.91                    73,081.30                    15,451.18                              79,185.11                  Urban Management Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 67,398.02                    128,238.89                 927,120.00                 13.83% 52,025.08                    90,978.09                    15,372.94                              37,260.80                  Benefits 10,924.77                    20,609.75                    167,371.00                 12.31% 8,438.38                      15,785.56                    2,486.39                                4,824.19                     Operations 53,508.64                    109,945.39                 493,000.00                 22.30% 39,000.67                    92,769.89                    14,507.97                              17,175.50                  Capital Outlay ‐                                ‐                                30,000.00                    0.00% ‐                                ‐                                ‐                                          ‐                              Total 131,831.43                 258,794.03                 1,617,491.00              16.00% 99,464.13                    199,533.54                 32,367.30                              59,260.49                  Facilities Maintenance Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 27,657.34                    54,802.02                    363,631.00                 15.07% 24,834.59                    43,231.81                    2,822.75                                11,570.21                  Benefits 4,278.31                      8,423.96                      59,507.00                    14.16% 3,780.43                      7,111.75                      497.88                                   1,312.21                     Operations 5,820.89                      30,649.39                    237,050.00                 12.93% 4,692.55                      27,475.36                    1,128.34                                3,174.03                     Capital Outlay ‐                                ‐                                35,000.00                    0.00% ‐                                ‐                                ‐                                          ‐                              Total 37,756.54                    93,875.37                    695,188.00                 13.50% 33,307.57                    77,818.92                    4,448.97                                16,056.45                  Public Works Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 23,961.84                    45,193.41                    312,653.00                 14.45% 19,880.33                    34,643.74                    4,081.51                                10,549.67                  Benefits 4,187.23                      7,838.11                      58,569.00                    13.38% 3,423.47                      6,442.90                      763.76                                   1,395.21                     Operations 22,148.31                    39,369.75                    224,718.00                 17.52% 10,786.22                    33,139.10                    11,362.09                              6,230.65                     Capital Outlay ‐                                ‐                                225,000.00                 0.00% ‐                                ‐                                ‐                                          ‐                              Total 50,297.38                    92,401.27                    820,940.00                 11.26% 34,090.02                    74,225.74                    16,207.36                              18,175.53                  Police Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 413,289.87                 807,581.21                 5,557,043.00              14.53% 364,015.67                 632,302.73                 49,274.20                              175,278.48                Benefits 68,956.36                    132,877.14                 1,044,030.00              12.73% 61,594.69                    117,309.60                 7,361.67                                15,567.54                  Operations 100,440.38                 280,820.71                 1,425,809.00              19.70% 43,661.35                    221,350.28                 56,779.03                              59,470.43                  Capital Outlay ‐                                ‐                                133,600.00                 0.00% ‐                                ‐                                ‐                                          ‐                              Total 582,686.61                 1,221,279.06              8,160,482.00              14.97% 469,271.71                 970,962.61                 113,414.90                           250,316.45                Fire Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 396,056.81                 790,277.30                 5,047,501.00              15.66% 345,637.22                 598,627.76                 50,419.59                              191,649.54                Benefits 69,941.13                    136,018.54                 1,012,418.00              13.44% 61,196.31                    115,166.65                 8,744.82                                20,851.89                  Operations 53,342.05                    161,318.46                 1,044,321.00              15.45% 58,974.97                    152,719.30                 (5,632.92)                               8,599.16                     Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                              Total 519,339.99                 1,087,614.30              7,104,240.00              15.31% 465,808.50                 866,513.71                 53,531.49                              221,100.59                Building Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 19,049.91                    37,333.11                    244,473.00                 15.27% 22,603.21                    39,538.81                    (3,553.30)                               (2,205.70)                   Benefits 3,386.86                      6,571.89                      49,214.00                    13.35% 4,058.22                      7,653.55                      (671.36)                                  (1,081.66)                   Operations 2,347.52                      19,060.71                    55,450.00                    34.37% 10,380.06                    15,314.18                    (8,032.54)                               3,746.53                     Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                              Total 24,784.29                    62,965.71                    349,137.00                 18.03% 37,041.49                    62,506.54                    (12,257.20)                            459.17                        Parks & Recreation Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 75,054.50                    150,246.43                 1,005,486.00              14.94% 56,897.40                    101,144.46                 18,157.10                              49,101.97                  Benefits 11,939.35                    23,277.27                    169,471.00                 13.74% 8,991.79                      16,929.71                    2,947.56                                6,347.56                     Operations 80,224.87                    214,189.88                 1,174,070.00              18.24% 36,608.41                    134,301.34                 43,616.46                              79,888.54                  Capital Outlay/ Capital Projects ‐                                ‐                                200,400.00                 0.00% ‐                                ‐                                ‐                                          ‐                              Total 167,218.72                 387,713.58                 2,549,427.00              15.21% 102,497.60                 252,375.51                 64,721.12                              135,338.07                Performing Arts Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 8,579.27                      16,981.67                    106,627.00                 15.93% 6,920.19                      11,327.39                    1,659.08                                5,654.28                     Benefits 1,302.54                      2,504.75                      15,770.00                    15.88% 1,076.12                      1,852.60                      226.42                                   652.15                        Operations 13,486.18                    23,911.18                    266,690.00                 8.97% 15,398.51                    24,090.40                    (1,912.33)                               (179.22)                       Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                              Total 23,367.99                    43,397.60                    389,087.00                 11.15% 23,394.82                    37,270.39                    (26.83)                                    6,127.21                     Non‐Departmental Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference City ‐ County Svcs 21,250.02                    101,250.02                 425,000.00                 23.82% ‐                                90,833.34                    21,250.02                              10,416.68                  Community Initiatives 120,843.53                 176,778.72                 979,274.00                 18.05% 93,007.36                    157,146.38                 27,836.17                              19,632.34                  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                 499,166.66                 2,995,000.00              16.67% 247,167.00                 494,334.00                 2,416.33                                4,832.66                     Transfer to Capital Project Fund ‐                                10,772.24                    75,000.00                    14.36% 10,529.13                    29,991.37                    (10,529.13)                            (19,219.13)                 Transfer to Gas Tax Fund ‐                                ‐                                22,000.00                    0.00% ‐                                ‐                                ‐                                          ‐                              Transfer to Judicial ‐                                121,794.00                 0.00% ‐                                ‐                                ‐                                          ‐                              Total 391,676.88                 2,938,564.09              8,676,538.00              33.87% 350,703.49                 2,737,151.98              40,973.39                              201,412.11                Debt Service Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Debt Service 132,750.59                 255,874.75                 1,728,000.00              14.81% 122,779.77                 239,257.84                 9,970.82                                16,616.91                  Total 132,750.59                 255,874.75                 1,728,000.00              14.81% 122,779.77                 239,257.84                 9,970.82                                16,616.91                  Total Nov‐19 YTD Budget % of Budget Nov‐18 YTD November Difference YTD Difference Salary 1,216,980.19              2,397,367.16              16,076,337.00            14.91% 1,060,643.88              1,843,892.10              156,336.31                           553,475.06                Benefits 454,314.61                 895,337.46                 6,004,987.00              14.91% 426,555.82                 832,555.29                 27,758.79                              62,782.17                  Operations 730,525.99                 1,675,845.62              9,905,357.00              16.92% 485,406.91                 1,333,877.99              245,119.08                           341,967.63                Capital Outlay ‐                                ‐                                1,194,718.00              0.00% ‐                                ‐                                ‐                                          ‐                              Debt Service 132,750.59                 2,406,471.20              5,786,470.00              41.59% 122,779.77                 2,204,104.73              9,970.82                                202,366.47                Total 2,534,571.38              7,375,021.44              38,967,869.00            18.93% 2,095,386.38              6,214,430.11              439,185.00                           1,160,591.33             Prepared by      Daniel Oakley