Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
May 2020 - Council Expenditure Report
As of 6/12/2020 66.67 % Year Complete Executive May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 20,222.52 176,868.32 284,622.67 62.14% 23,572.97 176,656.94 (3,350.45) 211.38 Benefits 2,539.79 22,467.12 43,490.97 51.66% 3,047.29 22,277.18 (507.50) 189.94 Operations 3,759.22 57,542.99 162,775.00 35.35% 8,807.36 79,439.62 (5,048.14) (21,896.63) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 26,521.53 256,878.43 490,888.64 52.33% 35,427.62 278,373.74 (8,906.09) (21,495.31) Legislative May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 10,417.04 83,336.32 125,000.00 66.67% 10,417.04 83,336.32 ‐ ‐ Benefits 761.00 6,285.28 10,299.00 61.03% 754.40 6,222.65 6.60 62.63 Operations (625.21) 8,294.80 13,300.00 62.37% 2,829.08 11,182.22 (3,454.29) (2,887.42) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 10,552.83 97,916.40 148,599.00 65.89% 14,000.52 100,741.19 (3,447.69) (2,824.79) Finance May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 24,756.90 212,782.84 360,253.00 59.06% 22,908.90 185,243.39 1,848.00 27,539.45 Benefits 3,980.18 34,597.80 60,616.00 57.08% 3,782.30 31,287.30 197.88 3,310.50 Operations 8,403.97 164,378.96 240,360.00 68.39% 30,017.73 175,839.05 (21,613.76) (11,460.09) Capital Outlay ‐ ‐ 0.00% ‐ ‐ Total 37,141.05 411,759.60 661,229.00 62.27% 56,708.93 392,369.74 (19,567.88) 19,389.86 City Clerk May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 10,810.91 87,566.39 139,619.00 62.72% 10,588.04 83,741.65 222.87 3,824.74 Benefits 1,746.92 14,430.46 24,068.00 59.96% 1,671.55 13,792.52 75.37 637.94 Operations 1,175.52 21,202.83 108,240.00 19.59% 2,141.83 19,819.50 (966.31) 1,383.33 Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 13,733.35 123,199.68 271,927.00 45.31% 14,401.42 117,353.67 (668.07) 5,846.01 HR May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 23,408.24 201,670.69 308,420.00 65.39% 22,526.46 180,391.75 881.78 21,278.94 Benefits 4,118.59 36,048.19 56,426.00 63.89% 3,974.30 32,840.84 144.29 3,207.35 Operations 5,531.93 41,972.34 72,275.00 58.07% 1,060.95 41,052.36 4,470.98 919.98 Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 33,058.76 279,691.22 437,121.00 63.98% 27,561.71 254,284.95 5,497.05 25,406.27 IT May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 14,649.96 125,610.15 195,466.00 64.26% 13,202.31 107,427.35 1,447.65 18,182.80 Benefits 2,192.98 19,058.49 30,262.00 62.98% 1,974.39 16,528.59 218.59 2,529.90 Operations 64,657.12 920,816.26 1,371,831.00 67.12% 47,803.88 953,589.41 16,853.24 (32,773.15) Capital Outlay ‐ 94,038.13 200,000.00 47.02% ‐ 33,515.00 ‐ 60,523.13 Total 81,500.06 1,159,523.03 1,797,559.00 64.51% 62,980.58 1,111,060.35 18,519.48 48,462.68 Vehicle Maint. May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 17,434.84 147,896.27 228,594.00 64.70% 21,043.47 162,467.35 (3,608.63) (14,571.08) Benefits 2,866.91 30,540.14 43,245.00 70.62% 3,023.61 32,828.75 (156.70) (2,288.61) Operations 5,882.39 61,751.16 98,650.00 62.60% 7,706.18 35,451.94 (1,823.79) 26,299.22 Capital Outlay ‐ 35,240.95 37,000.00 95.25% ‐ ‐ ‐ 35,240.95 Total 26,184.14 275,428.52 407,489.00 67.59% 31,773.26 230,748.04 (5,589.12) 44,680.48 City of Prattville May 2020 Unaudited Expenditures By Department Engineering May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 37,057.99 300,053.57 552,052.00 54.35% 35,645.67 302,498.92 1,412.32 (2,445.35) Benefits 6,487.41 64,718.56 113,511.00 57.02% 6,443.64 67,721.11 43.77 (3,002.55) Operations 23,148.75 229,835.23 566,300.00 40.59% 38,429.00 234,514.80 (15,280.25) (4,679.57) Capital Outlay 86,388.00 99,138.00 333,718.00 0.00% ‐ ‐ 86,388.00 99,138.00 Total 153,082.15 693,745.36 1,565,581.00 44.31% 80,518.31 604,734.83 72,563.84 89,010.53 Planning May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 29,854.20 210,775.64 347,578.47 60.64% 15,197.61 127,623.66 14,656.59 83,151.98 Benefits 5,291.11 37,961.96 67,357.73 56.36% 2,694.08 23,786.79 2,597.03 14,175.17 Operations 54,956.47 353,902.20 727,450.00 48.65% 34,692.64 276,199.11 20,263.83 77,703.09 Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 90,101.78 602,639.80 1,142,386.20 52.75% 52,584.33 427,609.56 37,517.45 175,030.24 Urban Management May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 71,689.98 576,604.27 927,120.00 62.19% 60,088.19 445,414.41 11,601.79 131,189.86 Benefits 11,258.24 105,036.54 167,371.00 62.76% 9,473.02 87,070.14 1,785.22 17,966.40 Operations 23,822.93 293,795.08 493,000.00 59.59% 35,180.08 292,708.23 (11,357.15) 1,086.85 Capital Outlay ‐ ‐ 30,000.00 0.00% 41,845.00 41,845.00 (41,845.00) (41,845.00) Total 106,771.15 975,435.89 1,617,491.00 60.31% 146,586.29 867,037.78 (39,815.14) 108,398.11 Facilities Maintenance May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 27,162.81 234,893.03 363,631.00 64.60% 25,784.86 207,201.82 1,377.95 27,691.21 Benefits 4,139.20 39,257.45 59,507.00 65.97% 3,944.79 35,611.40 194.41 3,646.05 Operations 5,799.65 95,926.30 194,210.00 49.39% 5,613.68 94,488.95 185.97 1,437.35 Capital Outlay ‐ 91,416.00 91,466.00 99.95% 11,510.00 16,362.56 (11,510.00) 75,053.44 Total 37,101.66 461,492.78 708,814.00 65.11% 46,853.33 353,664.73 (9,751.67) 107,828.05 Public Works May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 24,460.24 204,633.87 312,653.00 65.45% 18,414.16 163,037.85 6,046.08 41,596.02 Benefits 4,194.49 38,441.56 58,569.00 65.63% 3,205.23 31,564.71 989.26 6,876.85 Operations 8,301.74 165,157.77 224,718.00 73.50% 12,779.38 153,243.32 (4,477.64) 11,914.45 Capital Outlay ‐ ‐ 225,000.00 0.00% (3,390.00) (3,390.00) 3,390.00 3,390.00 Total 36,956.47 408,233.20 820,940.00 49.73% 31,008.77 344,455.88 5,947.70 63,777.32 Police May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 385,868.05 3,377,936.36 5,557,043.00 60.79% 380,056.43 3,056,392.06 5,811.62 321,544.30 Benefits 62,622.66 652,022.78 1,044,030.00 62.45% 63,639.50 613,478.87 (1,016.84) 38,543.91 Operations 56,918.79 817,804.96 1,425,809.00 57.36% 110,829.37 857,967.17 (53,910.58) (40,162.21) Capital Outlay ‐ 114,912.04 133,600.00 86.01% 250.00 122,314.38 (250.00) (7,402.34) Total 505,409.50 4,962,676.14 8,160,482.00 60.81% 554,775.30 4,650,152.48 (49,365.80) 312,523.66 Fire May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 356,573.40 3,241,610.95 5,047,501.00 64.22% 350,382.61 2,876,999.98 6,190.79 364,610.97 Benefits 61,843.50 678,206.56 1,012,418.00 66.99% 61,196.31 626,065.04 647.19 52,141.52 Operations 100,321.74 611,515.72 1,044,321.00 58.56% 104,023.59 670,070.77 (3,701.85) (58,555.05) Capital Outlay 29,990.00 29,990.00 29,990.00 0.00% 250.00 249,980.00 29,740.00 (219,990.00) Total 548,728.64 4,561,323.23 7,134,230.00 63.94% 515,852.51 4,423,115.79 32,876.13 138,207.44 Building May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 18,804.80 159,718.43 244,473.00 65.33% 23,528.19 188,813.96 (4,723.39) (29,095.53) Benefits 3,271.38 31,061.30 49,214.00 63.11% 4,168.69 37,114.35 (897.31) (6,053.05) Operations 839.13 26,632.52 55,450.00 48.03% 2,636.08 30,136.62 (1,796.95) (3,504.10) Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 22,915.31 217,412.25 349,137.00 62.27% 30,332.96 256,064.93 (7,417.65) (38,652.68) Parks & Recreation May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 74,566.17 641,539.33 1,005,486.00 63.80% 74,534.40 506,730.37 31.77 134,808.96 Benefits 11,307.98 111,398.11 169,471.00 65.73% 10,994.80 93,176.70 313.18 18,221.41 Operations 49,726.69 726,664.77 1,174,070.00 61.89% 118,860.82 630,985.79 (69,134.13) 95,678.98 Capital Outlay/ Capital Projects 12,500.00 75,012.11 243,583.00 30.80% ‐ 494,760.83 12,500.00 (419,748.72) Total 148,100.84 1,554,614.32 2,592,610.00 59.96% 204,390.02 1,725,653.69 (56,289.18) (171,039.37) Performing Arts May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 8,409.12 75,586.97 106,627.00 70.89% 6,961.02 57,036.19 1,448.10 18,550.78 Benefits 1,193.42 11,003.54 15,770.00 69.78% 1,068.42 8,922.34 125.00 2,081.20 Operations 1,292.43 97,179.61 266,690.00 36.44% 24,848.58 114,268.57 (23,556.15) (17,088.96) Capital Outlay ‐ ‐ ‐ 0.00% ‐ 10,514.00 ‐ (10,514.00) Total 10,894.97 183,770.12 389,087.00 47.23% 32,878.02 190,741.10 (21,983.05) (6,970.98) Non‐Departmental May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference City ‐ County Svcs ‐ 311,666.68 425,000.00 73.33% 6,666.66 312,500.02 (6,666.66) (833.34) Community Initiatives 58,160.63 591,299.19 979,274.00 60.38% 71,507.30 578,765.34 (13,346.67) 12,533.85 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 ‐ 451,328.86 664,029.00 67.97% ‐ 116,093.42 ‐ 335,235.44 Transfer to Group Health 249,583.33 2,006,666.64 2,995,000.00 67.00% 247,167.00 1,977,336.00 2,416.33 29,330.64 Transfer to Capital Project Fund ‐ 49,865.02 75,000.00 66.49% 279,691.44 363,295.88 (279,691.44) (313,430.86) 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 307,743.96 6,710,659.86 8,697,845.00 77.15% 605,032.40 6,683,176.24 (297,288.44) 27,483.62 Debt Service May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Debt Service 72,539.02 1,078,078.96 1,728,000.00 62.39% 118,322.54 1,106,847.28 (45,783.52) (28,768.32) Total 72,539.02 1,078,078.96 1,728,000.00 62.39% 118,322.54 1,106,847.28 (45,783.52) (28,768.32) Total May‐20 YTD Budget % of Budget May‐19 YTD May Difference YTD Difference Salary 1,156,147.17 10,059,083.40 16,106,139.14 62.45% 1,114,852.33 8,911,013.97 41,294.84 1,148,069.43 Benefits 439,399.09 3,939,202.48 6,020,625.70 65.43% 432,223.32 3,757,625.28 7,175.77 181,577.20 Operations 472,073.89 5,647,204.39 9,862,517.00 57.26% 946,125.63 5,925,518.67 (474,051.74) (278,314.28) Capital Outlay 128,878.00 539,747.23 1,324,357.00 40.76% 50,465.00 965,901.77 78,413.00 (426,154.54) Debt Service 72,539.02 4,829,241.29 5,786,470.00 83.46% 118,322.54 4,558,126.28 (45,783.52) 271,115.01 Total 2,269,037.17 25,014,478.79 39,100,108.84 63.98% 2,661,988.82 24,118,185.97 (392,951.65) 896,292.82 Prepared by Daniel Oakley