Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
MR 0418 Finance
NORTH AUGUSTA FINANCE DEPARTMENT CAMMIE T. HAYES, DIRECTOR FOR THE MONTH OF APRIL, 2018 5/11/2018 Laserfiche/FI0914#1 (2) This Month: April 2018Page 1 of 6 GGENERAL FUND REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 8 2 0 1 8 22 0 1 8 MonthlyYTD MonthlyYTDMonthlyYTDMonthlyYTDMonthlyYTDMonthlyYTD JAN1,419,5931,419,5931,220,6881,220,6881,159,5311,159,5311,074,2891,074,289 260,062260,062146,399146,399 FEB1,453,6002,873,1931,447,9972,668,6851,966,7423,126,2731,570,9002,645,189(513,142)(253,080)(122,903)23,496 MAR3,296,9006,170,0933,795,8276,464,5121,258,2624,384,5351,503,9514,149,1402,038,6381,785,5582,291,8762,315,372 APR3,513,8039,683,8963,505,6749,970,1861,387,5535,772,0881,244,5525,393,6922,126,2503,911,8082,261,1224,576,494 MAY1,269,44411,239,6301,536,2076,929,899(266,763)4,309,731 JUNE2,380,65313,620,2831,078,7778,008,6761,301,8765,611,607 JULY801,93414,422,2171,413,4809,422,156(611,546)5,000,061 AUG529,29714,951,5141,283,38010,705,536(754,083)4,245,978 SEPT471,80615,423,3201,264,85611,970,392(793,050)3,452,928 OCT745,79616,169,1161,783,88113,754,273(1,038,085)2,414,843 NOV420,73416,589,8501,126,15114,880,424(705,417)1,709,426 DEC453,23617,043,0861,728,46416,608,888(1,275,228)434,198 2 0 1 72 0 1 72 0 1 7 (1,000,000) 0 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 JANFEBMARAPRMAYJUNEJULYAUGSEPTOCTNOVDEC YEAR-TO-DATE BALANCE 2013 2014 2015 2016 2017 2018 3,911,808 5/11/2018 Laserfiche/FI0914#2 (2)This Month: April 2018Page 2 of 6 SSTORMWATER UTILITY FUND REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 8 2 0 1 8 MonthlyYTDMonthlyYTDMonthlyYTDMonthlyYTDMonthlyYTD Monthly YTD JAN66,96166,96166,17566,175 37,76937,76928,72128,72129,19229,19237,45437,454 FEB66,146133,10764,517130,69248,38386,15233,23061,95117,76346,95531,28768,741 MAR68,081201,18864,572195,26437,630123,78235,47197,42230,45177,40629,10197,842 APR66,305267,49365,599260,86342,090165,87237,358134,78024,215101,62128,241126,083 MAY65,389326,25249,154183,93416,235142,318 JUNE66,869393,12132,027215,96134,842177,160 JULY65,213458,33461,676277,6373,537180,697 AUG67,406525,74055,989333,62611,417192,114 SEPT65,922591,66236,867370,49329,055221,169 OCT65,419657,08158,167428,6607,252228,421 NOV67,537724,61835,881464,54131,656260,077 DEC66,097790,71556,969521,5109,128269,205 2 0 1 8 2 0 1 72 0 1 72 0 1 7 (50,000) 0 50,000 100,000 150,000 200,000 250,000 300,000 350,000 JANFEBMARAPRMAYJUNEJULYAUGSEPTOCTNOVDEC YEAR-TO-DATE BALANCE 2013 2014 2015 2016 2017 2018 101,621 5/11/2018 Laserfiche/FI0914#3 (3)This Month: April 2018Page 3 of 6 SSANITATION SERVICES FUND REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 7 2 0 1 7 22 0 1 7 MonthlyYTDMonthlyYTDMonthlyYTDMonthlyYTDMonthlyYTD Monthly YTD JAN350,100350,100297,001297,001 341,573341,573307,657307,6578,5278,527(10,656)(10,656) FEB308,941659,041369,289666,290583,964925,537426,569734,226(275,023)(266,496)(57,280)(67,936) MAR382,2781,041,319318,544984,834515,7191,441,256550,3311,284,557(133,441)(399,937)(231,787)(299,723) APR*364,995 1,406,314 383,335 1,368,169 509,075 1,950,331 274,223 1,558,780 (144,080) (544,017) 109,112 (190,611) MAY422,9751,791,144336,0901,894,87086,885(103,726) JUNE398,8592,190,003263,9852,158,855134,87431,148 JULY445,7242,635,727354,9062,513,76190,818121,966 AUG326,1192,961,846270,5602,784,32155,559177,525 SEPT375,2893,337,135293,9653,078,28681,324258,849 OCT390,1963,727,331386,4063,464,6923,790262,639 NOV369,7384,097,069261,2653,725,957108,473371,112 DEC448,5064,545,575374,8264,100,78373,680444,792 * Increased expense for 2018, as compared to the prior year, is related to refurbishment of the MRF compactor, lease purchse, and personnel costs. 2 0 1 8 2 0 1 8 2 0 1 8 (800,000) (600,000) (400,000) (200,000) 0 200,000 400,000 600,000 JANFEBMARAPR*MAYJUNEJULYAUGSEPTOCTNOVDEC YEAR-TO-DATE BALANCE 2013 2014 2015 2016 2017 2018 (544,017) 5/11/2018 Laserfiche/FI0914#4 This Month: April 2018Page 4 of 6 WATERWORKS & SEWER SYSTEM REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 7 2 0 1 7 22 0 1 7 MonthlyYTDMonthlyYTDMonthlyYTDMonthlyYTDMonthlyYTDMonthlyYTD JAN845,752845,752772,189772,189593,360593,360490,819490,819252,392252,392281,370281,370 FEB862,1271,707,879806,1791,578,368823,6671,417,027898,2461,389,06538,460290,852(92,067)189,303 MAR773,5542,481,433751,8512,330,2191,206,4902,623,5171,114,1092,503,174(432,936)(142,084)(362,258)(172,955) APR809,060 3,290,493 783,350 3,113,569 755,541 3,379,058 690,954 3,194,128 53,519 (88,565) 92,396 (80,559) MAY786,7483,900,317772,7253,966,85314,023(66,536) JUNE853,0244,753,341596,3954,563,248256,629190,093 JULY1,063,2745,816,615812,6645,375,912250,610440,703 AUG829,8996,646,514742,5906,118,50287,309528,012 SEPT959,0457,605,559665,9836,784,485293,062821,074 OCT795,2428,400,801830,9087,615,393(35,666)785,408 NOV893,3439,294,144674,7908,290,183218,5531,003,961 DEC816,38310,110,527989,9649,280,147(173,581)830,380 2 0 1 8 2 0 1 8 2 0 1 8 (800,000) (600,000) (400,000) (200,000) 0 200,000 400,000 600,000 800,000 1,000,000 1,200,000 JANFEBMARAPRMAYJUNEJULYAUGSEPTOCTNOVDEC YEAR-TO-DATE BALANCE 2013 2014 2015 2016 2017 2018 (88,565) 5/11/2018 OOPERATING FUNDS &2017 2018 YTD PERCENT ANNUAL DEPARTMENTS EXPENDED EXPENDED 4 MO=33.33%BUDGET BALANCE GENERAL FUND (10): CITY COUNCIL47,947.8053,151.1029.60%179,546.00126,394.90 ADMINISTRATION83,774.24125,528.7432.62%384,803.00259,274.26 INFORMATION TECHNOLOGY72,484.1579,504.7127.38%290,404.00210,899.29 JUSTICE & LAW201,766.04189,122.4726.37%717,238.00528,115.53 COMMUNITY PROMOTION40,570.4628,175.3637.65%74,831.0046,655.64 FINANCE135,122.11134,547.4830.94%434,889.00300,341.52 HUMAN RESOURCES58,957.5665,734.1427.66%237,680.00171,945.86 BUILDING STANDARDS111,976.29120,280.9230.96%388,469.00268,188.08 PLANNING & DEVELOPMENT85,619.1826,458.769.48%279,095.00252,636.24 CITY BUILDINGS81,375.2696,244.3729.45%326,797.00230,552.63 PROPERTY MAINTENANCE471,783.03492,234.6137.68%1,306,187.00813,952.39 PUBLIC SAFETY2,697,260.573,034,206.6936.29%8,360,016.005,325,809.31 ENGINEERING65,273.4565,780.2332.01%205,488.00139,707.77 STREET LIGHTS & SIGNALS119,122.65135,032.5327.80%485,670.00350,637.47 STREETS & DRAINS278,441.11315,917.0435.28%895,575.00579,657.96 RECREATION311,004.29310,853.8835.12%885,235.00574,381.12 PARKS223,274.64166,433.9431.32%531,320.00364,886.06 COMMUNITY CENTER47,874.7348,250.7227.57%175,016.00126,765.28 TOURISM63,940.5174,578.3818.93%394,021.00319,442.62 RVP ACTIVITIES CENTER196,124.31210,052.0526.47%793,603.00583,550.95 GGENERAL FUND TOTAL 5,393,692.385,772,088.1233.28%17,345,883.0011,573,794.88 SSTORMWATER UTILITY FUND (11): INFORMATION TECHNOLOGY1,021.82801.523.21%24,975.0024,173.48 STORMWATER 151,214.63164,371.5721.85%752,198.00587,826.43 HUMAN RESOURCES838.82698.670.09%780,796.00780,097.33 SSTORMWATER FUND TOTAL 153,075.27165,871.7610.65%1,557,969.001,392,097.24 SSANITATION FUND (13): INFORMATION TECHNOLOGY31,747.0732,752.4553.71%60,985.0028,232.55 SANITATION 838,573.48929,737.3036.42%2,553,111.001,623,373.70 RECYLING529,958.00770,076.8045.80%1,681,237.00911,160.20 HUMAN RESOURCES3,348.343,280.4617.89%18,341.0015,060.54 TRANSFERS155,173.00214,484.00100.00%214,484.000.00 SSANITATION FUND TOTAL 1,558,799.891,950,331.0143.07%4,528,158.002,577,826.99 OO & M FUND (21): INFORMATION TECHNOLOGY74,597.1583,938.8023.65%354,944.00271,005.20 HUMAN RESOURCES2,786.472,590.1417.10%15,151.0012,560.86 UTILITIES FINANCE124,819.90143,457.3527.96%513,145.00369,687.65 UTILITIES ADMINISTRATION182,027.37193,130.0330.66%629,998.00436,867.97 WATER OPERATIONS288,787.27337,006.4442.25%797,612.00460,605.56 WATER PRODUCTION440,574.24520,613.1333.82%1,539,554.001,018,940.87 WASTEWATER OPERATIONS1,026,447.20942,663.3224.46%3,853,413.002,910,749.68 TRANSFERS383,395.00478,767.00100.00%478,767.000.00 OO & M FUND TOTAL 2,523,434.602,702,166.2133.02%8,182,584.005,480,417.79 Laserfiche/FI0914#5 Page 5 of 6 DDEPARTMENT COMPARATIVE DATA (2017-2018) This Month: April 2018 5/11/2018 Laserfiche/FI0914#6 This Month: April 2018Page 6 of 6 201320142015201620172018 JAN87,534,10067,527,80066,593,80080,612,50066,226,50070,472,600 FEB79,331,60070,558,90064,130,00063,228,90067,248,70071,463,100 MAR72,713,00059,501,80061,445,10063,146,80066,873,20063,382,300 APR83,519,70066,036,80069,821,80075,996,30076,591,70067,096,100 MAY104,337,30087,006,60078,135,50091,865,70095,937,000 JUN143,562,600102,185,100114,293,800117,019,167110,442,100 JUL133,404,400119,881,100130,932,600127,708,867104,063,100 AUG107,485,366110,592,200128,369,800123,927,500103,060,200 SEP106,427,500128,709,100115,214,244128,532,700110,350,200 OCT126,482,300102,242,40096,463,100101,300,80095,226,700 NOV103,845,70082,984,30070,516,400109,895,80099,336,800 DEC74,656,80078,370,20073,391,30083,710,80078,090,700 TOTAL1,223,300,3661,075,596,3001,069,307,4441,166,945,8341,073,446,900272,414,100 GGALLONS OF WATER BILLED 0 20,000,000 40,000,000 60,000,000 80,000,000 100,000,000 120,000,000 140,000,000 160,000,000 180,000,000 200,000,000 JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC GALLONS OF WATER BILLED 2013 2014 2015 2016 2017 2018 67,096,100