No preview available
HomeMy WebLinkAboutMarch 2016 - Financial Statements4/22/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 $ 230,951 83.33% $ 67,110 250,759 280,372 263,472 352,361 133.74% 141,455 103,351 8,609 69,617 146,698 210.72% 11,836 1 - - - 42,335 254,738 247,154 238,649 217,632 91.19% 149,507 303,532 305,481 442,442 275,110 62.18% 248,800 729,469 833,532 842,115 767,408 91.13% 469,282 77,704 79,320 411,771 64,942 15.77% 62,383 1,569,231 1,588,997 1,695,468 1,108,201 65.36% 1,046,614 140,485 153,360 161,852 105,756 65.34% 112,551 438,847 603,102 579,622 366,102 63.16%431,634 1,004,266 839,486 1,859,552 934,475 50.25% 551,847 194,790 209,741 219,108 106,846 48.76% 145,866 3,400,887 3,736,788 3,708,493 2,465,098 66.47% 2,242,883 730,166 695,654 790,642 527,448 66.71% 509,334 1,301,628 1,726,510 1,917,855 1,461,678 76.21% 1,259,581 432,327 436,602 615,987 449,039 72.90% 307,871 10,166,283 10,205,366 10,202,126 6,666,830 65.35% 7,178,249 354,232 389,674 480,900 316,105 65.73% 289,425 80,119 - - - - 15,213 1,607 46,161 23,765 51.48% 1,607 66,257 70,126 76,867 47,219 61.43% 51,110 26,536 - - - - 1,219,142 1,389,574 1,722,028 1,182,960 68.70% 1,012,597 School Resource Officers - - 691,067 476,324 68.93% - 4,306,490 4,407,161 4,792,299 3,064,632 63.95% 3,181,986 737,021 765,164 838,463 479,950 57.24% 522,553 32,000 - 60,000 - 0.00% - 3,991,897 4,080,768 4,368,228 2,887,683 66.11% 2,798,411 1,083,318 1,144,801 1,155,913 808,459 69.94% 743,135 3,314,704 3,361,704 3,361,704 2,521,278 75.00% 2,801,421 376,744 431,707 498,413 284,229 57.03% 287,636 50,000 47,050 65,000 44,500 68.46% 31,600 - 4,516 8,040 4,193 52.15%1,893 124,334 79,180 71,168 53,213 74.77% 60,485 240,521 236,688 - - 176,950 300,204 246,495 285,000 107,046 37.56% 155,809 174,955 208,990 209,736 121,352 57.86% 128,380 124,133 161,801 183,879 121,817 66.25% 112,063 4,000 4,000 4,000 4,000 100.00% 4,000 114,849 112,289 111,511 71,012 63.68% 76,455 449,748 458,253 576,000 283,429 49.21% 291,345 776,301 1,382,346 674,272 361,997 53.69% 731,495 1,321,571 1,362,552 1,365,164 925,674 67.81% 948,552 1,129 735 300 2 0.67% 290 31,903 57,241 36,298 22,749 62.67% 37,617 351,557 289,118 389,913 190,424 48.84% 178,372 31,419 25,623 22,443 12,131 54.05% 22,810 2,483 379 600 104 17.33% 340 158,263 44,813 59,354 33,829 57.00% 28,390 59,107 60,321 70,295 53,203 75.69% 45,182 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 Human Resources Board of Elections Finance Clerk of Court Information Technology GIS Sheriff Tax General Services Fleet Maintenance Transportation Transportation - Admin Campbell Deputies Legal Services Engineering HARNETT COUNTY FINANCIAL SUMMARY REPORT March, 2016 GENERAL FUND CCR&R - United Way Emergency Medical Service Parents As Teachers Adolescent Parenting Planning & Inspections Community Development (BG) Abandoned MFG Home Cooperative Extension CCR&R - Block Grant Soil & Water Department Governing Body Administration Facilities Maintenance Register of Deeds Environmental Protection Forestry Program Economic/Physical Dev. App. Industrial Development JCPC Admin Public Safety Appropriations Emergency Telephone System Radio System Harnett Regional Jetport U:\My Documents\Monthly Reports\2015 - 2016\March 2016 - Financial Statements.xlsx 1 4/22/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT March, 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 - 49,773 30,115 60.50% 33,006 27,367 50,723 - - - 13,570 - 11,107 3,492 31.44% 13,924 3,789 14,200 - - - - - 24,495 13,616 55.59% - 283,332 307,602 317,411 212,716 67.02% 208,418 51,769 64,108 64,360 42,903 66.66% 45,226 73,276 77,658 77,258 54,474 70.51% 56,163 326,783 328,753 378,328 231,131 61.09% 245,805 378,087 414,989 437,457 297,579 68.02% 277,830 5,787,018 6,014,268 7,282,246 4,217,003 57.91% 4,147,998 815,679 605,679 605,679 554,259 91.51% 554,259 9,359,396 10,155,398 10,585,495 7,309,963 69.06% 6,897,373 7,829,453 7,905,017 10,088,010 6,738,240 66.79% 5,744,479 172,197 178,634 183,173 128,663 70.24% 128,870 110,369 100,304 120,965 71,986 59.51% 72,647 99,840 90,780 145,000 129,039 88.99% 75,298 928,107 941,972 1,001,229 609,866 60.91% 694,669 100,000 150,000 153,000 3,000 1.96% - 363,011 403,871 455,928 314,314 68.94% 263,872 20,523,700 21,523,700 21,267,993 15,950,995 75.00% 16,142,775 - - 280,707 136,885 48.76%- 927,711 928,467 993,967 739,100 74.36%688,100 - - - - - 25,000 25,000 25,000 - 0.00%- - - 70,000 - 0.00%- 1,903,876 64,701 283,334 43,334 15.29% 26,667 13,902,144 44,265,436 21,922,023 16,728,528 76.31% 10,360,061 - - 489,926 - 0.00% 105,234,405$ 137,544,080$ 123,834,804$ 85,311,055$ 68.89%76,378,487$ 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,295,343$ 53,598,412$ 98.72%52,614,663$ 3,949,979 5,712,141 5,654,182 3,909,985 69.15%3,640,700 14,884,497 16,757,810 16,154,459 8,226,914 50.93%9,119,237 1,037,719 1,053,493 1,200,000 739,264 61.61%613,069 2,763,205 2,515,489 3,723,930 2,118,672 56.89%1,798,994 19,304,274 18,884,854 19,638,170 12,143,340 61.84%10,469,232 7,658,151 7,838,973 8,840,960 6,850,389 77.48%4,718,343 3,451,519 3,741,739 3,549,982 1,714,544 48.30%2,278,781 77,898 77,652 78,779 73,684 93.53%45,711 857,548 29,108,938 6,388,000 5,938,000 92.96%3,896 460,947 322,415 55,656 7,501 13.48%- - - 4,255,343 - 0.00%- 108,566,559$ 139,944,211$ 123,834,804$ 95,320,705$ 76.97%85,302,626$ 2,400,131$ 10,009,650$ 8,924,139 4-H Teen Court & At Risk Child Care Youth Training Race to the Top Adolescent Parenting - BJRH Department on Aging Restitution CAP - Disabled Adults Real and Personal 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 Motor Vehicles Sales Tax Other taxes Interfund Transfers Debt Service Contingency Total Revenues: Department Revenues over/(under) expenditures Other Finance Sources Interfund Transfers Fund Balance Appropriated Total Permits & Fees Intergovernmental Revenue Sales & Services Other Revenues Rents, Concessions. & Fees Ad Valorem Taxes Central Carolina - DOT Cultural & Recreational App. Parks & Recreation Education Special Programs U:\My Documents\Monthly Reports\2015 - 2016\March 2016 - Financial Statements.xlsx 2 4/22/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT March, 2016 GENERAL FUND Cash Tax Lockbox MBS NCCMT Total 3,888,938$ -$ 5,910,697$ 31,321,226$ 41,120,861$ 6,184,218$ -$ 5,460,397$ 29,217,771$ 40,862,386$ 10,575,231$ -$ 4,715,250$ 27,749,119$ 43,039,600$ 638,944$ -$ 4,715,250$ 27,050,869$ 32,405,064$ -$ -$ 4,715,250$ 24,697,474$ 29,412,724$ -$ -$ 3,415,750$ 15,184,900$ 18,600,650$ -$ -$ 1,799,750$ 16,262,992$ 18,062,742$ -$ -$ 1,799,750$ 14,138,439$ 15,938,189$ 482,070$ -$ 1,199,750$ 19,037,670$ 20,719,491$ 6,004,643$ -$ 999,750$ 18,681,713$ 25,686,107$ 3,587,900$ -$ 1,149,750$ 22,024,531$ 26,762,181$ 10,758,278$ -$ 1,099,750$ 20,688,202$ 32,546,230$ 19,176,680$ -$ 1,099,750$ 19,219,802$ 39,496,232$ 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$ January, 2016 April, 2015 May, 2015 July, 2015 August, 2015 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. 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. Debt Service and Transfer Requirements June, 2015 Estimated Fund Balance March, 2015 October, 2015 September, 2015 December, 2015 November, 2015 Cash and Investments March, 2016 February, 2016 Unassigned Fund Balance - U:\My Documents\Monthly Reports\2015 - 2016\March 2016 - Financial Statements.xlsx 3 4/22/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT March, 2016 GENERAL FUND Unassigned Fund Balance at June 30, 2015 19,417,388$ 17.89% Year to Date Revenues over/(under) Expenditures 10,009,650 29,427,038 Remaining Debt Payments for this Year (5,193,495) Outstanding budget amendments - Year to Date Fund Balance Appropriated (4,255,343) (9,448,838) 19,978,200$ 16.13% Amount by which fund balance percentage will change 1,238,348$ 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. The Harnett County Board of Commissioners have approved a fund balance policy which strives to maintain a minimum fund balance of 15%. U:\My Documents\Monthly Reports\2015 - 2016\March 2016 - Financial Statements.xlsx 4 4/22/2016 FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 19,229,033$ 40,477,963$ 11,608,944$ 4,104,245$ 35.35%12,294,336$ 3,671,291 3,965,881 4,466,822 2,863,143 64.10%2,532,539 1,965,319 1,908,016 2,397,828 1,134,739 47.32%1,355,389 1,860,402 1,869,169 2,337,624 1,294,077 55.36%1,230,269 3,383,463 3,607,800 4,607,923 2,596,046 56.34%2,691,394 2,975,052 3,006,906 3,363,958 1,837,265 54.62%2,088,498 33,084,560$ 54,835,735$ 28,783,099$ 13,829,515$ 48.05%22,192,425$ 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 22,556,953 83.59%20,697,711 13,281,536 119,895,351 1,794,476 1,045,886 58.28%1,189,825 96 172 - - 14 473,683 13,731,430 - - 1,440,315 150,000 1,452,130 - - 652,130 - - - - - 44,184,741$ 165,217,388$ 28,783,099$ 23,606,542$ 82.02%23,983,698$ 9,777,027$ 1,791,273$ Cash Lockbox NCCMT Total 31,388,435$ 3,343,019$ 570,299$ 35,301,753$ 29,859,796$ 3,507,930$ 555,108$ 33,922,833$ 29,009,846$ 3,010,381$ 554,829$ 32,575,057$ 24,228,551$ 3,662,494$ 553,621$ 28,444,666$ 24,058,100$ 3,267,333$ 552,071$ 27,877,505$ 23,345,138$ 3,268,625$ 549,916$ 27,163,678$ 22,373,066$ 3,142,028$ 549,700$ 26,064,794$ 20,802,670$ 3,162,849$ 549,270$ 24,514,789$ 19,413,391$ 3,411,495$ 549,057$ 23,373,942$ 21,051,962$ 2,602,443$ 548,475$ 24,202,879$ 20,248,407$ 2,565,016$ 547,616$ 23,361,038$ 22,900,249$ 2,178,132$ 544,445$ 25,622,825$ 24,744,895$ 1,692,081$ 543,143$ 26,980,119$ 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$ HARNETT COUNTY FINANCIAL SUMMARY REPORT March, 2016 PUBLIC UTILITIES FUND Cash and Investments Debt Service and Transfer Requirements Department Admin/CSR/Meter Services Water Treatment Wastewater Treatment Wastewater Treatment SHWW Distribution Collections Total Revenues: Intergovernmental Revenue Sales & Services Other Revenues Rents, Concess. & Feees Other Finance Sources Interfund Transfers Fund Balance Appropriated Total March, 2015 Revenues over/(under) expenses April, 2015 March, 2016 August, 2015 September, 2015 October, 2015 November, 2015 December, 2015 May, 2015 June, 2015 July, 2015 January, 2016 February, 2016 U:\My Documents\Monthly Reports\2015 - 2016\March 2016 - Financial Statements.xlsx 5 4/22/2016 FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 5,161,897$ 6,827,067$ 6,044,255$ 3,947,685$ 65.31%3,435,631$ 5,161,897$ 6,827,067$ 6,044,255$ 3,947,685$ 65.31%3,435,631$ 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$ 125,820$ 52.64%118,937$ - 25,000 130,000 - 0.00%- 5,006,315 5,165,089 5,111,300 4,608,929 90.17%4,472,112 378,116 499,631 101,650 134,960 132.77%37,808 243 276 - 17,664 119 739,763 1,402,161 - - - - - - - - - - 462,305 - 0.00%- 6,361,734$ 7,326,433$ 6,044,255$ 4,887,373$ 80.86%4,628,976$ 939,688$ 1,193,345$ Cash Sun Trust/BB&T First Bank NCCMT Total 1,322,008$ 533,722$ 501,869$ 185,532$ 2,543,131$ 1,453,177$ 504,847$ 477,173$ 60,920$ 2,496,117$ 1,838,468$ 495,010$ 469,484$ 123,226$ 2,926,188$ 1,157,547$ 482,090$ 451,079$ 123,226$ 2,213,942$ 795,755$ 469,359$ 439,402$ 123,226$ 1,827,742$ 160,831$ 456,391$ 422,540$ 59,824$ 1,099,587$ 182,041$ 425,002$ 394,917$ 59,824$ 1,061,785$ 372,508$ 425,018$ 395,198$ 59,824$ 1,252,548$ 350,504$ 379,409$ 365,494$ -$ 1,095,407$ 575,612$ 375,758$ 368,150$ -$ 1,319,520$ 954,650$ 359,056$ 333,965$ 443,279$ 2,090,950$ 1,166,505$ 343,248$ 333,965$ 387,764$ 2,231,482$ 1,347,614$ 316,331$ 312,432$ 387,764$ 2,364,141$ Current Year Outstanding Interest 127,831$ 335,060$ Principal 510,937 2,700,856 Transfers Out - - 638,767$ 3,035,917$ Fund Balance Appropriated Total Revenues over/(under) expenses April, 2015 March, 2016 September, 2015 October, 2015 November, 2015 March, 2015 June, 2015 May, 2015 January, 2016 December, 2015 HARNETT COUNTY FINANCIAL SUMMARY REPORT March, 2016 SOLID WASTE FUND Cash and Investments Debt Service and Transfer Requirements Department Solid Waste Total Revenues: Taxes Intergovernmental Revenue Sales & Services Other Revenues Rents, Concess. & Feees Other Finance Sources Interfund Transfers February, 2016 August, 2015 July, 2015 U:\My Documents\Monthly Reports\2015 - 2016\March 2016 - Financial Statements.xlsx 6 4/22/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%402,064$ 2,979,815 123,636 1,865,000 889,646 47.70%- 2,979,815$ 152,636$ 1,900,000$ 910,646$ 47.93%402,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$ 694,117$ 39.66%661,228$ 280,523 250,795 150,000 259,423 172.95%106,733$ - - - - 1,985,345$ 2,072,166$ 1,900,000$ 953,540$ 50.19%767,961$ 42,894$ 365,897$ Cash NCCMT Total 1,711,933$ 1,211,772$ 2,923,705$ 1,532,422$ 1,211,772$ 2,744,194$ 1,556,134$ 1,211,772$ 2,767,906$ 1,193,599$ 1,211,772$ 2,405,371$ 1,273,094$ 1,211,772$ 2,484,866$ 1,329,590$ 1,211,772$ 2,541,362$ 1,238,990$ 1,211,772$ 2,450,762$ 1,234,512$ 1,211,772$ 2,446,284$ July, 2015 1,140,351$ 1,211,772$ 2,352,123$ 1,588,872$ 1,234,390$ 2,823,262$ May, 2015 1,273,019$ 562,026$ 1,835,045$ April, 2015 1,248,082$ 562,026$ 1,810,108$ March, 2015 1,114,579$ 562,026$ 1,676,605$ 2,839,689$ 104,756 3,047,026$ HARNETT COUNTY FINANCIAL SUMMARY REPORT March, 2016 WORKER'S COMPENSATION FUND Cash and Investments Liability 312,093 # of Claims this fiscal year 60 Category Fixed Cost Claims Funded Total Actual claim payments Liability as of end of month Revenues: Departmental Charge Other revenues Fund Balance Appropriated Total August, 2015 October, 2015 November, 2015 December, 2015 January, 2016 Revenues over/(under) expenses Liability as of July 1 Current year claims and changes in estimates March, 2016 June, 2015 September, 2015 February, 2016 U:\My Documents\Monthly Reports\2015 - 2016\March 2016 - Financial Statements.xlsx 7 4/22/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$ 88,604$ 34.80%80,841$ 83,514$ 121,440$ 254,588$ 88,604$ 34.80%80,841$ 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$ 177,725$ 69.81%171,025$ - - - - - - - - - - 282,984$ 228,950$ 254,588$ 177,725$ 69.81%171,025$ 89,121$ 90,184$ Cash NCCMT Total 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$ April, 2015 529,175$ 29,241$ 558,416$ March, 2015 520,088$ 29,241$ 549,330$ # of Visits March, 2016 163 February, 2016 159 January, 2016 182 December, 2015 196 # Flu shots November, 2015 132 October, 2015 144 September, 2015 131 August, 2015 98 # Pneumonia shots July, 2015 113 June, 2015 117 May, 2015 124 April, 2015 112 March, 2015 Fund Balance Appropriated HARNETT COUNTY FINANCIAL SUMMARY REPORT March, 2016 EMPLOYEE CLINIC FUND Category Employee Clinic Total Revenues: Departmental Charge Other revenues Total Revenues over/(under) expenses Cash and Investments Employee Clinic Utilization 2 327 Health Prevention U:\My Documents\Monthly Reports\2015 - 2016\March 2016 - Financial Statements.xlsx 8 4/22/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$ 5,500,000$ 4,472,960$ 81.33%3,355,622$ - 655,329 685,000 611,621 89.29%578,867 - 1,507 15,000 7,174 47.83%- -$ 5,862,173$ 6,200,000$ 5,091,755$ 82.13%3,934,489$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year -$ 6,687,178$ 6,200,000$ 4,871,075$ 78.57%5,091,800$ 588,107 10,783 - 24,463 10,783 588,107$ 6,697,961$ 6,200,000$ 4,895,538$ 78.96%5,102,583$ (196,217)$ 1,168,094$ Cash NCCMT Total 1,196,881$ 543,297$ 1,740,178$ 1,354,214$ 543,297$ 1,897,511$ 1,351,919$ 543,297$ 1,895,216$ 1,222,061$ 543,297$ 1,765,358$ 1,387,910$ 543,297$ 1,931,207$ 1,290,451$ 543,297$ 1,833,748$ 1,502,651$ 543,297$ 2,045,949$ 1,387,676$ 543,297$ 1,930,973$ 1,204,970$ 543,297$ 1,748,267$ 1,393,258$ 543,297$ 1,936,555$ 1,272,924$ 543,297$ 1,816,222$ 1,300,653$ 543,297$ 1,843,950$ 1,212,904$ 543,297$ 1,756,201$ 1,154,305$ 543,297$ 1,697,602$ Employees & Pre-65 Retirees Total Membership Net Paid Claims Fixed Cost Loss Ratio Premium Equivalent 800 1,162 320,633.21$ 54,321.22$ 69.90%536,400.67$ 802 1,167 383,357.49$ 56,855.83$ 82.22%535,395.42$ 802 1,169 465,117.51$ 55,311.71$ 96.87%537,247.45$ 808 1,174 650,383.71$ 103,099.20$ 141.27%533,359.40$ 808 1,173 531,699.65$ 59,136.25$ 108.27%545,697.46$ 812 1,177 448,829.22$ 52,614.19$ 92.18%544,006.75$ 820 1,191 418,525.31$ 56,097.08$ 86.93%545,957.33$ 829 1,199 476,696.71$ 57,028.00$ 97.08%549,770.71$ 824 1,192 613,689.61$ 55,057.79$ 122.98%543,783.54$ 812 1,178 4,308,932.42$ 549,521.27$ 99.73%4,871,618.73$ March, 2016 December, 2015 January, 2016 December, 2015 November, 2015 October, 2015 April, 2015 March, 2015 June, 2015 May, 2015 August, 2015 July, 2015 September, 2015 February, 2016 February, 2015 Year to Date (membership = avg) June, 2016 May, 2016 July, 2015 August, 2015 September, 2015 October, 2015 February, 2016 March, 2016 April, 2016 November, 2015 HARNETT COUNTY FINANCIAL SUMMARY REPORT March, 2016 MEDICAL INSURANCE FUND Cash and Investments Medical Paid Claims Summary Category Paid Claims Wellness Total Revenues: Medical Premium Equivilents Other revenues Total Fixed Cost January, 2016 Revenues over/(under) expenses U:\My Documents\Monthly Reports\2015 - 2016\March 2016 - Financial Statements.xlsx 9 4/22/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$ 220,918$ 43.66%178,057$ - 35,323 40,000 27,471 68.68%26,422 -$ 341,907$ 546,000$ 248,389$ 45.49%204,480$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year -$ 544,448$ 546,000$ 270,141$ 49.48%449,660$ - - - - 166,433 -$ 544,448$ 546,000$ 270,141$ 49.48%616,093$ 21,752$ 411,613$ Cash NCCMT Total 255,744$ -$ 255,744$ 262,475$ -$ 262,475$ 255,653$ -$ 255,653$ 257,742$ -$ 257,742$ 251,362$ -$ 251,362$ 242,621$ -$ 242,621$ 249,844$ -$ 249,844$ 249,852$ -$ 249,852$ 248,309$ -$ 248,309$ 247,472$ -$ 247,472$ 246,685$ -$ 246,685$ 246,310$ -$ 246,310$ 245,180$ -$ 245,180$ Total Employees Total Membership Net Paid Claims Fixed Cost Loss Ratio Premium Equivalent 399 653 14,975.40$ 6,090.62$ 70.66%29,813.15$ 398 651 31,428.55$ 3,033.66$ 116.21%29,654.93$ 399 650 28,953.57$ 3,033.66$ 106.13%30,140.02$ 403 654 30,171.44$ 3,033.66$ 114.74%28,939.38$ 400 651 19,987.80$ 3,010.36$ 74.83%30,735.68$ 400 651 20,264.80$ 3,047.64$ 77.38%30,126.24$ 409 661 27,163.98$ 3,056.96$ 102.76%29,408.35$ 412 663 20,728.10$ 3,075.60$ 76.42%31,147.59$ 410 661 29,696.70$ 3,122.20$ 110.76%29,629.84$ 403 655 223,370.34$ 30,504.36$ 94.17%269,595.18$ May, 2016 April, 2015 March, 2015 March, 2016 January, 2016 June, 2015 May, 2015 July, 2015 August, 2015 September, 2015 October, 2015 November, 2015 December, 2015 January, 2016 February, 2016 HARNETT COUNTY FINANCIAL SUMMARY REPORT March, 2016 DENTAL INSURANCE FUND Cash and Investments Category Paid Claims Fixed Cost Total Revenues: Dental Premium Equivilents Other revenues Total Revenues over/(under) expenses Dental Paid Claims Summary July, 2015 August, 2015 September, 2015 October, 2015 November, 2015 December, 2015 Year to Date (membership = avg) February, 2016 March, 2016 June, 2016 April, 2016 U:\My Documents\Monthly Reports\2015 - 2016\March 2016 - Financial Statements.xlsx 10 4/22/2016 FYE 2014 FYE 2015 2015 - 2016 Total Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 118,735,067$ 82,103,070$ 69.15% 118,735,067$ 72,891,417$ 61.39% -$ -$ -$ (9,211,654)$ -$ 26,725,166 15,677,137 58.66% 26,725,166 16,144,991 60.41% -$ -$ -$ 467,854$ -$ 13,763,719 7,948,850 57.75% 13,763,719 7,091,298 51.52% -$ -$ -$ (857,552)$ -$ 4,194,181 296,835 7.08% 5,194,181 25,364 0.49% -$ -$ 1,000,000$ (271,471)$ -$ 11,026,600 7,271,716 65.95% 11,026,600 7,132,398 64.68% -$ -$ -$ (139,318)$ -$ 536,488 253,558 47.26% 536,488 266,485 49.67% -$ -$ -$ 12,927$ -$ 8,070,125 2,844,952 35.25% 8,070,125 3,554,161 44.04% -$ -$ -$ 709,209$ -$ - - 183,051,346 116,396,117 63.59%- - - 184,051,346 107,106,113 58.19%- -$ -$ 1,000,000$ (9,290,004)$ -$ State Fund HARNETT COUNTY FINANCIAL SUMMARY REPORT March, 2016 Board of Education Fund Group: Capital Outlay Fund Expenditures Revenues Expenditures Revenues Local Current Expense Fund Expenditures Revenues Federal Grant Fund Expenditures Revenues Child Nutrition Fund Expenditures Revenues Expenditures Revenues Dunn District Fund Expenditures Revenues Local Restricted Fund Expenditures Revenues Total All Funds U:\My Documents\Monthly Reports\2015 - 2016\March 2016 - Financial Statements.xlsx 11