Loading...
October 2018 - Council Expense InformationAs of  11/15/2018 8.33 % Year Complete Executive Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 20,043.13                   20,043.13                   322,551.00                 6.21% 14,113.30                   14,113.30                   5,929.83                               5,929.83                     Benefits 2,668.05                     2,668.05                     45,910.00                   5.81% 1,581.69                     1,581.69                     1,086.36                               1,086.36                     Operations 13,420.70                   13,420.70                   137,333.00                 9.77% 13,837.67                   13,837.67                   (416.97)                                 (416.97)                       Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 36,131.88                   36,131.88                   505,794.00                 7.14% 29,532.66                   29,532.66                   6,599.22                               6,599.22                     Legislative Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 10,417.04                   10,417.04                   125,000.00                 8.33% 10,417.04                   10,417.04                    ‐                                          ‐                               Benefits 750.24                         750.24                         10,400.00                   7.21% 716.25                         716.25                         33.99                                     33.99                          Operations 489.77                         489.77                         13,600.00                   3.60% 513.71                         513.71                         (23.94)                                    (23.94)                         Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 11,657.05                   11,657.05                   149,000.00                 7.82% 11,647.00                   11,647.00                   10.05                                     10.05                          Finance Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 21,419.09                   21,419.09                   334,879.00                 6.40% 22,106.83                   22,106.83                   (687.74)                                 (687.74)                       Benefits 3,574.29                     3,574.29                     56,850.00                   6.29% 3,459.29                     3,459.29                     115.00                                   115.00                        Operations 8,396.44                     8,396.44                     242,460.00                 3.46% 7,074.62                     7,074.62                     1,321.82                               1,321.82                     Capital Outlay ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 33,389.82                   33,389.82                   634,189.00                 5.26% 32,640.74                   32,640.74                   749.08                                   749.08                        City Clerk Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 9,867.75                     9,867.75                     136,748.00                 7.22% 9,711.27                     9,711.27                     156.48                                   156.48                        Benefits 1,572.50                     1,572.50                     22,849.00                   6.88% 1,420.18                     1,420.18                     152.32                                   152.32                        Operations 1,856.13                     1,856.13                     49,250.00                   3.77% 1,680.59                     1,680.59                     175.54                                   175.54                        Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 13,296.38                   13,296.38                   208,847.00                 6.37% 12,812.04                   12,812.04                   484.34                                   484.34                        HR Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 21,446.82                   21,446.82                   283,708.00                 7.56% 16,489.51                   16,489.51                   4,957.31                               4,957.31                     Benefits 3,780.74                     3,780.74                     52,191.00                   7.24% 2,660.30                     2,660.30                     1,120.44                               1,120.44                     Operations 4,270.19                     4,270.19                     82,050.00                   5.20% 3,172.16                     3,172.16                     1,098.03                               1,098.03                     Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                          ‐                               Total 29,497.75                   29,497.75                   417,949.00                 7.06% 22,321.97                   22,321.97                   7,175.78                               7,175.78                     IT Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 13,371.83                   13,371.83                   168,121.00                 7.95% 12,222.40                   12,222.40                   1,149.43                               1,149.43                     Benefits 2,001.65                     2,001.65                     26,195.00                   7.64% 1,712.44                     1,712.44                     289.21                                   289.21                        Operations 112,251.41                 112,251.41                 1,426,295.00             7.87% 50,733.73                   50,733.73                   61,517.68                             61,517.68                   Capital Outlay ‐                                ‐                               109,000.00                 0.00%‐                                ‐                                ‐                                          ‐                               Total 127,624.89                 127,624.89                 1,729,611.00             7.38% 64,668.57                   64,668.57                   62,956.32                             62,956.32                   Vehicle Maint. Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 18,762.09                   18,762.09                   253,371.00                 7.40% 19,076.87                   19,076.87                   (314.78)                                 (314.78)                       Benefits 3,146.64                     3,146.64                     55,222.00                   5.70% 2,825.61                     2,825.61                     321.03                                   321.03                        Operations 2,559.32                     2,559.32                     103,450.00                 2.47% (48.03)                         (48.03)                         2,607.35                               2,607.35                     Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 24,468.05                   24,468.05                   412,043.00                 5.94% 21,854.45                   21,854.45                   2,613.60                               2,613.60                     City of Prattville October Unaudited Expenses By Department Engineering Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 36,586.30                   36,586.30                   488,503.00                7.49% 30,653.62                   30,653.62                   5,932.68                               5,932.68                     Benefits 6,604.12                     6,604.12                     110,944.00                5.95% 5,075.87                     5,075.87                     1,528.25                               1,528.25                     Operations 33,242.29                   33,242.29                   546,500.00                6.08% 38,070.40                   38,070.40                   (4,828.11)                              (4,828.11)                   Capital Projects ‐                                ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 76,432.71                   76,432.71                   1,145,947.00             6.67% 73,799.89                   73,799.89                   2,632.82                               2,632.82                     Planning Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 9,806.68                     9,806.68                     230,589.00                4.25% 19,443.57                   19,443.57                   (9,636.89)                              (9,636.89)                   Benefits 1,689.24                     1,689.24                     40,930.00                   4.13% 3,167.07                     3,167.07                     (1,477.83)                              (1,477.83)                   Operations 10,037.07                   10,037.07                   502,450.00                2.00% 5,962.71                     5,962.71                     4,074.36                               4,074.36                     Capital Projects ‐                                ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Capital Outlay ‐                                ‐                               32,000.00                   0.00%‐                                ‐                                ‐                                          ‐                              Total 21,532.99                   21,532.99                   805,969.00                2.67% 28,573.35                   28,573.35                   (7,040.36)                              (7,040.36)                   Urban Management Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 52,083.20                   52,083.20                   843,847.00                6.17% 58,263.14                   58,263.14                   (6,179.94)                              (6,179.94)                   Benefits 8,276.11                     8,276.11                     165,421.00                5.00% 8,510.33                     8,510.33                     (234.22)                                 (234.22)                       Operations 45,711.95                   45,711.95                   530,750.00                8.61% 29,883.14                   29,883.14                   15,828.81                             15,828.81                  Capital Outlay ‐                                ‐                               63,000.00                   0.00%‐                                ‐                                ‐                                          ‐                              Total 106,071.26                106,071.26                1,603,018.00             6.62% 96,656.61                   96,656.61                   9,414.65                               9,414.65                     Facilities Maintenance Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 25,028.95                   25,028.95                   330,843.00                7.57% 19,457.61                   19,457.61                   5,571.34                               5,571.34                     Benefits 3,800.87                     3,800.87                     56,573.00                   6.72% 2,886.56                     2,886.56                     914.31                                  914.31                        Operations 9,305.15                     9,305.15                     170,000.00                5.47% 8,079.77                     8,079.77                     1,225.38                               1,225.38                     Capital Outlay ‐                                ‐                               148,000.00                0.00%‐                                ‐                                ‐                                          ‐                              Total 38,134.97                   38,134.97                   705,416.00                5.41% 30,423.94                   30,423.94                   7,711.03                               7,711.03                     Public Works Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 19,678.59                   19,678.59                   268,409.00                7.33% 25,402.09                   25,402.09                   (5,723.50)                              (5,723.50)                   Benefits 3,362.17                     3,362.17                     52,443.00                   6.41% 3,974.66                     3,974.66                     (612.49)                                 (612.49)                       Operations 21,838.83                   21,838.83                   241,718.00                9.03% 14,686.67                   14,686.67                   7,152.16                               7,152.16                     Capital Outlay ‐                                ‐                               265,000.00                0.00%‐                                ‐                                ‐                                          ‐                              Total 44,879.59                   44,879.59                   827,570.00                5.42% 44,063.42                   44,063.42                   816.17                                  816.17                        Police Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 372,822.04                372,822.04                5,205,663.00             7.16% 376,078.38                376,078.38                (3,256.34)                              (3,256.34)                   Benefits 63,131.58                   63,131.58                   1,062,696.00             5.94% 59,356.48                   59,356.48                   3,775.10                               3,775.10                     Operations 171,655.24                171,655.24                1,311,933.00             13.08% 166,270.43                166,270.43                5,384.81                               5,384.81                     Capital Outlay ‐                                ‐                               112,000.00                0.00%‐                                ‐                                ‐                                          ‐                              Total 607,608.86                607,608.86                7,692,292.00             7.90% 601,705.29                601,705.29                5,903.57                               5,903.57                     Fire Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 354,127.08                354,127.08                4,704,544.00             7.53% 340,512.90                340,512.90                13,614.18                             13,614.18                  Benefits 61,070.61                   61,070.61                   1,046,996.00             5.83% 55,618.47                   55,618.47                   5,452.14                               5,452.14                     Operations 85,924.80                   85,924.80                   1,123,052.00             7.65% 91,993.45                   91,993.45                   (6,068.65)                              (6,068.65)                   Capital Outlay ‐                                ‐                               250,000.00                0.00%‐                                ‐                                ‐                                          ‐                              Total 501,122.49                501,122.49                7,124,592.00             7.03% 488,124.82                488,124.82                12,997.67                             12,997.67                  Building Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 22,569.60                   22,569.60                   300,082.00                7.52% 22,470.40                   22,470.40                   99.20                                    99.20                          Benefits 3,988.87                     3,988.87                     61,838.00                   6.45% 3,653.82                     3,653.82                     335.05                                  335.05                        Operations 4,927.87                     4,927.87                     63,200.00                   7.80% 4,524.35                     4,524.35                     403.52                                  403.52                        Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 31,486.34                   31,486.34                   425,120.00                7.41% 30,648.57                   30,648.57                   837.77                                  837.77                        Parks & Recreation Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 58,770.09                   58,770.09                   940,078.00                6.25% 46,520.39                   46,520.39                   12,249.70                             12,249.70                  Benefits 8,996.24                     8,996.24                     150,087.00                5.99% 6,645.13                     6,645.13                     2,351.11                               2,351.11                     Operations 85,911.89                   85,911.89                   1,343,500.00             6.39% 47,947.24                   47,947.24                   37,964.65                             37,964.65                  Capital Outlay/ Capital Projects ‐                                ‐                               754,820.00                0.00%‐                                ‐                                ‐                                          ‐                              Total 153,678.22                153,678.22                3,188,485.00             4.82% 101,112.76                101,112.76                52,565.46                             52,565.46                  Performing Arts Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 5,683.60                     5,683.60                     91,929.00                   6.18% 4,997.74                     4,997.74                     685.86                                  685.86                        Benefits 874.12                        874.12                        13,525.00                   6.46% 721.17                        721.17                        152.95                                  152.95                        Operations 5,625.91                     5,625.91                     258,595.00                2.18% 4,215.28                     4,215.28                     1,410.63                               1,410.63                     Capital Outlay ‐                                ‐                               17,500.00                    ‐                                ‐                                          ‐                              Total 12,183.63                   12,183.63                   381,549.00                3.19% 9,934.19                     9,934.19                     2,249.44                               2,249.44                     Non‐Departmental Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference City ‐ County Svcs 90,833.34                   90,833.34                   410,000.00                22.15% 94,166.67                   94,166.67                   (3,333.33)                              (3,333.33)                   Community Initiatives 64,139.02                   64,139.02                   978,094.00                6.56% 37,798.87                   37,798.87                   26,340.15                             26,340.15                  Transfer to DSF ‐ One Cent 1,880,628.47             1,880,628.47             3,493,844.00             53.83% 3,445,563.44             3,445,563.44             (1,564,934.97)                      (1,564,934.97)           Transfer to DSF ‐ Other 84,218.42                   84,218.42                   177,066.00                47.56% 84,218.42                   84,218.42                    ‐                                          ‐                              Transfer to Group Health 247,167.00                247,167.00                2,966,000.00             8.33% 249,375.00                249,375.00                (2,208.00)                              (2,208.00)                   Transfer to Capital Project Fund 19,462.24                   19,462.24                   181,869.00                10.70% 29,082.90                   29,082.90                   (9,620.66)                              (9,620.66)                   Transfer to Gas Tax Fund 188,150.00                0.00%‐                                          ‐                              Transfer to Judicial ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Total 2,386,448.49             2,386,448.49             8,395,023.00             28.43% 3,940,205.30             3,940,205.30             (1,553,756.81)                      (1,553,756.81)           Debt Service Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Debt Service 116,478.07                116,478.07                1,530,500.00             7.61% 79,228.61                   79,228.61                   37,249.46                             37,249.46                  Total 116,478.07                116,478.07                1,530,500.00             7.61% 79,228.61                   79,228.61                   37,249.46                             37,249.46                  Total Oct‐18 YTD Budget % of Budget Oct‐17 YTD October Difference YTD Difference Salary 1,072,483.88             1,072,483.88             15,028,865.00           7.14% 1,047,937.06             1,047,937.06             24,546.82                             24,546.82                  Benefits 426,455.04                426,455.04                5,997,070.00             7.11% 413,360.32                413,360.32                13,094.72                             13,094.72                  Operations 791,859.56                791,859.56                9,904,249.00             8.00% 649,646.33                649,646.33                142,213.23                          142,213.23                Capital Outlay ‐                                ‐                               1,751,320.00             0.00%‐                                ‐                                ‐                                          ‐                              Debt Service 2,081,324.96             2,081,324.96             5,201,410.00             40.01% 3,609,010.47             3,609,010.47             (1,527,685.51)                      (1,527,685.51)           Total 4,372,123.44             4,372,123.44             37,882,914.00           11.54% 5,719,954.18             5,719,954.18             (1,347,830.74)                      (1,347,830.74)           Prepared by     Daniel Oakley