Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
May 2018 - Council Expense Information
As of 6/14/2018 66.67 % Year Complete Executive May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 20,019.08 163,598.26 322,218.00 50.77% 15,040.34 125,384.80 4,978.74 38,213.46 Benefits 2,514.19 21,042.03 44,131.00 47.68% 1,778.81 15,208.89 735.38 5,833.14 Operations 3,540.90 57,820.64 105,533.00 54.79% 1,926.29 83,394.86 1,614.61 (25,574.22) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 26,074.17 242,460.93 471,882.00 51.38% 18,745.44 223,988.55 7,328.73 18,472.38 Legislative May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 10,417.04 83,336.32 125,000.00 66.67% 10,417.04 84,342.74 ‐ (1,006.42) Benefits 807.96 6,310.32 10,415.00 60.59% 716.25 6,339.25 91.71 (28.93) Operations 526.74 6,053.19 25,800.00 23.46% 806.48 5,325.89 (279.74) 727.30 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 11,751.74 95,699.83 161,215.00 59.36% 11,939.77 96,007.88 (188.03) (308.05) Finance May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 21,937.77 192,688.96 306,088.00 62.95% 21,896.89 177,297.98 40.88 15,390.98 Benefits 3,378.47 30,119.16 49,281.00 61.12% 3,402.47 27,969.70 (24.00) 2,149.46 Operations 9,024.96 172,368.12 259,155.00 66.51% 18,189.06 174,557.05 (9,164.10) (2,188.93) Capital Outlay ‐ ‐ 25,000.00 0.00%‐ 28,466.20 ‐ (28,466.20) Total 34,341.20 395,176.24 639,524.00 61.79% 43,488.42 408,290.93 (9,147.22) (13,114.69) City Clerk May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 9,939.50 82,350.77 126,487.00 65.11% 9,660.07 80,936.29 279.43 1,414.48 Benefits 1,483.43 12,173.46 20,169.00 60.36% 1,399.68 12,232.37 83.75 (58.91) Operations 3,244.88 48,065.48 62,300.00 77.15% 1,845.64 34,351.34 1,399.24 13,714.14 Capital Outlay ‐ 365.00 ‐ 100.00%‐ ‐ ‐ 365.00 Total 14,667.81 142,954.71 208,956.00 68.41% 12,905.39 127,520.00 1,762.42 15,434.71 HR May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 21,269.46 159,269.41 274,485.00 58.02% 16,811.85 140,575.60 4,457.61 18,693.81 Benefits 3,471.82 26,415.31 44,794.00 58.97% 2,654.08 23,182.11 817.74 3,233.20 Operations 5,975.89 68,127.26 87,550.00 77.82% 5,492.42 38,978.37 483.47 29,148.89 Capital Outlay ‐ ‐ ‐ 100.00%‐ ‐ Total 30,717.17 253,811.98 406,829.00 62.39% 24,958.35 202,736.08 5,758.82 51,075.90 IT May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 12,679.00 105,489.88 162,125.00 65.07% 12,327.52 72,953.05 351.48 32,536.83 Benefits 1,799.89 15,182.21 23,874.00 63.59% 1,725.15 10,619.28 74.74 4,562.93 Operations 92,897.31 831,822.69 1,248,460.00 66.63% 85,260.07 862,064.83 7,637.24 (30,242.14) Capital Outlay ‐ 11,000.00 51,000.00 21.57%‐ 11,000.00 Total 107,376.20 963,494.78 1,485,459.00 64.86% 99,312.74 945,637.16 8,063.46 17,857.62 Vehicle Maint. May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 14,678.37 139,330.19 243,870.00 57.13% 19,159.45 131,920.00 (4,481.08) 7,410.19 Benefits 2,570.79 31,116.23 50,505.00 61.61% 2,818.32 33,199.67 (247.53) (2,083.44) Operations 2,538.15 13,026.14 104,950.00 12.41% 9,056.74 60,281.41 (6,518.59) (47,255.27) Capital Outlay ‐ ‐ 25,000.00 0.00%‐ ‐ Total 19,787.31 183,472.56 424,325.00 43.24% 31,034.51 225,401.08 (11,247.20) (41,928.52) City of Prattville May Unaudited Expenses By Department Engineering May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 36,817.96 286,347.71 471,460.00 60.74% 30,638.24 281,068.69 6,179.72 5,279.02 Benefits 6,581.20 61,813.10 93,269.00 66.27% 5,031.09 66,195.06 1,550.11 (4,381.96) Operations 44,739.43 223,032.04 622,346.00 35.84% 20,208.56 218,735.19 24,530.87 4,296.85 Captial Projects ‐ ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ ‐ 146,476.00 0.00%‐ 268,977.61 ‐ (268,977.61) Total 88,138.59 571,192.85 1,333,551.00 42.83% 55,877.89 834,976.55 32,260.70 (263,783.70) Planning May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 14,349.35 143,361.98 247,504.00 57.92% 19,690.42 168,424.45 (5,341.07) (25,062.47) Benefits 2,457.27 24,037.82 41,702.00 57.64% 3,300.30 29,085.21 (843.03) (5,047.39) Operations 34,443.08 286,333.62 503,700.00 56.85% 66,324.34 286,696.52 (31,881.26) (362.90) Captial Projects ‐ ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ 6,011.00 6,000.00 100.18%‐ 27,839.00 ‐ (21,828.00) Total 51,249.70 459,744.42 798,906.00 57.55% 89,315.06 512,045.18 (38,065.36) (52,300.76) Urban Management May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 58,110.56 424,557.53 649,770.00 65.34% 67,885.02 528,033.42 (9,774.46) (103,475.89) Benefits 8,831.51 83,417.44 123,709.00 67.43% 9,905.19 107,854.00 (1,073.68) (24,436.56) Operations 39,332.23 224,893.81 564,750.00 39.82% 49,787.74 213,789.84 (10,455.51) 11,103.97 Capital Outlay ‐ ‐ 191,500.00 0.00%‐ ‐ ‐ Total 106,274.30 732,868.78 1,529,729.00 47.91% 127,577.95 849,677.26 (21,303.65) (116,808.48) Facilities Maintenance May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 22,024.73 184,707.65 267,205.00 69.13% 14,643.40 121,869.30 7,381.33 62,838.35 Benefits 3,303.09 36,081.66 47,755.00 75.56% 2,202.22 23,840.21 1,100.87 12,241.45 Operations 18,241.29 88,556.87 137,500.00 64.40% 9,154.55 35,983.32 9,086.74 52,573.55 Capital Outlay ‐ 6,550.00 342,000.00 1.92% 21,868.00 21,868.00 (21,868.00) (15,318.00) Total 43,569.11 315,896.18 794,460.00 39.76% 47,868.17 203,560.83 (4,299.06) 112,335.35 Public Works May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 19,587.64 253,722.51 582,714.00 43.54% 14,988.17 110,866.10 4,599.47 142,856.41 Benefits 3,232.29 74,376.40 131,966.00 56.36% 2,426.78 23,734.81 805.51 50,641.59 Operations 16,219.00 90,703.75 242,668.00 37.38% 10,530.02 45,509.73 5,688.98 45,194.02 Capital Outlay ‐ 6,550.00 85,000.00 7.71% 15,150.00 23,335.00 (15,150.00) (16,785.00) Total 39,038.93 425,352.66 1,042,348.00 40.81% 43,094.97 203,445.64 (4,056.04) 221,907.02 Police May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 353,753.79 3,146,228.59 5,031,675.00 62.53% 358,115.86 3,079,698.65 (4,362.07) 66,529.94 Benefits 59,311.58 668,307.37 1,016,170.00 65.77% 56,243.15 639,574.31 3,068.43 28,733.06 Operations 83,842.61 802,682.34 1,255,431.00 63.94% 112,864.61 854,362.08 (29,022.00) (51,679.74) Capital Outlay ‐ 157,212.28 244,837.00 64.21%‐ 167,034.00 ‐ (9,821.72) Total 496,907.98 4,774,430.58 7,548,113.00 63.25% 527,223.62 4,740,669.04 (30,315.64) 33,761.54 Fire May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 350,269.78 3,017,760.39 4,590,342.00 65.74% 343,856.73 2,953,971.06 6,413.05 63,789.33 Benefits 61,378.97 657,650.65 959,212.00 68.56% 56,055.14 672,610.43 5,323.83 (14,959.78) Operations 68,768.73 687,938.71 1,163,862.00 59.11% 129,252.89 611,368.24 (60,484.16) 76,570.47 Capital Outlay ‐ 35,936.25 116,269.00 30.91%‐ 775,570.42 ‐ (739,634.17) Total 480,417.48 4,399,286.00 6,829,685.00 64.41% 529,164.76 5,013,520.15 (48,747.28) (614,234.15) Building May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 22,671.82 177,431.11 292,550.00 60.65% 22,213.60 189,226.04 458.22 (11,794.93) Benefits 3,794.69 32,367.31 54,720.00 59.15% 3,581.86 35,780.37 212.83 (3,413.06) Operations 1,745.34 32,110.49 63,450.00 50.61% 2,612.24 25,944.89 (866.90) 6,165.60 Capital Outlay ‐ ‐ ‐ 0.00%‐ 40,000.00 ‐ (40,000.00) Total 28,211.85 241,908.91 410,720.00 58.90% 28,407.70 290,951.30 (195.85) (49,042.39) Parks & Recreation May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 59,611.24 410,770.85 718,665.00 57.16% 49,562.66 397,158.82 10,048.58 13,612.03 Benefits 9,004.07 75,316.95 122,111.00 61.68% 6,842.70 78,903.46 2,161.37 (3,586.51) Operations 108,051.57 507,915.06 1,161,416.00 43.73% 103,272.14 415,375.31 4,779.43 92,539.75 Capital Outlay/ Capital Projects 58,162.22 58,162.22 440,083.00 13.22% 86,422.41 118,858.41 (28,260.19) (60,696.19) Total 234,829.10 1,052,165.08 2,442,275.00 43.08% 246,099.91 1,010,296.00 (11,270.81) 41,869.08 Performing Arts May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 6,592.09 48,566.55 77,613.00 62.58% 5,215.97 40,788.73 1,376.12 7,777.82 Benefits 962.59 7,170.71 16,411.00 43.69% 751.63 6,082.45 210.96 1,088.26 Operations 14,198.19 93,326.94 222,760.00 41.90% 12,802.58 79,319.92 1,395.61 14,007.02 Capital Outlay ‐ ‐ ‐ ‐ ‐ Total 21,752.87 149,064.20 316,784.00 47.06% 18,770.18 126,191.10 2,982.69 22,873.10 Non‐Departmental May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference City ‐ County Svcs ‐ 295,833.36 410,000.00 72.15%‐ 295,833.36 ‐ ‐ Community Initiatives 72,399.25 461,350.46 930,624.00 49.57% 75,331.53 430,764.86 (2,932.28) 30,585.60 Transfer to DSF ‐ One Cent ‐ 4,955,997.97 6,366,000.00 77.85%‐ 4,955,997.97 Transfer to DSF ‐ Other ‐ 157,990.83 164,206.00 96.22%‐ 157,990.83 Transfer to Group Health 249,375.00 1,995,000.00 2,992,500.00 66.67% 207,168.75 1,657,350.00 42,206.25 337,650.00 Transfer to Capital Project Fund 11,726.97 709,092.60 112,300.00 631.43% 9,492.98 235,433.49 2,233.99 473,659.11 Transfer to Judicial ‐ 53,093.00 0.00%‐ ‐ Total 333,501.22 8,575,265.22 11,028,723.00 77.75% 291,993.26 2,619,381.71 41,507.96 5,955,883.51 Debt Service May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Debt Service 44,862.61 876,767.02 1,441,350.00 60.83% 31,763.39 1,280,125.15 13,099.22 (403,358.13) Total 44,862.61 876,767.02 1,441,350.00 60.83% 31,763.39 1,280,125.15 13,099.22 (403,358.13) Total May‐18 YTD Budget % of Budget May‐17 YTD May Difference YTD Difference Salary 1,054,729.18 9,019,518.66 14,489,771.00 62.25% 1,032,123.23 8,684,515.72 22,605.95 335,002.94 Benefits 424,258.81 3,857,898.13 5,842,694.00 66.03% 368,003.57 3,469,761.58 56,255.24 388,136.55 Operations 631,456.52 5,701,053.57 9,337,648.00 61.05% 724,210.88 5,008,070.50 (92,754.36) 692,983.07 Capital Outlay 58,162.22 281,786.75 1,673,165.00 16.84% 123,440.41 1,471,948.64 (65,278.19) (1,190,161.89) Debt Service 44,862.61 5,990,755.82 7,971,556.00 75.15% 31,763.39 1,280,125.15 13,099.22 4,710,630.67 Total 2,213,469.34 24,851,012.93 39,314,834.00 63.21% 2,279,541.48 19,914,421.59 (66,072.14) 4,936,591.34 Prepared by Daniel Oakley