Loading...
December 2012 Council ExpAs of 1/11/2013 25 % Year Complete Executive Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary 14,195.18 44,578.61 227,110.33 19.63%19,739.32 41,906.41 (5,544.14) 2,672.20 Benefits 1,674.05 6,278.12 33,237.47 18.89%4,945.38 8,205.00 (3,271.33) (1,926.88) Operations 5,463.50 14,847.60 42,685.00 34.78%3,619.61 9,281.16 1,843.89 5,566.44 Capital Outlay - - - - Total 21,332.73 65,704.33 303,032.80 21.68%28,304.31 59,392.57 (6,971.58) 6,311.76 Legislative Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary 10,417.04 31,219.04 125,000.00 24.98%10,417.04 20,834.08 - 10,384.96 Benefits 727.24 14,818.84 16,856.50 87.91%8,729.61 12,100.72 (8,002.37) 2,718.12 Operations 81.08 907.39 23,840.00 3.81%92.56 1,838.39 (11.48) (931.00) Capital Outlay - - Total 11,225.36 46,945.27 165,696.50 28.33%19,239.21 34,773.19 (8,013.85) 12,172.08 Finance Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary 20,698.65 58,979.75 262,445.19 22.47%26,678.73 54,430.65 (5,980.08) 4,549.10 Benefits 3,156.63 11,766.13 47,573.82 24.73%9,865.09 18,215.86 (6,708.46) (6,449.73) Operations 14,834.76 81,201.11 269,828.00 30.09%49,043.35 85,916.36 (34,208.59) (4,715.25) Capital Outlay - - Total 38,690.04 151,946.99 579,847.01 26.20%85,587.17 158,562.87 (46,897.13) (6,615.88) City Clerk Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary 8,886.55 24,742.98 113,608.32 21.78%9,670.88 26,397.30 (784.33) (1,654.32) Benefits 1,218.12 4,912.01 19,590.10 25.07%5,797.34 4,195.20 (4,579.22) 716.81 Operations 1,764.63 27,361.34 46,250.00 59.16%2,461.08 19,413.75 (696.45) 7,947.59 Capital Outlay - - Total 11,869.30 57,016.33 179,448.42 31.77%17,929.30 50,006.25 (6,060.00) 7,010.08 HR Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary 14,526.10 43,578.30 188,839.30 23.08%21,789.15 43,578.30 (7,263.05) - Benefits 2,855.82 11,253.46 34,722.20 32.41%7,574.14 12,503.95 (4,718.32) (1,250.49) Operations 16,725.27 34,842.77 98,982.00 35.20%4,026.13 28,348.79 12,699.14 6,493.98 Capital Outlay - - Total 34,107.19 89,674.53 322,543.50 27.80%33,389.42 84,431.04 717.77 5,243.49 Judicial Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary 13,380.36 36,322.86 169,851.26 21.39%17,674.38 35,635.05 (4,294.02) 687.81 Benefits 1,791.48 7,552.85 29,883.90 25.27%8,347.61 13,133.11 (6,556.13) (5,580.26) Operations 2,187.55 44,614.57 195,640.00 22.80%257.15 17,799.67 1,930.40 26,814.90 Capital Outlay 6,395.00 - - Total 17,359.39 88,490.28 401,770.16 22.03%26,279.14 66,567.83 (8,919.75) 21,922.45 City of Prattville December Unaudited Expenses By Department IT Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary 4,747.77 14,397.64 107,631.33 13.38%7,210.87 14,441.04 (2,463.10) (43.40) Benefits 689.79 2,746.17 18,715.31 14.67%2,320.98 4,544.08 (1,631.19) (1,797.91) Operations 162,154.06 324,800.72 951,634.68 34.13%100,008.01 226,303.54 62,146.05 98,497.18 Capital Outlay - - - - - Total 167,591.62 341,944.53 1,077,981.32 31.72%109,539.86 245,288.66 58,051.76 96,655.87 Vehicle Maint.Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary 20,119.58 60,372.18 301,827.40 20.00%30,113.78 59,877.60 (9,994.20) 494.58 Benefits 3,081.80 12,349.96 55,627.68 22.20%30,513.99 69,572.61 (27,432.19) (57,222.65) Operations 9,199.49 16,836.32 86,031.00 19.57%4,569.42 12,353.83 4,630.07 4,482.49 Capital Outlay - - Total 32,400.87 89,558.46 443,486.08 20.19%65,197.19 141,804.04 (32,796.32) (52,245.58) Engineering Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary 38,802.13 117,781.67 510,751.80 23.06%51,663.30 103,409.19 (12,861.17) 14,372.48 Benefits 6,129.32 23,460.60 94,101.64 24.93%17,264.44 23,952.92 (11,135.12) (492.32) Operations 19,301.62 153,025.84 485,197.00 31.54%6,383.24 54,591.48 12,918.38 98,434.36 Captial Projects 0.00%- - Capital Outlay - - 80,000.00 0.00%- - Total 64,233.07 294,268.11 1,170,050.44 25.15%75,310.98 181,953.59 (11,077.91) 112,314.52 Planning Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary 25,644.69 77,120.98 334,627.02 23.05%38,579.56 77,334.79 (12,934.87) (213.81) Benefits 4,082.74 15,834.69 61,436.65 25.77%14,841.58 24,767.92 (10,758.84) (8,933.23) Operations 41,857.11 167,336.17 472,922.00 35.38%42,018.86 109,552.50 (161.75) 57,783.67 Captial Projects 0.00%- - Capital Outlay 26,500.00 0.00%- - Total 71,584.54 260,291.84 895,485.67 29.07%95,440.00 211,655.21 (23,855.46) 48,636.63 Street Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary - - Benefits - - Operations 7,244.66 21,079.58 (7,244.66) (21,079.58) Capital Outlay - - Total - - - 0.00%7,244.66 21,079.58 (7,244.66) (21,079.58) Urban Management Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary 39,816.20 118,927.50 685,541.78 17.35%65,347.15 140,172.49 (25,530.95) (21,244.99) Benefits 6,163.50 28,015.91 130,275.28 21.51%32,644.79 66,941.60 (26,481.29) (38,925.69) Operations 4,092.32 33,202.88 389,830.00 8.52%2,744.06 15,640.65 1,348.26 17,562.23 Capital Outlay 8,900.00 109,000.00 8.17%- 8,900.00 Total 50,072.02 189,046.29 1,314,647.06 14.38%100,736.00 222,754.74 (50,663.98) (33,708.45) Police Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary 331,723.99 980,559.78 4,470,745.21 21.93%487,737.06 972,685.26 (156,013.07) 7,874.52 Benefits 51,562.83 199,181.16 813,502.37 24.48%204,177.30 361,821.20 (152,614.47) (162,640.04) Operations 49,560.53 182,087.68 917,086.00 19.86%34,787.17 108,904.88 14,773.36 73,182.80 Capital Outlay 8,000.00 71,941.40 201,770.00 35.66%8,000.00 71,941.40 Total 440,847.35 1,433,770.02 6,403,103.58 22.39%726,701.53 1,443,411.34 (285,854.18) (9,641.32) Fire Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary 354,309.17 1,048,777.01 4,501,451.80 23.30%527,420.08 1,054,652.26 (173,110.91) (5,875.25) Benefits 55,748.58 210,145.35 819,940.40 25.63%186,438.82 445,759.19 (130,690.24) (235,613.84) Operations 51,383.30 202,226.59 749,735.00 26.97%61,787.74 126,437.48 (10,404.44) 75,789.11 Capital Outlay 30,403.00 30,403.00 50,000.00 60.81%- - 30,403.00 30,403.00 Total 491,844.05 1,491,551.95 6,121,127.20 24.37%775,646.64 1,626,848.93 (283,802.59) (135,296.98) Leisure Services Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary 43,811.84 116,638.76 584,125.14 19.97%54,607.04 114,890.47 (10,795.20) 1,748.29 Benefits 5,905.31 29,650.47 116,570.11 25.44%36,105.15 61,974.13 (30,199.84) (32,323.66) Operations 27,252.23 157,655.91 849,618.40 18.56%33,126.97 126,339.57 (5,874.74) 31,316.34 Capital Outlay 10,000.00 - - Total 76,969.38 303,945.14 1,560,313.65 19.48%123,839.16 303,204.17 (46,869.78) 740.97 Performing Arts Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference Salary 3,302.03 11,401.52 52,057.98 21.90%6,006.69 11,996.26 (2,704.66) (594.74) Benefits 491.36 1,984.63 8,879.37 22.35%2,161.94 3,961.65 (1,670.58) (1,977.02) Operations 3,895.19 11,600.56 88,123.00 13.16%3,272.67 3,553.15 622.52 8,047.41 Capital Outlay - - Total 7,688.58 24,986.71 149,060.35 16.76%11,441.30 19,511.06 (3,752.72) 5,475.65 Non-Departmental Dec-12 YTD Budget % of Budget Dec-11 YTD December Difference YTD Difference City - County Svcs 66,250.00 172,500.00 435,000.00 39.66%56,250.00 75,000.00 10,000.00 97,500.00 Community Initiatives 24,719.00 111,511.72 603,084.00 18.49%1,875.00 15,086.26 22,844.00 96,425.46 Transfer to Group Health 2,073,125.00 0.00% Capital Projects 7,229.29 22,096.34 978,853.86 2.26%5,795.50 37,390.99 1,433.79 (15,294.65) Total 98,198.29 306,108.06 4,090,062.86 7.48%63,920.50 127,477.25 34,277.79 178,630.81 Debt Service Dec-12 YTD Budget % of Budget Dec-11 Prior Year YTD December Difference YTD Difference Debt Service 216,669.06 3,319,792.38 5,349,863.37 62.05%566,566.44 4,205,149.88 (349,897.38) (885,357.50) Total 216,669.06 3,319,792.38 5,349,863.37 62.05%566,566.44 4,205,149.88 (349,897.38) (885,357.50) Total Dec-12 YTD Budget % of Budget Dec-11 Prior Year YTD December Difference YTD Difference Salary 944,381.28 2,785,398.58 12,635,613.86 22%1,374,655.03 2,772,241.15 (430,273.75) 13,157.43 Benefits 145,278.57 579,950.35 4,374,037.80 13%571,728.16 1,131,649.14 (426,449.59) (551,698.79) Operations 500,721.64 1,736,559.17 6,705,486.08 26%413,567.68 1,057,441.04 87,153.96 679,118.13 Capital Projects 7,229.29 22,096.34 978,853.86 0%5,795.50 37,390.99 1,433.79 (15,294.65) Capital Outlay 38,403.00 111,244.40 483,665.00 23%- - 38,403.00 111,244.40 Debt Service 216,669.06 3,319,792.38 5,349,863.37 62%566,566.44 4,205,149.88 (349,897.38) (885,357.50) Total 1,852,682.84 8,555,041.22 30,527,519.97 28%2,932,312.81 9,203,872.20 (1,079,629.97) (648,830.98) Prepared by______________________________________________