Loading...
June 2019 - General Fund Expense ReportAs of  7/12/2019 75.00 % Year Complete Executive Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 22,756.09                   199,413.03                 322,551.00                 61.82% 19,961.75                   183,560.01                 2,794.34                               15,853.02                   Benefits 2,895.99                     25,173.17                   45,781.00                   54.99% 2,489.18                     23,531.21                   406.81                                   1,641.96                     Operations 3,730.44                     83,170.06                   137,333.00                 60.56% 3,178.33                     60,998.97                   552.11                                   22,171.09                   Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 29,382.52                   307,756.26                 505,665.00                 60.86% 25,629.26                   268,090.19                 3,753.26                               39,666.07                   Legislative Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 10,417.04                   93,753.36                   125,000.00                 75.00% 10,417.04                   93,753.36                    ‐                                          ‐                               Benefits 750.86                         6,973.51                     10,297.00                   67.72% 802.26                         7,112.58                     (51.40)                                    (139.07)                       Operations 140.13                         11,322.35                   13,600.00                   83.25% 796.47                         6,849.66                     (656.34)                                 4,472.69                     Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 11,308.03                   112,049.22                 148,897.00                 75.25% 12,015.77                   107,715.60                 (707.74)                                 4,333.62                     Finance Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 23,176.47                   208,419.86                 334,879.00                 62.24% 21,840.31                   214,529.27                 1,336.16                               (6,109.41)                   Benefits 3,802.31                     35,089.61                   56,680.00                   61.91% 3,361.36                     33,480.52                   440.95                                   1,609.09                     Operations 11,037.16                   186,876.21                 242,460.00                 77.08% 15,513.76                   187,881.88                 (4,476.60)                              (1,005.67)                   Capital Outlay ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 38,015.94                   430,385.68                 634,019.00                 67.88% 40,715.43                   435,891.67                 (2,699.49)                              (5,505.99)                   City Clerk Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 10,568.10                   94,309.75                   136,748.00                 68.97% 9,813.37                     92,164.14                   754.73                                   2,145.61                     Benefits 1,668.41                     15,460.93                   22,759.00                   67.93% 1,456.62                     13,630.08                   211.79                                   1,830.85                     Operations 3,524.21                     23,343.71                   49,250.00                   47.40% 4,401.86                     52,467.34                   (877.65)                                 (29,123.63)                 Capital Outlay ‐                                ‐                                ‐                               0.00%‐                               365.00                          ‐                                         (365.00)                       Total 15,760.72                   133,114.39                 208,757.00                 63.77% 15,671.85                   158,626.56                 88.87                                     (25,512.17)                 HR Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 23,101.85                   203,493.60                 283,708.00                 71.73% 21,558.95                   180,828.36                 1,542.90                               22,665.24                   Benefits 4,039.81                     36,880.65                   52,021.00                   70.90% 3,497.72                     29,913.03                   542.09                                   6,967.62                     Operations 10,826.43                   51,878.79                   71,100.00                   72.97% 10,436.05                   78,563.31                   390.38                                   (26,684.52)                 Capital Outlay ‐                                ‐                               10,950.00                   0.00%‐                                ‐                                ‐                                          ‐                               Total 37,968.09                   292,253.04                 417,779.00                 69.95% 35,492.72                   289,304.70                 2,475.37                               2,948.34                     IT Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 13,242.27                   120,669.62                 168,121.00                 71.78% 12,476.08                   117,965.96                 766.19                                   2,703.66                     Benefits 1,976.28                     18,504.87                   26,061.00                   71.01% 1,763.57                     16,945.78                   212.71                                   1,559.09                     Operations 77,510.83                   1,031,100.24             1,426,295.00             72.29% 70,804.15                   902,626.84                 6,706.68                               128,473.40                Capital Outlay ‐                               33,515.00                   109,000.00                 30.75% 39,234.92                   50,234.92                   (39,234.92)                            (16,719.92)                 Total 92,729.38                   1,203,789.73             1,729,477.00             69.60% 124,278.72                 1,087,773.50             (31,549.34)                            116,016.23                Vehicle Maint. Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 15,464.81                   177,932.16                 253,371.00                 70.23% 16,884.30                   156,214.49                 (1,419.49)                              21,717.67                   Benefits 2,311.13                     35,139.88                   50,796.00                   69.18% 2,649.72                     33,765.95                   (338.59)                                 1,373.93                     Operations 5,895.20                     41,347.14                   103,450.00                 39.97% 14,928.79                   27,954.93                   (9,033.59)                              13,392.21                   Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 23,671.14                   254,419.18                 407,617.00                 62.42% 34,462.81                   217,935.37                 (10,791.67)                            36,483.81                   City of Prattville June Unaudited Expenditures By Department Engineering Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 35,875.38                   338,374.30                488,503.00                69.27% 36,449.89                   322,797.60                (574.51)                                 15,576.70                  Benefits 6,208.97                     73,930.08                   102,847.00                71.88% 6,072.92                     67,886.02                   136.05                                  6,044.06                     Operations 14,581.10                   249,095.90                546,500.00                45.58% 31,376.92                   254,408.96                (16,795.82)                           (5,313.06)                   Capital Projects ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 56,665.45                   661,400.28                1,137,850.00             58.13% 73,899.73                   645,092.58                (17,234.28)                           16,307.70                  Planning Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 21,245.39                   148,869.05                230,589.00                64.56% 22,031.32                   165,393.30                (785.93)                                 (16,524.25)                 Benefits 3,813.63                     27,600.42                   40,685.00                   67.84% 2,803.92                     26,841.74                   1,009.71                               758.68                        Operations 40,396.16                   316,595.27                502,450.00                63.01% 38,250.78                   324,584.40                2,145.38                               (7,989.13)                   Capital Projects ‐                                ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Capital Outlay ‐                                ‐                               32,000.00                   0.00%‐                               6,011.00                      ‐                                         (6,011.00)                   Total 65,455.18                   493,064.74                805,724.00                61.20% 63,086.02                   522,830.44                2,369.16                               (29,765.70)                 Urban Management Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 61,812.69                   507,227.10                843,847.00                60.11% 58,224.28                   482,781.81                3,588.41                               24,445.29                  Benefits 9,126.57                     96,196.71                   154,697.00                62.18% 8,334.28                     91,751.72                   792.29                                  4,444.99                     Operations 28,727.00                   321,435.23                530,750.00                60.56% 54,471.17                   279,364.98                (25,744.17)                           42,070.25                  Capital Outlay ‐                               41,845.00                   63,000.00                   66.42%‐                                ‐                                ‐                                         41,845.00                  Total 99,666.26                   966,704.04                1,592,294.00             60.71% 121,029.73                853,898.51                (21,363.47)                           112,805.53                Facilities Maintenance Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 25,559.92                   232,761.74                330,843.00                70.35% 22,486.56                   207,194.21                3,073.36                               25,567.53                  Benefits 3,838.30                     39,449.70                   54,394.00                   72.53% 3,224.65                     39,306.31                   613.65                                  143.39                        Operations 3,719.18                     98,208.13                   170,000.00                57.77% 3,729.35                     92,286.22                   (10.17)                                   5,921.91                     Capital Outlay 2,042.16                     18,404.72                   163,000.00                11.29% 5,548.97                     12,098.97                   (3,506.81)                              6,305.75                     Total 35,159.56                   388,824.29                718,237.00                54.14% 34,989.53                   350,885.71                170.03                                  37,938.58                  Public Works Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 19,274.27                   182,312.12                268,409.00                67.92% 19,627.66                   273,350.17                (353.39)                                 (91,038.05)                 Benefits 3,282.95                     34,847.66                   50,333.00                   69.23% 3,117.62                     77,494.02                   165.33                                  (42,646.36)                 Operations 7,178.00                     160,421.32                235,214.00                68.20% 5,798.24                     96,501.99                   1,379.76                               63,919.33                  Capital Outlay ‐                               (3,390.00)                   408,399.00                 ‐0.83%‐                               6,550.00                      ‐                                         (9,940.00)                   Total 29,735.22                   374,191.10                962,355.00                38.88% 28,543.52                   453,896.18                1,191.70                               (79,705.08)                 Police Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 368,223.45                3,424,615.51             5,205,663.00             65.79% 350,275.52                3,496,504.11             17,947.93                             (71,888.60)                 Benefits 60,532.89                   674,011.76                1,003,222.00             67.18% 56,116.95                   724,424.32                4,415.94                               (50,412.56)                 Operations 105,908.32                963,875.49                1,293,071.00             74.54% 74,722.07                   877,404.41                31,186.25                             86,471.08                  Capital Outlay ‐                               122,314.38                130,862.00                93.47% 27,055.00                   184,267.28                (27,055.00)                           (61,952.90)                 Total 534,664.66                5,184,817.14             7,632,818.00             67.93% 508,169.54                5,282,600.12             26,495.12                             (97,782.98)                 Fire Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 348,949.61                3,225,949.59             4,704,544.00             68.57% 360,909.76                3,378,670.15             (11,960.15)                           (152,720.56)               Benefits 58,445.95                   684,510.99                972,204.00                70.41% 58,336.06                   715,986.71                109.89                                  (31,475.72)                 Operations 34,953.08                   705,023.85                1,123,052.00             62.78% 99,653.57                   787,592.28                (64,700.49)                           (82,568.43)                 Capital Outlay 195,464.00                445,444.00                445,464.00                100.00%‐                               35,936.25                   195,464.00                          409,507.75                Total 637,812.64                5,060,928.43             7,245,264.00             69.85% 518,899.39                4,918,185.39             118,913.25                          142,743.04                Building Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 17,604.80                   206,418.76                300,082.00                68.79% 22,384.00                   199,815.11                (4,779.20)                              6,603.65                     Benefits 3,000.95                     40,115.30                   59,832.00                   67.05% 3,638.10                     36,005.41                   (637.15)                                 4,109.89                     Operations 1,669.99                     31,806.61                   63,200.00                   50.33% 4,805.88                     36,916.37                   (3,135.89)                              (5,109.76)                   Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 22,275.74                   278,340.67                423,114.00                65.78% 30,827.98                   272,736.89                (8,552.24)                              5,603.78                     Parks & Recreation Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 92,321.44                   599,051.81                940,078.00                63.72% 75,511.17                   486,282.02                16,810.27                             112,769.79                Benefits 12,266.12                   105,442.82                140,994.00                74.79% 9,768.44                     85,085.39                   2,497.68                               20,357.43                  Operations 127,671.69                758,657.48                1,343,500.00             56.47% 65,722.27                   573,637.33                61,949.42                             185,020.15                Capital Outlay/ Capital Projects ‐                               494,760.83                754,820.00                65.55% 78,953.87                   137,116.09                (78,953.87)                           357,644.74                Total 232,259.25                1,957,912.94             3,179,392.00             61.58% 229,955.75                1,282,120.83             2,303.50                               675,792.11                Performing Arts Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 7,765.74                     64,801.93                   91,929.00                   70.49% 5,705.25                     54,271.80                   2,060.49                               10,530.13                  Benefits 1,117.51                     10,039.85                   13,441.00                   74.70% 830.06                        8,000.77                     287.45                                  2,039.08                     Operations 29,013.95                   143,282.52                258,595.00                55.41% 18,896.40                   112,223.34                10,117.55                             31,059.18                  Capital Outlay ‐                               10,514.00                   17,500.00                   60.08%‐                                ‐                                ‐                                         10,514.00                  Total 37,897.20                   228,638.30                381,465.00                59.94% 25,431.71                   174,495.91                12,465.49                             54,142.39                  Non‐Departmental Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference City ‐ County Svcs 6,666.66                     319,166.68                410,000.00                77.85% 13,333.32                   309,166.68                (6,666.66)                              10,000.00                  Community Initiatives 51,665.68                   630,431.02                978,094.00                64.46% 49,049.23                   510,399.69                2,616.45                               120,031.33                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                2,224,503.00             2,966,000.00             75.00% 249,375.00                2,244,375.00             (2,208.00)                              (19,872.00)                 Transfer to Capital Project Fund 11,158.03                   374,453.91                451,255.00                82.98% 10,809.57                   719,902.17                348.46                                  (345,448.26)               Transfer to Gas Tax Fund 188,150.00                0.00%‐                                          ‐                              Transfer to Judicial ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Total 316,657.37                6,999,833.61             8,819,312.00             79.37% 322,567.12                8,897,832.34             (5,909.75)                              (1,897,998.73)           Debt Service Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Debt Service 119,847.25                1,226,694.53             1,530,500.00             80.15% 163,496.23                1,040,263.25             (43,648.98)                           186,431.28                Total 119,847.25                1,226,694.53             1,530,500.00             80.15% 163,496.23                1,040,263.25             (43,648.98)                           186,431.28                Total Jun‐19 YTD Budget % of Budget Jun‐18 YTD June Difference YTD Difference Salary 1,117,359.32             10,028,373.29           15,028,865.00           66.73% 1,086,557.21             10,106,075.87           30,802.11                             (77,702.58)                 Benefits 426,245.63                4,183,870.91             5,823,044.00             71.85% 417,638.43                4,275,536.56             8,607.20                               (91,665.65)                 Operations 575,973.24                6,501,491.91             10,137,319.00           64.13% 590,678.18                6,291,731.75             (14,704.94)                           209,760.16                Capital Outlay 197,506.16                1,163,407.93             2,134,995.00             54.49% 150,792.76                432,579.51                46,713.40                             730,828.42                Debt Service 119,847.25                4,677,973.53             5,356,313.00             87.34% 163,496.23                6,154,252.05             (43,648.98)                           (1,476,278.52)           Total 2,436,931.60             26,555,117.57           38,480,536.00           69.01% 2,409,162.81             27,260,175.74           27,768.79                             (705,058.17)               Prepared by     Daniel Oakley