Loading...
July 2023 - Council Expenditure Report - UpdatedAs of 8/11/2023 83.33 % Year Complete Executive Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 30,091.82 282,063.78 446,090.00 63.23% 48,977.25 361,520.72 (18,885.43) (79,456.94) Benefits 4,784.90 43,639.73 73,359.00 59.49% 7,432.82 56,298.60 (2,647.92) (12,658.87) Operations 23,640.76 250,763.84 266,498.00 94.10% 9,898.06 131,736.03 13,742.70 119,027.81 Capital Outlay - 49,500.00 49,500.00 0.00% - 23,814.53 - 25,685.47 Total 58,517.48 625,967.35 835,447.00 74.93% 66,308.13 573,369.88 (7,790.65) 52,597.47 Legislative Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 10,417.04 98,855.50 125,000.00 79.08% 10,416.70 104,170.06 0.34 (5,314.56) Benefits 731.24 7,292.30 10,474.00 69.62% 778.63 7,725.05 (47.39) (432.75) Operations 2,614.91 3,959.88 30,100.00 13.16% 690.05 7,284.05 1,924.86 (3,324.17) Capital Outlay - - - 0.00% - - - - Total 13,763.19 110,107.68 165,574.00 66.50% 11,885.38 119,179.16 1,877.81 (9,071.48) Finance Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 35,299.69 387,852.36 460,940.00 84.14% 50,166.95 352,529.61 (14,867.26) 35,322.75 Benefits 6,794.15 75,173.17 90,693.00 82.89% 9,059.40 67,358.84 (2,265.25) 7,814.33 Operations 14,482.89 212,785.62 238,055.00 89.39% 13,276.22 209,272.66 1,206.67 3,512.96 Capital Outlay - - - 0.00% - - - - Total 56,576.73 675,811.15 789,688.00 85.58% 72,502.57 629,161.11 (15,925.84) 46,650.04 City Clerk Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 6,898.54 123,940.38 170,626.00 72.64% 15,691.05 110,257.06 (8,792.51) 13,683.32 Benefits 2,285.11 23,867.31 30,457.72 78.36% 2,878.51 20,283.87 (593.40) 3,583.44 Operations 22,063.43 97,849.84 115,809.28 84.49% 9,504.64 98,253.80 12,558.79 (403.96) Capital Outlay - - - 0.00% - - - - Total 31,247.08 245,657.53 316,893.00 77.52% 28,074.20 228,794.73 3,172.88 16,862.80 HR Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 27,768.33 306,265.57 362,688.00 84.44% 39,423.79 271,080.99 (11,655.46) 35,184.58 Benefits 5,365.21 190,642.02 246,649.00 77.29% 99,515.13 282,190.90 (94,149.92) (91,548.88) Operations 6,536.38 107,455.23 197,600.00 54.38% 4,899.56 61,303.63 1,636.82 46,151.60 Capital Outlay - - - 0.00% - - - - Total 39,669.92 604,362.82 806,937.00 74.90% 143,838.48 614,575.52 (104,168.56) (10,212.70) IT Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 17,976.77 190,418.18 232,474.00 81.91% 24,857.37 186,225.34 (6,880.60) 4,192.84 Benefits 3,277.84 34,990.00 43,377.00 80.66% 4,301.60 33,338.99 (1,023.76) 1,651.01 Operations 80,438.45 1,289,059.70 2,008,494.00 64.18% 116,605.62 1,727,148.38 (36,167.17) (438,088.68) Capital Outlay - 50,863.00 30,000.00 0.00% - 121,598.00 - (70,735.00) Total 101,693.06 1,565,330.88 2,314,345.00 67.64% 145,764.59 2,068,310.71 (44,071.53) (502,979.83) Vehicle Maint. Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 13,271.24 152,251.39 238,347.00 63.88% 21,731.13 173,495.59 (8,459.89) (21,244.20) Benefits 3,514.50 36,530.39 53,131.00 68.76% 3,843.84 43,792.39 (329.34) (7,262.00) Operations 3,870.11 52,021.23 97,050.00 53.60% 9,887.09 44,342.20 (6,016.98) 7,679.03 Capital Outlay - - - 0.00% 31,262.82 31,262.82 (31,262.82) (31,262.82) Total 20,655.85 240,803.01 388,528.00 61.98% 66,724.88 292,893.00 (46,069.03) (52,089.99) City of Prattville July 2023 Unaudited Expenditures By Department Engineering Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 50,889.87 553,083.04 697,081.00 79.34% 73,154.51 482,614.69 (22,264.64) 70,468.35 Benefits 13,611.00 143,215.43 184,712.00 77.53% 13,558.25 125,097.95 52.75 18,117.48 Operations 72,864.09 892,361.74 1,315,053.00 67.86% 91,555.09 595,975.42 (18,691.00) 296,386.32 Capital Outlay - (3,328.37) 606,599.00 -0.55% 1,500.00 90,672.60 (1,500.00) (94,000.97) Total 137,364.96 1,585,331.84 2,803,445.00 56.55% 179,767.85 1,294,360.66 (42,402.89) 290,971.18 Planning Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 27,031.93 299,925.24 450,630.00 66.56% 49,381.93 346,390.75 (22,350.00) (46,465.51) Benefits 5,325.42 57,305.28 90,406.00 63.39% 9,286.35 67,465.44 (3,960.93) (10,160.16) Operations 3,248.84 102,970.13 249,000.00 41.35% 11,879.19 119,669.19 (8,630.35) (16,699.06) Capital Outlay - - - 0.00% 15,136.00 15,136.00 (15,136.00) (15,136.00) Total 35,606.19 460,200.65 790,036.00 58.25% 85,683.47 548,661.38 (50,077.28) (88,460.73) Urban Management Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 90,112.30 890,023.28 1,151,880.00 77.27% 119,388.21 869,759.35 (29,275.91) 20,263.93 Benefits 20,549.78 197,356.12 257,288.00 76.71% 20,487.14 195,523.84 62.64 1,832.28 Operations 64,160.46 525,834.86 623,250.00 84.37% 57,399.80 439,397.05 6,760.66 86,437.81 Capital Outlay - - 199,534.90 0.00% 29,858.80 89,810.80 (29,858.80) (89,810.80) Total 174,822.54 1,613,214.26 2,231,952.90 72.28% 227,133.95 1,594,491.04 (52,311.41) 18,723.22 Facilities Maintenance Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 30,161.85 324,433.65 400,482.00 81.01% 39,930.72 302,811.78 (9,768.87) 21,621.87 Benefits 7,783.88 73,811.64 87,527.00 84.33% 6,663.70 71,421.47 1,120.18 2,390.17 Operations 20,844.57 449,098.66 261,500.00 171.74% 27,458.51 163,871.36 (6,613.94) 285,227.30 Capital Outlay 297,602.14 297,602.14 670,000.00 44.42% - - 297,602.14 297,602.14 Total 356,392.44 1,144,946.09 1,419,509.00 80.66% 74,052.93 538,104.61 282,339.51 606,841.48 Public Works Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 25,621.48 294,487.89 375,779.00 78.37% 41,297.38 288,111.73 (15,675.90) 6,376.16 Benefits 5,928.70 63,779.87 80,973.00 78.77% 7,665.94 62,878.81 (1,737.24) 901.06 Operations 21,280.69 229,465.92 255,968.00 89.65% 8,125.80 239,001.55 13,154.89 (9,535.63) Capital Outlay 13,180.00 64,173.65 300,000.00 21.39% - - 13,180.00 64,173.65 Total 66,010.87 651,907.33 1,012,720.00 64.37% 57,089.12 589,992.09 8,921.75 61,915.24 Police Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 427,877.20 4,853,238.15 6,654,061.00 72.94% 643,209.24 4,846,238.13 (215,332.04) 7,000.02 Benefits 108,607.79 1,101,691.11 1,460,253.00 75.45% 114,083.02 1,115,811.16 (5,475.23) (14,120.05) Operations 115,462.03 1,487,708.55 1,744,179.20 85.30% 169,652.09 1,541,776.86 (54,190.06) (54,068.31) Capital Outlay - 38,761.00 549,367.00 7.06% - 474,026.80 - (435,265.80) Total 651,947.02 7,481,398.81 10,407,860.20 71.88% 926,944.35 7,977,852.95 (274,997.33) (496,454.14) Fire Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 458,163.38 5,070,624.37 6,152,966.00 82.41% 635,619.31 4,573,512.09 (177,455.93) 497,112.28 Benefits 116,123.31 1,173,168.54 1,387,748.00 84.54% 118,268.69 1,107,135.17 (2,145.38) 66,033.37 Operations 128,356.22 926,005.46 1,227,789.00 75.42% 124,217.78 796,533.91 4,138.44 129,471.55 Capital Outlay 298,421.00 395,243.00 508,134.00 77.78% - 759,922.14 298,421.00 (364,679.14) Total 1,001,063.91 7,565,041.37 9,276,637.00 81.55% 878,105.78 7,237,103.31 122,958.13 327,938.06 Building Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 20,304.96 211,101.55 263,338.00 80.16% 31,270.75 217,686.71 (10,965.79) (6,585.16) Benefits 4,732.21 48,101.32 60,846.00 79.05% 5,829.54 50,132.43 (1,097.33) (2,031.11) Operations 2,616.68 29,620.23 62,450.00 47.43% 3,065.59 27,587.76 (448.91) 2,032.47 Capital Outlay - - - 0.00% - - - - Total 27,653.85 288,823.10 386,634.00 74.70% 40,165.88 295,406.90 (12,512.03) (6,583.80) Parks & Recreation Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 109,578.82 1,088,529.28 1,238,226.00 87.91% 180,458.80 1,008,472.44 (70,879.98) 80,056.84 Benefits 22,038.49 221,542.93 254,964.00 86.89% 25,987.27 204,479.04 (3,948.78) 17,063.89 Operations 139,708.63 1,414,469.30 1,487,050.50 95.12% 113,006.64 1,048,417.65 26,701.99 366,051.65 Capital Outlay/ Capital Projects - 307,316.81 1,559,526.50 19.71% 20,339.64 219,573.64 (20,339.64) 87,743.17 Total 271,325.94 3,031,858.32 4,539,767.00 66.78% 339,792.35 2,480,942.77 (68,466.41) 550,915.55 Performing Arts Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 16,427.60 150,036.55 185,634.00 80.82% 19,135.22 123,635.74 (2,707.62) 26,400.81 Benefits 2,594.26 25,391.44 31,359.00 80.97% 2,974.67 21,616.77 (380.41) 3,774.67 Operations 31,690.62 234,851.39 305,000.00 77.00% 25,635.90 196,332.73 6,054.72 38,518.66 Capital Outlay - 27,400.00 27,400.00 0.00% - - - 27,400.00 Total 50,712.48 437,679.38 549,393.00 79.67% 47,745.79 341,585.24 2,966.69 96,094.14 Non-Departmental Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference City - County Svcs 99,166.66 452,083.34 472,000.00 95.78% 87,083.33 417,416.66 12,083.33 34,666.68 Community Initiatives 126,229.92 2,198,435.55 2,080,484.09 105.67% 16,666.67 911,505.21 109,563.25 1,286,930.34 Unprocessed JP Morgan Payment 200,662.29 - - 100.00% - - 200,662.29 - Drug Proceeds Expenditures 12,411.45 12,411.45 - 100.00% - 41,683.00 12,411.45 (29,271.55) Transfer to DSF - One Cent - Infras 92,941.47 561,180.00 584,320.00 96.04% 92,941.47 520,553.26 - 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,800,000.00 3,360,000.00 83.33% 274,750.00 2,747,500.00 5,250.00 52,500.00 Transfer to Capital Project Fund 569,615.49 1,384,289.10 2,204,000.00 62.81% 28,445.95 2,707,479.95 541,169.54 (1,323,190.85) 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 - 358,634.18 354,557.00 101.15% - 261,287.36 - 97,346.82 Total 1,381,027.28 10,250,889.35 10,137,822.09 101.12% 499,887.42 7,730,736.64 881,139.86 2,520,152.71 Debt Service Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Debt Service 185,076.87 2,045,015.89 2,187,125.00 93.50% 172,866.51 1,749,329.15 12,210.36 295,686.74 Total 185,076.87 2,045,015.89 2,187,125.00 93.50% 172,866.51 1,749,329.15 12,210.36 295,686.74 Total Jul-23 YTD Budget % of Budget Jul-22 YTD July Difference YTD Difference Salary 1,397,892.82 15,277,130.16 19,606,242.00 77.92% 2,044,110.31 14,618,512.78 (646,217.49) 658,617.38 Benefits 614,047.79 6,317,498.60 7,804,216.72 80.95% 727,364.50 6,280,050.72 (113,316.71) 37,447.88 Operations 1,761,965.57 14,212,135.20 15,694,492.07 90.55% 928,953.58 11,787,276.41 833,011.99 2,424,858.79 Capital Outlay 609,203.14 1,227,531.23 4,500,061.40 27.28% 98,097.26 1,825,817.33 511,105.88 (598,286.10) Debt Service 278,018.34 3,590,051.62 3,755,301.00 95.60% 265,807.98 2,393,193.61 12,210.36 1,196,858.01 Total 4,661,127.66 40,624,346.81 51,360,313.19 79.10% 4,064,333.63 36,904,850.85 596,794.03 3,719,495.96 % of Budget Expenditures 79.10% Prepared by Daniel Oakley