Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
July 2021 - Council Expenditure Report
As of 8/13/2021 83.33 % Year Complete Executive Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 51,867.77 260,507.59 454,953.00 57.26% 29,237.15 226,412.77 22,630.62 34,094.82 Benefits 6,278.58 35,123.74 69,484.00 50.55% 3,642.25 28,668.98 2,636.33 6,454.76 Operations 28,192.23 141,091.61 218,035.00 64.71% 4,998.93 68,381.47 23,193.30 72,710.14 Capital Outlay ‐ 48,364.25 48,365.00 100.00% ‐ ‐ ‐ 48,364.25 COVID‐19 ‐ 2,740.93 100.00% 664.06 824.04 (664.06) 1,916.89 Total 86,338.58 487,828.12 790,837.00 61.69% 38,542.39 324,287.26 47,796.19 163,540.86 Legislative Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 10,417.04 104,782.05 125,000.00 83.83% 10,417.04 104,170.40 ‐ 611.65 Benefits 693.16 7,926.03 10,306.00 76.91% 788.82 7,892.92 (95.66) 33.11 Operations 1,707.60 4,142.90 20,900.00 19.82% ‐ 4,317.22 1,707.60 (174.32) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 4,039.73 ‐ (4,039.73) Total 12,817.80 116,850.98 156,206.00 74.81% 11,205.86 120,420.27 1,611.94 (3,569.29) Finance Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 67,105.21 318,866.37 403,498.00 79.03% 36,371.91 274,130.22 30,733.30 44,736.15 Benefits 9,418.80 53,748.45 72,462.00 74.17% 6,056.47 44,835.30 3,362.33 8,913.15 Operations 15,463.62 215,558.92 237,750.00 90.67% 22,871.81 195,722.44 (7,408.19) 19,836.48 Capital Outlay ‐ 0.00% ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% 107.74 189.44 (107.74) (189.44) Total 91,987.63 588,173.74 713,710.00 82.41% 65,407.93 514,877.40 26,579.70 73,296.34 City Clerk Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 17,396.97 131,524.60 144,744.00 90.87% 15,258.03 113,635.33 2,138.94 17,889.27 Benefits 1,928.36 16,998.73 25,190.00 67.48% 2,582.09 18,843.47 (653.73) (1,844.74) Operations 9,536.12 38,924.56 51,670.00 75.33% 12,347.66 34,339.42 (2,811.54) 4,585.14 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 19.95 100.00% 8,381.75 8,854.92 (8,381.75) (8,834.97) Total 28,861.45 187,467.84 221,604.00 84.60% 38,569.53 175,673.14 (9,708.08) 11,794.70 HR Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 56,871.78 298,841.27 316,371.00 94.46% 34,519.50 259,175.06 22,352.28 39,666.21 Benefits 8,290.31 52,075.00 459,716.00 11.33% 6,154.30 46,416.48 2,136.01 5,658.52 Operations 4,318.84 43,021.66 91,025.00 47.26% 8,297.63 47,202.06 (3,978.79) (4,180.40) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 927.82 100.00% 2,329.55 8,802.31 (2,329.55) (7,874.49) Total 69,480.93 394,865.75 867,112.00 45.54% 51,300.98 361,595.91 18,179.95 33,269.84 IT Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 37,391.28 201,373.73 204,469.00 98.49% 23,604.38 164,378.25 13,786.90 36,995.48 Benefits 5,184.98 32,702.84 35,188.00 92.94% 3,564.80 24,985.78 1,620.18 7,717.06 Operations 97,512.72 1,579,525.16 1,808,147.00 87.36% 67,347.28 1,053,881.92 30,165.44 525,643.24 Capital Outlay ‐ 20,855.13 94,552.00 22.06% ‐ 94,038.13 ‐ (73,183.00) COVID‐19 ‐ 135,787.53 100.00% 10,178.24 13,367.67 (10,178.24) 122,419.86 Total 140,088.98 1,970,244.39 2,142,356.00 91.97% 104,694.70 1,350,651.75 35,394.28 619,592.64 Vehicle Maint. Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 43,379.50 210,215.83 227,010.00 92.60% 26,187.25 191,448.72 17,192.25 18,767.11 Benefits 5,712.82 43,857.48 47,083.00 93.15% 4,350.78 39,038.79 1,362.04 4,818.69 Operations 8,509.04 55,404.73 98,150.00 56.45% 5,426.69 73,195.46 3,082.35 (17,790.73) Capital Outlay ‐ ‐ 7,500.00 0.00% ‐ 35,240.95 ‐ (35,240.95) COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 57,601.36 309,478.04 379,743.00 81.50% 35,964.72 338,923.92 21,636.64 (29,445.88) City of Prattville July 2021 Unaudited Expenditures By Department Engineering Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 104,068.75 492,721.68 541,734.00 90.95% 55,424.53 392,418.48 48,644.22 100,303.20 Benefits 14,634.17 105,031.19 113,070.00 92.89% 9,777.88 83,135.74 4,856.29 21,895.45 Operations 30,491.89 289,749.58 793,700.00 36.51% 14,968.21 274,542.61 15,523.68 15,206.97 Capital Outlay ‐ ‐ 0.00% ‐ 99,138.00 ‐ (99,138.00) COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 149,194.81 887,502.45 1,448,504.00 61.27% 80,170.62 849,234.83 69,024.19 38,267.62 Planning Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 75,236.78 373,768.91 404,595.00 92.38% 44,529.67 285,009.01 30,707.11 88,759.90 Benefits 10,775.43 65,717.73 76,496.00 85.91% 7,913.34 51,262.04 2,862.09 14,455.69 Operations 59,649.16 408,708.45 540,450.00 75.62% 50,676.80 478,169.53 8,972.36 (69,461.08) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 3,630.48 100.00% ‐ ‐ ‐ 3,630.48 Total 145,661.37 851,825.57 1,021,541.00 83.39% 103,119.81 814,440.58 42,541.56 37,384.99 Urban Management Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 215,928.88 942,923.85 990,654.00 95.18% 100,075.58 743,705.13 115,853.30 199,218.72 Benefits 26,801.76 178,407.01 193,188.00 92.35% 16,200.34 133,206.74 10,601.42 45,200.27 Operations 32,829.38 396,790.56 528,000.00 75.15% 26,228.09 341,870.54 6,601.29 54,920.02 Capital Outlay ‐ ‐ 81,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 275,560.02 1,518,121.42 1,792,842.00 84.68% 142,504.01 1,218,782.41 133,056.01 299,339.01 Facilities Maintenance Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 78,496.92 349,903.41 380,874.00 91.87% 40,925.54 302,913.61 37,571.38 46,989.80 Benefits 9,820.94 59,930.99 67,073.00 89.35% 6,326.02 50,303.79 3,494.92 9,627.20 Operations 5,835.30 127,790.26 222,550.00 57.42% 9,989.94 108,426.89 (4,154.64) 19,363.37 Capital Outlay ‐ ‐ 375,000.00 0.00% ‐ 91,416.00 ‐ (91,416.00) COVID‐19 ‐ 66,244.23 100.00% 3.29 345.52 (3.29) 65,898.71 Total 94,153.16 603,868.89 1,045,497.00 57.76% 57,244.79 553,405.81 36,908.37 50,463.08 Public Works Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 63,080.82 311,903.82 332,353.00 93.85% 37,096.27 266,183.21 25,984.55 45,720.61 Benefits 8,874.98 58,780.27 64,481.00 91.16% 6,422.81 49,598.82 2,452.17 9,181.45 Operations 15,890.03 170,349.74 212,718.00 80.08% 6,696.36 175,676.81 9,193.67 (5,327.07) Capital Outlay 4,800.00 234,712.00 520,000.00 45.14% ‐ ‐ 4,800.00 234,712.00 COVID‐19 ‐ 695.55 100.00% ‐ 586.88 ‐ 108.67 Total 92,645.83 776,441.38 1,129,552.00 68.74% 50,215.44 492,045.72 42,430.39 284,395.66 Police Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 917,614.91 4,666,693.82 5,753,608.00 81.11% 562,639.13 4,317,073.63 354,975.78 349,620.19 Benefits 125,592.75 928,131.78 1,114,150.00 83.30% 93,630.06 812,522.50 31,962.69 115,609.28 Operations 91,829.86 1,052,067.18 1,324,221.00 79.45% 48,825.50 941,365.31 43,004.36 110,701.87 Capital Outlay ‐ ‐ 6,229.00 0.00% ‐ 114,912.04 ‐ (114,912.04) COVID‐19 ‐ 54,437.46 100.00% 10,821.42 14,052.30 (10,821.42) 40,385.16 Total 1,135,037.52 6,701,330.24 8,198,208.00 81.74% 715,916.11 6,199,925.78 419,121.41 501,404.46 Fire Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 941,582.68 4,786,090.05 5,136,336.26 93.18% 574,196.12 4,229,436.92 367,386.56 556,653.13 Benefits 132,791.69 1,014,516.64 1,064,538.89 95.30% 100,619.79 850,891.89 32,171.90 163,624.75 Operations 73,954.96 797,221.14 1,097,908.00 72.61% 45,622.06 698,284.24 28,332.90 98,936.90 Capital Outlay ‐ 213,898.57 80,700.00 265.05% ‐ 29,990.00 ‐ 183,908.57 COVID‐19 ‐ 60,379.92 100.00% 7,438.46 15,989.88 (7,438.46) 44,390.04 Total 1,148,329.33 6,872,106.32 7,379,483.15 93.12% 727,876.43 5,824,592.93 420,452.90 1,047,513.39 Building Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 45,627.39 19,131.60 254,406.00 7.52% 28,207.20 206,730.43 17,420.19 (187,598.83) Benefits 6,611.10 3,433.31 51,631.00 6.65% 4,973.06 39,451.74 1,638.04 (36,018.43) Operations 2,296.99 1,002.56 67,450.00 1.49% 1,106.38 28,602.42 1,190.61 (27,599.86) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 54,535.48 23,567.47 373,487.00 6.31% 34,286.64 274,784.59 20,248.84 (251,217.12) Parks & Recreation Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 249,305.45 79,581.19 1,058,409.00 7.52% 158,031.78 882,158.69 91,273.67 (802,577.50) Benefits 29,897.66 12,609.31 192,383.00 6.55% 20,886.97 148,671.95 9,010.69 (136,062.64) Operations 75,940.28 91,585.04 1,316,238.00 6.96% 80,540.19 827,687.88 (4,599.91) (736,102.84) Capital Outlay/ Capital Projects ‐ 9,309.99 295,400.00 3.15% 13,850.00 88,862.11 (13,850.00) (79,552.12) COVID‐19 ‐ ‐ 100.00% 22,442.08 65,142.72 (22,442.08) (65,142.72) Total 355,143.39 193,085.53 2,862,430.00 6.75% 295,751.02 2,012,523.35 59,392.37 (1,819,437.82) Performing Arts Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 26,555.64 8,896.75 111,783.00 7.96% 12,037.82 96,148.38 14,517.82 (87,251.63) Benefits 3,342.88 1,383.82 18,332.00 7.55% 1,845.07 14,207.33 1,497.81 (12,823.51) Operations 36,324.18 6,445.93 255,640.00 2.52% 5,440.46 117,061.18 30,883.72 (110,615.25) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 23.96 100.00% 179.99 179.99 (179.99) (156.03) Total 66,222.70 16,750.46 385,755.00 4.34% 19,503.34 227,596.88 46,719.36 (210,846.42) Non‐Departmental Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference City ‐ County Svcs 87,083.33 422,916.67 430,000.00 98.35% 87,083.33 412,916.67 ‐ 10,000.00 Community Initiatives 142,845.22 500,968.05 928,801.00 53.94% 41,667.67 691,591.35 101,177.55 (190,623.30) 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 14,703,750.00 59.24% ‐ 3,299,833.47 ‐ 5,410,875.63 Transfer to DSF ‐ Other 92,941.47 558,667.08 558,667.00 100.00% 92,941.47 568,895.33 ‐ (10,228.25) Transfer to Group Health 252,500.00 2,529,344.00 3,034,344.00 83.36% 249,583.33 2,505,833.30 2,916.67 23,510.70 Transfer to Capital Project Fund ‐ ‐ 0.00% 75,000.00 124,870.02 (75,000.00) (124,870.02) Transfer to Sanitation Fund ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Transfer to Gas Tax Fund ‐ ‐ 42,723.00 0.00% 22,000.00 22,000.00 (22,000.00) (22,000.00) Transfer to Judicial ‐ ‐ 222,614.00 0.00% 121,793.88 121,793.88 (121,793.88) (121,793.88) Total 575,370.02 12,742,200.90 19,920,899.00 63.96% 690,069.68 7,747,734.02 (114,699.66) 4,994,466.88 Debt Service Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Debt Service 221,826.09 1,608,827.04 1,745,500.00 92.17% 194,710.00 1,396,368.02 27,116.09 212,459.02 Total 221,826.09 1,608,827.04 1,745,500.00 92.17% 194,710.00 1,396,368.02 27,116.09 212,459.02 Total Jul‐21 YTD Budget % of Budget Jul‐20 YTD July Difference YTD Difference Salary 3,001,927.77 13,557,726.52 16,840,797.26 80.51% 1,788,758.90 13,055,128.24 1,213,168.87 502,598.28 Benefits 659,150.37 5,199,718.32 6,709,115.89 77.50% 545,318.18 4,949,767.56 113,832.19 249,950.76 Operations 820,210.75 6,362,860.70 10,508,690.00 60.55% 758,928.87 6,819,899.32 61,281.88 (457,038.62) Capital Outlay 4,800.00 527,139.94 1,508,746.00 34.94% 13,850.00 553,597.23 (9,050.00) (26,457.29) Debt Service 314,767.56 10,878,203.22 17,007,917.00 63.96% 287,651.47 5,265,096.82 27,116.09 5,613,106.40 COVID‐19 ‐ 324,887.83 ‐ 100.00% 62,546.58 132,375.40 Total 4,800,856.45 36,850,536.53 52,575,266.15 70.09% 3,457,054.00 30,775,864.57 1,406,349.03 5,882,159.53 % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 69.47% Prepared by Daniel Oakley