Finding 497943 (2023-005)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2024-09-24

AI Summary

  • Core Issue: There is a major compliance finding regarding the allocation of costs to federal awards, repeating a previous issue.
  • Impacted Requirements: Federal regulations require costs benefiting multiple projects to be allocated based on proportional benefit, but current practices lack proper controls and documentation.
  • Recommended Follow-Up: Management should implement procedures and controls for cost allocation, ensuring all allocations are documented, substantiated, and reviewed.

Finding Text

#2023-005 – Major Federal Award Finding – Allocation of Costs Nature of Finding: Compliance Finding – Allowable Costs and Material Weakness in Internal Controls Over Compliance This is a repeat of prior year finding #2022-006. Criteria/Condition: Federal regulations 2 CFR 200.405 provide that costs benefiting two or more projects in proportions that can be easily determined must be allocated to the projects based on the proportional benefit. If proportions cannot be easily determined, the costs may be allocated to the benefitted projects on a reasonable and documented basis. Questioned Costs: Not able to be determined. Identification of How Questioned Costs Were Computed: Of the major program expenditures selected for testing, certain costs charged to the major program appear to be under-allocated, while others appear to be over-allocated to the major program. These matters are not isolated or contained to any particular type of expenditure. There was no meaningful methodology identified to quantify or extend the errors to the population. Cause/Context: Controls were not in place to evaluate the allocation of costs to grants based on proportional benefit provided to each grant. For payroll costs and 1 of the 40 expenditures selected for testing, costs were divided arbitrarily when charged to grants. No documented support for the allocation methodology was present. Effect: Expenditures that involve an allocation of costs between grants are not supported. The lack of controls results in questioned costs as a disproportionate amount of expenditures may be charged to the federal program. Recommendation: We recommend management establish procedures and controls to allocate costs between grants based upon actual costs attributed to the grant and the particular expenditure allowed by the grant. Any such allocations should be supported by activity-level substantiation and be reviewed. Documentation of the allocation methodology, review and approval should be maintained. Views of Responsible Officials and Planned Corrective Actions: MARR will retain a CPA consultant to recommend to management the establishment of procedures and controls to allocate costs between grants based on actual costs attributed to grant and the particular expenditure allowed by the grant. All such allocations will be supported by activity-level substantiation and be reviewed. Documentation of the allocation methodology, review and approval will be maintained in writing.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 497935 2023-004
    Material Weakness Repeat
  • 497936 2023-005
    Material Weakness Repeat
  • 497937 2023-006
    Material Weakness Repeat
  • 497938 2023-007
    Material Weakness Repeat
  • 497939 2023-008
    Material Weakness Repeat
  • 497940 2023-009
    Material Weakness Repeat
  • 497941 2023-010
    Material Weakness Repeat
  • 497942 2023-004
    Material Weakness Repeat
  • 497944 2023-006
    Material Weakness Repeat
  • 497945 2023-007
    Material Weakness Repeat
  • 497946 2023-008
    Material Weakness Repeat
  • 497947 2023-009
    Material Weakness Repeat
  • 497948 2023-010
    Material Weakness Repeat
  • 1074377 2023-004
    Material Weakness Repeat
  • 1074378 2023-005
    Material Weakness Repeat
  • 1074379 2023-006
    Material Weakness Repeat
  • 1074380 2023-007
    Material Weakness Repeat
  • 1074381 2023-008
    Material Weakness Repeat
  • 1074382 2023-009
    Material Weakness Repeat
  • 1074383 2023-010
    Material Weakness Repeat
  • 1074384 2023-004
    Material Weakness Repeat
  • 1074385 2023-005
    Material Weakness Repeat
  • 1074386 2023-006
    Material Weakness Repeat
  • 1074387 2023-007
    Material Weakness Repeat
  • 1074388 2023-008
    Material Weakness Repeat
  • 1074389 2023-009
    Material Weakness Repeat
  • 1074390 2023-010
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.788 Opioid Str $117,344
93.959 Block Grants for Prevention and Treatment of Substance Abuse $35,139