Finding 1169644 (2024-002)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2026-01-20
Audit: 382642
Organization: Dakota County (MN)

AI Summary

  • Core Issue: The County included individuals in the RMS listings who should not have been, indicating weak internal controls.
  • Impacted Requirements: Compliance with Title 2 U.S. Code of Federal Regulations § 200.303, which mandates effective internal control over federal awards.
  • Recommended Follow-Up: The County should enhance its procedures to ensure accurate RMS listings by excluding individuals no longer in the programs.

Finding Text

Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Medical Assistance Assistance Listing Numbers: 93.778 Federal Award Identification Numbers and Years: 2405MN5ADM - 2024 Passed Through Entity: Minnesota Department of Human Services Pass Through Numbers: H55245048 Compliance Requirement: Allowable Activities Award Period: 2024 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Criteria or specific requirement: The Minnesota Department of Human Services (DHS) requires a listing of employees working on social services programs to be submitted quarterly, known as a random moment study listing (RMS listing). DHS then determines the amount applicable to the applicable income maintenance programs through random moment studies. Each quarter the County’s coordinator reviews their RMS listing to ensure the employees listed are accurate for the people working and being coded in the general ledger. Title 2 U.S. Code of Federal Regulations § 200.303 states that the auditee must establish and maintain effective internal control over the federal award that provides reasonable assurance that the auditee is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition: One individual was included in the 2nd quarter Social Services RMS listing sent to the State that was not supposed to be included in the listing, one individual was noted to have the same issue on the 2nd quarter of the public health local collaborative time study participant listing. Questioned costs: None Context: In our testing of two of the eight quarterly RMS listings, one individual was included in the 2nd quarter Social Services RMS listing sent to the State that was not supposed to be included in the listings, one individual was noted to have the same issue on the 2nd quarter public health local collaborative time study participant listing. There were 335 County staff listed in the 2nd quarter’s RMS listing and 52 participants listed in the 2nd quarter public health LCTS RMS listing. Cause: The County's RMS controls and procedures were not robust enough to note that the RMS listings should have excluded the noted individuals. Increased turnover and growth of the programs also created an increase in the number changes that were needed to be made to the listings. Effect: Lack of proper controls could affect allocation of fundings due to the staff not being in MAXIS or actually assigned to social services or public health LCTS case files to properly respond to the random moment requests that are sent by the State as part of the random moment study. Repeat Finding: Yes 2023-009 Recommendation: We recommend that the County review its procedures and control to ensure all RMS listings sent to the State properly exclude those necessary individuals no longer working in the programs. Views of responsible officials: There is no disagreement with the audit finding.

Corrective Action Plan

Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Medical Assistance Assistance Listing Numbers: 93.778 Federal Award Identification Numbers and Years: 2405MN5ADM - 2024 Passed Through Entity: Minnesota Department of Human Services Pass Through Number: H55245048 Award Period: 2024 Recommendation: We recommend that the County review its procedures and control to ensure all RMS listings sent to the State properly exclude those necessary individuals no longer working in the programs. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action planned in response to finding: The County will ensure that the reports are reviewed prior to submission going forward. Name of the contact person responsible for corrective action: Tim Paulus, Social Services Administrative Manager Planned completion date for corrective action plan: December 31, 2025

Categories

Allowable Costs / Cost Principles Material Weakness Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1169642 2024-001
    Material Weakness Repeat
  • 1169643 2024-004
    Material Weakness Repeat
  • 1169645 2024-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $34.46M
93.778 MEDICAL ASSISTANCE PROGRAM $15.49M
93.563 CHILD SUPPORT SERVICES $6.10M
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $3.50M
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $2.88M
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $2.69M
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $1.72M
93.667 SOCIAL SERVICES BLOCK GRANT $1.52M
97.067 HOMELAND SECURITY GRANT PROGRAM $1.42M
93.870 MATERNAL, INFANT AND EARLY CHILDHOOD HOME VISITING GRANT $1.32M
93.658 FOSTER CARE TITLE IV-E $1.17M
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $1.02M
15.941 MISSISSIPPI NATIONAL RIVER AND RECREATION AREA STATE AND LOCAL ASSISTANCE $900,000
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $869,966
14.267 CONTINUUM OF CARE PROGRAM $659,986
10.572 WIC FARMERS' MARKET NUTRITION PROGRAM (FMNP) $523,950
20.205 HIGHWAY PLANNING AND CONSTRUCTION $436,965
17.259 WIOA YOUTH ACTIVITIES $329,566
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $314,982
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $279,366
20.513 ENHANCED MOBILITY OF SENIORS AND INDIVIDUALS WITH DISABILITIES $276,088
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $255,407
17.278 WIOA DISLOCATED WORKER FORMULA GRANTS $233,454
93.967 CENTERS FOR DISEASE CONTROL AND PREVENTION COLLABORATION WITH ACADEMIA TO STRENGTHEN PUBLIC HEALTH $201,224
17.258 WIOA ADULT PROGRAM $196,746
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $193,811
21.023 EMERGENCY RENTAL ASSISTANCE PROGRAM $186,743
16.575 CRIME VICTIM ASSISTANCE $180,802
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $160,469
95.001 HIGH INTENSITY DRUG TRAFFICKING AREAS PROGRAM $105,623
93.590 COMMUNITY-BASED CHILD ABUSE PREVENTION GRANTS $100,245
16.585 TREATMENT COURT DISCRETIONARY GRANT PROGRAM $98,933
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $98,879
93.959 BLOCK GRANTS FOR PREVENTION AND TREATMENT OF SUBSTANCE ABUSE $89,490
16.579 EDWARD BYRNE MEMORIAL FORMULA GRANT PROGRAM $84,699
93.659 ADOPTION ASSISTANCE $82,652
93.674 JOHN H. CHAFEE FOSTER CARE PROGRAM FOR SUCCESSFUL TRANSITION TO ADULTHOOD $68,017
16.922 EQUITABLE SHARING PROGRAM $59,097
93.958 BLOCK GRANTS FOR COMMUNITY MENTAL HEALTH SERVICES $57,224
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $53,558
93.556 MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES PROGRAM $44,792
10.555 NATIONAL SCHOOL LUNCH PROGRAM $25,812
93.645 STEPHANIE TUBBS JONES CHILD WELFARE SERVICES PROGRAM $24,509
20.608 MINIMUM PENALTIES FOR REPEAT OFFENDERS FOR DRIVING WHILE INTOXICATED $19,666
97.012 BOATING SAFETY FINANCIAL ASSISTANCE $18,916
93.070 ENVIRONMENTAL PUBLIC HEALTH AND EMERGENCY RESPONSE $17,069
10.553 SCHOOL BREAKFAST PROGRAM $14,280
93.008 MEDICAL RESERVE CORPS SMALL GRANT PROGRAM $13,875
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $8,601
93.251 EARLY HEARING DETECTION AND INTERVENTION $4,350
93.566 REFUGEE AND ENTRANT ASSISTANCE STATE/REPLACEMENT DESIGNEE ADMINISTERED PROGRAMS $4,252
84.181 SPECIAL EDUCATION-GRANTS FOR INFANTS AND FAMILIES $2,100
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $1,408