Loading...
October 2021 - Council Expenditure ReportAs of  12/9/2021 8.33 % Year Complete Executive Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 17,678.69                    17,678.69                    422,665.00                  4.18% 18,526.92                    18,526.92                    (848.23)                                   (848.23)                       Benefits 3,659.78                       3,659.78                       65,858.00                    5.56% 2,421.54                       2,421.54                       1,238.24                                 1,238.24                     Operations 23,795.91                    23,795.91                    294,213.00                  8.09% 11,639.72                    11,639.72                    12,156.19                               12,156.19                   Capital Outlay 20,000.00                    20,000.00                    ‐                                 100.00% ‐                                 ‐                                 20,000.00                               20,000.00                   COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 65,134.38                    65,134.38                    782,736.00                  8.32% 32,588.18                    32,588.18                    32,546.20                               32,546.20                   Legislative Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 10,417.04                    10,417.04                    125,000.00                  8.33% 11,028.69                    11,028.69                    (611.65)                                   (611.65)                       Benefits 815.59                          815.59                          10,323.00                    7.90% 828.80                          828.80                          (13.21)                                     (13.21)                          Operations 415.82                          415.82                          30,400.00                    1.37% 376.07                          376.07                          39.75                                       39.75                           Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 11,648.45                    11,648.45                    165,723.00                  7.03% 12,233.56                    12,233.56                    (585.11)                                   (585.11)                       Finance Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 18,076.83                    18,076.83                    439,849.00                  4.11% 24,232.70                    24,232.70                    (6,155.87)                                (6,155.87)                    Benefits 5,165.31                       5,165.31                       82,082.00                    6.29% 4,281.60                       4,281.60                       883.71                                    883.71                         Operations 7,585.34                       7,585.34                       252,820.00                  3.00% 10,970.26                    10,970.26                    (3,384.92)                                (3,384.92)                    Capital Outlay ‐                                 ‐                                ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 30,827.48                    30,827.48                    774,751.00                  3.98% 39,484.56                    39,484.56                    (8,657.08)                                (8,657.08)                    City Clerk Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 5,256.84                       5,256.84                       124,042.00                  4.24% 8,901.55                       8,901.55                       (3,644.71)                                (3,644.71)                    Benefits 1,226.68                       1,226.68                       24,411.00                    5.03% 1,762.73                       1,762.73                       (536.05)                                   (536.05)                       Operations 10,080.95                    10,080.95                    80,170.00                    12.57% 6,494.50                       6,494.50                       3,586.45                                 3,586.45                     Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 19.95                            19.95                            (19.95)                                     (19.95)                          Total 16,564.47                    16,564.47                    228,623.00                  7.25% 17,178.73                    17,178.73                    (614.26)                                   (614.26)                       HR Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 12,339.86                    12,339.86                    335,980.00                  3.67% 23,177.10                    23,177.10                    (10,837.24)                             (10,837.24)                  Benefits 3,867.11                       3,867.11                       292,173.00                  1.32% 4,367.67                       4,367.67                       (500.56)                                   (500.56)                       Operations 3,614.35                       3,614.35                       95,600.00                    3.78% 4,393.94                       4,393.94                       (779.59)                                   (779.59)                       Capital Outlay ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 100.00% 11.95                            11.95                            (11.95)                                     (11.95)                          Total 19,821.32                    19,821.32                    723,753.00                  2.74% 31,950.66                    31,950.66                    (12,129.34)                             (12,129.34)                  IT Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 10,172.20                    10,172.20                    218,147.00                  4.66% 15,926.76                    15,926.76                    (5,754.56)                                (5,754.56)                    Benefits 2,646.59                       2,646.59                       38,636.00                    6.85% 2,678.31                       2,678.31                       (31.72)                                     (31.72)                          Operations 281,315.48                  281,315.48                  1,721,197.00               16.34% 73,355.07                    73,355.07                    207,960.41                            207,960.41                 Capital Outlay ‐                                 ‐                                 215,000.00                  ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 8,647.40                       8,647.40                       (8,647.40)                                (8,647.40)                    Total 294,134.27                  294,134.27                  2,192,980.00               13.41% 100,607.54                  100,607.54                  193,526.73                            193,526.73                 Vehicle Maint. Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 9,745.05                       9,745.05                       234,957.00                  4.15% 36,001.62                    36,001.62                    (26,256.57)                             (26,256.57)                  Benefits 5,981.13                       5,981.13                       48,849.00                    12.24% 4,217.96                       4,217.96                       1,763.17                                 1,763.17                     Operations 4,966.60                       4,966.60                       101,650.00                  4.89% 5,220.60                       5,220.60                       (254.00)                                   (254.00)                       Capital Outlay ‐                                 ‐                                 40,000.00                    ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 20,692.78                    20,692.78                    425,456.00                  4.86% 45,440.18                    45,440.18                    (24,747.40)                             (24,747.40)                  City of Prattville October 2021 Unaudited Expenditures By Department Engineering Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 24,149.29                    24,149.29                    619,777.00                  3.90% 39,474.29                    39,474.29                    (15,325.00)                             (15,325.00)                 Benefits 12,917.29                    12,917.29                    138,019.00                  9.36% 7,277.09                      7,277.09                      5,640.20                                 5,640.20                     Operations 33,018.36                    33,018.36                    1,214,902.00              2.72% 48,532.60                    48,532.60                    (15,514.24)                             (15,514.24)                 Capital Outlay ‐                                ‐                                100,000.00                  ‐                                ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Total 70,084.94                    70,084.94                    2,072,698.00              3.38% 95,283.98                    95,283.98                    (25,199.04)                             (25,199.04)                 Planning Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 17,843.80                    17,843.80                    426,880.00                  4.18% 29,869.86                    29,869.86                    (12,026.06)                             (12,026.06)                 Benefits 5,187.55                      5,187.55                      81,800.00                    6.34% 5,516.17                      5,516.17                      (328.62)                                   (328.62)                       Operations 10,023.51                    10,023.51                    323,450.00                  3.10% 44,304.00                    44,304.00                    (34,280.49)                             (34,280.49)                 Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Total 33,054.86                    33,054.86                    832,130.00                  3.97% 79,690.03                    79,690.03                    (46,635.17)                             (46,635.17)                 Urban Management Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 60,696.43                    60,696.43                    1,117,145.00              5.43% 75,433.99                    75,433.99                    (14,737.56)                             (14,737.56)                 Benefits 19,260.23                    19,260.23                    223,770.00                  8.61% 12,588.27                    12,588.27                    6,671.96                                 6,671.96                     Operations 43,947.74                    43,947.74                    560,500.00                  7.84% 49,925.84                    49,925.84                    (5,978.10)                               (5,978.10)                    Capital Outlay ‐                                ‐                                129,000.00                  ‐                                ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Total 123,904.40                  123,904.40                  2,030,415.00              6.10% 137,948.10                  137,948.10                  (14,043.70)                             (14,043.70)                 Facilities Maintenance Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 16,099.17                    16,099.17                    397,866.00                  4.05% 27,269.72                    27,269.72                    (11,170.55)                             (11,170.55)                 Benefits 5,589.39                      5,589.39                      81,396.00                    6.87% 4,491.19                      4,491.19                      1,098.20                                 1,098.20                     Operations 31,481.45                    31,481.45                    229,000.00                  13.75% 10,741.46                    10,741.46                    20,739.99                              20,739.99                   Capital Outlay ‐                                ‐                                455,000.00                  ‐                                ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Total 53,170.01                    53,170.01                    1,163,262.00              4.57% 42,502.37                    42,502.37                    10,667.64                              10,667.64                   Public Works Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 14,814.40                    14,814.40                    355,055.00                  4.17% 24,439.95                    24,439.95                    (9,625.55)                               (9,625.55)                    Benefits 5,689.03                      5,689.03                      71,937.00                    7.91% 4,421.81                      4,421.81                      1,267.22                                 1,267.22                     Operations 20,613.27                    20,613.27                    327,718.00                  6.29% 14,192.18                    14,192.18                    6,421.09                                 6,421.09                     Capital Outlay ‐                                ‐                                100.00                          ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Total 41,116.70                    41,116.70                    754,710.00                  5.45% 43,053.94                    43,053.94                    (1,937.24)                               (1,937.24)                    Police Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 257,287.65                  257,287.65                  6,205,541.00              4.15% 368,682.88                  368,682.88                  (111,395.23)                           (111,395.23)               Benefits 110,762.61                  110,762.61                  1,280,084.00              8.65% 63,888.52                    63,888.52                    46,874.09                              46,874.09                   Operations 216,457.70                  216,457.70                  1,563,261.00              13.85% 167,511.67                  167,511.67                  48,946.03                              48,946.03                   Capital Outlay ‐                                ‐                                526,102.00                  ‐                                ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                ‐                                175.75                          175.75                          (175.75)                                   (175.75)                       Total 584,507.96                  584,507.96                  9,574,988.00              6.10% 600,258.82                  600,258.82                  (15,750.86)                             (15,750.86)                 Fire Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 230,484.63                  230,484.63                  5,687,258.00              4.05% 367,242.00                  367,242.00                  (136,757.37)                           (136,757.37)               Benefits 119,110.00                  119,110.00                  1,211,167.00              9.83% 66,724.36                    66,724.36                    52,385.64                              52,385.64                   Operations 82,098.39                    82,098.39                    1,126,017.00              7.29% 88,689.81                    88,689.81                    (6,591.42)                               (6,591.42)                    Capital Outlay ‐                                ‐                                900,000.00                  ‐                                ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                ‐                                1,650.00                      1,650.00                      (1,650.00)                               (1,650.00)                    Total 431,693.02                  431,693.02                  8,924,442.00              4.84% 524,306.17                  524,306.17                  (92,613.15)                             (92,613.15)                 Building Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 11,268.64                    11,268.64                    267,629.00                  4.21% 18,804.80                    18,804.80                    (7,536.16)                               (7,536.16)                    Benefits 4,715.95                      4,715.95                      56,692.00                    8.32% 3,454.10                      3,454.10                      1,261.85                                1,261.85                     Operations 5,592.50                      5,592.50                      67,450.00                    8.29% 8,388.33                      8,388.33                      (2,795.83)                               (2,795.83)                    Capital Outlay ‐                                ‐                                26,000.00                    ‐                                ‐                                ‐                                ‐                                          ‐                               COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 21,577.09                    21,577.09                    417,771.00                  5.16% 30,647.23                    30,647.23                    (9,070.14)                               (9,070.14)                    Parks & Recreation Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 45,281.81                    45,281.81                    1,132,797.00              4.00% 80,535.25                    80,535.25                    (35,253.44)                             (35,253.44)                 Benefits 17,909.18                    17,909.18                    216,697.00                  8.26% 12,874.83                    12,874.83                    5,034.35                                5,034.35                     Operations 59,736.56                    59,736.56                    1,230,438.00              4.85% 123,576.52                  123,576.52                  (63,839.96)                             (63,839.96)                 Capital Outlay/ Capital Projects ‐                                ‐                                488,000.00                  ‐                                ‐                                ‐                                ‐                                          ‐                               COVID‐19 ‐                                ‐                                ‐                                130.00                         130.00                         (130.00)                                  (130.00)                       Total 122,927.55                  122,927.55                  3,067,932.00              4.01% 217,116.60                  217,116.60                  (94,189.05)                             (94,189.05)                 Performing Arts Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 6,831.11                      6,831.11                      137,849.00                  4.96% 9,155.17                      9,155.17                      (2,324.06)                               (2,324.06)                    Benefits 1,591.39                      1,591.39                      24,304.00                    6.55% 1,475.03                      1,475.03                      116.36                                    116.36                        Operations 1,489.64                      1,489.64                      254,820.00                  0.58% 8,148.44                      8,148.44                      (6,658.80)                               (6,658.80)                    Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 9,912.14                      9,912.14                      416,973.00                  2.38% 18,778.64                    18,778.64                    (8,866.50)                               (8,866.50)                    Non‐Departmental Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference City ‐ County Svcs 80,000.00                    80,000.00                    432,000.00                  18.52% ‐                                ‐                                80,000.00                              80,000.00                   Community Initiatives 24,434.01                    24,434.01                    1,240,839.00              1.97% 9,217.38                      9,217.38                      15,216.63                              15,216.63                   Unprocessed JP Morgan Payment 176,016.20                  176,016.20                  ‐                                100.00% ‐                                ‐                                176,016.20                            176,016.20                Drug Proceeds Expenditures ‐                                ‐                                ‐                                100.00% 198.00                         198.00                         (198.00)                                  (198.00)                       Transfer to DSF ‐ One Cent ‐ Infras 92,941.47                    92,941.47                    573,819.00                  16.20% 1,623,029.10              1,623,029.10              (1,530,087.63)                       (1,530,087.63)            Transfer to DSF ‐ Other 123,311.20                  123,311.20                  123,311.00                  100.00% 132,034.25                  132,034.25                  (8,723.05)                               (8,723.05)                    Transfer to Group Health 274,750.00                  274,750.00                  3,297,000.00              8.33% 252,500.00                  252,500.00                  22,250.00                              22,250.00                   Transfer to Capital Project Fund ‐                                ‐                                2,365,100.00              ‐                                ‐                                ‐                                ‐                                          ‐                               Transfer to Wasewater Fund ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          Transfer to Sanitation Fund ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Transfer to Gas Tax Fund ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Transfer to Judicial ‐                                ‐                                261,287.00                  ‐                                ‐                                ‐                                ‐                                          ‐                               Total 771,452.88                  771,452.88                  8,293,356.00              9.30% 2,016,978.73              2,016,978.73              (1,245,525.85)                       (1,245,525.85)            Debt Service Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Debt Service 24,970.10                    24,970.10                    2,134,891.00              1.17% 24,610.97                    24,610.97                    359.13                                    359.13                        Total 24,970.10                    24,970.10                    2,134,891.00              1.17% 24,610.97                    24,610.97                    359.13                                    359.13                        Total Oct‐21 YTD Budget % of Budget Oct‐20 YTD October Difference YTD Difference Salary 768,443.44                  768,443.44                  18,248,437.00            4.21% 1,178,703.25              1,178,703.25              (410,259.81)                           (410,259.81)               Benefits 600,844.81                  600,844.81                  7,245,198.00              8.29% 455,769.98                  455,769.98                  145,074.83                            145,074.83                Operations 1,116,683.78              1,116,683.78              13,772,832.00            8.11% 685,876.39                  685,876.39                  430,807.39                            430,807.39                Capital Outlay 20,000.00                    20,000.00                    2,879,102.00              0.69% ‐                                ‐                                20,000.00                              20,000.00                   Debt Service 241,222.77                  241,222.77                  2,832,021.00              8.52% 1,779,674.32              1,779,674.32              (1,538,451.55)                       (1,538,451.55)            COVID‐19 ‐                                ‐                                ‐                                ‐                                10,635.05                    10,635.05                    Total 2,747,194.80              2,747,194.80              44,977,590.00            6.11% 4,110,658.99              4,110,658.99              (1,352,829.14)                       (1,352,829.14)            % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 6.11% Prepared by      Daniel Oakley