Finding 496753 (2023-003)

Material Weakness
Requirement
AB
Questioned Costs
-
Year
2023
Accepted
2024-09-13

AI Summary

  • Core Issue: There is a material weakness in internal controls over compliance related to fringe benefits calculations.
  • Impacted Requirements: The Cooperative failed to maintain effective internal controls as required by 2 CFR 200.303(a).
  • Recommended Follow-Up: Implement a formal review process for fringe benefit spreadsheets before submission to ensure accuracy.

Finding Text

Department of Homeland Security, State of South Dakota Office of Emergency Management, 97.036, FEMA-DR-4664-SD, FEMA-DR-4440-SD Disaster Grants – Public Assistance Material Weakness in Internal Control over Compliance Activities Allowed or Unallowed, Allowable Costs and Cost Principles Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Cooperative utilized a fringe benefits spreadsheet provided by FEMA and the information was not calculated correctly. Cause: The Cooperative did not formally review the spreadsheet to ensure information was accurate and up to date. Effect: There is a reasonable possibility that the Cooperative could have failed to identify any errors located within the fringe benefit spreadsheet. Questioned Costs: No questioned costs over $25,000. Context/Sampling: A nonstatistical sample of 60 transactions were selected for testing, which accounted for $1,063,076 out of $1,784,924 total federal program expenditures of which $1,338,693 were submitted for reimbursement. Repeat Finding form Prior Year: No Recommendation: We recommend the Cooperative review procedures surrounding fringe benefits to ensure the process includes a formal review of the spreadsheets prior to submission to the federal agency. Views of Responsible Officials: Management agrees with the finding.

Corrective Action Plan

Federal Agency Name: Department of Homeland Security Program Name: Disaster Grants – Public Assistance Federal Financial Assistance Listing #97.036 Finding Summary: The Cooperative utilized a fringe benefit spreadsheet provided by FEMA where the information was not calculated correctly. Responsible Individuals: Jeff Birkeland, CEO Corrective Action Plan: The spreadsheet we received from FEMA was protected and we could not verify formulas or make changes. We assumed the spreadsheet to work correctly. Through the audit, however, we found that there is an error in a formula(s) having to do with overheads. We will ensure we are using the most up-to-date spreadsheet for fringe benefits on FEMA projects going forward. Anticipated Completion Date: This has been resolved and Steph went back through and updated the spreadsheets accordingly in August 2024

Categories

Allowable Costs / Cost Principles Cash Management Material Weakness

Other Findings in this Audit

  • 496752 2023-002
    Material Weakness
  • 1073194 2023-002
    Material Weakness
  • 1073195 2023-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $1.34M