Loading...
July 2019 - General Fund Expense InformationAs of  8/20/2019 83.33 % Year Complete Executive Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 21,958.25                   221,371.28                 322,551.00                 68.63% 19,996.82                   203,556.83                 1,961.43                               17,814.45                   Benefits 2,742.53                     27,915.70                   45,781.00                   60.98% 2,493.69                     26,024.90                   248.84                                   1,890.80                     Operations 3,532.29                     86,702.35                   137,333.00                 63.13% 3,795.87                     64,794.84                   (263.58)                                 21,907.51                   Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 28,233.07                   335,989.33                 505,665.00                 66.45% 26,286.38                   294,376.57                 1,946.69                               41,612.76                   Legislative Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 10,417.04                   104,170.40                 125,000.00                 83.34% 10,417.04                   104,170.40                  ‐                                          ‐                               Benefits 711.22                         7,684.73                     10,297.00                   74.63% 707.06                         7,819.64                     4.16                                       (134.91)                       Operations 125.00                         11,447.35                   13,600.00                   84.17% 259.09                         7,108.75                     (134.09)                                 4,338.60                     Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 11,253.26                   123,302.48                 148,897.00                 82.81% 11,383.19                   119,098.79                 (129.93)                                 4,203.69                     Finance Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 23,112.89                   231,532.75                 334,879.00                 69.14% 21,664.92                   236,194.19                 1,447.97                               (4,661.44)                   Benefits 3,776.67                     38,866.28                   56,680.00                   68.57% 3,309.07                     36,789.59                   467.60                                   2,076.69                     Operations 4,796.49                     191,672.70                 242,460.00                 79.05% 11,609.41                   199,491.29                 (6,812.92)                              (7,818.59)                   Capital Outlay ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 31,686.05                   462,071.73                 634,019.00                 72.88% 36,583.40                   472,475.07                 (4,897.35)                              (10,403.34)                 City Clerk Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 10,800.09                   105,109.84                 136,748.00                 76.86% 9,813.37                     101,977.51                 986.72                                   3,132.33                     Benefits 1,670.02                     17,130.95                   22,759.00                   75.27% 1,426.02                     15,056.10                   244.00                                   2,074.85                     Operations 1,443.21                     24,786.92                   49,250.00                   50.33% 660.87                         53,128.21                   782.34                                   (28,341.29)                 Capital Outlay ‐                                ‐                                ‐                               0.00%‐                               365.00                          ‐                                         (365.00)                       Total 13,913.32                   147,027.71                 208,757.00                 70.43% 11,900.26                   170,526.82                 2,013.06                               (23,499.11)                 HR Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 22,667.51                   226,161.11                 283,708.00                 79.72% 21,410.30                   202,238.66                 1,257.21                               23,922.45                   Benefits 3,904.96                     40,785.61                   52,021.00                   78.40% 3,437.21                     33,350.24                   467.75                                   7,435.37                     Operations 3,519.94                     55,398.73                   71,100.00                   77.92% 8,283.43                     86,846.74                   (4,763.49)                              (31,448.01)                 Capital Outlay 10,950.00                   10,950.00                   10,950.00                   0.00%‐                                ‐                               10,950.00                             10,950.00                   Total 41,042.41                   333,295.45                 417,779.00                 79.78% 33,130.94                   322,435.64                 7,911.47                               10,859.81                   IT Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 13,331.90                   134,001.52                 168,121.00                 79.71% 12,640.67                   130,606.63                 691.23                                   3,394.89                     Benefits 1,984.03                     20,488.90                   26,061.00                   78.62% 1,766.93                     18,712.71                   217.10                                   1,776.19                     Operations 78,484.14                   1,109,584.38             1,426,295.00             77.79% 81,751.93                   984,378.77                 (3,267.79)                              125,205.61                Capital Outlay 70,159.00                   103,674.00                 109,000.00                 95.11%‐                               50,234.92                   70,159.00                             53,439.08                   Total 163,959.07                 1,367,748.80             1,729,477.00             79.08% 96,159.53                   1,183,933.03             67,799.54                             183,815.77                Vehicle Maint. Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 14,868.78                   192,800.94                 253,371.00                 76.09% 18,544.47                   174,758.96                 (3,675.69)                              18,041.98                   Benefits 2,278.10                     37,417.98                   50,796.00                   73.66% 2,867.35                     36,633.30                   (589.25)                                 784.68                        Operations 2,540.32                     43,887.46                   103,450.00                 42.42% 3,834.83                     31,789.76                   (1,294.51)                              12,097.70                   Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 19,687.20                   274,106.38                 407,617.00                 67.25% 25,246.65                   243,182.02                 (5,559.45)                              30,924.36                   City of Prattville July Unaudited Expenditures By Department Engineering Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 36,044.04                   374,418.34                488,503.00                76.65% 36,860.57                   359,658.17                (816.53)                                 14,760.17                  Benefits 6,488.12                     80,418.20                   102,847.00                78.19% 6,079.61                     73,965.63                   408.51                                  6,452.57                     Operations 9,419.55                     258,515.45                546,500.00                47.30% 51,499.49                   305,908.45                (42,079.94)                           (47,393.00)                 Capital Projects ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 51,951.71                   713,351.99                1,137,850.00             62.69% 94,439.67                   739,532.25                (42,487.96)                           (26,180.26)                 Planning Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 21,289.56                   170,158.61                230,589.00                73.79% 10,780.12                   176,173.42                10,509.44                             (6,014.81)                   Benefits 3,816.74                     31,417.16                   40,685.00                   77.22% 1,792.00                     28,633.74                   2,024.74                               2,783.42                     Operations 6,227.92                     322,823.19                502,450.00                64.25% 57,372.06                   381,956.46                (51,144.14)                           (59,133.27)                 Capital Projects ‐                                ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Capital Outlay ‐                                ‐                               32,000.00                   0.00%‐                               6,011.00                      ‐                                         (6,011.00)                   Total 31,334.22                   524,398.96                805,724.00                65.08% 69,944.18                   592,774.62                (38,609.96)                           (68,375.66)                 Urban Management Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 62,219.35                   569,446.45                843,847.00                67.48% 60,125.69                   542,907.50                2,093.66                               26,538.95                  Benefits 9,550.90                     105,747.61                154,697.00                68.36% 8,474.85                     100,226.57                1,076.05                               5,521.04                     Operations 31,037.53                   352,472.76                530,750.00                66.41% 33,605.48                   312,970.46                (2,567.95)                              39,502.30                  Capital Outlay 12,410.00                   54,255.00                   63,000.00                   86.12% 22,524.00                   22,524.00                   (10,114.00)                           31,731.00                  Total 115,217.78                1,081,921.82             1,592,294.00             67.95% 124,730.02                978,628.53                (9,512.24)                              103,293.29                Facilities Maintenance Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 25,757.24                   258,518.98                330,843.00                78.14% 24,735.01                   231,929.22                1,022.23                               26,589.76                  Benefits 3,918.41                     43,368.11                   54,394.00                   79.73% 3,496.08                     42,802.39                   422.33                                  565.72                        Operations 4,140.46                     102,348.59                170,000.00                60.21% 18,237.44                   110,523.66                (14,096.98)                           (8,175.07)                   Capital Outlay 46,990.96                   65,395.68                   163,000.00                40.12% 7,755.12                     19,854.09                   39,235.84                             45,541.59                  Total 80,807.07                   469,631.36                718,237.00                65.39% 54,223.65                   405,109.36                26,583.42                             64,522.00                  Public Works Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 21,220.90                   203,533.02                268,409.00                75.83% 19,673.14                   293,023.31                1,547.76                               (89,490.29)                 Benefits 3,637.05                     38,484.71                   50,333.00                   76.46% 3,088.12                     80,582.14                   548.93                                  (42,097.43)                 Operations 15,820.73                   176,242.05                235,214.00                74.93% 3,830.31                     100,332.30                11,990.42                             75,909.75                  Capital Outlay ‐                               (3,390.00)                   408,399.00                 ‐0.83%‐                               6,550.00                      ‐                                         (9,940.00)                   Total 40,678.68                   414,869.78                962,355.00                43.11% 26,591.57                   480,487.75                14,087.11                             (65,617.97)                 Police Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 391,153.70                3,815,769.21             5,205,663.00             73.30% 348,564.55                3,845,068.66             42,589.15                             (29,299.45)                 Benefits 63,865.99                   737,877.75                1,003,222.00             73.55% 55,500.19                   779,924.51                8,365.80                               (42,046.76)                 Operations 74,732.19                   1,038,607.68             1,293,071.00             80.32% 84,331.22                   961,735.63                (9,599.03)                              76,872.05                  Capital Outlay ‐                               122,314.38                130,862.00                93.47%‐                               184,267.28                 ‐                                         (61,952.90)                 Total 529,751.88                5,714,569.02             7,632,818.00             74.87% 488,395.96                5,770,996.08             41,355.92                             (56,427.06)                 Fire Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 357,243.35                3,583,192.94             4,704,544.00             76.16% 350,147.47                3,728,817.62             7,095.88                               (145,624.68)               Benefits 62,244.97                   746,755.96                972,204.00                76.81% 56,602.51                   772,589.22                5,642.46                               (25,833.26)                 Operations 47,257.70                   752,281.55                1,123,052.00             66.99% 55,449.26                   843,041.54                (8,191.56)                              (90,759.99)                 Capital Outlay ‐                               445,444.00                445,464.00                100.00%‐                               35,936.25                    ‐                                         409,507.75                Total 466,746.02                5,527,674.45             7,245,264.00             76.29% 462,199.24                5,380,384.63             4,546.78                               147,289.82                Building Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 17,604.80                   224,023.56                300,082.00                74.65% 22,679.74                   222,494.85                (5,074.94)                              1,528.71                     Benefits 3,069.44                     43,184.74                   59,832.00                   72.18% 3,688.41                     39,693.82                   (618.97)                                 3,490.92                     Operations 1,862.18                     33,668.79                   63,200.00                   53.27% 1,640.94                     38,557.31                   221.24                                  (4,888.52)                   Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 22,536.42                   300,877.09                423,114.00                71.11% 28,009.09                   300,745.98                (5,472.67)                              131.11                        Parks & Recreation Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 88,933.94                   687,985.75                940,078.00                73.18% 78,189.74                   564,471.76                10,744.20                             123,513.99                Benefits 11,836.54                   117,279.36                140,994.00                83.18% 9,836.67                     94,922.06                   1,999.87                               22,357.30                  Operations 53,424.75                   812,082.23                1,343,500.00             60.45% 113,626.18                687,263.51                (60,201.43)                           124,818.72                Capital Outlay/ Capital Projects ‐                               494,760.83                754,820.00                65.55% 54,856.10                   191,972.19                (54,856.10)                           302,788.64                Total 154,195.23                2,112,108.17             3,179,392.00             66.43% 256,508.69                1,538,629.52             (102,313.46)                         573,478.65                Performing Arts Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 8,522.31                     73,324.24                   91,929.00                   79.76% 6,451.21                     60,723.01                   2,071.10                               12,601.23                  Benefits 1,235.05                     11,274.90                   13,441.00                   83.88% 930.88                        8,931.65                     304.17                                  2,343.25                     Operations 9,301.30                     152,583.82                258,595.00                59.00% 17,847.71                   130,071.05                (8,546.41)                              22,512.77                  Capital Outlay ‐                               10,514.00                   17,500.00                   60.08%‐                                ‐                                ‐                                         10,514.00                  Total 19,058.66                   247,696.96                381,465.00                64.93% 25,229.80                   199,725.71                (6,171.14)                              47,971.25                  Non‐Departmental Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference City ‐ County Svcs 84,166.66                   403,333.34                410,000.00                98.37% 84,166.66                   393,333.34                 ‐                                         10,000.00                  Community Initiatives 68,707.06                   699,138.08                978,094.00                71.48% 53,530.31                   563,930.00                15,176.75                             135,208.08                Transfer to DSF ‐ One Cent 4,000,770.47             7,335,956.05             7,343,844.00             99.89%‐                               4,955,997.97             4,000,770.47                       2,379,958.08             Transfer to DSF ‐ Other 110,388.47                226,481.89                331,969.00                68.22% 6,215.00                     164,205.83                104,173.47                          62,276.06                  Transfer to Group Health 494,334.00                2,718,837.00             2,966,000.00             91.67% 249,375.00                2,493,750.00             244,959.00                          225,087.00                Transfer to Capital Project Fund 10,925.94                   385,379.85                451,255.00                85.40% 11,464.47                   731,366.64                (538.53)                                 (345,986.79)               Transfer to Gas Tax Fund 188,150.00                188,150.00                188,150.00                100.00% 188,150.00                          188,150.00                Transfer to Judicial ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Total 4,957,442.60             11,957,276.21           12,669,312.00           94.38% 404,751.44                9,302,583.78             4,552,691.16                       2,654,692.43             Debt Service Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Debt Service 143,157.26                1,369,851.79             1,530,500.00             89.50% 50,127.42                   1,090,390.67             93,029.84                             279,461.12                Total 143,157.26                1,369,851.79             1,530,500.00             89.50% 50,127.42                   1,090,390.67             93,029.84                             279,461.12                Total Jul‐19 YTD Budget % of Budget Jul‐18 YTD July Difference YTD Difference Salary 1,147,145.65             11,175,518.94           15,028,865.00           74.36% 1,072,694.83             11,178,770.70           74,450.82                             (3,251.76)                   Benefits 681,064.74                4,864,935.65             5,823,044.00             83.55% 414,871.65                4,690,408.21             266,193.09                          174,527.44                Operations 699,615.36                7,012,957.27             10,137,319.00           69.18% 696,796.96                6,988,528.71             2,818.40                               24,428.56                  Capital Outlay 140,509.96                1,303,917.89             2,134,995.00             61.07% 85,135.22                   517,714.73                55,374.74                             786,203.16                Debt Service 4,254,316.20             8,932,289.73             9,206,313.00             97.02% 56,342.42                   6,210,594.47             4,197,973.78                       2,721,695.26             Total 6,922,651.91             33,289,619.48           42,330,536.00           78.64% 2,325,841.08             29,586,016.82           4,596,810.83                       3,703,602.66             Prepared by     Daniel Oakley