Loading...
September 2020 - Council Expenditure ReportAs of  10/20/2020 100.00 % Year Complete Executive Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 18,526.92                    263,466.61                  284,622.67                  92.57% 23,570.61                    278,648.78                  (5,043.69)                                (15,182.17)                  Benefits 2,236.08                       33,143.95                    43,490.97                    76.21% 3,031.27                       35,278.77                    (795.19)                                   (2,134.82)                    Operations 8,773.27                       81,986.33                    162,775.00                  50.37% 7,406.94                       97,197.66                    1,366.33                                 (15,211.33)                  Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 2,251.20                       3,075.24                       ‐                                 100.00% 2,251.20                                 3,075.24                     Total 31,787.47                    381,672.13                  490,888.64                  77.75% 34,008.82                    411,125.21                  (2,221.35)                                (29,453.08)                  Legislative Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 10,417.04                    123,740.62                  125,000.00                  98.99% 10,417.04                    125,004.48                  ‐                                           (1,263.86)                    Benefits 782.02                          9,367.07                       10,299.00                    90.95% 711.22                          9,193.53                       70.80                                       173.54                         Operations 369.00                          4,792.22                       13,300.00                    36.03% 1,022.00                       13,106.35                    (653.00)                                   (8,314.13)                    Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 19.95                            4,079.63                       ‐                                 100.00% 19.95                                       4,079.63                     Total 11,588.01                    141,979.54                  148,599.00                  95.55% 12,150.26                    147,304.36                  (562.25)                                   (5,324.82)                    Finance Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 24,224.44                    322,579.09                  360,253.00                  89.54% 22,868.38                    289,342.88                  1,356.06                                 33,236.21                   Benefits 3,950.61                       52,734.68                    60,616.00                    87.00% 3,760.03                       48,421.98                    190.58                                    4,312.70                     Operations 9,954.36                       214,110.68                  240,360.00                  89.08% 8,785.86                       211,619.49                  1,168.50                                 2,491.19                     Capital Outlay ‐                                 ‐                                 0.00% ‐                                           ‐                               COVID‐19 21.97                            364.17                          ‐                                 100.00% 21.97                                       364.17                         Total 38,151.38                    589,788.62                  661,229.00                  89.20% 35,414.27                    549,384.35                  2,737.11                                 40,404.27                   City Clerk Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 9,018.43                       134,078.29                  139,619.00                  96.03% 10,327.95                    130,547.58                  (1,309.52)                                3,530.71                     Benefits 1,664.18                       22,399.82                    24,068.00                    93.07% 1,646.61                       21,276.61                    17.57                                       1,123.21                     Operations 27,570.28                    86,797.60                    108,240.00                  80.19% 3,635.53                       34,572.25                    23,934.75                               52,225.35                   Capital Outlay ‐                                 ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 (6,005.02)                     4,651.80                       ‐                                 100.00% (6,005.02)                                4,651.80                     Total 32,247.87                    247,927.51                  271,927.00                  91.17% 15,610.09                    186,396.44                  16,637.78                               61,531.07                   HR Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 23,007.62                    305,256.23                  308,420.00                  98.97% 22,401.95                    282,491.96                  605.67                                    22,764.27                   Benefits 4,051.54                       54,500.76                    56,426.00                    96.59% 3,928.62                       50,753.84                    122.92                                    3,746.92                     Operations 8,053.20                       56,147.17                    72,275.00                    77.69% 12,594.51                    73,264.11                    (4,541.31)                                (17,116.94)                  Capital Outlay ‐                                 ‐                                 ‐                                 0.00% 10,950.00                    ‐                                           (10,950.00)                  COVID‐19 92.15                            9,701.35                       ‐                                 100.00% 92.15                                       9,701.35                     Total 35,204.51                    425,605.51                  437,121.00                  97.37% 38,925.08                    417,459.91                  (3,720.57)                                8,145.60                     IT Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 15,686.60                    196,067.61                  195,466.00                  100.31% 13,420.77                    167,843.37                  2,265.83                                 28,224.24                   Benefits 2,351.80                       29,737.81                    30,262.00                    98.27% 1,997.68                       25,577.09                    354.12                                    4,160.72                     Operations 117,629.89                  1,253,999.44               1,371,831.00               91.41% 77,778.13                    1,251,136.55               39,851.76                               2,862.89                     Capital Outlay ‐                                 94,038.13                    200,000.00                  47.02% 27,212.00                    130,886.00                  (27,212.00)                             (36,847.87)                  COVID‐19 268,482.10                  474,782.49                  ‐                                 100.00% 268,482.10                            474,782.49                 Total 404,150.39                  2,048,625.48               1,797,559.00               113.97% 120,408.58                  1,575,443.01               283,741.81                            473,182.47                 Vehicle Maint. Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 14,154.00                    222,200.83                  228,594.00                  97.20% 17,096.89                    234,767.31                  (2,942.89)                                (12,566.48)                  Benefits 2,362.06                       44,085.49                    43,245.00                    101.94% 2,817.03                       44,378.81                    (454.97)                                   (293.32)                       Operations 6,217.79                       83,652.26                    98,650.00                    84.80% 9,618.47                       61,832.24                    (3,400.68)                                21,820.02                   Capital Outlay ‐                                 35,240.95                    37,000.00                    95.25% ‐                                 ‐                                 ‐                                           35,240.95                   COVID‐19 ‐                                 ‐                                 ‐                                 100.00% ‐                                           ‐                               Total 22,733.85                    385,179.53                  407,489.00                  94.53% 29,532.39                    340,978.36                  (6,798.54)                                44,201.17                   City of Prattville September 2020 Unaudited Expenditures By Department Engineering Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 40,549.43                    473,022.81                  552,052.00                  85.68% 35,634.93                    463,586.70                  4,914.50                                 9,436.11                     Benefits 7,031.17                      97,110.95                    113,511.00                  85.55% 6,411.01                      96,631.42                    620.16                                    479.53                        Operations 75,506.16                    364,562.49                  566,300.00                  64.38% 56,501.55                    351,376.52                  19,004.61                              13,185.97                   Capital Outlay ‐                                296,655.31                  333,718.00                  0.00% ‐                                ‐                                ‐                                           296,655.31                COVID‐19 ‐                                ‐                                ‐                                100.00% ‐                                           ‐                               Total 123,086.76                  1,231,351.56              1,565,581.00              78.65% 98,547.49                    911,594.64                  24,539.27                              319,756.92                Planning Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 29,864.32                    344,617.54                  347,578.47                  99.15% 21,333.01                    223,520.41                  8,531.31                                 121,097.13                Benefits 5,293.02                      61,825.52                    67,357.73                    91.79% 3,821.85                      41,038.73                    1,471.17                                 20,786.79                   Operations 83,270.77                    605,765.35                  727,450.00                  83.27% 44,996.93                    410,601.29                  38,273.84                              195,164.06                Capital Outlay ‐                                ‐                                ‐                                0.00% 26,863.00                    ‐                                           (26,863.00)                 COVID‐19 7,181.89                      7,181.89                      ‐                                100.00% ‐                                7,181.89                                 7,181.89                     Total 125,610.00                  1,019,390.30              1,142,386.20              89.23% 70,151.79                    702,023.43                  55,458.21                              317,366.87                Urban Management Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 75,332.53                    893,776.49                  927,120.00                  96.40% 60,164.41                    724,354.45                  15,168.12                              169,422.04                Benefits 11,763.99                    156,505.77                  167,371.00                  93.51% 9,383.61                      130,012.63                  2,380.38                                 26,493.14                   Operations 42,526.31                    416,356.81                  493,000.00                  84.45% 54,785.93                    447,726.85                  (12,259.62)                             (31,370.04)                 Capital Outlay ‐                                ‐                                52,469.00                    0.00% 9,804.24                      64,059.24                    (9,804.24)                               (64,059.24)                 COVID‐19 ‐                                ‐                                ‐                                100.00% ‐                                           ‐                               Total 129,622.83                  1,466,639.07              1,639,960.00              89.43% 134,138.19                  1,366,153.17              (4,515.36)                               100,485.90                Facilities Maintenance Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 27,264.70                    357,321.61                  363,631.00                  98.26% 25,523.50                    322,845.78                  1,741.20                                 34,475.83                   Benefits 4,163.39                      58,613.41                    59,507.00                    98.50% 3,876.81                      53,254.26                    286.58                                    5,359.15                     Operations 8,502.40                      136,445.34                  194,210.00                  70.26% 6,915.82                      130,320.16                  1,586.58                                 6,125.18                     Capital Outlay ‐                                91,416.00                    91,466.00                    99.95% 34,950.00                    107,545.68                  (34,950.00)                             (16,129.68)                 COVID‐19 ‐                                345.52                          ‐                                100.00% ‐                                           345.52                        Total 39,930.49                    644,141.88                  708,814.00                  90.88% 71,266.13                    613,965.88                  (31,335.64)                             30,176.00                   Public Works Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 24,517.05                    315,257.42                  312,653.00                  100.83% 20,696.09                    257,169.75                  3,820.96                                 58,087.67                   Benefits 4,206.87                      58,019.55                    58,569.00                    99.06% 3,507.10                      47,708.84                    699.77                                    10,310.71                   Operations 21,426.10                    202,424.49                  224,718.00                  90.08% 4,291.75                      188,429.71                  17,134.35                              13,994.78                   Capital Outlay ‐                                ‐                                225,000.00                  0.00% 63,216.80                    229,194.30                  (63,216.80)                             (229,194.30)               COVID‐19 ‐                                586.88                          ‐                                100.00% ‐                                           586.88                        Total 50,150.02                    576,288.34                  820,940.00                  70.20% 91,711.74                    722,502.60                  (41,561.72)                             (146,214.26)               Police Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 365,708.99                  5,057,797.99              5,557,043.00              91.02% 381,070.62                  4,758,192.01              (15,361.63)                             299,605.98                Benefits 60,573.80                    932,676.79                  1,044,030.00              89.33% 63,366.93                    895,499.76                  (2,793.13)                               37,177.03                   Operations 141,386.56                  1,118,911.77              1,309,552.35              85.44% 17,658.55                    1,134,664.34              123,728.01                            (15,752.57)                 Capital Outlay ‐                                114,912.04                  624,927.98                  18.39% 176,504.05                  298,818.43                  (176,504.05)                           (183,906.39)               COVID‐19 465.65                          16,378.77                    ‐                                100.00% 465.65                                    16,378.77                   Total 568,135.00                  7,240,677.36              8,535,553.33              84.83% 638,600.15                  7,087,174.54              (70,465.15)                             153,502.82                Fire Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 389,701.17                  4,995,823.06              5,047,501.00              98.98% 360,138.31                  4,472,014.12              29,562.86                              523,808.94                Benefits 67,652.29                    982,840.69                  1,012,418.00              97.08% 62,766.15                    903,293.71                  4,886.14                                 79,546.98                   Operations 54,977.50                    823,713.50                  986,692.00                  83.48% 63,885.81                    893,859.69                  (8,908.31)                               (70,146.19)                 Capital Outlay ‐                                29,990.00                    164,779.00                  18.20% ‐                                445,444.00                  ‐                                           (415,454.00)               COVID‐19 1,242.96                      18,144.96                    100.00% 1,242.96                                 18,144.96                   Total 513,573.92                  6,850,512.21              7,211,390.00              95.00% 486,790.27                  6,714,611.52              26,783.65                              135,900.69                Building Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 18,804.80                    244,340.03                  244,473.00                  99.95% 18,068.07                    268,678.03                  736.73                                    (24,338.00)                 Benefits 3,271.38                      45,994.50                    49,214.00                    93.46% 3,153.65                      51,036.57                    117.73                                    (5,042.07)                    Operations 1,469.10                      32,159.46                    55,450.00                    58.00% 2,219.02                      39,589.27                    (749.92)                                   (7,429.81)                    Capital Outlay 35,025.00                    35,025.00                    35,025.00                    0.00% ‐                                ‐                                35,025.00                              35,025.00                   COVID‐19 ‐                                ‐                                ‐                                100.00% ‐                                           ‐                               Total 58,570.28                    357,518.99                  384,162.00                  93.06% 23,440.74                    359,303.87                  35,129.54                              (1,784.88)                    Parks & Recreation Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 77,742.09                    1,056,763.40              1,005,486.00              105.10% 65,857.12                    863,458.75                  11,884.97                              193,304.65                Benefits 11,981.74                    174,139.80                  169,471.00                  102.75% 10,079.20                    143,456.62                  1,902.54                                 30,683.18                   Operations 109,396.59                  1,028,243.23              1,174,070.00              87.58% 140,452.65                  1,048,572.10              (31,056.06)                             (20,328.87)                 Capital Outlay/ Capital Projects 95,162.67                    184,024.78                  338,746.00                  54.33% 64,327.00                    559,087.83                  30,835.67                              (375,063.05)               COVID‐19 6,707.54                      73,411.67                    ‐                                100.00% 6,707.54                                 73,411.67                   Total 300,990.63                  2,516,582.88              2,687,773.00              93.63% 280,715.97                  2,614,575.30              20,274.66                              (97,992.42)                 Performing Arts Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 8,228.49                      112,648.38                  106,627.00                  105.65% 7,302.35                      93,147.77                    926.14                                    19,500.61                   Benefits 1,211.97                      16,687.40                    15,770.00                    105.82% 1,048.47                      14,139.76                    163.50                                    2,547.64                     Operations 10,789.63                    131,069.72                  266,690.00                  49.15% 19,659.19                    202,329.33                  (8,869.56)                               (71,259.61)                 Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                10,514.00                    ‐                                           (10,514.00)                 COVID‐19 ‐                                179.99                          ‐                                100.00% ‐                                           179.99                        Total 20,230.09                    260,585.49                  389,087.00                  66.97% 28,010.01                    320,130.86                  (7,779.92)                               (59,545.37)                 Non‐Departmental Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference City ‐ County Svcs 7,083.33                      420,000.00                  425,000.00                  98.82% ‐                                410,000.00                  7,083.33                                 10,000.00                   Community Initiatives 41,666.67                    774,925.69                  979,274.00                  79.13% 153,445.14                  898,398.24                  (111,778.47)                           (123,472.55)               Transfer to DSF ‐ One Cent 3,385,580.49              3,394,441.00              99.74% ‐                                7,335,956.05              ‐                                           (3,950,375.56)            Transfer to DSF ‐ Other 39,092.78                    607,988.11                  664,029.00                  91.56% ‐                                226,481.89                  39,092.78                              381,506.22                Transfer to Group Health 514,583.33                  3,269,999.96              2,995,000.00              109.18% ‐                                2,966,004.00              514,583.33                            303,995.96                Transfer to Capital Project Fund 560,907.22                  1,185,777.24              75,000.00                    1581.04% 511,611.32                  906,561.47                  49,295.90                              279,215.77                Transfer to Sanitation Fund 873.13                          873.13                          21,307.00                    4.10% ‐                                ‐                                873.13                                    873.13                        Transfer to Gas Tax Fund 175,663.79                  197,663.79                  22,000.00                    898.47% ‐                                188,150.00                  175,663.79                            9,513.79                     Transfer to Judicial ‐                                121,793.88                  121,794.00                  0.00% ‐                                ‐                                ‐                                           121,793.88                Total 1,339,870.25              9,964,602.29              8,697,845.00              114.56% 665,056.46                  12,931,551.65            674,813.79                            (2,966,949.36)            Debt Service Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Debt Service 200,857.11                  1,694,138.28              1,728,000.00              98.04% 137,585.45                  1,618,722.62              63,271.66                              75,415.66                   Total 200,857.11                  1,694,138.28              1,728,000.00              98.04% 137,585.45                  1,618,722.62              63,271.66                              75,415.66                   Total Sep‐20 YTD Budget % of Budget Sep‐19 YTD September Difference YTD Difference Salary 1,172,748.62              15,418,758.01            16,106,139.14            95.73% 1,115,892.00              13,955,614.13            56,856.62                              1,463,143.88             Benefits 709,131.24                  6,100,383.92              6,020,625.70              101.32% 185,307.24                  5,576,956.93              523,824.00                            523,426.99                Operations 1,514,013.05              9,143,634.67              9,688,631.35              94.37% 1,197,265.10              8,805,157.62              316,747.95                            338,477.05                Capital Outlay 130,187.67                  881,302.21                  2,103,130.98              41.90% 376,014.09                  1,883,362.48              (245,826.42)                           (1,002,060.27)            Debt Service 239,949.89                  5,687,706.88              5,786,470.00              98.29% 137,585.45                  9,181,160.56              102,364.44                            (3,493,453.68)            COVID‐19 280,460.39                  612,884.36                  ‐                                100.00% Total 4,046,490.86              37,844,670.05            39,704,997.17            95.31% 3,012,063.88              39,402,251.72            753,966.59                            (2,170,466.03)            % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 93.77% Prepared by      Daniel Oakley