Loading...
August 2017 - Council Expense InformationAs of  9/15/2017 91.67 % Year Complete Executive Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 13,225.82                   176,838.84                 192,853.00                 91.70% 14,738.64                   163,700.35                 (1,512.82)                              13,138.49                   Benefits 1,458.29                     20,661.26                   23,798.00                   86.82% 1,753.40                     20,661.99                   (295.11)                                 (0.73)                           Operations 3,257.85                     91,339.56                   99,698.00                   91.62% 2,399.98                     49,522.16                   857.87                                   41,817.40                   Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 17,941.96                   288,839.66                 316,349.00                 91.30% 18,892.02                   233,884.50                 (950.06)                                 54,955.16                   Legislative Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 10,417.04                   115,593.86                 125,000.00                 92.48% 10,417.04                   114,587.44                  ‐                                         1,006.42                     Benefits 811.45                         8,691.40                     10,391.50                   83.64% 733.22                         8,682.49                     78.23                                     8.91                             Operations 385.00                         7,645.25                     26,250.00                   29.12% 252.05                         385.00                                   7,393.20                     Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 11,613.49                   131,930.51                 161,641.50                 81.62% 11,150.26                   123,521.98                 463.23                                   8,408.53                     Finance Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 22,119.32                   243,431.91                 303,798.29                 80.13% 23,463.87                   260,957.04                 (1,344.55)                              (17,525.13)                 Benefits 3,462.56                     38,331.40                   51,498.48                   74.43% 3,913.21                     46,045.04                   (450.65)                                 (7,713.64)                   Operations 11,305.82                   219,429.94                 235,620.00                 93.13% 18,973.80                   324,268.65                 (7,667.98)                              (104,838.71)               Capital Outlay ‐                               28,466.20                   27,839.00                   102.25%‐                                ‐                                ‐                                         28,466.20                   Total 36,887.70                   529,659.45                 618,755.77                 85.60% 46,350.88                   631,270.73                 (9,463.18)                              (101,611.28)               City Clerk Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 9,660.09                     109,916.54                 125,523.26                 87.57% 9,507.47                     105,042.64                 152.62                                   4,873.90                     Benefits 1,430.30                     16,509.98                   19,803.25                   83.37% 1,424.04                     16,940.44                   6.26                                       (430.46)                       Operations 5,056.69                     43,045.21                   90,967.00                   47.32% 45,367.56                   91,025.06                   (40,310.87)                            (47,979.85)                 Capital Outlay ‐                                ‐                               11,693.00                   0.00%‐                                ‐                                ‐                                          ‐                               Total 16,147.08                   169,471.73                 247,986.51                 68.34% 56,299.07                   213,008.14                 (40,151.99)                            (43,536.41)                 HR Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 17,105.99                   191,048.29                 216,591.53                 88.21% 16,438.68                   183,519.75                 667.31                                   7,528.54                     Benefits 2,733.20                     31,242.79                   37,088.49                   84.24% 2,673.03                     31,914.69                   60.17                                     (671.90)                       Operations 7,312.22                     58,083.17                   119,351.00                 48.67% 5,931.33                     45,771.71                   1,380.89                               12,311.46                   Capital Outlay ‐                               22,832.00                   0.00%‐                                          ‐                               Total 27,151.41                   280,374.25                 395,863.02                 70.83% 25,043.04                   261,206.15                 2,108.37                               19,168.10                   IT Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 12,585.24                   110,069.66                 165,976.00                 66.32% 7,036.26                     103,068.30                 5,548.98                               7,001.36                     Benefits 1,782.71                     15,867.16                   24,344.00                   65.18% 1,054.82                     15,992.43                   727.89                                   (125.27)                       Operations 119,634.73                 1,137,843.34             1,054,414.00             107.91% 87,911.62                   1,066,158.22             31,723.11                             71,685.12                   Capital Outlay ‐                               16,045.76                   16,046.00                   100.00% 12,142.83                    ‐                                         3,902.93                     Total 134,002.68                 1,279,825.92             1,260,780.00             101.51% 96,002.70                   1,197,361.78             37,999.98                             82,464.14                   Vehicle Maint. Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 18,798.00                   188,599.08                 234,480.77                 80.43% 17,178.37                   190,963.72                 1,619.63                               (2,364.64)                   Benefits 2,792.10                     42,176.13                   47,139.49                   89.47% 2,646.42                     47,482.39                   145.68                                   (5,306.26)                   Operations 7,339.48                     70,569.88                   117,966.00                 59.82% 11,402.32                   99,944.38                   (4,062.84)                              (29,374.50)                 Capital Outlay 22,923.99                   22,923.99                   40,000.00                   57.31% 19,675.00                   22,923.99                             3,248.99                     Total 51,853.57                   324,269.08                 439,586.26                 73.77% 31,227.11                   358,065.49                 20,626.46                             (33,796.41)                 City of Prattville August Unaudited Expenses By Department Engineering Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 30,987.77                   374,016.68                493,422.82                75.80% 33,872.54                   420,970.73                (2,884.77)                              (46,954.05)                 Benefits 5,141.90                     82,596.46                   105,148.38                78.55% 5,544.65                     99,054.17                   (402.75)                                 (16,457.71)                 Operations 51,436.65                   327,764.16                543,300.00                60.33% 99,357.51                   362,516.32                (47,920.86)                           (34,752.16)                 Captial Projects ‐                               0.00%‐                                          ‐                              Capital Outlay ‐                               268,977.61                300,000.00                89.66% 108,874.15                 ‐                                         160,103.46                Total 87,566.32                   1,053,354.91             1,441,871.20             73.05% 138,774.70                991,415.37                (51,208.38)                           61,939.54                  Planning Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 18,711.48                   227,442.48                269,868.43                84.28% 20,005.04                   222,956.69                (1,293.56)                              4,485.79                     Benefits 3,135.56                     39,045.22                   47,227.87                   82.67% 3,448.85                     40,718.73                   (313.29)                                 (1,673.51)                   Operations 34,967.38                   385,273.60                693,335.00                55.57% 50,359.91                   392,519.82                (15,392.53)                           (7,246.22)                   Captial Projects ‐                                ‐                               0.00%‐                                          ‐                              Capital Outlay ‐                               27,839.00                   27,839.00                   100.00%‐                                         27,839.00                  Total 56,814.42                   679,600.30                1,038,270.30             65.46% 73,813.80                   656,195.24                (16,999.38)                           23,405.06                  Urban Management Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 68,882.41                   738,255.57                917,120.07                80.50% 74,030.90                   737,792.85                (5,148.49)                              462.72                        Benefits 9,855.36                     140,154.80                166,388.70                84.23% 10,967.61                   157,530.99                (1,112.25)                              (17,376.19)                 Operations 32,538.35                   302,931.80                577,050.00                52.50% 41,835.33                   393,612.58                (9,296.98)                              (90,680.78)                 Capital Outlay ‐                               8,397.52                     315,000.00                2.67% 40,131.80                   294,864.87                (40,131.80)                           (286,467.35)               Total 111,276.12                1,189,739.69             1,975,558.77             60.22% 166,965.64                1,583,801.29             (55,689.52)                           (394,061.60)               Facilities Maintenance Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 16,517.24                   167,192.64                227,251.00                73.57% 13,806.26                   176,743.12                2,710.98                               (9,550.48)                   Benefits 2,484.37                     31,052.83                   40,211.00                   77.22% 2,202.36                     35,375.73                   282.01                                  (4,322.90)                   Operations 5,306.06                     48,556.82                   84,600.00                   57.40% 4,371.80                     59,809.43                   934.26                                  (11,252.61)                 Capital Outlay ‐                               21,868.00                   193,358.00                11.31%‐                                         21,868.00                  Total 24,307.67                   268,670.29                545,420.00                49.26% 20,380.42                   271,928.28                3,927.25                               (3,257.99)                   Public Works Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 17,167.76                   162,312.92                248,857.41                65.22% 12,608.69                   135,962.81                4,559.07                               26,350.11                  Benefits 2,729.91                     32,244.43                   47,434.00                   67.98% 2,144.30                     25,929.01                   585.61                                  6,315.42                     Operations 5,001.36                     64,977.27                   102,396.00                63.46% 3,704.17                     50,572.41                   1,297.19                               14,404.86                  Capital Outlay ‐                               240,249.00                315,256.00                76.21%‐                                         240,249.00                Total 24,899.03                   499,783.62                713,943.41                70.00% 18,457.16                   212,464.23                6,441.87                               287,319.39                Police Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 353,575.26                4,142,436.15             4,929,053.84             84.04% 336,862.12                4,057,450.22             16,713.14                             84,985.93                  Benefits 57,170.07                   816,605.13                957,845.00                85.25% 56,099.14                   906,554.74                1,070.93                               (89,949.61)                 Operations 89,055.36                   1,077,739.62             1,198,972.00             89.89% 84,655.13                   1,055,246.11             4,400.23                               22,493.51                  Capital Outlay ‐                               167,034.00                283,831.00                58.85% 26,653.00                   481,103.00                (26,653.00)                           (314,069.00)               Total 499,800.69                6,203,814.90             7,369,701.84             84.18% 504,269.39                6,500,354.07             (4,468.70)                              (296,539.17)               Fire Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 344,400.74                3,972,969.34             4,434,714.57             89.59% 376,398.17                4,001,435.32             (31,997.43)                           (28,465.98)                 Benefits 56,003.24                   847,711.49                927,705.85                91.38% 61,529.35                   980,380.78                (5,526.11)                              (132,669.29)               Operations 62,692.69                   783,538.86                1,050,346.00             74.60% 71,308.44                   859,312.51                (8,615.75)                              (75,773.65)                 Capital Outlay ‐                               789,139.30                851,024.00                92.73% 51,956.53                    ‐                                         737,182.77                Total 463,096.67                6,393,358.99             7,263,790.42             88.02% 509,235.96                5,893,085.14             (46,139.29)                           500,273.85                Building Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 22,343.94                   256,129.18                284,584.67                90.00% 21,695.68                   245,138.85                648.26                                  10,990.33                  Benefits 3,602.54                     46,951.10                   54,088.11                   86.80% 3,622.52                     49,702.23                   (19.98)                                   (2,751.13)                   Operations 2,372.88                     32,049.87                   54,017.00                   59.33% 648.70                        25,770.06                   1,724.18                               6,279.81                     Capital Outlay ‐                               40,000.00                   47,454.00                   84.29% 27,568.00                    ‐                                         12,432.00                  Total 28,319.36                   375,130.15                440,143.78                85.23% 25,966.90                   348,179.14                2,352.46                               26,951.01                  Parks & Recreation Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 62,462.97                   608,499.35                668,496.00                91.03% 60,745.61                   555,437.65                1,717.36                               53,061.70                  Benefits 7,942.79                     105,645.69                114,243.00                92.47% 7,794.07                     112,439.86                148.72                                  (6,794.17)                   Operations 60,134.22                   576,432.34                1,073,033.00             53.72% 81,944.69                   724,263.21                (21,810.47)                           (147,830.87)               Capital Outlay/ Capital Projects ‐                               149,100.93                358,935.00                41.54% 104,348.23                 ‐                                         44,752.70                  Total 130,539.98                1,439,678.31             2,214,707.00             65.01% 150,484.37                1,496,488.95             (19,944.39)                           (56,810.64)                 Performing Arts Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 5,829.59                     62,590.57                   65,503.04                   95.55% 4,212.69                     45,741.12                   1,616.90                               16,849.45                  Benefits 846.84                        9,243.53                     8,835.94                     104.61% 571.52                        6,664.59                     275.32                                  2,578.94                     Operations 5,365.22                     118,593.63                191,310.00                61.99% 5,630.35                     127,500.18                (265.13)                                 (8,906.55)                   Capital Outlay ‐                               ‐                                          ‐                              Total 12,041.65                   190,427.73                265,648.98                71.68% 10,414.56                   179,905.89                1,627.09                               10,521.84                  Non‐Departmental Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference City ‐ County Svcs 13,333.32                   400,000.00                410,000.00                97.56% 75,000.00                   399,935.02                (61,666.68)                           64.98                          Community Initiatives 59,443.05                   576,312.89                739,279.00                77.96% 159,329.18                1,029,208.54             (99,886.13)                           (452,895.65)               Transfer to Group Health 207,168.75                2,278,856.25             2,483,850.00             91.75% 186,647.50                2,553,122.50             20,521.25                             (274,266.25)               Transfer to Capital Project Fund 65,103.74                   364,308.62                 ‐                               100.00% 65,103.74                             364,308.62                Transfer to Judicial ‐                                ‐                               7,067.00                     0.00%‐                                          ‐                              Total 345,048.86                3,619,477.76             3,640,196.00             99.43% 420,976.68                3,982,266.06             (75,927.82)                           (362,788.30)               Debt Service Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Debt Service 4,400.00                     1,394,567.17             4,940,537.10             28.23% 13,333.33                   4,097,039.97             (8,933.33)                              (2,702,472.80)           Total 4,400.00                     1,394,567.17             4,940,537.10             28.23% 13,333.33                   4,097,039.97             (8,933.33)                              (2,702,472.80)           Total Aug‐17 YTD Budget % of Budget Aug‐16 YTD August Difference YTD Difference Salary 1,044,790.66             11,847,343.06           13,903,094.70           85.21% 1,053,018.03             11,721,468.60           (8,227.37)                              125,874.46                Benefits 370,551.94                4,603,587.05             5,167,041.06             89.10% 354,770.01                5,155,192.80             15,781.93                             (551,605.75)               Operations 641,042.07                6,686,435.83             8,468,971.00             78.95% 850,131.82                7,157,208.42             (209,089.75)                         (470,772.59)               Capital Outlay 22,923.99                   1,780,041.31             2,811,107.00             63.32% 66,784.80                   1,100,532.61             (43,860.81)                           679,508.70                Debt Service 4,400.00                     1,394,567.17             4,940,537.10             28.23% 13,333.33                   4,097,039.97             (8,933.33)                              (2,702,472.80)           Total 2,083,708.66             26,311,974.42           35,290,750.86           74.56% 2,338,037.99             29,231,442.40           (254,329.33)                         (2,919,467.98)           Prepared by     Daniel Oakley