Audit 350301

FY End
2024-06-30
Total Expended
$23.79M
Findings
2
Programs
65
Organization: County of Yavapai (AZ)
Year: 2024 Accepted: 2025-03-29

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
540547 2024-101 Significant Deficiency - L
1116989 2024-101 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
10.665 Schools and Roads - Grants to States $1.55M - 0
84.425 Education Stabilization Fund $1.32M - 0
21.032 Local Assistance and Tribal Consistency Fund $1.18M Yes 0
20.205 Highway Planning and Construction $1.12M - 0
93.527 Grants for New and Expanded Services Under the Health Center Program $877,791 - 0
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $800,513 - 0
17.278 Wioa Dislocated Worker Formula Grants $714,236 - 0
17.258 Wioa Adult Program $713,053 - 0
17.259 Wioa Youth Activities $603,423 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $551,103 - 0
93.268 Immunization Cooperative Agreements $523,801 - 0
93.069 Public Health Emergency Preparedness $311,857 Yes 1
14.239 Home Investment Partnerships Program $300,363 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $278,635 - 0
93.563 Child Support Services $259,680 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $257,567 - 0
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $230,489 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $196,146 - 0
93.658 Foster Care Title IV-E $180,480 - 0
20.106 Airport Improvement Program, Infrastructure Investment and Jobs Act Programs, and Covid-19 Airports Programs $180,424 - 0
20.507 Federal Transit Formula Grants $177,504 - 0
84.371 Comprehensive Literacy Development $175,908 - 0
97.042 Emergency Management Performance Grants $150,261 - 0
10.923 Emergency Watershed Protection Program $142,500 - 0
16.576 Crime Victim Compensation $141,669 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $139,584 - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $133,120 Yes 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $129,251 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $129,075 Yes 0
90.404 Hava Election Security Grants $126,851 - 0
93.994 Maternal and Child Health Services Block Grant to the States $125,451 - 0
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $124,869 - 0
16.593 Residential Substance Abuse Treatment for State Prisoners $106,621 - 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $106,284 - 0
84.013 Title I State Agency Program for Neglected and Delinquent Children and Youth $85,851 - 0
97.047 Bric: Building Resilient Infrastructure and Communities $81,230 - 0
93.967 Centers for Disease Control and Prevention Collaboration with Academia to Strengthen Public Health $80,630 - 0
20.600 State and Community Highway Safety $73,529 - 0
16.606 State Criminal Alien Assistance Program $63,886 - 0
93.224 Health Center Program (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $61,000 - 0
93.991 Preventive Health and Health Services Block Grant $59,221 - 0
16.575 Crime Victim Assistance $58,930 - 0
93.217 Family Planning Services $47,289 - 0
45.310 Grants to States $40,806 - 0
93.977 Sexually Transmitted Diseases (std) Prevention and Control Grants $34,500 - 0
93.008 Medical Reserve Corps Small Grant Program $34,282 - 0
93.110 Maternal and Child Health Federal Consolidated Programs $31,691 - 0
10.553 School Breakfast Program $29,366 - 0
84.365 English Language Acquisition State Grants $27,104 - 0
20.616 National Priority Safety Programs $25,948 - 0
10.555 National School Lunch Program $24,499 - 0
32.009 Emergency Connectivity Fund Program $24,231 - 0
84.010 Title I Grants to Local Educational Agencies $24,100 - 0
84.027 Special Education Grants to States $19,595 - 0
32.006 Covid-19 Telehealth Program $17,847 - 0
21.023 Emergency Rental Assistance Program $17,559 - 0
93.788 Opioid Str $14,315 - 0
84.358 Rural Education $13,192 - 0
93.526 Grants for Capital Development in Health Centers $13,075 - 0
93.940 Hiv Prevention Activities Health Department Based $11,684 - 0
93.597 Grants to States for Access and Visitation Programs $9,760 - 0
16.U02 Domestic Cannabis Eradication/suppression Program $6,492 - 0
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $2,600 - 0
16.922 Equitable Sharing Program $2,400 - 0
97.067 Homeland Security Grant Program $1,409 - 0

Contacts

Name Title Type
H1RCC7MAXBL6 Connie M Dekemper Auditee
9284425185 Jay Z. Parke Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the financial statements. De Minimis Rate Used: N Rate Explanation: Grantor funding under Yavapai County’s federal awards does not allow for indirect costs and, accordingly, Yavapai County did not use the 10 percent de minimis indirect cost rate as covered in 2 CFR §200.414. The accompanying schedule of expenditures of federal awards (schedule) includes Yavapai County’s federal grant activity for the year ended June 30, 2024. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the Uniform Guidance).
Title: Federal Assistance Listings Number Accounting Policies: Expenditures reported on the schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the financial statements. De Minimis Rate Used: N Rate Explanation: Grantor funding under Yavapai County’s federal awards does not allow for indirect costs and, accordingly, Yavapai County did not use the 10 percent de minimis indirect cost rate as covered in 2 CFR §200.414. The program titles and Federal Assistance Listings numbers were obtained from the federal or pass-through grantor or the 2024 Federal Assistance Listings. When no Federal Assistance Listings number had been assigned to a program, the 2-digit federal agency identifier and the federal contract number were used.
Title: Donated Personal Protective Equipment (PPE) Accounting Policies: Expenditures reported on the schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the financial statements. De Minimis Rate Used: N Rate Explanation: Grantor funding under Yavapai County’s federal awards does not allow for indirect costs and, accordingly, Yavapai County did not use the 10 percent de minimis indirect cost rate as covered in 2 CFR §200.414. Yavapai County received donated personal protective equipment (PPE) with a fair market value of $314,345 for the fiscal year ended June 30, 2023.

Finding Details

Condition: During our audit, we noted that expenditures totaling $101,308 for FAL 93.354, Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response, were originally incorrectly listed on the schedule of expenditures of federal awards (SEFA) for FAL 93.069, Public Health Emergency Preparedness. Criteria: 2 CFR 200.508(b), Auditee Responsibilities, requires the auditee to prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with § 200.510. Cause and Effect: The cause is that lack of sufficient research in obtaining the appropriate federal assistance listing. The effect is the reporting of expenditures to an incorrect federal assistance listing. Recommendation: We recommend that Yavapai County develop internal controls that ensure the reporting of federal expenditures on the SEFA to the proper federal assistance listing number. Management’s Response: Yavapai County’s responsible officials’ views and planned corrective action are in its corrective action plan at the end of the report.
Condition: During our audit, we noted that expenditures totaling $101,308 for FAL 93.354, Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response, were originally incorrectly listed on the schedule of expenditures of federal awards (SEFA) for FAL 93.069, Public Health Emergency Preparedness. Criteria: 2 CFR 200.508(b), Auditee Responsibilities, requires the auditee to prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with § 200.510. Cause and Effect: The cause is that lack of sufficient research in obtaining the appropriate federal assistance listing. The effect is the reporting of expenditures to an incorrect federal assistance listing. Recommendation: We recommend that Yavapai County develop internal controls that ensure the reporting of federal expenditures on the SEFA to the proper federal assistance listing number. Management’s Response: Yavapai County’s responsible officials’ views and planned corrective action are in its corrective action plan at the end of the report.