Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
May 2021 - Council Expenditure Report
As of 6/14/2021 66.67 % Year Complete Executive May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 22,546.12 186,093.70 454,953.00 40.90% 20,222.52 176,868.32 2,323.60 9,225.38 Benefits 3,113.36 25,690.78 69,484.00 36.97% 2,539.79 22,467.12 573.57 3,223.66 Operations 21,743.27 98,065.82 266,400.00 36.81% 3,759.22 57,542.99 17,984.05 40,522.83 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 2,740.93 100.00% ‐ 2,740.93 Total 47,402.75 312,591.23 790,837.00 39.53% 26,521.53 256,878.43 20,881.22 55,712.80 Legislative May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 10,417.04 83,947.97 125,000.00 67.16% 10,417.04 83,336.32 ‐ 611.65 Benefits 760.98 6,464.39 10,306.00 62.72% 761.00 6,285.28 (0.02) 179.11 Operations 31.02 1,743.77 20,900.00 8.34% (625.21) 8,294.80 656.23 (6,551.03) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ Total 11,209.04 92,156.13 156,206.00 59.00% 10,552.83 97,916.40 656.21 (5,760.27) Finance May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 25,901.97 225,829.69 403,498.00 55.97% 24,756.90 212,782.84 1,145.07 13,046.85 Benefits 4,549.78 39,720.67 72,462.00 54.82% 3,980.18 34,597.80 569.60 5,122.87 Operations 29,559.96 259,041.23 237,750.00 108.96% 8,403.97 164,378.96 21,155.99 94,662.27 Capital Outlay ‐ 0.00% ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 60,011.71 524,591.59 713,710.00 73.50% 37,141.05 411,759.60 22,870.66 112,831.99 City Clerk May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 10,334.20 104,155.35 144,744.00 71.96% 10,810.91 87,566.39 (476.71) 16,588.96 Benefits 1,742.45 13,355.35 25,190.00 53.02% 1,746.92 14,430.46 (4.47) (1,075.11) Operations 5,766.47 27,630.10 51,670.00 53.47% 1,175.52 21,202.83 4,590.95 6,427.27 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 19.95 100.00% ‐ 19.95 Total 17,843.12 145,160.75 221,604.00 65.50% 13,733.35 123,199.68 4,109.77 21,961.07 HR May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 24,574.06 217,375.48 316,371.00 68.71% 23,408.24 201,670.69 1,165.82 15,704.79 Benefits 4,473.62 39,251.29 459,716.00 8.54% 4,118.59 36,048.19 355.03 3,203.10 Operations 1,824.22 30,356.36 91,025.00 33.35% 5,531.93 41,972.34 (3,707.71) (11,615.98) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ COVID‐19 ‐ 927.82 100.00% ‐ 927.82 Total 30,871.90 287,910.95 867,112.00 33.20% 33,058.76 279,691.22 (2,186.86) 8,219.73 IT May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 16,889.78 145,930.66 204,469.00 71.37% 14,649.96 125,610.15 2,239.82 20,320.51 Benefits 2,827.68 24,451.00 35,188.00 69.49% 2,192.98 19,058.49 634.70 5,392.51 Operations 145,690.99 1,346,041.73 1,808,147.00 74.44% 64,657.12 920,816.26 81,033.87 425,225.47 Capital Outlay ‐ 20,855.13 94,552.00 22.06% ‐ 94,038.13 ‐ (73,183.00) COVID‐19 2,258.23 135,787.53 100.00% 2,258.23 135,787.53 Total 167,666.68 1,673,066.05 2,142,356.00 78.09% 81,500.06 1,159,523.03 86,166.62 513,543.02 Vehicle Maint. May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 15,487.67 149,674.65 227,010.00 65.93% 17,434.84 147,896.27 (1,947.17) 1,778.38 Benefits 2,645.13 33,782.07 47,083.00 71.75% 2,866.91 30,540.14 (221.78) 3,241.93 Operations 1,472.81 43,722.39 98,150.00 44.55% 5,882.39 61,751.16 (4,409.58) (18,028.77) Capital Outlay ‐ ‐ 7,500.00 0.00% ‐ 35,240.95 ‐ (35,240.95) COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 19,605.61 227,179.11 379,743.00 59.82% 26,184.14 275,428.52 (6,578.53) (48,249.41) City of Prattville May 2021 Unaudited Expenditures By Department Engineering May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 41,846.30 346,104.64 541,734.00 63.89% 37,057.99 300,053.57 4,788.31 46,051.07 Benefits 7,476.54 80,096.32 113,070.00 70.84% 6,487.41 64,718.56 989.13 15,377.76 Operations 30,302.94 209,356.72 793,700.00 26.38% 23,148.75 229,835.23 7,154.19 (20,478.51) Capital Outlay ‐ ‐ 0.00% 86,388.00 99,138.00 (86,388.00) (99,138.00) COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 79,625.78 635,557.68 1,448,504.00 43.88% 153,082.15 693,745.36 (73,456.37) (58,187.68) Planning May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 31,386.54 266,984.44 404,595.00 65.99% 29,854.20 210,775.64 1,532.34 56,208.80 Benefits 5,722.42 49,107.21 76,496.00 64.20% 5,291.11 37,961.96 431.31 11,145.25 Operations 35,641.46 306,978.31 540,450.00 56.80% 54,956.47 353,902.20 (19,315.01) (46,923.89) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ COVID‐19 1,709.34 3,630.48 100.00% ‐ 1,709.34 3,630.48 Total 74,459.76 626,700.44 1,021,541.00 61.35% 90,101.78 602,639.80 (15,642.02) 24,060.64 Urban Management May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 73,441.01 655,896.20 990,654.00 66.21% 71,689.98 576,604.27 1,751.03 79,291.93 Benefits 12,492.43 135,738.77 193,188.00 70.26% 11,258.24 105,036.54 1,234.19 30,702.23 Operations 30,309.14 330,457.66 528,000.00 62.59% 23,822.93 293,795.08 6,486.21 36,662.58 Capital Outlay ‐ ‐ 81,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 116,242.58 1,122,092.63 1,792,842.00 62.59% 106,771.15 975,435.89 9,471.43 146,656.74 Facilities Maintenance May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 28,359.03 242,703.07 380,874.00 63.72% 27,162.81 234,893.03 1,196.22 7,810.04 Benefits 4,660.88 44,681.96 67,073.00 66.62% 4,139.20 39,257.45 521.68 5,424.51 Operations 3,616.47 105,351.22 222,550.00 47.34% 5,799.65 95,926.30 (2,183.18) 9,424.92 Capital Outlay ‐ ‐ 375,000.00 0.00% ‐ 91,416.00 ‐ (91,416.00) COVID‐19 ‐ 66,244.23 100.00% ‐ 66,244.23 Total 36,636.38 458,980.48 1,045,497.00 43.90% 37,101.66 461,492.78 (465.28) (2,512.30) Public Works May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 26,046.72 222,574.76 332,353.00 66.97% 24,460.24 204,633.87 1,586.48 17,940.89 Benefits 4,671.24 44,508.04 64,481.00 69.03% 4,194.49 38,441.56 476.75 6,066.48 Operations 9,763.94 143,453.32 212,718.00 67.44% 8,301.74 165,157.77 1,462.20 (21,704.45) Capital Outlay 173,140.00 220,312.00 520,000.00 42.37% ‐ 173,140.00 220,312.00 COVID‐19 ‐ 695.55 100.00% ‐ 695.55 Total 213,621.90 631,543.67 1,129,552.00 55.91% 36,956.47 408,233.20 176,665.43 223,310.47 Police May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 384,589.59 3,364,543.32 5,753,608.00 58.48% 385,868.05 3,377,936.36 (1,278.46) (13,393.04) Benefits 66,247.24 715,826.20 1,114,150.00 64.25% 62,622.66 652,022.78 3,624.58 63,803.42 Operations 71,668.04 873,668.27 1,324,221.00 65.98% 56,918.79 817,804.96 14,749.25 55,863.31 Capital Outlay ‐ ‐ 6,229.00 0.00% ‐ 114,912.04 ‐ (114,912.04) COVID‐19 ‐ 54,437.46 100.00% ‐ 54,437.46 Total 522,504.87 5,008,475.25 8,198,208.00 61.09% 505,409.50 4,962,676.14 17,095.37 45,799.11 Fire May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 375,782.36 3,434,211.42 5,136,336.26 66.86% 356,573.40 3,241,610.95 19,208.96 192,600.47 Benefits 67,513.76 783,757.98 1,064,538.89 73.62% 61,843.50 678,206.56 5,670.26 105,551.42 Operations 102,004.11 670,933.91 1,097,908.00 61.11% 100,321.74 611,515.72 1,682.37 59,418.19 Capital Outlay 473.00 213,898.57 80,700.00 265.05% 29,990.00 29,990.00 (29,517.00) 183,908.57 COVID‐19 ‐ 60,379.92 100.00% ‐ 60,379.92 Total 545,773.23 5,163,181.80 7,379,483.15 69.97% 548,728.64 4,561,323.23 (2,955.41) 601,858.57 Building May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 19,465.60 19,131.60 254,406.00 7.52% 18,804.80 159,718.43 660.80 (140,586.83) Benefits 3,494.94 3,433.31 51,631.00 6.65% 3,271.38 31,061.30 223.56 (27,627.99) Operations 988.68 1,002.56 67,450.00 1.49% 839.13 26,632.52 149.55 (25,629.96) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 23,949.22 23,567.47 373,487.00 6.31% 22,915.31 217,412.25 1,033.91 (193,844.78) Parks & Recreation May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 87,622.78 79,581.19 1,058,409.00 7.52% 74,566.17 641,539.33 13,056.61 (561,958.14) Benefits 13,632.76 12,609.31 192,383.00 6.55% 11,307.98 111,398.11 2,324.78 (98,788.80) Operations 120,269.61 91,585.04 1,316,238.00 6.96% 49,726.69 726,664.77 70,542.92 (635,079.73) Capital Outlay/ Capital Projects ‐ 9,309.99 295,400.00 3.15% 12,500.00 75,012.11 (12,500.00) (65,702.12) COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 221,525.15 193,085.53 2,862,430.00 6.75% 148,100.84 1,554,614.32 73,424.31 (1,361,528.79) Performing Arts May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 9,399.51 8,896.75 111,783.00 7.96% 8,409.12 75,586.97 990.39 (66,690.22) Benefits 1,455.03 1,383.82 18,332.00 7.55% 1,193.42 11,003.54 261.61 (9,619.72) Operations 6,752.99 6,445.93 255,640.00 2.52% 1,292.43 97,179.61 5,460.56 (90,733.68) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 23.96 100.00% ‐ 23.96 Total 17,607.53 16,750.46 385,755.00 4.34% 10,894.97 183,770.12 6,712.56 (167,019.66) Non‐Departmental May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference City ‐ County Svcs 7,083.33 328,750.01 430,000.00 76.45% ‐ 311,666.68 7,083.33 17,083.33 Community Initiatives 17,169.58 187,547.23 928,801.00 20.19% 58,160.63 591,299.19 (40,991.05) (403,751.96) 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 441,595.61 558,667.00 79.04% ‐ 451,328.86 ‐ (9,733.25) Transfer to Group Health 252,500.00 2,024,344.00 3,034,344.00 66.71% 249,583.33 2,006,666.64 2,916.67 17,677.36 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 276,752.91 11,712,541.95 14,002,149.00 83.65% 307,743.96 6,710,659.86 (30,991.05) 5,001,882.09 Debt Service May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Debt Service 139,711.56 1,277,950.62 1,745,500.00 73.21% 72,539.02 1,078,078.96 67,172.54 199,871.66 Total 139,711.56 1,277,950.62 1,745,500.00 73.21% 72,539.02 1,078,078.96 67,172.54 199,871.66 Total May‐21 YTD Budget % of Budget May‐20 YTD May Difference YTD Difference Salary 1,204,090.28 9,753,634.89 16,840,797.26 57.92% 1,156,147.17 10,059,083.40 47,943.11 (305,448.51) Benefits 459,980.24 4,078,202.47 6,709,115.89 60.79% 439,399.09 3,939,202.48 20,581.15 138,999.99 Operations 641,659.03 5,081,727.58 10,557,055.00 48.14% 472,073.89 5,647,204.39 169,585.14 (565,476.81) Capital Outlay 173,613.00 464,375.69 1,460,381.00 31.80% 128,878.00 539,747.23 44,735.00 (75,371.54) Debt Service 139,711.56 10,430,255.33 11,089,167.00 94.06% 72,539.02 4,829,241.29 67,172.54 5,601,014.04 COVID‐19 3,967.57 324,887.83 ‐ 100.00% Total 2,623,021.68 30,133,083.79 46,656,516.15 64.58% 2,269,037.17 25,014,478.79 350,016.94 4,793,717.17 % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 63.89% Prepared by Daniel Oakley