Loading...
June 2018 - Council Expense InformationAs of  7/13/2018 75.00 % Year Complete Executive Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 19,961.75                   183,560.01                 322,218.00                 56.97% 15,040.34                   140,425.14                 4,921.41                               43,134.87                   Benefits 2,489.18                     23,531.21                   44,131.00                   53.32% 1,787.51                     16,996.40                   701.67                                   6,534.81                     Operations 3,178.33                     60,998.97                   105,533.00                 57.80% 1,402.84                     84,797.70                   1,775.49                               (23,798.73)                 Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 25,629.26                   268,090.19                 471,882.00                 56.81% 18,230.69                   242,219.24                 7,398.57                               25,870.95                   Legislative Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 10,417.04                   93,753.36                   125,000.00                 75.00% 10,417.04                   94,759.78                    ‐                                         (1,006.42)                   Benefits 802.26                         7,112.58                     10,415.00                   68.29% 776.85                         7,116.10                     25.41                                     (3.52)                           Operations 796.47                         6,849.66                     25,800.00                   26.55% 1,934.36                     7,260.25                     (1,137.89)                              (410.59)                       Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 12,015.77                   107,715.60                 161,215.00                 66.81% 13,128.25                   109,136.13                 (1,112.48)                              (1,420.53)                   Finance Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 21,840.31                   214,529.27                 293,988.00                 72.97% 21,952.30                   199,250.28                 (111.99)                                 15,278.99                   Benefits 3,361.36                     33,480.52                   47,381.00                   70.66% 3,461.34                     31,431.04                   (99.98)                                    2,049.48                     Operations 15,513.76                   187,881.88                 259,155.00                 72.50% 29,635.53                   204,192.58                 (14,121.77)                            (16,310.70)                 Capital Outlay ‐                                ‐                               25,000.00                   0.00%‐                               28,466.20                    ‐                                         (28,466.20)                 Total 40,715.43                   435,891.67                 625,524.00                 69.68% 55,049.17                   463,340.10                 (14,333.74)                            (27,448.43)                 City Clerk Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 9,813.37                     92,164.14                   126,487.00                 72.86% 9,660.08                     90,596.37                   153.29                                   1,567.77                     Benefits 1,456.62                     13,630.08                   20,169.00                   67.58% 1,432.32                     13,664.69                   24.30                                     (34.61)                         Operations 4,401.86                     52,467.34                   62,300.00                   84.22% 1,096.49                     35,447.83                   3,305.37                               17,019.51                   Capital Outlay ‐                               365.00                          ‐                               100.00%‐                                ‐                                ‐                                         365.00                        Total 15,671.85                   158,626.56                 208,956.00                 75.91% 12,188.89                   139,708.89                 3,482.96                               18,917.67                   HR Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 21,558.95                   180,828.36                 274,485.00                 65.88% 16,692.00                   157,267.60                 4,866.95                               23,560.76                   Benefits 3,497.72                     29,913.03                   44,794.00                   66.78% 2,669.45                     25,851.56                   828.27                                   4,061.47                     Operations 10,436.05                   78,563.31                   87,550.00                   89.74% 8,831.93                     47,810.30                   1,604.12                               30,753.01                   Capital Outlay ‐                                ‐                                ‐                               100.00%‐                                ‐                                          ‐                               Total 35,492.72                   289,304.70                 406,829.00                 71.11% 28,193.38                   230,929.46                 7,299.34                               58,375.24                   IT Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 12,476.08                   117,965.96                 162,125.00                 72.76% 12,254.75                   85,207.80                   221.33                                   32,758.16                   Benefits 1,763.57                     16,945.78                   23,874.00                   70.98% 1,737.13                     12,356.41                   26.44                                     4,589.37                     Operations 70,804.15                   902,626.84                 1,182,681.00             76.32% 80,464.16                   942,528.99                 (9,660.01)                              (39,902.15)                 Capital Outlay 39,234.92                   50,234.92                   55,999.00                   89.71% 16,045.76                   16,045.76                   23,189.16                             34,189.16                   Total 124,278.72                 1,087,773.50             1,424,679.00             76.35% 110,501.80                 1,056,138.96             13,776.92                             31,634.54                   Vehicle Maint. Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 16,884.30                   156,214.49                 243,870.00                 64.06% 18,720.73                   150,640.73                 (1,836.43)                              5,573.76                     Benefits 2,649.72                     33,765.95                   50,505.00                   66.86% 3,376.10                     36,575.77                   (726.38)                                 (2,809.82)                   Operations 14,928.79                   27,954.93                   104,950.00                 26.64% 10,430.22                   70,711.63                   4,498.57                               (42,756.70)                 Capital Outlay ‐                                ‐                               25,000.00                   0.00%‐                                          ‐                               Total 34,462.81                   217,935.37                 424,325.00                 51.36% 32,527.05                   257,928.13                 1,935.76                               (39,992.76)                 City of Prattville June Unaudited Expenses By Department Engineering Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 36,449.89                   322,797.60                471,460.00                68.47% 31,004.32                   312,073.01                5,445.57                               10,724.59                  Benefits 6,072.92                     67,886.02                   93,269.00                   72.79% 6,150.43                     72,345.49                   (77.51)                                   (4,459.47)                   Operations 31,376.92                   254,408.96                622,346.00                40.88% 14,463.03                   233,198.22                16,913.89                             21,210.74                  Captial Projects ‐                                ‐                                ‐                               0.00%‐                                          ‐                              Capital Outlay ‐                                ‐                               146,476.00                0.00%‐                               268,977.61                 ‐                                         (268,977.61)               Total 73,899.73                   645,092.58                1,333,551.00             48.37% 51,617.78                   886,594.33                22,281.95                             (241,501.75)               Planning Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 22,031.32                   165,393.30                247,504.00                66.82% 20,075.67                   188,500.12                1,955.65                               (23,106.82)                 Benefits 2,803.92                     26,841.74                   41,702.00                   64.37% 3,415.10                     32,500.31                   (611.18)                                 (5,658.57)                   Operations 38,250.78                   324,584.40                503,700.00                64.44% 41,425.79                   328,122.31                (3,175.01)                              (3,537.91)                   Captial Projects ‐                                ‐                                ‐                               0.00%‐                                          ‐                              Capital Outlay ‐                               6,011.00                     6,000.00                     100.18%‐                               27,839.00                    ‐                                         (21,828.00)                 Total 63,086.02                   522,830.44                798,906.00                65.44% 64,916.56                   576,961.74                (1,830.54)                              (54,131.30)                 Urban Management Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 58,224.28                   482,781.81                649,770.00                74.30% 71,098.16                   599,131.58                (12,873.88)                           (116,349.77)               Benefits 8,334.28                     91,751.72                   123,709.00                74.17% 12,492.61                   120,346.61                (4,158.33)                              (28,594.89)                 Operations 54,471.17                   279,364.98                564,750.00                49.47% 31,391.58                   245,181.42                23,079.59                             34,183.56                  Capital Outlay ‐                                ‐                               191,500.00                0.00% 8,397.52                     8,397.52                     (8,397.52)                              (8,397.52)                   Total 121,029.73                853,898.51                1,529,729.00             55.82% 123,379.87                973,057.13                (2,350.14)                              (119,158.62)               Facilities Maintenance Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 22,486.56                   207,194.21                267,205.00                77.54% 14,322.96                   136,192.26                8,163.60                               71,001.95                  Benefits 3,224.65                     39,306.31                   47,755.00                   82.31% 2,549.20                     26,389.41                   675.45                                  12,916.90                  Operations 3,729.35                     92,286.22                   137,500.00                67.12% 4,657.65                     40,640.97                   (928.30)                                 51,645.25                  Capital Outlay 5,548.97                     12,098.97                   372,000.00                3.25%‐                               21,868.00                   5,548.97                               (9,769.03)                   Total 34,989.53                   350,885.71                824,460.00                42.56% 21,529.81                   225,090.64                13,459.72                             125,795.07                Public Works Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 19,627.66                   273,350.17                582,714.00                46.91% 17,107.85                   127,973.95                2,519.81                               145,376.22                Benefits 3,117.62                     77,494.02                   131,966.00                58.72% 3,066.20                     26,801.01                   51.42                                    50,693.01                  Operations 5,798.24                     96,501.99                   242,668.00                39.77% 12,321.18                   57,830.91                   (6,522.94)                              38,671.08                  Capital Outlay ‐                               6,550.00                     85,000.00                   7.71% 10,011.00                   33,346.00                   (10,011.00)                           (26,796.00)                 Total 28,543.52                   453,896.18                1,042,348.00             43.55% 42,506.23                   245,951.87                (13,962.71)                           207,944.31                Police Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 350,275.52                3,496,504.11             5,031,675.00             69.49% 351,694.79                3,431,393.44             (1,419.27)                              65,110.67                  Benefits 56,116.95                   724,424.32                1,016,170.00             71.29% 62,631.59                   702,205.90                (6,514.64)                              22,218.42                  Operations 74,722.07                   877,404.41                1,255,431.00             69.89% 43,223.04                   897,585.12                31,499.03                             (20,180.71)                 Capital Outlay 27,055.00                   184,267.28                283,134.00                65.08%‐                               167,034.00                27,055.00                             17,233.28                  Total 508,169.54                5,282,600.12             7,586,410.00             69.63% 457,549.42                5,198,218.46             50,620.12                             84,381.66                  Fire Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 360,909.76                3,378,670.15             4,590,342.00             73.60% 335,015.44                3,288,986.50             25,894.32                             89,683.65                  Benefits 58,336.06                   715,986.71                959,212.00                74.64% 63,711.69                   736,322.12                (5,375.63)                              (20,335.41)                 Operations 99,653.57                   787,592.28                1,163,862.00             67.67% 61,717.91                   673,086.15                37,935.66                             114,506.13                Capital Outlay ‐                               35,936.25                   138,752.00                25.90%‐                               775,570.42                 ‐                                         (739,634.17)               Total 518,899.39                4,918,185.39             6,852,168.00             71.78% 460,445.04                5,473,965.19             58,454.35                             (555,779.80)               Building Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 22,384.00                   199,815.11                292,550.00                68.30% 22,264.00                   211,490.04                120.00                                  (11,674.93)                 Benefits 3,638.10                     36,005.41                   54,720.00                   65.80% 3,973.17                     39,753.54                   (335.07)                                 (3,748.13)                   Operations 4,805.88                     36,916.37                   63,450.00                   58.18% 1,883.81                     27,828.70                   2,922.07                               9,087.67                     Capital Outlay ‐                                ‐                                ‐                               0.00%‐                               40,000.00                    ‐                                         (40,000.00)                 Total 30,827.98                   272,736.89                410,720.00                66.40% 28,120.98                   319,072.28                2,707.00                               (46,335.39)                 Parks & Recreation Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 75,511.17                   486,282.02                718,665.00                67.66% 73,214.39                   470,373.21                2,296.78                               15,908.81                  Benefits 9,768.44                     85,085.39                   122,111.00                69.68% 9,784.82                     88,688.28                   (16.38)                                   (3,602.89)                   Operations 65,722.27                   573,637.33                1,161,416.00             49.39% 62,189.35                   477,564.66                3,532.92                               96,072.67                  Capital Outlay/ Capital Projects 78,953.87                   137,116.09                440,083.00                31.16% 118,858.41                78,953.87                             18,257.68                  Total 229,955.75                1,282,120.83             2,442,275.00             52.50% 145,188.56                1,155,484.56             84,767.19                             126,636.27                Performing Arts Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 5,705.25                     54,271.80                   77,613.00                   69.93% 5,316.83                     46,105.56                   388.42                                  8,166.24                     Benefits 830.06                        8,000.77                     16,411.00                   48.75% 775.41                        6,857.86                     54.65                                    1,142.91                     Operations 18,896.40                   112,223.34                222,760.00                50.38% 26,035.09                   105,355.01                (7,138.69)                              6,868.33                     Capital Outlay ‐                                ‐                                ‐                               ‐                                          ‐                              Total 25,431.71                   174,495.91                316,784.00                55.08% 32,127.33                   158,318.43                (6,695.62)                              16,177.48                  Non‐Departmental Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference City ‐ County Svcs 13,333.32                   309,166.68                410,000.00                75.41% 13,333.32                   309,166.68                 ‐                                          ‐                              Community Initiatives 49,049.23                   510,399.69                930,624.00                54.84% 40,407.41                   471,172.27                8,641.82                               39,227.42                  Transfer to DSF ‐ One Cent ‐                               4,955,997.97             6,366,000.00             77.85%‐                                         4,955,997.97             Transfer to DSF ‐ Other ‐                               157,990.83                164,206.00                96.22%‐                                         157,990.83                Transfer to Group Health 249,375.00                2,244,375.00             2,992,500.00             75.00% 207,168.75                1,864,518.75             42,206.25                             379,856.25                Transfer to Capital Project Fund 10,809.57                   719,902.17                112,300.00                641.05% 9,406.91                     244,840.40                1,402.66                               475,061.77                Transfer to Judicial ‐                               53,093.00                   0.00%‐                                          ‐                              Total 322,567.12                8,897,832.34             11,028,723.00           80.68% 270,316.39                2,889,698.10             52,250.73                             6,008,134.24             Debt Service Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Debt Service 163,496.23                1,040,263.25             1,441,350.00             72.17%‐                               1,280,125.15             163,496.23                          (239,861.90)               Total 163,496.23                1,040,263.25             1,441,350.00             72.17%‐                               1,280,125.15             163,496.23                          (239,861.90)               Total Jun‐18 YTD Budget % of Budget Jun‐17 YTD June Difference YTD Difference Salary 1,086,557.21             10,106,075.87           14,477,671.00           69.80% 1,045,851.65             9,730,367.37             40,705.56                             375,708.50                Benefits 417,638.43                4,275,536.56             5,840,794.00             73.20% 390,959.67                3,860,721.25             26,678.76                             414,815.31                Operations 590,678.18                6,291,731.75             9,271,869.00             67.86% 496,251.60                5,504,322.10             94,426.58                             787,409.65                Capital Outlay 150,792.76                432,579.51                1,768,944.00             24.45% 34,454.28                   1,506,402.92             116,338.48                          (1,073,823.41)           Debt Service 163,496.23                6,154,252.05             7,971,556.00             77.20%‐                               1,280,125.15             163,496.23                          4,874,126.90             Total 2,409,162.81             27,260,175.74           39,330,834.00           69.31% 1,967,517.20             21,881,938.79           441,645.61                          5,378,236.95             Prepared by     Daniel Oakley