Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
December 2021 - Council Expenditure Report
As of 1/18/2022 25.00 % Year Complete Executive Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 48,868.79 101,780.50 422,665.00 24.08% 36,448.77 75,139.64 12,420.02 26,640.86 Benefits 7,396.25 16,178.13 65,858.00 24.57% 4,904.30 10,095.84 2,491.95 6,082.29 Operations 14,373.76 46,502.58 294,213.00 15.81% 9,704.46 30,265.79 4,669.30 16,236.79 Capital Outlay ‐ 20,000.00 ‐ 100.00% ‐ ‐ ‐ 20,000.00 COVID‐19 ‐ ‐ ‐ ‐ 2,058.70 2,058.70 (2,058.70) (2,058.70) Total 70,638.80 184,461.21 782,736.00 23.57% 53,116.23 117,559.97 17,522.57 66,901.24 Legislative Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 10,417.04 31,251.12 125,000.00 25.00% 10,417.04 31,862.77 ‐ (611.65) Benefits 693.16 2,288.27 10,323.00 22.17% 760.98 2,371.78 (67.82) (83.51) Operations 440.50 856.32 30,400.00 2.82% 68.75 464.77 371.75 391.55 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 11,550.70 34,395.71 165,723.00 20.75% 11,246.77 34,699.32 303.93 (303.61) Finance Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 49,613.42 101,079.92 439,849.00 22.98% 43,701.64 92,248.46 5,911.78 8,831.46 Benefits 8,918.46 20,021.05 82,082.00 24.39% 7,312.68 15,851.23 1,605.78 4,169.82 Operations 13,481.83 28,573.63 252,820.00 11.30% 7,371.47 27,656.79 6,110.36 916.84 Capital Outlay ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 72,013.71 149,674.60 774,751.00 19.32% 58,385.79 135,756.48 13,627.92 13,918.12 City Clerk Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 14,962.52 32,326.79 124,042.00 26.06% 8,834.69 47,417.84 6,127.83 (15,091.05) Benefits 2,729.52 5,976.50 24,411.00 24.48% 1,007.75 5,827.39 1,721.77 149.11 Operations 6,239.08 23,414.04 80,170.00 29.21% 1,510.65 9,346.32 4,728.43 14,067.72 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ 19.95 ‐ (19.95) Total 23,931.12 61,717.33 228,623.00 27.00% 11,353.09 62,611.50 12,578.03 (894.17) HR Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 35,971.84 75,836.84 335,980.00 22.57% 48,481.73 94,810.12 (12,509.89) (18,973.28) Benefits 6,755.08 15,085.21 292,173.00 5.16% 7,917.84 16,505.52 (1,162.76) (1,420.31) Operations 8,864.13 18,644.79 95,600.00 19.50% 8,266.59 14,072.25 597.54 4,572.54 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% 427.91 859.85 (427.91) (859.85) Total 51,591.05 109,566.84 723,753.00 15.14% 65,094.07 126,247.74 (13,503.02) (16,680.90) IT Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 26,589.20 57,997.44 218,147.00 26.59% 29,063.03 60,919.59 (2,473.83) (2,922.15) Benefits 4,582.94 10,524.15 38,636.00 27.24% 4,571.41 9,914.36 11.53 609.79 Operations 222,649.29 629,620.28 1,721,197.00 36.58% 109,878.22 305,417.14 112,771.07 324,203.14 Capital Outlay 7,272.00 61,973.00 215,000.00 0.29 ‐ ‐ 7,272.00 61,973.00 COVID‐19 ‐ ‐ ‐ 1,067.62 42,839.54 (1,067.62) (42,839.54) Total 261,093.43 760,114.87 2,192,980.00 34.66% 144,580.28 419,090.63 116,513.15 341,024.24 Vehicle Maint. Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 26,807.86 56,399.81 234,957.00 24.00% 20,404.98 69,078.90 6,402.88 (12,679.09) Benefits 4,698.20 13,934.88 48,849.00 28.53% 3,524.05 9,910.04 1,174.15 4,024.84 Operations 2,429.47 11,681.69 101,650.00 11.49% 7,360.04 17,441.13 (4,930.57) (5,759.44) Capital Outlay ‐ ‐ 40,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 33,935.53 82,016.38 425,456.00 19.28% 31,289.07 96,430.07 2,646.46 (14,413.69) City of Prattville December 2021 Unaudited Expenditures By Department Engineering Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 66,289.17 135,926.04 619,777.00 21.93% 71,568.40 151,212.53 (5,279.23) (15,286.49) Benefits 12,270.24 33,524.63 138,019.00 24.29% 12,226.66 26,751.22 43.58 6,773.41 Operations 29,477.25 84,258.73 1,214,902.00 6.94% 13,438.99 80,423.69 16,038.26 3,835.04 Capital Outlay ‐ ‐ 100,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 108,036.66 253,709.40 2,072,698.00 12.24% 97,234.05 258,387.44 10,802.61 (4,678.04) Planning Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 49,155.78 103,069.47 426,880.00 24.14% 51,044.43 110,743.32 (1,888.65) (7,673.85) Benefits 9,208.41 20,766.56 81,800.00 25.39% 9,033.46 20,020.64 174.95 745.92 Operations 36,978.10 88,198.77 323,450.00 27.27% 36,984.01 113,870.49 (5.91) (25,671.72) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 95,342.29 212,034.80 832,130.00 25.48% 97,061.90 244,634.45 (1,719.61) (32,599.65) Urban Management Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 123,578.60 268,108.28 1,117,145.00 24.00% 127,517.25 279,506.66 (3,938.65) (11,398.38) Benefits 21,202.85 54,237.24 223,770.00 24.24% 21,663.80 47,078.76 (460.95) 7,158.48 Operations 35,492.38 117,665.66 560,500.00 20.99% 37,401.65 137,725.63 (1,909.27) (20,059.97) Capital Outlay ‐ ‐ 129,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 180,273.83 440,011.18 2,030,415.00 21.67% 186,582.70 464,311.05 (6,308.87) (24,299.87) Facilities Maintenance Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 44,866.57 94,786.22 397,866.00 23.82% 47,757.51 102,442.48 (2,890.94) (7,656.26) Benefits 7,626.64 18,547.57 81,396.00 22.79% 7,552.75 16,519.46 73.89 2,028.11 Operations 3,055.76 42,534.61 229,000.00 18.57% 5,384.68 39,362.84 (2,328.92) 3,171.77 Capital Outlay ‐ ‐ 455,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 55,548.97 155,868.40 1,163,262.00 13.40% 60,694.94 158,324.78 (5,145.97) (2,456.38) Public Works Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 40,901.48 84,727.21 355,055.00 23.86% 43,032.80 92,776.07 (2,131.32) (8,048.86) Benefits 7,552.42 18,394.42 71,937.00 25.57% 7,407.24 16,367.06 145.18 2,027.36 Operations 10,490.73 71,087.68 327,718.00 21.69% 20,139.90 72,473.99 (9,649.17) (1,386.31) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 58,944.63 174,209.31 754,710.00 23.08% 70,579.94 181,617.12 (11,635.31) (7,407.81) Police Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 731,452.99 1,490,652.23 6,205,541.00 24.02% 689,058.40 1,438,260.64 42,394.59 52,391.59 Benefits 129,750.77 324,454.22 1,280,084.00 25.35% 114,637.57 244,375.62 15,113.20 80,078.60 Operations 68,113.56 419,742.74 1,563,261.00 26.85% 42,200.19 235,769.29 25,913.37 183,973.45 Capital Outlay ‐ ‐ 526,102.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 367.64 4,791.38 (367.64) (4,791.38) Total 929,317.32 2,234,849.19 9,574,988.00 23.34% 846,263.80 1,923,196.93 83,053.52 311,652.26 Fire Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 702,635.75 1,387,141.33 5,687,258.00 24.39% 733,778.95 1,489,773.92 (31,143.20) (102,632.59) Benefits 130,244.18 330,296.56 1,211,167.00 27.27% 129,220.72 265,744.66 1,023.46 64,551.90 Operations 66,332.68 202,872.18 1,126,017.00 18.02% 52,922.18 217,460.28 13,410.50 (14,588.10) Capital Outlay ‐ ‐ 900,000.00 ‐ 176,548.62 176,548.62 (176,548.62) (176,548.62) COVID‐19 ‐ ‐ ‐ 51,438.94 57,133.40 (51,438.94) (57,133.40) Total 899,212.61 1,920,310.07 8,924,442.00 21.52% 1,143,909.41 2,206,660.88 (244,696.80) (286,350.81) Building Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 30,903.54 66,278.58 267,629.00 24.77% 30,199.45 19,131.60 704.09 47,146.98 Benefits 5,761.38 14,537.82 56,692.00 25.64% 5,495.41 3,433.31 265.97 11,104.51 Operations 964.39 12,043.91 67,450.00 17.86% 1,054.27 1,002.56 (89.88) 11,041.35 Capital Outlay ‐ ‐ 26,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 37,629.31 92,860.31 417,771.00 22.23% 36,749.13 23,567.47 880.18 69,292.84 Parks & Recreation Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 127,700.17 271,601.82 1,132,797.00 23.98% 119,485.79 79,581.19 8,214.38 192,020.63 Benefits 21,124.01 54,252.11 216,697.00 25.04% 18,992.71 12,609.31 2,131.30 41,642.80 Operations 47,278.42 193,709.84 1,230,438.00 15.74% 73,112.51 91,585.04 (25,834.09) 102,124.80 Capital Outlay/ Capital Projects ‐ ‐ 488,000.00 ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 196,102.60 519,563.77 3,067,932.00 16.94% 211,591.01 183,775.54 (15,488.41) 335,788.23 Performing Arts Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 19,620.08 36,970.95 137,849.00 26.82% 14,563.82 32,615.74 5,056.26 4,355.21 Benefits 3,425.73 6,774.38 24,304.00 27.87% 2,277.04 5,135.89 1,148.69 1,638.49 Operations 13,861.11 47,717.80 254,820.00 18.73% 9,066.80 23,661.17 4,794.31 24,056.63 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 23.96 23.96 (23.96) (23.96) Total 36,906.92 91,463.13 416,973.00 21.94% 25,931.62 61,436.76 10,975.30 30,026.37 Non‐Departmental Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference City ‐ County Svcs ‐ 101,249.99 432,000.00 23.44% 101,250.02 101,250.02 (101,250.02) (0.03) Community Initiatives 58,100.93 603,249.84 1,240,839.00 48.62% 42,886.29 58,895.67 15,214.64 544,354.17 Unprocessed JP Morgan Payment ‐ ‐ ‐ 100.00% ‐ ‐ ‐ ‐ Drug Proceeds Expenditures ‐ ‐ ‐ 100.00% 565.00 763.00 (565.00) (763.00) Transfer to DSF ‐ One Cent ‐ Infras ‐ 92,941.47 573,819.00 16.20% ‐ 1,623,029.10 ‐ (1,530,087.63) Transfer to DSF ‐ Other ‐ 123,311.20 123,311.00 100.00% ‐ 216,252.67 ‐ (92,941.47) Transfer to Group Health 274,750.00 824,250.00 3,297,000.00 25.00% 252,500.00 757,500.00 22,250.00 66,750.00 Transfer to Capital Project Fund ‐ ‐ 2,790,260.00 ‐ ‐ ‐ ‐ ‐ Transfer to Wasewater Fund ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Sanitation Fund ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Gas Tax Fund ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfer to Judicial ‐ ‐ 261,287.00 ‐ ‐ ‐ ‐ ‐ Total 332,850.93 1,921,018.70 8,718,516.00 22.03% 397,201.31 2,757,690.46 (64,350.38) (1,012,687.96) Debt Service Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Debt Service 118,770.25 186,311.05 2,134,891.00 8.73% 104,025.49 259,569.98 14,744.76 (73,258.93) Total 118,770.25 186,311.05 2,134,891.00 8.73% 104,025.49 259,569.98 14,744.76 (73,258.93) Total Dec‐21 YTD Budget % of Budget Dec‐20 YTD December Difference YTD Difference Salary 2,150,334.80 4,395,934.55 18,248,437.00 24.09% 2,125,358.68 4,267,521.47 24,976.12 128,413.08 Benefits 658,690.24 1,784,043.70 7,245,198.00 24.62% 611,006.37 1,486,012.09 47,683.87 298,031.61 Operations 638,623.37 2,743,625.08 14,197,992.00 19.32% 580,566.67 1,578,907.86 58,056.70 1,164,717.22 Capital Outlay 7,272.00 81,973.00 2,879,102.00 2.85% 176,548.62 176,548.62 (169,276.62) (94,575.62) Debt Service 118,770.25 402,563.72 2,832,021.00 14.21% 104,025.49 2,098,851.75 14,744.76 (1,696,288.03) COVID‐19 ‐ ‐ ‐ ‐ 55,384.77 107,726.78 Total 3,573,690.66 9,408,140.05 45,402,750.00 20.72% 3,652,890.60 9,715,568.57 (23,815.17) (199,701.74) % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 20.72% Prepared by Daniel Oakley