Finding 525534 (2024-003)

Material Weakness
Requirement
F
Questioned Costs
-
Year
2024
Accepted
2025-03-04

AI Summary

  • Core Issue: The District failed to conduct a required physical inventory of equipment purchased with federal funds, leading to potential asset misappropriation.
  • Impacted Requirements: Non-compliance with 2 CFR § 3474.1 and 2 CFR § 200.313(d) regarding equipment safeguards and inventory reconciliation.
  • Recommended Follow-Up: Implement control procedures for equipment management, including proper tagging and regular inventory checks, especially for assets issued to students.

Finding Text

2 CFR § 3474.1 gives regulatory effect to the Office of Budget and Management Guidance in 2 CFR § 200.313(d) for the Department of Education, which states, in part, that a control system must be in place to ensure safeguards to prevent loss, damage, or theft of the equipment.  It also requires that the recipient or subrecipient maintain property records that include a description of the asset, a serial number or other source of identification (including the FAIN), the source of funding for the property and other data to identify the equipment.  Finally, it requires recipients or subrecipients to perform a physical inventory of property purchased with federal funds and reconcile the inventory results to the recipient or subrecipient’s property records at least once every two years. Due to insufficient knowledge of and controls in place over the federal requirements related to equipment, the District could not provide evidence that a physical inventory over property purchased with Elementary and Secondary School Emergency Relief (ESSER) Fund (AL #84.425D) and American Rescue Plan Elementary and Secondary School Emergency Relief (ARP ESSER) Funds (AL #84.425U) had been taken and reconciled with property records in the required timeframe. In addition, 30 of the 60 property items selected for physical observation were not properly tagged and could not be verified with the District’s property listing provided by management. The District maintains a list of students for which laptops and hot spots are issued, but due to insufficient controls and procedures over the issuance of laptops provided to students we noted, in addition to the 30 errors mentioned above, the District could not provide the property selected for physical observation for 28 of the remaining 60 property items tested prior to the end of the audit. Lack of controls over equipment management and failure to complete the required inventory could lead to misappropriation of District assets and potential questioned costs and non-compliance with federal requirements. We recommend the District establish control procedures over the management of equipment. Controls would include proper tagging of assets and regularly scheduled inventory dates. In addition, the policy should include procedures to ensure District assets under the control of students are regularly inventoried and verified.

Corrective Action Plan

This finding was brought to Management January 16, 2025. It involves significant cross-functional work including, but not limited to, Grants, Procure-to-Pay, Information Technology, Warehouse Operations, and Fine Arts. A group will come together in February 2025 representing these areas to develop a comprehensive action plan. That plan will be shared with the Internal Audit Committee and Board. It will include timelines and responsible parties, which Internal Audit staff will monitor.

Categories

Equipment & Real Property Management

Other Findings in this Audit

  • 525520 2024-001
    Material Weakness
  • 525521 2024-001
    Material Weakness
  • 525522 2024-001
    Material Weakness
  • 525523 2024-001
    Material Weakness
  • 525524 2024-001
    Material Weakness
  • 525525 2024-002
    Material Weakness
  • 525526 2024-002
    Material Weakness
  • 525527 2024-002
    Material Weakness
  • 525528 2024-002
    Material Weakness
  • 525529 2024-002
    Material Weakness
  • 525530 2024-002
    Material Weakness
  • 525531 2024-002
    Material Weakness
  • 525532 2024-002
    Material Weakness
  • 525533 2024-002
    Material Weakness
  • 525535 2024-003
    Material Weakness
  • 525536 2024-003
    Material Weakness
  • 525537 2024-003
    Material Weakness
  • 1101962 2024-001
    Material Weakness
  • 1101963 2024-001
    Material Weakness
  • 1101964 2024-001
    Material Weakness
  • 1101965 2024-001
    Material Weakness
  • 1101966 2024-001
    Material Weakness
  • 1101967 2024-002
    Material Weakness
  • 1101968 2024-002
    Material Weakness
  • 1101969 2024-002
    Material Weakness
  • 1101970 2024-002
    Material Weakness
  • 1101971 2024-002
    Material Weakness
  • 1101972 2024-002
    Material Weakness
  • 1101973 2024-002
    Material Weakness
  • 1101974 2024-002
    Material Weakness
  • 1101975 2024-002
    Material Weakness
  • 1101976 2024-003
    Material Weakness
  • 1101977 2024-003
    Material Weakness
  • 1101978 2024-003
    Material Weakness
  • 1101979 2024-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.010 Title I Grants to Local Educational Agencies $42.74M
10.555 National School Lunch Program $17.91M
84.425 Covid-19 Education Stabilization Fund-Esser $7.92M
10.553 School Breakfast Program $7.27M
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $4.84M
32.009 Covid-19 Emergency Connectivity Fund Program $4.84M
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $2.96M
84.048 Career and Technical Education -- Basic Grants to States $1.48M
84.027 Covid-19 Special Education Grants to States $938,169
10.555 Covid-19 National School Lunch Program $846,148
84.365 English Language Acquisition State Grants $664,832
84.425 Covid-19 Education Stabilization Fund-Arp Esser $635,046
84.196 Education for Homeless Children and Youth $492,198
84.424 Student Support and Academic Enrichment Program $386,131
10.559 Summer Food Service Program for Children $378,218
93.079 Cooperative Agreements to Promote Adolescent Health Through School-Based Hiv/std Prevention and School-Based Surveillance $330,680
84.425 Covid 19 Educational Stabilization Fund-Govenors Emergency Education Relief Programs $302,989
84.173 Special Education Preschool Grants $273,946
93.566 Refugee and Entrant Assistance State/replacement Designee Administered Programs $258,807
84.173 Covid-19 Special Education Grants to States $138,436
10.582 Fresh Fruit and Vegetable Program $121,819
84.041 Impact Aid $35,351
10.575 Farm to School Grant Program $6,848
12.000 JR Rotc Program $4,343
84.027 Special Education Grants to States $428