Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
July 2020 - General Fund Expense Information
As of 8/14/2020 83.33 % Year Complete Executive Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 29,237.15 226,412.77 284,622.67 79.55% 21,958.25 221,371.28 7,278.90 5,041.49 Benefits 3,642.25 28,668.98 43,490.97 65.92% 2,742.53 27,915.70 899.72 753.28 Operations 4,998.93 68,381.47 162,775.00 42.01% 3,532.29 86,702.35 1,466.64 (18,320.88) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 664.06 824.04 ‐ 100.00% 664.06 824.04 Total 38,542.39 324,287.26 490,888.64 66.06% 28,233.07 335,989.33 10,309.32 (11,702.07) Legislative Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 10,417.04 104,170.40 125,000.00 83.34% 10,417.04 104,170.40 ‐ ‐ Benefits 788.82 7,892.92 10,299.00 76.64% 711.22 7,684.73 77.60 208.19 Operations ‐ 4,317.22 13,300.00 32.46% 125.00 11,447.35 (125.00) (7,130.13) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ COVID‐19 4,039.73 ‐ 100.00% ‐ 4,039.73 Total 11,205.86 120,420.27 148,599.00 81.04% 11,253.26 123,302.48 (47.40) (2,882.21) Finance Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 36,371.91 274,130.22 360,253.00 76.09% 23,112.89 231,532.75 13,259.02 42,597.47 Benefits 6,056.47 44,835.30 60,616.00 73.97% 3,776.67 38,866.28 2,279.80 5,969.02 Operations 22,871.81 195,722.44 240,360.00 81.43% 4,796.49 191,672.70 18,075.32 4,049.74 Capital Outlay ‐ ‐ 0.00% ‐ ‐ COVID‐19 107.74 189.44 ‐ 100.00% 107.74 189.44 Total 65,407.93 514,877.40 661,229.00 77.87% 31,686.05 462,071.73 33,721.88 52,805.67 City Clerk Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 15,258.03 113,635.33 139,619.00 81.39% 10,800.09 105,109.84 4,457.94 8,525.49 Benefits 2,582.09 18,843.47 24,068.00 78.29% 1,670.02 17,130.95 912.07 1,712.52 Operations 12,347.66 34,339.42 108,240.00 31.73% 1,443.21 24,786.92 10,904.45 9,552.50 Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 8,381.75 8,854.92 ‐ 100.00% 8,381.75 8,854.92 Total 38,569.53 175,673.14 271,927.00 64.60% 13,913.32 147,027.71 24,656.21 28,645.43 HR Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 34,519.50 259,175.06 308,420.00 84.03% 22,667.51 226,161.11 11,851.99 33,013.95 Benefits 6,154.30 46,416.48 56,426.00 82.26% 3,904.96 40,785.61 2,249.34 5,630.87 Operations 8,297.63 47,202.06 72,275.00 65.31% 3,519.94 55,398.73 4,777.69 (8,196.67) Capital Outlay ‐ ‐ ‐ 0.00% 10,950.00 10,950.00 (10,950.00) (10,950.00) COVID‐19 2,329.55 8,802.31 ‐ 100.00% 2,329.55 8,802.31 Total 51,300.98 361,595.91 437,121.00 82.72% 41,042.41 333,295.45 10,258.57 28,300.46 IT Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 23,604.38 164,378.25 195,466.00 84.10% 13,331.90 134,001.52 10,272.48 30,376.73 Benefits 3,564.80 24,985.78 30,262.00 82.56% 1,984.03 20,488.90 1,580.77 4,496.88 Operations 67,347.28 1,053,881.92 1,371,831.00 76.82% 78,484.14 1,109,584.38 (11,136.86) (55,702.46) Capital Outlay ‐ 94,038.13 200,000.00 47.02% 70,159.00 103,674.00 (70,159.00) (9,635.87) COVID‐19 10,178.24 13,367.67 ‐ 100.00% 10,178.24 13,367.67 Total 104,694.70 1,350,651.75 1,797,559.00 75.14% 163,959.07 1,367,748.80 (59,264.37) (17,097.05) Vehicle Maint. Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 26,187.25 191,448.72 228,594.00 83.75% 14,868.78 192,800.94 11,318.47 (1,352.22) Benefits 4,350.78 39,038.79 43,245.00 90.27% 2,278.10 37,417.98 2,072.68 1,620.81 Operations 5,426.69 73,195.46 98,650.00 74.20% 2,540.32 43,887.46 2,886.37 29,308.00 Capital Outlay ‐ 35,240.95 37,000.00 95.25% ‐ ‐ ‐ 35,240.95 COVID‐19 ‐ ‐ ‐ 100.00% ‐ ‐ Total 35,964.72 338,923.92 407,489.00 83.17% 19,687.20 274,106.38 16,277.52 64,817.54 City of Prattville July 2020 Unaudited Expenditures By Department Engineering Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 55,424.53 392,418.48 552,052.00 71.08% 36,044.04 374,418.34 19,380.49 18,000.14 Benefits 9,777.88 83,135.74 113,511.00 73.24% 6,488.12 80,418.20 3,289.76 2,717.54 Operations 14,968.21 274,542.61 566,300.00 48.48% 9,419.55 258,515.45 5,548.66 16,027.16 Capital Outlay ‐ 99,138.00 333,718.00 0.00% ‐ ‐ ‐ 99,138.00 COVID‐19 ‐ ‐ ‐ 100.00% ‐ ‐ Total 80,170.62 849,234.83 1,565,581.00 54.24% 51,951.71 713,351.99 28,218.91 135,882.84 Planning Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 44,529.67 285,009.01 347,578.47 82.00% 21,289.56 170,158.61 23,240.11 114,850.40 Benefits 7,913.34 51,262.04 67,357.73 76.10% 3,816.74 31,417.16 4,096.60 19,844.88 Operations 50,676.80 478,169.53 727,450.00 65.73% 6,227.92 322,823.19 44,448.88 155,346.34 Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 100.00% ‐ ‐ Total 103,119.81 814,440.58 1,142,386.20 71.29% 31,334.22 524,398.96 71,785.59 290,041.62 Urban Management Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 100,075.58 743,705.13 927,120.00 80.22% 62,219.35 569,446.45 37,856.23 174,258.68 Benefits 16,200.34 133,206.74 167,371.00 79.59% 9,550.90 105,747.61 6,649.44 27,459.13 Operations 26,228.09 341,870.54 493,000.00 69.34% 31,037.53 352,472.76 (4,809.44) (10,602.22) Capital Outlay ‐ ‐ 30,000.00 0.00% 12,410.00 54,255.00 (12,410.00) (54,255.00) COVID‐19 ‐ ‐ ‐ 100.00% ‐ ‐ Total 142,504.01 1,218,782.41 1,617,491.00 75.35% 115,217.78 1,081,921.82 27,286.23 136,860.59 Facilities Maintenance Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 40,925.54 302,913.61 363,631.00 83.30% 25,757.24 258,518.98 15,168.30 44,394.63 Benefits 6,326.02 50,303.79 59,507.00 84.53% 3,918.41 43,368.11 2,407.61 6,935.68 Operations 9,989.94 108,426.89 194,210.00 55.83% 4,140.46 102,348.59 5,849.48 6,078.30 Capital Outlay ‐ 91,416.00 91,466.00 99.95% 46,990.96 65,395.68 (46,990.96) 26,020.32 COVID‐19 3.29 345.52 ‐ 100.00% 3.29 345.52 Total 57,244.79 553,405.81 708,814.00 78.07% 80,807.07 469,631.36 (23,562.28) 83,774.45 Public Works Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 37,096.27 266,183.21 312,653.00 85.14% 21,220.90 203,533.02 15,875.37 62,650.19 Benefits 6,422.81 49,598.82 58,569.00 84.68% 3,637.05 38,484.71 2,785.76 11,114.11 Operations 6,696.36 175,676.81 224,718.00 78.18% 15,820.73 176,242.05 (9,124.37) (565.24) Capital Outlay ‐ ‐ 225,000.00 0.00% ‐ (3,390.00) ‐ 3,390.00 COVID‐19 ‐ 586.88 ‐ 100.00% ‐ 586.88 Total 50,215.44 492,045.72 820,940.00 59.94% 40,678.68 414,869.78 9,536.76 77,175.94 Police Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 562,639.13 4,317,073.63 5,557,043.00 77.69% 391,153.70 3,815,769.21 171,485.43 501,304.42 Benefits 93,630.06 812,522.50 1,044,030.00 77.83% 63,865.99 737,877.75 29,764.07 74,644.75 Operations 48,825.50 941,365.31 1,425,809.00 66.02% 74,732.19 1,038,607.68 (25,906.69) (97,242.37) Capital Outlay ‐ 114,912.04 133,600.00 86.01% ‐ 122,314.38 ‐ (7,402.34) COVID‐19 10,821.42 14,052.30 ‐ 100.00% 10,821.42 14,052.30 Total 715,916.11 6,199,925.78 8,160,482.00 75.97% 529,751.88 5,714,569.02 186,164.23 485,356.76 Fire Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 574,196.12 4,229,436.92 5,047,501.00 83.79% 357,243.35 3,583,192.94 216,952.77 646,243.98 Benefits 100,619.79 850,891.89 1,012,418.00 84.05% 62,244.97 746,755.96 38,374.82 104,135.93 Operations 45,622.06 698,284.24 986,692.00 70.77% 47,257.70 752,281.55 (1,635.64) (53,997.31) Capital Outlay ‐ 29,990.00 87,619.00 0.00% ‐ 445,444.00 ‐ (415,454.00) COVID‐19 7,438.46 15,989.88 ‐ 100.00% 7,438.46 15,989.88 Total 727,876.43 5,824,592.93 7,134,230.00 81.64% 466,746.02 5,527,674.45 261,130.41 296,918.48 Building Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 28,207.20 206,730.43 244,473.00 84.56% 17,604.80 224,023.56 10,602.40 (17,293.13) Benefits 4,973.06 39,451.74 49,214.00 80.16% 3,069.44 43,184.74 1,903.62 (3,733.00) Operations 1,106.38 28,602.42 55,450.00 51.58% 1,862.18 33,668.79 (755.80) (5,066.37) Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ COVID‐19 ‐ ‐ ‐ 100.00% ‐ ‐ Total 34,286.64 274,784.59 349,137.00 78.70% 22,536.42 300,877.09 11,750.22 (26,092.50) Parks & Recreation Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 158,031.78 882,158.69 1,005,486.00 87.73% 88,933.94 687,985.75 69,097.84 194,172.94 Benefits 20,886.97 148,671.95 169,471.00 87.73% 11,836.54 117,279.36 9,050.43 31,392.59 Operations 80,540.19 827,687.88 1,174,070.00 70.50% 53,424.75 812,082.23 27,115.44 15,605.65 Capital Outlay/ Capital Projects 13,850.00 88,862.11 243,583.00 36.48% ‐ 494,760.83 13,850.00 (405,898.72) COVID‐19 22,442.08 65,142.72 ‐ 100.00% 22,442.08 65,142.72 Total 295,751.02 2,012,523.35 2,592,610.00 77.63% 154,195.23 2,112,108.17 141,555.79 (99,584.82) Performing Arts Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 12,037.82 96,148.38 106,627.00 90.17% 8,522.31 73,324.24 3,515.51 22,824.14 Benefits 1,845.07 14,207.33 15,770.00 90.09% 1,235.05 11,274.90 610.02 2,932.43 Operations 5,440.46 117,061.18 266,690.00 43.89% 9,301.30 152,583.82 (3,860.84) (35,522.64) Capital Outlay ‐ ‐ ‐ 0.00% ‐ 10,514.00 ‐ (10,514.00) COVID‐19 179.99 179.99 ‐ 100.00% 179.99 179.99 Total 19,503.34 227,596.88 389,087.00 58.50% 19,058.66 247,696.96 444.68 (20,100.08) Non‐Departmental Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference City ‐ County Svcs 87,083.33 412,916.67 425,000.00 97.16% 84,166.66 403,333.34 2,916.67 9,583.33 Community Initiatives 41,667.67 691,591.35 979,274.00 70.62% 68,707.06 699,138.08 (27,039.39) (7,546.73) Transfer to DSF ‐ One Cent ‐ 3,299,833.47 3,394,441.00 97.21% 4,000,770.47 7,335,956.05 (4,000,770.47) (4,036,122.58) Transfer to DSF ‐ Other 92,941.47 568,895.33 664,029.00 85.67% 110,388.47 226,481.89 (17,447.00) 342,413.44 Transfer to Group Health 249,583.33 2,505,833.30 2,995,000.00 83.67% 494,334.00 2,718,837.00 (244,750.67) (213,003.70) Transfer to Capital Project Fund 75,000.00 124,870.02 75,000.00 166.49% 10,925.94 385,379.85 64,074.06 (260,509.83) Transfer to Sanitation Fund 21,307.00 0.00% ‐ ‐ ‐ ‐ Transfer to Gas Tax Fund 22,000.00 22,000.00 22,000.00 100.00% 188,150.00 188,150.00 (166,150.00) (166,150.00) Transfer to Judicial 121,793.88 121,793.88 121,794.00 0.00% ‐ ‐ 121,793.88 121,793.88 Total 690,069.68 7,747,734.02 8,697,845.00 89.08% 4,957,442.60 11,957,276.21 (4,267,372.92) (4,209,542.19) Debt Service Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Debt Service 194,710.00 1,396,368.02 1,728,000.00 80.81% 143,157.26 1,369,851.79 51,552.74 26,516.23 Total 194,710.00 1,396,368.02 1,728,000.00 80.81% 143,157.26 1,369,851.79 51,552.74 26,516.23 Total Jul‐20 YTD Budget % of Budget Jul‐19 YTD July Difference YTD Difference Salary 1,788,758.90 13,055,128.24 16,106,139.14 81.06% 1,147,145.65 11,175,518.94 641,613.25 1,879,609.30 Benefits 545,318.18 4,949,767.56 6,020,625.70 82.21% 681,064.74 4,864,935.65 (135,746.56) 84,831.91 Operations 758,928.87 6,819,899.32 9,804,888.00 69.56% 699,615.36 7,012,957.27 59,313.51 (193,057.95) Capital Outlay 13,850.00 553,597.23 1,381,986.00 40.06% 140,509.96 1,303,917.89 (126,659.96) (750,320.66) Debt Service 287,651.47 5,265,096.82 5,786,470.00 90.99% 4,254,316.20 8,932,289.73 (3,966,664.73) (3,667,192.91) COVID‐19 62,546.58 132,375.40 ‐ 100.00% Total 3,457,054.00 30,775,864.57 39,100,108.84 78.71% 6,922,651.91 33,289,619.48 (3,528,144.49) (2,646,130.31) % of Budget Spend Excluding Unbudgeted COVID‐19 Expenditures 78.37% Prepared by Daniel Oakley