Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
August 2018 - Council Expense Information
As of 9/14/2018 91.67 % Year Complete Executive Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 29,980.86 233,537.69 322,218.00 72.48% 13,225.82 176,838.84 16,755.04 56,698.85 Benefits 3,775.34 29,800.24 44,131.00 67.53% 1,458.29 20,661.26 2,317.05 9,138.98 Operations 2,310.84 67,105.68 105,533.00 63.59% 3,257.85 91,339.56 (947.01) (24,233.88) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 36,067.04 330,443.61 471,882.00 70.03% 17,941.96 288,839.66 18,125.08 41,603.95 Legislative Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 10,417.04 114,587.44 125,000.00 91.67% 10,417.04 115,593.86 ‐ (1,006.42) Benefits 754.66 8,574.30 10,415.00 82.33% 811.45 8,691.40 (56.79) (117.10) Operations 1,525.81 8,634.56 25,800.00 33.47% 385.00 7,645.25 1,140.81 989.31 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 12,697.51 131,796.30 161,215.00 81.75% 11,613.49 131,930.51 1,084.02 (134.21) Finance Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 32,309.49 268,503.68 293,988.00 91.33% 22,119.32 243,431.91 10,190.17 25,071.77 Benefits 5,018.22 41,807.81 47,381.00 88.24% 3,462.56 38,331.40 1,555.66 3,476.41 Operations 18,806.71 218,298.00 259,155.00 84.23% 11,305.82 219,429.94 7,500.89 (1,131.94) Capital Outlay ‐ ‐ 25,000.00 0.00%‐ 28,466.20 ‐ (28,466.20) Total 56,134.42 528,609.49 625,524.00 84.51% 36,887.70 529,659.45 19,246.72 (1,049.96) City Clerk Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 13,805.88 115,783.39 126,487.00 91.54% 9,660.09 109,916.54 4,145.79 5,866.85 Benefits 2,133.63 17,189.73 20,169.00 85.23% 1,430.30 16,509.98 703.33 679.75 Operations 8,434.99 61,563.20 114,800.00 53.63% 5,056.69 43,045.21 3,378.30 18,517.99 Capital Outlay ‐ 365.00 ‐ 100.00%‐ ‐ ‐ 365.00 Total 24,374.50 194,901.32 261,456.00 74.54% 16,147.08 169,471.73 8,227.42 25,429.59 HR Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 32,120.59 234,359.25 274,485.00 85.38% 17,105.99 191,048.29 15,014.60 43,310.96 Benefits 5,239.94 38,590.18 44,794.00 86.15% 2,733.20 31,242.79 2,506.74 7,347.39 Operations 27,954.68 114,801.42 87,550.00 131.13% 7,312.22 58,083.17 20,642.46 56,718.25 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ Total 65,315.21 387,750.85 406,829.00 95.31% 27,151.41 280,374.25 38,163.80 107,376.60 IT Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 18,730.62 149,337.25 162,125.00 92.11% 12,585.24 110,069.66 6,145.38 39,267.59 Benefits 2,655.91 21,368.62 23,874.00 89.51% 1,782.71 15,867.16 873.20 5,501.46 Operations 79,041.64 1,063,420.41 1,174,168.00 90.57% 119,634.73 1,137,843.34 (40,593.09) (74,422.93) Capital Outlay ‐ 50,234.92 64,512.00 77.87%‐ 16,045.76 ‐ 34,189.16 Total 100,428.17 1,284,361.20 1,424,679.00 90.15% 134,002.68 1,279,825.92 (33,574.51) 4,535.28 Vehicle Maint. Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 28,079.47 202,838.43 243,870.00 83.17% 18,798.00 188,599.08 9,281.47 14,239.35 Benefits 4,407.93 41,041.23 50,505.00 81.26% 2,792.10 42,176.13 1,615.83 (1,134.90) Operations 2,253.64 34,043.40 104,950.00 32.44% 7,339.48 70,569.88 (5,085.84) (36,526.48) Capital Outlay ‐ ‐ 25,000.00 0.00% 22,923.99 22,923.99 (22,923.99) (22,923.99) Total 34,741.04 277,923.06 424,325.00 65.50% 51,853.57 324,269.08 (17,112.53) (46,346.02) City of Prattville August Unaudited Expenses By Department Engineering Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 54,524.25 414,182.42 471,460.00 87.85% 30,987.77 374,016.68 23,536.48 40,165.74 Benefits 9,144.56 83,110.19 93,269.00 89.11% 5,141.90 82,596.46 4,002.66 513.73 Operations 46,415.50 352,323.95 622,346.00 56.61% 51,436.65 327,764.16 (5,021.15) 24,559.79 Captial Projects ‐ ‐ ‐ 0.00%‐ ‐ ‐ Capital Outlay ‐ ‐ 146,476.00 0.00%‐ 268,977.61 ‐ (268,977.61) Total 110,084.31 849,616.56 1,333,551.00 63.71% 87,566.32 1,053,354.91 22,517.99 (203,738.35) Planning Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 23,774.65 199,948.07 247,504.00 80.79% 18,711.48 227,442.48 5,063.17 (27,494.41) Benefits 3,888.65 32,522.39 41,702.00 77.99% 3,135.56 39,045.22 753.09 (6,522.83) Operations 43,375.81 425,332.27 503,700.00 84.44% 34,967.38 385,273.60 8,408.43 40,058.67 Captial Projects ‐ ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ 6,011.00 6,000.00 100.18%‐ 27,839.00 ‐ (21,828.00) Total 71,039.11 663,813.73 798,906.00 83.09% 56,814.42 679,600.30 14,224.69 (15,786.57) Urban Management Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 93,964.57 636,872.07 649,770.00 98.02% 68,882.41 738,255.57 25,082.16 (101,383.50) Benefits 13,230.04 113,456.61 123,709.00 91.71% 9,855.36 140,154.80 3,374.68 (26,698.19) Operations 26,957.61 339,928.07 531,349.00 63.97% 32,538.35 302,931.80 (5,580.74) 36,996.27 Capital Outlay 11,858.39 34,382.39 205,833.00 16.70%‐ 8,397.52 11,858.39 25,984.87 Total 146,010.61 1,124,639.14 1,510,661.00 74.45% 111,276.12 1,189,739.69 34,734.49 (65,100.55) Facilities Maintenance Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 37,080.16 269,009.38 267,205.00 100.68% 16,517.24 167,192.64 20,562.92 101,816.74 Benefits 5,319.95 48,122.34 47,755.00 100.77% 2,484.37 31,052.83 2,835.58 17,069.51 Operations 1,629.62 112,153.28 137,500.00 81.57% 5,306.06 48,556.82 (3,676.44) 63,596.46 Capital Outlay 33,780.33 53,634.42 372,000.00 14.42%‐ 21,868.00 33,780.33 31,766.42 Total 77,810.06 482,919.42 824,460.00 58.57% 24,307.67 268,670.29 53,502.39 214,249.13 Public Works Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 29,478.66 322,501.97 582,714.00 55.34% 17,167.76 162,312.92 12,310.90 160,189.05 Benefits 4,711.99 85,294.13 131,966.00 64.63% 2,729.91 32,244.43 1,982.08 53,049.70 Operations 8,677.91 109,010.21 230,168.00 47.36% 5,001.36 64,977.27 3,676.55 44,032.94 Capital Outlay ‐ 6,550.00 85,000.00 7.71%‐ 240,249.00 ‐ (233,699.00) Total 42,868.56 523,356.31 1,029,848.00 50.82% 24,899.03 499,783.62 17,969.53 23,572.69 Police Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 545,509.01 4,390,577.67 5,031,675.00 87.26% 353,575.26 4,142,436.15 191,933.75 248,141.52 Benefits 86,906.90 866,831.41 1,016,170.00 85.30% 57,170.07 816,605.13 29,736.83 50,226.28 Operations 103,054.12 1,064,789.75 1,206,115.00 88.28% 89,055.36 1,077,739.62 13,998.76 (12,949.87) Capital Outlay 31,815.18 216,082.46 316,950.00 68.18%‐ 167,034.00 31,815.18 49,048.46 Total 767,285.21 6,538,281.29 7,570,910.00 86.36% 499,800.69 6,203,814.90 267,484.52 334,466.39 Fire Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 528,914.81 4,257,732.43 4,590,342.00 92.75% 344,400.74 3,972,969.34 184,514.07 284,763.09 Benefits 86,795.70 859,384.92 959,212.00 89.59% 56,003.24 847,711.49 30,792.46 11,673.43 Operations 104,516.60 947,558.14 1,146,362.00 82.66% 62,692.69 783,538.86 41,823.91 164,019.28 Capital Outlay 19,214.00 55,150.25 138,752.00 39.75%‐ 789,139.30 19,214.00 (733,989.05) Total 739,441.11 6,119,825.74 6,834,668.00 89.54% 463,096.67 6,393,358.99 276,344.44 (273,533.25) Building Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 33,779.92 256,274.77 292,550.00 87.60% 22,343.94 256,129.18 11,435.98 145.59 Benefits 5,564.54 45,258.36 54,720.00 82.71% 3,602.54 46,951.10 1,962.00 (1,692.74) Operations 1,322.20 39,879.51 63,450.00 62.85% 2,372.88 32,049.87 (1,050.68) 7,829.64 Capital Outlay ‐ ‐ ‐ 0.00%‐ 40,000.00 ‐ (40,000.00) Total 40,666.66 341,412.64 410,720.00 83.13% 28,319.36 375,130.15 12,347.30 (33,717.51) Parks & Recreation Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 102,719.82 667,191.58 718,665.00 92.84% 62,462.97 608,499.35 40,256.85 58,692.23 Benefits 13,870.40 108,792.46 122,111.00 89.09% 7,942.79 105,645.69 5,927.61 3,146.77 Operations 84,219.08 771,482.59 1,161,416.00 66.43% 60,134.22 576,432.34 24,084.86 195,050.25 Capital Outlay/ Capital Projects ‐ 191,972.19 459,151.00 41.81%‐ 149,100.93 ‐ 42,871.26 Total 200,809.30 1,739,438.82 2,461,343.00 70.67% 130,539.98 1,439,678.31 70,269.32 299,760.51 Performing Arts Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 9,020.15 69,743.16 77,613.00 89.86% 5,829.59 62,590.57 3,190.56 7,152.59 Benefits 1,305.00 10,236.65 16,411.00 62.38% 846.84 9,243.53 458.16 993.12 Operations 12,396.59 142,467.64 222,760.00 63.96% 5,365.22 118,593.63 7,031.37 23,874.01 Capital Outlay ‐ ‐ ‐ ‐ ‐ Total 22,721.74 222,447.45 316,784.00 70.22% 12,041.65 190,427.73 10,680.09 32,019.72 Non‐Departmental Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference City ‐ County Svcs 6,666.66 400,000.00 410,000.00 97.56% 13,333.32 400,000.00 (6,666.66) ‐ Community Initiatives 115,894.49 679,824.49 930,624.00 73.05% 59,443.05 576,312.89 56,451.44 103,511.60 Transfer to DSF ‐ One Cent 3,549,425.07 8,505,423.04 8,490,762.00 100.17%‐ 3,549,425.07 8,505,423.04 Transfer to DSF ‐ Other 164,205.83 164,206.00 100.00%‐ ‐ 164,205.83 Transfer to Group Health 249,375.00 2,743,125.00 2,992,500.00 91.67% 207,168.75 2,278,856.25 42,206.25 464,268.75 Transfer to Capital Project Fund 38,006.04 769,372.68 112,300.00 685.10% 65,103.74 364,308.62 (27,097.70) 405,064.06 Transfer to Judicial ‐ 53,093.00 0.00%‐ ‐ Total 3,959,367.26 13,261,951.04 13,153,485.00 100.82% 345,048.86 3,619,477.76 3,614,318.40 9,642,473.28 Debt Service Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Debt Service 199,582.99 1,289,973.66 1,441,350.00 89.50% 4,400.00 1,394,567.17 195,182.99 (104,593.51) Total 199,582.99 1,289,973.66 1,441,350.00 89.50% 4,400.00 1,394,567.17 195,182.99 (104,593.51) Total Aug‐18 YTD Budget % of Budget Aug‐17 YTD August Difference YTD Difference Salary 1,624,209.95 12,802,980.65 14,477,671.00 88.43% 1,044,790.66 11,847,343.06 579,419.29 955,637.59 Benefits 504,098.36 5,194,506.57 5,840,794.00 88.93% 370,551.94 4,603,587.05 133,546.42 590,919.52 Operations 733,460.54 7,721,989.25 9,203,139.00 83.91% 641,042.07 6,686,435.83 92,418.47 1,035,553.42 Capital Outlay 96,667.90 614,382.63 1,844,674.00 33.31% 22,923.99 1,780,041.31 73,743.91 (1,165,658.68) Debt Service 3,749,008.06 9,959,602.53 10,096,318.00 98.65% 4,400.00 1,394,567.17 3,744,608.06 8,565,035.36 Total 6,707,444.81 36,293,461.63 41,462,596.00 87.53% 2,083,708.66 26,311,974.42 4,623,736.15 9,981,487.21 Prepared by Daniel Oakley