Loading...
HomeMy WebLinkAboutSingle Audit of Federal Financial Assistance Programs for Fiscal Year 2014 - 2015 COUNTY OF HAWAIÒI STATE OF HAWAIÒI SINGLE AUDIT OF FEDERAL FINANCIAL ASSISTANCE PROGRAMS Fiscal Year Ended June 30, 2015 AMERICAN SAVINGS BANK TOWER | 1001 BISHOP STREET, SUITE 1700 | HONOLULU, HAWAII 96813-3696 T (808) 524-2255 F (808) 523-2090 | nkcpa.com AMERICAN SAVINGS BANK TOWER 1001 BISHOP STREET, SUITE 1700 HONOLULU, HAWAII 96813-3696 N&K CPAs, Inc. T (808) 524-2255 F (808) 523-2090 ACCOUNTANTS | CONSULTANTS March 28, 2016 To the Chair and Members of the County Council County of Hawai‘i We have completed our financial audit of the basic financial statements of the County of Hawai‘i, State of Hawai‘i (the County), as of and for the fiscal year ended June 30, 2015. Our report containing our opinions on those basic financial statements is included in the County’sComprehensive Annual Financial Report. We submit herein our reports on the County’s internal control over financial reporting and compliance, the County’s compliance with requirements that could have a direct and material effect on each of its major federal programs, and our report on the schedule of expenditures of federal awards. OBJECTIVES OF THE AUDIT The primary purpose of our audit was to form opinions on the fairness of the presentation of the County’s basic financial statements as of and for the fiscal year ended June 30, 2015, and to comply with the requirements of the Office of Management and Budget (OMB) Circular A-133, Audits of States, Local Governments, and Non-Profit Organizations, which establishes audit requirements for state and local governments that receive federal financial assistance.More specifically, the objectives of the audit were as follows: 1. To provide opinions on the fairness of the presentation of the County’s financial statements. 2. To determine whether expenditures and other disbursements have been made and all revenues and other receipts to which the County is entitled have been collected and accounted for in accordance with the laws, rules and regulations, administrative directives, policies and procedures of the County, the State of Hawai‘i and the federal government (where applicable). 3. To determine whether the County has established sufficient internal controls to properly manage federal financial assistance programs and to comply with the applicable laws and regulations. 4. To determine whether the County has complied with the laws and regulations that may have a material effect on the financial statements and on its major federal financial assistance programs. 2 N&K CPAs, Inc. ACCOUNTANTS | CONSULTANTS SCOPE OF THE AUDIT Our audit was performed in accordance with auditing standards generally accepted in the United States of America as prescribed by the American Institute of Certified Public Accountants;Government Auditing Standards, issued by the Comptroller General of the United States; and the provisions of OMB Circular A-133.The scope of our audit included an examination of the transactions and accounting records of the County for the fiscal year ended June 30, 2015. ORGANIZATION OF THE REPORT This report is presented in five parts as follows: • Part I - Our report on internal control over financial reporting and on compliance and other matters. • Part II - Our report on compliance with requirements that could have a direct and material effect on each major program and on internal control over compliance, and report on the schedule of expenditures of federal awards. • Part III - The schedule of findings and questioned costs. • Part IV - The summary schedule of prior audit findings. • Part V - The corrective action plan. We wish to express our sincere appreciation for the excellent cooperation and assistance extended by the staff of the County. Sincerely, N&K CPAs, INC. Chad Funasaki Principal 3 COUNTY OF HAWAIÒI, STATE OF HAWAIÒI TABLE OF CONTENTS Page PART I REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING AND ON COMPLIANCE AND OTHER MATTERS Report on Internal Control over Financial Reporting and on Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards 6 - 7 PART II REPORT ON COMPLIANCE FOR EACH MAJOR FEDERAL PROGRAM; REPORT ON INTERNAL CONTROL OVER COMPLIANCE; AND REPORT ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS REQUIRED BY OMB CIRCULAR A-133 Report on Compliance on Each Major Federal Program; Report on Internal Control over Compliance; and Report on the Schedule of Expenditures of Federal Awards Required by OMB Circular A-133 9 - 11 Schedule of Expenditures of Federal Awards 12 - 23 Notes to Schedule of Expenditures of Federal Awards 24 PART III SCHEDULE OF FINDINGS AND QUESTIONED COSTS 26 - 28 PART IV SUMMARY SCHEDULE OF PRIOR AUDIT FINDINGS Status Report 30 - 31 PART V CORRECTIVE ACTION PLAN Response of County of HawaiÒi 33 4 PART I REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING AND ON COMPLIANCE AND OTHER MATTERS 5 AMERICAN SAVINGS BANK TOWER 1001 BISHOP STREET, SUITE 1700 HONOLULU, HAWAII 96813-3696 N&K CPAs, Inc. T (808) 524-2255 F (808) 523-2090 ACCOUNTANTS | CONSULTANTS REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS INDEPENDENT AUDITORÓS REPORT To the Chair and Members of the County Council County of HawaiÒi We have audited, in accordance with the auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards issued by the Comptroller General of the United States, the financial statements of the governmental activities, the business-type activities, the discretely presented component unit, each major fund, and the aggregate remaining fund information of the County of Hawai Ò i, State of Hawai Ò i (the County), as of and for the fiscal year ended June 30, 2015, and the related notes to the financial statements, which collectively comprise the CountyÓs basic financial statements and have issued our report thereon dated December 28, 2015. Internal Control Over Financial Reporting In planning and performing our audit of the financial statements, we considered the CountyÓs internal control over financial reporting (internal control) to determine the audit procedures that are appropriate in the circumstances for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the CountyÓs internal control. Accordingly, we do not express an opinion on the effectiveness of the CountyÓs internal control. A deficiency in internal control exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, misstatements on a timely basis. A material weakness is a deficiency, or a combination of deficiencies, in internal control such that there is a reasonable possibility that a material misstatement of the entityÓs financial statements will not be prevented, or detected and corrected on a timely basis. A significant deficiency is a deficiency, or a combination of deficiencies, in internal control that is less severe than a material weakness, yet important enough to merit attention by those charged with governance. 6 N&K CPAs, Inc. ACCOUNTANTS | CONSULTANTS Our consideration of internal control was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control that might be material weaknesses or significant deficiencies and therefore, material weaknesses or significant deficiencies may exist that were not identified. Given these limitations, during our audit we did not identify any deficiencies in internal control that we consider to be material weaknesses. We did identify certain deficiencies in internal control, described in the accompanying schedule of findings and questioned costs as items 2015-001 and 2015-002 that we consider to be significant deficiencies. Compliance and Other Matters As part of obtaining reasonable assurance about whether the County’s financial statements are free from material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of our audit, and accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance or other matters that are required to be reported under Government Auditing Standards. County’s Response to Findings The County’s response to the findings identified in our audit is described in Part V, Corrective Action Plan, of this report. The County’s response was not subjected to the auditing procedures applied in the audit of the financial statements and, accordingly, we express no opinion on it. Purpose of this Report The purpose of this report is solely to describe the scope of our testing of internal control and compliance and the results of that testing, and not to provide an opinion on the effectiveness of the entity’s internal control or on compliance. This report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the entity’s internal control and compliance. Accordingly, this communication is not suitable for any other purpose. Honolulu, Hawai‘i December 28, 2015 7 PART II REPORT ON COMPLIANCE FOR EACH MAJOR FEDERAL PROGRAM; REPORT ON INTERNAL CONTROL OVER COMPLIANCE; AND REPORT ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS REQUIRED BY OMB CIRCULAR A-133 8 AMERICAN SAVINGS BANK TOWER 1001 BISHOP STREET, SUITE 1700 HONOLULU, HAWAII 96813-3696 N&K CPAs, Inc. T (808) 524-2255 F (808) 523-2090 ACCOUNTANTS | CONSULTANTS REPORT ON COMPLIANCE FOR EACH MAJOR FEDERAL PROGRAM; REPORT ON INTERNAL CONTROL OVER COMPLIANCE; AND REPORT ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS REQUIRED BY OMB CIRCULAR A-133 INDEPENDENT AUDITOR’S REPORT To the Chair and Members of the County Council County of Hawai‘i Report on Compliance for Each Major Federal Program We have audited the County of Hawai‘i, State of Hawai‘i’s (the County) compliance with the types of compliance requirements described in the OMB Compliance Supplement that could have a direct and material effect on each of the County’s major federal programs for the fiscal year ended June 30, 2015. The County’s major federal programs are identified in the summary of auditor’s results section of the accompanying schedule of findings and questioned costs. Management’s Responsibility The County’s management is responsible for compliance with the requirements of laws, regulations, contracts, and grants applicable to its federal programs. Auditor’s Responsibility Our responsibility is to express an opinion on compliance for each of the County’s major federal programs based on our audit of the types of compliance requirements referred to above. We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America; the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States; and OMB Circular A-133, Audits of States, Local Governments, and Non-Profit Organizations. Those standards and OMB Circular A-133 require that we plan and perform the audit to obtain reasonable assurance about whether noncompliance with the types of compliance requirements referred to above that could have a direct and material effect on a major federal program occurred. An audit includes examining, on a test basis, evidence about the County’s compliance with those requirements and performing such other procedures as we considered necessary in the circumstances. 9 N&K CPAs, Inc. ACCOUNTANTS | CONSULTANTS We believe that our audit provides a reasonable basis for our opinion on compliance for each major federal program. However, our audit does not provide a legal determination of the CountyÓs compliance. Opinion on Each Major Federal Program In our opinion, the County complied, in all material respects, with the compliance requirements referred to above that could have a direct and material effect on each of its major federal programs for the fiscal year ended June 30, 2015. Report on Internal Control Over Compliance Management of the County is responsible for establishing and maintaining effective internal control over compliance with the types of compliance requirements referred to above. In planning and performing our audit of compliance, we considered the CountyÓs internal control over compliance with the types of requirements that could have a direct and material effect on each major federal program to determine the auditing procedures that are appropriate in the circumstances for the purpose of expressing an opinion on compliance for each major federal program and to test and report on internal control over compliance in accordance with OMB Circular A-133, but not for the purpose of expressing an opinion on the effectiveness of internal control over compliance. Accordingly, we do not express an opinion on the effectiveness of the CountyÓs internal control over compliance. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. A material weakness in internal control over compliance is a deficiency, or a combination of deficiencies, in internal control over compliance, such that there is a reasonable possibility that material noncompliance with a type of compliance requirement of a federal program will not be prevented, or detected and corrected, on a timely basis. A significant deficiency in internal control over compliance is a deficiency, or a combination of deficiencies, in internal control over compliance with a type of compliance requirement of a federal program that is less severe than a material weakness in internal control over compliance, yet important enough to merit attention by those charged with governance. Our consideration of internal control over compliance was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control over compliance that might be material weaknesses or significant deficiencies. We did not identify any deficiencies in internal control over compliance that we consider to be material weaknesses. However, material weaknesses may exist that have not been identified. 10 N&K CPAs, Inc. ACCOUNTANTS | CONSULTANTS The purpose of this report on internal control over compliance is solely to describe the scope of our testing of internal control over compliance and the results of that testing based on the requirements of OMB Circular A-133. Accordingly, this report is not suitable for any other purpose. Report on Schedule of Expenditures of Federal Awards Required by OMB Circular A-133 We have audited the financial statements of the governmental activities, the business- type activities, the discretely presented component unit, each major fund, and the aggregate remaining fund information of the County as of and for the fiscal year ended June 30, 2015, and the related notes to the financial statements, which collectively comprise the County’s basic financial statements. We issued our report thereon dated December 28, 2015, which contained unmodified opinions on those financial statements.Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the County’s basic financial statements. We have not performed any procedures with respect to the audited basic financial statements subsequent to December 28, 2015. The accompanying schedule of expenditures of federal awards is presented for purposes of additional analysis as required by OMB Circular A-133 and is not a required part of the basic financial statements. Such information is the responsibility of management and was derived from and relates directly to the underlying accounting and other records used to prepare the basic financial statements. The information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or to the basic financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the schedule of expenditures of federal awards is fairly stated in all material respects in relation to the basic financial statements as a whole. Honolulu, Hawai‘i March 28, 2016 11 County of Hawaii, State of Hawai`i SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Fiscal Year Ended June 30, 2015 Federal Grantor/Pass-Through Grantor/Program Title CFDA Federal Program Federal Payments to Number Grant Number Award Amount Expenditures Sub Recipients U.S. DEPARTMENT OF AGRICULTURE Food and Nutrition Service Passed through the State Department of Education: Summer Food Service Program for Children 10.559 N/A 61,255 $ 61,255 $ Office of Forest Service Cooperative Forestry Assistance Fire Fighter Safety, Public Service Supplies 10.664 14 -DG -11052012-126 100,000 44,163 Passed through the State Department of Land and Natural Resources: Volunteer Fire Assistance 13 -DG -11052012-102 50,000 50,000 14 -DG -11052012-122 18,750 18,750 Subtotal CFDA 10.664 112,913 Rural Utilities Service Water and Waste Disposal Systems for Rural Communities 10.760 61-001-869653225 1,522,369 1,057, 084 Total U.S. Department of Agriculture 1,231,252 U.S. DEPARTMENT OF COMMERCE National Oceanic and Atmospheric Administration Passed through the State Department of Business, Economic Development and Tourism: Coastal Zone Management Administration Awards 11.419 NA13N0S4190055 303,019 14,735 Coastal Zone Management Program NA14N0S4190079 329,704 254,335 Subtotal CFDA 11.419 $ 269,070 $ County of Hawaii, State of Hawai`i SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (Continued) Fiscal Year Ended June 30, 2015 Federal Grantor/Pass-Through Grantor/Program Title U.S. DEPARTMENT OF COMMERCE (Continued) National Telecommunications & Information Administration Passed through the State Department of Commerce & Consumer Affairs: State Broadband Data and Development Grant CFDA Federal Program Federal Payments to Number Grant Number Award Amount Expenditures Sub Recipients 11.558 15-50-M09057 15-50-M09057 40,000 $ 188,500 40,000 $ 188,390 Subtotal CFDA 11.558 228,390 Total U.S. Department of Commerce 497,460 U.S. DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT Office of Housing Section 8 - Housing Assistance Payments Program Kulaimano Elderly Housing Community Planning and Development Community Development Block Grants/State's Program and Non -Entitlement Grants in Hawaii Subtotal CFDA 14.228 14.195 HI 10 0002001 14.228 B -13 -DH -15-0002 Program Income Passed through the Hawaii Housing Finance and Development Corporation: HOME Investment Partnerships Program 14.239 M12 -SG -150100 256,074 113,642 2,627,655 3,319,441 1,989,580 761,557 150,000 32,805 2,139,580 * 794,362 583,371 256,026 Program Income 44,111 Subtotal CFDA 14.239 $ 627,482 $ 256,026 County of Hawaii, State of Hawai`i SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (Continued) Fiscal Year Ended June 30, 2015 Federal Grantor/Pass-Through Grantor/Program Title CFDA Federal Program Federal Payments to Number Grant Number Award Amount Expenditures Sub Recipients U.S. DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT (Continued) Public and Indian Housing Section 8 - Housing Choice Vouchers 14.871 H1002V0 2012 14,511,613 $ 365,778 $ Subtotal CFDA 14.871 H1002V0 2014 13,266,188 6,919,939 H1002AF 2014 1,340,586 907,541 H1002V02015 13,061,385 6,554,631 H1002 FSF009 65,090 45,882 Program Income 1,343,344 16,137,115 * Family Self -Sufficiency Program 14.896 HI002FSH180A014 65,652 24,314 Total U.S. Department of Housing and Urban Development U.S. DEPARTMENT OF THE INTERIOR Office of the Secretary Payments in Lieu of Taxes 15.226 n/a 289,604 Fish and Wildlife Service National Wildlife Refuge Fund 15.659 n/a 113,829 Total U.S. Department of the Interior $ 19,042,133 1,050,388 289,604 113,829 403,433 $ County of Hawaii, State of Hawai`i SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (Continued) Fiscal Year Ended June 30, 2015 Federal Grantor/Pass-Through Grantor/Program Title CFDA Federal Program Federal Payments to Number Grant Number Award Amount Expenditures Sub Recipients U.S. DEPARTMENT OF JUSTICE Office of Juvenile Justice and Delinquency Prevention Passed through the State Department of Human Services: Juvenile Accountability Block Grant 16.523 2011 -JB -FX -0059 Passed through the State Department of Human Services: Juvenile Justice and Delinquency Prevention - Allocation to States Subtotal CFDA 16.540 16.540 2009 -JF -FX -8003 2012 -JF -FX -0001 61,000 $ 200,000 124,375 33,322 $ 33,322 96,343 94,343 85,243 83,293 181,586 177,636 Office for Victims of Crime Passed through the State Department of the Attorney General: Crime Victim Assistance 16.575 11 -VA -04 359,721 119,472 53,579 12 -VA -04 334,620 283,584 42,556 Subtotal CFDA 16.575 403,056 96,135 Bureau of Justice Assistance JAG Program Cluster Edward Byrne Memorial Justice Assistance Grant Program Justice Assistance Grant Passed through the State Department of Attorney General: Hawaii Narcotics Task Force Subtotal JAG Program Cluster 16.738 2012 -DJ -BX -1226 88,650 63,862 2013 -DJ -BX -0018 160,000 56,127 10 -DJ -13 75,000 16,720 13 -DJ -07 73,450 16,935 $ 153,644 $ County of Hawaii, State of Hawai`i SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (Continued) Fiscal Year Ended June 30, 2015 Federal Grantor/Pass-Through GrantorlProgram Title CFDA Federal Program Federal Payments to Number Grant Number Award Amount Expenditures Sub Recipients U.S. DEPARTMENT OF JUSTICE (Continued) Violence Against Women Office Passed through the State Department of Attorney General: Violence Against Women Formula Grants 16.588 STOP Violence Against Women 12 -WF -11 52,353 $ 43,668 $ Sexual Assault Forensic Examiners Standby Pay 11 -WF -03 52,061 10,814 12 -WF -05 52,353 27,404 13 -WF -07 51,525 7,989 Working Towards Crime Lab Accreditation 11 -CD -01 13,300 4,792 O) Basic Needs to Improve Forensic 13 -CD -01 26,830 13,279 Increasing Quality Services 14 -CD -02 26,830 5,892 SAFE Coordinator 10 -WF -15 52,068 15,895 12 -DJ -06 24,946 8,630 Police Detectives 11 -DJ -10 65,200 44,223 Subtotal CFDA 16.588 Office of Community Oriented Policing Services Public Safety Partnership and Community Policing Grants COPS Subtotal CFDA 16.710 Total U.S. Department of Justice 16.710 2011 ULWX0013 182,586 1,392,336 371,275 371,275 $ 1,325,469 $ 307,093 County of Hawaii, State of Hawai`i SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (Continued) Fiscal Year Ended June 30, 2015 Federal Grantor/Pass-Through Grantor/Program Title U.S. DEPARTMENT OF LABOR Employment and Training Administration Passed through the State Department of Labor and Industrial Relations: Senior Community Service Employment Program WIA Cluster WIA/WIAO Adult Program Subtotal CFDA 17.258 WIA/WIAO Youth Activities Subtotal CFDA 17.259 WIA/WIAO Dislocated Worker Formula Grants Subtotal CFDA 17.278 Subtotal WIA Cluster Total U.S. Department of Labor CFDA Federal Program Federal Payments to Number Grant Number Award Amount Expenditures Sub Recipients 17.235 AD -25497-14-55-A-15 362,999 $ 345,909 $ 17.258 AA -22391-12-55-A-15 557,596 60,189 60,189 AA -24088-13-55-A-15 474,501 196,029 196,029 AA -24088-14-55-A-15 444,576 328,011 285,534 584,229 541,752 17.259 AA -24088-13-55-A-15 447,021 172,116 171,017 AA -24088-14-55-A-15 424,534 361,959 316,086 534,075 487,103 17.278 AA -22391-12-55-A-15 442,996 26,814 26,814 AA -24088-13-55-A-15 317,623 98,844 98,844 AA -24088-14-55-A-15 253,156 176,641 153,766 302,299 279,424 1,420, 603 1,308,279 $ 1,766,512 $ 1,308,279 County of Hawaii, State of Hawai`i SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (Continued) Fiscal Year Ended June 30, 2015 Federal Grantor/Pass-Through Grantor/Program Title CFDA Federal Program Federal Payments to Number Grant Number Award Amount Expenditures Sub Recipients U.S. DEPARTMENT OF TRANSPORTATION Federal Highway Administration Passed through the State Department of Transportation: Highway Planning and Construction 20.205 Old Mamalahoa Hwy, Kaahakini Bridge Replacement BR -0100(44) 114,400 $ 302 $ Reeds Island Bridge Replacement on Kaiulani Street in Hilo BR -0100(47) 6,932,169 31,939 Bridge Inspection/Appraisals BR-NBIS(52) 80,000 1,750 BR-NBIS(55) 80,000 33,094 Mamalahoa Highway Earthquake Repairs MP4.4, MP8.9; Palani Road Pedestrian Overpass Repairs ER -15(9) 3,605,260 582 Co Mamalahoa Hwy Widening, Mana Road NH -019-1(044) 696,000 7,628 Alii Drive ROW RS -0187(1) 3,127,200 569 Alii Drive ROW RS -0187(4) 6,564,594 5,503 Waimea Trails & Greenways STP -0100(51) 313,644 10,474 Kuakini Highway Improvements, Hualalai to Alii Highway STP -0110(2) 24,000 1,094 Alii Drive Culvert Replacement STP -0186(1) 430,885 54,003 Kaiminani Drive Roadway Imp, Mamalahoa Hwy to Ahiahi St STP -0198(1) 9,434,330 30,457 Kaiminani Drive Roadway Imp, Ahiahi St to vicinity of Ane Keohokalole Hwy STP -0198(2) 16,126,147 3,060,713 Kamehameha Avenue Resurfacing, Wailoa Bridge to Ponohawai Street STP -1910(1) 12,842,182 6,312,503 Puainako Street Extension, Komohana St to Country Club Rd STP -2000(4) 26,886,000 582 Waianuenue Ave Imp, Rainbow Dr to Akolea Rd STP -2720(001) 280,000 304 Kawailani Street Improvements, Iwalani to Pohakulani Street STP -2760(2) 1,453,564 41,283 Manono St Improv, Lanikaula to Kekuanaoa STP -2770(004) 5,589,416 1,164,747 ARRA- Ane Keohokalole Highway ARRA-1880(1) 35,515,615 683,171 Subtotal CFDA 20.205 $ 11,440,698 * $ County of Hawaii, State of Hawai`i SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (Continued) Fiscal Year Ended June 30, 2015 Federal Grantor/Pass-Through GrantorlProgram Title U.S. DEPARTMENT OF TRANSPORTATION (Continued) Federal Transit Administration Passed through the State Department of Transportation: Federal Transit - Capital Investment Grants (5309 Capital Grant) Subtotal CFDA 20.500 Passed through the State Department of Transportation: Formula Grants for Rural Areas National Highway Traffic Safety Administration Passed through the State Department of Transportation: State and Community Highway Safety CFDA Federal Program Federal Payments to Number Grant Number Award Amount Expenditures Sub Recipients 20.500 HI -04-002 HI -04-004 HI -04-009 961,200 $ 1,725,183 1,200,000 60,000 $ 42,175 1,080,678 1,182, 853 20.509 HI -18-30 606,768 25,649 20.600 Prosecutor's Training AL14-02(03-S-01) 101,390 59,788 AL 15-02(03-S-01) 108,045 7,083 Roadblock Program AL14-02(01-H-02) 212,305 35,858 AL15-02(01-H-02) 222,523 84,179 Youth Deterrence Flex 2014 -project 2 22,956 2,864 Flex 2015 -project 3 24,010 4,407 Seatbelt Enforcement OP14-05(01-H-02) 85,000 25,647 0P15 -05(01-H-02) 78,480 46,896 Click It or Ticket OP14-05(02-H-01) 18,000 4,081 OP 15-05(02-H-01) 18,000 6,546 Speed Enforcement SC14-06(01-H-02) 81,603 20,307 SC15-06(01-H-02) 76,168 $ 60,801 $ County of Hawaii, State of Hawai`i SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (Continued) Fiscal Year Ended June 30, 2015 Federal Grantor/Pass-Through Grantor/Program Title CFDA Federal Program Federal Payments to Number Grant Number Award Amount Expenditures Sub Recipients U.S. DEPARTMENT OF TRANSPORTATION (Continued) Aggressive Driving Project Flex 2014 -Project #1 56,112 $ 22,484 $ Flex 2015 -Project #1 56,112 42,026 Traffic Investigation Program PT14-01(02-H-01) 84,000 55,313 PT15-01(02-H-01) 62,800 24,781 Data Grant TR14-03(04-H-01) 134,500 918 TR 15-03(04-H-01) 124,510 1,200 Distracted Driving DD14-10(02-H-01) 50,000 19,225 DD 15-10(02-H-01) 57,430 24,458 Subtotal CFDA 20.600 548,862 Total U.S. Department of Transportation 13,198,062 U.S. ENVIRONMENTAL PROTECTION AGENCY Office of the Chief Financial Officer Congressionally Mandated Projects Special Appropriation - Kau Cesspool Replacement Project 66.202 XP -96942401-I 1,842,150 85,881 Office of Water Passed through the State Department of Health: Capitalization Grants for Drinking Water State Revolving Funds 66.468 Kynnersley Reservoir Replacement DW129-0002 2,394,278 56,829 Source Water/Wellhead Protection ASO 12-116 200,000 82,772 Subtotal CFDA 66.468 139,601 Total U.S. Environmental Protection Agency $ 225,482 $ County of Hawaii, State of Hawai`i SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (Continued) Fiscal Year Ended June 30, 2015 Federal Grantor/Pass-Through Grantor/Program Title CFDA Federal Program Number Grant Number Award Amount Federal Expenditures Payments to Sub Recipients U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES Administration for Community Living Passed through the State Executive Office on Aging: Special Programs for the Aging - Title III, Part D - Disease Prevention and Health Promotion Services 93.043 3D-4-2013 15,701 $ 9,878 $ Aging Cluster Special Programs for the Aging - Title III, Part B - Grants for Supportive Services and Senior Centers 93.044 3B-4-2013 337,661 33,766 3B-4-2014 336,393 278,402 3B-4-2015 336,393 43,935 Subtotal CFDA 93.044 356,103 Special Programs for the Aging - Title III, Part C - Nutrition Services Subtotal CFDA 93.045 Nutrition Services Incentive Program Subtotal CFDA 93.053 Subtotal Aging Cluster 93.045 301-4-2013 301,938 5,934 3C1-4-2014 319,970 240,764 3C1-4-2015 319,970 43,633 302-4-2012 137,557 2,125 302-4-2013 186,153 112,596 302-4-2014 195,058 117,475 522,527 93.053 N/A 89,803 22,736 N/A 95,625 95,245 117,981 $ 996,611 $ County of Hawaii, State of Hawai`i SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (Continued) Fiscal Year Ended June 30, 2015 Federal Grantor/Pass-Through GrantorlProgram Title U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES (Continued) National Family Caregiver Support, Title III, Part E CFDA Federal Program Federal Payments to Number Grant Number Award Amount Expenditures Sub Recipients 93.052 3E-4-2012 136,502 $ 2,536 $ 3E-4-2013 136,778 95,859 3E-4-2014 128,860 22,563 Subtotal CFDA 93.052 120,958 Administration for Children and Families Passed through the State Department of Health: Affordable Care Act (ACA) Personal Responsibility Education Program 93.092 1201HIPREP 1301HIPREP Subtotal CFDA 93.092 Total U.S. Department of Health and Human Services CORPORATION FOR NATIONAL AND COMMUNITY SERVICE Retired and Senior Volunteer Program 125,000 115,400 34,878 31,698 38,214 22,615 73,092 54,313 1,200,539 54,313 94.002 135RPH 1001 211,762 67,815 Total Corporation for National and Community Service 67,815 U.S. DEPARTMENT OF HOMELAND SECURITY Passed through the State Department of Defense: Disaster Grants - Public Assistance (Presidentially Declared Disasters) 97.036 Kiholo Earthquake FEMA -1664 -DR -HI 5,435,807 878,208 HI Tropical Storm Iselle FEMA -4194 -DR -HI 2,743,237 2,579,979 Pu'u 0'o Volcanic Eruption & Lava Flow FEMA -4201 -DR -HI 5,808,567 5,808,567 Subtotal CFDA 97.036 $ 9,266,754 * $ County of Hawaii, State of Hawai`i SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (Continued) Fiscal Year Ended June 30, 2015 Federal Grantor/Pass-Through Grantor/Program Title U.S. DEPARTMENT OF HOMELAND SECURITY (Continued) Emergency Management Performance Grants CFDA Federal Program Federal Payments to Number Grant Number Award Amount Expenditures Sub Recipients 97.042 EMW-2012-EP-00012 265,000 $ 42,169 $ EMW-2013-EP-00006 158,000 158,000 EMW-2014-EP-00010 140,000 140,000 Subtotal CFDA 97.042 340,169 Assistance to Firefighters Grant 97.044 Fire Prevention EMW-2012-FP-00667 19,400 16,703 Passed through the State Department of Defense: Homeland Security Grant Program 97.067 State Homeland Security Program 2009 -SS -T9-0006 1,000,000 2,850 2011 -SS -00129 600,000 310,190 EMW-2012-SS-00009 354,925 294,024 EMW-2013-SS-00003 370,000 88,449 Subtotal CFDA 97.067 695,513 Total U.S Department of Homeland Security 10,319,139 U.S. OFFICE OF NATIONAL DRUG CONTROL POLICY Hawai'i Impact 07.000 G13HI0004A 73,062 31,840 G14HI0004A 137,702 103,358 G15HI0004A 132,564 29,780 Total U.S. Office of National Drug Control Policy 164,978 TOTAL EXPENDITURES OF FEDERAL AWARDS $ 49,442,274 $ 2,720,073 *Audited as a major federal program for the fiscal year ended June 30, 2015. County of Hawai‘i, State of Hawai‘i NOTES TO SCHEDULE OF EXPENDITURES OF FEDERAL AWARD Fiscal Year Ended June 30, 2015 NOTE A - BASIS OF PRESENTATION The accompanying schedule of expenditures of federal awards includes the federal grant activities of the County and its discretely presented component unit, the Department of Water Supply (DWS) and is presented on the cash basis of accounting. The information in this schedule is presented in accordance with the requirements of OMB Circular A-133, Audits of States, Local Governments, and Non-Profit Organizations. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. NOTE B - OUTSTANDING LOAN BALANCES The State Revolving Fund Loans are for the construction of necessary water treatment works and for wastewater reclamation projects, as well as solid waste projects. County - As of June 30, 2015, the outstanding principal amounted to $21,552,213 that bears interest at 0.50 percent. The loans require semi-annual principal and interest payments and loan fees through fiscal year 2033. The County has 8 projects funded with these loans. DWS - As of June 30, 2015, the outstanding principal amounted to $12,591,409 that bears interest up to 1.37 percent. The loans require semi-annual principal and interest payments and loan fees through fiscal year 2033. The DWS has 12 projects funded with these loans. 24 PART III SCHEDULE OF FINDINGS AND QUESTIONED COSTS 25 County of Hawai‘i, State of Hawai‘i SCHEDULE OF FINDINGS AND QUESTIONED COSTS Fiscal year Ended June 30, 2015 SECTION I - SUMMARY OF AUDITOR’S RESULTS Financial Statements Type of auditor’s report issued: Unmodified Internal control over financial reporting: Material weakness(es) identified? yes no Significant deficiency(ies) identified? yes none reported Noncompliance material to financial statements noted? yes no Federal Awards Internal control over major programs: Material weakness(es) identified? yes no Significant deficiency(ies) identified? yes none reported Type of auditor’s report issued on compliance for major programs: Unmodified Any audit findings disclosed that are required to be reported in accordance with Section 510(a) of OMB Circular A-133? yes no Identification of major programs: CFDA Number Name of Federal Program or Cluster 14.228 Community Development Block Grants 14.871 Section 8 Housing Choice Vouchers 20.205 Highway Planning and Construction (Federal-Aid Highway Program) 97.036 Disaster Grants – Public Assistance (Presidentially Declared Disasters) Dollar threshold used to distinguish between Type A and Type B programs: $1,483,268 Auditee qualified as a low-risk auditee? yes no 26 County of Hawai‘i, State of Hawai‘i SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Fiscal year Ended June 30, 2015 SECTION II - FINANCIAL STATEMENT FINDINGS Ref. No.Internal Control Findings 2015-001 Information Security Policy Condition:The responsibility of managing the County’s Information Technology (IT) activities is shared by five separate departments. The Department of Information Technology (IT) is primarily responsible for managing the County’s central computer system while the other four departments have personnel responsible for managing and supporting the computer system of each respective department. We noted that the County’s IT activities, as a whole, does not have standardized policies and procedures over information security that are followed by all departments and agencies of the County. Criteria: A standardized information security policy should exist that defines information security objectives that are approved by management. This policy should be supported by standards and procedures that are followed by the entity as a whole. Cause: The County does not have formally documented policies and procedures over information security that are followed by all departments and agencies of the County. Effect: The lack of standardized policies and procedures could increase the risk of unauthorized access to the County’s computer systems, which could potentially result in unauthorized use, modification, damage or loss of critical County data. Recommendation Management should develop standardized information security policies and procedures that are followed by all departments and agencies of the County. 27 County of Hawai‘i, State of Hawai‘i SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Fiscal year Ended June 30, 2015 SECTION II - FINANCIAL STATEMENT FINDINGS (Continued) Ref. No.Internal Control Findings 2015-002 Physical Security Condition: At June 30, 2015, the servers for the Eden and IAS systems were located in a room at the Civil Defense Center (Center). During our visit to the Center, we noted the following conditions: Security over the servers is compromised as the door to the room housing these servers is left open due to cooling concerns. Anyone with access to the Civil Defense Center could potentially access the server room. A fire suppression system was not installed. Criteria: Physical access to servers and other sensitive areas is appropriately restricted to authorized personnel. Devices are used to secure sensitive equipment and storage media from the risk of damage from fire. Cause: The County has not formally documented policies and procedures over the physical security of IT systems at the Center nor effectively designed these controls. Effect: Unauthorized access to the server room could result in unauthorized use, modification, damage or loss of data. The absence of a fire suppression system could increase the likelihood of the loss or destruction of data due to fire. Recommendation We recommend that the County develop formal policies over the physical security of IT systems at the Center and to implement them. The server room should be locked and access to keys or codes should be limited to authorized personnel. A fire suppression system should be installed to prevent or limit the loss of data from fire. SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS No matters reported. 28 PART IV SUMMARY SCHEDULE OF PRIOR AUDIT FINDINGS 29 County of Hawai‘i, State of Hawai‘i STATUS REPORT Fiscal year Ended June 30, 2015 This section contains the current status of prior audit recommendations. The recommendations are referenced to the pages of the previous audit report for the fiscal year ended June 30, 2014, dated January 12, 2015. SECTION II - FINANCIAL STATEMENT FINDINGS Reference NumberRecommendationCurrent Status 2014-001 Logical Access & Access Security (pages 25 - 26) Strengthen password controls for the IAS and ReCo Accomplished. As of systems that include a combination of minimum June 30, 2015, password length, complexity, expiration, history, and lockout requirements for both the policy and duration. As a compensating control to ReCo system and IAS have mitigate the lack of functionality in the IAS and ReCo been strengthened. systems, strengthen the domain password parameters and security settings to increase the minimum password age and lockout duration requirements. Develop an information security policy, have the policy Not accomplished. Refer to approved by the appropriate level of management and current year finding 2015- communicate the policy to employees. 001 for management’s response. 2014-002 Physical Security (page 27) The County should develop formal policies over the Not accomplished. Refer to physical security of IT systems at the Civil Defense current year finding 2015- Center and to implement them. The server room 002 for management’s should be locked and access to keys or codes should response. be limited to authorized personnel. A fire suppression system should be installed to prevent or limit the loss of data from fire. 2014-003 Information Technology (IT) Governance (page 28) The County should formally establish an IT Accomplished. The County management steering committee that meets on a implemented quarterly IT regular basis in order to evaluate IT risks and to management committee ensure that identified risks are appropriately meetings to facilitate addressed on a timely basis. information sharing and collaboration between the various departments supporting the County’s information technology function. 30 County of HawaiÒi, State of HawaiÒi STATUS REPORT (Continued) Fiscal year Ended June 30, 2015 SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Ref. Questioned No. Internal Control over Compliance Findings Costs 2009-01 Activities Allowed and Unallowed - Calculation of Federal Expenditures Federal agency: U.S. Department of Homeland Security CFDA No.: 97.036 Program: Disaster Grants - Public Assistance (Presidentially Declared Disasters): Kiholo Earthquake Award Number and Award Year: FEMA-1664-DR-HI 10/15/06-10/15/10 Per the prior auditorÓs testing of the activities allowed and unallowed compliance requirement, it was noted that the County overstated the federal share of eligible costs related to the Ikuo Hisaoka Gymnasium by $27,965. The amount the County reported was based on the actual expenditures, however, as the Ikuo Hisaoka Gymnasium was insured at the time of the loss, the expenditures should have been based on the insurance deductible in accordance with Title 44 Code of Federal Regulations (44 CFR 206.250(c)). $ 27,965 Status: Unresolved. We understand that the County has sought the assistance of the Ò i State Civil Defense in determining the correct portion eligible for federal Hawai aid and is still awaiting a response. 31 PART V CORRECTIVE ACTION PLAN 32 County of Hawai‘i, State of Hawai‘i CORRECTIVE ACTION PLAN Fiscal year Ended June 30, 2015 Financial Statement Findings: 2015-001 Information Security Policy Recommendation: Management should develop standardized information security policies and procedures that are followed by all departments and agencies of the County. County’s Comment: At the last quarterly Information Technology (IT) meeting, the reviewing of all agency Information Security policies and developing standardized baseline security policies for all IT groups was discussed by the group, which consists of the County’s IT Department and other County IT sections. Agencies are to provide their security policies for review and a standardized Information Security Policy will be developed and followed by all County departments and agencies. 2015-002 Physical Security Recommendation: We recommend that the County develop formal policies over the physical security of IT systems at the Center and to implement them. The server room should be locked and access to keys or codes should be limited to authorized personnel. A fire suppression system should be installed to prevent or limit the loss of data from fire. County’s Comment: As explained in prior years, although the specific room that houses the servers is left open, the general Civil Defense facility is restricted to authorized personnel and access to the facility itself is limited. Visitors are required to sign in before being allowed entry to Civil Defense and are typically escorted. The current air conditioning (AC) capabilities of the Server Room are not adequate to allow for the door to be closed without risking damage to the systems. The system specification requirements for a new AC system are being compiled to replace the existing system, which should allow the Server Room door to be closed and locked. We are considering several possibilities which would enable the County to secure the servers while still allowing airflow for cooling is also being considered. Although a fire suppression system has not been selected as of yet, all data is backed up nightly from these servers to a different physical location to reduce the risk of data loss due to fire and other potential hazards. 33