Loading...
March 2022 - Council Expenditure ReportAs of  4/15/2022 50.00 % Year Complete Executive Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 41,183.31                    208,266.81                  422,665.00                  49.27% 21,361.93                    141,001.46                  19,821.38                               67,265.35                   Benefits 5,999.66                       32,587.93                    65,858.00                    49.48% 2,928.09                       19,450.46                    3,071.57                                 13,137.47                   Operations 11,928.41                    82,622.13                    294,213.00                  28.08% 10,006.82                    67,810.04                    1,921.59                                 14,812.09                   Capital Outlay 3,814.53                       23,814.53                    ‐                                 100.00% ‐                                 ‐                                 3,814.53                                 23,814.53                   COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 2,740.93                       ‐                                           (2,740.93)                    Total 62,925.91                    347,291.40                  782,736.00                  44.37% 34,296.84                    231,002.89                  28,629.07                               116,288.51                 Legislative Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 10,417.04                    62,502.24                    125,000.00                  50.00% 10,417.04                    63,113.89                    ‐                                           (611.65)                       Benefits 735.46                          4,680.65                       10,323.00                    45.34% 774.56                          4,899.25                       (39.10)                                     (218.60)                       Operations 750.00                          1,722.91                       30,400.00                    5.67% 1,207.98                       1,712.75                       (457.98)                                   10.16                           Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 11,902.50                    68,905.80                    165,723.00                  41.58% 12,399.58                    69,725.89                    (497.08)                                   (820.09)                       Finance Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 33,373.93                    202,723.49                  439,849.00                  46.09% 26,113.89                    174,116.55                  7,260.04                                 28,606.94                   Benefits 5,971.32                       40,099.41                    82,082.00                    48.85% 4,597.59                       30,618.79                    1,373.73                                 9,480.62                     Operations 47,778.53                    166,980.68                  252,820.00                  66.05% 12,613.82                    191,858.43                  35,164.71                               (24,877.75)                  Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 87,123.78                    409,803.58                  774,751.00                  52.89% 43,325.30                    396,593.77                  43,798.48                               13,209.81                   City Clerk Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 10,667.55                    64,046.86                    124,042.00                  51.63% 13,750.98                    79,556.00                    (3,083.43)                                (15,509.14)                  Benefits 1,892.45                       11,792.53                    24,411.00                    48.31% 1,979.59                       9,866.52                       (87.14)                                     1,926.01                     Operations 10,457.49                    52,358.20                    80,170.00                    65.31% 5,072.08                       19,160.47                    5,385.41                                 33,197.73                   Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 19.95                            ‐                                           (19.95)                          Total 23,017.49                    128,197.59                  228,623.00                  56.07% 20,802.65                    108,602.94                  2,214.84                                 19,594.65                   HR Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 25,355.64                    152,459.39                  335,980.00                  45.38% 24,332.31                    168,502.13                  1,023.33                                 (16,042.74)                  Benefits 4,742.42                       29,878.00                    292,173.00                  10.23% 4,445.32                       30,332.78                    297.10                                    (454.78)                       Operations 9,235.11                       37,037.48                    95,600.00                    38.74% 1,871.78                       21,048.75                    7,363.33                                 15,988.73                   Capital Outlay ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 100.00% ‐                                 927.82                          ‐                                           (927.82)                       Total 39,333.17                    219,374.87                  723,753.00                  30.31% 30,649.41                    220,811.48                  8,683.76                                 (1,436.61)                    IT Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 17,952.79                    111,669.51                  218,147.00                  51.19% 17,217.73                    111,745.16                  735.06                                    (75.65)                          Benefits 3,085.05                       20,046.51                    38,636.00                    51.89% 2,891.60                       18,716.21                    193.45                                    1,330.30                     Operations 149,479.84                  1,073,640.81               1,721,197.00               62.38% 193,582.60                  1,072,409.10               (44,102.76)                             1,231.71                     Capital Outlay ‐                                 61,973.00                    215,000.00                  0.29                               20,855.13                    20,855.13                    (20,855.13)                             41,117.87                   COVID‐19 ‐                                 ‐                                 ‐                                 15,422.94                    106,861.30                  (15,422.94)                             (106,861.30)               Total 170,517.68                  1,267,329.83               2,192,980.00               57.79% 249,970.00                  1,330,586.90               (79,452.32)                             (63,257.07)                  Vehicle Maint. Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 17,129.16                    108,500.45                  234,957.00                  46.18% 16,641.16                    120,373.00                  488.00                                    (11,872.55)                  Benefits 2,993.12                       29,397.64                    48,849.00                    60.18% 2,819.95                       28,773.18                    173.17                                    624.46                         Operations 5,136.63                       21,971.88                    101,650.00                  21.62% 5,755.33                       31,236.97                    (618.70)                                   (9,265.09)                    Capital Outlay ‐                                 ‐                                 40,000.00                    ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 25,258.91                    159,869.97                  425,456.00                  37.58% 25,216.44                    180,383.15                  42.47                                       (20,513.18)                  City of Prattville March 2022 Unaudited Expenditures By Department Engineering Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 45,040.41                    269,971.80                  619,777.00                  43.56% 38,697.35                    266,038.94                  6,343.06                                 3,932.86                     Benefits 9,425.95                      79,395.16                    138,019.00                  57.52% 6,880.12                      65,762.12                    2,545.83                                 13,633.04                   Operations 61,408.27                    349,773.86                  1,214,902.00              28.79% 37,973.73                    150,716.11                  23,434.54                               199,057.75                 Capital Projects ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               Capital Outlay ‐                                ‐                                100,000.00                  ‐                                ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Total 115,874.63                  699,140.82                  2,072,698.00              33.73% 83,551.20                    482,517.17                  32,323.43                               216,623.65                 Planning Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 33,099.68                    201,798.49                  426,880.00                  47.27% 31,283.35                    204,304.26                  1,816.33                                 (2,505.77)                    Benefits 6,185.73                      39,816.34                    81,800.00                    48.68% 5,714.74                      37,656.19                    470.99                                    2,160.15                     Operations 7,779.13                      39,787.86                    323,450.00                  12.30% 35,527.86                    229,403.99                  (27,748.73)                             (189,616.13)               Capital Projects ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Total 47,064.54                    281,402.69                  832,130.00                  33.82% 72,525.95                    471,364.44                  (25,461.41)                             (189,961.75)               Urban Management Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 81,049.17                    510,399.23                  1,117,145.00              45.69% 73,385.45                    506,642.75                  7,663.72                                 3,756.48                     Benefits 16,433.45                    125,253.43                  223,770.00                  55.97% 12,593.12                    110,264.75                  3,840.33                                 14,988.68                   Operations 56,312.76                    248,406.18                  560,500.00                  44.32% 34,934.29                    264,254.25                  21,378.47                               (15,848.07)                 Capital Outlay 59,952.00                    70,330.25                    129,000.00                  0.55                              ‐                                ‐                                59,952.00                               70,330.25                   COVID‐19 ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                           ‐                               Total 213,747.38                  954,389.09                  2,030,415.00              47.00% 120,912.86                  881,161.75                  92,834.52                               73,227.34                   Facilities Maintenance Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 29,832.88                    183,621.20                  397,866.00                  46.15% 28,079.92                    186,147.39                  1,752.96                                 (2,526.19)                    Benefits 5,038.22                      46,768.69                    81,396.00                    57.46% 4,633.80                      35,353.17                    404.42                                    11,415.52                   Operations 7,440.14                      81,641.79                    229,000.00                  35.65% 6,000.64                      78,500.85                    1,439.50                                 3,140.94                     Capital Outlay ‐                                ‐                                455,000.00                  ‐                                ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                ‐                                134.49                          66,244.23                    (134.49)                                   (66,244.23)                 Total 42,311.24                    312,031.68                  1,163,262.00              26.82% 38,848.85                    366,245.64                  3,462.39                                 (54,213.96)                 Public Works Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 27,287.24                    166,532.18                  355,055.00                  46.90% 25,822.31                    170,748.55                  1,464.93                                 (4,216.37)                    Benefits 5,016.04                      38,603.23                    71,937.00                    53.66% 4,642.20                      35,195.95                    373.84                                    3,407.28                     Operations 14,766.60                    149,153.10                  327,718.00                  45.51% 18,560.35                    124,088.79                  (3,793.75)                               25,064.31                   Capital Outlay ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                ‐                                ‐                                695.55                          ‐                                           (695.55)                       Total 47,069.88                    354,288.51                  754,710.00                  46.94% 49,024.86                    330,728.84                  (1,954.98)                               23,559.67                   Police Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 463,666.73                  2,878,156.37              6,205,541.00              46.38% 390,757.50                  2,607,763.59              72,909.23                               270,392.78                 Benefits 82,569.76                    723,414.49                  1,280,084.00              56.51% 67,217.82                    585,269.79                  15,351.94                               138,144.70                 Operations 105,976.63                  876,645.69                  2,089,530.62              41.95% 82,042.64                    691,952.10                  23,933.99                               184,693.59                 Capital Outlay 66,527.92                    66,527.92                    548,682.00                  0.12                              ‐                                ‐                                66,527.92                               66,527.92                   COVID‐19 ‐                                ‐                                ‐                                ‐                                54,437.46                    ‐                                           (54,437.46)                 Total 718,741.04                  4,544,744.47              10,123,837.62            44.89% 540,017.96                  3,939,422.94              178,723.08                            605,321.53                 Fire Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 416,381.74                  2,697,698.92              5,687,258.00              47.43% 381,131.89                  2,686,561.77              35,249.85                               11,137.15                   Benefits 79,784.09                    716,002.17                  1,211,167.00              59.12% 68,703.72                    649,270.32                  11,080.37                               66,731.85                   Operations 85,785.82                    426,801.96                  1,500,762.21              28.44% 93,499.33                    456,270.24                  (7,713.51)                               (29,468.28)                 Capital Outlay 131,011.85                  198,915.37                  987,764.93                  0.20                              36,876.95                    213,425.57                  94,134.90                               (14,510.20)                 COVID‐19 ‐                                ‐                                ‐                                ‐                                60,379.92                    ‐                                           (60,379.92)                 Total 712,963.50                  4,039,418.42              9,386,952.14              43.03% 580,211.89                  4,065,907.82              132,751.61                            (26,489.40)                 Building Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 20,552.00                    127,934.58                  267,629.00                  47.80% 19,500.80                    126,567.85                  1,051.20                                 1,366.73                     Benefits 3,787.30                       31,386.87                    56,692.00                    55.36% 3,515.25                       27,483.67                    272.05                                    3,903.20                     Operations 1,829.23                       16,141.11                    67,450.00                    23.93% 2,584.76                       18,131.18                    (755.53)                                   (1,990.07)                    Capital Outlay ‐                                 ‐                                 26,000.00                    ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 26,168.53                    175,462.56                  417,771.00                  42.00% 25,600.81                    172,182.70                  567.72                                    3,279.86                     Parks & Recreation Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 91,974.86                    522,197.40                  1,132,797.00               46.10% 81,080.84                    501,681.06                  10,894.02                               20,516.34                   Benefits 16,661.47                    121,581.84                  216,697.00                  56.11% 13,221.38                    102,563.70                  3,440.09                                 19,018.14                   Operations 152,080.31                  503,427.84                  1,245,438.00               40.42% 91,120.79                    519,053.59                  60,959.52                               (15,625.75)                  Capital Outlay/ Capital Projects ‐                                 ‐                                 1,463,000.00               ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 79.95                            209.95                          (79.95)                                     (209.95)                       Total 260,716.64                  1,147,207.08               4,057,932.00               28.27% 185,502.96                  1,123,508.30               75,213.68                               23,698.78                   Performing Arts Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 12,376.85                    71,943.12                    137,849.00                  52.19% 9,797.15                       60,339.32                    2,579.70                                 11,603.80                   Benefits 2,164.29                       13,061.20                    24,304.00                    53.74% 1,530.62                       9,653.89                       633.67                                    3,407.31                     Operations 22,995.30                    110,727.58                  254,820.00                  43.45% 6,408.32                       37,597.15                    16,586.98                               73,130.43                   Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 23.96                            ‐                                           (23.96)                          Total 37,536.44                    195,731.90                  416,973.00                  46.94% 17,736.09                    107,614.32                  19,800.35                               88,117.58                   Non‐Departmental Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference City ‐ County Svcs 19,083.34                    222,000.01                  432,000.00                  51.39% 7,083.33                       227,500.02                  12,000.01                               (5,500.01)                    Community Initiatives 31,753.89                    782,850.24                  1,240,839.00               63.09% 9,808.84                       130,729.80                  21,945.05                               652,120.44                 Unprocessed JP Morgan Payment ‐                                 ‐                                 ‐                                 100.00% ‐                                 ‐                                 ‐                                           ‐                               Drug Proceeds Expenditures 36,232.00                    36,232.00                    ‐                                 100.00% 12,604.00                    19,596.00                    23,628.00                               16,636.00                   Transfer to DSF ‐ One Cent ‐ Infras ‐                                 307,680.32                  573,819.00                  53.62% ‐                                 ‐                                 ‐                                           307,680.32                 Transfer to DSF ‐ Other ‐                                 123,311.20                  123,311.00                  100.00% (82,515.72)                   348,654.14                  82,515.72                               (225,342.94)               Transfer to DSF ‐ One Cent (old) ‐                                ‐                                 8,599,459.10               ‐                                           Transfer to Group Health 274,750.00                  1,648,500.00               3,297,000.00               50.00% 252,500.00                  1,515,000.00               22,250.00                               133,500.00                 Transfer to Capital Project Fund 811,280.00                  2,213,922.00               3,484,260.00               0.64                               ‐                                 ‐                                 811,280.00                            2,213,922.00             Transfer to Wasewater Fund ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           Transfer to Sanitation Fund ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Transfer to Gas Tax Fund ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Transfer to Judicial ‐                                 ‐                                 261,287.00                  ‐                                 ‐                                 ‐                                 ‐                                           ‐                               Total 1,173,099.23               5,510,511.97               9,412,516.00               58.54% 199,480.45                  10,840,939.06            973,618.78                            3,093,015.81             Debt Service Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Debt Service 239,221.30                  936,436.25                  2,134,891.00               43.86% 64,721.94                    890,325.95                  174,499.36                            46,110.30                   Total 239,221.30                  936,436.25                  2,134,891.00               43.86% 64,721.94                    890,325.95                  174,499.36                            46,110.30                   Total Mar‐22 YTD Budget % of Budget Mar‐21 YTD March Difference YTD Difference Salary 1,377,340.98               8,540,422.04               18,248,437.00            46.80% 1,209,371.60               8,175,203.67               167,969.38                            365,218.37                 Benefits 527,235.78                  3,752,266.09               7,245,198.00               51.79% 461,589.47                  3,316,130.74               65,646.31                               436,135.35                 Operations 1,649,489.43               7,493,845.31               15,808,006.83            47.41% 668,259.29                  4,353,030.58               981,230.14                            3,140,814.73             Capital Outlay 261,306.30                  421,561.07                  3,964,446.93               10.63% 57,732.08                    234,280.70                  203,574.22                            187,280.37                 Debt Service 239,221.30                  1,367,427.77               2,832,021.00               48.28% (17,793.78)                   9,838,439.19               257,015.08                            (8,471,011.42)            COVID‐19 ‐                                 ‐                                 ‐                                 ‐                                 15,637.38                    292,541.07                  Total 4,054,593.79               21,575,522.28            48,098,109.76            44.86% 2,394,796.04               26,209,625.95            1,675,435.13                         (4,341,562.60)            % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 44.86% Prepared by      Daniel Oakley