Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
May 2017 - Council Expense Information
As of 6/16/2017 66.67 % Year Complete Executive May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 15,040.34 125,384.80 188,224.01 66.61% 14,422.77 120,116.18 617.57 5,268.62 Benefits 1,778.81 15,208.89 23,124.37 65.77% 1,732.30 15,438.21 46.51 (229.32) Operations 1,926.29 83,394.86 115,841.00 71.99% 1,390.89 41,460.00 535.40 41,934.86 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 18,745.44 223,988.55 327,189.38 68.46% 17,545.96 177,014.39 1,199.48 46,974.16 Legislative May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 10,417.04 84,342.74 125,000.00 67.47% 10,417.04 83,336.32 ‐ 1,006.42 Benefits 716.25 6,339.25 10,391.50 61.00% 695.65 6,435.23 20.60 (95.98) Operations 806.48 5,325.89 26,250.00 20.29% (243.78) 806.48 5,569.67 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 11,939.77 96,007.88 161,641.50 59.40% 11,112.69 89,527.77 827.08 6,480.11 Finance May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 21,896.89 177,297.98 303,798.29 58.36% 22,814.49 191,315.34 (917.60) (14,017.36) Benefits 3,402.47 27,969.70 51,498.48 54.31% 3,790.66 34,396.84 (388.19) (6,427.14) Operations 18,189.06 174,557.05 235,620.00 74.08% 165,253.18 427,609.27 (147,064.12) (253,052.22) Capital Outlay ‐ 28,466.20 27,839.00 102.25%‐ ‐ ‐ 28,466.20 Total 43,488.42 408,290.93 618,755.77 65.99% 191,858.33 653,321.45 (148,369.91) (245,030.52) City Clerk May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 9,660.07 80,936.29 125,523.26 64.48% 9,507.47 76,520.23 152.60 4,416.06 Benefits 1,399.68 12,232.37 19,803.25 61.77% 1,417.42 12,653.02 (17.74) (420.65) Operations 1,845.64 34,351.34 88,000.00 39.04% (3,829.65) 23,761.93 5,675.29 10,589.41 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 12,905.39 127,520.00 233,326.51 54.65% 7,095.24 112,935.18 5,810.15 14,584.82 HR May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 16,811.85 140,575.60 229,327.53 61.30% 16,283.91 134,374.77 527.94 6,200.83 Benefits 2,654.08 23,182.11 38,035.49 60.95% 2,665.78 23,894.27 (11.70) (712.16) Operations 5,492.42 38,978.37 96,600.00 40.35% (351.84) 27,120.60 5,844.26 11,857.77 Capital Outlay ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 24,958.35 202,736.08 363,963.02 55.70% 18,597.85 185,389.64 6,360.50 17,346.44 IT May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 12,327.52 72,953.05 165,976.00 43.95% 7,036.26 81,959.52 5,291.26 (9,006.47) Benefits 1,725.15 10,619.28 24,344.00 43.62% 1,060.23 12,831.37 664.92 (2,212.09) Operations 85,260.07 862,064.83 1,054,414.00 81.76% 63,577.56 815,861.39 21,682.51 46,203.44 Capital Outlay ‐ 16,046.00 0.00% 12,142.83 12,142.83 (12,142.83) (12,142.83) Total 99,312.74 945,637.16 1,260,780.00 75.00% 83,816.88 922,795.11 15,495.86 22,842.05 Vehicle Maint. May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 19,159.45 131,920.00 234,480.77 56.26% 17,823.48 140,474.60 1,335.97 (8,554.60) Benefits 2,818.32 33,199.67 47,139.49 70.43% 3,218.75 39,648.75 (400.43) (6,449.08) Operations 9,056.74 60,281.41 117,966.00 51.10% (8,258.66) 45,209.43 17,315.40 15,071.98 Capital Outlay ‐ 40,000.00 0.00% 19,675.00 ‐ (19,675.00) Total 31,034.51 225,401.08 439,586.26 51.28% 12,783.57 245,007.78 18,250.94 (19,606.70) City of Prattville May Unaudited Expenses By Department Engineering May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 30,638.24 281,068.69 493,422.82 56.96% 37,134.30 302,232.74 (6,496.06) (21,164.05) Benefits 5,031.09 66,195.06 105,148.38 62.95% 6,788.40 80,645.02 (1,757.31) (14,449.96) Operations 20,208.56 218,735.19 543,300.00 40.26% 8,110.83 203,267.61 12,097.73 15,467.58 Captial Projects ‐ 0.00%‐ ‐ Capital Outlay ‐ 268,977.61 300,000.00 89.66% 108,874.15 ‐ 160,103.46 Total 55,877.89 834,976.55 1,441,871.20 57.91% 52,033.53 695,019.52 3,844.36 139,957.03 Planning May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 19,690.42 168,424.45 269,868.43 62.41% 19,523.85 161,886.03 166.57 6,538.42 Benefits 3,300.30 29,085.21 47,227.87 61.58% 3,371.37 30,170.48 (71.07) (1,085.27) Operations 66,324.34 286,696.52 693,335.00 41.35% 54,356.33 257,368.11 11,968.01 29,328.41 Captial Projects ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ 27,839.00 27,839.00 100.00%‐ 27,839.00 Total 89,315.06 512,045.18 1,038,270.30 49.32% 77,251.55 449,424.62 12,063.51 62,620.56 Urban Management May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 67,885.02 528,033.42 917,120.07 57.58% 75,605.41 514,316.89 (7,720.39) 13,716.53 Benefits 9,905.19 107,854.00 166,388.70 64.82% 11,357.59 124,601.84 (1,452.40) (16,747.84) Operations 49,787.74 213,789.84 577,050.00 37.05% 27,602.73 269,583.99 22,185.01 (55,794.15) Capital Outlay ‐ 315,000.00 0.00% 246,349.05 ‐ (246,349.05) Total 127,577.95 849,677.26 1,975,558.77 43.01% 114,565.73 1,154,851.77 13,012.22 (305,174.51) Facilities Maintenance May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 14,643.40 121,869.30 222,213.17 54.84% 13,722.58 135,503.77 920.82 (13,634.47) Benefits 2,202.22 23,840.21 39,363.33 60.56% 2,367.34 28,843.72 (165.12) (5,003.51) Operations 9,154.55 35,983.32 84,600.00 42.53% 422.65 27,084.35 8,731.90 8,898.97 Capital Outlay 21,868.00 21,868.00 25,000.00 87.47% 21,868.00 21,868.00 Total 47,868.17 203,560.83 371,176.50 54.84% 16,512.57 191,431.84 31,355.60 12,128.99 Public Works May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 14,988.17 110,866.10 248,857.41 44.55% 12,638.54 98,091.01 2,349.63 12,775.09 Benefits 2,426.78 23,734.81 47,434.00 50.04% 2,146.39 19,477.89 280.39 4,256.92 Operations 10,530.02 45,509.73 102,396.00 44.44% 788.00 25,778.56 9,742.02 19,731.17 Capital Outlay 15,150.00 23,335.00 315,256.00 7.40% 15,150.00 23,335.00 Total 43,094.97 203,445.64 713,943.41 28.50% 15,572.93 143,347.46 27,522.04 60,098.18 Police May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 358,115.86 3,079,698.65 4,929,053.84 62.48% 370,503.69 3,002,779.90 (12,387.83) 76,918.75 Benefits 56,243.15 639,574.31 957,845.00 66.77% 66,933.79 732,510.16 (10,690.64) (92,935.85) Operations 112,864.61 854,362.08 1,254,650.00 68.10% 48,194.94 807,500.51 64,669.67 46,861.57 Capital Outlay ‐ 167,034.00 167,034.00 100.00%‐ 315,255.00 ‐ (148,221.00) Total 527,223.62 4,740,669.04 7,308,582.84 64.86% 485,632.42 4,858,045.57 41,591.20 (117,376.53) Fire May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 343,856.73 2,953,971.06 4,434,714.57 66.61% 346,400.58 2,938,993.11 (2,543.85) 14,977.95 Benefits 56,055.14 672,610.43 927,705.85 72.50% 65,798.00 803,454.84 (9,742.86) (130,844.41) Operations 129,252.89 611,368.24 1,050,345.96 58.21% 43,672.00 515,323.38 85,580.89 96,044.86 Capital Outlay ‐ 775,570.42 789,905.00 98.19%‐ 775,570.42 Total 529,164.76 5,013,520.15 7,202,671.38 69.61% 455,870.58 4,257,771.33 73,294.18 755,748.82 Building May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 22,213.60 189,226.04 284,584.67 66.49% 21,534.20 180,095.87 679.40 9,130.17 Benefits 3,581.86 35,780.37 54,088.11 66.15% 3,756.87 38,823.36 (175.01) (3,042.99) Operations 2,612.24 25,944.89 57,134.00 45.41% 902.48 221,196.16 1,709.76 (195,251.27) Capital Outlay ‐ 40,000.00 44,336.00 90.22% 27,568.00 ‐ 12,432.00 Total 28,407.70 290,951.30 440,142.78 66.10% 26,193.55 467,683.39 2,214.15 (176,732.09) Parks & Recreation May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 49,562.66 397,158.82 668,496.00 59.41% 52,171.67 349,791.46 (2,609.01) 47,367.36 Benefits 6,842.70 78,903.46 114,243.00 69.07% 7,856.92 86,909.77 (1,014.22) (8,006.31) Operations 103,272.14 415,375.31 1,069,712.00 38.83% 54,714.98 488,730.87 48,557.16 (73,355.56) Capital Outlay/ Capital Projects 86,422.41 118,858.41 328,691.00 36.16% 14,000.00 63,173.23 72,422.41 55,685.18 Total 246,099.91 1,010,296.00 2,181,142.00 46.32% 128,743.57 988,605.33 117,356.34 21,690.67 Performing Arts May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 5,215.97 40,788.73 65,503.04 62.27% 4,197.99 33,051.60 1,017.98 7,737.13 Benefits 751.63 6,082.45 8,835.94 68.84% 572.89 4,944.41 178.74 1,138.04 Operations 12,802.58 79,319.92 191,310.00 41.46% 390.93 64,398.33 12,411.65 14,921.59 Capital Outlay ‐ ‐ ‐ Total 18,770.18 126,191.10 265,648.98 47.50% 5,161.81 102,394.34 13,608.37 23,796.76 Non‐Departmental May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference City ‐ County Svcs ‐ 295,833.36 410,000.00 72.15%‐ 298,268.38 ‐ (2,435.02) Community Initiatives 75,331.53 430,764.86 871,659.00 49.42% 57,498.66 724,434.57 17,832.87 (293,669.71) Transfer to Group Health 207,168.75 1,657,350.00 2,486,025.00 66.67% 186,647.50 1,493,180.00 20,521.25 164,170.00 Transfer to Capital Project Fund 9,492.98 235,433.49 ‐ 100.00% 9,492.98 235,433.49 Transfer to Judicial ‐ ‐ 7,067.00 0.00%‐ ‐ Total 291,993.26 2,619,381.71 3,774,751.00 69.39% 244,146.16 2,515,882.95 47,847.10 103,498.76 Debt Service May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Debt Service 31,763.39 1,280,125.15 4,940,537.10 25.91% 330,227.28 3,317,062.75 (298,463.89) (2,036,937.60) Total 31,763.39 1,280,125.15 4,940,537.10 25.91% 330,227.28 3,317,062.75 (298,463.89) (2,036,937.60) Total May‐17 YTD Budget % of Budget May‐16 YTD May Difference YTD Difference Salary 1,032,123.23 8,684,515.72 13,906,163.88 62.45% 1,051,738.23 8,544,839.34 (19,615.00) 139,676.38 Benefits 368,003.57 3,469,761.58 5,168,641.76 67.13% 372,177.85 3,588,859.18 (4,174.28) (119,097.60) Operations 724,210.88 5,008,070.50 8,647,249.96 57.92% 514,436.01 5,283,713.66 209,774.87 (275,643.16) Capital Outlay 123,440.41 1,471,948.64 2,396,946.00 61.41% 26,142.83 793,037.26 97,297.58 678,911.38 Debt Service 31,763.39 1,280,125.15 4,940,537.10 25.91% 330,227.28 3,317,062.75 (298,463.89) (2,036,937.60) Total 2,279,541.48 19,914,421.59 35,059,538.70 56.80% 2,294,722.20 21,527,512.19 (15,180.72) (1,613,090.60) Prepared by Daniel Oakley