Finding 401541 (2023-003)

Significant Deficiency
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2024-06-22

AI Summary

  • Core Issue: Fringe benefits charged to federal grants were based on outdated 2020 budget rates without reconciling to actual 2023 costs.
  • Impacted Requirements: Compliance with cost principles in 2 CFR Part 200, Subpart E was not met, risking excessive charges to federal grants.
  • Recommended Follow-Up: Management should regularly review and update fringe benefit calculations to align billed amounts with actual costs incurred.

Finding Text

Condition: During our testing of federal expenditures, we noted fringe benefits were billed to federal grants based on the Organization’s budgeted 2020 fringe rate with no reconciliation to actual fringe benefits paid during 2023. We consider this instance to be a significant deficiency over compliance relating to allowable costs and the cost principles. Criteria: Expenditures charged to the federal grant must follow the cost principles outlined in 2 CFR Part 200, Subpart E including “Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles.” Cause: Internal billing calculation sheets were not updated for actual 2023 fringe rates and management did not perform reconciliation of budgeted rate to actual paid as the rate being used and charged to the federal awards was included in the grant budgets submitted grantors. Effect: As a result of the deficiency noted, federal grants could be charged in excess of actual expenditures necessary and reasonable to run the programs. Context: A sample of 40 payroll expenditures totaling $62,412, including related fringe benefits of $11,274. For all fringe rates reviewed, the budgeted rates from 2020 were used to determine amounts billed to the grant. Statistical sampling was not used in making sample selections. Recommendation: We recommend management review their calculations of fringe benefits on a periodic basis to ensure the amounts being billed to federal grants are reasonable and in line with actual costs incurred.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 401538 2023-003
    Significant Deficiency
  • 401539 2023-003
    Significant Deficiency
  • 401540 2023-003
    Significant Deficiency
  • 401542 2023-002
    Significant Deficiency
  • 977980 2023-003
    Significant Deficiency
  • 977981 2023-003
    Significant Deficiency
  • 977982 2023-003
    Significant Deficiency
  • 977983 2023-003
    Significant Deficiency
  • 977984 2023-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.218 Community Development Block Grants/entitlement Grants $120,176
16.575 Crime Victim Assistance $89,968
93.136 Injury Prevention and Control Research and State and Community Based Programs $71,940
17.259 Wia Youth Activities $55,578
93.558 Temporary Assistance for Needy Families $48,311
93.497 Family Violence Prevention and Services/ Sexual Assault/rape Crisis Services and Supports $26,054
93.991 Preventive Health and Health Services Block Grant $10,277
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $4,683