Finding 57931 (2022-003)

Significant Deficiency
Requirement
AB
Questioned Costs
-
Year
2022
Accepted
2023-03-15
Audit: 54638
Organization: The City of Oklahoma City (OK)

AI Summary

  • Core Issue: Incorrect pay rates were used for payroll calculations, leading to potential overcharges to disaster grants.
  • Impacted Requirements: Compliance with 2 CFR 200.403(g), which mandates adequate documentation of costs.
  • Recommended Follow-Up: Implement a second review process to ensure payroll expenses reflect the correct pay rates at the time services were rendered.

Finding Text

Finding 2022-003 (Significant Deficiency) AL# 97.036: Disaster Grants ? Public Assistance (Presidentially Declared Disasters), Passed Thru the Oklahoma Department of Emergency Management, U.S. Department of Homeland Security, Award # PA-06-OK-PW-00187, 2022 Condition: There were three instances in which an employee?s pay rate used in calculating payroll expense was the current pay rate and not the pay rate in effect at the time the work was performed. Criteria: 2 CFR 200.403(g) states that costs must be adequately documented. Questioned Costs: Unknown Context: The total amount of expenditures for this federal assistance listing number is $19,546,051 which consists of 7 different grants crossing over 3 different city departments. This error occurred in only one department and one grant which had payroll costs totaling $677,863. A portion of these costs used updated pay rates, instead of pay rates active at the time of service which caused some individual pay dates to be overcharged to the grant. The sample size was determined based upon guidelines provided by the AICPA which is not a statistically valid sample. Cause: Employees received pay increases between the time the service was performed and when costs were identified as being covered by the disaster grant. The pay rate used was the pay rate for those employees at the time the expenditures were identified. Effect: Not properly identifying the appropriate pay rates used in determining payroll expenses may cause the federal program to be overcharged. Recommendation: We recommend when identifying payroll expenditures to be charged to disaster grants that a second review is done to ensure pay rates used to determine payroll expenses are the pay rates in effect at the time the employee provided the service. Views of Responsible Officials (Unaudited): The Parks and Recreation Department will immediately implement a process where the Parks & Grounds Superintendent (or designee) will review employee pay information that administrative staff prepares for entry into the federal grant website ensuring that it is properly formatted and accurately reflects the pay at the time the work was performed. Also, a procedure will be added to the FEMA section of the City's Grants Manual to include a second review to verify that the pay rates being used to determine payroll expenses are the rates that were in effect at the time the service was provided.

Corrective Action Plan

Corrective Action Plan Year Ended June 30, 2022 Finding 2022-003: (Significant Deficiency) AL# 97.036: Disaster Grants - Public Assistance (Presidentially Declared Disasters), Passed Thru the Oklahoma Department of Emergency Management, U.S. Department of Homeland Security, Award# PA-06-OK-PW-00187, 2022 Condition: There were three instances in which an employee's pay rate used in calculating payroll expense was the current pay rate and not the pay rate in effective at the time the work was performed. Criteria or Specific Requirement: 2 CFR 200.403(g) states that costs must be adequately documented. Cause: Employees received pay increases between the time the service was performed and when costs were identified as being covered by the disaster grant. The pay rate used was the pay rate for those employees at the time the expenditures were identified. Effect: Not properly identifying the appropriate pay rates used in determining payroll expenses may cause the federal program to be overcharged. Corrective Action Plan: The City will implement the following steps: 1. The Parks and Recreation Department will immediately implement a process where the Parks & Grounds Superintendent (or designee) will review employee pay information that administrative staff prepares for entry into the federal grant website ensuring that it is properly formatted and accurately reflects the pay at the time the work was performed. 2. A procedure will be added to the FEMA section of the City's Grants Manual to include a second review to verify that the pay rates being used to determine payroll expenses are the rates that were in effect at the time the service was provided. This verification will be documented in the Grants database maintained by the Accounting Services Division.

Categories

Allowable Costs / Cost Principles Significant Deficiency

Other Findings in this Audit

  • 634373 2022-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.248 Community Development Block Grants_section 108 Loan Guarantees $18.83M
21.027 Coronavirus State and Local Fiscal Recovery Funds $12.57M
21.019 Coronavirus Relief Fund $11.29M
20.507 Federal Transit_formula Grants $7.06M
21.023 Emergency Rental Assistance Program $5.95M
59.075 Shuttered Venue Operators Grant Program $5.69M
14.218 Community Development Block Grants/entitlement Grants $3.47M
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $2.62M
66.468 Capitalization Grants for Drinking Water State Revolving Funds $621,930
14.241 Housing Opportunities for Persons with Aids $411,565
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $349,744
14.231 Emergency Solutions Grant Program $327,142
16.922 Equitable Sharing Program $288,406
16.034 Coronavirus Emergency Supplemental Funding Program $261,902
97.U01 Law Enforcement Officer Reimbursement Agreement Program $241,200
14.267 Continuum of Care Program $214,156
16.738 Edward Byrne Memorial Justice Assistance Grant Program $204,954
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $140,401
20.600 State and Community Highway Safety $97,978
16.320 Services for Trafficking Victims $95,319
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $84,377
20.205 Highway Planning and Construction $84,000
20.616 National Priority Safety Programs $78,828
16.575 Crime Victim Assistance $72,401
14.239 Home Investment Partnerships Program $64,641
16.710 Public Safety Partnership and Community Policing Grants $57,958
20.106 Airport Improvement Program $57,000
97.029 Flood Mitigation Assistance $42,140
93.575 Child Care and Development Block Grant $39,000
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $37,875
15.904 Historic Preservation Fund Grants-in-Aid $35,200
66.458 Capitalization Grants for Clean Water State Revolving Funds $19,243
16.741 Dna Backlog Reduction Program $17,953
97.073 State Homeland Security Program (shsp) $9,693
20.525 State of Good Repair Grants Program $8,000
14.276 Youth Homelessness Demonstration Program $7,337
14.269 Hurricane Sandy Community Development Block Grant Disaster Recovery Grants (cdbg-Dr) $4,000
45.310 Grants to States $1,040
97.042 Emergency Management Performance Grants $800
45.129 Promotion of the Humanities_federal/state Partnership $584