Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
April 2020 - Council Expenditure Report
As of 5/15/2020 58.33 % Year Complete Executive Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 20,211.93 156,645.80 284,622.67 55.04% 23,357.12 153,083.97 (3,145.19) 3,561.83 Benefits 2,511.14 19,927.33 43,490.97 45.82% 3,014.08 19,229.89 (502.94) 697.44 Operations 3,760.81 53,783.77 162,775.00 33.04% 4,313.75 70,632.26 (552.94) (16,848.49) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 26,483.88 230,356.90 490,888.64 46.93% 30,684.95 242,946.12 (4,201.07) (12,589.22) Legislative Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 10,417.04 72,919.28 125,000.00 58.34% 10,417.04 72,919.28 ‐ ‐ Benefits 804.18 5,524.28 10,299.00 53.64% 754.40 5,468.25 49.78 56.03 Operations 6,528.13 8,920.01 13,300.00 67.07% 2,808.69 8,353.14 3,719.44 566.87 Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 17,749.35 87,363.57 148,599.00 58.79% 13,980.13 86,740.67 3,769.22 622.90 Finance Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 24,751.12 188,025.94 360,253.00 52.19% 22,636.01 162,334.49 2,115.11 25,691.45 Benefits 4,025.83 30,617.62 60,616.00 50.51% 3,729.76 27,505.00 296.07 3,112.62 Operations 6,686.04 155,974.99 240,360.00 64.89% 31,530.66 145,821.32 (24,844.62) 10,153.67 Capital Outlay ‐ ‐ 0.00% ‐ ‐ Total 35,462.99 374,618.55 661,229.00 56.65% 57,896.43 335,660.81 (22,433.44) 38,957.74 City Clerk Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 10,810.91 76,755.48 139,619.00 54.97% 10,447.07 73,153.61 363.84 3,601.87 Benefits 1,749.70 12,683.54 24,068.00 52.70% 1,646.42 12,120.97 103.28 562.57 Operations 5,468.74 20,027.31 108,240.00 18.50% 2,195.94 17,677.67 3,272.80 2,349.64 Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 18,029.35 109,466.33 271,927.00 40.26% 14,289.43 102,952.25 3,739.92 6,514.08 HR Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 23,688.77 178,262.45 308,420.00 57.80% 22,214.15 157,865.29 1,474.62 20,397.16 Benefits 4,232.92 31,929.60 56,426.00 56.59% 3,930.89 28,866.54 302.03 3,063.06 Operations 2,369.43 36,440.41 72,275.00 50.42% 5,458.02 39,991.41 (3,088.59) (3,551.00) Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 30,291.12 246,632.46 437,121.00 56.42% 31,603.06 226,723.24 (1,311.94) 19,909.22 IT Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 15,005.64 110,960.19 195,466.00 56.77% 12,868.94 94,225.04 2,136.70 16,735.15 Benefits 2,257.67 16,865.51 30,262.00 55.73% 1,923.31 14,554.20 334.36 2,311.31 Operations 99,380.84 856,159.14 1,371,831.00 62.41% 149,965.41 905,785.53 (50,584.57) (49,626.39) Capital Outlay ‐ 94,038.13 200,000.00 47.02% ‐ 33,515.00 ‐ 60,523.13 Total 116,644.15 1,078,022.97 1,797,559.00 59.97% 164,757.66 1,048,079.77 (48,113.51) 29,943.20 Vehicle Maint. Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 17,343.08 130,461.43 228,594.00 57.07% 25,090.79 141,423.88 (7,747.71) (10,962.45) Benefits 2,858.94 27,673.23 43,245.00 63.99% 3,495.42 29,805.14 (636.48) (2,131.91) Operations 9,452.79 55,868.77 98,650.00 56.63% 1,247.42 27,745.76 8,205.37 28,123.01 Capital Outlay 26,660.95 35,240.95 37,000.00 95.25% ‐ ‐ 26,660.95 35,240.95 Total 56,315.76 249,244.38 407,489.00 61.17% 29,833.63 198,974.78 26,482.13 50,269.60 City of Prattville April 2020 Unaudited Expenditures By Department Engineering Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 37,588.64 262,995.58 552,052.00 47.64% 37,507.51 266,853.25 81.13 (3,857.67) Benefits 6,520.74 58,231.15 113,511.00 51.30% 6,719.28 61,277.47 (198.54) (3,046.32) Operations 37,708.00 206,686.48 566,300.00 36.50% 28,631.48 196,085.80 9,076.52 10,600.68 Capital Outlay ‐ 12,750.00 333,718.00 0.00% ‐ ‐ ‐ 12,750.00 Total 81,817.38 540,663.21 1,565,581.00 34.53% 72,858.27 524,216.52 8,959.11 16,446.69 Planning Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 28,077.94 180,921.44 347,578.47 52.05% 17,212.28 112,426.05 10,865.66 68,495.39 Benefits 5,041.39 32,670.85 67,357.73 48.50% 3,075.22 21,092.71 1,966.17 11,578.14 Operations 52,969.64 298,945.73 727,450.00 41.10% 39,957.57 241,506.47 13,012.07 57,439.26 Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 86,088.97 512,538.02 1,142,386.20 44.87% 60,245.07 375,025.23 25,843.90 137,512.79 Urban Management Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 67,858.89 504,914.29 927,120.00 54.46% 55,063.68 385,326.22 12,795.21 119,588.07 Benefits 10,923.24 93,778.30 167,371.00 56.03% 8,863.37 77,597.12 2,059.87 16,181.18 Operations 27,843.12 269,972.15 493,000.00 54.76% 40,086.63 257,528.15 (12,243.51) 12,444.00 Capital Outlay ‐ ‐ 30,000.00 0.00% ‐ ‐ ‐ ‐ Total 106,625.25 868,664.74 1,617,491.00 53.70% 104,013.68 720,451.49 2,611.57 148,213.25 Facilities Maintenance Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 27,129.24 207,730.22 363,631.00 57.13% 25,177.16 181,416.96 1,952.08 26,313.26 Benefits 4,156.64 35,118.25 59,507.00 59.02% 3,840.72 31,666.61 315.92 3,451.64 Operations 19,923.54 90,126.65 194,210.00 46.41% 19,495.28 88,875.27 428.26 1,251.38 Capital Outlay 77,790.00 91,416.00 91,466.00 99.95% 2,352.56 4,852.56 75,437.44 86,563.44 Total 128,999.42 424,391.12 708,814.00 59.87% 50,865.72 306,811.40 78,133.70 117,579.72 Public Works Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 24,442.20 180,173.63 312,653.00 57.63% 20,576.27 144,623.69 3,865.93 35,549.94 Benefits 4,209.56 34,247.07 58,569.00 58.47% 3,444.26 28,359.48 765.30 5,887.59 Operations 16,816.08 156,856.03 224,718.00 69.80% 17,897.71 140,463.94 (1,081.63) 16,392.09 Capital Outlay ‐ ‐ 225,000.00 0.00% ‐ ‐ ‐ ‐ Total 45,467.84 371,276.73 820,940.00 45.23% 41,918.24 313,447.11 3,549.60 57,829.62 Police Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 375,161.64 2,992,068.31 5,557,043.00 53.84% 376,942.96 2,676,335.63 (1,781.32) 315,732.68 Benefits 61,956.23 589,400.12 1,044,030.00 56.45% 63,925.53 549,839.37 (1,969.30) 39,560.75 Operations 64,797.76 760,886.17 1,425,809.00 53.37% 121,502.98 747,137.80 (56,705.22) 13,748.37 Capital Outlay 1,455.00 114,912.04 133,600.00 86.01% 18,532.38 122,064.38 (17,077.38) (7,152.34) Total 503,370.63 4,457,266.64 8,160,482.00 54.62% 580,903.85 4,095,377.18 (77,533.22) 361,889.46 Fire Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 357,876.46 2,885,037.55 5,047,501.00 57.16% 343,784.81 2,526,617.37 14,091.65 358,420.18 Benefits 62,463.48 616,363.06 1,012,418.00 60.88% 59,948.93 564,868.73 2,514.55 51,494.33 Operations 65,332.47 511,193.98 1,044,321.00 48.95% 103,752.76 566,047.18 (38,420.29) (54,853.20) Capital Outlay ‐ 29,990.00 0.00% 1,670.00 249,730.00 (1,670.00) (249,730.00) Total 485,672.41 4,012,594.59 7,134,230.00 56.24% 509,156.50 3,907,263.28 (23,484.09) 105,331.31 Building Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 18,804.80 140,913.63 244,473.00 57.64% 23,024.68 165,285.77 (4,219.88) (24,372.14) Benefits 3,271.38 27,789.92 49,214.00 56.47% 4,078.87 32,945.66 (807.49) (5,155.74) Operations 1,625.72 25,793.39 55,450.00 46.52% 4,141.48 27,500.54 (2,515.76) (1,707.15) Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 23,701.90 194,496.94 349,137.00 55.71% 31,245.03 225,731.97 (7,543.13) (31,235.03) Parks & Recreation Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 76,764.47 566,973.16 1,005,486.00 56.39% 69,136.86 432,195.97 7,627.61 134,777.19 Benefits 11,671.32 100,090.13 169,471.00 59.06% 10,360.95 82,181.90 1,310.37 17,908.23 Operations 143,481.72 676,938.08 1,174,070.00 57.66% 110,682.77 512,124.97 32,798.95 164,813.11 Capital Outlay/ Capital Projects 12,500.00 62,512.11 243,583.00 25.66% 124,622.00 494,760.83 (112,122.00) (432,248.72) Total 244,417.51 1,406,513.48 2,592,610.00 54.25% 314,802.58 1,521,263.67 (70,385.07) (114,750.19) Performing Arts Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 8,402.81 67,177.85 106,627.00 63.00% 8,185.93 50,075.17 216.88 17,102.68 Benefits 1,194.28 9,810.12 15,770.00 62.21% 1,222.91 7,853.92 (28.63) 1,956.20 Operations 10,832.02 95,887.18 266,690.00 35.95% 24,764.47 89,419.99 (13,932.45) 6,467.19 Capital Outlay ‐ ‐ ‐ 0.00% ‐ 10,514.00 ‐ (10,514.00) Total 20,429.11 172,875.15 389,087.00 44.43% 34,173.31 157,863.08 (13,744.20) 15,012.07 Non‐Departmental Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference City ‐ County Svcs 92,083.33 311,666.68 425,000.00 73.33% 84,166.67 305,833.36 7,916.66 5,833.32 Community Initiatives 67,907.96 533,138.56 979,274.00 54.44% 104,690.50 507,258.04 (36,782.54) 25,880.52 Transfer to DSF ‐ One Cent ‐ 3,299,833.47 3,394,441.00 97.21% 159,100.38 3,335,185.58 (159,100.38) (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 1,757,083.31 2,995,000.00 58.67% 247,167.00 1,730,169.00 2,416.33 26,914.31 Transfer to Capital Project Fund ‐ 49,865.02 75,000.00 66.49% 11,191.78 83,604.44 (11,191.78) (33,739.42) 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 409,574.62 6,402,915.90 8,697,845.00 73.61% 606,316.33 6,078,143.84 (196,741.71) 324,772.06 Debt Service Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Debt Service 153,775.12 1,005,539.94 1,728,000.00 58.19% 147,563.36 988,524.74 6,211.76 17,015.20 Total 153,775.12 1,005,539.94 1,728,000.00 58.19% 147,563.36 988,524.74 6,211.76 17,015.20 Total Apr‐20 YTD Budget % of Budget Apr‐19 YTD April Difference YTD Difference Salary 1,144,335.58 8,902,936.23 16,106,139.14 55.28% 1,103,643.26 7,796,161.64 40,692.32 1,106,774.59 Benefits 439,431.97 3,499,803.39 6,020,625.70 58.13% 431,141.32 3,325,401.96 8,290.65 174,401.43 Operations 734,968.14 5,175,130.50 9,862,517.00 52.47% 908,481.97 4,979,393.04 (173,513.83) 195,737.46 Capital Outlay 118,405.95 410,869.23 1,324,357.00 31.02% 147,176.94 915,436.77 (28,770.99) (504,567.54) Debt Service 153,775.12 4,756,702.27 5,786,470.00 82.20% 306,663.74 4,439,803.74 (152,888.62) 316,898.53 Total 2,590,916.76 22,745,441.62 39,100,108.84 58.17% 2,897,107.23 21,456,197.15 (306,190.47) 1,289,244.47 Prepared by Daniel Oakley