Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
August 2020 - Council Expenditure Report
As of 9/11/2020 91.67 % Year Complete Executive Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 18,526.92 244,939.69 284,622.67 86.06% 33,706.89 255,078.17 (15,179.97) (10,138.48) Benefits 2,238.89 30,907.87 43,490.97 71.07% 4,331.80 32,247.50 (2,092.91) (1,339.63) Operations 4,831.59 73,213.06 162,775.00 44.98% 3,088.37 89,790.72 1,743.22 (16,577.66) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 ‐ 824.04 ‐ 100.00% ‐ 824.04 Total 25,597.40 349,884.66 490,888.64 71.28% 41,127.06 377,116.39 (15,529.66) (27,231.73) Legislative Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 9,153.18 113,323.58 125,000.00 90.66% 10,417.04 114,587.44 (1,263.86) (1,263.86) Benefits 692.13 8,585.05 10,299.00 83.36% 797.58 8,482.31 (105.45) 102.74 Operations 106.00 4,423.22 13,300.00 33.26% 637.00 12,084.35 (531.00) (7,661.13) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 19.95 4,059.68 ‐ 100.00% 19.95 4,059.68 Total 9,971.26 130,391.53 148,599.00 87.75% 11,851.62 135,154.10 (1,880.36) (4,762.57) Finance Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 24,224.43 298,354.65 360,253.00 82.82% 34,941.75 266,474.50 (10,717.32) 31,880.15 Benefits 3,948.77 48,784.07 60,616.00 80.48% 5,795.67 44,661.95 (1,846.90) 4,122.12 Operations 8,433.88 204,156.32 240,360.00 84.94% 11,160.93 202,833.63 (2,727.05) 1,322.69 Capital Outlay ‐ ‐ 0.00% ‐ ‐ COVID‐19 152.76 342.20 ‐ 100.00% 152.76 342.20 Total 36,759.84 551,637.24 661,229.00 83.43% 51,898.35 513,970.08 (15,138.51) 37,667.16 City Clerk Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 11,424.53 125,059.86 139,619.00 89.57% 15,109.79 120,219.63 (3,685.26) 4,840.23 Benefits 1,892.17 20,735.64 24,068.00 86.15% 2,499.05 19,630.00 (606.88) 1,105.64 Operations 24,887.90 59,227.32 108,240.00 54.72% 6,149.80 30,936.72 18,738.10 28,290.60 Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 1,801.90 10,656.82 ‐ 100.00% 1,801.90 10,656.82 Total 40,006.50 215,679.64 271,927.00 79.32% 23,758.64 170,786.35 16,247.86 44,893.29 HR Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 23,073.55 282,248.61 308,420.00 91.51% 33,928.90 260,090.01 (10,855.35) 22,158.60 Benefits 4,032.74 50,449.22 56,426.00 89.41% 6,039.61 46,825.22 (2,006.87) 3,624.00 Operations 891.91 48,093.97 72,275.00 66.54% 5,270.87 60,669.60 (4,378.96) (12,575.63) Capital Outlay ‐ ‐ ‐ 0.00% 10,950.00 ‐ (10,950.00) COVID‐19 806.89 9,609.20 ‐ 100.00% 806.89 9,609.20 Total 28,805.09 390,401.00 437,121.00 89.31% 45,239.38 378,534.83 (16,434.29) 11,866.17 IT Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 16,002.76 180,381.01 195,466.00 92.28% 20,421.08 154,422.60 (4,418.32) 25,958.41 Benefits 2,400.23 27,386.01 30,262.00 90.50% 3,090.51 23,579.41 (690.28) 3,806.60 Operations 82,487.63 1,136,369.55 1,371,831.00 82.84% 63,774.04 1,173,358.42 18,713.59 (36,988.87) Capital Outlay ‐ 94,038.13 200,000.00 47.02% 103,674.00 ‐ (9,635.87) COVID‐19 192,932.72 206,300.39 ‐ 100.00% 192,932.72 206,300.39 Total 293,823.34 1,644,475.09 1,797,559.00 91.48% 87,285.63 1,455,034.43 206,537.71 189,440.66 Vehicle Maint. Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 16,598.11 208,046.83 228,594.00 91.01% 24,869.48 217,670.42 (8,271.37) (9,623.59) Benefits 2,684.64 41,723.43 43,245.00 96.48% 4,143.80 41,561.78 (1,459.16) 161.65 Operations 4,239.01 77,434.47 98,650.00 78.49% 8,326.31 52,213.77 (4,087.30) 25,220.70 Capital Outlay ‐ 35,240.95 37,000.00 95.25% ‐ ‐ ‐ 35,240.95 COVID‐19 ‐ ‐ ‐ 100.00% ‐ ‐ Total 23,521.76 362,445.68 407,489.00 88.95% 37,339.59 311,445.97 (13,817.83) 50,999.71 City of Prattville August 2020 Unaudited Expenditures By Department Engineering Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 40,054.90 432,473.38 552,052.00 78.34% 53,533.43 427,951.77 (13,478.53) 4,521.61 Benefits 6,944.04 90,079.78 113,511.00 79.36% 9,802.21 90,220.41 (2,858.17) (140.63) Operations 14,513.72 289,056.33 566,300.00 51.04% 36,359.52 294,874.97 (21,845.80) (5,818.64) Capital Outlay 197,517.31 296,655.31 333,718.00 0.00% ‐ ‐ 197,517.31 296,655.31 COVID‐19 ‐ ‐ ‐ 100.00% ‐ ‐ Total 259,029.97 1,108,264.80 1,565,581.00 70.79% 99,695.16 813,047.15 159,334.81 295,217.65 Planning Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 29,744.21 314,753.22 347,578.47 90.56% 32,028.79 202,187.40 (2,284.58) 112,565.82 Benefits 5,270.46 56,532.50 67,357.73 83.93% 5,799.72 37,216.88 (529.26) 19,315.62 Operations 44,325.05 522,494.58 727,450.00 71.83% 42,781.17 365,604.36 1,543.88 156,890.22 Capital Outlay ‐ ‐ ‐ 0.00% 26,863.00 26,863.00 (26,863.00) (26,863.00) COVID‐19 ‐ ‐ ‐ 100.00% ‐ ‐ ‐ Total 79,339.72 893,780.30 1,142,386.20 78.24% 107,472.68 631,871.64 (28,132.96) 261,908.66 Urban Management Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 74,738.83 818,443.96 927,120.00 88.28% 94,743.59 664,190.04 (20,004.76) 154,253.92 Benefits 11,535.04 144,741.78 167,371.00 86.48% 14,881.41 120,629.02 (3,346.37) 24,112.76 Operations 31,959.96 373,830.50 493,000.00 75.83% 40,468.16 392,940.92 (8,508.20) (19,110.42) Capital Outlay ‐ ‐ 30,000.00 0.00% 54,255.00 ‐ (54,255.00) COVID‐19 ‐ ‐ ‐ 100.00% ‐ ‐ Total 118,233.83 1,337,016.24 1,617,491.00 82.66% 150,093.16 1,232,014.98 (31,859.33) 105,001.26 Facilities Maintenance Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 27,143.30 330,056.91 363,631.00 90.77% 38,803.30 297,322.28 (11,660.00) 32,734.63 Benefits 4,146.23 54,450.02 59,507.00 91.50% 6,009.34 49,377.45 (1,863.11) 5,072.57 Operations 19,516.05 127,942.94 194,210.00 65.88% 21,055.75 123,404.34 (1,539.70) 4,538.60 Capital Outlay ‐ 91,416.00 91,466.00 99.95% 7,200.00 72,595.68 (7,200.00) 18,820.32 COVID‐19 ‐ 345.52 ‐ 100.00% ‐ 345.52 Total 50,805.58 604,211.39 708,814.00 85.24% 73,068.39 542,699.75 (22,262.81) 61,511.64 Public Works Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 24,557.16 290,740.37 312,653.00 92.99% 32,940.64 236,473.66 (8,383.48) 54,266.71 Benefits 4,213.86 53,812.68 58,569.00 91.88% 5,717.03 44,201.74 (1,503.17) 9,610.94 Operations 5,321.58 180,998.39 224,718.00 80.54% 7,895.91 184,137.96 (2,574.33) (3,139.57) Capital Outlay ‐ ‐ 225,000.00 0.00% 169,367.50 165,977.50 (169,367.50) (165,977.50) COVID‐19 ‐ 586.88 ‐ 100.00% ‐ 586.88 Total 34,092.60 526,138.32 820,940.00 64.09% 215,921.08 630,790.86 (181,828.48) (104,652.54) Police Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 375,015.37 4,692,089.00 5,557,043.00 84.43% 561,352.18 4,377,121.39 (186,336.81) 314,967.61 Benefits 59,580.49 872,102.99 1,044,030.00 83.53% 94,255.08 832,132.83 (34,674.59) 39,970.16 Operations 36,159.90 977,525.21 1,425,809.00 68.56% 78,398.11 1,117,005.79 (42,238.21) (139,480.58) Capital Outlay ‐ 114,912.04 133,600.00 86.01% ‐ 122,314.38 ‐ (7,402.34) COVID‐19 1,860.82 15,913.12 ‐ 100.00% 1,860.82 15,913.12 Total 472,616.58 6,672,542.36 8,160,482.00 81.77% 734,005.37 6,448,574.39 (261,388.79) 223,967.97 Fire Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 376,684.97 4,606,121.89 5,047,501.00 91.26% 528,682.87 4,111,875.81 (151,997.90) 494,246.08 Benefits 64,296.51 915,188.40 1,012,418.00 90.40% 93,771.60 840,527.56 (29,475.09) 74,660.84 Operations 70,451.76 768,736.00 986,692.00 77.91% 77,692.33 829,973.88 (7,240.57) (61,237.88) Capital Outlay ‐ 29,990.00 164,779.00 18.20% ‐ 445,444.00 ‐ (415,454.00) COVID‐19 912.12 16,902.00 100.00% 912.12 16,902.00 Total 512,345.36 6,336,938.29 7,211,390.00 87.87% 700,146.80 6,227,821.25 (187,801.44) 109,117.04 Building Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 18,804.80 225,535.23 244,473.00 92.25% 26,586.40 250,609.96 (7,781.60) (25,074.73) Benefits 3,271.38 42,723.12 49,214.00 86.81% 4,698.18 47,882.92 (1,426.80) (5,159.80) Operations 2,087.94 30,690.36 55,450.00 55.35% 3,701.46 37,370.25 (1,613.52) (6,679.89) Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 100.00% ‐ ‐ Total 24,164.12 298,948.71 349,137.00 85.63% 34,986.04 335,863.13 (10,821.92) (36,914.42) Parks & Recreation Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 96,862.62 979,021.31 1,005,486.00 97.37% 109,615.88 797,601.63 (12,753.26) 181,419.68 Benefits 13,486.11 162,158.06 169,471.00 95.68% 16,098.06 133,377.42 (2,611.95) 28,780.64 Operations 91,158.76 918,846.64 1,174,070.00 78.26% 96,037.22 908,119.45 (4,878.46) 10,727.19 Capital Outlay/ Capital Projects ‐ 88,862.11 243,583.00 36.48% ‐ 494,760.83 ‐ (405,898.72) COVID‐19 1,561.41 66,704.13 ‐ 100.00% 1,561.41 66,704.13 Total 203,068.90 2,215,592.25 2,592,610.00 85.46% 221,751.16 2,333,859.33 (18,682.26) (118,267.08) Performing Arts Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 8,271.51 104,419.89 106,627.00 97.93% 12,521.18 85,845.42 (4,249.67) 18,574.47 Benefits 1,268.10 15,475.43 15,770.00 98.13% 1,816.39 13,091.29 (548.29) 2,384.14 Operations 3,218.91 120,280.09 266,690.00 45.10% 30,086.32 182,670.14 (26,867.41) (62,390.05) Capital Outlay ‐ ‐ ‐ 0.00% ‐ 10,514.00 ‐ (10,514.00) COVID‐19 ‐ 179.99 ‐ 100.00% ‐ 179.99 Total 12,758.52 240,355.40 389,087.00 61.77% 44,423.89 292,120.85 (31,665.37) (51,765.45) Non‐Departmental Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference City ‐ County Svcs ‐ 412,916.67 425,000.00 97.16% 6,666.66 410,000.00 (6,666.66) 2,916.67 Community Initiatives 41,667.67 733,259.02 979,274.00 74.88% 45,815.02 744,953.10 (4,147.35) (11,694.08) Transfer to DSF ‐ One Cent 85,747.02 3,385,580.49 3,394,441.00 99.74% ‐ 7,335,956.05 85,747.02 (3,950,375.56) Transfer to DSF ‐ Other ‐ 568,895.33 664,029.00 85.67% ‐ 226,481.89 ‐ 342,413.44 Transfer to Group Health 249,583.33 2,755,416.63 2,995,000.00 92.00% 247,167.00 2,966,004.00 2,416.33 (210,587.37) Transfer to Capital Project Fund 500,000.00 624,870.02 75,000.00 833.16% 9,570.30 394,950.15 490,429.70 229,919.87 Transfer to Sanitation Fund 21,307.00 0.00% ‐ ‐ ‐ ‐ Transfer to Gas Tax Fund ‐ 22,000.00 22,000.00 100.00% ‐ 188,150.00 ‐ (166,150.00) Transfer to Judicial ‐ 121,793.88 121,794.00 0.00% ‐ ‐ ‐ 121,793.88 Total 876,998.02 8,624,732.04 8,697,845.00 99.16% 309,218.98 12,266,495.19 567,779.04 (3,641,763.15) Debt Service Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Debt Service 96,913.15 1,493,281.17 1,728,000.00 86.42% 111,285.38 1,481,137.17 (14,372.23) 12,144.00 Total 96,913.15 1,493,281.17 1,728,000.00 86.42% 111,285.38 1,481,137.17 (14,372.23) 12,144.00 Total Aug‐20 YTD Budget % of Budget Aug‐19 YTD August Difference YTD Difference Salary 1,190,881.15 14,246,009.39 16,106,139.14 88.45% 1,664,203.19 12,839,722.13 (473,322.04) 1,406,287.26 Benefits 441,485.12 5,391,252.68 6,020,625.70 89.55% 526,714.04 5,391,649.69 (85,228.92) (397.01) Operations 986,259.22 7,806,158.54 9,804,888.00 79.61% 594,935.25 7,607,892.52 391,323.97 198,266.02 Capital Outlay 197,517.31 751,114.54 1,459,146.00 51.48% 203,430.50 1,507,348.39 (5,913.19) (756,233.85) Debt Service 182,660.17 5,447,756.99 5,786,470.00 94.15% 111,285.38 9,043,575.11 71,374.79 (3,595,818.12) COVID‐19 200,048.57 332,423.97 ‐ 100.00% Total 3,198,851.54 33,974,716.11 39,177,268.84 86.72% 3,100,568.36 36,390,187.84 (101,765.39) (2,747,895.70) % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 85.87% Prepared by Daniel Oakley