Loading...
September 2022 - Council Expenditure ReportAs of  10/18/2022 100.00 % Year Complete Executive Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 27,228.80                    421,401.02                  422,665.00                  99.70% 26,248.74                    315,768.01                  980.06                                    105,633.01                 Benefits 3,925.58                       65,104.00                    65,858.00                    98.86% 4,001.08                       43,337.26                    (75.50)                                     21,766.74                   Operations 48,090.14                    205,463.88                  294,213.00                  69.84% 13,141.91                    162,977.52                  34,948.23                               42,486.36                   Capital Outlay ‐                                 45,414.53                    43,200.00                    105.13% ‐                                 48,364.25                    ‐                                           (2,949.72)                    COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 2,695.00                       5,435.93                       (2,695.00)                                (5,435.93)                    Total 79,244.52                    737,383.43                  825,936.00                  89.28% 46,086.73                    575,882.97                  33,157.79                               161,500.46                 Legislative Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 10,416.70                    125,003.46                  125,000.00                  100.00% 10,417.04                    125,616.13                  (0.34)                                        (612.67)                       Benefits 735.45                          9,152.77                       10,323.00                    88.66% 736.34                          9,398.71                       (0.89)                                        (245.94)                       Operations ‐                                 10,868.63                    30,400.00                    35.75% 76.72                            6,278.32                       (76.72)                                     4,590.31                     Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 11,152.15                    145,024.86                  165,723.00                  87.51% 11,230.10                    141,293.16                  (77.95)                                     3,731.70                     Finance Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 33,721.88                    419,666.95                  439,849.00                  95.41% 28,145.19                    380,455.36                  5,576.69                                 39,211.59                   Benefits 6,032.71                       79,355.82                    82,083.00                    96.68% 5,329.66                       64,862.15                    703.05                                    14,493.67                   Operations 14,669.14                    239,640.55                  252,820.00                  94.79% 13,144.29                    243,967.02                  1,524.85                                 (4,326.47)                    Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 54,423.73                    738,663.32                  774,752.00                  95.34% 46,619.14                    689,284.53                  7,804.59                                 49,378.79                   City Clerk Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 10,968.09                    132,145.32                  124,042.00                  106.53% 4,960.28                       143,311.99                  6,007.81                                 (11,166.67)                  Benefits 1,950.94                       24,167.92                    24,410.00                    99.01% 796.64                          18,582.48                    1,154.30                                 5,585.44                     Operations (1,246.53)                     103,116.29                  80,170.00                    128.62% 8,816.93                       50,631.67                    (10,063.46)                             52,484.62                   Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 19.95                            ‐                                           (19.95)                          Total 11,672.50                    259,429.53                  228,622.00                  113.48% 14,573.85                    212,546.09                  (2,901.35)                                46,883.44                   HR Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 26,796.90                    324,784.31                  343,172.00                  94.64% 15,551.01                    339,242.95                  11,245.89                               (14,458.64)                  Benefits 2,722.36                       289,811.95                  384,909.00                  75.29% 169,561.10                  226,161.79                  (166,838.74)                           63,650.16                   Operations 12,806.73                    79,894.62                    87,858.00                    90.94% 9,683.65                       58,648.73                    3,123.08                                 21,245.89                   Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 927.82                          ‐                                           (927.82)                       Total 42,325.99                    694,490.88                  815,939.00                  85.12% 194,795.76                  624,981.29                  (152,469.77)                           69,509.59                   IT Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 16,478.97                    219,735.62                  218,147.00                  100.73% 13,581.18                    232,146.72                  2,897.79                                 (12,411.10)                  Benefits 2,809.49                       39,044.27                    38,636.00                    101.06% 2,596.02                       38,178.06                    213.47                                    866.21                         Operations 29,424.49                    1,841,010.72               1,728,697.00               106.50% 69,679.98                    1,778,353.45               (40,255.49)                             62,657.27                   Capital Outlay ‐                                 121,598.00                  215,000.00                  56.56% ‐                                 20,855.13                    ‐                                           100,742.87                 COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 135,787.53                  ‐                                           (135,787.53)               Total 48,712.95                    2,221,388.61               2,200,480.00               100.95% 85,857.18                    2,205,320.89               (37,144.23)                             16,067.72                   Vehicle Maint. Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 13,976.11                    201,502.03                  234,957.00                  85.76% 17,370.98                    244,831.69                  (3,394.87)                                (43,329.66)                  Benefits 2,451.52                       48,699.80                    48,849.00                    99.69% 2,943.87                       49,723.69                    (492.35)                                   (1,023.89)                    Operations 4,512.61                       58,079.47                    101,650.00                  57.14% 537.67                          61,470.21                    3,974.94                                 (3,390.74)                    Capital Outlay ‐                                 31,262.82                    40,000.00                    78.16% ‐                                 ‐                                 ‐                                           31,262.82                   COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 20,940.24                    339,544.12                  425,456.00                  79.81% 20,852.52                    356,025.59                  87.72                                       (16,481.47)                  City of Prattville September 2022 Unaudited Expenditures By Department Engineering Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 48,070.79                    580,061.35                  619,777.00                  93.59% 34,714.24                    570,022.61                  13,356.55                               10,038.74                   Benefits 8,820.78                      142,965.75                  138,019.00                  103.58% 7,010.98                      119,693.82                  1,809.80                                 23,271.93                   Operations 72,066.35                    739,153.56                  1,214,902.00              60.84% 83,296.29                    408,092.90                  (11,229.94)                             331,060.66                 Capital Projects ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Capital Outlay 38,700.00                    140,525.38                  288,048.21                  48.79% 129,851.12                  129,851.12                  (91,151.12)                             10,674.26                   COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Total 167,657.92                  1,602,706.04              2,260,746.21              70.89% 254,872.63                  1,227,660.45              (87,214.71)                             375,045.59                 Planning Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 30,722.98                    410,093.55                  426,880.00                  96.07% 28,237.01                    433,515.26                  2,485.97                                 (23,421.71)                 Benefits 5,707.22                      79,308.79                    81,800.00                    96.95% 5,505.56                      76,969.05                    201.66                                    2,339.74                     Operations 9,145.87                      140,345.73                  329,817.67                  42.55% 42,960.50                    498,872.19                  (33,814.63)                             (358,526.46)               Capital Projects ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               Capital Outlay ‐                                15,136.00                    14,500.00                    104.39% ‐                                3,630.48                      ‐                                           11,505.52                   COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Total 45,576.07                    644,884.07                  852,997.67                  75.60% 76,703.07                    1,012,986.98              (31,127.00)                             (368,102.91)               Urban Management Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 82,083.97                    1,032,506.91              1,117,145.00              92.42% 73,440.35                    1,093,142.10              8,643.62                                 (60,635.19)                 Benefits 14,223.04                    223,665.16                  223,770.00                  99.95% 12,864.28                    204,059.50                  1,358.76                                 19,605.66                   Operations 59,060.13                    558,691.65                  560,500.00                  99.68% 46,827.95                    494,336.86                  12,232.18                               64,354.79                   Capital Outlay 44,202.12                    134,012.92                  153,203.00                  87.47% ‐                                18,952.54                    44,202.12                               115,060.38                 COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Total 199,569.26                  1,948,876.64              2,054,618.00              94.85% 133,132.58                  1,810,491.00              66,436.68                               138,385.64                 Facilities Maintenance Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 26,650.82                    356,024.30                  397,866.00                  89.48% 24,285.87                    402,668.79                  2,364.95                                 (46,644.49)                 Benefits 4,402.62                      80,200.32                    81,396.00                    98.53% 4,394.05                      69,024.27                    8.57                                         11,176.05                   Operations 30,560.89                    201,716.52                  229,000.00                  88.09% 2,176.35                      156,899.63                  28,384.54                               44,816.89                   Capital Outlay 279.30                          279.30                          455,000.00                  0.00                              ‐                                ‐                                279.30                                    279.30                        COVID‐19 ‐                                ‐                                ‐                                ‐                                66,244.23                    ‐                                           (66,244.23)                 Total 61,893.63                    638,220.44                  1,163,262.00              54.86% 30,856.27                    694,836.92                  31,037.36                               (56,616.48)                 Public Works Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 27,520.93                    343,146.22                  355,055.00                  96.65% 22,445.66                    360,331.94                  5,075.27                                 (17,185.72)                 Benefits 5,060.51                      72,976.02                    71,937.00                    101.44% 4,385.66                      67,822.15                    674.85                                    5,153.87                     Operations 32,339.65                    282,841.59                  327,718.00                  86.31% 5,510.00                      187,400.36                  26,829.65                               95,441.23                   Capital Outlay ‐                                ‐                                ‐                                9,600.00                      253,912.00                  (9,600.00)                               (253,912.00)               COVID‐19 ‐                                ‐                                ‐                                ‐                                695.55                          ‐                                           (695.55)                       Total 64,921.09                    698,963.83                  754,710.00                  92.61% 41,941.32                    870,162.00                  22,979.77                               (171,198.17)               Police Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 434,428.45                  5,690,012.26              6,205,541.00              91.69% 361,952.34                  5,425,690.14              72,476.11                               264,322.12                 Benefits 74,420.04                    1,262,858.79              1,280,084.00              98.65% 67,683.28                    1,064,624.95              6,736.76                                 198,233.84                 Operations 104,278.40                  1,753,868.02              2,089,530.00              83.94% 68,743.34                    1,183,824.36              35,535.06                               570,043.66                 Capital Outlay ‐                                474,026.80                  650,028.00                  72.92% 12,604.00                    12,604.00                    (12,604.00)                             461,422.80                 COVID‐19 ‐                                ‐                                ‐                                124,353.17                  178,790.63                  (124,353.17)                           (178,790.63)               Total 613,126.89                  9,180,765.87              10,225,183.00            89.79% 635,336.13                  7,865,534.08              (22,209.24)                             1,315,231.79             Fire Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 449,542.25                  5,423,063.36              5,687,258.00              95.35% 365,315.02                  5,526,332.38              84,227.23                               (103,269.02)               Benefits 81,029.58                    1,260,932.19              1,211,167.00              104.11% 69,702.94                    1,151,472.81              11,326.64                               109,459.38                 Operations 105,587.30                  996,985.04                  1,500,762.00              66.43% 40,857.55                    948,531.86                  64,729.75                               48,453.18                   Capital Outlay ‐                                759,922.14                  1,069,547.00              71.05% 41,946.10                    268,540.15                  (41,946.10)                             491,381.99                 COVID‐19 ‐                                ‐                                ‐                                ‐                                60,379.92                    ‐                                           (60,379.92)                 Total 636,159.13                  8,440,902.73              9,468,734.00              89.14% 517,821.61                  7,955,257.12              118,337.52                            485,645.61                 Building Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 46,513.87                    285,097.38                  267,629.00                  106.53% 19,852.80                    270,543.28                  26,661.07                               14,554.10                   Benefits 5,331.75                       59,316.54                    56,692.00                    104.63% 3,566.70                       52,413.44                    1,765.05                                 6,903.10                     Operations 1,406.23                       31,234.49                    67,450.00                    46.31% 4,218.04                       32,479.22                    (2,811.81)                                (1,244.73)                    Capital Outlay ‐                                 25,270.00                    26,000.00                    ‐                                 ‐                                 ‐                                 ‐                                           25,270.00                   COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 53,251.85                    400,918.41                  417,771.00                  95.97% 27,637.54                    355,435.94                  25,614.31                               45,482.47                   Parks & Recreation Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 84,269.97                    1,185,211.01               1,132,797.00               104.63% 67,234.32                    1,166,234.25               17,035.65                               18,976.76                   Benefits 13,021.62                    232,315.04                  216,697.00                  107.21% 12,092.59                    202,216.28                  929.03                                    30,098.76                   Operations 282,360.33                  1,485,664.58               1,245,438.00               119.29% 162,779.53                  1,221,108.48               119,580.80                            264,556.10                 Capital Outlay/ Capital Projects 868,747.00                  1,088,325.00               1,752,049.00               62.12% 37,699.24                    67,610.82                    831,047.76                            1,020,714.18             COVID‐19 ‐                                 ‐                                 ‐                                 2,695.00                       2,904.95                       (2,695.00)                                (2,904.95)                    Total 1,248,398.92               3,991,515.63               4,346,981.00               91.82% 282,500.68                  2,660,074.78               965,898.24                            1,331,440.85             Performing Arts Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 8,691.86                       144,711.70                  137,849.00                  104.98% 9,705.74                       136,629.34                  (1,013.88)                                8,082.36                     Benefits 1,519.36                       25,268.89                    24,304.00                    103.97% 1,519.55                       20,784.11                    (0.19)                                        4,484.78                     Operations 21,005.32                    248,695.96                  254,820.00                  97.60% 17,562.63                    146,238.33                  3,442.69                                 102,457.63                 Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 2,695.00                       2,718.96                       (2,695.00)                                (2,718.96)                    Total 31,216.54                    418,676.55                  416,973.00                  100.41% 31,482.92                    306,370.74                  (266.38)                                   112,305.81                 Non‐Departmental Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference City ‐ County Svcs ‐                                 424,500.00                  432,000.00                  98.26% ‐                                 430,000.00                  ‐                                           (5,500.00)                    Community Initiatives 407,340.03                  1,335,511.91               1,540,839.00               86.67% 16,666.67                    557,037.40                  390,673.36                            778,474.51                 Unprocessed JP Morgan Payment ‐                                 ‐                                 ‐                                 100.00% 150,095.08                  150,095.08                  (150,095.08)                           (150,095.08)               Drug Proceeds Expenditures ‐                                 41,683.00                    ‐                                 100.00% (12,604.00)                   6,992.00                       12,604.00                               34,691.00                   Transfer to DSF ‐ One Cent ‐ Infras ‐                                 535,818.51                  573,819.00                  93.38% ‐                                 ‐                                 ‐                                           535,818.51                 Transfer to DSF ‐ Other ‐                                 123,311.20                  123,311.00                  100.00% ‐                                 558,667.08                  ‐                                           (435,355.88)               Transfer to DSF ‐ One Cent (old) ‐                                 ‐                                 ‐                                 ‐                                 14,621,584.10            ‐                                           ‐                               Transfer to Group Health 274,750.00                  3,297,000.00               3,297,000.00               100.00% 252,500.00                  3,034,344.00               22,250.00                               262,656.00                 Transfer to Capital Project Fund 2,342,617.72               5,650,610.83               5,283,233.97               106.95% ‐                                 661,900.00                  2,342,617.72                         4,988,710.83             Transfer to Wasewater Fund ‐                                 ‐                                 ‐                                 ‐                                 111,162.96                  111,162.96                  (111,162.96)                           (111,162.96)               Transfer to Sanitation Fund ‐                                 ‐                                 ‐                                 ‐                                 703,786.63                  703,786.63                  (703,786.63)                           (703,786.63)               Transfer to Gas Tax Fund ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 42,723.04                    ‐                                           (42,723.04)                  Transfer to Judicial ‐                                 261,287.36                  261,287.00                  100.00% 19,377.00                    241,991.18                  (19,377.00)                             19,296.18                   Total 3,024,707.75               12,045,442.75            11,511,489.97            104.64% 1,240,984.34               21,120,283.47            1,783,723.41                         5,171,023.44             Debt Service Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Debt Service 377,544.01                  2,171,374.26               2,134,891.00               101.71% 180,545.59                  1,928,023.89               196,998.42                            243,350.37                 Total 377,544.01                  2,171,374.26               2,134,891.00               101.71% 180,545.59                  1,928,023.89               196,998.42                            243,350.37                 Total Sep‐22 YTD Budget % of Budget Sep‐21 YTD September Difference YTD Difference Salary 1,378,083.34               17,294,166.75            18,255,629.00            94.73% 1,123,457.77               17,166,482.94            254,625.57                            127,683.81                 Benefits 508,914.57                  7,292,144.02               7,337,934.00               99.38% 627,190.30                  6,513,668.52               (118,275.73)                           778,475.50                 Operations 3,576,024.80               16,690,864.40            17,913,105.64            93.18% 1,578,497.67               10,545,799.40            1,997,527.13                         6,145,065.00             Capital Outlay 951,928.42                  2,835,772.89               4,706,575.21               60.25% 231,700.46                  824,320.49                  720,227.96                            2,011,452.40             Debt Service 377,544.01                  2,830,503.97               2,832,021.00               99.95% 180,545.59                  17,108,275.07            196,998.42                            (14,277,771.10)          COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 132,438.17                  453,905.47                  Total 6,792,495.14               46,943,452.03            51,045,264.85            91.96% 3,873,829.96               52,612,451.89            3,051,103.35                         (5,215,094.39)            % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 91.96% Prepared by      Daniel Oakley