Loading...
November 2018 - Council Expense InformationAs of  12/14/2018 16.67 % Year Complete Executive Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 22,490.47                   42,533.60                   322,551.00                 13.19% 19,879.71                   33,993.01                   2,610.76                               8,540.59                     Benefits 2,484.86                     5,152.91                     45,910.00                   11.22% 2,546.93                     4,128.62                     (62.07)                                    1,024.29                     Operations 3,487.50                     16,908.20                   137,333.00                 12.31% 13,791.19                   27,628.86                   (10,303.69)                            (10,720.66)                 Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 28,462.83                   64,594.71                   505,794.00                 12.77% 36,217.83                   65,750.49                   (7,755.00)                              (1,155.78)                   Legislative Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 10,417.04                   20,834.08                   125,000.00                 16.67% 10,417.04                   20,834.08                    ‐                                          ‐                               Benefits 750.24                         1,500.48                     10,400.00                   14.43% 859.05                         1,575.30                     (108.81)                                 (74.82)                         Operations ‐                               489.77                         13,600.00                   3.60% 225.00                         738.71                         (225.00)                                 (248.94)                       Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 11,167.28                   22,824.33                   149,000.00                 15.32% 11,501.09                   23,148.09                   (333.81)                                 (323.76)                       Finance Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 21,761.58                   43,180.67                   334,879.00                 12.89% 22,047.89                   44,154.72                   (286.31)                                 (974.05)                       Benefits 3,648.97                     7,223.26                     56,850.00                   12.71% 3,542.26                     7,001.55                     106.71                                   221.71                        Operations 5,674.58                     14,071.02                   242,460.00                 5.80% 18,423.13                   25,497.75                   (12,748.55)                            (11,426.73)                 Capital Outlay ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 31,085.13                   64,474.95                   634,189.00                 10.17% 44,013.28                   76,654.02                   (12,928.15)                            (12,179.07)                 City Clerk Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 10,035.02                   19,902.77                   136,748.00                 14.55% 9,711.27                     19,422.54                   323.75                                   480.23                        Benefits 1,673.05                     3,245.55                     22,849.00                   14.20% 1,543.44                     2,963.62                     129.61                                   281.93                        Operations 1,807.74                     3,663.87                     49,250.00                   7.44% 1,885.73                     3,566.32                     (77.99)                                    97.55                          Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 13,515.81                   26,812.19                   208,847.00                 12.84% 13,140.44                   25,952.48                   375.37                                   859.71                        HR Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 21,561.38                   43,008.20                   283,708.00                 15.16% 16,916.23                   33,405.74                   4,645.15                               9,602.46                     Benefits 3,921.07                     7,701.81                     52,191.00                   14.76% 2,856.80                     5,517.10                     1,064.27                               2,184.71                     Operations 1,234.58                     5,504.77                     82,050.00                   6.71% 5,637.73                     8,809.89                     (4,403.15)                              (3,305.12)                   Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                          ‐                               Total 26,717.03                   56,214.78                   417,949.00                 13.45% 25,410.76                   47,732.73                   1,306.27                               8,482.05                     IT Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 12,498.62                   25,870.45                   168,121.00                 15.39% 12,233.29                   24,455.69                   265.33                                   1,414.76                     Benefits 1,875.80                     3,877.45                     26,195.00                   14.80% 1,750.66                     3,463.10                     125.14                                   414.35                        Operations 71,714.88                   183,966.29                 1,426,295.00             12.90% 144,507.58                 195,241.31                 (72,792.70)                            (11,275.02)                 Capital Outlay ‐                                ‐                               109,000.00                 0.00%‐                                ‐                                ‐                                          ‐                               Total 86,089.30                   213,714.19                 1,729,611.00             12.36% 158,491.53                 223,160.10                 (72,402.23)                            (9,445.91)                   Vehicle Maint. Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 18,831.57                   37,593.66                   253,371.00                 14.84% 18,927.26                   38,004.13                   (95.69)                                    (410.47)                       Benefits 3,220.59                     6,367.23                     55,222.00                   11.53% 2,876.85                     5,702.46                     343.74                                   664.77                        Operations 1,084.07                     3,643.39                     103,450.00                 3.52% (2,436.07)                    (2,484.10)                    3,520.14                               6,127.49                     Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 23,136.23                   47,604.28                   412,043.00                 11.55% 19,368.04                   41,222.49                   3,768.19                               6,381.79                     City of Prattville November Unaudited Expenses By Department Engineering Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 36,914.66                   73,500.96                   488,503.00                15.05% 31,121.06                   61,774.68                   5,793.60                               11,726.28                  Benefits 6,811.71                     13,415.83                   110,944.00                12.09% 5,356.94                     10,432.81                   1,454.77                               2,983.02                     Operations 3,477.96                     36,720.25                   546,500.00                6.72% 23,054.40                   61,124.80                   (19,576.44)                           (24,404.55)                 Capital Projects ‐                                ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 47,204.33                   123,637.04                1,145,947.00             10.79% 59,532.40                   133,332.29                (12,328.07)                           (9,695.25)                   Planning Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 13,319.85                   23,126.53                   230,589.00                10.03% 16,758.42                   36,201.99                   (3,438.57)                              (13,075.46)                 Benefits 2,443.12                     4,132.36                     40,930.00                   10.10% 2,859.97                     6,027.04                     (416.85)                                 (1,894.68)                   Operations 29,376.03                   39,413.10                   502,450.00                7.84% 19,164.70                   25,127.41                   10,211.33                             14,285.69                  Capital Projects ‐                                ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Capital Outlay ‐                                ‐                               32,000.00                   0.00%‐                                ‐                                ‐                                          ‐                              Total 45,139.00                   66,671.99                   805,969.00                8.27% 38,783.09                   67,356.44                   6,355.91                               (684.45)                       Urban Management Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 52,025.08                   104,108.28                843,847.00                12.34% 47,666.13                   105,929.27                4,358.95                               (1,820.99)                   Benefits 8,438.38                     16,714.49                   165,421.00                10.10% 7,286.51                     15,796.84                   1,151.87                               917.65                        Operations 15,355.79                   61,067.74                   530,750.00                11.51% 27,432.36                   57,315.50                   (12,076.57)                           3,752.24                     Capital Outlay ‐                                ‐                               63,000.00                   0.00%‐                                ‐                                ‐                                          ‐                              Total 75,819.25                   181,890.51                1,603,018.00             11.35% 82,385.00                   179,041.61                (6,565.75)                              2,848.90                     Facilities Maintenance Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 24,834.59                   49,863.54                   330,843.00                15.07% 20,846.86                   40,304.47                   3,987.73                               9,559.07                     Benefits 3,780.43                     7,581.30                     56,573.00                   13.40% 3,133.87                     6,020.43                     646.56                                  1,560.87                     Operations 1,349.23                     10,654.38                   170,000.00                6.27% 4,287.24                     12,367.01                   (2,938.01)                              (1,712.63)                   Capital Outlay ‐                                ‐                               148,000.00                0.00%‐                                ‐                                ‐                                          ‐                              Total 29,964.25                   68,099.22                   705,416.00                9.65% 28,267.97                   58,691.91                   1,696.28                               9,407.31                     Public Works Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 19,880.33                   39,558.92                   268,409.00                14.74% 33,342.35                   58,744.44                   (13,462.02)                           (19,185.52)                 Benefits 3,423.47                     6,785.64                     52,443.00                   12.94% 5,275.74                     9,250.40                     (1,852.27)                              (2,464.76)                   Operations 8,124.78                     29,963.61                   241,718.00                12.40% 19,587.01                   34,273.68                   (11,462.23)                           (4,310.07)                   Capital Outlay ‐                                ‐                               265,000.00                0.00%‐                                ‐                                ‐                                          ‐                              Total 31,428.58                   76,308.17                   827,570.00                9.22% 58,205.10                   102,268.52                (26,776.52)                           (25,960.35)                 Police Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 364,015.67                736,837.71                5,205,663.00             14.15% 384,343.69                760,422.07                (20,328.02)                           (23,584.36)                 Benefits 61,594.69                   124,726.27                1,062,696.00             11.74% 61,564.01                   120,920.49                30.68                                    3,805.78                     Operations 23,149.43                   194,804.67                1,311,933.00             14.85% 134,019.62                300,290.05                (110,870.19)                         (105,485.38)               Capital Outlay ‐                                ‐                               112,000.00                0.00%‐                                ‐                                ‐                                          ‐                              Total 448,759.79                1,056,368.65             7,692,292.00             13.73% 579,927.32                1,181,632.61             (131,167.53)                         (125,263.96)               Fire Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 345,637.22                699,764.30                4,704,544.00             14.87% 363,490.09                704,002.99                (17,852.87)                           (4,238.69)                   Benefits 61,196.31                   122,266.92                1,046,996.00             11.68% 60,613.27                   116,231.74                583.04                                  6,035.18                     Operations 10,534.87                   96,459.67                   1,123,052.00             8.59% 118,576.41                210,569.86                (108,041.54)                         (114,110.19)               Capital Outlay ‐                                ‐                               250,000.00                0.00%‐                                ‐                                ‐                                          ‐                              Total 417,368.40                918,490.89                7,124,592.00             12.89% 542,679.77                1,030,804.59             (125,311.37)                         (112,313.70)               Building Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 22,603.21                   45,172.81                   300,082.00                15.05% 22,531.20                   45,001.60                   72.01                                    171.21                        Benefits 4,058.22                     8,047.09                     61,838.00                   13.01% 3,714.11                     7,367.93                     344.11                                  679.16                        Operations 756.86                        5,684.73                     63,200.00                   8.99% 8,592.62                     13,116.97                   (7,835.76)                              (7,432.24)                   Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 27,418.29                   58,904.63                   425,120.00                13.86% 34,837.93                   65,486.50                   (7,419.64)                              (6,581.87)                   Parks & Recreation Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 56,897.40                   115,667.49                940,078.00                12.30% 45,888.84                   92,409.23                   11,008.56                             23,258.26                  Benefits 8,991.79                     17,988.03                   150,087.00                11.99% 6,940.79                     13,585.92                   2,051.00                               4,402.11                     Operations 29,919.14                   115,831.03                1,343,500.00             8.62% 43,996.30                   91,943.54                   (14,077.16)                           23,887.49                  Capital Outlay/ Capital Projects ‐                                ‐                               754,820.00                0.00%‐                                ‐                                ‐                                          ‐                              Total 95,808.33                   249,486.55                3,188,485.00             7.82% 96,825.93                   197,938.69                (1,017.60)                              51,547.86                  Performing Arts Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 6,920.19                     12,603.79                   91,929.00                   13.71% 5,370.29                     10,368.03                   1,549.90                               2,235.76                     Benefits 1,076.12                     1,950.24                     13,525.00                   14.42% 795.18                        1,516.35                     280.94                                  433.89                        Operations 3,855.90                     9,481.81                     258,595.00                3.67% 7,889.56                     12,104.84                   (4,033.66)                              (2,623.03)                   Capital Outlay ‐                                ‐                               17,500.00                    ‐                                ‐                                          ‐                              Total 11,852.21                   24,035.84                   381,549.00                6.30% 14,055.03                   23,989.22                   (2,202.82)                              46.62                          Non‐Departmental Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference City ‐ County Svcs ‐                               90,833.34                   410,000.00                22.15% 13,333.34                   107,500.01                (13,333.34)                           (16,666.67)                 Community Initiatives 93,007.36                   157,146.38                978,094.00                16.07% 57,684.97                   95,483.84                   35,322.39                             61,662.54                  Transfer to DSF ‐ One Cent 1,880,628.47             3,493,844.00             53.83%‐                               3,445,563.44              ‐                                         (1,564,934.97)           Transfer to DSF ‐ Other 84,218.42                   177,066.00                47.56%‐                               84,218.42                    ‐                                          ‐                              Transfer to Group Health 247,167.00                494,334.00                2,966,000.00             16.67% 249,375.00                498,750.00                (2,208.00)                              (4,416.00)                   Transfer to Capital Project Fund 10,529.13                   29,991.37                   181,869.00                16.49% 580,391.45                609,474.35                (569,862.32)                         (579,482.98)               Transfer to Gas Tax Fund 188,150.00                0.00%‐                                          ‐                              Transfer to Judicial ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Total 350,703.49                2,737,151.98             8,395,023.00             32.60% 900,784.76                4,840,990.06             (550,081.27)                         (2,103,838.08)           Debt Service Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Debt Service 122,779.77                239,257.84                1,530,500.00             15.63% 103,145.34                182,373.95                19,634.43                             56,883.89                  Total 122,779.77                239,257.84                1,530,500.00             15.63% 103,145.34                182,373.95                19,634.43                             56,883.89                  Total Nov‐18 YTD Budget % of Budget Nov‐17 YTD November Difference YTD Difference Salary 1,060,643.88             2,133,127.76             15,028,865.00           14.19% 1,081,491.62             2,129,428.68             (20,847.74)                           3,699.08                     Benefits 426,555.82                853,010.86                5,997,070.00             14.22% 422,891.38                836,251.70                3,664.44                               16,759.16                  Operations 314,439.83                1,106,299.39             9,904,249.00             11.17% 1,240,044.27             1,889,690.60             (925,604.44)                         (783,391.21)               Capital Outlay ‐                                ‐                               1,751,320.00             0.00%‐                                ‐                                ‐                                          ‐                              Debt Service 122,779.77                2,204,104.73             5,201,410.00             42.38% 103,145.34                3,712,155.81             19,634.43                             (1,508,051.08)           Total 1,924,419.30             6,296,542.74             37,882,914.00           16.62% 2,847,572.61             8,567,526.79             (923,153.31)                         (2,270,984.05)           Prepared by     Daniel Oakley