Finding 1167415 (2024-007)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2025-12-31
Audit: 378497
Organization: Mille Lacs County (MN)

AI Summary

  • Core Issue: Significant errors in the cost allocation plan led to incorrect expenditure amounts and lack of documentation for cost allocations.
  • Impacted Requirements: Non-compliance with federal regulations requiring effective internal controls and adequate documentation for allowable costs.
  • Recommended Follow-Up: Ensure accurate data and documentation are provided to the cost allocation preparer, and implement a thorough review process for the plan.

Finding Text

2024-007 Allowable Costs/Cost Principles – Cost Allocation Plan Prior Year Finding Number: N/A Year of Finding Origination: 2024 Type of Finding: Internal Control Over Compliance and Compliance Severity of Deficiency: Significant Deficiency and Other Matter Federal Agency: U.S. Department of Health and Human Services Programs: 93.563 Child Support Services, 93.778 Medicaid Cluster Award Number and Year: 2301MNCSES; 2024, 2405MN5ADM; 2024 Pass-Through Agency: Minnesota Department of Human Services Criteria: 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. Title 2 U.S. Code of Federal Regulations § 2 CFR 200.403(a) and § 2 CFR 200.403(g) require costs to be necessary and reasonable and be adequately documented. Condition: For two of the five departments tested, incorrect expenditure amounts were used in the cost allocation plan. In addition, for one of the five departments tested, the County did not have support for the basis of allocating the costs to benefiting departments. Questioned Costs: $2,968,953, which is calculated as $1,299,253 of department costs tested within the cost allocation plan that were derived from incorrect information and $1,669,700 in department costs without a documented basis for allocating costs. Not all questioned costs were allocated to the department reporting grant expenditures or to the grant tested as a major program. Additionally, the rate of reimbursement of allocated costs to the grant is not known to the auditor. Context: The 2024 cost allocation plan is prepared using activity and expenditures from 2022. The cost allocation plan is prepared annually by a contractor and submitted to the Minnesota Department of Human Services (DHS) for reimbursement of county-wide indirect cost reimbursement. For one department, the cost allocation plan included expenditure accounts with credit balances as debit balances and, for another department, the 2023 general ledger expenditures were used rather than 2022. Furthermore, the basis for one department was determined in direct conversation between the cost allocation plan preparer and the County, with no documented support retained. Effect: Errors in reporting expenditures and the basis of the allocations used in the cost allocation plan calculation could result in incorrect county-wide indirect cost reimbursements from DHS. Cause: The cost allocation plan preparer’s work contained errors or lacked proper support, and the County did not identify the errors or lack of support. Recommendation: We recommend the County provide accurate and supported information to the cost allocation plan preparer and appropriate staff review the cost allocation plan to ensure the data, basis, and calculation are accurate, complete, and supported. View of Responsible Official: Concur

Corrective Action Plan

Finding Number: 2024-007 Finding Title: Allowable Costs/Cost Principles – Cost Allocation Plan Name of Contact Person Responsible for Corrective Action: Dillon Hayes, County Administrator Corrective Action Planned: The County has contracted with a new vendor to prepare its Cost Allocation Plan effective in 2025. Anticipated Completion Date: Completed August 2025

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1167414 2024-007
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.563 CHILD SUPPORT SERVICES $597,321
93.658 FOSTER CARE TITLE IV-E $346,461
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $340,405
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $262,385
93.667 SOCIAL SERVICES BLOCK GRANT $201,043
16.575 CRIME VICTIM ASSISTANCE $174,190
93.870 MATERNAL, INFANT AND EARLY CHILDHOOD HOME VISITING GRANT $160,388
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $153,936
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $36,328
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $33,708
93.323 COVID-19 - EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $31,606
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $30,744
93.590 COMMUNITY-BASED CHILD ABUSE PREVENTION GRANTS $26,215
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $25,199
93.967 CENTERS FOR DISEASE CONTROL AND PREVENTION COLLABORATION WITH ACADEMIA TO STRENGTHEN PUBLIC HEALTH $19,748
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $17,007
93.778 MEDICAL ASSISTANCE PROGRAM $12,871
97.012 BOATING SAFETY FINANCIAL ASSISTANCE $12,179
93.556 MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES PROGRAM $8,878
93.674 JOHN H. CHAFEE FOSTER CARE PROGRAM FOR SUCCESSFUL TRANSITION TO ADULTHOOD $7,770
93.645 STEPHANIE TUBBS JONES CHILD WELFARE SERVICES PROGRAM $5,562
93.251 EARLY HEARING DETECTION AND INTERVENTION $1,850
93.566 REFUGEE AND ENTRANT ASSISTANCE STATE/REPLACEMENT DESIGNEE ADMINISTERED PROGRAMS $1,450
93.767 CHILDREN'S HEALTH INSURANCE PROGRAM $509