Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
August 2021 - Council Expenditure Report
As of 9/17/2021 91.67 % Year Complete Executive Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 29,011.68 289,519.27 454,953.00 63.64% 18,526.92 244,939.69 10,484.76 44,579.58 Benefits 4,212.44 39,336.18 69,484.00 56.61% 2,238.89 30,907.87 1,973.55 8,428.31 Operations 7,270.15 148,361.76 218,035.00 68.04% 4,831.59 73,213.06 2,438.56 75,148.70 Capital Outlay ‐ 48,364.25 48,365.00 100.00% ‐ ‐ ‐ 48,364.25 COVID‐19 ‐ 2,740.93 100.00% ‐ 824.04 ‐ 1,916.89 Total 40,494.27 528,322.39 790,837.00 66.81% 25,597.40 349,884.66 14,896.87 178,437.73 Legislative Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 10,417.04 115,199.09 125,000.00 92.16% 9,153.18 113,323.58 1,263.86 1,875.51 Benefits 736.34 8,662.37 10,306.00 84.05% 692.13 8,585.05 44.21 77.32 Operations 2,058.70 6,201.60 20,900.00 29.67% 106.00 4,423.22 1,952.70 1,778.38 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 19.95 4,059.68 (19.95) (4,059.68) Total 13,212.08 130,063.06 156,206.00 83.26% 9,971.26 130,391.53 3,240.82 (328.47) Finance Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 33,443.80 352,310.17 403,498.00 87.31% 24,224.43 298,354.65 9,219.37 53,955.52 Benefits 5,784.04 59,532.49 72,462.00 82.16% 3,948.77 48,784.07 1,835.27 10,748.42 Operations 14,338.84 229,897.76 237,750.00 96.70% 8,433.88 204,156.32 5,904.96 25,741.44 Capital Outlay ‐ 0.00% ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% 152.76 342.20 (152.76) (342.20) Total 53,566.68 641,740.42 713,710.00 89.92% 36,759.84 551,637.24 16,806.84 90,103.18 City Clerk Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 6,827.11 138,351.71 144,744.00 95.58% 11,424.53 125,059.86 (4,597.42) 13,291.85 Benefits 787.11 17,785.84 25,190.00 70.61% 1,892.17 20,735.64 (1,105.06) (2,949.80) Operations 767.32 39,691.88 51,670.00 76.82% 24,887.90 59,227.32 (24,120.58) (19,535.44) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 19.95 100.00% 1,801.90 10,656.82 (1,801.90) (10,636.87) Total 8,381.54 195,849.38 221,604.00 88.38% 40,006.50 215,679.64 (31,624.96) (19,830.26) HR Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 24,850.67 323,691.94 316,371.00 102.31% 23,073.55 282,248.61 1,777.12 41,443.33 Benefits 4,525.69 56,600.69 459,716.00 12.31% 4,032.74 50,449.22 492.95 6,151.47 Operations 3,599.88 46,621.54 91,025.00 51.22% 891.91 48,093.97 2,707.97 (1,472.43) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 927.82 100.00% 806.89 9,609.20 (806.89) (8,681.38) Total 32,976.24 427,841.99 867,112.00 49.34% 28,805.09 390,401.00 4,171.15 37,440.99 IT Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 17,191.81 218,565.54 204,469.00 106.89% 16,002.76 180,381.01 1,189.05 38,184.53 Benefits 2,879.20 35,582.04 35,188.00 101.12% 2,400.23 27,386.01 478.97 8,196.03 Operations 121,059.17 1,700,584.33 1,808,147.00 94.05% 82,487.63 1,136,369.55 38,571.54 564,214.78 Capital Outlay ‐ 20,855.13 94,552.00 22.06% ‐ 94,038.13 ‐ (73,183.00) COVID‐19 ‐ 135,787.53 100.00% 192,932.72 206,300.39 (192,932.72) (70,512.86) Total 141,130.18 2,111,374.57 2,142,356.00 98.55% 293,823.34 1,644,475.09 (152,693.16) 466,899.48 Vehicle Maint. Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 17,244.88 227,460.71 227,010.00 100.20% 16,598.11 208,046.83 646.77 19,413.88 Benefits 2,922.34 46,779.82 47,083.00 99.36% 2,684.64 41,723.43 237.70 5,056.39 Operations 4,299.38 59,704.11 98,150.00 60.83% 4,239.01 77,434.47 60.37 (17,730.36) Capital Outlay ‐ ‐ 7,500.00 0.00% ‐ 35,240.95 ‐ (35,240.95) COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 24,466.60 333,944.64 379,743.00 87.94% 23,521.76 362,445.68 944.84 (28,501.04) City of Prattville August 2021 Unaudited Expenditures By Department Engineering Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 42,586.69 535,308.37 541,734.00 98.81% 40,054.90 432,473.38 2,531.79 102,834.99 Benefits 7,651.65 112,682.84 113,070.00 99.66% 6,944.04 90,079.78 707.61 22,603.06 Operations 27,306.95 317,056.53 793,700.00 39.95% 14,513.72 289,056.33 12,793.23 28,000.20 Capital Outlay ‐ ‐ 0.00% 197,517.31 296,655.31 (197,517.31) (296,655.31) COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 77,545.29 965,047.74 1,448,504.00 66.62% 259,029.97 1,108,264.80 (181,484.68) (143,217.06) Planning Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 31,509.34 405,278.25 404,595.00 100.17% 29,744.21 314,753.22 1,765.13 90,525.03 Benefits 5,745.76 71,463.49 76,496.00 93.42% 5,270.46 56,532.50 475.30 14,930.99 Operations 42,065.33 450,773.78 540,450.00 83.41% 44,325.05 522,494.58 (2,259.72) (71,720.80) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 3,630.48 100.00% ‐ ‐ ‐ 3,630.48 Total 79,320.43 931,146.00 1,021,541.00 91.15% 79,339.72 893,780.30 (19.29) 37,365.70 Urban Management Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 76,777.90 1,019,701.75 990,654.00 102.93% 74,738.83 818,443.96 2,039.07 201,257.79 Benefits 12,788.21 191,195.22 193,188.00 98.97% 11,535.04 144,741.78 1,253.17 46,453.44 Operations 36,878.02 433,668.58 528,000.00 82.13% 31,959.96 373,830.50 4,918.06 59,838.08 Capital Outlay 18,952.54 18,952.54 81,000.00 23.40% ‐ ‐ 18,952.54 18,952.54 COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 145,396.67 1,663,518.09 1,792,842.00 92.79% 118,233.83 1,337,016.24 27,162.84 326,501.85 Facilities Maintenance Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 28,479.51 378,382.92 380,874.00 99.35% 27,143.30 330,056.91 1,336.21 48,326.01 Benefits 4,699.23 64,630.22 67,073.00 96.36% 4,146.23 54,450.02 553.00 10,180.20 Operations 23,804.56 151,594.82 222,550.00 68.12% 19,516.05 127,942.94 4,288.51 23,651.88 Capital Outlay ‐ ‐ 375,000.00 0.00% ‐ 91,416.00 ‐ (91,416.00) COVID‐19 ‐ 66,244.23 100.00% ‐ 345.52 ‐ 65,898.71 Total 56,983.30 660,852.19 1,045,497.00 63.21% 50,805.58 604,211.39 6,177.72 56,640.80 Public Works Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 25,982.46 337,886.28 332,353.00 101.66% 24,557.16 290,740.37 1,425.30 47,145.91 Benefits 4,656.22 63,436.49 64,481.00 98.38% 4,213.86 53,812.68 442.36 9,623.81 Operations 6,492.49 176,842.23 212,718.00 83.13% 5,321.58 180,998.39 1,170.91 (4,156.16) Capital Outlay 9,600.00 244,312.00 520,000.00 46.98% ‐ ‐ 9,600.00 244,312.00 COVID‐19 ‐ 695.55 100.00% ‐ 586.88 ‐ 108.67 Total 46,731.17 823,172.55 1,129,552.00 72.88% 34,092.60 526,138.32 12,638.57 297,034.23 Police Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 397,043.98 5,063,737.80 5,753,608.00 88.01% 375,015.37 4,692,089.00 22,028.61 371,648.80 Benefits 68,809.89 996,941.67 1,114,150.00 89.48% 59,580.49 872,102.99 9,229.40 124,838.68 Operations 50,753.34 1,102,820.52 1,324,221.00 83.28% 36,159.90 977,525.21 14,593.44 125,295.31 Capital Outlay ‐ ‐ 6,229.00 0.00% ‐ 114,912.04 ‐ (114,912.04) COVID‐19 ‐ 54,437.46 100.00% 1,860.82 15,913.12 (1,860.82) 38,524.34 Total 516,607.21 7,217,937.45 8,198,208.00 88.04% 472,616.58 6,672,542.36 43,990.63 545,395.09 Fire Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 374,927.31 5,161,017.36 5,136,336.26 100.48% 376,684.97 4,606,121.89 (1,757.66) 554,895.47 Benefits 67,253.23 1,081,769.87 1,064,538.89 101.62% 64,296.51 915,188.40 2,956.72 166,581.47 Operations 84,088.81 881,309.95 1,097,908.00 80.27% 70,451.76 768,736.00 13,637.05 112,573.95 Capital Outlay ‐ 213,898.57 112,405.10 190.29% ‐ 29,990.00 ‐ 183,908.57 COVID‐19 ‐ 60,379.92 100.00% 912.12 16,902.00 (912.12) 43,477.92 Total 526,269.35 7,398,375.67 7,411,188.25 99.83% 512,345.36 6,336,938.29 13,923.99 1,061,437.38 Building Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 19,918.71 250,690.48 254,406.00 98.54% 18,804.80 225,535.23 1,113.91 25,155.25 Benefits 3,576.71 48,846.74 51,631.00 94.61% 3,271.38 42,723.12 305.33 6,123.62 Operations 2,380.31 27,996.92 67,450.00 41.51% 2,087.94 30,690.36 292.37 (2,693.44) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 25,875.73 327,534.14 373,487.00 87.70% 24,164.12 298,948.71 1,711.61 28,585.43 Parks & Recreation Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 84,497.76 1,098,999.93 1,058,409.00 103.84% 96,862.62 979,021.31 (12,364.86) 119,978.62 Benefits 13,475.26 190,123.69 192,383.00 98.83% 13,486.11 162,158.06 (10.85) 27,965.63 Operations 93,477.75 1,042,393.33 1,316,238.00 79.19% 91,158.76 918,846.64 2,318.99 123,546.69 Capital Outlay/ Capital Projects 20,601.59 29,911.58 295,400.00 10.13% ‐ 88,862.11 20,601.59 (58,950.53) COVID‐19 ‐ 209.95 100.00% 1,561.41 66,704.13 (1,561.41) (66,494.18) Total 212,052.36 2,361,638.48 2,862,430.00 82.50% 203,068.90 2,215,592.25 8,983.46 146,046.23 Performing Arts Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 10,162.97 126,923.60 111,783.00 113.54% 8,271.51 104,419.89 1,891.46 22,503.71 Benefits 1,573.17 19,264.56 18,332.00 105.09% 1,268.10 15,475.43 305.07 3,789.13 Operations 14,617.37 121,582.76 255,640.00 47.56% 3,218.91 120,280.09 11,398.46 1,302.67 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 23.96 100.00% ‐ 179.99 ‐ (156.03) Total 26,353.51 267,794.88 385,755.00 69.42% 12,758.52 240,355.40 13,594.99 27,439.48 Non‐Departmental Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference City ‐ County Svcs 7,083.33 430,000.00 430,000.00 100.00% ‐ 412,916.67 7,083.33 17,083.33 Community Initiatives 39,402.68 540,370.73 928,801.00 58.18% 41,667.67 733,259.02 (2,264.99) (192,888.29) Unprocessed JP Morgan Payment 145,161.53 145,161.53 ‐ 100.00% ‐ ‐ 145,161.53 145,161.53 Drug Proceeds Expenditures 19,596.00 ‐ 100.00% ‐ ‐ ‐ 19,596.00 Transfer to DSF ‐ One Cent 5,910,875.00 14,621,584.10 14,703,750.00 99.44% 85,747.02 3,385,580.49 5,825,127.98 11,236,003.61 Transfer to DSF ‐ Other 558,667.08 558,667.00 100.00% ‐ 568,895.33 ‐ (10,228.25) Transfer to Group Health 252,500.00 2,781,844.00 3,034,344.00 91.68% 249,583.33 2,755,416.63 2,916.67 26,427.37 Transfer to Capital Project Fund 661,900.00 661,900.00 0.00% 500,000.00 624,870.02 161,900.00 37,029.98 Transfer to Sanitation Fund ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Transfer to Gas Tax Fund 42,723.04 42,723.04 42,723.00 100.00% ‐ 22,000.00 42,723.04 20,723.04 Transfer to Judicial 222,614.18 222,614.18 222,614.00 100.00% ‐ 121,793.88 222,614.18 100,820.30 Total 7,282,259.76 20,024,460.66 19,920,899.00 100.52% 876,998.02 8,624,732.04 6,405,261.74 11,399,728.62 Debt Service Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Debt Service 138,651.26 1,747,478.30 1,745,500.00 100.11% 96,913.15 1,493,281.17 41,738.11 254,197.13 Total 138,651.26 1,747,478.30 1,745,500.00 100.11% 96,913.15 1,493,281.17 41,738.11 254,197.13 Total Aug‐21 YTD Budget % of Budget Aug‐20 YTD August Difference YTD Difference Salary 1,230,873.62 16,043,025.17 16,840,797.26 95.26% 1,190,881.15 14,246,009.39 39,992.47 1,797,015.78 Benefits 464,576.49 5,886,478.22 6,709,115.89 87.74% 441,485.12 5,391,252.68 23,091.37 495,225.54 Operations 1,654,143.13 8,956,744.84 10,508,690.00 85.23% 986,259.22 7,806,158.54 667,883.91 1,150,586.30 Capital Outlay 49,154.13 576,294.07 1,540,451.10 37.41% 197,517.31 751,114.54 (148,363.18) (174,820.47) Debt Service 6,049,526.26 16,927,729.48 17,007,917.00 99.53% 182,660.17 5,447,756.99 5,866,866.09 11,479,972.49 COVID‐19 ‐ 325,097.78 ‐ 100.00% 200,048.57 332,423.97 Total 9,448,273.63 48,715,369.56 52,606,971.25 92.60% 3,198,851.54 33,974,716.11 6,449,470.66 14,747,979.64 % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 91.98% Prepared by Daniel Oakley