Loading...
April 2022 - Council Expenditure ReportAs of  5/13/2022 58.33 % Year Complete Executive Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 37,200.98                   245,467.79                 422,665.00                 58.08% 22,546.12                   163,547.58                 14,654.86                              81,920.21                   Benefits 5,695.02                      38,282.95                   65,858.00                   58.13% 3,126.96                      22,577.42                   2,568.06                                15,705.53                   Operations 11,111.59                   93,733.72                   294,213.00                 31.86% 8,512.51                      76,322.55                   2,599.08                                17,411.17                   Capital Outlay ‐                                23,814.53                    ‐                                100.00%‐                                 ‐                                 ‐                                          23,814.53                   COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                2,740.93                       ‐                                          (2,740.93)                    Total 54,007.59                   401,298.99                 782,736.00                 51.27% 34,185.59                   265,188.48                 19,822.00                              136,110.51                 Legislative Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 10,417.04                   72,919.28                   125,000.00                 58.34% 10,417.04                   73,530.93                    ‐                                          (611.65)                       Benefits 735.46                         5,416.11                      10,323.00                   52.47% 804.16                         5,703.41                      (68.70)                                    (287.30)                       Operations 1,968.00                      3,690.91                      30,400.00                   12.14%‐                                1,712.75                      1,968.00                                1,978.16                     Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 13,120.50                   82,026.30                   165,723.00                 49.50% 11,221.20                   80,947.09                   1,899.30                                1,079.21                     Finance Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 33,415.44                   236,138.93                 439,849.00                 53.69% 25,811.17                   199,927.72                 7,604.27                                36,211.21                   Benefits 5,979.10                      46,078.51                   82,082.00                   56.14% 4,552.10                      35,170.89                   1,427.00                                10,907.62                   Operations 10,285.30                   177,265.98                 252,820.00                 70.12% 37,622.84                   229,481.27                 (27,337.54)                            (52,215.29)                  Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 49,679.84                   459,483.42                 774,751.00                 59.31% 67,986.11                   464,579.88                 (18,306.27)                            (5,096.46)                    City Clerk Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 10,644.60                   74,691.46                   124,042.00                 60.21% 14,265.15                   93,821.15                   (3,620.55)                               (19,129.69)                  Benefits 1,887.98                      13,680.51                   24,411.00                   56.04% 1,746.38                      11,612.90                   141.60                                   2,067.61                     Operations 2,203.49                      54,561.69                   80,170.00                   68.06% 2,703.16                      21,863.63                   (499.67)                                  32,698.06                   Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                19.95                            ‐                                          (19.95)                          Total 14,736.07                   142,933.66                 228,623.00                 62.52% 18,714.69                   127,317.63                 (3,978.62)                               15,616.03                   HR Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 25,952.23                   178,411.62                 343,171.60                 51.99% 24,299.29                   192,801.42                 1,652.94                                (14,389.80)                  Benefits 4,796.86                      34,674.86                   292,723.15                 11.85% 4,444.89                      34,777.67                   351.97                                   (102.81)                       Operations 8,890.48                      45,927.96                   87,858.25                   52.28% 7,483.39                      28,532.14                   1,407.09                                17,395.82                   Capital Outlay ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                100.00%‐                                927.82                          ‐                                          (927.82)                       Total 39,639.57                   259,014.44                 723,753.00                 35.79% 36,227.57                   257,039.05                 3,412.00                                1,975.39                     IT Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 17,753.78                   129,423.29                 218,147.00                 59.33% 17,295.72                   129,040.88                 458.06                                   382.41                         Benefits 3,050.29                      23,096.80                   38,636.00                   59.78% 2,907.11                      21,623.32                   143.18                                   1,473.48                     Operations 126,106.97                 1,199,747.78              1,721,197.00              69.70% 127,941.64                 1,200,350.74              (1,834.67)                               (602.96)                       Capital Outlay ‐                                61,973.00                   215,000.00                 0.29                               ‐                                20,855.13                    ‐                                          41,117.87                   COVID‐19 ‐                                 ‐                                 ‐                                26,668.00                   133,529.30                 (26,668.00)                            (133,529.30)               Total 146,911.04                 1,414,240.87              2,192,980.00              64.49% 174,812.47                 1,505,399.37              (27,901.43)                            (91,158.50)                  Vehicle Maint. Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 17,142.72                   125,643.17                 234,957.00                 53.47% 13,813.98                   134,186.98                 3,328.74                                (8,543.81)                    Benefits 2,997.19                      32,394.83                   48,849.00                   66.32% 2,363.76                      31,136.94                   633.43                                   1,257.89                     Operations 6,075.34                      28,047.22                   101,650.00                 27.59% 11,012.61                   42,249.58                   (4,937.27)                               (14,202.36)                  Capital Outlay ‐                                 ‐                                40,000.00                    ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 26,215.25                   186,085.22                 425,456.00                 43.74% 27,190.35                   207,573.50                 (975.10)                                  (21,488.28)                  City of Prattville April 2022 Unaudited Expenditures By Department Engineering Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 44,867.48                   314,839.28                 619,777.00                 50.80% 38,219.40                   304,258.34                 6,648.08                                10,580.94                   Benefits 8,269.97                      87,665.13                   138,019.00                 63.52% 6,857.66                      72,619.78                   1,412.31                                15,045.35                   Operations 54,226.13                   403,999.99                 1,214,902.00              33.25% 28,337.67                   179,053.78                 25,888.46                              224,946.21                 Capital Projects ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Capital Outlay 89,172.60                   89,172.60                   100,000.00                  ‐                                 ‐                                 ‐                                89,172.60                              89,172.60                   COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 196,536.18                 895,677.00                 2,072,698.00              43.21% 73,414.73                   555,931.90                 123,121.45                           339,745.10                 Planning Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 32,693.62                   234,492.11                 426,880.00                 54.93% 31,293.64                   235,597.90                 1,399.98                                (1,105.79)                    Benefits 6,104.38                      45,920.72                   81,800.00                   56.14% 5,728.60                      43,384.79                   375.78                                   2,535.93                     Operations 24,026.88                   63,814.74                   323,450.00                 19.73% 41,932.86                   271,336.85                 (17,905.98)                            (207,522.11)               Capital Projects ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                1,921.14                      1,921.14                      (1,921.14)                               (1,921.14)                    Total 62,824.88                   344,227.57                 832,130.00                 41.37% 80,876.24                   552,240.68                 (18,051.36)                            (208,013.11)               Urban Management Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 81,309.47                   591,708.70                 1,117,145.00              52.97% 75,812.44                   582,455.19                 5,497.03                                9,253.51                     Benefits 14,066.11                   139,319.54                 223,770.00                 62.26% 12,981.59                   123,246.34                 1,084.52                                16,073.20                   Operations 44,183.64                   292,589.82                 560,500.00                 52.20% 35,894.27                   300,148.52                 8,289.37                                (7,558.70)                    Capital Outlay ‐                                70,330.25                   129,000.00                 0.55                               ‐                                 ‐                                 ‐                                          70,330.25                   COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 139,559.22                 1,093,948.31              2,030,415.00              53.88% 124,688.30                 1,005,850.05              14,870.92                              88,098.26                   Facilities Maintenance Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 31,102.37                   214,723.57                 397,866.00                 53.97% 28,196.65                   214,344.04                 2,905.72                                379.53                         Benefits 5,298.50                      52,067.19                   81,396.00                   63.97% 4,667.91                      40,021.08                   630.59                                   12,046.11                   Operations 28,892.49                   110,534.28                 229,000.00                 48.27% 23,233.90                   101,734.75                 5,658.59                                8,799.53                     Capital Outlay ‐                                 ‐                                455,000.00                  ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                66,244.23                    ‐                                          (66,244.23)                  Total 65,293.36                   377,325.04                 1,163,262.00              32.44% 56,098.46                   422,344.10                 9,194.90                                (45,019.06)                  Public Works Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 27,287.26                   193,819.44                 355,055.00                 54.59% 25,779.49                   196,528.04                 1,507.77                                (2,708.60)                    Benefits 5,016.05                      43,619.28                   71,937.00                   60.64% 4,640.85                      39,836.80                   375.20                                   3,782.48                     Operations 14,940.50                   164,093.60                 327,718.00                 50.07% 9,600.59                      133,689.38                 5,339.91                                30,404.22                   Capital Outlay ‐                                 ‐                                0.00% 47,172.00                   47,172.00                   (47,172.00)                            (47,172.00)                  COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                695.55                          ‐                                          (695.55)                       Total 47,243.81                   401,532.32                 754,710.00                 53.20% 87,192.93                   417,921.77                 (39,949.12)                            (16,389.45)                  Police Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 439,447.39                 3,317,603.76              6,205,541.00              53.46% 372,190.14                 2,979,953.73              67,257.25                              337,650.03                 Benefits 77,085.78                   800,500.27                 1,280,084.00              62.53% 64,309.17                   649,578.96                 12,776.61                              150,921.31                 Operations 163,656.76                 1,040,302.45              2,089,530.62              49.79% 110,048.13                 802,000.23                 53,608.63                              238,302.22                 Capital Outlay 325,971.96                 392,499.88                 650,028.08                 0.60                               ‐                                 ‐                                325,971.96                           392,499.88                 COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                54,437.46                    ‐                                          (54,437.46)                  Total 1,006,161.89              5,550,906.36              10,225,183.70           54.29% 546,547.44                 4,485,970.38              459,614.45                           1,064,935.98             Fire Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 433,709.67                 3,131,408.59              5,687,258.00              55.06% 371,867.29                 3,058,429.06              61,842.38                              72,979.53                   Benefits 76,773.01                   792,775.18                 1,211,167.00              65.46% 66,973.90                   716,244.22                 9,799.11                                76,530.96                   Operations 78,217.28                   505,019.24                 1,500,762.21              33.65% 112,659.56                 568,929.80                 (34,442.28)                            (63,910.56)                  Capital Outlay 19,861.44                   218,776.81                 987,764.93                 22.15%‐                                213,425.57                 19,861.44                              5,351.24                     COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                60,379.92                    ‐                                          (60,379.92)                  Total 608,561.40                 4,647,979.82              9,386,952.14              49.52% 551,500.75                 4,617,408.57              57,060.65                              30,571.25                   Building Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 20,618.66                   148,553.24                 267,629.00                 55.51% 19,477.33                   146,045.18                 1,141.33                                2,508.06                     Benefits 3,800.26                      35,187.13                   56,692.00                   62.07% 3,497.18                      30,980.85                   303.08                                   4,206.28                     Operations 2,457.06                      18,598.17                   67,450.00                   27.57% 2,686.16                      20,817.34                   (229.10)                                  (2,219.17)                    Capital Outlay ‐                                 ‐                                26,000.00                    ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 26,875.98                   202,338.54                 417,771.00                 48.43% 25,660.67                   197,843.37                 1,215.31                                4,495.17                     Parks & Recreation Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 92,242.83                   614,440.23                 1,132,797.00              54.24% 80,415.42                   582,096.48                 11,827.41                              32,343.75                   Benefits 15,228.16                   136,810.00                 216,697.00                 63.13% 12,999.21                   115,562.91                 2,228.95                                21,247.09                   Operations 154,743.52                 658,171.36                 1,245,438.00              52.85% 112,184.13                 631,237.72                 42,559.39                              26,933.64                   Capital Outlay/ Capital Projects ‐                                 ‐                                1,702,054.08               ‐                                9,309.99                      9,309.99                      (9,309.99)                               (9,309.99)                    COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                209.95                          ‐                                          (209.95)                       Total 262,214.51                 1,409,421.59              4,296,986.08              32.80% 214,908.75                 1,338,417.05              47,305.76                              71,004.54                   Performing Arts Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 13,090.36                   85,033.48                   137,849.00                 61.69% 10,054.31                   70,393.63                   3,036.05                                14,639.85                   Benefits 2,289.20                      15,350.40                   24,304.00                   63.16% 1,571.99                      11,225.88                   717.21                                   4,124.52                     Operations 26,246.55                   136,974.13                 254,820.00                 53.75% 19,278.38                   56,875.53                   6,968.17                                80,098.60                   Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                23.96                            ‐                                          (23.96)                          Total 41,626.11                   237,358.01                 416,973.00                 56.92% 30,904.68                   138,519.00                 10,721.43                              98,839.01                   Non‐Departmental Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference City ‐ County Svcs 94,166.66                   316,166.67                 432,000.00                 73.19% 94,166.66                   321,666.68                  ‐                                          (5,500.01)                    Community Initiatives 49,357.86                   832,208.10                 1,240,839.00              67.07% 39,647.85                   170,377.65                 9,710.01                                661,830.45                 Unprocessed JP Morgan Payment 199,703.74                 199,703.74                  ‐                                100.00%‐                                 ‐                                199,703.74                           199,703.74                 Drug Proceeds Expenditures 684.50                         36,916.50                    ‐                                100.00%‐                                19,596.00                   684.50                                   17,320.50                   Transfer to DSF ‐ One Cent ‐ Infras 92,941.47                   400,621.79                 573,819.00                 69.82%‐                                 ‐                                92,941.47                              400,621.79                 Transfer to DSF ‐ Other ‐                                123,311.20                 123,311.00                 100.00% 92,941.47                   441,595.61                 (92,941.47)                            (318,284.41)               Transfer to DSF ‐ One Cent (old)‐                                111,250.00                 8,710,709.10              (111,250.00)                           Transfer to Group Health 274,750.00                 1,923,250.00              3,297,000.00              58.33% 256,844.00                 1,771,844.00              17,906.00                              151,406.00                 Transfer to Capital Project Fund 20,416.00                   2,234,338.00              5,132,682.41              0.44                               ‐                                 ‐                                20,416.00                              2,234,338.00             Transfer to Wasewater Fund ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           Transfer to Sanitation Fund ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Transfer to Gas Tax Fund ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Transfer to Judicial ‐                                 ‐                                261,287.00                  ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 732,020.23                 6,242,532.20              11,060,938.41           56.44% 594,849.98                 11,435,789.04           137,170.25                           3,341,436.06             Debt Service Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Debt Service 115,393.65                 1,051,829.90              2,134,891.00              49.27% 247,913.11                 1,138,239.06              (132,519.46)                          (86,409.16)                  Total 115,393.65                 1,051,829.90              2,134,891.00              49.27% 247,913.11                 1,138,239.06              (132,519.46)                          (86,409.16)                  Total Apr‐22 YTD Budget % of Budget Apr‐21 YTD April Difference YTD Difference Salary 1,368,895.90              9,909,317.94              18,255,628.60           54.28% 1,181,754.58              9,356,958.25              187,141.32                           552,359.69                 Benefits 513,823.32                 4,266,089.41              7,245,748.15              58.88% 461,017.42                 3,777,148.16              52,805.90                              488,941.25                 Operations 1,122,560.74              8,616,406.05              17,448,687.49           49.38% 824,946.31                 5,177,976.89              297,614.43                           3,438,429.16             Capital Outlay 435,006.00                 856,567.07                 4,304,847.09              19.90% 56,481.99                   290,762.69                 378,524.01                           565,804.38                 Debt Service 208,335.12                 1,575,762.89              2,832,021.00              55.64% 452,104.58                 10,290,543.77           (243,769.46)                          (8,714,780.88)            COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                28,589.14                   321,130.21                  Total 3,648,621.08              25,224,143.36           50,086,932.33           50.36% 3,004,894.02              29,214,519.97           672,316.20                           (3,669,246.40)            % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 50.36% Prepared by     Daniel Oakley