Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
November 2021 - Council Expenditure Report
As of 1/14/2022 16.67 % Year Complete Executive Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 35,233.02 52,911.71 422,665.00 12.52% 20,163.95 38,690.87 15,069.07 14,220.84 Benefits 5,122.10 8,781.88 65,858.00 13.33% 2,770.00 5,191.54 2,352.10 3,590.34 Operations 8,332.91 32,128.82 294,213.00 10.92% 8,921.61 20,561.33 (588.70) 11,567.49 Capital Outlay ‐ 20,000.00 ‐ 100.00%‐ ‐ ‐ 20,000.00 COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 48,688.03 113,822.41 782,736.00 14.54% 31,855.56 64,443.74 16,832.47 49,378.67 Legislative Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 10,417.04 20,834.08 125,000.00 16.67% 10,417.04 21,445.73 ‐ (611.65) Benefits 779.52 1,595.11 10,323.00 15.45% 782.00 1,610.80 (2.48) (15.69) Operations ‐ 415.82 30,400.00 1.37% 19.95 396.02 (19.95) 19.80 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 11,196.56 22,845.01 165,723.00 13.79% 11,218.99 23,452.55 (22.43) (607.54) Finance Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 33,389.67 51,466.50 439,849.00 11.70% 24,314.12 48,546.82 9,075.55 2,919.68 Benefits 5,937.28 11,102.59 82,082.00 13.53% 4,256.95 8,538.55 1,680.33 2,564.04 Operations 7,506.46 15,091.80 252,820.00 5.97% 9,315.06 20,285.32 (1,808.60) (5,193.52) Capital Outlay ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 46,833.41 77,660.89 774,751.00 10.02% 37,886.13 77,370.69 8,947.28 290.20 City Clerk Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 12,107.43 17,364.27 124,042.00 14.00% 29,681.60 38,583.15 (17,574.17) (21,218.88) Benefits 2,020.30 3,246.98 24,411.00 13.30% 3,056.91 4,819.64 (1,036.61) (1,572.66) Operations 7,094.01 17,174.96 80,170.00 21.42% 1,341.17 7,835.67 5,752.84 9,339.29 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 19.95 ‐ (19.95) Total 21,221.74 37,786.21 228,623.00 16.53% 34,079.68 51,258.41 (12,857.94) (13,472.20) HR Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 27,525.14 39,865.00 335,980.00 11.87% 23,151.29 46,328.39 4,373.85 (6,463.39) Benefits 4,463.02 8,330.13 292,173.00 2.85% 4,220.01 8,587.68 243.01 (257.55) Operations 6,166.31 9,780.66 95,600.00 10.23% 1,411.72 5,805.66 4,754.59 3,975.00 Capital Outlay ‐ ‐ 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% 419.99 431.94 (419.99) (431.94) Total 38,154.47 57,975.79 723,753.00 8.01% 29,203.01 61,153.67 8,951.46 (3,177.88) IT Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 21,236.04 31,408.24 218,147.00 14.40% 15,929.80 31,856.56 5,306.24 (448.32) Benefits 3,294.62 5,941.21 38,636.00 15.38% 2,664.64 5,342.95 629.98 598.26 Operations 125,655.51 406,970.99 1,721,197.00 23.64% 122,183.85 195,538.92 3,471.66 211,432.07 Capital Outlay 54,701.00 54,701.00 215,000.00 0.25 ‐ ‐ 54,701.00 54,701.00 COVID‐19 ‐ ‐ ‐ 33,124.52 41,771.92 (33,124.52) (41,771.92) Total 204,887.17 499,021.44 2,192,980.00 22.76% 173,902.81 274,510.35 30,984.36 224,511.09 City of Prattville November 2021 Unaudited Expenditures By Department Vehicle Maint. Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 19,846.90 29,591.95 234,957.00 12.59% 12,672.30 48,673.92 7,174.60 (19,081.97) Benefits 3,255.55 9,236.68 48,849.00 18.91% 2,168.03 6,385.99 1,087.52 2,850.69 Operations 4,285.62 9,252.22 101,650.00 9.10% 4,860.49 10,081.09 (574.87) (828.87) Capital Outlay ‐ ‐ 40,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 27,388.07 48,080.85 425,456.00 11.30% 19,700.82 65,141.00 7,687.25 (17,060.15) Engineering Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 45,487.58 69,636.87 619,777.00 11.24% 40,169.84 79,644.13 5,317.74 (10,007.26) Benefits 8,337.10 21,254.39 138,019.00 15.40% 7,247.47 14,524.56 1,089.63 6,729.83 Operations 21,763.12 54,781.48 1,214,902.00 4.51% 18,452.10 66,984.70 3,311.02 (12,203.22) Capital Outlay ‐ ‐ 100,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 75,587.80 145,672.74 2,072,698.00 7.03% 65,869.41 161,153.39 9,718.39 (15,480.65) Planning Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 36,069.89 53,913.69 426,880.00 12.63% 29,829.03 59,698.89 6,240.86 (5,785.20) Benefits 6,370.60 11,558.15 81,800.00 14.13% 5,471.01 10,987.18 899.59 570.97 Operations 41,197.16 51,220.67 323,450.00 15.84% 32,582.48 76,886.48 8,614.68 (25,665.81) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 83,637.65 116,692.51 832,130.00 14.02% 67,882.52 147,572.55 15,755.13 (30,880.04) Urban Management Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 83,833.25 144,529.68 1,117,145.00 12.94% 76,555.42 151,989.41 7,277.83 (7,459.73) Benefits 13,774.16 33,034.39 223,770.00 14.76% 12,826.69 25,414.96 947.47 7,619.43 Operations 38,225.54 82,173.28 560,500.00 14.66% 50,398.14 100,323.98 (12,172.60) (18,150.70) Capital Outlay ‐ ‐ 129,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 135,832.95 259,737.35 2,030,415.00 12.79% 139,780.25 277,728.35 (3,947.30) (17,991.00) Facilities Maintenance Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 33,820.48 49,919.65 397,866.00 12.55% 27,415.25 54,684.97 6,405.23 (4,765.32) Benefits 5,331.54 10,920.93 81,396.00 13.42% 4,475.52 8,966.71 856.02 1,954.22 Operations 7,997.40 39,478.85 229,000.00 17.24% 23,236.70 33,978.16 (15,239.30) 5,500.69 Capital Outlay ‐ ‐ 455,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 47,149.42 100,319.43 1,163,262.00 8.62% 55,127.47 97,629.84 (7,978.05) 2,689.59 Public Works Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 29,011.33 43,825.73 355,055.00 12.34% 25,303.32 49,743.27 3,708.01 (5,917.54) Benefits 5,152.97 10,842.00 71,937.00 15.07% 4,538.01 8,959.82 614.96 1,882.18 Operations 39,983.68 60,596.95 327,718.00 18.49% 38,141.91 52,334.09 1,841.77 8,262.86 Capital Outlay ‐ ‐ 100.00 ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 74,147.98 115,264.68 754,710.00 15.27% 67,983.24 111,037.18 6,164.74 4,227.50 Police Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 501,911.59 759,199.24 6,205,541.00 12.23% 380,519.36 749,202.24 121,392.23 9,997.00 Benefits 83,940.84 194,703.45 1,280,084.00 15.21% 65,849.53 129,738.05 18,091.31 64,965.40 Operations 135,171.48 351,629.18 1,563,261.00 22.49% 26,057.43 193,569.10 109,114.05 158,060.08 Capital Outlay ‐ ‐ 526,102.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 4,247.99 4,423.74 (4,247.99) (4,423.74) Total 721,023.91 1,305,531.87 9,574,988.00 13.63% 476,674.31 1,076,933.13 244,349.60 228,598.74 Fire Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 454,020.95 684,505.58 5,687,258.00 12.04% 388,752.97 755,994.97 65,267.98 (71,489.39) Benefits 80,942.38 200,052.38 1,211,167.00 16.52% 69,799.58 136,523.94 11,142.80 63,528.44 Operations 54,441.11 136,539.50 1,126,017.00 12.13% 75,848.29 164,538.10 (21,407.18) (27,998.60) Capital Outlay ‐ ‐ 900,000.00 ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 4,044.46 5,694.46 (4,044.46) (5,694.46) Total 589,404.44 1,021,097.46 8,924,442.00 11.44% 538,445.30 1,062,751.47 50,959.14 (41,654.01) Building Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 24,106.40 35,375.04 267,629.00 13.22% 19,131.60 19,131.60 4,974.80 16,243.44 Benefits 4,060.49 8,776.44 56,692.00 15.48% 3,433.31 3,433.31 627.18 5,343.13 Operations 5,487.02 11,079.52 67,450.00 16.43% 1,002.56 1,002.56 4,484.46 10,076.96 Capital Outlay ‐ ‐ 26,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 33,653.91 55,231.00 417,771.00 13.22% 23,567.47 23,567.47 10,086.44 31,663.53 Parks & Recreation Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 98,619.84 143,901.65 1,132,797.00 12.70% 79,581.19 79,581.19 19,038.65 64,320.46 Benefits 15,218.92 33,128.10 216,697.00 15.29% 12,609.31 12,609.31 2,609.61 20,518.79 Operations 86,694.86 146,431.42 1,230,438.00 11.90% 91,585.04 91,585.04 (4,890.18) 54,846.38 Capital Outlay/ Capital Projects ‐ ‐ 488,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 200,533.62 323,461.17 3,067,932.00 10.54% 183,775.54 183,775.54 16,758.08 139,685.63 Performing Arts Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 10,519.76 17,350.87 137,849.00 12.59% 8,896.75 8,896.75 1,623.01 8,454.12 Benefits 1,757.26 3,348.65 24,304.00 13.78% 1,383.82 1,383.82 373.44 1,964.83 Operations 32,367.05 33,856.69 254,820.00 13.29% 6,445.93 6,445.93 25,921.12 27,410.76 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 44,644.07 54,556.21 416,973.00 13.08% 16,726.50 16,726.50 27,917.57 37,829.71 Non‐Departmental Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference City ‐ County Svcs 21,249.99 101,249.99 432,000.00 23.44%‐ ‐ 21,249.99 101,249.99 Community Initiatives 520,714.90 545,148.91 1,240,839.00 43.93% 6,792.00 16,009.38 513,922.90 529,139.53 Unprocessed JP Morgan Payment ‐ ‐ ‐ 100.00%‐ ‐ ‐ ‐ Drug Proceeds Expenditures ‐ ‐ ‐ 100.00%‐ 198.00 ‐ (198.00) Transfer to DSF ‐ One Cent ‐ Infras ‐ 92,941.47 573,819.00 16.20%‐ 1,623,029.10 ‐ (1,530,087.63) Transfer to DSF ‐ Other ‐ 123,311.20 123,311.00 100.00% 84,218.42 216,252.67 (84,218.42) (92,941.47) Transfer to Group Health 274,750.00 549,500.00 3,297,000.00 16.67% 252,500.00 505,000.00 22,250.00 44,500.00 Transfer to Capital Project Fund ‐ ‐ 2,790,260.00 ‐ ‐ ‐ ‐ ‐ Transfer to Wasewater Fund ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Sanitation Fund ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Gas Tax Fund ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Judicial ‐ ‐ 261,287.00 ‐ ‐ ‐ ‐ ‐ Total 816,714.89 1,588,167.77 8,718,516.00 18.22% 343,510.42 2,360,489.15 473,204.47 (948,337.58) Debt Service Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Debt Service 42,570.70 67,540.80 2,134,891.00 3.16% 130,933.52 155,544.49 (88,362.82) (88,003.69) Total 42,570.70 67,540.80 2,134,891.00 3.16% 130,933.52 155,544.49 (88,362.82) (88,003.69) Total Nov‐21 YTD Budget % of Budget Nov‐20 YTD November Difference YTD Difference Salary 1,477,156.31 2,245,599.75 18,248,437.00 12.31% 1,212,484.83 2,282,692.86 264,671.48 (37,093.11) Benefits 524,508.65 1,125,353.46 7,245,198.00 15.53% 460,052.79 898,018.81 64,455.86 227,334.65 Operations 1,164,334.13 2,105,001.71 14,197,992.00 14.83% 518,596.43 1,064,359.53 645,737.70 1,040,642.18 Capital Outlay 54,701.00 74,701.00 2,879,102.00 2.59%‐ ‐ 54,701.00 74,701.00 Debt Service 42,570.70 283,793.47 2,832,021.00 10.02% 215,151.94 1,994,826.26 (172,581.24) (1,711,032.79) COVID‐19 ‐ ‐ ‐ ‐ 41,836.96 52,342.01 Total 3,263,270.79 5,834,449.39 45,402,750.00 12.85% 2,448,122.95 6,292,239.47 856,984.80 (405,448.07) % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 12.85%