Finding 612785 (2022-002)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2022-10-20

AI Summary

  • Core Issue: The Authority's method for allocating administrative wages to Federal grants is flawed due to incorrect percentage calculations.
  • Impacted Requirements: Internal controls must ensure that costs charged to Federal awards are accurate and comply with cost principles.
  • Recommended Follow-Up: Implement a review process for allocation computations after each time study to confirm accuracy and prevent future errors.

Finding Text

2022-002 Significant Deficiency in Internal Control Department of Housing and Urban Development ""See Schedule of Findings and Questioned Costs for chart/table"" Criteria or specific requirement: The Authority?s system of internal control should provide reasonable assurance that costs of services charged to Federal awards are allowable and in accordance with the applicable cost principles. Condition: The Authority?s computation of costs allocated to the grant for administrative wage was inaccurate. The allocation spreadsheet used to identify the amounts to allocate to the grants erroneously included an incorrect percentage to allocate one individual?s time. Cause: The Authority?s system of internal control is lacking a procedure for verifying the computations of costs allocated to the grant for administrative wages. Effect or Potential Effect: The administrative costs are calculated and charged to the Federal award incorrectly. Questioned Costs: None Context: The Authority?s annual time study is used for allocating administrative payroll costs to the Federal award. The allocation computations are performed on a monthly basis, however not reviewed by another individual. For one employee, the percentage of wages allocated to the grant was entered into the calculation incorrectly, resulting in an incorrect computation for July 2021 through March 2022. Identification as a Repeat Finding: This is not a repeat finding. Recommendation: The Authority should review the setup of the allocation computation after each time study is performed to verify the accuracy of the allocation percentages and mathematical calculations. Views of Responsible Officials: Please refer to the Authority?s corrective action plan.

Categories

Allowable Costs / Cost Principles Significant Deficiency

Other Findings in this Audit

  • 36339 2022-001
    Significant Deficiency Repeat
  • 36340 2022-001
    Significant Deficiency Repeat
  • 36341 2022-001
    Significant Deficiency Repeat
  • 36342 2022-001
    Significant Deficiency
  • 36343 2022-002
    Significant Deficiency
  • 36344 2022-001
    Significant Deficiency
  • 36345 2022-002
    Significant Deficiency
  • 612781 2022-001
    Significant Deficiency Repeat
  • 612782 2022-001
    Significant Deficiency Repeat
  • 612783 2022-001
    Significant Deficiency Repeat
  • 612784 2022-001
    Significant Deficiency
  • 612786 2022-001
    Significant Deficiency
  • 612787 2022-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.239 Home Investment Partnerships Program $4.69M
14.258 Tax Credit Assistance Program (tcap) (recovery Act Funded) $1.17M
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $142,752
14.275 Housing Trust Fund $81,578
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii - Neighborhood Stabilization Program $52,998
14.239 Covid-19 - Home Investment Partnerships Program - (american Rescue Plan Funded) $4,879