Finding 526716 (2024-003)

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 scholarship led to an overpayment of $3,054 to two students due to incorrect inclusion of welding program tuition in the fees.
  • Impacted Requirements: The error violated the program's guidelines for determining scholarship amounts based on allowable costs and financial aid received.
  • Recommended Follow-Up: Ensure adherence to review processes and implement formal documentation to separate preparers from reviewers to prevent future errors.

Finding Text

Michigan Reconnect Expansion 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 amount of scholarship a student is eligible to receive from the Michigan Reconnect Expansion grant is dependent on the total cost of tuition and fees as well as other financial aid received (Pell and Tuition Restricted Scholarships). When performing the calculation, the College mistakenly included tuition related to welding programs in with the fees. Cause. The College performs a review by selecting a group of students who are manually reviewed before they disburse funds for the semester. The overpayment of Michigan Reconnect Expansion scholarship funds was missed during the review of the calculation, as the two students with errors were not a part of the manual review. Effect. As a result of this condition, two students' scholarship calculations were incorrect, resulting in an overpayment of $3,054 to those students. It is our understanding that on October 30, 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. We recommend that the College follow the review processes they have in place and include formal documentation showing the preparer is a separate individual from the reviewer. 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
  • 526717 2024-003
    Significant Deficiency
  • 526718 2024-004
    Significant Deficiency
  • 526719 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