Audit 333939

FY End
2024-06-30
Total Expended
$6.60M
Findings
10
Programs
21
Organization: City of Dearborn, Michigan (MI)
Year: 2024 Accepted: 2024-12-19

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
516118 2024-001 Material Weakness - I
516119 2024-001 Material Weakness - I
516120 2024-001 Material Weakness - I
516121 2024-001 Material Weakness - I
516122 2024-001 Material Weakness - I
1092560 2024-001 Material Weakness - I
1092561 2024-001 Material Weakness - I
1092562 2024-001 Material Weakness - I
1092563 2024-001 Material Weakness - I
1092564 2024-001 Material Weakness - I

Contacts

Name Title Type
NY79MWUNAL37 Michael Kennedy Auditee
3139432485 Timothy St. Andrew Auditor
No contacts on file

Notes to SEFA

Title: Noncash Assistance Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of the City of Dearborn, Michigan (the “City”) under programs of the federal government for the year ended June 30, 2024. 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 City, it is not intended to and does not present the financial position, changes in net position, or cash flows of the City. Expenditures reported in the Schedule are reported on the same basis of accounting as the basic financial statements. 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 City has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs, as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs, as allowed under the Uniform Guidance. The value of the noncash assistance received was determined in accordance with the provisions of the Uniform Guidance. The City has $65,085 of noncash assistance related to the Food Distribution Cluster (ALN 10.569) during the year ended June 30, 2024 that is included in the schedule of expenditures of federal awards.

Finding Details

Assistance Listing Number, Federal Agency, and Program Name - 97.044, U.S. Department of Homeland Security, Assistance to Firefighters Grant Federal Award Identification Number and Year - Not available Pass through Entity - Not applicable Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - Per 2 CFR 200.214, nonfederal entities are subject to the nonprocurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, as well as 2 CFR part 180. 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. Condition - The City could not provide evidence that it performed a check to verify contractors were not suspended or debarred. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The City used the grant to procure goods and services from 13 different contractors and was unable to provide evidence that the check for suspension and debarment was completed prior to entering into a contract with them. Cause and Effect - The City did not retain evidence to support that it had conducted the search for whether a contractor was suspended or debarred prior to entering into a contract. Subsequently, the City did complete the search on Sam.gov and retained evidence to support that the contractor was not suspended of debarred, thereby creating no questioned costs. Recommendation - We recommend the City strengthen its controls to ensure documentation is maintained to support that contractors are not suspended or debarred. Views of Responsible Officials and Corrective Action Plan - This item relates to turnover and transition within the purchasing division of the City during the last two years for all of the staff finalizing procurement matters that were replaced due to resignations and retirements. Upon notification of the deficiency, a root cause investigation on the actions involved during the grant procurement were performed to identify cause. The outcome of this investigation will be communicated as educational training within the finance department, which includes purchasing division, operating departmental procurement requestors using federal grant awards, and all accountants. Additionally, management has amended the standard policy for the City to ensure all federal monies are used in accordance with 2 CFR requirements.
Assistance Listing Number, Federal Agency, and Program Name - 97.044, U.S. Department of Homeland Security, Assistance to Firefighters Grant Federal Award Identification Number and Year - Not available Pass through Entity - Not applicable Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - Per 2 CFR 200.214, nonfederal entities are subject to the nonprocurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, as well as 2 CFR part 180. 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. Condition - The City could not provide evidence that it performed a check to verify contractors were not suspended or debarred. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The City used the grant to procure goods and services from 13 different contractors and was unable to provide evidence that the check for suspension and debarment was completed prior to entering into a contract with them. Cause and Effect - The City did not retain evidence to support that it had conducted the search for whether a contractor was suspended or debarred prior to entering into a contract. Subsequently, the City did complete the search on Sam.gov and retained evidence to support that the contractor was not suspended of debarred, thereby creating no questioned costs. Recommendation - We recommend the City strengthen its controls to ensure documentation is maintained to support that contractors are not suspended or debarred. Views of Responsible Officials and Corrective Action Plan - This item relates to turnover and transition within the purchasing division of the City during the last two years for all of the staff finalizing procurement matters that were replaced due to resignations and retirements. Upon notification of the deficiency, a root cause investigation on the actions involved during the grant procurement were performed to identify cause. The outcome of this investigation will be communicated as educational training within the finance department, which includes purchasing division, operating departmental procurement requestors using federal grant awards, and all accountants. Additionally, management has amended the standard policy for the City to ensure all federal monies are used in accordance with 2 CFR requirements.
Assistance Listing Number, Federal Agency, and Program Name - 97.044, U.S. Department of Homeland Security, Assistance to Firefighters Grant Federal Award Identification Number and Year - Not available Pass through Entity - Not applicable Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - Per 2 CFR 200.214, nonfederal entities are subject to the nonprocurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, as well as 2 CFR part 180. 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. Condition - The City could not provide evidence that it performed a check to verify contractors were not suspended or debarred. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The City used the grant to procure goods and services from 13 different contractors and was unable to provide evidence that the check for suspension and debarment was completed prior to entering into a contract with them. Cause and Effect - The City did not retain evidence to support that it had conducted the search for whether a contractor was suspended or debarred prior to entering into a contract. Subsequently, the City did complete the search on Sam.gov and retained evidence to support that the contractor was not suspended of debarred, thereby creating no questioned costs. Recommendation - We recommend the City strengthen its controls to ensure documentation is maintained to support that contractors are not suspended or debarred. Views of Responsible Officials and Corrective Action Plan - This item relates to turnover and transition within the purchasing division of the City during the last two years for all of the staff finalizing procurement matters that were replaced due to resignations and retirements. Upon notification of the deficiency, a root cause investigation on the actions involved during the grant procurement were performed to identify cause. The outcome of this investigation will be communicated as educational training within the finance department, which includes purchasing division, operating departmental procurement requestors using federal grant awards, and all accountants. Additionally, management has amended the standard policy for the City to ensure all federal monies are used in accordance with 2 CFR requirements.
Assistance Listing Number, Federal Agency, and Program Name - 97.044, U.S. Department of Homeland Security, Assistance to Firefighters Grant Federal Award Identification Number and Year - Not available Pass through Entity - Not applicable Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - Per 2 CFR 200.214, nonfederal entities are subject to the nonprocurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, as well as 2 CFR part 180. 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. Condition - The City could not provide evidence that it performed a check to verify contractors were not suspended or debarred. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The City used the grant to procure goods and services from 13 different contractors and was unable to provide evidence that the check for suspension and debarment was completed prior to entering into a contract with them. Cause and Effect - The City did not retain evidence to support that it had conducted the search for whether a contractor was suspended or debarred prior to entering into a contract. Subsequently, the City did complete the search on Sam.gov and retained evidence to support that the contractor was not suspended of debarred, thereby creating no questioned costs. Recommendation - We recommend the City strengthen its controls to ensure documentation is maintained to support that contractors are not suspended or debarred. Views of Responsible Officials and Corrective Action Plan - This item relates to turnover and transition within the purchasing division of the City during the last two years for all of the staff finalizing procurement matters that were replaced due to resignations and retirements. Upon notification of the deficiency, a root cause investigation on the actions involved during the grant procurement were performed to identify cause. The outcome of this investigation will be communicated as educational training within the finance department, which includes purchasing division, operating departmental procurement requestors using federal grant awards, and all accountants. Additionally, management has amended the standard policy for the City to ensure all federal monies are used in accordance with 2 CFR requirements.
Assistance Listing Number, Federal Agency, and Program Name - 97.044, U.S. Department of Homeland Security, Assistance to Firefighters Grant Federal Award Identification Number and Year - Not available Pass through Entity - Not applicable Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - Per 2 CFR 200.214, nonfederal entities are subject to the nonprocurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, as well as 2 CFR part 180. 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. Condition - The City could not provide evidence that it performed a check to verify contractors were not suspended or debarred. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The City used the grant to procure goods and services from 13 different contractors and was unable to provide evidence that the check for suspension and debarment was completed prior to entering into a contract with them. Cause and Effect - The City did not retain evidence to support that it had conducted the search for whether a contractor was suspended or debarred prior to entering into a contract. Subsequently, the City did complete the search on Sam.gov and retained evidence to support that the contractor was not suspended of debarred, thereby creating no questioned costs. Recommendation - We recommend the City strengthen its controls to ensure documentation is maintained to support that contractors are not suspended or debarred. Views of Responsible Officials and Corrective Action Plan - This item relates to turnover and transition within the purchasing division of the City during the last two years for all of the staff finalizing procurement matters that were replaced due to resignations and retirements. Upon notification of the deficiency, a root cause investigation on the actions involved during the grant procurement were performed to identify cause. The outcome of this investigation will be communicated as educational training within the finance department, which includes purchasing division, operating departmental procurement requestors using federal grant awards, and all accountants. Additionally, management has amended the standard policy for the City to ensure all federal monies are used in accordance with 2 CFR requirements.
Assistance Listing Number, Federal Agency, and Program Name - 97.044, U.S. Department of Homeland Security, Assistance to Firefighters Grant Federal Award Identification Number and Year - Not available Pass through Entity - Not applicable Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - Per 2 CFR 200.214, nonfederal entities are subject to the nonprocurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, as well as 2 CFR part 180. 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. Condition - The City could not provide evidence that it performed a check to verify contractors were not suspended or debarred. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The City used the grant to procure goods and services from 13 different contractors and was unable to provide evidence that the check for suspension and debarment was completed prior to entering into a contract with them. Cause and Effect - The City did not retain evidence to support that it had conducted the search for whether a contractor was suspended or debarred prior to entering into a contract. Subsequently, the City did complete the search on Sam.gov and retained evidence to support that the contractor was not suspended of debarred, thereby creating no questioned costs. Recommendation - We recommend the City strengthen its controls to ensure documentation is maintained to support that contractors are not suspended or debarred. Views of Responsible Officials and Corrective Action Plan - This item relates to turnover and transition within the purchasing division of the City during the last two years for all of the staff finalizing procurement matters that were replaced due to resignations and retirements. Upon notification of the deficiency, a root cause investigation on the actions involved during the grant procurement were performed to identify cause. The outcome of this investigation will be communicated as educational training within the finance department, which includes purchasing division, operating departmental procurement requestors using federal grant awards, and all accountants. Additionally, management has amended the standard policy for the City to ensure all federal monies are used in accordance with 2 CFR requirements.
Assistance Listing Number, Federal Agency, and Program Name - 97.044, U.S. Department of Homeland Security, Assistance to Firefighters Grant Federal Award Identification Number and Year - Not available Pass through Entity - Not applicable Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - Per 2 CFR 200.214, nonfederal entities are subject to the nonprocurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, as well as 2 CFR part 180. 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. Condition - The City could not provide evidence that it performed a check to verify contractors were not suspended or debarred. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The City used the grant to procure goods and services from 13 different contractors and was unable to provide evidence that the check for suspension and debarment was completed prior to entering into a contract with them. Cause and Effect - The City did not retain evidence to support that it had conducted the search for whether a contractor was suspended or debarred prior to entering into a contract. Subsequently, the City did complete the search on Sam.gov and retained evidence to support that the contractor was not suspended of debarred, thereby creating no questioned costs. Recommendation - We recommend the City strengthen its controls to ensure documentation is maintained to support that contractors are not suspended or debarred. Views of Responsible Officials and Corrective Action Plan - This item relates to turnover and transition within the purchasing division of the City during the last two years for all of the staff finalizing procurement matters that were replaced due to resignations and retirements. Upon notification of the deficiency, a root cause investigation on the actions involved during the grant procurement were performed to identify cause. The outcome of this investigation will be communicated as educational training within the finance department, which includes purchasing division, operating departmental procurement requestors using federal grant awards, and all accountants. Additionally, management has amended the standard policy for the City to ensure all federal monies are used in accordance with 2 CFR requirements.
Assistance Listing Number, Federal Agency, and Program Name - 97.044, U.S. Department of Homeland Security, Assistance to Firefighters Grant Federal Award Identification Number and Year - Not available Pass through Entity - Not applicable Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - Per 2 CFR 200.214, nonfederal entities are subject to the nonprocurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, as well as 2 CFR part 180. 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. Condition - The City could not provide evidence that it performed a check to verify contractors were not suspended or debarred. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The City used the grant to procure goods and services from 13 different contractors and was unable to provide evidence that the check for suspension and debarment was completed prior to entering into a contract with them. Cause and Effect - The City did not retain evidence to support that it had conducted the search for whether a contractor was suspended or debarred prior to entering into a contract. Subsequently, the City did complete the search on Sam.gov and retained evidence to support that the contractor was not suspended of debarred, thereby creating no questioned costs. Recommendation - We recommend the City strengthen its controls to ensure documentation is maintained to support that contractors are not suspended or debarred. Views of Responsible Officials and Corrective Action Plan - This item relates to turnover and transition within the purchasing division of the City during the last two years for all of the staff finalizing procurement matters that were replaced due to resignations and retirements. Upon notification of the deficiency, a root cause investigation on the actions involved during the grant procurement were performed to identify cause. The outcome of this investigation will be communicated as educational training within the finance department, which includes purchasing division, operating departmental procurement requestors using federal grant awards, and all accountants. Additionally, management has amended the standard policy for the City to ensure all federal monies are used in accordance with 2 CFR requirements.
Assistance Listing Number, Federal Agency, and Program Name - 97.044, U.S. Department of Homeland Security, Assistance to Firefighters Grant Federal Award Identification Number and Year - Not available Pass through Entity - Not applicable Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - Per 2 CFR 200.214, nonfederal entities are subject to the nonprocurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, as well as 2 CFR part 180. 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. Condition - The City could not provide evidence that it performed a check to verify contractors were not suspended or debarred. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The City used the grant to procure goods and services from 13 different contractors and was unable to provide evidence that the check for suspension and debarment was completed prior to entering into a contract with them. Cause and Effect - The City did not retain evidence to support that it had conducted the search for whether a contractor was suspended or debarred prior to entering into a contract. Subsequently, the City did complete the search on Sam.gov and retained evidence to support that the contractor was not suspended of debarred, thereby creating no questioned costs. Recommendation - We recommend the City strengthen its controls to ensure documentation is maintained to support that contractors are not suspended or debarred. Views of Responsible Officials and Corrective Action Plan - This item relates to turnover and transition within the purchasing division of the City during the last two years for all of the staff finalizing procurement matters that were replaced due to resignations and retirements. Upon notification of the deficiency, a root cause investigation on the actions involved during the grant procurement were performed to identify cause. The outcome of this investigation will be communicated as educational training within the finance department, which includes purchasing division, operating departmental procurement requestors using federal grant awards, and all accountants. Additionally, management has amended the standard policy for the City to ensure all federal monies are used in accordance with 2 CFR requirements.
Assistance Listing Number, Federal Agency, and Program Name - 97.044, U.S. Department of Homeland Security, Assistance to Firefighters Grant Federal Award Identification Number and Year - Not available Pass through Entity - Not applicable Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - Per 2 CFR 200.214, nonfederal entities are subject to the nonprocurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, as well as 2 CFR part 180. 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. Condition - The City could not provide evidence that it performed a check to verify contractors were not suspended or debarred. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The City used the grant to procure goods and services from 13 different contractors and was unable to provide evidence that the check for suspension and debarment was completed prior to entering into a contract with them. Cause and Effect - The City did not retain evidence to support that it had conducted the search for whether a contractor was suspended or debarred prior to entering into a contract. Subsequently, the City did complete the search on Sam.gov and retained evidence to support that the contractor was not suspended of debarred, thereby creating no questioned costs. Recommendation - We recommend the City strengthen its controls to ensure documentation is maintained to support that contractors are not suspended or debarred. Views of Responsible Officials and Corrective Action Plan - This item relates to turnover and transition within the purchasing division of the City during the last two years for all of the staff finalizing procurement matters that were replaced due to resignations and retirements. Upon notification of the deficiency, a root cause investigation on the actions involved during the grant procurement were performed to identify cause. The outcome of this investigation will be communicated as educational training within the finance department, which includes purchasing division, operating departmental procurement requestors using federal grant awards, and all accountants. Additionally, management has amended the standard policy for the City to ensure all federal monies are used in accordance with 2 CFR requirements.