Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
December 2018 - Council Expenditure Report
As of 1/25/2019 25.00 % Year Complete Executive Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 16,709.67 54,249.64 322,551.00 16.82% 19,851.59 53,844.60 (3,141.92) 405.04 Benefits 2,010.59 6,805.31 45,910.00 14.82% 2,462.05 6,590.67 (451.46) 214.64 Operations 17,134.26 33,043.14 137,333.00 24.06% 1,248.57 28,877.43 15,885.69 4,165.71 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 35,854.52 94,098.09 505,794.00 18.60% 23,562.21 89,312.70 12,292.31 4,785.39 Legislative Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 10,417.04 31,251.12 125,000.00 25.00% 10,417.04 31,251.12 ‐ ‐ Benefits 711.22 2,211.70 10,400.00 21.27% 716.25 2,291.55 (5.03) (79.85) Operations ‐ 689.77 13,600.00 5.07% 916.73 1,655.44 (916.73) (965.67) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 11,128.26 34,152.59 149,000.00 22.92% 12,050.02 35,198.11 (921.76) (1,045.52) Finance Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 22,156.57 60,000.46 334,879.00 17.92% 22,275.46 66,430.18 (118.89) (6,429.72) Benefits 3,628.17 10,469.35 56,850.00 18.42% 3,483.87 10,485.42 144.30 (16.07) Operations 6,162.85 21,902.02 242,460.00 9.03% 46,158.90 71,656.65 (39,996.05) (49,754.63) Capital Outlay ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 31,947.59 92,371.83 634,189.00 14.57% 71,918.23 148,572.25 (39,970.64) (56,200.42) City Clerk Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 10,355.14 27,311.80 136,748.00 19.97% 9,723.89 29,146.43 631.25 (1,834.63) Benefits 1,594.54 4,648.15 22,849.00 20.34% 1,422.37 4,385.99 172.17 262.16 Operations 1,202.03 5,807.79 49,250.00 11.79% 9,810.79 13,377.11 (8,608.76) (7,569.32) Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 13,151.71 37,767.74 208,847.00 18.08% 20,957.05 46,909.53 (7,805.34) (9,141.79) HR Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 21,594.53 59,304.29 283,708.00 20.90% 16,887.70 50,293.44 4,706.83 9,010.85 Benefits 3,790.13 11,116.77 52,191.00 21.30% 2,715.00 8,232.10 1,075.13 2,884.67 Operations 9,087.30 20,433.78 82,050.00 24.90% 9,081.02 17,890.91 6.28 2,542.87 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ Total 34,471.96 90,854.84 417,949.00 21.74% 28,683.72 76,416.45 5,788.24 14,438.39 IT Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 13,701.36 36,455.54 168,121.00 21.68% 12,238.59 36,694.28 1,462.77 (238.74) Benefits 2,040.64 5,693.98 26,195.00 21.74% 1,714.78 5,177.88 325.86 516.10 Operations 167,499.55 367,441.45 1,426,295.00 25.76% 197,887.41 393,128.72 (30,387.86) (25,687.27) Capital Outlay ‐ ‐ 109,000.00 0.00%‐ ‐ ‐ ‐ Total 183,241.55 409,590.97 1,729,611.00 23.68% 211,840.78 435,000.88 (28,599.23) (25,409.91) Vehicle Maint. Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 18,689.82 52,074.54 253,371.00 20.55% 17,684.89 55,689.02 1,004.93 (3,614.48) Benefits 3,119.42 9,187.17 55,222.00 16.64% 2,715.34 8,417.80 404.08 769.37 Operations 3,498.56 11,484.49 103,450.00 11.10% 3,809.18 1,325.08 (310.62) 10,159.41 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 25,307.80 72,746.20 412,043.00 17.66% 24,209.41 65,431.90 1,098.39 7,314.30 City of Prattville December Unaudited Expenditures By Department Engineering Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 36,556.97 100,962.14 488,503.00 20.67% 33,927.80 95,702.48 2,629.17 5,259.66 Benefits 6,562.78 19,344.09 110,944.00 17.44% 5,614.04 16,046.85 948.74 3,297.24 Operations 18,813.35 68,880.03 546,500.00 12.60% 24,688.44 85,813.24 (5,875.09) (16,933.21) Capital Projects ‐ ‐ ‐ 0.00%‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 61,933.10 189,186.26 1,145,947.00 16.51% 64,230.28 197,562.57 (2,297.18) (8,376.31) Planning Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 16,884.36 37,553.24 230,589.00 16.29% 16,748.37 52,950.36 135.99 (15,397.12) Benefits 3,003.56 6,953.50 40,930.00 16.99% 2,709.39 8,736.43 294.17 (1,782.93) Operations 36,166.36 84,628.84 502,450.00 16.84% 12,578.40 37,705.81 23,587.96 46,923.03 Capital Projects ‐ ‐ ‐ 0.00%‐ ‐ ‐ Capital Outlay ‐ ‐ 32,000.00 0.00%‐ ‐ ‐ ‐ Total 56,054.28 129,135.58 805,969.00 16.02% 32,036.16 99,392.60 24,018.12 29,742.98 Urban Management Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 66,532.02 157,510.11 843,847.00 18.67% 46,899.59 152,828.86 19,632.43 4,681.25 Benefits 9,359.88 25,145.44 165,421.00 15.20% 7,104.05 22,900.89 2,255.83 2,244.55 Operations 33,260.57 126,030.46 530,750.00 23.75% 21,808.06 79,123.56 11,452.51 46,906.90 Capital Outlay ‐ ‐ 63,000.00 0.00%‐ ‐ ‐ ‐ Total 109,152.47 308,686.01 1,603,018.00 19.26% 75,811.70 254,853.31 33,340.77 53,832.70 Facilities Maintenance Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 25,169.38 68,401.19 330,843.00 20.67% 21,284.06 61,588.53 3,885.32 6,812.66 Benefits 3,810.37 10,922.12 56,573.00 19.31% 3,152.95 9,173.38 657.42 1,748.74 Operations 14,907.29 42,382.65 170,000.00 24.93% 3,597.38 15,964.39 11,309.91 26,418.26 Capital Outlay ‐ ‐ 148,000.00 0.00%‐ ‐ ‐ ‐ Total 43,887.04 121,705.96 705,416.00 17.25% 28,034.39 86,726.30 15,852.65 34,979.66 Public Works Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 19,873.89 54,517.63 268,409.00 20.31% 33,189.54 91,933.98 (13,315.65) (37,416.35) Benefits 3,379.47 9,822.37 52,443.00 18.73% 5,054.29 14,304.69 (1,674.82) (4,482.32) Operations 22,881.34 56,020.44 241,718.00 23.18% 10,609.28 44,882.96 12,272.06 11,137.48 Capital Outlay ‐ ‐ 265,000.00 0.00%‐ ‐ ‐ ‐ Total 46,134.70 120,360.44 827,570.00 14.54% 48,853.11 151,121.63 (2,718.41) (30,761.19) Police Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 387,761.54 1,020,064.27 5,205,663.00 19.60% 404,654.53 1,165,076.60 (16,892.99) (145,012.33) Benefits 64,547.30 181,856.90 1,062,696.00 17.11% 64,241.42 185,161.91 305.88 (3,305.01) Operations 54,611.75 275,962.03 1,311,933.00 21.03% 79,856.70 380,146.75 (25,244.95) (104,184.72) Capital Outlay ‐ ‐ 112,000.00 0.00%‐ ‐ ‐ ‐ Total 506,920.59 1,477,883.20 7,692,292.00 19.21% 548,752.65 1,730,385.26 (41,832.06) (252,502.06) Fire Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 367,622.21 966,249.97 4,704,544.00 20.54% 349,772.17 1,053,775.16 17,850.04 (87,525.19) Benefits 64,592.56 179,759.21 1,046,996.00 17.17% 57,104.80 173,336.54 7,487.76 6,422.67 Operations 81,047.71 233,767.01 1,123,052.00 20.82% 74,182.18 284,752.04 6,865.53 (50,985.03) Capital Outlay ‐ ‐ 250,000.00 0.00%‐ ‐ ‐ Total 513,262.48 1,379,776.19 7,124,592.00 19.37% 481,059.15 1,511,863.74 32,203.33 (132,087.55) Building Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 22,623.70 62,162.51 300,082.00 20.72% 19,631.82 64,633.42 2,991.88 (2,470.91) Benefits 4,002.07 11,655.62 61,838.00 18.85% 3,189.23 10,557.16 812.84 1,098.46 Operations 1,905.35 17,219.53 63,200.00 27.25% 2,961.70 16,078.67 (1,056.35) 1,140.86 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 28,531.12 91,037.66 425,120.00 21.41% 25,782.75 91,269.25 2,748.37 (231.59) Parks & Recreation Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 57,448.40 158,592.86 940,078.00 16.87% 45,519.61 137,928.84 11,928.79 20,664.02 Benefits 9,036.50 25,966.21 150,087.00 17.30% 6,591.01 20,176.93 2,445.49 5,789.28 Operations 55,150.77 189,452.11 1,343,500.00 14.10% 29,615.44 121,558.98 25,535.33 67,893.13 Capital Outlay/ Capital Projects ‐ ‐ 754,820.00 0.00%‐ ‐ ‐ Total 121,635.67 374,011.18 3,188,485.00 11.73% 81,726.06 279,664.75 39,909.61 94,346.43 Performing Arts Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 6,647.85 17,975.24 91,929.00 19.55% 5,583.38 15,951.41 1,064.47 2,023.83 Benefits 1,017.05 2,869.65 13,525.00 21.22% 805.67 2,322.02 211.38 547.63 Operations 11,444.40 35,534.80 258,595.00 13.74% 17,486.99 29,591.83 (6,042.59) 5,942.97 Capital Outlay ‐ ‐ 17,500.00 ‐ ‐ ‐ Total 19,109.30 56,379.69 381,549.00 14.78% 23,876.04 47,865.26 (4,766.74) 8,514.43 Non‐Departmental Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference City ‐ County Svcs 23,333.34 114,166.68 410,000.00 27.85% 6,666.67 114,166.68 16,666.67 ‐ Community Initiatives 71,934.31 229,080.69 978,094.00 23.42% 73,698.20 169,182.04 (1,763.89) 59,898.65 Transfer to DSF ‐ One Cent 1,880,628.47 3,493,844.00 53.83%‐ 3,445,563.44 ‐ (1,564,934.97) Transfer to DSF ‐ Other 84,218.42 177,066.00 47.56%‐ 84,218.42 ‐ ‐ Transfer to Group Health 247,167.00 741,501.00 2,966,000.00 25.00% 249,375.00 748,125.00 (2,208.00) (6,624.00) Transfer to Capital Project Fund 12,026.21 42,017.58 181,869.00 23.10% 15,140.04 624,614.39 (3,113.83) (582,596.81) Transfer to Gas Tax Fund 188,150.00 0.00%‐ ‐ Transfer to Judicial ‐ ‐ 0.00%‐ ‐ ‐ Total 354,460.86 3,091,612.84 8,395,023.00 36.83% 344,879.91 5,185,869.97 9,580.95 (2,094,257.13) Debt Service Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Debt Service 36,694.16 275,952.00 1,530,500.00 18.03% 155,068.39 337,442.34 (118,374.23) (61,490.34) Total 36,694.16 275,952.00 1,530,500.00 18.03% 155,068.39 337,442.34 (118,374.23) (61,490.34) Total Dec‐18 YTD Budget % of Budget Dec‐17 YTD December Difference YTD Difference Salary 1,120,744.45 2,964,636.55 15,028,865.00 19.73% 1,086,290.03 3,215,718.71 34,454.42 (251,082.16) Benefits 433,373.25 1,265,928.54 5,997,070.00 21.11% 420,171.51 1,256,423.21 13,201.74 9,505.33 Operations 642,067.30 1,975,945.29 9,904,249.00 19.95% 641,802.08 2,531,492.68 265.22 (555,547.39) Capital Outlay ‐ ‐ 1,751,320.00 0.00%‐ ‐ ‐ ‐ Debt Service 36,694.16 2,240,798.89 5,201,410.00 43.08% 155,068.39 3,867,224.20 (118,374.23) (1,626,425.31) Total 2,232,879.16 8,447,309.27 37,882,914.00 22.30% 2,303,332.01 10,870,858.80 (70,452.85) (2,423,549.53) Prepared by Daniel Oakley