No preview available
HomeMy WebLinkAboutJune 2016 - Financial Statements1/26/2017 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 $ 279,338 $ 208,357 74.59% $ 158,070 250,759 280,372 302,009 294,293 97.45% 280,372 103,351 8,609 70,785 53,919 76.17% 8,609 1 - - - - 254,738 247,154 238,649 205,162 85.97% 247,154 303,532 305,481 442,442 381,191 86.16% 305,481 729,469 833,532 834,115 811,001 97.23% 833,532 - - - - - 77,704 79,320 411,771 81,438 19.78% 79,320 1,569,231 1,588,997 1,802,759 1,709,486 94.83% 1,588,997 140,485 153,360 161,852 158,173 97.73% 153,360 438,847 603,102 579,970 543,249 93.67%603,102 1,004,266 839,486 1,875,632 1,523,150 81.21% 839,486 194,790 209,741 219,108 194,529 88.78% 209,741 3,400,887 3,736,788 3,748,961 3,667,427 97.83% 3,736,788 730,166 695,654 792,668 759,735 95.85% 695,654 1,301,628 1,726,510 1,917,855 1,787,734 93.22% 1,726,510 432,327 436,602 615,987 581,109 94.34% 436,602 10,166,283 10,205,366 10,203,342 9,677,549 94.85% 10,205,366 354,232 389,674 480,900 442,623 92.04% 389,674 80,119 - - - - 15,213 1,607 46,161 26,924 58.33% 1,607 66,257 70,126 76,867 66,653 86.71% 70,126 26,536 - - - - 1,219,142 1,389,574 1,701,528 1,624,091 95.45% 1,389,574 School Resource Officers - - 691,067 682,489 98.76% - 4,306,490 4,407,161 4,812,299 4,551,465 94.58% 4,407,161 737,021 765,164 822,851 730,739 88.81% 765,164 32,000 - 60,000 - - 3,991,897 4,080,768 4,530,066 4,414,723 97.45% 4,080,768 1,083,318 1,144,801 1,205,115 1,151,492 95.55% 1,144,801 3,314,704 3,361,704 3,361,704 3,361,704 100.00% 3,361,704 376,744 431,707 498,413 438,575 87.99% 431,707 50,000 47,050 95,000 89,900 94.63% 47,050 - 4,516 7,160 6,886 96.17%4,516 124,334 79,180 74,168 71,908 96.95% 79,180 240,521 236,688 - - 236,688 300,204 246,495 - - 246,495 174,955 208,990 209,736 198,422 94.61% 208,990 124,133 161,801 192,983 178,736 92.62% 161,801 4,000 4,000 4,000 4,000 100.00% 4,000 114,849 112,289 111,511 101,648 91.16% 112,289 449,748 458,253 576,000 509,983 88.54% 458,253 776,301 1,382,346 674,742 436,558 64.70% 1,382,346 1,321,571 1,362,552 1,365,164 1,309,860 95.95% 1,362,552 1,129 735 300 192 64.00% 735 31,903 57,241 36,425 32,171 88.32% 57,241 351,557 289,118 387,645 314,013 81.01% 289,118 31,419 25,623 25,566 24,494 95.81% 25,623 2,483 379 600 150 25.00% 379 158,263 44,813 59,354 59,354 100.00% 44,813 59,107 60,321 77,681 76,776 98.83% 60,321 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 June, 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\June 2016 - Financial Statements.xlsx 1 1/26/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 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 - 76,070 72,035 94.70% 50,723 27,367 50,723 - - - 13,570 - 11,107 4,034 36.32% 14,200 3,789 14,200 - - - - - 32,695 30,035 91.86% - 283,332 307,602 318,310 315,244 99.04% 307,602 51,769 64,108 64,852 61,164 94.31% 64,108 73,276 77,658 78,290 77,511 99.00% 77,658 326,783 328,753 378,328 329,421 87.07% 328,753 378,087 414,989 437,920 432,337 98.73% 414,989 5,787,018 6,014,268 7,345,575 6,082,878 82.81% 6,014,268 815,679 605,679 605,679 605,679 100.00% 605,679 9,359,396 10,155,398 10,585,378 10,324,942 97.54% 10,155,398 7,829,453 7,905,017 10,182,077 9,351,002 91.84% 7,905,017 172,197 178,634 186,596 180,399 96.68% 178,634 110,369 100,304 119,908 103,322 86.17% 100,304 99,840 90,780 145,000 136,805 94.35% 90,780 928,107 941,972 1,001,979 910,122 90.83% 941,972 100,000 150,000 153,000 153,000 100.00% 150,000 363,011 403,871 455,928 435,005 95.41% 403,871 20,523,700 21,523,700 21,267,993 21,267,993 100.00% 21,523,700 - - 280,707 280,707 100.00%- 927,711 928,467 993,967 993,967 100.00%928,467 - - - - - 25,000 25,000 25,000 - 25,000 - - 70,000 70,000 100.00%- $ 89,428,385 $ 93,213,943 $ 101,498,608 $ 95,761,633 94.35% $ 93,213,943 1,903,876 64,701 2,145,446 2,145,446 100.00% 64,701 13,902,144 44,265,436 53,002,023 52,688,961 99.41% 44,265,436 - - 292,614 - $ 15,806,020 $ 44,330,137 $ 55,440,083 $ 54,834,407 98.91% $ 44,330,137 105,234,405$ 137,544,080$ 156,938,691$ 150,596,040$ 95.96%137,544,080$ Central Carolina - DOT 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 U:\My Documents\Monthly Reports\2015 - 2016\June 2016 - Financial Statements.xlsx 2 1/26/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 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$ 55,082,717$ 101.25%53,930,707$ 3,949,979 5,712,141 5,654,182 6,190,412 109.48%5,712,141 14,884,497 16,757,810 17,493,780 19,279,813 110.21%16,757,810 1,037,719 1,053,493 1,200,000 1,220,493 101.71%1,053,493 2,763,205 2,515,489 3,363,930 2,965,577 88.16%2,515,489 19,304,274 18,884,854 19,702,847 20,274,012 102.90%18,884,854 7,658,151 7,838,973 9,473,421 9,204,896 97.17%7,818,258 3,451,519 3,741,739 3,559,359 3,343,042 93.92%3,737,358 75,787 69,215 73,779 73,655 99.83%69,215 107,245,953 110,504,421 114,923,932 117,634,617 102.36%110,479,325 2,111 8,437 5,000 97,339 1946.78%8,437 857,548 29,108,938 37,468,000 37,018,000 98.80%29,108,938 460,947 322,415 55,656 7,501 13.48%322,415 - - 4,486,103 - - 1,320,606 29,439,790 42,014,759 37,122,840 88.36%29,439,790 108,566,559$ 139,944,211$ 156,938,691$ 154,757,457$ 98.61%139,919,115$ 2,400,131$ 4,161,417$ 2,375,035 Investment Earnings Subtotal - Operating Revenues Subtotal Other Financing Sources: Revenues over / (under) expenditures 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 U:\My Documents\Monthly Reports\2015 - 2016\June 2016 - Financial Statements.xlsx 3 1/26/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 2016 GENERAL FUND Cash Tax Lockbox MBS NCCMT Total 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$ 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$ 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\June 2016 - Financial Statements.xlsx 4 1/26/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 2016 GENERAL FUND Unassigned Fund Balance at June 30, 2015 19,417,388$ 17.89% Year to Date Revenues over/(under) Expenditures 4,161,417 23,578,805 Remaining Debt Payments for this Year (313,062) Outstanding budget amendments - Year to Date Fund Balance Appropriated (4,486,103) (4,799,165) 18,779,640$ 11.97% Amount by which fund balance percentage will change 1,569,387$ 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\June 2016 - Financial Statements.xlsx 5 1/26/2017 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$ 7,911,446$ 3,452,612$ 43.64%6,369,115$ 3,671,291 3,965,881 4,665,322 4,376,387 93.81%3,965,881 1,965,319 1,908,016 2,407,328 2,005,668 83.32%1,908,016 1,860,402 1,869,169 2,322,624 1,993,304 85.82%1,869,169 3,383,463 3,607,800 4,610,293 3,634,241 78.83%3,607,800 2,975,052 3,006,906 3,168,958 2,742,752 86.55%3,006,906 21,398,655$ 20,726,888$ 25,085,971$ 18,204,964$ 72.57%20,726,887$ 400,000 22,607,192 - - 22,607,193 Depreciation 6,122,500 6,395,389 - 9,327,622 6,395,389 5,163,405 5,106,266 5,274,311 1,070,704 20.30%5,106,266 11,685,905$ 34,108,847$ 5,274,311$ 10,398,325$ 197.15%34,108,848$ 33,084,560$ 54,835,735$ 30,360,282$ 28,603,289$ 94.21%54,835,735$ 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 28,559,733 32,563,219 114.02%30,134,602 13,281,536 2,023,403 1,796,846 3,704,119 206.15%2,023,404 96 172 - 2,105 172 43,561,058$ 32,161,880$ 30,360,282$ 36,273,146$ 119.48%32,161,881$ 473,683 13,731,430 - 320,484 13,731,430 150,000 1,452,130 - 450,000 1,452,130 - - - - - 623,683$ 15,183,560$ -$ 770,484$ 15,183,560$ 44,184,741$ 47,345,440$ 30,360,282$ 37,043,630$ 122.01%47,345,441$ 8,440,341$ (7,490,294)$ Subtotal - Operating Expenditures Interfund Transfers HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 2016 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 Debt Service Subtotal Other Financing Uses: Subtotal - Operating Revenues Total Expenditures Revenues: Intergovernmental Revenue Sales & Services Other Revenues Interfund Transfers Fund Balance Appropriated Total Revenues Subtotal Other Financing Sources: U:\My Documents\Monthly Reports\2015 - 2016\June 2016 - Financial Statements.xlsx 6 1/26/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 2016 PUBLIC UTILITIES FUND Cash Lockbox NCCMT Total 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$ 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$ 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\June 2016 - Financial Statements.xlsx 7 1/26/2017 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,577,002$ 4,207,775$ 75.45%6,297,319$ 4,407,605$ 4,555,419$ 5,577,002$ 4,207,775$ 75.45%6,297,319$ - 1,396,177 - - - - - - - - Depreciation 289,683 345,724 - 445,290 - 464,609 529,747 547,253 88,150 16.11%529,748 754,292$ 2,271,648$ 547,253$ 533,439$ 97.48%529,748$ 5,161,897$ 6,827,067$ 6,124,255$ 4,741,214$ 77.42%6,827,067$ 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$ 268,129$ 112.19%234,276$ - 25,000 163,790 133,790 81.68%25,000 5,006,315 5,165,089 5,157,510 5,313,693 103.03%5,153,491 378,116 499,631 101,650 139,437 137.17%2,081 243 276 - 1,291 276 5,621,971$ 5,924,272$ 5,661,950$ 5,856,340$ 103.43%5,415,124$ 739,763 1,402,161 - 917 1,402,161 - - - - - - - 462,305 - - 739,763$ 1,402,161$ 462,305$ 917$ 0.20%1,402,161$ 6,361,734$ 7,326,433$ 6,124,255$ 5,857,257$ 95.64%6,817,285$ 1,116,043$ (9,782)$ Rents, Concess. & Feees Other Finance Sources Subtotal - Operating Revenues Revenues: Taxes Intergovernmental Revenue Sales & Services Other Revenues HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 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\June 2016 - Financial Statements.xlsx 8 1/26/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 2016 SOLID WASTE FUND Cash BB&T First Bank NCCMT Total 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$ 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$ 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\June 2016 - Financial Statements.xlsx 9 1/26/2017 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%29,000$ 2,979,815 123,636 2,046,483 1,243,316 60.75%123,636 2,979,815$ 152,636$ 2,081,483$ 1,264,316$ 60.74%152,636$ 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$ 1,711,483$ 97.80%1,821,371$ 280,523 250,795 331,483 441,714 133.25%250,795$ - - - - - 1,985,345$ 2,072,166$ 2,081,483$ 2,153,197$ 103.45%2,072,166$ 888,881$ 1,919,530$ Cash NCCMT Total 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$ 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$ 2,839,689$ 134,020 3,094,894$ changes in estimates Departmental Charge Other revenues Fund Balance Appropriated Total HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 2016 WORKER'S COMPENSATION FUND Cash and Investments Category Fixed Cost Claims Funded Total Revenues: Revenues over/(under) expenses Liability 389,225 # of Claims this fiscal year 74 Actual claim payments Liability as of end of month Liability as of July 1 Current year claims and $1,000,000 $2,000,000 $3,000,000 Cash Flow U:\My Documents\Monthly Reports\2015 - 2016\June 2016 - Financial Statements.xlsx 10 1/26/2017 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$ 140,835$ 55.32%121,440$ 83,514$ 121,440$ 254,588$ 140,835$ 55.32%121,440$ 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$ 242,612$ 95.30%228,950$ - - - - - - - - - - 282,984$ 228,950$ 254,588$ 242,612$ 95.30%228,950$ 101,777$ 107,510$ Cash NCCMT Total 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$ 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$ Total Revenues over/(under) expenses Cash and Investments Fund Balance Appropriated HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 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\June 2016 - Financial Statements.xlsx 11 1/26/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 2016 EMPLOYEE CLINIC FUND # of Visits June 2016 162 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 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\June 2016 - Financial Statements.xlsx 12 1/26/2017 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$ 7,195,000$ 6,818,253$ 94.76%4,692,837$ - 655,329 815,527 634,709 77.83%655,329 - 1,507 15,000 8,355 55.70%1,507 -$ 5,862,173$ 8,025,527$ 7,461,317$ 92.97%5,349,673$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year -$ 6,687,178$ 8,000,000$ 7,892,453$ 98.66%6,687,178$ 588,107 10,783 25,527 26,178 102.55%10,783 588,107$ 6,697,961$ 8,025,527$ 7,918,631$ 98.67%6,697,961$ 457,314$ 1,348,288$ Cash NCCMT Total 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$ 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$ HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 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\June 2016 - Financial Statements.xlsx 13 1/26/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 2016 MEDICAL INSURANCE FUND Employees & Pre-65 Retirees Total MembershipNet Paid ClaimsFixed 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 826 1,201 749,785.30$ (48,146.18)$ 112.65%622,838.33$ 814 1,183 6,549,720.76$ 579,457.61$ 108.25%6,585,596.25$ 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\June 2016 - Financial Statements.xlsx 14 1/26/2017 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$ 295,849$ 58.47%306,584$ - 35,323 40,000 36,698 91.75%35,323 -$ 341,907$ 546,000$ 332,547$ 60.91%341,907$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year -$ 544,448$ 546,000$ 369,211$ 67.62%544,448$ - - - - - -$ 544,448$ 546,000$ 369,211$ 67.62%544,448$ 36,664$ 202,541$ Cash NCCMT Total 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$ 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$ HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 2016 DENTAL INSURANCE FUND Cash and Investments Category Paid Claims Fixed Cost Total Revenues: Dental Premium Equivilents Other revenues Total Revenues over/(under) expenses $225,000 $250,000 $275,000 Cash Flow U:\My Documents\Monthly Reports\2015 - 2016\June 2016 - Financial Statements.xlsx 15 1/26/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 2016 DENTAL INSURANCE FUND Total Employees Total MembershipNet Paid ClaimsFixed 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 419 671 28,488.90$ 6,202.76$ 90.84%38,188.97$ 406 658 305,448.23$ 42,825.70$ 94.78%367,454.55$ 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\June 2016 - Financial Statements.xlsx 16 1/26/2017 FYE 2014 FYE 2015 2015 - 2016 Total Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 118,259,682$ 115,268,881$ 97.47% 118,259,682$ 115,268,881$ 97.47% -$ -$ -$ -$ -$ 26,747,948 22,838,609 85.38% 26,747,948 21,557,719 80.60% -$ -$ -$ (1,280,890)$ -$ 14,078,347 11,365,474 80.73% 14,078,347 11,365,474 80.73% -$ -$ -$ -$ -$ 3,537,278 3,165,403 89.49% 3,537,278 2,844,295 80.41% -$ -$ -$ (321,108)$ -$ 11,273,007 10,013,377 88.83% 11,273,007 10,608,154 94.10% -$ -$ -$ 594,777$ -$ 552,153 304,258 55.10% 552,153 299,648 54.27% -$ -$ -$ (4,609)$ -$ 8,989,216 4,720,189 52.51% 8,989,216 5,253,011 58.44% -$ -$ -$ 532,822$ -$ - - 183,437,630 167,676,190 91.41%- - - 183,437,630 167,197,181 91.15%- -$ -$ -$ (479,009)$ -$ * 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 June, 2016 * BOARD OF EDUCATION Fund Group: U:\My Documents\Monthly Reports\2015 - 2016\June 2016 - Financial Statements.xlsx 17 1/26/2017HARNETT COUNTY FINANCIAL SUMMARY REPORT June, 2016 * BOARD OF EDUCATION Capital Outlay Total 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 -$ December 2015 -$ November 2015 -$ October 2015 -$ September 2015 -$ August 2015 -$ July 2015 -$ June 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 20,097 20,121 (45)(27) Month 9 Final Public School Membership Fiscal Year 2015-2016 Initial Allotment 20,725 Cash and Investments Local Currrent Expense $5,000,000 $7,000,000 $9,000,000 $11,000,000 Cash Flow 20,000 20,250 20,500 20,75021,000 Harnett County School Membership ADM MLD U:\My Documents\Monthly Reports\2015 - 2016\June 2016 - Financial Statements.xlsx 18