Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
November 2017 - Council Expense Information
As of 12/15/2017 16.67 % Year Complete Executive Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 19,879.71 33,993.01 322,218.00 10.55% 14,484.60 21,726.62 5,395.11 12,266.39 Benefits 2,546.93 4,128.62 44,131.00 9.36% 1,692.68 2,995.96 854.25 1,132.66 Operations 13,557.67 27,395.34 105,533.00 25.96% 18,565.78 24,313.57 (5,008.11) 3,081.77 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 35,984.31 65,516.97 471,882.00 13.88% 34,743.06 49,036.15 1,241.25 16,480.82 Legislative Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 10,417.04 20,834.08 125,000.00 16.67% 11,263.35 21,680.39 (846.31) (846.31) Benefits 859.05 1,575.30 10,415.00 15.13% 824.08 1,528.95 34.97 46.35 Operations ‐ 513.71 25,800.00 1.99% 1,585.11 1,585.11 (1,585.11) (1,071.40) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 11,276.09 22,923.09 161,215.00 14.22% 13,672.54 24,794.45 (2,396.45) (1,871.36) Finance Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 22,047.89 44,154.72 306,088.00 14.43% 20,021.19 28,412.16 2,026.70 15,742.56 Benefits 3,542.26 7,001.55 49,281.00 14.21% 3,075.08 4,933.71 467.18 2,067.84 Operations 17,993.17 25,067.79 259,155.00 9.67% 19,951.10 32,902.13 (1,957.93) (7,834.34) Capital Outlay ‐ ‐ 25,000.00 0.00%‐ ‐ Total 43,583.32 76,224.06 639,524.00 11.92% 43,047.37 66,248.00 535.95 9,976.06 City Clerk Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 9,711.27 19,422.54 126,487.00 15.36% 9,636.33 13,458.00 74.94 5,964.54 Benefits 1,543.44 2,963.62 20,169.00 14.69% 1,416.57 2,429.35 126.87 534.27 Operations 1,721.70 3,402.29 62,300.00 5.46% 3,922.58 18,064.45 (2,200.88) (14,662.16) Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 12,976.41 25,788.45 208,956.00 12.34% 14,975.48 33,951.80 (1,999.07) (8,163.35) HR Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 16,916.23 33,405.74 274,485.00 12.17% 16,070.28 24,427.29 845.95 8,978.45 Benefits 2,856.80 5,517.10 44,794.00 12.32% 2,730.65 4,778.38 126.15 738.72 Operations 5,025.89 8,198.05 87,550.00 9.36% 2,624.61 2,624.61 2,401.28 5,573.44 Capital Outlay ‐ ‐ 0.00%‐ ‐ Total 24,798.92 47,120.89 406,829.00 11.58% 21,425.54 31,830.28 3,373.38 15,290.61 IT Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 12,233.29 24,455.69 162,125.00 15.08% 7,291.64 10,937.46 4,941.65 13,518.23 Benefits 1,750.66 3,463.10 23,874.00 14.51% 1,024.76 1,778.27 725.90 1,684.83 Operations 130,950.09 181,683.82 1,259,460.00 14.43% 111,746.15 196,495.35 19,203.94 (14,811.53) Capital Outlay ‐ ‐ 40,000.00 0.00%‐ ‐ Total 144,934.04 209,602.61 1,485,459.00 14.11% 120,062.55 209,211.08 24,871.49 391.53 Vehicle Maint. Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 18,927.26 38,004.13 243,870.00 15.58% 17,137.27 25,728.03 1,789.99 12,276.10 Benefits 2,876.85 5,702.46 50,505.00 11.29% 2,554.40 4,523.07 322.45 1,179.39 Operations (3,425.23) (3,473.26) 104,950.00 ‐3.31% 27,709.28 28,294.11 (31,134.51) (31,767.37) Capital Outlay ‐ ‐ 25,000.00 0.00%‐ ‐ Total 18,378.88 40,233.33 424,325.00 9.48% 47,400.95 58,545.21 (29,022.07) (18,311.88) City of Prattville November Unaudited Expenses By Department Engineering Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 31,121.06 61,774.68 471,460.00 13.10% 32,002.44 48,126.79 (881.38) 13,647.89 Benefits 5,356.94 10,432.81 93,269.00 11.19% 5,338.15 9,609.38 18.79 823.43 Operations 16,824.14 54,894.54 622,346.00 8.82% 49,619.29 55,656.55 (32,795.15) (762.01) Captial Projects ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ Total 53,302.14 127,102.03 1,187,075.00 10.71% 86,959.88 113,392.72 (33,657.74) 13,709.31 Planning Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 16,758.42 36,201.99 247,504.00 14.63% 20,243.49 30,063.50 (3,485.07) 6,138.49 Benefits 2,859.97 6,027.04 41,702.00 14.45% 3,411.80 6,049.45 (551.83) (22.41) Operations 7,762.99 13,725.70 503,700.00 2.72% 58,735.79 86,798.82 (50,972.80) (73,073.12) Captial Projects ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ ‐ 6,000.00 0.00%‐ ‐ Total 27,381.38 55,954.73 798,906.00 7.00% 82,391.08 122,911.77 (55,009.70) (66,957.04) Urban Management Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 47,666.13 105,929.27 649,770.00 16.30% 63,656.29 95,867.02 (15,990.16) 10,062.25 Benefits 7,286.51 15,796.84 123,709.00 12.77% 9,754.44 17,443.70 (2,467.93) (1,646.86) Operations 17,139.80 47,022.94 564,750.00 8.33% 50,689.51 57,892.98 (33,549.71) (10,870.04) Capital Outlay ‐ ‐ 191,500.00 0.00%‐ ‐ Total 72,092.44 168,749.05 1,529,729.00 11.03% 124,100.24 171,203.70 (52,007.80) (2,454.65) Facilities Maintenance Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 20,846.86 40,304.47 267,205.00 15.08% 12,948.45 19,970.84 7,898.41 20,333.63 Benefits 3,133.87 6,020.43 47,755.00 12.61% 1,893.72 3,504.46 1,240.15 2,515.97 Operations 1,601.13 9,680.90 137,500.00 7.04% 6,755.15 7,062.13 (5,154.02) 2,618.77 Capital Outlay ‐ ‐ 405,000.00 0.00%‐ ‐ Total 25,581.86 56,005.80 857,460.00 6.53% 21,597.32 30,537.43 3,984.54 25,468.37 Public Works Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 33,342.35 58,744.44 582,714.00 10.08% 12,775.12 19,101.06 20,567.23 39,643.38 Benefits 5,275.74 9,250.40 131,966.00 7.01% 2,123.75 3,781.47 3,151.99 5,468.93 Operations 15,824.19 30,510.86 242,668.00 12.57% 10,296.25 10,948.93 5,527.94 19,561.93 Capital Outlay ‐ ‐ 85,000.00 0.00%‐ ‐ Total 54,442.28 98,505.70 1,042,348.00 9.45% 25,195.12 33,831.46 29,247.16 64,674.24 Police Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 384,343.69 760,422.07 5,031,675.00 15.11% 361,585.26 557,304.61 22,758.43 203,117.46 Benefits 61,564.01 120,920.49 1,016,170.00 11.90% 57,366.93 102,311.37 4,197.08 18,609.12 Operations 115,150.75 281,421.18 1,278,392.00 22.01% 205,402.16 286,841.52 (90,251.41) (5,420.34) Capital Outlay ‐ ‐ 206,251.00 0.00% 139,362.81 139,362.81 (139,362.81) (139,362.81) Total 561,058.45 1,162,763.74 7,532,488.00 15.44% 763,717.16 1,085,820.31 (202,658.71) 76,943.43 Fire Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 363,490.09 704,002.99 4,590,342.00 15.34% 348,102.07 524,683.21 15,388.02 179,319.78 Benefits 60,613.27 116,231.74 959,212.00 12.12% 56,963.77 99,983.15 3,649.50 16,248.59 Operations 88,190.24 180,183.69 1,167,011.00 15.44% 145,848.74 177,272.21 (57,658.50) 2,911.48 Capital Outlay ‐ ‐ 113,120.00 0.00% 726,905.00 726,905.00 (726,905.00) (726,905.00) Total 512,293.60 1,000,418.42 6,829,685.00 14.65% 1,277,819.58 1,528,843.57 (765,525.98) (528,425.15) Building Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 22,531.20 45,001.60 292,550.00 15.38% 22,484.14 34,419.12 47.06 10,582.48 Benefits 3,714.11 7,367.93 54,720.00 13.46% 3,655.83 6,605.93 58.28 762.00 Operations 151.21 4,675.56 63,450.00 7.37% 9,186.53 9,624.18 (9,035.32) (4,948.62) Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ Total 26,396.52 57,045.09 410,720.00 13.89% 35,326.50 50,649.23 (8,929.98) 6,395.86 Parks & Recreation Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 45,888.84 92,409.23 718,665.00 12.86% 45,709.64 68,508.18 179.20 23,901.05 Benefits 6,940.79 13,585.92 122,111.00 11.13% 6,640.83 11,531.53 299.96 2,054.39 Operations 37,104.69 85,051.93 1,208,999.00 7.03% 85,170.30 114,942.87 (48,065.61) (29,890.94) Capital Outlay/ Capital Projects ‐ ‐ 392,500.00 0.00%‐ ‐ Total 89,934.32 191,047.08 2,442,275.00 7.82% 137,520.77 194,982.58 (47,586.45) (3,935.50) Performing Arts Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 5,370.29 10,368.03 77,613.00 13.36% 4,411.14 6,643.66 959.15 3,724.37 Benefits 795.18 1,516.35 16,411.00 9.24% 637.36 1,069.59 157.82 446.76 Operations 2,940.79 7,156.07 222,760.00 3.21% 8,378.00 9,411.01 (5,437.21) (2,254.94) Capital Outlay ‐ ‐ ‐ ‐ Total 9,106.26 19,040.45 316,784.00 6.01% 13,426.50 17,124.26 (4,320.24) 1,916.19 Non‐Departmental Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference City ‐ County Svcs 13,333.34 107,500.01 410,000.00 26.22% 100,833.34 107,500.01 (87,500.00) ‐ Community Initiatives 57,684.97 95,483.84 930,624.00 10.26% 52,258.17 79,926.15 5,426.80 15,557.69 Transfer to DSF ‐ One Cent ‐ 3,445,563.44 6,366,000.00 54.12%‐ 3,445,563.44 Transfer to DSF ‐ Other ‐ 84,218.42 164,206.00 51.29%‐ 84,218.42 Transfer to Group Health 249,375.00 498,750.00 2,992,500.00 16.67% 207,168.75 414,337.50 42,206.25 84,412.50 Transfer to Capital Project Fund 580,391.45 609,474.35 112,300.00 542.72% 580,391.45 609,474.35 Transfer to Judicial ‐ 53,093.00 0.00%‐ ‐ Total 900,784.76 4,840,990.06 11,028,723.00 43.89% 360,260.26 601,763.66 540,524.50 4,239,226.40 Debt Service Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Debt Service 103,145.34 182,373.95 1,441,350.00 12.65% 87,643.30 1,449,550.13 15,502.04 (1,267,176.18) Total 103,145.34 182,373.95 1,441,350.00 12.65% 87,643.30 1,449,550.13 15,502.04 (1,267,176.18) Total Nov‐17 YTD Budget % of Budget Nov‐16 YTD November Difference YTD Difference Salary 1,081,491.62 2,129,428.68 14,489,771.00 14.70% 1,019,822.70 1,551,057.94 61,668.92 578,370.74 Benefits 422,891.38 836,251.70 5,842,694.00 14.31% 368,273.55 699,195.22 54,617.83 137,056.48 Operations 1,119,922.98 1,769,569.31 9,422,341.00 18.78% 969,277.84 1,308,156.69 150,645.14 461,412.62 Capital Outlay ‐ ‐ 1,489,371.00 0.00% 866,267.81 866,267.81 (866,267.81) (866,267.81) Debt Service 103,145.34 3,712,155.81 7,971,556.00 46.57% 87,643.30 1,449,550.13 15,502.04 2,262,605.68 Total 2,727,451.32 8,447,405.50 39,215,733.00 21.54% 3,311,285.20 5,874,227.79 (583,833.88) 2,573,177.71 Prepared by Daniel Oakley