No preview available
 /
     
February 2020 - General Fund ExpensesAs of  4/6/2020 41.67 % Year Complete Executive Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 20,222.52                    116,218.41                  267,156.00                  43.50% 21,296.89                    95,147.28                    (1,074.37)                               21,071.13                   Benefits 2,567.62                      14,876.01                    35,188.00                    42.28% 2,721.77                      12,122.14                    (154.15)                                  2,753.87                     Operations 15,073.94                    45,711.78                    162,775.00                  28.08% 22,495.79                    59,018.39                    (7,421.85)                               (13,306.61)                 Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 37,864.08                    176,806.20                  465,119.00                  38.01% 46,514.45                    166,287.81                  (8,650.37)                               10,518.39                   Legislative Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 10,417.04                    52,085.20                    125,000.00                  41.67% 10,417.04                    52,085.20                    ‐                                          ‐                               Benefits 804.18                          4,002.28                      10,299.00                    38.86% 840.76                          3,959.45                      (36.58)                                     42.83                          Operations 114.50                          1,587.88                      13,300.00                    11.94% 1,068.80                      2,606.57                      (954.30)                                  (1,018.69)                   Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 11,335.72                    57,675.36                    148,599.00                  38.81% 12,326.60                    58,651.22                    (990.88)                                  (975.86)                       Finance Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 26,365.32                    138,238.72                  360,253.00                  38.37% 24,136.57                    106,327.08                  2,228.75                                31,911.64                   Benefits 4,320.19                      22,539.13                    60,616.00                    37.18% 3,859.48                      18,232.96                    460.71                                    4,306.17                     Operations 10,346.99                    115,606.46                  240,360.00                  48.10% 13,998.56                    99,225.29                    (3,651.57)                               16,381.17                   Capital Outlay ‐                                ‐                                0.00% ‐                                          ‐                               Total 41,032.50                    276,384.31                  661,229.00                  41.80% 41,994.61                    223,785.33                  (962.11)                                  52,598.98                   City Clerk Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 9,242.77                      56,706.67                    139,619.00                  40.62% 10,396.34                    48,201.12                    (1,153.57)                               8,505.55                     Benefits 1,469.42                      9,485.10                      24,068.00                    39.41% 1,662.97                      8,080.14                      (193.55)                                  1,404.96                     Operations 3,353.71                      13,142.40                    108,240.00                  12.14% 5,114.00                      13,526.15                    (1,760.29)                               (383.75)                       Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               Total 14,065.90                    79,334.17                    271,927.00                  29.17% 17,173.31                    69,807.41                    (3,107.41)                               9,526.76                     HR Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 23,986.48                    130,849.15                  308,420.00                  42.43% 21,655.89                    102,940.56                  2,330.59                                27,908.59                   Benefits 4,238.39                      23,497.73                    56,426.00                    41.64% 3,862.13                      19,114.47                    376.26                                    4,383.26                     Operations 4,866.74                      22,710.17                    72,275.00                    31.42% 2,248.02                      23,923.52                    2,618.72                                (1,213.35)                   Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                               Total 33,091.61                    177,057.05                  437,121.00                  40.51% 27,766.04                    145,978.55                  5,325.57                                31,078.50                   IT Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 15,057.32                    80,748.27                    195,466.00                  41.31% 12,738.62                    61,675.87                    2,318.70                                19,072.40                   Benefits 2,265.57                      12,339.84                    30,262.00                    40.78% 1,923.75                      9,664.08                      341.82                                    2,675.76                     Operations 179,221.79                  687,120.77                  1,371,831.00              50.09% 98,257.53                    589,757.36                  80,964.26                              97,363.41                   Capital Outlay 60,422.73                    94,038.13                    200,000.00                  47.02% ‐                                ‐                                60,422.73                              94,038.13                   Total 256,967.41                  874,247.01                  1,797,559.00              48.64% 112,919.90                  661,097.31                  144,047.51                            213,149.70                Vehicle Maint. Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 17,337.17                    95,754.79                    228,594.00                  41.89% 18,841.08                    89,688.92                    (1,503.91)                               6,065.87                     Benefits 2,858.02                      21,966.83                    43,245.00                    50.80% 3,173.26                      22,011.28                    (315.24)                                  (44.45)                         Operations 4,103.27                      36,536.54                    98,650.00                    37.04% 9,417.82                      21,147.17                    (5,314.55)                               15,389.37                   Capital Outlay ‐                                8,580.00                      37,000.00                    23.19% ‐                                ‐                                ‐                                          8,580.00                     Total 24,298.46                    162,838.16                  407,489.00                  39.96% 31,432.16                    132,847.37                  (7,133.70)                               29,990.79                   City of Prattville February 2020 Unaudited Expenditures By Department Engineering Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 33,125.31                    192,242.09                 552,052.00                 34.82% 36,715.13                    174,241.17                 (3,589.82)                               18,000.92                  Benefits 5,912.02                      45,853.17                    113,511.00                 40.40% 6,680.68                      44,511.36                    (768.66)                                  1,341.81                     Operations 19,452.45                    138,064.05                 566,300.00                 24.38% 19,291.33                    113,906.71                 161.12                                   24,157.34                  Capital Outlay ‐                                ‐                                333,718.00                 0.00% ‐                                ‐                                ‐                                          ‐                              Total 58,489.78                    376,159.31                 1,565,581.00              24.03% 62,687.14                    332,659.24                 (4,197.36)                               43,500.07                  Planning Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 22,243.82                    128,620.99                 335,243.00                 38.37% 16,926.84                    70,671.24                    5,316.98                                57,949.75                  Benefits 3,835.82                      23,191.64                    60,022.00                    38.64% 3,044.07                      13,235.01                    791.75                                   9,956.63                     Operations 36,667.80                    210,866.76                 727,450.00                 28.99% 42,641.88                    163,464.08                 (5,974.08)                               47,402.68                  Capital Outlay ‐                               ‐                              ‐                                0.00% ‐                                ‐                                ‐                                          ‐                              Total 62,747.44                    362,679.39                 1,122,715.00              32.30% 62,612.79                    247,370.33                 134.65                                   115,309.06                Urban Management Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 68,158.35                    369,081.13                 927,120.00                 39.81% 48,663.31                    253,228.52                 19,495.04                              115,852.61                Benefits 11,095.57                    71,899.11                    167,371.00                 42.96% 7,216.07                      55,829.03                    3,879.50                                16,070.08                  Operations 27,587.13                    213,307.55                 493,000.00                 43.27% 30,457.95                    183,987.91                 (2,870.82)                               29,319.64                  Capital Outlay ‐                                ‐                                30,000.00                    0.00% ‐                                ‐                                ‐                                          ‐                              Total 106,841.05                 654,287.79                 1,617,491.00              40.45% 86,337.33                    493,045.46                 20,503.72                              161,242.33                Facilities Maintenance Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 28,381.28                    152,849.99                 363,631.00                 42.03% 25,209.68                    118,331.57                 3,171.60                                34,518.42                  Benefits 4,360.19                      26,731.15                    59,507.00                    44.92% 3,876.17                      21,757.48                    484.02                                   4,973.67                     Operations 21,067.80                    62,260.87                    194,210.00                 32.06% 16,443.90                    66,304.08                    4,623.90                                (4,043.21)                   Capital Outlay 13,626.00                    13,626.00                    91,466.00                    14.90% ‐                                ‐                                13,626.00                              13,626.00                  Total 67,435.27                    255,468.01                 708,814.00                 36.04% 45,529.75                    206,393.13                 21,905.52                              49,074.88                  Public Works Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 24,654.01                    131,174.55                 312,653.00                 41.96% 19,697.22                    94,130.61                    4,956.79                                37,043.94                  Benefits 4,247.35                      25,848.85                    58,569.00                    44.13% 3,407.60                      19,738.41                    839.75                                   6,110.44                     Operations 21,755.81                    125,088.45                 224,718.00                 55.66% 22,337.39                    104,348.36                 (581.58)                                  20,740.09                  Capital Outlay ‐                                ‐                                225,000.00                 0.00% ‐                                ‐                                ‐                                          ‐                              Total 50,657.17                    282,111.85                 820,940.00                 34.36% 45,442.21                    218,217.38                 5,214.96                                63,894.47                  Police Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 400,876.19                 2,227,381.74              5,557,043.00              40.08% 369,368.80                 1,753,851.61              31,507.39                              473,530.13                Benefits 65,412.11                    464,348.36                 1,044,030.00              44.48% 62,688.98                    393,635.37                 2,723.13                                70,712.99                  Operations 43,295.66                    617,560.63                 1,425,809.00              43.31% 175,192.84                 484,989.77                 (131,897.18)                          132,570.86                Capital Outlay ‐                                96,140.92                    133,600.00                 71.96% 103,532.00                 103,532.00                 (103,532.00)                          (7,391.08)                   Total 509,583.96                 3,405,431.65              8,160,482.00              41.73% 710,782.62                 2,736,008.75              (201,198.66)                          669,422.90                Fire Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 346,950.78                 2,175,296.73              5,047,501.00              43.10% 340,949.27                 1,655,961.86              6,001.51                                519,334.87                Benefits 60,451.17                    493,201.83                 1,012,418.00              48.72% 60,247.40                    411,226.96                 203.77                                   81,974.87                  Operations 63,180.95                    358,857.08                 1,044,321.00              34.36% 102,098.94                 381,636.43                 (38,917.99)                            (22,779.35)                 Capital Outlay ‐                                ‐                                ‐                                0.00% 177,680.00                 177,680.00                 (177,680.00)                          (177,680.00)               Total 470,582.90                 3,027,355.64              7,104,240.00              42.61% 680,975.61                 2,626,505.25              (210,392.71)                          400,850.39                Building Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 18,804.81                    103,149.94                 244,473.00                 42.19% 22,682.29                    107,515.33                 (3,877.48)                               (4,365.39)                   Benefits 3,271.38                      21,218.21                    49,214.00                    43.11% 4,016.08                      22,635.29                    (744.70)                                  (1,417.08)                   Operations 2,200.98                      22,838.15                    55,450.00                    41.19% 3,958.24                      21,918.47                    (1,757.26)                               919.68                        Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                ‐                                ‐                                          ‐                              Total 24,277.17                    147,206.30                 349,137.00                 42.16% 30,656.61                    152,069.09                 (6,379.44)                               (4,862.79)                   Parks & Recreation Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 76,129.12                    408,877.49                 1,005,486.00              40.66% 56,360.38                    268,241.41                 19,768.74                              140,636.08                Benefits 11,942.47                    75,994.72                    169,471.00                 44.84% 9,126.46                      57,004.99                    2,816.01                                18,989.73                  Operations 113,899.24                 449,486.96                 1,174,070.00              38.28% 95,192.34                    336,853.02                 18,706.90                              112,633.94                Capital Outlay/ Capital Projects ‐                                36,480.00                    200,400.00                 18.20% 316,879.00                 350,324.00                 (316,879.00)                          (313,844.00)               Total 201,970.83                 970,839.17                 2,549,427.00              38.08% 477,558.18                 1,012,423.42              (275,587.35)                          (41,584.25)                 Performing Arts Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 9,546.15                      48,911.09                    106,627.00                 45.87% 6,258.22                      30,289.13                    3,287.93                                18,621.96                  Benefits 1,363.96                      7,203.99                      15,770.00                    45.68% 967.55                         4,891.43                      396.41                                   2,312.56                     Operations 13,352.96                    65,319.48                    266,690.00                 24.49% 8,311.72                      49,572.67                    5,041.24                                15,746.81                  Capital Outlay ‐                                ‐                                ‐                                0.00% ‐                                10,514.00                    ‐                                          (10,514.00)                 Total 24,263.07                    121,434.56                 389,087.00                 31.21% 15,537.49                    95,267.23                    8,725.58                                26,167.33                  Non‐Departmental Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference City ‐ County Svcs 7,083.33                      212,500.02                 425,000.00                 50.00% 16,666.67                    215,000.02                 (9,583.34)                               (2,500.00)                   Community Initiatives 52,878.45                    403,728.81                 979,274.00                 41.23% 53,150.73                    338,479.50                 (272.28)                                  65,249.31                  Transfer to DSF ‐ One Cent 1,249,727.94              3,174,833.47              3,394,441.00              93.53% 1,295,456.73              3,176,085.20              (45,728.79)                            (1,251.73)                   Transfer to DSF ‐ Other ‐                                358,387.39                 664,029.00                 53.97% ‐                                116,093.42                 ‐                                          242,293.97                Transfer to Group Health 249,583.33                 1,247,916.65              2,995,000.00              41.67% 247,167.00                 1,235,835.00              2,416.33                                12,081.65                  Transfer to Capital Project Fund ‐                                10,772.24                    75,000.00                    14.36% 10,638.76                    63,316.18                    (10,638.76)                            (52,543.94)                 Transfer to Gas Tax Fund ‐                                ‐                                22,000.00                    0.00% ‐                                ‐                                ‐                                          ‐                              Transfer to Judicial ‐                                121,794.00                 0.00% ‐                                ‐                                ‐                                          ‐                              Total 1,559,273.05              5,408,138.58              8,676,538.00              62.33% 1,623,079.89              5,144,809.32              (63,806.84)                            263,329.26                Debt Service Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Debt Service 22,882.60                    681,846.77                 1,728,000.00              39.46% 115,497.76                 718,815.54                 (92,615.16)                            (36,968.77)                 Total 22,882.60                    681,846.77                 1,728,000.00              39.46% 115,497.76                 718,815.54                 (92,615.16)                            (36,968.77)                 Total Feb‐20 YTD Budget % of Budget Feb‐19 YTD February Difference YTD Difference Salary 1,151,498.44              6,608,186.95              16,076,337.00            41.11% 1,062,313.57              5,082,528.48              89,184.87                              1,525,658.47             Benefits 439,998.76                 2,612,114.60              6,004,987.00              43.50% 426,482.18                 2,373,484.85              13,516.58                              238,629.75                Operations 639,503.50                 3,813,067.05              9,862,517.00              38.66% 748,983.21                 3,332,981.65              (109,479.71)                          480,085.40                Capital Outlay 74,048.73                    248,865.05                 1,251,184.00              19.89% 598,091.00                 642,050.00                 (524,042.27)                          (393,184.95)               Debt Service 1,272,610.54              4,215,067.63              5,786,470.00              72.84% 1,410,954.49              4,010,994.16              (138,343.95)                          204,073.47                Total 3,577,659.97              17,497,301.28            38,981,495.00            44.89% 4,246,824.45              15,442,039.14            (669,164.48)                          2,055,262.14             Prepared by      Daniel Oakley