Loading...
June 2023 - Council Expenditure ReportAs of 7/13/2023 75.00 % Year Complete Executive Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 44,130.64 251,971.96 446,090.00 56.48% 29,874.70 312,543.47 14,255.94 (60,571.51) Benefits 7,046.48 38,854.83 73,359.00 52.97% 4,867.41 48,865.78 2,179.07 (10,010.95) Operations 17,941.56 227,123.08 266,498.00 85.23% 14,183.08 121,837.97 3,758.48 105,285.11 Capital Outlay - 49,500.00 49,500.00 0.00% - 23,814.53 - 25,685.47 Total 69,118.68 567,449.87 835,447.00 67.92% 48,925.19 507,061.75 20,193.49 60,388.12 Legislative Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 10,417.04 88,438.46 125,000.00 70.75% 10,417.04 93,753.36 - (5,314.90) Benefits 850.53 6,561.06 10,474.00 62.64% 751.67 6,946.42 98.86 (385.36) Operations - 1,344.97 30,100.00 4.47% 914.25 6,594.00 (914.25) (5,249.03) Capital Outlay - - - 0.00% - - - - Total 11,267.57 96,344.49 165,574.00 58.19% 12,082.96 107,293.78 (815.39) (10,949.29) Finance Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 51,442.10 352,552.67 460,940.00 76.49% 32,808.28 302,362.66 18,633.82 50,190.01 Benefits 9,928.71 68,379.02 90,693.00 75.40% 6,219.74 58,299.44 3,708.97 10,079.58 Operations 28,419.19 198,302.73 238,055.00 83.30% 8,238.05 195,996.44 20,181.14 2,306.29 Capital Outlay - - - 0.00% - - - - Total 89,790.00 619,234.42 789,688.00 78.42% 47,266.07 556,658.54 42,523.93 62,575.88 City Clerk Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 16,441.69 117,041.84 170,626.00 68.60% 9,264.17 94,566.01 7,177.52 22,475.83 Benefits 3,182.19 21,582.20 30,457.72 70.86% 1,835.03 17,405.36 1,347.16 4,176.84 Operations 2,862.35 75,786.41 115,809.28 65.44% 24,129.26 88,749.16 (21,266.91) (12,962.75) Capital Outlay - - - 0.00% - - - - Total 22,486.23 214,410.45 316,893.00 67.66% 35,228.46 200,720.53 (12,742.23) 13,689.92 HR Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 38,570.07 278,497.24 362,688.00 76.79% 26,646.53 231,657.20 11,923.54 46,840.04 Benefits 138,779.11 185,276.81 246,649.00 75.12% 143,132.29 182,675.77 (4,353.18) 2,601.04 Operations 6,585.16 100,918.85 197,600.00 51.07% 9,206.10 56,404.07 (2,620.94) 44,514.78 Capital Outlay - - - 0.00% - - - - Total 183,934.34 564,692.90 806,937.00 69.98% 178,984.92 470,737.04 4,949.42 93,955.86 IT Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 25,881.19 172,441.41 232,474.00 74.18% 13,717.12 161,367.97 12,164.07 11,073.44 Benefits 4,717.20 31,712.16 43,377.00 73.11% 2,797.31 29,037.39 1,919.89 2,674.77 Operations 136,635.23 1,208,621.25 2,008,494.00 60.18% 125,358.08 1,610,542.76 11,277.15 (401,921.51) Capital Outlay - 50,863.00 30,000.00 0.00% - 121,598.00 - (70,735.00) Total 167,233.62 1,463,637.82 2,314,345.00 63.24% 141,872.51 1,922,546.12 25,361.11 (458,908.30) Vehicle Maint. Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 22,250.59 138,980.15 238,347.00 58.31% 8,986.59 151,764.46 13,264.00 (12,784.31) Benefits 4,162.55 33,015.89 53,131.00 62.14% 4,551.02 39,948.55 (388.47) (6,932.66) Operations 7,447.97 48,151.12 97,050.00 49.61% 2,637.95 34,455.11 4,810.02 13,696.01 Capital Outlay - - - 0.00% - - - - Total 33,861.11 220,147.16 388,528.00 56.66% 16,175.56 226,168.12 17,685.55 (6,020.96) City of Prattville June 2023 Unaudited Expenditures By Department Engineering Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 73,790.62 502,193.17 697,081.00 72.04% 47,660.44 409,460.18 26,130.18 92,732.99 Benefits 14,715.02 129,604.43 184,712.00 70.17% 15,202.43 111,539.70 (487.41) 18,064.73 Operations 85,726.76 819,497.65 1,315,053.00 62.32% 65,469.50 504,420.33 20,257.26 315,077.32 Capital Outlay - (3,328.37) 606,599.00 -0.55% - 89,172.60 - (92,500.97) Total 174,232.40 1,447,966.88 2,803,445.00 51.65% 128,332.37 1,114,592.81 45,900.03 333,374.07 Planning Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 27,045.57 272,893.31 450,630.00 60.56% 29,501.75 297,008.82 (2,456.18) (24,115.51) Benefits 5,663.80 51,979.86 90,406.00 57.50% 6,071.20 58,179.09 (407.40) (6,199.23) Operations 15,781.15 99,721.29 249,000.00 40.05% 16,505.99 107,790.00 (724.84) (8,068.71) Capital Outlay - - - 0.00% - - - - Total 48,490.52 424,594.46 790,036.00 53.74% 52,078.94 462,977.91 (3,588.42) (38,383.45) Urban Management Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 129,892.26 799,910.98 1,151,880.00 69.44% 77,090.29 750,371.14 52,801.97 49,539.84 Benefits 23,974.47 176,806.34 257,288.00 68.72% 21,520.97 175,036.70 2,453.50 1,769.64 Operations 52,687.05 461,674.40 623,250.00 74.08% 44,534.11 381,997.25 8,152.94 79,677.15 Capital Outlay - - 50,000.00 0.00% - 59,952.00 - (59,952.00) Total 206,553.78 1,438,391.72 2,082,418.00 69.07% 143,145.37 1,367,357.09 63,408.41 71,034.63 Facilities Maintenance Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 40,726.06 294,271.80 400,482.00 73.48% 21,778.05 262,881.06 18,948.01 31,390.74 Benefits 7,660.59 66,027.76 87,527.00 75.44% 8,282.41 64,757.77 (621.82) 1,269.99 Operations 39,285.70 428,254.09 261,500.00 163.77% 13,604.58 136,412.85 25,681.12 291,841.24 Capital Outlay - - 670,000.00 0.00% - - - - Total 87,672.35 788,553.65 1,419,509.00 55.55% 43,665.04 464,051.68 44,007.31 324,501.97 Public Works Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 38,074.84 268,866.41 375,779.00 71.55% 25,707.64 246,814.35 12,367.20 22,052.06 Benefits 7,484.78 57,851.17 80,973.00 71.45% 6,557.14 55,212.87 927.64 2,638.30 Operations 28,222.16 208,185.23 255,968.00 81.33% 55,238.35 230,875.75 (27,016.19) (22,690.52) Capital Outlay - 50,993.65 300,000.00 17.00% - - - 50,993.65 Total 73,781.78 585,896.46 1,012,720.00 57.85% 87,503.13 532,902.97 (13,721.35) 52,993.49 Police Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 621,683.31 4,425,360.95 6,654,061.00 66.51% 390,104.67 4,203,028.89 231,578.64 222,332.06 Benefits 121,815.51 993,083.32 1,460,253.00 68.01% 119,980.02 1,001,728.14 1,835.49 (8,644.82) Operations 108,817.26 1,372,246.52 1,656,828.00 82.82% 248,628.86 1,372,124.77 (139,811.60) 121.75 Capital Outlay - 38,761.00 549,367.00 7.06% 48,262.96 474,026.80 (48,262.96) (435,265.80) Total 852,316.08 6,829,451.79 10,320,509.00 66.17% 806,976.51 7,050,908.60 45,339.57 (221,456.81) Fire Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 684,624.86 4,612,460.99 6,152,966.00 74.96% 392,947.04 3,937,892.78 291,677.82 674,568.21 Benefits 136,597.20 1,057,045.23 1,387,748.00 76.17% 122,518.96 988,866.48 14,078.24 68,178.75 Operations 66,839.70 797,649.24 1,227,789.00 64.97% 71,762.13 672,316.13 (4,922.43) 125,333.11 Capital Outlay - 96,822.00 508,134.00 19.05% - 759,922.14 - (663,100.14) Total 888,061.76 6,563,977.46 9,276,637.00 70.76% 587,228.13 6,358,997.53 300,833.63 204,979.93 Building Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 30,299.04 190,796.59 263,338.00 72.45% 17,175.21 186,415.96 13,123.83 4,380.63 Benefits 5,814.21 43,369.11 60,846.00 71.28% 5,302.09 44,302.89 512.12 (933.78) Operations 1,241.29 27,003.55 62,450.00 43.24% 1,565.68 24,522.17 (324.39) 2,481.38 Capital Outlay - - - 0.00% - - - - Total 37,354.54 261,169.25 386,634.00 67.55% 24,042.98 255,241.02 13,311.56 5,928.23 Parks & Recreation Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 161,006.07 978,950.46 1,238,226.00 79.06% 106,535.12 828,013.64 54,470.95 150,936.82 Benefits 27,351.06 199,504.44 254,964.00 78.25% 24,485.81 178,491.77 2,865.25 21,012.67 Operations 153,829.34 1,274,760.67 1,487,050.50 85.72% 140,334.09 935,411.01 13,495.25 339,349.66 Capital Outlay/ Capital Projects 99,634.81 307,316.81 1,559,526.50 19.71% 35,000.00 199,234.00 64,634.81 108,082.81 Total 441,821.28 2,760,532.38 4,539,767.00 60.81% 306,355.02 2,141,150.42 135,466.26 619,381.96 Performing Arts Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 23,585.78 133,608.95 185,634.00 71.97% 10,713.31 104,500.52 12,872.47 29,108.43 Benefits 3,737.11 22,797.18 31,359.00 72.70% 1,772.82 18,642.10 1,964.29 4,155.08 Operations 23,627.40 203,160.77 305,000.00 66.61% 23,162.89 170,696.83 464.51 32,463.94 Capital Outlay - 27,400.00 27,400.00 0.00% - - - 27,400.00 Total 50,950.29 386,966.90 549,393.00 70.44% 35,649.02 293,839.45 15,301.27 93,127.45 Non-Departmental Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference City - County Svcs 15,416.67 352,916.68 472,000.00 74.77% 7,083.33 330,333.33 8,333.34 22,583.35 Community Initiatives 1,669,900.92 2,072,205.63 2,080,484.09 99.60% 25,954.17 894,838.54 1,643,946.75 1,177,367.09 Unprocessed JP Morgan Payment - - - 100.00% - - - - Drug Proceeds Expenditures - - - 100.00% 4,766.50 41,683.00 (4,766.50) (41,683.00) Transfer to DSF - One Cent - Infras (35,077.91) 468,238.53 584,320.00 80.13% 26,990.00 427,611.79 (62,067.91) 40,626.74 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,520,000.00 3,360,000.00 75.00% 274,750.00 2,472,750.00 5,250.00 47,250.00 Transfer to Capital Project Fund 265,332.27 814,673.61 2,204,000.00 36.96% 330,920.00 2,679,034.00 (65,587.73) (1,864,360.39) 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 4,077.33 358,634.18 354,557.00 101.15% - 261,287.36 4,077.33 97,346.82 Total 2,199,649.28 9,070,524.36 10,137,822.09 89.47% 670,464.00 7,230,849.22 1,529,185.28 1,839,675.14 Debt Service Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Debt Service 289,238.29 1,859,939.02 2,187,125.00 85.04% 370,161.63 1,576,462.64 (80,923.34) 283,476.38 Total 289,238.29 1,859,939.02 2,187,125.00 85.04% 370,161.63 1,576,462.64 (80,923.34) 283,476.38 Total Jun-23 YTD Budget % of Budget Jun-22 YTD June Difference YTD Difference Salary 2,039,861.73 13,879,237.34 19,606,242.00 70.79% 1,250,927.95 12,574,402.47 788,933.78 1,304,834.87 Benefits 803,480.52 5,703,450.81 7,804,216.72 73.08% 770,598.32 5,552,686.22 32,882.20 150,764.59 Operations 2,730,676.46 12,650,831.92 15,607,140.87 81.06% 1,234,196.95 10,858,322.83 1,496,479.51 1,792,509.09 Capital Outlay 99,634.81 618,328.09 4,350,526.50 14.21% 83,262.96 1,727,720.07 16,371.85 (1,109,391.98) Debt Service 254,160.38 3,312,033.28 3,755,301.00 88.20% 397,151.63 2,127,385.63 (142,991.25) 1,184,647.65 Total 5,927,813.90 36,163,881.44 51,123,427.09 70.74% 3,736,137.81 32,840,517.22 2,191,676.09 3,323,364.22 % of Budget Expenditures 70.74% Prepared by Carlee Sims