Loading...
April 2017 - Council Expense InformationAs of  5/12/2017 58.33 % Year Complete Executive Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 15,040.34                   106,722.61                 188,224.01                 56.70% 21,634.14                   105,693.41                 (6,593.80)                              1,029.20                     Benefits 1,769.02                     13,290.81                   23,124.37                   57.48% 2,618.96                     13,705.91                   (849.94)                                 (415.10)                       Operations 2,259.05                     71,400.57                   115,841.00                 61.64% 1,674.61                     43,798.46                   584.44                                   27,602.11                   Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 19,068.41                   191,413.99                 327,189.38                 58.50% 25,927.71                   163,197.78                 (6,859.30)                              28,216.21                   Legislative Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 11,411.79                   73,925.70                   125,000.00                 59.14% 10,417.04                   72,919.28                   994.75                                   1,006.42                     Benefits 833.15                         5,774.28                     10,391.50                   55.57% 733.22                         5,739.58                     99.93                                     34.70                          Operations 22.70                           4,139.41                     26,250.00                   15.77% 425.00                         2,629.22                     (402.30)                                 1,510.19                     Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 12,267.64                   83,839.39                   161,641.50                 51.87% 11,575.26                   81,288.08                   692.38                                   2,551.31                     Finance Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 21,875.85                   151,186.37                 303,798.29                 49.77% 34,436.30                   168,500.85                 (12,560.45)                            (17,314.48)                 Benefits 3,420.73                     24,512.56                   51,498.48                   47.60% 5,760.91                     30,606.18                   (2,340.18)                              (6,093.62)                   Operations 4,674.48                     158,232.83                 235,620.00                 67.16% 111,557.14                 256,906.27                 (106,882.66)                          (98,673.44)                 Capital Outlay ‐                               28,466.20                   27,839.00                   102.25%‐                                         28,466.20                   Total 29,971.06                   362,397.96                 618,755.77                 58.57% 151,754.35                 456,013.30                 (121,783.29)                          (93,615.34)                 City Clerk Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 9,660.07                     68,407.25                   125,523.26                 54.50% 13,302.87                   67,012.76                   (3,642.80)                              1,394.49                     Benefits 1,414.98                     10,743.96                   19,803.25                   54.25% 2,091.27                     11,235.60                   (676.29)                                 (491.64)                       Operations 4,955.80                     35,604.02                   88,000.00                   40.46% 489.71                         25,187.98                   4,466.09                               10,416.04                   Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 16,030.85                   114,755.23                 233,326.51                 49.18% 15,883.85                   103,436.34                 147.00                                   11,318.89                   HR Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 16,491.10                   119,778.95                 229,327.53                 52.23% 24,116.41                   118,090.86                 (7,625.31)                              1,688.09                     Benefits 2,637.99                     20,417.65                   38,035.49                   53.68% 4,024.26                     21,228.49                   (1,386.27)                              (810.84)                       Operations 5,530.10                     20,106.95                   96,600.00                   20.81% 2,052.02                     29,061.79                   3,478.08                               (8,954.84)                   Capital Outlay ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 24,659.19                   160,303.55                 363,963.02                 44.04% 30,192.69                   168,381.14                 (5,533.50)                              (8,077.59)                   IT Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 10,287.39                   58,866.47                   165,975.83                 35.47% 10,554.39                   74,923.26                   (267.00)                                 (16,056.79)                 Benefits 1,457.71                     8,858.85                     24,343.60                   36.39% 1,598.60                     11,771.14                   (140.89)                                 (2,912.29)                   Operations 85,767.64                   778,615.97                 1,070,460.70             72.74% 49,764.70                   785,956.66                 36,002.94                             (7,340.69)                   Capital Outlay 0.00%‐                                          ‐                               Total 97,512.74                   846,341.29                 1,260,780.13             67.13% 61,917.69                   872,651.06                 35,595.05                             (26,309.77)                 Vehicle Maint. Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 18,675.97                   124,015.95                 234,480.77                 52.89% 25,432.80                   122,651.12                 (6,756.83)                              1,364.83                     Benefits 2,761.78                     34,463.26                   47,139.49                   73.11% 3,993.61                     36,430.00                   (1,231.83)                              (1,966.74)                   Operations (524.08)                       32,210.44                   117,966.00                 27.30% (6,673.06)                    60,301.60                   6,148.98                               (28,091.16)                 Capital Outlay 40,000.00                   0.00%‐                                          ‐                               Total 20,913.67                   190,689.65                 439,586.26                 43.38% 22,753.35                   219,382.72                 (1,839.68)                              (28,693.07)                 City of Prattville April Unaudited Expenses By Department Engineering Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 30,760.05                   242,224.66                493,422.82                49.09% 55,579.37                   265,098.44                (24,819.32)                           (22,873.78)                 Benefits 5,077.51                     68,048.95                   105,148.38                64.72% 9,266.02                     73,856.62                   (4,188.51)                              (5,807.67)                   Operations 12,783.64                   144,641.86                543,300.00                26.62% 28,783.04                   198,180.30                (15,999.40)                           (53,538.44)                 Captial Projects 0.00%‐                                          ‐                              Capital Outlay ‐                               237,520.76                300,000.00                79.17% 86,526.00                    ‐                                         150,994.76                Total 48,621.20                   692,436.23                1,441,871.20             48.02% 93,628.43                   623,661.36                (45,007.23)                           68,774.87                  Planning Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 20,176.26                   143,608.53                269,868.43                53.21% 29,229.54                   142,362.18                (9,053.28)                              1,246.35                     Benefits 3,399.93                     25,663.98                   47,227.87                   54.34% 5,070.51                     26,799.11                   (1,670.58)                              (1,135.13)                   Operations 6,314.18                     286,710.95                693,335.00                41.35% 23,340.35                   138,489.75                (17,026.17)                           148,221.20                Captial Projects ‐                               0.00%‐                                          ‐                              Capital Outlay ‐                               27,839.00                   27,839.00                   100.00%‐                                         27,839.00                  Total 29,890.37                   483,822.46                1,038,270.30             46.60% 57,640.40                   307,651.04                (27,750.03)                           176,171.42                Urban Management Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 60,234.43                   443,094.20                917,120.07                48.31% 96,757.20                   438,711.48                (36,522.77)                           4,382.72                     Benefits 9,250.37                     107,122.66                166,388.70                64.38% 15,337.93                   113,244.25                (6,087.56)                              (6,121.59)                   Operations 26,199.33                   153,466.83                577,050.00                26.60% 11,872.79                   261,030.24                14,326.54                             (107,563.41)               Capital Outlay ‐                               315,000.00                0.00% 61,993.60                   230,239.03                (61,993.60)                           (230,239.03)               Total 95,684.13                   703,683.69                1,975,558.77             35.62% 185,961.52                1,043,225.00             (90,277.39)                           (339,541.31)               Facilities Maintenance Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 14,527.62                   103,859.74                222,213.17                46.74% 17,875.72                   121,781.19                (3,348.10)                              (17,921.45)                 Benefits 2,130.43                     23,363.88                   39,363.33                   59.35% 2,861.85                     26,476.38                   (731.42)                                 (3,112.50)                   Operations 3,812.34                     26,922.41                   84,600.00                   31.82% 1,077.03                     27,276.38                   2,735.31                               (353.97)                       Capital Outlay 25,000.00                   0.00%‐                                          ‐                              Total 20,470.39                   154,146.03                371,176.50                41.53% 21,814.60                   175,533.95                (1,344.21)                              (21,387.92)                 Public Works Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 12,832.57                   92,725.76                   248,857.41                37.26% 19,044.47                   85,452.47                   (6,211.90)                              7,273.29                     Benefits 2,127.41                     21,622.26                   47,434.00                   45.58% 3,274.01                     17,331.50                   (1,146.60)                              4,290.76                     Operations 2,932.63                     35,154.61                   102,396.00                34.33% 3,574.76                     31,472.34                   (642.13)                                 3,682.27                     Capital Outlay 8,185.00                     8,185.00                     315,256.00                2.60% 8,185.00                               8,185.00                     Total 26,077.61                   157,687.63                713,943.41                22.09% 25,893.24                   134,256.31                184.37                                  23,431.32                  Police Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 352,490.31                2,648,344.01             4,929,053.84             53.73% 522,198.01                2,632,276.21             (169,707.70)                         16,067.80                  Benefits 55,689.63                   634,791.08                957,845.00                66.27% 86,516.69                   665,576.37                (30,827.06)                           (30,785.29)                 Operations 78,573.66                   770,931.61                1,254,650.00             61.45% 56,917.13                   740,529.62                21,656.53                             30,401.99                  Capital Outlay ‐                               166,864.00                167,034.00                99.90% 289,237.00                 ‐                                         (122,373.00)               Total 486,753.60                4,220,930.70             7,308,582.84             57.75% 665,631.83                4,327,619.20             (178,878.23)                         (106,688.50)               Fire Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 341,717.46                2,538,184.56             4,434,714.57             57.23% 527,709.45                2,592,592.53             (185,991.99)                         (54,407.97)                 Benefits 55,684.46                   686,294.08                927,705.85                73.98% 89,854.34                   737,656.84                (34,169.88)                           (51,362.76)                 Operations 64,864.40                   493,966.72                1,050,345.96             47.03% 54,737.81                   621,460.87                10,126.59                             (127,494.15)               Capital Outlay 5,276.71                     719,416.57                789,905.00                91.08% 1,649.07                     5,276.71                               717,767.50                Total 467,543.03                4,437,861.93             7,202,671.38             61.61% 672,301.60                3,953,359.31             (204,758.57)                         484,502.62                Building Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 22,163.20                   161,567.72                284,584.67                56.77% 32,532.78                   158,561.67                (10,369.58)                           3,006.05                     Benefits 3,573.20                     33,783.62                   54,088.11                   62.46% 5,489.66                     35,066.49                   (1,916.46)                              (1,282.87)                   Operations 5,641.30                     23,030.34                   57,134.00                   40.31% 516.04                        21,248.57                   5,125.26                               1,781.77                     Capital Outlay 40,000.00                   40,000.00                   44,336.00                   90.22% 27,568.00                   1,552.00                     12,432.00                             38,448.00                  Total 71,377.70                   258,381.68                440,142.78                58.70% 66,106.48                   216,428.73                5,271.22                               41,952.95                  Parks & Recreation Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 45,150.89                   336,022.85                668,496.00                50.27% 64,969.75                   297,619.79                (19,818.86)                           38,403.06                  Benefits 6,379.22                     79,258.08                   114,243.00                69.38% 9,899.89                     79,052.85                   (3,520.67)                              205.23                        Operations 26,581.10                   322,860.56                1,069,712.00             30.18% 40,959.67                   431,996.90                (14,378.57)                           (109,136.34)               Capital Outlay/ Capital Projects ‐                               32,436.00                   328,691.00                9.87% 36,673.23                    ‐                                         (4,237.23)                   Total 78,111.21                   770,577.49                2,181,142.00             35.33% 115,829.31                845,342.77                (37,718.10)                           (74,765.28)                 Performing Arts Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 5,050.60                     34,526.33                   65,503.04                   52.71% 6,288.41                     28,853.61                   (1,237.81)                              5,672.72                     Benefits 731.20                        5,294.66                     8,835.94                     59.92% 854.08                        4,371.52                     (122.88)                                 923.14                        Operations 21,058.57                   60,131.80                   191,310.00                31.43% 7,015.77                     69,272.17                   14,042.80                             (9,140.37)                   Capital Outlay ‐                                          ‐                              Total 26,840.37                   99,952.79                   265,648.98                37.63% 14,158.26                   102,497.30                12,682.11                             (2,544.51)                   Non‐Departmental Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference City ‐ County Svcs 84,166.67                   295,833.36                410,000.00                72.15% 6,568.73                     298,268.38                77,597.94                             (2,435.02)                   Community Initiatives 35,938.91                   398,733.76                871,659.00                45.74% 43,901.69                   666,935.91                (7,962.78)                              (268,202.15)               Transfer to Group Health 207,168.75                1,450,181.25             2,486,025.00             58.33% 162,906.32                1,306,532.50             44,262.43                             143,648.75                Transfer to Capital Project Fund 190,031.51                225,940.51                 ‐                               100.00% 190,031.51                          225,940.51                Transfer to Judicial ‐                                ‐                               7,067.00                     0.00%‐                                          ‐                              Total 517,305.84                2,370,688.88             3,774,751.00             62.80% 213,376.74                2,271,736.79             303,929.10                          98,952.09                  Debt Service Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Debt Service 210,493.99                2,555,896.18             4,940,537.10             51.73% 13,333.33                   2,986,818.26             197,160.66                          (430,922.08)               Total 210,493.99                2,555,896.18             4,940,537.10             51.73% 13,333.33                   2,986,818.26             197,160.66                          (430,922.08)               Total Apr‐17 YTD Budget % of Budget Apr‐16 YTD April Difference YTD Difference Salary 1,008,545.90             7,447,061.66             13,906,163.71           53.55% 1,512,078.65             7,493,101.11             (503,532.75)                         (46,039.45)                 Benefits 365,507.47                3,253,485.87             5,168,641.36             62.95% 412,152.13                3,216,681.33             (46,644.66)                           36,804.54                  Operations 661,583.93                4,338,635.51             8,663,296.66             50.08% 438,554.93                4,710,003.41             223,029.00                          (371,367.90)               Capital Outlay 53,461.71                   1,260,727.53             2,380,900.00             52.95% 89,561.60                   645,876.33                (36,099.89)                           614,851.20                Debt Service 210,493.99                2,555,896.18             4,940,537.10             51.73% 13,333.33                   2,986,818.26             197,160.66                          (430,922.08)               Total 2,299,593.00             18,855,806.75           35,059,538.83           53.78% 2,465,680.64             19,052,480.44           (166,087.64)                         (196,673.69)               Prepared by     Daniel Oakley