Finding 406017 (2023-006)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-07-02
Audit: 311580
Organization: Oakland County, Michigan (MI)

AI Summary

  • Core Issue: The County failed to file required FFATA reports for CDBG subrecipients on time, leading to a material weakness and noncompliance.
  • Impacted Requirements: Compliance with the Federal Funding Accountability and Transparency Act (FFATA) for timely reporting of subgrants.
  • Recommended Follow-up: Implement controls to ensure timely filing of required reports and clarify due dates for future submissions.

Finding Text

Assistance Listing Number, Federal Agency, and Program Name - ALN 14.218, Community Development Block Grants Cluster, Community Development Block Grants Program (CDBG) Federal Award Identification Number and Year – B-18-UC-26-002 (2018), B-19-UC-26-002 (2019), B-20-UC-26-002 (2020), B-21-UC-26-002 (2021), B-22-UC-26-002 (2022) Pass-through Entity - N/A Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding – Yes, 2022-007 Criteria - The Federal Funding Accountability and Transparency Act (FFATA), as amended by 6202 of Public Law 110-252, requires a prime grant awardee to report its subgrants using the FFATA Subaward Reporting System (FSRS) tool. The prime recipient will have until the end of the month plus one additional month after an award or subaward is obligated to fulfill the reporting requirement. Condition - The County did not file the required FFATA reports for CDBG subrecipients timely. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The following table summarizes the transactions examined and the noncompliance identified for subwards obligated during fiscal year 2023 for which the FFATA report was not filed timely: See findings text of 2023-006 for table Cause and Effect - The County’s processes did not properly identify the FFATA filing requirements and, as a result, failed to file any of the required FFATA reports timely. Recommendation - The County should implement controls to ensure that required reports are filed in a timely manner. Views of Responsible Officials and Corrective Action Plan - FFATA was brought up to date for prior years. The actual due date of the report was not known. Notes regarding the due date of the annual report have been made indicating to file 30 days within the approval of Subrecipient budgets.

Categories

Subrecipient Monitoring Material Weakness Reporting

Other Findings in this Audit

  • 406012 2023-004
    Material Weakness
  • 406013 2023-004
    Material Weakness
  • 406014 2023-004
    Material Weakness
  • 406015 2023-006
    Material Weakness Repeat
  • 406016 2023-004
    Material Weakness
  • 406018 2023-004
    Material Weakness
  • 406019 2023-004
    Material Weakness
  • 406020 2023-006
    Material Weakness Repeat
  • 406021 2023-004
    Material Weakness
  • 406022 2023-006
    Material Weakness Repeat
  • 406023 2023-004
    Material Weakness
  • 406024 2023-004
    Material Weakness
  • 406025 2023-004
    Material Weakness
  • 406026 2023-004
    Material Weakness
  • 406027 2023-004
    Material Weakness
  • 406028 2023-006
    Material Weakness Repeat
  • 406029 2023-004
    Material Weakness
  • 406030 2023-005
    Material Weakness Repeat
  • 406031 2023-005
    Material Weakness Repeat
  • 406032 2023-005
    Material Weakness Repeat
  • 406033 2023-005
    Material Weakness Repeat
  • 982454 2023-004
    Material Weakness
  • 982455 2023-004
    Material Weakness
  • 982456 2023-004
    Material Weakness
  • 982457 2023-006
    Material Weakness Repeat
  • 982458 2023-004
    Material Weakness
  • 982459 2023-006
    Material Weakness Repeat
  • 982460 2023-004
    Material Weakness
  • 982461 2023-004
    Material Weakness
  • 982462 2023-006
    Material Weakness Repeat
  • 982463 2023-004
    Material Weakness
  • 982464 2023-006
    Material Weakness Repeat
  • 982465 2023-004
    Material Weakness
  • 982466 2023-004
    Material Weakness
  • 982467 2023-004
    Material Weakness
  • 982468 2023-004
    Material Weakness
  • 982469 2023-004
    Material Weakness
  • 982470 2023-006
    Material Weakness Repeat
  • 982471 2023-004
    Material Weakness
  • 982472 2023-005
    Material Weakness Repeat
  • 982473 2023-005
    Material Weakness Repeat
  • 982474 2023-005
    Material Weakness Repeat
  • 982475 2023-005
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.563 Child Support Enforcement $11.48M
14.218 Covid-19 - Community Development Block Grants/entitlement Grants $833,676
21.019 Covid-19 - Coronavirus Relief Fund $762,853
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $690,370
84.425 Education Stabilization Fund $571,342
16.741 Dna Backlog Reduction Program $417,131
17.268 H-1b Job Training Grants $410,096
93.940 Hiv Prevention Activities_health Department Based $404,905
16.838 Comprehensive Opioid Abuse Site-Based Program $381,098
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $374,698
16.710 Public Safety Partnership and Community Policing Grants $340,058
93.994 Maternal and Child Health Services Block Grant to the States $321,457
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $298,046
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $263,702
93.658 Foster Care_title IV-E $251,140
14.239 Home Investment Partnerships Program $248,301
14.231 Emergency Solutions Grant Program $236,918
93.889 National Bioterrorism Hospital Preparedness Program $227,953
17.245 Trade Adjustment Assistance $220,195
16.738 Edward Byrne Memorial Justice Assistance Grant Program $195,372
97.042 Emergency Management Performance Grants $163,754
97.036 Covid-19 - Disaster Grants - Public Assistance (presidentially Declared Disasters) $157,197
97.012 Boating Safety Financial Assistance $119,100
17.259 Wia Youth Activities $118,724
97.047 Pre-Disaster Mitigation $110,438
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $100,305
95.001 High Intensity Drug Trafficking Areas Program $96,355
11.307 Covid-19 - Economic Adjustment Assistance $82,000
97.067 Homeland Security Grant Program $58,713
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $56,654
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $54,929
93.069 Public Health Emergency Preparedness $54,243
16.582 Crime Victim Assistance/discretionary Grants $52,667
16.824 Emergency Law Enforcement Assistance Grant $40,006
93.597 Grants to States for Access and Visitation Programs $37,000
17.278 Wia Dislocated Worker Formula Grants $36,780
10.331 Food Insecurity Nutrition Incentive Grants Program $31,070
17.207 Employment Service/wagner-Peyser Funded Activities $28,404
93.558 Temporary Assistance for Needy Families $23,835
16.753 Congressionally Recommended Awards $23,832
17.285 Apprenticeship USA Grants $22,875
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $18,280
93.991 Preventive Health and Health Services Block Grant $15,000
93.959 Block Grants for Prevention and Treatment of Substance Abuse $14,456
20.616 National Priority Safety Programs $14,388
17.225 Unemployment Insurance $14,017
93.354 Covid-19 - Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $13,865
14.169 Covid-19 - Housing Counseling Assistance Program $12,310
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $10,000
97.039 Hazard Mitigation Grant $9,793
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $8,611
84.126 Rehabilitation Services_vocational Rehabilitation Grants to States $7,016
10.555 National School Lunch Program $6,006
66.468 Capitalization Grants for Drinking Water State Revolving Funds $5,025
17.801 Jobs for Veterans State Grants $4,986
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $3,807
93.268 Immunization Cooperative Agreements $2,679
17.258 Wia Adult Program $2,039
16.609 Project Safe Neighborhoods $1,423
14.239 Covid-19 - Home Investment Partnerships Program $965
14.218 Community Development Block Grants/entitlement Grants $540
93.778 Medical Assistance Program $426
14.169 Housing Counseling Assistance Program $234
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $-6,803