Audit 31581

FY End
2022-12-31
Total Expended
$883,309
Findings
4
Programs
1
Year: 2022 Accepted: 2023-09-19

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
36372 2022-002 Material Weakness - P
36373 2022-003 Material Weakness - P
612814 2022-002 Material Weakness - P
612815 2022-003 Material Weakness - P

Contacts

Name Title Type
C5H7RKUY2LJ3 Brett Hunkins Auditee
8107678270 Jennifer Tingley Auditor
No contacts on file

Notes to SEFA

Title: BASIS OF PRESENTATION Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of the of the Community Foundation of Greater Flint and Supporting Organizations (the Foundation) under programs of the federal government for the year ended December 31, 2022. The information in this Schedule is presented in accordance with the requirements of 2 CFR Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Foundation, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the Foundation.

Finding Details

2022 ? 002 Federal Agency: Department of Health and Human Services Federal Program Name: Immunization Research, Demonstration, Public Information and Education, Training and Clinical Skills Improvement Projects Assistance Listing Number: 93.185 Pass-Through Agency: Michigan State University Award Period: July 31, 2021 ? July 30, 2023 Type of Finding: ? Material Weakness in Internal Control over Compliance ? Material Noncompliance (Modified Opinion) Criteria or specific requirement: 2 CFR 200.414(f) states that organizations may elect to charge a de minimis rate of 10% of modified total direct costs (MTDC) which may be used indefinitely. Modified Total Direct Cost (MTDC) is defined as all direct salaries and wages, applicable fringe benefits, materials and supplies, services, travel, and up to the first $25,000 of each subaward (regardless of the period of performance of the subawards under the award). Condition: Indirect costs were calculated on the full subaward amount, not just the first $25,000. Questioned costs: $50,148 Context: We recalculated the total indirect costs that were billed to the grant, and noted that the 10% indirect cost rate was applied to all subawards, not just the first $25,000 awarded. Cause: Management was not aware of this requirement. Effect: Costs were reimbursed to the Foundation from federal funds related to indirect costs that were not eligible. Recommendation: We recommend the Foundation attend training, review federal requirements, and fully understand the requirements over indirect costs. Views of responsible officials: There is no disagreement with the audit finding. See the Corrective Action Plan for further details.
2022 ? 003 Federal Agency: Department of Health and Human Services Federal Program Name: Immunization Research, Demonstration, Public Information and Education, Training and Clinical Skills Improvement Projects Assistance Listing Number: 93.185 Pass-Through Agency: Michigan State University Award Period: July 31, 2021 ? July 30, 2023 Type of Finding: ? Material Weakness in Internal Control over Compliance ? Other Matters Criteria or specific requirement: 2 CFR 200.332(f) requires that the pass through entity verify that subrecipients expected to be audited as required by 2 CFR Part 200, Subpart F, met this requirement. This verification may be performed as part of the required monitoring under 2 CFR section 200.332(d)(2) to ensure that the subrecipient takes timely and appropriate action on deficiencies detected though audits. Condition: Annual audit reports of subrecipients were not obtained or reviewed by the Foundation. Questioned costs: None Context: Three of the five subrecipients tested were required to have an annual audit report, but these were not obtained or reviewed by the Foundation. Cause: Management was not aware of this requirement. Effect: The subrecipient may have deficiencies detected though audits that could impact monitoring by the Foundation. Recommendation: We recommend the Foundation attend training, review federal requirements, and fully understand the requirements of subrecipient monitoring. Views of responsible officials: There is no disagreement with the audit finding. See the Corrective Action Plan for further details.
2022 ? 002 Federal Agency: Department of Health and Human Services Federal Program Name: Immunization Research, Demonstration, Public Information and Education, Training and Clinical Skills Improvement Projects Assistance Listing Number: 93.185 Pass-Through Agency: Michigan State University Award Period: July 31, 2021 ? July 30, 2023 Type of Finding: ? Material Weakness in Internal Control over Compliance ? Material Noncompliance (Modified Opinion) Criteria or specific requirement: 2 CFR 200.414(f) states that organizations may elect to charge a de minimis rate of 10% of modified total direct costs (MTDC) which may be used indefinitely. Modified Total Direct Cost (MTDC) is defined as all direct salaries and wages, applicable fringe benefits, materials and supplies, services, travel, and up to the first $25,000 of each subaward (regardless of the period of performance of the subawards under the award). Condition: Indirect costs were calculated on the full subaward amount, not just the first $25,000. Questioned costs: $50,148 Context: We recalculated the total indirect costs that were billed to the grant, and noted that the 10% indirect cost rate was applied to all subawards, not just the first $25,000 awarded. Cause: Management was not aware of this requirement. Effect: Costs were reimbursed to the Foundation from federal funds related to indirect costs that were not eligible. Recommendation: We recommend the Foundation attend training, review federal requirements, and fully understand the requirements over indirect costs. Views of responsible officials: There is no disagreement with the audit finding. See the Corrective Action Plan for further details.
2022 ? 003 Federal Agency: Department of Health and Human Services Federal Program Name: Immunization Research, Demonstration, Public Information and Education, Training and Clinical Skills Improvement Projects Assistance Listing Number: 93.185 Pass-Through Agency: Michigan State University Award Period: July 31, 2021 ? July 30, 2023 Type of Finding: ? Material Weakness in Internal Control over Compliance ? Other Matters Criteria or specific requirement: 2 CFR 200.332(f) requires that the pass through entity verify that subrecipients expected to be audited as required by 2 CFR Part 200, Subpart F, met this requirement. This verification may be performed as part of the required monitoring under 2 CFR section 200.332(d)(2) to ensure that the subrecipient takes timely and appropriate action on deficiencies detected though audits. Condition: Annual audit reports of subrecipients were not obtained or reviewed by the Foundation. Questioned costs: None Context: Three of the five subrecipients tested were required to have an annual audit report, but these were not obtained or reviewed by the Foundation. Cause: Management was not aware of this requirement. Effect: The subrecipient may have deficiencies detected though audits that could impact monitoring by the Foundation. Recommendation: We recommend the Foundation attend training, review federal requirements, and fully understand the requirements of subrecipient monitoring. Views of responsible officials: There is no disagreement with the audit finding. See the Corrective Action Plan for further details.