Finding 514625 (2023-002)

Material Weakness
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2024-12-17

AI Summary

  • Core Issue: There is a significant weakness in internal controls regarding allowable costs for federal grants, with many costs not properly allocated.
  • Impacted Requirements: Compliance with Section 200 of the Code of Federal Regulations, which mandates a consistent and supported cost allocation plan.
  • Recommended Follow-Up: Develop a straightforward cost allocation methodology and maintain documentation for all calculations to ensure compliance.

Finding Text

Finding 2023‐002: Allowable costs – Material weakness over internal controls over compliance and compliance finding. Coronavirus State and Local Fiscal Recovery Funds ALN 21.027. Criteria:  Section  200  of  the  Code  of  Federal  Regulations  requires  recipients  to  have  a  cost  allocation plan in place for allocated costs that is consistently followed and supported. Condition: During allowable cost testing for federal grants, 19 out of 25 samples were not 100% charged to the grant and were not supported by a cost allocation plan for how the percentages charged to the grant were determined. Cause: Turnover in the Organization and lack of knowledge of allocated cost requirements. Recommendation:  In  order  to  comply  with  the  Uniform  Guidance  federal  regulations,  we recommend a cost allocation methodology is put in place that is easy to follow and consistently applied throughout the  year. In addition, support of all calculations should be kept on file to document how the allocation was determined. Management’s response: See corrective action plan.

Corrective Action Plan

Finding Number: 2023-002: Allowable Costs – 19 out of 25 samples were not 100% charged to the grant and were not supported by a cost allocation plan for how the percentages charged to the grant were determined. Planned Corrective Action: We will review and update our existing cost allocation plan to ensure it aligns with current practices. Appropriate staff will receive retraining on the updated plan, and quarterly audits will be implemented to monitor compliance. Any discrepancies will be addressed immediately to prevent future issues. Cost allocation calculations will be kept on file to document how the allocation was determined. Anticipated Completion Date: October 1, 2024 Responsible Contact Person: Tana Rice, Director of Finance

Categories

Allowable Costs / Cost Principles Material Weakness

Other Findings in this Audit

  • 514624 2023-001
    Significant Deficiency
  • 514626 2023-003
    Significant Deficiency
  • 1091066 2023-001
    Significant Deficiency
  • 1091067 2023-002
    Material Weakness
  • 1091068 2023-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $507,308
93.497 Family Violence Prevention and Services/ Sexual Assault/rape Crisis Services and Supports $175,000
16.588 Violence Against Women Formula Grants $92,543
93.991 Preventive Health and Health Services Block Grant $38,119