Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster. Federal Direct Student Loan Program (ALN 84.268) and Federal Pell Grants (ALN 84.063). Federal Award Identification Number and Year - Various.
Pass-through Entity - None.
Finding Type - Significant deficiency.
Repeat Finding - No.
Criteria - If a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance but before he or she has attended 60 percent of the scheduled length of the semester, the school must perform a return of Title IV funds (R2T4) calculation. If the amount disbursed to the student is greater than the amount the student earned, the unearned funds must be returned. A school must return unearned funds for which it is responsible no later than 45 days from the determination of a student's withdrawal (30 days if never attended) (34 CFR 668.220)(1)). When a recipient of Title IV grant or loan assistance withdraws from an institution during a payment period or period of enrollment in which the recipient began attendance, the institution must determine the amount of Title IV aid earned by the student as of the student's withdrawal date. If an institution does not require instructors to take attendance, the withdrawal date is (1) the date, as determined by the institution, that the student began the withdrawal process prescribed by the institution; (2) the date, as determined by the institution, that the student otherwise provided official notification to the institution, in writing or orally, of his or her intent to withdraw; (3) if the student ceases attendance without providing official notification to the institution of his or her withdrawal, the midpoint of the payment period or, if applicable, the period of enrollment; (4) if the institution determines that a student did not begin the withdrawal process or otherwise notify the institution of the intent to withdraw due to illness, accident, grievous personal loss, or other circumstances beyond the student's control, the date the institution determines is related to that circumstance; (5) if a student does not return from an approved leave of absence, the date that the institution determines the student began the leave of absence; or (6) if the student takes an unapproved leave of absence, the date that the student began the leave of absence. Notwithstanding the above, an institution that is not required to take attendance may use as the withdrawal date the last date of attendance at an academically related activity, as documented by the institution (34 CFR668.22(c) and (I)).
Condition - The College used incorrect or incomplete data in the return of Title IV calculations.
Questioned Costs - $1,708
Identification of How Questioned Costs Were Computed - Recalculation of returns was based on accurate student data.
Context - Of the 40 students tested, there were 4 students where a portion of institutional charges (bookstore charges) were not included in the calculation when a Return of TItle IV calculation was performed and 1 student where a calculation was not completed but the student withdrew before the 60 percent completion date. As a result, the College completed updated calculations and properly corrected all 5 of the issues identified, resulting in $1,708 in questioned costs.
Cause and Effect - The College did not have a control in place to ensure all returns of Title IV refunds were reviewed. As a result, certain student Title IV refund calculations were not correctly calculated and returned.
Recommendation - The College should implement controls to ensure returns of Title IV refund calculations are prepared and reviewed to ensure accurate.
Views of Responsible Officials and Planned Corrective Actions - Management agrees with the finding. The College's financial aid department has updated its R2T4 procedure document to highlight steps needed to bring in other charges, such as bookstore, has provided updated training and has recalculated all R2T4's during FY23 where bookstore charges were incurred or calculations were not performed and processed the corrections.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster. Federal Direct Student Loan Program (ALN 84.268) and Federal Pell Grants (ALN 84.063). Federal Award Identification Number and Year - Various.
Pass-through Entity - None.
Finding Type - Significant deficiency.
Repeat Finding - No.
Criteria - If a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance but before he or she has attended 60 percent of the scheduled length of the semester, the school must perform a return of Title IV funds (R2T4) calculation. If the amount disbursed to the student is greater than the amount the student earned, the unearned funds must be returned. A school must return unearned funds for which it is responsible no later than 45 days from the determination of a student's withdrawal (30 days if never attended) (34 CFR 668.220)(1)). When a recipient of Title IV grant or loan assistance withdraws from an institution during a payment period or period of enrollment in which the recipient began attendance, the institution must determine the amount of Title IV aid earned by the student as of the student's withdrawal date. If an institution does not require instructors to take attendance, the withdrawal date is (1) the date, as determined by the institution, that the student began the withdrawal process prescribed by the institution; (2) the date, as determined by the institution, that the student otherwise provided official notification to the institution, in writing or orally, of his or her intent to withdraw; (3) if the student ceases attendance without providing official notification to the institution of his or her withdrawal, the midpoint of the payment period or, if applicable, the period of enrollment; (4) if the institution determines that a student did not begin the withdrawal process or otherwise notify the institution of the intent to withdraw due to illness, accident, grievous personal loss, or other circumstances beyond the student's control, the date the institution determines is related to that circumstance; (5) if a student does not return from an approved leave of absence, the date that the institution determines the student began the leave of absence; or (6) if the student takes an unapproved leave of absence, the date that the student began the leave of absence. Notwithstanding the above, an institution that is not required to take attendance may use as the withdrawal date the last date of attendance at an academically related activity, as documented by the institution (34 CFR668.22(c) and (I)).
Condition - The College used incorrect or incomplete data in the return of Title IV calculations.
Questioned Costs - $1,708
Identification of How Questioned Costs Were Computed - Recalculation of returns was based on accurate student data.
Context - Of the 40 students tested, there were 4 students where a portion of institutional charges (bookstore charges) were not included in the calculation when a Return of TItle IV calculation was performed and 1 student where a calculation was not completed but the student withdrew before the 60 percent completion date. As a result, the College completed updated calculations and properly corrected all 5 of the issues identified, resulting in $1,708 in questioned costs.
Cause and Effect - The College did not have a control in place to ensure all returns of Title IV refunds were reviewed. As a result, certain student Title IV refund calculations were not correctly calculated and returned.
Recommendation - The College should implement controls to ensure returns of Title IV refund calculations are prepared and reviewed to ensure accurate.
Views of Responsible Officials and Planned Corrective Actions - Management agrees with the finding. The College's financial aid department has updated its R2T4 procedure document to highlight steps needed to bring in other charges, such as bookstore, has provided updated training and has recalculated all R2T4's during FY23 where bookstore charges were incurred or calculations were not performed and processed the corrections.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster. Federal Direct Student Loan Program (ALN 84.268) and Federal Pell Grants (ALN 84.063). Federal Award Identification Number and Year - Various.
Pass-through Entity - None.
Finding Type - Significant deficiency.
Repeat Finding - No.
Criteria - If a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance but before he or she has attended 60 percent of the scheduled length of the semester, the school must perform a return of Title IV funds (R2T4) calculation. If the amount disbursed to the student is greater than the amount the student earned, the unearned funds must be returned. A school must return unearned funds for which it is responsible no later than 45 days from the determination of a student's withdrawal (30 days if never attended) (34 CFR 668.220)(1)). When a recipient of Title IV grant or loan assistance withdraws from an institution during a payment period or period of enrollment in which the recipient began attendance, the institution must determine the amount of Title IV aid earned by the student as of the student's withdrawal date. If an institution does not require instructors to take attendance, the withdrawal date is (1) the date, as determined by the institution, that the student began the withdrawal process prescribed by the institution; (2) the date, as determined by the institution, that the student otherwise provided official notification to the institution, in writing or orally, of his or her intent to withdraw; (3) if the student ceases attendance without providing official notification to the institution of his or her withdrawal, the midpoint of the payment period or, if applicable, the period of enrollment; (4) if the institution determines that a student did not begin the withdrawal process or otherwise notify the institution of the intent to withdraw due to illness, accident, grievous personal loss, or other circumstances beyond the student's control, the date the institution determines is related to that circumstance; (5) if a student does not return from an approved leave of absence, the date that the institution determines the student began the leave of absence; or (6) if the student takes an unapproved leave of absence, the date that the student began the leave of absence. Notwithstanding the above, an institution that is not required to take attendance may use as the withdrawal date the last date of attendance at an academically related activity, as documented by the institution (34 CFR668.22(c) and (I)).
Condition - The College used incorrect or incomplete data in the return of Title IV calculations.
Questioned Costs - $1,708
Identification of How Questioned Costs Were Computed - Recalculation of returns was based on accurate student data.
Context - Of the 40 students tested, there were 4 students where a portion of institutional charges (bookstore charges) were not included in the calculation when a Return of TItle IV calculation was performed and 1 student where a calculation was not completed but the student withdrew before the 60 percent completion date. As a result, the College completed updated calculations and properly corrected all 5 of the issues identified, resulting in $1,708 in questioned costs.
Cause and Effect - The College did not have a control in place to ensure all returns of Title IV refunds were reviewed. As a result, certain student Title IV refund calculations were not correctly calculated and returned.
Recommendation - The College should implement controls to ensure returns of Title IV refund calculations are prepared and reviewed to ensure accurate.
Views of Responsible Officials and Planned Corrective Actions - Management agrees with the finding. The College's financial aid department has updated its R2T4 procedure document to highlight steps needed to bring in other charges, such as bookstore, has provided updated training and has recalculated all R2T4's during FY23 where bookstore charges were incurred or calculations were not performed and processed the corrections.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster. Federal Direct Student Loan Program (ALN 84.268) and Federal Pell Grants (ALN 84.063). Federal Award Identification Number and Year - Various.
Pass-through Entity - None.
Finding Type - Significant deficiency.
Repeat Finding - No.
Criteria - If a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance but before he or she has attended 60 percent of the scheduled length of the semester, the school must perform a return of Title IV funds (R2T4) calculation. If the amount disbursed to the student is greater than the amount the student earned, the unearned funds must be returned. A school must return unearned funds for which it is responsible no later than 45 days from the determination of a student's withdrawal (30 days if never attended) (34 CFR 668.220)(1)). When a recipient of Title IV grant or loan assistance withdraws from an institution during a payment period or period of enrollment in which the recipient began attendance, the institution must determine the amount of Title IV aid earned by the student as of the student's withdrawal date. If an institution does not require instructors to take attendance, the withdrawal date is (1) the date, as determined by the institution, that the student began the withdrawal process prescribed by the institution; (2) the date, as determined by the institution, that the student otherwise provided official notification to the institution, in writing or orally, of his or her intent to withdraw; (3) if the student ceases attendance without providing official notification to the institution of his or her withdrawal, the midpoint of the payment period or, if applicable, the period of enrollment; (4) if the institution determines that a student did not begin the withdrawal process or otherwise notify the institution of the intent to withdraw due to illness, accident, grievous personal loss, or other circumstances beyond the student's control, the date the institution determines is related to that circumstance; (5) if a student does not return from an approved leave of absence, the date that the institution determines the student began the leave of absence; or (6) if the student takes an unapproved leave of absence, the date that the student began the leave of absence. Notwithstanding the above, an institution that is not required to take attendance may use as the withdrawal date the last date of attendance at an academically related activity, as documented by the institution (34 CFR668.22(c) and (I)).
Condition - The College used incorrect or incomplete data in the return of Title IV calculations.
Questioned Costs - $1,708
Identification of How Questioned Costs Were Computed - Recalculation of returns was based on accurate student data.
Context - Of the 40 students tested, there were 4 students where a portion of institutional charges (bookstore charges) were not included in the calculation when a Return of TItle IV calculation was performed and 1 student where a calculation was not completed but the student withdrew before the 60 percent completion date. As a result, the College completed updated calculations and properly corrected all 5 of the issues identified, resulting in $1,708 in questioned costs.
Cause and Effect - The College did not have a control in place to ensure all returns of Title IV refunds were reviewed. As a result, certain student Title IV refund calculations were not correctly calculated and returned.
Recommendation - The College should implement controls to ensure returns of Title IV refund calculations are prepared and reviewed to ensure accurate.
Views of Responsible Officials and Planned Corrective Actions - Management agrees with the finding. The College's financial aid department has updated its R2T4 procedure document to highlight steps needed to bring in other charges, such as bookstore, has provided updated training and has recalculated all R2T4's during FY23 where bookstore charges were incurred or calculations were not performed and processed the corrections.
Assistance Listing Number, Federal Agency, and Program Name - U.S. Department of Labor H-1B Job Training Grants (ALN 17.268) and WIA/WIOA Pilots, Demonstrations, and Research Projects Strengthening Community Colleges Training Grants (ALN 17.261). Federal Award Identification Number and Year - HG-35916-21-60-A-26 and MI-35900-21-60-A-26.
Pass-through Entity - None.
Finding Type - Significant deficiency.
Repeat Finding - No.
Criteria - A passthrough entity must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification: (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass through entity, and contact information for awarding official of the Pass through entity; (xii) Assistance Listings number and Title; the pass through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (2 CFR 200.332(a)). In addition, 2 CFR 200.332(d) states grantees are required to "Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved.
Condition - The College had the following issues noted: (1) It did not include items (1)(ii) subrecipient's unique unique entity identifier and (1)(xi) Name of federal awarding agency, passthrough entity or contact information within their subrecipient agreement; (2) It was not monitoring the subrecipient budgets and performance plans to ensure objectives were met; and (3) It was not monitoring financial expenditures that were below planned thresholds.
Questioned Costs - None.
Context - There were 5 subrecipients for grant #17.268 and 6 subrecipients for grant #17.671. There was approval and review of expenditures submitted by all subrecipients on a timely basis. In addition, each subrecipient is required to complete and submit a quarterly narrative performance report which the College uses to prepare the quarterly narrative performance report submitted to the granting agency.
Cause and Effect - The College did not have a system in place to monitor actual performance and financial measures against the planned activity as outlined in the subrecipient and grant agreements. The College was also not documenting the results of site visits of the subrecipients.
Recommendation - The College should implement controls to have subrecipients track and report perfornance and financial for planned versus actual reporting on a monthly or quarterly basis. In addition, the College should complete a written report summarizing the results of each onsite visit to its subrecipients as required under Uniform Guidance.
Views of Responsible Officials and Corrective Action Plan - Management agrees with the finding. The College has implemented a new Grants Administration Guide which covered initial risk assessment, subrecipient determination, subaward agreements, monitoring subrecipients and subrecipient reimbursements. In addition, the College has developed monthly metric reports for planned vs. actual outcomes which is to be completed by each subrecipient. The College has also scheduled formal site visits with each subrecipient to cover Financial status, metric verification, narrative overview and participant records and evaluation. A tool has been developed to summarize each site visit with recommendations. A written report will be provided to the subrecipients after each site visit.
Assistance Listing Number, Federal Agency, and Program Name - U.S. Department of Labor H-1B Job Training Grants (ALN 17.268) and WIA/WIOA Pilots, Demonstrations, and Research Projects Strengthening Community Colleges Training Grants (ALN 17.261). Federal Award Identification Number and Year - HG-35916-21-60-A-26 and MI-35900-21-60-A-26.
Pass-through Entity - None.
Finding Type - Significant deficiency.
Repeat Finding - No.
Criteria - A passthrough entity must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification: (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass through entity, and contact information for awarding official of the Pass through entity; (xii) Assistance Listings number and Title; the pass through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (2 CFR 200.332(a)). In addition, 2 CFR 200.332(d) states grantees are required to "Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved.
Condition - The College had the following issues noted: (1) It did not include items (1)(ii) subrecipient's unique unique entity identifier and (1)(xi) Name of federal awarding agency, passthrough entity or contact information within their subrecipient agreement; (2) It was not monitoring the subrecipient budgets and performance plans to ensure objectives were met; and (3) It was not monitoring financial expenditures that were below planned thresholds.
Questioned Costs - None.
Context - There were 5 subrecipients for grant #17.268 and 6 subrecipients for grant #17.671. There was approval and review of expenditures submitted by all subrecipients on a timely basis. In addition, each subrecipient is required to complete and submit a quarterly narrative performance report which the College uses to prepare the quarterly narrative performance report submitted to the granting agency.
Cause and Effect - The College did not have a system in place to monitor actual performance and financial measures against the planned activity as outlined in the subrecipient and grant agreements. The College was also not documenting the results of site visits of the subrecipients.
Recommendation - The College should implement controls to have subrecipients track and report perfornance and financial for planned versus actual reporting on a monthly or quarterly basis. In addition, the College should complete a written report summarizing the results of each onsite visit to its subrecipients as required under Uniform Guidance.
Views of Responsible Officials and Corrective Action Plan - Management agrees with the finding. The College has implemented a new Grants Administration Guide which covered initial risk assessment, subrecipient determination, subaward agreements, monitoring subrecipients and subrecipient reimbursements. In addition, the College has developed monthly metric reports for planned vs. actual outcomes which is to be completed by each subrecipient. The College has also scheduled formal site visits with each subrecipient to cover Financial status, metric verification, narrative overview and participant records and evaluation. A tool has been developed to summarize each site visit with recommendations. A written report will be provided to the subrecipients after each site visit.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster. Federal Direct Student Loan Program (ALN 84.268) and Federal Pell Grants (ALN 84.063). Federal Award Identification Number and Year - Various.
Pass-through Entity - None.
Finding Type - Significant deficiency.
Repeat Finding - No.
Criteria - If a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance but before he or she has attended 60 percent of the scheduled length of the semester, the school must perform a return of Title IV funds (R2T4) calculation. If the amount disbursed to the student is greater than the amount the student earned, the unearned funds must be returned. A school must return unearned funds for which it is responsible no later than 45 days from the determination of a student's withdrawal (30 days if never attended) (34 CFR 668.220)(1)). When a recipient of Title IV grant or loan assistance withdraws from an institution during a payment period or period of enrollment in which the recipient began attendance, the institution must determine the amount of Title IV aid earned by the student as of the student's withdrawal date. If an institution does not require instructors to take attendance, the withdrawal date is (1) the date, as determined by the institution, that the student began the withdrawal process prescribed by the institution; (2) the date, as determined by the institution, that the student otherwise provided official notification to the institution, in writing or orally, of his or her intent to withdraw; (3) if the student ceases attendance without providing official notification to the institution of his or her withdrawal, the midpoint of the payment period or, if applicable, the period of enrollment; (4) if the institution determines that a student did not begin the withdrawal process or otherwise notify the institution of the intent to withdraw due to illness, accident, grievous personal loss, or other circumstances beyond the student's control, the date the institution determines is related to that circumstance; (5) if a student does not return from an approved leave of absence, the date that the institution determines the student began the leave of absence; or (6) if the student takes an unapproved leave of absence, the date that the student began the leave of absence. Notwithstanding the above, an institution that is not required to take attendance may use as the withdrawal date the last date of attendance at an academically related activity, as documented by the institution (34 CFR668.22(c) and (I)).
Condition - The College used incorrect or incomplete data in the return of Title IV calculations.
Questioned Costs - $1,708
Identification of How Questioned Costs Were Computed - Recalculation of returns was based on accurate student data.
Context - Of the 40 students tested, there were 4 students where a portion of institutional charges (bookstore charges) were not included in the calculation when a Return of TItle IV calculation was performed and 1 student where a calculation was not completed but the student withdrew before the 60 percent completion date. As a result, the College completed updated calculations and properly corrected all 5 of the issues identified, resulting in $1,708 in questioned costs.
Cause and Effect - The College did not have a control in place to ensure all returns of Title IV refunds were reviewed. As a result, certain student Title IV refund calculations were not correctly calculated and returned.
Recommendation - The College should implement controls to ensure returns of Title IV refund calculations are prepared and reviewed to ensure accurate.
Views of Responsible Officials and Planned Corrective Actions - Management agrees with the finding. The College's financial aid department has updated its R2T4 procedure document to highlight steps needed to bring in other charges, such as bookstore, has provided updated training and has recalculated all R2T4's during FY23 where bookstore charges were incurred or calculations were not performed and processed the corrections.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster. Federal Direct Student Loan Program (ALN 84.268) and Federal Pell Grants (ALN 84.063). Federal Award Identification Number and Year - Various.
Pass-through Entity - None.
Finding Type - Significant deficiency.
Repeat Finding - No.
Criteria - If a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance but before he or she has attended 60 percent of the scheduled length of the semester, the school must perform a return of Title IV funds (R2T4) calculation. If the amount disbursed to the student is greater than the amount the student earned, the unearned funds must be returned. A school must return unearned funds for which it is responsible no later than 45 days from the determination of a student's withdrawal (30 days if never attended) (34 CFR 668.220)(1)). When a recipient of Title IV grant or loan assistance withdraws from an institution during a payment period or period of enrollment in which the recipient began attendance, the institution must determine the amount of Title IV aid earned by the student as of the student's withdrawal date. If an institution does not require instructors to take attendance, the withdrawal date is (1) the date, as determined by the institution, that the student began the withdrawal process prescribed by the institution; (2) the date, as determined by the institution, that the student otherwise provided official notification to the institution, in writing or orally, of his or her intent to withdraw; (3) if the student ceases attendance without providing official notification to the institution of his or her withdrawal, the midpoint of the payment period or, if applicable, the period of enrollment; (4) if the institution determines that a student did not begin the withdrawal process or otherwise notify the institution of the intent to withdraw due to illness, accident, grievous personal loss, or other circumstances beyond the student's control, the date the institution determines is related to that circumstance; (5) if a student does not return from an approved leave of absence, the date that the institution determines the student began the leave of absence; or (6) if the student takes an unapproved leave of absence, the date that the student began the leave of absence. Notwithstanding the above, an institution that is not required to take attendance may use as the withdrawal date the last date of attendance at an academically related activity, as documented by the institution (34 CFR668.22(c) and (I)).
Condition - The College used incorrect or incomplete data in the return of Title IV calculations.
Questioned Costs - $1,708
Identification of How Questioned Costs Were Computed - Recalculation of returns was based on accurate student data.
Context - Of the 40 students tested, there were 4 students where a portion of institutional charges (bookstore charges) were not included in the calculation when a Return of TItle IV calculation was performed and 1 student where a calculation was not completed but the student withdrew before the 60 percent completion date. As a result, the College completed updated calculations and properly corrected all 5 of the issues identified, resulting in $1,708 in questioned costs.
Cause and Effect - The College did not have a control in place to ensure all returns of Title IV refunds were reviewed. As a result, certain student Title IV refund calculations were not correctly calculated and returned.
Recommendation - The College should implement controls to ensure returns of Title IV refund calculations are prepared and reviewed to ensure accurate.
Views of Responsible Officials and Planned Corrective Actions - Management agrees with the finding. The College's financial aid department has updated its R2T4 procedure document to highlight steps needed to bring in other charges, such as bookstore, has provided updated training and has recalculated all R2T4's during FY23 where bookstore charges were incurred or calculations were not performed and processed the corrections.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster. Federal Direct Student Loan Program (ALN 84.268) and Federal Pell Grants (ALN 84.063). Federal Award Identification Number and Year - Various.
Pass-through Entity - None.
Finding Type - Significant deficiency.
Repeat Finding - No.
Criteria - If a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance but before he or she has attended 60 percent of the scheduled length of the semester, the school must perform a return of Title IV funds (R2T4) calculation. If the amount disbursed to the student is greater than the amount the student earned, the unearned funds must be returned. A school must return unearned funds for which it is responsible no later than 45 days from the determination of a student's withdrawal (30 days if never attended) (34 CFR 668.220)(1)). When a recipient of Title IV grant or loan assistance withdraws from an institution during a payment period or period of enrollment in which the recipient began attendance, the institution must determine the amount of Title IV aid earned by the student as of the student's withdrawal date. If an institution does not require instructors to take attendance, the withdrawal date is (1) the date, as determined by the institution, that the student began the withdrawal process prescribed by the institution; (2) the date, as determined by the institution, that the student otherwise provided official notification to the institution, in writing or orally, of his or her intent to withdraw; (3) if the student ceases attendance without providing official notification to the institution of his or her withdrawal, the midpoint of the payment period or, if applicable, the period of enrollment; (4) if the institution determines that a student did not begin the withdrawal process or otherwise notify the institution of the intent to withdraw due to illness, accident, grievous personal loss, or other circumstances beyond the student's control, the date the institution determines is related to that circumstance; (5) if a student does not return from an approved leave of absence, the date that the institution determines the student began the leave of absence; or (6) if the student takes an unapproved leave of absence, the date that the student began the leave of absence. Notwithstanding the above, an institution that is not required to take attendance may use as the withdrawal date the last date of attendance at an academically related activity, as documented by the institution (34 CFR668.22(c) and (I)).
Condition - The College used incorrect or incomplete data in the return of Title IV calculations.
Questioned Costs - $1,708
Identification of How Questioned Costs Were Computed - Recalculation of returns was based on accurate student data.
Context - Of the 40 students tested, there were 4 students where a portion of institutional charges (bookstore charges) were not included in the calculation when a Return of TItle IV calculation was performed and 1 student where a calculation was not completed but the student withdrew before the 60 percent completion date. As a result, the College completed updated calculations and properly corrected all 5 of the issues identified, resulting in $1,708 in questioned costs.
Cause and Effect - The College did not have a control in place to ensure all returns of Title IV refunds were reviewed. As a result, certain student Title IV refund calculations were not correctly calculated and returned.
Recommendation - The College should implement controls to ensure returns of Title IV refund calculations are prepared and reviewed to ensure accurate.
Views of Responsible Officials and Planned Corrective Actions - Management agrees with the finding. The College's financial aid department has updated its R2T4 procedure document to highlight steps needed to bring in other charges, such as bookstore, has provided updated training and has recalculated all R2T4's during FY23 where bookstore charges were incurred or calculations were not performed and processed the corrections.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster. Federal Direct Student Loan Program (ALN 84.268) and Federal Pell Grants (ALN 84.063). Federal Award Identification Number and Year - Various.
Pass-through Entity - None.
Finding Type - Significant deficiency.
Repeat Finding - No.
Criteria - If a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance but before he or she has attended 60 percent of the scheduled length of the semester, the school must perform a return of Title IV funds (R2T4) calculation. If the amount disbursed to the student is greater than the amount the student earned, the unearned funds must be returned. A school must return unearned funds for which it is responsible no later than 45 days from the determination of a student's withdrawal (30 days if never attended) (34 CFR 668.220)(1)). When a recipient of Title IV grant or loan assistance withdraws from an institution during a payment period or period of enrollment in which the recipient began attendance, the institution must determine the amount of Title IV aid earned by the student as of the student's withdrawal date. If an institution does not require instructors to take attendance, the withdrawal date is (1) the date, as determined by the institution, that the student began the withdrawal process prescribed by the institution; (2) the date, as determined by the institution, that the student otherwise provided official notification to the institution, in writing or orally, of his or her intent to withdraw; (3) if the student ceases attendance without providing official notification to the institution of his or her withdrawal, the midpoint of the payment period or, if applicable, the period of enrollment; (4) if the institution determines that a student did not begin the withdrawal process or otherwise notify the institution of the intent to withdraw due to illness, accident, grievous personal loss, or other circumstances beyond the student's control, the date the institution determines is related to that circumstance; (5) if a student does not return from an approved leave of absence, the date that the institution determines the student began the leave of absence; or (6) if the student takes an unapproved leave of absence, the date that the student began the leave of absence. Notwithstanding the above, an institution that is not required to take attendance may use as the withdrawal date the last date of attendance at an academically related activity, as documented by the institution (34 CFR668.22(c) and (I)).
Condition - The College used incorrect or incomplete data in the return of Title IV calculations.
Questioned Costs - $1,708
Identification of How Questioned Costs Were Computed - Recalculation of returns was based on accurate student data.
Context - Of the 40 students tested, there were 4 students where a portion of institutional charges (bookstore charges) were not included in the calculation when a Return of TItle IV calculation was performed and 1 student where a calculation was not completed but the student withdrew before the 60 percent completion date. As a result, the College completed updated calculations and properly corrected all 5 of the issues identified, resulting in $1,708 in questioned costs.
Cause and Effect - The College did not have a control in place to ensure all returns of Title IV refunds were reviewed. As a result, certain student Title IV refund calculations were not correctly calculated and returned.
Recommendation - The College should implement controls to ensure returns of Title IV refund calculations are prepared and reviewed to ensure accurate.
Views of Responsible Officials and Planned Corrective Actions - Management agrees with the finding. The College's financial aid department has updated its R2T4 procedure document to highlight steps needed to bring in other charges, such as bookstore, has provided updated training and has recalculated all R2T4's during FY23 where bookstore charges were incurred or calculations were not performed and processed the corrections.
Assistance Listing Number, Federal Agency, and Program Name - U.S. Department of Labor H-1B Job Training Grants (ALN 17.268) and WIA/WIOA Pilots, Demonstrations, and Research Projects Strengthening Community Colleges Training Grants (ALN 17.261). Federal Award Identification Number and Year - HG-35916-21-60-A-26 and MI-35900-21-60-A-26.
Pass-through Entity - None.
Finding Type - Significant deficiency.
Repeat Finding - No.
Criteria - A passthrough entity must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification: (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass through entity, and contact information for awarding official of the Pass through entity; (xii) Assistance Listings number and Title; the pass through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (2 CFR 200.332(a)). In addition, 2 CFR 200.332(d) states grantees are required to "Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved.
Condition - The College had the following issues noted: (1) It did not include items (1)(ii) subrecipient's unique unique entity identifier and (1)(xi) Name of federal awarding agency, passthrough entity or contact information within their subrecipient agreement; (2) It was not monitoring the subrecipient budgets and performance plans to ensure objectives were met; and (3) It was not monitoring financial expenditures that were below planned thresholds.
Questioned Costs - None.
Context - There were 5 subrecipients for grant #17.268 and 6 subrecipients for grant #17.671. There was approval and review of expenditures submitted by all subrecipients on a timely basis. In addition, each subrecipient is required to complete and submit a quarterly narrative performance report which the College uses to prepare the quarterly narrative performance report submitted to the granting agency.
Cause and Effect - The College did not have a system in place to monitor actual performance and financial measures against the planned activity as outlined in the subrecipient and grant agreements. The College was also not documenting the results of site visits of the subrecipients.
Recommendation - The College should implement controls to have subrecipients track and report perfornance and financial for planned versus actual reporting on a monthly or quarterly basis. In addition, the College should complete a written report summarizing the results of each onsite visit to its subrecipients as required under Uniform Guidance.
Views of Responsible Officials and Corrective Action Plan - Management agrees with the finding. The College has implemented a new Grants Administration Guide which covered initial risk assessment, subrecipient determination, subaward agreements, monitoring subrecipients and subrecipient reimbursements. In addition, the College has developed monthly metric reports for planned vs. actual outcomes which is to be completed by each subrecipient. The College has also scheduled formal site visits with each subrecipient to cover Financial status, metric verification, narrative overview and participant records and evaluation. A tool has been developed to summarize each site visit with recommendations. A written report will be provided to the subrecipients after each site visit.
Assistance Listing Number, Federal Agency, and Program Name - U.S. Department of Labor H-1B Job Training Grants (ALN 17.268) and WIA/WIOA Pilots, Demonstrations, and Research Projects Strengthening Community Colleges Training Grants (ALN 17.261). Federal Award Identification Number and Year - HG-35916-21-60-A-26 and MI-35900-21-60-A-26.
Pass-through Entity - None.
Finding Type - Significant deficiency.
Repeat Finding - No.
Criteria - A passthrough entity must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification: (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass through entity, and contact information for awarding official of the Pass through entity; (xii) Assistance Listings number and Title; the pass through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (2 CFR 200.332(a)). In addition, 2 CFR 200.332(d) states grantees are required to "Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved.
Condition - The College had the following issues noted: (1) It did not include items (1)(ii) subrecipient's unique unique entity identifier and (1)(xi) Name of federal awarding agency, passthrough entity or contact information within their subrecipient agreement; (2) It was not monitoring the subrecipient budgets and performance plans to ensure objectives were met; and (3) It was not monitoring financial expenditures that were below planned thresholds.
Questioned Costs - None.
Context - There were 5 subrecipients for grant #17.268 and 6 subrecipients for grant #17.671. There was approval and review of expenditures submitted by all subrecipients on a timely basis. In addition, each subrecipient is required to complete and submit a quarterly narrative performance report which the College uses to prepare the quarterly narrative performance report submitted to the granting agency.
Cause and Effect - The College did not have a system in place to monitor actual performance and financial measures against the planned activity as outlined in the subrecipient and grant agreements. The College was also not documenting the results of site visits of the subrecipients.
Recommendation - The College should implement controls to have subrecipients track and report perfornance and financial for planned versus actual reporting on a monthly or quarterly basis. In addition, the College should complete a written report summarizing the results of each onsite visit to its subrecipients as required under Uniform Guidance.
Views of Responsible Officials and Corrective Action Plan - Management agrees with the finding. The College has implemented a new Grants Administration Guide which covered initial risk assessment, subrecipient determination, subaward agreements, monitoring subrecipients and subrecipient reimbursements. In addition, the College has developed monthly metric reports for planned vs. actual outcomes which is to be completed by each subrecipient. The College has also scheduled formal site visits with each subrecipient to cover Financial status, metric verification, narrative overview and participant records and evaluation. A tool has been developed to summarize each site visit with recommendations. A written report will be provided to the subrecipients after each site visit.