Loading...
October 2019 - Council Expenditure ReportAs of  11/15/2019 8.33 % Year Complete Executive Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 23,878.02                   23,878.02                   267,156.00                 8.94% 15,049.50                   15,049.50                   8,828.52                               8,828.52                     Benefits 3,041.32                     3,041.32                     35,188.00                   8.64% 2,309.86                     2,309.86                     731.46                                   731.46                        Operations 19,219.00                   19,219.00                   162,775.00                 11.81% 11,649.60                   11,649.60                   7,569.40                               7,569.40                     Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 46,138.34                   46,138.34                   465,119.00                 9.92% 29,008.96                   29,008.96                   17,129.38                             17,129.38                   Legislative Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 10,417.04                   10,417.04                   125,000.00                 8.33% 10,417.04                   10,417.04                    ‐                                          ‐                               Benefits 711.22                         711.22                         10,299.00                   6.91% 750.24                         750.24                         (39.02)                                    (39.02)                         Operations 369.94                         369.94                         13,300.00                   2.78% 689.77                         689.77                         (319.83)                                 (319.83)                       Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 11,498.20                   11,498.20                   148,599.00                 7.74% 11,857.05                   11,857.05                   (358.85)                                 (358.85)                       Finance Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 23,702.82                   23,702.82                   360,253.00                 6.58% 16,082.31                   16,082.31                   7,620.51                               7,620.51                     Benefits 3,571.26                     3,571.26                     60,616.00                   5.89% 3,192.21                     3,192.21                     379.05                                   379.05                        Operations 13,093.34                   13,093.34                   240,360.00                 5.45% 8,585.62                     8,585.62                     4,507.72                               4,507.72                     Capital Outlay ‐                                ‐                               0.00%‐                                          ‐                               Total 40,367.42                   40,367.42                   661,229.00                 6.10% 27,860.14                   27,860.14                   12,507.28                             12,507.28                   City Clerk Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 10,569.43                   10,569.43                   139,619.00                 7.57% 6,921.64                     6,921.64                     3,647.79                               3,647.79                     Benefits 1,689.02                     1,689.02                     24,068.00                   7.02% 1,380.56                     1,380.56                     308.46                                   308.46                        Operations 3,702.54                     3,702.54                     108,240.00                 3.42% 1,892.91                     1,892.91                     1,809.63                               1,809.63                     Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 15,960.99                   15,960.99                   271,927.00                 5.87% 10,195.11                   10,195.11                   5,765.88                               5,765.88                     HR Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 23,061.84                   23,061.84                   308,420.00                 7.48% 16,148.38                   16,148.38                   6,913.46                               6,913.46                     Benefits 4,039.60                     4,039.60                     56,426.00                   7.16% 3,405.57                     3,405.57                     634.03                                   634.03                        Operations 3,016.43                     3,016.43                     72,275.00                   4.17% 4,636.19                     4,636.19                     (1,619.76)                              (1,619.76)                   Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 30,117.87                   30,117.87                   437,121.00                 6.89% 24,190.14                   24,190.14                   5,927.73                               5,927.73                     IT Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 13,899.29                   13,899.29                   195,466.00                 7.11% 10,255.56                   10,255.56                   3,643.73                               3,643.73                     Benefits 2,070.98                     2,070.98                     30,262.00                   6.84% 1,777.54                     1,777.54                     293.44                                   293.44                        Operations 70,144.93                   70,144.93                   1,371,831.00             5.11% 116,457.30                 116,457.30                 (46,312.37)                            (46,312.37)                 Capital Outlay ‐                                ‐                               200,000.00                 0.00%‐                                ‐                                ‐                                          ‐                               Total 86,115.20                   86,115.20                   1,797,559.00             4.79% 128,490.40                 128,490.40                 (42,375.20)                            (42,375.20)                 Vehicle Maint. Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 16,952.63                   16,952.63                   228,594.00                 7.42% 14,553.15                   14,553.15                   2,399.48                               2,399.48                     Benefits 2,788.08                     2,788.08                     43,245.00                   6.45% 2,847.16                     2,847.16                     (59.08)                                    (59.08)                         Operations 15,963.88                   15,963.88                   98,650.00                   16.18% 3,130.54                     3,130.54                     12,833.34                             12,833.34                   Capital Outlay ‐                                ‐                               37,000.00                   0.00%‐                                ‐                                ‐                                          ‐                               Total 35,704.59                   35,704.59                   407,489.00                 8.76% 20,530.85                   20,530.85                   15,173.74                             15,173.74                   City of Prattville October Unaudited Expenditures By Department Engineering Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 36,412.17                   36,412.17                   552,052.00                6.60% 27,490.51                   27,490.51                   8,921.66                               8,921.66                     Benefits 6,405.62                     6,405.62                     113,511.00                5.64% 5,969.60                     5,969.60                     436.02                                  436.02                        Operations 68,328.00                   68,328.00                   577,122.00                11.84% 35,294.90                   35,294.90                   33,033.10                             33,033.10                  Capital Outlay ‐                                ‐                               233,515.00                0.00%‐                                ‐                                ‐                                          ‐                              Total 111,145.79                111,145.79                1,476,200.00             7.53% 68,755.01                   68,755.01                   42,390.78                             42,390.78                  Planning Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 21,887.25                   21,887.25                   335,243.00                6.53% 7,349.03                     7,349.03                     14,538.22                             14,538.22                  Benefits 3,917.56                     3,917.56                     60,022.00                   6.53% 1,506.82                     1,506.82                     2,410.74                               2,410.74                     Operations 56,827.51                   56,827.51                   727,450.00                7.81% 10,042.54                   10,042.54                   46,784.97                             46,784.97                  Capital Outlay ‐                               ‐                              ‐                               #DIV/0!‐                                ‐                                ‐                                          ‐                              Total 82,632.32                   82,632.32                   1,122,715.00             7.36% 18,898.39                   18,898.39                   63,733.93                             63,733.93                  Urban Management Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 60,840.87                   60,840.87                   927,120.00                6.56% 38,953.01                   38,953.01                   21,887.86                             21,887.86                  Benefits 9,684.98                     9,684.98                     167,371.00                5.79% 7,347.18                     7,347.18                     2,337.80                               2,337.80                     Operations 56,436.75                   56,436.75                   493,000.00                11.45% 53,769.22                   53,769.22                   2,667.53                               2,667.53                     Capital Outlay ‐                                ‐                               30,000.00                   0.00%‐                                ‐                                ‐                                          ‐                              Total 126,962.60                126,962.60                1,617,491.00             7.85% 100,069.41                100,069.41                26,893.19                             26,893.19                  Facilities Maintenance Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 27,144.68                   27,144.68                   363,631.00                7.46% 18,397.22                   18,397.22                   8,747.46                               8,747.46                     Benefits 4,145.65                     4,145.65                     59,507.00                   6.97% 3,331.32                     3,331.32                     814.33                                  814.33                        Operations 24,828.50                   24,828.50                   237,050.00                10.47% 22,782.81                   22,782.81                   2,045.69                               2,045.69                     Capital Outlay ‐                                ‐                               35,000.00                   0.00%‐                                ‐                                ‐                                          ‐                              Total 56,118.83                   56,118.83                   695,188.00                8.07% 44,511.35                   44,511.35                   11,607.48                             11,607.48                  Public Works Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 21,231.57                   21,231.57                   312,653.00                6.79% 14,763.41                   14,763.41                   6,468.16                               6,468.16                     Benefits 3,650.88                     3,650.88                     58,569.00                   6.23% 3,019.43                     3,019.43                     631.45                                  631.45                        Operations 17,221.44                   17,221.44                   224,718.00                7.66% 22,352.88                   22,352.88                   (5,131.44)                              (5,131.44)                   Capital Outlay ‐                                ‐                               225,000.00                0.00%‐                                ‐                                ‐                                          ‐                              Total 42,103.89                   42,103.89                   820,940.00                5.13% 40,135.72                   40,135.72                   1,968.17                               1,968.17                     Police Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 394,291.34                394,291.34                5,557,043.00             7.10% 268,287.06                268,287.06                126,004.28                          126,004.28                Benefits 63,920.78                   63,920.78                   1,044,030.00             6.12% 55,714.91                   55,714.91                   8,205.87                               8,205.87                     Operations 180,380.33                180,380.33                1,262,714.00             14.29% 177,688.93                177,688.93                2,691.40                               2,691.40                     Capital Outlay ‐                                ‐                               133,600.00                0.00%‐                                ‐                                ‐                                          ‐                              Total 638,592.45                638,592.45                7,997,387.00             7.99% 501,690.90                501,690.90                136,901.55                          136,901.55                Fire Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 394,220.49                394,220.49                5,047,501.00             7.81% 252,990.54                252,990.54                141,229.95                          141,229.95                Benefits 66,077.41                   66,077.41                   1,012,418.00             6.53% 53,970.34                   53,970.34                   12,107.07                             12,107.07                  Operations 107,976.41                107,976.41                1,044,321.00             10.34% 93,744.33                   93,744.33                   14,232.08                             14,232.08                  Capital Outlay ‐                                ‐                                ‐                               #DIV/0!‐                                ‐                                ‐                                          ‐                              Total 568,274.31                568,274.31                7,104,240.00             8.00% 400,705.21                400,705.21                167,569.10                          167,569.10                Building Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 18,283.20                   18,283.20                   244,473.00                7.48% 16,935.60                   16,935.60                   1,347.60                               1,347.60                     Benefits 3,185.03                     3,185.03                     49,214.00                   6.47% 3,595.33                     3,595.33                     (410.30)                                 (410.30)                       Operations 16,713.19                   16,713.19                   55,450.00                   30.14% 4,934.12                     4,934.12                     11,779.07                             11,779.07                  Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 38,181.42                   38,181.42                   349,137.00                10.94% 25,465.05                   25,465.05                   12,716.37                             12,716.37                  Parks & Recreation Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 75,191.93                   75,191.93                   1,005,486.00             7.48% 44,247.06                   44,247.06                   30,944.87                             30,944.87                  Benefits 11,337.92                   11,337.92                   169,471.00                6.69% 7,937.92                     7,937.92                     3,400.00                               3,400.00                     Operations 133,965.01                133,965.01                1,174,070.00             11.41% 97,692.93                   97,692.93                   36,272.08                             36,272.08                  Capital Outlay/ Capital Projects ‐                                ‐                               200,400.00                0.00%‐                                ‐                                ‐                                          ‐                              Total 220,494.86                220,494.86                2,549,427.00             8.65% 149,877.91                149,877.91                70,616.95                             70,616.95                  Performing Arts Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 8,402.40                     8,402.40                     106,627.00                7.88% 4,407.20                     4,407.20                     3,995.20                               3,995.20                     Benefits 1,202.21                     1,202.21                     15,770.00                   7.62% 776.48                        776.48                        425.73                                  425.73                        Operations 10,425.00                   10,425.00                   266,690.00                3.91% 8,691.89                     8,691.89                     1,733.11                               1,733.11                     Capital Outlay ‐                                ‐                                ‐                               #DIV/0!‐                                ‐                                ‐                                          ‐                              Total 20,029.61                   20,029.61                   389,087.00                5.15% 13,875.57                   13,875.57                   6,154.04                               6,154.04                     Non‐Departmental Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference City ‐ County Svcs 80,000.00                   80,000.00                   425,000.00                18.82% 90,833.34                   90,833.34                   (10,833.34)                           (10,833.34)                 Community Initiatives 55,935.19                   55,935.19                   979,274.00                5.71% 64,139.02                   64,139.02                   (8,203.83)                              (8,203.83)                   Transfer to DSF ‐ One Cent 1,925,105.53             1,925,105.53             3,394,441.00             56.71% 1,880,628.47             1,880,628.47             44,477.06                             44,477.06                  Transfer to DSF ‐ Other 225,490.92                225,490.92                664,029.00                33.96% 84,218.42                   84,218.42                   141,272.50                          141,272.50                Transfer to Group Health 249,583.33                249,583.33                2,995,000.00             8.33% 247,167.00                247,167.00                2,416.33                               2,416.33                     Transfer to Capital Project Fund 10,772.24                   10,772.24                   75,000.00                   14.36% 19,462.24                   19,462.24                   (8,690.00)                              (8,690.00)                   Transfer to Gas Tax Fund ‐                                ‐                               22,000.00                   0.00%‐                                ‐                                ‐                                          ‐                              Transfer to Judicial ‐                               121,794.00                0.00%‐                                ‐                                ‐                                          ‐                              Total 2,546,887.21             2,546,887.21             8,676,538.00             29.35% 2,386,448.49             2,386,448.49             160,438.72                          160,438.72                Debt Service Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Debt Service 123,124.16                123,124.16                1,728,000.00             7.13% 116,478.07                116,478.07                6,646.09                               6,646.09                     Total 123,124.16                123,124.16                1,728,000.00             7.13% 116,478.07                116,478.07                6,646.09                               6,646.09                     Total Oct‐19 YTD Budget % of Budget Oct‐18 YTD October Difference YTD Difference Salary 1,180,386.97             1,180,386.97             16,076,337.00           7.34% 783,248.22                783,248.22                397,138.75                          397,138.75                Benefits 441,022.85                441,022.85                6,004,987.00             7.34% 405,999.47                405,999.47                35,023.38                             35,023.38                  Operations 945,319.63                945,319.63                9,753,084.00             9.69% 848,471.08                848,471.08                96,848.55                             96,848.55                  Capital Outlay ‐                                ‐                               1,094,515.00             0.00%‐                                ‐                                ‐                                          ‐                              Debt Service 2,273,720.61             2,273,720.61             5,786,470.00             39.29% 2,081,324.96             2,081,324.96             192,395.65                          192,395.65                Total 4,840,450.06             4,840,450.06             38,715,393.00           12.50% 4,119,043.73             4,119,043.73             721,406.33                          721,406.33                Prepared by     Daniel Oakley