Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
07.31.2019 July
NORTH AUGUSTA FINANCE DEPARTMENT CAMMIE T. HAYES, DIRECTOR FOR THE MONTH OF JULY, 2019 8/9/2019 Laserfiche/FI0914#1 This Month: July 2019 Page 1 of 6 REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 9 2 0 1 9 2 0 1 9 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 1,380,934 1,380,934 1,419,593 1,419,593 1,323,136 1,323,136 1,159,531 1,159,531 57,798 57,798 260,062 260,062 FEB 1,658,695 3,039,629 1,453,600 2,873,193 1,723,448 3,046,584 1,966,742 3,126,273 (64,753)(6,955)(513,142)(253,080) MAR 2,140,822 5,180,451 3,296,900 6,170,093 1,671,764 4,718,348 1,258,262 4,384,535 469,058 462,103 2,038,638 1,785,558 APR 4,324,373 9,504,824 3,513,803 9,683,896 1,789,807 6,508,155 1,387,553 5,772,088 2,534,566 2,996,669 2,126,250 3,911,808 MAY 1,429,984 10,934,808 808,100 10,491,996 1,330,968 7,839,123 1,526,539 7,298,627 99,016 3,095,685 (718,439)3,193,369 JUNE*4,529,490 15,464,298 2,694,795 13,186,791 1,347,319 9,186,442 1,274,638 8,573,265 3,182,171 6,277,856 1,420,157 4,613,526 JULY 988,789 16,453,087 2,345,871 15,532,662 1,780,636 10,967,078 1,598,431 10,171,696 (791,847)5,486,009 747,440 5,360,966 AUG 451,623 15,984,285 1,323,435 11,495,131 (871,812)4,489,154 SEPT 277,541 16,261,826 1,243,857 12,738,988 (966,316)3,522,838 OCT 608,769 16,870,595 1,674,070 14,413,058 (1,065,301)2,457,537 NOV 654,900 17,525,495 1,218,159 15,631,217 (563,259)1,894,278 DEC 657,439 18,182,934 1,594,930 17,226,147 (937,491)956,787 * Business license payment received in June vs July for the prior year. 2 0 1 82 0 1 82 0 1 8 GENERAL FUND (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 JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YEAR-TO-DATE BALANCE 2014 2015 2016 2017 2018 2019 5,486,009 8/9/2019 Laserfiche/FI0914#2 This Month: July 2019 Page 2 of 6 STORMWATER UTILITY FUND REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 9 2 0 1 8 2 0 1 9 2 0 1 8 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 68,228 68,228 66,961 66,961 37,913 37,913 37,769 37,769 30,315 30,315 29,192 29,192 FEB 69,151 137,379 66,146 133,107 54,834 92,747 48,383 86,152 14,317 44,632 17,763 46,955 MAR 71,585 208,964 68,081 201,188 51,554 144,301 37,630 123,782 20,031 64,663 30,451 77,406 APR 68,835 277,799 66,305 267,493 86,041 230,342 42,090 165,872 (17,206)47,457 24,215 101,621 MAY 71,629 349,428 66,519 334,012 40,799 271,141 65,471 231,343 30,830 78,287 1,048 102,669 JUNE 71,391 420,819 69,015 403,027 54,476 325,617 33,513 264,856 16,915 95,202 35,502 138,171 JULY 68,676 489,495 66,698 469,725 72,149 397,766 45,519 310,375 (3,473)91,729 21,179 159,350 AUG 66,946 536,671 116,784 427,159 (49,838)109,512 SEPT 69,305 605,976 53,811 480,970 15,494 125,006 OCT 70,324 676,300 54,419 535,389 15,905 140,911 NOV 67,481 743,781 42,123 577,512 25,358 166,269 DEC 73,083 816,864 55,594 633,106 17,489 183,758 2 0 1 9 2 0 1 8 (50,000) 0 50,000 100,000 150,000 200,000 250,000 300,000 350,000 JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YEAR-TO-DATE BALANCE 2014 2015 2016 2017 2018 2019 91,729 8/9/2019 Laserfiche/FI0914#3 This Month: July 2019 Page 3 of 6 SANITATION SERVICES FUND REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 8 2 0 1 8 2 0 1 8 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 295,207 295,207 350,100 350,100 326,136 326,136 341,573 341,573 (30,929)(30,929)8,527 8,527 FEB 311,097 606,304 308,941 659,041 450,190 776,326 583,964 925,537 (139,093)(170,022)(275,023)(266,496) MAR 378,176 984,480 382,278 1,041,319 799,318 1,575,644 515,719 1,441,256 (421,142)(591,164)(133,441)(399,937) APR 371,525 1,356,005 364,995 1,406,314 355,212 1,930,856 509,075 1,950,331 16,313 (574,851)(144,080)(544,017) MAY 374,269 1,730,274 401,043 1,807,357 284,457 2,215,313 391,823 2,342,154 89,812 (485,039)9,220 (534,797) JUNE 396,621 2,126,895 415,778 2,223,135 291,850 2,507,163 274,152 2,616,306 104,771 (380,268)141,626 (393,171) JULY 379,385 2,506,280 371,311 2,594,446 353,125 2,860,288 361,046 2,977,352 26,260 (354,008) 10,265 (382,906) AUG 442,206 3,036,652 290,491 3,267,843 151,715 (231,191) SEPT 380,997 3,417,649 272,478 3,540,321 108,519 (122,672) OCT 543,992 3,961,641 338,254 3,878,575 205,738 83,066 NOV 372,014 4,333,655 336,209 4,214,784 35,805 118,871 DEC 511,567 4,845,222 348,179 4,562,963 163,388 282,259 2 0 1 9 2 0 1 9 2 0 1 9 (800,000) (600,000) (400,000) (200,000) 0 200,000 400,000 600,000 JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YEAR-TO-DATE BALANCE 2014 2015 2016 2017 2018 2019 (354,008) 8/9/2019 Laserfiche/FI0914#4 This Month: July 2019 Page 4 of 6 WATERWORKS & SEWER SYSTEM REVENUES EXPENSES SURPLUS (DEFICIT) Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 864,457 864,457 845,752 845,752 608,909 608,909 593,360 593,360 255,548 255,548 252,392 252,392 FEB 875,804 1,740,261 862,127 1,707,879 824,109 1,433,018 823,667 1,417,027 51,695 307,243 38,460 290,852 MAR 842,846 2,583,107 773,554 2,481,433 1,615,645 3,048,663 1,206,490 2,623,517 (772,799)(465,556)(432,936)(142,084) APR 779,818 3,362,925 809,060 3,290,493 740,015 3,788,678 755,541 3,379,058 39,803 (425,753)53,519 (88,565) MAY 843,658 4,206,583 898,612 4,189,105 726,733 4,515,411 806,763 4,185,821 116,925 (308,828)91,849 3,284 JUNE 953,968 5,160,551 857,325 5,046,430 726,445 5,241,856 627,601 4,813,422 227,523 (81,305)229,724 233,008 JULY 912,733 6,073,284 845,603 5,892,033 863,813 6,105,669 801,352 5,614,774 48,920 (32,385) 44,251 277,259 AUG 880,982 6,773,015 720,568 6,335,342 160,414 437,673 SEPT 876,669 7,649,684 634,237 6,969,579 242,432 680,105 OCT 889,193 8,538,877 754,439 7,724,018 134,754 814,859 NOV 865,278 9,404,155 636,484 8,360,502 228,794 1,043,653 DEC 845,220 10,249,375 1,070,026 9,430,528 (224,806)818,847 2 0 1 9 2 0 1 9 2 0 1 9 2 0 1 82 0 1 82 0 1 8 (600,000) (400,000) (200,000) 0 200,000 400,000 600,000 800,000 1,000,000 1,200,000 JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YEAR-TO-DATE BALANCE 2014 2015 2016 2017 2018 2019 (32,385) 8/9/2019 OPERATING FUNDS &2018 2019 YTD PERCENT ANNUAL DEPARTMENTS EXPENDED EXPENDED 7 MO=58.33%BUDGET BALANCE GENERAL FUND (10): CITY COUNCIL 96,984.63 88,561.21 47.80%185,261.00 96,699.79 ADMINISTRATION 222,764.54 195,651.18 35.75%547,337.00 351,685.82 INFORMATION TECHNOLOGY 141,180.22 400,434.39 51.33%780,057.00 379,622.61 JUSTICE & LAW 354,551.06 431,384.48 54.10%797,399.00 366,014.52 COMMUNITY PROMOTION 48,880.61 56,917.40 76.72%74,187.00 17,269.60 FINANCE 265,821.85 251,874.98 57.37%439,038.00 187,163.02 HUMAN RESOURCES 145,557.60 142,001.48 47.20%300,851.00 158,849.52 BUILDING STANDARDS 234,172.11 231,224.11 53.55%431,828.00 200,603.89 PLANNING & DEVELOPMENT 72,930.86 200,189.85 48.47%412,999.00 212,809.15 CITY BUILDINGS 196,216.47 152,229.18 40.31%377,666.00 225,436.82 PROPERTY MAINTENANCE 849,499.84 890,905.91 64.14%1,389,086.00 498,180.09 PUBLIC SAFETY 5,084,614.11 5,340,961.34 62.13%8,596,074.00 3,255,112.66 ENGINEERING 127,695.09 137,831.50 56.14%245,507.00 107,675.50 STREET LIGHTS & SIGNALS 252,897.95 252,455.11 51.74%487,952.00 235,496.89 STREETS & DRAINS 541,658.28 593,470.68 63.75%930,912.00 337,441.32 RECREATION 565,506.64 602,444.29 62.87%958,177.00 355,732.71 PARKS 287,473.69 244,214.78 52.55%464,709.00 220,494.22 COMMUNITY CENTER 91,486.70 103,806.24 58.95%176,079.00 72,272.76 TOURISM 179,756.54 179,106.37 45.08%397,330.00 218,223.63 RVP ACTIVITIES CENTER 412,047.09 471,413.46 59.53%791,919.00 320,505.54 GENERAL FUND TOTAL 10,171,695.88 10,967,077.94 58.38%18,784,368.00 7,817,290.06 STORMWATER UTILITY FUND (11): INFORMATION TECHNOLOGY 1,513.41 0.00 0.00%0.00 0.00 STORMWATER 307,479.39 370,037.00 47.79%774,254.00 404,217.00 HUMAN RESOURCES 1,381.88 0.00 0.00%0.00 0.00 TRANSFERS 0.00 27,729.00 0.00%27,729.00 0.00 STORMWATER FUND TOTAL 310,374.68 397,766.00 49.60%801,983.00 404,217.00 SANITATION FUND (13): INFORMATION TECHNOLOGY 43,232.03 6,253.09 99.94%6,257.00 3.91 SANITATION 1,547,965.38 1,558,816.55 61.57%2,531,820.00 973,003.45 RECYLING 1,164,382.83 932,767.96 59.27%1,573,817.00 641,049.04 HUMAN RESOURCES 7,287.89 0.00 0.00%0.00 0.00 TRANSFERS 214,484.00 362,450.00 100.00%362,450.00 0.00 SANITATION FUND TOTAL 2,977,352.13 2,860,287.60 63.93%4,474,344.00 1,614,056.40 O & M FUND (21): INFORMATION TECHNOLOGY 151,756.20 4,982.00 100.00%4,982.00 0.00 HUMAN RESOURCES 4,951.43 0.00 0.00%0.00 0.00 UTILITIES FINANCE 291,402.31 333,339.12 63.26%526,923.00 193,583.88 UTILITIES ADMINISTRATION 344,613.71 281,117.70 54.47%516,078.00 234,960.30 WATER OPERATIONS 499,271.11 489,605.65 59.61%821,363.00 331,757.35 WATER PRODUCTION 869,162.35 860,728.53 53.48%1,609,557.00 748,828.47 WASTEWATER OPERATIONS 1,828,274.42 2,289,721.30 53.53%4,277,817.00 1,988,095.70 TRANSFERS 478,767.00 740,173.00 100.00%740,173.00 0.00 O & M FUND TOTAL 4,468,198.53 4,999,667.30 58.84%8,496,893.00 3,497,225.70 Laserfiche/FI0914#5 Page 5 of 6 DEPARTMENT COMPARATIVE DATA (2018-2019) This Month: July 2019 8/9/2019 Laserfiche/FI0914#6 This Month: July 2019 Page 6 of 6 2014 2015 2016 2017 2018 2019 JAN 67,527,800 66,593,800 80,612,500 66,226,500 70,472,600 68,059,100 FEB 70,558,900 64,130,000 63,228,900 67,248,700 71,463,100 66,272,900 MAR 59,501,800 61,445,100 63,146,800 66,873,200 63,382,300 61,423,300 APR 66,036,800 69,821,800 75,996,300 76,591,700 67,096,100 75,454,200 MAY 87,006,600 78,135,500 91,865,700 95,937,000 92,208,400 88,165,300 JUN*102,185,100 114,293,800 117,019,167 110,442,100 97,377,300 129,536,200 JUL*119,881,100 130,932,600 127,708,867 104,063,100 105,927,100 129,809,800 AUG 110,592,200 128,369,800 123,927,500 103,060,200 99,041,700 SEP 128,709,100 115,214,244 128,532,700 110,350,200 103,480,400 OCT 102,242,400 96,463,100 101,300,800 95,226,700 105,219,800 NOV 82,984,300 70,516,400 109,895,800 99,336,800 82,158,600 DEC 78,370,200 73,391,300 83,710,800 78,090,700 69,352,300 TOTAL 1,075,596,300 1,069,307,444 1,166,945,834 1,073,446,900 1,027,179,700 618,720,800 *Increase primarily related to a spike in residential watering and decreased rainfall. GALLONS 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 JAN FEB MAR APR MAY JUN*JUL*AUG SEP OCT NOV DEC GALLONS OF WATER BILLED 2014 2015 2016 2017 2018 2019 129,809,80