Loading...
July 2022 - Council Expenditure ReportAs of  8/14/2022 83.33 % Year Complete Executive Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 48,977.25                    361,520.72                  422,665.00                  85.53% 51,867.77                    260,507.59                  (2,890.52)                                101,013.13                 Benefits 7,432.82                       56,298.60                    65,858.00                    85.48% 6,278.58                       35,123.74                    1,154.24                                 21,174.86                   Operations 9,898.06                       131,736.03                  294,213.00                  44.78% 28,192.23                    141,091.61                  (18,294.17)                             (9,355.58)                    Capital Outlay ‐                                 23,814.53                    43,200.00                    55.13% ‐                                 48,364.25                    ‐                                           (24,549.72)                  COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 2,740.93                       ‐                                           (2,740.93)                    Total 66,308.13                    573,369.88                  825,936.00                  69.42% 86,338.58                    487,828.12                  (20,030.45)                             85,541.76                   Legislative Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 10,416.70                    104,170.06                  125,000.00                  83.34% 10,417.04                    104,782.05                  (0.34)                                        (611.99)                       Benefits 778.63                          7,725.05                       10,323.00                    74.83% 693.16                          7,926.03                       85.47                                       (200.98)                       Operations 690.05                          7,284.05                       30,400.00                    23.96% 1,707.60                       4,142.90                       (1,017.55)                                3,141.15                     Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 11,885.38                    119,179.16                  165,723.00                  71.91% 12,817.80                    116,850.98                  (932.42)                                   2,328.18                     Finance Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 50,166.95                    352,529.61                  439,849.00                  80.15% 67,105.21                    318,866.37                  (16,938.26)                             33,663.24                   Benefits 9,059.40                       67,358.84                    82,083.00                    82.06% 9,418.80                       53,748.45                    (359.40)                                   13,610.39                   Operations 13,276.22                    209,272.66                  252,820.00                  82.78% 15,463.62                    215,558.92                  (2,187.40)                                (6,286.26)                    Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 72,502.57                    629,161.11                  774,752.00                  81.21% 91,987.63                    588,173.74                  (19,485.06)                             40,987.37                   City Clerk Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 15,691.05                    110,257.06                  124,042.00                  88.89% 17,396.97                    131,524.60                  (1,705.92)                                (21,267.54)                  Benefits 2,878.51                       20,283.87                    24,410.00                    83.10% 1,928.36                       16,998.73                    950.15                                    3,285.14                     Operations 9,504.64                       98,253.80                    80,170.00                    122.56% 9,536.12                       38,924.56                    (31.48)                                     59,329.24                   Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 19.95                            ‐                                           (19.95)                          Total 28,074.20                    228,794.73                  228,622.00                  100.08% 28,861.45                    187,467.84                  (787.25)                                   41,326.89                   HR Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 39,423.79                    271,080.99                  343,172.00                  78.99% 56,871.78                    298,841.27                  (17,447.99)                             (27,760.28)                  Benefits 99,515.13                    282,190.90                  384,909.00                  73.31% 8,290.31                       52,075.00                    91,224.82                               230,115.90                 Operations 4,899.56                       61,303.63                    87,858.00                    69.78% 4,318.84                       43,021.66                    580.72                                    18,281.97                   Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 927.82                          ‐                                           (927.82)                       Total 143,838.48                  614,575.52                  815,939.00                  75.32% 69,480.93                    394,865.75                  74,357.55                               219,709.77                 IT Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 24,857.37                    186,225.34                  218,147.00                  85.37% 37,391.28                    201,373.73                  (12,533.91)                             (15,148.39)                  Benefits 4,301.60                       33,338.99                    38,636.00                    86.29% 5,184.98                       32,702.84                    (883.38)                                   636.15                         Operations 116,605.62                  1,727,148.38               1,721,197.00               100.35% 97,512.72                    1,579,525.16               19,092.90                               147,623.22                 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 145,764.59                  2,068,310.71               2,192,980.00               94.32% 140,088.98                  1,970,244.39               5,675.61                                 98,066.32                   Vehicle Maint. Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 21,731.13                    173,495.59                  234,957.00                  73.84% 43,379.50                    210,215.83                  (21,648.37)                             (36,720.24)                  Benefits 3,843.84                       43,792.39                    48,849.00                    89.65% 5,712.82                       43,857.48                    (1,868.98)                                (65.09)                          Operations 9,887.09                       44,342.20                    101,650.00                  43.62% 8,509.04                       55,404.73                    1,378.05                                 (11,062.53)                  Capital Outlay 31,262.82                    31,262.82                    40,000.00                    0.78                               ‐                                 ‐                                 31,262.82                               31,262.82                   COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 66,724.88                    292,893.00                  425,456.00                  68.84% 57,601.36                    309,478.04                  9,123.52                                 (16,585.04)                  City of Prattville July 2022 Unaudited Expenditures By Department Engineering Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 73,154.51                    482,614.69                  619,777.00                  77.87% 104,068.75                  492,721.68                  (30,914.24)                             (10,106.99)                 Benefits 13,558.25                    125,097.95                  138,019.00                  90.64% 14,634.17                    105,031.19                  (1,075.92)                               20,066.76                   Operations 91,555.09                    595,975.42                  1,214,902.00              49.06% 30,491.89                    289,749.58                  61,063.20                               306,225.84                 Capital Projects ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Capital Outlay 1,500.00                      90,672.60                    158,350.00                  57.26% ‐                                ‐                                1,500.00                                 90,672.60                   COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Total 179,767.85                  1,294,360.66              2,131,048.00              60.74% 149,194.81                  887,502.45                  30,573.04                               406,858.21                 Planning Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 49,381.93                    346,390.75                  426,880.00                  81.14% 75,236.78                    373,768.91                  (25,854.85)                             (27,378.16)                 Benefits 9,286.35                      67,465.44                    81,800.00                    82.48% 10,775.43                    65,717.73                    (1,489.08)                               1,747.71                     Operations 11,879.19                    119,669.19                  329,817.67                  36.28% 59,649.16                    408,708.45                  (47,769.97)                             (289,039.26)               Capital Projects ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Capital Outlay 15,136.00                    15,136.00                    14,500.00                    ‐                                ‐                                ‐                                15,136.00                               15,136.00                   COVID‐19 ‐                                ‐                                ‐                                ‐                                3,630.48                      ‐                                           (3,630.48)                    Total 85,683.47                    548,661.38                  852,997.67                  64.32% 145,661.37                  851,825.57                  (59,977.90)                             (303,164.19)               Urban Management Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 119,388.21                  869,759.35                  1,117,145.00              77.86% 215,928.88                  942,923.85                  (96,540.67)                             (73,164.50)                 Benefits 20,487.14                    195,523.84                  223,770.00                  87.38% 26,801.76                    178,407.01                  (6,314.62)                               17,116.83                   Operations 57,399.80                    439,397.05                  560,500.00                  78.39% 32,829.38                    396,790.56                  24,570.42                               42,606.49                   Capital Outlay 29,858.80                    89,810.80                    129,000.00                  69.62% ‐                                ‐                                29,858.80                               89,810.80                   COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Total 227,133.95                  1,594,491.04              2,030,415.00              78.53% 275,560.02                  1,518,121.42              (48,426.07)                             76,369.62                   Facilities Maintenance Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 39,930.72                    302,811.78                  397,866.00                  76.11% 78,496.92                    349,903.41                  (38,566.20)                             (47,091.63)                 Benefits 6,663.70                      71,421.47                    81,396.00                    87.75% 9,820.94                      59,930.99                    (3,157.24)                               11,490.48                   Operations 27,458.51                    163,871.36                  229,000.00                  71.56% 5,835.30                      127,790.26                  21,623.21                               36,081.10                   Capital Outlay ‐                                ‐                                455,000.00                  ‐                                ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                ‐                                ‐                                66,244.23                    ‐                                           (66,244.23)                 Total 74,052.93                    538,104.61                  1,163,262.00              46.26% 94,153.16                    603,868.89                  (20,100.23)                             (65,764.28)                 Public Works Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 41,297.38                    288,111.73                  355,055.00                  81.15% 63,080.82                    311,903.82                  (21,783.44)                             (23,792.09)                 Benefits 7,665.94                      62,878.81                    71,937.00                    87.41% 8,874.98                      58,780.27                    (1,209.04)                               4,098.54                     Operations 8,125.80                      239,001.55                  327,718.00                  72.93% 15,890.03                    170,349.74                  (7,764.23)                               68,651.81                   Capital Outlay ‐                                ‐                                ‐                                4,800.00                      234,712.00                  (4,800.00)                               (234,712.00)               COVID‐19 ‐                                ‐                                ‐                                ‐                                695.55                          ‐                                           (695.55)                       Total 57,089.12                    589,992.09                  754,710.00                  78.17% 92,645.83                    776,441.38                  (35,556.71)                             (186,449.29)               Police Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 643,209.24                  4,846,238.13              6,205,541.00              78.10% 917,614.91                  4,666,693.82              (274,405.67)                           179,544.31                 Benefits 114,083.02                  1,115,811.16              1,280,084.00              87.17% 125,592.75                  928,131.78                  (11,509.73)                             187,679.38                 Operations 169,652.09                  1,541,776.86              2,089,530.00              73.79% 91,829.86                    1,052,067.18              77,822.23                               489,709.68                 Capital Outlay ‐                                474,026.80                  650,028.00                  72.92% ‐                                ‐                                ‐                                           474,026.80                 COVID‐19 ‐                                ‐                                ‐                                ‐                                54,437.46                    ‐                                           (54,437.46)                 Total 926,944.35                  7,977,852.95              10,225,183.00            78.02% 1,135,037.52              6,701,330.24              (208,093.17)                           1,276,522.71             Fire Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 635,619.31                  4,573,512.09              5,687,258.00              80.42% 941,582.68                  4,786,090.05              (305,963.37)                           (212,577.96)               Benefits 118,268.69                  1,107,135.17              1,211,167.00              91.41% 132,791.69                  1,014,516.64              (14,523.00)                             92,618.53                   Operations 124,217.78                  796,533.91                  1,500,762.00              53.08% 73,954.96                    797,221.14                  50,262.82                               (687.23)                       Capital Outlay ‐                                759,922.14                  987,765.00                  76.93% ‐                                213,898.57                  ‐                                           546,023.57                 COVID‐19 ‐                                ‐                                ‐                                ‐                                60,379.92                    ‐                                           (60,379.92)                 Total 878,105.78                  7,237,103.31              9,386,952.00              77.10% 1,148,329.33              6,872,106.32              (270,223.55)                           364,996.99                 Building Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 31,270.75                    217,686.71                  267,629.00                  81.34% 45,627.39                    230,771.77                  (14,356.64)                             (13,085.06)                  Benefits 5,829.54                       50,132.43                    56,692.00                    88.43% 6,611.10                       45,270.03                    (781.56)                                   4,862.40                     Operations 3,065.59                       27,587.76                    67,450.00                    40.90% 2,296.99                       25,616.61                    768.60                                    1,971.15                     Capital Outlay ‐                                 ‐                                 26,000.00                    ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 40,165.88                    295,406.90                  417,771.00                  70.71% 54,535.48                    301,658.41                  (14,369.60)                             (6,251.51)                    Parks & Recreation Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 180,458.80                  1,008,472.44               1,132,797.00               89.02% 249,305.45                  1,014,502.17               (68,846.65)                             (6,029.73)                    Benefits 25,987.27                    204,479.04                  216,697.00                  94.36% 29,897.66                    176,648.43                  (3,910.39)                                27,830.61                   Operations 113,006.64                  1,048,417.65               1,245,438.00               84.18% 75,940.28                    948,915.58                  37,066.36                               99,502.07                   Capital Outlay/ Capital Projects 20,339.64                    219,573.64                  1,702,054.00               12.90% ‐                                 9,309.99                       20,339.64                               210,263.65                 COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 209.95                          ‐                                           (209.95)                       Total 339,792.35                  2,480,942.77               4,296,986.00               57.74% 355,143.39                  2,149,586.12               (15,351.04)                             331,356.65                 Performing Arts Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 19,135.22                    123,635.74                  137,849.00                  89.69% 26,555.64                    116,760.63                  (7,420.42)                                6,875.11                     Benefits 2,974.67                       21,616.77                    24,304.00                    88.94% 3,342.88                       17,691.39                    (368.21)                                   3,925.38                     Operations 25,635.90                    196,332.73                  254,820.00                  77.05% 36,324.18                    106,965.39                  (10,688.28)                             89,367.34                   Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 23.96                            ‐                                           (23.96)                          Total 47,745.79                    341,585.24                  416,973.00                  81.92% 66,222.70                    241,441.37                  (18,476.91)                             100,143.87                 Non‐Departmental Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference City ‐ County Svcs 87,083.33                    417,416.66                  432,000.00                  96.62% 87,083.33                    422,916.67                  ‐                                           (5,500.01)                    Community Initiatives 16,666.67                    911,505.21                  1,240,839.00               73.46% 142,845.22                  500,968.05                  (126,178.55)                           410,537.16                 Unprocessed JP Morgan Payment ‐                                 ‐                                 ‐                                 100.00% ‐                                 ‐                                 ‐                                           ‐                               Drug Proceeds Expenditures ‐                                 41,683.00                    ‐                                 100.00% ‐                                 19,596.00                    ‐                                           22,087.00                   Transfer to DSF ‐ One Cent ‐ Infras 92,941.47                    520,553.26                  573,819.00                  90.72% ‐                                 ‐                                 92,941.47                               520,553.26                 Transfer to DSF ‐ Other ‐                                 123,311.20                  123,311.00                  100.00% 92,941.47                    558,667.08                  (92,941.47)                             (435,355.88)               Transfer to DSF ‐ One Cent (old) ‐                                 ‐                                 ‐                                 ‐                                 8,710,709.10               ‐                                           ‐                               Transfer to Group Health 274,750.00                  2,747,500.00               3,297,000.00               83.33% 252,500.00                  2,529,344.00               22,250.00                               218,156.00                 Transfer to Capital Project Fund 28,445.95                    2,707,479.95               5,283,233.97               51.25% ‐                                 ‐                                 28,445.95                               2,707,479.95             Transfer to Wasewater Fund ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Transfer to Sanitation Fund ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Transfer to Gas Tax Fund ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Transfer to Judicial ‐                                 261,287.36                  261,287.00                  100.00% ‐                                 ‐                                 ‐                                           261,287.36                 Total 499,887.42                  8,106,456.58               11,211,489.97            72.30% 575,370.02                  12,742,200.90            (75,482.60)                             3,699,244.84             Debt Service Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Debt Service 172,866.51                  1,749,329.15               2,134,891.00               81.94% 221,826.09                  1,608,827.04               (48,959.58)                             140,502.11                 Total 172,866.51                  1,749,329.15               2,134,891.00               81.94% 221,826.09                  1,608,827.04               (48,959.58)                             140,502.11                 Total Jul‐22 YTD Budget % of Budget Jul‐21 YTD July Difference YTD Difference Salary 2,044,110.31               14,618,512.78            18,255,629.00            80.08% 3,001,927.77               14,812,151.55            (957,817.46)                           (193,638.77)               Benefits 727,364.50                  6,280,050.72               7,337,934.00               85.58% 659,150.37                  5,421,901.73               68,214.13                               858,148.99                 Operations 928,953.58                  11,787,276.41            17,605,605.64            66.95% 820,210.75                  7,345,324.75               108,742.83                            4,441,951.66             Capital Outlay 98,097.26                    1,825,817.33               4,420,897.00               41.30% 4,800.00                       527,139.94                  93,297.26                               1,298,677.39             Debt Service 265,807.98                  2,393,193.61               2,832,021.00               84.50% 314,767.56                  10,878,203.22            (48,959.58)                             (8,485,009.61)            COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 325,097.78                  Total 4,064,333.63               36,904,850.85            50,452,086.64            73.15% 4,800,856.45               39,309,818.97            (736,522.82)                           (2,079,870.34)            % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 73.15% Prepared by      Daniel Oakley