Loading...
September 2017 - Council Expense InformationAs of  10/13/2017 100.00 % Year Complete Executive Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 21,035.50                   196,874.34                 192,853.00                 102.09% 21,755.63                   185,455.98                 (720.13)                                 11,418.36                   Benefits 2,375.10                     23,036.36                   23,798.00                   96.80% 2,283.13                     23,283.22                   91.97                                     (246.86)                       Operations 1,260.08                     92,599.64                   99,698.00                   92.88% 1,301.69                     50,823.85                   (41.61)                                    41,775.79                   Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 24,670.68                   312,510.34                 316,349.00                 98.79% 25,340.45                   259,563.05                 (669.77)                                 52,947.29                   Legislative Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 10,417.04                   126,010.90                 125,000.00                 100.81% 10,417.04                   125,004.48                  ‐                                         1,006.42                     Benefits 716.25                         9,407.65                     10,391.50                   90.53% 685.62                         9,368.11                     30.63                                     39.54                          Operations 460.00                         8,105.25                     26,250.00                   30.88% 252.05                         460.00                                   7,853.20                     Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 11,593.29                   143,523.80                 161,641.50                 88.79% 11,102.66                   134,624.64                 490.63                                   8,899.16                     Finance Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 32,797.07                   276,228.98                 303,798.29                 90.93% 31,389.10                   292,346.14                 1,407.97                               (16,117.16)                 Benefits 5,142.29                     43,473.69                   51,498.48                   84.42% 4,096.21                     51,232.98                   1,046.08                               (7,759.29)                   Operations 6,829.44                     226,259.38                 235,620.00                 96.03% 238,019.10                 6,829.44                               (11,759.72)                 Capital Outlay ‐                               28,466.20                   27,839.00                   102.25% 29,800.85                   29,800.85                   (29,800.85)                            (1,334.65)                   Total 44,768.80                   574,428.25                 618,755.77                 92.84% 65,286.16                   611,399.07                 (20,517.36)                            (36,970.82)                 City Clerk Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 13,608.58                   123,525.12                 125,523.26                 98.41% 13,380.48                   118,423.12                 228.10                                   5,102.00                     Benefits 2,078.43                     18,588.41                   19,803.25                   93.87% 1,710.14                     19,030.04                   368.29                                   (441.63)                       Operations 2,886.43                     45,931.64                   90,967.00                   50.49% 5,303.31                     96,328.37                   (2,416.88)                              (50,396.73)                 Capital Outlay ‐                                ‐                               11,693.00                   0.00%‐                                ‐                                ‐                                          ‐                               Total 18,573.44                   188,045.17                 247,986.51                 75.83% 20,393.93                   233,781.53                 (1,820.49)                              (45,736.36)                 HR Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 24,932.69                   215,980.98                 216,591.53                 99.72% 23,876.00                   207,395.75                 1,056.69                               8,585.23                     Benefits 4,021.52                     35,264.31                   103,920.49                 33.93% 3,225.18                     35,889.60                   796.34                                   (625.29)                       Operations 19,369.52                   77,452.69                   119,351.00                 64.89% 9,098.24                     54,869.99                   10,271.28                             22,582.70                   Capital Outlay ‐                               22,832.00                   0.00%‐                                          ‐                               Total 48,323.73                   328,697.98                 462,695.02                 71.04% 36,199.42                   298,155.34                 12,124.31                             30,542.64                   IT Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 18,751.15                   128,820.81                 165,976.00                 77.61% 10,554.39                   113,622.69                 8,196.76                               15,198.12                   Benefits 2,650.81                     18,517.97                   24,344.00                   76.07% 1,320.55                     17,584.23                   1,330.26                               933.74                        Operations 53,740.72                   1,191,584.06             1,054,414.00             113.01% 73,471.43                   1,139,631.21             (19,730.71)                            51,952.85                   Capital Outlay ‐                               16,045.76                   16,046.00                   100.00% 12,142.83                    ‐                                         3,902.93                     Total 75,142.68                   1,354,968.60             1,260,780.00             107.47% 85,346.37                   1,282,980.96             (10,203.69)                            71,987.64                   Vehicle Maint. Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 27,662.04                   216,261.12                 234,480.77                 92.23% 25,241.95                   216,205.67                 2,420.09                               55.45                          Benefits 4,121.99                     46,298.12                   47,139.49                   98.22% 3,238.79                     51,400.53                   883.20                                   (5,102.41)                   Operations 4,168.15                     74,738.03                   117,966.00                 63.36% 7,068.14                     87,354.35                   (2,899.99)                              (12,616.32)                 Capital Outlay ‐                               22,923.99                   40,000.00                   57.31% 19,675.00                    ‐                                         3,248.99                     Total 35,952.18                   360,221.26                 439,586.26                 81.95% 35,548.88                   374,635.55                 403.30                                   (14,414.29)                 City of Prattville September Unaudited Expenses By Department Engineering Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 46,287.32                   420,304.00                493,422.82                85.18% 52,557.64                   473,528.37                (6,270.32)                              (53,224.37)                 Benefits 7,691.38                     90,287.84                   105,148.38                85.87% 7,083.30                     107,717.72                608.08                                  (17,429.88)                 Operations 11,897.07                   339,661.23                543,300.00                62.52% 50,645.72                   413,179.22                (38,748.65)                           (73,517.99)                 Captial Projects ‐                               0.00%‐                                          ‐                              Capital Outlay 3,250.00                     272,227.61                300,000.00                90.74% 108,874.15                3,250.00                               163,353.46                Total 69,125.77                   1,122,480.68             1,441,871.20             77.85% 110,286.66                1,103,299.46             (41,160.89)                           19,181.22                  Planning Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 28,798.53                   256,241.01                269,868.43                94.95% 30,798.76                   253,755.45                (2,000.23)                              2,485.56                     Benefits 4,752.44                     43,797.66                   47,227.87                   92.74% 4,282.13                     46,048.96                   470.31                                  (2,251.30)                   Operations 11,952.72                   397,226.32                685,816.00                57.92% 38,693.26                   447,209.77                (26,740.54)                           (49,983.45)                 Captial Projects ‐                                ‐                               0.00%‐                                          ‐                              Capital Outlay ‐                               27,839.00                   35,358.00                   78.73%‐                                         27,839.00                  Total 45,503.69                   725,103.99                1,038,270.30             69.84% 73,774.15                   747,014.18                (28,270.46)                           (21,910.19)                 Urban Management Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 98,784.49                   837,040.06                917,120.07                91.27% 103,237.06                841,029.91                (4,452.57)                              (3,989.85)                   Benefits 14,585.56                   154,740.36                166,388.70                93.00% 13,083.61                   173,389.29                1,501.95                               (18,648.93)                 Operations 26,286.76                   329,218.56                577,050.00                57.05% 30,566.90                   424,217.98                (4,280.14)                              (94,999.42)                 Capital Outlay 30,751.50                   39,149.02                   315,000.00                12.43% 13,460.02                   320,224.89                17,291.48                             (281,075.87)               Total 170,408.31                1,360,148.00             1,975,558.77             68.85% 160,347.59                1,758,862.07             10,060.72                             (398,714.07)               Facilities Maintenance Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 27,066.93                   194,259.57                227,251.00                85.48% 21,960.65                   198,703.77                5,106.28                               (4,444.20)                   Benefits 4,060.60                     35,113.43                   40,211.00                   87.32% 2,869.90                     38,880.20                   1,190.70                               (3,766.77)                   Operations 15,122.21                   63,679.03                   84,600.00                   75.27% 3,655.47                     63,464.90                   11,466.74                             214.13                        Capital Outlay ‐                               21,868.00                   193,358.00                11.31%‐                                         21,868.00                  Total 46,249.74                   314,920.03                545,420.00                57.74% 28,486.02                   301,048.87                17,763.72                             13,871.16                  Public Works Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 25,696.01                   188,008.93                239,548.41                78.48% 18,924.96                   154,887.77                6,771.05                               33,121.16                  Benefits 4,102.65                     36,347.08                   47,434.00                   76.63% 2,615.60                     29,171.81                   1,487.05                               7,175.27                     Operations 6,837.62                     71,814.89                   111,705.00                64.29% 3,364.53                     53,936.94                   3,473.09                               17,877.95                  Capital Outlay 30,751.50                   271,000.50                315,256.00                85.96% 30,751.50                             271,000.50                Total 67,387.78                   567,171.40                713,943.41                79.44% 24,905.09                   237,996.52                42,482.69                             329,174.88                Police Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 568,247.05                4,710,683.20             4,929,053.84             95.57% 540,085.65                4,597,535.87             28,161.40                             113,147.33                Benefits 89,812.32                   906,417.45                957,845.00                94.63% 71,929.86                   994,963.92                17,882.46                             (88,546.47)                 Operations 71,359.76                   1,149,099.38             1,183,977.00             97.05% 69,244.61                   1,126,748.52             2,115.15                               22,350.86                  Capital Outlay 70,673.00                   237,707.00                298,826.00                79.55% 21,184.52                   760,597.52                49,488.48                             (522,890.52)               Total 800,092.13                7,003,907.03             7,369,701.84             95.04% 702,444.64                7,479,845.83             97,647.49                             (475,938.80)               Fire Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 500,954.59                4,473,923.93             4,434,714.57             100.88% 505,247.49                4,506,682.81             (4,292.90)                              (32,758.88)                 Benefits 82,052.83                   929,764.32                927,705.85                100.22% 68,753.14                   1,064,989.71             13,299.69                             (135,225.39)               Operations 76,606.72                   860,145.58                1,050,346.00             81.89% 51,691.75                   913,343.49                24,914.97                             (53,197.91)                 Capital Outlay ‐                               789,139.30                851,024.00                92.73% 7,317.00                     59,273.53                   (7,317.00)                              729,865.77                Total 659,614.14                7,052,973.13             7,263,790.42             97.10% 633,009.38                6,544,289.54             26,604.76                             508,683.59                Building Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 33,640.05                   289,769.23                284,584.67                101.82% 32,668.32                   277,807.17                971.73                                  11,962.06                  Benefits 5,499.75                     52,450.85                   54,088.11                   96.97% 4,453.19                     55,201.80                   1,046.56                               (2,750.95)                   Operations 6,507.03                     38,556.90                   54,017.00                   71.38% 3,715.49                     29,488.67                   2,791.54                               9,068.23                     Capital Outlay ‐                               40,000.00                   47,454.00                   84.29% 27,568.00                    ‐                                         12,432.00                  Total 45,646.83                   420,776.98                440,143.78                95.60% 40,837.00                   390,065.64                4,809.83                               30,711.34                  Parks & Recreation Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 70,684.73                   679,184.08                668,496.00                101.60% 68,739.80                   624,177.45                1,944.93                               55,006.63                  Benefits 10,094.55                   115,740.24                114,243.00                101.31% 8,494.64                     122,594.38                1,599.91                               (6,854.14)                   Operations 50,974.66                   627,407.00                1,073,033.00             58.47% 113,945.23                838,567.16                (62,970.57)                           (211,160.16)               Capital Outlay/ Capital Projects 20,867.00                   169,967.93                358,935.00                47.35% 12,850.00                   117,198.23                8,017.00                               52,769.70                  Total 152,620.94                1,592,299.25             2,214,707.00             71.90% 204,029.67                1,702,537.22             (51,408.73)                           (110,237.97)               Performing Arts Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 7,568.75                     70,159.32                   65,503.04                   107.11% 6,268.81                     52,009.93                   1,299.94                               18,149.39                  Benefits 1,090.68                     10,334.21                   8,835.94                     116.96% 727.11                        7,515.47                     363.57                                  2,818.74                     Operations 8,746.69                     127,340.32                191,310.00                66.56% 12,350.48                   139,850.66                (3,603.79)                              (12,510.34)                 Capital Outlay ‐                               ‐                                          ‐                              Total 17,406.12                   207,833.85                265,648.98                78.24% 19,346.40                   199,376.06                (1,940.28)                              8,457.79                     Non‐Departmental Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference City ‐ County Svcs ‐                               400,000.00                410,000.00                97.56%‐                               399,935.02                 ‐                                         64.98                          Community Initiatives 138,284.63                714,597.52                739,279.00                96.66% 56,680.97                   1,085,889.51             81,603.66                             (371,291.99)               Transfer to Group Health 788,804.49                3,067,660.74             2,483,850.00             123.50% 171,577.64                2,724,700.14             617,226.85                          342,960.60                Transfer to Capital Project Fund 141,135.40                505,444.02                 ‐                               100.00% 141,135.40                          505,444.02                Transfer to Judicial 7,067.00                     7,067.00                     7,067.00                     100.00% 7,067.00                               7,067.00                     Total 1,075,291.52             4,694,769.28             3,640,196.00             128.97% 228,258.61                4,210,524.67             847,032.91                          484,244.61                Debt Service Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Debt Service 99,726.24                   1,494,293.41             1,441,984.82             103.63% 830,850.39                4,927,890.36             (731,124.15)                         (3,433,596.95)           Total 99,726.24                   1,494,293.41             1,441,984.82             103.63% 830,850.39                4,927,890.36             (731,124.15)                         (3,433,596.95)           Total Sep‐17 YTD Budget % of Budget Sep‐16 YTD September Difference YTD Difference Salary 1,556,932.52             13,403,275.58           13,893,785.70           96.47% 1,517,103.73             13,238,572.33           39,828.79                             164,703.25                Benefits 1,033,653.64             5,637,240.69             5,233,873.06             107.71% 372,429.74                5,572,962.11             661,223.90                          64,278.58                  Operations 661,492.61                7,347,928.44             8,455,766.00             86.90% 530,797.22                7,603,110.76             130,695.39                          (255,182.32)               Capital Outlay 156,293.00                1,936,334.31             2,833,621.00             68.33% 84,612.39                   1,455,355.00             71,680.61                             480,979.31                Debt Service 99,726.24                   1,494,293.41             1,441,984.82             103.63% 830,850.39                4,927,890.36             (731,124.15)                         (3,433,596.95)           Total 3,508,098.01             29,819,072.43           31,859,030.58           93.60% 3,335,793.47             32,797,890.56           172,304.54                          (2,978,818.13)           Prepared by     Daniel Oakley