Audit 330866

FY End
2024-06-30
Total Expended
$2.30M
Findings
4
Programs
6
Organization: West Shore Community College (MI)
Year: 2024 Accepted: 2024-12-04

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
512995 2024-001 Significant Deficiency - N
512996 2024-001 Significant Deficiency - N
1089437 2024-001 Significant Deficiency - N
1089438 2024-001 Significant Deficiency - N

Programs

ALN Program Spent Major Findings
84.063 Federal Pell Grant Program $1.39M Yes 1
21.027 Coronavirus State and Local Fiscal Recovery Funds $280,148 - 0
84.268 Federal Direct Student Loans $273,099 Yes 1
84.048 Career and Technical Education -- Basic Grants to States $96,128 - 0
84.007 Federal Supplemental Educational Opportunity Grants $50,630 Yes 0
84.033 Federal Work-Study Program $47,184 Yes 0

Contacts

Name Title Type
XAD7SXLMNQB6 Conny Bax Auditee
2318435710 Paula Bedford, 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 West Shore Community College (the “College”) under programs of the federal government for the year ended June 30, 2024. The information in this Schedule is presented in accordance with the requirements of the 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 net 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, and 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: Y Rate Explanation: For purposes of charging indirect costs to federal awards, the College has elected to use the 10 percent de minimis cost rate as permitted by §200.414 of the Uniform Guidance.

Finding Details

Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Special Tests and Provisions). Programs. Student Financial Assistance Cluster; U.S. Department of Education; Assistance Listing Numbers 84.063 and 84.268; Award Numbers P063P225088 and P268K225088. Criteria. The Code of Federal Regulations, 34 CFR 668.22(f)(2)(i), states that scheduled breaks of at least five consecutive days are excluded from the total number of calendar days in the period of enrollment and the number of calendar days completed in that period. Condition. It was noted during our testing of one R2T4 calculation that the College is not excluding the correct number of days for scheduled breaks of five days or more in both the 2023 fall and 2024 spring terms. Thus, calculations performed for the 2023 fall and 2024 spring terms were determined to be inaccurate. Cause. Incorrect break days were used in the calculation due to an error in the entering of the College's academic schedule information into the PowerFAIDS system, resulting in incorrect dates being used in the preparation of refund calculations within the system. Effect. As a result of this condition, the students' return of funds calculation was not done correctly and the return of funds back to the federal government was for the incorrect amount. Questioned Costs. No costs are required to be questioned as the amounts did not exceed the reporting threshold. Recommendation. We recommend the College review the R2T4 requirements and implement procedures to ensure the R2T4 calculations are using the correct amount of term days. View of Responsible Officials. Management concurs with this finding and has prepared a Corrective Action Plan.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Special Tests and Provisions). Programs. Student Financial Assistance Cluster; U.S. Department of Education; Assistance Listing Numbers 84.063 and 84.268; Award Numbers P063P225088 and P268K225088. Criteria. The Code of Federal Regulations, 34 CFR 668.22(f)(2)(i), states that scheduled breaks of at least five consecutive days are excluded from the total number of calendar days in the period of enrollment and the number of calendar days completed in that period. Condition. It was noted during our testing of one R2T4 calculation that the College is not excluding the correct number of days for scheduled breaks of five days or more in both the 2023 fall and 2024 spring terms. Thus, calculations performed for the 2023 fall and 2024 spring terms were determined to be inaccurate. Cause. Incorrect break days were used in the calculation due to an error in the entering of the College's academic schedule information into the PowerFAIDS system, resulting in incorrect dates being used in the preparation of refund calculations within the system. Effect. As a result of this condition, the students' return of funds calculation was not done correctly and the return of funds back to the federal government was for the incorrect amount. Questioned Costs. No costs are required to be questioned as the amounts did not exceed the reporting threshold. Recommendation. We recommend the College review the R2T4 requirements and implement procedures to ensure the R2T4 calculations are using the correct amount of term days. View of Responsible Officials. Management concurs with this finding and has prepared a Corrective Action Plan.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Special Tests and Provisions). Programs. Student Financial Assistance Cluster; U.S. Department of Education; Assistance Listing Numbers 84.063 and 84.268; Award Numbers P063P225088 and P268K225088. Criteria. The Code of Federal Regulations, 34 CFR 668.22(f)(2)(i), states that scheduled breaks of at least five consecutive days are excluded from the total number of calendar days in the period of enrollment and the number of calendar days completed in that period. Condition. It was noted during our testing of one R2T4 calculation that the College is not excluding the correct number of days for scheduled breaks of five days or more in both the 2023 fall and 2024 spring terms. Thus, calculations performed for the 2023 fall and 2024 spring terms were determined to be inaccurate. Cause. Incorrect break days were used in the calculation due to an error in the entering of the College's academic schedule information into the PowerFAIDS system, resulting in incorrect dates being used in the preparation of refund calculations within the system. Effect. As a result of this condition, the students' return of funds calculation was not done correctly and the return of funds back to the federal government was for the incorrect amount. Questioned Costs. No costs are required to be questioned as the amounts did not exceed the reporting threshold. Recommendation. We recommend the College review the R2T4 requirements and implement procedures to ensure the R2T4 calculations are using the correct amount of term days. View of Responsible Officials. Management concurs with this finding and has prepared a Corrective Action Plan.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Special Tests and Provisions). Programs. Student Financial Assistance Cluster; U.S. Department of Education; Assistance Listing Numbers 84.063 and 84.268; Award Numbers P063P225088 and P268K225088. Criteria. The Code of Federal Regulations, 34 CFR 668.22(f)(2)(i), states that scheduled breaks of at least five consecutive days are excluded from the total number of calendar days in the period of enrollment and the number of calendar days completed in that period. Condition. It was noted during our testing of one R2T4 calculation that the College is not excluding the correct number of days for scheduled breaks of five days or more in both the 2023 fall and 2024 spring terms. Thus, calculations performed for the 2023 fall and 2024 spring terms were determined to be inaccurate. Cause. Incorrect break days were used in the calculation due to an error in the entering of the College's academic schedule information into the PowerFAIDS system, resulting in incorrect dates being used in the preparation of refund calculations within the system. Effect. As a result of this condition, the students' return of funds calculation was not done correctly and the return of funds back to the federal government was for the incorrect amount. Questioned Costs. No costs are required to be questioned as the amounts did not exceed the reporting threshold. Recommendation. We recommend the College review the R2T4 requirements and implement procedures to ensure the R2T4 calculations are using the correct amount of term days. View of Responsible Officials. Management concurs with this finding and has prepared a Corrective Action Plan.