Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
February 2018 - Council Expense Information
As of 3/16/2018 41.67 % Year Complete Executive Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 19,876.58 93,594.64 322,218.00 29.05% 14,806.33 65,500.47 5,070.25 28,094.17 Benefits 2,487.84 12,179.83 44,131.00 27.60% 1,747.20 8,456.85 740.64 3,722.98 Operations 10,552.65 41,298.93 105,533.00 39.13% 4,952.86 34,420.71 5,599.79 6,878.22 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 32,917.07 147,073.40 471,882.00 31.17% 21,506.39 108,378.03 11,410.68 38,695.37 Legislative Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 10,417.04 52,085.20 125,000.00 41.67% 10,208.38 52,305.53 208.66 (220.33) Benefits 754.66 4,040.64 10,415.00 38.80% 781.89 4,055.56 (27.23) (14.92) Operations 840.00 2,525.53 25,800.00 9.79%‐ 2,256.72 840.00 268.81 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 12,011.70 58,651.37 161,215.00 36.38% 10,990.27 58,617.81 1,021.43 33.56 Finance Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 25,269.48 114,038.70 306,088.00 37.26% 21,756.67 92,344.58 3,512.81 21,694.12 Benefits 3,883.75 17,832.45 49,281.00 36.19% 3,425.61 15,393.65 458.14 2,438.80 Operations 17,317.01 100,662.14 259,155.00 38.84% 31,917.12 123,200.54 (14,600.11) (22,538.40) Capital Outlay ‐ ‐ 25,000.00 0.00% 627.20 28,466.20 (627.20) (28,466.20) Total 46,470.24 232,533.29 639,524.00 36.36% 57,726.60 259,404.97 (11,256.36) (26,871.68) City Clerk Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 9,876.43 48,836.21 126,487.00 38.61% 9,660.08 42,346.44 216.35 6,489.77 Benefits 1,452.25 7,138.04 20,169.00 35.39% 1,430.29 6,954.63 21.96 183.41 Operations 7,950.28 23,429.19 62,300.00 37.61% 4,951.38 28,313.80 2,998.90 (4,884.61) Capital Outlay 5,823.00 5,823.00 ‐ 0.00%‐ ‐ 5,823.00 5,823.00 Total 25,101.96 85,226.44 208,956.00 40.79% 16,041.75 77,614.87 9,060.21 7,611.57 HR Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 17,577.22 85,182.69 274,485.00 31.03% 16,714.96 74,688.43 862.26 10,494.26 Benefits 2,815.24 14,331.95 44,794.00 32.00% 2,699.98 13,342.03 115.26 989.92 Operations 13,121.09 33,500.39 87,550.00 38.26% 4,582.89 14,240.91 8,538.20 19,259.48 Capital Outlay 22,832.00 24,326.00 ‐ 100.00% 22,832.00 24,326.00 Total 56,345.55 157,341.03 406,829.00 38.67% 23,997.83 102,271.37 32,347.72 55,069.66 IT Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 12,560.57 61,710.10 162,125.00 38.06% 8,105.03 33,660.81 4,455.54 28,049.29 Benefits 1,765.57 8,998.51 23,874.00 37.69% 1,141.54 5,300.22 624.03 3,698.29 Operations 128,689.76 575,016.27 1,248,460.00 46.06% 90,250.24 609,258.21 38,439.52 (34,241.94) Capital Outlay ‐ ‐ 51,000.00 0.00%‐ ‐ Total 143,015.90 645,724.88 1,485,459.00 43.47% 99,496.81 648,219.24 43,519.09 (2,494.36) Vehicle Maint. Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 14,453.64 88,813.86 243,870.00 36.42% 16,816.48 75,858.95 (2,362.84) 12,954.91 Benefits 2,287.16 22,932.50 50,505.00 45.41% 2,506.09 23,227.33 (218.93) (294.83) Operations (675.04) 2,412.59 104,950.00 2.30% 7,262.38 22,968.80 (7,937.42) (20,556.21) Capital Outlay ‐ ‐ 25,000.00 0.00%‐ ‐ Total 16,065.76 114,158.95 424,325.00 26.90% 26,584.95 122,055.08 (10,519.19) (7,896.13) City of Prattville February Unaudited Expenses By Department Engineering Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 34,141.36 163,758.84 471,460.00 34.73% 45,259.71 157,702.22 (11,118.35) 6,056.62 Benefits 5,667.88 40,938.95 93,269.00 43.89% 6,384.60 47,333.07 (716.72) (6,394.12) Operations 22,088.79 122,271.62 622,346.00 19.65% 32,911.50 168,385.39 (10,822.71) (46,113.77) Captial Projects ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ ‐ 146,476.00 0.00%‐ 268,977.61 ‐ (268,977.61) Total 61,898.03 326,969.41 1,333,551.00 24.52% 84,555.81 642,398.29 (22,657.78) (315,428.88) Planning Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 16,852.88 86,684.65 247,504.00 35.02% 19,510.42 88,741.92 (2,657.54) (2,057.27) Benefits 2,741.20 14,636.10 41,702.00 35.10% 3,301.61 16,629.03 (560.41) (1,992.93) Operations 40,108.68 123,555.87 503,700.00 24.53% 12,647.83 213,619.51 27,460.85 (90,063.64) Captial Projects ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ 6,011.00 6,000.00 100.18%‐ 27,839.00 ‐ (21,828.00) Total 59,702.76 230,887.62 798,906.00 28.90% 35,459.86 346,829.46 24,242.90 (115,941.84) Urban Management Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 45,467.26 245,163.91 649,770.00 37.73% 59,982.41 276,003.80 (14,515.15) (30,839.89) Benefits 6,927.04 57,029.45 123,709.00 46.10% 9,282.76 72,328.40 (2,355.72) (15,298.95) Operations 29,009.40 129,357.42 564,750.00 22.91% 20,582.15 113,917.47 8,427.25 15,439.95 Capital Outlay ‐ ‐ 191,500.00 0.00%‐ ‐ ‐ Total 81,403.70 431,550.78 1,529,729.00 28.21% 89,847.32 462,249.67 (8,443.62) (30,698.89) Facilities Maintenance Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 23,051.19 105,616.00 267,205.00 39.53% 14,848.29 64,058.03 8,202.90 41,557.97 Benefits 3,266.19 24,588.65 47,755.00 51.49% 2,253.68 15,687.75 1,012.51 8,900.90 Operations 17,357.62 57,626.43 137,500.00 41.91% 3,371.59 18,629.68 13,986.03 38,996.75 Capital Outlay ‐ ‐ 342,000.00 0.00%‐ ‐ Total 43,675.00 187,831.08 794,460.00 23.64% 20,473.56 98,375.46 23,201.44 89,455.62 Public Works Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 30,827.63 155,354.04 582,714.00 26.66% 12,829.95 57,507.81 17,997.68 97,846.23 Benefits 4,873.98 58,804.31 131,966.00 44.56% 2,138.85 15,512.79 2,735.13 43,291.52 Operations 10,285.42 61,913.39 242,668.00 25.51% 2,683.82 26,802.23 7,601.60 35,111.16 Capital Outlay ‐ ‐ 85,000.00 0.00%‐ ‐ Total 45,987.03 276,071.74 1,042,348.00 26.49% 17,652.62 99,822.83 28,334.41 176,248.91 Police Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 360,471.87 1,896,833.86 5,031,675.00 37.70% 358,141.48 1,663,099.71 2,330.39 233,734.15 Benefits 52,953.86 469,151.92 1,016,170.00 46.17% 56,922.79 429,988.07 (3,968.93) 39,163.85 Operations 116,606.76 572,004.32 1,255,431.00 45.56% 93,240.05 627,539.82 23,366.71 (55,535.50) Capital Outlay ‐ 135,275.00 244,837.00 55.25%‐ 167,034.00 ‐ (31,759.00) Total 530,032.49 3,073,265.10 7,548,113.00 40.72% 508,304.32 2,887,661.60 21,728.17 185,603.50 Fire Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 354,215.67 1,781,117.18 4,590,342.00 38.80% 329,437.09 1,605,096.05 24,778.58 176,021.13 Benefits 57,683.42 448,544.66 959,212.00 46.76% 53,960.90 466,036.96 3,722.52 (17,492.30) Operations 119,294.71 475,961.08 1,167,011.00 40.78% 51,036.47 356,695.20 68,258.24 119,265.88 Capital Outlay ‐ ‐ 113,120.00 0.00% 9,873.71 770,293.71 (9,873.71) (770,293.71) Total 531,193.80 2,705,622.92 6,829,685.00 39.62% 444,308.17 3,198,121.92 86,885.63 (492,499.00) Building Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 19,676.80 103,987.02 292,550.00 35.55% 22,108.80 100,769.40 (2,432.00) 3,217.62 Benefits 3,179.04 20,286.45 54,720.00 37.07% 3,563.86 22,453.60 (384.82) (2,167.15) Operations 3,204.78 21,183.24 63,450.00 33.39% 4,019.67 16,027.19 (814.89) 5,156.05 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ Total 26,060.62 145,456.71 410,720.00 35.42% 29,692.33 139,250.19 (3,631.71) 6,206.52 Parks & Recreation Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 44,541.94 227,334.39 718,665.00 31.63% 60,455.89 215,256.75 (15,913.95) 12,077.64 Benefits 6,512.72 48,524.58 122,111.00 39.74% 7,575.93 54,807.22 (1,063.21) (6,282.64) Operations 43,704.80 243,734.55 1,208,999.00 20.16% 22,767.24 208,290.84 20,937.56 35,443.71 Capital Outlay/ Capital Projects ‐ ‐ 392,500.00 0.00%‐ ‐ Total 94,759.46 519,593.52 2,442,275.00 21.27% 90,799.06 478,354.81 3,960.40 41,238.71 Performing Arts Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 5,658.79 26,729.99 77,613.00 34.44% 4,962.39 21,165.78 696.40 5,564.21 Benefits 819.95 4,004.96 16,411.00 24.40% 721.89 3,387.72 98.06 617.24 Operations 3,519.11 39,046.93 222,760.00 17.53% 3,529.18 30,712.06 (10.07) 8,334.87 Capital Outlay ‐ ‐ ‐ ‐ Total 9,997.85 69,781.88 316,784.00 22.03% 9,213.46 55,265.56 784.39 14,516.32 Non‐Departmental Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference City ‐ County Svcs ‐ 198,333.35 410,000.00 48.37% 6,666.67 205,000.02 (6,666.67) (6,666.67) Community Initiatives 42,013.48 285,369.92 930,624.00 30.66% 33,255.64 275,658.02 8,757.84 9,711.90 Transfer to DSF ‐ One Cent 1,326,375.68 4,771,939.12 6,366,000.00 74.96% 1,326,375.68 4,771,939.12 Transfer to DSF ‐ Other ‐ 103,618.42 164,206.00 63.10%‐ 103,618.42 Transfer to Group Health 249,375.00 1,246,875.00 2,992,500.00 41.67% 207,168.75 1,035,843.75 42,206.25 211,031.25 Transfer to Capital Project Fund 37,811.40 676,375.22 112,300.00 602.29% 5,000.00 26,268.66 32,811.40 650,106.56 Transfer to Judicial ‐ 53,093.00 0.00%‐ ‐ Total 1,655,575.56 7,282,511.03 11,028,723.00 66.03% 252,091.06 1,542,770.45 1,403,484.50 5,739,740.58 Debt Service Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Debt Service 78,854.92 609,929.58 1,441,350.00 42.32% 895,852.06 2,345,402.19 (816,997.14) (1,735,472.61) Total 78,854.92 609,929.58 1,441,350.00 42.32% 895,852.06 2,345,402.19 (816,997.14) (1,735,472.61) Total Feb‐18 YTD Budget % of Budget Feb‐17 YTD February Difference YTD Difference Salary 1,044,936.35 5,336,841.28 14,489,771.00 36.83% 1,025,604.36 4,686,106.68 19,331.99 650,734.60 Benefits 409,446.75 2,520,838.95 5,842,694.00 43.15% 367,008.22 2,256,738.63 42,438.53 264,100.32 Operations 662,800.70 3,785,578.38 9,388,380.00 40.32% 435,628.68 3,122,205.78 227,172.02 663,372.60 Capital Outlay 28,655.00 171,435.00 1,622,433.00 10.57% 10,500.91 1,262,610.52 18,154.09 (1,091,175.52) Debt Service 1,405,230.60 5,485,487.12 7,971,556.00 68.81% 895,852.06 2,345,402.19 509,378.54 3,140,084.93 Total 3,551,069.40 17,300,180.73 39,314,834.00 44.00% 2,734,594.23 13,673,063.80 816,475.17 3,627,116.93 Prepared by Daniel Oakley