Loading...
March 2017 - Council Expense InformationAs of  4/14/2017 50.00 % Year Complete Executive Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 22,560.51                   88,060.98                   188,224.01                46.79% 14,422.77                   84,059.27                   8,137.74                               4,001.71                     Benefits 2,693.15                     11,150.00                   23,124.37                   48.22% 1,729.24                     11,086.95                   963.91                                  63.05                          Operations 44,812.81                   79,233.52                   115,841.00                68.40% 1,356.30                     42,243.85                   43,456.51                             36,989.67                  Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                              Total 70,066.47                   178,444.50                327,189.38                54.54% 17,508.31                   137,390.07                52,558.16                             41,054.43                  Legislative Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 10,208.38                   62,513.91                   125,000.00                50.01% 10,417.04                   62,502.24                   (208.66)                                 11.67                          Benefits 781.89                        4,837.45                     10,391.50                   46.55% 733.22                        5,006.36                     48.67                                     (168.91)                       Operations 2,239.99                     4,496.71                     26,250.00                   17.13%‐                               2,204.22                     2,239.99                               2,292.49                     Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                              Total 13,230.26                   71,848.07                   161,641.50                44.45% 11,150.26                   69,712.82                   2,080.00                               2,135.25                     Finance Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 32,751.22                   125,095.80                303,798.29                41.18% 22,782.00                   134,064.55                9,969.22                               (8,968.75)                   Benefits 5,161.65                     20,555.30                   51,498.48                   39.91% 3,799.41                     24,845.27                   1,362.24                               (4,289.97)                   Operations 33,167.81                   156,368.35                235,620.00                66.36% 81,802.55                   216,028.16                (48,634.74)                           (59,659.81)                 Capital Outlay ‐                               28,466.20                   27,839.00                   102.25%‐                                         28,466.20                  Total 71,080.68                   330,485.65                618,755.77                53.41% 108,383.96                374,937.98                (37,303.28)                           (44,452.33)                 City Clerk Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 13,531.77                   55,878.21                   125,523.26                44.52% 9,507.47                     53,709.89                   4,024.30                               2,168.32                     Benefits 2,095.83                     9,050.46                     19,803.25                   45.70% 1,424.04                     9,144.33                     671.79                                  (93.87)                         Operations 1,900.74                     30,648.22                   88,000.00                   34.83% 7,523.36                     18,501.77                   (5,622.62)                              12,146.45                  Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 17,528.34                   95,576.89                   233,326.51                40.96% 18,454.87                   81,355.99                   (926.53)                                 14,220.90                  HR Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 24,614.61                   99,303.04                   229,327.53                43.30% 15,920.20                   93,974.45                   8,694.41                               5,328.59                     Benefits 4,001.21                     17,343.24                   38,035.49                   45.60% 2,630.08                     17,204.23                   1,371.13                               139.01                        Operations 11,645.33                   25,886.24                   96,600.00                   26.80% 7,651.20                     34,862.59                   3,994.13                               (8,976.35)                   Capital Outlay ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 40,261.15                   142,532.52                363,963.02                39.16% 26,201.48                   146,041.27                14,059.67                             (3,508.75)                   IT Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 13,159.20                   46,820.01                   165,975.83                28.21% 22,540.46                   64,368.87                   (9,381.26)                              (17,548.86)                 Benefits 1,885.14                     7,185.36                     24,343.60                   29.52% 2,482.81                     10,172.54                   (597.67)                                 (2,987.18)                   Operations 86,278.06                   695,536.27                1,070,460.70             64.98% 62,940.31                   699,586.80                23,337.75                             (4,050.53)                   Capital Outlay 0.00%‐                                          ‐                              Total 101,322.40                749,541.64                1,260,780.13             59.45% 87,963.58                   774,128.21                13,358.82                             (24,586.57)                 Vehicle Maint. Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 25,076.43                   100,935.38                234,480.77                43.05% 16,217.10                   97,218.32                   8,859.33                               3,717.06                     Benefits 3,769.07                     26,996.40                   47,139.49                   57.27% 2,545.97                     32,436.39                   1,223.10                               (5,439.99)                   Operations 9,765.72                     32,734.52                   121,450.00                26.95% 66,854.47                   9,765.72                               (34,119.95)                 Capital Outlay 40,000.00                   0.00%‐                                          ‐                              Total 38,611.22                   160,666.30                443,070.26                36.26% 18,763.07                   196,509.18                19,848.15                             (35,842.88)                 City of Prattville March Unaudited Expenses By Department Engineering Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 45,556.60                   203,258.82                493,422.82                41.19% 36,888.73                   209,519.07                8,667.87                               (6,260.25)                   Benefits 7,616.70                     54,949.77                   105,148.38                52.26% 6,070.66                     64,590.60                   1,546.04                               (9,640.83)                   Operations 23,782.83                   192,168.22                543,300.00                35.37% 35,856.89                   206,693.41                (12,074.06)                           (14,525.19)                 Captial Projects 0.00%‐                                          ‐                              Capital Outlay ‐                               268,977.61                300,000.00                89.66% 140,331.00                 ‐                                         128,646.61                Total 76,956.13                   719,354.42                1,441,871.20             49.89% 78,816.28                   621,134.08                (1,860.15)                              98,220.34                  Planning Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 29,564.85                   118,306.77                269,868.43                43.84% 19,587.60                   113,132.64                9,977.25                               5,174.13                     Benefits 5,030.00                     21,659.03                   47,227.87                   45.86% 3,375.45                     21,728.60                   1,654.55                               (69.57)                         Operations 69,427.76                   283,047.27                693,335.00                40.82% 31,577.70                   207,117.11                37,850.06                             75,930.16                  Captial Projects ‐                               0.00%‐                                          ‐                              Capital Outlay ‐                               27,839.00                   27,839.00                   100.00%‐                                         27,839.00                  Total 104,022.61                450,852.07                1,038,270.30             43.42% 54,540.75                   341,978.35                49,481.86                             108,873.72                Urban Management Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 89,801.77                   365,805.57                917,120.07                39.89% 60,520.61                   341,954.28                29,281.16                             23,851.29                  Benefits 13,982.29                   86,310.69                   166,388.70                51.87% 9,771.56                     97,906.32                   4,210.73                               (11,595.63)                 Operations 26,985.03                   140,902.50                577,050.00                24.42% 20,342.21                   252,674.06                6,642.82                               (111,771.56)               Capital Outlay ‐                               315,000.00                0.00% 126,027.11                175,971.43                (126,027.11)                         (175,971.43)               Total 130,769.09                593,018.76                1,975,558.77             30.02% 216,661.49                868,506.09                (85,892.40)                           (275,487.33)               Facilities Maintenance Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 21,907.93                   85,965.96                   222,213.17                38.69% 28,062.99                   103,905.47                (6,155.06)                              (17,939.51)                 Benefits 3,366.77                     19,054.52                   39,363.33                   48.41% 3,315.26                     23,614.53                   51.51                                    (4,560.01)                   Operations 4,480.39                     23,110.07                   84,600.00                   27.32% 2,806.01                     26,199.35                   1,674.38                               (3,089.28)                   Capital Outlay 25,000.00                   0.00%‐                                          ‐                              Total 29,755.09                   128,130.55                371,176.50                34.52% 34,184.26                   153,719.35                (4,429.17)                              (25,588.80)                 Public Works Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 19,233.21                   76,741.02                   248,857.41                30.84% 12,688.80                   66,408.00                   6,544.41                               10,333.02                  Benefits 3,239.56                     18,752.35                   47,433.43                   39.53% 2,156.68                     14,057.49                   1,082.88                               4,694.86                     Operations 5,419.75                     32,221.98                   138,168.00                23.32% 5,890.61                     27,897.58                   (470.86)                                 4,324.40                     Capital Outlay 276,000.00                0.00%‐                                          ‐                              Total 27,892.52                   127,715.35                710,458.84                17.98% 20,736.09                   108,363.07                7,156.43                               19,352.28                  Police Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 547,308.74                2,210,408.45             4,929,053.84             44.84% 346,421.53                2,110,078.20             200,887.21                          100,330.25                Benefits 86,534.70                   516,522.77                957,845.57                53.93% 57,024.63                   579,059.68                29,510.07                             (62,536.91)                 Operations 61,632.48                   692,448.30                1,264,063.80             54.78% 54,795.79                   682,618.46                6,836.69                               9,829.84                     Capital Outlay ‐                               167,034.00                167,034.00                100.00% 315,255.00                 ‐                                         (148,221.00)               Total 695,475.92                3,586,413.52             7,317,997.21             49.01% 458,241.95                3,687,011.34             237,233.97                          (100,597.82)               Fire Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 507,452.98                2,112,549.03             4,434,714.57             47.64% 353,322.43                2,064,883.08             154,130.55                          47,665.95                  Benefits 83,962.81                   549,999.77                927,705.85                59.29% 59,617.97                   647,802.50                24,344.84                             (97,802.73)                 Operations 86,502.07                   449,979.32                1,050,345.96             42.84% 46,272.67                   560,692.93                40,229.40                             (110,713.61)               Capital Outlay ‐                               770,293.71                789,905.00                97.52% 1,649.07                     1,649.07                     (1,649.07)                              768,644.64                Total 677,917.86                3,882,821.83             7,202,671.38             53.91% 460,862.14                3,275,027.58             217,055.72                          607,794.25                Building Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 33,190.40                   133,959.80                284,584.67                47.07% 21,534.20                   126,028.89                11,656.20                             7,930.91                     Benefits 5,425.01                     27,878.61                   54,088.11                   51.54% 3,595.50                     29,576.83                   1,829.51                               (1,698.22)                   Operations 1,970.33                     17,997.52                   57,134.00                   31.50% 2,845.02                     20,402.31                   (874.69)                                 (2,404.79)                   Capital Outlay 44,336.00                   0.00%‐                                          ‐                              Total 40,585.74                   179,835.93                440,142.78                40.86% 27,974.72                   176,008.03                12,611.02                             3,827.90                     Parks & Recreation Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 64,041.90                   279,298.65                668,495.70                41.78% 42,355.79                   232,650.04                21,686.11                             46,648.61                  Benefits 9,192.12                     63,999.34                   114,243.26                56.02% 6,605.28                     69,152.96                   2,586.84                               (5,153.62)                   Operations 99,628.51                   309,000.48                1,069,712.07             28.89% 50,498.69                   367,623.61                49,129.82                             (58,623.13)                 Capital Outlay/ Capital Projects 32,436.00                   32,436.00                   1,223,584.90             2.65% 5,911.61                     49,173.23                   26,524.39                             (16,737.23)                 Total 205,298.53                684,734.47                3,076,035.93             22.26% 105,371.37                718,599.84                99,927.16                             (33,865.37)                 Performing Arts Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 7,263.51                     28,429.29                   65,503.04                   43.40% 4,283.00                     22,565.20                   2,980.51                               5,864.09                     Benefits 1,053.49                     4,441.21                     8,835.94                     50.26% 581.74                        3,517.44                     471.75                                  923.77                        Operations 14,996.65                   45,708.71                   191,310.00                23.89% 13,161.21                   62,860.02                   1,835.44                               (17,151.31)                 Capital Outlay ‐                                          ‐                              Total 23,313.65                   78,579.21                   265,648.98                29.58% 18,025.95                   88,942.66                   5,287.70                               (10,363.45)                 Non‐Departmental Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference City ‐ County Svcs 6,666.67                     211,666.69                410,000.00                51.63% 81,699.63                   291,699.65                (75,032.96)                           (80,032.96)                 Community Initiatives 87,136.83                   362,794.85                879,278.85                41.26% 309,399.38                623,034.22                (222,262.55)                         (260,239.37)               Transfer to Group Health 207,168.75                1,243,012.50             2,486,025.00             50.00% 186,647.50                1,119,885.00             20,521.25                             123,127.50                Transfer to Capital Project Fund 9,640.34                     35,909.00                    ‐                               100.00% 9,640.34                               35,909.00                  Transfer to Judicial ‐                                ‐                               7,067.00                     0.00%‐                                          ‐                              Total 310,612.59                1,853,383.04             3,782,370.85             49.00% 577,746.51                2,034,618.87             (267,133.92)                         (181,235.83)               Debt Service Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Debt Service ‐                               2,345,402.19             4,940,537.10             47.47% 536,132.22                2,973,502.14             (536,132.22)                         (628,099.95)               Total ‐                               2,345,402.19             4,940,537.10             47.47% 536,132.22                2,973,502.14             (536,132.22)                         (628,099.95)               Total Mar‐17 YTD Budget % of Budget Mar‐16 YTD March Difference YTD Difference Salary 1,507,224.01             6,193,330.69             13,906,163.41           44.54% 1,037,472.72             5,981,022.46             469,751.29                          212,308.23                Benefits 446,960.14                2,703,698.77             5,168,641.62             52.31% 354,107.00                2,780,788.02             92,853.14                             (77,089.25)                 Operations 688,080.10                3,821,858.74             8,719,586.38             43.83% 816,419.53                4,409,794.57             (128,339.43)                         (587,935.83)               Capital Outlay 32,436.00                   1,295,046.52             3,236,537.90             40.01% 133,587.79                682,379.73                (101,151.79)                         612,666.79                Debt Service ‐                               2,345,402.19             4,940,537.10             47.47% 536,132.22                2,973,502.14             (536,132.22)                         (628,099.95)               Total 2,674,700.25             16,359,336.91           35,971,466.41           45.48% 2,877,719.26             16,827,486.92           (203,019.01)                         (468,150.01)               Prepared by     Daniel Oakley