Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
April 2021 - Council Expenditure Report
As of 5/14/2021 58.33 % Year Complete Executive Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 22,546.12 163,547.58 454,953.00 35.95% 20,211.93 156,645.80 2,334.19 6,901.78 Benefits 3,126.96 22,577.42 69,484.00 32.49% 2,511.14 19,927.33 615.82 2,650.09 Operations 8,512.51 76,322.55 266,400.00 28.65% 3,760.81 53,783.77 4,751.70 22,538.78 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 2,740.93 100.00% ‐ 2,740.93 Total 34,185.59 265,188.48 790,837.00 33.53% 26,483.88 230,356.90 7,701.71 34,831.58 Legislative Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 10,417.04 73,530.93 125,000.00 58.82% 10,417.04 72,919.28 ‐ 611.65 Benefits 804.16 5,703.41 10,306.00 55.34% 804.18 5,524.28 (0.02) 179.13 Operations ‐ 1,712.75 20,900.00 8.19% 6,528.13 8,920.01 (6,528.13) (7,207.26) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ Total 11,221.20 80,947.09 156,206.00 51.82% 17,749.35 87,363.57 (6,528.15) (6,416.48) Finance Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 25,811.17 199,927.72 403,498.00 49.55% 24,751.12 188,025.94 1,060.05 11,901.78 Benefits 4,552.10 35,170.89 72,462.00 48.54% 4,025.83 30,617.62 526.27 4,553.27 Operations 37,622.84 229,481.27 237,750.00 96.52% 6,686.04 155,974.99 30,936.80 73,506.28 Capital Outlay ‐ 0.00% ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 67,986.11 464,579.88 713,710.00 65.09% 35,462.99 374,618.55 32,523.12 89,961.33 City Clerk Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 14,265.15 93,821.15 144,744.00 64.82% 10,810.91 76,755.48 3,454.24 17,065.67 Benefits 1,746.38 11,612.90 25,190.00 46.10% 1,749.70 12,683.54 (3.32) (1,070.64) Operations 2,703.16 21,863.63 51,670.00 42.31% 5,468.74 20,027.31 (2,765.58) 1,836.32 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 19.95 100.00% ‐ 19.95 Total 18,714.69 127,317.63 221,604.00 57.45% 18,029.35 109,466.33 685.34 17,851.30 HR Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 24,299.29 192,801.42 316,371.00 60.94% 23,688.77 178,262.45 610.52 14,538.97 Benefits 4,444.89 34,777.67 459,716.00 7.57% 4,232.92 31,929.60 211.97 2,848.07 Operations 7,483.39 28,532.14 91,025.00 31.35% 2,369.43 36,440.41 5,113.96 (7,908.27) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ COVID‐19 ‐ 927.82 100.00% ‐ 927.82 Total 36,227.57 257,039.05 867,112.00 29.64% 30,291.12 246,632.46 5,936.45 10,406.59 IT Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 17,295.72 129,040.88 204,469.00 63.11% 15,005.64 110,960.19 2,290.08 18,080.69 Benefits 2,907.11 21,623.32 35,188.00 61.45% 2,257.67 16,865.51 649.44 4,757.81 Operations 127,941.64 1,200,350.74 1,808,147.00 66.39% 99,380.84 856,159.14 28,560.80 344,191.60 Capital Outlay ‐ 20,855.13 94,552.00 22.06% ‐ 94,038.13 ‐ (73,183.00) COVID‐19 26,668.00 133,529.30 100.00% 26,668.00 133,529.30 Total 174,812.47 1,505,399.37 2,142,356.00 70.27% 116,644.15 1,078,022.97 58,168.32 427,376.40 Vehicle Maint. Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 13,813.98 134,186.98 227,010.00 59.11% 17,343.08 130,461.43 (3,529.10) 3,725.55 Benefits 2,363.76 31,136.94 47,083.00 66.13% 2,858.94 27,673.23 (495.18) 3,463.71 Operations 11,012.61 42,249.58 98,150.00 43.05% 9,452.79 55,868.77 1,559.82 (13,619.19) Capital Outlay ‐ ‐ 7,500.00 0.00% 26,660.95 35,240.95 (26,660.95) (35,240.95) COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 27,190.35 207,573.50 379,743.00 54.66% 56,315.76 249,244.38 (29,125.41) (41,670.88) City of Prattville April 2021 Unaudited Expenditures By Department Engineering Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 38,219.40 304,258.34 541,734.00 56.16% 37,588.64 262,995.58 630.76 41,262.76 Benefits 6,857.66 72,619.78 113,070.00 64.23% 6,520.74 58,231.15 336.92 14,388.63 Operations 28,337.67 179,053.78 793,700.00 22.56% 37,708.00 206,686.48 (9,370.33) (27,632.70) Capital Outlay ‐ ‐ 0.00% ‐ 12,750.00 ‐ (12,750.00) COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 73,414.73 555,931.90 1,448,504.00 38.38% 81,817.38 540,663.21 (8,402.65) 15,268.69 Planning Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 31,293.64 235,597.90 404,595.00 58.23% 28,077.94 180,921.44 3,215.70 54,676.46 Benefits 5,728.60 43,384.79 76,496.00 56.72% 5,041.39 32,670.85 687.21 10,713.94 Operations 41,932.86 271,336.85 540,450.00 50.21% 52,969.64 298,945.73 (11,036.78) (27,608.88) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ COVID‐19 1,921.14 1,921.14 100.00% ‐ 1,921.14 1,921.14 Total 80,876.24 552,240.68 1,021,541.00 54.06% 86,088.97 512,538.02 (5,212.73) 39,702.66 Urban Management Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 75,812.44 582,455.19 990,654.00 58.80% 67,858.89 504,914.29 7,953.55 77,540.90 Benefits 12,981.59 123,246.34 193,188.00 63.80% 10,923.24 93,778.30 2,058.35 29,468.04 Operations 35,894.27 300,148.52 528,000.00 56.85% 27,843.12 269,972.15 8,051.15 30,176.37 Capital Outlay ‐ ‐ 81,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 124,688.30 1,005,850.05 1,792,842.00 56.10% 106,625.25 868,664.74 18,063.05 137,185.31 Facilities Maintenance Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 28,196.65 214,344.04 380,874.00 56.28% 27,129.24 207,730.22 1,067.41 6,613.82 Benefits 4,667.91 40,021.08 67,073.00 59.67% 4,156.64 35,118.25 511.27 4,902.83 Operations 23,233.90 101,734.75 222,550.00 45.71% 19,923.54 90,126.65 3,310.36 11,608.10 Capital Outlay ‐ ‐ 375,000.00 0.00% 77,790.00 91,416.00 (77,790.00) (91,416.00) COVID‐19 ‐ 66,244.23 100.00% ‐ 66,244.23 Total 56,098.46 422,344.10 1,045,497.00 40.40% 128,999.42 424,391.12 (72,900.96) (2,047.02) Public Works Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 25,779.49 196,528.04 332,353.00 59.13% 24,442.20 180,173.63 1,337.29 16,354.41 Benefits 4,640.85 39,836.80 64,481.00 61.78% 4,209.56 34,247.07 431.29 5,589.73 Operations 9,600.59 133,689.38 212,718.00 62.85% 16,816.08 156,856.03 (7,215.49) (23,166.65) Capital Outlay 47,172.00 47,172.00 520,000.00 9.07% ‐ 47,172.00 47,172.00 COVID‐19 ‐ 695.55 100.00% ‐ 695.55 Total 87,192.93 417,921.77 1,129,552.00 37.00% 45,467.84 371,276.73 41,725.09 46,645.04 Police Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 372,190.14 2,979,953.73 5,753,608.00 51.79% 375,161.64 2,992,068.31 (2,971.50) (12,114.58) Benefits 64,309.17 649,578.96 1,114,150.00 58.30% 61,956.23 589,400.12 2,352.94 60,178.84 Operations 110,048.13 802,000.23 1,324,221.00 60.56% 64,797.76 760,886.17 45,250.37 41,114.06 Capital Outlay ‐ ‐ 6,229.00 0.00% 1,455.00 114,912.04 (1,455.00) (114,912.04) COVID‐19 ‐ 54,437.46 100.00% ‐ 54,437.46 Total 546,547.44 4,485,970.38 8,198,208.00 54.72% 503,370.63 4,457,266.64 43,176.81 28,703.74 Fire Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 371,867.29 3,058,429.06 5,136,336.26 59.54% 357,876.46 2,885,037.55 13,990.83 173,391.51 Benefits 66,973.90 716,244.22 1,064,538.89 67.28% 62,463.48 616,363.06 4,510.42 99,881.16 Operations 112,659.56 568,929.80 1,097,908.00 51.82% 65,332.47 511,193.98 47,327.09 57,735.82 Capital Outlay ‐ 213,425.57 80,700.00 264.47% ‐ ‐ ‐ 213,425.57 COVID‐19 ‐ 60,379.92 100.00% ‐ 60,379.92 Total 551,500.75 4,617,408.57 7,379,483.15 62.57% 485,672.41 4,012,594.59 65,828.34 604,813.98 Building Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 19,477.33 19,131.60 254,406.00 7.52% 18,804.80 140,913.63 672.53 (121,782.03) Benefits 3,497.18 3,433.31 51,631.00 6.65% 3,271.38 27,789.92 225.80 (24,356.61) Operations 2,686.16 1,002.56 67,450.00 1.49% 1,625.72 25,793.39 1,060.44 (24,790.83) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 25,660.67 23,567.47 373,487.00 6.31% 23,701.90 194,496.94 1,958.77 (170,929.47) Parks & Recreation Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 80,415.42 79,581.19 1,058,409.00 7.52% 76,764.47 566,973.16 3,650.95 (487,391.97) Benefits 12,999.21 12,609.31 192,383.00 6.55% 11,671.32 100,090.13 1,327.89 (87,480.82) Operations 112,184.13 91,585.04 1,316,238.00 6.96% 143,481.72 676,938.08 (31,297.59) (585,353.04) Capital Outlay/ Capital Projects 9,309.99 9,309.99 295,400.00 3.15% 12,500.00 62,512.11 (3,190.01) (53,202.12) COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 214,908.75 193,085.53 2,862,430.00 6.75% 244,417.51 1,406,513.48 (29,508.76) (1,213,427.95) Performing Arts Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 10,054.31 8,896.75 111,783.00 7.96% 8,402.81 67,177.85 1,651.50 (58,281.10) Benefits 1,571.99 1,383.82 18,332.00 7.55% 1,194.28 9,810.12 377.71 (8,426.30) Operations 19,278.38 6,445.93 255,640.00 2.52% 10,832.02 95,887.18 8,446.36 (89,441.25) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 23.96 100.00% ‐ 23.96 Total 30,904.68 16,750.46 385,755.00 4.34% 20,429.11 172,875.15 10,475.57 (156,124.69) Non‐Departmental Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference City ‐ County Svcs 94,166.66 321,666.68 430,000.00 74.81% 92,083.33 311,666.68 2,083.33 10,000.00 Community Initiatives 39,647.85 170,377.65 928,801.00 18.34% 67,907.96 533,138.56 (28,260.11) (362,760.91) Unprocessed JP Morgan Payment ‐ ‐ 100.00% ‐ ‐ ‐ ‐ Drug Proceeds Expenditures 19,596.00 ‐ 100.00% ‐ ‐ ‐ 19,596.00 Transfer to DSF ‐ One Cent 111,250.00 8,710,709.10 8,785,000.00 99.15% ‐ 3,299,833.47 111,250.00 5,410,875.63 Transfer to DSF ‐ Other 92,941.47 441,595.61 558,667.00 79.04% ‐ 451,328.86 92,941.47 (9,733.25) Transfer to Group Health 256,844.00 1,771,844.00 3,034,344.00 58.39% 249,583.33 1,757,083.31 7,260.67 14,760.69 Transfer to Capital Project Fund ‐ ‐ 0.00% ‐ 49,865.02 ‐ (49,865.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 594,849.98 11,435,789.04 14,002,149.00 81.67% 409,574.62 6,402,915.90 185,275.36 5,032,873.14 Debt Service Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Debt Service 247,913.11 1,138,239.06 1,745,500.00 65.21% 153,775.12 1,005,539.94 94,137.99 132,699.12 Total 247,913.11 1,138,239.06 1,745,500.00 65.21% 153,775.12 1,005,539.94 94,137.99 132,699.12 Total Apr‐21 YTD Budget % of Budget Apr‐20 YTD April Difference YTD Difference Salary 1,181,754.58 8,666,032.50 16,840,797.26 51.46% 1,144,335.58 8,902,936.23 37,419.00 (236,903.73) Benefits 461,017.42 3,636,804.96 6,709,115.89 54.21% 439,431.97 3,499,803.39 21,585.45 137,001.57 Operations 824,946.31 4,568,079.83 10,557,055.00 43.27% 734,968.14 5,175,130.50 89,978.17 (607,050.67) Capital Outlay 56,481.99 290,762.69 1,460,381.00 19.91% 118,405.95 410,869.23 (61,923.96) (120,106.54) Debt Service 452,104.58 10,290,543.77 11,089,167.00 92.80% 153,775.12 4,756,702.27 298,329.46 5,533,841.50 COVID‐19 28,589.14 320,920.26 ‐ 100.00% Total 3,004,894.02 27,773,144.01 46,656,516.15 59.53% 2,590,916.76 22,745,441.62 385,388.12 4,706,782.13 % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 58.84% Prepared by Daniel Oakley