Finding 504923 (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.

Corrective Action Plan

Condition: 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. 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. Planned Corrective Action: The School District recorded an adjusting journal entry to correct the indirect costs charged in excess of the approved rate charged to the Title I program for the year ended June 30, 2024. In addition, a secondary analytical review will be incorporated over the Budgetary and indirect costs budgeted specifically to grants prior to it being recorded. Contact person responsible for corrective action: Thomas Wall, Executive Director of Business Services and Operations. Anticipated Completion Date: November 1, 2024

Categories

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

Other Findings in this Audit

  • 504924 2024-001
    Material Weakness
  • 1081365 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