Loading...
January 2021 - Council Expense InformationAs of  2/11/2021 33.33 % Year Complete Executive Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 21,559.21                    96,698.85                    454,953.00                  21.25% 30,612.85                    95,995.89                    (9,053.64)                                702.96                         Benefits 2,952.26                       13,048.10                    69,484.00                    18.78% 4,071.60                       12,308.39                    (1,119.34)                                739.71                         Operations 5,519.14                       35,784.93                    266,400.00                  13.43% 4,587.96                       30,637.84                    931.18                                    5,147.09                     Capital Outlay ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 269.83                          2,328.53                       100.00% 269.83                                    2,328.53                     Total 30,300.44                    147,860.41                  790,837.00                  18.70% 39,272.41                    138,942.12                  (8,971.97)                                8,918.29                     Legislative Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 10,417.04                    42,279.81                    125,000.00                  33.82% 10,417.04                    41,668.16                    ‐                                           611.65                         Benefits 754.18                          3,125.96                       10,306.00                    30.33% 928.30                          3,198.10                       (174.12)                                   (72.14)                          Operations ‐                                 464.77                          20,900.00                    2.22% (35.00)                           1,473.38                       35.00                                       (1,008.61)                    Capital Outlay ‐                                 ‐                                 ‐                                 ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 ‐                                ‐                                           ‐                               Total 11,171.22                    45,870.54                    156,206.00                  29.37% 11,310.34                    46,339.64                    (139.12)                                   (469.10)                       Finance Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 28,388.24                    120,636.70                  403,498.00                  29.90% 38,482.38                    111,873.40                  (10,094.14)                             8,763.30                     Benefits 4,976.76                       20,827.99                    72,462.00                    28.74% 6,572.51                       18,218.94                    (1,595.75)                                2,609.05                     Operations 138,876.92                  166,533.71                  237,750.00                  70.05% 69,436.61                    105,259.47                  69,440.31                               61,274.24                   Capital Outlay ‐                                 0.00% ‐                                           ‐                               COVID‐19 ‐                                 ‐                                 100.00% ‐                                           ‐                               Total 172,241.92                  307,998.40                  713,710.00                  43.15% 114,491.50                  235,351.81                  57,750.42                               72,646.59                   City Clerk Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 4,327.07                       51,744.91                    144,744.00                  35.75% 15,258.03                    47,463.90                    (10,930.96)                             4,281.01                     Benefits 452.04                          6,279.43                       25,190.00                    24.93% 2,727.53                       8,015.68                       (2,275.49)                                (1,736.25)                    Operations 654.49                          10,000.81                    51,670.00                    19.36% 2,490.94                       9,788.69                       (1,836.45)                                212.12                         Capital Outlay ‐                                 ‐                                 0.00% ‐                                 ‐                                 ‐                                           ‐                               COVID‐19 ‐                                 19.95                            100.00% ‐                                           19.95                           Total 5,433.60                       68,045.10                    221,604.00                  30.71% 20,476.50                    65,268.27                    (15,042.90)                             2,776.83                     HR Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 24,647.36                    119,457.48                  316,371.00                  37.76% 35,992.31                    106,862.67                  (11,344.95)                             12,594.81                   Benefits 4,491.58                       20,997.10                    459,716.00                  4.57% 6,667.38                       19,259.34                    (2,175.80)                                1,737.76                     Operations 551.24                          14,623.49                    91,025.00                    16.07% 1,644.71                       17,843.43                    (1,093.47)                                (3,219.94)                    Capital Outlay ‐                                 ‐                                 0.00% ‐                                 ‐                                           ‐                               COVID‐19 67.97                            927.82                          100.00% 67.97                                       927.82                         Total 29,758.15                    156,005.89                  867,112.00                  17.99% 44,304.40                    143,965.44                  (14,546.25)                             12,040.45                   IT Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 16,251.29                    77,170.88                    204,469.00                  37.74% 22,178.62                    65,690.95                    (5,927.33)                                11,479.93                   Benefits 2,718.83                       12,633.19                    35,188.00                    35.90% 3,546.32                       10,074.27                    (827.49)                                   2,558.92                     Operations 381,455.27                  686,872.41                  1,808,147.00               37.99% 81,208.44                    507,898.98                  300,246.83                            178,973.43                 Capital Outlay ‐                                 ‐                                 75,000.00                    0.00% 27,224.90                    33,615.40                    (27,224.90)                             (33,615.40)                  COVID‐19 7,438.11                       50,277.65                    100.00% 7,438.11                                 50,277.65                   Total 407,863.50                  826,954.13                  2,122,804.00               38.96% 134,158.28                  617,279.60                  273,705.22                            209,674.53                 Vehicle Maint. Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 17,270.28                    86,349.18                    227,010.00                  38.04% 26,157.86                    78,417.62                    (8,887.58)                                7,931.56                     Benefits 2,939.48                       12,849.52                    47,083.00                    27.29% 10,447.01                    19,108.81                    (7,507.53)                                (6,259.29)                    Operations (1,173.54)                     16,267.59                    98,150.00                    16.57% 3,797.13                       32,433.27                    (4,970.67)                                (16,165.68)                  Capital Outlay ‐                                 ‐                                 7,500.00                       0.00% 8,580.00                       8,580.00                       (8,580.00)                                (8,580.00)                    COVID‐19 ‐                                 ‐                                 100.00% ‐                                           ‐                               Total 19,036.22                    115,466.29                  379,743.00                  30.41% 48,982.00                    138,539.70                  (29,945.78)                             (23,073.41)                  City of Prattville January 2021 Unaudited Expenditures By Department Engineering Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 37,087.79                    188,300.32                  541,734.00                  34.76% 50,112.45                    159,116.78                  (13,024.66)                             29,183.54                   Benefits 6,731.76                      33,482.98                    113,070.00                  29.61% 20,946.43                    39,941.15                    (14,214.67)                             (6,458.17)                    Operations 11,477.85                    91,901.54                    793,700.00                  11.58% 14,446.03                    118,611.60                  (2,968.18)                               (26,710.06)                 Capital Outlay ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                100.00% ‐                                           ‐                               Total 55,297.40                    313,684.84                  1,448,504.00              21.66% 85,504.91                    317,669.53                  (30,207.51)                             (3,984.69)                    Planning Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 31,071.28                    141,814.60                  404,595.00                  35.05% 34,364.30                    106,377.17                  (3,293.02)                               35,437.43                   Benefits 5,666.45                      25,687.09                    76,496.00                    33.58% 6,537.07                      19,355.82                    (870.62)                                   6,331.27                     Operations 34,766.12                    148,636.61                  540,450.00                  27.50% 39,492.25                    174,198.96                  (4,726.13)                               (25,562.35)                 Capital Outlay ‐                                ‐                                0.00% ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                100.00% ‐                                ‐                                           ‐                               Total 71,503.85                    316,138.30                  1,021,541.00              30.95% 80,393.62                    299,931.95                  (8,889.77)                               16,206.35                   Urban Management Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 78,144.98                    357,651.64                  990,654.00                  36.10% 102,515.42                  300,922.78                  (24,370.44)                             56,728.86                   Benefits 13,133.55                    60,212.31                    193,188.00                  31.17% 28,975.09                    60,803.54                    (15,841.54)                             (591.23)                       Operations 27,360.05                    165,085.68                  528,000.00                  31.27% 46,496.33                    185,720.42                  (19,136.28)                             (20,634.74)                 Capital Outlay ‐                                ‐                                81,000.00                    0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                100.00% ‐                                           ‐                               Total 118,638.58                  582,949.63                  1,792,842.00              32.52% 177,986.84                  547,446.74                  (59,348.26)                             35,502.89                   Facilities Maintenance Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 27,559.15                    130,001.63                  380,874.00                  34.13% 41,596.56                    124,468.71                  (14,037.41)                             5,532.92                     Benefits 4,588.10                      21,107.56                    67,073.00                    31.47% 9,636.81                      22,370.96                    (5,048.71)                               (1,263.40)                    Operations 2,882.75                      42,245.59                    222,550.00                  18.98% 5,998.69                      41,193.07                    (3,115.94)                               1,052.52                     Capital Outlay ‐                                ‐                                375,000.00                  0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 37,790.34                    37,790.34                    100.00% 37,790.34                              37,790.34                   Total 72,820.34                    231,145.12                  1,045,497.00              22.11% 57,232.06                    188,032.74                  15,588.28                              43,112.38                   Public Works Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 26,139.84                    118,915.91                  332,353.00                  35.78% 36,771.40                    106,520.54                  (10,631.56)                             12,395.37                   Benefits 4,688.89                      21,055.95                    64,481.00                    32.65% 9,553.32                      21,601.50                    (4,864.43)                               (545.55)                       Operations 8,879.48                      81,353.47                    212,718.00                  38.24% 45,340.10                    103,332.64                  (36,460.62)                             (21,979.17)                 Capital Outlay ‐                                ‐                                520,000.00                  0.00% (6,210.00)                     ‐                                6,210.00                                 ‐                               COVID‐19 63.89                            63.89                            100.00% 63.89                                      63.89                           Total 39,772.10                    221,389.22                  1,129,552.00              19.60% 85,454.82                    231,454.68                  (45,682.72)                             (10,065.46)                 Police Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 396,138.06                  1,834,398.70              5,753,608.00              31.88% 596,464.87                  1,826,505.55              (200,326.81)                           7,893.15                     Benefits 68,448.98                    312,824.60                  1,114,150.00              28.08% 195,430.40                  398,936.25                  (126,981.42)                           (86,111.65)                 Operations 305,016.70                  540,785.99                  1,324,221.00              40.84% 48,039.91                    574,264.97                  256,976.79                            (33,478.98)                 Capital Outlay ‐                                ‐                                6,229.00                      0.00% 32,016.64                    96,140.92                    (32,016.64)                             (96,140.92)                 COVID‐19 7,167.65                      11,959.03                    100.00% 7,167.65                                 11,959.03                   Total 776,771.39                  2,699,968.32              8,198,208.00              32.93% 871,951.82                  2,895,847.69              (95,180.43)                             (195,879.37)               Fire Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 454,507.20                  1,944,281.12              5,114,439.00              38.02% 631,462.58                  1,828,345.95              (176,955.38)                           115,935.17                Benefits 78,879.88                    344,624.54                  1,059,303.00              32.53% 225,526.46                  432,750.66                  (146,646.58)                           (88,126.12)                 Operations 39,241.73                    256,702.01                  1,097,908.00              23.38% 98,772.87                    295,676.13                  (59,531.14)                             (38,974.12)                 Capital Outlay ‐                                176,548.62                  80,700.00                    218.77% ‐                                ‐                                ‐                                           176,548.62                COVID‐19 4,670.66                      61,804.06                    100.00% 4,670.66                                 61,804.06                   Total 577,299.47                  2,783,960.35              7,352,350.00              37.86% 955,761.91                  2,556,772.74              (378,462.44)                           227,187.61                Building Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 19,465.60                    19,131.60                    254,406.00                  7.52% 28,207.21                    84,345.13                    (8,741.61)                               (65,213.53)                 Benefits 3,494.94                      3,433.31                      51,631.00                    6.65% 8,103.56                      17,946.83                    (4,608.62)                               (14,513.52)                 Operations 2,024.22                      1,002.56                      67,450.00                    1.49% 664.02                          20,637.17                    1,360.20                                 (19,634.61)                 Capital Outlay ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                ‐                                100.00% ‐                                           ‐                               Total 24,984.76                    23,567.47                    373,487.00                  6.31% 36,974.79                    122,929.13                  (11,990.03)                             (99,361.66)                 Parks & Recreation Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 66,333.26                    79,581.19                    1,058,409.00              7.52% 105,131.24                  332,748.37                  (38,797.98)                             (253,167.18)               Benefits 11,432.88                    12,609.31                    192,383.00                  6.55% 28,644.82                    64,052.25                    (17,211.94)                             (51,442.94)                 Operations 37,048.26                    91,585.04                    1,316,238.00              6.96% 49,485.31                    335,587.72                  (12,437.05)                             (244,002.68)               Capital Outlay/ Capital Projects ‐                                ‐                                295,400.00                  0.00% 36,480.00                    36,480.00                    (36,480.00)                             (36,480.00)                 COVID‐19 ‐                                ‐                                100.00% ‐                                           ‐                               Total 114,814.40                  183,775.54                  2,862,430.00              6.42% 219,741.37                  768,868.34                  (104,926.97)                           (585,092.80)               Performing Arts Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 8,775.71                      8,896.75                      111,783.00                  7.96% 13,204.30                    39,364.94                    (4,428.59)                               (30,468.19)                 Benefits 1,374.52                      1,383.82                      18,332.00                    7.55% 2,026.40                      5,840.03                      (651.88)                                   (4,456.21)                    Operations 1,555.85                      6,445.93                      255,640.00                  2.52% 12,595.12                    51,966.52                    (11,039.27)                             (45,520.59)                 Capital Outlay ‐                                ‐                                0.00% ‐                                ‐                                ‐                                           ‐                               COVID‐19 ‐                                23.96                            100.00% ‐                                           23.96                           Total 11,706.08                    16,750.46                    385,755.00                  4.34% 27,825.82                    97,171.49                    (16,119.74)                             (80,421.03)                 Non‐Departmental Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference City ‐ County Svcs 112,083.34                  213,333.36                  430,000.00                  49.61% 87,083.33                    205,416.69                  25,000.01                               7,916.67                     Community Initiatives 38,620.61                    97,516.28                    928,801.00                  10.50% 63,118.78                    350,850.36                  (24,498.17)                             (253,334.08)               Unprocessed JP Morgan Payment ‐                                ‐                                100.00% ‐                                ‐                                ‐                                           ‐                               Drug Proceeds Expenditures ‐                                763.00                          ‐                                100.00% ‐                                ‐                                ‐                                           763.00                        Transfer to DSF ‐ One Cent 5,390,000.00              7,013,029.10              8,785,000.00              79.83% ‐                                1,925,105.53              5,390,000.00                         5,087,923.57             Transfer to DSF ‐ Other 132,401.47                  348,654.14                  558,667.00                  62.41% 132,896.47                  358,387.39                  (495.00)                                   (9,733.25)                    Transfer to Group Health 252,500.00                  1,010,000.00              3,030,000.00              33.33% 249,583.33                  998,333.32                  2,916.67                                 11,666.68                   Transfer to Capital Project Fund ‐                                ‐                                0.00% ‐                                10,772.24                    ‐                                           (10,772.24)                 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 5,925,605.42              8,683,295.88              13,997,805.00            62.03% 532,681.91                  3,848,865.53              5,392,923.51                         4,834,430.35             Debt Service Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Debt Service 248,715.14                  508,285.12                  1,745,500.00              29.12% 214,677.66                  658,964.17                  34,037.48                               (150,679.05)               Total 248,715.14                  508,285.12                  1,745,500.00              29.12% 214,677.66                  658,964.17                  34,037.48                               (150,679.05)               Total Jan‐21 YTD Budget % of Budget Jan‐20 YTD January Difference YTD Difference Salary 1,268,083.36              5,417,311.27              16,818,900.00            32.21% 1,818,929.42              5,456,688.51              (550,846.06)                           (39,377.24)                 Benefits 470,225.08                  1,936,182.76              6,699,536.00              28.90% 819,924.34                  2,172,115.84              (349,699.26)                           (235,933.08)               Operations 1,146,840.48              2,667,904.77              10,557,055.00            25.27% 674,663.53                  3,173,563.55              472,176.95                            (505,658.78)               Capital Outlay ‐                                176,548.62                  1,440,829.00              12.25% 98,091.54                    174,816.32                  (98,091.54)                             1,732.30                     Debt Service 5,771,116.61              7,869,968.36              11,089,167.00            70.97% 347,574.13                  2,942,457.09              5,423,542.48                         4,927,511.27             COVID‐19 57,468.45                    165,195.23                  ‐                                100.00% Total 8,713,733.98              18,233,111.01            46,605,487.00            39.12% 3,759,182.96              13,919,641.31            4,897,082.57                         4,148,274.47             % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 38.77% Prepared by      Daniel Oakley