Audit 35343

FY End
2022-06-30
Total Expended
$20.57M
Findings
6
Programs
13
Organization: Albion College (MI)
Year: 2022 Accepted: 2023-04-24

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
38096 2022-001 Material Weakness Yes I
38097 2022-002 Significant Deficiency - C
38098 2022-002 Significant Deficiency - C
614538 2022-001 Material Weakness Yes I
614539 2022-002 Significant Deficiency - C
614540 2022-002 Significant Deficiency - C

Contacts

Name Title Type
N7M7LMDS1FK6 Gary Black Auditee
5176290289 Robb Rose Auditor
No contacts on file

Notes to SEFA

Title: Adjustments and Transfers Accounting Policies: The accompanying schedule of expenditures of federal awards (the "Schedule") includes the federal grant activity of Albion College (the "College") under programs of the federal government for the year ended June 30, 2022. The information in the 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 (the "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 assets, or cash flows of the College. Expenditures reported in the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The pass-through entity identifying numbers are presented where available. The College has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs as allowed under the Uniform Guidance, since the College has an approved rate through an approved agency. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. As allowable and in accordance with federal regulations issued by the U.S. Department of Education, the College transferred and spent $21,169 of Federal Work-study Program funds in the Federal Supplemental Educational Opportunity Grant Program.
Title: Loans Balances Accounting Policies: The accompanying schedule of expenditures of federal awards (the "Schedule") includes the federal grant activity of Albion College (the "College") under programs of the federal government for the year ended June 30, 2022. The information in the 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 (the "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 assets, or cash flows of the College. Expenditures reported in the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The pass-through entity identifying numbers are presented where available. The College has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs as allowed under the Uniform Guidance, since the College has an approved rate through an approved agency. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. As a part of the Student Financial Assistance Cluster, the College participates in the Federal Perkins Loan Program through the U.S. Department of Education. The outstanding balances on these loans totaled $1,973,849 as of June 30, 2022. New loans are financed from the collections of previous loans, interest income, and institutional advances to the fund. The College utilizes the services of University Accounting Service, Inc. to administer the repayments of the Federal Perkins loans and perform certain due diligence procedures.

Finding Details

ALN Number, Federal Agency, and Program Name - COVID-19 Education Stabilization Fund - Higher Education Emergency Relief Fund - CFDA 84.425F Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - Yes - 2021-001 Criteria - The College is required to have a policy in place to ensure it is in compliance with "Never Contract with the Enemy" (2 CFR Part 183) and verifying that a contractor is not debarred, suspended, or otherwise excluded from doing business with federal assistance programs or activities (2 CFR Sections 200.212 and 200.318(h); 2 CFR section 180.300; 48 CFR Section 52.209-6). In addition, the College's procurement policy should align with 2 CFR section 200.318-327. Condition - The College did not have a policy in place to ensure it was complying with "Never Contract with the Enemy" and verifying that a contractor is not debarred, suspended, or otherwise excluded from doing business with federal assistance programs or activities. In addition, the College's policy does not include all provisions in 2 CFR Section 200 318-327. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The one sample selected for procurement testing was not reviewed to ensure it was in compliance with "Never Contract with the Enemy," and it was not verified that the contractor was not debarred, suspended, or otherwise excluded from doing business with federal assistance programs or activities. The sample met the other requirements of 2 CFR Section 200.318-327, although it is not formally documented in the College's policy. Cause and Effect - The College does not have a control or policy in place to ensure it was in compliance with "Never Contract with the Enemy" and verifying that a contractor is not debarred, suspended, or otherwise excluded from doing business with federal assistance programs or activities. As a result, the College is not reviewing contracts to ensure it is in compliance with the regulation. The College has not updated its procurement policy since 2018 and does not include all Uniform Guidance provisions in the current policy. Recommendation - The College should implement controls and a policy to ensure it is in compliance with "Never Contract with the Enemy" and verify that a contractor is not debarred, suspended, or otherwise excluded from doing business with federal assistance programs or activities. It should also compare the current policy to 2 CFR Section 200.318-327 and update it as it relates to purchases made using federal funds. Views of Responsible Officials and Corrective Action Plan - An Albion College ?Never Contract with the Enemy? policy will be put into place and have the following conditions within the policy: The ?Grants and Foundation Relations Grants Manual? will be updated to include policy information about this federal regulation and how to determine whether a subcontractor/vendor is prohibited under this policy from being paid with federal grant funds. The Grants and Foundation Relations team (?GFRT?) will include the federal regulation in every ?Grants Kickoff Meeting? checklist and will discuss with the Principal Investigators (?PI?s) during grant development so that issues can be addressed at the beginning of federal grant application process. PI?s of the federal grants will be responsible for checking the SAM excluded vendor list as they are finalizing their budget and/or planned expenditures to confirm all subcontractors/vendors are allowed and in good standing, before any contract over $50,000 is executed or any invoice greater than $20,000 is paid. The Business Office will verify that the vendors or subcontractors for federal grants have been checked against the SAM excluded vendor list during the expenditure approval process. In addition, the College with develop a procurement policy that conforms to provisions in 2 CFR Section 200.318-327 and all federal grant recipients should review and adhere to that policy for all purchases and expenditures made with federal grant funds. Consult with GFR or the Business Office if there are questions about these standards and how they may impact federal grant expenditures.
ALN Number, Federal Agency, and Program Name - COVID-19 Education Stabilization Fund - Higher Education Emergency Relief Fund - ALN 84.425F, ALN 84.425M Finding Type - Significant deficiency and material noncompliance with laws and regulations Repeat Finding - No Criteria - The College must minimize the elapsed time between the transfer of funds from the United States Treasury to the College and the disbursement of those funds, as outlined in CFR Section 200.305(b). In addition, CARES Act 18004(e) and CRRSA 314(e) require institutions receiving funds under HEERF I and HEERF Il submit a report to the secretary at such time and in such a manner as the secretary may require. ARP Act 2003 specifies that the same terms and conditions of CRRSA 314 apply to HEERF Ill funds. While the acts do not explicitly identity procedures by which institutions must report their uses of HEERF grant funds, pursuant to these requirements, the U.S. Department of Education required quarterly public reporting of student portion and institutional portion awards and an annual report. Condition - The College drew down an expected amount for the institutional expenditures. The actual expenditures charged to the grant differed from those expected, resulting in the timing of the drawdown to be outside of the cash management regulations. By extension, the institutional quarterly reporting was also incorrect, as it was based on the initial expenditures classifications. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The College drew down $2,725,815 for the institutional aid but did not spend the money within the required time frame allowed in accordance with cash management rules under 2 CFR Section 200.305(b). In addition, the drawdowns did not correspond With the quarterly reporting under CRRSA 314. Cause and Effect - The College used estimates to determine the amount that was eligible to perform the drawdowns through the period. The final expenditures claimed against the grant did not align with the cash drawdowns actually taken, causing exceptions within the cash management and reporting requirements. Recommendation - We recommend the College implement a process to minimize the time elapsed between the transfer of funds from the United States Treasury to the College and disbursement of those funds. In addition, we recommend management amend the quarterly reports to update the quarterly reporting to accurately reflect the changes made by management. Views of Responsible Officials and Corrective Action Plan - The College drew down funds based on expenditures that management deemed to be qualified however, at year-end, concluded to charge other expenditures to the grant causing the mismatch in the timing of drawdowns and final expenditures charged to the grant. Although HEERF and other COVID 19 Pandemic funding has ended, in the future, such expenditures will be discussed and documented prior to the drawing of funds.
ALN Number, Federal Agency, and Program Name - COVID-19 Education Stabilization Fund - Higher Education Emergency Relief Fund - ALN 84.425F, ALN 84.425M Finding Type - Significant deficiency and material noncompliance with laws and regulations Repeat Finding - No Criteria - The College must minimize the elapsed time between the transfer of funds from the United States Treasury to the College and the disbursement of those funds, as outlined in CFR Section 200.305(b). In addition, CARES Act 18004(e) and CRRSA 314(e) require institutions receiving funds under HEERF I and HEERF Il submit a report to the secretary at such time and in such a manner as the secretary may require. ARP Act 2003 specifies that the same terms and conditions of CRRSA 314 apply to HEERF Ill funds. While the acts do not explicitly identity procedures by which institutions must report their uses of HEERF grant funds, pursuant to these requirements, the U.S. Department of Education required quarterly public reporting of student portion and institutional portion awards and an annual report. Condition - The College drew down an expected amount for the institutional expenditures. The actual expenditures charged to the grant differed from those expected, resulting in the timing of the drawdown to be outside of the cash management regulations. By extension, the institutional quarterly reporting was also incorrect, as it was based on the initial expenditures classifications. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The College drew down $2,725,815 for the institutional aid but did not spend the money within the required time frame allowed in accordance with cash management rules under 2 CFR Section 200.305(b). In addition, the drawdowns did not correspond With the quarterly reporting under CRRSA 314. Cause and Effect - The College used estimates to determine the amount that was eligible to perform the drawdowns through the period. The final expenditures claimed against the grant did not align with the cash drawdowns actually taken, causing exceptions within the cash management and reporting requirements. Recommendation - We recommend the College implement a process to minimize the time elapsed between the transfer of funds from the United States Treasury to the College and disbursement of those funds. In addition, we recommend management amend the quarterly reports to update the quarterly reporting to accurately reflect the changes made by management. Views of Responsible Officials and Corrective Action Plan - The College drew down funds based on expenditures that management deemed to be qualified however, at year-end, concluded to charge other expenditures to the grant causing the mismatch in the timing of drawdowns and final expenditures charged to the grant. Although HEERF and other COVID 19 Pandemic funding has ended, in the future, such expenditures will be discussed and documented prior to the drawing of funds.
ALN Number, Federal Agency, and Program Name - COVID-19 Education Stabilization Fund - Higher Education Emergency Relief Fund - CFDA 84.425F Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - Yes - 2021-001 Criteria - The College is required to have a policy in place to ensure it is in compliance with "Never Contract with the Enemy" (2 CFR Part 183) and verifying that a contractor is not debarred, suspended, or otherwise excluded from doing business with federal assistance programs or activities (2 CFR Sections 200.212 and 200.318(h); 2 CFR section 180.300; 48 CFR Section 52.209-6). In addition, the College's procurement policy should align with 2 CFR section 200.318-327. Condition - The College did not have a policy in place to ensure it was complying with "Never Contract with the Enemy" and verifying that a contractor is not debarred, suspended, or otherwise excluded from doing business with federal assistance programs or activities. In addition, the College's policy does not include all provisions in 2 CFR Section 200 318-327. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The one sample selected for procurement testing was not reviewed to ensure it was in compliance with "Never Contract with the Enemy," and it was not verified that the contractor was not debarred, suspended, or otherwise excluded from doing business with federal assistance programs or activities. The sample met the other requirements of 2 CFR Section 200.318-327, although it is not formally documented in the College's policy. Cause and Effect - The College does not have a control or policy in place to ensure it was in compliance with "Never Contract with the Enemy" and verifying that a contractor is not debarred, suspended, or otherwise excluded from doing business with federal assistance programs or activities. As a result, the College is not reviewing contracts to ensure it is in compliance with the regulation. The College has not updated its procurement policy since 2018 and does not include all Uniform Guidance provisions in the current policy. Recommendation - The College should implement controls and a policy to ensure it is in compliance with "Never Contract with the Enemy" and verify that a contractor is not debarred, suspended, or otherwise excluded from doing business with federal assistance programs or activities. It should also compare the current policy to 2 CFR Section 200.318-327 and update it as it relates to purchases made using federal funds. Views of Responsible Officials and Corrective Action Plan - An Albion College ?Never Contract with the Enemy? policy will be put into place and have the following conditions within the policy: The ?Grants and Foundation Relations Grants Manual? will be updated to include policy information about this federal regulation and how to determine whether a subcontractor/vendor is prohibited under this policy from being paid with federal grant funds. The Grants and Foundation Relations team (?GFRT?) will include the federal regulation in every ?Grants Kickoff Meeting? checklist and will discuss with the Principal Investigators (?PI?s) during grant development so that issues can be addressed at the beginning of federal grant application process. PI?s of the federal grants will be responsible for checking the SAM excluded vendor list as they are finalizing their budget and/or planned expenditures to confirm all subcontractors/vendors are allowed and in good standing, before any contract over $50,000 is executed or any invoice greater than $20,000 is paid. The Business Office will verify that the vendors or subcontractors for federal grants have been checked against the SAM excluded vendor list during the expenditure approval process. In addition, the College with develop a procurement policy that conforms to provisions in 2 CFR Section 200.318-327 and all federal grant recipients should review and adhere to that policy for all purchases and expenditures made with federal grant funds. Consult with GFR or the Business Office if there are questions about these standards and how they may impact federal grant expenditures.
ALN Number, Federal Agency, and Program Name - COVID-19 Education Stabilization Fund - Higher Education Emergency Relief Fund - ALN 84.425F, ALN 84.425M Finding Type - Significant deficiency and material noncompliance with laws and regulations Repeat Finding - No Criteria - The College must minimize the elapsed time between the transfer of funds from the United States Treasury to the College and the disbursement of those funds, as outlined in CFR Section 200.305(b). In addition, CARES Act 18004(e) and CRRSA 314(e) require institutions receiving funds under HEERF I and HEERF Il submit a report to the secretary at such time and in such a manner as the secretary may require. ARP Act 2003 specifies that the same terms and conditions of CRRSA 314 apply to HEERF Ill funds. While the acts do not explicitly identity procedures by which institutions must report their uses of HEERF grant funds, pursuant to these requirements, the U.S. Department of Education required quarterly public reporting of student portion and institutional portion awards and an annual report. Condition - The College drew down an expected amount for the institutional expenditures. The actual expenditures charged to the grant differed from those expected, resulting in the timing of the drawdown to be outside of the cash management regulations. By extension, the institutional quarterly reporting was also incorrect, as it was based on the initial expenditures classifications. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The College drew down $2,725,815 for the institutional aid but did not spend the money within the required time frame allowed in accordance with cash management rules under 2 CFR Section 200.305(b). In addition, the drawdowns did not correspond With the quarterly reporting under CRRSA 314. Cause and Effect - The College used estimates to determine the amount that was eligible to perform the drawdowns through the period. The final expenditures claimed against the grant did not align with the cash drawdowns actually taken, causing exceptions within the cash management and reporting requirements. Recommendation - We recommend the College implement a process to minimize the time elapsed between the transfer of funds from the United States Treasury to the College and disbursement of those funds. In addition, we recommend management amend the quarterly reports to update the quarterly reporting to accurately reflect the changes made by management. Views of Responsible Officials and Corrective Action Plan - The College drew down funds based on expenditures that management deemed to be qualified however, at year-end, concluded to charge other expenditures to the grant causing the mismatch in the timing of drawdowns and final expenditures charged to the grant. Although HEERF and other COVID 19 Pandemic funding has ended, in the future, such expenditures will be discussed and documented prior to the drawing of funds.
ALN Number, Federal Agency, and Program Name - COVID-19 Education Stabilization Fund - Higher Education Emergency Relief Fund - ALN 84.425F, ALN 84.425M Finding Type - Significant deficiency and material noncompliance with laws and regulations Repeat Finding - No Criteria - The College must minimize the elapsed time between the transfer of funds from the United States Treasury to the College and the disbursement of those funds, as outlined in CFR Section 200.305(b). In addition, CARES Act 18004(e) and CRRSA 314(e) require institutions receiving funds under HEERF I and HEERF Il submit a report to the secretary at such time and in such a manner as the secretary may require. ARP Act 2003 specifies that the same terms and conditions of CRRSA 314 apply to HEERF Ill funds. While the acts do not explicitly identity procedures by which institutions must report their uses of HEERF grant funds, pursuant to these requirements, the U.S. Department of Education required quarterly public reporting of student portion and institutional portion awards and an annual report. Condition - The College drew down an expected amount for the institutional expenditures. The actual expenditures charged to the grant differed from those expected, resulting in the timing of the drawdown to be outside of the cash management regulations. By extension, the institutional quarterly reporting was also incorrect, as it was based on the initial expenditures classifications. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The College drew down $2,725,815 for the institutional aid but did not spend the money within the required time frame allowed in accordance with cash management rules under 2 CFR Section 200.305(b). In addition, the drawdowns did not correspond With the quarterly reporting under CRRSA 314. Cause and Effect - The College used estimates to determine the amount that was eligible to perform the drawdowns through the period. The final expenditures claimed against the grant did not align with the cash drawdowns actually taken, causing exceptions within the cash management and reporting requirements. Recommendation - We recommend the College implement a process to minimize the time elapsed between the transfer of funds from the United States Treasury to the College and disbursement of those funds. In addition, we recommend management amend the quarterly reports to update the quarterly reporting to accurately reflect the changes made by management. Views of Responsible Officials and Corrective Action Plan - The College drew down funds based on expenditures that management deemed to be qualified however, at year-end, concluded to charge other expenditures to the grant causing the mismatch in the timing of drawdowns and final expenditures charged to the grant. Although HEERF and other COVID 19 Pandemic funding has ended, in the future, such expenditures will be discussed and documented prior to the drawing of funds.