Loading...
September 2018 - Council Expense InformationAs of  10/12/2018 100.00 % Year Complete Executive Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 19,971.33                   253,509.02                 322,218.00                 78.68% 21,035.50                   196,874.34                 (1,064.17)                              56,634.68                   Benefits 2,897.70                     32,697.94                   44,131.00                   74.09% 2,375.10                     23,036.36                   522.60                                   9,661.58                     Operations 8,520.10                     75,625.78                   105,533.00                 71.66% 1,260.08                     92,599.64                   7,260.02                               (16,973.86)                 Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 31,389.13                   361,832.74                 471,882.00                 76.68% 24,670.68                   312,510.34                 6,718.45                               49,322.40                   Legislative Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 10,417.04                   125,004.48                 125,000.00                 100.00% 10,417.04                   126,010.90                  ‐                                         (1,006.42)                   Benefits 750.24                         9,324.54                     10,415.00                   89.53% 716.25                         9,407.65                     33.99                                     (83.11)                         Operations 342.65                         8,977.21                     25,800.00                   34.80% 460.00                         8,105.25                     (117.35)                                 871.96                        Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 11,509.93                   143,306.23                 161,215.00                 88.89% 11,593.29                   143,523.80                 (83.36)                                    (217.57)                       Finance Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 21,347.10                   289,850.78                 293,988.00                 98.59% 32,797.07                   276,228.98                 (11,449.97)                            13,621.80                   Benefits 3,304.92                     45,112.73                   47,381.00                   95.21% 5,142.29                     43,473.69                   (1,837.37)                              1,639.04                     Operations 36,041.25                   254,339.25                 259,155.00                 98.14% 6,829.44                     226,259.38                 29,211.81                             28,079.87                   Capital Outlay 1,502.00                     1,502.00                     25,000.00                   6.01%‐                               28,466.20                   1,502.00                               (26,964.20)                 Total 62,195.27                   590,804.76                 625,524.00                 94.45% 44,768.80                   574,428.25                 17,426.47                             16,376.51                   City Clerk Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 9,867.75                     125,651.14                 126,487.00                 99.34% 13,608.58                   123,525.12                 (3,740.83)                              2,126.02                     Benefits 1,450.74                     18,640.47                   20,169.00                   92.42% 2,078.43                     18,588.41                   (627.69)                                 52.06                          Operations 5,500.92                     67,064.12                   114,800.00                 58.42% 2,886.43                     45,931.64                   2,614.49                               21,132.48                   Capital Outlay ‐                               365.00                          ‐                               100.00%‐                                ‐                                ‐                                         365.00                        Total 16,819.41                   211,720.73                 261,456.00                 80.98% 18,573.44                   188,045.17                 (1,754.03)                              23,675.56                   HR Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 21,239.00                   255,598.25                 274,485.00                 93.12% 24,932.69                   215,980.98                 (3,693.69)                              39,617.27                   Benefits 3,445.66                     42,035.84                   44,794.00                   93.84% 4,021.52                     35,264.31                   (575.86)                                 6,771.53                     Operations 7,910.57                     122,711.99                 87,550.00                   140.16% 19,369.52                   77,452.69                   (11,458.95)                            45,259.30                   Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                          ‐                               Total 32,595.23                   420,346.08                 406,829.00                 103.32% 48,323.73                   328,697.98                 (15,728.50)                            91,648.10                   IT Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 12,470.58                   161,807.83                 162,125.00                 99.80% 18,751.15                   128,820.81                 (6,280.57)                              32,987.02                   Benefits 1,752.58                     23,121.20                   23,874.00                   96.85% 2,650.81                     18,517.97                   (898.23)                                 4,603.23                     Operations 107,921.98                 1,171,342.39             1,174,168.00             99.76% 53,740.72                   1,191,584.06             54,181.26                             (20,241.67)                 Capital Outlay ‐                               50,234.92                   64,512.00                   77.87%‐                               16,045.76                    ‐                                         34,189.16                   Total 122,145.14                 1,406,506.34             1,424,679.00             98.72% 75,142.68                   1,354,968.60             47,002.46                             51,537.74                   Vehicle Maint. Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 18,690.87                   221,529.30                 243,870.00                 90.84% 27,662.04                   216,261.12                 (8,971.17)                              5,268.18                     Benefits 2,904.35                     43,945.58                   50,505.00                   87.01% 4,121.99                     46,298.12                   (1,217.64)                              (2,352.54)                   Operations 3,906.27                     37,949.67                   97,551.00                   38.90% 4,168.15                     74,738.03                   (261.88)                                 (36,788.36)                 Capital Outlay ‐                                ‐                               32,399.00                   0.00%‐                               22,923.99                    ‐                                         (22,923.99)                 Total 25,501.49                   303,424.55                 424,325.00                 71.51% 35,952.18                   360,221.26                 (10,450.69)                            (56,796.71)                 City of Prattville September Unaudited Expenses By Department Engineering Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 36,270.72                   450,453.14                471,460.00                95.54% 46,287.32                   420,304.00                (10,016.60)                           30,149.14                  Benefits 6,012.17                     89,122.36                   93,269.00                   95.55% 7,691.38                     90,287.84                   (1,679.21)                              (1,165.48)                   Operations 24,362.50                   376,686.45                613,733.00                61.38% 11,897.07                   339,661.23                12,465.43                             37,025.22                  Captial Projects ‐                                ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Capital Outlay ‐                                ‐                               155,089.00                0.00% 3,250.00                     272,227.61                (3,250.00)                              (272,227.61)               Total 66,645.39                   916,261.95                1,333,551.00             68.71% 69,125.77                   1,122,480.68             (2,480.38)                              (206,218.73)               Planning Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 39,502.89                   239,450.96                247,504.00                96.75% 28,798.53                   256,241.01                10,704.36                             (16,790.05)                 Benefits 3,978.53                     36,500.92                   41,702.00                   87.53% 4,752.44                     43,797.66                   (773.91)                                 (7,296.74)                   Operations 80,539.68                   505,871.95                503,700.00                100.43% 11,952.72                   397,226.32                68,586.96                             108,645.63                Captial Projects ‐                                ‐                                ‐                               0.00%‐                                          ‐                              Capital Outlay ‐                               6,011.00                     6,000.00                     100.18%‐                               27,839.00                    ‐                                         (21,828.00)                 Total 124,021.10                787,834.83                798,906.00                98.61% 45,503.69                   725,103.99                78,517.41                             62,730.84                  Urban Management Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 55,078.74                   691,950.81                649,770.00                106.49% 98,784.49                   837,040.06                (43,705.75)                           (145,089.25)               Benefits 8,006.67                     121,463.28                123,709.00                98.18% 14,585.56                   154,740.36                (6,578.89)                              (33,277.08)                 Operations 37,746.07                   377,674.14                472,388.00                79.95% 26,286.76                   329,218.56                11,459.31                             48,455.58                  Capital Outlay ‐                               34,382.39                   264,794.00                12.98% 30,751.50                   39,149.02                   (30,751.50)                           (4,766.63)                   Total 100,831.48                1,225,470.62             1,510,661.00             81.12% 170,408.31                1,360,148.00             (69,576.83)                           (134,677.38)               Facilities Maintenance Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 24,598.63                   293,608.01                267,205.00                109.88% 27,066.93                   194,259.57                (2,468.30)                              99,348.44                  Benefits 3,489.76                     51,612.10                   47,755.00                   108.08% 4,060.60                     35,113.46                   (570.84)                                 16,498.64                  Operations 4,518.11                     116,671.39                137,500.00                84.85% 15,122.21                   63,679.03                   (10,604.10)                           52,992.36                  Capital Outlay 115,590.06                169,224.48                372,000.00                45.49%‐                               21,868.00                   115,590.06                          147,356.48                Total 148,196.56                631,115.98                824,460.00                76.55% 46,249.74                   314,920.06                101,946.82                          316,195.92                Public Works Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 18,390.88                   340,892.85                582,714.00                58.50% 25,696.01                   188,008.93                (7,305.13)                              152,883.92                Benefits 2,924.11                     88,218.24                   131,966.00                66.85% 4,102.65                     36,347.08                   (1,178.54)                              51,871.16                  Operations 10,182.72                   119,192.93                230,168.00                51.79% 6,837.62                     71,814.89                   3,345.10                               47,378.04                  Capital Outlay ‐                               6,550.00                     85,000.00                   7.71% 30,751.50                   271,000.50                (30,751.50)                           (264,450.50)               Total 31,497.71                   554,854.02                1,029,848.00             53.88% 67,387.78                   567,171.40                (35,890.07)                           (12,317.38)                 Police Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 378,732.58                4,769,310.25             5,031,675.00             94.79% 568,247.05                4,710,683.20             (189,514.47)                         58,627.05                  Benefits 59,318.06                   926,149.47                1,016,170.00             91.14% 89,812.32                   906,417.45                (30,494.26)                           19,732.02                  Operations 49,818.77                   1,114,608.52             1,172,965.00             95.02% 71,359.76                   1,149,099.38             (21,540.99)                           (34,490.86)                 Capital Outlay 33,150.00                   249,232.46                350,100.00                71.19% 70,673.00                   237,707.00                (37,523.00)                           11,525.46                  Total 521,019.41                7,059,300.70             7,570,910.00             93.24% 800,092.13                7,003,907.03             (279,072.72)                         55,393.67                  Fire Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 354,223.50                4,611,955.93             4,590,342.00             100.47% 500,954.59                4,473,923.93             (146,731.09)                         138,032.00                Benefits 57,063.20                   916,448.12                959,212.00                95.54% 82,052.83                   929,764.32                (24,989.63)                           (13,316.20)                 Operations 63,165.30                   1,010,723.44             1,119,362.00             90.29% 76,606.72                   860,145.58                (13,441.42)                           150,577.86                Capital Outlay ‐                               55,150.25                   238,740.00                23.10%‐                               789,139.30                 ‐                                         (733,989.05)               Total 474,452.00                6,594,277.74             6,907,656.00             95.46% 659,614.14                7,052,973.13             (185,162.14)                         (458,695.39)               Building Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 22,549.67                   278,824.44                292,550.00                95.31% 33,640.05                   289,769.23                (11,090.38)                           (10,944.79)                 Benefits 3,664.90                     48,923.26                   54,720.00                   89.41% 5,499.75                     52,450.85                   (1,834.85)                              (3,527.59)                   Operations 1,583.08                     41,462.59                   63,450.00                   65.35% 6,507.03                     38,556.90                   (4,923.95)                              2,905.69                     Capital Outlay ‐                                ‐                                ‐                               0.00%‐                               40,000.00                    ‐                                         (40,000.00)                 Total 27,797.65                   369,210.29                410,720.00                89.89% 45,646.83                   420,776.98                (17,849.18)                           (51,566.69)                 Parks & Recreation Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 59,258.93                   726,450.51                718,665.00                101.08% 70,684.73                   679,184.08                (11,425.80)                           47,266.43                  Benefits 8,551.52                     117,343.98                122,111.00                96.10% 10,094.55                   115,740.24                (1,543.03)                              1,603.74                     Operations 119,407.13                890,889.72                1,161,416.00             76.71% 50,974.66                   627,407.00                68,432.47                             263,482.72                Capital Outlay/ Capital Projects 35,322.74                   227,294.93                459,151.00                49.50% 20,867.00                   169,967.93                14,455.74                             57,327.00                  Total 222,540.32                1,961,979.14             2,461,343.00             79.71% 152,620.94                1,592,299.25             69,919.38                             369,679.89                Performing Arts Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 5,690.99                     75,434.15                   77,613.00                   97.19% 7,568.75                     70,159.32                   (1,877.76)                              5,274.83                     Benefits 824.60                        11,061.25                   16,411.00                   67.40% 1,090.68                     10,334.21                   (266.08)                                 727.04                        Operations 14,793.74                   157,261.38                222,760.00                70.60% 8,746.69                     127,340.32                6,047.05                               29,921.06                  Capital Outlay ‐                                ‐                                ‐                               ‐                                          ‐                              Total 21,309.33                   243,756.78                316,784.00                76.95% 17,406.12                   207,833.85                3,903.21                               35,922.93                  Non‐Departmental Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference City ‐ County Svcs ‐                               400,000.00                410,000.00                97.56%‐                               400,000.00                 ‐                                          ‐                              Community Initiatives 145,675.13                825,499.62                930,624.00                88.70% 138,284.63                714,597.52                7,390.50                               110,902.10                Transfer to DSF ‐ One Cent ‐                               8,505,423.04             8,490,762.00             100.17%‐                                ‐                                         8,505,423.04             Transfer to DSF ‐ Other ‐                               164,205.83                164,206.00                100.00%‐                                ‐                                         164,205.83                Transfer to Group Health 249,375.00                2,992,500.00             2,992,500.00             100.00% 788,804.49                3,067,660.74             (539,429.49)                         (75,160.74)                 Transfer to Capital Project Fund 242,858.69                1,012,231.37             112,300.00                901.36% 141,135.40                505,444.02                101,723.29                          506,787.35                Transfer to Judicial ‐                               53,093.00                   0.00% 7,067.00                     7067 (7,067.00)                              (7,067.00)                   Total 637,908.82                13,899,859.86           13,153,485.00           105.67% 1,075,291.52             4,694,769.28             (437,382.70)                         9,205,090.58             Debt Service Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Debt Service 161,998.75                1,451,972.41             1,441,350.00             100.74% 99,726.24                   1,494,293.41             62,272.51                             (42,321.00)                 Total 161,998.75                1,451,972.41             1,441,350.00             100.74% 99,726.24                   1,494,293.41             62,272.51                             (42,321.00)                 Total Sep‐18 YTD Budget % of Budget Sep‐17 YTD September Difference YTD Difference Salary 1,108,301.20             13,911,281.85           14,477,671.00           96.09% 1,556,932.52             13,403,275.58           (448,631.32)                         508,006.27                Benefits 419,714.71                5,614,221.28             5,840,794.00             96.12% 1,033,653.64             5,637,240.72             (613,938.93)                         (23,019.44)                 Operations 964,794.66                8,686,783.91             9,068,016.00             95.80% 661,492.61                7,347,928.44             303,302.05                          1,338,855.47             Capital Outlay 185,564.80                799,947.43                2,052,785.00             38.97% 156,293.00                1,936,334.31             29,271.80                             (1,136,386.88)           Debt Service 161,998.75                10,121,601.28           10,096,318.00           100.25% 99,726.24                   1,494,293.41             62,272.51                             8,627,307.87             Total 2,840,374.12             39,133,835.75           41,535,584.00           94.22% 3,508,098.01             29,819,072.46           (667,723.89)                         9,314,763.29             Prepared by     Daniel Oakley