No preview available
HomeMy WebLinkAboutApril 2016 - Financial Statements5/26/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 $ 252,795 91.21% $ 94,204 250,759 280,372 263,472 397,880 151.01% 190,009 103,351 8,609 69,617 162,732 233.75% (33,954) 1 - - - 45,648 254,738 247,154 238,649 239,008 100.15% 176,733 303,532 305,481 442,442 298,600 67.49% 264,333 729,469 833,532 842,115 870,242 103.34% 573,431 77,704 79,320 411,771 71,673 17.41% 67,847 1,569,231 1,588,997 1,802,759 1,234,330 68.47% 1,160,262 140,485 153,360 161,852 118,123 72.98% 124,437 438,847 603,102 579,622 418,056 72.13%467,377 1,004,266 839,486 1,861,552 1,051,646 56.49% 625,740 194,790 209,741 219,108 115,646 52.78% 169,686 3,400,887 3,736,788 3,738,493 2,734,930 73.16% 2,477,522 730,166 695,654 790,642 582,580 73.68% 558,287 1,301,628 1,726,510 1,917,855 1,599,486 83.40% 1,424,465 432,327 436,602 615,987 506,937 82.30% 343,473 10,166,283 10,205,366 10,202,842 7,411,661 72.64% 8,052,986 354,232 389,674 480,900 349,116 72.60% 317,630 80,119 - - - - 15,213 1,607 46,161 23,765 51.48% 1,607 66,257 70,126 76,867 52,599 68.43% 56,537 26,536 - - - - 1,219,142 1,389,574 1,722,028 1,308,896 76.01% 1,115,462 School Resource Officers - - 691,067 535,105 77.43% - 4,306,490 4,407,161 4,792,299 3,441,870 71.82% 3,510,990 737,021 765,164 881,381 529,294 60.05% 577,329 32,000 - 60,000 - - 3,991,897 4,080,768 4,340,552 3,263,207 75.18% 3,088,306 1,083,318 1,144,801 1,183,589 918,369 77.59% 829,996 3,314,704 3,361,704 3,361,704 3,081,563 91.67% 2,801,421 376,744 431,707 498,413 321,310 64.47% 323,085 50,000 47,050 65,000 56,000 86.15% 38,600 - 4,516 7,160 4,910 68.58%2,390 124,334 79,180 71,168 58,442 82.12% 66,714 240,521 236,688 - - 196,094 300,204 246,495 285,000 131,414 46.11% 174,873 174,955 208,990 209,736 133,649 63.72% 129,797 124,133 161,801 183,879 136,729 74.36% 126,034 4,000 4,000 4,000 4,000 100.00% 4,000 114,849 112,289 111,511 80,444 72.14% 76,455 449,748 458,253 576,000 365,849 63.52% 334,833 776,301 1,382,346 674,272 399,034 59.18% 757,433 1,321,571 1,362,552 1,365,164 1,036,631 75.93% 1,013,371 1,129 735 300 52 17.33% 309 31,903 57,241 36,298 27,506 75.78% 40,506 351,557 289,118 389,857 225,564 57.86% 200,368 31,419 25,623 22,443 14,878 66.29% 22,810 2,483 379 600 104 17.33% 341 158,263 44,813 59,354 37,846 63.76% 32,455 59,107 60,321 70,608 60,474 85.65% 50,466 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 Finance Clerk of Court Information Technology GIS Sheriff Tax General Services Fleet Maintenance Transportation Transportation - Admin Engineering HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 2016 GENERAL FUND CCR&R - United Way Emergency Medical Service Human Resources Board of Elections Planning & Inspections Community Development (BG) Abandoned MFG Home Cooperative Extension CCR&R - Block Grant Soil & Water Department Governing Body Administration Campbell Deputies Legal Services Environmental Protection Forestry Program Economic/Physical Dev. App. Industrial Development JCPC Admin Public Safety Appropriations Emergency Telephone System Radio System Harnett Regional Jetport Facilities Maintenance Register of Deeds U:\My Documents\Monthly Reports\2015 - 2016\April 2016 - Financial Statements.xlsx 1 5/26/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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 33,472 63.57% 37,159 27,367 50,723 - - - 13,570 - 11,107 3,492 31.44% 13,924 3,789 14,200 - - - - - 32,695 16,370 50.07% - 283,332 307,602 317,411 239,841 75.56% 235,319 51,769 64,108 64,510 48,055 74.49% 50,328 73,276 77,658 77,858 60,100 77.19% 61,607 326,783 328,753 378,328 253,997 67.14% 266,398 378,087 414,989 437,517 335,767 76.74% 314,364 5,787,018 6,014,268 7,285,137 4,762,204 65.37% 4,711,069 815,679 605,679 605,679 605,679 100.00% 605,679 9,359,396 10,155,398 10,585,495 8,167,955 77.16% 7,762,157 7,829,453 7,905,017 10,338,010 7,422,377 71.80% 6,376,631 172,197 178,634 185,461 143,422 77.33% 143,392 110,369 100,304 118,965 80,462 67.64% 80,655 99,840 90,780 145,000 129,039 88.99% 75,298 928,107 941,972 1,001,229 699,137 69.83% 752,543 100,000 150,000 153,000 3,000 1.96% - 363,011 403,871 455,928 334,910 73.46% 299,583 20,523,700 21,523,700 21,267,993 17,723,328 83.33% 17,936,417 - - 280,707 192,260 68.49%- 927,711 928,467 993,967 824,056 82.91%764,556 - - - - - 25,000 25,000 25,000 - 25,000 - - 70,000 - - $ 89,428,385 $ 93,213,943 $ 101,586,892 $ 76,743,868 75.55% $ 73,184,777 1,903,876 64,701 283,334 43,334 15.29% 26,667 13,902,144 44,265,436 21,922,023 19,399,388 88.49% 15,110,901 - - 489,926 - $ 15,806,020 $ 44,330,137 $ 22,695,283 $ 19,442,722 85.67% $ 15,137,568 105,234,405$ 137,544,080$ 124,282,175$ 96,186,590$ 77.39%88,322,345$ 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 Department Central Carolina - DOT Cultural & Recreational App. Parks & Recreation Education Special Programs Subtotal - Operating Expenditures Subtotal Other Financing Uses: U:\My Documents\Monthly Reports\2015 - 2016\April 2016 - Financial Statements.xlsx 2 5/26/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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$ 53,650,121$ 98.62%53,243,348$ 3,949,979 5,712,141 5,654,182 3,910,377 69.16%4,189,353 14,884,497 16,757,810 16,154,459 9,483,048 58.70%10,332,715 1,037,719 1,053,493 1,200,000 832,195 69.35%678,760 2,763,205 2,515,489 3,723,930 2,360,072 63.38%2,015,983 19,304,274 18,884,854 19,820,211 12,866,654 64.92%11,970,721 7,658,151 7,838,973 8,844,120 7,458,817 84.34%5,392,636 3,451,519 3,741,739 3,551,821 2,063,917 58.11%2,534,826 77,898 77,652 78,779 75,820 96.24%52,728 107,248,064 110,512,858 113,430,136 92,701,021 81.73%90,411,070 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,408,383 - - 1,318,495 29,431,353 10,852,039 5,945,501 54.79%3,896 108,566,559$ 139,944,211$ 124,282,175$ 98,646,522$ 79.37%90,414,966$ 2,400,131$ 2,459,932$ 2,092,621 Real and Personal Motor Vehicles Sales Tax Other taxes Revenues: Other Finance Sources Interfund Transfers Fund Balance Appropriated Total Revenues Permits & Fees Intergovernmental Revenue Sales & Services Other Revenues Rents, Concessions. & Fees Ad Valorem Taxes Subtotal - Operating Revenues Subtotal Other Financing Sources: Revenues over / (under) expenditures U:\My Documents\Monthly Reports\2015 - 2016\April 2016 - Financial Statements.xlsx 3 5/26/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 2016 GENERAL FUND Cash Tax Lockbox MBS NCCMT Total -$ -$ 5,910,697$ 28,256,262$ 34,166,959$ 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$ Current YearOutstanding Interest 4,627,480$ 44,149,422$ Principal9,760,978 121,114,540 Transfers Out - - 14,388,459$ 165,263,961$ Estimated Fund Balance October, 2015 September, 2015 December, 2015 November, 2015 January, 2016 Cash and Investments April, 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 March, 2016 February, 2016 Unassigned Fund Balance - In the governmental fund financial statements, fund balance is composed of five classifications designed to disclose the hierarchy of Non-Spendable Fund Balance - This classification includes amounts that cannot be spent because they are either (a) not in spendable Restricted Fund Balance - The classification includes amount that are restricted to specific purposes externally imposed by creditors Assigned Fund Balance - That portion of fund balance that the County intends to use for specific purposes. The County Debt Service and Transfer Requirements June, 2015 U:\My Documents\Monthly Reports\2015 - 2016\April 2016 - Financial Statements.xlsx 4 5/26/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 2016 GENERAL FUND Unassigned Fund Balance at June 30, 2015 19,417,388$ 17.89% Unaudited 06/30/2014 Revenues over/(under) Expenditures Year to Date Revenues over/(under) Expenditures 2,459,932 21,877,320 Remaining Debt Payments for this Year (2,522,635) Outstanding budget amendments - Year to Date Fund Balance Appropriated (4,408,383) (6,931,018) 14,946,302$ 12.03% Amount by which fund balance percentage will change 1,242,822$ The Harnett County Board of Commissioners have approved a fund balance policy which strives to maintain a minimum fund balance of 15%. 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. U:\My Documents\Monthly Reports\2015 - 2016\April 2016 - Financial Statements.xlsx 5 5/26/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$ 30,201,337$ 7,713,054$ 2,718,980$ 35.25%6,766,921$ 3,671,291 3,965,881 4,466,822 3,196,257 71.56%2,825,611 1,965,319 1,908,016 2,397,828 1,314,412 54.82%1,452,727 1,860,402 1,869,169 2,337,624 1,484,754 63.52%1,388,664 3,383,463 3,607,800 4,607,923 2,945,643 63.93%2,918,423 2,975,052 3,006,906 3,363,958 2,007,148 59.67%2,302,654 21,398,655$ 44,559,109$ 24,887,209$ 13,667,194$ 54.92%17,655,000$ 400,000 - - - 8,150,882 Depreciation 6,122,500 6,395,389 - - - 5,163,405 3,881,237 3,895,890 3,364,021 86.35%3,732,154 11,685,905$ 10,276,626$ 3,895,890$ 3,364,021$ 86.35%11,883,036$ 33,084,560$ 54,835,735$ 28,783,099$ 17,031,215$ 59.17%29,538,036$ 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 25,168,312 93.27%23,163,565 13,281,536 2,023,403 1,794,476 1,062,249 59.20%2,368,537 96 172 - - 14 43,561,058$ 32,161,880$ 28,783,099$ 26,234,264$ 91.14%25,535,819$ 473,683 13,731,430 - - 1,440,312 150,000 1,452,130 - - 652,130 - - - - - 623,683$ 15,183,560$ -$ -$ 2,092,442$ 44,184,741$ 47,345,440$ 28,783,099$ 26,234,264$ 91.14%27,628,261$ 9,203,049$ (1,909,775)$ HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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 Interfund Transfers Fund Balance Appropriated Total Revenues Subtotal Other Financing Sources: Subtotal - Operating Expenditures Interfund Transfers Debt Service Subtotal Other Financing Uses: Subtotal - Operating Revenues Total Expenditures Revenues: Intergovernmental Revenue Sales & Services Other Revenues U:\My Documents\Monthly Reports\2015 - 2016\April 2016 - Financial Statements.xlsx 6 5/26/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 2016 PUBLIC UTILITIES FUND Cash Lockbox NCCMT Total 30,683,192$ 3,316,449$ 577,919$ 34,577,560$ 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$ 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 March, 2016 April, 2015 April, 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\April 2016 - Financial Statements.xlsx 7 5/26/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$ 3,795,286$ 69.04%3,324,103$ 4,407,605$ 4,555,419$ 5,497,002$ 3,795,286$ 69.04%3,324,103$ - 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,289,278$ 70.96%3,805,420$ 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 - - 5,006,315 5,165,089 5,111,300 4,766,721 93.26%4,687,180 378,116 499,631 101,650 136,633 134.42%263,563 243 276 - 17,766 119 5,621,971$ 5,924,272$ 5,581,950$ 5,046,940$ 90.42%5,069,799$ 739,763 1,402,161 - - - - - - - - - - 462,305 - - 739,763$ 1,402,161$ 462,305$ -$ -$ 6,361,734$ 7,326,433$ 6,044,255$ 5,046,940$ 83.50%5,069,799$ 757,662$ 1,264,379$ Fund Balance Appropriated Total Revenues HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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 Revenues: Taxes Intergovernmental Revenue Sales & Services Other Revenues Rents, Concess. & Feees Other Finance Sources Subtotal - Operating Revenues U:\My Documents\Monthly Reports\2015 - 2016\April 2016 - Financial Statements.xlsx 8 5/26/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 2016 SOLID WASTE FUND Cash Sun Trust/BB&T First Bank NCCMT Total 1,106,636$ 555,533$ 517,182$ 185,532$ 2,364,882$ 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$ Current Year Outstanding Interest 127,831$ 335,060$ Principal 510,937 2,700,856 Transfers Out - - 638,767$ 3,035,917$ April, 2015 April, 2016 September, 2015 October, 2015 November, 2015 June, 2015 May, 2015 January, 2016 December, 2015 Cash and Investments March, 2016 Debt Service and Transfer Requirements February, 2016 August, 2015 July, 2015 U:\My Documents\Monthly Reports\2015 - 2016\April 2016 - Financial Statements.xlsx 9 5/26/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 1,039,646 55.75%- 2,979,815$ 152,636$ 1,900,000$ 1,060,646$ 55.82%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$ 775,737$ 44.33%737,307$ 280,523 250,795 150,000 259,423 172.95%164,157$ - - - - 1,985,345$ 2,072,166$ 1,900,000$ 1,035,160$ 54.48%901,464$ (25,486)$ 499,400$ Cash NCCMT Total 1,643,553$ 1,211,772$ 2,855,325$ 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$ 2,839,689$ 115,438 3,063,226$ HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 2016 WORKER'S COMPENSATION FUND Cash and Investments Liability 338,975 # of Claims this fiscal year 67 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 April, 2016 June, 2015 September, 2015 February, 2016 March, 2016 U:\My Documents\Monthly Reports\2015 - 2016\April 2016 - Financial Statements.xlsx 10 5/26/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$ 100,247$ 39.38%95,363$ 83,514$ 121,440$ 254,588$ 100,247$ 39.38%95,363$ 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$ 197,800$ 77.69%190,250$ - - - - - - - - - - 282,984$ 228,950$ 254,588$ 197,800$ 77.69%190,250$ 97,553$ 94,887$ Cash NCCMT Total 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$ April, 2015 529,175$ 29,241$ 558,416$ # of Visits April, 2016 148 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 April, 2015 112 Fund Balance Appropriated HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 2016 EMPLOYEE CLINIC FUND Department Employee Clinic Total Revenues: Departmental Charge Other revenues Total Revenues over/(under) expenses Cash and Investments Employee Clinic Utilization 2 327 Health Prevention # Flu shots # Pneumonia shots U:\My Documents\Monthly Reports\2015 - 2016\April 2016 - Financial Statements.xlsx 11 5/26/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,395,000$ 5,241,279$ 97.15%3,740,393$ - 655,329 790,000 621,281 78.64%632,507 - 1,507 15,000 7,174 47.83%13,000 -$ 5,862,173$ 6,200,000$ 5,869,734$ 94.67%4,385,900$ 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$ 5,415,996$ 87.35%5,618,131$ 588,107 10,783 - 24,994 10,783 588,107$ 6,697,961$ 6,200,000$ 5,440,990$ 87.76%5,628,914$ (428,744)$ 1,243,014$ Cash NCCMT Total 964,355$ 543,297$ 1,507,653$ 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$ 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$ 819 1,190 846,544.07$ 59,316.96$ 166.24%544,921.50$ 812 1,179 5,155,476.49$ 608,838.23$ 106.42%5,416,540.23$ April, 2016 December, 2015 January, 2016 December, 2015 November, 2015 October, 2015 April, 2015 June, 2015 May, 2015 August, 2015 July, 2015 September, 2015 February, 2016 March, 2016 May, 2016 July, 2015 August, 2015 September, 2015 October, 2015 February, 2016 March, 2016 April, 2016 November, 2015 Year to Date (membership = avg) June, 2016 HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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\April 2016 - Financial Statements.xlsx 12 5/26/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$ 244,376$ 48.30%205,821$ - 35,323 40,000 30,504 76.26%29,353 -$ 341,907$ 546,000$ 274,880$ 50.34%235,174$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year -$ 544,448$ 546,000$ 300,511$ 55.04%481,484$ - - - - 166,433 -$ 544,448$ 546,000$ 300,511$ 55.04%647,917$ 25,631$ 412,743$ Cash NCCMT Total 259,621$ -$ 259,621$ 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$ 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$ 408 659 31,526.79$ 3,033.66$ 115.55%29,909.42$ 404 655 254,897.13$ 33,538.02$ 96.30%299,504.60$ May, 2016 April, 2015 April, 2016 January, 2016 June, 2015 May, 2015 July, 2015 August, 2015 September, 2015 October, 2015 November, 2015 December, 2015 January, 2016 February, 2016 March, 2016 HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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\April 2016 - Financial Statements.xlsx 13 5/26/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)$ -$ * Latest available numbers from the Board of Educations web site. ADM MLD ADM Change MLD Change 20,405 20,543 20,387 20,495 (18)(48) 20,505 20,504 118 9 20,468 20,465 (37)(39) 20,360 20,332 (108)(133) Month 8 Month 9 Month 7 Public School Membership Month 1 Month 2 Month 3 Month 4 State Fund HARNETT COUNTY FINANCIAL SUMMARY REPORT March, 2016 * Board of Education Fund Group: Expenditures Revenues Federal Grant Fund Expenditures Revenues Expenditures Revenues Local Current Expense Fund Total All Funds Month 5 Month 6 Capital Outlay Fund Expenditures Revenues Month 1 Revised Fiscal Year 2015-2016 Initial Allotment 20,725 Child Nutrition Fund Expenditures Revenues Expenditures Revenues Dunn District Fund Expenditures Revenues Local Restricted Fund Expenditures Revenues U:\My Documents\Monthly Reports\2015 - 2016\April 2016 - Financial Statements.xlsx 14