Finding 588067 (2023-003)

-
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2024-02-05

AI Summary

  • Core Issue: The District overcharged indirect costs to the Education Stabilization Fund by incorrectly applying the indirect cost rate.
  • Impacted Requirements: Compliance with 2 CFR Part 200, which outlines how to calculate modified total direct costs (MTDC) for federal awards.
  • Recommended Follow-Up: The District should create an annual indirect cost worksheet to accurately compute the MTDC before applying indirect cost rates.

Finding Text

U.S. Department of Education Pass-Through Iowa Department of Education Education Stabilization Fund: COVID-19 Elementary and Secondary School Emergency Relief (ESSER II) Fund; COVID-19 Governor’s Emergency Education Relief (GEER II) Fund; COVID-19 ARP-Elementary and Secondary School Emergency Relief (ARP ESSER); COVID-19 ARP-Elementary and Secondary School Emergency Relief-Homeless Children and Youth (ARP-HCY); Finding: The District overcharged indirect costs to the Education Stabilization Fund program. Criteria: The 2 Code of Federal Regulation (CFR) Part 200, Subpart E provides guidance on the provisions of indirect costs. Indirect cost rates are applied to modified total direct costs (MTDC). 2 CFR 200 defines MTDC as: All direct salaries and wages, applicable fringe benefits, materials and supplies, services, travel, and up to the first $25,000 of each subaward (regardless of the period of performance of the subawards under the award). MTDC excludes equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support costs and the portion of each subaward in excess of $25,000. Other items may only be excluded when necessary to avoid a serious inequity in the distribution of indirect costs, and with the approval of the cognizant agency for indirect costs. Condition: The District did not apply the indirect cost rate to the correct modified total direct cost allocation base. The District applied the indirect cost rate to total expenditures of the ESSER II award of the Education Stabilization Fund without first reducing the allocation base by the total indirect costs already included and by the capital outlay object expenditure amounts. Cause: The District does not prepare a calculation of the modified program direct costs before applying the indirect cost rate. Effect: The District could overcharge federal awards for indirect costs. Questioned costs: The District overcharged the program $94,605 computed by applying the unrestricted indirect cost rate provided by the Iowa Department of Education to the modified total direct cost allocation base which excluded the indirect cost journal entry posted by the District and capital outlay object expenditure amounts. Context: The overcharge represents approximately 1 percent of the ESSER II award modified total direct cost allocation base and approximately 0.5 percent of the total Education Stabilization Fund program modified total direct cost allocation base. Identification as a repeat finding: This is not a repeat finding. Recommendation: We recommend the District annually prepare an indirect cost worksheet to compute the modified total direct cost allocation base for all federal awards to apply indirect cost rates. Response and Corrective Action Plan: The District will annually prepare a calculation of the modified total direct cost allocation base for all federal awards before applying the indirect cost rate to federal programs.

Categories

Subrecipient Monitoring Allowable Costs / Cost Principles Period of Performance Equipment & Real Property Management Special Tests & Provisions

Other Findings in this Audit

  • 11612 2023-002
    Significant Deficiency Repeat
  • 11613 2023-003
    -
  • 11614 2023-002
    Significant Deficiency Repeat
  • 11615 2023-003
    -
  • 11616 2023-002
    Significant Deficiency Repeat
  • 11617 2023-003
    -
  • 11618 2023-002
    Significant Deficiency Repeat
  • 11619 2023-003
    -
  • 11620 2023-002
    Significant Deficiency Repeat
  • 11621 2023-003
    -
  • 11622 2023-002
    Significant Deficiency Repeat
  • 11623 2023-003
    -
  • 11624 2023-002
    Significant Deficiency Repeat
  • 11625 2023-003
    -
  • 588054 2023-002
    Significant Deficiency Repeat
  • 588055 2023-003
    -
  • 588056 2023-002
    Significant Deficiency Repeat
  • 588057 2023-003
    -
  • 588058 2023-002
    Significant Deficiency Repeat
  • 588059 2023-003
    -
  • 588060 2023-002
    Significant Deficiency Repeat
  • 588061 2023-003
    -
  • 588062 2023-002
    Significant Deficiency Repeat
  • 588063 2023-003
    -
  • 588064 2023-002
    Significant Deficiency Repeat
  • 588065 2023-003
    -
  • 588066 2023-002
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
10.553 School Breakfast Program $1.80M
84.010 Title I Grants to Local Educational Agencies $1.21M
84.027 Special Education_grants to States $800,541
84.425 Education Stabilization Fund $755,987
84.367 Improving Teacher Quality State Grants $678,205
10.555 National School Lunch Program $626,963
84.424 Student Support and Academic Enrichment Program $328,022
84.048 Career and Technical Education -- Basic Grants to States $300,722
10.582 Fresh Fruit and Vegetable Program $254,896
84.126 Rehabilitation Services_vocational Rehabilitation Grants to States $195,675
10.559 Summer Food Service Program for Children $127,069
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $75,657
84.196 Education for Homeless Children and Youth $47,249
93.575 Child Care and Development Block Grant $29,939
21.027 Coronavirus State and Local Fiscal Recovery Funds $23,087
10.579 Child Nutrition Discretionary Grants Limited Availability $20,624
84.365 English Language Acquisition State Grants $16,843
93.658 Foster Care_title IV-E $3,535