Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
December 2017 - Council Expense Information
As of 1/12/2018 25.00 % Year Complete Executive Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 19,851.59 53,844.60 322,218.00 16.71% 14,484.04 36,210.10 5,367.55 17,634.50 Benefits 2,462.05 6,590.67 44,131.00 14.93% 1,703.41 4,711.27 758.64 1,879.40 Operations 1,248.57 28,877.43 105,533.00 27.36% 2,236.11 26,549.68 (987.54) 2,327.75 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 23,562.21 89,312.70 471,882.00 18.93% 18,423.56 67,471.05 5,138.65 21,841.65 Legislative Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 10,417.04 31,251.12 125,000.00 25.00% 10,208.38 31,888.77 208.66 (637.65) Benefits 716.25 2,291.55 10,415.00 22.00% 734.24 2,310.79 (17.99) (19.24) Operations 916.73 1,655.44 25,800.00 6.42% 731.65 2,316.76 185.08 (661.32) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 12,050.02 35,198.11 161,215.00 21.83% 11,674.27 36,516.32 375.75 (1,318.21) Finance Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 22,275.46 66,430.18 306,088.00 21.70% 20,367.71 48,779.87 1,907.75 17,650.31 Benefits 3,483.87 10,485.42 49,281.00 21.28% 3,201.14 8,155.25 282.73 2,330.17 Operations 46,158.90 71,656.65 259,155.00 27.65% 43,309.51 76,473.13 2,849.39 (4,816.48) Capital Outlay ‐ ‐ 25,000.00 0.00%‐ ‐ Total 71,918.23 148,572.25 639,524.00 23.23% 66,878.36 133,408.25 5,039.87 15,164.00 City Clerk Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 9,723.89 29,146.43 126,487.00 23.04% 9,560.03 23,018.03 163.86 6,128.40 Benefits 1,422.37 4,385.99 20,169.00 21.75% 1,451.00 2,895.65 (28.63) 1,490.34 Operations 9,810.79 13,377.11 62,300.00 21.47% 1,891.85 21,277.41 7,918.94 (7,900.30) Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 20,957.05 46,909.53 208,956.00 22.45% 12,902.88 47,191.09 8,054.17 (281.56) HR Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 16,887.70 50,293.44 274,485.00 18.32% 16,659.74 41,087.03 227.96 9,206.41 Benefits 2,715.00 8,232.10 44,794.00 18.38% 2,730.72 7,524.40 (15.72) 707.70 Operations 9,081.02 17,890.91 87,550.00 20.44% 8,370.58 8,925.58 710.44 8,965.33 Capital Outlay ‐ ‐ 0.00%‐ ‐ Total 28,683.72 76,416.45 406,829.00 18.78% 27,761.04 57,537.01 922.68 18,879.44 IT Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 12,238.59 36,694.28 162,125.00 22.63% 7,305.12 18,242.58 4,933.47 18,451.70 Benefits 1,714.78 5,177.88 23,874.00 21.69% 1,031.55 2,813.22 683.23 2,364.66 Operations 197,887.41 393,128.72 1,248,460.00 31.49% 210,944.10 411,816.21 (13,056.69) (18,687.49) Capital Outlay ‐ ‐ 51,000.00 0.00%‐ ‐ Total 211,840.78 435,000.88 1,485,459.00 29.28% 219,280.77 432,872.01 (7,439.99) 2,128.87 Vehicle Maint. Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 17,684.89 55,689.02 243,870.00 22.84% 16,774.95 42,502.98 909.94 13,186.04 Benefits 2,715.34 8,417.80 50,505.00 16.67% 2,529.67 7,064.64 185.67 1,353.16 Operations 3,809.18 1,325.08 104,950.00 1.26% 12,663.66 20,590.72 (8,854.48) (19,265.64) Capital Outlay ‐ ‐ 25,000.00 0.00%‐ ‐ Total 24,209.41 65,431.90 424,325.00 15.42% 31,968.28 70,158.34 (7,758.87) (4,726.44) City of Prattville December Unaudited Expenses By Department Engineering Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 33,927.80 95,702.48 471,460.00 20.30% 32,002.53 80,129.32 1,925.27 15,573.16 Benefits 5,614.04 16,046.85 93,269.00 17.20% 5,466.70 15,106.68 147.34 940.17 Operations 24,688.44 85,813.24 622,346.00 13.79% 31,693.56 93,136.16 (7,005.12) (7,322.92) Captial Projects ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ Total 64,230.28 197,562.57 1,187,075.00 16.64% 69,162.79 188,372.16 (4,932.51) 9,190.41 Planning Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 16,748.37 52,950.36 247,504.00 21.39% 19,615.37 49,678.87 (2,867.00) 3,271.49 Benefits 2,709.39 8,736.43 41,702.00 20.95% 3,363.76 9,429.36 (654.37) (692.93) Operations 12,578.40 37,705.81 503,700.00 7.49% 3,689.29 94,300.35 8,889.11 (56,594.54) Captial Projects ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ ‐ 6,000.00 0.00%‐ ‐ Total 32,036.16 99,392.60 798,906.00 12.44% 26,668.42 153,408.58 5,367.74 (54,015.98) Urban Management Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 46,899.59 152,828.86 649,770.00 23.52% 60,161.79 156,028.81 (13,262.20) (3,199.95) Benefits 7,104.05 22,900.89 123,709.00 18.51% 9,192.65 26,694.15 (2,088.60) (3,793.26) Operations 21,808.06 79,123.56 564,750.00 14.01% 21,099.39 80,984.35 708.67 (1,860.79) Capital Outlay ‐ ‐ 191,500.00 0.00%‐ ‐ Total 75,811.70 254,853.31 1,529,729.00 16.66% 90,453.83 263,707.31 (14,642.13) (8,854.00) Facilities Maintenance Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 21,284.06 61,588.53 267,205.00 23.05% 14,790.52 34,761.36 6,493.54 26,827.17 Benefits 3,152.95 9,173.38 47,755.00 19.21% 2,237.50 5,755.56 915.45 3,417.82 Operations 3,597.38 15,964.39 137,500.00 11.61% 6,599.30 13,755.07 (3,001.92) 2,209.32 Capital Outlay ‐ ‐ 405,000.00 0.00%‐ ‐ Total 28,034.39 86,726.30 857,460.00 10.11% 23,627.32 54,271.99 4,407.07 32,454.31 Public Works Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 33,189.54 91,933.98 582,714.00 15.78% 12,817.32 31,918.38 20,372.22 60,015.60 Benefits 5,054.29 14,304.69 131,966.00 10.84% 2,138.25 5,931.62 2,916.04 8,373.07 Operations 10,609.28 44,882.96 242,668.00 18.50% 10,934.18 22,058.01 (324.90) 22,824.95 Capital Outlay ‐ ‐ 85,000.00 0.00%‐ ‐ Total 48,853.11 151,121.63 1,042,348.00 14.50% 25,889.75 59,908.01 22,963.36 91,213.62 Police Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 404,654.53 1,165,076.60 5,031,675.00 23.15% 381,731.32 939,035.93 22,923.21 226,040.67 Benefits 64,241.42 185,161.91 1,016,170.00 18.22% 61,706.95 164,256.32 2,534.47 20,905.59 Operations 79,856.70 380,146.75 1,257,005.00 30.24% 60,548.32 367,039.99 19,308.38 13,106.76 Capital Outlay ‐ ‐ 227,638.00 0.00% 55,678.00 167,034.00 (55,678.00) (167,034.00) Total 548,752.65 1,730,385.26 7,532,488.00 22.97% 559,664.59 1,637,366.24 (10,911.94) 93,019.02 Fire Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 349,772.17 1,053,775.16 4,590,342.00 22.96% 388,249.33 912,932.54 (38,477.16) 140,842.62 Benefits 57,104.80 173,336.54 959,212.00 18.07% 63,489.92 163,687.27 (6,385.12) 9,649.27 Operations 74,182.18 284,752.04 1,167,011.00 24.40% 48,719.93 229,726.97 25,462.25 55,025.07 Capital Outlay ‐ ‐ 113,120.00 0.00%‐ 726,905.00 ‐ (726,905.00) Total 481,059.15 1,511,863.74 6,829,685.00 22.14% 500,459.18 2,033,251.78 (19,400.03) (521,388.04) Building Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 19,631.82 64,633.42 292,550.00 22.09% 22,132.68 56,551.80 (2,500.86) 8,081.62 Benefits 3,189.23 10,557.16 54,720.00 19.29% 3,626.16 10,249.09 (436.93) 308.07 Operations 2,961.70 16,078.67 63,450.00 25.34% 1,238.80 10,294.35 1,722.90 5,784.32 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ Total 25,782.75 91,269.25 410,720.00 22.22% 26,997.64 77,095.24 (1,214.89) 14,174.01 Parks & Recreation Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 45,519.61 137,928.84 718,665.00 19.19% 44,085.06 112,593.24 1,434.55 25,335.60 Benefits 6,591.01 20,176.93 122,111.00 16.52% 6,479.89 18,040.32 111.12 2,136.61 Operations 29,615.44 121,558.98 1,208,999.00 10.05% 4,631.94 120,413.18 24,983.50 1,145.80 Capital Outlay/ Capital Projects ‐ ‐ 392,500.00 0.00%‐ ‐ Total 81,726.06 279,664.75 2,442,275.00 11.45% 55,196.89 251,046.74 26,529.17 28,618.01 Performing Arts Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 5,583.38 15,951.41 77,613.00 20.55% 4,781.09 11,424.75 802.29 4,526.66 Benefits 805.67 2,322.02 16,411.00 14.15% 695.85 1,767.14 109.82 554.88 Operations 17,486.99 29,591.83 222,760.00 13.28% 14,247.33 23,658.28 3,239.66 5,933.55 Capital Outlay ‐ ‐ ‐ ‐ Total 23,876.04 47,865.26 316,784.00 15.11% 19,724.27 36,850.17 4,151.77 11,015.09 Non‐Departmental Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference City ‐ County Svcs 6,666.67 114,166.68 410,000.00 27.85% 6,666.67 114,166.68 ‐ ‐ Community Initiatives 73,698.20 169,182.04 930,624.00 18.18% 77,580.51 200,807.09 (3,882.31) (31,625.05) 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 748,125.00 2,992,500.00 25.00% 207,168.75 621,506.25 42,206.25 126,618.75 Transfer to Capital Project Fund 15,140.04 624,614.39 112,300.00 556.20% 15,140.04 624,614.39 Transfer to Judicial ‐ 53,093.00 0.00%‐ ‐ Total 344,879.91 5,185,869.97 11,028,723.00 47.02% 291,415.93 936,480.02 53,463.98 4,249,389.95 Debt Service Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Debt Service 155,068.39 337,442.34 1,441,350.00 23.41%‐ 1,449,550.13 155,068.39 (1,112,107.79) Total 155,068.39 337,442.34 1,441,350.00 23.41%‐ 1,449,550.13 155,068.39 (1,112,107.79) Total Dec‐17 YTD Budget % of Budget Dec‐16 YTD December Difference YTD Difference Salary 1,086,290.03 3,215,718.71 14,489,771.00 22.19% 1,075,726.98 2,626,784.36 10,563.05 588,934.35 Benefits 420,171.51 1,256,423.21 5,842,694.00 21.50% 378,948.11 1,077,898.98 41,223.40 178,524.23 Operations 641,802.08 2,531,492.68 9,389,954.00 26.96% 567,796.68 1,938,289.97 74,005.40 593,202.71 Capital Outlay ‐ ‐ 1,521,758.00 0.00% 55,678.00 893,939.00 (55,678.00) (893,939.00) Debt Service 155,068.39 3,867,224.20 7,971,556.00 48.51%‐ 1,449,550.13 155,068.39 2,417,674.07 Total 2,303,332.01 10,870,858.80 39,215,733.00 27.72% 2,078,149.77 7,986,462.44 225,182.24 2,884,396.36 Prepared by Daniel Oakley