Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
June 2022 - Council Expenditure Report
As of 7/15/2022 75.00 % Year Complete Executive Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 29,874.70 312,543.47 422,665.00 73.95% 22,546.12 208,639.82 7,328.58 103,903.65 Benefits 4,867.41 48,865.78 65,858.00 74.20% 3,154.38 28,845.16 1,713.03 20,020.62 Operations 14,183.08 121,837.97 294,213.00 41.41% 14,833.56 112,899.38 (650.48) 8,938.59 Capital Outlay ‐ 23,814.53 ‐ 100.00% 48,364.25 48,364.25 (48,364.25) (24,549.72) COVID‐19 ‐ ‐ ‐ ‐ ‐ 2,740.93 ‐ (2,740.93) Total 48,925.19 507,061.75 782,736.00 64.78% 88,898.31 401,489.54 (39,973.12) 105,572.21 Legislative Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 10,417.04 93,753.36 125,000.00 75.00% 10,417.04 94,365.01 ‐ (611.65) Benefits 751.67 6,946.42 10,323.00 67.29% 768.48 7,232.87 (16.81) (286.45) Operations 914.25 6,594.00 30,400.00 21.69% 691.53 2,435.30 222.72 4,158.70 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 12,082.96 107,293.78 165,723.00 64.74% 11,877.05 104,033.18 205.91 3,260.60 Finance Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 32,808.28 302,362.66 439,849.00 68.74% 25,931.47 251,761.16 6,876.81 50,601.50 Benefits 6,219.74 58,299.44 82,083.00 71.02% 4,608.98 44,329.65 1,610.76 13,969.79 Operations 8,238.05 195,996.44 252,820.00 77.52% 6,738.02 265,779.25 1,500.03 (69,782.81) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 47,266.07 556,658.54 774,752.00 71.85% 37,278.47 561,870.06 9,987.60 (5,211.52) City Clerk Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 9,264.17 94,566.01 124,042.00 76.24% 9,972.28 114,127.63 (708.11) (19,561.62) Benefits 1,835.03 17,405.36 24,410.00 71.30% 1,715.02 15,070.37 120.01 2,334.99 Operations 24,129.26 88,749.16 80,170.00 110.70% 1,758.34 29,388.44 22,370.92 59,360.72 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 19.95 ‐ (19.95) Total 35,228.46 200,720.53 228,622.00 87.80% 13,445.64 158,606.39 21,782.82 42,114.14 HR Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 26,646.53 231,657.20 343,172.00 67.50% 24,594.01 241,969.49 2,052.52 (10,312.29) Benefits 143,132.29 182,675.77 292,723.00 62.41% 4,533.40 43,784.69 138,598.89 138,891.08 Operations 9,206.10 56,404.07 87,858.00 64.20% 8,346.46 38,702.82 859.64 17,701.25 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 927.82 ‐ (927.82) Total 178,984.92 470,737.04 723,753.00 65.04% 37,473.87 325,384.82 141,511.05 145,352.22 IT Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 13,717.12 161,367.97 218,147.00 73.97% 18,051.79 163,982.45 (4,334.67) (2,614.48) Benefits 2,797.31 29,037.39 38,636.00 75.16% 3,066.86 27,517.86 (269.55) 1,519.53 Operations 125,358.08 1,610,542.76 1,721,197.00 93.57% 135,970.71 1,482,012.44 (10,612.63) 128,530.32 Capital Outlay ‐ 121,598.00 215,000.00 56.56% ‐ 20,855.13 ‐ 100,742.87 COVID‐19 ‐ ‐ ‐ ‐ 135,787.53 ‐ (135,787.53) Total 141,872.51 1,922,546.12 2,192,980.00 87.67% 157,089.36 1,830,155.41 (15,216.85) 92,390.71 Vehicle Maint. Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 8,986.56 151,764.46 234,957.00 64.59% 17,161.68 166,836.33 (8,175.12) (15,071.87) Benefits 4,551.02 39,948.55 48,849.00 81.78% 4,362.59 38,144.66 188.43 1,803.89 Operations 2,637.95 34,455.11 101,650.00 33.90% 3,173.30 46,895.69 (535.35) (12,440.58) Capital Outlay ‐ ‐ 40,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 16,175.53 226,168.12 425,456.00 53.16% 24,697.57 251,876.68 (8,522.04) (25,708.56) City of Prattville June 2022 Unaudited Expenditures By Department Engineering Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 47,660.44 409,460.18 619,777.00 66.07% 42,548.29 388,652.93 5,112.15 20,807.25 Benefits 15,202.43 111,539.70 138,019.00 80.81% 10,300.70 90,397.02 4,901.73 21,142.68 Operations 65,469.50 504,420.33 1,214,902.00 41.52% 49,900.97 259,257.69 15,568.53 245,162.64 Capital Projects ‐ ‐ ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ 89,172.60 100,000.00 89.17% ‐ ‐ ‐ 89,172.60 COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 128,332.37 1,114,592.81 2,072,698.00 53.77% 102,749.96 738,307.64 25,582.41 376,285.17 Planning Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 29,501.75 297,008.82 426,880.00 69.58% 31,547.69 298,532.13 (2,045.94) (1,523.31) Benefits 6,071.20 58,179.09 81,800.00 71.12% 5,835.09 54,942.30 236.11 3,236.79 Operations 16,505.99 107,790.00 323,450.00 33.33% 42,080.98 349,059.29 (25,574.99) (241,269.29) Capital Projects ‐ ‐ ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 3,630.48 ‐ (3,630.48) Total 52,078.94 462,977.91 832,130.00 55.64% 79,463.76 706,164.20 (27,384.82) (243,186.29) Urban Management Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 77,090.29 750,371.14 1,117,145.00 67.17% 71,098.77 726,994.97 5,991.52 23,376.17 Benefits 21,520.97 175,036.70 223,770.00 78.22% 15,866.48 151,605.25 5,654.49 23,431.45 Operations 44,534.11 381,997.25 560,500.00 68.15% 33,503.52 363,961.18 11,030.59 18,036.07 Capital Outlay ‐ 59,952.00 129,000.00 46.47% ‐ ‐ ‐ 59,952.00 COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 143,145.37 1,367,357.09 2,030,415.00 67.34% 120,468.77 1,242,561.40 22,676.60 124,795.69 Facilities Maintenance Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 21,778.05 262,881.06 397,866.00 66.07% 28,703.42 271,406.49 (6,925.37) (8,525.43) Benefits 8,282.41 64,757.77 81,396.00 79.56% 5,428.09 50,110.05 2,854.32 14,647.72 Operations 13,604.58 136,412.85 229,000.00 59.57% 16,603.74 121,954.96 (2,999.16) 14,457.89 Capital Outlay ‐ ‐ 455,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 66,244.23 ‐ (66,244.23) Total 43,665.04 464,051.68 1,163,262.00 39.89% 50,735.25 509,715.73 (7,070.21) (45,664.05) Public Works Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 25,707.64 246,814.35 355,055.00 69.51% 26,248.24 248,823.00 (540.60) (2,008.65) Benefits 6,557.14 55,212.87 71,937.00 76.75% 5,397.25 49,905.29 1,159.89 5,307.58 Operations 55,238.35 230,875.75 327,718.00 70.45% 11,006.39 154,459.71 44,231.96 76,416.04 Capital Outlay ‐ ‐ ‐ 9,600.00 229,912.00 (9,600.00) (229,912.00) COVID‐19 ‐ ‐ ‐ ‐ 695.55 ‐ (695.55) Total 87,503.13 532,902.97 754,710.00 70.61% 52,251.88 683,795.55 35,251.25 (150,892.58) Police Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 390,104.67 4,203,028.89 6,205,541.00 67.73% 384,535.59 3,749,078.91 5,569.08 453,949.98 Benefits 119,980.02 1,001,728.14 1,280,084.00 78.25% 86,712.83 802,539.03 33,267.19 199,189.11 Operations 248,628.86 1,372,124.77 2,089,530.00 65.67% 86,569.05 960,237.32 162,059.81 411,887.45 Capital Outlay 48,262.96 474,026.80 650,028.00 72.92% ‐ ‐ 48,262.96 474,026.80 COVID‐19 ‐ ‐ ‐ ‐ 54,437.46 ‐ (54,437.46) Total 806,976.51 7,050,908.60 10,225,183.00 68.96% 557,817.47 5,566,292.72 249,159.04 1,484,615.88 Fire Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 392,947.04 3,937,892.78 5,687,258.00 69.24% 410,295.95 3,844,507.37 (17,348.91) 93,385.41 Benefits 122,518.96 988,866.48 1,211,167.00 81.65% 97,966.97 881,724.95 24,551.99 107,141.53 Operations 71,762.13 672,316.13 1,500,762.00 44.80% 52,332.27 723,266.18 19,429.86 (50,950.05) Capital Outlay ‐ 759,922.14 987,765.00 76.93% ‐ 213,898.57 ‐ 546,023.57 COVID‐19 ‐ ‐ ‐ ‐ 60,379.92 ‐ (60,379.92) Total 587,228.13 6,358,997.53 9,386,952.00 67.74% 560,595.19 5,723,776.99 26,632.94 635,220.54 Building Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 17,175.21 186,415.96 267,629.00 69.65% 19,633.60 185,144.38 (2,458.39) 1,271.58 Benefits 5,302.09 44,302.89 56,692.00 78.15% 4,183.14 38,658.93 1,118.95 5,643.96 Operations 1,565.68 24,522.17 67,450.00 36.36% 1,513.60 23,319.62 52.08 1,202.55 Capital Outlay ‐ ‐ 26,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 24,042.98 255,241.02 417,771.00 61.10% 25,330.34 247,122.93 (1,287.36) 8,118.09 Parks & Recreation Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 106,535.12 828,013.64 1,132,797.00 73.09% 95,477.46 765,196.72 11,057.66 62,816.92 Benefits 24,485.81 178,491.77 216,697.00 82.37% 17,555.10 146,750.77 6,930.71 31,741.00 Operations 140,334.09 935,411.01 1,245,438.00 75.11% 121,467.97 872,975.30 18,866.12 62,435.71 Capital Outlay/ Capital Projects 35,000.00 199,234.00 1,702,054.00 11.71% ‐ 9,309.99 35,000.00 189,924.01 COVID‐19 ‐ ‐ ‐ ‐ 209.95 ‐ (209.95) Total 306,355.02 2,141,150.42 4,296,986.00 49.83% 234,500.53 1,794,442.73 71,854.49 346,707.69 Performing Arts Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 10,713.31 104,500.52 137,849.00 75.81% 10,411.85 90,204.99 301.46 14,295.53 Benefits 1,772.82 18,642.10 24,304.00 76.70% 1,667.60 14,348.51 105.22 4,293.59 Operations 23,162.89 170,696.83 254,820.00 66.99% 7,012.69 70,641.21 16,150.20 100,055.62 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 23.96 ‐ (23.96) Total 35,649.02 293,839.45 416,973.00 70.47% 19,092.14 175,218.67 16,556.88 118,620.78 Non‐Departmental Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference City ‐ County Svcs 7,083.33 330,333.33 432,000.00 76.47% 7,083.33 335,833.34 ‐ (5,500.01) Community Initiatives 25,954.17 894,838.54 1,240,839.00 72.12% 170,575.60 358,122.83 (144,621.43) 536,715.71 Unprocessed JP Morgan Payment ‐ ‐ ‐ 100.00% ‐ ‐ ‐ ‐ Drug Proceeds Expenditures 4,766.50 41,683.00 ‐ 100.00% ‐ 19,596.00 4,766.50 22,087.00 Transfer to DSF ‐ One Cent ‐ Infras 26,990.00 427,611.79 573,819.00 74.52% ‐ ‐ 26,990.00 427,611.79 Transfer to DSF ‐ Other ‐ 123,311.20 123,311.00 100.00% 24,130.00 465,725.61 (24,130.00) (342,414.41) Transfer to DSF ‐ One Cent (old) ‐ ‐ ‐ ‐ 8,710,709.10 ‐ ‐ Transfer to Group Health 274,750.00 2,472,750.00 3,297,000.00 75.00% 252,500.00 2,276,844.00 22,250.00 195,906.00 Transfer to Capital Project Fund 330,920.00 2,679,034.00 5,283,233.97 50.71% ‐ ‐ 330,920.00 2,679,034.00 Transfer to Wasewater Fund ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Sanitation Fund ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Gas Tax Fund ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Judicial ‐ 261,287.36 261,287.00 100.00% ‐ ‐ ‐ 261,287.36 Total 670,464.00 7,606,569.16 11,211,489.97 67.85% 454,288.93 12,166,830.88 216,175.07 3,774,727.44 Debt Service Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Debt Service 370,161.63 1,576,462.64 2,134,891.00 73.84% 109,050.33 1,387,000.95 261,111.30 189,461.69 Total 370,161.63 1,576,462.64 2,134,891.00 73.84% 109,050.33 1,387,000.95 261,111.30 189,461.69 Total Jun‐22 YTD Budget % of Budget Jun‐21 YTD June Difference YTD Difference Salary 1,250,927.92 12,574,402.47 18,255,629.00 68.88% 1,249,175.25 11,810,223.78 1,752.67 764,178.69 Benefits 770,598.32 5,552,686.22 7,245,748.00 76.63% 525,622.96 4,762,751.36 244,975.36 789,934.86 Operations 1,234,196.95 10,858,322.83 17,599,237.97 61.70% 771,162.03 6,590,797.95 463,034.92 4,267,524.88 Capital Outlay 83,262.96 1,727,720.07 4,304,847.00 40.13% 57,964.25 522,339.94 25,298.71 1,205,380.13 Debt Service 397,151.63 2,127,385.63 2,832,021.00 75.12% 133,180.33 10,563,435.66 263,971.30 (8,436,050.03) COVID‐19 ‐ ‐ ‐ ‐ ‐ 325,097.78 Total 3,736,137.78 32,840,517.22 50,237,482.97 65.37% 2,737,104.82 34,574,646.47 999,032.96 (1,409,031.47) % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 65.37% Prepared by Carlee Sims