Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
July 2017 - Council Expense Information
As of 8/11/2017 83.33 % Year Complete Executive Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 23,187.88 163,613.02 188,224.01 86.92% 14,422.77 148,961.71 8,765.11 14,651.31 Benefits 2,206.57 19,202.97 23,124.37 83.04% 1,729.24 18,908.59 477.33 294.38 Operations 3,284.01 88,081.71 99,698.00 88.35% 1,458.48 46,420.97 1,825.53 41,660.74 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 28,678.46 270,897.70 311,046.38 87.09% 17,610.49 214,291.27 11,067.97 56,606.43 Legislative Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 10,417.04 105,176.82 125,000.00 84.14% 10,417.04 104,170.40 ‐ 1,006.42 Benefits 763.85 7,879.95 10,391.50 75.83% 733.22 7,949.27 30.63 (69.32) Operations ‐ 7,260.25 26,250.00 27.66% 319.40 252.05 (319.40) 7,008.20 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 11,180.89 120,317.02 161,641.50 74.43% 11,469.66 112,371.72 (288.77) 7,945.30 Finance Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 22,062.31 221,312.59 303,798.29 72.85% 23,237.32 237,493.17 (1,175.01) (16,180.58) Benefits 3,437.80 34,868.84 51,498.48 67.71% 3,911.87 42,131.83 (474.07) (7,262.99) Operations 3,931.54 208,124.12 235,620.00 88.33% 11,324.85 343,893.48 (7,393.31) (135,769.36) Capital Outlay ‐ 28,466.20 27,839.00 102.25%‐ ‐ ‐ 28,466.20 Total 29,431.65 492,771.75 618,755.77 79.64% 38,474.04 623,518.48 (9,042.39) (130,746.73) City Clerk Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 9,660.08 100,256.45 125,523.26 79.87% 9,507.47 95,535.17 152.61 4,721.28 Benefits 1,414.99 15,079.68 19,803.25 76.15% 1,424.04 15,516.40 (9.05) (436.72) Operations 2,540.69 37,988.52 97,202.00 39.08% 12,811.23 44,370.37 (10,270.54) (6,381.85) Capital Outlay ‐ ‐ 5,458.00 0.00%‐ ‐ ‐ ‐ Total 13,615.76 153,324.65 247,986.51 61.83% 23,742.74 155,421.94 (10,126.98) (2,097.29) HR Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 16,674.70 173,942.30 216,591.53 80.31% 16,373.91 167,081.07 300.79 6,861.23 Benefits 2,658.03 28,509.59 37,088.49 76.87% 2,668.86 29,241.66 (10.83) (732.07) Operations 2,960.65 50,770.95 119,351.00 42.54% 1,865.06 39,840.42 1,095.59 10,930.53 Capital Outlay ‐ 22,832.00 0.00%‐ ‐ Total 22,293.38 253,222.84 395,863.02 63.97% 20,907.83 236,163.15 1,385.55 17,059.69 IT Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 12,276.62 97,484.42 165,976.00 58.73% 7,036.26 96,032.04 5,240.36 1,452.38 Benefits 1,728.04 14,084.45 24,344.00 57.86% 1,054.82 14,937.61 673.22 (853.16) Operations 75,679.62 1,018,208.61 1,054,414.00 96.57% 81,984.36 975,489.99 (6,304.74) 42,718.62 Capital Outlay ‐ 16,045.76 16,046.00 100.00% 12,142.83 ‐ 3,902.93 Total 89,684.28 1,145,823.24 1,260,780.00 90.88% 90,075.44 1,098,602.47 (391.16) 47,220.77 Vehicle Maint. Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 19,160.35 169,801.08 234,480.77 72.42% 16,689.35 173,785.35 2,471.00 (3,984.27) Benefits 2,808.26 39,384.03 47,139.49 83.55% 2,591.17 44,835.97 217.09 (5,451.94) Operations (7,481.23) 63,230.40 117,966.00 53.60% (6,938.03) 57,546.13 (543.20) 5,684.27 Capital Outlay ‐ 40,000.00 0.00% 19,675.00 ‐ (19,675.00) Total 14,487.38 272,415.51 439,586.26 61.97% 12,342.49 295,842.45 2,144.89 (23,426.94) City of Prattville July Unaudited Expenses By Department Engineering Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 30,955.90 343,028.91 493,422.82 69.52% 47,866.51 387,098.19 (16,910.61) (44,069.28) Benefits 5,109.07 77,454.56 105,148.38 73.66% 6,762.69 93,509.52 (1,653.62) (16,054.96) Operations 43,129.29 276,327.51 543,300.00 50.86% 16,880.64 358,532.75 26,248.65 (82,205.24) Captial Projects ‐ 0.00%‐ ‐ Capital Outlay ‐ 268,977.61 300,000.00 89.66% 10,874.15 ‐ 258,103.46 Total 79,194.26 965,788.59 1,441,871.20 66.98% 71,509.84 850,014.61 7,684.42 115,773.98 Planning Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 20,230.88 208,731.00 269,868.43 77.35% 20,790.54 202,951.65 (559.66) 5,779.35 Benefits 3,409.35 35,909.66 47,227.87 76.03% 3,586.92 37,269.88 (177.57) (1,360.22) Operations 22,183.91 350,306.22 693,335.00 50.52% 43,524.91 341,657.97 (21,341.00) 8,648.25 Captial Projects ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ 27,839.00 27,839.00 100.00%‐ 27,839.00 Total 45,824.14 622,785.88 1,038,270.30 59.98% 67,902.37 581,879.50 (22,078.23) 40,906.38 Urban Management Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 70,241.58 669,373.16 917,120.07 72.99% 74,030.61 663,761.95 (3,789.03) 5,611.21 Benefits 9,952.83 130,299.44 166,388.70 78.31% 10,847.31 146,563.38 (894.48) (16,263.94) Operations 25,212.03 270,393.45 577,050.00 46.86% 19,869.48 342,810.56 5,342.55 (72,417.11) Capital Outlay ‐ 8,397.52 315,000.00 2.67% 8,384.02 254,733.07 (8,384.02) (246,335.55) Total 105,406.44 1,078,463.57 1,975,558.77 54.59% 113,131.42 1,407,868.96 (7,724.98) (329,405.39) Facilities Maintenance Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 14,483.14 150,675.40 227,251.00 66.30% 12,716.41 162,936.86 1,766.73 (12,261.46) Benefits 2,179.05 28,568.46 40,211.00 71.05% 2,037.53 33,173.37 141.52 (4,604.91) Operations 2,609.79 43,250.76 84,600.00 51.12% 14,850.06 50,228.33 (12,240.27) (6,977.57) Capital Outlay ‐ 21,868.00 185,155.00 11.81%‐ 21,868.00 Total 19,271.98 244,362.62 537,217.00 45.49% 29,604.00 246,338.56 (10,332.02) (1,975.94) Public Works Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 17,171.21 145,145.16 248,857.41 58.32% 12,608.69 123,354.12 4,562.52 21,791.04 Benefits 2,713.51 29,514.52 47,434.00 62.22% 2,144.30 23,784.71 569.21 5,729.81 Operations 2,145.00 59,975.91 102,396.00 58.57% 5,577.79 40,256.91 (3,432.79) 19,719.00 Capital Outlay 206,903.00 240,249.00 315,256.00 76.21% 206,903.00 240,249.00 Total 228,932.72 474,884.59 713,943.41 66.52% 20,330.78 187,395.74 208,601.94 287,488.85 Police Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 357,467.45 3,788,860.89 4,929,053.84 76.87% 369,073.37 3,720,588.10 (11,605.92) 68,272.79 Benefits 57,229.16 759,435.06 957,845.00 79.29% 59,366.07 850,455.60 (2,136.91) (91,020.54) Operations 91,099.14 988,684.26 1,198,972.00 82.46% 74,763.60 962,717.79 16,335.54 25,966.47 Capital Outlay ‐ 167,034.00 283,831.00 58.85% 139,195.00 454,450.00 (139,195.00) (287,416.00) Total 505,795.75 5,704,014.21 7,369,701.84 77.40% 642,398.04 5,988,211.49 (136,602.29) (284,197.28) Fire Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 339,582.10 3,628,568.60 4,434,714.57 81.82% 345,302.47 3,625,037.15 (5,720.37) 3,531.45 Benefits 55,386.13 791,708.25 927,705.85 85.34% 57,874.28 918,851.43 (2,488.15) (127,143.18) Operations 47,760.02 720,846.17 1,050,346.00 68.63% 48,012.64 778,973.25 (252.62) (58,127.08) Capital Outlay 13,568.88 789,139.30 851,024.00 92.73% 51,956.53 13,568.88 737,182.77 Total 456,297.13 5,930,262.32 7,263,790.42 81.64% 451,189.39 5,374,818.36 5,107.74 555,443.96 Building Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 22,295.20 233,785.24 284,584.67 82.15% 21,664.48 223,443.17 630.72 10,342.07 Benefits 3,595.02 43,348.56 54,088.11 80.14% 3,617.72 46,079.71 (22.70) (2,731.15) Operations 1,848.29 29,676.99 57,134.00 51.94% 2,251.51 24,988.24 (403.22) 4,688.75 Capital Outlay ‐ 40,000.00 44,336.00 90.22% 27,568.00 ‐ 12,432.00 Total 27,738.51 346,810.79 440,142.78 78.80% 27,533.71 322,079.12 204.80 24,731.67 Parks & Recreation Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 75,663.17 546,036.38 668,496.00 81.68% 72,255.03 494,692.00 3,408.14 51,344.38 Benefits 9,014.62 97,702.90 114,243.00 85.52% 8,719.63 104,645.83 294.99 (6,942.93) Operations 38,733.46 516,298.12 1,010,665.00 51.08% 61,960.75 639,268.04 (23,227.29) (122,969.92) Capital Outlay/ Capital Projects 30,242.52 149,100.93 358,935.00 41.54% 104,348.23 30,242.52 44,752.70 Total 153,653.77 1,309,138.33 2,152,339.00 60.82% 142,935.41 1,342,954.10 10,718.36 (33,815.77) Performing Arts Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 10,655.42 56,760.98 65,503.04 86.65% 4,232.29 41,528.43 6,423.13 15,232.55 Benefits 1,538.83 8,396.69 8,835.94 95.03% 573.01 6,093.07 965.82 2,303.62 Operations 7,873.40 113,228.41 191,310.00 59.19% 32,204.81 119,113.12 (24,331.41) (5,884.71) Capital Outlay ‐ ‐ ‐ Total 20,067.65 178,386.08 265,648.98 67.15% 37,010.11 166,734.62 (16,942.46) 11,651.46 Non‐Departmental Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference City ‐ County Svcs 77,500.00 386,666.68 410,000.00 94.31% 13,333.32 324,935.02 64,166.68 61,731.66 Community Initiatives 45,697.57 516,869.84 739,279.00 69.92% 15,000.00 869,879.36 30,697.57 (353,009.52) Transfer to Group Health 207,168.75 2,071,687.50 2,483,850.00 83.41% 186,647.50 2,366,475.00 20,521.25 (294,787.50) Transfer to Capital Project Fund 54,364.48 299,204.88 ‐ 100.00% 54,364.48 299,204.88 Transfer to Judicial ‐ ‐ 7,067.00 0.00%‐ ‐ Total 384,730.80 3,274,428.90 3,640,196.00 89.95% 214,980.82 3,561,289.38 169,749.98 (286,860.48) Debt Service Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Debt Service 110,042.02 1,390,167.17 4,940,537.10 28.14% 100,940.33 4,083,706.64 9,101.69 (2,693,539.47) Total 110,042.02 1,390,167.17 4,940,537.10 28.14% 100,940.33 4,083,706.64 9,101.69 (2,693,539.47) Total Jul‐17 YTD Budget % of Budget Jul‐16 YTD July Difference YTD Difference Salary 1,072,185.03 10,802,552.40 13,898,465.71 77.72% 1,078,224.52 10,668,450.53 (6,039.49) 134,101.87 Benefits 372,313.86 4,233,035.11 5,166,367.43 81.93% 356,290.18 4,800,422.83 16,023.68 (567,387.72) Operations 541,071.66 6,045,393.76 8,415,955.00 71.83% 451,054.86 6,361,174.75 90,016.80 (315,780.99) Capital Outlay 250,714.40 1,757,117.32 2,793,551.00 62.90% 147,579.02 935,747.81 103,135.38 821,369.51 Debt Service 110,042.02 1,390,167.17 4,940,537.10 28.14% 100,940.33 4,083,706.64 9,101.69 (2,693,539.47) Total 2,346,326.97 24,228,265.76 35,214,876.24 68.80% 2,134,088.91 26,849,502.56 212,238.06 (2,621,236.80) Prepared by Daniel Oakley