No preview available
 /
     
May 2014 Council Expense InformationAs of 6/11/2014 66.67 % Year Complete Executive May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 21,510.90 120,240.11 185,482.62 64.83%21,292.77 122,652.10 218.13 (2,411.99) Benefits 2,305.13 19,235.45 26,080.73 73.75%2,339.94 18,412.90 (34.81) 822.55 Operations 2,860.32 29,073.12 45,998.00 63.21%3,465.44 29,976.28 (605.12) (903.16) Capital Outlay - - Total 26,676.35 168,548.68 257,561.35 65.44%27,098.15 171,041.28 (421.80) (2,492.60) Legislative May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 10,417.04 72,919.28 125,000.00 58.34%10,417.04 83,304.24 - (10,384.96) Benefits 747.52 12,416.35 16,856.50 73.66%409.68 13,289.14 337.84 (872.79) Operations 622.37 2,498.64 23,390.00 10.68%536.93 4,008.64 85.44 (1,510.00) Capital Outlay - - Total 11,786.93 87,834.27 165,246.50 53.15%11,363.65 100,602.02 423.28 (12,767.75) Finance May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 32,720.50 172,105.26 273,059.80 63.03%30,538.83 171,367.25 2,181.67 738.01 Benefits 4,370.41 35,150.40 50,241.57 69.96%4,414.77 32,986.25 (44.36) 2,164.15 Operations 6,231.71 256,602.21 268,290.00 95.64%15,820.59 234,445.57 (9,588.88) 22,156.64 Capital Outlay - - Total 43,322.62 463,857.87 591,591.37 78.41%50,774.19 438,799.07 (7,451.57) 25,058.80 City Clerk May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 12,580.59 72,590.98 114,514.40 63.39%12,371.49 72,660.67 209.10 (69.69) Benefits 1,565.16 14,079.92 20,333.33 69.25%1,639.89 13,592.84 (74.73) 487.08 Operations 477.62 14,445.40 52,100.00 27.73%3,404.22 31,932.19 (2,926.60) (17,486.79) Capital Outlay - - Total 14,623.37 101,116.30 186,947.73 54.09%17,415.60 118,185.70 (2,792.23) (17,069.40) HR May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 22,224.93 123,326.58 190,727.69 64.66%21,789.15 123,471.85 435.78 (145.27) Benefits 2,988.35 25,078.58 36,267.47 69.15%3,275.38 25,392.44 (287.03) (313.86) Operations 1,952.55 25,113.33 91,125.00 27.56%1,794.52 61,687.82 158.03 (36,574.49) Capital Outlay - - Total 27,165.83 173,518.49 318,120.16 54.54%26,859.05 210,552.11 306.78 (37,033.62) IT May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 12,027.57 55,997.42 108,707.64 51.51%7,143.36 40,556.19 4,884.21 15,441.23 Benefits 1,499.64 11,060.74 19,498.26 56.73%917.05 8,122.21 582.59 2,938.53 Operations 82,454.27 677,994.81 907,921.28 74.68%94,038.49 646,553.08 (11,584.22) 31,441.73 Capital Outlay 10,463.83 10,463.83 110,172.00 9.50%49,520.31 98,005.01 (39,056.48) (87,541.18) Total 106,445.31 755,516.80 1,146,299.18 65.91%151,619.21 793,236.49 (45,173.90) (37,719.69) Vehicle Maint.May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 28,042.60 179,424.05 299,205.32 59.97%30,246.14 170,406.03 (2,203.54) 9,018.02 Benefits 3,502.35 35,518.06 55,238.10 64.30%4,280.44 34,076.36 (778.09) 1,441.70 Operations 10,123.30 79,314.37 100,980.00 78.54%8,747.68 53,682.36 1,375.62 25,632.01 Capital Outlay 19,546.61 20,000.00 97.73%- 19,546.61 Total 41,668.25 313,803.09 475,423.42 66.00%43,274.26 258,164.75 (1,606.01) 55,638.34 City of Prattville May Unaudited Expenses By Department Engineering May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 51,849.14 329,405.49 536,525.65 61.40%58,722.08 345,622.29 (6,872.94) (16,216.80) Benefits 6,796.77 65,254.68 102,801.26 63.48%8,790.56 65,520.38 (1,993.79) (265.70) Operations 204,440.71 214,689.51 620,800.00 34.58%26,075.30 265,073.47 178,365.41 (50,383.96) Captial Projects 0.00%- - Capital Outlay 20,768.20 446,363.44 545,000.00 81.90%20,768.20 446,363.44 Total 283,854.82 1,055,713.12 1,805,126.91 58.48%93,587.94 676,216.14 190,266.88 379,496.98 Planning May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 25,757.95 142,858.18 220,706.63 64.73%27,373.81 207,145.16 (1,615.86) (64,286.98) Benefits 3,492.21 29,587.00 41,312.93 71.62%4,050.93 41,154.72 (558.72) (11,567.72) Operations 25,367.36 271,256.13 622,273.00 43.59%38,109.75 330,476.39 (12,742.39) (59,220.26) Captial Projects 0.00%- - Capital Outlay - - 15,000.00 0.00%- - Total 54,617.52 443,701.31 899,292.56 49.34%69,534.49 578,776.27 (14,916.97) (135,074.96) Urban Management May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 91,206.68 427,023.46 816,831.17 52.28%66,167.68 349,071.09 25,039.00 77,952.37 Benefits 11,629.36 101,115.92 170,834.08 59.19%8,401.26 79,662.00 3,228.10 21,453.92 Operations 66,185.17 187,053.60 367,049.75 50.96%20,216.68 132,604.73 45,968.49 54,448.87 Capital Outlay 20,250.00 76,426.72 238,500.00 32.04%12,434.56 99,707.01 7,815.44 (23,280.29) Total 189,271.21 791,619.70 1,593,215.00 49.69%107,220.18 661,044.83 82,051.03 130,574.87 Facilities Maintenance May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 12,861.19 76,934.09 174,935.92 43.98%- - 12,861.19 76,934.09 Benefits 1,628.14 15,550.17 34,964.32 44.47%- - 1,628.14 15,550.17 Operations 1,177.59 5,584.42 33,800.00 16.52%- - 1,177.59 5,584.42 Capital Outlay - - - 0.00%- - - - Total 15,666.92 98,068.68 243,700.24 40.24%- - 15,666.92 98,068.68 Police May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 504,322.73 2,729,643.65 4,448,270.03 61.36%481,536.60 2,705,835.48 22,786.13 23,808.17 Benefits 67,004.62 551,226.24 837,823.12 65.79%68,084.60 529,745.27 (1,079.98) 21,480.97 Operations 109,262.76 662,240.13 947,189.20 69.92%55,269.06 596,509.29 53,993.70 65,730.84 Capital Outlay - 148,100.00 215,690.00 68.66%126,825.00 210,566.40 (126,825.00) (62,466.40) Total 680,590.11 4,091,210.02 6,448,972.35 63.44%731,715.26 4,042,656.44 (51,125.15) 48,553.58 Fire May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 495,095.88 2,727,171.56 4,191,018.49 65.07%520,457.83 2,965,100.90 (25,361.95) (237,929.34) Benefits 66,483.57 548,429.79 791,017.02 69.33%78,110.45 571,817.84 (11,626.88) (23,388.05) Operations 61,395.73 549,548.10 812,025.00 67.68%58,577.83 476,560.67 2,817.90 72,987.43 Capital Outlay - 62,860.40 108,507.70 57.93%31,046.24 - 31,814.16 Total 622,975.18 3,888,009.85 5,902,568.21 65.87%657,146.11 4,044,525.65 (34,170.93) (156,515.80) Building May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 25,883.01 150,362.71 249,217.41 60.33%- - 25883.01 150362.71 Benefits 3,469.24 27,488.75 45,311.64 60.67%- - 3469.24 27488.75 Operations 624.92 12,839.65 42,470.00 30.23%- - 624.92 12839.65 Capital Outlay 25,999.95 26,000.00 100.00%- - 0 25999.95 Total 29,977.17 216,691.06 362,999.05 59.69%- - 29,977.17 216,691.06 Parks & Recreation May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 66,089.34 321,644.79 623,669.03 51.57%59,779.64 321,267.07 6,309.70 377.72 Benefits 8,326.31 92,933.56 136,420.54 68.12%7,095.65 81,223.85 1,230.66 11,709.71 Operations 49,213.09 454,152.32 840,535.00 54.03%46,567.47 402,257.27 2,645.62 51,895.05 Capital Outlay 11,050.00 21,851.25 35,000.00 62.43%38,250.00 185,544.69 (27,200.00) (163,693.44) Total 134,678.74 890,581.92 1,635,624.57 54.45%151,692.76 990,292.88 (17,014.02) (99,710.96) Performing Arts May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Salary 4,538.19 18,330.35 51,799.62 35.39%1,625.15 21,180.62 2,913.04 (2,850.27) Benefits 555.32 3,952.57 9,091.54 43.48%59.68 3,998.40 495.64 (45.83) Operations 4,158.50 41,230.47 96,460.00 42.74%6,547.69 42,500.12 (2,389.19) (1,269.65) Capital Outlay - - Total 9,252.01 63,513.39 157,351.16 40.36%8,232.52 67,679.14 1,019.49 (4,165.75) Non-Departmental May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference City - County Svcs 20,292.49 380,256.69 528,510.00 71.95%6,250.00 317,500.00 14,042.49 62,756.69 Community Initiatives 33,558.69 341,822.88 1,001,334.00 34.14%26,275.08 261,260.62 7,283.61 80,562.26 Transfer to Group Health 175,529.16 1,404,233.28 2,112,013.52 66.49%172,760.41 2,310,570.75 2,768.75 (906,337.47) Transfer to Judicial - - 4,000.00 0.00% Capital Projects 7,509.82 398,587.97 964,157.40 41.34%7,902.33 72,592.06 (392.51) 325,995.91 Total 236,890.16 2,524,900.82 4,610,014.92 54.77%213,187.82 2,961,923.43 23,702.34 (437,022.61) Debt Service May-14 YTD Budget % of Budget May-13 YTD May Difference YTD Difference Debt Service 103,683.00 5,141,463.08 5,861,791.84 87.71%1,806,176.17 6,142,296.40 (1,702,493.17) (1,000,833.32) Total 103,683.00 5,141,463.08 5,861,791.84 87.71%1,806,176.17 6,142,296.40 (1,702,493.17) (1,000,833.32) Total May-14 YTD Budget % of Budget May-13 Prior Year YTD May Difference YTD Difference Salary 1,417,128.24 7,719,977.96 12,609,671.42 61.22%1,349,461.57 7,699,640.94 67,666.67 20,337.02 Benefits 361,893.26 2,992,311.46 4,506,105.93 66.41%364,630.69 3,829,565.35 (2,737.43) (837,253.89) Operations 680,399.15 4,205,715.78 7,406,250.23 57%411,696.73 3,887,028.50 268,702.42 318,687.28 Capital Projects 7,509.82 398,587.97 964,157.40 41%7,902.33 72,592.06 (392.51) 325,995.91 Capital Outlay 62,532.03 811,612.20 1,313,869.70 62%227,029.87 624,869.35 (164,497.84) 186,742.85 Debt Service 103,683.00 5,141,463.08 5,861,791.84 88%1,806,176.17 6,142,296.40 (1,702,493.17) (1,000,833.32) Total 2,633,145.50 21,269,668.45 32,661,846.52 65.12%4,166,897.36 22,255,992.60 (1,533,751.86) (986,324.15) Prepared by______________________________________________