Loading...
April 2023 - Council Expenditure ReportAs of  5/11/2023 58.33 % Year Complete Executive Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 32,198.41                   177,749.50                 446,090.00                 39.85% 37,200.98                   245,467.79                 (5,002.57)                               (67,718.29)                  Benefits 5,051.48                      27,143.43                   73,359.00                   37.00% 5,695.02                      38,282.95                   (643.54)                                  (11,139.52)                  Operations 38,733.12                   184,275.15                 266,498.00                 69.15% 11,111.59                   93,733.72                   27,621.53                              90,541.43                   Capital Outlay 49,500.00                   49,500.00                   49,500.00                   0.00%‐                                23,814.53                   49,500.00                              25,685.47                   Total 125,483.01                 438,668.08                 835,447.00                 52.51% 54,007.59                   401,298.99                 71,475.42                              37,369.09                   Legislative Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 10,934.48                   67,604.38                   125,000.00                 54.08% 10,417.04                   72,919.28                   517.44                                   (5,314.90)                    Benefits 733.90                         5,016.21                      10,474.00                   47.89% 735.46                         5,416.11                      (1.56)                                       (399.90)                       Operations 259.80                         730.95                         30,100.00                   2.43% 1,968.00                      3,690.91                      (1,708.20)                               (2,959.96)                    Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 11,928.18                   73,351.54                   165,574.00                 44.30% 13,120.50                   82,026.30                   (1,192.32)                               (8,674.76)                    Finance Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 35,278.38                   265,832.20                 460,940.00                 57.67% 33,415.44                   236,138.93                 1,862.94                                29,693.27                   Benefits 6,559.49                      51,890.81                   90,693.00                   57.22% 5,979.10                      46,078.51                   580.39                                   5,812.30                     Operations 18,763.39                   112,657.86                 238,055.00                 47.32% 10,285.30                   177,265.98                 8,478.09                                (64,608.12)                  Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 60,601.26                   430,380.87                 789,688.00                 54.50% 49,679.84                   459,483.42                 10,921.42                              (29,102.55)                  City Clerk Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 11,539.67                   87,116.05                   170,626.00                 51.06% 10,644.60                   74,691.46                   895.07                                   12,424.59                   Benefits 2,123.59                      16,150.84                   30,457.72                   53.03% 1,887.98                      13,680.51                   235.61                                   2,470.33                     Operations 13,666.96                   71,415.88                   115,809.28                 61.67% 2,203.49                      54,561.69                   11,463.47                              16,854.19                   Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 27,330.22                   174,682.77                 316,893.00                 55.12% 14,736.07                   142,933.66                 12,594.15                              31,749.11                   HR Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 27,427.57                   212,190.04                 362,688.00                 58.50% 25,952.23                   178,411.62                 1,475.34                                33,778.42                   Benefits 5,293.61                      41,200.69                   246,649.00                 16.70% 4,796.86                      34,674.86                   496.75                                   6,525.83                     Operations 3,150.26                      66,122.79                   197,600.00                 33.46% 8,890.48                      45,927.96                   (5,740.22)                               20,194.83                   Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 35,871.44                   319,513.52                 806,937.00                 39.60% 39,639.57                   259,014.44                 (3,768.13)                               60,499.08                   IT Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 17,946.75                   129,234.55                 232,474.00                 55.59% 17,753.78                   129,423.29                 192.97                                   (188.74)                       Benefits 3,216.94                      23,891.98                   43,377.00                   55.08% 3,050.29                      23,096.80                   166.65                                   795.18                         Operations 113,938.37                 975,663.55                 2,008,494.00              48.58% 126,106.97                 1,199,747.78              (12,168.60)                            (224,084.23)               Capital Outlay ‐                                50,863.00                   30,000.00                   0.00%‐                                61,973.00                    ‐                                          (11,110.00)                  Total 135,102.06                 1,179,653.08              2,314,345.00              50.97% 146,911.04                 1,414,240.87              (11,808.98)                            (234,587.79)               Vehicle Maint. Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 14,399.58                   102,223.59                 238,347.00                 42.89% 17,142.72                   125,643.17                 (2,743.14)                               (23,419.58)                  Benefits 2,654.38                      26,179.92                   53,131.00                   49.27% 2,997.19                      32,394.83                   (342.81)                                  (6,214.91)                    Operations 4,626.24                      36,162.20                   97,050.00                   37.26% 6,075.34                      28,047.22                   (1,449.10)                               8,114.98                     Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 21,680.20                   164,565.71                 388,528.00                 42.36% 26,215.25                   186,085.22                 (4,535.05)                               (21,519.51)                  City of Prattville April 2023 Unaudited Expenditures By Department Engineering Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 50,533.79                   378,015.06                 697,081.00                 54.23% 44,867.48                   314,839.28                 5,666.31                                63,175.78                   Benefits 9,700.64                      105,213.68                 184,712.00                 56.96% 8,269.97                      87,665.13                   1,430.67                                17,548.55                   Operations 212,165.97                 648,431.97                 1,315,053.00              49.31% 54,226.13                   403,999.99                 157,939.84                           244,431.98                 Capital Outlay ‐                                587.95                         521,850.00                 0.11% 89,172.60                   89,172.60                   (89,172.60)                            (88,584.65)                  Total 272,400.40                 1,132,248.66              2,718,696.00              41.65% 196,536.18                 895,677.00                 75,864.22                              236,571.66                 Planning Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 27,481.94                   221,347.32                 450,630.00                 49.12% 32,693.62                   234,492.11                 (5,211.68)                               (13,144.79)                  Benefits 5,355.99                      42,016.62                   90,406.00                   46.48% 6,104.38                      45,920.72                   (748.39)                                  (3,904.10)                    Operations 8,870.82                      66,047.41                   249,000.00                 26.53% 24,026.88                   63,814.74                   (15,156.06)                            2,232.67                     Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 41,708.75                   329,411.35                 790,036.00                 41.70% 62,824.88                   344,227.57                 (21,116.13)                            (14,816.22)                  Urban Management Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 86,400.41                   584,174.86                 1,151,880.00              50.71% 81,309.47                   591,708.70                 5,090.94                                (7,533.84)                    Benefits 15,432.91                   137,413.12                 257,288.00                 53.41% 14,066.11                   139,319.54                 1,366.80                                (1,906.42)                    Operations 54,317.55                   357,072.53                 623,250.00                 57.29% 44,183.64                   292,589.82                 10,133.91                              64,482.71                   Capital Outlay ‐                                 ‐                                50,000.00                   0.00%‐                                70,330.25                    ‐                                          (70,330.25)                  Total 156,150.87                 1,078,660.51              2,082,418.00              51.80% 139,559.22                 1,093,948.31              16,591.65                              (15,287.80)                  Facilities Maintenance Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 29,478.27                   223,721.09                 400,482.00                 55.86% 31,102.37                   214,723.57                 (1,624.10)                               8,997.52                     Benefits 5,131.11                      53,165.45                   87,527.00                   60.74% 5,298.50                      52,067.19                   (167.39)                                  1,098.26                     Operations 178,900.70                 339,877.74                 261,500.00                 129.97% 28,892.49                   110,534.28                 150,008.21                           229,343.46                 Capital Outlay ‐                                 ‐                                670,000.00                 0.00%‐                                 ‐                                 ‐                                           ‐                               Total 213,510.08                 616,764.28                 1,419,509.00              43.45% 65,293.36                   377,325.04                 148,216.72                           239,439.24                 Public Works Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 25,147.49                   205,657.30                 375,779.00                 54.73% 27,287.26                   193,819.44                 (2,139.77)                               11,837.86                   Benefits 4,848.00                      45,521.09                   80,973.00                   56.22% 5,016.05                      43,619.28                   (168.05)                                  1,901.81                     Operations 8,377.40                      163,201.74                 255,968.00                 63.76% 14,940.50                   164,093.60                 (6,563.10)                               (891.86)                       Capital Outlay ‐                                50,993.65                   300,000.00                 17.00%‐                                 ‐                                 ‐                                          50,993.65                   Total 38,372.89                   465,373.78                 1,012,720.00              45.95% 47,243.81                   401,532.32                 (8,870.92)                               63,841.46                   Police Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 442,255.65                 3,359,392.33              6,654,061.00              50.49% 439,447.39                 3,317,603.76              2,808.26                                41,788.57                   Benefits 81,381.47                   790,286.17                 1,460,253.00              54.12% 77,085.78                   800,500.27                 4,295.69                                (10,214.10)                  Operations 133,812.73                 1,178,086.90              1,656,828.00              71.10% 163,656.76                 1,040,302.45              (29,844.03)                            137,784.45                 Capital Outlay 38,761.00                   38,761.00                   549,367.00                 7.06% 325,971.96                 392,499.88                 (287,210.96)                          (353,738.88)               Total 696,210.85                 5,366,526.40              10,320,509.00           52.00% 1,006,161.89              5,550,906.36              (309,951.04)                          (184,379.96)               Fire Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 425,426.26                 3,483,323.50              6,152,966.00              56.61% 433,709.67                 3,131,408.59              (8,283.41)                               351,914.91                 Benefits 80,716.31                   835,508.41                 1,387,748.00              60.21% 76,773.01                   792,775.18                 3,943.30                                42,733.23                   Operations 94,424.84                   659,432.65                 1,237,156.00              53.30% 78,217.28                   505,019.24                 16,207.56                              154,413.41                 Capital Outlay ‐                                1,505.00                      384,371.00                 0.39% 19,861.44                   218,776.81                 (19,861.44)                            (217,271.81)               Total 600,567.41                 4,979,769.56              9,162,241.00              54.35% 608,561.40                 4,647,979.82              (7,993.99)                               331,789.74                 Building Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 20,199.37                   140,298.18                 263,338.00                 53.28% 20,618.66                   148,553.24                 (419.29)                                  (8,255.06)                    Benefits 3,808.35                      33,746.55                   60,846.00                   55.46% 3,800.26                      35,187.13                   8.09                                        (1,440.58)                    Operations 2,217.13                      24,504.86                   62,450.00                   39.24% 2,457.06                      18,598.17                   (239.93)                                  5,906.69                     Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 26,224.85                   198,549.59                 386,634.00                 51.35% 26,875.98                   202,338.54                 (651.13)                                  (3,788.95)                    Parks & Recreation Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 96,846.00                   711,962.27                 1,238,226.00              57.50% 92,242.83                   614,440.23                 4,603.17                                97,522.04                   Benefits 16,849.02                   154,060.25                 254,964.00                 60.42% 15,228.16                   136,810.00                 1,620.86                                17,250.25                   Operations 163,520.90                 910,737.48                 1,487,050.50              61.24% 154,743.52                 658,171.36                 8,777.38                                252,566.12                 Capital Outlay/ Capital Projects 80,909.50                   164,524.00                 1,559,526.50              10.55%‐                                 ‐                                80,909.50                              164,524.00                 Total 358,125.42                 1,941,284.00              4,539,767.00              42.76% 262,214.51                 1,409,421.59              95,910.91                              531,862.41                 Performing Arts Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 13,160.06                   88,086.95                   185,634.00                 47.45% 13,090.36                   85,033.48                   69.70                                      3,053.47                     Benefits 2,302.35                      16,385.10                   31,359.00                   52.25% 2,289.20                      15,350.40                   13.15                                      1,034.70                     Operations 21,958.04                   160,014.57                 305,000.00                 52.46% 26,246.55                   136,974.13                 (4,288.51)                               23,040.44                   Capital Outlay ‐                                27,400.00                   27,400.00                   0.00%‐                                 ‐                                 ‐                                          27,400.00                   Total 37,420.45                   291,886.62                 549,393.00                 53.13% 41,626.11                   237,358.01                 (4,205.66)                               54,528.61                   Non‐Departmental Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference City ‐ County Svcs 95,416.67                   329,583.34                 472,000.00                 69.83% 94,166.66                   316,166.67                 1,250.01                                13,416.67                   Community Initiatives 100,661.51                 375,638.04                 778,643.00                 48.24% 49,357.86                   832,208.10                 51,303.65                              (456,570.06)               Unprocessed JP Morgan Payment ‐                                 ‐                                 ‐                                100.00% 199,703.74                 199,703.74                 (199,703.74)                          (199,703.74)               Drug Proceeds Expenditures ‐                                 ‐                                 ‐                                100.00% 684.50                         36,916.50                   (684.50)                                  (36,916.50)                  Transfer to DSF ‐ One Cent ‐ Infras 92,941.47                   503,316.44                 584,320.00                 86.14% 92,941.47                   400,621.79                  ‐                                          102,694.65                 Transfer to DSF ‐ One Cent ‐ P&R 627,637.50                 860,544.53                 860,545.00                 100.00%‐                                 ‐                                627,637.50                           860,544.53                 Transfer to DSF ‐ Other ‐                                123,311.20                 123,311.00                 100.00%‐                                123,311.20                  ‐                                           ‐                               Transfer to DSF ‐ One Cent (old)‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Transfer to Group Health 280,000.00                 1,960,000.00              3,360,000.00              58.33% 274,750.00                 1,923,250.00              5,250.00                                36,750.00                   Transfer to Capital Project Fund 60,273.41                   2,015,107.05              2,204,000.00              91.43% 20,416.00                   2,234,338.00              39,857.41                              (219,230.95)               Transfer to Wasewater Fund ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Transfer to Sanitation Fund ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Transfer to Gas Tax Fund ‐                                1,500,000.00              98,605.00                   1521.22%‐                                 ‐                                 ‐                                          1,500,000.00             Transfer to Judicial ‐                                354,556.85                 354,557.00                 100.00%‐                                 ‐                                 ‐                                          354,556.85                 Total 1,256,930.56              8,022,057.45              8,835,981.00              90.79% 732,020.23                 6,066,516.00              524,910.33                           1,955,541.45             Debt Service Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Debt Service 276,912.29                 1,410,024.89              2,187,125.00              64.47% 115,393.65                 1,051,829.90              161,518.64                           358,194.99                 Total 276,912.29                 1,410,024.89              2,187,125.00              64.47% 115,393.65                 1,051,829.90              161,518.64                           358,194.99                 Total Apr‐23 YTD Budget % of Budget Apr‐22 YTD April Difference YTD Difference Salary 1,366,654.08              10,437,929.17           19,606,242.00           53.24% 1,368,895.90              9,909,317.94              (2,241.82)                               528,611.23                 Benefits 531,159.54                 4,364,790.32              7,804,216.72              55.93% 513,823.32                 4,266,089.41              17,336.22                              98,700.91                   Operations 1,328,055.81              10,529,321.51           14,314,666.78           73.56% 1,122,560.74              8,616,406.05              205,495.07                           1,912,915.46             Capital Outlay 169,170.50                 384,134.60                 4,142,014.50              9.27% 435,006.00                 856,567.07                 (265,835.50)                          (472,432.47)               Debt Service 997,491.26                 2,897,197.06              3,755,301.00              77.15% 208,335.12                 1,575,762.89              789,156.14                           1,321,434.17             Total 4,392,531.19              28,613,372.66           49,622,441.00           57.66% 3,648,621.08              25,224,143.36           743,910.11                           3,389,229.30             % of Budget Expenditures 57.66% Prepared by     Carlee Sims