Audit 33915

FY End
2022-06-30
Total Expended
$18.84M
Findings
8
Programs
12
Organization: Mid Michigan College (MI)
Year: 2022 Accepted: 2023-03-01

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
37096 2022-001 - Yes N
37097 2022-001 - Yes N
37098 2022-001 - Yes N
37099 2022-001 - Yes N
613538 2022-001 - Yes N
613539 2022-001 - Yes N
613540 2022-001 - Yes N
613541 2022-001 - Yes N

Programs

ALN Program Spent Major Findings
84.063 Federal Pell Grant Program $4.64M Yes 1
84.268 Federal Direct Student Loans $3.94M Yes 1
84.425 Education Stabilization Fund $2.98M Yes 0
84.031 Higher Education_institutional Aid $227,761 - 0
84.042 Trio_student Support Services $222,864 - 0
84.044 Trio_talent Search $173,563 - 0
84.033 Federal Work-Study Program $134,520 Yes 1
84.007 Federal Supplemental Educational Opportunity Grants $117,321 Yes 1
59.037 Small Business Development Centers $106,983 - 0
10.351 Rural Business Development Grant $95,000 - 0
84.044 Trio_student Support Services $72,893 - 0
84.048 Career and Technical Education -- Basic Grants to States $9,200 - 0

Contacts

Name Title Type
XCZ9Q91GKCS6 Susan Call Auditee
9893866604 Joshua Sullivan, CPA Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal grant activity of Mid Michigan College (the College) under programs of the federal government for the year ended June 30, 2022. The information in this Schedule is presented in accordance with the 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). Because the Schedule presents only a selected portion of the operations of the College, it is not intended to and does not present the financial position, changes in net position or cash flows of the College. Expenditures reported on the Schedule are reported on the accrual basis of accounting, which is described in Note 1 to the College's financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

2022-001 - Timeliness of Student Status Changes (Repeat Finding) Finding Type. Immaterial Noncompliance Program. Student Financial Assistance Cluster; U.S. Department of Education; Federal Supplemental Educational Opportunity Grants ("FSEOG"), Assistance Listing Number 84.007, Award Number P007A212047; Federal Work Study ("FWS"), Assistance Listing Number 84.033, Award Number P033A212047; Federal Pell Grant Program, Assistance Listing Number 84.063, Award Number P063P212848; and Federal Direct Student Loans Program, Assistance Listing Number 84.268, Award Number P268K212848. Criteria. The Compliance Supplement states that a College must report student status changes within 60 days of the status change. Condition. A status change was not updated for one of the forty students selected for testing who unofficially withdrew during the fiscal year. Cause. A status change was not updated for one of the students selected for testing who withdrew during the year. The College had a process in place to identify incorrectly submitted withdrawal statuses or dates to National Student Loan Data System (NSLDS), however, this process was not fully followed by an employee who is no longer employed at the College. Effect. As a result of this condition, the College did not fully comply with the requirements to report all student status changes and as a result of this condition, the College was exposed to not consistently reporting all student status changes correctly. Questioned Costs. No costs were required to be questioned as a result of this finding. Recommendation. We recommend that the College follow implemented procedures to include all status changes when reporting status changes to the NSLDS. View of Responsible Officials. Management believes this was an isolated incident and was identified internally during the fiscal year. Subsequent to this issue being found, the College engaged their IT department to look further into the cause of why some students were being reported with wrong dates. The College ended up changing how the Colleague-generated report that is sent to the Clearinghouse pulls withdrawn students so as to ensure these issues occur less often. The College believes that the corrective actions they have taken will be sufficient.
2022-001 - Timeliness of Student Status Changes (Repeat Finding) Finding Type. Immaterial Noncompliance Program. Student Financial Assistance Cluster; U.S. Department of Education; Federal Supplemental Educational Opportunity Grants ("FSEOG"), Assistance Listing Number 84.007, Award Number P007A212047; Federal Work Study ("FWS"), Assistance Listing Number 84.033, Award Number P033A212047; Federal Pell Grant Program, Assistance Listing Number 84.063, Award Number P063P212848; and Federal Direct Student Loans Program, Assistance Listing Number 84.268, Award Number P268K212848. Criteria. The Compliance Supplement states that a College must report student status changes within 60 days of the status change. Condition. A status change was not updated for one of the forty students selected for testing who unofficially withdrew during the fiscal year. Cause. A status change was not updated for one of the students selected for testing who withdrew during the year. The College had a process in place to identify incorrectly submitted withdrawal statuses or dates to National Student Loan Data System (NSLDS), however, this process was not fully followed by an employee who is no longer employed at the College. Effect. As a result of this condition, the College did not fully comply with the requirements to report all student status changes and as a result of this condition, the College was exposed to not consistently reporting all student status changes correctly. Questioned Costs. No costs were required to be questioned as a result of this finding. Recommendation. We recommend that the College follow implemented procedures to include all status changes when reporting status changes to the NSLDS. View of Responsible Officials. Management believes this was an isolated incident and was identified internally during the fiscal year. Subsequent to this issue being found, the College engaged their IT department to look further into the cause of why some students were being reported with wrong dates. The College ended up changing how the Colleague-generated report that is sent to the Clearinghouse pulls withdrawn students so as to ensure these issues occur less often. The College believes that the corrective actions they have taken will be sufficient.
2022-001 - Timeliness of Student Status Changes (Repeat Finding) Finding Type. Immaterial Noncompliance Program. Student Financial Assistance Cluster; U.S. Department of Education; Federal Supplemental Educational Opportunity Grants ("FSEOG"), Assistance Listing Number 84.007, Award Number P007A212047; Federal Work Study ("FWS"), Assistance Listing Number 84.033, Award Number P033A212047; Federal Pell Grant Program, Assistance Listing Number 84.063, Award Number P063P212848; and Federal Direct Student Loans Program, Assistance Listing Number 84.268, Award Number P268K212848. Criteria. The Compliance Supplement states that a College must report student status changes within 60 days of the status change. Condition. A status change was not updated for one of the forty students selected for testing who unofficially withdrew during the fiscal year. Cause. A status change was not updated for one of the students selected for testing who withdrew during the year. The College had a process in place to identify incorrectly submitted withdrawal statuses or dates to National Student Loan Data System (NSLDS), however, this process was not fully followed by an employee who is no longer employed at the College. Effect. As a result of this condition, the College did not fully comply with the requirements to report all student status changes and as a result of this condition, the College was exposed to not consistently reporting all student status changes correctly. Questioned Costs. No costs were required to be questioned as a result of this finding. Recommendation. We recommend that the College follow implemented procedures to include all status changes when reporting status changes to the NSLDS. View of Responsible Officials. Management believes this was an isolated incident and was identified internally during the fiscal year. Subsequent to this issue being found, the College engaged their IT department to look further into the cause of why some students were being reported with wrong dates. The College ended up changing how the Colleague-generated report that is sent to the Clearinghouse pulls withdrawn students so as to ensure these issues occur less often. The College believes that the corrective actions they have taken will be sufficient.
2022-001 - Timeliness of Student Status Changes (Repeat Finding) Finding Type. Immaterial Noncompliance Program. Student Financial Assistance Cluster; U.S. Department of Education; Federal Supplemental Educational Opportunity Grants ("FSEOG"), Assistance Listing Number 84.007, Award Number P007A212047; Federal Work Study ("FWS"), Assistance Listing Number 84.033, Award Number P033A212047; Federal Pell Grant Program, Assistance Listing Number 84.063, Award Number P063P212848; and Federal Direct Student Loans Program, Assistance Listing Number 84.268, Award Number P268K212848. Criteria. The Compliance Supplement states that a College must report student status changes within 60 days of the status change. Condition. A status change was not updated for one of the forty students selected for testing who unofficially withdrew during the fiscal year. Cause. A status change was not updated for one of the students selected for testing who withdrew during the year. The College had a process in place to identify incorrectly submitted withdrawal statuses or dates to National Student Loan Data System (NSLDS), however, this process was not fully followed by an employee who is no longer employed at the College. Effect. As a result of this condition, the College did not fully comply with the requirements to report all student status changes and as a result of this condition, the College was exposed to not consistently reporting all student status changes correctly. Questioned Costs. No costs were required to be questioned as a result of this finding. Recommendation. We recommend that the College follow implemented procedures to include all status changes when reporting status changes to the NSLDS. View of Responsible Officials. Management believes this was an isolated incident and was identified internally during the fiscal year. Subsequent to this issue being found, the College engaged their IT department to look further into the cause of why some students were being reported with wrong dates. The College ended up changing how the Colleague-generated report that is sent to the Clearinghouse pulls withdrawn students so as to ensure these issues occur less often. The College believes that the corrective actions they have taken will be sufficient.
2022-001 - Timeliness of Student Status Changes (Repeat Finding) Finding Type. Immaterial Noncompliance Program. Student Financial Assistance Cluster; U.S. Department of Education; Federal Supplemental Educational Opportunity Grants ("FSEOG"), Assistance Listing Number 84.007, Award Number P007A212047; Federal Work Study ("FWS"), Assistance Listing Number 84.033, Award Number P033A212047; Federal Pell Grant Program, Assistance Listing Number 84.063, Award Number P063P212848; and Federal Direct Student Loans Program, Assistance Listing Number 84.268, Award Number P268K212848. Criteria. The Compliance Supplement states that a College must report student status changes within 60 days of the status change. Condition. A status change was not updated for one of the forty students selected for testing who unofficially withdrew during the fiscal year. Cause. A status change was not updated for one of the students selected for testing who withdrew during the year. The College had a process in place to identify incorrectly submitted withdrawal statuses or dates to National Student Loan Data System (NSLDS), however, this process was not fully followed by an employee who is no longer employed at the College. Effect. As a result of this condition, the College did not fully comply with the requirements to report all student status changes and as a result of this condition, the College was exposed to not consistently reporting all student status changes correctly. Questioned Costs. No costs were required to be questioned as a result of this finding. Recommendation. We recommend that the College follow implemented procedures to include all status changes when reporting status changes to the NSLDS. View of Responsible Officials. Management believes this was an isolated incident and was identified internally during the fiscal year. Subsequent to this issue being found, the College engaged their IT department to look further into the cause of why some students were being reported with wrong dates. The College ended up changing how the Colleague-generated report that is sent to the Clearinghouse pulls withdrawn students so as to ensure these issues occur less often. The College believes that the corrective actions they have taken will be sufficient.
2022-001 - Timeliness of Student Status Changes (Repeat Finding) Finding Type. Immaterial Noncompliance Program. Student Financial Assistance Cluster; U.S. Department of Education; Federal Supplemental Educational Opportunity Grants ("FSEOG"), Assistance Listing Number 84.007, Award Number P007A212047; Federal Work Study ("FWS"), Assistance Listing Number 84.033, Award Number P033A212047; Federal Pell Grant Program, Assistance Listing Number 84.063, Award Number P063P212848; and Federal Direct Student Loans Program, Assistance Listing Number 84.268, Award Number P268K212848. Criteria. The Compliance Supplement states that a College must report student status changes within 60 days of the status change. Condition. A status change was not updated for one of the forty students selected for testing who unofficially withdrew during the fiscal year. Cause. A status change was not updated for one of the students selected for testing who withdrew during the year. The College had a process in place to identify incorrectly submitted withdrawal statuses or dates to National Student Loan Data System (NSLDS), however, this process was not fully followed by an employee who is no longer employed at the College. Effect. As a result of this condition, the College did not fully comply with the requirements to report all student status changes and as a result of this condition, the College was exposed to not consistently reporting all student status changes correctly. Questioned Costs. No costs were required to be questioned as a result of this finding. Recommendation. We recommend that the College follow implemented procedures to include all status changes when reporting status changes to the NSLDS. View of Responsible Officials. Management believes this was an isolated incident and was identified internally during the fiscal year. Subsequent to this issue being found, the College engaged their IT department to look further into the cause of why some students were being reported with wrong dates. The College ended up changing how the Colleague-generated report that is sent to the Clearinghouse pulls withdrawn students so as to ensure these issues occur less often. The College believes that the corrective actions they have taken will be sufficient.
2022-001 - Timeliness of Student Status Changes (Repeat Finding) Finding Type. Immaterial Noncompliance Program. Student Financial Assistance Cluster; U.S. Department of Education; Federal Supplemental Educational Opportunity Grants ("FSEOG"), Assistance Listing Number 84.007, Award Number P007A212047; Federal Work Study ("FWS"), Assistance Listing Number 84.033, Award Number P033A212047; Federal Pell Grant Program, Assistance Listing Number 84.063, Award Number P063P212848; and Federal Direct Student Loans Program, Assistance Listing Number 84.268, Award Number P268K212848. Criteria. The Compliance Supplement states that a College must report student status changes within 60 days of the status change. Condition. A status change was not updated for one of the forty students selected for testing who unofficially withdrew during the fiscal year. Cause. A status change was not updated for one of the students selected for testing who withdrew during the year. The College had a process in place to identify incorrectly submitted withdrawal statuses or dates to National Student Loan Data System (NSLDS), however, this process was not fully followed by an employee who is no longer employed at the College. Effect. As a result of this condition, the College did not fully comply with the requirements to report all student status changes and as a result of this condition, the College was exposed to not consistently reporting all student status changes correctly. Questioned Costs. No costs were required to be questioned as a result of this finding. Recommendation. We recommend that the College follow implemented procedures to include all status changes when reporting status changes to the NSLDS. View of Responsible Officials. Management believes this was an isolated incident and was identified internally during the fiscal year. Subsequent to this issue being found, the College engaged their IT department to look further into the cause of why some students were being reported with wrong dates. The College ended up changing how the Colleague-generated report that is sent to the Clearinghouse pulls withdrawn students so as to ensure these issues occur less often. The College believes that the corrective actions they have taken will be sufficient.
2022-001 - Timeliness of Student Status Changes (Repeat Finding) Finding Type. Immaterial Noncompliance Program. Student Financial Assistance Cluster; U.S. Department of Education; Federal Supplemental Educational Opportunity Grants ("FSEOG"), Assistance Listing Number 84.007, Award Number P007A212047; Federal Work Study ("FWS"), Assistance Listing Number 84.033, Award Number P033A212047; Federal Pell Grant Program, Assistance Listing Number 84.063, Award Number P063P212848; and Federal Direct Student Loans Program, Assistance Listing Number 84.268, Award Number P268K212848. Criteria. The Compliance Supplement states that a College must report student status changes within 60 days of the status change. Condition. A status change was not updated for one of the forty students selected for testing who unofficially withdrew during the fiscal year. Cause. A status change was not updated for one of the students selected for testing who withdrew during the year. The College had a process in place to identify incorrectly submitted withdrawal statuses or dates to National Student Loan Data System (NSLDS), however, this process was not fully followed by an employee who is no longer employed at the College. Effect. As a result of this condition, the College did not fully comply with the requirements to report all student status changes and as a result of this condition, the College was exposed to not consistently reporting all student status changes correctly. Questioned Costs. No costs were required to be questioned as a result of this finding. Recommendation. We recommend that the College follow implemented procedures to include all status changes when reporting status changes to the NSLDS. View of Responsible Officials. Management believes this was an isolated incident and was identified internally during the fiscal year. Subsequent to this issue being found, the College engaged their IT department to look further into the cause of why some students were being reported with wrong dates. The College ended up changing how the Colleague-generated report that is sent to the Clearinghouse pulls withdrawn students so as to ensure these issues occur less often. The College believes that the corrective actions they have taken will be sufficient.