Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
December 2022 - Council Expenditure Report
As of 1/13/2023 25.00 % Year Complete Executive Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 31,250.94 73,505.10 446,090.00 16.48% 48,868.79 101,780.50 (17,617.85) (28,275.40) Benefits 4,531.11 10,709.12 73,359.00 14.60% 7,396.25 16,178.13 (2,865.14) (5,469.01) Operations 11,681.18 83,368.51 315,998.00 26.38% 14,373.76 46,502.58 (2,692.58) 36,865.93 Capital Outlay ‐ ‐ ‐ 0.00%‐ 20,000.00 ‐ (20,000.00) COVID‐19 ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 47,463.23 167,582.73 835,447.00 20.06% 70,638.80 184,461.21 (23,175.57) (16,878.48) Legislative Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 8,958.70 29,793.80 125,000.00 23.84% 10,417.04 31,251.12 (1,458.34) (1,457.32) Benefits 626.20 2,072.87 10,474.00 19.79% 693.16 2,288.27 (66.96) (215.40) Operations ‐ 443.15 30,100.00 1.47% 440.50 856.32 (440.50) (413.17) Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 9,584.90 32,309.82 165,574.00 19.51% 11,550.70 34,395.71 (1,965.80) (2,085.89) Finance Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 52,304.29 123,027.35 460,940.00 26.69% 49,613.42 101,079.92 2,690.87 21,947.43 Benefits 9,875.74 23,667.97 90,693.00 26.10% 8,918.46 20,021.05 957.28 3,646.92 Operations 8,511.39 21,719.05 238,055.00 9.12% 13,481.83 28,573.63 (4,970.44) (6,854.58) Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ COVID‐19 ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 70,691.42 168,414.37 789,688.00 21.33% 72,013.71 149,674.60 (1,322.29) 18,739.77 City Clerk Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 16,293.27 41,422.71 147,626.00 28.06% 14,962.52 32,326.79 1,330.75 9,095.92 Benefits 3,117.77 7,524.23 28,627.00 26.28% 2,729.52 5,976.50 388.25 1,547.73 Operations 6,130.84 28,558.53 140,640.00 20.31% 6,239.08 23,414.04 (108.24) 5,144.49 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 25,541.88 77,505.47 316,893.00 24.46% 23,931.12 61,717.33 1,610.76 15,788.14 HR Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 41,842.83 100,251.46 362,688.00 27.64% 35,971.84 75,836.84 5,870.99 24,414.62 Benefits 8,039.55 19,283.33 246,649.00 7.82% 6,755.08 15,085.21 1,284.47 4,198.12 Operations 7,554.50 20,928.71 197,600.00 10.59% 8,864.13 18,644.79 (1,309.63) 2,283.92 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 57,436.88 140,463.50 806,937.00 17.41% 51,591.05 109,566.84 5,845.83 30,896.66 IT Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 25,354.32 59,116.09 232,474.00 25.43% 26,589.20 57,997.44 (1,234.88) 1,118.65 Benefits 4,585.72 10,746.69 43,377.00 24.78% 4,582.94 10,524.15 2.78 222.54 Operations 294,678.16 493,688.66 2,038,494.00 24.22% 222,649.29 629,620.28 72,028.87 (135,931.62) Capital Outlay 20,868.00 20,868.00 ‐ 0.00% 7,272.00 61,973.00 13,596.00 (41,105.00) COVID‐19 ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 345,486.20 584,419.44 2,314,345.00 25.25% 261,093.43 760,114.87 84,392.77 (175,695.43) Vehicle Maint. Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 21,889.98 50,517.68 238,347.00 21.20% 26,807.86 56,399.81 (4,917.88) (5,882.13) Benefits 4,070.26 11,617.14 53,131.00 21.87% 4,698.20 13,934.88 (627.94) (2,317.74) Operations 2,798.77 15,090.13 97,050.00 15.55% 2,429.47 11,681.69 369.30 3,408.44 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 28,759.01 77,224.95 388,528.00 19.88% 33,935.53 82,016.38 (5,176.52) (4,791.43) City of Prattville December 2022 Unaudited Expenditures By Department Engineering Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 75,776.09 178,005.39 697,081.00 25.54% 66,289.17 135,926.04 9,486.92 42,079.35 Benefits 14,662.98 41,211.26 184,712.00 22.31% 12,270.24 33,524.63 2,392.74 7,686.63 Operations 38,145.21 197,021.75 1,315,053.00 14.98% 29,477.25 84,258.73 8,667.96 112,763.02 Capital Projects ‐ ‐ 0.00%‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ 445,000.00 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 128,584.28 416,238.40 2,641,846.00 15.76% 108,036.66 253,709.40 20,547.62 162,529.00 Planning Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 41,475.71 110,477.58 450,630.00 24.52% 49,155.78 103,069.47 (7,680.07) 7,408.11 Benefits 8,159.90 19,776.41 90,406.00 21.88% 9,208.41 20,766.56 (1,048.51) (990.15) Operations 13,544.34 31,337.79 249,000.00 12.59% 36,978.10 88,198.77 (23,433.76) (56,860.98) Capital Projects ‐ ‐ 0.00%‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 63,179.95 161,591.78 790,036.00 20.45% 95,342.29 212,034.80 (32,162.34) (50,443.02) Urban Management Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 129,273.87 305,010.60 1,151,880.00 26.48% 123,578.60 268,108.28 5,695.27 36,902.32 Benefits 23,777.92 64,624.04 257,288.00 25.12% 21,202.85 54,237.24 2,575.07 10,386.80 Operations 17,626.87 127,218.39 623,250.00 20.41% 35,492.38 117,665.66 (17,865.51) 9,552.73 Capital Outlay ‐ ‐ 50,000.00 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 170,678.66 496,853.03 2,082,418.00 23.86% 180,273.83 440,011.18 (9,595.17) 56,841.85 Facilities Maintenance Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 42,929.22 105,539.22 400,482.00 26.35% 44,866.57 94,786.22 (1,937.35) 10,753.00 Benefits 7,534.02 22,405.93 87,527.00 25.60% 7,626.64 18,547.57 (92.62) 3,858.36 Operations 1,268.20 48,018.52 261,500.00 18.36% 3,055.76 42,534.61 (1,787.56) 5,483.91 Capital Outlay ‐ ‐ 670,000.00 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 51,731.44 175,963.67 1,419,509.00 12.40% 55,548.97 155,868.40 (3,817.53) 20,095.27 Public Works Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 43,169.58 99,920.36 375,779.00 26.59% 40,901.48 84,727.21 2,268.10 15,193.15 Benefits 8,372.15 21,052.29 80,973.00 26.00% 7,552.42 18,394.42 819.73 2,657.87 Operations 22,281.01 90,777.98 255,968.00 35.46% 10,490.73 71,087.68 11,790.28 19,690.30 Capital Outlay 50,993.65 50,993.65 300,000.00 17.00%‐ ‐ 50,993.65 50,993.65 COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 124,816.39 262,744.28 1,012,720.00 25.94% 58,944.63 174,209.31 65,871.76 88,534.97 Police Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 691,819.80 1,599,652.36 6,654,061.00 24.04% 731,452.99 1,490,652.23 (39,633.19) 109,000.13 Benefits 127,731.83 342,961.92 1,460,253.00 23.49% 129,750.77 324,454.22 (2,018.94) 18,507.70 Operations 87,364.67 472,414.05 1,656,828.00 28.51% 68,113.56 419,742.74 19,251.11 52,671.31 Capital Outlay ‐ ‐ 549,367.00 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 906,916.30 2,415,028.33 10,320,509.00 23.40% 929,317.32 2,234,849.19 (22,401.02) 180,179.14 Fire Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 743,563.09 1,649,720.99 6,152,966.00 26.81% 702,635.75 1,387,141.33 40,927.34 262,579.66 Benefits 143,586.07 362,391.84 1,387,748.00 26.11% 130,244.18 330,296.56 13,341.89 32,095.28 Operations 49,170.10 250,826.93 1,237,156.00 20.27% 66,332.68 202,872.18 (17,162.58) 47,954.75 Capital Outlay ‐ ‐ 287,000.00 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 936,319.26 2,262,939.76 9,064,870.00 24.96% 899,212.61 1,920,310.07 37,106.65 342,629.69 Building Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 28,119.85 59,500.72 263,338.00 22.59% 30,903.54 66,278.58 (2,783.69) (6,777.86) Benefits 5,389.90 13,399.83 60,846.00 22.02% 5,761.38 14,537.82 (371.48) (1,137.99) Operations 497.59 10,099.58 62,450.00 16.17% 964.39 12,043.91 (466.80) (1,944.33) Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 34,007.34 83,000.13 386,634.00 21.47% 37,629.31 92,860.31 (3,621.97) (9,860.18) Parks & Recreation Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 136,933.99 343,429.51 1,238,226.00 27.74% 127,700.17 271,601.82 9,233.82 71,827.69 Benefits 24,123.74 66,400.35 254,964.00 26.04% 21,124.01 54,252.11 2,999.73 12,148.24 Operations 59,290.20 345,375.77 1,532,960.00 22.53% 47,278.42 193,709.84 12,011.78 151,665.93 Capital Outlay/ Capital Projects ‐ 24,997.50 1,513,617.00 1.65%‐ ‐ ‐ 24,997.50 COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 220,347.93 780,203.13 4,539,767.00 17.19% 196,102.60 519,563.77 24,245.33 260,639.36 Performing Arts Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 17,655.80 38,729.31 185,634.00 20.86% 19,620.08 36,970.95 (1,964.28) 1,758.36 Benefits 3,229.78 7,223.81 31,359.00 23.04% 3,425.73 6,774.38 (195.95) 449.43 Operations 11,396.76 44,783.73 305,000.00 14.68% 13,861.11 47,717.80 (2,464.35) (2,934.07) Capital Outlay ‐ ‐ 0.00%‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 32,282.34 90,736.85 521,993.00 17.38% 36,906.92 91,463.13 (4,624.58) (726.28) Non‐Departmental Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference City ‐ County Svcs 15,833.33 122,916.66 472,000.00 26.04%‐ 101,249.99 15,833.33 21,666.67 Community Initiatives 75,666.67 202,351.19 778,643.00 25.99% 58,100.93 603,249.84 17,565.74 (400,898.65) Unprocessed JP Morgan Payment 362,951.43 362,951.43 ‐ 100.00%‐ ‐ 362,951.43 362,951.43 Drug Proceeds Expenditures ‐ ‐ ‐ 100.00%‐ ‐ ‐ ‐ Transfer to DSF ‐ One Cent ‐ Infras ‐ 92,941.47 584,320.00 15.91%‐ 92,941.47 ‐ ‐ 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 840,000.00 3,360,000.00 25.00% 274,750.00 824,250.00 5,250.00 15,750.00 Transfer to Capital Project Fund 40,374.70 769,124.37 2,204,000.00 34.90%‐ ‐ 40,374.70 769,124.37 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 774,826.13 2,570,028.04 8,835,981.00 29.09% 332,850.93 1,745,002.50 441,975.20 1,001,500.85 Debt Service Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Debt Service 402,536.77 611,918.78 2,187,125.00 27.98% 118,770.25 186,311.05 283,766.52 425,607.73 Total 402,536.77 611,918.78 2,187,125.00 27.98% 118,770.25 186,311.05 283,766.52 425,607.73 Total Dec‐22 YTD Budget % of Budget Dec‐21 YTD December Difference YTD Difference Salary 2,148,611.33 4,967,620.23 19,583,242.00 25.37% 2,150,334.80 4,395,934.55 (1,723.47) 571,685.68 Benefits 681,414.64 1,887,069.03 7,802,386.00 24.19% 658,690.24 1,784,043.70 22,724.40 103,025.33 Operations 1,126,765.92 3,739,014.88 14,464,907.00 25.85% 638,623.37 2,743,625.08 488,142.55 995,389.80 Capital Outlay 71,861.65 96,859.15 3,814,984.00 2.54% 7,272.00 81,973.00 64,589.65 14,886.15 Debt Service 402,536.77 1,061,078.48 3,755,301.00 28.26% 118,770.25 402,563.72 283,766.52 658,514.76 COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ Total 4,431,190.31 11,751,641.77 49,420,820.00 23.78% 3,573,690.66 9,408,140.05 857,499.65 2,343,501.72 % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 23.78% Prepared by Carlee Sims