Finding 604939 (2022-004)

Material Weakness
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2023-03-30

AI Summary

  • Core Issue: The School Corporation lacks an effective internal control system, leading to noncompliance with grant requirements for Title I funds.
  • Impacted Requirements: Failure to document payroll calculations and ensure allowable costs as per 2 CFR 200.303, 200.403, and 200.430(i).
  • Recommended Follow-Up: Management should implement a robust internal control system to ensure compliance with grant agreements and cost principles.

Finding Text

FINDING 2022-004 Subject: Title I Grants to Local Educational Agencies - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A190014, S010A200014, S010A210014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Condition and Context An effective internal control system was not developed at the School Corporation to ensure compliance with requirements related to the grant agreement and the Allowable Costs/Cost Principles compliance requirement. The School Corporation approved a salary schedule for bus drivers which included additional compensation based on miles driven for bus drivers who transported preschool students. Each pay period, the Director of Transportation calculated a bus driver's daily pay by adding the approved hourly wage rate times hours worked to the per mile rate times miles driven for the preschool route, if applicable. The School Corporation provided approved timesheets for the bus drivers selected for testing; however, the calculation of the daily pay calculation was not provided for audit. The bus drivers' payroll of $113,486 charged to the Title I grants during the audit period were considered questioned costs. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." Cause Management had not established a system of internal controls that would have ensured compliance with the grant agreement and the Allowable Costs/Cost Principles compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Allowable Costs/Cost Principles compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs Known questioned costs were $113,486 as identified in the Condition and Context. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the grant agreement and the Allowable Costs/Cost Principles compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 28492 2022-003
    Material Weakness
  • 28493 2022-004
    Material Weakness
  • 28494 2022-005
    Material Weakness
  • 28495 2022-006
    Material Weakness
  • 28496 2022-003
    Material Weakness
  • 28497 2022-004
    Material Weakness
  • 28498 2022-005
    Material Weakness
  • 28499 2022-006
    Material Weakness
  • 28500 2022-007
    Material Weakness
  • 28501 2022-008
    Material Weakness
  • 28502 2022-009
    Material Weakness
  • 28503 2022-010
    Material Weakness
  • 28504 2022-007
    Material Weakness
  • 28505 2022-008
    Material Weakness
  • 28506 2022-009
    Material Weakness
  • 28507 2022-010
    Material Weakness
  • 28508 2022-008
    Material Weakness
  • 28509 2022-009
    Material Weakness
  • 28510 2022-010
    Material Weakness
  • 604934 2022-003
    Material Weakness
  • 604935 2022-004
    Material Weakness
  • 604936 2022-005
    Material Weakness
  • 604937 2022-006
    Material Weakness
  • 604938 2022-003
    Material Weakness
  • 604940 2022-005
    Material Weakness
  • 604941 2022-006
    Material Weakness
  • 604942 2022-007
    Material Weakness
  • 604943 2022-008
    Material Weakness
  • 604944 2022-009
    Material Weakness
  • 604945 2022-010
    Material Weakness
  • 604946 2022-007
    Material Weakness
  • 604947 2022-008
    Material Weakness
  • 604948 2022-009
    Material Weakness
  • 604949 2022-010
    Material Weakness
  • 604950 2022-008
    Material Weakness
  • 604951 2022-009
    Material Weakness
  • 604952 2022-010
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund 22 $2.72M
10.555 National School Lunch Program 22 $856,037
84.027 Special Education_grants to States 22 $575,688
84.010 Title I Grants to Local Educational Agencies 21 $534,108
84.010 Title I Grants to Local Educational Agencies 22 $437,588
10.553 School Breakfast Program 22 $253,396
84.027 Special Education_grants to States 21 $204,394
10.559 Summer Food Service Program for Children 21 $148,860
84.425 Education Stabilization Fund 21 $116,185
10.555 National School Lunch Program 21 $101,298
84.367 Improving Teacher Quality State Grants 21 $73,206
84.358 Rural Education 22 $67,261
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) 22 $59,259
10.559 Summer Food Service Program for Children 22 $52,555
93.778 Medical Assistance Program 21 $50,141
84.367 Improving Teacher Quality State Grants 22 $49,417
93.778 Medical Assistance Program 22 $48,994
84.358 Rural Education 21 $47,951
84.424 Student Support and Academic Enrichment Program 21 $38,157
10.553 School Breakfast Program 21 $36,362
84.424 Student Support and Academic Enrichment Program 22 $21,766
84.173 Special Education_preschool Grants 22 $16,499
84.173 Special Education_preschool Grants 21 $16,453
10.558 Child and Adult Care Food Program 22 $7,399
10.558 Child and Adult Care Food Program 21 $5,987
84.334 Gaining Early Awareness and Readiness for Undergraduate Programs 21 $5,000
84.334 Gaining Early Awareness and Readiness for Undergraduate Programs 22 $1,200