Finding 526719 (2024-004)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2025-03-12
Audit: 345711
Organization: Bay De Noc Community College (MI)

AI Summary

  • Core Issue: A calculation error in the Michigan Reconnect Expansion refund resulted in an underpayment of $752 due to missing fees.
  • Impacted Requirements: The College did not follow the required process for refund calculations as outlined in the program guide, leading to noncompliance.
  • Recommended Follow-Up: Implement a formal review process to ensure all refund calculations are double-checked by a second individual to prevent future errors.

Finding Text

Michigan Reconnect Expansion Refund Calculation Error. Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Allowable Costs/Cost Principles). Program. Coronavirus State and Local Fiscal Recovery Funds; U.S. Department of Treasury; Assistance Listing Number 21.027; Award Number SLFRP0127. Criteria. As outlined in State of Michigan's Michigan Reconnect Expansion program guide, the Reconnect scholarship program is a last-dollar scholarship, which is equal to the difference between in-district tuition and fees (i.e., tuition, contact hours and mandatory fees) and any Pell Grant and any state tuition-restricted scholarships or awards that a student receives following the packaging order. Condition. The student development fees and the technology fees that were required to be included in the scholarship refund calculation were missed for one student. Cause. The College does not have a formal review process where a second individual looks over the refund calculation to ensure errors are caught before the returns are processed. Effect. As a result of this condition, one refund calculation for the grant was incorrect, resulting in an underpayment of $752. It is our understanding that on December 16, 2024, the College refunded this amount to the Michigan Department of Treasury for those affected by this calculation error. Questioned Costs. No costs were required to be questioned as a result of this finding insomuch as our testing did not reveal any unallowed costs over the $25,000 threshold. Recommendation. Management has already taken appropriate corrective action by updating the returns for the student impacted by the refund calculation error. However, we recommend that the College implement a review process to ensure that any correction is being reviewed by an independent second individual. View of Responsible Officials. Management agrees with this finding and has prepared a Corrective Action Plan.

Categories

Allowable Costs / Cost Principles Student Financial Aid Significant Deficiency

Other Findings in this Audit

  • 526708 2024-002
    Significant Deficiency
  • 526709 2024-002
    Significant Deficiency
  • 526710 2024-002
    Significant Deficiency
  • 526711 2024-002
    Significant Deficiency
  • 526712 2024-002
    Significant Deficiency
  • 526713 2024-002
    Significant Deficiency
  • 526714 2024-002
    Significant Deficiency
  • 526715 2024-003
    Significant Deficiency
  • 526716 2024-003
    Significant Deficiency
  • 526717 2024-003
    Significant Deficiency
  • 526718 2024-004
    Significant Deficiency
  • 526720 2024-004
    Significant Deficiency
  • 526721 2024-005
    Significant Deficiency
  • 526722 2024-005
    Significant Deficiency
  • 526723 2024-005
    Significant Deficiency
  • 1103150 2024-002
    Significant Deficiency
  • 1103151 2024-002
    Significant Deficiency
  • 1103152 2024-002
    Significant Deficiency
  • 1103153 2024-002
    Significant Deficiency
  • 1103154 2024-002
    Significant Deficiency
  • 1103155 2024-002
    Significant Deficiency
  • 1103156 2024-002
    Significant Deficiency
  • 1103157 2024-003
    Significant Deficiency
  • 1103158 2024-003
    Significant Deficiency
  • 1103159 2024-003
    Significant Deficiency
  • 1103160 2024-004
    Significant Deficiency
  • 1103161 2024-004
    Significant Deficiency
  • 1103162 2024-004
    Significant Deficiency
  • 1103163 2024-005
    Significant Deficiency
  • 1103164 2024-005
    Significant Deficiency
  • 1103165 2024-005
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $2.72M
84.063 Federal Pell Grant Program $2.65M
84.042 Trio_student Support Services $375,504
84.033 Federal Work-Study Program $138,087
21.027 Coronavirus State and Local Fiscal Recovery Funds $100,140
84.007 Federal Supplemental Educational Opportunity Grants $89,092
10.217 Higher Education - Institution Challenge Grants Program $37,213
84.325 Special Education - Personnel Development to Improve Services and Results for Children with Disabilities $11,923
84.048 Career and Technical Education -- Basic Grants to States $9,152