Loading...
March 2021 - Council Expenditure ReportAs of  4/16/2021 50.00 % Year Complete Executive Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 21,361.93                    141,001.46                  454,953.00                  30.99% 20,215.46                    136,433.87                  1,146.47                                 4,567.59                     Benefits 2,928.09                       19,450.46                    69,484.00                    27.99% 2,540.18                       17,416.19                    387.91                                    2,034.27                     Operations 10,006.82                    67,810.04                    266,400.00                  25.45% 4,311.18                       50,022.96                    5,695.64                                 17,787.08                   Capital Outlay ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 2,740.93                       100.00% ‐                                           2,740.93                     Total 34,296.84                    231,002.89                  790,837.00                  29.21% 27,066.82                    203,873.02                  7,230.02                                 27,129.87                   Legislative Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 10,417.04                    63,113.89                    125,000.00                  50.49% 10,417.04                    62,502.24                    ‐                                           611.65                         Benefits 774.56                          4,899.25                       10,306.00                    47.54% 717.82                          4,720.10                       56.74                                       179.15                         Operations 1,207.98                       1,712.75                       20,900.00                    8.19% 804.00                          2,391.88                       403.98                                    (679.13)                       Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                ‐                                           ‐                               Total 12,399.58                    69,725.89                    156,206.00                  44.64% 11,938.86                    69,614.22                    460.72                                    111.67                         Finance Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 26,113.89                    174,116.55                  403,498.00                  43.15% 25,036.10                    163,274.82                  1,077.79                                 10,841.73                   Benefits 4,597.59                       30,618.79                    72,462.00                    42.25% 4,052.66                       26,591.79                    544.93                                    4,027.00                     Operations 12,613.82                    191,858.43                  237,750.00                  80.70% 33,682.49                    149,288.95                  (21,068.67)                             42,569.48                   Capital Outlay ‐                                 0.00% ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 100.00% ‐                                           ‐                               Total 43,325.30                    396,593.77                  713,710.00                  55.57% 62,771.25                    339,155.56                  (19,445.95)                             57,438.21                   City Clerk Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 13,750.98                    79,556.00                    144,744.00                  54.96% 9,237.90                       65,944.57                    4,513.08                                 13,611.43                   Benefits 1,979.59                       9,866.52                       25,190.00                    39.17% 1,448.74                       10,933.84                    530.85                                    (1,067.32)                    Operations 5,072.08                       19,160.47                    51,670.00                    37.08% 1,416.17                       14,558.57                    3,655.91                                 4,601.90                     Capital Outlay ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 19.95                            100.00% ‐                                           19.95                           Total 20,802.65                    108,602.94                  221,604.00                  49.01% 12,102.81                    91,436.98                    8,699.84                                 17,165.96                   HR Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 24,332.31                    168,502.13                  316,371.00                  53.26% 23,724.53                    154,573.68                  607.78                                    13,928.45                   Benefits 4,445.32                       30,332.78                    459,716.00                  6.60% 4,198.95                       27,696.68                    246.37                                    2,636.10                     Operations 1,871.78                       21,048.75                    91,025.00                    23.12% 11,360.81                    34,070.98                    (9,489.03)                                (13,022.23)                  Capital Outlay ‐                                 ‐                                 0.00% ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 927.82                          100.00% ‐                                           927.82                         Total 30,649.41                    220,811.48                  867,112.00                  25.47% 39,284.29                    216,341.34                  (8,634.88)                                4,470.14                     IT Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 17,217.73                    111,745.16                  204,469.00                  54.65% 15,206.28                    95,954.55                    2,011.45                                 15,790.61                   Benefits 2,891.60                       18,716.21                    35,188.00                    53.19% 2,268.00                       14,607.84                    623.60                                    4,108.37                     Operations 193,582.60                  1,072,409.10               1,808,147.00               59.31% 69,657.53                    756,778.30                  123,925.07                            315,630.80                 Capital Outlay 20,855.13                    20,855.13                    94,552.00                    22.06% ‐                                 94,038.13                    20,855.13                               (73,183.00)                  COVID‐19 15,422.94                    106,861.30                  100.00% 15,422.94                               106,861.30                 Total 249,970.00                  1,330,586.90               2,142,356.00               62.11% 87,131.81                    961,378.82                  162,838.19                            369,208.08                 Vehicle Maint. Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 16,641.16                    120,373.00                  227,010.00                  53.03% 17,363.56                    113,118.35                  (722.40)                                   7,254.65                     Benefits 2,819.95                       28,773.18                    47,083.00                    61.11% 2,847.46                       24,814.29                    (27.51)                                     3,958.89                     Operations 5,755.33                       31,236.97                    98,150.00                    31.83% 9,879.44                       46,415.98                    (4,124.11)                                (15,179.01)                  Capital Outlay ‐                                 ‐                                 7,500.00                       0.00% ‐                                 8,580.00                       ‐                                           (8,580.00)                    COVID‐19 ‐                                 ‐                                 100.00% ‐                                           ‐                               Total 25,216.44                    180,383.15                  379,743.00                  47.50% 30,090.46                    192,928.62                  (4,874.02)                                (12,545.47)                  City of Prattville March 2021 Unaudited Expenditures By Department Engineering Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 38,697.35                    266,038.94                  541,734.00                  49.11% 33,164.85                    225,406.94                  5,532.50                                 40,632.00                   Benefits 6,880.12                      65,762.12                    113,070.00                  58.16% 5,857.24                      51,710.41                    1,022.88                                 14,051.71                   Operations 37,973.73                    150,716.11                  793,700.00                  18.99% 30,914.43                    168,978.48                  7,059.30                                 (18,262.37)                 Capital Outlay ‐                                ‐                                0.00% 12,750.00                    12,750.00                    (12,750.00)                             (12,750.00)                 COVID‐19 ‐                                ‐                                100.00% ‐                                           ‐                               Total 83,551.20                    482,517.17                  1,448,504.00              33.31% 82,686.52                    458,845.83                  864.68                                    23,671.34                   Planning Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 31,283.35                    204,304.26                  404,595.00                  50.50% 24,222.51                    152,843.50                  7,060.84                                 51,460.76                   Benefits 5,714.74                      37,656.19                    76,496.00                    49.23% 4,437.82                      27,629.46                    1,276.92                                 10,026.73                   Operations 35,527.86                    229,403.99                  540,450.00                  42.45% 35,109.33                    245,976.09                  418.53                                    (16,572.10)                 Capital Outlay ‐                                ‐                                0.00% ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                100.00% ‐                                ‐                                           ‐                               Total 72,525.95                    471,364.44                  1,021,541.00              46.14% 63,769.66                    426,449.05                  8,756.29                                 44,915.39                   Urban Management Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 73,385.45                    506,642.75                  990,654.00                  51.14% 67,974.27                    437,055.40                  5,411.18                                 69,587.35                   Benefits 12,593.12                    110,264.75                  193,188.00                  57.08% 10,955.95                    82,855.06                    1,637.17                                 27,409.69                   Operations 34,934.29                    264,254.25                  528,000.00                  50.05% 28,821.48                    242,129.03                  6,112.81                                 22,125.22                   Capital Outlay ‐                                ‐                                81,000.00                    0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                100.00% ‐                                           ‐                               Total 120,912.86                  881,161.75                  1,792,842.00              49.15% 107,751.70                  762,039.49                  13,161.16                              119,122.26                Facilities Maintenance Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 28,079.92                    186,147.39                  380,874.00                  48.87% 27,750.99                    180,600.98                  328.93                                    5,546.41                     Benefits 4,633.80                      35,353.17                    67,073.00                    52.71% 4,230.46                      30,961.61                    403.34                                    4,391.56                     Operations 6,000.64                      78,500.85                    222,550.00                  35.27% 7,942.24                      70,203.11                    (1,941.60)                               8,297.74                     Capital Outlay ‐                                ‐                                375,000.00                  0.00% ‐                                13,626.00                    ‐                                           (13,626.00)                 COVID‐19 134.49                          66,244.23                    100.00% 134.49                                    66,244.23                   Total 38,848.85                    366,245.64                  1,045,497.00              35.03% 39,923.69                    295,391.70                  (1,074.84)                               70,853.94                   Public Works Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 25,822.31                    170,748.55                  332,353.00                  51.38% 24,556.88                    155,731.43                  1,265.43                                 15,017.12                   Benefits 4,642.20                      35,195.95                    64,481.00                    54.58% 4,188.66                      30,037.51                    453.54                                    5,158.44                     Operations 18,560.35                    124,088.79                  212,718.00                  58.33% 14,951.50                    140,039.95                  3,608.85                                 (15,951.16)                 Capital Outlay ‐                                ‐                                520,000.00                  0.00% ‐                                ‐                                           ‐                               COVID‐19 ‐                                695.55                          100.00% ‐                                           695.55                        Total 49,024.86                    330,728.84                  1,129,552.00              29.28% 43,697.04                    325,808.89                  5,327.82                                 4,919.95                     Police Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 390,757.50                  2,607,763.59              5,753,608.00              45.32% 389,524.93                  2,616,906.67              1,232.57                                 (9,143.08)                    Benefits 67,217.82                    585,269.79                  1,114,150.00              52.53% 63,095.53                    527,443.89                  4,122.29                                 57,825.90                   Operations 82,042.64                    691,952.10                  1,324,221.00              52.25% 78,527.78                    696,088.41                  3,514.86                                 (4,136.31)                    Capital Outlay ‐                                ‐                                6,229.00                      0.00% 17,316.12                    113,457.04                  (17,316.12)                             (113,457.04)               COVID‐19 ‐                                54,437.46                    100.00% ‐                                           54,437.46                   Total 540,017.96                  3,939,422.94              8,198,208.00              48.05% 548,464.36                  3,953,896.01              (8,446.40)                               (14,473.07)                 Fire Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 381,131.89                  2,686,561.77              5,114,439.00              52.53% 351,864.36                  2,527,161.09              29,267.53                              159,400.68                Benefits 68,703.72                    649,270.32                  1,059,303.00              61.29% 60,697.75                    553,899.58                  8,005.97                                 95,370.74                   Operations 93,499.33                    456,270.24                  1,097,908.00              41.56% 87,004.43                    445,861.51                  6,494.90                                 10,408.73                   Capital Outlay 36,876.95                    213,425.57                  80,700.00                    264.47% ‐                                ‐                                36,876.95                              213,425.57                COVID‐19 ‐                                60,379.92                    100.00% ‐                                           60,379.92                   Total 580,211.89                  4,065,907.82              7,352,350.00              55.30% 499,566.54                  3,526,922.18              80,645.35                              538,985.64                Building Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 19,500.80                    19,131.60                    254,406.00                  7.52% 18,958.89                    122,108.83                  541.91                                    (102,977.23)               Benefits 3,515.25                      3,433.31                      51,631.00                    6.65% 3,300.33                      24,518.54                    214.92                                    (21,085.23)                 Operations 2,584.76                      1,002.56                      67,450.00                    1.49% 1,329.52                      24,167.67                    1,255.24                                 (23,165.11)                 Capital Outlay ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                100.00% ‐                                           ‐                               Total 25,600.81                    23,567.47                    373,487.00                  6.31% 23,588.74                    170,795.04                  2,012.07                                 (147,227.57)               Parks & Recreation Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 81,080.84                    79,581.19                    1,058,409.00              7.52% 81,331.20                    490,208.69                  (250.36)                                   (410,627.50)               Benefits 13,221.38                    12,609.31                    192,383.00                  6.55% 12,424.09                    88,418.81                    797.29                                    (75,809.50)                 Operations 91,120.79                    91,585.04                    1,316,238.00              6.96% 83,969.40                    533,456.36                  7,151.39                                 (441,871.32)               Capital Outlay/ Capital Projects ‐                                ‐                                295,400.00                  0.00% 13,532.11                    50,012.11                    (13,532.11)                             (50,012.11)                 COVID‐19 79.95                            ‐                                100.00% 79.95                                       ‐                               Total 185,502.96                  183,775.54                  2,862,430.00              6.42% 191,256.80                  1,162,095.97              (5,753.84)                               (978,320.43)               Performing Arts Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 9,797.15                      8,896.75                      111,783.00                  7.96% 9,863.95                      58,775.04                    (66.80)                                     (49,878.29)                 Benefits 1,530.62                      1,383.82                      18,332.00                    7.55% 1,411.85                      8,615.84                      118.77                                    (7,232.02)                    Operations 6,408.32                      6,445.93                      255,640.00                  2.52% 19,735.68                    85,055.16                    (13,327.36)                             (78,609.23)                 Capital Outlay ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                23.96                            100.00% ‐                                           23.96                           Total 17,736.09                    16,750.46                    385,755.00                  4.34% 31,011.48                    152,446.04                  (13,275.39)                             (135,695.58)               Non‐Departmental Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference City ‐ County Svcs 7,083.33                      227,500.02                  430,000.00                  52.91% 7,083.33                      219,583.35                  ‐                                           7,916.67                     Community Initiatives 9,808.84                      130,729.80                  928,801.00                  14.08% 61,501.79                    465,230.60                  (51,692.95)                             (334,500.80)               Unprocessed JP Morgan Payment ‐                                ‐                                100.00% ‐                                ‐                                ‐                                           ‐                               Drug Proceeds Expenditures 12,604.00                    19,596.00                    ‐                                100.00% ‐                                ‐                                12,604.00                               19,596.00                   Transfer to DSF ‐ One Cent 8,599,459.10              8,785,000.00              97.89% 125,000.00                  3,299,833.47              (125,000.00)                           5,299,625.63             Transfer to DSF ‐ Other (82,515.72)                   348,654.14                  558,667.00                  62.41% 92,941.47                    451,328.86                  (175,457.19)                           (102,674.72)               Transfer to Group Health 252,500.00                  1,515,000.00              3,030,000.00              50.00% 259,583.33                  1,507,499.98              (7,083.33)                               7,500.02                     Transfer to Capital Project Fund ‐                                ‐                                0.00% 39,092.78                    49,865.02                    (39,092.78)                             (49,865.02)                 Transfer to Sanitation Fund ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               Transfer to Gas Tax Fund ‐                                ‐                                42,723.00                    0.00% ‐                                ‐                                ‐                                           ‐                               Transfer to Judicial ‐                                ‐                                222,614.00                  0.00% ‐                                ‐                                ‐                                           ‐                               Total 199,480.45                  10,840,939.06            13,997,805.00            77.45% 585,202.70                  5,993,341.28              (385,722.25)                           4,847,597.78             Debt Service Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Debt Service 64,721.94                    890,325.95                  1,745,500.00              51.01% 169,918.05                  851,764.82                  (105,196.11)                           38,561.13                   Total 64,721.94                    890,325.95                  1,745,500.00              51.01% 169,918.05                  851,764.82                  (105,196.11)                           38,561.13                   Total Mar‐21 YTD Budget % of Budget Mar‐20 YTD March Difference YTD Difference Salary 1,209,371.60              7,594,224.98              16,818,900.00            45.15% 1,150,413.70              7,758,600.65              58,957.90                               (164,375.67)               Benefits 461,589.47                  3,193,855.92              6,699,536.00              47.67% 448,256.82                  3,060,371.42              13,332.65                               133,484.50                 Operations 668,259.29                  3,877,282.19              10,557,055.00            36.73% 627,095.31                  4,440,162.36              41,163.98                               (562,880.17)               Capital Outlay 57,732.08                    234,280.70                  1,460,381.00              16.04% 43,598.23                    292,463.28                  14,133.85                               (58,182.58)                 Debt Service (17,793.78)                   9,838,439.19              11,089,167.00            88.72% 387,859.52                  4,602,927.15              (405,653.30)                           5,235,512.04             COVID‐19 15,637.38                    292,331.12                  ‐                                100.00% Total 2,394,796.04              25,030,414.10            46,625,039.00            53.68% 2,657,223.58              20,154,524.86            (278,064.92)                           4,583,558.12             % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 53.06% Prepared by      Daniel Oakley