Finding 1081365 (2024-001)

Material Weakness
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2024-11-07

AI Summary

  • Core Issue: The School District misapplied the approved indirect cost rate for the Title I program, leading to incorrect financial reporting.
  • Impacted Requirements: Compliance with 2 CFR Part 200 guidelines for indirect cost allocation and proper internal controls.
  • Recommended Follow-Up: Conduct a thorough review of indirect cost calculations to prevent future errors and ensure accurate reporting.

Finding Text

Assistance Listing, Federal Agency, and Program Name - 84.010 - Title I Grants to Local Education Agencies Federal Award Identification Number and Year - 231530, 241530 Pass through Entity - Michigan Department of Education Finding Type - Material weakness Repeat Finding - No Criteria - The School District applies the simplified method to determine indirect costs for the Title I program. The allocation of indirect costs and the computation of an indirect cost rate may be accomplished through simplified allocation procedures described in 2 CFR Part 200, Appendix VII, paragraph C.2. The indirect cost rate is approved by the Michigan Department of Education. Condition - The School District did not accurately apply the approved indirect cost rate. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - Proper segregation of duties and review functions are critical key internal control functions to prevent errors or irregularities in financial reporting. The indirect cost allocation for the Title I program included an error in the indirect cost rate applied as identified during the audit. Management reduced the indirect costs charged to the Title I program by $615,547 to correct the error. Cause and Effect - The School District calculated indirect costs using an inaccurate rate. The School District reported indirect costs in excess of the approved rate for the federal program. Recommendation - We recommend that a review of the indirect cost calculations occur to detect errors in the indirect cost rates applied. Views of Responsible Officials and Corrective Action Plan - Management agrees with the finding and is in the process of enhancing procedures.

Categories

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

Other Findings in this Audit

  • 504923 2024-001
    Material Weakness
  • 504924 2024-001
    Material Weakness
  • 1081366 2024-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.063 Federal Pell Grant Program $30.21M
84.268 Federal Direct Student Loans $14.22M
84.010 Title I Grants to Local Educational Agencies $11.51M
10.553 School Breakfast Program - Cash Assistance $1.88M
84.048 Career and Technical Education -- Basic Grants to States $1.73M
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $1.13M
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $1.12M
84.365 English Language Acquisition State Grants $1.02M
84.007 Federal Supplemental Educational Opportunity Grants $950,160
84.424 Student Support and Academic Enrichment Program $543,086
10.555 National School Lunch Program - Cash Assistance $479,656
84.425 Covid-19 - Education Stabilization Fund $434,090
84.002 Adult Education - Basic Grants to States $390,180
10.582 Fresh Fruit and Vegetable Program $272,404
21.027 Coronavirus State and Local Fiscal Recovery Funds $243,018
84.173 Special Education Preschool Grants $203,595
10.559 Summer Food Service Program for Children $199,371
84.033 Federal Work-Study Program $191,192
93.778 Medical Assistance Program $136,320
84.215 Innovative Approaches to Literacy; Promise Neighborhoods; Full-Service Community Schools; and Congressionally Directed Spending for Elementary and Secondary Education Community Projects $65,103
17.285 Registered Apprenticeship $55,845
17.268 H-1b Job Training Grants $47,775
93.860 Emerging Infections Sentinel Networks $38,947
93.310 Trans-Nih Research Support $25,850
10.558 Child and Adult Care Food Program $22,652
17.258 Wioa Adult Program $18,476
84.027 Special Education Grants to States $13,681
84.184 School Safely National Activities $12,000
10.579 Child Nutrition Discretionary Grants Limited Availability $10,000
47.076 Stem Education (formerly Education and Human Resources) $5,221
81.117 Energy Efficiency and Renewable Energy Information Dissemination, Outreach, Training and Technical Analysis/assistance $5,188
10.555 National School Lunch Program - Commodities $2,907
93.859 Biomedical Research and Research Training $1,024
81.U01 Battery Workforce Challenge - Argonne National Labs Subaward $304