Loading...
May 2019 - Council Expense InformationAs of  6/14/2019 66.67 % Year Complete Executive May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 23,572.97                   176,656.94                 322,551.00                 54.77% 20,019.08                   163,598.26                 3,553.89                               13,058.68                   Benefits 3,047.29                     22,277.18                   45,781.00                   48.66% 2,514.19                     21,042.03                   533.10                                   1,235.15                     Operations 8,807.36                     79,439.62                   137,333.00                 57.84% 3,540.90                     57,820.64                   5,266.46                               21,618.98                   Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 35,427.62                   278,373.74                 505,665.00                 55.05% 26,074.17                   242,460.93                 9,353.45                               35,912.81                   Legislative May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 10,417.04                   83,336.32                   125,000.00                 66.67% 10,417.04                   83,336.32                    ‐                                          ‐                               Benefits 754.40                         6,222.65                     10,297.00                   60.43% 807.96                         6,310.32                     (53.56)                                    (87.67)                         Operations 2,829.08                     11,182.22                   13,600.00                   82.22% 526.74                         6,053.19                     2,302.34                               5,129.03                     Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 14,000.52                   100,741.19                 148,897.00                 67.66% 11,751.74                   95,699.83                   2,248.78                               5,041.36                     Finance May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 22,908.90                   185,243.39                 334,879.00                 55.32% 21,937.77                   192,688.96                 971.13                                   (7,445.57)                   Benefits 3,782.30                     31,287.30                   56,680.00                   55.20% 3,378.47                     30,119.16                   403.83                                   1,168.14                     Operations 30,017.73                   175,839.05                 242,460.00                 72.52% 9,024.96                     172,368.12                 20,992.77                             3,470.93                     Capital Outlay ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 56,708.93                   392,369.74                 634,019.00                 61.89% 34,341.20                   395,176.24                 22,367.73                             (2,806.50)                   City Clerk May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 10,588.04                   83,741.65                   136,748.00                 61.24% 9,939.50                     82,350.77                   648.54                                   1,390.88                     Benefits 1,671.55                     13,792.52                   22,759.00                   60.60% 1,483.43                     12,173.46                   188.12                                   1,619.06                     Operations 2,141.83                     19,819.50                   49,250.00                   40.24% 3,244.88                     48,065.48                   (1,103.05)                              (28,245.98)                 Capital Outlay ‐                                ‐                                ‐                               0.00%‐                               365.00                          ‐                                         (365.00)                       Total 14,401.42                   117,353.67                 208,757.00                 56.22% 14,667.81                   142,954.71                 (266.39)                                 (25,601.04)                 HR May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 22,526.46                   180,391.75                 283,708.00                 63.58% 21,269.46                   159,269.41                 1,257.00                               21,122.34                   Benefits 3,974.30                     32,840.84                   52,021.00                   63.13% 3,471.82                     26,415.31                   502.48                                   6,425.53                     Operations 1,060.95                     41,052.36                   82,050.00                   50.03% 5,975.89                     68,127.26                   (4,914.94)                              (27,074.90)                 Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 27,561.71                   254,284.95                 417,779.00                 60.87% 30,717.17                   253,811.98                 (3,155.46)                              472.97                        IT May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 13,202.31                   107,427.35                 168,121.00                 63.90% 12,679.00                   105,489.88                 523.31                                   1,937.47                     Benefits 1,974.39                     16,528.59                   26,061.00                   63.42% 1,799.89                     15,182.21                   174.50                                   1,346.38                     Operations 47,803.88                   953,589.41                 1,426,295.00             66.86% 92,897.31                   831,822.69                 (45,093.43)                            121,766.72                Capital Outlay ‐                               33,515.00                   109,000.00                 30.75%‐                               11,000.00                    ‐                                         22,515.00                   Total 62,980.58                   1,111,060.35             1,729,477.00             64.24% 107,376.20                 963,494.78                 (44,395.62)                            147,565.57                Vehicle Maint. May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 21,043.47                   162,467.35                 253,371.00                 64.12% 14,678.37                   139,330.19                 6,365.10                               23,137.16                   Benefits 3,023.61                     32,828.75                   50,796.00                   64.63% 2,570.79                     31,116.23                   452.82                                   1,712.52                     Operations 7,706.18                     35,451.94                   103,450.00                 34.27% 2,538.15                     13,026.14                   5,168.03                               22,425.80                   Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 31,773.26                   230,748.04                 407,617.00                 56.61% 19,787.31                   183,472.56                 11,985.95                             47,275.48                   City of Prattville May Unaudited Expenditures By Department Engineering May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 35,645.67                   302,498.92                488,503.00                61.92% 36,817.96                   286,347.71                (1,172.29)                              16,151.21                  Benefits 6,443.64                     67,721.11                   102,847.00                65.85% 6,581.20                     61,813.10                   (137.56)                                 5,908.01                     Operations 38,429.00                   234,514.80                546,500.00                42.91% 44,739.43                   223,032.04                (6,310.43)                              11,482.76                  Capital Projects ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 80,518.31                   604,734.83                1,137,850.00             53.15% 88,138.59                   571,192.85                (7,620.28)                              33,541.98                  Planning May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 15,197.61                   127,623.66                230,589.00                55.35% 14,349.35                   143,361.98                848.26                                  (15,738.32)                 Benefits 2,694.08                     23,786.79                   40,685.00                   58.47% 2,457.27                     24,037.82                   236.81                                  (251.03)                       Operations 34,692.64                   276,199.11                502,450.00                54.97% 34,443.08                   286,333.62                249.56                                  (10,134.51)                 Capital Projects ‐                                ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Capital Outlay ‐                                ‐                               32,000.00                   0.00%‐                               6,011.00                      ‐                                         (6,011.00)                   Total 52,584.33                   427,609.56                805,724.00                53.07% 51,249.70                   459,744.42                1,334.63                               (32,134.86)                 Urban Management May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 60,088.19                   445,414.41                843,847.00                52.78% 58,110.56                   424,557.53                1,977.63                               20,856.88                  Benefits 9,473.02                     87,070.14                   154,697.00                56.28% 8,831.51                     83,417.44                   641.51                                  3,652.70                     Operations 35,180.08                   292,708.23                530,750.00                55.15% 39,332.23                   224,893.81                (4,152.15)                              67,814.42                  Capital Outlay 41,845.00                   41,845.00                   63,000.00                   66.42%‐                                ‐                               41,845.00                             41,845.00                  Total 146,586.29                867,037.78                1,592,294.00             54.45% 106,274.30                732,868.78                40,311.99                             134,169.00                Facilities Maintenance May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 25,784.86                   207,201.82                330,843.00                62.63% 22,024.73                   184,707.65                3,760.13                               22,494.17                  Benefits 3,944.79                     35,611.40                   54,394.00                   65.47% 3,303.09                     36,081.66                   641.70                                  (470.26)                       Operations 5,613.68                     94,488.95                   170,000.00                55.58% 18,241.29                   88,556.87                   (12,627.61)                           5,932.08                     Capital Outlay 11,510.00                   16,362.56                   163,000.00                10.04%‐                               6,550.00                     11,510.00                             9,812.56                     Total 46,853.33                   353,664.73                718,237.00                49.24% 43,569.11                   315,896.18                3,284.22                               37,768.55                  Public Works May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 18,414.16                   163,037.85                268,409.00                60.74% 19,587.64                   253,722.51                (1,173.48)                              (90,684.66)                 Benefits 3,205.23                     31,564.71                   50,333.00                   62.71% 3,232.29                     74,376.40                   (27.06)                                   (42,811.69)                 Operations 12,779.38                   153,243.32                235,214.00                65.15% 16,219.00                   90,703.75                   (3,439.62)                              62,539.57                  Capital Outlay (3,390.00)                   (3,390.00)                   408,399.00                 ‐0.83%‐                               6,550.00                     (3,390.00)                              (9,940.00)                   Total 31,008.77                   344,455.88                962,355.00                35.79% 39,038.93                   425,352.66                (8,030.16)                              (80,896.78)                 Police May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 380,056.43                3,056,392.06             5,205,663.00             58.71% 353,753.79                3,146,228.59             26,302.64                             (89,836.53)                 Benefits 63,639.50                   613,478.87                1,003,222.00             61.15% 59,311.58                   668,307.37                4,327.92                               (54,828.50)                 Operations 110,829.37                857,967.17                1,293,071.00             66.35% 83,842.61                   802,682.34                26,986.76                             55,284.83                  Capital Outlay 250.00                        122,314.38                130,862.00                93.47%‐                               157,212.28                250.00                                  (34,897.90)                 Total 554,775.30                4,650,152.48             7,632,818.00             60.92% 496,907.98                4,774,430.58             57,867.32                             (124,278.10)               Fire May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 350,382.61                2,876,999.98             4,704,544.00             61.15% 350,269.78                3,017,760.39             112.83                                  (140,760.41)               Benefits 61,196.31                   626,065.04                972,204.00                64.40% 61,378.97                   657,650.65                (182.66)                                 (31,585.61)                 Operations 104,023.59                670,070.77                1,123,052.00             59.67% 68,768.73                   687,938.71                35,254.86                             (17,867.94)                 Capital Outlay 250.00                        249,980.00                250,000.00                99.99%‐                               35,936.25                   250.00                                  214,043.75                Total 515,852.51                4,423,115.79             7,049,800.00             62.74% 480,417.48                4,399,286.00             35,435.03                             23,829.79                  Building May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 23,528.19                   188,813.96                300,082.00                62.92% 22,671.82                   177,431.11                856.37                                  11,382.85                  Benefits 4,168.69                     37,114.35                   59,832.00                   62.03% 3,794.69                     32,367.31                   374.00                                  4,747.04                     Operations 2,636.08                     30,136.62                   63,200.00                   47.68% 1,745.34                     32,110.49                   890.74                                  (1,973.87)                   Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 30,332.96                   256,064.93                423,114.00                60.52% 28,211.85                   241,908.91                2,121.11                               14,156.02                  Parks & Recreation May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 74,534.40                   506,730.37                940,078.00                53.90% 59,611.24                   410,770.85                14,923.16                             95,959.52                  Benefits 10,994.80                   93,176.70                   140,994.00                66.09% 9,004.07                     75,316.95                   1,990.73                               17,859.75                  Operations 118,860.82                630,985.79                1,343,500.00             46.97% 108,051.57                507,915.06                10,809.25                             123,070.73                Capital Outlay/ Capital Projects ‐                               494,760.83                754,820.00                65.55% 58,162.22                   58,162.22                   (58,162.22)                           436,598.61                Total 204,390.02                1,725,653.69             3,179,392.00             54.28% 234,829.10                1,052,165.08             (30,439.08)                           673,488.61                Performing Arts May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 6,961.02                     57,036.19                   91,929.00                   62.04% 6,592.09                     48,566.55                   368.93                                  8,469.64                     Benefits 1,068.42                     8,922.34                     13,441.00                   66.38% 962.59                        7,170.71                     105.83                                  1,751.63                     Operations 24,848.58                   114,268.57                258,595.00                44.19% 14,198.19                   93,326.94                   10,650.39                             20,941.63                  Capital Outlay ‐                               10,514.00                   17,500.00                   60.08%‐                                ‐                                ‐                                         10,514.00                  Total 32,878.02                   190,741.10                381,465.00                50.00% 21,752.87                   149,064.20                11,125.15                             41,676.90                  Non‐Departmental May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference City ‐ County Svcs 6,666.66                     312,500.02                410,000.00                76.22%‐                               295,833.36                6,666.66                               16,666.66                  Community Initiatives 71,507.30                   578,765.34                978,094.00                59.17% 72,399.25                   461,350.46                (891.95)                                 117,414.88                Transfer to DSF ‐ One Cent ‐                               3,335,185.58             3,493,844.00             95.46%‐                               4,955,997.97              ‐                                         (1,620,812.39)           Transfer to DSF ‐ Other ‐                               116,093.42                331,969.00                34.97%‐                               157,990.83                 ‐                                         (41,897.41)                 Transfer to Group Health 247,167.00                1,977,336.00             2,966,000.00             66.67% 249,375.00                1,995,000.00             (2,208.00)                              (17,664.00)                 Transfer to Capital Project Fund 279,691.44                363,295.88                451,255.00                80.51% 11,726.97                   709,092.60                267,964.47                          (345,796.72)               Transfer to Gas Tax Fund 188,150.00                0.00%‐                                          ‐                              Transfer to Judicial ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Total 605,032.40                6,683,176.24             8,819,312.00             75.78% 333,501.22                8,575,265.22             271,531.18                          (1,892,088.98)           Debt Service May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Debt Service 118,322.54                1,106,847.28             1,530,500.00             72.32% 44,862.61                   876,767.02                73,459.93                             230,080.26                Total 118,322.54                1,106,847.28             1,530,500.00             72.32% 44,862.61                   876,767.02                73,459.93                             230,080.26                Total May‐19 YTD Budget % of Budget May‐18 YTD May Difference YTD Difference Salary 1,114,852.33             8,911,013.97             15,028,865.00           59.29% 1,054,729.18             9,019,518.66             60,123.15                             (108,504.69)               Benefits 432,223.32                3,757,625.28             5,823,044.00             64.53% 424,258.81                3,857,898.13             7,964.51                               (100,272.85)               Operations 946,125.63                5,925,518.67             10,148,269.00           58.39% 631,456.52                5,701,053.57             314,669.11                          224,465.10                Capital Outlay 50,465.00                   965,901.77                1,928,581.00             50.08% 58,162.22                   281,786.75                (7,697.22)                              684,115.02                Debt Service 118,322.54                4,558,126.28             5,356,313.00             85.10% 44,862.61                   5,990,755.82             73,459.93                             (1,432,629.54)           Total 2,661,988.82             24,118,185.97           38,285,072.00           63.00% 2,213,469.34             24,851,012.93           448,519.48                          (732,826.96)               Prepared by     Daniel Oakley