Loading...
January 2017 - Council Expense InformationAs of  2/16/2017 33.33 % Year Complete Executive Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 14,484.04                   50,694.14                   188,224.01                 26.93% 14,336.22                   55,213.74                   147.82                                   (4,519.60)                   Benefits 1,998.38                     6,709.65                     23,124.37                   29.02% 1,725.92                     7,288.70                     272.46                                   (579.05)                       Operations 2,894.17                     29,443.85                   115,841.00                 25.42% 1,637.95                     33,145.27                   1,256.22                               (3,701.42)                   Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 19,376.59                   86,847.64                   327,189.38                 26.54% 17,700.09                   95,647.71                   1,676.50                               (8,800.07)                   Legislative Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 10,208.38                   42,097.15                   125,000.00                 33.68% 10,417.04                   41,668.16                   (208.66)                                 428.99                        Benefits 962.88                         3,273.67                     10,391.50                   31.50% 780.82                         3,143.70                     182.06                                   129.97                        Operations (60.04)                         2,256.72                     26,250.00                   8.60%‐                               2,204.22                     (60.04)                                    52.50                          Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 11,111.22                   47,627.54                   161,641.50                 29.46% 11,197.86                   47,016.08                   (86.64)                                    611.46                        Finance Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 21,808.04                   70,587.91                   303,798.29                 23.24% 22,977.77                   88,435.18                   (1,169.73)                              (17,847.27)                 Benefits 3,812.79                     11,968.04                   51,498.48                   23.24% 3,847.91                     16,508.86                   (35.12)                                    (4,540.82)                   Operations 10,396.94                   91,283.42                   235,620.00                 38.74% 3,419.56                     95,705.44                   6,977.38                               (4,422.02)                   Capital Outlay 27,839.00                   27,839.00                   27,839.00                   0.00% 27,839.00                             27,839.00                   Total 63,856.77                   201,678.37                 618,755.77                 32.59% 30,245.24                   200,649.48                 33,611.53                             1,028.89                     City Clerk Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 9,668.33                     32,686.36                   125,523.26                 26.04% 9,507.47                     34,694.95                   160.86                                   (2,008.59)                   Benefits 1,628.69                     5,524.34                     19,803.25                   27.90% 1,435.57                     6,012.61                     193.12                                   (488.27)                       Operations 741.48                         23,362.42                   88,000.00                   26.55% 1,000.21                     8,235.95                     (258.73)                                 15,126.47                   Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 12,038.50                   61,573.12                   233,326.51                 26.39% 11,943.25                   48,943.51                   95.25                                     12,629.61                   HR Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 16,886.44                   57,973.47                   229,327.53                 25.28% 16,624.11                   62,077.45                   262.33                                   (4,103.98)                   Benefits 3,117.65                     10,642.05                   38,035.49                   27.98% 2,739.29                     11,453.05                   378.36                                   (811.00)                       Operations 732.44                         9,658.02                     96,600.00                   10.00% 2,796.52                     26,325.01                   (2,064.08)                              (16,666.99)                 Capital Outlay ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 20,736.53                   78,273.54                   363,963.02                 21.51% 22,159.92                   99,855.51                   (1,423.39)                              (21,581.97)                 IT Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 7,313.20                     25,555.78                   165,975.83                 15.40% 9,282.11                     30,822.07                   (1,968.91)                              (5,266.29)                   Benefits 1,345.46                     4,158.68                     24,343.60                   17.08% 1,597.36                     5,673.65                     (251.90)                                 (1,514.97)                   Operations 107,069.37                 519,007.97                 1,070,460.70             48.48% 108,790.74                 547,554.76                 (1,721.37)                              (28,546.79)                 Capital Outlay 0.00%‐                                          ‐                               Total 115,728.03                 548,722.43                 1,260,780.13             43.52% 119,670.21                 584,050.48                 (3,942.18)                              (35,328.05)                 Vehicle Maint. Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 16,539.49                   59,042.47                   234,480.77                 25.18% 16,863.96                   64,646.37                   (324.47)                                 (5,603.90)                   Benefits 13,656.60                   20,721.24                   47,139.49                   43.96% 2,647.19                     14,565.85                   11,009.41                             6,155.39                     Operations (6,237.12)                    15,706.42                   121,450.00                 12.93% 10,467.86                   41,003.38                   (16,704.98)                            (25,296.96)                 Capital Outlay 40,000.00                   0.00% 19,675.00                    ‐                                         (19,675.00)                 Total 23,958.97                   95,470.13                   443,070.26                 21.55% 29,979.01                   139,890.60                 (6,020.04)                              (44,420.47)                 City of Prattville January Unaudited Expenses By Department Engineering Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 32,313.19                   112,442.51                493,422.82                22.79% 35,786.58                   136,690.75                (3,473.39)                              (24,248.24)                 Benefits 25,841.79                   40,948.47                   105,148.38                38.94% 6,026.33                     30,937.33                   19,815.46                             10,011.14                  Operations 41,698.55                   135,473.89                543,300.00                24.94% 40,036.73                   159,737.93                1,661.82                               (24,264.04)                 Captial Projects 0.00%‐                                          ‐                              Capital Outlay 300,000.00                0.00% 140,331.00                 ‐                                         (140,331.00)               Total 99,853.53                   288,864.87                1,441,871.20             20.03% 81,849.64                   467,697.01                18,003.89                             (178,832.14)               Planning Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 19,552.63                   69,231.50                   269,868.43                25.65% 19,399.94                   74,153.06                   152.69                                  (4,921.56)                   Benefits 3,898.06                     13,327.42                   47,227.87                   28.22% 3,348.72                     14,301.13                   549.34                                  (973.71)                       Operations 41,494.30                   193,858.18                693,335.00                27.96% 5,583.02                     139,879.96                35,911.28                             53,978.22                  Captial Projects ‐                               0.00%‐                                          ‐                              Capital Outlay 27,839.00                   27,839.00                   27,839.00                   0.00% 27,839.00                             27,839.00                  Total 92,783.99                   304,256.10                1,038,270.30             29.30% 28,331.68                   228,334.15                64,452.31                             75,921.95                  Urban Management Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 59,992.58                   216,021.39                917,120.07                23.55% 56,925.48                   223,396.37                3,067.10                               (7,374.98)                   Benefits 36,351.49                   63,045.64                   166,388.70                37.89% 9,280.80                     47,827.55                   27,070.69                             15,218.09                  Operations 11,243.22                   93,335.32                   577,050.00                16.17% 23,656.39                   195,115.40                (12,413.17)                           (101,780.08)               Capital Outlay 315,000.00                0.00%‐                                          ‐                              Total 107,587.29                372,402.35                1,975,558.77             18.85% 89,862.67                   466,339.32                17,724.62                             (93,936.97)                 Facilities Maintenance Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 14,448.38                   49,209.74                   222,213.17                22.15% 15,513.33                   60,520.73                   (1,064.95)                              (11,310.99)                 Benefits 7,678.51                     13,434.07                   39,363.33                   34.13% 2,548.40                     12,141.13                   5,130.11                               1,292.94                     Operations 1,503.02                     15,258.09                   84,600.00                   18.04% 2,578.34                     21,835.22                   (1,075.32)                              (6,577.13)                   Capital Outlay 25,000.00                   0.00%‐                                          ‐                              Total 23,629.91                   77,901.90                   371,176.50                20.99% 20,640.07                   94,497.08                   2,989.84                               (16,595.18)                 Public Works Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 12,759.48                   44,677.86                   248,857.41                17.95% 11,625.50                   41,153.14                   1,133.98                               3,524.72                     Benefits 7,442.32                     13,373.94                   47,433.43                   28.20% 2,001.71                     8,186.85                     5,440.61                               5,187.09                     Operations 2,060.40                     24,118.41                   138,168.00                17.46% 1,412.29                     20,115.75                   648.11                                  4,002.66                     Capital Outlay 276,000.00                0.00%‐                                          ‐                              Total 22,262.20                   82,170.21                   710,458.84                11.57% 15,039.50                   69,455.74                   7,222.70                               12,714.47                  Police Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 365,922.30                1,304,958.23             4,929,053.84             26.47% 360,772.13                1,402,886.94             5,150.17                               (97,928.71)                 Benefits 208,808.96                373,065.28                957,845.57                38.95% 59,776.60                   299,145.37                149,032.36                          73,919.91                  Operations 160,661.44                528,575.77                1,264,063.80             41.82% 49,195.93                   513,670.19                111,465.51                          14,905.58                  Capital Outlay ‐                               167,034.00                167,034.00                100.00% 78,603.00                   288,211.00                (78,603.00)                           (121,177.00)               Total 735,392.70                2,373,633.28             7,317,997.21             32.44% 548,347.66                2,503,913.50             187,045.04                          (130,280.22)               Fire Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 362,726.42                1,275,658.96             4,434,714.57             28.77% 354,909.57                1,369,006.77             7,816.85                               (93,347.81)                 Benefits 248,388.79                412,076.06                927,705.85                44.42% 59,845.57                   313,937.73                188,543.22                          98,138.33                  Operations 53,720.27                   305,417.23                1,050,345.96             29.08% 73,611.04                   436,650.30                (19,890.77)                           (131,233.07)               Capital Outlay 33,515.00                   760,420.00                789,905.00                96.27% 33,515.00                             760,420.00                Total 698,350.48                2,753,572.25             7,202,671.38             38.23% 488,366.18                2,119,594.80             209,984.30                          633,977.45                Building Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 22,108.80                   78,660.60                   284,584.67                27.64% 21,613.63                   82,960.49                   495.17                                  (4,299.89)                   Benefits 8,640.65                     18,889.74                   54,088.11                   34.92% 3,626.47                     16,680.31                   5,014.18                               2,209.43                     Operations 838.37                        12,007.52                   61,470.00                   19.53% 527.46                        16,578.81                   310.91                                  (4,571.29)                   Capital Outlay 40,000.00                   0.00%‐                                ‐                                          ‐                              Total 31,587.82                   109,557.86                440,142.78                24.89% 25,767.56                   116,219.61                5,820.26                               (6,661.75)                   Parks & Recreation Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 42,207.62                   154,800.86                668,495.70                23.16% 38,766.92                   147,958.13                3,440.70                               6,842.73                     Benefits 29,190.97                   47,231.29                   114,243.26                41.34% 6,176.24                     32,566.72                   23,014.73                             14,664.57                  Operations 43,551.51                   185,523.60                1,069,712.07             17.34% 22,292.48                   244,128.63                21,259.03                             (58,605.03)                 Capital Outlay 282,070.90                0.00% 37,350.00                   37,350.00                   (37,350.00)                           (37,350.00)                 Total 114,950.10                387,555.75                2,134,521.93             18.16% 104,585.64                462,003.48                10,364.46                             (74,447.73)                 Performing Arts Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 4,778.64                     16,203.39                   65,503.04                   24.74% 3,997.83                     14,154.52                   780.81                                  2,048.87                     Benefits 898.69                        2,665.83                     8,835.94                     30.17% 551.91                        2,249.77                     346.78                                  416.06                        Operations 3,274.60                     27,182.88                   191,310.00                14.21% 5,430.12                     43,421.37                   (2,155.52)                              (16,238.49)                 Capital Outlay ‐                                          ‐                              Total 8,951.93                     46,052.10                   265,648.98                17.34% 9,979.86                     59,825.66                   (1,027.93)                              (13,773.56)                 Non‐Departmental Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference City ‐ County Svcs 84,166.67                   198,333.35                410,000.00                48.37% 81,666.67                   203,333.35                2,500.00                               (5,000.00)                   Community Initiatives 41,595.29                   242,402.38                879,278.85                27.57% 128,723.72                259,264.37                (87,128.43)                           (16,861.99)                 Transfer to Group Health 207,168.75                828,675.00                2,486,025.00             33.33% 186,647.50                746,590.00                20,521.25                             82,085.00                  Transfer to Capital Project Fund 21,268.66                   21,268.66                    ‐                               100.00%‐                                ‐                               21,268.66                             21,268.66                  Transfer to Judicial ‐                                ‐                                ‐                               0.00%‐                                          ‐                              Total 354,199.37                1,290,679.39             3,775,303.85             34.19% 397,037.89                1,209,187.72             (42,838.52)                           81,491.67                  Debt Service Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Debt Service ‐                               1,449,550.13             4,940,537.10             29.34% 98,623.39                   2,243,163.60             (98,623.39)                           (793,613.47)               Total ‐                               1,449,550.13             4,940,537.10             29.34% 98,623.39                   2,243,163.60             (98,623.39)                           (793,613.47)               Total Jan‐17 YTD Budget % of Budget Jan‐16 YTD January Difference YTD Difference Salary 1,033,717.96             3,660,502.32             13,906,163.41           26.32% 1,019,319.59             3,930,438.82             14,398.37                             (269,936.50)               Benefits 810,831.43                1,889,730.41             5,168,641.62             36.56% 354,604.31                1,589,210.31             456,227.12                          300,520.10                Operations 622,613.54                2,673,474.10             8,716,855.38             31% 562,827.03                3,007,905.31             59,786.51                             (334,431.21)               Capital Outlay 89,193.00                   983,132.00                2,290,687.90             43% 115,953.00                485,567.00                (26,760.00)                           497,565.00                Debt Service ‐                               1,449,550.13             4,940,537.10             29% 98,623.39                   2,243,163.60             (98,623.39)                           (793,613.47)               Total 2,556,355.93             10,656,388.96           35,022,885.41           30.43% 2,151,327.32             11,256,285.04           405,028.61                          (599,896.08)               Prepared by___________________Daniel Oakley