Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
January 2023 - Council Expenditure Report
As of 2/17/2023 33.33 % Year Complete Executive Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 20,833.96 94,339.06 446,090.00 21.15% 32,651.50 134,432.00 (11,817.54) (40,092.94) Benefits 3,622.23 14,331.35 73,359.00 19.54% 5,508.22 21,686.35 (1,885.99) (7,355.00) Operations 14,418.37 110,136.12 315,998.00 34.85% 9,334.86 55,837.44 5,083.51 54,298.68 Capital Outlay ‐ ‐ ‐ 0.00%‐ 20,000.00 ‐ (20,000.00) COVID‐19 ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 38,874.56 218,806.53 835,447.00 26.19% 47,494.58 231,955.79 (8,620.02) (13,149.26) Legislative Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 8,958.70 38,752.50 125,000.00 31.00% 10,417.04 41,668.16 (1,458.34) (2,915.66) Benefits 867.24 2,940.11 10,474.00 28.07% 921.46 3,209.73 (54.22) (269.62) Operations ‐ 443.15 30,100.00 1.47% 66.59 922.91 (66.59) (479.76) Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 9,825.94 42,135.76 165,574.00 25.45% 11,405.09 45,800.80 (1,579.15) (3,665.04) Finance Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 36,033.66 159,061.01 460,940.00 34.51% 33,749.57 134,829.49 2,284.09 24,231.52 Benefits 8,240.81 31,908.78 90,693.00 35.18% 7,929.47 27,950.52 311.34 3,958.26 Operations 9,009.18 41,055.52 238,055.00 17.25% 78,982.25 107,555.88 (69,973.07) (66,500.36) Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ COVID‐19 ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 53,283.65 232,025.31 789,688.00 29.38% 120,661.29 270,335.89 (67,377.64) (38,310.58) City Clerk Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 11,238.53 52,661.24 147,626.00 35.67% 10,476.08 42,802.87 762.45 9,858.37 Benefits 2,237.75 9,761.98 28,627.00 34.10% 2,048.85 8,025.35 188.90 1,736.63 Operations 3,656.86 36,297.12 140,640.00 25.81% 13,970.38 37,384.42 (10,313.52) (1,087.30) Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 17,133.14 98,720.34 316,893.00 31.15% 26,495.31 88,212.64 (9,362.17) 10,507.70 HR Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 28,126.09 128,377.55 362,688.00 35.40% 25,595.29 101,432.13 2,530.80 26,945.42 Benefits 5,809.22 25,107.55 246,649.00 10.18% 5,253.71 20,338.92 555.51 4,768.63 Operations 4,748.40 32,698.00 197,600.00 16.55% 6,870.57 25,515.36 (2,122.17) 7,182.64 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 38,683.71 186,183.10 806,937.00 23.07% 37,719.57 147,286.41 964.14 38,896.69 IT Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 17,207.41 76,323.50 232,474.00 32.83% 17,284.03 75,281.47 (76.62) 1,042.03 Benefits 3,610.53 14,357.22 43,377.00 33.10% 3,267.95 13,792.10 342.58 565.12 Operations 92,849.05 668,137.11 2,038,494.00 32.78% 217,276.29 846,896.57 (124,427.24) (178,759.46) Capital Outlay ‐ 20,868.00 30,000.00 0.00%‐ 61,973.00 ‐ (41,105.00) COVID‐19 ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 113,666.99 779,685.83 2,344,345.00 33.26% 237,828.27 997,943.14 (124,161.28) (218,257.31) Vehicle Maint. Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 14,100.17 64,617.85 238,347.00 27.11% 19,536.72 75,936.53 (5,436.55) (11,318.68) Benefits 7,687.06 19,304.20 53,131.00 36.33% 9,765.07 23,699.95 (2,078.01) (4,395.75) Operations 9,933.77 30,763.07 97,050.00 31.70% 1,011.41 12,693.10 8,922.36 18,069.97 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 31,721.00 114,685.12 388,528.00 29.52% 30,313.20 112,329.58 1,407.80 2,355.54 City of Prattville January 2023 Unaudited Expenditures By Department Engineering Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 49,912.28 227,917.67 697,081.00 32.70% 44,416.67 180,342.71 5,495.61 47,574.96 Benefits 35,015.58 76,226.84 184,712.00 41.27% 28,225.78 61,750.41 6,789.80 14,476.43 Operations 67,421.17 288,932.43 1,315,053.00 21.97% 140,307.22 224,565.95 (72,886.05) 64,366.48 Capital Projects ‐ ‐ 0.00%‐ ‐ ‐ ‐ Capital Outlay 587.95 587.95 445,000.00 0.13%‐ ‐ 587.95 587.95 COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 152,936.98 593,664.89 2,641,846.00 22.47% 212,949.67 466,659.07 (60,012.69) 127,005.82 Planning Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 27,514.52 137,992.10 450,630.00 30.62% 32,794.39 135,863.86 (5,279.87) 2,128.24 Benefits 5,893.61 25,670.02 90,406.00 28.39% 6,729.82 27,496.38 (836.21) (1,826.36) Operations 2,185.89 38,351.75 249,000.00 15.40% (60,287.45) 27,911.32 62,473.34 10,440.43 Capital Projects ‐ ‐ 0.00%‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 35,594.02 202,013.87 790,036.00 25.57% (20,763.24) 191,271.56 56,357.26 10,742.31 Urban Management Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 82,971.42 246,608.55 1,151,880.00 21.41% 80,542.93 348,651.21 2,428.49 (102,042.66) Benefits 36,603.42 54,148.12 257,288.00 21.05% 40,607.46 94,844.70 (4,004.04) (40,696.58) Operations 72,777.93 136,756.02 623,250.00 21.94% 48,212.94 165,878.60 24,564.99 (29,122.58) Capital Outlay ‐ ‐ 50,000.00 0.00% 10,378.25 10,378.25 (10,378.25) (10,378.25) COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 192,352.77 437,512.69 2,082,418.00 21.01% 179,741.58 619,752.76 12,611.19 (182,240.07) Facilities Maintenance Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 29,208.72 134,747.94 400,482.00 33.65% 29,235.71 124,021.93 (26.99) 10,726.01 Benefits 15,146.82 37,552.75 87,527.00 42.90% 18,149.30 36,696.87 (3,002.48) 855.88 Operations 10,506.59 74,794.86 261,500.00 28.60% 9,818.53 52,353.14 688.06 22,441.72 Capital Outlay ‐ ‐ 670,000.00 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 54,862.13 247,095.55 1,419,509.00 17.41% 57,203.54 213,071.94 (2,341.41) 34,023.61 Public Works Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 27,970.64 127,891.00 375,779.00 34.03% 27,206.37 111,933.58 764.27 15,957.42 Benefits 9,600.03 30,652.32 80,973.00 37.85% 10,172.34 28,566.76 (572.31) 2,085.56 Operations 10,243.05 110,715.59 255,968.00 43.25% 33,397.14 104,484.82 (23,154.09) 6,230.77 Capital Outlay ‐ 50,993.65 300,000.00 17.00%‐ ‐ ‐ 50,993.65 COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 47,813.72 320,252.56 1,012,720.00 31.62% 70,775.85 244,985.16 (22,962.13) 75,267.40 Police Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 443,408.33 2,043,060.69 6,654,061.00 30.70% 470,138.75 1,960,790.98 (26,730.42) 82,269.71 Benefits 203,969.80 546,931.72 1,460,253.00 37.45% 237,416.54 561,870.76 (33,446.74) (14,939.04) Operations 157,673.54 689,664.73 1,656,828.00 41.63% 282,581.84 702,324.58 (124,908.30) (12,659.85) Capital Outlay ‐ ‐ 549,367.00 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 805,051.67 3,279,657.14 10,320,509.00 31.78% 990,137.13 3,224,986.32 (185,085.46) 54,670.82 Fire Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 533,248.34 2,182,969.33 6,152,966.00 35.48% 493,146.71 1,880,288.04 40,101.63 302,681.29 Benefits 224,499.96 586,891.80 1,387,748.00 42.29% 232,160.13 562,456.69 (7,660.17) 24,435.11 Operations 90,786.96 403,488.17 1,237,156.00 32.61% 74,516.39 277,388.57 16,270.57 126,099.60 Capital Outlay 378.00 1,505.00 384,371.00 0.39%‐ ‐ 378.00 1,505.00 COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 848,913.26 3,174,854.30 9,162,241.00 34.65% 799,823.23 2,720,133.30 49,090.03 454,721.00 Building Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 20,199.36 79,700.08 263,338.00 30.27% 20,552.00 86,830.58 (352.64) (7,130.50) Benefits 8,879.84 22,279.67 60,846.00 36.62% 9,274.47 23,812.29 (394.63) (1,532.62) Operations 1,314.24 16,145.81 62,450.00 25.85% 1,088.66 13,132.57 225.58 3,013.24 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 30,393.44 118,125.56 386,634.00 30.55% 30,915.13 123,775.44 (521.69) (5,649.88) Parks & Recreation Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 85,961.93 429,391.44 1,238,226.00 34.68% 73,683.21 345,285.03 12,278.72 84,106.41 Benefits 37,554.28 103,954.63 254,964.00 40.77% 36,096.47 90,348.58 1,457.81 13,606.05 Operations 78,725.56 473,421.65 1,532,960.00 30.88% 65,953.66 259,663.50 12,771.90 213,758.15 Capital Outlay/ Capital Projects ‐ 24,997.50 1,559,526.50 1.60%‐ ‐ ‐ 24,997.50 COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 202,241.77 1,031,765.22 4,585,676.50 22.50% 175,733.34 695,297.11 26,508.43 336,468.11 Performing Arts Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 11,066.55 49,795.86 185,634.00 26.82% 10,748.64 47,719.59 317.91 2,076.27 Benefits 2,234.72 9,458.53 31,359.00 30.16% 2,050.86 8,825.24 183.86 633.29 Operations 9,288.33 78,585.44 305,000.00 25.77% 24,044.16 71,761.96 (14,755.83) 6,823.48 Capital Outlay ‐ ‐ 27,400.00 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 22,589.60 137,839.83 549,393.00 25.09% 36,843.66 128,306.79 (14,254.06) 9,533.04 Non‐Departmental Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference City ‐ County Svcs 95,416.67 218,333.33 472,000.00 46.26% 94,166.68 195,416.67 1,249.99 22,916.66 Community Initiatives 29,166.67 231,517.86 778,643.00 29.73% 103,887.17 707,137.01 (74,720.50) (475,619.15) Unprocessed JP Morgan Payment ‐ ‐ ‐ 100.00%‐ ‐ ‐ ‐ Drug Proceeds Expenditures ‐ ‐ ‐ 100.00%‐ ‐ ‐ ‐ Transfer to DSF ‐ One Cent ‐ Infras 317,433.50 410,374.97 584,320.00 70.23% 214,738.85 307,680.32 102,694.65 102,694.65 Transfer to DSF ‐ One Cent ‐ P&R ‐ 232,907.03 860,545.00 27.07%‐ ‐ ‐ 232,907.03 Transfer to DSF ‐ Other ‐ 123,311.20 123,311.00 100.00%‐ 123,311.20 ‐ ‐ Transfer to DSF ‐ One Cent (old)‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Transfer to Group Health 280,000.00 1,120,000.00 3,360,000.00 33.33% 274,750.00 1,099,000.00 5,250.00 21,000.00 Transfer to Capital Project Fund 239,529.10 1,008,653.47 2,204,000.00 45.76% 1,317,970.00 1,317,970.00 (1,078,440.90) (309,316.53) Transfer to Wasewater Fund ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Transfer to Sanitation Fund ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Transfer to Gas Tax Fund ‐ ‐ 98,605.00 0.00%‐ ‐ ‐ ‐ Transfer to Judicial ‐ ‐ 354,557.00 0.00%‐ ‐ ‐ ‐ Total 961,545.94 3,345,097.86 8,835,981.00 37.86% 2,005,512.70 3,750,515.20 (1,043,966.76) (405,417.34) Debt Service Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Debt Service 20,607.73 632,526.51 2,187,125.00 28.92% 486,817.54 673,128.59 (466,209.81) (40,602.08) Total 20,607.73 632,526.51 2,187,125.00 28.92% 486,817.54 673,128.59 (466,209.81) (40,602.08) Total Jan‐23 YTD Budget % of Budget Jan‐22 YTD January Difference YTD Difference Salary 1,447,960.61 6,274,207.37 19,583,242.00 32.04% 1,432,175.61 5,828,110.16 15,785.00 446,097.21 Benefits 891,472.90 2,731,477.59 7,802,386.00 35.01% 930,327.90 2,714,371.60 (38,855.00) 17,105.99 Operations 999,651.33 4,688,891.20 14,464,907.00 32.42% 2,463,169.29 5,206,794.37 (1,463,517.96) (517,903.17) Capital Outlay 965.95 98,952.10 4,015,664.50 2.46% 10,378.25 92,351.25 (9,412.30) 6,600.85 Debt Service 338,041.23 1,399,119.71 3,755,301.00 37.26% 701,556.39 1,104,120.11 (363,515.16) 294,999.60 COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ Total 3,678,092.02 15,192,647.97 49,621,500.50 30.62% 5,537,607.44 14,945,747.49 (1,859,515.42) 246,900.48 % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 30.62% Prepared by Carlee Sims