Loading...
February 2023 - Council Expenditure ReportAs of  3/17/2023 41.67 % Year Complete Executive Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 20,833.96                   115,173.02                 446,090.00                 25.82% 32,651.50                   167,083.50                 (11,817.54)                            (51,910.48)                  Benefits 3,010.40                      17,341.75                   73,359.00                   23.64% 4,901.92                      26,588.27                   (1,891.52)                               (9,246.52)                    Operations 18,434.08                   128,570.20                 315,998.00                 40.69% 14,856.28                   70,693.72                   3,577.80                                57,876.48                   Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                20,000.00                    ‐                                          (20,000.00)                  Total 42,278.44                   261,084.97                 835,447.00                 31.25% 52,409.70                   284,365.49                 (10,131.26)                            (23,280.52)                  Legislative Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 8,958.70                      47,711.20                   125,000.00                 38.17% 10,417.04                   52,085.20                   (1,458.34)                               (4,374.00)                    Benefits 672.40                         3,612.51                      10,474.00                   34.49% 735.46                         3,945.19                      (63.06)                                    (332.68)                       Operations ‐                                443.15                         30,100.00                   1.47% 50.00                           972.91                         (50.00)                                    (529.76)                       Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 9,631.10                      51,766.86                   165,574.00                 31.27% 11,202.50                   57,003.30                   (1,571.40)                               (5,236.44)                    Finance Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 36,398.42                   195,459.43                 460,940.00                 42.40% 34,520.07                   169,349.56                 1,878.35                                26,109.87                   Benefits 6,845.82                      38,754.60                   90,693.00                   42.73% 6,177.57                      34,128.09                   668.25                                   4,626.51                     Operations 14,844.59                   55,900.11                   238,055.00                 23.48% 11,646.27                   119,202.15                 3,198.32                                (63,302.04)                  Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                           ‐                               Total 58,088.83                   290,114.14                 789,688.00                 36.74% 52,343.91                   322,679.80                 5,744.92                                (32,565.66)                  City Clerk Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 11,244.70                   63,905.94                   147,626.00                 43.29% 10,576.44                   53,379.31                   668.26                                   10,526.63                   Benefits 2,086.66                      11,848.64                   28,627.00                   41.39% 1,874.73                      9,900.08                      211.93                                   1,948.56                     Operations 10,679.07                   46,976.19                   140,640.00                 33.40% 4,516.29                      41,900.71                   6,162.78                                5,075.48                     Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 24,010.43                   122,730.77                 316,893.00                 38.73% 16,967.46                   105,180.10                 7,042.97                                17,550.67                   HR Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 28,356.05                   156,733.60                 362,688.00                 43.21% 25,671.62                   127,103.75                 2,684.43                                29,629.85                   Benefits 5,425.59                      30,533.14                   246,649.00                 12.38% 4,796.66                      25,135.58                   628.93                                   5,397.56                     Operations 5,410.86                      38,108.86                   197,600.00                 19.29% 2,287.01                      27,802.37                   3,123.85                                10,306.49                   Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 39,192.50                   225,375.60                 806,937.00                 27.93% 32,755.29                   180,041.70                 6,437.21                                45,333.90                   IT Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 17,311.59                   93,635.09                   232,474.00                 40.28% 18,435.25                   93,716.72                   (1,123.66)                               (81.63)                          Benefits 3,129.88                      17,487.10                   43,377.00                   40.31% 3,169.36                      16,961.46                   (39.48)                                    525.64                         Operations 135,306.75                 803,443.86                 2,008,494.00              40.00% 77,264.40                   924,160.97                 58,042.35                              (120,717.11)               Capital Outlay 29,995.00                   50,863.00                   30,000.00                   0.00%‐                                61,973.00                   29,995.00                              (11,110.00)                  Total 185,743.22                 965,429.05                 2,314,345.00              41.72% 98,869.01                   1,096,812.15              86,874.21                              (131,383.10)               Vehicle Maint. Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 12,277.79                   76,895.64                   238,347.00                 32.26% 15,434.76                   91,371.29                   (3,156.97)                               (14,475.65)                  Benefits 2,162.98                      21,467.18                   53,131.00                   40.40% 2,704.57                      26,404.52                   (541.59)                                  (4,937.34)                    Operations 14.14                           30,777.21                   97,050.00                   31.71% 4,142.15                      16,835.25                   (4,128.01)                               13,941.96                   Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 14,454.91                   129,140.03                 388,528.00                 33.24% 22,281.48                   134,611.06                 (7,826.57)                               (5,471.03)                    City of Prattville February 2023 Unaudited Expenditures By Department Engineering Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 49,738.30                   277,655.97                 697,081.00                 39.83% 44,588.68                   224,931.39                 5,149.62                                52,724.58                   Benefits 9,642.08                      85,868.92                   184,712.00                 46.49% 8,218.80                      69,969.21                   1,423.28                                15,899.71                   Operations 78,506.26                   367,438.69                 1,315,053.00              27.94% 63,799.64                   288,365.59                 14,706.62                              79,073.10                   Capital Outlay ‐                                587.95                         445,000.00                 0.13%‐                                 ‐                                 ‐                                          587.95                         Total 137,886.64                 731,551.53                 2,641,846.00              27.69% 116,607.12                 583,266.19                 21,279.52                              148,285.34                 Planning Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 27,936.64                   165,928.74                 450,630.00                 36.82% 32,834.95                   168,698.81                 (4,898.31)                               (2,770.07)                    Benefits 5,500.76                      31,170.78                   90,406.00                   34.48% 6,134.23                      33,630.61                   (633.47)                                  (2,459.83)                    Operations 5,351.33                      43,703.08                   249,000.00                 17.55% 4,097.41                      32,008.73                   1,253.92                                11,694.35                   Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 38,788.73                   240,802.60                 790,036.00                 30.48% 43,066.59                   234,338.15                 (4,277.86)                               6,464.45                     Urban Management Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 84,116.59                   413,696.56                 1,151,880.00              35.91% 80,698.85                   429,350.06                 3,417.74                                (15,653.50)                  Benefits 15,548.20                   106,299.74                 257,288.00                 41.32% 13,975.28                   108,819.98                 1,572.92                                (2,520.24)                    Operations 45,208.09                   254,742.04                 623,250.00                 40.87% 26,214.82                   192,093.42                 18,993.27                              62,648.62                   Capital Outlay ‐                                 ‐                                50,000.00                   0.00%‐                                10,378.25                    ‐                                          (10,378.25)                  Total 144,872.88                 774,738.34                 2,082,418.00              37.20% 120,888.95                 740,641.71                 23,983.93                              34,096.63                   Facilities Maintenance Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 29,562.96                   164,310.90                 400,482.00                 41.03% 29,766.39                   153,788.32                 (203.43)                                  10,522.58                   Benefits 5,219.52                      42,772.27                   87,527.00                   48.87% 5,033.60                      41,730.47                   185.92                                   1,041.80                     Operations 46,514.02                   121,308.88                 261,500.00                 46.39% 21,848.51                   74,201.65                   24,665.51                              47,107.23                   Capital Outlay ‐                                 ‐                                670,000.00                 0.00%‐                                 ‐                                 ‐                                           ‐                               Total 81,296.50                   328,392.05                 1,419,509.00              23.13% 56,648.50                   269,720.44                 24,648.00                              58,671.61                   Public Works Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 27,269.03                   155,160.03                 375,779.00                 41.29% 27,311.36                   139,244.94                 (42.33)                                    15,915.09                   Benefits 5,109.76                      35,762.08                   80,973.00                   44.17% 5,020.43                      33,587.19                   89.33                                      2,174.89                     Operations 34,536.21                   145,251.80                 255,968.00                 56.75% 29,901.68                   134,386.50                 4,634.53                                10,865.30                   Capital Outlay ‐                                50,993.65                   300,000.00                 17.00%‐                                 ‐                                 ‐                                          50,993.65                   Total 66,915.00                   387,167.56                 1,012,720.00              38.23% 62,233.47                   307,218.63                 4,681.53                                79,948.93                   Police Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 442,168.34                 2,485,229.03              6,654,061.00              37.35% 453,698.66                 2,414,489.64              (11,530.32)                            70,739.39                   Benefits 81,695.81                   628,627.53                 1,460,253.00              43.05% 78,973.97                   640,844.73                 2,721.84                                (12,217.20)                  Operations 254,709.50                 944,374.23                 1,656,828.00              57.00% 68,344.48                   770,669.06                 186,365.02                           173,705.17                 Capital Outlay ‐                                 ‐                                549,367.00                 0.00%‐                                 ‐                                 ‐                                           ‐                               Total 778,573.65                 4,058,230.79              10,320,509.00           39.32% 601,017.11                 3,826,003.43              177,556.54                           232,227.36                 Fire Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 429,282.89                 2,612,252.22              6,152,966.00              42.46% 401,029.14                 2,281,317.18              28,253.75                              330,935.04                 Benefits 82,633.56                   669,525.36                 1,387,748.00              48.25% 73,761.39                   636,218.08                 8,872.17                                33,307.28                   Operations 72,402.38                   475,890.55                 1,237,156.00              38.47% 63,627.57                   341,016.14                 8,774.81                                134,874.41                 Capital Outlay ‐                                1,505.00                      384,371.00                 0.39% 67,903.52                   67,903.52                   (67,903.52)                            (66,398.52)                  Total 584,318.83                 3,759,173.13              9,162,241.00              41.03% 606,321.62                 3,326,454.92              (22,002.79)                            432,718.21                 Building Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 20,199.36                   99,899.44                   263,338.00                 37.94% 20,552.00                   107,382.58                 (352.64)                                  (7,483.14)                    Benefits 3,824.90                      26,104.57                   60,846.00                   42.90% 3,787.28                      27,599.57                   37.62                                      (1,495.00)                    Operations 2,731.28                      18,877.09                   62,450.00                   30.23% 1,179.31                      14,311.88                   1,551.97                                4,565.21                     Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 26,755.54                   144,881.10                 386,634.00                 37.47% 25,518.59                   149,294.03                 1,236.95                                (4,412.93)                    Parks & Recreation Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 88,935.28                   518,326.72                 1,238,226.00              41.86% 84,937.51                   430,222.54                 3,997.77                                88,104.18                   Benefits 16,291.29                   120,245.92                 254,964.00                 47.16% 14,571.79                   104,920.37                 1,719.50                                15,325.55                   Operations 146,639.00                 620,060.65                 1,487,050.50              41.70% 91,684.03                   351,347.53                 54,954.97                              268,713.12                 Capital Outlay/ Capital Projects ‐                                24,997.50                   1,559,526.50              1.60%‐                                 ‐                                 ‐                                          24,997.50                   Total 251,865.57                 1,283,630.79              4,539,767.00              28.28% 191,193.33                 886,490.44                 60,672.24                              397,140.35                 Performing Arts Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 12,073.84                   61,869.70                   185,634.00                 33.33% 11,846.68                   59,566.27                   227.16                                   2,303.43                     Benefits 2,224.05                      11,682.58                   31,359.00                   37.25% 2,071.67                      10,896.91                   152.38                                   785.67                         Operations 17,932.71                   96,518.15                   305,000.00                 31.65% 15,970.32                   87,732.28                   1,962.39                                8,785.87                     Capital Outlay 27,400.00                   27,400.00                   27,400.00                   0.00%‐                                 ‐                                27,400.00                              27,400.00                   Total 59,630.60                   197,470.43                 549,393.00                 35.94% 29,888.67                   158,195.46                 29,741.93                              39,274.97                   Non‐Departmental Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference City ‐ County Svcs 7,916.67                      226,250.00                 472,000.00                 47.93% 7,500.00                      202,916.67                 416.67                                   23,333.33                   Community Initiatives 31,666.67                   263,184.53                 778,643.00                 33.80% 43,959.34                   751,096.35                 (12,292.67)                            (487,911.82)               Unprocessed JP Morgan Payment ‐                                 ‐                                 ‐                                100.00%‐                                 ‐                                 ‐                                           ‐                               Drug Proceeds Expenditures ‐                                 ‐                                 ‐                                100.00%‐                                 ‐                                 ‐                                           ‐                               Transfer to DSF ‐ One Cent ‐ Infras 410,374.97                 584,320.00                 70.23%‐                                307,680.32                  ‐                                          102,694.65                 Transfer to DSF ‐ One Cent ‐ P&R ‐                                232,907.03                 860,545.00                 27.07%‐                                 ‐                                 ‐                                          232,907.03                 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,400,000.00              3,360,000.00              41.67% 274,750.00                 1,373,750.00              5,250.00                                26,250.00                   Transfer to Capital Project Fund 26,386.45                   1,035,039.92              2,204,000.00              46.96% 84,672.00                   1,402,642.00              (58,285.55)                            (367,602.08)               Transfer to Wasewater Fund ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Transfer to Sanitation Fund ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Transfer to Gas Tax Fund 1,500,000.00              1,500,000.00              98,605.00                   1521.22%‐                                 ‐                                1,500,000.00                        1,500,000.00             Transfer to Judicial 354,556.85                 354,556.85                 354,557.00                 100.00%‐                                 ‐                                354,556.85                           354,556.85                 Total 2,200,526.64              5,545,624.50              8,835,981.00              62.76% 410,881.34                 4,161,396.54              1,789,645.30                        1,384,227.96             Debt Service Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Debt Service 273,542.52                 906,069.03                 2,187,125.00              41.43% 24,086.36                   697,214.95                 249,456.16                           208,854.08                 Total 273,542.52                 906,069.03                 2,187,125.00              41.43% 24,086.36                   697,214.95                 249,456.16                           208,854.08                 Total Feb‐23 YTD Budget % of Budget Feb‐22 YTD February Difference YTD Difference Salary 1,346,664.44              7,703,843.23              19,583,242.00           39.34% 1,334,970.90              7,163,081.06              11,693.54                              540,762.17                 Benefits 531,023.66                 3,299,104.67              7,802,386.00              42.28% 510,658.71                 3,225,030.31              20,364.95                              74,074.36                   Operations 2,809,746.91              7,571,416.04              14,388,997.50           52.62% 637,561.51                 5,844,355.88              2,172,185.40                        1,727,060.16             Capital Outlay 57,395.00                   156,347.10                 4,015,664.50              3.89% 67,903.52                   160,254.77                 (10,508.52)                            (3,907.67)                    Debt Service 273,542.52                 1,672,662.23              3,755,301.00              44.54% 24,086.36                   1,128,206.47              249,456.16                           544,455.76                 Total 5,018,372.53              20,403,373.27           49,545,591.00           41.18% 2,575,181.00              17,520,928.49           2,443,191.53                        2,882,444.78             % of Budget Expenditures 41.18% Prepared by     Carlee Sims