Finding 406006 (2023-002)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-07-02

AI Summary

  • Core Issue: The Cook County Department of Planning and Development failed to meet FFATA reporting requirements for a subrecipient awarded in fiscal year 2023.
  • Impacted Requirements: Non-compliance with federal regulations impairs the grantor agency's monitoring capabilities and violates the grant agreement.
  • Recommended Follow-Up: DPD should create and implement procedures to ensure timely submission of required reports moving forward.

Finding Text

Reporting Federal Department – U.S. Department of Housing and Urban Development Federal Award Identification Number and Year(s): B-13BUS-17-0001 and 2013 CDBG - Disaster Recovery Grants - Pub. L. No. 113-2 Cluster: Hurricane Sandy Community Development Block Grant Disaster Recovery Grants (CDBG-DR), Federal Assistance Listing #14.269 County Department – Department of Planning and Development Finding 2023 – 002 CRITERIA Per the 2013 Funding approval/agreement with the U.S. Department of Housing and Urban Development (HUD), Item 6 states, “The grantee shall comply with requirements established by the Office of Management and Budget (OMB) concerning the Dun and Bradstreet Data Universal Numbering System (DUNS), the System or Award Management (SAM) Central Contractor Registration database, and the Federal Funding Accountability and Transparency Act, including Appendix A to Part 25 of the Financial Assistance Use of Universal Identifier and Central Contractor Registration, 75 Fed. Reg. 55671 (Sept. 14, 2010) (to be codified at 2 CFR part 25) and Appendix A to Part 170 of the Requirements for Federal Funding Accountability and Transparency Act Implementation, 75 Fed. Reg. 55663 (Sept. 14, 2010) (codified at 2 CFR part 170).” The Federal Funding Accountability and Transparency Act (FFATA) Subaward Reporting System (FSRS) website states, “FSRS is the reporting tool Federal prime awardees (i.e. prime contractors and prime grants recipients) use to capture and report subaward and executive compensation data regarding their first-tier subawards to meet the FFATA reporting requirements. Prime contract awardees will report against subcontracts awarded, and prime grant awardees will report against sub-grants awarded.” In addition, “Prime Grant Recipients awarded a new Federal grant greater than or equal to $30,000 as of October 1, 2010 are subject to FFATA sub-award reporting requirements as outlined in the Office of Management and Budgets guidance issued August 27, 2010. The prime awardee is required to file a FFATA sub-award report by the end of the month following the month in which the prime recipient awards any sub-grant greater than or equal to $30,000.” In accordance with 2 CFR Part 170, Reporting Subaward and Executive Compensation Information, Appendix A, Award Term, b. 1. Reporting total compensation of recipient executives for non-Federal entities, states, “You must report total compensation for each of your five most highly compensated executives for the preceding completed fiscal year, if - i. The total Federal funding authorized to date under this Federal award equals or exceeds $30,000 as defined in 2 CFR 170.320; ii. in the preceding fiscal year, you received— (A) 80 percent or more of your annual gross revenues from Federal procurement contracts (and subcontracts) and Federal financial assistance subject to the Transparency Act, as defined at 2 CFR 170.320 (and subawards), and (B) $25,000,000 or more in annual gross revenues from Federal procurement contracts (and subcontracts) and Federal financial assistance subject to the Transparency Act, as defined at 2 CFR 170.320 (and subawards); and, iii. The public does not have access to information about the compensation of the executives through periodic reports filed under section 13(a) or 15(d) of the Securities Exchange Act of 1934 (15 U.S.C. 78m(a), 78o(d)) or section 6104 of the Internal Revenue Code of 1986. 2. Where and when to report. You must report executive total compensation described in paragraph b.1. of this award term: i. As part of your registration profile at https://www.sam.gov. ii. By the end of the month following the month in which this award is made, and annually thereafter.” CONDITION During the current audit period, the Cook County Department of Planning and Development (DPD) did not comply with its FFATA reporting requirements as outlined in its grant agreement and federal regulations. CAUSE Based on discussions with management, this finding occurred due to not reporting FFATA information for one subrecipient that was awarded in fiscal year 2023 for the CDBG-DR grant. EFFECT Failure to prepare and submit required reports is a violation of federal regulations and impairs the grantor agency’s ability to adequately monitor the program activities/federally funded program. QUESTIONED COSTS None. CONTEXT We noted a total of 37 subrecipients received a sub-award greater than $30,000 in the prior fiscal year(s). Of these 37 subrecipients, we noted 7 had grant disbursements during the County’s fiscal year 2023 and hence, should have been subject to FFATA Subaward reporting. Based on our follow up discussions with DPD personnel, of the 37 subrecipients awarded, only one (1) subrecipient received a new sub-award during fiscal year 2023. Consequently, we were not provided with any evidence that DPD submitted any reporting information as required under the FFATA Subaward Reporting, in the FSRS system. IDENTIFICATION OF REPEATED FINDINGS None. RECOMMENDATION We recommend that DPD develop and implement procedures to ensure required reports are prepared, reviewed, and submitted in a timely manner and in compliance with its grant agreement and federal regulations. Per federal regulations, prime grant recipients awarded a new federal grant greater than or equal to $30,000 as of October 1, 2010, are subject to FFATA sub-award reporting requirements as outlined in the Office of Management and Budgets guidance issued August 27, 2010. The prime awardee (i.e., County DPD) is required to file a FFATA sub-award report by the end of the month following the month in which the prime recipient awards any sub-grant greater than or equal to $30,000. If any federal requirement is unclear, we recommend that DPD reach out to its grantor agency for additional clarification and guidance. VIEWS OF RESPONSIBLE OFFICIALS AND PLANNED CORRECTIVE ACTIONS The County agrees with the finding and recommendation. The County’s corrective action plan is on page 53.

Corrective Action Plan

Findings 2023-002 Community Development Block Disaster Recovery Grant (CDBG-DR) Federal Assistant Listing Number 14.269. Corrective Action Plan: The corrective action plan from prior year stated that the County would begin with a process in FY2023. The CDBG-DR grant had only one new award during 2023 which was the Palatine agreement. The FFATA information was not obtained for the award and as of today has not been reported in the federal data base. We have instructed our program administrator to send the information (Donna Sanford, CDM Smith) to the Township and will have it entered (Janet Hamilton) in the FSRS system. We have designed and implemented this. Date of completion November 30, 2024.

Categories

Procurement, Suspension & Debarment Subrecipient Monitoring

Other Findings in this Audit

  • 406005 2023-001
    Significant Deficiency Repeat
  • 406007 2023-003
    Significant Deficiency
  • 406008 2023-004
    Significant Deficiency
  • 406009 2023-005
    Significant Deficiency Repeat
  • 406010 2023-006
    Significant Deficiency
  • 982447 2023-001
    Significant Deficiency Repeat
  • 982448 2023-002
    Significant Deficiency
  • 982449 2023-003
    Significant Deficiency
  • 982450 2023-004
    Significant Deficiency
  • 982451 2023-005
    Significant Deficiency Repeat
  • 982452 2023-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
95.001 High Intensity Drug Trafficking Areas Program $18.75M
97.067 Homeland Security Grant Program $16.94M
14.218 Community Development Block Grants/entitlement Grants $14.03M
14.269 Hurricane Sandy Community Development Block Grant Disaster Recovery Grants (cdbg-Dr) $13.01M
21.023 Emergency Rental Assistance Program $12.08M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $10.77M
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $9.45M
93.563 Child Support Enforcement $8.60M
20.205 Highway Planning and Construction $7.33M
14.231 Emergency Solutions Grant Program $3.96M
14.239 Home Investment Partnerships Program $2.54M
93.495 Community Health Workers for Public Health Response and Resilient $2.50M
93.268 Immunization Cooperative Agreements $1.93M
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $1.59M
93.498 Provider Relief Fund $1.53M
16.575 Crime Victim Assistance $1.46M
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $1.38M
93.788 Opioid Str $1.17M
16.588 Violence Against Women Formula Grants $1.07M
14.905 Lead Hazard Reduction Demonstration Grant Program $945,943
16.812 Second Chance Act Reentry Initiative $925,000
93.069 Public Health Emergency Preparedness $812,336
93.926 Healthy Start Initiative $807,270
16.738 Edward Byrne Memorial Justice Assistance Grant Program $754,526
93.217 Family Planning_services $637,633
97.042 Emergency Management Performance Grants $603,183
93.959 Block Grants for Prevention and Treatment of Substance Abuse $585,334
66.001 Air Pollution Control Program Support $552,386
16.543 Missing Children's Assistance $450,304
93.247 Advanced Nursing Education Grant Program $440,701
16.827 Justice Reinvestment Initiative $411,072
10.555 National School Lunch Program $385,137
16.922 Equitable Sharing Program $352,774
16.585 Drug Court Discretionary Grant Program $298,088
93.884 Grants for Primary Care Training and Enhancement $266,683
66.034 Surveys, Studies, Research, Investigations, Demonstrations, and Special Purpose Activities Relating to the Clean Air Act $256,982
16.320 Services for Trafficking Victims $250,204
93.667 Social Services Block Grant $229,629
21.027 Coronavirus State and Local Fiscal Recovery Funds $190,722
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $182,722
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $176,635
10.553 School Breakfast Program $175,110
21.016 Equitable Sharing $171,484
16.820 Postconviction Testing of Dna Evidence to Exonerate the Innocent $164,485
16.741 Dna Backlog Reduction Program $131,476
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $130,814
16.034 Coronavirus Emergency Supplemental Funding Program $123,952
20.600 State and Community Highway Safety $121,207
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $114,671
16.836 Indigent Defense $97,827
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $90,000
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $85,290
16.582 Crime Victim Assistance/discretionary Grants $84,625
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health $79,196
16.021 Justice Systems Response to Families $74,873
16.593 Residential Substance Abuse Treatment for State Prisoners $73,207
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $72,355
16.560 National Institute of Justice Research, Evaluation, and Development Project Grants $60,553
16.838 Comprehensive Opioid Abuse Site-Based Program $56,609
66.708 Pollution Prevention Grants Program $55,890
93.855 Allergy, Immunology and Transplantation Research $41,106
93.669 Child Abuse and Neglect State Grants $40,383
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $39,667
16.735 Prea Program: Demonstration Projects to Establish 'zero Tolerance' Cultures for Sexual Assault in Correctional Facilities $35,654
16.540 Juvenile Justice and Delinquency Prevention_allocation to States $34,146
93.439 State Physical Activity and Nutrition (span $34,000
12.600 Community Investment $27,102
16.609 Project Safe Neighborhoods $19,520
66.605 Performance Partnership Grants $16,095
20.530 Public Transportation Innovation $15,793
16.752 Economic High-Tech and Cyber Crime Prevention $10,336
90.404 2018 Hava Election Security Grants $9,781
93.279 Drug Abuse and Addiction Research Programs $5,165
66.032 State Indoor Radon Grants $4,574
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $1,460
93.226 Research on Healthcare Costs, Quality and Outcomes $1,115
93.136 Injury Prevention and Control Research and State and Community Based Programs $-2,495
17.285 Apprenticeship USA Grants $-47,417