Finding 45936 (2022-006)

Significant Deficiency
Requirement
F
Questioned Costs
-
Year
2022
Accepted
2023-05-29

AI Summary

  • Core Issue: The district failed to record $92,555.68 worth of equipment purchased with federal grant funds in the subsidiary equipment records.
  • Impacted Requirements: This oversight violates both federal regulations (2 CFR 200.313) and state guidelines for tracking and verifying fixed assets.
  • Recommended Follow-Up: The district must adhere to established policies for recording and safeguarding federally funded equipment to prevent misuse.

Finding Text

Finding 2022-006. Equipment Management. (ALN 84.010 Title I grants to local educational agencies; ALN 84.424 Student support and academic enrichment grants, and ALN 84.425U ARP ESSER III) CRITERIA: 2 CFR 200.313(d)(1) requires for federal grants that 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, the acquisition date, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Since the State of Mississippi has more stringent criteria for tracking equipment inventory, the district must follow the following guidelines for equipment purchased with federal funds. Code Section 37-17-6(18) requires that the State Board of Education, acting through the Commission on School Accreditation, shall require each school district to comply with standards established by the State Department of Audit for the verification of fixed assets and the auditing of fixed assets records as a minimum requirement for accreditation. The State Department of Audit has issued an asset management manual to be used as a standard for verification of fixed assets. The school board has policies and procedures outlining the control and verification of fixed assets within the school district. As part of the asset management manual and local board policy, the district is charged with tracking assets meeting certain thresholds and performing physical verification of those assets at least annually. CONDITION: During our testing, we noted various pieces of equipment purchased with grant dollars totaling $92,555.68 that had not been added to the district?s subsidiary equipment records at the time of audit fieldwork. None of the purchased equipment met the threshold for depreciation; however, all the equipment met the threshold and criteria for tagging and inclusion in the subsidiary equipment records. These purchases were spread over three different federal grants as follows: ALN 84.010 Title I grants to local education agencies - $14,491.39 ALN 84.424 Student support and academic enrichments grants - $40,872.29 ALN 84.425U ARP ESSER III - $37,192.00 The school district stated that even though the equipment had not been added to the subsidiary records at the time of audit fieldwork, all equipment had been properly tagged. A physical inventory performed at the end of the 2021-2022 year would not have included all assets purchased during the 2021-2022 year because of the assets that had not been added to the inventory records at the time of purchase and tagging, therefore a year end inventory would have been incomplete. Our testing of the physical existence of selected fixed asset items revealed three (3) instances where assets appropriately included in the inventory records were not found at the time of testing. The three (3) assets not located were two (2) chromebooks and one (1) ipad with an original combined purchase price of $1,249.43. The assets were purchased from the following federal grant: ALN 84.425U ARP ESSER III - $1,249.43 CAUSE: The school district personnel failed to follow established policies for the recording of purchased equipment meeting the criteria for inclusion in equipment subsidiary records to the subsidiary records. EFFECT: The effect is a breakdown in controls surrounding the safeguarding of equipment purchased with federal dollars. Equipment purchased for use in the federal program could be used for purposes not related to the program or converted to personal use. QUESTIONED COSTS: None RECOMMENDATION: The district should follow established policies and procedures outlining the safeguarding of equipment purchased with federal grant dollars. VIEWS OF RESPONSIBLE OFFICIALS: See the school district?s response in the auditee?s corrective action plan in this report.

Corrective Action Plan

District Response: A. What corrective action will be taken: District will review and follow policies and procedures outlining safeguarding equipment purchased with federal grant dollars. B. Who is responsible (name and position): Nathan Wells, Technology and Fixed Assets Clerk C. When will the plan be implemented? Corrective action started May 5, 2023, and will continue.

Categories

Equipment & Real Property Management

Other Findings in this Audit

  • 45934 2022-003
    Significant Deficiency
  • 45935 2022-004
    Significant Deficiency
  • 45937 2022-003
    Significant Deficiency
  • 45938 2022-004
    Significant Deficiency
  • 45939 2022-003
    Significant Deficiency
  • 45940 2022-006
    Significant Deficiency
  • 45941 2022-003
    Significant Deficiency
  • 45942 2022-004
    Significant Deficiency
  • 45943 2022-003
    Significant Deficiency
  • 45944 2022-004
    Significant Deficiency
  • 45945 2022-003
    Significant Deficiency
  • 45946 2022-004
    Significant Deficiency
  • 45947 2022-005
    Significant Deficiency
  • 45948 2022-006
    Significant Deficiency
  • 622376 2022-003
    Significant Deficiency
  • 622377 2022-004
    Significant Deficiency
  • 622378 2022-006
    Significant Deficiency
  • 622379 2022-003
    Significant Deficiency
  • 622380 2022-004
    Significant Deficiency
  • 622381 2022-003
    Significant Deficiency
  • 622382 2022-006
    Significant Deficiency
  • 622383 2022-003
    Significant Deficiency
  • 622384 2022-004
    Significant Deficiency
  • 622385 2022-003
    Significant Deficiency
  • 622386 2022-004
    Significant Deficiency
  • 622387 2022-003
    Significant Deficiency
  • 622388 2022-004
    Significant Deficiency
  • 622389 2022-005
    Significant Deficiency
  • 622390 2022-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.010 Title I Grants to Local Educational Agencies $872,090
84.425 Education Stabilization Fund $473,013
84.367 Improving Teacher Quality State Grants $141,880
84.424 Student Support and Academic Enrichment Program $74,281
10.555 National School Lunch Program $57,740
84.027 Special Education_grants to States $21,998
84.358 Rural Education $16,904
10.559 Summer Food Service Program for Children $7,637
84.377 School Improvement Grants $5,568
10.560 State Administrative Expenses for Child Nutrition $3,022
84.173 Special Education_preschool Grants $1,976
96.001 Social Security_disability Insurance $336