Loading...
January 2020 - Council Expense InformationAs of  3/2/2020 33.33 % Year Complete Executive Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 30,612.85                    95,995.89                    267,156.00                  35.93% 19,600.75                    73,850.39                    11,012.10                              22,145.50                   Benefits 4,071.60                      12,308.39                    35,188.00                    34.98% 2,595.06                      9,400.37                      1,476.54                                2,908.02                     Operations 4,587.96                      30,637.84                    162,775.00                  18.82% 3,479.46                      36,522.60                    1,108.50                                (5,884.76)                   Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 39,272.41                    138,942.12                  465,119.00                  29.87% 25,675.27                    119,773.36                  13,597.14                              19,168.76                   Legislative Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 10,417.04                    41,668.16                    125,000.00                  33.33% 10,417.04                    41,668.16                    ‐                                          ‐                               Benefits 928.30                          3,198.10                      10,299.00                    31.05% 906.99                          3,118.69                      21.31                                      79.41                          Operations (35.00)                          1,473.38                      13,300.00                    11.08% 848.00                          1,537.77                      (883.00)                                  (64.39)                         Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 11,310.34                    46,339.64                    148,599.00                  31.18% 12,172.03                    46,324.62                    (861.69)                                  15.02                          Finance Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 38,482.38                    111,873.40                  360,253.00                  31.05% 22,190.05                    82,190.51                    16,292.33                              29,682.89                   Benefits 6,572.51                      18,218.94                    60,616.00                    30.06% 3,904.13                      14,373.48                    2,668.38                                3,845.46                     Operations 69,436.61                    105,259.47                  240,360.00                  43.79% 63,324.71                    85,226.73                    6,111.90                                20,032.74                   Capital Outlay ‐                                ‐                                0.00% ‐                                          ‐                               Total 114,491.50                  235,351.81                  661,229.00                  35.59% 89,418.89                    181,790.72                  25,072.61                              53,561.09                   City Clerk Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 15,258.03                    47,463.90                    139,619.00                  34.00% 10,492.98                    37,804.78                    4,765.05                                9,659.12                     Benefits 2,727.53                      8,015.68                      24,068.00                    33.30% 1,769.02                      6,417.17                      958.51                                    1,598.51                     Operations 2,490.94                      9,788.69                      108,240.00                  9.04% 2,604.36                      8,412.15                      (113.42)                                  1,376.54                     Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               Total 20,476.50                    65,268.27                    271,927.00                  24.00% 14,866.36                    52,634.10                    5,610.14                                12,634.17                   HR Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 35,992.31                    106,862.67                  308,420.00                  34.65% 21,980.38                    81,284.67                    14,011.93                              25,578.00                   Benefits 6,667.38                      19,259.34                    56,426.00                    34.13% 4,135.57                      15,252.34                    2,531.81                                4,007.00                     Operations 1,644.71                      17,843.43                    72,275.00                    24.69% 1,241.72                      21,675.50                    402.99                                    (3,832.07)                   Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               Total 44,304.40                    143,965.44                  437,121.00                  32.93% 27,357.67                    118,212.51                  16,946.73                              25,752.93                   IT Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 22,178.62                    65,690.95                    195,466.00                  33.61% 12,481.71                    48,937.25                    9,696.91                                16,753.70                   Benefits 3,546.32                      10,074.27                    30,262.00                    33.29% 2,046.35                      7,740.33                      1,499.97                                2,333.94                     Operations 81,208.44                    507,898.98                  1,371,831.00              37.02% 124,058.38                  491,499.83                  (42,849.94)                             16,399.15                   Capital Outlay 27,224.90                    33,615.40                    200,000.00                  16.81% ‐                                ‐                                27,224.90                              33,615.40                   Total 134,158.28                  617,279.60                  1,797,559.00              34.34% 138,586.44                  548,177.41                  (4,428.16)                               69,102.19                   Vehicle Maint. Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 26,157.86                    78,417.62                    228,594.00                  34.30% 18,773.30                    70,847.84                    7,384.56                                7,569.78                     Benefits 10,447.01                    19,108.81                    43,245.00                    44.19% 9,650.85                      18,838.02                    796.16                                    270.79                        Operations 3,797.13                      32,433.27                    98,650.00                    32.88% 244.86                          11,729.35                    3,552.27                                20,703.92                   Capital Outlay 8,580.00                      8,580.00                      37,000.00                    0.00% ‐                                ‐                                8,580.00                                8,580.00                     Total 48,982.00                    138,539.70                  407,489.00                  34.00% 28,669.01                    101,415.21                  20,312.99                              37,124.49                   City of Prattville January 2020 Unaudited Expenditures By Department Engineering Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 50,112.45                    159,116.78                 552,052.00                 28.82% 36,563.90                    137,526.04                 13,548.55                              21,590.74                  Benefits 20,946.43                    39,941.15                    113,511.00                 35.19% 18,486.59                    37,830.68                    2,459.84                                2,110.47                     Operations 14,446.03                    118,611.60                 566,300.00                 20.95% 25,735.35                    94,615.38                    (11,289.32)                            23,996.22                  Capital Outlay ‐                                ‐                                333,718.00                 0.00% ‐                                ‐                                ‐                                          ‐                              Total 85,504.91                    317,669.53                 1,565,581.00              20.29% 80,785.84                    269,972.10                 4,719.07                                47,697.43                  Planning Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 34,364.30                    106,377.17                 335,243.00                 31.73% 16,191.16                    53,744.40                    18,173.14                              52,632.77                  Benefits 6,537.07                      19,355.82                    60,022.00                    32.25% 3,237.44                      10,190.94                    3,299.63                                9,164.88                     Operations 39,492.25                    174,198.96                 727,450.00                 23.95% 36,193.36                    120,822.20                 3,298.89                                53,376.76                  Capital Outlay ‐                               ‐                              ‐                                0.00% ‐                                ‐                                ‐                                          ‐                              Total 80,393.62                    299,931.95                 1,122,715.00              26.71% 55,621.96                    184,757.54                 24,771.66                              115,174.41                Urban Management Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 102,515.42                 300,922.78                 927,120.00                 32.46% 47,055.10                    204,565.21                 55,460.32                              96,357.57                  Benefits 28,975.09                    60,803.54                    167,371.00                 36.33% 23,467.52                    48,612.96                    5,507.57                                12,190.58                  Operations 46,496.33                    185,720.42                 493,000.00                 37.67% 27,499.50                    153,529.96                 18,996.83                              32,190.46                  Capital Outlay ‐                                ‐                                30,000.00                    0.00% ‐                                ‐                                ‐                                          ‐                              Total 177,986.84                 547,446.74                 1,617,491.00              33.85% 98,022.12                    406,708.13                 79,964.72                              140,738.61                Facilities Maintenance Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 41,596.56                    124,468.71                 363,631.00                 34.23% 24,720.70                    93,121.89                    16,875.86                              31,346.82                  Benefits 9,636.81                      22,370.96                    59,507.00                    37.59% 6,959.19                      17,881.31                    2,677.62                                4,489.65                     Operations 5,998.69                      41,193.07                    237,050.00                 17.38% 7,477.53                      49,860.18                    (1,478.84)                               (8,667.11)                   Capital Outlay ‐                                ‐                                48,626.00                    0.00% ‐                                ‐                                ‐                                          ‐                              Total 57,232.06                    188,032.74                 708,814.00                 26.53% 39,157.42                    160,863.38                 18,074.64                              27,169.36                  Public Works Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 36,771.40                    106,520.54                 312,653.00                 34.07% 19,915.76                    74,433.39                    16,855.64                              32,087.15                  Benefits 9,553.32                      21,601.50                    58,569.00                    36.88% 6,508.44                      16,330.81                    3,044.88                                5,270.69                     Operations 45,340.10                    103,332.64                 224,718.00                 45.98% 25,990.53                    82,010.97                    19,349.57                              21,321.67                  Capital Outlay (6,210.00)                    ‐                                225,000.00                 0.00% ‐                                ‐                                (6,210.00)                               ‐                              Total 85,454.82                    231,454.68                 820,940.00                 28.19% 52,414.73                    172,775.17                 33,040.09                              58,679.51                  Police Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 596,464.87                 1,826,505.55              5,557,043.00              32.87% 364,418.54                 1,384,482.81              232,046.33                           442,022.74                Benefits 195,430.40                 398,936.25                 1,044,030.00              38.21% 149,089.49                 330,946.39                 46,340.91                              67,989.86                  Operations 48,039.91                    574,264.97                 1,425,809.00              40.28% 33,834.90                    309,796.93                 14,205.01                              264,468.04                Capital Outlay 32,016.64                    96,140.92                    133,600.00                 71.96% ‐                                ‐                                32,016.64                              96,140.92                  Total 871,951.82                 2,895,847.69              8,160,482.00              35.49% 547,342.93                 2,025,226.13              324,608.89                           870,621.56                Fire Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 631,462.58                 1,828,345.95              5,047,501.00              36.22% 348,762.62                 1,315,012.59              282,699.96                           513,333.36                Benefits 225,526.46                 432,750.66                 1,012,418.00              42.74% 171,220.35                 350,979.56                 54,306.11                              81,771.10                  Operations 98,772.87                    295,676.13                 1,044,321.00              28.31% 45,770.48                    279,537.49                 53,002.39                              16,138.64                  Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                              Total 955,761.91                 2,556,772.74              7,104,240.00              35.99% 565,753.45                 1,945,529.64              390,008.46                           611,243.10                Building Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 28,207.21                    84,345.13                    244,473.00                 34.50% 22,670.53                    84,833.04                    5,536.68                                (487.91)                       Benefits 8,103.56                      17,946.83                    49,214.00                    36.47% 6,963.59                      18,619.21                    1,139.97                                (672.38)                       Operations 664.02                         20,637.17                    55,450.00                    37.22% 740.70                         17,960.23                    (76.68)                                    2,676.94                     Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                              Total 36,974.79                    122,929.13                 349,137.00                 35.21% 30,374.82                    121,412.48                 6,599.97                                1,516.65                     Parks & Recreation Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 105,131.24                 332,748.37                 1,005,486.00              33.09% 53,288.17                    211,881.03                 51,843.07                              120,867.34                Benefits 28,644.82                    64,052.25                    169,471.00                 37.80% 21,912.32                    47,878.53                    6,732.50                                16,173.72                  Operations 49,485.31                    335,587.72                 1,174,070.00              28.58% 52,208.57                    241,660.68                 (2,723.26)                               93,927.04                  Capital Outlay/ Capital Projects 36,480.00                    36,480.00                    200,400.00                 18.20% 33,445.00                    33,445.00                    3,035.00                                3,035.00                     Total 219,741.37                 768,868.34                 2,549,427.00              30.16% 160,854.06                 534,865.24                 58,887.31                              234,003.10                Performing Arts Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 13,204.30                    39,364.94                    106,627.00                 36.92% 6,055.67                      24,030.91                    7,148.63                                15,334.03                  Benefits 2,026.40                      5,840.03                      15,770.00                    37.03% 1,054.23                      3,923.88                      972.17                                   1,916.15                     Operations 12,595.12                    51,966.52                    266,690.00                 19.49% 5,726.15                      41,260.95                    6,868.97                                10,705.57                  Capital Outlay ‐                                ‐                                ‐                                0.00% 10,514.00                    10,514.00                    (10,514.00)                            (10,514.00)                 Total 27,825.82                    97,171.49                    389,087.00                 24.97% 23,350.05                    79,729.74                    4,475.77                                17,441.75                  Non‐Departmental Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference City ‐ County Svcs 87,083.33                    205,416.69                 425,000.00                 48.33% 84,166.67                    198,333.35                 2,916.66                                7,083.34                     Community Initiatives 63,118.78                    350,850.36                 979,274.00                 35.83% 56,248.08                    285,328.77                 6,870.70                                65,521.59                  Transfer to DSF ‐ One Cent ‐                                1,925,105.53              3,394,441.00              56.71% ‐                                1,880,628.47              ‐                                          44,477.06                  Transfer to DSF ‐ Other 132,896.47                 358,387.39                 664,029.00                 53.97% 31,875.00                    116,093.42                 101,021.47                           242,293.97                Transfer to Group Health 249,583.33                 998,333.32                 2,995,000.00              33.33% 247,167.00                 988,668.00                 2,416.33                                9,665.32                     Transfer to Capital Project Fund ‐                                10,772.24                    75,000.00                    14.36% 10,659.84                    52,677.42                    (10,659.84)                            (41,905.18)                 Transfer to Gas Tax Fund ‐                                ‐                                22,000.00                    0.00% ‐                                ‐                                ‐                                          ‐                              Transfer to Judicial ‐                                121,794.00                 0.00% ‐                                ‐                                ‐                                          ‐                              Total 532,681.91                 3,848,865.53              8,676,538.00              44.36% 430,116.59                 3,521,729.43              102,565.32                           327,136.10                Debt Service Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Debt Service 214,677.66                 658,964.17                 1,728,000.00              38.13% 327,365.78                 603,317.78                 (112,688.12)                          55,646.39                  Total 214,677.66                 658,964.17                 1,728,000.00              38.13% 327,365.78                 603,317.78                 (112,688.12)                          55,646.39                  Total Jan‐20 YTD Budget % of Budget Jan‐19 YTD January Difference YTD Difference Salary 1,818,929.42              5,456,688.51              16,076,337.00            33.94% 1,055,578.36              4,020,214.91              763,351.06                           1,436,473.60             Benefits 819,924.34                 2,172,115.84              6,004,987.00              36.17% 681,074.13                 1,947,002.67              138,850.21                           225,113.17                Operations 674,663.53                 3,173,563.55              9,905,357.00              32.04% 608,053.15                 2,583,998.44              66,610.38                              589,565.11                Capital Outlay 98,091.54                    174,816.32                 1,208,344.00              14.47% 43,959.00                    43,959.00                    54,132.54                              130,857.32                Debt Service 347,574.13                 2,942,457.09              5,786,470.00              50.85% 359,240.78                 2,600,039.67              (11,666.65)                            342,417.42                Total 3,759,182.96              13,919,641.31            38,981,495.00            35.71% 2,747,905.42              11,195,214.69            1,011,277.54                        2,724,426.62             Prepared by      Daniel Oakley