Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
October 2020 - Council Expenditure Report
As of 11/13/2020 8.33 % Year Complete Executive Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 18,526.92 18,526.92 #DIV/0! 23,878.02 23,878.02 (5,351.10) (5,351.10) Benefits 2,421.54 2,421.54 #DIV/0! 3,041.32 3,041.32 (619.78) (619.78) Operations 11,411.05 11,411.05 #DIV/0! 19,219.00 19,219.00 (7,807.95) (7,807.95) Capital Outlay ‐ ‐ #DIV/0! ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ #DIV/0!‐ ‐ Total 32,359.51 32,359.51 ‐ #DIV/0! 46,138.34 46,138.34 (13,778.83) (13,778.83) Legislative Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 11,028.69 11,028.69 #DIV/0! 10,417.04 10,417.04 611.65 611.65 Benefits 828.80 828.80 #DIV/0! 711.22 711.22 117.58 117.58 Operations 358.07 358.07 #DIV/0! 369.94 369.94 (11.87) (11.87) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ Total 12,215.56 12,215.56 ‐ #DIV/0! 11,498.20 11,498.20 717.36 717.36 Finance Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 24,232.70 24,232.70 #DIV/0! 23,702.82 23,702.82 529.88 529.88 Benefits 4,281.60 4,281.60 #DIV/0! 3,571.26 3,571.26 710.34 710.34 Operations 10,689.78 10,689.78 #DIV/0! 13,093.34 13,093.34 (2,403.56) (2,403.56) Capital Outlay ‐ 0.00% ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 39,204.08 39,204.08 ‐ #DIV/0! 40,367.42 40,367.42 (1,163.34) (1,163.34) City Clerk Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 8,901.55 8,901.55 #DIV/0! 10,569.43 10,569.43 (1,667.88) (1,667.88) Benefits 1,762.73 1,762.73 #DIV/0! 1,689.02 1,689.02 73.71 73.71 Operations 6,244.73 6,244.73 #DIV/0! 3,702.54 3,702.54 2,542.19 2,542.19 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 19.95 19.95 100.00% 19.95 19.95 Total 16,928.96 16,928.96 ‐ #DIV/0! 15,960.99 15,960.99 967.97 967.97 HR Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 23,177.10 23,177.10 #DIV/0! 23,061.84 23,061.84 115.26 115.26 Benefits 4,367.67 4,367.67 #DIV/0! 4,039.60 4,039.60 328.07 328.07 Operations 3,104.95 3,104.95 #DIV/0! 3,016.43 3,016.43 88.52 88.52 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ COVID‐19 (78.00) (78.00) 100.00% (78.00) (78.00) Total 30,571.72 30,571.72 ‐ #DIV/0! 30,117.87 30,117.87 453.85 453.85 IT Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 15,926.76 15,926.76 #DIV/0! 13,899.29 13,899.29 2,027.47 2,027.47 Benefits 2,678.31 2,678.31 #DIV/0! 2,070.98 2,070.98 607.33 607.33 Operations 57,792.75 57,792.75 #DIV/0! 70,144.93 70,144.93 (12,352.18) (12,352.18) Capital Outlay ‐ ‐ #DIV/0! ‐ ‐ ‐ ‐ COVID‐19 1,510.37 1,510.37 100.00% 1,510.37 1,510.37 Total 77,908.19 77,908.19 ‐ #DIV/0! 86,115.20 86,115.20 (8,207.01) (8,207.01) Vehicle Maint. Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 36,001.62 36,001.62 #DIV/0! 16,952.63 16,952.63 19,048.99 19,048.99 Benefits 4,217.96 4,217.96 #DIV/0! 2,788.08 2,788.08 1,429.88 1,429.88 Operations 4,307.17 4,307.17 #DIV/0! 15,963.88 15,963.88 (11,656.71) (11,656.71) Capital Outlay ‐ ‐ #DIV/0! ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 44,526.75 44,526.75 ‐ #DIV/0! 35,704.59 35,704.59 8,822.16 8,822.16 City of Prattville October 2020 Unaudited Expenditures By Department Engineering Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 39,474.29 39,474.29 #DIV/0! 36,412.17 36,412.17 3,062.12 3,062.12 Benefits 7,277.09 7,277.09 #DIV/0! 6,405.62 6,405.62 871.47 871.47 Operations 41,988.54 41,988.54 #DIV/0! 68,328.00 68,328.00 (26,339.46) (26,339.46) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 88,739.92 88,739.92 ‐ #DIV/0! 111,145.79 111,145.79 (22,405.87) (22,405.87) Planning Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 29,869.86 29,869.86 #DIV/0! 21,887.25 21,887.25 7,982.61 7,982.61 Benefits 5,516.17 5,516.17 #DIV/0! 3,917.56 3,917.56 1,598.61 1,598.61 Operations 42,031.23 42,031.23 #DIV/0! 56,827.51 56,827.51 (14,796.28) (14,796.28) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 77,417.26 77,417.26 ‐ #DIV/0! 82,632.32 82,632.32 (5,215.06) (5,215.06) Urban Management Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 75,433.99 75,433.99 #DIV/0! 60,840.87 60,840.87 14,593.12 14,593.12 Benefits 12,588.27 12,588.27 #DIV/0! 9,684.98 9,684.98 2,903.29 2,903.29 Operations 39,529.11 39,529.11 #DIV/0! 56,436.75 56,436.75 (16,907.64) (16,907.64) Capital Outlay ‐ ‐ #DIV/0! ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 127,551.37 127,551.37 ‐ #DIV/0! 126,962.60 126,962.60 588.77 588.77 Facilities Maintenance Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 27,269.72 27,269.72 #DIV/0! 27,144.68 27,144.68 125.04 125.04 Benefits 4,491.19 4,491.19 #DIV/0! 4,145.65 4,145.65 345.54 345.54 Operations 10,741.46 10,741.46 #DIV/0! 24,828.50 24,828.50 (14,087.04) (14,087.04) Capital Outlay ‐ ‐ #DIV/0! ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 42,502.37 42,502.37 ‐ #DIV/0! 56,118.83 56,118.83 (13,616.46) (13,616.46) Public Works Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 24,439.95 24,439.95 #DIV/0! 21,231.57 21,231.57 3,208.38 3,208.38 Benefits 4,421.81 4,421.81 #DIV/0! 3,650.88 3,650.88 770.93 770.93 Operations 11,555.18 11,555.18 #DIV/0! 17,221.44 17,221.44 (5,666.26) (5,666.26) Capital Outlay ‐ ‐ #DIV/0! ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 40,416.94 40,416.94 ‐ #DIV/0! 42,103.89 42,103.89 (1,686.95) (1,686.95) Police Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 368,682.88 368,682.88 #DIV/0! 394,291.34 394,291.34 (25,608.46) (25,608.46) Benefits 63,888.52 63,888.52 #DIV/0! 63,920.78 63,920.78 (32.26) (32.26) Operations 158,765.02 158,765.02 #DIV/0! 180,380.33 180,380.33 (21,615.31) (21,615.31) Capital Outlay ‐ ‐ #DIV/0! ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 591,336.42 591,336.42 ‐ #DIV/0! 638,592.45 638,592.45 (47,256.03) (47,256.03) Fire Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 367,242.00 367,242.00 #DIV/0! 394,220.49 394,220.49 (26,978.49) (26,978.49) Benefits 66,724.36 66,724.36 #DIV/0! 66,077.41 66,077.41 646.95 646.95 Operations 85,015.61 85,015.61 #DIV/0! 107,976.41 107,976.41 (22,960.80) (22,960.80) Capital Outlay ‐ ‐ #DIV/0! ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 518,981.97 518,981.97 ‐ #DIV/0! 568,274.31 568,274.31 (49,292.34) (49,292.34) Building Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 18,804.80 18,804.80 #DIV/0! 18,283.20 18,283.20 521.60 521.60 Benefits 3,454.10 3,454.10 #DIV/0! 3,185.03 3,185.03 269.07 269.07 Operations 6,035.13 6,035.13 #DIV/0! 16,713.19 16,713.19 (10,678.06) (10,678.06) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 28,294.03 28,294.03 ‐ #DIV/0! 38,181.42 38,181.42 (9,887.39) (9,887.39) Parks & Recreation Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 80,535.25 80,535.25 #DIV/0! 75,191.93 75,191.93 5,343.32 5,343.32 Benefits 12,874.83 12,874.83 #DIV/0! 11,337.92 11,337.92 1,536.91 1,536.91 Operations 106,345.72 106,345.72 #DIV/0! 133,965.01 133,965.01 (27,619.29) (27,619.29) Capital Outlay/ Capital Projects ‐ ‐ #DIV/0! ‐ ‐ ‐ ‐ COVID‐19 130.00 130.00 100.00% 130.00 130.00 Total 199,885.80 199,885.80 ‐ #DIV/0! 220,494.86 220,494.86 (20,609.06) (20,609.06) Performing Arts Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 9,155.17 9,155.17 #DIV/0! 8,402.40 8,402.40 752.77 752.77 Benefits 1,475.03 1,475.03 #DIV/0! 1,202.21 1,202.21 272.82 272.82 Operations 7,538.81 7,538.81 #DIV/0! 10,425.00 10,425.00 (2,886.19) (2,886.19) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 18,169.01 18,169.01 ‐ #DIV/0! 20,029.61 20,029.61 (1,860.60) (1,860.60) Non‐Departmental Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference City ‐ County Svcs ‐ ‐ #DIV/0! 80,000.00 80,000.00 (80,000.00) (80,000.00) Community Initiatives 9,217.38 9,217.38 #DIV/0! 55,935.19 55,935.19 (46,717.81) (46,717.81) Transfer to DSF ‐ One Cent 1,923,029.10 1,923,029.10 #DIV/0! 1,925,105.53 1,925,105.53 (2,076.43) (2,076.43) Transfer to DSF ‐ Other 132,034.25 132,034.25 #DIV/0! 225,490.92 225,490.92 (93,456.67) (93,456.67) Transfer to Group Health 252,500.00 252,500.00 #DIV/0! 249,583.33 249,583.33 2,916.67 2,916.67 Transfer to Capital Project Fund ‐ ‐ #DIV/0! 10,772.24 10,772.24 (10,772.24) (10,772.24) Transfer to Sanitation Fund ‐ ‐ #DIV/0! ‐ ‐ ‐ ‐ Transfer to Gas Tax Fund ‐ ‐ #DIV/0! ‐ ‐ ‐ ‐ Transfer to Judicial ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 2,316,780.73 2,316,780.73 ‐ #DIV/0! 2,546,887.21 2,546,887.21 (230,106.48) (230,106.48) Debt Service Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Debt Service 24,610.97 24,610.97 #DIV/0! 123,124.16 123,124.16 (98,513.19) (98,513.19) Total 24,610.97 24,610.97 ‐ #DIV/0! 123,124.16 123,124.16 (98,513.19) (98,513.19) Total Oct‐20 YTD Budget % of Budget Oct‐19 YTD October Difference YTD Difference Salary 1,178,703.25 1,178,703.25 ‐ #DIV/0! 1,180,386.97 1,180,386.97 (1,683.72) (1,683.72) Benefits 455,769.98 455,769.98 ‐ #DIV/0! 441,022.85 441,022.85 14,747.13 14,747.13 Operations 612,671.69 612,671.69 ‐ #DIV/0! 945,319.63 945,319.63 (332,647.94) (332,647.94) Capital Outlay ‐ ‐ ‐ #DIV/0! ‐ ‐ ‐ ‐ Debt Service 2,079,674.32 2,079,674.32 ‐ #DIV/0! 2,273,720.61 2,273,720.61 (194,046.29) (194,046.29) COVID‐19 1,582.32 1,582.32 ‐ 100.00% Total 4,328,401.56 4,328,401.56 ‐ #DIV/0! 4,840,450.06 4,840,450.06 (513,630.82) (513,630.82) % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures #DIV/0! Prepared by Daniel Oakley