Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
May 2023 - Council Expenditure Report
As of 6/15/2023 66.67 % Year Complete Executive May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 30,091.82 207,841.32 446,090.00 46.59% 37,200.98 282,668.77 (7,109.16) (74,827.45) Benefits 4,664.92 31,808.35 73,359.00 43.36% 5,715.42 43,998.37 (1,050.50) (12,190.02) Operations 24,906.37 209,181.52 266,498.00 78.49% 13,921.17 107,654.89 10,985.20 101,526.63 Capital Outlay ‐ 49,500.00 49,500.00 0.00%‐ 23,814.53 ‐ 25,685.47 Total 59,663.11 498,331.19 835,447.00 59.65% 56,837.57 458,136.56 2,825.54 40,194.63 Legislative May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 10,417.04 78,021.42 125,000.00 62.42% 10,417.04 83,336.32 ‐ (5,314.90) Benefits 694.32 5,710.53 10,474.00 54.52% 778.64 6,194.75 (84.32) (484.22) Operations 614.02 1,344.97 30,100.00 4.47% 1,988.84 5,679.75 (1,374.82) (4,334.78) Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 11,725.38 85,076.92 165,574.00 51.38% 13,184.52 95,210.82 (1,459.14) (10,133.90) Finance May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 35,278.37 301,110.57 460,940.00 65.33% 33,415.45 269,554.38 1,862.92 31,556.19 Benefits 6,559.50 58,450.31 90,693.00 64.45% 6,001.19 52,079.70 558.31 6,370.61 Operations 57,225.68 169,883.54 238,055.00 71.36% 10,492.41 187,758.39 46,733.27 (17,874.85) Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 99,063.55 529,444.42 789,688.00 67.04% 49,909.05 509,392.47 49,154.50 20,051.95 City Clerk May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 13,484.10 100,600.15 170,626.00 58.96% 10,610.38 85,301.84 2,873.72 15,298.31 Benefits 2,249.17 18,400.01 30,457.72 60.41% 1,889.82 15,570.33 359.35 2,829.68 Operations 1,508.18 72,924.06 115,809.28 62.97% 10,058.21 64,619.90 (8,550.03) 8,304.16 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 17,241.45 191,924.22 316,893.00 60.56% 22,558.41 165,492.07 (5,316.96) 26,432.15 HR May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 27,737.13 239,927.17 362,688.00 66.15% 26,599.05 205,010.67 1,138.08 34,916.50 Benefits 5,297.01 46,497.70 246,649.00 18.85% 4,868.62 39,543.48 428.39 6,954.22 Operations 28,210.90 94,333.69 197,600.00 47.74% 1,270.01 47,197.97 26,940.89 47,135.72 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 61,245.04 380,758.56 806,937.00 47.19% 32,737.68 291,752.12 28,507.36 89,006.44 IT May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 17,325.67 146,560.22 232,474.00 63.04% 18,227.56 147,650.85 (901.89) (1,090.63) Benefits 3,102.98 26,994.96 43,377.00 62.23% 3,143.28 26,240.08 (40.30) 754.88 Operations 96,322.47 1,071,986.02 2,008,494.00 53.37% 285,436.90 1,485,184.68 (189,114.43) (413,198.66) Capital Outlay ‐ 50,863.00 30,000.00 0.00% 59,625.00 121,598.00 (59,625.00) (70,735.00) Total 116,751.12 1,296,404.20 2,314,345.00 56.02% 366,432.74 1,780,673.61 (249,681.62) (484,269.41) Vehicle Maint. May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 14,505.97 116,729.56 238,347.00 48.97% 17,134.73 142,777.90 (2,628.76) (26,048.34) Benefits 2,673.42 28,853.34 53,131.00 54.31% 3,002.70 35,397.53 (329.28) (6,544.19) Operations 4,540.95 40,703.15 97,050.00 41.94% 3,769.94 31,817.16 771.01 8,885.99 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 21,720.34 186,286.05 388,528.00 47.95% 23,907.37 209,992.59 (2,187.03) (23,706.54) City of Prattville May 2023 Unaudited Expenditures By Department Engineering May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 50,387.49 428,402.55 697,081.00 61.46% 46,960.46 361,799.74 3,427.03 66,602.81 Benefits 9,675.73 114,889.41 184,712.00 62.20% 8,672.14 96,337.27 1,003.59 18,552.14 Operations 85,338.92 733,770.89 1,315,053.00 55.80% 34,950.84 438,950.83 50,388.08 294,820.06 Capital Outlay (3,916.32) (3,328.37) 521,850.00 ‐0.64%‐ 89,172.60 (3,916.32) (92,500.97) Total 141,485.82 1,273,734.48 2,718,696.00 46.85% 90,583.44 986,260.44 50,902.38 287,474.04 Planning May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 24,500.42 245,847.74 450,630.00 54.56% 33,014.96 267,507.07 (8,514.54) (21,659.33) Benefits 4,299.44 46,316.06 90,406.00 51.23% 6,187.17 52,107.89 (1,887.73) (5,791.83) Operations 17,892.73 83,940.14 249,000.00 33.71% 27,469.27 91,284.01 (9,576.54) (7,343.87) Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 46,692.59 376,103.94 790,036.00 47.61% 66,671.40 410,898.97 (19,978.81) (34,795.03) Urban Management May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 85,843.86 670,018.72 1,151,880.00 58.17% 81,572.15 673,280.85 4,271.71 (3,262.13) Benefits 15,418.75 152,831.87 257,288.00 59.40% 14,196.19 153,515.73 1,222.56 (683.86) Operations 51,914.82 408,987.35 623,250.00 65.62% 44,873.32 337,463.14 7,041.50 71,524.21 Capital Outlay ‐ ‐ 50,000.00 0.00% (10,378.25) 59,952.00 10,378.25 (59,952.00) Total 153,177.43 1,231,837.94 2,082,418.00 59.15% 130,263.41 1,224,211.72 22,914.02 7,626.22 Facilities Maintenance May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 29,824.65 253,545.74 400,482.00 63.31% 26,379.44 241,103.01 3,445.21 12,442.73 Benefits 5,201.72 58,367.17 87,527.00 66.68% 4,408.17 56,475.36 793.55 1,891.81 Operations 49,090.65 388,968.39 261,500.00 148.75% 12,273.99 122,808.27 36,816.66 266,160.12 Capital Outlay ‐ ‐ 670,000.00 0.00%‐ ‐ ‐ ‐ Total 84,117.02 700,881.30 1,419,509.00 49.37% 43,061.60 420,386.64 41,055.42 280,494.66 Public Works May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 25,134.27 230,791.57 375,779.00 61.42% 27,287.27 221,106.71 (2,153.00) 9,684.86 Benefits 4,845.30 50,366.39 80,973.00 62.20% 5,036.45 48,655.73 (191.15) 1,710.66 Operations 16,761.33 179,963.07 255,968.00 70.31% 11,543.80 175,637.40 5,217.53 4,325.67 Capital Outlay ‐ 50,993.65 300,000.00 17.00%‐ ‐ ‐ 50,993.65 Total 46,740.90 512,114.68 1,012,720.00 50.57% 43,867.52 445,399.84 2,873.38 66,714.84 Police May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 444,285.31 3,803,677.64 6,654,061.00 57.16% 495,320.46 3,812,924.22 (51,035.15) (9,246.58) Benefits 80,981.64 871,267.81 1,460,253.00 59.67% 81,247.85 881,748.12 (266.21) (10,480.31) Operations 85,342.36 1,263,429.26 1,656,828.00 76.26% 83,193.46 1,123,495.91 2,148.90 139,933.35 Capital Outlay ‐ 38,761.00 549,367.00 7.06% 33,263.96 425,763.84 (33,263.96) (387,002.84) Total 610,609.31 5,977,135.71 10,320,509.00 57.92% 693,025.73 6,243,932.09 (82,416.42) (266,796.38) Fire May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 444,512.63 3,927,836.13 6,152,966.00 63.84% 413,537.15 3,544,945.74 30,975.48 382,890.39 Benefits 84,939.62 920,448.03 1,387,748.00 66.33% 73,572.34 866,347.52 11,367.28 54,100.51 Operations 71,376.89 730,809.54 1,227,789.00 59.52% 95,534.76 600,554.00 (24,157.87) 130,255.54 Capital Outlay 95,317.00 96,822.00 393,738.00 24.59% 541,145.33 759,922.14 (445,828.33) (663,100.14) Total 696,146.14 5,675,915.70 9,162,241.00 61.95% 1,123,789.58 5,771,769.40 (427,643.44) (95,853.70) Building May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 20,199.37 160,497.55 263,338.00 60.95% 20,687.51 169,240.75 (488.14) (8,743.20) Benefits 3,808.35 37,554.90 60,846.00 61.72% 3,813.67 39,000.80 (5.32) (1,445.90) Operations 1,257.40 25,762.26 62,450.00 41.25% 4,358.32 22,956.49 (3,100.92) 2,805.77 Capital Outlay ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Total 25,265.12 223,814.71 386,634.00 57.89% 28,859.50 231,198.04 (3,594.38) (7,383.33) Parks & Recreation May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 105,982.12 817,944.39 1,238,226.00 66.06% 107,038.29 721,478.52 (1,056.17) 96,465.87 Benefits 18,093.13 172,153.38 254,964.00 67.52% 17,195.96 154,005.96 897.17 18,147.42 Operations 210,193.95 1,120,931.33 1,487,050.50 75.38% 136,905.56 795,076.92 73,288.39 325,854.41 Capital Outlay/ Capital Projects 43,158.00 207,682.00 1,559,526.50 13.32% 164,234.00 164,234.00 (121,076.00) 43,448.00 Total 377,427.20 2,318,711.10 4,539,767.00 51.08% 425,373.81 1,834,795.40 (47,946.61) 483,915.70 Performing Arts May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 21,936.22 110,023.17 185,634.00 59.27% 8,753.73 93,787.21 13,182.49 16,235.96 Benefits 2,674.97 19,060.07 31,359.00 60.78% 1,518.88 16,869.28 1,156.09 2,190.79 Operations 19,518.80 179,533.37 305,000.00 58.86% 10,559.81 147,533.94 8,958.99 31,999.43 Capital Outlay ‐ 27,400.00 27,400.00 0.00%‐ ‐ ‐ 27,400.00 Total 44,129.99 336,016.61 549,393.00 61.16% 20,832.42 258,190.43 23,297.57 77,826.18 Non‐Departmental May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference City ‐ County Svcs 7,916.67 337,500.01 472,000.00 71.50% 7,083.33 323,250.00 833.34 14,250.01 Community Initiatives 26,666.67 402,304.71 2,059,484.09 19.53% 36,676.27 868,884.37 (10,009.60) (466,579.66) Unprocessed JP Morgan Payment ‐ ‐ ‐ 100.00%‐ ‐ ‐ ‐ Drug Proceeds Expenditures ‐ ‐ ‐ 100.00%‐ 36,916.50 ‐ (36,916.50) Transfer to DSF ‐ One Cent ‐ Infras ‐ 503,316.44 584,320.00 86.14%‐ 400,621.79 ‐ 102,694.65 Transfer to DSF ‐ One Cent ‐ P&R ‐ 860,544.53 860,545.00 100.00%‐ ‐ ‐ 860,544.53 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 2,240,000.00 3,360,000.00 66.67% 274,750.00 2,198,000.00 5,250.00 42,000.00 Transfer to Capital Project Fund (1,456,765.71) 549,341.34 2,204,000.00 24.92% 113,776.00 2,348,114.00 (1,570,541.71) (1,798,772.66) Transfer to Wasewater Fund ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Transfer to Sanitation Fund ‐ ‐ ‐ 0.00%‐ ‐ ‐ ‐ Transfer to Gas Tax Fund ‐ 1,500,000.00 98,605.00 1521.22%‐ ‐ ‐ 1,500,000.00 Transfer to Judicial ‐ 354,556.85 354,557.00 100.00% 261,287.36 261,287.36 (261,287.36) 93,269.49 Total (1,142,182.37) 6,870,875.08 10,116,822.09 67.92% 693,572.96 6,560,385.22 (1,835,755.33) 310,489.86 Debt Service May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Debt Service 160,675.84 1,570,700.73 2,187,125.00 71.82% 154,471.11 1,206,301.01 6,204.73 364,399.72 Total 160,675.84 1,570,700.73 2,187,125.00 71.82% 154,471.11 1,206,301.01 6,204.73 364,399.72 Total May‐23 YTD Budget % of Budget May‐22 YTD May Difference YTD Difference Salary 1,401,446.44 11,839,375.61 19,606,242.00 60.39% 1,414,156.61 11,323,474.55 (12,710.17) 515,901.06 Benefits 535,179.97 4,899,970.29 7,804,216.72 62.79% 515,998.49 4,782,087.90 19,181.48 117,882.39 Operations (600,165.95) 9,920,155.46 15,586,140.87 63.65% 1,207,423.57 9,624,125.88 (1,807,589.52) 296,029.58 Capital Outlay 134,558.68 518,693.28 4,151,381.50 12.49% 787,890.04 1,644,457.11 (653,331.36) (1,125,763.83) Debt Service 160,675.84 3,057,872.90 3,755,301.00 81.43% 154,471.11 1,730,234.00 6,204.73 1,327,638.90 Total 1,631,694.98 30,236,067.54 50,903,282.09 59.40% 4,079,939.82 29,104,379.44 (2,448,244.84) 1,131,688.10 % of Budget Expenditures 59.40% Prepared by Carlee Sims