Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
November 2020 - Council Expenditure Report
As of 12/15/2020 16.67 % Year Complete Executive Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 20,163.95 38,690.87 454,953.00 8.50% 21,300.16 45,178.18 (1,136.21) (6,487.31) Benefits 2,770.00 5,191.54 69,484.00 7.47% 2,700.00 5,741.32 70.00 (549.78) Operations 8,921.61 20,561.33 266,400.00 7.72% 3,221.90 22,440.90 5,699.71 (1,879.57) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ Total 31,855.56 64,443.74 790,837.00 8.15% 27,222.06 73,360.40 4,633.50 (8,916.66) Legislative Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 10,417.04 21,445.73 125,000.00 17.16% 10,417.04 20,834.08 ‐ 611.65 Benefits 782.00 1,610.80 10,306.00 15.63% 797.58 1,508.80 (15.58) 102.00 Operations 19.95 396.02 20,900.00 1.89% 913.44 1,283.38 (893.49) (887.36) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ Total 11,218.99 23,452.55 156,206.00 15.01% 12,128.06 23,626.26 (909.07) (173.71) Finance Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 24,314.12 48,546.82 403,498.00 12.03% 24,789.56 48,492.38 (475.44) 54.44 Benefits 4,256.95 8,538.55 72,462.00 11.78% 4,029.56 7,600.82 227.39 937.73 Operations 9,315.06 20,285.32 237,750.00 8.53% 10,952.28 24,045.62 (1,637.22) (3,760.30) Capital Outlay ‐ 0.00% ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 37,886.13 77,370.69 713,710.00 10.84% 39,771.40 80,138.82 (1,885.27) (2,768.13) City Clerk Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 29,681.60 38,583.15 144,744.00 26.66% 10,810.91 21,380.34 18,870.69 17,202.81 Benefits 3,056.91 4,819.64 25,190.00 19.13% 1,852.03 3,541.05 1,204.88 1,278.59 Operations 1,341.17 7,835.67 51,670.00 15.16% 590.41 4,292.95 750.76 3,542.72 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 19.95 100.00% ‐ 19.95 Total 34,079.68 51,258.41 221,604.00 23.13% 13,253.35 29,214.34 20,826.33 22,044.07 HR Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 23,151.29 46,328.39 316,371.00 14.64% 24,151.97 47,213.81 (1,000.68) (885.42) Benefits 4,220.01 8,587.68 459,716.00 1.87% 4,396.07 8,435.67 (176.06) 152.01 Operations 1,411.72 5,805.66 91,025.00 6.38% 5,350.16 8,366.59 (3,938.44) (2,560.93) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ COVID‐19 419.99 431.94 100.00% 419.99 431.94 Total 29,203.01 61,153.67 867,112.00 7.05% 33,898.20 64,016.07 (4,695.19) (2,862.40) IT Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 15,929.80 31,856.56 204,469.00 15.58% 14,649.96 28,549.25 1,279.84 3,307.31 Benefits 2,664.64 5,342.95 35,188.00 15.18% 2,216.03 4,287.01 448.61 1,055.94 Operations 122,183.85 195,538.92 1,775,647.00 11.01% 167,010.26 237,155.19 (44,826.41) (41,616.27) Capital Outlay ‐ ‐ 75,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 33,124.52 41,771.92 100.00% 33,124.52 41,771.92 Total 173,902.81 274,510.35 2,090,304.00 13.13% 183,876.25 269,991.45 (9,973.44) 4,518.90 Vehicle Maint. Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 12,672.30 48,673.92 227,010.00 21.44% 17,360.73 34,313.36 (4,688.43) 14,360.56 Benefits 2,168.03 6,385.99 47,083.00 13.56% 2,919.15 5,707.23 (751.12) 678.76 Operations 4,860.49 10,081.09 98,150.00 10.27% 7,435.31 23,399.19 (2,574.82) (13,318.10) Capital Outlay ‐ ‐ 7,500.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 19,700.82 65,141.00 379,743.00 17.15% 27,715.19 63,419.78 (8,014.37) 1,721.22 City of Prattville November 2020 Unaudited Expenditures By Department Engineering Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 40,169.84 79,644.13 541,734.00 14.70% 38,301.56 74,713.73 1,868.28 4,930.40 Benefits 7,247.47 14,524.56 113,070.00 12.85% 6,566.36 12,971.98 681.11 1,552.58 Operations 18,452.10 66,984.70 793,700.00 8.44% 20,494.44 88,822.44 (2,042.34) (21,837.74) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 65,869.41 161,153.39 1,448,504.00 11.13% 65,362.36 176,508.15 507.05 (15,354.76) Planning Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 29,829.03 59,698.89 404,595.00 14.76% 24,150.74 46,037.99 5,678.29 13,660.90 Benefits 5,471.01 10,987.18 76,496.00 14.36% 4,337.95 8,255.51 1,133.06 2,731.67 Operations 32,582.48 76,886.48 540,450.00 14.23% 41,145.40 97,972.91 (8,562.92) (21,086.43) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 67,882.52 147,572.55 1,021,541.00 14.45% 69,634.09 152,266.41 (1,751.57) (4,693.86) Urban Management Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 76,555.42 151,989.41 990,654.00 15.34% 67,398.02 128,238.89 9,157.40 23,750.52 Benefits 12,826.69 25,414.96 193,188.00 13.16% 10,924.77 20,609.75 1,901.92 4,805.21 Operations 50,398.14 100,323.98 528,000.00 19.00% 53,508.64 109,945.39 (3,110.50) (9,621.41) Capital Outlay ‐ ‐ 81,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 139,780.25 277,728.35 1,792,842.00 15.49% 131,831.43 258,794.03 7,948.82 18,934.32 Facilities Maintenance Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 27,415.25 54,684.97 380,874.00 14.36% 27,657.34 54,802.02 (242.09) (117.05) Benefits 4,475.52 8,966.71 67,073.00 13.37% 4,278.31 8,423.96 197.21 542.75 Operations 23,236.70 33,978.16 222,550.00 15.27% 5,820.89 30,649.39 17,415.81 3,328.77 Capital Outlay ‐ ‐ 375,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 55,127.47 97,629.84 1,045,497.00 9.34% 37,756.54 93,875.37 17,370.93 3,754.47 Public Works Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 25,303.32 49,743.27 332,353.00 14.97% 23,961.84 45,193.41 1,341.48 4,549.86 Benefits 4,538.01 8,959.82 64,481.00 13.90% 4,187.23 7,838.11 350.78 1,121.71 Operations 38,141.91 52,334.09 212,718.00 24.60% 22,148.31 39,369.75 15,993.60 12,964.34 Capital Outlay ‐ ‐ 520,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 67,983.24 111,037.18 1,129,552.00 9.83% 50,297.38 92,401.27 17,685.86 18,635.91 Police Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 380,519.36 749,202.24 5,753,608.00 13.02% 413,289.87 807,581.21 (32,770.51) (58,378.97) Benefits 65,849.53 129,738.05 1,114,150.00 11.64% 68,956.36 132,877.14 (3,106.83) (3,139.09) Operations 26,057.43 193,569.10 1,324,221.00 14.62% 100,440.38 280,820.71 (74,382.95) (87,251.61) Capital Outlay ‐ ‐ 6,229.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 4,247.99 4,423.74 100.00% 4,247.99 4,423.74 Total 476,674.31 1,076,933.13 8,198,208.00 13.14% 582,686.61 1,221,279.06 (106,012.30) (144,345.93) Fire Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 388,752.97 755,994.97 5,114,439.00 14.78% 396,056.81 790,277.30 (7,303.84) (34,282.33) Benefits 69,799.58 136,523.94 1,059,303.00 12.89% 69,941.13 136,018.54 (141.55) 505.40 Operations 75,848.29 164,538.10 1,097,908.00 14.99% 53,342.05 161,318.46 22,506.24 3,219.64 Capital Outlay ‐ 80,700.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 4,044.46 5,694.46 100.00% 4,044.46 5,694.46 Total 538,445.30 1,062,751.47 7,352,350.00 14.45% 519,339.99 1,087,614.30 19,105.31 (24,862.83) Building Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 19,131.60 19,131.60 254,406.00 7.52% 19,049.91 37,333.11 81.69 (18,201.51) Benefits 3,433.31 3,433.31 51,631.00 6.65% 3,386.86 6,571.89 46.45 (3,138.58) Operations 1,002.56 1,002.56 67,450.00 1.49% 2,347.52 19,060.71 (1,344.96) (18,058.15) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 23,567.47 23,567.47 373,487.00 6.31% 24,784.29 62,965.71 (1,216.82) (39,398.24) Parks & Recreation Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 79,581.19 79,581.19 1,058,409.00 7.52% 75,054.50 150,246.43 4,526.69 (70,665.24) Benefits 12,609.31 12,609.31 192,383.00 6.55% 11,939.35 23,277.27 669.96 (10,667.96) Operations 91,585.04 91,585.04 1,316,238.00 6.96% 80,224.87 214,189.88 11,360.17 (122,604.84) Capital Outlay/ Capital Projects ‐ ‐ 295,400.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 183,775.54 183,775.54 2,862,430.00 6.42% 167,218.72 387,713.58 16,556.82 (203,938.04) Performing Arts Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 8,896.75 8,896.75 111,783.00 7.96% 8,579.27 16,981.67 317.48 (8,084.92) Benefits 1,383.82 1,383.82 18,332.00 7.55% 1,302.54 2,504.75 81.28 (1,120.93) Operations 6,445.93 6,445.93 255,640.00 2.52% 13,486.18 23,911.18 (7,040.25) (17,465.25) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 16,726.50 16,726.50 385,755.00 4.34% 23,367.99 43,397.60 (6,641.49) (26,671.10) Non‐Departmental Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference City ‐ County Svcs ‐ ‐ 430,000.00 0.00% 21,250.02 101,250.02 (21,250.02) (101,250.02) Community Initiatives 6,792.00 16,009.38 928,801.00 1.72% 120,843.53 176,778.72 (114,051.53) (160,769.34) Unprocessed JP Morgan Payment ‐ ‐ 100.00% ‐ ‐ ‐ ‐ Drug Proceeds Expenditures ‐ 198.00 ‐ 100.00% ‐ ‐ ‐ 198.00 Transfer to DSF ‐ One Cent ‐ 1,623,029.10 8,785,000.00 18.48% ‐ 1,925,105.53 ‐ (302,076.43) Transfer to DSF ‐ Other 84,218.42 216,252.67 558,667.00 38.71% ‐ 225,490.92 84,218.42 (9,238.25) Transfer to Group Health 252,500.00 505,000.00 3,030,000.00 16.67% 249,583.33 499,166.66 2,916.67 5,833.34 Transfer to Capital Project Fund ‐ ‐ 0.00% ‐ 10,772.24 ‐ (10,772.24) Transfer to Sanitation Fund ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Transfer to Gas Tax Fund ‐ ‐ 42,723.00 0.00% ‐ ‐ ‐ ‐ Transfer to Judicial ‐ ‐ 222,614.00 0.00% ‐ ‐ ‐ ‐ Total 343,510.42 2,360,489.15 13,997,805.00 16.86% 391,676.88 2,938,564.09 (48,166.46) (578,074.94) Debt Service Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Debt Service 130,933.52 155,544.49 1,745,500.00 8.91% 132,750.59 255,874.75 (1,817.07) (100,330.26) Total 130,933.52 155,544.49 1,745,500.00 8.91% 132,750.59 255,874.75 (1,817.07) (100,330.26) Total Nov‐20 YTD Budget % of Budget Nov‐19 YTD November Difference YTD Difference Salary 1,212,484.83 2,282,692.86 16,818,900.00 13.57% 1,216,980.19 2,397,367.16 (4,495.36) (114,674.30) Benefits 460,052.79 898,018.81 6,699,536.00 13.40% 454,314.61 895,337.46 5,738.18 2,681.35 Operations 518,596.43 1,064,359.53 10,524,555.00 10.11% 730,525.99 1,675,845.62 (211,929.56) (611,486.09) Capital Outlay ‐ ‐ 1,440,829.00 0.00% ‐ ‐ ‐ ‐ Debt Service 215,151.94 1,994,826.26 11,089,167.00 17.99% 132,750.59 2,406,471.20 82,401.35 (411,644.94) COVID‐19 41,836.96 52,342.01 ‐ 100.00% Total 2,448,122.95 6,292,239.47 46,572,987.00 13.51% 2,534,571.38 7,375,021.44 (128,285.39) (1,135,123.98) % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 13.40% Prepared by Daniel Oakley