No preview available
 /
     
Council Expense Info May 2012June 16, 2012 66.67 % Year Complete Executive May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 10,197.94 103,932.88 176,866.26 58.76%13,438.61 111,382.36 (3,240.67) (7,449.48) Benefits 1,184.14 16,018.34 47,454.95 33.75%1,910.18 20,367.11 (726.04) (4,348.77) Operations 2,070.45 14,171.18 43,381.00 32.67%7,253.08 30,663.06 (5,182.63) (16,491.88) Capital Outlay - - - - Total 13,452.53 134,122.40 267,702.21 50.10%22,601.87 162,412.53 (9,149.34) (28,290.13) Legislative May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 10,417.04 71,460.94 125,000.00 57.17%10,417.04 75,052.98 - (3,592.04) Benefits 3,627.30 32,174.69 71,106.50 45.25%2,547.16 29,526.84 1,080.14 2,647.85 Operations 575.75 3,152.01 23,840.00 13.22%(85.04) (515.88) 660.79 3,667.89 Capital Outlay - - Total 14,620.09 106,787.64 219,946.50 48.55%12,879.16 104,063.94 1,740.93 2,723.70 Finance May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 18,235.58 146,104.09 235,293.18 62.09%19,176.36 200,354.04 (940.78) (54,249.95) Benefits 3,456.86 40,737.19 82,266.20 49.52%3,837.61 42,767.35 (380.75) (2,030.16) Operations 10,070.76 184,673.84 244,220.00 75.62%13,929.07 274,446.36 (3,858.31) (89,772.52) Capital Outlay - - Total 31,763.20 371,515.12 561,779.38 66.13%36,943.04 517,567.75 (5,179.84) (146,052.63) City Clerk May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 8,886.55 70,830.05 112,377.50 63.03%14,855.24 115,322.60 (5,968.69) (44,492.55) Benefits 4,600.70 26,234.10 42,739.78 61.38%4,368.18 102,107.04 232.52 (75,872.94) Operations 5,134.13 30,714.93 88,550.00 34.69%5,710.63 34,518.78 (576.50) (3,803.85) Capital Outlay 3,450.00 - - - - Total 18,621.38 127,779.08 247,117.28 51.71%24,934.05 251,948.42 (6,312.67) (124,169.34) HR May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 14,526.10 116,208.80 188,839.30 61.54%14,258.36 116,208.88 267.74 (0.08) Benefits 3,083.78 31,165.33 66,024.35 47.20%9,947.15 45,186.73 (6,863.37) (14,021.40) Operations 894.94 43,328.40 91,468.00 47.37%3,610.78 64,095.33 (2,715.84) (20,766.93) Capital Outlay 3,447.50 3,447.50 3,450.00 3,447.50 3,447.50 Total 21,952.32 194,150.03 349,781.65 55.51%27,816.29 225,490.94 (5,863.97) (31,340.91) Judicial May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 13,332.53 101,851.73 168,962.26 60.28%12,486.44 108,671.84 846.09 (6,820.11) Benefits 3,044.58 32,282.96 74,944.67 43.08%2,272.91 36,317.01 771.67 (4,034.05) Operations 302.25 21,742.73 194,950.00 11.15%18,655.71 111,219.71 (18,353.46) (89,476.98) Capital Outlay - - Total 16,679.36 155,877.42 438,856.93 35.52%33,415.06 256,208.56 (16,735.70) (100,331.14) City of Prattville May Unaudited Expenses By Department IT May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 4,839.40 38,440.32 64,542.14 59.56%9,949.64 103,834.90 (5,110.24) (65,394.58) Benefits 2,021.78 9,597.89 18,572.67 51.68%1,674.68 21,722.08 347.10 (12,124.19) Operations 63,271.81 645,627.96 865,249.00 74.62%68,864.03 668,544.74 (5,592.22) (22,916.78) Capital Outlay - - - Total 70,132.99 693,666.17 948,363.81 73.14%80,488.35 794,101.72 (10,355.36) (100,435.55) Vehicle Maint.May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 19,950.70 160,428.51 257,086.60 62.40%19,821.53 221,482.67 129.17 (61,054.16) Benefits 19,258.86 117,614.61 94,239.15 124.80%9,177.22 70,927.73 10,081.64 46,686.88 Operations 16,066.91 49,638.89 85,650.00 57.96%38,132.17 313,129.94 (22,065.26) (263,491.05) Capital Outlay - - Total 55,276.47 327,682.01 436,975.75 74.99%67,130.92 605,540.34 (11,854.45) (277,858.33) Engineering May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 34,442.21 275,962.26 447,748.60 61.63%33,305.02 161,217.08 1,137.19 114,745.18 Benefits 8,604.93 75,890.39 152,290.12 49.83%8,785.81 45,428.59 (180.88) 30,461.80 Operations 9,630.53 202,885.02 319,100.00 63.58%1,794.01 63,571.26 7,836.52 139,313.76 Capital Outlay - 149,974.90 - (149,974.90) Total 52,677.67 554,737.67 919,138.72 60.35%43,884.84 420,191.83 8,792.83 134,545.84 Planning May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 25,740.57 205,987.43 334,627.02 61.56%25,209.35 302,820.46 531.22 (96,833.03) Benefits 8,168.37 61,778.31 116,222.06 53.16%8,066.48 97,906.15 101.89 (36,127.84) Operations 223,434.07 558,940.87 1,095,821.00 51.01%39,388.34 312,961.50 184,045.73 245,979.37 Capital Outlay - - Total 257,343.01 826,706.61 1,546,670.08 53.45%72,664.17 713,688.11 184,678.84 113,018.50 Street May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 372,055.93 - (372,055.93) Benefits 5,748.57 153,376.65 (5,748.57) (153,376.65) Operations 13,832.79 69,509.42 263,750.00 26.35%13,579.44 88,018.35 253.35 (18,508.93) Capital Outlay - - Total 13,832.79 69,509.42 263,750.00 26.35%19,328.01 613,450.93 (5,495.22) (543,941.51) Urban Management May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 43,173.53 355,272.82 627,144.51 56.65%48,980.08 48,980.08 (5,806.55) 306,292.74 Benefits 10,303.59 166,057.43 269,531.19 61.61%5,641.76 5,641.76 4,661.83 160,415.67 Operations 12,408.76 94,425.34 332,720.00 28.38%12,408.76 94,425.34 Capital Outlay 36,764.10 37,730.00 97.44%- 36,764.10 Total 65,885.88 652,519.69 1,267,125.70 51.50%54,621.84 54,621.84 11,264.04 597,897.85 Police May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 299,867.51 2,477,960.85 4,458,605.90 55.58%326,443.62 2,825,093.43 (26,576.11) (347,132.58) Benefits 92,304.28 792,482.19 1,476,051.28 53.69%84,424.13 895,659.61 7,880.15 (103,177.42) Operations 51,234.59 329,054.83 645,672.00 50.96%53,301.41 303,811.95 (2,066.82) 25,242.88 Capital Outlay 78,742.00 0.00%- - Total 443,406.38 3,599,497.87 6,659,071.18 54.05%464,169.16 4,024,564.99 (20,762.78) (425,067.12) Fire May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 342,782.38 2,786,333.33 4,478,570.46 62.21%329,293.32 2,968,351.77 13,489.06 (182,018.44) Benefits 96,702.06 890,446.83 1,486,911.11 59.89%95,001.69 1,035,395.42 1,700.37 (144,948.59) Operations 67,454.93 398,953.32 707,374.00 56.40%40,347.10 303,117.57 27,107.83 95,835.75 Capital Outlay 36,500.00 36,500.00 203,381.00 36,500.00 36,500.00 Total 543,439.37 4,112,233.48 6,876,236.57 59.80%464,642.11 4,306,864.76 78,797.26 (194,631.28) Leisure Services May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 44,557.50 310,841.16 530,300.16 58.62%46,522.08 483,782.75 (1,964.58) (172,941.59) Benefits 9,668.62 101,423.99 214,222.99 47.35%10,376.92 169,199.44 (708.30) (67,775.45) Operations 63,988.28 371,718.59 775,795.00 47.91%68,782.84 392,186.97 (4,794.56) (20,468.38) Capital Outlay - - Total 118,214.40 783,983.74 1,520,318.15 51.57%125,681.84 1,045,169.16 (7,467.44) (261,185.42) Performing Arts May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 4,102.37 32,083.44 52,057.98 61.63%5,304.15 43,018.20 (1,201.78) (10,934.76) Benefits 835.74 7,410.35 16,692.37 44.39%1,460.09 18,063.03 (624.35) (10,652.68) Operations 5,961.78 33,086.07 83,700.00 39.53%4,649.45 27,195.58 1,312.33 5,890.49 Capital Outlay - - Total 10,899.89 72,579.86 152,450.35 47.61%11,413.69 88,276.81 (513.80) (15,696.95) Non-Departmental May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference City - County Svcs 10,000.00 259,250.00 395,000.00 65.63%- 214,083.33 10,000.00 45,166.67 Community Initiatives 40,000.00 221,728.97 558,165.00 39.72%31,910.00 42,499.68 8,090.00 179,229.29 Capital Projects 147.00 82,306.00 - 0.00%13,828.95 203,301.12 (13,681.95) (120,995.12) Total 50,147.00 563,284.97 953,165.00 45,738.95 459,884.13 4,408.05 103,400.84 Debt Service May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Debt Service 1,070,983.36 8,127,194.34 8,418,389.36 96.54%1,579,103.20 10,170,648.86 (508,119.84) (2,043,454.52) Total 1,070,983.36 8,127,194.34 8,418,389.36 96.54%1,579,103.20 10,170,648.86 (508,119.84) (2,043,454.52) Total May-12 YTD Budget % of Budget May-11 Prior Year YTD May Difference YTD Difference Salary 895,051.91 7,253,698.61 12,258,021.87 59%929,460.84 8,257,629.97 (34,408.93) (1,003,931.36) Benefits 266,865.59 2,401,314.60 4,229,269.39 57%255,240.54 2,789,592.54 11,625.05 (388,277.94) Operations 596,332.73 3,532,602.37 6,814,405.00 52%409,823.02 3,243,548.23 186,509.71 289,054.14 Capital Outlay 39,947.50 76,711.60 326,753.00 23%- 149,974.90 39,947.50 (73,263.30) Debt Service 1,070,983.36 8,127,194.34 8,418,389.36 97%1,579,103.20 10,170,648.86 (508,119.84) (2,043,454.52) Total 2,869,181.09 21,391,521.52 32,046,838.62 67%3,173,627.60 24,611,394.50 (304,446.51) (3,219,872.98) Capital Projects not in total 147.00 82,306.00 13,828.95 203,301.12 Prepared by______________________________________________