Press Alt + R to read the document text or Alt + P to download or print.

No preview available

The URL can be used to link to this page

Home My WebLink AboutMay 2017 - Financial Statements7/3/2017 FYE 2015 FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year $ 158,070 $ 208,357 $ 306,202 $ 344,197 112.41% $ 278,890 280,372 294,293 371,071 520,084 140.16% 439,861 8,609 53,919 146,001 223,198 152.87% 179,791 - - - - - 247,154 205,162 250,545 305,811 122.06% 260,888 305,481 381,191 415,712 374,959 90.20% 327,105 833,532 811,001 872,792 992,152 113.68% 967,280 - - 415,000 291,764 70.30% - 79,320 81,438 103,488 86,790 83.86% 77,139 1,588,997 1,709,486 1,730,410 1,424,135 82.30% 1,487,132 153,360 158,173 156,625 132,664 84.70% 130,299 603,102 543,249 608,174 482,474 79.33% 464,905 839,486 1,523,150 1,747,373 1,442,209 82.54% 1,172,160 209,741 194,529 279,019 182,383 65.37% 136,311 3,736,788 3,667,427 2,968,350 2,007,501 67.63% 2,969,145 695,654 759,735 796,548 682,192 85.64% 642,951 1,726,510 1,787,734 1,891,352 1,971,322 104.23% 1,741,205 436,602 581,109 607,805 593,376 97.63% 557,392 10,205,366 9,677,549 10,026,907 8,337,589 83.15% 8,160,798 389,674 442,623 501,509 400,977 79.95% 382,966 - - - - - 1,607 26,924 19,237 7,461 38.78% 23,765 70,126 66,653 85,799 62,212 72.51% 57,980 - - - - - 1,389,574 1,624,091 1,839,853 1,439,881 78.26% 1,422,623 School Resource Officers - 682,489 758,746 642,467 84.67% 597,842 4,407,161 4,551,465 5,006,995 4,013,115 80.15% 3,805,352 765,164 730,739 893,475 712,740 79.77% 581,767 - - 60,000 58,000 96.67% - 4,080,768 4,414,723 6,360,364 5,433,528 85.43% 3,636,307 1,144,801 1,151,492 - 14 1,016,122 3,361,704 3,361,704 3,361,704 3,081,558 91.67% 3,081,563 431,707 438,575 500,908 380,964 76.05% 354,078 47,050 89,900 85,000 55,850 65.71% 63,800 4,516 6,886 5,040 4,900 97.22% 5,909 79,180 71,908 81,835 68,399 83.58% 63,671 236,688 - - - - 246,495 - - - (11,519) 208,990 198,422 225,676 149,666 66.32% 149,492 161,801 178,736 194,199 159,669 82.22% 151,490 4,000 4,000 4,000 4,000 100.00% 4,000 112,289 101,648 111,585 83,332 74.68% 89,399 458,253 509,983 575,000 472,027 82.09% 365,849 1,382,346 436,558 1,199,766 603,842 50.33% 414,546 1,362,552 1,309,860 1,424,893 1,226,894 86.10% 1,147,305 735 192 51,500 19,091 37.07% 52 57,241 32,171 34,606 18,959 54.79% 29,216 289,118 314,013 412,896 327,227 79.25% 248,273 25,623 24,494 30,400 21,426 70.48% 16,879 Human Resources Facilities Maintenance Register of Deeds Information Technology GIS Sheriff Campbell Deputies Legal Services Engineering JCPC Admin Public Safety Appropriations Emergency Telephone System Radio System Harnett Regional Jetport Medical Examiner Environmental Protection Forestry Program Economic/Physical Dev. App. Industrial Development Development Services Community Development (BG) Abandoned MFG Home Cooperative Extension CCR&R - Block Grant HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 GENERAL FUND Emergency Medical Service Insurance - Retirees Clerk of Court Board of Elections Finance Tax Department Governing Body Administration General Services Fleet Maintenance Transportation Transportation - Admin Sheriff's Department Grants Child Support Enforcement Governor's Highway Safety Communications Jail Emergency Services Soil & Water EMS Transport Rescue Districts Emergency Services Grant Animal Services Harnett CJPP U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 1 7/3/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 GENERAL FUND FYE 2015 FYE 2016 FYE 2016 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 379 150 1,000 - 150 44,813 59,354 - - 41,863 60,321 76,776 70,921 67,734 95.51% 67,184 - 72,035 57,705 37,931 65.73% 39,905 50,723 - - - - - 4,034 2,071 657 31.72% 3,492 14,200 - - - - - 30,035 42,067 18,645 44.32% 20,257 307,602 315,244 318,319 264,789 83.18% 265,141 64,108 61,164 70,369 60,250 85.62% 53,884 77,658 77,511 84,354 70,498 83.57% 67,552 328,753 329,421 358,210 285,704 79.76% 283,618 414,989 432,337 436,245 328,519 75.31% 371,574 6,014,268 6,082,878 7,313,244 4,935,966 67.49% 5,251,493 605,679 605,679 605,679 605,679 100.00% 605,679 10,155,398 10,324,942 12,477,480 10,148,699 81.34% 8,982,095 7,905,017 9,351,002 9,718,837 8,224,165 84.62% 8,229,577 178,634 180,399 221,205 181,987 82.27% 157,869 100,304 103,322 108,325 86,376 79.74% 87,204 90,780 136,805 50,000 28,223 56.45% 129,039 941,972 910,122 1,059,501 815,769 77.00% 765,493 150,000 153,000 185,000 185,000 100.00% 3,000 403,871 435,005 869,480 692,295 79.62% 368,567 - - 74,175 69,732 94.01% - 21,523,700 21,267,993 21,420,138 19,635,127 91.67% 21,267,993 - 280,707 122,625 122,625 100.00%252,810 - 993,967 1,055,200 1,055,200 100.00%- 928,467 - 1,019,467 934,511 91.67%909,011 - - 30,500 26,197 85.89%- - - 798,517 731,974 91.67%- 25,000 - - - - - 70,000 - - - $ 93,213,943 $ 95,761,633 $ 106,088,994 $ 89,457,251 84.32% $ 85,916,429 64,701 2,145,446 1,454,409 1,454,409 100.00% 43,334 44,265,436 52,688,961 16,715,631 16,696,564 99.89% 52,672,888 - - 66,225 - - $ 44,330,137 $ 54,834,407 $ 18,236,265 $ 18,150,973 99.53% $ 52,716,222 137,544,080$ 150,596,040$ 124,325,259$ 107,608,224$ 86.55% 138,632,651$ Board of Education - add teach Board of Education - teachers Central Carolina - health sciences Subtotal Other Financing Uses: Department Central Carolina - DOT Social Services Public Assistance Veteran's Services Family Caregiver Support RSVP Cultural & Recreational App. Parks & Recreation Education Special Programs Subtotal - Operating Expenditures 4-H Teen Court & At Risk Adolescent Parenting Parents As Teachers Interfund Transfers Debt Service Contingency Total Expenditures Mental Health CCR&R - United Way Child Care Youth Training Race to the Top Adolescent Parenting - BJRH Department on Aging Restitution CAP - Disabled Adults Nutrition for Elderly Health Board of Education - current Board of Education - capital Central Carolina - current Central Carolina - capital Central Carolina - works Human Services App. Library U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 2 7/3/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 GENERAL FUND FYE 2015 FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date Same Period Last Fiscal Year 53,930,707$ 55,082,717$ 55,606,980$ 56,344,748$ 101.33%54,538,390$ 5,712,141 6,190,412 5,888,405 5,429,391 92.20%5,060,101 16,757,810 19,279,813 19,008,522 13,913,381 73.20%10,833,221 1,053,493 1,220,493 1,250,000 1,096,607 87.73%923,826 2,515,489 2,965,577 3,374,901 2,640,064 78.23%2,780,496 18,884,854 20,274,012 20,628,668 15,306,251 74.20%14,480,682 7,838,973 9,204,896 9,698,955 9,089,872 93.72%8,068,394 3,741,739 3,343,042 3,816,763 2,952,939 77.37%2,816,299 69,215 73,655 70,609 61,831 87.57%68,316 110,504,421 117,634,617 119,343,803 106,835,084 89.52% 99,569,725 8,437 97,339 30,000 178,769 595.90%15,023 29,108,938 37,018,000 - - 37,018,000 322,415 7,501 2,820,756 - 7,501 - - 2,130,700 - - 29,439,790 37,122,840 4,981,456 178,769 3.59% 37,040,524 139,944,211$ 154,757,457$ 124,325,259$ 107,013,853$ 86.08% 136,610,249$ 2,400,131$ 4,161,417$ (594,370)$ (2,022,402) Investment Earnings Sales Tax Revenues over / (under) expenditures Rents, Concessions & Fees Ad Valorem Taxes Subtotal - Operating Revenues Subtotal Other Financing Sources: Motor Vehicles Other Financing Sources Interfund Transfers Fund Balance Appropriated Total Revenues Permits & Fees Intergovernmental Revenue Sales & Services Other Revenues Other taxes Revenues: Real and Personal U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 3 7/3/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 GENERAL FUND PNC Fidelity MBS NCCMT Total May 2017 2,108,133$ 52,430$ 12,883,875$ 21,669,408$ 36,713,847$ April 2017 -$ 102,890$ 12,883,875$ 29,247,908$ 42,234,673$ March 2017 9,318,753$ 50,000$ 10,900,020$ 28,346,806$ 48,615,578$ February 2017 10,966,173$ 50,000$ 10,900,020$ 23,550,367$ 45,466,559$ January 2017 16,539,974$ 50,000$ 10,900,020$ 21,778,696$ 49,268,690$ December 2016 6,112,440$ 50,000$ 10,399,391$ 20,139,559$ 36,701,391$ November 2016 -$ 8,950,242$ 10,149,294$ 11,410,145$ 30,509,681$ October 2016 -$ 11,893,456$ 9,598,367$ 4,576,239$ 26,068,062$ September 2016 -$ 1,401,847$ 9,611,806$ 9,898,592$ 20,912,246$ August 2016 -$ -$ 10,830,323$ 13,870,895$ 24,701,218$ July 2016 -$ -$ 10,288,522$ 14,611,996$ 24,900,517$ June 2016 4,836,176$ -$ 10,288,522$ 15,052,435$ 30,177,132$ May 2016 -$ -$ 6,310,697$ 22,909,111$ 29,219,808$ April 2016 -$ -$ 5,910,697$ 28,256,262$ 34,166,959$ March 2016 3,888,938$ -$ 5,910,697$ 31,321,226$ 41,120,861$ February 2016 6,184,218$ -$ 5,460,397$ 29,217,771$ 40,862,386$ Current Year Outstanding Interest 3,797,212$ 36,234,829$ Principal 13,068,967 121,681,341 Transfers Out - - 16,866,179$ 157,916,170$ Debt Service and Transfer Requirements Cash and Investments $15,000,000 $25,000,000 $35,000,000 $45,000,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 4 7/3/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 GENERAL FUND 2012 2013 2014 2015 Non Spendable 748,224$ 451,088$ 111,181$ 159,625$ 1,418,606$ Restricted 8,789,704$ 9,433,149$ 9,260,952$ 11,496,063$ 11,966,027$ Committed 574,133$ -$ -$ -$ -$ Assigned -$ -$ 3,193,811$ 2,600,000$ -$ Unassigned 13,212,441$ 17,959,942$ 18,732,095$ 19,417,388$ 26,311,973$ Total General Fund 23,324,502$ 27,844,179$ 31,298,039$ 33,673,076$ 39,696,606$ General Fund Expenditures 100,900,981$ 101,852,867$ 103,330,529$ 108,508,715$ 112,272,703$ 13.09%17.63%18.13%17.89%23.44%Unassigned Fund Balance as a % of Expenditures That portion of fund balance that the County intends to use for specific purposes. The County Commissioners have the authority to assign fund balances. Unassigned Fund Balance - Assigned Fund Balance - 2016 In the governmental fund financial statements, fund balance is composed of five classifications designed to disclose the hierarchy of constraints placed on how fund balance can be spent. They are as follows: Non-Spendable Fund Balance - This classification includes amounts that cannot be spent because they are either (a) not in spendable form or (b) legally or contractually required to be maintained intact. Restricted Fund Balance - The classification includes amount that are restricted to specific purposes externally imposed by creditors or imposed by law. Committed Fund Balance - This classification represents the portion of fund balance that can only be used for specific purposes imposed by majority vote by a quorum of the County Commissioners, that can by adoption of an ordinance, commit fund balance. The Harnett County Board of Commissioners have approved a fund balance policy which strives to maintain a minimum fund balance of 15%. This classification represents the portion of fund balance that has not been assigned to another fund or is not restricted, committed, or assigned to specific purposes within the general fund. Estimated Fund Balance 1.00% 11.00% 21.00% 2012 2013 2014 2015 2016 13.09%17.63%18.13%17.89%23.44% Fund Balance % U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 5 7/3/2017 FYE 2015 FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 6,369,116$ 3,452,612$ 12,451,358$ 6,728,909$ 54.04%3,772,230$ 3,965,881 4,376,387 5,013,602 3,768,817 75.17%3,456,279 1,908,016 2,005,668 2,740,083 1,832,507 66.88%1,423,586 1,869,169 1,993,304 2,711,682 1,760,521 64.92%1,650,767 3,607,800 3,634,241 4,593,165 3,180,839 69.25%3,176,693 3,006,906 2,742,752 4,032,961 2,821,148 69.95%2,169,916 20,726,888$ 18,204,964$ 31,542,851$ 20,092,741$ 63.70% 15,649,471$ 22,607,192 - - - - 6,395,389 9,327,622 - - - 5,106,266 1,070,704 6,717,809 4,574,003 68.09%4,824,579 34,108,847$ 10,398,325$ 6,717,809$ 4,574,003$ 68.09% 4,824,579$ 54,835,735$ 28,603,289$ 38,260,660$ 24,666,744$ 64.47% 20,474,050$ FYE 2015 FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date Same Period Last Fiscal Year 3,703$ 3,703$ 3,703$ 3,703$ 100.00%3,703$ 30,134,602 32,563,219 29,448,080 29,900,882 101.54%27,289,138 2,023,403 3,704,119 278,045 625,657 225.02%2,251,145 172 2,105 - 5,682 - 32,161,880$ 36,273,146$ 29,729,828$ 30,535,924$ 102.71% 29,543,986$ 13,731,430 320,484 - - 312,197 1,452,130 450,000 - - - - - 8,530,832 - - 15,183,560$ 770,484$ 8,530,832$ -$ 312,197$ 47,345,440$ 37,043,630$ 38,260,660$ 30,535,924$ 79.81% 29,856,183$ (7,490,295)$ 8,440,341$ 5,869,180$ 9,382,133$ Sales & Services Other Revenues Subtotal - Operating Expenditures Interfund Transfers Depreciation HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 PUBLIC UTILITIES FUND Department Admin/CSR/Meter Services Water Treatment Wastewater Treatment Wastewater Treatment SHWW Distribution Collections Revenues over / (under) expenditures Rents, Concess. & Feees Other Finance Sources Interfund Transfers Fund Balance Appropriated Total Revenues Subtotal Other Financing Sources: Debt Service Subtotal Other Financing Uses: Subtotal - Operating Revenues Total Expenditures Revenues: Intergovernmental Revenue U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 6 7/3/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 PUBLIC UTILITIES FUND PNC Lockbox Money Mkt NCCMT Total May 2017 25,982,342$ 5,236,513$ 5,003,631$ 624,363$ 36,846,849$ April 2017 32,934,935$ 4,914,027$ 5,001,575$ 614,100$ 43,464,638$ March 2017 31,893,934$ 9,713,915$ -$ 599,368$ 42,207,217$ February 2017 35,929,010$ 4,553,808$ -$ 588,943$ 41,071,761$ January 2017 34,586,445$ 4,491,557$ -$ 588,277$ 39,666,278$ December 2016 33,153,787$ 4,255,513$ -$ 588,277$ 37,997,576$ November 2016 31,878,365$ 4,312,453$ -$ 588,228$ 36,779,046$ October 2016 31,059,095$ 4,075,830$ -$ 585,783$ 35,720,707$ September 2016 29,921,800$ 4,030,784$ -$ 585,023$ 34,537,607$ August 2016 30,074,922$ 3,836,649$ -$ 585,023$ 34,496,594$ July 2016 28,301,352$ 3,467,807$ -$ 583,368$ 32,352,527$ June 2016 27,213,474$ 3,582,342$ -$ 583,368$ 31,379,183$ May 2016 28,848,875$ 3,432,473$ -$ 581,211$ 32,862,559$ April 2016 30,683,192$ 3,316,449$ -$ 577,919$ 34,577,560$ March 2016 31,388,435$ 3,343,019$ -$ 570,299$ 35,301,753$ February 2016 29,859,796$ 3,507,930$ -$ 555,108$ 33,922,833$ Current Year Outstanding Interest 1,385,263$ 27,935,291$ Principal 2,903,937$ 74,815,351 Transfers Out 2,428,609$ - 6,717,809$ 102,750,642$ Cash and Investments Debt Service and Transfer Requirements $20,000,000 $30,000,000 $40,000,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 7 7/3/2017 FYE 2015 FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 4,555,419$ 4,207,775$ 5,849,138$ 4,374,980$ 74.80%4,178,332$ 4,555,419$ 4,207,775$ 5,849,138$ 4,374,980$ 74.80% 4,178,332$ 1,396,177 - - - - - - - - - 345,724 445,290 - - - 529,747 88,150 544,828 531,779 97.60%493,992 2,271,648$ 533,439$ 544,828$ 531,779$ 97.60% 493,992$ 6,827,067$ 4,741,214$ 6,393,966$ 4,906,759$ 76.74% 4,672,324$ FYE 2015 FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date Same Period Last Fiscal Year 234,276$ 268,129$ 219,000$ 216,910$ 99.05%194,789$ 25,000 133,790 61,000 - 133,790 5,165,089 5,313,693 5,265,540 5,152,700 97.86%4,973,325 499,631 139,437 520 63,025 #######139,278 276 1,291 20,000 1,657 8.29%17,869 5,924,272$ 5,856,340$ 5,566,060$ 5,434,292$ 97.63% 5,459,051$ 1,402,161 917 - - - - - - - - - - 827,906 - - 1,402,161$ 917$ 827,906$ -$ -$ 7,326,433$ 5,857,257$ 6,393,966$ 5,434,292$ 84.99% 5,459,051$ 499,366$ 1,116,043$ 527,533$ 786,727$ Rents, Concess. & Feees Other Finance Sources Subtotal - Operating Revenues Revenues: Taxes Intergovernmental Revenue Sales & Services Other Revenues Depreciation HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 SOLID WASTE FUND Subtotal Other Financing Sources: Revenues over / (under) expenditures Interfund Transfers Subtotal - Operating Expenditures Subtotal Other Financing Uses: Interfund Transfers Other Financing Uses Debt Service Department Solid Waste Total Expenditures Fund Balance Appropriated Total Revenues U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 8 7/3/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 SOLID WASTE FUND PNC BB&T First Bank NCCMT Total May 2017 146,657$ 849,369$ 798,541$ 295,485$ 2,090,052$ April 2017 252,605$ 813,116$ 768,637$ 235,646$ 2,070,004$ March 2017 697,465$ 796,560$ 738,482$ 316,381$ 2,548,889$ February 2017 1,010,246$ 774,615$ 715,054$ 316,381$ 2,816,296$ January 2017 933,046$ 733,821$ 679,357$ 240,324$ 2,586,547$ December 2016 1,221,468$ 712,874$ 660,335$ 159,310$ 2,753,988$ November 2016 723,455$ 703,192$ 649,795$ 159,310$ 2,235,752$ October 2016 143,512$ 679,050$ 628,517$ 78,246$ 1,529,324$ September 2016 -$ 623,360$ 608,194$ 78,246$ 1,309,800$ August 2016 596,631$ 637,923$ 589,976$ 78,243$ 1,902,774$ July 2016 706,906$ 613,495$ 567,589$ 4,902$ 1,892,893$ June 2016 953,476$ 595,845$ 549,127$ 4,902$ 2,103,350$ May 2016 1,030,073$ 577,211$ 534,532$ 254,500$ 2,396,316$ April 2016 1,106,636$ 555,533$ 517,182$ 185,532$ 2,364,882$ March 2016 1,322,008$ 533,722$ 501,869$ 185,532$ 2,543,131$ February 2016 1,453,177$ 504,847$ 477,173$ 60,920$ 2,496,117$ Current Year Outstanding Interest 78,464$ 295,375$ Principal 466,364 2,446,792 Transfers Out - - 544,828$ 2,742,167$ Cash and Investments Debt Service and Transfer Requirements $1,000,000 $2,000,000 $3,000,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 9 7/3/2017 FYE 2015 FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 29,000$ 21,000$ 32,000$ 21,000$ 65.63%21,000$ 123,636 1,243,316 1,093,000 3,010,116 275.40%1,143,316 152,636$ 1,264,316$ 1,125,000$ 3,031,116$ 269.43%1,164,316$ FYE 2015 FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date FYE 2016 Activity 1,821,371$ 1,711,483$ 975,000$ 910,921$ 93.43%855,863$ 250,795 441,714 150,000 2,541,109 #######331,482$ - - - - 2,072,166$ 2,153,197$ 1,125,000$ 3,452,030$ 306.85%1,187,345$ 1,919,530$ 888,881$ 420,914$ 23,029$ PNC NCCMT Total May 2017 2,809,436$ 1,211,772$ 4,021,208$ April 2017 265,521$ 1,211,772$ 1,477,293$ March 2017 2,833,889$ 1,211,772$ 4,045,661$ February 2017 2,717,622$ 1,211,772$ 3,929,394$ January 2017 2,768,040$ 1,211,772$ 3,979,812$ December 2016 2,687,499$ 1,211,772$ 3,899,271$ November 2016 2,582,294$ 1,211,772$ 3,794,066$ October 2016 2,487,719$ 1,211,772$ 3,699,491$ September 2016 2,533,314$ 1,211,772$ 3,745,086$ August 2016 1,669,764$ 1,211,772$ 2,881,536$ July 2016 1,705,014$ 1,211,772$ 2,916,786$ June 2016 1,624,481$ 1,211,772$ 2,836,253$ May 2016 1,692,068$ 1,211,772$ 2,903,840$ April 2016 1,643,553$ 1,211,772$ 2,855,325$ March 2016 1,711,933$ 1,211,772$ 2,923,705$ February 2016 1,532,422$ 1,211,772$ 2,744,194$ HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 WORKER'S COMPENSATION FUND Cash and Investments Category Fixed Cost Claims Funded Total Expenditures Revenues: Departmental Charge Other revenues Fund Balance Appropriated Total Revenues Revenues over / (under) expenditures $2,000,000 $3,000,000 $4,000,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 10 7/3/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 WORKER'S COMPENSATION FUND 4,690,195$ 2,501,397 Liability as of end of month 2,385,309$ Liability 196,510 # of Claims this fiscal year 63 Liability as of July 1 Current year claims and changes in estimates Actual claim payments U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 11 7/3/2017 FYE 2015 FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 121,440$ 140,835$ 178,432$ 130,992$ 73.41%125,756$ 121,440$ 140,835$ 178,432$ 130,992$ 73.41%125,756$ FYE 2015 FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date FYE 2016 Activity 228,950$ 242,612$ 177,232$ 135,120$ 76.24%218,075$ - - - - - - - 1,200 - - 228,950$ 242,612$ 178,432$ 135,120$ 75.73%218,075$ 107,510$ 101,777$ 4,128$ 92,319$ PNC NCCMT Total May 2017 643,317$ 29,241$ 672,559$ April 2017 645,207$ 29,241$ 674,448$ March 2017 642,930$ 29,241$ 672,171$ February 2017 644,551$ 29,241$ 673,792$ January 2017 641,202$ 29,241$ 670,443$ December 2016 641,529$ 29,241$ 670,770$ November 2016 644,850$ 29,241$ 674,091$ October 2016 646,455$ 29,241$ 675,697$ September 2016 647,665$ 29,241$ 676,906$ August 2016 645,243$ 29,241$ 674,484$ July 2016 643,903$ 29,241$ 673,145$ June 2016 640,890$ 29,241$ 670,132$ May 2016 629,731$ 29,241$ 658,972$ April 2016 634,966$ 29,241$ 664,207$ March 2016 626,534$ 29,241$ 655,776$ February 2016 619,752$ 29,241$ 648,994$ Total Revenues Cash and Investments Revenues over / (under) expenditures Fund Balance Appropriated HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 EMPLOYEE CLINIC FUND Department Employee Clinic Total Expenditures Revenues: Departmental Charge Other revenues $600,000 $625,000 $650,000 $675,000 $700,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 12 7/3/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 EMPLOYEE CLINIC FUND # of Visits May 2017 185 April 2017 109 March 2017 201 February 2017 198 January 2016 177 December 2016 165 November 2016 141 October 2016 116 September 2016 150 August 2016 145 July 2016 144 June 2016 162 May 2016 171 Employee Clinic Utilization 0 311 Health Prevention # Flu shots # Pneumonia shots 050100150200250 Patient Flow U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 13 7/3/2017 FYE 2015 FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 5,205,337$ 6,818,253$ 5,650,000$ 6,103,954$ 108.03%5,832,094$ 655,329 634,709 795,000 584,268 73.49%674,623 1,507 8,355 10,000 2,541 25.41%7,174 5,862,173$ 7,461,317$ 6,455,000$ 6,690,763$ 103.65%6,513,891$ FYE 2015 FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date FYE 2016 Activity 6,687,178$ 7,892,453$ 6,443,000$ 6,647,269$ 103.17%5,962,214$ 10,783 26,178 12,000 19,123 159.36%25,526 6,697,961$ 7,918,631$ 6,455,000$ 6,666,392$ 103.27%5,987,740$ 835,788$ 457,314$ (24,371)$ (526,151)$ PNC NCCMT Total May 2017 2,028,010$ 543,297$ 2,571,307$ April 2017 2,033,963$ 543,297$ 2,577,260$ March 2017 1,870,174$ 543,297$ 2,413,471$ February 2017 2,024,627$ 543,297$ 2,567,925$ January 2017 2,084,544$ 543,297$ 2,627,841$ December 2016 2,014,553$ 543,297$ 2,557,850$ November 2016 1,952,986$ 543,297$ 2,496,283$ October 2016 1,869,553$ 543,297$ 2,412,851$ September 2016 1,877,798$ 543,297$ 2,421,096$ August 2016 1,125,368$ 543,297$ 1,668,665$ July 2016 967,054$ 543,297$ 1,510,351$ June 2016 1,035,476$ 543,297$ 1,578,773$ May 2016 866,947$ 543,297$ 1,410,244$ April 2016 964,355$ 543,297$ 1,507,653$ March 2016 1,196,881$ 543,297$ 1,740,178$ February 2016 1,354,214$ 543,297$ 1,897,511$ HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 MEDICAL INSURANCE FUND Cash and Investments Category Paid Claims Wellness Total Expenditures Revenues: Medical Premium Equivilents Other revenues Total Revenues Fixed Cost Revenues over / (under) expenditures $1,250,000 $1,750,000 $2,250,000 $2,750,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 14 7/3/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 MEDICAL INSURANCE FUND Employees & Pre-65 Retirees Total Membership Net Paid Claims Fixed Cost Loss Ratio Premium Equivalent May 2017 859 1,308 585,092.44$ 59,071.95$ 99.37%648,269.01$ April 2017 850 1,288 426,323.43$ 60,687.61$ 74.69%652,008.78$ March 2017 847 1,280 700,824.81$ 62,056.67$ 120.25%634,433.13$ February 2017 838 1,270 697,396.28$ 38,867.77$ 116.07%634,310.54$ January 2017 843 1,275 451,584.71$ 46,679.99$ 79.47%626,993.27$ December 2016 843 1,271 562,043.76$ 50,371.79$ 96.89%632,074.10$ November 2016 841 1,265 450,496.19$ 58,245.17$ 80.80%629,611.56$ October 2016 835 1,253 475,315.79$ 93,186.53$ 90.35%629,233.60$ September 2016 830 1,242 949,451.70$ 58,166.03$ 161.13%625,355.69$ August 2016 827 1,238 472,478.84$ 58,462.25$ 85.98%617,534.95$ July 2016 830 1,237 567,120.08$ 117,732.75$ 110.59%619,266.87$ June 2016 826 1,201 749,785.30$ (48,146.18)$ 112.65%622,838.33$ May 2016 821 1,195 644,458.97$ 18,765.56$ 121.42%546,217.69$ April 2016 819 1,190 846,544.07$ 59,316.96$ 166.24%544,921.50$ March 2016 824 1,192 613,689.61$ 55,057.79$ 122.98%543,783.54$ February 2016 829 1,199 476,696.71$ 57,028.00$ 97.08%549,770.71$ 835 1,244 9,669,302.69$ 845,550.64$ 107.77% 9,756,623.27$ Medical Paid Claims Summary Year to Date (membership = avg) 50%75%100%125%150%175% Medical Plan Loss Ratio U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 15 7/3/2017 FYE 2015 FYE 2016 2016 - 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 306,584$ 295,849$ 500,000$ 340,806$ 68.16%268,525$ 35,323 36,698 45,000 33,207 73.79%33,589 341,907$ 332,547$ 545,000$ 374,013$ 68.63%302,114$ FYE 2015 FYE 2016 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date FYE 2016 Activity 544,448$ 369,211$ 545,000$ 415,539$ 76.25%331,022$ - - - - - 544,448$ 369,211$ 545,000$ 415,539$ 76.25%331,022$ 202,541$ 36,664$ 41,526$ 28,908$ PNC NCCMT Total May 2017 311,609$ -$ 311,609$ April 2017 313,273$ -$ 313,273$ March 2017 294,393$ -$ 294,393$ February 2017 296,096$ -$ 296,096$ January 2017 290,366$ -$ 290,366$ December 2016 290,231$ -$ 290,231$ November 2016 280,718$ -$ 280,718$ October 2016 278,083$ -$ 278,083$ September 2016 283,750$ -$ 283,750$ August 2016 269,750$ -$ 269,750$ July 2016 278,279$ -$ 278,279$ June 2016 270,084$ -$ 270,084$ May 2016 262,899$ -$ 262,899$ April 2016 259,621$ -$ 259,621$ March 2016 255,744$ -$ 255,744$ February 2016 262,475$ -$ 262,475$ HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 DENTAL INSURANCE FUND Cash and Investments Category Paid Claims Fixed Cost Total Expenditures Revenues: Dental Premium Equivilents Other revenues Total Revenues Revenues over / (under) expenditures $200,000 $225,000 $250,000 $275,000 $300,000 $325,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 16 7/3/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 DENTAL INSURANCE FUND Total Employees Total Membership Net Paid Claims Fixed Cost Loss Ratio Premium Equivalent May 2017 877 1,401 29,071.76$ 3,828.12$ 84.48%38,943.34$ April 2017 867 1,386 30,843.30$ 3,797.53$ 84.96%40,772.75$ March 2017 866 1,382 37,039.68$ 3,810.64$ 117.25%34,840.92$ February 2017 853 1,366 29,052.10$ 3,731.98$ 89.50%36,632.24$ January 2017 852 1,363 24,691.39$ 3,701.39$ 74.34%38,194.96$ December 2016 849 1,352 30,584.03$ 3,683.91$ 90.36%37,925.31$ November 2016 847 1,350 27,494.20$ 3,749.46$ 82.49%37,877.15$ October 2016 838 1,341 20,172.90$ 3,412.97$ 62.44%37,772.52$ September 2016 812 1,312 38,929.95$ 3,600.88$ 113.34%37,526.11$ August 2016 813 1,323 35,594.70$ 3,570.29$ 104.91%37,330.66$ July 2016 810 1,316 31,416.37$ 4,006.42$ 93.83%37,752.67$ June 2016 671 1,114 28,488.90$ 6,202.76$ 90.84%38,188.97$ May 2016 667 1,110 22,062.20$ 3,084.92$ 84.50%29,760.98$ April 2016 659 1,100 31,526.79$ 3,033.66$ 115.55%29,909.42$ March 2016 660 1,101 29,696.70$ 3,122.20$ 110.76%29,629.84$ February 2016 660 1,101 20,728.10$ 3,075.60$ 76.42%31,147.59$ 788 1,276 467,393.07$ 59,412.73$ 91.75% 574,205.43$ Dental Paid Claims Summary Year to Date (membership = avg) 50% 75% 100% 125% Dental Plan Loss Ratio U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 17 7/3/2017 FYE 2015 FYE 2016 2016 - 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 115,268,881$ 123,553,503$ 106,092,900$ 85.87%82,103,070$ 115,268,881$ 123,553,503$ 106,100,707$ 85.87%72,891,417$ -$ -$ -$ 7,807$ (9,211,654)$ 22,838,609 26,605,070 20,553,383 77.25%15,677,137$ 21,557,719 26,605,070 21,058,298 79.15%16,144,991$ -$ (1,280,890)$ -$ 504,915$ 467,854$ 11,365,474 14,892,583 10,646,921 71.49%7,948,850$ 11,365,474 14,892,583 10,649,134 71.51%7,091,298$ -$ -$ -$ 2,213$ (857,552)$ 3,165,403 5,054,077 3,395,126 67.18%296,835$ 2,844,295 5,054,077 3,534,258 69.93%25,364$ -$ (321,108)$ -$ 139,132$ (271,471)$ 10,013,377 11,365,310 9,236,883 81.27%7,271,716$ 10,608,154 11,365,310 10,202,351 89.77%7,132,398$ -$ 594,777$ -$ 965,468$ (139,318)$ 304,258 330,250 250,473 75.84%253,558$ 299,648 330,250 292,574 88.59%266,485$ -$ (4,609)$ -$ 42,101$ 12,927$ 4,720,189 10,357,495 5,456,564 52.68%2,844,952$ 5,253,011 10,357,495 6,017,872 58.10%3,554,161$ -$ 532,822$ -$ 561,307$ 709,209$ - 167,676,190 192,158,288 155,632,250 80.99%116,396,117 - 167,197,181 192,158,288 157,855,193 82.15%107,106,113 -$ (479,009)$ -$ 2,222,943$ (9,290,004)$ * Latest available numbers from the Board of Education's web site. Capital Outlay Fund Expenditures Revenues Expenditures Revenues Local Restricted Fund Expenditures Revenues Total All Funds Child Nutrition Fund Expenditures Revenues Expenditures Revenues Dunn District Fund Expenditures Revenues Local Current Expense Fund Expenditures Revenues Federal Grant Fund Expenditures Revenues State Fund HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 BOARD OF EDUCATION Fund Group: U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 18 7/3/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 BOARD OF EDUCATION 2012 2013 2014 2015 Non Spendable 1,431,174$ 1,417,080$ 2,130,098$ 1,849,351$ 1,796,064$ Restricted 49,951$ 2,813$ 67,971$ 21,420$ 25,507$ Committed -$ -$ -$ -$ -$ Assigned 1,384,125$ 4,004,023$ 3,508,927$ 5,466,811$ 3,845,000$ Unassigned 10,426,143$ 5,426,606$ 3,000,000$ 2,889,118$ 3,274,629$ Total General Fund 13,291,393$ 10,850,522$ 8,706,996$ 10,226,700$ 8,941,200$ General Fund Expenditures 17,301,200$ 20,262,634$ 22,848,788$ 20,369,083$ 23,089,579$ 60.26%26.78%13.13%14.18%14.18% Estimated Fund Balance In the governmental fund financial statements, fund balance is composed of five classifications designed to disclose the hierarchy of constraints placed on how fund balance can be spent. They are as follows: Non-Spendable Fund Balance - This classification includes amounts that cannot be spent because they are either (a) not in spendable form or (b) legally or contractually required to be maintained intact. Restricted Fund Balance - The classification includes amount that are restricted to specific purposes externally imposed by creditors or imposed by law. 2016 Unassigned Fund Balance as a % of Expenditures Committed Fund Balance - This classification represents the portion of fund balance that can only be used for specific purposes imposed by majority vote by a quorum of the County Commissioners, that can by adoption of an ordinance, commit fund balance. Assigned Fund Balance - That portion of fund balance that the County intends to use for specific purposes. The County Commissioners have the authority to assign fund balances. Unassigned Fund Balance - This classification represents the portion of fund balance that has not been assigned to another fund or is not restricted, committed, or assigned to specific purposes within the general fund. 1.00% 11.00% 21.00% 2012 2013 2014 2015 2016 60.26% 26.78% 13.13%14.18%14.18% Fund Balance % U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 19 7/3/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2017 BOARD OF EDUCATION ADM MLD ADM Change MLD Change Month 1 20,483 20,615 Month 1 Revd 20,469 20,573 (14)(42) Month 2 20,563 20,566 94 (7) Month 3 20,538 20,554 (25)(12) Month 4 20,443 20,480 (95)(74) Month 5 20,340 20,310 (103)(170) Month 6 20,280 20,325 (60)15 Month 7 20,271 20,282 (9)(43) Month 8 20,236 20,259 (35)(23) Month 9 0 0 Final 0 0 Public School Membership Fiscal Year 2016-2017 Initial Allotment20,850 19,500 20,000 20,500 21,000 Harnett County School Membership ADM MLD U:\My Documents\Monthly Reports\2016 - 2017\May 2017 - Financial Statements 20