Finding 586674 (2023-006)

Material Weakness
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2024-01-26
Audit: 13892
Organization: Elk Rapids Schools (MI)

AI Summary

  • Core Issue: The School District failed to maintain necessary time and effort records for two employees charged to a federal award, leading to potential unsupported salary costs.
  • Impacted Requirements: This finding violates federal regulations requiring accurate documentation of work performed for salary and wage charges under CFR Title 2, Part 200 Section 200.430.
  • Recommended Follow-Up: Implement time and effort documentation practices, such as semi-annual certifications or weekly timecards, and review employee allocations to ensure compliance with federal requirements.

Finding Text

Finding Number 2023-006 Assistance Listing Number 84.425 - Education Stabilization Fund Allowable Costs/Cost Principles - Documentation of Employee Time and Effort Material Weakness in Internal Control over Compliance Material Noncompliance Criteria: Per Federal regulations CFR Title 2, Part 200 Section 200.430 (i)(1), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. Condition: The School District did not maintain time and effort distribution records for two employees whose salaries, wages and benefits were charged to the federal award program. Cause: Accounting department turnover lead to incomplete record keeping and lack of knowledge on the federal requirement requiring accounting records to support salary, wage and benefit allocations. Effect: As a result of this condition, salaries, wages and benefits may be charged to the federal award program that are not supported by time and effort distributions. Questioned Costs: Known questioned costs are $77,244, and likely questioned costs are $130,610. Context: This finding relates to two employees whose salary, wages and benefits are charged 100% to this federal award program, however, the School District simply did not obtain an after-the-fact determination of their time and effort in accordance with the federal requirements. Recommendation: Salaries, wages and benefits allocations must be supported by time and effort documentation. This can be accomplished by obtaining semi-annual certifications, personal activity reports or weekly timecards from employees. We recommend management review employee allocations to ensure an after-the-fact determination of actual time spent is obtained from all employees charged to federal award programs.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 10231 2023-006
    Material Weakness
  • 10232 2023-006
    Material Weakness
  • 10233 2023-006
    Material Weakness
  • 586673 2023-006
    Material Weakness
  • 586675 2023-006
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $161,202
84.010 Title I Grants to Local Educational Agencies $137,483
21.027 Coronavirus State and Local Fiscal Recovery Funds $45,792
10.553 School Breakfast Program $40,498
84.367 Improving Teacher Quality State Grants $23,800
84.173 Special Education_preschool Grants $19,276
10.559 Summer Food Service Program for Children $6,032
93.778 Medical Assistance Program $4,640
10.185 Local Food for Schools $3,680
84.424 Student Support and Academic Enrichment Program $2,950
10.555 National School Lunch Program $2,757
10.649 Pandemic Ebt Administrative Costs $628