Loading...
February 2022 - Council Expenditure ReportAs of  3/11/2022 41.67 % Year Complete Executive Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 32,651.50                   167,083.50                 422,665.00                 31.81% 22,940.68                   119,639.53                 9,710.82                                14,792.47                   Benefits 4,901.92                      26,588.27                   65,858.00                   40.37% 3,474.27                      16,522.37                   1,427.65                                10,065.90                   Operations 14,856.28                   70,693.72                   294,213.00                 24.03% 18,567.10                   57,803.22                   (3,710.82)                               12,890.50                   Capital Outlay ‐                                20,000.00                    ‐                                100.00%‐                                 ‐                                 ‐                                          20,000.00                   COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                412.40                         2,740.93                      (412.40)                                  (2,740.93)                    Total 52,409.70                   284,365.49                 782,736.00                 36.33% 45,394.45                   196,706.05                 7,015.25                                55,007.94                   Legislative Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 10,417.04                   52,085.20                   125,000.00                 41.67% 10,417.04                   52,696.85                    ‐                                          (611.65)                       Benefits 735.46                         3,945.19                      10,323.00                   38.22% 998.73                         4,124.69                      (263.27)                                  (179.50)                       Operations 50.00                           972.91                         30,400.00                   3.20% 40.00                           504.77                         10.00                                      468.14                         Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 11,202.50                   57,003.30                   165,723.00                 34.40% 11,455.77                   57,326.31                   (253.27)                                  (323.01)                       Finance Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 34,520.07                   169,349.56                 439,849.00                 38.50% 27,365.96                   148,002.66                 7,154.11                                21,346.90                   Benefits 6,177.57                      34,128.09                   82,082.00                   41.58% 5,193.21                      26,021.20                   984.36                                   8,106.89                     Operations 11,646.27                   119,202.15                 252,820.00                 47.15% 12,183.05                   179,244.61                 (536.78)                                  (60,042.46)                  Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 52,343.91                   322,679.80                 774,751.00                 41.65% 44,742.22                   353,268.47                 7,601.69                                (30,588.67)                  City Clerk Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 10,576.44                   53,379.31                   124,042.00                 43.03% 14,060.11                   65,805.02                   (3,483.67)                               (12,425.71)                  Benefits 1,874.73                      9,900.08                      24,411.00                   40.56% 1,607.50                      7,886.93                      267.23                                   2,013.15                     Operations 4,516.29                      41,900.71                   80,170.00                   52.26% 4,030.46                      14,088.39                   485.83                                   27,812.32                   Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                19.95                            ‐                                          (19.95)                          Total 16,967.46                   105,180.10                 228,623.00                 46.01% 19,698.07                   87,800.29                   (2,730.61)                               17,379.81                   HR Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 25,671.62                   127,103.75                 335,980.00                 37.83% 24,712.34                   144,169.82                 959.28                                   (17,066.07)                  Benefits 4,796.66                      25,135.58                   292,173.00                 8.60% 4,890.36                      25,887.46                   (93.70)                                    (751.88)                       Operations 2,287.01                      27,802.37                   95,600.00                   29.08% 4,120.05                      19,176.97                   (1,833.04)                               8,625.40                     Capital Outlay ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                100.00%‐                                927.82                          ‐                                          (927.82)                       Total 32,755.29                   180,041.70                 723,753.00                 24.88% 33,722.75                   190,162.07                 (967.46)                                  (10,120.37)                  IT Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 18,435.25                   93,716.72                   218,147.00                 42.96% 17,356.55                   94,527.43                   1,078.70                                (810.71)                       Benefits 3,169.36                      16,961.46                   38,636.00                   43.90% 3,191.42                      15,824.61                   (22.06)                                    1,136.85                     Operations 77,264.40                   924,160.97                 1,721,197.00              53.69% 183,893.86                 878,826.50                 (106,629.46)                          45,334.47                   Capital Outlay ‐                                61,973.00                   215,000.00                 0.29                               ‐                                 ‐                                 ‐                                          61,973.00                   COVID‐19 ‐                                 ‐                                 ‐                                12,008.58                   91,438.36                   (12,008.58)                            (91,438.36)                  Total 98,869.01                   1,096,812.15              2,192,980.00              50.01% 216,450.41                 1,080,616.90              (117,581.40)                          16,195.25                   Vehicle Maint. Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 15,434.76                   91,371.29                   234,957.00                 38.89% 17,382.66                   103,731.84                 (1,947.90)                               (12,360.55)                  Benefits 2,704.57                      26,404.52                   48,849.00                   54.05% 13,103.71                   25,953.23                   (10,399.14)                            451.29                         Operations 4,142.15                      16,835.25                   101,650.00                 16.56% 4,335.77                      25,481.64                   (193.62)                                  (8,646.39)                    Capital Outlay ‐                                 ‐                                40,000.00                    ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 22,281.48                   134,611.06                 425,456.00                 31.64% 34,822.14                   155,166.71                 (12,540.66)                            (20,555.65)                  City of Prattville February 2022 Unaudited Expenditures By Department Engineering Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 44,588.68                   224,931.39                 619,777.00                 36.29% 39,041.27                   227,341.59                 5,547.41                                (2,410.20)                    Benefits 8,218.80                      69,969.21                   138,019.00                 50.70% 25,399.02                   58,882.00                   (17,180.22)                            11,087.21                   Operations 63,799.64                   288,365.59                 1,214,902.00              23.74% 20,283.88                   112,742.38                 43,515.76                              175,623.21                 Capital Projects ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Capital Outlay ‐                                 ‐                                100,000.00                  ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 116,607.12                 583,266.19                 2,072,698.00              28.14% 84,724.17                   398,965.97                 31,882.95                              184,300.22                 Planning Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 32,834.95                   168,698.81                 426,880.00                 39.52% 31,206.31                   173,020.91                 1,628.64                                (4,322.10)                    Benefits 6,134.23                      33,630.61                   81,800.00                   41.11% 6,254.36                      31,941.45                   (120.13)                                  1,689.16                     Operations 4,097.41                      32,008.73                   323,450.00                 9.90% 44,974.90                   193,876.13                 (40,877.49)                            (161,867.40)               Capital Projects ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 43,066.59                   234,338.15                 832,130.00                 28.16% 82,435.57                   398,838.49                 (39,368.98)                            (164,500.34)               Urban Management Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 80,698.85                   429,350.06                 1,117,145.00              38.43% 75,605.66                   433,257.30                 5,093.19                                (3,907.24)                    Benefits 13,975.28                   108,819.98                 223,770.00                 48.63% 37,459.32                   97,671.63                   (23,484.04)                            11,148.35                   Operations 26,214.82                   192,093.42                 560,500.00                 34.27% 53,470.79                   229,319.96                 (27,255.97)                            (37,226.54)                  Capital Outlay ‐                                10,378.25                   129,000.00                 0.08                               ‐                                 ‐                                 ‐                                          10,378.25                   COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 120,888.95                 740,641.71                 2,030,415.00              36.48% 166,535.77                 760,248.89                 (45,646.82)                            (19,607.18)                  Facilities Maintenance Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 29,766.39                   153,788.32                 397,866.00                 38.65% 28,065.84                   158,067.47                 1,700.55                                (4,279.15)                    Benefits 5,033.60                      41,730.47                   81,396.00                   51.27% 9,611.81                      30,719.37                   (4,578.21)                               11,011.10                   Operations 21,848.51                   74,201.65                   229,000.00                 32.40% 27,358.00                   72,500.21                   (5,509.49)                               1,701.44                     Capital Outlay ‐                                 ‐                                455,000.00                  ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                26,530.80                   66,109.74                   (26,530.80)                            (66,109.74)                  Total 56,648.50                   269,720.44                 1,163,262.00              23.19% 91,566.45                   327,396.79                 (34,917.95)                            (57,676.35)                  Public Works Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 27,311.36                   139,244.94                 355,055.00                 39.22% 26,010.33                   144,926.24                 1,301.03                                (5,681.30)                    Benefits 5,020.43                      33,587.19                   71,937.00                   46.69% 9,497.80                      30,553.75                   (4,477.37)                               3,033.44                     Operations 29,901.68                   134,386.50                 327,718.00                 41.01% 22,353.33                   105,528.44                 7,548.35                                28,858.06                   Capital Outlay ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                695.55                          ‐                                          (695.55)                       Total 62,233.47                   307,218.63                 754,710.00                 40.71% 57,861.46                   281,703.98                 4,372.01                                25,514.65                   Police Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 453,698.66                 2,414,489.64              6,205,541.00              38.91% 382,607.39                 2,217,006.09              71,091.27                              197,483.55                 Benefits 78,973.97                   640,844.73                 1,280,084.00              50.06% 205,227.37                 518,051.97                 (126,253.40)                          122,792.76                 Operations 68,344.48                   770,669.06                 1,563,261.00              49.30% 56,476.40                   609,909.46                 11,868.08                              160,759.60                 Capital Outlay ‐                                 ‐                                526,102.00                  ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                63.84                           54,437.46                   (63.84)                                    (54,437.46)                  Total 601,017.11                 3,826,003.43              9,574,988.00              39.96% 644,375.00                 3,399,404.98              (43,357.89)                            426,598.45                 Fire Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 401,029.14                 2,281,317.18              5,687,258.00              40.11% 361,148.76                 2,305,429.88              39,880.38                              (24,112.70)                  Benefits 73,761.39                   636,218.08                 1,211,167.00              52.53% 235,942.06                 580,566.60                 (162,180.67)                          55,651.48                   Operations 63,627.57                   341,016.14                 1,126,017.00              30.29% 91,380.53                   362,770.91                 (27,752.96)                            (21,754.77)                  Capital Outlay 67,903.52                   67,903.52                   987,764.93                 0.07                               ‐                                176,548.62                 67,903.52                              (108,645.10)               COVID‐19 ‐                                 ‐                                 ‐                                (1,433.64)                    60,379.92                   1,433.64                                (60,379.92)                  Total 606,321.62                 3,326,454.92              9,012,206.93              36.91% 687,037.71                 3,485,695.93              (80,716.09)                            (159,241.01)               Building Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 20,552.00                   107,382.58                 267,629.00                 40.12% 19,465.60                   107,067.05                 1,086.40                                315.53                         Benefits 3,787.28                      27,599.57                   56,692.00                   48.68% 8,090.66                      23,968.42                   (4,303.38)                               3,631.15                     Operations 1,179.31                      14,311.88                   67,450.00                   21.22% 3,077.04                      15,546.42                   (1,897.73)                               (1,234.54)                    Capital Outlay ‐                                 ‐                                26,000.00                    ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 25,518.59                   149,294.03                 417,771.00                 35.74% 30,633.30                   146,581.89                 (5,114.71)                               2,712.14                     Parks & Recreation Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 84,937.51                   430,222.54                 1,132,797.00              37.98% 74,664.73                   420,600.22                 10,272.78                              9,622.32                     Benefits 14,571.79                   104,920.37                 216,697.00                 48.42% 33,432.59                   89,342.32                   (18,860.80)                            15,578.05                   Operations 91,684.03                   351,347.53                 1,230,438.00              28.55% 91,503.08                   427,932.80                 180.95                                   (76,585.27)                  Capital Outlay/ Capital Projects ‐                                 ‐                                488,000.00                  ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                130.00                          ‐                                          (130.00)                       Total 191,193.33                 886,490.44                 3,067,932.00              28.90% 199,600.40                 938,005.34                 (8,407.07)                               (51,514.90)                  Performing Arts Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 11,846.68                   59,566.27                   137,849.00                 43.21% 9,150.72                      50,542.17                   2,695.96                                9,024.10                     Benefits 2,071.67                      10,896.91                   24,304.00                   44.84% 1,612.86                      8,123.27                      458.81                                   2,773.64                     Operations 15,970.32                   87,732.28                   254,820.00                 34.43% 3,859.47                      31,188.83                   12,110.85                              56,543.45                   Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                23.96                            ‐                                          (23.96)                          Total 29,888.67                   158,195.46                 416,973.00                 37.94% 14,623.05                   89,878.23                   15,265.62                              68,317.23                   Non‐Departmental Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference City ‐ County Svcs 7,500.00                      202,916.67                 432,000.00                 46.97% 7,083.33                      220,416.69                 416.67                                   (17,500.02)                  Community Initiatives 43,959.34                   751,096.35                 1,240,839.00              60.53% 23,404.68                   120,920.96                 20,554.66                              630,175.39                 Unprocessed JP Morgan Payment ‐                                 ‐                                 ‐                                100.00%‐                                 ‐                                 ‐                                           ‐                               Drug Proceeds Expenditures ‐                                 ‐                                 ‐                                100.00% 6,229.00                      6,992.00                      (6,229.00)                               (6,992.00)                    Transfer to DSF ‐ One Cent ‐ Infras ‐                                307,680.32                 573,819.00                 53.62%‐                                 ‐                                 ‐                                          307,680.32                 Transfer to DSF ‐ Other ‐                                123,311.20                 123,311.00                 100.00% 82,515.72                   431,169.86                 (82,515.72)                            (307,858.66)               Transfer to DSF ‐ One Cent (old)‐                                1,586,430.00              8,599,459.10              (1,586,430.00)                        Transfer to Group Health 274,750.00                 1,373,750.00              3,297,000.00              41.67% 252,500.00                 1,262,500.00              22,250.00                              111,250.00                 Transfer to Capital Project Fund 84,672.00                   1,402,642.00              2,790,260.00              0.50                               ‐                                 ‐                                84,672.00                              1,402,642.00             Transfer to Wasewater Fund ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           Transfer to Sanitation Fund ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Transfer to Gas Tax Fund ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Transfer to Judicial ‐                                 ‐                                261,287.00                  ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 410,881.34                 4,337,412.74              8,718,516.00              49.75% 1,958,162.73              10,641,458.61           (1,547,281.39)                       2,119,397.03             Debt Service Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Debt Service 24,086.36                   697,214.95                 2,134,891.00              32.66% 317,318.89                 825,604.01                 (293,232.53)                          (128,389.06)               Total 24,086.36                   697,214.95                 2,134,891.00              32.66% 317,318.89                 825,604.01                 (293,232.53)                          (128,389.06)               Total Feb‐22 YTD Budget % of Budget Feb‐21 YTD February Difference YTD Difference Salary 1,334,970.90              7,163,081.06              18,248,437.00           39.25% 1,181,201.95              6,965,832.07              153,768.95                           197,248.99                 Benefits 510,658.71                 3,225,030.31              7,245,198.00              44.51% 857,487.05                 2,854,541.27              (346,828.34)                          370,489.04                 Operations 637,561.51                 5,844,355.88              14,197,992.00           41.16% 678,624.72                 3,684,771.29              (41,063.21)                            2,159,584.59             Capital Outlay 67,903.52                   160,254.77                 2,966,866.93              5.40%‐                                176,548.62                 67,903.52                              (16,293.85)                  Debt Service 24,086.36                   1,128,206.47              2,832,021.00              39.84% 1,986,264.61              9,856,232.97              (1,962,178.25)                       (8,728,026.50)            COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                37,581.98                   276,903.69                  Total 2,575,181.00              17,520,928.49           45,490,514.93           38.52% 4,741,160.31              23,814,829.91           (2,128,397.33)                       (6,016,997.73)            % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 38.52% Prepared by     Carlee Sims