Finding 564446 (2022-004)

Significant Deficiency
Requirement
AB
Questioned Costs
-
Year
2022
Accepted
2025-06-11

AI Summary

  • Core Issue: One employee's hours were misallocated, leading to improper charges to the Substance Abuse Prevention and Control program.
  • Impacted Requirements: This violates the cost allocation criteria under § 200.405, which requires accurate assignment of costs to federal awards.
  • Recommended Follow-Up: Management should implement a review process for cost allocations before recording them in the accounting records.

Finding Text

Condition: We selected a sample of payroll cost allocations and tested whether the employees’ time were allocated in accordance with Day One’s cost allocations by program. As a result of our test, we noted that one employee’s hours were did not match the allocation guidelines provided by the Organization and hours were improperly charged to the Substance Abuse Prevention and Control program. Criteria: § 200.405 Allocable costs. (a) A cost is allocable to a particular Federal award or other cost objective if the goods or services involved are chargeable or assignable to that Federal award or cost objective in accordance with relative benefits received. This standard is met if the cost: (1) Is incurred specifically for the Federal award; (2) Benefits both the Federal award and other work of the non-Federal entity and can be distributed in proportions that may be approximated using reasonable methods; and (3) Is necessary to the overall operation of the non-Federal entity and is assignable in part to the Federal award in accordance with the principles in this subpart.Cause: The Organization has not implemented policies and procedures requiring management review the accuracy of the costs allocations to each program prior to being recording in the accounting records. Questioned Costs: $1,282.83 Effect and Context: By improperly allocating payroll costs to the Substance Abuse Prevention and Control-CPS program, the amount of costs reported for this program are overstated at June 30, 2022. Recommendation: We also recommend management review allocation percentages and application of allocations prior to recording the costs in the accounting records. Management’s Response and Corrective Action Plan: See management’s responses documented on page 46-47.

Corrective Action Plan

Management’s Planned Corrective Action: Disagree; There was an error in staff name and not billed to SAPC Substance Abuse Prevention and Control-CPS. Responsible Party: Beaulieu Accountancy Corporation, Accountant Completion Date: 9/25/2024

Categories

Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 564445 2022-003
    Significant Deficiency
  • 564447 2022-003
    Significant Deficiency
  • 1140887 2022-003
    Significant Deficiency
  • 1140888 2022-004
    Significant Deficiency
  • 1140889 2022-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.959 Block Grants for Prevention and Treatment of Substance Abuse $1.00M
93.137 Community Programs to Improve Minority Health $411,543
93.531 Pphf - Community Transformation Grants and National Dissemination and Support for Community Transformation Grants - Financed Solely by Prevention and Public Health Funds $199,995
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $145,987