Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
July 2018 - Council Expense Information
As of 8/17/2018 83.33 % Year Complete Executive Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 19,996.82 203,556.83 322,218.00 63.17% 23,187.88 163,613.02 (3,191.06) 39,943.81 Benefits 2,493.69 26,024.90 44,131.00 58.97% 2,206.57 19,202.97 287.12 6,821.93 Operations 3,795.87 64,794.84 105,533.00 61.40% 3,284.01 88,081.71 511.86 (23,286.87) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 26,286.38 294,376.57 471,882.00 62.38% 28,678.46 270,897.70 (2,392.08) 23,478.87 Legislative Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 10,417.04 104,170.40 125,000.00 83.34% 10,417.04 105,176.82 ‐ (1,006.42) Benefits 707.06 7,819.64 10,415.00 75.08% 763.85 7,879.95 (56.79) (60.31) Operations 259.09 7,108.75 25,800.00 27.55%‐ 7,260.25 259.09 (151.50) Capital Outlay ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total 11,383.19 119,098.79 161,215.00 73.88% 11,180.89 120,317.02 202.30 (1,218.23) Finance Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 21,664.92 236,194.19 293,988.00 80.34% 22,062.31 221,312.59 (397.39) 14,881.60 Benefits 3,309.07 36,789.59 47,381.00 77.65% 3,437.80 34,868.84 (128.73) 1,920.75 Operations 11,609.41 199,491.29 259,155.00 76.98% 3,931.54 208,124.12 7,677.87 (8,632.83) Capital Outlay ‐ ‐ 25,000.00 0.00%‐ 28,466.20 ‐ (28,466.20) Total 36,583.40 472,475.07 625,524.00 75.53% 29,431.65 492,771.75 7,151.75 (20,296.68) City Clerk Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 9,813.37 101,977.51 126,487.00 80.62% 9,660.08 100,256.45 153.29 1,721.06 Benefits 1,426.02 15,056.10 20,169.00 74.65% 1,414.99 15,079.68 11.03 (23.58) Operations 660.87 53,128.21 114,800.00 46.28% 2,540.69 37,988.52 (1,879.82) 15,139.69 Capital Outlay ‐ 365.00 ‐ 100.00%‐ ‐ ‐ 365.00 Total 11,900.26 170,526.82 261,456.00 65.22% 13,615.76 153,324.65 (1,715.50) 17,202.17 HR Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 21,410.30 202,238.66 274,485.00 73.68% 16,674.70 173,942.30 4,735.60 28,296.36 Benefits 3,437.21 33,350.24 44,794.00 74.45% 2,658.03 28,509.59 779.18 4,840.65 Operations 8,283.43 86,846.74 87,550.00 99.20% 2,960.65 50,770.95 5,322.78 36,075.79 Capital Outlay ‐ ‐ ‐ 100.00%‐ ‐ ‐ Total 33,130.94 322,435.64 406,829.00 79.26% 22,293.38 253,222.84 10,837.56 69,212.80 IT Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 12,640.67 130,606.63 162,125.00 80.56% 12,276.62 97,484.42 364.05 33,122.21 Benefits 1,766.93 18,712.71 23,874.00 78.38% 1,728.04 14,084.45 38.89 4,628.26 Operations 81,751.93 984,378.77 1,174,168.00 83.84% 75,679.62 1,018,208.61 6,072.31 (33,829.84) Capital Outlay ‐ 50,234.92 64,512.00 77.87%‐ 16,045.76 ‐ 34,189.16 Total 96,159.53 1,183,933.03 1,424,679.00 83.10% 89,684.28 1,145,823.24 6,475.25 38,109.79 Vehicle Maint. Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 18,544.47 174,758.96 243,870.00 71.66% 19,160.35 169,801.08 (615.88) 4,957.88 Benefits 2,867.35 36,633.30 50,505.00 72.53% 2,808.26 39,384.03 59.09 (2,750.73) Operations 3,834.83 31,789.76 104,950.00 30.29% (7,481.23) 63,230.40 11,316.06 (31,440.64) Capital Outlay ‐ ‐ 25,000.00 0.00%‐ ‐ Total 25,246.65 243,182.02 424,325.00 57.31% 14,487.38 272,415.51 10,759.27 (29,233.49) City of Prattville July Unaudited Expenses By Department Engineering Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 36,860.57 359,658.17 471,460.00 76.29% 30,955.90 343,028.91 5,904.67 16,629.26 Benefits 6,079.61 73,965.63 93,269.00 79.30% 5,109.07 77,454.56 970.54 (3,488.93) Operations 51,499.49 305,908.45 622,346.00 49.15% 43,129.29 276,327.51 8,370.20 29,580.94 Captial Projects ‐ ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ ‐ 146,476.00 0.00%‐ 268,977.61 ‐ (268,977.61) Total 94,439.67 739,532.25 1,333,551.00 55.46% 79,194.26 965,788.59 15,245.41 (226,256.34) Planning Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 10,780.12 176,173.42 247,504.00 71.18% 20,230.88 208,731.00 (9,450.76) (32,557.58) Benefits 1,792.00 28,633.74 41,702.00 68.66% 3,409.35 35,909.66 (1,617.35) (7,275.92) Operations 57,372.06 381,956.46 503,700.00 75.83% 22,183.91 350,306.22 35,188.15 31,650.24 Captial Projects ‐ ‐ ‐ 0.00%‐ ‐ Capital Outlay ‐ 6,011.00 6,000.00 100.18%‐ 27,839.00 ‐ (21,828.00) Total 69,944.18 592,774.62 798,906.00 74.20% 45,824.14 622,785.88 24,120.04 (30,011.26) Urban Management Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 60,125.69 542,907.50 649,770.00 83.55% 70,241.58 669,373.16 (10,115.89) (126,465.66) Benefits 8,474.85 100,226.57 123,709.00 81.02% 9,952.83 130,299.44 (1,477.98) (30,072.87) Operations 33,605.48 312,970.46 564,750.00 55.42% 25,212.03 270,393.45 8,393.45 42,577.01 Capital Outlay 22,524.00 22,524.00 191,500.00 11.76%‐ 8,397.52 22,524.00 14,126.48 Total 124,730.02 978,628.53 1,529,729.00 63.97% 105,406.44 1,078,463.57 19,323.58 (99,835.04) Facilities Maintenance Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 24,735.01 231,929.22 267,205.00 86.80% 14,483.14 150,675.40 10,251.87 81,253.82 Benefits 3,496.08 42,802.39 47,755.00 89.63% 2,179.05 28,568.46 1,317.03 14,233.93 Operations 18,237.44 110,523.66 137,500.00 80.38% 2,609.79 43,250.76 15,627.65 67,272.90 Capital Outlay 7,755.12 19,854.09 372,000.00 5.34%‐ 21,868.00 7,755.12 (2,013.91) Total 54,223.65 405,109.36 824,460.00 49.14% 19,271.98 244,362.62 34,951.67 160,746.74 Public Works Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 19,673.14 293,023.31 582,714.00 50.29% 17,171.21 145,145.16 2,501.93 147,878.15 Benefits 3,088.12 80,582.14 131,966.00 61.06% 2,713.51 29,514.52 374.61 51,067.62 Operations 3,830.31 100,332.30 230,168.00 43.59% 2,145.00 59,975.91 1,685.31 40,356.39 Capital Outlay ‐ 6,550.00 85,000.00 7.71% 206,903.00 240,249.00 (206,903.00) (233,699.00) Total 26,591.57 480,487.75 1,029,848.00 46.66% 228,932.72 474,884.59 (202,341.15) 5,603.16 Police Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 348,564.55 3,845,068.66 5,031,675.00 76.42% 357,467.45 3,788,860.89 (8,902.90) 56,207.77 Benefits 55,500.19 779,924.51 1,016,170.00 76.75% 57,229.16 759,435.06 (1,728.97) 20,489.45 Operations 84,331.22 961,735.63 1,237,931.00 77.69% 91,099.14 988,684.26 (6,767.92) (26,948.63) Capital Outlay ‐ 184,267.28 283,134.00 65.08%‐ 167,034.00 ‐ 17,233.28 Total 488,395.96 5,770,996.08 7,568,910.00 76.25% 505,795.75 5,704,014.21 (17,399.79) 66,981.87 Fire Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 350,147.47 3,728,817.62 4,590,342.00 81.23% 339,582.10 3,628,568.60 10,565.37 100,249.02 Benefits 56,602.51 772,589.22 959,212.00 80.54% 55,386.13 791,708.25 1,216.38 (19,119.03) Operations 55,449.26 843,041.54 1,146,362.00 73.54% 47,760.02 720,846.17 7,689.24 122,195.37 Capital Outlay ‐ 35,936.25 138,752.00 25.90% 13,568.88 789,139.30 (13,568.88) (753,203.05) Total 462,199.24 5,380,384.63 6,834,668.00 78.72% 456,297.13 5,930,262.32 5,902.11 (549,877.69) Building Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 22,679.74 222,494.85 292,550.00 76.05% 22,295.20 233,785.24 384.54 (11,290.39) Benefits 3,688.41 39,693.82 54,720.00 72.54% 3,595.02 43,348.56 93.39 (3,654.74) Operations 1,640.94 38,557.31 63,450.00 60.77% 1,848.29 29,676.99 (207.35) 8,880.32 Capital Outlay ‐ ‐ ‐ 0.00%‐ 40,000.00 ‐ (40,000.00) Total 28,009.09 300,745.98 410,720.00 73.22% 27,738.51 346,810.79 270.58 (46,064.81) Parks & Recreation Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 78,189.74 564,471.76 718,665.00 78.54% 75,663.17 546,036.38 2,526.57 18,435.38 Benefits 9,836.67 94,922.06 122,111.00 77.73% 9,014.62 97,702.90 822.05 (2,780.84) Operations 113,626.18 687,263.51 1,161,416.00 59.17% 38,733.46 516,298.12 74,892.72 170,965.39 Capital Outlay/ Capital Projects 54,856.10 191,972.19 440,083.00 43.62% 30,242.52 149,100.93 24,613.58 42,871.26 Total 256,508.69 1,538,629.52 2,442,275.00 63.00% 153,653.77 1,309,138.33 102,854.92 229,491.19 Performing Arts Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 6,451.21 60,723.01 77,613.00 78.24% 10,655.42 56,760.98 (4,204.21) 3,962.03 Benefits 930.88 8,931.65 16,411.00 54.42% 1,538.83 8,396.69 (607.95) 534.96 Operations 17,847.71 130,071.05 222,760.00 58.39% 7,873.40 113,228.41 9,974.31 16,842.64 Capital Outlay ‐ ‐ ‐ ‐ ‐ Total 25,229.80 199,725.71 316,784.00 63.05% 20,067.65 178,386.08 5,162.15 21,339.63 Non‐Departmental Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference City ‐ County Svcs 84,166.66 393,333.34 410,000.00 95.93% 77,500.00 386,666.68 6,666.66 6,666.66 Community Initiatives 53,530.31 563,930.00 930,624.00 60.60% 45,697.57 516,869.84 7,832.74 47,060.16 Transfer to DSF ‐ One Cent ‐ 4,955,997.97 6,366,000.00 77.85%‐ ‐ 4,955,997.97 Transfer to DSF ‐ Other 6,215.00 164,205.83 164,206.00 100.00%‐ 6,215.00 164,205.83 Transfer to Group Health 249,375.00 2,493,750.00 2,992,500.00 83.33% 207,168.75 2,071,687.50 42,206.25 422,062.50 Transfer to Capital Project Fund 11,464.47 731,366.64 112,300.00 651.26% 54,364.48 299,204.88 (42,900.01) 432,161.76 Transfer to Judicial ‐ 53,093.00 0.00%‐ ‐ Total 404,751.44 9,302,583.78 11,028,723.00 84.35% 384,730.80 3,274,428.90 20,020.64 6,028,154.88 Debt Service Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Debt Service 50,127.42 1,090,390.67 1,441,350.00 75.65% 110,042.02 1,390,467.17 (59,914.60) (300,076.50) Total 50,127.42 1,090,390.67 1,441,350.00 75.65% 110,042.02 1,390,467.17 (59,914.60) (300,076.50) Total Jul‐18 YTD Budget % of Budget Jul‐17 YTD July Difference YTD Difference Salary 1,072,694.83 11,178,770.70 14,477,671.00 77.21% 1,072,185.03 10,802,552.40 509.80 376,218.30 Benefits 414,871.65 4,690,408.21 5,840,794.00 80.30% 372,313.86 4,233,035.11 42,557.79 457,373.10 Operations 696,796.96 6,988,528.71 9,268,356.00 75.40% 541,071.66 6,045,393.76 155,725.30 943,134.95 Capital Outlay 85,135.22 517,714.73 1,777,457.00 29.13% 250,714.40 1,757,117.32 (165,579.18) (1,239,402.59) Debt Service 56,342.42 6,210,594.47 7,971,556.00 77.91% 110,042.02 1,390,467.17 (53,699.60) 4,820,127.30 Total 2,325,841.08 29,586,016.82 39,335,834.00 75.21% 2,346,326.97 24,228,565.76 (20,485.89) 5,357,451.06 Prepared by Daniel Oakley