CHARTER TOWNSHIP OF REDFORDLocal Government

Assistance Listing, Federal Agency, and Program Name - 97.044, U.S. Department of Homeland Security, Assistance to Firefighters Grant and 21.027, U.S. Department of Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria - The regulations in 2 CFR Part 180 restrict making federal awards, subawards, and contracts with certain parties that are debarred, suspended, or otherwise excluded from receiving or participating in federal awards. Nonfederal entities may satisfy the criteria prescribed by 2 CFR Part 180 by either checking SAM.gov exclusions, collecting a certification, or adding a clause or condition to the covered transaction with the contracted party. Condition - The Township did not have a control in place to retain evidence that it performed a check to verify the contractors used under these programs were not suspended or debarred. Questioned Costs - None If questioned costs are not determinable, description of why known questioned costs were undetermined or otherwise could not be reported - N/A Identification of How Questioned Costs Were Computed - N/A Context - The Township followed its procurement policy to enter into a contract with both vendors under these grants. However, they failed to maintain documentation regarding the check for suspension and debarment. The Township reviewed the SAM.gov website during testing and confirmed that the vendor was not listed as suspended or disbarred. Cause and Effect - The Township did not retain evidence to support that it had conducted the search for whether the vendors were suspended or debarred prior to entering into the contracts. The lack of control could result in the Township entering into contracts with contractors that are suspended or debarred. Recommendation - We recommend the Township enhance its controls as designed by retaining supporting documentation to support that contractors are not suspended or debarred. Views of Responsible Officials and Corrective Action Plan - The Township agrees with the finding and will work to put controls in place around retaining support for suspension and debarment checks.

Assistance Listing, Federal Agency, and Program Name - 97.044, U.S. Department of Homeland Security, Assistance to Firefighters Grant Federal Award Identification Number and Year - N /A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria - Per 2 CFR 200.303(a), the nonfederal entity must establish and maintain effective internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. These internal controls should be in compliance with the guidance in the "Standards for Internal Control in the Federal Government," issued by the Comptroller General of the United States, or the "Internal Control Integrated Framework," issued by the Committee of Sponsoring Organization of the Treadway Commission (COSO). Condition - The Township did not have the appropriate controls in place to ensure reports and reimbursement requests that were required to be submitted under the grant were complete and accurate as well as ensuring the matching requirement was properly reviewed. If questioned costs are not determinable, description of why known questioned costs were undetermined or otherwise could not be reported - N/A Identification of How Questioned Costs Were Computed - N/A Context - During testing of required reporting, as well as reimbursement requests submitted, it was noted that there was no evidence of supervisory reviews prior to submission of these documents. It was also noted there was no review in place over the matching requirment. Cause and Effect - The Township did not have the proper controls in place that lead to lack of appropriate reviews of reporting and requests for reimbursement could have resulted in instances of noncompliance. Recommendation - The Township should review its processes and controls in these areas to ensure that all reporting and reimbursement requests are appropriately reviewed. Views of Responsible Officials and Planned Corrective Actions - The Township agrees with the finding and will work to put controls in place to ensure reviews are performed appropriately.

ALN, Federal Agency, and Program Name - 14.218, U.S. Dept. of Housing and Community Development, Community Development Block Grants/Entitlement Grant Federal Award Identification Number and Year – N/A Pass through Entity – N/A Finding Type – Material weakness and material noncompliance with laws and regulations Repeat Finding – N/A Criteria – The Federal Funding Accountability and Transparency Act as mended by section 6202 of Public Las 110-252 requires recipients of Federal awards to report data using the FFATA Subaward Reporting System (FSRS) Tool. Condition – The Township did not have the appropriate processes and controls in place to ensure that FFATA reports were appropriately submitted. Questioned Costs – N/A If questioned costs are not determinable, description of why known questioned costs were undetermined or otherwise could not be reported- N/A Identification of How Questioned Costs Were Computed - N/A Context – The following table summarizes the transactions examined and the non-compliance identified: Cause and Effect – The Township did not file the proper FFATA leading to the inaccurate reporting of subrecipient agreements entered into during the year. Recommendation The Township should review its processes and controls to ensure when subrecipient agreements are entered into, FFATA reporting is completed. Views of Responsible Officials and Corrective Action Plan - The Township agrees with the finding and will work to put processes and controls in place to ensure FFATA reports are submitted as needed.

Assistance Listing, Federal Agency, and Program Name - 21.027, COVID-19 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - According to 2 CFR section 200.329, entities are required to submit performance reports. Management is responsible for ensuring expenses are allowable and for the accuracy of the reports submitted. Condition - Controls in place were not adequate to ensure expenses were allowable and reported in the proper categories on the performance reports. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - During reporting testing, we noted certain expenses were reported in incorrect categories. During our review of the report submitted for the period of October through December 2023, we noted $531,349 of premium pay costs were included in category 4.1, Public Sector Employees, but should have been included in category 6.1, Provision of Government Services, since premium pay is no longer an allowable expense in category 4.1. Cause and Effect - While the Charter Township did have controls in place around reporting and allowability of expenses, they were not sufficient to ensure expenses were properly recorded on the report in line with changing requirements under the terms of the grant. As a result, reports were not in compliance. Recommendation - We recommend the Charter Township ensure the effectiveness of controls to ensure expenditures get reported properly. Views of Responsible Officials and Corrective Action Plan - The Charter Township agrees with the findings. The Charter Township's management will ensure procedures are put into place to ensure expenditures are reported under the correct categories.

CFDA Number, Federal Agency, and Program Name 21.027, U.S. Department of Treasury, Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year N/A Pass through Entity N/A Finding Type Material weakness and material noncompliance with laws and regulations Repeat Finding No Criteria Per 2 CFR 200.303(a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) Condition During the audit of federal expenditures, it was noted that the Charter Township incorrectly reported project expenditure categories to Treasury. Questioned Costs N/A Identification of How Questioned Costs Were Computed N/A Context Project expenditure category amounts reported by the Township included $114,346 of expenditures reported as Administrative Expenses and Public Sector Capacity: Administrative Needs. The correct categorization of these costs was Public Sector Workforce: Payroll and Benefits for Public Health, Public Safety, or Human Services Workers Cause and Effect The Charter Township's process in place to review reports submitted to Treasury was not effective in identifying the reporting error. This resulted in the Charter Township incorrectly reporting expenditures to Treasury. Recommendation We recommend the Charter Township implement another layer of review to ensure reported costs are accurate. Views of Responsible Officials and Planned Corrective Actions The Charter Township agrees with the finding and will put procedures into place to ensure appropriate layers of review are performed when reporting expenditures.

CFDA Number, Federal Agency, and Program Name - 21.019, U.S. Department of Treasury, COVID 19 Coronavirus Relief Fund Pass through Entity - Michigan Department of Treasury Finding Type - Material weakness Repeat Finding - No Criteria - Reporting should be mathematically accurate and supported by applicable accounting records. Condition - During the audit of federal expenditures, it was noted that the Charter Township incorrectly reported fringe benefit expenses to the State of Michigan on a specific reimbursement request. Questioned Costs - N/A Context - Fringe benefit expenses reported to the State of Michigan included expenditures that were also reported in the gross wage line item of the reimbursement request. Approximately $1.9 million was reported, of which $1.7 million was eligible for reimbursement; the difference was a result of fringe benefit expenses being erroneously double counted on the report. However, due to lack of resources, the State was only able to reimburse approximately $1.2 million. As such, all funds received as part of this grant program were utilized to reimburse the Charter Township for eligible expenditures. Cause and Effect - The Charter Township's process in place to review reimbursement requests did not identify the reporting error. This resulted in the Charter Township incorrectly reporting expenditures in the State of Michigan reimbursement request report. Recommendation - We recommend the Charter Township implement another layer of review to ensure reported costs for reimbursement are accurate. Views of Responsible Officials and Corrective Action Plan - The Charter Township agrees with the finding and will put procedures into place to ensure appropriate layers of review are performed when reporting expenditures.