Loading...
March 2018 - Council Expense InformationAs of  4/13/2018 50.00 % Year Complete Executive Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 29,978.33                   123,572.97                 322,218.00                 38.35% 22,560.51                   88,060.98                   7,417.82                               35,511.99                   Benefits 3,879.78                     16,059.61                   44,131.00                   36.39% 2,693.15                     11,150.00                   1,186.63                               4,909.61                     Operations 7,052.80                     48,731.73                   105,533.00                 46.18% 44,812.81                   79,233.52                   (37,760.01)                            (30,501.79)                 Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 40,910.91                   188,364.31                 471,882.00                 39.92% 70,066.47                   178,444.50                 (29,155.56)                            9,919.81                     Legislative Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 10,417.04                   62,502.24                   125,000.00                 50.00% 10,208.38                   62,513.91                   208.66                                   (11.67)                         Benefits 707.06                         4,747.70                     10,415.00                   45.59% 781.89                         4,837.45                     (74.83)                                    (89.75)                         Operations 1,600.92                     4,126.45                     25,800.00                   15.99% 2,239.99                     4,496.71                     (639.07)                                 (370.26)                       Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 12,725.02                   71,376.39                   161,215.00                 44.27% 13,230.26                   71,848.07                   (505.24)                                 (471.68)                       Finance Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 33,622.85                   147,661.55                 306,088.00                 48.24% 32,751.22                   125,095.80                 871.63                                   22,565.75                   Benefits 5,351.99                     23,184.44                   49,281.00                   47.05% 5,161.65                     20,555.30                   190.34                                   2,629.14                     Operations 17,257.54                   130,306.07                 259,155.00                 50.28% 33,167.81                   156,368.35                 (15,910.27)                            (26,062.28)                 Capital Outlay ‐                                ‐                               25,000.00                   0.00%‐                               28,466.20                    ‐                                         (28,466.20)                 Total 56,232.38                   301,152.06                 639,524.00                 47.09% 71,080.68                   330,485.65                 (14,848.30)                            (29,333.59)                 City Clerk Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 13,761.71                   62,597.92                   126,487.00                 49.49% 13,531.77                   55,878.21                   229.94                                   6,719.71                     Benefits 2,110.67                     9,248.71                     20,169.00                   45.86% 2,095.83                     9,050.46                     14.84                                     198.25                        Operations 12,922.63                   40,452.82                   62,300.00                   64.93% 1,900.74                     30,648.22                   11,021.89                             9,804.60                     Capital Outlay ‐                               5,823.00                      ‐                               0.00%‐                                ‐                                ‐                                         5,823.00                     Total 28,795.01                   118,122.45                 208,956.00                 56.53% 17,528.34                   95,576.89                   11,266.67                             22,545.56                   HR Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 31,509.00                   116,691.69                 274,485.00                 42.51% 24,614.61                   99,303.04                   6,894.39                               17,388.65                   Benefits 5,155.13                     19,487.08                   44,794.00                   43.50% 4,001.21                     17,343.24                   1,153.92                               2,143.84                     Operations 10,807.36                   58,556.75                   87,550.00                   66.88% 11,645.33                   25,886.24                   (837.97)                                 32,670.51                   Capital Outlay ‐                               24,326.00                    ‐                               100.00%‐                                         24,326.00                   Total 47,471.49                   219,061.52                 406,829.00                 53.85% 40,261.15                   142,532.52                 7,210.34                               76,529.00                   IT Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 18,713.01                   80,423.11                   162,125.00                 49.61% 13,159.20                   46,820.01                   5,553.81                               33,603.10                   Benefits 2,643.17                     11,641.68                   23,874.00                   48.76% 1,885.14                     7,185.36                     758.03                                   4,456.32                     Operations 99,991.62                   675,472.86                 1,248,460.00             54.10% 86,278.06                   695,536.27                 13,713.56                             (20,063.41)                 Capital Outlay 11,000.00                   11,000.00                   51,000.00                   21.57% 11,000.00                             11,000.00                   Total 132,347.80                 778,537.65                 1,485,459.00             52.41% 101,322.40                 749,541.64                 31,025.40                             28,996.01                   Vehicle Maint. Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 21,510.51                   110,324.37                 243,870.00                 45.24% 25,076.43                   100,935.38                 (3,565.92)                              9,388.99                     Benefits 3,435.57                     26,368.07                   50,505.00                   52.21% 3,769.07                     26,996.40                   (333.50)                                 (628.33)                       Operations 6,339.80                     11,526.07                   104,950.00                 10.98% 9,765.72                     32,734.52                   (3,425.92)                              (21,208.45)                 Capital Outlay ‐                                ‐                               25,000.00                   0.00%‐                                          ‐                               Total 31,285.88                   148,218.51                 424,325.00                 34.93% 38,611.22                   160,666.30                 (7,325.34)                              (12,447.79)                 City of Prattville March Unaudited Expenses By Department Engineering Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 51,559.70                   215,318.54                471,460.00                45.67% 45,556.60                   203,258.82                6,003.10                               12,059.72                  Benefits 8,626.77                     49,565.72                   93,269.00                   53.14% 7,616.70                     54,949.77                   1,010.07                               (5,384.05)                   Operations 38,657.53                   163,782.64                622,346.00                26.32% 23,782.83                   192,168.22                14,874.70                             (28,385.58)                 Captial Projects ‐                                ‐                               0.00%‐                                          ‐                              Capital Outlay ‐                                ‐                               146,476.00                0.00%‐                               268,977.61                 ‐                                         (268,977.61)               Total 98,844.00                   428,666.90                1,333,551.00             32.14% 76,956.13                   719,354.42                21,887.87                             (290,687.52)               Planning Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 25,526.70                   112,211.35                247,504.00                45.34% 29,564.85                   118,306.77                (4,038.15)                              (6,095.42)                   Benefits 4,188.27                     18,824.37                   41,702.00                   45.14% 5,030.00                     21,659.03                   (841.73)                                 (2,834.66)                   Operations 36,676.28                   219,004.72                503,700.00                43.48% 69,427.76                   283,047.27                (32,751.48)                           (64,042.55)                 Captial Projects ‐                               0.00%‐                                          ‐                              Capital Outlay ‐                               6,011.00                     6,000.00                     100.18%‐                               27,839.00                    ‐                                         (21,828.00)                 Total 66,391.25                   356,051.44                798,906.00                44.57% 104,022.61                450,852.07                (37,631.36)                           (94,800.63)                 Urban Management Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 65,471.95                   310,635.86                649,770.00                47.81% 89,801.77                   365,805.57                (24,329.82)                           (55,169.71)                 Benefits 9,966.48                     66,995.93                   123,709.00                54.16% 13,982.29                   86,310.69                   (4,015.81)                              (19,314.76)                 Operations 30,325.29                   162,678.97                564,750.00                28.81% 26,985.03                   140,902.50                3,340.26                               21,776.47                  Capital Outlay ‐                                ‐                               191,500.00                0.00%‐                                ‐                                          ‐                              Total 105,763.72                540,310.76                1,529,729.00             35.32% 130,769.09                593,018.76                (25,005.37)                           (52,708.00)                 Facilities Maintenance Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 34,977.41                   140,593.41                267,205.00                52.62% 21,907.93                   85,965.96                   13,069.48                             54,627.45                  Benefits 5,014.45                     29,603.10                   47,755.00                   61.99% 3,366.77                     19,054.52                   1,647.68                               10,548.58                  Operations 7,753.59                     65,494.19                   137,500.00                47.63% 4,480.39                     23,110.07                   3,273.20                               42,384.12                  Capital Outlay 6,550.00                     6,550.00                     342,000.00                1.92% 6,550.00                               6,550.00                     Total 54,295.45                   242,240.70                794,460.00                30.49% 29,755.09                   128,130.55                24,540.36                             114,110.15                Public Works Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 34,977.41                   205,908.81                582,714.00                35.34% 19,233.21                   76,741.02                   15,744.20                             129,167.79                Benefits 5,014.45                     66,784.82                   131,966.00                50.61% 3,239.56                     18,752.35                   1,774.89                               48,032.47                  Operations 7,753.59                     68,502.87                   242,668.00                28.23% 5,419.75                     32,221.98                   2,333.84                               36,280.89                  Capital Outlay 6,550.00                      ‐                               85,000.00                   0.00% 6,550.00                                ‐                              Total 54,295.45                   341,196.50                1,042,348.00             32.73% 27,892.52                   127,715.35                26,402.93                             213,481.15                Police Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 542,770.58                2,439,604.44             5,031,675.00             48.48% 547,308.74                2,210,408.45             (4,538.16)                              229,195.99                Benefits 85,103.08                   554,255.00                1,016,170.00             54.54% 86,534.70                   516,522.77                (1,431.62)                              37,732.23                  Operations 71,506.80                   650,281.37                1,255,431.00             51.80% 61,632.48                   692,448.30                9,874.32                               (42,166.93)                 Capital Outlay 21,937.28                   157,212.28                244,837.00                64.21%‐                               167,034.00                21,937.28                             (9,821.72)                   Total 721,317.74                3,801,353.09             7,548,113.00             50.36% 695,475.92                3,586,413.52             25,841.82                             214,939.57                Fire Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 533,270.39                2,314,387.57             4,590,342.00             50.42% 507,452.98                2,112,549.03             25,817.41                             201,838.54                Benefits 90,207.74                   538,752.40                959,212.00                56.17% 83,962.81                   549,999.77                6,244.93                               (11,247.37)                 Operations 92,649.82                   571,367.68                1,163,862.00             49.09% 86,502.07                   449,979.32                6,147.75                               121,388.36                Capital Outlay ‐                               12,808.70                   116,269.00                11.02%‐                               770,293.71                 ‐                                         (757,485.01)               Total 716,127.95                3,437,316.35             6,829,685.00             50.33% 677,917.86                3,882,821.83             38,210.09                             (445,505.48)               Building Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 29,556.18                   133,543.20                292,550.00                45.65% 33,190.40                   133,959.80                (3,634.22)                              (416.60)                       Benefits 4,845.40                     25,131.85                   54,720.00                   45.93% 5,425.01                     27,878.61                   (579.61)                                 (2,746.76)                   Operations 1,657.74                     23,917.99                   63,450.00                   37.70% 1,970.33                     17,997.52                   (312.59)                                 5,920.47                     Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                          ‐                              Total 36,059.32                   182,593.04                410,720.00                44.46% 40,585.74                   179,835.93                (4,526.42)                              2,757.11                     Parks & Recreation Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 70,807.77                   298,142.16                718,665.00                41.49% 64,041.90                   279,298.65                6,765.87                               18,843.51                  Benefits 10,143.86                   58,668.44                   122,111.00                48.05% 9,192.12                     63,999.34                   951.74                                  (5,330.90)                   Operations 51,682.28                   339,796.40                1,208,999.00             28.11% 99,628.51                   309,000.48                (47,946.23)                           30,795.92                  Capital Outlay/ Capital Projects ‐                                ‐                               392,500.00                0.00% 32,436.00                   32,436.00                   (32,436.00)                           (32,436.00)                 Total 132,633.91                696,607.00                2,442,275.00             28.52% 205,298.53                684,734.47                (72,664.62)                           11,872.53                  Performing Arts Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 8,551.78                     35,281.77                   77,613.00                   45.46% 7,263.51                     28,429.29                   1,288.27                               6,852.48                     Benefits 1,234.01                     5,238.97                     16,411.00                   31.92% 1,053.49                     4,441.21                     180.52                                  797.76                        Operations 18,576.54                   57,623.47                   222,760.00                25.87% 14,996.65                   45,708.71                   3,579.89                               11,914.76                  Capital Outlay ‐                                ‐                               ‐                                          ‐                              Total 28,362.33                   98,144.21                   316,784.00                30.98% 23,313.65                   78,579.21                   5,048.68                               19,565.00                  Non‐Departmental Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference City ‐ County Svcs 13,333.34                   211,666.69                410,000.00                51.63% 6,666.67                     211,666.69                6,666.67                                ‐                              Community Initiatives 43,363.86                   335,525.78                930,624.00                36.05% 87,136.83                   362,794.85                (43,772.97)                           (27,269.07)                 Transfer to DSF ‐ One Cent 4,771,939.12             6,366,000.00             74.96%‐                                         4,771,939.12             Transfer to DSF ‐ Other ‐                               157,990.83                164,206.00                96.22%‐                                         157,990.83                Transfer to Group Health 249,375.00                1,496,250.00             2,992,500.00             50.00% 207,168.75                1,243,012.50             42,206.25                             253,237.50                Transfer to Capital Project Fund 10,576.41                   686,951.63                112,300.00                611.71% 9,640.34                     35,909.00                   936.07                                  651,042.63                Transfer to Judicial ‐                               53,093.00                   0.00%‐                                          ‐                              Total 316,648.61                7,660,324.05             11,028,723.00           69.46% 310,612.59                1,853,383.04             6,036.02                               5,806,941.01             Debt Service Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Debt Service 105,804.72                715,734.30                1,441,350.00             49.66%‐                               2,345,402.19             105,804.72                          (1,629,667.89)           Total 105,804.72                715,734.30                1,441,350.00             49.66%‐                               2,345,402.19             105,804.72                          (1,629,667.89)           Total Mar‐18 YTD Budget % of Budget Mar‐17 YTD March Difference YTD Difference Salary 1,556,982.32             6,909,400.96             14,489,771.00           47.68% 1,507,224.01             6,193,330.69             49,758.31                             716,070.27                Benefits 497,002.88                3,020,807.89             5,842,694.00             51.70% 446,960.14                2,703,698.77             50,042.74                             317,109.12                Operations 580,485.74                4,525,767.15             9,385,231.00             48.22% 688,080.10                3,821,858.74             (107,594.36)                         703,908.41                Capital Outlay 46,037.28                   223,730.98                1,625,582.00             13.76% 32,436.00                   1,295,046.52             13,601.28                             (1,071,315.54)           Debt Service 105,804.72                5,645,664.25             7,971,556.00             70.82%‐                               2,345,402.19             105,804.72                          3,300,262.06             Total 2,786,312.94             20,325,371.23           39,314,834.00           51.70% 2,674,700.25             16,359,336.91           111,612.69                          3,966,034.32             Prepared by     Daniel Oakley