Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
March 2020 - General Fund Expense Report
As of 4/17/2020 50.00 % Year Complete Executive Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 20,215.46 136,433.87 284,622.67 47.93% 34,579.57 129,726.85 (14,364.11) 6,707.02 Benefits 2,540.18 17,416.19 43,490.97 40.05% 4,093.67 16,215.81 (1,553.49) 1,200.38 Operations 4,311.18 50,022.96 162,775.00 30.73% 7,300.12 66,318.51 (2,988.94) (16,295.55) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 27,066.82 203,873.02 490,888.64 41.53% 45,973.36 212,261.17 (18,906.54) (8,388.15) Legislative Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 10,417.04 62,502.24 125,000.00 50.00% 10,417.04 62,502.24 ‐ ‐ Benefits 717.82 4,720.10 10,299.00 45.83% 754.40 4,713.85 (36.58) 6.25 Operations 804.00 2,391.88 13,300.00 17.98% 2,937.88 5,544.45 (2,133.88) (3,152.57) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 11,938.86 69,614.22 148,599.00 46.85% 14,109.32 72,760.54 (2,170.46) (3,146.32) Finance Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 25,036.10 163,274.82 360,253.00 45.32% 33,371.40 139,698.48 (8,335.30) 23,576.34 Benefits 4,052.66 26,591.79 60,616.00 43.87% 5,542.28 23,775.24 (1,489.62) 2,816.55 Operations 33,682.49 149,288.95 240,360.00 62.11% 15,065.37 114,290.66 18,617.12 34,998.29 Capital Outlay ‐ ‐ 0.00% ‐ ‐ Total 62,771.25 339,155.56 661,229.00 51.29% 53,979.05 277,764.38 8,792.20 61,391.18 City Clerk Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 9,237.90 65,944.57 139,619.00 47.23% 14,505.42 62,706.54 (5,267.52) 3,238.03 Benefits 1,448.74 10,933.84 24,068.00 45.43% 2,394.41 10,474.55 (945.67) 459.29 Operations 1,416.17 14,558.57 108,240.00 13.45% 1,955.58 15,481.73 (539.41) (923.16) Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 12,102.81 91,436.98 271,927.00 33.63% 18,855.41 88,662.82 (6,752.60) 2,774.16 HR Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 23,724.53 154,573.68 308,420.00 50.12% 32,710.58 135,651.14 (8,986.05) 18,922.54 Benefits 4,198.95 27,696.68 56,426.00 49.08% 5,821.18 24,935.65 (1,622.23) 2,761.03 Operations 11,360.81 34,070.98 72,275.00 47.14% 10,609.87 34,533.39 750.94 (462.41) Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 39,284.29 216,341.34 437,121.00 49.49% 49,141.63 195,120.18 (9,857.34) 21,221.16 IT Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 15,206.28 95,954.55 195,466.00 49.09% 19,680.23 81,356.10 (4,473.95) 14,598.45 Benefits 2,268.00 14,607.84 30,262.00 48.27% 2,966.81 12,630.89 (698.81) 1,976.95 Operations 69,657.53 756,778.30 1,371,831.00 55.17% 166,062.76 755,820.12 (96,405.23) 958.18 Capital Outlay ‐ 94,038.13 200,000.00 47.02% 33,515.00 33,515.00 (33,515.00) 60,523.13 Total 87,131.81 961,378.82 1,797,559.00 53.48% 222,224.80 883,322.11 (135,092.99) 78,056.71 Vehicle Maint. Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 17,363.56 113,118.35 228,594.00 49.48% 26,644.17 116,333.09 (9,280.61) (3,214.74) Benefits 2,847.46 24,814.29 43,245.00 57.38% 4,298.44 26,309.72 (1,450.98) (1,495.43) Operations 9,879.44 46,415.98 98,650.00 47.05% 5,351.17 26,498.34 4,528.27 19,917.64 Capital Outlay ‐ 8,580.00 37,000.00 23.19% ‐ ‐ ‐ 8,580.00 Total 30,090.46 192,928.62 407,489.00 47.35% 36,293.78 169,141.15 (6,203.32) 23,787.47 City of Prattville March 2020 Unaudited Expenditures By Department Engineering Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 33,164.85 225,406.94 552,052.00 40.83% 55,104.57 229,345.74 (21,939.72) (3,938.80) Benefits 5,857.24 51,710.41 113,511.00 45.56% 10,046.83 54,558.19 (4,189.59) (2,847.78) Operations 30,914.43 168,978.48 566,300.00 29.84% 53,547.61 167,454.32 (22,633.18) 1,524.16 Capital Outlay 12,750.00 12,750.00 333,718.00 0.00% ‐ ‐ 12,750.00 12,750.00 Total 82,686.52 458,845.83 1,565,581.00 29.31% 118,699.01 451,358.25 (36,012.49) 7,487.58 Planning Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 24,222.51 152,843.50 347,578.47 43.97% 24,542.53 95,213.77 (320.02) 57,629.73 Benefits 4,437.82 27,629.46 67,357.73 41.02% 4,782.48 18,017.49 (344.66) 9,611.97 Operations 35,109.33 245,976.09 727,450.00 33.81% 38,084.82 201,548.90 (2,975.49) 44,427.19 Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 63,769.66 426,449.05 1,142,386.20 37.33% 67,409.83 314,780.16 (3,640.17) 111,668.89 Urban Management Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 67,974.27 437,055.40 927,120.00 47.14% 77,034.02 330,262.54 (9,059.75) 106,792.86 Benefits 10,955.95 82,855.06 167,371.00 49.50% 12,904.72 68,733.75 (1,948.77) 14,121.31 Operations 28,821.48 242,129.03 493,000.00 49.11% 33,453.61 217,441.52 (4,632.13) 24,687.51 Capital Outlay ‐ ‐ 30,000.00 0.00% ‐ ‐ ‐ ‐ Total 107,751.70 762,039.49 1,617,491.00 47.11% 123,392.35 616,437.81 (15,640.65) 145,601.68 Facilities Maintenance Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 27,750.99 180,600.98 363,631.00 49.67% 37,908.23 156,239.80 (10,157.24) 24,361.18 Benefits 4,230.46 30,961.61 59,507.00 52.03% 6,068.41 27,825.89 (1,837.95) 3,135.72 Operations 7,942.24 70,203.11 194,210.00 36.15% 3,075.91 69,379.99 4,866.33 823.12 Capital Outlay ‐ 13,626.00 91,466.00 14.90% 2,500.00 2,500.00 (2,500.00) 11,126.00 Total 39,923.69 295,391.70 708,814.00 41.67% 49,552.55 255,945.68 (9,628.86) 39,446.02 Public Works Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 24,556.88 155,731.43 312,653.00 49.81% 29,916.81 124,047.42 (5,359.93) 31,684.01 Benefits 4,188.66 30,037.51 58,569.00 51.29% 5,176.81 24,915.22 (988.15) 5,122.29 Operations 14,951.50 140,039.95 224,718.00 62.32% 18,217.87 122,566.23 (3,266.37) 17,473.72 Capital Outlay ‐ ‐ 225,000.00 0.00% ‐ ‐ ‐ ‐ Total 43,697.04 325,808.89 820,940.00 39.69% 53,311.49 271,528.87 (9,614.45) 54,280.02 Police Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 389,524.93 2,616,906.67 5,557,043.00 47.09% 545,541.06 2,299,392.67 (156,016.13) 317,514.00 Benefits 63,095.53 527,443.89 1,044,030.00 50.52% 92,278.47 485,913.84 (29,182.94) 41,530.05 Operations 78,527.78 696,088.41 1,425,809.00 48.82% 140,645.05 625,634.82 (62,117.27) 70,453.59 Capital Outlay 17,316.12 113,457.04 133,600.00 84.92% ‐ 103,532.00 17,316.12 9,925.04 Total 548,464.36 3,953,896.01 8,160,482.00 48.45% 778,464.58 3,514,473.33 (230,000.22) 439,422.68 Fire Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 351,864.36 2,527,161.09 5,047,501.00 50.07% 526,870.70 2,182,832.56 (175,006.34) 344,328.53 Benefits 60,697.75 553,899.58 1,012,418.00 54.71% 93,692.84 504,919.80 (32,995.09) 48,979.78 Operations 87,004.43 445,861.51 1,044,321.00 42.69% 80,657.99 462,294.42 6,346.44 (16,432.91) Capital Outlay ‐ 29,990.00 0.00% 70,380.00 248,060.00 (70,380.00) (248,060.00) Total 499,566.54 3,526,922.18 7,134,230.00 49.44% 771,601.53 3,398,106.78 (272,034.99) 128,815.40 Building Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 18,958.89 122,108.83 244,473.00 49.95% 34,745.76 142,261.09 (15,786.87) (20,152.26) Benefits 3,300.33 24,518.54 49,214.00 49.82% 6,231.50 28,866.79 (2,931.17) (4,348.25) Operations 1,329.52 24,167.67 55,450.00 43.58% 1,440.59 23,359.06 (111.07) 808.61 Capital Outlay ‐ ‐ ‐ 0.00% ‐ ‐ ‐ ‐ Total 23,588.74 170,795.04 349,137.00 48.92% 42,417.85 194,486.94 (18,829.11) (23,691.90) Parks & Recreation Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 81,331.20 490,208.69 1,005,486.00 48.75% 94,817.70 363,059.11 (13,486.50) 127,149.58 Benefits 12,424.09 88,418.81 169,471.00 52.17% 14,815.96 71,820.95 (2,391.87) 16,597.86 Operations 83,969.40 533,456.36 1,174,070.00 45.44% 64,589.18 401,442.20 19,380.22 132,014.16 Capital Outlay/ Capital Projects 13,532.11 50,012.11 243,583.00 20.53% 19,814.83 370,138.83 (6,282.72) (320,126.72) Total 191,256.80 1,162,095.97 2,592,610.00 44.82% 194,037.67 1,206,461.09 (2,780.87) (44,365.12) Performing Arts Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 9,863.95 58,775.04 106,627.00 55.12% 11,600.11 41,889.24 (1,736.16) 16,885.80 Benefits 1,411.85 8,615.84 15,770.00 54.63% 1,739.58 6,631.01 (327.73) 1,984.83 Operations 19,735.68 85,055.16 266,690.00 31.89% 15,082.85 64,655.52 4,652.83 20,399.64 Capital Outlay ‐ ‐ ‐ 0.00% ‐ 10,514.00 ‐ (10,514.00) Total 31,011.48 152,446.04 389,087.00 39.18% 28,422.54 123,689.77 2,588.94 28,756.27 Non‐Departmental Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference City ‐ County Svcs 7,083.33 219,583.35 425,000.00 51.67% 6,666.67 221,666.69 416.66 (2,083.34) Community Initiatives 61,501.79 465,230.60 979,274.00 47.51% 64,088.04 402,567.54 (2,586.25) 62,663.06 Transfer to DSF ‐ One Cent 125,000.00 3,299,833.47 3,394,441.00 97.21% ‐ 3,176,085.20 125,000.00 123,748.27 Transfer to DSF ‐ Other 92,941.47 451,328.86 664,029.00 67.97% ‐ 116,093.42 92,941.47 335,235.44 Transfer to Group Health 259,583.33 1,507,499.98 2,995,000.00 50.33% 247,167.00 1,483,002.00 12,416.33 24,497.98 Transfer to Capital Project Fund 39,092.78 49,865.02 75,000.00 66.49% 9,096.48 72,412.66 29,996.30 (22,547.64) Transfer to Gas Tax Fund ‐ ‐ 22,000.00 0.00% ‐ ‐ ‐ ‐ Transfer to Judicial ‐ 121,794.00 0.00% ‐ ‐ ‐ ‐ Total 585,202.70 5,993,341.28 8,676,538.00 69.08% 327,018.19 5,471,827.51 258,184.51 521,513.77 Debt Service Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Debt Service 169,918.05 851,764.82 1,728,000.00 49.29% 122,145.84 840,961.38 47,772.21 10,803.44 Total 169,918.05 851,764.82 1,728,000.00 49.29% 122,145.84 840,961.38 47,772.21 10,803.44 Total Mar‐20 YTD Budget % of Budget Mar‐19 YTD March Difference YTD Difference Salary 1,150,413.70 7,758,600.65 16,106,139.14 48.17% 1,609,989.90 6,692,518.38 (459,576.20) 1,066,082.27 Benefits 448,256.82 3,060,371.42 6,020,625.70 50.83% 520,775.79 2,894,260.64 (72,518.97) 166,110.78 Operations 627,095.31 4,440,162.36 9,862,517.00 45.02% 737,929.42 4,070,911.07 (110,834.11) 369,251.29 Capital Outlay 43,598.23 292,463.28 1,324,357.00 22.08% 126,209.83 768,259.83 (82,611.60) (475,796.55) Debt Service 387,859.52 4,602,927.15 5,786,470.00 79.55% 122,145.84 4,133,140.00 265,713.68 469,787.15 Total 2,657,223.58 20,154,524.86 39,100,108.84 51.55% 3,117,050.78 18,559,089.92 (459,827.20) 1,595,434.94 Prepared by Daniel Oakley