Loading...
October 2022 - Council Expenditure ReportAs of  11/13/2022 8.33 % Year Complete Executive Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 20,413.11                    20,413.11                    446,090.00                  4.58% 17,678.69                    17,678.69                    2,734.42                                 2,734.42                     Benefits 2,921.94                       2,921.94                       73,359.00                    3.98% 3,659.78                       3,659.78                       (737.84)                                   (737.84)                       Operations 12,267.34                    12,267.34                    315,998.00                  3.88% 23,795.91                    23,795.91                    (11,528.57)                             (11,528.57)                  Capital Outlay ‐                                 ‐                                 ‐                                 0.00% 20,000.00                    20,000.00                    (20,000.00)                             (20,000.00)                  COVID‐19 ‐                                 ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               Total 35,602.39                    35,602.39                    835,447.00                  4.26% 65,134.38                    65,134.38                    (29,531.99)                             (29,531.99)                  Legislative Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 10,418.06                    10,418.06                    125,000.00                  8.33% 10,417.04                    10,417.04                    1.02                                         1.02                             Benefits 692.37                          692.37                          10,474.00                    6.61% 815.59                          815.59                          (123.22)                                   (123.22)                       Operations ‐                                 ‐                                 30,100.00                    0.00% 415.82                          415.82                          (415.82)                                   (415.82)                       Capital Outlay ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               Total 11,110.43                    11,110.43                    165,574.00                  6.71% 11,648.45                    11,648.45                    (538.02)                                   (538.02)                       Finance Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 34,169.62                    34,169.62                    460,940.00                  7.41% 18,076.83                    18,076.83                    16,092.79                               16,092.79                   Benefits 6,502.74                       6,502.74                       90,693.00                    7.17% 5,165.31                       5,165.31                       1,337.43                                 1,337.43                     Operations 9,928.44                       9,928.44                       238,055.00                  4.17% 7,585.34                       7,585.34                       2,343.10                                 2,343.10                     Capital Outlay ‐                                 ‐                                 0.00% ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               Total 50,600.80                    50,600.80                    789,688.00                  6.41% 30,827.48                    30,827.48                    19,773.32                               19,773.32                   City Clerk Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 11,050.88                    11,050.88                    147,626.00                  7.49% 5,256.84                       5,256.84                       5,794.04                                 5,794.04                     Benefits 2,070.08                       2,070.08                       28,627.00                    7.23% 1,226.68                       1,226.68                       843.40                                    843.40                         Operations 12,597.85                    12,597.85                    140,640.00                  8.96% 10,080.95                    10,080.95                    2,516.90                                 2,516.90                     Capital Outlay ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               Total 25,718.81                    25,718.81                    316,893.00                  8.12% 16,564.47                    16,564.47                    9,154.34                                 9,154.34                     HR Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 27,423.16                    27,423.16                    362,688.00                  7.56% 12,339.86                    12,339.86                    15,083.30                               15,083.30                   Benefits 5,501.28                       5,501.28                       246,649.00                  2.23% 3,867.11                       3,867.11                       1,634.17                                 1,634.17                     Operations 377.80                          377.80                          197,600.00                  0.19% 3,614.35                       3,614.35                       (3,236.55)                                (3,236.55)                    Capital Outlay ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               Total 33,302.24                    33,302.24                    806,937.00                  4.13% 19,821.32                    19,821.32                    13,480.92                               13,480.92                   IT Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 16,702.48                    16,702.48                    232,474.00                  7.18% 10,172.20                    10,172.20                    6,530.28                                 6,530.28                     Benefits 3,010.27                       3,010.27                       43,377.00                    6.94% 2,646.59                       2,646.59                       363.68                                    363.68                         Operations 116,200.57                  116,200.57                  2,038,494.00               5.70% 281,315.48                  281,315.48                  (165,114.91)                           (165,114.91)               Capital Outlay ‐                                 ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               Total 135,913.32                  135,913.32                  2,314,345.00               5.87% 294,134.27                  294,134.27                  (158,220.95)                           (158,220.95)               Vehicle Maint. Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 14,208.64                    14,208.64                    238,347.00                  5.96% 9,745.05                       9,745.05                       4,463.59                                 4,463.59                     Benefits 2,630.82                       2,630.82                       53,131.00                    4.95% 5,981.13                       5,981.13                       (3,350.31)                                (3,350.31)                    Operations 3,286.23                       3,286.23                       97,050.00                    3.39% 4,966.60                       4,966.60                       (1,680.37)                                (1,680.37)                    Capital Outlay ‐                                 ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               Total 20,125.69                    20,125.69                    388,528.00                  5.18% 20,692.78                    20,692.78                    (567.09)                                   (567.09)                       City of Prattville October 2022 Unaudited Expenditures By Department Engineering Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 49,029.19                    49,029.19                    697,081.00                  7.03% 24,149.29                    24,149.29                    24,879.90                               24,879.90                   Benefits 9,595.62                      9,595.62                      184,712.00                  5.19% 12,917.29                    12,917.29                    (3,321.67)                               (3,321.67)                    Operations 71,146.64                    71,146.64                    1,315,053.00              5.41% 33,018.36                    33,018.36                    38,128.28                               38,128.28                   Capital Projects ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               Capital Outlay ‐                                ‐                                445,000.00                  0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               Total 129,771.45                  129,771.45                  2,641,846.00              4.91% 70,084.94                    70,084.94                    59,686.51                               59,686.51                   Planning Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 39,832.65                    39,832.65                    450,630.00                  8.84% 17,843.80                    17,843.80                    21,988.85                               21,988.85                   Benefits 5,974.54                      5,974.54                      90,406.00                    6.61% 5,187.55                      5,187.55                      786.99                                    786.99                        Operations 11,190.81                    11,190.81                    249,000.00                  4.49% 10,023.51                    10,023.51                    1,167.30                                 1,167.30                     Capital Projects ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               Total 56,998.00                    56,998.00                    790,036.00                  7.21% 33,054.86                    33,054.86                    23,943.14                               23,943.14                   Urban Management Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 83,210.98                    83,210.98                    1,151,880.00              7.22% 60,696.43                    60,696.43                    22,514.55                               22,514.55                   Benefits 15,137.34                    15,137.34                    257,288.00                  5.88% 19,260.23                    19,260.23                    (4,122.89)                               (4,122.89)                    Operations 22,404.10                    22,404.10                    623,250.00                  3.59% 43,947.74                    43,947.74                    (21,543.64)                             (21,543.64)                 Capital Outlay ‐                                ‐                                50,000.00                    0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               Total 120,752.42                  120,752.42                  2,082,418.00              5.80% 123,904.40                  123,904.40                  (3,151.98)                               (3,151.98)                    Facilities Maintenance Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 28,486.30                    28,486.30                    400,482.00                  7.11% 16,099.17                    16,099.17                    12,387.13                               12,387.13                   Benefits 4,947.35                      4,947.35                      87,527.00                    5.65% 5,589.39                      5,589.39                      (642.04)                                   (642.04)                       Operations 1,305.76                      1,305.76                      261,500.00                  0.50% 31,481.45                    31,481.45                    (30,175.69)                             (30,175.69)                 Capital Outlay ‐                                ‐                                670,000.00                  0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               Total 34,739.41                    34,739.41                    1,419,509.00              2.45% 53,170.01                    53,170.01                    (18,430.60)                             (18,430.60)                 Public Works Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 28,028.79                    28,028.79                    375,779.00                  7.46% 14,814.40                    14,814.40                    13,214.39                               13,214.39                   Benefits 5,446.98                      5,446.98                      80,973.00                    6.73% 5,689.03                      5,689.03                      (242.05)                                   (242.05)                       Operations 34,994.82                    34,994.82                    255,968.00                  13.67% 20,613.27                    20,613.27                    14,381.55                               14,381.55                   Capital Outlay ‐                                ‐                                300,000.00                  0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               Total 68,470.59                    68,470.59                    1,012,720.00              6.76% 41,116.70                    41,116.70                    27,353.89                               27,353.89                   Police Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 421,346.64                  421,346.64                  6,654,061.00              6.33% 257,287.65                  257,287.65                  164,058.99                            164,058.99                 Benefits 78,477.63                    78,477.63                    1,460,253.00              5.37% 110,762.61                  110,762.61                  (32,284.98)                             (32,284.98)                 Operations 83,818.21                    83,818.21                    1,656,828.00              5.06% 216,457.70                  216,457.70                  (132,639.49)                           (132,639.49)               Capital Outlay ‐                                ‐                                549,367.00                  0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               Total 583,642.48                  583,642.48                  10,320,509.00            5.66% 584,507.96                  584,507.96                  (865.48)                                   (865.48)                       Fire Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 424,600.28                  424,600.28                  6,152,966.00              6.90% 230,484.63                  230,484.63                  194,115.65                            194,115.65                 Benefits 82,134.17                    82,134.17                    1,387,748.00              5.92% 119,110.00                  119,110.00                  (36,975.83)                             (36,975.83)                 Operations 42,331.29                    42,331.29                    1,237,156.00              3.42% 82,098.39                    82,098.39                    (39,767.10)                             (39,767.10)                 Capital Outlay ‐                                ‐                                287,000.00                  0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               Total 549,065.74                  549,065.74                  9,064,870.00              6.06% 431,693.02                  431,693.02                  117,372.72                            117,372.72                 Building Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 15,539.91                    15,539.91                    263,338.00                  5.90% 11,268.64                    11,268.64                    4,271.27                                4,271.27                     Benefits 3,151.91                      3,151.91                      60,846.00                    5.18% 4,715.95                      4,715.95                      (1,564.04)                               (1,564.04)                    Operations 2,347.15                      2,347.15                      62,450.00                    3.76% 5,592.50                      5,592.50                      (3,245.35)                               (3,245.35)                    Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               COVID‐19 ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               Total 21,038.97                    21,038.97                    386,634.00                  5.44% 21,577.09                    21,577.09                    (538.12)                                  (538.12)                       Parks & Recreation Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 98,557.30                    98,557.30                    1,238,226.00              7.96% 45,281.81                    45,281.81                    53,275.49                              53,275.49                   Benefits 16,875.49                    16,875.49                    254,964.00                  6.62% 17,909.18                    17,909.18                    (1,033.69)                               (1,033.69)                    Operations 76,939.17                    76,939.17                    1,532,960.00              5.02% 59,736.56                    59,736.56                    17,202.61                              17,202.61                   Capital Outlay/ Capital Projects ‐                                ‐                                1,455,000.00              0.00% ‐                                ‐                                ‐                                          ‐                               COVID‐19 ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               Total 192,371.96                  192,371.96                  4,481,150.00              4.29% 122,927.55                  122,927.55                  69,444.41                              69,444.41                   Performing Arts Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 10,114.58                    10,114.58                    185,634.00                  5.45% 6,831.11                      6,831.11                      3,283.47                                3,283.47                     Benefits 1,931.21                      1,931.21                      31,359.00                    6.16% 1,591.39                      1,591.39                      339.82                                    339.82                        Operations 7,798.09                      7,798.09                      305,000.00                  2.56% 1,489.64                      1,489.64                      6,308.45                                6,308.45                     Capital Outlay ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               COVID‐19 ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               Total 19,843.88                    19,843.88                    521,993.00                  3.80% 9,912.14                      9,912.14                      9,931.74                                9,931.74                     Non‐Departmental Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference City ‐ County Svcs 15,833.33                    15,833.33                    472,000.00                  3.35% 80,000.00                    80,000.00                    (64,166.67)                             (64,166.67)                 Community Initiatives 27,851.18                    27,851.18                    778,643.00                  3.58% 24,434.01                    24,434.01                    3,417.17                                3,417.17                     Unprocessed JP Morgan Payment 186,412.76                  186,412.76                  ‐                                100.00% 176,016.20                  176,016.20                  10,396.56                              10,396.56                   Drug Proceeds Expenditures ‐                                ‐                                ‐                                100.00% ‐                                ‐                                ‐                                          ‐                               Transfer to DSF ‐ One Cent ‐ Infras 92,941.47                    92,941.47                    584,320.00                  15.91% 92,941.47                    92,941.47                    ‐                                          ‐                               Transfer to DSF ‐ One Cent ‐ P&R 232,907.03                  232,907.03                  860,545.00                  27.07% 232,907.03                            232,907.03                Transfer to DSF ‐ Other 123,311.20                  123,311.20                  123,311.00                  100.00% 123,311.20                  123,311.20                  ‐                                          ‐                               Transfer to DSF ‐ One Cent (old) ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               Transfer to Group Health 280,000.00                  280,000.00                  3,360,000.00              8.33% 274,750.00                  274,750.00                  5,250.00                                5,250.00                     Transfer to Capital Project Fund 12,090.75                    12,090.75                    2,204,000.00              0.55% ‐                                ‐                                12,090.75                              12,090.75                   Transfer to Wasewater Fund ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               Transfer to Sanitation Fund ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               Transfer to Gas Tax Fund ‐                                ‐                                98,605.00                    0.00% ‐                                ‐                                ‐                                          ‐                               Transfer to Judicial ‐                                ‐                                354,557.00                  0.00% ‐                                ‐                                ‐                                          ‐                               Total 971,347.72                  971,347.72                  8,835,981.00              10.99% 771,452.88                  771,452.88                  199,894.84                            199,894.84                Debt Service Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Debt Service 165,797.51                  165,797.51                  2,187,125.00              7.58% 24,970.10                    24,970.10                    140,827.41                            140,827.41                Total 165,797.51                  165,797.51                  2,187,125.00              7.58% 24,970.10                    24,970.10                    140,827.41                            140,827.41                Total Oct‐22 YTD Budget % of Budget Oct‐21 YTD October Difference YTD Difference Salary 1,333,132.57              1,333,132.57              19,583,242.00            6.81% 768,443.44                  768,443.44                  564,689.13                            564,689.13                Benefits 527,001.74                  527,001.74                  7,802,386.00              6.75% 600,844.81                  600,844.81                  (73,843.07)                             (73,843.07)                 Operations 751,122.29                  751,122.29                  14,464,907.00            5.19% 1,116,683.78              1,116,683.78              (365,561.49)                           (365,561.49)               Capital Outlay ‐                                ‐                                3,756,367.00              0.00% 20,000.00                    20,000.00                    (20,000.00)                             (20,000.00)                 Debt Service 614,957.21                  614,957.21                  3,755,301.00              16.38% 241,222.77                  241,222.77                  373,734.44                            373,734.44                COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                Total 3,226,213.81              3,226,213.81              49,362,203.00            6.54% 2,747,194.80              2,747,194.80              479,019.01                            479,019.01                % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 6.54% Prepared by      Daniel Oakley