Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
September 2021 - Council Expenditure Report
As of 10/15/2021 100.00 % Year Complete Executive Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 26,248.74 315,768.01 454,953.00 69.41% 18,526.92 263,466.61 7,721.82 52,301.40 Benefits 4,001.08 43,337.26 69,484.00 62.37% 2,236.08 33,143.95 1,765.00 10,193.31 Operations 13,141.91 162,977.52 218,035.00 74.75% 8,773.27 81,986.33 4,368.64 80,991.19 Capital Outlay ‐ 48,364.25 1,348,365.00 3.59% ‐ ‐ ‐ 48,364.25 COVID‐19 2,695.00 5,435.93 100.00% 2,251.20 3,075.24 443.80 2,360.69 Total 46,086.73 575,882.97 2,090,837.00 27.54% 31,787.47 381,672.13 14,299.26 194,210.84 Legislative Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 10,417.04 125,616.13 125,000.00 100.49% 10,417.04 123,740.62 ‐ 1,875.51 Benefits 736.34 9,398.71 10,306.00 91.20% 782.02 9,367.07 (45.68) 31.64 Operations 76.72 6,278.32 20,900.00 30.04% 369.00 4,792.22 (292.28) 1,486.10 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 19.95 4,079.63 (19.95) (4,079.63) Total 11,230.10 141,293.16 156,206.00 90.45% 11,588.01 141,979.54 (357.91) (686.38) Finance Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 28,145.19 380,455.36 403,498.00 94.29% 24,224.44 322,579.09 3,920.75 57,876.27 Benefits 5,329.66 64,862.15 72,462.00 89.51% 3,950.61 52,734.68 1,379.05 12,127.47 Operations 13,144.29 243,967.02 237,750.00 102.61% 9,954.36 214,110.68 3,189.93 29,856.34 Capital Outlay ‐ 0.00% ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% 21.97 364.17 (21.97) (364.17) Total 46,619.14 689,284.53 713,710.00 96.58% 38,151.38 589,788.62 8,467.76 99,495.91 City Clerk Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 4,960.28 143,311.99 144,744.00 99.01% 9,018.43 134,078.29 (4,058.15) 9,233.70 Benefits 796.64 18,582.48 25,190.00 73.77% 1,664.18 22,399.82 (867.54) (3,817.34) Operations 8,816.93 50,631.67 51,670.00 97.99% 27,570.28 86,797.60 (18,753.35) (36,165.93) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 19.95 100.00% (6,005.02) 4,651.80 6,005.02 (4,631.85) Total 14,573.85 212,546.09 221,604.00 95.91% 32,247.87 247,927.51 (17,674.02) (35,381.42) HR Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 15,551.01 339,242.95 1,733,045.00 19.57% 23,007.62 305,256.23 (7,456.61) 33,986.72 Benefits 169,561.10 226,161.79 459,716.00 49.20% 4,051.54 54,500.76 165,509.56 171,661.03 Operations 9,683.65 58,648.73 91,025.00 64.43% 8,053.20 56,147.17 1,630.45 2,501.56 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 927.82 100.00% 92.15 9,701.35 (92.15) (8,773.53) Total 194,795.76 624,981.29 2,283,786.00 27.37% 35,204.51 425,605.51 159,591.25 199,375.78 IT Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 13,581.18 232,146.72 204,469.00 113.54% 15,686.60 196,067.61 (2,105.42) 36,079.11 Benefits 2,596.02 38,178.06 35,188.00 108.50% 2,351.80 29,737.81 244.22 8,440.25 Operations 69,679.98 1,778,353.45 1,808,147.00 98.35% 117,629.89 1,253,999.44 (47,949.91) 524,354.01 Capital Outlay ‐ 20,855.13 94,552.00 22.06% ‐ 94,038.13 ‐ (73,183.00) COVID‐19 ‐ 135,787.53 100.00% 268,482.10 474,782.49 (268,482.10) (338,994.96) Total 85,857.18 2,205,320.89 2,142,356.00 102.94% 404,150.39 2,048,625.48 (318,293.21) 156,695.41 Vehicle Maint. Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 17,370.98 244,831.69 227,010.00 107.85% 14,154.00 222,200.83 3,216.98 22,630.86 Benefits 2,943.87 49,723.69 47,083.00 105.61% 2,362.06 44,085.49 581.81 5,638.20 Operations 537.67 61,470.21 98,150.00 62.63% 6,217.79 83,652.26 (5,680.12) (22,182.05) Capital Outlay ‐ ‐ 7,500.00 0.00% ‐ 35,240.95 ‐ (35,240.95) COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 20,852.52 356,025.59 379,743.00 93.75% 22,733.85 385,179.53 (1,881.33) (29,153.94) City of Prattville September 2021 Unaudited Expenditures By Department Engineering Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 34,714.24 570,022.61 541,734.00 105.22% 40,549.43 473,022.81 (5,835.19) 96,999.80 Benefits 7,010.98 119,693.82 113,070.00 105.86% 7,031.17 97,110.95 (20.19) 22,582.87 Operations 83,296.29 408,092.90 663,848.88 61.47% 75,506.16 364,562.49 7,790.13 43,530.41 Capital Outlay 129,851.12 129,851.12 129,851.12 0.00% ‐ 296,655.31 129,851.12 (166,804.19) COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 254,872.63 1,227,660.45 1,448,504.00 84.75% 123,086.76 1,231,351.56 131,785.87 (3,691.11) Planning Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 28,237.01 433,515.26 404,595.00 107.15% 29,864.32 344,617.54 (1,627.31) 88,897.72 Benefits 5,505.56 76,969.05 76,496.00 100.62% 5,293.02 61,825.52 212.54 15,143.53 Operations 42,960.50 498,872.19 540,450.00 92.31% 83,270.77 605,765.35 (40,310.27) (106,893.16) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 3,630.48 100.00% 7,181.89 7,181.89 (7,181.89) (3,551.41) Total 76,703.07 1,012,986.98 1,021,541.00 99.16% 125,610.00 1,019,390.30 (48,906.93) (6,403.32) Urban Management Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 73,440.35 1,093,142.10 990,654.00 110.35% 75,332.53 893,776.49 (1,892.18) 199,365.61 Benefits 12,864.28 204,059.50 193,188.00 105.63% 11,763.99 156,505.77 1,100.29 47,553.73 Operations 46,827.95 494,336.86 528,000.00 93.62% 42,526.31 416,356.81 4,301.64 77,980.05 Capital Outlay ‐ 18,952.54 81,000.00 23.40% ‐ ‐ ‐ 18,952.54 COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 133,132.58 1,810,491.00 1,792,842.00 100.98% 129,622.83 1,466,639.07 3,509.75 343,851.93 Facilities Maintenance Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 24,285.87 402,668.79 380,874.00 105.72% 27,264.70 357,321.61 (2,978.83) 45,347.18 Benefits 4,394.05 69,024.27 67,073.00 102.91% 4,163.39 58,613.41 230.66 10,410.86 Operations 2,176.35 156,899.63 222,550.00 70.50% 8,502.40 136,445.34 (6,326.05) 20,454.29 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 30,856.27 694,836.92 1,045,497.00 66.46% 39,930.49 644,141.88 (9,074.22) 50,695.04 Public Works Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 22,445.66 360,331.94 332,353.00 108.42% 24,517.05 315,257.42 (2,071.39) 45,074.52 Benefits 4,385.66 67,822.15 64,481.00 105.18% 4,206.87 58,019.55 178.79 9,802.60 Operations 5,510.00 187,400.36 212,718.00 88.10% 21,426.10 202,424.49 (15,916.10) (15,024.13) Capital Outlay 9,600.00 253,912.00 885,019.00 28.69% ‐ ‐ 9,600.00 253,912.00 COVID‐19 ‐ 695.55 100.00% ‐ 586.88 ‐ 108.67 Total 41,941.32 870,162.00 1,494,571.00 58.22% 50,150.02 576,288.34 (8,208.70) 293,873.66 Police Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 361,952.34 5,425,690.14 5,453,608.00 99.49% 365,708.99 5,057,797.99 (3,756.65) 367,892.15 Benefits 67,683.28 1,064,624.95 1,114,150.00 95.55% 60,573.80 932,676.79 7,109.48 131,948.16 Operations 68,743.34 1,183,824.36 1,324,221.00 89.40% 141,386.56 1,118,911.77 (72,643.22) 64,912.59 Capital Outlay 12,604.00 12,604.00 405,396.52 3.11% ‐ 114,912.04 12,604.00 (102,308.04) COVID‐19 124,353.17 178,790.63 100.00% 465.65 16,378.77 123,887.52 162,411.86 Total 635,336.13 7,865,534.08 8,297,375.52 94.80% 568,135.00 7,240,677.36 67,201.13 624,856.72 Fire Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 365,315.02 5,526,332.38 5,136,336.26 107.59% 389,701.17 4,995,823.06 (24,386.15) 530,509.32 Benefits 69,702.94 1,151,472.81 1,064,538.89 108.17% 67,652.29 982,840.69 2,050.65 168,632.12 Operations 40,857.55 948,531.86 1,097,908.00 86.39% 54,977.50 823,713.50 (14,119.95) 124,818.36 Capital Outlay 41,946.10 268,540.15 112,405.10 238.90% ‐ 29,990.00 41,946.10 238,550.15 COVID‐19 ‐ 60,379.92 100.00% 1,242.96 18,144.96 (1,242.96) 42,234.96 Total 517,821.61 7,955,257.12 7,411,188.25 107.34% 513,573.92 6,850,512.21 4,247.69 1,104,744.91 Building Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 19,852.80 270,543.28 254,406.00 106.34% 18,804.80 244,340.03 1,048.00 26,203.25 Benefits 3,566.70 52,413.44 51,631.00 101.52% 3,271.38 45,994.50 295.32 6,418.94 Operations 4,218.04 32,479.22 67,450.00 48.15% 1,469.10 32,159.46 2,748.94 319.76 Capital Outlay ‐ ‐ 0.00% 35,025.00 35,025.00 (35,025.00) (35,025.00) COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 27,637.54 355,435.94 373,487.00 95.17% 58,570.28 357,518.99 (30,932.74) (2,083.05) Parks & Recreation Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 67,234.32 1,166,234.25 1,058,409.00 110.19% 77,742.09 1,056,763.40 (10,507.77) 109,470.85 Benefits 12,092.59 202,216.28 192,383.00 105.11% 11,981.74 174,139.80 110.85 28,076.48 Operations 162,779.53 1,221,108.48 1,316,238.00 92.77% 109,396.59 1,028,243.23 53,382.94 192,865.25 Capital Outlay/ Capital Projects 37,699.24 67,610.82 1,345,400.00 5.03% 95,162.67 184,024.78 (57,463.43) (116,413.96) COVID‐19 2,695.00 2,904.95 100.00% 6,707.54 73,411.67 (4,012.54) (70,506.72) Total 282,500.68 2,660,074.78 3,912,430.00 67.99% 300,990.63 2,516,582.88 (18,489.95) 143,491.90 Performing Arts Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 9,705.74 136,629.34 111,783.00 122.23% 8,228.49 112,648.38 1,477.25 23,980.96 Benefits 1,519.55 20,784.11 18,332.00 113.38% 1,211.97 16,687.40 307.58 4,096.71 Operations 17,562.63 146,238.33 255,640.00 57.20% 10,789.63 131,069.72 6,773.00 15,168.61 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 2,695.00 2,718.96 100.00% ‐ 179.99 2,695.00 2,538.97 Total 31,482.92 306,370.74 385,755.00 79.42% 20,230.09 260,585.49 11,252.83 45,785.25 Non‐Departmental Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference City ‐ County Svcs ‐ 430,000.00 430,000.00 100.00% 7,083.33 420,000.00 (7,083.33) 10,000.00 Community Initiatives 16,666.67 557,037.40 1,005,601.00 55.39% 41,666.67 774,925.69 (25,000.00) (217,888.29) Unprocessed JP Morgan Payment 150,095.08 150,095.08 ‐ 100.00% ‐ ‐ 150,095.08 150,095.08 Drug Proceeds Expenditures (12,604.00) 6,992.00 ‐ 100.00% ‐ ‐ (12,604.00) 6,992.00 Transfer to DSF ‐ One Cent ‐ 14,621,584.10 14,703,750.00 99.44% ‐ 3,385,580.49 ‐ 11,236,003.61 Transfer to DSF ‐ Other ‐ 558,667.08 558,667.00 100.00% 39,092.78 607,988.11 (39,092.78) (49,321.03) Transfer to Group Health 252,500.00 3,034,344.00 3,034,344.00 100.00% 514,583.33 3,269,999.96 (262,083.33) (235,655.96) Transfer to Capital Project Fund ‐ 661,900.00 ‐ 100.00% 560,907.22 1,185,777.24 (560,907.22) (523,877.24) Transfer to Wasewater Fund 111,162.96 ‐ ‐ #DIV/0! Transfer to Sanitation Fund 703,786.63 703,786.63 ‐ #DIV/0! 873.13 873.13 702,913.50 702,913.50 Transfer to Gas Tax Fund ‐ 42,723.04 42,723.00 100.00% 175,663.79 197,663.79 (175,663.79) (154,940.75) Transfer to Judicial 19,377.00 241,991.18 222,614.00 108.70% ‐ 121,793.88 19,377.00 120,197.30 Total 1,240,984.34 21,120,283.47 19,997,699.00 105.61% 1,339,870.25 9,964,602.29 (210,048.87) 11,044,518.22 Debt Service Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Debt Service 180,545.59 1,928,023.89 1,745,500.00 110.46% 200,857.11 1,694,138.28 (20,311.52) 233,885.61 Total 180,545.59 1,928,023.89 1,745,500.00 110.46% 200,857.11 1,694,138.28 (20,311.52) 233,885.61 Total Sep‐21 YTD Budget % of Budget Sep‐20 YTD September Difference YTD Difference Salary 1,123,457.77 17,166,482.94 17,957,471.26 95.60% 1,172,748.62 15,418,758.01 (49,290.85) 1,747,724.93 Benefits 627,190.30 6,513,668.52 6,709,115.89 97.09% 709,131.24 6,100,383.92 (81,940.94) 413,284.60 Operations 1,578,497.67 10,434,636.44 10,455,638.88 99.80% 1,514,013.05 9,143,634.67 64,484.62 1,291,001.77 Capital Outlay 231,700.46 820,690.01 4,784,488.74 17.15% 130,187.67 881,302.21 101,512.79 (60,612.20) Debt Service 180,545.59 17,108,275.07 17,007,917.00 100.59% 239,949.89 5,687,706.88 (59,404.30) 11,420,568.19 COVID‐19 132,438.17 457,535.95 ‐ 100.00% 280,460.39 612,884.36 Total 3,873,829.96 52,501,288.93 56,914,631.77 92.25% 4,046,490.86 37,844,670.05 (24,638.68) 14,811,967.29 % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 91.44% Prepared by Daniel Oakley