Loading...
June 2013 Council Exp InfoAs of 7/12/2013 75 % Year Complete Executive Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary 14,195.18 136,847.28 227,110.33 60.26%19,527.88 123,460.76 (5,332.70) 13,386.52 Benefits 1,683.84 20,096.74 33,237.47 60.46%2,368.32 18,386.66 (684.48) 1,710.08 Operations 2,043.41 32,019.69 42,685.00 75.01%2,242.53 16,413.71 (199.12) 15,605.98 Capital Outlay - - - - Total 17,922.43 188,963.71 303,032.80 62.36%24,138.73 158,261.13 (6,216.30) 30,702.58 Legislative Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary 10,417.04 93,721.28 125,000.00 74.98%10,417.04 81,877.98 - 11,843.30 Benefits 767.31 14,056.45 16,856.50 83.39%4,754.29 36,928.98 (3,986.98) (22,872.53) Operations 91.08 4,099.72 23,480.00 17.46%215.66 3,367.67 (124.58) 732.05 Capital Outlay - - Total 11,275.43 111,877.45 165,336.50 67.67%15,386.99 122,174.63 (4,111.56) (10,297.18) Finance Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary 20,990.65 192,357.90 262,445.19 73.29%27,079.93 173,184.02 (6,089.28) 19,173.88 Benefits 3,168.05 36,154.30 47,573.82 76.00%11,440.79 52,177.98 (8,272.74) (16,023.68) Operations 11,843.35 245,517.28 269,828.00 90.99%9,025.17 199,436.46 2,818.18 46,080.82 Capital Outlay - - Total 36,002.05 474,029.48 579,847.01 81.75%47,545.89 424,798.46 (11,543.84) 49,231.02 City Clerk Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary 8,886.55 81,547.22 113,608.32 71.78%12,371.49 83,201.54 (3,484.94) (1,654.32) Benefits 1,223.28 14,816.12 19,590.10 75.63%4,443.38 30,677.48 (3,220.10) (15,861.36) Operations 778.20 38,854.39 46,250.00 84.01%359.24 27,586.17 418.96 11,268.22 Capital Outlay 2,997.50 - (2,997.50) Total 10,888.03 135,217.73 179,448.42 75.35%17,174.11 144,462.69 (6,286.08) (9,244.96) HR Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary 14,526.10 137,997.95 188,839.30 73.08%21,789.15 137,997.95 (7,263.05) - Benefits 2,288.58 27,681.02 34,722.20 79.72%3,767.49 34,932.82 (1,478.91) (7,251.80) Operations 10,972.19 72,660.01 98,982.00 73.41%4,187.44 47,515.84 6,784.75 25,144.17 Capital Outlay 2,997.50 - (2,997.50) Total 27,786.87 238,338.98 322,543.50 73.89%29,744.08 223,444.11 (1,957.21) 14,894.87 Judicial Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary 13,662.04 121,999.62 169,851.26 71.83%18,263.13 120,114.86 (4,601.09) 1,884.76 Benefits 1,839.80 23,275.67 29,883.90 77.89%3,269.33 35,552.29 (1,429.53) (12,276.62) Operations 27,652.11 201,553.66 195,640.00 103.02%154,350.18 176,489.35 (126,698.07) 25,064.31 Capital Outlay 6,395.00 6,395.00 100.00%- 6,395.00 Total 43,153.95 353,223.95 401,770.16 87.92%175,882.64 332,156.50 (132,728.69) 21,067.45 City of Prattville June Unaudited Expenses By Department IT Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary 4,757.43 45,313.62 107,631.33 42.10%7,365.21 45,805.53 (2,607.78) (491.91) Benefits 681.07 8,803.28 18,715.31 47.04%1,506.60 11,105.49 (825.53) (2,302.21) Operations 38,865.97 701,821.26 853,862.88 82.19%70,278.90 717,106.86 (31,412.93) (15,285.60) Capital Outlay 98,005.01 97,771.80 100.24%- 98,005.01 Total 44,304.47 853,943.17 1,077,981.32 79.22%79,150.71 774,017.88 (34,846.24) 79,925.29 Vehicle Maint.Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary 20,210.91 190,616.94 301,827.40 63.15%30,515.99 190,944.50 (10,305.08) (327.56) Benefits 3,057.65 37,134.01 55,627.68 66.75%6,747.36 124,361.97 (3,689.71) (87,227.96) Operations 10,324.81 64,007.17 86,031.00 74.40%20,052.09 69,824.67 (9,727.28) (5,817.50) Capital Outlay - - Total 33,593.37 291,758.12 443,486.08 65.79%57,315.44 385,131.14 (23,722.07) (93,373.02) Engineering Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary 38,797.02 384,419.31 510,751.80 75.27%52,059.14 328,021.40 (13,262.12) 56,397.91 Benefits 6,081.14 71,601.52 94,101.64 76.09%20,283.83 96,174.22 (14,202.69) (24,572.70) Operations 20,673.08 284,577.69 485,197.00 58.65%16,493.21 223,123.38 4,179.87 61,454.31 Captial Projects 0.00%- - Capital Outlay 80,000.00 0.00%- - Total 65,551.24 740,598.52 1,170,050.44 63.30%88,836.18 647,319.00 (23,284.94) 93,279.52 Planning Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary 16,806.71 223,951.87 334,627.02 66.93%38,620.88 244,608.31 (21,814.17) (20,656.44) Benefits 2,662.72 43,817.44 61,436.65 71.32%7,470.40 69,248.71 (4,807.68) (25,431.27) Operations 32,644.44 363,120.83 472,922.00 76.78%33,609.80 600,192.02 (965.36) (237,071.19) Captial Projects 0.00%150,284.00 144,609.15 (150,284.00) (144,609.15) Capital Outlay 10,750.00 10,750.00 26,500.00 40.57%10,750.00 10,750.00 Total 62,863.87 641,640.14 895,485.67 71.65%229,985.08 1,058,658.19 (167,121.21) (417,018.05) Street Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary - - Benefits - - Operations 10,734.91 80,244.33 (10,734.91) (80,244.33) Capital Outlay - - Total - - - 0.00%- - Urban Management Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary 51,204.64 400,275.73 685,541.78 58.39%74,141.00 429,413.82 (22,936.36) (29,138.09) Benefits 6,885.98 86,547.98 130,275.28 66.43%16,202.14 182,259.57 (9,316.16) (95,711.59) Operations 34,802.01 167,188.05 389,830.00 42.89%18,196.11 113,684.48 16,605.90 53,503.57 Capital Outlay 99,707.01 109,000.00 91.47%36,764.10 - 62,942.91 Total 92,892.63 753,718.77 1,314,647.06 57.33%108,539.25 762,121.97 (15,646.62) (8,403.20) Police Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary 312,050.44 3,017,885.92 4,470,745.21 67.50%441,656.25 2,919,617.10 (129,605.81) 98,268.82 Benefits 47,034.82 576,780.09 813,502.37 70.90%117,214.35 909,696.54 (70,179.53) (332,916.45) Operations 79,488.90 669,855.81 891,211.00 75.16%44,391.15 374,675.98 35,097.75 295,179.83 Capital Outlay 210,566.40 224,771.00 93.68%- 210,566.40 Total 438,574.16 4,475,088.22 6,400,229.58 69.92%603,261.75 4,203,989.62 (164,687.59) 271,098.60 Fire Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary 373,363.72 3,338,464.62 4,501,451.80 74.16%498,092.33 3,284,425.66 (124,728.61) 54,038.96 Benefits 56,068.97 627,886.81 819,940.40 76.58%148,473.24 1,038,920.07 (92,404.27) (411,033.26) Operations 42,643.86 517,819.63 749,735.00 69.07%42,546.28 446,322.74 97.58 71,496.89 Capital Outlay 31,046.24 50,000.00 62.09%36,000.00 - (4,953.76) Total 472,076.55 4,515,217.30 6,121,127.20 73.76%689,111.85 4,805,668.47 (217,035.30) (290,451.17) Leisure Services Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary 58,512.94 379,780.01 584,125.14 65.02%88,263.60 399,104.76 (29,750.66) (19,324.75) Benefits 7,018.55 88,242.40 116,570.11 75.70%14,692.72 116,116.71 (7,674.17) (27,874.31) Operations 50,612.37 450,652.46 851,246.40 52.94%45,528.36 417,734.15 5,084.01 32,918.31 Capital Outlay 12,858.32 178,936.26 231,642.00 77.25%12,858.32 178,936.26 Total 129,002.18 1,097,611.13 1,783,583.65 61.54%148,484.68 932,955.62 (19,482.50) 164,655.51 Performing Arts Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference Salary 1,081.80 22,262.42 52,057.98 42.76%5,903.90 37,987.34 (4,822.10) (15,724.92) Benefits 82.75 4,081.15 8,879.37 45.96%1,214.17 8,624.52 (1,131.42) (4,543.37) Operations 2,361.14 44,861.26 88,123.00 50.91%3,233.57 36,677.94 (872.43) 8,183.32 Capital Outlay - - Total 3,525.69 71,204.83 149,060.35 47.77%10,351.64 83,289.80 (6,825.95) (12,084.97) Non-Departmental Jun-13 YTD Budget % of Budget Jun-12 YTD June Difference YTD Difference City - County Svcs 25,000.00 342,500.00 435,000.00 78.74%56,250.00 347,500.00 (31,250.00) (5,000.00) Community Initiatives 39,872.14 301,132.76 603,084.00 49.93%8,750.00 235,148.47 31,122.14 65,984.29 Transfer to Group Health 172,760.41 2,483,331.16 2,073,125.00 119.79%172,760.41 2,483,331.16 Capital Projects 136,667.76 209,259.82 978,853.86 21.38%69,774.39 136,667.76 139,485.43 Total 374,300.31 3,336,223.74 4,090,062.86 81.57%65,000.00 652,422.86 309,300.31 2,683,800.88 Debt Service Jun-13 YTD Budget % of Budget Jun-12 Prior Year YTD June Difference YTD Difference Debt Service 94,091.06 6,054,715.59 5,349,863.37 113.18%262,421.44 8,389,615.78 (168,330.38) (2,334,900.19) Total 94,091.06 6,054,715.59 5,349,863.37 113.18%262,421.44 8,389,615.78 (168,330.38) (2,334,900.19) Total Jun-13 YTD Budget % of Budget Jun-12 Prior Year YTD June Difference YTD Difference Salary 959,463.17 8,767,441.69 12,635,613.86 69%1,346,066.92 8,599,765.53 (386,603.75) 167,676.16 Benefits 313,304.92 4,164,306.14 4,374,037.80 95%363,848.41 2,765,164.01 (50,543.49) 1,399,142.13 Operations 430,669.06 4,502,241.67 6,583,107.28 68%540,444.60 4,133,044.22 (109,775.54) 369,197.45 Capital Projects 136,667.76 209,259.82 978,853.86 21%- 69,774.39 136,667.76 139,485.43 Capital Outlay 23,608.32 635,405.92 826,079.80 77%- 78,759.10 23,608.32 556,646.82 Debt Service 94,091.06 6,054,715.59 5,860,031.27 103%262,421.44 8,389,615.78 (168,330.38) (2,334,900.19) Total 1,957,804.29 24,333,370.83 31,257,723.87 78%2,512,781.37 24,036,123.03 (554,977.08) 297,247.80 Prepared by______________________________________________