Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
August 2022 - Council Expenditure Report
As of 9/18/2022 91.67 % Year Complete Executive Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 32,651.50 394,172.22 422,665.00 93.26% 29,011.68 289,519.27 3,639.82 104,652.95 Benefits 4,879.82 61,178.42 65,858.00 92.89% 4,212.44 39,336.18 667.38 21,842.24 Operations 25,637.71 157,373.74 294,213.00 53.49% 8,744.00 149,835.61 16,893.71 7,538.13 Capital Outlay 21,600.00 45,414.53 43,200.00 105.13% ‐ 48,364.25 21,600.00 (2,949.72) COVID‐19 ‐ ‐ ‐ ‐ ‐ 2,740.93 ‐ (2,740.93) Total 84,769.03 658,138.91 825,936.00 79.68% 41,968.12 529,796.24 42,800.91 128,342.67 Legislative Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 10,416.70 114,586.76 125,000.00 91.67% 10,417.04 115,199.09 (0.34) (612.33) Benefits 692.27 8,417.32 10,323.00 81.54% 736.34 8,662.37 (44.07) (245.05) Operations 3,584.58 10,868.63 30,400.00 35.75% 2,058.70 6,201.60 1,525.88 4,667.03 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 14,693.55 133,872.71 165,723.00 80.78% 13,212.08 130,063.06 1,481.47 3,809.65 Finance Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 33,415.46 385,945.07 439,849.00 87.74% 33,443.80 352,310.17 (28.34) 33,634.90 Benefits 5,964.27 73,323.11 82,083.00 89.33% 5,784.04 59,532.49 180.23 13,790.62 Operations 15,698.75 224,971.41 252,820.00 88.98% 15,263.81 230,822.73 434.94 (5,851.32) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 55,078.48 684,239.59 774,752.00 88.32% 54,491.65 642,665.39 586.83 41,574.20 City Clerk Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 10,920.17 121,177.23 124,042.00 97.69% 6,827.11 138,351.71 4,093.06 (17,174.48) Benefits 1,933.11 22,216.98 24,410.00 91.02% 787.11 17,785.84 1,146.00 4,431.14 Operations 6,109.02 104,362.82 80,170.00 130.18% 2,890.18 41,814.74 3,218.84 62,548.08 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 19.95 ‐ (19.95) Total 18,962.30 247,757.03 228,622.00 108.37% 10,504.40 197,972.24 8,457.90 49,784.79 HR Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 26,906.42 297,987.41 343,172.00 86.83% 24,850.67 323,691.94 2,055.75 (25,704.53) Benefits 4,898.69 287,089.59 384,909.00 74.59% 4,525.69 56,600.69 373.00 230,488.90 Operations 5,784.26 67,087.89 87,858.00 76.36% 5,943.42 48,965.08 (159.16) 18,122.81 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 927.82 ‐ (927.82) Total 37,589.37 652,164.89 815,939.00 79.93% 35,319.78 430,185.53 2,269.59 221,979.36 IT Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 17,031.31 203,256.65 218,147.00 93.17% 17,191.81 218,565.54 (160.50) (15,308.89) Benefits 2,895.79 36,234.78 38,636.00 93.79% 2,879.20 35,582.04 16.59 652.74 Operations 84,437.85 1,811,586.23 1,721,197.00 105.25% 129,148.31 1,708,673.47 (44,710.46) 102,912.76 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 104,364.95 2,172,675.66 2,192,980.00 99.07% 149,219.32 2,119,463.71 (44,854.37) 53,211.95 Vehicle Maint. Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 14,030.33 187,525.92 234,957.00 79.81% 17,244.88 227,460.71 (3,214.55) (39,934.79) Benefits 2,455.89 46,248.28 48,849.00 94.68% 2,922.34 46,779.82 (466.45) (531.54) Operations 9,224.66 53,566.86 101,650.00 52.70% 5,527.81 60,932.54 3,696.85 (7,365.68) Capital Outlay ‐ 31,262.82 40,000.00 78.16% ‐ ‐ ‐ 31,262.82 COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 25,710.88 318,603.88 425,456.00 74.89% 25,695.03 335,173.07 15.85 (16,569.19) City of Prattville August 2022 Unaudited Expenditures By Department Engineering Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 49,375.87 531,990.56 619,777.00 85.84% 42,586.69 535,308.37 6,789.18 (3,317.81) Benefits 9,047.02 134,144.97 138,019.00 97.19% 7,651.65 112,682.84 1,395.37 21,462.13 Operations 71,111.79 667,087.21 1,214,902.00 54.91% 35,047.03 324,796.61 36,064.76 342,290.60 Capital Projects ‐ ‐ ‐ ‐ ‐ ‐ ‐ Capital Outlay 11,152.78 101,825.38 255,295.00 39.89% ‐ ‐ 11,152.78 101,825.38 COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 140,687.46 1,435,048.12 2,227,993.00 64.41% 85,285.37 972,787.82 55,402.09 462,260.30 Planning Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 32,979.82 379,370.57 426,880.00 88.87% 31,509.34 405,278.25 1,470.48 (25,907.68) Benefits 6,136.13 73,601.57 81,800.00 89.98% 5,745.76 71,463.49 390.37 2,138.08 Operations 11,530.67 131,199.86 329,817.67 39.78% 47,203.24 455,911.69 (35,672.57) (324,711.83) Capital Projects ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Capital Outlay ‐ 15,136.00 14,500.00 104.39% ‐ 3,630.48 ‐ 11,505.52 COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 50,646.62 599,308.00 852,997.67 70.26% 84,458.34 936,283.91 (33,811.72) (336,975.91) Urban Management Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 80,663.59 950,422.94 1,117,145.00 85.08% 76,777.90 1,019,701.75 3,885.69 (69,278.81) Benefits 13,918.28 209,442.12 223,770.00 93.60% 12,788.21 191,195.22 1,130.07 18,246.90 Operations 60,234.47 499,631.52 560,500.00 89.14% 50,718.35 447,508.91 9,516.12 52,122.61 Capital Outlay ‐ 89,810.80 153,203.00 58.62% 18,952.54 18,952.54 (18,952.54) 70,858.26 COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 154,816.34 1,749,307.38 2,054,618.00 85.14% 159,237.00 1,677,358.42 (4,420.66) 71,948.96 Facilities Maintenance Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 26,561.70 329,373.48 397,866.00 82.79% 28,479.51 378,382.92 (1,917.81) (49,009.44) Benefits 4,376.23 75,797.70 81,396.00 93.12% 4,699.23 64,630.22 (323.00) 11,167.48 Operations 7,284.27 171,155.63 229,000.00 74.74% 26,933.02 154,723.28 (19,648.75) 16,432.35 Capital Outlay ‐ ‐ 455,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 66,244.23 ‐ (66,244.23) Total 38,222.20 576,326.81 1,163,262.00 49.54% 60,111.76 663,980.65 (21,889.56) (87,653.84) Public Works Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 27,513.56 315,625.29 355,055.00 88.89% 25,982.46 337,886.28 1,531.10 (22,260.99) Benefits 5,036.70 67,915.51 71,937.00 94.41% 4,656.22 63,436.49 380.48 4,479.02 Operations 11,500.39 250,501.94 327,718.00 76.44% 11,540.62 181,890.36 (40.23) 68,611.58 Capital Outlay ‐ ‐ ‐ 9,600.00 244,312.00 (9,600.00) (244,312.00) COVID‐19 ‐ ‐ ‐ ‐ 695.55 ‐ (695.55) Total 44,050.65 634,042.74 754,710.00 84.01% 51,779.30 828,220.68 (7,728.65) (194,177.94) Police Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 409,345.68 5,255,583.81 6,205,541.00 84.69% 397,043.98 5,063,737.80 12,301.70 191,846.01 Benefits 72,627.59 1,188,438.75 1,280,084.00 92.84% 68,809.89 996,941.67 3,817.70 191,497.08 Operations 107,812.76 1,649,589.62 2,089,530.00 78.95% 63,013.84 1,115,081.02 44,798.92 534,508.60 Capital Outlay ‐ 474,026.80 650,028.00 72.92% ‐ ‐ ‐ 474,026.80 COVID‐19 ‐ ‐ ‐ ‐ 54,437.46 ‐ (54,437.46) Total 589,786.03 8,567,638.98 10,225,183.00 83.79% 528,867.71 7,230,197.95 60,918.32 1,337,441.03 Fire Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 400,009.02 4,973,521.11 5,687,258.00 87.45% 374,927.31 5,161,017.36 25,081.71 (187,496.25) Benefits 72,767.44 1,179,902.61 1,211,167.00 97.42% 67,253.23 1,081,769.87 5,514.21 98,132.74 Operations 94,863.83 891,397.74 1,500,762.00 59.40% 110,453.17 907,674.31 (15,589.34) (16,276.57) Capital Outlay ‐ 759,922.14 987,765.00 76.93% 12,695.48 226,594.05 (12,695.48) 533,328.09 COVID‐19 ‐ ‐ ‐ ‐ 60,379.92 ‐ (60,379.92) Total 567,640.29 7,804,743.60 9,386,952.00 83.14% 565,329.19 7,437,435.51 2,311.10 367,308.09 Building Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 20,896.80 238,583.51 267,629.00 89.15% 19,918.71 250,690.48 978.09 (12,106.97) Benefits 3,852.36 53,984.79 56,692.00 95.22% 3,576.71 48,846.74 275.65 5,138.05 Operations 2,240.50 29,828.26 67,450.00 44.22% 2,644.57 28,261.18 (404.07) 1,567.08 Capital Outlay 25,270.00 25,270.00 26,000.00 ‐ ‐ ‐ 25,270.00 25,270.00 COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 52,259.66 347,666.56 417,771.00 83.22% 26,139.99 327,798.40 26,119.67 19,868.16 Parks & Recreation Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 92,468.60 1,100,941.04 1,132,797.00 97.19% 84,497.76 1,098,999.93 7,970.84 1,941.11 Benefits 14,814.38 219,293.42 216,697.00 101.20% 13,475.26 190,123.69 1,339.12 29,169.73 Operations 154,886.60 1,203,304.25 1,245,438.00 96.62% 109,413.37 1,058,328.95 45,473.23 144,975.30 Capital Outlay/ Capital Projects 4.36 219,578.00 1,702,054.00 12.90% 20,601.59 29,911.58 (20,597.23) 189,666.42 COVID‐19 ‐ ‐ ‐ ‐ 209.95 ‐ (209.95) Total 262,173.94 2,743,116.71 4,296,986.00 63.84% 227,987.98 2,377,574.10 34,185.96 365,542.61 Performing Arts Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 12,384.10 136,019.84 137,849.00 98.67% 10,162.97 126,923.60 2,221.13 9,096.24 Benefits 2,132.76 23,749.53 24,304.00 97.72% 1,573.17 19,264.56 559.59 4,484.97 Operations 31,357.91 227,690.64 254,820.00 89.35% 21,710.31 128,675.70 9,647.60 99,014.94 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 23.96 ‐ (23.96) Total 45,874.77 387,460.01 416,973.00 92.92% 33,446.45 274,887.82 12,428.32 112,572.19 Non‐Departmental Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference City ‐ County Svcs 7,083.34 424,500.00 432,000.00 98.26% 7,083.33 430,000.00 0.01 (5,500.00) Community Initiatives 16,666.67 928,171.88 1,240,839.00 74.80% 39,402.68 540,370.73 (22,736.01) 387,801.15 Unprocessed JP Morgan Payment ‐ ‐ ‐ 100.00% ‐ ‐ ‐ ‐ Drug Proceeds Expenditures ‐ 41,683.00 ‐ 100.00% ‐ 19,596.00 ‐ 22,087.00 Transfer to DSF ‐ One Cent ‐ Infras 15,265.25 535,818.51 573,819.00 93.38% ‐ ‐ 15,265.25 535,818.51 Transfer to DSF ‐ Other ‐ 123,311.20 123,311.00 100.00% ‐ 558,667.08 ‐ (435,355.88) Transfer to DSF ‐ One Cent (old) ‐ ‐ ‐ 5,910,875.00 14,621,584.10 (5,910,875.00) ‐ Transfer to Group Health 274,750.00 3,022,250.00 3,297,000.00 91.67% 252,500.00 2,781,844.00 22,250.00 240,406.00 Transfer to Capital Project Fund 600,513.16 3,307,993.11 5,283,233.97 62.61% 661,900.00 661,900.00 (61,386.84) 2,646,093.11 Transfer to Wasewater Fund ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Sanitation Fund ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Gas Tax Fund ‐ ‐ ‐ ‐ 42,723.04 42,723.04 (42,723.04) (42,723.04) Transfer to Judicial ‐ 261,287.36 261,287.00 100.00% 222,614.18 222,614.18 (222,614.18) 38,673.18 Total 914,278.42 9,020,735.00 11,211,489.97 80.46% 7,137,098.23 19,879,299.13 (6,222,819.81) 3,387,300.03 Debt Service Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Debt Service 44,501.10 1,793,830.25 2,134,891.00 84.02% 138,651.26 1,747,478.30 (94,150.16) 46,351.95 Total 44,501.10 1,793,830.25 2,134,891.00 84.02% 138,651.26 1,747,478.30 (94,150.16) 46,351.95 Total Aug‐22 YTD Budget % of Budget Aug‐21 YTD August Difference YTD Difference Salary 1,297,570.63 15,916,083.41 18,255,629.00 87.18% 1,230,873.62 16,043,025.17 66,697.01 (126,941.76) Benefits 503,178.73 6,783,229.45 7,337,934.00 92.44% 464,576.49 5,886,478.22 38,602.24 896,751.23 Operations 1,327,563.19 13,114,839.60 17,605,605.64 74.49% 1,621,976.98 8,924,578.69 (294,413.79) 4,190,260.91 Capital Outlay 58,027.14 1,883,844.47 4,542,045.00 41.48% 61,849.61 592,620.03 (3,822.47) 1,291,224.44 Debt Service 59,766.35 2,452,959.96 2,832,021.00 86.62% 6,049,526.26 16,927,729.48 (5,989,759.91) (14,474,769.52) COVID‐19 ‐ ‐ ‐ ‐ ‐ 321,467.30 Total 3,246,106.04 40,150,956.89 50,573,234.64 79.39% 9,428,802.96 48,695,898.89 (6,182,696.92) (8,223,474.70) % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 79.39% Prepared by Daniel Oakley