Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
January 2018 - Council Expense Information
As of 2/15/2018 33.33 % Year Complete Executive Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 19,873.46 73,718.06 322,218.00 22.88% 14,484.04 50,694.14 5,389.42 23,023.92 Benefits 3,101.32 9,691.99 44,131.00 21.96% 1,998.38 6,709.65 1,102.94 2,982.34 Operations 1,868.85 30,746.28 105,533.00 29.13% 2,894.17 29,443.85 (1,025.32) 1,302.43 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 24,843.63 114,156.33 471,882.00 24.19% 19,376.59 86,847.64 5,467.04 27,308.69 Legislative Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 10,417.04 41,668.16 125,000.00 33.33% 10,208.38 42,097.15 208.66 (428.99) Benefits 994.43 3,285.98 10,415.00 31.55% 962.88 3,273.67 31.55 12.31 Operations 30.09 1,685.53 25,800.00 6.53% (60.04) 2,256.72 90.13 (571.19) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 11,441.56 46,639.67 161,215.00 28.93% 11,111.22 47,627.54 330.34 (987.87) Finance Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 22,339.04 88,769.22 306,088.00 29.00% 21,808.04 70,587.91 531.00 18,181.31 Benefits 3,463.28 13,948.70 49,281.00 28.30% 3,812.79 11,968.04 (349.51) 1,980.66 Operations 11,688.48 83,345.13 259,155.00 32.16% 10,396.94 91,283.42 1,291.54 (7,938.29) Capital Outlay ‐ ‐ 25,000.00 0.00% 27,839.00 27,839.00 (27,839.00) (27,839.00) Total 37,490.80 186,063.05 639,524.00 29.09% 63,856.77 201,678.37 (26,365.97) (15,615.32) City Clerk Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 9,813.35 38,959.78 126,487.00 30.80% 9,668.33 32,686.36 145.02 6,273.42 Benefits 1,299.80 5,685.79 20,169.00 28.19% 1,628.69 5,524.34 (328.89) 161.45 Operations 2,101.80 15,478.91 62,300.00 24.85% 741.48 23,362.42 1,360.32 (7,883.51) Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 13,214.95 60,124.48 208,956.00 28.77% 12,038.50 61,573.12 1,176.45 (1,448.64) HR Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 17,312.03 67,605.47 274,485.00 24.63% 16,886.44 57,973.47 425.59 9,632.00 Benefits 3,284.61 11,516.71 44,794.00 25.71% 3,117.65 10,642.05 166.96 874.66 Operations 2,488.39 20,379.30 87,550.00 23.28% 732.44 9,658.02 1,755.95 10,721.28 Capital Outlay 1,494.00 1,494.00 ‐ 100.00% 1,494.00 1,494.00 Total 24,579.03 100,995.48 406,829.00 24.83% 20,736.53 78,273.54 3,842.50 22,721.94 IT Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 12,455.25 49,149.53 162,125.00 30.32% 7,313.20 25,555.78 5,142.05 23,593.75 Benefits 2,055.06 7,232.94 23,874.00 30.30% 1,345.46 4,158.68 709.60 3,074.26 Operations 53,197.79 446,326.51 1,248,460.00 35.75% 107,069.37 519,007.97 (53,871.58) (72,681.46) Capital Outlay ‐ ‐ 51,000.00 0.00%‐ ‐ Total 67,708.10 502,708.98 1,485,459.00 33.84% 115,728.03 548,722.43 (48,019.93) (46,013.45) Vehicle Maint. Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 18,671.20 74,360.22 243,870.00 30.49% 16,539.49 59,042.47 2,131.71 15,317.75 Benefits 12,227.54 20,645.34 50,505.00 40.88% 13,656.60 20,721.24 (1,429.06) (75.90) Operations 1,762.55 3,087.63 104,950.00 2.94% (6,237.12) 15,706.42 7,999.67 (12,618.79) Capital Outlay ‐ ‐ 25,000.00 0.00%‐ ‐ Total 32,661.29 98,093.19 424,325.00 23.12% 23,958.97 95,470.13 8,702.32 2,623.06 City of Prattville January Unaudited Expenses By Department Engineering Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 33,915.00 129,617.48 471,460.00 27.49% 32,313.19 112,442.51 1,601.81 17,174.97 Benefits 19,224.22 35,271.07 93,269.00 37.82% 25,841.79 40,948.47 (6,617.57) (5,677.40) Operations 14,369.59 100,182.83 622,346.00 16.10% 41,698.55 135,473.89 (27,328.96) (35,291.06) Captial Projects ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ ‐ 146,476.00 0.00%‐ ‐ Total 67,508.81 265,071.38 1,333,551.00 19.88% 99,853.53 288,864.87 (32,344.72) (23,793.49) Planning Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 16,881.41 69,831.77 247,504.00 28.21% 19,552.63 69,231.50 (2,671.22) 600.27 Benefits 3,158.47 11,894.90 41,702.00 28.52% 3,898.06 13,327.42 (739.59) (1,432.52) Operations 45,741.38 83,447.19 503,700.00 16.57% 41,494.30 193,858.18 4,247.08 (110,410.99) Captial Projects ‐ ‐ 0.00%‐ ‐ Capital Outlay 6,011.00 6,011.00 6,000.00 100.18% 27,839.00 27,839.00 (21,828.00) (21,828.00) Total 71,792.26 171,184.86 798,906.00 21.43% 92,783.99 304,256.10 (20,991.73) (133,071.24) Urban Management Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 46,867.79 199,696.65 649,770.00 30.73% 59,992.58 216,021.39 (13,124.79) (16,324.74) Benefits 27,201.52 50,102.41 123,709.00 40.50% 36,351.49 63,045.64 (9,149.97) (12,943.23) Operations 21,224.46 100,348.02 564,750.00 17.77% 11,243.22 93,335.32 9,981.24 7,012.70 Capital Outlay ‐ ‐ 191,500.00 0.00%‐ ‐ Total 95,293.77 350,147.08 1,529,729.00 22.89% 107,587.29 372,402.35 (12,293.52) (22,255.27) Facilities Maintenance Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 20,976.28 82,564.81 267,205.00 30.90% 14,448.38 49,209.74 6,527.90 33,355.07 Benefits 12,149.08 21,322.46 47,755.00 44.65% 7,678.51 13,434.07 4,470.57 7,888.39 Operations 24,304.42 40,268.81 137,500.00 29.29% 1,503.02 15,258.09 22,801.40 25,010.72 Capital Outlay ‐ ‐ 342,000.00 0.00%‐ ‐ Total 57,429.78 144,156.08 794,460.00 18.15% 23,629.91 77,901.90 33,799.87 66,254.18 Public Works Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 32,592.43 124,526.41 582,714.00 21.37% 12,759.48 44,677.86 19,832.95 79,848.55 Benefits 39,625.64 53,930.33 131,966.00 40.87% 7,442.32 13,373.94 32,183.32 40,556.39 Operations 6,745.01 51,627.97 242,668.00 21.28% 2,060.40 24,118.41 4,684.61 27,509.56 Capital Outlay ‐ ‐ 85,000.00 0.00%‐ ‐ Total 78,963.08 230,084.71 1,042,348.00 22.07% 22,262.20 82,170.21 56,700.88 147,914.50 Police Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 371,285.39 1,536,361.99 5,031,675.00 30.53% 365,922.30 1,304,958.23 5,363.09 231,403.76 Benefits 231,036.15 416,198.06 1,016,170.00 40.96% 208,808.96 373,065.28 22,227.19 43,132.78 Operations 75,250.81 455,397.56 1,257,005.00 36.23% 160,661.44 528,575.77 (85,410.63) (73,178.21) Capital Outlay 135,275.00 135,275.00 227,638.00 59.43%‐ 167,034.00 135,275.00 (31,759.00) Total 812,847.35 2,543,232.61 7,532,488.00 33.76% 735,392.70 2,373,633.28 77,454.65 169,599.33 Fire Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 373,126.35 1,426,901.51 4,590,342.00 31.08% 362,726.42 1,275,658.96 10,399.93 151,242.55 Benefits 217,524.70 390,861.24 959,212.00 40.75% 248,388.79 412,076.06 (30,864.09) (21,214.82) Operations 71,914.33 356,666.37 1,167,011.00 30.56% 53,720.27 305,417.23 18,194.06 51,249.14 Capital Outlay ‐ ‐ 113,120.00 0.00% 33,515.00 760,420.00 (33,515.00) (760,420.00) Total 662,565.38 2,174,429.12 6,829,685.00 31.84% 698,350.48 2,753,572.25 (35,785.10) (579,143.13) Building Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 19,676.80 84,310.22 292,550.00 28.82% 22,108.80 78,660.60 (2,432.00) 5,649.62 Benefits 6,550.25 17,107.41 54,720.00 31.26% 8,640.65 18,889.74 (2,090.40) (1,782.33) Operations 1,899.79 17,978.46 63,450.00 28.33% 838.37 12,007.52 1,061.42 5,970.94 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ Total 28,126.84 119,396.09 410,720.00 29.07% 31,587.82 109,557.86 (3,460.98) 9,838.23 Parks & Recreation Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 44,863.61 182,792.45 718,665.00 25.44% 42,207.62 154,800.86 2,655.99 27,991.59 Benefits 21,834.93 42,011.86 122,111.00 34.40% 29,190.97 47,231.29 (7,356.04) (5,219.43) Operations 78,470.77 200,029.75 1,208,999.00 16.55% 43,551.51 185,523.60 34,919.26 14,506.15 Capital Outlay/ Capital Projects ‐ ‐ 392,500.00 0.00%‐ ‐ Total 145,169.31 424,834.06 2,442,275.00 17.40% 114,950.10 387,555.75 30,219.21 37,278.31 Performing Arts Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 5,119.79 21,071.20 77,613.00 27.15% 4,778.64 16,203.39 341.15 4,867.81 Benefits 862.99 3,185.01 16,411.00 19.41% 898.69 2,665.83 (35.70) 519.18 Operations 5,935.99 35,527.82 222,760.00 15.95% 3,274.60 27,182.88 2,661.39 8,344.94 Capital Outlay ‐ ‐ ‐ ‐ Total 11,918.77 59,784.03 316,784.00 18.87% 8,951.93 46,052.10 2,966.84 13,731.93 Non‐Departmental Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference City ‐ County Svcs 84,166.67 198,333.35 410,000.00 48.37% 84,166.67 198,333.35 ‐ ‐ Community Initiatives 74,174.40 243,356.44 930,624.00 26.15% 41,595.29 242,402.38 32,579.11 954.06 Transfer to DSF ‐ One Cent ‐ 3,445,563.44 6,366,000.00 54.12%‐ 3,445,563.44 Transfer to DSF ‐ Other 19,400.00 103,618.42 164,206.00 63.10% 19,400.00 103,618.42 Transfer to Group Health 249,375.00 997,500.00 2,992,500.00 33.33% 207,168.75 828,675.00 42,206.25 168,825.00 Transfer to Capital Project Fund 13,949.43 638,563.82 112,300.00 568.62% 21,268.66 21,268.66 (7,319.23) 617,295.16 Transfer to Judicial ‐ 53,093.00 0.00%‐ ‐ Total 441,065.50 5,626,935.47 11,028,723.00 51.02% 354,199.37 1,290,679.39 86,866.13 4,336,256.08 Debt Service Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Debt Service 193,632.32 531,074.66 1,441,350.00 36.85%‐ 1,449,550.13 193,632.32 (918,475.47) Total 193,632.32 531,074.66 1,441,350.00 36.85%‐ 1,449,550.13 193,632.32 (918,475.47) Total Jan‐18 YTD Budget % of Budget Jan‐17 YTD January Difference YTD Difference Salary 1,076,186.22 4,291,904.93 14,489,771.00 29.62% 1,033,717.96 3,660,502.32 42,468.26 631,402.61 Benefits 854,968.99 2,111,392.20 5,842,694.00 36.14% 810,831.43 1,889,730.41 44,137.56 221,661.79 Operations 591,285.00 3,122,777.68 9,389,954.00 33.26% 622,613.54 2,673,474.10 (31,328.54) 449,303.58 Capital Outlay 142,780.00 142,780.00 1,605,234.00 8.89% 89,193.00 983,132.00 53,587.00 (840,352.00) Debt Service 213,032.32 4,080,256.52 7,971,556.00 51.19%‐ 1,449,550.13 213,032.32 2,630,706.39 Total 2,878,252.53 13,749,111.33 39,299,209.00 34.99% 2,556,355.93 10,656,388.96 321,896.60 3,092,722.37 Prepared by Daniel Oakley