Loading...
May 2016 - Financial Statements6/24/2016 FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year $ 164,631 $ 158,070 $ 277,153 $ 278,890 100.63% $ 121,113 250,759 280,372 263,472 439,861 166.95% 226,405 103,351 8,609 69,617 179,791 258.26% (16,954) 1 - - - 50,402 254,738 247,154 238,649 260,888 109.32% 202,982 303,532 305,481 442,442 327,105 73.93% 282,052 729,469 833,532 834,115 967,280 115.96% 675,555 - - - - - 77,704 79,320 411,771 77,139 18.73% 76,171 1,569,231 1,588,997 1,802,759 1,487,132 82.49% 1,322,461 140,485 153,360 161,852 130,299 80.51% 136,306 438,847 603,102 579,622 464,905 80.21%518,305 1,004,266 839,486 1,861,552 1,172,160 62.97% 696,297 194,790 209,741 219,108 136,311 62.21% 185,899 3,400,887 3,736,788 3,745,848 2,969,145 79.26% 2,805,879 730,166 695,654 790,642 642,951 81.32% 610,221 1,301,628 1,726,510 1,917,855 1,741,205 90.79% 1,557,520 432,327 436,602 615,987 557,392 90.49% 377,350 10,166,283 10,205,366 10,182,842 8,160,798 80.14% 8,886,098 354,232 389,674 480,900 382,966 79.64% 346,005 80,119 - - - - 15,213 1,607 46,161 23,765 51.48% 1,607 66,257 70,126 76,867 57,980 75.43% 62,027 26,536 - - - - 1,219,142 1,389,574 1,722,028 1,422,623 82.61% 1,227,400 School Resource Officers - - 691,067 597,842 86.51% - 4,306,490 4,407,161 4,812,299 3,805,352 79.08% 3,877,762 737,021 765,164 881,381 581,767 66.01% 638,975 32,000 - 60,000 - - 3,991,897 4,080,768 4,340,552 3,636,307 83.78% 3,446,057 1,083,318 1,144,801 1,183,589 1,016,122 85.85% 916,584 3,314,704 3,361,704 3,361,704 3,081,563 91.67% 3,361,704 376,744 431,707 498,413 354,078 71.04% 358,414 50,000 47,050 65,000 63,800 98.15% 43,850 - 4,516 7,160 5,909 82.53%3,636 124,334 79,180 71,168 63,671 89.47% 72,943 240,521 236,688 - - 217,727 300,204 246,495 - (11,519) 199,336 174,955 208,990 209,736 149,492 71.28% 151,710 124,133 161,801 191,879 151,490 78.95% 141,261 4,000 4,000 4,000 4,000 100.00% 4,000 114,849 112,289 111,511 89,399 80.17% 94,327 449,748 458,253 576,000 365,849 63.52% 376,103 776,301 1,382,346 674,272 414,546 61.48% 1,351,333 1,321,571 1,362,552 1,365,164 1,147,305 84.04% 1,169,484 1,129 735 300 52 17.33% 559 31,903 57,241 36,298 29,216 80.49% 48,680 351,557 289,118 389,857 248,273 63.68% 240,116 31,419 25,623 22,443 16,879 75.21% 22,874 2,483 379 600 150 25.00% 342 158,263 44,813 59,354 41,863 70.53% 40,646 59,107 60,321 75,469 67,184 89.02% 55,616 Facilities Maintenance Register of Deeds Campbell Deputies 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 Board of Elections Finance Planning & Inspections Community Development (BG) Abandoned MFG Home Cooperative Extension CCR&R - Block Grant Soil & Water Department Governing Body Administration General Services Fleet Maintenance Transportation Transportation - Admin HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 GENERAL FUND CCR&R - United Way Emergency Medical Service Insurance - Retirees EMS Transport Rescue Districts Harnett CJPP Sheriff's Department Grants Child Support Enforcement Governor's Highway Safety Communications Jail Emergency Services Emergency Services Grant Animal Services Medical Examiner Parents As Teachers Adolescent Parenting Clerk of Court Information Technology GIS Sheriff Tax U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 1 6/24/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 GENERAL FUND FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 45,686 - 52,653 39,905 75.79% 43,379 27,367 50,723 - - - 13,570 - 11,107 3,492 31.44% 14,190 3,789 14,200 - - - - - 32,695 20,257 61.96% - 283,332 307,602 317,411 265,141 83.53% 275,063 51,769 64,108 64,510 53,884 83.53% 56,469 73,276 77,658 77,858 67,552 86.76% 68,820 326,783 328,753 378,328 283,618 74.97% 294,349 378,087 414,989 437,517 371,574 84.93% 370,900 5,787,018 6,014,268 7,345,531 5,251,493 71.49% 5,279,052 815,679 605,679 605,679 605,679 100.00% 605,679 9,359,396 10,155,398 10,585,495 8,982,095 84.85% 8,786,279 7,829,453 7,905,017 10,572,010 8,229,577 77.84% 7,052,060 172,197 178,634 185,461 157,869 85.12% 157,844 110,369 100,304 118,965 87,204 73.30% 87,680 99,840 90,780 145,000 129,039 88.99% 75,298 928,107 941,972 1,001,229 765,493 76.46% 797,645 100,000 150,000 153,000 3,000 1.96% - 363,011 403,871 455,928 368,567 80.84% 335,857 20,523,700 21,523,700 21,267,993 21,267,993 100.00% 21,523,700 - - 280,707 252,810 90.06%- 927,711 928,467 993,967 909,011 91.45%917,467 - - - - - 25,000 25,000 25,000 - 25,000 - - 70,000 - - $ 89,428,385 $ 93,213,943 $ 101,608,502 $ 85,916,429 84.56% $ 83,951,871 1,903,876 64,701 283,334 43,334 15.29% 49,272 13,902,144 44,265,436 53,002,023 52,672,888 99.38% 44,221,567 - - 489,926 - $ 15,806,020 $ 44,330,137 $ 53,775,283 $ 52,716,222 98.03% $ 44,270,839 105,234,405$ 137,544,080$ 155,383,785$ 138,632,651$ 89.22%128,222,710$ Cultural & Recreational App. Parks & Recreation Education Special Programs Subtotal - Operating Expenditures Subtotal Other Financing Uses: Department Mental Health Social Services Public Assistance Veteran's Services Family Caregiver Support RSVP Interfund Transfers Debt Service Contingency Total Expenditures 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 Central Carolina - DOT U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 2 6/24/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 GENERAL FUND FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 54,120,822$ 53,930,707$ 54,402,634$ 54,538,390$ 100.25%53,941,860$ 3,949,979 5,712,141 5,654,182 5,060,101 89.49%4,704,268 14,884,497 16,757,810 16,154,459 10,833,221 67.06%11,460,153 1,037,719 1,053,493 1,200,000 923,826 76.99%787,564 2,763,205 2,515,489 3,363,930 2,780,496 82.66%2,278,598 19,304,274 18,884,854 20,062,746 14,480,682 72.18%13,059,850 7,658,151 7,838,973 8,898,120 8,068,394 90.68%6,168,786 3,451,519 3,741,739 3,559,176 2,816,299 79.13%3,206,574 75,787 69,215 73,779 68,316 92.60%58,027 107,245,953 110,504,421 113,369,026 99,569,725 87.83%95,665,680 2,111 8,437 5,000 15,023 300.46%1,276 857,548 29,108,938 37,468,000 37,018,000 98.80%29,098,735 460,947 322,415 55,656 7,501 13.48%- - - 4,486,103 - - 1,320,606 29,439,790 42,014,759 37,040,524 88.16%29,100,011 108,566,559$ 139,944,211$ 155,383,785$ 136,610,249$ 87.92%124,765,691$ 2,400,131$ (2,022,402)$ (3,457,019) Other Financing Sources Interfund Transfers Fund Balance Appropriated Total Revenues Permits & Fees Intergovernmental Revenue Sales & Services Other Revenues Rents, Concessions & Fees Ad Valorem Taxes Motor Vehicles Sales Tax Other taxes Revenues: Real and Personal Investment Earnings Subtotal - Operating Revenues Subtotal Other Financing Sources: Revenues over / (under) expenditures U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 3 6/24/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 GENERAL FUND Cash Tax Lockbox MBS NCCMT Total 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$ December 2015 638,944$ -$ 4,715,250$ 27,050,869$ 32,405,064$ November 2015 -$ -$ 4,715,250$ 24,697,474$ 29,412,724$ October 2015 -$ -$ 3,415,750$ 15,184,900$ 18,600,650$ September 2015 -$ -$ 1,799,750$ 16,262,992$ 18,062,742$ August 2015 -$ -$ 1,799,750$ 14,138,439$ 15,938,189$ July 2015 482,070$ -$ 1,199,750$ 19,037,670$ 20,719,491$ June 2015 6,004,643$ -$ 999,750$ 18,681,713$ 25,686,107$ May 2015 3,587,900$ -$ 1,149,750$ 22,024,531$ 26,762,181$ Current Year Outstanding Interest 4,627,480$ 44,149,422$ Principal 9,760,978 121,114,540 Transfers Out - - 14,388,459$ 165,263,961$ 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\2015 - 2016\May 2016 - Financial Statements.xlsx 4 6/24/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 GENERAL FUND Unassigned Fund Balance at June 30, 2015 19,417,388$ 17.89% Year to Date Revenues over/(under) Expenditures (2,022,402) 17,394,986 Remaining Debt Payments for this Year (329,135) Outstanding budget amendments - Year to Date Fund Balance Appropriated (4,486,103) (4,815,238) 12,579,748$ 8.10% Amount by which fund balance percentage will change 1,553,838$ If the County were to stop operations at the end of this month and had no further receivables or payables, then this would be the estimated fund balance amount and its percentage of expenditures. Unassigned 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. 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. 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 U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 5 6/24/2016 FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 7,543,128$ 6,369,116$ 6,933,860$ 3,772,230$ 54.40%16,117,584$ 3,671,291 3,965,881 4,466,822 3,456,279 77.38%3,295,448 1,965,319 1,908,016 2,397,828 1,423,586 59.37%1,597,525 1,860,402 1,869,169 2,337,624 1,650,767 70.62%1,565,058 3,383,463 3,607,800 4,607,923 3,176,693 68.94%3,208,055 2,975,052 3,006,906 3,363,958 2,169,916 64.50%2,662,226 21,398,655$ 20,726,888$ 24,108,015$ 15,649,471$ 64.91%28,445,896$ 400,000 22,607,192 - - 11,727,732 Depreciation 6,122,500 6,395,389 - - - 5,163,405 5,106,266 4,675,084 4,824,579 103.20%3,732,154 11,685,905$ 34,108,847$ 4,675,084$ 4,824,579$ 103.20%15,459,886$ 33,084,560$ 54,835,735$ 28,783,099$ 20,474,050$ 71.13%43,905,782$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 3,703$ 3,703$ 3,703$ 3,703$ 100.00%3,703$ 30,275,723 30,134,602 26,984,920 27,289,138 101.13%25,857,024 13,281,536 2,023,403 1,794,476 2,251,145 125.45%2,466,505 96 172 - - 14 43,561,058$ 32,161,880$ 28,783,099$ 29,543,986$ 102.64%28,327,246$ 473,683 13,731,430 - 312,197 12,113,312 150,000 1,452,130 - - 652,130 - - - - - 623,683$ 15,183,560$ -$ 312,197$ 12,765,442$ 44,184,741$ 47,345,440$ 28,783,099$ 29,856,183$ 103.73%41,092,688$ 9,382,133$ (2,813,094)$ Subtotal - Operating Expenditures Interfund Transfers Debt Service Subtotal Other Financing Uses: Subtotal - Operating Revenues Total Expenditures Revenues: Intergovernmental Revenue Sales & Services Other Revenues Revenues over / (under) expenditures Rents, Concess. & Feees Other Finance Sources Interfund Transfers Fund Balance Appropriated Total Revenues Subtotal Other Financing Sources: HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 PUBLIC UTILITIES FUND Department Admin/CSR/Meter Services Water Treatment Wastewater Treatment Wastewater Treatment SHWW Distribution Collections U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 6 6/24/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 PUBLIC UTILITIES FUND Cash Lockbox NCCMT Total 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$ December 2015 24,228,551$ 3,662,494$ 553,621$ 28,444,666$ November 2015 24,058,100$ 3,267,333$ 552,071$ 27,877,505$ October 2015 23,345,138$ 3,268,625$ 549,916$ 27,163,678$ September 2015 22,373,066$ 3,142,028$ 549,700$ 26,064,794$ August 2015 20,802,670$ 3,162,849$ 549,270$ 24,514,789$ July 2015 19,413,391$ 3,411,495$ 549,057$ 23,373,942$ June 2015 21,051,962$ 2,602,443$ 548,475$ 24,202,879$ May 2015 20,248,407$ 2,565,016$ 547,616$ 23,361,038$ Current Year Outstanding Interest 2,660,203$ 29,561,667$ Principal 4,621,391$ 80,736,891 Transfers Out -$ - 7,281,594$ 110,298,558$ Cash and Investments Debt Service and Transfer Requirements $20,000,000 $30,000,000 $40,000,000 Cash Flow U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 7 6/24/2016 FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 4,407,605$ 4,555,419$ 5,497,002$ 4,178,332$ 76.01%5,160,605$ 4,407,605$ 4,555,419$ 5,497,002$ 4,178,332$ 76.01%5,160,605$ - 1,396,177 - - - - - - - - Depreciation 289,683 345,724 - - - 464,609 529,747 547,253 493,992 90.27%481,317 754,292$ 2,271,648$ 547,253$ 493,992$ 90.27%481,317$ 5,161,897$ 6,827,067$ 6,044,255$ 4,672,324$ 77.30%5,641,922$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 237,297$ 234,276$ 239,000$ 194,789$ 81.50%174,452$ - 25,000 130,000 133,790 102.92%- 5,006,315 5,165,089 5,111,300 4,973,325 97.30%4,995,980 378,116 499,631 101,650 139,278 137.02%263,563 243 276 - 17,869 119 5,621,971$ 5,924,272$ 5,581,950$ 5,459,051$ 97.80%5,434,114$ 739,763 1,402,161 - - 1,402,161 - - - - - - - 462,305 - - 739,763$ 1,402,161$ 462,305$ -$ 1,402,161$ 6,361,734$ 7,326,433$ 6,044,255$ 5,459,051$ 90.32%6,836,275$ 786,727$ 1,194,353$ Rents, Concess. & Feees Other Finance Sources Subtotal - Operating Revenues Revenues: Taxes Intergovernmental Revenue Sales & Services Other Revenues HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 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\2015 - 2016\May 2016 - Financial Statements.xlsx 8 6/24/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 SOLID WASTE FUND Cash BB&T First Bank NCCMT Total 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$ December 2015 1,157,547$ 482,090$ 451,079$ 123,226$ 2,213,942$ November 2015 795,755$ 469,359$ 439,402$ 123,226$ 1,827,742$ October 2015 160,831$ 456,391$ 422,540$ 59,824$ 1,099,587$ September 2015 182,041$ 425,002$ 394,917$ 59,824$ 1,061,785$ August 2015 372,508$ 425,018$ 395,198$ 59,824$ 1,252,548$ July 2015 350,504$ 379,409$ 365,494$ -$ 1,095,407$ June 2015 575,612$ 375,758$ 368,150$ -$ 1,319,520$ May 2015 954,650$ 359,056$ 333,965$ 443,279$ 2,090,950$ Current Year Outstanding Interest 127,831$ 335,060$ Principal 510,937 2,700,856 Transfers Out - - 638,767$ 3,035,917$ Cash and Investments Debt Service and Transfer Requirements $1,000,000 $2,000,000 $3,000,000 Cash Flow U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 9 6/24/2016 FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year -$ 29,000$ 35,000$ 21,000$ 60.00%452,064$ 2,979,815 123,636 1,865,000 1,143,316 61.30%- 2,979,815$ 152,636$ 1,900,000$ 1,164,316$ 61.28%452,064$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 1,704,822$ 1,821,371$ 1,750,000$ 855,863$ 48.91%812,244$ 280,523 250,795 150,000 331,482 220.99%164,157$ - - - - 1,985,345$ 2,072,166$ 1,900,000$ 1,187,345$ 62.49%976,401$ 23,029$ 524,337$ Cash NCCMT Total 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$ December 2015 1,193,599$ 1,211,772$ 2,405,371$ November 2015 1,273,094$ 1,211,772$ 2,484,866$ October 2015 1,329,590$ 1,211,772$ 2,541,362$ September 2015 1,238,990$ 1,211,772$ 2,450,762$ August 2015 1,234,512$ 1,211,772$ 2,446,284$ July 2015 1,140,351$ 1,211,772$ 2,352,123$ June 2015 1,588,872$ 1,234,390$ 2,823,262$ May 2015 1,273,019$ 562,026$ 1,835,045$ 2,839,689$ 134,020 3,094,894$ Revenues over/(under) expenses Liability as of July 1 Current year claims and changes in estimates Departmental Charge Other revenues Fund Balance Appropriated Total HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 WORKER'S COMPENSATION FUND Cash and Investments Liability 389,225 # of Claims this fiscal year 74 Category Fixed Cost Claims Funded Total Actual claim payments Liability as of end of month Revenues: $1,000,000 $2,000,000 $3,000,000 Cash Flow U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 10 6/24/2016 FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 83,514$ 121,440$ 254,588$ 125,756$ 49.40%104,819$ 83,514$ 121,440$ 254,588$ 125,756$ 49.40%104,819$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 282,984$ 228,950$ 254,588$ 218,075$ 85.66%209,600$ - - - - - - - - - - 282,984$ 228,950$ 254,588$ 218,075$ 85.66%209,600$ 92,319$ 104,781$ Cash NCCMT Total 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$ December 2015 602,255$ 29,241$ 631,496$ November 2015 592,428$ 29,241$ 621,670$ October 2015 582,054$ 29,241$ 611,295$ September 2015 554,324$ 29,241$ 583,566$ August 2015 544,121$ 29,241$ 573,362$ July 2015 533,487$ 29,241$ 562,729$ June 2015 542,686$ 29,241$ 571,928$ May 2015 534,685$ 29,241$ 563,926$ Total Revenues over/(under) expenses Cash and Investments Fund Balance Appropriated HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 EMPLOYEE CLINIC FUND Department Employee Clinic Total Revenues: Departmental Charge Other revenues $500,000 $600,000 $700,000 Cash Flow U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 11 6/24/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 EMPLOYEE CLINIC FUND # of Visits May 2016 171 April 2016 149 March 2016 163 February 2016 159 January 2016 182 December 2015 196 November 2015 132 October 2015 144 September 2015 131 August 2015 98 July 2015 113 June 2015 117 May 2015 124 Employee Clinic Utilization 2 327 Health Prevention # Flu shots # Pneumonia shots 0 50 100 150 200 Patient Flow U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 12 6/24/2016 FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year -$ 5,205,337$ 6,195,000$ 5,832,094$ 94.14%4,266,847$ - 655,329 790,000 674,623 85.40%662,901 - 1,507 15,000 7,174 47.83%13,000 -$ 5,862,173$ 7,000,000$ 6,513,891$ 93.06%4,942,748$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year -$ 6,687,178$ 7,000,000$ 5,962,214$ 85.17%6,159,114$ 588,107 10,783 - 25,526 10,783 588,107$ 6,697,961$ 7,000,000$ 5,987,740$ 85.54%6,169,897$ (526,151)$ 1,227,149$ Cash NCCMT Total 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$ December 2015 1,222,061$ 543,297$ 1,765,358$ November 2015 1,387,910$ 543,297$ 1,931,207$ October 2015 1,290,451$ 543,297$ 1,833,748$ September 2015 1,502,651$ 543,297$ 2,045,949$ August 2015 1,387,676$ 543,297$ 1,930,973$ July 2015 1,204,970$ 543,297$ 1,748,267$ June 2015 1,393,258$ 543,297$ 1,936,555$ May 2015 1,272,924$ 543,297$ 1,816,222$ HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 MEDICAL INSURANCE FUND Cash and Investments Category Paid Claims Wellness Total Revenues: Medical Premium Equivilents Other revenues Total Fixed Cost Revenues over/(under) expenses $1,000,000 $1,500,000 $2,000,000 $2,500,000 Cash Flow U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 13 6/24/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 MEDICAL INSURANCE FUND Employees & Pre-65 Retirees Total Membership Net Paid Claims Fixed Cost Loss Ratio Premium Equivalent July 2015 800 1,162 320,633.21$ 54,321.22$ 69.90%536,400.67$ August 2015 802 1,167 383,357.49$ 56,855.83$ 82.22%535,395.42$ September 2015 802 1,169 465,117.51$ 55,311.71$ 96.87%537,247.45$ October 2015 808 1,174 650,383.71$ 103,099.20$ 141.27%533,359.40$ November 2015 808 1,173 531,699.65$ 59,136.25$ 108.27%545,697.46$ December 2015 812 1,177 448,829.22$ 52,614.19$ 92.18%544,006.75$ January 2016 820 1,191 418,525.31$ 56,097.08$ 86.93%545,957.33$ February 2016 829 1,199 476,696.71$ 57,028.00$ 97.08%549,770.71$ March 2016 824 1,192 613,689.61$ 55,057.79$ 122.98%543,783.54$ April 2016 819 1,190 846,544.07$ 59,316.96$ 166.24%544,921.50$ May 2016 821 1,195 644,458.97$ 18,765.56$ 121.42%546,217.69$ June 2016 813 1,181 5,799,935.46$ 627,603.79$ 107.79%5,962,757.92$ Medical Paid Claims Summary Year to Date (membership = avg) 50.00%75.00%100.00%125.00%150.00% 175.00% Medical Plan Loss Ratio U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 14 6/24/2016 FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year -$ 306,584$ 506,000$ 268,525$ 53.07%235,155$ - 35,323 40,000 33,589 83.97%32,359 -$ 341,907$ 546,000$ 302,114$ 55.33%267,514$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year -$ 544,448$ 546,000$ 331,022$ 60.63%514,200$ - - - - 166,433 -$ 544,448$ 546,000$ 331,022$ 60.63%680,633$ 28,908$ 413,119$ Cash NCCMT Total 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$ December 2015 257,742$ -$ 257,742$ November 2015 251,362$ -$ 251,362$ October 2015 242,621$ -$ 242,621$ September 2015 249,844$ -$ 249,844$ August 2015 249,852$ -$ 249,852$ July 2015 248,309$ -$ 248,309$ June 2015 247,472$ -$ 247,472$ May 2015 246,685$ -$ 246,685$ HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 DENTAL INSURANCE FUND Cash and Investments Category Paid Claims Fixed Cost Total Revenues: Dental Premium Equivilents Other revenues Total Revenues over/(under) expenses $230,000 $240,000 $250,000 $260,000 $270,000 Cash Flow U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 15 6/24/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 DENTAL INSURANCE FUND Total Employees Total Membership Net Paid Claims Fixed Cost Loss Ratio Premium Equivalent July 2015 399 653 14,975.40$ 6,090.62$ 70.66%29,813.15$ August 2015 398 651 31,428.55$ 3,033.66$ 116.21%29,654.93$ September 2015 399 650 28,953.57$ 3,033.66$ 106.13%30,140.02$ October 2015 403 654 30,171.44$ 3,033.66$ 114.74%28,939.38$ November 2015 400 651 19,987.80$ 3,010.36$ 74.83%30,735.68$ December 2015 400 651 20,264.80$ 3,047.64$ 77.38%30,126.24$ January 2016 409 661 27,163.98$ 3,056.96$ 102.76%29,408.35$ February 2016 412 663 20,728.10$ 3,075.60$ 76.42%31,147.59$ March 2016 410 661 29,696.70$ 3,122.20$ 110.76%29,629.84$ April 2016 408 659 31,526.79$ 3,033.66$ 115.55%29,909.42$ May 2016 414 667 22,062.20$ 3,084.92$ 84.50%29,760.98$ June 2016 405 656 276,959.33$ 36,622.94$ 95.24%329,265.58$ Dental Paid Claims Summary Year to Date (membership = avg) 50.00% 75.00% 100.00% 125.00% Dental Plan Loss Ratio U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 16 6/24/2016 FYE 2014 FYE 2015 2015 - 2016 Total Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 118,086,677$ 102,207,084$ 86.55% 118,086,677$ 102,223,378$ 86.57% -$ -$ -$ 16,295$ -$ 26,725,166 19,279,878 72.14% 26,725,166 21,520,806 80.53% -$ -$ -$ 2,240,928$ -$ 13,762,134 9,658,731 70.18% 13,762,134 9,670,260 70.27% -$ -$ -$ 11,528$ -$ 5,194,181 2,990,946 57.58% 5,194,181 2,681,150 51.62% -$ -$ -$ (309,796)$ -$ 11,026,600 9,324,806 84.57% 11,026,600 9,246,428 83.86% -$ -$ -$ (78,378)$ -$ 536,488 292,697 54.56% 536,488 284,577 53.04% -$ -$ -$ (8,120)$ -$ 8,394,394 3,813,528 45.43% 8,394,394 4,694,184 55.92% -$ -$ -$ 880,656$ -$ - - 183,725,641 147,567,670 80.32%- - - 183,725,641 150,320,783 81.82%- -$ -$ -$ 2,753,113$ -$ * Latest available numbers from the Board of Education's web site. Revenues Total All Funds Capital Outlay Fund Expenditures Revenues Child Nutrition Fund Expenditures Revenues Expenditures Revenues Dunn District Fund Expenditures Revenues Local Restricted Fund Expenditures Expenditures Revenues Local Current Expense Fund Expenditures Revenues Federal Grant Fund Expenditures Revenues State Fund HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 * BOARD OF EDUCATION Fund Group: U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 17 6/24/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 * BOARD OF EDUCATION Capital Outlay Total 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 -$ December 2015 -$ November 2015 -$ October 2015 -$ September 2015 -$ August 2015 -$ July 2015 -$ June 2015 -$ May 2015 -$ ADM MLD ADM Change MLD Change Month 1 20,405 20,543 Month 1 Revd 20,387 20,495 (18)(48) Month 2 20,505 20,504 118 9 Month 3 20,468 20,465 (37)(39) Month 4 20,360 20,332 (108)(133) Month 5 20,229 20,190 (131)(142) Month 6 20,164 20,191 (65)1 Month 7 20,142 20,148 (22)(43) Month 8 Month 9 Cash and Investments Local Currrent Expense Public School Membership Fiscal Year 2015-2016 Initial Allotment 20,725 $5,000,000 $7,000,000 $9,000,000 $11,000,000 Cash Flow 20,00020,250 20,500 20,750 21,000 Harnett County School Membership ADM MLD U:\My Documents\Monthly Reports\2015 - 2016\May 2016 - Financial Statements.xlsx 18