Finding 1054754 (2021-006)

Significant Deficiency
Requirement
B
Questioned Costs
$1
Year
2021
Accepted
2024-07-11
Audit: 314981
Organization: City of Compton (CA)

AI Summary

  • Core Issue: The City used incorrect payrates for payroll costs charged to the Coronavirus Relief Fund.
  • Impacted Requirements: This violates federal guidelines on allowable costs, specifically regarding accurate compensation documentation.
  • Recommended Follow-Up: Enhance procedures to double-check payrates for federal award calculations; implementation is planned for April 2024.

Finding Text

2021-006- Incorrect Payrates {SD, NC) Federal Program Title: Federal Catalog Number: Federal Agency: Pass-Through Entity: Federal Award Number and Year: Category of Finding: Coronavirus Relief Fund 21.019 U.S. Department of the Treasury CA Department of Finance N/A-2021 Allowable Costs/Cost Principles Criteria: Title 2, Subtitle A, Chapter II, Part 200, General Provisions for Selected Items of Cost, Section 200.430, Compensation - Personal Services requires that costs of compensation are allowable to the extent that they satisfy specific requirements which in include that the total compensation of individual employees is determined and supported as provided in the Standards for Documentation of Personnel Expenses. The said standards require charges to Federal awards for salaries and wages must be based on records that must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Condition: The City used incorrect payrates when calculating payroll costs charged to the program. Cause: When the City calculated the Fire Department payroll and payroll costs related to Covid Leave, they used a report that reflected payrates that were higher than what the payroll register reported. Effect or Potential Effect: The City overstated the payroll costs charged to the program. Questioned Cost: $32,314 Context: The exception was found in 10 out of 28 employees selected. The questioned cost is the amount projected to the entire population. Statistical Sampling Validity: Samples are haphazardly selected. Repeat of a Prior-Year Finding: No Recommendation: We recommend the City enhance procedures to double check the payrates used when calculating charges to federal awards. Management Response and Corrective Action Plan City's Response: The City concurs with the recommendation. Corrective Action Plan: The City has other eligible costs that were not claimed for this grant that can be used to offset the questioned cost. Procedures are already in place to enhance payrate calculations in the future. Planned Implementation Date: Implemented as of April 2024 Responsible Person(s): City Controller

Categories

Questioned Costs Allowable Costs / Cost Principles Subrecipient Monitoring HUD Housing Programs

Other Findings in this Audit

  • 478306 2021-002
    Material Weakness Repeat
  • 478307 2021-003
    Significant Deficiency
  • 478308 2021-004
    -
  • 478309 2021-005
    -
  • 478310 2021-007
    Significant Deficiency Repeat
  • 478311 2021-008
    Significant Deficiency
  • 478312 2021-006
    Significant Deficiency
  • 1054748 2021-002
    Material Weakness Repeat
  • 1054749 2021-003
    Significant Deficiency
  • 1054750 2021-004
    -
  • 1054751 2021-005
    -
  • 1054752 2021-007
    Significant Deficiency Repeat
  • 1054753 2021-008
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.871 Section 8 Housing Choice Vouchers $8.70M
14.218 Community Development Block Grants/entitlement Grants $1.38M
21.019 Coronavirus Relief Fund (crf) $1.21M
14.248 Section 108 Loans Receivable - Balance at Beginning of Year $522,691
14.248 Section 108 Note Payable - Current Expenditures $506,125
14.871 Cares Act - Supplemental Housing Assistance Payment (hap) $300,953
16.034 Coronavirus Emergency Supplemental Funding Program $149,719
14.239 Home Investment Partnership Program $148,848
14.871 Cares Act -Supplemental Administative Fee Funding $67,493
14.218 Community Development Block Grants/disaster Recovery Grants (drgr) $4,420
14.218 Covid-19-Cdbg - Cv, Cares Act $4,068