Loading...
March 2012 Council Expense InfoApril 16, 2012 50 % Year Complete Executive Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 13,223.40 82,024.27 176,866.26 46.38%15,342.42 86,057.96 (2,119.02) (4,033.69) Benefits 1,739.94 13,516.83 47,454.95 28.48%3,064.07 16,564.97 (1,324.13) (3,048.14) Operations 4,008.80 10,140.33 43,381.00 23.38%2,608.58 21,203.08 1,400.22 (11,062.75) Capital Outlay - - - - Total 18,972.14 105,681.43 267,702.21 39.48%21,015.07 123,826.01 (2,042.93) (18,144.58) Legislative Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 10,417.04 50,626.86 125,000.00 40.50%11,146.21 54,218.90 (729.17) (3,592.04) Benefits 9,107.02 25,314.86 71,106.50 35.60%6,635.43 24,154.97 2,471.59 1,159.89 Operations 841.19 2,378.70 23,840.00 9.98%136.67 (495.80) 704.52 2,874.50 Capital Outlay - - Total 20,365.25 78,320.42 219,946.50 35.61%17,918.31 77,878.07 2,446.94 442.35 Finance Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 18,459.89 109,379.77 235,293.18 46.49%19,072.09 160,638.77 (612.20) (51,259.00) Benefits 4,925.79 31,872.25 82,266.20 38.74%4,763.65 35,281.68 162.14 (3,409.43) Operations 8,472.83 159,590.87 238,220.00 66.99%18,617.45 233,438.65 (10,144.62) (73,847.78) Capital Outlay - - - - Total 31,858.51 300,842.89 555,779.38 54.13%42,453.19 429,359.10 (10,594.68) (128,516.21) City Clerk Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 8,886.55 53,056.95 112,377.50 47.21%20,216.73 90,913.20 (11,330.18) (37,856.25) Benefits 2,452.71 16,143.70 42,739.78 37.77%37,716.18 81,604.65 (35,263.47) (65,460.95) Operations 522.72 22,621.97 88,550.00 25.55%2,087.15 27,733.32 (1,564.43) (5,111.35) Capital Outlay - - - - Total 11,861.98 91,822.62 243,667.28 37.68%60,020.06 200,251.17 (48,158.08) (108,428.55) HR Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 14,526.10 87,156.60 188,839.30 46.15%14,526.10 87,882.90 - (726.30) Benefits 2,959.42 26,425.77 66,024.35 40.02%15,611.72 36,488.90 (12,652.30) (10,063.13) Operations 11,320.29 41,036.37 91,468.00 44.86%4,378.99 53,967.94 6,941.30 (12,931.57) Capital Outlay - - Total 28,805.81 154,618.74 346,331.65 44.64%34,516.81 178,339.74 (5,711.00) (23,721.00) Judicial Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 13,344.80 75,087.33 168,962.26 44.44%14,245.03 82,245.97 (900.23) (7,158.64) Benefits 2,346.38 25,163.16 74,944.67 33.58%5,091.58 31,984.79 (2,745.20) (6,821.63) Operations 361.84 19,790.33 194,950.00 10.15%28,999.94 75,723.15 (28,638.10) (55,932.82) Capital Outlay - - - - Total 16,053.02 120,040.82 438,856.93 27.35%48,336.55 189,953.91 (32,283.53) (69,913.09) City of Prattville March Unaudited Expenses By Department IT Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 4,656.14 28,727.76 64,542.14 44.51%13,608.29 82,110.43 (8,952.15) (53,382.67) Benefits 727.05 7,002.21 18,572.67 37.70%3,044.37 18,151.73 (2,317.32) (11,149.52) Operations 58,943.67 514,558.04 865,249.00 59.47%125,255.68 537,342.19 (66,312.01) (22,784.15) Capital Outlay - - - - - Total 64,326.86 550,288.01 948,363.81 58.02%141,908.34 637,604.35 (77,581.48) (87,316.34) Vehicle Maint.Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 20,054.73 120,260.45 257,086.60 46.78%27,301.51 168,247.68 (7,246.78) (47,987.23) Benefits 4,921.66 93,878.22 94,239.15 99.62%5,848.28 53,074.10 (926.62) 40,804.12 Operations 6,934.96 26,828.09 85,650.00 31.32%36,692.08 232,286.18 (29,757.12) (205,458.09) Capital Outlay - - - - Total 31,911.35 240,966.76 436,975.75 55.14%69,841.87 453,607.96 (37,930.52) (212,641.20) Engineering Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 34,493.03 206,786.62 447,748.60 46.18%18,155.19 109,934.14 16,337.84 96,852.48 Benefits 9,440.67 59,496.99 152,290.12 39.07%4,858.61 33,327.19 4,582.06 26,169.80 Operations 63,992.35 176,918.81 319,100.00 55.44%930.87 59,236.33 63,061.48 117,682.48 Capital Outlay 149,009.90 149,974.90 (149,009.90) (149,974.90) Total 107,926.05 443,202.42 919,138.72 48.22%172,954.57 352,472.56 (65,028.52) 90,729.86 Planning Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 25,740.60 154,615.18 334,627.02 46.21%39,687.97 239,567.58 (13,947.37) (84,952.40) Benefits 9,221.40 45,672.36 116,222.06 39.30%13,819.81 79,344.56 (4,598.41) (33,672.20) Operations 25,565.60 299,126.64 1,095,821.00 27.30%65,538.27 231,119.90 (39,972.67) 68,006.74 Capital Outlay - - - - Total 60,527.60 499,414.18 1,546,670.08 32.29%119,046.05 550,032.04 (58,518.45) (50,617.86) Street Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 51,934.34 321,051.41 (51,934.34) (321,051.41) Benefits 28,363.78 136,995.49 (28,363.78) (136,995.49) Operations 8,370.97 42,949.43 263,750.00 16.28%11,267.14 64,690.82 (2,896.17) (21,741.39) Capital Outlay - - - - Total 8,370.97 42,949.43 263,750.00 16.28%91,565.26 522,737.72 (83,194.29) (479,788.29) Urban Management Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 44,133.13 269,816.19 583,267.51 46.26%44,133.13 269,816.19 Benefits 13,051.36 124,114.26 263,174.19 47.16%13,051.36 124,114.26 Operations 19,952.91 55,412.92 332,720.00 16.65%19,952.91 55,412.92 Capital Outlay 21,361.71 21,361.71 37,730.00 56.62%21,361.71 21,361.71 Total 98,499.11 470,705.08 1,216,891.70 38.68%- - 98,499.11 470,705.08 Police Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 296,956.47 1,884,460.82 4,458,605.90 42.27%334,411.27 2,157,892.85 (37,454.80) (273,432.03) Benefits 74,519.71 630,045.60 1,476,051.28 42.68%129,792.34 737,909.35 (55,272.63) (107,863.75) Operations 39,006.08 223,502.62 645,672.00 34.62%38,313.87 215,647.19 692.21 7,855.43 Capital Outlay 78,742.00 0.00%- - - - Total 410,482.26 2,738,009.04 6,659,071.18 41.12%502,517.48 3,111,449.39 (92,035.22) (373,440.35) Fire Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 346,295.89 2,104,340.24 4,472,397.66 47.05%391,637.44 2,278,612.21 (45,341.55) (174,271.97) Benefits 98,885.49 729,505.70 1,486,063.89 49.09%142,066.84 839,282.92 (43,181.35) (109,777.22) Operations 45,337.53 270,517.34 707,374.00 38.24%39,443.46 232,446.00 5,894.07 38,071.34 Capital Outlay - - - - Total 490,518.91 3,104,363.28 6,665,835.55 46.57%573,147.74 3,350,341.13 (82,628.83) (245,977.85) Leisure Services Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 36,777.24 226,934.29 530,300.16 42.79%58,889.96 379,556.97 (22,112.72) (152,622.68) Benefits 9,778.73 87,541.39 214,222.99 40.86%24,898.10 147,042.28 (15,119.37) (59,500.89) Operations 66,521.36 261,804.72 775,795.00 33.75%63,082.94 289,649.23 3,438.42 (27,844.51) Capital Outlay - - - - Total 113,077.33 576,280.40 1,520,318.15 37.91%146,871.00 816,248.48 (33,793.67) (239,968.08) Performing Arts Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 3,828.24 23,774.69 52,057.98 45.67%5,453.72 32,555.35 (1,625.48) (8,780.66) Benefits 939.98 6,018.17 16,692.37 36.05%5,965.67 14,375.07 (5,025.69) (8,356.90) Operations 8,528.26 17,172.21 83,700.00 20.52%12,447.64 19,591.70 (3,919.38) (2,419.49) Capital Outlay - - - - Total 13,296.48 46,965.07 152,450.35 30.81%23,867.03 66,522.12 (10,570.55) (19,557.05) Non-Departmental Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference City - County Svcs - 155,500.00 395,000.00 39.37%63,333.33 195,333.33 (63,333.33) (39,833.33) Community Initiatives 16,250.00 166,890.26 558,165.00 29.90%34,166.68 80,772.68 (17,916.68) 86,117.58 Capital Projects 51,616.11 - 0.00%7,050.78 160,838.64 (7,050.78) (109,222.53) Total 16,250.00 374,006.37 953,165.00 104,550.79 436,944.65 (88,300.79) (62,938.28) Debt Service Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Debt Service 206,728.41 6,981,140.51 8,418,389.36 82.93%944,559.03 4,124,049.92 (737,830.62) 2,857,090.59 Total 206,728.41 6,981,140.51 8,418,389.36 82.93%944,559.03 4,124,049.92 (737,830.62) 2,857,090.59 Total Mar-12 YTD Budget % of Budget Mar-11 Prior Year YTD March Difference YTD Difference Salary 891,793.25 5,477,048.02 12,207,972.07 45%1,035,628.27 6,331,486.32 (143,835.02) (854,438.30) Benefits 245,017.31 1,921,711.47 4,222,065.17 46%431,540.43 2,285,582.65 (186,523.12) (363,871.18) Operations 384,931.36 2,466,739.65 6,808,405.00 36%547,300.74 2,569,685.89 (162,369.38) (102,946.24) Capital Outlay 21,361.71 21,361.71 116,472.00 18%149,009.90 149,974.90 (127,648.19) (128,613.19) Debt Service 206,728.41 6,981,140.51 8,418,389.36 83%944,559.03 4,124,049.92 (737,830.62) 2,857,090.59 Total 1,749,832.04 16,868,001.36 31,773,303.60 53%3,108,038.37 15,460,779.68 (1,358,206.33) 1,407,221.68 Capital Projects not in total - 51,616.11 7,050.78 160,838.64 Prepared by______________________________________________