Loading...
November 2016 - Council Expense InformationAs of  12/15/2016 16.67 % Year Complete Executive Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 14,484.60          21,726.62          188,224.01          11.54% 14,355.51         26,541.30            129.09                                  (4,814.68)                   Benefits 1,692.68             2,995.96             23,124.37            12.96% 1,710.20           3,846.70              (17.52)                                   (850.74)                       Operations 18,565.78          24,313.57          115,841.00          20.99% 14,447.62         27,543.49            4,118.16                               (3,229.92)                   Capital Outlay ‐                       ‐                       ‐                         ‐                   ‐                      ‐                         ‐                                          ‐                              Total 34,743.06          49,036.15          327,189.38          14.99% 30,513.33         57,931.49            4,229.73                               (8,895.34)                   Legislative Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 11,263.35          21,680.39          125,000.00          17.34% 10,417.04         20,834.08            846.31                                  846.31                        Benefits 824.08                1,528.95             10,391.50            14.71% 689.44               1,677.26              134.64                                  (148.31)                       Operations 1,585.11             1,585.11             26,250.00            6.04% 1,598.80           2,204.22              (13.69)                                   (619.11)                       Capital Outlay ‐                       ‐                       ‐                         ‐                   ‐                      ‐                         ‐                                          ‐                              Total 13,672.54          24,794.45          161,641.50          15.34% 12,705.28         24,715.56            967.26                                  78.89                          Finance Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 20,021.19          28,412.16          303,798.29          9.35% 23,042.33         42,489.29            (3,021.14)                              (14,077.13)                 Benefits 3,075.08             4,933.71             51,498.48            9.58% 3,844.15           8,825.13              (769.07)                                 (3,891.42)                   Operations 19,951.10          32,902.13          235,620.00          13.96% 4,110.61           19,381.07            15,840.49                             13,521.06                  Capital Outlay 27,839.00            0.00%‐                                          ‐                              Total 43,047.37          66,248.00          618,755.77          10.71% 30,997.09         70,695.49            12,050.28                             (4,447.49)                   City Clerk Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 9,636.33             13,458.00          125,523.26          10.72% 9,409.35           15,778.13            226.98                                  (2,320.13)                   Benefits 1,416.57             2,429.35             19,803.25            12.27% 1,394.08           3,143.14              22.49                                     (713.79)                       Operations 3,922.58             18,064.45          88,000.00            20.53% 778.80               3,976.29              3,143.78                               14,088.16                  Capital Outlay ‐                       ‐                       ‐                        0.00%‐                      ‐                         ‐                                          ‐                              Total 14,975.48          33,951.80          233,326.51          14.55% 11,582.23         22,897.56            3,393.25                               11,054.24                  HR Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 16,070.28          24,427.29          229,327.53          10.65% 15,922.20         29,354.86            148.08                                  (4,927.57)                   Benefits 2,730.65             4,778.38             38,035.49            12.56% 2,611.51           6,055.57              119.14                                  (1,277.19)                   Operations 2,624.61             2,624.61             96,600.00            2.72% 3,760.30           14,774.53            (1,135.69)                              (12,149.92)                 Capital Outlay ‐                        0.00%‐                      ‐                         ‐                                          ‐                              Total 21,425.54          31,830.28          363,963.02          8.75% 22,294.01         50,184.96            (868.47)                                 (18,354.68)                 IT Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 7,291.64             10,937.46          165,975.83          6.59% 7,557.88           13,982.08            (266.24)                                 (3,044.62)                   Benefits 1,024.76             1,778.27             24,343.60            7.30% 1,217.52           2,833.17              (192.76)                                 (1,054.90)                   Operations 111,746.15        196,495.35        1,070,460.70      18.36% 120,257.76       210,353.76         (8,511.61)                              (13,858.41)                 Capital Outlay 0.00%‐                                          ‐                              Total 120,062.55        209,211.08        1,260,780.13      16.59% 129,033.16       227,169.01         (8,970.61)                              (17,957.93)                 Vehicle Maint. Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 17,137.27          25,728.03          234,480.77          10.97% 16,959.27         31,378.20            178.00                                  (5,650.17)                   Benefits 2,554.40             4,523.07             47,139.49            9.60% 2,622.03           9,345.96              (67.63)                                   (4,822.89)                   Operations 27,709.28          28,294.11          121,450.00          23.30% 1,926.49           18,595.49            25,782.79                             9,698.62                     Capital Outlay 40,000.00            0.00%‐                     19,675.00             ‐                                         (19,675.00)                 Total 47,400.95          58,545.21          443,070.26          13.21% 21,507.79         78,994.65            25,893.16                             (20,449.44)                 City of Prattville November Unaudited Expenses By Department Engineering Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 32,002.44          48,126.79          493,422.82          9.75% 35,585.44         65,591.82            (3,583.00)                              (17,465.03)                 Benefits 5,338.15             9,609.38             105,148.38          9.14% 5,864.82           18,983.62            (526.67)                                 (9,374.24)                   Operations 49,619.29          55,656.55          543,300.00          10.24% 14,343.23         91,225.49            35,276.06                             (35,568.94)                 Captial Projects 0.00%‐                                          ‐                              Capital Outlay 300,000.00          0.00%‐                                          ‐                              Total 86,959.88          113,392.72        1,441,871.20      7.86% 55,793.49         175,800.93         31,166.39                             (62,408.21)                 Planning Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 20,243.49          30,063.50          269,868.43          11.14% 19,412.09         35,242.01            831.40                                  (5,178.51)                   Benefits 3,411.80             6,049.45             47,227.87            12.81% 3,332.08           7,556.65              79.72                                     (1,507.20)                   Operations 58,735.79          86,798.82          693,335.00          12.52% 7,924.58           44,626.86            50,811.21                             42,171.96                  Captial Projects ‐                        0.00%‐                                          ‐                              Capital Outlay 27,839.00            0.00%‐                                          ‐                              Total 82,391.08          122,911.77        1,038,270.30      11.84% 30,668.75         87,425.52            51,722.33                             35,486.25                  Urban Management Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 63,656.29          95,867.02          917,120.07          10.45% 57,988.46         107,115.29         5,667.83                               (11,248.27)                 Benefits 9,754.44             17,443.70          166,388.70          10.48% 9,358.21           28,981.95            396.23                                  (11,538.25)                 Operations 50,689.51          57,892.98          577,050.00          10.03% 33,864.17         135,828.22         16,825.34                             (77,935.24)                 Capital Outlay 315,000.00          0.00%‐                                          ‐                              Total 124,100.24        171,203.70        1,975,558.77      8.67% 101,210.84       271,925.46         22,889.40                             (100,721.76)               Facilities Maintenance Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 12,948.45          19,970.84          222,213.17          8.99% 15,592.41         28,889.64            (2,643.96)                              (8,918.80)                   Benefits 1,893.72             3,504.46             39,363.33            8.90% 2,537.02           6,968.06              (643.30)                                 (3,463.60)                   Operations 6,755.15             7,062.13             84,600.00            8.35% 1,677.58           12,977.38            5,077.57                               (5,915.25)                   Capital Outlay 25,000.00            0.00%‐                                          ‐                              Total 21,597.32          30,537.43          371,176.50          8.23% 19,807.01         48,835.08            1,790.31                               (18,297.65)                 Public Works Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 12,775.12          19,101.06          248,857.41          7.68% 10,461.14         19,083.88            2,313.98                               17.18                          Benefits 2,123.75             3,781.47             47,433.43            7.97% 1,779.64           4,389.95              344.11                                  (608.48)                       Operations 10,296.25          10,948.93          138,168.00          7.92% 1,561.64           16,369.05            8,734.61                               (5,420.12)                   Capital Outlay 276,000.00          0.00%‐                                          ‐                              Total 25,195.12          33,831.46          710,458.84          4.76% 13,802.42         39,842.88            11,392.70                             (6,011.42)                   Police Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 361,585.26        557,304.61        4,929,053.84      11.31% 349,696.84       641,281.38         11,888.42                             (83,976.77)                 Benefits 57,366.93          102,311.37        957,845.57          10.68% 57,440.94         172,675.59         (74.01)                                   (70,364.22)                 Operations 205,402.16        286,841.52        1,264,063.80      22.69% 103,915.96       291,537.35         101,486.20                           (4,695.83)                   Capital Outlay 139,362.81        139,362.81        139,195.00          100.12% 139,362.81                           139,362.81                Total 763,717.16        1,085,820.31     7,290,158.21      14.89% 511,053.74       1,105,494.32      252,663.42                           (19,674.01)                 Fire Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 348,102.07        524,683.21        4,434,714.57      11.83% 361,344.53       655,082.06         (13,242.46)                           (130,398.85)               Benefits 56,963.77          99,983.15          927,705.85          10.78% 61,012.20         193,262.24         (4,048.43)                              (93,279.09)                 Operations 145,848.74        177,272.21        1,050,345.96      16.88% 55,298.52         230,473.59         90,550.22                             (53,201.38)                 Capital Outlay 726,905.00        726,905.00        787,905.00          92.26% 726,905.00                           726,905.00                Total 1,277,819.58     1,528,843.57     7,200,671.38      21.23% 477,655.25       1,078,817.89      800,164.33                           450,025.68                Building Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 22,484.14          34,419.12          284,584.67          12.09% 21,425.40         39,867.06            1,058.74                               (5,447.94)                   Benefits 3,655.83             6,605.93             54,088.11            12.21% 3,572.94           9,448.51              82.89                                     (2,842.58)                   Operations 9,186.53             9,624.18             61,470.00            15.66% 3,619.88           13,684.91            5,566.65                               (4,060.73)                   Capital Outlay 40,000.00            0.00%‐                      ‐                                          ‐                              Total 35,326.50          50,649.23          440,142.78          11.51% 28,618.22         63,000.48            6,708.28                               (12,351.25)                 Parks & Recreation Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 45,709.64          68,508.18          668,495.70          10.25% 38,102.73         71,951.24            7,606.91                               (3,443.06)                   Benefits 6,640.83             11,531.53          114,243.26          10.09% 5,930.72           20,464.15            710.11                                  (8,932.62)                   Operations 85,170.30          114,942.87        1,069,712.07      10.75% 18,371.63         148,233.10         66,798.67                             (33,290.23)                 Capital Outlay 282,070.90          0.00%‐                                          ‐                              Total 137,520.77        194,982.58        2,134,521.93      9.13% 62,405.08         240,648.49         75,115.69                             (45,665.91)                 Performing Arts Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 4,411.14             6,643.66             65,503.04            10.14% 3,331.43           6,006.96              1,079.71                               636.70                        Benefits 637.36                1,069.59             8,835.94              12.10% 497.53               1,137.44              139.83                                  (67.85)                         Operations 8,378.00             9,411.01             191,310.00          4.92% 13,812.79         25,428.24            (5,434.79)                              (16,017.23)                 Capital Outlay ‐                                          ‐                              Total 13,426.50          17,124.26          265,648.98          6.45% 17,641.75         32,572.64            (4,215.25)                              (15,448.38)                 Non‐Departmental Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference City ‐ County Svcs 100,833.34        107,500.01        410,000.00          26.22% 13,333.34         105,000.01         87,500.00                             2,500.00                     Community Initiatives 52,258.17          79,926.15          879,278.85          9.09% 69,216.53         111,790.65         (16,958.36)                           (31,864.50)                 Transfer to Group Health 207,168.75        414,337.50        2,486,025.00      16.67% 186,647.50       373,295.00         20,521.25                             41,042.50                  Transfer to Judicial ‐                        0.00% Total 360,260.26        601,763.66        3,775,303.85      15.94% 269,197.37       590,085.66         91,062.89                             11,678.00                  Debt Service Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Debt Service 87,643.30          1,449,550.13     4,940,537.10      29.34% 1,988,268.92    1,988,263.64      (1,900,625.62)                      (538,713.51)               Total 87,643.30          1,449,550.13     4,940,537.10      29.34% 1,988,268.92    1,988,263.64      (1,900,625.62)                      (538,713.51)               Total Nov‐16 YTD Budget % of Budget Nov‐15 YTD November Difference YTD Difference Salary 1,019,822.70     1,551,057.94     13,906,163.41    11.15% 1,010,604.05    1,850,469.28      9,218.65                               (299,411.34)               Benefits 368,273.55        699,195.22        5,168,641.62      13.53% 352,062.53       872,890.09         16,211.02                             (173,694.87)               Operations 969,277.84        1,308,156.69     8,716,855.38      15% 483,820.23       1,524,003.70      485,457.61                           (215,847.01)               Capital Outlay 866,267.81        866,267.81        2,260,848.90      38%‐                     19,675.00            866,267.81                           846,592.81                Debt Service 87,643.30          1,449,550.13     4,940,537.10      29% 1,988,268.92    1,988,263.64      (1,900,625.62)                      (538,713.51)               Total 3,311,285.20     5,874,227.79     34,993,046.41    16.79% 3,834,755.73    6,255,301.71      (523,470.53)                         (381,073.92)               Prepared by_______________Daniel Oakley