Finding 30923 (2022-010)

Material Weakness
Requirement
F
Questioned Costs
-
Year
2022
Accepted
2023-03-30
Audit: 30350
Organization: Northern New Mexico College (NM)

AI Summary

  • Core Issue: The College lacks an equipment listing and has not conducted required physical inventories for federally funded items.
  • Impacted Requirements: Violations of 2 CFR 200.313(d)(2) and 2 CFR 200.303(a) regarding inventory management and internal controls.
  • Recommended Follow-up: Develop and implement policies to track federally funded equipment and ensure physical inventories are conducted every two years.

Finding Text

2022-010 ? Equipment and Real Property Management ? Material Weakness Federal Program Information Funding Agency: Department of Defense, National Science Foundation, Department of Education, Department of Health and Human Services ? National Institute of Health Federal Award Agreement Number: Not Applicable Award Year: Fiscal year 2022 Title: Research and Development Cluster Assistance Listing Number: 12.598, 47.050, 47.076, 84.031, and 93.859 Pass-through Agency: Not Applicable, Direct Program Pass-through Identification Number: Not Applicable, Direct Program Condition - The College was not able to provide an equipment listing tracking items purchased with federal funding nor did the College conduct a physical inventory.Criteria - Per 2 CFR 200.313(d)(2), a physical inventory of program property must be taken and the results reconciled with the property records at least once every 2 years and per 2 CFR 200.303(a) states that the non-Federal entity must 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. Questioned Costs - Not applicable. Effect - The College could dispose of or lose federally funded equipment without following federal guidelines. Cause - The College does not have policies and procedures to ensure that equipment purchases with federal funds is maintained and tracked and that the College performing a physical inventory at a minimum of every two years.

Corrective Action Plan

Auditors? Recommendation - We recommend the College enhance the design of its control activities and policies and procedures should be developed to ensure physical inventories are taken at least once every two years and that they create a tool to assist in tracking and maintaining equipment purchased with federal funds. Views of Responsible Officials and Planned Corrective Action - The College does maintain a listing of inventory purchased with federal funds; however, the inventory was not sufficiently and accurately maintained due to staff turnover. The College is reviewing current policies and will modify those as needed. The College plans to conduct a physical inventory of all capital assets and those assets procured with federal sources. Responsible Official - Denise Montoya, Vice President for Finance & Administration, Theresa Storey, Chief Financial Officer, Scott Stokes, Chief Information Officer, and Josephine Velasquez, Procurement Timeline and Estimated Completion Date - June 30, 2024

Categories

Equipment & Real Property Management

Other Findings in this Audit

  • 30920 2022-011
    Significant Deficiency
  • 30921 2022-012
    Material Weakness
  • 30922 2022-013
    Significant Deficiency
  • 30924 2022-011
    Significant Deficiency
  • 30925 2022-012
    Material Weakness
  • 30926 2022-013
    Significant Deficiency
  • 30927 2022-010
    Material Weakness
  • 30928 2022-011
    Significant Deficiency
  • 30979 2022-012
    Material Weakness
  • 30980 2022-013
    Significant Deficiency
  • 30981 2022-010
    Material Weakness
  • 30982 2022-011
    Significant Deficiency
  • 30983 2022-012
    Material Weakness
  • 30984 2022-013
    Significant Deficiency
  • 30985 2022-010
    Material Weakness
  • 30986 2022-011
    Significant Deficiency
  • 30987 2022-012
    Material Weakness
  • 30988 2022-013
    Significant Deficiency
  • 30989 2022-009
    Significant Deficiency Repeat
  • 30990 2022-009
    Significant Deficiency Repeat
  • 30991 2022-009
    Significant Deficiency Repeat
  • 30992 2022-007
    Material Weakness Repeat
  • 30993 2022-008
    Significant Deficiency
  • 30994 2022-007
    Material Weakness Repeat
  • 30995 2022-008
    Significant Deficiency
  • 30996 2022-007
    Material Weakness Repeat
  • 30997 2022-008
    Significant Deficiency
  • 30998 2022-007
    Material Weakness Repeat
  • 30999 2022-008
    Significant Deficiency
  • 31000 2022-007
    Material Weakness Repeat
  • 31001 2022-008
    Significant Deficiency
  • 37998 2022-010
    Material Weakness
  • 607362 2022-011
    Significant Deficiency
  • 607363 2022-012
    Material Weakness
  • 607364 2022-013
    Significant Deficiency
  • 607365 2022-010
    Material Weakness
  • 607366 2022-011
    Significant Deficiency
  • 607367 2022-012
    Material Weakness
  • 607368 2022-013
    Significant Deficiency
  • 607369 2022-010
    Material Weakness
  • 607370 2022-011
    Significant Deficiency
  • 607421 2022-012
    Material Weakness
  • 607422 2022-013
    Significant Deficiency
  • 607423 2022-010
    Material Weakness
  • 607424 2022-011
    Significant Deficiency
  • 607425 2022-012
    Material Weakness
  • 607426 2022-013
    Significant Deficiency
  • 607427 2022-010
    Material Weakness
  • 607428 2022-011
    Significant Deficiency
  • 607429 2022-012
    Material Weakness
  • 607430 2022-013
    Significant Deficiency
  • 607431 2022-009
    Significant Deficiency Repeat
  • 607432 2022-009
    Significant Deficiency Repeat
  • 607433 2022-009
    Significant Deficiency Repeat
  • 607434 2022-007
    Material Weakness Repeat
  • 607435 2022-008
    Significant Deficiency
  • 607436 2022-007
    Material Weakness Repeat
  • 607437 2022-008
    Significant Deficiency
  • 607438 2022-007
    Material Weakness Repeat
  • 607439 2022-008
    Significant Deficiency
  • 607440 2022-007
    Material Weakness Repeat
  • 607441 2022-008
    Significant Deficiency
  • 607442 2022-007
    Material Weakness Repeat
  • 607443 2022-008
    Significant Deficiency
  • 614440 2022-010
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.063 Federal Pell Grant Program $2.03M
84.425 Covid-19 Higher Education Emergency Relief Fund-Student Aid Portion $1.71M
84.425 Covid-19 Higher Education Emergency Relief Fund-Institutional Portion $1.38M
84.031 Higher Education Institutional Aid $944,439
84.149 Migrant Education College Assistance Migrant Program $416,392
84.141 Migrant Education High School Equivalency Program $378,027
84.047 Trio-Upward Bound $293,217
93.859 Biomedical Research and Research Training $152,114
84.268 Federal Direct Student Loans-Unsubsidized $151,771
84.268 Federal Direct Student Loans-Subsidized $143,289
84.007 Federal Supplemental Education Opportunitygrant $142,902
84.425 Covid-19 Higher Education Emergency Relief Fund-Minority Servinginstitutions Portion $121,532
47.050 Geosciences $85,207
84.066 Trio_educational Opportunity Centers $72,318
84.048 Career and Technical Education -- Basic Grants to States $71,679
84.002 Adult Education - Basic Grants to States $67,633
84.033 Federal Work Study Program $48,682
47.076 Education and Human Resources $16,739
12.598 Centers for Academic Excellence $4,493