Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
June 2012 Council Expense Info
July 17, 2012 75 % Year Complete Executive Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 19,527.88 123,460.76 176,866.26 69.80%11,993.57 123,375.93 7,534.31 84.83 Benefits 2,368.32 18,386.66 47,454.95 38.75%14,052.51 34,437.62 (11,684.19) (16,050.96) Operations 2,242.53 16,413.71 43,381.00 37.84%3,030.11 33,693.17 (787.58) (17,279.46) Capital Outlay - - - - Total 24,138.73 158,261.13 267,702.21 59.12%29,076.19 191,506.72 (4,937.46) (33,245.59) Legislative Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 10,417.04 81,877.98 125,000.00 65.50%10,417.04 85,470.02 - (3,592.04) Benefits 4,754.29 36,928.98 71,106.50 51.93%5,589.70 35,116.54 (835.41) 1,812.44 Operations 215.66 3,367.67 23,840.00 14.13%165.16 (350.72) 50.50 3,718.39 Capital Outlay - - Total 15,386.99 122,174.63 219,946.50 55.55%16,171.90 120,235.84 (784.91) 1,938.79 Finance Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 27,079.93 173,184.02 235,293.18 73.60%18,616.77 218,970.81 8,463.16 (45,786.79) Benefits 11,440.79 52,177.98 82,266.20 63.43%3,466.68 46,234.03 7,974.11 5,943.95 Operations 8,782.12 199,193.41 244,220.00 81.56%14,435.88 288,882.24 (5,653.76) (89,688.83) Capital Outlay - - Total 47,302.84 424,555.41 561,779.38 75.57%36,519.33 554,087.08 10,783.51 (129,531.67) City Clerk Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 12,371.49 83,201.54 112,377.50 74.04%6,221.69 121,544.29 6,149.80 (38,342.75) Benefits 4,443.38 30,677.48 42,739.78 71.78%4,359.54 106,466.58 83.84 (75,789.10) Operations 359.24 31,074.17 88,550.00 35.09%1,385.43 35,904.21 (1,026.19) (4,830.04) Capital Outlay 3,450.00 - - Total 17,174.11 144,953.19 247,117.28 58.66%11,966.66 263,915.08 5,207.45 (118,961.89) HR Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 21,789.15 137,997.95 188,839.30 73.08%13,799.62 130,008.50 7,989.53 7,989.45 Benefits 3,767.49 34,932.82 66,024.35 52.91%3,182.04 48,334.16 585.45 (13,401.34) Operations 4,187.44 47,515.84 91,468.00 51.95%5,015.79 69,111.12 (828.35) (21,595.28) Capital Outlay 3,447.50 3,450.00 - 3,447.50 Total 29,744.08 223,894.11 349,781.65 64.01%21,997.45 247,453.78 7,746.63 (23,559.67) Judicial Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 18,263.13 120,114.86 168,962.26 71.09%11,724.03 120,395.87 6,539.10 (281.01) Benefits 3,269.33 35,552.29 74,944.67 47.44%2,091.72 38,408.73 1,177.61 (2,856.44) Operations 151,899.38 174,038.55 194,950.00 89.27%17,156.92 128,376.63 134,742.46 45,661.92 Capital Outlay - - Total 173,431.84 329,705.70 438,856.93 75.13%30,972.67 287,181.23 142,459.17 42,524.47 City of Prattville June Unaudited Expenses By Department IT Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 7,365.21 45,805.53 64,542.14 70.97%9,796.70 113,631.60 (2,431.49) (67,826.07) Benefits 1,506.60 11,104.49 18,572.67 59.79%1,622.60 23,344.68 (116.00) (12,240.19) Operations 70,277.34 715,905.30 865,249.00 82.74%72,928.55 741,473.29 (2,651.21) (25,567.99) Capital Outlay - - - Total 79,149.15 772,815.32 948,363.81 81.49%84,347.85 878,449.57 (5,198.70) (105,634.25) Vehicle Maint.Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 30,515.99 190,944.50 257,086.60 74.27%18,594.60 240,077.27 11,921.39 (49,132.77) Benefits 6,747.36 124,361.97 94,239.15 131.96%6,403.73 77,331.46 343.63 47,030.51 Operations 20,034.96 69,807.54 85,650.00 81.50%33,349.03 346,478.97 (13,314.07) (276,671.43) Capital Outlay - - Total 57,298.31 385,114.01 436,975.75 88.13%58,347.36 663,887.70 (1,049.05) (278,773.69) Engineering Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 52,059.14 328,021.40 447,748.60 73.26%33,177.00 194,394.08 18,882.14 133,627.32 Benefits 20,283.83 96,174.22 152,290.12 63.15%9,456.76 54,885.35 10,827.07 41,288.87 Operations 16,078.13 219,255.52 319,100.00 68.71%(4,403.67) 59,167.59 20,481.80 160,087.93 Capital Outlay - 149,974.90 - (149,974.90) Total 88,421.10 643,451.14 919,138.72 70.01%38,230.09 458,421.92 50,191.01 185,029.22 Planning Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 38,620.88 244,608.31 334,627.02 73.10%24,376.20 327,196.66 14,244.68 (82,588.35) Benefits 7,470.40 69,248.71 116,222.06 59.58%9,549.97 107,456.12 (2,079.57) (38,207.41) Operations 198,328.74 739,236.11 1,095,821.00 67.46%41,912.53 354,874.03 156,416.21 384,362.08 Capital Outlay - - Total 244,420.02 1,053,093.13 1,546,670.08 68.09%75,838.70 789,526.81 168,581.32 263,566.32 Street Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 372,055.93 - (372,055.93) Benefits 6,033.03 159,409.68 (6,033.03) (159,409.68) Operations 10,524.46 80,033.88 263,750.00 30.34%18,009.44 106,027.79 (7,484.98) (25,993.91) Capital Outlay - - Total 10,524.46 80,033.88 263,750.00 30.34%24,042.47 637,493.40 (13,518.01) (557,459.52) Urban Management Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 74,141.00 429,413.82 627,144.51 68.47%47,261.03 96,241.11 26,879.97 333,172.71 Benefits 16,202.14 182,259.57 269,531.19 67.62%19,653.17 25,294.93 (3,451.03) 156,964.64 Operations 13,830.21 109,318.58 332,720.00 32.86%13,830.21 109,318.58 Capital Outlay 36,764.10 37,730.00 97.44%- 36,764.10 Total 104,173.35 757,756.07 1,267,125.70 59.80%66,914.20 121,536.04 37,259.15 636,220.03 Police Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 441,656.25 2,919,617.10 4,458,605.90 65.48%299,938.51 3,125,031.94 141,717.74 (205,414.84) Benefits 117,214.35 909,696.54 1,476,051.28 61.63%96,929.93 992,589.54 20,284.42 (82,893.00) Operations 44,306.15 373,975.98 645,672.00 57.92%49,879.30 353,691.25 (5,573.15) 20,284.73 Capital Outlay 78,742.00 0.00%- - Total 603,176.75 4,203,289.62 6,659,071.18 63.12%446,747.74 4,471,312.73 156,429.01 (268,023.11) Fire Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 498,092.33 3,284,425.66 4,478,570.46 73.34%314,152.60 3,282,504.37 183,939.73 1,921.29 Benefits 148,473.24 1,038,920.07 1,486,911.11 69.87%117,103.37 1,152,498.79 31,369.87 (113,578.72) Operations 41,457.73 444,734.19 707,374.00 62.87%28,960.86 332,078.43 12,496.87 112,655.76 Capital Outlay 36,500.00 203,381.00 - 36,500.00 Total 688,023.30 4,804,579.92 6,876,236.57 69.87%460,216.83 4,767,081.59 227,806.47 37,498.33 Leisure Services Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 88,263.60 399,104.76 530,300.16 75.26%58,111.68 541,894.43 30,151.92 (142,789.67) Benefits 14,692.72 116,116.71 214,222.99 54.20%15,353.01 184,552.45 (660.29) (68,435.74) Operations 45,277.21 417,313.80 775,795.00 53.79%54,273.93 446,460.90 (8,996.72) (29,147.10) Capital Outlay - - Total 148,233.53 932,535.27 1,520,318.15 61.34%127,738.62 1,172,907.78 20,494.91 (240,372.51) Performing Arts Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 5,903.90 37,987.34 52,057.98 72.97%5,386.34 48,404.54 517.56 (10,417.20) Benefits 1,214.17 8,624.52 16,692.37 51.67%936.84 18,999.87 277.33 (10,375.35) Operations 3,233.57 36,677.94 83,700.00 43.82%9,558.32 36,753.90 (6,324.75) (75.96) Capital Outlay - - Total 10,351.64 83,289.80 152,450.35 54.63%15,881.50 104,158.31 (5,529.86) (20,868.51) Non-Departmental Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference City - County Svcs 56,250.00 347,500.00 395,000.00 87.97%63,333.33 27,416.66 (7,083.33) 320,083.34 Community Initiatives 8,750.00 230,478.97 558,165.00 41.29%15,000.00 57,499.68 (6,250.00) 172,979.29 Capital Projects 69,774.39 - 0.00%6,675.20 190,241.99 (6,675.20) (120,467.60) Total 65,000.00 647,753.36 953,165.00 85,008.53 275,158.33 (20,008.53) 372,595.03 Debt Service Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Debt Service 232,486.92 4,342,482.48 8,418,389.36 51.58%417,697.83 6,435,841.39 (185,210.91) (2,093,358.91) Total 232,486.92 4,342,482.48 8,418,389.36 51.58%417,697.83 6,435,841.39 (185,210.91) (2,093,358.91) Total Jun-12 YTD Budget % of Budget Jun-11 Prior Year YTD June Difference YTD Difference Salary 1,346,066.92 8,599,765.53 12,258,021.87 70%883,567.38 9,141,197.35 462,499.54 (541,431.82) Benefits 363,848.41 2,765,163.01 4,229,269.39 65%315,784.60 3,105,360.53 48,063.81 (340,197.52) Operations 696,034.87 4,255,841.16 6,814,405.00 62%423,990.91 3,417,539.14 272,043.96 838,302.02 Capital Outlay - 76,711.60 326,753.00 23%- 149,974.90 - (73,263.30) Debt Service 232,486.92 4,342,482.48 8,418,389.36 52%417,697.83 6,435,841.39 (185,210.91) (2,093,358.91) Total 2,638,437.12 20,039,963.78 32,046,838.62 63%2,041,040.72 22,249,913.31 597,396.40 (2,209,949.53) Capital Projects not in total - 69,774.39 6,675.20 190,241.99 Prepared by______________________________________________