Audit 298480

FY End
2023-06-30
Total Expended
$171.94M
Findings
2
Programs
70
Organization: Shelby County, Tn (TN)
Year: 2023 Accepted: 2024-03-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
386100 2023-005 Significant Deficiency - B
962542 2023-005 Significant Deficiency - B

Programs

ALN Program Spent Major Findings
21.023 Emergency Rental Assistance Program $53.74M Yes 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $29.32M Yes 0
93.568 Low-Income Home Energy Assistance $16.77M - 0
93.967 Cdc's Collaboration with Academia to Strengthen Public Health $8.74M Yes 0
14.272 National Resilient Disaster Recovery Competition $8.49M - 0
93.914 Hiv Emergency Relief Project Grants $8.15M Yes 1
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $6.02M - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $4.32M - 0
93.569 Community Services Block Grant $2.82M - 0
93.268 Immunization Cooperative Agreements $2.72M - 0
14.218 Community Development Block Grants/entitlement Grants $2.48M - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $2.06M - 0
93.137 Community Programs to Improve Minority Health Grant Program $2.00M - 0
93.940 Hiv Prevention Activities_health Department Based $1.91M - 0
93.686 Ending the Hiv Epidemic: A Plan for America — Ryan White Hiv/aids Program Parts A and B (b) $1.89M - 0
16.575 Crime Victim Assistance $1.74M - 0
20.205 Highway Planning and Construction $1.70M - 0
93.563 Child Support Enforcement $1.41M - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $1.41M - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $1.33M - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $1.29M - 0
93.052 National Family Caregiver Support, Title Iii, Part E $1.21M - 0
93.917 Hiv Care Formula Grants $1.08M - 0
93.817 Hospital Preparedness Program (hpp) Ebola Preparedness and Response Activities $917,800 - 0
97.067 Homeland Security Grant Program $890,649 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $784,751 - 0
14.900 Lead-Based Paint Hazard Control in Privately-Owned Housing $741,887 - 0
93.074 Hospital Preparedness Program (hpp) and Public Health Emergency Preparedness (phep) Aligned Cooperative Agreements $672,490 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $391,962 - 0
66.001 Air Pollution Control Program Support $389,332 - 0
93.994 Maternal and Child Health Services Block Grant to the States $387,274 - 0
14.231 Emergency Solutions Grant Program $323,023 - 0
93.086 Healthy Marriage Promotion and Responsible Fatherhood Grants $262,651 - 0
66.312 State Environmental Justice Cooperative Agreement Program $200,000 - 0
20.607 Alcohol Open Container Requirements $198,159 - 0
95.001 High Intensity Drug Trafficking Areas Program $195,167 - 0
93.053 Nutrition Services Incentive Program $191,980 - 0
93.041 Special Programs for the Aging_title Vii, Chapter 3_programs for Prevention of Elder Abuse, Neglect, and Exploitation $184,643 - 0
93.283 Centers for Disease Control and Prevention_investigations and Technical Assistance $176,156 - 0
81.086 Conservation Research and Development $175,230 - 0
14.239 Home Investment Partnerships Program $167,502 - 0
93.575 Child Care and Development Block Grant $161,432 - 0
97.042 Emergency Management Performance Grants $150,384 - 0
93.991 Preventive Health and Health Services Block Grant $147,340 - 0
16.017 Sexual Assault Services Formula Program $141,378 - 0
20.600 State and Community Highway Safety $138,773 - 0
66.034 Surveys, Studies, Research, Investigations, Demonstrations, and Special Purpose Activities Relating to the Clean Air Act $136,699 - 0
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $121,190 - 0
16.833 National Sexual Assault Kit Initiative $119,129 - 0
16.585 Drug Court Discretionary Grant Program $115,574 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $101,316 - 0
97.056 Port Security Grant Program $95,420 - 0
93.042 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $90,556 - 0
93.324 State Health Insurance Assistance Program $90,528 - 0
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $75,889 - 0
16.588 Violence Against Women Formula Grants $54,657 - 0
93.747 Elder Abuse Prevention Interventions Program $52,768 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $48,587 - 0
16.609 Project Safe Neighborhoods $42,931 - 0
20.614 National Highway Traffic Safety Administration (nhtsa) Discretionary Safety Grants $37,451 - 0
90.404 2018 Hava Election Security Grants $29,814 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $29,365 - 0
93.426 Improving the Health of Americans Through Prevention and Management of Diabetes and Heart Disease and Stroke $20,857 - 0
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $19,512 - 0
16.812 Second Chance Act Reentry Initiative $15,225 - 0
93.247 Advanced Nursing Education Grant Program $15,000 - 0
93.071 Medicare Enrollment Assistance Program $11,266 - 0
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $10,794 - 0
93.946 Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative Programs $10,500 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $2,475 - 0

Contacts

Name Title Type
F663H7K72GR4 Gregory Cobbige Auditee
9012222204 Karen Gondan Auditor
No contacts on file

Notes to SEFA

Title: NOTE 1 – BASIS OF PRESENTATION Accounting Policies: The Schedule is presented on the modified accrual basis of accounting, consistent with accounting for governmental type funds. Under this basis of accounting, revenues are recognized when susceptible to accrual (i.e., when they are “measurable and available”), which is generally when the allowable program expenditures are incurred. Expenditures and transfers out are recorded when the related program liability is incurred, except for certain compensated absences. Such expenditures are recognized following the cost principles contained in the OMB Circular A-87, Cost Principles for State, Local, and Tribal Governments, or the Uniform Guidance, as applicable, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts reflected in the schedule represent adjustments or credits resulting from the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance The accompanying schedule of expenditures of federal awards and state financial assistance (the “Schedule”) includes the federal and state grant activity of Shelby County, Tennessee (the “County”) under programs of the federal and state government for the year ended June 30, 2023 (the Shelby County Health Care Corporation and the Shelby County Board of Education, component units of the County, issue separate financial reports and are not included in the Schedule). The information in this 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 (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the County, it is not intended to and does not present the financial position, changes in net position, or cash flows of the County.
Title: NOTE 2 – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES Accounting Policies: The Schedule is presented on the modified accrual basis of accounting, consistent with accounting for governmental type funds. Under this basis of accounting, revenues are recognized when susceptible to accrual (i.e., when they are “measurable and available”), which is generally when the allowable program expenditures are incurred. Expenditures and transfers out are recorded when the related program liability is incurred, except for certain compensated absences. Such expenditures are recognized following the cost principles contained in the OMB Circular A-87, Cost Principles for State, Local, and Tribal Governments, or the Uniform Guidance, as applicable, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts reflected in the schedule represent adjustments or credits resulting from the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance 1) The Schedule is presented on the modified accrual basis of accounting, consistent with accounting for governmental type funds. Under this basis of accounting, revenues are recognized when susceptible to accrual (i.e., when they are “measurable and available”), which is generally when the allowable program expenditures are incurred. Expenditures and transfers out are recorded when the related program liability is incurred, except for certain compensated absences. Such expenditures are recognized following the cost principles contained in the OMB Circular A-87, Cost Principles for State, Local, and Tribal Governments, or the Uniform Guidance, as applicable, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts reflected in the schedule represent adjustments or credits resulting from the normal course of business to amounts reported as expenditures in prior years. 2) Pass-through entity identifying numbers are presented where available. 3) The County has not elected to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance.
Title: NOTE 3 – RECONCILIATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS AND STATE FINANCIAL ASSISTANCE TO THE FINANCIAL STATEMENTS Accounting Policies: The Schedule is presented on the modified accrual basis of accounting, consistent with accounting for governmental type funds. Under this basis of accounting, revenues are recognized when susceptible to accrual (i.e., when they are “measurable and available”), which is generally when the allowable program expenditures are incurred. Expenditures and transfers out are recorded when the related program liability is incurred, except for certain compensated absences. Such expenditures are recognized following the cost principles contained in the OMB Circular A-87, Cost Principles for State, Local, and Tribal Governments, or the Uniform Guidance, as applicable, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts reflected in the schedule represent adjustments or credits resulting from the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance The following is a reconciliation of expenditures per the schedule of expenditures of federal awards and state financial assistance to the revenues in the grant fund, per the County’s financial statements: Totals per schedule of expenditures $ 191,054,171 Less: Grant revenues in non-grant funds (5,757,230) Add: Local grants not shown on this schedule 1,315,560 Add: Other revenues in grant fund 787,619 Total grant fund revenues $ 187,400,120

Finding Details

Department of Health and Human Services: HIV Emergency Relief Project Grants (Ryan White HIV/AIDS Program Part A) – Assistance Listing No. 93.914; Contract No. CA191064 Criteria: RWHAP Part A legislation, sections 2601-2610 of title XXVI of the Public Health Service Act, 42 U.S.C. 300ff-11-300ff-20. PCN 16-02. Condition: Per the site visit report issued by the Health Resources and Services Administration (HRSA) covering the visit from August 1, 2022 to August 5, 2022, the Shelby County Ryan White HIV/AIDS program (assistance listing number 93.914) was not in compliance with aligning services with the definitions for service categories during the budget period covering March 1, 2021 to February 28, 2022. As the report has not been closed, the issue still exists. No additional compliance issues were identified in the audit of compliance with each major program and on internal control over compliance required by the Uniform Guidance. Cause: Significant turnover within the Shelby County Health Department since the last time this program was audited. The findings are from 2021 and prior, which proceeded Dr. Michelle Taylor (Director-Health Officer), Tammy Winston (Finance Administrator), and Travis Green (Deputy Division Director). Effect: Continued noncompliance with recommendations from the HRSA could lead to potential decreases in funds received. Recommendation: We recommend working with the HRSA to implement appropriate corrective action to remedy their concerns with the allocation of activity to specific service categories. View of Responsible Officials: See management’s corrective action plan.
Department of Health and Human Services: HIV Emergency Relief Project Grants (Ryan White HIV/AIDS Program Part A) – Assistance Listing No. 93.914; Contract No. CA191064 Criteria: RWHAP Part A legislation, sections 2601-2610 of title XXVI of the Public Health Service Act, 42 U.S.C. 300ff-11-300ff-20. PCN 16-02. Condition: Per the site visit report issued by the Health Resources and Services Administration (HRSA) covering the visit from August 1, 2022 to August 5, 2022, the Shelby County Ryan White HIV/AIDS program (assistance listing number 93.914) was not in compliance with aligning services with the definitions for service categories during the budget period covering March 1, 2021 to February 28, 2022. As the report has not been closed, the issue still exists. No additional compliance issues were identified in the audit of compliance with each major program and on internal control over compliance required by the Uniform Guidance. Cause: Significant turnover within the Shelby County Health Department since the last time this program was audited. The findings are from 2021 and prior, which proceeded Dr. Michelle Taylor (Director-Health Officer), Tammy Winston (Finance Administrator), and Travis Green (Deputy Division Director). Effect: Continued noncompliance with recommendations from the HRSA could lead to potential decreases in funds received. Recommendation: We recommend working with the HRSA to implement appropriate corrective action to remedy their concerns with the allocation of activity to specific service categories. View of Responsible Officials: See management’s corrective action plan.