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 AboutJanuary 2017 - Financial Statements2/23/2017 FYE 2015FYE 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 $ 257,144 83.98% $ 160,829 280,372 294,293 361,471 318,033 87.98% 267,338 8,609 53,919 143,601 125,138 87.14% 114,879 - - - - - 247,154 205,162 246,945 164,477 66.60% 177,402 305,481 381,191 410,912 290,752 70.76% 166,642 833,532 811,001 855,992 645,392 75.40% 599,734 - - 415,000 172,474 41.56% - 79,320 81,438 103,488 63,913 61.76% 50,724 1,588,997 1,709,486 1,705,915 960,768 56.32% 886,906 153,360 158,173 154,225 82,572 53.54% 80,973 603,102 543,249 575,174 348,938 60.67% 301,751 839,486 1,523,150 1,722,386 785,774 45.62% 654,139 209,741 194,529 275,446 94,201 34.20% 88,257 3,736,788 3,667,427 2,953,950 1,254,636 42.47% 1,946,931 695,654 759,735 785,748 451,575 57.47% 417,040 1,726,510 1,787,734 1,873,607 1,270,416 67.81% 1,137,644 436,602 581,109 598,205 377,366 63.08% 348,342 10,205,366 9,677,549 9,881,707 5,159,619 52.21% 4,960,063 389,674 442,623 495,509 255,134 51.49% 232,879 - - - - - 1,607 26,924 19,237 5,921 30.78% 23,765 70,126 66,653 84,599 39,655 46.87% 36,082 - - - - - 1,389,574 1,624,091 1,814,053 902,773 49.77% 832,615 School Resource Officers - 682,489 745,546 397,059 53.26% 335,654 4,407,161 4,551,465 4,946,395 2,530,460 51.16% 2,362,223 765,164 730,739 879,523 461,997 52.53% 368,067 - - 60,000 58,000 96.67% - 4,080,768 4,414,723 6,242,375 3,337,872 53.47% 2,193,049 1,144,801 1,151,492 - 14 612,550 3,361,704 3,361,704 3,361,704 1,960,991 58.33% 2,241,136 431,707 438,575 491,308 249,932 50.87% 211,737 47,050 89,900 85,000 31,500 37.06% 23,950 4,516 6,886 5,040 2,548 50.56% 1,940 79,180 71,908 78,035 46,251 59.27% 42,755 236,688 - - - - 246,495 - - - 88,909 208,990 198,422 198,216 85,298 43.03% 84,980 161,801 178,736 190,599 107,938 56.63% 93,770 4,000 4,000 4,000 4,000 100.00% 4,000 112,289 101,648 111,585 40,885 36.64% 40,398 458,253 509,983 575,000 242,787 42.22% 239,449 1,382,346 436,558 1,162,566 382,793 32.93% 331,341 1,362,552 1,309,860 1,403,293 784,869 55.93% 715,481 735 192 51,500 17,949 34.85% 2 57,241 32,171 34,606 11,905 34.40% 19,331 289,118 314,013 412,938 183,196 44.36% 134,360 25,623 24,494 30,400 12,144 39.95% 7,799 379 150 1,000 - 83 44,813 59,354 - - 24,104 60,321 76,776 70,921 40,337 56.88% 40,303 Tax EMS Transport Rescue Districts Harnett CJPP Medical Examiner Parents As Teachers Adolescent Parenting Transportation Transportation - Admin Sheriff's Department Grants Child Support Enforcement Governor's Highway Safety Communications Jail Emergency Services Emergency Services Grant Animal Services HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2017 GENERAL FUND CCR&R - United Way Emergency Medical Service Insurance - Retirees Clerk of Court Board of Elections Finance Development Services Community Development (BG) Abandoned MFG Home Cooperative Extension CCR&R - Block Grant Soil & Water Department Governing Body Administration General Services Fleet Maintenance Legal Services Engineering Environmental Protection Forestry Program Economic/Physical Dev. App. Industrial Development JCPC Admin Public Safety Appropriations Emergency Telephone System Radio System Harnett Regional Jetport Human Resources Facilities Maintenance Register of Deeds Information Technology GIS Sheriff Campbell Deputies U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 1 2/23/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2017 GENERAL FUND FYE 2015FYE 2016 FYE 2016 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year - 72,035 52,273 23,268 44.51% 22,205 50,723 - - - - - 4,034 2,071 657 31.72% 3,492 14,200 - - - - - 30,035 33,325 11,757 35.28% 11,169 307,602 315,244 318,319 163,172 51.26% 163,422 64,108 61,164 65,925 37,364 56.68% 33,753 77,658 77,511 78,954 41,128 52.09% 38,521 328,753 329,421 353,410 174,251 49.31% 181,658 414,989 432,337 435,045 201,221 46.25% 234,886 6,014,268 6,082,878 7,167,067 3,029,548 42.27% 3,285,061 605,679 605,679 605,679 454,259 75.00% 454,259 10,155,398 10,324,942 12,224,040 6,601,002 54.00% 5,641,522 7,905,017 9,351,002 8,271,854 4,961,592 59.98% 5,177,494 178,634 180,399 186,475 108,800 58.35% 99,498 100,304 103,322 117,367 54,053 46.05% 55,181 90,780 136,805 50,000 20,482 40.96% 121,298 941,972 910,122 995,701 497,670 49.98% 458,410 150,000 153,000 185,000 185,000 100.00% 3,000 403,871 435,005 861,680 471,396 54.71% 242,419 21,523,700 21,267,993 21,420,138 12,495,081 58.33% 12,406,319 - 280,707 - - 136,885 - 993,967 1,252,000 1,055,200 84.28%- 928,467 - 1,019,467 594,689 58.33%569,189 - - 30,500 - - - - 798,517 465,802 58.33%- 25,000 - - - - - 70,000 - - - $ 93,213,943 $ 95,761,633 $ 103,449,729 $ 56,664,788 54.78% $ 53,041,947 64,701 2,145,446 1,454,409 94,567 6.50% 43,334 44,265,436 52,688,961 16,715,631 10,476,790 62.68% 16,696,675 - - 183,225 - - $ 44,330,137 $ 54,834,407 $ 18,353,265 $ 10,571,357 57.60% $ 16,740,009 137,544,080$ 150,596,040$ 121,802,994$ 67,236,145$ 55.20%69,781,956$ 4-H Teen Court & At Risk 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 Mental Health Social Services Public Assistance Veteran's Services Family Caregiver Support RSVP Interfund Transfers Debt Service Contingency Total Expenditures Cultural & Recreational App. Parks & Recreation Education Special Programs Subtotal - Operating Expenditures Subtotal Other Financing Uses: Department Board of Education - teachers Central Carolina - DOT Central Carolina - health sciences U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 2 2/23/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2017 GENERAL FUND FYE 2015FYE 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$ 49,049,292$ 88.21%51,513,025$ 5,712,141 6,190,412 5,888,405 3,150,403 53.50%2,955,314 16,757,810 19,279,813 19,008,522 5,262,385 27.68%5,246,063 1,053,493 1,220,493 1,250,000 605,339 48.43%586,109 2,515,489 2,965,577 3,374,101 1,625,307 48.17%1,508,575 18,884,854 20,274,012 19,107,663 9,419,467 49.30%8,225,746 7,838,973 9,204,896 9,653,887 3,806,956 39.43%3,804,918 3,741,739 3,343,042 3,777,704 1,666,705 44.12%1,336,214 69,215 73,655 70,609 40,812 57.80%40,537 110,504,421 117,634,617 117,737,871 74,626,666 63.38%75,216,501 8,437 97,339 30,000 69,193 230.64%7,033 29,108,938 37,018,000 - - 5,938,000 322,415 7,501 2,818,010 - 7,501 - - 855,497 - - 29,439,790 37,122,840 3,703,507 69,193 1.87%5,952,534 139,944,211$ 154,757,457$ 121,441,378$ 74,695,859$ 61.51%81,169,035$ 2,400,131$ 4,161,417$ 7,459,714$ 11,387,079 Real and Personal Motor Vehicles Sales Tax Other taxes Revenues: Other Financing Sources Interfund Transfers Fund Balance Appropriated Total Revenues Permits & Fees Intergovernmental Revenue Sales & Services Other Revenues Rents, Concessions & Fees Ad Valorem Taxes Investment Earnings Subtotal - Operating Revenues Subtotal Other Financing Sources: Revenues over / (under) expenditures U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 3 2/23/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2017 GENERAL FUND PNC Fidelity MBS NCCMT Total 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$ January 2016 10,575,231$ -$ 4,715,250$ 27,749,119$ 43,039,600$ 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$ Cash and Investments Debt Service and Transfer Requirements $15,000,000 $25,000,000 $35,000,000 $45,000,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 4 2/23/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 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% Estimated 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. 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. 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\January 2017 - Financial Statements.xlsx 5 2/23/2017 FYE 2015FYE 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$ 5,773,323$ 1,780,141$ 30.83%1,986,502$ 3,965,881 4,376,387 5,000,402 2,325,964 46.52%2,142,043 1,908,016 2,005,668 2,711,883 1,119,025 41.26%873,496 1,869,169 1,993,304 2,700,882 972,838 36.02%973,614 3,607,800 3,634,241 4,564,365 2,150,643 47.12%1,909,933 3,006,906 2,742,752 4,002,961 1,814,301 45.32%1,431,700 20,726,888$ 18,204,964$ 24,753,816$ 10,162,912$ 41.06%9,317,288$ 22,607,192 - - - - 6,395,389 9,327,622 - - - 5,106,266 1,070,704 5,273,907 1,691,042 32.06%1,554,577 34,108,847$ 10,398,325$ 5,273,907$ 1,691,042$ 32.06%1,554,577$ 54,835,735$ 28,603,289$ 30,027,723$ 11,853,954$ 39.48%10,871,865$ FYE 2015FYE 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 18,138,695 61.60%17,018,975 2,023,403 3,704,119 275,000 427,223 155.35%577,838 172 2,105 - 678 - 32,161,880$ 36,273,146$ 29,726,783$ 18,570,299$ 62.47%17,600,516$ 13,731,430 320,484 - - - 1,452,130 450,000 - - - - - 300,940 - - 15,183,560$ 770,484$ 300,940$ -$ -$ 47,345,440$ 37,043,630$ 30,027,723$ 18,570,299$ 61.84%17,600,516$ (7,490,295)$ 8,440,341$ 6,716,345$ 6,728,651$ 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 HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 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 Sales & Services Other Revenues Subtotal - Operating Expenditures Interfund Transfers Depreciation U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 6 2/23/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2017 PUBLIC UTILITIES FUND PNC Lockbox NCCMT Total 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$ January 2016 29,009,846$ 3,010,381$ 554,829$ 32,575,057$ Current Year Outstanding Interest 1,385,263$ 27,935,291$ Principal 2,903,937$ 74,815,351 Transfers Out 984,707$ - 5,273,907$ 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\January 2017 - Financial Statements.xlsx 7 2/23/2017 FYE 2015FYE 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,828,818$ 2,764,540$ 47.43%2,358,671$ 4,555,419$ 4,207,775$ 5,828,818$ 2,764,540$ 47.43%2,358,671$ 1,396,177 - - - - - - - - - 345,724 445,290 - - - 529,747 88,150 544,828 459,787 84.39%272,999 2,271,648$ 533,439$ 544,828$ 459,787$ 84.39%272,999$ 6,827,067$ 4,741,214$ 6,373,646$ 3,224,327$ 50.59%2,631,670$ FYE 2015FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date Same Period Last Fiscal Year 234,276$ 268,129$ 219,000$ 162,027$ 73.98%63,515$ 25,000 133,790 61,000 - - 5,165,089 5,313,693 5,265,540 4,056,173 77.03%3,800,806 499,631 139,437 - 9,592 133,743 276 1,291 20,000 785 3.93%251 5,924,272$ 5,856,340$ 5,565,540$ 4,228,577$ 75.98%3,998,315$ 1,402,161 917 - - - - - - - - - - 808,106 - - 1,402,161$ 917$ 808,106$ -$ -$ 7,326,433$ 5,857,257$ 6,373,646$ 4,228,577$ 66.34%3,998,315$ 499,366$ 1,116,043$ 1,004,250$ 1,366,645$ Fund Balance Appropriated Total Revenues HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 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 Rents, Concess. & Feees Other Finance Sources Subtotal - Operating Revenues Revenues: Taxes Intergovernmental Revenue Sales & Services Other Revenues Depreciation U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 8 2/23/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2017 SOLID WASTE FUND PNC BB&T First Bank NCCMT Total 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$ January 2016 1,838,468$ 495,010$ 469,484$ 123,226$ 2,926,188$ Current Year Outstanding Interest 78,464$ 295,375$ Principal 466,364 2,446,792 Transfers Out - - 544,828$ 2,742,167$ Debt Service and Transfer Requirements Cash and Investments $1,000,000 $2,000,000 $3,000,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 9 2/23/2017 FYE 2015FYE 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$ 14,000$ 43.75%14,000$ 123,636 1,243,316 1,093,000 280,919 25.70%739,646 152,636$ 1,264,316$ 1,125,000$ 294,919$ 26.22%753,646$ FYE 2015FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date FYE 2016 Activity 1,821,371$ 1,711,483$ 975,000$ 574,412$ 58.91%534,141$ 250,795 441,714 150,000 100,025 66.68%106,600$ - - - - 2,072,166$ 2,153,197$ 1,125,000$ 674,437$ 59.95%640,741$ 1,919,530$ 888,881$ 379,518$ (112,905)$ PNC NCCMT Total 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$ January 2016 1,556,134$ 1,211,772$ 2,767,906$ HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 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 $1,000,000 $2,000,000 $3,000,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 10 2/23/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2017 WORKER'S COMPENSATION FUND 4,690,195$ 38,849 Liability as of end of month 4,727,738$ Liability 76,392 # of Claims this fiscal year 38 Liability as of July 1 Current year claims and changes in estimates Actual claim payments U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 11 2/23/2017 FYE 2015FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 121,440$ 140,835$ 177,232$ 80,495$ 45.42%63,132$ 121,440$ 140,835$ 177,232$ 80,495$ 45.42%63,132$ FYE 2015FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date FYE 2016 Activity 228,950$ 242,612$ 177,232$ 85,290$ 48.12%137,800$ - - - - - - - - - - 228,950$ 242,612$ 177,232$ 85,290$ 48.12%137,800$ 107,510$ 101,777$ 4,795$ 74,668$ PNC NCCMT Total 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$ January 2016 612,081$ 29,241$ 641,322$ Fund Balance Appropriated HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2017 EMPLOYEE CLINIC FUND Department Employee Clinic Total Expenditures Revenues: Departmental Charge Other revenues Total Revenues Cash and Investments Revenues over / (under) expenditures $500,000 $600,000 $700,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 12 2/23/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2017 EMPLOYEE CLINIC FUND # of Visits January 2017 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 April 2016 149 March 2016 163 February 2016 159 January 2016 182 Employee Clinic Utilization 0 311 Health Prevention # Flu shots # Pneumonia shots 0 50 100 150 200 Patient Flow U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 13 2/23/2017 FYE 2015FYE 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$ 3,778,449$ 66.88%3,339,440$ 655,329 634,709 795,000 407,999 51.32%495,508 1,507 8,355 10,000 2,541 25.41%7,174 5,862,173$ 7,461,317$ 6,455,000$ 4,188,989$ 64.90%3,842,122$ FYE 2015FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date FYE 2016 Activity 6,687,178$ 7,892,453$ 6,443,000$ 4,204,680$ 65.26%3,777,520$ 10,783 26,178 12,000 16,471 137.26%23,422 6,697,961$ 7,918,631$ 6,455,000$ 4,221,151$ 65.39%3,800,943$ 835,788$ 457,314$ 32,162$ (41,179)$ PNC NCCMT Total 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$ January 2016 1,351,919$ 543,297$ 1,895,216$ HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 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,000,000 $1,500,000 $2,000,000 $2,500,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 14 2/23/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2017 MEDICAL INSURANCE FUND Employees & Pre-65 Retirees Total MembershipNet Paid ClaimsFixed Cost Loss Ratio Premium Equivalent 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$ January 2016 820 1,191 418,525.31$ 56,097.08$ 86.93%545,957.33$ 8301,2277,678,191.04$ 680,963.72$ 108.09%7,733,559.14$ Year to Date (membership = avg) Medical Paid Claims Summary 50%75%100%125% 150%175% Medical Plan Loss Ratio U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 15 2/23/2017 FYE 2015FYE 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$ 222,231$ 44.45%165,883$ 35,323 36,698 45,000 21,837 48.53%21,273 341,907$ 332,547$ 545,000$ 244,068$ 44.78%187,156$ FYE 2015FYE 2016 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date FYE 2016 Activity 544,448$ 369,211$ 545,000$ 264,349$ 48.50%208,818$ - - - - - 544,448$ 369,211$ 545,000$ 264,349$ 48.50%208,818$ 202,541$ 36,664$ 20,281$ 21,662$ PNC NCCMT Total 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$ January 2016 255,653$ -$ 255,653$ HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 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 $225,000 $250,000 $275,000 $300,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 16 2/23/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2017 DENTAL INSURANCE FUND Total Employees Total MembershipNet Paid ClaimsFixed Cost Loss Ratio Premium Equivalent 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$ January 2016 658 1,105 27,163.98$ 3,056.96$ 102.76%29,408.35$ 7541,230368,550.21$ 47,301.42$ 91.92%452,424.53$ Dental Paid Claims Summary Year to Date (membership = avg) 50% 75% 100% 125% Dental Plan Loss Ratio U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 17 2/23/2017 FYE 2015FYE 2016 2016 - 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 115,268,881$ 122,261,573$ 65,261,228$ 53.38% 115,268,881$ 122,261,573$ 65,270,223$ 53.39% -$ -$ -$ 8,995$ -$ 22,838,609 26,535,338 13,823,732 52.10% 21,557,719 26,535,338 13,699,041 51.63% -$ (1,280,890)$ -$ (124,691)$ -$ 11,365,474 14,918,045 6,315,553 42.33% 11,365,474 14,918,045 6,318,832 42.36% -$ -$ -$ 3,279$ -$ 3,165,403 1,020,323 - 2,844,295 1,020,323 213 0.02% -$ (321,108)$ -$ 213$ -$ 10,013,377 11,365,310 4,875,932 42.90% 10,608,154 11,365,310 4,508,843 39.67% -$ 594,777$ -$ (367,089)$ -$ 304,258 330,250 179,630 54.39% 299,648 330,250 185,659 56.22% -$ (4,609)$ -$ 6,029$ -$ 4,720,189 8,123,541 3,735,967 45.99% 5,253,011 8,123,541 3,510,029 43.21% -$ 532,822$ -$ (225,938)$ -$ - 167,676,190 184,554,380 94,192,042 51.04%- - 167,197,181 184,554,380 93,492,840 50.66%- -$ (479,009)$ -$ (699,202)$ -$ * Latest available numbers from the Board of Education's web site. State Fund HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2017 * BOARD OF EDUCATION Fund Group: Expenditures Revenues Federal Grant Fund Expenditures Revenues Expenditures Revenues Local Current Expense Fund 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 U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 18 2/23/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2017 * BOARD OF EDUCATION Capital Outlay Total January 2017 -$ December 2016 -$ November 2016 -$ October 2016 -$ September 2016 -$ August 2016 -$ July 2016 -$ June 2016 -$ May 2016 10,442,838$ 59,509$ 10,502,347$ April 2016 -$ March 2016 8,709,721$ 59,476$ 8,769,197$ February 2016 -$ January 2016 -$ 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 0 0 Month 5 0 0 Month 6 0 0 Month 7 0 0 Month 8 0 0 Month 9 0 0 Final 0 0 Public School Membership Fiscal Year 2016-2017 Initial Allotment 20,850 Cash and Investments Local Currrent Expense $5,000,000 $7,000,000 $9,000,000 $11,000,000 Cash Flow 19,500 20,000 20,500 21,000 Harnett County School Membership ADM MLD U:\My Documents\Monthly Reports\2016 - 2017\January 2017 - Financial Statements.xlsx 19