Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
December 2020 - Council Expenditure Report
As of 1/15/2021 25.00 % Year Complete Executive Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 36,448.77 75,139.64 454,953.00 16.52% 20,204.86 65,383.04 16,243.91 9,756.60 Benefits 4,904.30 10,095.84 69,484.00 14.53% 2,495.47 8,236.79 2,408.83 1,859.05 Operations 8,750.01 29,311.34 266,400.00 11.00% 3,608.98 26,049.88 5,141.03 3,261.46 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 0.00% ‐ ‐ Total 50,103.08 114,546.82 790,837.00 14.48% 26,309.31 99,669.71 23,793.77 14,877.11 Legislative Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 10,417.04 31,862.77 125,000.00 25.49% 10,417.04 31,251.12 ‐ 611.65 Benefits 760.98 2,371.78 10,306.00 23.01% 761.00 2,269.80 (0.02) 101.98 Operations ‐ 396.02 20,900.00 1.89% 225.00 1,508.38 (225.00) (1,112.36) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ ‐ ‐ Total 11,178.02 34,630.57 156,206.00 22.17% 11,403.04 35,029.30 (225.02) (398.73) Finance Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 43,701.64 92,248.46 403,498.00 22.86% 24,898.64 73,391.02 18,803.00 18,857.44 Benefits 7,312.68 15,851.23 72,462.00 21.88% 4,045.61 11,646.43 3,267.07 4,204.80 Operations 5,935.17 26,220.49 237,750.00 11.03% 11,777.24 35,822.86 (5,842.07) (9,602.37) Capital Outlay ‐ 0.00% ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 56,949.49 134,320.18 713,710.00 18.82% 40,721.49 120,860.31 16,228.00 13,459.87 City Clerk Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 8,834.69 47,417.84 144,744.00 32.76% 10,825.53 32,205.87 (1,990.84) 15,211.97 Benefits 1,007.75 5,827.39 25,190.00 23.13% 1,747.10 5,288.15 (739.35) 539.24 Operations 7,835.67 51,670.00 15.16% 3,004.80 7,297.75 (3,004.80) 537.92 Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ 19.95 100.00% ‐ 19.95 Total 9,842.44 61,100.85 221,604.00 27.57% 15,577.43 44,791.77 (5,734.99) 16,309.08 HR Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 48,481.73 94,810.12 316,371.00 29.97% 23,656.55 70,870.36 24,825.18 23,939.76 Benefits 7,917.84 16,505.52 459,716.00 3.59% 4,156.29 12,591.96 3,761.55 3,913.56 Operations 7,350.00 13,155.66 91,025.00 14.45% 7,832.13 16,198.72 (482.13) (3,043.06) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ COVID‐19 ‐ 431.94 100.00% ‐ 431.94 Total 63,749.57 124,903.24 867,112.00 14.40% 35,644.97 99,661.04 28,104.60 25,242.20 IT Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 29,063.03 60,919.59 204,469.00 29.79% 14,963.08 43,512.33 14,099.95 17,407.26 Benefits 4,571.41 9,914.36 35,188.00 28.18% 2,240.94 6,527.95 2,330.47 3,386.41 Operations 83,484.10 279,023.02 1,775,647.00 15.71% 189,535.35 426,690.54 (106,051.25) (147,667.52) Capital Outlay ‐ ‐ 75,000.00 0.00% 6,390.50 6,390.50 (6,390.50) (6,390.50) COVID‐19 ‐ 41,771.92 100.00% ‐ 41,771.92 Total 117,118.54 391,628.89 2,090,304.00 18.74% 213,129.87 483,121.32 (96,011.33) (91,492.43) Vehicle Maint. Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 20,404.98 69,078.90 227,010.00 30.43% 17,946.40 52,259.76 2,458.58 16,819.14 Benefits 3,524.05 9,910.04 47,083.00 21.05% 2,954.57 8,661.80 569.48 1,248.24 Operations 1,655.34 11,736.43 98,150.00 11.96% 5,236.95 28,636.14 (3,581.61) (16,899.71) Capital Outlay ‐ ‐ 7,500.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 25,584.37 90,725.37 379,743.00 23.89% 26,137.92 89,557.70 (553.55) 1,167.67 City of Prattville December 2020 Unaudited Expenditures By Department Engineering Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 71,568.40 151,212.53 541,734.00 27.91% 34,290.60 109,004.33 37,277.80 42,208.20 Benefits 12,226.66 26,751.22 113,070.00 23.66% 6,022.74 18,994.72 6,203.92 7,756.50 Operations 4,233.05 71,217.75 793,700.00 8.97% 15,343.13 104,165.57 (11,110.08) (32,947.82) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 88,028.11 249,181.50 1,448,504.00 17.20% 55,656.47 232,164.62 32,371.64 17,016.88 Planning Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 51,044.43 110,743.32 404,595.00 27.37% 25,974.88 72,012.87 25,069.55 38,730.45 Benefits 9,033.46 20,020.64 76,496.00 26.17% 4,563.24 12,818.75 4,470.22 7,201.89 Operations 35,362.50 112,248.98 540,450.00 20.77% 36,733.80 134,706.71 (1,371.30) (22,457.73) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ ‐ Total 95,440.39 243,012.94 1,021,541.00 23.79% 67,271.92 219,538.33 28,168.47 23,474.61 Urban Management Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 127,517.25 279,506.66 990,654.00 28.21% 70,168.47 198,407.36 57,348.78 81,099.30 Benefits 21,663.80 47,078.76 193,188.00 24.37% 11,218.70 31,828.45 10,445.10 15,250.31 Operations 10,653.95 110,977.93 528,000.00 21.02% 29,278.70 139,224.09 (18,624.75) (28,246.16) Capital Outlay ‐ ‐ 81,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 159,835.00 437,563.35 1,792,842.00 24.41% 110,665.87 369,459.90 49,169.13 68,103.45 Facilities Maintenance Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 47,757.51 102,442.48 380,874.00 26.90% 28,070.13 82,872.15 19,687.38 19,570.33 Benefits 7,552.75 16,519.46 67,073.00 24.63% 4,310.19 12,734.15 3,242.56 3,785.31 Operations 1,206.10 35,184.26 222,550.00 15.81% 4,544.99 35,194.38 (3,338.89) (10.12) Capital Outlay ‐ ‐ 375,000.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 56,516.36 154,146.20 1,045,497.00 14.74% 36,925.31 130,800.68 19,591.05 23,345.52 Public Works Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 43,032.80 92,776.07 332,353.00 27.91% 24,555.73 69,749.14 18,477.07 23,026.93 Benefits 7,407.24 16,367.06 64,481.00 25.38% 4,210.07 12,048.18 3,197.17 4,318.88 Operations 12,964.30 65,298.39 212,718.00 30.70% 18,622.79 57,992.54 (5,658.49) 7,305.85 Capital Outlay ‐ ‐ 520,000.00 0.00% 6,210.00 6,210.00 (6,210.00) (6,210.00) COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 63,404.34 174,441.52 1,129,552.00 15.44% 53,598.59 145,999.86 9,805.75 28,441.66 Police Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 689,058.40 1,438,260.64 5,753,608.00 25.00% 422,459.47 1,230,040.68 266,598.93 208,219.96 Benefits 114,637.57 244,375.62 1,114,150.00 21.93% 70,628.71 203,505.85 44,008.86 40,869.77 Operations 18,794.97 212,364.07 1,324,221.00 16.04% 245,404.35 526,225.06 (226,609.38) (313,860.99) Capital Outlay ‐ ‐ 6,229.00 0.00% 64,124.28 64,124.28 (64,124.28) (64,124.28) COVID‐19 ‐ 4,423.74 100.00% ‐ 4,423.74 Total 822,490.94 1,899,424.07 8,198,208.00 23.17% 802,616.81 2,023,895.87 19,874.13 (124,471.80) Fire Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 733,778.95 1,489,773.92 5,114,439.00 29.13% 406,606.07 1,196,883.37 327,172.88 292,890.55 Benefits 129,220.72 265,744.66 1,059,303.00 25.09% 71,205.66 207,224.20 58,015.06 58,520.46 Operations 22,509.35 187,047.45 1,097,908.00 17.04% 35,584.80 196,903.26 (13,075.45) (9,855.81) Capital Outlay 176,548.62 176,548.62 80,700.00 218.77% ‐ ‐ 176,548.62 176,548.62 COVID‐19 ‐ 5,694.46 100.00% ‐ 5,694.46 Total 1,062,057.64 2,124,809.11 7,352,350.00 28.90% 513,396.53 1,601,010.83 548,661.11 523,798.28 Building Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 30,199.45 19,131.60 254,406.00 7.52% 18,804.81 56,137.92 11,394.64 (37,006.32) Benefits 5,495.41 3,433.31 51,631.00 6.65% 3,271.38 9,843.27 2,224.03 (6,409.96) Operations 751.50 1,002.56 67,450.00 1.49% 912.44 19,973.15 (160.94) (18,970.59) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 36,446.36 23,567.47 373,487.00 6.31% 22,988.63 85,954.34 13,457.73 (62,386.87) Parks & Recreation Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 119,485.79 79,581.19 1,058,409.00 7.52% 77,370.70 227,617.13 42,115.09 (148,035.94) Benefits 18,992.71 12,609.31 192,383.00 6.55% 12,130.16 35,407.43 6,862.55 (22,798.12) Operations 56,002.27 91,585.04 1,316,238.00 6.96% 71,912.53 286,102.41 (15,910.26) (194,517.37) Capital Outlay/ Capital Projects ‐ ‐ 295,400.00 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 194,480.77 183,775.54 2,862,430.00 6.42% 161,413.39 549,126.97 33,067.38 (365,351.43) Performing Arts Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 14,563.82 8,896.75 111,783.00 7.96% 9,178.97 26,160.64 5,384.85 (17,263.89) Benefits 2,277.04 1,383.82 18,332.00 7.55% 1,308.88 3,813.63 968.16 (2,429.81) Operations 6,624.73 6,445.93 255,640.00 2.52% 15,460.22 39,371.40 (8,835.49) (32,925.47) Capital Outlay ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ 100.00% ‐ ‐ Total 23,465.59 16,726.50 385,755.00 4.34% 25,948.07 69,345.67 (2,482.48) (52,619.17) Non‐Departmental Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference City ‐ County Svcs 101,250.02 101,250.02 430,000.00 23.55% 17,083.34 118,333.36 84,166.68 (17,083.34) Community Initiatives 42,886.29 58,895.67 928,801.00 6.34% 110,952.86 287,731.58 (68,066.57) (228,835.91) Unprocessed JP Morgan Payment 323,127.42 323,127.42 ‐ 100.00% ‐ ‐ 323,127.42 323,127.42 Drug Proceeds Expenditures 565.00 763.00 ‐ 100.00% ‐ ‐ 565.00 763.00 Transfer to DSF ‐ One Cent ‐ 1,623,029.10 8,785,000.00 18.48% ‐ 1,925,105.53 ‐ (302,076.43) Transfer to DSF ‐ Other ‐ 216,252.67 558,667.00 38.71% ‐ 225,490.92 ‐ (9,238.25) Transfer to Group Health 252,500.00 757,500.00 3,030,000.00 25.00% 249,583.33 748,749.99 2,916.67 8,750.01 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 720,328.73 3,080,817.88 13,997,805.00 22.01% 377,619.53 3,316,183.62 342,709.20 (235,365.74) Debt Service Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Debt Service 104,025.49 259,569.98 1,745,500.00 14.87% 188,411.76 444,286.51 (84,386.27) (184,716.53) Total 104,025.49 259,569.98 1,745,500.00 14.87% 188,411.76 444,286.51 (84,386.27) (184,716.53) Total Dec‐20 YTD Budget % of Budget Dec‐19 YTD December Difference YTD Difference Salary 2,125,358.68 4,243,802.48 16,818,900.00 25.23% 1,240,391.93 3,637,759.09 884,966.75 606,043.39 Benefits 611,006.37 1,482,260.02 6,699,536.00 22.12% 456,854.04 1,352,191.50 154,152.33 130,068.52 Operations 744,106.07 1,745,087.10 10,524,555.00 16.58% 823,054.40 2,498,900.02 (78,948.33) (753,812.92) Capital Outlay 176,548.62 176,548.62 1,440,829.00 12.25% 76,724.78 76,724.78 99,823.84 99,823.84 Debt Service 104,025.49 2,098,851.75 11,089,167.00 18.93% 188,411.76 2,594,882.96 (84,386.27) (496,031.21) COVID‐19 ‐ 52,342.01 ‐ 100.00% Total 3,761,045.23 9,798,891.98 46,572,987.00 21.04% 2,785,436.91 10,160,458.35 975,608.32 (413,908.38) % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 20.93% Prepared by Daniel Oakley