Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
June 2017 - Council Expense Information
As of 7/14/2017 75.00 % Year Complete Executive Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 15,040.34 140,425.14 188,224.01 74.61% 14,422.76 134,538.94 617.58 5,886.20 Benefits 1,787.51 16,996.40 23,124.37 73.50% 1,741.14 17,179.35 46.37 (182.95) Operations 1,402.84 84,797.70 119,698.00 70.84% 1,693.40 43,379.69 (290.56) 41,418.01 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 18,230.69 242,219.24 331,046.38 73.17% 17,857.30 195,097.98 373.39 47,121.26 Legislative Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 10,417.04 94,759.78 125,000.00 75.81% 10,417.04 93,753.36 ‐ 1,006.42 Benefits 776.85 7,116.10 10,391.50 68.48% 780.82 7,216.05 (3.97) (99.95) Operations 1,934.36 7,260.25 26,250.00 27.66% 1,934.36 7,260.25 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 13,128.25 109,136.13 161,641.50 67.52% 11,197.86 100,969.41 1,930.39 8,166.72 Finance Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 21,952.30 199,250.28 303,798.29 65.59% 22,940.51 214,255.85 (988.21) (15,005.57) Benefits 3,461.34 31,431.04 51,498.48 61.03% 3,823.12 38,219.96 (361.78) (6,788.92) Operations 29,635.53 204,192.58 235,620.00 86.66% 7,437.40 331,587.71 22,198.13 (127,395.13) Capital Outlay ‐ 28,466.20 27,839.00 102.25%‐ ‐ ‐ 28,466.20 Total 55,049.17 463,340.10 618,755.77 74.88% 34,201.03 584,063.52 20,848.14 (120,723.42) City Clerk Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 9,660.08 90,596.37 125,523.26 72.17% 9,507.47 86,027.70 152.61 4,568.67 Benefits 1,432.32 13,664.69 19,803.25 69.00% 1,439.34 14,092.36 (7.02) (427.67) Operations 1,096.49 35,447.83 97,202.00 36.47% 1,040.96 29,855.07 55.53 5,592.76 Capital Outlay ‐ ‐ 5,458.00 0.00%‐ ‐ ‐ ‐ Total 12,188.89 139,708.89 247,986.51 56.34% 11,987.77 129,975.13 201.12 9,733.76 HR Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 16,692.00 157,267.60 229,327.53 68.58% 16,332.39 150,707.16 359.61 6,560.44 Benefits 2,669.45 25,851.56 38,035.49 67.97% 2,678.53 26,572.80 (9.08) (721.24) Operations 8,831.93 47,810.30 119,351.00 40.06% 10,694.94 37,815.54 (1,863.01) 9,994.76 Capital Outlay ‐ 22,832.00 0.00%‐ ‐ Total 28,193.38 230,929.46 409,546.02 56.39% 29,705.86 215,095.50 (1,512.48) 15,833.96 IT Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 12,254.75 85,207.80 165,976.00 51.34% 7,036.26 88,995.78 5,218.49 (3,787.98) Benefits 1,737.13 12,356.41 24,344.00 50.76% 1,051.42 13,882.79 685.71 (1,526.38) Operations 80,464.16 942,528.99 1,054,414.00 89.39% 61,332.68 884,085.27 19,131.48 58,443.72 Capital Outlay 16,045.76 16,045.76 16,046.00 100.00% 12,142.83 16,045.76 3,902.93 Total 110,501.80 1,056,138.96 1,260,780.00 83.77% 69,420.36 999,106.67 41,081.44 57,032.29 Vehicle Maint. Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 18,720.73 150,640.73 234,480.77 64.24% 16,621.40 157,096.00 2,099.33 (6,455.27) Benefits 3,376.10 36,575.77 47,139.49 77.59% 2,596.05 42,244.80 780.05 (5,669.03) Operations 10,430.22 70,711.63 117,966.00 59.94% 40,070.16 10,430.22 30,641.47 Capital Outlay ‐ 40,000.00 0.00% 19,675.00 ‐ (19,675.00) Total 32,527.05 257,928.13 439,586.26 58.68% 19,217.45 259,085.96 13,309.60 (1,157.83) City of Prattville June Unaudited Expenses By Department Engineering Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 31,004.32 312,073.01 493,422.82 63.25% 36,998.94 339,231.68 (5,994.62) (27,158.67) Benefits 6,150.43 72,345.49 105,148.38 68.80% 6,101.81 86,746.83 48.62 (14,401.34) Operations 14,463.03 233,198.22 543,300.00 42.92% 7,958.06 215,584.48 6,504.97 17,613.74 Captial Projects ‐ 0.00%‐ ‐ Capital Outlay ‐ 268,977.61 300,000.00 89.66% 108,874.15 ‐ 160,103.46 Total 51,617.78 886,594.33 1,441,871.20 61.49% 51,058.81 750,437.14 558.97 136,157.19 Planning Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 20,075.67 188,500.12 269,868.43 69.85% 20,275.08 182,161.11 (199.41) 6,339.01 Benefits 3,415.10 32,500.31 47,227.87 68.82% 3,512.48 33,682.96 (97.38) (1,182.65) Operations 41,425.79 328,122.31 693,335.00 47.33% 37,211.85 295,332.38 4,213.94 32,789.93 Captial Projects ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ 27,839.00 27,839.00 100.00%‐ 27,839.00 Total 64,916.56 576,961.74 1,038,270.30 55.57% 60,999.41 511,176.45 3,917.15 65,785.29 Urban Management Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 71,098.16 599,131.58 917,120.07 65.33% 75,414.45 589,731.34 (4,316.29) 9,400.24 Benefits 12,492.61 120,346.61 166,388.70 72.33% 11,114.83 135,716.67 1,377.78 (15,370.06) Operations 31,391.58 245,181.42 577,050.00 42.49% 9,770.79 288,287.72 21,620.79 (43,106.30) Capital Outlay 8,397.52 8,397.52 315,000.00 2.67% 246,349.05 8,397.52 (237,951.53) Total 123,379.87 973,057.13 1,975,558.77 49.25% 96,300.07 1,260,084.78 27,079.80 (287,027.65) Facilities Maintenance Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 14,322.96 136,192.26 227,251.00 59.93% 14,716.68 150,220.45 (393.72) (14,028.19) Benefits 2,549.20 26,389.41 40,211.00 65.63% 2,292.12 31,135.84 257.08 (4,746.43) Operations 4,657.65 40,640.97 84,600.00 48.04% 721.58 29,910.28 3,936.07 10,730.69 Capital Outlay ‐ 21,868.00 25,000.00 87.47%‐ 21,868.00 Total 21,529.81 225,090.64 377,062.00 59.70% 17,730.38 211,266.57 3,799.43 13,824.07 Public Works Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 17,107.85 127,973.95 248,857.41 51.42% 12,654.42 110,745.43 4,453.43 17,228.52 Benefits 3,066.20 26,801.01 47,434.00 56.50% 2,162.52 21,640.41 903.68 5,160.60 Operations 12,321.18 57,830.91 102,396.00 56.48% 836.74 26,921.19 11,484.44 30,909.72 Capital Outlay 10,011.00 33,346.00 315,256.00 10.58% 10,011.00 33,346.00 Total 42,506.23 245,951.87 713,943.41 34.45% 15,653.68 159,307.03 26,852.55 86,644.84 Police Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 351,694.79 3,431,393.44 4,929,053.84 69.62% 348,734.83 3,351,514.73 2,959.96 79,878.71 Benefits 62,631.59 702,205.90 957,845.00 73.31% 58,579.37 791,089.53 4,052.22 (88,883.63) Operations 43,223.04 897,585.12 1,198,972.00 74.86% 51,025.05 858,239.18 (7,802.01) 39,345.94 Capital Outlay ‐ 167,034.00 222,712.00 75.00%‐ 315,255.00 ‐ (148,221.00) Total 457,549.42 5,198,218.46 7,308,582.84 71.12% 458,339.25 5,316,098.44 (789.83) (117,879.98) Fire Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 335,015.44 3,288,986.50 4,434,714.57 74.16% 340,741.57 3,279,734.68 (5,726.13) 9,251.82 Benefits 63,711.69 736,322.12 927,705.85 79.37% 57,522.31 860,977.15 6,189.38 (124,655.03) Operations 61,717.91 673,086.15 1,009,846.00 66.65% 24,893.35 660,172.62 36,824.56 12,913.53 Capital Outlay ‐ 775,570.42 789,905.00 98.19% 102,190.00 51,956.53 (102,190.00) 723,613.89 Total 460,445.04 5,473,965.19 7,162,171.42 76.43% 525,347.23 4,852,840.98 (64,902.19) 621,124.21 Building Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 22,264.00 211,490.04 284,584.67 74.32% 21,682.82 201,778.69 581.18 9,711.35 Benefits 3,973.17 39,753.54 54,088.11 73.50% 3,638.63 42,461.99 334.54 (2,708.45) Operations 1,883.81 27,828.70 57,134.00 48.71% 631.12 19,771.40 1,252.69 8,057.30 Capital Outlay ‐ 40,000.00 44,336.00 90.22% 27,568.00 ‐ 12,432.00 Total 28,120.98 319,072.28 440,142.78 72.49% 25,952.57 291,580.08 2,168.41 27,492.20 Parks & Recreation Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 73,214.39 470,373.21 668,496.00 70.36% 72,645.55 422,437.01 568.84 47,936.20 Benefits 9,784.82 88,688.28 114,243.00 77.63% 9,016.39 95,926.16 768.43 (7,237.88) Operations 62,189.35 477,564.66 1,010,665.00 47.25% 56,792.57 555,326.38 5,396.78 (77,761.72) Capital Outlay/ Capital Projects 118,858.41 358,935.00 33.11% 29,950.00 93,123.23 (29,950.00) 25,735.18 Total 145,188.56 1,155,484.56 2,152,339.00 53.69% 168,404.51 1,166,812.78 (23,215.95) (11,328.22) Performing Arts Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 5,316.83 46,105.56 65,503.04 70.39% 4,244.54 37,296.14 1,072.29 8,809.42 Benefits 775.41 6,857.86 8,835.94 77.61% 575.65 5,520.06 199.76 1,337.80 Operations 26,035.09 105,355.01 191,310.00 55.07% 12,181.32 79,415.02 13,853.77 25,939.99 Capital Outlay ‐ ‐ ‐ Total 32,127.33 158,318.43 265,648.98 59.60% 17,001.51 122,231.22 15,125.82 36,087.21 Non‐Departmental Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference City ‐ County Svcs 13,333.32 309,166.68 410,000.00 75.41% 13,333.32 311,601.70 ‐ (2,435.02) Community Initiatives 40,407.41 471,172.27 807,559.00 58.35% 130,444.79 854,879.36 (90,037.38) (383,707.09) Transfer to Group Health 207,168.75 1,864,518.75 2,486,025.00 75.00% 686,647.50 2,179,827.50 (479,478.75) (315,308.75) Transfer to Capital Project Fund 9,406.91 244,840.40 ‐ 100.00% 9,406.91 244,840.40 Transfer to Judicial ‐ ‐ 7,067.00 0.00%‐ ‐ Total 270,316.39 2,889,698.10 3,710,651.00 77.88% 830,425.61 3,346,308.56 (560,109.22) (456,610.46) Debt Service Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Debt Service ‐ 1,280,125.15 4,940,537.10 25.91% 665,703.56 3,982,766.31 (665,703.56) (2,702,641.16) Total ‐ 1,280,125.15 4,940,537.10 25.91% 665,703.56 3,982,766.31 (665,703.56) (2,702,641.16) Total Jun‐17 YTD Budget % of Budget Jun‐16 YTD June Difference YTD Difference Salary 1,045,851.65 9,730,367.37 13,911,201.71 69.95% 1,045,386.71 9,590,226.05 464.94 140,141.32 Benefits 390,959.67 3,860,721.25 5,169,489.43 74.68% 855,274.03 4,444,133.21 (464,314.36) (583,411.96) Operations 496,251.60 5,504,322.10 8,463,735.00 65.03% 427,999.92 5,562,235.15 68,251.68 (57,913.05) Capital Outlay 34,454.28 1,506,402.92 2,511,158.00 59.99% 132,140.00 874,943.79 (97,685.72) 631,459.13 Debt Service ‐ 1,280,125.15 4,940,537.10 25.91% 665,703.56 3,982,766.31 (665,703.56) (2,702,641.16) Total 1,967,517.20 21,881,938.79 34,996,121.24 62.53% 3,126,504.22 24,454,304.51 (1,158,987.02) (2,572,365.72) Prepared by Daniel Oakley