Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
May 2022 - Council Expenditure Report
As of 6/15/2022 66.67 % Year Complete Executive May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 37,200.98 282,668.77 422,665.00 58.08% 22,546.12 186,093.70 14,654.86 59,374.09 Benefits 5,715.42 43,998.37 65,858.00 66.81% 3,113.36 25,690.78 2,602.06 18,307.59 Operations 13,921.17 107,654.89 294,213.00 36.59% 21,743.27 98,065.82 (7,822.10) 9,589.07 Capital Outlay ‐ 23,814.53 ‐ 100.00%‐ ‐ ‐ 23,814.53 COVID‐19 ‐ ‐ ‐ ‐ ‐ 2,740.93 ‐ (2,740.93) Total 56,837.57 458,136.56 782,736.00 58.53% 47,402.75 312,591.23 9,434.82 108,344.35 Legislative May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 10,417.04 83,336.32 125,000.00 66.67% 10,417.04 83,947.97 ‐ (611.65) Benefits 778.64 6,194.75 10,323.00 60.01% 760.98 6,464.39 17.66 (269.64) Operations 1,988.84 5,679.75 30,400.00 18.68% 31.02 1,743.77 1,957.82 3,935.98 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 13,184.52 95,210.82 165,723.00 57.45% 11,209.04 92,156.13 1,975.48 3,054.69 Finance May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 33,415.45 269,554.38 439,849.00 61.28% 25,901.97 225,829.69 7,513.48 43,724.69 Benefits 6,001.19 52,079.70 82,083.00 63.45% 4,549.78 39,720.67 1,451.41 12,359.03 Operations 10,492.41 187,758.39 252,820.00 74.27% 29,559.96 259,041.23 (19,067.55) (71,282.84) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 49,909.05 509,392.47 774,752.00 65.75% 60,011.71 524,591.59 (10,102.66) (15,199.12) City Clerk May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 10,610.38 85,301.84 124,042.00 68.77% 10,334.20 104,155.35 276.18 (18,853.51) Benefits 1,889.82 15,570.33 24,410.00 63.79% 1,742.45 13,355.35 147.37 2,214.98 Operations 10,058.21 64,619.90 80,170.00 80.60% 5,766.47 27,630.10 4,291.74 36,989.80 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 19.95 ‐ (19.95) Total 22,558.41 165,492.07 228,622.00 72.39% 17,843.12 145,160.75 4,715.29 20,331.32 HR May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 26,599.05 205,010.67 343,172.00 59.74% 24,574.06 217,375.48 2,024.99 (12,364.81) Benefits 4,868.62 39,543.48 292,723.00 13.51% 4,473.62 39,251.29 395.00 292.19 Operations 1,270.01 47,197.97 87,858.00 53.72% 1,824.22 30,356.36 (554.21) 16,841.61 Capital Outlay ‐ ‐ 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00%‐ 927.82 ‐ (927.82) Total 32,737.68 291,752.12 723,753.00 40.31% 30,871.90 287,910.95 1,865.78 3,841.17 IT May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 18,227.56 147,650.85 218,147.00 67.68% 16,889.78 145,930.66 1,337.78 1,720.19 Benefits 3,143.28 26,240.08 38,636.00 67.92% 2,827.68 24,451.00 315.60 1,789.08 Operations 285,436.90 1,485,184.68 1,721,197.00 86.29% 145,690.99 1,346,041.73 139,745.91 139,142.95 Capital Outlay 59,625.00 121,598.00 215,000.00 0.57 ‐ 20,855.13 59,625.00 100,742.87 COVID‐19 ‐ ‐ ‐ 2,258.23 135,787.53 (2,258.23) (135,787.53) Total 366,432.74 1,780,673.61 2,192,980.00 81.20% 167,666.68 1,673,066.05 198,766.06 107,607.56 Vehicle Maint. May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 17,134.73 142,777.90 234,957.00 60.77% 15,487.67 149,674.65 1,647.06 (6,896.75) Benefits 3,002.70 35,397.53 48,849.00 72.46% 2,645.13 33,782.07 357.57 1,615.46 Operations 3,769.94 31,817.16 101,650.00 31.30% 1,472.81 43,722.39 2,297.13 (11,905.23) Capital Outlay ‐ ‐ 40,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 23,907.37 209,992.59 425,456.00 49.36% 19,605.61 227,179.11 4,301.76 (17,186.52) City of Prattville May 2022 Unaudited Expenditures By Department Engineering May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 46,960.46 361,799.74 619,777.00 58.38% 41,846.30 346,104.64 5,114.16 15,695.10 Benefits 8,672.14 96,337.27 138,019.00 69.80% 7,476.54 80,096.32 1,195.60 16,240.95 Operations 34,950.84 438,950.83 1,214,902.00 36.13% 30,302.94 209,356.72 4,647.90 229,594.11 Capital Projects ‐ ‐ 0.00%‐ ‐ ‐ ‐ Capital Outlay ‐ 89,172.60 100,000.00 ‐ ‐ ‐ ‐ 89,172.60 COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 90,583.44 986,260.44 2,072,698.00 47.58% 79,625.78 635,557.68 10,957.66 350,702.76 Planning May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 33,014.96 267,507.07 426,880.00 62.67% 31,386.54 266,984.44 1,628.42 522.63 Benefits 6,187.17 52,107.89 81,800.00 63.70% 5,722.42 49,107.21 464.75 3,000.68 Operations 27,469.27 91,284.01 323,450.00 28.22% 35,641.46 306,978.31 (8,172.19) (215,694.30) Capital Projects ‐ ‐ 0.00%‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 1,709.34 3,630.48 (1,709.34) (3,630.48) Total 66,671.40 410,898.97 832,130.00 49.38% 74,459.76 626,700.44 (7,788.36) (215,801.47) Urban Management May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 81,572.15 673,280.85 1,117,145.00 60.27% 73,441.01 655,896.20 8,131.14 17,384.65 Benefits 14,196.19 153,515.73 223,770.00 68.60% 12,492.43 135,738.77 1,703.76 17,776.96 Operations 44,873.32 337,463.14 560,500.00 60.21% 30,309.14 330,457.66 14,564.18 7,005.48 Capital Outlay (10,378.25) 59,952.00 129,000.00 0.46 ‐ ‐ (10,378.25) 59,952.00 COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 130,263.41 1,224,211.72 2,030,415.00 60.29% 116,242.58 1,122,092.63 14,020.83 102,119.09 Facilities Maintenance May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 26,379.44 241,103.01 397,866.00 60.60% 28,359.03 242,703.07 (1,979.59) (1,600.06) Benefits 4,408.17 56,475.36 81,396.00 69.38% 4,660.88 44,681.96 (252.71) 11,793.40 Operations 12,273.99 122,808.27 229,000.00 53.63% 3,616.47 105,351.22 8,657.52 17,457.05 Capital Outlay ‐ ‐ 455,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 66,244.23 ‐ (66,244.23) Total 43,061.60 420,386.64 1,163,262.00 36.14% 36,636.38 458,980.48 6,425.22 (38,593.84) Public Works May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 27,287.27 221,106.71 355,055.00 62.27% 26,046.72 222,574.76 1,240.55 (1,468.05) Benefits 5,036.45 48,655.73 71,937.00 67.64% 4,671.24 44,508.04 365.21 4,147.69 Operations 11,543.80 175,637.40 327,718.00 53.59% 9,763.94 143,453.32 1,779.86 32,184.08 Capital Outlay ‐ ‐ 0.00% 173,140.00 220,312.00 (173,140.00) (220,312.00) COVID‐19 ‐ ‐ ‐ ‐ 695.55 ‐ (695.55) Total 43,867.52 445,399.84 754,710.00 59.02% 213,621.90 631,543.67 (169,754.38) (186,143.83) Police May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 495,320.46 3,812,924.22 6,205,541.00 61.44% 384,589.59 3,364,543.32 110,730.87 448,380.90 Benefits 81,247.85 881,748.12 1,280,084.00 68.88% 66,247.24 715,826.20 15,000.61 165,921.92 Operations 83,193.46 1,123,495.91 2,089,530.00 53.77% 71,668.04 873,668.27 11,525.42 249,827.64 Capital Outlay 33,263.96 425,763.84 650,028.00 0.65 ‐ ‐ 33,263.96 425,763.84 COVID‐19 ‐ ‐ ‐ ‐ 54,437.46 ‐ (54,437.46) Total 693,025.73 6,243,932.09 10,225,183.00 61.06% 522,504.87 5,008,475.25 170,520.86 1,235,456.84 Fire May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 413,537.15 3,544,945.74 5,687,258.00 62.33% 375,782.36 3,434,211.42 37,754.79 110,734.32 Benefits 73,572.34 866,347.52 1,211,167.00 71.53% 67,513.76 783,757.98 6,058.58 82,589.54 Operations 95,534.76 600,554.00 1,500,762.00 40.02% 102,004.11 670,933.91 (6,469.35) (70,379.91) Capital Outlay 541,145.33 759,922.14 987,765.00 76.93% 473.00 213,898.57 540,672.33 546,023.57 COVID‐19 ‐ ‐ ‐ ‐ 60,379.92 ‐ (60,379.92) Total 1,123,789.58 5,771,769.40 9,386,952.00 61.49% 545,773.23 5,163,181.80 578,016.35 608,587.60 Building May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 20,687.51 169,240.75 267,629.00 63.24% 19,465.60 165,510.78 1,221.91 3,729.97 Benefits 3,813.67 39,000.80 56,692.00 68.79% 3,494.94 34,475.79 318.73 4,525.01 Operations 4,358.32 22,956.49 67,450.00 34.03% 988.68 21,806.02 3,369.64 1,150.47 Capital Outlay ‐ ‐ 26,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 28,859.50 231,198.04 417,771.00 55.34% 23,949.22 221,792.59 4,910.28 9,405.45 Parks & Recreation May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 107,038.29 721,478.52 1,132,797.00 63.69% 87,622.78 669,719.26 19,415.51 51,759.26 Benefits 17,195.96 154,005.96 216,697.00 71.07% 13,632.76 129,195.67 3,563.20 24,810.29 Operations 136,905.56 795,076.92 1,245,438.00 63.84% 120,269.61 751,507.33 16,635.95 43,569.59 Capital Outlay/ Capital Projects 164,234.00 164,234.00 1,702,054.00 0.10 ‐ 9,309.99 164,234.00 154,924.01 COVID‐19 ‐ ‐ ‐ ‐ 209.95 ‐ (209.95) Total 425,373.81 1,834,795.40 4,296,986.00 42.70% 221,525.15 1,559,942.20 203,848.66 274,853.20 Performing Arts May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 8,753.73 93,787.21 137,849.00 68.04% 9,399.51 79,793.14 (645.78) 13,994.07 Benefits 1,518.88 16,869.28 24,304.00 69.41% 1,455.03 12,680.91 63.85 4,188.37 Operations 10,559.81 147,533.94 254,820.00 57.90% 6,752.99 63,628.52 3,806.82 83,905.42 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 23.96 ‐ (23.96) Total 20,832.42 258,190.43 416,973.00 61.92% 17,607.53 156,126.53 3,224.89 102,063.90 Non‐Departmental May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference City ‐ County Svcs 7,083.33 323,250.00 432,000.00 74.83% 7,083.33 328,750.01 ‐ (5,500.01) Community Initiatives 36,676.27 868,884.37 1,240,839.00 70.02% 17,169.58 187,547.23 19,506.69 681,337.14 Unprocessed JP Morgan Payment ‐ ‐ ‐ 100.00%‐ ‐ ‐ ‐ Drug Proceeds Expenditures ‐ 36,916.50 ‐ 100.00%‐ 19,596.00 ‐ 17,320.50 Transfer to DSF ‐ One Cent ‐ Infras ‐ 400,621.79 573,819.00 69.82%‐ ‐ ‐ 400,621.79 Transfer to DSF ‐ Other ‐ 123,311.20 123,311.00 100.00%‐ 441,595.61 ‐ (318,284.41) Transfer to DSF ‐ One Cent (old)‐ ‐ ‐ ‐ 8,710,709.10 ‐ ‐ Transfer to Group Health 274,750.00 2,198,000.00 3,297,000.00 66.67% 252,500.00 2,024,344.00 22,250.00 173,656.00 Transfer to Capital Project Fund 113,776.00 2,348,114.00 5,132,682.00 0.46 ‐ ‐ 113,776.00 2,348,114.00 Transfer to Wasewater Fund ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Sanitation Fund ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Gas Tax Fund ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Judicial 261,287.36 261,287.36 261,287.00 1.00 ‐ ‐ 261,287.36 261,287.36 Total 693,572.96 6,936,105.16 11,060,938.00 62.71% 276,752.91 11,712,541.95 416,820.05 3,558,552.37 Debt Service May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Debt Service 154,471.11 1,206,301.01 2,134,891.00 56.50% 139,711.56 1,277,950.62 14,759.55 (71,649.61) Total 154,471.11 1,206,301.01 2,134,891.00 56.50% 139,711.56 1,277,950.62 14,759.55 (71,649.61) Total May‐22 YTD Budget % of Budget May‐21 YTD May Difference YTD Difference Salary 1,414,156.61 11,323,474.55 18,255,629.00 62.03% 1,204,090.28 10,561,048.53 210,066.33 762,426.02 Benefits 515,998.49 4,782,087.90 7,245,748.00 66.00% 459,980.24 4,237,128.40 56,018.25 544,959.50 Operations 1,207,423.57 9,624,125.88 17,448,686.00 55.16% 641,659.03 5,819,635.92 565,764.54 3,804,489.96 Capital Outlay 787,890.04 1,644,457.11 4,304,847.00 38.20% 173,613.00 464,375.69 614,277.04 1,180,081.42 Debt Service 154,471.11 1,730,234.00 2,832,021.00 61.10% 139,711.56 10,430,255.33 14,759.55 (8,700,021.33) COVID‐19 ‐ ‐ ‐ ‐ 3,967.57 325,097.78 Total 4,079,939.82 29,104,379.44 50,086,931.00 58.11% 2,623,021.68 31,837,541.65 1,460,885.71 (2,408,064.43) % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 58.11% Prepared by Carlee Sims