Finding 504486 (2024-004)

Material Weakness
Requirement
A
Questioned Costs
$1
Year
2024
Accepted
2024-11-01
Audit: 327038
Organization: Ecorse Public Schools (MI)
Auditor: Yeo & Yeo PC

AI Summary

  • Core Issue: The School District overcharged Title I Grants by $74,789 due to a discrepancy in the fringe benefits rate applied compared to the average rate for the district.
  • Impacted Requirements: Compliance with 2CFR200.431 regarding the allocation of fringe benefits to Federal awards was not met, leading to material noncompliance.
  • Recommended Follow-Up: Implement procedures to ensure fringe benefits are allocated consistently and review all expenditures against the approved budget to identify any discrepancies.

Finding Text

Finding 2024-004: Allowable Activities – Allocable Fringe Benefits Program Name: Title I Grants to Local Educational Agencies – Assistance Listing 84.010 Awarding Agency: U.S. Department of Education, passed through Michigan Department of Education Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: $74,789 Context / Criteria: The School District determines salary and hourly rates based on contractual agreements and other approved rates and charges these expenses to grants in accordance with approved grant agreements. The School District should allocate related fringe benefits such as retirement, payroll taxes and health benefits in a manner consistent with the pattern of benefits attributable to the individuals of employees whose salaries are chargeable to the Federal awards in accordance with 2CFR200.431. Condition: During our payroll testing we noted the School District’s average retirement rate across the School District was 29.05%. However, the rate charged to Title I Grants to Local Educational Agencies was 40.84%, resulting in an estimated overcharge of $74,789. We did not note any major budget overages for Title I Grants to Local Educational Agencies at June 30, 2024, however, the grant period for Title I Grants to Local Educational Agencies ends September 30 each year and budget overages could exist that have not yet been identified based on spending through June 30, 2024. Cause / Effect: The School District did not maintain sufficient procedures to ensure charges for fringe benefits were consistent with fringe benefits for the School District as a whole. The School District may have overcharged Title I Grants to Local Educational Agencies based on the retirement rate used for June 30, 2024. Additionally, the School District did not maintain sufficient procedures to ensure expenses charged to the grant were allowable based on the approved budget which may have allowed the School District to detect the retirement expense difference before it was charged to the Federal award. Recommendation: We recommend the School District maintain a method to allocate Federal awards consistent with the School District as a whole. Additionally, the School District should review all expenditures and compare them to budget to detect any overcharges or undercharges to Federal awards. The School District should ensure the budget used for this comparison agrees to the approved grant budget. Views of Responsible Officials and Corrective Actions: Management agrees with the finding. See accompanying Corrective Action Plan.

Corrective Action Plan

Issue: Allowable Activities - Allocable Fringe Benefits Corrective Action Plan: The district will ensure that retirement rates are updated in the SMART program and that all accounts are charged at a consistent rate.

Categories

Questioned Costs Allowable Costs / Cost Principles Material Weakness Internal Control / Segregation of Duties

Other Findings in this Audit

  • 504485 2024-003
    Material Weakness Repeat
  • 1080927 2024-003
    Material Weakness Repeat
  • 1080928 2024-004
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.010 Title I Grants to Local Educational Agencies $1.28M
10.555 National School Lunch Program $537,590
84.027 Special Education Grants to States $294,945
10.553 School Breakfast Program $262,337
84.425 Education Stabilization Fund $209,190
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $135,572
84.424 Student Support and Academic Enrichment Program $98,067
10.559 Summer Food Service Program for Children $27,321
93.778 Medical Assistance Program $8,944
10.558 Child and Adult Care Food Program $4,711