Finding 47497 (2022-016)

Material Weakness
Requirement
F
Questioned Costs
-
Year
2022
Accepted
2023-03-30

AI Summary

  • Core Issue: The School Corporation failed to properly manage and document a $14,523 laser machine purchased with federal funds, lacking essential asset details and internal controls.
  • Impacted Requirements: Noncompliance with federal regulations (2 CFR 200.303 and 200.313) regarding equipment management and internal controls, risking future federal funding.
  • Recommended Follow-Up: Management should implement effective internal controls to ensure compliance with grant agreements and maintain accurate asset records.

Finding Text

FINDING 2022-016 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Number and Year (or Other Identifying Numbers): S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation purchased an All Purpose Laser Machine, totaling $14,523, with Education Stabilization Funds. This asset was not added to a detailed listing of capital assets that would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and the use and condition of the property. In addition, a physical inventory had not been taken in the past two years and assets were not properly safeguarded and maintained. 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.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated . . ." Cause Management had not designed nor implemented a system of internal controls that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Corrective Action Plan

FINDING 2022-016 Contact Person Responsible for Corrective Action: Tricia Malone Hudson, District Curriculum Specialist Contact Phone Number: 812-279-3521 Views of Responsible Official: We concur with the audit finding. Description of Corrective Action Plan: The school district will establish a process to ensure compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Anticipated Completion Date: North Lawrence Community Schools will implement this procedure by June 2023.

Categories

Equipment & Real Property Management

Other Findings in this Audit

  • 47451 2022-003
    Material Weakness
  • 47452 2022-004
    Material Weakness
  • 47453 2022-005
    Material Weakness
  • 47454 2022-003
    Material Weakness
  • 47455 2022-004
    Material Weakness
  • 47456 2022-005
    Material Weakness
  • 47457 2022-003
    Material Weakness
  • 47458 2022-004
    Material Weakness
  • 47459 2022-005
    Material Weakness
  • 47460 2022-003
    Material Weakness
  • 47461 2022-004
    Material Weakness
  • 47462 2022-005
    Material Weakness
  • 47463 2022-003
    Material Weakness
  • 47464 2022-004
    Material Weakness
  • 47465 2022-005
    Material Weakness
  • 47466 2022-003
    Material Weakness
  • 47467 2022-004
    Material Weakness
  • 47468 2022-005
    Material Weakness
  • 47469 2022-003
    Material Weakness
  • 47470 2022-004
    Material Weakness
  • 47471 2022-005
    Material Weakness
  • 47472 2022-003
    Material Weakness
  • 47473 2022-004
    Material Weakness
  • 47474 2022-005
    Material Weakness
  • 47475 2022-008
    Material Weakness
  • 47476 2022-006
    Material Weakness
  • 47477 2022-007
    Material Weakness
  • 47478 2022-008
    Material Weakness
  • 47479 2022-006
    Material Weakness
  • 47480 2022-007
    Material Weakness
  • 47481 2022-010
    Material Weakness
  • 47482 2022-011
    Material Weakness
  • 47483 2022-012
    Material Weakness
  • 47484 2022-013
    Material Weakness
  • 47485 2022-014
    Material Weakness
  • 47486 2022-015
    Material Weakness
  • 47487 2022-010
    Material Weakness
  • 47488 2022-011
    Material Weakness
  • 47489 2022-012
    Material Weakness
  • 47490 2022-013
    Material Weakness
  • 47491 2022-014
    Material Weakness
  • 47492 2022-015
    Material Weakness
  • 47493 2022-018
    Material Weakness
  • 47494 2022-018
    Material Weakness
  • 47495 2022-017
    Material Weakness
  • 47496 2022-018
    Material Weakness
  • 47498 2022-017
    Material Weakness
  • 47499 2022-018
    Material Weakness
  • 47500 2022-009
    Material Weakness
  • 47501 2022-009
    Material Weakness
  • 623893 2022-003
    Material Weakness
  • 623894 2022-004
    Material Weakness
  • 623895 2022-005
    Material Weakness
  • 623896 2022-003
    Material Weakness
  • 623897 2022-004
    Material Weakness
  • 623898 2022-005
    Material Weakness
  • 623899 2022-003
    Material Weakness
  • 623900 2022-004
    Material Weakness
  • 623901 2022-005
    Material Weakness
  • 623902 2022-003
    Material Weakness
  • 623903 2022-004
    Material Weakness
  • 623904 2022-005
    Material Weakness
  • 623905 2022-003
    Material Weakness
  • 623906 2022-004
    Material Weakness
  • 623907 2022-005
    Material Weakness
  • 623908 2022-003
    Material Weakness
  • 623909 2022-004
    Material Weakness
  • 623910 2022-005
    Material Weakness
  • 623911 2022-003
    Material Weakness
  • 623912 2022-004
    Material Weakness
  • 623913 2022-005
    Material Weakness
  • 623914 2022-003
    Material Weakness
  • 623915 2022-004
    Material Weakness
  • 623916 2022-005
    Material Weakness
  • 623917 2022-008
    Material Weakness
  • 623918 2022-006
    Material Weakness
  • 623919 2022-007
    Material Weakness
  • 623920 2022-008
    Material Weakness
  • 623921 2022-006
    Material Weakness
  • 623922 2022-007
    Material Weakness
  • 623923 2022-010
    Material Weakness
  • 623924 2022-011
    Material Weakness
  • 623925 2022-012
    Material Weakness
  • 623926 2022-013
    Material Weakness
  • 623927 2022-014
    Material Weakness
  • 623928 2022-015
    Material Weakness
  • 623929 2022-010
    Material Weakness
  • 623930 2022-011
    Material Weakness
  • 623931 2022-012
    Material Weakness
  • 623932 2022-013
    Material Weakness
  • 623933 2022-014
    Material Weakness
  • 623934 2022-015
    Material Weakness
  • 623935 2022-018
    Material Weakness
  • 623936 2022-018
    Material Weakness
  • 623937 2022-017
    Material Weakness
  • 623938 2022-018
    Material Weakness
  • 623939 2022-016
    Material Weakness
  • 623940 2022-017
    Material Weakness
  • 623941 2022-018
    Material Weakness
  • 623942 2022-009
    Material Weakness
  • 623943 2022-009
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.555 National School Lunch Program 22 $1.84M
84.425 Education Stabilization Fund 22 $1.32M
84.027 Special Education_grants to States 22 $975,069
84.425 Education Stabilization Fund 21 $862,480
84.010 Title I Grants to Local Educational Agencies 22 $756,412
84.010 Title I Grants to Local Educational Agencies 21 $756,017
84.027 Special Education_grants to States 21 $625,125
10.553 School Breakfast Program 22 $366,043
84.048 Career and Technical Education -- Basic Grants to States 22 $223,010
84.367 Improving Teacher Quality State Grants 21 $182,695
84.048 Career and Technical Education -- Basic Grants to States 21 $178,359
84.367 Improving Teacher Quality State Grants 22 $173,731
84.424 Student Support and Academic Enrichment Program 21 $136,860
10.555 National School Lunch Program 21 $123,737
93.778 Medical Assistance Program 22 $69,074
93.778 Medical Assistance Program 21 $64,916
10.559 Summer Food Service Program for Children 21 $54,204
84.173 Special Education_preschool Grants 22 $42,315
10.559 Summer Food Service Program for Children 22 $36,540
84.173 Special Education_preschool Grants 21 $35,644
10.553 School Breakfast Program 21 $31,026
84.424 Student Support and Academic Enrichment Program 22 $16,715
10.649 Pandemic Ebt Administrative Costs 22 $3,063