Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
June 2020 - Council Expenditure Report
As of 7/14/2020 75.00 % Year Complete Executive Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 20,307.30 197,175.62 284,622.67 69.28% 22,756.09 199,413.03 (2,448.79) (2,237.41) Benefits 2,559.61 25,026.73 43,490.97 57.54% 2,895.99 25,173.17 (336.38) (146.44) Operations 5,999.53 63,542.52 162,775.00 39.04% 3,730.44 83,170.06 2,269.09 (19,627.54) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 28,866.44 285,744.87 490,888.64 58.21% 29,382.52 307,756.26 (516.08) (22,011.39) Legislative Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 10,417.04 93,753.36 125,000.00 75.00% 10,417.04 93,753.36 ‐ ‐ Benefits 818.82 7,104.10 10,299.00 68.98% 750.86 6,973.51 67.96 130.59 Operations 62.15 8,356.95 13,300.00 62.83% 140.13 11,322.35 (77.98) (2,965.40) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 11,298.01 109,214.41 148,599.00 73.50% 11,308.03 112,049.22 (10.02) (2,834.81) Finance Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 24,975.47 237,758.31 360,253.00 66.00% 23,176.47 208,419.86 1,799.00 29,338.45 Benefits 4,181.03 38,778.83 60,616.00 63.97% 3,802.31 35,089.61 378.72 3,689.22 Operations 8,553.37 172,932.33 240,360.00 71.95% 11,037.16 186,876.21 (2,483.79) (13,943.88) Capital Outlay ‐ ‐ 0.00% ‐ ‐ Total 37,709.87 449,469.47 661,229.00 67.97% 38,015.94 430,385.68 (306.07) 19,083.79 City Clerk Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 10,810.91 98,377.30 139,619.00 70.46% 10,568.10 94,309.75 242.81 4,067.55 Benefits 1,830.92 16,261.38 24,068.00 67.56% 1,668.41 15,460.93 162.51 800.45 Operations 1,262.10 22,464.93 108,240.00 20.75% 3,524.21 23,343.71 (2,262.11) (878.78) Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 13,903.93 137,103.61 271,927.00 50.42% 15,760.72 133,114.39 (1,856.79) 3,989.22 HR Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 22,984.87 224,655.56 308,420.00 72.84% 23,101.85 203,493.60 (116.98) 21,161.96 Benefits 4,213.99 40,262.18 56,426.00 71.35% 4,039.81 36,880.65 174.18 3,381.53 Operations 3,404.85 45,377.19 72,275.00 62.78% 10,826.43 51,878.79 (7,421.58) (6,501.60) Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 30,603.71 310,294.93 437,121.00 70.99% 37,968.09 292,253.04 (7,364.38) 18,041.89 IT Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 15,163.72 140,773.87 195,466.00 72.02% 13,242.27 120,669.62 1,921.45 20,104.25 Benefits 2,362.49 21,420.98 30,262.00 70.79% 1,976.28 18,504.87 386.21 2,916.11 Operations 68,907.81 989,724.07 1,371,831.00 72.15% 77,510.83 1,031,100.24 (8,603.02) (41,376.17) Capital Outlay ‐ 94,038.13 200,000.00 47.02% ‐ 33,515.00 ‐ 60,523.13 Total 86,434.02 1,245,957.05 1,797,559.00 69.31% 92,729.38 1,203,789.73 (6,295.36) 42,167.32 Vehicle Maint. Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 17,365.20 165,261.47 228,594.00 72.29% 15,464.81 177,932.16 1,900.39 (12,670.69) Benefits 4,147.87 34,688.01 43,245.00 80.21% 2,311.13 35,139.88 1,836.74 (451.87) Operations 6,017.61 67,768.77 98,650.00 68.70% 5,895.20 41,347.14 122.41 26,421.63 Capital Outlay ‐ 35,240.95 37,000.00 95.25% ‐ ‐ ‐ 35,240.95 Total 27,530.68 302,959.20 407,489.00 74.35% 23,671.14 254,419.18 3,859.54 48,540.02 City of Prattville June 2020 Unaudited Expenditures By Department Engineering Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 36,940.38 336,993.95 552,052.00 61.04% 35,875.38 338,374.30 1,065.00 (1,380.35) Benefits 8,639.30 73,357.86 113,511.00 64.63% 6,208.97 73,930.08 2,430.33 (572.22) Operations 29,739.17 259,574.40 566,300.00 45.84% 14,581.10 249,095.90 15,158.07 10,478.50 Capital Outlay ‐ 99,138.00 333,718.00 0.00% ‐ ‐ ‐ 99,138.00 Total 75,318.85 769,064.21 1,565,581.00 49.12% 56,665.45 661,400.28 18,653.40 107,663.93 Planning Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 29,703.70 240,479.34 347,578.47 69.19% 21,245.39 148,869.05 8,458.31 91,610.29 Benefits 5,386.74 43,348.70 67,357.73 64.36% 3,813.63 27,600.42 1,573.11 15,748.28 Operations 73,590.53 427,492.73 727,450.00 58.77% 40,396.16 316,595.27 33,194.37 110,897.46 Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 108,680.97 711,320.77 1,142,386.20 62.27% 65,455.18 493,064.74 43,225.79 218,256.03 Urban Management Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 67,025.28 643,629.55 927,120.00 69.42% 61,812.69 507,227.10 5,212.59 136,402.45 Benefits 11,969.86 117,006.40 167,371.00 69.91% 9,126.57 96,196.71 2,843.29 20,809.69 Operations 21,847.37 315,642.45 493,000.00 64.02% 28,727.00 321,435.23 (6,879.63) (5,792.78) Capital Outlay ‐ ‐ 30,000.00 0.00% ‐ 41,845.00 ‐ (41,845.00) Total 100,842.51 1,076,278.40 1,617,491.00 66.54% 99,666.26 966,704.04 1,176.25 109,574.36 Facilities Maintenance Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 27,095.04 261,988.07 363,631.00 72.05% 25,559.92 232,761.74 1,535.12 29,226.33 Benefits 4,720.32 43,977.77 59,507.00 73.90% 3,838.30 39,449.70 882.02 4,528.07 Operations 2,852.88 98,779.18 194,210.00 50.86% 3,719.18 98,208.13 (866.30) 571.05 Capital Outlay ‐ 91,416.00 91,466.00 99.95% 2,042.16 18,404.72 (2,042.16) 73,011.28 Total 34,668.24 496,161.02 708,814.00 70.00% 35,159.56 388,824.29 (491.32) 107,336.73 Public Works Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 24,453.07 229,086.94 312,653.00 73.27% 19,274.27 182,312.12 5,178.80 46,774.82 Benefits 4,734.45 43,176.01 58,569.00 73.72% 3,282.95 34,847.66 1,451.50 8,328.35 Operations 4,409.56 169,567.33 224,718.00 75.46% 7,178.00 160,421.32 (2,768.44) 9,146.01 Capital Outlay ‐ ‐ 225,000.00 0.00% ‐ (3,390.00) ‐ 3,390.00 Total 33,597.08 441,830.28 820,940.00 53.82% 29,735.22 374,191.10 3,861.86 67,639.18 Police Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 376,498.14 3,754,434.50 5,557,043.00 67.56% 368,223.45 3,424,615.51 8,274.69 329,818.99 Benefits 66,869.66 718,892.44 1,044,030.00 68.86% 60,532.89 674,011.76 6,336.77 44,880.68 Operations 77,965.73 895,770.69 1,425,809.00 62.83% 105,908.32 963,875.49 (27,942.59) (68,104.80) Capital Outlay ‐ 114,912.04 133,600.00 86.01% ‐ 122,314.38 ‐ (7,402.34) Total 521,333.53 5,484,009.67 8,160,482.00 67.20% 534,664.66 5,184,817.14 (13,331.13) 299,192.53 Fire Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 413,629.85 3,655,240.80 5,047,501.00 72.42% 348,949.61 3,225,949.59 64,680.24 429,291.21 Benefits 72,065.54 750,272.10 1,012,418.00 74.11% 58,445.95 684,510.99 13,619.59 65,761.11 Operations 49,697.88 661,213.60 1,044,321.00 63.32% 34,953.08 705,023.85 14,744.80 (43,810.25) Capital Outlay ‐ 29,990.00 29,990.00 0.00% 195,464.00 445,444.00 (195,464.00) (415,454.00) Total 535,393.27 5,096,716.50 7,134,230.00 71.44% 637,812.64 5,060,928.43 (102,419.37) 35,788.07 Building Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 18,804.80 178,523.23 244,473.00 73.02% 17,604.80 206,418.76 1,200.00 (27,895.53) Benefits 3,417.38 34,478.68 49,214.00 70.06% 3,000.95 40,115.30 416.43 (5,636.62) Operations 863.52 27,496.04 55,450.00 49.59% 1,669.99 31,806.61 (806.47) (4,310.57) Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 23,085.70 240,497.95 349,137.00 68.88% 22,275.74 278,340.67 809.96 (37,842.72) Parks & Recreation Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 82,587.58 724,126.91 1,005,486.00 72.02% 92,321.44 599,051.81 (9,733.86) 125,075.10 Benefits 16,386.87 127,784.98 169,471.00 75.40% 12,266.12 105,442.82 4,120.75 22,342.16 Operations 63,183.56 789,848.33 1,174,070.00 67.27% 127,671.69 758,657.48 (64,488.13) 31,190.85 Capital Outlay/ Capital Projects ‐ 75,012.11 243,583.00 30.80% ‐ 494,760.83 ‐ (419,748.72) Total 162,158.01 1,716,772.33 2,592,610.00 66.22% 232,259.25 1,957,912.94 (70,101.24) (241,140.61) Performing Arts Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 8,523.59 84,110.56 106,627.00 78.88% 7,765.74 64,801.93 757.85 19,308.63 Benefits 1,358.72 12,362.26 15,770.00 78.39% 1,117.51 10,039.85 241.21 2,322.41 Operations 14,441.11 111,620.72 266,690.00 41.85% 29,013.95 143,282.52 (14,572.84) (31,661.80) Capital Outlay ‐ ‐ ‐ 0.00% ‐ 10,514.00 ‐ (10,514.00) Total 24,323.42 208,093.54 389,087.00 53.48% 37,897.20 228,638.30 (13,573.78) (20,544.76) Non‐Departmental Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference City ‐ County Svcs 14,166.66 325,833.34 425,000.00 76.67% 6,666.66 319,166.68 7,500.00 6,666.66 Community Initiatives 58,624.49 649,923.68 979,274.00 66.37% 51,665.68 630,431.02 6,958.81 19,492.66 Transfer to DSF ‐ One Cent ‐ 3,299,833.47 3,394,441.00 97.21% ‐ 3,335,185.58 ‐ (35,352.11) Transfer to DSF ‐ Other 24,625.00 475,953.86 664,029.00 71.68% ‐ 116,093.42 24,625.00 359,860.44 Transfer to Group Health 249,583.33 2,256,249.97 2,995,000.00 75.33% 247,167.00 2,224,503.00 2,416.33 31,746.97 Transfer to Capital Project Fund 5.00 49,870.02 75,000.00 66.49% 11,158.03 374,453.91 (11,153.03) (324,583.89) Transfer to Sanitation Fund 21,307.00 0.00% ‐ ‐ ‐ ‐ Transfer to Gas Tax Fund ‐ ‐ 22,000.00 0.00% ‐ ‐ ‐ ‐ Transfer to Judicial ‐ 121,794.00 0.00% ‐ ‐ ‐ ‐ Total 347,004.48 7,057,664.34 8,697,845.00 81.14% 316,657.37 6,999,833.61 30,347.11 57,830.73 Debt Service Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Debt Service 123,579.06 1,201,658.02 1,728,000.00 69.54% 119,847.25 1,226,694.53 3,731.81 (25,036.51) Total 123,579.06 1,201,658.02 1,728,000.00 69.54% 119,847.25 1,226,694.53 3,731.81 (25,036.51) Total Jun‐20 YTD Budget % of Budget Jun‐19 YTD June Difference YTD Difference Salary 1,207,285.94 11,266,369.34 16,106,139.14 69.95% 1,117,359.32 10,028,373.29 89,926.62 1,237,996.05 Benefits 465,246.90 4,404,449.38 6,020,625.70 73.16% 426,245.63 4,183,870.91 39,001.27 220,578.47 Operations 505,594.88 6,152,799.27 9,862,517.00 62.39% 575,973.24 6,501,491.91 (70,378.36) (348,692.64) Capital Outlay ‐ 539,747.23 1,324,357.00 40.76% 197,506.16 1,163,407.93 (197,506.16) (623,660.70) Debt Service 148,204.06 4,977,445.35 5,786,470.00 86.02% 119,847.25 4,677,973.53 28,356.81 299,471.82 Total 2,326,331.78 27,340,810.57 39,100,108.84 69.93% 2,436,931.60 26,555,117.57 (110,599.82) 785,693.00 Prepared by Daniel Oakley