Loading...
March 2019 - General Fund Expense ReportAs of  4/12/2019 50.00 % Year Complete Executive Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 34,579.57                   129,726.85                 322,551.00                 40.22% 29,978.33                   123,572.97                 4,601.24                               6,153.88                     Benefits 2,554.59                     14,676.73                   45,910.00                   31.97% 3,879.78                     16,059.61                   (1,325.19)                              (1,382.88)                   Operations 7,300.12                     66,318.51                   137,333.00                 48.29% 7,052.80                     48,731.73                   247.32                                   17,586.78                   Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 44,434.28                   210,722.09                 505,794.00                 41.66% 40,910.91                   188,364.31                 3,523.37                               22,357.78                   Legislative Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 10,417.04                   62,502.24                   125,000.00                 50.00% 10,417.04                   62,502.24                    ‐                                          ‐                               Benefits 754.40                         4,713.85                     10,400.00                   45.33% 707.06                         4,747.70                     47.34                                     (33.85)                         Operations 2,937.88                     5,544.45                     13,600.00                   40.77% 1,600.92                     4,126.45                     1,336.96                               1,418.00                     Capital Outlay ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                ‐                                          ‐                               Total 14,109.32                   72,760.54                   149,000.00                 48.83% 12,725.02                   71,376.39                   1,384.30                               1,384.15                     Finance Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 33,371.40                   139,698.48                 334,879.00                 41.72% 33,622.85                   147,661.55                 (251.45)                                 (7,963.07)                   Benefits 2,467.95                     20,700.91                   56,850.00                   36.41% 5,351.99                     23,184.44                   (2,884.04)                              (2,483.53)                   Operations 15,065.37                   114,290.66                 242,460.00                 47.14% 17,257.54                   130,306.07                 (2,192.17)                              (16,015.41)                 Capital Outlay ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 50,904.72                   274,690.05                 634,189.00                 43.31% 56,232.38                   301,152.06                 (5,327.66)                              (26,462.01)                 City Clerk Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 14,505.42                   62,706.54                   136,748.00                 45.86% 13,761.71                   62,597.92                   743.71                                   108.62                        Benefits 1,041.14                     9,121.28                     22,849.00                   39.92% 2,110.67                     9,248.71                     (1,069.53)                              (127.43)                       Operations 1,955.58                     15,481.73                   49,250.00                   31.43% 12,922.63                   40,452.82                   (10,967.05)                            (24,971.09)                 Capital Outlay ‐                                ‐                                ‐                               0.00%‐                               5,823.00                      ‐                                         (5,823.00)                   Total 17,502.14                   87,309.55                   208,847.00                 41.81% 28,795.01                   118,122.45                 (11,292.87)                            (30,812.90)                 HR Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 32,710.58                   135,651.14                 283,708.00                 47.81% 31,509.00                   116,691.69                 1,201.58                               18,959.45                   Benefits 2,396.05                     21,510.52                   52,191.00                   41.21% 5,155.13                     19,487.08                   (2,759.08)                              2,023.44                     Operations 10,609.87                   34,533.39                   82,050.00                   42.09% 10,807.36                   58,556.75                   (197.49)                                 (24,023.36)                 Capital Outlay ‐                                ‐                                ‐                               0.00%‐                               24,326.00                    ‐                                         (24,326.00)                 Total 45,716.50                   191,695.05                 417,949.00                 45.87% 47,471.49                   219,061.52                 (1,754.99)                              (27,366.47)                 IT Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 19,680.23                   81,356.10                   168,121.00                 48.39% 18,713.01                   80,423.11                   967.22                                   932.99                        Benefits 1,457.33                     11,121.41                   26,195.00                   42.46% 2,643.17                     11,641.68                   (1,185.84)                              (520.27)                       Operations 166,062.76                 755,820.12                 1,426,295.00             52.99% 99,991.62                   675,472.86                 66,071.14                             80,347.26                   Capital Outlay 33,515.00                   33,515.00                   109,000.00                 30.75% 11,000.00                   11,000.00                   22,515.00                             22,515.00                   Total 220,715.32                 881,812.63                 1,729,611.00             50.98% 132,347.80                 778,537.65                 88,367.52                             103,274.98                Vehicle Maint. Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 26,644.17                   116,333.09                 253,371.00                 45.91% 21,510.51                   110,324.37                 5,133.66                               6,008.72                     Benefits 1,944.60                     23,955.88                   55,222.00                   43.38% 3,435.57                     26,368.07                   (1,490.97)                              (2,412.19)                   Operations 5,351.17                     26,498.34                   103,450.00                 25.61% 6,339.80                     11,526.07                   (988.63)                                 14,972.27                   Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                               Total 33,939.94                   166,787.31                 412,043.00                 40.48% 31,285.88                   148,218.51                 2,654.06                               18,568.80                   City of Prattville March Unaudited Expenditures By Department Engineering Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 55,104.57                   229,345.74                488,503.00                46.95% 51,559.70                   215,318.54                3,544.87                               14,027.20                  Benefits 3,992.91                     48,504.27                   110,944.00                43.72% 8,626.77                     49,565.72                   (4,633.86)                              (1,061.45)                   Operations 53,547.61                   167,454.32                546,500.00                30.64% 38,657.53                   163,782.64                14,890.08                             3,671.68                     Capital Projects ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 112,645.09                445,304.33                1,145,947.00             38.86% 98,844.00                   428,666.90                13,801.09                             16,637.43                  Planning Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 24,542.53                   95,213.77                   230,589.00                41.29% 25,526.70                   112,211.35                (984.17)                                 (16,997.58)                 Benefits 1,860.99                     15,096.00                   40,930.00                   36.88% 4,188.27                     18,824.37                   (2,327.28)                              (3,728.37)                   Operations 38,084.82                   201,548.90                502,450.00                40.11% 36,676.28                   219,004.72                1,408.54                               (17,455.82)                 Capital Projects ‐                                ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Capital Outlay ‐                                ‐                               32,000.00                   0.00%‐                               6,011.00                      ‐                                         (6,011.00)                   Total 64,488.34                   311,858.67                805,969.00                38.69% 66,391.25                   356,051.44                (1,902.91)                              (44,192.77)                 Urban Management Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 77,034.02                   330,262.54                843,847.00                39.14% 65,471.95                   310,635.86                11,562.07                             19,626.68                  Benefits 5,818.08                     61,647.11                   165,421.00                37.27% 9,966.48                     66,995.93                   (4,148.40)                              (5,348.82)                   Operations 33,453.61                   217,441.52                530,750.00                40.97% 30,325.29                   162,678.97                3,128.32                               54,762.55                  Capital Outlay ‐                                ‐                               63,000.00                   0.00%‐                                ‐                                ‐                                          ‐                              Total 116,305.71                609,351.17                1,603,018.00             38.01% 105,763.72                540,310.76                10,541.99                             69,040.41                  Facilities Maintenance Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 37,908.23                   156,239.80                330,843.00                47.22% 34,977.41                   140,593.41                2,930.82                               15,646.39                  Benefits 2,776.89                     24,534.37                   56,573.00                   43.37% 5,014.45                     29,603.10                   (2,237.56)                              (5,068.73)                   Operations 3,075.91                     69,379.99                   170,000.00                40.81% 7,753.59                     65,494.19                   (4,677.68)                              3,885.80                     Capital Outlay 2,500.00                     2,500.00                     163,000.00                1.53% 6,550.00                     6,550.00                     (4,050.00)                              (4,050.00)                   Total 46,261.03                   252,654.16                720,416.00                35.07% 54,295.45                   242,240.70                (8,034.42)                              10,413.46                  Public Works Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 29,916.81                   124,047.42                268,409.00                46.22% 34,977.41                   205,908.81                (5,060.60)                              (81,861.39)                 Benefits 2,172.91                     21,911.32                   52,443.00                   41.78% 5,014.45                     66,784.82                   (2,841.54)                              (44,873.50)                 Operations 18,217.87                   122,566.23                241,718.00                50.71% 7,753.59                     68,502.87                   10,464.28                             54,063.36                  Capital Outlay ‐                                ‐                               265,000.00                0.00% 6,550.00                     6,550.00                     (6,550.00)                              (6,550.00)                   Total 50,307.59                   268,524.97                827,570.00                32.45% 54,295.45                   347,746.50                (3,987.86)                              (79,221.53)                 Police Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 545,541.06                2,299,392.67             5,205,663.00             44.17% 542,770.58                2,439,604.44             2,770.48                               (140,211.77)               Benefits 39,891.21                   433,526.58                1,062,696.00             40.79% 85,103.08                   554,255.00                (45,211.87)                           (120,728.42)               Operations 140,645.05                625,634.82                1,293,071.00             48.38% 71,506.80                   650,281.37                69,138.25                             (24,646.55)                 Capital Outlay ‐                               103,532.00                130,862.00                79.12% 21,937.28                   157,212.28                (21,937.28)                           (53,680.28)                 Total 726,077.32                3,462,086.07             7,692,292.00             45.01% 721,317.74                3,801,353.09             4,759.58                               (339,267.02)               Fire Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 526,870.70                2,182,832.56             4,704,544.00             46.40% 533,270.39                2,314,387.57             (6,399.69)                              (131,555.01)               Benefits 38,354.96                   449,581.92                1,046,996.00             42.94% 90,207.74                   538,752.40                (51,852.78)                           (89,170.48)                 Operations 80,657.99                   462,294.42                1,123,052.00             41.16% 92,649.82                   571,367.68                (11,991.83)                           (109,073.26)               Capital Outlay 70,380.00                   248,060.00                250,000.00                99.22%‐                               70,380.00                             248,060.00                Total 716,263.65                3,342,768.90             7,124,592.00             46.92% 716,127.95                3,424,507.65             135.70                                  (81,738.75)                 Building Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 34,745.76                   142,261.09                300,082.00                47.41% 29,556.18                   133,543.20                5,189.58                               8,717.89                     Benefits 2,514.19                     25,149.48                   61,838.00                   40.67% 4,845.40                     25,131.85                   (2,331.21)                              17.63                          Operations 1,440.59                     23,359.06                   63,200.00                   36.96% 1,657.74                     23,917.99                   (217.15)                                 (558.93)                       Capital Outlay ‐                                ‐                                ‐                               0.00%‐                                ‐                                ‐                                          ‐                              Total 38,700.54                   190,769.63                425,120.00                44.87% 36,059.32                   182,593.04                2,641.22                               8,176.59                     Parks & Recreation Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 94,817.70                   363,059.11                940,078.00                38.62% 70,807.77                   298,142.16                24,009.93                             64,916.95                  Benefits 7,115.98                     64,120.97                   150,087.00                42.72% 10,143.86                   58,668.44                   (3,027.88)                              5,452.53                     Operations 64,589.18                   401,442.20                1,343,500.00             29.88% 51,682.28                   339,796.40                12,906.90                             61,645.80                  Capital Outlay/ Capital Projects 19,814.83                   370,138.83                754,820.00                49.04%‐                                ‐                               19,814.83                             370,138.83                Total 186,337.69                1,198,761.11             3,188,485.00             37.60% 132,633.91                696,607.00                53,703.78                             502,154.11                Performing Arts Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 11,600.11                   41,889.24                   91,929.00                   45.57% 8,551.78                     35,281.77                   3,048.33                               6,607.47                     Benefits 889.41                        5,780.84                     13,525.00                   42.74% 1,234.01                     5,238.97                     (344.60)                                 541.87                        Operations 15,082.85                   64,655.52                   258,595.00                25.00% 18,576.54                   57,623.47                   (3,493.69)                              7,032.05                     Capital Outlay ‐                               10,514.00                   17,500.00                   60.08%‐                                ‐                                ‐                                         10,514.00                  Total 27,572.37                   122,839.60                381,549.00                32.19% 28,362.33                   98,144.21                   (789.96)                                 24,695.39                  Non‐Departmental Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference City ‐ County Svcs 6,666.67                     221,666.69                410,000.00                54.07% 13,333.34                   211,666.69                (6,666.67)                              10,000.00                  Community Initiatives 64,088.04                   402,567.54                978,094.00                41.16% 43,363.86                   335,525.78                20,724.18                             67,041.76                  Transfer to DSF ‐ One Cent 3,176,085.20             3,493,844.00             90.91%‐                               4,771,939.12              ‐                                         (1,595,853.92)           Transfer to DSF ‐ Other ‐                               116,093.42                177,066.00                65.57%‐                               157,990.83                 ‐                                         (41,897.41)                 Transfer to Group Health 247,167.00                1,483,002.00             2,966,000.00             50.00% 249,375.00                1,496,250.00             (2,208.00)                              (13,248.00)                 Transfer to Capital Project Fund 9,096.48                     72,412.66                   181,869.00                39.82% 10,576.41                   686,951.63                (1,479.93)                              (614,538.97)               Transfer to Gas Tax Fund 188,150.00                0.00%‐                                          ‐                              Transfer to Judicial ‐                                ‐                               0.00%‐                                ‐                                          ‐                              Total 327,018.19                5,471,827.51             8,395,023.00             65.18% 316,648.61                7,660,324.05             10,369.58                             (2,188,496.54)           Debt Service Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Debt Service 122,145.84                840,961.38                1,530,500.00             54.95% 105,804.72                715,734.30                16,341.12                             125,227.08                Total 122,145.84                840,961.38                1,530,500.00             54.95% 105,804.72                715,734.30                16,341.12                             125,227.08                Total Mar‐19 YTD Budget % of Budget Mar‐18 YTD March Difference YTD Difference Salary 1,609,989.90             6,692,518.38             15,028,865.00           44.53% 1,556,982.32             6,909,400.96             53,007.58                             (216,882.58)               Benefits 365,170.59                2,738,655.44             5,997,070.00             45.67% 497,002.88                3,020,807.89             (131,832.29)                         (282,152.45)               Operations 737,929.42                4,070,911.07             9,885,387.00             41.18% 580,485.74                4,525,767.15             157,443.68                          (454,856.08)               Capital Outlay 126,209.83                768,259.83                1,785,182.00             43.04% 46,037.28                   217,472.28                80,172.55                             550,787.55                Debt Service 122,145.84                4,133,140.00             5,201,410.00             79.46% 105,804.72                5,645,664.25             16,341.12                             (1,512,524.25)           Total 2,961,445.58             18,403,484.72           37,897,914.00           48.56% 2,786,312.94             20,319,112.53           175,132.64                          (1,915,627.81)           Prepared by     Daniel Oakley