Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
April 2018 - Council Expense Information
As of 5/11/2018 58.33 % Year Complete Executive Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 20,006.21 143,579.18 322,218.00 44.56% 15,040.34 106,722.61 4,965.87 36,856.57 Benefits 2,468.23 18,527.84 44,131.00 41.98% 1,769.02 13,290.81 699.21 5,237.03 Operations 5,548.01 54,279.74 105,533.00 51.43% 2,259.05 71,400.57 3,288.96 (17,120.83) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 28,022.45 216,386.76 471,882.00 45.86% 19,068.41 191,413.99 8,954.04 24,972.77 Legislative Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 10,417.04 72,919.28 125,000.00 58.34% 11,411.79 73,925.70 (994.75) (1,006.42) Benefits 754.66 5,502.36 10,415.00 52.83% 833.15 5,774.28 (78.49) (271.92) Operations 1,400.00 5,526.45 25,800.00 21.42% 22.70 4,139.41 1,377.30 1,387.04 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 12,571.70 83,948.09 161,215.00 52.07% 12,267.64 83,839.39 304.06 108.70 Finance Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 23,089.64 170,751.19 306,088.00 55.78% 21,875.85 151,186.37 1,213.79 19,564.82 Benefits 3,556.25 26,740.69 49,281.00 54.26% 3,420.73 24,512.56 135.52 2,228.13 Operations 33,037.09 163,343.16 259,155.00 63.03% 4,674.48 158,232.83 28,362.61 5,110.33 Capital Outlay ‐ ‐ 25,000.00 0.00%‐ 28,466.20 ‐ (28,466.20) Total 59,682.98 360,835.04 639,524.00 56.42% 29,971.06 362,397.96 29,711.92 (1,562.92) City Clerk Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 9,813.35 72,411.27 126,487.00 57.25% 9,660.07 68,407.25 153.28 4,004.02 Benefits 1,441.32 10,690.03 20,169.00 53.00% 1,414.98 10,743.96 26.34 (53.93) Operations 4,367.78 44,820.60 62,300.00 71.94% 4,955.80 35,604.02 (588.02) 9,216.58 Capital Outlay ‐ 5,823.00 ‐ 100.00%‐ ‐ ‐ 5,823.00 Total 15,622.45 133,744.90 208,956.00 64.01% 16,030.85 114,755.23 (408.40) 18,989.67 HR Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 21,308.26 137,999.95 274,485.00 50.28% 16,491.10 119,778.95 4,817.16 18,221.00 Benefits 3,456.41 22,943.49 44,794.00 51.22% 2,637.99 20,417.65 818.42 2,525.84 Operations 3,594.62 62,151.37 87,550.00 70.99% 5,530.10 20,106.95 (1,935.48) 42,044.42 Capital Outlay ‐ 24,326.00 ‐ 100.00%‐ 24,326.00 Total 28,359.29 247,420.81 406,829.00 60.82% 24,659.19 160,303.55 3,700.10 87,117.26 IT Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 12,387.77 92,810.88 162,125.00 57.25% 10,287.39 58,866.47 2,100.38 33,944.41 Benefits 1,740.64 13,382.32 23,874.00 56.05% 1,457.71 8,858.85 282.93 4,523.47 Operations 63,452.52 738,925.38 1,248,460.00 59.19% 85,767.64 778,615.97 (22,315.12) (39,690.59) Capital Outlay ‐ 11,000.00 51,000.00 21.57%‐ 11,000.00 Total 77,580.93 856,118.58 1,485,459.00 57.63% 97,512.74 846,341.29 (19,931.81) 9,777.29 Vehicle Maint. Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 14,327.45 124,651.82 243,870.00 51.11% 18,675.97 124,015.95 (4,348.52) 635.87 Benefits 2,177.37 28,545.44 50,505.00 56.52% 2,761.78 34,463.26 (584.41) (5,917.82) Operations (1,038.08) 10,487.99 104,950.00 9.99% (524.08) 32,210.44 (514.00) (21,722.45) Capital Outlay ‐ ‐ 25,000.00 0.00%‐ ‐ Total 15,466.74 163,685.25 424,325.00 38.58% 20,913.67 190,689.65 (5,446.93) (27,004.40) City of Prattville April Unaudited Expenses By Department Engineering Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 34,211.21 249,529.75 471,460.00 52.93% 30,760.05 242,224.66 3,451.16 7,305.09 Benefits 5,666.18 55,231.90 93,269.00 59.22% 5,077.51 68,048.95 588.67 (12,817.05) Operations 14,509.97 178,292.61 622,346.00 28.65% 12,783.64 144,641.86 1,726.33 33,650.75 Captial Projects ‐ ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ ‐ 146,476.00 0.00%‐ 237,520.76 ‐ (237,520.76) Total 54,387.36 483,054.26 1,333,551.00 36.22% 48,621.20 692,436.23 5,766.16 (209,381.97) Planning Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 16,801.28 129,012.63 247,504.00 52.13% 20,176.26 143,608.53 (3,374.98) (14,595.90) Benefits 2,756.18 21,580.55 41,702.00 51.75% 3,399.93 25,663.98 (643.75) (4,083.43) Operations 32,885.82 251,890.54 503,700.00 50.01% 6,314.18 286,710.95 26,571.64 (34,820.41) Captial Projects ‐ ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ 6,011.00 6,000.00 100.18%‐ 27,839.00 ‐ (21,828.00) Total 52,443.28 408,494.72 798,906.00 51.13% 29,890.37 483,822.46 22,552.91 (75,327.74) Urban Management Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 55,811.11 366,446.97 649,770.00 56.40% 60,234.43 443,094.20 (4,423.32) (76,647.23) Benefits 7,590.00 74,585.93 123,709.00 60.29% 9,250.37 107,122.66 (1,660.37) (32,536.73) Operations 22,882.61 185,561.58 564,750.00 32.86% 26,199.33 153,466.83 (3,316.72) 32,094.75 Capital Outlay ‐ ‐ 191,500.00 0.00%‐ ‐ ‐ Total 86,283.72 626,594.48 1,529,729.00 40.96% 95,684.13 703,683.69 (9,400.41) (77,089.21) Facilities Maintenance Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 22,089.51 162,682.92 267,205.00 60.88% 14,527.62 103,859.74 7,561.89 58,823.18 Benefits 3,175.47 32,778.57 47,755.00 68.64% 2,130.43 23,363.88 1,045.04 9,414.69 Operations 4,821.39 70,315.58 137,500.00 51.14% 3,812.34 26,922.41 1,009.05 43,393.17 Capital Outlay ‐ 6,550.00 342,000.00 1.92%‐ ‐ 6,550.00 Total 30,086.37 272,327.07 794,460.00 34.28% 20,470.39 154,146.03 9,615.98 118,181.04 Public Works Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 28,226.06 234,134.87 582,714.00 40.18% 12,832.57 92,725.76 15,393.49 141,409.11 Benefits 4,359.29 71,144.11 131,966.00 53.91% 2,127.41 21,622.26 2,231.88 49,521.85 Operations 5,981.88 74,484.75 242,668.00 30.69% 2,932.63 35,154.61 3,049.25 39,330.14 Capital Outlay ‐ 6,550.00 85,000.00 7.71% 8,185.00 8,185.00 (8,185.00) (1,635.00) Total 38,567.23 386,313.73 1,042,348.00 37.06% 26,077.61 157,687.63 12,489.62 228,626.10 Police Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 352,870.36 2,792,474.80 5,031,675.00 55.50% 352,490.31 2,648,344.01 380.05 144,130.79 Benefits 54,740.79 608,995.79 1,016,170.00 59.93% 55,689.63 634,791.08 (948.84) (25,795.29) Operations 68,558.36 718,839.73 1,255,431.00 57.26% 78,573.66 770,931.61 (10,015.30) (52,091.88) Capital Outlay ‐ 157,212.28 244,837.00 64.21%‐ 166,864.00 ‐ (9,651.72) Total 476,169.51 4,277,522.60 7,548,113.00 56.67% 486,753.60 4,220,930.70 (10,584.09) 56,591.90 Fire Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 353,103.04 2,667,490.61 4,590,342.00 58.11% 341,717.46 2,538,184.56 11,385.58 129,306.05 Benefits 57,519.28 596,271.68 959,212.00 62.16% 55,684.46 686,294.08 1,834.82 (90,022.40) Operations 47,802.30 619,169.98 1,163,862.00 53.20% 64,864.40 493,966.72 (17,062.10) 125,203.26 Capital Outlay 35,936.25 35,936.25 116,269.00 30.91% 5,276.71 719,416.57 30,659.54 (683,480.32) Total 494,360.87 3,918,868.52 6,829,685.00 57.38% 467,543.03 4,437,861.93 26,817.84 (518,993.41) Building Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 21,216.09 154,759.29 292,550.00 52.90% 22,163.20 161,567.72 (947.11) (6,808.43) Benefits 3,440.77 28,572.62 54,720.00 52.22% 3,573.20 33,783.62 (132.43) (5,211.00) Operations 6,447.16 30,365.15 63,450.00 47.86% 5,641.30 23,030.34 805.86 7,334.81 Capital Outlay ‐ ‐ ‐ 0.00% 40,000.00 40,000.00 (40,000.00) (40,000.00) Total 31,104.02 213,697.06 410,720.00 52.03% 71,377.70 258,381.68 (40,273.68) (44,684.62) Parks & Recreation Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 53,017.45 351,159.61 718,665.00 48.86% 45,150.89 336,022.85 7,866.56 15,136.76 Benefits 7,644.44 66,312.88 122,111.00 54.31% 6,379.22 79,258.08 1,265.22 (12,945.20) Operations 60,067.09 399,863.49 1,161,416.00 34.43% 26,581.10 322,860.56 33,485.99 77,002.93 Capital Outlay/ Capital Projects ‐ ‐ 440,083.00 0.00%‐ 32,436.00 ‐ (32,436.00) Total 120,728.98 817,335.98 2,442,275.00 33.47% 78,111.21 770,577.49 42,617.77 46,758.49 Performing Arts Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 6,692.69 41,974.46 77,613.00 54.08% 5,050.60 34,526.33 1,642.09 7,448.13 Benefits 969.15 6,208.12 16,411.00 37.83% 731.20 5,294.66 237.95 913.46 Operations 21,505.28 79,128.75 222,760.00 35.52% 21,058.57 60,131.80 446.71 18,996.95 Capital Outlay ‐ ‐ ‐ ‐ ‐ Total 29,167.12 127,311.33 316,784.00 40.19% 26,840.37 99,952.79 2,326.75 27,358.54 Non‐Departmental Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference City ‐ County Svcs 84,166.67 295,833.36 410,000.00 72.15% 84,166.67 295,833.36 ‐ ‐ Community Initiatives 53,425.43 388,951.21 930,624.00 41.79% 35,938.91 398,733.76 17,486.52 (9,782.55) Transfer to DSF ‐ One Cent 184,058.85 4,955,997.97 6,366,000.00 77.85% 184,058.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,745,625.00 2,992,500.00 58.33% 207,168.75 1,450,181.25 42,206.25 295,443.75 Transfer to Capital Project Fund 10,414.00 697,365.63 112,300.00 620.98% 190,031.51 225,940.51 (179,617.51) 471,425.12 Transfer to Judicial ‐ 53,093.00 0.00%‐ ‐ Total 581,439.95 8,241,764.00 11,028,723.00 74.73% 517,305.84 2,370,688.88 64,134.11 5,871,075.12 Debt Service Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Debt Service 116,170.11 831,904.41 1,441,350.00 57.72% 210,493.99 2,555,896.18 (94,323.88) (1,723,991.77) Total 116,170.11 831,904.41 1,441,350.00 57.72% 210,493.99 2,555,896.18 (94,323.88) (1,723,991.77) Total Apr‐18 YTD Budget % of Budget Apr‐17 YTD April Difference YTD Difference Salary 1,055,388.52 7,964,789.48 14,489,771.00 54.97% 1,008,545.90 7,447,061.66 46,842.62 517,727.82 Benefits 412,831.43 3,433,639.32 5,842,694.00 58.77% 365,507.47 3,253,485.87 47,323.96 180,153.45 Operations 543,829.90 5,069,597.05 9,337,648.00 54.29% 661,583.93 4,338,635.51 (117,754.03) 730,961.54 Capital Outlay 35,936.25 253,408.53 1,673,165.00 15.15% 53,461.71 1,260,727.53 (17,525.46) (1,007,319.00) Debt Service 300,228.96 5,945,893.21 7,971,556.00 74.59% 210,493.99 2,555,896.18 89,734.97 3,389,997.03 Total 2,348,215.06 22,667,327.59 39,314,834.00 57.66% 2,299,593.00 18,855,806.75 48,622.06 3,811,520.84 Prepared by Daniel Oakley