Loading...
October 2017 - Council Expense InformationAs of  11/17/2017 8.33 % Year Complete Executive Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 14,113.30                   14,113.30                   322,218.00                 4.38% 14,484.60                   14,484.60                   (371.30)                                 (371.30)                       Benefits 1,581.69                     1,581.69                     44,131.00                   3.58% 1,826.24                     1,826.24                     (244.55)                                 (244.55)                       Operations 13,837.67                   13,837.67                   105,533.00                 13.11% 5,747.79                     5,747.79                     8,089.88                               8,089.88                     Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 29,532.66                   29,532.66                   471,882.00                 6.26% 22,058.63                   22,058.63                   7,474.03                               7,474.03                     Legislative Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 10,417.04                   10,417.04                   125,000.00                 8.33% 10,417.04                   10,417.04                    ‐                                          ‐                               Benefits 716.25                         716.25                         10,415.00                   6.88% 704.87                         704.87                         11.38                                     11.38                          Operations 513.71                         513.71                         25,800.00                   1.99% 513.71                                   513.71                        Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 11,647.00                   11,647.00                   161,215.00                 7.22% 11,121.91                   11,121.91                   525.09                                   525.09                        Finance Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 22,106.83                   22,106.83                   306,088.00                 7.22% 16,820.41                   16,820.41                   5,286.42                               5,286.42                     Benefits 3,459.29                     3,459.29                     49,281.00                   7.02% 2,470.23                     2,470.23                     989.06                                   989.06                        Operations 7,074.62                     7,074.62                     259,155.00                 2.73% 12,951.03                   12,951.03                   (5,876.41)                              (5,876.41)                   Capital Outlay ‐                                ‐                               25,000.00                   0.00%‐                                          ‐                               Total 32,640.74                   32,640.74                   639,524.00                 5.10% 32,241.67                   32,241.67                   399.07                                   399.07                        City Clerk Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 9,711.27                     9,711.27                     126,487.00                 7.68% 9,559.61                     9,559.61                     151.66                                   151.66                        Benefits 1,420.18                     1,420.18                     20,169.00                   7.04% 1,395.33                     1,395.33                     24.85                                     24.85                          Operations 1,680.59                     1,680.59                     62,300.00                   2.70% 14,141.87                   14,141.87                   (12,461.28)                            (12,461.28)                 Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 12,812.04                   12,812.04                   208,956.00                 6.13% 25,096.81                   25,096.81                   (12,284.77)                            (12,284.77)                 HR Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 16,489.51                   16,489.51                   274,485.00                 6.01% 16,326.62                   16,326.62                   162.89                                   162.89                        Benefits 2,660.30                     2,660.30                     44,794.00                   5.94% 2,609.83                     2,609.83                     50.47                                     50.47                          Operations 3,172.16                     3,172.16                     87,550.00                   3.62% 3,172.16                               3,172.16                     Capital Outlay ‐                                ‐                               0.00%‐                                          ‐                               Total 22,321.97                   22,321.97                   406,829.00                 5.49% 18,936.45                   18,936.45                   3,385.52                               3,385.52                     IT Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 12,222.40                   12,222.40                   162,125.00                 7.54% 7,163.95                     7,163.95                     5,058.45                               5,058.45                     Benefits 1,712.44                     1,712.44                     23,874.00                   7.17% 1,007.97                     1,007.97                     704.47                                   704.47                        Operations 50,733.73                   50,733.73                   1,259,460.00             4.03% 84,749.20                   84,749.20                   (34,015.47)                            (34,015.47)                 Capital Outlay ‐                                ‐                               40,000.00                   0.00%‐                                          ‐                               Total 64,668.57                   64,668.57                   1,485,459.00             4.35% 92,921.12                   92,921.12                   (28,252.55)                            (28,252.55)                 Vehicle Maint. Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 19,076.87                   19,076.87                   243,870.00                 7.82% 1,739.96                     1,739.96                     17,336.91                             17,336.91                   Benefits 2,825.61                     2,825.61                     50,505.00                   5.59% 2,603.74                     2,603.74                     221.87                                   221.87                        Operations (48.03)                         (48.03)                         104,950.00                  ‐0.05% 584.83                         584.83                         (632.86)                                 (632.86)                       Capital Outlay ‐                                ‐                               25,000.00                   0.00%‐                                          ‐                               Total 21,854.45                   21,854.45                   424,325.00                 5.15% 4,928.53                     4,928.53                     16,925.92                             16,925.92                   City of Prattville October Unaudited Expenses By Department Engineering Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 30,653.62                   30,653.62                   471,460.00                6.50% 32,535.93                   32,535.93                   (1,882.31)                              (1,882.31)                   Benefits 5,075.87                     5,075.87                     93,269.00                   5.44% 5,438.52                     5,438.52                     (362.65)                                 (362.65)                       Operations 38,070.40                   38,070.40                   622,346.00                6.12% 6,037.26                     6,037.26                     32,033.14                             32,033.14                  Captial Projects ‐                                ‐                               0.00%‐                                          ‐                              Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                          ‐                              Total 73,799.89                   73,799.89                   1,187,075.00             6.22% 44,011.71                   44,011.71                   29,788.18                             29,788.18                  Planning Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 19,443.57                   19,443.57                   247,504.00                7.86% 20,071.01                   20,071.01                   (627.44)                                 (627.44)                       Benefits 3,167.07                     3,167.07                     41,702.00                   7.59% 3,379.75                     3,379.75                     (212.68)                                 (212.68)                       Operations 5,962.71                     5,962.71                     503,700.00                1.18% 28,063.03                   28,063.03                   (22,100.32)                           (22,100.32)                 Captial Projects ‐                                ‐                               0.00%‐                                          ‐                              Capital Outlay ‐                                ‐                               6,000.00                     0.00%‐                                          ‐                              Total 28,573.35                   28,573.35                   798,906.00                3.58% 51,513.79                   51,513.79                   (22,940.44)                           (22,940.44)                 Urban Management Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 58,263.14                   58,263.14                   649,770.00                8.97% 66,319.13                   66,319.13                   (8,055.99)                              (8,055.99)                   Benefits 8,510.33                     8,510.33                     123,709.00                6.88% 10,134.81                   10,134.81                   (1,624.48)                              (1,624.48)                   Operations 29,883.14                   29,883.14                   564,750.00                5.29% 7,203.47                     7,203.47                     22,679.67                             22,679.67                  Capital Outlay ‐                                ‐                               191,500.00                0.00%‐                                          ‐                              Total 96,656.61                   96,656.61                   1,529,729.00             6.32% 83,657.41                   83,657.41                   12,999.20                             12,999.20                  Facilities Maintenance Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 19,457.61                   19,457.61                   267,205.00                7.28% 13,754.71                   13,754.71                   5,702.90                               5,702.90                     Benefits 2,886.56                     2,886.56                     47,755.00                   6.04% 2,077.38                     2,077.38                     809.18                                  809.18                        Operations 8,079.77                     8,079.77                     137,500.00                5.88% 306.98                        306.98                        7,772.79                               7,772.79                     Capital Outlay ‐                                ‐                               405,000.00                0.00%‐                                          ‐                              Total 30,423.94                   30,423.94                   857,460.00                3.55% 16,139.07                   16,139.07                   14,284.87                             14,284.87                  Public Works Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 25,402.09                   25,402.09                   582,714.00                4.36% 12,630.28                   12,630.28                   12,771.81                             12,771.81                  Benefits 3,974.66                     3,974.66                     131,966.00                3.01% 2,097.89                     2,097.89                     1,876.77                               1,876.77                     Operations 14,686.67                   14,686.67                   242,668.00                6.05% 652.68                        652.68                        14,033.99                             14,033.99                  Capital Outlay ‐                                ‐                               85,000.00                   0.00%‐                                          ‐                              Total 44,063.42                   44,063.42                   1,042,348.00             4.23% 15,380.85                   15,380.85                   28,682.57                             28,682.57                  Police Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 376,078.38                376,078.38                5,031,675.00             7.47% 354,403.38                354,403.38                21,675.00                             21,675.00                  Benefits 59,356.48                   59,356.48                   1,016,170.00             5.84% 56,301.20                   56,301.20                   3,055.28                               3,055.28                     Operations 166,270.43                166,270.43                1,278,392.00             13.01% 81,439.36                   81,439.36                   84,831.07                             84,831.07                  Capital Outlay ‐                                ‐                               206,251.00                0.00%‐                                          ‐                              Total 601,705.29                601,705.29                7,532,488.00             7.99% 492,143.94                492,143.94                109,561.35                          109,561.35                Fire Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 340,512.90                340,512.90                4,590,342.00             7.42% 332,428.98                332,428.98                8,083.92                               8,083.92                     Benefits 55,618.47                   55,618.47                   959,212.00                5.80% 54,104.64                   54,104.64                   1,513.83                               1,513.83                     Operations 91,993.45                   91,993.45                   1,167,011.00             7.88% 31,423.47                   31,423.47                   60,569.98                             60,569.98                  Capital Outlay ‐                                ‐                               113,120.00                0.00%‐                                          ‐                              Total 488,124.82                488,124.82                6,829,685.00             7.15% 417,957.09                417,957.09                70,167.73                             70,167.73                  Building Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 22,470.40                   22,470.40                   292,550.00                7.68% 22,824.42                   22,824.42                   (354.02)                                 (354.02)                       Benefits 3,653.82                     3,653.82                     54,720.00                   6.68% 3,713.80                     3,713.80                     (59.98)                                   (59.98)                         Operations 4,524.35                     4,524.35                     63,450.00                   7.13% 437.65                        437.65                        4,086.70                               4,086.70                     Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                          ‐                              Total 30,648.57                   30,648.57                   410,720.00                7.46% 26,975.87                   26,975.87                   3,672.70                               3,672.70                     Parks & Recreation Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 46,520.39                   46,520.39                   718,665.00                6.47% 45,945.16                   45,945.16                   575.23                                  575.23                        Benefits 6,645.13                     6,645.13                     122,111.00                5.44% 6,601.80                     6,601.80                     43.33                                    43.33                          Operations 47,947.24                   47,947.24                   1,208,999.00             3.97% 29,772.57                   29,772.57                   18,174.67                             18,174.67                  Capital Outlay/ Capital Projects ‐                                ‐                               392,500.00                0.00%‐                                          ‐                              Total 101,112.76                101,112.76                2,442,275.00             4.14% 82,319.53                   82,319.53                   18,793.23                             18,793.23                  Performing Arts Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 4,997.74                     4,997.74                     77,613.00                   6.44% 4,325.39                     4,325.39                     672.35                                  672.35                        Benefits 721.17                        721.17                        16,411.00                   4.39% 592.34                        592.34                        128.83                                  128.83                        Operations 4,215.28                     4,215.28                     222,760.00                1.89% 1,033.01                     1,033.01                     3,182.27                               3,182.27                     Capital Outlay ‐                                ‐                               ‐                                          ‐                              Total 9,934.19                     9,934.19                     316,784.00                3.14% 5,950.74                     5,950.74                     3,983.45                               3,983.45                     Non‐Departmental Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference City ‐ County Svcs 94,166.67                   94,166.67                   410,000.00                22.97% 6,666.67                     6,666.67                     87,500.00                             87,500.00                  Community Initiatives 37,798.87                   37,798.87                   930,624.00                4.06% 27,667.98                   27,667.98                   10,130.89                             10,130.89                  Transfer to DSF ‐ One Cent 3,445,563.44             3,445,563.44             6,366,000.00             54.12% 3,445,563.44                       3,445,563.44             Transfer to DSF ‐ Other 84,218.42                   84,218.42                   164,206.00                51.29% 84,218.42                             84,218.42                  Transfer to Group Health 249,375.00                249,375.00                2,992,500.00             8.33% 207,168.75                207,168.75                42,206.25                             42,206.25                  Transfer to Capital Project Fund 29,082.90                   29,082.90                   110,000.00                26.44% 29,082.90                             29,082.90                  Transfer to Judicial ‐                               53,093.00                   0.00%‐                                          ‐                              Total 3,940,205.30             3,940,205.30             11,026,423.00           35.73% 241,503.40                241,503.40                3,698,701.90                       3,698,701.90             Debt Service Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Debt Service 79,228.61                   79,228.61                   1,441,350.00             5.50% 54,372.41                   54,372.41                   24,856.20                             24,856.20                  Total 79,228.61                   79,228.61                   1,441,350.00             5.50% 54,372.41                   54,372.41                   24,856.20                             24,856.20                  Total Oct‐17 YTD Budget % of Budget Oct‐16 YTD October Difference YTD Difference Salary 1,047,937.06             1,047,937.06             14,489,771.00           7.23% 981,750.58                981,750.58                66,186.48                             66,186.48                  Benefits 413,360.32                413,360.32                5,842,694.00             7.07% 364,229.09                364,229.09                49,131.23                             49,131.23                  Operations 649,646.33                649,646.33                9,420,041.00             6.90% 338,878.85                338,878.85                310,767.48                          310,767.48                Capital Outlay ‐                                ‐                               1,489,371.00             0.00%‐                                ‐                                ‐                                          ‐                              Debt Service 3,609,010.47             3,609,010.47             7,971,556.00             45.27% 54,372.41                   54,372.41                   3,554,638.06                       3,554,638.06             Total 5,719,954.18             5,719,954.18             39,213,433.00           14.59% 1,739,230.93             1,739,230.93             3,980,723.25                       3,980,723.25             Prepared by     Daniel Oakley