Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
November 2022 - Council Expenditure Report
As of 12/18/2022 16.67 % Year Complete Executive Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 21,841.05 42,254.16 446,090.00 9.47% 35,233.02 52,911.71 (13,391.97) (10,657.55) Benefits 3,053.40 6,178.01 73,359.00 8.42% 5,122.10 8,781.88 (2,068.70) (2,603.87) Operations 57,987.03 71,687.33 315,998.00 22.69% 8,332.91 32,128.82 49,654.12 39,558.51 Capital Outlay ‐ ‐ ‐ 0.00% ‐ 20,000.00 ‐ (20,000.00) COVID‐19 ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 82,881.48 120,119.50 835,447.00 14.38% 48,688.03 113,822.41 34,193.45 6,297.09 Legislative Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 10,417.04 20,835.10 125,000.00 16.67% 10,417.04 20,834.08 ‐ 1.02 Benefits 692.30 1,446.67 10,474.00 13.81% 779.52 1,595.11 (87.22) (148.44) Operations 443.15 443.15 30,100.00 1.47% ‐ 415.82 443.15 27.33 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 11,552.49 22,724.92 165,574.00 13.72% 11,196.56 22,845.01 355.93 (120.09) Finance Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 36,553.44 70,723.06 460,940.00 15.34% 33,389.67 51,466.50 3,163.77 19,256.56 Benefits 6,660.26 13,792.23 90,693.00 15.21% 5,937.28 11,102.59 722.98 2,689.64 Operations 1,342.02 13,207.66 238,055.00 5.55% 7,506.46 15,091.80 (6,164.44) (1,884.14) Capital Outlay ‐ ‐ 0.00% ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 44,555.72 97,722.95 789,688.00 12.37% 46,833.41 77,660.89 (2,277.69) 20,062.06 City Clerk Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 14,078.56 25,129.44 147,626.00 17.02% 12,107.43 17,364.27 1,971.13 7,765.17 Benefits 2,277.81 4,406.46 28,627.00 15.39% 2,020.30 3,246.98 257.51 1,159.48 Operations 9,386.96 22,427.69 140,640.00 15.95% 7,094.01 17,174.96 2,292.95 5,252.73 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 25,743.33 51,963.59 316,893.00 16.40% 21,221.74 37,786.21 4,521.59 14,177.38 HR Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 30,985.47 58,408.63 362,688.00 16.10% 27,525.14 39,865.00 3,460.33 18,543.63 Benefits 5,585.89 11,243.78 246,649.00 4.56% 4,463.02 8,330.13 1,122.87 2,913.65 Operations 11,766.76 13,374.21 197,600.00 6.77% 6,166.31 9,780.66 5,600.45 3,593.55 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 48,338.12 83,026.62 806,937.00 10.29% 38,154.47 57,975.79 10,183.65 25,050.83 IT Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 17,059.29 33,761.77 232,474.00 14.52% 21,236.04 31,408.24 (4,176.75) 2,353.53 Benefits 3,050.80 6,160.97 43,377.00 14.20% 3,294.62 5,941.21 (243.82) 219.76 Operations 51,462.97 199,010.50 2,038,494.00 9.76% 125,655.51 406,970.99 (74,192.54) (207,960.49) Capital Outlay ‐ ‐ ‐ 0.00% 54,701.00 54,701.00 (54,701.00) (54,701.00) COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 71,573.06 238,933.24 2,314,345.00 10.32% 204,887.17 499,021.44 (133,314.11) (260,088.20) City of Prattville November 2022 Unaudited Expenditures By Department Vehicle Maint. Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 14,419.06 28,627.70 238,347.00 12.01% 19,846.90 29,591.95 (5,427.84) (964.25) Benefits 2,651.81 7,546.88 53,131.00 14.20% 3,255.55 9,236.68 (603.74) (1,689.80) Operations 6,131.77 12,291.36 97,050.00 12.66% 4,285.62 9,252.22 1,846.15 3,039.14 Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 23,202.64 48,465.94 388,528.00 12.47% 27,388.07 48,080.85 (4,185.43) 385.09 Engineering Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 53,200.11 102,229.30 697,081.00 14.67% 45,487.58 69,636.87 7,712.53 32,592.43 Benefits 9,897.87 26,548.28 184,712.00 14.37% 8,337.10 21,254.39 1,560.77 5,293.89 Operations 82,629.43 158,876.54 1,315,053.00 12.08% 21,763.12 54,781.48 60,866.31 104,095.06 Capital Projects ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ 445,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 145,727.41 287,654.12 2,641,846.00 10.89% 75,587.80 145,672.74 70,139.61 141,981.38 Planning Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 29,169.22 69,001.87 450,630.00 15.31% 36,069.89 53,913.69 (6,900.67) 15,088.18 Benefits 5,440.81 11,616.51 90,406.00 12.85% 6,370.60 11,558.15 (929.79) 58.36 Operations 6,597.12 17,793.45 249,000.00 7.15% 41,197.16 51,220.67 (34,600.04) (33,427.22) Capital Projects ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 41,207.15 98,411.83 790,036.00 12.46% 83,637.65 116,692.51 (42,430.50) (18,280.68) Urban Management Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 92,525.75 175,736.73 1,151,880.00 15.26% 83,833.25 144,529.68 8,692.50 31,207.05 Benefits 16,008.13 40,846.12 257,288.00 15.88% 13,774.16 33,034.39 2,233.97 7,811.73 Operations 74,812.35 109,591.52 623,250.00 17.58% 38,225.54 82,173.28 36,586.81 27,418.24 Capital Outlay ‐ ‐ 50,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 183,346.23 326,174.37 2,082,418.00 15.66% 135,832.95 259,737.35 47,513.28 66,437.02 Facilities Maintenance Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 34,123.70 62,610.00 400,482.00 15.63% 33,820.48 49,919.65 303.22 12,690.35 Benefits 5,532.21 14,871.91 87,527.00 16.99% 5,331.54 10,920.93 200.67 3,950.98 Operations 42,237.21 46,750.32 261,500.00 17.88% 7,997.40 39,478.85 34,239.81 7,271.47 Capital Outlay ‐ ‐ 670,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 81,893.12 124,232.23 1,419,509.00 8.75% 47,149.42 100,319.43 34,743.70 23,912.80 Public Works Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 28,721.99 56,750.78 375,779.00 15.10% 29,011.33 43,825.73 (289.34) 12,925.05 Benefits 5,509.12 12,680.14 80,973.00 15.66% 5,152.97 10,842.00 356.15 1,838.14 Operations 29,906.31 68,496.97 255,968.00 26.76% 39,983.68 60,596.95 (10,077.37) 7,900.02 Capital Outlay ‐ ‐ 300,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 64,137.42 137,927.89 1,012,720.00 13.62% 74,147.98 115,264.68 (10,010.56) 22,663.21 Police Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 486,485.92 907,832.56 6,654,061.00 13.64% 501,911.59 759,199.24 (15,425.67) 148,633.32 Benefits 84,807.27 215,230.09 1,460,253.00 14.74% 83,940.84 194,703.45 866.43 20,526.64 Operations 290,297.61 385,049.38 1,656,828.00 23.24% 135,171.48 351,629.18 155,126.13 33,420.20 Capital Outlay ‐ ‐ 549,367.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 861,590.80 1,508,112.03 10,320,509.00 14.61% 721,023.91 1,305,531.87 140,566.89 202,580.16 Fire Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 481,557.62 906,157.90 6,152,966.00 14.73% 454,020.95 684,505.58 27,536.67 221,652.32 Benefits 88,619.49 218,805.77 1,387,748.00 15.77% 80,942.38 200,052.38 7,677.11 18,753.39 Operations 145,600.19 201,656.83 1,237,156.00 16.30% 54,441.11 136,539.50 91,159.08 65,117.33 Capital Outlay ‐ ‐ 287,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 715,777.30 1,326,620.50 9,064,870.00 14.63% 589,404.44 1,021,097.46 126,372.86 305,523.04 Building Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 15,840.96 31,380.87 263,338.00 11.92% 24,106.40 35,375.04 (8,265.44) (3,994.17) Benefits 3,028.96 8,009.93 60,846.00 13.16% 4,060.49 8,776.44 (1,031.53) (766.51) Operations 7,248.53 9,601.99 62,450.00 15.38% 5,487.02 11,079.52 1,761.51 (1,477.53) Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 26,118.45 48,992.79 386,634.00 12.67% 33,653.91 55,231.00 (7,535.46) (6,238.21) Parks & Recreation Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 107,938.22 206,495.52 1,238,226.00 16.68% 98,619.84 143,901.65 9,318.38 62,593.87 Benefits 17,293.35 42,276.61 254,964.00 16.58% 15,218.92 33,128.10 2,074.43 9,148.51 Operations 157,754.99 286,085.57 1,532,960.00 18.66% 86,694.86 146,431.42 71,060.13 139,654.15 Capital Outlay/ Capital Projects 24,997.50 24,997.50 1,513,617.00 1.65% ‐ ‐ 24,997.50 24,997.50 COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 307,984.06 559,855.20 4,539,767.00 12.33% 200,533.62 323,461.17 107,450.44 236,394.03 Performing Arts Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 10,958.93 21,073.51 185,634.00 11.35% 10,519.76 17,350.87 439.17 3,722.64 Benefits 2,005.82 3,994.03 31,359.00 12.74% 1,757.26 3,348.65 248.56 645.38 Operations 17,118.75 33,386.97 305,000.00 10.95% 32,367.05 33,856.69 (15,248.30) (469.72) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 30,083.50 58,454.51 521,993.00 11.20% 44,644.07 54,556.21 (14,560.57) 3,898.30 Non‐Departmental Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference City ‐ County Svcs 91,250.00 107,083.33 472,000.00 22.69% 21,249.99 101,249.99 70,000.01 5,833.34 Community Initiatives 98,833.34 126,684.52 778,643.00 16.27% 520,714.90 545,148.91 (421,881.56) (418,464.39) Unprocessed JP Morgan Payment 186,476.12 186,476.12 ‐ 100.00% ‐ ‐ 186,476.12 186,476.12 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 560,000.00 3,360,000.00 16.67% 274,750.00 549,500.00 5,250.00 10,500.00 Transfer to Capital Project Fund 716,658.92 728,749.67 2,204,000.00 33.06% ‐ ‐ 716,658.92 728,749.67 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 1,373,218.38 2,158,153.34 8,835,981.00 24.42% 816,714.89 1,412,151.57 556,503.49 746,001.77 Debt Service Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Debt Service 43,584.50 209,382.01 2,187,125.00 9.57% 42,570.70 67,540.80 1,013.80 141,841.21 Total 43,584.50 209,382.01 2,187,125.00 9.57% 42,570.70 67,540.80 1,013.80 141,841.21 Total Nov‐22 YTD Budget % of Budget Nov‐21 YTD November Difference YTD Difference Salary 1,485,876.33 2,819,008.90 19,583,242.00 14.40% 1,477,156.31 2,245,599.75 8,720.02 573,409.15 Benefits 542,115.30 1,205,654.39 7,802,386.00 15.45% 524,508.65 1,125,353.46 17,606.65 80,300.93 Operations 2,085,941.53 2,798,725.08 14,464,907.00 19.35% 1,164,334.13 2,105,001.71 921,607.40 693,723.37 Capital Outlay 24,997.50 24,997.50 3,814,984.00 0.66% 54,701.00 74,701.00 (29,703.50) (49,703.50) Debt Service 43,584.50 658,541.71 3,755,301.00 17.54% 42,570.70 283,793.47 1,013.80 374,748.24 COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ Total 4,182,515.16 7,506,927.58 49,420,820.00 15.19% 3,263,270.79 5,834,449.39 919,244.37 1,672,478.19 % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 15.19% Prepared by Daniel Oakley