Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
February 2021 - Council Expense Report
As of 3/10/2021 41.67 % Year Complete Executive Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 22,940.68 119,639.53 454,953.00 26.30% 20,222.52 116,218.41 2,718.16 3,421.12 Benefits 3,474.27 16,522.37 69,484.00 23.78% 2,567.62 14,876.01 906.65 1,646.36 Operations 18,567.10 57,803.22 266,400.00 21.70% 15,073.94 45,711.78 3,493.16 12,091.44 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 412.40 2,740.93 100.00% 412.40 2,740.93 Total 45,394.45 196,706.05 790,837.00 24.87% 37,864.08 176,806.20 7,530.37 19,899.85 Legislative Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 10,417.04 52,696.85 125,000.00 42.16% 10,417.04 52,085.20 ‐ 611.65 Benefits 998.73 4,124.69 10,306.00 40.02% 804.18 4,002.28 194.55 122.41 Operations 40.00 504.77 20,900.00 2.42% 114.50 1,587.88 (74.50) (1,083.11) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ Total 11,455.77 57,326.31 156,206.00 36.70% 11,335.72 57,675.36 120.05 (349.05) Finance Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 27,365.96 148,002.66 403,498.00 36.68% 26,365.32 138,238.72 1,000.64 9,763.94 Benefits 5,193.21 26,021.20 72,462.00 35.91% 4,320.19 22,539.13 873.02 3,482.07 Operations 12,183.05 179,244.61 237,750.00 75.39% 10,346.99 115,606.46 1,836.06 63,638.15 Capital Outlay ‐ 0.00% ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 44,742.22 353,268.47 713,710.00 49.50% 41,032.50 276,384.31 3,709.72 76,884.16 City Clerk Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 14,060.11 65,805.02 144,744.00 45.46% 9,242.77 56,706.67 4,817.34 9,098.35 Benefits 1,607.50 7,886.93 25,190.00 31.31% 1,469.42 9,485.10 138.08 (1,598.17) Operations 4,030.46 14,088.39 51,670.00 27.27% 3,353.71 13,142.40 676.75 945.99 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 19.95 100.00% ‐ 19.95 Total 19,698.07 87,800.29 221,604.00 39.62% 14,065.90 79,334.17 5,632.17 8,466.12 HR Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 24,712.34 144,169.82 316,371.00 45.57% 23,986.48 130,849.15 725.86 13,320.67 Benefits 4,890.36 25,887.46 459,716.00 5.63% 4,238.39 23,497.73 651.97 2,389.73 Operations 4,120.05 19,176.97 91,025.00 21.07% 4,866.74 22,710.17 (746.69) (3,533.20) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ COVID‐19 ‐ 927.82 100.00% ‐ 927.82 Total 33,722.75 190,162.07 867,112.00 21.93% 33,091.61 177,057.05 631.14 13,105.02 IT Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 17,356.55 94,527.43 204,469.00 46.23% 15,057.32 80,748.27 2,299.23 13,779.16 Benefits 3,191.42 15,824.61 35,188.00 44.97% 2,265.57 12,339.84 925.85 3,484.77 Operations 183,893.86 878,826.50 1,808,147.00 48.60% 179,221.79 687,120.77 4,672.07 191,705.73 Capital Outlay ‐ ‐ 94,552.00 0.00% 60,422.73 94,038.13 (60,422.73) (94,038.13) COVID‐19 12,008.58 91,438.36 100.00% 12,008.58 91,438.36 Total 216,450.41 1,080,616.90 2,142,356.00 50.44% 256,967.41 874,247.01 (40,517.00) 206,369.89 Vehicle Maint. Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 17,382.66 103,731.84 227,010.00 45.69% 17,337.17 95,754.79 45.49 7,977.05 Benefits 13,103.71 25,953.23 47,083.00 55.12% 2,858.02 21,966.83 10,245.69 3,986.40 Operations 4,335.77 25,481.64 98,150.00 25.96% 4,103.27 36,536.54 232.50 (11,054.90) Capital Outlay ‐ ‐ 7,500.00 0.00% ‐ 8,580.00 ‐ (8,580.00) COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 34,822.14 155,166.71 379,743.00 40.86% 24,298.46 162,838.16 10,523.68 (7,671.45) City of Prattville February 2021 Unaudited Expenditures By Department Engineering Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 39,041.27 227,341.59 541,734.00 41.97% 33,125.31 192,242.09 5,915.96 35,099.50 Benefits 25,399.02 58,882.00 113,070.00 52.08% 5,912.02 45,853.17 19,487.00 13,028.83 Operations 20,283.88 112,742.38 793,700.00 14.20% 19,452.45 138,064.05 831.43 (25,321.67) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 84,724.17 398,965.97 1,448,504.00 27.54% 58,489.78 376,159.31 26,234.39 22,806.66 Planning Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 31,206.31 173,020.91 404,595.00 42.76% 22,243.82 128,620.99 8,962.49 44,399.92 Benefits 6,254.36 31,941.45 76,496.00 41.76% 3,835.82 23,191.64 2,418.54 8,749.81 Operations 44,974.90 193,876.13 540,450.00 35.87% 36,667.80 210,866.76 8,307.10 (16,990.63) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 82,435.57 398,838.49 1,021,541.00 39.04% 62,747.44 362,679.39 19,688.13 36,159.10 Urban Management Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 75,605.66 433,257.30 990,654.00 43.73% 68,158.35 369,081.13 7,447.31 64,176.17 Benefits 37,459.32 97,671.63 193,188.00 50.56% 11,095.57 71,899.11 26,363.75 25,772.52 Operations 53,470.79 229,319.96 528,000.00 43.43% 27,587.13 213,307.55 25,883.66 16,012.41 Capital Outlay ‐ ‐ 81,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 166,535.77 760,248.89 1,792,842.00 42.40% 106,841.05 654,287.79 59,694.72 105,961.10 Facilities Maintenance Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 28,065.84 158,067.47 380,874.00 41.50% 28,381.28 152,849.99 (315.44) 5,217.48 Benefits 9,611.81 30,719.37 67,073.00 45.80% 4,360.19 26,731.15 5,251.62 3,988.22 Operations 27,358.00 72,500.21 222,550.00 32.58% 21,067.80 62,260.87 6,290.20 10,239.34 Capital Outlay ‐ ‐ 375,000.00 0.00% 13,626.00 13,626.00 (13,626.00) (13,626.00) COVID‐19 26,530.80 66,109.74 100.00% 26,530.80 66,109.74 Total 91,566.45 327,396.79 1,045,497.00 31.31% 67,435.27 255,468.01 24,131.18 71,928.78 Public Works Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 26,010.33 144,926.24 332,353.00 43.61% 24,654.01 131,174.55 1,356.32 13,751.69 Benefits 9,497.80 30,553.75 64,481.00 47.38% 4,247.35 25,848.85 5,250.45 4,704.90 Operations 22,353.33 105,528.44 212,718.00 49.61% 21,755.81 125,088.45 597.52 (19,560.01) Capital Outlay ‐ ‐ 520,000.00 0.00% ‐ ‐ ‐ COVID‐19 ‐ 695.55 100.00% ‐ 695.55 Total 57,861.46 281,703.98 1,129,552.00 24.94% 50,657.17 282,111.85 7,204.29 (407.87) Police Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 382,607.39 2,217,006.09 5,753,608.00 38.53% 400,876.19 2,227,381.74 (18,268.80) (10,375.65) Benefits 205,227.37 518,051.97 1,114,150.00 46.50% 65,412.11 464,348.36 139,815.26 53,703.61 Operations 56,476.40 609,909.46 1,324,221.00 46.06% 43,295.66 617,560.63 13,180.74 (7,651.17) Capital Outlay ‐ ‐ 6,229.00 0.00% ‐ 96,140.92 ‐ (96,140.92) COVID‐19 63.84 54,437.46 100.00% 63.84 54,437.46 Total 644,375.00 3,399,404.98 8,198,208.00 41.47% 509,583.96 3,405,431.65 134,791.04 (6,026.67) Fire Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 361,148.76 2,305,429.88 5,114,439.00 45.08% 346,950.78 2,175,296.73 14,197.98 130,133.15 Benefits 235,942.06 580,566.60 1,059,303.00 54.81% 60,451.17 493,201.83 175,490.89 87,364.77 Operations 91,380.53 362,770.91 1,097,908.00 33.04% 63,180.95 358,857.08 28,199.58 3,913.83 Capital Outlay ‐ 176,548.62 80,700.00 218.77% ‐ ‐ ‐ 176,548.62 COVID‐19 (1,433.64) 60,379.92 100.00% (1,433.64) 60,379.92 Total 687,037.71 3,485,695.93 7,352,350.00 47.41% 470,582.90 3,027,355.64 216,454.81 458,340.29 Building Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 19,465.60 19,131.60 254,406.00 7.52% 18,804.81 103,149.94 660.79 (84,018.34) Benefits 8,090.66 3,433.31 51,631.00 6.65% 3,271.38 21,218.21 4,819.28 (17,784.90) Operations 3,077.04 1,002.56 67,450.00 1.49% 2,200.98 22,838.15 876.06 (21,835.59) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 30,633.30 23,567.47 373,487.00 6.31% 24,277.17 147,206.30 6,356.13 (123,638.83) Parks & Recreation Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 74,664.73 79,581.19 1,058,409.00 7.52% 76,129.12 408,877.49 (1,464.39) (329,296.30) Benefits 33,432.59 12,609.31 192,383.00 6.55% 11,942.47 75,994.72 21,490.12 (63,385.41) Operations 91,503.08 91,585.04 1,316,238.00 6.96% 113,899.24 449,486.96 (22,396.16) (357,901.92) Capital Outlay/ Capital Projects ‐ ‐ 295,400.00 0.00% ‐ 36,480.00 ‐ (36,480.00) COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 199,600.40 183,775.54 2,862,430.00 6.42% 201,970.83 970,839.17 (2,370.43) (787,063.63) Performing Arts Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 9,150.72 8,896.75 111,783.00 7.96% 9,546.15 48,911.09 (395.43) (40,014.34) Benefits 1,612.86 1,383.82 18,332.00 7.55% 1,363.96 7,203.99 248.90 (5,820.17) Operations 3,859.47 6,445.93 255,640.00 2.52% 13,352.96 65,319.48 (9,493.49) (58,873.55) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 23.96 100.00% ‐ 23.96 Total 14,623.05 16,750.46 385,755.00 4.34% 24,263.07 121,434.56 (9,640.02) (104,684.10) Non‐Departmental Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference City ‐ County Svcs 7,083.33 220,416.69 430,000.00 51.26% 7,083.33 212,500.02 ‐ 7,916.67 Community Initiatives 23,404.68 120,920.96 928,801.00 13.02% 52,878.45 403,728.81 (29,473.77) (282,807.85) Unprocessed JP Morgan Payment ‐ ‐ 100.00% ‐ ‐ ‐ ‐ Drug Proceeds Expenditures 6,229.00 6,992.00 ‐ 100.00% ‐ ‐ 6,229.00 6,992.00 Transfer to DSF ‐ One Cent 1,586,430.00 8,599,459.10 8,785,000.00 97.89% 1,249,727.94 3,174,833.47 336,702.06 5,424,625.63 Transfer to DSF ‐ Other 82,515.72 431,169.86 558,667.00 77.18% ‐ 358,387.39 82,515.72 72,782.47 Transfer to Group Health 252,500.00 1,262,500.00 3,030,000.00 41.67% 249,583.33 1,247,916.65 2,916.67 14,583.35 Transfer to Capital Project Fund ‐ ‐ 0.00% ‐ 10,772.24 ‐ (10,772.24) 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 1,958,162.73 10,641,458.61 13,997,805.00 76.02% 1,559,273.05 5,408,138.58 398,889.68 5,233,320.03 Debt Service Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Debt Service 317,318.89 825,604.01 1,745,500.00 47.30% 22,882.60 681,846.77 294,436.29 143,757.24 Total 317,318.89 825,604.01 1,745,500.00 47.30% 22,882.60 681,846.77 294,436.29 143,757.24 Total Feb‐21 YTD Budget % of Budget Feb‐20 YTD February Difference YTD Difference Salary 1,181,201.95 6,495,232.17 16,818,900.00 38.62% 1,151,498.44 6,608,186.95 29,703.51 (112,954.78) Benefits 857,487.05 2,750,533.70 6,699,536.00 41.06% 439,998.76 2,612,114.60 417,488.29 138,419.10 Operations 678,624.72 3,309,136.77 10,557,055.00 31.35% 639,503.50 3,813,067.05 39,121.22 (503,930.28) Capital Outlay ‐ 176,548.62 1,460,381.00 12.09% 74,048.73 248,865.05 (74,048.73) (72,316.43) Debt Service 1,986,264.61 9,856,232.97 11,089,167.00 88.88% 1,272,610.54 4,215,067.63 713,654.07 5,641,165.34 COVID‐19 37,581.98 276,773.69 ‐ 100.00% Total 4,741,160.31 22,864,457.92 46,625,039.00 49.04% 3,577,659.97 17,497,301.28 1,125,918.36 5,090,382.95 % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 48.45% Prepared by Daniel Oakley