Audit 305437

FY End
2023-09-30
Total Expended
$5.54M
Findings
2
Programs
24
Year: 2023 Accepted: 2024-05-03

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
395809 2023-001 - - B
972251 2023-001 - - B

Programs

ALN Program Spent Major Findings
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $1.02M Yes 0
93.778 Medical Assistance Program $449,967 - 0
93.235 Affordable Care Act (aca) Abstinence Education Program $139,082 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $135,665 - 0
93.276 Drug-Free Communities Support Program Grants $130,669 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $109,769 - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $106,544 - 0
93.991 Preventive Health and Health Services Block Grant $105,000 - 0
93.889 National Bioterrorism Hospital Preparedness Program $101,170 - 0
93.217 Family Planning_services $64,186 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $61,901 - 0
10.175 Farmers Market and Local Food Promotion Program (b) $61,604 - 0
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $45,925 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $44,995 - 0
10.575 Farm to School Grant Program $36,180 - 0
93.069 Public Health Emergency Preparedness $30,407 - 0
93.994 Maternal and Child Health Services Block Grant to the States $28,686 - 0
66.472 Beach Monitoring and Notification Program Implementation Grants $19,340 - 0
93.436 Well-Integrated Screening and Evaluation for Women Across the Nation (wisewoman) $19,000 - 0
93.788 Opioid Str $11,250 - 0
93.268 Immunization Cooperative Agreements $9,917 - 0
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health $5,000 - 0
66.468 Capitalization Grants for Drinking Water State Revolving Funds $4,988 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $591 - 0

Contacts

Name Title Type
FK6VL4J93SL7 Shannon Klonowski Auditee
2315477613 Trina Ochs Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Note 1 The accompanying Schedule of Expenditures of Federal Awards includes the Federal grant activity of the Health Department, and is presented on the modified accrual basis of accounting. The information in this schedule is presented in accordance with requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards ("Uniform Guidance"). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in, the basic financial statements. Note 2 Management has reported that expenditures in this Schedule of Expenditures of Federal Awards are equal to or derived from amounts reported in the annual or final cost reports. Unallowed differences, if any, have been disclosed to the auditor. Note 3 The financial reports including claims for advances and reimbursements and amounts claimed or used for matching, are timely, complete, accurate and contain information that is supported by the books and records from which the basic financial statements have been prepared. Note 4 An analysis of the total Federal and State grants follows: Federal expenditures per Schedule of Expenditures of Federal Awards $ 5,535,302 State financial assistance 5,141,045 Total State and Federal grants revenue reported in the basic financial statements $10,676,347 Note 5 The Health Department did not use the 10% de-minimus cost rate under the Uniform Administrative Requirements. Note 6 The Health Department receives certain federal grants as subawards from non-federal entities. Pass-through entities, where applicable, have been identified in the Schedule with an abbreviation, defined as follows: Pass-through Agency Abbreviation Pass-through Agency Name EGLE Michigan Department of Environment, Great Lakes and Energy MCRH Michigan Center for Rural Health MDHHS Michigan Department of Health and Human Services MFF Michigan Fitness Foundation NMRE Northern Michigan Regional Entity SAMHSA Substance Abuse and Mental Health Services Administration USDAFNS USDA Food and Nutrition Service NACCHO National Association of County and City Health Officials Note 5 A reconciliation of expenditures on the Schedule of Expenditures of Federal Awards with Federal sources reported on the financial statements are as follows: Federal expenditures per schedule of expenditures of federal awards $ 1,547,509 Child Care Stabilization Funds 111,426 Total federal sources per financial statements $ 1,658,935 Note 6 Pass-through entities, where applicable, have been identified in the schedule with an abbreviation, defined as follows: Pass-Through Agency Abbreviation Pass-Through Agency Name MDE Michigan Department of Education NES Northwest Education Services De Minimis Rate Used: N Rate Explanation: The Health Department did not use the 10% de-minimus cost rate under the Uniform Administrative Requirements.

Finding Details

Finding 2023-001 Assistance Listing # 93.323 - Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Allowable Costs/Cost Principles Immaterial Noncompliance Criteria: Allowable costs for the federal award program are to be used for non-research activities that (1) strengthen epidemiologic capacity; (2) enhance laboratory capacity; (3) improve information systems; and (4) enhance collaboration among epidemiology, laboratory and information system components of public health departments. Condition: The Health Department charged a community luncheon to the federal award program that was not related to the purpose of the grant. Cause: Department supervisors overseeing the coding of expenditures miscoded the expenditure to the federal award program. Effect: An unallowed expenditure was charged to the federal award program. Context: The Health Department miscoded an expenditure to the federal award program in error. Upon discovery of the miscoded expenditure during audit testing, the questioned expenditure was removed from the federal award program, and other excess program-eligible costs were coded against the federal award program in its place. Questioned Costs: Known questioned costs are below the reporting threshold of $25,000. Recommendation: Per the Health Department's internal control policies, department supervisors are responsible for coding of grant expenditures. We recommend department supervisors carefully review the coding of individual transactions to ensure reasonableness of expenditures charged to federal award programs. Management's Response and Planned Corrective Action: Accounting leadership will review general Federal guidelines for allowable costs with directors and supervisors. Additionally, directors and supervisors will be reminded of their responsibility for, and the importance of, carefully reviewing coding of individual program expenditures to align with Federal guidelines. Accountants currently meet monthly with directors and supervisors to review the financial status of each program, including unreasonable budget variances and the reasonableness of current expenditure levels. Going forward, they will also review the individual expenditures in categories deemed most likely to have unallowable transactions. Responsible Party for Corrective Action: Shannon Klownowski, Chief Financial and Administrative Officer Anticipated Completion Date: January 2024. -
Finding 2023-001 Assistance Listing # 93.323 - Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Allowable Costs/Cost Principles Immaterial Noncompliance Criteria: Allowable costs for the federal award program are to be used for non-research activities that (1) strengthen epidemiologic capacity; (2) enhance laboratory capacity; (3) improve information systems; and (4) enhance collaboration among epidemiology, laboratory and information system components of public health departments. Condition: The Health Department charged a community luncheon to the federal award program that was not related to the purpose of the grant. Cause: Department supervisors overseeing the coding of expenditures miscoded the expenditure to the federal award program. Effect: An unallowed expenditure was charged to the federal award program. Context: The Health Department miscoded an expenditure to the federal award program in error. Upon discovery of the miscoded expenditure during audit testing, the questioned expenditure was removed from the federal award program, and other excess program-eligible costs were coded against the federal award program in its place. Questioned Costs: Known questioned costs are below the reporting threshold of $25,000. Recommendation: Per the Health Department's internal control policies, department supervisors are responsible for coding of grant expenditures. We recommend department supervisors carefully review the coding of individual transactions to ensure reasonableness of expenditures charged to federal award programs. Management's Response and Planned Corrective Action: Accounting leadership will review general Federal guidelines for allowable costs with directors and supervisors. Additionally, directors and supervisors will be reminded of their responsibility for, and the importance of, carefully reviewing coding of individual program expenditures to align with Federal guidelines. Accountants currently meet monthly with directors and supervisors to review the financial status of each program, including unreasonable budget variances and the reasonableness of current expenditure levels. Going forward, they will also review the individual expenditures in categories deemed most likely to have unallowable transactions. Responsible Party for Corrective Action: Shannon Klownowski, Chief Financial and Administrative Officer Anticipated Completion Date: January 2024. -