Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
January 2022 - Council Expenditure Report
As of 2/14/2022 33.33 % Year Complete Executive Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 32,651.50 134,432.00 422,665.00 31.81% 21,559.21 96,698.85 11,092.29 37,733.15 Benefits 5,508.22 21,686.35 65,858.00 32.93% 2,952.26 13,048.10 2,555.96 8,638.25 Operations 9,334.86 55,837.44 294,213.00 18.98% 8,970.33 39,236.12 364.53 16,601.32 Capital Outlay ‐ 20,000.00 ‐ 100.00% ‐ ‐ ‐ 20,000.00 COVID‐19 ‐ ‐ ‐ ‐ 269.83 2,328.53 (269.83) (2,328.53) Total 47,494.58 231,955.79 782,736.00 29.63% 33,751.63 151,311.60 13,742.95 80,644.19 Legislative Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 10,417.04 41,668.16 125,000.00 33.33% 10,417.04 42,279.81 ‐ (611.65) Benefits 921.46 3,209.73 10,323.00 31.09% 754.18 3,125.96 167.28 83.77 Operations 66.59 922.91 30,400.00 3.04% ‐ 464.77 66.59 458.14 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 11,405.09 45,800.80 165,723.00 27.64% 11,171.22 45,870.54 233.87 (69.74) Finance Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 33,749.57 134,829.49 439,849.00 30.65% 28,388.24 120,636.70 5,361.33 14,192.79 Benefits 7,929.47 27,950.52 82,082.00 34.05% 4,976.76 20,827.99 2,952.71 7,122.53 Operations 78,982.25 107,555.88 252,820.00 42.54% 139,404.77 167,061.56 (60,422.52) (59,505.68) Capital Outlay ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 120,661.29 270,335.89 774,751.00 34.89% 172,769.77 308,526.25 (52,108.48) (38,190.36) City Clerk Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 10,476.08 42,802.87 124,042.00 34.51% 4,327.07 51,744.91 6,149.01 (8,942.04) Benefits 2,048.85 8,025.35 24,411.00 32.88% 452.04 6,279.43 1,596.81 1,745.92 Operations 13,970.38 37,384.42 80,170.00 46.63% 711.61 10,057.93 13,258.77 27,326.49 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 19.95 ‐ (19.95) Total 26,495.31 88,212.64 228,623.00 38.58% 5,490.72 68,102.22 21,004.59 20,110.42 HR Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 25,595.29 101,432.13 335,980.00 30.19% 24,647.36 119,457.48 947.93 (18,025.35) Benefits 5,253.71 20,338.92 292,173.00 6.96% 4,491.58 20,997.10 762.13 (658.18) Operations 6,870.57 25,515.36 95,600.00 26.69% 984.67 15,056.92 5,885.90 10,458.44 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% 67.97 927.82 (67.97) (927.82) Total 37,719.57 147,286.41 723,753.00 20.35% 30,191.58 156,439.32 7,527.99 (9,152.91) IT Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 17,284.03 75,281.47 218,147.00 34.51% 16,251.29 77,170.88 1,032.74 (1,889.41) Benefits 3,267.95 13,792.10 38,636.00 35.70% 2,718.83 12,633.19 549.12 1,158.91 Operations 217,276.29 846,896.57 1,721,197.00 49.20% 389,515.50 694,932.64 (172,239.21) 151,963.93 Capital Outlay ‐ 61,973.00 215,000.00 0.29 ‐ ‐ ‐ 61,973.00 COVID‐19 ‐ ‐ ‐ 36,590.24 79,429.78 (36,590.24) (79,429.78) Total 237,828.27 997,943.14 2,192,980.00 45.51% 445,075.86 864,166.49 (207,247.59) 133,776.65 Vehicle Maint. Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 19,536.72 75,936.53 234,957.00 32.32% 17,270.28 86,349.18 2,266.44 (10,412.65) Benefits 9,765.07 23,699.95 48,849.00 48.52% 2,939.48 12,849.52 6,825.59 10,850.43 Operations 1,011.41 12,693.10 101,650.00 12.49% 3,704.74 21,145.87 (2,693.33) (8,452.77) Capital Outlay ‐ ‐ 40,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 30,313.20 112,329.58 425,456.00 26.40% 23,914.50 120,344.57 6,398.70 (8,014.99) City of Prattville January 2022 Unaudited Expenditures By Department Engineering Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 44,416.67 180,342.71 619,777.00 29.10% 37,087.79 188,300.32 7,328.88 (7,957.61) Benefits 28,225.78 61,750.41 138,019.00 44.74% 6,731.76 33,482.98 21,494.02 28,267.43 Operations 140,307.22 224,565.95 1,214,902.00 18.48% 12,034.81 92,458.50 128,272.41 132,107.45 Capital Projects ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ 100,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 212,949.67 466,659.07 2,072,698.00 22.51% 55,854.36 314,241.80 157,095.31 152,417.27 Planning Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 32,794.39 135,863.86 426,880.00 31.83% 31,071.28 141,814.60 1,723.11 (5,950.74) Benefits 6,729.82 27,496.38 81,800.00 33.61% 5,666.45 25,687.09 1,063.37 1,809.29 Operations (60,287.45) 27,911.32 323,450.00 8.63% 35,030.74 148,901.23 (95,318.19) (120,989.91) Capital Projects ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total (20,763.24) 191,271.56 832,130.00 22.99% 71,768.47 316,402.92 (92,531.71) (125,131.36) Urban Management Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 80,542.93 348,651.21 1,117,145.00 31.21% 78,144.98 357,651.64 2,397.95 (9,000.43) Benefits 40,607.46 94,844.70 223,770.00 42.38% 13,133.55 60,212.31 27,473.91 34,632.39 Operations 48,212.94 165,878.60 560,500.00 29.59% 38,123.54 175,849.17 10,089.40 (9,970.57) Capital Outlay 10,378.25 10,378.25 129,000.00 0.08 ‐ ‐ 10,378.25 10,378.25 COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 179,741.58 619,752.76 2,030,415.00 30.52% 129,402.07 593,713.12 50,339.51 26,039.64 Facilities Maintenance Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 29,235.71 124,021.93 397,866.00 31.17% 27,559.15 130,001.63 1,676.56 (5,979.70) Benefits 18,149.30 36,696.87 81,396.00 45.08% 4,588.10 21,107.56 13,561.20 15,589.31 Operations 9,818.53 52,353.14 229,000.00 22.86% 5,779.37 45,142.21 4,039.16 7,210.93 Capital Outlay ‐ ‐ 455,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 39,578.94 39,578.94 (39,578.94) (39,578.94) Total 57,203.54 213,071.94 1,163,262.00 18.32% 77,505.56 235,830.34 (20,302.02) (22,758.40) Public Works Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 27,206.37 111,933.58 355,055.00 31.53% 26,139.84 118,915.91 1,066.53 (6,982.33) Benefits 10,172.34 28,566.76 71,937.00 39.71% 4,688.89 21,055.95 5,483.45 7,510.81 Operations 33,397.14 104,484.82 327,718.00 31.88% 10,701.12 83,175.11 22,696.02 21,309.71 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 695.55 695.55 (695.55) (695.55) Total 70,775.85 244,985.16 754,710.00 32.46% 42,225.40 223,842.52 28,550.45 21,142.64 Police Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 470,138.75 1,960,790.98 6,205,541.00 31.60% 396,138.06 1,834,398.70 74,000.69 126,392.28 Benefits 237,416.54 561,870.76 1,280,084.00 43.89% 68,448.98 312,824.60 168,967.56 249,046.16 Operations 282,581.84 702,324.58 1,563,261.00 44.93% 317,663.77 553,433.06 (35,081.93) 148,891.52 Capital Outlay ‐ ‐ 526,102.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 49,582.24 54,373.62 (49,582.24) (54,373.62) Total 990,137.13 3,224,986.32 9,574,988.00 33.68% 831,833.05 2,755,029.98 158,304.08 469,956.34 Fire Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 493,146.71 1,880,288.04 5,687,258.00 33.06% 454,507.20 1,944,281.12 38,639.51 (63,993.08) Benefits 232,160.13 562,456.69 1,211,167.00 46.44% 78,879.88 344,624.54 153,280.25 217,832.15 Operations 74,516.39 277,388.57 1,126,017.00 24.63% 53,930.10 271,390.38 20,586.29 5,998.19 Capital Outlay ‐ ‐ 919,861.41 ‐ ‐ 176,548.62 ‐ (176,548.62) COVID‐19 ‐ ‐ ‐ 4,680.16 61,813.56 (4,680.16) (61,813.56) Total 799,823.23 2,720,133.30 8,944,303.41 30.41% 591,997.34 2,798,658.22 207,825.89 (78,524.92) Building Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 20,552.00 86,830.58 267,629.00 32.44% 19,465.60 87,601.45 1,086.40 (770.87) Benefits 9,274.47 23,812.29 56,692.00 42.00% 3,494.94 15,877.76 5,779.53 7,934.53 Operations 1,088.66 13,132.57 67,450.00 19.47% 2,024.22 12,469.38 (935.56) 663.19 Capital Outlay ‐ ‐ 26,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 30,915.13 123,775.44 417,771.00 29.63% 24,984.76 115,948.59 5,930.37 7,826.85 Parks & Recreation Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 73,683.21 345,285.03 1,132,797.00 30.48% 66,333.26 345,935.49 7,349.95 (650.46) Benefits 36,096.47 90,348.58 216,697.00 41.69% 11,432.88 55,909.73 24,663.59 34,438.85 Operations 65,953.66 259,663.50 1,230,438.00 21.10% 48,155.65 336,429.72 17,798.01 (76,766.22) Capital Outlay/ Capital Projects ‐ ‐ 488,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 130.00 ‐ (130.00) Total 175,733.34 695,297.11 3,067,932.00 22.66% 125,921.79 738,404.94 49,811.55 (43,107.83) Performing Arts Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 10,748.64 47,719.59 137,849.00 34.62% 8,775.71 41,391.45 1,972.93 6,328.14 Benefits 2,050.86 8,825.24 24,304.00 36.31% 1,374.52 6,510.41 676.34 2,314.83 Operations 24,044.16 71,761.96 254,820.00 28.16% 3,668.19 27,329.36 20,375.97 44,432.60 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 23.96 ‐ (23.96) Total 36,843.66 128,306.79 416,973.00 30.77% 13,818.42 75,255.18 23,025.24 53,051.61 Non‐Departmental Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference City ‐ County Svcs 94,166.68 195,416.67 432,000.00 45.24% 112,083.34 213,333.36 (17,916.66) (17,916.69) Community Initiatives 103,887.17 707,137.01 1,240,839.00 56.99% 38,620.61 97,516.28 65,266.56 609,620.73 Unprocessed JP Morgan Payment ‐ ‐ ‐ 100.00% ‐ ‐ ‐ ‐ Drug Proceeds Expenditures ‐ ‐ ‐ 100.00% ‐ 763.00 ‐ (763.00) Transfer to DSF ‐ One Cent ‐ Infras 214,738.85 307,680.32 573,819.00 53.62% ‐ ‐ 214,738.85 307,680.32 Transfer to DSF ‐ Other ‐ 123,311.20 123,311.00 100.00% 132,401.47 348,654.14 (132,401.47) (225,342.94) Transfer to DSF ‐ One Cent (old)5,390,000.00 7,013,029.10 Transfer to Group Health 274,750.00 1,099,000.00 3,297,000.00 33.33% 252,500.00 1,010,000.00 22,250.00 89,000.00 Transfer to Capital Project Fund 1,317,970.00 1,317,970.00 2,790,260.00 0.47 ‐ ‐ 1,317,970.00 1,317,970.00 Transfer to Wasewater Fund ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Sanitation Fund ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Gas Tax Fund ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Judicial ‐ ‐ 261,287.00 ‐ ‐ ‐ ‐ ‐ Total 2,005,512.70 3,926,531.40 8,718,516.00 45.04% 5,925,605.42 8,683,295.88 1,469,907.28 2,080,248.42 Debt Service Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Debt Service 486,817.54 673,128.59 2,134,891.00 31.53% 248,715.14 508,285.12 238,102.40 164,843.47 Total 486,817.54 673,128.59 2,134,891.00 31.53% 248,715.14 508,285.12 238,102.40 164,843.47 Total Jan‐22 YTD Budget % of Budget Jan‐21 YTD January Difference YTD Difference Salary 1,432,175.61 5,828,110.16 18,248,437.00 31.94% 1,268,083.36 5,784,630.12 164,092.25 43,480.04 Benefits 930,327.90 2,714,371.60 7,245,198.00 37.46% 470,225.08 1,997,054.22 460,102.82 717,317.38 Operations 2,463,169.29 5,206,794.37 14,197,992.00 36.67% 1,221,107.08 3,006,146.57 1,242,062.21 2,200,647.80 Capital Outlay 10,378.25 92,351.25 2,898,963.41 3.19% ‐ 176,548.62 10,378.25 (84,197.37) Debt Service 701,556.39 1,104,120.11 2,832,021.00 38.99% 5,771,116.61 7,869,968.36 (5,069,560.22) (6,765,848.25) COVID‐19 ‐ ‐ ‐ ‐ 131,464.93 239,321.71 Total 5,537,607.44 14,945,747.49 45,422,611.41 32.90% 8,861,997.06 19,073,669.60 (3,192,924.69) (3,888,600.40) % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 32.90% Prepared by Daniel Oakley