Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
June 2021 - Council Expenditure Report
As of 7/18/2021 75.00 % Year Complete Executive Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 22,546.12 208,639.82 454,953.00 45.86% 20,307.30 197,175.62 2,238.82 11,464.20 Benefits 3,154.38 28,845.16 69,484.00 41.51% 2,559.61 25,026.73 594.77 3,818.43 Operations 14,833.56 112,899.38 218,035.00 51.78% 5,999.53 63,542.52 8,834.03 49,356.86 Capital Outlay 48,364.25 48,364.25 48,365.00 100.00% ‐ ‐ 48,364.25 48,364.25 COVID‐19 ‐ 2,740.93 100.00% ‐ 2,740.93 Total 88,898.31 401,489.54 790,837.00 50.77% 28,866.44 285,744.87 60,031.87 115,744.67 Legislative Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 10,417.04 94,365.01 125,000.00 75.49% 10,417.04 93,753.36 ‐ 611.65 Benefits 768.48 7,232.87 10,306.00 70.18% 818.82 7,104.10 (50.34) 128.77 Operations 691.53 2,435.30 20,900.00 11.65% 62.15 8,356.95 629.38 (5,921.65) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ Total 11,877.05 104,033.18 156,206.00 66.60% 11,298.01 109,214.41 579.04 (5,181.23) Finance Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 25,931.47 251,761.16 403,498.00 62.39% 24,975.47 237,758.31 956.00 14,002.85 Benefits 4,608.98 44,329.65 72,462.00 61.18% 4,181.03 38,778.83 427.95 5,550.82 Operations 6,738.02 265,779.25 237,750.00 111.79% 8,553.37 172,932.33 (1,815.35) 92,846.92 Capital Outlay ‐ 0.00% ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 37,278.47 561,870.06 713,710.00 78.73% 37,709.87 449,469.47 (431.40) 112,400.59 City Clerk Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 9,972.28 114,127.63 144,744.00 78.85% 10,810.91 98,377.30 (838.63) 15,750.33 Benefits 1,715.02 15,070.37 25,190.00 59.83% 1,830.92 16,261.38 (115.90) (1,191.01) Operations 1,758.34 29,388.44 51,670.00 56.88% 1,262.10 22,464.93 496.24 6,923.51 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 19.95 100.00% ‐ 19.95 Total 13,445.64 158,606.39 221,604.00 71.57% 13,903.93 137,103.61 (458.29) 21,502.78 HR Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 24,594.01 241,969.49 316,371.00 76.48% 22,984.87 224,655.56 1,609.14 17,313.93 Benefits 4,533.40 43,784.69 459,716.00 9.52% 4,213.99 40,262.18 319.41 3,522.51 Operations 8,346.46 38,702.82 91,025.00 42.52% 3,404.85 45,377.19 4,941.61 (6,674.37) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ COVID‐19 ‐ 927.82 100.00% ‐ 927.82 Total 37,473.87 325,384.82 867,112.00 37.53% 30,603.71 310,294.93 6,870.16 15,089.89 IT Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 18,051.79 163,982.45 204,469.00 80.20% 15,163.72 140,773.87 2,888.07 23,208.58 Benefits 3,066.86 27,517.86 35,188.00 78.20% 2,362.49 21,420.98 704.37 6,096.88 Operations 135,970.71 1,482,012.44 1,808,147.00 81.96% 68,907.81 989,724.07 67,062.90 492,288.37 Capital Outlay ‐ 20,855.13 94,552.00 22.06% ‐ 94,038.13 ‐ (73,183.00) COVID‐19 ‐ 135,787.53 100.00% ‐ 135,787.53 Total 157,089.36 1,830,155.41 2,142,356.00 85.43% 86,434.02 1,245,957.05 70,655.34 584,198.36 Vehicle Maint. Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 17,161.68 166,836.33 227,010.00 73.49% 17,365.20 165,261.47 (203.52) 1,574.86 Benefits 4,362.59 38,144.66 47,083.00 81.02% 4,147.87 34,688.01 214.72 3,456.65 Operations 3,173.30 46,895.69 98,150.00 47.78% 6,017.61 67,768.77 (2,844.31) (20,873.08) Capital Outlay ‐ ‐ 7,500.00 0.00% ‐ 35,240.95 ‐ (35,240.95) COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 24,697.57 251,876.68 379,743.00 66.33% 27,530.68 302,959.20 (2,833.11) (51,082.52) City of Prattville June 2021 Unaudited Expenditures By Department Engineering Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 42,548.29 388,652.93 541,734.00 71.74% 36,940.38 336,993.95 5,607.91 51,658.98 Benefits 10,300.70 90,397.02 113,070.00 79.95% 8,639.30 73,357.86 1,661.40 17,039.16 Operations 49,900.97 259,257.69 793,700.00 32.66% 29,739.17 259,574.40 20,161.80 (316.71) Capital Outlay ‐ ‐ 0.00% ‐ 99,138.00 ‐ (99,138.00) COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 102,749.96 738,307.64 1,448,504.00 50.97% 75,318.85 769,064.21 27,431.11 (30,756.57) Planning Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 31,547.69 298,532.13 404,595.00 73.79% 29,703.70 240,479.34 1,843.99 58,052.79 Benefits 5,835.09 54,942.30 76,496.00 71.82% 5,386.74 43,348.70 448.35 11,593.60 Operations 42,080.98 349,059.29 540,450.00 64.59% 73,590.53 427,492.73 (31,509.55) (78,433.44) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ COVID‐19 ‐ 3,630.48 100.00% ‐ ‐ 3,630.48 Total 79,463.76 706,164.20 1,021,541.00 69.13% 108,680.97 711,320.77 (29,217.21) (5,156.57) Urban Management Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 71,098.77 726,994.97 990,654.00 73.39% 67,025.28 643,629.55 4,073.49 83,365.42 Benefits 15,866.48 151,605.25 193,188.00 78.48% 11,969.86 117,006.40 3,896.62 34,598.85 Operations 33,503.52 363,961.18 528,000.00 68.93% 21,847.37 315,642.45 11,656.15 48,318.73 Capital Outlay ‐ ‐ 81,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 120,468.77 1,242,561.40 1,792,842.00 69.31% 100,842.51 1,076,278.40 19,626.26 166,283.00 Facilities Maintenance Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 28,703.42 271,406.49 380,874.00 71.26% 27,095.04 261,988.07 1,608.38 9,418.42 Benefits 5,428.09 50,110.05 67,073.00 74.71% 4,720.32 43,977.77 707.77 6,132.28 Operations 16,603.74 121,954.96 222,550.00 54.80% 2,852.88 98,779.18 13,750.86 23,175.78 Capital Outlay ‐ ‐ 375,000.00 0.00% ‐ 91,416.00 ‐ (91,416.00) COVID‐19 ‐ 66,244.23 100.00% ‐ 66,244.23 Total 50,735.25 509,715.73 1,045,497.00 48.75% 34,668.24 496,161.02 16,067.01 13,554.71 Public Works Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 26,248.24 248,823.00 332,353.00 74.87% 24,453.07 229,086.94 1,795.17 19,736.06 Benefits 5,397.25 49,905.29 64,481.00 77.40% 4,734.45 43,176.01 662.80 6,729.28 Operations 11,006.39 154,459.71 212,718.00 72.61% 4,409.56 169,567.33 6,596.83 (15,107.62) Capital Outlay 9,600.00 229,912.00 520,000.00 44.21% ‐ 9,600.00 229,912.00 COVID‐19 ‐ 695.55 100.00% ‐ 695.55 Total 52,251.88 683,795.55 1,129,552.00 60.54% 33,597.08 441,830.28 18,654.80 241,965.27 Police Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 384,535.59 3,749,078.91 5,753,608.00 65.16% 376,498.14 3,754,434.50 8,037.45 (5,355.59) Benefits 86,712.83 802,539.03 1,114,150.00 72.03% 66,869.66 718,892.44 19,843.17 83,646.59 Operations 86,569.05 960,237.32 1,324,221.00 72.51% 77,965.73 895,770.69 8,603.32 64,466.63 Capital Outlay ‐ ‐ 6,229.00 0.00% ‐ 114,912.04 ‐ (114,912.04) COVID‐19 ‐ 54,437.46 100.00% ‐ 54,437.46 Total 557,817.47 5,566,292.72 8,198,208.00 67.90% 521,333.53 5,484,009.67 36,483.94 82,283.05 Fire Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 410,295.95 3,844,507.37 5,136,336.26 74.85% 413,629.85 3,655,240.80 (3,333.90) 189,266.57 Benefits 97,966.97 881,724.95 1,064,538.89 82.83% 72,065.54 750,272.10 25,901.43 131,452.85 Operations 52,332.27 723,266.18 1,097,908.00 65.88% 49,697.88 661,213.60 2,634.39 62,052.58 Capital Outlay ‐ 213,898.57 80,700.00 265.05% ‐ 29,990.00 ‐ 183,908.57 COVID‐19 ‐ 60,379.92 100.00% ‐ 60,379.92 Total 560,595.19 5,723,776.99 7,379,483.15 77.56% 535,393.27 5,096,716.50 25,201.92 627,060.49 Building Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 19,633.60 19,131.60 254,406.00 7.52% 18,804.80 178,523.23 828.80 (159,391.63) Benefits 4,183.14 3,433.31 51,631.00 6.65% 3,417.38 34,478.68 765.76 (31,045.37) Operations 1,513.60 1,002.56 67,450.00 1.49% 863.52 27,496.04 650.08 (26,493.48) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 25,330.34 23,567.47 373,487.00 6.31% 23,085.70 240,497.95 2,244.64 (216,930.48) Parks & Recreation Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 95,477.46 79,581.19 1,058,409.00 7.52% 82,587.58 724,126.91 12,889.88 (644,545.72) Benefits 17,555.10 12,609.31 192,383.00 6.55% 16,386.87 127,784.98 1,168.23 (115,175.67) Operations 121,467.97 91,585.04 1,316,238.00 6.96% 63,183.56 789,848.33 58,284.41 (698,263.29) Capital Outlay/ Capital Projects ‐ 9,309.99 295,400.00 3.15% ‐ 75,012.11 ‐ (65,702.12) COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 234,500.53 193,085.53 2,862,430.00 6.75% 162,158.01 1,716,772.33 72,342.52 (1,523,686.80) Performing Arts Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 10,411.85 8,896.75 111,783.00 7.96% 8,523.59 84,110.56 1,888.26 (75,213.81) Benefits 1,667.60 1,383.82 18,332.00 7.55% 1,358.72 12,362.26 308.88 (10,978.44) Operations 7,012.69 6,445.93 255,640.00 2.52% 14,441.11 111,620.72 (7,428.42) (105,174.79) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 23.96 100.00% ‐ 23.96 Total 19,092.14 16,750.46 385,755.00 4.34% 24,323.42 208,093.54 (5,231.28) (191,343.08) Non‐Departmental Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference City ‐ County Svcs 7,083.33 335,833.34 430,000.00 78.10% 14,166.66 325,833.34 (7,083.33) 10,000.00 Community Initiatives 170,575.60 358,122.83 928,801.00 38.56% 58,624.49 649,923.68 111,951.11 (291,800.85) Unprocessed JP Morgan Payment ‐ ‐ 100.00% ‐ ‐ ‐ ‐ Drug Proceeds Expenditures 19,596.00 ‐ 100.00% ‐ ‐ ‐ 19,596.00 Transfer to DSF ‐ One Cent 8,710,709.10 8,785,000.00 99.15% ‐ 3,299,833.47 ‐ 5,410,875.63 Transfer to DSF ‐ Other 24,130.00 465,725.61 558,667.00 83.36% 24,625.00 475,953.86 (495.00) (10,228.25) Transfer to Group Health 252,500.00 2,276,844.00 3,034,344.00 75.04% 249,583.33 2,256,249.97 2,916.67 20,594.03 Transfer to Capital Project Fund ‐ ‐ 0.00% 5.00 49,870.02 (5.00) (49,870.02) Transfer to Sanitation Fund ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Transfer to Gas Tax Fund ‐ ‐ 42,723.00 0.00% ‐ ‐ ‐ ‐ Transfer to Judicial ‐ ‐ 222,614.00 0.00% ‐ ‐ ‐ ‐ Total 454,288.93 12,166,830.88 14,002,149.00 86.89% 347,004.48 7,057,664.34 107,284.45 5,109,166.54 Debt Service Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Debt Service 109,050.33 1,387,000.95 1,745,500.00 79.46% 123,579.06 1,201,658.02 (14,528.73) 185,342.93 Total 109,050.33 1,387,000.95 1,745,500.00 79.46% 123,579.06 1,201,658.02 (14,528.73) 185,342.93 Total Jun‐21 YTD Budget % of Budget Jun‐20 YTD June Difference YTD Difference Salary 1,249,175.25 10,877,287.23 16,840,797.26 64.59% 1,207,285.94 11,266,369.34 41,889.31 (389,082.11) Benefits 525,622.96 4,580,419.59 6,709,115.89 68.27% 465,246.90 4,404,449.38 60,376.06 175,970.21 Operations 771,162.03 5,722,895.35 10,508,690.00 54.46% 505,594.88 6,152,799.27 265,567.15 (429,903.92) Capital Outlay 57,964.25 522,339.94 1,508,746.00 34.62% ‐ 539,747.23 57,964.25 (17,407.29) Debt Service 133,180.33 10,563,435.66 11,089,167.00 95.26% 148,204.06 4,977,445.35 (15,023.73) 5,585,990.31 COVID‐19 ‐ 324,887.83 ‐ 100.00% Total 2,737,104.82 32,591,265.60 46,656,516.15 69.85% 2,326,331.78 27,340,810.57 410,773.04 4,925,567.20 % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 69.16% Prepared by Daniel Oakley