No preview available
 /
     
May 2013 Council Exp InfoAs of 6/13/2013 66.67 % Year Complete Executive May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary 21,292.77 122,652.10 227,110.33 54.01%10,197.94 103,932.88 11,094.83 18,719.22 Benefits 2,339.94 18,412.90 33,237.47 55.40%1,184.14 16,018.34 1,155.80 2,394.56 Operations 3,465.44 29,976.28 42,685.00 70.23%2,070.45 14,171.18 1,394.99 15,805.10 Capital Outlay - - - - Total 27,098.15 171,041.28 303,032.80 56.44%13,452.53 134,122.40 13,645.62 36,918.88 Legislative May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary 10,417.04 83,304.24 125,000.00 66.64%10,417.04 71,460.94 - 11,843.30 Benefits 409.68 12,289.14 16,856.50 72.90%3,627.30 32,174.69 (3,217.62) (19,885.55) Operations 536.93 4,008.64 23,840.00 16.81%575.75 3,152.01 (38.82) 856.63 Capital Outlay - - Total 11,363.65 99,602.02 165,696.50 60.11%14,620.09 106,787.64 (3,256.44) (7,185.62) Finance May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary 30,538.83 171,367.25 262,445.19 65.30%18,235.58 146,104.09 12,303.25 25,263.16 Benefits 4,414.77 32,986.25 47,573.82 69.34%3,456.86 40,737.19 957.91 (7,750.94) Operations 15,595.59 233,448.93 269,828.00 86.52%10,524.46 190,411.29 5,071.13 43,037.64 Capital Outlay - - Total 50,549.19 437,802.43 579,847.01 75.50%32,216.90 377,252.57 18,332.29 60,549.86 City Clerk May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary 12,371.49 72,660.67 113,608.32 63.96%8,886.55 70,830.05 3,484.94 1,830.62 Benefits 1,639.89 13,592.84 19,590.10 69.39%4,600.70 26,234.10 (2,960.81) (12,641.26) Operations 3,404.22 38,075.89 46,250.00 82.33%1,686.63 27,226.93 1,717.59 10,848.96 Capital Outlay 2,997.50 2,997.50 (2,997.50) (2,997.50) Total 17,415.60 124,329.40 179,448.42 69.28%18,171.38 127,288.58 (755.78) (2,959.18) HR May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary 21,789.15 123,471.85 188,839.30 65.38%14,526.10 116,208.80 7,263.05 7,263.05 Benefits 3,275.38 25,392.44 34,722.20 73.13%3,083.78 31,165.33 191.60 (5,772.89) Operations 1,794.52 61,687.82 98,982.00 62.32%894.94 43,328.40 899.58 18,359.42 Capital Outlay 2,997.50 2,997.50 (2,997.50) (2,997.50) Total 26,859.05 210,552.11 322,543.50 65.28%21,502.32 193,700.03 5,356.73 16,852.08 Judicial May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary 18,486.55 108,337.58 169,851.26 63.78%13,332.53 101,851.73 5,154.02 6,485.85 Benefits 2,336.40 21,435.87 29,883.90 71.73%3,044.58 32,282.96 (708.18) (10,847.09) Operations 26,872.98 180,556.55 195,640.00 92.29%302.25 22,139.17 26,570.73 158,417.38 Capital Outlay 6,395.00 0.00%- - Total 47,695.93 310,330.00 401,770.16 77.24%16,679.36 156,273.86 31,016.57 154,056.14 City of Prattville May Unaudited Expenses By Department IT May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary 7,143.36 40,556.19 107,631.33 37.68%4,839.40 38,440.32 2,303.96 2,115.87 Benefits 917.05 8,122.21 18,715.31 43.40%2,021.78 9,597.89 (1,104.73) (1,475.68) Operations 76,155.10 645,071.90 853,862.88 75.55%64,471.81 646,827.96 11,683.29 (1,756.06) Capital Outlay 49,520.31 98,005.01 97,771.80 100.24%49,520.31 98,005.01 Total 133,735.82 791,755.31 1,077,981.32 73.45%71,332.99 694,866.17 62,402.83 96,889.14 Vehicle Maint.May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary 30,246.14 170,406.03 301,827.40 56.46%19,950.70 160,428.51 10,295.44 9,977.52 Benefits 4,280.44 34,076.36 55,627.68 61.26%19,258.86 117,614.61 (14,978.42) (83,538.25) Operations 8,747.68 54,182.36 86,031.00 62.98%16,200.60 49,772.58 (7,452.92) 4,409.78 Capital Outlay - - Total 43,274.26 258,664.75 443,486.08 58.33%55,410.16 327,815.70 (12,135.90) (69,150.95) Engineering May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary 58,722.08 345,622.29 510,751.80 67.67%34,442.21 275,962.26 24,279.87 69,660.03 Benefits 8,790.56 65,520.38 94,101.64 69.63%8,604.93 75,890.39 185.63 (10,370.01) Operations 23,261.38 293,757.10 485,197.00 60.54%7,713.79 100,462.93 15,547.59 193,294.17 Captial Projects 0.00%2,204.50 106,167.24 (2,204.50) (106,167.24) Capital Outlay 80,000.00 0.00%- - Total 90,774.02 704,899.77 1,170,050.44 60.25%52,965.43 558,482.82 37,808.59 146,416.95 Planning May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary 27,373.81 207,145.16 334,627.02 61.90%25,740.57 205,987.43 1,633.24 1,157.73 Benefits 4,050.93 41,154.72 61,436.65 66.99%9,168.37 61,778.31 (5,117.44) (20,623.59) Operations 36,806.25 297,835.89 472,922.00 62.98%35,575.42 366,582.22 1,230.83 (68,746.33) Captial Projects 0.00%188,825.15 194,325.15 (188,825.15) (194,325.15) Capital Outlay 26,500.00 0.00%- - Total 68,230.99 546,135.77 895,485.67 60.99%259,309.51 828,673.11 (191,078.52) (282,537.34) Street May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary - - Benefits - - Operations 66,859.77 653,582.72 (66,859.77) (653,582.72) Capital Outlay - - Total - - - 0.00%66,859.77 653,582.72 (66,859.77) (653,582.72) Urban Management May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary 66,167.68 349,071.09 685,541.78 50.92%43,173.53 355,272.82 22,994.15 (6,201.73) Benefits 8,401.46 79,662.00 130,275.28 61.15%10,303.59 166,057.43 (1,902.13) (86,395.43) Operations 20,211.04 133,004.95 389,830.00 34.12%13,382.65 95,488.37 6,828.39 37,516.58 Capital Outlay 12,434.56 99,707.01 109,000.00 91.47%36,764.10 12,434.56 62,942.91 Total 107,214.74 661,445.05 1,314,647.06 50.31%66,859.77 653,582.72 40,354.97 7,862.33 Police May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary 481,536.60 2,705,835.48 4,470,745.21 60.52%299,867.51 2,477,960.85 181,669.09 227,874.63 Benefits 68,084.60 529,745.27 813,502.37 65.12%92,304.28 792,482.19 (24,219.68) (262,736.92) Operations 47,802.40 606,687.97 891,211.00 68.07%51,849.59 330,284.93 (4,047.19) 276,403.04 Capital Outlay 126,825.00 210,566.40 224,771.00 93.68%126,825.00 210,566.40 Total 724,248.60 4,052,835.12 6,400,229.58 63.32%444,021.38 3,600,727.97 280,227.22 452,107.15 Fire May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary 520,457.83 2,965,100.90 4,501,451.80 65.87%342,782.38 2,786,333.33 177,675.45 178,767.57 Benefits 78,110.45 571,817.84 819,940.40 69.74%96,702.06 890,446.79 (18,591.61) (318,628.95) Operations 57,777.83 483,659.56 749,735.00 64.51%69,971.05 403,276.50 (12,193.22) 80,383.06 Capital Outlay 31,046.24 50,000.00 62.09%36,500.00 36,500.00 (36,500.00) (5,453.76) Total 656,346.11 4,051,624.54 6,121,127.20 66.19%545,955.49 4,116,556.62 110,390.62 (64,932.08) Leisure Services May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary 59,779.64 321,267.07 584,125.14 55.00%44,557.50 310,841.16 15,222.14 10,425.91 Benefits 7,095.65 81,223.85 116,570.11 69.68%9,668.62 101,423.99 (2,572.97) (20,200.14) Operations 46,467.25 411,281.61 851,246.40 48.32%64,127.12 372,205.79 (17,659.87) 39,075.82 Capital Outlay 77,294.41 231,642.00 33.37%- 77,294.41 Total 113,342.54 891,066.94 1,783,583.65 49.96%118,353.24 784,470.94 (5,010.70) 106,596.00 Performing Arts May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference Salary 1,625.15 21,180.62 52,057.98 40.69%4,107.37 32,083.44 (2,482.22) (10,902.82) Benefits 59.68 3,998.40 8,879.37 45.03%830.74 7,410.35 (771.06) (3,411.95) Operations 6,437.19 43,028.08 88,123.00 48.83%5,961.78 33,444.37 475.41 9,583.71 Capital Outlay - - Total 8,122.02 68,207.10 149,060.35 45.76%10,899.89 72,938.16 (2,777.87) (4,731.06) Non-Departmental May-13 YTD Budget % of Budget May-12 YTD May Difference YTD Difference City - County Svcs 6,250.00 317,500.00 435,000.00 72.99%10,000.00 291,250.00 (3,750.00) 26,250.00 Community Initiatives 26,275.08 261,260.62 603,084.00 43.32%40,000.00 226,398.47 (13,724.92) 34,862.15 Transfer to Group Health 172,760.41 2,310,570.75 2,073,125.00 111.45%172,760.41 2,310,570.75 Capital Projects 7,902.33 108,229.06 978,853.86 11.06%69,774.39 7,902.33 38,454.67 Total 213,187.82 2,997,560.43 4,090,062.86 73.29%50,000.00 587,422.86 163,187.82 2,410,137.57 Debt Service May-13 YTD Budget % of Budget May-12 Prior Year YTD May Difference YTD Difference Debt Service 1,502,557.42 5,960,624.53 5,349,863.37 111.42%1,070,983.36 8,127,194.34 431,574.06 (2,166,569.81) Total 1,502,557.42 5,960,624.53 5,349,863.37 111.42%1,070,983.36 8,127,194.34 431,574.06 (2,166,569.81) Total May-13 YTD Budget % of Budget May-12 Prior Year YTD May Difference YTD Difference Salary 1,367,948.12 7,807,978.52 12,635,613.86 62%895,056.91 7,253,698.61 472,891.21 554,279.91 Benefits 366,967.29 3,850,001.22 4,374,037.80 88%267,860.59 2,401,314.56 99,106.70 1,448,686.66 Operations 407,860.88 4,095,024.15 6,583,467.28 62%462,168.06 3,870,005.82 (54,307.18) 225,018.33 Capital Projects 7,902.33 108,229.06 978,853.86 11%- 69,774.39 7,902.33 38,454.67 Capital Outlay 188,779.87 516,619.07 826,079.80 63%42,495.00 79,259.10 146,284.87 437,359.97 Debt Service 1,502,557.42 5,960,624.53 5,860,031.27 102%1,070,983.36 8,127,194.34 431,574.06 (2,166,569.81) Total 3,842,015.91 22,338,476.55 31,258,083.87 71%2,738,563.92 21,801,246.82 1,103,451.99 537,229.73 Prepared by______________________________________________